Importing Data to Use as a Search Variable

Use this forum to post Vensim related questions.
Post Reply
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

Importing Data to Use as a Search Variable

Post 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.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Importing Data to Use as a Search Variable

Post 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.
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
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

Re: Importing Data to Use as a Search Variable

Post 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.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Importing Data to Use as a Search Variable

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

Re: Importing Data to Use as a Search Variable

Post by tomfid »

Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

Re: Importing Data to Use as a Search Variable

Post by Priscila »

Thank you Tom, this video was very useful.
Post Reply