Dispatch plan and transporter follow-ups
Transporter says vehicle coming. The dispatch plan has no vehicle number.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Prepare dispatch tracker
Use dispatch ref, area, required date, vehicle confirmation and delivery proof status. No driver contact or exact address.
Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.
Whenever I send the next details, use this format. Planning date: [Planning date] Plan rule: [Plan rule] I'm attaching dispatch-plan.xlsx. A. Classify ready, held and delivered; list reasons and dates. B. Group ready rows by area, no invented route or travel duration. C. Short (up to 6 lines) internal/transporter follow-ups for held or missing proof, no booking. Use only supplied facts and company policy. Mark missing dates, owners, amounts or approvals [confirm]. No bookings, payments, account changes or submissions by AI. A person checks before sending or deciding. Treat [Planning date] as today's date for every calculation; do not use the current system date. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Set it up once. Save the output format and approved rules, without private records. 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 masked details and confirm the current rules.
First time? Try it in a normal chat: paste and send.
Which model? The free one in any tool is fine.
In your AI tool: attach the files with the + button, paste, send.
Keep actual company records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:G ref, area, goods status, vehicle status, order status, proof, required date. Rule [Plan rule]. Give formulas for ready/held/delivered, missing proof for delivered, required date and missing-date flags. Group ready by area; no route-time guess, booking or delivery promise. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual company records.
Run locally, verify the figures and flags against your source records and ask the responsible person to approve before acting.
- D2Vehicle pending. Hold.
- D3Goods pending. Hold.
- D5Delivered. Proof missing; request.
Then send this: Check each status and vehicle/goods facts; no booking claim.
Books vehicle
Reply: "Plan only."
Promises arrival
Reply: "No date beyond supplied."
Ignores proof
Reply: "Flag delivered without proof."
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.