Free Excel Template for Training
08-06-06, 07:12 AM
#1
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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.
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
. “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.
08-06-06, 07:48 AM
#2
370H-SSV-0773H
Join Date: May 2005
Location: Penniless Park, Fla.
Posts: 2,750
Bikes: Merlin Fortius, Specialized Crossroads & Rockhopper, Serotta Fierte, Pedal Force RS2
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
- 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!
(will give a try under Oo 2.X under KANOTIX64 w/a 2.6.13 kernel)
- hope others will contribute in this sticky!
08-06-06, 04:06 PM
#3
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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!
(will give a try under Oo 2.X under KANOTIX64 w/a 2.6.13 kernel)
- hope others will contribute in this sticky!
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
. “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.
08-06-06, 10:15 PM
#4
Software for Cyclists
Join Date: Dec 2003
Location: Redding, California
Posts: 4,618
Bikes: Trek 5200, Specialized MTB
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
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.
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.
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.
08-07-06, 03:20 AM
#5
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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.
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.
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
. “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
08-07-06, 07:22 AM
#6
Software for Cyclists
Join Date: Dec 2003
Location: Redding, California
Posts: 4,618
Bikes: Trek 5200, Specialized MTB
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
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).
08-07-06, 09:13 AM
#7
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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).
-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
. “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
08-07-06, 11:05 AM
#8
Software for Cyclists
Join Date: Dec 2003
Location: Redding, California
Posts: 4,618
Bikes: Trek 5200, Specialized MTB
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
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
-Tom
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).
08-07-06, 03:46 PM
#9
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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).
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'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
. “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
08-07-06, 04:02 PM
#10
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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!
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
. “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.
08-08-06, 06:43 AM
#11
Senior Member
Join Date: Aug 2005
Posts: 58
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
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.
08-08-06, 08:33 AM
#12
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
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.
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
. “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
08-11-06, 07:49 AM
#14
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Thread Starter
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times
in
17 Posts
Originally Posted by brsboarder
where can I find a link to the download?
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
. “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
