CalAmp reports are designed to return a wide variety of data in order to fulfill the needs of all our customers, as you can see in What Reports Are Available in the New Platform?. We have endeavored to make the report results as self-explanatory as possible, but you may not readily understand what all the column data values mean, just from the heading. The following table explains how some of those values are calculated. The column names are presented alphabetically within each report category.
Note: Some column explanations apply to more than one category. For these, the column row will appear only in the first applicable category, so be sure to check earlier report types if you don't see what you're looking for under a certain heading (or perform a browser search from the top of the article).
| Column Name | How This Is Calculated |
| Asset Activity Reports | |
| % Utilization | The average of the total work time (total engine time minus the total waste idle time), multiplied by 100. Note: The expected work time (the number of hours the engine is supposed to be operating per day) is set at eight hours in the system, but that can be changed via a request to your customer success manager (CSM). The above calculation is divided by the result of the expected work time multiplied by the active day indicator. |
| Active Days | The number of days that the asset is active in the specified time range are added up; active means that the asset has had its ignition on and moved a distance greater than .5 miles. |
| Carbon Footprint | The total fuel consumed is multiplied by .008887. (The EPA, along with the Department of Transportation, published the CO2 conversion factor of .008887 metric tons of CO2e emitted per gallon of gasoline consumed in order to determine a product's carbon footprint.) |
| Normal Utilized Time | The total engine time, if this is LESS THAN the expected work time multiplied by the sum of active days. Otherwise, the expected work time multiplied by the sum of active days. (In other words, the asset has been used a normal or less amount of time.) |
| Odometer | The column headings GPS Odometer and True Odometer will usually report different values, as the former is calculated based on readings from GPS events, and the latter is the actual odometer reading in the vehicle. |
| Over Utilized Time | The total engine time minus the expected work time multiplied by the sum of active days, if the total engine time is GREATER THAN the expected work time multiplied by the sum of active days. (In other words, the asset has been used over its expected amount of time.) |
| Total Engine Time | The time the engine was running (as reported by the device accumulator) is added up for the date range, including both idling and moving hours. |
| Total Idle Cost | The total idle time is multiplied by the fuel consumption rate (per hour) and fuel price you enter. |
| Total Idle Time | The time difference between moving events (while the engine is running) is added up for the time frame. The moving event/idle data is reported to CalAmp by the device accumulator. Note: The total idle time includes both working idle time and waste idle time. Working idle time is defined as engine idling that is expected within a normal work pattern, and waste idle time is engine idling that is unnecessary (and thus causing excess fuel usage and cost). |
| Total Stops | The count of all the times an asset stops along its route, including both work stops and personal stops (which are assesed as stops shorter than 300 seconds). |
| Total Work Time | The waste idle time is subtracted from the total engine time. |
| Travel Time | The number of hours the asset has been in motion (moving time) is added to the total stop time. |
| Work Stops | The number of work stops (stops that are required on an asset's route for work purposes, such as unloading cargo) are added up for the day. Stops are processed as work stops if they are longer than 300 seconds. |
| Exception Management Reports | |
| Association Mileage | The number of miles the driver has been operating their asset since their association. |
| Over Limit (mph) | The driver's speed at the time of the reported event minus the posted speed limit. This disregards the Over Speed Threshold you specify and is raw data. |
| Fuel & Energy | |
| Fuel Efficiency | The total distance the asset has traveled is divided by the total fuel consumed. |
| Fuel Stops | All the stops made by the asset for the purpose of refueling are summed up. Note: This is available only with WEX fuel card integration (see Integrating a WEX Fuel Card). |
| Private Distance Driven (Miles) | The total number of miles the asset traveled on a toll road. |
| Public Distance Driven (Miles) | The total number of miles the asset traveled on a public road (not a toll road). |
| Total Fuel & Energy Efficiency (mpg) | The total distance traveled is divided by the fuel or energy consumed. |
| Geofence Reports | |
| Asset Type/Category Count | All the assets that entered the geofence are added for the total count. |
| Working Time | The total engine hours within the geofence minus the total idle time. |
| Maintenance Reports | |
| Days
Remaining | The number of days on the calendar is counted up to the day the maintenance is reported as being due. |
| Engine Hours Remaining | The reported engine hours value at which maintenance was entered as being due minus the last recorded engine hours count. |
| Odometer
Remaining | The reported odometer value at which maintenance was entered as being due minus the last recorded odometer reading. |
| Third Party Integration Reports | |
| Anti Ice | The amount of anti-ice material that was dispensed (in gallons or liters). |
| Dry Distance | The total number of miles or kilometers that dry material was spread. |
| Granular | The amount of granular material that was dispensed (in pounds or kilograms). |
| Granular Actual Rate | The reported application rate at which the granular material was dispensed (in pounds per linear foot). |
| Granular Set Rate | The application rate you set for spreading granular material (in pounds per mile or kilograms per kilometer). |
| Granular Spread Rate Index | The granular set rate in terms of the index from 0 to 10. |
| Granular Target Rate | The application rate you are targeting for spreading granular material (in pounds per linear foot). |
| Liquid Actual Rate | The reported application rate at which the liquid was dispensed (in gallons per linear foot). |
| Liquid Target Rate | The application rate you are targeting for dispensing liquid (in gallons per linear foot). |
| Pre Wet | The amount of pre-wet material that was dispensed (in gallons or liters). |
| Trip, Stop, & Location Activity Reports | |
| % of Day at Geofences | The total amount of driving within geofences is multiplied by 100 and then divided by the work day duration time. |
| % of Day Traveling | The total amount of work stop time is multiplied by 100 and then divided by the work day duration time. |
| % of Day at Work Stops | The total amount of trip stop time is multiplied by 100 and then divided by the work day duration time. |
| % Fuel Consumed Idling | The total amount of fuel used during idling events is divided by the total fuel consumption and then multiplied by 100. |
| Active Operator Days | All the days that the driver drove over .5 miles are added up within the specified time frame. |
| Co-location Stop Time per Co-location Stop | The amount of stop time spent at the same location as another asset divided by the total number of co-location stops. |
| Driver Score | A driver's score begins at 100 and is decreased a certain percentage for each safety violation. For simple point events (harsh acceleration, harsh braking, and harsh cornering), the score is figured using the count of each event multiplied by its assigned percentage weight, dividing by the total miles/kilometers driven, and then multiplying by 1000. For duration events, such as speeding, the score is evaluated by multiplying the total distance traveled in each speeding category by the category's assigned weight, dividing by the total miles/kilometers driven, and then multiplying by 100. (See the articles in the Driver Scoring folder for more details.) |
| Geofence Stop Time per Geofence Stop | The amount of time spent at all the driver's work stops within geofences divided by the total number of geofence work stops. |
| Work Day Duration | The number of seconds from the first recorded Ignition On event to the last Ignition Off event are counted. |
| Work Stop Time per Work Stop | The amount of time spent at all the driver's work stops is divided by the total number of work stops. |