Soil Mechanics – Soil Phase Relationships Calculator | Geotechnical Excel Spreadsheets
[GEO-2025-0106] – By Dr. Ahmad Fahmi
We are proud to introduce one of the most comprehensive Excel spreadsheet packs for Soil Mechanics: the Soil Phase Relationships Calculator, part of the GEOtExcel (2025-1) collection. This package includes 32 educational and professional spreadsheets, offering an in-depth look into the fundamental properties of soil as a three-phase system.
These spreadsheets are essential for students, civil engineers, geotechnical professionals, and lecturers dealing with soil behavior and laboratory testing.
🔍 What’s Included in the 32 Spreadsheets?
- Questions – 32 conceptual and applied questions designed to test and teach soil phase relationship fundamentals.
- Soil Phases 1 – Introduction to the three-phase soil system: solid, liquid, and gas.
- Soil Phases 2 – Continuation of the three-phase system with volumetric relationships.
- Soil Phases 3 – Graphical illustration and conceptual breakdown of soil structure.
- Soil Phases 4 – Final part of the introduction covering real-world soil phase examples.
- SP1 – Volume-based representation of the three-phase soil model.
- SP2 – Weight-based representation of the three-phase soil model.
- SP3 – Total volume, volume of voids, total weight, and how they interact.
- w – Water content (moisture): concept, formula, and example.
- e1 – Void ratio Part 1: Conceptual understanding and base formula.
- e2 – Void ratio Part 2: Extended explanation with examples.
- n – Porosity: Formula and relationship to soil structure.
- e, n – Relationship between void ratio and porosity: mathematical and graphical view.
- Sr – Degree of saturation: what it is, how to calculate it, and its significance.
- ac – Air content: concept and derivation from soil voids.
- na – Percentage air voids: practical computation in different soil states.
- Water – Unit weight of water used in calculations (ρw).
- Air – Unit weight of air (typically negligible, but acknowledged).
- Solid – Unit weight of soil solids (γs) and how to determine it.
- Gs1 – Specific gravity Part 1: Concept and application.
- Gs2 – Specific gravity Part 2: Extended examples and deeper insight.
- 3-Phase Soil – Summary sheet combining all phase-based relationships and equations.
- Gs2 – Different Units – Specific gravity and unit weight conversions across different unit systems.
- DUW – Dry Unit Weight: how to calculate and use it in design.
- MUW – Moist Unit Weight: relationship with water content.
- SUW – Saturated Unit Weight: calculation under fully saturated conditions.
- Unit Weight & Limits – Reference table showing common ranges and practical boundaries for unit weights.
- Graphs1 – Soil Phase Graphs: g–Sr & g–w in g/cm³.
- Graphs2 – Soil Phase Graphs: g–Sr & g–w in kg/m³.
- Graphs3 – Soil Phase Graphs: g–Sr & g–w in kN/m³.
- All – Combined summary of dry, moist, and saturated unit weights.
- w.Gs = Sr.e – The critical identity formula connecting water content, specific gravity, saturation, and void ratio.
📊 Applications in Civil and Geotechnical Engineering
- Teaching soil mechanics
- Lab and report data analysis
- Assignment and quiz design
- Parameter estimation and validation
- Academic and professional research
- Interactive visual modeling of soil states
📦 Part of GEOtExcel (2025-1)
The full GEOtExcel 2025-1 release includes:
- 12 topic categories
- 50 Excel files
- 470+ spreadsheets
- Secure and permanent use
- Commercial license
To receive purchasing info, email:
📧 academy.dr.fahmi@gmail.com
🛒 To Buy GEOtExcel and Use It on Your PC:
👉 How to Buy GEOtExcel and Use It on Your PC
🔗 Follow GEOtExcel on Social Media:
👨🏫 About Dr. Ahmad Fahmi
Assistant Professor, University of Bonab
Creator of GEOtExcel – bridging practical geotechnical analysis with Excel-based tools for learning and professional use.
📌 Subscribe for Upcoming Lectures:
Soil Mechanics | Foundation Engineering | Geotechnical Lab Reports
➡️ Subscribe on YouTube