Author Topic: need formula for this pointing system  (Read 2417 times)

ferryman

  • Newbie
  • *
  • Posts: 10
    • View Profile
need formula for this pointing system
« on: June 21, 2006, 08:49:21 AM »
Hi, I need a Formula for this pointing system as this is what i wil be using

Each player’s points for a particular tourney will be calculated based on 1500 points for every game as follows:
1st = 120%, 2nd = 96%, 3rd =82%, 4th = 70%, 5th = 60%, 6th = 50%, 7th = 40%, 8th = 30%, 9th = 20%, 10th and lower = 10%.

• With 10 or less players the point scale will be the same. 1st place would receive 1800 points (1500 x 120%), 2nd place would receive 1440 points (1500 x 96%) and so on.

• For every player over 10, 2% would be added to the total points earned for each position for that particular tourney. In the 14 player tourney we recently completed, 8% (14 players - 10 players x 2%) would have been added on top of the regular points for each position. 1st place with 14 players would receive 1944 points. That number comes from adding 8% to the 1800 points for the regular 10 player point scale (calculated as 1800 x 1.08). 2nd place would be 1555.2 points (1440 x 1.08). This would change the difference in points earned for 1st place for the 14 player game vs. 1st place for the 10 player game (for example) to 8% instead of the 40% difference we currently show. And with our current method, the 40% difference only gets wider with each finishing place (2nd = 44% diff, 3rd = 50% diff...7th = 100% diff) but with the new method it would be 8% across the board when comparing 10 player points to 14 player points.

This alternate/new point system addresses a couple of holes that are present in our current point system:

ferryman

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: need formula for this pointing system
« Reply #1 on: June 21, 2006, 12:29:24 PM »
Here is a sample of something i am trying to work out, but this brings up an error is there any tutorials on how to use the formula

what i am trying to do

if there is less or equal to 10 players and you come first in the tournament then your points are 1500*120% else your points are 1500*120% + 2% added to your score for every person over ten players , i am not a mathematician so would like some help please.

if(n=<10) and (rank=1),1500*120%,1500*120%+2%*n-10

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: need formula for this pointing system
« Reply #2 on: June 21, 2006, 01:24:10 PM »
Multiply by 1.2 for 120%, .96 for 96%, or .02 for 2%, etc.

if(r == 1, 1.2, if(r == 2, .96, if(r == 3, .82, if(r == 4, .70, if(r == 5, .60, if(r == 6, .50, if(r == 7, .40, if(r == 8, .3, if(r == 9, .2, if(r == 10, .1, 0)))))))))) * 1500 + (if(n > 10, (n-10)*.02, 0) * 1500)

This formula is as close as I get get with your description.  Note that it gives 2% of 1500 points for each player over 10 in the tournament.  So, as in your example, if there are 14 players, it would give an additional 8% to _every_ player.  To give that extra 8% to only the top 10 finishers, use this one:

if(r == 1, 1.2, if(r == 2, .96, if(r == 3, .82, if(r == 4, .70, if(r == 5, .60, if(r == 6, .50, if(r == 7, .40, if(r == 8, .3, if(r == 9, .2, if(r == 10, .1, 0)))))))))) * 1500 + if(r <= 10, (if(n > 10, (n-10)*.02, 0) * 1500), 0)


I'll break this down for you:

if(r == 1, 1.2, if(r == 2, .96, if(r == 3, .82, if(r == 4, .70, if(r == 5, .60, if(r == 6, .50, if(r == 7, .40, if(r == 8, .3, if(r == 9, .2, if(r == 10, .1, 0))))))))))

This computes the % that the player receives, based on their finishing rank.  It checks specifically for ranks 1 through 10 and gives a unique percentage for each one, or 0 if the rank is not 1 through 10.  We then multiply that by 1500 to get the actual points.

if(r <= 10, (if(n > 10, (n-10)*.02, 0) * 1500), 0)

This part adds additional points only if they ranked in the top 10.  And the inner part of it:

(if(n > 10, (n-10)*.02, 0) * 1500)

... computes the additional percentage to add (number of players minus 10, multiplied by 2%), and multiplies it by 1500 to get the actual additional points.

Those two parts are added together for the final points.


Here's the first formula above run for a tournament with 14 players:
1st, 1,920.00
2nd, 1,560.00
3rd, 1,350.00
4th, 1,170.00
5th, 1,020.00
6th, 870.00
7th, 720.00
8th, 570.00
9th, 420.00
10th, 270.00
11th, 120.00
12th, 120.00
13th, 120.00
14th, 120.00


And here's the second one run for a tournament with 14 players:
1st, 1,920.00
2nd, 1,560.00
3rd, 1,350.00
4th, 1,170.00
5th, 1,020.00
6th, 870.00
7th, 720.00
8th, 570.00
9th, 420.00
10th, 270.00
11th, 0.00
12th, 0.00
13th, 0.00
14th, 0.00

ferryman

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: need formula for this pointing system
« Reply #3 on: June 21, 2006, 01:58:21 PM »
Thanks a lot, I will try it :)

 "This formula is as close as I get get with your description.  Note that it gives 2% of 1500 points for each player over 10 in the tournament.  So, as in your example, if there are 14 players, it would give an additional 8% to _every_ player."

From the first post i think what it actually means is that an extra 2% for every player over ten to the sum

 i.e if came in first then the points would be (120% of 1500)=A then 2% of A would be add to A,  if 12 players then 4% 13 players 6% and so on

second place would be then the points would be (96% of 1500)=A then 2% of A would be add to A,  if 12 players then 4% 13 players 6% and so on

if under ten players then there would be no added percentage to the total



« Last Edit: June 21, 2006, 02:14:28 PM by ferryman »

ferryman

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: need formula for this pointing system
« Reply #4 on: June 22, 2006, 04:04:17 AM »
I have substituted the equation with the answers as this seems easier so now all i want to do now is add 2% per player over 10 entered to the total
I tried this formula but not to sure why it gives the wrong answer 1t should be 14 players coming first should be 1944
1800*1.08  or 8%
if(r == 1,1800, if(r == 2, 1440, if(r == 3, 1230, if(r == 4, 1050, if(r == 5, 900, if(r == 6, 750, if(r == 7, 600, if(r == 8, 450, if(r == 9, 300, if(r> == 10, 150, 0))))))))))+if(n > 10, (n-10)*.02, 0)

Thanks

1st, 1,800.08
2nd, 1,440.08
3rd, 1,230.08
4th, 1,050.08
5th, 900.08
6th, 750.08
7th, 600.08
8th, 450.08
9th, 300.08
10th, 150.08
11th, 150.08
12th, 150.08
13th, 150.08
14th, 150.08

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: need formula for this pointing system
« Reply #5 on: June 22, 2006, 12:09:58 PM »
Here you go:

(if(r == 1, 1.2, if(r == 2, .96, if(r == 3, .82, if(r == 4, .70, if(r == 5, .60, if(r == 6, .50, if(r == 7, .40, if(r == 8, .3, if(r == 9, .2, if(r == 10, .1, 0)))))))))) * 1500) * (1 + if(n > 10, (n-10)*.02, 0))


10 players:
1st, 1,800.00
2nd, 1,440.00
3rd, 1,230.00
4th, 1,050.00
5th, 900.00
6th, 750.00
7th, 600.00
8th, 450.00
9th, 300.00
10th, 150.00


14 players:
1st, 1,944.00
2nd, 1,555.20
3rd, 1,328.40
4th, 1,134.00
5th, 972.00
6th, 810.00
7th, 648.00
8th, 486.00
9th, 324.00
10th, 162.00
11th, 0.00
12th, 0.00
13th, 0.00
14th, 0.00

ferryman

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: need formula for this pointing system
« Reply #6 on: June 23, 2006, 05:25:32 AM »
Thanks for your help works great  :)

Sanastas

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: need formula for this pointing system
« Reply #7 on: June 23, 2006, 06:15:11 PM »
I stink at the formula thing.
Below is the point we use, please help me write the formula.
1st 500
2nd 300
3rd 200
4th 100
5th 50
6th 50...

Thanks for the help.

Moose, please don't yell at me.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: need formula for this pointing system
« Reply #8 on: June 23, 2006, 08:41:05 PM »
if(r=1, 500, if(r=2, 300, if(r=3, 200, if(r=4, 100, 50))))

1st, 500.00
2nd, 300.00
3rd, 200.00
4th, 100.00
5th, 50.00
6th, 50.00
7th, 50.00
8th, 50.00
9th, 50.00
10th, 50.00
...

Not the most elegant, but it works.