Optimization using Excel solver and GAMS

Go to Udemy

Beginning Course in Production and Scheduling Optimization

This course is suitable for student and researchers in any field even have no background in optimization.

In this course, you will learn:

· What is optimization?

· How to define the optimization problem

· How to formulate the mathematical model

· How to write objective functions

· How to write constraints

· How to use Microsoft Excel Solver for solving optimization problems.

· How to install Microsoft Excel Solver in your computer

· How to code the model's objective function and constraints in Microsoft Excel Solver

· How to set the solving options of Microsoft Excel Solver

· How to code conditional statements in Microsoft Excel Solver

· Multi-Objective optimization in Microsoft Excel Solver using Goal Programming

· Complete practical example in Microsoft Excel Solver

· Solved example of a complete published paper modelling using Microsoft Excel Solver

· How to Use GAMS for solving optimization problems.

· How to install GAMS in your computer

· How to get the license of GAMS

· Types of GAMS licenses

· How to code the model's objective function and constraints in GAMS

· How to set the solving options of GAMS

· How to code conditional statements in GAMS

· How to select solver in GAMS

· The relationship between solvers and model types

· How to read/write from/to an Excel file

· Multi-Objective optimization in GAMS using Epsilon Lexicographic procedure

· Complete practical example in GAMS

· Solved example of a complete published paper modelling using GAMS

Go to Udemy