In the Google Docs spreadsheet I created, there is a tab for 2014 mileage, and also I've gone ahead and created the 2015 tab as well with links between the tabs so that the previous year and previous best columns are auto populated beginning with 2015. It is fairly easy to create a new tab for each year. There are a handful of functions to either move from one cell to another, or to update. The demarcation between months was done by using thick borders in the Excel version, but on the Google Docs version I've used shading. Either works, but for each new tab I'll need to edit the shading for each month first (as Mark did with the borders).
The enhancements I've made include the table and chart of average weekly mileage at the bottom of the document, as well as some automatic shading in column A, the current monthly totals column.
I retain all rights to the document. You are free to make personal use of a copy of the document. No commercial use of this is allowed without permission.
Below are some details about the document and how to use it.
The Google Docs Spreadsheet is presented in view mode to anyone with the link. You can copy the document to your own Google Docs and begin test driving it. You only need to add your daily mileage under the appropriate dates (except columns C and D on the '2014' tab where you'll enter some historical data if you have it). All the rest is automatic.
Take a look at the two tabs, '2014' and '2015', that come with the initial version of the document. Both tabs will initially have all the formulas and functions active, but no data has been entered. On the '2014' tab, find cell H4 (this is where your mileage for January 1, 2014 would go), and enter the value 52 there. Note that not only did the contents of that cell change, but also all of the following:
- the weekly total for that week (cell M4)
- the running totals for the year (columns N and X)
- cells A7, A8 (current month's tally and # of rides)
- values in column B (cumulative miles)
Please feel free to comment. Thanks.