Visual Basic<sup>TM</sup> Routine for In-Place Matrix Inversion
- 1 Former V.P.-Development, LEAP Software, Inc., Tampa, FL, USA
- 2 Former Principal Consultant, McDonnell Douglas Automation Co., St. Louis, MO, USA
- 3 Former Assistant Director, Central Water & Power Commission, New Delhi, India
Abstract
A modified version of the Gauss-Jordan algorithm for performing In-Place matrix inversion without using an augmenting unit matrix was described in a previous article by the author. He had also developed several Structural Engineering softwares during his career using that method as their analysis engine. He chose matrix inversion because it was suitable for in-core solution of large numbers of vectors for the same set of equations as encountered in structural analysis of moving, dynamic and seismic loadings. The purpose of this article is to provide its readers with its theoretical background and detailed computations of an In-Place matrix inversion task as well as a Visual Basic routine of the algorithm for direct incorporation into Visual Basic 6 TM softwares and Visual Basic for Applications TM macros in MS-Excel TM spreadsheets to save them time and effort of software development.
- Smith, W.A. (1986) Elementary Numerical Analysis. Prentice-Hall, Inc., Englewood Cliffs, NJ, USA, 51-52.
- DasGupta, D. (2013) In-Place Matrix Inversion by Modified Gauss-Jordan Algorithm. Applied Mathematics, 4, 1392-1396. https://doi.org/10.4236/am.2013.410188
- McFarland, T. (2007) The Inverse of an n × n Matrix. University of Wisconsin-Whitewater. http://math.uww.edu/~mcfarlat/inverse.htm
- Microsoft Press (1998) Microsoft Visual Basic 6.0 Programming Guide©.
- Holzner, S. (1998) Visual Basic 6 Black Book©. Coriolis Technology Press, Scottsdale, AZ, USA.
- Microsoft TM (2017) Language Reference VBA|MSDN. https://msdn.microsoft.com/en-us/vba/vba-language-reference
- Staff Reporter (1987) Roads, Bridges and Computers. Roads & Bridges Magazine, 48.
- Corporate Technology Information Services, Inc. (1990) Corporate Technology Directory. U.S. Edition, Corporate Technology Information Services, Inc., Woburn, MA, USA, 3-873.
- Microsoft TM (2017) Support Statement for Visual Basic 6.0 on Windows. https://docs.microsoft.com/en-us/visualstudio/vb6/vb6-support