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 1 is in progress from 10/5/2018 through 10/10/2018, and job 2 is in progress 10/7/208 through 10/11/2018? I have been struggling to create a VBA code or macro to show what my mind says is possible below.
My start date is in column J and finish date is in column K.
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 10/12/2018...
0 0 1 1 1 1 1 1 0....
0 0 0 0 1 1 1 1 1 0....
How do I go about doing this?
Note, the 0s and 1s correspond to the dates respectively.
Bookmarks