{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SCM 3.3.1","Reference","Versions","Ref"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SCM 3.3.1","index":0,"n_rows":76,"n_cols":43,"rows_kept":76,"cut":false,"hidden":false,"merged":[[36,16,36,18],[36,19,36,21],[36,22,36,25],[37,16,37,18],[37,19,37,21],[37,22,37,25],[38,22,38,25],[38,19,38,21],[37,32,37,33],[30,32,30,37],[30,38,30,43],[31,34,31,35],[31,36,31,37],[31,38,31,39],[31,40,31,41],[31,42,31,43],[38,49,38,50],[37,34,37,35],[37,36,37,37],[37,38,37,39],[37,40,37,41],[37,42,37,43],[38,38,38,39],[38,40,38,41],[38,32,38,37],[53,2,53,15],[53,21,53,25],[49,2,49,15],[38,42,38,43],[32,32,32,33],[32,34,32,35],[32,36,32,37],[32,38,32,39],[32,40,32,41],[32,42,32,43],[35,32,35,33],[35,34,35,35],[35,36,35,37],[35,38,35,39],[35,40,35,41],[35,42,35,43],[36,32,36,33],[36,34,36,35],[36,36,36,37],[36,38,36,39],[36,40,36,41],[36,42,36,43],[48,2,48,15],[48,16,48,20],[45,2,45,15],[45,16,45,20],[45,21,45,25],[47,21,47,25],[47,2,47,15],[47,16,47,20],[5,2,5,4],[5,5,5,6],[5,12,5,14],[31,2,31,15],[31,16,31,18],[31,19,31,21],[31,22,31,25],[35,2,35,15],[36,2,36,15],[37,2,37,15],[35,22,35,25],[35,16,35,18],[32,19,32,21],[32,22,32,25],[34,16,34,18],[34,19,34,21],[34,22,34,25],[35,19,35,21],[2,1,2,25],[5,15,5,25],[24,0,24,25],[23,2,23,19],[25,15,25,20],[27,2,27,4],[27,5,27,25],[11,2,11,25],[19,2,19,7],[19,8,19,25],[21,5,21,25],[0,0,0,25],[52,2,52,15],[52,16,52,20],[52,21,52,25],[34,2,34,15],[7,2,7,9],[7,23,7,24],[7,15,7,22],[7,13,7,14],[32,16,32,18],[51,2,51,25],[50,2,50,25],[39,2,39,25],[38,16,38,17],[46,2,46,15],[46,16,46,20],[46,21,46,25],[32,2,32,15],[9,2,9,18],[29,2,29,25],[1,1,1,25],[7,10,7,11],[3,1,3,7],[3,8,3,9],[75,4,75,11],[75,14,75,17],[75,18,75,25],[31,32,31,33],[44,2,44,15],[44,16,44,20],[44,21,44,25],[43,2,43,15],[43,16,43,20],[43,21,43,25],[65,8,65,25],[69,2,69,21],[70,2,70,21],[68,22,68,25],[69,22,69,25],[56,16,56,20],[56,21,56,25],[57,16,57,20],[57,21,57,25],[55,2,55,15],[55,16,55,20],[68,2,68,21],[70,22,70,25],[67,22,67,25],[39,33,39,37],[39,38,39,39],[39,40,39,41],[39,42,39,43],[49,16,49,20],[49,21,49,25],[72,1,72,25],[73,1,73,25],[55,21,55,25],[56,2,56,15],[57,2,57,15],[53,16,53,20],[67,2,67,21],[54,2,54,15],[54,16,54,20],[54,21,54,25],[59,2,59,25],[41,2,41,15],[41,16,41,20],[41,21,41,25],[42,2,42,15],[42,16,42,20],[42,21,42,25],[48,21,48,25]]}
[null,null,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,false,false,false,"SCMType","Distrib","Remedial","Rows","T_F","Protect","Pretreat"]
[null,"SCM 3.3.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,false,false,false,"Riparian Forest Buffer Not Meeting § 102.14(b)","Level Spreader","Eliminate preferential flow paths",1,true,"Deed Restriction","Meadow"]
[null," Protected Natural Stormwater Features (PNSFs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,true,false,"Riparian Buffer (Non-Forested)","Other","Stabilize preferential flow paths to prevent erosion up to 10-yr/24-hr storm",2,false,"Conservation Easement","Vegetated 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,null,null,false,null,false,"Other Forested Area",null,"Other",3,null,"Other","Level Spreader"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,"Other Non-Forested Vegetated Area",null,null,4,null,null,"None"]
[null,null,"SCM ID:",null,null,null,null,null,null,null,null,null,"SCM Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P6<>\"\",IF(OR(P6=\"Riparian Forest Buffer Not Meeting § 102.14(b)\",P6=\"Other Forested Area\"),1,2),\"\")","v":""},false,null,false,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,6]
[null,null,"2-year/24-hour Precipitation Depth:",null,null,null,null,null,null,null,null,null,"in",null,null,"SCM Contributing Drainage Area:",null,null,null,null,null,null,null,null,null,"ac",null,false,null,null,null,null,null,7]
[null,null,null,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(AND(X8<>\"\",AB8<>\"\",V46<>\"\"),IF(AND(V46<>\"> 2-Year/24-Hour Storm\",AB8>6.1),\"Y\",IF(AND(V46=\"> 2-Year/24-Hour Storm\",AB8>3.1),\"Y\",\"\")),\"\")","v":""},null,null,null,null,null,8]
[null,null,"Has the Protected Natural Stormwater Feature been investigated in the field?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"A field investigation for prefential flow paths and color photographs are required."]
[]
[null,null,"Are color photographs of the Protected Natural Stormwater Feature attached?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"Attach color photographs of the Protected Natural Stormwater Feature."]
[]
[null,null,"Do preferential flow paths through the SCM currently exist?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"Proposed remedial action:"]
[]
[null,null,"Description:"]
[]
[null,null,"Will flow be concentrated upslope of the Protected Natural Stormwater Feature?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"How will flow be distributed across the length of the SCM?"]
[]
[null,null,"Description:",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(AND(I28<>\"\",I28<>\"Off-Site\"),\"Y\",\"\")","v":""}]
[]
[null,null,"Post-Construction Land Cover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pollutant Conc. (mg/L)",null,null,null,null,null,"Pollutant Loads (lbs)"]
[null,null,"Protected Natural Stormwater Feature Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,"HSG",null,null,"Runoff, 2-Yr/24-Hr (CF)",null,null,null,null,"CN","Ia","Q","Volume","Soil Group","TSS",null,"TP",null,"TN",null,"TSS",null,"TP",null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE33<>\"\",AE33,\"\")","v":""},null,null,null,{"$f":"IF(AND(AA6<>\"\",Q33<>\"\"),IF(AA6=1,Q33*43560*(1.5/12)*(1-IF(AB59<>\"\",AB59,0)),IF(AA6=2,Q33*43560*(0.75/12)*(1-IF(AB59<>\"\",AB59,0)))),\"\")","v":""},{"$f":"IF(AND(C33<>\"\",Q33<>\"\",T33<>\"\"),IF(ISNA(VLOOKUP(C33,Ref!$A$1:$E$61,AF33,FALSE))=TRUE,\"\",VLOOKUP(C33,Ref!$A$1:$E$61,AF33,FALSE)),\"\")","v":""},{"$f":"IF(AB33<>\"\",0.2*((1000/AB33)-10),\"\")","v":""},{"$f":"IF(AND(AC33<>\"\",$K$8<>\"\"),IF($K$8-AC33>0,(($K$8-AC33)^2)/($K$8+0.8*((1000/AB33)-10)),0),\"\")","v":""},{"$f":"IF(AD33<>\"\",Q33*43560*(AD33/12),\"\")","v":""},{"$f":"IF(T33<>\"\",IF(T33=\"A\",2,IF(T33=\"B\",3,IF(T33=\"C\",4,IF(OR(T33=\"D\",T33=\"N/A\"),5,)))),\"\")","v":""},"",null,"",null,"",null,{"$f":"IF(AND($Y33<>\"\",AG33<>\"\"),($Y33/43560)*AG33*2.72,\"\")","v":""},null,{"$f":"IF(AND($Y33<>\"\",AI33<>\"\"),($Y33/43560)*AI33*2.72,\"\")","v":""},null,{"$f":"IF(AND($Y33<>\"\",AK33<>\"\"),($Y33/43560)*AK33*2.72,\"\")","v":""}]
[null,null,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(AND(C34<>\"\",Q34<>\"\",T34<>\"\"),IF(ISNA(VLOOKUP(C34,Ref!$A$1:$F$61,6,FALSE))=TRUE,\"\",IF(VLOOKUP(C34,Reference!$A$1:$F$61,6,FALSE)=\"Y\",Q34,0)),0)","v":0},{"$f":"IF(AND(C34<>\"\",Q34<>\"\",T34<>\"\"),IF(ISNA(VLOOKUP(C34,Ref!$A$1:$E$61,AF34,FALSE))=TRUE,\"\",VLOOKUP(C34,Ref!$A$1:$E$61,AF34,FALSE)),\"\")","v":""},{"$f":"IF(AB34<>\"\",0.2*((1000/AB34)-10),\"\")","v":""},{"$f":"IF(AND(AC34<>\"\",$K$8<>\"\"),IF($K$8-AC34>0,(($K$8-AC34)^2)/($K$8+0.8*((1000/AB34)-10)),0),\"\")","v":""},{"$f":"IF(AD34<>\"\",Q34*43560*(AD34/12),\"\")","v":""},{"$f":"IF(T34<>\"\",IF(T34=\"A\",2,IF(T34=\"B\",3,IF(T34=\"C\",4,IF(OR(T34=\"D\",T34=\"N/A\"),5,)))),\"\")","v":""}]
[null,null,"Impervious (Within PNSF Drainage Area) Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,"HSG",null,null,"Runoff, 2-Yr/24-Hr (CF)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,{"$f":"IF(AE36<>\"\",AE36,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(C36<>\"\",Q36<>\"\",T36<>\"\"),IF(ISNA(VLOOKUP(C36,Ref!$A$1:$E$61,AF36,FALSE))=TRUE,\"\",VLOOKUP(C36,Ref!$A$1:$E$61,AF36,FALSE)),\"\")","v":""},"","","",5,{"$f":"IF(C36<>\"\",IF(ISNA(VLOOKUP(C36,Ref!$AA$2:$AD$9,2,FALSE))=TRUE,\"\",VLOOKUP(C36,Ref!$AA$2:$AD$9,2,FALSE)),\"\")","v":""},null,{"$f":"IF(C36<>\"\",IF(ISNA(VLOOKUP(C36,Ref!$AA$2:$AD$9,3,FALSE))=TRUE,\"\",VLOOKUP(C36,Ref!$AA$2:$AD$9,3,FALSE)),\"\")","v":""},null,{"$f":"IF(C36<>\"\",IF(ISNA(VLOOKUP(C36,Ref!$AA$2:$AD$9,4,FALSE))=TRUE,\"\",VLOOKUP(C36,Ref!$AA$2:$AD$9,4,FALSE)),\"\")","v":""},null,{"$f":"IF(AND($AE36<>\"\",AG36<>\"\"),($AE36/43560)*AG36*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE36<>\"\",AI36<>\"\"),($AE36/43560)*AI36*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE36<>\"\",AK36<>\"\"),($AE36/43560)*AK36*2.72,\"\")","v":""}]
[null,null,{"$f":"IF(C36<>\"\",C36,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q38<>\"\",Q36<>\"\"),IF(Q38>Q36,0,Q36-Q38),\"\")","v":""},null,null,{"$f":"T36","v":"N/A"},null,null,{"$f":"IF(AE37<>\"\",AE37,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(C37<>\"\",Q37<>\"\",T37<>\"\"),IF(ISNA(VLOOKUP(C37,Ref!$A$1:$E$61,AF37,FALSE))=TRUE,\"\",VLOOKUP(C37,Ref!$A$1:$E$61,AF37,FALSE)),\"\")","v":""},{"$f":"IF(AB37<>\"\",0.2*((1000/AB37)-10),\"\")","v":""},{"$f":"IF(AND(AC37<>\"\",$K$8<>\"\"),IF($K$8-AC37>0,(($K$8-AC37)^2)/($K$8+0.8*((1000/AB37)-10)),0),\"\")","v":""},{"$f":"IF(AD37<>\"\",Q37*43560*(AD37/12),\"\")","v":""},{"$f":"IF(T37<>\"\",IF(T37=\"A\",2,IF(T37=\"B\",3,IF(T37=\"C\",4,IF(OR(T37=\"D\",T37=\"N/A\"),5,)))),\"\")","v":5},{"$f":"IF(C37<>\"\",IF(ISNA(VLOOKUP(C37,Ref!$AA$2:$AD$9,2,FALSE))=TRUE,\"\",VLOOKUP(C37,Ref!$AA$2:$AD$9,2,FALSE)),\"\")","v":""},null,{"$f":"IF(C37<>\"\",IF(ISNA(VLOOKUP(C37,Ref!$AA$2:$AD$9,3,FALSE))=TRUE,\"\",VLOOKUP(C37,Ref!$AA$2:$AD$9,3,FALSE)),\"\")","v":""},null,{"$f":"IF(C37<>\"\",IF(ISNA(VLOOKUP(C37,Ref!$AA$2:$AD$9,4,FALSE))=TRUE,\"\",VLOOKUP(C37,Ref!$AA$2:$AD$9,4,FALSE)),\"\")","v":""},null,{"$f":"IF(AND($AE37<>\"\",AG37<>\"\"),($AE37/43560)*AG37*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE37<>\"\",AI37<>\"\"),($AE37/43560)*AI37*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE37<>\"\",AK37<>\"\"),($AE37/43560)*AK37*2.72,\"\")","v":""}]
[null,null,{"$f":"IF(C33<>\"\",C33,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q36<>\"\",Q36,\"\")","v":""},null,null,{"$f":"IF(T33<>\"\",T33,\"\")","v":""},null,null,{"$f":"IF(AE38<>\"\",AE38,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(C38<>\"\",Q38<>\"\",T38<>\"\"),IF(ISNA(VLOOKUP(C38,Ref!$A$1:$E$61,AF38,FALSE))=TRUE,\"\",VLOOKUP(C38,Ref!$A$1:$E$61,AF38,FALSE)),\"\")","v":""},"","","","",{"$f":"IF(C38<>\"\",IF(ISNA(VLOOKUP(C38,Ref!$W$2:$Z$14,2,FALSE))=TRUE,\"\",VLOOKUP(C38,Ref!$W$2:$Z$14,2,FALSE)),\"\")","v":""},null,{"$f":"IF(C38<>\"\",IF(ISNA(VLOOKUP(C38,Ref!$W$2:$Z$14,3,FALSE))=TRUE,\"\",VLOOKUP(C38,Ref!$W$2:$Z$14,3,FALSE)),\"\")","v":""},null,{"$f":"IF(C38<>\"\",IF(ISNA(VLOOKUP(C38,Ref!$W$2:$Z$14,4,FALSE))=TRUE,\"\",VLOOKUP(C38,Ref!$W$2:$Z$14,4,FALSE)),\"\")","v":""},null,{"$f":"IF(AND($AE38<>\"\",AG38<>\"\"),($AE38/43560)*AG38*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE38<>\"\",AI38<>\"\"),($AE38/43560)*AI38*2.72,\"\")","v":""},null,{"$f":"IF(AND($AE38<>\"\",AM38<>\"\"),($AE38/43560)*AM38*2.72,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Credit:",null,null,{"$f":"IF(AND(W36<>\"\",W37<>\"\",W38<>\"\",AB59<>\"\",AA46<>\"\"),(W36-(W37+W38))*(1-AB59),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Credit:",null,null,null,null,null,{"$f":"IF(AND(AM36<>\"\",AM37<>\"\",AM38<>\"\",AB59<>\"\"),(AM36-(AM37+AM38))*(1-AB59),\"\")","v":""},null,{"$f":"IF(AND(AO36<>\"\",AO37<>\"\",AO38<>\"\",AB59<>\"\"),(AO36-(AO37+AO38))*(1-AB59),\"\")","v":""},null,{"$f":"IF(AND(AQ36<>\"\",AQ37<>\"\",AQ38<>\"\",AB59<>\"\"),(AQ36-(AQ37+AQ38))*(1-AB59),\"\")","v":""}]
[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,{"$f":"IF(AND(V45<>\"\",V46<>\"\",V47<>\"\"),IF(AND((V45*V46)<(V47*1.1),(V45*V46)>(V47*0.9)),TRUE,FALSE),\"\")","v":""}]
[]
[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?","Entry Complete?"]
[null,null,"PNSF Length (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,null,"Y",{"$f":"IF(OR(AC43=\"\",AND(AC43=\"Y\",V43<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"PNSF Contributing Drainage Area Length (ft)",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(V44>V43,\"Y\",\"\")","v":""},null,"Y",""]
[null,null,"PNSF Inflow Length (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,null,"Y",""]
[null,null,"PNSF Average Width, Minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,{"$f":"IF(V46<>\"\",IF(AND(V46>=50,V46<100),1,IF(AND(V46>=100,V46<150),1.1,IF(V46>=150,1.2))),\"\")","v":""},null,"Y",""]
[null,null,"PNSF Area (ac)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q33<>\"\",Q33,\"\")","v":""},null,null,null,null,null,null,"Y",""]
[null,null,"Average Slope within PNSF, Maximum (ft/ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,null,null,null,null,null,null,null,null,null,{"$f":"IF(V48<0.05,\"Pretreat2\",\"Pretreat\")","v":"Pretreat2"},null,"Y",""]
[null,null,"Peak runoff velocity @ 10-year/24-hour storm (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(AND(Q49<>\"\",V49<>\"\"),IF(V49>(Q49*1.1),(V49-(Q49*1.1))/(Q49*1.1),0),\"\")","v":""},{"$f":"IF(V48>0.06,\"Y\",\"\")","v":""},"Y"]
[null,null,"Method used for long-term protection of PNSF",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,"Y",{"$f":"IF(OR(AC50=\"\",AND(AC50=\"Y\",V50<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"Long-term protection method:",null,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(V50=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC51=\"\",AC51=\"Y\"),\"Y\",\"\")","v":"Y"}]
[null,null,null,null,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(V50=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC52=\"\",AND(C52<>\"\",AC52=\"Y\")),\"Y\",\"\")","v":"Y"}]
[null,null,"Pretreatment:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One",null,null,null,null,null,null,null,null,null,{"$f":"IF(V53<>\"\",IF(V53=\"Meadow\",1,IF(V53=\"Vegetated Filter Strip\",2,IF(V53=\"Level Spreader\",3,IF(V53=\"None\",4)))),\"\")","v":""},null,"Y",""]
[null,null,"Width, Minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q54<>\"\",V54<>\"\"),IF(V54<(Q54*0.9),((Q54*0.9)-V54)/(Q54*0.9),0),\"\")","v":""},{"$f":"IF(OR(AA53=1,AA53=2),\"Y\",\"\")","v":""},"Y"]
[null,null,"Length (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V45<>\"\",V45,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q55<>\"\",V55<>\"\"),IF(V55<(Q55*0.9),((Q55*0.9)-V55)/(Q55*0.9),0),\"\")","v":""},"Y",""]
[null,null,"Average Slope of Meadow (ft/ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA53=1,\"Y\",\"\")","v":""},"Y"]
[null,null,"Retentive Grading Berm Height (minimum, prior to SCM) (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA53=2,\"Y\",\"\")","v":""},"Y"]
[null,null,"Flow depth over level spreader @ 10-year/24-hour storm (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q58<>\"\",V58<>\"\"),IF(V58>(Q58*1.1),(V58-(Q58*1.1))/(Q58*1.1),0),\"\")","v":""},{"$f":"IF(AA53=3,\"Y\",\"\")","v":""},"Y"]
[null,null,null,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(AD59=\"Y\",IF(SUM(AB43:AB58)>1,1,SUM(AB43:AB58)),\"\")","v":""},null,{"$f":"IF(COUNTBLANK(AD43:AD58)=0,\"Y\",\"\")","v":""}]
[null,null,"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,{"$f":"IF(COUNTBLANK(AD43:AD58)=0,\"Y\",\"\")","v":""}]
[null,null,"Does the PNSF Drainage Area contain residential land use?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"No"]
[]
[null,null,"Does the maximum impervious area allowed under local ordinances currently exist on the residential lot(s)?"]
[]
[null,null,null,"Yes",null,null,"No",null,{"$f":"IF(AD6=TRUE,\"A 10% factor of safety is applied to credits for future impervious\",\"\")","v":""}]
[]
[null,null,"Volume Management Credit (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W39<>\"\",W39*(IF(AD6=TRUE,0.9,1)),\"\")","v":""}]
[null,null,"WQ Management Credit - TSS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM39<>\"\",AM39*(IF(AD6=TRUE,0.9,1)),\"\")","v":""}]
[null,null,"WQ Management Credit - TP:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO39<>\"\",AO39*(IF(AD6=TRUE,0.9,1)),\"\")","v":""}]
[null,null,"WQ Management Credit - TN:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ39<>\"\",AQ39*(IF(AD6=TRUE,0.9,1)),\"\")","v":""}]
[]
[null,"CERTIFICATION"]
[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,"User Name:",null,null,null,null,null,null,null,null,null,null,null,null,"User Company:"]

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

{"sheet":"Versions","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Change(s)"]
["1.0","2026-03-23","Original Draft"]

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