Author Topic: Getting a formula correct  (Read 2536 times)

jrwilson1946

  • Newbie
  • *
  • Posts: 13
    • View Profile
Getting a formula correct
« on: March 12, 2006, 12:01:21 PM »
I have been attempting to set up a formula with the following criteria.

The top 16 positions receive points regardless as the number of players.  1st place gets 16 points, 16th place gets 1 point, 17th through 48th place receive 0 points.  I have not been able to work out the formula.

Thanks for your help in advance.

TimDugan

  • Jr. Member
  • **
  • Posts: 89
    • View Profile
    • The Oregon Poker Tour
Re: Getting a formula correct
« Reply #1 on: March 12, 2006, 05:55:58 PM »
You're going to have to set up this in prize form under the "prizes" tab.  There's no way to program a formula the way you want to (as of yet).

MooseWizard

  • Jr. Member
  • **
  • Posts: 78
    • View Profile
    • Louisville Poker Society
Re: Getting a formula correct
« Reply #2 on: March 13, 2006, 03:22:55 PM »
Try the following:

max(17-(r), 0)

This should provide the higher of the two variables, either 17 minus rank, or 0.

For 1st place, 17-1= 16 points
for 2nd place, 17-2= 15 points
for 3rd place, 17-3= 14 points
...
...
for 16th place, 17-16= 1 point
for 17th place, 17-17= 0 points
for 18th place, 17-18= -1, in which the equation will award 0 points instead because 0 is greater than -1.
...
...
for 48th place, 17-48= -31, in which the equation will award 0 points instead because 0 is greater than -31.


This should work for what you need.

« Last Edit: March 13, 2006, 03:30:05 PM by MooseWizard »
The man, the myth, the moose!

TimDugan

  • Jr. Member
  • **
  • Posts: 89
    • View Profile
    • The Oregon Poker Tour
Re: Getting a formula correct
« Reply #3 on: March 13, 2006, 09:41:55 PM »
Ooo, does that actually work?  Sweet.