Desarrollo de un aplicativo para el establecimiento de costos en redes eléctricas soterradas para procesos de diseño y fiscalización de obra en sistemas de distribución

Abstract

This document focuses on creating an application to calculate costs in underground electrical networks, with the objective of simplifying the design and supervision of electrical distribution projects. Although there are computational tools to assist in electrical design, there are not many available for underground electrical networks, especially in free software. Currently, there are modules suitable for this purpose, but they usually require the purchase of additional licenses. The current application is built in Microsoft Excel using VBA (Visual Basic for Applications), with modules and macros designed to simplify cost estimation in underground electrical networks. Its goal is to improve efficiency, precision and error reduction. In addition, it offers an interface that allows you to search for items of property units approved by the Ministry of Electricity and Renewable Energy, using unit identifiers and brief descriptions of materials or equipment. The interface allows you to edit costs in the equipment and materials database, create items of these to estimate budgets, and has a sheet to enter structure spreadsheets that automatically finds codes from total or partial descriptions of them.