Asee peer logo

Solving Complex Systems Using Spreadsheets

Download Paper |

Conference

2005 Annual Conference

Location

Portland, Oregon

Publication Date

June 12, 2005

Start Date

June 12, 2005

End Date

June 15, 2005

ISSN

2153-5965

Conference Session

Computing Tools for Engineering Education

Page Count

6

Page Numbers

10.1127.1 - 10.1127.6

Permanent URL

https://peer.asee.org/14679

Download Count

11

Request a correction

Paper Authors

author page

Kenneth Dudeck

Download Paper |

Abstract
NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

SOLVING COMPLEX SYSTEMS USING SPREADSHEETS: A

MATRIX DECOMPOSITION APPROACH

Kenneth E. Dudeck, Associate Professor of Electrical Engineering

Pennsylvania State University, Hazleton Campus

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.

Approach

A system of complex equations can be expressed as:

Zv=k , (1)

where Z is a complex square matrix of size n, v is the complex unknown vector and k is the complex system constant vector. The matrix system has the form below:

 z11 K z1n  v1   k1        M O M  M  =  M   z L z  v   k   n1 nn  n   n

The solution to this system, v, can be found if the inverse of Z, Z-1, is known.

Z-1 Z v = Z-1 k

“Proceedings of the 2005 American Society for Engineering Education Annual Conference & Exposition Copyright © 2005, American Society for Engineering Education”

Dudeck, K. (2005, June), Solving Complex Systems Using Spreadsheets Paper presented at 2005 Annual Conference, Portland, Oregon. https://peer.asee.org/14679

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2005 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015