Mse: Wall Design Spreadsheet !free!

MSE (Mechanically Stabilized Earth) Wall Design Spreadsheet — Structured Document

This document describes a comprehensive spreadsheet structure for designing MSE (reinforced soil) walls. It lists required inputs, calculated outputs, sheet layout, formulas, checks, units, and guidance for use. Use the spreadsheet to organize design parameters, run iterative checks, and produce outputs needed for drawings and reports.

Sheet: Inputs — Project Data & Materials

Columns/fields (single-column list of inputs with units and cell names): mse wall design spreadsheet

  • Project name, location, designer, date
  • Design standards/reference (e.g., FHWA, Eurocode alternative)
  • Safety factors: global phi, bearing FS, reinforcement phi, material factors
  • Wall face type: precast panel / geogrid / geotextile / biodegradable wrap
  • Facing unit weight (if required)
  • Backfill: unit weight γ (kN/m3 or lb/ft3), friction angle φ (deg), cohesion c (kPa or psf), dilation angle ψ
  • Reinforcement: type, allowable tensile strength Trated (kN/m or kN per strip), modulus (if needed), connection capacity
  • Foundation: soil unit weight, φ, c, allowable bearing pressure q_allow, stiffness (for settlement)
  • Groundwater: depth relative to base, pore pressure coefficients
  • Surcharges: uniform surcharge q (kPa), line surcharge or wheel loads
  • Seismic: coefficient (k_h, k_v) or design method (Mononobe-Okabe)
  • Construction tolerances: layer thicknesses, compaction percent
  • Unit conversions and constants (g=9.81)

Include named ranges for key cells to reference across sheets. Sheet: Inputs — Project Data & Materials Columns/fields

3. Methodology & Calculations

Sheet: Geometry

Inputs and calculated geometry parameters: see effect on FS_sliding

  • Wall height H (m)
  • Facing batter (if any) or setback per course
  • Reinforced zone horizontal length Lr (assume 0.7H–1.0H initial)
  • Base width of reinforced zone = Lr
  • Toe and heel lengths relative to wall face
  • Layer thickness (compaction layer) and number of reinforcement layers N = floor(Lr / layer_spacing)
  • Vertical spacing (layer_spacing), typical 0.2–0.4 m
  • Top of wall elevation, bottom elevation
  • Wall face height segments (if stepped)

Formulas:

  • N = ceil(Lr / layer_spacing)
  • Layer elevations = top elevation - layer_spacing * (0..N-1)

6. Example of a Basic Spreadsheet Workflow (Simplified)

  1. Input: Wall height H = 20 ft, reinforcement length L = 14 ft, φ_backfill = 34°, c=0, γ = 120 pcf.
  2. External stability – Calculate Ka, active thrust, check sliding FS = 1.8 → OK.
  3. Internal stability – For each reinforcement layer at 2 ft vertical spacing:
    • Compute σ_h at depth.
    • T_max = σ_h × Sh × Sv.
    • Pullout FS = (2 × Le × σ_v × tanφ) / T_max.
    • If FS < 1.5 → increase L or use stronger reinforcement.
  4. Output table listing each layer’s FS_pullout and FS_rupture.

Sheet: Sensitivity & Design Iterations

  • Parameter sensitivity table: vary embedment length ±10–30%, φ ±2–5°, q_allow ±20%, see effect on FS_sliding, FS_bearing, reinforcement demand.
  • Use data table or scenario rows for quick comparison.
  • Provide recommended final configuration and reasons for change (e.g., increase embedment if pullout margin low).

Typical Default Assumptions (can be changed by user)

  • Layer spacing = 0.3 m
  • Initial Lr = 0.8 * H
  • φ_backfill = 34°
  • γ = 18 kN/m3
  • K_a = tan^2(45 - φ/2)
  • Safety factors: sliding 1.5, overturning 2.0, bearing FS 3.0 (or q_max ≤ q_allow)
  • Seismic coefficients: user-provided (default 0.0)