View Single Post
Old 04-14-2009, 12:18 AM   #11 (permalink)
jomelmaldonado
Puerto Rican Hypermiler
 
jomelmaldonado's Avatar
 
Join Date: Oct 2008
Location: Arecibo, Puerto Rico
Posts: 34

Toyota Echo - '05 Toyota Echo
90 day: 41.71 mpg (US)
Thanks: 0
Thanked 8 Times in 7 Posts
Hello everyone, in Puerto Rico, where I live, fuel is sold by liters, instead of gallons, so I have to divide total liters purchased by 3.7854 to convert to gallons. I've been using an Excel spread sheet I prepared about 5 years ago and have been modifying since then. I have used this spread sheet for my Suzuki Swift, Jeep Cherokee and Ford F-650 Tow Truck. I am going to include the link for any of you that might be interested in it.

You simply enter the following data:
Odometer reading, liters purchased, date, Price/Liter and Fill Up Cost

Optionally: Location, Fuel Station and Remarks/Notes:

It will then calculate the followings:

Miles Driven
Galons
MPG
Average MPG
Price/Galon
Fuel Cost
Total Fuel Cost
Total Miles
Miles used so far
Miles Loged
Gallones Consumed
Cost per Miles
Overall MPG
Fuel Cost

It also has to graphs, a MPG graph and a Cost graph


Plus it has a part where it reminds you on the next tune up items like for example:
Oil & Filter
Air Filter
Spark Plugs
Ignition Cables
Coolant Level
Coolant
Brake Fluid Level
Front Brakes Check
Rear Brakes Check
Front Brakes Pads
Rear Brakes Shoes
Tire Pressure
Timing Belt Replace
Ribbed Belt Replace
M/T Fluid Level

This spread sheet is pre-filled with some information of my Suzuki Swift, remember to change it accordingly could be modified and tailored at you're convenience: Any question, feel free to ask, help this spread sheet is useful those that are starting at this, or want to keep a better, more precise and organized fuel log.

Attached Files
File Type: xls MPG.xls (84.0 KB, 140 views)
  Reply With Quote
The Following 2 Users Say Thank You to jomelmaldonado For This Useful Post:
HappyfaceEco (05-18-2012), phw (03-17-2010)