Libreoffice calculation [OT]

[Michael D. Setzer II]

Why not just enter the regular number in the columns, and just do 
the formula in the total column?

Just enter the wins in Columns B thru G Then in H put the 
formula.
H3 would have, with x1 thru x5 replaced with your numbers.

=B3*x1+c3*x2+d3*x3+e3*x4+g3*x5

Otherwise, you could enter the number in one column, and have 
the formula to multiply it in the next. 


On 21 Mar 2011 at 22:03, Mike Chambers wrote:

Subject:        	Re: Libreoffice calculation [OT]
From:           	Mike Chambers <mike at miketc.net>
To:             	Fedora <users at lists.fedoraproject.org>
Copies to:      	"Michael D. Setzer II" 
<mikes at kuentos.guam.net>
Date sent:      	Mon, 21 Mar 2011 22:03:30 -0500

> On Tue, 2011-03-22 at 12:47 +1000, Michael D. Setzer II wrote:
> > Not real clear on what you are trying to do.
> 
> Basically what I am messing with, is the March Madness bracket office
> pool we have at work.  I take the number of wins for a round (example, 5
> wins) and want to be able to just input that number into the cell, and
> have it automatically multiply by a set number that scores for that
> round (example, 10).
> 
> Maybe this will help
> 
> Round 2 scores 4 points per win.  Someone gets 10 wins for that round.
> That would be 40 total points for that round.  So I want to be able to
> just input the 10 and have it automatically multiply by 4 for me,
> instead of doing it in my head/on calculator.  I also will be printing
> this sheet out (maybe converting to html first) to let everyone keep
> updated with the scores.  So except for the info for the brackets,
> nothing else needs to be on there.
> 
> Gonna post a URL to let you see what it currently looks like (html form)
> to get an idea of what I want seen.  Any calculations that need done are
> to be hidden and not seen.
> 
> http://www.miketc.net/bracket.html
> 
> -- 
> Mike Chambers
> Madisonville, KY
> 
> "The best town on Earth!"
> 


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:mikes at kuentos.guam.net                            
  mailto:msetzerii at gmail.com
  http://www.guam.net/home/mikes
  Guam - Where America's Day Begins                        
  G4L Disk Imaging Project maintainer 
  http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC at HOME CREDITS
SETI        10490968.605283   |   EINSTEIN     5602714.540851
ROSETTA      2933735.693119   |   ABC          5004638.189001