Stencil Life Identification

I track all of our production daily in an excel spreadsheet that I use to calculate the OEE. I added another tab and use it to automatically calculate remaining stencil life of each stencil. I replace my stencils after 25K cycles, (prints). Things to take into consideration, I chart my production in single assemblies, so I created a formula to revert these back to panels. Then I use an If/Than statement to trigger a cell flag from "Safe" to "Order Stencil", (changing the color of the cell to RED, when the stencil life falls below 10%).

=IF(Q5>10%,"SAFE","ORDER STENCIL")

I like tracking it this way because it self calculates when I input my production data. I don't have to do anything other than to look at it every day and see if one of the stencil cells have triggered, prompting me to place an order for a replacement stencil.

Also, this falls under the category of "Predictive Maintenance", satisfying our ISO Requirement to have a Predictive Maintenance Program in place.

I'm curious to know what others are doing?

reply »