Skip to main content
Cartegraph Campus

Maximum Usage and Average Daily Usage Calculations

This explains how Usage and Average Usage fields are calculated when an Equipment Task or Fuel Log entry is created, updated, or deleted.

Maximum Usage

When an Equipment Task or Fuel Log is created, updated, or deleted, the maximum usage value is placed in the Assets Usage field.

Example

Task Data:

  • Activity: Inspection
  • Miles: 400
  • Completed On: 12/2/2013

Fuel Log Data:

  • Activity: Inspection
  • Miles: 425
  • Entered On: 12/2/2013

The Asset Usage Field is 425 from the Fuel Log because it is the highest Usage value.

If the Asset has a value in the Meter Reset Date and there are no newer Tasks or Fuel Logs, the Baseline Meter field is used as the current Usage.

Average Daily Usage

When an Equipment task or Fuel Log is created, updated, or deleted, the Average Daily Usage is calculated based on the oldest Tasks or Fuel Log, up to a year old, and the newest Tasks or Fuel Log value.

Example

Task Data:

Record 1:

  • Activity: Inspection
  • Miles: 40
  • Completed On: 12/5/2012

Record 2

  • Activity: Inspection
  • Miles: 700
  • Completed On: 12/1/2013

Fuel Log Data:

Record 1:

  • Miles: 35
  • Entered On: 12/1/2012

Record 2:

  • Miles: 775
  • Entered On: 12/2/2013

The calculation uses the mileage from Task Data Record 1 for the starting value. Fuel Log record 1 is over one year old. The calculation then uses Fuel Log Record 2 as it is the newest record of the four.

The math would be as follows if it ran on 12/2/2013:

(775 - 40) divided by 363 days (12/2/2013 - 12/5/2012)

Average Daily Usage = 2.02 Miles a day

  • Was this article helpful?