MATLAB Answers

omar
0

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

  0 Comments

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.

  2 Comments

omar
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.