Designing a Mechanically Stabilized Earth (MSE) wall requires balancing external stability (how the whole block moves) and internal stability (how the reinforcements hold the soil together). Most professional spreadsheets, like those from PennDOT or civil engineering firms, follow the AASHTO LRFD Bridge Design Specifications. 1. Spreadsheet Structure & Tabs
A standard MSE design spreadsheet should be organized into these key sections:
INPUT: Soil properties (phi angle, unit weight), wall geometry (height, batter), and reinforcement data (type, spacing, length).
EXTERNAL STABILITY: Calculations for sliding, bearing capacity, and eccentricity (overturning).
INTERNAL STABILITY: Calculations for reinforcement pullout and tensile rupture. mse wall design spreadsheet
OUTPUT: A summary table showing "Performance Ratios" or Factors of Safety (FoS). Ratios ≥is greater than or equal to 1.0 are typically "OK," while <1.0is less than 1.0 are "NG" (No Good). 2. Required Input Parameters
To get accurate results, you need to define three distinct soil zones:
Reinforced Fill: The select backfill placed within the reinforcement. Retained Backfill: The soil behind the reinforced mass. Foundation Soil: The native soil beneath the wall.
Surcharges: Include live loads (traffic) and dead loads (sloped backfill or permanent structures). 3. Core Stability Checks Your spreadsheet should automate the following checks: Check Type What it evaluates Common Success Criteria Sliding Resistance of the wall to being pushed forward. (or LRFD resistance factor) Bearing Capacity Ability of foundation soil to support the wall weight. Eccentricity Stability against overturning (keeps the wall upright). Resultant within middle Tensile Strength Resistance of reinforcement to breaking under tension. Strength > Max Tensile Force Pullout Resistance of reinforcement to sliding out of the soil. 4. Advanced Considerations Step 6 – Cross-check with hand calculation for
Seismic Loads: High-level designs must include horizontal and vertical acceleration coefficients ( Amcap A sub m
Facing Connections: Ensure the connection between the reinforcement (geogrid/strips) and the facing (panels/blocks) is strong enough to handle local pressures.
Embedment: The spreadsheet should account for minimum embedment depth (typically depending on slope) to prevent toe failure.
For further guidance, the FHWA MSE Wall Design Guide (NHI-10-025) is the industry standard for LRFD-based calculations. If you'd like, I can: consider adding these professional-grade features:
Detail the specific formulas for sliding and bearing capacity.
Recommend professional software alternatives to spreadsheets (like SkyCiv or MSEW). Provide a checklist for selecting backfill materials. Which of these would be most helpful for your project? MSE Wall Design Spreadsheet - User's Manual (April 2015)
Pick the lowest reinforcement layer (highest load). Compute T_max manually and compare to spreadsheet.
This document describes a comprehensive spreadsheet structure for designing MSE (reinforced soil) walls. It lists required inputs, calculated outputs, sheet layout, formulas, checks, units, and guidance for use. Use the spreadsheet to organize design parameters, run iterative checks, and produce outputs needed for drawings and reports.
A robust MSE wall spreadsheet must handle the following calculations, organized into logical sections:
Once you have the basics, consider adding these professional-grade features: