excel solver
optimization
simulation
tutorial, excel solver, optimization software

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   
Solver tutorial, excel solver downloads, spreadsheet solvers

Solver Tutorial - How to Use the Excel Solver or Solver SDK


model, decision variable, constraint, objective

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
Developers
MATLAB Users
Macintosh Users
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 


What Must I Do to Use a Solver?

To use a solver, you must build a model that specifies:

bulletThe resources to be used, using decision variables,
bulletThe limits on resource usage, called constraints, and
bulletThe measure to optimize, called the objective.

The solver will find values for the decision variables that satisfy the constraints while optimizing (maximizing or minimizing) the objective.

Using Spreadsheets.  Spreadsheets such as Microsoft Excel provide a convenient way to build such a model.  Anyone who has used a spreadsheet is already familiar with the process:  Cells on a worksheet can hold numbers, labels, or formulas that calculate new values -- such as the objective of an optimization.  Constraints are simply limits (specified with <=, = or >= relations) on formula cells.  And the decision variables are simply input cells containing numbers.  Frontline's Premium Solver products provide powerful tools for solving, or optimizing, such models.

Using Custom Programs.  Another way to build an optimization model is to write code in a programming language such as Visual Basic or C/C++.  Instead of spreadsheet cells, variables or arrays in the program hold the decision variables and calculate the constraints and objective.  Frontline's Solver SDK products provide equally powerful tools for solving, or optimizing, models in this form.

The choice of approach is up to you.  Spreadsheets offer a quick way to build a model, and you can easily explain the model and its results to other users who are usually spreadsheet-literate.  Application programs in Visual Basic, C/C++ or other languages may offer higher performance and may be easier to distribute widely, within a company or to commercial users.  No matter which approach you choose, Frontline Systems' Solver products provide the key optimization technology in an easy-to-use, reliable form.

Next: How Do I Define a Model?

Back to Tutorial Start

To Learn More:
For instant access to example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, you can register now.
User Type
Email Address
Name First Last
Company University
Phone

Trial version passwords are sent to the above email address: See Privacy Policy.
Our Premium Solver Platform works with existing Excel Solver models, solves much larger problems up to hundreds of times faster, and solves new kinds of problems via Evolutionary Solver.  Solver Engines plug into the Premium Solver Platform.
   
Solver Platform SDK makes it easy to solve any type or size of optimization problem in your Visual Basic, VB.NET, C/C++, C#, Java, or MATLAB program. And it's easy to deploy your application with our flexible licensing for software vendors and corporate developers.
  Visual Basic, custom program   Excel, spreadsheet
spreadsheet solver
scarce resources