Tracking mileage in a big, nerdy spreadsheet

One of my New Year's resolutions is to track my mileage and try to reach 5,000 miles by 2011. I've got a spreadsheet and I'll be tweaking it as I go along, adding new features. Has anyone already done this? Maybe we could work on one together as a forum, because I'm sure lots of people would find it useful.

At the moment mine's just a list of dates for the whole year and three columns for my three bikes, but I'd like automagically-generated graphs for monthly totals, broken down by bike, and maybe some macros to hide all the messy stuff.

Waddya reckon? Spreadsheet nerds of the forum, unite!

This was my resolution last year. This year its to not have a computer on any bicycle I own!

and the point would be?

Garmin.

To stop obsessing

and the point would be?

The point of tracking mileage? A training tool, for motivation, to see which bikes I actually ride most, which seasons I ride most, to set and hopefully reach a target and feel good about it....

Oops, posted in the other thread.

100 miles a week should be easy. Especially if you commute by bike.

My commute in the winter is 6 miles, summer 50. It's more to do with keeping up the mileage. Not a crazy target, should be fine.

aim for a 100 miles a day for the HTFU factor.

Sweet this sounds like a good idea.

If you wanted to track it as a group pretty sure you can use google spreadsheets then make it public so that everyone can have access.

If not I can easily set all this up in excel as I work with it everyday of the week at work.

I should imagine that I will hit around 2.5 3k this year. 500 Mile tour in june.

Garmin 705 + SportsTracks
nearly all done for you
2009
7493 km
34,034 m of ascent
1,142,109 kJ

One of my New Year's resolutions is to track my mileage and try to reach 5,000 miles by 2011. I've got a spreadsheet and I'll be tweaking it as I go along, adding new features. Has anyone already done this? Maybe we could work on one together as a forum, because I'm sure lots of people would find it useful.

At the moment mine's just a list of dates for the whole year and three columns for my three bikes, but I'd like automagically-generated graphs for monthly totals, broken down by bike, and maybe some macros to hide all the messy stuff.

Waddya reckon? Spreadsheet nerds of the forum, unite!

good idea.

i would participate.

Garmin 705 + SportsTracks
nearly all done for you
2009
7493 km
34,034 m of ascent
1,142,109 kJ

I'd take the Garmin ascent figures with a pinch of salt, and the energy consumption is about double the true figure. With those caveats, my 2009 totals on the Edge305 are

56 hours on the rollers?! You definitely need to get out more. :P

One doesn't achieve a 75.9mph top speed by going out!

This is the basis of mine..

Date:
Time:
Location:
Pie Type:
Pie Size:
Pie Quantity:

Not taking gravy into account? These things have to be taken seriously

You have gravy on your apple pie?

Custard is just a different flavour of gravy :-)

Custard shall never taint an apple pie of mine..

I'd take the Garmin ascent figures with a pinch of salt, and the energy consumption is about double the true figure.

I ignore the Kj, as I don't keep track of the food I eat,
pretty happy with the ascent figures though. I correct any 'spikes' but these are very rare.

pretty happy with the ascent figures though.

I'm "pretty happy" with the ascent figures, as they make it look as though I've done much more climbing than I really have, but I'm sure I didn't climb 18,000' on the rollers last year, because I live in a flat! I'm using the Garmin 305 with Garmin's own software, so there is no facility to do corrections like I could with the Polar. Maybe they've fixed the 305's altimeter problems in the 705?

I'm sure I didn't climb 18,000' on the rollers last year, because I live in a flat!

The front roller must be bigger than the rear one, then. ;)

I think some of the GPS satellites must be on a wobbly orbit...

The altimeter is barometric, which is a good idea as GPS is rubbish for establishing altitude to high precision, but of course a barometric altimeter is affected by weather. The Garmin calibrates the barometric altimeter (which can be out by hundreds of feet depending on the weather system in place over you, but has good accuracy for high resolution measurement as long as the weather doesn't change) against the GPS altitude (which will only ever be reliable to about +/- 50', but is unaffected by weather) over the first half hour or so after booting up, so you can "climb" or "descend" up to 300' without moving.