Moving Values To Match A Dynamic Gantt Chart

[mdw8189]

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.

File > Settings > Calculation > Iterative calculation > On

Stacked Dynamic.xlsm

Dyn Part,Comp,Qty,Rem,Parts Per Shift,SN,Shifts,Transpose,Start ,End ,Monday,Tuesday,Wednesday,Thursday 1st Shift,2nd Shift,3rd Shift,1st Shift,2nd Shift,3rd Shift,1st Shift,2nd Shift,3rd Shift,1st Shift 1,2,3,4,5,6,7,8,9,10 Job 1,200,200,50,4,4,1,4,X,X,X,X,,,,,, Job 2,100,100,20,5,5,5,10,,,,,X,X,X

docs.google.com

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Moving Values To Match A Dynamic Gantt Chart
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.