Consolidation Archives

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?

Start: GEOtExcel: Compaction, Consolidation, and Swelling – Overview and introduction sheet.
Compaction1: Compaction Concept – Expulsion of air from soil voids, Layout 1.
Compaction2: Compaction Concept – Expulsion of air from soil voids, Layout 2.
Compaction3: Compaction Concept – Expulsion of air from soil voids, Layout 3.
Example1: Compaction Concept Example – For dry soil conditions.
Example2: Compaction Concept Example – For slightly moist soil conditions.
Example3: Compaction Concept Example – For moderately moist soil conditions.
Example4: Compaction Concept Example – For lightly moist soil conditions.
Example5: Compaction Concept Example – For saturated soil conditions.
Consolidation: Consolidation Concept – Theory and calculation for soil consolidation.
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:

📺 Geotechnical Excel YouTube Channel
💼 LinkedIn Company Page

👨‍🏫 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
Foundation Engineering
Geotechnical Lab Testing
➡️ Subscribe on YouTube

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?

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