Automated 3x8 shift team scheduling
DidsCraft
Posted messages
30
Status
Member
-
DidsCraft Posted messages 30 Status Member -
DidsCraft Posted messages 30 Status Member -
Hello,
I'm currently trying to create an automated schedule to the "maximum".
It has advanced well, but now I'm hitting a wall and can't find even a starting solution.
The team rotation in order is M / N / AM (morning, night, etc...)
The wish:
When we select a cell containing M and click the "Rotation" button, the cells for the week take the value "M". For the following week, the value "N", and so on for all the cells for the rest of the year for that column (one sheet per month).
This should not change the cells preceding the date of the selected cell and should work when selecting multiple cells located in different columns, even if they are not next to each other.
I will attach the file to make it easier to understand.
Thank you
https://www.cjoint.com/c/JIufX108v5f
I'm currently trying to create an automated schedule to the "maximum".
It has advanced well, but now I'm hitting a wall and can't find even a starting solution.
The team rotation in order is M / N / AM (morning, night, etc...)
The wish:
When we select a cell containing M and click the "Rotation" button, the cells for the week take the value "M". For the following week, the value "N", and so on for all the cells for the rest of the year for that column (one sheet per month).
This should not change the cells preceding the date of the selected cell and should work when selecting multiple cells located in different columns, even if they are not next to each other.
I will attach the file to make it easier to understand.
Thank you
https://www.cjoint.com/c/JIufX108v5f
1 answer
-
I'm still searching, but I'm still stuck.
Does anyone have any leads?
For now, I've started with a three-column layout containing my three rotation options: M/N/A, N/A/M, and A/M/N
But I still can't figure out how to:
1- Start any day of the week based on the selected cell.
For example: if I select a Friday, only that day (the one) will be in the morning, then night, etc...
2 - Continue the rotations until the end of the month
Once again, if you have any leads, thank you.
