I need some tips. Instead of explaining what I’ve done I will give details on what I need to do…
At the factory we have an assembly line for one specific customer, this customer has a variety of products, I would say probably 60 or so.
What we wish to accomplish is to be able to have some statistics on each one of the products, the total count for the entire assembly line for the day, have the time stamp for when the employee logs on the work station, the total count done by each employees.
The products being assembled vary from one day to the other and will often change during the day. The employees on the work station can change. I need to have something very user friendly for the factory manager.
I want to have a data base where the names of the employees can be stored, another on where the product name and codes can be stored. This will make it simple to to store the information in the PLC.
Once a product is finalized and sent to be inspected the employee presses a RESET button then there will be a group of information sent to the data base of that particular station (product id, time it took to complete, the total count at the moment, etc).
I leave it there an wait for your suggestions.