Advertise on Bikeforums.net



User Tag List

Results 1 to 6 of 6

Thread: bike log

  1. #1
    Newbie
    Join Date
    Jul 2009
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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

  2. #2
    Senior Member
    Join Date
    Jun 2009
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  3. #3
    Senior Member
    Join Date
    Jun 2009
    Location
    Irvine, CA
    My Bikes
    Trek 820
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

    If you want more info, you can always add to your spreadsheet (like adding average distance, average speed, average time on bike, what type of ride it was). If you need help, there's plenty of online help for spreadsheets, and you can PM me, or ask here.
    Attached Images Attached Images

  4. #4
    Senior Member Jim from Boston's Avatar
    Join Date
    May 2008
    Posts
    2,700
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by SchnauzerHerder View Post
    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 Attached Files

  5. #5
    Senior Member
    Join Date
    Jun 2009
    Location
    Irvine, CA
    My Bikes
    Trek 820
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Jim from Boston View Post
    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.

  6. #6
    tsl
    tsl is offline
    Plays in traffic tsl's Avatar
    Join Date
    May 2006
    Location
    Rochester, NY
    My Bikes
    '96 Litespeed Classic, '06 Trek Portland, '13 Ribble Winter/Audax
    Posts
    6,257
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(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.
    My two favorite things in life are libraries and bicycles. They both move people forward without wasting anything.
    The perfect day: Riding a bike to the library.—Peter Golkin


    Lucky for me, I work at a library and bike to work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •