Tips for using engineering performance appraisal form
Engineering Performance Appraisal FormPreparation of:
(1) Daily assessment. Refers to the regular evaluation of the assessee's attendance, production and quality performance, and usual work behavior;
(2) Regular evaluation. Refers to the evaluation conducted according to a certain fixed cycle, such as annual evaluation, quarterly evaluation, etc.
General tips for engineering performance appraisal forms
1. Sum: =SUM(K2:K56) Sum the area from K2 to K56;
2. Average: =AVERAGE(K2:K56) Find the average of the area K2 K56;
3. Ranking: =RANK(K2,K$2:KS56) ranks the results of 55 students;
4. Level: =IF(K2>=85, "Excellent", IF(K2>=74, "People", IF(K2>=60, "Pass", "Fail")))
5. Semester overall evaluation: =K2*0.3+M2*0.3+N2*0.4 Assume that column K, column M and column N respectively store the three grades of students: "usual overall evaluation", "midterm" and "final";
6. Highest score: =MAX(K2:K56) Find the highest score in the K2 to K56 area (55 students);
7. Minimum score: =MIN(K2:K56) ——- Find the lowest score in the K2 to K56 area (55 students);
Recommended by the editor of Huajun Software Park
The Engineering 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 Engineering Performance Appraisal Form, please download it quickly.Organization life meeting minutes,Body temperature check formIt is also a good form. Welcome to click to download and experience it!
it works
it works
it works