The Tournament Director Forums

Main => General Discussion => Topic started by: jrwilson1946 on March 12, 2006, 12:01:21 PM

Title: Getting a formula correct
Post by: jrwilson1946 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.
Title: Re: Getting a formula correct
Post by: TimDugan 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).
Title: Re: Getting a formula correct
Post by: MooseWizard 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.

Title: Re: Getting a formula correct
Post by: TimDugan on March 13, 2006, 09:41:55 PM
Ooo, does that actually work?  Sweet.