The solver constraint screen should look like it does in Figure 4. Set all lower bounds
to 0 and set the upper bound for cell 'hatfldb!A3' (or Sheet1!A3 if you chose not to
name the sheet) to .8, as in figure 5.
to 0 and set the upper bound for cell 'hatfldb!A3' (or Sheet1!A3 if you chose not to
name the sheet) to .8, as in figure 5.
Figure 4
Figure 5
Now all you have to do is close the 'Set Solver Constraint' screen by pressing the red button with the white X
in the upper right hand corner then press 'Run Solver' on the xSolver Pro setup screen and the solver takes
over. Excel is disabled while the solver is running but you can stop it at any time and start it up again later.
Letting the solver run to completion should yield results like those in Figure 6.
Problem Solved.
If you wish you can save this template by pressing the 'Save' button on the Setup Screen and recall it later by
bringing up the setup screen and pressing 'Load'. The solver template is not attached to any particular
workbook file, but the sheet names matter. In this example the spreadsheet name is 'hatfldb' and when a
template is loaded there must be a sheet named 'hatfldb' in the workbook or an error will occur. You can of
course simply use 'Sheet1', 'Sheet2', 'Sheet3', etc. if you wish in all your workbooks so that the templates are
interchangable, but it may become unwieldy if you have lots of different spreadsheets.
in the upper right hand corner then press 'Run Solver' on the xSolver Pro setup screen and the solver takes
over. Excel is disabled while the solver is running but you can stop it at any time and start it up again later.
Letting the solver run to completion should yield results like those in Figure 6.
Problem Solved.
If you wish you can save this template by pressing the 'Save' button on the Setup Screen and recall it later by
bringing up the setup screen and pressing 'Load'. The solver template is not attached to any particular
workbook file, but the sheet names matter. In this example the spreadsheet name is 'hatfldb' and when a
template is loaded there must be a sheet named 'hatfldb' in the workbook or an error will occur. You can of
course simply use 'Sheet1', 'Sheet2', 'Sheet3', etc. if you wish in all your workbooks so that the templates are
interchangable, but it may become unwieldy if you have lots of different spreadsheets.
Figure 6