Advertise on Bikeforums.net



User Tag List

Results 1 to 21 of 21
  1. #1
    Don't Taunt Happyfunball cyclochica's Avatar
    Join Date
    Aug 2002
    Location
    Northern Virginia
    My Bikes
    2005 Kona Jake the Snake, Fuji Club SE
    Posts
    589
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  2. #2
    hehe...He said "member" ChipRGW's Avatar
    Join Date
    Aug 2002
    Location
    Fort Lauderdale, FLA
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  3. #3
    Don't Taunt Happyfunball cyclochica's Avatar
    Join Date
    Aug 2002
    Location
    Northern Virginia
    My Bikes
    2005 Kona Jake the Snake, Fuji Club SE
    Posts
    589
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Chip. I need a backup system if Bike Pro Log never comes back up.
    There can be only one.

  4. #4
    Bike for life.
    Join Date
    Apr 2003
    Location
    The Silver Comet Trail
    My Bikes
    KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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
    Ted Davis John 3:16
    KHS Alite 1000 MTB
    Bianchi Campione - a really sweet bike

  5. #5
    Junior Member
    Join Date
    May 2003
    Location
    Arlington, Va.
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    cyclochica, are you racing in the northern Va area?
    max out or black out

  6. #6
    Don't Taunt Happyfunball cyclochica's Avatar
    Join Date
    Aug 2002
    Location
    Northern Virginia
    My Bikes
    2005 Kona Jake the Snake, Fuji Club SE
    Posts
    589
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  7. #7
    Senior Member trmcgeehan's Avatar
    Join Date
    Oct 2002
    Location
    Somerset, KY -- near Lake Cumberland
    My Bikes
    1980 Univega; 1985 Ross; 1994 Trek 1400 -- all road bikes
    Posts
    757
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  8. #8
    www.activebody.org
    Join Date
    Apr 2002
    Location
    Madison, WI
    My 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)
    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

  9. #9
    Newbie
    Join Date
    Jun 2003
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try www.crosstrack.com they have a free version that seems to capture most everything...

  10. #10
    www.activebody.org
    Join Date
    Apr 2002
    Location
    Madison, WI
    My 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)
    Not sure why my url got goofed... but this should work


    www.activebody.org

  11. #11
    Member memphisjim's Avatar
    Join Date
    Aug 2002
    Location
    Memphis
    My Bikes
    Trek 2300
    Posts
    44
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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

  12. #12
    On Your Right ZackJones's Avatar
    Join Date
    Mar 2003
    Location
    Warner Robins, GA
    Posts
    1,422
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    memphisjim: would you mind emailing me the full version. Thanks!

    Zack
    "You never fail, you simply produce results. Learn from these" - Anonymous

  13. #13
    Member memphisjim's Avatar
    Join Date
    Aug 2002
    Location
    Memphis
    My Bikes
    Trek 2300
    Posts
    44
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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

  14. #14
    On Your Right ZackJones's Avatar
    Join Date
    Mar 2003
    Location
    Warner Robins, GA
    Posts
    1,422
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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

  15. #15
    Don't Taunt Happyfunball cyclochica's Avatar
    Join Date
    Aug 2002
    Location
    Northern Virginia
    My Bikes
    2005 Kona Jake the Snake, Fuji Club SE
    Posts
    589
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for all the suggestions.

    Memphisjim, the chart looks great. Thanks so much.
    There can be only one.

  16. #16
    Senior Member fujibike's Avatar
    Join Date
    May 2003
    Location
    Delaware
    Posts
    369
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.

  17. #17
    Guest
    Guest
    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....

  18. #18
    Senior Member Bobatin's Avatar
    Join Date
    Oct 2002
    Location
    Newnan, GA
    Posts
    402
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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 04:37 AM.
    So, if you're in the car, waiting impatiently. . . get over it - you're not that special.
    "Its not what you take when you leave, Its what you leave when you go."
    Some country and western song

  19. #19
    Bike for life.
    Join Date
    Apr 2003
    Location
    The Silver Comet Trail
    My Bikes
    KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
    Posts
    370
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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!
    Ted Davis John 3:16
    KHS Alite 1000 MTB
    Bianchi Campione - a really sweet bike

  20. #20
    Carpe Diem bdcheung's Avatar
    Join Date
    Sep 2006
    Location
    MABRA
    My Bikes
    2007 CAAD9; 2008 Giant Bowery; 2008 Surly Crosscheck
    Posts
    13,135
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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!

  21. #21
    BloomBikeShop.com BloomBikeShop's Avatar
    Join Date
    Sep 2004
    Location
    East Coast
    My Bikes
    A few.
    Posts
    457
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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

Posting Permissions

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