This sheet must be defined and contain at least one order.
Required: Yes.
Type: Text or (integer) number.
Description: A unique identifier for the order. An order’s identifier also acts as an attribute
name.
Required: No.
Type: Text.
Description: A descriptive name for the order (e.g. a purchase order).
Required: Yes.
Type: Text or (integer) number.
Description: An identifier from the Locations sheet.
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section 2.12.)
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.
Required: No.
Type: Excel time.
Default: Inferred from data.
Description: A nonnegative time.
Required: No.
Type: Text.
Default: Can occur at any time subject to the pickup location’s and vehicles’ time windows.
Description: The identifier of the time window as defined in the Time Windows sheet. (See Order Time
Windows in section 2.12.)
Required: No.
Type: Text.
Default: Can occur at any time subject to the pickup location’s, order’s and vehicles’ time
windows.
Description: The identifier of the time window as defined in the Time Windows sheet.
Required: No.
Type: Number.
Default: 0.
Description: The fixed penalty for the order’s pickup soft time windows.
Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for the order’s pickup soft time windows.
Required: Yes.
Type: Text or (integer) number.
Description: A location identifier from the Locations sheet.
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section 2.12.)
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.
Required: No.
Type: Excel time.
Default: No latest delivery time.
Description: A nonnegative time.
Required: No.
Type: Text.
Default: Can occur at any time subject to locations’ and vehicles’ time windows.
Description: The identifier of the time window as defined in the Time Windows sheet. (See Order Time
Windows in section 2.12.)
Required: No.
Type: Text.
Default: Can occur at any time subject to the delivery location’s, order’s and vehicles’ time
windows.
Description: The identifier of the time window as defined in the Time Windows sheet.
Required: No.
Type: Number.
Default: 0.
Description: The fixed penalty for any pickup soft time windows associated with the order.
Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for any pickup soft time windows associated with the
order.
Required: No.
Type: Excel time.
Default: No maximum duration.
Description: The maximum duration for the order.
Required: No, but if omitted then the Volume column must be present.
Type: Number.
Default: 0.
Description: Weight of the order with units consistent with vehicles’ weight capacity.
Required: No, but if omitted then the Weight column must be present.
Type: Number.
Default: 0.
Description: Volume of the order with units consistent with vehicles’ volume capacity.
Required: No.
Type: Number.
Default: 0.
Description: The cost incurred when servicing the order. This can be negative to represent gains
associated with servicing the order. (See Assign Cost in Section 2.12.)
Required: No.
Type: Number.
Default: 0.
Description: Additional fixed cost to service the order. This can be negative and is not included in the
cost calculation for the solution and may be used to prioritise certain orders. (See Hidden Assign Cost in
Section 2.12.)
Required: No.
Type: Text or (integer) number.
Description: Multiple attributes should be separated by semicolons. (Multiple attributes can only be
specified in a text cell.)