We have a fleet consisting of several trucks and we want to the monitor fuel consumption of individual trucks. At every fuel intake we register:
* current milage
* quantity of fuel
* license plate
I'm not sure how to determine all increments, so we can trend fuel consumption. My ultimate goal is:
* to find out which trucks have the highest fuel consumption /milage within a certain period.
* to identify trucks with a steadily increasing fuel consumption/milage
Can anyone give me some tips and tricks?
Thanks in advance