Friday, June 10, 2011

Interesting Cycling Stat

Okay, more like Boring Cycling Stat

I record all my rides in an Excel spreadsheet, which automatically generates a number of "reports".  E.g., number rides, miles, time, avg pace, avg distance per ride by month; same stats by "category" (categories include Irregular rides, brevets, permanents, and some others); same stats by day-of-the-week.  The spreadsheet also produces a list of my 20 longest rides of the year and separately 20 fastest rides of the year.  There are also some other auto-generated "reports".  All times entered in the spreadsheet are "time-in-motion", therefore the avg pace info is "avg-pace-while-in-motion". 

I just happened to notice a couple interesting things about my 20-fastest-rides so far this year:
I figure one or both of those might drop off the "fast 20" list by the time the weekend is completed, so I thought I'd record the factoid for ... posterity? ... the heck of it? ... because I'm a numbers geek? ...

---------------------------------------------------------------------------------------------


Fast rides:    miles   frac hrs  avg mph
max May 7 104.0 6.5 16.1
_2 Apr 2 125.3 7.8 16.1
_3 May 28 81.9 5.1 16.0
_4 May 21 66.0 4.2 15.9
_5 May 27 14.1 0.9 15.8
_6 Mar 29 127.0 8.1 15.7
_7 Mar 26 55.7 3.5 15.7
_8 May 20 13.9 0.9 15.7
_9 Apr 23 64.3 4.1 15.7
10 Mar 20 73.7 4.7 15.7
11 Mar 25 78.0 5.0 15.6
12 Jan 8 36.2 2.3 15.6
13 Apr 8 103.3 6.6 15.6
14 Feb 27 38.9 2.5 15.5
15 Mar 5 66.9 4.3 15.4
16 Mar 19 79.0 5.2 15.3
17 Feb 12 73.0 4.8 15.2
18 Feb 19 78.6 5.2 15.1
19 Jan 1 125.1 8.3 15.1
20 Apr 17 189.2 12.5 15.1
 _1 - 10 725.9 45.7 15.9 72.6
 11 - 20 868.2 56.8 15.3 86.8
total 1,594.1 102.5 15.6 79.7
other rides:
23 2,097.7 146.5 14.3 91.2

No comments:

Post a Comment