CISC CAN/CSA S16.1 Steel Section Design

I developed this spreadsheet that can design Beam under flexural, Beam-Column under Uniaxial and biaxial moment in accordance to CISC CAN/CSA S16.1 Structural Steel Design.

The spreadsheet results are compared to Examples in CISC Handbook and the results match exactly.

The spreadsheet results also compare with the CSA Beam Selection Table and the results also match exactly. This program can be used to assist in the design of steel elements to CISC CAN/CSA S16.1.

I will be developing more of the spreadsheet and for those interested, you can contact me for a copy.

Analysis of Beam Section - CSA A23.3 - 04

The following spreadsheet demonstrate my program that can analyse any rectangular beam section. The similar program can analyse rectangular column, circular column which will be demonstrated in the my future blog.

 Eg. 2.1 -The CSA concrete design handbook give the moment as = 207kNm

My spreadsheet Mr = 205.9 kNm

Eg. 2.4 - CSA concrete design handbook give the moment as = 675kNm

My spreadsheet Mr = 690 kNm

There is a slight discrepancy but it is due to the section analysis is very accurately calculate the neutral axis and checking the yield strength of the tension and compression steel.

So it can be seem that the spreadsheet is very accurate in computing the section capacity based on CSA A23.3 - 04.

Retaining Wall Design to CSA A23.3

This spreadsheet design the retaining wall in accordance to CSA A23.3. The spreadsheet also has version for BS8110 & CP65. The analysis of the FOS for the retaining wall does not differ much from code to code. The spreadsheet has widely been used in my project for the last 10 years and has proven to be a reliable spreadsheet.