Structural • Geotech Microsoft Excel (.xlsx)

Retaining Wall Stability (EC7)

External stability of a gravity or cantilever retaining wall: sliding, overturning, bearing.

What this workbook is

A real, downloadable Microsoft Excel workbook — not a rendered demo. Every sheet is built around a single engineering method: inputs in one place, calculated results and a PASS / WARN / FAIL check sheet, with the method, sources and assumptions recorded next to the numbers. Open it in Excel, Sheets or LibreOffice, change the inputs, and the workbook recalculates.

  • Light cells are user-entered inputs on the Inputs sheet.
  • Dark cells are calculated automatically and are not editable.
  • The method and sources for every calculation are listed below and inside the workbook.

What you enter

  • Wall geometry
  • Soil unit weights
  • د† and خ´ (user)
  • Surcharge
  • Bearing capacity

What it calculates

  • Active force & lever arm
  • FS sliding
  • FS overturning
  • Bearing pressures

Method

Rankine/Coulomb active pressure; EC7-style resistance verifications; middle-third rule

Sources

  • [1] EN 1997-1 (EC7); classic soil mechanics (Rankine/Coulomb)

Inside the workbook

CoverTitle, scope and revision block
SummaryCore inputs and headline results
InputsYour project values (light cells)
CalculationsStep-by-step working sheet (dark cells)
OutputsReadback of results for reporting
ChecksPASS / WARN / FAIL against stated limits
ReferenceSources for each calculation
Notes & AssumptionsScope, exclusions and stated limits