subscripts

Use this forum to post Vensim related questions.
Post Reply
AMZ
Newbie
Posts: 1
Joined: Thu Aug 10, 2017 12:46 pm
Vensim version: DSS

subscripts

Post by AMZ »

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
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: subscripts

Post by tomfid »

Check the sample models in the help system for prototypes of the correct syntax:
https://www.vensim.com/documentation/fn ... stants.htm
Post Reply