3.4 Sheet: Locations

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

3.4.1 Column: Id

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

3.4.2 Column: Name

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

3.4.3 Column: Attributes

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

3.4.4 Column: Address

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

3.4.5 Column: Longitude

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

3.4.6 Column: Latitude

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

3.4.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  2.10.)

3.4.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  2.10.)

3.4.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.4.10 Column: Opening Time

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

3.4.11 Column: Closing Time

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

3.4.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.4.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.4.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.)