4.1 Sheet: Runsheet

4.1.1 Column: Vehicle

Type: Text.
Description: The identifier of the vehicle as given in Id column of the Fleet sheet.

4.1.2 Column: Load

Type: Number.
Description: If batched loads is enabled, this is index of the current load.

4.1.3 Column: Stop Number

Type: Number.
Description: Numerical identification of a stop generated by the optimiser. Stops are numbered from 0 in increasing order with each stop number being unique.

4.1.4 Column: ETA

Type: Excel time.
Description: The “Estimated Time of Arrival” of the vehicle at the location.

4.1.5 Column: ETD

Type: Excel time.
Description: The “Estimated Time of Departure” of the vehicle from the location.

4.1.6 Column: Stop

Type: Text.
Description: The type of stop. See Section  2.18 for further information.

4.1.7 Column: Order

Type: Text.
Description: If the stop is a PICKUP or DELIVERY stop then this contains the identifier of the order in the Orders sheet. For START, FINISH and BREAK stops this will be blank.

4.1.8 Column: Compartment

Type: Text.
Description: If the vehicle has compartments and the stop is a PICKUP or DELIVERY stop then this contains the identifier of the compartment that the order is assigned to. For START, FINISH and BREAK stops this will be blank.

4.1.9 Column: Address

Type: Text.
Description: The identifier of the stop location as defined in the Locations sheet.

4.1.10 Column: Volume

Type: Number.
Description: The total volume on the vehicle at the stop.

4.1.11 Column: Delta Volume

Type: Number.
Description: The change in volume at the stop. Positive values represent an increase in volume, while negative values represent a decrease.

4.1.12 Column: Weight

Type: Number.
Description: The total weight on the vehicle at the stop.

4.1.13 Column: Delta Weight

Type: Number.
Description: The change in weight at the stop. Positive values represent an increase in weight, while negative values represent a decrease.

4.1.14 Column: Site Time

Type: Excel time.
Description: The site time incurred at the stop. (See Site Time in Section  2.10.)

4.1.15 Column: Load Time

Type: Excel time.
Description: The load time incurred at the stop. (See Load Time in Section  2.10.)

4.1.16 Column: Unload Time

Type: Excel time.
Description: The unload time incurred at the stop. (See Unload Time in Section  2.10.)

4.1.17 Column: Service Time

Type: Excel time.
Description: The service time incurred at the stop. (See Service Time in Section  2.12.)

4.1.18 Column: Transit Time

Type: Excel time.
Description: The transit time between the previous stop and this one.

4.1.19 Column: Transit Distance

Type: Number.
Description: The transit distance between the previous stop and this one.

4.1.20 Column: Soft Time Window Start

Type: Excel time.
Description: If the order has a soft time window for the current stop type, then the start time of the window closest to the stop arrival time.

4.1.21 Column: Soft Time Window End

Type: Excel time.
Description: If the order has a soft time window for the current stop type, then the end time of the window closest to the stop arrival time.

4.1.22 Column: Soft Time Window Delta

Type: Excel time.
Description: If the order has a soft time window for the current stop type, then the time difference between the stop arrival time and the closest boundary of the time window defined by the Soft Time Window Start and Soft Time Window End columns.