/*Flett Exchange Google API, (c)2010 Daniel Popp
  Big thanks to Mike Flett & Ronnie Black!
*/
google.load('visualization', '1', {packages: ['linechart']});
function drawVisualization() 
	{     
	var query = new google.visualization.Query('http://spreadsheets.google.com/pub?key=t0p0v6MzLhPWhqZdssm1l2Q&pub=1&gid=1');
	query.send(handleQueryResponse);
	}     
function handleQueryResponse(response) 
{

	if (response.isError()) 
		{
		//go to flash backup page
		window.location = "http://www.flettexchange.com/index.php?page=static"
		return;
		}
var data = response.getDataTable();

//new google.visualization.LineChart(document.getElementById('visualization')).
//draw(data, {width:580,height:250});  

//var CT2010set1 = new google.visualization.DataView(data);
//CT2010set1.setColumns([0, 1]);  
//var CT2010set = new google.visualization.LineChart(document.getElementById('CT2010set'));
//CT2010set.draw(CT2010set1, {width: 580, height: 300});

var CT2010set1 = new google.visualization.DataView(data);
CT2010set1.setColumns([0, 41]);
CT2010set1.hideRows(0,254);
var CT2010set = new google.visualization.LineChart(document.getElementById('CT2010set'));
CT2010set.draw(CT2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14,title: '2010 Connecticut Class I REC Settlement Price'});

var CA2010set1 = new google.visualization.DataView(data);
CA2010set1.setColumns([0, 1]);
CA2010set1.hideRows(0,254);
var CA2010set = new google.visualization.LineChart(document.getElementById('CA2010set'));
CA2010set.draw(CA2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14,title: '2010 California T-REC Settlement Price'});

var NY2010set1 = new google.visualization.DataView(data);
NY2010set1.setColumns([0, 1]);
NY2010set1.hideRows(0,274);
var NY2010set = new google.visualization.LineChart(document.getElementById('NY2010set'));
NY2010set.draw(NY2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14,title: '2010 New York SREC Settlement Price'});

var DE2010set1 = new google.visualization.DataView(data);
DE2010set1.setColumns([0, 5]);
DE2010set1.hideRows(0,80);
var DE2010set = new google.visualization.LineChart(document.getElementById('DE2010set'));
DE2010set.draw(DE2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14,title: '2010 Deleware SREC Settlement Price'});

var MA2010set1 = new google.visualization.DataView(data);
MA2010set1.setColumns([0, 13]); 
MA2010set1.hideRows(0,150); 
var MA2010set = new google.visualization.LineChart(document.getElementById('MA2010set'));
MA2010set.draw(MA2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2010 Massachusetts SREC Settlement Price'});    

var MD2010set1 = new google.visualization.DataView(data);
MD2010set1.setColumns([0, 9]);
MD2010set1.hideRows(0,136);
var MD2010set = new google.visualization.LineChart(document.getElementById('MD2010set'));
MD2010set.draw(MD2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2010 Maryland SREC Settlement Price'});

var NJ2010set1 = new google.visualization.DataView(data);
NJ2010set1.setColumns([0, 17]);
NJ2010set1.hideRows(0,275);
var NJ2010set = new google.visualization.LineChart(document.getElementById('NJ2010set'));
NJ2010set.draw(NJ2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2011 New Jersey SREC Settlement Price'});

var OH2010set1 = new google.visualization.DataView(data);
OH2010set1.setColumns([0, 21]);
OH2010set1.hideRows(0,136);
var OH2010set = new google.visualization.LineChart(document.getElementById('OH2010set'));
OH2010set.draw(OH2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2010 Ohio SREC Settlement Price'});

var PA2010set1 = new google.visualization.DataView(data);
PA2010set1.setColumns([0, 25]);
PA2010set1.hideRows(0,275);
var PA2010set = new google.visualization.LineChart(document.getElementById('PA2010set'));
PA2010set.draw(PA2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2011 Pennsylvania SREC Settlement Price'});  

var DC2010set1 = new google.visualization.DataView(data);
DC2010set1.setColumns([0, 29]);    
DC2010set1.hideRows(0,136);
var DC2010set = new google.visualization.LineChart(document.getElementById('DC2010set'));
DC2010set.draw(DC2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2009 Washington DC SREC Settlement Price'});    

var NJC12010set1 = new google.visualization.DataView(data);
NJC12010set1.setColumns([0, 33]);
var NJC12010set = new google.visualization.LineChart(document.getElementById('NJC12010set'));
NJC12010set.draw(NJC12010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2010 New Jersey Class I REC Settlement Price'});

var RGGI2010set1 = new google.visualization.DataView(data);
RGGI2010set1.setColumns([0, 37]);
var RGGI2010set = new google.visualization.LineChart(document.getElementById('RGGI2010set'));
RGGI2010set.draw(RGGI2010set1, {titleY: 'Settlement Price in US Dollars ($)',width: 580, height: 300, legend: 'none', lineSize: 4, pointSize: 0, borderColor: '#82cafa', titleFontSize: 14, title: '2010 Regional Greenhouse Gas Initiative Settlement Price'});
}
google.setOnLoadCallback(drawVisualization);