An MSE wall design spreadsheet is a pre-formatted electronic worksheet that guides engineers through the design process of an MSE wall. The spreadsheet typically includes multiple tabs or sheets that organize the input data, calculations, and output results.
| Pitfall | Spreadsheet Solution | | --- | --- | | Forgetting the facing connection strength | Add a specific check: FS_conn = T_conn_allow / T_max | | Ignoring the effect of a sloping backfill | Compute β (slope angle) and adjust K accordingly (K = Ka * (1 + β/φ)) | | Double-counting surcharge | Use distinct rows for dead load surcharge and live load surcharge | | Using the wrong K for pullout | For geogrids, pullout uses the interface friction angle (δ = 0.9φ) | | No load duration factor | For temporary walls (≤6 months), a duration factor can increase T_allow – include a toggle | mse wall design spreadsheet
The biggest risk with spreadsheets is the "black box" effect. A professional MSE spreadsheet should have an "Audit" tab where you can check the algebraic formulas against the relevant code (e.g., AASHTO LRFD). If you can't verify the math, you shouldn't trust the result. An MSE wall design spreadsheet is a pre-formatted
Spreadsheets—primarily Microsoft Excel—are widely used in practice for MSE wall design due to their transparency, flexibility, and accessibility compared to proprietary software (e.g., MSEW, ReSSA). However, proper spreadsheet design requires rigorous implementation of geotechnical and structural engineering principles. A professional MSE spreadsheet should have an "Audit"
Use validated spreadsheets for routine walls (H < 20 ft, non-seismic, good foundation soils). For complex projects, cross-check with commercial MSE software or 2D slope stability programs (e.g., Slide, Slope/W) that handle reinforcement explicitly.