Watt Matters is a blog about training and racing with power and other related musings.

Aside from writing items here on occasions, I also provide cycling performance improvement services via coaching, aerodynamics testing and host a cycling tour.

If you'd like to ask me a question or suggest a topic you'd like my take on, then just head to Ask Alex and let me know!

TdF Speed Trends 1947 - 2017

TdF Speed Trends 1947 - 2017

The 2017 edition of the Tour was a pretty quick tour in terms of average speed, and I suspect the relative lack of mountains played its part in that. Having said that, I can't specifically say whether of not the number of ascent meters was substantially different, it was just an impression from looking at the overall route.

Last year I posted an item with various charts about speed trends for the Tour de France. If you want to know more about the charts, what they mean, the data and where I stole the idea for some of them from (thanks Robert Chung) then have a read of that earlier post - it's not overly long.

So here's an update of the charts to see where 2017 falls.

First the overall speed trend by year:

TdF speed trend chart 2017 (1).jpg

2017 was the second quickest Tour on record.

How about average stage distance?

TdF stage distance trend chart 2017 (1).jpg

Right in line with the overall trend of shorter average stage distances. This may well continue as the ASO experiments with more short punchy stages, plus the ITT distances were less than in most recent tours.

Here's the average speed v overall distance plot with each decade colour coded:

TdF speed v distance 2017 (1).jpg

We can see 2017 is still within the speed v distance cluster of 21st century Tours.

And the residuals plot?

TdF residuals of speed on distance 2017 (1).jpg

Here we see the 2017 edition is right in line with the expected trend.

Now the obvious question about the overall trends relate to two other factors besides overall distance, one being impact of doping during different eras and the other being total ascent meters during the tour as a proportion of total distance.

The doping stuff has been done to death here and elsewhere and there really isn't much in these plots to definitively say much about it anyway. You can look at the peak in residuals in the period of 1990s to 2000s and say

"ah ha! doping!!"

but then you'd also have to explain the other peak in residuals from late 1950s to 1960s. No EPO or blood bags back then. So while doping has played its part, it's not the only or whole story.

About the amount of climbing though, in the last year I made an attempt to work out the number of climbs ascended each Tour. I went through online archive data to count the number of times each col was climbed in the tour for each year. It was pretty laborious research.

I got to something like 750 different mountains in the database and counts for each year, but was unable to complete the project of identifying the data for each (distance, vertical metres, gradient), nor did the archive identify in which direction the mountain was ascended. which matters quite a bit for some climbs.  Add to that the archives were not consistent in which climbs were included in the stage descriptions - and climb categorisation (i.e. HC, Cat 1, 2, 3, 4) has evolved over the years.

It became apparent that unless there is a source available that provides the actual race routes, then attempting to work out the meters ascended for each year was a pretty futile task. I gave it a go though.

Perhaps someone out there has actual race route data going back to 1947? If that's the case then we can map them using current technology to come up with a pretty decent indicator of ascent and descent metres for each edition of the Tour.

Conclusions? Not a lot with respect to 2017 edition. It's pretty much on trend.

Kona power meter usage trends: 2009 to 2017

Kona power meter usage trends: 2009 to 2017

Do I need a power meter?

Do I need a power meter?