# Optimization with Excel: Operations Research without Coding

## Description

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 problem
• Maximize the revenue in a rental car store
• Maintenance planning problem
• Optimal Power Flow: Electrical Systems
• Many 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. Since we do not use any programming language in the course, our approach would not be recommended to solve problems that requires iterations, such as Benders.
• Operational problems for real-time execution.
• Large problems that require fast solutions. The approach from the course does not have a limitation, but large problems may take a while to be converted from the Excel’s formulas to the solver.
• Solve multi-objective problems.

Attention:

• The approach in this course is NOT using the standard solver from Excel, our approach here has NO limitations on the number of variables or constraints.
• I do NOT show you how to install Excel. But I teach how to install the required tools.
• To follow the course you will need Excel installed on your computer. Moreover, the tools from the courses have been tested in Windows and MAC only.
• The classes use examples that are created step by step, from the business concept to the resolution.

Operations Research | Operational Research | Mathematical Optimization

## Who this course is for:

• If you want or need to solve optimization problems but is not very good with programming languages
• People interested in solving complex problems

## Requirements

• Some knowledge in Excel, however, I provide a fast introduction using the basic formulas you need for the course.
• Why and where to use optimization
• You do NOT need to know how to code in this course (we are NOT gonna use any programming language)

Last Updated 10/2021