GEOtExcel

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension) | Geotechnical Excel Spreadsheets

by

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension)

[GEO-2025-0131]

We are pleased to present the Deviatoric Stress at Active and Passive Failure States spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set of 4 powerful spreadsheets enables soil mechanics professionals, students, and geotechnical engineers to calculate deviatoric stress at the active and passive failure states of soil under compression and tension conditions.

The pack also includes tools to calculate failure surfaces and provides a comprehensive solution for analyzing soil behavior under different failure conditions, making it essential for foundation design and soil stability analysis.

What’s Included in the 4 Spreadsheets?

  1. Problem1: Determining Deviatoric Stress at Active Failure State of Soil – Calculate deviatoric stress for the active failure state of soil under compression.
  2. Problem2: Determining Deviatoric Stress at Passive Failure State of Soil – Calculate deviatoric stress for the passive failure state of soil under tension.
  3. Solution: Determining Deviatoric Stress at Soil Failure – Comprehensive solution for calculating deviatoric stress at active and passive failure states of soil.
  4. Failure Surface: Determining Failure Surface – Analyze and calculate the failure surface for soil under both compression and tension.

Applications in Soil Mechanics and Geotechnical Engineering:

Deviatoric Stress Calculation: Accurately calculate deviatoric stress at active and passive failure states of soil for both compression and tension conditions.

  • Failure State Analysis: Understand and analyze the active and passive failure states in soil mechanics.
  • Failure Surface Calculation: Calculate and visualize failure surfaces for soil under load conditions, aiding in foundation design and soil stability assessments.
  • Practical Use: Ideal for geotechnical engineers, soil mechanics professionals, and students working on soil behavior and failure analysis in foundation design.
  • Educational Tool: A valuable teaching aid for soil mechanics and geotechnical engineering courses focused on failure states and stress 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 – Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis | Geotechnical Excel Speadsheets

by

Soil Mechanics – Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis | Example 2 (GP-GM Soil)

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

We are pleased to introduce Example 2 (GP-GM Soil) from our Complete Soil Gradation Curve series. This set of Geotechnical Excel Spreadsheets includes 10 powerful spreadsheets for analyzing sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils (Gravelly Poorly Graded Sand and Gravel Mixture). These spreadsheets also include k-value determination and the calculation of temperature correction factors.

This set is ideal for soil mechanics professionals, students, and geotechnical engineers involved in soil classification, foundation design, and site investigations.

What’s Included in the 10 Spreadsheets?

  1. Start: Hydrometer Analysis of GP-GM Soil – Introduction sheet for analysis of GP-GM soils.
  2. Input Data: Sieve and Hydrometer Test Data – Enter the data from the sieve and hydrometer tests for full analysis.
  3. Sieve Analysis: Sieve Analysis Table and corresponding gradation curve for GP-GM soil.
  4. Hydrometer Analysis: Detailed hydrometer analysis tables for soil gradation calculations.
  5. Sieve & Hydrometer Analysis: Combining sieve and hydrometer data for full gradation analysis.
  6. USCS: Unified Soil Classification System (USCS Process Table) – Soil classification based on the USCS system.
  7. Important Note: Hydrometer test results are also necessary for accurate analysis in this particular example.
  8. Table 1: k-Value Determination based on Gs and temperature in soil hydrometer analysis.
  9. Table 2: Another k-Value Determination table for additional soil analysis.
  10. Table 3: Temperature Correction Factor (CT) determination for hydrometer analysis.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Gradation Analysis: Combine sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils.
  • Soil Classification: Classify soil using the Unified Soil Classification System (USCS) based on test data.
  • k-Value Determination: Accurately calculate k-values for soil hydrometer analysis based on specific gravity (Gs) and temperature.
  • Temperature Correction: Use the temperature correction factor (CT) to adjust for temperature variations in hydrometer analysis.
  • Practical Use: Essential for soil testing, foundation design, site investigations, and geotechnical analysis.
  • Educational Tool: Ideal for soil mechanics and geotechnical engineering students and professionals to understand soil behavior and gradations.

📦 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:

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

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

We are pleased to present the Bearing Capacity Comparison of Classic Methods spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This comprehensive set includes 15 powerful spreadsheets designed to help soil mechanics professionals and students compare bearing capacity using the classic methods of Terzaghi, Vesic, and Meyerhof. The pack allows you to calculate bearing capacity factors, shape and depth factors, and analyze solutions for different foundation types.

These spreadsheets are essential for foundation engineers, geotechnical engineers, and students who need to understand and apply these classic methods for real-world foundation design.

What’s Included in the 15 Spreadsheets?

  1. Start: GEOtExcel: Foundation Engineering-Bearing Capacity Calculator – Comprehensive Comparison – Overview and introduction sheet.
  2. Problem: A rectangular foundation with width B, length L, and other parameters for various student IDs.
  3. Problem-public: Rectangular foundation analysis for public student ID.
  4. Comprehensive Comparison: Comprehensive Bearing Capacity Comparison using Terzaghi, Vesic, and Meyerhof methods.
  5. N Factors: Bearing Capacity Factors (Nc, Nq, and Ng) – Formulas for calculating key bearing capacity factors.
  6. Bearing-Capacity Factors: Comprehensive Bearing Capacity Factors calculation for Terzaghi, Vesic, and Meyerhof methods.
  7. Shape & Depth Factors: Comprehensive Shape and Depth Factors for Vesic, Hansen, and Meyerhof methods.
  8. Terzaghi: Solution Using Terzaghi Bearing Capacity Calculator – Layout 1 for a rectangular foundation.
  9. Vesic1: Solution Using Vesic Bearing Capacity Calculator for a rectangular foundation.
  10. Vesic2: Solution Using Vesic Bearing Capacity Calculator – Layout 2 for a more detailed analysis.
  11. Shape & Depth Factors-(V): Comprehensive Shape and Depth Factors for Vesic’s Method.
  12. Hansen: Solution Using Hansen Bearing Capacity Calculator for a rectangular foundation.
  13. Shape & Depth-(H): Comprehensive Shape and Depth Factors for Hansen’s Method.
  14. Meyerhof: Solution Using Meyerhof Bearing Capacity Calculator for a rectangular foundation.
  15. Shape & Depth-(M): Comprehensive Shape and Depth Factors for Meyerhof’s Method.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Bearing Capacity Comparison: Compare Terzaghi, Vesic, and Meyerhof methods for estimating foundation bearing capacity.
  • Practical Solutions: Use comprehensive solutions and calculations for rectangular foundations and varying foundation depths.
  • Bearing Capacity Factors: Calculate Nc, Nq, and Ng bearing capacity factors for accurate foundation design.
  • Shape and Depth Factors: Understand how shape and depth factors influence bearing capacity in each method.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses on foundation design and bearing capacity analysis.
  • Real-World Application: Essential for geotechnical engineers, foundation design, and site investigations.

📦 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 – Complete Soil Gradation Curve Using Sieve and Hydrometer | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Complete Soil Gradation Curve Using Sieve and Hydrometer | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Complete Soil Gradation Curve Using Sieve and Hydrometer spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed to help soil mechanics professionals and students analyze and calculate the gradations of soil using sieve analysis and hydrometer tests.

These spreadsheets allow you to combine data from both sieve and hydrometer tests to create a full gradation curve for soil, and to calculate other crucial parameters like k-value and temperature correction factors for more accurate results.

What’s Included in the 8 Spreadsheets?

  1. Start: Hydrometer Analysis of Clayey Sand Soil – Introduction sheet to the analysis.
  2. Input Data: Sieve and Hydrometer Test Data – Input your data for analysis.
  3. Sieve Analysis: Sieve Analysis Table and corresponding gradation curve.
  4. Hydrometer: Hydrometer Analysis Tables for detailed results.
  5. Combination: Combining Sieve and Hydrometer data for complete gradation analysis.
  6. Table 1: k-Value Determination based on Gs and temperature in soil hydrometer analysis.
  7. Table 2: Another k-Value Determination table for more specific soil analysis conditions.
  8. Table 3: Temperature Correction Factor (CT) determination.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Gradation Analysis: Combine data from sieve and hydrometer tests to generate a complete gradation curve.
  • Accurate Soil Analysis: Determine k-values and temperature correction factors for more precise soil behavior prediction.
  • Sieve and Hydrometer Data: Analyze sieve analysis and hydrometer test data for soil classification.
  • Educational Tool: Ideal for soil mechanics and geotechnical engineering courses.
  • Practical Applications: Useful for soil testing, geotechnical investigations, and foundation design.

📦 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 – Unified Soil Classification System (USCS) – Sand Examples | Geotechnical Excel Spreadsheets

by

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

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

We are excited to present the Unified Soil Classification System (USCS) spreadsheet pack for sand examples, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 20 powerful spreadsheets that guide you through soil classification using the USCS method. The pack includes practical sand soil classification examples, providing detailed data entry and analysis for sieve analysis and Atterberg limits testing, crucial for geotechnical investigations and foundation design.

What’s Included in the 20 Spreadsheets?

  1. DATA: Unified Soil Classification System (USCS) – Five data series including sieve analysis and Atterberg limits.
  2. Data Form: Data form for sieve analysis and Atterberg limits tests.
  3. Analysis Sheet-Empty: Soil classification analysis sheet for USCS, based on sieve analysis and Atterberg limits data.
  4. USCS: USCS process table for soil classification.
  5. Examples: Example table showing five sand soil classification examples.
  6. Example 1: Example for SW: Well Graded Sand.
  7. F1: Data form for sieve analysis and Atterberg limits tests for Example 1: SW.
  8. S1: Analysis for soil classification on USCS for Example 1: SW.
  9. Problem 2: Example for SP: Well Graded Sand.
  10. F2: Data form for sieve analysis and Atterberg limits tests for Example 2: SP.
  11. S2: Analysis for soil classification on USCS for Example 2: SP.
  12. Problem 3: Example for SC: Well Graded Sand.
  13. F3: Data form for sieve analysis and Atterberg limits tests for Example 3: SC.
  14. S3: Analysis for soil classification on USCS for Example 3: SC.
  15. Problem 4: Example for SW-SC: Well Graded Gravel.
  16. F4: Data form for sieve analysis and Atterberg limits tests for Example 4: SW-SC.
  17. S4: Analysis for soil classification on USCS for Example 4: SW-SC.
  18. Problem 5: Example for SP-SC: Well Graded Sand.
  19. F5: Data form for sieve analysis and Atterberg limits tests for Example 5: SP-SC.
  20. S5: Analysis for soil classification on USCS for Example 5: SP-SC.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Perform soil classification using the USCS method for sand soils and other soil types.
  • Sieve analysis and Atterberg limits tests to determine soil properties and classify soil types.
  • Detailed examples and data forms to guide you through the process of soil classification.
  • Ideal for geotechnical engineers, civil engineers, and students working on soil classification and foundation design.
  • Practical tool for soil mechanics laboratories and field investigations.
  • Educational use in 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 – Compaction, Consolidation & Swelling | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Compaction, Consolidation & Swelling | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Compaction, Consolidation, and Swelling spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 11 valuable spreadsheets for soil mechanics professionals and students, designed to explain and calculate the processes of compaction, consolidation, and swelling in soils under different moisture conditions.

This pack helps you understand soil behavior under varying compaction scenarios and their effects on soil properties, offering insights into practical applications and theoretical calculations.

What’s Included in the 11 Spreadsheets?

  1. Start: GEOtExcel: Compaction, Consolidation, and Swelling – Overview and introduction sheet.
  2. Compaction1: Compaction Concept – Expulsion of air from soil voids, Layout 1.
  3. Compaction2: Compaction Concept – Expulsion of air from soil voids, Layout 2.
  4. Compaction3: Compaction Concept – Expulsion of air from soil voids, Layout 3.
  5. Example1: Compaction Concept Example – For dry soil conditions.
  6. Example2: Compaction Concept Example – For slightly moist soil conditions.
  7. Example3: Compaction Concept Example – For moderately moist soil conditions.
  8. Example4: Compaction Concept Example – For lightly moist soil conditions.
  9. Example5: Compaction Concept Example – For saturated soil conditions.
  10. Consolidation: Consolidation Concept – Theory and calculation for soil consolidation.
  11. Swelling: Swelling Concept – For sand and clay soils, covering volume changes and behaviors.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Compaction: Calculate and visualize how air expulsion affects soil density in different moisture conditions.
  • Consolidation Analysis: Understand and calculate soil consolidation over time under applied pressure.
  • Swelling Behavior: Analyze the swelling potential of sand and clay soils, crucial for foundation design and site investigations.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses.
  • Practical Tool: Use for field testing, laboratory analysis, and geotechnical site investigations.
  • Comprehensive Examples: Detailed examples for a wide range of soil moisture conditions, helping students and professionals apply the concepts in real-world scenarios.

📦 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:

Foundation Engineering – Bearing Capacity Calculator (Special Cases) | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Calculator (Special Cases) | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Bearing Capacity Calculator (Special Cases) spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 25 essential spreadsheets designed for geotechnical engineers and foundation design professionals who need to calculate bearing capacity for special cases. The pack covers Terzaghi and Vesic methods with additional calculations for unique soil and foundation conditions such as undrained soils, non-cohesive soils, and zero foundation depth.

What’s Included in the 25 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. Bearing-Capacity Factors: Nc, Nq, and Ng – Formulas and comprehensive calculation for different cases.
  5. Special Cases-Terzaghi: Bearing capacity for special cases using Terzaghi’s Method.
  6. Original-T0: Terzaghi’s Method (Original) for bearing capacity calculations.
  7. Specail-T1: Undrained Soil Conditions (f’ = 0) – Special case for Terzaghi’s Method.
  8. Specail-T2: Non-Cohesive Soils (c’ = 0) – Special case for Terzaghi’s Method.
  9. Specail-T3: Zero Foundation Depth (Df = 0) – Special case for Terzaghi’s Method.
  10. Specail-T4: Combination1: (c’ = 0 & Df = 0) – Special case for Terzaghi’s Method.
  11. Specail-T5: Combination2: (Df = 0 & f’ = 0) – Special case for Terzaghi’s Method.
  12. Special Cases-Vesic: Bearing capacity for special cases using Vesic’s Method.
  13. Original-V0: Vesic’s Method (Original) for bearing capacity calculations.
  14. Specail-V1: Undrained Soil Conditions (f’ = 0) – Special case for Vesic’s Method.
  15. Specail-V2: Non-Cohesive Soils (c’ = 0) – Special case for Vesic’s Method.
  16. Specail-V3: Zero Foundation Depth (Df = 0) – Special case for Vesic’s Method.
  17. Specail-V4: Combination1: (c’ = 0 & Df = 0) – Special case for Vesic’s Method.
  18. Specail-V5: Combination2: (Df = 0 & f’ = 0) – Special case for Vesic’s Method.
    19-25. S&D (0-5) Vesic: Shape and depth factors for Vesic’s Method (Used in sheets 13-18).

Applications in Foundation Engineering and Geotechnical Engineering:

  • Perform bearing capacity calculations for foundations using Terzaghi’s and Vesic’s methods for both standard and special cases.
  • Calculate for undrained soils, non-cohesive soils, and zero foundation depth conditions.
  • Use shape and depth factors to enhance bearing capacity calculations and adapt them to specific conditions.
  • Essential for geotechnical engineers, foundation design, and site investigations.
  • Educational tool for soil mechanics and foundation engineering courses.
  • Practical application for dam design, high-rise buildings, and infrastructure projects.

📦 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:

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: