Menu:

Steel Portal Frame Sizing Spreadsheet to BS5950
(Based on Appendix A in SCI Publication P252) Available for Microsoft Windows and Apple Mac users.

Description:
Very easy to use spreadsheet for sizing rafters, stanchions and haunches in single span portal frames at preliminary design stage. Based on Method 1 in Appendix A in SCI Publication P252: Design of single-span steel portal frames to BS 5950-1: 2000 - preliminary design. Saves you time finding required sizes in tables and writing up a calculation page.

​Spreadsheet is for estimating purpose only and detailed design should still be carried out. Appendix A in SCI Publication P252 does not take account of stability at the ultimate limit state, deflections at the serviceability limit state.

This spreadsheet was specially developed for Windows and Mac users.
Features:
- A clear and easy to read output (all on a single page);
- Quick summary of results;
- A diagram with member sizes and frame dimensions;
- Saves time going through tables and writing up a calculation page;
- Based on Method 1 in Appendix A in SCI Publication P252: Design of single-span steel portal frames to BS 5950-1: 2000 - preliminary design.

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
Assumptions in SCI P252:
- Wind load is based on ground roughness category 2 with a basic wind speed of up to 52m/s. Where dominant openings exist the results should be treated with caution;
- Steel grade is S275;
- Haunch length is 10% of the span of the frame;
- Roof pitch is 6 degrees;
- Rafter load is the total factored dead load (including self weight) and factored imposed load;
- Given member sizes are suitable for rapid preliminary design or for estimating purposes only;
- Results can be used for multiple span frames of equal or unequal spans provided a suitable valley column is used (not covered in the spreadsheet);
- Stability at the ultimate limit state and deflection at the serviceability limit state is not accounted for.
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 Portal Frame Sizing 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 Portal Frame Sizing 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).