XNUMBERS - Multi Precision Floating Point Calculus For EXCEL

Category	Type	Name	Description
Arithmetic	Function	baseChange	Converts a number from one base to another
Arithmetic	Function	cvBaseDec	converts any base (2 to 16) into decimal
Arithmetic	Function	cvBinDec	converts binary into decimal
Arithmetic	Function	cvDecBase	converts decimal-base into any base (2 to 16)
Arithmetic	Function	cvDecBin	converts decimal into binary
Arithmetic	Function	xabs	Multiprecision Absolute value
Arithmetic	Function	xadd	Multiprecision Addition
Arithmetic	Function	xdiv	Multiprecision Division
Arithmetic	Function	xdivint	Multiprecision integer division
Arithmetic	Function	xeval	Multiprecision evaluator
Arithmetic	Function	xevall	Multi-precision evaluator
Arithmetic	Function	xmod	Multiprecision remainder of integer division
Arithmetic	Function	xmult	Multiprecision Multiplication
Arithmetic	Function	xpow	Multiprecision Raise to power
Arithmetic	Function	xroot	Multiprecision Nth- Root
Arithmetic	Function	xsqr	Multiprecision Square Root
Arithmetic	Function	xsub	Multiprecision Subtraction
Complex	Function	cplx_eval	Complex evaluator
Complex	Function	cplx_integr	Complex Integration f(z) - Romberg method
Complex	Function	cplx_serie	Complex serie expansion
Complex	Function	cplxabs	Complex absolute
Complex	Function	cplxacos	Complex Inverse Cos
Complex	Function	cplxacosh	Complex Inverse Hyperbolic Cos
Complex	Function	cplxadd	Complex Addition
Complex	Function	cplxasin	Complex Inverse Sin
Complex	Function	cplxasinh	Complex Inverse Hyperbolic Sin
Complex	Function	cplxatan	Complex Inverse Tan
Complex	Function	cplxatanh	Complex Inverse Hyperbolic Tan
Complex	Function	cplxconj	Complex conjugate
Complex	Function	cplxcos	Complex Cos
Complex	Function	cplxcosh	Complex Hyperbolic Cos
Complex	Function	cplxdigamma	Complex digamma
Complex	Function	cplxdiv	Complex Division
Complex	Function	cplxei	Complex Exponential Integral
Complex	Function	cplxEquation2	Complex equation of 2° degree
Complex	Function	cplxerf	Complex Error Function
Complex	Function	cplxerfc	Complex Complem. Error Function
Complex	Function	cplxExp	Complex function exp (z)
Complex	Function	cplxgamma	Complex Gamma Function
Complex	Function	cplxgammaln	Complex Logarith. Gamma Function
Complex	Function	cplxinv	Complex inverse. 1/z
Complex	Function	cplxLn	Complex function Ln(z)
Complex	Function	cplxmult	Complex Multiplication
Complex	Function	cplxneg	Complex opposite. -z
Complex	Function	cplxpolar	Polar Conversion
Complex	Function	cplxpow	Complex Power
Complex	Function	cplxrect	Rectangular Conversion
Complex	Function	cplxroot	Complex Root
Complex	Function	cplxsin	Complex Sin
Complex	Function	cplxsinh	Complex Hyperbolic Sin
Complex	Function	cplxsub	Complex Subtraction
Complex	Function	cplxtan	Complex Tangent
Complex	Function	cplxtanh	Complex Hyperbolic Tan
Complex	Function	cplxzeta	Complex Zeta Function
Complex	Function	xcplxabs	Multiprecision Complex absolute
Complex	Function	xcplxadd	Multiprecision Complex Addition
Complex	Function	xcplxconj	Multi-precision complex conjugate
Complex	Function	xcplxdiv	Multiprecision Complex Division
Complex	Function	xcplxExp	Multiprecision Complex function exp (z)
Complex	Function	xcplxinv	Multi-precision complex inverse. 1/z
Complex	Function	xcplxLn	Multiprecision Complex function Ln(z)
Complex	Function	xcplxmult	Multiprecision Complex Multiplication
Complex	Function	xcplxneg	Multi-precision complex opposite. -z
Complex	Function	xcplxpolar	Multiprecision Polar Conversion
Complex	Function	xcplxpow	Multiprecision Complex Power
Complex	Function	xcplxrect	Multiprecision Rectangular Conversion
Complex	Function	xcplxroot	Multiprecision Complex Radix
Complex	Function	xcplxsub	Multiprecision Complex Subtraction
Derivatives, limits	Function	Diff1	First derivative of f(x)
Derivatives, limits	Function	Diff2	Second derivative of f(x)
Derivatives, limits	Function	Grad	Gradient of f(x,y,z)
Derivatives, limits	Function	Hessian	Hessian matrix
Derivatives, limits	Function	Jacobian	Jacobian matrix
Equations	Function	Zero_bisec	zero of f(x) with bisection method
Equations	Function	Zero_sec	zero of f(x) with secant method
Integrals, Series	Function	Convol	Convolution
Integrals, Series	Function	DFSP	Discrete Fourier Spectrum
Integrals, Series	Function	DFSP_INV	Inverse of Discrete Fourier Spectrum
Integrals, Series	Function	DFT	Discrete Fourier Transformation
Integrals, Series	Function	DFT_INV	Discrete Fourier Inverse Transformation
Integrals, Series	Sub	DFT_Routines	Discrete Fourier Transform
Integrals, Series	Sub	DFT2D_Routines	2D -Discrete Fourier Transform
Integrals, Series	Function	FFT	Fast Fourier Transformation
Integrals, Series	Function	FFT_INV	Fast Fourier Inverse Transformation
Integrals, Series	Function	FFT2D	2D Fast Fourier Transform
Integrals, Series	Function	FFT2D_INV	2D Inverse Fast Fourier Transform
Integrals, Series	Function	Fourier_cos	Fourier cosine transform
Integrals, Series	Function	Fourier_sin	Fourier sine transform
Integrals, Series	Function	Integr	Integration f(x)
Integrals, Series	Function	Integr_2D	2D Integral f(x, y) - Romberg method
Integrals, Series	Function	Integr_de	Integration f(x) - Double Exponential method
Integrals, Series	Function	Integr_fcos	Integration with cos Filon's formula
Integrals, Series	Function	Integr_fsin	Integration with sin Filon's formula
Integrals, Series	Function	Integr_nc	Integration f(x) - Newton-Cotes formulas
Integrals, Series	Function	Integr_ro	Integration f(x) - Romberg method
Integrals, Series	Sub	Integr2D	2D Integration routine - Romberg method
Integrals, Series	Sub	Integral_Inf	Infinite Integral
Integrals, Series	Function	IntegrDataC	Integration of data vector - Newton-Cotes formulas
Integrals, Series	Function	IntegrDataR	Integration of data vector - Romberg method
Integrals, Series	Function	IntRombergMat	Integration Romberg matrix
Integrals, Series	Sub	Samples_Generate	Samples generator
Integrals, Series	Function	Serie_trig	Trigonometric serie
Integrals, Series	Function	Serie2D_trig	Trigonometric serie 2D
Integrals, Series	Function	xSerie	Series of function
Integrals, Series	Function	xSerie2D	Double Series of function
Interpolation	Function	cspline_coeff	Cubic Spline Coefficients
Interpolation	Function	cspline_eval	Cubic Spline Interpolation (fast formula)
Interpolation	Function	cspline_interp	Cubic Spline Interpolation
Interpolation	Function	cspline_pre	Cubic Spline 2nd derivative values
Interpolation	Function	Extrap_Delta2	Extrapolation by Aitken's square-delta method
Interpolation	Function	Fract_Interp	interpolation with continuous fraction
Interpolation	Function	Fract_Interp_Coef	coefficients of interpolation with continuous fraction
Interpolation	Function	Interp_Mesh	linear interpolation of a 2D function
Interpolation	Function	InterpL	multi linear interpolation
Interpolation	Function	InterpL_Coef	Coefficients of multi linear interpolation
Interpolation	Function	PolyInterp	Polynomial Interpolation
Interpolation	Function	PolyInterpCf	returns coefficients of polynomial interpolation
Interpolation	Function	xExtrap_Delta2	Multiprecision Extrapolation by Aitken's square-delta method
Interpolation	Function	xFract_Interp	Multiprecision interpolation with continue fraction
Interpolation	Function	xFract_Interp_Coef	Multiprecision interpolation with continue fraction
Linear Algebra	Function	SYSLIN_ITER_G	Solve Linear System by iterative Gauss-Seidel method
Linear Algebra	Function	xMat_BAB	Multiprecision similarity transformation
Linear Algebra	Function	xMat_LU	Multiprecision Matrix LU decomposition
Linear Algebra	Function	xMatAbs	Multiprecision Modulus of Vectors or Matrix
Linear Algebra	Function	xMatAdd	Multiprecision Addition of two matrices
Linear Algebra	Function	xMatDet	Multiprecision Determinant of a Square Matrix
Linear Algebra	Function	xMatInv	Multiprecision Inverse of a square matrix
Linear Algebra	Function	xMatMult	Multiprecision Multiplication of two matrices
Linear Algebra	Function	xMatPow	Multiprecision power of square matrix
Linear Algebra	Function	xMatSub	Multiprecision Subtraction of two matrices
Linear Algebra	Function	xProdScal	Multiprecision Scalar product of two vectors
Linear Algebra	Function	xMat_LL	Multiprecision Cholesky decomposition
Linear Algebra	Function	xProdVect	Multiprecision vector product
Linear Algebra	Function	xSYSLIN	Multiprecision Solve Linear System
Manipulation	Function	DigitsAllDiff	Check digits
Manipulation	Function	flip	Vector inversion
Manipulation	Function	isXnumber	Check multiprecision number
Manipulation	Sub	Range_Xnumber_Format	Xnumbers format
Manipulation	Sub	Range_Xnumber_MopUp	Xnumbers mop-up
Manipulation	Sub	Range_Xnumber_relround	Xnumbers relative rounding
Manipulation	Sub	Range_Xnumber_round	Xnumbers rounding
Manipulation	Sub	Range_Xnumber_Unformat	Xnumbers unformat
Manipulation	Function	Sort	Array sort
Manipulation	Function	xbreak	Multiprecision Breaking
Manipulation	Function	xcdbl	Converts multiprecision into double precision
Manipulation	Function	xcomp	Multiprecision Compare numbers
Manipulation	Function	xcvexp	Converts into scientific notation
Manipulation	Function	xdec	Returns the decimal part of an extended number
Manipulation	Function	xdgt	Digits count
Manipulation	Function	xdgts	Significant digits count
Manipulation	Function	xFormat	Format extended numbers
Manipulation	Function	xint	Multiprecision Integer part
Manipulation	Function	xneg	Multiprecision opposite
Manipulation	Sub	Xnumber_Double_Conv	Xnumbers conversion
Manipulation	Function	xround	Multiprecision rounding
Manipulation	Function	xroundr	Multiprecision relative rounding
Manipulation	Function	xsplit	Split into mantissa and exponent
Manipulation	Function	xtrunc	Mantissa of a number
Manipulation	Function	xUnformat	Remove all formattig characters
Numbers	Function	CheckPrime	Checks Prime number
Numbers	Function	DiophEqu	Diophantine equation
Numbers	Function	Factor	Number factorization
Numbers	Sub	Factorize	Factorize the number of active cell
Numbers	Function	fract	Fraction approximate
Numbers	Function	MCD	Maximun Common Divisor (GCD)
Numbers	Function	MCM	Minimun Common Multiple (LCM)
Numbers	Function	NextPrime	Next Prime number
Numbers	Function	prime	States whether a number is prime
Numbers	Sub	Prime_Test_Fermat	Probabilistic Fermat's Prime Test
Numbers	Sub	PrimeGenerator	Prime Table Generator
Numbers	Function	sumDigits	Add up the digits of an integer.
Numbers	Function	xfract	Multiprecision approximate fraction
Numbers	Function	xIsOdd	Odd/even check
Numbers	Function	xIsSquare	Perfect square check
Numbers	Function	xMCD	Maximun Common Divisor (GCD)
Numbers	Function	xMCM	Minimum Common Multiple (LCM)
ODE	Function	ODE_COR	ODE -Multi-step Corrector
ODE	Function	ODE_PRE	ODE - Multi-step Predictor
ODE	Function	ODE_RK4	ODE - Runge-Kutta 4
ODE	Function	ODE_SYSL	ODE - Linear System
Optimization	Sub	Optim1	Optimization for multivariable function (downhill-simplex)
Optimization	Sub	Optim3	Optimization for movariable function (divide-and-conquer algorithm)
Polynomial	Function	DPOLYN	Multiprecision Polynomial Derivative Calculus
Polynomial	Function	Poly_ChebychevT	Chebychev orthogonal polynomial of 1st kind
Polynomial	Function	Poly_ChebychevU	Chebychev orthogonal polynomial of 2st kind
Polynomial	Function	Poly_Gegenbauer	Gegebauer orthogonal polynomial
Polynomial	Function	Poly_Hermite	Hermite orthogonal polynomial
Polynomial	Sub	Poly_Horto_Coeff	Coefficients of ortogonal polynomials
Polynomial	Sub	Poly_Horto_Zero	Roots of ortogonal polynomials
Polynomial	Function	Poly_Jacobi	Jacobi orthogonal polynomial
Polynomial	Function	Poly_Laguerre	Generalized Laguerre orthogonal polynomial
Polynomial	Function	Poly_Legendre	Legendre orthogonal polynomial
Polynomial	Function	Poly_Weight_ChebychevT	Weight of the Chebychev orthogonal polynomial of 1st kind
Polynomial	Function	Poly_Weight_ChebychevU	Weight of the Chebychev orthogonal polynomial of 2st kind
Polynomial	Function	Poly_Weight_Gegenbauer	Weight of the Gegebauer orthogonal polynomial
Polynomial	Function	Poly_Weight_Hermite	Weight of the Hermite orthogonal polynomial
Polynomial	Function	Poly_Weight_Jacobi	Weight of the Jacobi orthogonal polynomial
Polynomial	Function	Poly_Weight_Laguerre	Weight of the generalized Laguerre orthogonal polynomial
Polynomial	Function	Poly_Weight_Legendre	Weight of the Legendre orthogonal polynomial
Polynomial	Function	PolyAdd	Adds two polynomials
Polynomial	Function	PolyBuild	Returns a polynomial from its roots
Polynomial	Sub	PolyBuildCfx	Multiprecision Polynomial Coefficients
Polynomial	Function	PolyCenter	Returns the center of a polynomial
Polynomial	Function	PolyDiv	Quotient of the division of two polynomials
Polynomial	Function	PolyInt	Returns an integer denormalized polynomial
Polynomial	Function	PolyMult	Multiplies two polynomials
Polynomial	Function	POLYN	Multiprecision Polynomial Calculus
Polynomial	Function	POLYN2	Multiprecision bi-variables polynomial evaluation
Polynomial	Function	PolyRadius	Returns the radius of polynomial roots circle
Polynomial	Function	PolyRem	Remainder of the division of two polynomials
Polynomial	Function	PolyRootMopUp	Mop-up polynomial roots
Polynomial	Function	PolyShift	Polynomial translation
Polynomial	Function	PolySolve	Roots of polynomial
Polynomial	Function	PolySub	Subtracts two polynomials
Polynomial	Function	PolyTerms	Vector of polynomial coefficients
Polynomial	Function	PolyWrite	Returns polynomial string from coefficients
Polynomial	Sub	RootFinderDK	Roots finder of polynomials (Durand-Kerner-Aberth)
Polynomial	Sub	RootfinderGN	Roots finder of polynomials (generalized Newton-Rapshon)
Polynomial	Sub	RootFinderJT	Roots finder of polynomials (Jenkins-Traub)
Polynomial	Function	SYSPOLY2	Solve a system of two 2nd degree polynomials
Special functions	Function	AiryA	Airy function A(x)
Special functions	Function	AiryAD	Derivative Airy function A'(x)
Special functions	Function	AiryB	Airy function A(x)
Special functions	Function	AiryBD	Derivative Airy function B'(x)
Special functions	Function	BesseldI	First derivative of mod. Bessel functions I'n(x)
Special functions	Function	BesseldJ	First derivative of Bessel functions J'n(x)
Special functions	Function	BesseldK	First derivative of mod. Bessel functions K'n(x)
Special functions	Function	BesseldY	First derivative of Bessel functions Y'n(x)
Special functions	Function	BesselI	Modified Bessel function In(x)
Special functions	Function	BesselJ	Bessel function Jn(x)
Special functions	Function	BesselK	Modified Bessel function Kn(x)
Special functions	Function	BesselY	Bessel function Yn(x)
Special functions	Function	CosIntegral	Cosine integral Ci(x)
Special functions	Function	digamma	Digamma function
Special functions	Function	exp_integr	Exponential integral Ei(x) for x >0
Special functions	Function	expn_integr	Exponential integral En(x)
Special functions	Function	Fresnel_cos	Fresnel cosine integral
Special functions	Function	Fresnel_sin	Fresnel Sine integral
Special functions	Function	Hypergeom	Hypergeometric function
Special functions	Function	IElliptic1	Elliptic integral of 1st kind
Special functions	Function	IElliptic2	Elliptic integral of 2nd kind
Special functions	Function	SinIntegral	Sine integral Si(x)
Special functions	Function	xBeta	Beta function
Special functions	Function	xBetaI	Incomplete Beta function
Special functions	Function	xFib	Multiprecision Fibonacci number
Special functions	function	xGamma	Gamma function using Lanczos formula
Special functions	function	xGammaF	Gamma Fisher's distribution factor
Special functions	Function	xGammaI	Incomplete Gamma function
Special functions	Function	xGammaln	Natural log of gamma function
Special functions	Function	xGammalog	Decimal log of gamma function
Special functions	Function	xGammaQ	Quotient of two gamma functions q= qamma(x1)/gamma(x2)
Special functions	Function	xGm()	Euler-Mascheroni gamma constant
Special functions	Function	zeta	Riemann Zeta function
Statistical	Function	errfun	Integral of Gauss' standard error function
Statistical	Function	mjkLRE	Log Relative Error (LRE)
Statistical	Function	RegLinRM	Linear Regression with Robust Method
Statistical	Function	xcomb	Multiprecision Combinations C(n,k)
Statistical	Function	xperm	Multiprecision Permutations P(n,k)
Statistical	Function	xcomb_big	Combinations for large numbers
Statistical	Function	xfact	Multiprecision Factorial
Statistical	Function	xfact2	Double-step factorial (odd/even factorial)
Statistical	Function	xgmean	Multiprecision Geometric Mean
Statistical	Function	xLRE	Multiprecision Log Relative Error (LRE)
Statistical	Function	xmean	Multiprecision Arithmetical Mean
Statistical	Function	xqmean	Multiprecision Quadratic Mean
Statistical	Function	xRegLin_Coeff	Multiprecision Linear Regression
Statistical	Function	xRegLin_Covar	Multiprecision Cross-Covariance Matrix
Statistical	Function	xRegLin_Eval	Multiprecision Linear Regression evaluation
Statistical	Function	xRegLinStat	Multiprecision Linear Regression statistics
Statistical	Function	xstdev	Multiprecision Standard Deviation
Statistical	Function	xstdevp	Multiprecision Pop. Standard Deviation
Statistical	Function	xvar	Multiprecision Variance
Statistical	Function	xvarp	Multiprecision Pop. Variance
Transcendental	Function	xacosh	Multiprecision Inverse Hyperbolic Cosine
Transcendental	Function	xasinh	Multiprecision Inverse Hyperbolic Sine
Transcendental	Function	xatanh	Multiprecision Inverse Hyperbolic Tangent
Transcendental	Function	xcosh	Multiprecision Hyperbolic Cosine
Transcendental	Function	xe	Multiprecision Constant e
Transcendental	Function	xeu	Euler-Mascheroni gamma constant
Transcendental	Function	xexp	Multiprecision Exponential
Transcendental	Function	xexp_base	Multiprecision Exponential base B
Transcendental	Function	xLn	Multiprecision natural logarithm (Neper’s)
Transcendental	Function	xLN10	Multiprecision Constant Ln(10)
Transcendental	Function	xLN2	Multiprecision Constant Ln(2)
Transcendental	Function	xLog	Multiprecision decimal logarithm (Brigs’)
Transcendental	Function	xsinh	Multiprecision Hyperbolic Sine
Transcendental	Function	xtanh	Multiprecision Hyperbolic Tangent
Trigonometric	Function	x2Pi	Multiprecision Constant 2Pi
Trigonometric	Function	xacos	Multiprecision Arccos
Trigonometric	Function	xanglecompl	Multiprecision Complement of right angle
Trigonometric	Function	xasin	Multiprecision Arcsin
Trigonometric	Function	xatan	Multiprecision Arctan
Trigonometric	Function	xcos	Multiprecision Cos
Trigonometric	Function	xPi	Multiprecision Constant Pi
Trigonometric	Function	xPi2	Multiprecision Constant Pi /2
Trigonometric	Function	xPi4	Multiprecision Constant Pi /4
Trigonometric	Function	xsin	Multiprecision Sin
Trigonometric	Function	xtan	Multiprecision Tan

TOP

Home