PROMPT BRO
Customer service desk

Technician schedule with unassigned tickets

Technician is on another call. The spreadsheet says available.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By hand1 hr
With AI10 min
Per day · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Prepare two small sheets

Use ticket, area, skill, urgency and technician code, area, skill and available slots. Check availability locally.

First time? Try it on fake data first:

Privacy Remove customer phone numbers, addresses, order payment details and personal identifiers. Use ticket or order refs instead.

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

Whenever I send ticket and technician sheets for [Schedule date], apply [Approved assignment rule]. A. Assign each ticket to a matching available technician in ref order within urgency; show slot count, no exact time promised. B. List unassigned tickets and reason; count assignments per technician. C. Questions for dispatcher and short internal schedule note; no booking or customer promise. Use only supplied facts and policy. No admission of legal liability, refund or replacement promise unless the supplied policy permits it and an authorised person confirms. No invented dates, prices or outcomes. A person checks before sending or deciding.

Set it up once. Save the approved rules and output format, not customer details. Pick your tool at the top to see how.

After that, each time: send the next masked notes or export and current rules; check the result.

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)
3assigned
2unassigned
5tickets
  • T2No East electrical slot. No matching available technician.
  • T4West full. Urgent T1 uses A's only slot.
  • T5West mechanical. Assigned C.
Before you trust it

Then send this: Recheck skill, area, urgency and capacity; count assigned and unassigned.

If it goes wrong
Overbooks

Reply: "Respect slot count."

Wrong skill

Reply: "Match both area and skill."

Promises time

Reply: "Slot only, confirm locally."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?