Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

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!

User Tag List

Reply
 
Thread Tools Search this Thread
Old 08-26-02, 11:29 AM   #1
lshield
Junior Member
Thread Starter
 
lshield's Avatar
 
Join Date: Aug 2002
Location: El Dorado Hills
Bikes:
Posts: 14
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
logging your rides

Does anyone use a computer program to log their training rides? If so, what do you use?
lshield is offline   Reply With Quote
Old 08-26-02, 11:37 AM   #2
Bikes-N-Drums
Skin-Pounder
 
Bikes-N-Drums's Avatar
 
Join Date: May 2002
Location: Clarkston (Atlanta, GA., USA)
Bikes:
Posts: 491
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
Bikes-N-Drums is offline   Reply With Quote
Old 08-26-02, 11:43 AM   #3
velo
The Female Enduro
 
velo's Avatar
 
Join Date: Apr 2000
Location: Pennsylvania, United States of America
Bikes:
Posts: 1,185
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Go ahead and search the site, here. I remember a discussion that talked about this, exactly.
velo is offline   Reply With Quote
Old 08-26-02, 12:06 PM   #4
scubagirl
Senior Member
 
Join Date: Oct 2001
Location: Arlington, Tx
Bikes:
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I use
http://www.bikeprolog.com/index.jsp
scubagirl is offline   Reply With Quote
Old 08-26-02, 12:13 PM   #5
ptmurphy
Junior Member
 
Join Date: Aug 2002
Location: Western Kentucky
Bikes:
Posts: 20
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
ptmurphy is offline   Reply With Quote
Old 08-26-02, 12:15 PM   #6
scubagirl
Senior Member
 
Join Date: Oct 2001
Location: Arlington, Tx
Bikes:
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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?
scubagirl is offline   Reply With Quote
Old 08-26-02, 12:19 PM   #7
Csson
Ready to go anywhere
 
Csson's Avatar
 
Join Date: Sep 2001
Location: .se
Bikes:
Posts: 313
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
Csson is offline   Reply With Quote
Old 08-26-02, 02:04 PM   #8
bac
Senior Member
 
bac's Avatar
 
Join Date: Jun 2002
Location: Pennsylvania
Bikes: Too many to list!
Posts: 7,481
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
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)
bac is offline   Reply With Quote
Old 08-26-02, 02:05 PM   #9
scubagirl
Senior Member
 
Join Date: Oct 2001
Location: Arlington, Tx
Bikes:
Posts: 163
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
the (miles) / (time) didn't work
scubagirl is offline   Reply With Quote
Old 08-26-02, 02:27 PM   #10
BikingCT
Senior Member
 
Join Date: Aug 2002
Location: Connecticut, USA
Bikes: 2002 Cannondale R3000 Si Triple; 2003 Cannondale R900 Si
Posts: 78
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
BikingCT is offline   Reply With Quote
Old 08-26-02, 02:57 PM   #11
AnnieYak
Member
 
Join Date: Aug 2002
Location: Yakima, WA
Bikes:
Posts: 37
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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......
AnnieYak is offline   Reply With Quote
Old 08-26-02, 09:16 PM   #12
aerobat
Love Me....Love My Bike!
 
aerobat's Avatar
 
Join Date: Dec 2000
Location: Winnipeg
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)
Quoted: 1 Post(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.
aerobat is offline   Reply With Quote
Old 08-27-02, 12:57 AM   #13
Dutchy
We drive on the left.
 
Dutchy's Avatar
 
Join Date: Sep 2001
Location: Adelaide, South Australia
Bikes:
Posts: 1,096
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I use Microsoft Word, just 6 columns and a heap of rows.
date, destination, distance, time, ave speed, maximium speed.

CHEERS.

Mark
Dutchy is offline   Reply With Quote
Old 08-27-02, 04:10 AM   #14
jmlee
serial mender
 
Join Date: Mar 2002
Location: Bonn, Germany
Bikes:
Posts: 416
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
jmlee is offline   Reply With Quote
Old 08-27-02, 08:23 AM   #15
bac
Senior Member
 
bac's Avatar
 
Join Date: Jun 2002
Location: Pennsylvania
Bikes: Too many to list!
Posts: 7,481
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
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!
bac is offline   Reply With Quote
Old 08-27-02, 04:55 PM   #16
webist
Huachuca Rider
 
webist's Avatar
 
Join Date: Jun 2002
Location: Charlotte, NC
Bikes: Fuji CCR1, Specialized Roubaix
Posts: 4,275
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Perhaps I'm the only one who DOESN'T log?
__________________
Just Peddlin' Around
webist is offline   Reply With Quote
Old 08-27-02, 04:58 PM   #17
SteveE
Veni, Vidi, Vomiti
 
SteveE's Avatar
 
Join Date: Jun 2002
Location: Republic of Anaerobia
Bikes: Serotta Legend Ti, Romani Columbus SL, Soma Doublecross
Posts: 3,582
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Webist - Nope. You're not the only one. Maybe just one of two!
SteveE is offline   Reply With Quote
Old 08-27-02, 06:53 PM   #18
lotek
Forum Admin
 
lotek's Avatar
 
Join Date: Dec 2001
Location: n.w. superdrome
Bikes: 1 trek, serotta, rih, de Reus, Pogliaghi and finally a Zieleman! and got a DeRosa
Posts: 17,702
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.


Want to upgrade your membership? Click Here.
lotek is offline   Reply With Quote
Old 08-28-02, 02:07 AM   #19
jmlee
serial mender
 
Join Date: Mar 2002
Location: Bonn, Germany
Bikes:
Posts: 416
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
jmlee is offline   Reply With Quote
Old 08-28-02, 06:04 AM   #20
Steven Buglass
Junior Member
 
Join Date: Aug 2002
Location: Essex in England
Bikes:
Posts: 13
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
Steven Buglass is offline   Reply With Quote
Old 09-01-02, 01:03 AM   #21
willic
Senior Member
 
Join Date: Jul 2001
Location: N.E.England.(geordieland)
Bikes:
Posts: 605
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
willic is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 02:21 PM.