Soil Mechanics

Soil mechanics

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

Soil Mechanics – Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH)

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

This professional spreadsheet package provides a detailed solution for Soil Mechanics focusing on Fat Clay (CH) using the Unified Soil Classification System (USCS) and Hydrometer Analysis.

What’s Included:

  • 8 Professional Spreadsheets covering soil classification, sieve, and hydrometer analysis for Fat Clay (CH).

Detailed Breakdown:

  • [GEO-2025-0115]:
    1) Start Sheet: Introduction to Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH).
    2) DATA: Soil Classification data for Fat Clay (USCS).
    3) USCS: Excel Spreadsheet for Unified Soil Classification System (USCS).
    4) Sieve: Sieve Analysis for Fat Clay.
    5) Hydrometer: Hydrometer Analysis for Fat Clay.
    6) Table 1: Hydrometer 152H – Table1
    7) Table 1-Full: Full data for Hydrometer 152H – Table1
    8) Table 2: Hydrometer 152H – Table3
    9) Table 2-Full: Full data for Hydrometer 152H – Table2
    10) Table 3: Hydrometer 152H – Table1
    11) Table 3-Full: Full data for Hydrometer 152H – Table3

Features and Benefits:

  • Comprehensive Soil Classification: Covers the USCS system and Hydrometer analysis for Fat Clay (CH), including sieve analysis.
  • Professional and Educational Use: Aimed at students and professionals in soil mechanics and geotechnical engineering.
  • Detailed Spreadsheets: The package includes 8 detailed spreadsheets, ideal for practical use in laboratory settings.
  • Complete Hydrometer Analysis: Includes detailed tables and hydrometer calculations, providing valuable insights for soil testing and classification.

Why Choose GEOtExcel:

  • Educational & Professional-Grade: These spreadsheets offer a detailed approach to soil classification and analysis, suitable for both educational and professional use.
  • Comprehensive & User-Friendly: The easy-to-use format ensures users can perform detailed soil tests and obtain reliable results efficiently.
  • Expert-Developed: Created by Dr. Ahmad Fahmi, an expert in soil mechanics and geotechnical engineering.

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

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

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:

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:

Soil Mechanics – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Effective Stress with Double Layer and Groundwater Oscillation spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 16 powerful spreadsheets designed for soil mechanics professionals, students, and geotechnical engineers to analyze the effects of groundwater oscillation on effective stress variation in double layer soil systems.

This pack enables users to perform detailed calculations for total stress, pore water pressure, and effective stress, before and after groundwater oscillation, which is essential for foundation and soil stability analysis in areas affected by fluctuating water levels.

What’s Included in the 16 Spreadsheets?

  1. Start: Effective Stress (kg-Layout 1) – Introduction sheet for calculating effective stress in double layer soil systems.
  2. Double Layer-kg: Main Super Sheet – Analyzing the effect of groundwater oscillation on effective stress variation (kg/m²).
  3. D1: Calculation Sheet 1 – Total Stress Calculation and graph before groundwater oscillation.
  4. D2: Calculation Sheet 2 – Pore Water Pressure Calculation and graph before groundwater oscillation.
  5. D3: Calculation Sheet 3 – Effective Stress Calculation and graph before groundwater oscillation.
  6. D4: Calculation Sheet 1 – Total Stress Calculation and graph after groundwater oscillation.
  7. D5: Calculation Sheet 1 – Pore Water Pressure Calculation and graph after groundwater oscillation.
  8. D6: Calculation Sheet 1 – Effective Stress Calculation and graph after groundwater oscillation.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Effective Stress Calculation: Calculate the effective stress in double layer soils under varying groundwater conditions.
  • Groundwater Oscillation Effects: Analyze how oscillating groundwater affects total stress, pore water pressure, and effective stress.
  • Foundation Design: Essential for designing foundations in areas where groundwater levels fluctuate.
  • Practical Tool: Ideal for geotechnical engineers, soil mechanics professionals, and students working on foundation stability and soil behavior analysis.
  • Educational Use: A valuable teaching tool for soil mechanics and geotechnical engineering courses, particularly for understanding stress variations under groundwater changes.

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