Soil Behavior

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 – 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 – Triaxial CD Test (Real Results) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Triaxial CD Test (Real Results) | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Triaxial CD Test (Consolidated Drained Test) results spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 4 powerful spreadsheets designed to help soil mechanics professionals and students analyze and interpret real results from Triaxial CD tests. The spreadsheets cover essential calculations and data analysis, enabling users to assess soil strength and consolidation behavior accurately.

What’s Included in the 4 Spreadsheets?

  1. Start: Summary of Triaxial CD Test Data – Overview sheet with key data from the test.
  2. Locked Calculation sheet: Internal calculation sheet – Not for users but includes the foundation of the results.
  3. Data: Consolidated Drained Triaxial Test Data – Input and organize your test data for analysis.
  4. Analysis & Calculations: Triaxial Test (CD) Results – Detailed data analysis and calculations of Triaxial CD test results, including graphical outputs and interpretations.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Strength Analysis: Analyze the strength characteristics of soil using the Consolidated Drained (CD) Triaxial Test results.
  • Consolidation & Drained Behavior: Study how soil behaves under consolidation and drainage conditions, crucial for foundation design and geotechnical investigations.
  • Practical Data Analysis: Input your test data and quickly perform data analysis and calculations for soil mechanics projects.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses to learn how to analyze Triaxial CD tests.
  • Real-World Application: Perfect for geotechnical engineers, field testing, and site investigation projects.

📦 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 – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Consolidation spreadsheet pack for single and double drainage scenarios as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 5 essential spreadsheets designed for soil mechanics calculations, focusing on consolidation under different drainage conditions. The pack includes detailed calculations and graphs for total stress, pore water pressure, effective stress, and provides insights into stress distribution in soil.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Consolidation, covering single drainage and double drainage methods.
  2. Single drainage-min: Single drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  3. Single drainage-day: Single drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.
  4. Double Drainage-min: Double drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  5. Double Drainage-day: Double drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Calculate consolidation for soil under both single and double drainage conditions.
  • Analyze coefficient of consolidation (Cv) in different units: cm²/min and m²/day.
  • Single Drainage vs. Double Drainage scenario comparisons for soil consolidation.
  • Consolidation testing and fieldwork for soil behavior in various drainage conditions.
  • Educational use for soil mechanics and geotechnical engineering courses.
  • Practical tool for civil engineers working on foundation and soil stability projects.

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