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 08-06-06, 07:12 AM   #1
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Free Excel Template for Training

I have sample mileages inserted so just remove them and insert your own. Feel free to use this, it is .xlt format. I can also set it up in Open Office or Starcalc. Use it in good health, and of course, if you want, feel absolutely free to virus scan before you open it. It is virus and spyware free and simple to use. Use it in good health!

To the Moderators: If you want to make this a "Sticky", it's fine with me! I put this spreadsheet template together to help other riders, and it can be publically redistributed FOR FREE only. It can't be sold.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant

Last edited by Tom Stormcrowe; 08-07-06 at 04:15 PM.
Tom Stormcrowe is offline   Reply With Quote
Old 08-06-06, 07:48 AM   #2
linux_author
370H-SSV-0773H
 
linux_author's Avatar
 
Join Date: May 2005
Location: Penniless Park, Fla.
Bikes: Merlin Fortius, Specialized Crossroads & Rockhopper, Serotta Fierte, Pedal Force RS2
Posts: 2,750
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
- tks for sharing! the .xlt opened right up under NeoOffice/J 1.2.2 under OS X 10.3.9!

(will give a try under Oo 2.X under KANOTIX64 w/a 2.6.13 kernel)

- hope others will contribute in this sticky!
linux_author is offline   Reply With Quote
Old 08-06-06, 04:06 PM   #3
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by linux_author
- tks for sharing! the .xlt opened right up under NeoOffice/J 1.2.2 under OS X 10.3.9!

(will give a try under Oo 2.X under KANOTIX64 w/a 2.6.13 kernel)

- hope others will contribute in this sticky!
Not a sticky yet, but I can hope! No problem, linux_author, and you're welcome! I chose the .xlt format as it will open with any Windows 'puter w/ Office or Excel on it as well as my favorite OS, linux.. If anybody needs a different format, like Starcalc, let me know and I'll create that template as well. Like I said, the Template is free to use, enjoy in good health! I figure that the less time cyclists need to spend at the computer designing a tracking/graphing template for their training, the more time they'll have to ride!

Besides, free to use, isn't that the Open Source credo?
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant

Last edited by Tom Stormcrowe; 08-06-06 at 04:54 PM.
Tom Stormcrowe is offline   Reply With Quote
Old 08-06-06, 10:15 PM   #4
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by Tom Stormcrowe
I have sample mileages inserted so just remove them and insert your own. Feel free to use this, it is .xlt format. I can also set it up in Open Office or Starcalc. Use it in good health, and of course, if you want, feel absolutely free to virus scan before you open it. It is virus and spyware free and simple to use. Use it in good health!

To the Moderators: If you want to make this a "Sticky", it's fine with me! I put this spreadsheet template together to help other riders, and it can be publically redistributed FOR FREE only. It can't be sold.
No offense, but does it do anything beside summarize mileage for 2006? Like, weekly or monthly totals?

Also, I suspect there's a bug in one of the macros. Whenever I try to switch from Sheet 3 (which appears to contain nothing but a gray box), to sheet 1, it locks up Excel tight...I have to use Task Manager to kill it. This happened twice, using Excel 2000 on a Win XP system.
SSP is offline   Reply With Quote
Old 08-07-06, 03:20 AM   #5
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by SSP
No offense, but does it do anything beside summarize mileage for 2006? Like, weekly or monthly totals?

Also, I suspect there's a bug in one of the macros. Whenever I try to switch from Sheet 3 (which appears to contain nothing but a gray box), to sheet 1, it locks up Excel tight...I have to use Task Manager to kill it. This happened twice, using Excel 2000 on a Win XP system.
Hmm, haven't had any problem with Excel on my end. I've opened and run it on Windows, and Ubuntu linux. I've used Excel and Open Office to test the stability. Gray box is supposed to be a graph, and it's basically a trends program. There are a couple of websites listed on the cover page for other things like Wattage, etc.

Anybody else have problems with Excel 2000 with the template? Let me know and I'll start looking for buggy code.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline   Reply With Quote
Old 08-07-06, 07:22 AM   #6
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
The problem definitely seems related to Sheet 3...whenever I go to that sheet, it locks up Excel on my system. Might be an issue with what's in the zip file and/or corruption in the download...not sure (installer problems can be a PITA to figure out).
SSP is offline   Reply With Quote
Old 08-07-06, 09:13 AM   #7
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by SSP
The problem definitely seems related to Sheet 3...whenever I go to that sheet, it locks up Excel on my system. Might be an issue with what's in the zip file and/or corruption in the download...not sure (installer problems can be a PITA to figure out).
I think I found the problem. Excel has a 255 line data set limit and I used Open Office 2.0 to create my program and it has a far higher data set limit on the graphing function. Just one of the reasons I prefer Sun Microsystems over Microcrash! I'm pulling the software for now and will have it reconfigured later today for a more limited dataset, ie: Weekly trend and Monthly rather than the daily trend I was using. Do you mind if I shoot you the file before I post the v2.0? You use Excel proper, vs my Open Office so you can tell me if that fixes the macro issue. Thanks, if so, and if not, no problem!

-Tom
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline   Reply With Quote
Old 08-07-06, 11:05 AM   #8
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by Tom Stormcrowe
I think I found the problem. Excel has a 255 line data set limit and I used Open Office 2.0 to create my program and it has a far higher data set limit on the graphing function. Just one of the reasons I prefer Sun Microsystems over Microcrash! I'm pulling the software for now and will have it reconfigured later today for a more limited dataset, ie: Weekly trend and Monthly rather than the daily trend I was using. Do you mind if I shoot you the file before I post the v2.0? You use Excel proper, vs my Open Office so you can tell me if that fixes the macro issue. Thanks, if so, and if not, no problem!

-Tom
Sure, no problem. Just send it to SSP at my CycliStats domain name. I'll try to check it out this evening.

FWIW, there are already some fairly comprehensive Excel-based ride logs available on the internet, mostly available from bike clubs and enthusiasts. If you're interested, I could send you some links (don't have them available right now though).
SSP is offline   Reply With Quote
Old 08-07-06, 03:46 PM   #9
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by SSP
Sure, no problem. Just send it to SSP at my CycliStats domain name. I'll try to check it out this evening.

FWIW, there are already some fairly comprehensive Excel-based ride logs available on the internet, mostly available from bike clubs and enthusiasts. If you're interested, I could send you some links (don't have them available right now though).
I know, Bike Journal, among others...
I'm doing it for the intellectual exercise as well as making another one available. I'm sending it from My yahoo address, gunsel2001(at)yahoo.com. It's on the email in 5 minutes!
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline   Reply With Quote
Old 08-07-06, 04:02 PM   #10
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
OK, Here's V2.0. I think I have the lockup problem on pg 3 fixed. SSP, I got bounce from the email you gave me, so here is the new software. If anybody else wants to check it out for me as well, please do and give me feedback. There are test numbers in to chek the calc function and graphing, just replace them with your numbers as you come to them!

Edit: Disregard this, it still has problems, now it only opens in Read Only mode, so I pulled it again!
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant

Last edited by Tom Stormcrowe; 08-07-06 at 04:17 PM.
Tom Stormcrowe is offline   Reply With Quote
Old 08-08-06, 06:43 AM   #11
keith_b00ne
Senior Member
 
Join Date: Aug 2005
Bikes:
Posts: 52
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
The way that you have set Excel up to handle the data seems overly complicated for what you are trying to achieve. A simple form that you enter ride date, miles, and average speed is sufficient for excel to make a graph and summarize by month. Putting in every day of the year seems pointless and difficult to see the data.
keith_b00ne is offline   Reply With Quote
Old 08-08-06, 08:33 AM   #12
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by keith_b00ne
The way that you have set Excel up to handle the data seems overly complicated for what you are trying to achieve. A simple form that you enter ride date, miles, and average speed is sufficient for excel to make a graph and summarize by month. Putting in every day of the year seems pointless and difficult to see the data.
See the version im the ExcelV2.0 thread...It's a bit larger sizewise, but graphs on a monthly basis and the macros work. All you have to do is enter the ride data for the date and it will update to the appropriate graph.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline   Reply With Quote
Old 08-11-06, 07:37 AM   #13
brsboarder
Senior Member
 
Join Date: Jun 2006
Bikes:
Posts: 56
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
where can I find a link to the download?
brsboarder is offline   Reply With Quote
Old 08-11-06, 07:49 AM   #14
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Posts: 16,120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by brsboarder
where can I find a link to the download?
Here you go:

2006 file
2007 file

or here is the V2.0 thread I posted them in
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe 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 AM.