MATLAB Answers


Optimization of Excel data

Asked by omar
on 21 Aug 2017
Latest activity Commented on by 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


Sign in to comment.

1 Answer

Answer by denny
on 31 Aug 2017

  1. You should load all your data from the Excel, and then calculate them in the MATLAB.


on 31 Aug 2017
Thank you for replying.
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.