Author Topic: Yet another points debacle I messed up on  (Read 793 times)

cchur236

  • Newbie
  • *
  • Posts: 10
    • View Profile
Yet another points debacle I messed up on
« on: July 16, 2014, 10:37:12 PM »
So, I have my individual tournament points set as follows:  n - r + 1 + if(r == 1, 3)+ if(r == 2, 2) + if (r == 3,1).  That is 3 bonus points for 1st, 2 bonus points for 2nd and 1 bonus point for 1st.  At the buy-in you automatically get 5 points for playing, so in a 31 person tourney we just ran, the person knocked out first got 6 points (5 for playing plus 1 for last place).  2nd person knocked out got 7 pts, 3rd person 8 pts...3rd place got 35 points, 2nd place got 37 points and 1st place got 39 points.  These are all correct and all the points for each of the 6 tournaments we have run all calculate correctly for each tourney.  

Now the problem.  On the stats screen, I run the 'refresh' and get all my results for all players in each individual tourney which is great.  All values seem to be in line.  The column 'Sum' totals all the finishes for all of the tourneys.  I want to drop the worst score so I have this formula in the 'Overall Scores' sum(top(5,scores))  Since I have run 6, I just want to use 5 for now.  After the next tourney I will take top 6 of 7 and change it to sum(top(6,scores)).  in the columns, the Overall Scores are all wrong.  Some are off by 5 points, some by 1, but none seem to be spot on.  

Two questions, should I have anything in the 'Create Tournament Scores using formula' box since each tournament already calculates the proper scores using the first formula above.  Second, even though when I go into 'edit' on the 'Create Overall Scores' box, the "sum(top(5,scores))" shows up when the popup box appears.  The actual 'statistics Profile' page shows in the 'Create Tournament Scores using formula' the following:  "1 Formula".  It does not show the "sum(top(5,scores))".  

Sorry for the long post.  My brain is fried.


« Last Edit: July 17, 2014, 07:30:55 PM by cchur236 »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5381
    • View Profile
Re: Yet another points debacle I messed up on
« Reply #1 on: July 22, 2014, 03:08:05 PM »
Quote
Two questions, should I have anything in the 'Create Tournament Scores using formula' box since each tournament already calculates the proper scores using the first formula above.

Yes, you should have:

points

... as your Tournament Score formula.  This will set the value of the scores variable in the Overall Scores formula to the points the player received in each tournament.  If you're using version 3.2 or later (I believe), you could leave Tournament Score formula unset and instead use sum(top(6, listPoints)).  The listPoints variable is a list of the points a player received in each tournament.

Quote
Second, even though when I go into 'edit' on the 'Create Overall Scores' box, the "sum(top(5,scores))" shows up when the popup box appears.  The actual 'statistics Profile' page shows in the 'Create Tournament Scores using formula' the following:  "1 Formula".  It does not show the "sum(top(5,scores))".

You can have up to 5 Overall Scores formulas, the results of which will show up in the 5 Overall Score columns.  Since the Statistics Profiles dialog is really showing you a preview, it doesn't try to show you the 5 Overall Scores formulas.  Instead it just lists how many of the 5 actually have formulas assigned to them.

When you edit your Overall Scores formulas, notice there's a drop-down selection at the top where it says "Formula:".  There you can select which of the 5 Overall Scores formulas to work with.

cchur236

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Yet another points debacle I messed up on
« Reply #2 on: July 23, 2014, 12:02:04 AM »
Thanks Corey!