Desenvolvimento de uma ferramenta computacional utilizando Visual Basic for Applications (VBA) para consultoria no projeto de geradores fotovoltaicos residenciais

Abstract

The present document presents as stages of development of an automated survey for the consulting on projects of generation of photovoltaic energy, residential or connected to the electric grid. The tool was developed using Visual Basic for Applications (VBA) features, applied over the Excel Microssof software. In order to do so, it was necessary to design resources of photovoltaic systems such as: the precision of the solar demand, the definition of the local energy generator, the incidence of solar energy in the place, the analysis of azimuthal deviation, the configuration of the generator and the determination of the inverter and batteries for more installation. In addition, there is a license implementation for running VBA and Macros for Excel and for executing component selection processes to integrate the photovoltaic system. Aim the main feature of chance to change the time as the generation system wizard, making it a tool with greater decision-making power to implement according to the chosen data. In addition, it is useful, when developed, in force in Normative Resolution No. 687 of November 24, 2015, of the National Electric Energy Agency (ANEEL), which in its records defines distributed micro and mini-generation, and also the system of Brazilian energy compensation. Therefore, no document is present in the description of the work, as well as a bibliographic review on photovoltaics systems. At the end, the commented algorithm is presented to the reader.