How to use Solver in Matlab?

Question

Yasaswi 2024-5-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2122566-how-to-use-solver-in-matlab

回答： Abhishek Kumar Singh 2024-5-25

Hi,

Im optimising prices based on excel formulas. I have constructed a complete set of financial statements which is all linked to many cells. Can I upload that excel file to Matlab and work on Solver?

I have Objective cell, Change variable cells and Constraints in excel's solver. Can someone guide me how to use non linear solver in matlab please? Im using Web Matlab.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Abhishek Kumar Singh 2024-5-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2122566-how-to-use-solver-in-matlab#answer_1463346

Hi @Yasaswi

You can easily work with Excel files and solve optimization problems in MATLAB. Start by importing your Excel data using the readtable function. Check out how to use it here.

Next, define your optimization problem in MATLAB. Create a function for your objective that takes a vector of variables and returns your objective metric. For non-linear constraints, define separate functions for the constraint values and gradients.

For solving non-linear optimization, MATLAB offers various solvers. Explore the solver-based nonlinear optimization documentation here for functions and examples that can help. A good starting example is this fmincon solver guide.

Hope this helps!