Solving power flow problems through the Gauss-Seidel method using Microsoft Excel. Case applied to the course on Generation, Transmission, and Distribution of Electric Power

Abstract

[EN] Analysis of electric power systems is required to predict a grid's behavior before its design. Several commercial simulators give such information, but it is necessary to pay to use it. This work presents a method to solve electric power systems by applying Gauss-Seidel and MS Excel. The modulus and argument of the voltage and the active and reactive power are estimated for every bus. The results conclude that the presented method can analyze electric power systems with low uncertainty.

[ES] Para predecir el comportamiento de una red, previo a su diseño, es necesario llevar a cabo el análisis del sistema. Existe simuladores que dan dicha información, previo pago por su uso. Este trabajo presenta un método para resolver sistemas eléctricos de potencia aplicando Gauss-Seidel utilizando MS Excel. Se estima el módulo y argumento de la tensión así la potencia activa y reactiva de cada bus. Se concluye que el método permite analizar sistemas eléctricos de potencia con un bajo error.