Excel spreadsheet to log and calculate business and personal miles. Initialization Steps Line 3, Col B "date" : Put in January 1, 2015, or whatever year you want. Line 3, Col C "start": Put in the odometer reading as of midnight January 1 Line 3, Col D "end" : leave empty Line 3, Col's E "totals", F "business", G "personal" : Ignore for now How to use Col A - Purpose : Brief description of trip. eg: Jones - tune Col B - Date : Enter the month and day of your trip. eg 4/27 (April 27) Col C - Start : Enter odometer reading at beginning of trip Col D - End : Enter odometer reading at end of trip. Col E : Will automatically show total miles for that trip Col F : (at top) will automatically show running total for all miles entered. At end of year, midnight Dec 31, enter odometer reading in Row 3, Col D. Row 3, Col G will update to show total personal miles for year. #UserTag1 #BusinessMileagespreadsheet