Re: Financial data

513 views
Skip to first unread message

asgallant

unread,
Aug 6, 2012, 12:28:09 PM8/6/12
to google-visua...@googlegroups.com
The CategoryFilter control wasn't designed to do what you want here, but you can hack it to make it work (see my example script here: http://jsfiddle.net/asgallant/WaUu2/).

Basically, what you need to know is that each line (or, in the example case, bar color) corresponds to a column in the dataTable, with the first column providing your axis values.  To add a new line to the chart, you need to either add a new column to the dataTable or expose an additional column from the dataTable to the chart via a DataView (which is what the #setView() method of the ChartWrapper object does) - my example does the latter.

There is a whole bunch of code in there that converts the CategoryFilter into a column filter for the chart.  I'd be happy to walk you through everything, but it might be best for you to play around on the Visualization Playground first to get a feel for how the charts are built and how it all comes together first, because there is some fairly advanced stuff that goes into my hack.

On Monday, August 6, 2012 9:15:26 AM UTC-4, shutzi wrote:
I would like to draw several line charts. The aim is to add progressively new lines form the database trough a pulldown list like in the CategoryFilter Control example.

Can someone help me with that?

I am quite new to google chart thus the more explanation the better.

Thanks in advance

shutzi

unread,
Aug 6, 2012, 6:00:32 PM8/6/12
to google-visua...@googlegroups.com
Thanks.

I came up with something like this;

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>
      Google Visualization API Sample
    </title>
    <script type="text/javascript" src="http://www.google.com/jsapi"></script>
    <script type="text/javascript">
      google.load('visualization''1.1'{packages['controls','corechart']});
    </script>
    <script type="text/javascript">
      function drawVisualization({
        // Prepare the data.
        var data google.visualization.arrayToDataTable([
          ['Metric''Value','blah'],
          ['CPU' 12,2],
          ['Memory'20,1],
          ['Disk'7,6],
          ['Network'54,83]
        ]);
      
        // Define a category picker for the 'Metric' column.
        var categoryPicker new google.visualization.ControlWrapper({
          'controlType''CategoryFilter',
          'containerId''control1',
          'options'{
            'filterColumnLabel''Metric',
            'ui'{
              'allowTyping'true,
              'allowMultiple'true,
              'selectedValuesLayout''belowStacked'
            }
          },
          // Define an initial state, i.e. a set of metrics to be initially selected.
          'state'{'selectedValues'['Memory']}
        });
      
        // Define a gauge chart.
        var LineChart new google.visualization.ChartWrapper({
          'chartType''LineChart',
          'containerId''chart1',
          'options'{
           'width'800,
           'height'360
          }
        });
      
        // Create the dashboard.
        var dashboard new google.visualization.Dashboard(document.getElementById('dashboard')).
          // Configure the category picker to affect the gauge chart
          bind(categoryPickerLineChart).
          // Draw the dashboard
          draw(data);
      }
      

      google.setOnLoadCallback(drawVisualization);
    </script>
  </head>
  <body style="font-family: Arial;border: 0 none;">
    <div id="dashboard">
      <table>
        <tr style='vertical-align: top'>
          <td style='width: 300px; font-size: 0.9em;'>
            <div id="control1"></div>
          </td>
          <td style='width: 1200px'>
            <div style="float: left;" id="chart1"></div>
          </td>
        </tr>
      </table>
    </div>
  </body>
</html>


But my problem is that I cannot filter the data horizontally.
i.e the following does not work with filterRowLabel;

        var categoryPicker new google.visualization.ControlWrapper({
          'controlType''CategoryFilter',
          'containerId''control1',
          'options'{
            'filterColumnLabel''Metric',
            'ui'{
              'allowTyping'true,
              'allowMultiple'true,
              'selectedValuesLayout''belowStacked'
            }
          },

shutzi

unread,
Aug 6, 2012, 6:07:23 PM8/6/12
to google-visua...@googlegroups.com
After reading your message more carefully; Thank you this is exactly what I want! 
Changed the chart type to 'LineChart' and it does exactly what I was looking for.


Le lundi 6 août 2012 17:28:09 UTC+1, asgallant a écrit :

asgallant

unread,
Aug 6, 2012, 6:22:33 PM8/6/12
to google-visua...@googlegroups.com
You're welcome.

As a side note, there could potentially be a performance issue with my solution if your data set is very large, so let me know if things seem to be running slow and I'll see what I can come up with to fix it.

shutzi

unread,
Aug 7, 2012, 5:24:27 AM8/7/12
to google-visua...@googlegroups.com
Here's my code so far. As a personal note I added animation. Looks pretty good but I have several issues;
  • How do I specify the initial display? (I don't want every line to be displayed)
  • I suppose this is an issue of the filtering but if I remove or add lines the colors change which is not a thing that I want? How do I tackle that if it's possible (or what should I use instead of filtering)?
  • I would like to add a slider for the date (i.e. to change the abscissa range dynamically).
  • On a side note, is it possible to perform matrix calculation on the DataTable inside of the code and than pipe it back to the graph? I'm asking because I would like to change the date range with the slide and to have every line scaled at one for the first date.
I am sorry to ask so many questions but even as a novice to google charts I am very excited by what it is capable of.

Thanks in advance!

<!--
You are free to copy and use this sample in accordance with the terms of the
Apache license (http://www.apache.org/licenses/LICENSE-2.0.html)
-->


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<title>
Google Visualization API Sample
</title>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization''1.1'{packages['controls','corechart']});
</script>
<script type="text/javascript">
  

google.setOnLoadCallback(drawChart);

function drawChart({
var data google.visualization.arrayToDataTable([           
['date','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q'],
['02/01/2012',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1],
['03/01/2012',1.00227158,1.005315225,1.003662563,1.011327807,1.007016013,1.006120586,1.005379253,1.008121323,1.006617341,1.008975003,1.00786844,1.006744055,1,1.007112603,1.002249086,1.004789272,1.003610828],
['04/01/2012',1.003443427,1.005434547,1.002746922,1.012168492,1.008033507,1.006098759,1.006014644,1.00654678,1.009170488,1.010586462,1.009306218,1.00599336,1,1.005434348,1.00581014,1.003831418,1.002778224],
['05/01/2012',1.005390495,1.004512518,1.001350339,1.010603137,1.007662607,1.005295116,1.003802639,1.004806497,1.010629429,1.006811825,1.006051545,1.003478834,1,1.003836011,1.007590666,1.001915709,1.001997031],
['06/01/2012',1.006382058,1.003373541,1.00049944,1.010560262,1.008005078,1.003776131,1.002478369,1.004060661,1.012609421,1.00524953,1.004563695,1.001776036,1,1.002077839,1.003935901,1.000957854,1.000708392],
['09/01/2012',1.006580371,1.003384388,1.000961885,1.010747314,1.009806683,1.005786231,1.002992548,1.004920444,1.012609421,1.003829262,1.002968548,1.002032371,1,1.004475346,1.004498173,1.002873563,1.001322738],
['10/01/2012',1.00880688,1.007289452,1.00377355,1.016444635,1.012357359,1.01086605,1.005108144,1.009758018,1.021363068,1.01005113,1.007739683,1.00775719,1,1.007592104,1.008152938,1.005747126,1.004328188],
['11/01/2012',1.009509988,1.006833861,1.00226598,1.014936026,1.011842331,1.010296554,1.003582322,1.008918953,1.023707795,1.008024516,1.005600898,1.007024803,1,1.007272437,1.012463687,1.003831418,1.004767966],
['03/01/2012',1.00227158,1.005315225,1.003662563,1.011327807,1.007016013,1.006120586,1.005379253,1.008121323,1.006617341,1.008975003,1.00786844,1.006744055,1,1.007112603,1.002249086,1.004789272,1.003610828],
['04/01/2012',1.003443427,1.005434547,1.002746922,1.012168492,1.008033507,1.006098759,1.006014644,1.00654678,1.009170488,1.010586462,1.009306218,1.00599336,1,1.005434348,1.00581014,1.003831418,1.002778224],
['05/01/2012',1.005390495,1.004512518,1.001350339,1.010603137,1.007662607,1.005295116,1.003802639,1.004806497,1.010629429,1.006811825,1.006051545,1.003478834,1,1.003836011,1.007590666,1.001915709,1.001997031],
['06/01/2012',1.006382058,1.003373541,1.00049944,1.010560262,1.008005078,1.003776131,1.002478369,1.004060661,1.012609421,1.00524953,1.004563695,1.001776036,1,1.002077839,1.003935901,1.000957854,1.000708392],
['09/01/2012',1.006580371,1.003384388,1.000961885,1.010747314,1.009806683,1.005786231,1.002992548,1.004920444,1.012609421,1.003829262,1.002968548,1.002032371,1,1.004475346,1.004498173,1.002873563,1.001322738],
['10/01/2012',1.00880688,1.007289452,1.00377355,1.016444635,1.012357359,1.01086605,1.005108144,1.009758018,1.021363068,1.01005113,1.007739683,1.00775719,1,1.007592104,1.008152938,1.005747126,1.004328188],
['11/01/2012',1.009509988,1.006833861,1.00226598,1.014936026,1.011842331,1.010296554,1.003582322,1.008918953,1.023707795,1.008024516,1.005600898,1.007024803,1,1.007272437,1.012463687,1.003831418,1.004767966],
['03/01/2012',1.00227158,1.005315225,1.003662563,1.011327807,1.007016013,1.006120586,1.005379253,1.008121323,1.006617341,1.008975003,1.00786844,1.006744055,1,1.007112603,1.002249086,1.004789272,1.003610828],
['04/01/2012',1.003443427,1.005434547,1.002746922,1.012168492,1.008033507,1.006098759,1.006014644,1.00654678,1.009170488,1.010586462,1.009306218,1.00599336,1,1.005434348,1.00581014,1.003831418,1.002778224],
['05/01/2012',1.005390495,1.004512518,1.001350339,1.010603137,1.007662607,1.005295116,1.003802639,1.004806497,1.010629429,1.006811825,1.006051545,1.003478834,1,1.003836011,1.007590666,1.001915709,1.001997031],
['06/01/2012',1.006382058,1.003373541,1.00049944,1.010560262,1.008005078,1.003776131,1.002478369,1.004060661,1.012609421,1.00524953,1.004563695,1.001776036,1,1.002077839,1.003935901,1.000957854,1.000708392],
['09/01/2012',1.006580371,1.003384388,1.000961885,1.010747314,1.009806683,1.005786231,1.002992548,1.004920444,1.012609421,1.003829262,1.002968548,1.002032371,1,1.004475346,1.004498173,1.002873563,1.001322738],
['10/01/2012',1.00880688,1.007289452,1.00377355,1.016444635,1.012357359,1.01086605,1.005108144,1.009758018,1.021363068,1.01005113,1.007739683,1.00775719,1,1.007592104,1.008152938,1.005747126,1.004328188],
['11/01/2012',1.009509988,1.006833861,1.00226598,1.014936026,1.011842331,1.010296554,1.003582322,1.008918953,1.023707795,1.008024516,1.005600898,1.007024803,1,1.007272437,1.012463687,1.003831418,1.004767966],
['03/01/2012',1.00227158,1.005315225,1.003662563,1.011327807,1.007016013,1.006120586,1.005379253,1.008121323,1.006617341,1.008975003,1.00786844,1.006744055,1,1.007112603,1.002249086,1.004789272,1.003610828],
['04/01/2012',1.003443427,1.005434547,1.002746922,1.012168492,1.008033507,1.006098759,1.006014644,1.00654678,1.009170488,1.010586462,1.009306218,1.00599336,1,1.005434348,1.00581014,1.003831418,1.002778224],
['05/01/2012',1.005390495,1.004512518,1.001350339,1.010603137,1.007662607,1.005295116,1.003802639,1.004806497,1.010629429,1.006811825,1.006051545,1.003478834,1,1.003836011,1.007590666,1.001915709,1.001997031],
['06/01/2012',1.006382058,1.003373541,1.00049944,1.010560262,1.008005078,1.003776131,1.002478369,1.004060661,1.012609421,1.00524953,1.004563695,1.001776036,1,1.002077839,1.003935901,1.000957854,1.000708392],
['09/01/2012',1.006580371,1.003384388,1.000961885,1.010747314,1.009806683,1.005786231,1.002992548,1.004920444,1.012609421,1.003829262,1.002968548,1.002032371,1,1.004475346,1.004498173,1.002873563,1.001322738],
['10/01/2012',1.00880688,1.007289452,1.00377355,1.016444635,1.012357359,1.01086605,1.005108144,1.009758018,1.021363068,1.01005113,1.007739683,1.00775719,1,1.007592104,1.008152938,1.005747126,1.004328188],
['11/01/2012',1.009509988,1.006833861,1.00226598,1.014936026,1.011842331,1.010296554,1.003582322,1.008918953,1.023707795,1.008024516,1.005600898,1.007024803,1,1.007272437,1.012463687,1.003831418,1.004767966],
['03/01/2012',1.00227158,1.005315225,1.003662563,1.011327807,1.007016013,1.006120586,1.005379253,1.008121323,1.006617341,1.008975003,1.00786844,1.006744055,1,1.007112603,1.002249086,1.004789272,1.003610828],
['04/01/2012',1.003443427,1.005434547,1.002746922,1.012168492,1.008033507,1.006098759,1.006014644,1.00654678,1.009170488,1.010586462,1.009306218,1.00599336,1,1.005434348,1.00581014,1.003831418,1.002778224],
['05/01/2012',1.005390495,1.004512518,1.001350339,1.010603137,1.007662607,1.005295116,1.003802639,1.004806497,1.010629429,1.006811825,1.006051545,1.003478834,1,1.003836011,1.007590666,1.001915709,1.001997031],
['06/01/2012',1.006382058,1.003373541,1.00049944,1.010560262,1.008005078,1.003776131,1.002478369,1.004060661,1.012609421,1.00524953,1.004563695,1.001776036,1,1.002077839,1.003935901,1.000957854,1.000708392],
['09/01/2012',1.006580371,1.003384388,1.000961885,1.010747314,1.009806683,1.005786231,1.002992548,1.004920444,1.012609421,1.003829262,1.002968548,1.002032371,1,1.004475346,1.004498173,1.002873563,1.001322738],
['10/01/2012',1.00880688,1.007289452,1.00377355,1.016444635,1.012357359,1.01086605,1.005108144,1.009758018,1.021363068,1.01005113,1.007739683,1.00775719,1,1.007592104,1.008152938,1.005747126,1.004328188],
['11/01/2012',1.009509988,1.006833861,1.00226598,1.014936026,1.011842331,1.010296554,1.003582322,1.008918953,1.023707795,1.008024516,1.005600898,1.007024803,1,1.007272437,1.012463687,1.003831418,1.004767966],
['12/01/2012',1.009500974,1.00779928,1.001683299,1.015102902,1.011887289,1.009557401,1.0033234,1.010835336,1.024854106,1.007680374,1.004685298,1.007708364,1,1.009989611,1.0102146,1.005747126,1.005132928]       
]);          

var columnsTable new google.visualization.DataTable();
columnsTable.addColumn('number''colIndex');
columnsTable.addColumn('string''colLabel');
var initState {
selectedValues['HFRX Global']
};
// put the columns into this data table (skip column 0)
for (var 1data.getNumberOfColumns()i++{
columnsTable.addRow([idata.getColumnLabel(i)]);
initState.selectedValues.push(data.getColumnLabel(i));
}

var chart new google.visualization.ChartWrapper({
chartType'LineChart',
containerId'chart_div',
dataTabledata,
options{
title'Chart',
width700,
height470,
        animation:{
        duration1000,
        easing'out',
      }
}
});

chart.draw();

var dash new google.visualization.Dashboard(document.getElementById('dash'));

var columnFilter new google.visualization.ControlWrapper({
controlType'CategoryFilter',
containerId'colFilter_div',
options{
filterColumnLabel'colLabel',
ui{
label'Replicator',

allowTypingtrue,
allowMultipletrue,
selectedValuesLayout'belowStacked'
}
},
stateinitState
});

var junkChart new google.visualization.ChartWrapper({
chartType'Table',
containerId'junk_div'
});

google.visualization.events.addListener(columnFilter'statechange'function({
var state columnFilter.getState();
var row;
var columnIndices [0];
for (var 0state.selectedValues.lengthi++{
row columnsTable.getFilteredRows([{
column1,
valuestate.selectedValues[i]}])[0];
columnIndices.push(columnsTable.getValue(row0));
}
// sort the indices into their original order
columnIndices.sort(function(ab{
return (b);
});
chart.setView({
columnscolumnIndices
});
chart.draw();
});

// bind controls to junk chart and draw dash
dash.bind([columnFilter][junkChart]);
dash.draw(columnsTable);

}

 </script>
 </head>

<body style="font-family: Arial;border: 0 none;">

<div id="dash">
<table>
<tr style='vertical-align: top'>
<td style='width: 16px; font-size: 0.9em;'>
<div id="colFilter_div"></div>
</td>
<td style='width: 60px'>
<div style="float: left;" id="chart_div"></div>
</td>
</tr>
</table>
</div>
<div id="junk_div" style="display: none;"></div>
</body>
</html>

asgallant

unread,
Aug 7, 2012, 2:04:25 PM8/7/12
to google-visua...@googlegroups.com
These are all doable.  In order:

1) To set the initial display, set the view.columns parameter for the chart to the columns you want to start with (ie, to start with A, B, C, set columns = [0, 1, 2, 3]).
2) This is a bit complex, but you have to build a map that associates column indices with colors, and then change the colors used to draw the chart when the columns change
3) There is a control (ChartRangeFilter) that does this, but it only works with continuous axes, so you have to change your dates from strings to Date objects
4) Using calculated columns in the view fed to the chart allows you to do this

I did up a jsfiddle based on your code with these features: http://jsfiddle.net/asgallant/EVQP2/

A few things to note:

1) you might want to fiddle with the animation duration, as the chart draws a bit awkwardly when you use the range slider with an animation duration of 1 second
2) the "setChartControls" function (at the bottom) is where I handled assigning colors and calculated columns to the data set.  I used simple data normalization to set all series equal to 1 on the first displayed day, but if you want to use something else, the "calc" option holds the function that makes it all happen (dt is the dataTable being fed to the chart as filtered by the control (NOT the same as the "data" variable) and row is the row being calculated).  I assumed that all columns should be treated the same, if you want to handle them differently, then you can instead assign the function in the "columnsMap" object alongside the color property, ie:

var columnsMap {
    1{
        color'FF0000',
        definition{
            labeldata.getColumnLabel(1),
            type'number',
            calcfunction (dtrow{
                // return the value normalized to the first row in the view
                return dt.getValue(row1dt.getValue(01);
            }
        }
    }//...
};

and reference that instead.

shutzi

unread,
Aug 8, 2012, 7:00:10 AM8/8/12
to google-visua...@googlegroups.com
I don't know what to say; this is far more than what I hoped is possible! Thank you!

By curiosity, is there a way of piping out an html code out of JSFIDDLE? 

I tried to make my one fiddle but I failed (added HTML to HTML, JavaScript to JavaScript and added a resource), do you have any idea why?

Once again, Thank you!

asgallant

unread,
Aug 8, 2012, 9:48:34 AM8/8/12
to google-visua...@googlegroups.com
To get the HTML, right-click in the display frame and choose "View Frame Source" (in Chrome - FF and IE might have something different, but basically you want the frame's source code, not the page's source code).  There are a couple extra script and CSS links that jsfiddle includes by default (see them at the top of the source, above the google jsapi script).  You should delete these. The "?fake=.js" that I tag onto the end of the jsapi call is just a hack to make it work with jsfiddle (which doesn't load js links that don't end in ".js" properly); you can remove this substring (though leaving it on technically doesn't hurt anything either).

As far as making your own fiddles, by default jsfiddle places your js code in an "onLoad" event handler, which some API's (including google's loader) don't play well with.  In the framework section, change the first dropdown from "onLoad" to "no wrap (head)" and see if that fixes your problem.  If it doesn't, open the fiddle in FF or Chrome and check the developer console to see what errors are popping up.

shutzi

unread,
Aug 8, 2012, 9:56:49 AM8/8/12
to google-visua...@googlegroups.com
Thank you.

shutzi

unread,
Aug 10, 2012, 6:52:38 AM8/10/12
to google-visua...@googlegroups.com
I have a very large data set with data that I do not want to be publicly available. 
Do you have a script converting the Excel data to what I need to be imputed in the HTML code?
Or alternatively is there a way of setting a password to google spreadsheet and then to access it?


Le mercredi 8 août 2012 14:48:34 UTC+1, asgallant a écrit :

asgallant

unread,
Aug 10, 2012, 11:27:15 AM8/10/12
to google-visua...@googlegroups.com
As far as I know, the only way to access data from a Google doc through the viz API is if the doc is public.

If you want the data to be private, then there are a few options, depending on the setup of your server:

1) in Excel, save the file as a CSV and upload it to your server.  You can either read it server-side and input data into the javascript directly (via server-side scripting like PHP) or use an AJAX request to read the file from the client-side.  If you read from the client-side, you will have to convert it to a js array (google for "js csv to array"), and then input the data into a DataTable.
2) create a database and upload the data to the database.  You will then need to do some server-side scripting to build a data-retrieval script that can feed the data to the client (again via AJAX).  Alternatively, there are pre-built libraries in Python and Java that expose the same query interface used by Google docs (and, I notice today, a 3rd-party tool for PHP).

A.Radice

unread,
Aug 21, 2012, 10:28:22 PM8/21/12
to google-visua...@googlegroups.com
Okay, so I have 1. and 3. worked out, but I am still having difficulty rendering the chart.  Can you take a look at my code and see if you spot any errors?

function drawChart() {

var data = new google.visualization.DataTable();
data.addColumn('date', 'Date');
data.addColumn('number', 'Construction and Mining Jobs');
data.addColumn('number', 'Wholesale Trade Jobs');
data.addColumn('number', 'Retail Trade Jobs');
data.addColumn('number', 'Transportation and Utilities Jobs');
data.addColumn('number', 'Finance and Insurance Jobs');
data.addColumn('number', 'Real Estate and Rental Jobs');
data.addColumn('number', 'Professional, Scientific, and Technical Jobs');
data.addColumn('number', 'Management Jobs');
data.addColumn('number', 'Admin. and Waste Management Jobs');
data.addColumn('number', 'Educational Services Jobs');
data.addColumn('number', 'Health Care and Social Assistance Jobs');
data.addColumn('number', 'Accomodation and Food Services Jobs');
data.addColumn('number', 'Accomodation Jobs');
data.addColumn('number', 'Food Services Jobs');
data.addColumn('number', 'Other Services Jobs');

data.addRows([
	
	
	[new Date(1990, 0 , 1), 
		34.4, 
		17.3, 
		66.3, 
		27.80000000000001, 
		18.099999999999998, 
		12.8, 
		21.1, 
		4.6586905460951265, 
		22.841309453904874, 
		8.8, 
		36.8, 
		84.2, 
		37.977182117282766, 
		46.222817882717244, 
		19.4],
	
	
	[new Date(1990, 1 , 1), 
		35.3, 
		17.5, 
		66.8, 
		28.400000000000006, 
		18.0, 
		12.9, 
		21.4, 
		4.709512624779801, 
		23.090487375220206, 
		8.8, 
		36.9, 
		85.4, 
		38.518424617766605, 
		46.88157538223341, 
		19.5],
	
	
	[new Date(1990, 2 , 1), 
		35.1, 
		17.5, 
		66.9, 
		28.5, 
		18.1, 
		12.9, 
		21.6, 
		4.794216089254257, 
		23.50578391074574, 
		8.9, 
		37.0, 
		84.0, 
		37.886975033868794, 
		46.11302496613121, 
		19.7],
	
	
	[new Date(1990, 3 , 1), 
		34.8, 
		17.5, 
		67.3, 
		28.400000000000006, 
		18.1, 
		12.9, 
		21.3, 
		4.743394010569583, 
		23.256605989430415, 
		8.8, 
		37.4, 
		86.8, 
		39.14987420166442, 
		47.65012579833559, 
		19.7],
	
	
	[new Date(1990, 4 , 1), 
		35.0, 
		17.6, 
		67.3, 
		28.19999999999999, 
		18.200000000000003, 
		13.1, 
		21.5, 
		4.726453317674691, 
		23.17354668232531, 
		8.8, 
		37.5, 
		86.4, 
		38.96946003483647, 
		47.43053996516354, 
		19.7],
	
	
	[new Date(1990, 5 , 1), 
		35.3, 
		17.6, 
		67.7, 
		28.19999999999999, 
		18.3, 
		13.2, 
		21.5, 
		4.8111567821491485, 
		23.58884321785085, 
		8.9, 
		37.7, 
		86.1, 
		38.83414940971551, 
		47.265850590284494, 
		20.0],
	
	
	[new Date(1990, 6 , 1), 
		35.5, 
		17.7, 
		67.7, 
		28.19999999999999, 
		18.4, 
		13.3, 
		21.6, 
		4.845038167938932, 
		23.75496183206107, 
		8.5, 
		38.1, 
		85.7, 
		38.653735242887564, 
		47.046264757112446, 
		19.7],
	
	
	[new Date(1990, 7 , 1), 
		35.7, 
		17.8, 
		67.6, 
		28.400000000000006, 
		18.3, 
		13.5, 
		21.6, 
		4.878919553728713, 
		23.921080446271286, 
		8.8, 
		38.3, 
		85.5, 
		38.56352815947359, 
		46.936471840526416, 
		19.7],
	
	
	[new Date(1990, 8 , 1), 
		35.8, 
		17.8, 
		67.5, 
		28.5, 
		18.3, 
		13.5, 
		21.7, 
		4.878919553728714, 
		23.921080446271286, 
		9.0, 
		38.5, 
		85.4, 
		38.518424617766605, 
		46.88157538223341, 
		19.6],
	
	
	[new Date(1990, 9 , 1), 
		36.7, 
		17.8, 
		68.0, 
		28.700000000000003, 
		18.299999999999997, 
		13.6, 
		21.8, 
		4.895860246623606, 
		24.004139753376396, 
		9.1, 
		38.6, 
		86.8, 
		39.14987420166442, 
		47.65012579833559, 
		20.1],
	
	
	[new Date(1990, 10 , 1), 
		36.7, 
		17.7, 
		68.1, 
		28.799999999999997, 
		18.1, 
		13.7, 
		21.9, 
		4.878919553728715, 
		23.92108044627129, 
		9.3, 
		38.8, 
		88.2, 
		39.78132378556223, 
		48.418676214437774, 
		19.9],
	
	
	[new Date(1990, 11 , 1), 
		36.9, 
		17.8, 
		67.4, 
		29.0, 
		18.1, 
		13.7, 
		22.0, 
		4.8619788608338235, 
		23.83802113916618, 
		9.3, 
		38.8, 
		87.8, 
		39.600909618734285, 
		48.19909038126572, 
		20.0],
	
	
	[new Date(1991, 0 , 1), 
		36.8, 
		17.5, 
		68.0, 
		29.400000000000006, 
		19.0, 
		12.8, 
		22.1, 
		4.760783736004714, 
		23.939216263995284, 
		9.2, 
		40.0, 
		87.6, 
		40.50492363153401, 
		47.09507636846599, 
		20.1],
	
	
	[new Date(1991, 1 , 1), 
		36.8, 
		17.4, 
		67.9, 
		29.39999999999999, 
		18.8, 
		12.7, 
		22.2, 
		4.744195639363583, 
		23.85580436063642, 
		9.1, 
		40.2, 
		87.2, 
		40.31996964234893, 
		46.88003035765108, 
		20.2],
	
	
	[new Date(1991, 2 , 1), 
		36.6, 
		17.4, 
		67.7, 
		29.0, 
		18.9, 
		12.6, 
		22.3, 
		4.727607542722452, 
		23.772392457277547, 
		9.4, 
		40.3, 
		86.6, 
		40.042538658571296, 
		46.557461341428706, 
		20.3],
	
	
	[new Date(1991, 3 , 1), 
		36.7, 
		17.4, 
		67.3, 
		29.000000000000014, 
		18.8, 
		12.7, 
		22.6, 
		4.677843252799057, 
		23.522156747200942, 
		9.2, 
		40.1, 
		86.5, 
		39.99630016127503, 
		46.503699838724984, 
		20.2],
	
	
	[new Date(1991, 4 , 1), 
		36.7, 
		17.4, 
		67.4, 
		28.999999999999986, 
		18.8, 
		12.7, 
		22.7, 
		4.644667059516796, 
		23.355332940483212, 
		9.0, 
		40.2, 
		86.9, 
		40.18125415046012, 
		46.7187458495399, 
		20.3],
	
	
	[new Date(1991, 5 , 1), 
		36.6, 
		17.4, 
		67.2, 
		29.30000000000001, 
		18.8, 
		12.7, 
		22.9, 
		4.644667059516795, 
		23.35533294048321, 
		9.2, 
		40.2, 
		87.4, 
		40.412446636941475, 
		46.98755336305854, 
		20.3],
	
	
	[new Date(1991, 6 , 1), 
		36.2, 
		17.4, 
		67.4, 
		29.19999999999999, 
		18.8, 
		12.8, 
		22.8, 
		4.661255156157926, 
		23.438744843842073, 
		9.3, 
		40.3, 
		88.2, 
		40.78235461531165, 
		47.41764538468836, 
		20.4],
	
	
	[new Date(1991, 7 , 1), 
		36.0, 
		17.5, 
		67.4, 
		29.19999999999999, 
		18.8, 
		12.8, 
		22.7, 
		4.661255156157926, 
		23.438744843842073, 
		9.6, 
		40.5, 
		88.6, 
		40.96730860449673, 
		47.63269139550327, 
		20.7],
	
	
	[new Date(1991, 8 , 1), 
		35.6, 
		17.5, 
		67.3, 
		29.60000000000001, 
		18.7, 
		12.8, 
		22.9, 
		4.677843252799058, 
		23.52215674720095, 
		9.4, 
		40.5, 
		88.8, 
		41.059785599089274, 
		47.74021440091073, 
		20.8],
	
	
	[new Date(1991, 9 , 1), 
		35.4, 
		17.6, 
		67.5, 
		29.400000000000006, 
		18.6, 
		12.9, 
		22.8, 
		4.661255156157926, 
		23.438744843842073, 
		9.3, 
		41.0, 
		88.6, 
		40.96730860449673, 
		47.63269139550327, 
		20.8],
	
	
	[new Date(1991, 10 , 1), 
		35.1, 
		17.7, 
		67.5, 
		29.599999999999994, 
		18.6, 
		13.1, 
		22.7, 
		4.727607542722453, 
		23.772392457277554, 
		9.3, 
		41.0, 
		88.6, 
		40.96730860449673, 
		47.63269139550327, 
		21.0],
	
	
	[new Date(1991, 11 , 1), 
		35.0, 
		17.3, 
		67.5, 
		29.900000000000006, 
		18.6, 
		13.2, 
		22.5, 
		4.727607542722453, 
		23.77239245727755, 
		9.3, 
		41.1, 
		88.5, 
		40.921070107200464, 
		47.57892989279955, 
		21.0],
	
	
	[new Date(1992, 0 , 1), 
		34.5, 
		17.4, 
		67.8, 
		29.80000000000001, 
		18.900000000000002, 
		12.2, 
		22.5, 
		4.8801261829652995, 
		23.7198738170347, 
		9.5, 
		41.1, 
		88.9, 
		41.217196490897095, 
		47.68280350910292, 
		21.2],
	
	
	[new Date(1992, 1 , 1), 
		34.2, 
		17.2, 
		67.9, 
		29.799999999999997, 
		18.8, 
		12.3, 
		22.3, 
		4.914252939489533, 
		23.885747060510464, 
		9.7, 
		41.1, 
		89.1, 
		41.309923592113954, 
		47.79007640788604, 
		21.2],
	
	
	[new Date(1992, 2 , 1), 
		34.1, 
		17.2, 
		68.4, 
		30.19999999999999, 
		18.799999999999997, 
		12.4, 
		22.2, 
		4.93131631775165, 
		23.968683682248347, 
		9.5, 
		41.2, 
		89.2, 
		41.356287142722394, 
		47.843712857277616, 
		21.1],
	
	
	[new Date(1992, 3 , 1), 
		34.0, 
		17.2, 
		68.0, 
		29.89999999999999, 
		18.8, 
		12.3, 
		22.8, 
		4.845999426441067, 
		23.55400057355893, 
		9.6, 
		41.3, 
		89.5, 
		41.49537779454769, 
		48.004622205452314, 
		21.2],
	
	
	[new Date(1992, 4 , 1), 
		33.9, 
		17.2, 
		68.2, 
		29.799999999999997, 
		18.8, 
		12.3, 
		22.8, 
		4.897189561227416, 
		23.80281043877258, 
		9.5, 
		41.3, 
		89.4, 
		41.44901424393926, 
		47.95098575606075, 
		21.3],
	
	
	[new Date(1992, 5 , 1), 
		33.9, 
		17.2, 
		68.1, 
		29.799999999999997, 
		18.8, 
		12.3, 
		22.6, 
		4.931316317751649, 
		23.968683682248347, 
		9.5, 
		41.4, 
		89.2, 
		41.356287142722394, 
		47.843712857277616, 
		21.4],
	
	
	[new Date(1992, 6 , 1), 
		33.9, 
		17.3, 
		68.0, 
		29.900000000000006, 
		18.8, 
		12.3, 
		22.7, 
		4.948379696013766, 
		24.051620303986233, 
		9.6, 
		41.3, 
		88.7, 
		41.12446938968023, 
		47.57553061031978, 
		21.5],
	
	
	[new Date(1992, 7 , 1), 
		33.6, 
		17.3, 
		67.8, 
		29.80000000000001, 
		18.700000000000003, 
		12.4, 
		22.7, 
		4.982506452537998, 
		24.217493547462, 
		9.7, 
		41.8, 
		88.6, 
		41.07810583907179, 
		47.52189416092821, 
		21.5],
	
	
	[new Date(1992, 8 , 1), 
		32.9, 
		17.1, 
		67.7, 
		30.099999999999994, 
		18.9, 
		12.4, 
		22.6, 
		4.982506452537997, 
		24.217493547461995, 
		9.7, 
		42.0, 
		87.7, 
		40.66083388359589, 
		47.03916611640411, 
		21.5],
	
	
	[new Date(1992, 9 , 1), 
		34.0, 
		17.0, 
		67.3, 
		29.5, 
		19.0, 
		12.3, 
		22.5, 
		5.050759965586464, 
		24.549240034413533, 
		9.7, 
		41.5, 
		86.7, 
		40.19719837751156, 
		46.50280162248844, 
		21.5],
	
	
	[new Date(1992, 10 , 1), 
		34.6, 
		17.1, 
		67.0, 
		29.400000000000006, 
		19.0, 
		12.3, 
		22.5, 
		5.016633209062231, 
		24.383366790937764, 
		9.7, 
		41.4, 
		86.8, 
		40.243561928119995, 
		46.55643807188001, 
		21.4],
	
	
	[new Date(1992, 11 , 1), 
		34.8, 
		17.1, 
		67.1, 
		29.500000000000014, 
		19.2, 
		12.2, 
		22.3, 
		5.0507599655864635, 
		24.54924003441353, 
		9.7, 
		41.5, 
		86.6, 
		40.15083482690313, 
		46.44916517309687, 
		21.5],
	
	
	[new Date(1993, 0 , 1), 
		35.5, 
		17.1, 
		65.8, 
		29.799999999999997, 
		19.7, 
		12.3, 
		22.6, 
		5.097028862478778, 
		24.00297113752122, 
		9.9, 
		41.3, 
		84.6, 
		38.17235224117413, 
		46.42764775882584, 
		21.5],
	
	
	[new Date(1993, 1 , 1), 
		36.0, 
		17.1, 
		66.3, 
		29.799999999999997, 
		19.5, 
		12.5, 
		22.6, 
		5.132059988681381, 
		24.167940011318617, 
		9.9, 
		41.7, 
		84.8, 
		38.26259420864736, 
		46.53740579135262, 
		21.5],
	
	
	[new Date(1993, 2 , 1), 
		35.6, 
		16.9, 
		66.7, 
		29.60000000000001, 
		19.5, 
		12.6, 
		22.5, 
		5.149575551782683, 
		24.250424448217316, 
		9.8, 
		41.7, 
		84.5, 
		38.12723125743752, 
		46.37276874256246, 
		21.5],
	
	
	[new Date(1993, 3 , 1), 
		35.4, 
		17.1, 
		67.4, 
		29.299999999999997, 
		19.599999999999998, 
		12.7, 
		22.4, 
		5.167091114883984, 
		24.332908885116016, 
		9.8, 
		41.6, 
		84.4, 
		38.08211027370091, 
		46.31788972629907, 
		21.8],
	
	
	[new Date(1993, 4 , 1), 
		35.1, 
		17.1, 
		67.5, 
		29.0, 
		19.599999999999998, 
		12.8, 
		22.3, 
		5.149575551782683, 
		24.250424448217316, 
		9.8, 
		41.8, 
		84.6, 
		38.17235224117413, 
		46.42764775882584, 
		21.8],
	
	
	[new Date(1993, 5 , 1), 
		34.7, 
		17.1, 
		68.3, 
		29.299999999999997, 
		19.5, 
		12.9, 
		22.0, 
		5.237153367289191, 
		24.662846632710806, 
		10.0, 
		42.0, 
		84.3, 
		38.036989289964296, 
		46.26301071003568, 
		21.8],
	
	
	[new Date(1993, 6 , 1), 
		34.6, 
		16.8, 
		68.4, 
		28.89999999999999, 
		19.9, 
		12.5, 
		22.2, 
		5.114544425580079, 
		24.085455574419917, 
		9.5, 
		41.9, 
		84.0, 
		37.90162633875446, 
		46.098373661245525, 
		21.8],
	
	
	[new Date(1993, 7 , 1), 
		34.1, 
		16.7, 
		67.8, 
		28.900000000000006, 
		19.799999999999997, 
		12.5, 
		22.2, 
		5.097028862478778, 
		24.002971137521218, 
		9.8, 
		41.7, 
		83.6, 
		37.72114240380801, 
		45.87885759619197, 
		21.7],
	
	
	[new Date(1993, 8 , 1), 
		33.9, 
		16.7, 
		67.7, 
		28.89999999999999, 
		19.9, 
		12.5, 
		22.1, 
		5.149575551782683, 
		24.250424448217316, 
		10.0, 
		41.9, 
		83.6, 
		37.72114240380801, 
		45.87885759619197, 
		21.8],
	
	
	[new Date(1993, 9 , 1), 
		33.6, 
		16.5, 
		67.4, 
		29.69999999999999, 
		19.700000000000003, 
		12.5, 
		22.2, 
		5.167091114883985, 
		24.332908885116016, 
		9.8, 
		42.1, 
		84.3, 
		38.036989289964296, 
		46.26301071003568, 
		21.9],
	
	
	[new Date(1993, 10 , 1), 
		33.0, 
		16.7, 
		67.5, 
		29.0, 
		19.7, 
		12.7, 
		22.1, 
		5.184606677985286, 
		24.415393322014715, 
		9.8, 
		42.2, 
		83.7, 
		37.766263387544626, 
		45.93373661245536, 
		21.9],
	
	
	[new Date(1993, 11 , 1), 
		32.3, 
		16.6, 
		67.5, 
		28.80000000000001, 
		19.799999999999997, 
		12.6, 
		22.1, 
		5.219637804187889, 
		24.580362195812107, 
		9.8, 
		42.2, 
		82.8, 
		37.36017453391511, 
		45.43982546608487, 
		21.9],
	
	
	[new Date(1994, 0 , 1), 
		31.7, 
		16.5, 
		67.0, 
		29.0, 
		19.9, 
		13.0, 
		22.0, 
		5.320535714285713, 
		24.979464285714283, 
		9.7, 
		42.6, 
		83.5, 
		37.57830431341511, 
		45.921695686584876, 
		21.7],
	
	
	[new Date(1994, 1 , 1), 
		31.6, 
		16.4, 
		66.5, 
		29.0, 
		19.799999999999997, 
		13.0, 
		21.9, 
		5.30297619047619, 
		24.897023809523812, 
		9.6, 
		42.5, 
		83.6, 
		37.62330827067668, 
		45.9766917293233, 
		21.8],
	
	
	[new Date(1994, 2 , 1), 
		31.4, 
		16.4, 
		66.7, 
		29.30000000000001, 
		19.8, 
		12.8, 
		21.9, 
		5.30297619047619, 
		24.897023809523812, 
		9.7, 
		42.5, 
		83.8, 
		37.71331618519983, 
		46.086683814800146, 
		21.7],
	
	
	[new Date(1994, 3 , 1), 
		31.7, 
		16.4, 
		66.9, 
		29.39999999999999, 
		19.8, 
		12.0, 
		22.3, 
		5.285416666666665, 
		24.81458333333333, 
		9.7, 
		42.7, 
		83.8, 
		37.71331618519983, 
		46.086683814800146, 
		21.7],
	
	
	[new Date(1994, 4 , 1), 
		31.4, 
		16.5, 
		67.0, 
		29.200000000000003, 
		19.6, 
		12.1, 
		21.9, 
		5.390773809523809, 
		25.309226190476192, 
		9.7, 
		42.5, 
		83.6, 
		37.62330827067668, 
		45.9766917293233, 
		21.8],
	
	
	[new Date(1994, 5 , 1), 
		31.1, 
		16.4, 
		66.8, 
		29.000000000000014, 
		19.6, 
		12.1, 
		21.9, 
		5.408333333333333, 
		25.39166666666667, 
		9.8, 
		42.5, 
		83.7, 
		37.66831222793826, 
		46.03168777206172, 
		21.9],
	
	
	[new Date(1994, 6 , 1), 
		31.0, 
		16.4, 
		67.0, 
		28.69999999999999, 
		19.4, 
		12.3, 
		21.8, 
		5.373214285714284, 
		25.22678571428571, 
		9.3, 
		42.8, 
		84.6, 
		38.07334784329243, 
		46.52665215670755, 
		21.7],
	
	
	[new Date(1994, 7 , 1), 
		30.9, 
		16.4, 
		67.4, 
		28.69999999999999, 
		19.4, 
		12.3, 
		21.8, 
		5.443452380952379, 
		25.556547619047613, 
		9.6, 
		42.0, 
		84.3, 
		37.938335971507705, 
		46.36166402849227, 
		21.6],
	
	
	[new Date(1994, 8 , 1), 
		30.5, 
		16.4, 
		67.6, 
		28.700000000000003, 
		19.5, 
		12.4, 
		21.8, 
		5.461011904761903, 
		25.63898809523809, 
		9.4, 
		42.7, 
		84.6, 
		38.07334784329243, 
		46.52665215670755, 
		22.0],
	
	
	[new Date(1994, 9 , 1), 
		30.1, 
		16.4, 
		68.1, 
		28.400000000000006, 
		19.2, 
		12.2, 
		21.7, 
		5.496130952380951, 
		25.803869047619045, 
		10.0, 
		42.6, 
		84.9, 
		38.20835971507716, 
		46.691640284922826, 
		21.7],
	
	
	[new Date(1994, 10 , 1), 
		29.7, 
		16.3, 
		69.1, 
		28.700000000000003, 
		19.2, 
		12.2, 
		21.7, 
		5.513690476190475, 
		25.886309523809523, 
		10.0, 
		42.7, 
		85.2, 
		38.343371586861885, 
		46.856628413138104, 
		22.0],
	
	
	[new Date(1994, 11 , 1), 
		29.2, 
		16.4, 
		68.8, 
		28.60000000000001, 
		19.0, 
		12.3, 
		21.6, 
		5.5663690476190455, 
		26.133630952380948, 
		9.9, 
		42.6, 
		85.3, 
		38.388375544123456, 
		46.91162445587652, 
		21.8],
	
	
	[new Date(1995, 0 , 1), 
		28.7, 
		16.4, 
		68.5, 
		28.5, 
		19.1, 
		12.1, 
		21.0, 
		5.562777777777776, 
		26.73722222222222, 
		9.8, 
		42.8, 
		85.0, 
		37.72011030135908, 
		47.27988969864093, 
		21.7],
	
	
	[new Date(1995, 1 , 1), 
		28.5, 
		16.4, 
		68.3, 
		28.400000000000006, 
		19.1, 
		12.1, 
		21.0, 
		5.579999999999999, 
		26.819999999999997, 
		9.9, 
		42.7, 
		84.6, 
		37.542603899940914, 
		47.05739610005909, 
		21.8],
	
	
	[new Date(1995, 2 , 1), 
		28.4, 
		16.3, 
		68.4, 
		28.599999999999994, 
		18.9, 
		12.1, 
		21.0, 
		5.614444444444444, 
		26.985555555555553, 
		9.8, 
		42.6, 
		84.7, 
		37.58698050029546, 
		47.11301949970455, 
		21.9],
	
	
	[new Date(1995, 3 , 1), 
		28.0, 
		16.4, 
		68.1, 
		28.5, 
		18.9, 
		12.1, 
		20.9, 
		5.597222222222221, 
		26.902777777777775, 
		9.7, 
		42.7, 
		84.8, 
		37.63135710064999, 
		47.168642899350004, 
		21.8],
	
	
	[new Date(1995, 4 , 1), 
		27.8, 
		16.4, 
		68.3, 
		28.500000000000014, 
		18.9, 
		12.0, 
		20.9, 
		5.648888888888889, 
		27.151111111111113, 
		9.9, 
		43.0, 
		83.7, 
		37.143214496750055, 
		46.55678550324995, 
		21.7],
	
	
	[new Date(1995, 5 , 1), 
		27.8, 
		16.3, 
		68.5, 
		28.60000000000001, 
		18.8, 
		12.0, 
		20.7, 
		5.648888888888887, 
		27.151111111111106, 
		9.7, 
		42.7, 
		84.3, 
		37.4094740988773, 
		46.89052590112271, 
		21.6],
	
	
	[new Date(1995, 6 , 1), 
		27.5, 
		16.0, 
		68.8, 
		28.400000000000006, 
		18.5, 
		12.0, 
		20.5, 
		5.7349999999999985, 
		27.564999999999994, 
		9.8, 
		42.4, 
		84.7, 
		37.58698050029546, 
		47.11301949970455, 
		21.8],
	
	
	[new Date(1995, 7 , 1), 
		27.5, 
		16.0, 
		69.2, 
		28.5, 
		18.9, 
		12.1, 
		20.5, 
		5.717777777777777, 
		27.482222222222223, 
		9.6, 
		42.0, 
		84.8, 
		37.63135710064999, 
		47.168642899350004, 
		21.7],
	
	
	[new Date(1995, 8 , 1), 
		27.3, 
		16.1, 
		69.2, 
		28.099999999999994, 
		18.799999999999997, 
		12.1, 
		20.4, 
		5.734999999999999, 
		27.565, 
		9.8, 
		42.9, 
		84.8, 
		37.63135710064999, 
		47.168642899350004, 
		21.6],
	
	
	[new Date(1995, 9 , 1), 
		26.9, 
		16.0, 
		69.2, 
		28.099999999999994, 
		18.5, 
		12.2, 
		20.3, 
		5.752222222222223, 
		27.64777777777778, 
		9.9, 
		42.6, 
		84.5, 
		37.498227299586375, 
		47.001772700413625, 
		21.7],
	
	
	[new Date(1995, 10 , 1), 
		26.8, 
		16.0, 
		69.2, 
		28.0, 
		18.5, 
		12.2, 
		20.2, 
		5.82111111111111, 
		27.978888888888886, 
		9.8, 
		42.5, 
		84.7, 
		37.58698050029546, 
		47.11301949970455, 
		21.7],
	
	
	[new Date(1995, 11 , 1), 
		26.4, 
		15.9, 
		69.2, 
		28.099999999999994, 
		18.299999999999997, 
		12.1, 
		20.2, 
		5.803888888888888, 
		27.89611111111111, 
		10.1, 
		42.7, 
		84.5, 
		37.498227299586375, 
		47.001772700413625, 
		21.7],
	
	
	[new Date(1996, 0 , 1), 
		26.1, 
		16.1, 
		68.7, 
		28.099999999999994, 
		18.5, 
		12.3, 
		20.3, 
		5.564253713746758, 
		28.93574628625324, 
		10.0, 
		42.8, 
		84.9, 
		37.937207943925245, 
		46.96279205607477, 
		21.9],
	
	
	[new Date(1996, 1 , 1), 
		25.7, 
		16.1, 
		68.6, 
		28.000000000000014, 
		18.7, 
		12.3, 
		20.3, 
		5.596510257014855, 
		29.103489742985147, 
		10.1, 
		42.8, 
		85.4, 
		38.1606308411215, 
		47.23936915887851, 
		21.9],
	
	
	[new Date(1996, 2 , 1), 
		25.2, 
		16.1, 
		68.5, 
		27.80000000000001, 
		18.5, 
		12.3, 
		20.6, 
		5.580381985380806, 
		29.019618014619194, 
		10.2, 
		43.0, 
		85.7, 
		38.294684579439256, 
		47.40531542056075, 
		21.8],
	
	
	[new Date(1996, 3 , 1), 
		25.4, 
		16.0, 
		68.2, 
		27.599999999999994, 
		18.4, 
		12.3, 
		20.1, 
		5.644895071917, 
		29.355104928082998, 
		10.2, 
		42.9, 
		85.1, 
		38.02657710280374, 
		47.07342289719626, 
		21.7],
	
	
	[new Date(1996, 4 , 1), 
		25.3, 
		16.0, 
		68.1, 
		27.5, 
		18.3, 
		12.3, 
		20.2, 
		5.661023343551047, 
		29.438976656448947, 
		10.1, 
		43.0, 
		84.9, 
		37.937207943925245, 
		46.96279205607477, 
		21.7],
	
	
	[new Date(1996, 5 , 1), 
		25.1, 
		16.0, 
		68.1, 
		27.5, 
		18.2, 
		12.3, 
		20.1, 
		5.725536430087243, 
		29.774463569912758, 
		10.1, 
		42.9, 
		85.4, 
		38.1606308411215, 
		47.23936915887851, 
		21.8],
	
	
	[new Date(1996, 6 , 1), 
		24.9, 
		16.0, 
		67.9, 
		27.599999999999994, 
		18.0, 
		12.4, 
		20.1, 
		5.741664701721292, 
		29.85833529827871, 
		10.1, 
		43.2, 
		85.4, 
		38.1606308411215, 
		47.23936915887851, 
		21.9],
	
	
	[new Date(1996, 7 , 1), 
		24.8, 
		15.9, 
		67.5, 
		27.89999999999999, 
		18.2, 
		12.3, 
		20.1, 
		5.741664701721292, 
		29.85833529827871, 
		10.0, 
		43.4, 
		85.6, 
		38.25, 
		47.349999999999994, 
		21.9],
	
	
	[new Date(1996, 8 , 1), 
		24.7, 
		15.9, 
		67.3, 
		27.799999999999997, 
		18.2, 
		12.5, 
		20.1, 
		5.790049516623437, 
		30.10995048337656, 
		10.1, 
		43.4, 
		86.3, 
		38.56279205607477, 
		47.737207943925235, 
		21.9],
	
	
	[new Date(1996, 9 , 1), 
		24.7, 
		15.8, 
		66.3, 
		28.10000000000001, 
		17.8, 
		12.3, 
		20.1, 
		5.773921244989388, 
		30.02607875501061, 
		10.3, 
		43.5, 
		86.0, 
		38.428738317757016, 
		47.57126168224299, 
		21.9],
	
	
	[new Date(1996, 10 , 1), 
		23.7, 
		15.8, 
		66.8, 
		28.10000000000001, 
		17.9, 
		12.4, 
		20.0, 
		5.790049516623437, 
		30.10995048337656, 
		10.3, 
		43.8, 
		85.8, 
		38.33936915887851, 
		47.46063084112149, 
		21.8],
	
	
	[new Date(1996, 11 , 1), 
		24.6, 
		15.7, 
		66.9, 
		28.299999999999997, 
		18.0, 
		12.3, 
		20.1, 
		5.806177788257486, 
		30.193822211742514, 
		9.9, 
		44.0, 
		86.2, 
		38.51810747663552, 
		47.68189252336449, 
		21.9],
	
	
	[new Date(1997, 0 , 1), 
		24.5, 
		15.7, 
		67.4, 
		28.299999999999997, 
		18.1, 
		12.5, 
		19.8, 
		5.896473265073948, 
		30.603526734926053, 
		10.3, 
		44.3, 
		86.2, 
		38.50844644077726, 
		47.69155355922273, 
		21.8],
	
	
	[new Date(1997, 1 , 1), 
		24.4, 
		15.7, 
		67.5, 
		28.299999999999997, 
		18.1, 
		12.5, 
		19.7, 
		5.9287827076222985, 
		30.771217292377706, 
		10.1, 
		44.3, 
		86.0, 
		38.41909969729518, 
		47.58090030270481, 
		21.7],
	
	
	[new Date(1997, 2 , 1), 
		24.1, 
		15.7, 
		67.7, 
		28.5, 
		18.1, 
		12.5, 
		19.7, 
		5.9287827076222985, 
		30.771217292377706, 
		10.3, 
		44.6, 
		85.7, 
		38.28507958207206, 
		47.41492041792794, 
		21.8],
	
	
	[new Date(1997, 3 , 1), 
		23.7, 
		15.7, 
		67.7, 
		28.299999999999997, 
		17.9, 
		12.4, 
		19.6, 
		5.961092150170648, 
		30.938907849829352, 
		10.2, 
		44.6, 
		85.5, 
		38.195732838589976, 
		47.30426716141002, 
		21.8],
	
	
	[new Date(1997, 4 , 1), 
		23.6, 
		15.6, 
		67.0, 
		28.200000000000003, 
		17.8, 
		12.3, 
		19.5, 
		5.912627986348123, 
		30.687372013651878, 
		10.5, 
		45.0, 
		85.0, 
		37.97236597988477, 
		47.02763402011522, 
		21.8],
	
	
	[new Date(1997, 5 , 1), 
		23.2, 
		15.7, 
		66.6, 
		28.10000000000001, 
		17.7, 
		12.3, 
		19.6, 
		5.912627986348123, 
		30.687372013651878, 
		10.4, 
		45.2, 
		85.0, 
		37.97236597988477, 
		47.02763402011522, 
		21.8],
	
	
	[new Date(1997, 6 , 1), 
		23.4, 
		15.7, 
		66.1, 
		28.299999999999997, 
		17.7, 
		12.2, 
		19.7, 
		5.880318543799773, 
		30.51968145620023, 
		10.5, 
		45.2, 
		84.8, 
		37.88301923640269, 
		46.9169807635973, 
		21.6],
	
	
	[new Date(1997, 7 , 1), 
		23.2, 
		15.7, 
		65.7, 
		28.099999999999994, 
		17.799999999999997, 
		12.1, 
		19.6, 
		5.896473265073948, 
		30.603526734926053, 
		10.9, 
		45.8, 
		84.8, 
		37.88301923640269, 
		46.9169807635973, 
		21.6],
	
	
	[new Date(1997, 8 , 1), 
		23.2, 
		15.8, 
		65.5, 
		28.200000000000003, 
		18.0, 
		12.1, 
		19.7, 
		5.912627986348122, 
		30.687372013651874, 
		10.6, 
		45.3, 
		85.0, 
		37.97236597988477, 
		47.02763402011522, 
		21.6],
	
	
	[new Date(1997, 9 , 1), 
		23.2, 
		15.8, 
		65.4, 
		28.099999999999994, 
		17.5, 
		12.1, 
		19.7, 
		5.912627986348122, 
		30.687372013651874, 
		10.7, 
		45.4, 
		85.2, 
		38.06171272336685, 
		47.13828727663314, 
		21.6],
	
	
	[new Date(1997, 10 , 1), 
		23.1, 
		15.8, 
		65.1, 
		28.000000000000014, 
		17.6, 
		12.1, 
		19.7, 
		5.9449374288964725, 
		30.855062571103524, 
		10.7, 
		45.5, 
		85.3, 
		38.106386095107894, 
		47.1936139048921, 
		21.6],
	
	
	[new Date(1997, 11 , 1), 
		23.1, 
		15.8, 
		64.9, 
		27.799999999999997, 
		17.799999999999997, 
		12.1, 
		19.8, 
		5.9287827076222985, 
		30.771217292377706, 
		10.4, 
		45.9, 
		85.3, 
		38.106386095107894, 
		47.1936139048921, 
		21.8],
	
	
	[new Date(1998, 0 , 1), 
		22.8, 
		15.8, 
		65.1, 
		28.10000000000001, 
		18.2, 
		12.0, 
		18.9, 
		6.2596166703811, 
		31.040383329618898, 
		10.4, 
		45.9, 
		85.4, 
		37.69707088459285, 
		47.70292911540713, 
		21.7],
	
	
	[new Date(1998, 1 , 1), 
		23.1, 
		15.9, 
		65.0, 
		27.69999999999999, 
		17.8, 
		12.0, 
		19.1, 
		6.242834856251391, 
		30.957165143748597, 
		10.5, 
		46.1, 
		85.5, 
		37.741212653778554, 
		47.758787346221425, 
		21.7],
	
	
	[new Date(1998, 2 , 1), 
		22.9, 
		15.9, 
		64.7, 
		27.799999999999997, 
		17.9, 
		12.0, 
		19.0, 
		6.259616670381099, 
		31.04038332961889, 
		10.3, 
		46.1, 
		85.6, 
		37.785354422964254, 
		47.81464557703571, 
		21.6],
	
	
	[new Date(1998, 3 , 1), 
		22.8, 
		15.9, 
		64.5, 
		27.799999999999997, 
		17.9, 
		12.1, 
		18.9, 
		6.2596166703811, 
		31.040383329618898, 
		10.7, 
		46.3, 
		85.5, 
		37.741212653778554, 
		47.758787346221425, 
		21.7],
	
	
	[new Date(1998, 4 , 1), 
		22.8, 
		15.9, 
		64.5, 
		27.89999999999999, 
		17.9, 
		12.1, 
		18.9, 
		6.276398484510808, 
		31.123601515489185, 
		10.6, 
		46.6, 
		85.8, 
		37.87363796133567, 
		47.9263620386643, 
		21.8],
	
	
	[new Date(1998, 5 , 1), 
		22.6, 
		15.9, 
		64.3, 
		27.89999999999999, 
		17.799999999999997, 
		12.1, 
		19.0, 
		6.293180298640515, 
		31.20681970135948, 
		10.7, 
		46.7, 
		85.4, 
		37.69707088459285, 
		47.70292911540713, 
		21.8],
	
	
	[new Date(1998, 6 , 1), 
		22.6, 
		15.8, 
		64.1, 
		27.700000000000003, 
		18.1, 
		12.1, 
		19.0, 
		6.276398484510808, 
		31.123601515489185, 
		10.7, 
		47.0, 
		85.4, 
		37.69707088459285, 
		47.70292911540713, 
		21.8],
	
	
	[new Date(1998, 7 , 1), 
		22.7, 
		15.7, 
		64.1, 
		27.60000000000001, 
		18.1, 
		12.1, 
		19.0, 
		6.343525741029639, 
		31.45647425897035, 
		10.8, 
		47.5, 
		85.3, 
		37.65292911540714, 
		47.647070884592836, 
		21.8],
	
	
	[new Date(1998, 8 , 1), 
		22.7, 
		15.9, 
		64.0, 
		27.599999999999994, 
		18.2, 
		12.0, 
		19.0, 
		6.259616670381099, 
		31.04038332961889, 
		10.7, 
		47.2, 
		85.2, 
		37.60878734622143, 
		47.59121265377854, 
		21.7],
	
	
	[new Date(1998, 9 , 1), 
		22.7, 
		15.9, 
		63.9, 
		27.400000000000006, 
		17.799999999999997, 
		12.1, 
		18.9, 
		6.2596166703811, 
		31.040383329618898, 
		10.8, 
		47.4, 
		85.1, 
		37.564645577035726, 
		47.53535442296425, 
		21.8],
	
	
	[new Date(1998, 10 , 1), 
		22.6, 
		15.9, 
		64.1, 
		27.200000000000003, 
		18.1, 
		12.1, 
		18.9, 
		6.276398484510808, 
		31.123601515489185, 
		10.8, 
		47.5, 
		85.4, 
		37.69707088459285, 
		47.70292911540713, 
		21.8],
	
	
	[new Date(1998, 11 , 1), 
		22.9, 
		15.8, 
		64.4, 
		26.89999999999999, 
		18.0, 
		12.1, 
		18.9, 
		6.242834856251392, 
		30.957165143748604, 
		10.9, 
		47.4, 
		85.2, 
		37.60878734622143, 
		47.59121265377854, 
		21.7],
	
	
	[new Date(1999, 0 , 1), 
		22.6, 
		15.7, 
		63.7, 
		26.799999999999997, 
		18.0, 
		12.0, 
		18.8, 
		5.8855617257582225, 
		31.91443827424177, 
		10.9, 
		46.9, 
		85.1, 
		37.00789448162157, 
		48.09210551837843, 
		21.6],
	
	
	[new Date(1999, 1 , 1), 
		22.6, 
		15.6, 
		63.8, 
		26.80000000000001, 
		18.0, 
		12.0, 
		18.7, 
		5.901131994873986, 
		31.998868005126017, 
		10.9, 
		47.2, 
		85.1, 
		37.00789448162157, 
		48.09210551837843, 
		21.6],
	
	
	[new Date(1999, 2 , 1), 
		22.3, 
		15.7, 
		64.1, 
		27.0, 
		17.9, 
		12.0, 
		18.8, 
		5.932272533105509, 
		32.16772746689448, 
		10.8, 
		47.1, 
		85.5, 
		37.18184463194647, 
		48.31815536805354, 
		21.7],
	
	
	[new Date(1999, 3 , 1), 
		22.5, 
		15.7, 
		64.6, 
		27.10000000000001, 
		17.799999999999997, 
		12.1, 
		18.9, 
		5.916702263989748, 
		32.08329773601025, 
		10.8, 
		47.6, 
		85.7, 
		37.26881970710892, 
		48.43118029289109, 
		21.8],
	
	
	[new Date(1999, 4 , 1), 
		22.4, 
		15.7, 
		64.6, 
		27.400000000000006, 
		17.700000000000003, 
		12.1, 
		19.1, 
		6.025694147800085, 
		32.67430585219991, 
		10.6, 
		47.7, 
		85.8, 
		37.31230724469014, 
		48.487692755309865, 
		21.7],
	
	
	[new Date(1999, 5 , 1), 
		22.5, 
		15.7, 
		64.7, 
		27.5, 
		17.5, 
		12.3, 
		18.9, 
		6.010123878684323, 
		32.589876121315676, 
		11.0, 
		47.6, 
		86.0, 
		37.39928231985259, 
		48.60071768014742, 
		21.8],
	
	
	[new Date(1999, 6 , 1), 
		22.4, 
		15.7, 
		64.8, 
		27.5, 
		17.200000000000003, 
		12.1, 
		18.7, 
		6.072404955147372, 
		32.92759504485262, 
		11.0, 
		47.7, 
		86.0, 
		37.39928231985259, 
		48.60071768014742, 
		21.7],
	
	
	[new Date(1999, 7 , 1), 
		22.5, 
		15.7, 
		65.1, 
		27.700000000000003, 
		17.2, 
		12.0, 
		18.9, 
		6.119115762494661, 
		33.18088423750534, 
		11.0, 
		48.3, 
		85.7, 
		37.26881970710892, 
		48.43118029289109, 
		21.7],
	
	
	[new Date(1999, 8 , 1), 
		22.5, 
		15.8, 
		65.6, 
		27.400000000000006, 
		17.200000000000003, 
		11.9, 
		18.9, 
		6.134686031610423, 
		33.26531396838957, 
		11.0, 
		47.6, 
		86.0, 
		37.39928231985259, 
		48.60071768014742, 
		22.0],
	
	
	[new Date(1999, 9 , 1), 
		22.7, 
		15.9, 
		65.9, 
		27.599999999999994, 
		17.1, 
		11.9, 
		19.1, 
		6.290388722768047, 
		34.10961127723195, 
		10.9, 
		48.0, 
		86.6, 
		37.66020754533993, 
		48.93979245466007, 
		22.1],
	
	
	[new Date(1999, 10 , 1), 
		22.9, 
		15.9, 
		66.0, 
		27.799999999999997, 
		16.9, 
		12.0, 
		19.1, 
		6.228107646304998, 
		33.771892353695, 
		10.9, 
		48.1, 
		87.1, 
		37.87764523324605, 
		49.22235476675395, 
		22.2],
	
	
	[new Date(1999, 11 , 1), 
		23.2, 
		15.9, 
		65.5, 
		27.89999999999999, 
		17.1, 
		12.0, 
		19.3, 
		6.337099530115336, 
		34.362900469884664, 
		11.0, 
		47.9, 
		87.1, 
		37.87764523324605, 
		49.22235476675395, 
		22.2],
	
	
	[new Date(2000, 0 , 1), 
		23.6, 
		16.1, 
		66.0, 
		27.60000000000001, 
		16.5, 
		12.3, 
		19.4, 
		5.599678456591641, 
		34.90032154340836, 
		11.3, 
		47.9, 
		87.0, 
		37.52012761565169, 
		49.47987238434831, 
		22.2],
	
	
	[new Date(2000, 1 , 1), 
		23.8, 
		16.1, 
		65.9, 
		27.900000000000006, 
		16.4, 
		12.3, 
		19.5, 
		5.613504823151127, 
		34.98649517684888, 
		11.3, 
		48.2, 
		87.4, 
		37.692633949516754, 
		49.707366050483245, 
		22.5],
	
	
	[new Date(2000, 2 , 1), 
		24.1, 
		16.2, 
		65.9, 
		27.999999999999986, 
		16.200000000000003, 
		12.4, 
		19.7, 
		5.613504823151126, 
		34.98649517684887, 
		11.3, 
		48.5, 
		87.7, 
		37.82201369991555, 
		49.877986300084444, 
		22.6],
	
	
	[new Date(2000, 3 , 1), 
		24.5, 
		16.1, 
		65.8, 
		28.099999999999994, 
		16.200000000000003, 
		12.4, 
		19.9, 
		5.682636655948555, 
		35.41736334405145, 
		11.2, 
		48.3, 
		88.4, 
		38.123899784179414, 
		50.276100215820584, 
		22.6],
	
	
	[new Date(2000, 4 , 1), 
		24.6, 
		16.0, 
		65.9, 
		27.89999999999999, 
		16.0, 
		12.5, 
		19.8, 
		5.69646302250804, 
		35.50353697749197, 
		11.1, 
		48.2, 
		88.4, 
		38.123899784179414, 
		50.276100215820584, 
		22.7],
	
	
	[new Date(2000, 5 , 1), 
		24.7, 
		16.2, 
		66.1, 
		28.299999999999997, 
		16.0, 
		12.5, 
		19.9, 
		5.69646302250804, 
		35.50353697749197, 
		11.1, 
		49.2, 
		88.8, 
		38.29640611804448, 
		50.50359388195552, 
		22.7],
	
	
	[new Date(2000, 6 , 1), 
		25.2, 
		16.3, 
		66.3, 
		28.200000000000003, 
		16.1, 
		12.5, 
		20.1, 
		5.724115755627011, 
		35.675884244372995, 
		10.9, 
		48.8, 
		89.2, 
		38.468912451909546, 
		50.73108754809045, 
		22.9],
	
	
	[new Date(2000, 7 , 1), 
		25.3, 
		16.3, 
		66.6, 
		28.30000000000001, 
		16.0, 
		12.6, 
		20.1, 
		5.710289389067525, 
		35.58971061093248, 
		11.0, 
		48.7, 
		89.4, 
		38.55516561884208, 
		50.84483438115792, 
		23.1],
	
	
	[new Date(2000, 8 , 1), 
		25.4, 
		16.4, 
		66.9, 
		28.39999999999999, 
		15.8, 
		12.7, 
		20.2, 
		5.807073954983924, 
		36.19292604501608, 
		11.1, 
		49.1, 
		89.8, 
		38.72767195270714, 
		51.07232804729285, 
		23.0],
	
	
	[new Date(2000, 9 , 1), 
		25.4, 
		16.4, 
		66.8, 
		28.500000000000014, 
		15.8, 
		12.7, 
		20.2, 
		5.890032154340837, 
		36.709967845659165, 
		11.2, 
		49.0, 
		89.8, 
		38.72767195270714, 
		51.07232804729285, 
		23.3],
	
	
	[new Date(2000, 10 , 1), 
		25.4, 
		16.4, 
		67.3, 
		28.500000000000014, 
		15.600000000000001, 
		12.7, 
		20.5, 
		5.862379421221866, 
		36.53762057877814, 
		11.3, 
		49.0, 
		89.8, 
		38.72767195270714, 
		51.07232804729285, 
		23.5],
	
	
	[new Date(2000, 11 , 1), 
		25.7, 
		16.3, 
		67.3, 
		28.5, 
		16.0, 
		12.6, 
		20.4, 
		5.890032154340838, 
		36.709967845659165, 
		11.4, 
		49.4, 
		89.9, 
		38.77079853617341, 
		51.12920146382659, 
		23.6],
	
	
	[new Date(2001, 0 , 1), 
		25.4, 
		16.5, 
		67.2, 
		28.799999999999997, 
		15.9, 
		12.6, 
		20.7, 
		6.0440334825773805, 
		36.25596651742262, 
		11.3, 
		49.7, 
		89.4, 
		38.47134613565415, 
		50.92865386434584, 
		23.6],
	
	
	[new Date(2001, 1 , 1), 
		25.4, 
		16.5, 
		67.2, 
		28.89999999999999, 
		15.899999999999999, 
		12.5, 
		20.8, 
		6.0583219778080615, 
		36.34167802219195, 
		11.4, 
		49.7, 
		89.6, 
		38.55741178696434, 
		51.04258821303564, 
		23.6],
	
	
	[new Date(2001, 2 , 1), 
		25.2, 
		16.5, 
		67.2, 
		29.099999999999994, 
		15.999999999999998, 
		12.4, 
		20.8, 
		6.129764453961458, 
		36.77023554603855, 
		11.5, 
		49.7, 
		89.5, 
		38.51437896130924, 
		50.985621038690745, 
		23.7],
	
	
	[new Date(2001, 3 , 1), 
		24.8, 
		16.5, 
		67.0, 
		29.099999999999994, 
		15.999999999999998, 
		12.4, 
		20.9, 
		6.101187463500099, 
		36.598812536499906, 
		11.6, 
		49.9, 
		89.4, 
		38.47134613565415, 
		50.92865386434584, 
		23.6],
	
	
	[new Date(2001, 4 , 1), 
		24.8, 
		16.5, 
		66.8, 
		29.10000000000001, 
		16.0, 
		12.3, 
		21.1, 
		6.144052949192136, 
		36.85594705080786, 
		11.5, 
		49.9, 
		89.1, 
		38.34224765868886, 
		50.75775234131112, 
		23.5],
	
	
	[new Date(2001, 5 , 1), 
		24.5, 
		16.5, 
		66.7, 
		29.200000000000003, 
		15.899999999999999, 
		12.3, 
		21.2, 
		6.158341444422815, 
		36.941658555577185, 
		11.6, 
		50.2, 
		89.0, 
		38.29921483303377, 
		50.70078516696621, 
		23.7],
	
	
	[new Date(2001, 6 , 1), 
		24.5, 
		16.5, 
		66.4, 
		29.299999999999997, 
		15.7, 
		12.3, 
		21.2, 
		6.172629939653496, 
		37.02737006034651, 
		11.8, 
		50.1, 
		88.7, 
		38.17011635606849, 
		50.5298836439315, 
		23.9],
	
	
	[new Date(2001, 7 , 1), 
		24.4, 
		16.5, 
		66.3, 
		29.299999999999997, 
		15.8, 
		12.2, 
		21.4, 
		6.172629939653495, 
		37.027370060346506, 
		11.9, 
		50.1, 
		88.9, 
		38.25618200737868, 
		50.64381799262131, 
		23.6],
	
	
	[new Date(2001, 8 , 1), 
		24.6, 
		16.5, 
		66.0, 
		29.200000000000003, 
		15.8, 
		12.2, 
		21.4, 
		6.158341444422816, 
		36.94165855557719, 
		11.7, 
		50.4, 
		89.0, 
		38.29921483303377, 
		50.70078516696621, 
		23.6],
	
	
	[new Date(2001, 9 , 1), 
		24.3, 
		16.3, 
		65.0, 
		27.700000000000003, 
		15.700000000000001, 
		11.9, 
		21.3, 
		6.0583219778080615, 
		36.34167802219195, 
		11.8, 
		50.4, 
		85.1, 
		36.620934632485096, 
		48.479065367514885, 
		23.4],
	
	
	[new Date(2001, 10 , 1), 
		24.5, 
		16.1, 
		63.8, 
		25.799999999999997, 
		15.7, 
		11.8, 
		21.2, 
		6.101187463500099, 
		36.598812536499906, 
		11.8, 
		50.5, 
		84.2, 
		36.233639201589256, 
		47.96636079841073, 
		23.2],
	
	
	[new Date(2001, 11 , 1), 
		24.5, 
		16.2, 
		63.9, 
		25.80000000000001, 
		15.799999999999999, 
		11.6, 
		21.3, 
		6.0583219778080615, 
		36.34167802219195, 
		11.9, 
		50.5, 
		84.3, 
		36.276672027244345, 
		48.02332797275564, 
		23.3],
	
	
	[new Date(2002, 0 , 1), 
		25.0, 
		16.2, 
		63.9, 
		25.700000000000003, 
		15.900000000000002, 
		11.7, 
		21.2, 
		6.161944799853774, 
		36.83805520014622, 
		11.9, 
		50.8, 
		85.0, 
		35.4985549132948, 
		49.5014450867052, 
		23.6],
	
	
	[new Date(2002, 1 , 1), 
		24.9, 
		16.2, 
		63.8, 
		25.799999999999997, 
		15.8, 
		11.7, 
		21.3, 
		6.26225552915372, 
		37.437744470846276, 
		12.0, 
		50.7, 
		85.2, 
		35.5820809248555, 
		49.61791907514451, 
		23.5],
	
	
	[new Date(2002, 2 , 1), 
		25.3, 
		16.3, 
		63.7, 
		25.799999999999997, 
		15.8, 
		11.8, 
		21.4, 
		6.290915737525133, 
		37.609084262474866, 
		12.0, 
		50.7, 
		85.6, 
		35.749132947976875, 
		49.85086705202312, 
		23.6],
	
	
	[new Date(2002, 3 , 1), 
		25.5, 
		16.3, 
		64.0, 
		26.10000000000001, 
		15.8, 
		11.8, 
		21.5, 
		6.41988667519649, 
		38.3801133248035, 
		12.1, 
		51.0, 
		86.2, 
		35.99971098265896, 
		50.20028901734104, 
		23.6],
	
	
	[new Date(2002, 4 , 1), 
		25.6, 
		16.3, 
		64.0, 
		26.200000000000003, 
		15.8, 
		11.8, 
		21.8, 
		6.4772070919393165, 
		38.72279290806068, 
		12.2, 
		51.1, 
		86.7, 
		36.2085260115607, 
		50.49147398843931, 
		23.6],
	
	
	[new Date(2002, 5 , 1), 
		26.1, 
		16.4, 
		64.1, 
		26.400000000000006, 
		15.899999999999999, 
		11.8, 
		21.7, 
		6.563187717053554, 
		39.23681228294644, 
		12.0, 
		51.3, 
		87.3, 
		36.45910404624278, 
		50.840895953757226, 
		23.6],
	
	
	[new Date(2002, 6 , 1), 
		26.3, 
		16.5, 
		64.4, 
		26.299999999999997, 
		15.799999999999999, 
		11.9, 
		21.7, 
		6.606178029610674, 
		39.49382197038932, 
		11.9, 
		51.5, 
		86.8, 
		36.25028901734104, 
		50.54971098265896, 
		23.8],
	
	
	[new Date(2002, 7 , 1), 
		26.4, 
		16.4, 
		64.1, 
		26.799999999999997, 
		15.899999999999999, 
		11.8, 
		21.7, 
		6.6634984463535005, 
		39.8365015536465, 
		12.0, 
		51.1, 
		86.7, 
		36.2085260115607, 
		50.49147398843931, 
		23.7],
	
	
	[new Date(2002, 8 , 1), 
		26.4, 
		16.5, 
		64.0, 
		26.700000000000003, 
		15.9, 
		11.9, 
		21.7, 
		6.6921586547249134, 
		40.00784134527508, 
		12.2, 
		51.6, 
		86.8, 
		36.25028901734104, 
		50.54971098265896, 
		23.8],
	
	
	[new Date(2002, 9 , 1), 
		26.7, 
		16.6, 
		64.2, 
		26.799999999999983, 
		15.799999999999999, 
		12.1, 
		21.9, 
		6.763809175653445, 
		40.436190824346546, 
		12.2, 
		51.7, 
		86.7, 
		36.2085260115607, 
		50.49147398843931, 
		23.9],
	
	
	[new Date(2002, 10 , 1), 
		27.0, 
		16.6, 
		63.9, 
		26.700000000000003, 
		15.8, 
		12.2, 
		21.9, 
		6.663498446353501, 
		39.8365015536465, 
		12.4, 
		51.8, 
		87.3, 
		36.45910404624278, 
		50.840895953757226, 
		23.8],
	
	
	[new Date(2002, 11 , 1), 
		27.0, 
		16.7, 
		64.2, 
		26.799999999999997, 
		15.900000000000002, 
		12.2, 
		21.9, 
		6.86411990495339, 
		41.03588009504661, 
		12.5, 
		51.1, 
		87.2, 
		36.41734104046243, 
		50.78265895953758, 
		23.9],
	
	
	[new Date(2003, 0 , 1), 
		27.3, 
		16.6, 
		63.8, 
		27.099999999999994, 
		15.9, 
		12.1, 
		22.1, 
		6.8515156855833625, 
		40.84848431441664, 
		12.2, 
		51.9, 
		87.9, 
		36.454811400620834, 
		51.44518859937918, 
		24.0],
	
	
	[new Date(2003, 1 , 1), 
		27.4, 
		16.6, 
		64.0, 
		27.200000000000003, 
		15.8, 
		12.2, 
		22.1, 
		6.736605569263307, 
		40.163394430736695, 
		12.5, 
		52.2, 
		88.0, 
		36.496284451133484, 
		51.50371554886652, 
		24.1],
	
	
	[new Date(2003, 2 , 1), 
		27.5, 
		16.7, 
		63.8, 
		27.200000000000003, 
		16.0, 
		12.1, 
		22.1, 
		6.750969333803313, 
		40.24903066619669, 
		12.5, 
		52.4, 
		88.1, 
		36.537757501646134, 
		51.56224249835387, 
		24.0],
	
	
	[new Date(2003, 3 , 1), 
		27.9, 
		16.7, 
		64.0, 
		26.89999999999999, 
		16.0, 
		12.2, 
		22.0, 
		6.794060627423335, 
		40.50593937257667, 
		12.6, 
		52.5, 
		87.7, 
		36.371865299595534, 
		51.32813470040448, 
		24.2],
	
	
	[new Date(2003, 4 , 1), 
		28.1, 
		16.7, 
		64.0, 
		26.700000000000003, 
		16.0, 
		12.2, 
		22.3, 
		6.765333098343322, 
		40.33466690165669, 
		12.5, 
		52.5, 
		87.9, 
		36.454811400620834, 
		51.44518859937918, 
		24.1],
	
	
	[new Date(2003, 5 , 1), 
		27.9, 
		16.7, 
		64.1, 
		26.5, 
		16.099999999999998, 
		12.3, 
		22.4, 
		6.779696862883328, 
		40.420303137116676, 
		12.5, 
		52.4, 
		88.0, 
		36.496284451133484, 
		51.50371554886652, 
		24.2],
	
	
	[new Date(2003, 6 , 1), 
		28.1, 
		16.8, 
		64.6, 
		26.400000000000006, 
		16.1, 
		12.4, 
		22.4, 
		6.750969333803315, 
		40.249030666196695, 
		12.8, 
		52.5, 
		88.3, 
		36.62070360267144, 
		51.67929639732857, 
		24.2],
	
	
	[new Date(2003, 7 , 1), 
		28.2, 
		16.7, 
		64.4, 
		26.69999999999999, 
		16.299999999999997, 
		12.4, 
		22.5, 
		6.808424391963343, 
		40.59157560803667, 
		12.9, 
		52.4, 
		88.5, 
		36.70364970369674, 
		51.79635029630327, 
		24.2],
	
	
	[new Date(2003, 8 , 1), 
		28.3, 
		16.8, 
		64.4, 
		26.799999999999997, 
		16.200000000000003, 
		12.4, 
		22.6, 
		6.880243214663377, 
		41.019756785336625, 
		13.0, 
		53.0, 
		89.0, 
		36.911014956260004, 
		52.08898504374001, 
		24.2],
	
	
	[new Date(2003, 9 , 1), 
		28.3, 
		16.8, 
		64.5, 
		26.900000000000006, 
		16.1, 
		12.4, 
		22.6, 
		6.7940606274233355, 
		40.50593937257668, 
		12.9, 
		53.3, 
		89.5, 
		37.11838020882326, 
		52.381619791176746, 
		24.3],
	
	
	[new Date(2003, 10 , 1), 
		28.3, 
		16.7, 
		65.0, 
		26.799999999999997, 
		16.2, 
		12.3, 
		22.8, 
		6.837151921043358, 
		40.76284807895666, 
		12.9, 
		53.5, 
		89.7, 
		37.20132630984857, 
		52.49867369015145, 
		24.4],
	
	
	[new Date(2003, 11 , 1), 
		28.1, 
		16.7, 
		65.4, 
		26.799999999999997, 
		16.2, 
		12.3, 
		22.7, 
		6.822788156503349, 
		40.67721184349666, 
		12.8, 
		53.6, 
		90.4, 
		37.49163766343713, 
		52.90836233656289, 
		24.5],
	
	
	[new Date(2004, 0 , 1), 
		28.2, 
		16.9, 
		65.6, 
		26.900000000000006, 
		16.5, 
		12.3, 
		22.6, 
		6.934606702552528, 
		40.66539329744748, 
		12.8, 
		53.7, 
		90.7, 
		37.09004059539919, 
		53.609959404600815, 
		24.3],
	
	
	[new Date(2004, 1 , 1), 
		28.5, 
		16.9, 
		65.7, 
		27.10000000000001, 
		16.3, 
		12.3, 
		22.6, 
		6.978312206980379, 
		40.92168779301962, 
		12.8, 
		53.8, 
		91.1, 
		37.253612990527735, 
		53.84638700947225, 
		24.3],
	
	
	[new Date(2004, 2 , 1), 
		27.8, 
		16.9, 
		65.9, 
		27.19999999999999, 
		16.3, 
		12.3, 
		22.7, 
		6.963743705504428, 
		40.83625629449557, 
		12.9, 
		54.0, 
		90.9, 
		37.171826792963465, 
		53.72817320703654, 
		24.4],
	
	
	[new Date(2004, 3 , 1), 
		28.7, 
		17.0, 
		66.0, 
		28.0, 
		16.5, 
		12.3, 
		22.8, 
		6.905469699600626, 
		40.49453030039938, 
		12.8, 
		53.8, 
		91.4, 
		37.376292286874154, 
		54.023707713125845, 
		24.2],
	
	
	[new Date(2004, 4 , 1), 
		29.0, 
		17.0, 
		66.5, 
		28.200000000000003, 
		16.5, 
		12.3, 
		22.6, 
		6.9054696996006255, 
		40.494530300399376, 
		13.0, 
		54.3, 
		91.7, 
		37.498971583220566, 
		54.20102841677943, 
		24.4],
	
	
	[new Date(2004, 5 , 1), 
		29.3, 
		17.1, 
		66.6, 
		28.500000000000014, 
		16.5, 
		12.3, 
		22.8, 
		6.920038201076577, 
		40.57996179892343, 
		13.1, 
		54.5, 
		92.3, 
		37.74433017591339, 
		54.5556698240866, 
		24.5],
	
	
	[new Date(2004, 6 , 1), 
		29.4, 
		17.0, 
		66.9, 
		28.39999999999999, 
		16.4, 
		12.4, 
		22.7, 
		6.963743705504428, 
		40.83625629449557, 
		13.1, 
		54.7, 
		92.9, 
		37.98968876860622, 
		54.91031123139378, 
		24.5],
	
	
	[new Date(2004, 7 , 1), 
		29.7, 
		17.0, 
		67.2, 
		28.5, 
		16.4, 
		12.3, 
		22.8, 
		7.007449209932282, 
		41.09255079006773, 
		13.0, 
		54.9, 
		93.1, 
		38.0714749661705, 
		55.028525033829496, 
		24.5],
	
	
	[new Date(2004, 8 , 1), 
		29.8, 
		17.1, 
		67.6, 
		28.500000000000014, 
		16.4, 
		12.3, 
		22.8, 
		7.036586212884182, 
		41.263413787115816, 
		13.1, 
		55.2, 
		93.4, 
		38.19415426251691, 
		55.20584573748309, 
		24.4],
	
	
	[new Date(2004, 9 , 1), 
		30.4, 
		17.2, 
		68.4, 
		29.099999999999994, 
		16.5, 
		12.5, 
		22.8, 
		7.094860218787986, 
		41.605139781212024, 
		13.1, 
		55.4, 
		93.7, 
		38.31683355886333, 
		55.38316644113667, 
		24.7],
	
	
	[new Date(2004, 10 , 1), 
		30.7, 
		17.2, 
		68.7, 
		29.39999999999999, 
		16.5, 
		12.6, 
		23.0, 
		7.065723215836083, 
		41.43427678416392, 
		13.3, 
		55.6, 
		94.2, 
		38.52129905277402, 
		55.678700947225984, 
		24.6],
	
	
	[new Date(2004, 11 , 1), 
		31.0, 
		17.2, 
		68.4, 
		29.299999999999997, 
		16.5, 
		12.7, 
		22.9, 
		7.123997221739886, 
		41.776002778260114, 
		13.2, 
		55.9, 
		94.0, 
		38.43951285520974, 
		55.56048714479026, 
		24.7],
	
	
	[new Date(2005, 0 , 1), 
		31.4, 
		17.2, 
		68.5, 
		29.599999999999994, 
		16.6, 
		12.5, 
		23.0, 
		7.152248569092396, 
		42.54775143090762, 
		13.7, 
		56.2, 
		93.7, 
		38.28540165231147, 
		55.41459834768851, 
		24.9],
	
	
	[new Date(2005, 1 , 1), 
		31.7, 
		17.4, 
		68.7, 
		29.700000000000003, 
		16.5, 
		12.6, 
		23.0, 
		7.166639411283727, 
		42.63336058871628, 
		13.3, 
		56.2, 
		93.8, 
		38.32626120583581, 
		55.47373879416416, 
		24.8],
	
	
	[new Date(2005, 2 , 1), 
		32.2, 
		17.5, 
		68.7, 
		29.799999999999997, 
		16.4, 
		12.6, 
		23.0, 
		7.1954210956663935, 
		42.80457890433362, 
		13.5, 
		56.1, 
		94.1, 
		38.44883986640885, 
		55.65116013359113, 
		24.7],
	
	
	[new Date(2005, 3 , 1), 
		32.7, 
		17.5, 
		68.7, 
		30.200000000000003, 
		16.3, 
		12.7, 
		23.0, 
		7.267375306623057, 
		43.232624693376955, 
		13.5, 
		56.2, 
		94.5, 
		38.612278080506236, 
		55.88772191949375, 
		25.0],
	
	
	[new Date(2005, 4 , 1), 
		33.1, 
		17.5, 
		68.9, 
		30.89999999999999, 
		16.5, 
		12.7, 
		23.0, 
		7.281766148814389, 
		43.31823385118562, 
		13.6, 
		56.1, 
		94.6, 
		38.65313763403058, 
		55.9468623659694, 
		25.2],
	
	
	[new Date(2005, 5 , 1), 
		33.4, 
		17.5, 
		68.6, 
		31.30000000000001, 
		16.3, 
		12.8, 
		23.1, 
		7.28176614881439, 
		43.318233851185624, 
		13.5, 
		56.1, 
		94.9, 
		38.77571629460362, 
		56.12428370539637, 
		25.2],
	
	
	[new Date(2005, 6 , 1), 
		33.8, 
		17.7, 
		69.4, 
		31.39999999999999, 
		16.4, 
		12.9, 
		23.3, 
		7.324938675388389, 
		43.575061324611625, 
		13.6, 
		56.2, 
		94.9, 
		38.77571629460362, 
		56.12428370539637, 
		25.3],
	
	
	[new Date(2005, 7 , 1), 
		34.0, 
		17.7, 
		69.6, 
		31.5, 
		16.5, 
		12.9, 
		23.3, 
		7.353720359771055, 
		43.74627964022896, 
		13.7, 
		56.3, 
		95.2, 
		38.89829495517665, 
		56.301705044823336, 
		25.4],
	
	
	[new Date(2005, 8 , 1), 
		34.3, 
		17.9, 
		69.9, 
		31.39999999999999, 
		16.5, 
		13.0, 
		23.5, 
		7.3825020441537195, 
		43.91749795584629, 
		13.6, 
		56.6, 
		95.7, 
		39.10259272279838, 
		56.59740727720161, 
		25.5],
	
	
	[new Date(2005, 9 , 1), 
		34.5, 
		17.9, 
		70.1, 
		31.200000000000003, 
		16.6, 
		13.0, 
		23.5, 
		7.440065412919051, 
		44.25993458708096, 
		13.6, 
		56.3, 
		95.2, 
		38.89829495517665, 
		56.301705044823336, 
		25.4],
	
	
	[new Date(2005, 10 , 1), 
		34.7, 
		17.8, 
		69.9, 
		31.5, 
		16.7, 
		13.0, 
		23.6, 
		7.526410466067048, 
		44.77358953393297, 
		13.6, 
		56.4, 
		95.5, 
		39.020873615749686, 
		56.4791263842503, 
		25.4],
	
	
	[new Date(2005, 11 , 1), 
		35.0, 
		17.9, 
		69.9, 
		31.599999999999994, 
		16.700000000000003, 
		13.1, 
		23.7, 
		7.555192150449713, 
		44.9448078495503, 
		13.7, 
		56.4, 
		95.6, 
		39.06173316927403, 
		56.53826683072595, 
		25.6],
	
	
	[new Date(2006, 0 , 1), 
		35.1, 
		17.8, 
		70.0, 
		31.700000000000003, 
		16.799999999999997, 
		13.1, 
		23.8, 
		7.5187460417986065, 
		44.7812539582014, 
		13.7, 
		56.3, 
		95.6, 
		38.79109423541595, 
		56.80890576458406, 
		25.8],
	
	
	[new Date(2006, 1 , 1), 
		35.2, 
		17.8, 
		70.3, 
		32.0, 
		16.700000000000003, 
		13.1, 
		23.8, 
		7.605003166561115, 
		45.294996833438894, 
		13.7, 
		56.4, 
		95.7, 
		38.8316706938212, 
		56.868329306178815, 
		25.9],
	
	
	[new Date(2006, 2 , 1), 
		35.3, 
		17.8, 
		70.2, 
		32.400000000000006, 
		16.799999999999997, 
		13.1, 
		24.0, 
		7.619379354021532, 
		45.380620645978475, 
		13.8, 
		56.6, 
		95.9, 
		38.9128236106317, 
		56.98717638936833, 
		25.9],
	
	
	[new Date(2006, 3 , 1), 
		35.5, 
		17.9, 
		70.3, 
		32.70000000000002, 
		16.900000000000002, 
		13.2, 
		24.1, 
		7.6193793540215315, 
		45.38062064597847, 
		13.9, 
		56.8, 
		95.9, 
		38.9128236106317, 
		56.98717638936833, 
		25.9],
	
	
	[new Date(2006, 4 , 1), 
		35.8, 
		18.0, 
		70.1, 
		32.80000000000001, 
		16.8, 
		13.2, 
		24.1, 
		7.633755541481951, 
		45.466244458518055, 
		13.9, 
		57.0, 
		96.0, 
		38.95340006903694, 
		57.046599930963076, 
		26.0],
	
	
	[new Date(2006, 5 , 1), 
		36.2, 
		18.0, 
		70.1, 
		33.30000000000001, 
		16.900000000000002, 
		13.2, 
		24.3, 
		7.633755541481952, 
		45.46624445851806, 
		14.0, 
		57.1, 
		96.2, 
		39.034552985847434, 
		57.16544701415258, 
		26.0],
	
	
	[new Date(2006, 6 , 1), 
		36.5, 
		18.0, 
		69.7, 
		33.39999999999999, 
		16.8, 
		13.2, 
		24.3, 
		7.648131728942369, 
		45.551868271057636, 
		14.0, 
		57.0, 
		96.6, 
		39.19685881946842, 
		57.40314118053159, 
		26.1],
	
	
	[new Date(2006, 7 , 1), 
		37.0, 
		18.2, 
		70.1, 
		33.5, 
		17.0, 
		13.1, 
		24.3, 
		7.619379354021532, 
		45.380620645978475, 
		14.2, 
		58.0, 
		97.0, 
		39.35916465308941, 
		57.640835346910606, 
		26.3],
	
	
	[new Date(2006, 8 , 1), 
		37.3, 
		18.1, 
		70.0, 
		33.7, 
		16.9, 
		13.1, 
		24.3, 
		7.605003166561115, 
		45.294996833438894, 
		14.2, 
		57.6, 
		97.3, 
		39.480894028305144, 
		57.81910597169487, 
		26.3],
	
	
	[new Date(2006, 9 , 1), 
		37.6, 
		18.2, 
		69.9, 
		32.89999999999999, 
		17.0, 
		13.0, 
		24.1, 
		7.418112729575681, 
		44.181887270424326, 
		13.7, 
		58.0, 
		97.4, 
		39.5214704867104, 
		57.87852951328962, 
		26.4],
	
	
	[new Date(2006, 10 , 1), 
		38.2, 
		18.3, 
		70.3, 
		32.900000000000006, 
		16.9, 
		13.1, 
		24.3, 
		7.4181127295756815, 
		44.18188727042433, 
		13.9, 
		58.1, 
		97.6, 
		39.60262340352089, 
		57.99737659647912, 
		26.4],
	
	
	[new Date(2006, 11 , 1), 
		38.7, 
		18.3, 
		70.1, 
		33.400000000000006, 
		16.9, 
		13.1, 
		24.3, 
		7.432488917036099, 
		44.26751108296391, 
		14.0, 
		58.3, 
		97.5, 
		39.56204694511564, 
		57.937953054884375, 
		26.4],
	
	
	[new Date(2007, 0 , 1), 
		38.2, 
		18.4, 
		70.5, 
		32.89999999999999, 
		17.200000000000003, 
		13.1, 
		24.3, 
		7.574311926605506, 
		44.025688073394505, 
		14.0, 
		58.1, 
		97.8, 
		39.17327432121881, 
		58.62672567878116, 
		26.2],
	
	
	[new Date(2007, 1 , 1), 
		38.4, 
		18.4, 
		70.3, 
		32.70000000000002, 
		17.1, 
		13.1, 
		24.4, 
		7.515596330275229, 
		43.68440366972477, 
		14.2, 
		58.5, 
		97.9, 
		39.2133287939399, 
		58.68667120606008, 
		26.4],
	
	
	[new Date(2007, 2 , 1), 
		38.6, 
		18.5, 
		70.5, 
		32.900000000000006, 
		17.0, 
		13.2, 
		24.3, 
		7.559633027522937, 
		43.94036697247707, 
		14.1, 
		58.5, 
		98.1, 
		39.293437739382064, 
		58.80656226061791, 
		26.4],
	
	
	[new Date(2007, 3 , 1), 
		38.7, 
		18.4, 
		70.5, 
		32.8, 
		17.1, 
		13.0, 
		24.4, 
		7.471559633027523, 
		43.42844036697248, 
		14.4, 
		58.5, 
		98.4, 
		39.413601157545315, 
		58.98639884245467, 
		26.3],
	
	
	[new Date(2007, 4 , 1), 
		39.0, 
		18.5, 
		70.5, 
		32.8, 
		17.0, 
		13.0, 
		24.4, 
		7.544954128440367, 
		43.85504587155964, 
		14.3, 
		58.6, 
		98.4, 
		39.413601157545315, 
		58.98639884245467, 
		26.3],
	
	
	[new Date(2007, 5 , 1), 
		39.3, 
		18.6, 
		70.4, 
		32.8, 
		17.0, 
		13.1, 
		24.5, 
		7.691743119266056, 
		44.708256880733956, 
		14.4, 
		58.6, 
		98.5, 
		39.4536556302664, 
		59.04634436973358, 
		26.5],
	
	
	[new Date(2007, 6 , 1), 
		39.3, 
		18.6, 
		70.2, 
		32.999999999999986, 
		17.0, 
		13.1, 
		24.6, 
		7.6036697247706435, 
		44.196330275229364, 
		14.4, 
		58.6, 
		97.6, 
		39.09316537577665, 
		58.50683462422332, 
		26.7],
	
	
	[new Date(2007, 7 , 1), 
		39.4, 
		18.7, 
		70.0, 
		32.7, 
		16.8, 
		13.2, 
		24.7, 
		7.588990825688074, 
		44.11100917431193, 
		14.4, 
		58.7, 
		97.6, 
		39.09316537577665, 
		58.50683462422332, 
		26.7],
	
	
	[new Date(2007, 8 , 1), 
		39.5, 
		18.7, 
		69.8, 
		32.7, 
		16.799999999999997, 
		13.1, 
		24.8, 
		7.63302752293578, 
		44.36697247706422, 
		14.6, 
		58.7, 
		97.4, 
		39.01305643033449, 
		58.3869435696655, 
		26.8],
	
	
	[new Date(2007, 9 , 1), 
		39.6, 
		18.8, 
		70.2, 
		32.900000000000006, 
		16.9, 
		13.1, 
		24.7, 
		7.691743119266055, 
		44.70825688073394, 
		14.6, 
		58.6, 
		97.4, 
		39.01305643033449, 
		58.3869435696655, 
		26.9],
	
	
	[new Date(2007, 10 , 1), 
		39.6, 
		18.9, 
		70.7, 
		33.10000000000001, 
		16.700000000000003, 
		13.1, 
		24.9, 
		7.662385321100917, 
		44.53761467889908, 
		14.5, 
		58.5, 
		97.4, 
		39.01305643033449, 
		58.3869435696655, 
		27.0],
	
	
	[new Date(2007, 11 , 1), 
		39.6, 
		18.9, 
		70.8, 
		33.30000000000001, 
		16.700000000000003, 
		13.1, 
		24.8, 
		7.64770642201835, 
		44.45229357798166, 
		14.5, 
		58.6, 
		97.3, 
		38.973001957613405, 
		58.32699804238657, 
		26.9],
	
	
	[new Date(2008, 0 , 1), 
		39.6, 
		18.9, 
		70.6, 
		32.7, 
		16.8, 
		13.0, 
		24.9, 
		7.611298315163531, 
		43.98870168483648, 
		14.6, 
		58.9, 
		97.8, 
		38.70858788619305, 
		59.09141211380695, 
		27.2],
	
	
	[new Date(2008, 1 , 1), 
		39.5, 
		19.0, 
		70.8, 
		32.0, 
		16.7, 
		13.2, 
		24.8, 
		7.5375454245127225, 
		43.56245457548729, 
		14.5, 
		59.1, 
		98.0, 
		38.787746552626984, 
		59.21225344737302, 
		27.5],
	
	
	[new Date(2008, 2 , 1), 
		39.3, 
		19.0, 
		71.0, 
		31.299999999999997, 
		16.700000000000003, 
		12.9, 
		24.9, 
		7.5522960026428825, 
		43.64770399735712, 
		14.5, 
		59.1, 
		97.5, 
		38.589849886542154, 
		58.91015011345785, 
		27.5],
	
	
	[new Date(2008, 3 , 1), 
		39.0, 
		18.9, 
		70.8, 
		30.60000000000001, 
		16.799999999999997, 
		13.1, 
		25.2, 
		7.552296002642883, 
		43.64770399735713, 
		14.6, 
		59.2, 
		97.1, 
		38.43153255367429, 
		58.668467446325714, 
		27.5],
	
	
	[new Date(2008, 4 , 1), 
		38.6, 
		19.0, 
		70.7, 
		30.0, 
		16.8, 
		13.0, 
		25.1, 
		7.567046580773046, 
		43.73295341922696, 
		14.6, 
		59.3, 
		96.9, 
		38.35237388724036, 
		58.54762611275965, 
		27.5],
	
	
	[new Date(2008, 5 , 1), 
		38.2, 
		18.9, 
		70.5, 
		29.19999999999999, 
		16.8, 
		12.8, 
		25.1, 
		7.463792533861913, 
		43.136207466138096, 
		14.8, 
		59.6, 
		96.3, 
		38.114897887938554, 
		58.18510211206144, 
		27.3],
	
	
	[new Date(2008, 6 , 1), 
		37.9, 
		18.9, 
		70.3, 
		28.500000000000014, 
		16.7, 
		12.8, 
		25.1, 
		7.434291377601588, 
		42.96570862239842, 
		14.9, 
		59.5, 
		95.8, 
		37.917001221853724, 
		57.88299877814628, 
		27.1],
	
	
	[new Date(2008, 7 , 1), 
		37.5, 
		18.8, 
		70.0, 
		28.400000000000006, 
		16.799999999999997, 
		12.6, 
		25.2, 
		7.419540799471426, 
		42.88045920052858, 
		14.8, 
		59.7, 
		94.8, 
		37.521207889684064, 
		57.27879211031594, 
		27.0],
	
	
	[new Date(2008, 8 , 1), 
		37.2, 
		18.7, 
		69.4, 
		27.999999999999986, 
		16.799999999999997, 
		12.4, 
		25.2, 
		7.3605384869507775, 
		42.53946151304922, 
		14.8, 
		59.8, 
		94.1, 
		37.2441525571653, 
		56.8558474428347, 
		27.0],
	
	
	[new Date(2008, 9 , 1), 
		36.6, 
		18.6, 
		68.8, 
		27.89999999999999, 
		16.6, 
		12.1, 
		25.3, 
		7.301536174430131, 
		42.198463825569874, 
		14.8, 
		59.9, 
		93.3, 
		36.92751789142957, 
		56.37248210857044, 
		26.9],
	
	
	[new Date(2008, 10 , 1), 
		36.0, 
		18.5, 
		68.1, 
		27.700000000000003, 
		16.7, 
		12.2, 
		25.0, 
		7.28678559629997, 
		42.11321440370004, 
		14.8, 
		60.1, 
		92.5, 
		36.61088322569384, 
		55.88911677430617, 
		26.9],
	
	
	[new Date(2008, 11 , 1), 
		35.3, 
		18.4, 
		67.5, 
		27.5, 
		16.5, 
		12.0, 
		25.2, 
		7.227783283779322, 
		41.77221671622068, 
		14.8, 
		60.0, 
		91.5, 
		36.21508989352417, 
		55.28491010647583, 
		26.8],
	
	
	[new Date(2009, 0 , 1), 
		34.5, 
		18.3, 
		67.6, 
		27.400000000000006, 
		16.7, 
		11.5, 
		25.3, 
		7.21180654338549, 
		41.188193456614506, 
		14.8, 
		60.0, 
		91.2, 
		35.25158667836852, 
		55.956838653055584, 
		26.6],
	
	
	[new Date(2009, 1 , 1), 
		33.7, 
		18.2, 
		67.4, 
		27.39999999999999, 
		16.5, 
		11.5, 
		25.1, 
		7.137304409672829, 
		40.76269559032716, 
		14.8, 
		59.8, 
		91.0, 
		35.17428056723174, 
		55.834126287588354, 
		26.4],
	
	
	[new Date(2009, 2 , 1), 
		33.1, 
		18.1, 
		66.9, 
		27.099999999999994, 
		16.5, 
		11.3, 
		25.0, 
		7.1075035561877655, 
		40.59249644381222, 
		14.7, 
		60.0, 
		90.7, 
		35.05832140052658, 
		55.65005773938751, 
		26.5],
	
	
	[new Date(2009, 3 , 1), 
		32.2, 
		18.0, 
		66.4, 
		26.69999999999999, 
		16.4, 
		11.5, 
		24.8, 
		6.943598862019915, 
		39.65640113798008, 
		14.7, 
		59.6, 
		90.2, 
		34.86505612268465, 
		55.34327682571944, 
		25.8],
	
	
	[new Date(2009, 4 , 1), 
		32.0, 
		17.9, 
		66.1, 
		27.0, 
		16.3, 
		11.5, 
		24.6, 
		6.973399715504978, 
		39.826600284495015, 
		14.6, 
		59.5, 
		90.2, 
		34.86505612268465, 
		55.34327682571944, 
		25.7],
	
	
	[new Date(2009, 5 , 1), 
		31.7, 
		17.8, 
		66.2, 
		26.900000000000006, 
		16.2, 
		11.5, 
		24.6, 
		6.958499288762445, 
		39.74150071123754, 
		14.6, 
		60.3, 
		90.4, 
		34.94236223382143, 
		55.46598919118667, 
		25.8],
	
	
	[new Date(2009, 6 , 1), 
		31.1, 
		17.8, 
		66.0, 
		26.900000000000006, 
		16.1, 
		11.4, 
		24.4, 
		6.8690967283072535, 
		39.23090327169274, 
		14.5, 
		60.2, 
		90.0, 
		34.78775001154788, 
		55.22056446025221, 
		25.8],
	
	
	[new Date(2009, 7 , 1), 
		30.5, 
		17.7, 
		65.8, 
		26.5, 
		16.1, 
		11.4, 
		24.3, 
		6.869096728307254, 
		39.230903271692746, 
		14.8, 
		59.9, 
		90.2, 
		34.86505612268465, 
		55.34327682571944, 
		25.9],
	
	
	[new Date(2009, 8 , 1), 
		30.0, 
		17.7, 
		66.1, 
		26.400000000000006, 
		16.1, 
		11.4, 
		24.1, 
		6.85419630156472, 
		39.145803698435266, 
		14.5, 
		60.1, 
		89.9, 
		34.74909695597949, 
		55.15920827751861, 
		26.0],
	
	
	[new Date(2009, 9 , 1), 
		29.7, 
		17.6, 
		66.2, 
		26.39999999999999, 
		15.999999999999998, 
		11.4, 
		24.2, 
		7.018100995732572, 
		40.08189900426741, 
		14.5, 
		60.0, 
		89.9, 
		34.74909695597949, 
		55.15920827751861, 
		25.9],
	
	
	[new Date(2009, 10 , 1), 
		29.4, 
		17.6, 
		66.2, 
		26.099999999999994, 
		15.999999999999998, 
		11.4, 
		24.2, 
		6.928698435277381, 
		39.57130156472261, 
		14.5, 
		60.2, 
		89.6, 
		34.63313778927433, 
		54.97513972931776, 
		25.9],
	
	
	[new Date(2009, 11 , 1), 
		29.3, 
		17.6, 
		65.9, 
		26.200000000000003, 
		15.700000000000001, 
		11.4, 
		24.1, 
		6.913798008534849, 
		39.48620199146514, 
		14.5, 
		60.1, 
		89.6, 
		34.63313778927433, 
		54.97513972931776, 
		25.8],
	
	
	[new Date(2010, 0 , 1), 
		29.5, 
		17.6, 
		65.7, 
		26.19999999999999, 
		15.999999999999998, 
		11.4, 
		24.1, 
		6.508425681618295, 
		40.09157431838171, 
		14.7, 
		60.8, 
		89.4, 
		34.37055214723925, 
		55.029447852760725, 
		25.8],
	
	
	[new Date(2010, 1 , 1), 
		29.3, 
		17.6, 
		65.8, 
		26.299999999999997, 
		15.700000000000001, 
		11.4, 
		24.1, 
		6.494459102902375, 
		40.00554089709762, 
		14.5, 
		60.5, 
		89.3, 
		34.33210633946829, 
		54.96789366053168, 
		25.8],
	
	
	[new Date(2010, 2 , 1), 
		29.2, 
		17.7, 
		65.6, 
		26.10000000000001, 
		15.700000000000001, 
		11.4, 
		24.0, 
		6.508425681618293, 
		40.0915743183817, 
		14.5, 
		60.7, 
		89.1, 
		34.255214723926365, 
		54.8447852760736, 
		25.8],
	
	
	[new Date(2010, 3 , 1), 
		29.1, 
		17.7, 
		66.1, 
		26.200000000000003, 
		15.6, 
		11.4, 
		24.1, 
		6.522392260334213, 
		40.17760773966578, 
		14.1, 
		60.9, 
		89.4, 
		34.37055214723925, 
		55.029447852760725, 
		25.9],
	
	
	[new Date(2010, 4 , 1), 
		29.1, 
		17.7, 
		65.8, 
		26.400000000000006, 
		15.599999999999998, 
		11.3, 
		24.0, 
		6.59222515391381, 
		40.607774846086194, 
		14.3, 
		60.8, 
		89.0, 
		34.21676891615541, 
		54.78323108384457, 
		25.9],
	
	
	[new Date(2010, 5 , 1), 
		28.7, 
		17.6, 
		65.9, 
		26.299999999999997, 
		15.399999999999999, 
		11.3, 
		24.1, 
		6.606191732629728, 
		40.69380826737027, 
		14.2, 
		61.0, 
		89.3, 
		34.33210633946829, 
		54.96789366053168, 
		25.9],
	
	
	[new Date(2010, 6 , 1), 
		28.6, 
		17.7, 
		66.0, 
		26.39999999999999, 
		15.499999999999998, 
		11.4, 
		24.2, 
		6.6760246262093235, 
		41.12397537379067, 
		14.3, 
		61.2, 
		89.6, 
		34.44744376278117, 
		55.152556237218796, 
		25.9],
	
	
	[new Date(2010, 7 , 1), 
		28.5, 
		17.7, 
		66.1, 
		26.700000000000003, 
		15.5, 
		11.3, 
		24.2, 
		6.648091468777484, 
		40.95190853122251, 
		14.3, 
		61.2, 
		90.1, 
		34.639672801635975, 
		55.46032719836399, 
		25.9],
	
	
	[new Date(2010, 8 , 1), 
		28.4, 
		17.6, 
		66.0, 
		26.60000000000001, 
		15.5, 
		11.3, 
		24.2, 
		6.703957783641162, 
		41.29604221635884, 
		14.0, 
		61.0, 
		90.5, 
		34.793456032719824, 
		55.70654396728015, 
		25.8],
	
	
	[new Date(2010, 9 , 1), 
		28.7, 
		17.6, 
		66.1, 
		26.900000000000006, 
		15.499999999999998, 
		11.4, 
		24.3, 
		6.745857519788919, 
		41.55414248021108, 
		14.6, 
		61.1, 
		91.0, 
		34.98568507157463, 
		56.01431492842534, 
		25.9],
	
	
	[new Date(2010, 10 , 1), 
		28.7, 
		17.6, 
		66.1, 
		26.900000000000006, 
		15.499999999999998, 
		11.4, 
		24.3, 
		6.759824098504839, 
		41.64017590149517, 
		14.5, 
		61.1, 
		91.5, 
		35.177914110429434, 
		56.32208588957054, 
		25.8],
	
	
	[new Date(2010, 11 , 1), 
		28.7, 
		17.6, 
		66.2, 
		26.999999999999986, 
		15.399999999999999, 
		11.3, 
		24.2, 
		6.731890941073, 
		41.468109058927006, 
		14.5, 
		61.1, 
		91.7, 
		35.25480572597136, 
		56.445194274028616, 
		25.8],
	
	
	[new Date(2011, 0 , 1), 
		28.3, 
		17.5, 
		66.6, 
		26.700000000000003, 
		15.4, 
		11.4, 
		24.5, 
		6.677374670184697, 
		42.522625329815305, 
		14.4, 
		60.5, 
		91.9, 
		35.410028627661475, 
		56.489971372338516, 
		25.9],
	
	
	[new Date(2011, 1 , 1), 
		28.5, 
		17.4, 
		66.4, 
		27.099999999999994, 
		15.399999999999999, 
		11.3, 
		24.5, 
		6.758806068601583, 
		43.04119393139842, 
		14.4, 
		61.1, 
		91.8, 
		35.37149758454106, 
		56.42850241545893, 
		26.0],
	
	
	[new Date(2011, 2 , 1), 
		28.4, 
		17.4, 
		66.6, 
		27.0, 
		15.399999999999999, 
		11.3, 
		24.5, 
		6.813093667546175, 
		43.38690633245383, 
		14.5, 
		61.0, 
		92.0, 
		35.44855967078189, 
		56.551440329218096, 
		25.8],
	
	
	[new Date(2011, 3 , 1), 
		28.6, 
		17.4, 
		66.6, 
		26.700000000000003, 
		15.3, 
		11.3, 
		24.5, 
		6.826665567282322, 
		43.47333443271768, 
		14.4, 
		61.0, 
		91.9, 
		35.410028627661475, 
		56.489971372338516, 
		25.7],
	
	
	[new Date(2011, 4 , 1), 
		28.4, 
		17.5, 
		66.7, 
		26.89999999999999, 
		15.2, 
		11.3, 
		24.4, 
		6.853809366754619, 
		43.64619063324539, 
		14.4, 
		61.0, 
		92.1, 
		35.487090713902305, 
		56.61290928609768, 
		25.7],
	
	
	[new Date(2011, 5 , 1), 
		28.6, 
		17.4, 
		66.6, 
		26.700000000000003, 
		15.2, 
		11.3, 
		24.2, 
		6.853809366754618, 
		43.64619063324538, 
		14.0, 
		60.6, 
		91.6, 
		35.29443549830023, 
		56.305564501699756, 
		25.7],
	
	
	[new Date(2011, 6 , 1), 
		28.4, 
		17.7, 
		66.5, 
		27.0, 
		15.6, 
		11.4, 
		24.0, 
		6.853809366754618, 
		43.64619063324538, 
		14.3, 
		61.2, 
		93.3, 
		35.94946323134729, 
		57.3505367686527, 
		25.9],
	
	
	[new Date(2011, 7 , 1), 
		28.3, 
		17.5, 
		66.7, 
		26.89999999999999, 
		15.600000000000001, 
		11.5, 
		24.1, 
		6.8945250659630615, 
		43.905474934036945, 
		14.2, 
		61.3, 
		93.1, 
		35.87240114510645, 
		57.22759885489353, 
		25.7],
	
	
	[new Date(2011, 8 , 1), 
		28.1, 
		17.4, 
		66.7, 
		27.10000000000001, 
		15.500000000000002, 
		11.6, 
		23.9, 
		6.9623845646438, 
		44.337615435356206, 
		14.4, 
		60.9, 
		94.4, 
		36.373304705671856, 
		58.02669529432814, 
		25.8],
	
	
	[new Date(2011, 9 , 1), 
		28.8, 
		17.2, 
		67.0, 
		27.200000000000003, 
		15.7, 
		11.7, 
		23.9, 
		6.9623845646438, 
		44.337615435356206, 
		14.6, 
		61.0, 
		95.4, 
		36.758615136876, 
		58.64138486312399, 
		25.7],
	
	
	[new Date(2011, 10 , 1), 
		27.4, 
		17.1, 
		67.1, 
		27.200000000000017, 
		15.900000000000002, 
		11.7, 
		24.3, 
		6.935240765171505, 
		44.16475923482851, 
		14.8, 
		61.7, 
		95.3, 
		36.72008409375559, 
		58.5799159062444, 
		25.9],
	
	
	[new Date(2011, 11 , 1), 
		27.6, 
		17.0, 
		67.0, 
		27.400000000000006, 
		15.7, 
		11.7, 
		23.6, 
		6.975956464379947, 
		44.42404353562005, 
		14.9, 
		61.7, 
		95.6, 
		36.83567722311683, 
		58.764322776883155, 
		26.1],
	
	
	[new Date(2012, 0 , 1), 
		27.6, 
		17.3, 
		67.3, 
		26.30000000000001, 
		15.900000000000002, 
		11.7, 
		23.3, 
		7.144309609708099, 
		45.8556903902919, 
		14.4, 
		60.3, 
		95.2, 
		36.76754057428215, 
		58.43245942571787, 
		25.6],
	
	
	[new Date(2012, 1 , 1), 
		28.3, 
		17.1, 
		67.0, 
		27.200000000000003, 
		16.0, 
		11.6, 
		23.3, 
		6.990690837824594, 
		45.20930916217541, 
		14.5, 
		61.2, 
		96.1, 
		37.17027171017581, 
		58.929728289824176, 
		25.3],
	
	
	[new Date(2012, 2 , 1), 
		28.1, 
		17.3, 
		66.8, 
		28.0, 
		15.700000000000001, 
		11.4, 
		22.9, 
		6.963370201691606, 
		45.43662979830839, 
		14.6, 
		61.3, 
		96.7, 
		37.457356321839086, 
		59.242643678160924, 
		25.3],
	
	
	[new Date(2012, 3 , 1), 
		28.0, 
		17.4, 
		67.3, 
		28.10000000000001, 
		15.8, 
		11.7, 
		23.1, 
		6.909466688280112, 
		45.3905333117199, 
		14.2, 
		61.1, 
		97.2, 
		37.67879588064431, 
		59.521204119355694, 
		25.5],
	
	
	[new Date(2012, 4 , 1), 
		27.8, 
		17.6, 
		67.5, 
		28.5, 
		16.0, 
		11.8, 
		22.8, 
		6.80895715440582, 
		44.99104284559417, 
		14.3, 
		60.9, 
		97.9, 
		37.98170112123336, 
		59.91829887876664, 
		25.3],
	
	
	[new Date(2012, 5 , 1), 
		27.9, 
		17.4, 
		67.9, 
		28.099999999999994, 
		16.0, 
		11.8, 
		22.3, 
		6.815016129032259, 
		45.28498387096775, 
		14.0, 
		60.2, 
		97.8, 
		37.97462530498431, 
		59.82537469501568, 
		25.9],
]);






		
		
var columnsMap = {
	        1: {
	            color: 'FF0000'
	        },
	        2: {
	            color: '00FF00'
	        },
	        3: {
	            color: '0000FF'
	        },
	        4: {
	            color: 'FFFF00'
	        },
	        5: {
	            color: 'FF00FF'
	        },
	        6: {
	            color: '00FFFF'
	        },
	        7: {
	            color: 'FF8888'
	        },
	        8: {
	            color: '88FF88'
	        },
	        9: {
	            color: '8888FF'
	        },
	        10: {
	            color: 'FFFF88'
	        },
	        11: {
	            color: 'FF88FF'
	        },
	        12: {
	            color: '88FFFF'
	        },
	        13: {
	            color: 'FFAA66'
	        },
	        14: {
	            color: 'AAFF66'
	        },
	        15: {
	            color: 'AA66FF'
	        }
	    };

	    var columnsTable = new google.visualization.DataTable();
	    columnsTable.addColumn('number', 'colIndex');
	    columnsTable.addColumn('string', 'colLabel');
	    // put the columns into this data table (skip column 0)
	    for (var i = 1; i < data.getNumberOfColumns(); i++) {
	        columnsTable.addRow([i, data.getColumnLabel(i)]);
	    }

	    var initState = {
	        selectedValues: ['Manufacturing', 'Finance', 'Retail']
	    };

	    var chartDash = new google.visualization.Dashboard(document.getElementById('chartDash'));

	    var chart = new google.visualization.ChartWrapper({
	        chartType: 'LineChart',
	        containerId: 'chart_div',
	        options: {
	            title: 'Sector By Sector Employment Figures in Hawaii',
	            width: 700, // make sure this is the same for the chart and control so the axes align right
	            height: 470,
				backgroundColor: 'F9F9F8',
	            chartArea: {
	                width: '80%', // make sure this is the same for the chart and control so the axes align right
	                height: '80%'
	            },
	            animation: {
	                duration: 750,
	                easing: 'out',
	            }
	        }
	    });

	    var rangeFilter = new google.visualization.ControlWrapper({
	        controlType: 'ChartRangeFilter',
	        containerId: 'range_div',
	        options: {
	            filterColumnIndex: 0,
	            ui: {
	                chartOptions: {
	                    chartType: 'LineChart',
	                    height: 50,
	                    width: 700, // make sure this is the same for the chart and control so the axes align right
						backgroundColor: 'F9F9F8',
	                    chartArea: {
	                        width: '80%' // make sure this is the same for the chart and control so the axes align right
	                    },
	                    hAxis: {
	                        baselineColor: 'none'
	                    }
	                },
	                chartView: {
	                    columns: [0, 1] // use column 1 to draw the range chart
	                },
	                minRangeSize: 86400000 // 1 day in milliseconds = 24 * 60 * 60 * 1000 = 86,400,000
	            }
	        },
	        // set the initial range to 1/1/2012 to 1/10/2012
	        state: {
	            range: {
	                start: new Date(1990, 0, 1),
	                end: new Date(2012, 5, 1)
	            }
	        }
	    });

	    var controlDash = new google.visualization.Dashboard(document.getElementById('controlDash'));

	    var columnFilter = new google.visualization.ControlWrapper({
	        controlType: 'CategoryFilter',
	        containerId: 'colFilter_div',
	        options: {
	            filterColumnLabel: 'colLabel',
				backgroundColor: 'F9F9F8',
	            ui: {
	                label: 'Sort',
					caption: 'Choose a sector...',
	                allowTyping: true,
	                allowMultiple: true,
	                selectedValuesLayout: 'belowStacked'
	            }
	        },
	        state: initState
	    });

	    var junkChart = new google.visualization.ChartWrapper({
	        chartType: 'Table',
	        containerId: 'junk_div'
	    });

	    google.visualization.events.addListener(columnFilter, 'statechange', function() {
	        setChartColumns();
	        chart.draw();
	    });

	    // bind columnFilter control to junk chart and draw controlDash 
	    controlDash.bind([columnFilter], [junkChart]);
	    controlDash.draw(columnsTable);

	    // bind the chartRangeFilter control to the actual chart and draw chartDash
	    chartDash.bind([rangeFilter], [chart]);
	    // set the chart columns before drawing
	    setChartColumns();
	    chartDash.draw(data);

	    function setChartColumns () {
	        var state = columnFilter.getState();
	        var row;
	        var columnIndices = [];
	        for (var i = 0; i < state.selectedValues.length; i++) {
	            row = columnsTable.getFilteredRows([{
	                column: 1,
	                value: state.selectedValues[i]}])[0];
	            columnIndices.push(columnsTable.getValue(row, 0));
	        }
	        // sort the indices into their original order
	        columnIndices.sort(function(a, b) {
	            return (a - b);
	        });

	        var viewColumns = [0];
	        var colors = [];
	        for (var i = 0; i < columnIndices.length; i++) {
	            viewColumns.push({
	                label: data.getColumnLabel(columnIndices[i]),
	                type: 'number',
	                calc: (function (x) {
	                    // use a closure here to lock the value of i to each column
	                    return function (dt, row) {
	                        // return the value normalized to the first row in the view
	                        return dt.getValue(row, columnIndices[x]) / dt.getValue(0, columnIndices[x]);
	                    };
	                })(i)
	            });
	            colors.push(columnsMap[columnIndices[i]].color);
	        }

	        chart.setView({
	            columns: viewColumns
	        });
	        chart.setOption('colors', colors);
}
}
    </script>
  </head>
  <body style="font-family: Arial;border: 0 none;">
    <table>
	    <tr style='vertical-align: top'>
	        <td style='width: 16px; font-size: 0.9em;'>
	            <div id="controlDash">
	                <div id="colFilter_div"></div>
	            </div>
	        </td>
	        <td style='width: 60px'>
	            <div id="chartDash">
	                <div style="float: left;" id="chart_div"></div>
	                <div style="float: left;" id="range_div"></div>
	            </div>
	        </td>
	    </tr>
	</table>
	<div id="junk_div" style="display: none;"></div>​
  </body>
<p>&nbsp;</p>


On Tuesday, August 21, 2012 1:03:41 PM UTC-10, A.Radice wrote:
Thank you asgallant (and shutzi) for posting, I had a similar question and this thread helped out tremendously.

A few questions I have though:

1.  Is there anyway to modify the "Choose a value..." text in the column filter?  

2.  I'm having some trouble formatting the graph how I'd like it on a web page.  Specifically, I want the column filter to display beneath the chart (and slider).  Is it necessary to construct a div table?  And what is the purpose of "junkChart"? 

3.  I'm trying to pass data into the api dynamically using embedded ruby.  The structure of the data table and format of the date (in my db, I have dates set as "yyyy-mm-dd") is giving me some trouble.  Any ideas how to work around this?

Thanks!

A.Radice

unread,
Aug 21, 2012, 10:58:16 PM8/21/12
to google-visua...@googlegroups.com
Oops, issue solved.  Just mis specified the initial state.  Still a few issues outstanding:

1.  Any way to get the chart range filter to not display any series?  In other words, I don't want anything in the range except for the dates, ideally.  I looked into chartView options but do not see an option for this.

2.  As you might have noticed, my series names are very long (ie. "Professional, Scientific, and Technical Jobs").  Is there anyway to create an abbreviation in the key, so that the series names are not all cut off?

Thanks in advance.

asgallant

unread,
Aug 22, 2012, 12:43:58 PM8/22/12
to google-visua...@googlegroups.com
To answer the leftover questions from all your posts:

The table layout in HTML is not necessary.  You can position the chart and control divs wherever you like, though I would recommend placing the range filter immediately below the chart.  The junk chart is actually not necessary any more, with a few slight adjustments, the control works fine without it (and without the control dashboard).  The control dashboard, column filter, and junk chart can be replaced with this:

var columnFilter new google.visualization.ControlWrapper({
    controlType'CategoryFilter',
    containerId'colFilter_div',
    dataTablecolumnsTable,

    options{
        filterColumnLabel'colLabel',
        ui{
            label'Replicator',
            allowTypingtrue,
            allowMultipletrue,
            selectedValuesLayout'belowStacked'
        }
    },
    stateinitState
});

google.visualization.events.addListener(columnFilter'statechange'function({
    setChartColumns();
    chart.draw();
});

columnFilter.draw();

see the complete code here: http://jsfiddle.net/asgallant/EVQP2/3/

The chart range filter needs to display something, but it doesn't necessarily have to be meaningful data.  In the chartView.columns option, you can specify a calculated column that returns a constant value, which will give you a straight line:

chartView{
    columns[0{
        type'number',
        calcfunction ({
            return 0;
        }
    }]
} 

alternatively, you can set the ui.chartOptions.colors option to ['transparent'] (that is a js array with a single string value inside), which will essentially hide the line from view:

As far as your series names go, you can manually abbreviate them, but that will change them in both the legend and in the tooltips.  You could also increase the chart width to make more room for the legend (also, adjusting the chartArea option will help).  Note that any width changes you make to the chart or chartArea you must also make in the range control to keep them aligned.

asgallant

unread,
Aug 22, 2012, 12:45:14 PM8/22/12
to google-visua...@googlegroups.com
Oh, and a third option for the legend would be to turn off the legend in the chart itself and create your own legend in HTML.

A.Radice

unread,
Aug 22, 2012, 6:49:33 PM8/22/12
to google-visua...@googlegroups.com
Awesome, thanks.  The chart is coming together now.  I set the legend to bottom, center and that works fine so I don't think I will have to create one from scratch.  

Last few questions:

1.  How do I remove the scaling (normalization)?  I want the data to plot as is.  I tried messing around (and removing) parts of the function setChartColumns script but had trouble rendering the chart when I did this.

2.  Is it possible to remove the vertical (baseline) axis and subsequent vertical gridlines?  I was under the impression that these were null by default, but they are showing up here without any explicit call.

3.  Can you specify how many date markers are displayed in the range filter?  I don't see any options to do this in the google documentation.

asgallant

unread,
Aug 23, 2012, 11:58:34 AM8/23/12
to google-visua...@googlegroups.com
1) In the setChartColumns function, change the viewColumns.push({....}); block to  viewColumns.push(columnIndices[i]); 
2) The object that defines them is null by default, but they are automatically added to charts with a continuous x-axis.  Set the hAxis.baselineColor and hAxis.gridlines.color options to "transparent" to make them go away.
3) Theoretically, setting hAxis.gridlines.count in the control's ui.chartOptions parameter would add or remove dates (as each axis point is tied to a gridline on continuous axis charts), but this option is not supported for date axes (which is not documented, unfortunately).  According to the bug report, fixing it is a low-priority issue for the dev team.

A.Radice

unread,
Aug 23, 2012, 5:36:12 PM8/23/12
to google-visua...@googlegroups.com
3) isn't a big deal, I just thought it would be cool to play around with the range scale.  Anyways, thanks again for the help.

asgallant

unread,
Aug 23, 2012, 5:49:40 PM8/23/12
to google-visua...@googlegroups.com
You're welcome.

A.Radice

unread,
Aug 23, 2012, 6:53:34 PM8/23/12
to google-visua...@googlegroups.com
Just noticed one last thing (I actually ended up using the function to normalize the values):  how do I truncate the transformed data to x decimal places?

I saw you posted a fix on another thread, but I'm unsure where to place this: var formatter new google.visualization.NumberFormat({
    pattern'#.##' // limits the display to two decimal places
});
formatter.format(dataTablecolumnIndex);

A.Radice

unread,
Aug 23, 2012, 7:46:17 PM8/23/12
to google-visua...@googlegroups.com
Disregard! Fed this function in to setChartColumns:

function roundNumber(num, dec) {var result = Math.round(num*Math.pow(10,dec))/Math.pow(10,dec);
return result;

asgallant

unread,
Aug 24, 2012, 11:19:14 AM8/24/12
to google-visua...@googlegroups.com
The difference between using a formatter and the method you chose is that the formatter only changes the displayed value, while you function changes the value used to chart the data.  Chances are that the difference is too small to be worth worrying about, but that's up to you to decide.

If you want to use a formatter, it must be used on a DataTable, you can't use them on DataViews.  To use it, use the code you copied and replace "dataTable" with your DataTable object variable and "columnIndex" with the index of the column you want to format.
Reply all
Reply to author
Forward
0 new messages