{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ESD Summary","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"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":"ESD Summary","index":0,"n_rows":1245,"n_cols":33,"rows_kept":1245,"cut":false,"hidden":false,"merged":[[4,7,4,9],[95,20,98,24],[100,20,103,24],[105,20,108,24],[110,20,113,24],[99,20,99,23],[109,20,109,23],[75,20,78,24],[80,20,83,24],[64,20,64,23],[85,20,88,24],[104,20,104,23],[89,20,89,23],[84,20,84,23],[79,20,79,23],[94,20,94,23],[90,20,93,24],[35,20,38,24],[40,20,43,24],[9,4,10,4],[24,20,24,23],[19,20,19,23],[13,20,13,23],[9,19,10,19],[29,20,29,23],[34,20,34,23],[9,7,9,8],[0,28,0,30],[1,28,1,30],[2,28,2,30],[3,28,3,30],[4,28,4,30],[20,20,23,24],[5,1,5,24],[7,10,8,10],[7,4,8,4],[7,1,10,1],[7,9,8,9],[9,2,10,2],[9,17,10,17],[9,9,10,9],[6,1,6,13],[7,15,8,15],[9,5,9,6],[7,5,8,5],[7,3,8,3],[59,20,59,23],[69,20,69,23],[50,20,53,24],[74,20,74,23],[45,20,48,24],[55,20,58,24],[60,20,63,24],[54,20,54,23],[65,20,68,24],[70,20,73,24],[14,20,18,24],[9,13,10,13],[49,20,49,23],[6,20,8,23],[7,17,8,17],[7,18,8,18],[10,22,10,23],[9,20,9,21],[9,22,9,23],[6,14,6,19],[44,20,44,23],[9,3,10,3],[10,20,10,21],[7,11,8,11],[7,19,8,19],[25,20,28,24],[6,24,12,24],[7,13,8,13],[9,14,12,14],[7,14,8,14],[39,20,39,23],[9,16,10,16],[9,10,10,10],[9,11,10,11],[11,22,12,23],[11,20,12,21],[30,20,33,24],[9,15,12,15],[9,18,10,18],[9,12,10,12],[2,10,2,20],[3,10,3,14],[4,10,4,14],[0,1,0,24],[7,7,8,7],[7,8,8,8],[7,12,8,12],[7,16,8,16],[7,2,8,2],[7,6,8,6]]}
[null,"MDE Sediment & Stormwater Plan Review\nfor State & Federal Projects",null,null,null,null,null,null,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":"H5&\" \"&K5","v":"MDE Tracking Number: "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job #",null,null,null,null,null,null,null,null,{"$f":"LEFT(H5,3)","v":"MDE"}]
[null,null,null,null,null,null,null,null,null,"Project Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,"Contract Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Designed by:"]
[null,null,null,null,null,null,null,"MDE Tracking Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checked by:"]
[null,"ESD SUMMARY SHEET"]
[null,"Required ESD Management",null,null,null,null,null,null,null,null,null,null,null,null,"Provided ESD Management",null,null,null,null,null,"ESDv and Rev \nRequirements",null,null,null,"Is the POI Requirement met?"]
[null,"Point of Investigation","Col. 1","Col. 2","Col. 3","Col. 4a","Col. 4b","Col. 5a","Col. 5b","Col. 6","Col. 7","Col. 8","Col. 9","Col. 10","Col. 11","Col. 12","Col. 13","Col. 14","Col. 15","Col. 16"]
[]
[null,null,"IARTRE-DEV’L","IARTNEW","ESDV RE-DEV'L\n(PE=1.0 in)","ESDV reducedAi",null,"ESDV NEW",null,"ESDV SHIFT\n(PE = 2.6 in)","ESDV Loss","Required ESDV\nfor POI      =4b\n+5b+6\n+7","Required ESDV\nfor PROJECT        =Σ3+Σ4a\n+Σ5a+Σ5b\n+Σ6+Σ7","Required\nReV","Type of Practice","BMP Number","PE Treated by Practice","Provided\nESDV","ESDV from WQ Bank Debit","Provided \nReV","ESDv Project  Requirement ",null,"Rev Project Requirement "]
[null,null,null,null,null,"Reduction Applied to Project\n(PE = 1.0 in)  ","Reduction Applied to POI\n(PE = 2.6 in)  ","For 3.3.B Waivers\n(PE = 1 in)","(PE =\n 2 to 2.6 in)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Provided ESDv \"&(R12+S12)&\" \"&\"cf\n\"&\" \"&IF((R12-M12+S12)>=0,\">=\",\"<\")&\"\n \"&M12&\" \"&\"cf\"","v":"Provided ESDv 0 cf\n >=\n 0 cf"},null,{"$f":"\" Provided Rev   \"\n&T12&\" \"&\"cf\n\"&IF((T12-N12)>=0,\">=\",\"<\")&\"\n \"&N12&\" \"&\"cf\"","v":" Provided Rev   0 cf\n>=\n 0 cf"}]
[null,"Total ≫≫",{"$f":"Sheet1!R32","v":0},{"$f":"Sheet1!S32","v":0},{"$f":"Sheet1!T32","v":0},{"$f":"Sheet1!U32","v":0},null,{"$f":"Sheet1!W32","v":0},{"$f":"Sheet1!X32","v":0},{"$f":"Sheet1!Y32","v":0},{"$f":"Sheet1!Z32","v":0},null,{"$f":"E12+F12+H12+I12+J12+K12","v":0},{"$f":"Sheet1!P32","v":0},null,null,null,{"$f":"Sheet1!L32","v":0},null,{"$f":"Sheet1!O32","v":0},{"$f":"IF((R12-M12+S12)<0,\"CHECK: FAIL\",\"CHECK: OK\")","v":"CHECK: OK"},null,{"$f":"IF((T12-N12)<0,\"CHECK: FAIL\",\"CHECK: OK\")","v":"CHECK: OK"},null,null,null,null,null,null,{"$f":"OR(AND(H14>0,J14<=0,J14=ROUND(J14,1),AND(OR(H14=\"\",H14=0),J14>=0,J14=ROUND(J14,1))))","v":false}]
[null,"Units ≫≫","acres","acres","cubic feet","cubic feet","cubic feet","cubic feet","cubic feet","Cubic feet","Cubic feet","Cubic feet","Cubic feet","Cubic feet",null,null,"inches","Cubic feet","Cubic feet","Cubic feet",null,null,null,null,null,null,null,null,null,{"$f":"AND(OR(AND(H14>0,J14<=0),AND(H14=\"\",H14=0,J14>=0),(J14=ROUND(J14,1))))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G14+I14+J14+K14)>0,(G14+I14+J14+K14),0)","v":0},null,0,null,null,null,null,null,null,{"$f":"IF($B14=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B14,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z14)>=0,\">=\",\"<\")&\" \"&L14&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B14=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B14,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B14,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B14,Sheet1!$J$2:$J$31,0))","v":0},null,null,null,{"$f":"AND(OR(AND(H14>0,J14<=0),AND(OR(H14=\"\",H14=0))),J14=ROUND(J14,1))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"\",\"\",IF(AND((R12-M12+S12)<0,Z14<0),Sheet1!$AY$1,IF((R12-M12+S12)<0,Sheet1!$AQ$1,IF(Z14<0,Sheet1!$AI$1,\"\"))))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B15,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B15,Sheet1!$J$2:$J$31,0))","v":0},null,null,null,null,{"$f":"AND(OR(H15=\"\",H15=0,J15=0),OR(J15=ROUND(J15,1)))","v":true}]
[]
[null,null,null,null,null,null,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":"AND(OR(H17=\"\",H17=0,J17=0),OR(J17=ROUND(J17,1)))","v":true}]
[null,null,null,null,null,null,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":"AND(OR(H18=\"\",H18=0,J18=0),OR(J18=ROUND(J18,1)))","v":true}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B19,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B19,Sheet1!$J$2:$J$31,0))","v":0},null,null,null,null,{"$f":"AND(OR(H19=\"\",H19=0,J19=0),OR(J19=ROUND(J19,1)))","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G20+I20+J20+K20)>0,(G20+I20+J20+K20),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B20=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B20,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z20)>=0,\">=\",\"<\")&\" \"&L20&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B20=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B20,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B20,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B20,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B20=\"\",\"\",IF(Z20<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B21,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B21,Sheet1!$J$2:$J$31,0))","v":0}]
[]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B23,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B23,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B24,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B24,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G25+I25+J25+K25)>0,(G25+I25+J25+K25),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B25=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B25,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z25)>=0,\">=\",\"<\")&\" \"&L25&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B25=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B25,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B25,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B25,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B25=\"\",\"\",IF(Z25<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B26,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B26,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B27,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B27,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B28,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B28,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B29,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B29,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G30+I30+J30+K30)>0,(G30+I30+J30+K30),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B30=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B30,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z30)>=0,\">=\",\"<\")&\" \"&L30&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B30=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B30,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B30,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B30,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(Z30<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B31,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B31,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B32,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B32,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B33,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B33,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B34,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B34,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G35+I35+J35+K35)>0,(G35+I35+J35+K35),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B35=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B35,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z35)>=0,\">=\",\"<\")&\" \"&L35&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B35=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B35,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B35,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B35,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(Z35<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B36,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B36,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B37,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B37,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B38,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B38,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B39,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B39,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G40+I40+J40+K40)>0,(G40+I40+J40+K40),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B40=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B40,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z40)>=0,\">=\",\"<\")&\" \"&L40&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B40=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B40,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B40,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B40,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"\",\"\",IF(Z40<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B41,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B41,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B42,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B42,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B43,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B43,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B44,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B44,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G45+I45+J45+K45)>0,(G45+I45+J45+K45),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B45=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B45,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z45)>=0,\">=\",\"<\")&\" \"&L45&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B45=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B45,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B45,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B45,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",IF(Z45<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B46,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B46,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B47,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B47,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B48,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B48,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B49,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B49,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G50+I50+J50+K50)>0,(G50+I50+J50+K50),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B50=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B50,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z50)>=0,\">=\",\"<\")&\" \"&L50&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B50=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B50,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B50,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B50,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",IF(Z50<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B51,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B51,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B52,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B52,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B53,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B53,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B54,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B54,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G55+I55+J55+K55)>0,(G55+I55+J55+K55),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B55=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B55,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z55)>=0,\">=\",\"<\")&\" \"&L55&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B55=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B55,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B55,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B55,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B55=\"\",\"\",IF(Z55<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B56,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B56,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B57,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B57,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B58,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B58,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B59,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B59,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G60+I60+J60+K60)>0,(G60+I60+J60+K60),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B60=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B60,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z60)>=0,\">=\",\"<\")&\" \"&L60&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B60=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B60,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B60,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B60,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B60=\"\",\"\",IF(Z60<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B61,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B61,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B62,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B62,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B63,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B63,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B64,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B64,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G65+I65+J65+K65)>0,(G65+I65+J65+K65),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B65=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B65,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z65)>=0,\">=\",\"<\")&\" \"&L65&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B65=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B65,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B65,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B65,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B65=\"\",\"\",IF(Z65<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B66,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B66,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B67,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B67,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B68,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B68,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B69,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B69,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G70+I70+J70+K70)>0,(G70+I70+J70+K70),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B70=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B70,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z70)>=0,\">=\",\"<\")&\" \"&L70&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B70=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B70,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B70,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B70,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B70=\"\",\"\",IF(Z70<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B71,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B71,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B72,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B72,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B73,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B73,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B74,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B74,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G75+I75+J75+K75)>0,(G75+I75+J75+K75),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B75=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B75,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z75)>=0,\">=\",\"<\")&\" \"&L75&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B75=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B75,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B75,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B75,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B75=\"\",\"\",IF(Z75<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B76,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B76,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B77,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B77,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B78,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B78,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B79,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B79,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G80+I80+J80+K80)>0,(G80+I80+J80+K80),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B80=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B80,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z80)>=0,\">=\",\"<\")&\" \"&L80&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B80=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B80,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B80,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B80,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B80=\"\",\"\",IF(Z80<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B81,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B81,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B82,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B82,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B83,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B83,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B84,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B84,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G85+I85+J85+K85)>0,(G85+I85+J85+K85),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B85=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B85,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z85)>=0,\">=\",\"<\")&\" \"&L85&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B85=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B85,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B85,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B85,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B85=\"\",\"\",IF(Z85<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B86,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B86,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B87,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B87,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B88,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B88,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B89,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B89,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G90+I90+J90+K90)>0,(G90+I90+J90+K90),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B90=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B90,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z90)>=0,\">=\",\"<\")&\" \"&L90&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B90=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B90,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B90,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B90,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B90=\"\",\"\",IF(Z90<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B91,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B91,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B92,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B92,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B93,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B93,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B94,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B94,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G95+I95+J95+K95)>0,(G95+I95+J95+K95),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B95=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B95,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z95)>=0,\">=\",\"<\")&\" \"&L95&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B95=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B95,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B95,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B95,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B95=\"\",\"\",IF(Z95<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B96,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B96,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B97,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B97,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B98,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B98,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B99,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B99,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G100+I100+J100+K100)>0,(G100+I100+J100+K100),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B100=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B100,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z100)>=0,\">=\",\"<\")&\" \"&L100&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B100=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B100,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B100,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B100,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B100=\"\",\"\",IF(Z100<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B101,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B101,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B102,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B102,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B103,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B103,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B104,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B104,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G105+I105+J105+K105)>0,(G105+I105+J105+K105),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B105=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B105,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z105)>=0,\">=\",\"<\")&\" \"&L105&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B105=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B105,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B105,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B105,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B105=\"\",\"\",IF(Z105<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B106,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B106,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B107,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B107,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B108,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B108,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B109,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B109,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((G110+I110+J110+K110)>0,(G110+I110+J110+K110),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($B110=\"\",\"\",\"Provided ESDv at POI\"&\" \"&INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B110,Sheet1!$J$2:$J$31,0))&\" \"&\"cf\"&\" \"&IF((Z110)>=0,\">=\",\"<\")&\" \"&L110&\" \"&\"cf\")","v":""},null,null,null,{"$f":"IF(B110=\"\",\"\",INDEX(Sheet1!$N$2:$N$31,MATCH('ESD Summary'!B110,Sheet1!$J$2:$J$31,0)))","v":""},{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B110,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B110,Sheet1!$J$2:$J$31,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B110=\"\",\"\",IF(Z110<0,Sheet1!$AI$1,\"\"))","v":""},null,null,null,null,{"$f":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B111,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B111,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B112,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B112,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B113,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B113,Sheet1!$J$2:$J$31,0))","v":0}]
[null,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":"INDEX(Sheet1!$L$2:$L$31,MATCH('ESD Summary'!$B114,Sheet1!$J$2:$J$31,0))-INDEX(Sheet1!$M$2:$M$31,MATCH('ESD Summary'!$B114,Sheet1!$J$2:$J$31,0))","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"``"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A-1. Green Roofs ",null,null,null,null,null,null,null,null,{"$f":"LEFT(B1215,3)","v":"A-1"}]
[null,"A-2. Permeable Pavements ",null,null,null,null,null,null,null,null,"A-2"]
[null,"A-3. Reinforced Turf",null,null,null,null,null,null,null,null,"A-3"]
[null,"N-1. Disconnection of Rooftop Runoff",null,null,null,null,null,null,null,null,"N-1"]
[null,"N-2. Disconnection of Non-Rooftop Runoff",null,null,null,null,null,null,null,null,"N-2"]
[null,"M-1. Rainwater Harvesting",null,null,null,null,null,null,null,null,"M-1"]
[null,"M-2. Submerged Gravel Wetlands",null,null,null,null,null,null,null,null,"M-2"]
[null,"M-3. Landscape Infiltration",null,null,null,null,null,null,null,null,"M-3"]
[null,"M-4. Infiltration Berms",null,null,null,null,null,null,null,null,"M-4"]
[null,"M-5. Dry Wells",null,null,null,null,null,null,null,null,"M-5"]
[null,"M-6. Micro-Bioretention",null,null,null,null,null,null,null,null,"M-6"]
[null,"M-7. Rain Gardens",null,null,null,null,null,null,null,null,"M-7"]
[null,"M-8 Grass Swales",null,null,null,null,null,null,null,null,{"$f":"LEFT(B1227,5)","v":"M-8 G"}]
[null,"M-8 Bio- Swales",null,null,null,null,null,null,null,null,{"$f":"LEFT(B1228,5)","v":"M-8 B"}]
[null,"M-8 Wet Swales",null,null,null,null,null,null,null,null,{"$f":"LEFT(B1229,5)","v":"M-8 W"}]
[null,"M-9. Enhanced Filters",null,null,null,null,null,null,null,null,{"$f":"LEFT(B1230,3)","v":"M-9"}]
[null,"P-2 Wet Pond (Figure 3.2)",null,null,null,null,null,null,null,null,"P-2"]
[null,"P-3 Wet Extended Detention Pond (Figure 3.3)",null,null,null,null,null,null,null,null,"P-3"]
[null,"P-4 Multiple Pond System (Figure 3.4)",null,null,null,null,null,null,null,null,"P-4"]
[null,"P-5 Pocket Pond (Figure 3.5)",null,null,null,null,null,null,null,null,"P-5"]
[null,"I-1 Infiltration Trench (Figure 3.10)",null,null,null,null,null,null,null,null,"I-1"]
[null,"I-2 Infiltration Basin (Figure 3.11)",null,null,null,null,null,null,null,null,"I-2"]
[null,"F-1 Surface Sand Filter (Figure 3.12)",null,null,null,null,null,null,null,null,"F-1"]
[null,"F-2 Underground Sand Filter (Figure 3.13)",null,null,null,null,null,null,null,null,"F-2"]
[null,"F-3 Perimeter Sand Filter (Figure 3.14)",null,null,null,null,null,null,null,null,"F-3"]
[null,"F-4 Organic Filter (Figure 3.15)",null,null,null,null,null,null,null,null,"F-4"]
[null,"F-5 Pocket Sand Filter (Figure 3.16)",null,null,null,null,null,null,null,null,"F-5"]
[null,"F-6 Bioretention (Figure 3.17)",null,null,null,null,null,null,null,null,"F-6"]
[null,"O-1 Dry Swale (Figure 3.18)",null,null,null,null,null,null,null,null,"O-1"]
[null,"O-2 Wet Swale (Figure 3.19)",null,null,null,null,null,null,null,null,"O-2"]
[null,"OD Other devices as approved by MDE",null,null,null,null,null,null,null,null,"OD "]

{"sheet":"Sheet1","index":1,"n_rows":200,"n_cols":51,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,34,0,41],[0,42,0,49],[0,50,0,57]]}
[null,null,null,null,null,"IAT","Treated \nESDV","Treated \nReV\n","Required ESDV for POI",{"$f":"30-COUNTBLANK(J3:J31)","v":1},"IAT","Treated \nESDV","Required ESDV for POI","Treated \nESDVIARTNEW ","Treated \nRev","Required\nReV",null,"IARTRE-DEV’L","IARTNEW","ESDVRE-DEV'L  (PE=1.0 in)","Reduction applied to Project  (PE=1.0 in)  ","Reduction applied to POI        (PE=2.6 in)  ","For 3.3.B Waivers                  (PE=1 in)","(PE= 2 to 2.6 in)","ESDVshift   (PE = 2 to 2.6 in)","ESDVLWQ",null,null,null,"A-1. Green Roofs ",null,null,null,{"$f":"LEFT(AD1,3)","v":"A-1"},"ALERT! ≫≫≫ For POI\nAdditional management is necessary.\nPlease provide additional ESD practices \nOR provide a structural facility for PE over 1.0 inch \nunless a variance has been granted from MDE. ",null,null,null,null,null,null,null,"ALERT! ≫≫≫ For PROJECT\nAdditional management is necessary.\nPlease provide additional ESD practices \nOR provide a structural facility for PE over 1.0 inch \nunless a variance has been granted from MDE. ",null,null,null,null,null,null,null,"ALERT! ≫≫≫ For POI & PROJECT\nAdditional management is necessary for POI/PROJECT.\nPlease provide additional ESD practices \nOR provide a structural facility for PE over 1.0 inch \nunless a variance has been granted from MDE. "]
[{"$f":"ROW('ESD Summary'!B14)","v":14},{"$f":"ADDRESS(A2,2)","v":"$B$14"},{"$f":"INDIRECT(\"'ESD Summary'!\"&B2)","v":0},1,{"$f":"C2","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!P\"&$A2)=\"\",0,INDIRECT(\"'ESD Summary'!P\"&$A2))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!R\"&$A2)=\"\",0,INDIRECT(\"'ESD Summary'!R\"&$A2))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!t\"&$A2)=\"\",0,INDIRECT(\"'ESD Summary'!t\"&$A2))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!L\"&$A2)=\"\",0,INDIRECT(\"'ESD Summary'!L\"&$A2))","v":0},{"$f":"IF(ISERROR(VLOOKUP(ROW()-1,$D$2:$E$200,2,FALSE)),\"\",VLOOKUP(ROW()-1,$D$2:$E$200,2,FALSE))","v":0},{"$f":"SUMPRODUCT(($E$2:$E$200=J2)*($F$2:$F$200))","v":0},{"$f":"SUMPRODUCT(($E$2:$E$200=J2)*($G$2:$G$200))","v":0},{"$f":"SUMPRODUCT(($E$2:$E$200=J2)*($I$2:$I$200))","v":0},{"$f":"IF(J2=\"\",\"\",IF(OR(M2=\"\",M2=0),\"YES\",IF((L2-M2)>=0,\"YES\",\"NO\")))","v":"YES"},{"$f":"SUMPRODUCT(($E$2:$E$200=J2)*($H$2:$H$200))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!N$14:N$291))","v":0},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J2)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"A-2. Permeable Pavements ",null,null,null,"A-2"]
[{"$f":"A2+1","v":15},{"$f":"ADDRESS(A3,2)","v":"$B$15"},{"$f":"INDIRECT(\"'ESD Summary'!\"&B3)","v":0},{"$f":"IF(COUNTIF($E$2:E3,E3)=1,D2+1,D2)","v":1},{"$f":"IF(C3=0,E2,C3)","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!P\"&$A3)=\"\",0,INDIRECT(\"'ESD Summary'!P\"&$A3))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!R\"&$A3)=\"\",0,INDIRECT(\"'ESD Summary'!R\"&$A3))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!t\"&$A3)=\"\",0,INDIRECT(\"'ESD Summary'!t\"&$A3))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!L\"&$A3)=\"\",0,INDIRECT(\"'ESD Summary'!L\"&$A3))","v":0},{"$f":"IF(ISERROR(VLOOKUP(ROW()-1,$D$2:$E$200,2,FALSE)),\"\",VLOOKUP(ROW()-1,$D$2:$E$200,2,FALSE))","v":""},{"$f":"SUMPRODUCT(($E$2:$E$200=J3)*($F$2:$F$200))","v":0},0,0,"",0,{"$f":"IF(J3=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J3)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"A-3. Reinforced Turf",null,null,null,"A-3"]
[{"$f":"A3+1","v":16},"$B$16",0,{"$f":"IF(COUNTIF($E$2:E4,E4)=1,D3+1,D3)","v":1},{"$f":"IF(C4=0,E3,C4)","v":0},0,0,0,0,"",{"$f":"SUMPRODUCT(($E$2:$E$200=J4)*($F$2:$F$200))","v":0},0,0,"",0,{"$f":"IF(J4=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J4)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"N-1. Disconnection of Rooftop Runoff",null,null,null,"N-1"]
[17,"$B$17",0,{"$f":"IF(COUNTIF($E$2:E5,E5)=1,D4+1,D4)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J5=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J5)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"N-2. Disconnection of Non-Rooftop Runoff",null,null,null,"N-2"]
[18,"$B$18",0,{"$f":"IF(COUNTIF($E$2:E6,E6)=1,D5+1,D5)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J6=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J6)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"N-3. Sheetflow to Conservation Areas",null,null,null,"N-3"]
[19,"$B$19",0,{"$f":"IF(COUNTIF($E$2:E7,E7)=1,D6+1,D6)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J7=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J7)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-1. Rainwater Harvesting",null,null,null,"M-1"]
[20,"$B$20",0,{"$f":"IF(COUNTIF($E$2:E8,E8)=1,D7+1,D7)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J8=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J8)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-2. Submerged Gravel Wetlands",null,null,null,"M-2"]
[21,"$B$21",0,{"$f":"IF(COUNTIF($E$2:E9,E9)=1,D8+1,D8)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J9=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J9)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-3. Landscape Infiltration",null,null,null,"M-3"]
[22,"$B$22",0,{"$f":"IF(COUNTIF($E$2:E10,E10)=1,D9+1,D9)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J10=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J10)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-4. Infiltration Berms",null,null,null,"M-4"]
[23,"$B$23",0,{"$f":"IF(COUNTIF($E$2:E11,E11)=1,D10+1,D10)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J11=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J11)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-5. Dry Wells",null,null,null,"M-5"]
[24,"$B$24",0,{"$f":"IF(COUNTIF($E$2:E12,E12)=1,D11+1,D11)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J12=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J12)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-6. Micro-Bioretention",null,null,null,"M-6"]
[25,"$B$25",0,{"$f":"IF(COUNTIF($E$2:E13,E13)=1,D12+1,D12)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J13=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J13)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-7. Rain Gardens",null,null,null,"M-7"]
[26,"$B$26",0,{"$f":"IF(COUNTIF($E$2:E14,E14)=1,D13+1,D13)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J14=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J14)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-8 G. Swales",null,null,null,{"$f":"LEFT(AD14,5)","v":"M-8 G"}]
[27,"$B$27",0,{"$f":"IF(COUNTIF($E$2:E15,E15)=1,D14+1,D14)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J15=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J15)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-8 B. Swales",null,null,null,{"$f":"LEFT(AD15,5)","v":"M-8 B"}]
[28,"$B$28",0,{"$f":"IF(COUNTIF($E$2:E16,E16)=1,D15+1,D15)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J16=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J16)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-8 W. Swales",null,null,null,{"$f":"LEFT(AD16,5)","v":"M-8 W"}]
[29,"$B$29",0,{"$f":"IF(COUNTIF($E$2:E17,E17)=1,D16+1,D16)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J17=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J17)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"M-9. Enhanced Filters",null,null,null,{"$f":"LEFT(AD17,3)","v":"M-9"}]
[30,"$B$30",0,{"$f":"IF(COUNTIF($E$2:E18,E18)=1,D17+1,D17)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J18=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J18)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"P-2 Wet Pond (Figure 3.2)",null,null,null,"P-2"]
[31,"$B$31",0,{"$f":"IF(COUNTIF($E$2:E19,E19)=1,D18+1,D18)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J19=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J19)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"P-3 Wet ED Pond (Figure 3.3)",null,null,null,"P-3"]
[32,"$B$32",0,{"$f":"IF(COUNTIF($E$2:E20,E20)=1,D19+1,D19)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J20=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J20)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"P-4 Multiple Pond System (Figure 3.4)",null,null,null,"P-4"]
[33,"$B$33",0,{"$f":"IF(COUNTIF($E$2:E21,E21)=1,D20+1,D20)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J21=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J21)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"P-5 Pocket Pond (Figure 3.5)",null,null,null,"P-5"]
[34,"$B$34",0,{"$f":"IF(COUNTIF($E$2:E22,E22)=1,D21+1,D21)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J22=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J22)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"I-1 Infiltration Trench (Figure 3.10)",null,null,null,"I-1"]
[35,"$B$35",0,{"$f":"IF(COUNTIF($E$2:E23,E23)=1,D22+1,D22)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J23=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J23)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"I-2 Infiltration Basin (Figure 3.11)",null,null,null,"I-2"]
[36,"$B$36",0,{"$f":"IF(COUNTIF($E$2:E24,E24)=1,D23+1,D23)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J24=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J24)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-1 Surface Sand Filter (Figure 3.12)",null,null,null,"F-1"]
[37,"$B$37",0,{"$f":"IF(COUNTIF($E$2:E25,E25)=1,D24+1,D24)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J25=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J25)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-2 Underground Sand Filter (Figure 3.13)",null,null,null,"F-2"]
[38,"$B$38",0,{"$f":"IF(COUNTIF($E$2:E26,E26)=1,D25+1,D25)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J26=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J26)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-3 Perimeter Sand Filter (Figure 3.14)",null,null,null,"F-3"]
[39,"$B$39",0,{"$f":"IF(COUNTIF($E$2:E27,E27)=1,D26+1,D26)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J27=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J27)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-4 Organic Filter (Figure 3.15)",null,null,null,"F-4"]
[40,"$B$40",0,{"$f":"IF(COUNTIF($E$2:E28,E28)=1,D27+1,D27)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J28=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J28)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-5 pocket sand filter (Figure 3.16)",null,null,null,"F-5"]
[41,"$B$41",0,{"$f":"IF(COUNTIF($E$2:E29,E29)=1,D28+1,D28)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J29=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J29)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"F-6 Bioretention (Figure 3.17)",null,null,null,"F-6"]
[42,"$B$42",0,{"$f":"IF(COUNTIF($E$2:E30,E30)=1,D29+1,D29)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J30=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J30)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"O-1 Dry Swale (Figure 3.18)",null,null,null,"O-1"]
[43,"$B$43",0,{"$f":"IF(COUNTIF($E$2:E31,E31)=1,D30+1,D30)","v":1},0,0,0,0,0,"",0,0,0,"",0,{"$f":"IF(J31=\"\",\"\",SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!N$14:N$291)))","v":""},null,{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!C$14:C$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!D$14:D$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!E$14:E$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!F$14:F$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!G$14:G$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!H$14:H$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!I$14:I$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!J$14:J$291))","v":0},{"$f":"SUMPRODUCT(('ESD Summary'!$B$14:$B$291=Sheet1!$J31)*('ESD Summary'!K$14:K$291))","v":0},null,null,null,"O-2 Wet Swale (Figure 3.19)",null,null,null,"O-2"]
[44,"$B$44",0,{"$f":"IF(COUNTIF($E$2:E32,E32)=1,D31+1,D31)","v":1},0,0,0,0,0,"",{"$f":"SUM(K2:K31)","v":0},{"$f":"SUM(L2:L31)","v":0},{"$f":"J1","v":1},{"$f":"COUNTIF(N2:N31,\"YES\")","v":1},{"$f":"SUM(O2:O31)","v":0},{"$f":"SUM(P2:P31)","v":0},null,{"$f":"SUM(R2:R31)","v":0},0,0,0,0,0,0,0,0,null,null,null,"PD Proprietary Device",null,null,null,"PD "]
[45,"$B$45",0,{"$f":"IF(COUNTIF($E$2:E33,E33)=1,D32+1,D32)","v":1},0,0,0,0,0,"",null,null,null,{"$f":"IF(J1-N32=0,\"All Study Points meet ESDVIARTNEW Requirement\",\"Out of\"&\" \"&J1&\" \"&\"Study Points,\"&\" \"&N32&\" \"&\"Study Points meet ESDVIARTNEW Requirement\")","v":"All Study Points meet ESDVIARTNEW Requirement"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debit WQ Bank ",null,null,null,{"$f":"LEFT(AD33,5)","v":"Debit"}]
[46,"$B$46",0,{"$f":"IF(COUNTIF($E$2:E34,E34)=1,D33+1,D33)","v":1},0,0,0,0,0,""]
[47,"$B$47",0,{"$f":"IF(COUNTIF($E$2:E35,E35)=1,D34+1,D34)","v":1},0,0,0,0,0,""]
[48,"$B$48",0,{"$f":"IF(COUNTIF($E$2:E36,E36)=1,D35+1,D35)","v":1},0,0,0,0,0,""]
[49,"$B$49",0,{"$f":"IF(COUNTIF($E$2:E37,E37)=1,D36+1,D36)","v":1},0,0,0,0,0,""]
[50,"$B$50",0,{"$f":"IF(COUNTIF($E$2:E38,E38)=1,D37+1,D37)","v":1},0,0,0,0,0,""]
[51,"$B$51",0,{"$f":"IF(COUNTIF($E$2:E39,E39)=1,D38+1,D38)","v":1},0,0,0,0,0,""]
[52,"$B$52",0,{"$f":"IF(COUNTIF($E$2:E40,E40)=1,D39+1,D39)","v":1},0,0,0,0,0,""]
[53,"$B$53",0,{"$f":"IF(COUNTIF($E$2:E41,E41)=1,D40+1,D40)","v":1},0,0,0,0,0,""]
[54,"$B$54",0,{"$f":"IF(COUNTIF($E$2:E42,E42)=1,D41+1,D41)","v":1},0,0,0,0,0,""]
[55,"$B$55",0,{"$f":"IF(COUNTIF($E$2:E43,E43)=1,D42+1,D42)","v":1},0,0,0,0,0,""]
[56,"$B$56",0,{"$f":"IF(COUNTIF($E$2:E44,E44)=1,D43+1,D43)","v":1},0,0,0,0,0]
[57,"$B$57",0,{"$f":"IF(COUNTIF($E$2:E45,E45)=1,D44+1,D44)","v":1},0,0,0,0,0]
[58,"$B$58",0,{"$f":"IF(COUNTIF($E$2:E46,E46)=1,D45+1,D45)","v":1},0,0,0,0,0]
[59,"$B$59",0,{"$f":"IF(COUNTIF($E$2:E47,E47)=1,D46+1,D46)","v":1},0,0,0,0,0]
[60,"$B$60",0,{"$f":"IF(COUNTIF($E$2:E48,E48)=1,D47+1,D47)","v":1},0,0,0,0,0]
[61,"$B$61",0,{"$f":"IF(COUNTIF($E$2:E49,E49)=1,D48+1,D48)","v":1},0,0,0,0,0]
[62,"$B$62",0,{"$f":"IF(COUNTIF($E$2:E50,E50)=1,D49+1,D49)","v":1},0,0,0,0,0]
[63,"$B$63",0,{"$f":"IF(COUNTIF($E$2:E51,E51)=1,D50+1,D50)","v":1},0,0,0,0,0]
[64,"$B$64",0,{"$f":"IF(COUNTIF($E$2:E52,E52)=1,D51+1,D51)","v":1},0,0,0,0,0]
[65,"$B$65",0,{"$f":"IF(COUNTIF($E$2:E53,E53)=1,D52+1,D52)","v":1},0,0,0,0,0]
[66,"$B$66",0,{"$f":"IF(COUNTIF($E$2:E54,E54)=1,D53+1,D53)","v":1},0,0,0,0,0]
[67,"$B$67",0,{"$f":"IF(COUNTIF($E$2:E55,E55)=1,D54+1,D54)","v":1},0,0,0,0,0]
[68,"$B$68",0,{"$f":"IF(COUNTIF($E$2:E56,E56)=1,D55+1,D55)","v":1},0,0,0,0,0]
[69,"$B$69",0,{"$f":"IF(COUNTIF($E$2:E57,E57)=1,D56+1,D56)","v":1},0,0,0,0,0]
[70,"$B$70",0,{"$f":"IF(COUNTIF($E$2:E58,E58)=1,D57+1,D57)","v":1},0,0,0,0,0]
[71,"$B$71",0,{"$f":"IF(COUNTIF($E$2:E59,E59)=1,D58+1,D58)","v":1},0,0,0,0,0]
[72,"$B$72",0,{"$f":"IF(COUNTIF($E$2:E60,E60)=1,D59+1,D59)","v":1},0,0,0,0,0]
[73,"$B$73",0,{"$f":"IF(COUNTIF($E$2:E61,E61)=1,D60+1,D60)","v":1},0,0,0,0,0]
[74,"$B$74",0,{"$f":"IF(COUNTIF($E$2:E62,E62)=1,D61+1,D61)","v":1},0,0,0,0,0]
[75,"$B$75",0,{"$f":"IF(COUNTIF($E$2:E63,E63)=1,D62+1,D62)","v":1},0,0,0,0,0]
[76,"$B$76",0,{"$f":"IF(COUNTIF($E$2:E64,E64)=1,D63+1,D63)","v":1},0,0,0,0,0]
[77,"$B$77",0,{"$f":"IF(COUNTIF($E$2:E65,E65)=1,D64+1,D64)","v":1},0,0,0,0,0]
[78,"$B$78",0,{"$f":"IF(COUNTIF($E$2:E66,E66)=1,D65+1,D65)","v":1},0,0,0,0,0]
[79,{"$f":"ADDRESS(A67,2)","v":"$B$79"},{"$f":"INDIRECT(\"'ESD Summary'!\"&B67)","v":0},{"$f":"IF(COUNTIF($E$2:E67,E67)=1,D66+1,D66)","v":1},0,{"$f":"IF(INDIRECT(\"'ESD Summary'!P\"&$A67)=\"\",0,INDIRECT(\"'ESD Summary'!P\"&$A67))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!R\"&$A67)=\"\",0,INDIRECT(\"'ESD Summary'!R\"&$A67))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!t\"&$A67)=\"\",0,INDIRECT(\"'ESD Summary'!t\"&$A67))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!L\"&$A67)=\"\",0,INDIRECT(\"'ESD Summary'!L\"&$A67))","v":0}]
[{"$f":"A67+1","v":80},"$B$80",0,{"$f":"IF(COUNTIF($E$2:E68,E68)=1,D67+1,D67)","v":1},{"$f":"IF(C68=0,E67,C68)","v":0},0,0,0,0]
[81,"$B$81",0,{"$f":"IF(COUNTIF($E$2:E69,E69)=1,D68+1,D68)","v":1},0,0,0,0,0]
[82,"$B$82",0,{"$f":"IF(COUNTIF($E$2:E70,E70)=1,D69+1,D69)","v":1},0,0,0,0,0]
[83,"$B$83",0,{"$f":"IF(COUNTIF($E$2:E71,E71)=1,D70+1,D70)","v":1},0,0,0,0,0]
[84,"$B$84",0,{"$f":"IF(COUNTIF($E$2:E72,E72)=1,D71+1,D71)","v":1},0,0,0,0,0]
[85,"$B$85",0,{"$f":"IF(COUNTIF($E$2:E73,E73)=1,D72+1,D72)","v":1},0,0,0,0,0]
[86,"$B$86",0,{"$f":"IF(COUNTIF($E$2:E74,E74)=1,D73+1,D73)","v":1},0,0,0,0,0]
[87,"$B$87",0,{"$f":"IF(COUNTIF($E$2:E75,E75)=1,D74+1,D74)","v":1},0,0,0,0,0]
[88,"$B$88",0,{"$f":"IF(COUNTIF($E$2:E76,E76)=1,D75+1,D75)","v":1},0,0,0,0,0]
[89,"$B$89",0,{"$f":"IF(COUNTIF($E$2:E77,E77)=1,D76+1,D76)","v":1},0,0,0,0,0]
[90,"$B$90",0,{"$f":"IF(COUNTIF($E$2:E78,E78)=1,D77+1,D77)","v":1},0,0,0,0,0]
[91,"$B$91",0,{"$f":"IF(COUNTIF($E$2:E79,E79)=1,D78+1,D78)","v":1},0,0,0,0,0]
[92,"$B$92",0,{"$f":"IF(COUNTIF($E$2:E80,E80)=1,D79+1,D79)","v":1},0,0,0,0,0]
[93,"$B$93",0,{"$f":"IF(COUNTIF($E$2:E81,E81)=1,D80+1,D80)","v":1},0,0,0,0,0]
[94,"$B$94",0,{"$f":"IF(COUNTIF($E$2:E82,E82)=1,D81+1,D81)","v":1},0,0,0,0,0]
[95,"$B$95",0,{"$f":"IF(COUNTIF($E$2:E83,E83)=1,D82+1,D82)","v":1},0,0,0,0,0]
[96,"$B$96",0,{"$f":"IF(COUNTIF($E$2:E84,E84)=1,D83+1,D83)","v":1},0,0,0,0,0]
[97,"$B$97",0,{"$f":"IF(COUNTIF($E$2:E85,E85)=1,D84+1,D84)","v":1},0,0,0,0,0]
[98,"$B$98",0,{"$f":"IF(COUNTIF($E$2:E86,E86)=1,D85+1,D85)","v":1},0,0,0,0,0]
[99,"$B$99",0,{"$f":"IF(COUNTIF($E$2:E87,E87)=1,D86+1,D86)","v":1},0,0,0,0,0]
[100,"$B$100",0,{"$f":"IF(COUNTIF($E$2:E88,E88)=1,D87+1,D87)","v":1},0,0,0,0,0]
[101,"$B$101",0,{"$f":"IF(COUNTIF($E$2:E89,E89)=1,D88+1,D88)","v":1},0,0,0,0,0]
[102,"$B$102",0,{"$f":"IF(COUNTIF($E$2:E90,E90)=1,D89+1,D89)","v":1},0,0,0,0,0]
[103,"$B$103",0,{"$f":"IF(COUNTIF($E$2:E91,E91)=1,D90+1,D90)","v":1},0,0,0,0,0]
[104,"$B$104",0,{"$f":"IF(COUNTIF($E$2:E92,E92)=1,D91+1,D91)","v":1},0,0,0,0,0]
[105,"$B$105",0,{"$f":"IF(COUNTIF($E$2:E93,E93)=1,D92+1,D92)","v":1},0,0,0,0,0]
[106,"$B$106",0,{"$f":"IF(COUNTIF($E$2:E94,E94)=1,D93+1,D93)","v":1},0,0,0,0,0]
[107,"$B$107",0,{"$f":"IF(COUNTIF($E$2:E95,E95)=1,D94+1,D94)","v":1},0,0,0,0,0]
[108,"$B$108",0,{"$f":"IF(COUNTIF($E$2:E96,E96)=1,D95+1,D95)","v":1},0,0,0,0,0]
[109,"$B$109",0,{"$f":"IF(COUNTIF($E$2:E97,E97)=1,D96+1,D96)","v":1},0,0,0,0,0]
[110,"$B$110",0,{"$f":"IF(COUNTIF($E$2:E98,E98)=1,D97+1,D97)","v":1},0,0,0,0,0]
[111,"$B$111",0,{"$f":"IF(COUNTIF($E$2:E99,E99)=1,D98+1,D98)","v":1},0,0,0,0,0]
[112,"$B$112",0,{"$f":"IF(COUNTIF($E$2:E100,E100)=1,D99+1,D99)","v":1},0,0,0,0,0]
[113,"$B$113",0,{"$f":"IF(COUNTIF($E$2:E101,E101)=1,D100+1,D100)","v":1},0,0,0,0,0]
[114,"$B$114",0,{"$f":"IF(COUNTIF($E$2:E102,E102)=1,D101+1,D101)","v":1},0,0,0,0,0]
[115,"$B$115",0,{"$f":"IF(COUNTIF($E$2:E103,E103)=1,D102+1,D102)","v":1},0,0,0,0,0]
[116,"$B$116",0,{"$f":"IF(COUNTIF($E$2:E104,E104)=1,D103+1,D103)","v":1},0,0,0,0,0]
[117,"$B$117",0,{"$f":"IF(COUNTIF($E$2:E105,E105)=1,D104+1,D104)","v":1},0,0,0,0,0]
[118,"$B$118",0,{"$f":"IF(COUNTIF($E$2:E106,E106)=1,D105+1,D105)","v":1},0,0,0,0,0]
[119,"$B$119",0,{"$f":"IF(COUNTIF($E$2:E107,E107)=1,D106+1,D106)","v":1},0,0,0,0,0]
[120,"$B$120",0,{"$f":"IF(COUNTIF($E$2:E108,E108)=1,D107+1,D107)","v":1},0,0,0,0,0]
[121,"$B$121",0,{"$f":"IF(COUNTIF($E$2:E109,E109)=1,D108+1,D108)","v":1},0,0,0,0,0]
[122,"$B$122",0,{"$f":"IF(COUNTIF($E$2:E110,E110)=1,D109+1,D109)","v":1},0,0,0,0,0]
[123,"$B$123",0,{"$f":"IF(COUNTIF($E$2:E111,E111)=1,D110+1,D110)","v":1},0,0,0,0,0]
[124,"$B$124",0,{"$f":"IF(COUNTIF($E$2:E112,E112)=1,D111+1,D111)","v":1},0,0,0,0,0]
[125,"$B$125",0,{"$f":"IF(COUNTIF($E$2:E113,E113)=1,D112+1,D112)","v":1},0,0,0,0,0]
[126,"$B$126",0,{"$f":"IF(COUNTIF($E$2:E114,E114)=1,D113+1,D113)","v":1},0,0,0,0,0]
[127,"$B$127",0,{"$f":"IF(COUNTIF($E$2:E115,E115)=1,D114+1,D114)","v":1},0,0,0,0,0]
[128,"$B$128",0,{"$f":"IF(COUNTIF($E$2:E116,E116)=1,D115+1,D115)","v":1},0,0,0,0,0]
[129,"$B$129",0,{"$f":"IF(COUNTIF($E$2:E117,E117)=1,D116+1,D116)","v":1},0,0,0,0,0]
[130,"$B$130",0,{"$f":"IF(COUNTIF($E$2:E118,E118)=1,D117+1,D117)","v":1},0,0,0,0,0]
[131,"$B$131",0,{"$f":"IF(COUNTIF($E$2:E119,E119)=1,D118+1,D118)","v":1},0,0,0,0,0]
[132,"$B$132",0,{"$f":"IF(COUNTIF($E$2:E120,E120)=1,D119+1,D119)","v":1},0,0,0,0,0]
[133,"$B$133",0,{"$f":"IF(COUNTIF($E$2:E121,E121)=1,D120+1,D120)","v":1},0,0,0,0,0]
[134,"$B$134",0,{"$f":"IF(COUNTIF($E$2:E122,E122)=1,D121+1,D121)","v":1},0,0,0,0,0]
[135,"$B$135",0,{"$f":"IF(COUNTIF($E$2:E123,E123)=1,D122+1,D122)","v":1},0,0,0,0,0]
[136,"$B$136",0,{"$f":"IF(COUNTIF($E$2:E124,E124)=1,D123+1,D123)","v":1},0,0,0,0,0]
[137,"$B$137",0,{"$f":"IF(COUNTIF($E$2:E125,E125)=1,D124+1,D124)","v":1},0,0,0,0,0]
[138,"$B$138",0,{"$f":"IF(COUNTIF($E$2:E126,E126)=1,D125+1,D125)","v":1},0,0,0,0,0]
[139,"$B$139",0,{"$f":"IF(COUNTIF($E$2:E127,E127)=1,D126+1,D126)","v":1},0,0,0,0,0]
[140,"$B$140",0,{"$f":"IF(COUNTIF($E$2:E128,E128)=1,D127+1,D127)","v":1},0,0,0,0,0]
[141,"$B$141",0,{"$f":"IF(COUNTIF($E$2:E129,E129)=1,D128+1,D128)","v":1},0,0,0,0,0]
[142,"$B$142",0,{"$f":"IF(COUNTIF($E$2:E130,E130)=1,D129+1,D129)","v":1},0,0,0,0,0]
[143,{"$f":"ADDRESS(A131,2)","v":"$B$143"},{"$f":"INDIRECT(\"'ESD Summary'!\"&B131)","v":0},{"$f":"IF(COUNTIF($E$2:E131,E131)=1,D130+1,D130)","v":1},0,{"$f":"IF(INDIRECT(\"'ESD Summary'!P\"&$A131)=\"\",0,INDIRECT(\"'ESD Summary'!P\"&$A131))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!R\"&$A131)=\"\",0,INDIRECT(\"'ESD Summary'!R\"&$A131))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!t\"&$A131)=\"\",0,INDIRECT(\"'ESD Summary'!t\"&$A131))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!L\"&$A131)=\"\",0,INDIRECT(\"'ESD Summary'!L\"&$A131))","v":0}]
[{"$f":"A131+1","v":144},"$B$144",0,{"$f":"IF(COUNTIF($E$2:E132,E132)=1,D131+1,D131)","v":1},{"$f":"IF(C132=0,E131,C132)","v":0},0,0,0,0]
[145,"$B$145",0,{"$f":"IF(COUNTIF($E$2:E133,E133)=1,D132+1,D132)","v":1},0,0,0,0,0]
[146,"$B$146",0,{"$f":"IF(COUNTIF($E$2:E134,E134)=1,D133+1,D133)","v":1},0,0,0,0,0]
[147,"$B$147",0,{"$f":"IF(COUNTIF($E$2:E135,E135)=1,D134+1,D134)","v":1},0,0,0,0,0]
[148,"$B$148",0,{"$f":"IF(COUNTIF($E$2:E136,E136)=1,D135+1,D135)","v":1},0,0,0,0,0]
[149,"$B$149",0,{"$f":"IF(COUNTIF($E$2:E137,E137)=1,D136+1,D136)","v":1},0,0,0,0,0]
[150,"$B$150",0,{"$f":"IF(COUNTIF($E$2:E138,E138)=1,D137+1,D137)","v":1},0,0,0,0,0]
[151,"$B$151",0,{"$f":"IF(COUNTIF($E$2:E139,E139)=1,D138+1,D138)","v":1},0,0,0,0,0]
[152,"$B$152",0,{"$f":"IF(COUNTIF($E$2:E140,E140)=1,D139+1,D139)","v":1},0,0,0,0,0]
[153,"$B$153",0,{"$f":"IF(COUNTIF($E$2:E141,E141)=1,D140+1,D140)","v":1},0,0,0,0,0]
[154,"$B$154",0,{"$f":"IF(COUNTIF($E$2:E142,E142)=1,D141+1,D141)","v":1},0,0,0,0,0]
[155,"$B$155",0,{"$f":"IF(COUNTIF($E$2:E143,E143)=1,D142+1,D142)","v":1},0,0,0,0,0]
[156,"$B$156",0,{"$f":"IF(COUNTIF($E$2:E144,E144)=1,D143+1,D143)","v":1},0,0,0,0,0]
[157,"$B$157",0,{"$f":"IF(COUNTIF($E$2:E145,E145)=1,D144+1,D144)","v":1},0,0,0,0,0]
[158,"$B$158",0,{"$f":"IF(COUNTIF($E$2:E146,E146)=1,D145+1,D145)","v":1},0,0,0,0,0]
[159,"$B$159",0,{"$f":"IF(COUNTIF($E$2:E147,E147)=1,D146+1,D146)","v":1},0,0,0,0,0]
[160,"$B$160",0,{"$f":"IF(COUNTIF($E$2:E148,E148)=1,D147+1,D147)","v":1},0,0,0,0,0]
[161,"$B$161",0,{"$f":"IF(COUNTIF($E$2:E149,E149)=1,D148+1,D148)","v":1},0,0,0,0,0]
[162,"$B$162",0,{"$f":"IF(COUNTIF($E$2:E150,E150)=1,D149+1,D149)","v":1},0,0,0,0,0]
[163,"$B$163",0,{"$f":"IF(COUNTIF($E$2:E151,E151)=1,D150+1,D150)","v":1},0,0,0,0,0]
[164,"$B$164",0,{"$f":"IF(COUNTIF($E$2:E152,E152)=1,D151+1,D151)","v":1},0,0,0,0,0]
[165,"$B$165",0,{"$f":"IF(COUNTIF($E$2:E153,E153)=1,D152+1,D152)","v":1},0,0,0,0,0]
[166,"$B$166",0,{"$f":"IF(COUNTIF($E$2:E154,E154)=1,D153+1,D153)","v":1},0,0,0,0,0]
[167,"$B$167",0,{"$f":"IF(COUNTIF($E$2:E155,E155)=1,D154+1,D154)","v":1},0,0,0,0,0]
[168,"$B$168",0,{"$f":"IF(COUNTIF($E$2:E156,E156)=1,D155+1,D155)","v":1},0,0,0,0,0]
[169,"$B$169",0,{"$f":"IF(COUNTIF($E$2:E157,E157)=1,D156+1,D156)","v":1},0,0,0,0,0]
[170,"$B$170",0,{"$f":"IF(COUNTIF($E$2:E158,E158)=1,D157+1,D157)","v":1},0,0,0,0,0]
[171,"$B$171",0,{"$f":"IF(COUNTIF($E$2:E159,E159)=1,D158+1,D158)","v":1},0,0,0,0,0]
[172,"$B$172",0,{"$f":"IF(COUNTIF($E$2:E160,E160)=1,D159+1,D159)","v":1},0,0,0,0,0]
[173,"$B$173",0,{"$f":"IF(COUNTIF($E$2:E161,E161)=1,D160+1,D160)","v":1},0,0,0,0,0]
[174,"$B$174",0,{"$f":"IF(COUNTIF($E$2:E162,E162)=1,D161+1,D161)","v":1},0,0,0,0,0]
[175,"$B$175",0,{"$f":"IF(COUNTIF($E$2:E163,E163)=1,D162+1,D162)","v":1},0,0,0,0,0]
[176,"$B$176",0,{"$f":"IF(COUNTIF($E$2:E164,E164)=1,D163+1,D163)","v":1},0,0,0,0,0]
[177,"$B$177",0,{"$f":"IF(COUNTIF($E$2:E165,E165)=1,D164+1,D164)","v":1},0,0,0,0,0]
[178,"$B$178",0,{"$f":"IF(COUNTIF($E$2:E166,E166)=1,D165+1,D165)","v":1},0,0,0,0,0]
[179,"$B$179",0,{"$f":"IF(COUNTIF($E$2:E167,E167)=1,D166+1,D166)","v":1},0,0,0,0,0]
[180,"$B$180",0,{"$f":"IF(COUNTIF($E$2:E168,E168)=1,D167+1,D167)","v":1},0,0,0,0,0]
[181,"$B$181",0,{"$f":"IF(COUNTIF($E$2:E169,E169)=1,D168+1,D168)","v":1},0,0,0,0,0]
[182,"$B$182",0,{"$f":"IF(COUNTIF($E$2:E170,E170)=1,D169+1,D169)","v":1},0,0,0,0,0]
[183,"$B$183",0,{"$f":"IF(COUNTIF($E$2:E171,E171)=1,D170+1,D170)","v":1},0,0,0,0,0]
[184,"$B$184",0,{"$f":"IF(COUNTIF($E$2:E172,E172)=1,D171+1,D171)","v":1},0,0,0,0,0]
[185,"$B$185",0,{"$f":"IF(COUNTIF($E$2:E173,E173)=1,D172+1,D172)","v":1},0,0,0,0,0]
[186,"$B$186",0,{"$f":"IF(COUNTIF($E$2:E174,E174)=1,D173+1,D173)","v":1},0,0,0,0,0]
[187,"$B$187",0,{"$f":"IF(COUNTIF($E$2:E175,E175)=1,D174+1,D174)","v":1},0,0,0,0,0]
[188,"$B$188",0,{"$f":"IF(COUNTIF($E$2:E176,E176)=1,D175+1,D175)","v":1},0,0,0,0,0]
[189,"$B$189",0,{"$f":"IF(COUNTIF($E$2:E177,E177)=1,D176+1,D176)","v":1},0,0,0,0,0]
[190,"$B$190",0,{"$f":"IF(COUNTIF($E$2:E178,E178)=1,D177+1,D177)","v":1},0,0,0,0,0]
[191,"$B$191",0,{"$f":"IF(COUNTIF($E$2:E179,E179)=1,D178+1,D178)","v":1},0,0,0,0,0]
[192,"$B$192",0,{"$f":"IF(COUNTIF($E$2:E180,E180)=1,D179+1,D179)","v":1},0,0,0,0,0]
[193,"$B$193",0,{"$f":"IF(COUNTIF($E$2:E181,E181)=1,D180+1,D180)","v":1},0,0,0,0,0]
[194,"$B$194",0,{"$f":"IF(COUNTIF($E$2:E182,E182)=1,D181+1,D181)","v":1},0,0,0,0,0]
[195,"$B$195",0,{"$f":"IF(COUNTIF($E$2:E183,E183)=1,D182+1,D182)","v":1},0,0,0,0,0]
[196,"$B$196",0,{"$f":"IF(COUNTIF($E$2:E184,E184)=1,D183+1,D183)","v":1},0,0,0,0,0]
[197,"$B$197",0,{"$f":"IF(COUNTIF($E$2:E185,E185)=1,D184+1,D184)","v":1},0,0,0,0,0]
[198,"$B$198",0,{"$f":"IF(COUNTIF($E$2:E186,E186)=1,D185+1,D185)","v":1},0,0,0,0,0]
[199,"$B$199",0,{"$f":"IF(COUNTIF($E$2:E187,E187)=1,D186+1,D186)","v":1},0,0,0,0,0]
[200,"$B$200",0,{"$f":"IF(COUNTIF($E$2:E188,E188)=1,D187+1,D187)","v":1},0,0,0,0,0]
[201,"$B$201",0,{"$f":"IF(COUNTIF($E$2:E189,E189)=1,D188+1,D188)","v":1},0,0,0,0,0]
[202,"$B$202",0,{"$f":"IF(COUNTIF($E$2:E190,E190)=1,D189+1,D189)","v":1},0,0,0,0,0]
[203,"$B$203",0,{"$f":"IF(COUNTIF($E$2:E191,E191)=1,D190+1,D190)","v":1},0,0,0,0,0]
[204,"$B$204",0,{"$f":"IF(COUNTIF($E$2:E192,E192)=1,D191+1,D191)","v":1},0,0,0,0,0]
[205,"$B$205",0,{"$f":"IF(COUNTIF($E$2:E193,E193)=1,D192+1,D192)","v":1},0,0,0,0,0]
[206,"$B$206",0,{"$f":"IF(COUNTIF($E$2:E194,E194)=1,D193+1,D193)","v":1},0,0,0,0,0]
[207,{"$f":"ADDRESS(A195,2)","v":"$B$207"},{"$f":"INDIRECT(\"'ESD Summary'!\"&B195)","v":0},{"$f":"IF(COUNTIF($E$2:E195,E195)=1,D194+1,D194)","v":1},0,{"$f":"IF(INDIRECT(\"'ESD Summary'!P\"&$A195)=\"\",0,INDIRECT(\"'ESD Summary'!P\"&$A195))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!R\"&$A195)=\"\",0,INDIRECT(\"'ESD Summary'!R\"&$A195))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!t\"&$A195)=\"\",0,INDIRECT(\"'ESD Summary'!t\"&$A195))","v":0},{"$f":"IF(INDIRECT(\"'ESD Summary'!L\"&$A195)=\"\",0,INDIRECT(\"'ESD Summary'!L\"&$A195))","v":0}]
[{"$f":"A195+1","v":208},"$B$208",0,{"$f":"IF(COUNTIF($E$2:E196,E196)=1,D195+1,D195)","v":1},{"$f":"IF(C196=0,E195,C196)","v":0},0,0,0,0]
[{"$f":"A196+1","v":209},"$B$209",0,{"$f":"IF(COUNTIF($E$2:E197,E197)=1,D196+1,D196)","v":1},{"$f":"IF(C197=0,E196,C197)","v":0},0,0,0,0]
[{"$f":"A197+1","v":210},"$B$210",0,{"$f":"IF(COUNTIF($E$2:E198,E198)=1,D197+1,D197)","v":1},{"$f":"IF(C198=0,E197,C198)","v":0},0,0,0,0]
[{"$f":"A198+1","v":211},"$B$211",0,{"$f":"IF(COUNTIF($E$2:E199,E199)=1,D198+1,D198)","v":1},{"$f":"IF(C199=0,E198,C199)","v":0},0,0,0,0]
[{"$f":"A199+1","v":212},"$B$212",0,{"$f":"IF(COUNTIF($E$2:E200,E200)=1,D199+1,D199)","v":1},{"$f":"IF(C200=0,E199,C200)","v":0},0,0,0,0]