Bulk Density Problem

Some data was collected to find specific yield from bulk density and field capacity at Red Rock Lakes.  The bulk density was found by drilling a segment of a hole with a soil auger, saving the soil, measuring the volume of sand required to fill  the hole segment with round quartz, and drying and weighing the soil from the hole segment in the laboratory.   The field capacity was measured by the MSU soil laboratory. (The density of quartz and feldspar is 2.65 g/cm-3).   A spread sheet of data  from the experiment is presented to save you time. (Note:  you must subtract tare from dry to find the actual mass of the soil.  Use the spread sheet to calculate the bulk density, porosity, specific yield and and amount of water level rise resulting from 10 cm of snow melt in the spring.   Then plot the textural data on the triangular diagram of texture and specific yield.  How well did the diagram predict measured specific yield?

Product.

1. printed spreadsheet with your name and calculated
1. bulk density
2. calculated specific yield
3. water level rise from 10 cm of infiltrated water.
2. A copy of the triangular specific yield diagram with points plotted.
1. Enter the specific yield values in the spread sheet from 1.
2. Calculated mean estimated and mean measured specific yield in the spread sheet.
3. Use the means to discuss how well the triangular diagram estimate and measured values compare.   If there are discrepancies, suggest a possible cause.