RoadBikeReview.com's Forum Archives - General


Archive Home >> General(1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 )


Excel training log...(8 posts)

Excel training log...Vortex
Nov 22, 2001 7:13 AM
Hi... I´m looking for an Excel version of a training log/diary... If anyone here uses one please email me with a copy of your version at coglliostro@hotmail.com, I´ll be very glad!!!
Want one toobikerduder
Nov 22, 2001 7:31 AM
I would like the same if you run across any. email me at:

dmathertmmc@hotmail.com

Thanks
Want one toogusriley
Nov 23, 2001 3:20 PM
A version of my Excel Training Log is on it's way to you. It's for 2002. Let me know if you like it.
I use a home-made one ...Humma Hah
Nov 22, 2001 7:42 AM
I track mileage on three bikes, two of which have cyclocomputers, the third is estimated mileage based on known route lengths. Odometer readings are entered for each week, accumulated for the year-to-date, and each mileage and total mileage is plotted.

I have several "goal lines", my original goal of 60 miles per week, an upgraded goal of 70 miles per week, and my current goal of 80 miles per week. These are plotted with my actual miles, and have proved to be a great motivator to ride more, and not have off-weeks. They're presently the most patched-up feature, needing a little work to be easy to use.

There's a seperate sheet for ride logs, where I can make notes about various big rides, more like a diary. It was originally set up to show one line for the weekdays, and a line for Saturday, another for Sunday. That worked early this year when I was mostly a weekend warrior. Now I mostly commute, with little weekend riding, and am thinking of changing the format to make it more flexible.

I need to strip this spreadsheet of its current data to make a blank one for next year. When I do that, I could make a copy available to you. If you know how to do basic Excel spreadsheets, it would be pretty easy to customize.
Excelbikerduder
Nov 22, 2001 8:18 AM
HH - I have two versions of excel, 97 on the work machine, 95 on the home unit. I have done literally thousands of spreadsheets in my time, but would like to see what you've done to save the time of creating a new one. Send it on in 95 format if you don't mind.

Thanks
You can beta-test it for me ...Humma Hah
Nov 22, 2001 11:31 AM
I've stripped it down, tidied it up, and it is ready to be tried out.

E-mail me at tomligon@compuserve.com, and I'll send you a copy.
re: Excel training log...Frank
Nov 22, 2001 3:28 PM
I made one that I have been using and sharing for several years. A version of it can be obtained for free at:

http://www.cyclingforum.com/features/findex.htm

Frank
re: Excel training log...gusriley
Nov 23, 2001 3:18 PM
I'm sending you my version of a Training Log written with Excel. It's on it's way.