Development of a Tool for Sizing and Technical–Financial Analysis of Energy‐Storage Systems Using Batteries

Abstract

In this article, an innovative approach is presented to the sizing and technical–economic analysis of battery energy‐storage systems (BESS) designed for customers in the free energy market in Brazil. The tool enables the integration of photovoltaic (PV) energy sources and includes a comparison between the BESS + PV system and diesel generators. Integrating the computational capabilities of Microsoft Excel in the backend and the intuitive interface of PowerApps in the front end, the sizing process is based on analyzing historical energy invoices spanning at least 12 months or loading data with a 1 h measurement interval. The data discretization over the 8760 h of the year, considering the consumer's load profile, is facilitated by the PowerApps interface, providing a comprehensive visualization of the technical‐economic sizing results for BESS. A case study is conducted for a commercial load with a specific tariff for free energy market customers, revealing viable solutions for BESS compared to diesel alternatives. In this approach, it is aimed to simplify the analysis and decision‐making process, offering a valuable tool for power system engineers to evaluate sustainable and economically viable solutions in the Brazilian free energy market.