Hi, I am currently working on an LP model using the EXCEL Solver. May I know is it possible to solve a multi-objective optimization using EXCEL? and what is the most suitable way?
@jensk.perret6794
3 жыл бұрын
Multi-objective optimization using the solver is not directly possible because the objective in the solver allows only for a single cell. If you use the solver in your own VBA program you might build your own multi-objective optimization solver.
@TheMadMonkey3
4 жыл бұрын
Hello, im trying to figure out a linear programming problem on Excel, could you take a look at it? Its quite challenging
@jensk.perret6794
4 жыл бұрын
If you have specific questions you could ask them. However, if you try to solve linear programs I would recommend to go with an LP Solver this will give you additional options as you can see in my unit on LP programs and in particular on sensitivity analysis.
@stanleymarketing
Жыл бұрын
Thanks for sharing these womderful video. How do I connect with you? I am struggling with a non-linear optimisation question with solver. Is there a chance that I can email it to you and we discuss it?
Пікірлер: 5