Confusing error

Use this forum to post Vensim related questions.
Post Reply
soniav
Junior Member
Posts: 2
Joined: Thu Oct 02, 2008 7:20 pm

Confusing error

Post by soniav »

Help - yet another "what does this error mean" question.

I have a rather large model and am trying to change one of the subscripts due to a new flow being added. I renamed the subscript and the elements. I then updated all of the equations, including the import functions for many of the variables. However, now I'm getting a message saying:
"Used, not computed - [variable name+subscripts]". The problem is that the variable is computed - they're all import functions:
GET XLS Constants('filename.xls', 'worksheet', 'C807')

It seems to be giving me these error messages for all of the import functions in which I altered the subscripts, but the error is appearing for all subscript combinations, which seems odd to me.
I did not make any changes to the import file (basically the new subscript combinations are reading in the same data as the old subscript combinations.

Can anyone give me advice? I know vensim can be finicky about symbols, like ' and - but I've tried getting rid of all of these, retyping them, etc., and nothing seems to solve the problem.
Maybe it's something really obvious, but I've been staring at it for so long I'm going crazy.
tomfid
Administrator
Posts: 3994
Joined: Wed May 24, 2006 4:54 am

Re: Confusing error

Post by tomfid »

This error is generated when you're using all the elements of an array, but not computing some of them. For example:

myrange : mysubA, mysubB

mysubA : (sa1-sa10)

mysubB : (sb1-sb10)

datavar[mysubA] := GET XLS DATA( ... )

auxvar[myrange] = 3*datavar[myrange]

Notice that above, datavar is used with [myrange] but only half of [myrange] is computed - my guess is that you've done the equivalent in your model.
Post Reply