Mse Wall Design | Spreadsheet ~upd~
The standard for highway and bridge structures in North America. It applies statistical load factors to various force components (e.g., earth pressure, live load surcharge) and resistance factors to soil-structure interactions. 2. NCMA (National Concrete Masonry Association)
Provide a single, auditable spreadsheet to:
Checks and formulas (per unit length of wall unless otherwise stated):
Use visual anchors—such as green cells for "PASS" and red cells for "FAIL" —to allow engineers to instantly diagnose design vulnerabilities during rapid sizing exercises.
When building or selecting an MSE wall design spreadsheet, it must align with the correct engineering methodology mandated by your project jurisdiction: Allowable Stress Design (ASD) : Applies global Factors of Safety ( FScap F cap S ) to nominal loads and capacities. mse wall design spreadsheet
) utilizing the Mononobe-Okabe equations to calculate dynamic earth pressures.
Metallic strips/grids or geosynthetic geogrids that extend into the backfill to provide tensile strength.
The spreadsheet computes the following external stability checks:
Mechanically Stabilized Earth (MSE) wall design spreadsheets are critical tools for engineers to verify both internal stability The standard for highway and bridge structures in
A well-constructed MSE wall design spreadsheet is typically organized into distinct modules. The first module serves as the input dashboard, where the user defines geometry, soil properties (retained soil, reinforced soil, and foundation soil), and external loading conditions. The power of the spreadsheet lies in its ability to instantly propagate changes from this input module to all subsequent calculations.
Allow the user to specify variable vertical spacing (e.g., closer spacing at the bottom of the wall where lateral pressures are highest).
The spreadsheet calculates factors of safety or demand-capacity ratios for sliding , overturning (eccentricity), and bearing capacity .
Formulas:
Which design standard do you primary follow ( or ASD )?
Tiered walls, complex sloping backfills, and highly irregular surcharges are difficult to model accurately in Excel.
Total and differential settlement of the wall is estimated using classical consolidation or elastic settlement theory, depending on the foundation soil type. The spreadsheet may also compute lateral wall deflection (serviceability check) to ensure it remains within acceptable limits.
Once external stability is satisfied, the spreadsheet evaluates the internal design of the soil reinforcement. This includes: complex sloping backfills