Retaining Wall Design Calculator

Full Description

This retaining wall design calculator is a spreadsheet for engineers who need to size a retaining wall and check its reinforcement. It brings wall dimensions, retained materials, concrete strength and rebar design into one workbook, with a calculations page that shows your work.

What is a retaining wall design calculator?

A retaining wall design calculator is a tool that takes a wall’s geometry, the soil or material it holds back and the materials it is built from, and works through the structural checks. For a reinforced concrete wall that usually means estimating the lateral earth pressure, checking the wall against overturning, sliding and bearing failure, and then sizing the stem and footing reinforcement. A spreadsheet keeps those steps visible so they can be reviewed and adjusted.

When to use it

• Early design, to test wall heights and footing sizes before detailed drawings.
• Checking a contractor-proposed alternative or a field change to wall height.
• Sizing rebar for site walls, loading dock walls or landscape walls.
• Preparing calculations to submit with a permit or for peer review.
• Teaching or self-checking how retaining wall design works.

What’s included

• Inputs for the size of the retaining wall.
• Material types being retained.
• Rebar (reinforcement) design, including concrete strength and rebar requirements.
• A calculations page to show your work.

The calculator is an Excel spreadsheet (.xls), so it opens in current versions of Excel and most other spreadsheet programs.

How to fill it out

1. Collect the geotechnical data: soil unit weight, friction angle and allowable bearing pressure, ideally from a site investigation report.
2. Enter the wall geometry: retained height, stem thickness, footing width, toe and heel lengths.
3. Select or enter the retained material and any surcharge, such as traffic or stockpiles behind the wall.
4. Enter the concrete strength and rebar grade you plan to use.
5. Review the calculations page and adjust the wall dimensions or reinforcement until every check works.
6. Have the final design reviewed and sealed by a licensed engineer where required.

Tips

• Drainage behind the wall matters as much as the concrete. Water pressure adds a large load.
• Use conservative soil values if you do not have a geotechnical report, and say so in your calculations.
• Keep a copy of each design run so you can show how the final size was reached.

Related templates and guides

• Quantity Calculator – Concrete, Steel and Brick
• Rebar Takeoff
• More design calculators
• Guide: Concrete Formwork Types, Design and Stripping Times
• Glossary: Rebar

Frequently asked questions

How do you calculate a retaining wall?

Work out the lateral earth pressure from the retained height and soil properties, add any surcharge and water pressure, then check the wall for overturning, sliding and bearing pressure under the footing. Once the wall is stable, design the stem and footing for bending and shear and select the reinforcement.

What safety factors are used for retaining walls?

Factors of around 1.5 against overturning and sliding are common in practice, with bearing checked against the allowable soil pressure. The governing building code and the geotechnical engineer’s recommendations set the actual values for your project, so confirm them before you finalize a design.

Does a retaining wall need an engineer?

Many building departments require an engineered design once a wall passes a set height, or where it supports a surcharge such as a driveway or building. Requirements vary by location, so check with your local authority. Even when not required, an engineering review is good practice for structural walls.

Can I use this calculator for block retaining walls?

It is set up around concrete strength and rebar design, so it suits reinforced concrete retaining walls. Segmental block walls and geogrid-reinforced walls follow different design methods, and block manufacturers publish their own design guides and estimating tools for those systems.

Does the calculator give a cost estimate for the wall?

No. It is built for design checks rather than pricing. Once you know the wall size and reinforcement, take off the concrete and rebar quantities and price them separately, using a quantity calculator or your estimating template.