This report shows the list of trips executed by vehicle/driver. Data is presented exactly like in the trips table of the Vehicle detailed report, but here a period of up to a month can be viewed.
The period must always be a multiple of quarters. For example, it can start at 9:15, but not at 9:10. This way, the report can use the 15 minutes slots for the trips that are not fully included in the period.
The report can be generated for vehicles, for drivers, driver status, or teams, for a period of up to one month.
Configuration
To generate the report, you must provide the following settings:
| Configuration | Description |
| Period |
The period the report will be generated for. Options:
|
| Show information by |
Here you must choose the source of the information. It can be:
Once you select one source, you must select which components will be used to filter the report. For instance, if I want my report to be generated for some vehicles of my fleet, I first select Vehicles and then choose their License plates in the next selector: This selection slightly changes the output of the report. |
| Show mileage chart |
If you select this option, a bar chart will be added to the report, to show the mileage per driver. This option is not available for the Authorities format of this report. |
| Show trips of | Allows filtering trips based on the organization (department and segment); the filter is based on the department and segment to which trips are associated; |
| Authorities format |
This option changes the format of the report to be compatible with some European authorities. Unless it's mandatory for your company to submit this report to the authorities, this option should not be used. |
| Trips limit |
Trips intercepted by report limits allows you to choose which trips are shown in the report, by selecting one of the following three options:
|
| Show report |
Detailed, Summarized by period, Summarized by day |
The report will group vehicles by their energy type and use the correct units and totals.
Output
This is an example of the output of the report.
The report must contain only one row per day for each vehicle/driver. The only exception to this rule is when the vehicle was driven by more than one driver that day. In this case, each change of driver will have a different row.
At the very top, the mileage chart is present (if you select this option in the Configurations), followed by the table described below:
| Column | Description |
| Vehicle | The column Vehicle is only available if you choose to generate the report per Driver. In this case, the header of the report becomes the Driver and the column is added to the table. Otherwise, the header is the License plate of the vehicle, and the column is not visible. |
| Departure Time | Date and time when the trip started. If the trip started before the period, this field shows the beginning of the reported period. |
| Departure place | Name of the place where the trip started, when the trip started inside a place defined in the account. Empty otherwise. This field is also empty when the trip started before the beginning of the period. |
| Departure Address | The address where the trip started or empty if the trip started before the period. |
| Start Odometer | The vehicle odometer when the trip started. If the trip started before the beginning of the period, the column shows the odometer at the start of the report (read from the corresponding 15 minutes slot). This odometer comes from GPS or CANBus, depending on the vehicle configuration |
| Arrival Time | Date and time when the trip ended. If the trip ended after the period, this field shows the end of the reported period. The field is empty if the trip did not finish at the time of report generation. |
| Arrival place | Name of the place where the trip end, when the trip end inside a place defined in the account. Empty otherwise. This field is also empty when the trip ended after the end of the period or if it did not finish yet. |
| Arrival Address | The address where the trip ended or empty if the trip ended after the period or did not finish at the time of report generation. |
| Arrival Odometer | The vehicle odometer when the trip ended. If the trip ended after the end of the period, the column shows the odometer at the end of the report (read from the corresponding 15 minutes slot). The field is empty if the trip is not finished yet. This odometer comes from GPS or CANBus, depending on the vehicle configuration |
| Driver | The driver using the vehicle during the trip. For the record, the driver of a trip is always the one that finished the trip. In case there was a driver and a co-driver, both names are presented with a pipe as a separator |
| Duration Driving | The time during which the vehicle was moving. Calculated as Duration Total - Duration Idle. |
| Duration Idle | The time during which the vehicle was not moving. When the trip is not fully enclosed in the reported period, the Idle time is obtained from the 15-minute slots that lie inside the reported period. |
| Duration Total |
Total trip duration = Arrival time - Departure time. If the trip started before the reported period, Departure time is replaced by the beginning of the reported period. In the same way, if the trip ended after the reported period, Arrival time is replaced by the end of the reported period. If the reported period includes the present time and the trip has not finished yet, the Arrival time is replaced by the current time. Finally, if the trip did end yet, but the reported period does not include the present time, this means that the device is late sending the data, and the Duration Total field should be left empty, as well as the Duration Driving field. |
| Mileage | The total mileage of the trip (km/mi). Values from the corresponding 15-minute slots should be used if the trip is not fully enclosed in the reported period. The field should be empty if the trip did not finish yet. |
| Cost | This field shows the result of multiplying the calculated Mileage by the cost per km/mi. |
| Max. Speed | Shows the maximum speed the vehicle has reached for this trip. If the trip is not fully enclosed within the reported period, show the maximum value of all 15 minutes slots of the trip that lie inside the reported period. |
| Mean Speed | For trips fully enclosed in the reported period, Mean Speed = Speed Sum / Sample count. If the trip is not fully enclosed within the reported period, it takes into consideration all 15 minutes slots of the trip that lie inside the reported period. |
| Stop | Amount of time the vehicle remained stopped, calculated as the time between Arrival Time of the trip and Departure Time of next trip. If the trip ended after the period or did not end yet, leave this field empty. |
| Alarms | The number of alarms triggered by the vehicle during the trip. The background of the cell is red if there were alarms triggered during the trip. |
| Departments | The codes of the departments associated with the trip (if available) |
| Energy consumption | Shows the numbers of Energy consumption (total and per 100 km/mi) for the trip |
Authorities format
If you choose to generate the report with the Authorities format, the report will have the following format:
Summarized by period
This is an example of the output of the report.
By Driver
By Vehicle
The table is described below:
| Column | Description |
| Vehicle or Driver | The column Vehicle/Driver is only available if you choose to generate the report per vehicle/driver. |
| Department | The name of the departments associated with the trip (if available). |
| Segment | The name of the segments associated with the trip (if available). |
| Driving | The time moving, for trips associated with the vehicle/driver. Calculated as Duration Total - Duration Idle. |
| Idle | The time not moving, for trips associated with the driver. |
| Total | Total duration of trips associated with the driver. |
| Driving (%) | The percentage of time moving (Driving/Total). |
| Idle (%) | Percentage of time in trips but not moving (Idle/Total). |
| Mileage | The total mileage of the period (km/mi). |
| Max Speed | The maximum speed the vehicle has reached for the period selected. |
| Mean Speed | The mean speed that the vehicle has reached for the period selected |
| L/100km | The total fuel consumption per 100km for the trip of the period selected (L or G). |
| Nr. trips |
Number of Trips. |
| Nr. days with trips | Number days with trips |
Note: Only trips or slice of trips inside the report period are considered (Trips Limits = Split).
Summarized by Day
This is an example of the output of the report.
By Driver
By Vehicle
The table is described below:
| Column | Description |
| Vehicle or Driver | The column Vehicle/Driver is only available if you choose to generate the report per vehicle/driver. |
| Day date | Day of the trip. |
| Date First trip | Date/time of the first trip. |
| Date Last trip | The time moving, for trips associated with the vehicle/driver. Calculated as Duration Total - Duration Idle. |
| Idle | The time not moving, for trips associated with the driver. |
| Total | Total duration of trips associated with the driver. |
| Driving (%) | The percentage of time moving (Driving/Total). |
| Idle (%) | Percentage of time in trips but not moving (Idle/Total). |
| Mileage | The total mileage of the period (km/mi). |
| Max Speed | The maximum speed the vehicle has reached for the period selected. |
| Mean Speed | The mean speed that the vehicle has reached for the period selected |
| L/100km | The total fuel consumption per 100km for the trip of the period selected (L or G). |
| Nr. trips |
Number of Trips. |
Note: Only trips or slice of trips inside the report period are considered (Trips Limits = Split).
Comments