How To Draw Grain Size Distribution Curve In Excel Youtube Grain size distribution curve is obtained from the result of sieve size analysis and it is plotted for grain or particle size versus percentage finer.in this. This video will show you how to draw a particle size distribution curve or gradation curve using microsoft excel. a step by step guide to plotting a gradatio.
How To Plot Grain Size Distribution Curve In Excel Youtube In this video, i will show you step by step on how to plot a particle size distribution using a spreadsheet software like microsoft excel. the data is taken. Select the data that you want to include in the scatter plot. this typically includes the grain size (x axis) and the percentage passing (y axis). click on the "insert" tab at the top of the excel window. from the "charts" section, click on "scatter" and choose the scatter plot type that best represents your data. To create the psd curve, we need to calculate the percent finer for each particle size fraction. the percent finer represents the cumulative percentage of particles smaller than a given size. use the following formula to calculate the percent finer: percent finer = cumulative mass retained total mass × 100%. Excel spreadsheet setup. to begin constructing a grain size distribution curve in excel, input your soil sample data into a spreadsheet. each column should represent a different sieve size, with the weight or percentage of the soil that remained on each sieve recorded beneath. this forms the basis for your particle size distribution plot.
Comments are closed.