The Tournament Director Forums
Main => Help Me => Topic started by: Kevziniou on October 20, 2013, 06:35:44 AM
-
Hello,
I am very bad with all this formula thing so if someone could help me it would be very nice !
Here's the formula I am looking for: if there is 10 players, the winner of the tournament gets 10 points, the 2nd gets 9 points, the third gets 8 points etc. + 1 point for every player you bust out.
Thank you very much !!!!! ;D
Kevin.
-
n-r+1 will do the trick for you. Last place will be awarded one point, and everyone else will get one more point. The amount awarded will change, based upon the number of players you have. See my two examples below.
Example 1: 3 players
1st: 3
2nd: 2
3rd: 1
Example 2: 10 players
1st: 10
2nd: 9
3rd: 8
4th: 7
5th: 6
6th: 5
7th: 4
8th: 3
9th: 2
10th: 1
-
Ok, let's make it more complicated.
1st gets 100
2nd gets 80
3rd gets 60
with a toltal of 20 places
also, each player gets 5 points for attending
-
Thank you MAgic Fubu !
-
Kevziniou - You're welcome!
tartoga1 - are you wanting just the top three of the 20 to be awarded points (besides the automatic 5), or is everyone in the top 20 getting points? If it's the 2nd option, then I would need to see more of your point structure to be able to assist, as the way you're going right now, you'd only be able to have five places paid out.
-
if(r < 4, 120 - (r * 20), n - r + 6)
Unless, as Magic_fubu noted, you were intending it to be 100 for 1st, 80 for 2nd, 60 for 3rd, 40 for 4th, 20 for 5th, etc. Which, again as Magic_fubu noted, is as far as you can go with that. The above yields the following for 20 players:
1: 100.00
2: 80.00
3: 60.00
4: 22.00
5: 21.00
6: 20.00
7: 19.00
8: 18.00
9: 17.00
10: 16.00
11: 15.00
12: 14.00
13: 13.00
14: 12.00
15: 11.00
16: 10.00
17: 9.00
18: 8.00
19: 7.00
20: 6.00
-
thanks everyone. food for thought.
-
since you all are so helpful ;-) I would appreciate the formula for the following point range;
1-100, 2-80, 3-65, 4-50, 5-45, 6-40, 7-35, 8-30, 9-25, 10-20
11-15, 12,14, 13-13, 14-12, 15=11, 16-10, 17-9, 18-8, 19-8, 20-8
ooops, I forgot to include getting 5 points for playing :)
-
switch(r, 1, 100, 2, 80, 3, 65, 4, 50, 5, 45, 6, 40, 7, 35, 8, 30, 9, 25, 10, 20, 11, 15, 12, 14, 13, 13, 14, 12, 15, 11, 16, 10, 17, 9, 18, 8, 19, 8, 20, 8) + 5