Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy All,
I have a problem with my analisys. In our production we work more time in a day the same pieces on a machine.
In my DB the data are collected line by line for every working activity the machine perform.
I need to analyse the single working activity pieces by pieces but I don't know how to do it.
I give you an example
Production Order | Sequence Number | Working Step | Time ON | Header 5 |
---|---|---|---|---|
12345 | 1001 | 1 | 15.00 11/02/2013 | |
12345 | 1002 | 2 | 15.01 11/02/2013 | |
12345 | 1003 | 3 | 15.02 11/02/2013 | |
12345 | 1004 | 4 | 15.03 11/02/2013 | |
12345 | 1005 | 5 | 15.04 11/02/2013 | |
12345 | 1500 | 1 | 18.01 11/02/2013 | |
12345 | 1501 | 2 | 18.02 11/02/2013 | |
12345 | 1502 | 3 | 18.03 11/02/2013 | |
12345 | 1503 | 4 | 18.04 11/02/2013 | |
12345 | 1504 | 5 | 18.05 11/02/2013 |
in this case the same Production Order (12345) go 2 time on the machine, one from 15.00 to 15.04 and one form 18.01 to 18.05.
How can I make the calculation for the ammount of time the PO was under the machine on a single working phase (1to5)?
How can I count the number of time we rework the same PO?
thanks a lot for your help!
How can I count the number of time we rework the same PO?
by counting working steps="5" each PO?
How can I make the calculation for the ammount of time the PO was under the machine on a single working phase (1to5)?
is Your data set order by Time, Working Step, PO?
See attached qvw.
First, you need a field with a unique value for a full working phase (1 to 5) ;
Then, you need an end period ("Time OFF").