Hi to everybody
is there any way to use the encolsed excel file as an input for a lookup function in Vensim PLE? With some efforts I translated the data so to get a series of values of the type (a,b),(c,d) but when I tried to copy and paste sush a series within a lookup I found some problems since only a small subset was really saved.
Any workaround?
All the best.
Lorenzo
Excel file as an input for a lookup
-
- Senior Member
- Posts: 102
- Joined: Wed Jul 30, 2014 7:09 am
- Vensim version: PLE
Excel file as an input for a lookup
- Attachments
-
- test.xlsx
- (25.03 KiB) Downloaded 195 times
-
- Senior Member
- Posts: 102
- Joined: Wed Jul 30, 2014 7:09 am
- Vensim version: PLE
Re: Excel file as an input for a lookup
Ok, sorry, I partially solved.. there were some missing , between the )( but the whole process is really boring.. is there any direct way to access the data within an excel file?
L.
L.
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: Excel file as an input for a lookup
Not with PLE. You'd need PLE+, Pro or DSS to read the data directly.
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
-
- Senior Member
- Posts: 102
- Joined: Wed Jul 30, 2014 7:09 am
- Vensim version: PLE
Re: Excel file as an input for a lookup
Hi AdministratorAdministrator wrote:Not with PLE. You'd need PLE+, Pro or DSS to read the data directly.
thanks... so PLE+ is fine.... could you give me some hints? I know a collegue who has that version....
All the best.
Lorenzo
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: Excel file as an input for a lookup
Have a look at the Vensim documentation, it has all you need (including examples) to read directly from Excel.
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: Excel file as an input for a lookup
Specifically, the Help includes a sample model for every built in function, including the GET XLS variants. Sometimes the OS will lock out the links, but you can also find them in the Vensim folder (usually C:\users\public\vensim on Windows).
/*
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
*/
-
- Senior Member
- Posts: 102
- Joined: Wed Jul 30, 2014 7:09 am
- Vensim version: PLE
Re: Excel file as an input for a lookup
Ok, as Tomfid and Administrator suggested me, I looked at the documentation and the examples so I discovered I have non been clear enough. What I want to do is to load from an Excel file the tabular definition of a function f() and use it as f(x) with x \in [xmin, xmax] before the start of any simulation so to use it in a Vensim model with Time running from 0 to FINAL TIME and with, possibly but not necessarily, x=x(Time).
All the best.
Lorenzo
All the best.
Lorenzo
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: Excel file as an input for a lookup
GET XLS LOOKUPS is the function that does this.
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
-
- Senior Member
- Posts: 102
- Joined: Wed Jul 30, 2014 7:09 am
- Vensim version: PLE
Re: Excel file as an input for a lookup
Hi Administrator, thank u a lot, it works really fine..Administrator wrote:GET XLS LOOKUPS is the function that does this.
Lorenzo