Computer generated Proctor curve
Computer generated Proctor curve
(OP)
Hi,
I am currently undertaking remaking the company's workbook for calculating and reporting Nuclear density tests and MDD (Proctor curve) tests. Currently the program does not incorporate the Zero Air Voids chart and the curve is made by plotting the 4 points (Moisture Content & Dry Density) and in excel computer generating a curve on a graph.
I am interested to incorporate the Zero Air Voids line in with the wet side of the proctor curve - is there any way to do this in an excel spreadsheet?
I am currently undertaking remaking the company's workbook for calculating and reporting Nuclear density tests and MDD (Proctor curve) tests. Currently the program does not incorporate the Zero Air Voids chart and the curve is made by plotting the 4 points (Moisture Content & Dry Density) and in excel computer generating a curve on a graph.
I am interested to incorporate the Zero Air Voids line in with the wet side of the proctor curve - is there any way to do this in an excel spreadsheet?





RE: Computer generated Proctor curve
Hope this helps.
f-d
¡papá gordo ain't no madre flaca!
RE: Computer generated Proctor curve
In that case one file would have only the zero air voids curve for your specific gravity, from which you transfer to your production curve file.
Never tried it, but if it works, you would not have to re-invent the zero air voids curve every time.
RE: Computer generated Proctor curve
RE: Computer generated Proctor curve
RE: Computer generated Proctor curve
i have incorporated the air voids line.
I would like the wet side to mimmick the airvoids line - but don't know how.
I would also like to get the MDD & OMC values to be automatically added to some cells - but do not know if possibe - anyone have any ideas????
Any input into the page would be apprecited.
RE: Computer generated Proctor curve
When I do this, I will set up four colums in excel. the first [A] will be the moisture content, the second [B] will be the 0%, with a header of 0, column C is for 5%, headed 5 and finally column D will be for 10%, and again header 10.
The first row of the spreadsheet contains the particle density, and typically this will be in cell C1.
Therefore the following cells contain the following information.
Cell A1 - worksheet title
Cell C1 - Selected Particle Density
Cell A2 - Title of 'Moisture Content'
Cell B2 - 0 [AS A NUMBER]
CELL C2 - 5
CELL D2 - 10
Cell A3 to An - moisture content in 0.5% incriments, i.e. 0, 0.5, 1.0, 1.5 etc...
Cell B3 to Bn - the following equation "=((1-(B$2/100))/((1/$C$1)+($A3/100)))"
Cell C3 to Cn - the following equation "=((1-(C$2/100))/((1/$C$1)+($A3/100)))"
Cell D3 to Dn - the following equation "=((1-(D$2/100))/((1/$C$1)+($A3/100)))"
Once you have written the first line for cell B3 just copy them down and it will always read the moisture from the left hand column. You only need to type this into the first cell, B3, and copy it to the left, then down for any number of moisture contents.
By setting it up like this, you can play around with different particle densities, air void contents etc... for as many moisture content range you may want. Can even add in the upper and lower MC, plus the interval required and you will only end up plotting the data specific to your sample.
Hope this helps
RE: Computer generated Proctor curve
RE: Computer generated Proctor curve
RE: Computer generated Proctor curve