4.3 Sheet: Load Summary

If batched loads is enabled, this sheet is a summary of the Runsheet data for each load in 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  2.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  2.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  2.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  2.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.