Sieve Analysis

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

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