Author Topic: Pokerstars formula help  (Read 3001 times)

bjp001

  • Newbie
  • *
  • Posts: 1
    • View Profile
Pokerstars formula help
« on: March 03, 2008, 01:23:21 PM »
Will TD support a formula just like the Pokerstars formula?

I am having trouble getting it to work.

I am using the following: 10 * [sqrt(n)/sqrt(r)] * [1+log(b+0.25)]

Are the sqrt and log functions a problem?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6220
    • View Profile
Re: Pokerstars formula help
« Reply #1 on: March 03, 2008, 02:02:37 PM »
Well, if you are setting the formula to exactly what you've posted, then the problem is the [] and the variable 'b'.

First, the [] are not allowed.  I think Pokerstars probably used them for readability, but they have no place in the formula.  Replace them with ().

The 'b' variable has no meaning to the Tournament Director.  What is it supposed to represent?

Also make sure that the 'n' variable represents the number of players in the tournament, and the 'r' variable represents the player's rank, because that is what they mean to the Tournament Director.

Finally, the 'log' function, although will work, may not have the same meaning.  From the TD user manual:

log()
The natural logarithm (base E) of a number. Example: log(2) returns 0.6931471805599453.

log10()
The logarithm (base 10) of a number. Example: log10(2) returns 0.3010299956639812.

So you may need to replace log() with log10() to get the same results as PS.


Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Pokerstars formula help
« Reply #2 on: March 03, 2008, 06:19:49 PM »
Points = 10 * [sqrt(n)/sqrt(k)] * [1+log(b+0.25)]

Where:

n is the number of entrants
k is the place of finish (k=1 for the first-place finisher, and so on)
b is the buy-in amount in dollars (excluding administrative fee). For freerolls the buy-in

Example 1: A player takes third place in a $20 tournament with a field of 150 players. Here:

n = 150, k=3, b=20

The total points awarded to this player are:

= 10 * [sqrt(n)/sqrt(k)] * [1+log(b+0.25)]
= 10 * [sqrt(150)/sqrt(3)] * [1+log(20+0.25)]
= 10 * sqrt(50) * (1+1.31)
= 10 * 7.071 * 2.31
= 163.09 (rounded up)

Downloadable Excel sheet to calculate TLB points - leaders.xls.

----------------

just happened to be looking at this the other day, hope it helps.... BTW, bjp001, The sqrt function does work  :)
« Last Edit: March 03, 2008, 06:22:29 PM by Phaze »

MattBurlew

  • Jr. Member
  • **
  • Posts: 78
    • View Profile
Re: Pokerstars formula help
« Reply #3 on: March 08, 2008, 11:35:35 PM »
Per the Excel spreadsheet, the log in question is base 10.

Buy in cost in TD is bc.

So the formula would be:

10 * sqrt(n) / sqrt(k) * (1 + log10(bc+0.25))