Ventana software support forum

I have a project model and want to use it in real specific projects. Every time I enter a new project I have to adapt the model. This is difficult as the model has several hundred paramateres and subscripts. I'm never sure having catchted every thing. Is it any solution to this problem?

E.g. my model assumes that there are two subcontractors, and both are characterized by a set of behaviour parameters. Now if my spcific project has four subcontractors I have to increase the subcontractor subscript as well as edit all the sets of character parameters. I rather would like fill out an Excel sheet with every parameters for every subcontractos, and Vensim looks for these parameters at starting time and set automatically the subscript range. Is this possible?

[Edited on 10-7-2004 by addor]

what a lot of people do is to configure their Vensim model so that all this specific information is in one section, usually at the top, when the model is viewed as text. Then the information in excel is saved - either directly or through the application of a macro that might do some refomatting. The contents of that saved file are then used to replace the first section of the model file.

Actually you can use a shortcut in the form

#include externparam.txt

to directly read in the file contents - though if you save the model the contents will replace this statement.

If you want to automate this you will need to use DDE to communicate with Vensim DSS to force it to read in and parse the model (the MDL2VMF command is useful for this)