contents.gifprev1.gifnext1.gif

How to Use This Helpfile

"Custom Installation" describes steps you can take to install the Solver for 1-2-3 97 Edition if you had trouble with the automatic installation program. If you have successfully installed the Solver, you can skip this section.

"Solver Basics" reviews the basic framework of the optimization problems which can be handled by the Solver. It describes how a model is made up of variables, constraints and an objective, and covers the major categories of optimization problems (linear and quadratic programming, nonlinear programming, and integer programming) handled by the Solver.

"Building Solver Models" is an introduction to the process of building optimization models in Lotus 1-2-3, translating from algebraic notation to spreadsheet formulas and Solver dialog choices. It also covers multiple selections for decision variables, use of the Variables button, the possible forms of constraint left- and right-hand sides, and use of the "bin" dropdown to specify binary integer variables.

"Diagnosing Solver Problems" helps you determine what is wrong if you don't get the solution you expect from the Solver, or if you encounter a message other than "Solver found a solution." It outlines the most common problems that users have, based on our technical support experience with the Solver.

"Solver Options" documents in depth the advanced options and tolerances which can be set using the Solver Options dialog. The effect of each option and situations where you would likely choose it are described.

"Solver Reports" describes the contents of the reports which may be chosen from the Solver Results dialog. It shows you how to interpret the numbers in the reports, and how to use the Sensitivity Report to predict changes in the optimal solution in response to certain kinds of changes in your input data.

"Programming the Solver" describes how you can control the Solver from LotusScript and create "turn-key" applications using the Solver.