This Spreadsheet performs 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 full restrain or without full restraint.
The design is in accordance with BS 5950-1.990. Bending moments, shear forces and deflection are computed at a 1/60th position along the span and the maximum of these value 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 buckling 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 Construction Manual.