3.6 Sheet: Orders
This sheet must be defined and contain at least one order.
3.6.1 Column: Id
Required: Yes.
Type: Text or (integer) number.
Description: A unique identifier for the order. An order’s identifier also acts as an attribute name.
3.6.2 Column: Name
Required: No.
Type: Text or (integer) number.
Description: A descriptive name for the order (e.g. a purchase order).
3.6.3 Column: Customer Name
Required: No.
Type: Text or (integer) number.
Description: The name of the order’s customer.
3.6.4 Column: Pickup Location
Required: Yes.
Type: Text or (integer) number.
Description: An identifier from the Locations sheet.
3.6.5 Column: Pickup Name
Required: No.
Type: Text or (integer) number.
Description: A descriptive name for the pickup.
3.6.6 Column: Pickup Service Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section x16-380002.122.12.)
3.6.7 Column: Earliest Pickup Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.
3.6.8 Column: Latest Pickup Time
Required: No.
Type: Excel time.
Default: Inferred from data.
Description: A nonnegative time.
3.6.9 Column: Pickup Time Windows
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 x16-380002.122.12.)
3.6.10 Column: Pickup Soft Time Windows
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.
3.6.11 Column: Soft Pickup Constant
Required: No.
Type: Number.
Default: 0.
Description: The fixed penalty for the order’s pickup soft time windows.
3.6.12 Column: Soft Pickup Variable
Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for the order’s pickup soft time windows.
3.6.13 Column: Delivery Location
Required: Yes.
Type: Text or (integer) number.
Description: A location identifier from the Locations sheet.
3.6.14 Column: Delivery Name
Required: No.
Type: Text or (integer) number.
Description: A descriptive name for the delivery.
3.6.15 Column: Delivery Service Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section x16-380002.122.12.)
3.6.16 Column: Earliest Delivery Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.
3.6.17 Column: Latest Delivery Time
Required: No.
Type: Excel time.
Default: No latest delivery time.
Description: A nonnegative time.
3.6.18 Column: Delivery Time Windows
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 x16-380002.122.12.)
3.6.19 Column: Delivery Soft Time Windows
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.
3.6.20 Column: Soft Delivery Constant
Required: No.
Type: Number.
Default: 0.
Description: The fixed penalty for any delivery soft time windows associated with the order.
3.6.21 Column: Soft Delivery Variable
Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for any delivery soft time windows associated with the order.
3.6.22 Column: Maximum Duration
Required: No.
Type: Excel time.
Default: No maximum duration.
Description: The maximum duration for the order.
3.6.23 Column: Weight
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.
3.6.24 Column: Volume
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.
3.6.25 Column: Assign Cost
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 x16-380002.122.12.)
3.6.26 Column: Hidden Assign Cost
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 x16-380002.122.12.)
3.6.27 Column: Revenue
Required: No.
Type: Number (nonnegative).
Default: 0.
Description: The revenue earned for servicing the order.
3.6.28 Column: Attributes
Required: No.
Type: Text or (integer) number.
Description: Multiple attributes are separated by semicolons. (Multiple attributes can only be specified in a text
cell.)
3.6.29 Column: Allow Splitting
Required: No.
Type: Text (Boolean).
Description: If TRUE, then this order can be split according to the order splitting strategy.
Note: The pickup and delivery locations must both allow splitting for this to take effect.

