Get subranges?

[linear feedback]

I can use GET SUBSCRIPTS to read in subscripts but how can I add or map subranges to it if the names of subscripts are not known in advance?

[Administrator]

Can you upload a simple model demonstrating what mapping you need to do? There may be a way to do it.

[linear feedback]

I'd like to map the subranges in column B to the range in A. Trouble is that the number of elements in the subrange categories can change and should adjust itself to the data sets. Any thoughts?

[Administrator]

Can you work with these files?

Read in the subscripts as before, but create a cross reference matrix. Then use this as a multiplier to convert

[linear feedback]

Thank you for your suggestion. As I would be dealing with 700 x 70 items a matrix does get a bit more complex in Excel. I have attached a solution which uses indexed subscripts - as one cannot calculate (especially references) with subscripts in vensim I use variables for doing so. Any thoughts which approach is better?

Is there a way around the necessity to call GET SUBSCRIPT with two fixed cell references? Using a different data set with a different structure requires also changing the model which a user won't like doing.

[Administrator]

Is there a way around the necessity to call GET SUBSCRIPT with two fixed cell references? Using a different data set with a different structure requires also changing the model which a user won't like doing.

I'll raise this a feature request.

Regarding which method is better, it's really a matter of personal preference (and ease of understanding).