Spreadsheet: 389823d1429292059-count-issue-book2
Sheet: Data

Date |  | Part Number | Budgeted Production Line |  |  |  |  |  | Shift 1 |  |  |  |  | 0 | Shift 2 |  |  |  |  | 1 | Shift 3
 |  |  |  |  |  |  |  |  | Pieces | Sched | Uptime |  | PPRM | 0 | Pieces | Sched | Uptime |  | PPRM |  | Pieces | Sched | Uptime |  | PPRM
 |  |  |  |  |  |  |  |  | Produced | Hours | Hours | Minute |  | 0 | Produced | Hours | Hours | Minute |  |  | Produced | Hours | Hours | Minute
Data | Week | Part Number | Line | Pieces produced | Same | Same2 |  |  |  |  |  |  |  | 0
2014-12-17 00:00:00 | 51 | 110 | 1 | 3031 |  | 3031 |  | 1 | 3031 | 6.5 | 2 | 26 | 20.76027397260274 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
2014-06-09 00:00:00 | 24 | 114 | 4 | 5430 |  | 5430 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 5430 | 7 | 2 | 6 | 43.09523809523809 |  | 0 | 0 | 0 | 0 | 0
2014-11-04 00:00:00 | 45 | 114 | 4 | 4000 |  | 4000 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 4000 | 4 | 1 | 42 | 39.21568627450981
2014-06-25 00:00:00 | 26 | 127 | 1 | 740 |  | 740 |  | 1 | 425 | 1.75 | 0 | 40 | 10.625 | 2 | 315 | 0.67 | 0 | 9 | 35 |  | 0 | 0 | 0 | 0 | 0
2014-07-17 00:00:00 | 29 | 127 | 1 | 4703 |  | 4703 |  | 1 | 940 | 3.5 | 0 | 36 | 26.11111111111111 | 2 | 3763 | 8 | 1 | 48 | 34.8425925925926 |  | 0 | 0 | 0 | 0 | 0
2014-08-26 00:00:00 | 35 | 127 | 1 | 4307 |  | 4307 |  | 1 | 4307 | 7 | 1 | 54 | 37.78070175438597 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
2014-09-21 00:00:00 | 38 | 127 | 1 | 4049 |  | 4049 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 4049 | 5.75 | 2 | 32 | 26.63815789473684 |  | 0 | 0 | 0 | 0 | 0
2014-10-08 00:00:00 | 41 | 127 | 1 | 4485 |  | 4485 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 4485 | 4 | 2 | 45 | 27.18181818181818 |  | 0 | 0 | 0 | 0 | 0
2014-10-25 00:00:00 | 43 | 127 | 1 | 3700 |  | 3700 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 3700 | 4.5 | 1 | 46 | 34.90566037735849
2014-10-26 00:00:00 | 43 | 127 | 1 | 623 | A |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 623 | 0.75 | 0 | 18 | 34.61111111111111
2014-11-12 00:00:00 | 46 | 127 | 1 | 6682 |  | 6682 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 6682 | 8 | 3 | 54 | 28.55555555555556
2014-11-13 00:00:00 | 46 | 127 | 1 | 623 | A |  |  | 1 | 623 | 0.75 | 0 | 18 | 34.61111111111111 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
2014-11-22 00:00:00 | 47 | 127 | 1 | 4626 |  | 4626 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 4626 | 4 | 2 | 32 | 30.43421052631579
2014-12-06 00:00:00 | 49 | 127 | 1 | 4735 |  | 4735 |  | 1 | 1580 | 4.5 | 1 | 30 | 17.55555555555556 | 2 | 3155 | 3.75 | 1 | 30 | 35.05555555555556 |  | 0 | 0 | 0 | 0 | 0
2014-12-20 00:00:00 | 51 | 127 | 1 | 4751 |  | 4751 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 4751 | 6 | 3 | 23 | 23.40394088669951
2014-05-02 00:00:00 | 18 | 160 | 1 | 2047 |  | 2047 |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 800 | 2 | 0 | 45 | 17.77777777777778 | 3 | 1247 | 4 | 1 | 23 | 15.02409638554217
2014-05-03 00:00:00 | 18 | 160 | 1 | 5110 | A |  |  |  | 0 | 0 | 0 | 0 | 0 | 2 | 3184 | 8 | 3 | 18 | 16.08080808080808 | 3 | 1926 | 4 | 1 | 59 | 16.18487394957983
2014-05-05 00:00:00 | 19 | 160 | 1 | 3113 |  | 3113 |  | 1 | 3113 | 8 | 3 | 14.6 | 15.99691675231244 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
2014-05-08 00:00:00 | 19 | 160 | 1 | 9283 | A |  |  | 1 | 6040 | 8 | 5 | 30 | 18.3030303030303 | 2 | 3243 | 8 | 1 | 47.5 | 30.16744186046512 |  | 0 | 0 | 0 | 0 | 0
2014-05-15 00:00:00 | 20 | 160 | 1 | 3616 |  | 3616 |  | 1 | 3616 | 7.5 | 3 | 15 | 18.54358974358975 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
2014-05-21 00:00:00 | 21 | 160 | 1 | 1742 |  | 1742 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 1742 | 6 | 1 | 40 | 17.42