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 WeblogBearing Capacity Calculator
Calculating Bearing Capacity Using Excel Spreadsheets
Bearing Capacity Calculator
Calculating bearing capacity using Excel spreadsheets is a practical, concept-oriented approach for geotechnical engineers and designers. By organizing key soil parameters such as cohesion, internal friction angle, and unit weight into structured spreadsheets, engineers can streamline complex calculations into manageable, step-by-step processes. Excel allows for the efficient application of various bearing capacity methods, such as Terzaghi, Meyerhof, Hansen and Vesic’s equations, with built-in formulas that simplify the determination of foundation performance under different loading conditions. These methods take into account different factors such as soil type, depth, shape, and load conditions, ensuring comprehensive analysis. The concept-oriented design of the spreadsheet not only clarifies the relationships between variables but also enables easy adjustments to parameters, making it ideal for optimizing designs and testing multiple scenarios. This approach improves both the accuracy of calculations and the clarity of data presentation for project documentation and reporting, while allowing engineers to apply industry-standard methods seamlessly.
Watch the Related Videos on Our YouTube Channel (in English):
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/watch?v=xafDNzuvdWM
https://www.youtube.com/watch?v=2A-nvMpLCTQ&t=32s
https://www.youtube.com/watch?v=CYsjxh9IuLk
https://www.linkedin.com/feed/update/urn:li:activity:7230479702426058752/
https://www.linkedin.com/feed/update/urn:li:activity:7229481766682558464/
https://www.linkedin.com/feed/update/urn:li:activity:7226966139539488768/
https://www.linkedin.com/feed/update/urn:li:activity:7230130595618582529/
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s
https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s
https://www.youtube.com/watch?v=cIzYpDOUlVo
GEOtExcel YouTube Channel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
#Soilmechanics #Foundation #Foundationengineering #Foundationdesign #Geotechnics #Geotechnical #Engineering #Excel
Instagram Page Address:
https://www.instagram.com/academy.dr.fahmiExcel Spreadsheets for Soil Mechanics & Foundation Engineering
Geotechnical Excel Programs & Lectures
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
How can we comprehensively learn about Bearing Capacity? ,Terzaghi, Hansen, Vesic, and Meyerhof's Methods
Bearing Capacity calculator: Geotechnical Excel Spreadsheet (GEOtExcel)
Terzaghi, Hansen, Vesic, and Meyerhof's Methods: Comparison
Learning about bearing capacity and foundation engineering using Excel spreadsheets allows for a practical, hands-on approach to understanding critical concepts in geotechnical design. Bearing capacity refers to the ability of soil to support the loads applied by a foundation, and it is calculated using different empirical and analytical methods developed by geotechnical pioneers like Terzaghi, Hansen, Vesic, and Meyerhof. By creating Excel spreadsheets, you can systematically calculate the bearing capacity under various conditions such as soil type, footing size, depth, and load characteristics. Excel can be used to input data, apply formulas for each method (e.g., Terzaghi’s formula for shallow foundations), and generate results such as ultimate bearing capacity. Hansen and Vesic methods include more detailed parameters like shape, depth, and inclination factors, which can also be calculated in Excel. Meyerhof’s method is often used for multi-layered soils or different load conditions. With Excel's functionality for repetitive calculations, and graphing, it becomes an invaluable tool for comparing the results of these different methods, allowing for a comprehensive understanding of bearing capacity principles and foundation engineering design.
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
Understanding Soil Phase Relationships Using Excel Spreadsheets
Understanding Soil Phase Relationships: Problem and Illustrative Solution
Watch the Video on Our YouTube Channel (in English)
Grasping the relationships between soil’s different phases is vital in geotechnical engineering and soil science. These phases—solid particles, water, and air—interact in ways that deeply influence key soil properties, such as density, porosity, and moisture content. The balance and interaction of these phases dictate how soil will perform under various conditions. By studying these relationships, engineers can more precisely predict soil behavior, which is critical for designing and building stable, safe structures.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
Foundation Engineering Excel Spreadsheets: Bearing Capacity
Foundation Engineering: Bearing Capacity Excel Spreadsheets & Lectures
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Geotechnical Excel Spreadsheets
Terzaghi, Hansen, Vesic, and Meyerhof's Methods
https://www.youtube.com/watch?v=xafDNzuvdWM
https://www.youtube.com/watch?v=2A-nvMpLCTQ&t=32s
https://www.youtube.com/watch?v=CYsjxh9IuLk
https://www.linkedin.com/feed/update/urn:li:activity:7230479702426058752/
https://www.linkedin.com/feed/update/urn:li:activity:7229481766682558464/
https://www.linkedin.com/feed/update/urn:li:activity:7226966139539488768/
https://www.linkedin.com/feed/update/urn:li:activity:7230130595618582529/
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s
https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s
https://www.youtube.com/watch?v=cIzYpDOUlVo
GEOtExcel YouTube Channel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
#Soilmechanics #Foundation #Foundationengineering #Foundationdesign #Geotechnics #Geotechnical #Engineering #Excel #Spreadsheet