Spreadsheet: 693492d1598990138-count-the-number-of-days-a-job-has-been-excuted-with-pivot-summary-daily-production-sheet
Sheet: consolidated sheet 

 | Employee | Job Numbers
 | Names | [NAME]HRS | [NAME]OT | ADMIN WORK HRS | ADMIN WORK OT | [NAME] | [NAME] | JO/20/120-B HRS | JO/20/120-B OT | [NAME] | [NAME] | JO/20/142 HRS | JO/20/142 OT | JO/20/144 HRS | JO/20/144 OT | JO/20/149 HRS | JO/20/149 OT | JO/20/162 HRS | [NAME] | JO/20/175 HRS | JO/20/175 OT | JO/20/178 HRS | JO/20/178 OT | JO/20/179 HRS | JO/20/179 OT | [NAME] | JO/20/180 OT | [NAME] | [NAME] | JO/20/186 HRS | JO/20/186 OT | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Maintainance / Other works  HRS | Maintainance / Other works  OT
 | AJMER SINGH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | BALJIT |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  | 20 |  | 2 |  | 4 |  | 36 |  | 6 |  | 4
 | BOMMANNA |  |  |  |  |  |  |  |  |  |  |  |  | 104 | 3
 | CHRISTOPHER |  |  |  |  | 104 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | DIPAK |  |  |  |  |  |  | 12 |  |  |  | 40 |  | 52 |  |  |  |  |  |  |  |  |  |  | 5
 | FELIX | 1 | 2.3 | 1 | 2.3 |  |  |  |  |  |  |  |  |  |  |  |  | 91 |  | 11 | 25.3
 | FLORENCIO |  |  |  |  |  |  |  |  |  |  |  |  | 104
 | FRANCIS JOSEPH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 80 |  | 8 |  | 8 |  |  |  |  | 32.5
 | GEORGE
 | [NAME]
 | HEMRAJ |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  | 8 |  | 72 |  | 8 |  | 8
 | KUMAR RAM
 | MALIK |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 1 |  |  |  |  |  |  | 2.5
 | MARTIN |  |  |  |  |  |  |  |  |  | 3
 | MATHEW |  |  |  |  | 39 | 42.89999999999999 |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3
 | RAJASEKAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 |  | 8 |  | 8
 | RAJEEV |  |  |  |  |  |  |  |  | 104 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | RASHID |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 3 |  |  | 2 |  |  |  |  |  | 4
 | RAVI |  |  |  |  |  |  | 24 |  |  |  | 72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | SAMUEL |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  | 88 |  | 8 | 6 |  |  |  |  | 8
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  | 4 |  | 40 |  | 4 |  | 4 |  |  |  | 52
 | SATHYAPALAN
 | SATIYAR |  |  |  |  |  |  |  |  | 104 | 4
 | SHAM |  |  |  |  |  |  | 24 |  |  |  | 80
 | SIVA |  |  |  |  | 104 | 42.89999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
 | SIVA |  |  |  |  |  | 4 |  |  |  |  |  |  | 36 | 2 |  |  |  |  | 5 |  | 5 |  |  |  | 4 |  | 36 |  | 22 |  | 5 |  | 1 |  |  | 32.5
 | SONU  CHAUHAN |  |  |  |  |  |  | 24 |  |  |  | 80
 | SURENDRA |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 8 |  | 8 |  |  | 30
 | VINOTH | 1 | 2.3 | 1 | 2.3 |  |  |  |  |  |  |  |  |  |  |  |  | 91 |  | 11 | 25.3
 | Grand Total | 2 | 4.6 | 2 | 4.6 | 247 | 89.79999999999998 | 84 |  | 208 | 14 | 280 |  | 325 | 13 | 65 |  | 182 | 3 | 27 | 53.60000000000001 | 115 |  | 10 | 16 | 28 |  | 280 |  | 225 |  | 45 |  | 35 | 7 | 52 | 97.5