Civil Engineering Tools

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 – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

by

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

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

We are excited to present the Effective Stress for Single Layer Soil Profile spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 20 sheets, designed for geotechnical engineers, soil mechanics students, and civil engineers looking to calculate and visualize effective stress in a single-layer soil profile. The pack includes essential calculations and graphs for total stress, pore water pressure, and effective stress in both kg/m² and kN/m² units.

What’s Included in the 20 Spreadsheets?

  1. Start: Introduction sheet for Effective Stress calculations (kg-Layout 1).
  2. Single Layer-kg: Main sheet explaining the Effective Stress concept for a single-layer profile in kg/m².
  3. TS-01: Calculation Sheet 1 for Total Stress calculation and associated graph.
  4. u-01: Calculation Sheet 2 for Pore Water Pressure calculation and graph.
  5. ES-01: Calculation Sheet 3 for Effective Stress calculation and graph.
  6. [GEO-2025-0122-A] – kg-Layout 1: Effective Stress layout for kg/m².
  7. [GEO-2025-0122-B] – kg-Layout 2: Second layout for Effective Stress using kg/m².
  8. [GEO-2025-0122-C] – kN-Layout 1: Effective Stress layout for kN/m².
  9. [GEO-2025-0122-D] – kN-Layout 2: Second layout for Effective Stress using kN/m².

Applications in Soil Mechanics and Geotechnical Engineering:

  • Performing effective stress analysis in single-layer soil profiles
  • Calculating and visualizing total stress, pore water pressure, and effective stress
  • Teaching and learning about effective stress concepts in soil mechanics
  • Suitable for geotechnical testing, field work, and laboratory experiments
  • Ideal for use in civil engineering projects and foundation design
  • Comprehensive graphs for visual understanding and data interpretation

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