Inverse matrix calculation [ Excel VBA / c language / VBA using c DLL ]

Inverse matrix calculation [ Excel VBA / c language / VBA using c DLL ]

I have calculated the inverse of the matrix of size 1780 x 1780. From [A][x]=[B] [x] =[A] ^ (- 1) [B]. You can see the following figure.

Excel Link

 

I tried to calculate through VBA of Excel. In module3 of  VBA(alt-F11) If you run(F5) it in ... it takes 231 seconds to time. It takes too long.

 

 

It need to be faster. Therefor I use c language.  It takes about 20 seconds to calculate in c language. It has been significantly improved.

 

1780.exe  1780.dat

 

Last, the matrix information is obtained from Excel and calculate it in c language DLL. In Excel VBA module1, you declare it to be able to use DLL and execute it.

DLL

 

It takes 26 seconds. It's a good result when combine the efficient side of Excel with c.

댓글

Designed by JB FACTORY