Page 1 of 1
Importing Data to Use as a Search Variable
Posted: Mon Apr 09, 2018 12:25 pm
by Priscila
Hello,
I would like to know if there is a way to import a excel chart as a search data variable. Which function should I use.
Re: Importing Data to Use as a Search Variable
Posted: Mon Apr 09, 2018 2:25 pm
by Administrator
Can you explain what you mean by a "search" variable?
You cannot import a chart, only the data that is used to create the chart. I don't know what you mean by a "search variable" though.
Re: Importing Data to Use as a Search Variable
Posted: Mon Apr 09, 2018 4:10 pm
by Priscila
For example,
A variable X is input for an auxiliary variable X x Y with subtype with lookup, where I will have a graph that will provide me the output Y according to input X.
I need a function for the X and Y data to be imported into Vensim.
Re: Importing Data to Use as a Search Variable
Posted: Mon Apr 09, 2018 6:02 pm
by Administrator
So you want a lookup table?
Don't bother with the "with lookup" functionality.
Search the Vensim help for GET XLS LOOKUPS, this gives an example how to get the data into Vensim and how to use it.
Re: Importing Data to Use as a Search Variable
Posted: Tue Apr 10, 2018 10:21 pm
by tomfid
Re: Importing Data to Use as a Search Variable
Posted: Thu Apr 12, 2018 12:45 pm
by Priscila
Thank you Tom, this video was very useful.