[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

BGonline.org Forums

suggests for new XG

Posted By: eXtreme Gammon
Date: Friday, 17 January 2014, at 4:46 p.m.

In Response To: suggests for new XG (Dmitriy Obukhov)

Thanks,

for now what you can do is export from your profile using "results>>Copy to clipboard>>Game List"

  • Paste it in excel.
  • to see PR, add a column with the formula "=-AM2*500"
  • insert a Pivot table (INSERT tab) to a new worksheet
  • drag "score" to the row, "opp score" to the column, PR to the Value
  • right click to the PR and pick average and change the number format to 1 decimal

    Some Color conditional formatting will help with the display

    note that this is giving the average PR on your game. A better way will be to add column for total errors and use a calculated filed in the Pivot PR='total error'/'decisions'*500 For instance (I filtered out scores above 9 as I've do not play many long match): PR above 11 are surely from test games ;-)

    Average of PR Column Labels
    Row Labels 1 2 3 4 5 6 7 8 9 Grand Total
    1 5.5 3.8 3.8 4.1 4.0 3.6 4.1 4.4 4.8 4.8
    2 3.8 3.9 7.2 6.0 7.5 9.0 9.1 6.5 5.7
    3 3.9 6.0 6.0 6.4 6.7 5.9 5.8 5.4 3.0 5.6
    4 4.0 5.4 8.0 8.0 6.7 8.1 5.0 4.4 4.5 6.3
    5 4.0 5.0 5.6 6.8 5.5 6.7 5.7 12.6 4.0 5.5
    6 3.4 5.2 5.5 6.1 8.7 8.2 6.0 11.1 5.8 6.4
    7 5.7 8.3 7.3 6.3 6.5 5.2 6.0 3.8 7.7 6.3
    8 3.0 8.2 5.2 11.0 6.8 7.1 8.4 6.5 5.9 6.7
    9 3.2 9.3 7.0 8.9 5.5 6.2 4.4 5.5 7.7 6.2
    Grand Total 4.7 5.0 5.9 6.3 5.9 6.3 5.9 6.1 6.0 5.5

    • Messages In This Thread

     

    Post Response
    Your Name:
    Your E-Mail Address:
    Subject:
    Message:

    If necessary, enter your password below:

    Password:
     

     

    [ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

    BGonline.org Forums is maintained by Stick with WebBBS 5.12.