Friday - 04th of July 2008
Check the Latest News!

XL Toolboxes

A SpreadsheetWorld, Inc. Website

XLEigensystem Analysis PDF Print E-mail

Eigenvalue/Vectors in Excel and VBA
SpreadsheetWorld Advanced Integrated Systems Design

Features: XLLink is
  • Real Matrices
  • Complex Matrices
  • Embed Function into Worksheets
  • Iterate Inputs
  • Integrated with Other Models
  • Affordable
  • Scalable
  • Effective
  • Innovative
  • User Friendly
  • Fast

This toolbox provides the ability to calculate the real and complex eigenvalues and eigenvectors for matrices. The original matrices can be either real or complex. These functions are useful in calculation natural frequencies of dynamic systems, and in the process of solving systems of linear differential equations. This Toolbox includes the following functions:

This toolbox provides the ability to calculate the real and complex eigenvalues and eigenvectors for matrices. The original matrices can be either real or complex. These functions are useful in calculation natural frequencies of dynamic systems, and in the process of solving systems of linear differential equations. The toolbox includes following 8 functions which can be used from either a worksheet cell or called from VBA:

EIG_EigValsRealMatrix(AMatrix)
Computes all the eigenvalues L of real matrix A in the reduced eigenvalue problem Ax=Lx.

EIG_EigValsCmplxMatrix(AMatrix)
Computes all the eigenvalues L of a complex matrix A in the reduced eigenvalue problem Ax=Lx.

EIG_EigVecsRealMatrix(AMatrix)
Computes all the eigenvectors x of a real matrix in the reduced eigenvalue problem Ax=Lx.

EIG_EigVecsCmplxMatrix(AMatrix)
Computes all the eigenvectors x of a complex matrix in the reduced eigenvalue problem Ax=Lx.

EIG_EigValsRealMatrix2(AMatrix,BMatrix)
Computes all the eigenvalues L of a generalized real eigensystem Ax=LBx.

EIG_EigValsCmplxMatrix2(AMatrix,BMatrix)
Computes all the eigenvalues L of a generalized complex eigensystem Ax=LBx.

EIG_EigVecsRealMatrix2(AMatrix,BMatrix)
Computes all the eigenvectors x of a generalized real eigensystem Ax=LBx.

EIG_EigVecsCmplxMatrix2(AMatrix,BMatrix)
Computes all the eigenvectors x of a generalized complex eigensystem Ax=LBx.

(170KB)

Buy now at SpreadsheetWorld.com

 
< Prev   Next >