There is a need to look for alternative sources of renewable energy, especially in zones where people continue to live under energy poverty conditions. Consequently, to enhance the performance of energy systems, algorithms to support planning decisions are required. This article proposes a simulation-optimization framework to solve the stochastic version of the integrated energy dispatch and unit commitment problem for a solar radiation system operating in non-interconnected zones. Our study was motivated by challenges faced by a rural school located in Cundinamarca, Colombia. Particularly, a simulation with optimization-based iterations approach is used, modeling solar radiation as a random variable. The optimization phase uses a heuristic procedure that enables good solutions to be found in short computational times. To test our method, computational experiments were conducted using a set of randomly generated cases. The results suggest that our approach is useful and able to handle the random nature of the process for the school “Volcanes”. Additionally, we were able to quantify the impact that using a deterministic approach has on service levels for such systems. The novelty of the article lies in the proposed method and its application to a rural school with a low-budget system.

The aim of this work is to identify and quantify physical and environmental explanatory variables for the structural state of urban drainage networks in a pilot study located in Bogota, Colombia. The analysis used information from 2291 CCTV inspections collected by the Water and Sewerage Company of Bogota (EAAB, from its Spanish initials) using tele-operated equipment during 2008-2010. Linear regression models were established to identify the environmental and physical characteristics of the pipes that are significantly associated with the occurrence, magnitude and type of the failures commonly found. Despite the fact that the correlation levels show that the developed model has a very low predictive capacity, it was found that the process of selecting assets for CCTV inspection can be optimized, increasing the success rate in failure detection.

INTRODUCCIÓN. El análisis de criticidad mediante una matriz de criterios permite establecer la jerarquía de equipos de una planta, mientras que, el cálculo del indicador de disponibilidad muestra el porcentaje de tiempo durante el cual un equipo se encuentra apto para su uso y operativo. OBJETIVO. Desarrollar una herramienta en Excel utilizando criterios de disponibilidad y criticidad de los equipos para la asignación de modelos de mantenimiento. MÉTODO. Esta investigación es de carácter mixto, cualitativa y cuantitativa, utilizando como herramienta el software “Microsoft Excel”, que se configura mediante funciones matemáticas y lógicas para determinar el modelo de mantenimiento. RESULTADOS. Como resultado y aplicación de esta investigación se obtuvo una disponibilidad del 95.51% en el equipo, considerando cada variable para su cálculo. DISCUSIÓN Y CONCLUSIONES. Con este proyecto se demuestra que es posible gestionar el mantenimiento utilizando herramientas de bajo costo como Excel. La herramienta desarrollada en esta investigación significa un aporte sustancial en el proceso de mejora continua y gestión integral del mantenimiento.