csdl/makahiki — Issue #3: Make energy scoreboards work with static spreadsheet
Author: yongwen
Created: 2012-02-08 01:25:26+00:00
State: open

Makahiki consults the EnergyLastThirtyDays gdata spreadsheet to display the energy scoreboard. However, we want to stop updating that spreadsheet to ensure that the competition data doesn't fall off the end.

Currently Makahiki uses today's date to figure out how many columns it should skip to compute energy usage for the different rounds. This works during the competition when today is always the first column, etc. But with a static spreadsheet, it needs to look at the column headers (which contain dates) to see which columns to sum up.