Error message

The page you requested does not exist. For your convenience, a search was performed using the query category catalog excel products.

Search results

Excel Solver- Functions of the Variables

Since there are large differences in the time it takes to find a solution and the kinds of solutions – globally optimal, locally optimal, or simply “good” – that you can expect for different types of problems, it pays to understand the differences between ...

admin - 04/07/2015 - 15:08

Excel Solver- Smooth Nonlinear Functions

A nonlinear function is any function of the variables that is not linear, i.e. which cannot be written in the algebraic form: a 1 x 1 + a 2 x 2 +... + a n x n Examples are =1/C1, =LOG(C1), and =C1^2, where C1 is a decision variable.  All of these are call ...

admin - 04/07/2015 - 15:09

Excel Solver- Solver converged in probability to a global solution (17).

If you are using the GRG Nonlinear Solving method and you’ve selected the Use Multistart check box in the Solver Options dialog, this message appears when the multistart method’s Bayesian test has determined that all of the locally optimal solutions have ...

admin - 04/07/2015 - 14:55

Excel Solver- All variables must have both upper and lower bounds (18).

If you are using the Evolutionary Solving method or the multistart methods for global optimization, and you have checked the Require Bounds on Variables check box in the Solver Options dialog (it is checked by default), this message appears if you have no ...

admin - 04/07/2015 - 14:55

Excel Solver- Optimization Methods

A model in which the objective function and all of the constraints (other than integer constraints) are linear functions of the decision variables is called a linear programming (LP) problem.  (The term “programming” dates from the 1940s and the disciplin ...

admin - 04/07/2015 - 15:06

Excel Solver- Linear Programming

A model in which the objective cell and all of the constraints (other than integer constraints) are linear functions of the decision variables is called a linear programming (LP) problem.  Such problems are intrinsically easier to solve than nonlinear (NL ...

admin - 04/07/2015 - 15:06

Excel Solver- Global Optimization

The GRG Nonlinear Solving method, like most nonlinear optimization methods, normally can find only a locally optimal solution to a nonlinear, non-convex problem.  Solver includes a multistart method that can improve your prospects of finding a globally op ...

admin - 04/07/2015 - 15:07

Pages