Using lookups with subscripted variables

Liz · Post by **Liz** » Tue Aug 03, 2004 1:51 pm

I am building a model of a workforce, and have used subscripts to allow the use of the same model for 9 different grades and 2 locations (i.e. StaffInPost[grade, location]). This is fine for constant variables such as initial work force size (where I enter the values in the 1, 2, 3, 4; 5, 6, 7, 8; format shown in the help files), but I now want to use a profile of how long staff in each grade/location have been in the workforce in a conveyor delay. Is there a way of setting a lookup graph for each grade/location in a single initial population level variable so that I can feed this into the 'initprofile' element of the conveyor?

Post by **Administrator** » Tue Aug 03, 2004 4:15 pm

The best thing to do would be to enter the data into a CIN file (see the help system under changes file or just CIN).

Basically you can use Vensim's text editor to edit and create lookup tables. You then use this CIN file when running a model instead of holding the data in the model itself.

Hope this makes sense.

Tony.

Liz · Post by **Liz** » Wed Aug 04, 2004 1:23 pm

Thanks Tony, will give it a go!

Liz

Post by **Administrator** » Wed Aug 04, 2004 3:03 pm

Another tip, if you click Model->Settings->Info from the Vensim menu, there is a button for Model->CIN, click this and it will give you a template CIN file that you can edit in the Vensim text editor. Select the particular lookup you are interested in and there is a graph button in the text editor.

Hope this helps.

Tony.