Hello all,
I am working on capacity planning and I can only use the current tools that we have at my business. I am struggling to find a way to show the load of a certain area within the plant. For example, showing that the job is scheduled for 10/5/2018 and scheduled to finish on 10/10/2018 (I have historical data through future data). My question is how do I display that the job is in progress from 10/5/2018 through 10/10/2018? I have been struggling to find a formula to show what my mind says is possible below.
1 being job is in scheduled time, 0 not in scheduled time.
10/3/2018 10/4/2018 10/5/2018 10/6/2018 10/7/2018 10/8/2018 10/9/2018 10/10/2018 10/11/2018...
0 0 1 1 1 1 1 1 0....
How do I go about doing this?
Note, the 0s and 1s correspond to the dates respectively.
Bookmarks