{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SCM 3.4.2","Reference","Versions","Ref"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":21,"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.4.2","index":0,"n_rows":122,"n_cols":47,"rows_kept":122,"cut":false,"hidden":false,"merged":[[51,41,51,46],[55,44,55,45],[56,44,56,45],[57,44,57,45],[113,2,113,21],[114,2,114,21],[115,2,115,21],[116,2,116,21],[116,22,116,25],[98,16,98,20],[99,2,99,15],[99,16,99,20],[99,21,99,25],[100,2,100,15],[100,16,100,20],[100,21,100,25],[101,2,101,15],[101,16,101,20],[101,21,101,25],[95,2,95,15],[95,16,95,20],[95,21,95,25],[96,2,96,15],[96,16,96,20],[118,1,118,25],[119,1,119,25],[121,4,121,11],[121,14,121,17],[121,18,121,25],[113,22,113,25],[114,22,114,25],[115,22,115,25],[102,2,102,15],[102,16,102,20],[102,21,102,25],[103,16,103,20],[104,2,104,25],[110,8,110,25],[112,22,112,25],[96,21,96,25],[97,2,97,15],[97,16,97,20],[97,21,97,25],[91,2,91,15],[91,16,91,20],[91,21,91,25],[92,2,92,15],[92,16,92,20],[92,21,92,25],[94,2,94,15],[94,16,94,20],[94,21,94,25],[88,2,88,15],[88,16,88,20],[88,21,88,25],[89,2,89,15],[89,16,89,20],[89,21,89,25],[90,2,90,15],[90,16,90,20],[90,21,90,25],[83,2,83,15],[83,16,83,20],[83,21,83,25],[84,2,84,15],[84,16,84,20],[84,21,84,25],[85,2,85,25],[86,2,86,25],[87,2,87,15],[87,16,87,20],[87,21,87,25],[79,2,79,25],[80,2,80,15],[80,16,80,20],[80,21,80,25],[81,2,81,15],[81,16,81,20],[81,21,81,25],[82,2,82,15],[82,16,82,20],[82,21,82,25],[76,2,76,15],[76,16,76,20],[76,21,76,25],[77,2,77,15],[77,16,77,20],[77,21,77,25],[78,2,78,15],[78,16,78,20],[78,21,78,25],[73,2,73,15],[73,16,73,20],[73,21,73,25],[74,2,74,15],[74,16,74,20],[74,21,74,25],[75,2,75,15],[75,16,75,20],[75,21,75,25],[67,2,67,13],[67,14,67,17],[67,18,67,21],[71,2,71,15],[71,16,71,20],[71,21,71,25],[72,2,72,15],[72,16,72,20],[72,21,72,25],[67,22,67,25],[69,16,69,21],[69,22,69,23],[69,24,69,25],[64,2,64,13],[64,14,64,17],[64,18,64,21],[64,22,64,25],[65,2,65,13],[65,14,65,17],[65,18,65,21],[65,22,65,25],[66,2,66,13],[66,14,66,17],[66,18,66,21],[66,22,66,25],[60,2,60,14],[60,15,60,17],[60,18,60,19],[60,20,60,21],[60,22,60,25],[62,14,62,25],[63,14,63,17],[63,18,63,21],[63,22,63,25],[61,15,61,17],[58,2,58,14],[58,15,58,17],[58,18,58,19],[58,20,58,21],[58,22,58,25],[59,2,59,14],[59,15,59,17],[59,18,59,19],[59,20,59,21],[59,22,59,25],[56,2,56,14],[56,15,56,17],[56,18,56,19],[56,20,56,21],[56,22,56,25],[57,2,57,14],[57,15,57,17],[57,18,57,19],[57,20,57,21],[57,22,57,25],[54,2,54,14],[54,15,54,17],[54,18,54,19],[54,20,54,21],[54,22,54,25],[55,2,55,14],[55,15,55,17],[55,18,55,19],[55,20,55,21],[55,22,55,25],[51,28,51,31],[52,2,52,14],[52,15,52,17],[52,18,52,19],[52,20,52,21],[52,22,52,25],[53,2,53,14],[53,15,53,17],[53,18,53,19],[53,20,53,21],[53,22,53,25],[47,2,47,13],[47,14,47,17],[47,18,47,21],[47,22,47,25],[48,2,48,13],[48,14,48,17],[48,18,48,21],[48,22,48,25],[50,2,50,10],[50,11,50,12],[50,13,50,14],[43,14,43,25],[44,14,44,17],[44,18,44,21],[44,22,44,25],[45,2,45,13],[45,14,45,17],[45,18,45,21],[45,22,45,25],[46,2,46,13],[46,14,46,17],[46,18,46,21],[46,22,46,25],[40,2,40,14],[40,15,40,17],[40,18,40,19],[40,20,40,21],[40,22,40,25],[41,2,41,14],[41,15,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,25],[38,2,38,14],[38,15,38,17],[38,18,38,19],[38,20,38,21],[39,2,39,14],[39,15,39,17],[39,18,39,19],[39,20,39,21],[39,22,39,25],[32,28,32,31],[33,2,33,14],[33,15,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,25],[34,2,34,14],[34,15,34,17],[34,18,34,19],[34,20,34,21],[37,18,37,19],[0,0,0,25],[7,2,7,9],[7,23,7,24],[7,15,7,22],[7,13,7,14],[29,2,29,25],[1,1,1,25],[7,10,7,11],[3,1,3,7],[3,8,3,9],[5,2,5,4],[5,5,5,6],[5,12,5,14],[2,1,2,25],[5,15,5,25],[24,0,24,25],[25,15,25,20],[27,2,27,4],[27,5,27,25],[11,2,11,25],[19,2,19,7],[19,8,19,25],[37,20,37,21],[42,22,42,25],[42,15,42,17],[93,2,93,15],[93,16,93,20],[93,21,93,25],[21,5,21,25],[31,2,31,10],[31,11,31,12],[31,13,31,14],[35,22,35,25],[34,22,34,25],[36,22,36,25],[37,22,37,25],[38,22,38,25],[35,2,35,14],[35,15,35,17],[35,18,35,19],[35,20,35,21],[36,2,36,14],[36,15,36,17],[36,18,36,19],[36,20,36,21],[37,2,37,14],[37,15,37,17]]}
[null,null,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","Inundation","Storm"]
[null,"SCM 3.4.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,"Protected RFB (Existing)","Level Spreader","Eliminate preferential flow paths",1,true,"Deed Restriction","Meadow","Tolerant","< 2-Year/24-Hour Storm"]
[null,"Riparian Forest Buffers (RFBs)",null,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,"Converted RFB","Other","Stabilize preferential flow paths to prevent erosion up to 10-yr/24-hr storm",2,false,"Conservation Easement","Vegetated Filter Strip","Intermediate","2-Year/24-Hour Storm"]
[null,null,null,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,"Newly Established RFB",null,"Other",3,null,"Other","Level Spreader","Intolerant","> 2-Year/24-Hour Storm"]
[null,null,null,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,null,null,null,4,null,null,null,null,"10-Year/24-Hour Storm"]
[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(P6=\"Protected RFB (Existing)\",1,IF(P6=\"Converted RFB\",2,IF(P6=\"Newly Established RFB\",3))),\"\")","v":""},false,null,false,null,null,null,5,null,null,null,null,"> 10-Year/24-Hour Storm"]
[null,null,null,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,null,null,null,null,null,null,8]
[null,null,"Has the Riparian Forest Buffer area been investigated in the field?",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 Riparian Forest Buffer area attached?",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 Riparian Forest Buffer area."]
[]
[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,null,"Yes",null,null,"No"]
[]
[null,null,"Proposed remedial action:"]
[]
[null,null,"Description:"]
[]
[null,null,"Will flow be concentrated upslope of the Riparian Forest Buffer?",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,"Drainage Areas"]
[]
[null,null,"Pre-Construction Drainage Area",null,null,null,null,null,null,null,null,"Rows:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Runoff"]
[null,null,"Pre-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,"HSG",null,"Off-Site",null,"2-Year/24-Hour Runoff (CF)",null,null,null,null,"Off-Site Runoff","CN","Ia","Q","Volume","Soil Group","TSS Load","Off-Site TSS","TN Load","Off-Site TN","TP Load","Off-Site TP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AF35<>\"\",AF35,\"\")","v":""},null,null,null,{"$f":"IF(AND(O46<>\"\",V78<>\"\"),O46/(V78*43560),\"\")","v":""},{"$f":"IF(U35=TRUE,W35,\"\")","v":""},{"$f":"IF(AND(C35<>\"\",P35<>\"\",S35<>\"\"),VLOOKUP(C35,Ref!$M$1:$T$12,AG35,FALSE),\"\")","v":""},{"$f":"IF(AC35<>\"\",0.2*((1000/AC35)-10),\"\")","v":""},{"$f":"IF(AND(AD35<>\"\",$K$8<>\"\"),IF($K$8-AD35>0,(($K$8-AD35)^2)/($K$8+0.8*((1000/AC35)-10)),0),\"\")","v":""},{"$f":"IF(AE35<>\"\",P35*43560*(AE35/12),\"\")","v":""},{"$f":"IF(S35<>\"\",IF(S35=\"A\",2,IF(S35=\"B\",3,IF(S35=\"C\",4,IF(OR(S35=\"D\",S35=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(AND(C35<>\"\",W35<>\"\"),(W35/43560)*VLOOKUP(C35,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U35=TRUE,AH35,\"\")","v":""},{"$f":"IF(AND(C35<>\"\",W35<>\"\"),(W35/43560)*VLOOKUP(C35,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U35=TRUE,AJ35,\"\")","v":""},{"$f":"IF(AND(C35<>\"\",W35<>\"\"),(W35/43560)*VLOOKUP(C35,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U35=TRUE,AL35,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AF36<>\"\",AF36,\"\")","v":""},null,null,null,null,{"$f":"IF(U36=TRUE,W36,\"\")","v":""},{"$f":"IF(AND(C36<>\"\",P36<>\"\",S36<>\"\"),VLOOKUP(C36,Ref!$M$1:$T$12,AG36,FALSE),\"\")","v":""},{"$f":"IF(AC36<>\"\",0.2*((1000/AC36)-10),\"\")","v":""},{"$f":"IF(AND(AD36<>\"\",$K$8<>\"\"),IF($K$8-AD36>0,(($K$8-AD36)^2)/($K$8+0.8*((1000/AC36)-10)),0),\"\")","v":""},{"$f":"IF(AE36<>\"\",P36*43560*(AE36/12),\"\")","v":""},{"$f":"IF(S36<>\"\",IF(S36=\"A\",2,IF(S36=\"B\",3,IF(S36=\"C\",4,IF(OR(S36=\"D\",S36=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(AND(C36<>\"\",W36<>\"\"),(W36/43560)*VLOOKUP(C36,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U36=TRUE,AH36,\"\")","v":""},{"$f":"IF(AND(C36<>\"\",W36<>\"\"),(W36/43560)*VLOOKUP(C36,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U36=TRUE,AJ36,\"\")","v":""},{"$f":"IF(AND(C36<>\"\",W36<>\"\"),(W36/43560)*VLOOKUP(C36,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U36=TRUE,AL36,\"\")","v":""}]
[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,"",{"$f":"IF(AND(C37<>\"\",P37<>\"\",S37<>\"\"),VLOOKUP(C37,Ref!$M$1:$T$12,AG37,FALSE),\"\")","v":""},"","",{"$f":"IF(AE37<>\"\",Q37*43560*(AE37/12),\"\")","v":""},"",{"$f":"IF(AND(C37<>\"\",W37<>\"\"),(W37/43560)*VLOOKUP(C37,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C37<>\"\",W37<>\"\"),(W37/43560)*VLOOKUP(C37,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C37<>\"\",W37<>\"\"),(W37/43560)*VLOOKUP(C37,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[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,"",{"$f":"IF(AND(C38<>\"\",P38<>\"\",S38<>\"\"),VLOOKUP(C38,Ref!$M$1:$T$12,AG38,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C38<>\"\",W38<>\"\"),(W38/43560)*VLOOKUP(C38,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C38<>\"\",W38<>\"\"),(W38/43560)*VLOOKUP(C38,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C38<>\"\",W38<>\"\"),(W38/43560)*VLOOKUP(C38,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[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,"",{"$f":"IF(AND(C39<>\"\",P39<>\"\",S39<>\"\"),VLOOKUP(C39,Ref!$M$1:$T$12,AG39,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C39<>\"\",W39<>\"\"),(W39/43560)*VLOOKUP(C39,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C39<>\"\",W39<>\"\"),(W39/43560)*VLOOKUP(C39,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C39<>\"\",W39<>\"\"),(W39/43560)*VLOOKUP(C39,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[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,"",{"$f":"IF(AND(C40<>\"\",P40<>\"\",S40<>\"\"),VLOOKUP(C40,Ref!$M$1:$T$12,AG40,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C40<>\"\",W40<>\"\"),(W40/43560)*VLOOKUP(C40,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C40<>\"\",W40<>\"\"),(W40/43560)*VLOOKUP(C40,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C40<>\"\",W40<>\"\"),(W40/43560)*VLOOKUP(C40,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[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,"",{"$f":"IF(AND(C41<>\"\",P41<>\"\",S41<>\"\"),VLOOKUP(C41,Ref!$M$1:$T$12,AG41,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C41<>\"\",W41<>\"\"),(W41/43560)*VLOOKUP(C41,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C41<>\"\",W41<>\"\"),(W41/43560)*VLOOKUP(C41,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C41<>\"\",W41<>\"\"),(W41/43560)*VLOOKUP(C41,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[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,"",{"$f":"IF(AND(C42<>\"\",P42<>\"\",S42<>\"\"),VLOOKUP(C42,Ref!$M$1:$T$12,AG42,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C42<>\"\",W42<>\"\"),(W42/43560)*VLOOKUP(C42,Ref!$M$1:$T$12,6,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C42<>\"\",W42<>\"\"),(W42/43560)*VLOOKUP(C42,Ref!$M$1:$T$12,8,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C42<>\"\",W42<>\"\"),(W42/43560)*VLOOKUP(C42,Ref!$M$1:$T$12,7,FALSE)*2.72,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P35:P42)>0,SUM(P35:P42),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AH35:AH42)>0,SUM(AH35:AH42),\"\")","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-Construction Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,"Off-Site",null,null,null,"Project Site"]
[null,null,"Runoff Volume (CF):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W35:W42)>0,SUM(W35:W42),\"\")","v":""},null,null,null,{"$f":"IF(SUM(AB35:AB42)>0,SUM(AB35:AB42),\"\")","v":""},null,null,null,{"$f":"IF(O46<>\"\",O46-IF(S46=\"\",0,S46),\"\")","v":""}]
[null,null,"TSS Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH43<>\"\",AH43,\"\")","v":""},null,null,null,{"$f":"IF(AI43<>\"\",AI43,\"\")","v":""},null,null,null,{"$f":"IF(O47<>\"\",O47-IF(S47=\"\",0,S47),\"\")","v":""}]
[null,null,"TN Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ43<>\"\",AJ43,\"\")","v":""},null,null,null,{"$f":"IF(AK43<>\"\",AK43,\"\")","v":""},null,null,null,{"$f":"IF(O48<>\"\",O48-IF(S48=\"\",0,S48),\"\")","v":""}]
[null,null,"TP Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL43<>\"\",AL43,\"\")","v":""},null,null,null,{"$f":"IF(AM43<>\"\",AM43,\"\")","v":""},null,null,null,{"$f":"IF(O49<>\"\",O49-IF(S49=\"\",0,S49),\"\")","v":""}]
[]
[null,null,"Post-Construction Drainage Area",null,null,null,null,null,null,null,null,"Rows:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Runoff",null,null,null,null,null,null,null,null,null,null,null,null,"Volume Calculation for Credit Limit"]
[null,null,"Post-Construction Drainage Area Cover Type",null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,"HSG",null,"Off-Site",null,"2-Year/24-Hour Runoff (CF)",null,null,null,null,"Off-Site Runoff","CN","Ia","Q","Volume","Soil Group","TSS Load","Off-Site TSS","TN Load","Off-Site TN","TP Load","Off-Site TP","Runoff 1.2 Inch",null,"Allowed Impervious","Actual Impervious","CN","Ia","Q","Volume"]
[null,{"$f":"IF(AND(C54<>\"\",P54<>\"\",U54=FALSE),IF(VLOOKUP(C54,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P54,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(AF54<>\"\",AF54,\"\")","v":""},null,null,null,{"$f":"IF(AND(AN54<>\"\",U54=FALSE),AN54/(0.083333*43560),0)","v":0},{"$f":"IF(U54=TRUE,W54,\"\")","v":""},{"$f":"IF(AND(C54<>\"\",P54<>\"\",S54<>\"\"),VLOOKUP(C54,Ref!$A$1:$E$61,AG54,FALSE),\"\")","v":""},{"$f":"IF(AC54<>\"\",0.2*((1000/AC54)-10),\"\")","v":""},{"$f":"IF(AND(AD54<>\"\",$K$8<>\"\"),IF($K$8-AD54>0,(($K$8-AD54)^2)/($K$8+0.8*((1000/AC54)-10)),0),\"\")","v":""},{"$f":"IF(AE54<>\"\",P54*43560*(AE54/12),\"\")","v":""},{"$f":"IF(S54<>\"\",IF(S54=\"A\",2,IF(S54=\"B\",3,IF(S54=\"C\",4,IF(OR(S54=\"D\",S54=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(AND(C54<>\"\",W54<>\"\"),(W54/43560)*VLOOKUP(C54,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U54=TRUE,AH54,\"\")","v":""},{"$f":"IF(AND(C54<>\"\",W54<>\"\"),(W54/43560)*VLOOKUP(C54,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U54=TRUE,AJ54,\"\")","v":""},{"$f":"IF(AND(C54<>\"\",W54<>\"\"),(W54/43560)*VLOOKUP(C54,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U54=TRUE,AL54,\"\")","v":""},{"$f":"IF(AD54<>\"\",IF(1.2-AD54>0,P54*43560*(((1.2-AD54)^2)/(1.2+0.8*((1000/AC54)-10))/12),0),\"\")","v":""},null,{"$f":"IF(V78<>\"\",V78*2,\"\")","v":""},{"$f":"IF(B62<>\"\",B62,\"\")","v":0},98,{"$f":"IF(AR54<>\"\",0.2*((1000/AR54)-10),\"\")","v":4.0816326530612207E-2},{"$f":"IF(AND(AS54<>\"\",$K$8<>\"\"),IF($K$8-AS54>0,(($K$8-AS54)^2)/($K$8+0.8*((1000/AR54)-10)),0),\"\")","v":""},{"$f":"IF(AND(AT54<>\"\",AP54<>\"\"),AP54*43560*(AT54/12),\"\")","v":""}]
[null,{"$f":"IF(AND(C55<>\"\",P55<>\"\",U55=FALSE),IF(VLOOKUP(C55,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P55,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,{"$f":"IF(AND(AN55<>\"\",U55=FALSE),AN55/(0.083333*43560),0)","v":0},{"$f":"IF(U55=TRUE,W55,\"\")","v":""},{"$f":"IF(AND(C55<>\"\",P55<>\"\",S55<>\"\"),VLOOKUP(C55,Ref!$A$1:$E$61,AG55,FALSE),\"\")","v":""},{"$f":"IF(AC55<>\"\",0.2*((1000/AC55)-10),\"\")","v":""},{"$f":"IF(AND(AD55<>\"\",$K$8<>\"\"),IF($K$8-AD55>0,(($K$8-AD55)^2)/($K$8+0.8*((1000/AC55)-10)),0),\"\")","v":""},{"$f":"IF(AE55<>\"\",P55*43560*(AE55/12),\"\")","v":""},{"$f":"IF(S55<>\"\",IF(S55=\"A\",2,IF(S55=\"B\",3,IF(S55=\"C\",4,IF(OR(S55=\"D\",S55=\"N/A\"),5,)))),\"\")","v":""},{"$f":"IF(AND(C55<>\"\",W55<>\"\"),(W55/43560)*VLOOKUP(C55,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U55=TRUE,AH55,\"\")","v":""},{"$f":"IF(AND(C55<>\"\",W55<>\"\"),(W55/43560)*VLOOKUP(C55,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U55=TRUE,AJ55,\"\")","v":""},{"$f":"IF(AND(C55<>\"\",W55<>\"\"),(W55/43560)*VLOOKUP(C55,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},{"$f":"IF(U55=TRUE,AL55,\"\")","v":""},{"$f":"IF(AD55<>\"\",IF(1.2-AD55>0,P55*43560*(((1.2-AD55)^2)/(1.2+0.8*((1000/AC55)-10))/12),0),\"\")","v":""},null,null,null,{"$f":"IF(Y70<>\"\",IF(Y70=\"A\",30,IF(Y70=\"B\",55,IF(Y70=\"C\",70,IF(Y70=\"D\",77)))),\"\")","v":""},{"$f":"IF(AR55<>\"\",0.2*((1000/AR55)-10),\"\")","v":""},{"$f":"IF(AND(AS55<>\"\",$K$8<>\"\"),IF($K$8-AS55>0,(($K$8-AS55)^2)/($K$8+0.8*((1000/AR55)-10)),0),\"\")","v":""},{"$f":"IF(AND(AT55<>\"\",AP54<>\"\"),AP54*43560*(AT55/12),\"\")","v":""}]
[null,{"$f":"IF(AND(C56<>\"\",P56<>\"\",U56=FALSE),IF(VLOOKUP(C56,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P56,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C56<>\"\",P56<>\"\",S56<>\"\"),VLOOKUP(C56,Ref!$A$1:$E$61,AG56,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C56<>\"\",W56<>\"\"),(W56/43560)*VLOOKUP(C56,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C56<>\"\",W56<>\"\"),(W56/43560)*VLOOKUP(C56,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C56<>\"\",W56<>\"\"),(W56/43560)*VLOOKUP(C56,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"","",null,null,null,null,"100% increase area:",null,{"$f":"IF(AND(AU54<>\"\",AU55<>\"\"),AU54-AU55,\"\")","v":""}]
[null,{"$f":"IF(AND(C57<>\"\",P57<>\"\",U57=FALSE),IF(VLOOKUP(C57,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P57,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C57<>\"\",P57<>\"\",S57<>\"\"),VLOOKUP(C57,Ref!$A$1:$E$61,AG57,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C57<>\"\",W57<>\"\"),(W57/43560)*VLOOKUP(C57,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C57<>\"\",W57<>\"\"),(W57/43560)*VLOOKUP(C57,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C57<>\"\",W57<>\"\"),(W57/43560)*VLOOKUP(C57,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"","",null,null,null,null,"100% increase pre:",null,{"$f":"IF(W46<>\"\",W46*2,\"\")","v":""}]
[null,{"$f":"IF(AND(C58<>\"\",P58<>\"\",U58=FALSE),IF(VLOOKUP(C58,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P58,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C58<>\"\",P58<>\"\",S58<>\"\"),VLOOKUP(C58,Ref!$A$1:$E$61,AG58,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C58<>\"\",W58<>\"\"),(W58/43560)*VLOOKUP(C58,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C58<>\"\",W58<>\"\"),(W58/43560)*VLOOKUP(C58,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C58<>\"\",W58<>\"\"),(W58/43560)*VLOOKUP(C58,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"","",null,null,null,null,"Volume Limit:",null,{"$f":"IF(AND(AU56<>\"\",AU57<>\"\"),IF(AU56>AU57,AU56,AU57),\"\")","v":""}]
[null,{"$f":"IF(AND(C59<>\"\",P59<>\"\",U59=FALSE),IF(VLOOKUP(C59,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P59,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C59<>\"\",P59<>\"\",S59<>\"\"),VLOOKUP(C59,Ref!$A$1:$E$61,AG59,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C59<>\"\",W59<>\"\"),(W59/43560)*VLOOKUP(C59,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C59<>\"\",W59<>\"\"),(W59/43560)*VLOOKUP(C59,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C59<>\"\",W59<>\"\"),(W59/43560)*VLOOKUP(C59,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"",""]
[null,{"$f":"IF(AND(C60<>\"\",P60<>\"\",U60=FALSE),IF(VLOOKUP(C60,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P60,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C60<>\"\",P60<>\"\",S60<>\"\"),VLOOKUP(C60,Ref!$A$1:$E$61,AG60,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C60<>\"\",W60<>\"\"),(W60/43560)*VLOOKUP(C60,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C60<>\"\",W60<>\"\"),(W60/43560)*VLOOKUP(C60,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C60<>\"\",W60<>\"\"),(W60/43560)*VLOOKUP(C60,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"",""]
[null,{"$f":"IF(AND(C61<>\"\",P61<>\"\",U61=FALSE),IF(VLOOKUP(C61,Ref!$A$1:$F$61,6,FALSE)=\"Y\",P61,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"",null,null,null,0,"",{"$f":"IF(AND(C61<>\"\",P61<>\"\",S61<>\"\"),VLOOKUP(C61,Ref!$A$1:$E$61,AG61,FALSE),\"\")","v":""},"","","","",{"$f":"IF(AND(C61<>\"\",W61<>\"\"),(W61/43560)*VLOOKUP(C61,Ref!$A$2:$I$61,7,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C61<>\"\",W61<>\"\"),(W61/43560)*VLOOKUP(C61,Ref!$A$2:$I$61,9,FALSE)*2.72,\"\")","v":""},"",{"$f":"IF(AND(C61<>\"\",W61<>\"\"),(W61/43560)*VLOOKUP(C61,Ref!$A$2:$I$61,8,FALSE)*2.72,\"\")","v":""},"",""]
[null,{"$f":"IF(SUM(B54:B61)>0,SUM(B54:B61),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P54:P61)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AA54:AA61)>0,SUM(AA54:AA61),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(AH54:AH61)>0,SUM(AH54:AH61),\"\")","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-Construction Values",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(W63<>\"\",W46<>\"\"),IF(W63>(2*W46),\"Y\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,"Off-Site",null,null,null,"Project Site"]
[null,null,"Runoff Volume (CF):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W54:W61)>0,SUM(W54:W61),\"\")","v":""},null,null,null,{"$f":"IF(SUM(AB54:AB61)>0,SUM(AB54:AB61),\"\")","v":""},null,null,null,{"$f":"IF(O65<>\"\",O65-IF(S65=\"\",0,S65),\"\")","v":""}]
[null,null,"TSS Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH62<>\"\",AH62,\"\")","v":""},null,null,null,{"$f":"IF(AI62<>\"\",AI62,\"\")","v":""},null,null,null,{"$f":"IF(O66<>\"\",O66-IF(S66=\"\",0,S66),\"\")","v":""}]
[null,null,"TN Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ62<>\"\",AJ62,\"\")","v":""},null,null,null,{"$f":"IF(AK62<>\"\",AK62,\"\")","v":""},null,null,null,{"$f":"IF(O67<>\"\",O67-IF(S67=\"\",0,S67),\"\")","v":""}]
[null,null,"TP Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL62<>\"\",AL62,\"\")","v":""},null,null,null,{"$f":"IF(AM62<>\"\",AM62,\"\")","v":""},null,null,null,{"$f":"IF(O68<>\"\",O68-IF(S68=\"\",0,S68),\"\")","v":""}]
[]
[null,null,"RFB Design Standards",null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Type within RFB:",null,null,null,null,null,"HSG"]
[]
[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,"Maximum Storm Event Routed to RFB",null,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(AC73=\"\",AND(AC73=\"Y\",V73<>\"\")),\"Y\",\"\")","v":""}]
[null,null,"RFB 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,"RFB 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(V75>V74,\"Y\",\"\")","v":""},null,"Y",""]
[null,null,"RFB 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,"RFB Average Width, Minimum (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,150,null,null,null,null,null,null,null,null,null,{"$f":"IF(V77<>\"\",IF(AND(V77>=50,V77<100),1,IF(AND(V77>=100,V77<150),1.1,IF(V77>=150,1.2))),\"\")","v":""},null,"Y",""]
[null,null,"RFB Area (ac)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(V76<>\"\",V77<>\"\"),(V76*V77)/43560,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(B62<>\"\",V78<>\"\"),IF(B62>(V78*0.25),\"Y\",\"\"),\"\")","v":""},null,"Y",""]
[null,null,"Average Slope within RFB, Maximum (ft/ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V73=\"> 10-Year/24-Hour Storm\",15%,25%)","v":0.25},null,null,null,null,null,null,null,null,null,{"$f":"IF(V79<>\"\",IF(V79>0.06,\"Y\",\"\"),\"\")","v":""},{"$f":"IF(AND(V79>0.15,V73=\"> 10-Year/24-Hour Storm\"),1,0)","v":0},"Y",""]
[null,null,"Flows greater than the 10-year/24-hour storm must be diverted for buffers exceeding 15% slope (change Maximum Storm Event Routed to SCM above to receive 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,"Y","Y"]
[null,null,"Peak inflow velocity @ 2-year/24-hour storm, Maximum (fps)",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q81<>\"\",V81<>\"\"),IF(V81>(Q81*1.1),(V81-(Q81*1.1))/(Q81*1.1),0),\"\")","v":""},{"$f":"IF(OR(AA78=\"Y\",AA79=\"Y\"),\"Y\",\"\")","v":""},"Y"]
[null,null,"Peak inflow velocity @ 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(AND(Q82<>\"\",V82<>\"\"),IF(V82>(Q82*1.1),(V82-(Q82*1.1))/(Q82*1.1),0),\"\")","v":""},{"$f":"IF(OR(AA78=\"Y\",AA79=\"Y\"),\"Y\",\"\")","v":""},"Y"]
[null,null,"Flow depth @ 10-year/24-hour storm, Maximum (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(Q83<>\"\",V83<>\"\"),IF(V83>(Q83*1.1),(V83-(Q83*1.1))/(Q83*1.1),0),\"\")","v":""},{"$f":"IF(OR(AA78=\"Y\",AA79=\"Y\"),\"Y\",\"\")","v":""},"Y"]
[null,null,"Runoff duration following storm routed to SCM, Maximum (hrs)",null,null,null,null,null,null,null,null,null,null,null,null,null,48,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q84<>\"\",V84<>\"\"),IF(V84>(Q84*1.1),(V84-(Q84*1.1))/(Q84*1.1),0),\"\")","v":""},{"$f":"IF(AB7=TRUE,\"Y\",\"\")","v":""},"Y"]
[null,null,"Method used for long-term protection of SCM",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",""]
[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(V85=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC86=\"\",AND(C86<>\"\",AC86=\"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(V85=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC87=\"\",AND(C87<>\"\",AC87=\"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(V88<>\"\",IF(V88=\"Meadow\",1,IF(V88=\"Vegetated Filter Strip\",2,IF(V88=\"Level Spreader\",3))),\"\")","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(Q89<>\"\",V89<>\"\"),IF(V89<(Q89*0.9),((Q89*0.9)-V89)/(Q89*0.9),0),\"\")","v":""},{"$f":"IF(OR(AA88=1,AA88=2),\"Y\",\"\")","v":""},"Y"]
[null,null,"Length (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V76<>\"\",V76,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q90<>\"\",V90<>\"\"),IF(V90<(Q90*0.9),((Q90*0.9)-V90)/(Q90*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,{"$f":"IF(AND(Q91<>\"\",V91<>\"\"),IF(V91>(Q91*1.1),(V91-(Q91*1.1))/(Q91*1.1),0),\"\")","v":""},{"$f":"IF(AA88=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,{"$f":"IF(AND(Q92<>\"\",V92<>\"\"),IF(V92<(Q92*0.9),((Q92*0.9)-V92)/(Q92*0.9),0),\"\")","v":""},{"$f":"IF(AA88=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(Q93<>\"\",V93<>\"\"),IF(V93>(Q93*1.1),(V93-(Q93*1.1))/(Q93*1.1),0),\"\")","v":""},{"$f":"IF(AA88=3,\"Y\",\"\")","v":""},"Y"]
[null,null,"Uniform Canopy Cover (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q94<>\"\",V94<>\"\"),IF(V94<(Q94*0.9),((Q94*0.9)-V94)/(Q94*0.9),0),\"\")","v":""},"Y",{"$f":"IF(V94<>\"\",\"Y\",\"\")","v":""}]
[null,null,{"$f":"CONCATENATE(IF(AA6<>\"\",IF(AA6=1,\"Existing\",IF(AA6=2,\"Converted\",IF(AA6=3,\"New\"))),\"\"),\" Riparian Forest Buffer Species Composition (Top 3):\")","v":" Riparian Forest Buffer Species Composition (Top 3):"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent (%)",null,null,null,null,"Inundation Tolerance",null,null,null,null,null,null,"Y","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C96<>\"\",C96<>\"Other\"),IF(ISNA(VLOOKUP(C96,Ref!$AE$2:$AF$138,2,FALSE))=TRUE,\"\",VLOOKUP(C96,Ref!$AE$2:$AF$138,2,FALSE)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(C96<>\"\",$AA$6<>\"\",C96<>\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V96=\"Intolerant\"),0.1,IF(AND($AA$6=3,V96=\"Intolerant\"),1,0)),0)","v":0},"Y",{"$f":"IF(OR(AC96=\"\",AND(AC96=\"Y\",C96<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C97<>\"\",C97<>\"Other\"),IF(ISNA(VLOOKUP(C97,Ref!$AE$2:$AF$138,2,FALSE))=TRUE,\"\",VLOOKUP(C97,Ref!$AE$2:$AF$138,2,FALSE)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(C97<>\"\",$AA$6<>\"\",C97<>\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V97=\"Intolerant\"),0.1,IF(AND($AA$6=3,V97=\"Intolerant\"),1,0)),0)","v":0},"Y",{"$f":"IF(OR(AC97=\"\",AND(AC97=\"Y\",C97<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C98<>\"\",C98<>\"Other\"),IF(ISNA(VLOOKUP(C98,Ref!$AE$2:$AF$138,2,FALSE))=TRUE,\"\",VLOOKUP(C98,Ref!$AE$2:$AF$138,2,FALSE)),\"\")","v":""},null,null,null,null,{"$f":"IF(AND(C96<>\"Other\",C97<>\"Other\",C98<>\"Other\"),1,IF(AND(C96=\"Other\",C97<>\"Other\",C98<>\"Other\"),2,IF(AND(C96<>\"Other\",C97=\"Other\",C98<>\"Other\"),3,IF(AND(C96<>\"Other\",C97<>\"Other\",C98=\"Other\"),4,IF(AND(C96=\"Other\",C97=\"Other\",C98<>\"Other\"),5,IF(AND(C96=\"Other\",C97<>\"Other\",C98=\"Other\"),6,IF(AND(C96<>\"Other\",C97=\"Other\",C98=\"Other\"),7,IF(AND(C96=\"Other\",C97=\"Other\",C98=\"Other\"),8,\"\"))))))))","v":1},{"$f":"IF(AND(C98<>\"\",$AA$6<>\"\",C98<>\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V98=\"Intolerant\"),0.1,IF(AND($AA$6=3,V98=\"Intolerant\"),1,0)),0)","v":0},"Y",{"$f":"IF(OR(AC98=\"\",AND(AC98=\"Y\",C98<>\"\")),\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q96:Q98)>0,SUM(Q96:Q98),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Y","Y"]
[null,null,"Enter Other Species:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent (%)",null,null,null,null,"Inundation Tolerance",null,null,null,null,null,null,"Y","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(AND(C101<>\"\",$AA$6<>\"\",C96=\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V101=\"Intolerant\"),0.1,IF(AND($AA$6=3,V101=\"Intolerant\"),1,0)),0)","v":0},{"$f":"IF(C96=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC101=\"\",AND(AC101=\"Y\",C101<>\"\",V101<>\"\")),\"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(AND(C102<>\"\",$AA$6<>\"\",C97=\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V102=\"Intolerant\"),0.1,IF(AND($AA$6=3,V102=\"Intolerant\"),1,0)),0)","v":0},{"$f":"IF(C97=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC102=\"\",AND(AC102=\"Y\",C102<>\"\",V102<>\"\")),\"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(AND(C103<>\"\",$AA$6<>\"\",C98=\"Other\"),IF(AND(OR($AA$6=1,$AA$6=2),V103=\"Intolerant\"),0.1,IF(AND($AA$6=3,V103=\"Intolerant\"),1,0)),0)","v":0},{"$f":"IF(C98=\"Other\",\"Y\",\"\")","v":""},{"$f":"IF(OR(AC103=\"\",AND(AC103=\"Y\",C103<>\"\",V103<>\"\")),\"Y\",\"\")","v":"Y"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Q101:Q103)>0,SUM(Q101:Q103),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD104=\"Y\",IF(SUM(AB74:AB103)>1,1,SUM(AB74:AB103)),\"\")","v":""},null,{"$f":"IF(AND(COUNTBLANK(AD73:AD103)=0,Y70<>\"\"),\"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(AD74:AD93)=0,\"Y\",\"\")","v":""}]
[null,null,"Does the RFB 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Credits",null,null,null,null,"Project Site Δ 2","DS Deductions","10% Deduction","Prelim Credit","Credit Limit","Final Credit"]
[null,null,"Runoff Volume (CF):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG114<>\"\",AG114,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(W65<>\"\",W46<>\"\"),W65-W46,\"\")","v":""},{"$f":"IF(AND(AB114<>\"\",$AB$104<>\"\"),AB114*$AB$104,0)","v":0},{"$f":"IF(AND(AB114<>\"\",$AD$6=TRUE),AB114*0.1,0)","v":0},{"$f":"IF(AB114<>\"\",AB114-AC114-AD114,\"\")","v":""},{"$f":"IF(AU58<>\"\",AU58,\"\")","v":""},{"$f":"IF(AND(AE114<>\"\",AF114<>\"\"),IF(AF114<AE114,AF114,AE114),\"\")","v":""}]
[null,null,"TSS Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG115<>\"\",AG115,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(W66<>\"\",W47<>\"\"),W66-W47,\"\")","v":""},{"$f":"IF(AND(AB115<>\"\",$AB$104<>\"\"),AB115*$AB$104,0)","v":0},{"$f":"IF(AND(AB115<>\"\",$AD$6=TRUE),AB115*0.1,0)","v":0},{"$f":"IF(AB115<>\"\",AB115-AC115-AD115,\"\")","v":""},{"$f":"IF($AF$114<$AE$114,(($AF$114/$AE$114)*AE115)-AC115-AD115,AE115)","v":""},{"$f":"IF(AND(AE115<>\"\",AF115<>\"\"),IF(AF115<AE115,AF115,AE115),\"\")","v":""}]
[null,null,"TN Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG116<>\"\",AG116,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(W67<>\"\",W48<>\"\"),W67-W48,\"\")","v":""},{"$f":"IF(AND(AB116<>\"\",$AB$104<>\"\"),AB116*$AB$104,0)","v":0},{"$f":"IF(AND(AB116<>\"\",$AD$6=TRUE),AB116*0.1,0)","v":0},"",{"$f":"IF($AF$114<$AE$114,(($AF$114/$AE$114)*AE116)-AC116-AD116,AE116)","v":""},{"$f":"IF(AND(AE116<>\"\",AF116<>\"\"),IF(AF116<AE116,AF116,AE116),\"\")","v":""}]
[null,null,"TP Load (lbs):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG117<>\"\",AG117,\"\")","v":""},null,null,null,null,{"$f":"IF(AND(W68<>\"\",W49<>\"\"),W68-W49,\"\")","v":""},{"$f":"IF(AND(AB117<>\"\",$AB$104<>\"\"),AB117*$AB$104,0)","v":0},{"$f":"IF(AND(AB117<>\"\",$AD$6=TRUE),AB117*0.1,0)","v":0},"",{"$f":"IF($AF$114<$AE$114,(($AF$114/$AE$114)*AE117)-AC117-AD117,AE117)","v":""},{"$f":"IF(AND(AE117<>\"\",AF117<>\"\"),IF(AF117<AE117,AF117,AE117),\"\")","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":138,"n_cols":32,"rows_kept":138,"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)","RFB_Species","Inundation"]
["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,"Alder, Black (Ilex verticillata)","Tolerant"]
["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,"Alder, Smooth (Alnus serrulata)","Tolerant"]
["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,"Alder, Speckled (Alnus Rugosa)","Tolerant"]
["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,"American Basswood (Tilia americana)","Intolerant"]
["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,"American Beech (Fagus grandifolia)","Intolerant"]
["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,"American Cranberry (Viburnum trilobum)","Intermediate"]
["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,"American smoketree (Cotinus obovatus)","Intermediate"]
["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,"American Sycamore (Platanus occidentalis)","Tolerant"]
["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,null,null,null,null,"Arrowwood, Southern (Viburnum dentatum)","Intermediate"]
["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,null,null,null,null,"Aspen, Big-tooth (Populus grandidentata)","Intolerant"]
["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,null,null,null,null,"Aspen, Quaking (Populus tremuloides)","Intermediate"]
["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,null,null,null,null,"Azalea, Swamp (Rhododendron viscosum)","Tolerant"]
["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,null,null,null,null,"Bald Cypress (Taxodium distichum)","Tolerant"]
["Fallow - Crop Residue Cover (Good Condition)",74,83,88,90,null,216,1.07,7.7,null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basswood, American (Tilia americana)","Intolerant"]
["Row Crops - Straight Row (Poor Condition)",72,81,88,91,null,145,0.55000000000000004,5.71,null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bayberry, Northern (Myrica pennsylvanica)","Intermediate"]
["Row Crops - Straight Row (Good Condition)",67,78,85,89,null,145,0.55000000000000004,5.71,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch, Gray (Betula populifolia)","Intermediate"]
["Row Crops - Straight Row & Crop Residue (Poor Condition)",71,80,87,90,null,216,1.07,7.7,null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch, Paper (Betula papyrifera)","Intolerant"]
["Row Crops - Straight Row & Crop Residue (Good Condition)",64,75,82,85,null,216,1.07,7.7,null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch, River (Betula nigra)","Intermediate"]
["Row Crops - Contoured (Poor Condition)",70,79,84,88,null,145,0.55000000000000004,5.71,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch, Sweet (Betula lenta)","Intermediate"]
["Row Crops - Contoured (Good Condition)",65,75,82,86,null,145,0.55000000000000004,5.71,null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch, Yellow (Betula alleghaniensis)","Intermediate"]
["Row Crops - Contoured & Crop Residue (Poor Condition)",69,78,83,87,null,216,1.07,7.7,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Black Haw (Viburnum prunifolia)","Intolerant"]
["Row Crops - Contoured & Crop Residue (Good Condition)",64,74,81,85,null,216,1.07,7.7,null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Black Locust (Robinia psuedoacacia)","Intolerant"]
["Row Crops - Contoured & Terraced (Poor Condition)",66,74,80,82,null,145,0.55000000000000004,5.71,null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Black Walnut (Juglans nigra)","Intermediate"]
["Row Crops - Contoured & Terraced (Good Condition)",62,71,78,81,null,145,0.55000000000000004,5.71,null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackberry, Common (Rubus allegheniensis)","Intolerant"]
["Row Crops - Contoured, Terraced & Crop Residue (Poor Condition)",65,73,79,81,null,216,1.07,7.7,null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackcap Raspberry (Rubus occidentalis)","Intolerant"]
["Row Crops - Contoured, Terraced & Crop Residue (Good Condition)",61,70,77,80,null,216,1.07,7.7,null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blackgum (Nyssa sylvatica)","Intermediate"]
["Small Grain - Straight Row (Poor Condition)",65,76,84,88,null,145,0.55000000000000004,5.71,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blueberry, Early Low (Vaccinium pallidum)","Intermediate"]
["Small Grain - Straight Row (Good Condition)",63,75,83,87,null,145,0.55000000000000004,5.71,null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blueberry, Highbush (Vaccinium corymbosum)","Intermediate"]
["Small Grain - Straight Row & Crop Residue (Poor Condition)",64,75,83,86,null,216,1.07,7.7,null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blueberry, Lowbush (Vaccinium angustifolium)","Intermediate"]
["Small Grain - Straight Row & Crop Residue (Good Condition)",60,72,80,84,null,216,1.07,7.7,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bottonbush, Common (Cephalanthus occidentalis)","Tolerant"]
["Small Grain - Contoured (Poor Condition)",63,74,82,85,null,145,0.55000000000000004,5.71,null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box Elder (Acer negundo)","Tolerant"]
["Small Grain - Contoured (Good Condition)",61,73,81,84,null,145,0.55000000000000004,5.71,null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buckeyes (Aesculus spp.)","Intermediate"]
["Small Grain - Contoured & Crop Residue (Poor Condition)",62,73,81,84,null,216,1.07,7.7,null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bush Cinquefoil (Dasiphora fruticosa)","Intermediate"]
["Small Grain - Contoured & Crop Residue (Good Condition)",60,72,80,83,null,216,1.07,7.7,null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cedar, Atlantic White (Chamaecyparis thyoides)","Tolerant"]
["Small Grain - Contoured & Terraced (Poor Condition)",61,72,79,82,null,145,0.55000000000000004,5.71,null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cedar, Eastern Red (Juniperus virginiana)","Intolerant"]
["Small Grain - Contoured & Terraced (Good Condition)",59,70,78,81,null,145,0.55000000000000004,5.71,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cherries (Prunus spp.)","Intolerant"]
["Small Grain - Contoured, Terraced & Crop Residue (Poor Condition)",60,71,78,81,null,216,1.07,7.7,null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choke Berry, Black (Aronia melanocarpa)","Intermediate"]
["Small Grain - Contoured, Terraced & Crop Residue (Good Condition)",58,69,77,80,null,216,1.07,7.7,null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choke Berry, Red (Aronia arbutifolia)","Intermediate"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Poor Condition)",66,77,85,89,null,145,0.55000000000000004,5.71,null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cottonwood, Eastern (Populus deltoides)","Intermediate"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Straight Row (Good Condition)",58,72,81,85,null,145,0.55000000000000004,5.71,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crabapples (Malus spp.)","Intolerant"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Poor Condition)",64,75,83,85,null,145,0.55000000000000004,5.71,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crape Myrtle (Lagerstroemia indica)","Intolerant"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured (Good Condition)",55,69,78,83,null,145,0.55000000000000004,5.71,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cucumbertree (Magnolia acuminata)","Intolerant"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Poor Condition)",63,73,80,83,null,145,0.55000000000000004,5.71,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deerberry (Vaccinium stamineum)","Intolerant"]
["Close-Seeded or Broadcast Legumes or Rotation Meadow - Contoured & Terraced (Good Condition)",51,67,76,80,null,145,0.55000000000000004,5.71,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dogwood, Flowering (Cornus florida)","Intolerant"]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Poor Condition)",68,79,86,89,null,48.8,0.22,2.2999999999999998,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dogwood, Gray (Cornus racemosa)","Intermediate"]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Fair Condition)",49,69,79,84,null,48.8,0.22,2.2999999999999998,null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dogwood, Redtwig (Cornus sericia)","Intermediate"]
["Pasture, Grassland, or Range-Continuous Forage for Grazing (Good Condition)",39,61,74,80,null,48.8,0.22,2.2999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dogwood, Silky (Cornus amomum)","Intermediate"]
["Meadow-Continuous Grass, Protected from Grazing and Generally Mowed for Hay",30,58,71,78,null,48.8,0.22,2.2999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Arborvitae (Thuja occidentalis)","Intolerant"]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Poor Condition)",48,67,77,83,null,39,0.15,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Cottonwood (Populus deltoides)","Tolerant"]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Fair Condition)",35,56,70,77,null,39,0.15,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Hemlock","Intolerant"]
["Brush-Forbs-Grass Mixture with Brush the Major Element (Good Condition)",30,48,65,73,null,39,0.15,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Hophornbeam (Ostrya virginiana)","Intermediate"]
["Woods-Grass Combination (Orchard or Tree Farm) (Poor Condition)",57,73,82,86,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Red Cedar (Juniperus virginiana)","Intermediate"]
["Woods-Grass Combination (Orchard or Tree Farm) (Fair Condition)",43,65,76,82,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastern Redbud (Cercis canadensis)","Intolerant"]
["Woods-Grass Combination (Orchard or Tree Farm) (Good Condition)",32,58,72,79,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elderberry (Sambucus canadensis)","Tolerant"]
["Woods (Poor Condition)",45,66,77,83,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elm, American (Ulmus americana)","Intermediate"]
["Woods (Fair Condition)",36,60,73,79,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elm, Slippery (Ulmus rubra)","Intolerant"]
["Woods (Good Condition)",30,55,70,77,null,45,0.13,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fringetree (Chionanthus virginicus)","Intermediate"]
["Farmstead-Buildings, Lanes, Driveways and Surrounding Lots",59,74,82,86,null,65,0.28999999999999998,2.0499999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hackberry (Celtis occidentalis)","Intolerant"]
["Roads (Including ROW) - Dirt",72,82,87,89,null,141,0.43,2.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hackberry, Common (Celtis occidentalis)","Intolerant"]
["Roads (Including ROW) - Gravel",76,85,89,91,null,141,0.43,2.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hawthorn, Cockspur (Crataegus crus-galli)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hawthorn, Frosted (Crataegus pruinosa)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazelnut, American (Corylus americana)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearts-a-burstin' (Euonymus americanus)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hickory, Bitternut (Carya cordiformis)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hickory, Shagbark (Carya ovata)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hickory, Sweet Pignut (Carya glabra)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holly, American (Ilex opaca)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inkberry (Ilex glabra)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ironwood (Carpinus caroliniana)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniper (Juniperus communis)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Magnolia, Sweetbay (Magnolia virginiana)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maple, Red (Acer rubrurn)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maple, Silver (Acer saccharinum)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maple, Sugar (Acer saccharum)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maple-leaved Viburnum (Viburnum acerifolium)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nannyberry (Viburnum lentago)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ninebark (Physocarpus opulifolius)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Bush Honeysuckle (Diervilla lonicera)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Black (Quercus velutina)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Bur (Quercus macrocarpa)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Cherrybark (Quercus pagoda)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Chestnut (Quercus prinus)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Chinkapin (Quercus muehlenbergii)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Pin (Quercus palustris)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Red (Quercus rubra)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Scarlet (Quercus coccinea)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Swamp White (Quercus bicolor)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Water (Quercus nigra)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, White (Quercus alba)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oak, Willow (Quercus phellos)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paw Paw (Asimina triloba)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepperbush, sweet (Clethra alnifolia)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Persimmon (Diospyros virginiana)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pine, Eastern White (Pinus strobus)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pine, Pitch (Pinus rigida)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pine, Scrub (Pinus virginiana)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinxterbloom Azalea (Rhododendron periclymenoides)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Possum Haw (Viburnum nudum)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Chokeberry (Aronia arbutifolia)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Spruce (Picea rubens)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rose, Pasture (Rosa carolina)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rose, Swamp (Rosa palustris)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rose, Virginia (Rosa virginiana)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rosebay (Rhododendron maximum)","Intermediate"]
[null,null,null,null,null,null,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 (Sassafras albidum)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviceberry (Amelanchier canadensis)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviceberry, Downy (Amelanchier arborea)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviceberry, Shadbush (Amelanchier canadensis)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviceberry, Smooth (Amelanchier laevis)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smooth Alder (Alnus serrulata)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spice Bush (Lindera benzoin)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. John's Wort (Hypericum densiflorum, prolificum)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steeplebush (Spiraea tomentosa)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumac, Fragrant (Rhus aromatica)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumac, Smooth (Rhus glabra)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumac, Staghorn (Rhus typhina)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumac, Winged (Rhus copallina)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swamp Sweetbells (Leucothoe racemosa)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweet Birch (Betula lenta)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweetfern (Comptonia peregrina)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweetgum (Liquidambar styraciflua)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trumpet Honeysuckle (Lonicera sempervirens)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuliptree (Liriodendron tulipifera)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virginia Creeper (Parthenocissus quinquefolia)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Virginia Sweet Spire (Itea virginica)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Hickory (Carya aquatica)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White Ash (Fraxinus americana)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White Meadowsweet (Spiraea alba)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White Walnut (Juglans cinerea)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wild Hydrangea (Hydrangea arborescens)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Willow, Black (Salix nigra)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Willow, Pussy (Salix discolor)","Tolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Willow, Sandbar (Salix exigua)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Willow, Silky (Salix sericea)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winterberry, common (Ilex verticillata)","Intermediate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Witchhazel, American (Hamamelis virginiana)","Intolerant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]