AUTOMATIC CALCULATION OF THE PARAMETERS OF LINEAR ELECTRICAL CIRCUITS VIA AC ANALYSIS BY THE USE OF EXCEL

Simona Petrakieva; Borislav Boychev

Scientific paper ID 1402 : 2016/3

AUTOMATIC CALCULATION OF THE PARAMETERS OF LINEAR ELECTRICAL CIRCUITS VIA AC ANALYSIS BY THE USE OF EXCEL

Simona Petrakieva, Borislav Boychev

Each periodical signal with period 2 can be presented by Fourier transformation. Then the analysis of the behaviour of linear electric circuits relegates to solving one DC problem and a set of AC problems with sinusoidal sources. In the present paper it suggests automatic calculation of the complex resistances Z in electrical circuits and determining the branch current by Thevenin’s theorem, based on the experimental measured currents, voltages and active powers. It uses symbolic method for analysis, using mathematical basic of complex numbers. Calculations are made by the use of Excel, because in this way it visualizes in table form as well the results from measurements as the current calculated complex quantities. Thus, based on the results for the complex resistances Z in the considered electrical circuit it makes conclusions about the type of real elements (resistors, coils and capacitors), d there.

The measurements are made on the lab “AC analysis of linear electric circuits”, carrying out in the course “Theory of Electrical Engineering” in the homonymous department in Technical University of Sofia.

The paper is prepared with educational purpose to help the students in preparering and defending their laboratory assignments.

• Reload article • Open/Download as PDF

синусоидални режими линейни електрически вериги изчисления с Excel теорема на ТевененAC analysis linear electric circuits ExcelSimona Petrakieva Borislav Boychev

BIBLIOGRAPHY

[1] An introduction to Fourier analysis http://www.facstaff.bucknell.edu/mastascu/e...

[2] K. Brandiski i kolektiv, Rakovodstvo za laboratorni uprazhneniya po Teoretichna elektrotehnika, izd. KING 2010, ISBN 954-9518-24-8, 144 str.
( [2] К. Брандиски и колектив, Ръководство за лабораторни упражнения по Теоретична електротехника, изд. КИНГ 2010, ISBN 954-9518-24-8, 144 стр. )

[3] Hayt, W., Jr. And J. Kemmerly, Engineering Circuit Analysis, 5th Edition, McGRAW-Hill, Inc., 1993, ISBN 0-07-112736-4, 706 pp.

[4] G. Cherneva, Uchebnik po Teoretichna Elektrotehnika, ch. I, VTU Sofiya, 2010, ISBN 978-954-12-0195-4, 313 str.
( [4] Г. Чернева, Учебник по Теоретична Електротехника, ч. I, ВТУ София, 2010, ISBN 978-954-12-0195-4, 313 стр. )

[5] Microsoft Excel – Help