HSG Soil Testing¶
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 | HSG Soil Testing Worksheet | |
| B3 | Project Name: | |
| B4 | Location: | |
| B6 | Determination of Hydrologic Soil Group Worksheet | |
| B7 | Determining No. of Test Pit for HSG | |
| F7 | Requirements | |
| B8 | Unknown Mapping Unit No. Code |
|
| C8 | Size of Mapping Unit (acre) | |
| D8 | # of Soil Profile Pit(s) Required | |
| E8 | # of Soil Boring(s) Required | |
| F8 | 1. a mapping unit of less than 0.5 acre, a minimum of one soil profile pit and one soil boring shall be conducted within that mapping unit. 2. a minimum of one soil profile pit and four soil borings shall be conducted within each soil mapping unit of 0.5 acre or more and less than or equal to 2 acres, as shown on the NRCS Web Soil Survey. 3. a mapping unit larger than 2 acres within the limits of the overall site, a minimum of one additional soil profile pit and two additional soil borings shall be conducted for each additional 2 acres. |
|
| D9 | 1 | =IF(C9<0.5,1, ROUNDDOWN(C9/2, 0)+1) |
| E9 | 1 | =IF(C9<0.5,1, ROUNDDOWN(C9/2, 0)*2+4) |
| D10 | 1 | =IF(C10<0.5,1, ROUNDDOWN(C10/2, 0)+1) |
| E10 | 1 | =IF(C10<0.5,1, ROUNDDOWN(C10/2, 0)*2+4) |
| D11 | 1 | =IF(C11<0.5,1, ROUNDDOWN(C11/2, 0)+1) |
| E11 | 1 | =IF(C11<0.5,1, ROUNDDOWN(C11/2, 0)*2+4) |
| D12 | 1 | =IF(C12<0.5,1, ROUNDDOWN(C12/2, 0)+1) |
| E12 | 1 | =IF(C12<0.5,1, ROUNDDOWN(C12/2, 0)*2+4) |
| D13 | 1 | =IF(C13<0.5,1, ROUNDDOWN(C13/2, 0)+1) |
| E13 | 1 | =IF(C13<0.5,1, ROUNDDOWN(C13/2, 0)*2+4) |
| D14 | 1 | =IF(C14<0.5,1, ROUNDDOWN(C14/2, 0)+1) |
| E14 | 1 | =IF(C14<0.5,1, ROUNDDOWN(C14/2, 0)*2+4) |
| D15 | 1 | =IF(C15<0.5,1, ROUNDDOWN(C15/2, 0)+1) |
| E15 | 1 | =IF(C15<0.5,1, ROUNDDOWN(C15/2, 0)*2+4) |
| B17 | Determining Depth of Soil Profile Pit/Boring | |
| B18 | Test No. | |
| C18 | Existing Grade Elevation (ft) | |
| D18 | 40 in. Below Existing Grade (ft) | |
| E18 | SHWT Elevation (ft) | |
| F18 | Depth of Test Pit/Boring from Existing Grade (ft) | |
| G18 | Notes | |
| B19 | 1 | |
| C19 | 11 | |
| D19 | 7.66 | |
| E19 | - | |
| F19 | 7.66 | =IF(C19="","", IF(OR(E19="-", E19=""), D19, IF((C19-E19>2), D19, E19))) |
| G19 | =IF(OR(E19="-",E19=""),"", IF((C19-E19<=2),"SHWT is within 24 inches. D soil","")) | |
| B20 | 2 | |
| C20 | 9 | |
| D20 | 5.66 | |
| E20 | 7.5 | |
| F20 | 7.5 | =IF(C20="","", IF(OR(E20="-", E20=""), D20, IF((C20-E20>2), D20, E20))) |
| G20 | SHWT is within 24 inches. D soil | =IF(OR(E20="-",E20=""),"", IF((C20-E20<=2),"SHWT is within 24 inches. D soil","")) |
| B21 | 3 | |
| C21 | 9 | |
| D21 | 5.66 | |
| E21 | 6.5 | |
| F21 | 5.66 | =IF(C21="","", IF(OR(E21="-", E21=""), D21, IF((C21-E21>2), D21, E21))) |
| G21 | =IF(OR(E21="-",E21=""),"", IF((C21-E21<=2),"SHWT is within 24 inches. D soil","")) | |
| B22 | 4 | |
| F22 | =IF(C22="","", IF(OR(E22="-", E22=""), D22, IF((C22-E22>2), D22, E22))) | |
| G22 | =IF(OR(E22="-",E22=""),"", IF((C22-E22<=2),"SHWT is within 24 inches. D soil","")) | |
| B23 | 5 | |
| F23 | =IF(C23="","", IF(OR(E23="-", E23=""), D23, IF((C23-E23>2), D23, E23))) | |
| G23 | =IF(OR(E23="-",E23=""),"", IF((C23-E23<=2),"SHWT is within 24 inches. D soil","")) | |
| B24 | 6 | |
| F24 | =IF(C24="","", IF(OR(E24="-", E24=""), D24, IF((C24-E24>2), D24, E24))) | |
| G24 | =IF(OR(E24="-",E24=""),"", IF((C24-E24<=2),"SHWT is within 24 inches. D soil","")) | |
| B25 | 7 | |
| F25 | =IF(C25="","", IF(OR(E25="-", E25=""), D25, IF((C25-E25>2), D25, E25))) | |
| G25 | =IF(OR(E25="-",E25=""),"", IF((C25-E25<=2),"SHWT is within 24 inches. D soil","")) | |
| B26 | 8 | |
| F26 | =IF(C26="","", IF(OR(E26="-", E26=""), D26, IF((C26-E26>2), D26, E26))) | |
| G26 | =IF(OR(E26="-",E26=""),"", IF((C26-E26<=2),"SHWT is within 24 inches. D soil","")) | |
| B27 | 9 | |
| F27 | =IF(C27="","", IF(OR(E27="-", E27=""), D27, IF((C27-E27>2), D27, E27))) | |
| G27 | =IF(OR(E27="-",E27=""),"", IF((C27-E27<=2),"SHWT is within 24 inches. D soil","")) | |
| B28 | 10 | |
| F28 | =IF(C28="","", IF(OR(E28="-", E28=""), D28, IF((C28-E28>2), D28, E28))) | |
| G28 | =IF(OR(E28="-",E28=""),"", IF((C28-E28<=2),"SHWT is within 24 inches. D soil","")) | |
| B30 | Soil profile pits and soil borings performed for the purpose of determining HSG must extend at least 40 inches below existing grade, except when the SHWT is at a depth of 24 inches or less, the exploration may be terminated before excavation to the depth of 40 inches below existing grade and the soils are classified as HSG D. | |
| G31 | Locked_NJDEP_Chapter_12_workbook_March_2024 |