Automation of product yield monitoring and production traceability

Abstract

The goal of this thesis was to create a template for an automated yield monitoring system with Microsoft Excel. Microsoft Excel was chosen for this because it is already in use in the case company and it is capable of doing this. The thesis began with reading through theoretical material followed by designing the layout for the Excel, writing functional formulas and macros to minimize manual input from the operators and linking workbooks to one another.

The production in the case company was prototype based so it is followed very closely, since prototypes usually have flaws, mismatching parts, and are not as reliable as a finished product would be. Yield monitoring was used to follow this. All passes, fails and the reason for the fails are marked so the possible questions can be worked on.