Author Topic: Formula  (Read 698 times)

xtof

  • Newbie
  • *
  • Posts: 16
    • View Profile
Formula
« 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
« Last Edit: June 20, 2012, 09:50:26 AM by xtof »

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formula
« Reply #1 on: June 20, 2012, 10:02:47 AM »

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?
My cowboys shot down your rockets
---
If you send a request to me please send that you got me from here w/your TD name to confirm. Thanks!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Formula
« Reply #2 on: June 21, 2012, 02:50:01 PM »
(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.