Watermark @ Robertson Quay - Conservation of old facade and new construction of residential units

Structural Analysis & Design: Structural Analysis Programs in Excel Spreadsheet

Structural Analysis & Design: Structural Analysis Programs in Excel Spreadsheet

Queens Condonminium - 3 Block of 39 Storeys Highrise Apartment Units at Queensway, Singapore. Analysis and design of the structure was carried out using ETABS and SAFE programs.

Flatplate with shearwalls system is use as the structural system. The design is very efficient and won the Construction Excellency Award and Buildable Award from Building Authority of Singapore (BCA).

Posted by Structural Design at 8:30 PM 0 comments

Orchard Central - 12 Storeys luxury shopping malls at Orchard Road. The structure is post-tensioned beams with composite steel columns.

Cascadia - 13 Blocks of 10 Storeys luxury condonminium at Upper Bukit Timah Road

Structural Subframe Analysis Using OpenOffice

In the previous post, I introduced my spreadsheet programs using excel. At the same time, I also developed and converted the Macro in the excel to OpenOffice Macro. The task is pretty daunting for someone like me who is not familiar with Open office.

Slowing but painfully, the macro take shape and finally Subframe analysis and Design Program in BS8110 is available in OpenOffice Calc.

In the next few post, I will demonstrate the screen shots of my program. I will like to collaborate with anyone that can incorporate the DXF drafting portion in the program.

Subframe/ Continuous Beam using Excel

This the sample page of the continuous spreadsheet program that I developed. The input is simple and straight forward. The beauty of using spreadsheet is that even if the input is enter incorrectly first time, you could amend it later without going through the entire input process. Output forces are directly printed beside each spans.

The are two buttons command, namely "Span Information" & :Input Load Type". This is where all the macro will be invoked.

Input : 1) By clicking the macro, the input screen would ask for number of span, support conditions, beams span lengths, beam and column sizes in a sequential way.

2) Next step is to invoke the Input Load Type macro.

3) You can input maximum 10 load cases for each spans. Uniformly distributed load, triangular load, point load, trapezoidal load and linear load are all the load cases.

4) No analysis step is needed as analysis will be completed the moment the last load case is completed.

5) The support reactions for Dead Load, Live Load and ultimate load & column moment will also be computed and shown in the spreadsheet.

Next post, I will illustrated the Subframe analysis spreadsheet usingn OpenOffice.