OT: quick and dirty interactive electoral vote calculator

[Stephen]

Matt Price wrote:
> hope it's ok to ask a quick non-linux question.  I'm just making a quick
> US election spreadsheet, with rows for the various states.  I intended
> to have a radio button for each row, with the possible values "Obama",
> "McCain", amd "Undecided"; depending on the value, the electoral votes
> for that state would be added to the electoral college total for Obama,
> McCain, or neither.  As far as i can see there's no simple way to do
> this in Openoffice.  
>   
I am not familiar with open office, but in EXCEL I would define a range 
to include three cells, Obama, McCain, Undecided.

Use these to make a drop down selection for the row for each state in 
column B. C column would have the electoral votes. D, E & F would have 
formulas to select the electoral votes based on the value of the drop down.

Add a totals row and you are done.

Stephen
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists