XLPack

XLPack is a set of expansion programs for Excel for numerical calculation which is developed for easy calculations on office/home PCs. It adds the features useful for wide range of scientific fields to Excel. Excel is a widely used spreadsheet software. It is possible to program with VBA* and display the result in understandable visual form by graph functions. It can become an easy-to-use and powerful numerical calculation tool by enhancing the numerical calculation functions. (* Visual Basic for Applications: Built-in macro language of Excel)

Software contents

XLPack consists of worksheet function library, solver and VBA subroutine/function library. These can be divided into two types: tools for numerical calculations without programming and tools that support programming.

Numerical calculation without programming

Worksheet function library

Worksheet functions which can be entered directly in the Excel worksheet are provided. Just by inputting the data into a worksheet, you can compute solution of linear equations, eigenvalues, special functions, etc.

Example of worksheet function

Solver add-in

Using the formulas entered in the Excel worksheet, solutions of nonlinear equations, quadrature and ordinary differential equations can be obtained by menu operation.

Example of solver add-in

Supporting VBA numerical programming

VBA subroutine/function library

Subroutines and functions which can be called from Excel VBA are provided. By using these subroutines and functions, advanced numerical application programs can be developed in a short development period without professional knowledge on numerical calculation.

Performance of XLPack

Fast computation

XLPack computes faster than the equivalent VBA program. The figure below shows the measurement results of the CPU time required to solve simultaneous linear equations. In this example, the solution was obtained approximately thousand times faster when using XLPack compared to the program developed entirely with VBA. Even with a popular processor (Core i3 14100), simultaneous linear equations with 5000 elements can be solved at a practical speed of approximately 1.3 seconds.

CPU time of linear calculations

Efficient algorithms

XLPack employs the latest efficient algorithms. The following figure shows the example of an initial value problem of ODE (ordinary differential equation). The logarithm of number of function evaluations is plotted against the relative error of the solution. The number of function evaluations required by the algorithms used in XLPack are less than those required by commonly used Euler method and 4th order Runge-Kutta method.

Computation amount of ordinary differential equations

Use cases

Calculation tool for researchers and engineers
- Provides easy and practically fast numerical calculations for medium and small scale problems
- Researchers and engineers can concentrate on their main job without spending time for the details of calculation
Development support tool
- Used for prototyping and one-time programs
Platform in education fields
- Used for study and training of numerical calculation

XLPack Version 7.0

Software requirements

Windows 10 (Version 22H2) or Windows 11
Excel of Office 365, 2024, 2021, 2019 or 2016

Features

You can download and use XLPack Basic (base program). It provides the basic functions with 216 VBA functions, 27 worksheet functions and solver. It is powerful enough to perform general calculations.

By installing XLPack Addons (extension modules), extension functions divided into five extension modules can be added. The total numbers of VBA functions and worksheet functions including base program and all extension modules are 1385 and 216, respectively.

The detail list of functions is as follows. The orange parts are provided as basic functions.

XLPack detail list of functions

Products

XLPack Basic (base program)
- This is the base program of XLPack and provides basic functions.
- You can download it from this site or install it as “XLPack Basic” from the Microsoft Store. It is free to use.

XLPack Addons (extension modules)
- The extended functions are divided into five modules – M1: Linear computation (real), M2: Linear computation (complex), M3: Special functions, nonlinear computation, M4: Interpolation, differential/integral equations, random numbers, M5: Sparse matrix computation (see more details in the detail list of functions above)
- It can be installed as “XLPack Addons” from the Microsoft Store for free. You can purchase one year license for each necessary module in Microsoft Store by in-app purchase so that you can introduce necessary features at the lowest possible cost. One license can be used on up to 10 PCs.
- Manuals and sample worksheets are available online

For the detail installation and setup procedures, see XLPack 7.0 User’s Guide.

XLPack API

Calculation modules of XLPack can be called through this interface as the numerical library from other languages such as C/C++, Python and C#.

Refer to XLPack 7.0 API Guide for more details.

Changes from XLPack 6.1

See for details in release notes.

XLPack 7.0 Release Notes
XLPack Basic 7.0 Release Notes