If the project is in a high-risk zone, the tool must incorporate Mononobe-Okabe equations.
Once the template is built, you can perform "what-if" analyses—such as changing the geogrid length or reinforcement type —to find the most cost-effective design in seconds.
Spreadsheets provide a clear, printable calculation log that is essential for Quality Assurance (QA) and submission to regulatory agencies. Essential Calculations to Include When building or selecting a spreadsheet, ensure it covers: Earth Pressure Coefficients ( Kacap K sub a ): Accounting for backfill slope and wall friction. mse wall design spreadsheet
A robust design tool generally breaks down into four main modules:
This section defines the geometry (wall height, batter, and surcharge), soil properties (friction angle and unit weight for reinforced, retained, and foundation soils), and reinforcement specs (geogrid or metallic strap strength). If the project is in a high-risk zone,
The spreadsheet calculates factors of safety or demand-capacity ratios for sliding , overturning (eccentricity), and bearing capacity .
Calculating the impact of hydrostatic pressure if the drainage system fails. Essential Calculations to Include When building or selecting
This involves checking the reinforcement for tensile resistance and pullout resistance at each layer, ensuring the spacing is sufficient to hold the soil mass together.
Unlike "black box" commercial software, a spreadsheet allows you to see every formula, making it easier to verify calculations against specific project requirements .