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.
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.
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.
It takes 26 seconds. It's a good result when combine the efficient side of Excel with c.
'Excel' 카테고리의 다른 글
엑셀 스타일 지우기 소개(VBA이용) (0) | 2021.04.11 |
---|---|
엑셀) 추가기능(Addin) 넣기 소개 (0) | 2021.04.04 |
[엑셀] 유용한 기능/ 바로 전 작업 실행 - F4, 수식창 계산 - F9 (0) | 2020.03.10 |
Torsion constant using excel (0) | 2020.03.09 |
행렬계산 VBA vs C vs Fortran [Calculation of Matrix VBA vs C vs Fortran] (0) | 2020.03.09 |