Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Training & Nutrition Learn how to develop a training schedule that's good for you. What should you eat and drink on your ride? Learn everything you need to know about training and nutrition here.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 12-12-05, 12:41 PM   #1
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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?
chimblysweep is offline   Reply With Quote
Old 12-12-05, 01:21 PM   #2
caadman
Senior Member
 
Join Date: Sep 2002
Location: Beverly hills Michigan
Bikes:
Posts: 486
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
caadman is offline   Reply With Quote
Old 12-12-05, 02:06 PM   #3
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
chimblysweep is offline   Reply With Quote
Old 12-12-05, 03:22 PM   #4
Wulfheir
Designated Drinker
 
Wulfheir's Avatar
 
Join Date: Oct 2004
Location: Calgary
Bikes: '04 Kona Fire Mountain
Posts: 800
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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
Wulfheir is offline   Reply With Quote
Old 12-12-05, 03:29 PM   #5
Machka 
In Real Life
 
Join Date: Jan 2003
Bikes:
Posts: 46,640
Mentioned: 22 Post(s)
Tagged: 0 Thread(s)
Quoted: 550 Post(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/
Machka is offline   Reply With Quote
Old 12-12-05, 03:30 PM   #6
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
that's very, very close! thanks so much!

as you can tell, i'm a luddite... and i really appreciate the help.
chimblysweep is offline   Reply With Quote
Old 12-12-05, 03:38 PM   #7
Wulfheir
Designated Drinker
 
Wulfheir's Avatar
 
Join Date: Oct 2004
Location: Calgary
Bikes: '04 Kona Fire Mountain
Posts: 800
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
My boss just gave me some work to do, I'll finish the calendar year later.
Wulfheir is offline   Reply With Quote
Old 12-14-05, 10:04 AM   #8
caadman
Senior Member
 
Join Date: Sep 2002
Location: Beverly hills Michigan
Bikes:
Posts: 486
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks very much chimblysweep!!

Benjamin
caadman is offline   Reply With Quote
Old 12-14-05, 07:57 PM   #9
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
SSP is offline   Reply With Quote
Old 12-15-05, 10:16 AM   #10
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
wulf - any chance you'll finish that chart??

thanks so much!
chimblysweep is offline   Reply With Quote
Old 12-15-05, 01:29 PM   #11
Tmax1
... .
 
Tmax1's Avatar
 
Join Date: Nov 2004
Location: ...out there.
Bikes: IF, Litespeed, Bianchi, Fisher, Dahon, Schwinn, Burley
Posts: 452
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Thanks for the chart Wulf!
Tmax1 is offline   Reply With Quote
Old 12-15-05, 02:41 PM   #12
Wulfheir
Designated Drinker
 
Wulfheir's Avatar
 
Join Date: Oct 2004
Location: Calgary
Bikes: '04 Kona Fire Mountain
Posts: 800
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
np.
if you have any additions/changes before the new year, let me know and i'll update it.
Wulfheir is offline   Reply With Quote
Old 12-20-05, 08:48 AM   #13
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
that's awesome. thanks so much!
chimblysweep is offline   Reply With Quote
Old 12-21-05, 10:01 AM   #14
khan
rider
 
Join Date: Dec 2005
Location: st.louis
Bikes:
Posts: 138
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Really appreciate the milage spreadsheet!

Thanks a bunch!
khan is offline   Reply With Quote
Old 01-02-06, 03:46 PM   #15
blueeyedme
Senior Member
 
Join Date: Sep 2005
Location: St. Petersburg, FL
Bikes: 02 Jamis Coda
Posts: 120
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
blueeyedme is offline   Reply With Quote
Old 01-03-06, 08:22 AM   #16
BloomBikeShop
BloomBikeShop.com
 
BloomBikeShop's Avatar
 
Join Date: Sep 2004
Location: East Coast
Bikes: A few.
Posts: 475
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(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
BloomBikeShop is offline   Reply With Quote
Old 01-03-06, 09:34 AM   #17
SSP
Software for Cyclists
 
SSP's Avatar
 
Join Date: Dec 2003
Location: Redding, California
Bikes: Trek 5200, Specialized MTB
Posts: 4,618
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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 ).
SSP is offline   Reply With Quote
Old 01-03-06, 12:51 PM   #18
chimblysweep
dc pirate, 4evah.
Thread Starter
 
chimblysweep's Avatar
 
Join Date: Sep 2004
Location: seattle
Bikes: several. blue. fun.
Posts: 3,193
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(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.
chimblysweep is offline   Reply With Quote
Old 01-04-06, 06:28 PM   #19
BloomBikeShop
BloomBikeShop.com
 
BloomBikeShop's Avatar
 
Join Date: Sep 2004
Location: East Coast
Bikes: A few.
Posts: 475
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Quote:
Originally Posted by SSP
I've looked at your Access database, and have a few recommendations:.
Thanks for the help!!
BloomBikeShop is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 10:53 PM.