2022 Mileage Tracking Spreadsheet

I developed this spreadsheet to track my bicycling mileage for the year. It has some neat features such as automatic computation and totaling of weekly, monthly and cumulative miles and number of rides for the month and year to date. There is also a graph showing cumulative mileage for the year and your goal if you provide one. Some of the totals do not appear until their time comes, so don't worry if you enter "future miles" to test the spreadsheet and do not see all the totals you might expect.

Some notes and pointers:

  1. In newer versions of Excel, the file may open in PROTECTED VIEW, which will prevent entering data. Click on the Enable Editing box to remove the restriction.
  2. It is a good idea to make a backup of copy just in case you mess up something.
  3. Enter your mileage for the day under the date. These are the only values you need to enter.
  4. Do not enter weekly, monthly, or cumulative totals since these are calculated automatically.
  5. If you want to compare 2022 to how you did last year and your highest year, you can enter your 2021 monthly mileage and best months ever in columns C and D. The entries may be anywhere within the box for each month. The 2021 total will be computed automatically. Enter your best annual total if you want to see it on the spreadsheet.
  6. Some of the formulas are very complicated. Do not try to change them unless you really know what you are doing. If you mess one up, either close the spreadsheet without saving the current file or copy the formula from the backup copy of the original blank spreadsheet. (No backup copy, then download it again from here and make one this time, but be careful about the file names.)
  7. The print setup has been set to print on one page in landscape mode. This may not work well or at all with some printers. If so, you may need to adjust the print setup, which can be done by choosing Print Preview from the file menu and then clicking on the "Setup..." button.
  8. The file is in Excel 2003 format. If you can't read the file with your spreadsheet program, let me know what program and version you have, and I'll try to make a file that your program can read. However, some of the features may not work, so you'll have to supply your own formulas.
  9. If you do not see the scroll bars or the spreadsheet does not seem to fit properly on your screen, try the following: from the Excel Window menu, choose Arrange... If there are no other spreadsheets open, then click OK. If there are others open, the best choice is probably Cascade. The spreadsheet(s) should then adjust to fit in your screen.
  10. When you click on "Download" below, instead of asking you to save the file to your hard disk, your browser may open up the spreadsheet and display it. In that case, choose "Save As" from the File menu, which will enable you to write the file to your hard disk.
  11. If you right-click (or the Mac equivalent) on the Download link, you should see a menu that lets you save the target of the link, the mileage spreadsheet, directly. This is an alternative to just clicking on the link as discussed in the previous note.
  12. You can be "low tech" by printing out a blank copy of the spreadsheet and filling in your miles and the totals on the printed copy. This may be the best way to go if your spreadsheet program does not recognize some of the formulas.


The spreadsheet is copyrighted in 2021 by Mark D. Pankin, and he reserves all rights. You have permission to use and distribute the file in any non-commercial (you may not charge anyone or demand payment) manner. You must not remove or alter the copyright notice at the bottom of spreadsheet in any copy you distribute. You may remove the notice from your own copy that you do not give to anyone else. Commercial use with the permission of the author only.

Download Mileage Tracking Spreadsheet

To send comments or request a different type of file e-mail: bike -ATsign- pankin.com

Return to the Bicycling Page

Return to the Home Page