geotechnical engineering

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:

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 – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Consolidation spreadsheet pack for single and double drainage scenarios as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 5 essential spreadsheets designed for soil mechanics calculations, focusing on consolidation under different drainage conditions. The pack includes detailed calculations and graphs for total stress, pore water pressure, effective stress, and provides insights into stress distribution in soil.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Consolidation, covering single drainage and double drainage methods.
  2. Single drainage-min: Single drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  3. Single drainage-day: Single drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.
  4. Double Drainage-min: Double drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  5. Double Drainage-day: Double drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Calculate consolidation for soil under both single and double drainage conditions.
  • Analyze coefficient of consolidation (Cv) in different units: cm²/min and m²/day.
  • Single Drainage vs. Double Drainage scenario comparisons for soil consolidation.
  • Consolidation testing and fieldwork for soil behavior in various drainage conditions.
  • Educational use for soil mechanics and geotechnical engineering courses.
  • Practical tool for civil engineers working on foundation and soil stability 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:

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