Advertise on Bikeforums.net



User Tag List

Results 1 to 21 of 21
  1. #1
    Junior Member lshield's Avatar
    Join Date
    Aug 2002
    Location
    El Dorado Hills
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    logging your rides

    Does anyone use a computer program to log their training rides? If so, what do you use?

  2. #2
    Skin-Pounder Bikes-N-Drums's Avatar
    Join Date
    May 2002
    Location
    Clarkston (Atlanta, GA., USA)
    Posts
    491
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use Excel with a log I made up myself. PM me if you want a copy. Also, there's tons of freebie logs over the net.
    We are the musicmakers and we are the dreamers of dreams...

  3. #3
    The Female Enduro velo's Avatar
    Join Date
    Apr 2000
    Location
    Pennsylvania, United States of America
    Posts
    1,185
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)
    Go ahead and search the site, here. I remember a discussion that talked about this, exactly.
    "....You have to have faith that if you're doing the work now,you'll get there sometime."
    - Nicole Reinhart

  4. #4
    Senior Member
    Join Date
    Oct 2001
    Location
    Arlington, Tx
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  5. #5
    Junior Member
    Join Date
    Aug 2002
    Location
    Western Kentucky
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use both my own spreadsheet and bikeprolog.com

    I can't decide between the two, since my spreadsheet has a couple of graphs in it I can get to quickly and understand.

    Bikeprolog has the advantage (disadvantage?) of keeping the data off-site in case something happens here.

  6. #6
    Senior Member
    Join Date
    Oct 2001
    Location
    Arlington, Tx
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried to do an excell spreadsheet, but couldn't get it to average mph.

    is there a function or something else that will do it?

  7. #7
    Ready to go anywhere Csson's Avatar
    Join Date
    Sep 2001
    Location
    .se
    Posts
    313
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use bikeprolog.com too, after someone here suggested them. They did have a database crash about a month ago that erased a couple of days, but one great feature is the ability to download an Excel spread sheet with all your data.

    /Csson
    Two roads diverged in a wood, and I-
    I took the one less travelled by,
    And that has made all the difference.
    (R. Frost)

  8. #8
    bac
    bac is offline
    Senior Member bac's Avatar
    Join Date
    Jun 2002
    Location
    Pennsylvania
    My Bikes
    Too many to list!
    Posts
    7,488
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by scubagirl
    I tried to do an excell spreadsheet, but couldn't get it to average mph.

    is there a function or something else that will do it?
    Yup, the function is:

    =average(number1,number2,number3,etc)

    For example, if your spreadsheet has a column of numbers (let's say it's column C, and cells C1-C15), then the actual formula would be:

    =average(C1:C15)

  9. #9
    Senior Member
    Join Date
    Oct 2001
    Location
    Arlington, Tx
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the (miles) / (time) didn't work

  10. #10
    Senior Member
    Join Date
    Aug 2002
    Location
    Connecticut, USA
    My Bikes
    2002 Cannondale R3000 Si Triple; 2003 Cannondale R900 Si
    Posts
    78
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Like B-n-D, I use my own Excell spreadsheet. I can easily create my own reports and graphs, and report how I want to see it (versus what another program may have pre-set). I also use it to track my training progress, as I train for rides of different length and # of days. This way, I can plug in the target miles for the ride I want, the numer of weeks I have to train, and it calculates exactly how many miles per day/week I need to train to achieve the goal. It is loosely base doff the guide that was in Bicycling magazine a while ago on Training for a Century.

  11. #11
    Member
    Join Date
    Aug 2002
    Location
    Yakima, WA
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I also use an excel spreadsheet. This way it is totally my whim to what I wish to log. I control the program, for I am, the great programmer!!

    Annie......

  12. #12
    Love Me....Love My Bike! aerobat's Avatar
    Join Date
    Dec 2000
    Location
    Winnipeg
    My Bikes
    Bikes: Giant hybrid, Trek 4500, Cannondale R800 Some commuting 20mi/day, mostly fitness riding - 20-50 mile rides
    Posts
    1,231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use a quattro pro spreadsheet, and a program on my palm pilot called CyclistsLog, which is very good. It is supposed to be coming out in a PC version, which can be synched to the pilot (and vice versa). If and when it does come out, I'll probably just use that instead of quatro pro.
    "...perhaps the world needs a little more Canada" - Jean Chretian, 2003.

  13. #13
    We drive on the left. Dutchy's Avatar
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia
    Posts
    1,096
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use Microsoft Word, just 6 columns and a heap of rows.
    date, destination, distance, time, ave speed, maximium speed.

    CHEERS.

    Mark
    I'd rather be riding.

  14. #14
    serial mender
    Join Date
    Mar 2002
    Location
    Bonn, Germany
    Posts
    416
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Scubagirl,

    to do the average speed calculation you want use the following =(distance)/(time * 24) and make sure that the cell format is set to "General" (excel will try to outsmart itself by setting the cell to a "Time" format).

    The above presumes that your "time" cell is already in a hh:mm:ss time format.

    Cheers,
    Jamie

    P.S. in other places where I have tried to deal with time in excel, I have found sometimes that I needed to divide a value by 24 to get it to produce the time correctly.

  15. #15
    bac
    bac is offline
    Senior Member bac's Avatar
    Join Date
    Jun 2002
    Location
    Pennsylvania
    My Bikes
    Too many to list!
    Posts
    7,488
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by bac


    Yup, the function is:

    =average(number1,number2,number3,etc)

    For example, if your spreadsheet has a column of numbers (let's say it's column C, and cells C1-C15), then the actual formula would be:

    =average(C1:C15)
    FYI, this function (=average or @average) assumes that you already have a column of average daily speeds. This function would then average all of the days in the column and give you an aggregate average speed. The beauty of this function is that it automatically counts the number of cells; therefore, you do not have to change the formula if you add more rows to the column.

    Of course, if you just want the average speed for the day, create a formula as specified in a few of the proceeding messages.

    I hope that made sense!

  16. #16
    Huachuca Rider webist's Avatar
    Join Date
    Jun 2002
    Location
    Southeastern, AZ
    My Bikes
    Fuji CCR1, Specialized Roubaix
    Posts
    4,273
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Perhaps I'm the only one who DOESN'T log?
    Just Peddlin' Around

  17. #17
    Veni, Vidi, Vomiti SteveE's Avatar
    Join Date
    Jun 2002
    Location
    Republic of Anaerobia
    My Bikes
    Serotta Legend Ti, Romani Columbus SL, Soma Doublecross
    Posts
    3,581
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Webist - Nope. You're not the only one. Maybe just one of two!
    "Life's journey is not to arrive at the grave safely in a well preserved body, but rather to skid in sideways, totally worn out, shouting ...'holy *****...what a ride!'"

  18. #18
    Forum Admin lotek's Avatar
    Join Date
    Dec 2001
    Location
    n.w. superdrome
    My Bikes
    1 trek, serotta, rih, de Reus, Pogliaghi and finally a Zieleman! and got a DeRosa
    Posts
    17,606
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have Log software, but I don't use it.
    so that makes 3 of us.
    However let it be said, I'm not training for anything
    specifically (at the moment).
    On the otherhand, I don't go 15 minutes after a dive
    without making an entry in a log book.

    Marty
    Sono pił lento di quel che sembra.
    Odio la gente, tutti.

    Are you a registered member? Why not? click here to register. Its free, and only takes 27 seconds!
    Want to upgrade your membership? Click Here.

  19. #19
    serial mender
    Join Date
    Mar 2002
    Location
    Bonn, Germany
    Posts
    416
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have sometimes laughed at myself for the meticulousness with which I log my rides. I am training, of course, but not for anything in particular (more self-irony).

    But, when I injured my achilles tendon this spring it was really useful for me to have a log. I didn't really investigate the injury until about a month after it first happened (due to vacation and other stuff). But, since I had dutifully recorded my cramping calves and so forth, I was able to pin-point them as the cause. This further helped my doctor to determine that the underlying cause was with my feet. So, while making it an obsession is not a good thing, a few notes can pay off.

    I am still trying to plot the relationship between my average speed and my sex-life, but I haven't found the appropriate Excel function.

    Cheers,
    Jamie

  20. #20
    Junior Member
    Join Date
    Aug 2002
    Location
    Essex in England
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've just been using the software that comes with the Polar 610/710/810 HR monitors, it can record and graph all the info I can think of:
    Complete graph of how hard you worked ie Heart rate
    average HR
    time spent in each HR zone
    Calaries
    Weight
    Distance
    Average speed
    Time if day
    date
    temp

  21. #21
    Senior Member
    Join Date
    Jul 2001
    Location
    N.E.England.(geordieland)
    Posts
    605
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Scubagirl!

    For the info on finding Pro-log.

    My own log was a bit of a shambolic mess, which I have transfered to Pro-log. That has tidy`ed it up no-end.....

    I particularly like the matching of your own performance with other riders, it just adds another edge to the incentive to get out and ride.

Posting Permissions

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