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.7 Column: Site Time
Required: No.
Type: Text (HH:MM).
Default: 00:00.
Description: Minimum time spent at the location. (See Site Time in Section x14-240002.102.10.)
3.5.8 Column: Load Time
Required: No.
Type: Text (HH:MM).
Default: 00:00.
Description: Time spent for loading at the location. (See Load Time in Section x14-240002.102.10.)
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 x14-240002.102.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 x14-240002.102.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 x14-240002.102.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 x14-240002.102.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.

