Get data xls with multiple subscripts

[thifei]

Hello,

Is it possible to import data as in this exemple http://www.vensim.com/documentation/fn_ ... _data.html, but with multiple subscripts?
I only manage to import with one subscript.

Reffering to this example, is it possible to import all values from B5 to B10 directly in a variable Sales[shape,size] for instance, with autonomous differenciation of the shapes and the sizes?

thanks in advance!

[Administrator]

Can you get the sample models working? They should import more than 1 subscript.

[thifei]

I attached the files where I tried the example, can you tell me how to do pls?

[tomfid]

The GET DATA calls are basically 1-dimensional because the spreadsheet is 2D, and one is taken by time.

One possible way to semi-automate a GET call with more dimensions is to put the sheet names or first-cell references in a string variable with the appropriate subscripting.

[tomfid]

In a case like this, importing the data to vdf would be less error-prone.