Author Topic: Adding stats columns question  (Read 609 times)

Breed

  • Newbie
  • *
  • Posts: 3
    • View Profile
Adding stats columns question
« on: May 29, 2011, 08:43:09 PM »
Hi all
New to the forums. Thanks for making a great product Corey!

I have two formulas I am using and want to add the columns together

I am using
if(r<=9,100*(sqrt(n))/(r + 1),0) for my tournament scoring

Overall score is
sum(top(8,scores))

Points is
if(r<=18,n-r+1,0)

These all work fine and give me correct calculations under the stats tab

What I would like to do is add points to Overall score in a separate column under stats. Is this possible? Thanks

Breed

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Adding stats columns question
« Reply #1 on: May 29, 2011, 09:44:49 PM »
Ok so I came up with one big formula

if(r<=18,r+n-1,0)+if(r<=9,100*(sqrt(n))/(r + 1),0)

However its giving me values finishes beyond 9th place that are clearly from the second if statment

Is there a way to join these together ?

Breed

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Adding stats columns question
« Reply #2 on: May 29, 2011, 09:51:53 PM »
Nevermind I got it

Its n-r+1 lol

Its getting too late to be doing this stuff