Structural Analysis Programs in Excel Spreadsheet

The followings described the Excel Spreadsheet Programs :

1) Continuous &Subframe Analysis and Design (Excel & Calc) - This program analyses and design continuous beams or subframe using moment distribution methods. Moments and shear forces envelope are based on BS8110 requirements but the programs can analyse more rigorous loading patterns if needed. The maximum number of span is 10 and can carry out analysis on cantilever ends, fixed ends etc. Excel macro is added to the programs to ease the input of spans and loadings. However, the programs can still work if the macro is disable, it will only be a more cumbersome input steps only. The program had been tested rigirously with commercial software such as SAP2000, Prokon Continuous Beams, TopCad Beam and some textbooks examples. All the results tally exactly.

The program is also writtten in OpenOffice and run perfectly well. In future post, I will denote as (Excel & Calc) for Microsoft Excel format and OpenOffice Calc format.

The design module is an add-on and can be carried out separately from the analysis portion. Currently the design is in BS8110 (1985, 1997). CSA A23.3-04 code is currently implementing.

2) Reinforced Concrete Section Analysis (Rectangular Beams, Rectangular and Circular Column) - (Excel & Calc) Every engineer writes a program to design moment and shear for RC sections once in their work life. I developed more than section design. This is a capacity check of rectangular beam and column and circular column. The analysis is carried out using first principle and reinforcement arrangement can be asymmetric. Macro is written to accelerate the iteration process but without the macro, the program will still work.

Currently, the program is written in both BS8110 and CSA A23.3-04.

3) Beam Design (Excel & Calc) - Design the reinforcement requirements of beam section for bending moment, shear force and torsional force. This is a typical beam design program that is used on daily basis.

The program can design in both BS8110 and CSA A23.3-04.

4) Pilecap Design (Excel & Calc) - Design of pilecap for pilegroup of 2 to 6 piles. The pile arrangement need to be regular in order for the program to work.

5) Box Drain Design (Excel & Calc) - Design of box culvert using coefficient given in Reynold Handbook. The program was tested using SAP2000 plane frame with numerous load patterns and cases. Results proved to be exactly.

6) Retaining wall Design (Excel & Calc) - Design of L shape retaining walls and checking of factor of safety for sliding, overturning and bearing pressure. The soil can be on the heel or toe of the retaining walls making the program very versatile to use.

7) Corbel Design and Deep Beam Design (Excel & Cal) - Design corbel and deep beam using strut and tie model.

There are other programs that I will list in my next few post.