{"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":31,"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":110,"n_cols":23,"rows_kept":110,"cut":false,"hidden":false,"merged":[[100,1,100,8],[6,2,7,2],[90,1,90,3],[102,2,102,8],[5,4,5,14],[0,2,0,14],[1,2,1,14],[2,2,2,14],[4,2,4,14],[5,0,5,1],[3,2,3,14]]}
[null,"PROJECT:"]
[null,"DRAINAGE SUBAREA ID:"]
[null,"LOCATION (County):"]
[null,"UNIT HYDROGRAPH:"]
[null,"PARCEL AREA (ACRES):"]
["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(E8>0,E8<10000),E8*F8,0)","v":0},"Acres","RCN",{"$f":"IF(AND(H8>0,H8<10000),H8*I8,0)","v":0},"Acres","RCN",{"$f":"IF(AND(K8>0,K8<10000),K8*L8,0)","v":0},"Acres","RCN",{"$f":"IF(AND(N8>0,N8<10000),N8*O8,0)","v":0}]
["CULTIVATED AGRICULTURAL LANDS   "]
["Fallow","              Bare soil","----",null,null,"77",{"$f":"ROUND(IF(AND(E10>0,E10<10000),E10*F10,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H10>0,H10<10000),H10*I10,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K10>0,K10<10000),K10*L10,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N10>0,N10<10000),N10*O10,0),2)","v":0},"-----------"]
[null,"              Crop residue (CR)","poor",null,null,"76",{"$f":"ROUND(IF(AND(E11>0,E11<10000),E11*F11,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H11>0,H11<10000),H11*I11,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K11>0,K11<10000),K11*L11,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N11>0,N11<10000),N11*O11,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(E45>0,E45<10000),E45*F45,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H45>0,H45<10000),H45*I45,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K45>0,K45<10000),K45*L45,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N45>0,N45<10000),N45*O45,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 (NCC Jurisdiction)"]
[null,"   Poor condition; grass cover < 50%",null,null,null,"68",{"$f":"ROUND(IF(AND(E62>0,E62<10000),E62*F62,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(H62>0,H62<10000),H62*I62,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(K62>0,K62<10000),K62*L62,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N62>0,N62<10000),N62*O62,0),2)","v":0},"-----------",null,null,null,null,null,"New Castle (Municipal, State or Federal Jurisdiction)"]
[null,"   Fair condition; grass cover 50% to 75 %",null,null,null,"49",{"$f":"ROUND(IF(AND(E63>0,E63<10000),E63*F63,0),2)","v":0},null,"69",{"$f":"ROUND(IF(AND(H63>0,H63<10000),H63*I63,0),2)","v":0},null,"79",{"$f":"ROUND(IF(AND(K63>0,K63<10000),K63*L63,0),2)","v":0},null,"84",{"$f":"ROUND(IF(AND(N63>0,N63<10000),N63*O63,0),2)","v":0},"-----------",null,null,null,null,null,"Kent"]
[null,"   Good condition; grass cover > 75%",null,null,null,"39",{"$f":"ROUND(IF(AND(E64>0,E64<10000),E64*F64,0),2)","v":0},null,"61",{"$f":"ROUND(IF(AND(H64>0,H64<10000),H64*I64,0),2)","v":0},null,"74",{"$f":"ROUND(IF(AND(K64>0,K64<10000),K64*L64,0),2)","v":0},null,"80",{"$f":"ROUND(IF(AND(N64>0,N64<10000),N64*O64,0),2)","v":0},"-----------",null,null,null,null,null,"Sussex"]
["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(E66>0,E66<10000),E66*F66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H66>0,H66<10000),H66*I66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K66>0,K66<10000),K66*L66,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N66>0,N66<10000),N66*O66,0),2)","v":0},"-----------",null,null,null,null,null,"Unit Hydrograph"]
[null,"  Streets and roads      ",null,null,null,"  ",null,null,null,null,null,null,null,null,"  "]
[null,"      Paved; curbs and storm sewers","",null,null,"98",{"$f":"ROUND(IF(AND(E68>0,E68<10000),E68*F68,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(H68>0,H68<10000),H68*I68,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(K68>0,K68<10000),K68*L68,0),2)","v":0},null,"98",{"$f":"ROUND(IF(AND(N68>0,N68<10000),N68*O68,0),2)","v":0},"-----------",null,null,null,null,null,"DMV"]
[null,"     Paved; open ditches (w/right-of-way)",null,null,null,"83",{"$f":"ROUND(IF(AND(E69>0,E69<10000),E69*F69,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(H69>0,H69<10000),H69*I69,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(K69>0,K69<10000),K69*L69,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N69>0,N69<10000),N69*O69,0),2)","v":0},"-----------",null,null,null,null,null,"STD"]
[null,"     Gravel (w/ right-of-way)",null,null,null,"76",{"$f":"ROUND(IF(AND(E70>0,E70<10000),E70*F70,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H70>0,H70<10000),H70*I70,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(K70>0,K70<10000),K70*L70,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(N70>0,N70<10000),N70*O70,0),2)","v":0},"-----------"]
[null,"     Dirt   (w/ right-of-way)",null,null,null,"72",{"$f":"ROUND(IF(AND(E71>0,E71<10000),E71*F71,0),2)","v":0},null,"82",{"$f":"ROUND(IF(AND(H71>0,H71<10000),H71*I71,0),2)","v":0},null,"87",{"$f":"ROUND(IF(AND(K71>0,K71<10000),K71*L71,0),2)","v":0},null,"89",{"$f":"ROUND(IF(AND(N71>0,N71<10000),N71*O71,0),2)","v":0},"-----------"]
["Urban Districts",null,"Avg % impervious"]
[null,"     Commercial & business","85",null,null,"89",{"$f":"ROUND(IF(AND(E73>0,E73<10000),E73*F73,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(H73>0,H73<10000),H73*I73,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(K73>0,K73<10000),K73*L73,0),2)","v":0},null,"95",{"$f":"ROUND(IF(AND(N73>0,N73<10000),N73*O73,0),2)","v":0},"-----------"]
[null,"     Industrial","72 ",null,null,"81",{"$f":"ROUND(IF(AND(E74>0,E74<10000),E74*F74,0),2)","v":0},null,"88",{"$f":"ROUND(IF(AND(H74>0,H74<10000),H74*I74,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K74>0,K74<10000),K74*L74,0),2)","v":0},null,"93",{"$f":"ROUND(IF(AND(N74>0,N74<10000),N74*O74,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(E76>0,E76<10000),E76*F76,0),2)","v":0},null,"85",{"$f":"ROUND(IF(AND(H76>0,H76<10000),H76*I76,0),2)","v":0},null,"90",{"$f":"ROUND(IF(AND(K76>0,K76<10000),K76*L76,0),2)","v":0},null,"92",{"$f":"ROUND(IF(AND(N76>0,N76<10000),N76*O76,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(E85>0,E85<10000),E85*F85,0),2)","v":0},null,"86",{"$f":"ROUND(IF(AND(H85>0,H85<10000),H85*I85,0),2)","v":0},null,"91",{"$f":"ROUND(IF(AND(K85>0,K85<10000),K85*L85,0),2)","v":0},null,"94",{"$f":"ROUND(IF(AND(N85>0,N85<10000),N85*O85,0),2)","v":0}]
[]
["USER DEFINED"]
[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,null,null,null,null,null,{"$f":"ROUND(IF(AND(E89>0,E89<10000),E89*F89,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(H89>0,H89<10000),H89*I89,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(K89>0,K89<10000),K89*L89,0),2)","v":0},null,null,{"$f":"ROUND(IF(AND(N89>0,N89<10000),N89*O89,0),2)","v":0},"-----------"]
[]
[null,"Subarea Contributing Area per Soil Type (ac)",null,null,{"$f":"ROUND(SUM(E10:E89),2)","v":0},null,null,{"$f":"ROUND(SUM(H10:H89),2)","v":0},null,null,{"$f":"ROUND(SUM(K10:K89),2)","v":0},null,null,{"$f":"ROUND(SUM(N10:N89),2)","v":0}]
[null,"Subarea Contributing Area (ac)",{"$f":"SUM(E91,H91,K91,N91)","v":0}]
[null,"Subarea Weighted RCN",{"$f":"IF($C$92=0,0,(SUM(G100:P100)/C92))","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(G10:G89)","v":0},null,null,{"$f":"SUM(J10:J89)","v":0},null,null,{"$f":"SUM(M10:M89)","v":0},null,null,{"$f":"SUM(P10:P89)","v":0}]
[null,"Total Contributing Area w. Upstream Areas (ac)  ",null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(E91:N91)+SUM(E96:E99)),2)","v":0}]
[]
[null,null,"Weighted Runoff Curve Number (RCN)",null,null,null,null,null,null,null,{"$f":"IF($K$101=0,0,(SUM(G100:P100)+E96*F96+E97*F97+E98*F98+E99*F99)/K101)","v":0}]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"LOD","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[19,1,19,4],[35,1,35,4],[21,1,21,4],[20,1,20,4],[22,1,22,4],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[39,1,39,4],[40,1,40,4],[38,1,38,4],[37,1,37,4],[34,1,34,4],[36,1,36,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":0}]
["UNIT HYDROGRAPH:",{"$f":"'C.A. RCN'!C4","v":0}]
["PARCEL AREA (ACRES)",{"$f":"'C.A. RCN'!C5","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(B8=0,0,B11/B8)","v":0},{"$f":"IF(C8=0,0,C11/C8)","v":0},0,0]
[]
["Step 2 - Subarea LOD Runoff Calculations"]
["2.1 RCN per HSG",{"$f":"IF(B8=0,0,((B11*98)+((B8-B11)*39))/B8)","v":0},{"$f":"IF(C8=0,0,((C11*98)+((C8-C11)*61))/C8)","v":0},{"$f":"IF(D8=0,0,((D11*98)+((D8-D11)*74))/D8)","v":0},{"$f":"IF(E8=0,0,((E11*98)+((E8-E11)*80))/E8)","v":0}]
["2.2 RPv per HSG (in.)",{"$f":"IF(B8=0,0,((2.7-(0.05*(1000/B15-10)))^2/(2.7+(0.95*(1000/B15-10)))))","v":0},{"$f":"IF(C8=0,0,((2.7-(0.05*(1000/C15-10)))^2/(2.7+(0.95*(1000/C15-10)))))","v":0},0,0]
["2.3 Target RCN per HSG",{"$f":"IF(AND($B$3=\"New Castle (NCC Jurisdiction)\",$B$5>3),IF(B8=0,0,IF(B10>0,((((B9*30)+(B10*0.5*98)+((B8-B9-(B10*0.5))*39)))/B8),((((B9*30)+((B8-B9)*39)))/B8))),IF(B8=0,0,IF(B10>0,((((B9*30)+(B10*0.85*98)+((B8-B9-(B10*0.85))*39)))/B8),((((B9*30)+((B8-B9)*39)))/B8))))","v":0},{"$f":"IF(AND($B$3=\"New Castle (NCC Jurisdiction)\",$B$5>3),IF(C8=0,0,IF(C10>0,((((C9*55)+(C10*0.5*98)+((C8-C9-(C10*0.5))*61)))/C8),((((C9*55)+((C8-C9)*61)))/C8))),IF(C8=0,0,IF(C10>0,((((C9*55)+(C10*0.85*98)+((C8-C9-(C10*0.85))*61)))/C8),((((C9*55)+((C8-C9)*61)))/C8))))","v":0},{"$f":"IF(AND($B$3=\"New Castle (NCC Jurisdiction)\",$B$5>3),IF(D8=0,0,IF(D10>0,((((D9*70)+(D10*0.5*98)+((D8-D9-(D10*0.5))*74)))/D8),((((D9*70)+((D8-D9)*74)))/D8))),IF(D8=0,0,IF(D10>0,((((D9*70)+(D10*0.85*98)+((D8-D9-(D10*0.85))*74)))/D8),((((D9*70)+((D8-D9)*74)))/D8))))","v":0},{"$f":"IF(AND($B$3=\"New Castle (NCC Jurisdiction)\",$B$5>3),IF(E8=0,0,IF(E10>0,((((E9*77)+(E10*0.5*98)+((E8-E9-(E10*0.5))*80)))/E8),((((E9*77)+((E8-E9)*80)))/E8))),IF(E8=0,0,IF(E10>0,((((E9*77)+(E10*0.85*98)+((E8-E9-(E10*0.85))*80)))/E8),((((E9*77)+((E8-E9)*80)))/E8))))","v":0}]
["2.4 Target Runoff per HSG (in.)",{"$f":"IF(B8=0,0,((2.7-(0.05*(1000/B17-10)))^2/(2.7+(0.95*(1000/B17-10)))))","v":0},{"$f":"IF(C8=0,0,((2.7-(0.05*(1000/C17-10)))^2/(2.7+(0.95*(1000/C17-10)))))","v":0},{"$f":"IF(D8=0,0,((2.7-(0.05*(1000/D17-10)))^2/(2.7+(0.95*(1000/D17-10)))))","v":0},{"$f":"IF(E8=0,0,((2.7-(0.05*(1000/E17-10)))^2/(2.7+(0.95*(1000/E17-10)))))","v":0}]
[]
["2.5 Subarea LOD (ac)",{"$f":"B8+C8+D8+E8","v":0}]
["2.6 Subarea Weighted RCN",{"$f":"IF(B20=0,0,((B8*B15)+(C8*C15)+(D8*D15)+(E8*E15))/B20)","v":0}]
["2.7 Subarea Weighted RPv (in.)",{"$f":"ROUND(IF(B20=0,0,(((2.7-(0.05*((1000/B21)-10)))^2)/(2.7+(0.95*((1000/B21)-10))))),3)","v":0}]
["2.8 Subarea Weighted Target Runoff (in.)",{"$f":"ROUND(IF(B20=0,0,(((2.7-(0.05*((1000/(((B8*B17)+(C8*C17)+(D8*D17)+(E8*E17))/B20))-10)))^2)/(2.7+(0.95*((1000/(((B8*B17)+(C8*C17)+(D8*D17)+(E8*E17))/B20))-10))))),3)","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"]
["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":"B20+B27+C27+D27+E27","v":0}]
["4.2 Weighted RCN",{"$f":"(B21*B20+B29*B27+C29*C27+D29*D27+E29*E27)/B35","v":{"$error":"#DIV/0!"}}]
["4.3 Weighted RPv (in.)",{"$f":"(B22*B20+B30*B27+C30*C27+D30*D27+E30*E27)/B35","v":{"$error":"#DIV/0!"}}]
["4.4 Weighted Target Runoff (in.)",{"$f":"(B23*B20+B28*B27+C28*C27+D28*D27+E28*E27)/B35","v":{"$error":"#DIV/0!"}}]
["4.5 Estimated Annual Runoff (in.)",{"$f":"0.000004*B36^3.5","v":{"$error":"#DIV/0!"}}]
["4.6 Req'd Runoff to be Managed within LOD (in.)",{"$f":"IF(B37-B38>1,1,B37-B38)","v":{"$error":"#DIV/0!"}}]
["4.7 Req'd Runoff to be Managed within LOD (%)",{"$f":"B40/B37","v":{"$error":"#DIV/0!"}}]

{"sheet":"OLOD ","index":2,"n_rows":113,"n_cols":22,"rows_kept":113,"cut":false,"hidden":false,"merged":[[4,0,5,0],[17,12,18,13],[4,13,4,15],[0,1,0,10],[1,1,1,10],[43,1,43,2],[2,1,2,10],[3,1,3,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":0}]
["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'!C92=LOD!B20,\"N/A\",'C.A. RCN'!C92)","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'!C92=LOD!B20,\"N/A\",'C.A. RCN'!C93)","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'!C92=LOD!B20,\"N/A\",LOD!B20)","v":"N/A"}]
["1.4 LOD RCN",{"$f":"IF('C.A. RCN'!C92=LOD!B20,\"N/A\",LOD!B21)","v":"N/A"}]
["1.5 Outside LOD Area (ac)",{"$f":"IF('C.A. RCN'!K101=LOD!B35,\"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":{"$error":"#N/A"}},{"$f":"VLOOKUP(B3,N7:P9,3)","v":{"$error":"#N/A"}},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":"#N/A"}},{"$f":"(C46-0.2*((1000/B13)-10))^2/(C46+0.8*((1000/B13)-10))","v":{"$error":"#N/A"}},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":93,"n_cols":15,"rows_kept":93,"cut":false,"hidden":false,"merged":[[51,0,54,4],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,1,4,2],[0,1,0,4],[1,1,1,4],[2,1,2,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":0}]
["RESOURCE PROTECTION EVENT (RPv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2"]
[null,"Type","--","Type","--",null,null,null,null,null,null,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'!K101","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'!K101>LOD!B35,'C.A. RCN'!K103,LOD!B36)","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'!K101=LOD!B35,LOD!B37,(IF(B8*(2.7-(0.05*(1000/B9-10)))^2/(2.7+(0.95*(1000/B9-10)))<(LOD!B35*LOD!B37),(LOD!B35*LOD!B37/B8),(2.7-(0.05*(1000/B9-10)))^2/(2.7+(0.95*(1000/B9-10)))))),3)","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!B40*LOD!B35)/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,{"$f":"IF(C6=\"12-D Submerged Gravel Wetlands\",\"Stone Void Only\",\" \")","v":" "},null,{"$f":"IF(E6=\"12-D Submerged Gravel Wetlands\",\"Stone Void Only\",\" \")","v":" "},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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,"2-C Streetscape Bioretention - Infiltration"]
["2.6  Adjusted CN*",{"$f":"IF(C6=\"--\",\"N/A\",1000/(((0.27+0.95*B19-SQRT(((0.27+0.95*B19)^2)-4*(0.0025*(7.29-2.7*B19))))/0.005)+10))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",1000/(((0.27+0.95*D19-SQRT(((0.27+0.95*D19)^2)-4*(0.0025*(7.29-2.7*D19))))/0.005)+10))","v":"N/A"},null,null,null,null,null,null,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\",34.8553*B27^0.285714)","v":"N/A"},null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,"2-F Advanced Bioretention - Underdrain"]
["3.3  Proportion A/B soils in BMP footprint (%)",0,null,0,null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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":"ROUND(IF(E6=\"--\",\"N/A\",$B$10-(2.7-(0.05*(1000/D28-10)))^2/(2.7+(0.95*(1000/D28-10)))),2)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,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"}]
["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$33-D18-D29))))","v":"N/A"},null,null,null,null,null,null,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\",B34+(IF(NOT(B50=\"N/A\"),B50,0)-MAX(D32,B32)))","v":"N/A"},null,null,null,null,null,null,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,null,null,null,null,null,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,0,IF(D35/$B$10<=0,0,D35/$B$10)))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,"5-A Seasonal Rainwater Harvesting"]
["4.6  Adjusted CN after all reductions*",{"$f":"MIN(B20,B28)","v":{"$error":"#VALUE!"}},null,{"$f":"MIN(D28,D20)","v":0},null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,"6-A Step Pool RSCS"]
["4.9  Runoff Reduction Extra 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,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,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(E6=\"--\",\"N/A\",IF(OR(B49=\"YES\",D39=\"YES\"),\"N/A\",$B$8*D44))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,"7-C Full Rooftop Disconnection - HSG C"]
["5.4 Max. Compliance Rate for ED (cfs)",{"$f":"IF(OR(C6=\"--\",NOT(OR((C6=\"10-B Dry Extended Detention (ED) Basin\"),(C6=\"10-D Underground 48-HR Detention Facilities\"),(C6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(B39=\"YES\",\"N/A\",((B34/172800)*5)))","v":"N/A"},null,{"$f":"IF(OR(E6=\"--\",NOT(OR((E6=\"10-B Dry Extended Detention (ED) Basin\"),(E6=\"10-D Underground 48-HR Detention Facilities\"),(E6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(D39=\"YES\",\"N/A\",((D34-D32)/172800)*5))","v":"N/A"}]
["5.5 Max. Extra Credit Rate for ED (cfs)",{"$f":"IF(OR(C6=\"--\",NOT(OR((C6=\"10-B Dry Extended Detention (ED) Basin\"),(C6=\"10-D Underground 48-HR Detention Facilities\"),(C6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(B39=\"YES\",\"N/A\",((5*(((LOD!B38)/12)*((LOD!B35*43560)/172800))))))","v":"N/A"},null,{"$f":"IF(OR(E6=\"--\",NOT(OR((E6=\"10-B Dry Extended Detention (ED) Basin\"),(E6=\"10-D Underground 48-HR Detention Facilities\"),(E6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(D39=\"YES\",\"N/A\",(D46-((5*(((LOD!B37-LOD!B38)/12)*((LOD!B35*43560)/172800)))))))","v":"N/A"}]
["5.6 Max. Design Discharge Rate for ED (cfs)"]
["5.7 RPv Compliance Met Through Extended Detention?",{"$f":"IF(C6=\"--\",\"N/A\",IF(OR(B50=\"N/A\",B48>B46),\"NO\",\"YES\"))","v":"N/A"},null,{"$f":"IF(E6=\"--\",\"N/A\",IF(OR(D50=\"N/A\",D48>D46),\"NO\",\"YES\"))","v":"N/A"}]
["5.8 Extended Detention Extra Credit, If Applicable (cu.ft)",{"$f":"IF(OR(C6=\"--\",NOT(OR((C6=\"10-B Dry Extended Detention (ED) Basin\"),(C6=\"10-D Underground 48-HR Detention Facilities\"),(C6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(B39=\"YES\",\"N/A\",(IF(AND(B48<=B47,B48<>0),(B45-(LOD!B37/12)*(LOD!B35*43560)),IF(AND(B48>B47,B48<B46),0,\"N/A\")))))","v":"N/A"},null,{"$f":"IF(OR(E6=\"--\",NOT(OR((E6=\"10-B Dry Extended Detention (ED) Basin\"),(E6=\"10-D Underground 48-HR Detention Facilities\"),(E6=\"13-B Wet Extended Detention (ED) Pond\")))),\"N/A\",IF(D39=\"YES\",\"N/A\",(IF(AND(D48<=D47,D48<>0),D45-D34,IF(AND(D48>D47,D48<D46),0,\"N/A\")))))","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,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 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,"8-B Grassed Channel"]
[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,"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":63,"n_cols":29,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,25,0,27],[4,1,4,4],[4,5,4,8],[4,9,4,12],[4,13,4,16],[2,1,2,8],[0,1,0,8],[1,1,1,8],[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]]}
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TMDL Reduction Requirements"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},null,null,"Type:",{"$f":"RPv!E6","v":"--"},null,null,null,null,null,null,null,null,null,null,null,null,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"]
["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.79,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,0.77,0.08,"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,"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\",C25)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",D25)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",E25)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,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\",C26)","v":"N/A"},{"$f":"IF($G$6=\"--\",\"N/A\",D26)","v":"N/A"},{"$f":"IF($G$6=\"--\",\"N/A\",E26)","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,"N/A","N/A","N/A"]
["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"}]
["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,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dragon Run Creek",10,5.3,0.28000000000000003,"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,"C&D Canal East",11,4.3,0.14000000000000001]
["3.4 Adjusted load from annual reductions (lb/ac/yr)",null,{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,C16,ROUND(C14*B21*0.000002205/$B$8,2)))","v":"N/A"},{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,D16,ROUND(D14*B21*0.000002205/$B$8,2)))","v":"N/A"},{"$f":"IF(B19=\"N/A\",\"N/A\",IF(B19=0,E16,ROUND(E14*B21*0.000002205/$B$8,2)))","v":"N/A"},null,{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,G16,ROUND(G14*F21*0.000002205/$B$8,2)))","v":"N/A"},{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,H16,ROUND(H14*F21*0.000002205/$B$8,2)))","v":"N/A"},{"$f":"IF(F19=\"N/A\",\"N/A\",IF(F19=0,I16,ROUND(I14*F21*0.000002205/$B$8,2)))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C&D Canal East (Outside TMDL)",11,"N/A","N/A","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appoquinimink River",12,6.4,0.83,"N/A"]
["3.6 BMP effluent concentration (mg/L)",null,{"$f":"IF(C24=\"N/A\",C14,C14*(1-C24))","v":"N/A"},{"$f":"IF(D24=\"N/A\",D14,D14*(1-D24))","v":"N/A"},"N/A",null,{"$f":"IF(G24=\"N/A\",G14,G14*(1-G24))","v":"N/A"},{"$f":"IF(H24=\"N/A\",H14,H14*(1-H24))","v":"N/A"},{"$f":"IF(I24=\"N/A\",I14,I14*(1-I24))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackbird Creek",13,3.2,0.36,"N/A"]
["3.7 Final Adjusted load (lb/ac/yr)",null,{"$f":"IF(C24=\"N/A\",C23,C23*(1-C24))","v":"N/A"},{"$f":"IF(D24=\"N/A\",D23,D23*(1-D24))","v":"N/A"},"N/A",null,{"$f":"IF(G24=\"N/A\",G23,ROUND(G23*(1-G24),2))","v":"N/A"},{"$f":"IF(H24=\"N/A\",H23,H23*(1-H24))","v":"N/A"},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delaware Bay",14,"N/A","N/A","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,"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:AC63,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B3,Y7:AC63,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B3,Y7:AC63,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$29>=C16,\"YES\",IF(C26<=$C$29,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF($D$29>=D16,\"YES\",IF(D26<=$D$29,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",IF($E$29=\"N/A\",\"N/A\",IF($E$29>=E16,\"YES\",IF(E26<=$E$29,\"YES\",\"NO\"))))","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",IF($C$29>=G16,\"YES\",IF(G26<=$C$29,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF($D$29>=H16,\"YES\",IF(H26<=$D$29,\"YES\",\"NO\")))","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",IF($E$29=\"N/A\",\"N/A\",IF($E$29>=I16,\"YES\",IF(I26<=$E$29,\"YES\",\"NO\"))))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,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\",C26*$B$8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",D26*$B$8)","v":"N/A"},{"$f":"IF(C6=\"--\",\"N/A\",E26*$B$8)","v":"N/A"},null,{"$f":"IF(G6=\"--\",\"N/A\",G26*$B$8)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",H26*$B$8)","v":"N/A"},{"$f":"IF(G6=\"--\",\"N/A\",I26*$B$8)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,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(C26-C29<=0,0,C26-C29)","v":{"$error":"#VALUE!"}},{"$f":"IF(D26-D29<=0,0,D26-D29)","v":{"$error":"#VALUE!"}},{"$f":"IF(E29=\"N/A\",0,IF(E26-E29<=0,0,E26-E29))","v":{"$error":"#N/A"}},null,{"$f":"IF(G26-G29<=0,0,G26-G29)","v":{"$error":"#VALUE!"}},{"$f":"IF(H26-H29<=0,0,H26-H29)","v":{"$error":"#VALUE!"}},{"$f":"IF(I29=\"N/A\",0,IF(I26-I29<=0,0,I26-I29))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(K26-K29<=0,0,K26-K29)","v":0},{"$f":"IF(L26-L29<=0,0,L26-L29)","v":0},{"$f":"IF(M29=\"N/A\",0,IF(M26-M29<=0,0,M26-M29))","v":0},null,{"$f":"IF(O26-O29<=0,0,O26-O29)","v":0},{"$f":"IF(P26-P29<=0,0,P26-P29)","v":0},{"$f":"IF(Q29=\"N/A\",0,IF(Q26-Q29<=0,0,Q26-Q29))","v":0},null,{"$f":"IF(S26-S29<=0,0,S26-S29)","v":0},{"$f":"IF(T26-T29<=0,0,T26-T29)","v":0},{"$f":"IF(U29=\"N/A\",0,IF(U26-U29<=0,0,U26-U29))","v":0},null,null,null,"Cedar Creek",21,6.4,0.25,"N/A"]
["5.2 TMDL Shortfall (%)",null,{"$f":"C34/C26","v":{"$error":"#VALUE!"}},{"$f":"D34/D26","v":{"$error":"#VALUE!"}},{"$f":"E34/E26","v":{"$error":"#N/A"}},null,{"$f":"G34/G26","v":{"$error":"#VALUE!"}},{"$f":"H34/H26","v":{"$error":"#VALUE!"}},{"$f":"I34/I26","v":{"$error":"#VALUE!"}},null,{"$f":"K34/K26","v":{"$error":"#DIV/0!"}},{"$f":"L34/L26","v":{"$error":"#DIV/0!"}},{"$f":"M34/M26","v":{"$error":"#DIV/0!"}},null,{"$f":"O34/O26","v":{"$error":"#DIV/0!"}},{"$f":"P34/P26","v":{"$error":"#DIV/0!"}},{"$f":"Q34/Q26","v":{"$error":"#DIV/0!"}},null,{"$f":"S34/S26","v":{"$error":"#DIV/0!"}},{"$f":"T34/T26","v":{"$error":"#DIV/0!"}},{"$f":"U34/U26","v":{"$error":"#DIV/0!"}},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":0},{"$f":"RPv!F33","v":0},{"$f":"RPv!F33","v":0},null,{"$f":"RPv!H33","v":0},{"$f":"RPv!H33","v":0},{"$f":"RPv!H33","v":0},null,{"$f":"RPv!J33","v":0},{"$f":"RPv!J33","v":0},{"$f":"RPv!J33","v":0}]
["5.4 Req'd Additional RR to meet TMDL (in)*",null,{"$f":"C35*C36","v":{"$error":"#VALUE!"}},{"$f":"D35*D36","v":{"$error":"#VALUE!"}},{"$f":"E35*E36","v":{"$error":"#N/A"}},null,{"$f":"G35*G36","v":{"$error":"#VALUE!"}},{"$f":"H35*H36","v":{"$error":"#VALUE!"}},{"$f":"I35*I36","v":{"$error":"#VALUE!"}},null,{"$f":"K35*K36","v":{"$error":"#DIV/0!"}},{"$f":"L35*L36","v":{"$error":"#DIV/0!"}},{"$f":"M35*M36","v":{"$error":"#DIV/0!"}},null,{"$f":"O35*O36","v":{"$error":"#DIV/0!"}},{"$f":"P35*P36","v":{"$error":"#DIV/0!"}},{"$f":"Q35*Q36","v":{"$error":"#DIV/0!"}},null,{"$f":"S35*S36","v":{"$error":"#DIV/0!"}},{"$f":"T35*T36","v":{"$error":"#DIV/0!"}},{"$f":"U35*U36","v":{"$error":"#DIV/0!"}},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":"C37*43560/12","v":{"$error":"#VALUE!"}},{"$f":"D37*43560/12","v":{"$error":"#VALUE!"}},{"$f":"E37*43560/12","v":{"$error":"#N/A"}},null,{"$f":"G37*43560/12","v":{"$error":"#VALUE!"}},{"$f":"H37*43560/12","v":{"$error":"#VALUE!"}},{"$f":"I37*43560/12","v":{"$error":"#VALUE!"}},null,{"$f":"K37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"L37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"M37*43560/12","v":{"$error":"#DIV/0!"}},null,{"$f":"O37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"P37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"Q37*43560/12","v":{"$error":"#DIV/0!"}},null,{"$f":"S37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"T37*43560/12","v":{"$error":"#DIV/0!"}},{"$f":"U37*43560/12","v":{"$error":"#DIV/0!"}},null,null,null,"Perch Creek",24,6.58,0.57999999999999996,129]
["5.6 Total Offset Volume (cu.ft.)",null,{"$f":"B8*C38","v":{"$error":"#VALUE!"}},{"$f":"B8*D38","v":{"$error":"#VALUE!"}},{"$f":"B8*E38","v":{"$error":"#N/A"}},null,{"$f":"B8*G38","v":{"$error":"#VALUE!"}},{"$f":"B8*H38","v":{"$error":"#VALUE!"}},{"$f":"B8*I38","v":{"$error":"#VALUE!"}},null,{"$f":"B8*K38","v":{"$error":"#DIV/0!"}},{"$f":"B8*L38","v":{"$error":"#DIV/0!"}},{"$f":"B8*M38","v":{"$error":"#DIV/0!"}},null,{"$f":"B8*O38","v":{"$error":"#DIV/0!"}},{"$f":"B8*P38","v":{"$error":"#DIV/0!"}},{"$f":"B8*Q38","v":{"$error":"#DIV/0!"}},null,{"$f":"B8*S38","v":{"$error":"#DIV/0!"}},{"$f":"B8*T38","v":{"$error":"#DIV/0!"}},{"$f":"B8*U38","v":{"$error":"#DIV/0!"}},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":[[4,5,4,6],[4,7,4,8],[4,9,4,10],[0,1,0,4],[1,1,1,4],[2,1,2,4],[4,1,4,2],[4,3,4,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":0}]
["CONVEYANCE EVENT (Cv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},"Type:",{"$f":"RPv!E6","v":"--"},null,null,null,null,null,null,null,null,null,"Rainfall","10-YR"]
["Step 1 - Calculate Initial Cv","Data",null,"Data",null,null,null,null,null,null,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,null,null,null,null,null,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":{"$error":"#N/A"}}]
["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":"#N/A"}}]
[]
["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"}]
["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"}]
["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"}]
["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"}]
["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"}]
[]
["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"}]
["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"}]
["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"}]
["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"}]
[]
["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"}]
["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"}]
["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"}]

{"sheet":"Fv","index":6,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,5,4,6],[4,7,4,8],[4,9,4,10],[0,1,0,4],[1,1,1,4],[2,1,2,4],[4,1,4,2],[4,3,4,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":0}]
["FLOODING EVENT (Fv) WORKSHEET"]
[null,"BMP 1",null,"BMP 2"]
[null,"Type:",{"$f":"RPv!C6","v":"--"},"Type:",{"$f":"RPv!E6","v":"--"},null,null,null,null,null,null,null,null,null,"Rainfall","100-YR"]
["Step 1 - Calculate Initial Fv","Data",null,"Data",null,null,null,null,null,null,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,null,null,null,null,null,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":{"$error":"#N/A"}}]
["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":"#N/A"}}]
[]
["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"}]
["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"}]
["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"}]
["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"}]
["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"}]
[]
["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"}]
["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"}]
["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"}]
["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"}]
[]
["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"}]
["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"}]
["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"}]

{"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":0},null,"UNIT HYDROGRAPH:",null,{"$f":"'C.A. RCN'!C4","v":0}]
["TMDL Watershed:",{"$f":"TMDL!B3","v":0},null,"VERSION:","DURMM v2.6.05012026"]
["DURMM OUTPUT WORKSHEET"]
["Site Data"]
["Contributing Area to BMPs (ac.)",{"$f":"'C.A. RCN'!K101","v":0}]
["C.A. RCN",{"$f":"'C.A. RCN'!K103","v":0}]
["Subarea LOD (ac.)",{"$f":"LOD!B20","v":0}]
["Subarea RCN",{"$f":"LOD!B21","v":0}]
["Upstream Subarea ID",{"$f":"IF(LOD!B26=\" \",\"N/A\",LOD!B26)","v":0},{"$f":"IF(LOD!C26=\" \",\"N/A\",LOD!C26)","v":0},{"$f":"IF(LOD!D26=\" \",\"N/A\",LOD!D26)","v":0},{"$f":"IF(LOD!E26=\" \",\"N/A\",LOD!E26)","v":0}]
["Upstream Subarea LOD (ac.)",{"$f":"LOD!B27","v":0},{"$f":"LOD!C27","v":0},{"$f":"LOD!D27","v":0},{"$f":"LOD!E27","v":0}]
["Combined LOD with Upstream Areas (ac.)",{"$f":"LOD!B35","v":0}]
["Combined RCN with Upstream Areas (ac.)",{"$f":"LOD!B36","v":{"$error":"#DIV/0!"}}]
["Watershed TMDL-TN (lb/ac/yr)",{"$f":"TMDL!C29","v":{"$error":"#N/A"}}]
["Watershed TMDL-TP (lb/ac/yr)",{"$f":"TMDL!D29","v":{"$error":"#N/A"}}]
["Watershed TMDL-TSS (lb/ac/yr)",{"$f":"TMDL!E29","v":{"$error":"#N/A"}}]
[]
["BMP Data","BMP 1","BMP 2"]
[null,{"$f":"RPv!C6","v":"--"},{"$f":"RPv!E6","v":"--"}]
[]
[]
["RPv runoff volume after all reductions (in.)",{"$f":"RPv!B33","v":"N/A"},{"$f":"RPv!D33","v":"N/A"}]
["Total RPv runoff reduction (in.)",{"$f":"RPv!B35","v":"N/A"},{"$f":"RPv!D35","v":"N/A"}]
["Total RPv runoff reduction (%)",{"$f":"RPv!B36","v":"N/A"},{"$f":"RPv!D36","v":"N/A"}]
["RPv Compliance Met Through Runoff Reduction?",{"$f":"IF(OR(RPv!B39=\"YES\",RPv!B49=\"YES\"),\"YES\",\"NO\")","v":"NO"},{"$f":"IF(OR(RPv!D39=\"YES\",RPv!D49=\"YES\"),\"YES\",\"NO\")","v":"NO"}]
["RPv Residual Volume (cu. ft.)",{"$f":"RPv!B45","v":"N/A"},{"$f":"RPv!D45","v":"N/A"}]
["Adjusted pollutant load, TN (lb/ac/yr)",{"$f":"TMDL!C26","v":"N/A"},{"$f":"TMDL!G26","v":"N/A"}]
["Adjusted pollutant load, TP (lb/ac/yr)",{"$f":"TMDL!D26","v":"N/A"},{"$f":"TMDL!H26","v":"N/A"}]
["Adjusted pollutant load, TSS (lb/ac/yr)",{"$f":"TMDL!E26","v":"N/A"},{"$f":"TMDL!I26","v":"N/A"}]
["Cv runoff volume after all reductions (in.)",{"$f":"Cv!B27","v":"N/A"},{"$f":"Cv!D27","v":"N/A"}]
["Fv runoff volume after all reductions (in.)",{"$f":"Fv!B27","v":"N/A"},{"$f":"Fv!D27","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,IF(NOT(RPv!B50=\"N/A\"),RPv!B45-RPv!B50,0),IF(NOT(RPv!D50=\"N/A\"),RPv!D45-RPv!D50,0))","v":0}]
["RPv Residual Volume (cu.ft.)",{"$f":"MIN(RPv!B45,RPv!D45,RPv!B40,RPv!D40,RPv!B50,RPv!D50)","v":0},{"$f":"IF(B41=0,\"\",IF(B41>0,\"SHORTFALL\",\"EXTRA CREDIT\"))","v":""},{"$f":"IF(C41=\"SHORTFALL\",\" (Requires additional management or offset)\",\"\" )","v":""}]
["Design RPv avg. discharge rate (cfs)",{"$f":"B43/5","v":0}]
["Design RPv max. discharge rate (cfs)",{"$f":"MAX(RPv!B48,RPv!D48,)","v":0}]
["TN Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!C31,TMDL!G31,TMDL!K31,TMDL!O31,TMDL!S31)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D31,TMDL!H31,TMDL!L31,TMDL!P31,TMDL!T31)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E31,TMDL!I31,TMDL!M31,TMDL!Q31,TMDL!U31)","v":0}]
[]
["Conveyance Event (Cv)"]
["Cv runoff volume (in.)",{"$f":"Cv!B11","v":{"$error":"#N/A"}}]
["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":"#N/A"}}]
["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'!K101","v":0}]
["Weighted Target Runoff (in.)",{"$f":"LOD!B38","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'!K101","v":0}]
["LOD Area (ac.)",{"$f":"LOD!B35","v":0}]
["TN Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!C31,TMDL!G31,TMDL!K31,TMDL!O31,TMDL!S31)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D31,TMDL!H31,TMDL!L31,TMDL!P31,TMDL!T31)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E31,TMDL!I31,TMDL!M31,TMDL!Q31,TMDL!U31)","v":0}]
["Percent Impervious Cover",{"$f":"(LOD!B12*LOD!B8+LOD!C12*LOD!C8+LOD!D12*LOD!D8+LOD!E12*LOD!E8)/LOD!B20","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'!K101","v":0}]
["RPv Residual Volume (cu.ft.)",{"$f":"MIN(RPv!B45,RPv!D45,RPv!F45,RPv!H45,RPv!J45,RPv!B40,RPv!D40,RPv!B50,RPv!D50)","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)","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!C31,TMDL!G31,TMDL!K31,TMDL!O31,TMDL!S31)","v":0}]
["TP Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!D31,TMDL!H31,TMDL!L31,TMDL!P31,TMDL!T31)","v":0}]
["TSS Pollutant Load (lb/yr)",{"$f":"MIN(TMDL!E31,TMDL!I31,TMDL!M31,TMDL!Q31,TMDL!U31)","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",4,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"]