Excel - Non-linear Optimization Problems with Solver

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 5

  • @qisiah827
    @qisiah827 3 ปีที่แล้ว +1

    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
      @jensk.perret6794  3 ปีที่แล้ว +2

      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
    @TheMadMonkey3 4 ปีที่แล้ว +1

    Hello, im trying to figure out a linear programming problem on Excel, could you take a look at it? Its quite challenging

    • @jensk.perret6794
      @jensk.perret6794  4 ปีที่แล้ว +3

      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
    @stanleymarketing 2 ปีที่แล้ว

    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?