The Tournament Director Forums
Main => Help Me => Topic started by: xtof on June 20, 2012, 09:44:18 AM
-
Hi
i've got a formula in excel but can't get in tournament.
this is the formula
1 for every player
for each player who's in get 1 point
for each place you come up in the ranking you get 2 points
ex : there are 30 players , I've get busted on 26 place that mains than (30-26+1)x2
points=(4+1) x 2 points = 5x2 = 10points
2 20% of first players
But also the first 20% of the total players get more points
for each place to the top you get 7 points extra
ex
you busted on the 3th place 20% of 30 = 6
6 players get extra points
1point for playing +((30-3+1)x2) points of your place + (((6+1)-3)x7) extra points
this is total points of 1+56+28=85 points.
mvg
-
1 for every player
for each player who's in get 1 point
for each place you come up in the ranking you get 2 points
ex : there are 30 players , I've get busted on 26 place that mains than (30-26+1)x2
points=(4+1) x 2 points = 5x2 = 10points
This part is pretty simple. How I approach this is to put a "1" in for "points for playing" and then in for the formula put (n - r + 1) * 2. Alternatively, you could leave out the 1 in the points for playing and make the formula be 1 + ((n - r + 1) * 2)
2 20% of first players
But also the first 20% of the total players get more points
for each place to the top you get 7 points extra
ex
you busted on the 3th place 20% of 30 = 6
6 players get extra points
1point for playing +((30-3+1)x2) points of your place + (((6+1)-3)x7) extra points
this is total points of 1+56+28=85 points.
This is going to be more difficult for me to figure out... I honestly don't think there is a way to automatically configure this out... Maybe someone else can lend a hand?
-
(position * 2) + if(r <= floor(n * .2), (floor(n * .2) + 1 - r) * 7, 0)
You didn't specify what to do when 20% of the number of players is not an even number. I used the "floor" function to round down. You could change it to "ceil" to round up, or "round" to round to the nearest whole number.