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
Prepare two small sheets
Use ticket, area, skill, urgency and technician code, area, skill and available slots. Check availability locally.
Privacy Remove customer phone numbers, addresses, order payment details and personal identifiers. Use ticket or order refs instead.
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.
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 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.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Tickets A:D ticket, area, skill, urgency; technicians A:D code, area, skill, slots. Rule [Approved assignment rule]. Give local sort/filter and step-by-step assignment worksheet with COUNTIFS area/skill match, remaining slots and urgent-first order; flag unassigned, prevent overbooking. Explain how to check manually instead of pretending a lookup can allocate capacity. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual customer, employee or vendor records.
Run the method locally; verify every exception against source records and obtain approval before acting.
- T2No East electrical slot. No matching available technician.
- T4West full. Urgent T1 uses A's only slot.
- T5West mechanical. Assigned C.
Then send this: Recheck skill, area, urgency and capacity; count assigned and unassigned.
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?
If your whole team does this, we'll set it up for all of them in one session.