Spreadsheet: 453959d1459536214-conditional-formatting-formulas-for-alphanumeric-codes-in-other-cells-copy-of-2016-sample-data
Sheet: TABLE

2016 Concrete Test Data on All Mixes
Mix ID | Cast Date | Date Received | Customer | Project | Test Lab | Lab ID | Ticket No | Slump | Air | Temp | Plant | Field Tester | Target Strength | [NAME] |  |  |  |  |  | 28 day AVG | 28 day range | [NAME] | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 day | 7 day | 28 day | 28 day | 28 day | 56 day
 |  |  |  |  |  |  |  | [NAME] | % | deg C |  |  |  | MPa | MPa | MPa | MPa | MPa | MPa | MPa | MPa
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10.0 | 11.0 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
30A21FP | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | C5TORIND |  | WGS |  |  | 80 | 4 | 19 | 3810 | CW | 30 | - | 19.9 | 31.9 | 31.4 | - | 33.7 |  |  | CW
30A21FP | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | C5TORIND |  | WGS |  |  | 90 | 3.8 | 12 | 3810 | CW | 30 | - | 24.4 | 44.4 | 44.3 | - | 50 |  |  | CW
30A21FP | 2016-01-08 00:00:00 | 2016-01-11 00:00:00 | C5TORIND |  | WGS |  |  | 150 SP | 5.8 | 13 | 3810 | CW | 30 | - | 20.7 | 32 | 32.9 | - | 38.6 |  |  | CW
30A21FW | 2016-01-12 00:00:00 | 2016-01-14 00:00:00 | C5TORIND |  | WGS |  |  | 160 SP | 9.5 | 12 | 3810 | CW | 30 | - | 19.8 | 26.1 | 28.9 | - | 31.3 |  |  | CW
30A21FW | 2016-01-12 00:00:00 | 2016-01-14 00:00:00 | C5TORIND |  | WGS |  |  | 150 SP | 11 | 12 | 3810 | CW | 30 | - | 16.8 | 25.6 | 25 | - | 29.3 |  |  | CW
25N12BF | 2016-01-21 00:00:00 | 2016-01-22 00:00:00 | C5CAMCON |  | Parkland Geo | GP3050-1 |  | 210 SP | NA | 10 | 3810 | IT | 25 | - | 16.8 | 25.7 | 27.1 | - | - |  |  | -
30A21FW | 2016-01-28 00:00:00 | 2016-01-30 00:00:00 | C5KAYCON |  | Parkland Geo | GP3094-1 |  | 110 | 5.5 | 13 | 3810 | DC | 30 | - | 23.9 | 34.4 | 34.2 | - | - |  |  | -
30A21FW | 2016-01-28 00:00:00 | 2016-01-30 00:00:00 | C5KAYCON |  | WGS |  |  | 90 | 5.2 | 14 | 3810 | CW | 30 | - | 25.9 | 38.2 | 35.9 | - | 40.8 |  |  | CW
30A21FW | 2015-01-28 00:00:00 | 2016-01-30 00:00:00 | C5KAYCON |  | Parkland Geo | GP3094-2 |  | 110 | 5.5 | 12 | 3810 | DC | 30 | - | 22.4 | 32.8 | 33.4 | - | - |  |  | -
30A21FW | 2016-01-28 00:00:00 | 2016-01-30 00:00:00 | C5KAYCON |  | WGS |  |  | 130 | 5.6 | 11 | 3810 | CW | 30 | - | 21.6 | 30.4 | 33.6 | - | 41.7 |  |  | CW
30A21FW | 2016-02-02 00:00:00 | 2016-02-04 00:00:00 | C5KAYCON |  | Parkland Geo | GP3094-3 |  | 105 | 4.5 | 10 | 3810 | DC | 30 | - | 26.3 | 39.4 | 40.1 | - | - |  |  | -
30A21FW | 2016-02-02 00:00:00 | 2016-02-05 00:00:00 | C5KAYCON |  | WGS |  |  | 110 | 4.6 | 8 | 3810 | CW | 30 | - | 24 | 35.8 | 37.4 | - | 39.5 |  |  | CW
30N21IF | 2016-02-18 00:00:00 | 2016-02-19 00:00:00 | PLC |  | Parkland Geo | GP3066-3 |  | 30/65 | 1.6 | 17 | 3810 | IT | 30 | - | 32.8 | 46.6 | 46.8 | - | - |  |  | -
30N21IF | 2016-02-18 00:00:00 | 2016-02-19 00:00:00 | C5TORIND |  | WGS |  |  | 100 | NA | 12 | 3810 | CW | 30 | - | 30.4 | 40.6 | 43.6 | - |  |  |  | CW
30N21IF | 2016-02-18 00:00:00 | 2016-02-19 00:00:00 | C5TORIND |  | WGS |  |  | 120 SP | NA | 10 | 3810 | CW | 30 | - | 27.2 | 40.6 | 38.8 | - |  |  |  | CW
30A21FW | 2016-02-29 00:00:00 | 2016-03-01 00:00:00 | PLC |  | Parkland Geo | GP3066-4 |  | 85 | 5.6 | 18 | 3810 | PG | 30 | - | 25 | 37.2 | 36.9 | - | - |  |  | -
30A21FW | 2016-02-29 00:00:00 | 2016-03-01 00:00:00 | C5TORIND |  | WGS | Test |  | 105 SP | 5 | 13 | 3810 | CW | 30 | - | 26.1 | 38.3 | 40.2 | - |  |  |  | CW
25A11ST | 2016-03-17 00:00:00 | 2016-03-18 00:00:00 | PLC |  | WGS | Test |  | 110/130/110 | 3.8/6.8/7.2 | "-"/9/9 | MM | [NAME] | 25 | - | 11.5 |  |  | - |  |  |  | HJM
25A21FW | 2016-03-17 00:00:00 | 2016-03-18 00:00:00 | PLC |  | WGS | Test |  | 80/60 | 9.1/8.1 | 9/8 | MM | [NAME] | 25 | - | 12.4 |  |  | - |  |  |  | HJM
30A11ST | 2016-03-17 00:00:00 | 2016-03-18 00:00:00 | PLC |  | WGS | Test |  | 110/90 | 6.2/5.8 | 9/9 | MM | [NAME] | 30 | - | 22.2 |  |  | - |  |  |  | HJM
30C11DU | 2016-03-17 00:00:00 | 2016-03-18 00:00:00 | PLC |  | WGS | Test |  | "-"/60/140 | 6.2/7.6 | "-"/9/10 | MM | [NAME] | 30 | - | 24.6 |  |  | - |  |  |  | HJM
32A11ST | 2016-03-18 00:00:00 | 2016-03-19 00:00:00 | PLC |  | WGS | Test |  | 15/70 | 4.1/6.0 | - | MM | [NAME] | 32 | - | 24.9 |  |  | - |  |  |  | HJM
30D11CW | 30D11CW |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 29 |  |  | -
30D11TW |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 30.1 |  |  | -