Quote:
Originally Posted by c991257
A few questions:
Does it matter who shifts with who, or do you not care as long as a person only takes a certain number of days off per period?
Is the RDO per month or?
Does the order of the persons on the schedule have any significance?
|
Right now the shifts are set. But we do move people around more often than we like.
We work 48 hours on, then 48 hours off. The RDO is a rotating day off that happens once every 7 shifts. Every 2 weeks, we get a RDO, which gives us an extra day off. Then every 3 months, we will get 2 RDO's that are back to back which gives us either 4 days off, or 6 days off. It's pretty confusing until you get used to it.
I had the order of the roster by rank, highest rank at the top.
What I'm trying to accomplish is make a calendar that shows who is on shift every day, and who is on RDO every day. Any changes to the roster will auto populate to the calendar portion.
I might be overthinking this and making it more complicated than it has to be. I could just tell the Calendar to look at the specific cell next to the RDO number.