View previous topic :: View next topic |
Author |
Message |
anoamas321 "Cowboys"
Joined: 07 Apr 2010 Posts: 26
|
Posted: Thu Apr 08, 2010 2:34 am Post subject: combine, spreadsheet and formula to score leauges |
|
|
i run a small leauge just for fun, and i use a points system, of 10,6,4,3,2,1
for 1st though 6th.(avg game 10 players) + knockout count /2(rounded down). i would like to be able to this with out entering manul points scores after each game |
|
Back to top |
|
|
drneau Site Admin
Joined: 13 Feb 2005 Posts: 2385 Location: Woodbury, MN
|
|
Back to top |
|
|
anoamas321 "Cowboys"
Joined: 07 Apr 2010 Posts: 26
|
Posted: Thu Apr 08, 2010 6:01 am Post subject: |
|
|
ok so exactly how would that be done, i cant figure it out |
|
Back to top |
|
|
drneau Site Admin
Joined: 13 Feb 2005 Posts: 2385 Location: Woodbury, MN
|
Posted: Thu Apr 08, 2010 6:22 am Post subject: |
|
|
Your formula would look something like this
round( if Finish = 1 then 10 + (knockoutCount / 2)
else if Finish = 2 then 6 + (knockoutCount / 2) ..... ) _________________ --
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau |
|
Back to top |
|
|
anoamas321 "Cowboys"
Joined: 07 Apr 2010 Posts: 26
|
Posted: Thu Apr 08, 2010 7:19 am Post subject: |
|
|
k thanks, it would take a while to set up but is doable, the other thing is does it round or will it score half points, i want to not have half points and round down |
|
Back to top |
|
|
|