forum.alglib.net
http://forum.alglib.net/

Compiled matrix functions for Excel
http://forum.alglib.net/viewtopic.php?f=2&t=12
Page 1 of 1

Author:  Doug Jenkins [ Thu May 27, 2010 11:21 pm ]
Post subject:  Compiled matrix functions for Excel

Following a discussion in the EngTips Forum :
http://eng-tips.com/viewthread.cfm?qid= ... amp;page=1
I have compiled the C++ versions of a number of matrix functions from the AlgLib library as a dll, and linked them to Excel. The spreadsheet and associated code can be downloaded from:
http://newtonexcelbach.wordpress.com/20 ... for-excel/

The functions included are:
Inverse of real matrix
Inverse of complex matrix
Determinant of real matrix
Determinant of complex matrix
Transpose of real matrix
Transpose of complex matrix
Matrix multiplication; real
Matrix multiplication; complex
Add matrices
Extract matrix
Insert Matrix
Eigen value and Eigen vectors
Solve system of linear equations

I'd really like to get some feedback on this. Do the functions work correctly? Is the documentation adequate? What other functions would be desirable? Any problems installing the dll and linking to the spreadsheet? etc.

Author:  Sergey.Bochkanov [ Fri May 28, 2010 7:27 pm ]
Post subject:  Re: Compiled matrix functions for Excel

Good work! I want to implement something like that several month later, but in my usual fashion - using automatic code generation :) All ALGLIB functions will be implemented as calls to C DLL.

As for you project, I think that some convenient interface for reading matrices from text files (and for saving matrices to files) could be very useful.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/