Foundation Engineering – Bearing Capacity Calculator | Geotechnical Excel Spreadsheets

GEOtExcel Foundation Engineering – Bearing Capacity Calculator (Terzaghi Method)

Welcome to GEOtExcel, the most advanced and comprehensive collection of professional geotechnical spreadsheets for foundation engineering. Our Bearing Capacity Calculator spreadsheet set is designed for foundation engineers, geotechnical professionals, and students, featuring solutions and analysis of bearing capacity for various soil types, depth (Df), shear strength (f), and more. This pack allows easy calculation and comparison of bearing capacities based on Terzaghi’s method, as well as methods by Meyerhof, Hansen, and Vesić.

What’s Included in the GEOtExcel Bearing Capacity Calculator Pack?

This collection of 20 specialized spreadsheets is an essential tool for anyone in the field of foundation engineering. The spreadsheets provide:

  1. Problem 01: Problem Page: A foundation has a depth of Df. The soil supporting the foundation is considered for various student IDs.
  2. Bearing Capacity Factors: Bearing-capacity factors for the Terzaghi, Meyerhof, Hansen, and Vesić methods.
  3. Formulas of the Factors: Detailed formulas for each of the bearing-capacity factors.
  4. Formulas for Factors (Image): A graphical representation of the bearing-capacity factors.
  5. Problem 01-Public: Problem Page: A foundation has a depth of Df, with soil considered for public student ID.
  6. Solution: Step-by-step solution to the problem.
  7. Variations: Solution considering the effect of variations in all parameters.
  8. Variations-B: Solution considering the effect of variation in the B parameter along with the graph.
  9. Variations-fi: Solution considering the effect of variation in the f parameter along with the graph.
  10. Variations-B&fi: Solution considering the effect of variation in both B and f parameters with graphs.
  11. Variations-Df: Solution considering the effect of variation in the Df parameter along with the graph.
  12. Variations-C: Solution considering the effect of variation in the C parameter along with the graph.
  13. Variations-gama: Solution considering the effect of variation in the g parameter along with the graph.
  14. Special Cases: Categorization of special cases.
  15. Special-01: Considering the special case where c’ = 0.
  16. Special-02: Considering the special case where Df = 0.
  17. Special-03: Considering the special case where f’ = 0.
  18. Special-04: Considering the special case where c’ = 0 and Df = 0.
  19. Special-05: Considering the special case where Df = 0 and f’ = 0.
  20. General: Comparing the special cases with the general (non-special) case.

Key Features of GEOtExcel:

  • Comprehensive Spreadsheet Collection: 20 advanced spreadsheets covering various aspects of bearing capacity calculations.
  • Solutions for Different Methods: Use Terzaghi, Meyerhof, Hansen, and Vesić methods to solve foundation bearing capacity problems.
  • Parameter Sensitivity Analysis: Investigate how variations in parameters (Df, f, c, B, gama) affect the overall bearing capacity.
  • Special Case Scenarios: Handle special cases such as when parameters are zero, helping you address real-world complexities in soil mechanics.
  • User-Friendly Graphs and Visuals: View the effects of parameter variations with intuitive graphs and charts.


Follow GEOtExcel on Social Media:

Leave a Comment