-

Reinforced Rectangular Concentric Concrete Footing Design Spreadsheet

General Description: Calculates the reinforcement required for a reinforced rectangular or square concrete footing with a rectangular or square columns at the centre of the footing, for flexure and checks 1 way and 2 way shear at the concrete column, using ductility class N reinforcement.

Limitations: For rectangular or square pads only, with no applied moment or horizontal forces. Does not design for shear reinforcement.

Codes/Theoretical Basis:
AS3600 – 2009 (Incorporating Amendment 1, 2010 )
Warner, Rangan, Hall & Faulkes, Concrete Structures, Longman, Melbourne, 1999
Foster, Kilpatrick and Warner, Reinforced Concrete Basics 2E, Pearson, 2010

Nomenclature: Symbols and notation as generally used in AS3600.

Input:
Yellow cells require data input by the designer
Geometry for the pad footing , etc
Concrete strength etc
Geometry of column etc
Applied actions and allowable bearing capacity
Area of tension reinforcement in both directions based on initial calculations and minimum reinforcement
Iterate if does not meet minimum design values

Where pink fill is used it alerts designer to options or information

Output:
Boxed cells with green background calculated automatically using formulae.
Footing weight, working load, total ultimate load, load factor and actual bearing pressure under the footing
Ultimate moment in each direction and initial area of reinforcing along with minimum reinforcement
Number, size and spacing of reinforcing bars
Maximum bending capacity in both directions Muo
Moment capacity fMu in both directions for the chosen reinforcement
Checks for minimum reinforcement
Checks one way and two way shear
Provides summary of the results

Feedback: For comments, corrections, suggestions or other feedback regarding this spreadsheet, please contact the CCAA

Calculation Reference
AS3600

Download Link

Earthquake Lateral Forces According to UBC97 Spreadsheet

Download Link

Characteristic Load Method (CLM) Spreadsheet

Introduction
The first version of the Characteristic Load Method (CLM) spreadsheet (Brettmann and Duncan, 1996) was based on the CLM method (Duncan, et al., 1994) for analysis of single piles, and the Group Amplification Method (Ooi and Duncan, 1994) for analysis of pile groups.

That first version of the CLM spreadsheet was found to produce quite accurate results for single piles, but was found in many cases to overestimate deflections and bending moments for pile groups.
The revised spreadsheet described in this report uses the same method of analysis as the original
for single piles, but uses an improved method of analysis for pile groups.

Background
The characteristic load method (CLM) of analysis of laterally loaded piles (Duncan et al., 1994) was developed by performing nonlinear p-y analyses for a wide range of free-head and fixed-head piles and drilled shafts in clay and sand. The results of the analyses were used to develop nonlinear relationships between dimensionless measures of load and deflection.

These relationships were found to be capable of representing the nonlinear behavior of single piles and drilled shafts quite accurately, producing essentially the same values of deflection and maximum moment as p-y analysis computer programs like COM624 and LpilePlus3.0.

The principal limitation of the CLM method is that it is applicable only to uniform soil conditions.
The Group Amplification Method was developed by Ooi and Duncan (1994), to extend use of the CLM method to groups of piles and drilled shafts. Values of group amplification factors for deflection and moment were computed using the method developed by Focht and Koch(1973).

The original version of the CLM spreadsheet (Brettmann and Duncan, 1996) used the CLM method to calculate deflections and bending moments in single piles, and the Group Amplification Method to calculate deflections and moments for piles in pile groups. It was found that the original version of the spreadsheet resulted in accurate values of moment and deflection for single piles, but often over-estimated deflections and bending moments for the
piles in pile groups, as judged by comparison with p-y analysis programs and the results of field
load tests.

Download Link

Pushover Analysis of Steel Frame Spreadsheet

Download Link

A complete Example of Precast Structural Design

Project Description

The building is a 12-storey office block in a mix commercial development comprising carparks, shopping malls and service apartments.

A typical floor of the building measuring 24 m x 72 m with 8 m building grids in both direction. The design floor-to-floor height is 3.6 m. Staircases, lift cores and other building services such as toilets, AHU, M&E risers are located at each end of the floor which are to be cast in-situ.

Design Information

Codes of Practice: