There are 5 sheets in the file: 
https://docs.google.com/spreadsheet/ccc?key=0AvBLIH0W6HbJdDRnLW1vNklEYUJzZFJ5VmlvUFdSM3c


Sheets UnitA and UnitB are the budget sheets (more units can be added), 
the sheet has some rules on the right side, if the rule gets violated, 
it will warn the user by showing a red block.

Sheet "Overview" is the college level sheet, recording how to
distribute cost projections and revenue allocation among units. It also 
has some limitations on relation the total/internal revenue and cost.


To check the whether the subtotal of each unit matches the number in
overview, just click the menu "Buget tools"->"Validate Total Number",
it will show the entries which don't match. (available only to editors 
currently)

To view the slice of the data cube we use "pivot
table" which is available in all spreadsheet software. basically it
takes a group of data points in the form of (x,y,z,value), and can
create the slice on any direction of the 3.

The sheet "pivot table of cost" is the slice on cost and the sheet 
"pivot table of revenue" is the slice on revenue.

If you click the pivot table, a side panel will
show up on the right, at the bottom of the panel there is a "filter"
sub-panel. You can choose which revenue/cost you want to look at ( or
even the sum of multiple categories).

To update the pivot table, you need to click the menu "Budget 
tools"->"Merge Table". This will convert
the table of each unit into the format that the pivot table can handle,
and put them into the sheet "Allocation", and then the pivot table
will get updated by itself. (this too is only available to editors 
currently).

This template uses the script function of google spreadsheet. Actually
we only use the spreadsheet as input and output method, and write the
other functions we need in javascript (these can be viewed and edited 
only be editors currently).
It can be ported to microsoft excel, but
don't know whether we can port it to openoffice calc. For other non-CS
background people, a excel template may be preferred.