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?
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.
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.
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?
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?
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.
Hello, im trying to figure out a linear programming problem on Excel, could you take a look at it? Its quite challenging
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.
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?