Diseño y automatización de una herramienta informática en línea, para el cálculo de indicadores clave de mantenimiento en el sector industrial ecuatoriano

Abstract

The objective of this project was creating an online computer tool for the calculation of Maintenance Key Performance Indicators (KPI). Among the indicators that can be calculated with this tool are: Maintenance Costs, Mean Time to Repair, Mean Time Between Failures, and Equipment Availability. The online computing tool is a website, accessible from any device that has an active internet connection. The website was created through the content management system "WordPress"; also, a unique URL address was generated for the website, the address was "calculadorakpis.com". To make the pages for the calculation of key indicators, it was necessary to create Excel Spreadsheets and HTML for each of these sheets, in order to display and use the spreadsheets in the computer tool. Each page created contains relevant information about: the previously mentioned Maintenance Key Performance Indicators, video tutorials about how to use the website, interactive spreadsheets that, at the moment a user enters data, the spreadsheets automatically obtain the values and graphs of the indicators. In addition, a tool for censoring outliers was included, which can be a problem when calculating KPI. The online computer tool created was designed to be used for consultation and learning purposes; for both students and technicians from the Ecuadorian industrial sector that requires a brief introduction to the calculations of these indicators. It is recommended to increase the number of online computer tools to share knowledge on industrial maintenance.