3.5 Sheet: Locations

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

3.5.1 Column: Id

Required: Yes.
Type: Text or (integer) number.
Description: A unique identifier for the location.

3.5.2 Column: Name

Required: No.
Type: Text or (integer) number.
Description: A name for the location (e.g. a store or facility name).

3.5.3 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.4 Column: Address

Required: No.
Type: Any.
Description: The full street address of the location.

3.5.5 Column: Longitude

Required: Yes.
Type: Number.
Description: Longitude of the location in decimal degrees between -180 and 180.

3.5.6 Column: Latitude

Required: Yes.
Type: Number.
Description: Latitude of the location in decimal degrees between -90 and 90.

3.5.9 Column: Unload Time

Required: No.
Type: Text (HH:MM).
Default: 00:00.
Description: Time spent for unloading at the location. (See Unload Time in Section  2.10.)

3.5.10 Column: Opening Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: Earliest opening time for the location.

3.5.11 Column: Closing Time

Required: No.
Type: Excel time.
Default: No closing time.
Description: Latest closing time for the location.

3.5.12 Column: Operating Time Windows

Required: No.
Type: Text or (integer) number.
Default: No time windows.
Description: The identifier of the time window as defined in the Time Windows sheet. (See Location Time Windows in Section  2.10).

3.5.13 Column: Cost per Visit

Required: No.
Type: Number.
Default: 0.
Description: The cost incurred when a vehicle visits this location. This may be negative to represent gains associated with visiting the location. (See Cost per Visit in Section  2.10.)

3.5.14 Column: Hidden Cost per Visit

Required: No.
Type: Number.
Default: 0.
Description: An additional cost incurred when a vehicle visits this location. This may be negative and is not included in the cost calculation for the solution. (See Hidden Cost per Visit in Section  2.10.)

3.5.15 Column: Loading Bays

Required: No.
Type: Number (nonnegative integer).
Default: 0.
Description: The number of loading bays at this location.

3.5.16 Column: Loading Bay Gap

Required: No.
Type: Excel time.
Default: 00:00.
Description: The loading bay gap at this location.

3.5.17 Column: Allow Preloading

Required: No.
Type: Text (Boolean).
Description: If TRUE, then vehicles can preload at this location.
Note: See Preloading for more information.

3.5.18 Column: Allow Splitting

Required: No.
Type: Text (Boolean).
Description: If TRUE, then orders that are picked up or delivered to this location can be split according to the order splitting strategy.
Note: The order must also allow splitting for this to take effect.