That is his original efficiency score times the weight of efficiency (10) divided by the maximum potential weight (10).Īrchie’s Attendance is calculated with =((C3*5)/10), and finally, speed is calculated with =((D3*3)/10). Here, the equation for Archie’s weighted efficiency is =((B4*10)/10). In the Excel template, a weighted item is denoted by an * asterisk. Now we need to calculate weighted scores for the criteria and total score. Step 6 - Calculate weighted criteria scores and total scores Simply remember to score them on the same scale. Note that multiple criteria can have the same level of importance. In the example, speed is least important, attendance is moderately important, and efficiency is highly important. Score each criteria on a scale of importance. That is why we need to determine the weight that each criteria holds when calculating total score. Some performance criteria are going to be more important to employee success than others. This is the list you will want to rank based on performance variables. In the first column, list out your employees by name, employee ID or other identifier. Guide for stack ranking template Step 1 - List employees This will allow you to assign more weight to more important criteria. Think about your performance criteria and how they relate in importance. Stack ranking assumes that certain criteria are more important than others. Whether you score out of 100 or 10 (or some other range) is up to you and your system. You must be able to give a numerical rating to each performance criteria. What items are you using to measure employee performance? Is it their attendance level, number of projects completed, ability to work quickly? Here is a checklist of the information and values you will need to use the stack ranking template. Download our free stack ranking template for Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |