The Tournament Director Forums

Main => Help Me => Topic started by: chiqmagne on May 13, 2011, 04:15:54 PM

Title: Help with points formula
Post by: chiqmagne 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
Title: Re: Help with points formula
Post by: Corey Cooper 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)
Title: Re: Help with points formula
Post by: chiqmagne on May 16, 2011, 11:21:07 AM
Thank you so much, Corey. BTW, I'm using the latest BETA. Your software is AWESOME!