the performance appraisal form is a form for evaluating and counting employees' work performance, work ability, work attitude and personal morality, and it is used to judge whether employees are commensurate with the requirements of the post. So how to do the performance appraisal form?

1. Open excel, and first work out what the performance appraisal is. Now I divide it into two parts: performance and behavior. The performance is divided into five dozen projects, and each project is divided into several details; The behavior is divided into five items, and each item has 1 general details.

2. After setting these types and finishing the project, set full marks and performance marks for details now.

3. After setting the performance score, the proportion of this large-scale classification and the full score in the picture begin.

4. After setting the proportion, it is time to set the calculation formula in the line of subtotal of employees' self-evaluation performance = sum (F2: F13) * E2. At the same time, the calculation formula = SUM (F15: F19) * E15 is also set in the line of behavior subtotal; These formulas are used for scoring totals.

5. after setting the total formula of employees' self-evaluation, the calculation formula is set for the line of subtotal of performance scored by the department = sum (G2: G13) * E2. At the same time, the calculation formula = SUM (G15: G19) * E15 is also set in the line of behavior subtotal; These formulas are used for scoring totals

6. Finally, a line of basic item assessment scores is set, which is the total score of two blocks. In the column of employee self-evaluation, it is set to =F14+F21, and in the column of department rating, it is set to = g14+G21; This completes the performance appraisal form.

that's all for the introduction of how to do the performance appraisal form.