) of the resultant force must fall within the middle third (or middle half for rock foundations) of the base width (
) and the required tensile strength of the geogrid reinforcements. Tired of the repetitive math, they open Excel. Chapter 2: The Logic of Layers
The pressure exerted on the foundation soil must not exceed its allowable bearing capacity.
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 mse wall design spreadsheet
🧵 5 reasons every Geotech should have a solid MSE Wall Design Spreadsheet:
Ensure all formulas align with AASHTO LRFD Bridge Design Specifications or NCMA Segmental Retaining Wall standards.
Always ensure that any spreadsheet used in production has been thoroughly benchmarked against known hand-calculation solutions, and that the final designs are signed and sealed by a . ) of the resultant force must fall within
A robust design spreadsheet is divided into distinct modular tabs or sections to keep data organized and easily auditable. Input Data Module : Total wall height ( ), embedment depth ( ), backslope angle ( ), and batter angle ( Soil Properties : Unit weight ( ), friction angle ( ), and cohesion (
The spreadsheet must evaluate the Capacity Demand Ratio (CDR), ensuring it is greater than or equal to 1.0. Step-by-Step Blueprint to Build the Spreadsheet
Engineers can easily adapt the sheet to specific project specifications or regional design codes. Core Design Methodologies and Codes As a rule of thumb, start with a
Spreadsheets use iterative searching for the critical failure plane (typically bilinear, per AASHTO).
And Marcus was doing it all by hand.
: Federal Highway Administration (FHWA) manuals and associated spreadsheets, such as the FHWA-RD-89-193 method
An is indispensable for efficient geotechnical engineering. By automating the intensive calculations for external and internal stability, engineers can focus on optimizing designs for safety and cost-effectiveness. Whether using uniaxial polyester geogrid for reinforcement or designing for significant traffic surcharges, a well-built Excel tool streamlines the process, leading to robust, secure, and cost-efficient retaining walls. Need an optimized MSE wall design? Compare different geogrid strengths for a 5-meter wall.
: While not a traditional spreadsheet, this free software is widely used by engineers for Presto Geosystems' GEOWEB®