Charts and Trendlines

I love numbers and charts. Let's play!

My bike rides to date have been 1, 2.5, 2.5, 4.5, 4.5 and 9 miles long. From this I can create a chart in Microsoft Excel.

The next question is whether I am on track for the New York ride, which involves ~60 miles on day one and ~40 on day two. So I add a linear trendline (in pink, see detail, above left) and have the chart extend out to September (full chart, right).

This begs the question: do I have to be doing 60 mile rides consistently if that is the one-time target? What length training rides get me on track to do 60 miles on the day? I know marathon runners don't run 26 mile training runs on a regular basis. So what do I need to build up to and when? 25 mile training rides? 30-40? Now I have more research to do and advice to find (your comments welcome below).

Here is another chart. This is from the Google Map Pedometer site I have mentioned in a previous post. It shows the elevation of my early 2.5 mile short out-and-back route (hence it is symmetrical around the mid-point).

I present this here to illustrate that (a) it does look like a heartbreaker of a hill, and (b) I really do have to go uphill both leaving home and uphill going back home, too.

1 comment:

David Harlow said...

Richard --

The blog looks great, the bike looks great, the gizmos are a bit over the top, but you're forgiven.

If you want to see more than you need to on training for the long ride, check out the PMC training page at:
http://www.pmc.org/training.asp?Topic=Training/TrainingZone

The level of detail and seriousness is almost comical.

I'm starting to blog myself (professionally, so to speak), so that I may replace emails of interest to different groups of clients/contacts with blog (or in my case, blawg) posts/feeds. It's a work in progress: http://www.healthblawg.typepad.com. (Read only in case of insomnia.)

Would you like to join me on the Climb to the Clouds this weekend? http://www.crw.org/CTTC/climb2clouds.htm I expect to be riding the 92-mile route.

See you on the road.