Bike Forums > bike log
 Register All Albums Elite Membership Forum Rules Calendar Search Today's Posts Mark Forums Read

 General Cycling Discussion Have a cycling related question or comment that doesn't fit in one of the other specialty forums? Drop on in and post in here! When possible, please select the forum above that most fits your post!

 07-04-09, 09:10 PM #1 bikewise007 Newbie Thread Starter   Join Date: Jul 2009 Bikes: Posts: 1 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 0 Post(s) bike log hi all I have just joined this web site as it seems great! I was wondering if anyone has a simple bike log, all it has to have is the date,distance, time & monthly total , which I can down load and use. I know a lot of you use more complex ones but I get lost with them as I am an old pensioner Ian
 07-04-09, 10:50 PM #2 VeganForPeace Senior Member   Join Date: Jun 2009 Bikes: Posts: 115 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 0 Post(s) mapmyride.com is pretty simple to use and it allows you to pull up a map, create a route that you ride by clicking on the streets, and it logs the mileage, the time, and the average speed. I find it to work well for me.
07-04-09, 11:43 PM   #3
SchnauzerHerder
Senior Member

Join Date: Jun 2009
Location: Irvine, CA
Bikes: Trek 820
Posts: 53
Mentioned: 0 Post(s)
Quoted: 0 Post(s)
Just use excel, or another spread sheet. You can set up something pretty simple in a few minutes where you just plug the info you want (like date, distance and time), and it can give you the total miles, a monthly total, average time per ride, average distance.

to set this up: open excel.
Column A is the date
Column B is the distance
Column C is time

Find a place for the total miles (I use D1 and D2... D2 has the formula =SUM(B:B) which tells excel to put the sum of everything in the B column into D2).

Then find a place for the monthly totals.
I use D3,E3, and F3 (month, distance, time respectively)
To put in to total distance, put =SUM(B2:B13) (or whatever the cell range is: you can put =SUM( then click and drag a range of cells instead)
Same for total time, except its =SUM(C2:C13).

and you're done. I've got a pic to help a little.

Attached Images
 bike log.jpg (51.1 KB, 28 views) bike log 2.jpg (55.6 KB, 24 views)

07-05-09, 05:18 AM   #4
Jim from Boston
Senior Member

Join Date: May 2008
Bikes:
Posts: 5,415
Mentioned: 14 Post(s)
Quoted: 251 Post(s)
Quote:
 Originally Posted by SchnauzerHerder Just use excel, or another spread sheet. You can set up something pretty simple in a few minutes where you just plug the info you want (like date, distance and time), and it can give you the total miles, a monthly total, average time per ride, average distance...
I use Excell too. I like to graph my data. In particular I do a published ten week training schedule for a century and I have attached a copy of a bar graph. The blue bars are the weekly recommended miles, the brown bars are my actual mileage, and the yellow line is my usual 80 mile per week commute. I find it motivates me to keep up when I plot the data and see the results.

BTW, week 10 is the Century week, and week 11 is the mileage I would like to do for the next few weeks until I resume training for the next century.
Attached Files
 Training graph.doc (54.5 KB, 13 views)

07-05-09, 08:10 AM   #5
SchnauzerHerder
Senior Member

Join Date: Jun 2009
Location: Irvine, CA
Bikes: Trek 820
Posts: 53
Mentioned: 0 Post(s)
Quoted: 0 Post(s)
Quote:
 Originally Posted by Jim from Boston I use Excell too. I like to graph my data. In particular I do a published ten week training schedule for a century and I have attached a copy of a bar graph. The blue bars are the weekly recommended miles, the brown bars are my actual mileage, and the yellow line is my usual 80 mile per week commute. I find it motivates me to keep up when I plot the data and see the results.
Thats another reason I like using Excel, or another spreadsheet program. Its simple to set up, easy to use, and can be modified on a moments notice to track some other bit of information i decide i want to know. While I'm fond of things like Mapmyride.com and bikely.com, it requires me to be online and for me to deal with ads, page loading, and some frustration getting it to map he route properly.

 07-05-09, 08:36 AM #6 tsl Plays in traffic     Join Date: May 2006 Location: Rochester, NY Bikes: 1996 Litespeed Classic, 2006 Trek Portland, 2013 Ribble Winter/Audax, 2016 Giant Talon 4 Posts: 6,964 Mentioned: 6 Post(s) Tagged: 0 Thread(s) Quoted: 41 Post(s) I use BikeJournal.com. The free version does all the basics. The \$20/year membership version tracks stuff even I've never heard of. Plus, I like the forum there. You can keep your log privately, or optionally share your log with other members, or with the public. I've chosen public. My BikeJournal Ride Log My BikeJournal Profile As a paid member, I get to choose which columns appear in my log and in what order. I can also sort and filter by column and column data. Note too the bike statistics in my profile. Miles on the bike, miles on each tire and miles on the chain help me keep track for maintenance.