google.load('visualization', '1', { packages: ['linechart', "barchart", "columnchart"] });

var visualization_Env_SAP;
var visualization_Env_StockAge;
var visualization_Env_Energy;
var visualization_Env_HeatLoss;
var visualization_Env_CentralHeat;
var visualization_Env_NonDecentEng;
var visualization_Env_NonDecentWales;
var visualization_Env_NonDecentScot;
var visualization_Env_NonDecentNI;


function drawAllFigure() 
{
    drawVisualization_Env_SAP();
    drawVisualization_Env_StockAge();
	drawVisualization_Env_Energy();
    drawVisualization_Env_HeatLoss();
	drawVisualization_Env_CentralHeat();
	drawVisualization_Env_NonDecentEng();
    drawVisualization_Env_NonDecentWales();
    drawVisualization_Env_NonDecentScot();
    drawVisualization_Env_NonDecentNI();
	
}

//Env_SAP
function drawVisualization_Env_SAP() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_SAP= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_SAP');
    // Send the query with a callback function.
    query_Env_SAP.send(handleQueryResponse_Env_SAP);
}

function handleQueryResponse_Env_SAP(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Env_SAP = response.getDataTable();
    visualization_Env_SAP = new google.visualization.ColumnChart(document.getElementById('Env_SAP'));
    visualization_Env_SAP.draw(data_Env_SAP, { width: 706, height: 300, legend: "bottom", titleY: "SAP rating (out of 100)", is3D: true });
}

// Env_StockAge
function drawVisualization_Env_StockAge() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_StockAge = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_StockAge');
    // Send the query with a callback function.
    query_Env_StockAge.send(handleQueryResponse_Env_StockAge);
}

function handleQueryResponse_Env_StockAge(response) {
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Env_StockAge = response.getDataTable();
    visualization_Env_StockAge = new google.visualization.ColumnChart(document.getElementById('Env_StockAge'));
    visualization_Env_StockAge.draw(data_Env_StockAge, { width: 706, height: 300, legend: "bottom",titleY: "Percentage (%)", is3D: true, min: "0", isStacked:true });
}


//Env_Energy
function drawVisualization_Env_Energy() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_Energy= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_Energy');
    // Send the query with a callback function.
    query_Env_Energy.send(handleQueryResponse_Env_Energy);
}

function handleQueryResponse_Env_Energy(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Env_Energy = response.getDataTable();
    visualization_Env_Energy = new google.visualization.LineChart(document.getElementById('Env_Energy'));
    visualization_Env_Energy.draw(data_Env_Energy, { width: 706, height: 300, legend: "bottom", titleY: "Energy in gigajoules ", is3D: true });
}

//Env_HeatLoss
function drawVisualization_Env_HeatLoss() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_HeatLoss= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_HeatLoss');
    // Send the query with a callback function.
    query_Env_HeatLoss.send(handleQueryResponse_Env_HeatLoss);
}

function handleQueryResponse_Env_HeatLoss(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Env_HeatLoss = response.getDataTable();
    visualization_Env_HeatLoss = new google.visualization.LineChart(document.getElementById('Env_HeatLoss'));
    visualization_Env_HeatLoss.draw(data_Env_HeatLoss, { width: 706, height: 300, legend: "bottom", titleY: "Heat loss in watt per celcius degree", is3D: true });
}


//Env_CentralHeat
function drawVisualization_Env_CentralHeat() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_CentralHeat= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_CentralHeat');
    // Send the query with a callback function.
    query_Env_CentralHeat.send(handleQueryResponse_Env_CentralHeat);
}

function handleQueryResponse_Env_CentralHeat(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Env_CentralHeat = response.getDataTable();
    visualization_Env_CentralHeat = new google.visualization.ColumnChart(document.getElementById('Env_CentralHeat'));
    visualization_Env_CentralHeat.draw(data_Env_CentralHeat, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}
 


//Env_NonDecentEng
function drawVisualization_Env_NonDecentEng() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_NonDecentEng= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_NonDecentEng');
    // Send the query with a callback function.
    query_Env_NonDecentEng.send(handleQueryResponse_Env_NonDecentEng);
}

function handleQueryResponse_Env_NonDecentEng(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Env_NonDecentEng = response.getDataTable();
    visualization_Env_NonDecentEng = new google.visualization.ColumnChart(document.getElementById('Env_NonDecentEng'));
    visualization_Env_NonDecentEng.draw(data_Env_NonDecentEng, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}


// Env_NonDecentWales
function drawVisualization_Env_NonDecentWales() {
    // To see the data that this visualization uses, browse to
    var query_Env_NonDecentWales = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_NonDecentWales');
    // Send the query with a callback function.
    query_Env_NonDecentWales.send(handleQueryResponse_Env_NonDecentWales);
}

function handleQueryResponse_Env_NonDecentWales(response) 
{
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Env_NonDecentWales = response.getDataTable();
    visualization_Env_NonDecentWales = new google.visualization.ColumnChart(document.getElementById('Env_NonDecentWales'));
    visualization_Env_NonDecentWales.draw(data_Env_NonDecentWales, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}
 

// Env_NonDecentScot
function drawVisualization_Env_NonDecentScot() {
    // To see the data that this visualization uses, browse to
    var query_Env_NonDecentScot = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_NonDecentScot');
    // Send the query with a callback function.
    query_Env_NonDecentScot.send(handleQueryResponse_Env_NonDecentScot);
}

function handleQueryResponse_Env_NonDecentScot(response) {
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Env_NonDecentScot = response.getDataTable();
    visualization_Env_NonDecentScot = new google.visualization.ColumnChart(document.getElementById('Env_NonDecentScot'));
    visualization_Env_NonDecentScot.draw(data_Env_NonDecentScot, { width: 706, height: 500, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}

// Env_NonDecentNI
function drawVisualization_Env_NonDecentNI() 
{
    // To see the data that this visualization uses, browse to
    var query_Env_NonDecentNI = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Env_NonDecentNI');
    // Send the query with a callback function.
    query_Env_NonDecentNI.send(handleQueryResponse_Env_NonDecentNI);
}

function handleQueryResponse_Env_NonDecentNI(response) {
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Env_NonDecentNI = response.getDataTable();
    visualization_Env_NonDecentNI = new google.visualization.ColumnChart(document.getElementById('Env_NonDecentNI'));
    visualization_Env_NonDecentNI.draw(data_Env_NonDecentNI, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}


google.setOnLoadCallback(drawAllFigure);