Author Topic: Help with points formula  (Read 704 times)

chiqmagne

  • Newbie
  • *
  • Posts: 6
    • View Profile
Help with points formula
« on: May 13, 2011, 04:15:54 PM »
Hello TD Netizens!

I have a poker league with roughly 80 different players and we have a points system for players that make the final table. Here is how our players earn points in our system:

1st: 100pts + 10% of Cash won (example $1100 won = 110pts, thus 210 total points)
2nd: 75pts + 10% of $
3rd: 50pts + 10%
4th: 35pts + 10%
5th: 20pts + 10%
6th: 15pts + 10%
7th: 10pts + 10%
8th: 8pts +10%
9th: 6pts + 10%
10th: 5pts + 10%

Can anyone suggest a formula that I can use to "automate" this in the database? We use the points to establish chip stacks in our league's monthly championship. Thanks in advance for your help.

Le ChiqMagne

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5426
    • View Profile
Re: Help with points formula
« Reply #1 on: May 16, 2011, 10:20:11 AM »
Use this formula for the Points for Playing field on the Game tab:

switch(r, 1, 100, 2, 75, 3, 50, 4, 35, 5, 20, 6, 15, 7, 10, 8, 8, 9, 6, 10, 5) + if(r < 11, totalWinnings * .1)

chiqmagne

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Help with points formula
« Reply #2 on: May 16, 2011, 11:21:07 AM »
Thank you so much, Corey. BTW, I'm using the latest BETA. Your software is AWESOME!