// JavaScript Document
	function drawVisualization(dropdown) {
	var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key=pbm0LWWoYKfvBevKA7GHJcQ&pub=1');
	var queryString = 'SELECT *';
	if (dropdown.value == 0){
		queryString = 'SELECT *';
	}
	else if (dropdown.value == 1){
		queryString = queryString + ' WHERE D = 1';
	}
	else if (dropdown.value == 2){
		queryString = queryString + ' WHERE E = 1';
	}
	else if (dropdown.value == 3){
		queryString = queryString + ' WHERE F = 1';
	}
	if (dropdown.value == 4){
		queryString = queryString + ' WHERE G = 1';
	}
	if (dropdown.value == 5){
		queryString = queryString + ' WHERE H = 1';
	}
	if (dropdown.value == 6){
		queryString = queryString + ' WHERE I = 1';
	}
	if (dropdown.value == 7){
		queryString = queryString + ' WHERE J = 1';
	}
	if (dropdown.value == 8){
		queryString = queryString + ' WHERE K = 1';
	}
	if (dropdown.value == 9){
		queryString = queryString + ' WHERE L = 1';
	}
	if (dropdown.value == 10){
		queryString = queryString + ' WHERE M = 1';
	}
	if (dropdown.value == 11){
		queryString = queryString + ' WHERE N = 1';
	}
	if (dropdown.value == 12){
		queryString = queryString + ' WHERE O = 1';
	}
	if (dropdown.value == 13){
		queryString = queryString + ' WHERE P = 1';
	}
	if (dropdown.value == 14){
		queryString = queryString + ' WHERE Q = 1';
	}
	query.setQuery(queryString);
	query.send(handleQueryResponse);
}

function handleQueryResponse(response) {
	if (response.isError()) {
		 alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
		return;
	}
	var data = response.getDataTable();
	visualization = new google.visualization.Table(document.getElementById('table'));

	var formatter = new google.visualization.TablePatternFormat('<a class="textLinkB" href="{2}{1}" target="_blank">{0}</a>');
	formatter.format(data, [0, 1, 18]);
	var formatter = new google.visualization.TablePatternFormat('<p>{0}</p>');
	formatter.format(data, [2]);
	
	var view = new google.visualization.DataView(data);
	view.setColumns([0, 2]);
	
	data.sort([{column: 16, desc: true}, {column: 17}]);
	var customCSS = {oddTableRow: 'googleOddTableRow'};
	visualization.draw(view, {allowHtml: true, sort: 'disable', width: 570, cssClassNames: customCSS});
}
      google.setOnLoadCallback(drawVisualization);