I’ve made a dynamic Gantt Chart that adjusts based on the efficiency a machine runs during each shift.
For example, Job 1 is scheduled to run at 100% and is expected to be completed in 4 shifts. Job 2 is expected to begin on Tuesday 2nd shift but requires a new setup and will only run at 25% on the setup shift. But say on Monday 3rd shift, there were issues resulting in Job 1 only running at 50%. By changing this shift to 50%, an additional shift will be plotted moving Job 2’s setup shift to Tuesday 3rd shift.
What I’d like is for the 25% to move in accordance with Job 2’s new start date (Tuesday 3rd shift). So Tuesday 2nd shift would revert back to 100% and Tuesday 3rd shift would change to 25%. Any ideas of how I might be able to accomplish this?
Iterative calculations need to be turned on in order for the chart to work.
Bookmarks