Main > General Discussion
Getting a formula correct
(1/1)
jrwilson1946:
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:
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:
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.
TimDugan:
Ooo, does that actually work? Sweet.
Navigation
[0] Message Index
Go to full version