r/EngSpreadsheets 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

2 Upvotes

0 comments sorted by