Help

XLPack Solver – General Nonlinear Equation (Feb 21, 2019)

Solve the general nonlinear equation with single variable using Dfzero. Let’s solve the following example equation. f(x) = x^3 – 2x – 5 = 0 The solver program will write the value of x into the variable value cell (B6 in this case). The function value cell (B7 in this case) must contain the formula […]

XLPack Solver – Save/restore Parameters (Feb 21, 2019)

By saving the input parameters in each menu of XLPack solver into the worksheet, you can save time and effort to set the parameters each time by restoring all parameter values. Click “Save/Restore” in the dialog of each function. Select appropriate cell range (A10:A13 in this example) and click “Save” to save input parameters into […]

XLPack Solver – System of Nonlinear Equations (Feb 17, 2019)

Solve the system of nonlinear equations (find the real solution). Let’s solve the following example. f1(x1,x2) = 4*x1^2 + x2^2 – 16 f2(x1,x2) = x1^2 + x2^2 – 9 The solver program will write the value of x1 and x2 into the variable value cells (B8 and B9 in this case). The function value cells […]

XLPack Solver – Univariate Nonlinear Optimization (Feb 17, 2019)

Minimize the nonlinear function with single variable using Dfmin. Let’s find the minimum point of the following example equation. f(x) = x^3 – 2x – 5 The solver program will write the value of x into the variable value cell (B6 in this case). The function value cell (B7 in this case) must contain the […]

XLPack Solver – Multivariate Nonlinear Optimization (Feb 17, 2019)

Minimize the nonlinear function with multiple variables. Let’s find the minimum point of the following example equation. f(x1,x2) = 100*(x2 – x1^2)^2 + (1 – x1)^2 (Rosenbrock function) The solver program will write the value of x1 and x2 into the variable value cells (B8 and B9 in this case). The function value cell (C8 […]

XLPack Solver – Nonlinear Least Squares Problems (Feb 21, 2019)

Solve the nonlinear lease squares problems. Let’s solve the following example (Reference: https://www.itl.nist.gov/div898/strd/nls/data/misra1a.shtml). Find the parameters p1 and p2 to approximate the following data using the model function f(x) = p1*(1 – exp(-p2*x)) with least sum of squares of residuals. x y 77.6 10.07 114.9 14.73 141.1 17.94 190.8 23.93 239.9 29.61 289.0 35.18 332.8 […]

XLPack Solver – Quadrature (finite interval) (Feb 26, 2019)

Compute the numerical integration of the given function. Let’s compute the integral of the following example function. f(x) = 1/(1 + x^2) The solver program will write the value of x into the variable value cell (B6 in this case). The function value cell (B7 in this case) must contain the formula to compute f(x) […]

XLPack Solver – Ordinary Differential Equations (ODEs) (Mar 16, 2019)

Compute the solution of the initial value problem of the ordinary differential equations. Let’s solve the following example equations. dy1/dt = -y2, dy2/dt = y1 where y1 = 1, y2 = 0 at t0 = 0 The solver program will write the value of t into the independent variable (t) cell (B8 in this case) […]

XLPack Solver – Quadrature (infinite interval) (Mar 3, 2019)

This function computes the numerical integration of the given function over an infinite interval (both interval bounds are infinite). Let’s compute the integral of the following example function. f(x) = 1/(1 + x^2) The solver program will write the value of x into the variable value cell (B6 in this case). The function value cell […]

XLPack Solver – Quadrature (semi-infinite interval) (Feb 26, 2019)

This function computes the numerical integration of the given function over a semi-infinite interval (one of the interval bounds is -∞ or +∞). Let’s compute the integral of the following example function. f(x) = 1/(1 + x^2) The solver program will write the value of x into the variable value cell (B6 in this case). […]

XLPack Solver (Mar 14, 2019)

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 Lite. Note – XLPack solver manipulates a current worksheet (active worksheet) only. Even if a […]

Top