| forum.alglib.net http://forum.alglib.net/ |
|
| Eigenvals/vecs in VBA http://forum.alglib.net/viewtopic.php?f=2&t=44 |
Page 1 of 1 |
| Author: | danguetta [ Tue Jul 27, 2010 3:05 pm ] |
| Post subject: | Eigenvals/vecs in VBA |
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 |
|
| Author: | Doug Jenkins [ Tue Jul 27, 2010 11:53 pm ] |
| Post subject: | Re: Eigenvals/vecs in VBA |
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. |
|
| Author: | danguetta [ Fri Jul 30, 2010 2:54 pm ] |
| Post subject: | Re: Eigenvals/vecs in VBA |
Doug Jenkins wrote: 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. Thanks so much! Very helpful indeed! Daniel |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|