Skip to main content
Cartegraph Campus

Vehicle Replacement Rating Calculations

This section covers how Vehicle Replacement Ratings are calculated.

These fields are recalculated whenever a Task, Fuel Log or Equipment record is created, updated, or deleted. Make sure the Equipment Classification has the Vehicle check box selected for the associated classification to view this information for the Equipment record.

Age calculation:

  • 1 point for each year based on Manufactured Date
  • Determine the number of days between today and Manufactured Date
  • Divide days by 365
  • Cannot be less than 0 or greater than 5

Usage calculation:

Based on Current Usage and the point value, cannot be less than 0 or greater than 5

  • If Miles—1 point for each 10,000 miles, divide Current Usage by 10,000
  • If Hours—1 point for each 250 Hours, divide Current Usage by 250
  • If Kilometers—1 point for each 16000 KM, divide Current Usage by 16000

Service Type calculation:

  • An Attribute of the Equipment record
  • Cannot less than 0 or greater than 5

Reliability calculation:

  • Find the number of Tasks related to the equipment that do not have an activity of Accident (N)
  • Determine days since In Service Date and divide by 90 to get how many 90 day periods: (D)
  • Divide Task count by the number of 90 day periods: (N/D) = (W, or # of Tasks per 90 day period)
  • Get the User input from System Settings for VRR Reliability: (X)
  • Divide User input by 5 to get correct scale: (X / 5) = (Y)
  • Divide Task per 90 days by scale: (W / Y) = Score
  • Cannot be less than 0 or greater than 5

M & R calculation:

If there is not a purchase cost or the purchase cost of the equipment is 0: M&R is not calculated

If there are no Tasks or none of the Tasks have a total cost: M&R is 0

COST = Sum the total cost for all tasks that do not have an activity of Accident|
PERC = Determine the cost percentage cost is of the Purchase Cost ((COST / PURCHASE COST) * 100)
MRSet = System setting for VRR M and R
ADJMR = (MR / 100)—Scale adjustment value
MR = ((PERC * .05) / ADJMR)

Calculated value must be between 0 and 5 inclusive

Condition calculation:

  • Convert our 100 point scale to a 5 point scale
  • 5 - (Estimated OCI * 0.05)
  • Invert the value
  • Cannot be less than 0 or greater than 5

VRR Total:

The sum of the all of the above calculations.

Fleet Average calculation:

  • Find all Equipment records with the same Equipment Classification
  • Find the average of all the VRR scores.
  • Do not include equipment with a null VRR
  • Was this article helpful?