Author Topic: Help w/ Points Formulas  (Read 1152 times)

introvert8

  • Newbie
  • *
  • Posts: 3
    • View Profile
Help w/ Points Formulas
« on: August 22, 2008, 06:36:47 AM »
Hey guys, I'm new to TD and need some help.

I need a formula for our regular league games that:
1)  award all players points for playing
2)  awards players "in the money" additional points (i.e. - say 4 players are in the money, 1st place will get an additional 4 points, 2nd an additional 3 points, 3rd=2 and 4th=1 additional point)
3) our "season" has 15 regular games (sometimes less/more games) and we want to keep the top 10 'regular game' scores for our season ending free roll game (dropping the lowest 5 games this season). This allows players who can not make every game to not be penalized.

Thanks and TD ROCKS!
Jon

introvert8

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Help w/ Points Formulas
« Reply #1 on: August 24, 2008, 10:42:29 AM »
Bueller?

Please, can anyone give me some pointers.  I have read thru the forums and spent some time studying the manual, it's just beyond me.

Thanks, Jon

Phaze

  • Sr. Member
  • ****
  • Posts: 346
    • View Profile
Re: Help w/ Points Formulas
« Reply #2 on: August 24, 2008, 01:58:23 PM »
(n - r + 1) + if(r <= mr, mr - r + 1, 0)

This formula satisfies your requirements for your first two points... You put this formula in the formula window on your game tab

For your third point open up the Stats tab, click on the Filter button and in the new window on the bottom right hand side click on the Overall Scoring button.

sum(top(10, scores))

This should get ya rolling



introvert8

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Help w/ Points Formulas
« Reply #3 on: August 25, 2008, 03:02:09 PM »
Thank you Phaze!!!

I will give it a spin.