Dear Vensim support staff,
I have a model in which I am heavily using the GET XLS CONSTANT function to call initial stock values and parameter values from an Excel file. This allows me to easily change the initial conditions when initialising the run.
I would now like to test some shock dynamics, but realised that Vensim won't allow me to add a STEP function to the definition of the constant whose value I call via the GET XLS CONSTANT function. It gives me an error message: 'Only literals or variables separated by commas allowed'. The only way I managed to make it work is to create two distinct variables: one that calls the value from Excel, and another one equal to the first variable plus the STEP function.
Is there any more efficient way to do this?
All the best, and many thanks for your help.
Emanuele
GET XLS CONSTANT + STEP functions
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: GET XLS CONSTANT + STEP functions
No, this is the most efficient and best way to do it.ema wrote:Is there any more efficient way to do this?
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: GET XLS CONSTANT + STEP functions
Also, this is true in general. A constant has to be a single number so that it can be attached to sliders, changed in optimizations, etc., regardless of its source.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/