Cantilever Retaining Wall Analysis Excel Sheet

Cantilever Retaining Wall Analysis Excel Sheet

1 July 2019 Off By The Engineering Community

Cantilever Retaining Wall Analysis Excel Sheet

 

Purpose of calculation: The details of a cantilever retaining wall are shown below, is the design of the wall satisfactory?
Calculation Reference: Craig Soil Mechanics. R.F. Craig
Calculation Validation: Check against a worked example in the reference above.

Calculation Parameters :

 

  •     Surcharge Pressure
  •    Thickness of the Stem
  •    Thickness of the Base
  •    Length of Backfill
  •   Height of Wall from the Base
  •   Width of the Base
  •    Characteristics of Backfill
  •     Drained (effective stress) Shear Strength Parameter
  •     Unit Weight of the backfill
  •     Drained (effective stress) Shear Strength Parameter
  •     Characteristics of Concrete
  •     Unit Weight of Concrete
  •     Angle of friction between the base and the foundation soil is
  •    Active earth pressure coefficient
  •     Horizontal Forces
  •     Sum of Horizontal Forces
  •     Vertical Forces
  •     Sum of Vertical Forces
  •     Lever
  •     Moments
  •     Lever arm of base resultant
  •     FoS against overturning
  •     Eccentricity of base reaction
  •     Maximum and minimum base pressures
  •     FoS against sliding

Calculation Reference
Geotechnics

Download Link