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:



Leave a Comment