The Fuel Log uses three calculations: Current Usage, Average Current Usage, and Current Cost:
Current Usage calculation specifications
- There must be at least two Fuel Log entries to calculate the Current Usage.
- Select all Fuel Log entries for the equipment that are not before the Meter Reset Date.
- Selected Fuel Logs must have the Date, Odometer, and Quantity values.
- From the selected Fuel Logs determine the maximum and minimum odometer reading:
- Subtract the minimum from the maximum to get the Meter Difference
- Determine the total fuel usage of the selected Fuel Logs
- Do not include the usage of the first Fuel Log in this calculation.
- Divide the previously calculated Meter Difference by the fuel usage to determine the current usage.
NOTE: The label displayed for the Current usage is determined by Usage Per Unit Label field from the Equipment Odometer Types library.
Average Current Usage calculation
Calculate the average usage for all equipment records with the same Equipment Classification.
Current Cost calculation specifications
- Must have at least one of the following to calculate Current Cost:
- At least two Fuel Log entries
- At least two Task records
- At least one Fuel Log and one task for the equipment
- Determine if the equipment record has a meter reset date:
- If one does exist this is used in all future selecting of data
- If not use 1/1/1900 in all future selecting of data
- Select the minimum task odometer—the Odometer reading from the oldest completed Task that is equal to or greater than the previously determined meter reset date.
- Select the minimum odometer reading—the oldest Fuel Log that is equal to or greater than the previously determined meter reset date.
- Select the maximum odometer reading—the maximum could be from a Fuel Log entry or from a Task, depending on which is greater.
- Select the minimum odometer—the lowest value from the previously determined minimum Task Odometer and minimum Fuel Odometer.
- Select the total cost from all tasks where the Actual Stop Date is after the previously determined meter reset date.
COST PER UNIT = (totalCost / (maxOdometer - minOdometer)
NOTE: The label displayed for the Current cost is determined by Cost Per Usage Label field from the Equipment Odometer Types library.