У дома > Приложения > Средства разработчика
XLPack Basic

XLPack Basic

Издатель: K Technologies
разрешение: Бесплатно

Снимки экрана:

Минимальные
ОС
Архитектураx64,x86
Рекомендованные
ОС
Архитектураx64,x86

Описание

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)


Другим нравится

Windows Terminal
Windows Terminal
Бесплатно
Ubuntu 20.04.6 LTS
Ubuntu 20.04.6 LTS
Бесплатно
Ubuntu (Preview)
Ubuntu (Preview)
Бесплатно
CPI Explorer
CPI Explorer
Бесплатно
openSUSE Tumbleweed
openSUSE Tumbleweed
Бесплатно
Notifications Visualizer
Notifications Visualizer
Бесплатно
EasyConnect
EasyConnect
Бесплатно
C# Formatter
C# Formatter
Бесплатно
Microsoft Store Developer CLI
Microsoft Store Developer CLI
Бесплатно

отзывы

статия

относно XLPack Basic
Advertisement
най-добрите изтегляния
Популярные приложения
Лучшие приложения
We use cookies and other technologies on this website to enhance your user experience.
By clicking any link on this page you are giving your consent to our Privacy Policy and Cookies Policy.