These boards have been great in the past and I am hoping they can help me again. We have an excel sheet we use to create a daily work schedule for a group of employees where we have broken their day into 15 minute increments (each row) so they know what to work on and we know what is realistic to get done in the day.
For this example in cell C2 (6:45am) through C41 (4:30pm) we have the time of day and the in cells D2 through D41 we have the schedule for AL, this repeats in additional columns to the right. During the day various people perform jobs where they place a part on or in various machines and can leave for up to two hours with different parts taking different amounts of time. When making the schedule each day it has become more difficult to keep track of the timing and not "double book" of piece of equipment.
What we would like to have happen is if AL is making part 1 which needs two hours on machine 1 that if he starts it at 8am (cell D7) that it would highlight or some other visual way show that that part would be done at 10am (cell D15). We would want this to work for a wide range of items and be easy to update and add products.
Example of something that would work
Hope this makes sense
Andrew
For this example in cell C2 (6:45am) through C41 (4:30pm) we have the time of day and the in cells D2 through D41 we have the schedule for AL, this repeats in additional columns to the right. During the day various people perform jobs where they place a part on or in various machines and can leave for up to two hours with different parts taking different amounts of time. When making the schedule each day it has become more difficult to keep track of the timing and not "double book" of piece of equipment.
What we would like to have happen is if AL is making part 1 which needs two hours on machine 1 that if he starts it at 8am (cell D7) that it would highlight or some other visual way show that that part would be done at 10am (cell D15). We would want this to work for a wide range of items and be easy to update and add products.
Example of something that would work
Hope this makes sense
Andrew
