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, then this is the 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 x25-500002.212.21 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: Customer Name
Type: Text.
Description: If the stop is a PICKUP or DELIVERY stop, then this contains the name of the customer for
the order from the Orders sheet. This column will be omitted if all of the orders have blank customer
names.
4.1.9 Column: Delivery Name
Type: Text.
Description: If the stop is a PICKUP or DELIVERY stop, then this contains the name of the delivery for
the order from the Orders sheet. This column will be omitted if all of the orders have blank delivery
names.
4.1.10 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.11 Column: Address
Type: Text.
Description: The identifier of the stop location as defined in the Locations sheet.
4.1.13 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.14 Column: Weight
Type: Number.
Description: The total weight on the vehicle at the stop.
4.1.15 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.16 Column: Site Time
Type: Excel time.
Description: The site time incurred at the stop. (See Site Time in Section x14-240002.102.10.)
4.1.17 Column: Load Time
Type: Excel time.
Description: The load time incurred at the stop. (See Load Time in Section x14-240002.102.10.)
4.1.18 Column: Unload Time
Type: Excel time.
Description: The unload time incurred at the stop. (See Unload Time in Section x14-240002.102.10.)
4.1.19 Column: Service Time
Type: Excel time.
Description: The service time incurred at the stop. (See Service Time in Section x16-380002.122.12.)
4.1.20 Column: Transit Time
Type: Excel time.
Description: The transit time between the previous stop and this one.
4.1.21 Column: Transit Distance
Type: Number.
Description: The transit distance between the previous stop and this one.
4.1.22 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.23 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.24 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.

