Active Links to Spreadsheets

You can make an active link to data contained in a spreadsheet using the GET 123 DATA or GET XLS DATA function. For example suppose you have a spreadsheet file:

$image\ebx_6628.gif$

and want to use the data in row 2. Then you can write an equation

sales data := GET XLS DATA('test6.xls','sheet1','1','A2') ~~|

After simulating the model setting Print Every on the table tool to 10 we would get:

$image\ebx_-608.gif$

The sales data variable could then be used anywhere in the model to drive behavior. For subscripted models you can define a vector of data series in this manner using a single equation. See Chapter 4 for an example.