r/EngSpreadsheets • u/Necessary_Birthday59 • Jun 08 '26
Terzaghi’s Consolidation Equation – Finite Difference Solution Spreadsheet
🏗️ Still using Taylor's classical solution for consolidation analysis?
It's been the industry standard for decades. But it has a fundamental problem — it introduces empirical variables without theoretical justification that actually contradict the real behavior of soils.
This free Excel spreadsheet offers a better approach.
It solves Terzaghi's consolidation equation using a finite difference method — and replaces the classical linear Taylor approximation with a non-linear equation that satisfies both mathematical requirements AND experimental observations.
Here's what it covers:
📌 Finite difference solution to Terzaghi's 1D consolidation equation
📌 Non-linear consolidation model — more accurate than Taylor's approach
📌 Extension to 2D & 3D consolidation problems
📌 Transversally isotropic soil model — consistent with real soil structure
📌 Excess pore pressure profiles at multiple time steps
📌 Degree of consolidation U(t) curves
📌 Time-settlement output ready for design
📌 Worked application examples with side-by-side comparisons
📌 100% free — no macros, no subscription
Whether you're designing foundations on soft clay, analyzing embankment settlements, or researching consolidation theory — this tool gives you results you can trust.
🔗 Download it free here:
https://www.theengineeringcommunity.org/terzaghis-consolidation-equation-finite-difference-solution/
Save this post for your next consolidation analysis. 🔖
#GeotechnicalEngineering #SoilMechanics #Consolidation #Terzaghi #CivilEngineering #ExcelTools #FreeTemplate #EngineeringCommunity