{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Principal","Regras e Promoções","Impostos","Tabela"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Principal","index":0,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,17,31,18],[28,1,31,2],[23,12,26,13],[1,1,5,2],[7,1,10,2],[12,1,15,2],[17,1,20,2],[8,16,11,17],[8,19,11,20],[8,22,11,23],[1,12,6,13],[13,12,18,13]]}
[]
[null,{"$error":"#VALUE!"},null,null,"Fornecedor","Produto","Preço de Custo","Preço Minimo","Markup PM","Preço Sugestivo","Markup PS",null,{"$error":"#VALUE!"},null,null,"Fornecedor",null,"Produto",null,null,null,null,"Preço de Custo","Preço Minimo","Markup PM","Preço Sugestivo","Markup PS"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F3,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A1))), \"\")","v":"BIO OMEGA 3 (18/12) 120 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F3,Tabela!$B:$B,0)),\"\")","v":59.18},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F3,Tabela!$B:$B,0)),\"\")","v":98.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F3,Tabela!$B:$B,0)),\"\")","v":1.6711726934775264},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F3,Tabela!$B:$B,0)),\"\")","v":113.7},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F3,Tabela!$B:$B,0)),\"\")","v":1.9212571814802299},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R3,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"NATURELLE"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$8) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(L1))), \"\")","v":"NO RED FPS 30 - 100G UNID"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R3,Tabela!$B:$B,0)),\"\")","v":49.74},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R3,Tabela!$B:$B,0)),\"\")","v":89.5},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R3,Tabela!$B:$B,0)),\"\")","v":1.7993566546039403},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R3,Tabela!$B:$B,0)),\"\")","v":102.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R3,Tabela!$B:$B,0)),\"\")","v":2.06875753920386}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F4,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A2))), \"\")","v":"COENZIMA Q10 100MG 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F4,Tabela!$B:$B,0)),\"\")","v":86.76},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F4,Tabela!$B:$B,0)),\"\")","v":145},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F4,Tabela!$B:$B,0)),\"\")","v":1.6712770862148454},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F4,Tabela!$B:$B,0)),\"\")","v":166.8},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F4,Tabela!$B:$B,0)),\"\")","v":1.9225449515905948},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R4,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BOTANIK KOSMETICS"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$8) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(L2))), \"\")","v":"NO RED FPS 40 - 60G UNID."},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R4,Tabela!$B:$B,0)),\"\")","v":51.52},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R4,Tabela!$B:$B,0)),\"\")","v":95.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R4,Tabela!$B:$B,0)),\"\")","v":1.861413043478261},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R4,Tabela!$B:$B,0)),\"\")","v":110.3},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R4,Tabela!$B:$B,0)),\"\")","v":2.1409161490683228}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F5,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BASECOL MIX"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A3))), \"\")","v":"COLAG VERISOL GELATINA 30 GOMAS FR VERM. 240G"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F5,Tabela!$B:$B,0)),\"\")","v":88.91},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F5,Tabela!$B:$B,0)),\"\")","v":142.5},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F5,Tabela!$B:$B,0)),\"\")","v":1.6027443482172985},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F5,Tabela!$B:$B,0)),\"\")","v":163.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F5,Tabela!$B:$B,0)),\"\")","v":1.8434371836688788},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R5,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BOTANIK KOSMETICS"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$8) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(L3))), \"\")","v":"NO RED FPS 50 C/COR 60G UNID."},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R5,Tabela!$B:$B,0)),\"\")","v":61.78},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R5,Tabela!$B:$B,0)),\"\")","v":108.5},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R5,Tabela!$B:$B,0)),\"\")","v":1.7562317902233733},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R5,Tabela!$B:$B,0)),\"\")","v":124.8},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R5,Tabela!$B:$B,0)),\"\")","v":2.0200712204596956}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F6,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BASECOL MIX"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A4))), \"\")","v":"COLAG VERISOL PECTINA 30 GOMAS FR VERM. 216G UN"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F6,Tabela!$B:$B,0)),\"\")","v":84.9},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F6,Tabela!$B:$B,0)),\"\")","v":119.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F6,Tabela!$B:$B,0)),\"\")","v":1.4122497055359247},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F6,Tabela!$B:$B,0)),\"\")","v":137.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F6,Tabela!$B:$B,0)),\"\")","v":1.624263839811543},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R6,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"KILT DISTRIBUIDORA"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$8) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(L4))), \"\")","v":"NO RED LOCAO AUTOBRONZEADORA 120G"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R6,Tabela!$B:$B,0)),\"\")","v":13.83},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R6,Tabela!$B:$B,0)),\"\")","v":34.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R6,Tabela!$B:$B,0)),\"\")","v":2.5234996384671002},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R6,Tabela!$B:$B,0)),\"\")","v":40.1},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R6,Tabela!$B:$B,0)),\"\")","v":2.8994938539407089}]
[null,"PURIS",null,null,{"$f":"IFERROR(VLOOKUP(F7,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A5))), \"\")","v":"COLAGENO POTE NEUTRO 360G"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F7,Tabela!$B:$B,0)),\"\")","v":66.55},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F7,Tabela!$B:$B,0)),\"\")","v":111.2},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F7,Tabela!$B:$B,0)),\"\")","v":1.670924117205109},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F7,Tabela!$B:$B,0)),\"\")","v":127.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F7,Tabela!$B:$B,0)),\"\")","v":1.921863260706236},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R7,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$8) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(L5))), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R7,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R7,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R7,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R7,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R7,Tabela!$B:$B,0)),\"\")","v":""}]
[null,{"$error":"#VALUE!"},null,null,{"$f":"IFERROR(VLOOKUP(F8,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A6))), \"\")","v":"COLAGENO SACHE 12G - ABACAXI"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F8,Tabela!$B:$B,0)),\"\")","v":73.31},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F8,Tabela!$B:$B,0)),\"\")","v":124.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F8,Tabela!$B:$B,0)),\"\")","v":1.7037239121538672},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F8,Tabela!$B:$B,0)),\"\")","v":143.6},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F8,Tabela!$B:$B,0)),\"\")","v":1.9588050743418359},null,"NORED"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F9,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A7))), \"\")","v":"COLAGENO SACHE 12G - LARANJA COM ACEROLA"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F9,Tabela!$B:$B,0)),\"\")","v":73.31},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F9,Tabela!$B:$B,0)),\"\")","v":124.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F9,Tabela!$B:$B,0)),\"\")","v":1.7037239121538672},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F9,Tabela!$B:$B,0)),\"\")","v":143.6},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F9,Tabela!$B:$B,0)),\"\")","v":1.9588050743418359},null,null,null,null,null,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F10,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A8))), \"\")","v":"COLAGENO TIPO II 750MG 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F10,Tabela!$B:$B,0)),\"\")","v":76.61},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F10,Tabela!$B:$B,0)),\"\")","v":129.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F10,Tabela!$B:$B,0)),\"\")","v":1.6956010964626029},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F10,Tabela!$B:$B,0)),\"\")","v":149.4},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F10,Tabela!$B:$B,0)),\"\")","v":1.9501370578253492}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F11,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BASECOL MIX"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A9))), \"\")","v":"COLAGENO VERISOL PO 210G SEM SABOR"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F11,Tabela!$B:$B,0)),\"\")","v":76.989999999999995},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F11,Tabela!$B:$B,0)),\"\")","v":119.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F11,Tabela!$B:$B,0)),\"\")","v":1.5573451097545137},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F11,Tabela!$B:$B,0)),\"\")","v":137.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F11,Tabela!$B:$B,0)),\"\")","v":1.791141706715158}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F12,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BASECOL MIX"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A10))), \"\")","v":"CREATINA MONOHIDRATADA PECT FR VERM GOMAS 240GR"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F12,Tabela!$B:$B,0)),\"\")","v":69.900000000000006},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F12,Tabela!$B:$B,0)),\"\")","v":119.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F12,Tabela!$B:$B,0)),\"\")","v":1.7153075822603718},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F12,Tabela!$B:$B,0)),\"\")","v":137.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F12,Tabela!$B:$B,0)),\"\")","v":1.9728183118741058}]
[null,{"$error":"#VALUE!"},null,null,{"$f":"IFERROR(VLOOKUP(F13,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"BASECOL MIX"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A11))), \"\")","v":"CREATINA MONOHIDRATADA PECT UVA GOMAS 240GR"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F13,Tabela!$B:$B,0)),\"\")","v":69.900000000000006},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F13,Tabela!$B:$B,0)),\"\")","v":119.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F13,Tabela!$B:$B,0)),\"\")","v":1.7153075822603718},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F13,Tabela!$B:$B,0)),\"\")","v":137.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F13,Tabela!$B:$B,0)),\"\")","v":1.9728183118741058}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F14,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A12))), \"\")","v":"DHA PLUS (OMEGA 3) 120 CAPS 1G"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F14,Tabela!$B:$B,0)),\"\")","v":103.51},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F14,Tabela!$B:$B,0)),\"\")","v":173.5},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F14,Tabela!$B:$B,0)),\"\")","v":1.6761665539561394},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F14,Tabela!$B:$B,0)),\"\")","v":199.5},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F14,Tabela!$B:$B,0)),\"\")","v":1.9273500144913533},null,{"$error":"#VALUE!"},null,null,"Fornecedor",null,"Produto",null,null,null,null,"Preço de Custo","Preço Minimo","Markup PM","Preço Sugestivo","Markup PS"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F15,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A13))), \"\")","v":"ENZYMAX SACHES 2G"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F15,Tabela!$B:$B,0)),\"\")","v":43.8},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F15,Tabela!$B:$B,0)),\"\")","v":104.89500000000001},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F15,Tabela!$B:$B,0)),\"\")","v":2.3948630136986306},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F15,Tabela!$B:$B,0)),\"\")","v":120.6},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F15,Tabela!$B:$B,0)),\"\")","v":2.7534246575342465},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R15,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"PASTEUR"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$20) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A1))), \"\")","v":"HIDRATANTE CORPORAL MAG 200G"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R15,Tabela!$B:$B,0)),\"\")","v":15.74},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R15,Tabela!$B:$B,0)),\"\")","v":39.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R15,Tabela!$B:$B,0)),\"\")","v":2.5349428208386278},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R15,Tabela!$B:$B,0)),\"\")","v":45.9},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R15,Tabela!$B:$B,0)),\"\")","v":2.9161372299872932}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F16,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A14))), \"\")","v":"LACTOBACILLUS SACHES 2G"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F16,Tabela!$B:$B,0)),\"\")","v":89.53},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F16,Tabela!$B:$B,0)),\"\")","v":143.745},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F16,Tabela!$B:$B,0)),\"\")","v":1.6055512118842847},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F16,Tabela!$B:$B,0)),\"\")","v":165.3},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F16,Tabela!$B:$B,0)),\"\")","v":1.8463084999441528},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R16,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"PASTEUR"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$20) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A2))), \"\")","v":"HIDRATANTE PARA PES MAG 60G"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R16,Tabela!$B:$B,0)),\"\")","v":10.43},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R16,Tabela!$B:$B,0)),\"\")","v":25.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R16,Tabela!$B:$B,0)),\"\")","v":2.4832214765100669},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R16,Tabela!$B:$B,0)),\"\")","v":29.8},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R16,Tabela!$B:$B,0)),\"\")","v":2.8571428571428572}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F17,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"CROMOFLORAIS"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A15))), \"\")","v":"MELATONINA 0,21MG GOTA 30ML - CX C/10 UN"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F17,Tabela!$B:$B,0)),\"\")","v":16.5},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F17,Tabela!$B:$B,0)),\"\")","v":28.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F17,Tabela!$B:$B,0)),\"\")","v":1.7515151515151515},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F17,Tabela!$B:$B,0)),\"\")","v":33.200000000000003},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F17,Tabela!$B:$B,0)),\"\")","v":2.0121212121212122},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R17,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"PASTEUR"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$20) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A3))), \"\")","v":"MANTEIGA CORPORAL MAG 210G"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R17,Tabela!$B:$B,0)),\"\")","v":17.43},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R17,Tabela!$B:$B,0)),\"\")","v":47.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R17,Tabela!$B:$B,0)),\"\")","v":2.7481353987378085},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R17,Tabela!$B:$B,0)),\"\")","v":55.1},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R17,Tabela!$B:$B,0)),\"\")","v":3.1612162937464143}]
[null,{"$error":"#VALUE!"},null,null,{"$f":"IFERROR(VLOOKUP(F18,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A16))), \"\")","v":"OMEGA 3 PLUS (33/22) 1G 120 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F18,Tabela!$B:$B,0)),\"\")","v":82.85},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F18,Tabela!$B:$B,0)),\"\")","v":138.69},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F18,Tabela!$B:$B,0)),\"\")","v":1.6739891369945685},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F18,Tabela!$B:$B,0)),\"\")","v":159.5},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F18,Tabela!$B:$B,0)),\"\")","v":1.9251659625829813},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R18,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$20) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A4))), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R18,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R18,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R18,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R18,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R18,Tabela!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F19,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A17))), \"\")","v":"OMEGAMEMO 1000MG 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F19,Tabela!$B:$B,0)),\"\")","v":79.75},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F19,Tabela!$B:$B,0)),\"\")","v":133.5},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F19,Tabela!$B:$B,0)),\"\")","v":1.6739811912225706},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F19,Tabela!$B:$B,0)),\"\")","v":153.5},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F19,Tabela!$B:$B,0)),\"\")","v":1.9247648902821317},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R19,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$20) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A5))), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R19,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R19,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R19,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R19,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R19,Tabela!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F20,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A18))), \"\")","v":"RESVERATROL 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F20,Tabela!$B:$B,0)),\"\")","v":96.96},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F20,Tabela!$B:$B,0)),\"\")","v":155.9},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F20,Tabela!$B:$B,0)),\"\")","v":1.6078795379537956},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F20,Tabela!$B:$B,0)),\"\")","v":179.3},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F20,Tabela!$B:$B,0)),\"\")","v":1.849216171617162},null,"MAG"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F21,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A19))), \"\")","v":"VITAMINA C 1G 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F21,Tabela!$B:$B,0)),\"\")","v":39.979999999999997},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F21,Tabela!$B:$B,0)),\"\")","v":66.900000000000006},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F21,Tabela!$B:$B,0)),\"\")","v":1.6733366683341673},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F21,Tabela!$B:$B,0)),\"\")","v":76.900000000000006},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F21,Tabela!$B:$B,0)),\"\")","v":1.9234617308654329}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F22,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"VITAFOR"},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A20))), \"\")","v":"VITAMINA D3 (2.000UI) 500MG 60 CAPS"},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F22,Tabela!$B:$B,0)),\"\")","v":43.12},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F22,Tabela!$B:$B,0)),\"\")","v":72.19},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F22,Tabela!$B:$B,0)),\"\")","v":1.674165120593692},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F22,Tabela!$B:$B,0)),\"\")","v":83},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F22,Tabela!$B:$B,0)),\"\")","v":1.9248608534322822}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F23,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A21))), \"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F23,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F23,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F23,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F23,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F23,Tabela!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F24,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(#REF!))), \"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F24,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F24,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F24,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F24,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F24,Tabela!$B:$B,0)),\"\")","v":""},null,{"$error":"#VALUE!"},null,null,"Fornecedor",null,"Produto",null,null,null,null,"Preço de Custo","Preço Minimo","Markup PM","Preço Sugestivo","Markup PS"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F25,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(#REF!))), \"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F25,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F25,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F25,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F25,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F25,Tabela!$B:$B,0)),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R25,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":"ATIVA BRASIL"},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$28) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A1))), \"\")","v":"NANO NAILS REPARADOR UNHAS 7ML UN"},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R25,Tabela!$B:$B,0)),\"\")","v":21.5},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R25,Tabela!$B:$B,0)),\"\")","v":46.65},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R25,Tabela!$B:$B,0)),\"\")","v":2.1697674418604649},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R25,Tabela!$B:$B,0)),\"\")","v":53.6},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R25,Tabela!$B:$B,0)),\"\")","v":2.4930232558139536}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(F26,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=Principal!$B$7) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A24))), \"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(F26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(F26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH($F26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH($F26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH($F26,Tabela!$B:$B,0)),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(VLOOKUP(R26,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$28) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A2))), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R26,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R26,Tabela!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(R27,Tabela!$B$1:$C$69,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(INDEX(Tabela!$B$2:$B$69, _xlfn.AGGREGATE(15, 6, (ROW(Tabela!$B$2:$B$69)-ROW(Tabela!$B$2)+1) / ((Tabela!$D$2:$D$69=$M$28) * (Tabela!$E$2:$E$69=\"Ativo\")), ROW(A3))), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX(Tabela!$F:$F,MATCH(R27,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$G:$G,MATCH(R27,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$H:$H,MATCH(R27,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$I:$I,MATCH(R27,Tabela!$B:$B,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Tabela!$J:$J,MATCH(R27,Tabela!$B:$B,0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAESTRINE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]

{"sheet":"Regras e Promoções","index":1,"n_rows":45,"n_cols":39,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,38,39,40],[29,5,30,8],[32,5,33,8],[29,9,30,11],[32,9,33,11],[34,32,36,37],[30,32,32,37],[38,32,40,37],[27,18,29,28],[21,9,22,11],[30,38,31,40],[34,38,35,40],[23,32,24,36],[21,38,22,42],[23,38,24,42],[20,18,22,28],[24,17,25,20],[13,17,14,46],[21,32,22,36],[21,12,22,12],[37,2,44,13],[15,17,15,46],[16,17,16,46],[17,17,17,46],[29,12,30,12],[32,12,33,12],[16,3,17,12],[23,2,28,13],[42,25,47,28],[44,18,46,23],[31,18,33,28],[36,18,41,28],[21,3,22,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proibido!"]
[]
[null,null,null,"Selecione o Produto",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anúnciar descontos nos sites de e-commerce de produtos que estão com prazo de 6 meses ou menos, sem destacar a validade e o nome da sua farmácia."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A identificação se faz necessária para que possamos fazer uma rastreabilidade do lote caso apresente algum problema."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Os preços minimos devem ser respeitados seja na venda de balcão ou na venda por internet, caso infrinja a regra, será passivel de notificação e até exclusão do quadro associativo."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regra para Produtos com validade curta"]
[null,null,null,"Preço de custo Promocional:",null,null,null,null,null,0,null,null,"/UN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 meses",null,null,null,null,null,"3 meses"]
[]
[null,null,"Autorizado de forma automatica a vender em um prazo de até 30 dias após o encerramento da Promoção da Oser.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descontos de até 30%",null,null,null,null,null,"Descontos de até 50%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marketplace"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Os produtos Marca própria podem ser vendidos em marketplace desde que sejam respeitados as seguintes regras:"]
[]
[null,null,null,{"$f":"INDEX(#REF!,MATCH('Regras e Promoções'!$D$17,#REF!,0))","v":{"$error":"#REF!"}},null,"Preço Mínimo:",null,null,null,{"$f":"IFERROR($J$22*$D$30,\"R$ 0,00\")","v":"R$ 0,00"},null,null,"/UN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preço de Venda:",null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH($D$17,#REF!,0)),\"Selecione\")","v":"Selecione"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   1º - O preço mínimo a ser aplicado na revanda deve respeitar o preço informado na Tabela;"]
[null,null,null,{"$f":"INDEX(#REF!+0.2,MATCH('Regras e Promoções'!$D$17,#REF!,0))","v":{"$error":"#REF!"}},null,"Preço Sugerido:",null,null,null,{"$f":"IFERROR($J$22*$D$33,\"R$ 0,00\")","v":"R$ 0,00"},null,null,"/UN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preço de Venda 6 meses:",null,null,null,null,null,{"$f":"IFERROR($AM$31*0.7,\"R$ 0,00\")","v":"R$ 0,00"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     2º - Só pode ser vendido em marketplace que identifique quem está vendendo, no caso a farmácia, e não a OLIST por exemplo. Isso se faz necessário, pois se o produto apresentar qualquer problema, só poderemos rastrear o lote identificando a farmácia."]
[null,null,"Essa condição é valida para promoções feitas pela Oser onde você tem autorização para fazer uma condição especial. Por exemplo, a promoção da Oser contempla na compra de  1un a bonificação de  outra unidade, nesse caso você deve incluir no campo \"Preço de custo Promocional\" o valor da unidade com 50% de desconto, assim você terá os valores permitidos. Esses valores podem ser usados até o final do mês subsequente ao mês da promoção."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preço de Venda 3 meses:",null,null,null,null,null,{"$f":"IFERROR($AM$31*0.5,\"R$ 0,00\")","v":"R$ 0,00"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informação Registrada na ATA da Assembleia de novembro de 2020."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marketplace"]

{"sheet":"Impostos","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Estado de Destino","ICMS Interestadual","Alíquota Interna","DIFAL","FCP"]
["AC",7.0000000000000007E-2,0.17,0.1,0.02]
["AL",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"Origem:","RS"]
["AP",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"Destino:","SP"]
["AM",7.0000000000000007E-2,0.18,0.11,0.02]
["BA",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"ICMS Interestadual:",{"$f":"INDEX($B$2:$B$28,MATCH($K$3,$A$2:$A$28,0))","v":0.12}]
["CE",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"Alíquota Interna Destino:",{"$f":"INDEX($C$2:$C$28,MATCH($K$4,$A$2:$A$28,0))","v":0.18}]
["DF",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"FCP Destino:",{"$f":"INDEX(E2:E28,MATCH($K$4,$A$2:$A$28,0))","v":0.02}]
["ES",0.12,0.17,0.05,0.02,null,null,null,null,"DIFAL:",{"$f":"K7-K6","v":0.06}]
["GO",7.0000000000000007E-2,0.17,0.1,0.02,null,null,null,null,"FCP Origem:",{"$f":"INDEX(E2:E28,MATCH($K$3,$A$2:$A$28,0))","v":0.02}]
["MA",7.0000000000000007E-2,0.18,0.11,0.02]
["MT",7.0000000000000007E-2,0.17,0.1,0.02,null,null,null,null,"Custo:",1000]
["MS",7.0000000000000007E-2,0.17,0.1,0.02,null,null,null,null,"Cálculo:"]
["MG",0.12,0.18,0.06,0.02]
["PA",7.0000000000000007E-2,0.17,0.1,0.02,null,null,null,null,"ICMS Interestadual:",{"$f":"K12*K6","v":120}]
["PB",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"DIFAL:",{"$f":"K12*K9","v":60},"(dividido entre estado de origem e estado de destino)"]
["PR",0.12,0.18,0.06,0.02,null,null,null,null,"FCP:",{"$f":"K12*K8","v":20}]
["PE",7.0000000000000007E-2,0.18,0.11,0.02,null,null,null,null,"TOTAL:",{"$f":"SUM(K15:K17)","v":200}]
["PI",7.0000000000000007E-2,0.18,0.11,0.02]
["RJ",0.12,0.2,0.08,0.02]
["RN",7.0000000000000007E-2,0.18,0.11,0.02]
["RO",7.0000000000000007E-2,0.17,0.1,0.02]
["RR",7.0000000000000007E-2,0.17,0.1,0.02]
["RS",0.12,0.18,0.06,0.02]
["SC",0.12,0.17,0.05,0.02]
["SP",0.12,0.18,0.06,0.02]
["SE",7.0000000000000007E-2,0.18,0.11,0.02]
["TO",7.0000000000000007E-2,0.18,0.11,0.02]

{"sheet":"Tabela","index":3,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Produto","Descrição","Fornecedor","Linha","Situação","Preço de Venda","Preço Minimo","Markup PM","Preço Sugestivo","Markup PS"]
[161,"NANO NAILS REPARADOR UNHAS 7ML UN","ATIVA BRASIL","MAESTRINE","ATIVO",21.5,46.65,{"$f":"G2/F2","v":2.1697674418604649},{"$f":"ROUND(G2*1.15,1)","v":53.6},{"$f":"I2/F2","v":2.4930232558139536}]
[45,"HIDRATANTE CORPORAL MAG 200G","PASTEUR","MAG","ATIVO",15.74,39.9,{"$f":"G3/F3","v":2.5349428208386278},{"$f":"ROUND(G3*1.15,1)","v":45.9},{"$f":"I3/F3","v":2.9161372299872932}]
[46,"HIDRATANTE PARA MAOS MAG 60G","PASTEUR","MAG","INATIVO",11,33.9,{"$f":"G4/F4","v":3.0818181818181816},{"$f":"ROUND(G4*1.15,1)","v":39},{"$f":"I4/F4","v":3.5454545454545454}]
[47,"HIDRATANTE PARA PES MAG 60G","PASTEUR","MAG","ATIVO",10.43,25.9,{"$f":"G5/F5","v":2.4832214765100669},{"$f":"ROUND(G5*1.15,1)","v":29.8},{"$f":"I5/F5","v":2.8571428571428572}]
[48,"MANTEIGA CORPORAL MAG 210G","PASTEUR","MAG","ATIVO",17.43,47.9,{"$f":"G6/F6","v":2.7481353987378085},{"$f":"ROUND(G6*1.15,1)","v":55.1},{"$f":"I6/F6","v":3.1612162937464143}]
[57,"NO RED FPS 30 - 100G UNID","NATURELLE","NORED","ATIVO",49.74,89.5,{"$f":"G7/F7","v":1.7993566546039403},{"$f":"ROUND(G7*1.15,1)","v":102.9},{"$f":"I7/F7","v":2.06875753920386}]
[54,"NO RED FPS 40 - 60G UNID.","BOTANIK KOSMETICS","NORED","ATIVO",51.52,95.9,{"$f":"G8/F8","v":1.861413043478261},{"$f":"ROUND(G8*1.15,1)","v":110.3},{"$f":"I8/F8","v":2.1409161490683228}]
[55,"NO RED FPS 50 C/COR 60G UNID.","BOTANIK KOSMETICS","NORED","ATIVO",61.78,108.5,{"$f":"G9/F9","v":1.7562317902233733},{"$f":"ROUND(G9*1.15,1)","v":124.8},{"$f":"I9/F9","v":2.0200712204596956}]
[56,"NO RED LOCAO AUTOBRONZEADORA 120G","KILT DISTRIBUIDORA","NORED","ATIVO",13.83,34.9,{"$f":"G10/F10","v":2.5234996384671002},{"$f":"ROUND(G10*1.15,1)","v":40.1},{"$f":"I10/F10","v":2.8994938539407089}]
[1,"AGARICUSOL 300MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",46.51,81.400000000000006,{"$f":"G11/F11","v":1.7501612556439476},{"$f":"ROUND(G11*1.15,1)","v":93.6},{"$f":"I11/F11","v":2.0124704364652763}]
[8,"BCAA 500MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",45.87,80.3,{"$f":"G12/F12","v":1.750599520383693},{"$f":"ROUND(G12*1.15,1)","v":92.3},{"$f":"I12/F12","v":2.0122084150861128}]
[9,"BERINJELA 450MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",26.21,47.4,{"$f":"G13/F13","v":1.8084700495993895},{"$f":"ROUND(G13*1.15,1)","v":54.5},{"$f":"I13/F13","v":2.0793590232735597}]
[10,"BETACAROTENO 400MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",22.97,40.200000000000003,{"$f":"G14/F14","v":1.7501088376142797},{"$f":"ROUND(G14*1.15,1)","v":46.2},{"$f":"I14/F14","v":2.0113191118850677}]
[58,"BIO OMEGA 3 (18/12) 120 CAPS","VITAFOR","PURIS","ATIVO",59.18,98.9,{"$f":"G15/F15","v":1.6711726934775264},{"$f":"ROUND(G15*1.15,1)","v":113.7},{"$f":"I15/F15","v":1.9212571814802299}]
[11,"CALCIO ENRIQUECIDO 700MG (CA+VIT. D+MG+ZN) 60 CAPS","AD OCEANUM","PURIS","INATIVO",19.36,36.4,{"$f":"G16/F16","v":1.8801652892561984},{"$f":"ROUND(G16*1.15,1)","v":41.9},{"$f":"I16/F16","v":2.1642561983471076}]
[12,"CARTILAGEM DE TUBARAO 120 CAPS","AD OCEANUM","PURIS","INATIVO",23.39,43.3,{"$f":"G17/F17","v":1.8512184694313807},{"$f":"ROUND(G17*1.15,1)","v":49.8},{"$f":"I17/F17","v":2.1291150064129969}]
[13,"CLORELLA 300MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",33.58,58.75,{"$f":"G18/F18","v":1.7495533055390113},{"$f":"ROUND(G18*1.15,1)","v":67.599999999999994},{"$f":"I18/F18","v":2.0131030375223347}]
[14,"CLORELLA 300MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",21.43,40.5,{"$f":"G19/F19","v":1.8898740083994401},{"$f":"ROUND(G19*1.15,1)","v":46.6},{"$f":"I19/F19","v":2.1745216985534297}]
[63,"COENZIMA Q10 100MG 60 CAPS","VITAFOR","PURIS","ATIVO",86.76,145,{"$f":"G20/F20","v":1.6712770862148454},{"$f":"ROUND(G20*1.15,1)","v":166.8},{"$f":"I20/F20","v":1.9225449515905948}]
[142,"COLAG VERISOL GELATINA 30 GOMAS FR VERM. 240G","BASECOL MIX","PURIS","ATIVO",88.91,142.5,{"$f":"G21/F21","v":1.6027443482172985},{"$f":"ROUND(G21*1.15,1)","v":163.9},{"$f":"I21/F21","v":1.8434371836688788}]
[159,"COLAG VERISOL PECTINA 30 GOMAS FR VERM. 216G UN","BASECOL MIX","PURIS","ATIVO",84.9,119.9,{"$f":"G22/F22","v":1.4122497055359247},{"$f":"ROUND(G22*1.15,1)","v":137.9},{"$f":"I22/F22","v":1.624263839811543}]
[15,"COLAGENO 500MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",19.96,41.5,{"$f":"G23/F23","v":2.0791583166332663},{"$f":"ROUND(G23*1.15,1)","v":47.7},{"$f":"I23/F23","v":2.3897795591182365}]
[62,"COLAGENO POTE NEUTRO 360G","VITAFOR","PURIS","ATIVO",66.55,111.2,{"$f":"G24/F24","v":1.670924117205109},{"$f":"ROUND(G24*1.15,1)","v":127.9},{"$f":"I24/F24","v":1.921863260706236}]
[59,"COLAGENO SACHE 12G - ABACAXI","VITAFOR","PURIS","ATIVO",73.31,124.9,{"$f":"G25/F25","v":1.7037239121538672},{"$f":"ROUND(G25*1.15,1)","v":143.6},{"$f":"I25/F25","v":1.9588050743418359}]
[60,"COLAGENO SACHE 12G - LARANJA COM ACEROLA","VITAFOR","PURIS","ATIVO",73.31,124.9,{"$f":"G26/F26","v":1.7037239121538672},{"$f":"ROUND(G26*1.15,1)","v":143.6},{"$f":"I26/F26","v":1.9588050743418359}]
[77,"COLAGENO TIPO II 750MG 60 CAPS","VITAFOR","PURIS","ATIVO",76.61,129.9,{"$f":"G27/F27","v":1.6956010964626029},{"$f":"ROUND(G27*1.15,1)","v":149.4},{"$f":"I27/F27","v":1.9501370578253492}]
[143,"COLAGENO VERISOL PO 210G SEM SABOR","BASECOL MIX","PURIS","ATIVO",76.989999999999995,119.9,{"$f":"G28/F28","v":1.5573451097545137},{"$f":"ROUND(G28*1.15,1)","v":137.9},{"$f":"I28/F28","v":1.791141706715158}]
[2188,"CREATINA MONOHIDRATADA GEL UVA 30 GOMAS 240GR","BASECOL MIX","PURIS","INATIVO",69.900000000000006,119.9,{"$f":"G29/F29","v":1.7153075822603718},{"$f":"ROUND(G29*1.15,1)","v":137.9},{"$f":"I29/F29","v":1.9728183118741058}]
[2200,"CREATINA MONOHIDRATADA PECT FR VERM GOMAS 240GR","BASECOL MIX","PURIS","ATIVO",69.900000000000006,119.9,{"$f":"G30/F30","v":1.7153075822603718},{"$f":"ROUND(G30*1.15,1)","v":137.9},{"$f":"I30/F30","v":1.9728183118741058}]
[2201,"CREATINA MONOHIDRATADA PECT UVA GOMAS 240GR","BASECOL MIX","PURIS","ATIVO",69.900000000000006,119.9,{"$f":"G31/F31","v":1.7153075822603718},{"$f":"ROUND(G31*1.15,1)","v":137.9},{"$f":"I31/F31","v":1.9728183118741058}]
[68,"DHA PLUS (OMEGA 3) 120 CAPS 1G","VITAFOR","PURIS","ATIVO",103.51,173.5,{"$f":"G32/F32","v":1.6761665539561394},{"$f":"ROUND(G32*1.15,1)","v":199.5},{"$f":"I32/F32","v":1.9273500144913533}]
[64,"ENZYMAX SACHES 2G","VITAFOR","PURIS","ATIVO",43.8,104.89500000000001,{"$f":"G33/F33","v":2.3948630136986306},{"$f":"ROUND(G33*1.15,1)","v":120.6},{"$f":"I33/F33","v":2.7534246575342465}]
[16,"GUARANA E ACAI 550MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",16.940000000000001,33.549999999999997,{"$f":"G34/F34","v":1.9805194805194801},{"$f":"ROUND(G34*1.15,1)","v":38.6},{"$f":"I34/F34","v":2.278630460448642}]
[66,"LACTOBACILLUS SACHES 2G","VITAFOR","PURIS","ATIVO",89.53,143.745,{"$f":"G35/F35","v":1.6055512118842847},{"$f":"ROUND(G35*1.15,1)","v":165.3},{"$f":"I35/F35","v":1.8463084999441528}]
[18,"LECITINA DE SOJA 1G 60 CAPS","AD OCEANUM","PURIS","INATIVO",21.61,38,{"$f":"G36/F36","v":1.7584451642757983},{"$f":"ROUND(G36*1.15,1)","v":43.7},{"$f":"I36/F36","v":2.022211938917168}]
[17,"LECITINA DE SOJA 500MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",17.670000000000002,31,{"$f":"G37/F37","v":1.7543859649122806},{"$f":"ROUND(G37*1.15,1)","v":35.700000000000003},{"$f":"I37/F37","v":2.0203735144312391}]
[19,"LICOPENO 300MG 30 CAPS","AD OCEANUM","PURIS","INATIVO",27.83,48.9,{"$f":"G38/F38","v":1.757096658282429},{"$f":"ROUND(G38*1.15,1)","v":56.2},{"$f":"I38/F38","v":2.0194035213798061}]
[20,"LUTEINA 250MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",24.55,46.5,{"$f":"G39/F39","v":1.8940936863543787},{"$f":"ROUND(G39*1.15,1)","v":53.5},{"$f":"I39/F39","v":2.1792260692464356}]
[21,"MAGNESIO BISGLICINATO 755MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",31.95,55.9,{"$f":"G40/F40","v":1.7496087636932707},{"$f":"ROUND(G40*1.15,1)","v":64.3},{"$f":"I40/F40","v":2.0125195618153362}]
[131,"MALATO DE MAGNESIO 1650MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",58.68,94,{"$f":"G41/F41","v":1.6019086571233812},{"$f":"ROUND(G41*1.15,1)","v":108.1},{"$f":"I41/F41","v":1.8421949556918882}]
[149,"MELATONINA 0,21MG GOTA 30ML - CX C/10 UN","CROMOFLORAIS","PURIS","ATIVO",16.5,28.9,{"$f":"G42/F42","v":1.7515151515151515},{"$f":"ROUND(G42*1.15,1)","v":33.200000000000003},{"$f":"I42/F42","v":2.0121212121212122}]
[22,"OLEO DE ALHO 400MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",13.63,29.9,{"$f":"G43/F43","v":2.1936903888481289},{"$f":"ROUND(G43*1.15,1)","v":34.4},{"$f":"I43/F43","v":2.5238444607483488}]
[23,"OLEO DE BORRAGEM 500MG 90 CAPS","AD OCEANUM","PURIS","INATIVO",48.77,85.4,{"$f":"G44/F44","v":1.7510764814435105},{"$f":"ROUND(G44*1.15,1)","v":98.2},{"$f":"I44/F44","v":2.0135329095755585}]
[24,"OLEO DE CARTAMO 1G 120 CAPS","AD OCEANUM","PURIS","INATIVO",44.17,97.1,{"$f":"G45/F45","v":2.198324654743038},{"$f":"ROUND(G45*1.15,1)","v":111.7},{"$f":"I45/F45","v":2.5288657459814354}]
[25,"OLEO DE CHIA 500MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",36.81,64.5,{"$f":"G46/F46","v":1.752241238793806},{"$f":"ROUND(G46*1.15,1)","v":74.2},{"$f":"I46/F46","v":2.0157565878837271}]
[26,"OLEO DE COCO 1G PURIS 120 CAPS","AD OCEANUM","PURIS","INATIVO",45.94,80.599999999999994,{"$f":"G47/F47","v":1.7544623421854593},{"$f":"ROUND(G47*1.15,1)","v":92.7},{"$f":"I47/F47","v":2.0178493687418375}]
[27,"OLEO DE COCO 1G PURIS 60 CAPS","AD OCEANUM","PURIS","INATIVO",27.81,57.9,{"$f":"G48/F48","v":2.0819848975188782},{"$f":"ROUND(G48*1.15,1)","v":66.599999999999994},{"$f":"I48/F48","v":2.3948220064724919}]
[28,"OLEO DE FIGADO DE BACALHAU 250MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",25.38,44.5,{"$f":"G49/F49","v":1.7533490937746257},{"$f":"ROUND(G49*1.15,1)","v":51.2},{"$f":"I49/F49","v":2.0173364854215921}]
[31,"OLEO DE LINHACA 1G 60 CAPS","AD OCEANUM","PURIS","INATIVO",23.37,45,{"$f":"G50/F50","v":1.9255455712451861},{"$f":"ROUND(G50*1.15,1)","v":51.8},{"$f":"I50/F50","v":2.2165169020111253}]
[30,"OLEO DE LINHACA 750MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",21.19,37.200000000000003,{"$f":"G51/F51","v":1.7555450684285041},{"$f":"ROUND(G51*1.15,1)","v":42.8},{"$f":"I51/F51","v":2.0198206701274182}]
[32,"OLEO DE PEIXE OMEGA 3 1G 120 CAPS","AD OCEANUM","PURIS","INATIVO",43.57,76.5,{"$f":"G52/F52","v":1.7557952719761303},{"$f":"ROUND(G52*1.15,1)","v":88},{"$f":"I52/F52","v":2.019738352077117}]
[33,"OLEO DE PEIXE OMEGA 3 500MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",27.83,57.5,{"$f":"G53/F53","v":2.0661157024793391},{"$f":"ROUND(G53*1.15,1)","v":66.099999999999994},{"$f":"I53/F53","v":2.3751347466762485}]
[36,"OLEO DE PRIMULA 750MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",19.3,45,{"$f":"G54/F54","v":2.3316062176165802},{"$f":"ROUND(G54*1.15,1)","v":51.8},{"$f":"I54/F54","v":2.6839378238341967}]
[67,"OMEGA 3 PLUS (33/22) 1G 120 CAPS","VITAFOR","PURIS","ATIVO",82.85,138.69,{"$f":"G55/F55","v":1.6739891369945685},{"$f":"ROUND(G55*1.15,1)","v":159.5},{"$f":"I55/F55","v":1.9251659625829813}]
[34,"OMEGA 3 PLUS (33/22) 1G 60 CAPS","AD OCEANUM","PURIS","INATIVO",51.71,96.62,{"$f":"G56/F56","v":1.868497389286405},{"$f":"ROUND(G56*1.15,1)","v":111.1},{"$f":"I56/F56","v":2.148520595629472}]
[37,"OMEGA 3/6/9 1G 60 CAPS","SOROCAPS","PURIS","INATIVO",null,null,{"$f":"G57/F57","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(G57*1.15,1)","v":0},{"$f":"I57/F57","v":{"$error":"#DIV/0!"}}]
[2185,"OMEGAMEMO 1000MG 60 CAPS","VITAFOR","PURIS","ATIVO",79.75,133.5,{"$f":"G58/F58","v":1.6739811912225706},{"$f":"ROUND(G58*1.15,1)","v":153.5},{"$f":"I58/F58","v":1.9247648902821317}]
[69,"OMEGAMEMO 1G 60 CAPS","VITAFOR","PURIS","INATIVO",27.07,94.39500000000001,{"$f":"G59/F59","v":3.4870705578130776},{"$f":"ROUND(G59*1.15,1)","v":108.6},{"$f":"I59/F59","v":4.0118212042851864}]
[38,"OSTEO PUR 500MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",36.049999999999997,65.760000000000005,{"$f":"G60/F60","v":1.8241331484049934},{"$f":"ROUND(G60*1.15,1)","v":75.599999999999994},{"$f":"I60/F60","v":2.0970873786407767}]
[39,"QUITOSANA PECTINA E PSYLLIUM 600MG 120 CAPS","AD OCEANUM","PURIS","INATIVO",59.2,104.1,{"$f":"G61/F61","v":1.7584459459459458},{"$f":"ROUND(G61*1.15,1)","v":119.7},{"$f":"I61/F61","v":2.0219594594594592}]
[2184,"RESVERATROL 60 CAPS","VITAFOR","PURIS","ATIVO",96.96,155.9,{"$f":"G62/F62","v":1.6078795379537956},{"$f":"ROUND(G62*1.15,1)","v":179.3},{"$f":"I62/F62","v":1.849216171617162}]
[40,"SELENIO E VITAMINA E 250MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",13.17,29.9,{"$f":"G63/F63","v":2.2703113135914958},{"$f":"ROUND(G63*1.15,1)","v":34.4},{"$f":"I63/F63","v":2.6119969627942292}]
[41,"SUPLEMENTO VITAMINICO MINERAL 450MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",21.24,42.9,{"$f":"G64/F64","v":2.0197740112994351},{"$f":"ROUND(G64*1.15,1)","v":49.3},{"$f":"I64/F64","v":2.3210922787193975}]
[79,"VITAMINA C 1G 60 CAPS","VITAFOR","PURIS","ATIVO",39.979999999999997,66.900000000000006,{"$f":"G65/F65","v":1.6733366683341673},{"$f":"ROUND(G65*1.15,1)","v":76.900000000000006},{"$f":"I65/F65","v":1.9234617308654329}]
[148,"VITAMINA D3 (2.000UI) 10ML","VITAFOR","PURIS","INATIVO",27.36,67.105499999999992,{"$f":"G66/F66","v":2.4526864035087717},{"$f":"ROUND(G66*1.15,1)","v":77.2},{"$f":"I66/F66","v":2.8216374269005851}]
[71,"VITAMINA D3 (2.000UI) 500MG 60 CAPS","VITAFOR","PURIS","ATIVO",43.12,72.19,{"$f":"G67/F67","v":1.674165120593692},{"$f":"ROUND(G67*1.15,1)","v":83},{"$f":"I67/F67","v":1.9248608534322822}]
[130,"VITAMINA E 400UI 750MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",45.76,80.5,{"$f":"G68/F68","v":1.7591783216783217},{"$f":"ROUND(G68*1.15,1)","v":92.6},{"$f":"I68/F68","v":2.0236013986013988}]
[42,"VITAMINAS DO COMPLEXO B 280MG 60 CAPS","AD OCEANUM","PURIS","INATIVO",13.1,27.2,{"$f":"G69/F69","v":2.0763358778625953},{"$f":"ROUND(G69*1.15,1)","v":31.3},{"$f":"I69/F69","v":2.389312977099237}]