Understanding Soil Phase Relationships (e, n, Sr, w, Gs & Other Parameters in Excel)

by

✅ Soil Mechanics Lecture: “Soil Phase Relationships”
✅ Unique Excel Spreadsheets: Geotechnical Excel Spreadsheets(GEOtExcel)

✅ Multi-Language Video: The subtitles in this video are accurate, so you can enable auto-translate to listen to the video in any language you prefer.

✅ Discover the fundamentals of weight-volume relationships in soil mechanics. Learn how to calculate and interpret soil unit weight, porosity, void ratio, and moisture content, and other volume-weight parameters.
✅ Understanding the relationships between different phases of soil is essential in geotechnical engineering and soil science. These relationships define how the solid particles, water, and air within soil interact and exist together. Soil is composed of these three phases, and the proportion and interaction of each phase affect soil properties like density, porosity, and moisture content. By studying these phase relationships, engineers can better predict soil behavior under various conditions, aiding in the design and construction of stable and safe structures. Join us as we delve into the basics of soil phase relationships and their practical applications in engineering.

The Link on the YouTube Channel:
https://youtu.be/a83_VRxPKe8

✅ About:
I am an assistant professor at the University. I have nearly 20 years of experience instructing geotechnical engineering courses. As an Academic Staff Member and a Geotechnical Engineer, my unwavering passion lies in revolutionizing geotechnical engineering education through innovation. My work centers around the GEOtExcel Project, where I design and develop innovative Geotechnical Excel spreadsheets including :

Soil mechanics Spreadsheets

Foundation Engineering Spreadsheets

Spreadsheets for Soil mechanical tests

✅ These interesting tools serve both educational and practical purposes in the field of geotechnical engineering. My vision is to make learning not only informative but also enjoyable. Through the GeotExcel Project, I aim to provide students, educators, and professionals with interactive, user-friendly spreadsheets that enhance the learning and designing experience.

✅ Stay tuned for exciting updates, as I will soon be unveiling a series of free and commercial spreadsheets designed with added features, advanced tools, and dedicated support to meet your specific requirements. Join me on this educational journey, where we transform the way we teach and learn in the realm of geotechnical engineering. Let’s make education a delightful and enriching experience together.
✅ My Youtube channel : GEOtExcel:
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
✅ My website address:
https://geotexcel.com/

Designed & Presented by Dr. Ahmad Fahmi

How to use a plasticity chart to classify fine-grained soil?

by

✅ GEOtExcel: Soil Mechanics & Foundation Engineering Excel Spreadsheets:
☑ Soil Plasticity Chart:
▶ https://lnkd.in/dy5BYv8S
PI: Soil Plasticity index
LL: Soil Liquid Limit
A line: PI=0.73(LL-20)
U Line: PI=0.90(LL-8)
CL, CH, ML, MH, CL-ML

📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

soilmechanics #soil_mechanics #soil_plasticity #foundation_engineering #excel_Spreadsheet #excel

The Link on the YouTube Channel:
https://youtu.be/O3B06zcb6D4

How is the flow rate through the soil beneath a concrete dam calculated? Excel Spreadsheet

by

✅ GEOtExcel: Soil Mechanics & Foundation Engineering Excel Spreadsheets:
▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
✅ Soil mechanics: Seepage:Flow Nets: Flow Rate Calculation
✅ Concept-oriented Excel Spreadsheet
▶ More Videos on Our YouTube Channel:
▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

soil_mechanics #soil_mechanics #seepage #foundation_engineering #excel_Spreadsheet #excel #equipotential #flow_net #flow_rate

The Link on the YouTube Channel:
https://youtu.be/CBNMKoEMhV4

How can we calculate the flow rate through soil using Darcy’s law?

by

✅ GEOtExcel: Soil Mechanics & Foundation Engineering Excel Spreadsheets:
☑ Soil mechanics: Darcy’s law (alpha version):
✅ YouTube channel Address:
▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Hydraulic gradient, velocity and flow rate calculation:
📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

soilmechanics #soil_mechanics #Darcy_law #foundation_engineering #excel_Spreadsheet #excel #Hydraulic_gradient #flow_rate

The Link on the YouTube Channel:
https://youtu.be/YqRafl_g9Wo

What is the concept of the equipotential lines in seepage?

by

What is the concept of the equipotential lines in seepage?

What do equipotential lines represent in flow net?

✅ GEOtExcel: Soil Mechanics & Foundation Engineering Excel Spreadsheets:
✅ Soil mechanics: Seepage:Flow Nets:
✅ Equipotential lines: Concept
▶ More Videos on Our YouTube Channel:
▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

#soilmechanics #soil_mechanics #seepage #foundation_engineering #excel_Spreadsheet #excel #equipotential #flow_net

The Link on the YouTube Channel:
https://youtu.be/YkrkLgN6AR4

Hydraulic Gradient & Darcy’s Law: An Innovative Excel Spreadsheet

by

How can we calculate the hydraulic gradient between two points in the soil? How can we calculate the flow rate through soil using Darcy’s law?

✅ GEOtExcel: Soil Mechanics & Foundation Engineering Excel Spreadsheets:
✅ Soil mechanics: Hydraulic gradient:
✅Darcy’s Law: Hydraulic gradient, velocity and flow rate calculation
▶ More Videos on Our YouTube Channel:
l▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

The Link on the YouTube Channel:
https://youtu.be/NhJcIhNqUrs

Excel Spreadsheet for Rock Quality Designation Calculation

by

Excel Spreadsheet: #geotechnical_engineering #rock_quality #excel_spreadsheet :

✅ GEOtExcel: Soil Mechanics,Foundation Engineering & Engineering Geology Excel Spreadsheets:
✅ Geotechnical Engineering: Engineering Geology: RQD Calculation (Rock Quality Designation)
✅ Concept-oriented Excel Spreadsheet: RQD Concept (Random core samples, Random Examples)

▶ More Videos on Our YouTube Channel:
▶ https://www.youtube.com/@Dr.Fahmi.GEOtExcel
📊 Geotechnical Excel Spreadsheets
Designed by Dr. Ahmad Fahmi

Rock Quality Designation (RQD) measures the quality of rock cores from boreholes by calculating the percentage of core pieces longer than 10 cm. It helps assess rock mass integrity, with higher RQD values indicating better quality rock with fewer fractures, and lower values indicating more fractured, poorer quality rock.

The Link on the YouTube Channel:

https://youtu.be/_NDWS6mmM9w

How does changing the internal friction angle of the soil affect the bearing capacity? (Excel Spreadsheet)

by

Excel Spreadsheet: #foundation_engineering #bearing_capacity #excel_spreadsheet :

The failure zone under a foundation can be divided into three key parts:
1- Triangular Zone: This zone, directly beneath the foundation, fails in a triangular pattern due to compression. Higher friction angles result in a larger triangular zone, as the soil can better withstand compression without failure.
2- Radial (Logarithmic Spiral) Shear Zone: This zone represents the path of soil failure around the foundation in a spiral pattern. With higher friction angles, the radial shear zone tends to be larger, as the soil can resist shear stresses more effectively.
3- Triangular Rankine Passive Zone: Located outside the failure surface, this zone is under passive stress and contributes to the bearing capacity. Higher friction angles lead to a larger Rankine passive zone, providing more support to the foundation.
💎 In summary, higher friction angles result in larger triple zones, including the triangular, radial shear, and Rankine passive zones. This enlargement collectively contributes to a higher bearing capacity for the foundation.

The Link on the YouTube Channel:

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Soil Mechanics/Unified Soil Classification System (USCS)/Excel Spreadsheet

by

Excel Spreadsheet: #soilmechanics #Soil Classification #USCS :

The Unified Soil Classification System (USCS) is a widely-used method for categorizing soils based on their engineering properties. It classifies soils into two main groups: coarse-grained soils, such as gravels and sands, and fine-grained soils, including silts and clays. Within these groups, soils are further classified based on their grain size distribution, plasticity, and compressibility characteristics. This system utilizes a combination of letters and symbols to represent various soil types, such as GW for well-graded gravels, SM for silty sands, and CL for low-plasticity clays. The USCS provides engineers and geologists with a standardized framework for understanding and analyzing soil behavior in construction and geotechnical applications.

The Link on the YouTube Channel:

https://www.youtube.com/watch?v=MRlMFXpHtgw

Soil Mechanics: Shear Strength: Triaxial CD & CU Tests (Excel Spreadsheets)

by

Excel Spreadsheet: #soilmechanics #Shear Strength #Triaxial CD & CU Tests :

The triaxial shear tests, including the consolidated drained (CD) and consolidated undrained (CU) tests, are essential in geotechnical engineering. They provide valuable data on soil behavior under different loading conditions. The CD test assesses shear strength parameters like cohesion and angle of internal friction, while the CU test helps evaluate undrained shear strength, particularly important for saturated soils. Results from these tests inform foundation design, slope stability analysis, and other geotechnical considerations in construction projects.The triaxial shear tests, including the consolidated drained (CD) and consolidated undrained (CU) tests, are essential in geotechnical engineering. They provide valuable data on soil behavior under different loading conditions. The CD test assesses shear strength parameters like cohesion and angle of internal friction, while the CU test helps evaluate undrained shear strength, particularly important for saturated soils. Results from these tests inform foundation design, slope stability analysis, and other geotechnical considerations in construction projects.

The Link on the YouTube Channel:

https://www.youtube.com/watch?v=5NvPIB1CEzk&t=46s

https://www.youtube.com/watch?v=ABzuZtPJ1-o