OT: quick and dirty interactive electoral vote calculator

[Matt Price]

On Sat, 2008-11-01 at 14:45 -0400, Stephen wrote:
> 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.

thanks stephen. that taught me quite a bit about spreadsheets -- i
learned how to to makethose dropdown boxes, and how to put conditional
statements into cell formulae.  The format still seems a little bit
limited to me -- the dropdown box is a little awkward to navigate; i
feel like i ought to be able to insert other kinds of elements, like
checkboxes.  i'm going to look at the forms capabilities of ooo and see
if that provides some extra flexibility...

matt


> 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
-- 
Matt Price
matt.price-H217xnMUJC0sA/PxXw9srA at public.gmane.org
--
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