@ TJ,
Just spent some time going through the spreadsheet, WOW! Nice work and the effort is really appreciated. Makes my own planning efforts look like not planning at all!
A couple of questions, just explanatory stuff about the spreadsheet to help me get my head around it and to get a feel for what I might need to aim at for the day.
1. Is the yellow column the "ideal" for the ride participants, or what we should be looking at having a crack at during the ride?
2. Default moving speed (F3), is that your target Moving Average (MA) in the absence of stops?
3. The speeds used for the calcs real (GPS) speeds not odometer speeds the latter of which will make most of us late. Is that correct?
4. Your column "Average Speed" is that the Overall Average that results from the Default Moving Speed (MA) taking into account the 4 x 20 minute stops? So in X49 we have 94.7 OA that sees us finish at 20:43.? Extending that your "Slow (95kph), Fast (103kph) and Min (73.
" are OA's not MA's?
Comment: I really like that you've included "leave" times to account for the fuel/breaks. So in areas where it's very likely the MA will exceed the 100kph people can focus on what time they might need to leave on their ride plan to stay on track, not what time they arrive. And also in areas where time was banked with MA that time could be used to take a quick walk around the bike with full knowledge of the impact on their ride progression.
Once again, awesome work and thanks. A good safe route with lots of options.