Ventana software support forum

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.

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.

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.

http://vensim.com/lookups-in-vensim/
https://www.vensim.com/documentation/fn ... ookups.htm