File import issue

[RobAGD]

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]

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]

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]

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]

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.