{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RESUMO","02-10-24","03-10-24","04-10-24"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RESUMO","index":0,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["PRODUTO","Quant. Vendida Quente","Quant. Vendida Gelada","UNID. VENDIDAS","VALOR UNID.","01/10/2024",null,null,null,"PLANILHAS",null,null,null,"GUIAS",null,null,null,"PRODUTO","PREÇO"]
[{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(R2:R102))","v":"AGUA 20 LITROS"},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A2,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A2,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":1},{"$f":"SUM(B2:C2)","v":1},{"$f":"IFERROR(VLOOKUP(A2,$R$2:$S$102,2,0),\"0\")","v":6},{"$f":"D2*E2","v":6},null,null,null,"02-10-24",null,null,1,{"$f":"IFERROR(INDEX(GUIAS,M2),\"\")","v":""},null,null,null,"Cerveja Skol 1 litro",{"$f":"VLOOKUP(R2,'02-10-24'!$A$1:$D$200,4,0)","v":6.916666666666667}]
["AGUA COM GÁS 510ML",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A3,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A3,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":1},{"$f":"SUM(B3:C3)","v":1},{"$f":"IFERROR(VLOOKUP(A3,$R$2:$S$102,2,0),\"0\")","v":1.1666666666666667},{"$f":"D3*E3","v":1.1666666666666667},null,null,null,"03-10-24",null,null,2,{"$f":"IFERROR(INDEX(GUIAS,M3),\"\")","v":""},null,null,null,"Cerveja Brahma 1 litro",{"$f":"VLOOKUP(R3,'02-10-24'!$A$1:$D$200,4,0)","v":6.541666666666667}]
["Agua Mamba Water 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A4,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A4,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.17,0,null,null,null,"04-10-24",null,null,3,{"$f":"IFERROR(INDEX(GUIAS,M4),\"\")","v":""},null,null,null,"Cerveja Brahma 1 litro",{"$f":"VLOOKUP(R4,'02-10-24'!$A$1:$D$200,4,0)","v":6.541666666666667}]
["AGUA SEM GÁS 510ML",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A5,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A5,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,0.83333333333333337,0,null,null,null,null,null,null,4,{"$f":"IFERROR(INDEX(GUIAS,M5),\"\")","v":""},null,null,null,"Cerveja Brahma 300ml",{"$f":"VLOOKUP(R5,'02-10-24'!$A$1:$D$200,4,0)","v":2.1513043478260867}]
["Bala Halls",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A6,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A6,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.1971000000000001,0,null,null,null,null,null,null,5,null,null,null,null,"Cerveja Antartica 1 litro",{"$f":"VLOOKUP(R6,'02-10-24'!$A$1:$D$200,4,0)","v":6.916666666666667}]
["Biscoito Piraque",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A7,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A7,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.5,0,null,null,null,null,null,null,6,null,null,null,null,"Cerveja Antartica 1 litro",{"$f":"VLOOKUP(R7,'02-10-24'!$A$1:$D$200,4,0)","v":6.916666666666667}]
["BONO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A8,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A8,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.17,0,null,null,null,null,null,null,7,null,null,null,null,"Cerveja Budweiser 1 litro",{"$f":"VLOOKUP(R8,'02-10-24'!$A$1:$D$200,4,0)","v":6.541666666666667}]
["Brahma Duplo Malte",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A9,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A9,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.4249999999999998,0,null,null,null,null,null,null,8,null,null,null,null,"Cerveja Budweiser 1 litro",{"$f":"VLOOKUP(R9,'02-10-24'!$A$1:$D$200,4,0)","v":6.541666666666667}]
["Cachaça 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A10,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A10,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":2},2,1.5,3,null,null,null,null,null,null,9,null,null,null,null,"Cerveja Budweiser Long Neck",{"$f":"VLOOKUP(R10,'02-10-24'!$A$1:$D$200,4,0)","v":4}]
["Cachaça 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A11,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A11,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.4,0,null,null,null,null,null,null,10,null,null,null,null,"Cerveja Antartica 300ml",{"$f":"VLOOKUP(R11,'02-10-24'!$A$1:$D$200,4,0)","v":2.3252173913043479}]
["Cachaça 500ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A12,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A12,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja original 300ml",{"$f":"VLOOKUP(R12,'02-10-24'!$A$1:$D$200,4,0)","v":2.5652173913043477}]
["Cachaça Seleta 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A13,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A13,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,29.9,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Stella 600ml",{"$f":"VLOOKUP(R13,'02-10-24'!$A$1:$D$200,4,0)","v":7.55}]
["Carvão Roytec 2,5kg",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A14,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A14,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,8.5,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja original 1 Litro",{"$f":"VLOOKUP(R14,'02-10-24'!$A$1:$D$200,4,0)","v":7.4916666666666671}]
["Cerveja Amstel 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A15,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A15,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":29},41,6.2458333333333336,256.07916666666665,null,null,null,null,null,null,null,null,null,null,null,"Cerveja original 473 ml",{"$f":"VLOOKUP(R15,'02-10-24'!$A$1:$D$200,4,0)","v":4.41}]
["Cerveja Amstel 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A16,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":552},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A16,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":34},586,3.4583333333333335,2026.5833333333335,null,null,null,null,null,null,null,null,null,null,null,"Vodka Orloff 1 litro",{"$f":"VLOOKUP(R16,'02-10-24'!$A$1:$D$200,4,0)","v":28.4}]
["Cerveja Antartica 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A17,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":300},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A17,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":112},412,6.916666666666667,2849.666666666667,null,null,null,null,null,null,null,null,null,null,null,"Vodka Smirnoff 998ml",{"$f":"VLOOKUP(R17,'02-10-24'!$A$1:$D$200,4,0)","v":33.729999999999997}]
["Cerveja Antartica 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A18,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A18,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.3252173913043479,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Sparten Lata 473ml",{"$f":"VLOOKUP(R18,'02-10-24'!$A$1:$D$200,4,0)","v":4.1583333333333332}]
["Cerveja Antartica lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A19,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":3036},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A19,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":33},3069,3.4166666666666665,10485.75,null,null,null,null,null,null,null,null,null,null,null,"Cerveja corona LongNeck",{"$f":"VLOOKUP(R19,'02-10-24'!$A$1:$D$200,4,0)","v":5.291666666666667}]
["Cerveja BADEN 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A20,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A20,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.34,0,null,null,null,null,null,null,null,null,null,null,null,"Cachaça Seleta 1 litro",{"$f":"VLOOKUP(R20,'02-10-24'!$A$1:$D$200,4,0)","v":29.9}]
["Cerveja Brahma 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A21,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A21,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":7},19,6.541666666666667,124.29166666666667,null,null,null,null,null,null,null,null,null,null,null,"Wisky Red Label",{"$f":"VLOOKUP(R21,'02-10-24'!$A$1:$D$200,4,0)","v":74.900000000000006}]
["Cerveja Brahma 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A22,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A22,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.1513043478260867,0,null,null,null,null,null,null,null,null,null,null,null,"Wisky Cavalo Branco",{"$f":"VLOOKUP(R22,'02-10-24'!$A$1:$D$200,4,0)","v":62.9}]
["Cerveja Brahma 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A23,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":360},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A23,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},360,3.25,1170,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Pepsi 2 litros",{"$f":"VLOOKUP(R23,'02-10-24'!$A$1:$D$200,4,0)","v":6.04}]
["Cerveja Budweiser 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A24,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A24,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,6.541666666666667,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Pepsi 200ml",{"$f":"VLOOKUP(R24,'02-10-24'!$A$1:$D$200,4,0)","v":1.25}]
["Cerveja Budweiser Latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A25,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A25,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.8533333333333335,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Antarctica 2 litros",{"$f":"VLOOKUP(R25,'02-10-24'!$A$1:$D$200,4,0)","v":6.63}]
["Cerveja Budweiser Long Neck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A26,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A26,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Antarctica 200ml",{"$f":"VLOOKUP(R26,'02-10-24'!$A$1:$D$200,4,0)","v":1.25}]
["Cerveja Budweiser LongNeck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A27,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A27,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.9916666666666667,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Antarctica 350ml",{"$f":"VLOOKUP(R27,'02-10-24'!$A$1:$D$200,4,0)","v":0.96666666666666667}]
["Cerveja corona LongNeck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A28,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A28,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,5.291666666666667,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Sukita 2 litros",{"$f":"VLOOKUP(R28,'02-10-24'!$A$1:$D$200,4,0)","v":4.791666666666667}]
["Cerveja Heineken 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A29,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A29,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.1574999999999998,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Sukita Laranja 200ml",{"$f":"VLOOKUP(R29,'02-10-24'!$A$1:$D$200,4,0)","v":1.39}]
["Cerveja Heineken 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A30,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":288},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A30,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":38},326,4.75,1548.5,null,null,null,null,null,null,null,null,null,null,null,"Energetico Red Bull 250ml",{"$f":"VLOOKUP(R30,'02-10-24'!$A$1:$D$200,4,0)","v":7.29}]
["Cerveja Heineken 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A31,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A31,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,8.2899999999999991,0,null,null,null,null,null,null,null,null,null,null,null,"H2OH 1,5 litro limoneto",{"$f":"VLOOKUP(R31,'02-10-24'!$A$1:$D$200,4,0)","v":6.6000000000000005}]
["Cerveja Itaipava Latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A32,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A32,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.5124999999999997,0,null,null,null,null,null,null,null,null,null,null,null,"Bala Halls",{"$f":"VLOOKUP(R32,'02-10-24'!$A$1:$D$200,4,0)","v":1.1971000000000001}]
["Cerveja Lagunitas 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A33,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A33,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4,0,null,null,null,null,null,null,null,null,null,null,null,"Skol Beats",{"$f":"VLOOKUP(R33,'02-10-24'!$A$1:$D$200,4,0)","v":4.8}]
["Cerveja Lokal latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A34,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A34,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.2833333333333332,0,null,null,null,null,null,null,null,null,null,null,null,"Biscoito Piraque",{"$f":"VLOOKUP(R34,'02-10-24'!$A$1:$D$200,4,0)","v":2.5}]
["Cerveja original 1 Litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A35,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A35,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.4916666666666671,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Heineken 600ml",{"$f":"VLOOKUP(R35,'02-10-24'!$A$1:$D$200,4,0)","v":8.2899999999999991}]
["Cerveja original 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A36,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A36,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.5652173913043477,0,null,null,null,null,null,null,null,null,null,null,null,"Agua Mamba Water 350ml",{"$f":"VLOOKUP(R36,'02-10-24'!$A$1:$D$200,4,0)","v":2.17}]
["Cerveja original 473 ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A37,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A37,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.41,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Lagunitas 350ml",{"$f":"VLOOKUP(R37,'02-10-24'!$A$1:$D$200,4,0)","v":4}]
["Cerveja Skol 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A38,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A38,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":4},16,6.916666666666667,110.66666666666667,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Amstel 1 litro",{"$f":"VLOOKUP(R38,'02-10-24'!$A$1:$D$200,4,0)","v":6.2458333333333336}]
["Cerveja Skol Beats Lata 269ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A39,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A39,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,5.14,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja BADEN 350ml",{"$f":"VLOOKUP(R39,'02-10-24'!$A$1:$D$200,4,0)","v":4.34}]
["Cerveja Skol Lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A40,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A40,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.4916666666666667,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante ItaUp sabores",{"$f":"VLOOKUP(R40,'02-10-24'!$A$1:$D$200,4,0)","v":3.15}]
["Cerveja Sparten Lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A41,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A41,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.1583333333333332,0,null,null,null,null,null,null,null,null,null,null,null,"Energetico Fontt 2 litros",{"$f":"VLOOKUP(R41,'02-10-24'!$A$1:$D$200,4,0)","v":3}]
["Cerveja Stella 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A42,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A42,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.55,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola 2 litros",{"$f":"VLOOKUP(R42,'02-10-24'!$A$1:$D$200,4,0)","v":7.666666666666667}]
["Cerveja Stella lata 473 ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A43,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A43,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.9083333333333332,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola 2 litros Retornavel",{"$f":"VLOOKUP(R43,'02-10-24'!$A$1:$D$200,4,0)","v":5.7}]
["CHOKITO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A44,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A44,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.66,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola 2,250",{"$f":"VLOOKUP(R44,'02-10-24'!$A$1:$D$200,4,0)","v":{"$error":"#N/A"}}]
["Chopp Bodegão 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A45,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A45,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.95,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola 2,250 Sem Açucar",{"$f":"VLOOKUP(R45,'02-10-24'!$A$1:$D$200,4,0)","v":{"$error":"#N/A"}}]
["Chopp Vinho Pink Moon 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A46,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A46,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.4,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola mini 200ml",{"$f":"VLOOKUP(R46,'02-10-24'!$A$1:$D$200,4,0)","v":1.45}]
["Combo Jaya 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A47,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A47,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":3},3,14,42,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Fanta Laranja 600ml",{"$f":"VLOOKUP(R47,'02-10-24'!$A$1:$D$200,4,0)","v":3.62}]
["Combo Jaya 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A48,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A48,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,12.1,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola lata 350ml",{"$f":"VLOOKUP(R48,'02-10-24'!$A$1:$D$200,4,0)","v":2.75}]
["Combo One 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A49,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A49,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":1},1,11.850000000000001,11.850000000000001,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola 600ml",{"$f":"VLOOKUP(R49,'02-10-24'!$A$1:$D$200,4,0)","v":4.5}]
["Combo One 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A50,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A50,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,10,0,null,null,null,null,null,null,null,null,null,null,null,"Refrigerante Coca Cola lata 350ml sem açucar",{"$f":"VLOOKUP(R50,'02-10-24'!$A$1:$D$200,4,0)","v":2.61}]
["Coquetel Banana Belong 960ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A51,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A51,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,15.5,0,null,null,null,null,null,null,null,null,null,null,null,"Suco DelVale 1,5",{"$f":"VLOOKUP(R51,'02-10-24'!$A$1:$D$200,4,0)","v":7.03}]
["Creveja Imperio Latão Large",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A52,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A52,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.98,0,null,null,null,null,null,null,null,null,null,null,null,"Suco Kappo",{"$f":"VLOOKUP(R52,'02-10-24'!$A$1:$D$200,4,0)","v":1.25}]
["Creveja Imperio Latão Puro Malte",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A53,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A53,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":22},22,3.0833333333333335,67.833333333333343,null,null,null,null,null,null,null,null,null,null,null,"CHOKITO",{"$f":"VLOOKUP(R53,'02-10-24'!$A$1:$D$200,4,0)","v":1.66}]
["Energetico Fontt 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A54,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A54,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3,0,null,null,null,null,null,null,null,null,null,null,null,"PASSATEMPO",{"$f":"VLOOKUP(R54,'02-10-24'!$A$1:$D$200,4,0)","v":2.29}]
["Energetico Jaya 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A55,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A55,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":1},1,6.5,6.5,null,null,null,null,null,null,null,null,null,null,null,"BONO",{"$f":"VLOOKUP(R55,'02-10-24'!$A$1:$D$200,4,0)","v":2.17}]
["Energetico one 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A56,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A56,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":1},13,4.3500000000000005,56.550000000000004,null,null,null,null,null,null,null,null,null,null,null,"PRESTIGIO",{"$f":"VLOOKUP(R56,'02-10-24'!$A$1:$D$200,4,0)","v":1.54}]
["Energetico Red Bull 250ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A57,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A57,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.29,0,null,null,null,null,null,null,null,null,null,null,null,"Carvão Roytec 2,5kg",{"$f":"VLOOKUP(R57,'02-10-24'!$A$1:$D$200,4,0)","v":8.5}]
["GostoGin lata 269ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A58,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A58,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.3991666666666664,0,null,null,null,null,null,null,null,null,null,null,null,"AGUA 20 LITROS",{"$f":"VLOOKUP(R58,'02-10-24'!$A$1:$D$200,4,0)","v":6}]
["H2OH 1,5 litro limoneto",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A59,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A59,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,6.6000000000000005,0,null,null,null,null,null,null,null,null,null,null,null,"AGUA COM GÁS 510ML",{"$f":"VLOOKUP(R59,'02-10-24'!$A$1:$D$200,4,0)","v":1.1666666666666667}]
["Ice One 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A60,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A60,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.89,0,null,null,null,null,null,null,null,null,null,null,null,"AGUA SEM GÁS 510ML",{"$f":"VLOOKUP(R60,'02-10-24'!$A$1:$D$200,4,0)","v":0.83333333333333337}]
["Ice syn 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A61,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A61,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.8012499999999998,0,null,null,null,null,null,null,null,null,null,null,null,"Energetico one 2 litros",{"$f":"VLOOKUP(R61,'02-10-24'!$A$1:$D$200,4,0)","v":4.3500000000000005}]
["Menta 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A62,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A62,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,5.9,0,null,null,null,null,null,null,null,null,null,null,null,"Vodka Darkoff 900ml",{"$f":"VLOOKUP(R62,'02-10-24'!$A$1:$D$200,4,0)","v":5.5}]
["Ousadia 500ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A63,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A63,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.2433333333333336,0,null,null,null,null,null,null,null,null,null,null,null,"Vodka Darkoff 1,50 litros",{"$f":"VLOOKUP(R63,'02-10-24'!$A$1:$D$200,4,0)","v":7.5}]
["PASSATEMPO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A64,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A64,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.29,0,null,null,null,null,null,null,null,null,null,null,null,"Combo Jaya 1,50 litros",{"$f":"VLOOKUP(R64,'02-10-24'!$A$1:$D$200,4,0)","v":14}]
["PRESTIGIO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A65,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A65,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.54,0,null,null,null,null,null,null,null,null,null,null,null,"Combo One 1,50 litros",{"$f":"VLOOKUP(R65,'02-10-24'!$A$1:$D$200,4,0)","v":11.850000000000001}]
["Refrigerante Antarctica 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A66,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":6},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A66,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":3},9,6.63,59.67,null,null,null,null,null,null,null,null,null,null,null,"Combo Jaya 900ml",{"$f":"VLOOKUP(R66,'02-10-24'!$A$1:$D$200,4,0)","v":12.1}]
["Refrigerante Antarctica 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A67,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A67,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},{"$f":"SUM(B67:C67)","v":0},{"$f":"IFERROR(VLOOKUP(A67,$R$2:$S$102,2,0),\"0\")","v":1.25},{"$f":"D67*E67","v":0},null,null,null,null,null,null,null,null,null,null,null,"Combo One 900ml",{"$f":"VLOOKUP(R67,'02-10-24'!$A$1:$D$200,4,0)","v":10}]
["Refrigerante Antarctica 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A68,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A68,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,0.96666666666666667,0,null,null,null,null,null,null,null,null,null,null,null,"Vinho Bodegão Bordo 1 Litro",{"$f":"VLOOKUP(R68,'02-10-24'!$A$1:$D$200,4,0)","v":8.2449999999999992}]
["Refrigerante Coca Cola 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A69,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":108},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A69,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":3},111,7.666666666666667,851,null,null,null,null,null,null,null,null,null,null,null,"Energetico Jaya 2 litros",{"$f":"VLOOKUP(R69,'02-10-24'!$A$1:$D$200,4,0)","v":6.5}]
["Refrigerante Coca Cola 2 litros Retornavel",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A70,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A70,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":5},5,5.7,28.5,null,null,null,null,null,null,null,null,null,null,null,"Ice One 300ml",{"$f":"VLOOKUP(R70,'02-10-24'!$A$1:$D$200,4,0)","v":1.89}]
["Refrigerante Coca Cola 2,250",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A71,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A71,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Coquetel Banana Belong 960ml",{"$f":"VLOOKUP(R71,'02-10-24'!$A$1:$D$200,4,0)","v":15.5}]
["Refrigerante Coca Cola 2,250 Sem Açucar",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A72,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A72,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Chopp Bodegão 600ml",{"$f":"VLOOKUP(R72,'02-10-24'!$A$1:$D$200,4,0)","v":4.95}]
["Refrigerante Coca Cola 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A73,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A73,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.5,0,null,null,null,null,null,null,null,null,null,null,null,"Vinho Bodegão 2 Litros",{"$f":"VLOOKUP(R73,'02-10-24'!$A$1:$D$200,4,0)","v":16.5}]
["Refrigerante Coca Cola lata 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A74,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A74,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.75,0,null,null,null,null,null,null,null,null,null,null,null,"Menta 900ml",{"$f":"VLOOKUP(R74,'02-10-24'!$A$1:$D$200,4,0)","v":5.9}]
["Refrigerante Coca Cola lata 350ml sem açucar",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A75,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A75,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,2.61,0,null,null,null,null,null,null,null,null,null,null,null,"Ousadia 500ml",{"$f":"VLOOKUP(R75,'02-10-24'!$A$1:$D$200,4,0)","v":3.2433333333333336}]
["Refrigerante Coca Cola mini 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A76,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A76,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.45,0,null,null,null,null,null,null,null,null,null,null,null,"Chopp Vinho Pink Moon 600ml",{"$f":"VLOOKUP(R76,'02-10-24'!$A$1:$D$200,4,0)","v":7.4}]
["Refrigerante Fanta Laranja 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A77,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A77,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.62,0,null,null,null,null,null,null,null,null,null,null,null,"Vodka Komaroff 1L",{"$f":"VLOOKUP(R77,'02-10-24'!$A$1:$D$200,4,0)","v":6}]
["Refrigerante ItaUp sabores",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A78,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A78,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,3.15,0,null,null,null,null,null,null,null,null,null,null,null,"Ice syn 300ml",{"$f":"VLOOKUP(R78,'02-10-24'!$A$1:$D$200,4,0)","v":1.8012499999999998}]
["Refrigerante Pepsi 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A79,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A79,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":2},2,6.04,12.08,null,null,null,null,null,null,null,null,null,null,null,"GostoGin lata 269ml",{"$f":"VLOOKUP(R79,'02-10-24'!$A$1:$D$200,4,0)","v":3.3991666666666664}]
["Refrigerante Pepsi 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A80,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A80,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.25,0,null,null,null,null,null,null,null,null,null,null,null,"Vinho Cantina da serra",{"$f":"VLOOKUP(R80,'02-10-24'!$A$1:$D$200,4,0)","v":4.4766666666666666}]
["Refrigerante Sukita 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A81,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A81,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":2},2,4.791666666666667,9.5833333333333339,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Skol Lata 473ml",{"$f":"VLOOKUP(R81,'02-10-24'!$A$1:$D$200,4,0)","v":3.4916666666666667}]
["Refrigerante Sukita Laranja 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A82,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A82,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.39,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Skol Beats Lata 269ml",{"$f":"VLOOKUP(R82,'02-10-24'!$A$1:$D$200,4,0)","v":5.14}]
["Skol Beats",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A83,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A83,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.8,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Brahma 473ml",{"$f":"VLOOKUP(R83,'02-10-24'!$A$1:$D$200,4,0)","v":3.25}]
["Suco DelVale 1,5",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A84,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A84,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.03,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Brahma 473ml",{"$f":"VLOOKUP(R84,'02-10-24'!$A$1:$D$200,4,0)","v":3.25}]
["Suco Kappo",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A85,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A85,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,1.25,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Antartica lata 473ml",{"$f":"VLOOKUP(R85,'02-10-24'!$A$1:$D$200,4,0)","v":3.4166666666666665}]
["Vinho Bodegão 2 Litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A86,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A86,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":2},2,16.5,33,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Antartica lata 473ml",{"$f":"VLOOKUP(R86,'02-10-24'!$A$1:$D$200,4,0)","v":3.4166666666666665}]
["Vinho Bodegão Bordo 1 Litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A87,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A87,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,8.2449999999999992,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Stella lata 473 ml",{"$f":"VLOOKUP(R87,'02-10-24'!$A$1:$D$200,4,0)","v":3.9083333333333332}]
["Vinho Cantina da serra",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A88,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A88,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,4.4766666666666666,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Budweiser Latão",{"$f":"VLOOKUP(R88,'02-10-24'!$A$1:$D$200,4,0)","v":3.8533333333333335}]
["Vodka Darkoff 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A89,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A89,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,7.5,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Budweiser LongNeck",{"$f":"VLOOKUP(R89,'02-10-24'!$A$1:$D$200,4,0)","v":3.9916666666666667}]
["Vodka Darkoff 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A90,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A90,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},12,5.5,66,null,null,null,null,null,null,null,null,null,null,null,"Brahma Duplo Malte",{"$f":"VLOOKUP(R90,'02-10-24'!$A$1:$D$200,4,0)","v":3.4249999999999998}]
["Vodka Komaroff 1L",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A91,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A91,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,6,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Itaipava Latão",{"$f":"VLOOKUP(R91,'02-10-24'!$A$1:$D$200,4,0)","v":2.5124999999999997}]
["Vodka Orloff 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A92,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A92,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,28.4,0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Lokal latão",{"$f":"VLOOKUP(R92,'02-10-24'!$A$1:$D$200,4,0)","v":2.2833333333333332}]
["Vodka Smirnoff 998ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A93,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A93,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,33.729999999999997,0,null,null,null,null,null,null,null,null,null,null,null,"Creveja Imperio Latão Puro Malte",{"$f":"VLOOKUP(R93,'02-10-24'!$A$1:$D$200,4,0)","v":3.0833333333333335}]
["Wisky Cavalo Branco",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A94,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A94,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,62.9,0,null,null,null,null,null,null,null,null,null,null,null,"Creveja Imperio Latão Puro Malte",{"$f":"VLOOKUP(R94,'02-10-24'!$A$1:$D$200,4,0)","v":3.0833333333333335}]
["Wisky Red Label",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A95,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A95,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,74.900000000000006,0,null,null,null,null,null,null,null,null,null,null,null,"Creveja Imperio Latão Large",{"$f":"VLOOKUP(R95,'02-10-24'!$A$1:$D$200,4,0)","v":3.98}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A96,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A96,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Amstel 473ml",{"$f":"VLOOKUP(R96,'02-10-24'!$A$1:$D$200,4,0)","v":3.4583333333333335}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A97,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A97,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Amstel 473ml",{"$f":"VLOOKUP(R97,'02-10-24'!$A$1:$D$200,4,0)","v":3.4583333333333335}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A98,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A98,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Heineken 350ml",{"$f":"VLOOKUP(R98,'02-10-24'!$A$1:$D$200,4,0)","v":4.1574999999999998}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A99,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A99,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cerveja Heineken 473ml",{"$f":"VLOOKUP(R99,'02-10-24'!$A$1:$D$200,4,0)","v":4.75}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A100,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A100,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cachaça 500ml",{"$f":"VLOOKUP(R100,'02-10-24'!$A$1:$D$200,4,0)","v":4}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A101,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A101,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cachaça 300ml",{"$f":"VLOOKUP(R101,'02-10-24'!$A$1:$D$200,4,0)","v":2.4}]
[null,{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A102,INDIRECT(\"'\"&$J$2:$J$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$J$2:$J$4&\"'!A:A\"),A102,INDIRECT(\"'\"&$J$2:$J$4&\"'!c:c\")))","v":0},0,"0",0,null,null,null,null,null,null,null,null,null,null,null,"Cachaça 200ml",{"$f":"VLOOKUP(R102,'02-10-24'!$A$1:$D$200,4,0)","v":1.5}]

{"sheet":"02-10-24","index":1,"n_rows":145,"n_cols":12,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol 1 litro",null,null,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Brahma 1 litro",null,6,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 300ml",null,null,{"$f":"49.48/23","v":2.1513043478260867}]
["Cerveja Antartica 1 litro",24,19,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Antartica 1 litro",null,null,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser Long Neck",null,null,4]
["Cerveja Antartica 300ml",null,null,{"$f":"53.48/23","v":2.3252173913043479}]
["Cerveja original 300ml",null,null,{"$f":"59/23","v":2.5652173913043477}]
["Cerveja Stella 600ml",null,null,{"$f":"181.2/24","v":7.55}]
["Cerveja original 1 Litro",null,null,{"$f":"89.9/12","v":7.4916666666666671}]
["Cerveja original 473 ml",null,null,{"$f":"4.41","v":4.41}]
["Vodka Orloff 1 litro",null,null,28.4]
["Vodka Smirnoff 998ml",null,null,33.729999999999997]
["Cerveja Sparten Lata 473ml",null,null,{"$f":"49.9/12","v":4.1583333333333332}]
["Cerveja corona LongNeck",null,null,{"$f":"127/24","v":5.291666666666667}]
["Cachaça Seleta 1 litro",null,null,29.9]
["Wisky Red Label",null,null,74.900000000000006]
["Wisky Cavalo Branco",null,null,62.9]
["Refrigerante Pepsi 2 litros",null,1,{"$f":"36.24/6","v":6.04}]
["Refrigerante Pepsi 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 2 litros",null,2,{"$f":"39.78/6","v":6.63}]
["Refrigerante Antarctica 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 350ml",null,null,{"$f":"11.6/12","v":0.96666666666666667}]
["Refrigerante Sukita 2 litros",null,null,{"$f":"28.75/6","v":4.791666666666667}]
["Refrigerante Sukita Laranja 200ml",null,null,{"$f":"16.68/12","v":1.39}]
["Energetico Red Bull 250ml",null,null,7.29]
["H2OH 1,5 litro limoneto",null,null,{"$f":"39.6/6","v":6.6000000000000005}]
["Bala Halls",null,null,1.1971000000000001]
["Skol Beats",null,null,{"$f":"38.4/8","v":4.8}]
["Biscoito Piraque",null,null,2.5]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Heineken 600ml",null,null,8.2899999999999991]
["Agua Mamba Water 350ml",null,null,2.17]
["Cerveja Lagunitas 350ml",null,null,4]
["Cerveja Amstel 1 litro",null,13,{"$f":"74.95/12","v":6.2458333333333336}]
["Cerveja BADEN 350ml",null,null,4.34]
[null,null,"Venda Custo"]
["ITAUP"]
["Refrigerante ItaUp sabores",null,null,{"$f":"18.9/6","v":3.15}]
["Energetico Fontt 2 litros",null,null,3]
[null,null,"Venda Custo"]
["COCA COLA"]
["Refrigerante Coca Cola 2 litros",{"$f":"7*6","v":42},null,{"$f":"46/6","v":7.666666666666667}]
["Refrigerante Coca Cola 2 litros Retornavel",null,1,5.7]
["Refrigerante Fanta Laranja 2 litros",null,null,{"$f":"35.5/6","v":5.916666666666667}]
["Refrigerante Coca Cola 2 litros Sem Açucar",null,null,{"$f":"63.2/8","v":7.9}]
["Refrigerante Coca Cola mini 200ml",null,null,{"$f":"17.4/12","v":1.45}]
["Refrigerante Fanta Laranja 600ml",null,null,3.62]
["Refrigerante Coca Cola lata 350ml",null,null,{"$f":"33/12","v":2.75}]
["Refrigerante Coca Cola 600ml",null,null,4.5]
["Refrigerante Coca Cola lata 350ml sem açucar",null,null,2.61]
["Suco DelVale 1,5",null,null,7.03]
["Suco Kappo",null,null,1.25]
[null,null,"Venda Custo"]
["NESTLE"]
["CHOKITO",null,null,1.66]
["PASSATEMPO",null,null,2.29]
["BONO",null,null,2.17]
["PRESTIGIO",null,null,1.54]
[null,null,"Venda Custo"]
["CARVÃO ROYTEC"]
["Carvão Roytec 2,5kg",null,null,8.5]
[null,null,"Venda Custo"]
["AGUA"]
["AGUA 20 LITROS",null,null,6]
["AGUA COM GÁS 510ML",null,null,{"$f":"14/12","v":1.1666666666666667}]
["AGUA SEM GÁS 510ML",null,null,{"$f":"10/12","v":0.83333333333333337}]
[null,null,"Venda Custo"]
["BE LONG"]
["Energetico one 2 litros",null,null,{"$f":"26.1/6","v":4.3500000000000005}]
["Vodka Darkoff 900ml",null,null,5.5]
["Vodka Darkoff 1,50 litros",null,null,{"$f":"90/12","v":7.5}]
["Combo Jaya 1,50 litros",null,3,{"$f":"D79+D85","v":14}]
["Combo One 1,50 litros",null,1,{"$f":"D79+D77","v":11.850000000000001}]
["Combo Jaya 900ml",null,null,{"$f":"5.3+6.8","v":12.1}]
["Combo One 900ml",null,null,{"$f":"4.7+5.3","v":10}]
["Vinho Bodegão Bordo 1 Litro",null,null,{"$f":"98.94/12","v":8.2449999999999992}]
["Energetico Jaya 2 litros",null,null,6.5]
["Ice One 300ml",null,null,1.89]
["Coquetel Banana Belong 960ml",null,null,{"$f":"93/6","v":15.5}]
["Chopp Bodegão 600ml",null,null,{"$f":"59.4/12","v":4.95}]
["Vinho Bodegão 2 Litros",null,null,16.5]
["Menta 900ml",null,null,5.9]
[null,null,"Venda Custo"]
["ARBOL"]
["Ousadia 500ml",null,null,{"$f":"38.92/12","v":3.2433333333333336}]
["Chopp Vinho Pink Moon 600ml",null,null,7.4]
["Vodka Komaroff 1L",null,null,6]
["Ice syn 300ml",null,null,{"$f":"43.23/24","v":1.8012499999999998}]
["GostoGin lata 269ml",null,null,{"$f":"81.58/24","v":3.3991666666666664}]
["Vinho Cantina da serra",null,null,{"$f":"53.72/12","v":4.4766666666666666}]
[null,null,"Venda Custo"]
[]
[null,"Soma de Itens",{"$f":"SUM(B4:C98)","v":112}]
[null,null,"Venda Custo"]
["INAH"]
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol Lata 473ml",null,null,{"$f":"41.9/12","v":3.4916666666666667}]
["Cerveja Skol Beats Lata 269ml",null,null,5.14]
["Cerveja Brahma 473ml",null,null,{"$f":"39/12","v":3.25}]
["Cerveja Brahma 473ml",null,null,{"$f":"41.9/12","v":3.4916666666666667}]
["Cerveja Antartica lata 473ml",{"$f":"142*12","v":1704},5,{"$f":"41/12","v":3.4166666666666665}]
["Cerveja Antartica lata 473ml",null,null,{"$f":"43.9/12","v":3.6583333333333332}]
["Cerveja Stella lata 473 ml",null,null,{"$f":"46.9/12","v":3.9083333333333332}]
["Cerveja Budweiser Latão",null,null,{"$f":"46.24/12","v":3.8533333333333335}]
["Cerveja Budweiser LongNeck",null,null,{"$f":"95.8/24","v":3.9916666666666667}]
["Brahma Duplo Malte",null,null,3.4249999999999998]
[]
[null,null,"Venda Custo"]
["ITAIPAVA"]
["Cerveja Itaipava Latão",null,null,{"$f":"30.15/12","v":2.5124999999999997}]
["Cerveja Lokal latão",null,null,{"$f":"27.4/12","v":2.2833333333333332},null,null,null,null,null,null,null,"                                                                                 "]
[null,null,"Venda Custo"]
["IMPERIO"]
["Creveja Imperio Latão Puro Malte",null,null,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Puro Malte",null,null,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Large",null,null,3.98]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Amstel 473ml",12,6,{"$f":"41.5/12","v":3.4583333333333335}]
["Cerveja Amstel 473ml",null,null,{"$f":"45/12","v":3.75}]
["Cerveja Heineken 350ml",null,null,{"$f":"49.89/12","v":4.1574999999999998}]
["Cerveja Heineken 473ml",{"$f":"13*12","v":156},13,{"$f":"57/12","v":4.75}]
[null,null,"Venda Custo"]
["CACHAÇA"]
["Cachaça 500ml",null,null,4]
["Cachaça 300ml",null,null,2.4]
["Cachaça 200ml",null,1,1.5]
[]
[null,null,"Venda Custo"]
[]
[]
[null,"Soma de Itens",{"$f":"SUM(B107:C138)","v":1897}]
[null,null,"Venda Custo"]
[]
["TOTAL DAS VENDAS CUSTO",{"$f":"E143+E102","v":0},"TOTAL DAS VENDAS GERAL"]

{"sheet":"03-10-24","index":2,"n_rows":145,"n_cols":12,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol 1 litro",null,2,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Brahma 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 300ml",null,null,{"$f":"49.48/23","v":2.1513043478260867}]
["Cerveja Antartica 1 litro",{"$f":"6*12","v":72},15,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Antartica 1 litro",null,null,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser Long Neck",null,null,4]
["Cerveja Antartica 300ml",null,null,{"$f":"53.48/23","v":2.3252173913043479}]
["Cerveja original 300ml",null,null,{"$f":"59/23","v":2.5652173913043477}]
["Cerveja Stella 600ml",null,null,{"$f":"181.2/24","v":7.55}]
["Cerveja original 1 Litro",null,null,{"$f":"89.9/12","v":7.4916666666666671}]
["Cerveja original 473 ml",null,null,{"$f":"4.41","v":4.41}]
["Vodka Orloff 1 litro",null,null,28.4]
["Vodka Smirnoff 998ml",null,null,33.729999999999997]
["Cerveja Sparten Lata 473ml",null,null,{"$f":"49.9/12","v":4.1583333333333332}]
["Cerveja corona LongNeck",null,null,{"$f":"127/24","v":5.291666666666667}]
["Cachaça Seleta 1 litro",null,null,29.9]
["Wisky Red Label",null,null,74.900000000000006]
["Wisky Cavalo Branco",null,null,62.9]
["Refrigerante Pepsi 2 litros",null,1,6]
["Refrigerante Pepsi 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 2 litros",6,null,{"$f":"39.78/6","v":6.63}]
["Refrigerante Antarctica 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 350ml",null,null,{"$f":"11.6/12","v":0.96666666666666667}]
["Refrigerante Sukita 2 litros",null,null,{"$f":"28.75/6","v":4.791666666666667}]
["Refrigerante Sukita Laranja 200ml",null,null,{"$f":"16.68/12","v":1.39}]
["Energetico Red Bull 250ml",null,null,7.29]
["H2OH 1,5 litro limoneto",null,null,{"$f":"39.6/6","v":6.6000000000000005}]
["Bala Halls",null,null,1.1971000000000001]
["Skol Beats",null,null,{"$f":"38.4/8","v":4.8}]
["Biscoito Piraque",null,null,2.5]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Heineken 600ml",null,null,8.2899999999999991]
["Agua Mamba Water 350ml",null,null,2.17]
["Cerveja Lagunitas 350ml",null,null,4]
["Cerveja Amstel 1 litro",null,4,{"$f":"74.95/12","v":6.2458333333333336}]
["Cerveja BADEN 350ml",null,null,4.34]
[null,null,"Venda Custo"]
["ITAUP"]
["Refrigerante ItaUp sabores",null,null,{"$f":"18.9/6","v":3.15}]
["Energetico Fontt 2 litros",null,null,3]
[null,null,"Venda Custo"]
["COCA COLA"]
["Refrigerante Coca Cola 2 litros",{"$f":"6*6","v":36},2,{"$f":"46/6","v":7.666666666666667}]
["Refrigerante Coca Cola 2 litros Retornavel",null,4,5.7]
["Refrigerante Fanta Laranja 2 litros",null,null,{"$f":"35.5/6","v":5.916666666666667}]
["Refrigerante Coca Cola 2 litros Sem Açucar",null,null,{"$f":"63.2/8","v":7.9}]
["Refrigerante Coca Cola mini 200ml",null,null,{"$f":"17.4/12","v":1.45}]
["Refrigerante Fanta Laranja 600ml",null,null,3.62]
["Refrigerante Coca Cola lata 350ml",null,null,{"$f":"33/12","v":2.75}]
["Refrigerante Coca Cola 600ml",null,null,4.5]
["Refrigerante Coca Cola lata 350ml sem açucar",null,null,2.61]
["Suco DelVale 1,5",null,null,7.03]
["Suco Kappo",null,null,1.25]
[null,null,"Venda Custo"]
["NESTLE"]
["CHOKITO",null,null,1.66]
["PASSATEMPO",null,null,2.29]
["BONO",null,null,2.17]
["PRESTIGIO",null,null,1.54]
[null,null,"Venda Custo"]
["CARVÃO ROYTEC"]
["Carvão Roytec 2,5kg",null,null,8.5]
[null,null,"Venda Custo"]
["AGUA"]
["AGUA 20 LITROS",null,null,6]
["AGUA COM GÁS 510ML",null,null,{"$f":"14/12","v":1.1666666666666667}]
["AGUA SEM GÁS 510ML",null,null,{"$f":"10/12","v":0.83333333333333337}]
[null,null,"Venda Custo"]
["BE LONG"]
["Energetico one 2 litros",null,null,{"$f":"26.1/6","v":4.3500000000000005}]
["Vodka Darkoff 900ml",null,null,5.5]
["Vodka Darkoff 1,50 litros",null,null,{"$f":"90/12","v":7.5}]
["Combo Jaya 1,50 litros",null,null,{"$f":"D79+D85","v":14}]
["Combo One 1,50 litros",null,null,{"$f":"D79+D77","v":11.850000000000001}]
["Combo Jaya 900ml",null,null,{"$f":"5.3+6.8","v":12.1}]
["Combo One 900ml",null,null,{"$f":"4.7+5.3","v":10}]
["Vinho Bodegão Bordo 1 Litro",null,null,{"$f":"98.94/12","v":8.2449999999999992}]
["Energetico Jaya 2 litros",null,null,6.5]
["Ice One 300ml",null,null,1.89]
["Coquetel Banana Belong 960ml",null,null,{"$f":"93/6","v":15.5}]
["Chopp Bodegão 600ml",null,null,{"$f":"59.4/12","v":4.95}]
["Vinho Bodegão 2 Litros",null,null,16.5]
["Menta 900ml",null,null,5.9]
[null,null,"Venda Custo"]
["ARBOL"]
["Ousadia 500ml",null,null,{"$f":"38.92/12","v":3.2433333333333336}]
["Chopp Vinho Pink Moon 600ml",null,null,7.4]
["Vodka Komaroff 1L",null,null,6]
["Ice syn 300ml",null,null,{"$f":"43.23/24","v":1.8012499999999998}]
["GostoGin lata 269ml",null,null,{"$f":"81.58/24","v":3.3991666666666664}]
["Vinho Cantina da serra",null,null,{"$f":"53.72/12","v":4.4766666666666666}]
[null,null,"Venda Custo"]
[]
[null,"Soma de Itens",{"$f":"SUM(B4:C98)","v":142}]
[null,null,"Venda Custo"]
["INAH"]
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol Lata 473ml",null,null,{"$f":"41.9/12","v":3.4916666666666667}]
["Cerveja Skol Beats Lata 269ml",null,null,5.14]
["Cerveja Brahma 473ml",null,null,{"$f":"39/12","v":3.25}]
["Cerveja Brahma 473ml",{"$f":"30*12","v":360},null,{"$f":"40/12","v":3.3333333333333335}]
["Cerveja Antartica lata 473ml",{"$f":"109*12","v":1308},null,{"$f":"41/12","v":3.4166666666666665}]
["Cerveja Antartica lata 473ml",null,null,{"$f":"43.9/12","v":3.6583333333333332}]
["Cerveja Stella lata 473 ml",null,null,{"$f":"46.9/12","v":3.9083333333333332}]
["Cerveja Budweiser Latão",null,null,{"$f":"46.24/12","v":3.8533333333333335}]
["Cerveja Budweiser LongNeck",null,null,{"$f":"95.8/24","v":3.9916666666666667}]
["Brahma Duplo Malte",null,null,3.4249999999999998]
[]
[null,null,"Venda Custo"]
["ITAIPAVA"]
["Cerveja Itaipava Latão",null,null,{"$f":"30.15/12","v":2.5124999999999997}]
["Cerveja Lokal latão",null,null,{"$f":"27.4/12","v":2.2833333333333332},null,null,null,null,null,null,null,"                                                                                 "]
[null,null,"Venda Custo"]
["IMPERIO"]
["Creveja Imperio Latão Puro Malte",null,8,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Puro Malte",null,1,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Large",null,null,3.98]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Amstel 473ml",{"$f":"43*12","v":516},2,{"$f":"41.5/12","v":3.4583333333333335}]
["Cerveja Amstel 473ml",null,null,{"$f":"45/12","v":3.75}]
["Cerveja Heineken 350ml",null,null,{"$f":"49.89/12","v":4.1574999999999998}]
["Cerveja Heineken 473ml",48,1,{"$f":"57/12","v":4.75}]
[null,null,"Venda Custo"]
["CACHAÇA"]
["Cachaça 500ml",null,null,4]
["Cachaça 300ml",null,null,2.4]
["Cachaça 200ml",null,1,1.5]
[]
[null,null,"Venda Custo"]
[]
[]
[null,"Soma de Itens",{"$f":"SUM(B107:C138)","v":2245}]
[null,null,"Venda Custo"]
[]
["TOTAL DAS VENDAS CUSTO",{"$f":"E143+E102","v":0},"TOTAL DAS VENDAS GERAL"]

{"sheet":"04-10-24","index":3,"n_rows":145,"n_cols":12,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol 1 litro",12,2,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Brahma 1 litro",12,1,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Brahma 300ml",null,null,{"$f":"49.48/23","v":2.1513043478260867}]
["Cerveja Antartica 1 litro",{"$f":"17*12","v":204},78,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Antartica 1 litro",null,null,{"$f":"83/12","v":6.916666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser 1 litro",null,null,{"$f":"78.5/12","v":6.541666666666667}]
["Cerveja Budweiser Long Neck",null,null,4]
["Cerveja Antartica 300ml",null,null,{"$f":"53.48/23","v":2.3252173913043479}]
["Cerveja original 300ml",null,null,{"$f":"59/23","v":2.5652173913043477}]
["Cerveja Stella 600ml",null,null,{"$f":"181.2/24","v":7.55}]
["Cerveja original 1 Litro",null,null,{"$f":"89.9/12","v":7.4916666666666671}]
["Cerveja original 473 ml",null,null,{"$f":"4.41","v":4.41}]
["Vodka Orloff 1 litro",null,null,28.4]
["Vodka Smirnoff 998ml",null,null,33.729999999999997]
["Cerveja Sparten Lata 473ml",null,null,{"$f":"49.9/12","v":4.1583333333333332}]
["Cerveja corona LongNeck",null,null,{"$f":"127/24","v":5.291666666666667}]
["Cachaça Seleta 1 litro",null,null,29.9]
["Wisky Red Label",null,null,74.900000000000006]
["Wisky Cavalo Branco",null,null,62.9]
["Refrigerante Pepsi 2 litros",null,null,6]
["Refrigerante Pepsi 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 2 litros",null,1,{"$f":"39.78/6","v":6.63}]
["Refrigerante Antarctica 200ml",null,null,{"$f":"15/12","v":1.25}]
["Refrigerante Antarctica 350ml",null,null,{"$f":"11.6/12","v":0.96666666666666667}]
["Refrigerante Sukita 2 litros",null,2,{"$f":"28.75/6","v":4.791666666666667}]
["Refrigerante Sukita Laranja 200ml",null,null,{"$f":"16.68/12","v":1.39}]
["Energetico Red Bull 250ml",null,null,7.29]
["H2OH 1,5 litro limoneto",null,null,{"$f":"39.6/6","v":6.6000000000000005}]
["Bala Halls",null,null,1.1971000000000001]
["Skol Beats",null,null,{"$f":"38.4/8","v":4.8}]
["Biscoito Piraque",null,null,2.5]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Heineken 600ml",null,null,8.2899999999999991]
["Agua Mamba Water 350ml",null,null,2.17]
["Cerveja Lagunitas 350ml",null,null,4]
["Cerveja Amstel 1 litro",12,12,{"$f":"74.95/12","v":6.2458333333333336}]
["Cerveja BADEN 350ml",null,null,4.34]
[null,null,"Venda Custo"]
["ITAUP"]
["Refrigerante ItaUp sabores",null,null,{"$f":"18.9/6","v":3.15}]
["Energetico Fontt 2 litros",null,null,3]
[null,null,"Venda Custo"]
["COCA COLA"]
["Refrigerante Coca Cola 2 litros",{"$f":"5*6","v":30},1,{"$f":"46/6","v":7.666666666666667}]
["Refrigerante Coca Cola 2 litros Retornavel",null,null,5.7]
["Refrigerante Fanta Laranja 2 litros",null,null,{"$f":"35.5/6","v":5.916666666666667}]
["Refrigerante Coca Cola 2 litros Sem Açucar",null,null,{"$f":"63.2/8","v":7.9}]
["Refrigerante Coca Cola mini 200ml",null,null,{"$f":"17.4/12","v":1.45}]
["Refrigerante Fanta Laranja 600ml",null,null,3.62]
["Refrigerante Coca Cola lata 350ml",null,null,{"$f":"33/12","v":2.75}]
["Refrigerante Coca Cola 600ml",null,null,4.5]
["Refrigerante Coca Cola lata 350ml sem açucar",null,null,2.61]
["Suco DelVale 1,5",null,null,7.03]
["Suco Kappo",null,null,1.25]
[null,null,"Venda Custo"]
["NESTLE"]
["CHOKITO",null,null,1.66]
["PASSATEMPO",null,null,2.29]
["BONO",null,null,2.17]
["PRESTIGIO",null,null,1.54]
[null,null,"Venda Custo"]
["CARVÃO ROYTEC"]
["Carvão Roytec 2,5kg",null,null,8.5]
[null,null,"Venda Custo"]
["AGUA"]
["AGUA 20 LITROS",null,1,6]
["AGUA COM GÁS 510ML",null,1,{"$f":"14/12","v":1.1666666666666667}]
["AGUA SEM GÁS 510ML",null,null,{"$f":"10/12","v":0.83333333333333337}]
[null,null,"Venda Custo"]
["BE LONG"]
["Energetico one 2 litros",12,1,{"$f":"26.1/6","v":4.3500000000000005}]
["Vodka Darkoff 900ml",12,null,5.5]
["Vodka Darkoff 1,50 litros",null,null,{"$f":"90/12","v":7.5}]
["Combo Jaya 1,50 litros",null,null,{"$f":"D79+D85","v":14}]
["Combo One 1,50 litros",null,null,{"$f":"D79+D77","v":11.850000000000001}]
["Combo Jaya 900ml",null,null,{"$f":"5.3+6.8","v":12.1}]
["Combo One 900ml",null,null,{"$f":"4.7+5.3","v":10}]
["Vinho Bodegão Bordo 1 Litro",null,null,{"$f":"98.94/12","v":8.2449999999999992}]
["Energetico Jaya 2 litros",null,1,6.5]
["Ice One 300ml",null,null,1.89]
["Coquetel Banana Belong 960ml",null,null,{"$f":"93/6","v":15.5}]
["Chopp Bodegão 600ml",null,null,{"$f":"59.4/12","v":4.95}]
["Vinho Bodegão 2 Litros",null,2,16.5]
["Menta 900ml",null,null,5.9]
[null,null,"Venda Custo"]
["ARBOL"]
["Ousadia 500ml",null,null,{"$f":"38.92/12","v":3.2433333333333336}]
["Chopp Vinho Pink Moon 600ml",null,null,7.4]
["Vodka Komaroff 1L",null,null,6]
["Ice syn 300ml",null,null,{"$f":"43.23/24","v":1.8012499999999998}]
["GostoGin lata 269ml",null,null,{"$f":"81.58/24","v":3.3991666666666664}]
["Vinho Cantina da serra",null,null,{"$f":"53.72/12","v":4.4766666666666666}]
[null,null,"Venda Custo"]
[]
[null,"Soma de Itens",{"$f":"SUM(B4:C98)","v":397}]
[null,null,"Venda Custo"]
["INAH"]
["Produto","Quantidade Vendida Quente","Quantidade Vendida Gelada","Preço Custo"]
["AMBEV"]
["Coluna1","Coluna2","Coluna3","Coluna4","Coluna5","Coluna6","Coluna7","Coluna8","Coluna9","Coluna10","Coluna11"]
["Cerveja Skol Lata 473ml",null,null,{"$f":"41.9/12","v":3.4916666666666667}]
["Cerveja Skol Beats Lata 269ml",null,null,5.14]
["Cerveja Brahma 473ml",null,null,{"$f":"40/12","v":3.3333333333333335}]
["Cerveja Brahma 473ml",null,null,{"$f":"41.9/12","v":3.4916666666666667}]
["Cerveja Antartica lata 473ml",24,{"$f":"4+24","v":28},{"$f":"41/12","v":3.4166666666666665}]
["Cerveja Antartica lata 473ml",null,null,{"$f":"43.9/12","v":3.6583333333333332}]
["Cerveja Stella lata 473 ml",null,null,{"$f":"46.9/12","v":3.9083333333333332}]
["Cerveja Budweiser Latão",null,null,{"$f":"46.24/12","v":3.8533333333333335}]
["Cerveja Budweiser LongNeck",null,null,{"$f":"95.8/24","v":3.9916666666666667}]
["Brahma Duplo Malte",null,null,3.4249999999999998]
[]
[null,null,"Venda Custo"]
["ITAIPAVA"]
["Cerveja Itaipava Latão",null,null,{"$f":"30.15/12","v":2.5124999999999997}]
["Cerveja Lokal latão",null,null,{"$f":"27.4/12","v":2.2833333333333332},null,null,null,null,null,null,null,"                                                                                 "]
[null,null,"Venda Custo"]
["IMPERIO"]
["Creveja Imperio Latão Puro Malte",null,1,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Puro Malte",null,12,{"$f":"37/12","v":3.0833333333333335}]
["Creveja Imperio Latão Large",null,null,3.98]
[null,null,"Venda Custo"]
["HEINEKEN"]
["Cerveja Amstel 473ml",24,{"$f":"2+24","v":26},{"$f":"41.5/12","v":3.4583333333333335}]
["Cerveja Amstel 473ml",null,null,{"$f":"45/12","v":3.75}]
["Cerveja Heineken 350ml",null,null,{"$f":"49.89/12","v":4.1574999999999998}]
["Cerveja Heineken 473ml",{"$f":"7*12","v":84},{"$f":"24","v":24},{"$f":"57/12","v":4.75}]
[null,null,"Venda Custo"]
["CACHAÇA"]
["Cachaça 500ml",null,null,4]
["Cachaça 300ml",null,null,2.4]
["Cachaça 200ml",null,null,1.5]
[]
[null,null,"Venda Custo"]
[]
[]
[null,"Soma de Itens",{"$f":"SUM(B107:C138)","v":223}]
[null,null,"Venda Custo"]
[]
["TOTAL DAS VENDAS CUSTO",{"$f":"E143+E102","v":0},"TOTAL DAS VENDAS GERAL"]