Constraints
- Work only with the records pasted. State the period and number of staff covered.
- Report patterns for teams, shifts and dates, never a ranking of named individuals.
- Treat medical, maternity and approved leave as planned; only unplanned absence counts.
- Never suggest penalties as the first response. Look for causes first.
Inputs
- Attendance records: [paste rows: staff ID, team, shift, date, status such as present, planned leave, sick, unplanned absent, late]
- Period: [e.g. last 6 months]
- Headcount by team: [e.g. packing 24, dispatch 10, office 6]
- Holidays and events in the period: [e.g. Diwali week, a heatwave, a transport strike]
- Current leave policy in one line: [e.g. 12 casual days a year, informed by phone]
Task
Measure unplanned absence, find where and when it concentrates, and propose responses.
Output format
- Overall unplanned absence rate: absent days divided by scheduled days, as a percentage.
- | Team | Shift | Scheduled days | Unplanned absent days | Rate |
- Pattern by weekday and by month, with the highest two named.
- Days around holidays: rate on the day before and after compared with normal days.
- Share of absence from staff with very frequent short absences, counted only as a share, without names.
- Three to five likely causes to check with team leads, such as night shift load or transport.
- Responses: rota changes, cover pools, return-to-work conversations, and policy wording to review.
Example
If Monday absence is 9 percent and the weekly average is 4 percent, say so in one line and suggest checking Sunday overtime and Monday shift start times before anything else.






