Please add miles/day to mini stats
April 15, 2012 6:45 AM Subscribe
Yeah, I think this is something we can add, but we'll need to add some pretty big caveats if we do it. Part of the problem with miles/day is that there can be gaps in the fuelling record. People can forget to add fuel-ups for years, and then come back to fuelly and pick up again. That would throw off the miles/day statistic wildly.
So we might need to find a new way to calculate "consecutive fuel-ups" or something and base that statistic on those fuel-ups only. Which will be confusing for people and harder for us to explain.
It's something we can think further about, but in the meantime you might try exporting your fuel-ups to Excel and see if you can calculate your miles/day there.
Perhaps it might fit better on the 'annual report' page, or in the 'cost analysis' section... ?
Maybe, yeah. But we'd still have the problem with gaps in fuel-ups causing inaccurate numbers.
Maybe that in itself will encourage people to be more accurate in their reporting. Why try to fudge it and make it work with inconsistent data, instead of having it work with what is reported?
You already track data on an as-reported basis. For example, look at my 1994 Z. I only drive it during the warmer months, so it sits all winter. But the way the site tracks it with regards to fuel entries, it only shows the months I actually put fuel in the car. So by that math alone, you should be able to also do a daily, using the data gathered on those days/months recorded.
Use a simple mileage total for each month divided by the actual number of days that month. It will give you an average of miles per day for that month. This will change as you add fill ups of course during the month, and/or this could be a rolling month, showing your mileage average as it increases/decreases on each fill up.
Use the sum of all recorded mileage. Divide that by the number of REPORTED months. Then you can break that down by an average of 30 days. Though it will be slightly more accurate to use the previous example, this will provide a more realistic average over the ownership of the vehicle since registered and while actively updated. Either way should eliminate gap problems though.
Just an idea, you can run with it how you want. lol
Otherwise, you would have to change your entire recording structure, to count all days, not just the ones that are reported on, and figure averages that way. If that was done, your numbers would change EVERY day, fill ups added or not, because it would be adding and calculating constantly as the days go by.
My Excel sheet does this already, it uses a "Today" entry to give it the current date and uses logic (and lots of math) to count the days from a "start" date to calculate how much time to figure averages like mileage per day, hour, week, month, year, etc. I can use one fill up and know what the sheet predicts for a yearly average.
Granted, that would be a tad overkill for here. lol
But basic info, like a miles per day (and have it be for the entire garage) would be useful.
That still sounds far too complicated. There are too many rules and exceptions to blanket allow for that kind of data (some winter months, other summer months, partial months, etc). The only solution, (and I think that pb is moving to that) is that you'd have to imply something about the data - either have a "Continuous" checkbox when you report (ie this is continuous data, with no gaps) to validate that the current info should be included in the miles/day calculation, or something more complex. The problem with complexity is that people will start to not actually use it, if it is too complex.
Also, how do you handle a "long trip" - say I drive 800 miles in a day. My car can't go 800 miles on a single tank of gas, so that might wind up being 3 fillups for that 800 mile trek. How would/could you handle that on an as reported basis? I suppose you could do something like record your fillup time as well as date (which I've started doing via aCar, but that's just me), but that would be even more of a "burden" on the end user.
The reason why this site is so AWESOME is that I have reference data that thousands of other people have also contributed to. Making it "harder" (or at least more complex) to use drives away more people, thereby reducing the usefulness of the site.
So, perhaps now that I think about it, it might be useful to have that statistic with a 'caveat' asterisk.
I would also really like this feature... I want to have better fuel economy, but I also want to make sure that I'm not driving too much as well and keep my overall spending down...