Mse Wall Design Spreadsheet Fix -

Designing a Mechanically Stabilized Earth (MSE) wall requires verifying two major stability modes: external stability (sliding, overturning, and bearing capacity) and internal stability (reinforcement rupture and pullout). Professional design typically follows the AASHTO LRFD (Load and Resistance Factor Design) methodology, which replaces traditional factors of safety with load and resistance factors to account for uncertainty. 1. Define Design Parameters

Workbook Structure (Suggested Sheets)

  1. Cover / Instructions
  2. Inputs — Project Data & Materials
  3. Geometry — Wall Geometry & Layers
  4. Loads & Surcharge
  5. Reinforcement Layout
  6. Global Stability Checks
  7. Internal Stability Checks
  8. Seismic Analysis (optional)
  9. Reinforced Zone Strength (strain compatibility)
  10. Foundation Bearing & Settlement
  11. Drainage & Facing Details
  12. Quantities & Bill of Materials
  13. Sensitivity & Design Iterations
  14. Output Summary & Typical Details
  15. Assumptions, References, Revision Log

The primary function of these spreadsheets is to handle the dual-stability checks required by standards like the Federal Highway Administration (.gov): mse wall design spreadsheet

  • Table: Layer index, elevation, embedment length, required T, provided T, margin (%)

Formulas and outputs:

2. Typical Structure of an MSE Wall Design Spreadsheet

A robust MSE wall spreadsheet is organized into distinct modules: Cover / Instructions Inputs — Project Data &

2. External Stability Checks

These ensure the wall behaves as a rigid block: The primary function of these spreadsheets is to

Step 3 – Input geometry and loads

Start with a realistic wall height and surcharge. Avoid over-conservative φ values (e.g., using 28° for clean sand when 34° is justified).