Rotation formula challange - Help
Hi all. I am new to this forum, so I appologise if I have posted this question in the wrong place (if so please direct me to a more suitable site).
My colleagues and I have been trying to figure out a years rota for next year the problem we have is as follows:
3 people work a 3 shift cycle (days, lates, nights). 2 people work 2 shifts (days & lates)
There are 4 work stations.
Station 1 only runs on day shift (the extra person on late shift provides support so is still allocated to this station)
Station 2 doesnt run on night shift.
Is there a formula that would mean no one works the same station 2 weeks running for the next 48 weeks, and that everyone has an even spread of each station on each shift over the year?
Many thanks in advance for any help provided.