Linking Data into Arrayed Variables

Special Note: Importing data into an arrayed variable in your model via DDE follows the same basic process as for non-arrayed variables. There are several exceptions to note. (See Chapter 11 for details on working with Arrays.)

1) Apply To All is checked in the arrayed variable's equation box.

2) There is the same number of data points in the data set to be pasted as there are cells in the arrayed variable (number of cells = number of elements in column * number of elements in row).

3) The data are enclosed in square brackets [] and all data points are separated by commas. The correct format for a column of data is illustrated here.

[Note: If the data are being imported from a spreadsheet, a column of commas can be created alongside the column of data. Square brackets should be put in front of the first number and after the last number. Copying them together will bring the data in the necessary format.]

See Also