Column Analysis - Canadia Code A23.3-04

The following spreadsheet can analyse both rectangular and circular columns.

For the example in the CPCA Concrete design handbook, the column example using PCACOL program and also from the tables give Pf=500kN, Mr=192kNm. The spreadsheet give Pf=500kN, Mr= 194kNm.

As can be seen, the spreadsheet yiedl very accurate results.

 

 I will show the rectangular beam analysis spreadsheet that anlayse beam. 

Beam Flexure & Shear Design to Canadian Code CSA23.3-04

The following is the simple spreadsheet that was written for CSA A23.3-04 code.

The spreadsheet results are compare with the Concrete Design Handbook examples and found to be accurate. The following are the comparison.

Concrete Design Handbook                          Spreadsheet Program

Eg.2.1  Mr = 209 kNm  As=1200mm2        As = 1222mm2                                                        

Eg. 2.2  As = 2468mm2                               As = 2489mm2

Eg. 2.4 As = 5674 mm2, As' = 1047mm2    As=5675mm2, As' = 1050mm2

The values of spreadsheet tally with the CSA A24.3 design handbook. The program is accurate. I shall extend this to all the one way, two way slab design, retaining wall, columns design etc.

Next time, I will post my spreadsheet that can analyse the rectangular , circular columns and beams section.