Advertise on Bikeforums.net



User Tag List

Results 1 to 14 of 14
  1. #1
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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.
    Last edited by Tom Stormcrowe; 08-07-06 at 05:15 PM.
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  2. #2
    370H-SSV-0773H linux_author's Avatar
    Join Date
    May 2005
    Location
    Penniless Park, Fla.
    My Bikes
    Merlin Fortius, Specialized Crossroads & Rockhopper, Serotta Fierte, Pedal Force RS2
    Posts
    2,760
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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!

  3. #3
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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?
    Last edited by Tom Stormcrowe; 08-06-06 at 05:54 PM.
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  4. #4
    SSP
    SSP is offline
    Software for Cyclists SSP's Avatar
    Join Date
    Dec 2003
    Location
    Redding, California
    My Bikes
    Trek 5200, Specialized MTB
    Posts
    4,618
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.
    CycliStats.com - Software for Cyclists
    WeightWare.com - Weight Management Software

  5. #5
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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.
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  6. #6
    SSP
    SSP is offline
    Software for Cyclists SSP's Avatar
    Join Date
    Dec 2003
    Location
    Redding, California
    My Bikes
    Trek 5200, Specialized MTB
    Posts
    4,618
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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).
    CycliStats.com - Software for Cyclists
    WeightWare.com - Weight Management Software

  7. #7
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  8. #8
    SSP
    SSP is offline
    Software for Cyclists SSP's Avatar
    Join Date
    Dec 2003
    Location
    Redding, California
    My Bikes
    Trek 5200, Specialized MTB
    Posts
    4,618
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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).
    CycliStats.com - Software for Cyclists
    WeightWare.com - Weight Management Software

  9. #9
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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!
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  10. #10
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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!
    Last edited by Tom Stormcrowe; 08-07-06 at 05:17 PM.
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  11. #11
    Senior Member
    Join Date
    Aug 2005
    Posts
    52
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  12. #12
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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.
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

  13. #13
    Senior Member
    Join Date
    Jun 2006
    Posts
    56
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    where can I find a link to the download?

  14. #14
    The Site Administrator: Currently at home recovering from a couple of strokes,please contact my assistnt admins for forum issues Tom Stormcrowe's Avatar
    Join Date
    Mar 2006
    Location
    South Florida
    My Bikes
    Techna Wheelchair and a Sun EZ 3 Recumbent Trike
    Posts
    16,160
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(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
    on light duty due to illness; please contact my assistants for forum issues. They are Siu Blue Wind, or CbadRider or the other 3 star folk. I am currently at home recovering from a couple of strokes. I am making good progress, happily.


    . “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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •