Despite its power, an MSE wall spreadsheet has inherent limitations:
Internal stability evaluates the integrity of the reinforcement layers within the soil mass. The spreadsheet calculates:
To build the formulas into your spreadsheet, follow this computational order: mse wall design spreadsheet
A robust MSE wall spreadsheet is organized into distinct modules:
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 Despite its power, an MSE wall spreadsheet has
Wall height, backslope angle, and toe slope angle.
A summary table of all Safety Factors or Capacity Demand Ratios (CDRs). Clear or "FAIL" conditional formatting indicators. Clear or "FAIL" conditional formatting indicators
Your spreadsheet should clearly state which code it follows (e.g., AASHTO LRFD Bridge Design Specifications or FHWA guidelines) and organize input parameters accordingly. Architecture of an MSE Wall Spreadsheet
Modern MSE wall design is governed by Load and Resistance Factor Design (LRFD) principles, as specified in the AASHTO LRFD Bridge Design Specifications and the FHWA NHI-10-024 / NHI-10-025 manuals.
Below is a comprehensive guide to understanding, building, and utilizing an MSE wall design spreadsheet. The Role of Spreadsheets in MSE Wall Design
