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.
Spreadsheets use iterative searching for the critical failure plane (typically bilinear, per AASHTO). mse wall design spreadsheet
The third module addresses internal stability. Here, the spreadsheet calculates the tensile forces at each reinforcement level and the required pullout length. Advanced spreadsheets utilize macros or scripting to optimize reinforcement spacing—perhaps suggesting closer spacing near the top of the wall where surcharge loads are high, or increasing reinforcement length at the base to improve bearing capacity. These calculations are heavily dependent on variable inputs:
A professional-grade spreadsheet typically automates the following three core design stages: 1. Input and Geometry Definition mse wall design spreadsheet
To get accurate results, you need to define three distinct soil zones:
Copyright (c) 2011 - , All rights reserved