{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Input","BMP Selection Matrix","Tables","Tables (OLD)"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,1],[9,0,9,1]]}
["Aloha! Welcome to the Low Impact Development (LID) Practititioner's Guide Best Management Practice (BMP) Selection tool."]
["This page has instructions on how to gather information for the \"Input\" tab and how to read the results."]
[]
["Choose the land use where the LID BMP will be installed: ","residential, road/highway, commercial, industrial, ultra urban, or retrofit "]
["Find your soil type.\nThis will help determine if you can install a BMP that infiltrates.","Web Soil Survey - Home (usda.gov) Best viewed on a desktop or laptop screen."]
["Depth to groundwater. \nThis information is used with your soil type to determine if you can install a BMP that infiltrates.","Are you located within a couple blocks of a natural stream, spring, or other water body? Are you located at an elevation of 10' mean sea level or lower? If you answered yes to either question, most likely your depth to groundwater is less than 3'. The closer you are to a water body or lower elevation, the closer you are to groundwater. Using this information, estimate the depth to groundwater."]
["Calculate slope.\nThis information is used to determine which BMP can be installed. Some cannot be used on steep slopes!","This is the difference in elevation from where the runoff starts to where your BMP will be divided by the length of that path. \nSearch your smartphone's app store for a slope measurement tool, use the 3D path tool in Google Earth, or get outside with a measuring tape!"]
["Do you have space to install a BMP?","Measure the available area and use the BMP Fact Sheets Minimum Area Requirement to find which BMPs could fit and select from the list. You can select all that apply."]
["What are you treating for?","Select which pollutants you are targeting from the list. You can select all that apply."]
[]
["After all the fields are filled, the scores will appear next to the LID BMP list on the right. \nThe top 3 scores will be highlighted green for you to check out!"]

{"sheet":"Input","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"Select/input your answer here",null,"TOTAL POINTS","BMP TYPE"]
[1,"Choose your land use:","Residential",null,{"$f":"'BMP Selection Matrix'!P15","v":17},"Infiltration Basin"]
[2,"Find your soil type here: ","B",null,{"$f":"'BMP Selection Matrix'!P16","v":22},"Infiltration Trench"]
[3,"Depth to groundwater","1'",null,{"$f":"'BMP Selection Matrix'!P17","v":26},"Dry Well"]
[4,"Slope (%)",0.05,"See your top 3",{"$f":"'BMP Selection Matrix'!P18","v":16},"Bioretention Basin (Rain Garden)"]
[null,null,null,null,{"$f":"'BMP Selection Matrix'!P19","v":19},"Permeable Pavement"]
[5,"Do you have space for a(n):",null,null,{"$f":"'BMP Selection Matrix'!P20","v":39},"Harvesting/ Reuse"]
[null,"Infiltration Basin","Yes",null,{"$f":"'BMP Selection Matrix'!P21","v":29},"Green Roof"]
[null,"Infiltration Trench","Yes",null,{"$f":"'BMP Selection Matrix'!P22","v":28},"Tree/Planter Box\n(Vegetated Bio-Filter)"]
[null,"Dry Well","Yes",null,{"$f":"'BMP Selection Matrix'!P23","v":21},"Enhanced Swale"]
[null,"Bioretention Basin (Rain Garden)","Yes",null,{"$f":"'BMP Selection Matrix'!P24","v":21},"Vegetated Swale"]
[null,"Permeable Pavement","Yes",null,{"$f":"'BMP Selection Matrix'!P25","v":38},"Vegetated Filter Strip"]
[null,"Harvesting/ Reuse","Yes",null,{"$f":"'BMP Selection Matrix'!P26","v":17},"Detention Basin"]
[null,"Green Roof","Yes"]
[null,"Tree/Planter Box \n(Vegetated Bio-Filter)","Yes"]
[null,"Enhanced Swale","Yes"]
[null,"Vegetated Swale","Yes"]
[null,"Vegetated Filter Strip","Yes"]
[null,"Detention Basin","Yes"]
[]
[6,"What are you treating for?"]
[null,"Nutrients"]
[null,"Sediments"]
[null,"Trash"]
[null,"Pathogens"]
[null,"Pesticides"]
[null,"Oil & Grease"]
[null,"Metals"]
[null,"Organic Compounds"]

{"sheet":"BMP Selection Matrix","index":2,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":true,"merged":[[5,14,13,14],[5,15,13,15],[4,5,4,6],[5,5,5,6],[4,7,4,9],[6,5,13,5],[5,7,5,8],[6,6,13,6],[5,10,13,10],[5,11,13,11],[5,12,13,12],[5,13,13,13],[6,0,13,0],[6,1,13,1],[6,2,13,2],[6,3,13,3],[6,4,13,4]]}
[null,"USER DEFINED SELECTION (EDITABLE)"]
[null,"SYSTEM DEFINED VALUE (NON-EDITABLE)"]
[null,"SYSTEM CALCULATED VALUE (NON-EDITABLE)"]
[]
["BMP TYPE","LAND USE","NRCS SOIL GROUP","DEPTH TO WATER TABLE FROM BOTTOM OF BMP","LAND SLOPE AT BMP LOCATION","AVAILABLE SPACE FOR BMP",null,"TARGETED POLLUTANTS",null,null,"COMMUNITY ACCEPTANCE OF BMP","HABITAT QUALITY OF BMP","BMP SAFETY CONCERNS","CONSTRUCTION COST","MAINTENANCE EFFORT","TOTAL POINTS"]
[null,"(Select Below)","(Select Below)","(Select Below)","(Input Slope Below)","(Select for Each BMP)",null,"(Select \"X\" for Pollutants)",null,"Points","Points","Points","Points","Points","Points"]
["SELECTION",{"$f":"Input!C2","v":"Residential"},{"$f":"Input!C3","v":"B"},{"$f":"Input!C4","v":"1'"},{"$f":"Input!C5","v":0.05},null,null,"Nutrients",{"$f":"Input!C22","v":0}]
[null,null,null,null,null,null,null,"Sediment",{"$f":"Input!C23","v":0}]
[null,null,null,null,null,null,null,"Trash",{"$f":"Input!C24","v":0}]
[null,null,null,null,null,null,null,"Pathogens",{"$f":"Input!C25","v":0}]
[null,null,null,null,null,null,null,"Pesticides",{"$f":"Input!C26","v":0}]
[null,null,null,null,null,null,null,"Oil & Grease",{"$f":"Input!C27","v":0}]
[null,null,null,null,null,null,null,"Metals",{"$f":"Input!C28","v":0}]
[null,null,null,null,null,null,null,"Organic Compound",{"$f":"Input!C29","v":0}]
["Infiltration Basin",{"$f":"INDEX('Tables (OLD)'!B2:B6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"-5\", \"D\", \"-5\")","v":"5"},{"$f":"INDEX(Tables!B19:B22,MATCH(D7,Tables!A19:A22,0))","v":-5},{"$f":"IF(E7<=20%, \"5\", \"-5\")","v":"5"},{"$f":"Input!C8","v":"Yes"},{"$f":"_xlfn.SWITCH(F15,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O4,\"0\"))+N(IF($I$8=\"x\",Tables!P4,\"0\"))+N(IF($I$9=\"x\",Tables!Q4,\"0\"))+N(IF($I$10=\"x\",Tables!R4,\"0\"))+N(IF($I$11=\"x\",Tables!S4,\"0\"))+N(IF($I$12=\"x\",Tables!T4,\"0\"))+N(IF($I$13=\"x\",Tables!U4,\"0\"))+N(IF($I$14=\"x\",Tables!V4+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},3,3,3,3,0,{"$f":"SUM(B15:O15)","v":17}]
["Infiltration Trench",{"$f":"INDEX('Tables (OLD)'!C2:C6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"-5\", \"D\", \"-5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!C10:C13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=15%, \"5\",\"-5\")","v":"5"},{"$f":"Input!C9","v":"Yes"},{"$f":"_xlfn.SWITCH(F16,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O5,\"0\"))+N(IF($I$8=\"x\",Tables!P5,\"0\"))+N(IF($I$9=\"x\",Tables!Q5,\"0\"))+N(IF($I$10=\"x\",Tables!R5,\"0\"))+N(IF($I$11=\"x\",Tables!S5,\"0\"))+N(IF($I$12=\"x\",Tables!T5,\"0\"))+N(IF($I$13=\"x\",Tables!U5,\"0\"))+N(IF($I$14=\"x\",Tables!V5+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,1,5,3,3,22]
["Dry Well",{"$f":"INDEX('Tables (OLD)'!D2:D6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"-5\", \"D\", \"-5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!D10:D13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=15%, \"5\", \"-5\")","v":"5"},{"$f":"Input!C10","v":"Yes"},{"$f":"_xlfn.SWITCH(F17,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O6,\"0\"))+N(IF($I$8=\"x\",Tables!P6,\"0\"))+N(IF($I$9=\"x\",Tables!Q6,\"0\"))+N(IF($I$10=\"x\",Tables!R6,\"0\"))+N(IF($I$11=\"x\",Tables!S6,\"0\"))+N(IF($I$12=\"x\",Tables!T6,\"0\"))+N(IF($I$13=\"x\",Tables!U6,\"0\"))+N(IF($I$14=\"x\",Tables!V6+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,1,5,5,5,26]
["Bioretention Basin (Rain Garden)",{"$f":"INDEX('Tables (OLD)'!E2:E6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"-5\", \"D\", \"-5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!E10:E13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=20%, \"5\", \"-5\")","v":"5"},{"$f":"Input!C11","v":"Yes"},{"$f":"_xlfn.SWITCH(F18,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O7,\"0\"))+N(IF($I$8=\"x\",Tables!P7,\"0\"))+N(IF($I$9=\"x\",Tables!Q7,\"0\"))+N(IF($I$10=\"x\",Tables!R7,\"0\"))+N(IF($I$11=\"x\",Tables!S7,\"0\"))+N(IF($I$12=\"x\",Tables!T7,\"0\"))+N(IF($I$13=\"x\",Tables!U7,\"0\"))+N(IF($I$14=\"x\",Tables!V7+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},3,3,5,0,0,16]
["Permeable Pavement",{"$f":"INDEX('Tables (OLD)'!F2:F6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"-5\", \"D\", \"-5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!F10:F13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=5%, \"5\",\"-5\")","v":"5"},{"$f":"Input!C12","v":"Yes"},{"$f":"_xlfn.SWITCH(F19,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O8,\"0\"))+N(IF($I$8=\"x\",Tables!P8,\"0\"))+N(IF($I$9=\"x\",Tables!Q8,\"0\"))+N(IF($I$10=\"x\",Tables!R8,\"0\"))+N(IF($I$11=\"x\",Tables!S8,\"0\"))+N(IF($I$12=\"x\",Tables!T8,\"0\"))+N(IF($I$13=\"x\",Tables!U8,\"0\"))+N(IF($I$14=\"x\",Tables!V8+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,1,5,0,3,19]
["Harvesting/ Reuse",{"$f":"INDEX('Tables (OLD)'!G2:G6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!G10:G13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":5},5,{"$f":"Input!C13","v":"Yes"},{"$f":"_xlfn.SWITCH(F20,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O9,\"0\"))+N(IF($I$8=\"x\",Tables!P9,\"0\"))+N(IF($I$9=\"x\",Tables!Q9,\"0\"))+N(IF($I$10=\"x\",Tables!R9,\"0\"))+N(IF($I$11=\"x\",Tables!S9,\"0\"))+N(IF($I$12=\"x\",Tables!T9,\"0\"))+N(IF($I$13=\"x\",Tables!U9,\"0\"))+N(IF($I$14=\"x\",Tables!V9+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},3,1,5,5,5,39]
["Green Roof",{"$f":"INDEX('Tables (OLD)'!H2:H6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":0},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!H10:H13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":5},5,{"$f":"Input!C14","v":"Yes"},{"$f":"_xlfn.SWITCH(F21,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O10,\"0\"))+N(IF($I$8=\"x\",Tables!P10,\"0\"))+N(IF($I$9=\"x\",Tables!Q10,\"0\"))+N(IF($I$10=\"x\",Tables!R10,\"0\"))+N(IF($I$11=\"x\",Tables!S10,\"0\"))+N(IF($I$12=\"x\",Tables!T10,\"0\"))+N(IF($I$13=\"x\",Tables!U10,\"0\"))+N(IF($I$14=\"x\",Tables!V10+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,3,3,3,0,29]
["Tree/Planter Box (Vegetated Bio-Filter)",{"$f":"INDEX('Tables (OLD)'!I2:I6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!I10:I13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},5,{"$f":"Input!C15","v":"Yes"},{"$f":"_xlfn.SWITCH(F22,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O11,\"0\"))+N(IF($I$8=\"x\",Tables!P11,\"0\"))+N(IF($I$9=\"x\",Tables!Q11,\"0\"))+N(IF($I$10=\"x\",Tables!R11,\"0\"))+N(IF($I$11=\"x\",Tables!S11,\"0\"))+N(IF($I$12=\"x\",Tables!T11,\"0\"))+N(IF($I$13=\"x\",Tables!U11,\"0\"))+N(IF($I$14=\"x\",Tables!V11+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,3,5,0,5,{"$f":"SUM(B22:O22)","v":28}]
["Enhanced Swale",{"$f":"INDEX('Tables (OLD)'!J2:J6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!J10:J13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=5%, \"5\",\"-5\")","v":"5"},{"$f":"Input!C16","v":"Yes"},{"$f":"_xlfn.SWITCH(F23,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O12,\"0\"))+N(IF($I$8=\"x\",Tables!P12,\"0\"))+N(IF($I$9=\"x\",Tables!Q12,\"0\"))+N(IF($I$10=\"x\",Tables!R12,\"0\"))+N(IF($I$11=\"x\",Tables!S12,\"0\"))+N(IF($I$12=\"x\",Tables!T12,\"0\"))+N(IF($I$13=\"x\",Tables!U12,\"0\"))+N(IF($I$14=\"x\",Tables!V12+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,3,5,0,3,21]
["Vegetated Swale",{"$f":"INDEX('Tables (OLD)'!K2:K6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!K10:K13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=6%, \"5\", \"-5\")","v":"5"},{"$f":"Input!C17","v":"Yes"},{"$f":"_xlfn.SWITCH(F24,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O13,\"0\"))+N(IF($I$8=\"x\",Tables!P13,\"0\"))+N(IF($I$9=\"x\",Tables!Q13,\"0\"))+N(IF($I$10=\"x\",Tables!R13,\"0\"))+N(IF($I$11=\"x\",Tables!S13,\"0\"))+N(IF($I$12=\"x\",Tables!T13,\"0\"))+N(IF($I$13=\"x\",Tables!U13,\"0\"))+N(IF($I$14=\"x\",Tables!V13+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,3,5,0,3,21]
["Vegetated Filter Strip",{"$f":"INDEX('Tables (OLD)'!M2:M6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":5},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!M10:M13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":5},{"$f":"IF(E7<=15%, \"5\",\"-5\")","v":"5"},{"$f":"Input!C18","v":"Yes"},{"$f":"_xlfn.SWITCH(F25,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O15,\"0\"))+N(IF($I$8=\"x\",Tables!P15,\"0\"))+N(IF($I$9=\"x\",Tables!Q15,\"0\"))+N(IF($I$10=\"x\",Tables!R15,\"0\"))+N(IF($I$11=\"x\",Tables!S15,\"0\"))+N(IF($I$12=\"x\",Tables!T15,\"0\"))+N(IF($I$13=\"x\",Tables!U15,\"0\"))+N(IF($I$14=\"x\",Tables!V15+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},5,3,5,5,5,38]
["Detention Basin",{"$f":"INDEX('Tables (OLD)'!N2:N6,MATCH('BMP Selection Matrix'!B7,'Tables (OLD)'!A2:A6,0))","v":0},{"$f":"_xlfn.SWITCH($C$7,\"A\", \"5\", \"B\", \"5\", \"C\", \"5\", \"D\", \"5\")","v":"5"},{"$f":"INDEX('Tables (OLD)'!N10:N13,MATCH(D7,'Tables (OLD)'!A10:A13,0))","v":-5},{"$f":"IF(E7<=20%, \"5\",\"-5\")","v":"5"},{"$f":"Input!C19","v":"Yes"},{"$f":"_xlfn.SWITCH(F26,\"Yes\",5,\"Maybe\",0,\"Probably not\", -5)","v":5},null,null,{"$f":"IFERROR(ROUND(((N(IF($I$7=\"x\",Tables!O16,\"0\"))+N(IF($I$8=\"x\",Tables!P16,\"0\"))+N(IF($I$9=\"x\",Tables!Q16,\"0\"))+N(IF($I$10=\"x\",Tables!R16,\"0\"))+N(IF($I$11=\"x\",Tables!S16,\"0\"))+N(IF($I$12=\"x\",Tables!T16,\"0\"))+N(IF($I$13=\"x\",Tables!U16,\"0\"))+N(IF($I$14=\"x\",Tables!V16+\"0\")))/COUNTA($I$7:$I$14)),0),\"\")","v":0},3,3,3,3,5,17]

{"sheet":"Tables","index":3,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["BMP Type","Residential","Roads/Highways","Commercial","Ultra Urban","Retrofits",null,null,"0'","1'","2'","≥3'",null,null,"Nutrients","Sediment","Trash","Pathogens","Pesticides","Oil & Grease","Metals","Organic Compound"]
["hlookup ref:",1,2,3,4,5,null,null,6,7,8,9,null,null,10,11,12,13,14,15,16,17]
[]
["Infilration Basin",5,0,5,0,5,null,"Infilration Basin",-5,-5,-5,5,null,"Infilration Basin",5,5,5,5,5,5,5,5]
["Infilration Trench",5,5,5,5,5,null,"Infilration Trench",-5,-5,-5,5,null,"Infilration Trench",5,5,5,5,5,5,5,5]
["Dry Well",5,5,5,5,5,null,"Dry Well",-5,-5,-5,5,null,"Dry Well",5,5,5,5,5,5,5,5]
["Bioretention Basin(Rain Garden)",5,5,5,0,5,null,"Bioretention Basin(Rain Garden)",-5,-5,-5,5,null,"Bioretention Basin(Rain Garden)",5,5,5,5,5,5,5,5]
["Permeable Pavement ",5,0,5,5,5,null,"Permeable Pavement ",-5,-5,-5,5,null,"Permeable Pavement ",5,5,1,5,5,5,5,5]
["Harvesting/Reuse",5,5,5,5,5,null,"Harvesting/Reuse","n/a","n/a","n/a","n/a",null,"Harvesting/Reuse",5,5,1,5,5,5,5,5]
["Green Roof",0,5,5,5,5,null,"Green Roof","n/a","n/a","n/a","n/a",null,"Green Roof",3,5,5,3,3,5,3,3]
["Tree/Planter Box (Vegetated Bio-Filter)",5,5,5,5,5,null,"Tree/Planter Box (Vegetated Bio-Filter)","Data",-5,-5,5,null,"Tree/Planter Box (Vegetated Bio-Filter)",3,5,5,3,"Null",5,5,5]
["Enhanced Swale",5,5,5,0,0,null,"Enhanced Swale",-5,-5,-5,5,null,"Enhanced Swale",3,5,5,null,"Null",3,3,"Null"]
["Vegetated Swale",5,5,5,0,0,null,"Vegetated Swale",-5,-5,5,5,null,"Vegetated Swale",1,3,1,1,"Null",3,3,"Null"]
["Downspout Disconnection",5,5,5,0,5,null,"Downspout Disconnection","n/a","n/a","n/a","n/a",null,"Downspout Disconnection",5,5,1,5,"Null",5,5,"Null"]
["Vegetated Filter Strip",5,5,5,0,5,null,"Vegetated Filter Strip","n/a","n/a","n/a","n/a",null,"Vegetated Filter Strip",1,3,3,1,"Null",3,3,3]
["Detention Basin",0,0,0,5,5,null,"Detention Basin",-5,-5,-5,5,null,"Detention Basin",1,3,5,1,"Null",3,2,"Null"]
[]
[null,"Infilration Basin","Infilration Trench","Dry Well","Bioretention Basin(Rain Garden)","Permeable Pavement ","Harvesting/Reuse","Green Roof","Tree/Planter Box (Vegetated Bio-Filter)","Enhanced Swale","Vegetated Swale","Downspout Disconnection","Vegetated Filter Strip","Detention Basin"]
["0'",-5,-5,-5,-5,-5,5,5,-5,-5,-5,5,5,-5]
["1'",-5,-5,-5,-5,-5,5,5,-5,-5,-5,5,5,-5]
["2'",-5,-5,-5,-5,-5,5,5,-5,-5,5,5,5,-5]
["≥3'",5,5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[null,"Infilration Basin","Infilration Trench","Dry Well","Bioretention Basin(Rain Garden)","Permeable Pavement ","Harvesting/Reuse","Green Roof","Tree/Planter Box (Vegetated Bio-Filter)","Enhanced Swale","Vegetated Swale","Downspout Disconnection","Vegetated Filter Strip","Detention Basin"]
["Nutrients",5,5,5,5,5,5,3,3,3,1,5,1,1]
["Sediment",5,5,5,5,5,5,5,5,5,3,5,3,3]
["Trash",5,5,5,5,1,1,5,5,5,1,1,3,5]
["Pathogens",5,5,5,5,5,5,3,3,null,1,5,1,1]
["Pesticides",5,5,5,5,5,5,3,"Null","Null","Null","Null","Null","Null"]
["Oil & Grease",5,5,5,5,5,5,5,5,3,3,5,3,3]
["Metals",5,5,5,5,5,5,3,5,3,3,5,3,2]
["Organic Compound",5,5,5,5,5,5,3,5,"Null","Null","Null",3,"Null"]

{"sheet":"Tables (OLD)","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["BMP Type","Infilration Basin","Infilration Trench","Dry Well","Bioretention Basin(Rain Garden)","Permeable Pavement ","Harvesting/Reuse","Green Roof","Tree/Planter Box (Vegetated Bio-Filter)","Enhanced Swale","Vegetated Swale","Downspout Disconnection","Vegetated Filter Strip","Detention Basin"]
["Residential",5,5,5,5,5,5,0,5,5,5,5,5,0]
["Roads/Highways",0,5,5,5,0,5,5,5,5,5,5,5,0]
["Commercial",5,5,5,5,5,5,5,5,5,5,5,5,0]
["Ultra Urban",0,5,5,0,5,5,5,5,0,0,0,0,5]
["Retrofits",5,5,5,5,5,5,5,5,0,0,5,5,5]
[]
[]
[null,"Infilration Basin","Infilration Trench","Dry Well","Bioretention Basin(Rain Garden)","Permeable Pavement ","Harvesting/Reuse","Green Roof","Tree/Planter Box (Vegetated Bio-Filter)","Enhanced Swale","Vegetated Swale","Downspout Disconnection","Vegetated Filter Strip","Detention Basin"]
["0'",-5,-5,-5,-5,-5,5,5,-5,-5,-5,5,5,-5]
["1'",-5,-5,-5,-5,-5,5,5,-5,-5,-5,5,5,-5]
["2'",-5,-5,-5,-5,-5,5,5,-5,-5,5,5,5,-5]
["≥3'",5,5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[null,"Infilration Basin","Infilration Trench","Dry Well","Bioretention Basin(Rain Garden)","Permeable Pavement ","Harvesting/Reuse","Green Roof","Tree/Planter Box (Vegetated Bio-Filter)","Enhanced Swale","Vegetated Swale","Downspout Disconnection","Vegetated Filter Strip","Detention Basin"]
["Nutrients",5,5,5,5,5,5,3,3,3,1,5,1,1]
["Sediment",5,5,5,5,5,5,5,5,5,3,5,3,3]
["Trash",5,5,5,5,1,1,5,5,5,1,1,3,5]
["Pathogens",5,5,5,5,5,5,3,3,null,1,5,1,1]
["Pesticides",5,5,5,5,5,5,3,"Null","Null","Null","Null","Null","Null"]
["Oil & Grease",5,5,5,5,5,5,5,5,3,3,5,3,3]
["Metals",5,5,5,5,5,5,3,5,3,3,5,3,2]
["Organic Compound",5,5,5,5,5,5,3,5,"Null","Null","Null",3,"Null"]
[]
[]
["nutrients, sediment"]