Use Excel’s MAX and MIN functions to handle varying water table depths or slope geometries.
Mechanically Stabilized Earth (MSE) walls are a cornerstone of modern civil engineering. They offer flexibility, cost-effectiveness, and high load-bearing capacity for highways, bridges, and commercial developments.
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.
Include unit rates and a simple cost estimate section as optional inputs. mse wall design spreadsheet
): Reductions applied to nominal capacities (e.g., 0.90 for geogrid pullout resistance).
This module evaluates the integrity of the layers inside the reinforced soil mass. It calculates stresses at each reinforcement layer.
Calculations determine if the wall will slide along the base, considering the shear strength of the foundation soil. Use Excel’s MAX and MIN functions to handle
Commercial black-box software often hides the underlying physics and mathematical formulas. A customized Excel or Google Sheets workbook provides distinct advantages:
[1. Input Parameters] ➔ [2. Earth Pressures] ➔ [3. External Stability] ➔ [4. Internal Stability] ➔ [5. Drainage & Output] Module 1: Input Parameters & Geometry
Engineers can instantly see how changing soil properties or reinforcement spacing impacts factors of safety. Include unit rates and a simple cost estimate
Water is the primary cause of MSE wall failures. The spreadsheet should incorporate calculations for hydrostatic pressure if a water table is present, or verify the capacity of the specified blanket and chimney drains. 3. Formulas and Engineering Logic
applications. It features a user-friendly interface for designing gravity walls, reinforced walls, and slopes. SCDOT MSE Wall Design Manual : Provides a detailed appendix outlining South Carolina’s internal and external stability requirements
Ka=tan2(45∘−ϕ2)=1−sin(ϕ)1+sin(ϕ)cap K sub a equals tangent squared open paren 45 raised to the composed with power minus the fraction with numerator phi and denominator 2 end-fraction close paren equals the fraction with numerator 1 minus sine open paren phi close paren and denominator 1 plus sine open paren phi close paren end-fraction : The total thrust from the retained soil: