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.
Search excel
-
- Super Administrator
- Posts: 4573
- Joined: Wed Mar 05, 2003 3:10 am
Re: Search excel
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.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Search excel
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.
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
Re: Search excel
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/