{"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":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date","Raw TOC","Raw Alk.","Fin. TOC","Fin. TTHM","Fin HAA5","Comments","DBP IND","Month Date","Quarter Date"]
["2012-01-01",null,null,null,5.6000000000000001E-2,4.7600000000000003E-2,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":"2012-01-01"},{"$f":"IF(\"Q\"&ROUNDUP(MONTH(I2)/3,0)=\"Q1\",VALUE(\"1/1/\"&YEAR(I2)),IF(\"Q\"&ROUNDUP(MONTH(I2)/3,0)=\"Q2\",VALUE(\"4/1/\"&YEAR(I2)),IF(\"Q\"&ROUNDUP(MONTH(I2)/3,0)=\"Q3\",VALUE(\"7/1/\"&YEAR(I2)),IF(\"Q\" & ROUNDUP(MONTH(I2)/3,0)=\"Q4\", VALUE(\"10/1/\"&YEAR(I2)),\"\"))))","v":"2012-01-01"}]
["2012-04-01",null,null,null,5.7200000000000001E-2,2.87E-2,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":"2012-04-01"},"2012-04-01"]
["2012-07-01",null,null,null,3.4099999999999998E-2,1.9300000000000001E-2,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":"2012-07-01"},"2012-07-01"]
["2012-10-01",null,null,null,4.2599999999999999E-2,4.2000000000000003E-2,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":"2012-10-01"},"2012-10-01"]
["2013-01-01",null,null,null,4.7E-2,5.7200000000000001E-2,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":"2013-01-01"},"2013-01-01"]
["2013-04-01",null,null,null,5.1400000000000001E-2,1.5800000000000002E-2,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":"2013-04-01"},"2013-04-01"]
["2013-07-01",null,null,null,3.9399999999999998E-2,1.54E-2,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":"2013-07-01"},"2013-07-01"]
["2013-10-01",null,null,null,5.3199999999999997E-2,3.95E-2,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":"2013-10-01"},"2013-10-01"]
["2014-01-01",null,null,null,3.5310000000000001E-2,3.2599999999999997E-2,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":"2014-01-01"},"2014-01-01"]
["2014-04-01",null,null,null,5.6599999999999998E-2,1.8100000000000002E-2,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":"2014-04-01"},"2014-04-01"]
["2014-07-01",null,null,null,3.9399999999999998E-2,1.5800000000000002E-2,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":"2014-07-01"},"2014-07-01"]
["2014-10-01",null,null,null,3.3799999999999997E-2,1.29E-2,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":"2014-10-01"},"2014-10-01"]
["2015-01-01",null,null,null,4.3499999999999997E-2,5.3100000000000001E-2,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-01-01"},"2015-01-01"]
["2015-01-01",2.2999999999999998,4,1.5,null,null,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":"2015-01-01"},"2015-01-01"]
["2015-02-01",1.2,4,0.9,null,null,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":"2015-02-01"},"2015-01-01"]
["2015-03-01",2.2000000000000002,5,1.3,null,null,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":"2015-03-01"},"2015-01-01"]
["2015-04-01",null,null,null,3.1600000000000003E-2,1.04E-2,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"},"2015-04-01"]
["2015-04-01",5,4,1.4,null,null,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":"2015-04-01"},"2015-04-01"]
["2015-05-01",2.2999999999999998,4,1.1000000000000001,null,null,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":"2015-05-01"},"2015-04-01"]
["2015-06-01",2.6,5,1.3,null,null,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":"2015-06-01"},"2015-04-01"]
["2015-07-01",null,null,null,0.04,1.41E-2,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-07-01",1.5,4,0.8,null,null,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":"2015-07-01"},"2015-07-01"]
["2015-08-01",1.4,5,0.7,null,null,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":"2015-08-01"},"2015-07-01"]
["2015-09-01",1.8,5,0.8,null,null,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":"2015-09-01"},"2015-07-01"]
["2015-10-01",null,null,null,4.3999999999999997E-2,4.3999999999999997E-2,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"]
["2015-10-01",1.5,5,0.8,null,null,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":"2015-10-01"},"2015-10-01"]
["2015-11-01",3.1,5,1.5,null,null,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":"2015-11-01"},"2015-10-01"]
["2015-12-01",4.8,6,2.4,null,null,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":"2015-12-01"},"2015-10-01"]
["2016-01-01",null,null,null,7.4899999999999994E-2,6.3200000000000006E-2,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-01-01",1.4,4,0.9,null,null,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":"2016-01-01"},"2016-01-01"]
["2016-02-01",5.8,5,2.2000000000000002,null,null,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":"2016-02-01"},"2016-01-01"]
["2016-03-01",2.6,4,1.4,null,null,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":"2016-03-01"},"2016-01-01"]
["2016-04-01",null,null,null,2.6800000000000001E-2,1.11E-2,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"},{"$f":"IF(\"Q\"&ROUNDUP(MONTH(I34)/3,0)=\"Q1\",VALUE(\"1/1/\"&YEAR(I34)),IF(\"Q\"&ROUNDUP(MONTH(I34)/3,0)=\"Q2\",VALUE(\"4/1/\"&YEAR(I34)),IF(\"Q\"&ROUNDUP(MONTH(I34)/3,0)=\"Q3\",VALUE(\"7/1/\"&YEAR(I34)),IF(\"Q\" & ROUNDUP(MONTH(I34)/3,0)=\"Q4\", VALUE(\"10/1/\"&YEAR(I34)),\"\"))))","v":"2016-04-01"}]
["2016-04-01",1.8,5,1.1000000000000001,null,null,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":"2016-04-01"},"2016-04-01"]
["2016-05-01",2.2999999999999998,5,1.2,null,null,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":"2016-05-01"},"2016-04-01"]
["2016-06-01",1.6,4,0.7,null,null,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":"2016-06-01"},"2016-04-01"]
["2016-07-01",null,null,null,3.5799999999999998E-2,1.9E-2,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-07-01",3.3,5,2.1,null,null,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":"2016-07-01"},"2016-07-01"]
["2016-08-01",2.4,5,1.4,null,null,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":"2016-08-01"},"2016-07-01"]
["2016-09-01",1.4,4,0.8,null,null,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":"2016-09-01"},"2016-07-01"]
["2016-10-01",null,null,null,3.3599999999999998E-2,1.9099999999999999E-2,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"]
["2016-10-01",1.4,6,0.7,null,null,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":"2016-10-01"},"2016-10-01"]
["2016-11-01",1.9,6,0.9,null,null,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":"2016-11-01"},"2016-10-01"]
["2016-12-01",4,6,2.9,null,null,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":"2016-12-01"},"2016-10-01"]
["2017-01-01",null,null,null,2.2599999999999999E-2,1.15E-2,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-01-15",2.7,4,1.9,null,null,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-01-01"},"2017-01-01"]
["2017-02-18",1.7,6,1,null,null,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-02-01"},"2017-01-01"]
["2017-03-01",3.4,5,2.2999999999999998,null,null,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-03-01"},"2017-01-01"]
["2017-04-01",2.8,5,1.45,null,null,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"},"2017-04-01"]
["2017-04-25",null,null,null,2.4199999999999999E-2,7.9799999999999992E-3,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-05-01",1.8,4,0.9,null,null,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",4,5,2.2000000000000002,null,null,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-20",null,null,null,3.3700000000000001E-2,1.4500000000000001E-2,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-07-20",1.7,6,0.8,null,null,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",1.4,4,0.5,null,null,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.4,6,1.6,null,null,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",1.7,5,0.9,null,null,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-10-15",null,null,null,1.5699999999999999E-2,7.6499999999999997E-3,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"]
["2017-11-01",1.8,5,0.9,null,null,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.2,6,3,null,null,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"]

{"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 # AL000XXXX",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-31"]
[null,"Water Treatment Plant Name"]
[null,"Source Water Name"]
[null,"TOC Results Past 12 Months"]
[null,null,{"$f":"EDATE(N6,-11)","v":"2017-01-01"},{"$f":"EDATE(N6,-10)","v":"2017-02-01"},{"$f":"EDATE(N6,-9)","v":"2017-03-01"},{"$f":"EDATE(N6,-8)","v":"2017-04-01"},{"$f":"EDATE(N6,-7)","v":"2017-05-01"},{"$f":"EDATE(N6,-6)","v":"2017-06-01"},{"$f":"EDATE(N6,-5)","v":"2017-07-01"},{"$f":"EDATE(N6,-4)","v":"2017-08-01"},{"$f":"EDATE(N6,-3)","v":"2017-09-01"},{"$f":"EDATE(N6,-2)","v":"2017-10-01"},{"$f":"EDATE(N6,-1)","v":"2017-11-01"},{"$f":"VALUE(MONTH(P2) &\"/1/\"&YEAR(P2))","v":"2017-12-01"}]
[null,"Raw Alkalinity",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,3)","v":4},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,3)","v":6},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,3)","v":5},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,3)","v":5},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,3)","v":4},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,3)","v":5},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,3)","v":6},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,3)","v":4},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,3)","v":6},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,3)","v":5},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,3)","v":5},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,3)","v":6}]
[null,"Raw TOC",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,2)","v":2.7},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.7},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.4},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,2)","v":2.8},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.8},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,2)","v":4},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.7},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.4},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,2)","v":3.4},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.7},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,2)","v":1.8},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,2)","v":5.2}]
[null,"Finished TOC",{"$f":"VLOOKUP(C6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.9},{"$f":"VLOOKUP(D6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1},{"$f":"VLOOKUP(E6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.2999999999999998},{"$f":"VLOOKUP(F6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.45},{"$f":"VLOOKUP(G6,'Pivot Tables'!$B$3:$E$1048576,4)","v":0.9},{"$f":"VLOOKUP(H6,'Pivot Tables'!$B$3:$E$1048576,4)","v":2.2000000000000002},{"$f":"VLOOKUP(I6,'Pivot Tables'!$B$3:$E$1048576,4)","v":0.8},{"$f":"VLOOKUP(J6,'Pivot Tables'!$B$3:$E$1048576,4)","v":0.5},{"$f":"VLOOKUP(K6,'Pivot Tables'!$B$3:$E$1048576,4)","v":1.6},{"$f":"VLOOKUP(L6,'Pivot Tables'!$B$3:$E$1048576,4)","v":0.9},{"$f":"VLOOKUP(M6,'Pivot Tables'!$B$3:$E$1048576,4)","v":0.9},{"$f":"VLOOKUP(N6,'Pivot Tables'!$B$3:$E$1048576,4)","v":3}]
[null,"Removal Percentage",{"$f":"IFERROR((C8-C9)/C8,\"\")","v":0.29629629629629639},{"$f":"IFERROR((D8-D9)/D8,\"\")","v":0.41176470588235292},0.3235294117647059,0.48214285714285715,0.5,0.44999999999999996,0.52941176470588236,0.64285714285714279,0.52941176470588236,0.47058823529411764,0.5,0.42307692307692307]
[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.35,0.35,0.35,0.35,0.35,0.45]
[null,"Calculated PR",{"$f":"IFERROR(((C8-C9)/C8)/C11,\"\")","v":0.84656084656084685},{"$f":"IFERROR(((D8-D9)/D8)/D11,\"\")","v":1.1764705882352942},0.92436974789915982,1.3775510204081634,1.4285714285714286,1.2857142857142856,1.5126050420168069,1.8367346938775511,1.5126050420168069,1.3445378151260505,1.4285714285714286,0.94017094017094016]
[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},0,1,1,0,1,1,1,1,1,0]
[null,"Selected PR",{"$f":"MAX(C12:C13)","v":1},{"$f":"MAX(D12:D13)","v":1.1764705882352942},0.92436974789915982,1.3775510204081634,1.4285714285714286,1.2857142857142856,1.5126050420168069,1.8367346938775511,1.5126050420168069,1.3445378151260505,1.4285714285714286,0.94017094017094016]
[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.3139918360506597}]
[]
[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,"WTP Effluent Individual DBP Sample Results (Past 3 Years)"]
[null,"WTP Effluent",{"$f":"\"Q\" & ROUNDUP(MONTH(C46)/3,0)&\" \" & YEAR(C46)","v":"Q1 2015"},"Q2 2015","Q3 2015","Q4 2015","Q1 2016","Q2 2016","Q3 2016","Q4 2016","Q1 2017","Q2 2017","Q3 2017",{"$f":"\"Q\" & ROUNDUP(MONTH(N46)/3,0)&\" \" & YEAR(N46)","v":"Q4 2017"}]
[null,"TTHM",{"$f":"VLOOKUP(C46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":43.5},{"$f":"VLOOKUP(D46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":31.6},{"$f":"VLOOKUP(E46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":40},{"$f":"VLOOKUP(F46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":44},{"$f":"VLOOKUP(G46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":74.899999999999991},{"$f":"VLOOKUP(H46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":26.8},{"$f":"VLOOKUP(I46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":35.799999999999997},{"$f":"VLOOKUP(J46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":33.6},{"$f":"VLOOKUP(K46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":22.599999999999998},{"$f":"VLOOKUP(L46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":24.2},{"$f":"VLOOKUP(M46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":33.700000000000003},{"$f":"VLOOKUP(N46,'Pivot Tables'!$G$3:$I$1048576,2)*1000","v":15.7}]
[null,"HAA5",{"$f":"VLOOKUP(C46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":53.1},{"$f":"VLOOKUP(D46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":10.4},{"$f":"VLOOKUP(E46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":14.1},{"$f":"VLOOKUP(F46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":44},{"$f":"VLOOKUP(G46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":63.2},{"$f":"VLOOKUP(H46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":11.1},{"$f":"VLOOKUP(I46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":19},{"$f":"VLOOKUP(J46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":19.099999999999998},{"$f":"VLOOKUP(K46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":11.5},{"$f":"VLOOKUP(L46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":7.9799999999999995},{"$f":"VLOOKUP(M46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":14.5},{"$f":"VLOOKUP(N46,'Pivot Tables'!$G$3:$I$1048576,3)*1000","v":7.6499999999999995}]
[]
[null,"TTHM Goal LRRA ≤ 20 mg/L and HAA5 Goal LRAA ≤ 15 mg/L"]
[null,null,{"$f":"EDATE(D46,-3)","v":"2015-03-01"},"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",{"$f":"EDATE(N6,0)","v":"2017-12-01"}]

{"sheet":"Pivot Tables","index":2,"n_rows":39,"n_cols":9,"rows_kept":39,"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,"2015-01-01",2.2999999999999998,4,1.5,null,"2012-01-01",5.6000000000000001E-2,4.7600000000000003E-2]
[null,"2015-02-01",1.2,4,0.9,null,"2012-04-01",5.7200000000000001E-2,2.87E-2]
[null,"2015-03-01",2.2000000000000002,5,1.3,null,"2012-07-01",3.4099999999999998E-2,1.9300000000000001E-2]
[null,"2015-04-01",5,4,1.4,null,"2012-10-01",4.2599999999999999E-2,4.2000000000000003E-2]
[null,"2015-05-01",2.2999999999999998,4,1.1000000000000001,null,"2013-01-01",4.7E-2,5.7200000000000001E-2]
[null,"2015-06-01",2.6,5,1.3,null,"2013-04-01",5.1400000000000001E-2,1.5800000000000002E-2]
[null,"2015-07-01",1.5,4,0.8,null,"2013-07-01",3.9399999999999998E-2,1.54E-2]
[null,"2015-08-01",1.4,5,0.7,null,"2013-10-01",5.3199999999999997E-2,3.95E-2]
[null,"2015-09-01",1.8,5,0.8,null,"2014-01-01",3.5310000000000001E-2,3.2599999999999997E-2]
[null,"2015-10-01",1.5,5,0.8,null,"2014-04-01",5.6599999999999998E-2,1.8100000000000002E-2]
[null,"2015-11-01",3.1,5,1.5,null,"2014-07-01",3.9399999999999998E-2,1.5800000000000002E-2]
[null,"2015-12-01",4.8,6,2.4,null,"2014-10-01",3.3799999999999997E-2,1.29E-2]
[null,"2016-01-01",1.4,4,0.9,null,"2015-01-01",4.3499999999999997E-2,5.3100000000000001E-2]
[null,"2016-02-01",5.8,5,2.2000000000000002,null,"2015-04-01",3.1600000000000003E-2,1.04E-2]
[null,"2016-03-01",2.6,4,1.4,null,"2015-07-01",0.04,1.41E-2]
[null,"2016-04-01",1.8,5,1.1000000000000001,null,"2015-10-01",4.3999999999999997E-2,4.3999999999999997E-2]
[null,"2016-05-01",2.2999999999999998,5,1.2,null,"2016-01-01",7.4899999999999994E-2,6.3200000000000006E-2]
[null,"2016-06-01",1.6,4,0.7,null,"2016-04-01",2.6800000000000001E-2,1.11E-2]
[null,"2016-07-01",3.3,5,2.1,null,"2016-07-01",3.5799999999999998E-2,1.9E-2]
[null,"2016-08-01",2.4,5,1.4,null,"2016-10-01",3.3599999999999998E-2,1.9099999999999999E-2]
[null,"2016-09-01",1.4,4,0.8,null,"2017-01-01",2.2599999999999999E-2,1.15E-2]
[null,"2016-10-01",1.4,6,0.7,null,"2017-04-01",2.4199999999999999E-2,7.9799999999999992E-3]
[null,"2016-11-01",1.9,6,0.9,null,"2017-07-01",3.3700000000000001E-2,1.4500000000000001E-2]
[null,"2016-12-01",4,6,2.9,null,"2017-10-01",1.5699999999999999E-2,7.6499999999999997E-3]
[null,"2017-01-01",2.7,4,1.9]
[null,"2017-02-01",1.7,6,1]
[null,"2017-03-01",3.4,5,2.2999999999999998]
[null,"2017-04-01",2.8,5,1.45]
[null,"2017-05-01",1.8,4,0.9]
[null,"2017-06-01",4,5,2.2000000000000002]
[null,"2017-07-01",1.7,6,0.8]
[null,"2017-08-01",1.4,4,0.5]
[null,"2017-09-01",3.4,6,1.6]
[null,"2017-10-01",1.7,5,0.9]
[null,"2017-11-01",1.8,5,0.9]
[null,"2017-12-01",5.2,6,3]