Hello dears
I want to calculate the fuel consumption for trucks per trip; however, I get the fuel data only when the truck refill the tank
So, i have 2 tables
First table (first tab) shows the truck No., date of refill and the consumption rate in the period between the last 2 refills
Second table (Second tab) shows trucks and date of trips
N.B. i calculate the consumption ( KM/ Liter) by dividing the difference between the current km counter and the previous km counter by the current gasoline refill quantity, so at each refill i calculate the consumption between the current and the previous refill
What i need to do is to allocate the consumption to trucks by trip, however not every trip date has a refill transaction on that date
so i want to take the consumption for the trip by checking in which on period it exist (period between 2 refill transactions) and allocate the consumption
Please find the attached sheet
Bookmarks