Excel Spreadsheet: #foundationengineering #bearing capacity :
The ultimate bearing capacity of soil represents the maximum load per unit area it can withstand without failing or undergoing excessive settlement. It’s crucial in geotechnical engineering for ensuring the safety and stability of structures. Factors like soil type, density, and moisture content influence this capacity, which engineers calculate to design structures capable of withstanding expected loads.
Excel Spreadsheet: #soilmechanics #consolidation :
Soil consolidation, the gradual reduction in volume of a soil mass due to the expulsion of water under load, is influenced by boundary conditions such as double drainage and single drainage. In double drainage, both top and bottom boundaries allow for water drainage, leading to faster consolidation compared to single drainage, where only one boundary permits water escape, creating a gradient in pore water pressure and slowing down consolidation. Understanding these drainage conditions is crucial for predicting the long-term behavior of soil deposits and designing effective engineering strategies, as they directly impact the degree of consolidation, which quantifies the extent to which soil settlement occurs over time under applied loads.
Cost-Free Excel Spreadsheet:
In geotechnical engineering, bearing capacity is the soil’s ability to support applied loads. It’s the maximum pressure between the foundation and soil that won’t cause failure. Ultimate bearing capacity is the highest pressure soil can handle without failing, while allowable bearing capacity considers a safety factor. Soft soil may settle under load without failing, so allowable bearing capacity can be based on acceptable settlement. Allowable bearing pressure is the maximum pressure soil can handle without failure, while ultimate bearing capacity is the pressure before failure.
In this freely available Excel spreadsheet, you’ll find Bearing Capacity Factors based on methodologies by Meyerhof, Hansen, and Vesić.
Critical Path Method (CPM) in Project Management
Resource Leveling
Designed by: Dr. Ahmad Fahmi
The weight of a wet soil is 32 g. When this soil dries, its weight reduces to 30 g. If it is saturated, its weight increases to 40 g. If the specific gravity of the soil equals 2.65, then calculate: A) Water content, B)Void ratio, C)The degree of Saturation, D)Porosity, E)Volume of the Soil phases, F) Air content and Percentage air voids.
GEOtExcel spreadsheets will be commercially available next year and will be accessible to professors, lecturers, and engineers. The GEOtExcel-Consolidation spreadsheet is currently available at no cost. It is one among the hundreds in the GEOtExcel collection. This program, focused on consolidation, is presented as a gift to our subscribers and followers. While you are welcome to use the program for teaching purposes, we kindly ask that you refrain from publishing any educational videos or lectures created using this spreadsheet. It is suggested that you refer to the YouTube video published on the GEOtExcel channel to learn how to use the shared Excel file.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Double Drainage:
Single Drainage:
Excel Spreadsheets for Soil Mechanics
YouTube.com: @Dr.Fahmi.GEOtExcel
