World TT Championships - Fun with Charts!

The World's TT is unusual in that it's usually done in laps, and thus has a lot of intermediate splits.  This, naturally, inspires me to play around with spreadsheets.

So here are two charts I created



This is (hopefully) fairly straightforward.  It's the average speed of each of the two laps of the riders who finished in the top 10. 

You can see that everyone except Wiggins went faster in the first lap than the second.  Cancellara started fast and slowed in the second lap, as did Bobridge




This is maybe a little less clear, but allows us to tell something of a story of the race for the top 5 finishers. 

This chart is showing the speed compared to Tony Martin, who wasn't going at a constant speed himself - as we saw in the previous chart he slowed in the second lap.

The six coloured bars show the riders average speed compared to Martin in the sections of the course, the next two bars show the speed compared to Martin for the two laps, and the final shows the average speed for the whole Time Trial

The first thing to note is that Martin didn't just lead for the whole race, he was the fastest in every section.

Looking at Bradley Wiggins, we can see he started out considerably slower, but by the final section was almost going as fast as Martin.

Fabian Cancellara started extremely strongly, and raised his game for the second section, perhaps trying to match the incredible pace of Martin.  But in the second lap he pays for this effort and falls behind the strong finishing Wiggins.

Bert Grabsch seems to have paced himself remarkably similarly to his victorious compatriot and HTC team mate.  Unfortunately he was going more than a km/h slower.

Jack Bobridge started extremely strongly, going at medal winning pace for the first section.  He pays for this, going more than 2km/h slower in the second lap, but the youngster still manages an impressive 5th.

Log In Sign Up

Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Podium Cafe

You must be a member of Podium Cafe to participate.

We have our own Community Guidelines at Podium Cafe. You should read them.

Join Podium Cafe

You must be a member of Podium Cafe to participate.

We have our own Community Guidelines at Podium Cafe. You should read them.




Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.