Geotechnical Excel

Soil Mechanics – Soil Phase Relationships – Step-by-Step Solutions for Problem02, Problem03, & Problem04 | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Soil Phase Relationships: Step-by-Step Solutions for Problem02, Problem03, & Problem04

[GEO-2025-0109], [GEO-2025-0110], [GEO-2025-0111] – Developed by GEOtExcel Co.

This comprehensive product includes 17 professional spreadsheets that help solve Soil Phase Relationships problems in Soil Mechanics. The spreadsheets cover Problem02, Problem03, & Problem04 in detail with a step-by-step approach, ensuring a thorough understanding of the concepts.

What’s Included:

  • [GEO-2025-0109]: 7 Spreadsheets for Problem02, including detailed steps for solving the phase relationships.
  • [GEO-2025-0110]: 6 Spreadsheets for Problem03, covering calculations and key principles in soil mechanics.
  • [GEO-2025-0111]: 4 Spreadsheets for Problem04, designed to aid in comprehensive soil phase analysis and understanding.

Features and Benefits:

  • Step-by-Step Solutions: Each problem is solved with clear, structured steps to enhance learning and application.
  • Educational-Oriented: Ideal for students and professionals alike, these spreadsheets provide valuable insights and practice.
  • Comprehensive Coverage: From calculation of soil parameters to soil classification, the product covers all essential soil phase relationships in great detail.
  • Practical Applications: Designed for use in real-world soil mechanics problems and foundation design.

Why Choose GEOtExcel:

  • Complete Package: A total of 17 professional spreadsheets designed specifically for soil mechanics and phase relationships.
  • Trusted by Professionals: Developed by Dr. Ahmad Fahmi, an expert in Geotechnical Engineering.
  • Educational Focus: Aimed at enhancing your understanding of complex soil behavior and mechanics through practical and structured solutions.

📦 Part of the GEOtExcel 2025-1 Collection

  • 12 Groups of spreadsheets
  • 50 Files for soil mechanics and foundation engineering
  • 470+ Spreadsheets
  • Secure Access: Easily downloadable and usable on your computer
  • 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:

📺 GEOtExcel YouTube Channel

👨‍🏫 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

[GEO-2025-0109]

[GEO-2025-0110]

[GEO-2025-0111]

Advanced Soil Mechanics – Critical State Mechanics (MCC) Model | CU Triaxial Test | Geotechnical Excel Spreadsheets

by

Advanced Soil Mechanics – Critical State Mechanics (MCC) Model | CU Triaxial Test

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

This advanced Geotechnical Excel Spreadsheet for Critical State Mechanics (MCC Model) is designed for CU Triaxial Tests in soil mechanics. It allows classification of soil into three categories:

  1. NC – Normally Consolidated Clay
  2. LOC – Lightly Over-Consolidated Clay
  3. HOC – Highly Over-Consolidated Clay

The spreadsheet provides a professional tool for analyzing soil behaviors under different consolidation states, essential for advanced geotechnical engineering and foundation design.

What’s Included in the Product:

  • [GEO-2025-0140]: Includes 7 Professional Spreadsheets for soil classification based on the Modified Cam Clay (MCC) Model.
    • Start Sheet: Introduction and Overview.
    • MCC-CU Sheet: Main Super Sheet for Critical State Mechanics and CU Triaxial Test.
    • Calculation Sheets (Cal1-Cal5): For performing the detailed calculations required for soil classification under MCC.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Critical State Mechanics (MCC Model): Used to understand the soil behavior under varying stress states.
  • CU Triaxial Test: Important for testing soil in consolidated undrained conditions.
  • Soil Classification: The tool classifies clay into normally consolidated, lightly over-consolidated, and highly over-consolidated based on the MCC Model.
  • Geotechnical Engineers: Essential for soil stability, foundation analysis, and earthworks.
  • Educational Use: Suitable for students and professors in advanced soil mechanics courses.

📦 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 – Soil Classification (USCS) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Soil Classification (USCS)

[GEO-2025-0116], [GEO-2025-0117], [GEO-2025-0118] – By Dr. Ahmad Fahmi

We are excited to present the Soil Classification (USCS) tools in Geotechnical Excel Spreadsheets. This product includes 44 spreadsheets, offering a comprehensive solution for soil classification using the Unified Soil Classification System (USCS). The package includes various sections for comparing different soil classification systems, Fuller’s comparison, and analysis of poorly graded soils.

This tool is designed for geotechnical engineers, students, and soil mechanics professionals who are working with soil classification systems, especially focusing on the USCS.

What’s Included in the 44 Spreadsheets?

  1. [GEO-2025-0116]: Comparison
    • 20 Spreadsheets covering the USCS classification system, with detailed soil property analysis.
  2. [GEO-2025-0117]: Comparison with Fuller
    • 14 Spreadsheets offering a comparison between USCS and Fuller’s Classification.
  3. [GEO-2025-0118]: Poorly Graded Soils
    • 10 Spreadsheets focusing on the classification and analysis of poorly graded soils using the USCS.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Unified Soil Classification System (USCS): Ideal for classifying soils based on particle size and plasticity characteristics.
  • Geotechnical Engineers: A useful tool for foundation design, soil testing, and soil analysis.
  • Educational Use: Great for soil mechanics students and professors to demonstrate soil classification methods.
  • Comparison Analysis: Includes Fuller’s Classification comparison, which is essential for understanding soil behavior in various construction contexts.
  • Advanced Soil Analysis: Provides tools for the analysis of poorly graded soils, an important factor in foundation design and soil stabilization.

📦 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:

[GEO-2025-0116]

[GEO-2025-0117]

[GEO-2025-0118]

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:

Advanced Soil Mechanics – Critical State Mechanics – MCC Model (CD Triaxial Test) | Geotechnical Excel Spreadsheets

by

Advanced Soil Mechanics – Critical State Mechanics (MCC Model) for CD Triaxial Test

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

We are excited to introduce the Critical State Mechanics spreadsheet pack based on the Modified Cam Clay (MCC) Model for the CD Triaxial Test. This advanced set of 7 professional spreadsheets developed by GEOtExcel Co. is designed for soil mechanics professionals, students, and geotechnical engineers to classify soils into Normally Consolidated (NC), Lightly Over-consolidated (LOC), and Highly Over-consolidated (HOC) clays.

This tool is essential for understanding critical state mechanics, enabling accurate modeling of soil behavior under compression and tension conditions. It’s a vital resource for professionals involved in geotechnical engineering projects, foundation design, and soil testing.

What’s Included in the 7 Spreadsheets?

  1. Start: Start Sheet – Overview and setup for the MCC model and CD triaxial test calculations.
  2. MCC-CD: Main Super Sheet – Critical State Mechanics using the MCC model for CD triaxial test.
  3. Cal1 to Cal5: Calculation Sheets – Various sheets to calculate and analyze data for NC, LOC, and HOC clay classifications.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Critical State Mechanics: Implement MCC model for modeling soil behavior and failure states under compression and tension.
  • Soil Classification: Classify soils into Normally Consolidated (NC), Lightly Over-consolidated (LOC), and Highly Over-consolidated (HOC) using MCC and triaxial test data.
  • Triaxial Test Analysis: Conduct comprehensive analysis of CD triaxial tests, including effective stress and critical state conditions.
  • Soil Behavior Simulation: Essential for simulating soil behavior in geotechnical and foundation engineering applications.
  • Practical Tool: Ideal for soil testing labs, foundation design, and geotechnical engineers working with clay soils.
  • Educational Use: Useful in soil mechanics and geotechnical engineering courses focusing on critical state soil mechanics and advanced triaxial testing.

📦 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 – Unified Soil Classification System (USCS) – Clay & Silt Classification with Plasticity Chart

by

Soil Mechanics – Unified Soil Classification System (USCS) – Geotechnical Excel Spreadsheets

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

We are thrilled to introduce the Unified Soil Classification System (USCS) spreadsheet pack for Clay and Silt soils, developed by GEOtExcel Co.. This pack includes 5 professional spreadsheets, designed to help soil mechanics professionals, students, and geotechnical engineers classify clay and silt soils based on the Plasticity Chart and the Atterberg Limits test data.

This spreadsheet pack is an invaluable tool for anyone involved in soil classification, offering easy-to-use formulas and visual tools for determining the plasticity index and shrinkage limits of soils, specifically for CL, CH, ML, and MH soil types.

What’s Included in the 5 Spreadsheets?

  1. DATA: Soil Classification Data for CL, CH, ML, and MH soils under the USCS system.
  2. USCS: Excel Spreadsheet for the Unified Soil Classification System (USCS) for clay and silt soils.
  3. Analysis Sheet: Soil Classification Analysis Sheet: Includes particle size curve and plasticity chart for USCS classification.
  4. Plasticity Chart: Understanding the Components of the Plasticity Chart for classifying soil based on Atterberg limits.
  5. Shrinkage Limit: Determining the Shrinkage Limit using the Plasticity Chart and Atterberg limits test data.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Classification: Use the USCS to classify clay and silt soils and calculate the plasticity index and shrinkage limits.
  • Plasticity Chart Analysis: Classify soils based on their plasticity index and assess their suitability for various engineering applications.
  • Shrinkage Limit Determination: Analyze and determine the shrinkage limit of soils using Atterberg limits test data.
  • Practical Tool: Ideal for soil testing, foundation design, and geotechnical analysis in civil engineering projects.
  • Educational Use: A useful tool for students and professors in soil mechanics and geotechnical engineering courses, helping students better understand the plasticity chart and soil classification.

📦 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:

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension) | Geotechnical Excel Spreadsheets

by

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension)

[GEO-2025-0131]

We are pleased to present the Deviatoric Stress at Active and Passive Failure States spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set of 4 powerful spreadsheets enables soil mechanics professionals, students, and geotechnical engineers to calculate deviatoric stress at the active and passive failure states of soil under compression and tension conditions.

The pack also includes tools to calculate failure surfaces and provides a comprehensive solution for analyzing soil behavior under different failure conditions, making it essential for foundation design and soil stability analysis.

What’s Included in the 4 Spreadsheets?

  1. Problem1: Determining Deviatoric Stress at Active Failure State of Soil – Calculate deviatoric stress for the active failure state of soil under compression.
  2. Problem2: Determining Deviatoric Stress at Passive Failure State of Soil – Calculate deviatoric stress for the passive failure state of soil under tension.
  3. Solution: Determining Deviatoric Stress at Soil Failure – Comprehensive solution for calculating deviatoric stress at active and passive failure states of soil.
  4. Failure Surface: Determining Failure Surface – Analyze and calculate the failure surface for soil under both compression and tension.

Applications in Soil Mechanics and Geotechnical Engineering:

Deviatoric Stress Calculation: Accurately calculate deviatoric stress at active and passive failure states of soil for both compression and tension conditions.

  • Failure State Analysis: Understand and analyze the active and passive failure states in soil mechanics.
  • Failure Surface Calculation: Calculate and visualize failure surfaces for soil under load conditions, aiding in foundation design and soil stability assessments.
  • Practical Use: Ideal for geotechnical engineers, soil mechanics professionals, and students working on soil behavior and failure analysis in foundation design.
  • Educational Tool: A valuable teaching aid for soil mechanics and geotechnical engineering courses focused on failure states and stress 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:

Soil Mechanics – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) / Geotechnical Excel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading)

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

We are excited to introduce the Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 4 essential spreadsheets designed to help soil mechanics professionals, students, and geotechnical engineers calculate and analyze vertical stress distribution in soil under rectangular loading using Boussinesq theory.

This pack provides solutions for computing stress distribution and includes influence charts that are crucial for foundation design and soil behavior analysis in areas affected by varying load conditions.

What’s Included in the 4 Spreadsheets?

  1. Start: Stress Distribution in Soil – Boussinesq Theory – Rectangular Loading – Introduction sheet for stress distribution analysis.
  2. Rectangular Loading: Calculation Sheet for Stress Distribution in soil using Boussinesq Theory for vertical stress calculation.
  3. Influence-Main: Influence Chart for Computing Vertical Stress – Visual tool for calculating stress distribution.
  4. Influence-Image: Influence Chart Image – A graphical representation of the influence chart for stress calculations.

Applications in Soil Mechanics and Geotechnical Engineering:7

  • Stress Distribution: Use Boussinesq theory to calculate vertical stress distribution in soil under rectangular loading conditions.
  • Influence Charts: Generate and interpret influence charts for accurate stress calculations in different soil conditions.
  • Foundation Design: Essential for designing foundations in geotechnical engineering projects affected by varying load distribution.
  • Practical Tool: Ideal for soil testing, foundation stability analysis, and site investigations in geotechnical projects.
  • Educational Tool: Useful for soil mechanics and geotechnical engineering courses focusing on load distribution and stress analysis in soils.

📦 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: