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

Printed Circuit Board Assembly & PCB Design Forum

SMT electronics assembly manufacturing forum.


EMS PCBA - SMT Excel Calculator

Views: 794

#81112

EMS PCBA - SMT Excel Calculator | 27 September, 2018

Hello everyone,

I've been working on a project to create Cycle Time Calculator. To be simple, easy to use, and fast. We are EMS, we do a lot of calculations and offers, it takes time. I want to design calculator which will work without adding example: Component Complex Class etc. Atm its working as:

You enter Throughput of machines (line) Panels size, placements, batch size

and it calculates: Pieces/hour Tact/Piece sec/PCB sec/Panel Batch Cycle Time in hours (shifts)

It is a bit inacurate, not so reliable. Do you have any suggestions, maybe a template for calculator excel, access, application or anything that can help?

Best regards

reply »

#81114

EMS PCBA - SMT Excel Calculator | 27 September, 2018

I'd suggest you speak with ITM Consulting. They have advised PCBA operations for many years. It is likely they offer or can direct you to a proven solution. phil_zarrow@ITMconsulting.org I have no business association with Phil; but, have worked with him and have known him for 30 years.

reply »

SMT in-printer dispensing