Spreadsheet: 798187d1664359143-preparing-incentive-sheet-for-workers-based-on-criteria-incentive-sheet-query-etaf
Sheet: WORKER AND OPERATOR  (2)

OPERATORS & WORKERS INCENTIVE JUNE 2022
Sr.No | Name Of Employee | Designation |  | Average Score | Incentive Rate Slab | Incentive Rate Slab | [NAME] | Att% | Late Coming Max | Total Incentive Amount | Score Wise Incentive % | Actual Incentive | Qualify/Disqaulify
1 | A 1 | Worker |  | 0.12 |  | 80 | 28 |  | 0 |  | 0.84 |  | Qualify
2 | A 2 | Operator |  | 1.1 |  | 90 | 25 |  | 0 |  | 0.84 |  | Qualify
3 | A 3 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.83 |  | Qualify
4 | A 4 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.74 |  | Qualify
5 | A 5 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.82 |  | Qualify
6 | A 6 | Operator |  | 0.8 |  | 125 | 25 |  | 0 |  | 0.71 |  | Qualify
7 | A 7 | Operator |  | 0.9 |  | 125 | 26 |  | 0 |  | 0.96 |  | Qualify
8 | A 8 | Operator |  | 0.7 |  | 50 | 20 |  | 0 |  | 0.52 |  | Qualify
9 | A 9 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.74 |  | Qualify
10 | A 10 | Operator |  | 0.12 |  | 50 | 27 |  | 0 |  | 0.64 |  | Qualify
11 | A 11 | Operator |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.73 |  | Qualify
12 | A 12 | Operator |  | 0.8 |  | 90 | 26 |  | 0 |  | 0.65 |  | Qualify
13 | A 13 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.71 |  | Qualify
14 | A 14 | Operator |  | 0.8 |  | 90 | 26 |  | 0 |  | 0.73 |  | Qualify
15 | A 15 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.7 |  | Qualify
16 | A 16 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.77 |  | Qualify
17 | A 17 | Operator |  | 0.8 |  | 90 | 20 |  | 0 |  | 0.77 |  | Qualify
18 | A 18 | Operator |  | 0.9 |  | 125 | 26 |  | 0 |  | 0.8 |  | Qualify
19 | A 19 | Operator |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.97 |  | Qualify
20 | A 20 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.61 |  | Qualify
21 | A 21 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.83 |  | Qualify
22 | A 22 | Operator |  | 0.8 |  | 90 | 23 |  | 0 |  | 0.71 |  | Qualify
23 | A 23 | Operator |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.81 |  | Qualify
24 | A 24 | Worker |  | 0.8 |  | 60 | 27 |  | 0 |  | 0.84 |  | Qualify
25 | A 25 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.7461 |  | Qualify
26 | A 26 | Worker |  | 1.1 |  | 60 | 24 |  | 4 |  | 0.7 |  | Qualify
27 | A 27 | Worker |  | 0.2 |  | 60 | 24 |  | 0 |  | 0.66 |  | Qualify
28 | A 28 | Operator |  | 0.8 |  | 90 | 22 |  | 0 |  | 0.72 |  | Qualify
29 | A 29 | Operator |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.9 |  | Qualify
30 | A 30 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.81 |  | Qualify
31 | A 31 | Operator |  | 0.8 |  | 90 | 26 |  | 0 |  | 0.82 |  | Qualify
32 | A 32 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.65 |  | Qualify
33 | A 33 | Operator |  | 0.7 |  | 125 | 26 |  | 0 |  | 0.62 |  | Qualify
34 | A 34 | Operator |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.63 |  | Qualify
35 | A 35 | Operator |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.72 |  | Qualify
36 | A 36 | Operator |  | 0.9 |  | 125 | 26 |  | 0 |  | 0.79 |  | Qualify
37 | A 37 | Operator |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.77 |  | Qualify
38 | A 38 | Operator |  | 0.7 |  | 50 | 27 |  | 0 |  | 0.65 |  | Qualify
39 | A 39 | Operator |  | 0.8 |  | 90 | 25 |  | 4 |  | 0.72 |  | Qualify
40 | A 40 | Worker |  | 0.8 |  | 60 | 25 |  | 0 |  | 0.73 |  | Qualify
41 | A 41 | Operator |  | 0.8 |  | 90 | 29 |  | 0 |  | 0.83 |  | Qualify
42 | A 42 | Operator |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.8 |  | Qualify
43 | A 43 | Operator |  | 0.9 |  | 125 | 27 |  | 0 |  | 0.86 |  | Qualify
44 | A 44 | Operator |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.97 |  | Qualify
45 | A 45 | Operator |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.89 |  | Qualify
46 | A 46 | Worker |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.77 |  | Qualify
47 | A 47 | Worker |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.78 |  | Qualify
48 | A 48 | Worker |  | 0.7 |  | 50 | 24 |  | 0 |  | 0.68 |  | Qualify
49 | A 49 | Worker |  | 0.8 |  | 90 | 26 |  | 0 |  | 0.67 |  | Qualify
50 | A 50 | Worker |  | 0.8 |  | 90 | 28 |  | 0 |  | 0.8 |  | Qualify
51 | A 51 | Worker |  | 0.9 |  | 125 | 28 |  | 0 |  | 0.84 |  | Qualify
52 | A 52 | Worker |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.65 |  | Qualify
53 | A 53 | Operator |  | 0.7 |  | 50 | 24 |  | 0 |  | 0.8 |  | Qualify
54 | A 54 | Operator |  | 0.9 |  | 125 | 27 |  | 0 |  | 0.9 |  | Qualify
55 | A 55 | Operator |  | 0.9 |  | 125 | 27 |  | 0 |  | 0.9 |  | Qualify
56 | A 56 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.8 |  | Qualify
57 | A 57 | Operator |  | 0.9 |  | 125 | 26 |  | 0 |  | 0.8666 |  | Qualify
58 | A 58 | Operator |  | 0.9 |  | 125 | 23 |  | 0 |  | 0.7666 |  | Qualify
59 | A 59 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.64 |  | Qualify
60 | A 60 | Operator |  | 0.8 |  | 90 | 25 |  | 0 |  | 0.83 |  | Qualify
61 | A 61 | Operator |  | 0.9 |  | 125 | 24 |  | 0 |  | 0.83 |  | Qualify
62 | A 62 | Worker |  | 0.7 |  | 50 | 23 |  | 4 |  | 0.58 |  | Qualify
63 | A 63 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.8 |  | Qualify
64 | A 64 | Worker |  | 0.7 |  | 40 | 23 |  | 0 |  | 0.51 |  | Qualify
65 | A 65 | Worker |  | 0.7 |  | 40 | 25 |  | 0 |  | 0.62 |  | Qualify
66 | A 66 | Worker |  | 0.7 |  | 40 | 26 |  | 0 |  | 0.56 |  | Qualify
67 | A 67 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.96 |  | Qualify
68 | A 68 | Worker |  | 0.8 |  | 60 | 23 |  | 0 |  | 0.59 |  | Qualify
69 | A 69 | Worker |  | 0.9 |  | 80 | 24 |  | 0 |  | 0.8 |  | Qualify
70 | A 70 | Operator |  | 0.8 |  | 90 | 26 |  | 4 |  | 0.69 |  | Qualify
71 | A 71 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.85 |  | Qualify
72 | A 72 | Operator |  | 0.8 |  | 90 | 22 |  | 0 |  | 0.59 |  | Qualify
73 | A 73 | Worker |  | 0.9 |  | 80 | 27 |  | 0 |  | 0.8 |  | Qualify
74 | A 74 | Worker |  | 0.8 |  | 60 | 25 |  | 0 |  | 0.75 |  | Qualify
75 | A 75 | Worker |  | 0.8 |  | 60 | 25 |  | 0 |  | 0.75 |  | Qualify
76 | A 76 | Worker |  | 0.9 |  | 80 | 27 |  | 0 |  | 0.8 |  | Qualify
77 | A 77 | Worker |  | 0.8 |  | 60 | 26 |  | 0 |  | 0.81 |  | Qualify
78 | A 78 | Worker |  | 0.8 |  | 60 | 26 |  | 0 |  | 0.84 |  | Qualify
79 | A 79 | Driver |  | 0.8 |  | 60 | 26 |  | 0 |  | 0.5 |  | Qualify
80 | A 80 | Driver |  | 0.8 |  | 60 | 26 |  | 0 |  | 0.8 |  | Qualify
81 | A 81 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.8666 |  | Qualify
82 | A 82 | Worker |  | 0.9 |  | 80 | 24 |  | 0 |  | 0.8 |  | Qualify
83 | A 83 | Worker |  | 0.9 |  | 80 | 27 |  | 0 |  | 0.8 |  | Qualify
84 | A 84 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.85 |  | Qualify
85 | A 85 | Worker |  | 0.9 |  | 80 | 25 |  | 0 |  | 0.9 |  | Qualify
86 | A 86 | Worker |  | 0.9 |  | 80 | 28 |  | 0 |  | 0.9 |  | Qualify
87 | A 87 | Worker |  | 0.9 |  | 80 | 24 |  | 0 |  | 0.8 |  | Qualify
88 | A 88 | Worker |  | 0.9 |  | 80 | 24 |  | 0 |  | 0.9 |  | Qualify
89 | A 89 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.75 |  | Qualify
90 | A 90 | Worker |  | 0.9 |  | 80 | 26 |  | 0 |  | 0.8 |  | Qualify
91 | A 91 | Worker |  | 0.9 |  | 80 | 28 |  | 0 |  | 0.8 |  | Qualify
92 | A 92 | Worker |  | 0.9 |  | 80 | 27 |  | 0 |  | 0.8 |  | Qualify
93 | A 93 | Worker |  | 0.9 |  | 80 | 28 |  | 0 |  | 0.9 |  | Qualify
94 | A 94 | Worker |  | 0.9 |  | 80 | 28 |  | 0 |  | 0.8 |  | Qualify
95 | A 95 | Office Boy |  | 0.9 |  | 80 | 23 |  | 0 |  | 0.9 |  | Qualify
96 | A 96 | Worker |  | 0.8 |  | 60 | 27 |  | 0 |  | 0.8 |  | Qualify
97 | A 97 | Worker |  | 0.7 |  | 40 | 21 |  | 0 |  | 0.9 |  | Qualify
98 | A 98 | Operator |  | 0.7 |  | 50 | 18 |  | 0 |  | 0 |  | Disqualify
99 | A 99 | Operator |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | Disqualify
100 | A 100 | Operator |  | 0.8 |  | 90 | 21.5 |  | 7 |  | 0.1 |  | Disqualify
101 | A 101 | Operator |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | Disqualify
102 | A 102 | Operator |  | 0.8 |  | 90 | 26 |  | 7 |  | 0.4 |  | Late Coming
103 | A 103 | Operator |  | 0.7 |  | 50 | 11 |  | 0 |  | 0 |  | Disqualify
104 | A 104 | Operator |  | 0.8 |  | 90 | 24 |  | 0 |  | 0.75 |  | Disqualify
105 | A 105 | Worker |  | 0.8 |  | 60 | 25 |  | 0 |  | 0.7 |  | Disqualify
106 | A 106 | Operator |  | 0.7 |  | 50 | 16 |  | 0 |  | 0 |  | Disqualify
107 | A 107 | Worker |  | 0.7 |  | 40 | 26 |  | 6 |  | 0.2 |  | Late Coming
108 | A 108 | Worker |  | 0.8 |  | 60 | 25 |  | 7 |  | 0.2 |  | Late Coming
109 | A 109 | Operator |  | 0 |  | 50 | 19 |  | 0 |  | 0 |  | Disqualify
110 | A 110 | Operator |  | 0.8 |  | 90 | 30 |  | 5 |  | 0.4 |  | Late Coming
111 | A 111 | Operator |  | 0.7 |  | 50 | 24 |  | 8 |  | 0.2 |  | Late Coming
112 | A 112 | Operator |  | 0.9 |  | 125 | 21.5 |  | 0 |  | 0.4 |  | absentism
113 | A 113 | Operator |  | 0.7 |  | 50 | 20 |  | 0 |  | 0.1 |  | Disqualify
114 | A 114 | Operator |  | 0.8 |  | 90 | 24 |  | 12 |  | 0 |  | Disqualify
115 | A 115 | Operator |  | 0.7 |  | 50 | 22 |  | 7 |  | 0.2 |  | Late Coming
116 | A 116 | Operator |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | Disqualify
117 | A 117 | Operator |  | 0.7 |  | 50 | 19 |  | 0 |  | 0 | 0 | Disqualify
118 | A 118 | Worker |  | 0.8 |  | 60 | 23 |  | 7 |  | 0.2 |  | Late Coming
119 | A 119 | Operator |  | 0.7 |  | 50 | 24 |  | 14 |  | 0 |  | Disqualify
120 | A 120 | Worker |  | 0.7 |  | 40 | 19 |  | 0 |  | 0 |  | Disqualify
121 | A 121 | Worker |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | Disqualify
122 | A 122 | Worker |  | 0.9 |  | 80 | 27 |  | 7 |  | 0.2 |  | Late Coming
123 | A 123 | Worker |  | 0.7 |  | 40 | 19 |  | 0 |  | 0 |  | Disqualify
124 | A 124 | Operator |  | 0.8 |  | 90 | 28 |  | 23 |  | 0 |  | Disqualify
125 | A 125 | Worker |  | 0.7 |  | 40 | 24 |  | 10 |  | 0.1 |  | Late Coming
126 | A 126 | Worker |  | 0 |  | 0 | 15 |  | 13 |  | 0 |  | Disqualify
127 | A 127 | Worker |  | 0.9 |  | 80 | 22 |  | 6 |  | 0.2 |  | Late Coming
128 | A 128 | Operator |  | 0.8 |  | 90 | 29 |  | 10 |  | 0.1 |  | Late Coming
129 | A 129 | Operator |  | 0.9 |  | 125 | 23 |  | 7 |  | 0.4 |  | Late Coming
130 | A 130 | Operator |  | 0.9 |  | 125 | 15 |  | 0 |  | 0 |  | Disqualify
131 | A 131 | Worker |  | 0 |  | 80 | 26 |  | 13 |  | 0 |  | Disqualify
132 | A 132 | Worker |  | 0 |  | 0 | 19 |  | 9 |  | 0 |  | Disqualify
133 | A 133 | Worker |  | 0 |  | 0 | 6 |  | 0 |  | 0 |  | Disqualify
134 | A 134 | Worker |  | 0 |  | 0 | 17 |  | 0 |  | 0 |  | Disqualify
135 | A 135 | Operator |  | 0.8 |  | 90 | 30 |  | 24 |  | 0 |  | Disqualify
136 | A 136 | Operator |  | 0.9 |  | 125 | 25 |  | 6 |  | 0.2 |  | Late Coming
137 | A 137 | Worker |  | 0.7 |  | 40 | 28 |  | 6 |  | 0.4 |  | Late Coming
138 | A 138 | Worker |  | 0.9 |  | 80 | 21 |  | 0 |  | 0.2 |  | Attendance
139 | A 139 | Worker |  | 0.7 |  | 40 | 29 |  | 19 |  | 0 |  | Disqualify
140 | A 140 | Worker |  | 0.7 |  | 40 | 29 |  | 19 |  | 0 |  | Disqualify
141 | A 141 | Operator |  | 0.8 |  | 60 | 29 |  | 13 |  | 0 | 0 | Disqualify
142 | A 142 | Worker |  | 0.8 |  | 60 | 27 |  | 12 |  | 0 |  | Disqualify
143 | A 143 | Worker |  | 0 |  | 0 | 9 |  | 0 |  | 0 |  | Disqualify
144 | A 144 | Worker |  | 0.8 |  | 60 | 20 |  | 0 |  | 0.1 |  | absentism
145 | A 145 | Worker |  | 0.9 |  | 80 | 23 |  | 13 |  | 0 |  | Disqualify
146 | A 146 | Operator |  | 0.9 |  | 125 | 26 |  | 8 |  | 0.1 |  | Late Coming
147 | A 147 | Worker |  | 0 |  | 0 | 16 |  | 7 |  | 0 |  | Disqualify
148 | A 148 | Office Boy |  | 0 |  | 0 | 25 |  | 15 |  | 0 |  | Disqualify