Excel file as an input for a lookup

Use this forum to post Vensim related questions.
Post Reply
lorenzo.cioni
Senior Member
Posts: 102
Joined: Wed Jul 30, 2014 7:09 am
Vensim version: PLE

Excel file as an input for a lookup

Post by lorenzo.cioni »

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 8)
Attachments
test.xlsx
(25.03 KiB) Downloaded 190 times
lorenzo.cioni
Senior Member
Posts: 102
Joined: Wed Jul 30, 2014 7:09 am
Vensim version: PLE

Re: Excel file as an input for a lookup

Post by lorenzo.cioni »

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

Re: Excel file as an input for a lookup

Post by Administrator »

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
lorenzo.cioni
Senior Member
Posts: 102
Joined: Wed Jul 30, 2014 7:09 am
Vensim version: PLE

Re: Excel file as an input for a lookup

Post by lorenzo.cioni »

Administrator wrote:Not with PLE. You'd need PLE+, Pro or DSS to read the data directly.
Hi Administrator
thanks... so PLE+ is fine.... could you give me some hints? I know a collegue who has that version....
All the best.
Lorenzo
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Excel file as an input for a lookup

Post by Administrator »

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

Re: Excel file as an input for a lookup

Post by tomfid »

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).
lorenzo.cioni
Senior Member
Posts: 102
Joined: Wed Jul 30, 2014 7:09 am
Vensim version: PLE

Re: Excel file as an input for a lookup

Post by lorenzo.cioni »

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

Re: Excel file as an input for a lookup

Post by Administrator »

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
lorenzo.cioni
Senior Member
Posts: 102
Joined: Wed Jul 30, 2014 7:09 am
Vensim version: PLE

Re: Excel file as an input for a lookup

Post by lorenzo.cioni »

Administrator wrote:GET XLS LOOKUPS is the function that does this.
Hi Administrator, thank u a lot, it works really fine..
Lorenzo 8)
Post Reply