The spreadsheet uses classical soil mechanics, typically utilizing or Rankine’s earth pressure theories, to calculate: Active earth pressure coefficient ( Kacap K sub a Horizontal and vertical components of earth thrust (
Using a structured Excel spreadsheet provides several advantages over manual calculations or expensive, complex FEA software for routine projects:
) based on laboratory testing data for the specific block-grid combination, accounting for the confining pressure at that specific layer depth. 5. Summary and Output Sheet
An serves as a vital tool for engineers to automate these iterative calculations, ensuring compliance while optimizing material usage. Core Functionality of an MSE Wall Design Spreadsheet mse wall design spreadsheet
MSE wall design spreadsheets have a wide range of applications in various fields, including:
As a rule of thumb, start with a minimum reinforcement length ( ) equal to (70% of the wall height), or a minimum of Step 3: Compute External Safety Factors
External stability treats the reinforced soil mass as a coherent rigid gravity block. Core Functionality of an MSE Wall Design Spreadsheet
The standard required by AASHTO for highway projects. It applies separate factors to individual loads and material resistances.
Full control, educational value, no cost. Cons: Time-consuming (30+ hours for a robust version), risk of hidden bugs, requires validation against benchmark examples.
) for three distinct zones: reinforced fill, retained backfill, and foundation soil. Full control, educational value, no cost
$0 (limited) to $500–$1500 for fully featured, LRFD-compliant versions.
Real-time feedback on whether the design meets code requirements.