Skip to main content
Cartegraph Campus

Fuel Log Calculations

This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at support@cartegraph.com.

The fuel log uses three calculations: current usage, average current usage, and current cost. The average miles per gallon (MPG) is the average of all vehicles with the same equipment classification, not an average of trips for that vehicle. This is so you can easily compare it to other vehicles of the same class.

Current Usage Calculation Specifications

  1. There must be at least two fuel log entries to calculate the current usage.
  2. Select all fuel log entries for the equipment that are not before the meter reset date.
  3. Selected fuel logs must have the date, odometer, and quantity values.
  4. 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
  1. Do not include the usage of the first fuel log in this calculation.
  2. Divide the previously calculated meter difference by the fuel usage to determine the current usage.

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

  1. 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
  1. 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
  1. 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.
  2. Select the minimum odometer reading—the oldest fuel log that is equal to or greater than the previously determined meter reset date.
  3. Select the maximum odometer reading. This could be from a fuel log entry or from a task, depending on which is greater.
  4. Select the minimum odometer—the lowest value from the previously determined minimum task odometer and minimum fuel odometer.
  5. Select the total cost from all tasks where the actual stop date is after the previously determined meter reset date.
  6. COST PER UNIT = (totalCost / (maxOdometer - minOdometer)

The label displayed for the Current cost is determined by Cost Per Usage Label field from the Equipment Odometer Types library.

Current Miles per Gallon on Equipment Calculation

  • There must be at least two fuel log entries to calculate the current miles per gallon (MPG).
  • 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 quantity of the first fuel log in this calculation.
  • Divide the previously calculated meter difference by the fuel usage to determine the current usage.
  • Was this article helpful?