{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["3.4.1","Reference"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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":"3.4.1","index":0,"n_rows":100,"n_cols":42,"rows_kept":100,"cut":false,"hidden":false,"merged":[[77,1,77,25],[78,1,78,25],[80,4,80,11],[80,14,80,17],[80,18,80,25],[72,22,72,25],[73,22,73,25],[74,22,74,25],[75,22,75,25],[73,6,73,21],[74,6,74,21],[75,6,75,21],[71,3,71,5],[71,6,71,7],[71,8,71,9],[71,10,71,12],[71,13,71,15],[71,16,71,18],[71,19,71,20],[71,21,71,23],[71,24,71,25],[22,2,22,15],[22,16,22,20],[22,21,22,25],[11,5,11,12],[51,3,51,22],[32,2,32,11],[32,12,32,13],[32,15,32,22],[1,1,1,25],[3,1,3,7],[3,8,3,9],[13,2,13,15],[13,16,13,20],[13,21,13,25],[5,1,5,3],[5,4,5,5],[2,1,2,25],[7,1,7,8],[7,9,7,10],[5,19,5,24],[11,2,11,4],[7,20,7,24],[9,2,9,25],[14,2,14,15],[14,16,14,20],[14,21,14,25],[15,2,15,15],[15,16,15,20],[15,21,15,25],[16,2,16,15],[16,16,16,20],[16,21,16,25],[19,2,19,15],[19,16,19,20],[19,21,19,25],[17,2,17,15],[17,16,17,20],[17,21,17,25],[21,2,21,15],[21,16,21,20],[21,21,21,25],[18,2,18,15],[18,16,18,20],[18,21,18,25],[20,2,20,15],[20,16,20,20],[20,21,20,25],[25,2,25,15],[25,16,25,20],[25,21,25,25],[23,2,23,15],[23,16,23,20],[23,21,23,25],[24,2,24,15],[24,16,24,20],[24,21,24,25],[28,2,28,15],[28,16,28,20],[28,21,28,25],[26,2,26,15],[26,16,26,20],[26,21,26,25],[27,2,27,15],[27,16,27,20],[27,21,27,25],[34,2,34,8],[34,9,34,14],[34,16,34,20],[34,21,34,22],[36,2,36,15],[36,16,36,20],[36,21,36,22],[30,2,30,25],[38,2,39,4],[38,5,39,8],[38,9,39,12],[38,13,39,17],[38,18,39,22],[34,24,34,25],[40,2,40,4],[40,5,40,8],[40,9,40,12],[40,13,40,17],[40,18,40,22],[41,2,41,4],[41,5,41,8],[41,9,41,12],[41,13,41,17],[41,18,41,22],[42,2,42,4],[42,5,42,8],[42,9,42,12],[42,13,42,17],[42,18,42,22],[43,2,43,4],[43,5,43,8],[43,9,43,12],[43,13,43,17],[43,18,43,22],[44,2,44,4],[44,5,44,8],[44,9,44,12],[44,13,44,17],[44,18,44,22],[45,2,45,4],[45,5,45,8],[45,9,45,12],[45,13,45,17],[45,18,45,22],[46,2,46,4],[46,5,46,8],[46,9,46,12],[46,13,46,17],[46,18,46,22],[47,2,47,4],[47,5,47,8],[47,9,47,12],[47,13,47,17],[47,18,47,22],[49,11,49,17],[49,18,49,22],[55,15,55,16],[55,2,55,14],[57,2,61,2],[57,3,61,5],[57,6,61,7],[57,8,61,9],[57,10,61,12],[57,13,61,15],[57,16,61,18],[57,19,61,20],[57,21,61,23],[57,24,61,25],[62,3,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,12],[62,13,62,15],[62,16,62,18],[62,19,62,20],[62,21,62,23],[62,24,62,25],[63,3,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,12],[63,13,63,15],[63,16,63,18],[63,19,63,20],[63,21,63,23],[63,24,63,25],[64,3,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,12],[64,13,64,15],[64,16,64,18],[64,19,64,20],[64,21,64,23],[64,24,64,25],[65,3,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,12],[65,13,65,15],[65,16,65,18],[65,19,65,20],[65,21,65,23],[65,24,65,25],[66,3,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,12],[66,13,66,15],[66,16,66,18],[66,19,66,20],[66,21,66,23],[66,24,66,25],[68,24,68,25],[68,3,68,5],[68,6,68,7],[68,8,68,9],[68,10,68,12],[68,13,68,15],[68,16,68,18],[68,19,68,20],[67,3,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,12],[67,13,67,15],[67,16,67,18],[55,24,55,25],[0,1,0,25],[70,3,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,12],[70,13,70,15],[70,16,70,18],[70,19,70,20],[70,21,70,23],[70,24,70,25],[69,3,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,12],[69,13,69,15],[69,16,69,18],[69,19,69,20],[69,21,69,23],[69,24,69,25],[67,19,67,20],[67,21,67,23],[67,24,67,25],[68,21,68,23]]}
[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,true,"No_SCMs","Variation_1","Source","Rows","Disconnection",null,"Temperature","Adjustment",true,1.2,true,"Infiltration_Methods","Impervious","HSG",1]
[null,"SCM 3.4.1  ",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,1,"None","NOAA Atlas 14",1,"Downspout Disconnection",null,30,1.7,false,1.3,false,"Double Ring Infiltrometer","Roof","A",2]
[null,"Disconnection of Impervious Surface with Filter Strip",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,2,"Trail Disconnection","Other",2,"Sheet Flow Disconnection",null,31,1.68,false,1.4,"N/A","Single Ring Infiltrometer","Roadway/Parking Lot","B",3]
[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,3,"Simple Downspout Disconnection",null,3,null,null,32,1.66,false,1.5,null,"Cased Borehole",null,"C",4]
[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,4,null,null,4,null,null,33,1.64,false,1.6,null,"Basin Flood Test",null,"D",5]
[null,"SCM ID:",null,null,null,null,null,null,null,null,null,"Type of Impervious Being Treated:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,5,null,null,34,1.62,false,1.7,null,"Other",null,null,6]
[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,null,null,6,null,null,35,1.6,false,1.8,null,null,null,null,7]
[null,"2-year/24-hour precipitation depth:",null,null,null,null,null,null,null,null,null,"in",null,null,"Chapter 102",null,null,null,null,null,"Runoff is Concentrated",null,null,null,null,null,null,{"$f":"IF(AJ2=TRUE,\"Variation_1\",\"Variation_2\")","v":"Variation_2"},null,null,7,null,null,36,1.58,null,1.9,null,null,null,null,8]
[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,null,null,8,null,null,37,1.56,null,2,null,null,null,null,9]
[null,null,"Design Standards",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,null,null,38,1.54,null,2.1,null,null,null,null,10]
[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,null,null,null,null,null,39,1.52,null,2.2000000000000002,null,null,null,null,11]
[null,null,"Variation:",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,null,null,40,1.5,null,2.2999999999999998,null,null,null,null,12]
[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,null,null,null,null,null,41,1.48,null,2.4,null,null,null,null,13]
[null,null,"Parameter",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard",null,null,null,null,"Design Value",null,null,null,null,null,"Deduction","Required?","Complete?",null,null,null,42,1.46,null,2.5,null,null,null,null,14]
[null,null,"Disconnected Impervious Width (perpendicular to flow) (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Y",{"$f":"IF(OR(AC15=\"\",AND(AC15=\"Y\",V15<>\"\")),\"Y\",\"\")","v":""},null,null,null,43,1.44,null,2.6,null,null,null,null,15]
[null,null,{"$f":"CONCATENATE(\"Disconnected Impervious Length (in direction of flow),\",IF(AJ2=TRUE,\" \",\" maximum\"),\" (ft)\")","v":"Disconnected Impervious Length (in direction of flow), maximum (ft)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ2=FALSE,100,\"-\")","v":100},null,null,null,null,null,null,null,null,null,null,0,"Y","",null,null,null,44,1.42,null,2.7,null,null,null,null,16]
[null,null,"Disconnected Impervious Area, maximum (SF)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F12<>\"Simple Downspout Disconnection\",2000,500)","v":2000},null,null,null,null,{"$f":"IF(AND(V15<>\"\",V16<>\"\"),V15*V16,\"\")","v":""},null,null,null,null,null,{"$f":"IF(V17<>\"\",IF(V17>(Q17*1.1),(V17-(Q17*1.1))/(Q17*1.1),0),0)","v":0},null,"Y",null,null,null,45,1.4,null,2.8,null,null,null,null,17]
[null,null,"Disconnected Impervious Slope, maximum (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ2=FALSE,0.1,\"-\")","v":0.1},null,null,null,null,null,null,null,null,null,{"$f":"V18","v":0},0,{"$f":"IF($F$12<>\"Simple Downspout Disconnection\",\"Y\",\"\")","v":"Y"},"",null,null,null,46,1.38,null,2.9,null,null,null,null,18]
[null,null,"Vegetated Filter Strip (VFS) Length (in direction of flow), minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V16<>\"\",V17<>\"\"),IF(F12<>\"Simple Downspout Disconnection\",IF(F12<>\"Trail Disconnection\",IF((V17*0.05)<20,20,V17*0.05),V16),20),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AJ2=FALSE,V17>500,V17<=1000),\"Y\",\"\")","v":""},{"$f":"IF(V19<>\"\",IF(V19<(Q19*0.9),((Q19*0.9)-V19)/(Q19*0.9),0),0)","v":0},"Y","",null,null,null,47,1.36,null,3,null,null,null,null,19]
[null,null,"A retentive grading berm with a minimum height of 6 inches will be placed along the width of the filter strip at approximately 100 feet downslope",null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V20<>\"\",IF(V20<>TRUE,0.5,0),0)","v":0},{"$f":"IF(V19>=100,\"Y\",\"\")","v":""},"Y",null,null,null,48,1.34,null,3.1,null,null,null,null,20]
[null,null,"VFS Width (perpendicular to flow), minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V15<>\"\",V16<>\"\"),IF(F12<>\"Simple Downspout Disconnection\",IF(AJ2=FALSE,V15,MAX(0.5*V16,0.025*V17)),10),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V19<>\"\",V21<>\"\"),V19*V21,\"\")","v":""},{"$f":"IF(V21<>\"\",IF(V21<(Q21*0.9),((Q21*0.9)-V21)/(Q21*0.9),0),0)","v":0},{"$f":"IF($F$12<>\"Simple Downspout Disconnection\",\"Y\",\"\")","v":"Y"},"",null,null,null,49,1.32,null,3.2,null,null,null,null,21]
[null,null,"VFS Average Slope (in any direction), maximum (%).",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,{"$f":"V22","v":0},0,"Y","",null,null,null,50,1.3,null,3.3,null,null,null,null,22]
[null,null,"Runoff velocity at 10-year/24-hour storm, maximum (fps)",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V23<>\"\",IF(V23>(Q23*1.1),(V23-(Q23*1.1))/(Q23*1.1),0),0)","v":0},{"$f":"IF(AA22>=0.06,\"Y\",\"\")","v":""},"Y",null,null,null,51,1.28,null,3.4,null,null,null,null,23]
[null,null,{"$f":"IF(F12<>\"Simple Downspout Disconnection\",IF(AJ2=TRUE,\"A level spreader will be installed to distribute concentrated flows\",\"A level spreader will be installed to maintain sheet flow conditions\"),\"A splash block or equivalent will be used to prevent erosion\")","v":"A level spreader will be installed to maintain sheet flow conditions"},null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V24<>\"\",IF(V24<>TRUE,1,0),\"\")","v":""},"Y","",null,null,null,52,1.26,null,3.5,null,null,null,null,24]
[null,null,"Level Spreader Width, minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V15<>\"\",V21<>\"\"),IF(AJ2=TRUE,V21,V15),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V25<>\"\",IF(V25<(Q25*0.9),((Q25*0.9)-V25)/(Q25*0.9),0),0)","v":0},{"$f":"IF($F$12<>\"Simple Downspout Disconnection\",\"Y\",\"\")","v":"Y"},"",null,null,null,53,1.24,null,3.6,null,null,null,null,25]
[null,null,"A gravel verge will be installed with a minimum 2-inch drop below impervious, width of 12 inches and depth of 24 inches",null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V26<>\"\",IF(V26<>TRUE,1,0),0)","v":0},{"$f":"IF(AJ2=FALSE,\"Y\",\"\")","v":"Y"},"",null,null,null,54,1.22,null,3.7,null,null,null,null,26]
[null,null,"The VFS will terminate prior to a surface water or stable conveyance to surface water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($F$12<>\"Simple Downspout Disconnection\",\"Y\",\"\")","v":"Y"},"",null,null,null,55,1.2,null,3.8,null,null,null,null,27]
[null,null,"The distance from impervious to a surface water or stable conveyance to surface water exceeds 100 feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(V27=TRUE,\"Y\",\"\")","v":""},"Y",null,null,null,56,1.18,null,3.9,null,null,null,null,28]
[null,null,"A retentive grading berm with a minimum height of 6 inches will be placed along the width of the filter strip at the terminus of the filter strip",null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V29<>\"\",IF(V29<>TRUE,0.5,0),0)","v":0},{"$f":"IF(V28=TRUE,\"Y\",\"\")","v":""},"Y",null,null,null,57,1.1599999999999999,null,4,null,null,null,null,29]
[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,{"$f":"IF(COUNTBLANK(AB15:AB29)=0,IF(SUM(AB15:AB29)+IF(AB52<>\"\",AB52,0)+IF(AA64<>\"\",AA64,0)>=1,1,SUM(AB15:AB29)+IF(AB52<>\"\",AB52,0)+IF(AA64<>\"\",AA64,0)),\"\")","v":""},null,{"$f":"IF(COUNTBLANK(AD15:AD29)=0,\"Y\",\"\")","v":""},null,null,null,58,1.1399999999999999,null,4.0999999999999996,null,null,null,null,30]
[null,null,"VFS Infiltration Rate",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,null,null,59,1.1200000000000001,null,4.2,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB34=1,IF(ROUND(#REF!/2000,0)<15,ROUND(#REF!/2000,0),15),\"\")","v":""},{"$f":"IF(OR(AB34=2,AB34=3,AB34=5),IF(ROUND(#REF!/1250,0)<20,ROUND(#REF!/1250,0),20),\"\")","v":""},{"$f":"IF(AB34=4,IF(ROUND(#REF!/5000,0)<3,ROUND(#REF!/5000,0),3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,60,1.1000000000000001,null,4.3,null,null,null,null,32]
[null,null,"Predominant HSG Soil Type in VFS Area:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M33<>\"\",IF(F12=\"Simple Downspout Disconnection\",IF(M33=\"D\",\"Infiltration testing is required\",\"\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M33<>\"\",IF(M33=\"A\",2,IF(M33=\"B\",3,IF(M33=\"C\",4,IF(M33=\"D\",5,)))),\"\")","v":""},null,null,null,null,null,61,1.08,null,4.4000000000000004,null,null,null,null,33]
[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,null,null,null,null,null,62,1.06,null,4.5,null,null,null,null,34]
[null,null,"Infiltration Test Method:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum No. Tests:",null,null,null,null,{"$f":"IF(AND(Y35<>\"\",J35<>\"\"),IF(J35=\"Double Ring Infiltrometer\",Y35,Y35*2),\"\")","v":""},null,null,{"$f":"IF(AA21<>\"\",IF(AA21<=1000,1,IF(AND(AA21>1000,AA21<=2000),2,IF(AND(AA21>2000,AA21<=3000),3,IF(AND(AA21>3000,AA21<=4000),4,IF(AND(AA21>4000,AA21<=5000),5,IF(AA21>5000,6)))))),\"\")","v":""},null,null,null,{"$f":"IF(ISNUMBER(V22),1,0)","v":0},null,null,null,null,63,1.04,null,4.5999999999999996,null,null,null,null,35]
[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,{"$f":"IF(ISNONTEXT(V24),1,0)","v":1},null,null,null,null,64,1.02,null,4.7,null,null,null,null,36]
[null,null,"Saturated Hydraulic Conductivity (Ksat) Results for SCM:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual No. Tests:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNONTEXT(V25),1,0)","v":1},null,null,null,null,65,1,null,4.8,null,null,null,null,37]
[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,1,null,null,null,null,66,0.98660000000000003,null,4.9000000000000004,null,null,null,null,38]
[null,null,"Test No.",null,null,"Field Ksat Result (in/hr)",null,null,null,"Air Temp During Test (°F)",null,null,null,"Temp-Adjusted Ksat (in/hr)",null,null,null,null,"Ksat for Geomean (in/hr)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.97320000000000007,null,5,null,null,null,null,39]
[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,null,null,null,null,null,68,0.91,null,5.0999999999999996,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F41<>\"\",J41<>\"\"),F41*VLOOKUP(J41,$AH$2:$AI$73,2,FALSE),\"\")","v":""},null,null,null,null,{"$f":"IF(N41<>\"\",IF(F41<>0,N41,0.1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,0.9,null,5.2,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(N42<>\"\",IF(F42<>0,N42,0.1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,0.89,null,5.3,null,null,null,null,42]
[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,null,null,null,71,0.88,null,5.4,null,null,null,null,43]
[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,null,null,null,72,0.86799999999999999,null,5.5,null,null,null,null,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,null,null,null,null,null,null,null,73,0.85599999999999998,null,5.6,null,null,null,null,45]
[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,null,null,null,74,0.84399999999999997,null,5.7,null,null,null,null,46]
[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,null,null,null,75,0.83199999999999996,null,5.8,null,null,null,null,47]
[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,null,null,null,76,0.82,null,5.9,null,null,null,null,48]
[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,null,null,null,null,null,77,0.81199999999999994,null,6,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,"Geometric Mean (in/hr):",null,null,null,null,null,null,{"$f":"IF(SUM(S41:S48)>0,GEOMEAN(S41:S48),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,0.80400000000000005,null,null,null,null,null,null,50]
[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,null,null,null,null,null,79,0.79600000000000004,null,null,null,null,null,null,51]
[null,null,null,"Soils in the Vegetated Filter Strip area will be amended and/or restored to meet a minimum Ksat of 0.5 in/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S50<0.5,AJ5=FALSE),1,0)","v":0},null,null,null,null,null,80,0.78800000000000003,null,null,null,null,null,null,52]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,"Volume Management Credit",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,null,null,81,0.78,null,null,null,null,null,null,54]
[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,null,null,null,null,null,82,0.77,null,null,null,null,null,null,55]
[null,null,"Simple Downspout Disconnection Credit (0.3 in / SF roof):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F12=\"Simple Downspout Disconnection\",V17<>\"\"),V17*0.025,\"\")","v":""},null,null,"No. similar disconnections:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,0.76,null,null,null,null,null,null,56]
[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,"No. Rows:",null,null,null,null,null,84,0.75,null,null,null,null,null,null,57]
[null,null,"No.","Land Cover",null,null,"Length (ft)",null,"Width (ft)",null,"Direct Precipitation (in)",null,null,"Runoff as Precipitation (in)",null,null,"Runoff + Direct Precipitation (in)",null,null,"Area Weighting",null,"Runoff Depth per Unit Area (in)",null,null,"Total Runoff Depth (in)",null,null,{"$f":"IF(V19<>\"\",ROUNDUP(V19/20,0)+1,\"\")","v":""},null,null,null,null,null,85,0.74,null,null,null,null,null,null,58]
[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,"No. Strips:",null,null,null,null,null,86,0.73,null,null,null,null,null,null,59]
[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,{"$f":"IF(V19<>\"\",ROUNDUP(V19/20,0),\"\")","v":""},null,null,null,null,null,87,0.72199999999999998,null,null,null,null,null,null,60]
[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,null,null,null,null,null,88,0.71399999999999997,null,null,null,null,null,null,61]
[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,null,"VFS Runoff",null,null,null,89,0.70599999999999996,null,null,null,null,null,null,62]
[null,null,1,"Impervious",null,null,{"$f":"IF(V16<>\"\",V16,\"\")","v":""},null,{"$f":"IF(V15<>\"\",V15,\"\")","v":""},null,{"$f":"IF(J8<>\"\",J8,\"\")","v":""},null,null,0,null,null,{"$f":"IF(AND(K63<>\"\",N63<>\"\"),K63+N63,\"\")","v":""},null,null,{"$f":"IF(AND(G63<>\"\",I63<>\"\",G64<>\"\",I64<>\"\"),(G63*I63)/(G64*I64),\"\")","v":""},null,{"$f":"IF(K63<>\"\",(K63-0.04)^2/(K63+0.16),\"\")","v":""},null,null,{"$f":"IF(AND(T63<>\"\",V63<>\"\"),T63*V63,\"\")","v":""},null,null,"CN","Final Depth (in)",{"$f":"IF(AND(D63<>\"\",$J$8<>\"\",G63<>\"\",I63<>\"\"),(($J$8-(0.2*((1000/98)-10)))^2/($J$8+(0.8*((1000/98)-10)))/12)*G63*I63,\"\")","v":""},null,null,null,90,0.69799999999999995,null,null,null,null,null,null,63]
[null,null,2,null,null,null,{"$f":"IF(V19<>\"\",IF(V19>=20,20,\"\"),\"\")","v":""},null,{"$f":"IF(AB60>1,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF(V21<>\"\",V21,\"\")),\"\")","v":""},null,{"$f":"IF(AND(G64<>\"\",I64<>\"\"),IF($J$8<>\"\",$J$8,\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(G64<>\"\",I64<>\"\"),IF(Y63<>\"\",Y63,\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(K64<>\"\",N64<>\"\"),K64+N64,\"\")","v":""},null,null,{"$f":"IF(AND(G64<>\"\",I64<>\"\"),1,\"\")","v":""},null,{"$f":"IF(AND(D64<>\"\",Q64<>\"\",AB64<>\"\"),(Q64-(0.2*((1000/AB64)-10)))^2/(Q64+(0.8*((1000/AB64)-10))),\"\")","v":""},null,null,{"$f":"IF(AND(T64<>\"\",V64<>\"\"),T64*V64,\"\")","v":""},null,{"$f":"IF(D64=\"Woods\",0.25,0)","v":0},{"$f":"IF(AND($M$33<>\"\",D64<>\"\"),VLOOKUP(D64,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},{"$f":"IF(SUM(Y63:Y72)>0,LOOKUP(2,1/(Y63:Y72<>\"\"),Y63:Y72),\"\")","v":""},{"$f":"IF(AND(D64<>\"\",$J$8<>\"\",G64<>\"\",I64<>\"\"),(($J$8-(0.2*((1000/AB64)-10)))^2/($J$8+(0.8*((1000/AB64)-10)))/12)*G64*I64,\"\")","v":""},null,null,null,91,0.69,null,null,null,null,null,null,64]
[null,null,3,null,null,null,{"$f":"IF(G64<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G64)<>0,IF($V$19>=40,20,$V$19-20),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>1,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,{"$f":"IF(AND(G65<>\"\",I65<>\"\"),IF($J$8<>\"\",$J$8,\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(G65<>\"\",I65<>\"\"),IF(Y64<>\"\",Y64,\"\"),\"\")","v":""},null,null,"",null,null,{"$f":"IF(AND(G65<>\"\",I65<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G65*I65)/(G64*I64),1),\"\")","v":""},null,{"$f":"IF(AND(D65<>\"\",Q65<>\"\",AB65<>\"\"),(Q65-(0.2*((1000/AB65)-10)))^2/(Q65+(0.8*((1000/AB65)-10))),\"\")","v":""},null,null,{"$f":"IF(AND(T65<>\"\",V65<>\"\"),T65*V65,\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D65<>\"\"),VLOOKUP(D65,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},"Final Runoff (CF)",{"$f":"IF(AND(D65<>\"\",$J$8<>\"\",G65<>\"\",I65<>\"\"),(($J$8-(0.2*((1000/AB65)-10)))^2/($J$8+(0.8*((1000/AB65)-10)))/12)*G65*I65,\"\")","v":""},null,null,null,92,0.68199999999999994,null,null,null,null,null,null,65]
[null,null,4,null,null,null,{"$f":"IF(G65<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G65)<>0,IF($V$19>=60,20,IF(G65<20,\"\",$V$19-40)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>2,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G66<>\"\",I66<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G66*I66)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T66<>\"\",V66<>\"\"),T66*V66,\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D66<>\"\"),VLOOKUP(D66,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},{"$f":"IF(AC64<>\"\",(AC64/12)*_xlfn.XLOOKUP(AC64,Y63:Y72,G63:G72)*_xlfn.XLOOKUP(AC64,Y63:Y72,I63:I72),\"\")","v":""},"",null,null,null,93,0.67400000000000004,null,null,null,null,null,null,66]
[null,null,5,null,null,null,{"$f":"IF(G66<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G66)<>0,IF($V$19>=80,20,IF(G66<20,\"\",$V$19-60)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>3,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G67<>\"\",I67<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G67*I67)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T67<>\"\",V67<>\"\"),T67*V67,\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D67<>\"\"),VLOOKUP(D67,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,94,0.66600000000000004,null,null,null,null,null,null,67]
[null,null,6,null,null,null,{"$f":"IF(G67<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G67)<>0,IF($V$19>=100,20,IF(G67<20,\"\",$V$19-80)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>4,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G68<>\"\",I68<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G68*I68)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T68<>\"\",V68<>\"\"),T68*V68,\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D68<>\"\"),VLOOKUP(D68,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,95,0.65800000000000003,null,null,null,null,null,null,68]
[null,null,7,null,null,null,{"$f":"IF(G68<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G68)<>0,IF($V$19>=120,20,IF(G68<20,\"\",$V$19-100)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>5,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G69<>\"\",I69<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G69*I69)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T69<>\"\",V69<>\"\"),T69*V69*IF(D69=\"Open Space\",1.1,1),\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D69<>\"\"),VLOOKUP(D69,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,96,0.65,null,null,null,null,null,null,69]
[null,null,8,null,null,null,{"$f":"IF(G69<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G69)<>0,IF($V$19>=140,20,IF(G69<20,\"\",$V$19-120)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>6,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G70<>\"\",I70<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G70*I70)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T70<>\"\",V70<>\"\"),T70*V70*IF(D70=\"Open Space\",1.1,1),\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D70<>\"\"),VLOOKUP(D70,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,97,0.64200000000000002,null,null,null,null,null,null,70]
[null,null,9,null,null,null,{"$f":"IF(G70<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G70)<>0,IF($V$19>=160,20,IF(G70<20,\"\",$V$19-140)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>7,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,"",null,null,"",null,null,{"$f":"IF(AND(G71<>\"\",I71<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G71*I71)/(G64*I64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T71<>\"\",V71<>\"\"),T71*V71*IF(D71=\"Open Space\",1.1,1),\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D71<>\"\"),VLOOKUP(D71,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,98,0.63400000000000001,null,null,null,null,null,null,71]
[null,null,10,null,null,null,{"$f":"IF(G71<>\"\",IF($V$19<>\"\",IF(V19-SUM(G64:G71)<>0,IF($V$19>=180,20,IF(G71<20,\"\",$V$19-160)),\"\"),\"\"),\"\")","v":""},null,{"$f":"IF($AB$60>8,IF(AND(V24=TRUE,AJ2=TRUE,V25<>\"\"),V25,IF($V$21<>\"\",$V$21,\"\")),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(G72<>\"\",I72<>\"\"),IF(Y71<>\"\",Y71,\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(K72<>\"\",N72<>\"\"),K72+N72,\"\")","v":""},null,null,{"$f":"IF(AND(G72<>\"\",I72<>\"\"),IF(AND(G64<>\"\",I64<>\"\"),(G72*I72)/(I64*G64),1),\"\")","v":""},null,"",null,null,{"$f":"IF(AND(T72<>\"\",V72<>\"\"),T72*V72*IF(D72=\"Open Space\",1.1,1),\"\")","v":""},null,null,{"$f":"IF(AND($M$33<>\"\",D72<>\"\"),VLOOKUP(D72,Reference!$J$1:$N$4,$AB$33,FALSE),\"\")","v":""},null,"",null,null,null,99,0.626,null,null,null,null,null,null,72]
[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,null,{"$f":"IF(SUM(AD63:AD72)>0,SUM(AD63:AD72),\"\")","v":""},null,null,null,100,0.61799999999999999,null,null,null,null,null,null,73]
[null,null,null,null,null,null,"Volume Management Disconnection Credit (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD30=\"Y\",IF(AB74<>3,IF(AND(F12<>\"Simple Downspout Disconnection\",AD73<>\"\"),AD73,0)-IF(AND(F12<>\"Simple Downspout Disconnection\",AC66<>\"\"),AC66,0)+IF(P56<>\"\",P56*IF(Y56<>\"\",Y56,1),0),0),\"\")","v":""},null,null,null,null,{"$f":"IF(AND(AC66=\"\",F12=\"Simple Downspout Disconnection\"),1,IF(AND(AD73<>\"\",AC66<>\"\",F12<>\"Simple Downspout Disconnection\",AD73>=AC66),2,IF(AND(AD73<>\"\",AC66<>\"\",F12<>\"Simple Downspout Disconnection\",AC66>AD73),3)))","v":false},null,null,null,null,null,101,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,"Deductions (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD30<>\"\",IF(AND(AB30<>\"\",W74<>\"\"),W74*AB30,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,102,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,"Final Volume Management Disconnection Credit (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W74<>\"\",W75<>\"\"),W74-W75,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,103,null,null,null,null,null,null,null,76]
[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,null,null,null,null,null,104,null,null,null,null,null,null,null,77]
[null,"CERTIFICATION",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,null,null,null,null,null,null,null,null,null,null,null,78]
[null,"I certify under penalty of law and subject to the penalties of 18 Pa.C.S. § 4904 (relating to unsworn falsification to authorities) that this document and all attachments were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gathered and evaluated the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete.  I further certify that the structure, function, and calculations contained in this spreadsheet have not been modified in comparison to the spreadsheet DEP has posted to its website.",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,null,null,null,null,null,null,null,null,null,null,null,79]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,"User Name:",null,null,null,null,null,null,null,null,null,null,null,null,"User Company:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,null,null,null,null,null,null,null,81]
[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,null,null,null,null,null,109,null,null,null,null,null,null,null,82]
[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,null,null,null,null,null,110,null,null,null,null,null,null,null,83]
[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,null,null,null,null,null,111,null,null,null,null,null,null,null,84]
[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,null,null,null,null,null,112,null,null,null,null,null,null,null,85]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,100]

{"sheet":"Reference","index":1,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Land_Cover","A","B","C","D","IMP?","Soils","CN",null,"VFS_Cover","A","B","C","D"]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Poor Condition (Grass Cover < 50%)",68,79,86,89,null,"A",40,null,"Meadow",30,58,71,78]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Fair Condition (Grass Cover 50% to 75%)",49,69,79,84,null,"B",41,null,"Woods",30,55,70,77]
["Open Space (Lawns, Parks, Golf Courses, Cemeteries, Etc.) - Good Condition (Grass Cover > 75%)",39,61,74,80,null,"C",42,null,"Open Space",39,61,74,80]
["Impervious Areas: Paved Parking Lots, Roofs, Driveways, Etc. (Excluding ROW)",98,98,98,98,"Y","D",43]
["Impervious Areas: Streets and Roads - Paved; Curbs and Storm Sewers (Excluding ROW)",98,98,98,98,"Y","N/A",44]
["Impervious Areas: Streets and Roads - Paved; Open Ditches (Including ROW)",83,89,92,93,"Y",null,45]
["Impervious Areas: Streets and Roads - Gravel (Including ROW)",76,85,89,91,"Y",null,46]
["Impervious Areas: Streets and Roads - Dirt (Including ROW)",72,82,87,89,"Y",null,47]
["Impervious Areas: Commercial",98,98,98,98,"Y",null,48]
["Impervious Areas: Industrial",98,98,98,98,"Y",null,49]
["Impervious Areas: Institutional ",98,98,98,98,"Y",null,50]
["Fallow - Bare Soil",77,86,91,94,null,null,51]
["Fallow - Crop Residue Cover (Poor Condition)",76,85,90,93,null,null,52]
["Fallow - Crop Residue Cover (Good Condition)",74,83,88,90,null,null,53]
["Row Crops - Straight Row (Poor Condition)",72,81,88,91,null,null,54]
["Row Crops - Straight Row (Good Condition)",67,78,85,89,null,null,55]
["Row Crops - Straight Row & Crop Residue (Poor Condition)",71,80,87,90,null,null,56]
["Row Crops - Straight Row & Crop Residue (Good Condition)",64,75,82,85,null,null,57]
["Row Crops - Contoured (Poor Condition)",70,79,84,88,null,null,58]
["Row Crops - Contoured (Good Condition)",65,75,82,86,null,null,59]
["Row Crops - Contoured & Crop Residue (Poor Condition)",69,78,83,87,null,null,60]
["Row Crops - Contoured & Crop Residue (Good Condition)",64,74,81,85,null,null,61]
["Row Crops - Contoured & Terraced (Poor Condition)",66,74,80,82,null,null,62]
["Row Crops - Contoured & Terraced (Good Condition)",62,71,78,81,null,null,63]
["Row Crops - Contoured, Terraced & Crop Residue (Poor Condition)",65,73,79,81,null,null,64]
["Row Crops - Contoured, Terraced & Crop Residue (Good Condition)",61,70,77,80,null,null,65]
["Small Grain - Straight Row (Poor Condition)",65,76,84,88,null,null,66]
["Small Grain - Straight Row (Good Condition)",63,75,83,87,null,null,67]
["Small Grain - Straight Row & Crop Residue (Poor Condition)",64,75,83,86,null,null,68]
["Small Grain - Straight Row & Crop Residue (Good Condition)",60,72,80,84,null,null,69]
["Small Grain - Contoured (Poor Condition)",63,74,82,85,null,null,70]
["Small Grain - Contoured (Good Condition)",61,73,81,84,null,null,71]
["Small Grain - Contoured & Crop Residue (Poor Condition)",62,73,81,84,null,null,72]
["Small Grain - Contoured & Crop Residue (Good Condition)",60,72,80,83,null,null,73]
["Small Grain - Contoured & Terraced (Poor Condition)",61,72,79,82,null,null,74]
["Small Grain - Contoured & Terraced (Good Condition)",59,70,78,81,null,null,75]
["Small Grain - Contoured, Terraced & Crop Residue (Poor Condition)",60,71,78,81,null,null,76]
["Small Grain - Contoured, Terraced & Crop Residue (Good Condition)",58,69,77,80,null,null,77]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Poor Condition)",66,77,85,89,null,null,78]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Good Condition)",58,72,81,85,null,null,79]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Poor Condition)",64,75,83,85,null,null,80]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Good Condition)",55,69,78,83,null,null,81]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Poor Condition)",63,73,80,83,null,null,82]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Good Condition)",51,67,76,80,null,null,83]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Poor Condition)",68,79,86,89,null,null,84]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Fair Condition)",49,69,79,84,null,null,85]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Good Condition)",39,61,74,80]
["Meadow-Continuous Grass, Protected from Grazing and Generally Mowed for Hay",30,58,71,78]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Poor Condition)",48,67,77,83]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Fair Condition)",35,56,70,77]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Good Condition)",30,48,65,73]
["Woods-Grass Combination (Orchard or Tree Farm) (Poor Condition)",57,73,82,86]
["Woods-Grass Combination (Orchard or Tree Farm) (Fair Condition)",43,65,76,82]
["Woods-Grass Combination (Orchard or Tree Farm) (Good Condition)",32,58,72,79]
["Woods (Poor Condition)",45,66,77,83]
["Woods (Fair Condition)",36,60,73,79]
["Woods (Good Condition)",30,55,70,77]
["Farmstead-Buildings, Lanes, Driveways and Surrounding Lots",59,74,82,86]
["Roads (Including ROW) - Dirt",72,82,87,89]
["Roads (Including ROW) - Gravel",76,85,89,91]