How to put excel database in variables?

Use this forum to post Vensim related questions.
Post Reply
wanderbeg
Member
Posts: 20
Joined: Mon Mar 18, 2019 3:21 am
Vensim version: PLE

How to put excel database in variables?

Post by wanderbeg »

Hi, guys,


I'm new with vensim, and I'm having the following data-related question:
- How to put excel database in variables?

I would to know if anyone works System Dynamics in water management using the software vensim. Because I do research in this area and I have some doubts. We can exchange e-mails.

Cheers,
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: How to put excel database in variables?

Post by tomfid »

wanderbeg
Member
Posts: 20
Joined: Mon Mar 18, 2019 3:21 am
Vensim version: PLE

Re: How to put excel database in variables?

Post by wanderbeg »

Another question. The only way to put historical data is by importing data or can put directly into the variable?

Thanks for the answers,
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: How to put excel database in variables?

Post by Administrator »

If you are using PLE, there is very little you can do regarding external data. You need PLE+ really to import 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
wanderbeg
Member
Posts: 20
Joined: Mon Mar 18, 2019 3:21 am
Vensim version: PLE

Re: How to put excel database in variables?

Post by wanderbeg »

Could I put my historical data using the "with lookup" command, instead of importing a database?

My data range from 2005 to 2015. They are in a monthly range, but could be placed annually.

What do you think?
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: How to put excel database in variables?

Post by tomfid »

You can do that. There are some drawbacks - for example, you can't distinguish the interpolated values from real data points - but it works.
Post Reply