{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Instructions","DataEntryPaste","DataEntryValues","Summary","OptimizationTrend","LogProfile","MaxSed","SedSum","MaxFilter","FilterSum(1-4)","FilterSum(5-8)","FilterSum(9-12)","BW Data","BW Data Chart","BW Data PT","LT-Trend","LT-Settle","PT setup","LT-Filter","AllDataSort","MonthDist"],"not_rendered":{"charts":33,"images":2,"macros":1,"external_links":0,"defined_names":80,"comments":4,"pivot_tables":1},"unopened":[{"sheet":"LogProfile","index":5,"reason":"not_a_worksheet"},{"sheet":"MaxSed","index":6,"reason":"not_a_worksheet"},{"sheet":"MaxFilter","index":8,"reason":"not_a_worksheet"},{"sheet":"BW Data Chart","index":13,"reason":"not_a_worksheet"},{"sheet":"LT-Settle","index":16,"reason":"not_a_worksheet"},{"sheet":"LT-Filter","index":18,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":78,"n_cols":4,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"Optimization Assessment Software - Version 33"]
[null,"Instructions"]
["Entering data from another spreadsheet (copy/pasting):"]
["1.","When entering data sets from another spreadsheet, use the DataEntryPaste worksheet.  This will"]
[null,"reduce problems that could occur due to formatting differences.  "]
["2.","Before entering new data, you should clear the data entry area of any pre-existing data.  This can be"]
[null,"performed by clicking on the CLEAR button."]
["3.","After the data is entered, click the TRANSFER button to transfer the data to the database"]
[null,"i.e., Data Entry Values worksheet."]
[null,"Warning! The transfer button replaces all values in the Data Entry Values worksheet."]
["4.","Go to the DataEntryValues worksheet and enter the plant name and performance goals."]
["5.","Click the UPDATE button to develop the Summary and Optimization Trend Reports."]
[]
["Entering individual data from plant records:"]
["1.","When entering daily data from plant records, use the DataEntryValues worksheet."]
["2.","Before entering new data, you should clear the database of any pre-existing data.  This can be "]
[null,"performed by clicking on the CLEAR button."]
["3.","After data is entered, click on the UPDATE button to develop the Summary and Optimization Trend"]
[null,"Reports."]
[]
[]
[]
[]
[]
[null,{"$f":"B1","v":"Optimization Assessment Software - Version 33"}]
[null,"FILE:","Turb-opt12filtersV33.xlsm"]
[null,"AUTHOR:","L. DeMers, K. Rakness, B. Hegg"]
[null,"COMPANY:","Process Applications, Inc."]
[null,"PURPOSE:","To assess particulate removal in surface water treatment plants"]
[]
[null,"DATE MODIFIED:",null,"MODIFICATIONS & BY WHOM:"]
[null,"1999-04-15","LDD initiated program development."]
[null,"1999-05-26","LDD modified program to include individual sedimentation and filter graphs."]
[null,"1999-05-27","LDD modified program to indicate \"out of range\" warning for filter turbidity data entry."]
[null,"1999-07-23","LDD initiated program modifications to use percentile calculation."]
[null,"1999-09-23","LDD added column for combined filter effluent turbidity."]
[null,null,"Modifications also made to use percentile calculations."]
[null,"1999-09-25","LDD modified program to include optimization goal tracking features."]
[null,"1999-11-24","LDD added worst filter cell conditions and screen hide during macro."]
[null,"1999-11-28","LDD added worst sed basin cell conditions."]
[null,"1999-12-16","LDD corrected 95% calc. error in max. sed. and filter columns."]
[null,null,"LDD modified to data input to allow up to 12 filters."]
[null,"1999-12-17","LDD modified annual statistics to exclude STDEV and include % time meeting reg."]
[null,null,"requirement."]
[null,"2000-03-03","LDD fixed y-axis on individual sed and filter graphs"]
[null,"2000-05-13","LDD corrected Leap Year problem (temporary fix until modifications to account for both"]
[null,null,"Leap Year and non-Leap year data input is completed)."]
[null,"2000-06-08","LDD/KLR corrected Leap Year problem to allow data input for both Leap Year and non "]
[null,null,"Leap Year data."]
[null,"2000-11-28","LDD corrected error in max filter turbidity calc on DataEntryValues worksheet.  Saved"]
[null,null,"as turb-opt23p.xls."]
[null,"2001-03-27","LDD corrected error in max settled water graph to plot the max value from four sed"]
[null,null,"basins (versus the value from sed basin 1).  Also corrected date range in same graph."]
[null,null,"Saved as turb-opt24a.xls."]
[null,"2001-04-18","LDD added \"Yes/No\" step to clear macros.  Changed color of macro buttons."]
[null,"2002-08-23","LDD added LT-Trend worksheet to support LT Trend companion spreadsheet."]
[null,null,"Corrected y-axis lable on MaxFilter chart.  Saved as turb-opt26a.xls."]
[null,"2003-04-20","LDD added data entry cell for public water system number."]
[null,"2003-04-20","LDD added annual calculations for individual basin/filter 95th % and % values meeting"]
[null,null,"goal calculations.  Saved as turb-opt27.xls."]
[null,"2007-02-07","LDD modified % settled water turbidity meeting goals to include all available sed basin"]
[null,null,"data (Optimization Trend report)."]
[null,null,"RSQ calculation was modified for combined filter turbidity to include max. filtered water"]
[null,null,"turbidity and combined turbidity."]
[null,"2011-06-03","LDD updated spreadsheet to Excel 2010 version (.xlsm file format)."]
[null,null,"Changed name to Turb-optV30.xlsm."]
[null,"2012-02-27","LDD modified all sed basin calculation in Optimization Trend Report to be consistent"]
[null,null,"with calculation in 36 filter OAS (i.e., 95th P of all sed basin data)."]
[null,null,"Named file Turb-opt12filtersV31.xlsm."]
[null,"2014-08-14","LDD added \"Yes/No\" step to Transfer button for DataEntryPaste."]
[null,null,"Added conditional formatting for data entry cells that are less than or equal to 0.02 NTU,"]
[null,null,"indicating a potential data integrity issue."]
[null,null,"Updated % goal formulas and removed lookup tables."]
[null,null,"Added All Filter calculation and replaced CFE summary chart."]
[null,"2017-03-20","Moved filter backwash trending features to this worksheet using pivot table and charts."]
[null,"2017-04-03","Moved long-term trending features to this spreadsheet."]
[null,null,"Updated file name to Turb-opt12filtersV33.xlsm."]
[null,"Model developed by: Process Applications, Inc. Fort Collins, CO 970-223-5787"]

{"sheet":"DataEntryPaste","index":1,"n_rows":380,"n_cols":19,"rows_kept":380,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Instruction to users:  Paste plant turbidity data sets into the data entry area below.  The "]
[null,"data entry area will hold 366 days of data.  Following data input, transfer data to the"]
[null,"database by clicking on the data TRANSFER button.  Go to the DataEntryValues "]
[null,"worksheet to enter the plant name and performance goals."]
[]
[]
[]
[]
[]
[]
["Data Entry Area for Posting Data Sets"]
["Date","Raw","Sed 1","Sed 2","Sed 3","Sed 4","Filter 1","Filter 2","Filter 3","Filter 4","Filter 5","Filter 6","Filter 7","Filter 8","Filter 9","Filter 10","Filter 11","Filter 12","Combined"]
["2016-01-01"]
[{"$f":"A15+1","v":"2016-01-02"}]
[{"$f":"A16+1","v":"2016-01-03"}]
["2016-01-04"]
["2016-01-05"]
["2016-01-06"]
["2016-01-07"]
["2016-01-08"]
["2016-01-09"]
["2016-01-10"]
["2016-01-11"]
["2016-01-12"]
["2016-01-13"]
["2016-01-14"]
["2016-01-15"]
["2016-01-16"]
["2016-01-17"]
["2016-01-18"]
["2016-01-19"]
["2016-01-20"]
["2016-01-21"]
["2016-01-22"]
["2016-01-23"]
["2016-01-24"]
["2016-01-25"]
["2016-01-26"]
["2016-01-27"]
["2016-01-28"]
["2016-01-29"]
["2016-01-30"]
["2016-01-31"]
["2016-02-01"]
["2016-02-02"]
["2016-02-03"]
["2016-02-04"]
["2016-02-05"]
["2016-02-06"]
["2016-02-07"]
["2016-02-08"]
["2016-02-09"]
["2016-02-10"]
["2016-02-11"]
["2016-02-12"]
["2016-02-13"]
["2016-02-14"]
["2016-02-15"]
["2016-02-16"]
["2016-02-17"]
["2016-02-18"]
["2016-02-19"]
["2016-02-20"]
["2016-02-21"]
["2016-02-22"]
["2016-02-23"]
["2016-02-24"]
["2016-02-25"]
["2016-02-26"]
["2016-02-27"]
["2016-02-28"]
["2016-02-29"]
["2016-03-01"]
["2016-03-02"]
["2016-03-03"]
["2016-03-04"]
["2016-03-05"]
["2016-03-06"]
[{"$f":"A80+1","v":"2016-03-07"}]
["2016-03-08"]
["2016-03-09"]
["2016-03-10"]
["2016-03-11"]
["2016-03-12"]
["2016-03-13"]
["2016-03-14"]
["2016-03-15"]
["2016-03-16"]
["2016-03-17"]
["2016-03-18"]
["2016-03-19"]
["2016-03-20"]
["2016-03-21"]
["2016-03-22"]
["2016-03-23"]
["2016-03-24"]
["2016-03-25"]
["2016-03-26"]
["2016-03-27"]
["2016-03-28"]
["2016-03-29"]
["2016-03-30"]
["2016-03-31"]
["2016-04-01"]
["2016-04-02"]
["2016-04-03"]
["2016-04-04"]
["2016-04-05"]
["2016-04-06"]
["2016-04-07"]
["2016-04-08"]
["2016-04-09"]
["2016-04-10"]
["2016-04-11"]
["2016-04-12"]
["2016-04-13"]
["2016-04-14"]
["2016-04-15"]
["2016-04-16"]
["2016-04-17"]
["2016-04-18"]
["2016-04-19"]
["2016-04-20"]
["2016-04-21"]
["2016-04-22"]
["2016-04-23"]
["2016-04-24"]
["2016-04-25"]
["2016-04-26"]
["2016-04-27"]
["2016-04-28"]
["2016-04-29"]
["2016-04-30"]
["2016-05-01"]
["2016-05-02"]
["2016-05-03"]
["2016-05-04"]
["2016-05-05"]
["2016-05-06"]
["2016-05-07"]
["2016-05-08"]
["2016-05-09"]
[{"$f":"A144+1","v":"2016-05-10"}]
["2016-05-11"]
["2016-05-12"]
["2016-05-13"]
["2016-05-14"]
["2016-05-15"]
["2016-05-16"]
["2016-05-17"]
["2016-05-18"]
["2016-05-19"]
["2016-05-20"]
["2016-05-21"]
["2016-05-22"]
["2016-05-23"]
["2016-05-24"]
["2016-05-25"]
["2016-05-26"]
["2016-05-27"]
["2016-05-28"]
["2016-05-29"]
["2016-05-30"]
["2016-05-31"]
["2016-06-01"]
["2016-06-02"]
["2016-06-03"]
["2016-06-04"]
["2016-06-05"]
["2016-06-06"]
["2016-06-07"]
["2016-06-08"]
["2016-06-09"]
["2016-06-10"]
["2016-06-11"]
["2016-06-12"]
["2016-06-13"]
["2016-06-14"]
["2016-06-15"]
["2016-06-16"]
["2016-06-17"]
["2016-06-18"]
["2016-06-19"]
["2016-06-20"]
["2016-06-21"]
["2016-06-22"]
["2016-06-23"]
["2016-06-24"]
["2016-06-25"]
["2016-06-26"]
["2016-06-27"]
["2016-06-28"]
["2016-06-29"]
["2016-06-30"]
["2016-07-01"]
["2016-07-02"]
["2016-07-03"]
["2016-07-04"]
["2016-07-05"]
["2016-07-06"]
["2016-07-07"]
["2016-07-08"]
["2016-07-09"]
["2016-07-10"]
["2016-07-11"]
["2016-07-12"]
[{"$f":"A208+1","v":"2016-07-13"}]
["2016-07-14"]
["2016-07-15"]
["2016-07-16"]
["2016-07-17"]
["2016-07-18"]
["2016-07-19"]
["2016-07-20"]
["2016-07-21"]
["2016-07-22"]
["2016-07-23"]
["2016-07-24"]
["2016-07-25"]
["2016-07-26"]
["2016-07-27"]
["2016-07-28"]
["2016-07-29"]
["2016-07-30"]
["2016-07-31"]
["2016-08-01"]
["2016-08-02"]
["2016-08-03"]
["2016-08-04"]
["2016-08-05"]
["2016-08-06"]
["2016-08-07"]
["2016-08-08"]
["2016-08-09"]
["2016-08-10"]
["2016-08-11"]
["2016-08-12"]
["2016-08-13"]
["2016-08-14"]
["2016-08-15"]
["2016-08-16"]
["2016-08-17"]
["2016-08-18"]
["2016-08-19"]
["2016-08-20"]
["2016-08-21"]
["2016-08-22"]
["2016-08-23"]
["2016-08-24"]
["2016-08-25"]
["2016-08-26"]
["2016-08-27"]
["2016-08-28"]
["2016-08-29"]
["2016-08-30"]
["2016-08-31"]
["2016-09-01"]
["2016-09-02"]
["2016-09-03"]
["2016-09-04"]
["2016-09-05"]
["2016-09-06"]
["2016-09-07"]
["2016-09-08"]
["2016-09-09"]
["2016-09-10"]
["2016-09-11"]
["2016-09-12"]
["2016-09-13"]
["2016-09-14"]
[{"$f":"A272+1","v":"2016-09-15"}]
["2016-09-16"]
["2016-09-17"]
["2016-09-18"]
["2016-09-19"]
["2016-09-20"]
["2016-09-21"]
["2016-09-22"]
["2016-09-23"]
["2016-09-24"]
["2016-09-25"]
["2016-09-26"]
["2016-09-27"]
["2016-09-28"]
["2016-09-29"]
["2016-09-30"]
["2016-10-01"]
["2016-10-02"]
["2016-10-03"]
["2016-10-04"]
["2016-10-05"]
["2016-10-06"]
["2016-10-07"]
["2016-10-08"]
["2016-10-09"]
["2016-10-10"]
["2016-10-11"]
["2016-10-12"]
["2016-10-13"]
["2016-10-14"]
["2016-10-15"]
["2016-10-16"]
["2016-10-17"]
["2016-10-18"]
["2016-10-19"]
["2016-10-20"]
["2016-10-21"]
["2016-10-22"]
["2016-10-23"]
["2016-10-24"]
["2016-10-25"]
["2016-10-26"]
["2016-10-27"]
["2016-10-28"]
["2016-10-29"]
["2016-10-30"]
["2016-10-31"]
["2016-11-01"]
["2016-11-02"]
["2016-11-03"]
["2016-11-04"]
["2016-11-05"]
["2016-11-06"]
["2016-11-07"]
["2016-11-08"]
["2016-11-09"]
["2016-11-10"]
["2016-11-11"]
["2016-11-12"]
["2016-11-13"]
["2016-11-14"]
["2016-11-15"]
["2016-11-16"]
["2016-11-17"]
[{"$f":"A336+1","v":"2016-11-18"}]
["2016-11-19"]
["2016-11-20"]
["2016-11-21"]
["2016-11-22"]
["2016-11-23"]
["2016-11-24"]
["2016-11-25"]
["2016-11-26"]
["2016-11-27"]
["2016-11-28"]
["2016-11-29"]
["2016-11-30"]
["2016-12-01"]
["2016-12-02"]
["2016-12-03"]
["2016-12-04"]
["2016-12-05"]
["2016-12-06"]
["2016-12-07"]
["2016-12-08"]
["2016-12-09"]
["2016-12-10"]
["2016-12-11"]
["2016-12-12"]
["2016-12-13"]
["2016-12-14"]
["2016-12-15"]
["2016-12-16"]
["2016-12-17"]
["2016-12-18"]
["2016-12-19"]
["2016-12-20"]
["2016-12-21"]
["2016-12-22"]
["2016-12-23"]
["2016-12-24"]
["2016-12-25"]
["2016-12-26"]
["2016-12-27"]
["2016-12-28"]
["2016-12-29"]
["2016-12-30"]
["2016-12-31"]

{"sheet":"DataEntryValues","index":2,"n_rows":380,"n_cols":32,"rows_kept":380,"cut":false,"hidden":false,"merged":[[1,6,1,10],[3,6,3,10],[4,6,4,10],[5,6,5,10],[2,6,2,10]]}
[]
[null,"Plant Name",null,null,null,null,"Rocky Mountain Water District"]
[null,"PWS #",null,null,null,null,1031009]
[null,"Max. settled water turbidity goal",null,null,null,null,2]
[null,"Filtered water turbidity optimization goal",null,null,null,null,0.1]
[null,"Filtered water turbidity regulation",null,null,null,null,0.3]
[null,"Instruction to users:  Input plant name and turbidity goals above.  Input start date"]
[null,"and turbidity data below.  The database will hold 366 days of data.  The turbidity data"]
[null,"entry cells will turn yellow if the value exceeds the process goal.  The IFE and CFE cells"]
[null,"will turn red if the value is less than or equal to 0.02 NTU (suggesting checking"]
[null,"intrument O&M and sample flow rate).  Following data input, develop the reports"]
[null,"by clicking the UPDATE button."]
["Data Entry Area"]
[null,"Raw","Sed 1","Sed 2","Sed 3","Sed 4","Filter 1","Filter 2","Filter 3","Filter 4","Filter 5","Filter 6","Filter 7","Filter 8","Filter 9","Filter 10","Filter 11","Filter 12","Combined",null,null,null,null,null,null,null,"MaxSed","MaxSedPlot","Sed Goal","Max Filter","MaxFilterPlot","Filter Goal"]
["2016-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"MAX(C15:F15)","v":0},null,{"$f":"$G$4","v":2},{"$f":"MAX(G15:R15)","v":0},null,{"$f":"$G$5","v":0.1}]
[{"$f":"A15+1","v":"2016-01-02"},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":"Z15+1","v":2},{"$f":"MAX(C16:F16)","v":0},null,2,{"$f":"MAX(G16:R16)","v":0},null,0.1]
["2016-01-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,null,2,0,null,0.1]
["2016-01-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,null,2,0,null,0.1]
["2016-01-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,null,2,0,null,0.1]
["2016-01-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,null,2,0,null,0.1]
["2016-01-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,2,0,null,0.1]
["2016-01-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,null,2,0,null,0.1]
["2016-01-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,null,2,0,null,0.1]
["2016-01-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,null,2,0,null,0.1]
["2016-01-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0,null,2,0,null,0.1]
["2016-01-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,null,2,0,null,0.1]
["2016-01-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,null,2,0,null,0.1]
["2016-01-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,null,2,0,null,0.1]
["2016-01-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,null,2,0,null,0.1]
["2016-01-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,null,2,0,null,0.1]
["2016-01-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,null,2,0,null,0.1]
["2016-01-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,null,2,0,null,0.1]
["2016-01-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,null,2,0,null,0.1]
["2016-01-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,null,2,0,null,0.1]
["2016-01-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,null,2,0,null,0.1]
["2016-01-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,null,2,0,null,0.1]
["2016-01-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,null,2,0,null,0.1]
["2016-01-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,null,2,0,null,0.1]
["2016-01-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,null,2,0,null,0.1]
["2016-01-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0,null,2,0,null,0.1]
["2016-01-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0,null,2,0,null,0.1]
["2016-01-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,null,2,0,null,0.1]
["2016-01-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,null,2,0,null,0.1]
["2016-01-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,null,2,0,null,0.1]
["2016-01-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0,null,2,0,null,0.1]
["2016-02-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0,null,2,0,null,0.1]
["2016-02-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,null,2,0,null,0.1]
["2016-02-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0,null,2,0,null,0.1]
["2016-02-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0,null,2,0,null,0.1]
["2016-02-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0,null,2,0,null,0.1]
["2016-02-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0,null,2,0,null,0.1]
["2016-02-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0,null,2,0,null,0.1]
["2016-02-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0,null,2,0,null,0.1]
["2016-02-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0,null,2,0,null,0.1]
["2016-02-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0,null,2,0,null,0.1]
["2016-02-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0,null,2,0,null,0.1]
["2016-02-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0,null,2,0,null,0.1]
["2016-02-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0,null,2,0,null,0.1]
["2016-02-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0,null,2,0,null,0.1]
["2016-02-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0,null,2,0,null,0.1]
["2016-02-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0,null,2,0,null,0.1]
["2016-02-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0,null,2,0,null,0.1]
["2016-02-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0,null,2,0,null,0.1]
["2016-02-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0,null,2,0,null,0.1]
["2016-02-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0,null,2,0,null,0.1]
["2016-02-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0,null,2,0,null,0.1]
["2016-02-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0,null,2,0,null,0.1]
["2016-02-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0,null,2,0,null,0.1]
["2016-02-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0,null,2,0,null,0.1]
["2016-02-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0,null,2,0,null,0.1]
["2016-02-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0,null,2,0,null,0.1]
["2016-02-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0,null,2,0,null,0.1]
["2016-02-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0,null,2,0,null,0.1]
["2016-02-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0,null,2,0,null,0.1]
["2016-03-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0,null,2,0,null,0.1]
["2016-03-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0,null,2,0,null,0.1]
["2016-03-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0,null,2,0,null,0.1]
["2016-03-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0,null,2,0,null,0.1]
["2016-03-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0,null,{"$f":"$G$4","v":2},0,null,{"$f":"$G$5","v":0.1}]
[{"$f":"A79+1","v":"2016-03-06"},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":"Z79+1","v":66},{"$f":"MAX(C80:F80)","v":0},null,2,{"$f":"MAX(G80:R80)","v":0},null,0.1]
["2016-03-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0,null,2,0,null,0.1]
["2016-03-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,0,null,2,0,null,0.1]
["2016-03-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,0,null,2,0,null,0.1]
["2016-03-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,0,null,2,0,null,0.1]
["2016-03-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,0,null,2,0,null,0.1]
["2016-03-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,0,null,2,0,null,0.1]
["2016-03-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,0,null,2,0,null,0.1]
["2016-03-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,0,null,2,0,null,0.1]
["2016-03-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,0,null,2,0,null,0.1]
["2016-03-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,0,null,2,0,null,0.1]
["2016-03-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,0,null,2,0,null,0.1]
["2016-03-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,0,null,2,0,null,0.1]
["2016-03-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,0,null,2,0,null,0.1]
["2016-03-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0,null,2,0,null,0.1]
["2016-03-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,0,null,2,0,null,0.1]
["2016-03-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,0,null,2,0,null,0.1]
["2016-03-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,0,null,2,0,null,0.1]
["2016-03-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,0,null,2,0,null,0.1]
["2016-03-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,0,null,2,0,null,0.1]
["2016-03-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,0,null,2,0,null,0.1]
["2016-03-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,0,null,2,0,null,0.1]
["2016-03-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,0,null,2,0,null,0.1]
["2016-03-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,0,null,2,0,null,0.1]
["2016-03-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,0,null,2,0,null,0.1]
["2016-03-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,0,null,2,0,null,0.1]
["2016-04-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,0,null,2,0,null,0.1]
["2016-04-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,0,null,2,0,null,0.1]
["2016-04-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,0,null,2,0,null,0.1]
["2016-04-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,0,null,2,0,null,0.1]
["2016-04-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,0,null,2,0,null,0.1]
["2016-04-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,0,null,2,0,null,0.1]
["2016-04-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,0,null,2,0,null,0.1]
["2016-04-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,0,null,2,0,null,0.1]
["2016-04-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,0,null,2,0,null,0.1]
["2016-04-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,0,null,2,0,null,0.1]
["2016-04-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,0,null,2,0,null,0.1]
["2016-04-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,0,null,2,0,null,0.1]
["2016-04-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,0,null,2,0,null,0.1]
["2016-04-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,0,null,2,0,null,0.1]
["2016-04-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,0,null,2,0,null,0.1]
["2016-04-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,0,null,2,0,null,0.1]
["2016-04-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,0,null,2,0,null,0.1]
["2016-04-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,0,null,2,0,null,0.1]
["2016-04-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,0,null,2,0,null,0.1]
["2016-04-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,0,null,2,0,null,0.1]
["2016-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,0,null,2,0,null,0.1]
["2016-04-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,0,null,2,0,null,0.1]
["2016-04-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,0,null,2,0,null,0.1]
["2016-04-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,0,null,2,0,null,0.1]
["2016-04-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,0,null,2,0,null,0.1]
["2016-04-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,0,null,2,0,null,0.1]
["2016-04-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,0,null,2,0,null,0.1]
["2016-04-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,0,null,2,0,null,0.1]
["2016-04-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,0,null,2,0,null,0.1]
["2016-04-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,0,null,2,0,null,0.1]
["2016-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,0,null,2,0,null,0.1]
["2016-05-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,0,null,2,0,null,0.1]
["2016-05-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,0,null,2,0,null,0.1]
["2016-05-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,0,null,2,0,null,0.1]
["2016-05-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,0,null,2,0,null,0.1]
["2016-05-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,0,null,2,0,null,0.1]
["2016-05-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,0,null,2,0,null,0.1]
["2016-05-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,0,null,{"$f":"$G$4","v":2},0,null,{"$f":"$G$5","v":0.1}]
[{"$f":"A143+1","v":"2016-05-09"},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":"Z143+1","v":130},{"$f":"MAX(C144:F144)","v":0},null,2,{"$f":"MAX(G144:R144)","v":0},null,0.1]
["2016-05-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,0,null,2,0,null,0.1]
["2016-05-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,0,null,2,0,null,0.1]
["2016-05-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,0,null,2,0,null,0.1]
["2016-05-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,0,null,2,0,null,0.1]
["2016-05-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,0,null,2,0,null,0.1]
["2016-05-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,0,null,2,0,null,0.1]
["2016-05-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,0,null,2,0,null,0.1]
["2016-05-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,0,null,2,0,null,0.1]
["2016-05-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,0,null,2,0,null,0.1]
["2016-05-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,0,null,2,0,null,0.1]
["2016-05-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,0,null,2,0,null,0.1]
["2016-05-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,0,null,2,0,null,0.1]
["2016-05-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,0,null,2,0,null,0.1]
["2016-05-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,0,null,2,0,null,0.1]
["2016-05-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,0,null,2,0,null,0.1]
["2016-05-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,0,null,2,0,null,0.1]
["2016-05-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,0,null,2,0,null,0.1]
["2016-05-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,0,null,2,0,null,0.1]
["2016-05-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,0,null,2,0,null,0.1]
["2016-05-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,0,null,2,0,null,0.1]
["2016-05-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,0,null,2,0,null,0.1]
["2016-05-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,0,null,2,0,null,0.1]
["2016-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153,0,null,2,0,null,0.1]
["2016-06-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154,0,null,2,0,null,0.1]
["2016-06-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,0,null,2,0,null,0.1]
["2016-06-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,0,null,2,0,null,0.1]
["2016-06-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157,0,null,2,0,null,0.1]
["2016-06-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158,0,null,2,0,null,0.1]
["2016-06-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159,0,null,2,0,null,0.1]
["2016-06-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,0,null,2,0,null,0.1]
["2016-06-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161,0,null,2,0,null,0.1]
["2016-06-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,0,null,2,0,null,0.1]
["2016-06-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163,0,null,2,0,null,0.1]
["2016-06-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,164,0,null,2,0,null,0.1]
["2016-06-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165,0,null,2,0,null,0.1]
["2016-06-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,166,0,null,2,0,null,0.1]
["2016-06-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167,0,null,2,0,null,0.1]
["2016-06-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,0,null,2,0,null,0.1]
["2016-06-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,169,0,null,2,0,null,0.1]
["2016-06-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,0,null,2,0,null,0.1]
["2016-06-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,171,0,null,2,0,null,0.1]
["2016-06-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,172,0,null,2,0,null,0.1]
["2016-06-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,0,null,2,0,null,0.1]
["2016-06-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,174,0,null,2,0,null,0.1]
["2016-06-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,0,null,2,0,null,0.1]
["2016-06-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,176,0,null,2,0,null,0.1]
["2016-06-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,177,0,null,2,0,null,0.1]
["2016-06-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,178,0,null,2,0,null,0.1]
["2016-06-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,179,0,null,2,0,null,0.1]
["2016-06-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,0,null,2,0,null,0.1]
["2016-06-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,181,0,null,2,0,null,0.1]
["2016-06-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,182,0,null,2,0,null,0.1]
["2016-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,183,0,null,2,0,null,0.1]
["2016-07-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,184,0,null,2,0,null,0.1]
["2016-07-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,0,null,2,0,null,0.1]
["2016-07-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,186,0,null,2,0,null,0.1]
["2016-07-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187,0,null,2,0,null,0.1]
["2016-07-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,188,0,null,2,0,null,0.1]
["2016-07-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,189,0,null,2,0,null,0.1]
["2016-07-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,0,null,2,0,null,0.1]
["2016-07-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191,0,null,2,0,null,0.1]
["2016-07-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,192,0,null,2,0,null,0.1]
["2016-07-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,193,0,null,{"$f":"$G$4","v":2},0,null,{"$f":"$G$5","v":0.1}]
[{"$f":"A207+1","v":"2016-07-12"},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":"Z207+1","v":194},{"$f":"MAX(C208:F208)","v":0},null,2,{"$f":"MAX(G208:R208)","v":0},null,0.1]
["2016-07-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195,0,null,2,0,null,0.1]
["2016-07-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,196,0,null,2,0,null,0.1]
["2016-07-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,197,0,null,2,0,null,0.1]
["2016-07-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198,0,null,2,0,null,0.1]
["2016-07-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,199,0,null,2,0,null,0.1]
["2016-07-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,0,null,2,0,null,0.1]
["2016-07-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201,0,null,2,0,null,0.1]
["2016-07-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,202,0,null,2,0,null,0.1]
["2016-07-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,203,0,null,2,0,null,0.1]
["2016-07-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,204,0,null,2,0,null,0.1]
["2016-07-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205,0,null,2,0,null,0.1]
["2016-07-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206,0,null,2,0,null,0.1]
["2016-07-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207,0,null,2,0,null,0.1]
["2016-07-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,0,null,2,0,null,0.1]
["2016-07-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,209,0,null,2,0,null,0.1]
["2016-07-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,0,null,2,0,null,0.1]
["2016-07-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211,0,null,2,0,null,0.1]
["2016-07-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212,0,null,2,0,null,0.1]
["2016-07-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213,0,null,2,0,null,0.1]
["2016-08-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,214,0,null,2,0,null,0.1]
["2016-08-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,0,null,2,0,null,0.1]
["2016-08-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,216,0,null,2,0,null,0.1]
["2016-08-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,217,0,null,2,0,null,0.1]
["2016-08-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,218,0,null,2,0,null,0.1]
["2016-08-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,219,0,null,2,0,null,0.1]
["2016-08-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,0,null,2,0,null,0.1]
["2016-08-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221,0,null,2,0,null,0.1]
["2016-08-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,0,null,2,0,null,0.1]
["2016-08-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223,0,null,2,0,null,0.1]
["2016-08-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,224,0,null,2,0,null,0.1]
["2016-08-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,225,0,null,2,0,null,0.1]
["2016-08-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,226,0,null,2,0,null,0.1]
["2016-08-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,227,0,null,2,0,null,0.1]
["2016-08-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,228,0,null,2,0,null,0.1]
["2016-08-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229,0,null,2,0,null,0.1]
["2016-08-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,0,null,2,0,null,0.1]
["2016-08-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,231,0,null,2,0,null,0.1]
["2016-08-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,232,0,null,2,0,null,0.1]
["2016-08-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,233,0,null,2,0,null,0.1]
["2016-08-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,234,0,null,2,0,null,0.1]
["2016-08-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,235,0,null,2,0,null,0.1]
["2016-08-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,236,0,null,2,0,null,0.1]
["2016-08-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237,0,null,2,0,null,0.1]
["2016-08-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,238,0,null,2,0,null,0.1]
["2016-08-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,239,0,null,2,0,null,0.1]
["2016-08-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,0,null,2,0,null,0.1]
["2016-08-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,241,0,null,2,0,null,0.1]
["2016-08-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,242,0,null,2,0,null,0.1]
["2016-08-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,0,null,2,0,null,0.1]
["2016-08-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,244,0,null,2,0,null,0.1]
["2016-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,245,0,null,2,0,null,0.1]
["2016-09-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,246,0,null,2,0,null,0.1]
["2016-09-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,247,0,null,2,0,null,0.1]
["2016-09-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,248,0,null,2,0,null,0.1]
["2016-09-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,249,0,null,2,0,null,0.1]
["2016-09-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,0,null,2,0,null,0.1]
["2016-09-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,251,0,null,2,0,null,0.1]
["2016-09-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,252,0,null,2,0,null,0.1]
["2016-09-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,253,0,null,2,0,null,0.1]
["2016-09-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,254,0,null,2,0,null,0.1]
["2016-09-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,255,0,null,2,0,null,0.1]
["2016-09-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,256,0,null,2,0,null,0.1]
["2016-09-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,257,0,null,{"$f":"$G$4","v":2},0,null,{"$f":"$G$5","v":0.1}]
[{"$f":"A271+1","v":"2016-09-14"},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":"Z271+1","v":258},{"$f":"MAX(C272:F272)","v":0},null,2,{"$f":"MAX(G272:R272)","v":0},null,0.1]
["2016-09-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,259,0,null,2,0,null,0.1]
["2016-09-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260,0,null,2,0,null,0.1]
["2016-09-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,261,0,null,2,0,null,0.1]
["2016-09-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,262,0,null,2,0,null,0.1]
["2016-09-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,263,0,null,2,0,null,0.1]
["2016-09-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,264,0,null,2,0,null,0.1]
["2016-09-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,265,0,null,2,0,null,0.1]
["2016-09-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,266,0,null,2,0,null,0.1]
["2016-09-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,267,0,null,2,0,null,0.1]
["2016-09-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,268,0,null,2,0,null,0.1]
["2016-09-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,269,0,null,2,0,null,0.1]
["2016-09-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,270,0,null,2,0,null,0.1]
["2016-09-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,271,0,null,2,0,null,0.1]
["2016-09-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,272,0,null,2,0,null,0.1]
["2016-09-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,273,0,null,2,0,null,0.1]
["2016-09-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,274,0,null,2,0,null,0.1]
["2016-10-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,275,0,null,2,0,null,0.1]
["2016-10-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,276,0,null,2,0,null,0.1]
["2016-10-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,277,0,null,2,0,null,0.1]
["2016-10-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,278,0,null,2,0,null,0.1]
["2016-10-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,279,0,null,2,0,null,0.1]
["2016-10-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,280,0,null,2,0,null,0.1]
["2016-10-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,281,0,null,2,0,null,0.1]
["2016-10-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,282,0,null,2,0,null,0.1]
["2016-10-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,283,0,null,2,0,null,0.1]
["2016-10-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,284,0,null,2,0,null,0.1]
["2016-10-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,285,0,null,2,0,null,0.1]
["2016-10-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,286,0,null,2,0,null,0.1]
["2016-10-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,287,0,null,2,0,null,0.1]
["2016-10-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,288,0,null,2,0,null,0.1]
["2016-10-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,289,0,null,2,0,null,0.1]
["2016-10-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,290,0,null,2,0,null,0.1]
["2016-10-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,291,0,null,2,0,null,0.1]
["2016-10-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,292,0,null,2,0,null,0.1]
["2016-10-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,293,0,null,2,0,null,0.1]
["2016-10-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,294,0,null,2,0,null,0.1]
["2016-10-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,295,0,null,2,0,null,0.1]
["2016-10-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,296,0,null,2,0,null,0.1]
["2016-10-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,297,0,null,2,0,null,0.1]
["2016-10-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,298,0,null,2,0,null,0.1]
["2016-10-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,299,0,null,2,0,null,0.1]
["2016-10-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,0,null,2,0,null,0.1]
["2016-10-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,301,0,null,2,0,null,0.1]
["2016-10-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,302,0,null,2,0,null,0.1]
["2016-10-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,303,0,null,2,0,null,0.1]
["2016-10-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,304,0,null,2,0,null,0.1]
["2016-10-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,305,0,null,2,0,null,0.1]
["2016-11-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,306,0,null,2,0,null,0.1]
["2016-11-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,307,0,null,2,0,null,0.1]
["2016-11-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,308,0,null,2,0,null,0.1]
["2016-11-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,309,0,null,2,0,null,0.1]
["2016-11-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,0,null,2,0,null,0.1]
["2016-11-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,311,0,null,2,0,null,0.1]
["2016-11-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,312,0,null,2,0,null,0.1]
["2016-11-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,313,0,null,2,0,null,0.1]
["2016-11-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,314,0,null,2,0,null,0.1]
["2016-11-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,315,0,null,2,0,null,0.1]
["2016-11-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,316,0,null,2,0,null,0.1]
["2016-11-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,317,0,null,2,0,null,0.1]
["2016-11-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,0,null,2,0,null,0.1]
["2016-11-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,319,0,null,2,0,null,0.1]
["2016-11-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,0,null,2,0,null,0.1]
["2016-11-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,321,0,null,{"$f":"$G$4","v":2},0,null,{"$f":"$G$5","v":0.1}]
[{"$f":"A335+1","v":"2016-11-17"},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":"Z335+1","v":322},{"$f":"MAX(C336:F336)","v":0},null,2,{"$f":"MAX(G336:R336)","v":0},null,0.1]
["2016-11-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,323,0,null,2,0,null,0.1]
["2016-11-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,324,0,null,2,0,null,0.1]
["2016-11-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325,0,null,2,0,null,0.1]
["2016-11-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,326,0,null,2,0,null,0.1]
["2016-11-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,327,0,null,2,0,null,0.1]
["2016-11-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,328,0,null,2,0,null,0.1]
["2016-11-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,329,0,null,2,0,null,0.1]
["2016-11-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330,0,null,2,0,null,0.1]
["2016-11-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,331,0,null,2,0,null,0.1]
["2016-11-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,332,0,null,2,0,null,0.1]
["2016-11-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,333,0,null,2,0,null,0.1]
[{"$f":"A347+1","v":"2016-11-29"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,334,0,null,2,0,null,0.1]
[{"$f":"A348+1","v":"2016-11-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,335,0,null,2,0,null,0.1]
["2016-12-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,336,0,null,2,0,null,0.1]
["2016-12-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,337,0,null,2,0,null,0.1]
["2016-12-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,338,0,null,2,0,null,0.1]
["2016-12-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,339,0,null,2,0,null,0.1]
["2016-12-05",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340,0,null,2,0,null,0.1]
["2016-12-06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,341,0,null,2,0,null,0.1]
["2016-12-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,342,0,null,2,0,null,0.1]
["2016-12-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,343,0,null,2,0,null,0.1]
["2016-12-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,344,0,null,2,0,null,0.1]
["2016-12-10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,345,0,null,2,0,null,0.1]
["2016-12-11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,346,0,null,2,0,null,0.1]
["2016-12-12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,347,0,null,2,0,null,0.1]
["2016-12-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,348,0,null,2,0,null,0.1]
["2016-12-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,349,0,null,2,0,null,0.1]
["2016-12-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,0,null,2,0,null,0.1]
["2016-12-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,351,0,null,2,0,null,0.1]
["2016-12-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,352,0,null,2,0,null,0.1]
["2016-12-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,353,0,null,2,0,null,0.1]
["2016-12-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354,0,null,2,0,null,0.1]
["2016-12-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,355,0,null,2,0,null,0.1]
["2016-12-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,356,0,null,2,0,null,0.1]
["2016-12-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,357,0,null,2,0,null,0.1]
["2016-12-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358,0,null,2,0,null,0.1]
["2016-12-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,359,0,null,2,0,null,0.1]
["2016-12-25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,0,null,2,0,null,0.1]
["2016-12-26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,361,0,null,2,0,null,0.1]
["2016-12-27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,362,0,null,2,0,null,0.1]
["2016-12-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,363,0,null,2,0,null,0.1]
["2016-12-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,364,{"$f":"MAX(C378:F378)","v":0},null,2,0,null,0.1]
["2016-12-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,0,null,2,0,null,0.1]
["2016-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,366,0,null,2,0,null,0.1]

{"sheet":"Summary","index":3,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,2,25,3],[24,2,24,4]]}
[]
[null,null,{"$f":"DataEntryValues!G2&\"  \"&DataEntryValues!G3","v":"Rocky Mountain Water District  1031009"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Treatment Barrier Performance Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ANNUAL DATA",null,null,"Avg","Min","Max","RSQ",0.95,"Opt. Goal","Reg."]
[null,null,null,null,null,"NTU","NTU","NTU",null,"NTU","% Values","% Values"]
[null,null,"Raw Turbidity",null,null,{"$f":"IF(SUM(Raw)=0,,AVERAGE(Raw))","v":0},{"$f":"IF(SUM(Raw)=0,,MIN(Raw))","v":0},{"$f":"IF(SUM(Raw)=0,,MAX(Raw))","v":0},"n/a",{"$f":"IF(SUM(Raw)=0,,PERCENTILE(Raw, 0.95))","v":0},"n/a","n/a"]
[null,null,"Max. Settled Turbidity",null,null,{"$f":"IF(SUM(MaxSedPlot)=0,,AVERAGE(MaxSedPlot))","v":0},{"$f":"IF(SUM(MaxSedPlot)=0,,MIN(MaxSedPlot))","v":0},{"$f":"IF(SUM(MaxSedPlot)=0,,MAX(MaxSedPlot))","v":0},{"$f":"IF(SUM(Raw)=0,,IF(SUM(MaxSedPlot)=0,,RSQ(Raw,MaxSedPlot)))","v":0},{"$f":"IF(SUM(MaxSedPlot)=0,,PERCENTILE(MaxSedPlot,0.95))","v":0},{"$f":"IF(SUM(MaxSedPlot)=0,,(COUNTIFS(MaxSedPlot,\"<=\"&DataEntryValues!G4)/COUNT(MaxSedPlot))*100)","v":0},"n/a"]
[null,null,"Max. Filtered Turbidity",null,null,{"$f":"IF(SUM(MaxFilterPlot)=0,,AVERAGE(MaxFilterPlot))","v":0},{"$f":"IF(SUM(MaxFilterPlot)=0,,MIN(MaxFilterPlot))","v":0},{"$f":"IF(SUM(MaxFilterPlot)=0,,MAX(MaxFilterPlot))","v":0},{"$f":"IF(SUM(MaxSedPlot)=0,,IF(SUM(MaxFilterPlot)=0,,RSQ(MaxSedPlot,MaxFilterPlot)))","v":0},{"$f":"IF(SUM(MaxFilterPlot)=0,,PERCENTILE(MaxFilterPlot,0.95))","v":0},{"$f":"IF(SUM(MaxFilterPlot)=0,,(COUNTIFS(MaxFilterPlot,\"<=\"&DataEntryValues!G5)/COUNT(MaxFilterPlot))*100)","v":0},"n/a"]
[null,null,"Combined Filtered Turbidity",null,null,{"$f":"IF(SUM(Comb)=0,,AVERAGE(Comb))","v":0},{"$f":"IF(SUM(Comb)=0,,MIN(Comb))","v":0},{"$f":"IF(SUM(Comb)=0,,MAX(Comb))","v":0},{"$f":"IF(SUM(MaxFilterPlot)=0,,IF(SUM(Comb)=0,,RSQ(MaxFilterPlot,Comb)))","v":0},{"$f":"IF(SUM(Comb)=0,,PERCENTILE(Comb,0.95))","v":0},{"$f":"IF(SUM(Comb)=0,,(COUNTIFS(Comb,\"<=\"&DataEntryValues!G5)/COUNT(Comb))*100)","v":0},{"$f":"IF(SUM(Comb)=0,,(COUNTIFS(Comb,\"<=\"&DataEntryValues!G6)/COUNT(Comb))*100)","v":0}]
[]
[null,null,"RSQ = Correlation Coefficient for two selected data sets (> ~ 0.25 suggests correlation)"]
[null,null,"95% = 95th Percentile value for data set"]
[null,null,"Opt. Goal = % of values in data set that are less than or equal to the selected optimization turbidity goal"]
[null,null,"Reg.  = % of values in data set that are less than or equal to the regulated turbidity requirement"]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Instructions!B1","v":"Optimization Assessment Software - Version 33"}]

{"sheet":"OptimizationTrend","index":4,"n_rows":40,"n_cols":28,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,3,4,10],[4,11,4,27],[5,3,5,6],[5,8,5,10],[5,11,5,24],[5,25,5,27]]}
[]
[null,null,{"$f":"DataEntryValues!G2&\"  \"&DataEntryValues!G3","v":"Rocky Mountain Water District  1031009"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optimization Trend Report"]
[]
[]
[null,null,null,"Settled Water Turbidity",null,null,null,null,null,null,null,"Filtered Water Turbidity"]
[null,null,null,"95th Percentile Values (NTU)",null,null,null,null,"% Values Meeting Goal",null,null,"95th Percentile Values (NTU)",null,null,null,null,null,null,null,null,null,null,null,null,null,"% Values Meeting Goal All Filters"]
[null,null,null,"Sed 1","Sed 2","Sed 3","Sed 4","All Sed","3 NTU","2 NTU","1 NTU","Filter 1","Filter 2","Filter 3","Filter 4","Filter 5","Filter 6","Filter 7","Filter 8","Filter 9","Filter 10","Filter 11","Filter 12","Combined","All Filters",0.3,0.2,0.1]
[null,null,"2016-01-01"]
[null,null,"2016-02-01"]
[null,null,"2016-03-01"]
[null,null,"2016-04-01"]
[null,null,"2016-05-01"]
[null,null,"2016-06-01"]
[null,null,"2016-07-01"]
[null,null,"2016-08-01"]
[null,null,"2016-09-01"]
[null,null,"2016-10-01"]
[null,null,"2016-11-01"]
[null,null,"2016-12-01"]
[null,null,"Yr. 95%",{"$f":"IF(SUM(DataEntryValues!C15:C380)=0,,PERCENTILE(DataEntryValues!C15:C380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!D15:D380)=0,,PERCENTILE(DataEntryValues!D15:D380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!E15:E380)=0,,PERCENTILE(DataEntryValues!E15:E380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!F15:F380)=0,,PERCENTILE(DataEntryValues!F15:F380,0.95))","v":0},null,null,null,null,{"$f":"IF(SUM(DataEntryValues!G15:G380)=0,,PERCENTILE(DataEntryValues!G15:G380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!H15:H380)=0,,PERCENTILE(DataEntryValues!H15:H380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!I15:I380)=0,,PERCENTILE(DataEntryValues!I15:I380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!J15:J380)=0,,PERCENTILE(DataEntryValues!J15:J380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!K15:K380)=0,,PERCENTILE(DataEntryValues!K15:K380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!L15:L380)=0,,PERCENTILE(DataEntryValues!L15:L380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!M15:M380)=0,,PERCENTILE(DataEntryValues!M15:M380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!N15:N380)=0,,PERCENTILE(DataEntryValues!N15:N380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!O15:O380)=0,,PERCENTILE(DataEntryValues!O15:O380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!P15:P380)=0,,PERCENTILE(DataEntryValues!P15:P380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!Q15:Q380)=0,,PERCENTILE(DataEntryValues!Q15:Q380,0.95))","v":0},{"$f":"IF(SUM(DataEntryValues!R15:R380)=0,,PERCENTILE(DataEntryValues!R15:R380,0.95))","v":0},{"$f":"IF(SUM([0]!Comb)=0,,PERCENTILE([0]!Comb,0.95))","v":0}]
[null,null,"Yr. Goal",{"$f":"IF(SUM(DataEntryValues!C15:C380)=0,,FREQUENCY(DataEntryValues!C15:C380,DataEntryValues!$G$4)/COUNT(DataEntryValues!C15:C380))","v":0},{"$f":"IF(SUM(DataEntryValues!D15:D380)=0,,FREQUENCY(DataEntryValues!D15:D380,DataEntryValues!$G$4)/COUNT(DataEntryValues!D15:D380))","v":0},{"$f":"IF(SUM(DataEntryValues!E15:E380)=0,,FREQUENCY(DataEntryValues!E15:E380,DataEntryValues!$G$4)/COUNT(DataEntryValues!E15:E380))","v":0},{"$f":"IF(SUM(DataEntryValues!F15:F380)=0,,FREQUENCY(DataEntryValues!F15:F380,DataEntryValues!$G$4)/COUNT(DataEntryValues!F15:F380))","v":0},null,null,null,null,{"$f":"IF(SUM(DataEntryValues!G15:G380)=0,,FREQUENCY(DataEntryValues!G15:G380,DataEntryValues!$G$5)/COUNT(DataEntryValues!G15:G380))","v":0},{"$f":"IF(SUM(DataEntryValues!H15:H380)=0,,FREQUENCY(DataEntryValues!H15:H380,DataEntryValues!$G$5)/COUNT(DataEntryValues!H15:H380))","v":0},{"$f":"IF(SUM(DataEntryValues!I15:I380)=0,,FREQUENCY(DataEntryValues!I15:I380,DataEntryValues!$G$5)/COUNT(DataEntryValues!I15:I380))","v":0},{"$f":"IF(SUM(DataEntryValues!J15:J380)=0,,FREQUENCY(DataEntryValues!J15:J380,DataEntryValues!$G$5)/COUNT(DataEntryValues!J15:J380))","v":0},{"$f":"IF(SUM(DataEntryValues!K15:K380)=0,,FREQUENCY(DataEntryValues!K15:K380,DataEntryValues!$G$5)/COUNT(DataEntryValues!K15:K380))","v":0},{"$f":"IF(SUM(DataEntryValues!L15:L380)=0,,FREQUENCY(DataEntryValues!L15:L380,DataEntryValues!$G$5)/COUNT(DataEntryValues!L15:L380))","v":0},{"$f":"IF(SUM(DataEntryValues!M15:M380)=0,,FREQUENCY(DataEntryValues!M15:M380,DataEntryValues!$G$5)/COUNT(DataEntryValues!M15:M380))","v":0},{"$f":"IF(SUM(DataEntryValues!N15:N380)=0,,FREQUENCY(DataEntryValues!N15:N380,DataEntryValues!$G$5)/COUNT(DataEntryValues!N15:N380))","v":0},{"$f":"IF(SUM(DataEntryValues!O15:O380)=0,,FREQUENCY(DataEntryValues!O15:O380,DataEntryValues!$G$5)/COUNT(DataEntryValues!O15:O380))","v":0},{"$f":"IF(SUM(DataEntryValues!P15:P380)=0,,FREQUENCY(DataEntryValues!P15:P380,DataEntryValues!$G$5)/COUNT(DataEntryValues!P15:P380))","v":0},{"$f":"IF(SUM(DataEntryValues!Q15:Q380)=0,,FREQUENCY(DataEntryValues!Q15:Q380,DataEntryValues!$G$5)/COUNT(DataEntryValues!Q15:Q380))","v":0},{"$f":"IF(SUM(DataEntryValues!R15:R380)=0,,FREQUENCY(DataEntryValues!R15:R380,DataEntryValues!$G$5)/COUNT(DataEntryValues!R15:R380))","v":0},{"$f":"IF(SUM([0]!Comb)=0,,FREQUENCY([0]!Comb,DataEntryValues!$G$5)/COUNT([0]!Comb))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Instructions!B1","v":"Optimization Assessment Software - Version 33"}]

{"sheet":"SedSum","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Sedimentation Performance Summary"]

{"sheet":"FilterSum(1-4)","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Filtration Performance Summary (Filters 1 - 4)"]

{"sheet":"FilterSum(5-8)","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Filtration Performance Summary (Filters 5 - 8)"]

{"sheet":"FilterSum(9-12)","index":11,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Filtration Performance Summary (Filters 9 - 12)"]

{"sheet":"BW Data","index":12,"n_rows":632,"n_cols":20,"rows_kept":632,"cut":false,"hidden":false,"merged":[]}
[null,"Data input screen for filter backwash data."]
[null,"For filters with filter-to-waste (FTW) capability, input three values",null,null,null,null,null,"Return to Service Turbidity (% values <= goal)"]
[null,"per backwash: 1) max. turbidity during FTW period, 2) turbidity at",null,null,null,null,null,null,"Filter #"]
[null,"return to service (RTS) and 3) FTW time.",null,null,null,null,null,"Goal",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"For filters without FTW capability, input two values per backwash:",null,null,null,null,null,"Peak",{"$f":"IFERROR(COUNTIFS(Table1[Filter],I4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],I4),\"\")","v":0.93396226415094341},{"$f":"IFERROR(COUNTIFS(Table1[Filter],J4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],J4),\"\")","v":0.95959595959595956},{"$f":"IFERROR(COUNTIFS(Table1[Filter],K4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],K4),\"\")","v":0.92307692307692313},{"$f":"IFERROR(COUNTIFS(Table1[Filter],L4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],L4),\"\")","v":0.93396226415094341},{"$f":"IFERROR(COUNTIFS(Table1[Filter],M4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],M4),\"\")","v":0.95959595959595956},{"$f":"IFERROR(COUNTIFS(Table1[Filter],N4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],N4),\"\")","v":0.92307692307692313},{"$f":"IFERROR(COUNTIFS(Table1[Filter],O4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],O4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],P4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],P4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],Q4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],Q4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],R4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],R4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],S4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],S4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],T4,Table1[Peak Turbidity],\"<=\"&ROUND($D$10,2))/COUNTIF(Table1[Filter],T4),\"\")","v":""}]
[null,"1) max. turbidity during initial 15 minutes of filter run and",null,null,null,null,null,"RTS",{"$f":"IFERROR(COUNTIFS(Table1[Filter],I4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],I4),\"\")","v":0.68867924528301883},{"$f":"IFERROR(COUNTIFS(Table1[Filter],J4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],J4),\"\")","v":0.77777777777777779},{"$f":"IFERROR(COUNTIFS(Table1[Filter],K4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],K4),\"\")","v":0.75961538461538458},{"$f":"IFERROR(COUNTIFS(Table1[Filter],L4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],L4),\"\")","v":0.68867924528301883},{"$f":"IFERROR(COUNTIFS(Table1[Filter],M4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],M4),\"\")","v":0.77777777777777779},{"$f":"IFERROR(COUNTIFS(Table1[Filter],N4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],N4),\"\")","v":0.75961538461538458},{"$f":"IFERROR(COUNTIFS(Table1[Filter],O4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],O4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],P4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],P4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],Q4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],Q4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],R4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],R4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],S4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],S4),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Table1[Filter],T4,Table1[RTS Turbidity],\"<=\"&ROUND($E$10,2))/COUNTIF(Table1[Filter],T4),\"\")","v":""}]
[null,"2) turbidity after 15 minutes of filter run."]
[null,"To start, delete rows with demo data, but leave a few rows for new."]
[null,"Add new data to bottom of table.",null,null,null,null,null,"Turbidity during FTW (95th percentile)"]
[null,null,"Perf. Goals (NTU)",0.3,0.1,"Avg FTW",null,null,"Filter #"]
[null,null,"% values <= Goal",{"$f":"COUNTIF(D15:D632,\"<=\"&ROUND(D10,2))/COUNT(D15:D632)*100","v":94.155844155844164},{"$f":"COUNTIF(E15:E632,\"<=\"&ROUND(E10,2))/COUNT(E15:E632)*100","v":74.110032362459549},"Time",null,"Percentile",1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"95th % NTU",{"$f":"IF(SUM(D15:D632)=0,\"\",PERCENTILE(D15:D632,0.95))","v":0.32500000000000001},{"$f":"IF(SUM(E15:E632)=0,\"\",PERCENTILE(E15:E632,0.95))","v":0.17},{"$f":"IF(SUM(F15:F632)=0,\"\",AVERAGE(F15:F632))","v":24.708737864077669},null,"Peak",{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=I$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.3115},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=J$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.2745999999999999},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=K$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.33079999999999998},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=L$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.3115},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=M$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.2745999999999999},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=N$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":0.33079999999999998},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=O$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=P$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=Q$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=R$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=S$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=T$11,Table1[Peak Turbidity],\"\"),0.95),\"\")","v":""}]
[null,null,null,null,null,null,null,"RTS",{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=I$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.161},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=J$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.18439999999999993},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=K$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.15934999999999994},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=L$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.161},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=M$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.18439999999999993},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=N$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":0.15934999999999994},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=O$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=P$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=Q$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=R$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=S$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""},{"$f":"IFERROR(PERCENTILE(IF(Table1[Filter]=T$11,Table1[RTS Turbidity],\"\"),0.95),\"\")","v":""}]
[null,"BW Date","Filter","Peak Turbidity","RTS Turbidity","FTW Time (min)"]
[null,"2008-01-01",3,0.10100000000000001,5.8999999999999997E-2,15]
[null,"2008-01-01",6,0.10100000000000001,5.8999999999999997E-2,15]
[null,"2008-01-02",2,0.16400000000000001,9.8000000000000004E-2,25]
[null,"2008-01-02",5,0.16400000000000001,9.8000000000000004E-2,25]
[null,"2008-01-02",1,0.109,9.8000000000000004E-2,15]
[null,"2008-01-02",4,0.109,9.8000000000000004E-2,15]
[null,"2008-01-04",3,7.9000000000000001E-2,7.3999999999999996E-2,17]
[null,"2008-01-04",6,7.9000000000000001E-2,7.3999999999999996E-2,17]
[null,"2008-01-07",3,9.4E-2,8.6999999999999994E-2,35]
[null,"2008-01-07",6,9.4E-2,8.6999999999999994E-2,35]
[null,"2008-01-08",2,0.10100000000000001,8.4000000000000005E-2,15]
[null,"2008-01-08",5,0.10100000000000001,8.4000000000000005E-2,15]
[null,"2008-01-09",1,9.0999999999999998E-2,8.5999999999999993E-2,15]
[null,"2008-01-09",4,9.0999999999999998E-2,8.5999999999999993E-2,15]
[null,"2008-01-10",3,0.129,9.2999999999999999E-2,10]
[null,"2008-01-10",6,0.129,9.2999999999999999E-2,10]
[null,"2008-01-11",2,0.13600000000000001,0.112,22]
[null,"2008-01-11",5,0.13600000000000001,0.112,22]
[null,"2008-01-11",1,0.125,0.11899999999999999,20]
[null,"2008-01-11",4,0.125,0.11899999999999999,20]
[null,"2008-01-14",3,6.5000000000000002E-2,5.7000000000000002E-2,15]
[null,"2008-01-14",6,6.5000000000000002E-2,5.7000000000000002E-2,15]
[null,"2008-01-15",2,0.11,8.6999999999999994E-2,20]
[null,"2008-01-15",5,0.11,8.6999999999999994E-2,20]
[null,"2008-01-15",1,9.9000000000000005E-2,9.0999999999999998E-2,15]
[null,"2008-01-15",4,9.9000000000000005E-2,9.0999999999999998E-2,15]
[null,"2008-01-15",6,6.0999999999999999E-2,0.17499999999999999,15]
[null,"2008-01-16",3,6.0999999999999999E-2,0.17499999999999999,15]
[null,"2008-01-16",3,0.14000000000000001,7.0000000000000007E-2,15]
[null,"2008-01-16",6,0.14000000000000001,7.0000000000000007E-2,15]
[null,"2008-01-17",1,0.11899999999999999,9.8000000000000004E-2,22]
[null,"2008-01-17",4,0.11899999999999999,9.8000000000000004E-2,22]
[null,"2008-01-17",3,0.12,9.8000000000000004E-2,17]
[null,"2008-01-17",6,0.12,9.8000000000000004E-2,17]
[null,"2008-01-18",3,0.11899999999999999,6.3E-2,16]
[null,"2008-01-18",6,0.11899999999999999,6.3E-2,16]
[null,"2008-01-19",1,0.107,9.9000000000000005E-2,22]
[null,"2008-01-19",4,0.107,9.9000000000000005E-2,22]
[null,"2008-01-19",2,0.125,0.10299999999999999,20]
[null,"2008-01-19",5,0.125,0.10299999999999999,20]
[null,"2008-01-21",3,7.0999999999999994E-2,7.0000000000000007E-2,18]
[null,"2008-01-21",6,7.0999999999999994E-2,7.0000000000000007E-2,18]
[null,"2008-01-22",1,0.13100000000000001,9.9000000000000005E-2,30]
[null,"2008-01-22",2,0.13400000000000001,9.9000000000000005E-2,30]
[null,"2008-01-22",4,0.13100000000000001,9.9000000000000005E-2,30]
[null,"2008-01-22",5,0.13400000000000001,9.9000000000000005E-2,30]
[null,"2008-01-24",2,0.216,0.183,30]
[null,"2008-01-24",5,0.216,0.183,30]
[null,"2008-01-24",1,0.17899999999999999,0.16800000000000001,25]
[null,"2008-01-24",4,0.17899999999999999,0.16800000000000001,25]
[null,"2008-01-24",3,0.127,9.4E-2,12]
[null,"2008-01-24",6,0.127,9.4E-2,12]
[null,"2008-01-27",2,8.7999999999999995E-2,8.4000000000000005E-2,15]
[null,"2008-01-27",5,8.7999999999999995E-2,8.4000000000000005E-2,15]
[null,"2008-01-27",1,7.8E-2,7.0999999999999994E-2,14]
[null,"2008-01-27",4,7.8E-2,7.0999999999999994E-2,14]
[null,"2008-01-27",3,8.2000000000000003E-2,7.9000000000000001E-2,13]
[null,"2008-01-27",6,8.2000000000000003E-2,7.9000000000000001E-2,13]
[null,"2008-01-28",3,0.14299999999999999,6.5000000000000002E-2,12]
[null,"2008-01-28",6,0.14299999999999999,6.5000000000000002E-2,12]
[null,"2008-01-30",1,7.4999999999999997E-2,6.6000000000000003E-2,17]
[null,"2008-01-30",2,0.106,9.1999999999999998E-2,17]
[null,"2008-01-30",4,7.4999999999999997E-2,6.6000000000000003E-2,17]
[null,"2008-01-30",5,0.106,9.1999999999999998E-2,17]
[null,"2008-01-31",3,7.0000000000000007E-2,5.5E-2,15]
[null,"2008-01-31",6,7.0000000000000007E-2,5.5E-2,15]
[null,"2008-02-01",2,9.4E-2,8.7999999999999995E-2,15]
[null,"2008-02-01",5,9.4E-2,8.7999999999999995E-2,15]
[null,"2008-02-02",1,7.0999999999999994E-2,7.0000000000000007E-2,14]
[null,"2008-02-02",4,7.0999999999999994E-2,7.0000000000000007E-2,14]
[null,"2008-02-03",3,8.5000000000000006E-2,6.4000000000000001E-2,11]
[null,"2008-02-03",6,8.5000000000000006E-2,6.4000000000000001E-2,11]
[null,"2008-02-04",2,0.57199999999999995,5.5E-2,8]
[null,"2008-02-04",5,0.57199999999999995,5.5E-2,8]
[null,"2008-02-05",3,6.6000000000000003E-2,6.3E-2,11]
[null,"2008-02-05",6,6.6000000000000003E-2,6.3E-2,11]
[null,"2008-02-07",2,0.80100000000000005,0.26600000000000001,320]
[null,"2008-02-07",5,0.80100000000000005,0.26600000000000001,320]
[null,"2008-02-07",3,0.42399999999999999,0.24,140]
[null,"2008-02-07",6,0.42399999999999999,0.24,140]
[null,"2008-02-07",1,0.115,0.111,50]
[null,"2008-02-07",4,0.115,0.111,50]
[null,"2008-02-08",1,0.74199999999999999,0.105,30]
[null,"2008-02-08",4,0.74199999999999999,0.105,30]
[null,"2008-02-09",2,0.14399999999999999,8.7999999999999995E-2,25]
[null,"2008-02-09",5,0.14399999999999999,8.7999999999999995E-2,25]
[null,"2008-02-09",3,6.4000000000000001E-2,6.0999999999999999E-2,12]
[null,"2008-02-09",6,6.4000000000000001E-2,6.0999999999999999E-2,12]
[null,"2008-02-13",1,0.1,9.0999999999999998E-2,22]
[null,"2008-02-13",4,0.1,9.0999999999999998E-2,22]
[null,"2008-02-14",2,0.11899999999999999,0.09,25]
[null,"2008-02-14",5,0.11899999999999999,0.09,25]
[null,"2008-02-14",3,0.08,5.8999999999999997E-2,16]
[null,"2008-02-14",6,0.08,5.8999999999999997E-2,16]
[null,"2008-02-15",1,0.125,0.1,30]
[null,"2008-02-15",4,0.125,0.1,30]
[null,"2008-02-15",3,7.3999999999999996E-2,7.0000000000000007E-2,13]
[null,"2008-02-15",6,7.3999999999999996E-2,7.0000000000000007E-2,13]
[null,"2008-02-16",2,0.125,9.7000000000000003E-2,30]
[null,"2008-02-16",5,0.125,9.7000000000000003E-2,30]
[null,"2008-02-16",3,7.8E-2,6.3E-2,10]
[null,"2008-02-16",6,7.8E-2,6.3E-2,10]
[null,"2008-02-17",1,0.127,9.6000000000000002E-2,35]
[null,"2008-02-17",4,0.127,9.6000000000000002E-2,35]
[null,"2008-02-18",2,0.115,9.8000000000000004E-2,10]
[null,"2008-02-18",3,6.9000000000000006E-2,6.6000000000000003E-2,10]
[null,"2008-02-18",5,0.115,9.8000000000000004E-2,10]
[null,"2008-02-18",6,6.9000000000000006E-2,6.6000000000000003E-2,10]
[null,"2008-02-19",1,null,0.14899999999999999,150]
[null,"2008-02-19",4,null,0.14899999999999999,150]
[null,"2008-02-20",2,0.442,0.16200000000000001,155]
[null,"2008-02-20",5,0.442,0.16200000000000001,155]
[null,"2008-02-20",3,0.121,8.1000000000000003E-2,15]
[null,"2008-02-20",6,0.121,8.1000000000000003E-2,15]
[null,"2008-02-21",1,0.12,0.108,25]
[null,"2008-02-21",4,0.12,0.108,25]
[null,"2008-02-22",2,0.115,0.104,20]
[null,"2008-02-22",5,0.115,0.104,20]
[null,"2008-02-22",3,7.3999999999999996E-2,7.2999999999999995E-2,13]
[null,"2008-02-22",6,7.3999999999999996E-2,7.2999999999999995E-2,13]
[null,"2008-02-23",1,0.153,0.124,30]
[null,"2008-02-23",4,0.153,0.124,30]
[null,"2008-02-24",2,0.155,9.9000000000000005E-2,30]
[null,"2008-02-24",5,0.155,9.9000000000000005E-2,30]
[null,"2008-02-25",1,0.13400000000000001,0.109,30]
[null,"2008-02-25",4,0.13400000000000001,0.109,30]
[null,"2008-02-25",3,7.4999999999999997E-2,7.2999999999999995E-2,13]
[null,"2008-02-25",6,7.4999999999999997E-2,7.2999999999999995E-2,13]
[null,"2008-02-26",2,0.14000000000000001,9.9000000000000005E-2,30]
[null,"2008-02-26",5,0.14000000000000001,9.9000000000000005E-2,30]
[null,"2008-02-27",1,0.127,0.12,25]
[null,"2008-02-27",4,0.127,0.12,25]
[null,"2008-02-27",3,7.4999999999999997E-2,7.2999999999999995E-2,13]
[null,"2008-02-27",6,7.4999999999999997E-2,7.2999999999999995E-2,13]
[null,"2008-04-03",1,8.1000000000000003E-2,7.4999999999999997E-2,16]
[null,"2008-04-03",4,8.1000000000000003E-2,7.4999999999999997E-2,16]
[null,"2008-04-03",3,8.2000000000000003E-2,0.06,13]
[null,"2008-04-03",6,8.2000000000000003E-2,0.06,13]
[null,"2008-04-04",2,0.113,6.6000000000000003E-2,17]
[null,"2008-04-04",5,0.113,6.6000000000000003E-2,17]
[null,"2008-04-05",3,0.158,7.3999999999999996E-2,12]
[null,"2008-04-05",6,0.158,7.3999999999999996E-2,12]
[null,"2008-04-06",1,9.5000000000000001E-2,8.6999999999999994E-2,12]
[null,"2008-04-06",4,9.5000000000000001E-2,8.6999999999999994E-2,12]
[null,"2008-04-06",2,7.3999999999999996E-2,7.0999999999999994E-2,11]
[null,"2008-04-06",5,7.3999999999999996E-2,7.0999999999999994E-2,11]
[null,"2008-04-09",3,0.14099999999999999,0.08,15]
[null,"2008-04-09",6,0.14099999999999999,0.08,15]
[null,"2008-04-10",1,0.14399999999999999,9.9000000000000005E-2,16]
[null,"2008-04-10",4,0.14399999999999999,9.9000000000000005E-2,16]
[null,"2008-04-10",2,7.9000000000000001E-2,7.0999999999999994E-2,12]
[null,"2008-04-10",5,7.9000000000000001E-2,7.0999999999999994E-2,12]
[null,"2008-04-26",1,0.16500000000000001,9.1999999999999998E-2,11]
[null,"2008-04-26",4,0.16500000000000001,9.1999999999999998E-2,11]
[null,"2008-04-27",3,0.108,7.1999999999999995E-2,12]
[null,"2008-04-27",6,0.108,7.1999999999999995E-2,12]
[null,"2008-04-28",2,6.7000000000000004E-2,6.3E-2,14]
[null,"2008-04-28",5,6.7000000000000004E-2,6.3E-2,14]
[null,"2008-04-30",1,0.122,7.3999999999999996E-2,13]
[null,"2008-04-30",4,0.122,7.3999999999999996E-2,13]
[null,"2008-05-01",2,5.8999999999999997E-2,5.3999999999999999E-2,14]
[null,"2008-05-01",5,5.8999999999999997E-2,5.3999999999999999E-2,14]
[null,"2008-05-03",1,7.9000000000000001E-2,7.1999999999999995E-2,13]
[null,"2008-05-03",4,7.9000000000000001E-2,7.1999999999999995E-2,13]
[null,"2008-05-04",2,5.8999999999999997E-2,4.9000000000000002E-2,12]
[null,"2008-05-04",5,5.8999999999999997E-2,4.9000000000000002E-2,12]
[null,"2008-05-05",3,9.6000000000000002E-2,8.4000000000000005E-2,10]
[null,"2008-05-05",6,9.6000000000000002E-2,8.4000000000000005E-2,10]
[null,"2008-05-07",1,7.5999999999999998E-2,6.9000000000000006E-2,13]
[null,"2008-05-07",4,7.5999999999999998E-2,6.9000000000000006E-2,13]
[null,"2008-05-07",2,5.6000000000000001E-2,3.1E-2,9]
[null,"2008-05-07",5,5.6000000000000001E-2,3.1E-2,9]
[null,"2008-05-10",1,8.3000000000000004E-2,7.5999999999999998E-2,11]
[null,"2008-05-10",4,8.3000000000000004E-2,7.5999999999999998E-2,11]
[null,"2008-05-11",2,6.2E-2,5.8000000000000003E-2,13]
[null,"2008-05-11",5,6.2E-2,5.8000000000000003E-2,13]
[null,"2008-05-12",3,0.14599999999999999,6.6000000000000003E-2,14]
[null,"2008-05-12",6,0.14599999999999999,6.6000000000000003E-2,14]
[null,"2008-05-14",1,0.14899999999999999,8.7999999999999995E-2,12]
[null,"2008-05-14",4,0.14899999999999999,8.7999999999999995E-2,12]
[null,"2008-05-15",3,0.23599999999999999,7.0000000000000007E-2,13]
[null,"2008-05-15",6,0.23599999999999999,7.0000000000000007E-2,13]
[null,"2008-05-15",2,0.12,7.3999999999999996E-2,12]
[null,"2008-05-15",5,0.12,7.3999999999999996E-2,12]
[null,"2008-05-17",1,0.184,0.08,17]
[null,"2008-05-17",4,0.184,0.08,17]
[null,"2008-05-18",3,0.22800000000000001,6.3E-2,20]
[null,"2008-05-18",6,0.22800000000000001,6.3E-2,20]
[null,"2008-05-18",2,0.11600000000000001,6.6000000000000003E-2,15]
[null,"2008-05-18",5,0.11600000000000001,6.6000000000000003E-2,15]
[null,"2008-05-19",3,0.129,6.3E-2,20]
[null,"2008-05-19",6,0.129,6.3E-2,20]
[null,"2008-05-19",1,0.32500000000000001,8.5999999999999993E-2,12]
[null,"2008-05-19",2,6.7000000000000004E-2,5.8999999999999997E-2,12]
[null,"2008-05-19",4,0.32500000000000001,8.5999999999999993E-2,12]
[null,"2008-05-19",5,6.7000000000000004E-2,5.8999999999999997E-2,12]
[null,"2008-05-21",1,0.14799999999999999,9.8000000000000004E-2,11]
[null,"2008-05-21",4,0.14799999999999999,9.8000000000000004E-2,11]
[null,"2008-05-22",2,9.9000000000000005E-2,5.8000000000000003E-2,20]
[null,"2008-05-22",5,9.9000000000000005E-2,5.8000000000000003E-2,20]
[null,"2008-05-23",3,0.16400000000000001,9.4E-2,21]
[null,"2008-05-23",6,0.16400000000000001,9.4E-2,21]
[null,"2008-05-24",1,0.112,8.6999999999999994E-2,11]
[null,"2008-05-24",4,0.112,8.6999999999999994E-2,11]
[null,"2008-05-25",2,0.09,8.1000000000000003E-2,11]
[null,"2008-05-25",5,0.09,8.1000000000000003E-2,11]
[null,"2008-05-27",1,0.11799999999999999,9.5000000000000001E-2,12]
[null,"2008-05-27",4,0.11799999999999999,9.5000000000000001E-2,12]
[null,"2008-05-28",2,9.7000000000000003E-2,7.4999999999999997E-2,12]
[null,"2008-05-28",5,9.7000000000000003E-2,7.4999999999999997E-2,12]
[null,"2008-05-29",1,0.105,8.3000000000000004E-2,11]
[null,"2008-05-29",4,0.105,8.3000000000000004E-2,11]
[null,"2008-05-31",3,0.156,8.8999999999999996E-2,30]
[null,"2008-05-31",6,0.156,8.8999999999999996E-2,30]
[null,"2008-05-31",2,0.124,7.5999999999999998E-2,13]
[null,"2008-05-31",5,0.124,7.5999999999999998E-2,13]
[null,"2008-06-01",1,0.125,9.6000000000000002E-2,13]
[null,"2008-06-01",4,0.125,9.6000000000000002E-2,13]
[null,"2008-06-03",1,0.154,9.8000000000000004E-2,19]
[null,"2008-06-03",4,0.154,9.8000000000000004E-2,19]
[null,"2008-06-03",2,0.125,8.8999999999999996E-2,17]
[null,"2008-06-03",5,0.125,8.8999999999999996E-2,17]
[null,"2008-06-04",1,0.20200000000000001,9.1999999999999998E-2,20]
[null,"2008-06-04",2,0.26100000000000001,9.0999999999999998E-2,20]
[null,"2008-06-04",4,0.20200000000000001,9.1999999999999998E-2,20]
[null,"2008-06-04",5,0.26100000000000001,9.0999999999999998E-2,20]
[null,"2008-06-05",3,0.108,0.14499999999999999,20]
[null,"2008-06-05",6,0.108,0.14499999999999999,20]
[null,"2008-06-06",2,0.13900000000000001,0.109,30]
[null,"2008-06-06",5,0.13900000000000001,0.109,30]
[null,"2008-06-06",1,0.13700000000000001,9.9000000000000005E-2,17]
[null,"2008-06-06",4,0.13700000000000001,9.9000000000000005E-2,17]
[null,"2008-06-07",3,0.20100000000000001,9.5000000000000001E-2,25]
[null,"2008-06-07",6,0.20100000000000001,9.5000000000000001E-2,25]
[null,"2008-06-07",2,0.124,9.9000000000000005E-2,21]
[null,"2008-06-07",5,0.124,9.9000000000000005E-2,21]
[null,"2008-06-07",1,0.151,9.5000000000000001E-2,16]
[null,"2008-06-07",4,0.151,9.5000000000000001E-2,16]
[null,"2008-06-29",2,0.11799999999999999,9.6000000000000002E-2,17]
[null,"2008-06-29",5,0.11799999999999999,9.6000000000000002E-2,17]
[null,"2008-06-29",1,0.113,8.6999999999999994E-2,13]
[null,"2008-06-29",4,0.113,8.6999999999999994E-2,13]
[null,"2008-06-30",3,0.185,9.2999999999999999E-2,25]
[null,"2008-06-30",6,0.185,9.2999999999999999E-2,25]
[null,"2008-06-30",1,0.111,9.1999999999999998E-2,12]
[null,"2008-06-30",4,0.111,9.1999999999999998E-2,12]
[null,"2008-06-30",2,9.5000000000000001E-2,8.7999999999999995E-2,10]
[null,"2008-06-30",5,9.5000000000000001E-2,8.7999999999999995E-2,10]
[null,"2008-07-02",1,0.13100000000000001,0.11700000000000001,30]
[null,"2008-07-02",4,0.13100000000000001,0.11700000000000001,30]
[null,"2008-07-03",3,0.154,8.5000000000000006E-2,23]
[null,"2008-07-03",6,0.154,8.5000000000000006E-2,23]
[null,"2008-07-03",2,7.1999999999999995E-2,6.6000000000000003E-2,22]
[null,"2008-07-03",5,7.1999999999999995E-2,6.6000000000000003E-2,22]
[null,"2008-07-05",1,0.126,9.1999999999999998E-2,15]
[null,"2008-07-05",4,0.126,9.1999999999999998E-2,15]
[null,"2008-07-06",3,0.20799999999999999,9.5000000000000001E-2,25]
[null,"2008-07-06",6,0.20799999999999999,9.5000000000000001E-2,25]
[null,"2008-07-06",2,0.104,8.5000000000000006E-2,10]
[null,"2008-07-06",5,0.104,8.5000000000000006E-2,10]
[null,"2008-07-07",1,0.14199999999999999,7.0000000000000007E-2,20]
[null,"2008-07-07",4,0.14199999999999999,7.0000000000000007E-2,20]
[null,"2008-07-08",1,0.12,7.2999999999999995E-2,16]
[null,"2008-07-08",4,0.12,7.2999999999999995E-2,16]
[null,"2008-07-09",3,0.17,9.4E-2,22]
[null,"2008-07-09",6,0.17,9.4E-2,22]
[null,"2008-07-10",2,0.13100000000000001,0.10299999999999999,25]
[null,"2008-07-10",5,0.13100000000000001,0.10299999999999999,25]
[null,"2008-07-10",1,0.106,7.2999999999999995E-2,16]
[null,"2008-07-10",4,0.106,7.2999999999999995E-2,16]
[null,"2008-07-11",3,0.23699999999999999,0.09,21]
[null,"2008-07-11",6,0.23699999999999999,0.09,21]
[null,"2008-07-11",1,0.13500000000000001,8.4000000000000005E-2,14]
[null,"2008-07-11",4,0.13500000000000001,8.4000000000000005E-2,14]
[null,"2008-07-13",3,0.16700000000000001,9.1999999999999998E-2,18]
[null,"2008-07-13",6,0.16700000000000001,9.1999999999999998E-2,18]
[null,"2008-07-13",2,0.112,5.5E-2,15]
[null,"2008-07-13",5,0.112,5.5E-2,15]
[null,"2008-07-13",1,0.127,8.6999999999999994E-2,11]
[null,"2008-07-13",4,0.127,8.6999999999999994E-2,11]
[null,"2008-07-14",1,0.126,8.5999999999999993E-2,12]
[null,"2008-07-14",4,0.126,8.5999999999999993E-2,12]
[null,"2008-07-15",3,0.16,8.7999999999999995E-2,18]
[null,"2008-07-15",6,0.16,8.7999999999999995E-2,18]
[null,"2008-07-15",1,0.13500000000000001,9.5000000000000001E-2,13]
[null,"2008-07-15",4,0.13500000000000001,9.5000000000000001E-2,13]
[null,"2008-07-15",2,0.14799999999999999,8.7999999999999995E-2,11]
[null,"2008-07-15",5,0.14799999999999999,8.7999999999999995E-2,11]
[null,"2008-07-16",2,0.70099999999999996,0.17,92]
[null,"2008-07-16",5,0.70099999999999996,0.17,92]
[null,"2008-07-16",1,0.63700000000000001,0.115,52]
[null,"2008-07-16",4,0.63700000000000001,0.115,52]
[null,"2008-07-17",3,0.16600000000000001,9.4E-2,22]
[null,"2008-07-17",6,0.16600000000000001,9.4E-2,22]
[null,"2008-07-18",1,0.18,9.2999999999999999E-2,19]
[null,"2008-07-18",4,0.18,9.2999999999999999E-2,19]
[null,"2008-07-19",2,0.21099999999999999,8.7999999999999995E-2,16]
[null,"2008-07-19",5,0.21099999999999999,8.7999999999999995E-2,16]
[null,"2008-07-20",1,0.21,9.8000000000000004E-2,25]
[null,"2008-07-20",4,0.21,9.8000000000000004E-2,25]
[null,"2008-07-20",3,0.19800000000000001,7.6999999999999999E-2,22]
[null,"2008-07-20",6,0.19800000000000001,7.6999999999999999E-2,22]
[null,"2008-07-21",1,0.187,9.4E-2,17]
[null,"2008-07-21",2,0.15,6.3E-2,17]
[null,"2008-07-21",4,0.187,9.4E-2,17]
[null,"2008-07-21",5,0.15,6.3E-2,17]
[null,"2008-07-23",3,0.23599999999999999,8.5999999999999993E-2,30]
[null,"2008-07-23",6,0.23599999999999999,8.5999999999999993E-2,30]
[null,"2008-07-23",1,0.19900000000000001,9.1999999999999998E-2,19]
[null,"2008-07-23",4,0.19900000000000001,9.1999999999999998E-2,19]
[null,"2008-07-24",1,0.20100000000000001,9.9000000000000005E-2,27]
[null,"2008-07-24",4,0.20100000000000001,9.9000000000000005E-2,27]
[null,"2008-07-24",2,0.152,6.8000000000000005E-2,15]
[null,"2008-07-24",5,0.152,6.8000000000000005E-2,15]
[null,"2008-07-25",1,0.23599999999999999,9.8000000000000004E-2,26]
[null,"2008-07-25",4,0.23599999999999999,9.8000000000000004E-2,26]
[null,"2008-07-25",3,0.21299999999999999,0.09,20]
[null,"2008-07-25",6,0.21299999999999999,0.09,20]
[null,"2008-07-25",2,0.16900000000000001,7.8E-2,15]
[null,"2008-07-25",5,0.16900000000000001,7.8E-2,15]
[null,"2008-07-27",1,0.22700000000000001,0.108,35]
[null,"2008-07-27",4,0.22700000000000001,0.108,35]
[null,"2008-07-27",2,0.156,0.09,15]
[null,"2008-07-27",5,0.156,0.09,15]
[null,"2008-07-28",1,0.185,0.106,36]
[null,"2008-07-28",4,0.185,0.106,36]
[null,"2008-07-28",3,0.185,8.7999999999999995E-2,21]
[null,"2008-07-28",6,0.185,8.7999999999999995E-2,21]
[null,"2008-07-29",1,0.20200000000000001,0.11700000000000001,45]
[null,"2008-07-29",4,0.20200000000000001,0.11700000000000001,45]
[null,"2008-07-29",2,0.184,9.8000000000000004E-2,26]
[null,"2008-07-29",5,0.184,9.8000000000000004E-2,26]
[null,"2008-07-31",1,0.22700000000000001,0.108,35]
[null,"2008-07-31",4,0.22700000000000001,0.108,35]
[null,"2008-07-31",2,0.156,0.09,15]
[null,"2008-07-31",5,0.156,0.09,15]
[null,"2008-08-01",2,0.20499999999999999,8.5000000000000006E-2,20]
[null,"2008-08-01",5,0.20499999999999999,8.5000000000000006E-2,20]
[null,"2008-08-03",3,0.35599999999999998,0.09,33]
[null,"2008-08-03",6,0.35599999999999998,0.09,33]
[null,"2008-08-03",1,0.24199999999999999,0.09,27]
[null,"2008-08-03",4,0.24199999999999999,0.09,27]
[null,"2008-08-03",2,0.23,9.1999999999999998E-2,19]
[null,"2008-08-03",5,0.23,9.1999999999999998E-2,19]
[null,"2008-08-05",3,0.251,0.09,25]
[null,"2008-08-05",6,0.251,0.09,25]
[null,"2008-08-06",1,0.23400000000000001,0.10299999999999999,45]
[null,"2008-08-06",4,0.23400000000000001,0.10299999999999999,45]
[null,"2008-08-07",2,0.189,8.7999999999999995E-2,20]
[null,"2008-08-07",5,0.189,8.7999999999999995E-2,20]
[null,"2008-08-07",3,0.22900000000000001,8.3000000000000004E-2,19]
[null,"2008-08-07",6,0.22900000000000001,8.3000000000000004E-2,19]
[null,"2008-08-08",1,0.24299999999999999,0.104,30]
[null,"2008-08-08",4,0.24299999999999999,0.104,30]
[null,"2008-08-08",3,0.189,8.8999999999999996E-2,20]
[null,"2008-08-08",6,0.189,8.8999999999999996E-2,20]
[null,"2008-08-10",3,0.187,8.5999999999999993E-2,25]
[null,"2008-08-10",6,0.187,8.5999999999999993E-2,25]
[null,"2008-08-10",1,0.21299999999999999,9.8000000000000004E-2,23]
[null,"2008-08-10",4,0.21299999999999999,9.8000000000000004E-2,23]
[null,"2008-08-10",2,0.20899999999999999,9.4E-2,16]
[null,"2008-08-10",5,0.20899999999999999,9.4E-2,16]
[null,"2008-08-13",3,0.18,9.0999999999999998E-2,27]
[null,"2008-08-13",6,0.18,9.0999999999999998E-2,27]
[null,"2008-08-13",1,0.159,9.6000000000000002E-2,17]
[null,"2008-08-13",4,0.159,9.6000000000000002E-2,17]
[null,"2008-08-13",2,0.15,8.7999999999999995E-2,14]
[null,"2008-08-13",5,0.15,8.7999999999999995E-2,14]
[null,"2008-08-15",3,0.23799999999999999,0.09,25]
[null,"2008-08-15",6,0.23799999999999999,0.09,25]
[null,"2008-08-15",1,0.20200000000000001,9.0999999999999998E-2,20]
[null,"2008-08-15",4,0.20200000000000001,9.0999999999999998E-2,20]
[null,"2008-08-16",2,0.16,8.5999999999999993E-2,17]
[null,"2008-08-16",5,0.16,8.5999999999999993E-2,17]
[null,"2008-08-17",3,0.19800000000000001,9.0999999999999998E-2,25]
[null,"2008-08-17",6,0.19800000000000001,9.0999999999999998E-2,25]
[null,"2008-08-18",1,0.20100000000000001,9.7000000000000003E-2,30]
[null,"2008-08-18",4,0.20100000000000001,9.7000000000000003E-2,30]
[null,"2008-08-19",3,0.223,8.5000000000000006E-2,30]
[null,"2008-08-19",6,0.223,8.5000000000000006E-2,30]
[null,"2008-08-20",1,0.182,9.7000000000000003E-2,25]
[null,"2008-08-20",4,0.182,9.7000000000000003E-2,25]
[null,"2008-08-20",2,0.14499999999999999,8.5999999999999993E-2,15]
[null,"2008-08-20",5,0.14499999999999999,8.5999999999999993E-2,15]
[null,"2008-08-23",1,0.21199999999999999,9.8000000000000004E-2,23]
[null,"2008-08-23",4,0.21199999999999999,9.8000000000000004E-2,23]
[null,"2008-08-23",2,0.183,9.1999999999999998E-2,20]
[null,"2008-08-23",5,0.183,9.1999999999999998E-2,20]
[null,"2008-08-24",1,0.184,8.7999999999999995E-2,20]
[null,"2008-08-24",4,0.184,8.7999999999999995E-2,20]
[null,"2008-08-25",3,0.17499999999999999,6.8000000000000005E-2,26]
[null,"2008-08-25",6,0.17499999999999999,6.8000000000000005E-2,26]
[null,"2008-08-25",2,0.16300000000000001,7.8E-2,14]
[null,"2008-08-25",5,0.16300000000000001,7.8E-2,14]
[null,"2008-08-26",1,0.18099999999999999,7.0000000000000007E-2,30]
[null,"2008-08-26",4,0.18099999999999999,7.0000000000000007E-2,30]
[null,"2008-08-27",3,0.17,9.6000000000000002E-2,20]
[null,"2008-08-27",6,0.17,9.6000000000000002E-2,20]
[null,"2008-08-28",2,0.14499999999999999,5.8000000000000003E-2,20]
[null,"2008-08-28",5,0.14499999999999999,5.8000000000000003E-2,20]
[null,"2008-08-29",1,0.184,9.7000000000000003E-2,21]
[null,"2008-08-29",4,0.184,9.7000000000000003E-2,21]
[null,"2008-08-30",2,0.189,8.5000000000000006E-2,18]
[null,"2008-08-30",5,0.189,8.5000000000000006E-2,18]
[null,"2008-08-31",3,0.23799999999999999,0.09,35]
[null,"2008-08-31",6,0.23799999999999999,0.09,35]
[null,"2008-09-03",3,0.37,0.112,45]
[null,"2008-09-03",6,0.37,0.112,45]
[null,"2008-09-05",2,0.22,9.9000000000000005E-2,37]
[null,"2008-09-05",5,0.22,9.9000000000000005E-2,37]
[null,"2008-09-06",1,0.23,9.7000000000000003E-2,27]
[null,"2008-09-06",4,0.23,9.7000000000000003E-2,27]
[null,"2008-09-07",1,0.23599999999999999,9.9000000000000005E-2,61]
[null,"2008-09-07",4,0.23599999999999999,9.9000000000000005E-2,61]
[null,"2008-09-07",3,0.254,8.7999999999999995E-2,35]
[null,"2008-09-07",6,0.254,8.7999999999999995E-2,35]
[null,"2008-09-08",1,0.441,0.13700000000000001,159]
[null,"2008-09-08",4,0.441,0.13700000000000001,159]
[null,"2008-09-08",2,0.193,0.13700000000000001,40]
[null,"2008-09-08",5,0.193,0.13700000000000001,40]
[null,"2008-09-09",3,0.32400000000000001,0.11899999999999999,45]
[null,"2008-09-09",6,0.32400000000000001,0.11899999999999999,45]
[null,"2008-09-12",1,0.184,9.7000000000000003E-2,37]
[null,"2008-09-12",4,0.184,9.7000000000000003E-2,37]
[null,"2008-09-12",2,0.126,8.1000000000000003E-2,24]
[null,"2008-09-12",5,0.126,8.1000000000000003E-2,24]
[null,"2008-09-13",3,0.21099999999999999,0.124,30]
[null,"2008-09-13",6,0.21099999999999999,0.124,30]
[null,"2008-09-16",3,0.32300000000000001,0.13,40]
[null,"2008-09-16",6,0.32300000000000001,0.13,40]
[null,"2008-09-17",1,0.23599999999999999,9.9000000000000005E-2,35]
[null,"2008-09-17",4,0.23599999999999999,9.9000000000000005E-2,35]
[null,"2008-09-17",2,0.14599999999999999,9.8000000000000004E-2,23]
[null,"2008-09-17",5,0.14599999999999999,9.8000000000000004E-2,23]
[null,"2008-09-20",3,0.26800000000000002,9.7000000000000003E-2,35]
[null,"2008-09-20",6,0.26800000000000002,9.7000000000000003E-2,35]
[null,"2008-09-21",2,0.157,0.112,38]
[null,"2008-09-21",5,0.157,0.112,38]
[null,"2008-09-21",1,0.27100000000000002,0.13900000000000001,30]
[null,"2008-09-21",4,0.27100000000000002,0.13900000000000001,30]
[null,"2008-09-21",3,3.7999999999999999E-2,3.7999999999999999E-2,20]
[null,"2008-09-21",6,3.7999999999999999E-2,3.7999999999999999E-2,20]
[null,"2008-09-24",3,0.26400000000000001,9.8000000000000004E-2,43]
[null,"2008-09-24",6,0.26400000000000001,9.8000000000000004E-2,43]
[null,"2008-09-24",1,0.35499999999999998,0.152,35]
[null,"2008-09-24",4,0.35499999999999998,0.152,35]
[null,"2008-09-24",2,0.16700000000000001,0.14699999999999999,30]
[null,"2008-09-24",5,0.16700000000000001,0.14699999999999999,30]
[null,"2008-09-27",1,0.26400000000000001,0.17199999999999999,30]
[null,"2008-09-27",3,0.20699999999999999,0.11700000000000001,30]
[null,"2008-09-27",4,0.26400000000000001,0.17199999999999999,30]
[null,"2008-09-27",6,0.20699999999999999,0.11700000000000001,30]
[null,"2008-09-28",2,0.16900000000000001,0.115,30]
[null,"2008-09-28",5,0.16900000000000001,0.115,30]
[null,"2008-10-01",3,0.193,0.11,30]
[null,"2008-10-01",6,0.193,0.11,30]
[null,"2008-10-02",1,0.24399999999999999,0.14499999999999999,30]
[null,"2008-10-02",2,0.14899999999999999,9.9000000000000005E-2,30]
[null,"2008-10-02",4,0.24399999999999999,0.14499999999999999,30]
[null,"2008-10-02",5,0.14899999999999999,9.9000000000000005E-2,30]
[null,"2008-10-04",3,0.183,9.1999999999999998E-2,29]
[null,"2008-10-04",6,0.183,9.1999999999999998E-2,29]
[null,"2008-10-05",1,0.254,0.13800000000000001,32]
[null,"2008-10-05",4,0.254,0.13800000000000001,32]
[null,"2008-10-05",2,0.14899999999999999,0.109,28]
[null,"2008-10-05",5,0.14899999999999999,0.109,28]
[null,"2008-10-06",2,0.115,0.11899999999999999,28]
[null,"2008-10-06",5,0.115,0.11899999999999999,28]
[null,"2008-10-07",3,0.20699999999999999,9.7000000000000003E-2,30]
[null,"2008-10-07",6,0.20699999999999999,9.7000000000000003E-2,30]
[null,"2008-10-10",3,0.24399999999999999,0.1,30]
[null,"2008-10-10",6,0.24399999999999999,0.1,30]
[null,"2008-10-10",1,0.17899999999999999,0.126,25]
[null,"2008-10-10",4,0.17899999999999999,0.126,25]
[null,"2008-10-12",2,0.17199999999999999,0.109,30]
[null,"2008-10-12",5,0.17199999999999999,0.109,30]
[null,"2008-10-12",3,0.19500000000000001,0.10199999999999999,25]
[null,"2008-10-12",6,0.19500000000000001,0.10199999999999999,25]
[null,"2008-10-13",3,0.19800000000000001,8.1000000000000003E-2,30]
[null,"2008-10-13",6,0.19800000000000001,8.1000000000000003E-2,30]
[null,"2008-10-15",3,0.187,9.5000000000000001E-2,30]
[null,"2008-10-15",6,0.187,9.5000000000000001E-2,30]
[null,"2008-10-17",3,0.221,8.7999999999999995E-2,30]
[null,"2008-10-17",6,0.221,8.7999999999999995E-2,30]
[null,"2008-10-18",3,0.17699999999999999,8.5000000000000006E-2,29]
[null,"2008-10-18",6,0.17699999999999999,8.5000000000000006E-2,29]
[null,"2008-10-19",1,0.247,0.13900000000000001,32]
[null,"2008-10-19",4,0.247,0.13900000000000001,32]
[null,"2008-10-20",2,0.27300000000000002,0.223,38]
[null,"2008-10-20",5,0.27300000000000002,0.223,38]
[null,"2008-10-20",3,0.249,0.10199999999999999,23]
[null,"2008-10-20",6,0.249,0.10199999999999999,23]
[null,"2008-10-22",1,0.245,0.192,30]
[null,"2008-10-22",2,0.20699999999999999,0.19900000000000001,30]
[null,"2008-10-22",3,0.17,9.7000000000000003E-2,30]
[null,"2008-10-22",4,0.245,0.192,30]
[null,"2008-10-22",5,0.20699999999999999,0.19900000000000001,30]
[null,"2008-10-22",6,0.17,9.7000000000000003E-2,30]
[null,"2008-10-25",1,0.161,0.14399999999999999,31]
[null,"2008-10-25",4,0.161,0.14399999999999999,31]
[null,"2008-10-25",2,0.13,9.9000000000000005E-2,29]
[null,"2008-10-25",5,0.13,9.9000000000000005E-2,29]
[null,"2008-10-25",3,0.16400000000000001,9.0999999999999998E-2,24]
[null,"2008-10-25",6,0.16400000000000001,9.0999999999999998E-2,24]
[null,"2008-10-27",3,0.441,0.13800000000000001,28]
[null,"2008-10-27",6,0.441,0.13800000000000001,28]
[null,"2008-10-29",2,7.8E-2,7.5999999999999998E-2,15]
[null,"2008-10-29",5,7.8E-2,7.5999999999999998E-2,15]
[null,"2008-10-30",3,0.151,9.2999999999999999E-2,32]
[null,"2008-10-30",6,0.151,9.2999999999999999E-2,32]
[null,"2008-10-30",1,0.15,6.4000000000000001E-2,12]
[null,"2008-10-30",4,0.15,6.4000000000000001E-2,12]
[null,"2008-11-01",2,0.127,8.5999999999999993E-2,12]
[null,"2008-11-01",5,0.127,8.5999999999999993E-2,12]
[null,"2008-11-02",1,0.22600000000000001,0.16400000000000001,30]
[null,"2008-11-02",4,0.22600000000000001,0.16400000000000001,30]
[null,"2008-11-02",3,0.127,9.6000000000000002E-2,25]
[null,"2008-11-02",6,0.127,9.6000000000000002E-2,25]
[null,"2008-11-03",2,0.24099999999999999,0.13,30]
[null,"2008-11-03",5,0.24099999999999999,0.13,30]
[null,"2008-11-04",1,0.17799999999999999,0.13100000000000001,12]
[null,"2008-11-04",4,0.17799999999999999,0.13100000000000001,12]
[null,"2008-11-05",3,0.127,0.109,20]
[null,"2008-11-05",6,0.127,0.109,20]
[null,"2008-11-06",2,0.161,0.11700000000000001,21]
[null,"2008-11-06",5,0.161,0.11700000000000001,21]
[null,"2008-11-07",1,0.155,0.09,18]
[null,"2008-11-07",4,0.155,0.09,18]
[null,"2008-11-08",3,0.11600000000000001,9.8000000000000004E-2,20]
[null,"2008-11-08",6,0.11600000000000001,9.8000000000000004E-2,20]
[null,"2008-11-09",2,0.14399999999999999,8.5000000000000006E-2,20]
[null,"2008-11-09",5,0.14399999999999999,8.5000000000000006E-2,20]
[null,"2008-11-10",1,0.16600000000000001,8.5999999999999993E-2,22]
[null,"2008-11-10",4,0.16600000000000001,8.5999999999999993E-2,22]
[null,"2008-11-11",3,0.16400000000000001,9.8000000000000004E-2,30]
[null,"2008-11-11",6,0.16400000000000001,9.8000000000000004E-2,30]
[null,"2008-11-12",2,0.111,8.5000000000000006E-2,15]
[null,"2008-11-12",5,0.111,8.5000000000000006E-2,15]
[null,"2008-11-13",1,0.11700000000000001,8.7999999999999995E-2,17]
[null,"2008-11-13",4,0.11700000000000001,8.7999999999999995E-2,17]
[null,"2008-11-14",3,0.13100000000000001,0.113,28]
[null,"2008-11-14",6,0.13100000000000001,0.113,28]
[null,"2008-11-15",2,0.156,9.7000000000000003E-2,26]
[null,"2008-11-15",5,0.156,9.7000000000000003E-2,26]
[null,"2008-11-16",1,0.13600000000000001,9.8000000000000004E-2,25]
[null,"2008-11-16",4,0.13600000000000001,9.8000000000000004E-2,25]
[null,"2008-11-17",3,0.20200000000000001,0.127,30]
[null,"2008-11-17",6,0.20200000000000001,0.127,30]
[null,"2008-11-17",2,0.157,9.6000000000000002E-2,21]
[null,"2008-11-17",5,0.157,9.6000000000000002E-2,21]
[null,"2008-11-19",3,3,1.4610000000000001,32]
[null,"2008-11-19",6,3,1.4610000000000001,32]
[null,"2008-11-19",2,0.193,9.5000000000000001E-2,20]
[null,"2008-11-19",5,0.193,9.5000000000000001E-2,20]
[null,"2008-11-19",1,0.129,9.9000000000000005E-2,18]
[null,"2008-11-19",4,0.129,9.9000000000000005E-2,18]
[null,"2008-11-21",3,0.222,0.186,30]
[null,"2008-11-21",6,0.222,0.186,30]
[null,"2008-11-21",1,0.151,9.9000000000000005E-2,26]
[null,"2008-11-21",4,0.151,9.9000000000000005E-2,26]
[null,"2008-11-22",2,0.183,9.9000000000000005E-2,19]
[null,"2008-11-22",5,0.183,9.9000000000000005E-2,19]
[null,"2008-11-23",1,0.14199999999999999,0.121,38]
[null,"2008-11-23",4,0.14199999999999999,0.121,38]
[null,"2008-11-24",3,0.25600000000000001,0.214,34]
[null,"2008-11-24",6,0.25600000000000001,0.214,34]
[null,"2008-11-25",1,0.36899999999999999,0.36099999999999999,30]
[null,"2008-11-25",2,0.26900000000000002,0.19700000000000001,30]
[null,"2008-11-25",4,0.36899999999999999,0.36099999999999999,30]
[null,"2008-11-25",5,0.26900000000000002,0.19700000000000001,30]
[null,"2008-11-28",3,0.153,0.09,20]
[null,"2008-11-28",6,0.153,0.09,20]
[null,"2008-11-28",2,0.122,9.4E-2,13]
[null,"2008-11-28",5,0.122,9.4E-2,13]
[null,"2008-11-29",1,0.12,9.1999999999999998E-2,17]
[null,"2008-11-29",4,0.12,9.1999999999999998E-2,17]
[null,"2008-12-01",2,0.11799999999999999,9.0999999999999998E-2,12]
[null,"2008-12-01",5,0.11799999999999999,9.0999999999999998E-2,12]
[null,"2008-12-02",1,0.22,0.188,30]
[null,"2008-12-02",3,0.22900000000000001,0.161,30]
[null,"2008-12-02",4,0.22,0.188,30]
[null,"2008-12-02",6,0.22900000000000001,0.161,30]
[null,"2008-12-04",2,0.28899999999999998,0.28899999999999998,32]
[null,"2008-12-04",5,0.28899999999999998,0.28899999999999998,32]
[null,"2008-12-06",3,0.15,0.15,30]
[null,"2008-12-06",6,0.15,0.15,30]
[null,"2008-12-07",1,9.9000000000000005E-2,9.1999999999999998E-2,12]
[null,"2008-12-07",2,8.5000000000000006E-2,7.1999999999999995E-2,12]
[null,"2008-12-07",4,9.9000000000000005E-2,9.1999999999999998E-2,12]
[null,"2008-12-07",5,8.5000000000000006E-2,7.1999999999999995E-2,12]
[null,"2008-12-09",3,0.13,0.10299999999999999,25]
[null,"2008-12-09",6,0.13,0.10299999999999999,25]
[null,"2008-12-10",1,0.114,0.106,13]
[null,"2008-12-10",4,0.114,0.106,13]
[null,"2008-12-12",3,0.14499999999999999,0.12,30]
[null,"2008-12-12",6,0.14499999999999999,0.12,30]
[null,"2008-12-13",1,8.5999999999999993E-2,7.9000000000000001E-2,12]
[null,"2008-12-13",4,8.5999999999999993E-2,7.9000000000000001E-2,12]
[null,"2008-12-14",3,0.14199999999999999,0.11,30]
[null,"2008-12-14",6,0.14199999999999999,0.11,30]
[null,"2008-12-14",2,7.9000000000000001E-2,6.3E-2,11]
[null,"2008-12-14",5,7.9000000000000001E-2,6.3E-2,11]
[null,"2008-12-16",3,0.11600000000000001,0.105,25]
[null,"2008-12-16",6,0.11600000000000001,0.105,25]
[null,"2008-12-16",2,8.6999999999999994E-2,6.9000000000000006E-2,17]
[null,"2008-12-16",5,8.6999999999999994E-2,6.9000000000000006E-2,17]
[null,"2008-12-17",2,8.7999999999999995E-2,7.4999999999999997E-2,12]
[null,"2008-12-17",5,8.7999999999999995E-2,7.4999999999999997E-2,12]
[null,"2008-12-19",3,0.33200000000000002,0.105,21]
[null,"2008-12-19",6,0.33200000000000002,0.105,21]
[null,"2008-12-20",1,0.12,0.1,21]
[null,"2008-12-20",4,0.12,0.1,21]
[null,"2008-12-20",2,0.107,9.6000000000000002E-2,12]
[null,"2008-12-20",5,0.107,9.6000000000000002E-2,12]
[null,"2008-12-23",2,9.6000000000000002E-2,8.1000000000000003E-2,12]
[null,"2008-12-23",5,9.6000000000000002E-2,8.1000000000000003E-2,12]
[null,"2008-12-24",3,0.16900000000000001,6.4000000000000001E-2,12]
[null,"2008-12-24",6,0.16900000000000001,6.4000000000000001E-2,12]

{"sheet":"BW Data PT","index":14,"n_rows":110,"n_cols":4,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Filter",1,null,"Pivot table for creating charts. Do not enter data here."]
[]
["Row Labels","Average of FTW Time (min)","Max of Peak Turbidity","Max of RTS Turbidity"]
["2008-01-02",15,0.109,9.8000000000000004E-2]
["2008-01-09",15,9.0999999999999998E-2,8.5999999999999993E-2]
["2008-01-11",20,0.125,0.11899999999999999]
["2008-01-15",15,9.9000000000000005E-2,9.0999999999999998E-2]
["2008-01-17",22,0.11899999999999999,9.8000000000000004E-2]
["2008-01-19",22,0.107,9.9000000000000005E-2]
["2008-01-22",30,0.13100000000000001,9.9000000000000005E-2]
["2008-01-24",25,0.17899999999999999,0.16800000000000001]
["2008-01-27",14,7.8E-2,7.0999999999999994E-2]
["2008-01-30",17,7.4999999999999997E-2,6.6000000000000003E-2]
["2008-02-02",14,7.0999999999999994E-2,7.0000000000000007E-2]
["2008-02-07",50,0.115,0.111]
["2008-02-08",30,0.74199999999999999,0.105]
["2008-02-13",22,0.1,9.0999999999999998E-2]
["2008-02-15",30,0.125,0.1]
["2008-02-17",35,0.127,9.6000000000000002E-2]
["2008-02-19",150,null,0.14899999999999999]
["2008-02-21",25,0.12,0.108]
["2008-02-23",30,0.153,0.124]
["2008-02-25",30,0.13400000000000001,0.109]
["2008-02-27",25,0.127,0.12]
["2008-04-03",16,8.1000000000000003E-2,7.4999999999999997E-2]
["2008-04-06",12,9.5000000000000001E-2,8.6999999999999994E-2]
["2008-04-10",16,0.14399999999999999,9.9000000000000005E-2]
["2008-04-26",11,0.16500000000000001,9.1999999999999998E-2]
["2008-04-30",13,0.122,7.3999999999999996E-2]
["2008-05-03",13,7.9000000000000001E-2,7.1999999999999995E-2]
["2008-05-07",13,7.5999999999999998E-2,6.9000000000000006E-2]
["2008-05-10",11,8.3000000000000004E-2,7.5999999999999998E-2]
["2008-05-14",12,0.14899999999999999,8.7999999999999995E-2]
["2008-05-17",17,0.184,0.08]
["2008-05-19",12,0.32500000000000001,8.5999999999999993E-2]
["2008-05-21",11,0.14799999999999999,9.8000000000000004E-2]
["2008-05-24",11,0.112,8.6999999999999994E-2]
["2008-05-27",12,0.11799999999999999,9.5000000000000001E-2]
["2008-05-29",11,0.105,8.3000000000000004E-2]
["2008-06-01",13,0.125,9.6000000000000002E-2]
["2008-06-03",19,0.154,9.8000000000000004E-2]
["2008-06-04",20,0.20200000000000001,9.1999999999999998E-2]
["2008-06-06",17,0.13700000000000001,9.9000000000000005E-2]
["2008-06-07",16,0.151,9.5000000000000001E-2]
["2008-06-29",13,0.113,8.6999999999999994E-2]
["2008-06-30",12,0.111,9.1999999999999998E-2]
["2008-07-02",30,0.13100000000000001,0.11700000000000001]
["2008-07-05",15,0.126,9.1999999999999998E-2]
["2008-07-07",20,0.14199999999999999,7.0000000000000007E-2]
["2008-07-08",16,0.12,7.2999999999999995E-2]
["2008-07-10",16,0.106,7.2999999999999995E-2]
["2008-07-11",14,0.13500000000000001,8.4000000000000005E-2]
["2008-07-13",11,0.127,8.6999999999999994E-2]
["2008-07-14",12,0.126,8.5999999999999993E-2]
["2008-07-15",13,0.13500000000000001,9.5000000000000001E-2]
["2008-07-16",52,0.63700000000000001,0.115]
["2008-07-18",19,0.18,9.2999999999999999E-2]
["2008-07-20",25,0.21,9.8000000000000004E-2]
["2008-07-21",17,0.187,9.4E-2]
["2008-07-23",19,0.19900000000000001,9.1999999999999998E-2]
["2008-07-24",27,0.20100000000000001,9.9000000000000005E-2]
["2008-07-25",26,0.23599999999999999,9.8000000000000004E-2]
["2008-07-27",35,0.22700000000000001,0.108]
["2008-07-28",36,0.185,0.106]
["2008-07-29",45,0.20200000000000001,0.11700000000000001]
["2008-07-31",35,0.22700000000000001,0.108]
["2008-08-03",27,0.24199999999999999,0.09]
["2008-08-06",45,0.23400000000000001,0.10299999999999999]
["2008-08-08",30,0.24299999999999999,0.104]
["2008-08-10",23,0.21299999999999999,9.8000000000000004E-2]
["2008-08-13",17,0.159,9.6000000000000002E-2]
["2008-08-15",20,0.20200000000000001,9.0999999999999998E-2]
["2008-08-18",30,0.20100000000000001,9.7000000000000003E-2]
["2008-08-20",25,0.182,9.7000000000000003E-2]
["2008-08-23",23,0.21199999999999999,9.8000000000000004E-2]
["2008-08-24",20,0.184,8.7999999999999995E-2]
["2008-08-26",30,0.18099999999999999,7.0000000000000007E-2]
["2008-08-29",21,0.184,9.7000000000000003E-2]
["2008-09-06",27,0.23,9.7000000000000003E-2]
["2008-09-07",61,0.23599999999999999,9.9000000000000005E-2]
["2008-09-08",159,0.441,0.13700000000000001]
["2008-09-12",37,0.184,9.7000000000000003E-2]
["2008-09-17",35,0.23599999999999999,9.9000000000000005E-2]
["2008-09-21",30,0.27100000000000002,0.13900000000000001]
["2008-09-24",35,0.35499999999999998,0.152]
["2008-09-27",30,0.26400000000000001,0.17199999999999999]
["2008-10-02",30,0.24399999999999999,0.14499999999999999]
["2008-10-05",32,0.254,0.13800000000000001]
["2008-10-10",25,0.17899999999999999,0.126]
["2008-10-19",32,0.247,0.13900000000000001]
["2008-10-22",30,0.245,0.192]
["2008-10-25",31,0.161,0.14399999999999999]
["2008-10-30",12,0.15,6.4000000000000001E-2]
["2008-11-02",30,0.22600000000000001,0.16400000000000001]
["2008-11-04",12,0.17799999999999999,0.13100000000000001]
["2008-11-07",18,0.155,0.09]
["2008-11-10",22,0.16600000000000001,8.5999999999999993E-2]
["2008-11-13",17,0.11700000000000001,8.7999999999999995E-2]
["2008-11-16",25,0.13600000000000001,9.8000000000000004E-2]
["2008-11-19",18,0.129,9.9000000000000005E-2]
["2008-11-21",26,0.151,9.9000000000000005E-2]
["2008-11-23",38,0.14199999999999999,0.121]
["2008-11-25",30,0.36899999999999999,0.36099999999999999]
["2008-11-29",17,0.12,9.1999999999999998E-2]
["2008-12-02",30,0.22,0.188]
["2008-12-07",12,9.9000000000000005E-2,9.1999999999999998E-2]
["2008-12-10",13,0.114,0.106]
["2008-12-13",12,8.5999999999999993E-2,7.9000000000000001E-2]
["2008-12-20",21,0.12,0.1]
["Grand Total",25.264150943396228,0.74199999999999999,0.36099999999999999]

{"sheet":"LT-Trend","index":15,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Settled Water (All Sed)",null,null,null,"Filtered Water (All Filters)"]
[null,null,"Turbidity","% Values Meeting Goal",null,null,"Turbidity","% Values Meeting Goal"]
[null,"Month/Yr","95th %","3 NTU","2 NTU","1 NTU","95th %","0.3 NTU","0.2 NTU","0.1 NTU"]
[null,"2016-01-01"]
[null,"2016-02-01"]
[null,"2016-03-01"]
[null,"2016-04-01"]
[null,"2016-05-01"]
[null,"2016-06-01"]
[null,"2016-07-01"]
[null,"2016-08-01"]
[null,"2016-09-01"]
[null,"2016-10-01"]
[null,"2016-11-01"]
[null,"2016-12-01"]
[]
[null,"The area in blue can be copied to the long-term trend table below to develop up to three year trend charts."]
[null,"Delete example data."]
[null,"Manually copy and paste the data into the table below."]
[]
[null,null,"Settled Water (All Sed)",null,null,null,"Filtered Water (All Filters)"]
[null,null,"Turbidity","% Values Meeting Goal",null,null,"Turbidity","% Values Meeting Goal"]
[null,"Month/Yr","95th %","3 NTU","2 NTU","1 NTU","95th %","0.3 NTU","0.2 NTU","0.1 NTU"]
[null,"1998-01-01",5.15,22.580645161290324,3.225806451612903,null,0.42499999999999999,70.967741935483872,35.483870967741936,3.225806451612903]
[null,"1998-02-01",6.54,53.571428571428569,14.285714285714286,null,0.40404999999999996,75,57.142857142857146,14.285714285714286]
[null,"1998-03-01",4.9000000000000004,70.967741935483872,19.35483870967742,null,0.28249999999999997,96.774193548387103,70.967741935483872,29.032258064516128]
[null,"1998-04-01",4.78,80,60,null,0.24994999999999987,100,83.333333333333329,43.333333333333336]
[null,"1998-05-01",5.8,80.645161290322577,61.29032258064516,null,0.20050000000000001,100,93.548387096774192,77.41935483870968]
["Year 1","1998-06-01",2.5099999999999998,96.666666666666671,90,20,0.14279999999999995,96.666666666666671,96.666666666666671,76.666666666666671]
[null,"1998-07-01",2.2000000000000002,96.774193548387103,93.548387096774192,58.064516129032256,0.17549999999999999,100,96.774193548387103,41.935483870967744]
[null,"1998-08-01",1.2,100,100,90.322580645161295,0.193,100,96.774193548387103,74.193548387096769]
[null,"1998-09-01",1.8,100,100,36.666666666666664,0.14259999999999998,100,100,60]
[null,"1998-10-01",1.4,100,100,64.516129032258064,0.13200000000000001,100,100,80.645161290322577]
[null,"1998-11-01",1.5,100,100,50,9.6000000000000002E-2,100,100,100]
[null,"1998-12-01",4.25,87.096774193548384,54.838709677419352,6.4516129032258061,0.17899999999999999,100,96.774193548387103,70.967741935483872]
[null,"1999-01-01",3.85,77.41935483870968,32.258064516129032,null,0.432,87.096774193548384,64.516129032258064,32.258064516129032]
[null,"1999-02-01",2.5950000000000002,96.428571428571431,75,3.5714285714285716,0.37309999999999977,92.857142857142861,82.142857142857139,46.428571428571431]
[null,"1999-03-01",2.8,96.774193548387103,74.193548387096769,null,0.33250000000000002,93.548387096774192,80.645161290322577,48.387096774193552]
[null,"1999-04-01",2.0550000000000002,100,93.333333333333329,33.333333333333336,0.32454999999999967,93.333333333333329,83.333333333333329,56.666666666666664]
[null,"1999-05-01",2.2000000000000002,100,90.322580645161295,9.67741935483871,0.20050000000000001,100,93.548387096774192,54.838709677419352]
["Year 2","1999-06-01",1.71,100,100,33.333333333333336,0.19955000000000001,100,96.666666666666671,46.666666666666664]
[null,"1999-07-01",1.125,100,100,87.096774193548384,5.6500000000000002E-2,100,100,100]
[null,"1999-08-01",1.375,100,100,83.870967741935488,5.6500000000000002E-2,100,100,100]
[null,"1999-09-01",1.61,100,96.666666666666671,40,0.11119999999999983,100,100,93.333333333333329]
[null,"1999-10-01",1.4,100,100,16.129032258064516,7.5999999999999998E-2,96.774193548387103,96.774193548387103,96.774193548387103]
[null,"1999-11-01",1.5,100,100,23.333333333333332,9.6549999999999941E-2,100,100,93.333333333333329]
[null,"1999-12-01",1.55,96.774193548387103,96.774193548387103,6.4516129032258061,0.33699999999999997,93.548387096774192,90.322580645161295,83.870967741935488]
[null,"2000-01-01",2.95,93.548387096774192,90.322580645161295,29.032258064516128,0.24349999999999999,100,84.615384615384613,23.076923076923077]
[null,"2000-02-01",1.7,100,100,50,0.13,95.238095238095241,95.238095238095241,76.19047619047619]
[null,"2000-03-01",1.78,100,96.551724137931032,41.379310344827587,8.5999999999999993E-2,100,100,100]
[null,"2000-04-01",2.02,100,93.333333333333329,46.666666666666664,8.2299999999999984E-2,100,100,100]
[null,"2000-05-01",1.4,100,100,90.322580645161295,9.6500000000000002E-2,100,100,96.774193548387103]
["Year 3","2000-06-01",0.71849999999999981,100,100,100,5.1499999999999969E-2,100,100,100]
[null,"2000-07-01",0.77500000000000002,100,100,100,7.1500000000000008E-2,100,100,100]
[null,"2000-08-01",0.75,100,100,100,0.05,100,100,100]
[null,"2000-09-01",0.84399999999999975,100,100,100,8.7999999999999995E-2,100,100,96.666666666666671]
[null,"2000-10-01",0.92500000000000004,100,100,100,7.1500000000000008E-2,100,100,100]
[null,"2000-11-01",0.96,100,100,96.551724137931032,9.7999999999999934E-2,100,100,93.103448275862064]
[null,"2000-12-01",null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"PT setup","index":17,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,"Use to screen shots to recreate BW pivot table and charts"]

{"sheet":"AllDataSort","index":19,"n_rows":371,"n_cols":32,"rows_kept":371,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"DataEntryValues!G2","v":"Rocky Mountain Water District"},null,null,null,"2016-02-01"]
[null,null,null,null,null,"Cell to identify if year is a leap year or not.",null,null,null,{"$f":"IF(MOD(YEAR(J2)/4,1)=0,1,2)","v":1}]
[null,null,null,null,"Data Entry Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Data Sort Table"]
["FebValue","FebFind",null,null,null,"Raw","Sed 1","Sed 2","Sed 3","Sed 4","Filter 1","Filter 2","Filter 3","Filter 4","Filter 5","Filter 6","Filter 7","Filter 8","Filter 9","Filter 10","Filter 11","Filter 12","Combined"]
[0,{"$f":"IF(MONTH(E6)=2,\"feb\",)","v":0},{"$f":"MONTH(E6)","v":1},1,"2016-01-01"]
[0,0,{"$f":"MONTH(E7)","v":1},1,"2016-01-02"]
[0,0,1,1,"2016-01-03"]
[0,0,1,1,"2016-01-04"]
[0,0,1,1,"2016-01-05"]
[0,0,1,1,"2016-01-06"]
[0,0,1,1,"2016-01-07"]
[0,0,1,1,"2016-01-08"]
[0,0,1,1,"2016-01-09"]
[0,0,1,1,"2016-01-10"]
[0,0,1,1,"2016-01-11"]
[0,0,1,1,"2016-01-12"]
[0,0,1,1,"2016-01-13"]
[0,0,1,1,"2016-01-14"]
[0,0,1,1,"2016-01-15"]
[0,0,1,1,"2016-01-16"]
[0,0,1,1,"2016-01-17"]
[0,0,1,1,"2016-01-18"]
[0,0,1,1,"2016-01-19"]
[0,0,1,1,"2016-01-20"]
[0,0,1,1,"2016-01-21"]
[0,0,1,1,"2016-01-22"]
[0,0,1,1,"2016-01-23"]
[0,0,1,1,"2016-01-24"]
[0,0,1,1,"2016-01-25"]
[0,0,1,1,"2016-01-26"]
[0,0,1,1,"2016-01-27"]
[0,0,1,1,"2016-01-28"]
[0,0,1,1,"2016-01-29"]
[0,0,1,1,"2016-01-30"]
[0,0,1,1,"2016-01-31"]
["feb","feb",2,2,"2016-02-01"]
["feb","feb",2,2,"2016-02-02"]
["feb","feb",2,2,"2016-02-03"]
["feb","feb",2,2,"2016-02-04"]
["feb","feb",2,2,"2016-02-05"]
["feb","feb",2,2,"2016-02-06"]
["feb","feb",2,2,"2016-02-07"]
["feb","feb",2,2,"2016-02-08"]
["feb","feb",2,2,"2016-02-09"]
["feb","feb",2,2,"2016-02-10"]
["feb","feb",2,2,"2016-02-11"]
["feb","feb",2,2,"2016-02-12"]
["feb","feb",2,2,"2016-02-13"]
["feb","feb",2,2,"2016-02-14"]
["feb","feb",2,2,"2016-02-15"]
["feb","feb",2,2,"2016-02-16"]
["feb","feb",2,2,"2016-02-17"]
["feb","feb",2,2,"2016-02-18"]
["feb","feb",2,2,"2016-02-19"]
["feb","feb",2,2,"2016-02-20"]
["feb","feb",2,2,"2016-02-21"]
["feb","feb",2,2,"2016-02-22"]
["feb","feb",2,2,"2016-02-23"]
["feb","feb",2,2,"2016-02-24"]
["feb","feb",2,2,"2016-02-25"]
["feb","feb",2,2,"2016-02-26"]
["feb","feb",2,2,"2016-02-27"]
["feb","feb",2,2,"2016-02-28"]
["feb","feb",2,2,"2016-02-29"]
[0,0,3,3,"2016-03-01"]
[0,0,3,3,"2016-03-02"]
[0,0,3,3,"2016-03-03"]
[0,0,3,3,"2016-03-04"]
[0,0,3,3,"2016-03-05"]
[0,{"$f":"IF(MONTH(E71)=2,\"feb\",)","v":0},{"$f":"MONTH(E71)","v":3},3,"2016-03-06"]
[0,0,3,3,"2016-03-07"]
[0,0,3,3,"2016-03-08"]
[0,0,3,3,"2016-03-09"]
[0,0,3,3,"2016-03-10"]
[0,0,3,3,"2016-03-11"]
[0,0,3,3,"2016-03-12"]
[0,0,3,3,"2016-03-13"]
[0,0,3,3,"2016-03-14"]
[0,0,3,3,"2016-03-15"]
[0,0,3,3,"2016-03-16"]
[0,0,3,3,"2016-03-17"]
[0,0,3,3,"2016-03-18"]
[0,0,3,3,"2016-03-19"]
[0,0,3,3,"2016-03-20"]
[0,0,3,3,"2016-03-21"]
[0,0,3,3,"2016-03-22"]
[0,0,3,3,"2016-03-23"]
[0,0,3,3,"2016-03-24"]
[0,0,3,3,"2016-03-25"]
[0,0,3,3,"2016-03-26"]
[0,0,3,3,"2016-03-27"]
[0,0,3,3,"2016-03-28"]
[0,0,3,3,"2016-03-29"]
[0,0,3,3,"2016-03-30"]
[0,0,3,3,"2016-03-31"]
[0,0,4,4,"2016-04-01"]
[0,0,4,4,"2016-04-02"]
[0,0,4,4,"2016-04-03"]
[0,0,4,4,"2016-04-04"]
[0,0,4,4,"2016-04-05"]
[0,0,4,4,"2016-04-06"]
[0,0,4,4,"2016-04-07"]
[0,0,4,4,"2016-04-08"]
[0,0,4,4,"2016-04-09"]
[0,0,4,4,"2016-04-10"]
[0,0,4,4,"2016-04-11"]
[0,0,4,4,"2016-04-12"]
[0,0,4,4,"2016-04-13"]
[0,0,4,4,"2016-04-14"]
[0,0,4,4,"2016-04-15"]
[0,0,4,4,"2016-04-16"]
[0,0,4,4,"2016-04-17"]
[0,0,4,4,"2016-04-18"]
[0,0,4,4,"2016-04-19"]
[0,0,4,4,"2016-04-20"]
[0,0,4,4,"2016-04-21"]
[0,0,4,4,"2016-04-22"]
[0,0,4,4,"2016-04-23"]
[0,0,4,4,"2016-04-24"]
[0,0,4,4,"2016-04-25"]
[0,0,4,4,"2016-04-26"]
[0,0,4,4,"2016-04-27"]
[0,0,4,4,"2016-04-28"]
[0,0,4,4,"2016-04-29"]
[0,0,4,4,"2016-04-30"]
[0,0,5,5,"2016-05-01"]
[0,0,5,5,"2016-05-02"]
[0,0,5,5,"2016-05-03"]
[0,0,5,5,"2016-05-04"]
[0,0,5,5,"2016-05-05"]
[0,0,5,5,"2016-05-06"]
[0,0,5,5,"2016-05-07"]
[0,0,5,5,"2016-05-08"]
[0,{"$f":"IF(MONTH(E135)=2,\"feb\",)","v":0},{"$f":"MONTH(E135)","v":5},5,"2016-05-09"]
[0,0,5,5,"2016-05-10"]
[0,0,5,5,"2016-05-11"]
[0,0,5,5,"2016-05-12"]
[0,0,5,5,"2016-05-13"]
[0,0,5,5,"2016-05-14"]
[0,0,5,5,"2016-05-15"]
[0,0,5,5,"2016-05-16"]
[0,0,5,5,"2016-05-17"]
[0,0,5,5,"2016-05-18"]
[0,0,5,5,"2016-05-19"]
[0,0,5,5,"2016-05-20"]
[0,0,5,5,"2016-05-21"]
[0,0,5,5,"2016-05-22"]
[0,0,5,5,"2016-05-23"]
[0,0,5,5,"2016-05-24"]
[0,0,5,5,"2016-05-25"]
[0,0,5,5,"2016-05-26"]
[0,0,5,5,"2016-05-27"]
[0,0,5,5,"2016-05-28"]
[0,0,5,5,"2016-05-29"]
[0,0,5,5,"2016-05-30"]
[0,0,5,5,"2016-05-31"]
[0,0,6,6,"2016-06-01"]
[0,0,6,6,"2016-06-02"]
[0,0,6,6,"2016-06-03"]
[0,0,6,6,"2016-06-04"]
[0,0,6,6,"2016-06-05"]
[0,0,6,6,"2016-06-06"]
[0,0,6,6,"2016-06-07"]
[0,0,6,6,"2016-06-08"]
[0,0,6,6,"2016-06-09"]
[0,0,6,6,"2016-06-10"]
[0,0,6,6,"2016-06-11"]
[0,0,6,6,"2016-06-12"]
[0,0,6,6,"2016-06-13"]
[0,0,6,6,"2016-06-14"]
[0,0,6,6,"2016-06-15"]
[0,0,6,6,"2016-06-16"]
[0,0,6,6,"2016-06-17"]
[0,0,6,6,"2016-06-18"]
[0,0,6,6,"2016-06-19"]
[0,0,6,6,"2016-06-20"]
[0,0,6,6,"2016-06-21"]
[0,0,6,6,"2016-06-22"]
[0,0,6,6,"2016-06-23"]
[0,0,6,6,"2016-06-24"]
[0,0,6,6,"2016-06-25"]
[0,0,6,6,"2016-06-26"]
[0,0,6,6,"2016-06-27"]
[0,0,6,6,"2016-06-28"]
[0,0,6,6,"2016-06-29"]
[0,0,6,6,"2016-06-30"]
[0,0,7,7,"2016-07-01"]
[0,0,7,7,"2016-07-02"]
[0,0,7,7,"2016-07-03"]
[0,0,7,7,"2016-07-04"]
[0,0,7,7,"2016-07-05"]
[0,0,7,7,"2016-07-06"]
[0,0,7,7,"2016-07-07"]
[0,0,7,7,"2016-07-08"]
[0,0,7,7,"2016-07-09"]
[0,0,7,7,"2016-07-10"]
[0,0,7,7,"2016-07-11"]
[0,{"$f":"IF(MONTH(E199)=2,\"feb\",)","v":0},{"$f":"MONTH(E199)","v":7},7,"2016-07-12"]
[0,0,7,7,"2016-07-13"]
[0,0,7,7,"2016-07-14"]
[0,0,7,7,"2016-07-15"]
[0,0,7,7,"2016-07-16"]
[0,0,7,7,"2016-07-17"]
[0,0,7,7,"2016-07-18"]
[0,0,7,7,"2016-07-19"]
[0,0,7,7,"2016-07-20"]
[0,0,7,7,"2016-07-21"]
[0,0,7,7,"2016-07-22"]
[0,0,7,7,"2016-07-23"]
[0,0,7,7,"2016-07-24"]
[0,0,7,7,"2016-07-25"]
[0,0,7,7,"2016-07-26"]
[0,0,7,7,"2016-07-27"]
[0,0,7,7,"2016-07-28"]
[0,0,7,7,"2016-07-29"]
[0,0,7,7,"2016-07-30"]
[0,0,7,7,"2016-07-31"]
[0,0,8,8,"2016-08-01"]
[0,0,8,8,"2016-08-02"]
[0,0,8,8,"2016-08-03"]
[0,0,8,8,"2016-08-04"]
[0,0,8,8,"2016-08-05"]
[0,0,8,8,"2016-08-06"]
[0,0,8,8,"2016-08-07"]
[0,0,8,8,"2016-08-08"]
[0,0,8,8,"2016-08-09"]
[0,0,8,8,"2016-08-10"]
[0,0,8,8,"2016-08-11"]
[0,0,8,8,"2016-08-12"]
[0,0,8,8,"2016-08-13"]
[0,0,8,8,"2016-08-14"]
[0,0,8,8,"2016-08-15"]
[0,0,8,8,"2016-08-16"]
[0,0,8,8,"2016-08-17"]
[0,0,8,8,"2016-08-18"]
[0,0,8,8,"2016-08-19"]
[0,0,8,8,"2016-08-20"]
[0,0,8,8,"2016-08-21"]
[0,0,8,8,"2016-08-22"]
[0,0,8,8,"2016-08-23"]
[0,0,8,8,"2016-08-24"]
[0,0,8,8,"2016-08-25"]
[0,0,8,8,"2016-08-26"]
[0,0,8,8,"2016-08-27"]
[0,0,8,8,"2016-08-28"]
[0,0,8,8,"2016-08-29"]
[0,0,8,8,"2016-08-30"]
[0,0,8,8,"2016-08-31"]
[0,0,9,9,"2016-09-01"]
[0,0,9,9,"2016-09-02"]
[0,0,9,9,"2016-09-03"]
[0,0,9,9,"2016-09-04"]
[0,0,9,9,"2016-09-05"]
[0,0,9,9,"2016-09-06"]
[0,0,9,9,"2016-09-07"]
[0,0,9,9,"2016-09-08"]
[0,0,9,9,"2016-09-09"]
[0,0,9,9,"2016-09-10"]
[0,0,9,9,"2016-09-11"]
[0,0,9,9,"2016-09-12"]
[0,0,9,9,"2016-09-13"]
[0,{"$f":"IF(MONTH(E263)=2,\"feb\",)","v":0},{"$f":"MONTH(E263)","v":9},9,"2016-09-14"]
[0,0,9,9,"2016-09-15"]
[0,0,9,9,"2016-09-16"]
[0,0,9,9,"2016-09-17"]
[0,0,9,9,"2016-09-18"]
[0,0,9,9,"2016-09-19"]
[0,0,9,9,"2016-09-20"]
[0,0,9,9,"2016-09-21"]
[0,0,9,9,"2016-09-22"]
[0,0,9,9,"2016-09-23"]
[0,0,9,9,"2016-09-24"]
[0,0,9,9,"2016-09-25"]
[0,0,9,9,"2016-09-26"]
[0,0,9,9,"2016-09-27"]
[0,0,9,9,"2016-09-28"]
[0,0,9,9,"2016-09-29"]
[0,0,9,9,"2016-09-30"]
[0,0,10,10,"2016-10-01"]
[0,0,10,10,"2016-10-02"]
[0,0,10,10,"2016-10-03"]
[0,0,10,10,"2016-10-04"]
[0,0,10,10,"2016-10-05"]
[0,0,10,10,"2016-10-06"]
[0,0,10,10,"2016-10-07"]
[0,0,10,10,"2016-10-08"]
[0,0,10,10,"2016-10-09"]
[0,0,10,10,"2016-10-10"]
[0,0,10,10,"2016-10-11"]
[0,0,10,10,"2016-10-12"]
[0,0,10,10,"2016-10-13"]
[0,0,10,10,"2016-10-14"]
[0,0,10,10,"2016-10-15"]
[0,0,10,10,"2016-10-16"]
[0,0,10,10,"2016-10-17"]
[0,0,10,10,"2016-10-18"]
[0,0,10,10,"2016-10-19"]
[0,0,10,10,"2016-10-20"]
[0,0,10,10,"2016-10-21"]
[0,0,10,10,"2016-10-22"]
[0,0,10,10,"2016-10-23"]
[0,0,10,10,"2016-10-24"]
[0,0,10,10,"2016-10-25"]
[0,0,10,10,"2016-10-26"]
[0,0,10,10,"2016-10-27"]
[0,0,10,10,"2016-10-28"]
[0,0,10,10,"2016-10-29"]
[0,0,10,10,"2016-10-30"]
[0,0,10,10,"2016-10-31"]
[0,0,11,11,"2016-11-01"]
[0,0,11,11,"2016-11-02"]
[0,0,11,11,"2016-11-03"]
[0,0,11,11,"2016-11-04"]
[0,0,11,11,"2016-11-05"]
[0,0,11,11,"2016-11-06"]
[0,0,11,11,"2016-11-07"]
[0,0,11,11,"2016-11-08"]
[0,0,11,11,"2016-11-09"]
[0,0,11,11,"2016-11-10"]
[0,0,11,11,"2016-11-11"]
[0,0,11,11,"2016-11-12"]
[0,0,11,11,"2016-11-13"]
[0,0,11,11,"2016-11-14"]
[0,0,11,11,"2016-11-15"]
[0,0,11,11,"2016-11-16"]
[0,{"$f":"IF(MONTH(E327)=2,\"feb\",)","v":0},{"$f":"MONTH(E327)","v":11},11,"2016-11-17"]
[0,0,11,11,"2016-11-18"]
[0,0,11,11,"2016-11-19"]
[0,0,11,11,"2016-11-20"]
[0,0,11,11,"2016-11-21"]
[0,0,11,11,"2016-11-22"]
[0,0,11,11,"2016-11-23"]
[0,0,11,11,"2016-11-24"]
[0,0,11,11,"2016-11-25"]
[0,0,11,11,"2016-11-26"]
[0,0,11,11,"2016-11-27"]
[0,0,11,11,"2016-11-28"]
[0,0,11,11,"2016-11-29"]
[0,0,11,11,"2016-11-30"]
[0,0,12,12,"2016-12-01"]
[0,0,12,12,"2016-12-02"]
[0,0,12,12,"2016-12-03"]
[0,0,12,12,"2016-12-04"]
[0,0,12,12,"2016-12-05"]
[0,0,12,12,"2016-12-06"]
[0,0,12,12,"2016-12-07"]
[0,0,12,12,"2016-12-08"]
[0,0,12,12,"2016-12-09"]
[0,0,12,12,"2016-12-10"]
[0,0,12,12,"2016-12-11"]
[0,0,12,12,"2016-12-12"]
[0,0,12,12,"2016-12-13"]
[0,0,12,12,"2016-12-14"]
[0,0,12,12,"2016-12-15"]
[0,0,12,12,"2016-12-16"]
[0,0,12,12,"2016-12-17"]
[0,0,12,12,"2016-12-18"]
[0,0,12,12,"2016-12-19"]
[0,0,12,12,"2016-12-20"]
[0,0,12,12,"2016-12-21"]
[0,0,12,12,"2016-12-22"]
[0,0,12,12,"2016-12-23"]
[0,0,12,12,"2016-12-24"]
[0,0,12,12,"2016-12-25"]
[0,0,12,12,"2016-12-26"]
[0,0,12,12,"2016-12-27"]
[0,0,12,12,"2016-12-28"]
[0,0,12,12,"2016-12-29"]
[0,0,12,12,"2016-12-30"]
[0,0,{"$f":"IF(J3=1,MONTH(E371),13)","v":12},12,"2016-12-31"]

{"sheet":"MonthDist","index":20,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null,"Settled Turbidity",null,null,null,null,null,null,null,"Filtered Turbidity"]
["MONTH","Sed1 95%","Sed2 95%","Sed3 95%","Sed4 95%","All Sed 95th P","Goal 3","Goal 2","Goal 1","95% #1","95% #2","95% #3","95% #4","95% #5","95% #6","95% #7","95% #8","95% #9","95% #10","95% #11","95% #12","95% Comb","95% All Filters","Goal .3","Goal .2","Goal .1"]
[{"$f":"MonthStart","v":"2016-12-01"},{"$f":"IF(SUM(_Sed1)=0,,PERCENTILE(_Sed1,0.95))","v":0},{"$f":"IF(SUM(_Sed2)=0,,PERCENTILE(_Sed2,0.95))","v":0},{"$f":"IF(SUM(_Sed3)=0,,PERCENTILE(_Sed3,0.95))","v":0},{"$f":"IF(SUM(_Sed4)=0,,PERCENTILE(_Sed4,0.95))","v":0},{"$f":"IF(SUM(SedGoalPercent)=0,,PERCENTILE(SedGoalPercent,0.95))","v":0},{"$f":"IF(SUM(SedGoalPercent)=0,,100*FREQUENCY(SedGoalPercent,3)/COUNT(SedGoalPercent))","v":0},{"$f":"IF(SUM(SedGoalPercent)=0,,100*FREQUENCY(SedGoalPercent,2)/COUNT(SedGoalPercent))","v":0},{"$f":"IF(SUM(SedGoalPercent)=0,,100*FREQUENCY(SedGoalPercent,1)/COUNT(SedGoalPercent))","v":0},{"$f":"IF(SUM(Filter1)=0,,PERCENTILE(Filter1,0.95))","v":0},{"$f":"IF(SUM(Filter2)=0,,PERCENTILE(Filter2,0.95))","v":0},{"$f":"IF(SUM(Filter3)=0,,PERCENTILE(Filter3,0.95))","v":0},{"$f":"IF(SUM(Filter4)=0,,PERCENTILE(Filter4,0.95))","v":0},{"$f":"IF(SUM(Filter5)=0,,PERCENTILE(Filter5,0.95))","v":0},{"$f":"IF(SUM(Filter6)=0,,PERCENTILE(Filter6,0.95))","v":0},{"$f":"IF(SUM(Filter7)=0,,PERCENTILE(Filter7,0.95))","v":0},{"$f":"IF(SUM(Filter8)=0,,PERCENTILE(Filter8,0.95))","v":0},{"$f":"IF(SUM(Filter9)=0,,PERCENTILE(Filter9,0.95))","v":0},{"$f":"IF(SUM(Filter10)=0,,PERCENTILE(Filter10,0.95))","v":0},{"$f":"IF(SUM(Filter11)=0,,PERCENTILE(Filter11,0.95))","v":0},{"$f":"IF(SUM(Filter12)=0,,PERCENTILE(Filter12,0.95))","v":0},{"$f":"IF(SUM(Combined)=0,,PERCENTILE(Combined,0.95))","v":0},{"$f":"IF(SUM(FilterGoalPercent)=0,,PERCENTILE(FilterGoalPercent,0.95))","v":0},{"$f":"IF(SUM(FilterGoalPercent)=0,,100*FREQUENCY(FilterGoalPercent,0.3)/COUNT(FilterGoalPercent))","v":0},{"$f":"IF(SUM(FilterGoalPercent)=0,,100*FREQUENCY(FilterGoalPercent,0.2)/COUNT(FilterGoalPercent))","v":0},{"$f":"IF(SUM(FilterGoalPercent)=0,,100*FREQUENCY(FilterGoalPercent,0.1)/COUNT(FilterGoalPercent))","v":0}]
[]
[]
["Monthly Data"]
[null,"Raw","Sed 1","Sed 2","Sed 3","Sed 4","Filter 1","Filter 2","Filter 3","Filter 4","Filter 5","Filter 6","Filter 7","Filter 8","Filter 9","Filter 10","Filter 11","Filter 12","Combined"]
[]
[]
["2016-12-01"]
["2016-12-02"]
["2016-12-03"]
["2016-12-04"]
["2016-12-05"]
["2016-12-06"]
["2016-12-07"]
["2016-12-08"]
["2016-12-09"]
["2016-12-10"]
["2016-12-11"]
["2016-12-12"]
["2016-12-13"]
["2016-12-14"]
["2016-12-15"]
["2016-12-16"]
["2016-12-17"]
["2016-12-18"]
["2016-12-19"]
["2016-12-20"]
["2016-12-21"]
["2016-12-22"]
["2016-12-23"]
["2016-12-24"]
["2016-12-25"]
["2016-12-26"]
["2016-12-27"]
["2016-12-28"]
["2016-12-29"]
["2016-12-30"]
["2016-12-31"]
[]
[]
[null,null,null,null,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":"COUNT(_CFC1)","v":0}]