There are many demands on the small scale numerical calculations. For example, you can proceed with research and development efficiently if you can analyze experimental data and complete the model calculation by your own personal computer. However, considerable experience and expertise are required to develop and use numerical calculation software effectively.
Microsoft Excel is a widely used spreadsheet software. It is possible to develop programs with VBA (Visual Basic for Applications) and display the result in understandable visual form by graph functions. Excel becomes an easytouse and powerful numerical calculation tool running on your personal computer if the numerical calculation features are enhanced by XLPack.
What is XLPack ?
XLPack is a set of expansion modules of Excel for numerical calculation including features useful for wide range of scientific fields. Highly functional and efficient numerical calculation functions based on carefully selected highquality open software are provided.
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: These functions can be entered directly in the Excel worksheet. Just by inputting the data into a worksheet, you can you can calculate linear equations, eigenvalues, special functions, etc.

 Solver addin: Using the formulas entered in the Excel worksheet, solutions for nonlinear equations, quadrature and ordinary differential equations can be obtained by menu operation.
 Supporting VBA numerical programming

 VBA subroutine/function library: A variety of 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. Professional knowledge on numerical calculation is not required.
Performance of XLPack
 Fast binary modules are provided
Since XLPack modules have been compiled to the native binaries, they are faster than the programs developed by VBA.
The above figure shows the measurements of CPU time to solve systems of linear equations. In this example case, XLPack is much faster than the equivalent program coded by VBA.
 Efficient algorithms are adopted
XLPack employs the carefully selected programs that use the latest and most efficient algorithms.
The above figure shows the example of an initial value problem of ODE (ordinary differential equation). The (logarithm of) number of function evaluation needed to solve the problem is plotted against the relative error of the solution obtained. The function evaluations required by the algorithms used in XLPack are much less than those required by the algorithms commonly used in the own developed programs such as Euler method and 4th order RungeKutta method.
Target field of XLPack
XLPack can be used by researchers, engineers, students and any person who are using Excel.
 As a tool for researchers and engineers
 Easy and practically fast numerical calculations for medium and small scale problems
 You can concentrate on your main job without spending time for the details of calculation
 As a development support tool
 For prototyping and onetime programming
 As a platform in education fields
 For study and training of numerical calculation
Introducing XLPack
You can introduce XLPack easily if you have the personal computer running Excel.
The following additional materials are provided to support the introduction of XLPack.
 XLPack Lite: Subset version with major features which is provided for users to confirm their software environment prior to purchase. Also individual users can use this version for noncommercial use.
 Sample worksheets: By referring these sample worksheets, you can start to use XLPack immediately. Example codes can also be found in the reference manual.
XLPack Version 5.2
Software requirements
 Windows version
 Windows 10, Windows 8.1 Update or Windows 7 SP1
 Office 365 Excel, Excel 2019, Excel 2016, Excel 2013 SP1 or Excel 2010 SP2
 macOS version
 macOS Mojave (10.14.5 or later)
 Excel for Mac (Office 365 (Subscription) or Office 2019 for Mac (Onetime purchase)) (16.26 (19060901) or later)
 The older versions cannot be used. XLPack does not work with Office 2016 for Mac (Onetime purchase).
Products
 XLPack
 Divided into four modules:
M1: Linear computation (real), M2: Linear computation (complex), M3: Special functions, nonlinear computation, M4: Interpolation, differential/integral equations, random numbers
 VBA subroutine/function library routines: 708 (total)
 Worksheet function library routines: 132 (total)
 Solver addin (for M3 and M4)
 1,400 page PDF manuals
 Sample worksheets
 XLPack Lite: Subset version with major features. Same software requirements and performance as product version
 For evaluation and confirmation before purchasing product
 For personal use except commercial purposes
Features

 Module 1
 Linear computation (systems of linear equations, eigenvalue problems, linear least squares problems) (real)
 Module 2
 Linear computation (systems of linear equations, eigenvalue problems, linear least squares problems) (complex)
 Module 3
 Special functions
 Nonlinear equations (Algebraic equations, solution of nonlinear equations)
 Nonlinear optimization
 Fast Fourier transform
 Nonlinear least squares problems
 Module 4
 Interpolation
 Quadrature
 Ordinary differential equations
 Random numbers
 Detail function list: Open in a separate tab
XLPack API
The interface for other programs than Excel to use numerical calculation module of XLPack (XLPack API) is provided. By using XLPack API, numerical calculation programs can be developed in C/C++ (or other languages which can call C program (C#, F#, Python, etc.)).
Refer to here for more details.
Related links