Excel - Non-linear Optimization Problems with Solver

Подписаться 3,8 тыс.

Просмотров 28 тыс.

50% 1

ISM Course Excel
Part 11.06
The corresponding playlist can be found here:
Excel (en): • Excel (en)
Additional Content on working with Excel can be found here:
Visual Basic for Applications: • Visual Basic for Appli...
Additional information on the International School of Management (ISM) and the offered study programs can be found at:
www.ism.de
#excel #microsoft #ism

Опубликовано:

12 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@qisiah827 3 года назад

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?