Draw a soil particle distribution curve using Sieve and Hydrometer tests in an Excel spreadsheet

Discover how to draw a soil particle distribution curve using Sieve and Hydrometer tests in an Excel spreadsheet

Watch the Video on Our YouTube Channel (in English)

https://youtu.be/eWqvdg6uFzo

 Instagram Page Address

 https://www.instagram.com/academy.dr.fahmi

 Excel Spreadsheets for Soil Mechanics & Foundation Engineering

 Geotechnical Excel Programs & Lectures

In geotechnical engineering, understanding the distribution of soil particle sizes is crucial for assessing soil properties. To create a soil particle distribution curve, engineers commonly use Sieve and Hydrometer tests. The Sieve test separates coarse particles, while the Hydrometer test measures the finer particles suspended in a liquid. Once the data from both tests are collected, it can be easily input into an Excel spreadsheet. Using Excel, you can calculate cumulative percentages of particles retained or passed through various sieve sizes and plot them to generate a smooth soil particle distribution curve. This graphical representation helps visualize the gradation of the soil, offering insights into its characteristics, such as grain size distribution, which is essential for soil classification and design decisions.

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

Designed by Dr. Ahmad Fahmi