{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["C.A. RCN","LOD","OLOD ","RPv","TMDL","Cv","Fv","DURMM Report","Data & Documentation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"C.A. RCN","index":0,"n_rows":109,"n_cols":23,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,2,0,14],[1,2,1,14],[2,2,2,14],[3,2,3,14],[4,0,4,1],[99,1,99,8],[5,2,6,2],[89,1,89,3],[101,2,101,8],[4,4,4,14]]}
[null,"PROJECT:"]
[null,"DRAINAGE SUBAREA ID:"]
[null,"LOCATION (County):","New Castle"]
[null,"UNIT HYDROGRAPH:"]
["CONTRIBUTING AREA RUNOFF CURVE NUMBER               (C.A. RCN) WORKSHEET \n",null,null,null,"Curve Numbers for Hydrologic Soil Type"]
["Cover Type","Treatment","Hydrologic Condition",null,"A",null,null,"B",null,null,"C",null,null,"D"]
[null,null,null,null,"Acres","RCN",{"$f":"IF(AND(E7>0,E7<10000),E7*F7,0)","v":0},"Acres","RCN",{"$f":"IF(AND(H7>0,H7<10000),H7*I7,0)","v":0},"Acres","RCN",{"$f":"IF(AND(K7>0,K7<10000),K7*L7,0)","v":0},"Acres","RCN",{"$f":"IF(AND(N7>0,N7<10000),N7*O7,0)","v":0}]
["CULTIVATED AGRICULTURAL LANDS   "]
["Fallow","              Bare soil","----",null,null,"77",{"$f":"ROUND(IF(AND(E9>0,E9<10000),E9*F9,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H9>0,H9<10000),H9*I9,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K9>0,K9<10000),K9*L9,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N9>0,N9<10000),N9*O9,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","poor",null,null,"76",{"$f":"ROUND(IF(AND(E10>0,E10<10000),E10*F10,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H10>0,H10<10000),H10*I10,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K10>0,K10<10000),K10*L10,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N10>0,N10<10000),N10*O10,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","good",null,null,"74",0,null,"83",0,null,"88",0,null,"90",0,"-----------"]
["Row Crops","              Straight row (SR)","poor",null,null,"72",0,null,"81",0,null,"88",0,null,"91",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"67",0,null,"78",0,null,"85",0,null,"89",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"71",0,null,"80",0,null,"87",0,null,"90",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"64",0,null,"75",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"70",0,null,"79",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"65",0,null,"75",0,null,"82",0,null,"86",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"69",0,null,"78",0,null,"83",0,null,"87",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"64",0,null,"74",0,null,"81",0,null,"85",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"66",0,null,"74",0,null,"80",0,null,"82",0,"-----------"]
[null,"              Cont & terraced(C&T)","good",null,null,"62",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"65",0,null,"73",0,null,"79",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"61",0,null,"70",0,null,"77",0,null,"80",0,"-----------"]
["Small Grain","              Straight row (SR)","poor",null,null,"65",0,null,"76",0,null,"84",0,null,"88",0,"-----------"]
[null,"              Straight row (SR)","good",null,null,"63",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"              SR + Crop residue","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"86",0,"-----------"]
[null,"              SR + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"84",0,"-----------"]
[null,"              Contoured (C)","poor",null,null,"63",0,null,"74",0,null,"82",0,null,"85",0,"-----------"]
[null,"              Contoured (C)","good",null,null,"61",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","poor",null,null,"62",0,null,"73",0,null,"81",0,null,"84",0,"-----------"]
[null,"              C + Crop residue","good",null,null,"60",0,null,"72",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced(C&T)","poor",null,null,"61",0,null,"72",0,null,"79",0,null,"82",0,"-----------"]
[null,"              Cont & terraces(C&T)","good",null,null,"59",0,null,"70",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","poor",null,null,"60",0,null,"71",0,null,"78",0,null,"81",0,"-----------"]
[null,"              C&T + Crop residue","good",null,null,"58",0,null,"69",0,null,"77",0,null,"80",0,"-----------"]
["Close-seeded","              Straight row","poor",null,null,"66",0,null,"77",0,null,"85",0,null,"89",0,"-----------"]
["or broadcast","              Straight row","good",null,null,"58",0,null,"72",0,null,"81",0,null,"85",0,"-----------"]
["legumes or","              Contoured","poor",null,null,"64",0,null,"75",0,null,"83",0,null,"85",0,"-----------"]
["rotation","              Contoured","good",null,null,"55",0,null,"69",0,null,"78",0,null,"83",0,"-----------"]
["meadow","              Cont & terraced","poor",null,null,"63",0,null,"73",0,null,"80",0,null,"83",0,"-----------"]
[null,"              Cont & terraced","good",null,null,"51",0,null,"67",0,null,"76",0,null,"80",0,"-----------"]
[]
["OTHER AGRICULTURAL LANDS       ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Pasture, grassland or range ","poor",null,null,"68",{"$f":"ROUND(IF(AND(E44>0,E44<10000),E44*F44,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H44>0,H44<10000),H44*I44,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K44>0,K44<10000),K44*L44,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N44>0,N44<10000),N44*O44,0),2)","v":0},"-----------"]
[null,"                            ","fair",null,null,"49",0,null,"69",0,null,"79",0,null,"84",0,"-----------"]
[null,"                            ","good",null,null,"39",0,null,"61",0,null,"74",0,null,"80",0,"-----------"]
[null,"Meadow -cont. grass (non grazed) ","----",null,null,"30",0,null,"58",0,null,"71",0,null,"78",0,"-----------"]
[null,"Brush - brush, weed, grass mix ","poor",null,null,"48",0,null,"67",0,null,"77",0,null,"83",0,"-----------"]
[null,"                               ","fair",null,null,"35",0,null,"56",0,null,"70",0,null,"77",0,"-----------"]
[null,"                               ","good",null,null,"30",0,null,"48",0,null,"65",0,null,"73",0,"-----------"]
[null,"Woods - grass combination ","poor",null,null,"57",0,null,"73",0,null,"82",0,null,"86",0,"-----------"]
[null,"                          ","fair",null,null,"43",0,null,"65",0,null,"76",0,null,"82",0,"-----------"]
[null,"                          ","good",null,null,"32",0,null,"58",0,null,"72",0,null,"79",0,"-----------"]
[null,"Woods ","poor",null,null,"45",0,null,"66",0,null,"77",0,null,"83",0,"-----------"]
[null,"      ","fair",null,null,"36",0,null,"60",0,null,"73",0,null,"79",0,"-----------"]
[null,"      ","good",null,null,"30",0,null,"55",0,null,"70",0,null,"77",0,"-----------"]
[null,"Farmsteads ","----",null,null,"59",0,null,"74",0,null,"82",0,null,"86",0,"-----------"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County"]
["FULLY DEVELOPED URBAN AREAS (Veg Established)"]
["Open space (Lawns,parks etc.)   ",null,null,null,null,"  ",null,null,"  ",null,null,"  ",null,null,"  ",null,null,null,null,null,null,null,"New Castle"]
[null,"   Poor condition; grass cover < 50%",null,null,null,"68",{"$f":"ROUND(IF(AND(E61>0,E61<10000),E61*F61,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H61>0,H61<10000),H61*I61,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K61>0,K61<10000),K61*L61,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N61>0,N61<10000),N61*O61,0),2)","v":0},"-----------"]
[null,"   Fair condition; grass cover 50% to 75 %",null,null,null,"49",{"$f":"ROUND(IF(AND(E62>0,E62<10000),E62*F62,0),2)","v":0},null,"69",{"$f":"ROUND(IF(AND(H62>0,H62<10000),H62*I62,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(K62>0,K62<10000),K62*L62,0),2)","v":0},null,"84",{"$f":"ROUND(IF(AND(N62>0,N62<10000),N62*O62,0),2)","v":0},"-----------"]
[null,"   Good condition; grass cover > 75%",null,null,null,"39",{"$f":"ROUND(IF(AND(E63>0,E63<10000),E63*F63,0),2)","v":0},null,"61",{"$f":"ROUND(IF(AND(H63>0,H63<10000),H63*I63,0),2)","v":0},null,"74",{"$f":"ROUND(IF(AND(K63>0,K63<10000),K63*L63,0),2)","v":0},null,"80",{"$f":"ROUND(IF(AND(N63>0,N63<10000),N63*O63,0),2)","v":0},"-----------",null,null,null,null,null,"Unit Hydrograph"]
["Impervious Areas      ",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"  Paved parking lots, roofs, driveways",null,null,null,"98",{"$f":"ROUND(IF(AND(E65>0,E65<10000),E65*F65,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H65>0,H65<10000),H65*I65,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K65>0,K65<10000),K65*L65,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N65>0,N65<10000),N65*O65,0),2)","v":0},"-----------",null,null,null,null,null,"DMV"]
[null,"  Streets and roads      ",null,null,null,"  ",null,null,null,null,null,null,null,null,"  ",null,null,null,null,null,null,null,"STD"]
[null,"      Paved; curbs and storm sewers","",null,null,"98",{"$f":"ROUND(IF(AND(E67>0,E67<10000),E67*F67,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H67>0,H67<10000),H67*I67,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K67>0,K67<10000),K67*L67,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N67>0,N67<10000),N67*O67,0),2)","v":0},"-----------"]
[null,"     Paved; open ditches (w/right-of-way)",null,null,null,"83",{"$f":"ROUND(IF(AND(E68>0,E68<10000),E68*F68,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(H68>0,H68<10000),H68*I68,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(K68>0,K68<10000),K68*L68,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N68>0,N68<10000),N68*O68,0),2)","v":0},"-----------"]
[null,"     Gravel (w/ right-of-way)",null,null,null,"76",{"$f":"ROUND(IF(AND(E69>0,E69<10000),E69*F69,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H69>0,H69<10000),H69*I69,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(K69>0,K69<10000),K69*L69,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(N69>0,N69<10000),N69*O69,0),2)","v":0},"-----------"]
[null,"     Dirt   (w/ right-of-way)",null,null,null,"72",{"$f":"ROUND(IF(AND(E70>0,E70<10000),E70*F70,0),2)","v":0},null,"82",{"$f":"ROUND(IF(AND(H70>0,H70<10000),H70*I70,0),2)","v":0},null,"87",{"$f":"ROUND(IF(AND(K70>0,K70<10000),K70*L70,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N70>0,N70<10000),N70*O70,0),2)","v":0},"-----------"]
["Urban Districts",null,"Avg % impervious"]
[null,"     Commercial & business","85",null,null,"89",{"$f":"ROUND(IF(AND(E72>0,E72<10000),E72*F72,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(H72>0,H72<10000),H72*I72,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(K72>0,K72<10000),K72*L72,0),2)","v":0},null,"95",{"$f":"ROUND(IF(AND(N72>0,N72<10000),N72*O72,0),2)","v":0},"-----------"]
[null,"     Industrial","72 ",null,null,"81",{"$f":"ROUND(IF(AND(E73>0,E73<10000),E73*F73,0),2)","v":0},null,"88",{"$f":"ROUND(IF(AND(H73>0,H73<10000),H73*I73,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K73>0,K73<10000),K73*L73,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N73>0,N73<10000),N73*O73,0),2)","v":0},"-----------"]
["Residential districts by average lot size",null,"Avg % impervious",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"   1/8 acre (town houses)","65",null,null,"77",{"$f":"ROUND(IF(AND(E75>0,E75<10000),E75*F75,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H75>0,H75<10000),H75*I75,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K75>0,K75<10000),K75*L75,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(N75>0,N75<10000),N75*O75,0),2)","v":0},"-----------"]
[null,"   1/4 acre","38",null,null,"61",0,null,"75",0,null,"83",0,null,"87",0,"-----------"]
[null,"   1/3 acre","30",null,null,"57",0,null,"72",0,null,"81",0,null,"86",0,"-----------"]
[null,"   1/2 acre","25",null,null,"54",0,null,"70",0,null,"80",0,null,"85",0,"-----------"]
[null,"     1 acre","20",null,null,"51",0,null,"68",0,null,"79",0,null,"84",0,"-----------"]
[null,"     2 acre","12",null,null,"46",0,null,"65",0,null,"77",0,null,"82",0,"-----------"]
[]
[null,null,null,null,null,"**",null,null,"**",null,null,"**",null,null,"**"]
["DEVELOPING URBAN AREA (No Vegetation)",null,null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"Newly graded area (pervious only) ","",null,null,"77",{"$f":"ROUND(IF(AND(E84>0,E84<10000),E84*F84,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H84>0,H84<10000),H84*I84,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K84>0,K84<10000),K84*L84,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N84>0,N84<10000),N84*O84,0),2)","v":0}]
[]
["USER DEFINED"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E87>0,E87<10000),E87*F87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H87>0,H87<10000),H87*I87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K87>0,K87<10000),K87*L87,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N87>0,N87<10000),N87*O87,0),2)","v":0},"-----------"]
[null,null,null,null,null,null,{"$f":"ROUND(IF(AND(E88>0,E88<10000),E88*F88,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H88>0,H88<10000),H88*I88,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K88>0,K88<10000),K88*L88,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N88>0,N88<10000),N88*O88,0),2)","v":0},"-----------"]
[]
[null,"Subarea Contributing Area per Soil Type (ac)",null,null,{"$f":"ROUND(SUM(E9:E88),2)","v":0},null,null,{"$f":"ROUND(SUM(H9:H88),2)","v":0},null,null,{"$f":"ROUND(SUM(K9:K88),2)","v":0},null,null,{"$f":"ROUND(SUM(N9:N88),2)","v":0}]
[null,"Subarea Contributing Area (ac)",{"$f":"SUM(E90,H90,K90,N90)","v":0}]
[null,"Subarea Weighted RCN",{"$f":"IF($C$91=0,0,(SUM(G99:P99)/C91))","v":0}]
[]
["UPSTREAM CONTRIBUTING AREAS",null,"Subarea ID",null,"Acres","RCN"]
[null,"Upstream Contributing Area 1"]
[null,"Upstream Contributing Area 2"]
[null,"Upstream Contributing Area 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-----------"]
[null,"Upstream Contributing Area 4"]
[null,null,null,null,null,null,{"$f":"SUM(G9:G88)","v":0},null,null,{"$f":"SUM(J9:J88)","v":0},null,null,{"$f":"SUM(M9:M88)","v":0},null,null,{"$f":"SUM(P9:P88)","v":0}]
[null,"Total Contributing Area w. Upstream Areas (ac)  ",null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(E90:N90)+SUM(E95:E98)),2)","v":0}]
[]
[null,null,"Weighted Runoff Curve Number (RCN)",null,null,null,null,null,null,null,{"$f":"IF($K$100=0,0,(SUM(G99:P99)+E95*F95+E96*F96+E97*F97+E98*F98)/K100)","v":0}]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"LOD","index":1,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,1,38,4],[39,1,39,4],[37,1,37,4],[36,1,36,4],[33,1,33,4],[0,1,0,10],[1,1,1,10],[35,1,35,4],[18,1,18,4],[34,1,34,4],[2,1,2,10],[3,1,3,10],[20,1,20,4],[19,1,19,4],[21,1,21,4]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["LOCATION (County):",{"$f":"'C.A. RCN'!C3","v":"New Castle"}]
["UNIT HYDROGRAPH:",{"$f":"'C.A. RCN'!C4","v":0}]
["LIMIT OF DISTURBANCE (LOD) WORKSHEET"]
["Step 1 - Subarea LOD Data","HSG A","HSG B","HSG C","HSG D"]
["1.1 HSG Area Within LOD (ac)"]
["1.2 Pre-Developed Woods/Meadow Within LOD (ac)"]
["1.3 Pre-Developed Impervious Within LOD (ac)"]
["1.4.a Post-Developed Imperviousness Within LOD, Option #1 (ac); OR"]
["1.4.b Post-Developed Imperviousness Within LOD, Option #2 (%)",{"$f":"IF(B7=0,0,B10/B7)","v":0},{"$f":"IF(C7=0,0,C10/C7)","v":0},0,0]
[]
["Step 2 - Subarea LOD Runoff Calculations"]
["2.1 RCN per HSG",{"$f":"IF(B7=0,0,(B11*98)+((1-B11)*39))","v":0},{"$f":"IF(C7=0,0,(C11*98)+((1-C11)*61))","v":0},{"$f":"IF(D7=0,0,(D11*98)+((1-D11)*74))","v":0},{"$f":"IF(E7=0,0,(E11*98)+((1-E11)*80))","v":0}]
["2.2 RPv per HSG (in.)",{"$f":"IF(B7=0,0,((2.7-(0.05*(1000/B14-10)))^2/(2.7+(0.95*(1000/B14-10)))))","v":0},{"$f":"IF(C7=0,0,((2.7-(0.05*(1000/C14-10)))^2/(2.7+(0.95*(1000/C14-10)))))","v":0},0,0]
["2.3 Target RCN per HSG",{"$f":"IF(B7=0,0,IF(B9>0,((((B8*30)+(B9*0.5*98)+((B7-B8-(B9*0.5))*39)))/B7),((((B8*30)+((B7-B8)*39)))/B7)))","v":0},{"$f":"IF(C7=0,0,IF(C9>0,((((C8*55)+(C9*0.5*98)+((C7-C8-(C9*0.5))*61)))/C7),((((C8*55)+((C7-C8)*61)))/C7)))","v":0},{"$f":"IF(D7=0,0,IF(D9>0,((((D8*70)+(D9*0.5*98)+((D7-D8-(D9*0.5))*74)))/D7),((((D8*70)+((D7-D8)*74)))/D7)))","v":0},{"$f":"IF(E7=0,0,IF(E9>0,((((E8*77)+(E9*0.5*98)+((E7-E8-(E9*0.5))*80)))/E7),((((E8*77)+((E7-E8)*80)))/E7)))","v":0}]
["2.4 Target Runoff per HSG (in.)",{"$f":"IF(B7=0,0,((2.7-(0.05*(1000/B16-10)))^2/(2.7+(0.95*(1000/B16-10)))))","v":0},{"$f":"IF(C7=0,0,((2.7-(0.05*(1000/C16-10)))^2/(2.7+(0.95*(1000/C16-10)))))","v":0},{"$f":"IF(D7=0,0,((2.7-(0.05*(1000/D16-10)))^2/(2.7+(0.95*(1000/D16-10)))))","v":0},{"$f":"IF(E7=0,0,((2.7-(0.05*(1000/E16-10)))^2/(2.7+(0.95*(1000/E16-10)))))","v":0}]
[]
["2.5 Subarea LOD (ac)",{"$f":"B7+C7+D7+E7","v":0}]
["2.6 Subarea Weighted RCN",{"$f":"IF(B19=0,0,((B7*B14)+(C7*C14)+(D7*D14)+(E7*E14))/B19)","v":0}]
["2.7 Subarea Weighted RPv (in.)",{"$f":"ROUND(IF(B19=0,0,(2.7-(0.05*(1000/B20-10)))^2/(2.7+(0.95*(1000/B20-10)))),2)","v":0}]
["2.8 Subarea Weighted Target Runoff (in.)",{"$f":"IF(B19=0,0,((B7*B17)+(C7*C17)+(D7*D17)+(E7*E17))/B19)","v":0}]
[]
["Step 3 - Upstream LOD Areas (from previous DURMM Report as applicable)","Area 1","Area 2","Area 3","Area 4"]
["3.1 Upstream Sub-Area ID",{"$f":"IF('C.A. RCN'!C95<=0,\" \",'C.A. RCN'!C95)","v":" "},{"$f":"IF('C.A. RCN'!C96<=0,\" \",'C.A. RCN'!C96)","v":" "},{"$f":"IF('C.A. RCN'!C97<=0,\" \",'C.A. RCN'!C97)","v":" "},{"$f":"IF('C.A. RCN'!C98<=0,\" \",'C.A. RCN'!C98)","v":" "}]
["3.2 Upstream Contributing Area (ac)"]
["3.3 Target Runoff for Upstream Area (in.)"]
["3.4 Adjusted CN after all reductions"]
["3.5 Adjusted RPv (in.)"]
["3.6 Adjusted Cv (in.)"]
["3.7 Adjusted Fv (in.)"]
[]
["Step 4 - RPv Calculations for Combined LOD"]
["4.1 Combined LOD (ac)",{"$f":"B19+B26+C26+D26+E26","v":0}]
["4.2 Weighted RCN",{"$f":"(B20*B19+B28*B26+C28*C26+D28*D26+E28*E26)/B34","v":{"$error":"#DIV/0!"}}]
["4.3 Weighted RPv (in.)",{"$f":"(B21*B19+B29*B26+C29*C26+D29*D26+E29*E26)/B34","v":{"$error":"#DIV/0!"}}]
["4.4 Weighted Target Runoff (in.)",{"$f":"(B22*B19+B27*B26+C27*C26+D27*D26+E27*E26)/B34","v":{"$error":"#DIV/0!"}}]
["4.5 Estimated Annual Runoff (in.)",{"$f":"0.000004*B35^3.5","v":{"$error":"#DIV/0!"}}]
["4.6 Req'd Runoff to be Managed within LOD (in.)",{"$f":"IF(B36-B37>1,1,B36-B37)","v":{"$error":"#DIV/0!"}}]
["4.7 Req'd Runoff to be Managed within LOD (%)",{"$f":"B39/B36","v":{"$error":"#DIV/0!"}}]

{"sheet":"OLOD ","index":2,"n_rows":113,"n_cols":22,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[43,1,43,2],[2,1,2,10],[3,1,3,10],[4,0,5,0],[17,12,18,13],[4,13,4,15]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["LOCATION (County):",{"$f":"'C.A. RCN'!C3","v":"New Castle"}]
["UNIT HYDROGRAPH:",{"$f":"'C.A. RCN'!C4","v":0}]
["OUTSIDE LIMIT OF DISTURBANCE (OLOD) WORKSHEET",null,null,null,null,null,null,null,null,null,null,null,null,"24-Hour Rainfall per County (in.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"County","10-YR","100-YR"]
["Step 1 - Site Data",null,null,null,null,null,null,null,null,null,null,null,null,"Kent",5.2,8.9]
["1.1 Total Contributing Area (ac)",{"$f":"IF('C.A. RCN'!C91=LOD!B19,\"N/A\",'C.A. RCN'!C91)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,"New Castle",4.8,8]
["1.2 C.A. RCN",{"$f":"IF('C.A. RCN'!C91=LOD!B19,\"N/A\",'C.A. RCN'!C92)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,"Sussex",5.3,9.1999999999999993]
["1.3 LOD Area (ac)",{"$f":"IF('C.A. RCN'!C91=LOD!B19,\"N/A\",LOD!B19)","v":"N/A"}]
["1.4 LOD RCN",{"$f":"IF('C.A. RCN'!C91=LOD!B19,\"N/A\",LOD!B20)","v":"N/A"}]
["1.5 Outside LOD Area (ac)",{"$f":"IF('C.A. RCN'!K100=LOD!B34,\"N/A\",B8-B10)","v":"N/A"}]
["1.6 Outside LOD RCN",{"$f":"IF(B12=\"N/A\",\"N/A\",((B8*B9)-(B10*B11))/B12)","v":"N/A"}]
[]
[]
["Step 2 - Time of Concentration",2.1,2.2000000000000002,2.2999999999999998,2.4,2.5,2.6]
[null,"LENGTH","SLOPE","SURFACE","MANNINGS","VELOCITY","TRAVEL"]
["FLOW TYPE","(feet)","(ft./ft.)","CODE","\"n\"","(ft./sec.)","TIME (hrs)",null,null,null,null,null,"Sheet Flow Surface Code & Type",null,"Manning's"]
["Sheet",null,null,null,{"$f":"IF(D19>0,(VLOOKUP(D19,M20:O29,3,FALSE)),\"-----------\")","v":"-----------"},"N/A",{"$f":"IF(B19>0,(0.007*(E19*B19)^0.8)/((O31)^0.5*(C19)^0.4),0)","v":0},null,null,null,null,null,null,null,"\"n\""]
[null,null,null,null,{"$f":"IF(D20>0,(VLOOKUP(D20,M20:O29,3,FALSE)),\"-----------\")","v":"-----------"},"N/A",{"$f":"IF(B20>0,(0.007*(E20*B20)^0.8)/((O31)^0.5*(C20)^0.4),0)","v":0},null,null,null,null,null,"a","Smooth Surface",1.0999999999999999E-2]
[null,null,null,null,{"$f":"IF(D21>0,(VLOOKUP(D21,M20:O29,3,FALSE)),\"-----------\")","v":"-----------"},"N/A",{"$f":"IF(B21>0,(0.007*(E21*B21)^0.8)/((O31)^0.5*(C21)^0.4),0)","v":0},null,null,null,null,null,"b","fallow (no residue)",0.05]
["Shallow Concentrated",null,null,null,"N/A",{"$f":"IF(D22=\"u\",16.1345*C22^0.5,IF(D22=\"p\",20.3282*C22^0.5,\"-----------\"))","v":"-----------"},{"$f":"IF(B22>0,((B22)/(3600*F22)),0)","v":0},null,null,null,null,null,"c","cultivated < 20% Res.",0.06]
[null,null,null,null,"N/A",{"$f":"IF(D23=\"u\",16.1345*C23^0.5,IF(D23=\"p\",20.3282*C23^0.5,\"-----------\"))","v":"-----------"},0,null,null,null,null,null,"d","cultivated > 20% Res.",0.17]
[null,null,null,null,"N/A",{"$f":"IF(D24=\"u\",16.1345*C24^0.5,IF(D24=\"p\",20.3282*C24^0.5,\"-----------\"))","v":"-----------"},0,null,null,null,null,null,"e","grass - range, short",0.15]
["Open Channel",null,null,"N/A",null,null,0,null,null,null,null,null,"f","grass, dense",0.24]
[null,null,null,"N/A",null,null,0,null,null,null,null,null,"g","grass, bermuda",0.41]
[null,null,null,"N/A",null,null,0,null,null,null,null,null,"h","woods, light",0.4]
[null,null,null,"N/A",null,null,0,null,null,null,null,null,"i","woods, dense",0.8]
[null,null,null,"N/A",null,null,0,null,null,null,null,null,"j","range, natural",0.13]
[]
[null,null,null,null,null,"2.7 Time of Concentration (Tc)",{"$f":"IF(SUM(G19:G29)=0,0.1,IF(SUM(G19:G29)<=0.1,0.1,SUM(G19:G29)))","v":0.1},null,null,null,null,null,null,"2yr 24hr rain event",3.3]
[]
[]
[null,"Sheet Flow Surface Codes",null,null,null,null,"Shallow Concentrated Surface Codes"]
[null,"a smooth surface",null,null,"f grass, dense",null,"u unpaved surface"]
[null,"b fallow (no residue)",null,null,"g grass, bermuda",null,"p paved surface"]
[null,"c cultivated < 20% Res.",null,null,"h woods, light"]
[null,"d cultivated > 20% Res.",null,null,"i woods, dense"]
[null,"e grass - range, short",null,null,"j range, natural"]
[]
[]
["Step 3 - Peak Discharge"]
[null,null,null,null,null,null,null,null,null,null,null,null,"STD Unit Peak Discharge Coefficient Table - Type II Storm",null,null,null,null,null,"UH",null,"Curve","Ia"]
["3.1 Unit Hydrograph Type",{"$f":"B4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STD",null,"Number","(in)"]
["3.2 Frequency (yr)",10,100,null,null,null,null,null,null,null,null,null,null,"Ia/P","C0","C1","C2",null,"DMV",null,30,4.6669999999999998]
["3.3 24-HR Rainfall, P (in.)",{"$f":"VLOOKUP(B3,N7:O9,2)","v":4.8},{"$f":"VLOOKUP(B3,N7:P9,3)","v":8},null,null,null,null,null,null,null,null,null,1,0.1,2.5532300000000001,-0.61512,-0.16403000000000001,null,null,null,31,4.452]
["3.4 Initial Abstraction, Ia (in.)",{"$f":"LOOKUP(B13,U45:U113,V45:V113)","v":{"$error":"#N/A"}},{"$f":"B47","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,2,0.3,2.4653200000000002,-0.62256999999999996,-0.11656999999999999,null,null,null,32,4.25]
["3.5 Ia/P ratio",{"$f":"B47/B46","v":{"$error":"#N/A"}},{"$f":"C47/C46","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,3,0.35,2.4189600000000002,-0.61594000000000004,-8.8200000000000001E-2,null,null,null,33,4.0609999999999999]
["3.6 Unit Peak Discharge, qu (csm/in)",{"$f":"IF(B4=\"STD\",10^R52,10^R64)","v":{"$error":"#N/A"}},{"$f":"IF(B4=\"STD\",10^R53,10^R65)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,4,0.4,2.36409,-0.59857000000000005,-5.6210000000000003E-2,null,null,null,34,3.8820000000000001]
["3.7 Runoff (in.)",{"$f":"(B46-0.2*((1000/B13)-10))^2/(B46+0.8*((1000/B13)-10))","v":{"$error":"#VALUE!"}},{"$f":"(C46-0.2*((1000/B13)-10))^2/(C46+0.8*((1000/B13)-10))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,5,0.45,2.2923800000000001,-0.57004999999999995,-2.281E-2,null,null,null,35,3.714]
["3.8 Peak Discharge, qp (cfs)",{"$f":"(B12/640)*B49*B50","v":{"$error":"#VALUE!"}},{"$f":"(B12/640)*C49*C50","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,6,0.5,2.20282,-0.51598999999999995,-1.259E-2,"log(qu)",null,null,36,3.556]
["3.9 Equiv. unit peak discharge (cfs/ac)",{"$f":"IF(B12=\"N/A\",0,B51/B12)","v":0},{"$f":"IF(B12=\"N/A\",0,C51/B12)","v":0},null,null,null,null,null,null,null,null,null,"10-YR",{"$f":"B48","v":{"$error":"#N/A"}},{"$f":"(-2.2349*N52^2)+(0.4759*N52)+2.5273","v":{"$error":"#N/A"}},{"$f":"(16.611*N52^4)-(16.336*N52^3)+(6.4975*N52^2)-(1.1783*N52)-0.5476","v":{"$error":"#N/A"}},{"$f":"(0.6041*N52^2)+(0.0437*N52)-0.1761","v":{"$error":"#N/A"}},{"$f":"O52+P52*LOG10(G31)+Q52*LOG10(G31)^2","v":{"$error":"#N/A"}},null,null,37,3.4049999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,"100-YR",{"$f":"C48","v":{"$error":"#N/A"}},{"$f":"(-2.2349*N53^2)+(0.4759*N53)+2.5273","v":{"$error":"#N/A"}},{"$f":"(16.611*N53^4)-(16.336*N53^3)+(6.4975*N53^2)-(1.1783*N53)-0.5476","v":{"$error":"#N/A"}},{"$f":"(0.6041*N53^2)+(0.0437*N53)-0.1761","v":{"$error":"#N/A"}},{"$f":"O53+P53*LOG10(G31)+Q53*LOG10(G31)^2","v":{"$error":"#N/A"}},null,null,38,3.2629999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,3.1280000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"DMV Unit Peak Discharge Coefficient Table - Type II Storm",null,null,null,null,null,null,null,{"$f":"U55+1","v":41},2.8780000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ia/P","C0","C1","C2",null,null,null,42,2.762]
[null,null,null,null,null,null,null,null,null,null,null,null,1,0.1,2.3373300000000001,-0.68708999999999998,-0.10847,null,null,null,43,2.6509999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,2,0.3,2.2259899999999999,-0.68545,-3.2199999999999999E-2,null,null,null,44,2.5449999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,3,0.35,2.1770700000000001,-0.66476000000000002,-8.3000000000000001E-3,null,null,null,45,2.444]
[null,null,null,null,null,null,null,null,null,null,null,null,4,0.4,2.1234099999999998,-0.63854,1.6240000000000001E-2,null,null,null,46,2.3479999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,5,0.45,2.06447,-0.59719999999999995,2.8670000000000001E-2,null,null,null,47,2.2549999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,6,0.5,1.9967299999999999,-0.53417000000000003,3.1140000000000001E-2,"log(qu)",null,null,48,2.1669999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,"10-YR",{"$f":"B48","v":{"$error":"#N/A"}},{"$f":"(-1.4336*N64^2)+(0.0072*N64)+2.3512","v":{"$error":"#N/A"}},{"$f":"(3.6441*N64^3)-(1.4577*N64^2)+(0.1255*N64)-0.6888","v":{"$error":"#N/A"}},{"$f":"(-6.1266*N64^4)+(3.2535*N64^3)+(0.4699*N64^2)+(0.0138*N64)-0.1172","v":{"$error":"#N/A"}},{"$f":"O64+P64*LOG10(G31)+Q64*LOG10(G31)^2","v":{"$error":"#N/A"}},null,null,49,2.0819999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,"100-YR",{"$f":"C48","v":{"$error":"#N/A"}},{"$f":"(-1.4336*N65^2)+(0.0072*N65)+2.3512","v":{"$error":"#N/A"}},{"$f":"(3.6441*N65^3)-(1.4577*N65^2)+(0.1255*N65)-0.6888","v":{"$error":"#N/A"}},{"$f":"(-6.1266*N65^4)+(3.2535*N65^3)+(0.4699*N65^2)+(0.0138*N65)-0.1172","v":{"$error":"#N/A"}},{"$f":"O65+P65*LOG10(G31)+Q65*LOG10(G31)^2","v":{"$error":"#N/A"}},null,null,50,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,1.9219999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,1.8460000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,1.774]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,1.704]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,1.6359999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,1.571]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,1.5089999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,1.448]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,1.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,1.333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,1.2789999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,1.226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,1.175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,1.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,1.077]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,1.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,0.94099999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,0.89900000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,0.85699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,0.81699999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,0.77800000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,0.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,0.70299999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,0.66700000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,0.63200000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,0.59699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,0.56399999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,0.53200000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,0.46899999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,0.439]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,0.38100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,0.35299999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,0.32600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,0.29899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,0.27300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,0.247]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,0.222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,0.19800000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,0.17399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,0.151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,0.128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,0.105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,8.3000000000000004E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,6.2E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,4.1000000000000002E-2]

{"sheet":"RPv","index":3,"n_rows":90,"n_cols":15,"rows_kept":90,"cut":false,"hidden":false,"merged":[[49,0,49,10],[48,0,48,10],[0,1,0,10],[1,1,1,10],[2,1,2,10],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,1,4,2]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["LOCATION (County):",{"$f":"'C.A. RCN'!C3","v":"New Castle"}]
["RESOURCE PROTECTION EVENT (RPv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2",null,"BMP 3",null,"BMP 4",null,"BMP 5"]
[null,"Type","--","Type","--","Type","--","Type","--","Type","--",null,null,null,"DURMM BMP Name"]
["Step 1 - Calculate Initial RPv","Data",null,null,null,null,null,null,null,null,null,null,null,null,"--"]
["1.1  Total contributing area to BMP (ac)",{"$f":"'C.A. RCN'!K100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"0-No BMP"]
["1.2  Initial RCN",{"$f":"IF('C.A. RCN'!K100>LOD!B34,'C.A. RCN'!K102,LOD!B35)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"--"]
["1.3  RPv for Contributing Area (in.)",{"$f":"ROUND(IF('C.A. RCN'!K100=LOD!B34,LOD!B36,(IF(B8*(2.7-(0.05*(1000/B9-10)))^2/(2.7+(0.95*(1000/B9-10)))<(LOD!B34*LOD!B36),(LOD!B34*LOD!B36/B8),(2.7-(0.05*(1000/B9-10)))^2/(2.7+(0.95*(1000/B9-10)))))),2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"1-A Infiltration Trench"]
["1.4  Req'd RPv to be Managed for Contributing Area (in.)",{"$f":"(LOD!B39*LOD!B34)/B8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"1-B Infiltration Basin"]
["1.5  Req'd RPv to be Managed for Contributing Area (%)",{"$f":"B11/B10","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"1-C Underground Infiltration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
["Step 2 - Adjust for Retention Reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,"2-A Traditional Bioretention - Underdrain"]
["2.1  Retention volume provided (cu. ft.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"2-A Traditional Bioretention - Infiltration"]
["2.2  Retention reduction allowance (%)",{"$f":"IF(C6=\"--\",\"N/A\",VLOOKUP(C6,'Data & Documentation'!$C$1:$Q$83,8,FALSE))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",VLOOKUP(E6,'Data & Documentation'!$C$1:$Q$83,8,FALSE))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",VLOOKUP(G6,'Data & Documentation'!$C$1:$Q$83,8,FALSE))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",VLOOKUP(I6,'Data & Documentation'!$C$1:$Q$83,8,FALSE))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",VLOOKUP(K6,'Data & Documentation'!$C$1:$Q$83,8,FALSE))","v":"N/A"},null,null,null,null,"2-B In-Situ Bioretention - Underdrain"]
["2.3  Retention reduction volume (ac-ft)",{"$f":"IF(C6=\"--\",\"N/A\",B15*B16/43560)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",D15*D16/43560)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",F15*F16/43560)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",H15*H16/43560)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",J15*J16/43560)","v":"N/A"},null,null,null,null,"2-B In-Situ Bioretention - Infiltration"]
["2.4  Retention reduction volume (in.)",{"$f":"IF(C6=\"--\",\"N/A\",(B17*12)/B8)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",(D17*12)/$B$8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",(F17*12)/$B$8)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",(H17*12)/$B$8)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",(J17*12)/$B$8)","v":"N/A"},null,null,null,null,"2-C Streetscape Bioretention - Underdrain"]
["2.5  Runoff volume after retention reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B10-B18<=0,0,B10-B18))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(B33-D18<=0,0,B33-D18))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(D33-F18<=0,0,D33-F18))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(F33-H18<=0,0,F33-H18))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(H33-J18<=0,0,H33-J18))","v":"N/A"},null,null,null,null,"2-C Streetscape Bioretention - Infiltration"]
["2.6  Adjusted CN*",{"$f":"IF(C6=\"--\",\"N/A\",(625*SQRT(361*B19^2+216*B19)+11875*B19+4000)/(170*B19+256))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",(625*SQRT(361*D19^2+216*D19)+11875*D19+4000)/(170*D19+256))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",(625*SQRT(361*F19^2+216*F19)+11875*F19+4000)/(170*F19+256))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",(625*SQRT(361*H19^2+216*H19)+11875*H19+4000)/(170*H19+256))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",(625*SQRT(361*J19^2+216*J19)+11875*J19+4000)/(170*J19+256))","v":"N/A"},null,null,null,null,"2-D Engineered Tree Pits - Underdrain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-D Engineered Tree Pits - Infiltration"]
["Step 3 - Adjust for Annual Runoff Reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,"2-E Stormwater Planters - Underdrain"]
["3.1  Annual CN (ACN)",{"$f":"B9","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(E6=\"--\",\"N/A\",(625*SQRT(361*B33^2+216*B33)+11875*B33+4000)/(170*B33+256))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",(625*SQRT(361*D33^2+216*D33)+11875*D33+4000)/(170*D33+256))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",(625*SQRT(361*F33^2+216*F33)+11875*F33+4000)/(170*F33+256))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",(625*SQRT(361*H33^2+216*H33)+11875*H33+4000)/(170*H33+256))","v":"N/A"},null,null,null,null,"2-E Stormwater Planters - Infiltration"]
["3.2  Annual runoff (in.)",{"$f":"0.000004*B23^3.5","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(E6=\"--\",\"N/A\",0.000004*D23^3.5)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",0.000004*F23^3.5)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",0.000004*H23^3.5)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",0.000004*J23^3.5)","v":"N/A"},null,null,null,null,"2-F Advanced Bioretention - Underdrain"]
["3.3  Proportion A/B soils in BMP footprint (%)",0,null,0,null,0,null,0,null,0,null,null,null,null,"2-F Advanced Bioretention - Infiltration"]
["3.4  Annual runoff reduction allowance (%)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B25=0,VLOOKUP(C6,'Data & Documentation'!$C$1:$Q$83,11,FALSE),(VLOOKUP(C6,'Data & Documentation'!$C$1:$Q$83,9,FALSE)*B25+VLOOKUP(C6,'Data & Documentation'!$C$1:$Q$83,11,FALSE)*(1-B25))))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(D25=0,VLOOKUP(E6,'Data & Documentation'!$C$1:$Q$83,11,FALSE),(VLOOKUP(E6,'Data & Documentation'!$C$1:$Q$83,9,FALSE)*D25+VLOOKUP(E6,'Data & Documentation'!$C$1:$Q$83,11,FALSE)*(1-D25))))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(F25=0,VLOOKUP(G6,'Data & Documentation'!$C$1:$Q$83,11,FALSE),(VLOOKUP(G6,'Data & Documentation'!$C$1:$Q$83,9,FALSE)*F25+VLOOKUP(G6,'Data & Documentation'!$C$1:$Q$83,11,FALSE)*(1-F25))))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(H25=0,VLOOKUP(I6,'Data & Documentation'!$C$1:$Q$83,11,FALSE),(VLOOKUP(I6,'Data & Documentation'!$C$1:$Q$83,9,FALSE)*H25+VLOOKUP(I6,'Data & Documentation'!$C$1:$Q$83,11,FALSE)*(1-H25))))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(J25=0,VLOOKUP(K6,'Data & Documentation'!$C$1:$Q$83,11,FALSE),(VLOOKUP(K6,'Data & Documentation'!$C$1:$Q$83,9,FALSE)*J25+VLOOKUP(K6,'Data & Documentation'!$C$1:$Q$83,11,FALSE)*(1-J25))))","v":"N/A"},null,null,null,null,"--"]
["3.5  Annual runoff after reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",B24*(1-B26))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",D24*(1-D26))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",F24*(1-F26))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",H24*(1-H26))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",J24*(1-J26))","v":"N/A"},null,null,null,null,"3-A Porous Asphalt (PA)"]
["3.6  Adjusted ACN",{"$f":"ROUND(IF(C6=\"--\",\"N/A\",34.8553*B27^0.285714),2)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(E6=\"--\",\"N/A\",34.8553*D27^0.285714)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",34.8553*F27^0.285714)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",34.8553*H27^0.285714)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",34.8553*J27^0.285714)","v":"N/A"},null,null,null,null,"3-B Pervious Concrete (PC)"]
["3.7  Annual Runoff Reduction Allowance for RPv (in.)",{"$f":"ROUND(IF(C6=\"--\",\"N/A\",IF(C6=\"0-No BMP\",0,$B$10-(2.7-(0.05*(1000/B28-10)))^2/(2.7+(0.95*(1000/B28-10))))),2)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(E6=\"--\",\"N/A\",$B$10-(2.7-(0.05*(1000/D28-10)))^2/(2.7+(0.95*(1000/D28-10))))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",$B$10-(2.7-(0.05*(1000/F28-10)))^2/(2.7+(0.95*(1000/F28-10))))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",$B$10-(2.7-(0.05*(1000/H28-10)))^2/(2.7+(0.95*(1000/H28-10))))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",$B$10-(2.7-(0.05*(1000/J28-10)))^2/(2.7+(0.95*(1000/J28-10))))","v":"N/A"},null,null,null,null,"3-C Permeable Concrete Pavers (PP) & (CP)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-D Plastic & Composite Grid Pavers (GP)"]
["Step 4 - Calculate RPv with BMP Reductions",null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
["4.1  RPv Runoff Manangement Provided (cu. ft.)",{"$f":"IF(C6=\"--\",\"N/A\",($B$10-B33)/12*43560*B8)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",($B$10-D33)/12*43560*$B$8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",($B$10-F33)/12*43560*$B$8)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",($B$10-H33)/12*43560*$B$8)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",($B$10-J33)/12*43560*$B$8)","v":"N/A"}]
["4.2  RPv runoff volume after all reductions (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF($B$10-B18-B29<=0,0,$B$10-B18-B29))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF($B$10-D18-D29<=0,0,$B$10-D18-D29))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($B$10-F18-F29<=0,0,$B$10-F18-F29))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF($B$10-H18-H29<=0,0,$B$10-H18-H29))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF($B$10-J18-J29<=0,0,$B$10-J18-J29))","v":"N/A"},null,null,null,null,"4-A Extensive Vegetated Roofs"]
["4.3  RPv runoff volume after all reductions (cu.ft.)",{"$f":"IF(C6=\"--\",\"N/A\",B33/12*B8*43560)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",D33/12*$B$8*43560)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",F33/12*$B$8*43560)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",H33/12*$B$8*43560)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",J33/12*$B$8*43560)","v":"N/A"},null,null,null,null,"4-B Intensive Vegetated Roofs"]
["4.4  Total RPv runoff reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",$B$10-B33)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",$B$10-D33)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",$B$10-F33)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",$B$10-H33)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",$B$10-J33)","v":"N/A"},null,null,null,null,"--"]
["4.5  Total RPv runoff reduction (%)",{"$f":"IF(C6=\"--\",\"N/A\",IF($B$10=0,0,IF(B35/$B$10<=0,0,B35/$B$10)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF($B$10=0,1,IF(D35/$B$10<=0,1,D35/$B$10)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($B$10=0,1,IF(F35/$B$10<=0,1,F35/$B$10)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF($B$10=0,1,IF(H35/$B$10<=0,1,H35/$B$10)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF($B$10=0,1,IF(J35/$B$10<=0,1,J35/$B$10)))","v":"N/A"},null,null,null,null,"5-A Seasonal Rainwater Harvesting"]
["4.6  Adjusted CN after all reductions*",{"$f":"IF(B20<B28,B20,B28)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D20<D28,D20,D28)","v":"N/A"},null,{"$f":"IF(F20<F28,F20,F28)","v":"N/A"},null,{"$f":"IF(H20<H28,H20,H28)","v":"N/A"},null,{"$f":"IF(J20<J28,J20,J28)","v":"N/A"},null,null,null,null,"5-B Continuous Rainwater Harvesting"]
["4.7 Adjusted equivalent annual runoff (in.)",{"$f":"IF(C6=\"--\",\"N/A\",0.000004*B37^3.5)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",0.000004*D37^3.5)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",0.000004*F37^3.5)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",0.000004*H37^3.5)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",0.000004*J37^3.5)","v":"N/A"},null,null,null,null,"--"]
["4.8  RPv Compliance Met Through Runoff Reduction?",{"$f":"IF(C6=\"--\",\"N/A\",IF(B38=0,\"YES\",IF(B35>=B11,\"YES\",\"NO\")))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(D35>=B11,\"YES\",\"NO\"))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(F35>=B11,\"YES\",\"NO\"))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(H35>=B11,\"YES\",\"NO\"))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(J35>=B11,\"YES\",\"NO\"))","v":"N/A"},null,null,null,null,"6-A Step Pool RSCS"]
["4.9  Runoff Reduction Credit, if Applicable (cu.ft)",{"$f":"IF(C6=\"--\",\"N/A\",IF(OR(C6=\"7-A Full Rooftop Disconnection - HSG A\",C6=\"7-B Full Rooftop Disconnection - HSG B\",C6=\"7-C Full Rooftop Disconnection - HSG C\",C6=\"7-D Full Disconnection - HSG D\"),0,IF(B39=\"YES\",($B$11-B35)*43560/12*B8,\"N/A\")))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(OR(E6=\"7-A Full Rooftop Disconnection - HSG A\",E6=\"7-B Full Rooftop Disconnection - HSG B\",E6=\"7-C Full Rooftop Disconnection - HSG C\",E6=\"7-D Full Disconnection - HSG D\"),0,IF(D39=\"YES\",($B$11-D35)*43560/12*$B$8,\"N/A\")))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(OR(G6=\"7-A Full Rooftop Disconnection - HSG A\",G6=\"7-B Full Roofto Ddisconnection - HSG B\",G6=\"7-C Full Rooftop Disconnection - HSG C\",G6=\"7-D Full Disconnection - HSG D\"),0,IF(F39=\"YES\",($B$11-F35)*43560/12*$B$8,\"N/A\")))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(OR(I6=\"7-A Full Rooftop Disconnection - HSG A\",I6=\"7-B Full Rooftop Disconnection - HSG B\",I6=\"7-C Full Rooftop Disconnection - HSG C\",I6=\"7-D Full Disconnection - HSG D\"),0,IF(H39=\"YES\",($B$11-H35)*43560/12*$B$8,\"N/A\")))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(OR(K6=\"7-A Full Rooftop Disconnection - HSG A\",K6=\"7-B Full Rooftop Disconnection - HSG B\",K6=\"7-C Full Rooftop Disconnection - HSG C\",K6=\"7-D Full Disconnection - HSG D\"),0,IF(J39=\"YES\",($B$11-J35)*43560/12*$B$8,\"N/A\")))","v":"N/A"},null,null,null,null,"6-B Seepage Wetland RSCS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-C Streambank Stabilization"]
["Step 5 - Determine Residual Volume to be Managed or Offset",null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
["5.1 RPv Residual Volume (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B39=\"YES\",\"N/A\",$B$11-B35))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(D39=\"YES\",\"N/A\",$B$11-D35))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(F39=\"YES\",\"N/A\",$B$11-F35))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(H39=\"YES\",\"N/A\",$B$11-H35))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(J39=\"YES\",\"N/A\",$B$11-J35))","v":"N/A"},null,null,null,null,"7-A Full Rooftop Disconnection - HSG A"]
["5.2  RPv Residual Volume (cu.ft./ac)",{"$f":"IF(B43=\"N/A\",\"N/A\",B43*43560/12)","v":"N/A"},null,{"$f":"IF(D43=\"N/A\",\"N/A\",D43*43560/12)","v":"N/A"},null,{"$f":"IF(F43=\"N/A\",\"N/A\",F43*43560/12)","v":"N/A"},null,{"$f":"IF(H43=\"N/A\",\"N/A\",H43*43560/12)","v":"N/A"},null,{"$f":"IF(J43=\"N/A\",\"N/A\",J43*43560/12)","v":"N/A"},null,null,null,null,"7-B Full Rooftop Disconnection - HSG B"]
["5.3  Residual Volume to be Managed or Offset (cu.ft.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B39=\"YES\",\"N/A\",B8*B44))","v":"N/A"},null,{"$f":"IF(D43=\"N/A\",\"N/A\",$B$8*D44)","v":"N/A"},null,{"$f":"IF(F43=\"N/A\",\"N/A\",$B$8*F44)","v":"N/A"},null,{"$f":"IF(H43=\"N/A\",\"N/A\",$B$8*H44)","v":"N/A"},null,{"$f":"IF(J43=\"N/A\",\"N/A\",$B$8*J44)","v":"N/A"},null,null,null,null,"7-C Full Rooftop Disconnection - HSG C"]
["5.4  RPv avg. discharge rate for 48-hr detention (cfs)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B39=\"YES\",\"N/A\",B45/172800))","v":"N/A"},null,{"$f":"IF(D43=\"N/A\",\"N/A\",D45/172800)","v":"N/A"},null,{"$f":"IF(F43=\"N/A\",\"N/A\",F45/172800)","v":"N/A"},null,{"$f":"IF(H43=\"N/A\",\"N/A\",H45/172800)","v":"N/A"},null,{"$f":"IF(J43=\"N/A\",\"N/A\",J45/172800)","v":"N/A"},null,null,null,null,"7-D Full Rooftop Disconnection - HSG D"]
["5.5 RPv max. discharge rate for 48-hr detention (cfs)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B39=\"YES\",\"N/A\",B46*5))","v":"N/A"},null,{"$f":"IF(D43=\"N/A\",\"N/A\",D46*5)","v":"N/A"},null,{"$f":"IF(F43=\"N/A\",\"N/A\",F46*5)","v":"N/A"},null,{"$f":"IF(H43=\"N/A\",\"N/A\",H46*5)","v":"N/A"},null,{"$f":"IF(J43=\"N/A\",\"N/A\",J46*5)","v":"N/A"},null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8-A Bioswale"]
["*NOTE:  No additional runoff reduction credit can be taken for surface recharge practices once the “Adjusted CN after all reductions” (Step 4.6) reaches the equivalent CN for the native soil-cover condition of the BMP ",null,null,null,null,null,null,null,null,null,null,null,null,null,"8-B Grassed Channel"]
["footprint itself (i.e. for Sheet Flow to Turf Filter Strip on B soils Step 4.6 cannot be below 61).  If this occurs contact the DNREC – SSP for further guidance.",null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-A Sheet Flow to Grassed Filter Strip"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-B Sheet Flow to Afforested Filter Strip"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-C Sheet Flow to Forested Filter Strip"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-D Sheet Flow to Grassed Open Space"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-E Sheet Flow to Afforested Open Space"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-F Sheet Flow to Forested Open Space"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-A Dry Detention Pond"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-B Dry Extended Detention (ED) Basin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-C Underground Detention Facilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-D Underground 48-HR Detention Facilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-A Non-Structural Sand Filter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-B Surface Sand Filter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-C 3-Chamber Underground Sand Filter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-D Perimeter Sand Filter (DE Sand Filter)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-A Traditional Constructed Wetlands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-B Wetland Swales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-C Ephemeral Constructed Wetlands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-D Submerged Gravel Wetlands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-A Wet Quantity Management Pond"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-B Wet Extended Detention (ED) Pond"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-A Compost Amended Soil - HSG A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-B Compost Amended Soil - HSG B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-C Compost Amended Soil - HSG C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-D Compost Amended Soil - HSG D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15-A Proprietary Practices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-A Nutrient Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-B Street Sweeping"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-AA Afforestation - HSG A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-AB Afforestation - HSG B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-AC Afforestation - HSG C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-AD Afforestation - HSG D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-B Urban Tree Planting"]

{"sheet":"TMDL","index":4,"n_rows":62,"n_cols":29,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,18,5,20],[4,17,4,20],[4,23,4,28],[5,2,5,4],[5,6,5,8],[5,10,5,12],[5,14,5,16],[0,25,0,27],[0,1,0,20],[1,1,1,20],[4,1,4,4],[4,5,4,8],[4,9,4,12],[4,13,4,16],[2,1,2,4],[2,5,2,20]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMC (mg/L)"]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN","TP","TSS"]
["TMDL WATERSHED:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8,0.49,90]
["TOTAL MAXIMUM DAILY LOAD (TMDL) WORKSHEET"]
[null,"BMP 1",null,null,null,"BMP 2",null,null,null,"BMP 3",null,null,null,"BMP 4",null,null,null,"BMP 5",null,null,null,null,null,"TMDL Reduction Requirements"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},null,null,"Type:",{"$f":"RPv!E6","v":"--"},null,null,"Type:",{"$f":"RPv!G6","v":"--"},null,null,"Type:",{"$f":"RPv!I6","v":"--"},null,null,"Type:",{"$f":"RPv!K6","v":"--"},null,null,null,null,"Drainage Basin","TMDL Watershed","WS Code","TN TMDL","TP TMDL","TSS TMDL"]
["Step 1 - Calculate Annual Runoff Volume","Data","TN","TP","TSS","Data","TN","TP","TSS","Data","TN","TP","TSS","Data","TN","TP","TSS","Data","TN","TP","TSS"]
["1.1 Total contributing area to BMP (ac)",{"$f":"RPv!B8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piedmont","Naamans Creek",1,10.4,0.72,"N/A"]
["1.2 Initial RCN",{"$f":"RPv!B9","v":{"$error":"#DIV/0!"}}]
["1.3 Annual runoff volume  (in.)",{"$f":"RPv!B24","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shellpot Creek, above Rt. 13",2,6.3,0.43,"N/A"]
["1.4 Annual runoff volume (liters)",{"$f":"B8*B10*102790","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shellpot Creek, below Rt. 13",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brandywine Creek",3,10.1,0.67,"N/A"]
["Step 2 - Calculate Annual Pollutant Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Clay Creek",4,5.3,0.49,"N/A"]
["2.1  EMC (mg/L)",null,{"$f":"IF(C6=\"--\",\"N/A\",$Z$3)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",$AA$3)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",$AB$3)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",C24)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",D24)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",E24)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",G24)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",H24)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",I24)","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",K24)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",L24)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",M24)","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",O24)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",P24)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",Q24)","v":"N/A"},null,null,null,"White Clay Creek",5,8,0.46,"N/A"]
["2.2 Load (mg/yr)",null,{"$f":"IF(C6=\"--\",\"N/A\",B11*C14)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",B11*D14)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",B11*E14)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",B21*G14)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",B21*H14)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",B21*I14)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",F21*K14)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",F21*L14)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",F21*M14)","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",J21*O14)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",J21*P14)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",J21*Q14)","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",N21*S14)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",N21*T14)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",N21*U14)","v":"N/A"},null,null,null,"Christina River",6,5.7,0.35,"N/A"]
["2.3 Stormwater Load (lb/ac/yr)",null,{"$f":"IF(C6=\"--\",\"N/A\",C15*0.000002205/B8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",D15*0.000002205/B8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",E15*0.000002205/B8)","v":"N/A"},null,{"$f":"IF($G$6=\"--\",\"N/A\",C25)","v":"N/A"},{"$f":"IF($G$6=\"--\",\"N/A\",D25)","v":"N/A"},{"$f":"IF($G$6=\"--\",\"N/A\",E25)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",G25)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",H25)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",I25)","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",K25)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",L25)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",M25)","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",O25)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",P25)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",Q25)","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delaware Bay","Delaware River",7]
["Step 3 - Adjust for Pollutant Reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Army Creek",8,2.1,0.18,"N/A"]
["3.1 BMP annual runoff reduction (%)",{"$f":"IF(C6=\"--\",\"N/A\",(RPv!B24-RPv!B38)/RPv!B24)","v":"N/A"},null,null,null,{"$f":"IF(G6=\"--\",\"N/A\",(RPv!D24-RPv!D38)/RPv!D24)","v":"N/A"},null,null,null,{"$f":"IF(K6=\"--\",\"N/A\",(RPv!F24-RPv!F38)/RPv!F24)","v":"N/A"},null,null,null,{"$f":"IF(O6=\"--\",\"N/A\",(RPv!H24-RPv!H38)/RPv!H24)","v":"N/A"},null,null,null,{"$f":"IF(S6=\"--\",\"N/A\",(RPv!J24-RPv!J38)/RPv!J24)","v":"N/A"}]
["3.2 Adjusted annual runoff volume (in)",{"$f":"RPv!B38","v":"N/A"},null,null,null,{"$f":"RPv!D38","v":"N/A"},null,null,null,{"$f":"RPv!F38","v":"N/A"},null,null,null,{"$f":"RPv!H38","v":"N/A"},null,null,null,{"$f":"RPv!J38","v":"N/A"},null,null,null,null,null,null,"Red Lion Creek",9,6.9,0.21,"N/A"]
["3.3 Adjusted annual runoff volume (liters)",{"$f":"IF(B19=\"N/A\",\"N/A\",$B$8*B20*102790)","v":"N/A"},null,null,null,{"$f":"IF(F19=\"N/A\",\"N/A\",$B$8*F20*102790)","v":"N/A"},null,null,null,{"$f":"IF(J19=\"N/A\",\"N/A\",$B$8*J20*102790)","v":"N/A"},null,null,null,{"$f":"IF(N19=\"N/A\",\"N/A\",$B$8*N20*102790)","v":"N/A"},null,null,null,{"$f":"IF(R19=\"N/A\",\"N/A\",$B$8*R20*102790)","v":"N/A"},null,null,null,null,null,null,"Dragon Run Creek",10,5.3,0.28000000000000003,"N/A"]
["3.4 Adjusted load from annual reductions (lb/ac/yr)",null,{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,C16,C14*B21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,D16,D14*B21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,E16,E14*B21*0.000002205/$B$8))","v":"N/A"},null,{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,G16,G14*F21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,H16,H14*F21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,I16,I14*F21*0.000002205/$B$8))","v":"N/A"},null,{"$f":"IF(J19=\"N/A\",\"N/A\",IF(J19=0,K16,K14*J21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(J19=\"N/A\",\"N/A\",IF(J19=0,L16,L14*J21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(J19=\"N/A\",\"N/A\",IF(J19=0,M16,M14*J21*0.000002205/$B$8))","v":"N/A"},null,{"$f":"IF(N19=\"N/A\",\"N/A\",IF(N19=0,O16,O14*N21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(N19=\"N/A\",\"N/A\",IF(N19=0,P16,P14*N21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(N19=\"N/A\",\"N/A\",IF(N19=0,Q16,Q14*N21*0.000002205/$B$8))","v":"N/A"},null,{"$f":"IF(R19=\"N/A\",\"N/A\",IF(R19=0,S16,S14*R21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(R19=\"N/A\",\"N/A\",IF(R19=0,T16,T14*R21*0.000002205/$B$8))","v":"N/A"},{"$f":"IF(R19=\"N/A\",\"N/A\",IF(R19=0,U16,U14*R21*0.000002205/$B$8))","v":"N/A"},null,null,null,"C&D Canal East",11,null,null,"N/A"]
["3.5 BMP removal efficiency (%)",null,{"$f":"IF(C6=\"--\",\"N/A\",IF(VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,2,FALSE)=1,\"N/A\",VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,2,FALSE)))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF(VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,4,FALSE)=1,\"N/A\",VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,4,FALSE)))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF(VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,6,FALSE)=1,\"N/A\",VLOOKUP(C6,'Data & Documentation'!$C$2:$I$83,6,FALSE)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,2,FALSE)=1,\"N/A\",VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,2,FALSE)))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF(VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,4,FALSE)=1,\"N/A\",VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,4,FALSE)))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF(VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,6,FALSE)=1,\"N/A\",VLOOKUP(G6,'Data & Documentation'!$C$2:$I$83,6,FALSE)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,2,FALSE)=1,\"N/A\",VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,2,FALSE)))","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",IF(VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,4,FALSE)=1,\"N/A\",VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,4,FALSE)))","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",IF(VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,6,FALSE)=1,\"N/A\",VLOOKUP(K6,'Data & Documentation'!$C$2:$I$83,6,FALSE)))","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",IF(VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,2,FALSE)=1,\"N/A\",VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,2,FALSE)))","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",IF(VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,4,FALSE)=1,\"N/A\",VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,4,FALSE)))","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",IF(VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,6,FALSE)=1,\"N/A\",VLOOKUP(O6,'Data & Documentation'!$C$2:$I$83,6,FALSE)))","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",IF(VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,2,FALSE)=1,\"N/A\",VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,2,FALSE)))","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",IF(VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,4,FALSE)=1,\"N/A\",VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,4,FALSE)))","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",IF(VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,6,FALSE)=1,\"N/A\",VLOOKUP(S6,'Data & Documentation'!$C$2:$I$83,6,FALSE)))","v":"N/A"},null,null,null,"Appoquinimink River",12,6.4,0.83,"N/A"]
["3.6 BMP effluent concentration (mg/L)",null,{"$f":"IF(C23=\"N/A\",C14,C14*(1-C23))","v":"N/A"},{"$f":"IF(D23=\"N/A\",D14,D14*(1-D23))","v":"N/A"},"N/A",null,{"$f":"IF(G23=\"N/A\",G14,G14*(1-G23))","v":"N/A"},{"$f":"IF(H23=\"N/A\",H14,H14*(1-H23))","v":"N/A"},{"$f":"IF(I23=\"N/A\",I14,I14*(1-I23))","v":"N/A"},null,{"$f":"IF(K23=\"N/A\",K14,K14*(1-K23))","v":"N/A"},{"$f":"IF(L23=\"N/A\",L14,L14*(1-L23))","v":"N/A"},{"$f":"IF(M23=\"N/A\",M14,M14*(1-M23))","v":"N/A"},null,{"$f":"IF(O23=\"N/A\",O14,O14*(1-O23))","v":"N/A"},{"$f":"IF(P23=\"N/A\",P14,P14*(1-P23))","v":"N/A"},{"$f":"IF(Q23=\"N/A\",Q14,Q14*(1-Q23))","v":"N/A"},null,{"$f":"IF(S23=\"N/A\",S14,S14*(1-S23))","v":"N/A"},{"$f":"IF(T23=\"N/A\",T14,T14*(1-T23))","v":"N/A"},{"$f":"IF(U23=\"N/A\",U14,U14*(1-U23))","v":"N/A"},null,null,null,"Blackbird Creek",13,3.2,0.36,"N/A"]
["3.7 Final Adjusted load (lb/ac/yr)",null,{"$f":"IF(C23=\"N/A\",C22,C22*(1-C23))","v":"N/A"},{"$f":"IF(D23=\"N/A\",D22,D22*(1-D23))","v":"N/A"},"N/A",null,{"$f":"IF(G23=\"N/A\",G22,G22*(1-G23))","v":"N/A"},{"$f":"IF(H23=\"N/A\",H22,H22*(1-H23))","v":"N/A"},"N/A",null,{"$f":"IF(K23=\"N/A\",K22,K22*(1-K23))","v":"N/A"},{"$f":"IF(L23=\"N/A\",L22,L22*(1-L23))","v":"N/A"},"N/A",null,{"$f":"IF(O23=\"N/A\",O22,O22*(1-O23))","v":"N/A"},{"$f":"IF(P23=\"N/A\",P22,P22*(1-P23))","v":"N/A"},"N/A",null,{"$f":"IF(S23=\"N/A\",S22,S22*(1-S23))","v":"N/A"},{"$f":"IF(T23=\"N/A\",T22,T22*(1-T23))","v":"N/A"},"N/A",null,null,null,"Delaware Bay",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smyrna River",15,6.6,0.51,"N/A"]
["Step 4 - Pollutant Reduction Met? (For Informational Purposes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leipsic River",16,6.6,0.73,"N/A"]
["4.1 TMDL (lb/ac/yr)",null,{"$f":"VLOOKUP(B3,Y7:AC62,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B3,Y7:AC62,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B3,Y7:AC62,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Little Creek",17,4.7,0.51,"N/A"]
["4.2 Reduction met?",null,{"$f":"IF(C6=\"--\",\"N/A\",IF($C$28>=C16,\"YES\",IF(C25<=$C$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF($D$28>=D16,\"YES\",IF(D25<=$D$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF($E$28=\"N/A\",\"N/A\",IF($E$28>=E16,\"YES\",IF(E25<=$E$28,\"YES\",\"NO\"))))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($C$28>=G16,\"YES\",IF(G25<=$C$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF($D$28>=H16,\"YES\",IF(H25<=$D$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF($E$28=\"N/A\",\"N/A\",IF($E$28>=I16,\"YES\",IF(I25<=$E$28,\"YES\",\"NO\"))))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF($C$28>=K16,\"YES\",IF(K25<=$C$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",IF($D$28>=L16,\"YES\",IF(L25<=$D$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",IF($E$28=\"N/A\",\"N/A\",IF($E$28>=M16,\"YES\",IF(M25<=$E$28,\"YES\",\"NO\"))))","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",IF($C$28>=O16,\"YES\",IF(O25<=$C$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",IF($D$28>=P16,\"YES\",IF(P25<=$D$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",IF($E$28=\"N/A\",\"N/A\",IF($E$28>=Q16,\"YES\",IF(Q25<=$E$28,\"YES\",\"NO\"))))","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",IF($C$28>=S16,\"YES\",IF(S25<=$C$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",IF($D$28>=T16,\"YES\",IF(T25<=$D$28,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",IF($E$28=\"N/A\",\"N/A\",IF($E$28>=U16,\"YES\",IF(U25<=$E$28,\"YES\",\"NO\"))))","v":"N/A"},null,null,null,"St. Jones River",18,5.5,0.39,"N/A"]
["4.3 Final Adjusted Load (lb/yr)",null,{"$f":"IF(C6=\"--\",\"N/A\",C25*$B$8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",D25*$B$8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",E25*$B$8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",G25*$B$8)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",H25*$B$8)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",I25*$B$8)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",K25*$B$8)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",L25*$B$8)","v":"N/A"},{"$f":"IF(K6=\"--\",\"N/A\",M25*$B$8)","v":"N/A"},null,{"$f":"IF(O6=\"--\",\"N/A\",O25*$B$8)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",P25*$B$8)","v":"N/A"},{"$f":"IF(O6=\"--\",\"N/A\",Q25*$B$8)","v":"N/A"},null,{"$f":"IF(S6=\"--\",\"N/A\",S25*$B$8)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",T25*$B$8)","v":"N/A"},{"$f":"IF(S6=\"--\",\"N/A\",U25*$B$8)","v":"N/A"},null,null,null,"Murderkill River",19,3,0.51,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mispillion River, King's Causeway Br.",20,5.7,0.1,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mispillion River, Remaining WS",20,5.7,0.1,"N/A"]
["5.1 TMDL Shortfall (lb/ac/yr)",null,{"$f":"IF(C25-C28<=0,0,C25-C28)","v":{"$error":"#VALUE!"}},{"$f":"IF(D25-D28<=0,0,D25-D28)","v":{"$error":"#VALUE!"}},{"$f":"IF(E28=\"N/A\",0,IF(E25-E28<=0,0,E25-E28))","v":{"$error":"#N/A"}},null,{"$f":"IF(G25-G28<=0,0,G25-G28)","v":{"$error":"#VALUE!"}},{"$f":"IF(H25-H28<=0,0,H25-H28)","v":{"$error":"#VALUE!"}},{"$f":"IF(I28=\"N/A\",0,IF(I25-I28<=0,0,I25-I28))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(K25-K28<=0,0,K25-K28)","v":{"$error":"#VALUE!"}},{"$f":"IF(L25-L28<=0,0,L25-L28)","v":{"$error":"#VALUE!"}},{"$f":"IF(M28=\"N/A\",0,IF(M25-M28<=0,0,M25-M28))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(O25-O28<=0,0,O25-O28)","v":{"$error":"#VALUE!"}},{"$f":"IF(P25-P28<=0,0,P25-P28)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q28=\"N/A\",0,IF(Q25-Q28<=0,0,Q25-Q28))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(S25-S28<=0,0,S25-S28)","v":{"$error":"#VALUE!"}},{"$f":"IF(T25-T28<=0,0,T25-T28)","v":{"$error":"#VALUE!"}},{"$f":"IF(U28=\"N/A\",0,IF(U25-U28<=0,0,U25-U28))","v":{"$error":"#VALUE!"}},null,null,null,"Cedar Creek",21,6.4,0.25,"N/A"]
["5.2 TMDL Shortfall (%)",null,{"$f":"C33/C25","v":{"$error":"#VALUE!"}},{"$f":"D33/D25","v":{"$error":"#VALUE!"}},{"$f":"E33/E25","v":{"$error":"#N/A"}},null,{"$f":"G33/G25","v":{"$error":"#VALUE!"}},{"$f":"H33/H25","v":{"$error":"#VALUE!"}},{"$f":"I33/I25","v":{"$error":"#VALUE!"}},null,{"$f":"K33/K25","v":{"$error":"#VALUE!"}},{"$f":"L33/L25","v":{"$error":"#VALUE!"}},{"$f":"M33/M25","v":{"$error":"#VALUE!"}},null,{"$f":"O33/O25","v":{"$error":"#VALUE!"}},{"$f":"P33/P25","v":{"$error":"#VALUE!"}},{"$f":"Q33/Q25","v":{"$error":"#VALUE!"}},null,{"$f":"S33/S25","v":{"$error":"#VALUE!"}},{"$f":"T33/T25","v":{"$error":"#VALUE!"}},{"$f":"U33/U25","v":{"$error":"#VALUE!"}},null,null,null,"Broadkill River",22,11.9,0.5,"N/A"]
["5.3 Residual RPv Volume (in)",null,{"$f":"RPv!B33","v":"N/A"},{"$f":"RPv!B33","v":"N/A"},{"$f":"RPv!B33","v":"N/A"},null,{"$f":"RPv!D33","v":"N/A"},{"$f":"RPv!D33","v":"N/A"},{"$f":"RPv!D33","v":"N/A"},null,{"$f":"RPv!F33","v":"N/A"},{"$f":"RPv!F33","v":"N/A"},{"$f":"RPv!F33","v":"N/A"},null,{"$f":"RPv!H33","v":"N/A"},{"$f":"RPv!H33","v":"N/A"},{"$f":"RPv!H33","v":"N/A"},null,{"$f":"RPv!J33","v":"N/A"},{"$f":"RPv!J33","v":"N/A"},{"$f":"RPv!J33","v":"N/A"}]
["5.4 Req'd Additional RR to meet TMDL (in)*",null,{"$f":"C34*C35","v":{"$error":"#VALUE!"}},{"$f":"D34*D35","v":{"$error":"#VALUE!"}},{"$f":"E34*E35","v":{"$error":"#N/A"}},null,{"$f":"G34*G35","v":{"$error":"#VALUE!"}},{"$f":"H34*H35","v":{"$error":"#VALUE!"}},{"$f":"I34*I35","v":{"$error":"#VALUE!"}},null,{"$f":"K34*K35","v":{"$error":"#VALUE!"}},{"$f":"L34*L35","v":{"$error":"#VALUE!"}},{"$f":"M34*M35","v":{"$error":"#VALUE!"}},null,{"$f":"O34*O35","v":{"$error":"#VALUE!"}},{"$f":"P34*P35","v":{"$error":"#VALUE!"}},{"$f":"Q34*Q35","v":{"$error":"#VALUE!"}},null,{"$f":"S34*S35","v":{"$error":"#VALUE!"}},{"$f":"T34*T35","v":{"$error":"#VALUE!"}},{"$f":"U34*U35","v":{"$error":"#VALUE!"}},null,null,"Chesapeake Bay","Elk Creek",23,6.58,0.57999999999999996,129]
["5.5 Req'd Additional RR to meet TMDL (cu.ft./ac)",null,{"$f":"C36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"D36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"E36*43560/12","v":{"$error":"#N/A"}},null,{"$f":"G36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"H36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"I36*43560/12","v":{"$error":"#VALUE!"}},null,{"$f":"K36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"L36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"M36*43560/12","v":{"$error":"#VALUE!"}},null,{"$f":"O36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"P36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"Q36*43560/12","v":{"$error":"#VALUE!"}},null,{"$f":"S36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"T36*43560/12","v":{"$error":"#VALUE!"}},{"$f":"U36*43560/12","v":{"$error":"#VALUE!"}},null,null,null,"Perch Creek",24,6.58,0.57999999999999996,129]
["5.6 Total Offset Volume (cu.ft.)",null,{"$f":"B8*C37","v":{"$error":"#VALUE!"}},{"$f":"B8*D37","v":{"$error":"#VALUE!"}},{"$f":"B8*E37","v":{"$error":"#N/A"}},null,{"$f":"B8*G37","v":{"$error":"#VALUE!"}},{"$f":"B8*H37","v":{"$error":"#VALUE!"}},{"$f":"B8*I37","v":{"$error":"#VALUE!"}},null,{"$f":"B8*K37","v":{"$error":"#VALUE!"}},{"$f":"B8*L37","v":{"$error":"#VALUE!"}},{"$f":"B8*M37","v":{"$error":"#VALUE!"}},null,{"$f":"B8*O37","v":{"$error":"#VALUE!"}},{"$f":"B8*P37","v":{"$error":"#VALUE!"}},{"$f":"B8*Q37","v":{"$error":"#VALUE!"}},null,{"$f":"B8*S37","v":{"$error":"#VALUE!"}},{"$f":"B8*T37","v":{"$error":"#VALUE!"}},{"$f":"B8*U37","v":{"$error":"#VALUE!"}},null,null,null,"C&D Canal West",25,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bohemia Creek",26,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sassafras River",27,6.58,0.57999999999999996,129]
["*=  % TMDL shortfall x Residual RPv",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chester River",28,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choptank River",29,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marshyhope Creek",30,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nanticoke River",31,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gum Branch",32,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gravelly Branch",33,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deep Creek",34,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broad Creek",35,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wicomico River",36,6.58,0.57999999999999996,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pocomoke River",37,6.58,0.57999999999999996,129]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inland Bays/Atlantic Ocean","Lewes-Rehoboth Canal",38,5.7,0.23,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rehoboth Bay",39,5.7,0.23,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indian River, Upper",40,3.3,0.18,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indian River, Lower",40,5.7,0.23,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iron Branch",41,3.3,0.18,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indian River Bay",42,5.7,0.23,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buntings Branch",43,11.9,0.39,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assawoman Bay",44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Little Assawoman Bay",45,5.7,0.23,"N/A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End"]

{"sheet":"Cv","index":5,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[2,1,2,10]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["LOCATION (County):",{"$f":"'C.A. RCN'!C3","v":"New Castle"}]
["CONVEYANCE EVENT (Cv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2",null,"BMP 3",null,"BMP 4",null,"BMP 5"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},"Type:",{"$f":"RPv!E6","v":"--"},"Type:",{"$f":"RPv!G6","v":"--"},"Type:",{"$f":"RPv!I6","v":"--"},"Type:",{"$f":"RPv!K6","v":"--"},null,null,null,"Rainfall","10-YR"]
["Step 1 - Calculate Initial Cv","Data",null,"Data",null,"Data",null,"Data",null,"Data",null,null,null,null,"Kent",5.2]
["1.1  Total contributing area to BMP (ac)",{"$f":"RPv!B8","v":0},null,{"$f":"B8","v":0},null,{"$f":"D8","v":0},null,{"$f":"F8","v":0},null,{"$f":"H8","v":0},null,null,null,null,"New Castle",4.8]
["1.2  Initial RCN",{"$f":"RPv!B9","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Sussex",5.3]
["1.3  10-Year Rainfall (in.)",{"$f":"VLOOKUP(B3,O7:P9,2)","v":4.8}]
["1.4  Cv runoff volume (in.)",{"$f":"IF(B10=0,\"XXXXXXXX\",(B10-0.2*((1000/B9)-10))^2/(B10+0.8*((1000/B9)-10)))","v":{"$error":"#DIV/0!"}}]
[]
["Step 2 - Adjust for Retention Reduction"]
["2.1  Storage volume (cu. ft.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(RPv!B16=0, 0,RPv!B15))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(RPv!D16=0, 0,RPv!D15))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(RPv!F16=0, 0,RPv!F15))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(RPv!H16=0, 0,RPv!H15))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(RPv!J16=0, 0,RPv!J15))","v":"N/A"}]
["2.2  Storage volume (ac-ft)",{"$f":"IF(C6=\"--\",\"N/A\",B14/43560)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",D14/43560)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",F14/43560)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",H14/43560)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",J14/43560)","v":"N/A"}]
["2.3  Storage volume (in.)",{"$f":"IF(C6=\"--\",\"N/A\",(B15*12)/B8)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",(D15*12)/D8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",(F15*12)/F8)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",(H15*12)/H8)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",(J15*12)/J8)","v":"N/A"}]
["2.4  Runoff volume after reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B11-B16<=0,0,B11-B16))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(B27-D16<=0,0,B27-D16))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(D27-F16<=0,0,D27-F16))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(F27-H16<=0,0,F27-H16))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(H27-J16<=0,0,H27-J16))","v":"N/A"}]
["2.5  CN*",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B17+2)-SQRT((5*B10*B17)+4*B17^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D17+2)-SQRT((5*B10*D17)+4*D17^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F17+2)-SQRT((5*B10*F17)+4*F17^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H17+2)-SQRT((5*B10*H17)+4*H17^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J17+2)-SQRT((5*B10*J17)+4*J17^2)))","v":"N/A"}]
[]
["Step 3 - Adjust for Annual Runoff Reduction"]
["3.1  Runoff reduction allowance (%)",{"$f":"IF(C6=\"--\",\"N/A\",VLOOKUP(C6,'Data & Documentation'!C1:R77,13,FALSE))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",VLOOKUP(E6,'Data & Documentation'!C1:R77,13,FALSE))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",VLOOKUP(G6,'Data & Documentation'!C1:R77,13,FALSE))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",VLOOKUP(I6,'Data & Documentation'!C1:R77,13,FALSE))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",VLOOKUP(K6,'Data & Documentation'!C1:R77,13,FALSE))","v":"N/A"}]
["3.2  Annual runoff after reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",B11*(1-B21))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",B27*(1-D21))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",D27*(1-F21))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",F27*(1-H21))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",H27*(1-J21))","v":"N/A"}]
["3.3  Adjusted ACN",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B22+2)-SQRT((5*B10*B22)+4*B22^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D22+2)-SQRT((5*B10*D22)+4*D22^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F22+2)-SQRT((5*B10*F22)+4*F22^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H22+2)-SQRT((5*B10*H22)+4*H22^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J22+2)-SQRT((5*B10*J22)+4*J22^2)))","v":"N/A"}]
["3.4  Event-based runoff reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/B23-10))^2/($B$10+0.8*(1000/B23-10)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/D23-10))^2/($B$10+0.8*(1000/D23-10)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/F23-10))^2/($B$10+0.8*(1000/F23-10)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/H23-10))^2/($B$10+0.8*(1000/H23-10)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/J23-10))^2/($B$10+0.8*(1000/J23-10)))","v":"N/A"}]
[]
["Step 4 - Calculate Cv with BMP Reductions"]
["4.1  Cv runoff volume after all reductions (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF($B$11-B16-B24<=0,0,$B$11-B16-B24))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF($B$11-D16-D24<=0,0,$B$11-D16-D24))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($B$11-F16-F24<=0,0,$B$11-F16-F24))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF($B$11-H16-H24<=0,0,$B$11-H16-H24))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF($B$11-J16-J24<=0,0,$B$11-J16-J24))","v":"N/A"}]
["4.2  Total Cv runoff reduction (%)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-B27)/B11<=0,0,(B11-B27)/B11)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-D27)/B11<=0,0,(B11-D27)/B11)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-F27)/B11<=0,0,(B11-F27)/B11)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-H27)/B11<=0,0,(B11-H27)/B11)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-J27)/B11<=0,0,(B11-J27)/B11)))","v":"N/A"}]
["4.3  Adjusted RCN for H&H modeling",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B27+2)-SQRT((5*B10*B27)+4*B27^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D27+2)-SQRT((5*B10*D27)+4*D27^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F27+2)-SQRT((5*B10*F27)+4*F27^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H27+2)-SQRT((5*B10*H27)+4*H27^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J27+2)-SQRT((5*B10*J27)+4*J27^2)))","v":"N/A"}]

{"sheet":"Fv","index":6,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[2,1,2,10]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["LOCATION (County):",{"$f":"'C.A. RCN'!C3","v":"New Castle"}]
["FLOODING EVENT (Fv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2",null,"BMP 3",null,"BMP 4",null,"BMP 5"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},"Type:",{"$f":"RPv!E6","v":"--"},"Type:",{"$f":"RPv!G6","v":"--"},"Type:",{"$f":"RPv!I6","v":"--"},"Type:",{"$f":"RPv!K6","v":"--"},null,null,null,"Rainfall","100-YR"]
["Step 1 - Calculate Initial Fv","Data",null,"Data",null,"Data",null,"Data",null,"Data",null,null,null,null,"Kent",8.9]
["1.1  Total contributing area to BMP (ac)",{"$f":"RPv!B8","v":0},null,{"$f":"B8","v":0},null,{"$f":"D8","v":0},null,{"$f":"F8","v":0},null,{"$f":"H8","v":0},null,null,null,null,"New Castle",8]
["1.2  Initial RCN",{"$f":"RPv!B9","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Sussex",9.1999999999999993]
["1.3  100-Year Rainfall (in.)",{"$f":"VLOOKUP(B3,O7:P9,2)","v":8}]
["1.4  Fv runoff volume (in.)",{"$f":"IF(B10=0,\"XXXXXXXX\",(B10-0.2*((1000/B9)-10))^2/(B10+0.8*((1000/B9)-10)))","v":{"$error":"#DIV/0!"}}]
[]
["Step 2 - Adjust for Retention Reduction"]
["2.1  Storage volume (cu. ft.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(RPv!B16=0,0,RPv!B15))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(RPv!D16=0,0,RPv!D15))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(RPv!F16=0, 0,RPv!F15))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(RPv!H16=0, 0,RPv!H15))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(RPv!J16=0, 0,RPv!J15))","v":"N/A"}]
["2.2  Storage volume (ac-ft)",{"$f":"IF(C6=\"--\",\"N/A\",B14/43560)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",D14/43560)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",F14/43560)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",17/43560)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",J14/43560)","v":"N/A"}]
["2.3  Storage volume (in.)",{"$f":"IF(C6=\"--\",\"N/A\",(B15*12)/B8)","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",(D15*12)/D8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",(F15*12)/F8)","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",(H15*12)/H8)","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",(J15*12)/J8)","v":"N/A"}]
["2.4  Runoff volume after reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B11-B16<=0,0,B11-B16))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(B27-D16<=0,0,B27-D16))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(D27-F16<=0,0,D27-F16))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(F27-H16<=0,0,F27-H16))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(H27-J16<=0,0,H27-J16))","v":"N/A"}]
["2.5  CN*",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B17+2)-SQRT((5*B10*B17)+4*B17^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D17+2)-SQRT((5*B10*D17)+4*D17^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F17+2)-SQRT((5*B10*F17)+4*F17^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H17+2)-SQRT((5*B10*H17)+4*H17^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J17+2)-SQRT((5*B10*J17)+4*J17^2)))","v":"N/A"}]
[]
["Step 3 - Adjust for Annual Runoff Reduction"]
["3.1  Runoff reduction allowance (%)",{"$f":"IF(C6=\"--\",\"N/A\",VLOOKUP(C6,'Data & Documentation'!C1:R77,15,FALSE))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",VLOOKUP(E6,'Data & Documentation'!C1:R77,15,FALSE))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",VLOOKUP(G6,'Data & Documentation'!C1:R77,15,FALSE))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",VLOOKUP(I6,'Data & Documentation'!C1:R77,15,FALSE))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",VLOOKUP(K6,'Data & Documentation'!C1:R77,15,FALSE))","v":"N/A"}]
["3.2  Annual runoff after reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",B11*(1-B21))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",B27*(1-D21))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",D27*(1-F21))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",F27*(1-H21))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",H27*(1-J21))","v":"N/A"}]
["3.3  Adjusted ACN",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B22+2)-SQRT((5*B10*B22)+4*B22^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D22+2)-SQRT((5*B10*D22)+4*D22^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F22+2)-SQRT((5*B10*F22)+4*F22^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H22+2)-SQRT((5*B10*H22)+4*H22^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J22+2)-SQRT((5*B10*J22)+4*J22^2)))","v":"N/A"}]
["3.4  Event-based runoff reduction (in.)",{"$f":"IF(C6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/B23-10))^2/($B$10+0.8*(1000/B23-10)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/D23-10))^2/($B$10+0.8*(1000/D23-10)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/F23-10))^2/($B$10+0.8*(1000/F23-10)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/H23-10))^2/($B$10+0.8*(1000/H23-10)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",$B$11-($B$10-0.2*(1000/J23-10))^2/($B$10+0.8*(1000/J23-10)))","v":"N/A"}]
[]
["Step 4 - Calculate Fv with BMP Reductions"]
["4.1  Fv runoff volume after all reductions (in.)",{"$f":"IF(C6=\"--\",\"N/A\",IF($B$11-B16-B24<=0,0,$B$11-B16-B24))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF($B$11-D16-D24<=0,0,$B$11-D16-D24))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($B$11-F16-F24<=0,0,$B$11-F16-F24))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF($B$11-H16-H24<=0,0,$B$11-H16-H24))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF($B$11-J16-J24<=0,0,$B$11-J16-J24))","v":"N/A"}]
["4.2  Total Fv runoff reduction (%)",{"$f":"IF(C6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-B27)/B11<=0,0,(B11-B27)/B11)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-D27)/B11<=0,0,(B11-D27)/B11)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-F27)/B11<=0,0,(B11-F27)/B11)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-H27)/B11<=0,0,(B11-H27)/B11)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",IF(B11=0,1,IF((B11-J27)/B11<=0,0,(B11-J27)/B11)))","v":"N/A"}]
["4.3  Adjusted RCN for H&H modeling",{"$f":"IF(C6=\"--\",\"N/A\",200/((B10+2*B27+2)-SQRT((5*B10*B27)+4*B27^2)))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",200/((B10+2*D27+2)-SQRT((5*B10*D27)+4*D27^2)))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",200/((B10+2*F27+2)-SQRT((5*B10*F27)+4*F27^2)))","v":"N/A"},null,{"$f":"IF(I6=\"--\",\"N/A\",200/((B10+2*H27+2)-SQRT((5*B10*H27)+4*H27^2)))","v":"N/A"},null,{"$f":"IF(K6=\"--\",\"N/A\",200/((B10+2*J27+2)-SQRT((5*B10*J27)+4*J27^2)))","v":"N/A"}]

{"sheet":"DURMM Report","index":7,"n_rows":82,"n_cols":6,"rows_kept":82,"cut":false,"hidden":false,"merged":[[75,3,75,5],[40,3,40,5],[0,1,0,5],[1,1,1,5],[19,1,21,1],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,4,3,5],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5]]}
["PROJECT:",{"$f":"'C.A. RCN'!C1","v":0}]
["DRAINAGE SUBAREA ID:",{"$f":"'C.A. RCN'!C2","v":0}]
["COUNTY:",{"$f":"'C.A. RCN'!C3","v":"New Castle"},null,"UNIT HYDROGRAPH:",null,{"$f":"'C.A. RCN'!C4","v":0}]
["TMDL Watershed:",{"$f":"TMDL!B3","v":0},null,"VERSION:","DURMM v2.51.220414_50% ReDev"]
["DURMM OUTPUT WORKSHEET"]
["Site Data"]
["Contributing Area to BMPs (ac.)",{"$f":"'C.A. RCN'!K100","v":0}]
["C.A. RCN",{"$f":"'C.A. RCN'!K102","v":0}]
["Subarea LOD (ac.)",{"$f":"LOD!B19","v":0}]
["Subarea RCN",{"$f":"LOD!B20","v":0}]
["Upstream Subarea ID",{"$f":"IF(LOD!B25=\" \",\"N/A\",LOD!B25)","v":"N/A"},{"$f":"IF(LOD!C25=\" \",\"N/A\",LOD!C25)","v":"N/A"},{"$f":"IF(LOD!D25=\" \",\"N/A\",LOD!D25)","v":"N/A"},{"$f":"IF(LOD!E25=\" \",\"N/A\",LOD!E25)","v":"N/A"}]
["Upstream Subarea LOD (ac.)",{"$f":"LOD!B26","v":0},{"$f":"LOD!C26","v":0},{"$f":"LOD!D26","v":0},{"$f":"LOD!E26","v":0}]
["Combined LOD with Upstream Areas (ac.)",{"$f":"LOD!B34","v":0}]
["Combined RCN with Upstream Areas (ac.)",{"$f":"LOD!B35","v":{"$error":"#DIV/0!"}}]
["Watershed TMDL-TN (lb/ac/yr)",{"$f":"TMDL!C28","v":{"$error":"#N/A"}}]
["Watershed TMDL-TP (lb/ac/yr)",{"$f":"TMDL!D28","v":{"$error":"#N/A"}}]
["Watershed TMDL-TSS (lb/ac/yr)",{"$f":"TMDL!E28","v":{"$error":"#N/A"}}]
[]
["BMP Data","BMP 1","BMP 2","BMP 3","BMP 4","BMP 5"]
[null,{"$f":"RPv!C6","v":"--"},{"$f":"RPv!E6","v":"--"},{"$f":"RPv!G6","v":"--"},{"$f":"RPv!I6","v":"--"},{"$f":"RPv!K6","v":"--"}]
[]
[]
["RPv runoff volume after all reductions (in.)",{"$f":"RPv!B33","v":"N/A"},{"$f":"RPv!D33","v":"N/A"},{"$f":"RPv!F33","v":"N/A"},{"$f":"RPv!H33","v":"N/A"},{"$f":"RPv!J33","v":"N/A"}]
["Total RPv runoff reduction (in.)",{"$f":"RPv!B35","v":"N/A"},{"$f":"RPv!D35","v":"N/A"},{"$f":"RPv!F35","v":"N/A"},{"$f":"RPv!H35","v":"N/A"},{"$f":"RPv!J35","v":"N/A"}]
["Total RPv runoff reduction (%)",{"$f":"RPv!B36","v":"N/A"},{"$f":"RPv!D36","v":"N/A"},{"$f":"RPv!F36","v":"N/A"},{"$f":"RPv!H36","v":"N/A"},{"$f":"RPv!J36","v":"N/A"}]
["RPv Compliance Met Through Runoff Reduction?",{"$f":"RPv!B39","v":"N/A"},{"$f":"RPv!D39","v":"N/A"},{"$f":"RPv!F39","v":"N/A"},{"$f":"RPv!H39","v":"N/A"},{"$f":"RPv!J39","v":"N/A"}]
["RPv Residual Volume (cu. ft.)",{"$f":"RPv!B45","v":"N/A"},{"$f":"RPv!D45","v":"N/A"},{"$f":"RPv!F45","v":"N/A"},{"$f":"RPv!H45","v":"N/A"},{"$f":"RPv!J45","v":"N/A"}]
["Adjusted pollutant load, TN (lb/ac/yr)",{"$f":"TMDL!C25","v":"N/A"},{"$f":"TMDL!G25","v":"N/A"},{"$f":"TMDL!K25","v":"N/A"},{"$f":"TMDL!O25","v":"N/A"},{"$f":"TMDL!S25","v":"N/A"}]
["Adjusted pollutant load, TP (lb/ac/yr)",{"$f":"TMDL!D25","v":"N/A"},{"$f":"TMDL!H25","v":"N/A"},{"$f":"TMDL!L25","v":"N/A"},{"$f":"TMDL!P25","v":"N/A"},{"$f":"TMDL!T25","v":"N/A"}]
["Adjusted pollutant load, TSS (lb/ac/yr)",{"$f":"TMDL!E25","v":"N/A"},{"$f":"TMDL!I25","v":"N/A"},{"$f":"TMDL!M25","v":"N/A"},{"$f":"TMDL!Q25","v":"N/A"},{"$f":"TMDL!U25","v":"N/A"}]
["Cv runoff volume after all reductions (in.)",{"$f":"Cv!B27","v":"N/A"},{"$f":"Cv!D27","v":"N/A"},{"$f":"Cv!F27","v":"N/A"},{"$f":"Cv!H27","v":"N/A"},{"$f":"Cv!J27","v":"N/A"}]
["Fv runoff volume after all reductions (in.)",{"$f":"Fv!B27","v":"N/A"},{"$f":"Fv!D27","v":"N/A"},{"$f":"Fv!F27","v":"N/A"},{"$f":"Fv!H27","v":"N/A"},{"$f":"Fv!J27","v":"N/A"}]
[]
["Resource Protection Event (RPV)"]
["RPv for Contributing Area (in.)",{"$f":"RPv!B10","v":{"$error":"#DIV/0!"}}]
["Annual Runoff for Contributing Area (in.)",{"$f":"RPv!B24","v":{"$error":"#DIV/0!"}}]
["Req'd RPv to be Managed for Contributing Area (in.)",{"$f":"RPv!B11","v":{"$error":"#DIV/0!"}}]
["Req'd RPv to be Managed  for Contributing Area (%)",{"$f":"RPv!B12","v":{"$error":"#DIV/0!"}}]
["RPv Runoff Management Required (cu. Ft.)",{"$f":"B37/12*43560*B7","v":{"$error":"#DIV/0!"}}]
["RPv Runoff Management Provided (cu. Ft.)",{"$f":"MAX(RPv!B32,RPv!D32,RPv!F32,RPv!H32,RPv!J32)","v":0}]
["RPv Residual Volume (cu.ft.)",{"$f":"MIN(RPv!B45,RPv!D45,RPv!F45,RPv!H45,RPv!J45,RPv!B40,RPv!D40,RPv!F40,RPv!H40,RPv!J40)","v":0},{"$f":"IF(B41=0,\"\",IF(B41>0,\"SHORTFALL\",\"CREDIT\"))","v":""},{"$f":"IF(C41=\"SHORTFALL\",\" (Requires additional management or offset)\",\"\" )","v":""}]
["C.A. RPv avg. discharge rate (cfs)",{"$f":"MIN(RPv!B46,RPv!D46,RPv!F46,RPv!H46,RPv!J46)","v":0}]
["C.A. RPv max. discharge rate (cfs)",{"$f":"MIN(RPv!B47,RPv!D47,RPv!F47,RPv!H47,RPv!J47)","v":0}]
["TN Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!C30,TMDL!G30,TMDL!K30,TMDL!O30,TMDL!S30)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D30,TMDL!H30,TMDL!L30,TMDL!P30,TMDL!T30)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E30,TMDL!I30,TMDL!M30,TMDL!Q30,TMDL!U30)","v":0}]
[]
["Conveyance Event (Cv)"]
["Cv runoff volume (in.)",{"$f":"Cv!B11","v":{"$error":"#DIV/0!"}}]
["Adjusted RCN for H&H Modeling (CN*)",{"$f":"MIN(Cv!B29,Cv!D29,Cv!F29,Cv!H29,Cv!J29)","v":0}]
[]
["Flooding Event (Fv)"]
["Fv runoff volume (in.)",{"$f":"Fv!B11","v":{"$error":"#DIV/0!"}}]
["Equivalent RCN for H&H Modeling (CN*)",{"$f":"MIN(Fv!B29,Fv!D29,Fv!F29,Fv!H29,Fv!J29)","v":0}]
[]
["Adjusted Subarea Data for Downstream DURMM Modeling"]
["Subarea ID",{"$f":"B2","v":0}]
["Contributing Area (ac.)",{"$f":"'C.A. RCN'!K100","v":0}]
["Weighted Target Runoff (in.)",{"$f":"LOD!B37","v":{"$error":"#DIV/0!"}}]
["Adjusted CN after all reductions",{"$f":"MIN(RPv!B37,RPv!D37,RPv!F37,RPv!H37,RPv!J37)","v":{"$error":"#VALUE!"}}]
["Adjusted RPv (in.)",{"$f":"MIN(RPv!B33,RPv!D33,RPv!F33,RPv!H33,RPv!J33)","v":0}]
["Adjusted Cv (in.)",{"$f":"MIN(Cv!B27,Cv!D27,Cv!F27,Cv!H27,Cv!J27)","v":0}]
["Adjusted Fv (in.)",{"$f":"MIN(Fv!B27,Fv!D27,Fv!F27,Fv!H27,Fv!J27)","v":0}]
[]
["Adjusted Subarea Data for Nutrient Protocol Modeling"]
["Contributing Area (ac.)",{"$f":"'C.A. RCN'!K100","v":0}]
["LOD Area (ac.)",{"$f":"LOD!B34","v":0}]
["TN Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!C30,TMDL!G30,TMDL!K30,TMDL!O30,TMDL!S30)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D30,TMDL!H30,TMDL!L30,TMDL!P30,TMDL!T30)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E30,TMDL!I30,TMDL!M30,TMDL!Q30,TMDL!U30)","v":0}]
["Percent Impervious Cover",{"$f":"(LOD!B11*LOD!B7+LOD!C11*LOD!C7+LOD!D11*LOD!D7+LOD!E11*LOD!E7)/LOD!B19","v":{"$error":"#DIV/0!"}}]
[]
["Adjusted Subarea Data for the Summary Table for Sub-Areas Draining to a Common Point of Interest"]
["Subarea ID",{"$f":"B2","v":0}]
["Contributing Area (ac.)",{"$f":"'C.A. RCN'!K100","v":0}]
["RPv Residual Volume (cu.ft.)",{"$f":"MIN(RPv!B45,RPv!D45,RPv!F45,RPv!H45,RPv!J45,RPv!B40,RPv!D40,RPv!F40,RPv!H40,RPv!J40)","v":0},{"$f":"IF(B76=0,\"\",IF(B76>0,\"SHORTFALL\",\"CREDIT\"))","v":""},{"$f":"IF(C76=\"SHORTFALL\",\" (Requires additional management or offset)\",\"\" )","v":""}]
["Adjusted CN after all reductions",{"$f":"MIN(RPv!B37,RPv!D37,RPv!F37,RPv!H37,RPv!J37)","v":{"$error":"#VALUE!"}}]
["Cv RCN for H&H Modeling",{"$f":"MIN(Cv!B29,Cv!D29,Cv!F29,Cv!H29,Cv!J29)","v":0}]
["Fv RCN for H&H Modeling",{"$f":"MIN(Fv!B29,Fv!D29,Fv!F29,Fv!H29,Fv!J29)","v":0}]
["TN Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!C30,TMDL!G30,TMDL!K30,TMDL!O30,TMDL!S30)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D30,TMDL!H30,TMDL!L30,TMDL!P30,TMDL!T30)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E30,TMDL!I30,TMDL!M30,TMDL!Q30,TMDL!U30)","v":0}]

{"sheet":"Data & Documentation","index":8,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,16,0,17],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,10,0,11],[0,12,0,13],[0,14,0,15]]}
["Class","BMP Category","DURMM Variant","TN Reduction",null,"TP Reduction",null,"TSS Reduction",null,"Retention Allowance","Annual Runoff Reduction, RPv, A/B Soil",null,"Annual Runoff Reduction, RPv, C/D Soil",null,"Runoff Reduction, Cv",null,"Runoff Reduction, Fv"]
["No BMP","N/A","0-No BMP",0,null,0,null,0,null,0,0,null,0,null,0,null,0]
[]
["Retention Practice","1.0 Infiltration","1-A Infiltration Trench",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","1.0 Infiltration","1-B Infiltration Basin",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","1.0 Infiltration","1-C Underground Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
[]
["Retention Practice","2.0 Bioretention","2-A Traditional Bioretention - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-A Traditional Bioretention - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-B In-Situ Bioretention - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-B In-Situ Bioretention - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-C Streetscape Bioretention - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-C Streetscape Bioretention - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-D Engineered Tree Pits - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-D Engineered Tree Pits - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-E Stormwater Planters - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-E Stormwater Planters - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-F Advanced Bioretention - Underdrain",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","2.0 Bioretention","2-F Advanced Bioretention - Infiltration",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
[]
["Retention Practice","3.0 Permeable Pavement","3-A Porous Asphalt (PA)",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","3.0 Permeable Pavement","3-B Pervious Concrete (PC)",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","3.0 Permeable Pavement","3-C Permeable Concrete Pavers (PP) & (CP)",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","3.0 Permeable Pavement","3-D Plastic & Composite Grid Pavers (GP)",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",1,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
[]
["Annual Runoff Reduction Practice","4.0 Vegetated Roofs","4-A Extensive Vegetated Roofs",0,"of Load Reduction",0,"of Load Reduction",0,"of Load Reduction",0,0.5,"Annual RR",1.0000000000000001E-5,"Annual RR",0.05,"Runoff Reduction",0.01,"Runoff Reduction"]
["Annual Runoff Reduction Practice","4.0 Vegetated Roofs","4-B Intensive Vegetated Roofs",0,"of Load Reduction",0,"of Load Reduction",0,"of Load Reduction",0,0.75,"Annual RR",1.0000000000000001E-5,"Annual RR",0.08,"Runoff Reduction",0.02,"Runoff Reduction"]
[]
["Retention Practice","5.0 Rainwater Harvesting","5-A Seasonal Rainwater Harvesting",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0.5,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
["Retention Practice","5.0 Rainwater Harvesting","5-B Continuous Rainwater Harvesting",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0.75,0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage",0,"of Retention Storage"]
[]
["Annual Runoff Reduction Practice","6.0 Restoration Practices","6-A Step Pool RSCS",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","6.0 Restoration Practices","6-B Seepage Wetland RSCS",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","6.0 Restoration Practices","6-C Streambank Stabilization",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Annual Runoff Reduction Practice","7.0 Rooftop Disconnection","7-A Full Rooftop Disconnection - HSG A",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.96025000000000005,"Annual RR",0.96025000000000005,"Annual RR",9.1999999999999998E-2,"Runoff Reduction",8.9999999999999993E-3,"Runoff Reduction"]
["Annual Runoff Reduction Practice","7.0 Rooftop Disconnection","7-B Full Rooftop Disconnection - HSG B",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.80969999999999998,"Annual RR",0.80969999999999998,"Annual RR",7.3999999999999996E-2,"Runoff Reduction",7.0000000000000001E-3,"Runoff Reduction"]
["Annual Runoff Reduction Practice","7.0 Rooftop Disconnection","7-C Full Rooftop Disconnection - HSG C",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.62590000000000001,"Annual RR",0.62590000000000001,"Annual RR",5.8000000000000003E-2,"Runoff Reduction",6.0000000000000001E-3,"Runoff Reduction"]
["Annual Runoff Reduction Practice","7.0 Rooftop Disconnection","7-D Full Rooftop Disconnection - HSG D",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.50849999999999995,"Annual RR",0.50849999999999995,"Annual RR",4.8000000000000001E-2,"Runoff Reduction",4.7999999999999996E-3,"Runoff Reduction"]
[]
["Annual Runoff Reduction Practice","8.0 Vegetated Channels","8-A Bioswale",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.5,"Annual RR",0.25,"Annual RR",5.0000000000000001E-3,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","8.0 Vegetated Channels","8-B Grassed Channel",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.2,"Annual RR",0.1,"Annual RR",2E-3,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-A Sheet Flow to Grassed Filter Strip",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.25,"Annual RR",0.1,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-B Sheet Flow to Afforested Filter Strip",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.3,"Annual RR",0.15,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-C Sheet Flow to Forested Filter Strip",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.4,"Annual RR",0.2,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-D Sheet Flow to Grassed Open Space",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.5,"Annual RR",0.2,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-E Sheet Flow to Afforested Open Space",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.6,"Annual RR",0.3,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
["Annual Runoff Reduction Practice","9.0 Sheet Flow","9-F Sheet Flow to Forested Open Space",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.65,"Annual RR",0.4,"Annual RR",0.1,"of RPv Allowance",0.01,"of RPv Allowance"]
[]
["Stormwater Treatment Practice","10.0 Detention Practices","10-A Dry Detention Pond",0.05,"Removal Efficiency",0.1,"Removal Efficiency",0.1,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","10.0 Detention Practices","10-B Dry Extended Detention (ED) Basin",0.2,"Removal Efficiency",0.2,"Removal Efficiency",0.6,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0.01,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","10.0 Detention Practices","10-C Underground Detention Facilities",0.05,"Removal Efficiency",0.1,"Removal Efficiency",0.1,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","10.0 Detention Practices","10-D Underground 48-HR Detention Facilities",0.2,"Removal Efficiency",0.2,"Removal Efficiency",0.6,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0.01,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Stormwater Treatment Practice","11.0 Stormwater Filtering Systems","11-A Non-Structural Sand Filter",0.4,"Removal Efficiency",0.6,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","11.0 Stormwater Filtering Systems","11-B Surface Sand Filter",0.4,"Removal Efficiency",0.6,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","11.0 Stormwater Filtering Systems","11-C 3-Chamber Underground Sand Filter",0.4,"Removal Efficiency",0.6,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","11.0 Stormwater Filtering Systems","11-D Perimeter Sand Filter (DE Sand Filter)",0.4,"Removal Efficiency",0.6,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Stormwater Treatment Practice","12.0 Wetlands","12-A Traditional Constructed Wetlands",0.3,"Removal Efficiency",0.4,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0.01,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","12.0 Wetlands","12-B Wetland Swales",0.2,"Removal Efficiency (+ 100% of Load Reduction)",0.3,"Removal Efficiency (+ 100% of Load Reduction)",0.6,"Removal Efficiency (+ 100% of Load Reduction)",0,0.15,"Annual RR",0.1,"Annual RR",1.5E-3,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","12.0 Wetlands","12-C Ephemeral Constructed Wetlands",0.2,"Removal Efficiency (+ 100% of Load Reduction)",0.3,"Removal Efficiency (+ 100% of Load Reduction)",0.6,"Removal Efficiency (+ 100% of Load Reduction)",0,0.4,"Annual RR",0.1,"Annual RR",4.0000000000000001E-3,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","12.0 Wetlands","12-D Submerged Gravel Wetlands",0.3,"Removal Efficiency",0.4,"Removal Efficiency",0.8,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",1,"Runoff Reduction",1,"Runoff Reduction"]
[]
["Stormwater Treatment Practice","13.0 Wet Pond","13-A Wet Quantity Management Pond",0,"Removal Efficiency",0,"Removal Efficiency",0,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","13.0 Wet Pond","13-B Wet Extended Detention (ED) Pond",0.3,"Removal Efficiency",0.55000000000000004,"Removal Efficiency",0.6,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Annual Runoff Reduction Practice","14.0 Soil Amendments","14-A Compost Amended Soil - HSG A",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.47899999999999998,"Annual RR",0,"Annual RR",0.04,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","14.0 Soil Amendments","14-B Compost Amended Soil - HSG B",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.5,"Annual RR",0,"Annual RR",0.05,"Runoff Reduction",0.01,"Runoff Reduction"]
["Annual Runoff Reduction Practice","14.0 Soil Amendments","14-C Compost Amended Soil - HSG C",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0.28999999999999998,"Annual RR",0.03,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","14.0 Soil Amendments","14-D Compost Amended Soil - HSG D",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0.13,"Annual RR",0.01,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Stormwater Treatment Practice","15.0 Proprietary Practices","15-A Proprietary Practices",0,"Removal Efficiency",0,"Removal Efficiency",0,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Stormwater Treatment Practice","16.0 Source Controls","16-A Nutrient Management",0.17,"Removal Efficiency",0.22,"Removal Efficiency",0,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Stormwater Treatment Practice","16.0 Source Controls","16-B Street Sweeping",0.03,"Removal Efficiency",0.03,"Removal Efficiency",0.09,"Removal Efficiency",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
[]
["Annual Runoff Reduction Practice","17.0 Afforestation","17-AA Afforestation - HSG A",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0.60099999999999998,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]
["Annual Runoff Reduction Practice","17.0 Afforestation","17-AB Afforestation - HSG B",null,null,null,null,null,null,0,0.30399999999999999,"Annual RR",0,"Annual RR"]
["Annual Runoff Reduction Practice","17.0 Afforestation","17-AC Afforestation - HSG C",null,null,null,null,null,null,0,0,"Annual RR",0.17680000000000001,"Annual RR"]
["Annual Runoff Reduction Practice","17.0 Afforestation","17-AD Afforestation - HSG D",null,null,null,null,null,null,0,0,"Annual RR",0.12520000000000001,"Annual RR"]
["Annual Runoff Reduction Practice","17.0 Afforestation","17-B Urban Tree Planting",1,"of Load Reduction",1,"of Load Reduction",1,"of Load Reduction",0,0,"Annual RR",0,"Annual RR",0,"Runoff Reduction",0,"Runoff Reduction"]