Code Excel Solver in Matlab for SimplexLP optimization

4 views (last 30 days)
Hi, I am using Excel Solver to minimize a value by changing a range of variables. But as I use more and more data, excel is not able to solve it. I have imported and created matrices in matlab with the excel data. But I am not exactly sure about which optimization technique to use in matlab as I want to change a number of variables to solve the problem.
Here is the solver parameters I used in excel
Capture.PNG
As you can see I am changing a lot of variables to obtain the solution with a number of constraints.
I've assigned the values to matrices in matlab and I didn't have a problem with that. But I am not exactly sure about how to code it in Matlab for optimization. Can anyone please provide some advice on this topic?
Thanks in advance.

Answers (0)

Community Treasure Hunt

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

Start Hunting!