Search excel

Use this forum to post Vensim related questions.
Post Reply
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

Search excel

Post by Priscila »

Good night,
I would like to know if there is any function that can do research in excel. For example, I have the wind speed entering a variable that is the power curve (which relates wind speed to output power) and needs to get output power. The power curve is in excel on a table, according to the precise input speed get the power output.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Search excel

Post by Administrator »

Is the table in excel a static set of numbers? If yes, you can import them as a lookup table.

Post the spreadsheet and we can take a better look.
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
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

Re: Search excel

Post by Priscila »

Good Morning,

The numbers in the table are constant; they do not vary throughout the simulation. How can I use a lookup table, which function. Attached to the worksheet.
Attachments
Planilha.xlsx
(9.59 KiB) Downloaded 189 times
Post Reply