Optimization of Excel data

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

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.

Products

Asked:

on 21 Aug 2017

Commented:

on 8 Mar 2019

Community Treasure Hunt

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

Start Hunting!