Excel spreadsheet?

  • Posted by a hidden member.
    Log in to view his profile

    May 24, 2008 6:35 PM GMT
    Does anyone have an excel spreadsheet that they could mail me for a cycle log?
  • Posted by a hidden member.
    Log in to view his profile

    May 25, 2008 3:46 AM GMT
    LutherGooch saidDoes anyone have an excel spreadsheet

    Uh, if you have Excel, you can make your own. If you don't have Excel, you can use other free spreadsheet programs out there, like Open Office.

    Do you mean create a printed log and (post) mail to you, or e-mail?
  • Posted by a hidden member.
    Log in to view his profile

    May 25, 2008 4:20 AM GMT
    i think he means an excel spreadsheet already made
  • Tritimium

    Posts: 261

    May 25, 2008 5:44 PM GMT
    Here's what I do - dunno if this is helpful:

    Back in March I planned what races I was going to do, and then worked back from the race dates to get sensible progression in terms of distance and the times I wanted to aim for. I then incorporated those weekly goal/distance targets into my weekly workout schedule. On a Sunday evening I print out my workouts for the week ahead - they're all Excel spreadsheets, and yes, it's paper-intensive - and then take each day's sheets with me to the gym/swimming pool (suitably waterproofed!)/running track and write what I actually do as I go along. I usually record reps, distance, time (effort and recovery), heart rate, details for free weights, etc., as appropriate. I then put them into a larger folder at the end of the day, and will, at some point, put the data back into Excel and try to draw some meaningful information from it all.

    Obviously it would be trickier to do this cycling out in the open (as opposed to a turbo, as I often do), but it could be afterwards.

    I could email examples of my spreadsheets, but to be honest, each person's needs are so individual that a log is probably best made by themselves anyway, and it doesn't take long. But you're welcome to look at mine.

    I believe there are some logs that are available to download for free, others cost money.

    Also, have you had a look at the Tacx website? There's a really good coaching section on there (tailored for their turbos, but useful anyway).
  • Posted by a hidden member.
    Log in to view his profile

    Jun 10, 2008 9:55 AM GMT
    I finally got a friend to make the excel spreadsheet, and we have a log book. At the moment we keep up the log book and transfer our computer (cycle) info to the log. We are working on % of lose and gains and grades of elevations for the spreaksheet.
  • Posted by a hidden member.
    Log in to view his profile

    Jun 10, 2008 5:41 PM GMT
    I have a garmin edge 705, and am using that to collect my training data. I agree that each person's needs are different, which is probably why I don't like the garmin connect (inmotion) site. So, being a geek, I made my own.

    You can look at my training data here:
    http://www.pink-triangle.org/scott/biking/
    by clicking on the 2008 rides. This site is still a work in progress. I want to add some graphic visualization for the data, work on an automatic upload, and perhaps have a way to visualize each ride (or sets of rides).

    If you're geeky enough to wonder what is powering the site, it's running on the Google maps api, spreadsheet api and soon visualization api.

  • Posted by a hidden member.
    Log in to view his profile

    Jun 10, 2008 8:04 PM GMT
    I love the site man! Thanks.
  • Posted by a hidden member.
    Log in to view his profile

    Jun 11, 2008 12:39 AM GMT
    There are a couple free or inexpensive ($20/year) websites for tracking cycling (and/or some other activities)

    BikeJournal.com
    Allows you to configure what data you want to record, with up to 30 different bits of data. Basic (free) membership includes 6 columns of data. Premier ($20/year) allows you to include more data, but also allows you to make your rider profile and or ride journal public for others on the site or external to view:
    My profile:
    http://www.bikejournal.com/profiles.asp?rname=DAGAUS190&public=1
    My journal:
    http://www.bikejournal.com/journal_public.asp?rname=DAGAUS190

    Your journal data can be exported to a .csv file one year at a time, and if you have an Excel file, with Premier membership that data can be imported by the administrator to get your ride journal up to date.

    WeEndure.com
    Is similar, free or $20/year, but with fewer data fields, but you can log running or swimming.
    http://weendure.com/user/dagaus

    Data can be imported by the administrator to get your ride journal up to date here also.



  • Posted by a hidden member.
    Log in to view his profile

    Jun 11, 2008 1:13 AM GMT
    Thanks a million Dagaus190. That was very useful info!!!!