{"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":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["PRODUTO","QUANT.","01/10/2024",null,null,null,"PLANILHAS",null,null,null,"GUIAS"]
["Cerveja Skol 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A2,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A2,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":20.75},null,null,null,"02-10-24",null,null,1,{"$f":"IFERROR(INDEX(GUIAS,J2),\"\")","v":"RESUMO"}]
["Cerveja Brahma 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A3,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A3,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":39.25},null,null,null,"03-10-24",null,null,2,{"$f":"IFERROR(INDEX(GUIAS,J3),\"\")","v":"02-10-24"}]
["Cerveja Brahma 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A4,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A4,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":39.25},null,null,null,"04-10-24",null,null,3,{"$f":"IFERROR(INDEX(GUIAS,J4),\"\")","v":"03-10-24"}]
["Cerveja Brahma 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A5,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A5,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.4539130434782601},null,null,null,null,null,null,4,{"$f":"IFERROR(INDEX(GUIAS,J5),\"\")","v":"04-10-24"}]
["Cerveja Antartica 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A6,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":300},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A6,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":41.5},null,null,null,null,null,null,5]
["Cerveja Antartica 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A7,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":300},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A7,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":41.5},null,null,null,null,null,null,6]
["Cerveja Budweiser 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A8,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A8,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":39.25},null,null,null,null,null,null,7]
["Cerveja Budweiser 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A9,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A9,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":39.25},null,null,null,null,null,null,8]
["Cerveja Budweiser Long Neck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A10,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A10,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":12},null,null,null,null,null,null,9]
["Cerveja Antartica 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A11,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A11,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.9756521739130442},null,null,null,null,null,null,10]
["Cerveja original 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A12,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A12,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":7.695652173913043}]
["Cerveja Stella 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A13,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A13,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":22.65}]
["Cerveja original 1 Litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A14,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A14,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":22.475000000000001}]
["Cerveja original 473 ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A15,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A15,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":13.23}]
["Vodka Orloff 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A16,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A16,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":85.199999999999989}]
["Vodka Smirnoff 998ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A17,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A17,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":101.19}]
["Cerveja Sparten Lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A18,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A18,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":12.475}]
["Cerveja corona LongNeck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A19,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A19,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":15.875}]
["Cachaça Seleta 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A20,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A20,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":89.699999999999989}]
["Wisky Red Label",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A21,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A21,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":224.70000000000002}]
["Wisky Cavalo Branco",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A22,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A22,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":188.7}]
["Refrigerante Pepsi 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A23,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A23,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18.04}]
["Refrigerante Pepsi 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A24,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A24,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":3.75}]
["Refrigerante Antarctica 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A25,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":6},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A25,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":19.89}]
["Refrigerante Antarctica 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A26,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A26,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":3.75}]
["Refrigerante Antarctica 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A27,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A27,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":2.9}]
["Refrigerante Sukita 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A28,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A28,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":14.375}]
["Refrigerante Sukita Laranja 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A29,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A29,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":4.17}]
["Energetico Red Bull 250ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A30,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A30,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.87}]
["H2OH 1,5 litro limoneto",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A31,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A31,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":19.8}]
["Bala Halls",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A32,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A32,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":3.5913000000000004}]
["Skol Beats",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A33,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A33,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":14.399999999999999}]
["Biscoito Piraque",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A34,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A34,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":7.5}]
["Cerveja Heineken 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A35,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A35,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":24.869999999999997}]
["Agua Mamba Water 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A36,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A36,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.51}]
["Cerveja Lagunitas 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A37,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A37,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":12}]
["Cerveja Amstel 1 litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A38,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A38,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18.737500000000001}]
["Cerveja BADEN 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A39,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A39,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":13.02}]
["Refrigerante ItaUp sabores",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A40,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A40,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":9.4499999999999993}]
["Energetico Fontt 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A41,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A41,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":9}]
["Refrigerante Coca Cola 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A42,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":108},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A42,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":23}]
["Refrigerante Coca Cola 2 litros Retornavel",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A43,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A43,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":17.100000000000001}]
["Refrigerante Coca Cola 2,250",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A44,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A44,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":0}]
["Refrigerante Coca Cola 2,250 Sem Açucar",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A45,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A45,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":0}]
["Refrigerante Coca Cola mini 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A46,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A46,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":4.3499999999999996}]
["Refrigerante Fanta Laranja 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A47,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A47,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":10.86}]
["Refrigerante Coca Cola lata 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A48,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A48,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":8.25}]
["Refrigerante Coca Cola 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A49,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A49,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":13.5}]
["Refrigerante Coca Cola lata 350ml sem açucar",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A50,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A50,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":7.83}]
["Suco DelVale 1,5",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A51,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A51,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.09}]
["Suco Kappo",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A52,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A52,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":3.75}]
["CHOKITO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A53,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A53,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":4.9799999999999995}]
["PASSATEMPO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A54,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A54,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.87}]
["BONO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A55,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A55,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.51}]
["PRESTIGIO",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A56,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A56,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":4.62}]
["Carvão Roytec 2,5kg",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A57,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A57,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":25.5}]
["AGUA 20 LITROS",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A58,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A58,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18}]
["AGUA COM GÁS 510ML",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A59,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A59,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":3.5}]
["AGUA SEM GÁS 510ML",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A60,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A60,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":2.5}]
["Energetico one 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A61,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A61,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":13.05}]
["Vodka Darkoff 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A62,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":12},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A62,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":16.5}]
["Vodka Darkoff 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A63,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A63,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":22.5}]
["Combo Jaya 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A64,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A64,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":42}]
["Combo One 1,50 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A65,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A65,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":35.550000000000004}]
["Combo Jaya 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A66,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A66,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":36.299999999999997}]
["Combo One 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A67,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A67,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":30}]
["Vinho Bodegão Bordo 1 Litro",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A68,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A68,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":24.734999999999999}]
["Energetico Jaya 2 litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A69,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A69,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":19.5}]
["Ice One 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A70,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A70,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":5.67}]
["Coquetel Banana Belong 960ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A71,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A71,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":46.5}]
["Chopp Bodegão 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A72,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A72,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":14.850000000000001}]
["Vinho Bodegão 2 Litros",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A73,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A73,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":49.5}]
["Menta 900ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A74,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A74,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":17.700000000000003}]
["Ousadia 500ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A75,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A75,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":9.73}]
["Chopp Vinho Pink Moon 600ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A76,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A76,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":22.200000000000003}]
["Vodka Komaroff 1L",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A77,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A77,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18}]
["Ice syn 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A78,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A78,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":5.4037499999999996}]
["GostoGin lata 269ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A79,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A79,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":10.1975}]
["Vinho Cantina da serra",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A80,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A80,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":13.43}]
["Cerveja Skol Lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A81,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A81,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":10.475}]
["Cerveja Skol Beats Lata 269ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A82,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A82,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":15.419999999999998}]
["Cerveja Brahma 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A83,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":360},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A83,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":20.150000000000002}]
["Cerveja Brahma 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A84,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":360},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A84,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":20.150000000000002}]
["Cerveja Antartica lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A85,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":3036},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A85,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.224999999999998}]
["Cerveja Antartica lata 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A86,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":3036},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A86,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.224999999999998}]
["Cerveja Stella lata 473 ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A87,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A87,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":11.725}]
["Cerveja Budweiser Latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A88,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A88,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":11.56}]
["Cerveja Budweiser LongNeck",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A89,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A89,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":11.975}]
["Brahma Duplo Malte",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A90,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A90,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":10.274999999999999}]
["Cerveja Itaipava Latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A91,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A91,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":7.5374999999999996}]
["Cerveja Lokal latão",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A92,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A92,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":6.85}]
["Creveja Imperio Latão Puro Malte",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A93,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A93,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18.5}]
["Creveja Imperio Latão Puro Malte",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A94,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A94,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":18.5}]
["Creveja Imperio Latão Large",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A95,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A95,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":11.94}]
["Cerveja Amstel 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A96,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":552},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A96,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.625}]
["Cerveja Amstel 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A97,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":552},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A97,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":21.625}]
["Cerveja Heineken 350ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A98,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A98,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":12.4725}]
["Cerveja Heineken 473ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A99,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":288},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A99,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":14.25}]
["Cachaça 500ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A100,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A100,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":12}]
["Cachaça 300ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A101,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A101,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":7.1999999999999993}]
["Cachaça 200ml",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A102,INDIRECT(\"'\"&$G$2:$G$4&\"'!B:B\")))","v":0},{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$G$2:$G$4&\"'!A:A\"),A102,INDIRECT(\"'\"&$G$2:$G$4&\"'!D:D\")))","v":4.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"]