From the course: Excel: Using Solver for Decision Analysis

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Introduce linear, nonlinear, and evolutionary programming

Introduce linear, nonlinear, and evolutionary programming - Microsoft Excel Tutorial

From the course: Excel: Using Solver for Decision Analysis

Start my 1-month free trial Buy for my team

Introduce linear, nonlinear, and evolutionary programming

“

- [Instructor] Before I get into using Solver, I would like to give you an introduction to linear and integer programming. The goal in both cases is to find the optimal solution to a system of equations. Within those equations, which we'll look at examples in a moment, linear programming does not allow exponents or things like division or counting. You can only have multiplication, addition, and subtraction. Non-linear programming does allow exponents and division and so on. But where linear programming will find you an optimal solution, if there is one, non-linear programming does not guarantee that. And, finally, integer programming requires whole number solutions. For example, you couldn't sell one half of a car to someone. You can only sell cars as entire units. Now let's take a look at what I mean by systems of equations. These are mathematical representations of the constraints on a problem. For example, if you…

Contents