Spreadsheet: 551348d1512866637-issue-with-reconciliation-when-averaging-weekly-variances-and-ytd-variances-copy-of-line-turn-test-cvmiller39-
Sheet: Bravo

Line | Week | Lot Code | Product | Lot Size | Last Shipper of Previous Lot | First Shipper | Elapsed Time | Type | Comment | [NAME] | [NAME] | Lit Size | P/O |  |  |  |  | Packaging Line Turn Standards
Bravo | 44 | 281483F |  | 79000 | 18:15:00 | 19:35:00 |  | No Change |  | 15ML | G | 6 | 6 |  |  |  |  | Line B | No Change (A) | Bottle or [NAME] (B) | [NAME] (C) | Lit Change (D) | Serialization (E) | Serialization + Change (F)
Bravo | 44 | 283527F |  | 90000 | 00:25:00 | 03:10:00 |  | Bottle or Carton | Lit stuck in roller.  [NAME] changeover | 15ML | F | N/A | 6 |  |  |  |  |  | 01:50:00 | 02:20:00 | 02:40:00 | 02:00:00 | 02:15:00 | 03:05:00
 | 44 | 280152F |  | 48000 | 16:30:00 | 21:42:00 |  | Bottle or Carton |  | 8ML | F | N/A | 6
 | 44 | 287193F |  | 20000 | 15:48:00 | 17:15:00 |  | No Change |  | 8ML | F | N/A | 6
 | 44 | 285027F |  |  | 19:59:00 | 23:35:00 |  |  | Shift change.  Changeover issues |  |  |  |  |  |  |  |  | Reporting Week | No Change | Bottle or Carton | [NAME] | Lit Change | Serialization | Serialization + Change
 | 44 | 285028F |  |  | 09:21:00 | 10:35:00 |  |  |  |  |  |  |  |  |  |  |  | 47
 | 45 | 291054F |  |  | 02:28:00 | 04:02:00 |  | No Change |  |  |  |  |  |  |  |  |  | Weekly # of Turns
 | 45 | 285022F |  |  | 08:30:00 | 16:28:00 |  | Bottle or Carton | [NAME] |  |  |  |  |  |  |  |  | Weekly Average
 | 45 | 290001F |  |  | 04:22:00 | 08:13:00 |  | Bottle or Carton | [NAME] to regular; F to E; 6 pack to 12 pack |  |  |  |  |  |  |  |  | YTD # of Turns
 | 45 | 287902F |  |  | 09:25:00 | 10:45:00 |  | Lit Change |  |  |  |  |  |  |  |  |  | YTD Average
 | 45 | 289420F |  |  | 12:15:00 | 15:30:00 |  | Serialization + Change | (written as C/F) and Lit |  |  |  |  |  |  |  |  | Target
 | 45 | 290027F |  |  | 18:55:00 | 21:27:00 |  | No Change |  |  |  |  |  |  |  |  |  | Weekly [NAME] (min)
 | 45 | 289204F |  |  | 22:24:00 | 1900-01-01 00:38:00 |  | Serialization | 10" to 12" lit; regular to serialization |  |  |  |  |  |  |  |  | YTD Variance (min)
 | 45 | 287874F |  |  | 01:48:00 | 03:42:00 |  | Serialization + Change | serialization to reg; B to D carton; 12" to 10" lit; 8ml to 10ml; casepacker changeover
 | 45 | 287875F |  |  | 11:10:00 | 13:09:00 |  | No Change | During break; staffing |  |  |  |  |  |  |  |  | Weekly Conversion
 | 45 | 289294F |  |  | 19:25:00 | 1900-01-01 01:59:00 |  | [NAME] | D to C; 6 to 10" lit |  |  |  |  |  |  |  |  | Yearly Conversion
 | 45 | 288341F |  |  | 05:47:00 | 20:20:00 |  |  | Line dark 1430 to 2000 |  |  |  |  |  |  |  |  | Weekly Average (decimal) |  |  | YTD Average (decimal)
 | 45 | 287727F |  |  | 15:25:00 | 17:06:00 |  | No Change |  |  |  |  |  |  |  |  |  | Weekly Average (time) |  |  | YTD Average (time)
 | 45 | 285126F |  |  | 18:00:00 | 19:17:00 |  | Lit Change
 | 45 | 284425F |  |  | 19:51:00 | 21:26:00 |  | No Change |  |  |  |  |  |  |  |  |  | Weekly # of Turns |  |  | YTD # of Turns
 | 46 | 283528F |  |  | 08:00:00 | 11:00:00 |  | [NAME] | C/O start up adjustments |  |  |  |  |  |  |  |  | Weekly [NAME] (min) |  |  | YTD Variance (min)
 | 46 | 289847F |  |  | 00:38:00 | 02:51:00 |  | [NAME] | F to G carton; change to 6" lit; [NAME] to regular
 | 46 | 285071F |  |  | 15:57:00 | 17:45:00 |  | No Change
 | 46 | 290463F |  |  | 23:20:00 | 1900-01-01 00:50:00 |  | No Change |  |  |  |  |  |  |  |  | Turns
 | 47 | 284864F |  |  | 11:50:00 | 13:40:00 |  | No Change |  |  |  |  |  |  |  |  | 4 | 44 | 0.02500000000000002
 | 47 | 282059F |  |  | 18:27:00 | 21:03:00 |  |  |  |  |  |  |  |  |  |  | 13 | 45 | 0.02825854700854701
 | 47 | 286423F |  |  | 23:46:00 | 1 day, 2:41:00 |  | Bottle or Carton | D to G carton; 10" to 6"; 12 to 6 pack |  |  |  |  |  |  |  | 4 | 46 | -0.005034722222222232
 | 47 | 288396F |  |  | 06:20:00 | 07:55:00 |  | No Change |  |  |  |  |  |  |  |  | 5 | 47 | 0.01597222222222221
 | 47 | 290073F |  |  | 08:25:00 | 10:50:00 |  | Bottle or Carton | Wait on mechanics (45 min)/ tune in |  |  |  |  |  |  |  |  | average
 | 47 | 285029F |  |  | 19:30:00 | 23:20:00 |  | Bottle or Carton |  |  |  |  |  |  |  |  |  |  |  | avg check from weekly data