That's incredible. It works and it's a simple solution without any scripting. You're a real Guru! Thank you soooo much :-)
I have two issues which make it a bit more complex:
1.
We usually have two production cycles every day. In some processes we need to add the compounds twice a day so that it might happen that we run out of stock after the 1st round of the day. Is there a way to cover this aspect?
2.
Is it possible to create a schedule for the support staff. The ideal output would be list like this (columns: Date, Time, Cycle, Message/Note)
Date 0|Time (6am) | Cycle 1
Date 0|Time (2pm) | Cycle 2
Date +1 |Time (6am) | Cycle 1
Date +1 |Time (2pm) | Cycle 2
Date +2 |Time (6am) | Cycle 1
Date +2 |Time (2pm) | Cycle 2
Date +3 |Time (6am) | Cycle 1
Date +3 |Time (2pm) | Cycle 2
Date +4 |Time (6am) | Cycle 1
Date +4 |Time (2pm) | Cycle 2 only five supply for 5 cycles left, please reorder
Date +5 |Time (6am) | Cycle 1
Date +5 |Time (2pm) | Cycle 2
Date +6 |Time (6am) | Cycle 1
Date +6 |Time (2pm) | Cycle 2
Date +X |Time (6am) | Cycle 1 out of stock after this cycle, please refill
(end of this list, process would start again)
Unfortunately, the compounds can only be filled after the machine is out of stock. Therefore, the support staff must receive the message "out of stock after this cycle".
Any idea?
Bookmarks