Selective reporting of values in two dimensional arrays
Posted: Tue Jun 02, 2015 2:34 pm
I've got a large model that includes lots of arrays describing travel volumes between pairs of locations, or zones. There is a subscript called zones, which lists all the zone names, plus two others, called livezone and workzone, which are both equivalenced to zones. This means I can refer, in the model, to things like trips(livezone, workzone), and it's clear that the calculations have to work for each pair of origin and destination zone (whereas trips(zone,zone) would always have the same original and destination) . I've never worked out how to get the model to report values for different livezone and workzone values, like Trips(London, Leeds), because the subscript control menu only allows me to select values for the main subscript, zones. So I can see trips(London,London), and Trips(leeds,leeds). I can select London and Leeds in the subscript control, and then it will report all the London/leeds combinations, but that's messy when all I want is one of them. How can I do this?