Printed Circuit Board Assembly & PCB Design SMT Electronics Assembly Manufacturing Forum

Printed Circuit Board Assembly & PCB Design Forum

SMT electronics assembly manufacturing forum.


OEE excel template

Views: 2502

#83397

OEE excel template | 6 September, 2019

Hello All, I'm looking for information on OEE data collection for our smt dept. Would anyone have a template excel based or know of somewhere we can purchase a template which would allow the operator to fill in data at shift end. Any info greatly appreciated.

reply »

#83400

OEE excel template | 8 September, 2019

Be careful using charts like this to characterize the performance of a production line. The only part of the line that needs to be optimized is the bottleneck. Stencil printer probably.

reply »

#83403

OEE excel template | 9 September, 2019

Thanks for the input, We work with Panasonic dual line, only bottle neck we have is the oven.

reply »

#83404

OEE excel template | 9 September, 2019

The oven is the only thing that you need to manage, in your case

reply »

#83405

OEE excel template | 9 September, 2019

If oven profile is optimised there's nothing to manage. What I was looking for is a oee template, nothing to do with line optimisation.

reply »

#83408

OEE excel template | 10 September, 2019

If you are not going to do anything with the data, then why collect it? And everyone does it differently.

reply »

#83410

OEE excel template | 10 September, 2019

Sometimes it's just because they want "data art" on the walls.

I was once tasked with developing an SPC program for our SMT lines. It was crudely implemented (plotting points on a chart template) because this was a BIFF (big improvements for free) project. It was moderately effective in keeping the machines running properly and keeping printer programs dialed in.

The reason for it, as I was told later, was that we were planning to outsource and wanted to show the overseas supplier management that WE used SPC and we would be insisting that they do the same. It had nothing to do with using the data to drive improvements.

reply »

#83411

OEE excel template | 10 September, 2019

Steve is on the right track. Wall art

reply »

#83412

OEE excel template | 10 September, 2019

Sorry to hear that, although I'm sure some readers will experience the proverbial "ah-hah" moment upon reading your last comment. Thanks for the transparency. :)

reply »

See Your 2024 IPC Certification Training Schedule for Eptac

Sell Your Used SMT & Test Equipment