Use Excel charts to dynamically plot the wall profile, reinforcement layers, and the theoretical coherent gravity or bilinear failure plane. If a layer spacing is entered incorrectly, it will be immediately visible on the plot. 🛑 Limitations of Spreadsheet Tools
For geogrids: obtain manufacturer’s reduction factors (RF_creep, RF_install, RF_chemical/biological). Do not guess.
The is more than a computational tool—it is a structured representation of geotechnical engineering principles. Whether you are building one from scratch or customizing a template, focus on clarity, error-proofing, and full documentation of assumptions.
Comprehensive Guide to MSE Wall Design Spreadsheets: Streamlining Retaining Wall Engineering mse wall design spreadsheet
You can build your own MSE wall design spreadsheet from scratch using textbooks (e.g., FHWA NHI-10-024 ). The benefits include full customization and deep learning. The downsides: 40-80 hours of development, debugging, and validation.
External stability treats the reinforced soil mass as a rigid gravity retaining wall. The spreadsheet must compute the driving forces against the resisting forces.
External stability treats the reinforced soil mass as a rigid gravity retaining wall block. The spreadsheet calculates safety factors against three primary failure modes: Use Excel charts to dynamically plot the wall
What type of reinforcement are you targeting ( or metallic strips )?
: By multiplying the reinforcement areas by unit prices, the project manager can estimate if the wall fits the $40 to $360 per linear foot budget.
Are there any involved? (High seismic loads , tiered walls , or steep backslopes ) Share public link Do not guess
For further guidance, the FHWA MSE Wall Design Guide (NHI-10-025) is the industry standard for LRFD-based calculations. If you'd like, I can:
If you are building an Excel or Google Sheets template from scratch, organize your workbook across logical, sequential tabs to maintain clean data flow: