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 |

