Go Back  Bike Forums > Bike Forums > Commuting
Reload this Page >

Who keeps track of their over year distances?

Commuting Bicycle commuting is easier than you think, before you know it, you'll be hooked. Learn the tips, hints, equipment, safety requirements for safely riding your bike to work.

Who keeps track of their over year distances?

Reply

Old 06-03-08, 12:10 AM
  #1  
FreddyV
Senior Member
Thread Starter
 
Join Date: Jun 2008
Location: 5257'N 621'E
Posts: 1,977

Bikes: Giant OCR

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Who keeps track of their over year distances?

Hey guys, was just wondering. Does anyone keep track of their over day/week/month/year distances? I thought it would be interesting to see how I developed my commuting (just started yesterday), so I built me a quick whip up in MS Excel to see what the outcomes are. Am I the only one doing this, or are there more of you out there doing the same?
FreddyV is offline  
Reply With Quote
Old 06-03-08, 12:38 AM
  #2  
prawza
Senior Member
 
prawza's Avatar
 
Join Date: Apr 2008
Location: Perth, Australia
Posts: 298

Bikes: Avanti ventura, Fuga Track Bike

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Yeah I have an odometer ticking away on my bike and i keep weekly distances just for curiosity at the end of the week, where i then calculate how many miles i've done each day on average. usually ~18km per day.

most people have a general idea of how far they commute,
so far ive done about 1300km since march this year.

I thought it would be interesting to see how I developed my commuting
Don't really get this, develop your commuting in what way?
prawza is offline  
Reply With Quote
Old 06-03-08, 12:40 AM
  #3  
krauos
Junior Member
 
Join Date: May 2008
Location: Dearborn, MI
Posts: 20
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
yea i have a planet bike 9.0 wireless and an excel spreadsheed going

not to complicated, just weekly miles, total odometer and gas savings!!! $$$$$

my engineer at work is a racer, and he has a data recording torque meter rear hub and analyzed everything its insane.
krauos is offline  
Reply With Quote
Old 06-03-08, 12:52 AM
  #4  
FreddyV
Senior Member
Thread Starter
 
Join Date: Jun 2008
Location: 5257'N 621'E
Posts: 1,977

Bikes: Giant OCR

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Prawza, I just started commuting yesterday, but not the entire way to work. For the first two weeks I'll be going just to the trainstation, and hop on the train. After those two weeks I'll be commuting all the way to work and back. Anyway, that's the plan.
I just might do one or two days all the way to work next week, just to see how it's turning out.

Haven't done cycling in years, so I still have something to work on and hope my butt won't get that sore.

So by developing commuting I mean the distances may change/improve on a weekly basis.

*edit* in a few weeks I could post a screenshot of the Excel sheet, to show you what I mean exactly.
FreddyV is offline  
Reply With Quote
Old 06-03-08, 12:59 AM
  #5  
prawza
Senior Member
 
prawza's Avatar
 
Join Date: Apr 2008
Location: Perth, Australia
Posts: 298

Bikes: Avanti ventura, Fuga Track Bike

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
ah ok.
i was assuming you were going to ride everyday, where in that case you would be riding the same distance each time so i was like, hmm how could tell? (thought you were timing your rides or something)

Sounds like a good plan though, also a good way of motivating you to ride more and more.

Good luck with it all, especially the sore butt thing. hah

Last edited by prawza; 06-03-08 at 01:00 AM. Reason: typo
prawza is offline  
Reply With Quote
Old 06-03-08, 01:01 AM
  #6  
Gabbo
Never get out of the boat
 
Gabbo's Avatar
 
Join Date: Mar 2006
Location: Aliso Viejo, CA
Posts: 113

Bikes: Fuji Sportif, Fuji SLM, Sanino Super Record

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Originally Posted by krauos View Post
yea i have a planet bike 9.0 wireless and an excel spreadsheed going

not to complicated, just weekly miles, total odometer and gas savings!!! $$$$$.
Similar set up. I track avg mph, miles and time for my rides. A good thing to do is track totals on parts and maintenance jobs. Good way to see where tires should be, how long a chain has left, whether or not you need to clean/lube one thing or another.
Gabbo is offline  
Reply With Quote
Old 06-03-08, 01:02 AM
  #7  
FreddyV
Senior Member
Thread Starter
 
Join Date: Jun 2008
Location: 5257'N 621'E
Posts: 1,977

Bikes: Giant OCR

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Good one. Might incorporate your ride timing idea as well...
FreddyV is offline  
Reply With Quote
Old 06-03-08, 02:03 AM
  #8  
JeffB502
Arrogant Safety Nanny
 
Join Date: Apr 2007
Location: Santa Maria, CA
Posts: 554

Bikes: 2007 Trek 7.2 FX, 2008 Trek Madone 5.2

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I log my data on bikejournal.com. I'm also a member of the Commuter Cycling Century club there, where the goal is to complete 100 round trip work commutes in the year (already there...going for the double century ).
JeffB502 is offline  
Reply With Quote
Old 06-03-08, 05:39 AM
  #9  
madhouse
Senior Member
 
madhouse's Avatar
 
Join Date: Sep 2004
Location: Podunc, Minnesota
Posts: 415

Bikes: 07 Sun EZ-Rider, 04 Fuji Royale, 97 Giant ATX890, 89 Burley Duet, 86 Trek 560

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I log every ride in an Excel spread sheet. I also log bike expenditures and pay myself for commuting miles... without getting rid of a car it takes a long time to pay off a bike and accessories in gas and upkeep alone... I'm several hundred commutes away from breaking even!
madhouse is offline  
Reply With Quote
Old 06-03-08, 05:48 AM
  #10  
Big Ron
Rim crusher
 
Join Date: Nov 2005
Location: Raleigh, NC
Posts: 290
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Date: Distance : Avg Speed: Ride Time: Comments:

Been tracking this basic info for years. In the comments section I further track the number of commutes to/from work each year. At the end of the year I tally up the total mileage, total time, etc.... Based on all that accumulated data I know that I am very close to hitting my 10,000 mile mark for commuting (not including recreational riding)
Big Ron is offline  
Reply With Quote
Old 06-03-08, 05:49 AM
  #11  
VA_Dave
beer disposal technician
 
Join Date: Sep 2007
Location: Ashburn, VA
Posts: 81
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I don't have a computer but I keep track of my commuting mileage in a spreadsheet. I measured the distance using Google Earth. I'm mostly concerned with the ratio of days I biked into work vs the days I drove, and so far this year's looking pretty good. Like madhouse, I also try to figure savings though it seems like an exercise in futility. 35 more pedal days and I'll have my garment bag pannier paid off and can buy the next expensive toy
VA_Dave is offline  
Reply With Quote
Old 06-03-08, 05:51 AM
  #12  
m_yates
Senior Member
 
m_yates's Avatar
 
Join Date: Feb 2008
Location: Rochester, NY
Posts: 636
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 10 Post(s)
My spreadsheet also keeps track of total expenditures, total miles, and a conservative estimate gas money saved. Since March 24 (when I first rode my new bike), I have logged 772 miles commuting. My net balance on bicycle expenditures is now -$801.45, but it is slowly shrinking now that I have my new bike set up how I like it.
m_yates is offline  
Reply With Quote
Old 06-03-08, 06:19 AM
  #13  
DataJunkie
Senior Member
 
Join Date: Oct 2005
Posts: 14,279
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
I ride more for fitness than anything else.
I log my stats in bikejournal.com to see how I am doing in relations to my fellow club members.
Distance, time, weather, ride description, type of ride, what bike I used, and a few other stats.
Just another way to enjoy cycling.
DataJunkie is offline  
Reply With Quote
Old 06-03-08, 07:15 AM
  #14  
tarwheel 
Senior Member
 
tarwheel's Avatar
 
Join Date: May 2007
Location: Raleigh, NC
Posts: 8,906

Bikes: Waterford RST-22, Bob Jackson World Tour, Ritchey Breakaway Cross, Soma Saga, De Bernardi SL, Specialized Sequoia

Mentioned: 36 Post(s)
Tagged: 0 Thread(s)
Quoted: 193 Post(s)
I've tracked all of my cycling miles for years, as well as any other exercise I do like walking, swimming, running, etc. I used journals for years, but have been using an on-line log since January and it is so much better. All I have to do is enter my mileage and time, and it calculates the average speed and keeps running totals by week, month, and year. I like it so much that I went back and entered in all of my mileage for 2007 as well. Check it out:

http://www.mycyclinglog.com/
tarwheel is offline  
Reply With Quote
Old 06-03-08, 07:21 AM
  #15  
mcsteve20
Pot holes suck
 
Join Date: May 2008
Location: Boston
Posts: 51

Bikes: 08 Schwinn Voyageur GS

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Yes, I have been keeping track. I don't feel like I'm just commuting to work, I also believe this is my excercise program. I keep track of my miles and my weight.
mcsteve20 is offline  
Reply With Quote
Old 06-03-08, 07:21 AM
  #16  
madhouse
Senior Member
 
madhouse's Avatar
 
Join Date: Sep 2004
Location: Podunc, Minnesota
Posts: 415

Bikes: 07 Sun EZ-Rider, 04 Fuji Royale, 97 Giant ATX890, 89 Burley Duet, 86 Trek 560

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Originally Posted by VA_Dave View Post
Like madhouse, I also try to figure savings though it seems like an exercise in futility. 35 more pedal days and I'll have my garment bag pannier paid off and can buy the next expensive toy
I don't wait... just like most other Red Blooded Americans I buy on credit!
madhouse is offline  
Reply With Quote
Old 06-03-08, 07:22 AM
  #17  
newbojeff
Commuter First
 
newbojeff's Avatar
 
Join Date: Mar 2006
Location: Boston, MA
Posts: 1,286
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Definitely. Garmin bike computer keeps track of all of it.

Same goal this year as last year: ride 5000 miles.
newbojeff is offline  
Reply With Quote
Old 06-03-08, 07:24 AM
  #18  
misterE0
Senior Member
 
Join Date: Aug 2007
Location: St. Louis, MO
Posts: 263

Bikes: Steelman road bike, '81 Schwinn Le Tour single speed,

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I keep a spreadsheet of time/duration/distance/av speed/max speed, etc. I have it setup to tally weekly and monthly totals. Feel free to use or modify it as you see fit:

http://spreadsheets.google.com/ccc?k...kyNNBPUw&hl=en
misterE0 is offline  
Reply With Quote
Old 06-03-08, 07:25 AM
  #19  
tekknoschtev
Senior Member
 
Join Date: May 2008
Location: Lansing, MI
Posts: 323
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Originally Posted by mcsteve20 View Post
Yes, I have been keeping track. I don't feel like I'm just commuting to work, I also believe this is my excercise program. I keep track of my miles and my weight.
Weight is an excellent one to keep track of along with this, especially if you consider it an exercise program (I do). I haven't started logging data yet, but now that I'm getting into this more seriously I will be
tekknoschtev is offline  
Reply With Quote
Old 06-03-08, 07:39 AM
  #20  
DataJunkie
Senior Member
 
Join Date: Oct 2005
Posts: 14,279
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
I track my weight as well. Been a bit depressing this year but I hope to turn it around soon.
A 1000 miles this month should help....I hope.
DataJunkie is offline  
Reply With Quote
Old 06-03-08, 07:39 AM
  #21  
josephjhaney
Senior Member
 
Join Date: Dec 2007
Posts: 397
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 19 Post(s)
Originally Posted by newbojeff View Post
Definitely. Garmin bike computer keeps track of all of it.

Same goal this year as last year: ride 5000 miles.
+1

I love my garmin, and while I most likely won't hit 5000 miles (my commute is only 8 miles each way) I should break 4000 this year, which is just fine by me. LOVE my GARMNIN!

Joe
josephjhaney is offline  
Reply With Quote
Old 06-03-08, 07:58 AM
  #22  
FreddyV
Senior Member
Thread Starter
 
Join Date: Jun 2008
Location: 5257'N 621'E
Posts: 1,977

Bikes: Giant OCR

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Interesting one VA_Dave.

Could you pass on the function on how to calculate the amount of days you've biked to work? Should be an IF function, but haven't been able to figure that out exactly yet.
FreddyV is offline  
Reply With Quote
Old 06-03-08, 08:09 AM
  #23  
VA_Dave
beer disposal technician
 
Join Date: Sep 2007
Location: Ashburn, VA
Posts: 81
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Originally Posted by FreddyV View Post
Could you pass on the function on how to calculate the amount of days you've biked to work? Should be an IF function, but haven't been able to figure that out exactly yet.
Nothing that fancy. I just have a column for bike and a column for car and sum them. I'm using the Google Docs spreadsheet and I'm not familiar with any higher-level functionality like that.
VA_Dave is offline  
Reply With Quote
Old 06-03-08, 08:12 AM
  #24  
Michael H
Member
 
Michael H's Avatar
 
Join Date: Feb 2007
Location: Wisconsin
Posts: 36

Bikes: Redline 925

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I track them, but it's mostly because we have a competition at work for who commutes the most. We've got sponsors and prizes and the whole nine. I got second this month...
Michael H is offline  
Reply With Quote
Old 06-03-08, 08:42 AM
  #25  
Psydotek
Body By Nintendo
 
Psydotek's Avatar
 
Join Date: Sep 2006
Location: Videogames ruined my life. Good thing i have 2 extra lives.
Posts: 3,187

Bikes: Giant TCR2, Giant TCX, IRO BFSSFG SE, Salsa Casseroll, IRO Rob Roy.

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I just reset the odometer on my bike at the end of the year.

I don't save $$$ on gas unfortunately (it goes to my train ticket instead). However, i'm estimating that if i bike commute (more like car-train-bike) 15 times per month, i'll keep about 14k miles off my car's odometer every year.
__________________

Originally Posted by jsharr View Post
A girl once asked me to give her twelve inches and make it hurt. I had to make love to her 3 times and then punch her in the nose.
Psydotek is offline  
Reply With Quote

Thread Tools
Search this Thread

Contact Us Archive Advertising Cookie Policy Privacy Statement Terms of Service