Author Topic: A new formula needed  (Read 884 times)

mikkelkk

  • Newbie
  • *
  • Posts: 11
    • View Profile
A new formula needed
« 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!

« Last Edit: August 18, 2009, 12:37:04 PM by mikkelkk »

edneely

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: A new formula needed
« Reply #1 on: September 30, 2009, 10:13:54 AM »
I'm new to this feature.  Is their a ROUND function?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: A new formula needed
« Reply #2 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.