4.2 Sheet: Vehicle Summary
This sheet is a summary of the Runsheet data for each vehicle.
4.2.1 Column: Vehicle
Type: Text.
Description: The identifier of the vehicle as given by the Id column of the Fleet sheet.
4.2.2 Column: Used
Type: Text (Boolean).
Description: TRUE if the vehicle has at least one order assigned to it.
4.2.3 Column: Cost
Type: Number.
Description: The cost incurred by the vehicle.
4.2.4 Column: Revenue
Type: Number.
Description: The revenue earned by the vehicle.
4.2.5 Column: Profit
Type: Number.
Description: The profit or loss for the vehicle. Profit is the difference between revenue and cost.
4.2.6 Column: Peak Volume
Type: Number.
Description: The highest volume achieved during the vehicle’s route.
4.2.7 Column: Total Volume
Type: Number.
Description: The total volume carried during the vehicle’s route.
4.2.8 Column: Volume Capacity
Type: Number.
Description: The maximum volume capacity of the vehicle as defined in the Fleet sheet.
4.2.9 Column: Peak Weight
Type: Number.
Description: The highest weight achieved during the vehicle’s route.
4.2.10 Column: Total Weight
Type: Number.
Description: The total weight carried during the vehicle’s route.
4.2.11 Column: Weight Capacity
Type: Number.
Description: The maximum weight capacity of the vehicle as defined in the Fleet sheet.
4.2.12 Column: Number Of Loads
Type: Number.
Description: If batched loads is enabled, this is the number of loads in the vehicle’s route. (See
Section x26-510002.222.22.)
4.2.13 Column: Transit Distance
Type: Number.
Description: The total transit distance of the vehicle in the route.
4.2.14 Column: Loaded Distance
Type: Number.
Description: The total transit distance of the vehicle while it is carrying at least one order.
4.2.15 Column: Empty Distance
Type: Number.
Description: The total transit distance of the vehicle while it is empty.
4.2.16 Column: Actual Start Time
Type: Excel time.
Description: The time of arrival at the START stop in the route for the vehicle.
4.2.17 Column: Actual Finish Time
Type: Excel time.
Description: The time of departure at the FINISH stop in the route for the vehicle.
4.2.18 Column: Work Time
Type: Excel time.
Description: The total time spent between the START and FINISH stops in the route for the vehicle.
4.2.19 Column: Allowed Work Time
Type: Excel time.
Description: The maximum work time for the vehicle as defined in the Fleet sheet. See Vehicle Times for further
information.
4.2.20 Column: Transit Time
Type: Excel time.
Description: The total time spent in transit by the vehicle.
4.2.21 Column: Allowed Transit Time
Type: Excel time.
Description: The maximum time that a vehicle can spend in transit during a route as defined in the Fleet sheet. See
Vehicle Times for further information.
4.2.22 Column: Site Time
Type: Excel time.
Description: The total site time incurred by the vehicle. (See Site Time in Section x14-240002.102.10.)
4.2.23 Column: Load Time
Type: Excel time.
Description: The total load time incurred by the vehicle. (See Load Time in Section x14-240002.102.10.)
4.2.24 Column: Unload Time
Type: Excel time.
Description: The total unload time incurred by the vehicle. (See Unload Time in Section x14-240002.102.10.)
4.2.25 Column: Service Time
Type: Excel time.
Description: The total service time incurred by the vehicle. (See Service Time in Section x16-380002.122.12.)
4.2.26 Column: Idle Time
Type: Excel time.
Description: The total time spent idle by the vehicle.
4.2.27 Column: Break Time
Type: Excel time.
Description: The total time spent on breaks by the vehicle.
4.2.28 Column: Number Of Drops
Type: Number.
Description: The number of deliveries such that consecutive deliveries at the same location are only counted
once.
4.2.29 Column: Number Of Orders
Type: Number.
Description: The number of orders assigned to the vehicle.
4.2.30 Column: Average Transit Speed
Type: Number.
Description: The average speed of the vehicle. This is derived by dividing the total transit distance
by the total transit time. Units are in Km/h by default and Mph if Use Miles in the General sheet is
TRUE.
4.2.31 Column: Pickup Soft Time Window Early
Type: Excel time.
Description: The total time the vehicle serviced an order’s pickup before the start of its closest soft time
window.
4.2.32 Column: Pickup Soft Time Window Late
Type: Excel time.
Description: The total time the vehicle serviced an order’s pickup after the end of its closest soft time
window.
4.2.33 Column: Delivery Soft Time Window Early
Type: Excel time.
Description: The total time the vehicle serviced an order’s delivery before the start of its closest soft time
window.
4.2.34 Column: Delivery Soft Time Window Late
Type: Excel time.
Description: The total time the vehicle serviced an order’s delivery after the end of its closest soft time
window.

