Sales achievement and incentive working
The target sheet says 99.9%. The incentive sheet suddenly needs a meeting.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Make a dummy sales sheet
Use rep codes, target and approved eligible sales. Practise on the sample; keep actual personal incentive amounts in your company file.
Confirm the scheme
Use the exact approved threshold and calculation basis. No assumed slabs, deductions or payments.
Privacy Upload only fictional practice data. Actual rep pay, incentive amounts and employee details stay in your payroll and sales files.
I'm attaching fictional rep-level sales data for [Month]. Scheme: [Approved scheme]. Basis: [Sales basis]. A. For each rep calculate achievement % = eligible sales / target × 100 if target positive. Hold duplicate rep codes (all copies), missing sales or target not positive; calculate incentive for valid rows using supplied rule. B. Count achieved, below target and held; sum known valid target, sales and incentive separately. Do not treat held rows as zero. C. Draft a short explanation of the scheme and list questions for payroll/sales manager. No pay decision, no personal salary records. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding. Do not repeat personal identifiers from the data (personal names, phone numbers, email or postal addresses, bank account numbers, UPI IDs, PAN, Aadhaar, GSTIN or other registration numbers) unless the output genuinely needs one; use the code, ref or row instead, and copy any needed identifier exactly. Keep masked values masked; never guess, complete or unmask them.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Use the calculation on your own Excel file.
Excel A:C = rep code, target, eligible sales. Approved scheme [Approved scheme]; basis [Sales basis]. Write formulas for D achievement % if target positive and sales numeric, E eligibility status, F incentive if valid. Hold missing or zero target and missing sales. Explain valid-only totals.
Fill down locally; verify against approved scheme and sales records; payroll and manager approve.
- R01100%. ₹3 L sales on ₹3 L target; incentive ₹3,000.
- R03Target zero. Achievement cannot be calculated; hold.
- R04Sales missing. Hold until eligible sales confirmed.
Then send this: Recalculate each achievement and incentive from the supplied approved scheme, including its exact threshold and equality rule. Verify held rows are excluded and valid totals tie.
It adds a slab
Reply: "Only apply my approved scheme."
It divides by zero
Reply: "Hold zero target."
It assumes missing sales zero
Reply: "Hold missing value."
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.