Author Topic: season formula  (Read 1537 times)

jkbrekne

  • Newbie
  • *
  • Posts: 8
    • View Profile
season formula
« on: September 03, 2012, 05:37:42 PM »
we are playing a 10nights season , but i only want the 7 best results to count, and i have no clue on how to write a formula  :( PLS help anyone!!!

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: season formula
« Reply #1 on: September 03, 2012, 08:53:44 PM »
How are you rating your players?  Are you awarding points or are you basing it strictly off of ranking?

jkbrekne

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: season formula
« Reply #2 on: September 04, 2012, 02:44:43 AM »
im using this formula in tourney  ((n-r+2)/2) * n + max((5-r)*10, 0)

but how can i filter out so that only the 7 best tourneys from a series of 10  will count at the end of a season??


Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: season formula
« Reply #3 on: September 04, 2012, 10:28:17 AM »
On the Stats tab, edit your Profile (it will be called a "Filter" in version 2, a "Profile" in version 3) and set the Tournament Score formula to:

points

Then set the Overall Score formula to:

sum(top(7, scores))

This will give the sum of the top 7 tournaments.  If you want to do something other than sum them let me know.

jkbrekne

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: season formula
« Reply #4 on: September 04, 2012, 02:20:41 PM »
Magic ;D

works like a charm , thank U