topic Thanks Zhang, in Intel® oneAPI Math Kernel Library

vslSSEdit* functions

Keith_L_1 — Fri, 04 Oct 2013 01:01:10 GMT

Are the various vslSSEdit* functions (e.g., vslSSEditCovCor) convenience wrappers for calls to vslSSEditTask?

Quote:Keith L. wrote:

Zhang_Z_Intel — Fri, 04 Oct 2013 17:02:32 GMT

Keith L. wrote:

Are the various vslSSEdit* functions (e.g., vslSSEditCovCor) convenience wrappers for calls to vslSSEditTask?

Yes.

Got it. Thanks.I'm sure you

Keith_L_1 — Mon, 07 Oct 2013 23:48:04 GMT

Got it. Thanks.
I'm sure you couldn't care less about Excel, but http://xllmkl.codeplex.com is a (very preliminary) attempt to expose MKL functionality in Excel.

Hi Keith,

Zhang_Z_Intel — Tue, 08 Oct 2013 16:50:46 GMT

Hi Keith,

Thank you very much for telling us about XLLMKL. We do care about Excel! A few years ago, some of my colleagues wrote a Knowledge Base article describing how to add MKL functionality to Excel. It can still be found here: http://software.intel.com/en-us/articles/use-intel-mkl-from-microsoft-office-excel

This article is probably a bit out-of-date now, but hopefully it can be helpful for you.

Zhang

Thanks Zhang,

Keith_L_1 — Tue, 08 Oct 2013 18:35:25 GMT

Thanks Zhang,

Cool! I use (and wrote) http://xll.codeplex.com with xllmkl. The VBA Declare technique is too fragile for production code. It also does not give you access to the Excel FP data type: http://xll.codeplex.com/wikipage?title=FP This is the key to high-performance add-ins for numerical work. You can hand the double pointer to MKL and avoid marshalling data though the VBA COM interface. Calculating the inverse of a 1000x1000 matrix takes 0.2 seconds on my 2.4GHz i5 laptop.

The trickier problem I'm trying to solve is how to integrate the Create/Edit/Compute/Delete cycle for tasks with Excel. Excel is purely functional. The xll::handle<T> class http://xll.codeplex.com/wikipage?title=Handles works for lightweight C++ classes, but is not suitable for the MKL paradigm. The best I can come up with is https://xllmkl.codeplex.com/SourceControl/latest#vslSS.cpp. It might not be pretty, but it seems to work.

-Keith