Disclaimer: The Engineering Tools provided have been checked, but, that being said, WikiEngineer is not able to guarantee the complete accuracy of all these works. Therefore it is important for everyone to do their due diligence to make sure that all works are complete and accurate. If any mistakes are found they will be added to the Addendum portion you will find under each spreadsheet. Also, if a new version is uploaded the version will change (all versions will start at v1.0 and update accordingly). It is up to you to do your own research and make certain that you have reviewed the spreadsheet you're using and that you are using the most up-to-date spreadsheet available |
What does the Doubly Symmetric Steel Flexural Spreadsheet solve?
This spreadsheet will find the flexural capacity of a Doubly Symmetric I-Shaped Member bend around it's major axis. It is solved using ASD? loads.
This spreadsheet checks for:
- To see if the web and flange are compact
- Find the beams Yield Strength
- Lateral Torsional Buckling (which occurs in compact sections and non-compact sections)
- Flange Local Buckling (which occurs in non-compact sections)
How to Understand this Spreadsheet | |||||||||||||
Where to download?
How to use this Spreadsheet:
''This spreadsheet works in Microsoft Excel 2003 and later. This spreadsheet will solve for Lateral Torsional Buckling it will check to make sure that the steel section is compact and it will check to see if the flange has local buckling? (which only occurs in non-compact sections).
The top portion of the spreadsheet allows you to change your inputs:
Fig. 1: Spreadsheet Inputs
where:
t_{f} = thickness of the flange (inches)
S_{x} = Section Modulus? of the beam about the strong axis of the cross section (in^{3})
Z_{x} = The Plastic Section Modulus in the x or strong axis. Z_{x} is similar to the Section Modulus of a member (it is usually a minimum of 10% greater than the Section Modulus) (in^{3})
r_{y} = The radius of gyration? about the weak axis of the cross section
r_{ts}^{2} = \frac{\sqrt{I_yC_w}}{S_x} = \frac{I_yh_O}{2S_x}
h_{O} = distance between flange centroids = d - t_{f} (in)
J = torsional constant (in^{4})
C_{w} = warping constant (in^{6})
C_{b} = Beam bending Coeeficient
L_{b} = Unbraced Length (bracing must resist displacement of the compression flange or twisting of the cross section)
F_{y} = The yield strength of the steal beam (e.g. A36 has a yield strength of 36 ksi)
E = The modulus of elasticity of the steel beam (e.g. 29000 ksi)
Note: For standard doubly symmetric I-shapes: r_{ts}, r_{y}, J, S_{x}, h_{O}, I_{y}, C_{w}, and most of the other variables can all be found in Table 1 of the AISC 360 Steel Construction Manual^{[1]}. This makes these calculations much easier.
The next section will check to see if the beam's flange and web are compact.
Fig. 2: Check to see if the beam is compact
If required (L_{b} > L_{p}), the third section will find whether or not the beam is in the inelastic or elastic LTB zone and reduce the flexural strength of the beam.
Fig. 3: Check to see if the beam is undergoing Lateral Torsional Buckling
If required (the flange is not compact), the next section will solve for flange local buckling? in the beam.
Fig. 4: Does the Flange have Local Buckling Problems (non-compact only)
Finally, the spreadsheet will provide you the Results Summary which gives you the allowable flexural strength of the beam
Fig. 5: Spreadsheet Results
Notes:
The following notes must be considered when using this spreadsheet:
- For doubly symmetric I-shaped members bent about their major axis
- Designed using the AISC 13th edition (AISC 360 specifications)
- See chapter F in the specifications for complete details
- Table B4.1 in the Specifications (AISC 360) has also been referenced to find λ_{p} & λ_{r}. And also to find out if the beams flange & web are compact.
- Most of the required variables to solve the above complex equations (for standard sized beams) can be found in Table 1 of the manual.
Addendum
- V1.0: This is the original version of the column stability factor spreadsheet (designed by A. Cabico)
- V1.1: Corrected an error in calculating L_{r} (an extra square was present in the equation)