PROMPT BRO
HR desk

Training feedback scores and themes

The feedback form has 200 comments. Half say 'good'. The other half need an action plan.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

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

Export anonymous feedback

Keep response code, rating, comment and topic tag if available. Remove identifying details and use the sample first.

First time? Try it on fake data first:

Confirm the rating scale

Check what each score means. Missing scores stay blank, not zero.

Privacy Remove names, contact details, employee codes and identifying comments. Use random response codes only.

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

I'm attaching anonymous feedback for [Training session]. Rating scale: [Rating scale]. Low rating threshold: [Low rating threshold] or below. A. Count responses, valid ratings, missing or out-of-range ratings and low ratings. Average valid ratings only to two decimal places; show sum and denominator. B. Count topic tags from the sheet, one per response. If no tag, group comments and mark the grouping as your interpretation. Show short anonymous examples, no invented quotes. C. Separate findings from suggested improvements, one per repeated topic. Do not infer individual ability or trainer performance beyond the comments. Use only supplied data. HR reviews before sharing.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
3.80average / 5
6responses
2low ratings
  • 2Practice mentions. More examples and another practice round.
  • 2Pace mentions. Two responses say the session moved too fast.
  • F06Rating missing. Excluded from average, comment still counted.
Before you trust it

Then send this: Recount all responses, ratings and topics. Show the exact rating sum and denominator, and check that the missing rating is not zero.

If it goes wrong
It counts blank as zero

Reply: "Exclude missing ratings from the average."

It invents a quote

Reply: "Use only supplied comment text."

It rates the trainer

Reply: "Report feedback themes, not a person-level verdict."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?