Shallow Foundations

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: