Soil Explorations for SW BMPs

Sheet visibility: visible.

Back to workbook

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	Soil Explorations for Stormwater BMPs
B3	Project Name:
B4	Location:
B5	No. of Soil Explorations Required for Stormwater BMPs (Single, Non-GI, Large BMP, Linear BMP)
B6	Type (select one)
C6	Size of Infiltration Area (square feet)
D6	Length of Linear BMP (ft)
E6	# of Soil Profile Pits Required
F6	# of Soil Borings Required
B7	Single BMP
C7	6500
D7	--	=IF(B7 ="Linear BMP", "? ft","--")
E7	2	=IF(B7="Single BMP",IF(C7<=10000,2,2+ROUNDUP((C7-10000)/10000,0)),IF(B7="Linear BMP",1+ROUNDDOWN((D7-500)/2000,0),"--"))
F7	0	=IF(B7="Single BMP",0,IF(B7="Linear BMP",MAX(0,ROUNDUP((D7-500)/500,0)),"--"))
B8	Single BMP
C8	25600
D8	--	=IF(B8 ="Linear BMP", "? ft","--")
E8	4	=IF(B8="Single BMP",IF(C8<=10000,2,2+ROUNDUP((C8-10000)/10000,0)),IF(B8="Linear BMP",1+ROUNDDOWN((D8-500)/2000,0),"--"))
F8	0	=IF(B8="Single BMP",0,IF(B8="Linear BMP",MAX(0,ROUNDUP((D8-500)/500,0)),"--"))
B9	Linear BMP
C9	--	=IF(B9 ="Single BMP", "? sf","--")
D9	450
E9	1	=IF(B9="Single BMP",IF(C9<=10000,2,2+ROUNDUP((C9-10000)/10000,0)),IF(B9="Linear BMP",1+ROUNDDOWN((D9-500)/2000,0),"--"))
F9	0	=IF(B9="Single BMP",0,IF(B9="Linear BMP",MAX(0,ROUNDUP((D9-500)/500,0)),"--"))
C10	--	=IF(B10 ="Single BMP", "? sf","--")
D10	--	=IF(B10 ="Linear BMP", "? ft","--")
E10	--	=IF(B10="Single BMP",IF(C10<=10000,2,2+ROUNDUP((C10-10000)/10000,0)),IF(B10="Linear BMP",1+ROUNDDOWN((D10-500)/2000,0),"--"))
F10	--	=IF(B10="Single BMP",0,IF(B10="Linear BMP",MAX(0,ROUNDUP((D10-500)/500,0)),"--"))
C11	--	=IF(B11 ="Single BMP", "? sf","--")
D11	--	=IF(B11 ="Linear BMP", "? ft","--")
E11	--	=IF(B11="Single BMP",IF(C11<=10000,2,2+ROUNDUP((C11-10000)/10000,0)),IF(B11="Linear BMP",1+ROUNDDOWN((D11-500)/2000,0),"--"))
F11	--	=IF(B11="Single BMP",0,IF(B11="Linear BMP",MAX(0,ROUNDUP((D11-500)/500,0)),"--"))
C12	--	=IF(B12 ="Single BMP", "? sf","--")
D12	--	=IF(B12 ="Linear BMP", "? ft","--")
E12	--	=IF(B12="Single BMP",IF(C12<=10000,2,2+ROUNDUP((C12-10000)/10000,0)),IF(B12="Linear BMP",1+ROUNDDOWN((D12-500)/2000,0),"--"))
F12	--	=IF(B12="Single BMP",0,IF(B12="Linear BMP",MAX(0,ROUNDUP((D12-500)/500,0)),"--"))
C13	--	=IF(B13 ="Single BMP", "? sf","--")
D13	--	=IF(B13 ="Linear BMP", "? ft","--")
E13	--	=IF(B13="Single BMP",IF(C13<=10000,2,2+ROUNDUP((C13-10000)/10000,0)),IF(B13="Linear BMP",1+ROUNDDOWN((D13-500)/2000,0),"--"))
F13	--	=IF(B13="Single BMP",0,IF(B13="Linear BMP",MAX(0,ROUNDUP((D13-500)/500,0)),"--"))
B15	No. of Soil Explorations Required for Stormwater BMPs in accordance with Items 2 and 3 of Subsection 2a in Ch. 12
B16	Type (select one)
C16	# of Soil Mapping Unit
D16	# of BMPs
E16	# of Soil Profile Pits Required
F16	# of Soil Borings Required
B17	Small BMPs <= 500 sf
C17	1
D17	5
E17	1	=C17
F17	5	=IF(B17="Small BMPs <= 500 sf",D17, (IF(B17="GI BMPs > 500 sf",D17*2,"--")))
B18	GI BMPs > 500 sf
C18	2
D18	9
E18	2	=C18
F18	18	=IF(B18="Small BMPs <= 500 sf",D18, (IF(B18="GI BMPs > 500 sf",D18*2,"--")))
B19	Small BMPs <= 500 sf
C19	--	=IF(B19 ="Single BMP", "? sf","--")
D19	--	=IF(B19 ="Linear BMP", "? ft","--")
E19	--	=C19
F19	--	=IF(B19="Small BMPs <= 500 sf",D19, (IF(B19="GI BMPs > 500 sf",D19*2,"--")))
C20	--	=IF(B20 ="Single BMP", "? sf","--")
D20	--	=IF(B20 ="Linear BMP", "? ft","--")
E20	--	=C20
F20	--	=IF(B20="Small BMPs <= 500 sf",D20, (IF(B20="GI BMPs > 500 sf",D20*2,"--")))
C21	--	=IF(B21 ="Single BMP", "? sf","--")
D21	--	=IF(B21 ="Linear BMP", "? ft","--")
E21	--	=C21
F21	--	=IF(B21="Small BMPs <= 500 sf",D21, (IF(B21="GI BMPs > 500 sf",D21*2,"--")))
C22	--	=IF(B22 ="Single BMP", "? sf","--")
D22	--	=IF(B22 ="Linear BMP", "? ft","--")
E22	--	=C22
F22	--	=IF(B22="Small BMPs <= 500 sf",D22, (IF(B22="GI BMPs > 500 sf",D22*2,"--")))
C23	--	=IF(B23 ="Single BMP", "? sf","--")
D23	--	=IF(B23 ="Linear BMP", "? ft","--")
E23	--	=C23
F23	--	=IF(B23="Small BMPs <= 500 sf",D23, (IF(B23="GI BMPs > 500 sf",D23*2,"--")))
B26	Determining Depth of Soil Profile Pit/Boring
B27	Test Pit / Boring No.
C27	Existing Grade EL. (ft)
D27	Lowest Bottom EL. (ft)
E27	Maximum Potential Water Depth (ft)
F27	Depth of Test Pit/Boring Depth from Existing Grade (in)
G27	Elevation of Excavation EL. (ft)
B28	1
C28	100
D28	96
E28	2
F28	144	=12IF((C28-D28+8)>2E28,(C28-D28+8),2*E28)
G28	88	=C28 -IF((C28-D28+8)>2E28,(C28-D28+8),2E28)
B29	2
F29	96	=12IF((C29-D29+8)>2E29,(C29-D29+8),2*E29)
G29	-8	=C29 -IF((C29-D29+8)>2E29,(C29-D29+8),2E29)
B30	3
F30	96	=12IF((C30-D30+8)>2E30,(C30-D30+8),2*E30)
G30	-8	=C30 -IF((C30-D30+8)>2E30,(C30-D30+8),2E30)
B31	4
F31	96	=12IF((C31-D31+8)>2E31,(C31-D31+8),2*E31)
G31	-8	=C31 -IF((C31-D31+8)>2E31,(C31-D31+8),2E31)
B32	5
F32	96	=12IF((C32-D32+8)>2E32,(C32-D32+8),2*E32)
G32	-8	=C32 -IF((C32-D32+8)>2E32,(C32-D32+8),2E32)
B33	6
F33	96	=12IF((C33-D33+8)>2E33,(C33-D33+8),2*E33)
G33	-8	=C33 -IF((C33-D33+8)>2E33,(C33-D33+8),2E33)
B34	7
F34	96	=12IF((C34-D34+8)>2E34,(C34-D34+8),2*E34)
G34	-8	=C34 -IF((C34-D34+8)>2E34,(C34-D34+8),2E34)
B35	8
F35	96	=12IF((C35-D35+8)>2E35,(C35-D35+8),2*E35)
G35	-8	=C35 -IF((C35-D35+8)>2E35,(C35-D35+8),2E35)
B36	9
F36	96	=12IF((C36-D36+8)>2E36,(C36-D36+8),2*E36)
G36	-8	=C36 -IF((C36-D36+8)>2E36,(C36-D36+8),2E36)
B37	10
F37	96	=12IF((C37-D37+8)>2E37,(C37-D37+8),2*E37)
G37	-8	=C37 -IF((C37-D37+8)>2E37,(C37-D37+8),2E37)
B39	Note: Soil profile pits and soil borings performed for the purpose of designing a stormwater BMP must extend to either a minimum depth of eight feet below the lowest elevation of the basin bottom or to a depth that is at least twice the maximum potential water depth generated by the largest design storm, whichever is greater.
F40	Locked_NJDEP_Chapter_12_workbook_March_2024