Author Topic: Points Formula Help  (Read 967 times)

Stuart Murray

  • Sr. Member
  • ****
  • Posts: 497
    • View Profile
Points Formula Help
« on: August 07, 2010, 08:04:19 AM »
So i've taken the step of trying to add points to lleague games which can then be displayed on-screen but i need help in how to award the correct points, pretty basic scoring system:

200 points for playing
1st 30%
2nd 20%
3rd 13%
4th 10%
5th 9%
6th 7%
7th 6%
8th 5%
all others 50 points

there is also a bonus 30 points for having your membership card which applies to all games where the laptop is used

anyone that can come up with the formula would be greatly appreciated!

Stu
Stuart Murray

Stuart Murray

  • Sr. Member
  • ****
  • Posts: 497
    • View Profile
Re: Points Formula Help
« Reply #1 on: August 09, 2010, 09:16:23 AM »
Can anyone help with this formula?
Stuart Murray

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5525
    • View Profile
Re: Points Formula Help
« Reply #2 on: August 09, 2010, 11:31:11 AM »
if(r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 200, 50)

Unless I am reading this wrong.  Is the points pool always 200?  If so, there's no point in percentages, because you can figure out that 30% of 200 is 60 ahead of time, and simply award 60 points to first place (etc).  Also, 2nd through 8th get LESS than 50 points based on this.  For a 15 player tournament, you get:

 1st: 60.0000
 2nd: 40.0000
 3rd: 26.0000
 4th: 20.0000
 5th: 18.0000
 6th: 14.0000
 7th: 12.0000
 8th: 10.0000
 9th: 50.0000
10th: 50.0000
11th: 50.0000
12th: 50.0000
13th: 50.0000
14th: 50.0000
15th: 50.0000

Stuart Murray

  • Sr. Member
  • ****
  • Posts: 497
    • View Profile
Re: Points Formula Help
« Reply #3 on: August 09, 2010, 11:39:49 AM »
apologies Corey no it's 200 points per player in the pool, so for 20 players the pointspool would be 4000 etc

Cheers
Stuart
Stuart Murray

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5525
    • View Profile
Re: Points Formula Help
« Reply #4 on: August 09, 2010, 12:15:22 PM »
Oh, well, that's an easy change:

if(r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 200 * n, 50)

Stuart Murray

  • Sr. Member
  • ****
  • Posts: 497
    • View Profile
Re: Points Formula Help
« Reply #5 on: August 09, 2010, 12:33:08 PM »
Cheers, is there a way of adding the 30 bonus points to all players score? for example

if(r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 200 + 30 * n, 50)

Stu

Edit

I've got it functioning correctly awarding 1,200 points to 1st for a 10 player tourney using:
if (r < 9, switch(r, 1, .3, 2, .2, 3, .13, 4, .1, 5, .09, 6, .07, 7, .06, 8, .05) * 2000 * n, 80)

Note the 80 change for 9th+ (adding the bonus 30 points to 9th and above.  I don't know if it is possible to award the bonus 30 points to 1-8th places.

NExt problem I have identified is I can't seem to get the prizes to appear on the prizes tab or on the display?

I have points for playing set to 200 and the above formula, when I use test range all the points are correct based on the percentile used.

Stu
« Last Edit: August 09, 2010, 12:49:33 PM by stuamurr »
Stuart Murray