MATLAB Answers

Optimization of Excel data

3 views (last 30 days)
omar
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

  0 Comments

Sign in to comment.

Answers (1)

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

Sign in to answer this question.


Translated by