Fuel & Maintenance Logs, How Much Do You Keep Up With?
#1
Fuel & Maintenance Logs, How Much Do You Keep Up With?
Ok so maybe I've become a little **** with this truck, but I started logging darn near EVERYTHING. I bought the truck in late summer '06, but didn't start logging stuff until a little while after.
I've logged every single fuel stop since August 12, 2006, and here's what I've learned:
Monthly fuel spending, 2006:
$262.00 August
$260.55 September
$233.00 October
$161.25 November
$220.00 December
Monthly fuel spending, 2007:
$202.00 January
$218.00 February
$247.45 March
2006 total: $1,136.80
2007 total: $667.45 (so far)
My fuel log, which is handwritten in a "journal" style book in my truck, gets transferred to an Excel file whenever I feel like it, in this format:
Date, Mileage, Average MPG, Gallons filled, Price per gallon, Total amt. spent, Location of fuel stop (not shown here)
Then, there's maintenance. That one's easier.
Date, Mileage, Price, Location, and Description. For example:
1/5/2007...$40.90...Geno's Garage...VENTVISOR - 2 PC KIT ('94-'02 DODGE)
How much do y'all keep up with?
I've logged every single fuel stop since August 12, 2006, and here's what I've learned:
Monthly fuel spending, 2006:
$262.00 August
$260.55 September
$233.00 October
$161.25 November
$220.00 December
Monthly fuel spending, 2007:
$202.00 January
$218.00 February
$247.45 March
2006 total: $1,136.80
2007 total: $667.45 (so far)
My fuel log, which is handwritten in a "journal" style book in my truck, gets transferred to an Excel file whenever I feel like it, in this format:
Date, Mileage, Average MPG, Gallons filled, Price per gallon, Total amt. spent, Location of fuel stop (not shown here)
Originally Posted by Fuel Logbook
Saturday, January 13, 2007...92,843...14.08...25.43...$2.35...$60.00
Saturday, January 20, 2007...93,118...13.93...19.74...$2.27...$45.00
Saturday, January 27, 2007...93,408...13.49...21.50...$2.27...$49.00
Friday, February 02, 2007......93,690...14.60...19.31...$2.27...$44.00
Friday, February 09, 2007......94,005...13.05...24.13...$2.27...$55.00
Friday, February 16, 2007......94,342...13.53...24.90...$2.36...$59.00
Friday, February 23, 2007......94,682...13.48...25.22...$2.37...$60.00
Saturday, January 20, 2007...93,118...13.93...19.74...$2.27...$45.00
Saturday, January 27, 2007...93,408...13.49...21.50...$2.27...$49.00
Friday, February 02, 2007......93,690...14.60...19.31...$2.27...$44.00
Friday, February 09, 2007......94,005...13.05...24.13...$2.27...$55.00
Friday, February 16, 2007......94,342...13.53...24.90...$2.36...$59.00
Friday, February 23, 2007......94,682...13.48...25.22...$2.37...$60.00
Date, Mileage, Price, Location, and Description. For example:
1/5/2007...$40.90...Geno's Garage...VENTVISOR - 2 PC KIT ('94-'02 DODGE)
How much do y'all keep up with?
#2
#3
#5
#6
Service Record Spread Sheet
#7
What I do keep up and keep in the truck at all times is a binder I put together that has all the paperwork including directions and receipts for all the mods on it, A section for some important how to articles in it, a section with lubes and torque charts in it and a section that I keep a list of maintenance things that I want to do just to keep my memory jogged when I feel like working on it. All this is for when I'm on the road and have problems. I have everything handy and if it ever goes into a shop and the mechanic gives me a funny look when he see's my toys, I just hand him the binder and it gives him any info he needs know.
#8
#10
My method is a little more spartan than using spread sheets.
I write mileage, miles driven and mpg on all my fuel receipts and keep them. When I do maintenance I write that down on the corresponding fuel receipt along with any related receipts which are later put into a folder. It sounds stupid but has actually come in handy more than once.
My monthly fuel bill is more like $600.00
I write mileage, miles driven and mpg on all my fuel receipts and keep them. When I do maintenance I write that down on the corresponding fuel receipt along with any related receipts which are later put into a folder. It sounds stupid but has actually come in handy more than once.
My monthly fuel bill is more like $600.00