Spreadsheet: 70722d1271424375-excel-2007-pivots-with-lookups-or-indexes-fix
Sheet: RECIPES

 |  |  | Count of Qty
Item | Qty |  | Item | Total |  | Supplement Recipe | Ingred.1 | Spec. | TOTAL | Ingred.2 | Spec. | TOTAL | Ingred.3 | Spec. | TOTAL | Ingred.4 | Spec. | TOTAL | Ingred.5 | Spec. | TOTAL | Ingred.6 | Spec. | TOTAL | Ingred.7 | Spec. | TOTAL | Ingred.8 | Spec. | TOTAL | Ingred.9 | Spec. | TOTAL | [NAME] | Spec. | TOTAL
250Ml [NAME] | 1 |  | 250Ml [NAME] | 8 |  | 250Ml [NAME] | [NAME] | 0.25 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 8 | Poly Lid | 1 | 8 |  | 24 Muffins = 1KG | Issue 4 24 | Per Person
250Ml [NAME] | 1 |  | 250Ml Conc Apple Juice | 9 |  | 250Ml Conc Apple Juice | [NAME]. | 0.02 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 9 | Poly Lid | 1 | 9 |  | [NAME] | 1 | 0.04166666666666666
250Ml [NAME] | 1 |  | 250Ml Fortified Apple Juice | 8 |  | 250Ml Conc Fruit Cocktail Juice | Fruit Cocktail | 0.02 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 8 | Poly Lid | 1 | 8 |  | Oil | 0.25 | 0.01041666666666667
250Ml [NAME] | 1 |  | 250Ml Milk Low Fat | 19 |  | 250Ml Conc Guava Juice | [NAME]. | 0.02 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 7 | Poly Lid | 1 | 7 |  | Egg | 2 | 0.08333333333333333
250Ml [NAME] | 1 |  | Portion: Custard | 9 |  | 250Ml Diluted Apple Juice | [NAME]. | 0.25 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 7 | Poly Lid | 1 | 7 |  | Milk | 1 | 0.04166666666666666
250Ml [NAME] | 1 |  | Fruit: Apple | 4 |  | 250Ml Diluted Fruit Cocktail Juice | Fruit Cocktail | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1 |  |  | Apples | 2 | 0.08333333333333333
250Ml [NAME] | 1 |  | 250Ml Conc Guava Juice | 7 |  | 250Ml Diluted Guava Juice | [NAME]. | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1 |  |  | [NAME] | 2 | 0.08333333333333333
250Ml [NAME] | 1 |  | 250Ml Diluted Apple Juice | 7 |  | 250Ml Fortified Apple Juice | [NAME]. | 0.25 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 8 | Poly Lid | 1 | 8
250Ml Conc Apple Juice | 1 |  | 250Ml Conc Fruit Cocktail Juice | 8 |  | 250Ml Grape Juice (Liquifruit Grape) | Liquifruit 250ml | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  | Cereal: All Bran | 5 |  | 250Ml Ice Cream | Ice Cream | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  | Cereal: Cornflakes | 7 |  | 250Ml Maas | Maas | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  | Portion: Boiled Egg (+ 1 Sachet Salt) | 1 |  | 250Ml [NAME] ( 0 Scoops) | Maas | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  | Portion: Boiled Egg - No Salt | 1 |  | 250Ml Milk Full Cream | FC Milk | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  |  |  |  | 250Ml Milk Low Fat | LF Milk | 0.25 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 | 19 | Poly Lid | 1 | 19
250Ml Conc Apple Juice | 1 |  |  |  |  | 250Ml Yoghurt: Enriched | FR.Yoghurt | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  |  |  |  | 250Ml Yoghurt: Fortified | FR.Yoghurt | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Apple Juice | 1 |  |  |  |  | 250Ml Yoghurt: Fruit | FR.Yoghurt | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PolyCup | 1 |  | Poly Lid | 1
250Ml Conc Guava Juice | 1 |  |  |  |  | Cereal: All Bran | PL.Yoghurt | 0.25 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 | 5 | 60 D | 1 | 5
250Ml Conc Guava Juice | 1 |  |  |  |  | Cereal: Cornflakes | All Bran | 0.04 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 | 7 | 60 D | 1 | 7
250Ml Conc Guava Juice | 1 |  |  |  |  | Cereal: Weetbix x 2 | Weetbix | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Guava Juice | 1 |  |  |  |  | Fruit: Apple | Apple | 1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 | 4 | 60 D | 1 | 4
250Ml Conc Guava Juice | 1 |  |  |  |  | Fruit: Banana | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Guava Juice | 1 |  |  |  |  | Fruit: Orange | Orange | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Guava Juice | 1 |  |  |  |  | Fruit: Pear | Pear | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Boiled Egg - No Salt | Egg | 1 | 1 | [NAME] | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 | 1 | 60 D | 1 | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Boiled Egg (+ 1 Sachet Salt) | Egg | 1 | 1 | Egg | 0.083 | 1 | Oil | 0.0104 | 1 | Milk | 0.0417 | 1 | Apple | 0.08333 | 1 | [NAME] | 0.08333 | 1 | Cling Wrap | 0.04 | 1 | 60 D | 1 | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: [NAME] | [NAME] | 0.0417 |  | [NAME] | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Cheese & Crackers | Snacktime | 3 |  | Paprika | 0.001 |  | Oil | 0.01 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Chicken Drumstick | [NAME] | 0.18 |  | Milk | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Custard | [NAME] | 0.01 | 9 | Oil | 0.02 | 9 | [NAME] | 0.001 | 9 |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 | 9 | 60 D | 1 | 9
250Ml Diluted Apple Juice | 1 |  |  |  |  | Portion: Fried Fish (150g) | Hake Portion | 0.15 |  | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: Hot Chips | Chips | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: Hot Chips - NO SALT | Chips | 0.1 |  | Margarine | 0.015 |  | HotDog Roll | 1 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: Hotdog | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: Jelly | Jelly | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: Prunes (8/Portion) | Prunes | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Portion: [NAME] (1/Portion) | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Sandwich: Cheese | Bread | 2 |  | Margarine | 0.015 |  | [NAME] | 0.015 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Fortified Apple Juice | 1 |  |  |  |  | Sandwich: Chicken Mayonnaise | Bread | 2 |  | Margarine | 0.015 |  | [NAME] | 0.08 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: [NAME] | Bread | 2 |  | Margarine | 0.015 |  | [NAME] | 0.04 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: Egg Mayonnaise | Bread | 2 |  | Margarine | 0.015 |  | Egg | 1 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: Fried Egg | Bread | 2 |  | Margarine | 0.015 |  | Egg | 1 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: Jam | Bread | 2 |  | Margarine | 0.015 |  | Jam | 0.03 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: [NAME] | Bread | 2 |  | Margarine | 0.015 |  | P.nut Butter | 0.03 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Sandwich: Polony, Cheese & Tomato | Bread | 2 |  | Margarine | 1.015 |  | [NAME] | 0.04 |  | [NAME] | 0.015 |  | Tomato | 0.03 |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Scone: Jam And Cream | J&C Scone | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Conc Fruit Cocktail Juice | 1 |  |  |  |  | Scone: Jam And Margarine | PL. Scone | 1 |  | Margarine | 0.015 |  | Jam | 0.03 |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 1
250Ml Milk Low Fat | 1 |  |  |  |  | Scone: Plain | PL. Scone | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cling Wrap | 0.04 |  | 60 D | 2
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sundries |  |  | Cling Wrap |  | 27 |  | 60 D Trays | 27 |  | PolyCup | 66 |  | Poly Lid | 66
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
Portion: Custard | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
250Ml Milk Low Fat | 1
Fruit: Apple | 1
Fruit: Apple | 1
Fruit: Apple | 1
Fruit: Apple | 1
Cereal: All Bran | 1
Cereal: All Bran | 1
Cereal: All Bran | 1
Cereal: All Bran | 1
Cereal: All Bran | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Cereal: Cornflakes | 1
Portion: Boiled Egg (+ 1 Sachet Salt) | 1
Portion: Boiled Egg - No Salt | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1
0 | 1