Parsing the paste
The pasted text is read as rows, with a header line naming the columns and one track per line below it. Rows that do not parse cleanly - blank lines, stray text, a play count that is not a number - do not enter the sums. The charts are only as precise as the paste, so a quick check of the header and the numbers before analyzing saves confusion.