3.5 Sheet: Orders

This sheet must be defined and contain at least one order.

3.5.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.5.2 Column: Name

Required: No.
Type: Text.
Description: A descriptive name for the order (e.g. a purchase order).

3.5.3 Column: Pickup Location

Required: Yes.
Type: Text or (integer) number.
Description: An identifier from the Locations sheet.

3.5.4 Column: Pickup Service Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section  2.12.)

3.5.5 Column: Earliest Pickup Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.

3.5.6 Column: Latest Pickup Time

Required: No.
Type: Excel time.
Default: Inferred from data.
Description: A nonnegative time.

3.5.7 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  2.12.)

3.5.8 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.5.9 Column: Soft Pickup Constant

Required: No.
Type: Number.
Default: 0.
Description: The fixed penalty for the order’s pickup soft time windows.

3.5.10 Column: Soft Pickup Variable

Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for the order’s pickup soft time windows.

3.5.11 Column: Delivery Location

Required: Yes.
Type: Text or (integer) number.
Description: A location identifier from the Locations sheet.

3.5.12 Column: Delivery Service Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time. (See Service Time in Section  2.12.)

3.5.13 Column: Earliest Delivery Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: A nonnegative time.

3.5.14 Column: Latest Delivery Time

Required: No.
Type: Excel time.
Default: No latest delivery time.
Description: A nonnegative time.

3.5.15 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  2.12.)

3.5.18 Column: Soft Delivery Variable

Required: No.
Type: Number.
Default: 0.
Description: The variable penalty for any pickup soft time windows associated with the order.

3.5.19 Column: Maximum Duration

Required: No.
Type: Excel time.
Default: No maximum duration.
Description: The maximum duration for the order.

3.5.20 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.5.21 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.5.22 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  2.12.)

3.5.23 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  2.12.)

3.5.24 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.5.25 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.