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

In the Name of God
✅ 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.

00:00 . GEOtExcel Introduction (Dr. Ahmad Fahmi)
00:29 . General Introduction
01:28 . Problem & Solution: A) Strip Foundation
09:45 . Problem & Solution: B) Square Foundation & C) Circle Foundation
11:44 . The variation of qu by adjusting different parameters
16:59 . Special Cases (c'=0, Df=0, fi=0 and Combinations)
21:36 . Problem for Students with different student ID's
22:03 . End

✅ 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. Using Excel spreadsheets, engineers can efficiently organize and analyze these factors, calculate bearing capacity, and perform sensitivity analyses to explore the impact of different variables. Academic lecturers can teach these concepts effectively using Excel, providing students with practical, hands-on experience in analyzing and solving foundation engineering problems.
Using these Excel spreadsheets, students can learn the concepts of bearing capacity comprehensively.

✅ 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

✅ 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:
   / @dr.fahmi.geotexcel  
✅ My website address:
https://geotexcel.com/

Designed & Presented by Dr. Ahmad Fahmi
****************************************

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