forum.alglib.net

ALGLIB forum
It is currently Fri Mar 29, 2024 4:01 pm

All times are UTC


Forum rules


1. This forum can be used for discussion of both ALGLIB-related and general numerical analysis questions
2. This forum is English-only - postings in other languages will be removed.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Eigenvals/vecs in VBA
PostPosted: Tue Jul 27, 2010 3:05 pm 
Offline

Joined: Tue Jul 27, 2010 3:00 pm
Posts: 2
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


Top
 Profile  
 
 Post subject: Re: Eigenvals/vecs in VBA
PostPosted: Tue Jul 27, 2010 11:53 pm 
Offline

Joined: Sun May 16, 2010 11:42 pm
Posts: 63
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/


Top
 Profile  
 
 Post subject: Re: Eigenvals/vecs in VBA
PostPosted: Fri Jul 30, 2010 2:54 pm 
Offline

Joined: Tue Jul 27, 2010 3:00 pm
Posts: 2
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 100 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group