Mse Wall Design Spreadsheet Jun 2026
An automated Excel sheet relies on specific mathematical relationships. Below are the core formulas your spreadsheet formulas must execute: Rankine Active Earth Pressure
): Friction angle, unit weight, and cohesion of the bearing stratum. Tab 3: Geometric & Loading Inputs Total wall height ( ) and embedment depth ( Reinforcement length ( )—typically initialized at a minimum of 0.7H0.7 cap H Surcharge loads: Constant dead load surcharge ( ) and temporary live load surcharge ( Backslope angle ( ) if the terrain rises behind the wall crest. Tab 4: Earth Pressure Calculations
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. mse wall design spreadsheet
: Analysis of additional horizontal forces generated during earthquake events. 3. Output and Optimization
) is less than the factored long-term allowable design strength ( Talcap T sub a l end-sub Computes the embedment length ( Lecap L sub e An automated Excel sheet relies on specific mathematical
Creating a is a classic journey from engineering chaos to professional precision. Here is the "story" of how such a tool typically evolves from a blank Excel sheet to a critical project asset. Chapter 1: The Mountain of Manual Math
If any check fails, the spreadsheet suggests adjustments (e.g., increasing ( L )) and recalculates automatically. Tab 4: Earth Pressure Calculations Computes the high
State DOTs are a major source for official, standardized design tools.
These ensure the wall behaves as a rigid block:
