Run a fair, evidence-based appraisal cycle in one connected workbook. Managers rate nine competencies on a 1 to 5 scale, and every level is anchored to observable behaviour, so two managers looking at the same work reach the same rating. The workbook weights the results, assigns an overall rating, flags extreme ratings that lack evidence, compares the outcome with your target distribution, and places every employee on a 9-box performance and potential grid. An 8-page user guide in PDF is included as a secondary document.
WHAT IS INSIDE
A cover page and six working sheets. Start Here explains the six steps and the rating rules. Competency Dictionary holds nine competencies in three clusters: Results (Quality of Work, Timeliness, Goal Achievement), Capability (Technical Expertise, Problem Solving, Communication) and Behaviours (Collaboration, Initiative, Process Improvement). Each has a definition, an evidence source, the evaluator, and behaviour anchors for levels 1, 3 and 5, all editable. Appraisals takes one row per employee: department, manager, nine ratings, potential and evidence. Cluster averages, the weighted score, the overall rating and the 9-box position calculate automatically, and a check column flags missing ratings, missing potential, and any rating of 1 or 5 without an example. Review Form produces a printable one-page review for the selected employee, showing each rating next to the behaviour it stands for. Calibration shows actual against target distribution, average scores and the share of high ratings by manager to reveal lenient or strict raters, scores by department, and the 9-box grid. Settings holds cluster weights, rating bands, the target distribution, departments and managers.
THE USER GUIDE
The PDF guide covers set-up, a six-week appraisal timeline, how to write evidence that holds up with weak and strong examples, a full agenda for the calibration meeting with questions for lenient and strict raters, typical actions for each 9-box position, and troubleshooting.
WHY IT WORKS
Behaviour anchors replace vague adjectives, so ratings can be explained to the employee. The evidence rule stops inflated or unfair extremes before they reach calibration. Performance drives the rating and pay, while potential is judged separately and used for development and succession.
COMPATIBILITY
No macros and no add-ins. Works in Excel 2010 and later, Excel 365, LibreOffice and Google Sheets. Holds up to 300 employees.
WHO IT IS FOR
HR managers, HR business partners, consultants and business owners introducing or repairing a performance appraisal process in organizations of 20 to 300 people.
PLEASE NOTE
All employees, managers and ratings in the file are fictional sample data. Check local employment law before linking ratings to pay or termination decisions.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Performance Management, Talent Management Excel: Performance Appraisal & Competency Toolkit Excel (XLSX) Spreadsheet, Sara Afshar Azad
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more. |