Vendor scorecard from actual receipts
Vendor rating says excellent. The rejection register says please check.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get vendor performance rows
Use vendor, deliveries, on-time deliveries, received qty and rejected qty from GRN. Same period.
Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.
Period: [Period] Review rule: [Review rule] I'm attaching vendor-rating.xlsx. A. Calculate on-time % and rejection % per vendor; flag missing or invalid counts. B. List vendors needing review with reasons; sum deliveries and quantities for valid rows only. C. Suggested questions, not automatic vendor removal. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting.
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.
Excel A:E vendor, deliveries, on time, received qty, rejected qty. Rule [Review rule]. Give formulas for valid counts, on-time % and rejection %, hold invalid denominators or counts exceeding totals; flag supplied thresholds and show valid-only totals. No vendor removal. 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.
- V260% on time. 3 of 5; review.
- V310% rejected. 10 of 100; review.
- V4Invalid count. 6 on time of 5 deliveries.
Then send this: Recheck rates and boundaries, exclude invalid counts and sum valid totals.
Invents score weights
Reply: "Use supplied rates only."
Divides by zero
Reply: "Hold invalid denominator."
Removes vendor
Reply: "Review flag only."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. 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.
If your whole team does this, we'll set it up for all of them in one session.