Hi Alan, it’s great to meet a fellow spreadsheet guru 😀 and thanks for sharing your insights.
I think that you and I are aiming to calculate different outcomes. My approach is to try to calculate/estimate the car’s underlying hybrid mpg once the pure EV range has burnt off.
My data since ownership last July now shows a total of 6,200 miles, 364.62 litres (80.2 gallons) and 1,140kWh of electricity. The car is showing a trip of 2.7 miles/kWh thus I have, in theory, covered 3.078 miles from my purchased electricity (2.7 x 1,140). This leaves 3,122 miles (6,200-3,078) covered by 80.2 gallons; giving a hybrid economy of 38.93 mpg
As my old maths teacher used to say QED (quite enough data, thank you)…😂