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: Peak Volume

Type: Number.
Description: The highest volume achieved during the vehicle’s route.

4.2.5 Column: Total Volume

Type: Number.
Description: The total volume carried during the vehicle’s route.

4.2.6 Column: Volume Capacity

Type: Number.
Description: The maximum volume capacity of the vehicle as defined in the Fleet sheet.

4.2.7 Column: Peak Weight

Type: Number.
Description: The highest weight achieved during the vehicle’s route.

4.2.8 Column: Total Weight

Type: Number.
Description: The total weight carried during the vehicle’s route.

4.2.9 Column: Weight Capacity

Type: Number.
Description: The maximum weight capacity of the vehicle as defined in the Fleet sheet.

4.2.10 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  2.19.)

4.2.11 Column: Transit Distance

Type: Number.
Description: The total transit distance of the vehicle in the route.

4.2.12 Column: Loaded Distance

Type: Number.
Description: The total transit distance of the vehicle while it is carrying at least one order.

4.2.13 Column: Empty Distance

Type: Number.
Description: The total transit distance of the vehicle while it is empty.

4.2.14 Column: Actual Start Time

Type: Excel time.
Description: The time of arrival at the START stop in the route for the vehicle.

4.2.15 Column: Actual Finish Time

Type: Excel time.
Description: The time of departure at the FINISH stop in the route for the vehicle.

4.2.16 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.17 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.18 Column: Transit Time

Type: Excel time.
Description: The total time spent in transit by the vehicle.

4.2.19 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.20 Column: Site Time

Type: Excel time.
Description: The total site time incurred by the vehicle. (See Site Time in Section  2.10.)

4.2.21 Column: Load Time

Type: Excel time.
Description: The total load time incurred by the vehicle. (See Load Time in Section  2.10.)

4.2.22 Column: Unload Time

Type: Excel time.
Description: The total unload time incurred by the vehicle. (See Unload Time in Section  2.10.)

4.2.23 Column: Service Time

Type: Excel time.
Description: The total service time incurred by the vehicle. (See Service Time in Section  2.12.)

4.2.24 Column: Idle Time

Type: Excel time.
Description: The total time spent idle by the vehicle.

4.2.25 Column: Break Time

Type: Excel time.
Description: The total time spent on breaks by the vehicle.

4.2.26 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.27 Column: Number Of Orders

Type: Number.
Description: The number of orders assigned to the vehicle.

4.2.28 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.29 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.30 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.31 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.32 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.