Soil Testing

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

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