The most difficult type of optimization problem to solve is a non-smooth problem (NSP). Such a problem may not only have multiple feasible regions and multiple locally optimal points within each region – because some of the functions are non-smooth or ev ...
Adds a constraint to the current problem. Equivalent to clicking Solver in the Data | Analysis group and then clicking Add in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visua ...
Changes an existing constraint. Equivalent to clicking Solver in the Data | Analysis group and then clicking Change in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic ...
Deletes an existing constraint. Equivalent to clicking Solver in the Data | Analysis group and then clicking Delete in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic ...
Loads existing Solver model parameters that have been saved to the worksheet. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then ...
Defines a basic Solver model. Equivalent to clicking Solver in the Data | Analysis group and then specifying options in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basi ...
Same as the SolverOK function, but also displays the Solver dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then selec ...
Allows you to specify advanced options for your Solver model. This function and its arguments correspond to the options in the Solver Options dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basi ...
Resets all cell selections and constraints in the Solver Parameters dialog box and restores all the settings in the Solver Options dialog box to their defaults. Equivalent to clicking Reset All in the Solver Parameters dialog box. The SolverReset function ...
Saves the Solver problem specifications on the worksheet. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.x ...