The Tournament Director Forums
Main => Help Me => Topic started by: jodybingo on October 18, 2012, 01:09:01 PM

I want to use this formula
if (ro>4),10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))
This should produce points for all players that are eliminated after round 4. However all players are getting points. Where is the error?

I just modified the formula as per an earlier post to this
if (RoundOut>4),10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))
with the same results. All players get points regardless of when they are eliminated

Jody, I think you want the 10*(sqrt ..... (bc+0.75)) to all be enclosed within parenthesis, and add a comma, and a zero:
if (RoundOut>4), (10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))), 0

No points are awarded when using the comma 0 (I copied/pasted)

I want to use this formula
if (ro>4),10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))
This should produce points for all players that are eliminated after round 4. However all players are getting points. Where is the error?
Misplaced parenthesis:
if (ro>4),10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))
^
Move it to the end:
if (ro>4,10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75)))
^

thank you Corey

Bah.... Sorry Jody... And thanks Corey for fixing what I missed... One of these days, I swear I'll get one of these complex formulas correct. :D