Menu:

Steel Balustrade Post Design Spreadsheet to BS 5950-1
 

Description:
An easy to use spreadsheet for designing steel balustrade posts subject to horizontal imposed or wind loads, depending on type of occupancy. Includes baseplate weld and bolt design. Steel-to-steel and steel-to-concrete post fixing scenarios are covered. Spreadsheet covers CHS, RHS and SHS steel sections. Spreadsheet is very user friendly. It is an invaluable tool for quickly designing steel balustrade posts. 

Features:
- Clear and easy to read output (all on a single page);
- Quick summary of utilization factors;
- Covers ULS and SLS checks of balustrade post;
- Includes a comprehensive database of standard steel sections up to 100mm deep. This includes CHS, RHS and SHS sections;
- Post deflection is checked against user defined absolute value as well as span to depth ratio;
- Three load types can be specified and spreadsheet designs for the worst case. The loads include horizontal line load, point load and panel load (UDL);
- Post is checked as fixed cantilever;
- Baseplates design covers weld and bolt design. Both steel-to-steel and steel-to-concrete post fixing scenarios are covered;
- For steel-to-steel connection weld check is based on full height sideplate length. While for steel-to-concrete connection weld check is based on full perimeter weld around the post section;
- In-spreadsheet help;
- Live diagram shows selected section size and dimensions;
- It also updates when user changes between steel-to-steel and steel-to-concrete base connection type;
- 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)​
What People Say:

​Be the first to leave a comment...
Provide testimonial or feedback
System Requirements:
To run the Single-User Licensed version you require:
- Microsoft Windows Excel version 2007 and above;
(Note: the Single-User spreadsheet will not run on Mac due to unsupported activation procedure)

To run the Company Licensed version you require either:
- Microsoft Windows Excel version 2007 and above;
- Microsoft Mac Excel version 2004, 2011 and above. If unsure then see whether the FREE version works.
Download Section:
FREE Lite version: Steel Balustrade Post Design Spreadsheet to BS 5950-1 (1.1)

The restriction in this free lite version is that you can not change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also you cannot change post height, overall factor of safety etc.
​ 

 
​​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.


FULL version: Steel Balustrade Post Design Spreadsheet to BS 5950-1 (1.1)

Single-User or Company License, which one is the best for me?

Fully working version where you change the company information and logo in the top left corner.

By purchasing this spreadsheet you agree to the disclaimer and terms & conditions. Two types of licenses are available for this spreadsheet. The Single-User license is offered for a nominal price of £20 - a great product for a great value.

After purchase fill in the Activation Key Request Form.


 
 


For other currencies click here: € (EUR), £ (GBP) or $ (USD).