{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Pricing schedule","Summary","36 months estimate"],"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"merged":[[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,16],[5,1,5,16]]}
[]
[1,"Complete the green cells in the worksheet \"Pricing schedule\""]
[2,"Values can only be entered into the green cells. All other cells are locked."]
[3,"Cells in the column \"VAT %\" has a data selection tab with the options of \"0\" (0%) or \"15\" (15%) VAT. Use the data selection tab to select the % VAT relevant to the particular item."]
[4,"If a value is not inserted for either the \"Unit price VAT Excl.\" or the \"VAT %\" the \"Unit price VAT Incl\" will show \"ERROR\". This is to ensure all items are priced with the applicable VAT rate for all items indicated. "]
[5,"If a value is not inserted for the \"Rate/km\" under transport the \"Unit price VAT Excl\" will show \"ERROR\"or if the \"VAT %\" under transport is not inserted the \"Unit price VAT Incl\" will show \"ERROR\". This is to ensure all items are priced with the applicable VAT rate for all items indicated. "]

{"sheet":"Pricing schedule","index":1,"n_rows":299,"n_cols":10,"rows_kept":299,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,7],[10,0,10,7],[41,0,41,6],[47,0,47,6],[59,0,59,6],[72,0,72,6],[96,0,96,6],[148,0,148,6],[149,0,149,1],[160,0,160,6],[161,0,161,6],[168,0,168,6],[169,0,169,1],[184,0,184,6],[185,0,185,1],[199,0,199,6],[200,0,200,1],[208,0,208,6],[209,0,209,1],[229,0,229,6],[230,0,230,1],[292,0,292,6]]}
["Annexure A (cont)"]
["Pricing instructions:"]
[]
["(i)              Price per item must exclude the delivery cost at Glen College of Agriculture’s kitchen. Cost of delivery is calculated separately under item 14 of the\n              pricing schedule."]
["(ii)             Indicate items zero rated for VAT under the VAT column where applicable, by inserting the percentage VAT charged per item."]
["(iii)           Estimated quantities per month as provided in the pricing schedule is used for purposes of evaluating the bid and are not necessarily indicative of the\n              expected quantities required per month."]
["(iv)           Example calculation of D where B = R 10.00 per unit VAT exclusive and C is not a zero rated item and therefore VAT is charged at 15%:\n             D = R 10.00 x (1 + 0.15) = R 10.00 x 1.15 = R 11.50."]
["(v)             Example calculation of E where D = R 11.50 per unit VAT inclusive and A is 50 units per month:\n              E = R 11.50 x 50 = R 575.00"]
["(vi)            Pricing schedule (Bidders are required to complete the pricing schedule in full for all categories and quote on all items indicated)."]
["(vii)          To be completed in the Excel file provided, printed and each page signed and attached to the tender document. The electronic copy of the pricing\n             schedule also submitted together with the tender document on a memory stick in the envelope"]
[]
["No.","CATEGORY","Unit","Estimated Quantity per month","Unit Price VAT Excl.","VAT %\n(Specify 0% or 15%)","Unit Price VAT Incl.","Amount (VAT Incl.)"]
[{"$nulls":3},"(A)","(B)","(C) ","D=(B)*(1+C%)","E= (A) x (D)"]
[1,"MEAT"]
[1.1,"Topside, Beef, Whole","kg",150,null,null,{"$f":"IF(OR(E15=\"\",F15=\"\"),\"ERROR\",E15*(1+F15/100))","v":"ERROR"},{"$f":"D15*G15","v":{"$error":"#VALUE!"}}]
[1.2,"Beef Mincemeat, 10% fat content (Maximum)","kg",90,null,null,{"$f":"IF(OR(E16=\"\",F16=\"\"),\"ERROR\",E16*(1+F16/100))","v":"ERROR"},{"$f":"D16*G16","v":{"$error":"#VALUE!"}}]
[1.3,"Beef Stew","kg",60,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.4,"T-Bone Steak, Beef, 12mm to 15mm in thickness","kg",256,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.5,"Meaty bones, Beef","kg",75,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.6,"Braai chops, Mutton, 12-15mm in thickness, 120-140g per chop","kg",68,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.7,"Stewing Mutton, excl leg. 50mm. 78% meat, 2% fat, 20% bones","kg",100,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.8,"Leg of Pork, Deboned","kg",160,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.9,"Pork Chops, 12-15mm in thickness, 120 – 140g per chop","kg",256,null,null,"ERROR",{"$error":"#VALUE!"}]
["1.10","Boerewors 3% or less water content","kg",155,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.11,"Beef Patties 100% Beef","kg",43,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.12,"Chicken Polony 2,5 kg Loaf Packaging\n(Quality equivalent to Enterprise)","2,5 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.13,"French Polony, 2.0 kg Loaf Packaging\n(Quality equivalent to Enterprise)","2,0 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.14,"Sandwich Ham, Cooked 2.5 kg Loaf Packaging\n(Quality equivalent to Enterprise)","2,5 kg",16,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.15,"Russians, Long – 1.2 kg Packaging\n(Quality equivalent to Enterprise)","1.2 kg",180,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.16,"Vienna Smoked, Foot long, 6 x 1 kg packaging\n(Quality equivalent to Enterprise)","6 x 1 kg",140,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.17,"Cocktail Cheese grillers 6 x 1kg packaging\n(Quality equivalent to Enterprise)","6 x 1 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.18,"Cocktail pies – 48 x 45 g case","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.19,"Beef sausage, 500 g per tray, 9 trays per box","Box",8,null,null,"ERROR",{"$error":"#VALUE!"}]
["1.20","Pork sausage, 500 g per tray, 9 trays per box","Box",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.21,"Bacon Shoulder 6 x 1 kg box packaging\n(Quality equivalent to Freys)","Box",13,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.22,"Chicken breast fillet IQF 6 x 2 kg packaging","6 x 2kg",23,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.23,"Chicken Drumsticks MCP 150-180GR; ± 13 kg packaging","± 13 kg Bag",24,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.24,"Chicken Thighs MCP 150-180GR 75p; ± 11.5 kg packaging","± 11.5 kg Bag",31,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.25,"Chicken Quarter Legs 10 kg packaging box (+/-33P)","10 kg Case",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.26,"Chicken Wings 10 kg packaging case","10 kg Case",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[1.27,"Chicken livers box 10 x 1kg packaging\n(Quality equivalent to Rainbow)","10 kg Box",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL MEAT (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H15:H41)","v":{"$error":"#VALUE!"}}]
[2,"FISH"]
[2.1,"Hake, Fillet, Large 5 kg packaging","5 kg",14,null,null,{"$f":"IF(OR(E44=\"\",F44=\"\"),\"ERROR\",E44*(1+F44/100))","v":"ERROR"},{"$f":"D44*G44","v":{"$error":"#VALUE!"}}]
[2.2,"Fish Cake, 2 kg box"," 2 kg Box",32,null,null,"ERROR",{"$error":"#VALUE!"}]
[2.3,"Fish Finger, 5 kg case","5 kg Case",32,null,null,"ERROR",{"$error":"#VALUE!"}]
[2.4,"Battered fish, Case 54 x 100g","Case",14,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL FISH (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H44:H47)","v":{"$error":"#VALUE!"}}]
[3,"DAIRY PRODUCTS AND EGGS"]
[3.1,"Full Cream Milk 2 litre packaging","2 litre",900,null,null,{"$f":"IF(OR(E50=\"\",F50=\"\"),\"ERROR\",E50*(1+F50/100))","v":"ERROR"},{"$f":"D50*G50","v":{"$error":"#VALUE!"}}]
[3.2,"2% fat Long Life Milk Case 6 x1 litre packaging","Case",900,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.3,"Yoghurt, Flavoured, sweetened 1litre packaging","1 litre",30,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.4,"Sour Milk 2 litre\n(Quality equivalent to Amazi) ","2 litre",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.5,"Gouda Cheese 2,5 kg packaging","2,5 kg",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.6,"Feta cheese plain 400 g","400 g",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.7,"Cheddar Cheese 2,5 kg packaging","2,5 kg",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.8,"Parmesan Cheese grated, 1 kg packaging","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[3.9,"Cream, Fresh, 1 L","1 litre",4,null,null,"ERROR",{"$error":"#VALUE!"}]
["3.10","Eggs, Large box (15 DOZ)","Box",9,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL DAIRY PRODUCTS AND EGGS (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H50:H59)","v":{"$error":"#VALUE!"}}]
[4,"SPREADS"]
[4.1,"Peanut Butter, Smooth 1 kg\n(Quality Equivalent to Black Cat)","1 kg",64,null,null,{"$f":"IF(OR(E62=\"\",F62=\"\"),\"ERROR\",E62*(1+F62/100))","v":"ERROR"},{"$f":"D62*G62","v":{"$error":"#VALUE!"}}]
[4.2,"Jam, Smooth – Peach 900g packaging","900 g",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.3,"Jam, Smooth – Strawberry 3,75 kg packaging","3,75 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.4,"Jam, Smooth – Apricot A10 tin size packaging","A10",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.5,"Margarine 1kg packaging\n(Quality equivalent to RAMA)","1 kg",150,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.6,"Honey 1 kg","1 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.7,"Syrup, Golden 1 kg packaging","1 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.8,"Cheese Spread, 400 g ","400 g",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.9,"Marmite, 250 g","250 g",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["4.10","Fish Paste, 125 g","125 g",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[4.11,"Sandwich Spread, 270 g","270 g",25,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL SPREADS (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H62:H72)","v":{"$error":"#VALUE!"}}]
[5," BREAD, BAKERY AND CEREALS"]
[5.1,"White Bread 700g, Sliced\n(Quality equivalent to SASKO or Blue Ribbon or Albany)","700g loaf",640,null,null,{"$f":"IF(OR(E75=\"\",F75=\"\"),\"ERROR\",E75*(1+F75/100))","v":"ERROR"},{"$f":"D75*G75","v":{"$error":"#VALUE!"}}]
[5.2,"Brown Bread 700g, Sliced\n(Quality equivalent to SASKO or Blue Ribbon or Albany)","700g loaf",640,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.3,"Bread Buns (Hot Dog Buns)","p/dozen",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.4,"Bread Buns (Hamburger Buns) – 100 g","p/dozen",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.5,"Muffins Case 48 x 55g","Case",42,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.6,"Croissants (mini; 30g) Box 150 x 30g","Box",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.7,"Croissants (large; 80g) Box 70 x 80g","Box",48,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.8,"Scones Case 80 x 50g","Case",52,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.9,"Choice Assorted Biscuits 2 kg packaging","2kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["5.10","Tennis Biscuits, case 12 x 200 g packaging","Case",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.11,"Eat Sum More Biscuits, case 12 x 200 g packaging","Case",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.12,"Lemon Cream Biscuits, case 12 x 200 g packaging","Case",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.13,"Romany Cream Biscuits, case 12 x 200 g packaging","Case",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.14,"Provita biscuits, case 12 x 250 g packaging","Case",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.15,"Mabela Porridge, 10 kg","10 kg",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.16,"Breakfast cereal biscuit, 900 g\n(Quality equivalent to Weetbix)","900 g",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.17,"Pronutro 500 g","500 g",25,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.18,"Breakfast corn flakes cereals 1 kg\n(Quality equivalent to Kellogg’s)","1kg",48,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.19,"Breakfast All-bran cereals 1 kg\n(Quality equivalent to Kellogg’s)","1kg",48,null,null,"ERROR",{"$error":"#VALUE!"}]
["5.20","Oats 1kg","1kg",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.21,"Rice krispies 500g","500g",100,null,null,"ERROR",{"$error":"#VALUE!"}]
[5.22,"Muesli 750g","750g",50,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL BREAD, BAKERY AND CEREALS (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H75:H96)","v":{"$error":"#VALUE!"}}]
[6,"FRESH FRUITS & VEGETABLES"]
[6.1,"Potatoes, fresh Grade 1, Large 10 kg pockets","10 kg bag",11,null,null,{"$f":"IF(OR(E99=\"\",F99=\"\"),\"ERROR\",E99*(1+F99/100))","v":"ERROR"},{"$f":"D99*G99","v":{"$error":"#VALUE!"}}]
[6.2,"Potatoes, fresh Grade 1, Large 7 kg pockets","7 kg bag",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.3,"Baby potato 700g bag","700 g bag",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.4,"Sweet Potatoes, 1 kg bag","1 kg bag",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.5,"Carrots, Select (not broken) 5 kg bags","5 kg bag",16,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.6,"Baby Carrots 300g bag","300 g",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.7,"Beetroot, 1 kg Bag","1 kg bag",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.8,"Onion, Grade 1, 7 kg bags","7 kg bag",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.9,"Red onion, 1 kg","1 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["6.10","Pumpkin (Boer), 35 kg bags","35 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.11,"Butternut, 10 kg bag","10 kg",80,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.12,"Gem Squash, 10 kg Pockets","10 kg",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.13,"Baby Marrow, 4 kg box","4 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.14,"Patty Pans, 200 g","200 g",300,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.15,"Cabbage 10 kg bags with minimum outside leaves","10 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.16,"Red cabbage, 3 kg box","3 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.17,"Cauliflower, 350 g","350 g",300,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.18,"Broccoli, 400 g","400 g",200,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.19,"Spinach, 1 kg Bunch","1 kg",50,null,null,"ERROR",{"$error":"#VALUE!"}]
["6.20","Tomatoes, firm and Ripe, 6 kg Box","6 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.21,"Cherry tomato, 250 g punnet","250 g",320,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.22,"Green Beans, 2 kg","2 kg",30,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.23,"English Cucumbers x15 / Box","Box",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.24,"Green Peppers, 4 kg Box","4 kg",3,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.25,"Red pepper, 4 kg Box ","4 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.26,"Yellow pepper, 4 kg Box ","4 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.27,"Button Mushrooms, box (10 x 250 g)","10 x 250 g",48,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.28,"Garlic crushed, 1kg ","1 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.29,"Lettuce, x8 / Box ","Box",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["6.30","Mixed Lettuce, 200 g","200 g",300,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.31,"Parsley, 30g Bunch","30 g",60,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.32,"Thyme, 20 g","20 g",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.33,"Mint leaves, 20 g","20 g",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.34,"Mixed Vegetables, 1 kg","1 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.35,"Bananas, 18 kg Box","18 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.36,"Guavas, 7.5 kg Box","7.5 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.37,"Pawpaws, 1 kg Box","1 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.38,"Mangoes, 1 kg Box","1 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.39,"Kiwi Fruit, 500g","500 g",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["6.40","Sweet Melon, 2.6 kg Box","2.6 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.41,"Apples, red, 20 kg Box","20 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.42,"Apples, Green, 20 kg Box","20 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.43,"Grapes, 1 kg Box","1 kg",100,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.44,"Naartjies, 10 kg Box","10 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.45,"Oranges, 10 kg bags","10 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.46,"Lemon, 1 kg Bag","1 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.47,"Pineapples, 1 kg Box","1 kg",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.48,"Strawberry, 1 kg","1 kg",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[6.49,"Blueberry, 1 kg","1 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["6.50","Raisins/Sultanas, 1kg Bag","1 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL FRESH FRUITS AND VEGETABLES (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H99:H148)","v":{"$error":"#VALUE!"}}]
["7.      FROZEN VEGETABLES"]
[7.1,"Baby Carrots, 6 x 1 kg Case","Case",10,null,null,{"$f":"IF(OR(E151=\"\",F151=\"\"),\"ERROR\",E151*(1+F151/100))","v":"ERROR"},{"$f":"D151*G151","v":{"$error":"#VALUE!"}}]
[7.2,"Julienne Carrots, 6 x 1 kg Case ","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.3,"Beans (French Cut), 6 x 1 kg Case","Case",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.4,"Butternut, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.5,"Sweet Potato chunks, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.6,"Potato Chips, 10 x 1 kg Case","Case",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.7,"Broccoli & Cauliflower, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.8,"Mixed vegetables, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[7.9,"Country Mix, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["7.10","Assorted Stir-fry frozen vegetables, 6 x 1 kg Case","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL FROZEN VEGETABLES (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H151:H160)","v":{"$error":"#VALUE!"}}]
["8.      FRUIT JUICE CONCENTRATE NECTAR(± 40 - 50%; Dilution rate >= 1:4; Similar to Magalies)"]
[8.1,"Apple (Concentrated); 5 litre","5 litre",20,null,null,{"$f":"IF(OR(E163=\"\",F163=\"\"),\"ERROR\",E163*(1+F163/100))","v":"ERROR"},{"$f":"D163*G163","v":{"$error":"#VALUE!"}}]
[8.2,"Cranberry (Concentrated); 5 litre  ","5 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[8.3,"Guava (Concentrated); 5 litre","5 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[8.4,"Orange (Concentrated); 5 litre","5 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[8.5,"Fruit Punch (Concentrated); 5 litre","5 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[8.6,"Mango & Orange (Concentrated); 5 litre","5 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL FRUIT JUICE CONCENTRATE (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H163:H168)","v":{"$error":"#VALUE!"}}]
["9.      BEVERAGES OTHER"]
[9.1,"Instant Coffee; 1.5 kg packaging\n(Quality equivalent to Ricoffy)","1,5 kg",12,null,null,{"$f":"IF(OR(E171=\"\",F171=\"\"),\"ERROR\",E171*(1+F171/100))","v":"ERROR"},{"$f":"D171*G171","v":{"$error":"#VALUE!"}}]
[9.2,"Rooibos Tea; Box 80’s packaging\n(Quantity equivalent to Freshpak)","Box",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.3,"Tea tagless; packet 100 x 2.5g packaging\n(Quality equivalent to Five Roses)","packet",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.4,"Earl Grey tea tagless; carton 200 x 2.5g","carton",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.5,"English breakfast tea; carton 200 x 2.5g ","carton",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.6,"Assorted Fruit juices similar to Fruitree; Case 24; 24 x 250ml","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.7,"Assorted Fruit juices similar to Liqui Fruit; Case 24; 24 x 300ml packaging","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.8,"Apple juice similar to Appletizer; Case 24, 24 x 330ml packaging","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.9,"Grape juice similar to Grapetiser; Case 24, 24 x 330ml packaging","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["9.10","Assorted flavours fizzy juice similar to Minute-maid; Case 24, 24 x 330ml packaging","Case",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.11,"Orange Squash; 2 litre\n(Quality equivalent to Oros)","2 litre",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.12,"Assorted flavours soda drinks; Case 24; 24 x 300ml packaging","Case",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.13,"Still Water; Case 24; 24 x 500 ml packaging\n(Quality equivalent to Valpre or Bonaqua)","Case",50,null,null,"ERROR",{"$error":"#VALUE!"}]
[9.14,"Sparkling Water; Case 24; 24 x 500 ml packaging\n(Quality equivalent to Valpre or Bonaqua)","Case",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL BEVERAGES OTHER (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H171:H184)","v":{"$error":"#VALUE!"}}]
["10.       CANNED PRODUCTS"]
[10.1,"Pilchards in Tomato Sauce; 400g","400 g",100,null,null,{"$f":"IF(OR(E187=\"\",F187=\"\"),\"ERROR\",E187*(1+F187/100))","v":"ERROR"},{"$f":"D187*G187","v":{"$error":"#VALUE!"}}]
[10.2,"Butter beans; 2.5 kg\n(Quality equivalent to Koo)","2.5 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.3,"Kidney beans; 2.5 kg\n(Quality equivalent to Koo)","2.5 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.4,"Green beans; A10\n(Quality equivalent to Koo)","A10",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.5,"Baked Beans in Tomato Sauce; 3.06 kg\n(Quality equivalent to Koo)","3,06 kg",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.6,"Fruit Cocktail; 3.06 kg","3,06 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.7,"Guava Halves; 3.01 kg","3,01 kg",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.8,"Peach halves; 3 kg","3 kg",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.9,"Pear halves; 3 kg","3 kg",6,null,null,"ERROR",{"$error":"#VALUE!"}]
["10.10","Chakalaka; 410 g\n(Quality equivalent to Koo)","410 g",60,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.11,"Tomato Puree; 3.06 kg","3.06 kg",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.12,"Olives seedless; 4.1 kg","4.1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[10.13,"Black Olives; 4.1kg","4.1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL CANNED PRODUCTS (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H187:H199)","v":{"$error":"#VALUE!"}}]
["11.       GRAINS & STARCH"]
[11.1,"Macaroni; 3 kg\n(Quality equivalent to Fattis & Monis)","3 kg",15,null,null,{"$f":"IF(OR(E202=\"\",F202=\"\"),\"ERROR\",E202*(1+F202/100))","v":"ERROR"},{"$f":"D202*G202","v":{"$error":"#VALUE!"}}]
[11.2,"Spaghetti; 3 kg\n(Quality equivalent to Fattis & Monis)","3 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[11.3,"Rice parboiled; 10 kg\n(Quality equivalent to Tastic)","10 kg",12,null,null,"ERROR",{"$error":"#VALUE!"}]
[11.4,"Brown Rice; 2kg\n(Quality equivalent to Tastic)","2 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[11.5,"Maize Meal; 10 kg\n(Quality equivalent to White Star)","10 kg",13,null,null,"ERROR",{"$error":"#VALUE!"}]
[11.6,"Samp; 10 kg\n(Quality equivalent to Iwisa)","10 kg",9,null,null,"ERROR",{"$error":"#VALUE!"}]
[11.7,"Cake Flour; 10 kg\n(Quality equivalent to Golden cloud)","10 kg",9,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL GRAINS AND STARCH (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H202:H208)","v":{"$error":"#VALUE!"}}]
["12.       DISPOSABLES"]
[12.1,"Clingwrap cater roll (330 mm wide x 1400 m length); specify any length of more than 1000m","Cater roll",2,null,null,{"$f":"IF(OR(E211=\"\",F211=\"\"),\"ERROR\",E211*(1+F211/100))","v":"ERROR"},{"$f":"D211*G211","v":{"$error":"#VALUE!"}}]
[12.2,"Heavy duty catering foil roll (70 m x 440 mm)","Roll",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.3,"Fomo food tray no. 30, sleeve 75’s\n(Quality equivalent to Aro)","75’s",100,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.4,"Plastic spoons; 100’s\n(Quality equivalent to Aro)","100’s",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.5,"Plastic teaspoons; 100’s\n(Quality equivalent to Aro)  ","100’s",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.6,"Plastic forks; 100’s\n(Quality equivalent to Aro)  ","100’s",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.7,"Plastic bottles and lids; 250 ml x 50\n(Quality equivalent to Aro)  ","250ml x 50",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.8,"Plastic Cups (250 ml x 50)","250 ml x 50",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.9,"Plastic heavy duty aprons, disposable; (100’s)","100’s",2,null,null,"ERROR",{"$error":"#VALUE!"}]
["12.10","White serviettes box of 1000 (300 mm x 300 mm)","Box",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.11,"Vacuum bag; 185 mm x 110 mm, 100 per pack","100 pack",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.12,"Plastic Shopping bag; Bale 300mm x 160mm x 430","Bale",1,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.13,"Toothpicks wrapped; 1000 per box","Box",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.14,"Kebab stick (long), 50’s 250mm x 3mm ","50’s",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.15,"Kebab stick (short), 50’s 200 x 3mm","50’s",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.16,"Food string/twine Roll 1mm x 100m","Roll",1,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.17,"Matches; 10 x 10’s shrink","10 x 10’s SHR",1,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.18,"Charcoal; 4kg bag","4 kg bag",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[12.19,"Firelighters; 12’s (box)\n(Quality equivalent to Blitz)","Box",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL DISPOSABLES (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H211:H229)","v":{"$error":"#VALUE!"}}]
["13.      CONDIMENTS"]
[13.1,"Mayonnaise; 20 kg bucket\n(Quality equivalent to Cross & Blackwell)","20 kg",1,null,null,{"$f":"IF(OR(E232=\"\",F232=\"\"),\"ERROR\",E232*(1+F232/100))","v":"ERROR"},{"$f":"D232*G232","v":{"$error":"#VALUE!"}}]
[13.2,"Tomato Sauce; 700 ml\n(Quality equivalent to All Gold)","700 ml",80,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.3,"Chutney; 3 kg packaging\n(Quality equivalent to Mrs H Balls)","3 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.4,"Sweet chilli sauce; 2 litre\n(Quality equivalent to Wellington)","2 litre",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.5,"1000 Island dressing; 2 litre\n(Quality equivalent to Knorr)","2 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.6,"Worcestershire Sauce; 5 litre","5 litre",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.7,"Mustard; 2 litre packaging\n(Quality equivalent to Colmann’s)","2 litre",3,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.8,"Garlic sauce; 375 ml ","375 ml",16,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.9,"Mushroom Sauce; 2 kg\n(Quality equivalent to Knorr)","2 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.10","Garlic & Herb Sauce; 2 litre","2 litre",11,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.11,"Soy Sauce; 2 litre","2 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.12,"White Sauce packet; 1 kg TUB","1 kg",16,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.13,"Cheese Sauce packet; 800g TUB","800 g",16,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.14,"Extra hot Peri-Peri Sauce; 2 litre","2 litre",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.15,"Hot Peri-Peri Sauce; 2 litre","2 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.16,"Mild Peri-Peri Sauce; 2 litre","2 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.17,"Spirit Vinegar white; 5 litre","5 litre",3,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.18,"White Sugar; 12.5 kg","12.5 kg",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.19,"Brown Sugar; 2 kg","2 kg",5,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.20","Sweetener; 1000 sachets per Box","Box",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.21,"Paprika, 700g","700 g",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.22,"Garlic Salt, 100g","100 g",40,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.23,"Steak & Chops Spice, 1kg","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.24,"Six Gun Spice, 1kg","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.25,"Portuguese Spice, 1 kg","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.26,"Lemon & Herb Spice 800 g","800 g",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.27,"Food spice similar to Aromat; 1 kg","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.28,"BBQ Spice; 1 kg packaging\n(Quality equivalent Robertsons) ","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.29,"Chicken Spice; 1 kg packaging\n(Quality equivalent Robertsons) ","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.30","Garlic Spice; 100g packaging\n(Quality equivalent Robertsons) ","100 g",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.31,"Medium Curry; 800 g packaging\n(Quality equivalent Robertsons) ","800 g",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.32,"Turmeric; 800g packaging\n(Quality equivalent Robertsons) ","800g",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.33,"Fish Spice; 1 kg packaging\n(Quality equivalent Robertsons) ","1 kg",4,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.34,"White Pepper; 800 g packaging\n(Quality equivalent Robertsons) ","800 g",3,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.35,"Black Pepper; 800 g packaging\n(Quality equivalent Robertsons) ","800 g",3,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.36,"Salt Fine, Iodated; 1 kg","1 kg",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.37,"Salad dressing, Greek; 1 litre\n(Quality equivalent to Knorr)","1 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.38,"Salad dressing, Honey & mustard; 1 litre\n(Quality equivalent to Knorr)","1 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.39,"Brown Onion Soup; 1.6 kg packaging","1,6 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.40","Meat stock brown; 1 kg packaging\n(Quality equivalent to BISTO)","1 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.41,"Beef Stock Cubes; 12 x 10g Box\n(Quality equivalent to Knorr)","Box",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.42,"Chicken Stock cubes; 12 x 10g Box\n(Quality equivalent to Knorr)","Box",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.43,"Mutton Stock cubes; 12 x 10g Box\n(Quality equivalent to Knorr)","Box",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.44,"Marinade Chicken; 5 litre\n(Quality equivalent to Jimmy`s)","5 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.45,"Marinade Beef; 5 litre\n(Quality equivalent to Jimmy`s)","5 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.46,"Marinade, Lemon & Herb; 2 litre","2 litre",30,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.47,"Baking essence (vanilla) 1 litre","1 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.48,"Tartaric acid; 1 kg packaging","1 kg",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.49,"Baking Powder; 1 kg packaging","1 kg",2,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.50","Bicarbonate of Soda; 500g packaging","500 g",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.51,"Dry Yeast instant; 48 x 10g packaging","48 x10 g",2,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.52,"Chicken Coating; 5 kg Bag","5 kg",6,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.53,"Custard Powder, 2.5 kg","2.5 kg",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.54,"Jelly powder, 8 x 500 g Carton","Carton",8,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.55,"Malva pudding instant mix 400 g","400 g",30,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.56,"Sunflower Cooking oil; 20 litre","20 litre",5,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.57,"Canola Cooking oil; 4 litre","4 litre",15,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.58,"Olive Oil; 1 litre","1 litre",20,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.59,"Coconut Oil; 500 ml","500 ml",20,null,null,"ERROR",{"$error":"#VALUE!"}]
["13.60","Powdered milk; 1 kg","1 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
[13.61,"Endearments; 1 kg packaging","1 kg",10,null,null,"ERROR",{"$error":"#VALUE!"}]
["TOTAL CONDIMENTS (CARRIED TO SUMMARY)",{"$nulls":6},{"$f":"SUM(H232:H292)","v":{"$error":"#VALUE!"}}]
[]
[14,"TRANSPORT","Unit","Estimated return trips per month","Rate/km","Return trip distance (km)","Unit Price VAT Excl.","VAT %\n(Specify 0% or 15%)","Unit Price VAT Incl.","Amount (VAT Incl.)"]
[{"$nulls":3},"(A)","(a)","(b)","(B=axb)","(C)","D=(B)*(1+C%)","E= (A) x (D)"]
[14.1,"Transport costs to Glen - normal vehicle (unit price should be rate per km x return distance (70 km))","return trip",12,null,70,{"$f":"IF(E297=\"\",\"ERROR\",E297*F297)","v":"ERROR"},null,{"$f":"IF(OR(G297=\"\",H297=\"\"),\"ERROR\",G297*(1+H297/100))","v":"ERROR"},{"$f":"D297*I297","v":{"$error":"#VALUE!"}}]
["14,2","Transport costs to Glen - cold truck (unit price should be rate per km for cold truck x return distance (70 km))","return trip",8,null,70,{"$f":"IF(E298=\"\",\"ERROR\",E298*F298)","v":"ERROR"},null,"ERROR",{"$f":"D298*I298","v":{"$error":"#VALUE!"}}]
["TOTAL TRANSPORT (CARRIED TO SUMMARY)",{"$nulls":8},{"$f":"SUM(J297:J298)","v":{"$error":"#VALUE!"}}]

{"sheet":"Summary","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,0,15,2],[16,0,16,1]]}
["SUMMARY OF SCHEDULES",null,null,"Amount (VAT Incl.)"]
[1,"TOTAL MEAT",null,{"$f":"'Pricing schedule'!H42","v":{"$error":"#VALUE!"}}]
[2,"TOTAL FISH",null,{"$f":"'Pricing schedule'!H48","v":{"$error":"#VALUE!"}}]
[3,"TOTAL DAIRY PRODUCTS AND EGGS",null,{"$f":"'Pricing schedule'!H60","v":{"$error":"#VALUE!"}}]
[4,"TOTAL SPREADS",null,{"$f":"'Pricing schedule'!H73","v":{"$error":"#VALUE!"}}]
[5,"TOTAL BREAD, BAKERY AND CEREALS",null,{"$f":"'Pricing schedule'!H97","v":{"$error":"#VALUE!"}}]
[6,"TOTAL FRESH FRUITS AND VEGETABLES",null,{"$f":"'Pricing schedule'!H149","v":{"$error":"#VALUE!"}}]
[7,"TOTAL FROZEN VEGETABLES",null,{"$f":"'Pricing schedule'!H161","v":{"$error":"#VALUE!"}}]
[8,"TOTAL FRUIT JUICE CONCENTRATE",null,{"$f":"'Pricing schedule'!H169","v":{"$error":"#VALUE!"}}]
[9,"TOTAL BEVERAGES OTHER",null,{"$f":"'Pricing schedule'!H185","v":{"$error":"#VALUE!"}}]
[10,"TOTAL CANNED PRODUCTS",null,{"$f":"'Pricing schedule'!H200","v":{"$error":"#VALUE!"}}]
[11,"TOTAL GRAINS AND STARCH",null,{"$f":"'Pricing schedule'!H209","v":{"$error":"#VALUE!"}}]
[12,"TOTAL DISPOSABLES",null,{"$f":"'Pricing schedule'!H230","v":{"$error":"#VALUE!"}}]
[13,"TOTAL CONDIMENTS",null,{"$f":"'Pricing schedule'!H293","v":{"$error":"#VALUE!"}}]
[14,"TOTAL TRANSPORT",null,{"$f":"'Pricing schedule'!J299","v":{"$error":"#VALUE!"}}]
["SUB TOTAL (F)",null,null,{"$f":"SUM(D2:D15)","v":{"$error":"#VALUE!"}}]
["TOTAL ESTIMATE FOR YEAR 1 (G)\n(Groceries required for 10 months a year excluding December and January) (G = F x 10)",null,"x10",{"$f":"D16*10","v":{"$error":"#VALUE!"}}]

{"sheet":"36 months estimate","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[4,0,4,1]]}
["Period","Estimated inflation % (H)","Year estimate"]
["Year 1 (total from summary of schedules) (G)",null,{"$f":"Summary!D17","v":{"$error":"#VALUE!"}}]
["Year 2 (I = G x (1+H%))",{"v":0.04,"d":"4%"},{"$f":"C2*(1+B3)","v":{"$error":"#VALUE!"}}]
["Year 3 (J = I x (1+H%))",{"v":0.04,"d":"4%"},{"$f":"C3*(1+B4)","v":{"$error":"#VALUE!"}}]
["TOTAL ESTIMATED TENDER AMOUNT (36 months)",null,{"$f":"SUM(C2:C4)","v":{"$error":"#VALUE!"}}]