Foundation Engineering

GEOtExcel 2025-1 | Geotechnical Excel Spreadsheets for Soil Mechanics & Foundation Engineering

by

✅ Geotechnical Excel Spreadsheets – GEOtExcel (2025-1)

GEOtExcel 2025-1 is now easier to access, fully secure, and permanently usable on your personal computer. With this version, GEOtExcel brings an Excel-based desktop application packed with essential tools for soil mechanics, foundation engineering, and geotechnical testing.

What’s New in GEOtExcel 2025-1?

Thanks to valuable user feedback, the delivery method of GEOtExcel has been improved. The 2025-1 version now offers:

1️⃣ Lifetime, Unlimited Access: Use it anytime on your personal computer.
2️⃣ No Restrictions: Save, print, and manage data locally without any limitations.
3️⃣ Offline Access: No need for an internet connection or cloud service to use GEOtExcel.

Important Note

The current GEOtExcel 2025-1 version is fully functional and permanently usable on the registered computer.
(If future versions are released and you choose to upgrade, you’ll receive special discounts for existing users.)

How to Order GEOtExcel 2025

To begin the process of getting GEOtExcel 2025, follow these steps:

  1. Download the package:
    Download Zip File
  2. Unzip and open the package:
    It contains two Excel files:
  • File 1: GET ID: This file helps you extract your computer’s unique ID. Simply open the file and click the “Copy Computer ID” button.
  • File 2: Agreement: This file contains 3 sheets:
    • Sheet 1: Price List: Select the GEOtExcel files you wish to purchase, and the total price will be calculated automatically.
    • Sheet 2: Customer & PC Info: Fill in your contact details and paste the copied Computer ID.
    • Sheet 3: Agreement: Review and confirm your order details.
  1. Complete the required fields, then save the Agreement file and email it to:
    📧 academy.dr.fahmi@gmail.com

Support and Assistance

Our support team is ready to assist you with the entire process, including payment, installation, and file delivery.

Why Choose GEOtExcel?

  • Comprehensive: Includes 12 fields, 50 files, and over 470 Excel spreadsheets.
  • Educational & Professional Quality: Created by Dr. Ahmad Fahmi, Assistant Professor at The University of Bonab, and CEO of GEOtExcel.
  • Real-World Application: Designed for professionals and students working in geotechnical engineering, soil mechanics, and foundation engineering.

Follow GEOtExcel on Social Media:

Contact Dr. Ahmad Fahmi:

Assistant Professor, The University of Bonab
CEO of GEOtExcel (KAPA)
Email: academy.dr.fahmi@gmail.com

Stay Updated:

Subscribe to get the latest updates, lectures, and spreadsheets for soil mechanics, foundation engineering, and geotechnical testing.
➡️ Subscribe on YouTube

Foundation Engineering – Pile Frictional Resistance (Beta Method) | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Pile Frictional Resistance (Beta Method)

[GEO-2025-0105] – Developed by GEOtExcel Co.

This educational spreadsheet package provides a step-by-step solution for pile frictional resistance calculations using the Beta Method in foundation engineering. It helps in analyzing the frictional resistance of a concrete pile in sandy soil and understanding the effects of varying parameters such as pile length, diameter, and friction angle.

Problem Overview:

A concrete pile with:

  • Length (L) = 10m
  • Diameter (D) = 0.5m
  • Soil Friction Angle (φ’) = 20°
  • Eccentricity (e) = 0.5
  • Pile-Soil Friction Angle = (2/3 φ’)

Steps Covered:

A) Calculate the frictional resistance (Qs) using the Beta Method.
B) Analyze the effect of varying L (10-15m), D (0.5-1m), and φ (20°-30°) on the frictional resistance.
C) Evaluate the impact of groundwater level ossification on the pile frictional resistance.

What’s Included:

  • 3 Professional Spreadsheets designed for analyzing pile frictional resistance using the Beta Method.
  • Comprehensive step-by-step solutions for all variables affecting pile frictional resistance.

Spreadsheets Included:

  1. Start Sheet: Introduction to the pile frictional resistance problem and parameters.
  2. Problem01: Detailed Foundation Engineering Problem with corresponding solution approach using GEOtExcel.
  3. Qs-Solution: Pile Frictional Resistance (Qs) Calculation using the Beta Method.

Features and Benefits:

  • Complete Analysis: This package includes comprehensive steps for calculating pile frictional resistance under different loading conditions and soil parameters.
  • Educational Use: Ideal for students and professionals in foundation engineering and geotechnical engineering.
  • Real-world Problem Solving: Provides a practical solution to a common engineering challenge in foundation design.

Why Choose GEOtExcel:

  • Expert-Developed: Created by Dr. Ahmad Fahmi, an expert in foundation engineering and soil mechanics.
  • Educational & Professional Quality: Suitable for both classroom learning and professional practice.
  • User-Friendly Format: Easy-to-use Excel spreadsheets designed for efficient problem-solving in geotechnical and foundation engineering.

Part of the GEOtExcel 2025-1 Collection

  • 12 Groups of spreadsheets
  • 50 Files covering various geotechnical topics
  • 470+ Spreadsheets
  • Commercially Licensed: Full access for professionals and educational use

For more details or to make a purchase, please contact:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy GEOtExcel and Use It on Your PC:

👉 How to Buy GEOtExcel and Use It on Your PC

🔗 Follow GEOtExcel on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi is a leading expert in soil mechanics, foundation engineering, and geotechnical testing, dedicated to providing high-quality educational tools for professionals and students.

📌 Stay Updated:

Subscribe to get access to the latest soil mechanics, foundation engineering, and geotechnical testing lectures on YouTube:
➡️ Subscribe on YouTube

Soil Mechanics – Stress Distribution in Soil using Newmark Method | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil Using Newmark Method

[GEO-2025-0129 A&B] – By Dr. Ahmad Fahmi

We are pleased to present the Stress Distribution in Soil analysis tool using the Newmark Method with Geotechnical Excel Spreadsheets. This advanced product includes 22 spreadsheets, which provide a comprehensive solution for calculating the stress distribution in soils based on the Newmark method.

This product is designed for geotechnical engineers and soil mechanics students working on foundation design, soil analysis, and stress distribution. Whether you are analyzing the vertical stress distribution in soil or studying soil behavior under varying conditions, these spreadsheets will help you perform precise calculations.

What’s Included in the 22 Spreadsheets?

  1. [GEO-2025-0129-A]:
    • Start Sheet: Introduction to the Newmark Method for stress distribution.
    • Main Super Sheet: Stress Distribution in Soil using the Newmark Method.
    • Calculation Sheets: Detailed spreadsheets for calculations based on the Newmark Method.
  2. [GEO-2025-0129-B]:
    • Additional Spreadsheets for extended calculations and analysis.
    • More comprehensive breakdowns for stress distribution.

Applications in Soil Mechanics and Foundation Engineering:

  • Newmark Method: Use the Newmark Method for stress distribution calculations in soil mechanics.
  • Soil Behavior Analysis: Analyze the effect of external loads on soil using stress distribution models.
  • Geotechnical Engineers: Ideal for professionals working on shallow foundations and soil load analysis.
  • Educational Use: A great tool for students and professors in soil mechanics and geotechnical engineering courses.
  • Detailed Analysis: Includes multiple calculation options to accurately model stress distribution in different soil types.

📦 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 – Effect of Surcharge on Effective Stress | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Effect of Surcharge on Effective Stress

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

Introducing the comprehensive Excel Spreadsheets for analyzing the Effect of Surcharge on Effective Stress in soil mechanics. This product, developed by GEOtExcel Co., includes 24 spreadsheets designed to provide accurate calculations of effective stress when surcharge loads are applied to shallow foundations. The package includes two layouts (Layout 1 and Layout 2) for flexibility in analysis and application.

These spreadsheets are ideal for geotechnical engineers and students working on projects related to foundation design, soil mechanics, and surcharge effects. Whether you’re analyzing shallow foundations or soil behavior under surcharge load, these tools will help you calculate effective stress with ease.

What’s Included in the 24 Spreadsheets?

  1. Start Sheet: Overview of the Effect of Surcharge on Effective Stress calculations.
  2. Surcharge Main Super Sheet: Core sheet for analyzing the effect of surcharge on effective stress (kg/m²).
  3. Calculation Spreadsheets: A series of 12 spreadsheets in both Layout 1 and Layout 2 for step-by-step calculations.

Applications in Soil Mechanics and Foundation Engineering:

  • Effective Stress Calculation: Calculate effective stress under surcharge loads with two layouts for flexibility and accuracy.
  • Foundation Design: Analyze the effect of surcharge on shallow foundations and soil behavior.
  • Practical Tool: Ideal for geotechnical engineers involved in soil testing and foundation design.
  • Educational Use: A great resource for students and professors studying soil mechanics and geotechnical engineering.
  • Advanced Analysis: Comprehensive tools for soil mechanics involving shallow foundation and surcharge load 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:

Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load

[GEO-2025-0104-A] – By Dr. Ahmad Fahmi

We are pleased to present the Bearing Capacity Calculator using Hansen’s Method for shallow foundations under inclined loads. This advanced set of 10 professional spreadsheets developed by GEOtExcel Co. allows engineers and students to calculate the bearing capacity of foundations when subjected to inclined loads.

This product is perfect for foundation engineers involved in designing shallow foundations subjected to various angles of inclination. By using this tool, you can determine the effect of loading inclination on the bearing capacity, an essential factor in geotechnical and foundation engineering.

What’s Included in the 10 Spreadsheets?

Start: Start Sheet – Introduction to the Hansen method for calculating bearing capacity under inclined loads.

  1. Angles: Introducing the Alpha, Beta, and Theta Angles – Explanation of different angles affecting bearing capacity.
  2. Hansen-Inclined Load: Main Super Sheet – Core sheet for calculating the bearing capacity using the Hansen method under inclined loads.
  3. C1-C7: Calculation Sheets – Detailed calculation sheets that handle various angles and loading conditions.

Applications in Foundation Engineering:

  • Hansen Method: Apply the Hansen method to calculate bearing capacity for shallow foundations under inclined loads.
  • Inclined Loads: Account for the effect of inclined loading on bearing capacity, which is crucial for foundations subjected to sloping or angled loads.
  • Practical Tool: Ideal for foundation design and geotechnical engineers working with shallow foundations.
  • Educational Use: Useful for students and professors in foundation engineering and geotechnical engineering courses.
  • Comprehensive Analysis: Includes all necessary calculations for bearing capacity factors, shape, depth factors, and more.

📦 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

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:

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

Bearing Capacity Factors: Meyerhof, Hansen,Vesić

by

Cost-Free Excel Spreadsheet:

In geotechnical engineering, bearing capacity is the soil’s ability to support applied loads. It’s the maximum pressure between the foundation and soil that won’t cause failure. Ultimate bearing capacity is the highest pressure soil can handle without failing, while allowable bearing capacity considers a safety factor. Soft soil may settle under load without failing, so allowable bearing capacity can be based on acceptable settlement. Allowable bearing pressure is the maximum pressure soil can handle without failure, while ultimate bearing capacity is the pressure before failure.
In this freely available Excel spreadsheet, you’ll find Bearing Capacity Factors based on methodologies by Meyerhof, Hansen, and Vesić.

GEOtExcel-Foundation-Engineering-Bearing-Capacity-FactorsDownload