The design of involves complex calculations for internal and external stability. Using a dedicated spreadsheet is a common way for geotechnical and structural engineers to streamline this process while adhering to AASHTO LRFD or NCMA standards. Core Components of an MSE Wall Design Spreadsheet
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.
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. mse wall design spreadsheet
Calculating the impact of hydrostatic pressure if the drainage system fails.
While often requiring specialized software, many spreadsheets include a preliminary check for deep-seated failure planes. Advantages of Spreadsheet-Based Design The design of involves complex calculations for internal
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).
A robust design tool generally breaks down into four main modules: 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.
The spreadsheet calculates factors of safety or demand-capacity ratios for sliding , overturning (eccentricity), and bearing capacity .
Unlike "black box" commercial software, a spreadsheet allows you to see every formula, making it easier to verify calculations against specific project requirements .