Page 2 of 2

Re: Uploading Data onto Vensim PLE

Posted: Fri Sep 20, 2019 12:26 pm
by MaxiKing
Hi tomfid,

sorry for coming back to this issue. I've tried to fix the lookup and also reread the help on lookups as well as the video on lookups (https://vensim.com/lookups-in-vensim/), however I am still lost here.

I simply want to return the value of the lookup with the input time and use it in my flow variable "change in FIT".

Would you mind just fixing it quickly in the model so I can see how to use lookups with time inputs in the rest of my model? (I am using Vensim PLE)

That would be so helpful!

Thanks!

Re: Uploading Data onto Vensim PLE

Posted: Fri Sep 20, 2019 2:55 pm
by Administrator
Lookups are really easy to use.

This lookup has values from 2010 until 2040

Lookup table ( (2010,1),(2020,2),(2030,3),(2040,4) )

And to retrieve the value at "time",

looked up value = lookup table ( time )

Re: Uploading Data onto Vensim PLE

Posted: Fri Sep 20, 2019 3:33 pm
by tomfid
I'm on the road and can't modify the model, plus I don't have the data. But the structure you already have for "fit degression rate" is exactly what you need. "FIT degression rate DATA" is the lookup and "FIT degression rate" is the value looked up from the data, by time.