Travel and vehicles

City vs highway mileage: how to log and compare two driving modes

Tag each tank as mostly city or mostly highway, then compare averages over several tanks. A ten-tank example with made-up numbers shows how to read the gap.

Editorial illustration for City vs highway mileage: how to log and compare two driving modes

To compare city and highway mileage, tag each full-tank fill as mostly city or mostly highway, compute km per litre for each tank, then divide total km by total litres within each group. Use the totals, not an average of tank figures, and keep mixed tanks out or in a group of their own.

How do I tag a tank?

At each fill-up, ask yourself where most of the kilometres since the last fill happened. If roughly three-quarters or more were in one mode, tag it as city or highway. Otherwise tag it mixed. Do not agonise over borderline tanks. A rule you can apply quickly beats a precise one you abandon.

A made-up ten-tank comparison

TankTagKmLitresKm per litre
1City31022.014.1
2City29521.513.7
3City32023.013.9
4City30022.013.6
5City30521.814.0
6Highway42024.017.5
7Highway43524.517.8
8Highway41023.817.2
9Highway44025.017.6
10Highway42524.217.6

Why use totals instead of averaging the tank figures?

A tank with more litres should count for more. For the city group, total kilometres are 310 plus 295 plus 320 plus 300 plus 305, which is 1,530. Total litres are 22.0 plus 21.5 plus 23.0 plus 22.0 plus 21.8, which is 110.3. City mileage is 1,530 divided by 110.3, about 13.87 km per litre.

For highway, kilometres total 2,130 and litres total 121.5, so highway mileage is 2,130 divided by 121.5, about 17.53 km per litre. The gap is about 3.66 km per litre.

What does the gap cost me?

Suppose petrol is ₹100 a litre in this example. City costs ₹100 divided by 13.87, about ₹7.21 per km. Highway costs ₹100 divided by 17.53, about ₹5.70 per km. For a 1,000 km month in the city, that is ₹7,210; on the highway it would be ₹5,700. A difference of about ₹1,500 a month on the same distance.

What do I do with mixed tanks?

  • Keep them in a third group and report that average separately.
  • Or note an estimated city percentage and use a weighted comparison once you have enough tanks.
  • Or leave them out of the comparison, but still count their litres in your fuel spend.
  • Try to arrange a deliberately highway or city tank occasionally, such as filling just before a long drive.

How do I set it up in a sheet?

Put the tag in column B, km in C and litres in D. For city mileage use =SUMIFS($C$2:$C$50, $B$2:$B$50, "City")/SUMIFS($D$2:$D$50, $B$2:$B$50, "City"). Swap City for Highway to get the other. Both formulas divide total km by total litres in the group.

SpendixAI can supply the money side: fuel payments from imported statements under a fuel category. The tags, kilometres and litres stay in your own log.

Mixed tanks deserve one more thought. If you can only fill up at the end of a week that included both the daily commute and a highway trip, write both in the note, for example about 120 km on the highway and 180 km in the city. Later, once you have enough tanks, the clean ones show each mode and the mixed ones become a check on whether the two figures hang together.

Because the same route can behave differently in different traffic, record the time of day too if you can. A morning commute and a late-night drive on the same road are not the same test.

When is the comparison worth the effort?

When you are choosing a route, deciding how much of a trip should be by highway, or judging whether a vehicle suits your commute. Five tanks in each mode is a reasonable start, ten is better.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports