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.
Importing Data to Use as a Search Variable
-
- Super Administrator
- Posts: 4573
- Joined: Wed Mar 05, 2003 3:10 am
Re: Importing Data to Use as a Search Variable
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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Importing Data to Use as a Search Variable
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.
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.
-
- Super Administrator
- Posts: 4573
- Joined: Wed Mar 05, 2003 3:10 am
Re: Importing Data to Use as a Search Variable
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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Importing Data to Use as a Search Variable
/*
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
*/
Re: Importing Data to Use as a Search Variable
Thank you Tom, this video was very useful.