TABBED ARRAY is used as a convenient mechanism to enter vectors or arrays of Constants into Vensim.
Restrictions: TABBED ARRAY must immediately follow the equal = sign and cannot have anything following it. In the Equation Editor Tabbed Array appears as a subtype for variable type Constant.
The input to the TABBED ARRAY function is 1 or more rows of number separated by tabs with each row being on its own line. This function is designed to make it easy to paste number from spreadsheets directly into the Equation Editor. Each row must contain the same number of values as the last Subscript Range has Elements. The number of rows must match the number of elements in the first Subscript Range that appears. No more than two subscript ranges can appear.
Units: TABBED ARRAY is not part of units checking. Define the units for the Constant.
Example
country : MEXICO, USA, CANADA
blood type : A, B, O, AB ~~|
initial population[country,blood type] = TABBED ARRAY( |
1 2 3 4 |
5 6 7 8 |
9 10 11 12) ~Person~| |
Availability: Professional and DSS only.
See also: GET 123 CONSTANTS, GET XLS CONSTANTS, GET DIRECT CONSTANTS
Sample model: TABBED ARRAY.mdl in FunctionExamples