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 language | English (US) |
---|---|
Title of host publication | 2005 ASEE Annual Conference and Exposition, Conference Proceedings |
Pages | 12875-12880 |
Number of pages | 6 |
State | Published - 2005 |
Event | 2005 ASEE Annual Conference and Exposition: The Changing Landscape of Engineering and Technology Education in a Global World - Portland, OR, United States Duration: Jun 12 2005 → Jun 15 2005 |
Other
Other | 2005 ASEE Annual Conference and Exposition: The Changing Landscape of Engineering and Technology Education in a Global World |
---|---|
Country/Territory | United States |
City | Portland, OR |
Period | 6/12/05 → 6/15/05 |
All Science Journal Classification (ASJC) codes
- General Engineering