Special Cases

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: