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


Go Back   > >

Training & Nutrition Learn how to develop a training schedule that's good for you. What should you eat and drink on your ride? Learn everything you need to know about training and nutrition here.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 05-21-03, 11:38 AM   #1
cyclochica
Don't Taunt Happyfunball
Thread Starter
 
cyclochica's Avatar
 
Join Date: Aug 2002
Location: Northern Virginia
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Posts: 589
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Excel Spread Sheet Training Log

Does anyone have a training log set up in excel with formulas that they would be willing to email me? Thanks
__________________
There can be only one.
cyclochica is offline   Reply With Quote
Old 05-21-03, 11:42 AM   #2
ChipRGW
hehe...He said "member"
 
ChipRGW's Avatar
 
Join Date: Aug 2002
Location: Fort Lauderdale, FLA
Bikes:
Posts: 630
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I have one that I set up to track my training schedule for the MS150.

You, and all, are welcome to DL it and adapt it if it's what you are looking for...
__________________
Sometimes you just let the rabbits run, but sometimes you gotta let the dogs run.
ChipRGW is offline   Reply With Quote
Old 05-21-03, 01:28 PM   #3
cyclochica
Don't Taunt Happyfunball
Thread Starter
 
cyclochica's Avatar
 
Join Date: Aug 2002
Location: Northern Virginia
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Posts: 589
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks Chip. I need a backup system if Bike Pro Log never comes back up.
__________________
There can be only one.
cyclochica is offline   Reply With Quote
Old 05-25-03, 06:49 PM   #4
The Terminator
Bike for life.
 
Join Date: Apr 2003
Location: The Silver Comet Trail
Bikes: KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
Posts: 370
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I use a MSExcell format. I copy and paste it to a MS Word document, then save it as HTML, and then view as html source code, and then copy and paste it to my web page as an html document. Its really easy. You can see it at my web page, listed in the sig file. I am going to take a look at the one I just downloaded from this post. - Best
The Terminator is offline   Reply With Quote
Old 05-28-03, 01:26 PM   #5
nvrqut100
Junior Member
 
Join Date: May 2003
Location: Arlington, Va.
Bikes:
Posts: 6
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
cyclochica, are you racing in the northern Va area?
nvrqut100 is offline   Reply With Quote
Old 05-28-03, 02:00 PM   #6
cyclochica
Don't Taunt Happyfunball
Thread Starter
 
cyclochica's Avatar
 
Join Date: Aug 2002
Location: Northern Virginia
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Posts: 589
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally posted by nvrqut100
cyclochica, are you racing in the northern Va area?
Not racing yet, I need to get a better bike for that. Right now I am riding for fitness and personal distance goals. Once I finish grad school I am going to think about racing, and buying a newer bike.
__________________
There can be only one.
cyclochica is offline   Reply With Quote
Old 05-30-03, 05:01 AM   #7
trmcgeehan
Senior Member
 
trmcgeehan's Avatar
 
Join Date: Oct 2002
Location: Somerset, KY -- near Lake Cumberland
Bikes: 1980 Univega; 1985 Ross; 1994 Trek 1400 -- all road bikes
Posts: 757
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Using Excel for a bike log is a great idea. Wonder why I didn't think of it. I used Bike Prolog, but since they've been off the net, I've been using a pad and pencil. Excel makes much more sense. I use Excel for my family's budget, and it has worked great. Now, for the first time in my life, I know where all my money goes (wine, women, bikes). I like the way Excel keeps a running total of everything. Bike Prolog was great, but if they're not consistently up and running, it's of no use to me.
__________________
"I am a true laborer. I earn that I eat, get that I wear, owe no man hate, envy no man's happiness, glad of other men's good, content with my harm." As You Like It, Act 3, Scene 2. Shakespeare.
"Deep down, I'm pretty superficial." Ava Gardner.
trmcgeehan is offline   Reply With Quote
Old 05-30-03, 09:11 PM   #8
clintthayer
www.activebody.org
 
Join Date: Apr 2002
Location: Madison, WI
Bikes: Airborne Zepp 2003, Co-Motion Tandem, Trek 8000 mtn bike (commuter), Klein Attitude Comp
Posts: 221
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Check out www.activebody.org... very easy to use and does most of what bikeprolog does/did

and it's free...

and it will not go away (cause I use it for my own training).

Cheers,
Clint
clintthayer is offline   Reply With Quote
Old 06-03-03, 03:03 PM   #9
melston
Newbie
 
Join Date: Jun 2003
Bikes:
Posts: 4
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
try www.crosstrack.com they have a free version that seems to capture most everything...
melston is offline   Reply With Quote
Old 06-03-03, 03:07 PM   #10
clintthayer
www.activebody.org
 
Join Date: Apr 2002
Location: Madison, WI
Bikes: Airborne Zepp 2003, Co-Motion Tandem, Trek 8000 mtn bike (commuter), Klein Attitude Comp
Posts: 221
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Not sure why my url got goofed... but this should work


www.activebody.org
clintthayer is offline   Reply With Quote
Old 06-18-03, 04:25 PM   #11
memphisjim
Member
 
memphisjim's Avatar
 
Join Date: Aug 2002
Location: Memphis
Bikes: Trek 2300
Posts: 44
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Cyclochica & Trmcgeehan,

If you are still looking for a simple excel spreadsheet to collect riding and running data see if the attached one works for you.

I've been using it for about a year and it works ok for me as a method to collect data such as distance, time, heart rate and keeps track of cummulative miles, calculates MPH, weekly averages, etc.

(I had to delete some of the charting functions to get the size down below 102kb so the charts don't work)

The cells are not protected so be sure and only enter data in the yellow cells.

If you improve on it just be sure to repost the revised version.


Jim
__________________
"A desk is a dangerous place from which to view the world." - John le Carre

"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
memphisjim is offline   Reply With Quote
Old 06-19-03, 04:48 AM   #12
ZackJones
On Your Right
 
ZackJones's Avatar
 
Join Date: Mar 2003
Location: Warner Robins, GA
Bikes:
Posts: 1,422
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
memphisjim: would you mind emailing me the full version. Thanks!

Zack
__________________
"You never fail, you simply produce results. Learn from these" - Anonymous
ZackJones is offline   Reply With Quote
Old 06-19-03, 06:43 AM   #13
memphisjim
Member
 
memphisjim's Avatar
 
Join Date: Aug 2002
Location: Memphis
Bikes: Trek 2300
Posts: 44
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Zack,

I've received a few PM's with some questions and suggestions.

What type of additional info do you want to keep track of? Time, Distance, Average, Weekly Average, Cummulative, etc. and for activities other than riding? such as running and swimming, etc. Also what types of charts, graphs and summaries?

Let me know and I'll try and include your suggestions.

Jim
__________________
"A desk is a dangerous place from which to view the world." - John le Carre

"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
memphisjim is offline   Reply With Quote
Old 06-19-03, 07:51 AM   #14
ZackJones
On Your Right
 
ZackJones's Avatar
 
Join Date: Mar 2003
Location: Warner Robins, GA
Bikes:
Posts: 1,422
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Jim,

I'm interested in cycling only. Add all the features you want - I'll just skip the ones I don't need

Zack
__________________
"You never fail, you simply produce results. Learn from these" - Anonymous
ZackJones is offline   Reply With Quote
Old 06-19-03, 07:55 AM   #15
cyclochica
Don't Taunt Happyfunball
Thread Starter
 
cyclochica's Avatar
 
Join Date: Aug 2002
Location: Northern Virginia
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Posts: 589
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks for all the suggestions.

Memphisjim, the chart looks great. Thanks so much.
__________________
There can be only one.
cyclochica is offline   Reply With Quote
Old 06-19-03, 09:14 AM   #16
fujibike
Senior Member
 
fujibike's Avatar
 
Join Date: May 2003
Location: Delaware
Bikes:
Posts: 369
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I have a nice spreadsheet developed on Excel 2000 but don't have the zip utility to post through the forum. It includes a data entry sheet, multiple chart sheets, and sheets that are used in data manipulation to create the charts available. Updating data is done via a macro which is invoked by holding the 'ctrl' key down and pressing 'w'. It updates all charts, saves the file and returns user to last data entered. Only data entry required is miles and minutes. One down side, it is year 2003 specific, however, using it from one year to another would only result in some shifting of data from week to week or month to month on the charts. Bar graphs include: Cumulative Miles, Weekly Miles, Monthly Miles, Average distance/ride/month, and Average MPH per month.
fujibike is offline   Reply With Quote
Old 06-19-03, 09:50 AM   #17
Guest
Guest
 
Bikes:
Posts: n/a
Mentioned: Post(s)
Tagged: Thread(s)
Quoted: Post(s)
How about emailing it to people who want it instead of trying to post it on the forum?

Fuji, I'd love to get my hands on your chart....
  Reply With Quote
Old 06-20-03, 03:31 AM   #18
Bobatin
Senior Member
 
Bobatin's Avatar
 
Join Date: Oct 2002
Location: Newnan, GA
Bikes:
Posts: 402
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
A good log from cyclingforum.com

Cycling ChartLogTTF Workbook

Longtime forum member and contributor JayPee has created a Microsoft Excel spreadsheet analysis tool for reviewing cycling data.


JayPee's ChartLogTTF Workbook has received a fairly thorough review and workout over the last 6 weeks so it should work without major flaws. He will provide support for it - not only as constructed, but for any updates as may be needed. In addition, he will assist FORUM MEMBERS in making reasonable custom modifications if needed.


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

Last edited by Bobatin; 06-20-03 at 03:37 AM.
Bobatin is offline   Reply With Quote
Old 06-20-03, 07:16 PM   #19
The Terminator
Bike for life.
 
Join Date: Apr 2003
Location: The Silver Comet Trail
Bikes: KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
Posts: 370
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
memphisjim,

That is a phenominal chart that you offered. I enjoyed the MS 150, I tweaked it some, but this one that you came up with is really fabulous. Thanks!
The Terminator is offline   Reply With Quote
Old 12-18-06, 04:26 PM   #20
bdcheung
Carpe Diem
 
bdcheung's Avatar
 
Join Date: Sep 2006
Location: MABRA
Bikes: 2007 CAAD9; 2014 CAADX; PedalForce CG1
Posts: 13,149
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
This is a GREAT spreadsheet!!!
__________________
"When you are chewing the bars at the business end of a 90 mile road race you really dont care what gear you have hanging from your bike so long as it works."
ΛΧΑ ΔΞ179 - 15% off your first Hammer Nutrition order!
bdcheung is offline   Reply With Quote
Old 12-19-06, 07:11 PM   #21
BloomBikeShop
BloomBikeShop.com
 
BloomBikeShop's Avatar
 
Join Date: Sep 2004
Location: East Coast
Bikes: A few.
Posts: 475
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
If you're still looking for more, I have at least one version on my site.

http://coachlevi.com/articles/traininglog.htm

http://coachlevi.com/articles/traininglogsystem.htm
BloomBikeShop 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 10:40 AM.