You can extend external matrices during an arithmetic operation, i.e. you can add columns and rows. To do so, choose an arithmetic operation that allows you to combine external matrices with matrices that have different OD pairs.
You can use any arithmetic operation that requires a second operand, e.g. the basic ones or forming the maximum or minimum.
The matrix data is calculated as follows:
- The arithmetic operation is performed for the OD pairs that occur in all matrices.
- If an OD pair is not listed in all matrices, a null is entered for it before the arithmetic operation is performed. Then the arithmetic operation is performed.
- For OD pairs that are not listed in any of the matrices, a default value is set in the results matrix.
Example of extending a matrix
On the addition, the two matrices are extended. The default value specified for new OD pairs is 99.
- Matrix in Matrix editor window
|
|
1 |
2 |
3 |
|
1 |
1 |
1 |
1 |
|
2 |
1 |
1 |
1 |
|
3 |
1 |
1 |
1 |
- Matrix chosen as operand
|
|
1 |
2 |
4 |
5 |
|
1 |
2 |
2 |
2 |
2 |
|
2 |
2 |
2 |
2 |
2 |
|
4 |
2 |
2 |
2 |
2 |
|
5 |
2 |
2 |
2 |
2 |
- Matrix extended on addition
|
|
1 |
2 |
3 |
4 |
5 |
|
1 |
3 |
3 |
1 |
2 |
2 |
|
2 |
3 |
3 |
1 |
2 |
2 |
|
3 |
1 |
1 |
1 |
99 |
99 |
|
4 |
2 |
2 |
99 |
2 |
2 |
|
5 |
2 |
2 |
99 |
2 |
2 |
