Re: Libreoffice calculation [OT]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx>
To:             	Fedora <users@xxxxxxxxxxxxxxxxxxxxxxx>
Copies to:      	"Michael D. Setzer II" 
<mikes@xxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxx                            
  mailto:msetzerii@xxxxxxxxx
  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@HOME CREDITS
SETI        10490968.605283   |   EINSTEIN     5602714.540851
ROSETTA      2933735.693119   |   ABC          5004638.189001

-- 
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines

[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux