Effective Depth

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: