Go Back  Bike Forums > Bike Forums > Road Cycling
Reload this Page >

Do you keep track of your ride stats?

Road Cycling “It is by riding a bicycle that you learn the contours of a country best, since you have to sweat up the hills and coast down them. Thus you remember them as they actually are, while in a motor car only a high hill impresses you, and you have no such accurate remembrance of country you have driven through as you gain by riding a bicycle.” -- Ernest Hemingway

Do you keep track of your ride stats?

Old 06-02-07, 05:52 PM
  #1  
Ahaz
Senior Member
Thread Starter
 
Join Date: Mar 2007
Posts: 60
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Do you keep track of your ride stats?

Do you keep track of your ride stats? Why or why not? How much data to you keep track of, and how to you store/analyze it?

I'm very new to cycling - started around February of this year - and I recently decided to start tracking my ride data. Before, I would just look at my computer readouts for distance and average MPH, and compare that mentally to what I did last time.

I don't have a good reason for writing down all my data in Excel, except that it's fun to try to make some kind of sense out of all my stats.

Here's what I have right now. And yes, I know, I suck pretty bad.








I have
  • Distance
  • Time
  • MPH
  • Hidden column with running average of MPH
  • Percent change based on running average of MPH
  • Cadence
  • Hidden column with running average of cadence
  • Percent change based on running average of cadence

The second average under MPH is a weighted average based on distance. I feel this is more accurate than the straight average. My after work ride is always going to be ~45 minutes to an hour, while my weekend rides should be getting longer than that. This way, my shorter (and hopefully faster) rides will be weighted less than my longer rides, and thus avoid any skewing or inflating in the data.

I think the average delta for MPH is an important number. Not really how big it is, but just trying to keep it positive. Right now I'm trying to think of a way to keep a running weighted average of MPH to use in calculating this delta.

The delta for cadence will probably be useless once I start riding more, but it's interesting to see how my cadence will change from ride to ride.

I don't really know how to do hours in Excel, so all my time values are in minutes (I divide the seconds by 60 after each ride to get the decimal). The total and average for time are in hours.

And I'm also trying to put together a graph that will map my cadence versus my MPH. It's useless right now, but after a some months of riding, I should be able to home into my sweet-spot range. Although, now that I think about it, as my average MPH goes up, this earlier data will become more irrelevant and add some skew to the trend line. Hmm...

So, what do you guys think? Am I making any bad assumptions? Anything else I could or should be keeping track of?
Ahaz is offline  
Old 06-02-07, 06:07 PM
  #2  
group105
Master of the Obvious
 
Join Date: May 2007
Location: Muncie, Indiana
Posts: 456

Bikes: Fuji

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I use mapmyride.com. It has full map with elevation and gps/satelite options.
I track, distance, avg, max, total time and start end time
Attached Images
File Type: jpg
map2.jpg (79.0 KB, 19 views)
File Type: jpg
map3.jpg (76.6 KB, 12 views)
group105 is offline  
Old 06-02-07, 06:17 PM
  #3  
kwrides
Senior Member
 
kwrides's Avatar
 
Join Date: Nov 2006
Location: Houston, TX
Posts: 3,198

Bikes: 2007 Orbea Onix, 2007 Windsor The Hour, 2008 Kona Jake

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
My Garmin does it all for me
kwrides is offline  
Old 06-02-07, 06:18 PM
  #4  
songfta
Cycling Skier
 
songfta's Avatar
 
Join Date: May 2006
Location: Washington, DC
Posts: 619

Bikes: 2008 Pedal Force ZX3, 2006 Jamis Eclipse, 1997 Marin Indian Fire Trail

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I've been using BikeJournal.com for the past few years, and it's been quite good. It allows for great flexibility with regard to data recorded, and the site is quite stable.

MapMyRide also looks good, if you're starting fresh.
songfta is offline  
Old 06-02-07, 06:22 PM
  #5  
mrdatalife
Senior Member
 
Join Date: Jan 2002
Posts: 59

Bikes: Kestrel 200Sci

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
i use a web app i've developed:



mrdatalife is offline  
Old 06-02-07, 08:38 PM
  #6  
Turkey Feathers
nothing to see here
 
Turkey Feathers's Avatar
 
Join Date: Dec 2006
Location: LOST!!! Korea
Posts: 198

Bikes: Kona MTB, Cdale CAAD9 road

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I created a ride log in a spread sheet (open office, like excel), I keep track of:
Date, wind, weather (sunny/cloudy/blah), Temperature, distance, time, ave speed, location (where was the ride), and comments (like how'd I feel at the end, energy level....)
Turkey Feathers is offline  
Old 06-02-07, 08:42 PM
  #7  
sportbiker
Senior Member
 
sportbiker's Avatar
 
Join Date: Aug 2005
Location: Los Angeles
Posts: 243

Bikes: Olmo Gran Fondo and Bianchi Squadra

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by songfta
I've been using BikeJournal.com for the past few years, and it's been quite good. It allows for great flexibility with regard to data recorded, and the site is quite stable.
+1
sportbiker is offline  
Old 06-02-07, 09:02 PM
  #8  
wolfpack 
Rawwrrrrrrrrr!
 
wolfpack's Avatar
 
Join Date: Jan 2006
Location: Clayton, NC
Posts: 2,729

Bikes: 2009 Specialized Ruby Sworks SL w/SRAM Red; 2006 Fuji Team RC; 2008 Felt F1x; 1980's Lotus Excelle; Mangusta FG/SS; Rossin (yet to be built up)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
cyclistats ftw
__________________
wolfpackcycles
skiffrun: Enjoy the ride. Ride for the enjoyment.
wolfpack is offline  
Old 06-02-07, 09:07 PM
  #9  
jsharr
You Know!? For Kids!
 
jsharr's Avatar
 
Join Date: Apr 2005
Location: Just NW of Richardson Bike Mart
Posts: 6,163

Bikes: '05 Trek 1200 / '90 Trek 8000 / '? Falcon Europa

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 27 Post(s)
Liked 0 Times in 0 Posts
Yes, I just write the date, the distance and a brief note, either finished last or got dropped, usually both.
__________________
Are you a registered member? Why not? Click here to register. It's free and only takes 27 seconds! Help out the forums, abide by our community guidelines.
Originally Posted by colorider View Post
Phobias are for irrational fears. Fear of junk ripping badgers is perfectly rational. Those things are nasty.
jsharr is offline  
Old 06-02-07, 09:16 PM
  #10  
cccorlew
Erect member since 1953
 
cccorlew's Avatar
 
Join Date: Dec 2006
Location: Antioch, CA (SF Bay Area)
Posts: 6,949

Bikes: Roubaix Expert, Motobecane Ti Century Elite turned commuter, Cannondale F500 Mtn bike, Some old French thing gone fixie

Mentioned: 7 Post(s)
Tagged: 0 Thread(s)
Quoted: 84 Post(s)
Likes: 0
Liked 2 Times in 2 Posts
I want to, but I just screw it up. Everytime.
cccorlew is offline  
Old 06-02-07, 09:24 PM
  #11  
midschool22
Digging in the pain cave.
 
midschool22's Avatar
 
Join Date: Nov 2006
Posts: 717
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 4 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by songfta
I've been using BikeJournal.com for the past few years, and it's been quite good. It allows for great flexibility with regard to data recorded, and the site is quite stable.
+2
midschool22 is offline  
Old 06-02-07, 09:47 PM
  #12  
FatguyRacer
Mmmmm Donuts!
 
FatguyRacer's Avatar
 
Join Date: Jul 2005
Location: Crownsville, MD
Posts: 2,069

Bikes: 1998 IF Crown Jewel

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by songfta
I've been using BikeJournal.com for the past few years, and it's been quite good. It allows for great flexibility with regard to data recorded, and the site is quite stable.
+1 for Bike Journal. I joined in 2005. I often refer back to years past for info about rides i had done before.

I also download my Polar S720 data via infrared link to my computer.

Prior to the WWW thing, i used to log all my stuff in those sprial bound Velonews ride logs. I have quite a few of those on my bookshelf.

Thank goodness for the WWW.
__________________
John

'09 Cannondale CAAD9 - Team Latitude/ABRT Special.
'04 Lemond Victorie Ti
'98 IF Crown Jewel (dead)
'92 Trek2100 (TT)
'50 something Gino Bartali (fixer)
'02 Ducati ST4s (Moto-Ref mount)

My Blog
FatguyRacer is offline  
Old 06-02-07, 09:57 PM
  #13  
do-well
Senior Member
 
Join Date: Aug 2006
Posts: 311
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
On a daily basis, I record student grades and attendance. I also record conference dates, publication deadlines, meeting times, to-do lists, assignments and all other kinds of so-called "important" information. I ride my bike to get away from the details of everyday life, so there's no recording ride data in my world.

Now, it's important to note that I'm an English graduate student, so maybe I just suffer from Arithmophobia.

On a serious note, I ride to ride (and I don't race). I often ride without my cyclometer, but can easily tell the good days from the bad ones, in terms of ride statistics.
do-well is offline  
Old 06-02-07, 10:19 PM
  #14  
SteveE
Veni, Vidi, Vomiti
 
SteveE's Avatar
 
Join Date: Jun 2002
Location: Republic of Anaerobia
Posts: 3,582

Bikes: Serotta Legend Ti, Romani Columbus SL, Soma Doublecross

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Nope. I measure my fitness by how long I can hang with the club A-Ride and whether I make it to the re-group at the top of the major climbs before they've given up and left me for dead.
SteveE is offline  
Old 06-02-07, 10:35 PM
  #15  
phoenity
Senior Member
 
Join Date: Apr 2007
Posts: 180
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by do-well
I ride my bike to get away from the details of everyday life, so there's no recording ride data in my world.
+1
phoenity is offline  
Old 06-02-07, 10:57 PM
  #16  
Groundhawg
Senior Member
 
Groundhawg's Avatar
 
Join Date: Jul 2004
Posts: 90
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I keep a log of every ride I do. I think I may have missed writng down a couple since 2004.
I keep all the logs in a notebook.

Here's the info I write down for each ride:

* Date
* Trip miles ( Mileage for this trip only)
* Average Speed
* Maximum Speed
* Time
* Total Miles ( This is the total miles the bike has on it)
* Days skipped riding.....If Any.
* Comments Section I put the route I rode in this section. Also the type of ride...Recreational, Fast etc...
Groundhawg is offline  
Old 06-02-07, 11:11 PM
  #17  
jmechy
Senior Member
 
jmechy's Avatar
 
Join Date: Mar 2007
Location: UCSB
Posts: 666

Bikes: 2006 Felt F3C

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by wolfpack
cyclistats ftw
+1

I also use an excel chart so I can totally customize graphs. Entering data twice is a pain, but worth it in the end.
jmechy is offline  
Old 06-02-07, 11:22 PM
  #18  
drmarthacastro
Cycling Fanatic
 
drmarthacastro's Avatar
 
Join Date: Apr 2007
Location: Austria
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I use an old fashion pen and paper.

I record:

Date
Kilometers
Total Time
Distance
Average speed

And general comments like: "Ouch, I fell pretty bad today hurting my right rotator shoulder cuff"
drmarthacastro is offline  
Old 06-02-07, 11:35 PM
  #19  
ollo_ollo
Senior Member
 
ollo_ollo's Avatar
 
Join Date: Nov 2003
Location: Near Sublimity Orygun
Posts: 4,781

Bikes: Still have a few left!

Mentioned: 33 Post(s)
Tagged: 0 Thread(s)
Quoted: 305 Post(s)
Liked 1 Time in 1 Post
I was a daily commuter before I retired and logged my miles monthly by hand to qualify for the $2 per day stipend the State gives employees who use an alternative to a single occupant automobile.

I started logging my miles on bike journal.com January 1 of 2005 and it is much more convenient than keeping a handwritten mileage log & its free for the basic logging features. There is a Bike Forums team you can join & then your miles get added to the team total to compete with other teams that have been formed. Don
ollo_ollo is offline  
Old 06-02-07, 11:51 PM
  #20  
Stallionforce
Senior Member
 
Stallionforce's Avatar
 
Join Date: Apr 2005
Location: Victoria
Posts: 1,372

Bikes: 05 Norco CRR Team Carbon Dura Ace, 06 Cervelo P2C TT Dura Ace, 88 Olmo Steelie w. Campy Mirage, Cypress CX w. 105

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I used to keep track of distance and time.

Now I try to keep a running tally (in my head, I don't write it down) of how much time per week I spend at threshold. I like to try to do 3 to 4 hours at threshold. 5 hours is a great week.

I think power metering is the only way to go for me from now on. I can really keep better track of what my body is doing, and how it is coping with stress.
Stallionforce is offline  
Old 06-03-07, 12:24 AM
  #21  
drmarthacastro
Cycling Fanatic
 
drmarthacastro's Avatar
 
Join Date: Apr 2007
Location: Austria
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by Stallionforce
I used to keep track of distance and time.

Now I try to keep a running tally (in my head, I don't write it down) of how much time per week I spend at threshold. I like to try to do 3 to 4 hours at threshold. 5 hours is a great week.

I think power metering is the only way to go for me from now on. I can really keep better track of what my body is doing, and how it is coping with stress.
Wow, I never thought to do it that way, thank you for your input, it sounds like a great idea to follow.
drmarthacastro is offline  
Old 06-03-07, 01:03 AM
  #22  
Viceroy
Senior Member
 
Join Date: Sep 2006
Posts: 127
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by drmarthacastro
I use an old fashion pen and paper.

I record:

Date
Kilometers
Total Time
Distance
Average speed

And general comments like: "Ouch, I fell pretty bad today hurting my right rotator shoulder cuff"
Very similar to me. There's something gratifying about sitting down with a pen and recording everything that way rather than just typing it on a spreadsheet. I'm young, but old-fashioned.
I track the ride I did (I've given all my common routes names), date, time, distance, maximum speed, and average speed. There's also a column called "Notes", which most of the time denotes if it was particularly windy or something happened out of the ordinary. Ie. "Strong northern wind" or something like that.
I also used to put in cadence, but my cadence tracker is off my bike and I haven't put it back on yet.
Viceroy is offline  
Old 06-03-07, 01:17 AM
  #23  
ekimeno
Good day to ride
 
ekimeno's Avatar
 
Join Date: Jul 2006
Location: London, UK
Posts: 564

Bikes: Look KG451, half Record, half Chorus

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I also use Bikejournal.com - great place to see how you tally up against other several thousand riders around the world, plus there is a very active forum. Bikeforums has a 'club' based there - a couple hundred BF members who use this site - looks like no one on BF will catch the mighty NomadVW with 9730km logged this year already - almost twice as much as I've done

I also use Motionbased to log all my Garmin GPS data - this one's a no-brainer - it does everything for you. Here's an example of the data it records.
ekimeno is offline  
Old 06-03-07, 01:19 AM
  #24  
cyclezealot
Senior Member
 
cyclezealot's Avatar
 
Join Date: Sep 2001
Location: Fallbrook,Calif./Palau del Vidre, France
Posts: 13,192

Bikes: Klein QP, Fuji touring, Surly Cross Check, BCH City bike

Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 1259 Post(s)
Liked 0 Times in 0 Posts
used to. It was a badge of courage to know I did ever more miles as each year passed. Now I know I do more than 7000 miles a year. Year in year out. So seems like a lot of effort. Have a new calendar on the wall with large boxes for writing comments. Maybe I will start up again.
cyclezealot is offline  
Old 06-03-07, 02:41 AM
  #25  
John Wilke
Senior Member
 
John Wilke's Avatar
 
Join Date: Sep 2005
Location: Milwaukee
Posts: 3,917
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Originally Posted by drmarthacastro
I use an old fashion pen and paper.

I record:

Date
Kilometers
Total Time
Distance
Average speed

And general comments like: "Ouch, I fell pretty bad today hurting my right rotator shoulder cuff"
I do the same thing in a hard cover accounting book. I've got every bike, ski, hike, or rollerblade noted since 1998 !
John Wilke is offline  

Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.