awong-dev

Budget Category	North Beach	Sacajewea	Sanislo	Stevens
Teaching	$4,703,004.66	$3,745,920.86	$2,798,710.64	$2,133,890.54
Principal Office	$508,197.73	$385,685.13	$409,689.50	$362,218.07
Teaching Support	$282,486.22	$272,033.58	$370,283.80	$256,912.67
Other Support Activities	$222,382.81	$199,180.83	$184,004.32	$208,177.46
Central Administration	$2,125.78	$14,171.85	-	-
Uncategorized	$31.03	$2,339.53	-	$2,113.22

awong-dev

function toDataByLocation(data) {
  const headers = data.values[0];
  const approvedIndex = headers.findIndex( e => e === 'Approved' );
  const stateIndex = headers.findIndex( e => e === 'State?' );
  const cityIndex = headers.findIndex( e => e === 'City' );
  const data_by_location = {};

  const published_entries = data.values.slice(1).filter((entry) => entry[approvedIndex] === "x");

  published_entries.forEach( entry => {