Hello I am in need to receive support in regards of the subscript feature.
I need Vensim to get constants values from cell P4 to P33 (30 cells in total) of an excel file
I added a subscript to the model
I set the subscript to the variable I need to use
I hit the function editor and typed GET XLS CONSTANTS( {'filename'} , {'tabname'} , 'P4*' ) in the interested variable
I knew that by putting the * Vensim would have iteratively read down the column P4 (for 30 cells in my case) in the excel file.
However I receive an error message saying the Vensim is unable to get constant values.
Anybody can help?
Thank's in advance
Ale
subscripts
Re: subscripts
Check the sample models in the help system for prototypes of the correct syntax:
https://www.vensim.com/documentation/fn ... stants.htm
https://www.vensim.com/documentation/fn ... stants.htm
/*
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
*/