{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ITRC Stormwater BMP Tool","BMP"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"ITRC Stormwater BMP Tool","index":0,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Pollutant Screening",null,null,null,null,"Secondary Screening Criteria"]
[null,null,"Select pollutant(s):",null,null,null,null,"Select applicable installation condition(s):"]
[null,null,"Sediments","Y/N",null,null,null,"Installation Conditions","Y/N",null,null,null,"Related Practices (BMP)"]
[null,null,{"$f":"BMP!D4","v":"Total Suspended Solids"},"N",null,null,null,{"$f":"BMP!AO4","v":"Will the BMPs experience freezing conditions?"},"N",null,null,null,{"$f":"BMP!BP4","v":""}]
[null,null,{"$f":"BMP!E4","v":"Suspended Solid Concentration"},"N",null,null,null,{"$f":"BMP!AP4","v":"Will the BMPs experience arid conditions?"},"N",null,null,null,{"$f":"BMP!BP5","v":""}]
[null,null,{"$f":"BMP!F4","v":"Turbidity"},"N",null,null,null,{"$f":"BMP!AQ4","v":"Is there limited space in which to install BMPs?"},"N",null,null,null,{"$f":"BMP!BP6","v":""}]
[null,null,{"$f":"BMP!G4","v":"Total Solids"},"N",null,null,null,{"$f":"BMP!AR4","v":"Are contaminated soils potentially present in the installation area?"},"N",null,null,null,{"$f":"BMP!BP7","v":""}]
[null,null,{"$f":"BMP!H4","v":"Total Dissolved Solids"},"N",null,null,null,{"$f":"BMP!AS4","v":"Will the BMPs be installed in an area with high groundwater?"},"N",null,null,null,{"$f":"BMP!BP8","v":""}]
[null,null,"Metals","Y/N",null,null,null,{"$f":"BMP!AT4","v":"Will the BMPs experience high TSS loads?"},"N",null,null,null,{"$f":"BMP!BP9","v":""}]
[null,null,{"$f":"BMP!I4","v":"Total Dissolved Metals"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP10","v":""}]
[null,null,{"$f":"BMP!J4","v":"Total Copper"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP11","v":""}]
[null,null,{"$f":"BMP!K4","v":"Dissolved Copper"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP12","v":""}]
[null,null,{"$f":"BMP!L4","v":"Total Zinc"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP13","v":""}]
[null,null,{"$f":"BMP!M4","v":"Dissolved Zinc"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP14","v":""}]
[null,null,{"$f":"BMP!N4","v":"Total Lead"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP15","v":""}]
[null,null,{"$f":"BMP!O4","v":"Dissolved Lead"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP16","v":""}]
[null,null,{"$f":"BMP!P4","v":"Total Cadmium"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP17","v":""}]
[null,null,{"$f":"BMP!Q4","v":"Dissolved Cadmium"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP18","v":""}]
[null,null,{"$f":"BMP!R4","v":"Total Chromium"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP19","v":""}]
[null,null,{"$f":"BMP!S4","v":"Dissolved Chromium"},"N",null,null,null,null,null,null,null,null,{"$f":"BMP!BP20","v":""}]
[null,null,{"$f":"BMP!T4","v":"Total Nickel"},"N"]
[null,null,{"$f":"BMP!U4","v":"Dissolved Nickel"},"N"]
[null,null,{"$f":"BMP!V4","v":"Total Arsenic"},"N"]
[null,null,{"$f":"BMP!W4","v":"Dissolved Arsenic"},"N",null,null,null,null,null,null,null,null,"References"]
[null,null,"Nutrients","Y/N"]
[null,null,{"$f":"BMP!X4","v":"Total Nitrogen"},"N"]
[null,null,{"$f":"BMP!Y4","v":"Kjeldahl Nitrogen"},"N",null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(PRIMARY_SCREENER,\"Y\")<>0,\"Pollutant Selected\",\"No Pollutant Selected\")","v":"No Pollutant Selected"}]
[null,null,{"$f":"BMP!Z4","v":"Nitrate/ Nitrite"},"N",null,null,null,null,null,null,null,null,{"$f":"IF(OR(COUNTIF(D7:D46,\"N\")=37,COUNTIF(I7:I12,\"N\")=6),\"No Installation Condition Selected\",\"Installation Condition Selected\")","v":"No Installation Condition Selected"}]
[null,null,{"$f":"BMP!AA4","v":"Ammonia"},"N"]
[null,null,{"$f":"BMP!AB4","v":"Phosphorous"},"N"]
[null,null,{"$f":"BMP!AC4","v":"Ortho-phosphorous"},"N"]
[null,null,"Other","Y/N"]
[null,null,{"$f":"BMP!AD4","v":"Radionuclides"},"N"]
[null,null,{"$f":"BMP!AE4","v":"Oil / Grease"},"N"]
[null,null,{"$f":"BMP!AF4","v":"Total Petroleum Hydrocarbons"},"N"]
[null,null,{"$f":"BMP!AG4","v":"pH"},"N"]
[null,null,{"$f":"BMP!AH4","v":"Bacteria / Pathogens"},"N"]
[null,null,{"$f":"BMP!AI4","v":"PCBs"},"N"]
[null,null,{"$f":"BMP!AJ4","v":"PAHs"},"N"]
[null,null,{"$f":"BMP!AK4","v":"Pesticides"},"N"]
[null,null,{"$f":"BMP!AL4","v":"Herbicides"},"N"]
[null,null,{"$f":"BMP!AM4","v":"BOD / COD"},"N"]
[null,null,{"$f":"BMP!AN4","v":"Trash"},"N"]

{"sheet":"BMP","index":1,"n_rows":40,"n_cols":68,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,3,1,39],[2,3,2,7],[2,8,2,22],[2,23,2,28],[2,29,2,39]]}
["DRAFT  ITRC BMP Refinement Tool"]
[null,null,null,"Pollutants of Concern (See Note 2, below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE!","DO NOT DELETE!",null,"DO NOT DELETE!!"]
[null,null,null,"Sediments",null,null,null,null,"Metals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutrients",null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,"Installation Conditions (Secondary Filter)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Pollutants to Search By","Select Installation Controls to Search By",null,"Related Practices (BMP)"]
[null,"Treatment System Component (TSC) (Note 1, below)","Add Selection","Total Suspended Solids","Suspended Solid Concentration","Turbidity","Total Solids","Total Dissolved Solids","Total Dissolved Metals","Total Copper","Dissolved Copper","Total Zinc","Dissolved Zinc","Total Lead","Dissolved Lead","Total Cadmium","Dissolved Cadmium","Total Chromium","Dissolved Chromium","Total Nickel","Dissolved Nickel","Total Arsenic","Dissolved Arsenic","Total Nitrogen","Kjeldahl Nitrogen","Nitrate/ Nitrite","Ammonia","Phosphorous","Ortho-phosphorous","Radionuclides","Oil / Grease","Total Petroleum Hydrocarbons","pH","Bacteria / Pathogens","PCBs","PAHs","Pesticides","Herbicides","BOD / COD","Trash","Will the BMPs experience freezing conditions?","Will the BMPs experience arid conditions?","Is there limited space in which to install BMPs?","Are contaminated soils potentially present in the installation area?","Will the BMPs be installed in an area with high groundwater?","Will the BMPs experience high TSS loads?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D7=\"Y\",'ITRC Stormwater BMP Tool'!C7,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I7=\"Y\",'ITRC Stormwater BMP Tool'!H7,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B5,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B5,\"\"))","v":""}]
[1,"Soil Management and Soil Amendments","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","Yes","No","Yes","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D8=\"Y\",'ITRC Stormwater BMP Tool'!C8,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I8=\"Y\",'ITRC Stormwater BMP Tool'!H8,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B6,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B6,\"\"))","v":""}]
[2,"Racks and Screens","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D9=\"Y\",'ITRC Stormwater BMP Tool'!C9,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I9=\"Y\",'ITRC Stormwater BMP Tool'!H9,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B7,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B7,\"\"))","v":""}]
[3,"Skimmers and Booms","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D10=\"Y\",'ITRC Stormwater BMP Tool'!C10,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I10=\"Y\",'ITRC Stormwater BMP Tool'!H10,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B8,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B8,\"\"))","v":""}]
[4,"Initial Settling Basins","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D11=\"Y\",'ITRC Stormwater BMP Tool'!C11,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I11=\"Y\",'ITRC Stormwater BMP Tool'!H11,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B9,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B9,\"\"))","v":""}]
[5,"Tanks and Vaults","Yes","Yes","Yes","Yes","Yes","No","NO","Yes","No","Yes","NO","Yes","No","Yes","No","Yes","No","Yes","No","Yes","No","No","No","No","No","Yes","No","No","Yes","Yes","No","Yes","Yes","Yes","No","No","YES","Yes","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D13=\"Y\",'ITRC Stormwater BMP Tool'!C13,\"Add Selection\")","v":"Add Selection"},{"$f":"IF('ITRC Stormwater BMP Tool'!I12=\"Y\",'ITRC Stormwater BMP Tool'!H12,\"Add Selection\")","v":"Add Selection"},null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B10,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B10,\"\"))","v":""}]
[6,"Oil-Water Separators","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D14=\"Y\",'ITRC Stormwater BMP Tool'!C14,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B11,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B11,\"\"))","v":""}]
[7,"Hydrodynamic Separators","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","No","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D15=\"Y\",'ITRC Stormwater BMP Tool'!C15,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B12,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B12,\"\"))","v":""}]
[8,"Sediment Basin","Yes","Yes","Yes","Yes","Yes","No","No","Yes","No","Yes","No","Yes","No","Yes","No","Yes","No","Yes","No","Yes","No","No","No","No","No","Yes","No","No","Yes","Yes","No","Yes","Yes","Yes","No","No","No","Yes","Yes","Yes","No","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D16=\"Y\",'ITRC Stormwater BMP Tool'!C16,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B13,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B13,\"\"))","v":""}]
[9,"Vegetated Systems, Swales and Strips","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","No","No","Yes","No","No","No","No","No","Yes","Yes","No","No","Yes","Yes","YES","YES","YES","Yes","No","Yes","No","No","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D17=\"Y\",'ITRC Stormwater BMP Tool'!C17,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B14,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B14,\"\"))","v":""}]
[10,"Constructed Wetlands","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","No","Yes","Yes","Yes","YES","YES","YES","Yes","No","No","No","No","Yes","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D18=\"Y\",'ITRC Stormwater BMP Tool'!C18,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B15,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B15,\"\"))","v":""}]
[11,"Wet Pond / Wet Basin","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","No","Yes","No","No","No","No","No","Yes","No","No","Yes","Yes","No","Yes","Yes","Yes","No","No","No","Yes","No","No","No","No","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D19=\"Y\",'ITRC Stormwater BMP Tool'!C19,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B16,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B16,\"\"))","v":""}]
[12,"Media Filters","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","No","No","Yes","No","No","Yes","Yes","No","Yes","Yes","Yes","YES","YES","No","Yes","Yes","Yes","Yes","Yes","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D20=\"Y\",'ITRC Stormwater BMP Tool'!C20,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B17,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B17,\"\"))","v":""}]
[13,"Biofilters / Bioretention","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","Yes","No","Yes","No","Yes","No","No","No","No","No","No","No","No","Yes","Yes","No","Yes","Yes","Yes","YES","YES","YES","Yes","No","Yes","Yes","No","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D21=\"Y\",'ITRC Stormwater BMP Tool'!C21,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B18,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B18,\"\"))","v":""}]
[14,"Permeable Pavement","Yes","Yes","Yes","Yes","Yes","No","No","Yes","No","Yes","Yes","Yes","No","No","No","No","No","Yes","Yes","No","No","No","Yes","No","No","Yes","No","No","No","No","No","No","Yes","Yes","No","No","No","No","Yes","Yes","Yes","No","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D22=\"Y\",'ITRC Stormwater BMP Tool'!C22,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B19,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B19,\"\"))","v":""}]
[15,"Infiltration Devices","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","Yes","No","No","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D23=\"Y\",'ITRC Stormwater BMP Tool'!C23,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B20,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B20,\"\"))","v":""}]
[16,"Chemical Treatment","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D24=\"Y\",'ITRC Stormwater BMP Tool'!C24,\"Add Selection\")","v":"Add Selection"},null,null,{"$f":"IF(COUNTIF('ITRC Stormwater BMP Tool'!PRIMARY_SCREENER,\"N\")=37,\"\",IF(AND(LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$4,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$5,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$6,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$7,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$8,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$9,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$10,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$11,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$12,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$13,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$14,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$15,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$16,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$17,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$18,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$19,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$20,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$21,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$22,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$23,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$24,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$25,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$26,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$27,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$28,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$29,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$30,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$31,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$32,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$33,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$34,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$35,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$36,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$37,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$38,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$39,$B$4:$AN$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AN$21,MATCH($BM$40,$B$4:$AN$4,0),FALSE),1)=\"Y\", LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$4,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$5,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$6,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$7,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$8,$B$4:$AT$4,0),FALSE),1)=\"Y\",LEFT(VLOOKUP(B21,$B$5:$AT$21,MATCH($BN$9,$B$4:$AT$4,0),FALSE),1)=\"Y\"),B21,\"\"))","v":""}]
[17,"Disinfection Systems","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('ITRC Stormwater BMP Tool'!D25=\"Y\",'ITRC Stormwater BMP Tool'!C25,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D26=\"Y\",'ITRC Stormwater BMP Tool'!C26,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D27=\"Y\",'ITRC Stormwater BMP Tool'!C27,\"Add Selection\")","v":"Add Selection"}]
["*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D29=\"Y\",'ITRC Stormwater BMP Tool'!C29,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D30=\"Y\",'ITRC Stormwater BMP Tool'!C30,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D31=\"Y\",'ITRC Stormwater BMP Tool'!C31,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D32=\"Y\",'ITRC Stormwater BMP Tool'!C32,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D33=\"Y\",'ITRC Stormwater BMP Tool'!C33,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D34=\"Y\",'ITRC Stormwater BMP Tool'!C34,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D36=\"Y\",'ITRC Stormwater BMP Tool'!C36,\"Add Selection\")","v":"Add Selection"}]
[null,"DO NOT DELETE!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D37=\"Y\",'ITRC Stormwater BMP Tool'!C37,\"Add Selection\")","v":"Add Selection"}]
["Y","Valid List",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D38=\"Y\",'ITRC Stormwater BMP Tool'!C38,\"Add Selection\")","v":"Add Selection"}]
["N","Do Not Delete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D39=\"Y\",'ITRC Stormwater BMP Tool'!C39,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D40=\"Y\",'ITRC Stormwater BMP Tool'!C40,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D41=\"Y\",'ITRC Stormwater BMP Tool'!C41,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D42=\"Y\",'ITRC Stormwater BMP Tool'!C42,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D43=\"Y\",'ITRC Stormwater BMP Tool'!C43,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D44=\"Y\",'ITRC Stormwater BMP Tool'!C44,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D45=\"Y\",'ITRC Stormwater BMP Tool'!C45,\"Add Selection\")","v":"Add Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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('ITRC Stormwater BMP Tool'!D46=\"Y\",'ITRC Stormwater BMP Tool'!C46,\"Add Selection\")","v":"Add Selection"}]