Author Topic: points formula help needed..please  (Read 1163 times)

chris carpol

  • Newbie
  • *
  • Posts: 1
    • View Profile
points formula help needed..please
« on: October 11, 2006, 02:58:05 AM »
 hi all,
this is all new to me so please fogive my ignorance. i am trying to write a formula(first attempt ever) with limited success the end goal is for the total number of points to be awarded as a percentage of the total # of entrants +
the total # of rebuys.
 hope i can express this clearly

24 players in tournament with 16 rebuys

 1st place would receive 100% of points = 40 points
2nd place 80% = 32 points
3rd place 70% = 28 points
4th place 60% = 24 points
5th place 50% = 20 points
6th place 40% = 16points
7th place 30% = 12 points
8th place 20% = 8 points
9th - 24th 5% = 2 points

hope that made sense to someone. the amount of players per tournament varies so it would be 9th place to last place always getting 5%
here's my closest effort to getting this to work after butchering one of coreys formulas but i can't get it quite right.

if(r == 1, 1.0, if(r == 2, .80, if(r == 3, .70, if(r == 4, .60, if(r == 5, .50, if(r == 6, .40, if(r == 7, .30, if(r == 8, .2, if(r == 9, .05, if(r == 10, .05, 0)))))))))) * 40 + (if(n > 10, (n-10)*.02, 0) * 40)

if anyone can help i've tried for about 8 hours with no luck so any input would be greatly appreciated.
thanks chris

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5428
    • View Profile
Re: points formula help needed..please
« Reply #1 on: October 11, 2006, 10:42:53 AM »
Well, your explanation doesn't actually seem to imply that the points awarded is dependent on the number of entrants, other than any player who ranks 9th or greater always gets 2% of 40.  I can't quite figure out what the last part of your formula is, but it seems to be if you take that part off, and simplify the rest a bit, you get what it looks like you described:

if(r == 1, 1.0, if(r == 2, .80, if(r == 3, .70, if(r == 4, .60, if(r == 5, .50, if(r == 6, .40, if(r == 7, .30, if(r == 8, .2, if(r >= 9, .05, 0))))))))) * 40

1st, 40.00
2nd, 32.00
3rd, 28.00
4th, 24.00
5th, 20.00
6th, 16.00
7th, 12.00
8th, 8.00
9th, 2.00
10th, 2.00
11th, 2.00
12th, 2.00
13th, 2.00
14th, 2.00
15th, 2.00
16th, 2.00
17th, 2.00
18th, 2.00
19th, 2.00
20th, 2.00

This allows you to easily change the maximum points awarded (40).  But the percentages of that maximum that is awarded doesn't change based on the number of players.... only on the finishing rank of a player.

theHammer

  • Newbie
  • *
  • Posts: 41
    • View Profile
Re: points formula help needed..please
« Reply #2 on: October 11, 2006, 01:54:50 PM »
I've been using the formula

round(10*sqrt(n)/sqrt(r))+nh+(3*nb)+(5*nbk)-nr

This awards more points for top-ranked finishers that had to go against a larger field, i.e. -

TEST ALL BUTTON:
16 players: 40, 28, 23, 20 (1st, 2nd, 3rd, 4th)
12 players: 35, 24, 20, 17
  8 players: 28, 20, 16, 14

This also has the tendency to shore up the bottom players points more, and keep folks "in the hunt" for the long-haul when they have an off-night, with last place in all above scenarios being awarded 10 points minimum.

The last part of the formula "+nh+(3*nb)+(5*nbk)-nr" awards additional points for being a HitMan and collecting Bounties, and awards negative points for Rebuys.

I ran a TEST redoing this years cumulative results (9 events) by plugging in Corey's formula posted, plus adding the tail-end of this formula above -- and the results were fairly close in comparison of one to the other, with the re-run results pulling the field of competition together a bit tighter.