Soil Mechanics and Foundation Engineering/ Dr. Ahmad Fahmi / Professional Excel Spreadsheet Designer
In the name of God /Dr. Ahmad Fahmi's Weblog
Soil Mechanics and Foundation Engineering/ Dr. Ahmad Fahmi / Professional Excel Spreadsheet Designer
In the name of God /Dr. Ahmad Fahmi's WeblogHow to effectively learn the concept of “Stress Distribution in Soil” using Excel spreadsheets
Stress Distribution in Soil: Boussinesq’s Method (Point Load)
Watch the Video on Our YouTube Channel (in English)
To effectively learn the concept of “Stress Distribution in Soil” using Excel spreadsheets, you can create interactive models to visualize and calculate how stress disperses under loads. By inputting parameters such as soil properties, point or distributed loads, and depth, Excel can be used to apply formulas like Boussinesq’s method or Westergaard’s theory. The spreadsheet can then automatically compute stress values at different points and generate charts or stress bulbs, making the process more intuitive and dynamic. This hands-on approach helps in understanding the complex behavior of stress distribution through visualization and iterative calculations.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
Mohr-Coulomb Failure Criterion: Conceptual and Illustrative Calculations Using Excel Spreadsheet
Mohr-Coulomb Failure Criterion
Watch the Video on Our YouTube Channel (in English)
The Mohr-Coulomb failure criterion is a fundamental concept in geotechnical engineering that describes the shear strength of soils based on cohesion and internal friction angle. It defines the conditions under which soil will fail under stress, combining normal and shear stresses on a failure plane. Using Excel spreadsheets, engineers can perform illustrative calculations by inputting parameters like cohesion, friction angle, and stress values
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
How to effectively learn the concept of "Stress Bulb" using Excel spreadsheets
Stress Distribution in Soil: Stress Bulb: Boussinesq's Method (Point Load)
Watch the Video on Our YouTube Channel (in English)
Stress distribution in soil due to a point load can be analyzed using Boussinesq's method, which provides a way to calculate how stresses spread within a soil mass. The concept of a "stress bulb" represents the area beneath the surface where the stress decreases with depth and distance from the point of load application. Boussinesq’s method assumes an elastic, isotropic, and homogeneous medium, and it helps in visualizing how vertical stress from a surface load disperses in a bulb-like pattern, with higher stresses near the load and diminishing stresses as the depth and lateral distance increase.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
Darcy's law: One-Dimensional Flow of Water Through Soils (Seepage)
Conceptual and Illustrative Calculations Using Excel Spreadsheet
Watch the Video on Our YouTube Channel (in English)
To calculate the flow rate through soil using Darcy's law, we consider factors such as the soil's hydraulic conductivity, the cross-sectional area through which the water flows, the difference in hydraulic head (the driving pressure), and the length of the flow path. Darcy's law essentially states that the flow rate is directly proportional to both the permeability of the soil and the pressure difference, while being inversely proportional to the distance the water travels. This method is commonly used to predict water movement in porous materials like soil.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
Bearing Capacity calculator: Excel spreadsheet
How to calculate the “Bearing Capacity” in an Excel spreadsheet for strip, square, and circular footings using Terzaghi’s method
Bearing Capacity calculator: Geotechnical Excel Spreadsheet (GEOtExcel)
Watch the Video on Our YouTube Channel (in English)
Full Video Lecture
Terzaghi, Hansen, Vesic, and Meyerhof developed foundational methods in geotechnical engineering for calculating soil bearing capacity. Terzaghi’s method, the earliest and most straightforward, provided a basic bearing capacity formula based on three key factors. Hansen built upon this by adding correction factors for foundation shape, depth, and load inclination. Vesic further enhanced the method, integrating plasticity theory for more accurate predictions under complex conditions. Meyerhof introduced a more generalized bearing capacity formula that accounted for the foundation’s shape, depth, and load inclination, providing a comprehensive approach to bearing capacity estimation.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi