Spreadsheet: 167469d1342007449-multiple-column-sum-product-based-on-set-criteria-usage-10th-july-2012
Sheet: Base data 10.07.12

Group | Shift | Vessel | Blows | Pan | Low S (1) | Plate/Slab (2) | Works Arising (3) | High S (4) | Demo/Purch (5) | Light (6) | Breaker (7) | SRSS +200mm (8) | SRSS +200mm (9) | Bank Iron (10) | Skim Iron (11) | Plate Iron (12) | Hematite (13) | Tin Bales (14) | Incinerator (15) | Rail (16) | [NAME] | Wet Scrap | [NAME] | Act Pan | S In Pan | Reblow Reason
1587923 | B | 2 | 1 | 8 |  |  | 12.68 |  | 10 | 10 |  | 12.3 |  |  |  | 10 |  | 5.02 |  |  | 60 |  | B | C | 0.0527
1587924 | B | 2 | 1 | 3 |  |  |  |  | 17.82 |  |  | 7.2 |  |  |  | 10 |  | 4.98 |  |  | 40 |  | S | S | 0.0709
1587925 | B | 2 | 1 | 8 |  | 10 | 10 |  | 10 | 10 |  | 4.96 |  |  |  |  |  | 5 |  | 10.04 | 60 |  | B | B | 0.0203
1587926 | B | 2 | 1 | 9 |  |  |  |  | 18.7 |  |  | 6.3 |  |  |  | 10 |  | 5 |  |  | 40 |  | S | S | 0.0707
1587927 | B | 2 | 1 | 4 |  |  | 9.28 |  | 20.72 |  |  | 15 |  |  |  | 10 |  | 5 |  |  | 60 |  | S | S | 0.0574
1587928 | B | 2 | 1 | 3 |  |  | 20 |  | 10 | 10 |  | 5 |  |  |  |  |  | 5 |  | 10 | 60 |  | B | B | 0.0222
1587929 | B | 2 | 2 | 4 |  | 10 | 27.58 |  | 7.4 | 10 |  |  |  |  |  |  |  | 5.02 |  |  | 60 |  | S | B | 0.0175 | EXTERNAL INFLUENCE
1587930 | B | 2 | 1 | 3 |  | 23.88 | 5 |  |  | 19.34 |  | 6.8 |  |  |  |  |  | 4.98 |  |  | 60 |  | B | B | 0.0153
1587931 | B | 2 | 1 | 9 |  | 10 |  |  |  | 18.98 |  | 21 |  |  |  |  |  | 5.02 |  |  | 55 |  | S | S | 0.0246
1587932 | A | 2 | 1 | 8 |  | 20 | 10.94 |  |  | 18.36 |  | 5.7 |  |  |  |  |  | 5 |  |  | 60 |  | B | B | 0.0156
1587933 | A | 2 | 2 | 3 |  | 8.44 |  |  | 22.28 |  |  | 19.28 |  |  |  |  |  | 5 |  |  | 55 |  | S | S | 0.0319
1587934 | A | 2 | 1 | 1 |  | 20 | 10 |  | 16.76 |  |  | 3.24 |  |  |  |  |  |  |  | 10 | 60 |  | B | B | 0.02
1587935 | A | 2 | 1 | 9 | 6.66 | 10.04 | 20.3 |  |  | 18 |  |  |  |  |  |  |  | 5 |  |  | 60 |  | B | B | 0.0135
1587936 | A | 2 | 2 | 4 |  | 9.1 |  |  |  | 20.72 |  | 20.18 |  |  |  |  |  | 5 |  |  | 55 |  | S | S | 0.0242
1587937 | A | 2 | 1 | 3 |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.24 | 48.24 |  | B | B | 0.0112
1587938 | A | 2 | 1 | 9 |  |  |  |  | 13.5 | 11.5 | 10 |  |  |  |  |  |  | 5 |  |  | 40 |  | S | S | 0.0244
1587939 | A | 2 | 1 | 1 |  | 19.08 |  |  |  | 30.92 |  |  |  |  |  |  |  | 5 |  |  | 55 |  | B | B | 0.0118
1587940 | A | 2 | 1 | 4 |  | 25.66 | 7.42 |  |  | 21.92 |  |  |  |  |  |  |  | 5 |  |  | 60 |  | B | B | 0.0118
1587941 | A | 2 | 1 | 8 |  |  |  |  |  | 20 |  |  |  |  |  |  |  | 5 |  |  | 25 |  | S | S | 0.0148
1587942 | A | 2 | 1 | 1 |  | 20 | 14.86 |  |  | 20.14 |  |  |  |  |  |  |  | 5 |  |  | 60 |  | B | B | 0.013
1587943 | E | 2 | 1 | 4 |  | 10 |  |  |  | 5 | 10 | 10 |  |  |  |  |  | 5 |  |  | 40 |  | S | S | 0.0238
1587944 | E | 2 | 1 | 3 |  |  |  |  |  | 14.98 | 10 | 10.02 |  |  |  |  |  | 5 |  |  | 40 |  | S | S | 0.0254
1587945 | E | 2 | 1 | 9 |  | 25 | 15 |  |  | 20 |  |  |  |  |  |  |  | 5 |  |  | 65 |  | B | B | 0.0125
1587946 | E | 2 | 1 | 8 |  | 10 | 8.74 |  |  | 14.84 |  | 11.4 |  |  |  |  |  | 5.02 |  |  | 50 |  | C | C | 0.0206
1587947 | E | 2 | 1 | 1 |  | 10 | 10.52 |  |  |  |  | 11 |  |  |  |  |  | 4.96 |  | 13.52 | 50 |  | C | C | 0.0218
1587948 | E | 2 | 2 | 9 |  | 10 | 5.2 |  | 19.76 |  |  | 10 |  |  |  |  |  | 5.04 |  |  | 50 |  | B | C | 0.0273 | [NAME] (HEAT BALANCE
1587949 | E | 2 | 1 | 3 |  | 10 |  |  |  | 18.82 | 5 | 11.2 |  |  |  |  |  | 4.98 |  |  | 50 |  | C | C | 0.021
1587950 | E | 2 | 1 | 8 |  | 4.2 | 20.84 |  | 10 | 10 |  |  |  |  |  |  |  | 4.96 |  |  | 50 |  | B | B | 0.0195
1587951 | E | 2 | 1 | 1 |  | 10 | 15.6 |  | 19.42 |  |  |  |  |  |  |  |  | 4.98 |  |  | 50 |  | B | B | 0.022
1587952 | E | 2 | 1 | 4 |  |  | 20 |  | 5 | 5 |  | 15 |  |  |  |  |  | 5 |  |  | 50 |  | C | C | 0.0271
1587953 | E | 2 | 1 | 8 |  | 20.04 | 19.76 |  | 10.2 |  |  |  |  |  |  |  |  |  |  |  | 50 |  | B | B | 0.0167