Modeling of Resonant Circuits in Excel

Abstract

The paper deals with the possibility of modeling passive linear electrical circuits powered by harmonic sources using Excel. The ability to work with complex numbers allows to use Excel as a calculator with graphical output, which immediately after changing the size of the parameter recalculates and graphically displays the change. This option is welcome for resonant circuits where manual calculation of the resonant frequency would take a long time. In addition, if a circuit has multiple resonant frequencies, the proposed calculation procedure will provide an immediate response for a particular circuit. The use of Excel is also attractive because, compared to other software, Office 365 and, therefore, the Excel version for students and university staff under the license for schools is free.