Reporting

Two versions of the reporting form are available.  Use the following link if you want a printable version of the reporting form that you can fill in by hand.

Mileage Reporting Form – PDF Version

 

An Excel spreadsheet version is available for those who prefer to enter their data on the computer and have the spreadsheet assist with the calculations.  You may download the Excel spreadsheet by clicking on the link below.  Once it is opened, be sure to click on “Enable Editing” in the yellow bar to enter your information.  

Mileage Reporting Form – Excel Version

Following is some information about using the Excel spreadsheet.

Top of Form: Everything is pretty straightforward on the top of the form, but if you have any questions you should certainly feel free to contact me.

Body of Form: In the body of the form, you will fill in the first 6 columns. The column headed “Last Reported Odometer Reading” will, of course, be the odometer reading last reported for that particular vehicle, whether it was one year ago or several. Once you have put in the figure for the next column, “Odometer Reading Dec. 31,” the spreadsheet will automatically subtract the last reported odometer reading from Dec. 31 odometer reading to calculate the next column, “Miles Driven This Report.”

Some regions/individuals keep their own records of total miles driven, and some do not. For that reason, the last two columns on the spreadsheet are optional. If you wish to keep track of the total miles, enter the most recent information in the column headed “Previous Total Miles Driven,” and the spreadsheet will add those miles to the “Miles Driven This Report” column to give you the “Cumulative Total Miles Driven.”

Adding/Deleting Rows: If it is necessary to add more rows to the form (and some of the larger regions will require more space), here is the best way to do it to ensure that the formulas that are locked into the spreadsheet are continued with the new rows (this is best done before you enter any information; you can always remove any extra rows):

  1. Move the cursor all the way to the left, in the numbers alongside the rows (you will get an arrow pointing right). Click and drag the cursor straight down to highlight the desired number of rows you wish to insert. Release the mouse button.
  2. Right-click the mouse and a drop-down window will appear. Click on Copy.
  3. Move the cursor to the row where you want the copied rows inserted, right-click to get the drop-down window, and click on Insert Copied Cells. Done!
  4. To delete any extra rows, repeat step 1 above, highlighting the rows you want to delete, then right-click the mouse to get the drop-down window and click on Delete. That’s it!

Saving the Report:  Don’t forget to save your file with an appropriately identifying name (e.g., “2015 Mileage Report” or similar).

Printing the Report: If you wish to print a copy for your own records, and you don’t think it will fit on one page, there’s no need to try to break the form down into page-sized blocks. When you give the print command, the spreadsheet will automatically print page-size blocks and will repeat the top of the form and the column headings on each page.

Submitting the Report: You may submit the form by email if that is most convenient for you. In fact, we encourage this method! But, of course, you may print it out and mail it if you prefer.  Either way, don’t forget to submit it no later than February 28. This will ensure that any mileage awards based on the figures in the report will be acknowledged in the Model “A” News.´ We cannot guarantee recognition in the magazine if the reports are not received on time.

A Few Last Things: Special thanks to Eugene Willingham of the Southside A’s for “beta-testing” our form and making some valuable suggestions for improvement! We have done our best to make the form as user-friendly as possible, but we welcome your comments and ideas for further improvement.

 Dick Fisher
Chairman, MARC Mileage  Program
P.O. Box 23
Hanover, MD 21076-0023
443-627-0395 (Dick)
443-889-1018 (Betty)