This Soil-Structure Interaction spreadsheet from 3D-LABS follows ACI 336.2R-88 and gives instant, checkable results for practising engineers — no manual derivation required.
This spreadsheet calculates soil-structure interaction (SSI) spring constants for foundations, buried structures, and retaining walls using Winkler (beam-on-elastic-foundation) and Pasternak models. Spring constants are required as boundary conditions in structural analysis models (STAAD.Pro, SAP2000, ANSYS) when rigid foundation assumption is not valid — typically when the foundation length-to-width ratio > 3 or when differential settlement is critical.
What standard does this calculation follow?
ACI 336.2R-88 (Suggested Analysis and Design Procedures for Combined Footings and Mats), Bowles “Foundation Analysis and Design” 5th Ed., AASHTO LRFD 9th Edition Section 10 (Foundations), Eurocode 7 EN 1997-1:2004 Annex C, and IS 2950:1981 (Code of Practice for Design and Construction of Raft Foundations).
What formula is used?
Vertical spring constant (Winkler): kv = ks × A (kN/m), where ks = coefficient of subgrade reaction (kN/m³) = Es/(B(1-ν²)) × If × Is, Es = soil Young’s modulus (MPa from SPT/CPT), B = foundation width, ν = Poisson’s ratio (0.3–0.5), If = shape factor, Is = depth factor. Typical ks: sand 24,000–80,000 kN/m³; stiff clay 12,000–25,000 kN/m³.
Frequently Asked Questions
How is the Winkler spring constant (subgrade modulus) calculated for a foundation?
Coefficient of subgrade reaction ks = Es / [B(1-ν²)] × If, where Es = soil modulus from pressuremeter or from SPT: Es ≈ (2 to 4) × N60 (MPa) for sand, Es ≈ (0.3 to 0.7) × qu (MPa) for clay (qu = unconfined compressive strength). Foundation spring k = ks × tributary area A (kN/m per node in FE model).
What is the difference between Winkler and Pasternak foundation models?
Winkler model: soil represented by independent springs kv (no interaction between adjacent springs). Simple but overestimates differential settlement. Pasternak (two-parameter) model: adds shear coupling between springs (Gs parameter = ks × h/6 for equivalent shear layer). Pasternak is more realistic for raft foundations; Winkler is adequate for isolated footings and pile caps.
What SPT N-value corresponds to what subgrade modulus for sandy soil?
Per Bowles (1996): ks = 40(N60)^0.75 kN/m³ for square footing on sand, corrected for shape. Direct values: N60 = 10 (loose sand): ks ≈ 24,000 kN/m³; N60 = 30 (medium sand): ks ≈ 58,000 kN/m³; N60 = 50 (dense sand): ks ≈ 96,000 kN/m³. These values assume 1 m × 1 m plate load test reference — scale correction needed for larger footings.
What’s Included
An instant Excel download with the complete formula set, a worked numerical example, and reference to the governing standard — ready to adapt to your own project inputs.
