He changed the backfill from “select granular” to “on-site sandy clay” (phi = 28°). The spreadsheet instantly flashed on sliding (SF: 1.32). He added a geotextile wrap-around drainage layer — PASS again.
If you are building your own tool or reviewing an existing one, I can help you refine the specific formulas or layout. Let me know: Are you designing for or NCMA ASD standards?
, which can serve as a basis for building custom verification spreadsheets. CivilWeb Spreadsheets Essential Evaluation Features mse wall design spreadsheet
A clean summary tab that highlights the final Safety Factors (FS) or Load and Resistance Factor Design (LRFD) Demand-to-Capacity ratios. It should feature automated "PASS/FAIL" indicators using conditional formatting. 📐 Essential Design Equations for Your Spreadsheet
Total height (H), front face batter, and embedment depth ( Dmincap D sub m i n end-sub He changed the backfill from “select granular” to
The first stage involves defining the physical and material parameters of the wall. Essential inputs usually include:
Creating an MSE wall design spreadsheet requires expertise in civil engineering, specifically in geotechnical engineering and MSE wall design. The spreadsheet should be developed using a spreadsheet software (e.g., Microsoft Excel) and should include: If you are building your own tool or
The true power of an advanced MSE spreadsheet lies in its ability to automate the tedious, iterative optimization process. Instead of manually calculating the required strength for each reinforcement layer (a process that could take hours for a tall wall), the spreadsheet completes the analysis in seconds. It can automatically determine the minimum reinforcement length needed to pass external stability and the most economical combination of reinforcement strength and spacing to satisfy internal stability and connection checks. This efficiency allows the engineer to explore multiple design alternatives—different reinforcement types, varying spacing, or staged construction—in minutes rather than hours.
A spreadsheet can be easily modified to accommodate unique project parameters, such as specific hydrostatic pressures, custom tiered configurations, or localized seismic coefficients. Core Engineering Components of an MSE Wall Spreadsheet
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
Clearly color-code input cells (e.g., yellow) versus calculated result cells (e.g., gray) to prevent accidental deletion of formulas.