GET DIRECT SUBSCRIPT Problem (split/moved from other thread)

[akivoigt]

Yes, I tried GET DIRECT SUBSCRIPT - but the problem is that it does not seem to work when you want to increase or reduce the number of elements in the array/family.

For example, I had a family with three elements and wanted to add a fourth - I was able to add the fourth subscript with GET..., but then Vensim complained that the model parameters using this family only had 3 values and that now 4 were needed.

Am I forgetting something, can this be resolved?

Thanks!

Alex

[Administrator]

The only thing you can do here is move the constant values into a CIN file (which is good practice anyway) and then just add the new constant values.

[tomfid]

Or put the constants in the same spreadsheet/tab file that you're using for the subscripts, and use the GET DIRECT or GET XLS function to retrieve them. For example, you might have

City|Boston|Cairo|Denver
PriceOfCheese|1|2|3.5
FractionWhoJog|.5|.7|.2

Then read the subscript elements from the first line and the matching constant vectors from the 2nd & 3rd.