Author Topic: Top 10 out of 12 tourny points?  (Read 1265 times)

Trips

  • Newbie
  • *
  • Posts: 14
    • View Profile
Top 10 out of 12 tourny points?
« on: August 12, 2008, 01:25:34 PM »
sum(top(10, scores))

sum(top(count(scores) - 2, scores))


Which of these will give me the top ten out of 12 tourney scores?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6220
    • View Profile
Re: Top 10 out of 12 tourny points?
« Reply #1 on: August 12, 2008, 04:52:56 PM »
Both - sort of.

The first one will count a player's top 10 scores out of any number of tournaments played.  So, if the player has played in 5 tournaments, all 5 will be included.  If he has played in 12, the top 10 will be included.  If he has played in 50, the top 10 will be included.  This one can be described as "sums the top 10 [or fewer] scores".

The second one will drop the bottom 2 scores.  If a player has played in 5 tournaments, the top 3 will be included.  If he has played in 12, the top 10 will be included.  If he has played in 50, the top 48 will be included.  This one can be described as "sums all scores after dropping the lowest 2".


badbeat

  • Full Member
  • ***
  • Posts: 114
    • View Profile
Re: Top 10 out of 12 tourny points?
« Reply #2 on: December 15, 2008, 09:18:19 PM »
I would use sum(top(6, scores)) as it's going to give the top 6 scores from however many you play. If you use the other type of formula, you will only count 5 scores if someone plays 7 games. Whichever formula you use, it goes in the "overall scoring" in the stats tab and will always produce your points leader, when you post your league standings. The dropped scores only come into effect once you play more than 6 games.