Advertise on Bikeforums.net



User Tag List

Results 1 to 19 of 19
  1. #1
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    2006 mileage chart

    sorry to jump the gun by two weeks, but rather now than too late...

    i have a 2005 excel spreadsheet that does all the tabulating and such for me, and I went back to the website i got it from last year, and they're using a PDF this year instead... which means I have to do the adding.

    i'm way too non-mathematical for that.

    does anyone know where there's a 2006 mileage chart in .xls or the equivalent?

  2. #2
    Senior Member
    Join Date
    Sep 2002
    Location
    Beverly hills Michigan
    Posts
    486
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    chimblysweep, do you have that website, I'd like to take a look at the chart. I need one for 06 also!

    Thanks,
    Benjamin

  3. #3
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The Potomac Pedalers have the pdf (it was an xls last year!):
    http://www.bikepptc.org/
    Direct to the pdf:
    http://www.bikepptc.org/pptc2006.pdf

  4. #4
    Designated Drinker Wulfheir's Avatar
    Join Date
    Oct 2004
    Location
    Calgary
    My Bikes
    '04 Kona Fire Mountain
    Posts
    800
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I made this spreadsheet just now, for the first 6 months of '06.
    Does is work sorta like your old one? Wanna suggest any changes/additions?

    http://www.wulfheir.com/BF2006MileageChart.xls
    My Bike Journal Profile

    Oh, you hate your job? There's a support group for that, it's called EVERYONE and they meet at the PUB!

  5. #5
    Long Distance Cyclist Machka's Avatar
    Join Date
    Jan 2003
    Location
    I ride where the thylacine roamed!
    My Bikes
    Lots
    Posts
    36,703
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    I created my own Excel spreadsheet for my miles and other information. Once you create it with all the forumlas and everything you need, you don't have to do any more adding etc. ... the program does it all for you.

    But I also use bike journal: http://www.bikejournal.com/

  6. #6
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    that's very, very close! thanks so much!

    as you can tell, i'm a luddite... and i really appreciate the help.

  7. #7
    Designated Drinker Wulfheir's Avatar
    Join Date
    Oct 2004
    Location
    Calgary
    My Bikes
    '04 Kona Fire Mountain
    Posts
    800
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My boss just gave me some work to do, I'll finish the calendar year later.
    My Bike Journal Profile

    Oh, you hate your job? There's a support group for that, it's called EVERYONE and they meet at the PUB!

  8. #8
    Senior Member
    Join Date
    Sep 2002
    Location
    Beverly hills Michigan
    Posts
    486
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks very much chimblysweep!!

    Benjamin

  9. #9
    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)
    It's not free, but I like CycliStats...however, as the developer of it, I'm 100% biased .

    It does much more than a spreadsheet (including tracking of maintenance, health, goals, cycling specific tools, etc.), is easier to use, and comes with a bunch of built-in reports and graphs.

    If you're interested, you can download a free 30-day trial version from the website to see if it meets your needs.
    CycliStats.com - Software for Cyclists
    WeightWare.com - Weight Management Software

  10. #10
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wulf - any chance you'll finish that chart??

    thanks so much!

  11. #11
    ... . Tmax1's Avatar
    Join Date
    Nov 2004
    Location
    ...out there.
    My Bikes
    IF, Litespeed, Bianchi, Fisher, Dahon, Schwinn, Burley
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the chart Wulf!

  12. #12
    Designated Drinker Wulfheir's Avatar
    Join Date
    Oct 2004
    Location
    Calgary
    My Bikes
    '04 Kona Fire Mountain
    Posts
    800
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    np.
    if you have any additions/changes before the new year, let me know and i'll update it.
    My Bike Journal Profile

    Oh, you hate your job? There's a support group for that, it's called EVERYONE and they meet at the PUB!

  13. #13
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    that's awesome. thanks so much!

  14. #14
    rider
    Join Date
    Dec 2005
    Location
    st.louis
    Posts
    138
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Really appreciate the milage spreadsheet!

    Thanks a bunch!

  15. #15
    Senior Member
    Join Date
    Sep 2005
    Location
    St. Petersburg, FL
    My Bikes
    02 Jamis Coda
    Posts
    119
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey thanks for the spreadsheet! I noted that it is locked. I would like to add some health stats to the sheet - weight, BP, RHR. Could you PM me the unlock code? Thanks.

  16. #16
    BloomBikeShop.com BloomBikeShop's Avatar
    Join Date
    Sep 2004
    Location
    East Coast
    My Bikes
    Trek 1500, Giant XTC SE2, S&M Warpig, KHE Premium Lagger, Trek 800, a couple old Raleighs, an old Road Runner, etc.
    Posts
    454
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have stuff in Excel and Access. My Access system is new for 06 and does a lot more than my old .xls, as far as reports on mileage, etc.

    All for free...

    http://coachlevi.com/articles/traininglogsystem.htm

  17. #17
    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 BloomBikeShop
    I have stuff in Excel and Access. My Access system is new for 06 and does a lot more than my old .xls, as far as reports on mileage, etc.

    All for free...

    http://coachlevi.com/articles/traininglogsystem.htm
    I've looked at your Access database, and have a few recommendations:

    1) You'll definitely need to modify your "Rides" table, to permit non-integer ride distance (your "Mileage" column). As it currently exists, you can't enter something like "21.4" miles...only "21" or "22".

    2) You need a ride time field. Currently, "Elapsed Time" is defined as a 50 character text field...this means it won't be possible to produce summaries for riding time, or calculate average speed.

    3) It would be useful to allow ride entries to include a Bike, so that one can view summaries by bike (i.e., road vs. mountain bike).

    4) Notes - the notes fields are far too short (for instance, the 100 character limit for "Noteworthy News").

    Sorry if I sound overly critical, but I'm a professional software developer and database analyst. Best of luck with your project...it's always better to use something you love as a learning exercise (but don't be surprised to find that it takes a LOT of time to get it right ).
    CycliStats.com - Software for Cyclists
    WeightWare.com - Weight Management Software

  18. #18
    dc pirate, 4evah. chimblysweep's Avatar
    Join Date
    Sep 2004
    Location
    seattle
    My Bikes
    several. blue. fun.
    Posts
    3,195
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The Potomac Pedalers chart is now available:
    http://www.pankin.com/miles.htm

    Honestly, though, I'm sticking with WulfHeir's. I'm sick of the week starting on Monday in the PPTC one - I like my mileage weeks to start on Sunday.

  19. #19
    BloomBikeShop.com BloomBikeShop's Avatar
    Join Date
    Sep 2004
    Location
    East Coast
    My Bikes
    Trek 1500, Giant XTC SE2, S&M Warpig, KHE Premium Lagger, Trek 800, a couple old Raleighs, an old Road Runner, etc.
    Posts
    454
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by SSP
    I've looked at your Access database, and have a few recommendations:.
    Thanks for the help!!

Posting Permissions

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