Automatización del proceso del análisis causa raíz y la metodología del análisis de modos de falla y efecto mediante la utilización de Excel para la Carrera de Mantenimiento Industrial

Abstract

The aim of this technical project was creating computer tools to automating the maintenance methodologies of the root cause analysis and the Failure Mode and Effects Analysis (FMEA). For this, it was necessary to develop a study of the art’s state based on maintenance regulations and bibliographies. The methodologies were defined to be applied, the spreadsheets were created, and their operation checked. Among the methodologies to be automated are found Pareto analysis, the Ishikawa diagram, the 5-why methodology, and the analysis of failure modes and effects. The purpose is shorting the calculation time between these methodologies in order to perform the analysis in a quickly way. To carry out these tools, Microsoft Office Excel was used, making the registration and visualization of data interactive with the user, who use the spreadsheets. Dynamic tables, instructions created through Macros and data comparison charts were used. In addition, these computer tools are intended to be used in the academic and professional analysis, because root cause analysis has a vital importance for making a decision in the industry. In conclusion, a computer tool was created, and this is able to automate the recording process of root cause, failure modes and effects analysis. For obtaining these results specific data must be registered for each spreadsheet and this will show a result based on the criteria detailed by the user. It is recommended the implementation of computer tools for the Industrial Maintenance students’ academic training.