Soil Classification

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]

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

by

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

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

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

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

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

What’s Included in the Product:

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

Applications in Soil Mechanics and Geotechnical Engineering:

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

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Soil Classification (USCS) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Soil Classification (USCS)

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

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

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

What’s Included in the 44 Spreadsheets?

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

Applications in Soil Mechanics and Geotechnical Engineering:

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

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

[GEO-2025-0116]

[GEO-2025-0117]

[GEO-2025-0118]

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

by

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

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

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

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

What’s Included in the 7 Spreadsheets?

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

Applications in Soil Mechanics and Geotechnical Engineering:

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

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics – Unified Soil Classification System (USCS) – Clay & Silt Classification with Plasticity Chart

by

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

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

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

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

What’s Included in the 5 Spreadsheets?

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

Applications in Soil Mechanics and Geotechnical Engineering:

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

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

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

by

Soil Mechanics – Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis | Example 2 (GP-GM Soil)

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

We are pleased to introduce Example 2 (GP-GM Soil) from our Complete Soil Gradation Curve series. This set of Geotechnical Excel Spreadsheets includes 10 powerful spreadsheets for analyzing sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils (Gravelly Poorly Graded Sand and Gravel Mixture). These spreadsheets also include k-value determination and the calculation of temperature correction factors.

This set is ideal for soil mechanics professionals, students, and geotechnical engineers involved in soil classification, foundation design, and site investigations.

What’s Included in the 10 Spreadsheets?

  1. Start: Hydrometer Analysis of GP-GM Soil – Introduction sheet for analysis of GP-GM soils.
  2. Input Data: Sieve and Hydrometer Test Data – Enter the data from the sieve and hydrometer tests for full analysis.
  3. Sieve Analysis: Sieve Analysis Table and corresponding gradation curve for GP-GM soil.
  4. Hydrometer Analysis: Detailed hydrometer analysis tables for soil gradation calculations.
  5. Sieve & Hydrometer Analysis: Combining sieve and hydrometer data for full gradation analysis.
  6. USCS: Unified Soil Classification System (USCS Process Table) – Soil classification based on the USCS system.
  7. Important Note: Hydrometer test results are also necessary for accurate analysis in this particular example.
  8. Table 1: k-Value Determination based on Gs and temperature in soil hydrometer analysis.
  9. Table 2: Another k-Value Determination table for additional soil analysis.
  10. Table 3: Temperature Correction Factor (CT) determination for hydrometer analysis.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Gradation Analysis: Combine sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils.
  • Soil Classification: Classify soil using the Unified Soil Classification System (USCS) based on test data.
  • k-Value Determination: Accurately calculate k-values for soil hydrometer analysis based on specific gravity (Gs) and temperature.
  • Temperature Correction: Use the temperature correction factor (CT) to adjust for temperature variations in hydrometer analysis.
  • Practical Use: Essential for soil testing, foundation design, site investigations, and geotechnical analysis.
  • Educational Tool: Ideal for soil mechanics and geotechnical engineering students and professionals to understand soil behavior and gradations.

📦 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) – Sand Examples | Geotechnical Excel Spreadsheets

by

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

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

We are excited to present the Unified Soil Classification System (USCS) spreadsheet pack for sand examples, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 20 powerful spreadsheets that guide you through soil classification using the USCS method. The pack includes practical sand soil classification examples, providing detailed data entry and analysis for sieve analysis and Atterberg limits testing, crucial for geotechnical investigations and foundation design.

What’s Included in the 20 Spreadsheets?

  1. DATA: Unified Soil Classification System (USCS) – Five data series including sieve analysis and Atterberg limits.
  2. Data Form: Data form for sieve analysis and Atterberg limits tests.
  3. Analysis Sheet-Empty: Soil classification analysis sheet for USCS, based on sieve analysis and Atterberg limits data.
  4. USCS: USCS process table for soil classification.
  5. Examples: Example table showing five sand soil classification examples.
  6. Example 1: Example for SW: Well Graded Sand.
  7. F1: Data form for sieve analysis and Atterberg limits tests for Example 1: SW.
  8. S1: Analysis for soil classification on USCS for Example 1: SW.
  9. Problem 2: Example for SP: Well Graded Sand.
  10. F2: Data form for sieve analysis and Atterberg limits tests for Example 2: SP.
  11. S2: Analysis for soil classification on USCS for Example 2: SP.
  12. Problem 3: Example for SC: Well Graded Sand.
  13. F3: Data form for sieve analysis and Atterberg limits tests for Example 3: SC.
  14. S3: Analysis for soil classification on USCS for Example 3: SC.
  15. Problem 4: Example for SW-SC: Well Graded Gravel.
  16. F4: Data form for sieve analysis and Atterberg limits tests for Example 4: SW-SC.
  17. S4: Analysis for soil classification on USCS for Example 4: SW-SC.
  18. Problem 5: Example for SP-SC: Well Graded Sand.
  19. F5: Data form for sieve analysis and Atterberg limits tests for Example 5: SP-SC.
  20. S5: Analysis for soil classification on USCS for Example 5: SP-SC.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Perform soil classification using the USCS method for sand soils and other soil types.
  • Sieve analysis and Atterberg limits tests to determine soil properties and classify soil types.
  • Detailed examples and data forms to guide you through the process of soil classification.
  • Ideal for geotechnical engineers, civil engineers, and students working on soil classification and foundation design.
  • Practical tool for soil mechanics laboratories and field investigations.
  • Educational use in soil mechanics and geotechnical engineering 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 – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Soil Hydrometer Testing Analysis spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 7 comprehensive spreadsheets designed for geotechnical engineers and soil mechanics students to perform hydrometer analysis and determine soil properties such as effective depth, k-value, and temperature correction factors.

What’s Included in the 7 Spreadsheets?

  1. Start: The introductory sheet to begin the hydrometer analysis for soil.
  2. Calculation: Comprehensive sheet for input, computation, and output tables for the soil hydrometer analysis process.
  3. Table 1: Table for Effective Depth (L) determination based on actual hydrometer reading (RC1).
  4. Table 2: Table for k-value determination based on Gs (specific gravity) and temperature in soil hydrometer analysis.
  5. Table 2-Full: Expanded version of Table 2 for more detailed k-value determination.
  6. Table 3: Sheet for determining the Temperature Correction Factor (CT) during soil hydrometer analysis.
  7. Table 3-Full: Extended version of Table 3 for accurate temperature correction factor determination.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Perform soil classification tests using hydrometer analysis
  • Accurately determine soil’s effective depth and specific gravity (Gs)
  • Calculate k-value based on real lab data
  • Apply temperature correction factor (CT) to soil behavior analysis
  • Educational use for soil mechanics and geotechnical engineering courses
  • Useful for soil testing and lab experiments

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (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 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 specializes in integrating Excel-based solutions with soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:

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

by

Soil Mechanics – Unified Soil Classification System (USCS) Gravel Soil Examples | GEOtExcel Spreadsheets

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

We are excited to introduce the Unified Soil Classification System (USCS) Gravel Soil Examples spreadsheet pack as part of the GEOtExcel (2025-1) collection. This 20-sheet bundle is designed for geotechnical engineers, soil mechanics students, and civil engineering professionals looking to classify gravel soils using the USCS system based on sieve analysis and Atterberg limits.

What’s Included in the 20 Spreadsheets?

  1. DATA: Unified Soil Classification System data series with sieve analysis and Atterberg limits.
  2. Data Form: Standardized data form for sieve analysis and Atterberg limits tests.
  3. Analysis Sheet-Empty: Empty sheet template for soil classification based on USCS data.
  4. USCS: USCS process table to help classify soil types based on test results.
  5. Examples: Example table with five examples of gravel soils classification using USCS.
  6. Example 1 – GW: Well-graded gravel classification.
  7. F1: Data form for sieve analysis and Atterberg limits for Example 1: GW.
  8. S1: Soil classification analysis sheet for Example 1: GW based on USCS.
  9. Problem 2 – GP: Well-graded gravel classification example.
  10. F2: Data form for sieve analysis and Atterberg limits for Example 2: GP.
  11. S2: Analysis for soil classification for Example 2: GP.
  12. Problem 3 – GC: Gravelly clay soil example.
  13. F3: Data form for sieve analysis and Atterberg limits for Example 3: GC.
  14. S3: Analysis for soil classification for Example 3: GC.
  15. Problem 4 – GW-GM: Well-graded gravel-silty gravel example.
  16. F4: Data form for sieve analysis and Atterberg limits for Example 4: GW-GM.
  17. S4: Analysis for soil classification for Example 4: GW-GM.
  18. Problem 5 – GP-GC: Well-graded gravel-clay gravel example.
  19. F5: Data form for sieve analysis and Atterberg limits for Example 5: GP-GC.
  20. S5: Analysis for soil classification for Example 5: GP-GC.

Applications in Geotechnical and Civil Engineering:

  • Classification of gravel soils for construction projects
  • Performing sieve analysis and Atterberg limits tests
  • Understanding and applying the USCS soil classification system
  • Preparing data forms and analysis sheets for soil lab work
  • Teaching soil mechanics and geotechnical courses
  • Research and fieldwork in soil behavior and composition

📦 Part of the GEOtExcel 2025-1 Collection

This product is part of the comprehensive GEOtExcel (2025-1) package, featuring:

  • 12 groups
  • 50 files
  • Over 470 spreadsheets
  • Secure, permanent access
  • Available for purchase with a commercial license

For inquiries or to 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 specializes in applying Excel-based solutions for geotechnical engineering, soil mechanics, and foundation engineering.

📌 Stay Updated:

Subscribe to our channel for upcoming video lectures on: