Geotechnical Excel

Foundation Engineering – Bearing Capacity Calculator (All Methods) | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Calculator (All Methods) | Geotechnical Excel Spreadsheets

[GEO-2025-0102-A] – By Dr. Ahmad Fahmi

We are excited to introduce the Bearing Capacity Calculator spreadsheet pack, which includes the Terzaghi, Vesic, Hansen, and Meyerhof methods for foundation design. This set includes 14 comprehensive spreadsheets designed for geotechnical engineers and foundation design professionals. The pack helps you perform bearing capacity calculations, incorporating shape and depth factors for each method, and provides detailed solutions for various foundation scenarios.

What’s Included in the 14 Spreadsheets?

  1. Start: GEOtExcel: Foundation Engineering – Bearing Capacity Calculator – Overview and introduction sheet.
  2. Problem: Problem page for foundation calculations, considering various student IDs and specifications.
  3. Problem-public: Problem page for public access, tailored for various foundation calculations.
  4. N Factors: Bearing Capacity Factors (Nc, Nq, Ng) – Formulas for all methods.
  5. Bearing-Capacity Factors: Comprehensive calculation of bearing capacity factors (Nc, Nq, Ng) for different scenarios.
  6. Shape & Depth Factors: Comprehensive shape and depth factors for Vesic, Hansen, and Meyerhof methods.
  7. Terzaghi-Layout1: Solution using Terzaghi bearing capacity calculator – Layout 1.
  8. Terzaghi-Layout2: Solution using Terzaghi bearing capacity calculator – Layout 2.
  9. Vesic: Solution using Vesic bearing capacity calculator.
  10. Shape & Depth Factors-(V): Comprehensive shape and depth factors for Vesic method.
  11. Hansen: Solution using Hansen bearing capacity calculator.
  12. Shape & Depth-(H): Comprehensive shape and depth factors for Hansen method.
  13. Meyerhof: Solution using Meyerhof bearing capacity calculator.
  14. Shape & Depth-(M): Comprehensive shape and depth factors for Meyerhof method.

Applications in Foundation Engineering and Geotechnical Engineering:

  • Perform bearing capacity calculations for foundations using the Terzaghi, Vesic, Hansen, and Meyerhof methods.
  • Use shape and depth factors to refine bearing capacity calculations and design more accurate foundations.
  • Tailored calculations for rectangular foundations, circular foundations, and more.
  • Ideal for geotechnical engineers working on foundation design and site investigation.
  • Educational tool for soil mechanics and foundation engineering courses.
  • Use in practical applications such as construction projects, structural design, and civil engineering.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Rock Mechanics & Engineering Geology – Rock Quality Designation (RQD) | Geotechnical Excel Spreadsheets

by

Rock Mechanics & Engineering Geology – Rock Quality Designation (RQD) | Geotechnical Excel Spreadsheets

[GEO-2025-0138] – By Dr. Ahmad Fahmi

We are excited to introduce the Rock Quality Designation (RQD) calculation spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 3 practical spreadsheets designed to help geotechnical engineers, rock mechanics professionals, and students calculate and analyze RQD values for different quality rock samples. The spreadsheets cover Good, Fair, Poor, and Very Poor samples using best practices for accurate RQD determination.

What’s Included in the 3 Spreadsheets?

Start: Introduction to RQD Calculation with key concepts and calculation guidelines.

  1. RQD1-Good&Fair: RQD Calculation for Good and Fair rock samples, with best practices for data input and analysis.
  2. RQD2-Poor&VeryPoor: RQD Calculation for Poor and Very Poor rock samples, providing step-by-step instructions for calculation.

Applications in Rock Mechanics and Engineering Geology:

  • Calculate Rock Quality Designation (RQD) for various rock qualities: Good, Fair, Poor, and Very Poor.
  • Analyze rock quality for geotechnical investigations and foundation design projects.
  • Understand how RQD relates to rock core quality and seepage potential in engineering geology.
  • Educational use for rock mechanics and geotechnical engineering courses.
  • Ideal for field testing and laboratory analysis in rock engineering.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Flow Net Calculation for Dams | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Flow Net Calculation for Dams | Geotechnical Excel Spreadsheets

[GEO-2025-0136] – By Dr. Ahmad Fahmi

We are pleased to introduce the Flow Net Calculation for Dams spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 5 powerful spreadsheets designed for soil mechanics professionals, geotechnical engineers, and students looking to analyze flow channels, potential drops, and piezometer configurations beneath concrete dams.

The pack provides detailed calculations for seepage and flow in the soil under the dam, using the flow net method to model the groundwater flow patterns.

What’s Included in the 5 Spreadsheets?

  1. Start: GEOtExcel: Flow Net Concept & Calculation – Introduction sheet to the flow net concept.
  2. Flow Net 01: Flow channels and potential drops beneath a concrete dam — An example of seepage and flow patterns.
  3. Flow Net 02: Flow channels and potential drops beneath a concrete dam, incorporating fixed piezometers to measure pressure.
  4. Flow Net 03: Flow channels and potential drops beneath a concrete dam
  5. Flow Net 04: Zoomed layout of flow channels and potential drops beneath a concrete dam for a more detailed view.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Flow Net Analysis: Model and analyze flow channels and piezometer readings in soil beneath concrete dams.
  • Seepage & Flow Patterns: Understand seepage and groundwater flow beneath dams for design and construction purposes.
  • Fixed and Movable Piezometers: Learn how to use fixed and movable piezometers to measure pressure and flow beneath structures.
  • Dam Design & Safety: Essential for dam design, seepage control, and ensuring structural safety of dams.
  • Educational Use: A practical tool for soil mechanics and geotechnical engineering courses.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

[GEO-2025-0134] – By Dr. Ahmad Fahmi

We are excited to present the Seepage & Darcy’s Law spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics and geotechnical engineering professionals to analyze and calculate seepage, hydraulic gradient, and flow rate using Darcy’s Law.

What’s Included in the 8 Spreadsheets?

  1. Start: Introduction sheet to Darcy’s Law and seepage analysis.
  2. Darcy’s law-01: Hydraulic gradient concept — Part 1.
  3. Darcy’s law-02: Hydraulic gradient concept — Part 2.
  4. Darcy’s law-03: Darcy’s Law concept — Part 1, with visual explanations.
  5. Darcy’s law-04: Darcy’s Law concept — Part 2, focusing on soil characteristics and flow.
  6. Darcy’s law-05: Darcy’s Law flow rate calculation — Part 1, covering theoretical concepts.
  7. Darcy’s law-06: Darcy’s Law flow rate calculation — Part 2, applying real data.
  8. Darcy’s law-07: Darcy’s Law flow rate calculation — Part 3, advanced application and results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage and Flow Rate Analysis: Calculate flow rate and seepage in soil based on Darcy’s law.
  • Hydraulic Gradient: Understand and apply the hydraulic gradient concept in various soil conditions.
  • Darcy’s Law: Deep dive into Darcy’s law for seepage and fluid flow through porous materials.
  • Practical Tools for soil mechanics and geotechnical engineering projects.
  • Laboratory & Field Testing: Use for soil testing and site investigations in civil and geotechnical projects.
  • Educational Use: Ideal for students, lecturers, and professionals learning and applying seepage analysis.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Triaxial CU Test (Real Results) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Triaxial CU Test (Real Results) | Geotechnical Excel Spreadsheets

[GEO-2025-0133] – By Dr. Ahmad Fahmi

We are proud to introduce the Triaxial CU Test (Real Results) spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This pack includes 4 essential spreadsheets designed to help geotechnical engineers, soil mechanics students, and civil engineers analyze consolidated undrained triaxial test data (CU tests) for accurate soil behavior analysis and calculation of shear strength parameters.

What’s Included in the 4 Spreadsheets?

  1. Start: Summary of Triaxial CU Test Data with key variables and results.
  2. Locked Calculation Sheet: Internal calculation sheet (not for users) for automated data processing.
  3. Data: Consolidated undrained Triaxial Test Data, providing input values and soil test results.
  4. Analysis & Calculations: Triaxial Test (CU) results sheet, including data analysis and calculations for CU test results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Analyze and interpret Triaxial CU Test Data for undrained triaxial tests.
  • Perform data analysis and calculations for shear strength parameters and other test results.
  • Ideal for geotechnical investigations, foundation design, and soil testing.
  • Used for teaching and learning about triaxial test results and soil mechanics.
  • A practical tool for fieldwork and lab testing in geotechnical engineering.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

[GEO-2025-0126] – By Dr. Ahmad Fahmi

We are pleased to introduce the Stress Distribution in Soil (Boussinesq Method) spreadsheet pack, part of the GEOtExcel (2025-1) collection. This pack includes 5 powerful spreadsheets designed for geotechnical engineers, soil mechanics students, and civil engineering professionals who need to analyze stress distribution in soil under a point load using the Boussinesq method. The spreadsheets cover detailed total stress, pore water pressure, effective stress calculations, and provide graphical insights into the stress distribution.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Stress Distribution in Soil using the Boussinesq Method.
  2. Boussinesq: Boussinesq’s Formula for point load stress distribution in soil.
  3. Point Load1: Stress distribution analysis for Point Load with stress-x graph visualization.
  4. Point Load2: Stress distribution analysis for Point Load with z-stress graph.
  5. Pressure Bulb: Pressure bulb analysis for point load stress distribution in soil.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Stress Distribution Analysis: Accurately calculate stress distribution in soil using the Boussinesq method.
  • Point Load Analysis: Determine the effects of point load on stress distribution in soil layers.
  • Graphical Representation: Visualize stress-x and z-stress graphs for better understanding of soil behavior.
  • Pressure Bulb Analysis: Analyze and visualize the pressure bulb around a point load in soil.
  • Teaching & Learning Tool: Ideal for soil mechanics and geotechnical engineering education and practical use.
  • Field Work & Lab Testing: Use for site investigations and laboratory experiments to analyze soil response under load.

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 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, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in integrating Excel-based solutions with soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics

Foundation Engineering

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

by

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

[GEO-2025-0122] – By Dr. Ahmad Fahmi

We are excited to present the Effective Stress for Single Layer Soil Profile spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 20 sheets, designed for geotechnical engineers, soil mechanics students, and civil engineers looking to calculate and visualize effective stress in a single-layer soil profile. The pack includes essential calculations and graphs for total stress, pore water pressure, and effective stress in both kg/m² and kN/m² units.

What’s Included in the 20 Spreadsheets?

  1. Start: Introduction sheet for Effective Stress calculations (kg-Layout 1).
  2. Single Layer-kg: Main sheet explaining the Effective Stress concept for a single-layer profile in kg/m².
  3. TS-01: Calculation Sheet 1 for Total Stress calculation and associated graph.
  4. u-01: Calculation Sheet 2 for Pore Water Pressure calculation and graph.
  5. ES-01: Calculation Sheet 3 for Effective Stress calculation and graph.
  6. [GEO-2025-0122-A] – kg-Layout 1: Effective Stress layout for kg/m².
  7. [GEO-2025-0122-B] – kg-Layout 2: Second layout for Effective Stress using kg/m².
  8. [GEO-2025-0122-C] – kN-Layout 1: Effective Stress layout for kN/m².
  9. [GEO-2025-0122-D] – kN-Layout 2: Second layout for Effective Stress using kN/m².

Applications in Soil Mechanics and Geotechnical Engineering:

  • Performing effective stress analysis in single-layer soil profiles
  • Calculating and visualizing total stress, pore water pressure, and effective stress
  • Teaching and learning about effective stress concepts in soil mechanics
  • Suitable for geotechnical testing, field work, and laboratory experiments
  • Ideal for use in civil engineering projects and foundation design
  • Comprehensive graphs for visual understanding and data interpretation

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 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, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

[GEO-2025-0119] – By Dr. Ahmad Fahmi

We are pleased to introduce the Soil Hydrometer Testing Analysis spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 7 comprehensive spreadsheets designed for geotechnical engineers and soil mechanics students to perform hydrometer analysis and determine soil properties such as effective depth, k-value, and temperature correction factors.

What’s Included in the 7 Spreadsheets?

  1. Start: The introductory sheet to begin the hydrometer analysis for soil.
  2. Calculation: Comprehensive sheet for input, computation, and output tables for the soil hydrometer analysis process.
  3. Table 1: Table for Effective Depth (L) determination based on actual hydrometer reading (RC1).
  4. Table 2: Table for k-value determination based on Gs (specific gravity) and temperature in soil hydrometer analysis.
  5. Table 2-Full: Expanded version of Table 2 for more detailed k-value determination.
  6. Table 3: Sheet for determining the Temperature Correction Factor (CT) during soil hydrometer analysis.
  7. Table 3-Full: Extended version of Table 3 for accurate temperature correction factor determination.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Perform soil classification tests using hydrometer analysis
  • Accurately determine soil’s effective depth and specific gravity (Gs)
  • Calculate k-value based on real lab data
  • Apply temperature correction factor (CT) to soil behavior analysis
  • Educational use for soil mechanics and geotechnical engineering courses
  • Useful for soil testing and lab experiments

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 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, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in integrating Excel-based solutions with soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Unified Soil Classification System (USCS) | Gravel Soil Examples | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Unified Soil Classification System (USCS) Gravel Soil Examples | GEOtExcel Spreadsheets

[GEO-2025-0112] – By Dr. Ahmad Fahmi

We are excited to introduce the Unified Soil Classification System (USCS) Gravel Soil Examples spreadsheet pack as part of the GEOtExcel (2025-1) collection. This 20-sheet bundle is designed for geotechnical engineers, soil mechanics students, and civil engineering professionals looking to classify gravel soils using the USCS system based on sieve analysis and Atterberg limits.

What’s Included in the 20 Spreadsheets?

  1. DATA: Unified Soil Classification System data series with sieve analysis and Atterberg limits.
  2. Data Form: Standardized data form for sieve analysis and Atterberg limits tests.
  3. Analysis Sheet-Empty: Empty sheet template for soil classification based on USCS data.
  4. USCS: USCS process table to help classify soil types based on test results.
  5. Examples: Example table with five examples of gravel soils classification using USCS.
  6. Example 1 – GW: Well-graded gravel classification.
  7. F1: Data form for sieve analysis and Atterberg limits for Example 1: GW.
  8. S1: Soil classification analysis sheet for Example 1: GW based on USCS.
  9. Problem 2 – GP: Well-graded gravel classification example.
  10. F2: Data form for sieve analysis and Atterberg limits for Example 2: GP.
  11. S2: Analysis for soil classification for Example 2: GP.
  12. Problem 3 – GC: Gravelly clay soil example.
  13. F3: Data form for sieve analysis and Atterberg limits for Example 3: GC.
  14. S3: Analysis for soil classification for Example 3: GC.
  15. Problem 4 – GW-GM: Well-graded gravel-silty gravel example.
  16. F4: Data form for sieve analysis and Atterberg limits for Example 4: GW-GM.
  17. S4: Analysis for soil classification for Example 4: GW-GM.
  18. Problem 5 – GP-GC: Well-graded gravel-clay gravel example.
  19. F5: Data form for sieve analysis and Atterberg limits for Example 5: GP-GC.
  20. S5: Analysis for soil classification for Example 5: GP-GC.

Applications in Geotechnical and Civil Engineering:

  • Classification of gravel soils for construction projects
  • Performing sieve analysis and Atterberg limits tests
  • Understanding and applying the USCS soil classification system
  • Preparing data forms and analysis sheets for soil lab work
  • Teaching soil mechanics and geotechnical courses
  • Research and fieldwork in soil behavior and composition

📦 Part of the GEOtExcel 2025-1 Collection

This product is part of the comprehensive GEOtExcel (2025-1) package, featuring:

  • 12 groups
  • 50 files
  • Over 470 spreadsheets
  • Secure, permanent access
  • Available for purchase with a commercial license

For inquiries or to purchase, please contact:
📧 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, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for geotechnical engineering, soil mechanics, and foundation engineering.

📌 Stay Updated:

Subscribe to our channel for upcoming video lectures on:

Soil Mechanics – Soil Phase Relationships Calculator | Geotechnical Excel Spreadsheets

by

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?

  1. Questions – 32 conceptual and applied questions designed to test and teach soil phase relationship fundamentals.
  2. Soil Phases 1 – Introduction to the three-phase soil system: solid, liquid, and gas.
  3. Soil Phases 2 – Continuation of the three-phase system with volumetric relationships.
  4. Soil Phases 3 – Graphical illustration and conceptual breakdown of soil structure.
  5. Soil Phases 4 – Final part of the introduction covering real-world soil phase examples.
  6. SP1 – Volume-based representation of the three-phase soil model.
  7. SP2 – Weight-based representation of the three-phase soil model.
  8. SP3 – Total volume, volume of voids, total weight, and how they interact.
  9. w – Water content (moisture): concept, formula, and example.
  10. e1 – Void ratio Part 1: Conceptual understanding and base formula.
  11. e2 – Void ratio Part 2: Extended explanation with examples.
  12. n – Porosity: Formula and relationship to soil structure.
  13. e, n – Relationship between void ratio and porosity: mathematical and graphical view.
  14. Sr – Degree of saturation: what it is, how to calculate it, and its significance.
  15. ac – Air content: concept and derivation from soil voids.
  16. na – Percentage air voids: practical computation in different soil states.
  17. Water – Unit weight of water used in calculations (ρw).
  18. Air – Unit weight of air (typically negligible, but acknowledged).
  19. Solid – Unit weight of soil solids (γs) and how to determine it.
  20. Gs1 – Specific gravity Part 1: Concept and application.
  21. Gs2 – Specific gravity Part 2: Extended examples and deeper insight.
  22. 3-Phase Soil – Summary sheet combining all phase-based relationships and equations.
  23. Gs2 – Different Units – Specific gravity and unit weight conversions across different unit systems.
  24. DUW – Dry Unit Weight: how to calculate and use it in design.
  25. MUW – Moist Unit Weight: relationship with water content.
  26. SUW – Saturated Unit Weight: calculation under fully saturated conditions.
  27. Unit Weight & Limits – Reference table showing common ranges and practical boundaries for unit weights.
  28. Graphs1 – Soil Phase Graphs: g–Sr & g–w in g/cm³.
  29. Graphs2 – Soil Phase Graphs: g–Sr & g–w in kg/m³.
  30. Graphs3 – Soil Phase Graphs: g–Sr & g–w in kN/m³.
  31. All – Combined summary of dry, moist, and saturated unit weights.
  32. 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