Dimensiones y propiedades de perfiles de Acero AISC (Planilla Excel)

Esta es una planilla Excel para ingenieros civiles que contiene una base de datos con las dimensiones y propiedades de perfiles de acero (secciones de acero), el autor de esta Hoja Excel es Alex Tomanovich, a quien damos todo el crédito y agradecimiento respectivo. Las propiedades y dimensiones de los perfiles de esta base de datos fueron obtenidas de la base de datos (CD-ROM Versión 12/2005) del Manual de Construcción de Acero AISC Edición 13 (12/2005).

Esta herramienta esta en inglés y es de uso fácil, estamos seguros que comprenderán su sencillo funcionamiento y significados.

Los perfiles y secciones de acero cuyas propiedades se muestran en la planilla Excel con los siguientes:

– Perfiles W, S, M, HP

– Perfiles C, MC

– Perfiles WT, ST, MT

– Perfil Angular

– Perfil Angular Doble

– Perfil Rectangular HSS

– Perfil circular HSS y Tubular

– Placas, Planchas de acero

** Se muestran las propiedades de todos los perfiles.

La nomenclatura y significado, de las dimensiones y propiedades de perfiles de Acero

Las definiciones estan en inglés y se detallan a continuación:

A =         Cross-sectional area of member (in.^2)
d =         Depth of member, parallel to Y-axis (in.)
h =         Depth of member, parallel to Y-axis (in.)
tw =       Thickness of web of member (in.)
bf =        Width of flange of member, parallel to X-axis (in.)
b =         Width of member, parallel to X-axis (in.)
tf =         Thickness of flange of member (in.)
k =          Distance from outer face of flange to web toe of fillet (in.)
k1 =       Distance from web centerline to flange toe of fillet (in.)
T =          Distance between fillets for wide-flange or channel shape = d(nom)-2*k(det) (in.)
gage =  Standard gage (bolt spacing) for member (in.)
Ix =        Moment of inertia of member taken about X-axis (in.^4)
Sx =       Elastic section modulus of member taken about X-axis (in.^3)
rx =        Radius of gyration of member taken about X-axis (in.) = SQRT(Ix/A)
Iy =        Moment of inertia of member taken about Y-axis (in.^4)
Sy =       Elastic section modulus of member taken about Y-axis (in.^3)
ry =        Radius of gyration of member taken about Y-axis (in.) = SQRT(Iy/A)
Zx =       Plastic section modulus of member taken about X-axis (in.^3)
Zy =       Plastic section modulus of member taken about Y-axis (in.^3)
rts =       SQRT(SQRT(Iy*Cw)/Sx) (in.)
xp =       horizontal distance from designated member edge to plastic neutral axis (in.)
yp =       vertical distance from designated member edge to plastic neutral axis (in.)
ho =       Distance between centroid of flanges, d-tf (in.)
J =          Torsional moment of inertia of member (in.^4)
Cw =      Warping constant (in.^6)
C =         Torsional constant for HSS shapes (in.^3)
a =          Torsional property, a = SQRT(E*Cw/G*J) (in.)
E =          Modulus of elasticity of steel = 29,000 ksi
G =         Shear modulus of elasticity of steel = 11,200 ksi
Wno =  Normalized warping function at a point at the flange edge (in.^2)
Sw =      Warping statical moment at a point on the cross section (in.^4)
Qf =       Statical moment for a point in the flange directly above the vertical edge of the web (in.^3)
Qw =     Statical moment at the mid-depth of the section (in.^3)
x(bar) =               Distance from outside face of web of channel shape or outside face of angle leg to Y-axis (in.)
y(bar) =               Distance from outside face of outside face of flange of WT or angle leg to Y-axis (in.)
eo =       Horizontal distance from the outer edge of a channel web to its shear center (in.) = (approx.) tf*(d-tf)^2*(bf-tw/2)^2/(4*Ix)-tw/2
xo =       x-coordinate of shear center with respect to the centroid of the section (in.)
yo =       y-coordinate of shear center with respect to the centroid of the section (in.)
ro(bar) =             Polar radius of gyration about the shear center = SQRT(xo^2+yo^2+(Ix+Iy)/A) (in.)
H =         Flexural constant, H = 1-(xo^2+yo^2)/ro(bar)^2)
LLBB =   Long legs back-to-back for double angles
SLBB =  Short legs back-to-back for double angles
h(flat) =               The workable flat (straight) dimension along the height, h (in.)
b(flat) =               The workable flat (straight) dimension along the width, b (in.)
A(surf) =             The total surface area of a rectangular or square HSS section (ft.^2/ft.)
STD =    Standard weight (Schedule 40) pipe section
XS =       Extra strong (Schedule 80) pipe section
XXS =    Double-extra strong pipe section

Esperamos que esta planilla Excel con la base de datos de las dimensiones y propiedades de perfiles de acero sea de utilidad para todas las personas interesadas en temas de ingeniería civil, no olviden dejarnos sus comentarios y opiniones.

Descarga desde GoogleDrive: Aquí