### 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 | United States |

City | Portland, OR |

Period | 6/12/05 → 6/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

*2005 ASEE Annual Conference and Exposition, Conference Proceedings*(pp. 12875-12880)