The Tournament Director Forums
Main => Help Me => Topic started by: aadne on October 27, 2017, 08:55:40 AM

OK this might be a difficult one, atleast for me.
I have made a formula in excel that I am using in tournaments.
But want to put it in the program if there is a possibility of that.
Ok here is the formula I am using.
Points = 36 * (ITMfactor) * (√entries/√player position) * (1+log10(average bet+0,25))
ITMfactor:
1 if player cashed
0.67 if player is top 9 but not cashed
0.33 if player placed 1099
Entries:
How many players in the tournament
Player position:
Which place the player busted
Average bet:
Each players average bet ( total price pool / Total Entries )
square root symbol: √

Was reading in the formula maker in the program and on the cheat sheet, but coulndt figure out if i could do it.
maybe on of you guys know how to rewrite this formula so that it work in the program.
Would be nice to get it automatically when we are playing.
Inserted a photo of the formula also (swedish language)(https://imgur.com/a/gv5Ck)
I also looked at Dr. Neau's Tournament Formula, have anybody used that in the program?
Or do any of you have used another formula that is decent ?

Got it to work, here it is if someone wants to try out a new points formula.
36 *((if(pw, 1)) + (if((rank <= 9) and (pw < 1) , 0.67 , 0)) + (if(rank>9,0.33))) *(sqrt(n)/sqrt(rank))*(1+log10(((totalBuyinsAmount+totalAddOnsAmount+totalRebuysAmount)/n) +0.25))

I think you can reduce the ITMFactor to:
if(pw, 1, if(rank <= 9, 0.67, 0.33))
pw is prize winnings. The inTheMoney variable was created for this. Either works, but there is a subtle difference. pw will have a value (and thus be "true") if the player has won any money at all. inTheMoney will only be true if the player has won a ranked prize. Therefore inTheMoney wouldn't be true for a player that won a bounty prize, or a manually awarded prize.
The other side can be reduced a little, too, but I personally tend to use parentheses when they're not completely necessary, so I'd probably do the same thing. But here it is nonetheless:
sqrt(n) / sqrt(rank) * (1 + log10((totalBuyinsAmount+totalAddOnsAmount+totalRebuysAmount) / n + 0.25))
For a total of:
36 * if(pw, 1, if(rank <= 9, 0.67, 0.33)) * sqrt(n) / sqrt(rank) * (1 + log10((totalBuyinsAmount+totalAddOnsAmount+totalRebuysAmount) / n + 0.25))