justcycling.myfastforum.org Forum Index justcycling.myfastforum.org
Just Cycling
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   Join! (free) Join! (free)  
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Sticky Articles
2010 Season
Smarauder Memorial Trophy 2010 - New Poll
Comments and problems thread
Cycling on TV & Internet
Fantasy Cycling
JustCycling's New Net Biking Biblioteca
Popular Topics
2009 Season-The News and our Views
Tour of California 2009
Edit: Armstrong crash puts Giro in doubt
Transfers 2009
Paris - Nice 2009
Astana
Contador admits Difficulties in Astana
Tipster League (Smarauder Memorial Trophy) 2009
Cycling Manager Game
What will your reaction be when Lance takes the jersey tmrow
Top posters
CapeRoadie 9647
Bartali 8028
HuwB 7634
kathy 7493
Mrs John Murphy 5575
Sooty 4879
cardinal guzman 4315
crash48 4283
smarauder68 4197
bianchigirl 4189
Ralphnorman 4038
sheeponabike 3705
last km 3508
naspa 3506
cyclingtv 3476
bbnaz 3287
kellyrocheearly 2969
Slapshot 3 2901
Jackov 2763
shimouma 2725
Nolte 2589
70kmph 2287
headwind 2265
SlowRower 1982
mr shifter 1954
TdF average speed
Page 1, 2, 3  Next
 
Post new topic   Reply to topic    justcycling.myfastforum.org Forum Index -> The 3 GTīs
View previous topic :: View next topic  
Author Message
Please Register and Login to this forum to stop seeing this advertsing.






Posted:     Post subject:

Back to top
Jackov



Joined: 27 Dec 2006
Posts: 2763


Location: The Burbs of Merlin

PostPosted: Wed Jul 15, 2009 11:21 am    Post subject: TdF average speed Reply with quote

Back to top
View user's profile Send private message
SlowRower



Joined: 22 Nov 2006
Posts: 1982


Location: Leeds - Centre of the Universe

PostPosted: Wed Jul 15, 2009 11:26 am    Post subject: Reply with quote

Something for everyone there, I suspect!
_________________
EPO is for wimps. Proper cyclists go faster on beer, curry and porridge.
Back to top
View user's profile Send private message
Fontfroide



Joined: 07 Apr 2008
Posts: 1327



PostPosted: Wed Jul 15, 2009 7:17 pm    Post subject: Reply with quote

Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.
Back to top
View user's profile Send private message
Bartali



Joined: 06 Oct 2006
Posts: 8028


Location: Hertfordshire

PostPosted: Wed Jul 15, 2009 8:59 pm    Post subject: Reply with quote

Need parcours info etc to be meaningful, but a general trend of increased km/h - 6km/h in 30 years.  Quite significant.  Bikes weigh less and roads are a bit better.  I'd like to see the graph go back to the 1940s
Back to top
View user's profile Send private message
Nolte



Joined: 15 Oct 2006
Posts: 2589


Location: irlande

PostPosted: Wed Jul 15, 2009 9:25 pm    Post subject: Reply with quote

Fontfroide wrote:
Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.


it would be Smile
_________________
Hi
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Boogerd_Fan



Joined: 07 Oct 2006
Posts: 1575


Location: Bratislava, Slovakia

PostPosted: Wed Jul 15, 2009 9:52 pm    Post subject: Reply with quote

riders are specialist professionals now too, instead of chimney sweeps...

but then if the graph did go back to 1900, surely the progress would be in the first half-century, rather than over last 10 years. That 6kmph faster trend is certainly curious...

what is different about today's peleton than 80s?
Can't just be about the hog in the earpiece can it?
_________________
03-11-2007 = the end
Back to top
View user's profile Send private message
Jackov



Joined: 27 Dec 2006
Posts: 2763


Location: The Burbs of Merlin

PostPosted: Wed Jul 15, 2009 11:06 pm    Post subject: Reply with quote

Fontfroide wrote:
Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.


It would...if I could do more than one scale on the y-axis.
Back to top
View user's profile Send private message
Nolte



Joined: 15 Oct 2006
Posts: 2589


Location: irlande

PostPosted: Wed Jul 15, 2009 11:06 pm    Post subject: Reply with quote

what about between 1980 and 1981?  was there anything extraordinary. it was in the pre-me era so i'm not sure

is it the average winners speed as i though 2005, 2004 and 2003 where the 3 fastest years or so
_________________
Hi
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Jackov



Joined: 27 Dec 2006
Posts: 2763


Location: The Burbs of Merlin

PostPosted: Wed Jul 15, 2009 11:17 pm    Post subject: Reply with quote

Here's back to 1947
Back to top
View user's profile Send private message
Biosphere



Joined: 08 Oct 2006
Posts: 1890


Location: Midlands, UK

PostPosted: Wed Jul 15, 2009 11:25 pm    Post subject: Reply with quote

Jackov wrote:
Fontfroide wrote:
Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.


It would...if I could do more than one scale on the y-axis.


Secondary y axis should be straightforward

http://www.mrexcel.com/archive/Formatting/27980.html
Back to top
View user's profile Send private message
Jackov



Joined: 27 Dec 2006
Posts: 2763


Location: The Burbs of Merlin

PostPosted: Wed Jul 15, 2009 11:31 pm    Post subject: Reply with quote

Biosphere wrote:
Jackov wrote:
Fontfroide wrote:
Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.


It would...if I could do more than one scale on the y-axis.


Secondary y axis should be straightforward

http://www.mrexcel.com/archive/Formatting/27980.html


my graph is google graph, the peoples graph! not  running dog imperialist excel graph
Back to top
View user's profile Send private message
Biosphere



Joined: 08 Oct 2006
Posts: 1890


Location: Midlands, UK

PostPosted: Wed Jul 15, 2009 11:42 pm    Post subject: Reply with quote

Jackov wrote:
Biosphere wrote:
Jackov wrote:
Fontfroide wrote:
Would it be at all interesting to put into that graph the fastest time of the year for the 100 metres on land and in the pool?  Just to see.


It would...if I could do more than one scale on the y-axis.


Secondary y axis should be straightforward

http://www.mrexcel.com/archive/Formatting/27980.html


my graph is google graph, the peoples graph! not  running dog imperialist excel graph


Let us know when you get upgraded to some real functionality  Wink
Back to top
View user's profile Send private message
headwind



Joined: 12 Oct 2006
Posts: 2265


Location: Mountains of East Tennessee

PostPosted: Thu Jul 16, 2009 12:19 am    Post subject: Reply with quote

Hi All,  Every year I trot out this garbage, so might as well this tour as well.  I was fascinated with all this too a while back and dug out all kinds of shite from the recordbooks.  Heres a few figs.

This one clearly shows the inverse relationship between tour speed and distance over time. Whether this intersection point in the late 80s is meaningful Im not sure...but I bet Lemond would say it is!

...the idea its just getting faster is largely crap:

Back to top
View user's profile Send private message
headwind



Joined: 12 Oct 2006
Posts: 2265


Location: Mountains of East Tennessee

PostPosted: Thu Jul 16, 2009 12:29 am    Post subject: Reply with quote

This plot shows the average speed for three races...P-R (black), LBL (blue), TdF (red).  I have applied a smoothing function to the data sets to even out the variation and give an overall impression.

I think its quite interesting.  I see the following:  PR and LBL have been very constant in parcours over a long time, and in the early 60s, we see a dramatic leveling off of speeds, whereas the tour is not levelling off at the same rate.  It tells me that the continued monkeying of the Tour, essentially making it easier, by making it SHORTER (overall, and each stage), has kept the speeds up. It also shows the advances intraining, bikes, and doping have not had a quantum effect on speed, suggesting we are at the capacity for human achievement.

The fastest PR ever was 1964!

Back to top
View user's profile Send private message
headwind



Joined: 12 Oct 2006
Posts: 2265


Location: Mountains of East Tennessee

PostPosted: Thu Jul 16, 2009 12:32 am    Post subject: Reply with quote

On top of tour distance getting shorter, stage distance is getting shorter, permitting faster speeds.

.



Last edited by headwind on Thu Jul 16, 2009 1:10 am; edited 2 times in total
Back to top
View user's profile Send private message
headwind



Joined: 12 Oct 2006
Posts: 2265


Location: Mountains of East Tennessee

PostPosted: Thu Jul 16, 2009 12:34 am    Post subject: Reply with quote

plot showing actual data and "smoothed" data for PR



Last edited by headwind on Thu Jul 16, 2009 2:29 am; edited 1 time in total
Back to top
View user's profile Send private message
headwind



Joined: 12 Oct 2006
Posts: 2265


Location: Mountains of East Tennessee

PostPosted: Thu Jul 16, 2009 1:02 am    Post subject: Reply with quote

I thought Id also add my 2 cents.

Clearly the years between wars were teh most phenomenal in cementing the rigor f the major races. that 3 races show the same thing says the old days were pretty incredible...and why records were falling all the time. It might also be linked to the seriousness of the endeavor and certainly in bike construction.  All these do point to huge advances in cycling, just not in our time.  It strikes me the immediate post WWII years were really an apex in cycling. that bikes weigh about half now, with 2x the number of gears basically says those guys were monster hard asses on the road.  Add road surfaces changes ago, and its clear we stand on the shoulders of giants today. Really doping and bikes and training etc have inched up the speeds from the 50s, but not hugely when looked at through the perspective of a lens where great races have been largely constant over time (PR, LBL). The Tour has been such a moving target that focusing on speed give a very partial picture, and one where we might easily be convinced that cyclers are getting materially much better...but I dont think thats the case!!!

your serve gang

hw
Back to top
View user's profile Send private message
SlowRower



Joined: 22 Nov 2006
Posts: 1982


Location: Leeds - Centre of the Universe

PostPosted: Thu Jul 16, 2009 7:40 am    Post subject: Reply with quote

Thanks for the analysis, HW. Definitely something to think about!

Here's a thought for you - does making the TDF stages shorter necessarily make it easier? Riding to your limit over (for example) 250km is probably not that much different to riding to your limit over 180km, as you do the latter faster, so that in both cases, the tank is empty at the end of the effort.

Admittedly, I've never ridden anything like 180km in one go, so the above is guesswork, but I've done a lot of running and rowing over various distances and short endurance events are every bit as hard as long endurance events. (Harder in one context, actually, as your cruising pace is closer to your absolute maximum pace in the shorter distances, and "peak pain" is higher! As an athlete, I suppose which you consider harder depends on whether you like lots of pain for a short time, or lower levels of pain for sustained periods. I always found the most preferable option was the one that I wasn't currently undertaking. Smile)
_________________
EPO is for wimps. Proper cyclists go faster on beer, curry and porridge.
Back to top
View user's profile Send private message
Jackov



Joined: 27 Dec 2006
Posts: 2763


Location: The Burbs of Merlin

PostPosted: Thu Jul 16, 2009 11:30 am    Post subject: Reply with quote

Headwind siezes the torch of scholarship!  Excellent.

I believe a huge part of it is greater participation: the pool of athletes has grown, and athletes have more exposure to different sports to discover their specialty.
Back to top
View user's profile Send private message
Bartali



Joined: 06 Oct 2006
Posts: 8028


Location: Hertfordshire

PostPosted: Thu Jul 16, 2009 12:27 pm    Post subject: Reply with quote

I can't see HW's graphs on this computer, but looking at Jack's last graph there seems to be a steady trend up till about 1960 and then another steady rise starting about 1970.  Something odd in the 1960s.  Ideas?  Apologies if its clear from HW's data.


Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    justcycling.myfastforum.org Forum Index -> The 3 GTīs All times are GMT
Page 1, 2, 3  Next
Page 1 of 3

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Card File  Gallery  Forum Archive
Powered by phpBB © 2001, 2005 phpBB Group
Create your own free forum | Buy a domain to use with your forum