Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load

[GEO-2025-0104-A] – By Dr. Ahmad Fahmi

We are pleased to present the Bearing Capacity Calculator using Hansen’s Method for shallow foundations under inclined loads. This advanced set of 10 professional spreadsheets developed by GEOtExcel Co. allows engineers and students to calculate the bearing capacity of foundations when subjected to inclined loads.

This product is perfect for foundation engineers involved in designing shallow foundations subjected to various angles of inclination. By using this tool, you can determine the effect of loading inclination on the bearing capacity, an essential factor in geotechnical and foundation engineering.

What’s Included in the 10 Spreadsheets?

Start: Start Sheet – Introduction to the Hansen method for calculating bearing capacity under inclined loads.

  1. Angles: Introducing the Alpha, Beta, and Theta Angles – Explanation of different angles affecting bearing capacity.
  2. Hansen-Inclined Load: Main Super Sheet – Core sheet for calculating the bearing capacity using the Hansen method under inclined loads.
  3. C1-C7: Calculation Sheets – Detailed calculation sheets that handle various angles and loading conditions.

Applications in Foundation Engineering:

  • Hansen Method: Apply the Hansen method to calculate bearing capacity for shallow foundations under inclined loads.
  • Inclined Loads: Account for the effect of inclined loading on bearing capacity, which is crucial for foundations subjected to sloping or angled loads.
  • Practical Tool: Ideal for foundation design and geotechnical engineers working with shallow foundations.
  • Educational Use: Useful for students and professors in foundation engineering and geotechnical engineering courses.
  • Comprehensive Analysis: Includes all necessary calculations for bearing capacity factors, shape, depth factors, and more.

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

Advanced Soil Mechanics – Critical State Mechanics – MCC Model (CD Triaxial Test) | Geotechnical Excel Spreadsheets

by

Advanced Soil Mechanics – Critical State Mechanics (MCC Model) for CD Triaxial Test

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

We are excited to introduce the Critical State Mechanics spreadsheet pack based on the Modified Cam Clay (MCC) Model for the CD Triaxial Test. This advanced set of 7 professional spreadsheets developed by GEOtExcel Co. is designed for soil mechanics professionals, students, and geotechnical engineers to classify soils into Normally Consolidated (NC), Lightly Over-consolidated (LOC), and Highly Over-consolidated (HOC) clays.

This tool is essential for understanding critical state mechanics, enabling accurate modeling of soil behavior under compression and tension conditions. It’s a vital resource for professionals involved in geotechnical engineering projects, foundation design, and soil testing.

What’s Included in the 7 Spreadsheets?

  1. Start: Start Sheet – Overview and setup for the MCC model and CD triaxial test calculations.
  2. MCC-CD: Main Super Sheet – Critical State Mechanics using the MCC model for CD triaxial test.
  3. Cal1 to Cal5: Calculation Sheets – Various sheets to calculate and analyze data for NC, LOC, and HOC clay classifications.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Critical State Mechanics: Implement MCC model for modeling soil behavior and failure states under compression and tension.
  • Soil Classification: Classify soils into Normally Consolidated (NC), Lightly Over-consolidated (LOC), and Highly Over-consolidated (HOC) using MCC and triaxial test data.
  • Triaxial Test Analysis: Conduct comprehensive analysis of CD triaxial tests, including effective stress and critical state conditions.
  • Soil Behavior Simulation: Essential for simulating soil behavior in geotechnical and foundation engineering applications.
  • Practical Tool: Ideal for soil testing labs, foundation design, and geotechnical engineers working with clay soils.
  • Educational Use: Useful in soil mechanics and geotechnical engineering courses focusing on critical state soil mechanics and advanced triaxial testing.

📦 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) – Clay & Silt Classification with Plasticity Chart

by

Soil Mechanics – Unified Soil Classification System (USCS) – Geotechnical Excel Spreadsheets

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

We are thrilled to introduce the Unified Soil Classification System (USCS) spreadsheet pack for Clay and Silt soils, developed by GEOtExcel Co.. This pack includes 5 professional spreadsheets, designed to help soil mechanics professionals, students, and geotechnical engineers classify clay and silt soils based on the Plasticity Chart and the Atterberg Limits test data.

This spreadsheet pack is an invaluable tool for anyone involved in soil classification, offering easy-to-use formulas and visual tools for determining the plasticity index and shrinkage limits of soils, specifically for CL, CH, ML, and MH soil types.

What’s Included in the 5 Spreadsheets?

  1. DATA: Soil Classification Data for CL, CH, ML, and MH soils under the USCS system.
  2. USCS: Excel Spreadsheet for the Unified Soil Classification System (USCS) for clay and silt soils.
  3. Analysis Sheet: Soil Classification Analysis Sheet: Includes particle size curve and plasticity chart for USCS classification.
  4. Plasticity Chart: Understanding the Components of the Plasticity Chart for classifying soil based on Atterberg limits.
  5. Shrinkage Limit: Determining the Shrinkage Limit using the Plasticity Chart and Atterberg limits test data.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Classification: Use the USCS to classify clay and silt soils and calculate the plasticity index and shrinkage limits.
  • Plasticity Chart Analysis: Classify soils based on their plasticity index and assess their suitability for various engineering applications.
  • Shrinkage Limit Determination: Analyze and determine the shrinkage limit of soils using Atterberg limits test data.
  • Practical Tool: Ideal for soil testing, foundation design, and geotechnical analysis in civil engineering projects.
  • Educational Use: A useful tool for students and professors in soil mechanics and geotechnical engineering courses, helping students better understand the plasticity chart and soil classification.

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

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension) | Geotechnical Excel Spreadsheets

by

Determining Deviatoric Stress at Active & Passive Failure State of Soil (Compression & Tension)

[GEO-2025-0131]

We are pleased to present the Deviatoric Stress at Active and Passive Failure States spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set of 4 powerful spreadsheets enables soil mechanics professionals, students, and geotechnical engineers to calculate deviatoric stress at the active and passive failure states of soil under compression and tension conditions.

The pack also includes tools to calculate failure surfaces and provides a comprehensive solution for analyzing soil behavior under different failure conditions, making it essential for foundation design and soil stability analysis.

What’s Included in the 4 Spreadsheets?

  1. Problem1: Determining Deviatoric Stress at Active Failure State of Soil – Calculate deviatoric stress for the active failure state of soil under compression.
  2. Problem2: Determining Deviatoric Stress at Passive Failure State of Soil – Calculate deviatoric stress for the passive failure state of soil under tension.
  3. Solution: Determining Deviatoric Stress at Soil Failure – Comprehensive solution for calculating deviatoric stress at active and passive failure states of soil.
  4. Failure Surface: Determining Failure Surface – Analyze and calculate the failure surface for soil under both compression and tension.

Applications in Soil Mechanics and Geotechnical Engineering:

Deviatoric Stress Calculation: Accurately calculate deviatoric stress at active and passive failure states of soil for both compression and tension conditions.

  • Failure State Analysis: Understand and analyze the active and passive failure states in soil mechanics.
  • Failure Surface Calculation: Calculate and visualize failure surfaces for soil under load conditions, aiding in foundation design and soil stability assessments.
  • Practical Use: Ideal for geotechnical engineers, soil mechanics professionals, and students working on soil behavior and failure analysis in foundation design.
  • Educational Tool: A valuable teaching aid for soil mechanics and geotechnical engineering courses focused on failure states and stress 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 – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) / Geotechnical Excel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading)

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

We are excited to introduce the Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 4 essential spreadsheets designed to help soil mechanics professionals, students, and geotechnical engineers calculate and analyze vertical stress distribution in soil under rectangular loading using Boussinesq theory.

This pack provides solutions for computing stress distribution and includes influence charts that are crucial for foundation design and soil behavior analysis in areas affected by varying load conditions.

What’s Included in the 4 Spreadsheets?

  1. Start: Stress Distribution in Soil – Boussinesq Theory – Rectangular Loading – Introduction sheet for stress distribution analysis.
  2. Rectangular Loading: Calculation Sheet for Stress Distribution in soil using Boussinesq Theory for vertical stress calculation.
  3. Influence-Main: Influence Chart for Computing Vertical Stress – Visual tool for calculating stress distribution.
  4. Influence-Image: Influence Chart Image – A graphical representation of the influence chart for stress calculations.

Applications in Soil Mechanics and Geotechnical Engineering:7

  • Stress Distribution: Use Boussinesq theory to calculate vertical stress distribution in soil under rectangular loading conditions.
  • Influence Charts: Generate and interpret influence charts for accurate stress calculations in different soil conditions.
  • Foundation Design: Essential for designing foundations in geotechnical engineering projects affected by varying load distribution.
  • Practical Tool: Ideal for soil testing, foundation stability analysis, and site investigations in geotechnical projects.
  • Educational Tool: Useful for soil mechanics and geotechnical engineering courses focusing on load distribution and stress analysis in soils.

📦 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 – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Effective Stress with Double Layer and Groundwater Oscillation spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 16 powerful spreadsheets designed for soil mechanics professionals, students, and geotechnical engineers to analyze the effects of groundwater oscillation on effective stress variation in double layer soil systems.

This pack enables users to perform detailed calculations for total stress, pore water pressure, and effective stress, before and after groundwater oscillation, which is essential for foundation and soil stability analysis in areas affected by fluctuating water levels.

What’s Included in the 16 Spreadsheets?

  1. Start: Effective Stress (kg-Layout 1) – Introduction sheet for calculating effective stress in double layer soil systems.
  2. Double Layer-kg: Main Super Sheet – Analyzing the effect of groundwater oscillation on effective stress variation (kg/m²).
  3. D1: Calculation Sheet 1 – Total Stress Calculation and graph before groundwater oscillation.
  4. D2: Calculation Sheet 2 – Pore Water Pressure Calculation and graph before groundwater oscillation.
  5. D3: Calculation Sheet 3 – Effective Stress Calculation and graph before groundwater oscillation.
  6. D4: Calculation Sheet 1 – Total Stress Calculation and graph after groundwater oscillation.
  7. D5: Calculation Sheet 1 – Pore Water Pressure Calculation and graph after groundwater oscillation.
  8. D6: Calculation Sheet 1 – Effective Stress Calculation and graph after groundwater oscillation.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Effective Stress Calculation: Calculate the effective stress in double layer soils under varying groundwater conditions.
  • Groundwater Oscillation Effects: Analyze how oscillating groundwater affects total stress, pore water pressure, and effective stress.
  • Foundation Design: Essential for designing foundations in areas where groundwater levels fluctuate.
  • Practical Tool: Ideal for geotechnical engineers, soil mechanics professionals, and students working on foundation stability and soil behavior analysis.
  • Educational Use: A valuable teaching tool for soil mechanics and geotechnical engineering courses, particularly for understanding stress variations under groundwater changes.

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

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

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

We are pleased to present the Bearing Capacity Comparison of Classic Methods spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This comprehensive set includes 15 powerful spreadsheets designed to help soil mechanics professionals and students compare bearing capacity using the classic methods of Terzaghi, Vesic, and Meyerhof. The pack allows you to calculate bearing capacity factors, shape and depth factors, and analyze solutions for different foundation types.

These spreadsheets are essential for foundation engineers, geotechnical engineers, and students who need to understand and apply these classic methods for real-world foundation design.

What’s Included in the 15 Spreadsheets?

  1. Start: GEOtExcel: Foundation Engineering-Bearing Capacity Calculator – Comprehensive Comparison – Overview and introduction sheet.
  2. Problem: A rectangular foundation with width B, length L, and other parameters for various student IDs.
  3. Problem-public: Rectangular foundation analysis for public student ID.
  4. Comprehensive Comparison: Comprehensive Bearing Capacity Comparison using Terzaghi, Vesic, and Meyerhof methods.
  5. N Factors: Bearing Capacity Factors (Nc, Nq, and Ng) – Formulas for calculating key bearing capacity factors.
  6. Bearing-Capacity Factors: Comprehensive Bearing Capacity Factors calculation for Terzaghi, Vesic, and Meyerhof methods.
  7. Shape & Depth Factors: Comprehensive Shape and Depth Factors for Vesic, Hansen, and Meyerhof methods.
  8. Terzaghi: Solution Using Terzaghi Bearing Capacity Calculator – Layout 1 for a rectangular foundation.
  9. Vesic1: Solution Using Vesic Bearing Capacity Calculator for a rectangular foundation.
  10. Vesic2: Solution Using Vesic Bearing Capacity Calculator – Layout 2 for a more detailed analysis.
  11. Shape & Depth Factors-(V): Comprehensive Shape and Depth Factors for Vesic’s Method.
  12. Hansen: Solution Using Hansen Bearing Capacity Calculator for a rectangular foundation.
  13. Shape & Depth-(H): Comprehensive Shape and Depth Factors for Hansen’s Method.
  14. Meyerhof: Solution Using Meyerhof Bearing Capacity Calculator for a rectangular foundation.
  15. Shape & Depth-(M): Comprehensive Shape and Depth Factors for Meyerhof’s Method.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Bearing Capacity Comparison: Compare Terzaghi, Vesic, and Meyerhof methods for estimating foundation bearing capacity.
  • Practical Solutions: Use comprehensive solutions and calculations for rectangular foundations and varying foundation depths.
  • Bearing Capacity Factors: Calculate Nc, Nq, and Ng bearing capacity factors for accurate foundation design.
  • Shape and Depth Factors: Understand how shape and depth factors influence bearing capacity in each method.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses on foundation design and bearing capacity analysis.
  • Real-World Application: Essential for geotechnical engineers, foundation design, and site investigations.

📦 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 – Flow Net & Flow Rate Concept for Dams | Seepage Analysis | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Flow Net & Flow Rate Concept for Dams | Seepage Analysis | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Flow Net & Flow Rate Concept spreadsheet pack for dams, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics professionals and students to analyze and calculate flow net and flow rate beneath concrete dams, with a focus on seepage analysis through soil at an angle α to the horizontal.

These spreadsheets provide detailed calculations and analysis for flow channels, potential drops, and the flow rate formula beneath a concrete dam, along with Darcy’s Law applications in various soil sections (circle, rectangle, and square).

What’s Included in the 8 Spreadsheets?

  1. Start: GEOtExcel: Flow Net Concept & Calculation – Introduction to the flow net concept and seepage analysis.
  2. Flow Net-Dam-01: Flow Channels and Potential Drops Beneath a Concrete Dam – Layout 1.
  3. Flow Net-Dam-02: Flow Channels and Potential Drops Beneath a Concrete Dam – Layout 2.
  4. Darcy’s law-Circle: Seepage through soil at an angle α to the horizontal – Circular section analysis using Darcy’s Law.
  5. Darcy’s law-Rectangle: Seepage through soil at an angle α to the horizontal – Rectangular section analysis using Darcy’s Law.
  6. Darcy’s law-Square: Seepage through soil at an angle α to the horizontal – Square section analysis using Darcy’s Law.
  7. Formula Concept: Flow Rate Calculation Beneath a Concrete Dam – Formula concept and calculation for seepage through soil.
  8. Concept Conclusion: Flow Rate Calculation Beneath a Concrete Dam – Concept conclusion and summary of results.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage Analysis: Understand seepage through soil beneath concrete dams, considering flow at an angle α to the horizontal.
  • Flow Rate Calculations: Accurately calculate flow rate for soil water movement beneath a dam using Darcy’s Law.
  • Flow Channel Analysis: Calculate flow channels and potential drops in different soil sections (circle, rectangle, square).
  • Dam Design: Essential for dam engineering, hydrological studies, and foundation design.
  • Ideal for Geotechnical Engineers: Useful for site investigations, groundwater flow analysis, and foundation stability.
  • Educational Tool: Perfect for soil mechanics and geotechnical engineering courses focused on seepage and flow behavior.

📦 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 through Soil at an Angle α to the Horizontal | Darcy’s Law | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Seepage through Soil at an Angle α to the Horizontal | Darcy’s Law | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Seepage through Soil at an Angle α to the Horizontal spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 9 essential spreadsheets designed for soil mechanics professionals and students to analyze seepage through soil using Darcy’s Law. The pack focuses on seepage analysis in soils when the flow occurs at an angle to the horizontal, a crucial consideration in geotechnical engineering projects like drainage systems, earth dam design, and foundation investigations.

What’s Included in the 9 Spreadsheets?

  1. Start: Darcy’s Law Start Sheet – Introduction to seepage through soil at an angle α to the horizontal.
  2. Darcy’s law alpha-01: Hydraulic Gradient Concept – Part 1 – Introduction to hydraulic gradient and its application in seepage analysis.
  3. Darcy’s law alpha-02: Hydraulic Gradient Concept – Part 2 – Further exploration of the hydraulic gradient concept and its impact on flow behavior.
  4. Darcy’s law alpha-03: Darcy’s Law Concept – Part 1 – Basics of Darcy’s Law applied to soil seepage at an angle.
  5. Darcy’s law alpha-04: Darcy’s Law Concept – Part 2 – Advanced calculations using Darcy’s Law in seepage scenarios with a focus on angles.
  6. Darcy’s law alpha-05: Flow Rate Calculation – Part 1 – Calculating flow rate through soil using Darcy’s Law for angled flow.
  7. Darcy’s law alpha-06: Flow Rate Calculation – Part 2 – Continuing flow rate analysis with Darcy’s Law for angled soil conditions.
  8. Darcy’s law alpha-07: Flow Rate Calculation – Part 3 – Final calculations and visualizing flow rate for seepage through soils at an angle.
  9. Darcy’s law alpha-08: Flow Rate Calculation – Part 4 – Additional advanced calculations for seepage flow rate in soils subjected to angled conditions.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Seepage Analysis: Understand and calculate seepage through soil at an angle using Darcy’s Law.
  • Flow Rate Calculations: Calculate flow rate for soil water movement in geotechnical projects like dam engineering, groundwater studies, and foundation designs.
  • Hydraulic Gradient: Analyze the hydraulic gradient and its relationship with flow direction and soil permeability.
  • Ideal for Geotechnical Engineers: A valuable tool for drainage systems, subsurface investigations, and soil permeability tests.
  • Educational Use: Perfect for soil mechanics and geotechnical engineering courses focused on seepage and soil behavior.
  • Practical Tool: Applicable in real-world geotechnical projects, including foundation design, soil permeability testing, and geotechnical investigations.

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