Skip Navigation

Spreadsheet

Performance Review & Calibration Workbook — Weighted Scoring & Rating Distribution (Excel & Sheets)

A weighted performance review template for Excel & Google Sheets — score your team on shared criteria and calibrate the rating distribution.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Rate each person 1–5 against weighted role criteria and their goals
  • The workbook computes one weighted overall score and rating band per person
  • A Calibration tab shows the rating distribution across your whole team
  • A rating-inflation read and a by-manager view catch a lenient or strict rater
  • One owned file — Excel, Google Sheets & LibreOffice, no per-seat review fees

A lot of performance reviews go wrong in the same two ways. Every manager rates a little differently, so the same performance earns a different score depending on who wrote the review. And the ratings quietly drift upward until almost everyone “exceeds” and the review tells no one anything. This workbook fixes both — it scores every person on the same weighted criteria, and it shows you the whole team’s rating distribution so you can calibrate before the reviews are final.

You own the file outright. No per-seat performance-management subscription, no cycle locked behind a login — a structured workbook you keep, adapt to your roles, and reuse every review period.

Rate each person on weighted criteria — the same yardstick for everyone

On the Reviews tab you rate each person 1 to 5 against a shared set of role criteria and their goals, and the workbook does the rest. It computes a weighted overall score on a 1.00–5.00 scale — each rating times its weight, divided by the total weight — and looks up the rating band, from Unsatisfactory to Outstanding. Everyone in the cycle is measured against the same criteria, so the ratings are comparable when you calibrate.

Because it is weighted, the score reflects the actual job. A role built on quality can weight Quality of Work up; a role built on hitting targets can weight Goal Achievement up. You set the weights on the Criteria & Weights tab — rename the criteria, rewrite the descriptions, change the weights — and every review re-scores live.

Calibrate the whole team before reviews are final

Calibration is the step that turns a stack of separate review forms into a fair, comparable cycle — and a step small teams often skip. The Calibration tab does it for you:

  • The rating distribution across everyone reviewed, next to a common reference spread, so you can see the shape at a glance.
  • A rating-inflation read — your combined top-two-band share against the reference, with a plain-language flag when it runs well above.
  • A by-manager view — each manager’s average score and top-box rate, the clearest way to spot a lenient or a strict rater before ratings go out.

Two very different top-box rates on similar teams is the signal to calibrate. You read the distribution, revisit the evidence where it disagrees, and re-rate — before a single review is delivered, which is the only point where a rating can still move.

Everything in the download

  • A 7-tab workbook (.xlsx) that opens in Excel, Google Sheets, and LibreOffice Calc: Read Me, How to Review, Rating Scale, Criteria & Weights, Reviews, Calibration, and Review Log.
  • A one-click Google Sheets copy — open the included link, choose Make a copy, and the whole workbook lands in your Drive with every dropdown, formula, and color already set up. No importing.
  • Four PDF guides — a Start Here guide, the review method & scoring guide, a guide to running the cycle and reading the calibration, and printable review & calibration sheets — written to be read, with worked examples.
  • A pre-loaded worked example (a fictional nine-person team) you overwrite with your own.

Own it, don’t rent it

A performance-management platform charges a subscription, per seat, for the weighted scoring and the calibration view this workbook gives you in one owned file. This sits between a blank spreadsheet you’d have to build from scratch and a rented app built for a company ten times your size: the structure, the math, and the calibration are already done, and the file is yours to keep.

Try it first: the free single-review starter form rates one person on the same weighted criteria — a real taste before you run a whole cycle. And to map the same people on performance and potential, pair it with the 9-Box Talent Grid; to set the goals you review against, the OKR & Goal-Setting Workbook.

A note on what it is

This workbook is a structured tool to help you rate consistently and calibrate fairly. It is not HR, legal, or professional advice, and not a substitute for your own judgment or your organization’s policy. The example people and every rating are fictional and illustrative. The scores are one input to a human conversation and to decisions about development, pay, or promotion that remain yours to make.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 7-tab workbook (.xlsx): Read Me, How to Review, Rating Scale, Criteria & Weights, Reviews, Calibration, Review Log
  • One-click Google Sheets copy — a ready-made native version, no import needed
  • Start Here guide (PDF)
  • Review Method & Scoring guide (PDF)
  • Running the Review Cycle guide (PDF)
  • Printable Review & Calibration Sheets (PDF)
  • Pre-loaded worked example you overwrite with your own team

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Running an operation that's genuinely outgrown the file? Ardent Seller isn't the generic SaaS app this ladder warns about — it's maker-first software built by the same workshop: your data stays yours, you can start free or pay as you go with no subscription required, and it's sized for your operation, not someone bigger. The platform to graduate to when a spreadsheet honestly can't keep up.

Ready to start

Instant download · Free lifetime updates · Personal use license

$24.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.