An Optimization Model

This section is meant for you if you’re familiar with optimization, but you’ve never used the Excel Solver, Solver add-on for Excel Online or Analytic Solver Platform.  It shows how you can translate from the algebraic statement of an optimization problem to a spread­sheet Solver model.  If optimization is new to you, consult our website at www.solver.com for example models and recommended reference books.

• The Model in Algebraic and Spreadsheet Form
• The Algebraic Form
• Setting Up a Model
• The Spreadsheet Formulas
• Defining Decision Variables
• Defining the Objective
• Defining Constraints
• Selecting the Solver Engine
• Defining and Solving the Optimization Model
• Flexibility in Model Creation