Corporate attendance sheetcontent:
1. Unit name
2. Department name
3. Number
4. Name
5. Late
6. Leave early
7. Absenteeism from work
8. Actual attendance
9. Remarks
General tips for corporate attendance sheet 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
Corporate attendance sheetIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need a corporate attendance sheet, download it quickly. also,Job introduction work status table,Job applicant resumeIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works