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 throughout these pages are included in the sample worksheet, which can be downloaded if required. In the sample worksheet, orange cells represent input cells, green cells represent cells to which the program writes data, and blue cells indicate the parameter storage area.
