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

Foundation Engineering – Bearing Capacity Calculator | Geotechnical Excel Spreadsheets

by

GEOtExcel Foundation Engineering – Bearing Capacity Calculator (Terzaghi Method)

Welcome to GEOtExcel, the most advanced and comprehensive collection of professional geotechnical spreadsheets for foundation engineering. Our Bearing Capacity Calculator spreadsheet set is designed for foundation engineers, geotechnical professionals, and students, featuring solutions and analysis of bearing capacity for various soil types, depth (Df), shear strength (f), and more. This pack allows easy calculation and comparison of bearing capacities based on Terzaghi’s method, as well as methods by Meyerhof, Hansen, and Vesić.

What’s Included in the GEOtExcel Bearing Capacity Calculator Pack?

This collection of 20 specialized spreadsheets is an essential tool for anyone in the field of foundation engineering. The spreadsheets provide:

  1. Problem 01: Problem Page: A foundation has a depth of Df. The soil supporting the foundation is considered for various student IDs.
  2. Bearing Capacity Factors: Bearing-capacity factors for the Terzaghi, Meyerhof, Hansen, and Vesić methods.
  3. Formulas of the Factors: Detailed formulas for each of the bearing-capacity factors.
  4. Formulas for Factors (Image): A graphical representation of the bearing-capacity factors.
  5. Problem 01-Public: Problem Page: A foundation has a depth of Df, with soil considered for public student ID.
  6. Solution: Step-by-step solution to the problem.
  7. Variations: Solution considering the effect of variations in all parameters.
  8. Variations-B: Solution considering the effect of variation in the B parameter along with the graph.
  9. Variations-fi: Solution considering the effect of variation in the f parameter along with the graph.
  10. Variations-B&fi: Solution considering the effect of variation in both B and f parameters with graphs.
  11. Variations-Df: Solution considering the effect of variation in the Df parameter along with the graph.
  12. Variations-C: Solution considering the effect of variation in the C parameter along with the graph.
  13. Variations-gama: Solution considering the effect of variation in the g parameter along with the graph.
  14. Special Cases: Categorization of special cases.
  15. Special-01: Considering the special case where c’ = 0.
  16. Special-02: Considering the special case where Df = 0.
  17. Special-03: Considering the special case where f’ = 0.
  18. Special-04: Considering the special case where c’ = 0 and Df = 0.
  19. Special-05: Considering the special case where Df = 0 and f’ = 0.
  20. General: Comparing the special cases with the general (non-special) case.

Key Features of GEOtExcel:

  • Comprehensive Spreadsheet Collection: 20 advanced spreadsheets covering various aspects of bearing capacity calculations.
  • Solutions for Different Methods: Use Terzaghi, Meyerhof, Hansen, and Vesić methods to solve foundation bearing capacity problems.
  • Parameter Sensitivity Analysis: Investigate how variations in parameters (Df, f, c, B, gama) affect the overall bearing capacity.
  • Special Case Scenarios: Handle special cases such as when parameters are zero, helping you address real-world complexities in soil mechanics.
  • User-Friendly Graphs and Visuals: View the effects of parameter variations with intuitive graphs and charts.

How to Buy GEOtExcel and Use It on Your PC

How to Buy GEOtExcel and Use It on Your PC

Follow GEOtExcel on Social Media:

How to Buy GEOtExcel and Use It on Your PC

by

GEOtExcel (2025-1)

GEOtExcel (2025-1)

We are excited to announce the release of GEOtExcel (2025-1), now more accessible, secure, and permanently usable on your personal computer. Based on valuable user feedback, we’ve enhanced the delivery method. GEOtExcel is now available as an Excel-based desktop application, offering the following advantages:

  • ✅ Lifetime, unlimited access on your personal computer
  • ✅ Save, print, and manage data locally, with no restrictions
  • ✅ No internet or cloud connection required

🔺 Important Note:
The current version (2025-1) is fully functional and permanently usable on the registered computer. Should future versions be released, existing users will enjoy special discounts for upgrading.

📦 How to Order GEOtExcel – Version 2025

To get started, follow these simple steps:

  1. Download and unzip the provided package: Download here The package contains two Excel files:
    • File 1: GET ID
      This file helps you extract your computer’s unique ID. Open it, then click the “Copy Computer ID” button to copy your ID.
    • File 2: Agreement
      This file has 3 sheets:
      • Sheet 1: Price List – Select the GEOtExcel files you wish to purchase; the total price will be automatically calculated.
      • Sheet 2: Customer & PC Info – Fill in your contact details and paste the copied Computer ID.
      • Sheet 3: Agreement – Review and sign the agreement.
  2. Send the completed Agreement file to:
    📧 academy.dr.fahmi@gmail.com

File Safety Assurance

The “Get ID.exe” file and the GEOtExcel files (which will be shared with you after we receive the completed agreement) are all safe. If your antivirus or firewall issues a warning, please rest assured that the files are secure and can be downloaded and run without concern.

You can be fully confident that our support team will assist you throughout the entire process — including payment, installation, and file delivery. If you have any questions, please feel free to ask. We will guide you through the installation process.

Thank you for choosing GEOtExcel.
GEOtExcel Support Team

Agreement Instruction Video

GEOtExcel: Geotechnical Excel Spreadsheets

Soil Mechanics: Effective Stress Concept
Bearing Capacity: Vesic’s method
Understanding Soil Phase
Bearing Capacity Calculation in an Excel spreadsheet
Darcy’s law
Stress Bulb
Soil Mechanics Excel Spreadsheet
Soil Mechanics: Stress Distribution
soil particle distribution curve
plasticity chart using Excel spreadsheet
RQD Calculation (Rock Quality Designation)
Comprehensively learning about Bearing Capacity
Geotechnical Excel Spreadsheets
Flow Net, Flow Rate Calculation, Soil Mechanics
Geotechnical Excel Spreadsheet: Soil Mechanics
Excel Spreadsheets for Geotechnical Engineering
Soil Consolidation, Drainage, Tv

“GEOtExcel-2025-v1” Catalog: Geotechnical Excel Spreadsheets

by

✅ GEOtExcel: Geotechnical Excel Spreadsheets
☑️ [GEO-2025-0101-0140]-Version 2025
☑️ 12 Fields, 40 Files, +470 Excel Spreadsheets
📊 “Developed by GEOtExcel Co., Copyrighted.”
📊 This Educational-Oriented Product Includes: 12 Fields, 40 Files, +470 Excel Spreadsheets

☑️ Video “627-Page Catalog”
☑️ Full video: https://youtu.be/s96jKsjq-D4

GEOtExcel Catalogue-Vesion 2025-High qualityDownload

✅ GEOtExcel YouTube Channel Address:
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
✅ GEOtExcel Company Page Address:
https://www.linkedin.com/company/geotexcel/

✅ This Educational-Oriented Product (Version 2025) Includes: +474 Excel Spreadsheets:
☑️ Foundation Engineering (Shallow & Deep Foundations)
☑️ Soil Mechanics & Soil Mechanics Laboratory
☑️ Rock Mechanics
☑️ Advanced Soil Mechanics

Dear Academics, Engineers, and Enthusiasts!
Stay updated by subscribing — simply send us your email at:
academy.dr.fahmi@gmail.com

✅ This Educational-Oriented Product (Version 2025) Includes: +470 Excel Spreadsheets:
☑️ Foundation Engineering (Shallow & Deep Foundations)
☑️ Soil Mechanics & Soil Mechanics Laboratory
☑️ Rock Mechanics
☑️ Advanced Soil Mechanics

☑️ Group 01: Foundation Engineering – Bearing Capacity
☑️ 5 Files:
[GEO-2025-0101]
Foundation Eng-Bearing Capacity Calculator-Terzaghi
[GEO-2025-0102-A]
Foundation Eng-Bearing Capacity Calculator-All Methods
[GEO-2025-0102-B]
Foundation Eng-Bearing Capacity Calculator-Special Cases
[GEO-2025-0103]
Foundation Eng-Bearing Capacity Calculator-Comprehensive Comparison
[GEO-2025-0104]
Foundation Eng-Bearing Capacity -Hansen-Inclined Load

☑️ Group 02: Foundation Engineering-Deep Foundations
☑️ 1 File:
[GEO-2025-0109]
Foundation Eng-Pile Frictional Resistance

☑️ Group 03: Soil Mechanics – Soil Phase Relationships
☑️ 6 Files:
[GEO-2025-0106]
Soil Mech-Soil Phase Relationships-Excel Spreadsheets
[GEO-2025-0107]
Soil Mechanics-Compaction-Consolidation-Swelling
[GEO-2025-0108]
Soil Phase Relationships-Problem01 & Step-by-Step Solution
[GEO-2025-0109]
Soil Phase Relationships-Problem02 & Step-by-Step Solution
[GEO-2025-0110]
Soil Phase Relationships-Problem03 & Step-by-Step Solution
[GEO-2025-0111]
Soil Phase Relationships-Problem04 & Step-by-Step Solution

☑️ Group 04: Soil Mechanics – Soil Classification
☑️ 7 Files:
[GEO-2025-0112]
Soil Mech-Unified Soil Classification System-USCS-Gravel Examples
[GEO-2025-0113]
Soil Mech-Unified Soil Classification System-USCS-Sand Examples
[GEO-2025-0114]
Soil Mech-Unified Soil Classification System-USCS-Clay&Silt-Plasticity Chart
[GEO-2025-0115]
Soil Mech-Unified Soil Classification System & Hydrometer Analysis-Fat Clay (CH)
[GEO-2025-0116]
Soil Mech-Unified Soil Classification System-USCS-Comparison
[GEO-2025-0117]
Soil Mech-Unified Soil Classification System-USCS-Comparison ith Fuller
[GEO-2025-0118]
Soil Mech-Unified Soil Classification System-USCS-Poorly Graded Soils

☑️ Group 05: Soil Mechanics – Hydrometer Analysis
☑️ 3 Files:
[GEO-2025-0119]
Soil Mech-Analysis of Soil Hydrometer Testing
[GEO-2025-0120]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example1
[GEO-2025-0121]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example2

☑️ Group 06: Soil Mechanics – Effective Stress Concept
☑️ 12 Files:
[GEO-2025-0122-A,B,C & D]
Soil Mech-Effective Stress-Single: (4×5=20 Spreadsheets)
[GEO-2025-0123-A,B,C & D]
Soil Mech-Effective Stress-Double: (4×5=20 Spreadsheets)
[GEO-2025-0124-A &B]
Soil Mech-Effective Stress-Double Layer-GWL Oscillation: (2×8=16 Spreadsheets)
[GEO-2025-0125-A &B]
Soil MechEffect of Surcharge on Effective Stress: (2×8=16 Spreadsheets)

☑️ Group 07: Soil Mechanics – Stress Distribution in Soil
☑️ 5 Files:
[GEO-2025-0126]
Soil Mech-Stress distribution in soil- Boussinesq-Point Load
[GEO-2025-0127]
Soil Mech-Stress distribution in soil- Boussinesq-Strip Loading
[GEO-2025-0128]
Soil Mechanics-Stress distribution in soil-Boussinesq-Rectangular Loading
[GEO-2025-0129-A]
Soil Mech-Stress distribution in Soil- Newmark Method
[GEO-2025-0129-B]
Soil Mech-Stress distribution in Soil- Newmark Method-Concept

☑️ Group 08: Soil Mechanics – Consolidation
☑️ 1 File:
[GEO-2025-0130]
Soil Mech-Consolidation

☑️ Group 09: Soil Mechanics – Shear Strength
☑️ 3 Files:
[GEO-2025-0131]
Soil Mechanics-Shear Strength Problems-Active & Passive
[GEO-2025-0132]
Soil Mech-Triaxial CD Test-Real Results
[GEO-2025-0133]
Soil Mech-Triaxial CU Test-Real Results

☑️ Group 10: Soil Mechanics – Seepage
☑️ 4 Files:
[GEO-2025-0134]
Soil Mechanics-Seepgae-Darcy’s Law
[GEO-2025-0135]
Soil Mechanics-Seepgae-Darcy Law-alpha
[GEO-2025-0136]
Soil Mechanics-Flow Net-Dam
[GEO-2025-0137]
Soil Mechanics-Flow Net & Flow Rate Concept-Dam

☑️ Group 11: Soil Mechanics – Rock Quality Designation (RQD)
☑️ 1 File:
[GEO-2025-0138]
Rock Mechanics & Engineering Geology-RQD

☑️ Group 12: Advanced Soil Mechanics – Critical State Mechanics
☑️ 2 Files:
[GEO-2025-0139]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CD
[GEO-2025-0140]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CU

Dear Academics, Engineers, and Enthusiasts!
Stay updated by subscribing — simply send us your email at:
academy.dr.fahmi@gmail.com

Dr. Ahmad Fahmi
Assistant Professor, The University of Bonab
& CEO of GEOtExcel (KAPA)

A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

by

✅ A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

✅Soil Mechanics & Foundation Engineering: GEOtExcel
Geotechnical Excel Spreadsheets

✅ Watch unique videos on our YouTube channel:
▶️ https://www.youtube.com/@Dr.Fahmi.GEOtExcel

✅ GEOtExcel Website:
▶️ https://geotexcel.com/

✅ Welcome to the GEOtExcel! We’re glad to have you here. I am Dr. Ahmad Fahmi, the inventor of GEOtExcel. As an academic lecturer, researcher and a geotechnical engineer, my unwavering passion lies in revolutionizing geotechnical engineering education through innovation. My team’s work centers around the GeotExcel Project, where we design and develop innovative Geotechnical Excel spreadsheets including :

🔹 Soil mechanics Spreadsheets
🔹 Foundation Engineering Spreadsheets
🔹 Spreadsheets for Geotechnical tests (Soil Mechanics Laboratory)

These interesting tools serve both educational and practical purposes in the field of geotechnical engineering. our vision is to make learning not only informative but also enjoyable. Through the GeotExcel Project, we aim to provide students, educators, and professionals with interactive, user-friendly spreadsheets that enhance the learning and designing experience.
Stay tuned for exciting updates, as we will soon be unveiling a series of free and commercial spreadsheets designed with added features, advanced tools, and dedicated support to meet your specific requirements. Join us on this educational journey, where we transform the way we teach and learn in the realm of geotechnical engineering. Let’s make education a delightful and enriching experience together.

Dr. Ahmad Fahmi
Assistant professor
The University of Bonab

GEOtExcel = Geotechnical Excel Spreadsheets

GEOtExcel for professors & Academic Lectures

GEOtExcel for civil engineering and geotechnical engineering students

GEOtExcel for Geotechnical Engineers

GEOtExcel for Geotechnical Engineers

GEOtExcel for Civil Engineers

GEOtExcel for Geotechnical Engineers (Visit our YouTube channel and LinkedIn page)

A New Revolution in Geotechnical Engineering

Check Out Dr. Fahmi’s First Article on GEOtExcel on LinkedIn:

A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

https://www.linkedin.com/feed/update/urn:li:ugcPost:7276220241121021953

Soil Phase Relationships:

by

Soil Mechanics Lecture

Soil phase relationships describe how solids, water, and air coexist in a given volume of soil and are essential in understanding soil behavior. These relationships are crucial for assessing characteristics like density, porosity, saturation rate, and moisture content, all of which directly impact soil’s engineering performance. By examining the proportions of solids, water, and air, engineers can determine how well the soil can support loads, retain moisture, or drain. Soil that is fully saturated has no air voids, while partially saturated soils contain both air and water within their void spaces. These relationships offer insights into soil’s stability, compressibility, and permeability, which are necessary for effective design in construction and environmental applications.

Watch the Related Videos on Our YouTube Channel (in English):

Soil Phase Relationships

Volume of air in the voids
Volume of water in the voids
Volume of soil solids

The weight of the air is negligible
Weight of water
Weight of soil solids

Total Volume
Volume of voids
Total Weight

The water content (moisture) represents the proportion of water weight to solid weight.

The void ratio represents the proportion of void volume to solid volume.

The porosity represents the proportion of void volume to total volume.

The porosity represents the proportion of void volume to total volume.

The saturation rate represents the proportion of water volume to void volume.

The air content represents the proportion of air volume to void volume.

The percentage air voids represents the proportion of air volume to total volume.

The weight of 1 cubic centimeter of water is 1 gram.

The weight of 1 cubic centimeter of air is negligible

The weight of 1 cubic centimeter of the clay is 2.72 grams (in this example):

Specific Gravity or Relative density of soil solids:

Specific Gravity or Relative density of soil solids:

Phase 1: Unit weight of air
Phase 2: Unit weight of water
Phase 3: Unit weight of soil solids
3-Phase Soil: Unit weight

Dry Unit Weight

Moisture Unit Weight

Saturated Unit Weight

Dry unit weight
Moisture (total) unit weight
Saturated unit weight

w.Gs=Sr.e

Dry unit weight & Moisture (total) unit weight Relationship

✅ Instagram Page Address:
☑ https://www.instagram.com/academy.dr.fahmi
✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering
✅ Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

Bearing Capacity Calculator

by

✅ Calculating Bearing Capacity Using Excel Spreadsheets

✅ Bearing Capacity Calculator

Calculating bearing capacity using Excel spreadsheets is a practical, concept-oriented approach for geotechnical engineers and designers. By organizing key soil parameters such as cohesion, internal friction angle, and unit weight into structured spreadsheets, engineers can streamline complex calculations into manageable, step-by-step processes. Excel allows for the efficient application of various bearing capacity methods, such as Terzaghi, Meyerhof, Hansen and Vesic’s equations, with built-in formulas that simplify the determination of foundation performance under different loading conditions. These methods take into account different factors such as soil type, depth, shape, and load conditions, ensuring comprehensive analysis. The concept-oriented design of the spreadsheet not only clarifies the relationships between variables but also enables easy adjustments to parameters, making it ideal for optimizing designs and testing multiple scenarios. This approach improves both the accuracy of calculations and the clarity of data presentation for project documentation and reporting, while allowing engineers to apply industry-standard methods seamlessly.

Watch the Related Videos on Our YouTube Channel (in English):

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity Calculation in an Excel spreadsheet
Foundation Engineering: Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Comprehensively learning about Bearing Capacity
Geotechnical Excel Spreadsheets

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Excel Spreadsheet: Foundation Engineering, Bearing Capacity, Tezaghi, Vesic, Hansen

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Innovative Excel Spreadsheets
Excel Spreadsheets for Foundation Engineering, Bearing capacity, Terzaghi, Meyerhof, Vesic, Hansen

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Excel Spreadsheets for Geotechnical Engineering
Terzaghi’s Method, Meyerhof’s Method, Vesic’s Method, Hansen’s Method, bearing capacity

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Excel Spreadsheets for Bearing Capacity Comparison
Foundation Engineering Concept in Excel Spreadsheet: Comparison

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering Excel Spreadsheet
Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing capacity
Excel Spreadsheets for Geotechnical Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Excel Spreadsheets for Geotechnical Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity, Rectangle Footing: Foundation Engineering
Excel Spreadsheet for Bearing Capacity Calculation

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Dr.Fahmi.GEOtExcel
Excel Spreadsheets for Geotechnical Engineering, Ultimate Bearing Capacity

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet
Foundation Engineering: Meyerhof’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Bearing capacity: Meyerhof’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity: Meyerhof's Method: Failure Surface
Foundation Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity:
Geotechnical Excel Spreadsheet: Foundation Engineering: Failure Surface

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet / Failure Surface
Meyerhof’s Method: Failure Surface

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity: Meyerhof's Method
Failure Surface/ Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Terzaghi's Method: Strip, Square and Circle Foundations: Excel Spreadsheet
Foundation Engineering Problem & Solution: “Bearing Capacity: Terzaghi’s Method”

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity Excel Sprreadsheets
Bearing Capacity, Terzaghi’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing Capacity Soil mechanics and Foundation Engineering Excel Spreadsheets
Soil mechanics and Foundation Engineering Excel Spreadsheets

✅ Instagram Page Address:
☑ https://www.instagram.com/academy.dr.fahmi
✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering
✅ Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi