Referring to the diagram above, the vehicle has three Fuel records for December 2019 and three for January 2020. However, since there is no Fuel record for January 1st, 2020, Gearbox utilizes the mileage reading from December 31st, 2019 (257,283 Kms) and subtracts it from the reading on January 31st, 2020 (258,784 Kms), resulting in a distance traveled of 1,501 Kms. Gearbox then calculates the total liters consumed for January 2020.
Using this data, Gearbox divides the distance travelled by the liters of fuel consumed to provide an average fuel economy value of 1.75 Liters consumed per Kilometer.
AUG 2019 Kms = [August Highest KMs Reading] – [July Highest KMs Reading]
AUG 2019 Litres = Sum of all fuel for AUG
AUG 2019 KMs Per Litre = [AUG 2019 Kms] / [AUG 2019 Litres]
Fuel Economy September 2019
SEP 2019 Kms = [September Highest KMs Reading] – [August Highest KMs Reading]
SEP 2019 Litres = Sum of all fuel for SEP
SEP 2019 KMs Per Litre = [SEP 2019 Kms] / [SEP 2019 Litres]
Fuel Economy October 2019
OCT 2019 Kms = [October Highest KMs Reading] – [September Highest KMs Reading]
OCT 2019 Litres = Sum of all fuel for OCT
OCT 2019 KMs Per Litre = [OCT2019 Kms] / [OCT2019 Litres]