Retaining walls play important roles in the stabilisation of soil masses and in the prevention of slope failures encountered in civil and structural engineering. This Excel sheet for Retaining Wall Design complies with ACI 318-05 and provides a reliable and convenient design tool for engineering professionals analysing and designing concrete retaining walls. The spreadsheet performs stability checks for sliding, overturning, and bearing pressure, as well as structural design of the stem, base slab, and key (if applicable).
Types of Retaining Walls Covered
- Cantilever retaining wall — the primary type covered, with a reinforced concrete stem, base slab, and optional shear key
- Gravity retaining wall — relies mainly on the mass of the wall itself for stability, with little or no reinforcement
- Counterfort retaining wall — used for taller walls, with counterforts tying the stem to the base slab to reduce bending
- Semi-gravity retaining wall — a smaller, lightly reinforced section between gravity and cantilever wall proportions
What This Excel Sheet Calculates
- Factor of safety against sliding and overturning
- Bearing pressure at the toe and heel of the base slab
- Active and passive earth pressure using Rankine or Coulomb theory
- Required flexural reinforcement for the stem, heel, toe, and key
- Base slab and key dimensions needed to satisfy stability checks
- Effect of surcharge loads on the backfill side of the wall
Design Inputs Required
- Overall wall height, stem thickness, and base slab dimensions
- Soil unit weight, angle of internal friction, and cohesion (if any)
- Allowable bearing capacity of the foundation soil
- Surcharge load on the backfill, where applicable
- Concrete compressive strength (f'c) and reinforcement yield strength (fy)
- Coefficient of base friction and passive pressure coefficient
Applicable Design Codes
This spreadsheet is built around ACI 318 (the edition referenced is ACI 318-05) for the structural design of the stem, base slab, and key in reinforced concrete. Earth pressure and stability calculations follow classical Rankine and Coulomb lateral earth pressure theory, which is standard practice alongside ACI provisions for retaining wall design. Geotechnical parameters such as bearing capacity and friction angle should come from a project-specific soil investigation rather than assumed values.
Who Should Use This Tool
This tool is aimed at structural and geotechnical engineers designing or checking cantilever, gravity, or counterfort retaining walls for buildings, roadways, and site retaining structures. It is also useful for engineering students studying lateral earth pressure and reinforced concrete design, and for reviewers who need a quick independent check of stability and reinforcement calculations.
Download the Free Retaining Wall Design Sheet
The free Excel sheet walks through soil and geometry inputs, then reports sliding, overturning, and bearing checks alongside the required reinforcement for the stem and base slab. It is intended as a design aid and preliminary check, not a substitute for a full engineering review. Confirm soil parameters against a geotechnical report, verify load combinations against the applicable building code, and have the final design checked by a licensed engineer before construction.
Be the first to comment.