Forum Discussion
Roster Conflict
OK just looked further into your amendments. Restrictions on the data validation go to far. For example if I needed to give Staff H a 2nd or 3rd shift they would not appear in the drop down box.Also I J and K as casuals may not be available for shifts this week... Mind you if it displayed potentially available staff, shift by shift, in the drop down box it would be incredibly powerful. I am daily asked to find ways to cover shifts due to staff illness / unavailability or pop up shifts from unexpected appointments with participants... And yes it would be excellent if the highlighting occurred on both examples of the conflict. Thank you so much your formulae will actually have a real positive impact on lives in our society...
Can I ask for an explanation of the logic behind the (widely) differing hours given to what are labeled as the same shifts? That internal inconsistency certainly complicates what you're trying to do.
For example, Staff Member A has Shift 1 as going from 6:00 to 12:00 (and none of the others have Shift 1 as showing hours like that, although they too vary all over the place) ... so it would appear that Shift 1 itself has no set meaning.
And then looking at Staff Member A in Shift 2, which in that case--here's your conflict--overlaps A's shift 1 but not necessarily that of others.....
Can you help make sense of that layout, first? Then maybe we can come up with a formula or function to highlight the clashes.
Yep I can explain. I work as an NDIS provider. We supply support for people with disability. Every participants plan is individualized according to their particular needs so the rostering is complex. We currently have 50 participants and 35 staff and due to potential unforeseen issues on a weekly basis the roster week to week is a living document. There are commonly unexpected appointments with doctors, specialists, therapists or dealing with behavioral issues relating to self harm.
So in dealing with these issues with a pool of casual Disability Support workers it would be great when an issue arises (which is every week) we can rearrange the roster and automate identifying potential roster conflicts. Hopefully this illuminates the issue. 🙂 Thank you for looking at this 🙂