Author Topic: Formula help  (Read 1595 times)

jodybingo

  • Hero Member
  • *****
  • Posts: 667
    • View Profile
    • Personal Web Site
Formula help
« 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?

jodybingo

  • Hero Member
  • *****
  • Posts: 667
    • View Profile
    • Personal Web Site
Re: Formula help
« Reply #1 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

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formula help
« Reply #2 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
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!

jodybingo

  • Hero Member
  • *****
  • Posts: 667
    • View Profile
    • Personal Web Site
Re: Formula help
« Reply #3 on: October 18, 2012, 01:45:52 PM »
No points are awarded when using the comma 0 (I copied/pasted)

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Formula help
« Reply #4 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)))
                                                      ^

jodybingo

  • Hero Member
  • *****
  • Posts: 667
    • View Profile
    • Personal Web Site
Re: Formula help
« Reply #5 on: October 19, 2012, 11:56:19 AM »
thank you Corey

Magic_fubu

  • Hero Member
  • *****
  • Posts: 1035
    • View Profile
Re: Formula help
« Reply #6 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
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!