Soil Testing

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 – Compaction, Consolidation & Swelling | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Compaction, Consolidation & Swelling | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Compaction, Consolidation, and Swelling spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 11 valuable spreadsheets for soil mechanics professionals and students, designed to explain and calculate the processes of compaction, consolidation, and swelling in soils under different moisture conditions.

This pack helps you understand soil behavior under varying compaction scenarios and their effects on soil properties, offering insights into practical applications and theoretical calculations.

What’s Included in the 11 Spreadsheets?

  1. Start: GEOtExcel: Compaction, Consolidation, and Swelling – Overview and introduction sheet.
  2. Compaction1: Compaction Concept – Expulsion of air from soil voids, Layout 1.
  3. Compaction2: Compaction Concept – Expulsion of air from soil voids, Layout 2.
  4. Compaction3: Compaction Concept – Expulsion of air from soil voids, Layout 3.
  5. Example1: Compaction Concept Example – For dry soil conditions.
  6. Example2: Compaction Concept Example – For slightly moist soil conditions.
  7. Example3: Compaction Concept Example – For moderately moist soil conditions.
  8. Example4: Compaction Concept Example – For lightly moist soil conditions.
  9. Example5: Compaction Concept Example – For saturated soil conditions.
  10. Consolidation: Consolidation Concept – Theory and calculation for soil consolidation.
  11. Swelling: Swelling Concept – For sand and clay soils, covering volume changes and behaviors.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Compaction: Calculate and visualize how air expulsion affects soil density in different moisture conditions.
  • Consolidation Analysis: Understand and calculate soil consolidation over time under applied pressure.
  • Swelling Behavior: Analyze the swelling potential of sand and clay soils, crucial for foundation design and site investigations.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses.
  • Practical Tool: Use for field testing, laboratory analysis, and geotechnical site investigations.
  • Comprehensive Examples: Detailed examples for a wide range of soil moisture conditions, helping students and professionals apply the concepts in real-world scenarios.

📦 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 – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

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

We are excited to present the Seepage & Darcy’s Law spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics and geotechnical engineering professionals to analyze and calculate seepage, hydraulic gradient, and flow rate using Darcy’s Law.

What’s Included in the 8 Spreadsheets?

  1. Start: Introduction sheet to Darcy’s Law and seepage analysis.
  2. Darcy’s law-01: Hydraulic gradient concept — Part 1.
  3. Darcy’s law-02: Hydraulic gradient concept — Part 2.
  4. Darcy’s law-03: Darcy’s Law concept — Part 1, with visual explanations.
  5. Darcy’s law-04: Darcy’s Law concept — Part 2, focusing on soil characteristics and flow.
  6. Darcy’s law-05: Darcy’s Law flow rate calculation — Part 1, covering theoretical concepts.
  7. Darcy’s law-06: Darcy’s Law flow rate calculation — Part 2, applying real data.
  8. Darcy’s law-07: Darcy’s Law flow rate calculation — Part 3, advanced application and results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage and Flow Rate Analysis: Calculate flow rate and seepage in soil based on Darcy’s law.
  • Hydraulic Gradient: Understand and apply the hydraulic gradient concept in various soil conditions.
  • Darcy’s Law: Deep dive into Darcy’s law for seepage and fluid flow through porous materials.
  • Practical Tools for soil mechanics and geotechnical engineering projects.
  • Laboratory & Field Testing: Use for soil testing and site investigations in civil and geotechnical projects.
  • Educational Use: Ideal for students, lecturers, and professionals learning and applying seepage analysis.

📦 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 – Triaxial CU Test (Real Results) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Triaxial CU Test (Real Results) | Geotechnical Excel Spreadsheets

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

We are proud to introduce the Triaxial CU Test (Real Results) spreadsheet pack as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This pack includes 4 essential spreadsheets designed to help geotechnical engineers, soil mechanics students, and civil engineers analyze consolidated undrained triaxial test data (CU tests) for accurate soil behavior analysis and calculation of shear strength parameters.

What’s Included in the 4 Spreadsheets?

  1. Start: Summary of Triaxial CU Test Data with key variables and results.
  2. Locked Calculation Sheet: Internal calculation sheet (not for users) for automated data processing.
  3. Data: Consolidated undrained Triaxial Test Data, providing input values and soil test results.
  4. Analysis & Calculations: Triaxial Test (CU) results sheet, including data analysis and calculations for CU test results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Analyze and interpret Triaxial CU Test Data for undrained triaxial tests.
  • Perform data analysis and calculations for shear strength parameters and other test results.
  • Ideal for geotechnical investigations, foundation design, and soil testing.
  • Used for teaching and learning about triaxial test results and soil mechanics.
  • A practical tool for fieldwork and lab testing in geotechnical engineering.

📦 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 – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Consolidation spreadsheet pack for single and double drainage scenarios as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 5 essential spreadsheets designed for soil mechanics calculations, focusing on consolidation under different drainage conditions. The pack includes detailed calculations and graphs for total stress, pore water pressure, effective stress, and provides insights into stress distribution in soil.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Consolidation, covering single drainage and double drainage methods.
  2. Single drainage-min: Single drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  3. Single drainage-day: Single drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.
  4. Double Drainage-min: Double drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
  5. Double Drainage-day: Double drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Calculate consolidation for soil under both single and double drainage conditions.
  • Analyze coefficient of consolidation (Cv) in different units: cm²/min and m²/day.
  • Single Drainage vs. Double Drainage scenario comparisons for soil consolidation.
  • Consolidation testing and fieldwork for soil behavior in various drainage conditions.
  • Educational use for soil mechanics and geotechnical engineering courses.
  • Practical tool for civil engineers working on foundation and soil stability projects.

📦 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 – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil (Boussinesq Method) | Point Load Analysis | GEOtExcel Spreadsheets

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

We are pleased to introduce the Stress Distribution in Soil (Boussinesq Method) spreadsheet pack, part of the GEOtExcel (2025-1) collection. This pack includes 5 powerful spreadsheets designed for geotechnical engineers, soil mechanics students, and civil engineering professionals who need to analyze stress distribution in soil under a point load using the Boussinesq method. The spreadsheets cover detailed total stress, pore water pressure, effective stress calculations, and provide graphical insights into the stress distribution.

What’s Included in the 5 Spreadsheets?

  1. Start: The introductory sheet for Stress Distribution in Soil using the Boussinesq Method.
  2. Boussinesq: Boussinesq’s Formula for point load stress distribution in soil.
  3. Point Load1: Stress distribution analysis for Point Load with stress-x graph visualization.
  4. Point Load2: Stress distribution analysis for Point Load with z-stress graph.
  5. Pressure Bulb: Pressure bulb analysis for point load stress distribution in soil.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Stress Distribution Analysis: Accurately calculate stress distribution in soil using the Boussinesq method.
  • Point Load Analysis: Determine the effects of point load on stress distribution in soil layers.
  • Graphical Representation: Visualize stress-x and z-stress graphs for better understanding of soil behavior.
  • Pressure Bulb Analysis: Analyze and visualize the pressure bulb around a point load in soil.
  • Teaching & Learning Tool: Ideal for soil mechanics and geotechnical engineering education and practical use.
  • Field Work & Lab Testing: Use for site investigations and laboratory experiments to analyze soil response under load.

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

Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics

Foundation Engineering

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: