Spreadsheet: 100023d1298508869-running-metrics-running-metrics-02-23-11
Sheet: Manufacturing Imperfections

 |  |  |  |  | ENGINE LINE | JT8D - 2nd
 |  |  |  |  |  | (Pick Engine & Stage)
 |  |  |  |  |  | Report Date:
 |  |  |  |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  | Control Chart for Rejects
 |  |  |  |  |  | Dept:
 |  |  |  |  |  | Equipment ID:
 |  |  |  |  |  | Start date: |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  |  |  | End date: |  |  |  |  | 2011-12-31 00:00:00
 |  |  |  |  |  | Desired level |  |  |  |  | 0.9
 | YTD Cumulative Totals As of: |  | 2011-02-23 00:00:00 |  |  | FW  8
 |  |  |  | Number of Imperfections |  |  |  |  |  |  |  |  |  |  | Mean (Daily Average) | Sample Mean (Average of All Means) | Standard Deviation | Sample Standard Deviation | Lower Control Limit | Upper Control Limit
 | Beg. Of Week | End of Week | FW | COATING | HANDLING DAMAGE | INCLUSIONS | MACHINING | WELDING | WELDING | ?? |  |  |  | Total Defects Per Week
 | 2011-01-03 00:00:00 | 2011-01-09 00:00:00 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-01-10 00:00:00 | 2011-01-16 00:00:00 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-01-17 00:00:00 | 2011-01-23 00:00:00 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-01-24 00:00:00 | 2011-01-30 00:00:00 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-01-31 00:00:00 | 2011-02-06 00:00:00 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-02-07 00:00:00 | 2011-02-13 00:00:00 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-02-14 00:00:00 | 2011-02-20 00:00:00 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 12.61538461538461 | 0 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-02-21 00:00:00 | 2011-02-27 00:00:00 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-02-28 00:00:00 | 2011-03-06 00:00:00 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-03-07 00:00:00 | 2011-03-13 00:00:00 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-03-14 00:00:00 | 2011-03-20 00:00:00 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-03-21 00:00:00 | 2011-03-27 00:00:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-03-28 00:00:00 | 2011-04-03 00:00:00 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-04-04 00:00:00 | 2011-04-10 00:00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-04-11 00:00:00 | 2011-04-17 00:00:00 | 15 | 1 | 5 | 4 |  |  |  |  | 1 |  |  | 11 | 2.75 | 0 | 2.06155281280883 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-04-18 00:00:00 | 2011-04-24 00:00:00 | 16 | 4 | 0 | 3 |  |  |  |  | 2 |  |  | 9 | 2.25 | 0 | 1.707825127659933 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-04-25 00:00:00 | 2011-05-01 00:00:00 | 17 | 3 | 4 | 1 |  |  |  |  | 2 |  |  | 10 | 2.5 | 0 | 1.290994448735806 | 1.395113304990061 | -1.255601974491055 | 1.255601974491055
 | 2011-05-02 00:00:00 | 2011-05-08 00:00:00 | 18 | 1 | 4 | 0 |  |  |  |  | 5 |  |  | 10 | 2.5 | 12.61538461538461 | 2.380476142847617 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-05-09 00:00:00 | 2011-05-15 00:00:00 | 19 | 4 | 4 | 0 |  |  |  |  | 2 |  |  | 10 | 2.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-05-16 00:00:00 | 2011-05-22 00:00:00 | 20 | 5 | 5 | 1 |  |  |  |  | 3 |  |  | 14 | 3.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-05-23 00:00:00 | 2011-05-29 00:00:00 | 21 | 6 | 6 | 2 |  |  |  |  | 4 |  |  | 18 | 4.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-05-30 00:00:00 | 2011-06-05 00:00:00 | 22 | 7 | 7 | 3 |  |  |  |  | 5 |  |  | 22 | 5.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-06-06 00:00:00 | 2011-06-12 00:00:00 | 23 | 8 | 8 | 4 |  |  |  |  | 6 |  |  | 26 | 6.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-06-13 00:00:00 | 2011-06-19 00:00:00 | 24 | 9 | 9 | 5 |  |  |  |  | 7 |  |  | 30 | 7.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-06-20 00:00:00 | 2011-06-26 00:00:00 | 25 | 10 | 10 | 6 |  |  |  |  | 8 |  |  | 34 | 8.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-06-27 00:00:00 | 2011-07-03 00:00:00 | 26 | 11 | 11 | 7 |  |  |  |  | 9 |  |  | 38 | 9.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-07-04 00:00:00 | 2011-07-10 00:00:00 | 27 | 12 | 12 | 8 |  |  |  |  | 10 |  |  | 42 | 10.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-07-11 00:00:00 | 2011-07-17 00:00:00 | 28 | 13 | 13 | 9 |  |  |  |  | 11 |  |  | 46 | 11.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-07-18 00:00:00 | 2011-07-24 00:00:00 | 29 | 14 | 14 | 10 |  |  |  |  | 12 |  |  | 50 | 12.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-07-25 00:00:00 | 2011-07-31 00:00:00 | 30 | 15 | 15 | 11 |  |  |  |  | 13 |  |  | 54 | 13.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-08-01 00:00:00 | 2011-08-07 00:00:00 | 31 | 16 | 16 | 12 |  |  |  |  | 14 |  |  | 58 | 14.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-08-08 00:00:00 | 2011-08-14 00:00:00 | 32 | 17 | 17 | 13 |  |  |  |  | 15 |  |  | 62 | 15.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-08-15 00:00:00 | 2011-08-21 00:00:00 | 33 | 18 | 18 | 14 |  |  |  |  | 16 |  |  | 66 | 16.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-08-22 00:00:00 | 2011-08-28 00:00:00 | 34 | 19 | 19 | 15 |  |  |  |  | 17 |  |  | 70 | 17.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-08-29 00:00:00 | 2011-09-04 00:00:00 | 35 | 20 | 20 | 16 |  |  |  |  | 18 |  |  | 74 | 18.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-09-05 00:00:00 | 2011-09-11 00:00:00 | 36 | 21 | 21 | 17 |  |  |  |  | 19 |  |  | 78 | 19.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-09-12 00:00:00 | 2011-09-18 00:00:00 | 37 | 22 | 22 | 18 |  |  |  |  | 20 |  |  | 82 | 20.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-09-19 00:00:00 | 2011-09-25 00:00:00 | 38 | 23 | 23 | 19 |  |  |  |  | 21 |  |  | 86 | 21.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-09-26 00:00:00 | 2011-10-02 00:00:00 | 39 | 24 | 24 | 20 |  |  |  |  | 22 |  |  | 90 | 22.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-10-03 00:00:00 | 2011-10-09 00:00:00 | 40 | 25 | 25 | 21 |  |  |  |  | 23 |  |  | 94 | 23.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-10-10 00:00:00 | 2011-10-16 00:00:00 | 41 | 26 | 26 | 22 |  |  |  |  | 24 |  |  | 98 | 24.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-10-17 00:00:00 | 2011-10-23 00:00:00 | 42 | 27 | 27 | 23 |  |  |  |  | 25 |  |  | 102 | 25.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-10-24 00:00:00 | 2011-10-30 00:00:00 | 43 | 28 | 28 | 24 |  |  |  |  | 26 |  |  | 106 | 26.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-10-31 00:00:00 | 2011-11-06 00:00:00 | 44 | 29 | 29 | 25 |  |  |  |  | 27 |  |  | 110 | 27.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-11-07 00:00:00 | 2011-11-13 00:00:00 | 45 | 30 | 30 | 26 |  |  |  |  | 28 |  |  | 114 | 28.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-11-14 00:00:00 | 2011-11-20 00:00:00 | 46 | 31 | 31 | 27 |  |  |  |  | 29 |  |  | 118 | 29.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-11-21 00:00:00 | 2011-11-27 00:00:00 | 47 | 32 | 32 | 28 |  |  |  |  | 30 |  |  | 122 | 30.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-11-28 00:00:00 | 2011-12-04 00:00:00 | 48 | 33 | 33 | 29 |  |  |  |  | 31 |  |  | 126 | 31.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-12-05 00:00:00 | 2011-12-11 00:00:00 | 49 | 34 | 34 | 30 |  |  |  |  | 32 |  |  | 130 | 32.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-12-12 00:00:00 | 2011-12-18 00:00:00 | 50 | 35 | 35 | 31 |  |  |  |  | 33 |  |  | 134 | 33.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-12-19 00:00:00 | 2011-12-25 00:00:00 | 51 | 36 | 36 | 32 |  |  |  |  | 34 |  |  | 138 | 34.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567
 | 2011-12-26 00:00:00 | 2012-01-01 00:00:00 | 52 | 37 | 37 | 33 |  |  |  |  | 35 |  |  | 142 | 35.5 | 12.61538461538461 | 1.914854215512676 | 1.395113304990061 | 11.35978264089356 | 13.87098658987567