{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["1.KITCHEN BOQ","2.TUCKSHOP BOQ","3.WORKSHOP, CS, CONF & ROOM BOQ","SUMMARY"],"not_rendered":{"images":1,"external_links":1,"defined_names":155},"read":"whole","date_system":"1900"}

{"sheet":"1.KITCHEN BOQ","index":0,"n_rows":660,"n_cols":9,"rows_kept":660,"merged":[[659,1,659,5]]}
["ITEM CODE","ITEM NO","DESCRIPTION","36 MONTH QTY","UOM","RATE EXCL VAT","AMOUNT EXCL VAT","VAT AMOUNT","TOTAL AMOUNT INCL VAT"]
[]
[null,null,"KITCHEN"]
[null,null,"GROCERIES"]
[null,null,"BILL NO.1"]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF DRY GOODS"]
[]
[null,null,"Beans"]
["0688672",1,"3.06kg Baked Koo or equivalent",1584,"tin",null,{"$f":"ROUND(D10*F10,2)","v":0},{"$f":"ROUND(G10*0.15,2)","v":0},{"$f":"ROUND(G10+H10,2)","v":0}]
["0567448",{"$f":"B10+1","v":2},"3.06kg Baked Goldcrest or equivalent",1584,"tin",null,{"$f":"ROUND(D11*F11,2)","v":0},0,0]
["0672256",3,"5kg oval butter dry beans",6,"bag",null,{"$f":"ROUND(D12*F12,2)","v":0},0,0]
["0576492",4,"A10 Butter in brine koo or equivalent",634,"tin",null,0,0,0]
["0576528",5,"A10 Red kidney goldcrest or equivalent",634,"tin",null,0,0,0]
["0672258",6,"5kg Red speckled sugar ",119,"bag",null,0,0,0]
["0746538",7,"5kg Black eyed grade A",6,"each",null,0,0,0]
["0746537",8,"5kg Cannellini grade A",6,"each",null,0,0,0]
["0747773",9,"410g Black koo or equivalent",6,"each",null,0,0,0]
["0747111",10,"5kg Dry chickpea",5,"each",null,0,0,0]
["0672122",11,"410g Goldcrest or equivalent chickpea in brine",950,"each",null,0,0,0]
["0747812",12,"1kg dried brown legumes lentil",10,"each",null,0,0,0]
["0747817",13,"1kg dried whole green peas",10,"each",null,0,0,0]
["0745413",14,"1kg dried whole reddish peas",10,"each",null,0,0,0]
["0747818",15,"1kg dried split pink lintel",10,"each",null,0,0,0]
["0745412",16,"1kg dried whole yellow peas",10,"each",null,0,0,0]
["0672254",17,"410g black round lentil in brine",396,"each",null,0,0,0]
[]
[null,null,"Bread/ Rolls"]
["0587007",{"$f":"B26+1","v":18},"700g sliced brown bread(Bag Plastic)",19800,"loaf",null,{"$f":"ROUND(D29*F29,2)","v":0},"Zero Rated",{"$f":"G29","v":0}]
["0769505",{"$f":"B29+1","v":19},"700g unsliced brown bread",600,"loaf",null,0,"Zero Rated",{"$f":"G30","v":0}]
["0183483",20,"700g sliced white bread (Bag Plastic)",19800,"loaf",null,0,{"$f":"ROUND(G31*0.15,2)","v":0},{"$f":"ROUND(G31+H31,2)","v":0}]
["0769504",21,"700g un-sliced white bread ",600,"each",null,0,0,0]
["0183488",22,"Plain white baked hotdog roll        ",19800,"each",null,0,0,0]
["0183486",23,"Plain white baked round hamburger roll      ",29700,"each",null,0,0,0]
["0183512",24,"Garlic bread               ",396,"loaf",null,0,0,0]
["0655891",25,"700g sliced wholegrain bread              ",1188,"loaf",null,0,0,0]
["0183494",26,"French baguette bread                                  ",396,"Each",null,0,0,0]
["0568322",27,"100g Grissini bread sticks",792,"packet",null,0,0,0]
["0748309",28,"750g round flat rotis",80,"packet",null,0,0,0]
["0747614",29,"135g Folded into U-shape tortilla",5,"packet",null,0,0,0]
["0747615",30,"156g Folded into U-shape tortilla",5,"packet",null,0,0,0]
["0747613",31,"336g Folded into U-shape tortilla",5,"packet",null,0,0,0]
["0749146",32,"25cm diameter round flatbread",792,"packet",null,0,0,0]
["0749572",33,"100g thin round crisp bread",100,"packet",null,0,0,0]
["0708212",34,"20 X 520g plain round-flat tortillas",10,"packet",null,0,0,0]
["0649468",35,"1kg Liberty or equivalent bread crumbs",10,"kg",null,0,0,0]
[]
[null,null,"Cereal price/1kg box or bag"]
["0576655",{"$f":"B46+1","v":36},"1kg All Bran Kellogg's or equivalent",990,"box",null,{"$f":"ROUND(D49*F49,2)","v":0},{"$f":"ROUND(G49*0.15,2)","v":0},{"$f":"ROUND(G49+H49,2)","v":0}]
["0651962",{"$f":"B49+1","v":37},"1kg Cornflakes Kellogg's or equivalent",990,"box",null,0,0,0]
["0576602",38,"1kg Crunch muesli",100,"box",null,0,0,0]
["0183762",39,"1kg Jungle oats original      ",713,"box",null,0,0,0]
["0183764",40,"1kg Plain rice krispies",200,"box",null,0,0,0]
["0747438",41,"375kg All-bran hi-fibre ",2,"box",null,0,0,0]
["0576510",42,"1kg Nutzy crunch meusli",24,"box",null,0,0,0]
["0747439",43,"1kg coco pops",2,"box",null,0,0,0]
[]
[null,null,"Chemical leavening agents"]
["0183649",{"$f":"B56+1","v":44},"1kg Royal baking powder ",50,"packet",null,{"$f":"ROUND(D59*F59,2)","v":0},{"$f":"ROUND(G59*0.15,2)","v":0},{"$f":"ROUND(G59+H59,2)","v":0}]
["0567857",{"$f":"B59+1","v":45},"1kg Bicarbonate of soda",792.0000000000001,"packet",null,{"$f":"ROUND(D60*F60,2)","v":0},{"$f":"ROUND(G60*0.15,2)","v":0},{"$f":"ROUND(G60+H60,2)","v":0}]
["0744692",{"$f":"B60+1","v":46},"1kg cream of tarta",4,"each",null,{"$f":"ROUND(D61*F61,2)","v":0},{"$f":"ROUND(G61*0.15,2)","v":0},{"$f":"ROUND(G61+H61,2)","v":0}]
[]
[null,null,"Cherry"]
["0576484",{"$f":"B61+1","v":47},"410g Black pitted cherries",950,"tin",null,{"$f":"ROUND(D64*F64,2)","v":0},{"$f":"ROUND(G64*0.15,2)","v":0},{"$f":"ROUND(G64+H64,2)","v":0}]
["0576424",{"$f":"B64+1","v":48},"1kg Red glazed cherries(plastic bucket)",150,"bucket",null,{"$f":"ROUND(D65*F65,2)","v":0},{"$f":"ROUND(G65*0.15,2)","v":0},{"$f":"ROUND(G65+H65,2)","v":0}]
["0747772",{"$f":"B65+1","v":49},"680g cherry pitted",24,"bottle",null,{"$f":"ROUND(D66*F66,2)","v":0},{"$f":"ROUND(G66*0.15,2)","v":0},{"$f":"ROUND(G66+H66,2)","v":0}]
["0747435",{"$f":"B66+1","v":50},"1kg green whole cherry tub",24,"tub",null,{"$f":"ROUND(D67*F67,2)","v":0},{"$f":"ROUND(G67*0.15,2)","v":0},{"$f":"ROUND(G67+H67,2)","v":0}]
[]
[null,null,"Chutney Grade 1"]
["0649529",{"$f":"B67+1","v":51},"3KG Mrs balls Grade 1",158,"bucket",null,{"$f":"ROUND(D70*F70,2)","v":0},{"$f":"ROUND(G70*0.15,2)","v":0},{"$f":"ROUND(G70+H70,2)","v":0}]
[]
[null,null,"Coconut"]
["0649549",{"$f":"B70+1","v":52},"1Kg Coconut fine particles ",198.00000000000003,"packet",null,{"$f":"ROUND(D73*F73,2)","v":0},{"$f":"ROUND(G73*0.15,2)","v":0},{"$f":"ROUND(G73+H73,2)","v":0}]
["0744706",{"$f":"B73+1","v":53},"1kg Coconut flakes",198.00000000000003,"packet",null,{"$f":"ROUND(D74*F74,2)","v":0},{"$f":"ROUND(G74*0.15,2)","v":0},{"$f":"ROUND(G74+H74,2)","v":0}]
[]
[null,null,"Dessert"]
["0582251",{"$f":"B74+1","v":54},"1kg Chocolate mousse dessert carte dor",792,"tub",null,{"$f":"ROUND(D77*F77,2)","v":0},{"$f":"ROUND(G77*0.15,2)","v":0},{"$f":"ROUND(G77+H77,2)","v":0}]
["0582239",{"$f":"B77+1","v":55},"1kg Strawberry mousse dessert carte dor",792,"tub",null,0,0,0]
["0649476",56,"379ml Caramel dessert treat",100,"tin",null,0,0,0]
["0649704",57,"385g Condensed milk",950,"can",null,0,0,0]
["0769514",58,"1L Fresh cream meadowlands classic",4000,"bottle",null,0,0,0]
["0746889",59,"1kg Carte d'or white chocolate mousse",80,"each",null,0,0,0]
["0649705",60,"380g Unsweetened Ideal evaporated milk",4,"each",null,0,0,0]
["0746890",61,"1kg Carte d'or cream caramel dessert topping",48,"each",null,0,0,0]
[]
[null,null,"Dressing for salads"]
["0672111",{"$f":"B84+1","v":62},"1L Knorr or equivalent blue cheese ",396,"bottle",null,{"$f":"ROUND(D87*F87,2)","v":0},{"$f":"ROUND(G87*0.15,2)","v":0},{"$f":"ROUND(G87+H87,2)","v":0}]
["0672112",{"$f":"B87+1","v":63},"1L Knorr or equivalent ceasar   ",396,"bottle",null,0,0,0]
["0672045",64,"1L Knorr or equivalent greek",396,"bottle",null,0,0,0]
["0672110",65,"1L Knorr or equivalent italian     ",396,"bottle",null,0,0,0]
["0747842",66,"1L Hallmans or equivalent french",150,"each",null,0,0,0]
["0747843",67,"1L Hallmans or equivalent greek",150,"each",null,0,0,0]
["0747841",68,"1L Hallmans or equivalent ceaser",2,"each",null,0,0,0]
[]
[null,null,"Dried Fruit (Grade A)"]
["0576651",{"$f":"B93+1","v":69},"1kg Prunes pitted",20,"packet",null,{"$f":"ROUND(D96*F96,2)","v":0},{"$f":"ROUND(G96*0.15,2)","v":0},{"$f":"ROUND(G96+H96,2)","v":0}]
["0672113",{"$f":"B96+1","v":70},"1kg Safari seedless raisins",396.00000000000006,"packet",null,0,0,0]
["0576480",71,"1kg Apple rings      ",20,"kg",null,0,0,0]
["0576631",72,"Apricot halves      ",20,"kg",null,0,0,0]
["0576399",73,"1kg Banana               ",20,"kg",null,0,0,0]
["0576481",74,"1kg Mango slices               ",20,"kg",null,0,0,0]
["0576624",75,"1kg Dried mixed fruits            ",198.00000000000003,"kg",null,0,0,0]
["0576463",76,"1kg Peach peeled           ",20,"kg",null,0,0,0]
["0576617",77,"1kg Pears     ",20,"kg",null,0,0,0]
["0747425",78,"1kg Cranberry",1,"each",null,0,0,0]
["0747424",79,"1kg Fig",2,"each",null,0,0,0]
["0746888",80,"250g Goji berries",2,"each",null,0,0,0]
["0746630",81,"2 to 3.5g bean vanilla pods",6,"each",null,0,0,0]
["0747454",82,"1kg sultanas",2,"each",null,0,0,0]
["0748307",83,"250g Fruit sticks",20,"each",null,0,0,0]
[]
[null,null,"Essence"]
["0576574",{"$f":"B110+1","v":84},"1L Moir's vanilla",396,"bottle",null,{"$f":"ROUND(D113*F113,2)","v":0},{"$f":"ROUND(G113*0.15,2)","v":0},{"$f":"ROUND(G113+H113,2)","v":0}]
["0713327",{"$f":"B113+1","v":85},"40ml Moir's lemon",100,"bottle",null,{"$f":"ROUND(D114*F114,2)","v":0},{"$f":"ROUND(G114*0.15,2)","v":0},{"$f":"ROUND(G114+H114,2)","v":0}]
["0747431",{"$f":"B114+1","v":86},"30ml Red food colouring",20,"bottle",null,{"$f":"ROUND(D115*F115,2)","v":0},{"$f":"ROUND(G115*0.15,2)","v":0},{"$f":"ROUND(G115+H115,2)","v":0}]
["0748782",{"$f":"B115+1","v":87},"50ml vanilla bean",6,"bottle",null,{"$f":"ROUND(D116*F116,2)","v":0},{"$f":"ROUND(G116*0.15,2)","v":0},{"$f":"ROUND(G116+H116,2)","v":0}]
["0748709",{"$f":"B116+1","v":88},"50ml mint",6,"bottle",null,{"$f":"ROUND(D117*F117,2)","v":0},{"$f":"ROUND(G117*0.15,2)","v":0},{"$f":"ROUND(G117+H117,2)","v":0}]
[]
[null,null,"Eggs"]
["0183523",{"$f":"B117+1","v":89},"30 Dozen large oval chicken eggs box of 360",1500,"box",null,{"$f":"ROUND(D120*F120,2)","v":0},"Zero Rated",{"$f":"G120","v":0}]
[]
[null,null,"Honey"]
["0581116",{"$f":"B120+1","v":90},"1kg Pure gold                                  ",158,"bottle",null,{"$f":"ROUND(D123*F123,2)","v":0},{"$f":"ROUND(G123*0.15,2)","v":0},{"$f":"ROUND(G123+H123,2)","v":0}]
["0747822",{"$f":"B123+1","v":91},"250g Honey Comb raw unfiltered",6,"each",null,{"$f":"ROUND(D124*F124,2)","v":0},{"$f":"ROUND(G124*0.15,2)","v":0},{"$f":"ROUND(G124+H124,2)","v":0}]
[]
[null,null,"Flour"]
["0672115",{"$f":"B124+1","v":92},"12.5kg Golden cloud brown bread wheat flour",36,"bag",null,{"$f":"ROUND(D127*F127,2)","v":0},{"$f":"ROUND(G127*0.15,2)","v":0},{"$f":"ROUND(G127+H127,2)","v":0}]
["0583595",{"$f":"B127+1","v":93},"12.5kg Snowflake cake wheat flour",634,"bag",null,0,{"$f":"ROUND(G128*0.15,2)","v":0},{"$f":"ROUND(G128+H128,2)","v":0}]
["0582279",94,"500g Semolina wheat powder ",158,"kg",null,0,{"$f":"ROUND(G129*0.15,2)","v":0},{"$f":"ROUND(G129+H129,2)","v":0}]
["0582259",95,"10kg Cake mix madeira powder ",158,"bag",null,0,{"$f":"ROUND(G130*0.15,2)","v":0},{"$f":"ROUND(G130+H130,2)","v":0}]
["0713320",96,"1kg Pancake and waffle premix",198,"kg",null,0,{"$f":"ROUND(G131*0.15,2)","v":0},{"$f":"ROUND(G131+H131,2)","v":0}]
["0583605",97,"500g Fine powder maizena corn flour",1188,"box",null,0,"Zero Rated",{"$f":"G132","v":0}]
["0744696",98,"1kg gluten free flour",2,"each",null,0,{"$f":"ROUND(G133*0.15,2)","v":0},{"$f":"ROUND(G133+H133,2)","v":0}]
["0744705",99,"1kg snowflake nutty wheat",4,"each",null,0,0,0]
["0744707",100,"1kg Tempura powder",1,"each",null,0,0,0]
["0744690",101,"5kg pettina kokomix cake mix",1,"each",null,0,0,0]
["0744691",102,"5kg pettina sponge instant cake mix",1,"each",null,0,0,0]
["0744689",103,"5kg waffle premix",1,"each",null,0,0,0]
["0744689",104,"5kg waffle cake mix",10,"each",null,0,0,0]
["0744688",105,"5kg pettina fond suisse cake mix",1,"each",null,0,0,0]
["0748707",106,"25kg bran muffin milling cake mix",1,"each",null,0,0,0]
["0744691",107,"5kg pettina sponge  cake mix",2,"each",null,0,0,0]
["0747123",108,"5kg plain white muffin cake mix",10,"each",null,0,0,0]
["0568351",109,"10kg cheese cake mix",1,"each",null,0,0,0]
[]
[null,null,"Jam"]
["0581128",{"$f":"B144+1","v":110},"15g Rhodes or equivalent assorted jam portions box of 200",119,"box",null,{"$f":"ROUND(D147*F147,2)","v":0},{"$f":"ROUND(G147*0.15,2)","v":0},{"$f":"ROUND(G147+H147,2)","v":0}]
["0581058",{"$f":"B147+1","v":111},"3kg Grade 1 strawberry                                               ",158,"tin",null,0,0,0]
["0576623",112,"3.75Kg All gold apricot                ",317,"tin",null,0,0,0]
["0581105",113,"3kg mixed fruit grade1",158,"each",null,0,0,0]
["0747122",114,"340g thick texture fig grade A",6,"each",null,0,0,0]
["0654049",115,"15g marmalade sachet box of 200",154,"each",null,0,0,0]
["0654061",116,"3.75kg All gold or equivalent strawberry",36,"each",null,0,0,0]
[]
[null,null,"Jelly"]
["0576573",{"$f":"B153+1","v":117},"4kg Assorted carte d'or         ",475,"box",null,{"$f":"ROUND(D156*F156,2)","v":0},{"$f":"ROUND(G156*0.15,2)","v":0},{"$f":"ROUND(G156+H156,2)","v":0}]
[]
[null,null,"Macaroni dry/Pasta/Grain"]
["0672149",{"$f":"B156+1","v":118},"500g Elbow macaroni    ",1188,"packet",null,{"$f":"ROUND(D159*F159,2)","v":0},{"$f":"ROUND(G159*0.15,2)","v":0},{"$f":"ROUND(G159+H159,2)","v":0}]
["0644375",{"$f":"B159+1","v":119},"500g Pasta quills",792,"packet",null,0,0,0]
["0644372",120,"500g Pasta shells",1188,"packet",null,0,0,0]
["0644374",121,"500g Spaghetti         ",1188,"packet",null,0,0,0]
["0644397",122,"500g Tagliatelle        ",792,"packet",null,0,0,0]
["0649731",123,"500g flat macaroni",1188,"packet",null,0,0,0]
["0713329",124,"7cm Tartletshell round base pastry box of 12",100,"box",null,0,0,0]
["0713323",125,"400g Drill bit shaped pasta egg noodles ",396,"packet",null,0,0,0]
["0649740",126,"500g macaroni dry",100,"each",null,0,0,0]
["0747819",127,"500g vermicelli noodle",12,"each",null,0,0,0]
["0744656",128,"1kg screw noodle",100,"each",null,0,0,0]
["0672150",129,"500g drill bit shaped pasta",60,"each",null,0,0,0]
["0744658",130,"500g cylindrical tube cannelloni pasta",24,"each",null,0,0,0]
["0744659",131,"500g bowtie shape farfalle pasta",24,"each",null,0,0,0]
["0744661",132,"500g Futtucini strips",24,"each",null,0,0,0]
["0720636",133,"500g fattis & monis or equivalent beige dry lasagna",50,"each",null,0,0,0]
["0744657",134,"500g Linguine strips",24,"each",null,0,0,0]
["0744667",135,"500g cylinder gluten free penne pasta",12,"each",null,0,0,0]
["0744666",136,"500g curved tube penne rigate pasta",396,"each",null,0,0,0]
["0747160",137,"550g plain spring roll sheets",10,"each",null,0,{"$f":"ROUND(G178*0.15,2)","v":0},{"$f":"ROUND(G178+H178,2)","v":0}]
[]
[]
[null,null,"Maize"]
["0583597",{"$f":"B178+1","v":138},"12.5kg white star or equivalent superbag (white)",1500,"bag",null,{"$f":"ROUND(D182*F182,2)","v":0},"Zero Rated",{"$f":"G182","v":0}]
["0583626",{"$f":"B182+1","v":139},"12.5kg ace or equivalent maize meal (white)",1,"each",null,0,"Zero Rated",{"$f":"G183","v":0}]
["0672124",140,"10kg Grade1 Cream Imbo Samp         ",317,"bag",null,0,"ZeroRated",{"$f":"G184","v":0}]
["0748332",141,"1kg Grade A polenta",120,"each",null,0,{"$f":"ROUND(G185*0.15,2)","v":0},{"$f":"ROUND(G185+H185,2)","v":0}]
["0736889",142,"1kg Grade A popcorn seeds",30,"each",null,0,0,0]
["0738646",143,"1kg pure sorghum ground mabele grain wheat",12,"each",null,0,0,0]
["0748314",144,"1kg grade A Quinoa black whole grain wheat",12,"each",null,0,0,0]
["0748313",145,"1kg grade A Quinoa red whole grain wheat",12,"each",null,0,0,0]
["0748614",146,"1kg grade A Quinoa white whole grain wheat",12,"each",null,0,0,0]
["0746985",147,"1kg grade A barley cereal like grain wheat",6,"each",null,0,0,0]
["0713321",148,"1kg Bulgur cracked wheat grain",158,"each",null,0,0,0]
[]
[]
[null,null,"Nuts EDBL"]
["0581277",{"$f":"B192+1","v":149},"1kg  Liberty oval whole almond ",119,"kg",null,{"$f":"ROUND(D196*F196,2)","v":0},{"$f":"ROUND(G196*0.15,2)","v":0},{"$f":"ROUND(G196+H196,2)","v":0}]
["0672118",{"$f":"B196+1","v":150},"1kg Liberty oval mixed roasted almond           ",2,"kg",null,0,0,0]
["0582310",151,"50g Oval peanuts and raisins box of 36",40,"box",null,0,0,0]
["0582311",152,"50g Oval simba peanuts box of 36",119,"kg",null,0,0,0]
["0187041",153,"1kg Oval pecan ",396,"kg",null,0,0,0]
["0567812",154,"1kg Liberty oval walnuts",198,"kg",null,0,0,0]
["0747422",155,"1kg Liberty sprinkle nuts",2,"kg",null,0,0,0]
["0747422",156,"1kg Liberty oval cashew",90,"kg",null,0,0,0]
["0713326",157,"1kg Oval hazelnut raw",20,"kg",null,0,0,0]
["0713322",158,"1kg Oval and dried hazelnut",20,"kg",null,0,0,0]
["0747423",159,"1kg Pistachio",2,"kg",null,0,0,0]
["0567445",160,"1kg Almond flakes",24,"packet",null,0,0,0]
[]
[null,null,"Oil"]
["0672255",{"$f":"B207+1","v":161},"Plain Sesame suti hui hong vegitable oil ",119,"litre",null,{"$f":"ROUND(D210*F210,2)","v":0},"Zero Rated",{"$f":"G210","v":0}]
["0649755",{"$f":"B210+1","v":162},"20L Nola sunflower pure vegetable oil ",650,"bottle",null,{"$f":"ROUND(D211*F211,2)","v":0},"Zero Rated",{"$f":"G211","v":0}]
["0582202",{"$f":"B211+1","v":163},"100% Olive oil ",36,"bottle",null,{"$f":"ROUND(D212*F212,2)","v":0},{"$f":"ROUND(G212*0.15,2)","v":0},{"$f":"ROUND(G212+H212,2)","v":0}]
["0748784",{"$f":"B212+1","v":164},"Truffle olive oil",4,"each",null,{"$f":"ROUND(D213*F213,2)","v":0},{"$f":"ROUND(G213*0.15,2)","v":0},{"$f":"ROUND(G213+H213,2)","v":0}]
[]
[null,null,"Pie filling"]
["0576483",{"$f":"B213+1","v":165},"1kg Blueberry filling               ",158,"each",null,{"$f":"ROUND(D216*F216,2)","v":0},{"$f":"ROUND(G216*0.15,2)","v":0},{"$f":"ROUND(G216+H216,2)","v":0}]
["0576576",{"$f":"B216+1","v":166},"1kg Strawberry filling          ",158,"each",null,{"$f":"ROUND(D217*F217,2)","v":0},{"$f":"ROUND(G217*0.15,2)","v":0},{"$f":"ROUND(G217+H217,2)","v":0}]
["0576395",{"$f":"B217+1","v":167},"1Kg Blackberry filling",50,"each",null,{"$f":"ROUND(D218*F218,2)","v":0},{"$f":"ROUND(G218*0.15,2)","v":0},{"$f":"ROUND(G218+H218,2)","v":0}]
[]
[null,null,"Powders"]
["0649547",{"$f":"B218+1","v":168},"1kg Liberty Cocoa podwer                                            ",158,"kg",null,{"$f":"ROUND(D221*F221,2)","v":0},{"$f":"ROUND(G221*0.15,2)","v":0},{"$f":"ROUND(G221+H221,2)","v":0}]
["0582286",{"$f":"B221+1","v":169},"2.5kg Carte d'or custard powder          ",792,"box",null,0,0,0]
["0644512",170,"1kg Kramess plain instant icing powder",198,"packet",null,0,0,0]
["0649664",171,"1kg Gelatine",36,"packet",null,0,0,0]
["0748325",172,"Actiwhite meringue powder",1,"each",null,0,0,0]
["0584243",173,"1kg Cream brulle tub",36,"each",null,0,0,0]
["0583583",174,"500g sago tiny balls pudding",50,"each",null,0,0,0]
[]
[null,null,"Preserves"]
["0649746",{"$f":"B227+1","v":175},"3.06kg Cucumber dill pickles",198,"bottle",null,{"$f":"ROUND(D230*F230,2)","v":0},{"$f":"ROUND(G230*0.15,2)","v":0},{"$f":"ROUND(G230+H230,2)","v":0}]
["0187048",{"$f":"B230+1","v":176},"3kg Guava halves                                                 ",396,"tin",null,0,0,0]
["0581101",{"$f":"B231+1","v":177},"3kg Goldcrest fruit cocktail",216,"tin",null,0,0,0]
["0576445",178,"1.7kg Liberty fish procso tuna chuncks",150,"tin",null,0,0,0]
["0576642",179,"3.15kg All gold tomato paste                 ",634,"tin",null,0,0,0]
["0748706",180,"A10 chickpeas in brine",5,"each",null,0,0,0]
["0582249",181,"3.06kg Rhodes peach halves in syrup                  ",475,"tin",null,0,0,0]
["0581416",182,"3.06kg Rhodes pear halves in syrup                      ",475,"tin",null,0,0,0]
["0576498",183,"3kg Rhodes black pitted olives",150,"tin",null,0,0,0]
["0576634",184,"3.06kg Rhodes pineapple rings",475,"tin",null,0,0,0]
["0649449",185,"2kg prepared atchar salad                                ",2,"each",null,0,0,0]
["0672030",186,"2kg Atchar vegetable strips salad     ",2,"each",null,0,0,0]
["0649449",187,"385g Atchar packo salad     ",6,"each",null,0,0,0]
["0746628",188,"3.15kg Pitted whole green olives      ",158,"tin",null,0,0,0]
["0581465",189,"2.85kg Stems mistro mushroom pieces    ",12,"tin",null,0,0,0]
["0713324",190,"Jalapeno pepper bell in vinegar",90,"jar",null,0,0,0]
["0582201",191,"200g gherkin cocktail pickle               ",198,"jar",null,0,0,0]
["0746460",192,"200g Ginger preserve in syrup",6,"jar",null,0,0,0]
["0744695",193,"fig:pear shaped;bottle;340 g;preserved",2,"each",null,0,0,0]
["0746989",194,"preserve, fruit:figs in syrup;grade a",2,"each",null,0,0,0]
["0748611",195,"fish procsd:anchovy fillets in oil;1 kg",1,"each",null,0,0,0]
["0568406",196,"apple:baby;can;425 g",6,"each",null,0,0,0]
["0567478",197,"apricot:grade 1;halves;can;3.06 kg;koo",30,"each",null,0,0,0]
["0744718",198,"cream dairy:coconut Jemz;tin;400 ml",6,"each",null,0,0,0]
["0744571",199,"milk:human consumption;uht processed;tin",20,"each",null,0,0,0]
["0745299",200,"paste:curry green;tub with lid;plastic;1",2,"each",null,{"$f":"ROUND(D255*F255,2)","v":0},{"$f":"ROUND(G255*0.15,2)","v":0},{"$f":"ROUND(G255+H255,2)","v":0}]
["0747113",201,"paste:red curry;plastic;1 kg",2,"each",null,0,0,0]
["0746629",202,"olive:green pitted;jar;340 g",10,"each",null,0,0,0]
["0746484",203,"vegetable, caned:hearts of palm;can",10,"each",null,0,0,0]
["0749574",204,"pear:baby in syrup;can;410 g;whole",6,"each",null,0,0,0]
["0728089",205,"pepper bell:peppadew whole;can;3 kg",100,"each",null,0,0,0]
["0746384",206,"grinder spice:pepper corn;57 g",6,"each",null,0,0,0]
["0748308",207,"grinder spice:salt;5 cm;100 ml;glass package",6,"each",null,{"$f":"ROUND(D262*F262,2)","v":0},{"$f":"ROUND(G262*0.15,2)","v":0},{"$f":"ROUND(G262+H262,2)","v":0}]
["0746481",208,"relish vegetable: piccalilli pickle; grade A; jar packaged",3,"each",null,0,0,0]
["0746459",209,"onion:pickled white;jar;410 g",12,"each",null,0,0,0]
["0746382",210,"tomato:pesto sundried goldcrest;140 g",3,"each",null,0,0,0]
["0748608",211,"paste:wasabi;plastic tube with lid;43 g",2,"each",null,0,0,0]
["0672127",212,"paste:mustard, dijon;bottle;bottle;350 g",2,"each",null,0,0,0]
["0747162",213,"mustard:dijon smooth;glass jar;215 g",2,"each",null,{"$f":"ROUND(D268*F268,2)","v":0},{"$f":"ROUND(G268*0.15,2)","v":0},{"$f":"ROUND(G268+H268,2)","v":0}]
["0582252",214,"mustard:english wellington;bottle;168 g",2,"each",null,{"$f":"ROUND(D269*F269,2)","v":0},{"$f":"ROUND(G269*0.15,2)","v":0},{"$f":"ROUND(G269+H269,2)","v":0}]
["0748962",215,"paste:cooking tamarind;plastic container",2,"each",null,0,0,0]
["0747459",216,"tomato:sundried in oil;1 kg;glass jar",4,"each",null,0,0,0]
["0749571",217,"food, processed:tofu; a soya bean curd",6,"each",null,0,0,0]
["0746383",218,"puree:tomato;can;3 kg",36,"each",null,0,0,0]
["0746474",219,"tomato:whole peeled;3 kg;can;grade a",2,"each",null,0,0,0]
["0746382",220,"tomato:pesto sundried goldcrest;140 g",1,"each",null,{"$f":"ROUND(D275*F275,2)","v":0},{"$f":"ROUND(G275*0.15,2)","v":0},{"$f":"ROUND(G275+H275,2)","v":0}]
["0747612",221,"food, processed:seaweed sushi sheets",2,"each",null,{"$f":"ROUND(D276*F276,2)","v":0},0,0]
["0745298",222,"granadilla:thick with seeds;plastic tub",10,"each",null,{"$f":"ROUND(D277*F277,2)","v":0},0,0]
["0713317",223,"icing plastic 1kg (fondant) satin white",5,"each",null,0,0,0]
["0713317",224,"icing plastic 1kg (fondant) Fondre",6,"each",null,{"$f":"ROUND(D279*F279,2)","v":0},{"$f":"ROUND(G279*0.15,2)","v":0},{"$f":"ROUND(G279+H279,2)","v":0}]
[]
[null,null,"Rice"]
["0672123",{"$f":"B279+1","v":225},"10kg Tastic instant brown ",80,"bag",null,{"$f":"ROUND(D282*F282,2)","v":0},"Zero rated",{"$f":"G282","v":0}]
["0583936",{"$f":"B282+1","v":226},"1kg Instant couscous                        ",50,"box",null,0,{"$f":"ROUND(G283*0.15,2)","v":0},{"$f":"ROUND(G283+H283,2)","v":0}]
["0583936",{"$f":"B283+1","v":227},"1kg Instant couscous                        ",594,"box",null,{"$f":"ROUND(D284*F284,2)","v":0},{"$f":"ROUND(G284*0.15,2)","v":0},{"$f":"ROUND(G284+H284,2)","v":0}]
["0583945",228,"10kg Tastic instant white                      ",3564.0000000000005,"bag",null,0,"Zero rated",{"$f":"G285","v":0}]
["0746476",229,"5kg Instant basmatic ",80,"bag",null,0,{"$f":"ROUND(G286*0.15,2)","v":0},{"$f":"ROUND(G286+H286,2)","v":0}]
["0583972",230,"2kg Jasmine instant rice",20,"each",null,0,"Zero rated",{"$f":"G287","v":0}]
["0747844",231,"5kg sushi instant rice",1,"each",null,0,"Zero rated",{"$f":"G288","v":0}]
["0649756",232,"2kg brown old mill stream instant rice",4,"each",null,0,"Zero rated",0]
[]
[null,null,"Rusks"]
["0576639",{"$f":"B289+1","v":233},"500g Ouma buttermilk                          ",60,"box",null,{"$f":"ROUND(D292*F292,2)","v":0},{"$f":"ROUND(G292*0.15,2)","v":0},{"$f":"ROUND(G292+H292,2)","v":0}]
["0576545",{"$f":"B292+1","v":234},"500g Ouma muesli",60,"box",null,{"$f":"ROUND(D293*F293,2)","v":0},{"$f":"ROUND(G293*0.15,2)","v":0},{"$f":"ROUND(G293+H293,2)","v":0}]
["0576400",{"$f":"B293+1","v":235},"500g Bokomo plain                                ",30,"box",null,{"$f":"ROUND(D294*F294,2)","v":0},{"$f":"ROUND(G294*0.15,2)","v":0},{"$f":"ROUND(G294+H294,2)","v":0}]
[]
[null,null,"Salt"]
["0576513",{"$f":"B294+1","v":236},"1kg Coarse                                                  ",198,"kg",null,{"$f":"ROUND(D297*F297,2)","v":0},{"$f":"ROUND(G297*0.15,2)","v":0},{"$f":"ROUND(G297+H297,2)","v":0}]
["0576432",{"$f":"B297+1","v":237},"1.22g Fine foods satchets box of 1000 ",79,"box",null,{"$f":"ROUND(D298*F298,2)","v":0},{"$f":"ROUND(G298*0.15,2)","v":0},{"$f":"ROUND(G298+H298,2)","v":0}]
["0582233",{"$f":"B298+1","v":238},"1kg Fine table                            ",792,"kg",null,{"$f":"ROUND(D299*F299,2)","v":0},{"$f":"ROUND(G299*0.15,2)","v":0},{"$f":"ROUND(G299+H299,2)","v":0}]
[]
[null,null,"Sauces"]
[]
["0576405",{"$f":"B299+1","v":239},"4.5kg All gold tomato                        ",792,"box",null,{"$f":"ROUND(D303*F303,2)","v":0},{"$f":"ROUND(G303*0.15,2)","v":0},{"$f":"ROUND(G303+H303,2)","v":0}]
[{"$f":"[1]Data!$B$540","v":"0576459"},{"$f":"B303+1","v":240},"5L Barbeque ",317,"bottle",null,0,0,0]
["0576544",{"$f":"B304+1","v":241},"5L Quinns hamburger spiced                       ",317,"bottle",null,0,0,0]
["0649793",{"$f":"B305+1","v":242},"5L Lazeby worcesterhire      ",79,"bottle",null,0,0,0]
["0576460",243,"20L Original Nola mayonnaise         ",317,"tub",null,0,0,0]
["0649928",244,"Shebo plain tomato and onion mix    ",317,"bucket",null,0,0,0]
["0576629",245,"Thai sweet chilli           ",317,"bottle",null,0,0,0]
["0576632",246,"2L Wellington sweet chilli       ",317,"bottle",null,0,0,0]
["0582178",247,"2kg Knorr original tartare ",317,"bottle",null,0,0,0]
["0649776",248,"5L Quinns soya ",158,"Bottel",null,0,0,0]
["0576414",249,"2L Knorr mint",317,"bottle",null,0,0,0]
["0576645",250,"1L Oyster ",198,"bottle",null,0,0,0]
["0582189",251,"250ml Nandos peri peri mild ",396,"bottle",null,0,0,0]
["0583971",252,"2L Liquid Horseradish",79,"bottle",null,0,0,0]
["0747458",253,"sauce:smokey;barbeque;plastic container 5l",2,"each",null,0,0,0]
["0744773",254,"sauce:aro;chillie;plastic bottle;5 l",4,"each",null,0,0,0]
["0748312",255,"sauce:classic brown base; knorr;1 kg",6,"each",null,0,0,0]
["0649767",256,"sauce:knorr;classic white;1 kg",6,"each",null,0,0,0]
["0582179",257,"sauce:cranberry;cranberry;bottle;454 g",6,"each",null,0,0,0]
["0744774",258,"sauce:top kitchen;fish;plastic bottle",6,"each",null,0,0,0]
["0744781",259,"sauce:kikkoman;soy green;plastic bottle",2,"each",null,0,0,0]
["0744780",260,"sauce:kikkoman;soy red;plastic bottle",2,"each",null,0,0,0]
["0744772",261,"sauce: minnies; lemon and herb;5l ;liquid",4,"each",null,0,0,0]
["0744770",262,"sauce:quinns;munkee gland;plastic bottle 5l",4,"each",null,0,0,0]
["0649772",263,"sauce:quinns;peri peri;container plastic 5l",2,"each",null,0,0,0]
["0744784",264,"sauce:mutti;pizza;tin;4.1 kg",2,"each",null,0,0,0]
["0748037",265,"sauce:portuguese prego;hot; peri peri;5",2,"each",null,0,0,0]
["0748038",266,"sauce:rib basting;sweet; tangy and smokey",2,"each",null,0,0,0]
["0748310",267,"sauce:strawberry flavoured; quinns;sweet",6,"each",null,0,0,0]
["0744782",268,"sauce:minnies;tikka hot;plastic bottle;2",4,"each",null,0,0,0]
["0744778",269,"sauce:minnies;tikka mild;plastic bottle",4,"each",null,0,0,0]
["0744775",270,"sauce:lazenby;worcester;bottle;500;liquid",6,"each",null,0,0,0]
["0582195",271,"sauce:mint;bottle;150 ml;thick liquid",6,"each",null,0,0,0]
["0567839",272,"sauce:puree;apple;bottle;425 g",6,"each",null,0,0,0]
["0649775",273,"sauce:tabasco;red pepper;bottle;60 ml",36,"each",null,0,0,0]
["0649924",274,"sauce:all gold;tomato and onion all mix 3kg",2,"each",null,0,0,0]
["0749575",275,"sauce:tomato pronto; knorr;can;2 kg",1,"each",null,0,0,0]
["0744779",276,"sauce:all gold;tomato;sachets 200;8 g",1,"each",null,0,0,0]
["0747456",277,"sauce:tabasco pepper;hot;bottle;350 mm",6,"each",null,0,0,0]
["0649771",278,"sauce:fine food;mustard;2 l;thick liquid",6,"each",null,0,0,0]
[]
[null,null,"Spices"]
[]
["0747399",{"$f":"B342+1","v":279},"1kg Original ground chip & potato seasoning         ",198,"kg",null,{"$f":"ROUND(D346*F346,2)","v":0},{"$f":"ROUND(G346*0.15,2)","v":0},{"$f":"ROUND(G346+H346,2)","v":0}]
["0736903",{"$f":"B346+1","v":280},"Seasoning:for popcorn spice;ground;1 kg",3,"kg",null,0,"",""]
["0649815",{"$f":"B347+1","v":281},"800g All in one curry powder",317,"tub",null,0,{"$f":"ROUND(G348*0.15,2)","v":0},{"$f":"ROUND(G348+H348,2)","v":0}]
["0576520",282,"1kg Robertson BBQ",317,"tub",null,0,0,0]
["0576580",283,"1kg Ground cajun caterers choice",317,"kg",null,0,0,0]
["0576620",284,"800g Cayenne",158,"tub",null,0,0,0]
["0576450",285,"1Kg Robertsons portuguese",475,"tub",null,0,0,0]
["0582224",286,"800g Rajah medium curry powder",475,"tub",null,0,0,0]
["0672259",287,"800g Maggi jus",317,"tub",null,0,0,0]
["0576508",288,"800g Robertsons black peper",317,"tub",null,0,0,0]
["0576564",289,"700g Robertsons ground peri-peri",317,"tub",null,0,0,0]
["0576502",290,"1kg Robertsons chicken ",475,"tub",null,0,0,0]
["0576558",291,"1kg Robertsons fish spice",475,"tub",null,0,0,0]
["0649805",292,"1kg Robertsons jikelele barbeque",475,"tub",null,0,0,0]
["0576587",293,"700g Robertsons paprika",475,"tub",null,0,0,0]
["0183731",294,"1kg Robertsons veggie seasoning",475,"tub",null,0,0,0]
["0576554",295,"1kg Robertsons savoury rice     ",475,"tub",null,0,0,0]
["0183840",296,"Knorr aromat seasoning",475,"tub",null,0,0,0]
["0567845",297,"1kg Robertsons steak and chops         ",475,"tub",null,0,0,0]
["0576439",298,"800g Robertsons tumeric  ",475,"tub",null,0,0,0]
["0583632",299,"800g Robertsons white pepper             ",475,"tub",null,0,0,0]
["0576507",300,"600g Robertsons ground cinnamon",317,"tub",null,0,0,0]
["0713334",301,"55g Robertsons nutmeg         ",79,"each",null,0,0,0]
["0582297",302,"200g Robertsons mixed herbs",317,"tub",null,0,0,0]
["0747219",303,"1kg Tikka masala curry powder",119,"kg",null,0,0,0]
["0576591",304,"1kg Robertsons meat tenderizer  ",198,"kg",null,0,0,0]
["0583585",305,"1kg Robertsons cloves  ",158,"tub",null,0,0,0]
["0713330",306,"1kg crushed chillies",30,"kg",null,0,0,0]
["0749573",307,"spice:black peppercorn whole robertsons",6,"each",null,0,0,0]
["0747396",308,"spice:chicken breading knorr;plastic bag",10,"each",null,0,0,0]
["0747224",309,"spice:chilli bite mix;250 g",6,"each",null,0,0,0]
["0747394",310,"spice:chilli powder;plastic bag;250 g",4,"each",null,0,0,0]
["0747403",311,"spice:six gun grill;plastic tub;1 kg",198,"each",null,{"$f":"ROUND(D378*F378,2)","v":0},0,0]
["0747608",312,"spice:star anise whole;plastic bag;1 kg",10,"each",null,0,0,0]
["0576404",313,"spice:black pepper sachets;0.62 g;ground",79,"each",null,0,{"$f":"ROUND(G380*0.15,2)","v":0},{"$f":"ROUND(G380+H380,2)","v":0}]
["0576451",314,"spice:rosemary robertsons;plastic tub",6,"each",null,0,0,0]
["0187120",315,"spice:whole parsley robertsons;150 g",150,"each",null,0,0,0]
["0745334",316,"200g Robertsons origanum",158,"tub",null,0,0,0]
["0747121",317,"2kg knorr or equivalent potato mash flakes",6,"each",null,0,0,0]
["0583546",318,"1.6kg  Knorr professional hearty beef soup",30,"each",null,0,0,0]
["0583554",319,"1.6kg Knorr professional brown onion soup",6,"each",null,0,0,0]
["0583571",320,"1.6kg Knorr professional oxtail soup",30,"each",null,0,0,0]
["0583614",321,"1.6kg Knorr professional chicken soup",30,"each",null,0,0,0]
["0583570",322,"1.6kg Knorr professional Minestrone Soup",30,"each",null,0,0,0]
["0747368",323,"1.6kg Knorr professional mushroom soup",30,"tub",null,0,0,0]
["0748331",324,"1kg Bay leaves",100,"packet",null,0,0,0]
["0747400",325,"200g Cinnamon sticks",50,"each",null,0,0,0]
["0747229",326,"clove:plastic bag;500 g",2,"each",null,0,0,0]
["0747398",327,"coriander:plastic bag;1 kg",10,"each",null,0,0,0]
["0747453",328,"sunflower seed:plastic bag;1 kg",4,"each",null,0,0,0]
["0744650",329,"seed:chia;plastic packet 1 kg",2,"each",null,0,0,0]
["0747404",330,"sesame seed:black;plastic bag;1 kg",36,"each",null,0,0,0]
["0747405",331,"sesame seed:white;plastic bag;1 kg",36,"each",null,0,0,0]
["0748315",332,"seed:pumpkin green;plastic bag 1 kg",6,"each",null,0,0,0]
["0748323",333,"seed:poppy blue;plastic bag 1 kg",30,"each",null,0,0,0]
[779413,334,"All Purpose spice fo sho or equivalent",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[]
[null,null,"Spread"]
[]
["0748326",{"$f":"B401+1","v":335},"spread:nutella smooth;chocolate;grade a",1,"each",null,{"$f":"ROUND(D405*F405,2)","v":0},{"$f":"ROUND(G405*0.15,2)","v":0},{"$f":"ROUND(G405+H405,2)","v":0}]
["0649857",{"$f":"B405+1","v":336},"spread:black cat;peanut butter;bottle",10,"each",null,0,0,0]
["0746891",{"$f":"B406+1","v":337},"spread:bar one; nestle;chocolate;grade a",1,"each",null,0,0,0]
["0649855",338,"spread:bovril;beef extract;bottle;250 g",4,"each",null,0,0,0]
["0748710",339,"spread:lemon curd;citrus;grade a;6 kg",10,"each",null,0,0,0]
["0747119",340,"peanut butter:smooth;2.5 kg",198,"each",null,0,0,0]
["0748327",341,"butter:ghee; clover;plastic container",2,"each",null,0,0,0]
[]
[null,null,"Stock"]
["0649859",{"$f":"B411+1","v":342},"1kg Knorr beef granules",475,"tub",null,{"$f":"ROUND(D414*F414,2)","v":0},{"$f":"ROUND(G414*0.15,2)","v":0},{"$f":"ROUND(G414+H414,2)","v":0}]
["0649860",{"$f":"B414+1","v":343},"1kg Knorr chicken",475,"tub",null,0,0,0]
["0582298",{"$f":"B415+1","v":344},"1kg Knorr vegetable      ",475,"tub",null,0,0,0]
["0746464",345,"stock:box; 5 in a pack;400 g",1,"each",null,0,0,0]
["0746462",346,"stock:soya mince mutton flavour knorrox",1,"each",null,0,0,0]
["0746461",347,"stock:box; 5 in a pack;400 g",1,"each",null,0,0,0]
["0746465",348,"stock:soya mince chicken flavour knorrox",6,"each",null,0,0,0]
["0746466",349,"stock:soya mince savoury flavour knorrox",6,"each",null,0,0,0]
["0746475",350,"stock:soya mince;plastic bag;1 kg",6,"each",null,0,0,0]
["0746477",351,"stock:gravy;plastic packet;1 kg;powder",30,"each",null,0,0,0]
["0748316",352,"stock:classic roast onion gravy; knorr",6,"each",null,0,0,0]
[]
[null,null,"Sugar"]
["0582232",{"$f":"B424+1","v":353},"1kg Selati brown sugar",792,"bag",null,{"$f":"ROUND(D427*F427,2)","v":0},{"$f":"ROUND(G427*0.15,2)","v":0},{"$f":"ROUND(G427+H427,2)","v":0}]
["0582303",{"$f":"B427+1","v":354},"25kg White sugar                                         ",317,"bag",null,0,0,0]
["0582304",{"$f":"B428+1","v":355},"1kg Icing sugar                                                  ",396,"kg",null,0,0,0]
["0689901",356,"sugar brown: packet;10kg; granules",6,"each",null,0,0,0]
["0690366",357,"sugar brown: packet;5 kg: granules",4,"each",null,0,0,0]
["0183670",358,"sugar brown: sachet 5kg: 5g tubes: box 1000",4,"each",null,0,0,0]
["0746984",359,"sugar: castor 25 kg: superfine granules: pure white",2,"each",null,0,0,0]
["0746892",360,"sugar brown:plastic bag;750 g",10,"each",null,0,0,0]
["0582275",361,"sugar brown:sachet;12 kg;crystalline",4,"each",null,0,0,0]
["0582197",362,"sugar:white sachet 5kg: 5g tubes: box 1000",4,"each",null,0,0,0]
["0649877",363,"sugar : Hullets: packet;5 kg: granules",20,"each",null,0,0,0]
[]
[null,null,"Syrup"]
["0672260",{"$f":"B437+1","v":364},"500ml Marple syrup                  ",24,"bottle",null,{"$f":"ROUND(D440*F440,2)","v":0},{"$f":"ROUND(G440*0.15,2)","v":0},{"$f":"ROUND(G440+H440,2)","v":0}]
["0747457",{"$f":"B440+1","v":365},"2L Carte d'or chocolate sauce",36,"bottle",null,0,0,0]
["0747840",{"$f":"B441+1","v":366},"syrup:carte d'or milkshake bubblegum;1 l",4,"each",null,0,0,0]
["0747839",367,"syrup:carte d'or milkshake chocolate;1 l",4,"each",null,0,0,0]
["0748558",368,"syrup:carte d'or milkshake lime;1 l",4,"each",null,0,0,0]
["0747838",369,"syrup:carte d'or milkshake strawberry;1",4,"each",null,0,0,0]
["0750117",370,"syrup:maple;plastic container;3.5 kg",72,"each",null,0,0,0]
["0747607",371,"syrup:mint mix;bottle;1 l",3,"each",null,0,0,0]
["0583549",372,"syrup:golden illovo;plastic bottle;500 g",10,"each",null,0,0,0]
[]
[null,null,"Vinegar"]
[]
["0672128",{"$f":"B448+1","v":373},"1L Vesu balsamic                  ",396.00000000000006,"bottle",null,{"$f":"ROUND(D452*F452,2)","v":0},{"$f":"ROUND(G452*0.15,2)","v":0},{"$f":"ROUND(G452+H452,2)","v":0}]
["0672129",{"$f":"B452+1","v":374},"1L Vesu red                               ",198.00000000000003,"bottle",null,{"$f":"ROUND(D453*F453,2)","v":0},{"$f":"ROUND(G453*0.15,2)","v":0},{"$f":"ROUND(G453+H453,2)","v":0}]
["0649936",{"$f":"B453+1","v":375},"5L white 5 pct                           ",100,"bottle",null,{"$f":"ROUND(D454*F454,2)","v":0},{"$f":"ROUND(G454*0.15,2)","v":0},{"$f":"ROUND(G454+H454,2)","v":0}]
["0749634",376,"Apple cider; organic;750 ml",4,"each",null,{"$f":"ROUND(D455*F455,2)","v":0},{"$f":"ROUND(G455*0.15,2)","v":0},{"$f":"ROUND(G455+H455,2)","v":0}]
["0649934",377,"Balsamic brown;bottle;500 ml",3,"each",null,0,0,0]
["0746479",378,"Balsamic glaze reduction;500 ml",3,"each",null,0,0,0]
["0746631",379,"vinegar:black;glass bottle;1 l",3,"each",null,0,0,0]
["0748963",380,"vinegar:brown;plastic container;5 l",2,"each",null,0,0,0]
["0583553",381,"vinegar:red wine;bottle;500 ml",2,"each",null,0,0,0]
["0748964",382,"vinegar:rice;plastic container;5 l",396,"each",null,0,0,0]
["0672130",383,"vinegar:sachets, fine foods, 1000;box",1,"each",null,0,0,0]
["0748965",384,"vinegar:white wine;bottle;1 l",1,"each",null,0,0,0]
[]
[null,null,"Yeast"]
["0649939",{"$f":"B463+1","v":385},"10g Instant dry granules sachets box of 48",40,"box",null,{"$f":"ROUND(D466*F466,2)","v":0},{"$f":"ROUND(G466*0.15,2)","v":0},{"$f":"ROUND(G466+H466,2)","v":0}]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF BEVERAGES"]
[]
[null,null,"Juice (Fruit)"]
["0184699",{"$f":"B466+1","v":386},"5L Magalies Fruitcocktail                        ",3168.0000000000005,"bottle",null,{"$f":"ROUND(D471*F471,2)","v":0},{"$f":"ROUND(G471*0.15,2)","v":0},{"$f":"ROUND(G471+H471,2)","v":0}]
["0672580",{"$f":"B471+1","v":387},"5L Magalies Guava bust     ",3168.0000000000005,"bottle",null,0,0,0]
["0654799",{"$f":"B472+1","v":388},"5L Magalies Orange       ",3168.0000000000005,"bottle",null,0,0,0]
["0187121",389,"2L Lemon fruit     ",396.00000000000006,"bottle",null,0,0,0]
["0750114",390,"300ml Liquid 100% tropical (24 cans per case)            ",360,"case",null,0,0,0]
["0750113",391,"300ml Liquid 100% passion fruit (24 cans per case)      ",360,"case",null,0,0,0]
["0750139",392,"300ml Liquid 100%  clear apple (24 cans per case)      ",360,"case",null,0,0,0]
["0750116",393,"300ml Liquid 100% orange  (24 cans per case)      ",360,"case",null,0,0,0]
["0750110",394,"300ml Liquid 100% mango and orange (24 cans per case)      ",360,"case",null,0,0,0]
["0750111",395,"300ml Liquid 100% breakfast punch (24 cans per case)      ",360,"case",null,0,0,0]
["0750112",396,"300ml Liquid 100% cranberry (24 cans per case)      ",360,"case",null,0,0,0]
["0750115",397,"300ml Liquid 100% berry blaze (24 cans per case) ",360,"each",null,{"$f":"ROUND(D482*F482,2)","v":0},{"$f":"ROUND(G482*0.15,2)","v":0},{"$f":"ROUND(G482+H482,2)","v":0}]
["0713316",398,"750ml Roses ginger ",158,"bottle",null,0,0,0]
["0567337",399,"750ml Roses lime                                   ",158,"bottle",null,0,0,0]
["0713595",400,"750ml Roses blueberry       ",158,"bottle",null,0,0,0]
["0713318",401,"750ml Roses watermelon                 ",158,"bottle",null,0,0,0]
["0567336",402,"750ml Roses kola tonic",198,"bottle",null,0,0,0]
["0187106",403,"750ml Liquid passion fruit",24,"bottle",null,0,0,0]
["0767828",404,"2L Liqui fruit 100% orange",36,"box",null,0,0,0]
["0767871",405,"2L Liqui fruit 100% mango and orange",36,"box",null,0,0,0]
["0767827",406,"2L Liqui fruit 100% clear apple",36,"box",null,0,0,0]
["0767826",407,"2L Liqui fruit 100% red grape",36,"box",null,0,0,0]
["0767825",408,"2L Liqui fruit 100% breakfast punch",36,"box",null,0,0,0]
["0767872",409,"2L Liqui fruit 100% cranberry",36,"box",null,0,0,0]
["0745338",410,"750ml tomato juice",48,"each",null,0,0,0]
["0715516",411,"750ml pink sparkling non alcoholic champagne ",48,"each",null,0,0,0]
["0715523",412,"wine sparkling: champagne non-alcoholic;750ml",48,"each",null,0,0,0]
["0715451",413,"wine sparkling: champagne non-alcoholic;750ml; white",48,"each",null,0,0,0]
["0728902",414,"wine sparkling: champagne non-alcoholic; 750ml; red",48,"each",null,0,0,0]
["0567952",415,"beverage:apple/pear;bottle 500 ml",4,"each",null,{"$f":"ROUND(D500*F500,2)","v":0},{"$f":"ROUND(G500*0.15,2)","v":0},{"$f":"ROUND(G500+H500,2)","v":0}]
[]
[null,null,"Soda/Fizzy drinks"]
["0567323",{"$f":"B500+1","v":416},"200ml Schweppes ginger ale (24 cans per case)      ",90,"case",null,{"$f":"ROUND(D503*F503,2)","v":0},{"$f":"ROUND(G503*0.15,2)","v":0},{"$f":"ROUND(G503+H503,2)","v":0}]
["0567331",{"$f":"B503+1","v":417},"200ml Shweppes lemonade (24 cans per case)      ",90,"case",null,0,0,0]
["0567339",{"$f":"B504+1","v":418},"200ml Shweppes dry lemon (24 cans per case)      ",90,"case",null,0,0,0]
["0567343",419,"200ml Shweppes tonic water (24 cans per case)      ",90,"case",null,0,0,0]
["0567345",420,"200ml Shweppes soda water (24 cans per case)      ",90,"case",null,0,0,0]
["0567456",421,"200ml Coca cola coke lite (24 cans per case)      ",90,"case",null,0,0,0]
["0567481",422,"200ml Coca cola coke zero (24 cans per case)      ",90,"case",null,0,0,0]
["0567485",423,"200ml Coca cola coke (24 cans per case)                        ",90,"case",null,0,0,0]
["0713319",424,"250ml Red bull sugar free (24 cans per case)       ",10,"case",null,0,0,0]
["0567335",425,"250ml Red bull (24 cans per case)    ",180,"case",null,0,0,0]
["0709409",426,"300ml Coca cola coke (24 cans per case)    ",360,"case",null,0,0,0]
["0709407",427,"300ml Coca cola coke light  (24 cans per case)    ",90,"case",null,0,0,0]
["0709408",428,"300ml Coca cola coke zero (24 cans per case)    ",90,"case",null,0,0,0]
["0709410",429,"300ml Coca cola crème soda (24 cans per case)    ",90,"case",null,0,0,0]
["0709420",430,"300ml Coca cola stoney ginger beer  (24 cans per case)            ",360,"case",null,0,0,0]
["0709411",431,"300ml Sweppes dry lemon (24 cans per case)    ",360,"case",null,0,0,0]
["0709412",432,"300ml Fanta grape (24 cans per case)    ",90,"case",null,0,0,0]
["0709413",433,"300ml Fanta orange  (24 cans per case)    ",360,"case",null,0,0,0]
["0709414",434,"300ml Fanta pineapple (24 cans per case)    ",90,"case",null,0,0,0]
["0709415",435,"300ml Granadilla twist   (24 cans per case)               ",90,"case",null,0,0,0]
["0709416",436,"300ml Coca cola iron brew  (24 cans per case)    ",180,"case",null,0,0,0]
["0709417",437,"300ml Lemon twist (24 cans per case)    ",240,"case",null,0,0,0]
["0709418",438,"300ml Sprite zero  (24 cans per case)    ",360,"case",null,0,0,0]
["0709419",439,"300ml Sprite (24 cans per case)    ",90,"case",null,0,0,0]
["0183650",440,"330ml Appletiser  (24 cans per case)            ",90,"case",null,0,0,0]
["0587005",441,"330ml Grapetiser  (24 cans per case)            ",90,"case",null,{"$f":"ROUND(D528*F528,2)","v":0},{"$f":"ROUND(G528*0.15,2)","v":0},{"$f":"ROUND(G528+H528,2)","v":0}]
["0709395",442,"440ml Coca cola coke  (24 cans per case)           ",90,"case",null,0,0,0]
["0709397",443,"440ml Fanta grape   (24 cans per case)         ",90,"case",null,0,0,0]
["0709398",444,"440ml Fanta orange   (24 cans per case)              ",90,"case",null,0,0,0]
["0709399",445,"440ml Fanta pineapple (24 cans per case)    ",90,"case",null,0,0,0]
["0709400",446,"440ml Granadilla twist  (24 cans per case)    ",90,"case",null,0,0,0]
["0709401",447,"440ml Iron brew  (24 cans per case)                               ",90,"case",null,0,0,0]
["0709402",448,"440ml Lemon twist  (24 cans per case)                 ",90,"case",null,0,0,0]
["0709403",449,"440ml Sprite zero  (24 cans per case)                    ",90,"case",null,0,0,0]
["0709405",450,"440ml Stoney ginger beer  (24 cans per case)              ",90,"case",null,0,0,0]
["0567455",451,"2l Coca cola coke( 6 Pack cases )",800,"case",null,0,0,0]
["0567471",452,"2L Coca cola cream soda ( 6 Pack cases )",60,"case",null,0,0,0]
["0567440",453,"2L Coca cola Sprite ( 6 Pack cases )",60,"case",null,0,0,0]
["0581094",454,"2L Coca cola Stoney ginger beer ( 6 Pack cases )",800,"case",null,0,0,0]
["0567487",455,"2L Fanta grape ( 6 Pack cases )",60,"case",null,0,0,0]
["0567474",456,"2L Fanta orange ( 6 Pack cases )",60,"case",null,0,0,0]
["0672038",457,"2L Schweppes granadilla twist ( 6 Pack cases )",60,"case",null,0,0,0]
["0672039",458,"2L Iron brew ( 6 Pack cases )",60,"case",null,0,0,0]
[]
[null,null,"Energy drinks"]
["0567462",{"$f":"B545+1","v":459},"Tiger blueberry energade               ",90,"case",null,0,0,0]
["0567470",{"$f":"B548+1","v":460},"Tiger citrus rush energade",90,"case",null,0,0,0]
["0567479",{"$f":"B549+1","v":461},"Tiger mixed berry energade",90,"case",null,0,0,0]
["0567332",462,"Coca cola lemon lime powerade ",90,"case",null,0,0,0]
["0567333",463,"500ml Naartjie powerade ",90,"case",null,0,0,0]
["0567334",464,"500ml Apple powerade",90,"case",null,0,0,0]
[]
[]
[null,null,"Milk"]
["0744396",{"$f":"B553+1","v":465},"1 litre Almond Breeze original almond milk",36,"litre",null,{"$f":"ROUND(D557*F557,2)","v":0},"Zero Rated",{"$f":"G557","v":0}]
["0746627",{"$f":"B557+1","v":466},"2L Full cream maas or sour cream",10,"each",null,{"$f":"ROUND(D558*F558,2)","v":0},{"$f":"ROUND(G558*0.15,2)","v":0},{"$f":"ROUND(G558+H558,2)","v":0}]
["0748783",{"$f":"B558+1","v":467},"creamer non dairy:rich's; versatie cream",950,"each",null,{"$f":"ROUND(D559*F559,2)","v":0},{"$f":"ROUND(G559*0.15,2)","v":0},{"$f":"ROUND(G559+H559,2)","v":0}]
["0744397",468,"1 litre Soya milk",12,"each",null,{"$f":"ROUND(D560*F560,2)","v":0},0,0]
["0744398",469,"1 litre coconut milk",12,"each",null,0,0,0]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF MISCELLANEOUS"]
[]
[null,null,"Sundries"]
["0187058",{"$f":"B561+1","v":470},"Apron food handler: Plastic packet of 100: common size: neck & waist ties",475,"packet",null,0,0,0]
["0582250",{"$f":"B566+1","v":471},"Bag: Pie bag;Paper Greaseproof;1000 180 HT x 140 WD mm",79,"packet",null,0,0,0]
["0568320",{"$f":"B567+1","v":472},"cap: disposable; mop; white; one size fits all box of 100",475,"packet",null,0,0,0]
["0187053",473,"cap: disposable: chef; paper: box of 50",79,"packet",null,0,0,0]
["0581821",474,"container storage;tub:250 ml-500 ml;plastic: pack of 100    ",2000,"tub",null,0,0,0]
["0582315",475,"pad cleaning: pot scrubbing: plastic ",198,"packet",null,0,0,0]
["0583965",476,"paper:greaseproof sheet:450 x 750 mm pack of 1000",79,"packet",null,0,0,0]
["0583956",477,"paper:silicone  sheet:450 x 750 mm;white pack of 1000",79,"packet",null,0,0,0]
["0672148",478,"ppr wrpg plstc ctd:wd  38 cm;lg 14000 cm;15 micron      ",317,"roll",null,0,0,0]
["0672147",479,"stirring stick beverage:tea; coffee;wooden; pack of 1000",198,"packet",null,0,0,0]
["0660545",480,"straw: breath analyser; paper; length 230 mm box of 1000",10,"tub",null,0,0,0]
["0649659",481,"fork tbl:white aro  250s 5;6 in;plastic                      ",396,"box",null,{"$f":"ROUND(D577*F577,2)","v":0},{"$f":"ROUND(G577*0.15,2)","v":0},{"$f":"ROUND(G577+H577,2)","v":0}]
["0649854",482,"spoon:dessert;plastic  pack of 250",396,"box",null,0,0,0]
["0582192",483,"knife table;60 mm;plastic pack of 250",75,"box",null,0,0,0]
["0581250",484,"stick:kebab:250 mm;wood ;100 in packet                                   ",198,"packet",null,0,0,0]
["0704958",485,"cup disposable: paper 250ml (Ripple paper cups with lids 50 in a pack)                     ",3000,"box",null,0,0,0]
["0672044",486,"lid:zibo plastic clear  250ml;12 cm  box of 200",2000,"box",null,0,0,0]
["0568347",{"$f":"B582+1","v":487},"cake:board;round;plastic  bag box of 100",158,"box",null,{"$f":"ROUND(D583*F583,2)","v":0},{"$f":"ROUND(G583*0.15,2)","v":0},{"$f":"ROUND(G583+H583,2)","v":0}]
["0568334",488,"charcoal:braai;5 kg                                            ",396,"bag",null,0,0,0]
["0187056",489,"doily:240 mm;100 in box                                                      ",158,"box",null,0,0,0]
["0183801",490,"serviette:plain. 1  ply·paper:white box of 1000",1188,"box",null,0,0,0]
["0746540",491,"lighter;gas;gun type;plastic;long nozzle ",10,"packet",null,0,0,0]
["0768465",492,"ziplock food sample bags;200mm x 200mm 1000 unit",24,"each",null,0,0,0]
["0582242",493,"heavy duty foil 70m",200,"each",null,0,0,0]
["0159771",{"$f":"B589+1","v":494},"cleaner:degreaser;liquid;handy andy 750ml",396,"bottle",null,{"$f":"ROUND(D590*F590,2)","v":0},{"$f":"ROUND(G590*0.15,2)","v":0},{"$f":"ROUND(G590+H590,2)","v":0}]
["0583966",495,"cloth;jumbo wiper roll; wide 250mm; cotton",198,"roll",null,0,0,0]
["0159845",496,"detergent;sunlight:dishwashing:750 ml         ",792,"bottle",null,0,0,0]
["0672151",497,"glove disposable: large;length 23 cm;polythene; colour blue           ",792,"box",null,0,0,0]
["0710006",498,"soap  laundry:powder:plastic bag:5 kg           ",40,"bag",null,0,0,0]
["0672114",499,"fire lighter:matches:box·1g ",396,"box",null,0,0,0]
["0576526",500,"fire lighter:spirit jelly chafer fuel box of 24 ;250ml",158,"box",null,0,0,0]
["0768466",501,"350 ml disposable plastic cups with lids",36,"each",null,{"$f":"ROUND(D597*F597,2)","v":0},{"$f":"ROUND(G597*0.15,2)","v":0},{"$f":"ROUND(G597+H597,2)","v":0}]
["0672152",502,"270 x 218 mm;87 ml;polystyrene 3- division fomo 53 food tray take away",317,"each",null,{"$f":"ROUND(D598*F598,2)","v":0},{"$f":"ROUND(G598*0.15,2)","v":0},{"$f":"ROUND(G598+H598,2)","v":0}]
["0747406",503,"cutlery and condiment:disposable plastic white : set",10,"each",null,0,0,0]
["0746986",504,"frwood:sekelbos dry; hardwood;wd 8 to 12",6,"each",null,0,0,0]
["0582243",505,"fire lighter:blitz;box;500 g",6,"each",null,0,0,0]
["0582238",506,"bag:carrier;wd 260 x lg 240 x ht 10 mm",80,"each",null,0,0,0]
["0742373",507,"cap dspsbl:white;34 x 26 cm",50,"each",null,0,0,0]
["0672146",508,"spoon:tea;wooden;10.5 x 2 x 1 cm",40,"each",null,0,0,0]
["0583995",509,"pad cleaning :pot scorer; metal; plastic",20,"each",null,0,0,0]
["0746482",510,"paper test:1 to 2.5 pct",25,"each",null,0,0,0]
["0747120",511,"paper filter: diameter 200- 250mm wide x 250mm height;50 um",20,"each",null,0,0,0]
["0749044",512,"bag:piping pastry; disp;red colour logo",2,"each",null,0,0,0]
["0748329",513,"plate eating: high quality paper; diameter 23 cm",80,"each",null,0,0,0]
["0749907",514,"decoration, cake:plastic container;140 g",4,"each",null,0,0,0]
["0746987",515,"additive:soy lecithin;plastic bag; 500 g",12,"each",null,0,{"$f":"ROUND(G611*0.15,2)","v":0},0]
["0748328",{"$f":"B611+1","v":516},"utensil:chop sticks wrapped; 21 cm long",20,"each",null,0,0,0]
["0582209",517,"hinge:sandwich 2 slice;150*250 mm",20,"each",null,{"$f":"ROUND(D613*F613,2)","v":0},{"$f":"ROUND(G613*0.15,2)","v":0},{"$f":"ROUND(G613+H613,2)","v":0}]
[779225,{"$f":"B613+1","v":518},"12cm Muffin cups pack of 500",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779275,519,"No.8 SO8  90mm x 301mm Brown kraft paper bag pack of 150 ",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779279,520,"Medium size brown paper bag with twist handles pack of 100",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779301,521,"150ml Square clear plastic dessert tubs with lids pack of 20",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779226,522,"Small size disposable bamboo boats pack of 20",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779226,523,"Medium size disposable bamboo boats pack of 20",null,"each",null,"Rate Only","Rate Only","Rate Only"]
[779226,524,"Large size disposable bamboo boats pack of 20",null,"each",null,"Rate Only","Rate Only","Rate Only"]
["0583965",525,"12 Micron Heavy duty cling wrap size 380mm x 1000m ",null,"each",null,"Rate Only","Rate Only","Rate Only"]
{"$rows_empty":38}
[null,"SUB TOTAL FOR KITCHEN GROCERIES- CARRIED TO FINAL SUMMARY",{"$nulls":4},{"$f":"SUM(G10:G659)","v":0},{"$f":"SUM(H10:H659)","v":0},{"$f":"SUM(I10:I659)","v":0}]

{"sheet":"2.TUCKSHOP BOQ","index":1,"n_rows":243,"n_cols":9,"rows_kept":243,"merged":[[242,1,242,5]]}
["ITEM CODE","ITEM NO","DESCRIPTION","36 MONTH QTY","UOM","RATE EXCL VAT","AMOUNT EXCL VAT","VAT AMOUNT","TOTAL AMOUNT INCL VAT"]
[null,null,"TUCKSHOP"]
[null,null,"GROCERIES"]
[null,null,"BILL NO.2"]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF DRY GOODS"]
[]
[null,null,"Biscuits"]
["0568337",1,"2kg Bakers choice assorted",360,"packet",null,{"$f":"ROUND(D9*F9,2)","v":0},{"$f":"ROUND(G9*0.15,2)","v":0},{"$f":"ROUND(G9+H9,2)","v":0}]
["0187110",{"$f":"B9+1","v":2},"200g Bakers eat sumore (box of 12)",360,"box",null,{"$f":"ROUND(D10*F10,2)","v":0},{"$f":"ROUND(G10*0.15,2)","v":0},{"$f":"ROUND(G10+H10,2)","v":0}]
["0187114",{"$f":"B10+1","v":3},"200g Bakers lemon creams (box of 12)",360,"box",null,0,0,0]
["0568340",4,"1kg  Pyotts snack time",360,"packet",null,{"$f":"ROUND(D12*F12,2)","v":0},{"$f":"ROUND(G12*0.15,2)","v":0},{"$f":"ROUND(G12+H12,2)","v":0}]
["0187112",5,"200g Royal cream (box of 12)",360,"box",null,0,0,0]
["0187111",6,"200g Tennis (box of 12)",360,"box",null,0,0,0]
["0744638",7,"biscuit:boudoir bakers;box;200 g x 15",2,"each",null,0,{"$f":"ROUND(G15*0.15,2)","v":0},{"$f":"ROUND(G15+H15,2)","v":0}]
["0744648",8,"crackers:crisp cream bakers;box;200 g x 12",4,"each",null,0,0,0]
["0744635",9,"biscuit:digestive bakers;original;box of 12",4,"each",null,0,0,0]
["0744639",10,"biscuit:bakers ginger nuts;box;190 g",24,"each",null,0,0,0]
["0744641",11,"biscuit:good morning bakers;box;300 g x 12",2,"each",null,0,0,0]
["0744633",12,"biscuit:bakers blue label marie;200 g x 12",5,"each",null,0,0,0]
["0744647",13,"crackers:bakers mini cheddars;6 x 33 g",20,"each",null,0,0,0]
["0744634",14,"biscuit:oreo original;box;128g x 20",6,"each",null,0,0,0]
["0744637",15,"biscuit:bakers provita rice cake;plain",12,"each",null,0,0,0]
["0744640",16,"biscuit:wheatsworth bakers;box;200 g x 12",4,"each",null,0,0,0]
["0744636",17,"biscuit:good morning bakers;chocolate",2,"each",null,0,0,0]
["0744631",18,"biscuit:good morning bakers;box;300 g x 12",2,"each",null,0,0,0]
["0744641",19,"biscuit:good morning bakers;box;300 g x 12",2,"each",null,0,0,0]
["0744630",20,"biscuit:good morning bakers;box;300 g x 12",2,"each",null,0,0,0]
["0744632",21,"biscuit:pretzels;salt;plastic bag;500 g",30,"each",null,0,0,0]
[]
[null,null,"Candy"]
["0568442",{"$f":"B29+1","v":22},"Airwaves Gum; Blackcurrent; Box of 30",36,"Box",null,0,0,0]
["0576571",{"$f":"B32+1","v":23},"Airwaves Gum; Cherry Menthol;Box of 30",36,"Box",null,0,0,0]
["0568443",{"$f":"B33+1","v":24},"Airwaves Gum; Green Mint;Box 14g of 30",36,"Box",null,0,0,0]
["0568444",25,"Astros; Assorted;Round;Box of 40: 38g",36,"Box",null,0,0,0]
["0583912",26,"Chappies; Fruit;Square;Bag Plastic of 100",36,"packet",null,0,0,0]
["0583913",27,"Chappies; Grape;Square;Bag Plastic of 100",36,"packet",null,0,0,0]
["0583914",28,"Chappies; Mint;Square;Bag Plastic of 100",36,"packet",null,0,0,0]
["0583915",29,"Chappies; Spearmint;Square;3125 of 100",36,"packet",null,0,0,0]
["0568446",30,"Chappies; Water Melon;Square;Packet of 100",36,"packet",null,0,0,0]
["0583916",31,"Chappies; Wicks;Square;Bag Plastic of 100",12,"packet",null,0,0,0]
["0581273",32,"Clorets Gum;Eliminator;Rectangular box of 24x 10piece",36,"Box",null,0,0,0]
["0582309",33,"Clorets Gum; Fresh Mint; Rectangular box of 24x 10piece",24,"Box",null,0,0,0]
["0576654",34,"Clorets Gum; Original; Rectangular box of 24x 10piece",36,"Box",null,0,0,0]
["0583920",35,"Dentyne Gum;Gentle Mint; Box;12g box of 50",24,"Box",null,0,0,0]
["0583969",36,"Dentyne Gum;Peppermint; Rectangular box of 50",24,"Box",null,0,0,0]
["0583921",37,"Dentyne Gum;Spearmint; Rectangular box of 50",2,"Box",null,0,0,0]
["0576452",38,"Dentyne Gum;Strawberry; Rectangular box of 50",2,"Box",null,0,0,0]
["0584247",39,"Fizz Pop;Apple; Plastic Tub; 20.5g",36,"Tub",null,0,0,0]
["0582277",40,"Fizz Pop;Crème Soda; Plastic Tub",36,"Tub",null,0,0,0]
["0584256",41,"Fizz Pop;Grape; Plastic Tub; 20.5g",24,"Tub",null,0,0,0]
["0187040",42,"Fizz Pop;Humbugs;Plastic Tub",12,"Tub",null,0,0,0]
["0584238",43,"Fizz Pop;Strawberry;Plastic Tub",36,"Tub",null,0,0,0]
["0581081",44,"Halls Sweets;Cherry; Square;Box",24,"Box",null,0,0,0]
["0576436",45,"Halls; Extra Strong; Square;Box 54g",36,"Box",null,0,0,0]
["0576519",46,"Halls; Honey & Lemon;Square; Box",24,"Box",null,0,0,0]
["0576402",47,"Halls; Honey;Square; Box;54g",24,"Box",null,0,0,0]
["0576569",48,"Halls; Menthol;Square; Box;54g",24,"Box",null,0,0,0]
["0576601",49,"Halls; Mentholyptus;Square; Box;54g",36,"Box",null,0,0,0]
["0576425",50,"Halls; Spearmint;Square; Box;54g",24,"Box",null,0,0,0]
["0576621",51,"Jelly Tots Large; Berries;Round;Box of 40",24,"Box",null,0,0,0]
["0576477",52,"Jelly Tots Large; Original;Round of 40",36,"Box",null,0,0,0]
["0576594",53,"Jelly Tots Large; Sour;Round;Box of 40",18,"Box",null,0,0,0]
["0582278",54,"Maynard Wine Gums; Assorted;Round",36,"Box",null,0,0,0]
["0576527",55,"Mentos;Grape; Roll; Box 37,5g x 40",30,"Box",null,0,0,0]
["0576506",56,"Mentos;Mint; Roll; Box 37,5g x 40",30,"Box",null,0,0,0]
["0583923",57,"Mentos;Rainbow; Roll; Box 37,5g x 40",30,"Box",null,0,0,0]
["0576423",58,"Mentos;Spearmint; Roll; Box 37,5g x 40",24,"Box",null,0,0,0]
["0576618",59,"Mentos;Strawberry; Roll; Box 37,5g x 40",30,"Box",null,0,0,0]
["0581066",60,"Stimorol Gum; Cherry Menthol;Box 14g x 12",30,"Box",null,0,0,0]
["0581134",61,"Stimorol Gum; Original;Rectangular 14g x 12",30,"Box",null,0,0,0]
["0583924",62,"Stimorol Gum; Spearmint;Rectangular 14g x 12",30,"Box",null,0,0,0]
["0581028",63,"Stimorol Gum; Wicks Mint;Box 12g",12,"Box",null,0,0,0]
["0581109",64,"Stimorol Gum; Wild Cherry;Box 12g",36,"Box",null,0,0,0]
["0581135",65,"Stimorol; Cinnamon;Rectangular;Box ",36,"Box",null,0,0,0]
["0576465",66,"Super C Energy; Orange, Round; Box  36.9g x 24 ",36,"Box",null,0,0,0]
["0576652",67,"Super C Energy; Pineapple, Round; Box 36.9g x 24 ",36,"Box",null,0,0,0]
["0576633",68,"Super C Energy; Tangerine, Round; Box  36.9g x 24 ",36,"Box",null,0,0,0]
["0584248",69,"Yogueta Lollipop; Tangerine, Assorted; 21g",36,"packet",null,0,0,0]
["0584255",70,"Turnbull Sweets;Butterscotch 5kg                  ",180,"box",null,0,0,0]
["0584240",71,"Turnbull Sweets;Mint:Bag Plastic  5kg",180,"box",null,0,0,0]
["0582244",72,"Endearmints:Original:Round:1kg",180,"box",null,0,0,0]
["0576533",73,"candy:smarties medium;chocolate;box of 24",36,"box",null,0,{"$f":"ROUND(G83*0.15,2)","v":0},{"$f":"ROUND(G83+H83,2)","v":0}]
["0744649",74,"candy:jelly babies;beacon;plastic packet",2,"box",null,{"$f":"ROUND(D84*F84,2)","v":0},0,0]
["0747161",75,"candy:maynards jelly beans;fruity;60 g",2,"box",null,0,0,0]
[]
[null,null,"Chips"]
["0576619",{"$f":"B85+1","v":76},"Crinkle Cut;Simba;Mexican Chilli box of 48",36,"Box",null,0,0,0]
["0649501",{"$f":"B88+1","v":77},"Crinkle Cut;Simba;Salt and Vinegar box of 48",30,"Box",null,0,0,0]
["0576472",{"$f":"B89+1","v":78},"Crinkle Cut;Simba;Tomato; Box; 36g box of 48",24,"Box",null,0,0,0]
["0584001",79,"Niknaks; Simba;Cheese;Box; 55g box of 48",36,"Box",null,0,0,0]
["0576648",80,"Plain;Big Corn Bites; BBQ,Box; 50g box of 48",36,"Box",null,0,0,0]
["0576557",81,"Plain;Big Corn Bites; Spicy;Box; 50g box of 48",12,"Box",null,{"$f":"ROUND(D93*F93,2)","v":0},{"$f":"ROUND(G93*0.15,2)","v":0},{"$f":"ROUND(G93+H93,2)","v":0}]
["0576413",82,"Plain;Big Corn Bites; Tomato;Box box of 48",36,"Box",null,0,0,0]
["0576411",83,"Plain;Doritos; Cheese Supreme; Box box of 48",36,"Box",null,0,0,0]
["0576493",84,"Plain;Doritos; Sweet Chilli Pepper box of 48",25,"Box",null,0,0,0]
["0576442",85,"Plain;Fritos;Barbeque; Box; 50g x 48",2,"Box",null,0,0,0]
["0576438",86,"Plain;Fritos;Tomato; Box; 50g x 48",2,"Box",null,0,0,0]
["0576429",87,"Plain;Lays;Lightly Salted;Box;36g x 48",36,"Box",null,0,0,0]
["0576503",88,"Plain;Lays:Peppadew;Box;36g x 48",24,"Box",null,0,0,0]
["0576410",89,"Plain·Lays;Salt and Vinega:Box x 48",36,"Box",null,0,0,0]
["0576525",90,"Plain:Lays;Sour Cream and Onion;Box x 48",36,"Box",null,0,0,0]
["0576473",91,"Plain;Lays;Spring Cheese & Onion x 48",36,"Box",null,0,0,0]
["0576575",92,"Plain;Lays;Thai Sweet Chilli;Box x 48",36,"Box",null,0,0,0]
["0649494",93,"Plain;Simba;Cheese and Onion;Pkt box of 48",36,"Box",null,0,0,0]
["0747231",94,"corn:popcorn jumping jack;grade a;100 g Gourmet white cheddar",4,"each",null,0,{"$f":"ROUND(G106*0.15,2)","v":0},{"$f":"ROUND(G106+H106,2)","v":0}]
["0747231",95,"corn:popcorn jumping jack;grade a;100 g Gourmet cheese and green onion",6,"each",null,0,0,0]
[]
[null,null,"Chocolate"]
["0576592",{"$f":"B107+1","v":96},"Aero chunky;box·38 g;bar box of 40",24,"Box",null,0,0,0]
["0576482",{"$f":"B110+1","v":97},"Aero chunky;box:38 g: caramel:bar box of 40",24,"Box",null,0,0,0]
["0576427",{"$f":"B111+1","v":98},"Aero chunky;box:38 g:milky:bar box of 40",36,"Box",null,{"$f":"ROUND(D112*F112,2)","v":0},{"$f":"ROUND(G112*0.15,2)","v":0},{"$f":"ROUND(G112+H112,2)","v":0}]
["0567696",99,"Aero;box:45 g:milk;bar box of 40",36,"Box",null,0,0,0]
["0567698",100,"Aero:box;45g:peppermint;bar box of 40",24,"Box",null,0,0,0]
["0576495",101,"Aero;packet;45g;caramel:bar box of 40",12,"Box",null,0,0,0]
["0659859",102,"Bakels chockex dark:packet",400,"Box",null,0,0,0]
["0576614",103,"Bar one;box;100 g;bar",36,"Box",null,0,0,0]
["0576559",104,"Bar one;box;so g;peanut blast",36,"Box",null,0,0,0]
["0567700",105,"Bounty:box;52 g;bar",24,"Box",null,0,0,0]
["0582199",106,"Cadbury  tumbles;box;65 g of 36",30,"Box",null,0,0,0]
["0644497",107,"Chockex chips white:sox:1 kg",500,"Box",null,0,0,0]
["0576430",108,"Crunchie;box;40  g;bar  of 40",30,"Box",null,0,0,0]
["0576468",109,"Damascus  french nougat;75 g",30,"Box",null,0,0,0]
["0748330",110,"Ferrero Rocher 16 in pack",2,"Box",null,{"$f":"ROUND(D124*F124,2)","v":0},{"$f":"ROUND(G124*0.15,2)","v":0},{"$f":"ROUND(G124+H124,2)","v":0}]
["0584004",111,"chocolate:flake;box;32 g;cylinder",2,"each",null,{"$f":"ROUND(D125*F125,2)","v":0},{"$f":"ROUND(G125*0.15,2)","v":0},{"$f":"ROUND(G125+H125,2)","v":0}]
["0584244",112,"Jungle  enegy;box;40 g;bar box of 30                    ",36,"Box",null,0,0,0]
["0584249",113,"Jungle  energy;box;40g;banana  box of 30            ",36,"Box",null,0,0,0]
["0584241",114,"Jungle energy;box;40g;bar  box of 30                    ",36,"Box",null,0,0,0]
["0584253",115,"Jungle energy;box:40g; yoghurt   box of 30      ",36,"Box",null,0,0,0]
["0584236",116,"Jungle  energy;box;48g;berries  box of 30   ",36,"Box",null,0,0,0]
["0576479",117,"Lunch  bar;box;46g;bar box of 40            ",36,"Box",null,0,0,0]
["0576581",118,"Lunch bar;box;46g;original box of 40",36,"Box",null,0,0,0]
["0580141",119,"Peppermint crisp;box:49 g box of 40           ",30,"Box",null,0,0,0]
["0576640",120,"Ps:box:46g:caramel                               ",36,"Box",null,0,0,0]
["0576388",121,"Pvm energy bar:box:45g;bar box of 20                ",30,"Box",null,0,0,0]
["0576396",122,"Pvm energy bar;box;45 g;bar   box of 20                             ",30,"Box",null,0,0,0]
["0576422",123,"Pvm energy bar;box;45 g;bar box of 20                     ",30,"Box",null,0,0,0]
["0576499",124,"Pvm energy bar:box;45 g;bar box of 20                   ",30,"Box",null,0,0,0]
["0576524",125,"Pvm energy bar;box:45 g;bar box of 20               ",30,"Box",null,0,0,0]
["0576535",126,"Pvm energy bar;box:45 g;bar box of 20               ",30,"Box",null,0,0,0]
["0576548",127,"Pvm energy bar;box:45 g·bar box of 20                   ",30,"Box",null,0,0,0]
["0583954",128,"Pvm energy bar;box:45 g;bar box of 20               ",30,"Box",null,0,0,0]
["0584002",129,"Pvm  energy bar:box:45 g;bar box of 20                    ",30,"Box",null,0,0,0]
["0576603",130,"Snacker:box (24);45g:fruit                    ",30,"Box",null,0,0,0]
["0576397",131,"Snacker;box (24):45g:yogurt              ",24,"Box",null,0,0,0]
["0581102",132,"Snacker;box;45 g;muesll:bar box of 24            ",30,"Box",null,0,0,0]
["0576607",133,"Tex;box (401;40g:bar box of 40                                  ",24,"Box",null,0,0,0]
["0581043",134,"Tumbles;box:65g;raisins;round box of 40         ",30,"Box",null,0,0,0]
["0581115",135,"Tumbles·box;65g;shortcake box of 40              ",30,"Box",null,0,0,0]
["0576590",136,"Tv bar·box;47g;milk box of 40                                 ",24,"Box",null,0,0,0]
["0576610",137,"Tv bar;box;47g;white box of 40                            ",24,"Box",null,0,0,0]
["0583987",138,"Vermicelll 1 kg                 ",200,"kg",null,0,0,0]
["0184712",139,"chocolate:quality street;pkt;900 g",12,"each",null,0,{"$f":"ROUND(G153*0.15,2)","v":0},{"$f":"ROUND(G153+H153,2)","v":0}]
["0747848",140,"chocolate:quality street;packet;435 g",12,"each",null,{"$f":"ROUND(D154*F154,2)","v":0},0,0]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF MISCELLENEOUS"]
[]
[null,null,"Medicine"]
["0582300",{"$f":"B154+1","v":141},"Med lemon;powder sachet:72               ",36,"Box",null,0,0,0]
["0582248",{"$f":"B159+1","v":142},"Eno satchets;powder:box:72       ",36,"Box",null,0,0,0]
["0576406",{"$f":"B160+1","v":143},"Rennies:tablet;24;box;12                         ",36,"Box",null,0,0,0]
["0576538",144,"Compral:tablet:2 in a packet 106kg                 ",36,"Box",null,{"$f":"ROUND(D162*F162,2)","v":0},{"$f":"ROUND(G162*0.15,2)","v":0},{"$f":"ROUND(G162+H162,2)","v":0}]
["0582235",145,"Painkiller: disprin blue;tablet:box:96                   ",36,"Box",null,0,0,0]
["0576448",146,"Painkiller: disprin red:tablet:box :96           ",36,"Box",null,0,0,0]
["0576556",147,"Painkiller: grandpa ;powder:box:144        ",36,"Box",null,0,0,0]
["0576586",148,"Painkilr:panado:tablet;box:48       ",36,"Box",null,0,0,0]
["0582181",149,"Zam-buck;ointment;7g;tin;36              ",36,"Box",null,0,0,0]
["0582299",150,"Vicks vaporub;ointment;12g;tin              ",36,"Box",null,0,0,0]
["0576606",151,"Medicine painkiller: disprin blue;tablet;48 in box",36,"each",null,0,{"$f":"ROUND(G169*0.15,2)","v":0},{"$f":"ROUND(G169+H169,2)","v":0}]
[]
[null,null,"Cream"]
["0583997",{"$f":"B169+1","v":152},"Balm: lip care;plastic hard;4.8g box of 12                      ",12,"Box",null,0,0,0]
[]
[null,null,"Toothpaste"]
["0582227",{"$f":"B172+1","v":153},"Colgate 100ml;various;12                                   ",36,"Box",null,0,0,0]
[]
[null,null,"Cigarrettes"]
["0576637",{"$f":"B175+1","v":154},"cigarette tobac:dunhill;white infinite 10x20 in box",36,"each",null,0,{"$f":"ROUND(G178*0.15,2)","v":0},{"$f":"ROUND(G178+H178,2)","v":0}]
["0649532",{"$f":"B178+1","v":155},"cigarette tobac:courtleigh;lights hard 10x20 in box",36,"each",null,0,{"$f":"ROUND(G179*0.15,2)","v":0},{"$f":"ROUND(G179+H179,2)","v":0}]
["0576588",{"$f":"B179+1","v":156},"cigarette tobacco: peter stuyvesant;20;packet x 10 in box",36,"each",null,0,0,0]
["0576530",157,"cigarette tobacco: dunhill;menthol;20;packet x 10 in box",20,"each",null,0,0,0]
["0576391",158,"cigarette tobacco :Marlboro; original gold 10x20 in box",20,"each",null,0,0,0]
["0576622",159,"cigarette tobacco :peter stuyvesant;blue;20 x  10 in box",20,"each",null,0,0,0]
["0576598",160,"cigarette tobacco marlboro;standard;20;packet 10 x 20 in box",20,"each",null,0,0,0]
["0576466",161,"cigarette tobac:dunhill;infinite light 10 x 20 in box",20,"each",null,0,0,0]
["0576643",162,"cigarette tobacco :camel; lights hard;20;packet x 10 in box",20,"each",null,0,0,0]
["0576408",163,"cigarette tobacco: camel; filter hard;20;packet x 10 in box",20,"each",null,0,0,0]
[]
[null,null,"Sanitary pad"]
["0582206",{"$f":"B187+1","v":164},"Pad sntry:menstruation;yes;10       ",36,"each",null,0,0,0]
{"$rows_empty":52}
[null,"SUB TOTAL FOR TUCKSHOP GROCERIES- CARRIED TO FINAL SUMMARY",{"$nulls":4},{"$f":"SUM(G9:G242)","v":0},{"$f":"SUM(H9:H242)","v":0},{"$f":"SUM(I9:I242)","v":0}]

{"sheet":"3.WORKSHOP, CS, CONF & ROOM BOQ","index":2,"n_rows":81,"n_cols":9,"rows_kept":81,"merged":[[80,0,80,5]]}
["ITEM CODE","ITEM NO","DESCRIPTION","36 MONTH QTY","UOM","RATE EXCL VAT","AMOUNT EXCL VAT","VAT AMOUNT","TOTAL AMOUNT INCL VAT"]
[null,null,"WORKSHOP, COST CENTRES, CONFERENCES & ROOMS"]
[null,null,"GROCERIES"]
[null,null,"BILL NO.3"]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF DRY GOODS"]
[]
[null,null,"Coffee(Instant)"]
["0649571",1,"1.8g Nescafe classic sticks box of 200         ",9000,"box",null,{"$f":"ROUND(D9*F9,2)","v":0},{"$f":"ROUND(G9*0.15,2)","v":0},{"$f":"ROUND(G9+H9,2)","v":0}]
["0567701",{"$f":"B9+1","v":2},"1Kg Cappucino powder      ",2,"each",null,0,0,0]
["0707284",{"$f":"B10+1","v":3},"200g Jacobs ",250,"Jar",null,0,0,0]
["0745415",4,"200g Nestle decaf granules",6,"each",null,0,0,0]
["0708213",5,"1.8g  Jacobs instant granules pack of 26",4,"each",null,0,0,0]
["0649569",6,"200g Nescafe classic granules",6,"each",null,0,0,0]
["0649587",7,"1.8g Decaf Nescafe sticks box of 200",3,"each",null,0,0,0]
["0738174",8,"200g Nescafe gold granules",6,"each",null,0,0,0]
["0746480",9,"20g Ciro hot chocolate sticks box of 70",2,"each",null,0,0,0]
["0738252",10,"1kg Roasted to a medium to dark ",5,"each",null,0,0,0]
["0745414",11,"Hot chocolate sticks box of 70",2,"each",null,0,0,0]
["0161179",12,"1kg Hot chocolate",6,"kg",null,0,0,0]
[]
[null,null,"Powders"]
["0582198",{"$f":"B20+1","v":13},"Non dairy ellis brown sticks 4g box of 200",9000,"box",null,{"$f":"ROUND(D23*F23,2)","v":0},{"$f":"ROUND(G23*0.15,2)","v":0},{"$f":"ROUND(G23+H23,2)","v":0}]
[]
[null,null,"Sugar"]
["0707829",{"$f":"B23+1","v":14},"5kg Hullets brown tube sachets box of 1000     ",5000,"box",null,{"$f":"ROUND(D26*F26,2)","v":0},{"$f":"ROUND(G26*0.15,2)","v":0},{"$f":"ROUND(G26+H26,2)","v":0}]
["0604956",{"$f":"B26+1","v":15},"5kg Hullets white tube sachets box of 1000                        ",5000,"box",null,{"$f":"ROUND(D27*F27,2)","v":0},{"$f":"ROUND(G27*0.15,2)","v":0},{"$f":"ROUND(G27+H27,2)","v":0}]
["0582216",{"$f":"B27+1","v":16},"Canderel non sugar sweetener sachets box of 1000",30,"box",null,{"$f":"ROUND(D28*F28,2)","v":0},{"$f":"ROUND(G28*0.15,2)","v":0},{"$f":"ROUND(G28+H28,2)","v":0}]
[]
[null,null,"Tea"]
["0583599",{"$f":"B28+1","v":17},"2.5g Five roses tagged box of 200                  ",40,"box",null,{"$f":"ROUND(D31*F31,2)","v":0},{"$f":"ROUND(G31*0.15,2)","v":0},{"$f":"ROUND(G31+H31,2)","v":0}]
["0649888",{"$f":"B31+1","v":18},"2g Rooibos laager box of 200               ",40,"box",null,{"$f":"ROUND(D32*F32,2)","v":0},{"$f":"ROUND(G32*0.15,2)","v":0},0]
["0583568",{"$f":"B32+1","v":19},"200g Five roses box of 100",3600,"box",null,0,0,0]
["0583627",20,"200g Rooibos freshpack box of 80  ",3600,"box",null,0,0,0]
["0586010",21,"100g English breakfast twinings         ",158,"box",null,{"$f":"ROUND(D35*F35,2)","v":0},{"$f":"ROUND(G35*0.15,2)","v":0},{"$f":"ROUND(G35+H35,2)","v":0}]
["0586009",22,"100g Ealry grey twinings                ",4,"box",null,{"$f":"ROUND(D36*F36,2)","v":0},{"$f":"ROUND(G36*0.15,2)","v":0},{"$f":"ROUND(G36+H36,2)","v":0}]
["0586011",23,"2g Jasmine green box of 25         ",158,"box",null,{"$f":"ROUND(D37*F37,2)","v":0},{"$f":"ROUND(G37*0.15,2)","v":0},{"$f":"ROUND(G37+H37,2)","v":0}]
[]
[null,null,"THE FOLLOWING SUPPLY AND DELIVERY OF BEVERAGES"]
[]
[null,null,"Milk"]
["0183372",{"$f":"B37+1","v":24},"1L Low fat UHT processed milk (price per case of 6 x 1L)",8802,"Case",null,{"$f":"ROUND(D42*F42,2)","v":0},"Zero Rated",{"$f":"G42","v":0}]
["0214649",{"$f":"B42+1","v":25},"1L Full cream long life milk (price per case of 6 x 1L)",17604,"Case",null,0,"Zero Rated",{"$f":"G43","v":0}]
[]
[null,null,"Water (Valpre or Equivalent)"]
[]
["0567355",{"$f":"B43+1","v":26},"500ml Sparkling (price per 24pack case)",3000,"Case",null,{"$f":"ROUND(D47*F47,2)","v":0},{"$f":"ROUND(G47*0.15,2)","v":0},{"$f":"ROUND(G47+H47,2)","v":0}]
["0567356",{"$f":"B47+1","v":27},"1L Natural still",1200,"each",null,0,{"$f":"ROUND(G48*0.15,2)","v":0},{"$f":"ROUND(G48+H48,2)","v":0}]
["0567354",{"$f":"B48+1","v":28},"1L Sparkling spring water",1200,"each",null,0,0,0]
{"$rows_empty":31}
["SUB TOTAL FOR WORKSHOP GROCERIES- CARRIED TO FINAL SUMMARY",{"$nulls":5},{"$f":"SUM(G8:G80)","v":0},{"$f":"SUM(H9:H80)","v":0},{"$f":"SUM(I9:I80)","v":0}]

{"sheet":"SUMMARY","index":3,"n_rows":68,"n_cols":8,"rows_kept":68,"merged":[[1,1,6,2],[1,3,6,8],[65,2,65,6],[66,2,66,6],[67,2,67,6]]}
[]
[{"$nulls":3},"SUPLLY AND DELIVERY OF DRY GOODS  AT ESKOM ACADEMY OF LEARNING (EAL) FOR A 3-YEAR PERIOD"]
{"$rows_empty":10}
[null,"1.1","FINALSUMMARY"]
[]
[null,null,"ITEM NO","DESCRIPTION","UOM","QUANTITY","RATE ","AMOUNT"]
[]
[null,null,1,"Kitchen Groceries","Sum",1,{"$f":"'1.KITCHEN BOQ'!G660","v":{"v":0,"d":"R0.00"}},{"$f":"ROUND(F17*G17,2)","v":{"v":0,"d":"R0.00"}}]
[null,null,2,"Tuckshop Groceries","Sum",1,{"$f":"'2.TUCKSHOP BOQ'!G243","v":{"v":0,"d":"R0.00"}},{"$f":"ROUND(F18*G18,2)","v":{"v":0,"d":"R0.00"}}]
[null,null,3,"Workshop, Cost Centres, Conferences and Rooms","Sum",1,{"$f":"'3.WORKSHOP, CS, CONF & ROOM BOQ'!G81","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
{"$rows_empty":46}
[null,null,"TOTAL AMOUNT EXCL VAT",{"$nulls":4},{"$f":"SUM(H17:H65)","v":{"v":0,"d":"R 0.00"}}]
[null,null,"VAT @15% (Excluding Zero-Rated Items)",{"$nulls":4},{"$f":"'1.KITCHEN BOQ'!H660+'2.TUCKSHOP BOQ'!H243+'3.WORKSHOP, CS, CONF & ROOM BOQ'!H81","v":{"v":0,"d":"R 0.00"}}]
[null,null,"TOTAL AMOUNT INCL VAT",{"$nulls":4},{"$f":"SUM(H66:H67)","v":{"v":0,"d":"R 0.00"}}]