Optimization of Excel data
Show older comments
Hello everyone, I am new user of matlab. Excel spreadsheet data consists of four columns by 25 rows ( A & B as inputs; C & D as outputs). I imported data into matlab as columns. How can I use fmincon function to maximize C, under constraint of D <= 0.001 . Any hints or suggestions are valuable to me. thank you in advanced
Answers (1)
denny
on 31 Aug 2017
1 vote
- You should load all your data from the Excel, and then calculate them in the MATLAB.
2 Comments
omar
on 31 Aug 2017
RAJARSI SAHA
on 8 Mar 2019
What functions do I use to optimise the data in excel using weighted sum method. I have data in Excel containing three values per row. Please let me know.
Categories
Find more on Problem-Based Optimization Setup in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!