A weekly roster with coverage gaps
Weekly roster: a perfectly balanced sheet until two leave requests arrive.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Make your availability sheet
Use employee codes, approved shift, unavailable dates and off/leave status. Include all staff, even those with no unavailable date.
Confirm coverage rules
Get the working dates, minimum staff per shift and any limits from your manager. The sample uses fixed shifts.
Privacy Use employee codes, not names. Remove contact details and reasons for leave beyond Off or Leave.
Whenever I send availability and approved shift rules, make a weekly roster. Week starts: [Week starts] Working days: [Working days] Shifts: [Approved shifts] Minimum staff per shift: [Minimum per shift] Assignment rule: [Assignment rule] I'm attaching the employee-code availability sheet with approved shifts and unavailable dates. A. Roster by date and shift, with each available employee code assigned according to the rule, off/leave shown separately, no double booking. B. Coverage table: date, shift, assigned count, minimum, shortage = maximum of zero and minimum minus assigned. Flag gaps without assigning unavailable staff. C. Count total scheduled employee-shifts, list gaps and suggest questions for the manager to resolve them. No new shift, leave or overtime rules. Use only my dates and company rules. A manager confirms actual coverage and the final roster. Do not repeat personal identifiers from the data (personal names, phone numbers, email or postal addresses, bank account numbers, UPI IDs, PAN, Aadhaar, GSTIN or other registration numbers) unless the output genuinely needs one; use the code, ref or row instead, and copy any needed identifier exactly. Keep masked values masked; never guess, complete or unmask them.
Set it up once. Save the approved shift rules and roster format. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
After that, each time: send the new week and code-only availability sheet; resolve gaps with the manager.
First time? Try it in a normal chat: paste and send.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep employee availability and roster details in your approved local workbook.
Excel unavailable sheet A:D employee code, approved shift, unavailable date, reason. Create a local roster grid using each employee's assigned shift and the working dates from the approved rule in the task. Give COUNTIFS availability checks and staffing counts per date/shift; flag below minimum and show coverage total. Use dummy codes only and do not change shifts or leave automatically. Use the approved dates, shift minimums and staffing rule from my supplied setup. Tell me where to paste formulas or how to set up the local steps; use fictional examples only, no actual records. Approved inputs: Week starts: [Week starts]; Working days: [Working days]; Approved shifts: [Approved shifts]; Minimum per shift: [Minimum per shift]; Assignment rule: [Assignment rule].
Run locally, verify flagged rows against your source and have the responsible person approve any action.
- 16 NovAM shortage 1. E401 and E402 unavailable; only E403 can work.
- 17 NovPM shortage 1. E404 and E405 unavailable; only E406 can work.
- 20 NovPM covered. E406 off; E404 and E405 meet the minimum.
Then send this: Recount each shift from the roster, verify all unavailable dates were respected and no double bookings, and sum employee-shifts. List any shortage.
It moves people across shifts
Reply: "Fixed shifts only; show the gap."
It ignores leave
Reply: "Remove unavailable staff and recalculate."
It fills every calendar day
Reply: "Use my working days only."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.