Spreadsheet: 794459d1662055343-calculating-attendance-times-from-shift-books-on-product-basis-excel-forum-attendances
Sheet: Data

Machine | Date | Shift | Employee | Item code | te (production time per item) | Quantity produced (right) | Quantity produced (left) | setting-up (minutes) | Losses (no production) | Reason for loss | ta hrs. = actual time required to produce quanitity (column G or H) |  | Hub |  | Number of setting-ups | Machine utilization in hrs | Production hours in te times (column F)
15221 | 2022-08-22 00:00:00 | 1 | 293373 | 310808-01 | 12.5 | 6460 |  | 60 |  |  | 3.5
15221 | 2022-08-22 00:00:00 | 1 | 293373 | 10205766-01 | 12.5 | 7856 |  | 30 |  |  | 2.5
15221 | 2022-08-22 00:00:00 | 2 | 173512 | 310808-01 | 12.5 | 8100 |  |  | 210 | 3 | 4
15221 | 2022-08-22 00:00:00 | 3 | 13319 | 310808-01 | 12.5 | 15448 |  |  |  |  | 7.5
15222 | 2022-08-22 00:00:00 | 1 | 293373 | 916391 | 18.37 | 3026 |  | 60 | 90 | 11 | 1
15222 | 2022-08-22 00:00:00 | 1 | 293373 | 10221346-01 | 15 |  |  | 60 | 180 | 11
15222 | 2022-08-22 00:00:00 | 2 | 13918 | 10221346-01 | 15 | 17190 |  |  |  |  | 7.5
15222 | 2022-08-22 00:00:00 | 3 | 13012 | 315802-01 | 22 | 14610 |  |  | 90 | 6 | 6
15222 | 2022-08-22 00:00:00 | 3 | 178410 | 939703 | 27.5 |  |  | 30 | 105 | 3
15223 | 2022-08-22 00:00:00 | 1 | 293373 | 939703 | 27.5 |  |  | 60 | 390 | 23
15223 | 2022-08-22 00:00:00 | 2 | 175200 | 939703 | 27.5 | 5870 |  | 15 | 255 | 11 | 3
15223 | 2022-08-22 00:00:00 | 3 | 178410 | 29929-01 | 27.5 | 6560 |  | 45 | 105 | 11 | 2.75
15230 | 2022-08-22 00:00:00 | 1 | 183900 | 938823-01 | 41.25 | 10400 |  |  |  |  | 7.5
15230 | 2022-08-22 00:00:00 | 2 | 293383 | 111742-01 | 16.5 | 9050 |  | 45 | 60 | 14 | 2.5
15230 | 2022-08-22 00:00:00 | 2 | 293383 | 938823-01 | 41.25 | 3900 |  | 30 |  |  | 2.75
15230 | 2022-08-22 00:00:00 | 3 | 175710 | 111742-01 | 16.5 | 17065 |  |  | 150 | 25 | 5
15241 | 2022-08-22 00:00:00 | 1 | 175310 | 212331-01 | 16.5 | 11000 |  |  | 150 | 4 | 5
15241 | 2022-08-22 00:00:00 | 2 | 176700 | 210384-01 | 36 | 4800 |  | 60 | 30 | 9 | 2.5
15241 | 2022-08-22 00:00:00 | 2 | 176700 | 212331-01 | 16.5 | 6160 |  | 30 |  |  | 3
15241 | 2022-08-22 00:00:00 | 3 | 173600 | 10204964-01 | 27.5 | 2700 |  | 45 | 135 | 9 | 1.5
15241 | 2022-08-22 00:00:00 | 3 | 173600 | 210384-01 | 36 | 6185 |  | 30 |  |  | 2.5
15242 | 2022-08-22 00:00:00 | 1 | 13219 | 013202-01 | 110 |  |  |  | 450 | 11
15242 | 2022-08-22 00:00:00 | 2 | 176211 | 013202-01 | 110 | 2210 |  |  | 165 | 27 | 4.75
15242 | 2022-08-22 00:00:00 | 3 | 171610 | 013202-01 | 110 | 1890 |  |  | 240 | 11 | 3.5
15221 | 2022-08-23 00:00:00 | 1 | 293373 | 310808-01 | 12.5 | 11400 |  |  | 120 | 3 | 5.5
15221 | 2022-08-23 00:00:00 | 2 | 173512 | 48386 | 18.18 |  |  | 30 | 90 | 11
15221 | 2022-08-23 00:00:00 | 2 | 173512 | 310261-01 | 22 | 6160 |  | 45 | 15 | 11 | 2.75
15221 | 2022-08-23 00:00:00 | 2 | 173512 | 310808-01 | 12.5 | 3890 |  | 15 |  |  | 1.5
15221 | 2022-08-23 00:00:00 | 3 | 13319 | 310250-01 | 18.37 |  |  | 30
15221 | 2022-08-23 00:00:00 | 3 | 13319 | 48386 | 18.18 | 14112 |  | 60 | 30 | 8 | 5.5
15222 | 2022-08-23 00:00:00 | 1 | 293373 | 211773-01 | 32.35 | 1330 |  | 105 | 45 | 23 | 1
15222 | 2022-08-23 00:00:00 | 1 | 293373 | 315802-01 | 22 | 5930 |  | 30 |  |  | 3.5
15222 | 2022-08-23 00:00:00 | 2 | 13918 | 27527-01 | 16.67 | 15885 |  | 60 |  |  | 6.5
15222 | 2022-08-23 00:00:00 | 3 | 13012 | 390119-01 | 27.5 | 10500 |  | 60 |  |  | 4.25
15222 | 2022-08-23 00:00:00 | 3 | 13012 | 27527-01 | 16.67 | 2749 |  | 180 | 145 | 3 | 1
15223 | 2022-08-23 00:00:00 | 1 | 293373 | 29929-01 | 27.5 | 6840 |  |  | 255 | 11 | 3.25
15223 | 2022-08-23 00:00:00 | 2 | 175200 | 29929-01 | 27.5 | 5700 |  |  | 240 | 11 | 3.5
15223 | 2022-08-23 00:00:00 | 3 | 178410 | 29929-01 | 27.5 | 11000 |  | 30 | 120 | 3 | 5
15230 | 2022-08-23 00:00:00 | 1 | 183900 | 115127-01 | 55 | 265 |  | 90 |  |  | 0.25
15230 | 2022-08-23 00:00:00 | 1 | 183900 | 111742-01 | 16.5 | 1060 |  | 30 | 270 | 25 | 0.75
15230 | 2022-08-23 00:00:00 | 2 | 293383 | 115127-01 | 55 | 9250 |  |  | 60 | 14 | 6.5
15230 | 2022-08-23 00:00:00 | 3 | 175710 | 115128-01 | 55 | 4460 |  | 60 |  |  | 3.25
15230 | 2022-08-23 00:00:00 | 3 | 175710 | 115127-01 | 55 | 3240 |  | 60 |  |  | 2.25
15241 | 2022-08-23 00:00:00 | 1 | 175310 | 10204964-01 | 27.5 | 7000 |  |  | 90 | 4 | 4
15241 | 2022-08-23 00:00:00 | 1 | 175310 |  |  |  |  |  | 120 | 3
15241 | 2022-08-23 00:00:00 | 2 | 176700 | 210478-01 | 19.8 | 7320 |  | 90 | 30 | 9 | 3.5
15241 | 2022-08-23 00:00:00 | 2 | 176700 | 10204964-01 | 27.5 | 2520 |  | 30 |  |  | 1.5
15241 | 2022-08-23 00:00:00 | 3 | 173600 | 210478-01 | 19.8 | 11700 |  |  | 60 | 27 | 6.5
15242 | 2022-08-23 00:00:00 | 1 | 13219 | 013202-01 | 110 | 3165 |  |  | 30 | 7 | 7
15242 | 2022-08-23 00:00:00 | 2 | 176211 | 013202-01 | 110 | 2000 |  |  | 210 | 11 | 4
15242 | 2022-08-23 00:00:00 | 3 | 171610 | 03372-01 | 55 | 680 |  | 60 | 210 | 24 | 1
15242 | 2022-08-23 00:00:00 | 3 | 171610 |  |  |  |  |  | 60 | 14
15242 | 2022-08-23 00:00:00 | 3 | 171610 | 013202-01 | 110 |  |  | 60
15221 | 2022-08-24 00:00:00 | 1 | 184311 | 310250-01 | 18.37 | 14000 |  |  | 120 | 3 | 5.5
15221 | 2022-08-24 00:00:00 | 2 | 13219 | 310250-01 | 18.37 | 11700 |  |  | 165 | 11 | 4.75
15221 | 2022-08-24 00:00:00 | 3 | 173512 | 310250-01 | 18.37 | 17700 |  |  |  |  | 7.5
15222 | 2022-08-24 00:00:00 | 1 | 184311 | 939581 | 27.5 | 4650 |  | 60 | 195 | 4 | 2.5
15222 | 2022-08-24 00:00:00 | 1 | 184311 | 390119-01 | 27.5 | 430 |  | 30 |  |  | 0.25
15222 | 2022-08-24 00:00:00 | 2 | 175212 | 939581 | 27.5 | 6350 |  |  | 240 | 23 | 3.5
15222 | 2022-08-24 00:00:00 | 3 | 13918 | 939581 | 27.5 | 1800 |  | 30 |  |  | 1.5
15222 | 2022-08-24 00:00:00 | 3 | 13918 | 10204973-01 | 13.75 | 18092 |  | 60 |  |  | 3.75
15222 | 2022-08-24 00:00:00 | 3 | 13918 | 27616-01 | 27.5 |  |  | 45
15223 | 2022-08-24 00:00:00 | 1 | 178811 | 29929-01 | 27.5 | 16580 |  |  | 90 | 11 | 6
15223 | 2022-08-24 00:00:00 | 2 | 293373 | 939703 | 27.5 | 7200 |  | 60 | 60 | 11 | 3.5
15223 | 2022-08-24 00:00:00 | 2 | 293373 | 29929-01 | 27.5 | 973 |  | 60 |  |  | 1
15223 | 2022-08-24 00:00:00 | 3 | 175200 | 939703 | 27.5 | 4900 |  | 90 | 150 | 11 | 2.5
15223 | 2022-08-24 00:00:00 | 3 | 175200 | 939703 | 27.5 |  |  |  | 60 | 14
15230 | 2022-08-24 00:00:00 | 1 | 293382 | 115128-01 | 55 | 3815 |  | 60 | 30 | 5 | 6
15230 | 2022-08-24 00:00:00 | 2 | 183900 | 214827-01 | 27.5 | 10260 |  | 75 |  |  | 6.25
15230 | 2022-08-24 00:00:00 | 3 | 293383 | 26935-01 | 16.5 |  |  | 60 | 60 | 11
15230 | 2022-08-24 00:00:00 | 3 | 293383 | 214827-01 | 27.5 | 9900 |  | 30 |  |  | 5
15241 | 2022-08-24 00:00:00 | 1 | 184312 | 210478-01 | 19.8 | 10240 |  |  | 120 | 12 | 5.5
15241 | 2022-08-24 00:00:00 | 2 | 175310 | 210478-01 | 19.8 | 14560 |  | 30 |  |  | 6.5
15241 | 2022-08-24 00:00:00 | 2 | 175310 | 938883 | 55 |  |  | 30
15241 | 2022-08-24 00:00:00 | 3 | 176700 | 938883 | 55 | 6350 |  | 30 | 30 | 9 | 5.5
15241 | 2022-08-24 00:00:00 | 3 | 176700 | 938883 | 55 |  |  |  | 60 | 11
15242 | 2022-08-24 00:00:00 | 1 | 293372 | 03372-01 | 55 | 2000 |  |  | 315 | 4 | 2.25
15242 | 2022-08-24 00:00:00 | 2 | 13219 | 03372-01 | 55 | 4630 |  |  | 45 | 11 | 6.75
15242 | 2022-08-24 00:00:00 | 3 | 176211 | 03372-01 | 55 | 4100 |  |  | 165 | 11 | 4.75
15221 | 2022-08-25 00:00:00 | 1 | 184311 | 938970 | 22 | 10000 |  | 90 |  |  | 5
15221 | 2022-08-25 00:00:00 | 1 | 184311 | 310250-01 | 18.37 | 1850 |  | 15 |  |  | 0.75
15221 | 2022-08-25 00:00:00 | 2 | 293373 | 938970 | 22 | 3708 |  | 45 |  |  | 1.75
15221 | 2022-08-25 00:00:00 | 2 | 13219 | 318127-01 | 12.375 | 12200 |  | 30 | 105 | 11 | 2.75
15221 | 2022-08-25 00:00:00 | 3 | 173512 | 318127-01 | 12.375 | 25300 |  |  | 30 | 26 | 7
15222 | 2022-08-25 00:00:00 | 1 | 184311 | 27616-01 | 27.5 | 12630 |  |  | 60 | 23 | 6.5
15222 | 2022-08-25 00:00:00 | 2 | 175212 | 27616-01 | 27.5 | 5560 |  |  | 60 | 23 | 3
15222 | 2022-08-25 00:00:00 | 2 | 175212 | 24413 | 22 |  |  | 45 | 165 | 23
15222 | 2022-08-25 00:00:00 | 3 | 13918 | 24413 | 22 | 4591 |  |  | 300 | 11 | 2.5
15223 | 2022-08-25 00:00:00 | 1 | 178811 | 939703 | 27.5 |  |  |  | 450 | 11
15223 | 2022-08-25 00:00:00 | 2 | 293373 | 939703 | 27.5 | 5660 |  |  | 210 | 20 | 4
15223 | 2022-08-25 00:00:00 | 3 | 175200 | 939703 | 27.5 | 6565 |  | 60 | 120 | 11 | 4.5
15230 | 2022-08-25 00:00:00 | 1 | 293382 | 26935-01 | 16.5 | 3260 |  |  | 390 | 12 | 1
15230 | 2022-08-25 00:00:00 | 2 | 183900 | 26935-01 | 16.5 | 10220 |  |  |  |  | 7.5
15230 | 2022-08-25 00:00:00 | 3 | 293383 | 26935-01 | 16.5 | 7700 |  |  | 60 | 2 | 4
15230 | 2022-08-25 00:00:00 | 3 | 293383 | 26935-01 | 16.5 |  |  |  | 60 | 4
15230 | 2022-08-25 00:00:00 | 3 | 293383 | 26935-01 | 16.5 |  |  |  | 90 | 11
15241 | 2022-08-25 00:00:00 | 1 | 184312 | 938883 | 55 | 3540 |  | 30 |  |  | 3.25
15241 | 2022-08-25 00:00:00 | 1 | 184312 | 10202734-01 | 44 |  |  | 60 | 165 | 9
15241 | 2022-08-25 00:00:00 | 2 | 175310 | 10202734-01 | 44 | 7750 |  |  | 45 | 9 | 6.75
15241 | 2022-08-25 00:00:00 | 3 | 176700 | 10202734-01 | 44 | 7800 |  |  |  |  | 7.5
15242 | 2022-08-25 00:00:00 | 1 | 293372 | 03372-01 | 55 | 5800 |  |  | 60 | 11 | 6.5
15242 | 2022-08-25 00:00:00 | 2 | 13219 | 03372-01 | 55 | 5810 |  |  | 30 | 12 | 7
15242 | 2022-08-25 00:00:00 | 3 | 176211 | 03372-01 | 55 | 6280 |  |  | 30 | 15 | 7
15221 | 2022-08-26 00:00:00 | 1 | 184311 | 318127-01 | 12.375 | 8300 |  |  | 240 | 11 | 3.5
15221 | 2022-08-26 00:00:00 | 2 | 293373 | 314066-01 | 12.375 | 10910 |  | 60 |  |  | 4
15221 | 2022-08-26 00:00:00 | 2 | 293373 | 318127-01 | 12.375 | 6269 |  | 30 |  |  | 2
15221 | 2022-08-26 00:00:00 | 3 | 173512 | 314066-01 | 12.375 | 4580 |  |  | 150 | 12 | 2
15221 | 2022-08-26 00:00:00 | 3 | 173512 |  |  |  |  |  | 180 | 5
15222 | 2022-08-26 00:00:00 | 1 | 184311 | 24413 | 22 | 1850 |  |  | 330 | 11 | 2
15222 | 2022-08-26 00:00:00 | 2 |  |  |  |  |  |  | 450 | 23
15222 | 2022-08-26 00:00:00 | 3 | 13918 | 938910 | 20 | 1381 |  | 30 | 240 | 11 | 1
15222 | 2022-08-26 00:00:00 | 3 | 13918 | 24413 | 22 | 2736 |  | 30 |  |  | 1.5
15223 | 2022-08-26 00:00:00 | 1 | 178811 | 939703 | 27.5 | 8000 |  |  | 240 | 11 | 3.5
15223 | 2022-08-26 00:00:00 | 2 | 293373 | 939703 | 27.5 | 8757 |  |  | 60 | 5 | 6.5
15223 | 2022-08-26 00:00:00 | 3 | 175200 | 939703 | 27.5 | 6000 |  | 60 | 180 | 11 | 3.5
15230 | 2022-08-26 00:00:00 | 1 | 293382 | 26935-01 | 16.5 | 2260 |  |  | 180 | 28 | 1.25
15230 | 2022-08-26 00:00:00 | 1 | 293382 |  |  |  |  |  | 195 | 23
15230 | 2022-08-26 00:00:00 | 2 | 183900 | 26935-01 | 16.5 | 9400 |  |  | 150 | 25 | 5
15230 | 2022-08-26 00:00:00 | 3 | 293383 | 214828-01 | 36.667 | 1690 |  | 45 | 60 | 8 | 1
15230 | 2022-08-26 00:00:00 | 3 | 293383 | 26935-01 | 16.5 | 7590 |  | 15 | 60 | 2 | 3.5
15241 | 2022-08-26 00:00:00 | 1 | 184312 | 10202734-01 | 44 | 6550 |  |  | 60 | 5 | 5.5
15241 | 2022-08-26 00:00:00 | 1 | 184312 | 10202734-01 | 44 |  |  |  | 60 | 14
15241 | 2022-08-26 00:00:00 | 2 | 175310 | 10202734-01 | 44 | 6040 |  |  | 150 | 3 | 5
15241 | 2022-08-26 00:00:00 | 3 | 176700 | 212686-01 | 22 | 4600 |  | 60 |  |  | 3
15241 | 2022-08-26 00:00:00 | 3 | 176700 | 10202734-01 | 44 | 1520 |  | 30 | 90 | 11 | 1.5
15242 | 2022-08-26 00:00:00 | 1 | 293372 | 03372-02 | 49.5 | 4365 |  |  | 120 | 6 | 3.5
15242 | 2022-08-26 00:00:00 | 1 | 293372 | 03372-01 | 55 | 1985 |  |  |  |  | 2
15242 | 2022-08-26 00:00:00 | 2 | 13219 | 017639-01 | 73.333 | 128 |  | 60 | 15 | 11 | 0.25
15242 | 2022-08-26 00:00:00 | 2 | 13219 | 03372-02 | 49.5 | 4670 |  | 30 |  |  | 5.5
15242 | 2022-08-26 00:00:00 | 3 | 176211 | 017639-01 | 73.333 | 3180 |  |  | 90 | 12 | 6
15221 | 2022-08-27 00:00:00 | 1 |  |  |  |  |  |  | 450 | 25
15221 | 2022-08-27 00:00:00 | 2 |  |  |  |  |  |  | 450 | 25
15222 | 2022-08-27 00:00:00 | 1 |  |  |  |  |  |  | 450 | 23
15222 | 2022-08-27 00:00:00 | 2 | 293373 | 939168 | 9.167 |  |  | 60
15222 | 2022-08-27 00:00:00 | 2 | 293373 | 938910 | 20 | 6397 |  | 30 |  |  | 6
15223 | 2022-08-27 00:00:00 | 1 |  |  |  |  |  |  | 450 | 23
15223 | 2022-08-27 00:00:00 | 2 | 293373 | 939703 | 27.5 | 8550 |  | 30 | 30 | 11 | 6
15230 | 2022-08-27 00:00:00 | 1 | 293382 | 214828-01 | 36.667 | 5720 |  |  | 240 | 8 | 3.5
15230 | 2022-08-27 00:00:00 | 2 | 183900 | 214828-01 | 36.667 | 5620 |  |  |  |  | 5
15230 | 2022-08-27 00:00:00 | 2 | 293200 | 214828-01 | 36.667 | 3880 |  |  |  |  | 2.5
15241 | 2022-08-27 00:00:00 | 1 | 184311 | 212686-01 | 22 | 7160 |  | 30 | 120 | 25 | 5
15241 | 2022-08-27 00:00:00 | 2 | 175310 | 30516/17 | 11 | 9760 | 9760 | 60 | 90 | 9 | 4.5
15241 | 2022-08-27 00:00:00 | 2 | 175310 | 116376-01 | 55 |  |  | 30
15242 | 2022-08-27 00:00:00 | 1 | 293372 | 017639-01 | 73.333 | 2985 |  | 45 |  |  | 5.75
15242 | 2022-08-27 00:00:00 | 1 | 293372 | 012960-01 | 91.667 |  |  | 60
15242 | 2022-08-27 00:00:00 | 2 | 13219 | 012960-01 | 91.667 | 1965 |  | 30 | 150 | 11 | 4.5
15221 | 2022-08-28 00:00:00 | 3 |  |  |  |  |  |  | 450 | 25
15222 | 2022-08-28 00:00:00 | 3 | 184311 | 939168 | 9.167 | 2365 |  | 120 | 30 | 25 | 3
15222 | 2022-08-28 00:00:00 | 3 | 184311 | 214799-02 | 18.333 |  |  | 30 | 90 | 4
15223 | 2022-08-28 00:00:00 | 3 | 178811 | 10219225-01 | 13.75 | 8600 |  | 75 |  |  | 2.25
15223 | 2022-08-28 00:00:00 | 3 | 178811 | 10204969/70-01 | 13.75 | 7270 | 7270 | 30 | 30 | 15 | 3
15230 | 2022-08-28 00:00:00 | 3 | 293382 | 214828-01 | 36.667 | 6855 |  |  | 75 | 20 | 5.25
15230 | 2022-08-28 00:00:00 | 3 | 293382 | 214828-01 | 36.667 |  |  |  | 60 | 3
15241 | 2022-08-28 00:00:00 | 3 | 176500 | 116376-01 | 55 | 3590 |  | 135 | 105 | 9 | 3.5
15242 | 2022-08-28 00:00:00 | 3 | 293372 | 012960-01 | 91.667 | 2855 |  | 60 |  |  | 6.5