Steel Column Design Spreadsheet to BS 5950

Steel Column Design Spreadsheet to BS 5950 is intended for Windows and Mac users. This estimating spreadsheet can be used to simplify the steel design process. The spreadsheet offers automatic user input.

With this takeoff sheet, the users can get rid of time consuming calculations of steel columns. The users can utilize it toward slender sections. The design system is designated for 'simple structures' where estimations are made for minimal column moments on the basis of reactions out of supported beams.

The spreadsheet offers the following aspects :-

• A concise and easily understandable out (all on a single page);
• Modify steel grade: S275; S355; S460;
• Compatible with steel sections: UC, UB;
• Support all cross-section classes like plastic, compact, semi-compact, slender;
• Estimation is makde for Class 4 Slender sections on the basis of reduced design strength pyr;
• All the estimates are created on the basis of 'simple structures' design processes narrated in section 4.7.7. of BS;
• Automate the processes for estimating nominal effective length factors on the basis of stipulated end restraint types;
• There is choice to modify beam reaction eccentricity value (in 'simple construction' typically 100mm);
• There is also choice to allow moments being segregated amid nearby (top and bottom) columns;
• Provides individual checks for compression resistance and buckling resistance;
• There is option to modify design amid under factored or unfactored values;
• Get instant synopsis of utilization factors;
• 'Live' Loading diagram;
• Adjustable safety factors;
• Design is creared on the basis of British Standard (BS 5950:1 2000).

To activate the Single-User Licensed version, one should need the following version:

• Microsoft Windows Excel version 2007 to 2013;
  (Note: the Single-User spreadsheet will not compatible with Mac due to unsupported activation procedure)

To activate the Company Licensed version the users should need the following:

• Microsoft Windows Excel version 2007 to 2013;
• Microsoft Mac Excel version 2001, 2004 or 2011.

Link for download Steel Column Design Spreadsheet