![]() However, if our parser works, then the solver can typically solve your problem quickly as it doesn’t need to re-calculate the spreadsheet repeatedly. We can only translate formulae that both we and the solvers understand, and so currently our parser will fail if your model uses spreadsheet-specific formulae such as OFFSET(), INDIRECT(), INDEX() etc. This is needed non-linear models, and will, in the future, also be available for linear ones. Versions of OpenSolver released from 2015 also include a new experimental parser that directly translates the formulae in your spreadsheet into a form the solver understands. To create this copy for linear models, OpenSolver uses an iterative process that requires one spreadsheet re-calculation for each decision cell. Most of the solvers need to be given a copy of your model in a form they understand. ![]() This page gives information about the solvers, including its uses and limitations, to help you find the right solver for your problem. OpenSolver supports a wide variety of solvers for use inside Excel, and several different ways in which the solver integrates with the Excel model.
0 Comments
Leave a Reply. |