XLPack Basic

XLPack is a set of expansion modules for Excel which is developed for easy numerical calculation of small and medium-size on office / home PCs. It adds the features useful for wide range of scientific fields to Excel.

XLPack consists of a worksheet function library, a solver add-in, and a VBA subroutine library. By using worksheet functions or a solver, numerical calculations can be performed without programming. Also, the VBA subroutine library can be called from Excel VBA so that the numerical calculation programming can be made easier.

(1) The worksheet function library provides worksheet functions that can be entered directly in the Excel worksheet. You can perform calculations such as linear equations, eigenvalues, and special functions simply by entering data in the Excel worksheet.
(2) By using the solver, solutions for nonlinear equations, quadrature and ordinary differential equations can be obtained using the formulas entered in the Excel worksheet by menu operation.
(3) The VBA subroutine library provides subroutines that can be called from Excel VBA. Using the professional numerical computation routines provided by the library, advanced numerical application programs for Excel can be developed easily.

XLPack works with Excel 2013 / 2016 / 2019 / 2021 / 365. No other development tools are required.

“XLPack Basic” allows you to use basic 27 worksheet functions and 138 VBA subroutines/functions.

In addition, you can add more expert functions by installing separate app “XLPack Addon”. In that case, you will be able to use a total of 148 worksheet functions and 902 VBA subroutines.

Online manuals and sample worksheets are provided on the website (https://www.ktech.biz/manual/xlpack-60-manual/).

Major features of XLPack Basic

• Elementary and special functions
  Elementary transcendental functions, complex basic arithmetics, exponential integrals, logarithmic integrals, gamma functions, digamma function, error functions, Bessel functions, modified Bessel functions, complete elliptic integrals
• Linear algebra (LAPACK)
  Solution of systems of linear equations (general matrices, symmetric positive definite matrices)
  Eigenvalues and eigenvectors (symmetric matrices)
  Linear least squares method (QR decomposition), variance covariance matrices
• Interpolation
  Piecewise cubic spline interpolation and its quadrature
• Nonlinear equations
  Roots of polynomials (Newton method)
  Solution of single general nonlinear equation (Dekker’s method)
  Solution of system of nonlinear equations (Powell’s hybrid method)
• Nonlinear optimization
  Unconstrained optimization of general univariate function (Brent’s method)
  Unconstrained optimization of general multivariate function (quasi-Newton method)
• Quadrature
  Finite interval quadrature (user-defined integrand function) (fixed points) (15 point Gauss-Kronrod rule)
  Finite interval quadrature (user-defined integrand function) (automatic quadrature) (Gauss-Kronrod rule)
  Semi-infinite or infinite interval quadrature (user-defined integrand function) (automatic quadrature) (Gauss-Kronrod rule)
• Initial value problem of ordinary differential equations
  Non-stiff problems (Runge-Kutta-Fehlberg method)
• Fast Fourier transform (FFT)
  One-dimensional real fast Fourier transform
• Nonlinear least squares method
  Unconstrained nonlinear least squares problems (Levenberg-Marquardt method)
• Random number generation
  Uniform random numbers (Mersenne-Twister)