XLPack

XLPack is a set of expansion modules of 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 use 27 major worksheet functions and 175 major VBA subroutines/functions in the basic function package. It is sufficiently powerful for normal calculations.

In addition, the introduction of five extension modules (Modules 1 – 5) will add more advanced features, and then a total of 216 worksheet functions and 1218 VBA functions/subroutines can be used.

The detail list of functions is as follows.

XLPack detail list of functions

The orange parts are provided as basic functions.

Products

XLPack Basic (basic functions)
- Basic function package with major features. Same software requirements and performance as full version
- You can download from this site or install it as “XLPack Basic” from the Microsoft Store. The license is free

XLPack Addons (additional functions)
- Additional 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 Microsoft Store, and each module can be purchased by in-app purchase
- 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