Optimization using Excel solver and GAMS (بالعربي)

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