Author Topic: Trouble Summarizing Player Scores  (Read 900 times)

Mecheng

  • Newbie
  • *
  • Posts: 7
    • View Profile
Trouble Summarizing Player Scores
« on: May 28, 2009, 11:35:28 PM »
This past week end I discovered that the players score is not being correctly accumulated. First, is how I set up my program to calculate a score for each player.

Tournament Scoring Box: I use the default formula - (log((n + 1) / r))

Overall Scoring Box - Box 1 - OVERALL SCORE title changed to AVG SCORE and I use the default formula with one minor modification. I multiply the default formula by 100 which assigns each player a score between 0 and 100 instead of between 0 and 1 for each tournament.
Formula - ((1-exp(-average(scores)))*100).

Overall Scoring Box - Box 2 - OVERALL SCORE 2 title changed to TOTAL SCORE. I take the formula from the first box which calculates the average score for a player and multiply the average score by count(scores) to get the total score for each player
Formula - ((1-exp(-average(scores)))*100)*(count(scores))

The normal way to summarize the player scores would be to set the filter to include the desired dates and export the results.

The following is the result for 4/1/2009 thru 5/22/2009 (Eight Tournaments):
   Place   Name   Buy-ins   Tot Winnings   Tot Score         
April - May   1   Player  1   8   $385.00    588   588   April - May Totals

The following are the results from running April and May summaries separately: 
April   6   Player  1   4   $55.00    218   218   April Total   
May   1   Player  1   4   $330.00    339   339   May Total   
                        
         8   $385.00    557   557   April - May Totals

The following are the results for running a summary on each tournament:
3-Apr   6   Player  1   1   $55.00    79         
10-Apr   7   Player  1   1   $0.00    68         
17-Apr   9   Player  1   1   $0.00    31         
24-Apr   16   Player  1   1   $0.00    6   184   April Total   
1-May   1   Player  1   1   $190.00    95         
8-May   8   Player  1   1   $0.00    60         
15-May   1   Player  1   1   $140.00    93         
22-May   5   Player  1   1   $0.00    58   306   May Total   
                        
         8   $385.00    490   490   April - May Totals

As you can see above:
Summary of all 8 = a total score of       588
Summary of April + May = a score of    557
Adding the 8 scores = a tot score of       490

I have run the summaries on both my lap top a Dell D-630 and my desktop a HP with identical results. Both computers are running TD Version 2.5.8 Internet Explorer 7 Windows XP Pro recently updated

Thanks for help - Great program

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5429
    • View Profile
Re: Trouble Summarizing Player Scores
« Reply #1 on: June 01, 2009, 12:28:51 PM »
You've stated that the Tournament Scoring formula is the default formula: (log((n + 1) / r))

This formula will give values like: 6.90875477931522 (for coming in 1st in a 1000 player tournament), or 2.217225244042889 (for coming in 11th in a 100 player tournament).

The values you've listed for each tournament (79, 68, 31, 95, 60, 93, 58) can't be the Scores, because they're too large and are whole numbers (not fractions).

What are the player's Scores for each tournament?  You've given a lot of information, which is *great*, but without the Scores, it's impossible to see what is happening.

On the Stats tab, press the "View" button and select "Single field view", then select "Score" as the column to view.  This should give you each score, for each tournament, for each player.

Unless I'm missing something, of course ... :)