Hey everybody,
I have a question. In my example of data of a production process every batch has to go through 6 operations. For every batch each operation is performed by a different machine, numbered 1 to 10. A zero indicates that batch didn't need to go through that operation.
I need to know how many operations each machine performs. For example: In batch 14, machine 10 performs 3 operations so the total operations is 3 * 39 (batch size) = 117. In the end I need a total of the operations each machine performs over all batches.
Is there a formula or series of steps I can take to make this easier for the way larger document I have to analyse?
Thanks!
Bookmarks