Author Topic: Points formula help for a numpty please.  (Read 1579 times)

Zipraker

  • Newbie
  • *
  • Posts: 2
    • View Profile
Points formula help for a numpty please.
« 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.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Points formula help for a numpty please.
« Reply #1 on: December 16, 2009, 09:52:38 AM »
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((20-r) * 25) + max(0, (8-r) * 25) + max(0, (2-r) * 150) + (n * 10))

Zipraker

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Points formula help for a numpty please.
« Reply #2 on: December 16, 2009, 11:40:13 AM »
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)    :)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Points formula help for a numpty please.
« Reply #3 on: December 16, 2009, 03:02:19 PM »
Points for Playing on the Game tab.