Spreadsheet: 876391d1723066600-value-error-help-my-mrp-copy
Sheet: Production

Hide |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  |  |  | W1 Sum | [NAME] | [NAME] | [NAME]
Type | Size | Sucrose | SAPG | Fructose | FAPG | [NAME] | KLN | Description | SUN1 | MON1 | TUE1 | WED1 | THU1 | FRI1 | SAT1 | W1 TOTAL GAL | SUN2 | MON2 | TUE2 | [NAME] | THU2 | FRI2 | SAT2 | W2 TOTAL GAL | SUN3 | MON3 | TUE3 | WED3 | THU3 | FRI3 | SAT3 | W3 TOTAL GAL | SUN4 | MON4 | TUE4 | WED4 | [NAME] | FRI4 | SAT4 | W4 TOTAL GAL
1 | Gal |  |  |  |  | Green | D01665 | [NAME] | 0 | 9772 | 8843 | 6052 | 7547 | 13830 | 0 |  | 0 | 7000 | 9000 | 9000 | 10000 | 12000 | 0 |  | 0 | 7000 | 9000 | 9000 | 10000 | 12000 | 0 |  | 0 | 7000 | 9000 | 9000 | 10000 | 12000 | 0
2 | Gal |  |  |  |  | Blue | D01700 | [NAME] | 0 | 34874 | 27618 | 31590 | 35095 | 40457 | 0 |  | 0 | 27000 | 36000 | 34000 | 36000 | 36000 | 0 |  | 0 | 27000 | 36000 | 34000 | 36000 | 36000 | 0 |  | 0 | 27000 | 36000 | 34000 | 36000 | 36000 | 0
3 | Gal |  |  |  |  | Red | D00101 | [NAME] 3.25% | 0 | 28939 | 27412 | 26810 | 26852 | 37259 | 0 |  | 0 | 27000 | 27000 | 24000 | 30000 | 34000 | 0 |  | 0 | 27000 | 27000 | 24000 | 30000 | 34000 | 0 |  | 0 | 27000 | 27000 | 24000 | 30000 | 34000 | 0
0 | Gal |  |  |  |  | Light Blue | D02315 | [NAME] | 0 | 4975 | 5990 | 5028 | 5492 | 7007 | 0 |  | 0 | 5000 | 5000 | 5000 | 7000 | 7000 | 0 |  | 0 | 5000 | 5000 | 5000 | 7000 | 7000 | 0 |  | 0 | 5000 | 5000 | 5000 | 7000 | 7000 | 0
1.5 | HG |  |  |  |  | Green | D01661 | [NAME] | 0 | 4089 | 2033 |  | 3101 | 3055 | 0 |  | 0 | 4000 | 6000 | 6000 | 9000 | 10000 | 0 |  | 0 | 4000 | 6000 | 6000 | 9000 | 10000 | 0 |  | 0 | 4000 | 6000 | 6000 | 9000 | 10000 | 0
2.5 | HG |  |  |  |  | Blue | D01600 | [NAME] | 0 | 18556 | 10093 | 8191 | 13948 | 24163 | 0 |  | 0 | 22000 | 28000 | 30000 | 40000 | 40000 | 0 |  | 0 | 22000 | 28000 | 30000 | 40000 | 40000 | 0 |  | 0 | 22000 | 28000 | 30000 | 40000 | 40000 | 0
3.5 | HG |  |  |  |  | Red | D00601 | [NAME] 3.25% | 0 | 12014 | 6044 | 6174 | 8053 | 13607 | 0 |  | 0 | 14000 | 20000 | 20000 | 22000 | 24000 | 0 |  | 0 | 14000 | 20000 | 20000 | 22000 | 24000 | 0 |  | 0 | 14000 | 20000 | 20000 | 22000 | 24000 | 0
0.5 | HG |  |  |  |  | Light Blue | D02305 | [NAME] | 0 | 3133 | 3067 | 1821 | 2056 | 2035 | 0 |  | 0 | 4000 | 6000 | 6000 | 8000 | 8000 | 0 |  | 0 | 4000 | 6000 | 6000 | 8000 | 8000 | 0 |  | 0 | 4000 | 6000 | 6000 | 8000 | 8000 | 0
GLFC | Gal | S |  | F |  | [NAME] | D56032 | [NAME] LF Chocolate | 0 | 4139 |  |  |  | 2955 | 0 |  | 0 | 3000 | 0 | 3000 | 0 | 3000 | 0 |  | 0 | 3000 | 0 | 3000 | 0 | 3000 | 0 |  | 0 | 3000 | 0 | 3000 | 0 | 3000 | 0
HGLFC | HG | S |  | F |  | [NAME] | D56033 | HG Kro LF Chocolate | 0 | 4174 | 4115 |  |  | 8034 | 0 |  | 0 | 4000 | 4000 | 3000 | 5000 | 6000 | 0 |  | 0 | 4000 | 4000 | 3000 | 5000 | 6000 | 0 |  | 0 | 4000 | 4000 | 3000 | 5000 | 6000 | 0
HGWC | HG | S |  | F |  | Red | D03266 | [NAME] | 0 | 4942 |  | 2435 |  | 3822 | 0 |  | 0 | 6000 | 0 | 4000 | 0 | 4000 | 0 |  | 0 | 6000 | 0 | 4000 | 0 | 4000 | 0 |  | 0 | 6000 | 0 | 4000 | 0 | 4000 | 0
HGHH | HG |  |  |  |  | Purple | D54414 | HG Kro Half & Half | 0 | 1990 |  |  | 1908 |  | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0
HGLFBM | HG |  |  |  |  | Yellow | D02701 | HG Kro LF Buttermilk | 0 |  | 3824 |  |  |  | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0
HGWBM | HG |  |  |  |  | Green | D02712 | [NAME] | 0 |  | 5496 |  |  |  | 0 |  | 0 | 0 | 0 | 6000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 6000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 6000 | 0 | 0 | 0
GOJ | Gal |  |  |  |  | Orange | D08820 | [NAME] | 0 |  | 2439 |  |  |  | 0 |  | 0 | 0 | 5000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 5000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 5000 | 0 | 0 | 0 | 0
HGOJ | HG |  |  |  |  | Orange | D08822 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0
GOJC | Gal |  |  |  |  | Blue | D08815 | [NAME] | 0 |  | 2300 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGOJC | HG |  |  |  |  | Blue | D08902 | HG Kro OJ Calcium | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0 |  | 0 | 0 | 0 | 0 | 4000 | 0 | 0
GL | Gal | S |  |  |  | Green | D03085 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0
HGL | HG | S |  |  |  | Green | D08819 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0
GAC | Gal |  |  |  |  | Red | D08621 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGAC | HG |  |  |  |  | Red | D08626 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
SWBR | Gal |  |  | F |  | Blue | D05087 | [NAME] Way Blue Raspberry
SWO | Gal |  |  | F |  | Orange | D02265 | [NAME] Orange | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0
SWT | Gal |  |  | F |  | Red | D02272 | [NAME] | 0 |  | 1936 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
GTC | Gal |  |  | F |  | Orange | D07823 | [NAME] Citrus | 0 |  |  | 2043 |  |  | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0
GTM | Gal |  |  | F |  | Blue | D07816 | [NAME] | 0 |  |  |  | 1850 |  | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0 |  | 0 | 2000 | 0 | 0 | 0 | 0 | 0
GTT | Gal |  |  | F |  | Red | D07828 | Gal Tampico Tropical | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
GDDT | Gal |  |  |  |  | ZST Red | D08965 | [NAME] | 0 |  | 3089 |  | 2991 |  | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 4000 | 0 | 0 | 0
GCST | Gal | S |  |  |  | Caff Sweet Tea Light Blue | D03024 | [NAME] Sweet Tea | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 4000 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 4000 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 4000 | 2000 | 0 | 0 | 0
GLT | Gal | S |  |  |  | Lemonade Tea Yellow | D01033 | [NAME] Tea | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0 |  | 0 | 0 | 2000 | 0 | 0 | 0 | 0
GDST | Gal | S |  |  |  | Decaf Sweet Tea Blue | D00476 | [NAME] Sweet Tea | 0 |  |  |  |  |  | 0 |  | 0 | 4000 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 4000 | 0 | 4000 | 0 | 0 | 0 |  | 0 | 4000 | 0 | 4000 | 0 | 0 | 0
GUT | Gal |  |  |  |  | Unsweet Tea Green | D08957 | [NAME] | 0 |  | 2065 |  |  |  | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0 |  | 0 | 0 | 0 | 2000 | 0 | 0 | 0
HGCST | HG | S |  |  |  | Caff Sweet Tea Light Blue | D02030 | [NAME] Sweet Tea | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGDST | HG | S |  |  |  | Decaf Sweet Tea Blue | D00653 | [NAME] Sweet Tea | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRBCST | Gal | S |  |  |  | Caff Sweet Tea Light Blue | D04439 | [NAME] Caff Sweet Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRBLT | Gal | S |  |  |  | Lemonade Tea Yellow | D04443 | [NAME] Lemonade Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRBDST | Gal | S |  |  |  | Decaf Sweet Tea Blue | D04441 | [NAME] Sweet Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRBUT | Gal |  |  |  |  | Unsweet Tea Green | D04437 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRBZST | Gal |  |  |  |  | ZST Red | D04438 | [NAME] Decaf Zero Sugar Tea
HGRBCST | HG | S |  |  |  | Caff Sweet Tea Light Blue | D04440 | [NAME] Caff Sweet Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGRBPT | HG | S |  |  |  | Orange | D07055 | [NAME] Peach Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGRBRT | HG | S |  |  |  | Violet | D07052 | [NAME] Raspberry Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGRBDST | HG | S |  |  |  | Decaf Sweet Tea Blue | D04442 | [NAME] Sweet Tea | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGRBZSBT | HG |  |  |  |  | Purple | D07058 | [NAME] Blackberry Tea
GDIW | Gal |  |  |  |  | Red | D02124 | [NAME] | 0 | 16104 | 9487 | 2084 | 18000 | 1846 | 0 |  | 0 | 18000 | 18000 | 18000 | 18000 | 18000 | 0 |  | 0 | 18000 | 18000 | 18000 | 18000 | 18000 | 0 |  | 0 | 18000 | 18000 | 18000 | 18000 | 18000 | 0
GDRW | Gal |  |  |  |  | Blue | D02123 | [NAME] | 0 | 15281 | 12971 | 10609 | 20000 | 1204 | 0 |  | 0 | 20000 | 20000 | 20000 | 20000 | 20000 | 0 |  | 0 | 20000 | 20000 | 20000 | 20000 | 20000 | 0 |  | 0 | 20000 | 20000 | 20000 | 20000 | 20000 | 0
[NAME] | Gal |  |  |  |  | Green | D02125 | [NAME] | 0 | 30305 | 26898 | 28398 | 22000 | 23609 | 0 |  | 0 | 22000 | 22000 | 22000 | 22000 | 22000 | 0 |  | 0 | 22000 | 22000 | 22000 | 22000 | 22000 | 0 |  | 0 | 22000 | 22000 | 22000 | 22000 | 22000 | 0
HG2EN | HG | S |  | F |  | Green | [NAME] | [NAME] Eggnog | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HG6EN | HG | S |  | F |  | Red | D07602 | [NAME]% Eggnog | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGPEN | HG | S |  | F |  | Orange | D07701 | [NAME] Eggnog | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
HGVEN | HG | S |  |  |  | Light Blue | D07734 | [NAME] | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0