File import issue
July 14, 2009 8:05 PM   RSS feed for this thread Subscribe

I am having some issues with a csv file I uploaded, it seems to have dropped April and Mays fill up and well, its also seems to not be once again calculating fill or listing fills in correct order.

Is there a way to delete an imported file ?
posted by RobAGD to Fuelly Site Issues at 8:05 PM (14 comments total)

pb
Jul 14, 2009
8:26 PM

No there isn't a way to delete imports, but you can: 1.) delete your existing car, 2.) create a new car, 3.) try your import again.


pb
Jul 14, 2009
8:31 PM

yeah, looks like your April fills are off. I took a look at all fuel ups and on April 20 your odometer said 88221, and then on April 21 it said 87811, so there are probably some fuel-up dates transposed along the line. If you fix those up and re-import you should be set.

RobAGD
Jul 15, 2009
6:07 PM

ok the april booboo was a 12 vs 21 in the date.

Now looking at some other weird ness

May 22 and June 6th I belive

I have complete fills 1 with 0 mpg and 1 with 1.9

Also a partial fill is listed above ( later ) than another fill in the same day, Why wouldnt the system sort fill on teh same day by the miles ?

-R


pb
Jul 15, 2009
9:47 PM

Why wouldnt the system sort fill on teh same day by the miles ?

It should, so I'm not sure why you had the glitch with that day. It could have been a problem with the import process and having fuel-ups recorded at exactly the same time on the same day. I recalculated your mileage manually on this end and it looks like things are lining up better on those problem days now.

RobAGD
Jul 19, 2009
5:36 AM

Thanks, when I get back into town I'll noodle through the list again and see if anything else is skewed.

-R

RobAGD
Jul 23, 2009
2:43 PM

OK I am still seeing some issues with fill ups in May.

starting 4/27 to 5/31 everything mileage wise looks correct to me and is in correct order BUT I have 3 complete fills with no calculated mpg.

Something in how your system handles partial fills is angry or something.

R


pb
Jul 24, 2009
12:05 PM

heh, nothing is angry. When you mark a fill as partial, Fuelly skips calculating the MPG for that tank and the next one. Fuelly needs a baseline full tank to start calculating MPG for individual fuel-ups again. But all of fuel-up data goes into calculating the average MPG of the vehicle, so it's still worthwhile to include partials.

There's a little more info in the FAQ: How do I account for partial fuel-ups?

RobAGD
Jul 24, 2009
4:08 PM

Ok, there is the problem then, there is no reason to skip the calc.

If I burn through say a tank and go 400 miles on 18 gallons

how is that any differnt than if I go 1200 miles on 60 gallons ?

As long as you dont SKIP a fill there is no reason to not calc the mileage. It run look back at the DB and add the total gallons and miles up and bingo.

And somethinge lse thats a bit weird the same mileage that I uploaded here figured out to a differnt mpg than my excel sheets did.

Thanks

-R


pb
Jul 24, 2009
7:07 PM

This answer in the FAQ might answer your question: Why do I have to fill the tank all the way up every time I buy fuel?

RobAGD
Jul 25, 2009
8:07 AM

I'll be honest, that is a horrid reason.

partical fills can be added, if your accounting for them in the total MPG avg count then there is no reason not to tally on a full fill.

the Miles only need to be counted from last fill to current fill and then total the gallons and divide. I am going to assume that all this is kept in some sort of DB and you can set a flag on a partical just like you would on a skip.

-R


pb
Jul 25, 2009
11:34 AM

That's ok, we can agree to disagree on this one. Tracking your fuel based on a full tank isn't a science, and there's no way to be 100% accurate without some sort of device attached to your vehicle measuring fuel consumption. So we have a system that we worked out for getting an estimate, and I'm sure there are lots of other ways you could do it.

RobAGD
Aug 4, 2009
10:25 PM

Ok here is an example :

I have 8 fills :

Odo_____Date_____Type____Fuel__Fill$___Gal$___Gals___MPG__Miles
93097__07/16/09__Sunoco___93__$46.00__$2.62__17.50__14.8___259
93456__07/18/09__Valero____93___$7.00__$2.64___2.64__NC
93465__07/18/09__BP_______93__$41.00__$2.59__15.77__20_____368
93804__07/21/09__Chevron__93__$10.00__$2.79___3.57__NC
93887__07/22/09__Sunoco___93__$46.00__$2.59__17.70__19.84__422
94166__07/27/09__Chevron__93__$10.00__$2.84___2.84__NC
94227__07/28/09__Sunoco___93__$47.00__$2.64__17.74__16.52__340

Ok that comes to 1680 Miles from last fill (odo reading 92838), 94.86 Gals, thats 17.71 MPG.

Now what would be the differnace if I just entered 1 fill at 94.86 Gallons and a Odo reading of my last fill ? because I am just trying to wrap my head around the idea about how you are handling the part fills.

BTW - I am not picking on you or the site, I am just trying to help this work more smoothly. I have records of every fill for my car from the 116 miles that were on it when I picked it up, to the current almost 95k miles. In that, I dont have records of I think 3 fills.

-Robert

RobAGD
Aug 5, 2009
7:36 AM

woops just checked something the last fill didnt paste over

94518__08/01/09__Sheetz___93__$45.10__$2.63__17.10__17.02__291

-R

LP81
Aug 10, 2009
4:12 PM

Rob, What is your end goal here... Do you want to send me your excel doc and I can format it for you for a clean upload? If so, hit me up on LXF and we can go thru it.

« Older Incorrect Milage Calcuatlion   |   Picture / data issues Newer »

You are not logged in, either login or create an account to post comments