Percolation Test¶
Sheet visibility: visible.
Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.
| Cell | Stored value or cached result | Formula |
|---|---|---|
| B2 | Percolation Test Data Sheet | |
| B3 | Project: | |
| G3 | Date: | |
| B4 | Municipality: | |
| B6 | Test Hole Dimensions | |
| B7 | Test Pit # | |
| B8 | Test Hole Shape (select one) | |
| C8 | Round | |
| D8 | Enter the Diameter (in) if Round was selected | |
| F8 | 6 | |
| G8 | Enter Dimensions (in) if Square or Rectangular was selected | |
| I8 | Length | |
| I9 | Width | |
| B11 | Test Results | |
| B12 | Trial No. | |
| C12 | Start Time at 6 inches | |
| D12 | Stop Time at 0 inch | |
| E12 | Time Interval (min) | |
| F12 | Initial Water Depth (in) | |
| G12 | Final Water Depth (in) | |
| H12 | Change in Water Level (in) | |
| I12 | Percolation Rate (min/in) | |
| J12 | Converted Hydraulic Conductivity (in/hr) | |
| B13 | 1 | |
| C13 | 0 | |
| D13 | 25 | |
| E13 | 25 | =D13-C13 |
| F13 | 6 | |
| G13 | 0 | |
| H13 | 6 | |
| I13 | 4.166666666666667 | =IF((E13<>0),E13/H13,"") |
| J13 | 4.8 | =IF(AND($F$8="", $J$8=""), "Dimension", IF(I13<>"",IF($C$8="Round",(60(PI()($F$8/2)^2)1/(PI()($F$8/2)^2+2PI()($F$8/2)(6/2))(1/I13)),IF($C$8="Sq/Rect",(60(J$8J$9)1/(J$8J$9+2(J$8+J$9)(6/2))*(1/I13)),"Select test hole type")),"")) |
| B14 | 2 | |
| C14 | 0 | |
| D14 | 24 | |
| E14 | 24 | =D14-C14 |
| F14 | 6 | |
| G14 | 0 | |
| H14 | 6 | |
| I14 | 4 | =IF((E14<>0),E14/H14,"") |
| J14 | 5 | =IF(AND($F$8="", $J$8=""), "Dimension", IF(I14<>"",IF($C$8="Round",(60(PI()($F$8/2)^2)1/(PI()($F$8/2)^2+2PI()($F$8/2)(6/2))(1/I14)),IF($C$8="Sq/Rect",(60(J$8J$9)1/(J$8J$9+2(J$8+J$9)(6/2))*(1/I14)),"Select test hole type")),"")) |
| B15 | 3 | |
| E15 | 0 | =D15-C15 |
| F15 | 6 | |
| G15 | 0 | |
| H15 | 6 | |
| I15 | =IF((E15<>0),E15/H15,"") | |
| J15 | =IF(AND($F$8="", $J$8=""), "Dimension", IF(I15<>"",IF($C$8="Round",(60(PI()($F$8/2)^2)1/(PI()($F$8/2)^2+2PI()($F$8/2)(6/2))(1/I15)),IF($C$8="Sq/Rect",(60(J$8J$9)1/(J$8J$9+2(J$8+J$9)(6/2))*(1/I15)),"Select test hole type")),"")) | |
| B16 | 4 | |
| E16 | 0 | =D16-C16 |
| F16 | 6 | |
| G16 | 0 | |
| H16 | 6 | |
| I16 | =IF((E16<>0),E16/H16,"") | |
| J16 | =IF(AND($F$8="", $J$8=""), "Dimension", IF(I16<>"",IF($C$8="Round",(60(PI()($F$8/2)^2)1/(PI()($F$8/2)^2+2PI()($F$8/2)(6/2))(1/I16)),IF($C$8="Sq/Rect",(60(J$8J$9)1/(J$8J$9+2(J$8+J$9)(6/2))*(1/I16)),"Select test hole type")),"")) | |
| B17 | 5 | |
| E17 | 0 | =D17-C17 |
| F17 | 6 | |
| G17 | 0 | |
| H17 | 6 | |
| I17 | =IF((E17<>0),E17/H17,"") | |
| J17 | =IF(AND($F$8="", $J$8=""), "Dimension", IF(I17<>"",IF($C$8="Round",(60(PI()($F$8/2)^2)1/(PI()($F$8/2)^2+2PI()($F$8/2)(6/2))(1/I17)),IF($C$8="Sq/Rect",(60(J$8J$9)1/(J$8J$9+2(J$8+J$9)(6/2))*(1/I17)),"Select test hole type")),"")) | |
| H19 | Average | |
| J19 | 4.9 | =IF(J13<>"",SUM(J13:J17)/(5-COUNTBLANK(J13:J17)),"") |
| B23 | Test Hole Dimensions | |
| B24 | Test Pit # | |
| B25 | Test Hole Shape (select one) | |
| C25 | Sq/Rect | |
| D25 | Enter the Diameter (in) if Round was selected | |
| G25 | Enter Dimensions (in) if Square or Rectangular was selected | |
| I25 | Length | |
| J25 | 10 | |
| I26 | Width | |
| J26 | 10 | |
| B28 | Test Results | |
| B29 | Trial No. | |
| C29 | Start Time at 6 inches | |
| D29 | Stop Time at 0 inch | |
| E29 | Time Interval (min) | |
| F29 | Initial Water Depth (in) | |
| G29 | Final Water Depth (in) | |
| H29 | Change in Water Level (in) | |
| I29 | Percolation Rate (min/in) | |
| J29 | Converted Hydraulic Conductivity (in/hr) | |
| B30 | 1 | |
| C30 | 0 | |
| D30 | 16 | |
| E30 | 16 | =D30-C30 |
| F30 | 6 | |
| G30 | 0 | |
| H30 | 6 | |
| I30 | 2.6666666666666665 | =IF((E30<>0),E30/H30,"") |
| J30 | 10.227272727272727 | =IF(AND($F$25="", $J$25=""), "Dimension", IF(I30<>"",IF($C$25="Round",(60(PI()($F$25/2)^2)1/(PI()($F$25/2)^2+2PI()($F$25/2)(6/2))(1/I30)),IF($C$25="Sq/Rect",(60(J$25J$26)1/(J$25J$26+2(J$25+J$26)(6/2))*(1/I30)),"Select test hole type")),"")) |
| B31 | 2 | |
| E31 | 0 | =D31-C31 |
| F31 | 6 | |
| G31 | 0 | |
| H31 | 6 | |
| I31 | =IF((E31<>0),E31/H31,"") | |
| J31 | =IF(AND($F$25="", $J$25=""), "Dimension", IF(I31<>"",IF($C$25="Round",(60(PI()($F$25/2)^2)1/(PI()($F$25/2)^2+2PI()($F$25/2)(6/2))(1/I31)),IF($C$25="Sq/Rect",(60(J$25J$26)1/(J$25J$26+2(J$25+J$26)(6/2))*(1/I31)),"Select test hole type")),"")) | |
| B32 | 3 | |
| E32 | 0 | =D32-C32 |
| F32 | 6 | |
| G32 | 0 | |
| H32 | 6 | |
| I32 | =IF((E32<>0),E32/H32,"") | |
| J32 | =IF(AND($F$25="", $J$25=""), "Dimension", IF(I32<>"",IF($C$25="Round",(60(PI()($F$25/2)^2)1/(PI()($F$25/2)^2+2PI()($F$25/2)(6/2))(1/I32)),IF($C$25="Sq/Rect",(60(J$25J$26)1/(J$25J$26+2(J$25+J$26)(6/2))*(1/I32)),"Select test hole type")),"")) | |
| B33 | 4 | |
| E33 | 0 | =D33-C33 |
| F33 | 6 | |
| G33 | 0 | |
| H33 | 6 | |
| I33 | =IF((E33<>0),E33/H33,"") | |
| J33 | =IF(AND($F$25="", $J$25=""), "Dimension", IF(I33<>"",IF($C$25="Round",(60(PI()($F$25/2)^2)1/(PI()($F$25/2)^2+2PI()($F$25/2)(6/2))(1/I33)),IF($C$25="Sq/Rect",(60(J$25J$26)1/(J$25J$26+2(J$25+J$26)(6/2))*(1/I33)),"Select test hole type")),"")) | |
| B34 | 5 | |
| E34 | 0 | =D34-C34 |
| F34 | 6 | |
| G34 | 0 | |
| H34 | 6 | |
| I34 | =IF((E34<>0),E34/H34,"") | |
| J34 | =IF(AND($F$25="", $J$25=""), "Dimension", IF(I34<>"",IF($C$25="Round",(60(PI()($F$25/2)^2)1/(PI()($F$25/2)^2+2PI()($F$25/2)(6/2))(1/I34)),IF($C$25="Sq/Rect",(60(J$25J$26)1/(J$25J$26+2(J$25+J$26)(6/2))*(1/I34)),"Select test hole type")),"")) | |
| H36 | Average | |
| J36 | 10.227272727272727 | =IF(J30<>"",SUM(J30:J34)/(5-COUNTBLANK(J30:J34)),"") |
| H38 | Locked_NJDEP_Chapter_12_workbook_March_2024 |