Civil Engineering Tools

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:

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

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

We are pleased to present the Bearing Capacity Comparison of Classic Methods spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This comprehensive set includes 15 powerful spreadsheets designed to help soil mechanics professionals and students compare bearing capacity using the classic methods of Terzaghi, Vesic, and Meyerhof. The pack allows you to calculate bearing capacity factors, shape and depth factors, and analyze solutions for different foundation types.

These spreadsheets are essential for foundation engineers, geotechnical engineers, and students who need to understand and apply these classic methods for real-world foundation design.

What’s Included in the 15 Spreadsheets?

  1. Start: GEOtExcel: Foundation Engineering-Bearing Capacity Calculator – Comprehensive Comparison – Overview and introduction sheet.
  2. Problem: A rectangular foundation with width B, length L, and other parameters for various student IDs.
  3. Problem-public: Rectangular foundation analysis for public student ID.
  4. Comprehensive Comparison: Comprehensive Bearing Capacity Comparison using Terzaghi, Vesic, and Meyerhof methods.
  5. N Factors: Bearing Capacity Factors (Nc, Nq, and Ng) – Formulas for calculating key bearing capacity factors.
  6. Bearing-Capacity Factors: Comprehensive Bearing Capacity Factors calculation for Terzaghi, Vesic, and Meyerhof methods.
  7. Shape & Depth Factors: Comprehensive Shape and Depth Factors for Vesic, Hansen, and Meyerhof methods.
  8. Terzaghi: Solution Using Terzaghi Bearing Capacity Calculator – Layout 1 for a rectangular foundation.
  9. Vesic1: Solution Using Vesic Bearing Capacity Calculator for a rectangular foundation.
  10. Vesic2: Solution Using Vesic Bearing Capacity Calculator – Layout 2 for a more detailed analysis.
  11. Shape & Depth Factors-(V): Comprehensive Shape and Depth Factors for Vesic’s Method.
  12. Hansen: Solution Using Hansen Bearing Capacity Calculator for a rectangular foundation.
  13. Shape & Depth-(H): Comprehensive Shape and Depth Factors for Hansen’s Method.
  14. Meyerhof: Solution Using Meyerhof Bearing Capacity Calculator for a rectangular foundation.
  15. Shape & Depth-(M): Comprehensive Shape and Depth Factors for Meyerhof’s Method.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Bearing Capacity Comparison: Compare Terzaghi, Vesic, and Meyerhof methods for estimating foundation bearing capacity.
  • Practical Solutions: Use comprehensive solutions and calculations for rectangular foundations and varying foundation depths.
  • Bearing Capacity Factors: Calculate Nc, Nq, and Ng bearing capacity factors for accurate foundation design.
  • Shape and Depth Factors: Understand how shape and depth factors influence bearing capacity in each method.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses on foundation design and bearing capacity analysis.
  • Real-World Application: Essential for geotechnical engineers, foundation design, and site investigations.

📦 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 – Flow Net & Flow Rate Concept for Dams | Seepage Analysis | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Flow Net & Flow Rate Concept for Dams | Seepage Analysis | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Flow Net & Flow Rate Concept spreadsheet pack for dams, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics professionals and students to analyze and calculate flow net and flow rate beneath concrete dams, with a focus on seepage analysis through soil at an angle α to the horizontal.

These spreadsheets provide detailed calculations and analysis for flow channels, potential drops, and the flow rate formula beneath a concrete dam, along with Darcy’s Law applications in various soil sections (circle, rectangle, and square).

What’s Included in the 8 Spreadsheets?

  1. Start: GEOtExcel: Flow Net Concept & Calculation – Introduction to the flow net concept and seepage analysis.
  2. Flow Net-Dam-01: Flow Channels and Potential Drops Beneath a Concrete Dam – Layout 1.
  3. Flow Net-Dam-02: Flow Channels and Potential Drops Beneath a Concrete Dam – Layout 2.
  4. Darcy’s law-Circle: Seepage through soil at an angle α to the horizontal – Circular section analysis using Darcy’s Law.
  5. Darcy’s law-Rectangle: Seepage through soil at an angle α to the horizontal – Rectangular section analysis using Darcy’s Law.
  6. Darcy’s law-Square: Seepage through soil at an angle α to the horizontal – Square section analysis using Darcy’s Law.
  7. Formula Concept: Flow Rate Calculation Beneath a Concrete Dam – Formula concept and calculation for seepage through soil.
  8. Concept Conclusion: Flow Rate Calculation Beneath a Concrete Dam – Concept conclusion and summary of results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage Analysis: Understand seepage through soil beneath concrete dams, considering flow at an angle α to the horizontal.
  • Flow Rate Calculations: Accurately calculate flow rate for soil water movement beneath a dam using Darcy’s Law.
  • Flow Channel Analysis: Calculate flow channels and potential drops in different soil sections (circle, rectangle, square).
  • Dam Design: Essential for dam engineering, hydrological studies, and foundation design.
  • Ideal for Geotechnical Engineers: Useful for site investigations, groundwater flow analysis, and foundation stability.
  • Educational Tool: Perfect for soil mechanics and geotechnical engineering courses focused on seepage and flow behavior.

📦 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 – Seepage through Soil at an Angle α to the Horizontal | Darcy’s Law | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Seepage through Soil at an Angle α to the Horizontal | Darcy’s Law | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Seepage through Soil at an Angle α to the Horizontal spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 9 essential spreadsheets designed for soil mechanics professionals and students to analyze seepage through soil using Darcy’s Law. The pack focuses on seepage analysis in soils when the flow occurs at an angle to the horizontal, a crucial consideration in geotechnical engineering projects like drainage systems, earth dam design, and foundation investigations.

What’s Included in the 9 Spreadsheets?

  1. Start: Darcy’s Law Start Sheet – Introduction to seepage through soil at an angle α to the horizontal.
  2. Darcy’s law alpha-01: Hydraulic Gradient Concept – Part 1 – Introduction to hydraulic gradient and its application in seepage analysis.
  3. Darcy’s law alpha-02: Hydraulic Gradient Concept – Part 2 – Further exploration of the hydraulic gradient concept and its impact on flow behavior.
  4. Darcy’s law alpha-03: Darcy’s Law Concept – Part 1 – Basics of Darcy’s Law applied to soil seepage at an angle.
  5. Darcy’s law alpha-04: Darcy’s Law Concept – Part 2 – Advanced calculations using Darcy’s Law in seepage scenarios with a focus on angles.
  6. Darcy’s law alpha-05: Flow Rate Calculation – Part 1 – Calculating flow rate through soil using Darcy’s Law for angled flow.
  7. Darcy’s law alpha-06: Flow Rate Calculation – Part 2 – Continuing flow rate analysis with Darcy’s Law for angled soil conditions.
  8. Darcy’s law alpha-07: Flow Rate Calculation – Part 3 – Final calculations and visualizing flow rate for seepage through soils at an angle.
  9. Darcy’s law alpha-08: Flow Rate Calculation – Part 4 – Additional advanced calculations for seepage flow rate in soils subjected to angled conditions.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage Analysis: Understand and calculate seepage through soil at an angle using Darcy’s Law.
  • Flow Rate Calculations: Calculate flow rate for soil water movement in geotechnical projects like dam engineering, groundwater studies, and foundation designs.
  • Hydraulic Gradient: Analyze the hydraulic gradient and its relationship with flow direction and soil permeability.
  • Ideal for Geotechnical Engineers: A valuable tool for drainage systems, subsurface investigations, and soil permeability tests.
  • Educational Use: Perfect for soil mechanics and geotechnical engineering courses focused on seepage and soil behavior.
  • Practical Tool: Applicable in real-world geotechnical projects, including foundation design, soil permeability testing, and geotechnical investigations.

📦 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 – Complete Soil Gradation Curve Using Sieve and Hydrometer | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Complete Soil Gradation Curve Using Sieve and Hydrometer | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Complete Soil Gradation Curve Using Sieve and Hydrometer spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed to help soil mechanics professionals and students analyze and calculate the gradations of soil using sieve analysis and hydrometer tests.

These spreadsheets allow you to combine data from both sieve and hydrometer tests to create a full gradation curve for soil, and to calculate other crucial parameters like k-value and temperature correction factors for more accurate results.

What’s Included in the 8 Spreadsheets?

  1. Start: Hydrometer Analysis of Clayey Sand Soil – Introduction sheet to the analysis.
  2. Input Data: Sieve and Hydrometer Test Data – Input your data for analysis.
  3. Sieve Analysis: Sieve Analysis Table and corresponding gradation curve.
  4. Hydrometer: Hydrometer Analysis Tables for detailed results.
  5. Combination: Combining Sieve and Hydrometer data for complete gradation analysis.
  6. Table 1: k-Value Determination based on Gs and temperature in soil hydrometer analysis.
  7. Table 2: Another k-Value Determination table for more specific soil analysis conditions.
  8. Table 3: Temperature Correction Factor (CT) determination.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Gradation Analysis: Combine data from sieve and hydrometer tests to generate a complete gradation curve.
  • Accurate Soil Analysis: Determine k-values and temperature correction factors for more precise soil behavior prediction.
  • Sieve and Hydrometer Data: Analyze sieve analysis and hydrometer test data for soil classification.
  • Educational Tool: Ideal for soil mechanics and geotechnical engineering courses.
  • Practical Applications: Useful for soil testing, geotechnical investigations, and foundation design.

📦 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 – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

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

We are excited to present the Seepage & Darcy’s Law spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics and geotechnical engineering professionals to analyze and calculate seepage, hydraulic gradient, and flow rate using Darcy’s Law.

What’s Included in the 8 Spreadsheets?

  1. Start: Introduction sheet to Darcy’s Law and seepage analysis.
  2. Darcy’s law-01: Hydraulic gradient concept — Part 1.
  3. Darcy’s law-02: Hydraulic gradient concept — Part 2.
  4. Darcy’s law-03: Darcy’s Law concept — Part 1, with visual explanations.
  5. Darcy’s law-04: Darcy’s Law concept — Part 2, focusing on soil characteristics and flow.
  6. Darcy’s law-05: Darcy’s Law flow rate calculation — Part 1, covering theoretical concepts.
  7. Darcy’s law-06: Darcy’s Law flow rate calculation — Part 2, applying real data.
  8. Darcy’s law-07: Darcy’s Law flow rate calculation — Part 3, advanced application and results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage and Flow Rate Analysis: Calculate flow rate and seepage in soil based on Darcy’s law.
  • Hydraulic Gradient: Understand and apply the hydraulic gradient concept in various soil conditions.
  • Darcy’s Law: Deep dive into Darcy’s law for seepage and fluid flow through porous materials.
  • Practical Tools for soil mechanics and geotechnical engineering projects.
  • Laboratory & Field Testing: Use for soil testing and site investigations in civil and geotechnical projects.
  • Educational Use: Ideal for students, lecturers, and professionals learning and applying seepage 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 – Triaxial CU Test (Real Results) | Geotechnical Excel Spreadsheets

by

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

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

We are proud to introduce the Triaxial CU Test (Real Results) spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This pack includes 4 essential spreadsheets designed to help geotechnical engineers, soil mechanics students, and civil engineers analyze consolidated undrained triaxial test data (CU tests) for accurate soil behavior analysis and calculation of shear strength parameters.

What’s Included in the 4 Spreadsheets?

  1. Start: Summary of Triaxial CU Test Data with key variables and results.
  2. Locked Calculation Sheet: Internal calculation sheet (not for users) for automated data processing.
  3. Data: Consolidated undrained Triaxial Test Data, providing input values and soil test results.
  4. Analysis & Calculations: Triaxial Test (CU) results sheet, including data analysis and calculations for CU test results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Analyze and interpret Triaxial CU Test Data for undrained triaxial tests.
  • Perform data analysis and calculations for shear strength parameters and other test results.
  • Ideal for geotechnical investigations, foundation design, and soil testing.
  • Used for teaching and learning about triaxial test results and soil mechanics.
  • A practical tool for fieldwork and lab testing in geotechnical engineering.

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