forum.alglib.net

Hi there,

I'm trying to use the VBA version of Alglib to find eigenvalues and eigenvectors of a matrix in Excel.

I've added the evd.bas module, the ortfac.bas module and the ap.bas module into my project, and tried to run it. (EDIT: I also added the module mdlAblas.bas)

Unfortunately, it seems I'm missing some definitions. Excel tells me, for example, that the function GenerateReflection is missing - and there's a few others which I can see are missing.

I've tried to search for these functions in the user manual (http://www.alglib.net/translator/man/ma ... l#unit_evd) but they don't seem to be defined anywhere.

Could anyone help? Where can I find modules for these functions?

Thanks so much, for this and for the great library :-)

Daniel

Daniel - you might find the link below useful:

http://newtonexcelbach.wordpress.com/20 ... excel-vba/

It lists all the modules you need to get the matrix maths routines working, and gives a quick way to import them into the VB Editor. There is also a downloadable spreadsheet with Alglib based UDFs for matrix manipulation, with open source code. If you search the blog for AlgLib you'll find several other posts that may be useful as well.

_________________
Doug Jenkins
http://newtonexcelbach.wordpress.com/

Thanks so much! Very helpful indeed!

Daniel