Spreadsheet: 540483d1506708735-need-help-with-this-formula-production
Sheet: Sheet1

AMI Day x Hour Data |  |  |  |  |  |  |  |  |  |  | Breaks | Waiting on setup to arrive | [NAME] | Welder Time Adjusting | Collet time to change | Operator job change over | Burst & Leak | Retainers | Collet | O-Ring | Refill of Bins | Maintenance | Packing | [NAME] | No Op | [NAME] | [NAME] sort | Other
Date | Clock # | Shift | Machine | Part # | Target pcs | Actual pcs | % Efficient | Downtime (minutes) | Code (MAJORITY) | Comments | 1 | 2 | 2A | 2B | 2C | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | [NAME] | Reason 1 | Reason 2 | Reason 3 | Reason 4
2017-09-13 00:00:00 |  | 3 | [NAME] | LFPP6VUCPB6 | 350 | 462
2017-09-13 00:00:00 |  | 3 | [NAME] | LFPP6VUC6
2017-09-13 00:00:00 |  | 1 | [NAME] | LFPP6VUC6 | 150 | 170
2017-09-13 00:00:00 |  | 1 | [NAME] | PP6VMC4-MG | 575 | 497 |  |  | 4 |  | 10 |  |  |  |  | 15 | 20
2017-09-13 00:00:00 |  | 3 | DIAL-X | A6TEU4-MG | 2400 | 2330 |  |  | 3 |  |  | 15 |  |  |  | 15
2017-09-13 00:00:00 |  | 3 | DIAL-X | A6EU4-MG |  |  |  |  | 9 |  |  | 40 |  |  |  |  |  |  |  |  |  | 40
2017-09-13 00:00:00 | 1791 | 2 | AMI | BCA8UC8 | 5271 | 5026 |  |  | 2A |  | 30 |  | 25 |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 10 | 5
2017-09-14 00:00:00 | 1802 | 3 | AMI | BCA8UC8 | 6010 | 5922 |  |  | 4 |  |  |  |  |  |  |  | 15 |  |  |  |  | 15 | 15
2017-09-14 00:00:00 | 1755 | 1 | AMI | BCA8UC8 | 4533 | 4617 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 15
2017-09-14 00:00:00 |  | 2 | AMI | A8TU8-MG | 800 | 669 |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | 10
2017-09-14 00:00:00 |  | 3 | CLACK | LFPP6CLACK | 6010 | 5207 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  | 10 | 10
2017-09-14 00:00:00 | 1762 | 1 | CLACK | LFPP6CLACK | 6010 | 5500
2017-09-15 00:00:00 |  | 3 | AMI | A8TU8-MG | 3733 | 3905 |  |  | 4 |  |  |  |  |  |  | 15 | 35
2017-09-15 00:00:00 | 1802 | 3 | AMI | A8MC8-MG |  |  |  |  | 2 |  |  | 20
2017-09-15 00:00:00 | 1255 | 1 | AMI | A4FE4MG-WRAS | 1600 | 1646
2017-09-15 00:00:00 | 1768 | 1 | [NAME] | PP6VMC4-MG | 1100 | 1128
2017-09-15 00:00:00 | 1801 | 2 | [NAME] | PP6VMC4-MG | 1100 | 1100
2017-09-15 00:00:00 |  | 3 | CLACK | LFPP6CLACK | 667 | 710
2017-09-18 00:00:00 |  | 3 | [NAME] | PP6VMC4-MG | 675 | 567 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  | 20
2017-09-18 00:00:00 | 1801 | 2 | [NAME] | A4VC4-MG | 3200 | 3121 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  | 15
2017-09-18 00:00:00 |  | 3 | CLACK | LFPP6CLACK | 2800 | 2000 |  |  | 8 |  | 10 |  |  |  |  |  | 15 |  |  |  | 45
2017-09-19 00:00:00 | 1755 | 3 | CLACK | LFPP6CLACK | 2000 | 1513 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
2017-09-19 00:00:00 |  | 1 | CLACK | LFPP6CLACK | 3067 | 2460 |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 25
2017-09-19 00:00:00 |  | 2 | CLACK | LFPP6CLACK | 5886 | 6096 |  |  | 1 |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10
2017-09-19 00:00:00 | 1762 | 1 | [NAME] | PP6VMC4-MG | 575 | 780
2017-09-19 00:00:00 | 1762 | 1 | [NAME] | LFPP5VMC4 |  |  |  |  | 1 |  | 20
2017-09-19 00:00:00 | 1769 | 2 | [NAME] | LFPP4VMC4 | 600 | 570
2017-09-19 00:00:00 | 1802 | 3 | AMI | A6EU4-MG | 3610 | 4301 |  |  | 2 |  |  | 30 |  |  |  | 20
2017-09-19 00:00:00 | 1801 | 2 | AMI | A4VC4-MG | 800 | 938
2017-09-19 00:00:00 | 1801 | 2 | AMI | PP4FC4 |  |  |  |  | 4 |  |  |  |  |  |  |  | 10 | 10
2017-09-19 00:00:00 | 1781 | 3 | DIAL-X | A6TEU4-MG | 5887 | 5218 |  |  | 15 |  |  |  |  | 10 |  | 20 |  |  |  |  |  |  |  |  |  |  |  | 50
2017-09-19 00:00:00 | 1755 | 1 | DIAL-X | A6MC8-MG | 3077 | 2540 |  |  |  |  | 10 |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  | 15
2017-09-19 00:00:00 | 1755 | 1 | DIAL-X | A6EU4-MG |  |  |  |  | 15 |  |  |  |  |  |  | 15 | 10 |  |  |  |  |  |  |  |  |  |  | 15
2017-09-19 00:00:00 | 1797 | 2 | DIAL-X | A6UC4-MG | 3077 | 3219