Reading data from many files into subscripts

[linear feedback]

I have dozens of Excel sheets all with the same structure and I need to read the data items therein into variables. All variables are subscripted and each sheet contains the all data items for one subscript. What is the most efficient way to do so? Writing lots of GET XLS DATA for each subscript for all the variables seems intimidating...

[Administrator]

That's the only way to do it unfortunately.

If you go into text mode, it might prove a little quicker to enter the equations.

Or you could export the data and import it to Vensim. It depends on how often the data changes though.