PROMPT BRO
Admin desk

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

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

Prepare dispatch tracker

Use dispatch ref, area, required date, vehicle confirmation and delivery proof status. No driver contact or exact address.

First time? Try it on fake data first:

Privacy Remove personal phone numbers, addresses, IDs, bank details and private records. Use employee or document codes and approved business facts only.

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

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.

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.

What you'll get back (example, from the practice files)
2ready
2held
1proof missing
  • D2Vehicle pending. Hold.
  • D3Goods pending. Hold.
  • D5Delivered. Proof missing; request.
Before you trust it

Then send this: Check each status and vehicle/goods facts; no booking claim.

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