The spreadsheet must perform checks for multiple "Limit States" as defined by codes like AASHTO :
. These spreadsheets typically automate complex, iterative calculations following industry standards such as AASHTO LRFD Bridge Design Specifications Top MSE Wall Design Spreadsheets & Resources
: Unlike commercial software where calculations happen behind the scenes, spreadsheets display every formula explicitly. Reviewing engineers and agencies can click on cells to trace exactly how a safety factor was derived. mse wall design spreadsheet
: Federal Highway Administration (FHWA) manuals and associated spreadsheets, such as the FHWA-RD-89-193 method
: Tools like the CivilWeb MSE Wall Design Spreadsheet allow you to instantly see how changing reinforcement length or spacing affects your safety factors. The spreadsheet must perform checks for multiple "Limit
The spreadsheet shouldn't just handle the "flat backfill, no surcharge" scenario. It needs built-in capability for:
Commercial geotechnical software can be expensive and act as a "black box," hiding the underlying formulas. An Excel or Google Sheets design tool offers unique advantages: An Excel or Google Sheets design tool offers
Computes the high localized stress at the toe of the wall (often using the Meyerhof stress distribution) and compares it against the allowable bearing capacity of the foundation soil.
The workbook contains the following worksheets:
The first stage involves defining the physical and material parameters of the wall. Essential inputs usually include:
Spreadsheets excel at planar external and internal calculations. They cannot calculate global rotational slope stability. Complex deep-seated failure planes must always be verified using specialized geotechnical limit-equilibrium software.
EN 
ES 
BR 