T
tkpmep
I have a loop that changes some parameters with each loop, and then
sets up and solves an optimization problem. The results from each run
are stored on a separate sheet. I sometimes find that a dailog box
appears saying that the iteration limit has been reached. In such
cases, I am more than happy to acccept the solution and to just go on
to the next iteration, but I want this done automatically with no
need for human intervention. The userFinish option for SolverSolve
allows me to accept the final solution without any need for human
intervention; is there a corresponding way in which to suppress
warning or error messages and accept the current solution as well? My
code follows - thanks in advance for your assistance.
Sincerely
Thomas Philips
SolverReset
SOLVERAdd CellRef:="$C$1:$F$1", Relation:=1, FormulaText:="1"
SOLVERAdd CellRef:="$C$1:$F$1", Relation:=3, FormulaText:="0"
SOLVERAdd CellRef:="$B$1", Relation:=2, FormulaText:="1"
SolverOk SetCell:="$U$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$C
$1:$F$1"
SolverOptions MaxTime:=100, Iterations:=10000, Precision:=0.0000001, _
AssumeLinear:=False, StepThru:=False,
Estimates:=2, _
Derivatives:=1, SearchOption:=1, IntTolerance:=1,
Scaling:=True, _
Convergence:=0.000001, AssumeNonNeg:=True
SolverSolve userFinish:=True
sets up and solves an optimization problem. The results from each run
are stored on a separate sheet. I sometimes find that a dailog box
appears saying that the iteration limit has been reached. In such
cases, I am more than happy to acccept the solution and to just go on
to the next iteration, but I want this done automatically with no
need for human intervention. The userFinish option for SolverSolve
allows me to accept the final solution without any need for human
intervention; is there a corresponding way in which to suppress
warning or error messages and accept the current solution as well? My
code follows - thanks in advance for your assistance.
Sincerely
Thomas Philips
SolverReset
SOLVERAdd CellRef:="$C$1:$F$1", Relation:=1, FormulaText:="1"
SOLVERAdd CellRef:="$C$1:$F$1", Relation:=3, FormulaText:="0"
SOLVERAdd CellRef:="$B$1", Relation:=2, FormulaText:="1"
SolverOk SetCell:="$U$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$C
$1:$F$1"
SolverOptions MaxTime:=100, Iterations:=10000, Precision:=0.0000001, _
AssumeLinear:=False, StepThru:=False,
Estimates:=2, _
Derivatives:=1, SearchOption:=1, IntTolerance:=1,
Scaling:=True, _
Convergence:=0.000001, AssumeNonNeg:=True
SolverSolve userFinish:=True