This report will provide the asset’s fuel consumption for a selected date range. A benefit of this report is it allows you to filter on zones, reporting fuel use in off-road applications.
The J3 data geo-code and the fuel information is sent in real time, not at the end of the trip.
The Fuel information is delivered from the asset’s Engine Control Module (ECM). Select one of your assets and date and time range. To access the Jbus Fuel Path Report, from the main menu click Reports, then go to Fuel Diagnostics & Usage and click Fuel Path.
This report is not used for electric vehicles.
Path Controls | |
Map | Idle events |
Results |
Filters
Asset | Select an asset for which run the report. |
Zone Filter | (Optional) Select the zone in which to report fuel usage. |
Date Range | Select the time and date range to display. |
Once the desired filters are selected, click Generate Report to show results.
Map
The report will produce the asset’s path on the map and the amount of fuel used during the trip in the fuel path data section. For map help, see Map Overview.
Results
Asset No. | Displays the asset number. |
Date Range | The date and time the asset was traveling. |
Distance | Total distance traveled in the time frame. |
Fuel Used | Total amount of fuel used for the distance traveled. |
Export | Choose a format to export the path report: Shapefile for ArcGIS CSV file for Excel CSV file with addresses |
Export Options
Shapefile
Shapefile exports are a ZIP file containing four files: DBF, SHP, SHX, and PRJ. This ZIP file can be used with geographic information system (GIS) applications such as ArcGIS. More information can be found on the Shapefile Wikipedia page.
CSV file
The CSV file is a human-readable file that can be opened in Excel. It provides the same information as the map-based path report, but in a spreadsheet. This file can be customized extensively via the API (refer to Export A Path documentation), but the export on the website provides the following data:
Column Header | Excel Column | Data Description |
Asset ID | A | Internal database ID of the asset |
Asset No. | B | The asset number of the vehicle |
Date | C | The date in MM/DD/YYYY format |
Time(PST) | D | The time in HH:MM:SS format (24-hour) Parentheses indicates timezone used |
Speed(MPH/KPH) | E | Speed of the asset using listed units |
Heading | F | Cardinal direction in which vehicle is moving |
Log Reason | G | Indicates the type of GPS point |
Distance Traveled (Miles/Kilometers) | H | Distance traveled since the beginning of the time range of the report using listed units. This value will always begin at 0, even if the vehicle was in motion immediately prior to the time range of the report. |
Lat | I | GPS latitude |
Lon | J | GPS longitude |
Zone | K | The name of the smallest geofence in which the GPS point was logged |
Fuel Counter (Gallon/Liter) | L | The fuel counter provided by the ECM. Fuel data for a given trip is calculated by comparing the fuel counter at the beginning of the trip to the end. |
Acceleration (Miles/Hour/Sec) (Meters/Hour/Sec) | M | The acceleration calculating by comparing the speed of that logged point to the speed from the previous second (whether logged or not). A negative number indicates deceleration, or slowing down. |
Status Mask | N | A bitmask encoding of information sent with the GPS point. To decode the Status value, refer to Status Mask.
Refer to Reason column for the same information in user-readable format. |
Address | O | Blank for CSV file option. |
CSV file with addresses
This option is exactly the same as the CSV file, except the Address field is filled in:
Column Header | Excel Column | Data Description |
Address | O | Shows the closest available address Address is reverse-geocoded by HERE based on the latitude/longitude |