@hippy my spreadsheet at https://goo.gl/RBHtiS has both paces on it, 'Comparisions Days against idealised record rider' for the highest average mileage over the whole year (currently still Tommy), and 'Comparisions Days against best record rider' for a comparison against whoever currently has the highest average miles per day (currently Kurt). Both are dynamic, and will shift each time the rest of the figures are updated if they need to.
Steve on his second go needs to add 25.1 miles above the record pace to be beating the first, and 106.2 above the higher pace to match the second.
On his first, he's needing virtually 350 miles per day to beat Tommy. The trap is that every day you ride under the required distance, that distance creeps up a little to start with, and then starts to head up quite sharply after a bit. This can be seen on the 'Daily targets to beat current record' sheet.
Anyone wanting further explanations of bits on the sheets, or different data manipulation that I've not done, give me a poke, and I'll see what can be done.
@hippy my spreadsheet at https://goo.gl/RBHtiS has both paces on it, 'Comparisions Days against idealised record rider' for the highest average mileage over the whole year (currently still Tommy), and 'Comparisions Days against best record rider' for a comparison against whoever currently has the highest average miles per day (currently Kurt). Both are dynamic, and will shift each time the rest of the figures are updated if they need to.
Steve on his second go needs to add 25.1 miles above the record pace to be beating the first, and 106.2 above the higher pace to match the second.
On his first, he's needing virtually 350 miles per day to beat Tommy. The trap is that every day you ride under the required distance, that distance creeps up a little to start with, and then starts to head up quite sharply after a bit. This can be seen on the 'Daily targets to beat current record' sheet.
Anyone wanting further explanations of bits on the sheets, or different data manipulation that I've not done, give me a poke, and I'll see what can be done.