Tips for using performance appraisal forms for logistics personnel
Logistics staff performance appraisal formPreparation of:
1. The monthly assessment is based on four aspects: the assessor's completion of the work plan for the month, work quality, work attitude, and work collaboration.
2. Individual assessments are organized by the unit (department) where they work, and the assessment results are reported to the company's Human Resources and Labor Department. After confirmation, a list is posted in the unit (department).
3. When the individual assessment score is less than 50 points, M3=0, that is, the job performance salary is zero.
4. Job performance wages are paid on a monthly basis, and the units (departments) make secondary distributions based on individual assessment results, and the balance is used as unit (department) reward funds.
5. When assessing basic production workers, if the number of working hours completed in the month exceeds the quota, each unit (department) can formulate corresponding reward regulations.
General tips for logistics staff performance appraisal form
1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.
Recommended by the editor of Huajun Software Park
The Logistics Staff Performance Appraisal Form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the Logistics Staff Performance Appraisal Form, please download it quickly.Summary table of investigation of project funds in arrears,Sales monthly planIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works