|
|
|
The standard Microsoft Excel Solver places upper limits on the
number of decision variables (or changing cells), and the number of
constraints in a Solver model. The limit on decision variables is
straightforward (200), but the limit on constraints depends on the
type of model (linear or nonlinear) and the form of the constraints.
It's easy to upgrade to Frontline's Premium
Solver products, which have much higher limits on both decision
variables and constraints -- your Excel Solver model can be used
as-is, with no changes.
Before you reach the standard Solver's size
limits, you may find that the solution process takes a long
time.
Click on this topic to learn about steps you can take to speed up
the solution process. You can usually obtain much faster
solutions with Frontline's Premium Solver
products.
The standard Microsoft Excel Solver has a limit of
200 decision variables, for both linear and nonlinear problems. The
only way around this limit is to change your model so that some of
the cells you have chosen as decision variables are removed from the
By Changing Cells reference, and are held constant in the
optimization process. To explore the consequences of varying the
cells which are no longer determined by the Solver, you'll have to
employ what-if analysis or other methods.
Frontline's Premium
Solver has a limit of 2,000 decision variables for linear
problems, and 500 variables for nonlinear problems -- and it solves
problems of this size in much less time. The Premium
Solver Platform handles linear and quadratic problems of up to
8,000 variables, and Solver engines for
the Premium Solver Platform can handle problems of virtually
unlimited size.
Back to Standard Excel Solver
Support Information
|
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. |
|
