Using Excel VBA Program and Barcode System for Recording of Calibration Data

Abstract

This research was conducted to design and improve the data recording system. Calibration of measuring instruments the aim is to improve the system for recording data of Calibration with Microsoft Excel VBA and barcode system. This is a system that reduces steps, time and increases data to accuracy. From problems encountered before improving the system, it was found that recording data had several steps with a lot of incorrect information causing the needs for improvements. Designing and developing a system for recording data with barcodes, the organizers have applied the theory of Fishbone Diagram principle to analyze the problem to find a solution, Improve the process by reducing waste (ECRS)   Including bringing the Microsoft Excel VBA program and barcode system for recording of calibration data, the process of calibration of measuring instruments was reduced from 8 steps to 6 steps, the time using from 59 minutes to 31 minutes or 52.54% of the time reduction. The verification process of the procedure still had 8 steps, but the time was reduced from 95 minutes to 39 minutes, or 41.05 % of the time reduction. Therefore, it is considered that the test run is effective.