XLPack

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 easy-to-use 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 high-quality 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 add-in: 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.

Perf

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 Runge-Kutta 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 one-time 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 (One-time purchase)) (16.26 (19060901) or later)
    • The older versions cannot be used. XLPack does not work with Office 2016 for Mac (One-time 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 add-in (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
  • Major 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

    Top