GP-GM Soil

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: