HR Metrics Starter: Eight Numbers, One Definition Each, Reviewed in 15 Minutes a Month

You are asked what your turnover is and give a number from memory, and someone else calculates it differently. This workbook gives you eight metrics, one clear definition each and a place to type 12 months of data, so your numbers can be trusted and compared.

What you get

• Monthly Data tab: 12 months of inputs with 8 metric formulas per month and a yearly row.
• Summary tab: your 12-month number beside a benchmark you enter, with a better or worse flag and a one-sentence read-out.
• Definitions tab: each formula in words, what it tells you and the common mistake.
• Example tab: 12 months of fictional data checked by hand.
• 5 page PDF guide: the 8 metrics, where each input comes from, a worked example and a 15 minute monthly review agenda.

How it works

1. Type 12 months of headcount, hires, separations and the other yellow cells.
2. Read the Summary and add a benchmark for each metric.
3. Review once a month using the 15 minute agenda.

Requirements

Excel, Google Sheets or LibreOffice and a PDF reader. No macros.

What it is not

A starter for descriptive metrics, not an analytics platform or a prediction model. Benchmarks are yours to choose, for example from BLS JOLTS or your own prior year.

Digital products: no refunds once downloaded. A corrupted, incomplete or not-as-described file reported within 14 days of purchase is replaced or refunded in full. Refunds return to your original payment method within ten business days.

These are general HR tools, not legal advice. For a situation with legal stakes, talk with an employment attorney.