🪄 Enter your scores to automatically group people and calculate percentages
📝 Contains 2 versions and an interpretation readme
❓ What is a 9-Box Grid?
The 9-box grid matrix, also known as the performance-potential matrix, is used to evaluate an employee's performance and potential for growth.
This tool is widely used to assess the talent pool of an organization, identify top performers, and plan their development. But creating a 9-box grid from scratch can be time-consuming and challenging. This is where the 9-box grid Excel template comes into play.
The 9-box grid is a visual representation of employees' performance and potential, based on a set of predefined criteria. It is a 3x3 matrix that divides employees into nine categories, based on their performance and potential. The horizontal axis represents an employee's performance, while the vertical axis represents an employee's potential. The nine categories are:
High Potential - High Performer
High Potential - Average Performer
High Potential - Low Performer
Average Potential - High Performer
Average Potential - Average Performer
Average Potential - Low Performer
Low Potential - High Performer
Low Potential - Average Performer
Low Potential - Low Performer
🔍 Why is the 9-Box Grid Important?
It helps in identifying top performers and high-potential employees who can take up leadership roles in the future.
It assists in assessing the talent pool of the organization and identifying skill gaps.
It aids in succession planning by identifying potential successors for key positions.
Pick this one, if you already have both numbers on a scale of 1-3
💡 This version directly works with your values for performance and potential on a 1-3 scale.
🪄 List down your employees In the table (A14...) and they will automatically appear in the grid.
🔍 To interpret the sections, browse to the sheet called "Interpretation"
Performance Management 9-box template
Pick this one, if your performance number is calculated from multiple questions + on a bigger scale (e.g. 1-5)
💡 This, slightly more advanced version, assumes- multiple performance ratings (in this example: 5)- and a bigger scale (in this example: 1-5)
🪄 List down your employees and values In the table (A14...) and they will automatically appear in the grid.Use Column B to enter your value for "potential" (1-3).
Enter the single performance question items in the following columns. If you need more, make sure that column H still works properly.
Column H calculates the average across all performance questions.
Column I converts the original scale into a 1-3 scale. (If your original scale is different, change the value in B11 to your maximum)
Column J outputs the rounded, converted value and defines where people will land.🔍 To interpret the sections, browse to the sheet called "Interpretation"