|
|
|
Given that you plan to define your model in a
Microsoft Excel spreadsheet, your best choice is
Risk Solver if you're modeling a
risk analysis problem that can be solved with Monte Carlo
simulation, or Premium Solver
or Premium Solver Platform (see
further below) if you're modeling a resource allocation
problem that can be solved with optimization.
If your problem involves an optimization model of
some size, let's consider the last two
questions we posed earlier:
 | What type of problem
(linear programming, nonlinear optimization, etc.) do you want to solve? |
| What size of problem (number of decision
variables and constraints) do you want to solve? |
The type of optimization problem you have depends
on:
| The types of mathematical relationships
(e.g. linear,
nonlinear or nonsmooth) between your objective and constraints and
your decision variables. |
| The types of decision variables
(real-valued or integer-valued) you have in your model. |
| The type of solution you want --
globally optimal or locally optimal -- for nonlinear
optimization problems. |
If you're not sure what type of problem you have,
click on Optimization Problem Types for
an in-depth discussion. But you may want to start with
Frontline Systems' Premium Solver Platform, because it
bundles together several Solvers that together will handle all
types of optimization problems up to certain size limits.
Click on Frontline
Systems Solvers for Excel Users for further information.
The size of your problem is measured by the number
of decision variables and the number of constraints.
If you have not yet defined your model in these terms, you may not
know its size -- see below for ideas on estimating problem
size. You can start with our Premium Solver Platform,
and if your problem ultimately exceeds its size limits, you can add
a "plug-in" Solver Engine that handles larger-scale
problems of the appropriate type. If your problem is
relatively small, you can save money with our Premium Solver.
Click on Frontline
Systems Solvers for Excel Users for further information.
Often -- though not always -- the number of
decision variables will be greater than the number of constraints
and will determine the "size limit;" also, it may easier
to estimate the number of decision variables up-front. To
understand what kind of decision variables you may have, take our Solver
Tutorial, paying special attention to the page Defining
a Model.
Back to Select the Best Product for Your
Needs
|
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. |
|
|
| 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. |
|
