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

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:



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

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

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: