Hey guys!
In my table you see the two columns time and delta_time.
"time" indicates timestamps of an driverless transport system (DTS) while entering a certain workstation. "delta_time" indicates the time the DTS needed at the previous workstation.
In case of an problem the DTS will stop longer at a particual workstation and potentially causes a jam in the assembly line. To analyse which DTS was originally responsible for the jam I check
where the delta_time is higher then 00:01:30 (planned cycle time) and set this as local maximum.
You see in the table that the DTS stoped at workstation 02 for 00:02:48. After that delta_time decreases. That means that workstation 02 is the responsible for the jam.
The same you find at workstation 07.
Now I need an automated mechanism for painting green the the jam responsible workstations. I hope you got what I mean :D
Can you please help me?
In my table you see the two columns time and delta_time.
"time" indicates timestamps of an driverless transport system (DTS) while entering a certain workstation. "delta_time" indicates the time the DTS needed at the previous workstation.
In case of an problem the DTS will stop longer at a particual workstation and potentially causes a jam in the assembly line. To analyse which DTS was originally responsible for the jam I check
where the delta_time is higher then 00:01:30 (planned cycle time) and set this as local maximum.
You see in the table that the DTS stoped at workstation 02 for 00:02:48. After that delta_time decreases. That means that workstation 02 is the responsible for the jam.
The same you find at workstation 07.
Now I need an automated mechanism for painting green the the jam responsible workstations. I hope you got what I mean :D
Can you please help me?
ordernumber | date | time | delta_time | workstation |
ZSC2 | 16.08.2021 | 07:03:00 | 00:00:00 | 01 |
ZSC2 | 16.08.2021 | 07:05:48 | 00:02:48 | 02 |
ZSC2 | 16.08.2021 | 07:07:29 | 00:01:41 | 03 |
ZSC2 | 16.08.2021 | 07:09:07 | 00:01:38 | 04 |
ZSC2 | 16.08.2021 | 07:10:34 | 00:01:27 | 04 |
ZSC2 | 16.08.2021 | 07:11:59 | 00:01:25 | 06 |
ZSC2 | 16.08.2021 | 07:14:38 | 00:02:39 | 07 |
ZSC2 | 16.08.2021 | 07:16:46 | 00:02:08 | 08 |
ZSC2 | 16.08.2021 | 07:18:14 | 00:01:28 | 09 |
ZSC2 | 16.08.2021 | 07:19:46 | 00:01:32 | 10 |