Calculator Inputs
Use the responsive calculator grid below. It displays three columns on large screens, two on smaller screens, and one on mobile.
Example Data Table
This sample monthly dataset matches the calculator defaults, so you can test the scorecard immediately after loading the page.
| Period | Start HC | End HC | Hires | Separations | Absence Days | Filled Roles | Total Fill Days | Offers Extended | Offers Accepted | Training Hours | Revenue | Promotions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sample Month | 120 | 126 | 14 | 8 | 46 | 10 | 280 | 12 | 10 | 320 | 950,000 | 5 |
Formula Used
((Starting Headcount + Ending Headcount) / 2)
(Separations / Average Headcount) × 100
((Starting Headcount - Separations) / Starting Headcount) × 100
(Unplanned Absence Days / (Average Headcount × Workdays)) × 100
Total Days to Fill / Filled Positions
(Offers Accepted / Offers Extended) × 100
Training Hours / Total Employees
Revenue / Average Headcount
(Promotions / Average Headcount) × 100
For higher-is-better KPIs: (Actual / Target) × 100
For lower-is-better KPIs: (Target / Actual) × 100
(Achievement Score × KPI Weight) / Total Weight
Sum of all weighted KPI contributions
How to Use This Calculator
- Enter monthly or quarterly workforce data in the main input blocks.
- Provide target values for each KPI you want to benchmark.
- Assign relative weights based on strategic importance.
- Click Calculate HR Scorecard to generate the weighted results.
- Review the overall score, strongest KPI, weakest KPI, and graph.
- Use the CSV or PDF buttons to export the scorecard summary.
- Repeat each period to build a consistent HR operating cadence.
FAQs
1) What does the overall weighted score mean?
It combines all KPI achievement scores after applying your selected weights. A score of 100 means your overall people performance met target. Above 100 means you exceeded target overall, while below 100 signals underperformance against your chosen plan.
2) Why are some metrics treated as lower-is-better?
Turnover, absenteeism, and time to fill usually improve when they decline. The calculator flips the scoring logic for those measures so a lower actual value can still generate a stronger achievement score.
3) Can I change the KPI weights?
Yes. Weights are fully editable. Use larger weights for the metrics most important to your people strategy. The tool automatically normalizes all weights, so they do not need to add up to exactly 100.
4) Which reporting period should I use?
You can use monthly, quarterly, or annual data. The most useful approach is consistency. Keep the same reporting cadence and definitions each period so your scorecard can show clean operational trends.
5) Why is achievement score capped at 150?
The cap prevents one unusually strong KPI from overpowering the rest of the scorecard. It keeps the summary balanced and makes the final weighted score more useful for management reviews.
6) Does revenue per employee need profit data?
No. This calculator uses revenue only. If your team prefers profit per employee or gross margin per employee, you can adapt the same framework by replacing the revenue input with your preferred business outcome measure.
7) Can this scorecard work for different departments?
Yes. You can run it for a company, region, business unit, or department. Just keep the inputs and targets aligned to the same population, time period, and measurement rules.
8) What is the best way to set targets?
Use a mix of past performance, budget expectations, benchmark data, and strategic priorities. Targets should be ambitious but realistic enough to guide actions and support management accountability.