Community
 
Aggiungi lista preferiti Aggiungi lista nera Invia ad un amico
------------------
Crea
Profilo
Blog
Video
Sito
Foto
Amici
   
 
 

MATRIX
Matrix and Linear Algebra Functions for EXCEL

By Foxes & C

Macros List of MATRIX add-in ver. 2.3  (update of 1-12-2006)

Function/Sub Name

Description

GJstep

Gauss-Jordan algorithm step by step

MAbs

Norm of vector or matrix

MAbsC

Norm of complex vector or matrix

MAdd

Matrix addition

MAddC

Complex matrix addition

MBAB

Similarity transform [B]*[A]*[B]^-1

MCond

Matrix condition number

MpCond

Log10 of matrix condition number

MDet

Determinant

MDetC

Determinant for complex matrix

MDet3

Determinant for tridiagonal matrices

MDetPar

Parametric Determinant

MDiag

Diagonal matrix

MExp

Matrix exponential e^[M]

MExpErr

Error of matrix exponential

MIde

Matrix Identity (I)

MInv

Matrix inverse [A]^-1

MInvC

Complex Matrix inverse [A]^-1

MMultC

Complex matrix multiplication

MMultTpz

Toeplitz matrix and vector multiplication

MMult3

Tridiagonal matrix multiplication

MPow

Matrix power [A]^n

MPowC

Complex matrix power [A]^n

MProd

Matrix product [A]*[B]*[C]*….

MMultS

Matrix scalar multiplication

MMultsC

Complex matrix scalar multiplication

MRank

Rank of matrix

MSub

Matrix subtraction

MSubC

Complex matrix subtraction

MTrace

Matrix Trace

MAdm

Admittance matrix of a linear passive network

MBlock

block-partitioned matrix

MBlockPerm

Permutation vector of block-partitioned matrix

MCholesky

Cholesky decomposition

MHessemberg

Hessemberg form

MHilbert

Hilbert's matrix

MHilbertinv

Inverse Hilbert's matrix

MHouseholder

Houseolder matrix

MLeontInv

Leontief inverse matrix for Input Output Analysis

MLU

LU decomposition

MPseudoinv

Moore-Penrose pseudo-inverse

MQH

QH decomposition

MQR

QR decomposition

MQRiter

Diagonalization with the QR iterative method

MTartaglia

Tartaglia's matrix

MVandermonde

Vandermonde's matrix

MChar

Characteristic matrix

MCharC

Complex Characteristic matrix

MCharPoly

Characteristic polynomial coefficients

MCharPolyC

Complex characteristic polynomial coefficients

MCmp

Companion matrix

MCorr

Correlation matrix

MCovar

Covariance matrix

MCplx

Converts 2 real matrices into a complex matrix

MDiagExtr

Diagonal extractor

MEigenSortJacobi

Sorts eigenvectors for eigenvalues amplitude

MEigenvalJacobi

Eigenvalues of symmetric matrix with Jacobi algorithm

MEigenvalMax

Dominant eigenvectors with power method

MEigenvalPow

Eigenvectors with power method

MEigenvalQL

Eigenvalues of tridiagonal matrix

MEigenvalQR

Eigenvalues of real matrix with QR algorithm

MEigenvalQRC

Eigenvalues of complex matrix with QR algorithm

MEigenvalTTpz

Eigenvalues of tridiagonal Toeplitz matrix

MEigenvec

Eigenvector

MEigenvecC

Complex eigenvector

MEigenvecJacobi

Eigenvectors of symmetric matrix with Jacobi algorithm

MEigenvecMax

Dominant eigenvalues with power method

MEigenvecPow

Eigenvalues with powers' method

MEigenvecT

Eigenvectors of tridiagonal matrix

MEigenvecInv

Eigenvector with inverse algorithm

MEigenvecInvC

Complex eigenvector with inverse algorithm

MExtract

Extract sub-matrix

MMopUp

Eliminates round-off errors

MNorm

Vector or Matrix Norm

MNormalize

Vectors Normalization

MNormalizeC

Complex Vectors Normalization

MOrthoGS

Orthogonalization with Gram-Schmidt algorithm

MPerm

Permutation matrix

MRnd

Random matrix

MRndEig

Random matrix with given eigenvalues

MRndEigSym

Random symmetric matrix with given eigenvalues

MRndRank

Random matrix with given rank or determinant

MRndSym

Random symmetric matrix with given rank or det.

MRot

Orthogonal planar rotation matrix

MRotJacobi

Jacobi rotation matrix

MT

Matrix transpose

MTC

Complex Matrix transpose

MTH

Complex Matrix transpose-conjugate

PathFloyd

All-pairs-path matrix with Floyd algorithm

PathMin

Shortest path with Floyd algorithm

PolyRoots

Polynomial rootfinder (Siljak+Ruffini method)

PolyRootsQR

Polynomial rootfinder (QR method)

PolyRootsQRC

Complex polynomial rootfinder (QR method)

ProdScal

Scalar Product (inner)

ProdScalC

Complex scalar product

ProdVect

Vector Product

RegrCir

Circular regression

RegrL

Linear regression with SVD method

RegrP

Polynomial regression with SVD method

Simplex

Linear Optimization with Simplex algorithm

SVDD

SVD: returns D matrix

SVDU

SVD: returns U matrix

SVDV

SVD: returns V matrix

SysLin

Linear System solving

SysLinC

Complex Linear System solving

SysLinIterG

Linear System solving with Gauss-Seidel SOR algorithm

SysLinIterJ

Linear System solving with Jacobi algorithm

SysLinT

Triangular linear sistem solving

SysLinTpz

Toeplitz Linear System solving

SysLin3

Tridiagonal linear system solving

SysLinSing

Singular Linear System solving

TraLin

Linear Transform

VarimaxIndex

Varimax index of a given Factors matrix

VarimaxRot

Orthogonal rotation with Varimax Kaiser's

VectAngle

Angle between the two vectors v1, v2

Sub

Matrix Generator

Sub

Macro Toepliz matrix generator

Sub

Macro Shortest-Path

Sub

Macro Draw Graph

Sub

Macro Block reduction

Sub

Macro Matrix Operations

Sub

Macro Complex Matrix Operations

Sub

Macro Random matrix with given eigenvalues

Sub

Matrix Clean-up

Sub

Macro Matrix Round

Sub

Macro Sparse Matrix Operations

Sub

Macro Random sparse matrix

 

TOP

Home