Performance Review Inputs
Enter review details, set the rating scale, then score each metric. Weights are automatically normalized, so your total does not need to equal 100.
Example Data Table
This sample shows how weighted review data can compare multiple employees during one review cycle.
| Employee | Period | Scale | Weighted Score | Overall % | Rating Band | Priority Metric |
|---|---|---|---|---|---|---|
| Amina Khan | Q1 2026 | 10 | 8.42 | 84.20% | Strong Performer | Communication |
| Bilal Ahmed | Q1 2026 | 10 | 7.18 | 71.80% | Solid Performer | Goal Achievement |
| Hira Malik | Q1 2026 | 10 | 9.08 | 90.80% | Outstanding | Teamwork |
Formula Used
1. Normalize each metric to the selected scale.
Direct score metrics use the value entered. Percentage metrics are converted to the rating scale.
Direct score: Normalized Score = Entered Score
100% metric: Normalized Score = Max Scale × (Percent ÷ 100)
Goal metric: Normalized Score = Max Scale × (min(Goal %, 120) ÷ 100)
Weighted score: Overall Score = Σ(Normalized Score × Weight) ÷ Σ(Weights)
2. Convert the final score into a percentage.
Overall Percentage = (Overall Score ÷ Max Scale) × 100
3. Apply rating bands.
- 90% and above: Outstanding
- 80% to 89.99%: Strong Performer
- 70% to 79.99%: Solid Performer
- 60% to 69.99%: Developing
- 50% to 59.99%: Needs Improvement
- Below 50%: Unsatisfactory
How to Use This Calculator
- Enter the employee name, role, reviewer, department, and review period.
- Choose the maximum rating scale, such as 5 or 10.
- Score each direct competency using that same scale.
- Enter percentage-based review data for attendance, goals, and deadlines.
- Adjust weights to reflect your review framework or company policy.
- Click the calculate button to see the final rating above the form.
- Review the strongest area, weakest area, and detailed metric breakdown.
- Use the export buttons to save the report in CSV or PDF format.
Frequently Asked Questions
1. What does this calculator measure?
It measures overall work performance through weighted competency scores, attendance, goal completion, deadline delivery, and stakeholder feedback, then converts them into a final rating band.
2. Do the weights need to total 100?
No. The calculator normalizes the weights automatically by dividing total weighted points by the sum of all active weights.
3. Why are attendance and goals converted first?
Those values are percentages, not direct rating scores. They are converted onto the chosen scale so all metrics can be compared fairly in one formula.
4. Can I use a 5-point scale instead of 10?
Yes. Change the maximum rating scale field to 5. All direct score metrics and converted percentages will then use the 5-point scale.
5. Why is goal achievement capped for scoring?
The cap prevents one unusually high value from overpowering the full review. It still rewards overachievement while keeping the rating balanced.
6. How do I identify coaching priorities?
Look at the lowest metric percentage in the result breakdown. That area is flagged as the improvement priority for targeted coaching and follow-up planning.
7. What should I include in stakeholder feedback?
Use survey averages, client comments, peer feedback summaries, or manager observations. Convert that evidence into a fair score on your chosen scale.
8. Can this support quarterly and annual reviews?
Yes. The review period field is flexible, so you can use the same page for monthly, quarterly, semiannual, or annual performance reviews.