Menu:

Steel Bracing Design Spreadsheet to BS5950
Available for Microsoft Windows and Apple Mac users.

Description:
Spreadsheet for designing bracing in steel frames up to ten storey high. It is very versatile and covers four types of bracing: single diagonal, x-bracing, v-bracing and k-bracing. Spreadsheet is very easy to use with all calculations done automatically in the background. It also includes a 'live' diagram for quick appreciation of results.​

This spreadsheet was specially developed for Windows and Mac users.
Features:
- Clear and easy to read output (all on a single page);
- Table with summary of calculation steps and results per storey;
- For frames from one to ten storey high;
- Covers: section classification, tension member analysis, compression member analysis, reactions;
- Bracing types covered: single diagonal bracing; x-bracing (tension only); v-bracing; k-bracing;
- Steel grades: S275, S355, S460;
- Steel section types (tension only members): flat bars, equal angles, unequal angles;
- Steel section types (tension and compression members): RHS, SHS, CHS. Hot rolled and cold formed;
- 'Live' diagram with member sizes, frame dimensions, loads;
- Option to specify amplification factor for sway-sensitive structures;
- Option to specify effective length parameter;
- Includes reduction for bolt holes in tension members;
- Every storey can be controlled individually;
- Based 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)
Assumptions and Limitations:
- All connections are pinned;
​- Bracing is assumed to be central on connecting members. No account is made for moment due to eccentric connections;
- Class 4 slender sections are beyond the scope of this spreadsheet;
- Block tear failure around bolts in tension members is not considered.
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 Bracing Design to BS (1.0).

The restriction in this free lite version is that you cannot change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also a few other cells are locked.
​ 

 
​​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 Bracing Design to BS (1.0).

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

Fully working version where you change the company information and company logo.

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 that you can have for a great value.

After purchase fill in this Activation Key Request Form.


 
 


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