Re: Erroneous entries in the mileage database
Some things that can be automated by database macros:
1. Toss out anyone with only 1 or 2 tanks after a certain date duration. We know that the first tank is often meaningless because of the dealer activities, and if people are not serious about maintaining the data they should be removed.
2. Toss out anyone with totally unreasonable accumulated FE, high or low, as bogus after the same time period. The trick here is to make sure that the achievable FE at each end is maintained. Weird one-time events do happen, (such as actually taking a HiHy off-road).
3. In the interest of retaining an accurate indicator of FE to a non-hybrid owner, the cumulative FE for the class should be established without using the extreme cars in the top and bottom ranges. (i.e. Leave some percentage of the top and bottom performing cars in the published list, but eliminate them from the processing list before summing and averaging for the class cumulative FE.
Finally, there will be some cases where obvious tampering by mean-minded individuals will require hand deletion. But standards should be set so as to be fair to all concerned. Perhaps a review by two or three serious volunteers for each car class could detemine if a car gets manually deleted or not. I would take a turn at it if asked.
It is the ignorant among us that will eventually destroy us all.
Last edited by FastMover : 08-03-2007 at 05:08 PM.
|