To ensure your spreadsheet calculates values accurately, integrate these fundamental engineering equations: Lateral Earth Pressure (Rankine Theory)
External stability treats the reinforced soil mass as a rigid gravity retaining wall block. The spreadsheet calculates safety factors against three primary failure modes:
): The natural soil beneath the wall supporting the entire structure. Reinforcement (Geogrid/Steel) Properties The maximum load the reinforcement can handle. Reduction Factors ( ): Factors for creep, installation damage, and durability. Long-Term Allowable Design Strength ( Talcap T sub a l end-sub ): Calculated as Coverage Ratio ( Rccap R sub c
Type (geogrid vs. steel), ultimate tensile strength ( Tultcap T sub u l t end-sub ), long-term design strength reduction factors ( ), and vertical spacing ( Svcap S sub v Surcharge Loads: Live load surcharge ( qLSq sub cap L cap S end-sub ) and dead load surcharge ( qDSq sub cap D cap S end-sub 2. External Stability Analysis Module mse wall design spreadsheet
Which design methodology do you need to follow? ( or NCMA ASD ?)
Enter the design geometry and the laboratory-verified soil properties for the site. Step 2: Set Initial Reinforcement Length
Generate tables of required reinforcement length, spacing, and strength for varying wall heights – useful for preliminary design and cost estimation. Reduction Factors ( ): Factors for creep, installation
): Spatial distribution of the reinforcement along the wall length. 3. Step-by-Step Calculation Engine
Real-time feedback on whether the design meets code requirements.
Create blocked sections for Inputs, Earth Pressures, External Checking, and Internal Checking. Create blocked sections for Inputs
Accounts for dynamic traffic live load surcharges by converting them into an equivalent uniform height of soil. 3. External Stability Analysis
| Issue | Consequence | |-------|-------------| | | Incorrect safety factors or units (e.g., psf vs. ksf) | | Missing load combinations | Under-designed wall for seismic or surcharge | | No built-in global stability | Deep-seated failure through foundation soil not checked | | Spreadsheet cell protection | Accidental overwriting of key formulas | | Complex iteration limits | Excel’s circular reference or goal seek may converge poorly |
Even experienced users make these errors:
The design of involves complex calculations for internal and external stability. Using a dedicated spreadsheet is a common way for geotechnical and structural engineers to streamline this process while adhering to AASHTO LRFD or NCMA standards. Core Components of an MSE Wall Design Spreadsheet