Formula

[xtof]

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

[Magic_fubu]

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?

[Corey Cooper]

(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.