PROMPT BRO
HR desk

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

By hand2–3 hrs
With AI20 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make your availability sheet

Use employee codes, approved shift, unavailable dates and off/leave status. Include all staff, even those with no unavailable date.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
shift-availability.xlsx

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.

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.

What you'll get back (example, from the practice files)
10shift slots
2coverage gaps
24staff shifts
  • 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.
Before you trust it

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.

If it goes wrong
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?