Diseño e implementación de una solución para recolección de datos y generación de reportes web de los sistemas de CO2 y refrigeración para el área de manufactura de Cervecería Nacional C.N. planta Quito

Abstract

Nowadays, the industry generates a group of data which delivers a lot of information to do preventive and corrective maintenance for the machinery. The data should be completed and it has to be shown in a user interface. This project implements a solution that collects data from PLC using an InSQL server. The data is gotten through an intermediate database in an SQL server, using stored procedures. The solution has a web application where the user authenticates and can generate reports receiving as input a date range, a report type and a set of variables if a combined report is needed. The graphics need similar input parameters and deploy a graphic using a set of data according to the selected parameters and variables. With this project, operators will have an automatized system to collect data and get accurate reports. Other benefits include time and resources optimization, and information that helps operators in maintenance tasks.