Does anyone have an Excel SS setup for a fuel log?
03-18-2006, 03:58 PM
#1
Does anyone have an Excel SS setup for a fuel log?
Just curious if anyone has developed an MS Excel spreadsheet for a neet orderly way to keep fuel milege?
Or any other easy set up for printing out some type of fuel log that's easy to fit in the console.
I'm not real computer savy, so I'm not sure how to make one myself.
TIA
Or any other easy set up for printing out some type of fuel log that's easy to fit in the console.
I'm not real computer savy, so I'm not sure how to make one myself.
TIA
03-18-2006, 04:37 PM
#2
'People of Wal-Mart' 2010 finalist
Join Date: Feb 2005
Location: Oklahoma/Texas
Posts: 456
Likes: 0
Received 0 Likes
on
0 Posts
Funny you should mention that.
I just finished updating mine.
I have the following columns:
Fill Date, Mile, Gallons, MPG, Maintenance, Location, Cost, Maintenance Cost, $/mile, Odometer.
I use my trip odometer for the miles and Odometer just as a verification I didn't miss a fillup. $/mile is a combination of fuel cost/miles driven and maintenance cost/odometer. Other than that, everything else is pretty straight forward.
I just finished updating mine.
I have the following columns:
Fill Date, Mile, Gallons, MPG, Maintenance, Location, Cost, Maintenance Cost, $/mile, Odometer.
I use my trip odometer for the miles and Odometer just as a verification I didn't miss a fillup. $/mile is a combination of fuel cost/miles driven and maintenance cost/odometer. Other than that, everything else is pretty straight forward.
03-18-2006, 08:04 PM
#3
Registered User
Join Date: Jun 2005
Location: Albuquerque, NM
Posts: 109
Likes: 0
Received 0 Likes
on
0 Posts
Are you looking for something for the home computer from Excel or just a printout with nice columns for the info.
I'd be glad to whip you up a spreadsheet with whatever you would like to have (printed and the XL file too).
Date, Odometer, Gallons, Price(from pump), MPG (calculated from other columns), what else? $/mile like Fronty suggested?
I'd be glad to whip you up a spreadsheet with whatever you would like to have (printed and the XL file too).
Date, Odometer, Gallons, Price(from pump), MPG (calculated from other columns), what else? $/mile like Fronty suggested?
03-18-2006, 09:35 PM
#4
'People of Wal-Mart' 2010 finalist
Join Date: Feb 2005
Location: Oklahoma/Texas
Posts: 456
Likes: 0
Received 0 Likes
on
0 Posts
I do alot of miles for the company. Not including vehicle costs, insureance, and other things I would have anyway, I like to keep a rough idea of how much money im making for using my truck for work.
03-18-2006, 09:56 PM
#5
I just normally jot down the:
date
mileage for the tank
gallons filled up with
computer MPG
actual MPG hand calculated
Never thought about marking the price/gallon, but that could be interesting.
I would like to print up a sheet with rows/columns that I could just write the numbers in and leave it in the truck, and wouldn't utilize the actual home computer to fill in the blanks. Just my chicken scratch. I don't have a clue on how to make it small enough to use and fit in the console. Something like using a normal sheet of paper folded in half lenghtwise and the info on either side would work great.
Wish I wasn't such a sloppy writer and a computer nerd
TIA
date
mileage for the tank
gallons filled up with
computer MPG
actual MPG hand calculated
Never thought about marking the price/gallon, but that could be interesting.
I would like to print up a sheet with rows/columns that I could just write the numbers in and leave it in the truck, and wouldn't utilize the actual home computer to fill in the blanks. Just my chicken scratch. I don't have a clue on how to make it small enough to use and fit in the console. Something like using a normal sheet of paper folded in half lenghtwise and the info on either side would work great.
Wish I wasn't such a sloppy writer and a computer nerd
TIA
03-19-2006, 11:01 AM
#6
Registered User
Join Date: Mar 2003
Location: Springfield, MO
Posts: 199
Likes: 0
Received 0 Likes
on
0 Posts
Send me a PM with your email address and I can send you what I use. It is really nice and I copied it from someone else, no way I could've come up with this thing.
Eric
Eric
03-20-2006, 12:31 PM
#7
Registered User
Join Date: May 2005
Location: Mount Airy, MD
Posts: 75
Likes: 0
Received 0 Likes
on
0 Posts
Not mine and not specifically fuel related but I use the Service Record spreadsheet I got from http://www.cumminsdatabase.com/browse.php?mod=5&part=1 It has a page for fuel and does what I need it to.
This is the direct link to download the .xls file.
http://www.cumminsdatabase.com/read.php?id=134
This is the direct link to download the .xls file.
http://www.cumminsdatabase.com/read.php?id=134
Thread
Thread Starter
Forum
Replies
Last Post