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:

Leave a Comment