function doGet(e) {
  // Load the spreadsheet that contains the sheet of student data you want to chart, with the first column containing student email address.
  // Replace the spreadsheet KEY in quotes with yours
  var ss = SpreadsheetApp.openById("0AjdG0Zk4rfrwdDNWVE5RcDRUMWRud0lDYW81ZldtTHc");
  
  // Load the sheet that contains the data by name. Change the value in quotes to reflect your setup.
  var sheet = ss.getSheetByName("Grades");
  
  // Get the range of cells that store the Student ID lookup table, including the student email address as the first column.  This range name is defined within the spreadsheet in the Data-> dropdown.
  // Define this randge to include all students and data columns you hope to chart, leaving the row of column headers just above the selection.
  // In this example, the range "studentlookup" is defined as A2:I6
  var studentLookuprange = ss.getRangeByName("studentlookup");  
  
  
  // Set the number of the column that contains the first data column you want to include on the chart.  
  // This assumes the first column in the spreadsheet is 1 (not zero). Change to reflect your setup.
  var firstdatacolumn = 5;
  
  // Set some of the properties of your bar chart
  // Change the values in quotes to reflect your setup.  Colors can also be six character web colors starting with # ex) #00FFFF
  var horizontal = "Competencies";
  var vertical = "% Mastery";
  var title = "Progress Towards Mastery";
  var barcolor = "green";
  var min = 0;
  var max = 100;
  var width = 800;
  var height = 400;
      
  
  // For every row of student data, generate an object that contains all information from that row.
  var studentObjects = getRowsData(sheet, studentLookuprange);
  
  // Prepare an array to be filled with numerical data for use in the chart
  var columnData = new Array();
  
  // Load the labels from the header row of the spreadsheet
  var headerLabels = getHeaderLabels(sheet, studentLookuprange);
  
  // Load the email address of the currently logged-in user on the Site
  var loggedInEmail = Session.getActiveUser().getEmail();  
  
  // Prepare various variables for use as loop indeces
  var i = 0;
  var j = 0;
  var n = 0;

  if (loggedInEmail != "") {

  // Get the total number of students loaded from the defined range
  var k = studentObjects.length;
  
  // Load the currently logged in student's data
  // Note that i is a flag, which goes from 0 to 1 when a row's email matches the logged in user.
  for (;(i==0)&&(j<k);j++) {
  var lookupStudent = studentObjects[j];
    if ((lookupStudent["studentEmail"] == loggedInEmail)||(lookupStudent["parentEmail"] == loggedInEmail)) {
    i = 1;
    }
  }

  }
// If i never goes to 1, we assume the currently logged in user isn't listed in the spreadsheet.
if (i==1) {
     
    // Roll back j by one to compensate for the last index increase prior to flag
     j = j-1;
    // Current studentObjects object is keyed to column headers.  We need to build an array that is re-keyed using standard numerical indeces.
    for (var m in studentObjects[j]) {
      columnData[n]= studentObjects[j][m];
      n++;
      }
  // find the length of the array to be charted
  var x = columnData.length;
  
  // launch UI for sites gadget
  var app = UiApp.createApplication();
  
  // define student name variable
  // Note that all other values in the row are available using NORMALIZED version (lowercaseUpperNoSpaces) of the column headers
  var name = "Name: " + studentObjects[j].firstName + " " + studentObjects[j].lastName;
  
  // Example: to get report the value of the first competency, you could uncomment the related lines below
  //var competency1 = studentObjects[j].competency1;
  
  // Print student Info on the screen
  var nameLabel = app.createLabel(name).setStyleAttribute("fontSize","16px");
  // var competency1Label = app.createLabel(competency1).setStyleAttribute("fontSize","16px");
  
  // add the student name to the app container
  app.add(nameLabel);
  // app.add(competency1Label);
 
   // Build the data table for the chart
   var dataTable = Charts.newDataTable();
   
  // Add columns to data table
  dataTable.addColumn(Charts.ColumnType.STRING, horizontal);
  dataTable.addColumn(Charts.ColumnType.NUMBER, vertical);
  
  // Add rows of data to table by looping through array
  // Note that loop starts at the user-defined first data column and finishes at the last column in the defined range, allowing for easy expansion
  for (var h=firstdatacolumn-1;h<=x-1;h++) {
        dataTable.addRow([headerLabels[h],columnData[h]]);
  }
        
// Build the chart. 
var chart = Charts.newColumnChart()      
    .setDataTable(dataTable)        
    .setDimensions(width, height) 
    .setRange(min, max)
    .setColors([barcolor])
    .setXAxisTitle(horizontal)
    .setYAxisTitle(vertical)      
    .setTitle(title)      
    .build();

// Add our chart to the UI and return it so that we can publish  
// this UI as a service and access it via a URL.  
app.add(chart);  
return app;
  };
  
if (i==0)  {
    // launch UI for sites gadget
    var app = UiApp.createApplication();
    var notlistedwarn = "Your currently logged-in Google email address is not listed in the data that feeds the chart that's supposed to be here. \
        Please be sure you are logged into your school email account.  If the chart still doesn't display, let your teacher know something isn't working properly."; 
    var notlisted = app.createLabel(notlistedwarn).setStyleAttribute("fontSize","16px");
    app.add(notlisted);
    return app;
  }
}



// getRowsData iterates row by row in the input range and returns an array of objects.
// Each object contains all the data for a given row, indexed by its normalized column name.
// Arguments:
//   - sheet: the sheet object that contains the data to be processed
//   - range: the exact range of cells where the data is stored
//   - columnHeadersRowIndex: specifies the row number where the column names are stored.
//       This argument is optional and it defaults to the row immediately above range; 
// Returns an Array of objects.
function getRowsData(sheet, range, columnHeadersRowIndex) {
  columnHeadersRowIndex = columnHeadersRowIndex || range.getRowIndex() - 1;
  var numColumns = range.getEndColumn() - range.getColumn() + 1;
  var headersRange = sheet.getRange(columnHeadersRowIndex, range.getColumn(), 1, numColumns);
  var headers = headersRange.getValues()[0];
  return getObjects(range.getValues(), normalizeHeaders(headers));
}


// getHeaderLabels returns an array of strings from with the first row.
//   - sheet: the sheet object that contains the data to be processed
//   - range: the exact range of cells where the data is stored
//   - columnHeadersRowIndex: specifies the row number where the column names are stored.
//       This argument is optional and it defaults to the row immediately above range; 
// Returns an Array of objects.
function getHeaderLabels(sheet, range, columnHeadersRowIndex) {
  columnHeadersRowIndex = columnHeadersRowIndex || range.getRowIndex() - 1;
  var numColumns = range.getEndColumn() - range.getColumn() + 1;
  var headersRange = sheet.getRange(columnHeadersRowIndex, range.getColumn(), 1, numColumns);
  var headers = headersRange.getValues()[0];
  return headers;
}

// getColumnsData iterates column by column in the input range and returns an array of objects.
// Each object contains all the data for a given column, indexed by its normalized row name.
// Arguments:
//   - sheet: the sheet object that contains the data to be processed
//   - range: the exact range of cells where the data is stored
//   - rowHeadersColumnIndex: specifies the column number where the row names are stored.
//       This argument is optional and it defaults to the column immediately left of the range; 
// Returns an Array of objects.
function getColumnsData(sheet, range, rowHeadersColumnIndex) {
  rowHeadersColumnIndex = rowHeadersColumnIndex || range.getColumnIndex() - 1;
  var headersTmp = sheet.getRange(range.getRow(), rowHeadersColumnIndex, range.getNumRows(), 1).getValues();
  var headers = normalizeHeaders(arrayTranspose(headersTmp)[0]);
  return getObjects(arrayTranspose(range.getValues()), headers);
}


// For every row of data in data, generates an object that contains the data. Names of
// object fields are defined in keys.
// Arguments:
//   - data: JavaScript 2d array
//   - keys: Array of Strings that define the property names for the objects to create
function getObjects(data, keys) {
  var objects = [];
  for (var i = 0; i < data.length; ++i) {
    var object = {};
    var hasData = false;
    for (var j = 0; j < data[i].length; ++j) {
      var cellData = data[i][j];
      if (isCellEmpty(cellData)) {
        continue;
      }
      object[keys[j]] = cellData;
      hasData = true;
    }
    if (hasData) {
      objects.push(object);
    }
  }
  return objects;
}

// Returns an Array of normalized Strings.
// Arguments:
//   - headers: Array of Strings to normalize
function normalizeHeaders(headers) {
  var keys = [];
  for (var i = 0; i < headers.length; ++i) {
    var key = normalizeHeader(headers[i]);
    if (key.length > 0) {
      keys.push(key);
    }
  }
  return keys;
}

// Normalizes a string, by removing all alphanumeric characters and using mixed case
// to separate words. The output will always start with a lower case letter.
// This function is designed to produce JavaScript object property names.
// Arguments:
//   - header: string to normalize
// Examples:
//   "First Name" -> "firstName"
//   "Market Cap (millions) -> "marketCapMillions
//   "1 number at the beginning is ignored" -> "numberAtTheBeginningIsIgnored"
function normalizeHeader(header) {
  var key = "";
  var upperCase = false;
  for (var i = 0; i < header.length; ++i) {
    var letter = header[i];
    if (letter == " " && key.length > 0) {
      upperCase = true;
      continue;
    }
    if (!isAlnum(letter)) {
      continue;
    }
    if (key.length == 0 && isDigit(letter)) {
      continue; // first character must be a letter
    }
    if (upperCase) {
      upperCase = false;
      key += letter.toUpperCase();
    } else {
      key += letter.toLowerCase();
    }
  }
  return key;
}

// Returns true if the cell where cellData was read from is empty.
// Arguments:
//   - cellData: string
function isCellEmpty(cellData) {
  return typeof(cellData) == "string" && cellData == "";
}

// Returns true if the character char is alphabetical, false otherwise.
function isAlnum(char) {
  return char >= 'A' && char <= 'Z' ||
    char >= 'a' && char <= 'z' ||
    isDigit(char);
}

// Returns true if the character char is a digit, false otherwise.
function isDigit(char) {
  return char >= '0' && char <= '9';
}

// Given a JavaScript 2d Array, this function returns the transposed table.
// Arguments:
//   - data: JavaScript 2d Array
// Returns a JavaScript 2d Array
// Example: arrayTranspose([[1,2,3],[4,5,6]]) returns [[1,4],[2,5],[3,6]].
function arrayTranspose(data) {
  if (data.length == 0 || data[0].length == 0) {
    return null;
  }

  var ret = [];
  for (var i = 0; i < data[0].length; ++i) {
    ret.push([]);
  }

  for (var i = 0; i < data.length; ++i) {
    for (var j = 0; j < data[i].length; ++j) {
      ret[j][i] = data[i][j];
    }
  }

  return ret;
}