The Riverview MSE wall was built in eleven days. It passed all field quality assurance tests: no excessive facing deflection, no geogrid rupture during construction, no settlement behind the wall after six months. The spreadsheet saved the firm 32 hours of manual calculations and prevented a $90,000 delay.
Pro tip: Use Excel’s Data Table or Solver add-in to automatically iterate length, but validate with hand checks.
These calculations are heavily dependent on variable inputs: soil unit weights, friction angles, surcharge loads, seismic coefficients, and geometric constraints. A slight change in the angle of internal friction or the height of the wall necessitates a complete recalculation of the reinforcement schedule. This is where the computational power of a spreadsheet transforms a tedious manual process into an efficient engineering workflow. mse wall design spreadsheet
Structural design checks (reinforcement strength, pullout resistance). Automatic optimization of reinforcement length and spacing. 1. Core Inputs in an MSE Design Spreadsheet
An institutional-grade MSE wall design spreadsheet must be structured logically. A standard layout flows from raw data inputs to final safety factor summaries. 1. Input Parameter Modules The Riverview MSE wall was built in eleven days
Use Coulomb or Rankine theories to determine Kacap K sub a for the retained soil. Determine Krcap K sub r for the internal zone based on reinforcement type. Determine Reinforcement Length (
Even seasoned engineers make mistakes. Integrate these checks into your design spreadsheet: Pro tip: Use Excel’s Data Table or Solver
However, designing an MSE wall is no trivial task. Engineers must check external stability (sliding, bearing capacity, overturning, global stability) and internal stability (tension pullout, rupture, facing connection, and overall block stability). Doing this manually for every layer of reinforcement is tedious and error-prone.
– Vertical stress at the base vs. ultimate bearing capacity of foundation soil. Spreadsheets compute eccentricity (e = M/V) and effective footing width (B' = B - 2e), then check Meyerhof or Terzaghi bearing capacity.
Remember: the best spreadsheet in the world is useless if the engineer does not understand the why behind the how . Use your spreadsheet to iterate freely, but always anchor your final design in the physical realities of soil, reinforcement, and construction.
External stability treats the MSE mass as a rigid gravity retaining wall. The spreadsheet must compute the driving forces against the resisting forces to evaluate three primary failure modes: