Hello everyone! I found this forum while looking for tips on Excel and I saw this one so I said to myself: "why not?".
So here is the issue: I have to fill an entire chart with every day on this year with different working shifts. Also I have to give them holidays and stuff. I used formulas to randomize it all, but it has one problem: I canīt have a "Morning" shift if the previous day I had an "Afternoon" shift. I'll try my best to explain this: I have four workers (let's call them Worker1 and stuff, for the sake of simplicity) and all of them must work 1748 hours or less during the year. This is, of course, couting holidays (they must have at least 1 free weekend a month and 30 days of holidays, splitted in a period of 15 days each). Again, I have no problem with the holidays, the main issue is that I must have two workers that have a "Morning" shift, one worker with an "Afternoon" shift and the remaining worker has a free day. But, as I said earlier, if a worker had an "Afternoon" shift the previous day, they can't have a "Morning" one the next day, in which case they must have either a free day (labeled as "F" in the chart) or work another "Afternoon" shift. You must be getting the point, and that point is that I can't randomize the chart and have everything perfect because it'll keep putting "Mornings" after "Afternoons"... So I had to ask, is there any way that I can randomize the chart with that specification in mind? I'm not asking to do my job, I just want to know if there's a simpler way for this because I honestly don't have the time and will to go through everyday in the year putting shifts randomly, it'd take a very long time to complete everything.
Thanks beforehand, hope you guys can help me out!
PD: If this is not the place to ask this kind of things, please move this post :DD
Bookmarks