PDA

View Full Version : On Call Rotation Schedule with no VBA (Defined Rules)



oplintx
07-02-2018, 01:19 PM
I am trying to figure out how to create a on call calendar rotation that rotates between 8 people. There are several rules that dictate who the on call person is. First, the weekend (Friday, Saturday, Sunday) and weekdays have their own rotation. The weekend (Friday, Saturday, Sunday) on call person will not be scheduled to be on call on a weekday before and after the weekend they are on call. They are skipped if their in the numeric order during those two weeks. If a vacation is planned, that person is skipped over, but fall back in the rotation as soon as they return from vacation. There can be multiple people on vacation at the same time.

Any help would be appreciated.

oplintx
07-03-2018, 12:42 PM
ANYBODY?


I am trying to figure out how to create a on call calendar rotation that rotates between 8 people. There are several rules that dictate who the on call person is. First, the weekend (Friday, Saturday, Sunday) and weekdays have their own rotation. The weekend (Friday, Saturday, Sunday) on call person will not be scheduled to be on call on a weekday before and after the weekend they are on call. They are skipped if their in the numeric order during those two weeks. If a vacation is planned, that person is skipped over, but fall back in the rotation as soon as they return from vacation. There can be multiple people on vacation at the same time.

Any help would be appreciated.