How to calculate the “Bearing Capacity” in an Excel spreadsheet?

How to calculate the “Bearing Capacity” in an Excel spreadsheet for strip, square, and circular footings using Terzaghi’s method?

Watch the Video on Our YouTube Channel (in English):

https://youtu.be/cIzYpDOUlVo

✅ Instagram Page Address:
https://www.instagram.com/academy.dr.fahmi
✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering
✅ Geotechnical Excel Programs & Lectures

Terzaghi, Hansen, Vesic, and Meyerhof developed foundational methods in geotechnical engineering for calculating soil bearing capacity. Terzaghi’s method, the earliest and most straightforward, provided a basic bearing capacity formula based on three key factors. Hansen built upon this by adding correction factors for foundation shape, depth, and load inclination. Vesic further enhanced the method, integrating plasticity theory for more accurate predictions under complex conditions. Meyerhof introduced a more generalized bearing capacity formula that accounted for the foundation’s shape, depth, and load inclination, providing a comprehensive approach to bearing capacity estimation.

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

2 thoughts on “How to calculate the “Bearing Capacity” in an Excel spreadsheet?”

    • Geotechnical Excel Spreadsheets (GEOtExcel-2025) is Now Available

      We are excited to announce that the official release of GEOtExcel-2025-v1 is now available!
      GEOtExcel offers a cloud-based, Excel-driven solution for geotechnical calculations, fully integrated with Microsoft 365 services. You can find full details, subscription information, and a step-by-step guide on our launch page:

      https://geotexcel.com/geotexcel-2025-launch/
      “Please make sure to watch the video on the launch page carefully, as it explains important subscription and access steps.”

      To complete your subscription:
      • Download the Catalog and Pricing & Subscription Agreement directly from the page.
      • Review the pricing and terms carefully.
      • Sign the agreement (either digitally or by hand).
      • Email the signed agreement to: academy.dr.fahmi@gmail.com
      • Important: In the subject line of your email, please write: “GEOtExcel Agreement + Your Full Name”
      • After we receive your signed agreement, we will promptly provide you with the payment instructions.
      • Once your payment is confirmed, your access to GEOtExcel-2025 will be activated at the earliest possible time.
      Important Subscription Note:
      The official subscription period (one year) for GEOtExcel-2025 begins upon purchase, with access to the files provided shortly after payment.
      If you have any questions about Microsoft 365 requirements, subscription steps, or using GEOtExcel, feel free to contact us. We are here to assist you at every stage.

      We look forward to welcoming you to the GEOtExcel community!

      Warm regards,
      Dr. Ahmad Fahmi
      CEO, Khak Azma Pey Afzar Co.
      Brand: GEOtExcel
      academy.dr.fahmi@gmail.com
      http://www.geotexcel.com

      Supplementary Information
      Two recommended options for accessing GEOtExcel:

      🔹 Option 1: Use Microsoft 365 Free Account
      • GEOtExcel Subscription: $250 USD/year or 199 USDT/year
      • Cost: $0 for Microsoft 365
      Microsoft 365 free account must be registered by the user directly.
      • You can access all calculation sheets and graphical results via Excel Online in your browser.
      • Note: You will not have access to certain advanced control features (VBA-based tools), but core calculations and outputs will still work fully.

      🔹 Option 2: Use Microsoft 365 Personal (Paid)
      • GEOtExcel Subscription: $250 USD/year or 199 USDT/year
      • Cost: ~$10 USD/month for Microsoft 365 Personal license (The first month of Microsoft 365 Personal subscription is free).
      (Microsoft 365 Personal must be purchased directly from Microsoft; this cost is separate and not paid to us.)
      • You will be able to open files in your desktop Excel, use all features including calculation tools, graphs, and control interfaces without limitations.

      Reply

Leave a Comment