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 WeblogHow is the flow rate through the soil beneath a concrete dam calculated? Excel sheet
How is the flow rate through the soil beneath a concrete dam calculated
Flow rate calculation: Innovative unique Excel Spreadsheet
Watch the video on our YouTube channel
Instagram Page Address
https://www.instagram.com/academy.dr.fahmi/
Excel Spreadsheets for Soil Mechanics & Foundation Engineering
Geotechnical Excel Programs & Lectures
Let's make education a delightful and enriching experience together
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Calculating the flow rate of water through the soil beneath a concrete dam is crucial for maintaining the dam's stability and safety. This process requires a comprehensive understanding of seepage, which describes how water interacts with and moves through the soil. Using an Excel spreadsheet, you can streamline the calculation by inputting soil properties (such as permeability), hydraulic gradients, and cross-sectional areas to compute the flow rate through Darcy's Law. Excel’s formulas and data visualization tools allow for clear graphical representation of seepage calculations.
Designed by Dr. Ahmad Fahmi
#GEOtExcel #soilmechanics #excelspreadsheets #geotechnics #geotechnicalengineering #soil_mechanics #excel #excelsheet #shearstress #microsoftexcel
How can soil particle size be graphically represented in Microsoft Excel?
Soil particle size distribution can be effectively represented graphically in Microsoft Excel by plotting a gradation curve, which helps visualize the range of particle sizes within a soil sample. To do this, data from sieve analysis or hydrometer tests are first entered into an Excel spreadsheet. The key data points typically include the percentage of soil passing through each sieve (cumulative percent finer) and the corresponding sieve sizes. Using this data, you can create a scatter or line chart in Excel, with the sieve size (or particle diameter in mm) plotted on a logarithmic scale on the x-axis and the cumulative percent finer on the y-axis. Excel’s chart tools allow you to format the axes, add labels, and generate a smooth curve that shows the particle size distribution of the soil sample. This graphical representation helps in classifying the soil based on its gradation characteristics, such as identifying whether it is well-graded, poorly graded, or uniformly graded. Excel's flexibility in data manipulation and visualization makes it a convenient tool for engineers to represent and analyze soil particle size distribution.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi
How can we efficiently learn to analyze Consolidated Drained Triaxial Test (CD) results in soil using Excel Spreadsheet
Drained Triaxial Test (CD)/ Excel spreadsheets
Analyzing Consolidated Drained (CD) Triaxial Test results using an Excel spreadsheet provides an efficient way to interpret soil behavior under drained conditions, where pore water pressure is allowed to dissipate. The CD test is commonly used to evaluate the shear strength parameters of soil, such as cohesion (c) and the angle of internal friction (ϕ). To analyze CD test results in Excel, start by inputting the raw data from the test, including axial load, confining pressure, and deformation measurements. You can use Excel formulas to calculate key parameters like deviator stress, axial strain, and volumetric strain. Plotting stress-strain curves and Mohr’s circles for different confining pressures allows you to visualize the behavior of soil under various loading conditions. Excel’s built-in regression tools can also be used to derive the failure envelope, helping to determine the soil’s shear strength parameters (c and ϕ). With Excel’s capability to automate calculations and generate graphs, it becomes a powerful tool for efficiently analyzing CD test results and understanding soil behavior under drained conditions.
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
RQD Calculation (Rock Quality Designation): GEOtExcel: Geotechnical Excel Spreadsheets & Lectures
Training on Calculating the RQD Parameter in Engineering Geology Using a Designed Program in Excel Spreadsheet (Random Examples)
Rock Quality Designation (RQD) is an important measure in geotechnical engineering used to assess the quality and fracturing of rock masses. It is calculated as the percentage of rock core pieces longer than 10 cm (4 inches) relative to the total drilled length. To calculate RQD in Excel, start by inputting the lengths of all core pieces recovered from a drilling operation. Next, filter the data to identify only the core segments longer than 10 cm. Using Excel’s built-in functions, sum these qualified core lengths and divide the result by the total core length drilled. Multiply the final ratio by 100 to express the RQD as a percentage. Excel’s capabilities also allow for quick adjustments, visualization through charts, and easy recalculations, making it an efficient tool for conducting RQD analysis.
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
Designed by Dr. Ahmad Fahmi