The Tournament Director Forums

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

Title: Formula help
Post 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?
Title: Re: Formula help
Post by: jodybingo on October 18, 2012, 01:15:22 PM
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
Title: Re: Formula help
Post by: Magic_fubu on October 18, 2012, 01:37:41 PM
Jody, I think you want the 10*(sqrt ..... (bc+0.75)) to all be enclosed within parenthesis, and add a comma, and a zero:

Code: [Select]
if (RoundOut>4), (10 * (sqrt(n)/sqrt(r*0.1)) * (2+log(bc+0.75))), 0
Title: Re: Formula help
Post by: jodybingo on October 18, 2012, 01:45:52 PM
No points are awarded when using the comma 0 (I copied/pasted)
Title: Re: Formula help
Post by: Corey Cooper on October 19, 2012, 10:36:40 AM
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)))
                                                      ^
Title: Re: Formula help
Post by: jodybingo on October 19, 2012, 11:56:19 AM
thank you Corey
Title: Re: Formula help
Post by: Magic_fubu on October 19, 2012, 02:30:23 PM
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