The Tournament Director Forums

Main => Help Me => Topic started by: mikkelkk on August 18, 2009, 07:39:39 AM

Title: A new formula needed
Post by: mikkelkk on August 18, 2009, 07:39:39 AM

Hi,
First of all, thanks for a great piece of software!

I am trying to create a formula for the tournament scoring for my home poker league (8-10 players), but can't figure out a good formula. I want it to favour the first 3 positions and also take into account the number of hits and the size of the prize pool.

I have tried with something like this: ((log10(pp))*(log10(pp))+sqrt(n)+nh)/(1+r)
But I would prefer to have a formula not resulting in points with weird decimals. I know using the LOG function should then be avoided, but need some inspiration from you guys ;-)

I have also tried this: (pp/(n*10))+nh+(sqrt((n/r)*10)) but I would like it to favour the top 3 a bit more.....

All suggestions are welcome!

Title: Re: A new formula needed
Post by: edneely on September 30, 2009, 10:13:54 AM

I'm new to this feature.  Is their a ROUND function?

Title: Re: A new formula needed
Post by: Corey Cooper on October 01, 2009, 08:24:09 PM

Yes.  Oddly enough, it's "round()".  :)

There's also a "ceil()" function to round up, and a "floor()" function to round down.  "round()" rounds to the nearest.