I made this little spreadsheet to help with figuring out what time I would be in certain places on marathon routes but it works for anything now.
To use it:
- Type in the length in miles of the race
- Type in the best guess for how long it’ll take to cross the start line (useful at places like London where it might take ages)
- Type in the predicted finish time
You can then type in up to four points you’ll be spectating at, and it will generate a set of times you should expect your runner. It works on a scale of 95% to 110% of the predicted time, so the ranges will get wider as the race goes on.
Hope it’s useful!