When building or selecting an MSE wall design spreadsheet, it must align with the correct engineering methodology mandated by your project jurisdiction: Allowable Stress Design (ASD) : Applies global Factors of Safety ( FScap F cap S ) to nominal loads and capacities.
Inputs:
Dropdown menus to select the design methodology (e.g., AASHTO LRFD vs. ASD). Global safety factor or resistance factor settings. Tab 2: Geotechnical Input Parameters Reinforced Fill ( ϕrphi sub r γrgamma sub r
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.
Any loads acting on top of or behind the wall, such as traffic or nearby building foundations. Why Use a Spreadsheet Instead of Manual Calculations? mse wall design spreadsheet
: High-level designs must include horizontal and vertical acceleration coefficients ( Amcap A sub m
“You can’t do that,” the PM said. “That’s too fast. What about quality control?”
These tools typically include several "tabs" or modules to handle the lifecycle of the design: MSE Wall Design Spreadsheet - User's Manual (April 2015)
Some advanced spreadsheets also perform preliminary checks for deep-seated slope stability and expected settlements. Key Design Parameters and Inputs When building or selecting an MSE wall design
: Verifies that the embedded length of the geogrid in the resistant zone is long enough to prevent pulling out of the soil.
The spreadsheet checks the connection strength between the reinforcement and the facing element. For manufactured facing blocks, proprietary connection capacities are often required from the manufacturer’s design manual.
Mechanically Stabilized Earth (MSE) wall design spreadsheets are engineering tools used to perform complex stability calculations based on soil properties, wall geometry, and loading conditions. Most professional-grade spreadsheets follow the AASHTO LRFD (Load and Resistance Factor Design) methodology. Commonwealth of Pennsylvania (.gov) Key Design Reports & Manuals
Create a lookup table linking geogrid or metallic strip properties. Use XLOOKUP or INDEX/MATCH formulas to automatically populate reduction factors based on the selected product model. Best Practices and Limitations Global safety factor or resistance factor settings
Spreadsheets run on almost any device without requiring specialized software licenses. Core Components of an MSE Wall Design Spreadsheet
The MSE wall design spreadsheet typically consists of several worksheets that guide the user through the design process. The steps involved in using the spreadsheet are:
: A dashboard showing "OK" or "NG" (No Good) for all stability checks. RESOURCES/TABLES