Foundation Engineering: Bearing Capacity Excel Spreadsheets

βœ… Terzaghi, Hansen, Vesic, and Meyerhof’s methods are foundational approaches in geotechnical engineering for determining the bearing capacity of soils. Terzaghi’s method is the earliest and simplest, providing a basic formula for bearing capacity using three key factors. Hansen expanded on Terzaghi’s work by introducing additional correction factors to account for shape, depth, and load inclination. Vesic’s method further refined these calculations by incorporating plasticity theory and offering more accurate predictions for complex conditions. Meyerhof introduced a generalized bearing capacity formula that considered the influence of the shape of the foundation, the depth of the foundation, the inclination of the load.

βœ… In Terzaghi’s method, the shape and depth factors for rectangular footings are derived from other methods (In this video).

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

Register for an Organ Donor Card (Website Addresses for Different Countries in Excel Spreadsheet)

βœ… Website Address: Register for an Organ Donor Card

πŸ“Š Excel Spreadsheet

βœ… If your country’s name is not listed in the provided Excel file and there is an organization in your country that issues organ donation cards, please share the relevant website address with me. The donation Excel file will be updated every month based on the information you provide and will be shared on my LinkedIn page. Additionally, if you have a high-quality image of an organ donation card, please send it to me so that it can be included in the file. The updated Excel spreadsheet is available in this post every month:

Vesrion1 (2024/08):

Dr. Ahmad Fahmi

#life #donation #donor_card #donorcard #donor #excel #excel_spreadsheet #spreadsheet #organ_donor_card

https://youtu.be/NYBNRPsJCtQ

Foundation Engineering: Bearing Capacity [Meyerhof’s Method]

Excel Spreadsheet: #foundation_engineering #bearing_capacity #excel_spreadsheet :

βœ… Meyerhof’s method is a widely recognized approach for determining the bearing capacity of shallow foundations in geotechnical engineering. This method takes into account various factors that influence the bearing capacity, such as the shape of the foundation, the depth of the foundation, the inclination of the load, and the properties of the soil. Meyerhof’s approach is distinguished by its comprehensive consideration of these factors, leading to a more accurate estimation of the ultimate bearing capacity.

Bearing Capacity [Meyerhof’s Method]

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

Calculating Soil Bearing Capacity: Excel Spreadsheets (Terzaghi’s Method)

Video Link:

https://youtu.be/BT0QMJ5-YJ0

βœ… Foundation Engineering Problem & Solution: “Bearing Capacity”
βœ… Terzaghi’s Method: Strip, Square and Circle Foundations
βœ… 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.

βœ… Foundation Engineering: Bearing Capacity:
Foundation engineering is a vital discipline within civil engineering that focuses on the design and construction of foundations for various structures. A key element in this field is the bearing capacity of the soil, which refers to the soil’s ability to support the loads imposed by the structure. Assessing bearing capacity is essential to ensure the foundation remains stable and secure, thereby preventing excessive settlement or structural failure. This process involves determining the maximum load per unit area that the soil can withstand without experiencing shear failure. Factors influencing bearing capacity include soil type, moisture content, density, and the dimensions of the foundation. Thorough evaluation and enhancement of bearing capacity are crucial for the durability and stability of any construction project.

βœ… In this educational and concept-focused video, you will see:
1) Calculating the Ultimate and Allowable Bearing Capacity of Strip, Square, and Circular Foundations Using Terzaghi’s Method
2) Considering the Variation of Ultimate Bearing Capacity Values with Different Soil-Foundation Parameters such as Foundation Depth, Foundation Width, Soil Cohesion, Soil Internal Friction Angle, and Soil Unit Weight
3) Considering Special Cases in the Calculation of Bearing Capacity, Such As:

  • Non-Cohesive Soils (c’=0)
  • Zero Foundation Depth (Df =0)
  • Un-drained Soil Conditions (phi’=0)
  • Combonation1: (c’=0 & Df = 0)
  • Combonation2: (Df = 0 & phi’ = 0)

βœ… Definitions:
For the Strip Foundations : B = The width of the foundation
For the Square Foundations : B = The dimension of each side of the foundation
For the Circle Foundations : B = The diameter of the foundation
Foundation Depth: Df = The depth of foundation measured from the ground surface
gamma = Unit Weight of Soil
c’ = Soil Cohesion or cu = Undrained Cohesion (phi =0)
phi’ = Angle of friction of soil
Sc , Sq & Sg : Shape Factors
FS = Factor of Safety
q = Surcharge: The soil above the bottom of the foundation can also be considered as being replaced by an equivalent surcharge (q= gamma . Df)
Nc = The bearing capacity factor related to the contribution of soil cohesion
Nq = The bearing capacity factor related to the contribution of surcharge
N(gamma) = The bearing capacity factor related to the contribution of unit weight
qu = Ultimate Bearing Capacity
q(all) = Allowable Bearing Capacity

Designed & Presented by Dr. Ahmad Fahmi

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


foundation #geotechnicalengineering #foundationengineering #engineering #soilmechanics #civilengineering #bearingcapacity #bearing #footing #engineeringeducation

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

βœ… 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?

βœ… 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

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

βœ… 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

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

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

βœ… 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?

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

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