The Tournament Director Forums
Main => Help Me => Topic started by: mm48 on September 28, 2013, 09:18:26 AM
-
Can you help me with a formula
my problem :
formula = (10 * sqrt(n) ) / sqrt(r)
with r = rank
n players (n = 10 to 150)
Only have points rank 1 to rank n * a(%)
Players 1 and 2 have formula points + p1 points + p2 points
Players 3 to 8 have formula points + p1 points
All the others player (except rank > r*a(%) who have 0 points) have formula points
Thank's
-
Can you help me with a formula
my problem :
formula = (10 * sqrt(n) ) / sqrt(r)
with r = rank
n players (n = 10 to 150)
Only have points rank 1 to rank n * a(%)
Players 1 and 2 have formula points + p1 points + p2 points
Players 3 to 8 have formula points + p1 points
All the others player (except rank > r*a(%) who have 0 points) have formula points
Thank's
You lost me.
Can you help me with a formula
my problem :
formula = (10 * sqrt(n) ) / sqrt(r)
with r = rank
n players (n = 10 to 150)
OK, I get this, I think.
Only have points rank 1 to rank n * a(%)
Does this mean that you want to only award points to a certain percent of the total players? For example, you want to be able to say that only the top 10% ranked players get points?
Players 1 and 2 have formula points + p1 points + p2 points
Players 3 to 8 have formula points + p1 points
All the others player (except rank > r*a(%) who have 0 points) have formula points
What are p1 and p2 points?
-
Does this mean that you want to only award points to a certain percent of the total players? For example, you want to be able to say that only the top 10% ranked players get points?
Yes
What are p1 and p2 points?
example : for p1 = 100 and p2 = 50
rank =1 points = (10 * sqrt(n) ) / sqrt(r) + 100 +50
rank =2 points = (10 * sqrt(n) ) / sqrt(r) + 100 +50
rank =3 points = (10 * sqrt(n) ) / sqrt(r) + 100
...
rank =7 points = (10 * sqrt(n) ) / sqrt(r) + 100
rank =8 points = (10 * sqrt(n) ) / sqrt(r) + 100
rank =9 points = (10 * sqrt(n) ) / sqrt(r)
rank =9 points = (10 * sqrt(n) ) / sqrt(r)
...
-
I think i found :
if (r>n*(a*0,01),0,1)* roundUpToNearest (((10*sqrt(n))/(sqrt(r)) + if (r < 9,P1,0) + if (r < 3,P2,0)),10)
Is it correct ?
I test and i come back
Thank's
-
That actually looks close to what I *think* you're trying to do. A couple of things, though:
if (r>n*(a*0,01),0,1)*
OK, I see what you're trying to do here, which is multiply the entire formula by 1 of the player falls into the top a% ranked players, or 0 otherwise. In other words, only award points to the top a% of players. This looks correct except you need to replace that comma (,) with a period (.):
if (r>n*(a*0,01),0,1)* should be if (r>n*(a*0.01),0,1)*
Other than that it looks OK. But where do the values for "a", "P1", and "P2" come from? If these are values you want to be able to easily change each tournament, you need to add them to the formula, like this:
assign("a", 10);
assign("P1", 100);
assign("P2", 50);
if (r>n*(a*0.01),0,1)* roundUpToNearest (((10*sqrt(n))/(sqrt(r)) + if (r < 9,P1,0) + if (r < 3,P2,0)),10)
-
For comma/period in my preference/currency number my decimal point is comma
For a, P1, P2, i imagine to change the values in the formula. But i prefer your proposal to use "assign"
Thank you for your help
-
For comma/period in my preference/currency number my decimal point is comma
But in formulas, decimals must use periods and functions must use commas, regardless of this preference.