Spreadsheet: 551247d1512794123-sorting-issues-test-book
Sheet: Sheet1

Production Info |  |  |  | Production Specifics |  |  |  |  |  |  |  |  |  | Rejects |  |  |  |  |  |  |  |  |  |  |  | Other
Date | Shift | [NAME] | Grade | Target Speed | Speed | Deviation | TPH | Downtime | Produced Tons | Scaled Tons | Spool Loss | Trim Loss | Grade Change Reject | PM Reject | WD Reject | Total Reject | Spots | Caliper | Holes | Sizing | Scabs | Color | After Break Reject | Insects | Other | Maintenance | Comments
2017-12-04 00:00:00 | Nights | 413159 | .015-168# Poly Cup (Hot) HH | 1150 | 1013.5 |  | 34.89 | 0 | 68.8 | 23.76 | 2.37 | 2.54 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-12-04 00:00:00 | Nights | 413159 | .015-168# Poly Cup (Hot) | 1150 | 1014.09 |  | 34.94 | 0 | 349.34 | 360.72 | 12.6 | 17.31 | 0 | 0 | 14.83 |  | 6.55 | 0 | 0 | 0 | 0 | 0 | 0 | 8.28
2017-12-03 00:00:00 | Nights | 413165 | .0165-175# Poly Cup WF | 1100 | 927 |  | 34.63 | 0 | 417.39 | 402.11 | 15.82 | 15.3 | 0 | 0 | 16.89 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
2017-12-02 00:00:00 | Nights | 413165 | .0165-175# Poly Cup WF | 1100 | 914.85 |  | 34.4 | 0 | 413.35 | 306.86 | 8.27 | 3.98 | 9.23 | 26.83 | 34.55 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34.55
2017-12-01 00:00:00 | Nights | 413165 | .0165-175# Poly Cup WF | 1100 | 867.31 |  | 32.48 | 60 | 367.43 | 316.45 | 9.98 | 0 | 14.7 | 14.7 | 50.02 |  | 19.94 | 2.5 | 2.47 | 0 | 0 | 0 | 0 | 12.66
2017-11-30 00:00:00 | Days | 413180 | .0180-185# Poly Cup WF | 1000 | 843.6 |  | 34.07 | 0 | 313.92 | 45.07 | 3.42 | 4.96 | 17.55 | 17.55 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-11-30 00:00:00 | Days | 440147 | .014-185# [NAME] | 925 | 950.33 |  | 33.6 | 0 | 89.97 | 79.48 | 1.78 | 3.28 | 16.76 | 16.76 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-11-29 00:00:00 | Days | 440106 | .0105-114# [NAME] | 1600 | 1557.82 |  | 34.58 | 0 | 355.59 | 322.74 | 11.68 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-11-29 00:00:00 | Days | 440008 | .0110-143# [NAME] (90/10 Rec) | 1125 | 1355.5 |  | 33.48 | 0 | 58.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-11-28 00:00:00 | Days | 413017 | .0082-98# Cup Stock (NL) DF | 1600 | 1557.6 |  | 32.51 | 0 | 161.66 | 308.93 | 11.03 | 0 | 0 | 0 | 32.77 |  | 25.11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-11-28 00:00:00 | Days | 440016 | .0105-105# MFF-DF (90/10) | 1600 | 1556.86 |  | 34.33 | 0 | 94.1 | 94.1 | 3.29 | 0 | 14.05 | 16.09 | 0 |  | 0 | 0 | 0 | 0 | 0 | 2.04 | 0 | 0
2017-11-27 00:00:00 | Days | 413017 | .0082-98# Cup Stock (NL) DF | 1600 | 1556.4 |  | 32.67 | 0 | 363.3 | 373.03 | 12 | 0 | 0 | 0 | 80.08 |  | 61.97 | 0 | 0 | 12.24 | 0 | 0 | 0 | 5.82
Row Labels | Count of Shift | Count of Grade Code | Count of Grade | Average of Target Speed | Average of Speed | Average of Deviation | Average of TPH | Average of Downtime | Average of Produced Tons | Average of [NAME] | Average of Spool Loss | Average of Trim Loss | Average of Grade Change Reject | Average of PM Reject | Average of WD Reject | Average of Total Reject | Average of Spots | Average of Caliper | Average of Holes | Average of Sizing | Average of Scabs | Average of Color | Average of After Break Reject | Average of Insects | Average of Other
Dec | 5 | 5 | 5 | 1120 | 947.35 | 0.8451988932806325 | 34.268 | 1900-01-12 00:00:00 | 323.2620000000001 | 281.98 | 9.808000000000002 | 7.825999999999999 | 4.786 | 8.306000000000001 | 23.258 | 31.564 | 5.298 | 0.5 | 0.4940000000000001 | 0 | 0 | 0 | 0 | 13.098 | 12.174
Nov | 7 | 7 | 7 | 1350 | 1339.73 | 0.9955425246675248 | 33.60571428571428 | 00:00:00 | 205.2842857142857 | 174.7642857142857 | 6.171428571428571 | 1.177142857142857 | 6.908571428571428 | 7.200000000000001 | 16.12142857142857 | 23.32142857142857 | 12.44 | 0 | 0 | 1.748571428571429 | 0 | 0.2914285714285714 | 0 | 0.8314285714285715 | 8.010000000000002
Grand Total | 12 | 12 | 12 | 1254.166666666667 | 1176.238333333333 | 0.9328993449229862 | 33.88166666666667 | 1900-01-05 00:00:00 | 254.4416666666667 | 219.4375 | 7.686666666666668 | 3.9475 | 6.024166666666667 | 7.660833333333334 | 19.095 | 26.75583333333333 | 9.464166666666666 | 0.2083333333333333 | 0.2058333333333333 | 1.02 | 0 | 0.17 | 0 | 5.9425 | 9.745