Working As Designed: MPG numbers don't match [non-bug]

[DirtyDawg]

Originally Posted by freddie

What numbers did you use to arrive at 14.1?

Well, Freddie, unfortunately it looks like I'm going to have to eat some crow here. The numbers you used, do not match mine, but in going back to my spreadsheet to find out why, I discovered an oddity in the way Apple Numbers handles a particular formula, so it turns out that my spreadsheet was giving an unexpected erroneous figure.

I had expected (obviously wrongly!) that the best way to calculate total miles/total gallons would be as follows: =sum ((miles column)/(gallons column)). This would be accessing actually entered data, rather than the results of a calculation as would be the case if I summed each column and then divided the sums.

The miles column totals 19006.2 currently, and the gallons column totals 1413.45. Much to my chagrin, 19006.2/1413.45=13.446673! :scratches head: So I go and change the formula in the Average MPG field to =(miles sum cell)/(gallons sum cell), and voila! My average MPG now matches yours. Hopefully egg is good for the complexion.

APOLOGIES FOR HAVING MALIGNED THE APP UNJUSTLY.

Edit: P.S. It is also good to know that the calculations are actually being performed by the more accurate method now, as Freddie's test car proves. In our previous conversation, Robert V. stated, "The Average MPG figure is calculated from an average of each individual fuel-up MPG reading." This is the info I was basing my arguments upon.