4.3 Sheet: Load Summary
If batched loads is enabled, then this sheet is a summary of each load for each vehicle.
4.3.1 Column: Vehicle
Type: Text.
Description: The identifier of the vehicle as given by the Id column of the Fleet sheet.
4.3.2 Column: Load Number
Type: Number.
Description: The number of the load.
4.3.3 Column: Peak Volume
Type: Number.
Description: The highest volume achieved during the load.
4.3.4 Column: Volume Capacity
Type: Number.
Description: The maximum volume capacity of the vehicle as defined in the Fleet sheet.
4.3.5 Column: Peak Weight
Type: Number.
Description: The highest weight achieved during the load.
4.3.6 Column: Weight Capacity
Type: Number.
Description: The maximum weight capacity of the vehicle as defined in the Fleet sheet.
4.3.7 Column: Loaded Distance
Type: Number.
Description: The transit distance from the first pickup to the last delivery in the load.
4.3.8 Column: Empty Distance Before
Type: Number.
Description: For the first load, this is the distance from the START stop to the first pickup; otherwise it is the distance
from the final delivery of the previous load to the first pickup of this load.
4.3.9 Column: Empty Distance After
Type: Number.
Description: For the final load, this is the distance from the final delivery to the FINISH stop; otherwise it is the
distance from the final delivery of this load to the first pickup of the next load.
4.3.10 Column: Work Time
Type: Excel time.
Description: The total time spent between the first stop and last stop in the load by the vehicle.
4.3.11 Column: Transit Time
Type: Excel time.
Description: The time spent in transit by the vehicle for this load.
4.3.12 Column: Site Time
Type: Excel time.
Description: The site time incurred by the vehicle for this load. (See Site Time in Section x14-240002.102.10.)
4.3.13 Column: Load Time
Type: Excel time.
Description: The total load time incurred by the vehicle for this load. (See Load Time in Section x14-240002.102.10.)
4.3.14 Column: Unload Time
Type: Excel time.
Description: The total unload time incurred by the vehicle for this load. (See Unload Time in
Section x14-240002.102.10.)
4.3.15 Column: Service Time
Type: Excel time.
Description: The total service time incurred by the vehicle for this load. (See Service Time in Section x16-380002.122.12.)
4.3.16 Column: Idle Time
Type: Excel time.
Description: The time spent idle by the vehicle for this load.
4.3.17 Column: Break Time
Type: Excel time.
Description: The time spent on breaks by the vehicle for this load.
4.3.18 Column: Number Of Drops
Type: Number.
Description: The number of deliveries in the load such that consecutive deliveries at the same location are only
counted once.
4.3.19 Column: Average Transit Speed
Type: Number.
Description: The average speed of the vehicle during the load. 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.3.20 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 in
the load.
4.3.21 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 in the
load.
4.3.22 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 in
the load.
4.3.23 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 in the
load.

