Attached is a spreadsheet to classify the soil according to USCS and the granulometric curve is plotted by sieving.

Please upload any improvements done to this file and post if any mistakes are found or if you have any suggestions.

This is the original code.
USCS1.sm (101,6 KiB) scaricato 1855 volta(e).

This is the original code with another particle-size distribution
USCS.sm (103,17 KiB) scaricato 2245 volta(e).

Below in another post it is updated with a better presentation of the granulometric curve.

Fit & explorer ... Jean

USCS fit Granulometry.sm (21,61 KiB) scaricato 1779 volta(e).

Wrote

Fit & explorer ... Jean

USCS fit Granulometry.sm (21,61 KiB) scaricato 1779 volta(e).

Thank you so much,

I added the logistic sigmoid function you made to the initial code and it compare with and without the fit. In addition to the initial curve, I graphed it using the Zed Graph, where it can be better appreciated using a semilogx graph

USCS-fit-Granulometry.sm (175,97 KiB) scaricato 1674 volta(e).

Wrote

Thank you so much,

Thanks as well, very educative.
A large suite of math codes added
Cheers ... Jean.

Project USCS fit Granulometry.sm (90,24 KiB) scaricato 1782 volta(e).