Im creating a Rostering model in which I need to do the following:
1. In a module contain all employee information i.e.. start dates, shift pattern category, etc
2. Module containg a shift pattern profile i.e. for shift pattern A = 2 days on 2 days off, Shift Pattern b = 5 days on 2 days off
3. Module with timescale(day) for a given employee flag celss across a continuous timescale with a line item formatted with a Boolean tick box to tick the patterns for an employee based on the Shift Pattern Module.
Maybe a combination of Post or lag formulaes. Any Ideas for a solution.
Thanks