{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Entry","WTP INFO","Pivot Tables"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":2},"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":"Data Entry","index":0,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Date","Raw TOC","Raw Alk.","Fin. TOC","Fin. TTHM","Fin HAA5","Coagulation pH","Coagulant Dose","Comments","DBP IND","Month Date","Quarter Date"]
["2017-04-01",3.22,28,1.73,null,null,6.84,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-04-01"},{"$f":"IF(\"Q\"&ROUNDUP(MONTH(K2)/3,0)=\"Q1\",VALUE(\"1/1/\"&YEAR(K2)),IF(\"Q\"&ROUNDUP(MONTH(K2)/3,0)=\"Q2\",VALUE(\"4/1/\"&YEAR(K2)),IF(\"Q\"&ROUNDUP(MONTH(K2)/3,0)=\"Q3\",VALUE(\"7/1/\"&YEAR(K2)),IF(\"Q\" & ROUNDUP(MONTH(K2)/3,0)=\"Q4\", VALUE(\"10/1/\"&YEAR(K2)),\"\"))))","v":"2017-04-01"}]
["2017-05-01",3.3,25,1.98,null,null,6.72,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-05-01"},"2017-04-01"]
["2017-06-01",3.28,25,1.39,null,null,6.58,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-06-01"},"2017-04-01"]
["2017-07-01",3.77,28,1.9,null,null,6.62,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-07-01"},"2017-07-01"]
["2017-08-01",3.35,34,1.81,null,null,6.69,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-08-01"},"2017-07-01"]
["2017-09-01",3.67,33,2.23,null,null,6.76,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-09-01"},"2017-07-01"]
["2017-10-01",5.28,33,2.4700000000000002,null,null,6.84,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-10-01"},"2017-10-01"]
["2017-11-01",4.75,35,2.2999999999999998,null,null,6.92,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-11-01"},"2017-10-01"]
["2017-12-01",5.09,35,2.52,null,null,6.78,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-12-01"},"2017-10-01"]
["2018-01-01",4.66,28,1.75,null,null,6.49,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2018-01-01"},"2018-01-01"]
["2018-02-01",5.1100000000000003,28,2.5299999999999998,null,null,6.76,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2018-02-01"},"2018-01-01"]
["2018-03-01",5.1100000000000003,28,1.84,null,null,6.6,36,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"NO"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2018-03-01"},"2018-01-01"]
["2015-04-01",null,null,null,2.18E-2,1.41E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2015-04-01"},{"$f":"IF(\"Q\"&ROUNDUP(MONTH(K14)/3,0)=\"Q1\",VALUE(\"1/1/\"&YEAR(K14)),IF(\"Q\"&ROUNDUP(MONTH(K14)/3,0)=\"Q2\",VALUE(\"4/1/\"&YEAR(K14)),IF(\"Q\"&ROUNDUP(MONTH(K14)/3,0)=\"Q3\",VALUE(\"7/1/\"&YEAR(K14)),IF(\"Q\" & ROUNDUP(MONTH(K14)/3,0)=\"Q4\", VALUE(\"10/1/\"&YEAR(K14)),\"\"))))","v":"2015-04-01"}]
["2015-07-01",null,null,null,2.4799999999999999E-2,1.4200000000000001E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2015-07-01"},"2015-07-01"]
["2015-10-01",null,null,null,1.11E-2,9.3399999999999993E-3,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2015-10-01"},"2015-10-01"]
["2016-01-01",null,null,null,7.0000000000000001E-3,1.2E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2016-01-01"},"2016-01-01"]
["2016-04-01",null,null,null,3.9899999999999998E-2,2.3699999999999999E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2016-04-01"},"2016-04-01"]
["2016-07-01",null,null,null,3.0099999999999998E-2,2.0199999999999999E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2016-07-01"},"2016-07-01"]
["2016-10-01",null,null,null,1.5100000000000001E-2,1.4E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2016-10-01"},"2016-10-01"]
["2017-01-01",null,null,null,6.5300000000000002E-3,8.4200000000000004E-3,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-01-01"},"2017-01-01"]
["2017-04-01",null,null,null,2.8400000000000002E-2,2.41E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-04-01"},"2017-04-01"]
["2017-07-01",null,null,null,4.2999999999999997E-2,3.6999999999999998E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-07-01"},"2017-07-01"]
["2017-10-01",null,null,null,3.2899999999999999E-2,2.0199999999999999E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2017-10-01"},"2017-10-01"]
["2018-01-01",null,null,null,2.1600000000000001E-2,1.61E-2,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Fin. TTHM]]=\"\",Table1[[#This Row],[Fin HAA5]]=\"\"),\"NO\",\"YES\")","v":"YES"},{"$f":"VALUE(MONTH(Table1[[#This Row],[Date]]) &\"/1/\"&YEAR(Table1[[#This Row],[Date]]))","v":"2018-01-01"},"2018-01-01"]

{"sheet":"WTP INFO","index":1,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,15,0,16],[1,15,1,16],[39,1,39,13],[44,1,44,13],[0,1,0,13],[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[14,2,14,12],[16,1,16,13]]}
[null,"Water System Name",null,null,null,null,null,null,null,null,null,null,null,null,null,"End Date"]
[null,"PWSID # AL0005555",null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-31"]
[null,"Water Treatment Plant Name"]
[null,"Source Name"]
[null,"TOC Results Past 12 Months"]
[null,null,{"$f":"EDATE(N6,-11)","v":"2017-04-01"},{"$f":"EDATE(N6,-10)","v":"2017-05-01"},{"$f":"EDATE(N6,-9)","v":"2017-06-01"},{"$f":"EDATE(N6,-8)","v":"2017-07-01"},{"$f":"EDATE(N6,-7)","v":"2017-08-01"},{"$f":"EDATE(N6,-6)","v":"2017-09-01"},{"$f":"EDATE(N6,-5)","v":"2017-10-01"},{"$f":"EDATE(N6,-4)","v":"2017-11-01"},{"$f":"EDATE(N6,-3)","v":"2017-12-01"},{"$f":"EDATE(N6,-2)","v":"2018-01-01"},{"$f":"EDATE(N6,-1)","v":"2018-02-01"},{"$f":"VALUE(MONTH(P2) &\"/1/\"&YEAR(P2))","v":"2018-03-01"}]
[null,"Raw Alkalinity",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,3)","v":28},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,3)","v":25},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,3)","v":25},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,3)","v":28},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,3)","v":34},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,3)","v":33},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,3)","v":33},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,3)","v":35},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,3)","v":35},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,3)","v":28},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,3)","v":28},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,3)","v":28}]
[null,"Raw TOC",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.22},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.3},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.28},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.77},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.35},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.67},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,2)","v":5.28},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,2)","v":4.75},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,2)","v":5.09},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,2)","v":4.66},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,2)","v":5.1100000000000003},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,2)","v":5.1100000000000003}]
[null,"Finished TOC",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.73},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.98},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.39},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.9},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.81},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.23},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.4700000000000002},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.2999999999999998},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.52},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.75},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.5299999999999998},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.84}]
[null,"Removal Percentage",{"$f":"IFERROR((C8-C9)/C8,\"\")","v":0.46273291925465843},{"$f":"IFERROR((D8-D9)/D8,\"\")","v":0.39999999999999997},0.57621951219512191,0.49602122015915123,0.45970149253731341,0.39237057220708449,0.53219696969696972,0.51578947368421058,0.50491159135559915,0.62446351931330468,0.50489236790606662,0.63992172211350296]
[null,"Required Removal",{"$f":"IF(AND((C$7<=60),(C$8<=4)),0.35,IF(AND((C$7<=60),(C$8<=8)),0.45,IF(AND((C$7<=60),(C$8>8)),0.5,IF(AND((C$7<=120),(C$8<=4)),0.25,IF(AND((C$7<=120),(C$8<=8)),0.35,IF(AND((C$7<=120),(C$8>8)),0.4,IF(AND((C$7>120),(C$8<=4)),0.15,IF(AND((C$7>120),(C$8<=8)),0.25,IF(AND((C$7>120),(C$8>8)),0.3,0)))))))))","v":0.35},{"$f":"IF(AND((D$7<=60),(D$8<=4)),0.35,IF(AND((D$7<=60),(D$8<=8)),0.45,IF(AND((D$7<=60),(D$8>8)),0.5,IF(AND((D$7<=120),(D$8<=4)),0.25,IF(AND((D$7<=120),(D$8<=8)),0.35,IF(AND((D$7<=120),(D$8>8)),0.4,IF(AND((D$7>120),(D$8<=4)),0.15,IF(AND((D$7>120),(D$8<=8)),0.25,IF(AND((D$7>120),(D$8>8)),0.3,0)))))))))","v":0.35},{"$f":"IF(AND((E$7<=60),(E$8<=4)),0.35,IF(AND((E$7<=60),(E$8<=8)),0.45,IF(AND((E$7<=60),(E$8>8)),0.5,IF(AND((E$7<=120),(E$8<=4)),0.25,IF(AND((E$7<=120),(E$8<=8)),0.35,IF(AND((E$7<=120),(E$8>8)),0.4,IF(AND((E$7>120),(E$8<=4)),0.15,IF(AND((E$7>120),(E$8<=8)),0.25,IF(AND((E$7>120),(E$8>8)),0.3,0)))))))))","v":0.35},0.35,0.35,0.35,0.45,0.45,0.45,0.45,0.45,0.45]
[null,"Calculated PR",{"$f":"IFERROR(((C8-C9)/C8)/C11,\"\")","v":1.3220940550133098},{"$f":"IFERROR(((D8-D9)/D8)/D11,\"\")","v":1.1428571428571428},1.6463414634146341,1.4172034861690037,1.3134328358208955,1.1210587777345271,1.1826599326599327,1.1461988304093569,1.122025758567998,1.3876967095851216,1.1219830397912591,1.4220482713633398]
[null,"Alternate PR",{"$f":"IF(OR((C8<2),(C9<2)),1,0)","v":1},{"$f":"IF(OR((D8<2),(D9<2)),1,0)","v":1},1,1,1,0,0,0,0,1,0,1]
[null,"Selected PR",{"$f":"MAX(C12:C13)","v":1.3220940550133098},{"$f":"MAX(D12:D13)","v":1.1428571428571428},1.6463414634146341,1.4172034861690037,1.3134328358208955,1.1210587777345271,1.1826599326599327,1.1461988304093569,1.122025758567998,1.3876967095851216,1.1219830397912591,1.4220482713633398]
[null,"Compliance PR","The Compliance PR must be greater than or equal to 1.00 or finished TOC average < 2.0 mg/L",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(C14:N14),\"ERROR\")","v":1.27880002528221}]
[]
[null,"Finished TOC RAA Goal ≤ 1.7 mg/L"]
[]
[null,"FINISHED TOC GOAL",1.7,1.7,1.7,1.7,1.7,1.7,1.7,1.7,1.7,1.7,1.7,1.7]
[null,"PR Regulatory Requirement",1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[null,"Coagulation pH",{"$f":"VLOOKUP(C$6,Table1[[#All],[Date]:[Comments]],7)","v":6.84},{"$f":"VLOOKUP(D$6,Table1[[#All],[Date]:[Comments]],7)","v":6.72},{"$f":"VLOOKUP(E$6,Table1[[#All],[Date]:[Comments]],7)","v":6.58},{"$f":"VLOOKUP(F$6,Table1[[#All],[Date]:[Comments]],7)","v":6.62},{"$f":"VLOOKUP(G$6,Table1[[#All],[Date]:[Comments]],7)","v":6.69},{"$f":"VLOOKUP(H$6,Table1[[#All],[Date]:[Comments]],7)","v":6.76},{"$f":"VLOOKUP(I$6,Table1[[#All],[Date]:[Comments]],7)","v":6.84},{"$f":"VLOOKUP(J$6,Table1[[#All],[Date]:[Comments]],7)","v":6.92},{"$f":"VLOOKUP(K$6,Table1[[#All],[Date]:[Comments]],7)","v":6.78},{"$f":"VLOOKUP(L$6,Table1[[#All],[Date]:[Comments]],7)","v":6.49},{"$f":"VLOOKUP(M$6,Table1[[#All],[Date]:[Comments]],7)","v":6.76},{"$f":"VLOOKUP(N$6,Table1[[#All],[Date]:[Comments]],7)","v":6.6}]
[null,"Coagulant Dose",{"$f":"VLOOKUP(C$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(D$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(E$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(F$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(G$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(H$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(I$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(J$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(K$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(L$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(M$6,Table1[[#All],[Date]:[Comments]],8)","v":36},{"$f":"VLOOKUP(N$6,Table1[[#All],[Date]:[Comments]],8)","v":36}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WTP Effluent Individual DBP Sample Results (Past 3 Years)"]
[null,"WTP Effluent",{"$f":"\"Q\" & ROUNDUP(MONTH(C46)/3,0)&\" \" & YEAR(C46)","v":"Q2 2015"},"Q3 2015","Q4 2015","Q1 2016","Q2 2016","Q3 2016","Q4 2016","Q1 2017","Q2 2017","Q3 2017","Q4 2017",{"$f":"\"Q\" & ROUNDUP(MONTH(N46)/3,0)&\" \" & YEAR(N46)","v":"Q1 2018"}]
[null,"TTHM",{"$f":"VLOOKUP(C46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":21.8},{"$f":"VLOOKUP(D46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":24.8},{"$f":"VLOOKUP(E46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":11.1},{"$f":"VLOOKUP(F46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":7},{"$f":"VLOOKUP(G46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":39.9},{"$f":"VLOOKUP(H46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":30.099999999999998},{"$f":"VLOOKUP(I46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":15.100000000000001},{"$f":"VLOOKUP(J46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":6.53},{"$f":"VLOOKUP(K46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":28.400000000000002},{"$f":"VLOOKUP(L46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":43},{"$f":"VLOOKUP(M46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":32.9},{"$f":"VLOOKUP(N46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":21.6}]
[null,"HAA5",{"$f":"VLOOKUP(C46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":14.1},{"$f":"VLOOKUP(D46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":14.200000000000001},{"$f":"VLOOKUP(E46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":9.34},{"$f":"VLOOKUP(F46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":12},{"$f":"VLOOKUP(G46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":23.7},{"$f":"VLOOKUP(H46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":20.2},{"$f":"VLOOKUP(I46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":14},{"$f":"VLOOKUP(J46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":8.42},{"$f":"VLOOKUP(K46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":24.1},{"$f":"VLOOKUP(L46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":37},{"$f":"VLOOKUP(M46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":20.2},{"$f":"VLOOKUP(N46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":16.100000000000001}]
[]
[null,"TTHM Goal LRRA ≤ 20 mg/L and HAA5 Goal LRAA ≤ 15 mg/L"]
[null,null,{"$f":"EDATE(D46,-3)","v":"2015-06-01"},"2015-09-01","2015-12-01","2016-03-01","2016-06-01","2016-09-01","2016-12-01","2017-03-01","2017-06-01","2017-09-01","2017-12-01",{"$f":"EDATE(N6,0)","v":"2018-03-01"}]

{"sheet":"Pivot Tables","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"DBP IND","NO",null,null,null,"DBP IND","YES"]
[]
[null,"Row Labels","Average of Raw TOC","Average of Raw Alk.","Average of Fin. TOC",null,"Row Labels","Average of Fin. TTHM","Average of Fin HAA5"]
[null,"2017-04-01",3.22,28,1.73,null,"2015-04-01",2.18E-2,1.41E-2]
[null,"2017-05-01",3.3,25,1.98,null,"2015-07-01",2.4799999999999999E-2,1.4200000000000001E-2]
[null,"2017-06-01",3.28,25,1.39,null,"2015-10-01",1.11E-2,9.3399999999999993E-3]
[null,"2017-07-01",3.77,28,1.9,null,"2016-01-01",7.0000000000000001E-3,1.2E-2]
[null,"2017-08-01",3.35,34,1.81,null,"2016-04-01",3.9899999999999998E-2,2.3699999999999999E-2]
[null,"2017-09-01",3.67,33,2.23,null,"2016-07-01",3.0099999999999998E-2,2.0199999999999999E-2]
[null,"2017-10-01",5.28,33,2.4700000000000002,null,"2016-10-01",1.5100000000000001E-2,1.4E-2]
[null,"2017-11-01",4.75,35,2.2999999999999998,null,"2017-01-01",6.5300000000000002E-3,8.4200000000000004E-3]
[null,"2017-12-01",5.09,35,2.52,null,"2017-04-01",2.8400000000000002E-2,2.41E-2]
[null,"2018-01-01",4.66,28,1.75,null,"2017-07-01",4.2999999999999997E-2,3.6999999999999998E-2]
[null,"2018-02-01",5.1100000000000003,28,2.5299999999999998,null,"2017-10-01",3.2899999999999999E-2,2.0199999999999999E-2]
[null,"2018-03-01",5.1100000000000003,28,1.84,null,"2018-01-01",2.1600000000000001E-2,1.61E-2]