Solving complex systems using spreadsheets: A matrix decomposition approach

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

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

Original languageEnglish (US)
Title of host publication2005 ASEE Annual Conference and Exposition, Conference Proceedings
Pages12875-12880
Number of pages6
StatePublished - 2005
Event2005 ASEE Annual Conference and Exposition: The Changing Landscape of Engineering and Technology Education in a Global World - Portland, OR, United States
Duration: Jun 12 2005Jun 15 2005

Other

Other2005 ASEE Annual Conference and Exposition: The Changing Landscape of Engineering and Technology Education in a Global World
CountryUnited States
CityPortland, OR
Period6/12/056/15/05

All Science Journal Classification (ASJC) codes

  • Engineering(all)

Fingerprint Dive into the research topics of 'Solving complex systems using spreadsheets: A matrix decomposition approach'. Together they form a unique fingerprint.

  • Cite this

    Dudeck, K. E. (2005). Solving complex systems using spreadsheets: A matrix decomposition approach. In 2005 ASEE Annual Conference and Exposition, Conference Proceedings (pp. 12875-12880)