XNUMBERS 5.6 - Multi Precision Floating Point Computing and Numerical Methods for EXCELâ

XNUMBERS 5.6 - Multi Precision Floating Point Computing and Numerical Methods for EXCELâ
Xnumbers is an Excel addin (xla) that performs multi-precision floating point arithmetic from 1 up to 250 significant digits. It is compatible with Excel XP and consists of a set of more than 270 functions/macros for arithmetic, complex , trigonometric, logarithm, exponential calculus. Linear Algebra: System resolution with Gauss-Jordan algorithm (also in a didactic step-by-step method). Gauss-Seidel iterative method. Matrix operations. Determinant. Matrix Inversion. Characteristic Polynomial with Newton-Girard formulas. Crout's algorithm for LU decomposition. Similarity Transform. Matrix power. Polynomials: symbolic computation to add, multiply, divide polynomials. Derivatives of polynomials. Interpolation with Newton formula. Rootfinder algorithms: Jenkins-Traub, Durand-Kerner-Aberth, Newton Generalized, Laguerre, Siljak, Ruffini. Orthogonal polynomials. Numbers Theory: MCD, MCM, factorization, prime number, fraction reduction, modular power, Diophantine equation, Brouncker-Pell Equation, Integer relation with PSLQ algorithm. Statistic: Mean, Variance, Multivariable Linear Regression, LRE, Probability distributions. Integration : Double Exponetial, Romberg , 2D Romberg, Complex integration, Newton-Cotes, Filon, FFT, DFT, 2D-FFT, Infinite integral. Numerical Series evaluation, real and complex serie. Special function: high precision 64b Bessel, Gamma, Gammaln, Digamma, Incomplete Gamma, Fresnel, integral sine-cosine, exponential integral, error function, Beta, Incomplete Beta, Fibonacci, Airy functions, Elliptic integrals. Interpolation : polynomial, fractional, cubic spline, 2D random interpolation. Derivativse: Gradient vector, Jacobian matrix, Hessian matrix. Diff Equat. Runge-Kutta-4, Adams’s multi-steps, Runge-Kutta-Fehlberg. Optimization on site with Downhill-Simplex (Nelder Maid) algorithm. For further details see XNUMBERS- Multi Precision Computing Tutorial of Numerical Analysis with Xnumbers.xla -Vol 1. Nov. 2007, PDF (2.5 MB) , Ó 2007 by Foxes Team. Download at the document section
Download xnumb56.zip v 5.6 Feb 2008 (2.3 MB) . - last update 16-2-2008 - REVIEW
FIRE-UP your Excel macros! XNUMBERS DLL ActiveX - Multi Precision Math Library
Xnumbers.dll is a free math library that encapsulates the multiprecision arithmetic engine of the Xnumbers.xla addin for Excel. It's an ActiveX DLL for VBA and Visual Basic that performs multi-precision floating point arithmetic from 1 up to 200 significant digits. It is compatible with Win2000/NT/XP and consists of a set of more than 90 functions for arithmetic, trigonometric, logarithm, exponential and matrix calculus. Complete of Reference Guide. (for smart programmer only!) Download xnumbersdll.zip v 1.1.7 Dic .2008 (0.8 MB) . - last update 5-12-2008 - REVIEW
	MATRIX 2.3 - Matrix and Linear Algebra functions for EXCELâ
	This Excel XP addin contains useful functions for Matrix and Linear Algebra. Norm. Matrix multiplication. Similarity Transform. Determinant. Inverse. Power. Trace. Scalar Product. Vector Product. Eigenvalues and Eigenvectors of symmetric matrices with Jacobi algorithm. Jacobi rotation matrix. Real and complex Eigenvalues with QR algorithm. Eigenvalues of tridiagonal matrices with QL algorithm. Characteristic polynomial. Random matrices with given eigenvalues. Random matrices with given Rank or Determinant. Several useful matrices: Hilbert's, Houseolder's, Tartaglia's, Vandermonde's. Hessemberg form. Gauss-Jordan algorithm step by step. Linear Systems. Solving Linear Systems with iterative methods: Gauss-Seidel and Jacobi algorithms. Singular Linear Systems. Linear Transformation. Gram-Schmidt's Orthogonalization. Matrix Factorization: LU, QR, QH, SVD and Cholesky decomposition. Sub-matrix extractor. Rank. Floyd's shortest-path algorithm. Complex matrix operations. Complex Inversion. Complex Linear Systems. Complex Eigenvalues/Eigenvectors of real and complex matricies. Lin-Bairstow polynomial root finder. Polynomial rootfinder with HQR algorithm. Linear system with tridiagonal matrix. Inversion of tridiagonal matrix. Block-triangular reduction. Toeplitz Linear System. Linear, polynomial and pieces-polynomial regression. Admittance matrix of Linear Network. Leontief matrix All functions work in standard 32 bit precision. Sparse linear system. For further details see MATRIX function list. Help on line. No installation. Freeware and open source. For math fans! Tutorial of Numerical Analysis with Matrix.xla -Vol. 1 and 2, PDF (1.2+1.2 MB) , Ó Dic. 2006 by Foxes Team. Download at the document section
	Download matrix.zip v 2.3.2 March 2007 (1.0 MB) . - last update 18-1-2007 - REVIEW
	MATRIX 2.3 Light -This version contains only function macros (no sub macro, no menu, no DLL, no help). It has set up for old Excel versions and for MAC OS system. Not fully tested. This add-in is provided as a courtesy to others that may find it useful, but use it with your own responsibility. Download MatrixL.zip v 2.3 Dic 2006 (0.4 MB) . - last update 4-12-2006