Author Topic: formula  (Read 1304 times)

mm48

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
formula
« 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

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: formula
« Reply #1 on: September 30, 2013, 12:43:04 PM »
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?

mm48

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
Re: formula
« Reply #2 on: October 01, 2013, 02:40:17 AM »
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)
...
« Last Edit: October 01, 2013, 02:42:51 AM by mm48 »

mm48

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
Re: formula
« Reply #3 on: October 01, 2013, 06:53:15 AM »
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

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: formula
« Reply #4 on: October 02, 2013, 11:06:07 AM »
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)

mm48

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
Re: formula
« Reply #5 on: October 03, 2013, 05:44:42 AM »
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

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: formula
« Reply #6 on: October 03, 2013, 10:08:49 AM »
Quote
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.