The Tournament Director Forums
Main => Help Me => Topic started by: AFroats13 on September 18, 2006, 02:42:48 PM
-
I have a points system that is based off of number of players and finishing place. Last place is awarded one point. Each place better earns one point more up to the money. If I pay out the top 3, the 2nd and 3rd place finishers earn 2 more points than the place before, with the winner receiving 3 points more than 2nd. For example –
o Eight seat tournament
1st – 12 pts
2nd – 9 pts
3rd – 7 pts
4th – 5 pts
5th – 4 pts
6th – 3 pts
7th – 2 pts
8th – 1 pt
Is there a formula that will do this? ??? Keep in mind, if I have more players, I may want to pay out 4 places, then 4th, 3rd, and 2nd would get 2 more points than previous, and 1st 3 more than 2nd. Thanks!
-
Does the points formula allow IF statements? Is it programable just like excel?
-
The formula does support "if" statements of the format if(condition, then, else). So, if(r<6, 2*(6-r), 0) would give points to those who rank 5th or better, 0 otherwise. 2 points to 5th place, 4 to 4th, 6 to 3rd, 8 to 2nd, and 10 to 1st. The user guide gives a more detailed explanation.
-
Does the formula field accept nested if formulas?
-
Yes.
-
Does the implementation of the "inthemoney" formula entry help out with simplifying my nested if formulae? This is what I have so far:
=IF(r=1,(n-r)+7,IF(r=2,(n-r)+5,IF(r=3,(n-r)+4,IF(r=4,(n-r)+3,IF(r=5,(n-r)+2,(n-r)+1))))), where the top 5 are in the money.
-
If you really want to make it simpler, I believe this will do, so long as you have prizes for the top 5 ranks:
n-r+1 + if(m, 6-r, 0) + if(r=1, 1, 0)