Optimization of Excel data

4 views (last 30 days)
omar on 21 Aug 2017
Commented: RAJARSI SAHA on 8 Mar 2019
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. You should load all your data from the Excel, and then calculate them in the MATLAB.
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.

Sign in to comment.


Find more on Data Import from MATLAB in Help Center and File Exchange


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!