XLPack Solver
XLPack solver is the add-in program to help use XLPack without VBA programming for nonlinear equations, nonlinear optimization, nonlinear least squares problems, quadrature and ordinary differential equations. This add-in is included in XLPack Module 3 and 4 packages and XLPack Basic.
Note – XLPack solver manipulates a current worksheet (active worksheet) only. Even if a cell in the other worksheet is specified, the worksheet specification will be ignored.
How to use XLPack Solver
Click “XLPack Solver” in “Menu Commands” of “Add-ins” tab, then choose the required function.
For details of each function, please refer to the followings.
Univariate nonlinear optimization
Multivariate nonlinear optimization
Nonlinear least squares problems
Quadrature (semi-infinite interval)
Quadrature (infinite interval)
Ordinary differential equations (ODEs)
Second order ordinary differential equations (ODEs)
The examples used in the explanations on these pages are included in a sample worksheet that you can download if necessary. In the example worksheet, orange indicates input cells, green indicates cells that the program writes to, and blue indicates the parameter save area.
