: This involves checking the integrity of the reinforcement and its interaction with the soil. Two primary failure modes are analyzed:
The Ultimate Guide to MSE Wall Design Spreadsheets: Streamlining Retaining Wall Engineering
and is designed to optimize design efficiency by eliminating manual iterations. GEOWEB® MSE Wall Design Software
– Vertical stress at the base vs. ultimate bearing capacity of foundation soil. Spreadsheets compute eccentricity (e = M/V) and effective footing width (B' = B - 2e), then check Meyerhof or Terzaghi bearing capacity.
Checks and formulas (per unit length of wall unless otherwise stated): mse wall design spreadsheet
Commercial geotechnical software can be expensive and act as a "black box," hiding the underlying formulas. An Excel or Google Sheets design tool offers unique advantages:
The reinforced soil mass is treated as a rigid gravity block. You must check the following limit states:
The core functionality of the spreadsheet relies on executing two main categories of stability checks.
Whether you need to accommodate specific loading conditions like or heavy traffic surcharges Share public link : This involves checking the integrity of the
Before building or selecting a spreadsheet, you must understand the underlying design methodologies. Most modern spreadsheets are built around one of two frameworks: Allowable Stress Design (ASD) Historically the standard method for MSE wall design.
Toggle between Allowable Stress Design (ASD, factors of safety) and Load and Resistance Factor Design (LRFD, φ factors and load factors). Some spreadsheets include separate tabs for Strength I, Strength IV, Service I, and Extreme Event I (seismic).
Internal stability evaluates the integrity of the soil reinforcements (geogrids or steel strips) and their connections to the wall facing.
Eliminates the need for expensive software licenses for preliminary sizing and quality assurance checks. Core Regulatory Frameworks ultimate bearing capacity of foundation soil
Dynamic earth pressure increments (if seismic forces are required) External Stability Analysis
Marcus released MSE-Wall-Pro v1.0 internally. Within three months, it was used on five projects. He added a seismic module after a small earthquake hit a neighboring county. He added a “reinforcement layout optimizer” that minimized geogrid length while satisfying all safety factors — saving $8,000 in materials per wall on average. He added a construction checklist tab for field inspectors.
Vary φ by ±2° and γ by ±10%. If FS drops below 1.3 in any scenario, redesign.
The spreadsheet must evaluate the Capacity Demand Ratio (CDR), ensuring it is greater than or equal to 1.0. Step-by-Step Blueprint to Build the Spreadsheet