Spreadsheet: 48960d1248251062-pivot-table-of-subtotal-pivottableperventofsubtotal-929b
Sheet: Dry Data

 | Need Average output Rate based on Mix
Site | [NAME] | Family recipe | comp Recipe 1 | comp Recipe 2 | comp Recipe 3 | Comp1 [NAME] | Comp2 Ratio | Comp3 Ratio | Comp1 Extruder | Comp2 Extruder | [NAME] | Demand | subtotal helper | subtotal | Family Rate
GA1 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 23400 | 0.004273504273504274 | 6.3
GA1 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 200 | 23400 | 0.008547008547008548 | 6.3
GA1 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 23400 | 0.004273504273504274 | 6.3
GA1 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 23400 | 0.0170940170940171 | 6.3
GA1 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 23400 | 0.04273504273504274 | 8.5
GA1 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 23400 | 0.004273504273504274 | 8.5
GA1 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 23400 | 0.2136752136752137 | 8.5
GA1 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 23400 | 0.0641025641025641 | 10
GA1 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 15000 | 23400 | 0.6410256410256411 | 10
CA2 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 7100 | 0.01408450704225352 | 6.3
CA2 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 200 | 7100 | 0.02816901408450704 | 6.3
CA2 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 7100 | 0.04225352112676056 | 6.3
CA2 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 7100 | 0.05633802816901409 | 6.3
CA2 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 7100 | 0.1408450704225352 | 8.5
CA2 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 7100 | 0.2112676056338028 | 8.5
CA2 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 7100 | 0.01408450704225352 | 8.5
CA2 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 7100 | 0.2112676056338028 | 10
CA2 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 2000 | 7100 | 0.2816901408450704 | 10
AL1 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 13000 | 0.007692307692307693 | 6.3
AL1 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 1500 | 13000 | 0.1153846153846154 | 6.3
AL1 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 13000 | 0.02307692307692308 | 6.3
AL1 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 13000 | 0.007692307692307693 | 6.3
AL1 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1000 | 13000 | 0.07692307692307693 | 8.5
AL1 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 13000 | 0.1153846153846154 | 8.5
AL1 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 13000 | 0.3846153846153846 | 8.5
AL1 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 13000 | 0.1153846153846154 | 10
AL1 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 2000 | 13000 | 0.1538461538461539 | 10
DL2 | K1001 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 100 | 11900 | 0.008403361344537815 | 6.3
DL2 | [NAME] | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 1500 | 11900 | 0.1260504201680672 | 6.3
DL2 | K1003 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 300 | 11900 | 0.02521008403361345 | 6.3
DL2 | K1004 | A | 1 | 2 | 3 | 0.2 | 0.3 | 0.5 | 5 | 6 | 7 | 400 | 11900 | 0.03361344537815126 | 6.3
DL2 | X0001 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 100 | 11900 | 0.008403361344537815 | 8.5
DL2 | X0002 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 1500 | 11900 | 0.1260504201680672 | 8.5
DL2 | X0003 | B | 4 | 5 |  | 0.5 | 0.5 |  | 8 | 9 |  | 5000 | 11900 | 0.4201680672268908 | 8.5
DL2 | Y0001 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 11900 | 0.1260504201680672 | 10
DL2 | Y0002 | C | 6 |  |  | 1 |  |  | 10 |  |  | 1500 | 11900 | 0.1260504201680672 | 10