Joined
·
1,183 Posts
There's been a lot of talk about what kind of real-world mileage we'll experience with our Karmas. I decided that when I get my car I'm going to carefully track how much fuel I'm putting in, and how far I go.
I looked around for a logbook to keep in the car to jot down each fill-up but I couldn't find one I liked. Instead, I fired up Excel, leveraged some ideas and templates from the Internet, stayed up past my bedtime and created a Fuel Calculator for my Karma.
I'd like to invite you to be a beta tester and provide feedback. You can download my work-in-progress from the link below.
A few notes about the tool:
Update: The link below will now always point to the latest version. Read later entries in this thread to learn about the improvements I've made.
Click Here to Download the Latest Version
All feedback welcome. Feel free to send me a PM through the forum.
Thanks!
Brent
I looked around for a logbook to keep in the car to jot down each fill-up but I couldn't find one I liked. Instead, I fired up Excel, leveraged some ideas and templates from the Internet, stayed up past my bedtime and created a Fuel Calculator for my Karma.
I'd like to invite you to be a beta tester and provide feedback. You can download my work-in-progress from the link below.
A few notes about the tool:
- There are four tabs: the Mileage Calculator, the Mileage Chart, a Printable Log and a printable Service History
- The Mileage Calculator is where all of the magic happens. You put in the Date of each fill-up, along with the current odometer reading, and the amount and cost of the fuel. Excel calculates the rest
- The tool calculates Spot MPG (what you observed since the last Fill-up) and Lifetime MPG
- The Mileage Chart helps you visualize the data and identify trends
- The Printable Log is intended to be kept in the car and used to write down Fill-up details.
- The Service Log is likewise intended to be printed and kept in the car. I use this for all of my vehicles to record all service perfomed, tire changes, warranty work, etc
- I've populated the tool with some sample data. It's all made up but hopefully plausible
- I'm running Excel 2007. No guarantees it'll work for you or on another version
- Once this is polished I'll make it available to any and all who wish to use it
Update: The link below will now always point to the latest version. Read later entries in this thread to learn about the improvements I've made.
Click Here to Download the Latest Version
All feedback welcome. Feel free to send me a PM through the forum.
Thanks!
Brent