Anyone who has looked at the recently reappeared Stockport (home) attendance thread will know that @wwfcblue queried a discrepancy after I published some of the underlying data for the top seven in the current Tour de Season competition.
I have spent some time looking and I am confident that there was a mistake made back then and that I know exactly what it was.
It is a small slip but does some implications.
What Happened:
For the Stockport game and only for the Stockport game when I transferred the data from the Match Day Spreadsheet to the Tour de Season spreadsheet the whole column was misaligned by one cell so that forecasters were credited with the score of the person above them in the table.
So in fact I myself benefitted from a score which should have belonged to @PJS, poor @robin received the score that should have belonged to me and so on.
The mistake that I feel worst about is that @FromeBlue was credited with a score of 57 which should have belonged to @Monza = if I had been sharper I would have spotted this because @FromeBlue didn’t predict until the 4th match.
@wwfcblue spotted that he had @williwycombe’s score of 90 and deserves loads of credit for both spotting it and then saying as it is to his disadvantage in the overall competition.
The affected scores for the Stockport game are highghted in pale red. Anyone who predicted the first game of the season and whose handle is earlier in the alphabet has an unaffected score.
Below is how the spreadsheet looks when it has been corrected…..
An Apology and Could it Happen Again?
I have had a look and it does make some siglogilognificant changes to the Leaderboard. I apologise to everybody because it was my mistake. I want to say sorry to people who have lost places on the Leaderboard as a consequence, particularly to @FromeBlue, @Ryan_W_Kirkby, @SmiroludyBlue and @silverfox who have lost ‘score’ and I believe places on the Leaderboard. If ahyohe wants an explanation of what happened to their particular score I am happy to do that.
There are few absolute guaratnees in this life but I am pretty sure that it can’t happen again. I have been checking the unique number identifies for most of the season whenever I transfer data between spreadsneets and the first four weeks were added and published at one go, when they are added a match at a time it is much more transparent and I am confident the error would be spotted..
What it means:
The revised Leaderboard below to which I will add the Doncaster outcomes -
Scores highlighted in green are those that can have altered and the usual up and down arrows apply.
I am slightly relieved that most of the big changes have happened in tight areas of the Leaderbord so it is possible to recover very quickly.
I’m not buying everyone a beer!