3.28 Sheet: Matrix Override

The Matrix Override sheet may be used to override the routing times and distances between pairs of locations in the Locations sheet.

Times in route matrix overrides are affected by speed scaling and rush hour constraints as normal.

This sheet is optional. If omitted, then the optimiser will either use the provided matrices or compute them.

3.28.1 Column: Location 1

Required: Yes.
Type: Text or (integer) number.
Description: The identifier of location from the Location sheet.

3.28.2 Column: Location 2

Required: Yes.
Type: Text or (integer) number.
Description: The identifier of location from the Location sheet.

3.28.3 Column: Time Forwards

Required: No.
Type: Number (positive).
Description: The transit time, in minutes, when travelling from “Location 1” to “Location 2”.

3.28.4 Column: Time Backwards

Required: No.
Type: Number (positive).
Description: The transit time, in minutes, when travelling from “Location 2” to “Location 1”.

3.28.5 Column: Distance Forwards

Required: No.
Type: Number (positive).
Description: The transit distance, in kilometres, when travelling from “Location 1” to “Location 2”.

3.28.6 Column: Distance Backwards

Required: No.
Type: Number (positive).
Description: The transit distance, in kilometres, when travelling from “Location 2” to “Location 1”.

Location 1 Location 2 Time Forwards Time Backwards Distance Forwards Distance Backwards
DEPOT Hallam 0 0 0 0
DEPOT Skye 0 0 0 0
DEPOT Rowville 0 0 0 0
Table 5: Matrix Override Example