Excel Solver Equivalent in Matlab?
显示 更早的评论
Hello,
I have data in excel which I am using to make an optimization analysis. In excel, using the solver, it's easy: I can choose a cell with a formula then pick the cells i need to change and add constraints and then minimize. But, I'm lost when it comes to Matlab's optimization process. Reading through the documentation, it looks like the solvers/optimizers are meant to analyze single functions; since my problem is very data-driven, I'm not sure what to do.
Can someone please provide some guidance?
I have access to the optimization and global optimization toolboxes.
Thank you.
1 个评论
Julian Gammon III
2014-10-10
I am having exactly the same problem. Althogh Solver is not geared to large scale problems, it is easy to set up LP problems and interactively add/delete constraints. I am going through two MatLab solvers by trail and error Linprog and Nmincon to try and see how to convert my Excel problem structure to MatLab.
采纳的回答
Shashank Prasanna
2013-7-1
0 个投票
Are you interested in a linear programming optimization problem?
Take a look at linprog:
You will need to provide your vector or data you want to optimize as the first argument. You can then provide your constraint matrix you select in excel as A and b. You can very easily pull your excel data into matlab by using the import tool. Right click on the excel file in the current folder browser and choose import and select the data you are interested in.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Solver Outputs and Iterative Display 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
