Steel Stairs Design Spreadsheet to BS 5950-1
|
A powerful and comprehensive spreadsheet for design of steel stairs. It covers design of flat plate stair stringers in bending plus compression; design of chequer plate treads (other types can be selected but design is not covered), and vibration check of stringers. Spreadsheet considers two load combinations to account for the requirements of BS 6399-1, i.e. UDL dead plus UDL imposed load; and UDL dead load plus PL imposed load. Vibration check can be done either based on simplified or rigorous equations for natural frequency.
This spreadsheet was specially developed for Windows and Mac users.
- Clear and easy to read output (all on a single page);
- Quick summary of utilization factors; - Covers ULS and SLS checks of steel flat plate stair stringers. Design is based on Class 3 sections as per SCI AD310 guidance. However, user can specify limiting width-to-thickness ratio; - Comprehensive design of flat plate stringers covers the following checks: bending moment, buckling moment, compression resistance, bending plus compression, buckling plus compression. For instances where maximum bending moment does not coincide with location of maximum compression, user has the option to specify percentage of maximum compression force that is to be considered in conjunction with maximum bending moment. - Spreadsheet includes deflection and vibration check of stringers. The latter checks natural frequency against a user specified threshold. Simplified or rigorous equations for calculating natural frequency can be used; - Covers ULS and SLS checks of chequer plate treads. Other types of treads can be selected from dropdown menu, but these are not checked. This includes extended metal grating, flat bar grating, LCC cast iron, open mesh grating, and pressed steel treads; - Considers two load combinations to account for different stair loading requirements in BS 6399-1: UDL dead plus UDL imposed load; and UDL dead load plus PL imposed load. User has the option to specify whether point load should be considered at mid-span of thread, at one-third, or over stringer; - Comprehensive in-spreadsheet help in form of pop-up messages, this includes diagrams to better clarity the various topics. Refer to the images on the left; - Live diagram shows elevation of defined staircase and chequer plate tread, with dimensions; - Design is based on British Standard (BS 5950-1: 2000) (Note: macros must be unblocked for the spreadsheet to function properly. Follow instructions in this guide)
Be the first to leave a comment...
PLEASE NOTE: The file is in XLSM format. If after downloading you get an error message about invalid file format (XLSX) then please update your web browser or use a different one and re-download the file. Some versions of Microsoft Edge, Microsoft IE are known to corrupt XLSM files upon download by changing these to XLSX format, making these unreadable in Excel.
|