Desenvolvimento de uma ferramenta computacional para avaliar a viabilidade da migração de um consumidor cativo para o ambiente de contratação livre de energia elétrica

Abstract

Given the increase in the number of agents participating of the deregulated energy market and the complexity of this market, studies about it are becoming more and more important. The present work consists of a software programmed in VBA, through Microsoft Excel. The tool performs economic feasibility studies of the migration of a regulated consumer served by Copel to the deregulated market, by simulating the expenses of this consumer in both energy markets. Considering the seasonality of the energy consumption of the unit to be analyzed, the software named AClere takes as input historical data from the consumer and data from the deregulated contract, calculating a consumption forecast for the duration of the contract in the deregulated market, resulting in the cost difference month by month of the two markets, as well as the total cost difference in the analyzed period. It is possible to consider error margins, annually variable energy prices, tariffs of different voltage subgroups, as well as importing the consumption history present in the invoices of consumers served in medium and high voltage by Copel. Indicators such as NPV, payback, total savings, and average savings are calculated. After the analysis, the user can navigate between tables with detailed costs, as well as save a report in a text file. Another feature of AClere is the visualization of a graph illustrating the costs in ACL and ACR, which can be saved as an image file.