The Scot wrote:iGotSpreadsheetzYo wrote:Yes I put a red font on the most obviously overlapping ones which were on 16.5 image 7. I did wonder if that was a watch swap or something though? and temporarily having both devices on.The Scot wrote:I also did this:
This is the spreadsheet I just typed up off the Robert Young photo album of TomTom screenshots of which there are 70. Some of those are duplicates. The timestamps of a few are hard to read so may be blank or slightly mistyped.
It seems yours includes more maybe. I didn't transcribe it if I was unsure what it said due to blurriness.
Two things jump out:
1) Lots of overlap, 2 activities will be happening at the same time...
2) There are several times where the timestamp of the activity was unknown due to the photograph of the TomTom log being scrolled just such so that the numbers can be seen, but the time is off the bottom of the screen.
The known mileages for the "accidentally" missing timestamps are: 31.98, 30.17, 25.6, 25.36, 21.97, 20.65, 16, 1.1, 0.07. That is 8 of the 18 runs over 16. Perhaps he doesn't want to draw attention to these, afraid we will cross reference sometime damning with the time of these runs?
Cool good job. Row 28 on yours - start time is wrong, that one is a duplicate of the above May 15 9.17mi. Other duplicates for May 15. I'm too tired to keep double checking now... I also found a couple mistakes on mine from looking at yours which I fixed. Surely with some crowdsourcing we can get the data airtight which may help in the future but I'll come back to this later. Thanks!