Spreadsheet: 821585d1678806218-copying-max-min-not-following-cell-selection-pattern-protein-tests-for-forum
Sheet: Washer 9

 |  |  |  |  |  |  |  |  |  | Individuals Chart |  |  |  |  | MR Chart |  |  |  | Xbar-R Chart |  |  |  |  |  |  | R Chart
WASHER 9 | Date | Residual  Protein (μm) | Pass/Fail | Pass Rate | Chamber Location | Test Carried Out By | Instrument | Cycle | Comments | Data | Xbar | LCL | UCL |  | Data | MRbar | LCL | UCL | Data | Batch | Xbar |  | Centre | LCL | UCL | R | Centre | LCL | UCL
 | 2017-05-08 00:00:00 | 0.52 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2017-05-09 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 2017-05-10 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 2017-05-11 00:00:00 | 0.8 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | 2017-05-12 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 2017-05-15 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 2017-05-16 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 2017-05-17 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 2017-05-18 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 2017-05-19 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 2017-05-22 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 2017-05-23 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | 2017-05-24 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 | 2017-05-25 00:00:00 | 4.1 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | 2017-05-26 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | 2017-05-29 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | 2017-05-30 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | 2017-05-31 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | 2017-06-01 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 | 2017-06-02 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 2017-06-05 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 | 2017-06-06 00:00:00 | 16.7 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | 2017-06-07 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
 | 2017-06-08 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 | 2017-06-09 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 | 2017-06-12 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 | 2017-06-13 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 | 2017-06-14 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 | 2017-06-15 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 | 2017-06-16 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | 2017-06-19 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 | 2017-06-20 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 | 2017-06-21 00:00:00 | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 | 2017-06-22 00:00:00 | 0 |  | 5
 | 2017-06-23 00:00:00 | 0 |  | 5
 | 2017-06-26 00:00:00 | 0 |  | 5
 | 2017-06-27 00:00:00 | 0 |  | 5
 | 2017-06-28 00:00:00 | 0.6 |  | 5
 | 2017-06-29 00:00:00 | 0 |  | 5
 | 2017-06-30 00:00:00 | 0 |  | 5
 | 2017-07-03 00:00:00 | 0 |  | 5
 | 2017-07-04 00:00:00 | 0 |  | 5
 | 2017-07-05 00:00:00 | 0 |  | 5
 | 2017-07-06 00:00:00 | 0 |  | 5
 | 2017-07-29 00:00:00 | 0 |  | 5
 | 2017-08-01 00:00:00 | 2.3 |  | 5
 | 2017-08-03 00:00:00 | 0 |  | 5