Skip to main content
Cartegraph Campus

Average Monthly Miles Calculation

You must have a Cartegraph OMS advanced feature extension to access this feature.

The following values are the calculation variables:

Earliest Date:

  • When the fuel log is sorted by date ascending order, the system finds the first record in the fuel log with a Date field value. This value becomes the Earliest Date.
  • If the fuel log does not contain any records or there are no records with a date value, the Service Base Line Date becomes the Earliest Date.
  • If there are no fuel log records with dates and there is no Service Base Line Date, the Earliest Date is set to 1/1/1900.
  • If there is only one Fuel Log record and a baseline date and/or baseline odometer reading then the Earliest Date is the date that is the earliest between the Base Line date and the Fuel Log record.

Earliest Odometer:

  • When the fuel log is sorted by date ascending order, the first fuel log record with a value in the Odometer field becomes the Earliest Odometer.
  • If there are no fuel log records with odometer readings, then the Service Base Line odometer becomes the Earliest Odometer reading.
  • If the Earliest Odometer field doesn’t have a value, then the Earliest Odometer reading is set to 0.
  • If there is only one Fuel Log record and baseline values the Earliest Odometer is the smallest value between the Fuel Log Odometer and the Baseline Odometer values. The other odometer value becomes the Most Recent Odometer.

Most Recent Date:

  • When the fuel log is sorted by date ascending order, the last record in the fuel log with a Date value becomes the Most Recent Date.
  • If no records have Date values, then the Most Recent Date value is set to equal the Earliest Date value.

Most Recent Odometer Reading:

  • The last record in the fuel log with an Odometer Reading becomes the Most Recent Odometer value.
  • If no records have Odometer Readings, then the Most Recent Odometer value is set to equal the Earliest Odometer value.

Number of Months Difference:

  • The functionality determines MonthDiff value, the number of months between the Earliest Date and the Most Recent Date.
  • If the two dates are in the same month the MonthDiff is set to 1.

Number of Miles Driven:

  • The functionality then determines the number of miles driven in the entire fuel log by setting OdometerDiff equal to the Most Recent Odometer minus the Earliest Odometer.
  • If there are no Fuel Log records or only one Fuel Log record then the Average Miles per month is zero.

Number of Miles per Month:

The functionality then estimates average number of miles per month that the piece of equipment travels by setting Average Miles per Month=OdometerDiff/MonthDiff.

Sample Calculation

This sample shows how three future months are processed for service needs and schedules the Equipment Events.

Month 1

  • Fuel Date is Today plus one month.
  • Fuel Odometer is Most recent fuel log odometer value entry, where the odometer value is not null plus Average Monthly Miles.

NOTE: If there are no Fuel Log records then the Baseline odometer is used.

If the check for service reveals the need for scheduled maintenance, then a record is added to the Equipment Future Maintenance library with the following values:

Month 2       

  • Fuel Date is Fuel Date plus one month.
  • Fuel Odometer is Fuel Odometer plus Average Monthly Miles.

If the check for service reveals the need for scheduled maintenance, then a record is added to the Equipment Future Maintenance library.

Month 3

  • Fuel Date is Fuel Date plus one month
  • Fuel Odometer is Fuel Odometer plus Average Monthly Mile.

If the check for service reveals the need for scheduled maintenance, then a record is added to the Equipment Future Maintenance library.

This process continues estimating end month date and odometer values and checking if service is due against the Equipment Events recordset and previously–predicted events stored in the Equipment Future Maintenance library.

  • Was this article helpful?