Geotechnical Engineering Tools

Soil Mechanics – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

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

We are pleased to introduce the Stress Distribution in Soil (Boussinesq Method) spreadsheet pack, part of the GEOtExcel (2025-1) collection. This pack includes 5 powerful spreadsheets designed for geotechnical engineers, soil mechanics students, and civil engineering professionals who need to analyze stress distribution in soil under a point load using the Boussinesq method. The spreadsheets cover detailed total stress, pore water pressure, effective stress calculations, and provide graphical insights into the stress distribution.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Stress Distribution in Soil using the Boussinesq Method.
  2. Boussinesq: Boussinesq’s Formula for point load stress distribution in soil.
  3. Point Load1: Stress distribution analysis for Point Load with stress-x graph visualization.
  4. Point Load2: Stress distribution analysis for Point Load with z-stress graph.
  5. Pressure Bulb: Pressure bulb analysis for point load stress distribution in soil.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Stress Distribution Analysis: Accurately calculate stress distribution in soil using the Boussinesq method.
  • Point Load Analysis: Determine the effects of point load on stress distribution in soil layers.
  • Graphical Representation: Visualize stress-x and z-stress graphs for better understanding of soil behavior.
  • Pressure Bulb Analysis: Analyze and visualize the pressure bulb around a point load in soil.
  • Teaching & Learning Tool: Ideal for soil mechanics and geotechnical engineering education and practical use.
  • Field Work & Lab Testing: Use for site investigations and laboratory experiments to analyze soil response under load.

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (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 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 specializes in integrating Excel-based solutions with soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics

Foundation Engineering

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

by

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

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

We are excited to present the Effective Stress for Single Layer Soil Profile spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 20 sheets, designed for geotechnical engineers, soil mechanics students, and civil engineers looking to calculate and visualize effective stress in a single-layer soil profile. The pack includes essential calculations and graphs for total stress, pore water pressure, and effective stress in both kg/m² and kN/m² units.

What’s Included in the 20 Spreadsheets?

  1. Start: Introduction sheet for Effective Stress calculations (kg-Layout 1).
  2. Single Layer-kg: Main sheet explaining the Effective Stress concept for a single-layer profile in kg/m².
  3. TS-01: Calculation Sheet 1 for Total Stress calculation and associated graph.
  4. u-01: Calculation Sheet 2 for Pore Water Pressure calculation and graph.
  5. ES-01: Calculation Sheet 3 for Effective Stress calculation and graph.
  6. [GEO-2025-0122-A] – kg-Layout 1: Effective Stress layout for kg/m².
  7. [GEO-2025-0122-B] – kg-Layout 2: Second layout for Effective Stress using kg/m².
  8. [GEO-2025-0122-C] – kN-Layout 1: Effective Stress layout for kN/m².
  9. [GEO-2025-0122-D] – kN-Layout 2: Second layout for Effective Stress using kN/m².

Applications in Soil Mechanics and Geotechnical Engineering:

  • Performing effective stress analysis in single-layer soil profiles
  • Calculating and visualizing total stress, pore water pressure, and effective stress
  • Teaching and learning about effective stress concepts in soil mechanics
  • Suitable for geotechnical testing, field work, and laboratory experiments
  • Ideal for use in civil engineering projects and foundation design
  • Comprehensive graphs for visual understanding and data interpretation

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (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 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 specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on: