10.6.1   Selection by Location

Location selection essentially defines a rectangular “area” defined by lower and upper rows and/or lower and upper columns where everything in between is either “in” or “out”.  Alternatively if sectors have been defined the limits for both rows and columns may be defined by sector numbers; e.g. you may select origins (rows) in sector 1 to all destinations (columns) in sectors 2 to 6.

Post release 10.8 with “stacked” matrices (e.g., multiple user class matrices) the “selected area” definitions may be further refined to either apply to all levels separately or to a particular level. In these situations one has to be careful in specifying areas to distinguish between sequential row/column numbers and zone names.

Suppose, for example, that you have a basic 10x10 matrix with 3 levels so that the full matrix has 30 rows and 10 columns, and that the zone names are simply 1 to 10. You might, using sequential numbers, select all rows from 5 to 25, even though rows 5 and 25 both have the same zone “name”, i.e., 5, but clearly they are in different levels.  Alternatively you could define row limits by zone name, e.g., zones 5 to 7, in which case this could either be applied to all levels to include sequential rows 5 to 7, 15 to 17 and 25 to 27, or you could choose to apply it only to a single level, e.g., level 2, rows 15 to 17 only.

In addition with levels it is possible to select either a single level in its entirety or else a range of levels in their entirety. So that, in the above example, if you were to select level 2 only this would be equivalent to selecting rows 11 through 20 but with no further selection rules. I.e., if you select level 2 then there is no possibility to add extra restrictions on columns.

A slightly different form of location definition is to select intra-zonal or diagonal cells.  11.6, if the matrix contains either levels or blocks then the definition of whether a cell is an intra-zonal or not is based on its position within its sub-matrix.

Alternatively, you may select cells “outside” the defined locations.  For example you may select an area, perform an operation on those cells only, return to Select and “toggle” to select the outside cells and perform a different operation on those cells.