Author Topic: Spreadsheet for recording miles  (Read 2633 times)

Wowbagger

  • Dez's butler
    • Musings of a Gentleman Cyclist
Spreadsheet for recording miles
« on: December 31, 2012, 11:16:31 pm »
Chris S mentioned using a spreadsheet, designed by the Queen of such things, for logging his miles in 2013.

I have set up a spreadsheet which, for me, is quite a good effort, but I'm sure pales into insignificance compared to what a real proper spreadsheet user could do.

Does anyone else use a spreadsheet to log miles?
Oh, Bach without any doubt. Bach every time for me.

fboab

  • It's a fecking serious business, riding a bike
Re: Spreadsheet for recording miles
« Reply #1 on: January 01, 2013, 05:52:06 am »
Mine is for recording kilometres.

It also gives me all sorts of stats-
Targets, weight (loss if there was any), planning, what-if scenarios, will give me month-by-month totals, separates by ride type and by machine.
And is beautiful.

It has grown, somewhat, over the years. I've been doing it since I offset the rent increase of moving to my current abode by riding to work, back in 2008. It doesn't, currently, record speeds, but knowing that Chris likes to know such things, I'll probably add that to his page.
TSS is not Total Sex Score, Chris!

LindaG

Re: Spreadsheet for recording miles
« Reply #2 on: January 01, 2013, 06:48:29 am »
Awww, can't you share the joy boabacca?  Some of us are still on fountain pens and rulers y'know

Re: Spreadsheet for recording miles
« Reply #3 on: January 01, 2013, 06:55:48 am »
I've been using a simple on for a few years.Fields are date, miles, km, and details. Plus at the top daily average and total distance.

Re: Spreadsheet for recording miles
« Reply #4 on: January 01, 2013, 09:07:39 am »
Mine counts miles, trips out and shopping by bike

Wowbagger

  • Dez's butler
    • Musings of a Gentleman Cyclist
Re: Spreadsheet for recording miles
« Reply #5 on: January 01, 2013, 09:27:48 am »
Mine records the daily miles and ride time and adds them together to show monthly and annual totals for time, miles, ave and max speed. I don't know how to do separate totals by bike ridden short of sett up a different sheet for each bike.
Oh, Bach without any doubt. Bach every time for me.

robgul

  • HoECC & Cycle:End-to-End webmaster, S Warwickshire Bike Shop in Wellesbourne
  • . . cyclist, Cytech accredited, manages an LBS
    • Cycle:End-to-End
Re: Spreadsheet for recording miles
« Reply #6 on: January 01, 2013, 10:44:19 am »
Having missed a few years of recording mileage I went back to doing so for 2012 - with nothing more than a spreadsheet that records :

 Date - Brief description/destination - Bike used (a column for each .. 10!) - distance - Notes - e.g extreme weather or mechanicals

... and then a row of column total.   The header line is locked for the rest of the sheet to scroll on the screen.

That's it - I do a manual sum each month and a running annual total that also averages the miles done on an annual basis, per week. Simple, but it works for me.

As I now have a Garmin Edge gadget I might store a bit more data .. but I'm not really interested in much beyond the distance - the thing the Garmin will be used for is to capture routes/tracks as the club is starting to create a library of rides to help new ride leaders - the library is based on the pubs we use for lunch!

Rob


Re: Spreadsheet for recording miles
« Reply #7 on: January 01, 2013, 03:20:19 pm »
Anybody else use this?
http://www.prologcycling.com/home.html
Cost is $15 (£9.60) for this year, and it's pretty good IMO. Been using it for the last four or five years.
Tracks pretty much everything you might want to if you don't have a power meter.
Steve
The dog did nothing in the night-time - that was the curious incident..........

Jaded

  • The Codfather
  • Formerly known as Jaded
Re: Spreadsheet for recording miles
« Reply #8 on: January 01, 2013, 03:55:33 pm »
I write a database in Filemaker Pro to do mine. The advantage is that it is flexible, and there is data integrity built in. Spreadsheets can go horribly wrong with an intemperate sort.
If you don't like your democracy, vote against it.

Re: Spreadsheet for recording miles
« Reply #9 on: January 01, 2013, 04:05:35 pm »
I made a simple xl spreadsheet for my mileage:

fboab

  • It's a fecking serious business, riding a bike
Re: Spreadsheet for recording miles
« Reply #10 on: January 01, 2013, 09:49:04 pm »
Mine records the daily miles and ride time and adds them together to show monthly and annual totals for time, miles, ave and max speed. I don't know how to do separate totals by bike ridden short of sett up a different sheet for each bike.
If you add a column for bike, you can do either SUMIF or a VLOOKUP or a pivot table. (In excel, but I'm sure there are equivalents in whatever you use if you don't use excel).
Awww, can't you share the joy boabacca?  Some of us are still on fountain pens and rulers y'know
(click to show/hide)
TSS is not Total Sex Score, Chris!

Manotea

  • Where there is doubt...
Re: Spreadsheet for recording miles
« Reply #11 on: January 01, 2013, 10:00:32 pm »
(click to show/hide)

I really do think there should be a health warning on the clicking of that button!

fboab

  • It's a fecking serious business, riding a bike
Re: Spreadsheet for recording miles
« Reply #12 on: January 01, 2013, 10:04:28 pm »
 ;D

I know, I am a saddo statto...
TSS is not Total Sex Score, Chris!

Re: Spreadsheet for recording miles
« Reply #13 on: January 01, 2013, 10:20:44 pm »
I only managed to record mileages consistently once I got a bike computer (Garmin) that uploads the data painlessly without having to remember stuff or type it it manually. I upload it into Ascent (Mac-only: http://www.montebellosoftware.com); I can't really recommend this software since it costs £27 and isn't being actively developed anymore, but it allows all the data fields to be exported in spreadsheet formats for any kind of trend analysis or pretty presentation that it can't do itself.

Or if you're truly sad you can load the spreadsheet data into a graphing program like DataGraph and make elaborate plots like this:


Cycling data graphs by mrkwr, on Flickr

Re: Spreadsheet for recording miles
« Reply #14 on: January 01, 2013, 10:24:47 pm »
Good work, Boab.

But how come "Fun" is -22.1?  :o

Re: Spreadsheet for recording miles
« Reply #15 on: January 01, 2013, 10:41:41 pm »
Good work, Boab.

But how come "Fun" is -22.1?  :o

(sings)

Deano found a bug... Deano found a bug...

 ;D

fboab

  • It's a fecking serious business, riding a bike
Re: Spreadsheet for recording miles
« Reply #16 on: January 01, 2013, 10:47:43 pm »
Good work, Boab.

But how come "Fun" is -22.1?  :o

(sings)

Deano found a bug... Deano found a bug...

 ;D
Acksherley I spotted it and CBA to change the picture. I forgot to tell it I was on holiday over Christmas.  :facepalm:
TSS is not Total Sex Score, Chris!

Wowbagger

  • Dez's butler
    • Musings of a Gentleman Cyclist
Re: Spreadsheet for recording miles
« Reply #17 on: January 01, 2013, 11:17:34 pm »
Mine records the daily miles and ride time and adds them together to show monthly and annual totals for time, miles, ave and max speed. I don't know how to do separate totals by bike ridden short of sett up a different sheet for each bike.
If you add a column for bike, you can do either SUMIF or a VLOOKUP or a pivot table. (In excel, but I'm sure there are equivalents in whatever you use if you don't use excel).
Thank you! That works.  :thumbsup:
Oh, Bach without any doubt. Bach every time for me.

Re: Spreadsheet for recording miles
« Reply #18 on: January 02, 2013, 12:26:12 pm »
Good work, Boab.

But how come "Fun" is -22.1?  :o

(sings)

Deano found a bug... Deano found a bug...

 ;D
Acksherley I spotted it and CBA to change the picture. I forgot to tell it I was on holiday over Christmas.  :facepalm:

I'm just relieved that fun hasn't been cancelled for 2013.

vorsprung

  • Opposites Attract
    • Audaxing
Re: Spreadsheet for recording miles
« Reply #19 on: January 02, 2013, 01:09:54 pm »
Audaxing Blog follow @vorsprungbike on

LEE

Re: Spreadsheet for recording miles
« Reply #20 on: January 02, 2013, 01:45:50 pm »
Mine records the daily miles and ride time and adds them together to show monthly and annual totals for time, miles, ave and max speed. I don't know how to do separate totals by bike ridden short of sett up a different sheet for each bike.

Be careful doing this.

I did it a while back and it highlighted how very little I ride some of my bikes.  My Mountain Bike for example, could be reclassified as a wall hanging.

It could lead to N-1 (which nobody wants)

Wowbagger

  • Dez's butler
    • Musings of a Gentleman Cyclist
Re: Spreadsheet for recording miles
« Reply #21 on: January 02, 2013, 01:50:08 pm »
I really only have 3 active bikes. There is also a Brompton which I tend to ride only in emergencies but which Dez uses. All of my bikes see reasonable use. I suspect that the Mercian, now it is a single speed, will become my main pootling/social ride bike. The Thorn is the shopping/touring/work bike because it carries loads, and the tandem is Mrs. Wow's personal sedan chair.
Oh, Bach without any doubt. Bach every time for me.

Re: Spreadsheet for recording miles
« Reply #22 on: January 02, 2013, 01:55:55 pm »
the tandem is Mrs. Wow's personal sedan chair.

 ;D

clarion

  • Tyke
Re: Spreadsheet for recording miles
« Reply #23 on: January 02, 2013, 02:03:57 pm »
Bike usage might deserve a new thread.  Hold on a minute...

ETA: Here's a thread with more detail than you could ever have wished
Getting there...

Re: Spreadsheet for recording miles
« Reply #24 on: January 02, 2013, 02:17:03 pm »
I enter the following into each of 12 monthly worksheets, with new spreadsheets each year: moving time, distance, altitude gain, bike (one of two), ride type (primarily audax, commute or other), ride (brief description of route).  And one worksheet where I just enter miles by the week.  From all of that I have other spreadsheets which show a variety of useless information such as monthly/weekly/annual stats according to ride type, bike type etc.  So I can see that 2% of rides in 2012 were Audax, but that they accounted for 16% of annual distance and 12% of climbing.  Or I could compare my average speed on the Thorn with that on the Sabbath, over the year, for a given month or ride type. Or which my best week was in terms of distance. Or what my average daily commute distance is by month.  Or my longest ride on a Thursday.  Or current Furlongs per Fortnight. I did flirt with cadence and heart rate for while, but they were a step too far for me. I could show you a variety of graphs as well.

I know I have a problem, but as vices go it’s a harmless one and takes very little time.  What I am particularly inept at is recording useful information such as tyre and other component use.  On the plus side, I’m the go-to guy for Excel queries at work.