Computing Caps Average from archive cut & paste into Excel
Sort:
Most Recent
Forum Legend
Following
New Comments
Locked Topic
Pinned Topic
Until Chess.com offers some sort of CAPS average it is possible to cut and paste game entries from the archive into Excel and with a few formulas compute one's CAPS average. Below is a screen shot showing the top rows and bottom rows of the spreadsheet with the formulas displayed.
This example uses my user name jas0501 and my user name length 6 in column H. Also used is the range of game lines, H2:H101. Row 2's formula
=if(LEFT(B2,6)="jas0501",D2)
Copy the formula to cells H2:H101
The total line, row 102,
Column H - counts the > 0 values in column H, =countif(H2:H101,">0")
Column I - sums the values > 0, =sumif(H2:H101,">0")
Column J - computes the average =I102/H102