Optimization of Excel data

6 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

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.

Categories

Find more on Get Started with MATLAB 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!