1
Help Me / 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.
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.