The Tournament Director Forums
Main => Help Me => Topic started by: Zipraker on December 15, 2009, 06:52:07 PM

Hi.
I TD for a pub poker league so thought I'd make things easier for myself so got the program, and am loving it, but please, please can anyone please help with working out the points formula because I just can't figure it out.....
I need a formula that gives set points to the top 16 players plus bonus points of 10 x (number of players).
Set points are:
1 800
2 600
3 550
4 500
5 450
6 400
7 350
8 300
9 275
10 250
11 225
12 200
13 175
14 150
15 125
16 100
I.E. In a 24 entrant game, 1st would get 1040, (800 +(24x10)). 11th would get 465, (225+(24x10). I know it looks easy but I'm a math's numpty so would REALLY appreciate some help.
Cheers guys and gals.
Zip.

switch(r, 1, 800, 2, 600, 3, 550, 4, 500, 5, 450, 6, 400, 7, 350, 8, 300, 9, 275, 10, 250, 11, 225, 12, 200, 13, 175, 14, 150, 15, 125, 16, 100) + (n * 10)
You didn't say whether or not the bonus points apply to everyone who plays or just the top 16 players. The formula above awards it to everyone. If it should only be the top 16, then the formula would be:
switch(r, 1, 800, 2, 600, 3, 550, 4, 500, 5, 450, 6, 400, 7, 350, 8, 300, 9, 275, 10, 250, 11, 225, 12, 200, 13, 175, 14, 150, 15, 125, 16, 100) + if(r < 17, (n * 10))
Or here's the way to do it without a "switch":
if(r < 17, max((20r) * 25) + max(0, (8r) * 25) + max(0, (2r) * 150) + (n * 10))

That's brilliant, thanks so much Corey, now all I need to do is work out where to put the formula to get it working....(told you, I'm a numpty) :)

Points for Playing on the Game tab.