If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#10
|
|||
|
|||
Solver not working
Kerry -
Are there other Solver limitations I need to know about that could be causing the issue? Bernard Liengme suggested checking www.solver.com, where you will see that Premium Solver can automatically transform nonsmooth functions like IF, MIN, MAX, ABS, AND, OR, and NOT. As you have found, standard Solver generally cannot. For the standard Solver add-in shipped with pre-2010 Excel, Tushar Mehta suggested a workaround for dealing with the nonsmooth IF function using a binary variable. For a brief description of these issues, see http://www.solver.com/xlsplatformb.htm What is a binary variable in excel, how do I incorporate it and wouldn't it also cause the function gaps or sudden jumps that Solver has issues with? A binary variable is restricted to the values zero or one. On the Solver Parameters dialog box, you click the Add button (for the Constraints), specify the cell reference where your model's binary variable is located, and use the unlabeled "relationship" drop-down list to select "bin," which automatically enters "binary" in the Constraint edit box. Using a binary variable does not have the same issues as a nonsmooth function, because Solver uses a different algorithm for model formulations that contain a binary or integer variable. - Mike http://www.MikeMiddleton.com |
Thread Tools | |
Display Modes | |
|
|