Steel Beam (Historical Sections) Analysis Spreadsheet to BS 5950
Very useful spreadsheet for checking existing steel structures. It has a library of BSB and RSC steel sections which were used in UK and overseas since 1932. Back then section names and properties were expressed in inches and pounds. The spreadsheet gives properties in imperial units and converts these to metric units for analysis. Calculations are based on BS 5950 which is a common approach unless you are familiar with CP113 1948. When analysing historical sections it is very important to choose appropriate allowable stresses, reference should be made to Historical Structural Steelwork Handbook by W. Bates or similar literature.
- A clear and easy to read output (all on a single page);
- Quick summary of utilization factors;
- User can change design strength of steel (derived from allowable stresses);
- Supported steel sections: BSB, RSC;
- Analyse for Lateral Torsional Buckling (LTB) based on effective length;
- Loading options: UDL, 2x Partial UDL, 2x Point Load;
- 'Live' Loading diagram;
- Change between deflection for Dead Load + Imposed Load or Imposed Load only;
- Changeable safety factors;
- Analysis is based on British Standard (BS 5950:1 2000).
(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
Be the first to leave a comment...
To run the Single-User or the Company Licensed version of this spreadsheet you require:
- Microsoft Windows Excel version 2007 to 2016;
Contact me if you want to use this spreadsheet on MAC.
Technical Advice: If you have enabled macros and still cannot use the drop-down menu to change steel beam size then it is probably because of a faulty Windows Update. Solution HERE.