047 Angle Iron data calculator.xls - engineering and design

Document Sample
047 Angle Iron data calculator.xls - engineering and design Powered By Docstoc
					                                                                                           c13caeab-2086-40f0-83e6-5b0e4ae26116.xls 6/6/2013 pg. 1 of 2


         Angle Iron Data Calculator
         Ignores radiuses at leg ends and intersection of legs
         Enter data only in the 3 indicated cells, all other cells are calculated

>>>>>>         2 Longer leg, or equal leg
>>>>>>       1.5 Shorter leg, or equal leg
>>>>>>    0.125 thickness

                                                         distance    centroid
                                                         to most     distance
                                                         extreme     to edge
                        I       S         r                fiber       axis
         X-X        0.173075 0.12524 0.64051             1.381944    0.618056   X-X is parallel to the Shorter or equal leg
         Y-Y        0.084696 0.074824 0.448065           1.131944    0.368056   Y-Y is parallel to the Longer or equal leg
         Z-Z        0.044735 0.059789 0.325636           0.748213       n/a     Z-Z is the weak principal axis
         W-W        0.213037 0.153692 0.710617           1.386124       n/a     W-W is the strong principal axis

          1.375    a = b-t
             1.5   b, Shorter or Equal leg, outside edge along X axis, total length
          1.875    c = d-t
               2   d, Longer or Equal leg, outside edge along Y axis, total length
          0.125    t, thickness, both legs must have same thickness for this calculator
          0.422    Area total = t * (a+d)

           0.25 cx1= d*t, area                                                            theta = rotation of the principal axes from the X Y axes
              1 cx2= d/2, center of d*t relative to X axis                                  -0.07161 K, product of inertia = - (a*b*c*d*t)/(4*(b+c))
          0.172 cx3= a*t, area                                                             1.620626 tan 2 theta =(2*K)/(Iy-Ix)
          0.063 cx4= t/2, center of a*t relative to X axis                                 0.508969 theta (radians) = (1/2)*arctan(tan 2 theta)
          0.618 y, centroid X-X distance from X axis                                       29.16176 theta (degrees)
                y = ((cx1*cx2)+(cx3*cx4))/(cx1+cx3)                                        0.558006 tan theta (frequently tabulated, not needed here)
          1.382 X-X axis distance to most extreme fiber = d-y

          0.188 cy1= b*t, area
           0.75 cy2= b/2, center of b*t relative to X axis
          0.234 cy3= c*t, area                                                            necessary additional calculations to determine Sz and Sw
          0.063 cy4= t/2, center of c*t relative to X axis
          0.368 x, centroid Y-Y distance from Y axis                                                angles
                x = ((cy1*cy2)+(cy3*cy4))/(cy1+cy3)                                       degrees radians
          1.132 Y-Y axis distance to most extreme fiber = b-x                              29.16176 0.50897     E = theta
                                                                                           60.83824 1.06183     F = pi/2 - E
          0.173    Ix = (1/3)*(t*(d-y)^3 +b*y^3-a*(y-t)^3)                                            N/A       G+H+J = E
          0.085    Iy = (1/3)*(t*(b-x)^3 +d*x^3-c*(x-t)^3)                                 9.975127 0.1741      G = E-(H+J)
          0.045    Iz = Ix*sin(theta)^2+Iy*cos(theta)^2+K*sin(2*theta)                     4.938369 0.08619     H = arccos((h^2+g^2-t^2)/(2*h*g))
          0.213    Iw = Ix*cos(theta)^2+Iy*sin(theta)^2-K*sin(2*theta)                                N/A       F+J = arccos((x^2+h^2-(d-y)^2)/(2*x*h))
                                                                                           14.24827 0.24868     J = arccos((x^2+h^2-(d-y)^2)/(2*x*h))-F
          0.641    rx = sqrt ( Ix/A )                                                      30.77404 0.53711     P= arctan (x/y)
          0.448    ry = sqrt ( Iy/A )                                                      5.097968 0.08898     U = arccos((f^2+e^2-t^2)/(2*f*e))
          0.326    rz = sqrt ( Iz/A )                                                                 N/A       Q+E = arccos((e^2+y^2-(b-x)^2)/2*e*y)
          0.711    rw = sqrt ( Iw/A )                                                      32.20315 0.56205     Q = arccos((e^2+y^2-(b-x)^2)/(2*e*y))-E
                                                                                                      N/A       Q+U+V = pi/2 - E
          0.125 Sx = Ix / (d-y)                                                            23.53711 0.4108      V=(pi/2 -E)-(Q+U)
          0.075 Sy = Iy / (b-x)
                                                                                                     lengths
          0.461    m = Longer or equal leg, extreme fiber to Z-Z axis                                 1.28969   e = sqrt(y^2+(b-x)^2)
          0.623    p = heel to Z-Z axis                                                               1.23467   f = sqrt((y-t)^2+(b-x)^2)
          0.748    q = Shorter or equal leg, extreme fiber to Z-Z axis                                1.40316   g = sqrt((d-y)^2+(x-t)^2)
          0.748    largest distance Z-Z axis to most extreme fiber                                    1.43012   h = sqrt((d-y)^2+x^2)
           0.06    Sz = Iz / largest distance Z-Z axis to extreme fiber                               0.71935   j = sqrt(y^2+x^2)
                                                                                                      0.46114   m = g sin(H+J)
          1.386    u = Longer or equal leg, extreme fiber to W-W axis                                 0.62257   p = j sin (P+E)
          1.091    v = Shorter or equal leg, extreme fiber to W-W axis                                0.74821   q = f sin(Q+U)
          1.386    largest distance W-W axis to most extreme fiber                                    1.38612   u = h sin(F+G+H)
          0.154    Sw = Iw / largest distance W-W axis to extreme fiber                               1.09129   v = e sin (U+V+E)
c13caeab-2086-40f0-83e6-5b0e4ae26116.xls 6/6/2013 pg. 2 of 2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:6/5/2013
language:Unknown
pages:2