Sample of my PBP planning spreadsheet

In order to be more organised and hopefully more successful in my upcoming PBP attempt, I’ve created a planning spreadsheet giving me a better idea of where I should be, when.

I found this approach helpful when I did Mille Cymru in 2018 and I mostly stuck to my plan. To make that easier I scribbled my expected average speed and ETAs on the route sheet. When I started to drift from the plan, I knew what I had to do to regain time – in my case that meant having less sleep. For PBP I won’t have a route sheet, but will probably still keep these targets to hand, maybe taped onto the bike somewhere.

For anyone who’d like to do the same, I’m sharing the link here

How to use the spreadsheet for PBP2019 (90hr group*)

  • Start by making your own private copy of the spreadsheet either in Google Docs or locally, so that you can edit it as you like.
  • There are two plans to compare, blue and orange. I use them for my optimistic “fast” plan and the “slow” plan.
  • You should only need to edit the coloured cells, starting with your start time and date in C2 and L2.
  • Go down the coloured columns for each plan and fill in your expected average speed for each section and how long you intend to rest at the next control. It doesn’t matter whether you include your en-route rests in the resting time or average speed as long as you are consistent and measure it correctly on the road. If your GPS shows only “Moving average”, be sure to include extra “resting” time for adjusting clothes, calls of nature, etc. Whereas, if you use “Overall average” when riding, any small stops will naturally reduce your average speed. When deciding how fast you think you can go, it’s worth looking at each section of the route to assess the climb/descending, time of day, fatigue, likely conditions, etc. As the sections are not circular, some involve a lot more climbing than descending, so expect them to be slower than average.
Line-area graph with two rising and falling plots with control towns on the X-axis
Time-in-hand graph produced automatically by the spreadsheet

How to use the spreadsheet for other events

To use the spreadsheet for other events you’ll need to make another copy and edit the control names and distances in columns A and B.

Apart from that the instructions above should still work.

* I’ve worked out the minimum average speed that makes the finish time work for the 90hr starts and put it in B19 – if you’re in the 84hr or 80hr starts, you’ll need to increase that number accordingly and make sure the finish time in C17 is correct.

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.