Code Excel Solver in Matlab for SimplexLP optimization

Ajith Viswanath Sreenivasan

2019 3 13

0 个回答

8 次查看（30 天）

显示更早的评论

0 个投票

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

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.