{"id":1195,"date":"2022-04-04T14:41:41","date_gmt":"2022-04-04T05:41:41","guid":{"rendered":"http:\/\/targa.iptime.org\/?p=1195"},"modified":"2024-04-25T07:42:20","modified_gmt":"2024-04-24T22:42:20","slug":"system-of-linear-equations-solver-library","status":"publish","type":"post","link":"http:\/\/targa.iptime.org\/?p=1195","title":{"rendered":"Solving System of Linear Equations in Microsoft EXCEL with Various Open Source Libraries"},"content":{"rendered":"\n

General purpose open source numerical analysis libraries for solving system of linear equations are used to interface with more specified numerical analysis procedures such as Finite Element Analysis.
\nThey are built as dynamic link libraries and iterfaced with VBA, so that they can be easily used as EXCEL’s worksheet functions.<\/p>\n

Open Source Libraries Used and their dlls<\/strong><\/p>\n

    \n
  1. EIGEN<\/a>
    \neigen.dll<\/li>\n
  2. ALGLIB<\/a>
    \nalglib.dll<\/li>\n
  3. LAPACK<\/a> with OpenBLAS<\/a>
    \nlapack_and_openblas.dll<\/li>\n
  4. Reference algorithm implementations
    \ntarga.dll
    \ntriangular_solver.dll<\/li>\n
  5. Additional libraries related to MSYS2<\/a>
    \nlibwinpthread-1.dll
    \nlibgcc_s_seh-1.dll
    \nlibgfortran-5.dll
    \nlibquadmath-0.dll
    \nlapack and openblas dlls are built under MSYS2 and depend on these additional libraries<\/li>\n<\/ol>\n

    Installation<\/strong><\/p>\n

      \n
    1. Copy library files to your specific folder (e.g. C:\\NumericalAnalysisLibrary).<\/li>\n
    2. Add that folder to PATH environment variable of Windows.<\/li>\n<\/ol>\n

      Testing in Microsoft EXCEL<\/strong><\/p>\n

        \n
      1. Open NumericalAnalysisLibrary.xlam
        \nOptionally, if this file is registered as an EXCEL ADD-IN, it is not necessary to open this file every time you use this library.<\/li>\n
      2. Open test_NumericalAnalysisLibrary.xlsm<\/li>\n
      3. In test_NumericalAnalysisLibrary.xlsm, input equation (variable) numbers in D4 cell and right hand side vector numbers in D5 cell and select solver to test in D6 cell.\nAvailable solvers are listed in range M5:M39<\/li>\n<\/ol>\n<\/div>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n

        Sample Test Result<\/strong><\/p>\n

        If equations and rhs columns are set to 5 and 3 and EIGEN’s PartialPivLU_decompose is selected as an solver, then the intermediate process and results will be output as follows. At the end of the result worksheet, residual value of solution is also output as an verification of the solver.\nYou can also refer to named ranges defined in output worksheet.<\/p>\n<\/div>\n\n\n\n

        \"\"<\/figure>\n\n\n\n
        <\/div>\n\n\n\n

        Download<\/strong><\/p>\n<\/div>\n\n\n\n

        NumericalAnalysisLibrary<\/a>Download<\/a><\/div>\n\n\n\n
        <\/div>\n\n\n\n

        Support or Contact<\/strong><\/p>\n

        Having any question using this library, please leave a reply to this post or contact me by jangwj7@gmail.com<\/a>.<\/p>\n<\/div>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,5,7,10],"tags":[13,15,17,20],"class_list":["post-1195","post","type-post","status-publish","format-standard","hentry","category-c","category-excel","category-numerical-analysis","category-vba","tag-c","tag-excel","tag-numerical-analysis","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/posts\/1195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1195"}],"version-history":[{"count":112,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/posts\/1195\/revisions"}],"predecessor-version":[{"id":1464,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=\/wp\/v2\/posts\/1195\/revisions\/1464"}],"wp:attachment":[{"href":"http:\/\/targa.iptime.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1195"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/targa.iptime.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}