Need some help with visualising data from MySQL database

117 views
Skip to first unread message

Matt K90

unread,
May 31, 2017, 9:19:08 AM5/31/17
to Google Visualization API
Hi there,

I'll hold my hands up right now and say that I'm new to Google Charts, so apologies in advance if this is a noob question!

I am trying to create a line chart of temperature information, collected by Raspberry Pi, from within my house. The data is stored in a MySQL database in the following format:

        tdate                ttime        zone                                temperature
        2017-05-14 17:24:17 Living Room Out Box 19
2017-05-14 17:24:23 Living Room In Box         20
2017-05-14 17:24:31 Living Room Out Box 20
2017-05-14 17:24:42 Living Room In Box         20
2017-05-14 17:24:48 Living Room Out Box 20
2017-05-14 17:24:53 Living Room In Box         20
2017-05-14 17:24:59 Outside                     15
2017-05-14 17:25:05 Living Room In Box         20
2017-05-14 17:25:12 Living Room Out Box 20
2017-05-14 17:25:18 Living Room In Box         20
2017-05-14 17:25:23 Outside                      15
2017-05-14 17:25:29 Living Room In Box         20
2017-05-14 17:25:35 Living Room Out Box 20
2017-05-14 17:25:41 Living Room In Box         20


I am trying to plot a graph that has a line for each zone, similar to below:



I cannot fathom how I need to organise my DataTable in order to account for the way in which the data is being returned. I will be adding thermometers to the house as I progress with the renovations, so I'd like to be able to cater for data where a line is plotted that may start half way through the results set  when that thermometer comes online (see "Outside" zone for example).

In order to set the columns and data in the way I've seen in all tutorials and examples, I would need to know the order in which they appear in the database. However the data is not in that format as I've added thermometers as I've progressed, plus due to the way in which the thermometers work they might all be writing at slightly different times, so I cannot easily order the data to create the table orientation below (example I've found online showing add rows used when order is known):

data.addColumn('number', 'Day');
      data.addColumn('number', 'Guardians of the Galaxy');
      data.addColumn('number', 'The Avengers');
      data.addColumn('number', 'Transformers: Age of Extinction');

      data.addRows([
        [1,  37.8, 80.8, 41.8],
        [2,  30.9, 69.5, 32.4],
        [3,  25.4,   57, 25.7],
        [4,  11.7, 18.8, 10.5],
        [5,  11.9, 17.6, 10.4],
        [6,   8.8, 13.6,  7.7],
        [7,   7.6, 12.3,  9.6],
        [8,  12.3, 29.2, 10.6],
        [9,  16.9, 42.9, 14.8],
        [10, 12.8, 30.9, 11.6],
        [11,  5.3,  7.9,  4.7],
        [12,  6.6,  8.4,  5.2],
        [13,  4.8,  6.3,  3.6],
        [14,  4.2,  6.2,  3.4]
This might just be down to the way in which I need to group or order the data in my SQL SELECT statement. But I can't seem to figure it out!! Is there a means by which I can group/order/add the data in the DataTable object to achieve what I need to do/see?

Any help would be very much appreciated! 

Thanks! Matt



Daniel LaLiberte

unread,
Jun 1, 2017, 10:08:30 AM6/1/17
to Google Visualization API
Hi Matt,

Currently, you will need to put each of your zones in a separate column.  I don't know if there is a way to do this with SQL, but you could do it in JavaScript with a simple loop over your data as you create another datatable.

At some point in the future, it would probably be convenient if we had a 'series' role, which you could apply to your zones column to have it automatically create the separate series for each zone.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/20a2e9aa-04e8-48d6-9a75-536221c457fc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Matt Kiteley

unread,
Jun 14, 2017, 7:04:29 PM6/14/17
to google-visua...@googlegroups.com
Thank you for your reply Daniel, 

I wonder if I could ask a favour? I've almost got my code dynamically adding to each series using loops/ifs etc. However I've got to the point where I can't figure out what is wrong with the chart javascript that's generated. Do you have any idea what's happening with the code below?

The error message I'm getting in the console is.... " Uncaught (in promise) Error: Row given with size different than 6 (the number of columns in the table)."

Here's the output generated by my php:

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {packages: ['corechart', 'line']});
google.charts.setOnLoadCallback(drawBasic);

var columnCount = 0;
function drawBasic() {
 
      var data = new google.visualization.DataTable();

      data.addColumn('string', 'tdate');
data.addColumn('string', 'ttime');
data.addColumn('number', 'Living Room Out Box');
data.addColumn('number', 'Living Room In Box');
data.addColumn('number', 'Future Bathroom');
data.addColumn('number', 'Outside Temperature');
var columnCount = data.getNumberOfColumns();
var columnArray = [];
for (i = 0; i < columnCount; i++) {
columnArray.push(data.getColumnLabel(i));
}
data.addRows([['2017-06-14','22:59:52',,,,18],['2017-06-14','23:00:23',,,25,],['2017-06-14','23:00:54',,,,18],['2017-06-14','23:01:24',,,25,],['2017-06-14','23:01:55',,,,18],['2017-06-14','23:02:26',,,25,],['2017-06-14','23:02:57',,,,18],['2017-06-14','23:03:28',,,25,],['2017-06-14','23:03:59',,,,18],['2017-06-14','23:04:30',,,25,],['2017-06-14','23:05:01',,,,18],['2017-06-14','23:05:31',,,25,],['2017-06-14','23:06:02',,,,18],['2017-06-14','23:06:33',,,25,],['2017-06-14','23:07:04',,,,18],['2017-06-14','23:07:35',,,25,],['2017-06-14','23:08:06',,,,18],['2017-06-14','23:08:37',,,25,],['2017-06-14','23:09:07',,,,18],['2017-06-14','23:09:38',,,25,],['2017-06-14','23:10:09',,,,18],['2017-06-14','23:10:40',,,25,],['2017-06-14','23:11:11',,,,18],['2017-06-14','23:11:42',,,25,],['2017-06-14','23:12:13',,,,18],['2017-06-14','23:12:44',,,25,],['2017-06-14','23:13:14',,,,18],['2017-06-14','23:13:45',,,25,],['2017-06-14','23:14:16',,,,18],['2017-06-14','23:14:47',,,25,],['2017-06-14','23:15:18',,,,18],['2017-06-14','23:15:49',,,25,],['2017-06-14','23:16:20',,,,18],['2017-06-14','23:16:51',,,25,],['2017-06-14','23:17:21',,,,18],['2017-06-14','23:17:52',,,25,],['2017-06-14','23:18:23',,,,18],['2017-06-14','23:18:54',,,25,],['2017-06-14','23:19:25',,,,18],['2017-06-14','23:19:56',,,25,],['2017-06-14','23:20:27',,,,18],['2017-06-14','23:20:58',,,25,],['2017-06-14','23:21:28',,,,18],['2017-06-14','23:21:59',,,25,],['2017-06-14','23:22:30',,,,18],['2017-06-14','23:23:01',,,25,],['2017-06-14','23:23:32',,,,18],['2017-06-14','23:24:03',,,25,],['2017-06-14','23:24:34',,,,18],['2017-06-14','23:25:04',,,25,],['2017-06-14','23:25:35',,,,18],['2017-06-14','23:26:06',,,25,],['2017-06-14','23:26:37',,,,18],['2017-06-14','23:27:08',,,25,],['2017-06-14','23:27:39',,,,18],['2017-06-14','23:28:10',,,25,],['2017-06-14','23:28:40',,,,18],['2017-06-14','23:29:11',,,25,],['2017-06-14','23:29:42',,,,18],['2017-06-14','23:30:13',,,25,],['2017-06-14','23:30:44',,,,18],['2017-06-14','23:31:15',,,25,],['2017-06-14','23:31:46',,,,18]]);
      var options = {
    curveType: 'function',
        hAxis: {
          title: 'Time'
        },
        vAxis: {
          title: 'Temperature'
        }
      };
      var myView = new google.visualization.DataView(data);
      var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
      
      chart.draw(data, options);
      //document.write("Column array value: " + columnArray[1]);
    }
   // 

    </script>
<div id="chart_div" style="width: 1500px; height: 800px"></div>


Thanks for any help at all!!! Matt

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/20a2e9aa-04e8-48d6-9a75-536221c457fc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/IB-y-DvK1g8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPBno-oXLjkt4CrfMw1QYSDw7iT3CFvRTtEuObEAjH9DA%40mail.gmail.com.

Daniel LaLiberte

unread,
Jun 14, 2017, 7:31:47 PM6/14/17
to Google Visualization API
I would guess the trailing commas on some of your rows are not doing what you expect, and therefore those rows are shorter than the required 6 columns.  Rather than leave the values undefined, use null instead, which should work the same as undefined in the chart.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPBno-oXLjkt4CrfMw1QYSDw7iT3CFvRTtEuObEAjH9DA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6aZjG%3D60LRXYSfQ9nwSKWO%3Ds1r-T55SFbY6pD5N2Xs_pA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Matt Kiteley

unread,
Jun 15, 2017, 2:49:25 AM6/15/17
to google-visua...@googlegroups.com
Thanks Daniel,

I did read about the trailing commas being a potential problem but couldn't think of a way around the issue as I will very often have null values but can't predict when they will occur in my dataset. Just so I can properly understand the point around using null values, would that mean changing the line below from:
['2017-06-14','23:00:23',,,25,]
to
['2017-06-14','23:00:23',,,25,,]

I.e. adding the final comma to properly close the line, denoting a null value?

Or is the suggestion that I need to do some something a little more fundamental around the way in which I'm building up the string so that I have tdate and ttime at the end of each line perhaps (which are not null in my db, as such I know to always be populated). Like this:

[,,,,'2017-06-14','23:00:23']

If I were to do the latter, would I still be able to set the axes of the graph to be temperature (wherever this may fall in the dataset) vs time?

Do appreciate your help!

Thanks, Matt




To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6aZjG%3D60LRXYSfQ9nwSKWO%3Ds1r-T55SFbY6pD5N2Xs_pA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/IB-y-DvK1g8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJP%3DVo6V-tzU2S2ZORQgcEoVbgezbmyB0%2B1ocH5r2_ONJg%40mail.gmail.com.

Daniel LaLiberte

unread,
Jun 15, 2017, 8:38:53 AM6/15/17
to Google Visualization API
The empty values between commas or before the first or after the last comma, represent undefined values.  A null value must be literally specified.
So change: ['2017-06-14','23:00:23',,,25,]
to ['2017-06-14', '23:00:23', null, null, 25, null]

Specifying dates in strings doesn't make them be dates, by the way.  You either new to construct the date with new Date(2017, 5, 14), or use the string notation: "Date(2017, 5, 14)".  Note that months start at 0, so 0 is January.


To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJP%3DVo6V-tzU2S2ZORQgcEoVbgezbmyB0%2B1ocH5r2_ONJg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6ZdU-2znAkGqqc9Bj4-eyvV6r8PTp-EXSybMet6W%2BLAsA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Matt Kiteley

unread,
Aug 18, 2017, 11:52:51 AM8/18/17
to google-visua...@googlegroups.com
Hey Daniel, 

Wanted to let you know, got it working! You were quite right about the need for a null and the way I was specifying dates. 

I now have the chart method creating meaningful graphs of the temperature data from my Raspberry Pi, pulled down via a Restful API service running on the Pi.

I do have one more question though, I'm trying to figure out why I'm only seeing points on the graph (image below) rather than a line being drawn between them. Is that a setting I have wrong in my method perhaps? I thought that specifying line type curve would do that... but apparently now.

Any help very much appreciated!

Thanks, Matt

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {packages: ['corechart', 'line']});
google.charts.setOnLoadCallback(drawBasic);

var columnCount = 0;
function drawBasic() {
var data = new google.visualization.DataTable();

data.addColumn('datetime', 'tdate');
data.addColumn('number', 'Future Bathroom');
data.addColumn('number', 'Outside Temperature');
var columnCount = data.getNumberOfColumns();
var columnArray = [];
for (i = 0; i < columnCount; i++) {
columnArray.push(data.getColumnLabel(i));
}
data.addRows([[new Date(2017,08,18,06,36,22),22.062,null],[new Date(2017,08,18,06,36,53),null,14.562],[new Date(2017,08,18,06,37,23),22.062,null],[new Date(2017,08,18,06,37,54),null,14.562],[new Date(2017,08,18,06,38,25),22.062,null],[new Date(2017,08,18,06,38,56),null,14.625],[new Date(2017,08,18,06,39,27),22.062,null],[new Date(2017,08,18,06,39,58),null,14.625],[new Date(2017,08,18,06,40,29),22.062,null],[new Date(2017,08,18,06,40,59),null,14.562],[new Date(2017,08,18,06,41,30),22.000,null],[new Date(2017,08,18,06,42,01),null,14.562],[new Date(2017,08,18,06,42,32),22.062,null],[new Date(2017,08,18,06,43,03),null,14.562],[new Date(2017,08,18,06,43,34),22.062,null],[new Date(2017,08,18,06,44,05),null,14.562],[new Date(2017,08,18,06,44,36),22.062,null],[new Date(2017,08,18,06,45,06),null,14.562],[new Date(2017,08,18,06,45,37),22.062,null],[new Date(2017,08,18,06,46,08),null,14.625],[new Date(2017,08,18,06,46,39),22.000,null],[new Date(2017,08,18,06,47,10),null,14.625],[new Date(2017,08,18,06,47,41),22.000,null],[new Date(2017,08,18,06,48,12),null,14.562],[new Date(2017,08,18,06,48,43),22.000,null],[new Date(2017,08,18,06,49,13),null,14.625],[new Date(2017,08,18,06,49,44),22.000,null],[new Date(2017,08,18,06,50,15),null,14.562],[new Date(2017,08,18,06,50,46),22.000,null],[new Date(2017,08,18,06,51,17),null,14.562],[new Date(2017,08,18,06,51,48),22.000,null],[new Date(2017,08,18,06,52,19),null,14.562],[new Date(2017,08,18,06,52,50),22.000,null],[new Date(2017,08,18,06,53,20),null,14.625],[new Date(2017,08,18,06,53,51),22.000,null],[new Date(2017,08,18,06,54,22),null,14.562],[new Date(2017,08,18,06,54,53),22.000,null],[new Date(2017,08,18,06,55,24),null,14.562],[new Date(2017,08,18,06,55,55),22.000,null],[new Date(2017,08,18,06,56,26),null,14.562],[new Date(2017,08,18,06,56,57),22.000,null],[new Date(2017,08,18,06,57,27),null,14.500],[new Date(2017,08,18,06,57,58),22.000,null],[new Date(2017,08,18,06,58,29),null,14.500],[new Date(2017,08,18,06,59,00),22.000,null],[new Date(2017,08,18,06,59,31),null,14.562],[new Date(2017,08,18,07,00,02),22.000,null],[new Date(2017,08,18,07,00,33),null,14.500],[new Date(2017,08,18,07,01,04),22.000,null],[new Date(2017,08,18,07,01,34),null,14.500],[new Date(2017,08,18,07,02,05),22.000,null],[new Date(2017,08,18,07,02,36),null,14.500],[new Date(2017,08,18,07,03,07),22.000,null],[new Date(2017,08,18,07,03,38),null,14.562],[new Date(2017,08,18,07,04,09),22.000,null],[new Date(2017,08,18,07,04,40),null,14.562],[new Date(2017,08,18,07,05,11),22.000,null],[new Date(2017,08,18,07,05,41),null,14.625],[new Date(2017,08,18,07,06,12),22.000,null],[new Date(2017,08,18,07,06,43),null,14.625],[new Date(2017,08,18,07,07,14),22.000,null],[new Date(2017,08,18,07,07,45),null,14.687],[new Date(2017,08,18,07,08,16),22.062,null],[new Date(2017,08,18,07,08,47),null,14.625],[new Date(2017,08,18,07,09,18),22.062,null],[new Date(2017,08,18,07,09,49),null,14.687],[new Date(2017,08,18,07,10,19),22.062,null],[new Date(2017,08,18,07,10,50),null,14.687],[new Date(2017,08,18,07,11,21),22.062,null],[new Date(2017,08,18,07,11,53),null,14.750],[new Date(2017,08,18,07,12,24),22.062,null],[new Date(2017,08,18,07,12,55),null,14.687],[new Date(2017,08,18,07,13,25),22.062,null],[new Date(2017,08,18,07,13,56),null,14.687],[new Date(2017,08,18,07,14,27),22.062,null],[new Date(2017,08,18,07,14,58),null,14.750],[new Date(2017,08,18,07,15,29),22.125,null],[new Date(2017,08,18,07,16,00),null,14.750],[new Date(2017,08,18,07,16,31),22.062,null],[new Date(2017,08,18,07,17,02),null,14.875],[new Date(2017,08,18,07,17,32),22.125,null],[new Date(2017,08,18,07,18,03),null,14.875],[new Date(2017,08,18,07,18,34),22.125,null],[new Date(2017,08,18,07,19,05),null,14.812],[new Date(2017,08,18,07,19,36),22.125,null],[new Date(2017,08,18,07,20,07),null,14.812],[new Date(2017,08,18,07,20,38),22.125,null],[new Date(2017,08,18,07,21,09),null,14.812],[new Date(2017,08,18,07,21,39),22.125,null],[new Date(2017,08,18,07,22,10),null,14.812],[new Date(2017,08,18,07,22,41),22.125,null],[new Date(2017,08,18,07,23,12),null,14.812],[new Date(2017,08,18,07,23,43),22.125,null],[new Date(2017,08,18,07,24,14),null,14.812],[new Date(2017,08,18,07,24,45),22.125,null],[new Date(2017,08,18,07,25,16),null,14.875],[new Date(2017,08,18,07,25,47),22.125,null],[new Date(2017,08,18,07,26,17),null,14.937],[new Date(2017,08,18,07,26,48),22.125,null],[new Date(2017,08,18,07,27,19),null,14.937],[new Date(2017,08,18,07,27,50),22.187,null],[new Date(2017,08,18,07,28,21),null,15.000],[new Date(2017,08,18,07,28,52),22.187,null],[new Date(2017,08,18,07,29,23),null,15.062],[new Date(2017,08,18,07,29,54),22.187,null],[new Date(2017,08,18,07,30,24),null,15.062],[new Date(2017,08,18,07,30,55),22.187,null],[new Date(2017,08,18,07,31,26),null,15.125],[new Date(2017,08,18,07,31,57),22.187,null],[new Date(2017,08,18,07,32,28),null,15.125],[new Date(2017,08,18,07,32,59),22.187,null],[new Date(2017,08,18,07,33,30),null,15.125],[new Date(2017,08,18,07,34,01),22.187,null],[new Date(2017,08,18,07,34,31),null,15.125],[new Date(2017,08,18,07,35,02),22.187,null],[new Date(2017,08,18,07,35,33),null,15.125],[new Date(2017,08,18,07,36,04),22.125,null],[new Date(2017,08,18,07,36,35),null,15.125],[new Date(2017,08,18,07,37,06),22.125,null],[new Date(2017,08,18,07,37,37),null,15.187],[new Date(2017,08,18,07,38,08),22.125,null],[new Date(2017,08,18,07,38,38),null,15.187],[new Date(2017,08,18,07,39,09),22.125,null],[new Date(2017,08,18,07,39,40),null,15.125],[new Date(2017,08,18,07,40,11),22.125,null],[new Date(2017,08,18,07,40,42),null,15.125],[new Date(2017,08,18,07,41,13),22.125,null],[new Date(2017,08,18,07,41,44),null,15.125],[new Date(2017,08,18,07,42,15),22.125,null],[new Date(2017,08,18,07,42,45),null,15.062],[new Date(2017,08,18,07,43,16),22.062,null],[new Date(2017,08,18,07,43,47),null,15.062],[new Date(2017,08,18,07,44,18),22.062,null],[new Date(2017,08,18,07,44,49),null,15.062],[new Date(2017,08,18,07,45,20),22.062,null],[new Date(2017,08,18,07,45,51),null,15.125],[new Date(2017,08,18,07,46,22),22.062,null],[new Date(2017,08,18,07,46,53),null,15.187],[new Date(2017,08,18,07,47,24),22.062,null],[new Date(2017,08,18,07,47,55),null,15.187],[new Date(2017,08,18,07,48,26),22.062,null],[new Date(2017,08,18,07,48,57),null,15.187],[new Date(2017,08,18,07,49,28),22.062,null],[new Date(2017,08,18,07,49,59),null,15.187],[new Date(2017,08,18,07,50,29),22.062,null],[new Date(2017,08,18,07,51,00),null,15.187],[new Date(2017,08,18,07,51,31),22.062,null],[new Date(2017,08,18,07,52,02),null,15.250],[new Date(2017,08,18,07,52,33),22.062,null],[new Date(2017,08,18,07,53,04),null,15.187],[new Date(2017,08,18,07,53,35),22.000,null],[new Date(2017,08,18,07,54,06),null,15.125],[new Date(2017,08,18,07,54,36),22.000,null],[new Date(2017,08,18,07,55,07),null,15.125],[new Date(2017,08,18,07,55,38),22.000,null],[new Date(2017,08,18,07,56,09),null,15.125],[new Date(2017,08,18,07,56,40),22.000,null],[new Date(2017,08,18,07,57,11),null,15.125],[new Date(2017,08,18,07,57,42),22.000,null],[new Date(2017,08,18,07,58,12),null,15.125],[new Date(2017,08,18,07,58,43),22.000,null],[new Date(2017,08,18,07,59,14),null,15.125],[new Date(2017,08,18,07,59,45),22.062,null],[new Date(2017,08,18,08,00,16),null,15.187],[new Date(2017,08,18,08,00,47),22.062,null],[new Date(2017,08,18,08,01,18),null,15.250],[new Date(2017,08,18,08,01,49),22.062,null],[new Date(2017,08,18,08,02,19),null,15.250],[new Date(2017,08,18,08,02,50),22.062,null],[new Date(2017,08,18,08,03,21),null,15.250],[new Date(2017,08,18,08,03,52),22.062,null],[new Date(2017,08,18,08,04,23),null,15.250],[new Date(2017,08,18,08,04,54),22.062,null],[new Date(2017,08,18,08,05,25),null,15.250],[new Date(2017,08,18,08,05,56),22.062,null],[new Date(2017,08,18,08,06,27),null,15.250],[new Date(2017,08,18,08,06,57),22.062,null],[new Date(2017,08,18,08,07,28),null,15.250],[new Date(2017,08,18,08,07,59),22.062,null],[new Date(2017,08,18,08,08,30),null,15.312],[new Date(2017,08,18,08,09,01),22.125,null],[new Date(2017,08,18,08,09,32),null,15.500],[new Date(2017,08,18,08,10,03),22.125,null],[new Date(2017,08,18,08,10,34),null,15.500],[new Date(2017,08,18,08,11,04),22.125,null],[new Date(2017,08,18,08,11,35),null,15.562],[new Date(2017,08,18,08,12,06),22.125,null],[new Date(2017,08,18,08,12,37),null,15.625],[new Date(2017,08,18,08,13,08),22.187,null],[new Date(2017,08,18,08,13,39),null,15.687],[new Date(2017,08,18,08,14,10),22.187,null],[new Date(2017,08,18,08,14,41),null,15.750],[new Date(2017,08,18,08,15,11),22.187,null],[new Date(2017,08,18,08,15,42),null,15.687],[new Date(2017,08,18,08,16,13),22.125,null],[new Date(2017,08,18,08,16,44),null,15.625],[new Date(2017,08,18,08,17,15),22.125,null],[new Date(2017,08,18,08,17,46),null,15.625],[new Date(2017,08,18,08,18,17),22.125,null],[new Date(2017,08,18,08,18,48),null,15.562],[new Date(2017,08,18,08,19,18),22.125,null],[new Date(2017,08,18,08,19,49),null,15.500],[new Date(2017,08,18,08,20,20),22.125,null],[new Date(2017,08,18,08,20,51),null,15.625],[new Date(2017,08,18,08,21,22),22.125,null],[new Date(2017,08,18,08,21,53),null,15.750],[new Date(2017,08,18,08,22,24),22.125,null],[new Date(2017,08,18,08,22,55),null,15.812],[new Date(2017,08,18,08,23,25),22.187,null],[new Date(2017,08,18,08,23,56),null,15.875],[new Date(2017,08,18,08,24,27),22.187,null],[new Date(2017,08,18,08,24,58),null,16.000],[new Date(2017,08,18,08,25,29),22.187,null],[new Date(2017,08,18,08,26,00),null,15.812],[new Date(2017,08,18,08,26,31),22.187,null],[new Date(2017,08,18,08,27,02),null,15.875],[new Date(2017,08,18,08,27,32),22.187,null],[new Date(2017,08,18,08,28,03),null,15.875],[new Date(2017,08,18,08,28,34),22.187,null],[new Date(2017,08,18,08,29,05),null,15.875],[new Date(2017,08,18,08,29,36),22.187,null],[new Date(2017,08,18,08,30,07),null,15.937],[new Date(2017,08,18,08,30,38),22.187,null],[new Date(2017,08,18,08,31,09),null,16.125],[new Date(2017,08,18,08,31,39),22.250,null],[new Date(2017,08,18,08,32,10),null,16.187],[new Date(2017,08,18,08,32,41),22.250,null],[new Date(2017,08,18,08,33,12),null,16.312],[new Date(2017,08,18,08,33,43),22.250,null],[new Date(2017,08,18,08,34,14),null,16.375],[new Date(2017,08,18,08,34,45),22.312,null],[new Date(2017,08,18,08,35,16),null,16.500],[new Date(2017,08,18,08,35,46),22.312,null],[new Date(2017,08,18,08,36,17),null,16.375],[new Date(2017,08,18,08,36,48),22.312,null],[new Date(2017,08,18,08,37,19),null,16.500],[new Date(2017,08,18,08,37,50),22.312,null],[new Date(2017,08,18,08,38,21),null,16.687],[new Date(2017,08,18,08,38,52),22.312,null],[new Date(2017,08,18,08,39,23),null,16.625],[new Date(2017,08,18,08,39,53),22.312,null],[new Date(2017,08,18,08,40,24),null,16.750],[new Date(2017,08,18,08,40,55),22.375,null],[new Date(2017,08,18,08,41,26),null,16.937],[new Date(2017,08,18,08,41,57),22.375,null],[new Date(2017,08,18,08,42,28),null,16.937],[new Date(2017,08,18,08,42,59),22.375,null],[new Date(2017,08,18,08,43,30),null,17.125],[new Date(2017,08,18,08,44,00),22.375,null],[new Date(2017,08,18,08,44,31),null,17.250],[new Date(2017,08,18,08,45,02),22.437,null],[new Date(2017,08,18,08,45,33),null,17.250],[new Date(2017,08,18,08,46,04),22.437,null],[new Date(2017,08,18,08,46,35),null,17.187],[new Date(2017,08,18,08,47,06),22.437,null],[new Date(2017,08,18,08,47,37),null,17.125],[new Date(2017,08,18,08,48,07),22.437,null],[new Date(2017,08,18,08,48,38),null,17.187],[new Date(2017,08,18,08,49,09),22.437,null],[new Date(2017,08,18,08,49,40),null,17.187],[new Date(2017,08,18,08,50,11),22.437,null],[new Date(2017,08,18,08,50,42),null,17.250],[new Date(2017,08,18,08,51,13),22.437,null],[new Date(2017,08,18,08,51,44),null,17.187],[new Date(2017,08,18,08,52,14),22.437,null],[new Date(2017,08,18,08,52,45),null,17.125],[new Date(2017,08,18,08,53,16),22.437,null],[new Date(2017,08,18,08,53,47),null,17.250],[new Date(2017,08,18,08,54,18),22.437,null],[new Date(2017,08,18,08,54,49),null,17.375],[new Date(2017,08,18,08,55,20),22.437,null],[new Date(2017,08,18,08,55,51),null,17.312],[new Date(2017,08,18,08,56,21),22.437,null],[new Date(2017,08,18,08,56,52),null,17.312],[new Date(2017,08,18,08,57,23),22.437,null],[new Date(2017,08,18,08,57,54),null,17.375],[new Date(2017,08,18,08,58,25),22.500,null],[new Date(2017,08,18,08,58,56),null,17.437],[new Date(2017,08,18,08,59,27),22.500,null],[new Date(2017,08,18,08,59,58),null,17.562],[new Date(2017,08,18,09,00,28),22.500,null],[new Date(2017,08,18,09,00,59),null,17.562],[new Date(2017,08,18,09,01,30),22.500,null],[new Date(2017,08,18,09,02,01),null,17.625],[new Date(2017,08,18,09,02,32),22.500,null],[new Date(2017,08,18,09,03,03),null,17.562],[new Date(2017,08,18,09,03,34),22.500,null],[new Date(2017,08,18,09,04,05),null,17.625],[new Date(2017,08,18,09,04,35),22.500,null],[new Date(2017,08,18,09,05,06),null,17.750],[new Date(2017,08,18,09,05,37),22.562,null],[new Date(2017,08,18,09,06,08),null,18.000],[new Date(2017,08,18,09,06,39),22.562,null],[new Date(2017,08,18,09,07,10),null,17.625],[new Date(2017,08,18,09,07,41),22.500,null],[new Date(2017,08,18,09,08,12),null,17.562],[new Date(2017,08,18,09,08,42),22.500,null],[new Date(2017,08,18,09,09,13),null,17.562],[new Date(2017,08,18,09,09,44),22.500,null],[new Date(2017,08,18,09,10,15),null,17.687],[new Date(2017,08,18,09,10,46),22.500,null],[new Date(2017,08,18,09,11,17),null,17.812],[new Date(2017,08,18,09,11,48),22.562,null],[new Date(2017,08,18,09,12,19),null,18.062],[new Date(2017,08,18,09,12,49),22.500,null],[new Date(2017,08,18,09,13,20),null,18.250],[new Date(2017,08,18,09,13,51),22.562,null],[new Date(2017,08,18,09,14,22),null,18.375],[new Date(2017,08,18,09,14,53),22.562,null],[new Date(2017,08,18,09,15,24),null,18.375],[new Date(2017,08,18,09,15,55),22.562,null],[new Date(2017,08,18,09,16,26),null,18.312],[new Date(2017,08,18,09,16,56),22.562,null],[new Date(2017,08,18,09,17,27),null,18.500],[new Date(2017,08,18,09,17,58),22.562,null],[new Date(2017,08,18,09,19,00),22.625,null],[new Date(2017,08,18,09,19,31),null,18.562],[new Date(2017,08,18,09,20,02),22.562,null],[new Date(2017,08,18,09,20,33),null,18.500],[new Date(2017,08,18,09,21,03),22.562,null],[new Date(2017,08,18,09,21,34),null,18.375],[new Date(2017,08,18,09,22,05),22.562,null],[new Date(2017,08,18,09,22,36),null,18.312],[new Date(2017,08,18,09,23,07),22.562,null],[new Date(2017,08,18,09,23,38),null,18.062],[new Date(2017,08,18,09,24,09),22.500,null],[new Date(2017,08,18,09,24,40),null,18.000],[new Date(2017,08,18,09,25,10),22.500,null],[new Date(2017,08,18,09,25,41),null,18.062],[new Date(2017,08,18,09,26,12),22.562,null],[new Date(2017,08,18,09,26,43),null,18.125],[new Date(2017,08,18,09,27,14),22.562,null],[new Date(2017,08,18,09,27,45),null,18.125],[new Date(2017,08,18,09,28,16),22.562,null],[new Date(2017,08,18,09,28,46),null,18.250],[new Date(2017,08,18,09,29,17),22.562,null],[new Date(2017,08,18,09,29,48),null,18.250],[new Date(2017,08,18,09,30,19),22.500,null],[new Date(2017,08,18,09,30,50),null,18.312],[new Date(2017,08,18,09,31,21),22.562,null],[new Date(2017,08,18,09,31,52),null,18.312],[new Date(2017,08,18,09,32,23),22.562,null],[new Date(2017,08,18,09,32,53),null,18.375],[new Date(2017,08,18,09,33,24),22.562,null],[new Date(2017,08,18,09,33,55),null,18.625],[new Date(2017,08,18,09,34,26),22.625,null],[new Date(2017,08,18,09,34,57),null,18.625],[new Date(2017,08,18,09,35,28),22.625,null],[new Date(2017,08,18,09,35,59),null,18.625],[new Date(2017,08,18,09,36,29),22.625,null],[new Date(2017,08,18,09,37,00),null,18.687],[new Date(2017,08,18,09,37,31),22.625,null],[new Date(2017,08,18,09,38,02),null,18.812],[new Date(2017,08,18,09,38,33),22.687,null],[new Date(2017,08,18,09,39,04),null,19.062],[new Date(2017,08,18,09,39,35),22.687,null],[new Date(2017,08,18,09,40,06),null,19.062],[new Date(2017,08,18,09,40,36),22.687,null],[new Date(2017,08,18,09,41,07),null,19.000],[new Date(2017,08,18,09,41,38),22.687,null],[new Date(2017,08,18,09,42,09),null,18.875],[new Date(2017,08,18,09,42,40),22.687,null],[new Date(2017,08,18,09,43,11),null,18.750],[new Date(2017,08,18,09,43,42),22.687,null],[new Date(2017,08,18,09,44,13),null,18.312],[new Date(2017,08,18,09,44,44),22.687,null],[new Date(2017,08,18,09,45,14),null,18.312],[new Date(2017,08,18,09,45,45),22.625,null],[new Date(2017,08,18,09,46,16),null,18.375],[new Date(2017,08,18,09,46,47),22.625,null],[new Date(2017,08,18,09,47,18),null,18.312],[new Date(2017,08,18,09,47,49),22.625,null],[new Date(2017,08,18,09,48,20),null,18.000],[new Date(2017,08,18,09,48,51),22.625,null],[new Date(2017,08,18,09,49,21),null,18.062],[new Date(2017,08,18,09,49,52),22.562,null],[new Date(2017,08,18,09,50,23),null,18.062],[new Date(2017,08,18,09,50,54),22.562,null],[new Date(2017,08,18,09,51,25),null,17.875],[new Date(2017,08,18,09,51,56),22.562,null],[new Date(2017,08,18,09,52,27),null,18.000],[new Date(2017,08,18,09,52,57),22.562,null],[new Date(2017,08,18,09,53,28),null,18.000],[new Date(2017,08,18,09,53,59),22.562,null],[new Date(2017,08,18,09,54,30),null,17.875],[new Date(2017,08,18,09,55,01),22.562,null],[new Date(2017,08,18,09,55,32),null,17.750],[new Date(2017,08,18,09,56,03),22.562,null],[new Date(2017,08,18,09,56,34),null,18.062],[new Date(2017,08,18,09,57,04),22.562,null],[new Date(2017,08,18,09,57,35),null,18.125],[new Date(2017,08,18,09,58,06),22.625,null],[new Date(2017,08,18,09,58,37),null,18.250],[new Date(2017,08,18,09,59,08),22.625,null],[new Date(2017,08,18,09,59,39),null,18.500],[new Date(2017,08,18,10,00,10),22.687,null],[new Date(2017,08,18,10,00,41),null,18.500],[new Date(2017,08,18,10,01,12),22.687,null],[new Date(2017,08,18,10,01,42),null,18.687],[new Date(2017,08,18,10,02,13),22.687,null],[new Date(2017,08,18,10,02,44),null,18.562],[new Date(2017,08,18,10,03,15),22.687,null],[new Date(2017,08,18,10,03,46),null,18.312],[new Date(2017,08,18,10,04,17),22.687,null],[new Date(2017,08,18,10,04,48),null,18.437],[new Date(2017,08,18,10,05,19),22.687,null],[new Date(2017,08,18,10,05,49),null,18.562],[new Date(2017,08,18,10,06,20),22.687,null],[new Date(2017,08,18,10,06,51),null,18.437],[new Date(2017,08,18,10,07,22),22.687,null],[new Date(2017,08,18,10,07,53),null,18.187],[new Date(2017,08,18,10,08,24),22.687,null],[new Date(2017,08,18,10,08,55),null,18.312],[new Date(2017,08,18,10,09,26),22.687,null],[new Date(2017,08,18,10,09,56),null,18.312],[new Date(2017,08,18,10,10,27),22.687,null],[new Date(2017,08,18,10,10,58),null,18.625],[new Date(2017,08,18,10,11,29),22.750,null],[new Date(2017,08,18,10,12,00),null,19.062],[new Date(2017,08,18,10,12,31),22.750,null],[new Date(2017,08,18,10,13,02),null,18.937],[new Date(2017,08,18,10,13,33),22.812,null],[new Date(2017,08,18,10,14,03),null,19.000],[new Date(2017,08,18,10,14,34),22.812,null],[new Date(2017,08,18,10,15,05),null,19.187],[new Date(2017,08,18,10,15,36),22.812,null],[new Date(2017,08,18,10,16,07),null,19.187],[new Date(2017,08,18,10,16,38),22.875,null],[new Date(2017,08,18,10,17,09),null,19.187],[new Date(2017,08,18,10,17,40),22.875,null],[new Date(2017,08,18,10,18,10),null,19.375],[new Date(2017,08,18,10,18,41),22.875,null],[new Date(2017,08,18,10,19,12),null,19.687],[new Date(2017,08,18,10,19,43),22.937,null],[new Date(2017,08,18,10,20,14),null,19.500],[new Date(2017,08,18,10,20,45),22.937,null],[new Date(2017,08,18,10,21,16),null,19.625],[new Date(2017,08,18,10,21,46),22.937,null],[new Date(2017,08,18,10,22,17),null,19.625],[new Date(2017,08,18,10,22,48),22.937,null],[new Date(2017,08,18,10,23,19),null,19.500],[new Date(2017,08,18,10,23,51),23.000,null],[new Date(2017,08,18,10,24,22),null,19.625],[new Date(2017,08,18,10,24,53),23.000,null],[new Date(2017,08,18,10,25,23),null,19.500],[new Date(2017,08,18,10,25,54),23.000,null],[new Date(2017,08,18,10,26,25),null,19.812],[new Date(2017,08,18,10,26,56),23.000,null],[new Date(2017,08,18,10,27,27),null,19.687],[new Date(2017,08,18,10,27,58),23.000,null],[new Date(2017,08,18,10,28,29),null,20.000],[new Date(2017,08,18,10,29,00),23.000,null],[new Date(2017,08,18,10,29,30),null,20.187],[new Date(2017,08,18,10,30,01),23.000,null],[new Date(2017,08,18,10,30,32),null,20.312],[new Date(2017,08,18,10,31,04),23.000,null],[new Date(2017,08,18,10,31,35),null,20.375],[new Date(2017,08,18,10,32,06),23.000,null],[new Date(2017,08,18,10,32,36),null,20.375],[new Date(2017,08,18,10,33,07),23.000,null],[new Date(2017,08,18,10,33,38),null,19.875],[new Date(2017,08,18,10,34,09),23.000,null],[new Date(2017,08,18,10,34,40),null,19.687],[new Date(2017,08,18,10,35,11),23.000,null],[new Date(2017,08,18,10,35,42),null,19.687],[new Date(2017,08,18,10,36,13),23.000,null],[new Date(2017,08,18,10,36,43),null,19.750],[new Date(2017,08,18,10,37,14),23.000,null],[new Date(2017,08,18,10,37,45),null,19.750],[new Date(2017,08,18,10,38,16),23.000,null],[new Date(2017,08,18,10,38,47),null,19.937],[new Date(2017,08,18,10,39,18),23.062,null],[new Date(2017,08,18,10,39,49),null,20.062],[new Date(2017,08,18,10,40,20),23.062,null],[new Date(2017,08,18,10,40,50),null,20.812],[new Date(2017,08,18,10,41,21),23.062,null],[new Date(2017,08,18,10,41,52),null,21.875],[new Date(2017,08,18,10,42,23),23.062,null],[new Date(2017,08,18,10,42,54),null,22.437],[new Date(2017,08,18,10,43,25),23.062,null],[new Date(2017,08,18,10,43,56),null,22.687],[new Date(2017,08,18,10,44,26),23.062,null],[new Date(2017,08,18,10,44,57),null,22.250],[new Date(2017,08,18,10,45,28),23.125,null],[new Date(2017,08,18,10,45,59),null,23.000],[new Date(2017,08,18,10,46,30),23.125,null],[new Date(2017,08,18,10,47,01),null,22.687],[new Date(2017,08,18,10,47,32),23.125,null],[new Date(2017,08,18,10,48,03),null,22.812],[new Date(2017,08,18,10,48,33),23.187,null],[new Date(2017,08,18,10,49,04),null,23.187],[new Date(2017,08,18,10,49,35),23.187,null],[new Date(2017,08,18,10,50,06),null,22.500],[new Date(2017,08,18,10,50,37),23.187,null],[new Date(2017,08,18,10,51,08),null,22.125],[new Date(2017,08,18,10,51,39),23.125,null],[new Date(2017,08,18,10,52,10),null,22.937],[new Date(2017,08,18,10,52,40),23.187,null],[new Date(2017,08,18,10,53,11),null,22.875],[new Date(2017,08,18,10,53,42),23.187,null],[new Date(2017,08,18,10,54,13),null,21.875],[new Date(2017,08,18,10,54,44),23.125,null],[new Date(2017,08,18,10,55,15),null,20.937],[new Date(2017,08,18,10,55,46),23.062,null],[new Date(2017,08,18,10,56,16),null,22.062],[new Date(2017,08,18,10,56,47),23.062,null],[new Date(2017,08,18,10,57,18),null,23.250],[new Date(2017,08,18,10,57,49),23.125,null],[new Date(2017,08,18,10,58,20),null,23.437],[new Date(2017,08,18,10,58,51),23.125,null],[new Date(2017,08,18,10,59,22),null,23.937],[new Date(2017,08,18,10,59,53),23.125,null],[new Date(2017,08,18,11,00,23),null,24.250],[new Date(2017,08,18,11,00,54),23.187,null],[new Date(2017,08,18,11,01,25),null,24.500],[new Date(2017,08,18,11,01,56),23.187,null],[new Date(2017,08,18,11,02,27),null,24.250],[new Date(2017,08,18,11,02,58),23.187,null],[new Date(2017,08,18,11,03,29),null,24.625],[new Date(2017,08,18,11,03,59),23.250,null],[new Date(2017,08,18,11,04,30),null,24.750],[new Date(2017,08,18,11,05,01),23.187,null],[new Date(2017,08,18,11,05,32),null,24.062],[new Date(2017,08,18,11,06,03),23.187,null],[new Date(2017,08,18,11,06,34),null,24.062],[new Date(2017,08,18,11,07,05),23.250,null],[new Date(2017,08,18,11,07,35),null,24.062],[new Date(2017,08,18,11,08,06),23.250,null],[new Date(2017,08,18,11,08,37),null,24.625],[new Date(2017,08,18,11,09,08),23.250,null],[new Date(2017,08,18,11,09,39),null,25.062],[new Date(2017,08,18,11,10,10),23.312,null],[new Date(2017,08,18,11,10,41),null,25.250],[new Date(2017,08,18,11,11,11),23.312,null],[new Date(2017,08,18,11,11,42),null,23.687],[new Date(2017,08,18,11,12,13),23.250,null],[new Date(2017,08,18,11,12,44),null,23.312],[new Date(2017,08,18,11,13,15),23.250,null],[new Date(2017,08,18,11,13,46),null,23.375],[new Date(2017,08,18,11,14,17),23.250,null],[new Date(2017,08,18,11,14,48),null,23.187],[new Date(2017,08,18,11,15,18),23.250,null],[new Date(2017,08,18,11,15,49),null,23.250],[new Date(2017,08,18,11,16,20),23.250,null],[new Date(2017,08,18,11,16,51),null,22.250],[new Date(2017,08,18,11,17,22),23.187,null],[new Date(2017,08,18,11,17,53),null,22.750],[new Date(2017,08,18,11,18,24),23.187,null],[new Date(2017,08,18,11,18,54),null,22.000],[new Date(2017,08,18,11,19,25),23.125,null],[new Date(2017,08,18,11,20,27),23.125,null],[new Date(2017,08,18,11,20,58),null,22.437],[new Date(2017,08,18,11,21,29),23.125,null],[new Date(2017,08,18,11,22,00),null,23.000],[new Date(2017,08,18,11,22,31),23.187,null],[new Date(2017,08,18,11,23,01),null,23.625],[new Date(2017,08,18,11,23,32),23.187,null],[new Date(2017,08,18,11,24,03),null,24.000],[new Date(2017,08,18,11,24,34),23.250,null],[new Date(2017,08,18,11,25,05),null,24.500],[new Date(2017,08,18,11,25,36),23.250,null],[new Date(2017,08,18,11,26,07),null,24.937],[new Date(2017,08,18,11,26,38),23.250,null],[new Date(2017,08,18,11,27,08),null,25.375],[new Date(2017,08,18,11,27,39),23.312,null],[new Date(2017,08,18,11,28,10),null,25.000],[new Date(2017,08,18,11,28,41),23.312,null],[new Date(2017,08,18,11,29,13),null,25.562],[new Date(2017,08,18,11,29,44),23.312,null],[new Date(2017,08,18,11,30,14),null,25.437],[new Date(2017,08,18,11,30,45),23.312,null],[new Date(2017,08,18,11,31,16),null,25.375],[new Date(2017,08,18,11,31,47),23.312,null],[new Date(2017,08,18,11,32,18),null,25.312],[new Date(2017,08,18,11,32,49),23.312,null],[new Date(2017,08,18,11,33,20),null,25.562],[new Date(2017,08,18,11,33,50),23.312,null],[new Date(2017,08,18,11,34,21),null,26.500],[new Date(2017,08,18,11,34,52),23.375,null],[new Date(2017,08,18,11,35,23),null,26.875],[new Date(2017,08,18,11,35,54),23.375,null],[new Date(2017,08,18,11,36,25),null,25.812],[new Date(2017,08,18,11,36,56),23.375,null],[new Date(2017,08,18,11,37,27),null,25.187],[new Date(2017,08,18,11,37,57),23.375,null],[new Date(2017,08,18,11,38,28),null,25.750],[new Date(2017,08,18,11,38,59),23.312,null],[new Date(2017,08,18,11,39,30),null,26.000],[new Date(2017,08,18,11,40,01),23.375,null],[new Date(2017,08,18,11,40,32),null,25.937],[new Date(2017,08,18,11,41,03),23.375,null],[new Date(2017,08,18,11,41,34),null,26.312],[new Date(2017,08,18,11,42,04),23.375,null],[new Date(2017,08,18,11,42,35),null,26.812],[new Date(2017,08,18,11,43,06),23.375,null],[new Date(2017,08,18,11,43,37),null,25.437],[new Date(2017,08,18,11,44,08),23.312,null],[new Date(2017,08,18,11,44,39),null,23.625],[new Date(2017,08,18,11,45,10),23.312,null],[new Date(2017,08,18,11,45,41),null,22.875],[new Date(2017,08,18,11,46,11),23.250,null],[new Date(2017,08,18,11,46,42),null,22.312],[new Date(2017,08,18,11,47,13),23.250,null],[new Date(2017,08,18,11,47,44),null,23.187],[new Date(2017,08,18,11,48,15),23.250,null],[new Date(2017,08,18,11,48,46),null,23.750],[new Date(2017,08,18,11,49,17),23.250,null],[new Date(2017,08,18,11,49,47),null,24.937],[new Date(2017,08,18,11,50,18),23.250,null],[new Date(2017,08,18,11,50,49),null,23.875],[new Date(2017,08,18,11,51,20),23.187,null],[new Date(2017,08,18,11,51,51),null,22.500],[new Date(2017,08,18,11,52,22),23.187,null],[new Date(2017,08,18,11,52,53),null,23.562],[new Date(2017,08,18,11,53,24),23.187,null],[new Date(2017,08,18,11,53,55),null,24.875],[new Date(2017,08,18,11,54,25),23.187,null],[new Date(2017,08,18,11,54,56),null,24.000],[new Date(2017,08,18,11,55,27),23.187,null],[new Date(2017,08,18,11,55,58),null,24.062],[new Date(2017,08,18,11,56,29),23.187,null],[new Date(2017,08,18,11,57,00),null,23.937],[new Date(2017,08,18,11,57,31),23.187,null],[new Date(2017,08,18,11,58,01),null,23.812],[new Date(2017,08,18,11,58,32),23.187,null],[new Date(2017,08,18,11,59,03),null,24.250],[new Date(2017,08,18,11,59,34),23.187,null],[new Date(2017,08,18,12,00,05),null,24.687],[new Date(2017,08,18,12,00,36),23.187,null],[new Date(2017,08,18,12,01,07),null,25.687],[new Date(2017,08,18,12,01,38),23.187,null],[new Date(2017,08,18,12,02,08),null,25.125],[new Date(2017,08,18,12,02,39),23.187,null],[new Date(2017,08,18,12,03,10),null,24.687],[new Date(2017,08,18,12,03,41),23.250,null],[new Date(2017,08,18,12,04,12),null,24.875],[new Date(2017,08,18,12,04,43),23.187,null],[new Date(2017,08,18,12,05,14),null,23.750],[new Date(2017,08,18,12,05,45),23.187,null],[new Date(2017,08,18,12,06,15),null,22.750],[new Date(2017,08,18,12,06,46),23.125,null],[new Date(2017,08,18,12,07,17),null,22.250],[new Date(2017,08,18,12,07,48),23.125,null],[new Date(2017,08,18,12,08,19),null,22.250],[new Date(2017,08,18,12,08,50),23.062,null],[new Date(2017,08,18,12,09,21),null,21.687],[new Date(2017,08,18,12,09,52),23.062,null],[new Date(2017,08,18,12,10,22),null,21.125],[new Date(2017,08,18,12,10,53),23.000,null],[new Date(2017,08,18,12,11,24),null,21.062],[new Date(2017,08,18,12,11,55),23.000,null],[new Date(2017,08,18,12,12,26),null,20.875],[new Date(2017,08,18,12,12,57),23.000,null],[new Date(2017,08,18,12,13,28),null,20.625],[new Date(2017,08,18,12,13,59),23.000,null],[new Date(2017,08,18,12,14,29),null,20.937],[new Date(2017,08,18,12,15,00),23.000,null],[new Date(2017,08,18,12,15,31),null,20.750],[new Date(2017,08,18,12,16,02),22.937,null],[new Date(2017,08,18,12,16,33),null,20.937],[new Date(2017,08,18,12,17,04),22.937,null],[new Date(2017,08,18,12,17,35),null,20.937],[new Date(2017,08,18,12,18,06),22.937,null],[new Date(2017,08,18,12,18,36),null,21.062],[new Date(2017,08,18,12,19,07),22.937,null],[new Date(2017,08,18,12,19,38),null,21.062],[new Date(2017,08,18,12,20,09),22.937,null],[new Date(2017,08,18,12,20,40),null,20.875],[new Date(2017,08,18,12,21,11),22.937,null],[new Date(2017,08,18,12,21,42),null,22.250],[new Date(2017,08,18,12,22,13),22.937,null],[new Date(2017,08,18,12,22,43),null,21.812],[new Date(2017,08,18,12,23,14),23.000,null],[new Date(2017,08,18,12,23,45),null,23.500],[new Date(2017,08,18,12,24,16),23.000,null],[new Date(2017,08,18,12,24,47),null,24.937],[new Date(2017,08,18,12,25,18),23.062,null],[new Date(2017,08,18,12,25,49),null,24.250],[new Date(2017,08,18,12,26,20),23.062,null],[new Date(2017,08,18,12,26,50),null,23.875],[new Date(2017,08,18,12,27,21),23.062,null],[new Date(2017,08,18,12,27,52),null,23.875],[new Date(2017,08,18,12,28,23),23.062,null],[new Date(2017,08,18,12,28,54),null,22.750],[new Date(2017,08,18,12,29,25),23.062,null],[new Date(2017,08,18,12,29,56),null,23.500],[new Date(2017,08,18,12,30,27),23.062,null],[new Date(2017,08,18,12,30,57),null,23.187],[new Date(2017,08,18,12,31,28),23.062,null],[new Date(2017,08,18,12,31,59),null,22.562],[new Date(2017,08,18,12,32,30),23.062,null],[new Date(2017,08,18,12,33,01),null,22.062],[new Date(2017,08,18,12,33,32),23.062,null],[new Date(2017,08,18,12,34,03),null,21.437],[new Date(2017,08,18,12,34,34),23.000,null],[new Date(2017,08,18,12,35,04),null,21.187],[new Date(2017,08,18,12,35,35),23.000,null],[new Date(2017,08,18,12,36,06),null,21.125],[new Date(2017,08,18,12,36,37),23.000,null],[new Date(2017,08,18,12,37,08),null,21.000],[new Date(2017,08,18,12,37,39),23.000,null],[new Date(2017,08,18,12,38,10),null,21.000],[new Date(2017,08,18,12,38,41),23.000,null],[new Date(2017,08,18,12,39,11),null,20.687],[new Date(2017,08,18,12,39,42),22.937,null],[new Date(2017,08,18,12,40,13),null,20.687],[new Date(2017,08,18,12,40,44),22.937,null],[new Date(2017,08,18,12,41,15),null,20.812],[new Date(2017,08,18,12,41,46),22.937,null],[new Date(2017,08,18,12,42,17),null,20.625],[new Date(2017,08,18,12,42,48),22.937,null],[new Date(2017,08,18,12,43,18),null,19.687],[new Date(2017,08,18,12,43,49),22.937,null],[new Date(2017,08,18,12,44,20),null,19.312],[new Date(2017,08,18,12,44,51),22.937,null],[new Date(2017,08,18,12,45,22),null,19.312],[new Date(2017,08,18,12,45,53),22.875,null],[new Date(2017,08,18,12,46,24),null,18.500],[new Date(2017,08,18,12,46,55),22.875,null],[new Date(2017,08,18,12,47,26),null,18.187],[new Date(2017,08,18,12,47,56),22.875,null],[new Date(2017,08,18,12,48,27),null,17.312],[new Date(2017,08,18,12,48,58),22.875,null],[new Date(2017,08,18,12,49,29),null,17.062],[new Date(2017,08,18,12,50,00),22.812,null],[new Date(2017,08,18,12,50,31),null,16.750],[new Date(2017,08,18,12,51,02),22.812,null],[new Date(2017,08,18,12,51,33),null,16.250],[new Date(2017,08,18,12,52,04),22.812,null],[new Date(2017,08,18,12,52,34),null,16.000],[new Date(2017,08,18,12,53,05),22.812,null],[new Date(2017,08,18,12,53,36),null,15.875],[new Date(2017,08,18,12,54,07),22.812,null],[new Date(2017,08,18,12,54,38),null,15.875],[new Date(2017,08,18,12,55,09),22.812,null],[new Date(2017,08,18,12,55,40),null,16.187],[new Date(2017,08,18,12,56,11),22.812,null],[new Date(2017,08,18,12,56,42),null,16.250],[new Date(2017,08,18,12,57,13),22.812,null],[new Date(2017,08,18,12,58,15),22.812,null],[new Date(2017,08,18,12,58,46),null,16.625],[new Date(2017,08,18,12,59,17),22.812,null],[new Date(2017,08,18,12,59,48),null,16.687],[new Date(2017,08,18,13,00,18),22.875,null],[new Date(2017,08,18,13,00,49),null,17.312],[new Date(2017,08,18,13,01,20),22.875,null],[new Date(2017,08,18,13,01,51),null,17.875],[new Date(2017,08,18,13,02,22),22.875,null],[new Date(2017,08,18,13,02,53),null,18.187],[new Date(2017,08,18,13,03,24),22.875,null],[new Date(2017,08,18,13,03,54),null,19.312],[new Date(2017,08,18,13,04,25),23.000,null],[new Date(2017,08,18,13,04,56),null,21.000],[new Date(2017,08,18,13,05,27),23.000,null],[new Date(2017,08,18,13,05,58),null,22.125],[new Date(2017,08,18,13,06,29),23.125,null],[new Date(2017,08,18,13,07,00),null,22.875],[new Date(2017,08,18,13,07,30),23.125,null],[new Date(2017,08,18,13,08,01),null,22.750],[new Date(2017,08,18,13,09,03),null,22.562],[new Date(2017,08,18,13,09,34),23.125,null],[new Date(2017,08,18,13,10,05),null,22.500],[new Date(2017,08,18,13,10,36),23.187,null],[new Date(2017,08,18,13,11,07),null,23.375],[new Date(2017,08,18,13,11,37),23.187,null],[new Date(2017,08,18,13,12,08),null,24.125],[new Date(2017,08,18,13,12,39),23.250,null],[new Date(2017,08,18,13,13,10),null,24.312],[new Date(2017,08,18,13,13,41),23.312,null],[new Date(2017,08,18,13,14,12),null,25.062],[new Date(2017,08,18,13,14,43),23.375,null],[new Date(2017,08,18,13,15,14),null,25.312],[new Date(2017,08,18,13,15,44),23.375,null],[new Date(2017,08,18,13,16,15),null,26.062],[new Date(2017,08,18,13,16,46),23.437,null],[new Date(2017,08,18,13,17,17),null,26.187],[new Date(2017,08,18,13,17,48),23.437,null],[new Date(2017,08,18,13,18,19),null,24.750],[new Date(2017,08,18,13,18,50),23.500,null],[new Date(2017,08,18,13,19,21),null,25.312],[new Date(2017,08,18,13,19,51),23.500,null],[new Date(2017,08,18,13,20,22),null,25.062],[new Date(2017,08,18,13,21,24),null,25.312],[new Date(2017,08,18,13,21,55),23.500,null],[new Date(2017,08,18,13,22,26),null,26.250],[new Date(2017,08,18,13,22,57),23.562,null],[new Date(2017,08,18,13,23,28),null,26.437],[new Date(2017,08,18,13,23,58),23.562,null],[new Date(2017,08,18,13,24,29),null,27.250],[new Date(2017,08,18,13,25,00),23.562,null],[new Date(2017,08,18,13,25,31),null,26.125],[new Date(2017,08,18,13,26,02),23.625,null],[new Date(2017,08,18,13,26,33),null,26.375],[new Date(2017,08,18,13,27,04),23.625,null],[new Date(2017,08,18,13,27,35),null,26.375],[new Date(2017,08,18,13,28,05),23.625,null],[new Date(2017,08,18,13,28,36),null,26.875],[new Date(2017,08,18,13,29,07),23.625,null],[new Date(2017,08,18,13,29,38),null,25.437],[new Date(2017,08,18,13,30,09),23.625,null],[new Date(2017,08,18,13,30,40),null,25.750],[new Date(2017,08,18,13,31,11),23.625,null],[new Date(2017,08,18,13,31,41),null,25.000],[new Date(2017,08,18,13,32,12),23.687,null],[new Date(2017,08,18,13,32,43),null,25.250],[new Date(2017,08,18,13,33,14),23.687,null],[new Date(2017,08,18,13,33,45),null,25.187],[new Date(2017,08,18,13,34,16),23.687,null],[new Date(2017,08,18,13,34,47),null,25.062],[new Date(2017,08,18,13,35,18),23.687,null],[new Date(2017,08,18,13,35,48),null,26.000],[new Date(2017,08,18,13,36,19),23.687,null],[new Date(2017,08,18,13,36,50),null,26.062],[new Date(2017,08,18,13,37,21),23.687,null],[new Date(2017,08,18,13,37,52),null,25.750],[new Date(2017,08,18,13,38,23),23.687,null],[new Date(2017,08,18,13,38,54),null,26.312],[new Date(2017,08,18,13,39,24),23.687,null],[new Date(2017,08,18,13,39,55),null,25.937],[new Date(2017,08,18,13,40,26),23.750,null],[new Date(2017,08,18,13,40,57),null,25.625],[new Date(2017,08,18,13,41,28),23.750,null],[new Date(2017,08,18,13,41,59),null,25.312],[new Date(2017,08,18,13,42,30),23.750,null],[new Date(2017,08,18,13,43,01),null,25.187],[new Date(2017,08,18,13,43,31),23.750,null],[new Date(2017,08,18,13,44,02),null,25.062],[new Date(2017,08,18,13,44,33),23.750,null],[new Date(2017,08,18,13,45,04),null,25.000],[new Date(2017,08,18,13,45,35),23.687,null],[new Date(2017,08,18,13,46,06),null,24.687],[new Date(2017,08,18,13,46,37),23.625,null],[new Date(2017,08,18,13,47,08),null,24.375],[new Date(2017,08,18,13,47,38),23.562,null],[new Date(2017,08,18,13,48,09),null,23.750],[new Date(2017,08,18,13,48,40),23.562,null],[new Date(2017,08,18,13,49,11),null,23.750],[new Date(2017,08,18,13,49,42),23.562,null],[new Date(2017,08,18,13,50,13),null,24.500],[new Date(2017,08,18,13,50,44),23.562,null],[new Date(2017,08,18,13,51,15),null,23.812],[new Date(2017,08,18,13,51,45),23.500,null],[new Date(2017,08,18,13,52,16),null,24.000],[new Date(2017,08,18,13,52,47),23.562,null],[new Date(2017,08,18,13,53,18),null,24.625],[new Date(2017,08,18,13,53,49),23.562,null],[new Date(2017,08,18,13,54,20),null,24.187],[new Date(2017,08,18,13,54,51),23.500,null],[new Date(2017,08,18,13,55,21),null,22.750],[new Date(2017,08,18,13,55,52),23.437,null],[new Date(2017,08,18,13,56,23),null,21.875],[new Date(2017,08,18,13,56,54),23.437,null],[new Date(2017,08,18,13,57,25),null,21.437],[new Date(2017,08,18,13,57,56),23.375,null],[new Date(2017,08,18,13,58,27),null,20.812],[new Date(2017,08,18,13,58,58),23.312,null],[new Date(2017,08,18,13,59,28),null,20.750],[new Date(2017,08,18,13,59,59),23.312,null],[new Date(2017,08,18,14,00,30),null,20.937],[new Date(2017,08,18,14,01,01),23.375,null],[new Date(2017,08,18,14,01,32),null,21.375],[new Date(2017,08,18,14,02,03),23.375,null],[new Date(2017,08,18,14,02,34),null,21.375],[new Date(2017,08,18,14,03,05),23.375,null],[new Date(2017,08,18,14,03,35),null,20.812],[new Date(2017,08,18,14,04,06),23.437,null],[new Date(2017,08,18,14,04,37),null,20.562],[new Date(2017,08,18,14,05,08),23.375,null],[new Date(2017,08,18,14,05,39),null,19.875],[new Date(2017,08,18,14,06,10),23.375,null],[new Date(2017,08,18,14,06,41),null,19.375],[new Date(2017,08,18,14,07,11),23.312,null],[new Date(2017,08,18,14,07,42),null,19.187],[new Date(2017,08,18,14,08,13),23.312,null],[new Date(2017,08,18,14,08,44),null,19.750],[new Date(2017,08,18,14,09,15),23.375,null],[new Date(2017,08,18,14,09,46),null,20.250],[new Date(2017,08,18,14,10,17),23.375,null],[new Date(2017,08,18,14,10,48),null,21.187],[new Date(2017,08,18,14,11,18),23.437,null],[new Date(2017,08,18,14,11,49),null,21.750],[new Date(2017,08,18,14,12,20),23.500,null],[new Date(2017,08,18,14,12,51),null,22.250],[new Date(2017,08,18,14,13,22),23.437,null],[new Date(2017,08,18,14,13,53),null,22.000],[new Date(2017,08,18,14,14,24),23.500,null],[new Date(2017,08,18,14,14,54),null,21.937],[new Date(2017,08,18,14,15,25),23.500,null],[new Date(2017,08,18,14,15,56),null,23.062],[new Date(2017,08,18,14,16,27),23.500,null],[new Date(2017,08,18,14,16,58),null,22.687],[new Date(2017,08,18,14,17,29),23.500,null],[new Date(2017,08,18,14,18,00),null,22.625],[new Date(2017,08,18,14,18,30),23.562,null],[new Date(2017,08,18,14,19,01),null,23.437],[new Date(2017,08,18,14,19,32),23.562,null],[new Date(2017,08,18,14,20,03),null,23.375],[new Date(2017,08,18,14,20,34),23.625,null],[new Date(2017,08,18,14,21,05),null,24.125],[new Date(2017,08,18,14,21,36),23.687,null],[new Date(2017,08,18,14,22,07),null,24.312],[new Date(2017,08,18,14,22,38),23.687,null],[new Date(2017,08,18,14,23,08),null,24.250],[new Date(2017,08,18,14,23,39),23.750,null],[new Date(2017,08,18,14,24,10),null,25.062],[new Date(2017,08,18,14,24,41),23.750,null],[new Date(2017,08,18,14,25,12),null,25.500],[new Date(2017,08,18,14,25,43),23.687,null],[new Date(2017,08,18,14,26,14),null,24.500],[new Date(2017,08,18,14,26,45),23.687,null],[new Date(2017,08,18,14,27,15),null,24.312],[new Date(2017,08,18,14,27,46),23.687,null],[new Date(2017,08,18,14,28,17),null,24.125],[new Date(2017,08,18,14,28,48),23.750,null],[new Date(2017,08,18,14,29,19),null,25.000],[new Date(2017,08,18,14,29,50),23.687,null],[new Date(2017,08,18,14,30,21),null,23.750],[new Date(2017,08,18,14,30,52),23.687,null],[new Date(2017,08,18,14,31,22),null,24.375],[new Date(2017,08,18,14,31,53),23.687,null],[new Date(2017,08,18,14,32,24),null,24.250],[new Date(2017,08,18,14,32,55),23.750,null],[new Date(2017,08,18,14,33,26),null,24.750],[new Date(2017,08,18,14,33,57),23.750,null],[new Date(2017,08,18,14,34,28),null,23.812],[new Date(2017,08,18,14,34,59),23.750,null],[new Date(2017,08,18,14,35,29),null,22.750],[new Date(2017,08,18,14,36,00),23.812,null],[new Date(2017,08,18,14,36,31),null,22.437],[new Date(2017,08,18,14,37,02),23.812,null],[new Date(2017,08,18,14,37,33),null,22.000],[new Date(2017,08,18,14,38,04),23.875,null],[new Date(2017,08,18,14,38,35),null,21.812],[new Date(2017,08,18,14,39,06),23.875,null],[new Date(2017,08,18,14,39,37),null,21.750],[new Date(2017,08,18,14,40,07),23.875,null],[new Date(2017,08,18,14,40,38),null,21.562],[new Date(2017,08,18,14,41,09),23.875,null],[new Date(2017,08,18,14,41,40),null,21.562],[new Date(2017,08,18,14,42,11),23.937,null],[new Date(2017,08,18,14,42,42),null,21.937],[new Date(2017,08,18,14,43,13),23.937,null],[new Date(2017,08,18,14,43,44),null,21.875],[new Date(2017,08,18,14,44,14),23.875,null],[new Date(2017,08,18,14,44,45),null,21.562],[new Date(2017,08,18,14,45,16),23.812,null],[new Date(2017,08,18,14,45,47),null,21.250],[new Date(2017,08,18,14,46,18),23.750,null],[new Date(2017,08,18,14,46,49),null,20.562],[new Date(2017,08,18,14,47,20),23.687,null],[new Date(2017,08,18,14,47,51),null,20.375],[new Date(2017,08,18,14,48,21),23.687,null],[new Date(2017,08,18,14,48,52),null,20.125],[new Date(2017,08,18,14,49,23),23.625,null],[new Date(2017,08,18,14,49,54),null,20.000],[new Date(2017,08,18,14,50,25),23.562,null],[new Date(2017,08,18,14,50,56),null,20.187],[new Date(2017,08,18,14,51,27),23.562,null],[new Date(2017,08,18,14,51,58),null,20.250],[new Date(2017,08,18,14,52,28),23.562,null],[new Date(2017,08,18,14,52,59),null,20.375],[new Date(2017,08,18,14,53,30),23.562,null],[new Date(2017,08,18,14,54,01),null,20.500],[new Date(2017,08,18,14,54,32),23.500,null],[new Date(2017,08,18,14,55,03),null,20.125],[new Date(2017,08,18,14,55,34),23.500,null],[new Date(2017,08,18,14,56,05),null,20.125],[new Date(2017,08,18,14,56,35),23.500,null],[new Date(2017,08,18,14,57,06),null,19.875],[new Date(2017,08,18,14,57,37),23.500,null],[new Date(2017,08,18,14,58,08),null,19.562],[new Date(2017,08,18,14,58,39),23.437,null],[new Date(2017,08,18,14,59,10),null,19.437],[new Date(2017,08,18,14,59,41),23.437,null],[new Date(2017,08,18,15,00,11),null,19.625],[new Date(2017,08,18,15,00,42),23.437,null],[new Date(2017,08,18,15,01,13),null,19.187],[new Date(2017,08,18,15,01,44),23.437,null],[new Date(2017,08,18,15,02,15),null,19.312],[new Date(2017,08,18,15,02,46),23.437,null],[new Date(2017,08,18,15,03,17),null,19.125],[new Date(2017,08,18,15,03,48),23.375,null],[new Date(2017,08,18,15,04,19),null,18.875],[new Date(2017,08,18,15,04,49),23.375,null],[new Date(2017,08,18,15,05,20),null,18.625],[new Date(2017,08,18,15,05,51),23.375,null],[new Date(2017,08,18,15,06,22),null,18.562],[new Date(2017,08,18,15,06,53),23.375,null],[new Date(2017,08,18,15,07,24),null,18.562],[new Date(2017,08,18,15,07,55),23.375,null],[new Date(2017,08,18,15,08,26),null,18.937],[new Date(2017,08,18,15,08,57),23.375,null],[new Date(2017,08,18,15,09,28),null,18.812],[new Date(2017,08,18,15,09,59),23.375,null],[new Date(2017,08,18,15,10,30),null,18.750],[new Date(2017,08,18,15,11,01),23.375,null],[new Date(2017,08,18,15,11,32),null,18.062],[new Date(2017,08,18,15,12,02),23.375,null],[new Date(2017,08,18,15,12,33),null,16.437],[new Date(2017,08,18,15,13,04),23.375,null],[new Date(2017,08,18,15,13,35),null,15.125],[new Date(2017,08,18,15,14,06),23.375,null],[new Date(2017,08,18,15,14,37),null,14.812],[new Date(2017,08,18,15,15,08),23.375,null],[new Date(2017,08,18,15,15,39),null,14.312],[new Date(2017,08,18,15,16,10),23.375,null],[new Date(2017,08,18,15,17,11),23.375,null],[new Date(2017,08,18,15,17,42),null,14.062],[new Date(2017,08,18,15,18,13),23.375,null],[new Date(2017,08,18,15,18,44),null,14.000],[new Date(2017,08,18,15,19,15),23.375,null],[new Date(2017,08,18,15,19,46),null,13.937],[new Date(2017,08,18,15,20,17),23.375,null],[new Date(2017,08,18,15,20,47),null,13.625],[new Date(2017,08,18,15,21,18),23.375,null],[new Date(2017,08,18,15,21,49),null,13.437],[new Date(2017,08,18,15,22,20),23.375,null],[new Date(2017,08,18,15,22,51),null,13.312],[new Date(2017,08,18,15,23,22),23.375,null],[new Date(2017,08,18,15,23,53),null,13.687],[new Date(2017,08,18,15,24,24),23.375,null],[new Date(2017,08,18,15,24,54),null,13.500],[new Date(2017,08,18,15,25,25),23.375,null],[new Date(2017,08,18,15,25,56),null,13.562],[new Date(2017,08,18,15,26,27),23.375,null],[new Date(2017,08,18,15,26,58),null,13.750],[new Date(2017,08,18,15,27,29),23.375,null],[new Date(2017,08,18,15,28,00),null,14.062],[new Date(2017,08,18,15,28,31),23.375,null],[new Date(2017,08,18,15,29,01),null,13.750],[new Date(2017,08,18,15,29,32),23.375,null],[new Date(2017,08,18,15,30,03),null,13.687],[new Date(2017,08,18,15,30,34),23.375,null],[new Date(2017,08,18,15,31,05),null,13.687],[new Date(2017,08,18,15,31,36),23.375,null],[new Date(2017,08,18,15,32,07),null,13.687],[new Date(2017,08,18,15,32,38),23.375,null],[new Date(2017,08,18,15,33,08),null,13.500],[new Date(2017,08,18,15,33,39),23.375,null],[new Date(2017,08,18,15,34,10),null,13.625],[new Date(2017,08,18,15,34,41),23.375,null],[new Date(2017,08,18,15,35,12),null,13.687],[new Date(2017,08,18,15,35,43),23.375,null],]);
var options = {
curveType: 'function',
hAxis: {
title: 'Time'
},
vAxis: {
title: 'Temperature'
}
};
var myView = new google.visualization.DataView(data);
var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
chart.draw(data, options);
//document.write("Column array value: " + columnArray[1]);
}
//

</script>
Inline images 1


To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6ZdU-2znAkGqqc9Bj4-eyvV6r8PTp-EXSybMet6W%2BLAsA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/IB-y-DvK1g8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPkz2K%2BKAA3wV1vRvMbnHZRoP%2BgjBstRciDHMa9aNBeuQ%40mail.gmail.com.

Daniel LaLiberte

unread,
Aug 18, 2017, 12:14:30 PM8/18/17
to Google Visualization API
I believe all you need to do is add the option 'interpolateNulls': true, in order to get lines drawn through the null values that you added because not all domain values have corresponding target values.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPkz2K%2BKAA3wV1vRvMbnHZRoP%2BgjBstRciDHMa9aNBeuQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6ZcAVhdcc-wpxfhYNrjgTJHboTxCxz%3D7ETM7Q9itXJFKA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Matt Kiteley

unread,
Aug 18, 2017, 12:33:35 PM8/18/17
to google-visua...@googlegroups.com
You're a legend!!!!! :)

Thanks so much!

Matt
Inline images 1


To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CABE_m6ZcAVhdcc-wpxfhYNrjgTJHboTxCxz%3D7ETM7Q9itXJFKA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



--

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/IB-y-DvK1g8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMy3Ph6Sr83MKHDKT4HNFb8kHwAeUzaxacsZdkO5SKgPQ%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages