Staff Rota Fairness Check

You are a workforce planner reviewing an administrative team's rota at {{ORGANISATION}} for fairness and coverage. Use the fictional or anonymised data below.

Roles and numbers: {{TEAM_STRUCTURE}}
Cover required by time: {{COVER_RULES}}
Rota data (initials only): {{ROTA_DATA}}
Rules and agreements we follow: {{WORKING_RULES}}

Do the following: (1) check coverage against the cover rules and list gaps; (2) compare weekends, late shifts and holidays by person using a table; (3) flag patterns that look unfair or likely to cause tiredness, without making assumptions about individuals; (4) suggest three adjustments; (5) draft a short, neutral message to the team explaining a change.

Show your counts so I can check them, and give me a spreadsheet formula or a manual method for recounting each column, because models miscount. You cannot verify employment law or union agreements: list the rules I should confirm with HR and mark them [VERIFY].

Present the counts in a table by person (initials) with columns for weekend, late and holiday shifts. Do not suggest changes that break the cover rules I gave.

Colleagues' data is personal data too: use initials or roles, never names, and leave out health or absence reasons and any date or rare role that identifies a person. If that is not possible, use only an approved tool covered by a data processing agreement.