Fisker Mileage Calculator - Fisker Buzz Forums
Fisker Buzz Forums

User Tag List

Reply
 
LinkBack Thread Tools
Old 01-11-2012, 02:17 AM   #1 (permalink)
Super Moderator
 
LonePalmBJ's Avatar
 
Join Date: Jun 2011
Location: Roswell, GA
Posts: 1,172
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 139 Post(s)
Garage
Default Fisker Mileage Calculator

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:
  • 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
LonePalmBJ is offline   Reply With Quote
Old 01-11-2012, 04:28 PM   #2 (permalink)
Senior Member
 
Join Date: Jan 2011
Posts: 744
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Default RE: Fisker Mileage Calculator

I was discussing MPG of my Subaru with my father, a retired math professor, and he made a good point regarding MPG calculation. When fueling, especially when using the automatic shutoff feature on most pumps, the amount of fuel put in varies significantly. Therefore, if I just drove 250 miles and put in 10 gallons of gas, I might think my MPG was 25, not realizing this particular pump shutoff a half gallon sooner than the one from last fill up, causing an inflation of my actual MPG. If one is more interested in accurate Spot or Trip MPGs, one would have to put in a measured amount of fuel each time. Having a full tank is more important to me than this as the flucuations wash out for Lifetime MPG, of course.
__________________
delivered from Fisker of Huntsville, AL
kabalah70 is offline   Reply With Quote
Old 01-11-2012, 04:40 PM   #3 (permalink)
Senior Member
 
Join Date: Mar 2010
Location: Oakland (Montclair)
Posts: 913
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 42 Post(s)
Default RE: Fisker Mileage Calculator

Quote:
Originally Posted by kabalah70
I was discussing MPG of my Subaru with my father, a retired math professor, and he made a good point regarding MPG calculation. When fueling, especially when using the automatic shutoff feature on most pumps, the amount of fuel put in varies significantly. ...
Yes. The variation drops a lot if you use the same pump at the same station all the time (not always easy to do), or you can "top off" the tank by hand (not always wise ) but it's best just to use a longer term average.
ct-fiskerbuzz is offline   Reply With Quote
 
Old 01-11-2012, 05:16 PM   #4 (permalink)
Senior Member
 
Join Date: Nov 2009
Location: Vail, Colorado
Posts: 147
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 5 Post(s)
Garage
Default RE: Fisker Mileage Calculator

Looks good, and works fine on Excel 2010. When I did my test drive (waaaay back in August) I asked the Fisker Rep if there was going to be some sort of online tracking for owners to input their data (along with their issues), as I thought it could be a tremendous sales tool for Fisker. He said they were considering something at the time, but I never heard anymore about it. This will work great for me, that is, IF I ever have an actual car.
Richard Carnes is offline   Reply With Quote
Old 01-11-2012, 05:40 PM   #5 (permalink)
Super Moderator
 
LonePalmBJ's Avatar
 
Join Date: Jun 2011
Location: Roswell, GA
Posts: 1,172
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 139 Post(s)
Garage
Default RE: Fisker Mileage Calculator

Thanks Guys!

I've already got a v2 in the works with some improvements. I'll post it soon.

I agree about the variability of auto-shutoff, which is why the spreadsheet runs primarily off of the metered amount of fuel pumped. Yes, each pump will have a different definition of "full", and the sheet only calculates Spot MPG correctly if you fill up, but I think the error discrepancy will be trivial. For my purposes, it'll be good enough to say "I'm getting about 85mpg" or hopefully "I'm getting about 185mpg"

Keep the feedback coming!

Brent
LonePalmBJ is offline   Reply With Quote
Old 01-11-2012, 10:07 PM   #6 (permalink)
Senior Member
 
Dave_Car_Guy's Avatar
 
Join Date: Oct 2011
Posts: 312
Mentioned: 9 Post(s)
Tagged: 0 Thread(s)
Quoted: 60 Post(s)
Default RE: Fisker Mileage Calculator

I have an easier solution, although maybe slightly less robust.

The Karma comes with two trip calculators, A and B. Each one tells you how many miles you have traveled and the combined gas mileage you have experienced. For my "A" trip computer, I never re-set it, so when I look at that one, it is telling me my overall experience since purchase. I reset the "B" one each time I plug it in, so that I get the mileage for my most recent electrical "fill-up". I would say that I could also use B every time I fill it up with gas, but so far, the car still has most of the gas it was delivered to me with. 500 miles so far and only a gallon or so of gas use.

The B computer, when I am in all stealth mode for any given 50 mile segment, always tell me I am getting above 400 MPG (people love to see that on my command center screen), but it won't give you a reading to infinity ;-). My combined one since purchase (Trip "A") is telling me I have experienced 290 MPG. One test would be to start with an empty battery and let my B computer calculate what MPG I would get over 100 miles or so, and see how it compares to the EPA all-gas calcs. But to do that, I'd have to burn gas for the test, which I don't want to do until I go on a long trip somewhere.
Dave_Car_Guy is offline   Reply With Quote
Old 01-11-2012, 10:32 PM   #7 (permalink)
Super Moderator
 
LonePalmBJ's Avatar
 
Join Date: Jun 2011
Location: Roswell, GA
Posts: 1,172
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 139 Post(s)
Garage
Default Fisker Mileage Calculator version 2

Ok, I've made some tweaks. Click here for version 2:

Fisker Mileage Calculator v.2

Release notes:
  • Replaced Cost-per-mile with Cost-per-gallon. Cost-per-Mile was pretty meaningless since it doesn't account for electricity cost. There are lots of tools out there that estimate or track that, but that's out of scope for what I'm looking to do here. I put in Cost-per-gallon just because it'll be interesting to be able to track what happens with fuel prices.
  • Resequenced the columns on the Mileage Calculator sheet, placing the four that require data entry together. Also changed the shading to indicate which fields are manually entered and which are calculated
  • Updated the Printable Log to only include the four columns of data you need to capture at each fill-up
  • Added a Version History tab, with an enhancement idea scratchpad

Again, all feedback welcome!

Brent
LonePalmBJ is offline   Reply With Quote
Old 01-11-2012, 10:36 PM   #8 (permalink)
Senior Member
 
Join Date: Mar 2010
Location: Oakland (Montclair)
Posts: 913
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 42 Post(s)
Default RE: Fisker Mileage Calculator

Quote:
Originally Posted by Dave_Car_Guy
I have an easier solution, although maybe slightly less robust.

The Karma comes with two trip calculators, A and B. Each one tells you how many miles you have traveled and the combined gas mileage you have experienced. For my "A" trip computer, I never re-set it, so when I look at that one, it is telling me my overall experience since purchase. I reset the "B" one each time I plug it in, so that I get the mileage for my most recent electrical "fill-up". I would say that I could also use B every time I fill it up with gas, but so far, the car still has most of the gas it was delivered to me with. 500 miles so far and only a gallon or so of gas use.

The B computer, when I am in all stealth mode for any given 50 mile segment, always tell me I am getting above 400 MPG (people love to see that on my command center screen), but it won't give you a reading to infinity ;-). My combined one since purchase (Trip "A") is telling me I have experienced 290 MPG. One test would be to start with an empty battery and let my B computer calculate what MPG I would get over 100 miles or so, and see how it compares to the EPA all-gas calcs. But to do that, I'd have to burn gas for the test, which I don't want to do until I go on a long trip somewhere.
My current car does not even have A-and-B. I just keep a log book in the car and record mileage and quantity (and price and date and so on) at each fill-up. In most cases I use the trip odometer to measure miles between fill-ups.

Since the Karma has an actual computer instead of just a limited set of hardwired counters, it really should let you select a "start new trip named <fill in the blank>" at any time, and count up from current odometer reading (or store it as an odometer offset that is subtracted from "current reading" for display purposes until that trip is marked "ended", but that's an efficiency tweak that will only matter if there is a large number of active trips*). The trips page should show you all the current active trips (and let you mark any of them "ended", which stops them counting up), show ended trips (maybe let you "resume" them too), and let you delete or reset them.

That page should probably come with basic "trip A" and "trip B" pre-loaded, but that should not be a limit, just a starting point.
[hr]
* I.e., instead of:
Code:
for trip in active_trips:
    trip.distance += 1 # one tick = 1/10th mile or 1/10th km or whatever
at every odometer tick, you just do:
Code:
odometer.reading += 1
and when showing all trips you do:
Code:
for trip in active_trips:
    trip.distance = odometer.reading - trip.offset
for trip in sorted(active_trips + stored_trips):
    trip.display()
or whatever.
ct-fiskerbuzz is offline   Reply With Quote
Old 02-27-2012, 10:58 AM   #9 (permalink)
Super Moderator
 
LonePalmBJ's Avatar
 
Join Date: Jun 2011
Location: Roswell, GA
Posts: 1,172
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 139 Post(s)
Garage
Default Fisker Mileage Calculator version 4

I've owned my car for a couple weeks now and have moved in to my spreadsheet. It's working well for me as a way of keeping track of my actual consumption, and also as a consolidated tool to track issues as I encounter them. I've made some tweaks. Click here for version 4:

Fisker Mileage Calculator v.4

Release notes:
  • Added Squawks worksheet to record observed issues and their status
  • Protected sheets and cells from inadventant change (no password)
  • Changed odometer precision to whole miles to match odometer in vehicle

The Squawks sheet uses conditional formatting on the "Date Observed" cell as follows:
  • Yellow background color indicates a new occurrence that hasn't yet been reported to my dealer
  • White/no background color means an active, open issue that the dealer is aware of
  • Green background color indicates a resolved issue


Again, all feedback welcome!

Brent




__________________
Owner: Karma EcoSport Deep Ocean/Black
LonePalmBJ is offline   Reply With Quote
Old 02-27-2012, 11:45 AM   #10 (permalink)
Super Moderator
 
SoCalGuy's Avatar
 
Join Date: Jun 2011
Location: LA/NYC
Posts: 1,975
Mentioned: 7 Post(s)
Tagged: 0 Thread(s)
Quoted: 36 Post(s)
Garage
Default RE: Fisker Mileage Calculator

Quote:
Originally Posted by LonePalmBJ
I've owned my car for a couple weeks now and have moved in to my spreadsheet. It's working well for me as a way of keeping track of my actual consumption, and also as a consolidated tool to track issues as I encounter them. I've made some tweaks. Click here for version 4:

Fisker Mileage Calculator v.4

Release notes:
  • Added Squawks worksheet to record observed issues and their status
  • Protected sheets and cells from inadventant change (no password)
  • Changed odometer precision to whole miles to match odometer in vehicle

The Squawks sheet uses conditional formatting on the "Date Observed" cell as follows:
  • Yellow background color indicates a new occurrence that hasn't yet been reported to my dealer
  • White/no background color means an active, open issue that the dealer is aware of
  • Green background color indicates a resolved issue


Again, all feedback welcome!

Brent




What sort of fuel economy have you been getting (e.g. in pure Sport mode)?
SoCalGuy is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mileage/ command center bug Grebechini Fisker Karma 19 08-30-2013 03:39 PM
What Real World Mileage Are you Getting? Fabulist Fisker Karma 10 12-24-2011 12:53 AM
Fisker Karma Electric Car Gets Worse Mileage Than an SUV SoCalGuy Fisker Karma 15 10-22-2011 10:01 AM
Southern California Edison launches rate calculator for plug-in vehicles Wimbledon The Fisker Lounge 0 09-15-2010 11:31 AM

Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 12:52 AM.



Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2
Garage Plus vBulletin Plugins by Drive Thru Online, Inc.
User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.