SOLVING COMPLEX SYSTEMS USING SPREADSHEETS: AMATRIX DECOMPOSITION APPROACH

摘要

Many problems in engineering design and analysis, such as sinusoidal driven electricalcircuits, produce a set of complex linear simultaneous equations. This set of equationsform a complex system. Many algorithms have been developed to solve this system byfinding the complex matrix inverse. [1] – [4]This paper describes an approach using a spreadsheet, such as Excel. By using thisapproach, students can use the spreadsheet without the additional cost of purchasingadditional software. Excel does not have complex math or complex matrix functionsoperations, but has real matrix functions. The algorithm is implemented by thedecomposition of the complex matrix into real matrices and programming the spreadsheetusing the built in real matrix functions afforded by the spreadsheet package.