Tips for using performance appraisal form template
How to prepare a performance appraisal form template?
1. The work standards method compares employees’ work with the work standards and labor quotas established by the company to determine employee performance.
2. Ranking method, a performance evaluation method that ranks employees within a certain range from high to low according to a certain standard.
3. Hard distribution. This method is similar to the sorting method to a certain extent. It is a method that forces a limited range of employees to be distributed according to a certain probability distribution. The advantage of this method is that it avoids eating in one pot. The disadvantage is that the probability assumption is not necessarily consistent with the facts, and the probabilities in different departments or ranges may be different.
4. Critical incident method refers to recording those behaviors that have a significant positive or negative impact on department or enterprise performance.
5. The basic feature of the management by objectives method is that the appraiser and the person being appraised jointly set work goals, guide and assist them in completing the goals, and constantly revise the goals. This changes the relationship between the appraiser and the appraisee from a mere supervisor and the supervised to a consultant and facilitator, promoting the realization of work goals and performance goals.
General Tips for Performance Appraisal Form Templates
1: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:
VLOOKUP (Who are you looking for, where to look for, which column of content is returned, exact search or approximate search)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
When using this function, you need to pay attention to the following points:
1. The fourth parameter is generally set to 0 (or FASLE) to search in exact matching mode.
2. The column number in the third parameter cannot be understood as the actual column number in the worksheet, but specifies the column in the search range of the return value.
3. If the search value is inconsistent with the data type of the data area keyword, the error value #N/A will be returned.
4. The search value must be located in the first column in the query area.
The editor recommends:
The performance appraisal form template is a free template. You can get the source file by downloading it, which can be edited, modified and replaced by you. Huajun Software Park also provideskpi performance appraisal template,Performance appraisal interview form sampleDownload.
Useful
Useful
Useful