Hi Jason:

___I just had a look over the database numbers and it appears that the average temperature is now fubar? IIRC, you had a mileage weighted temperature (as you should have) but now, something altogether different is appearing. In other words, the temperature shown is not a straight average or mileage weighted but something completely different?

___For my own mileage weighted temperature, I use the following in excel …

T(mileage weighted)=[(Miles Traveled Tank(n)*Average Temperature of Tank(n))+(Miles Traveled Tank(n + 1)*Average Temperature Tank(n+1))]/(Miles Traveled Tank(n) + Miles Traveled Tank(n + 1)) with a drag down continuing the sequence with future n = (n+1)

___For the straight average (non-temperature weighted), I just use T(non-weighted)=Sum(Average Tank Temperature(s))/total number of tanks … The weighted average makes more sense to me given you will usually drive further in warmer weather then colder (A/C use not-withstanding).

___Good Luck

___Wayne R. Gerdes
___Hunt Club Farms Landscaping Ltd.
___Waynegerdes@earthlink.net