Saturday, October 19, 2019

Steel Beam Excel Calculations (Download For Free)







File Size: 663 Kb

This spreadsheet performs an analysis and design of simply supported and cantilever, steel beams bending about their X-X axis and subjected to gravity loads. Beams can be either with full restraint or without full restraint.



Design is in accordance with BS 5950-1:1990. Bending moments, shear forces and deflections are computed at 1/60th positions along the span and the maximums of these values are used for the design. The equations for the analysis have been obtained from the Reinforced Concrete Designer's Handbook by Reynolds and Steedman. Self weight of the steel section is automatically included in the calculations. The moment capacity of the section is calculated taking into account the corresponding shear force and a reduction is made as necessary. A check is made to see if a shear bucking calculation is required and a warning is issued. This spreadsheet also contains a calculation sheet for checking local web bearing and buckling.



The spreadsheet uses UK steel section properties which have been directly obtained from the Corus Construction Manual, released on CD in February 2000. The values were imported into Microsoft Excel v8.0 from the html tables contained on the Corus CD. No typing in of values has been carried out and therefore these tables should accurately reflect the tables as published by Corus.





1. Not Full Restraint
2. Full Restraint
3. Cantilever
4. Web Bearing Bucking Design
5. Factor For Lateral Torsional Buckling
6. Notes
7. About Steel Beam
8. Other
9. Universal Beams to B S4 Part-1 1993 - Dimensions & Properties
10. Universal Columns to B S4 Part-1 1993 - Dimensions & Properties
11. Joists to B S4 Part-1 1993 - Dimensions & Properties
12. Parallel Flange Channels - Dimensions and Properties







Download Drive-1











You May Also Like These E-Books:-

No comments:

Post a Comment