Optimization with Excel: Operations Research without Coding

Operational planning and long term planning for companies are more complex in recent years. Information changes fast, and the decision making is a hard task. Therefore, optimization algorithms (operations research) are used to find optimal solutions for these problems.

Professionals in this field are one of the most valued in the market. And if you do not known how to code and/or if you wish to solve optimization problems using Excel, this is a perfect course for you. In this course you will learn what is necessary to solve problems applying (without any coding):Linear Programming (LP)Mixed-Integer Linear Programming (MILP)NonLinear Programming (NLP)Mixed-Integer Linear Programming (MINLP)Genetic Algorithm (GA)And how to solve Vehicle Routing Problems with Time Window (VRPTW)The following solvers will be explored: Gurobi - CBC - IPOPT - Bonmin - Couenne We will also use CPLEX, but a limited version from NEOS server.

Also, I provide workbooks for you that will facilitate to solve these problems. GA and VRPTW will be solved using workbooks that are very easy to work with. The course has a nice introduction on mathematical modeling and the main formulas from Excel.

Thus, you can easily follow the classes. In addition to the classes and exercises, the following problems will be solved step by step:Route optimization problemMaximize the revenue in a rental car storeMaintenance planning problemOptimal Power Flow: Electrical SystemsMany other examples, some simple, some complexes, including summations and many constraints. You should NOT solve optimization problems in Excel for:Complex problems that requires decompositions and iterations.