How can soil particle size be graphically represented in Microsoft Excel?

How do you determine D10, D30, and D60 in Excel Spreadsheet

Soil Classification : Unified Soil Classification System (USCS)

Watch the Videos on Our YouTube Channel:

https://www.youtube.com/watch?v=b1LrrIB7V0k

https://youtu.be/MRlMFXpHtgw

https://youtu.be/Z7w0dPFC9us

 Watch the Video on Our YouTube Channel (in English):

Flow Nets: Two-Dimensional Flow of Water Through Soils: Excel Spreadsheet: GEOtExcel

 Instagram Page Address:

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

 Excel Spreadsheets for Soil Mechanics & Foundation Engineering

 Geotechnical Excel Programs & Lectures

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