{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HIST. OPERAÇÕES","Planilha1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":8,"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":"HIST. OPERAÇÕES","index":0,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Histórico de Operações",null,null,{"$f":"COUNTIF(TB_HistoricoOperacoes[Ativo],\"<>\")","v":14}]
[null,"Registro","Data Entrada","Corretora","Nota","Ativo","C / V","Qtde","Vlr Entrada","Total Ativo (E)","PM (Preço Médio)","Resultado Esperado PM","Data - Saída","Vlr Saída","Total Ativo (S)"]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":1},"2021-03-20","Modal Mais",1620,"NTCO3","V",150,37,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":5550},null,-38.14,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":2},"2021-03-20","Modal Mais",1631,"BBSS3","C",250,20.6,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":5150},null,20.6,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":3},"2021-03-17","Modal Mais",1620,"TASA4","C",500,10.3,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":5150},null,0,"2021-03-20",21.32,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":10660}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":4},"2021-03-16","XP",4221,"MRFG3","V",150,14.54,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":2181},null,-14.59,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":5},"2021-03-16","Modal Mais",2119,"NTCO3","V",200,39,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":7800},null,-38.14,"-",null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":6},"2021-03-09","Rico",3037,"VALE3","C",100,24.12,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":2412},null,24.12,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":7},"2021-03-09","XP",4112,"VALE3","C",200,24.46,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":4892},null,24.46,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":8},"2021-03-08","Genial Investimentos",1620,"GOAU4","C",200,11.92,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":2384},null,null,"2021-03-12",11.52,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":2304}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":9},"2021-03-08","Genial Investimentos",1620,"ENBR3","C",100,18.79,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":1879},null,18.48,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":10},"2021-03-08","Genial Investimentos",1620,"PRFM3","C",100,8.8699999999999992,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":886.99999999999989},null,null,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":11},"2021-03-05","Modal Mais",1405,"MRFG3","V",35,14.59,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":510.65},null,-14.59,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":12},"2021-03-04","Genial Investimentos",1405,"MRFG3","V",45,14.67,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":660.15},null,-14.59,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":13},"2021-03-01","Clear",1728,"MRFG3","V",200,14.61,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":2922},null,null,"2021-03-02",14.72,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":2944}]
[null,{"$f":"ROW()-ROW(TB_HistoricoOperacoes[[#Headers],[Registro]])","v":14},"2021-02-26","Genial Investimentos",2109,"ENBR3","C",245,18.350000000000001,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Entrada]]","v":4495.75},null,18.48,null,null,{"$f":"TB_HistoricoOperacoes[[#This Row],[Qtde]]*TB_HistoricoOperacoes[[#This Row],[Vlr Saída]]","v":0}]
[]
[]
[null,"Boa tarde, colaboradores do fórum."]
[null,"Preciso de ajuda em uma fórmula que calcula o Preço Médio de Ativos de um ativo que ainda estão com posição aberta."]
[null,"Condição para ativos com posição aberta:"]
[null,"Coluna [Data - Saída] = \"\" (vazio) ou Coluna [Data - Saída] = \"-\" e Coluna [Vlr Saída] = 0"]
[null,"A fórmula deve retornar o PM somente dos ativos das linhas com posição aberta."]
[null,"Inseri uma coluna na qual apresento o resultado esperado."]
[null,"Por padrão as linhas que estiverem com a posição encerrada devem retornar [[PM (Preço médio] = R$ 0,00"]
[null,"Seguem alguns exemplos para demonstrar o resultado esperado."]
[null,"Situação A:"]
[null,"Linhas 1 e 5 da Tabela"]
[null,"O Ativo NTCO3 apresenta 2 posições vendidas"]
[null,"(150 x 37,00 = 5.550,00) e (200 x 39,00 = 7.800,00)"]
[null,"Resultado esperado (5.550 + 7.800) / 350 = - 38,14 (negativo pois é uma posição vendida)"]
[null,"Situação B:"]
[null,"Linhas 3 da Tabela"]
[null,"O Ativo TASA4 não apresenta operação aberta"]
[null,"Portanto o campo [PM (Preço médio] = R$ 0,00"]
[null,"Situação C:"]
[null,"Linhas 4, 11, 12 e 13 - Ativo MRFG3 com 4 posições Vendidas porém uma delas está encerrada"]
[null,"Restam 3 posições vendidas com PM de ((150 x 14,54) + (100 x 14,59) + (100 x 14,67)) / 350"]
[null,"PM = 5.307/350"]
[null,"PM = - 14,59 (sinal negativo pq é uma posição vendida)"]
[null,"Muito obrigado a quem puder colaborar."]
[null,"Segue planilha de exemplo para testes."]

{"sheet":"Planilha1","index":1,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[2,18,2,19],[2,20,2,21]]}
[]
[]
[null,"Papel","Numero do Trade",null,1,null,{"$f":"E3+1","v":2},null,{"$f":"G3+1","v":3},null,{"$f":"I3+1","v":4},null,{"$f":"K3+1","v":5},null,{"$f":"M3+1","v":6},"FECHTO.",null,null,"Corret.",null,"TAB.EVENTOS"]
[null,"MRFG3","Tipo de operação",null,{"$f":"IF(AND(E8=\"\",B8=\"\"),\"\",IF($B8<>\"Opção\",\"À vista\",\"Day Trade\"))","v":"À vista"},null,{"$f":"IF(AND(D8=\"CP\",F8=\"VD\",G8=E8),\"Day Trade\",\"À vista\")","v":"À vista"},null,{"$f":"IF(AND(F8=\"CP\",H8=\"VD\",I8=G8),\"Day Trade\",\"À vista\")","v":"À vista"},null,{"$f":"IF(AND(H8=\"CP\",J8=\"VD\",K8=I8),\"Day Trade\",\"À vista\")","v":"À vista"},null,{"$f":"IF(AND(J8=\"CP\",L8=\"VD\",M8=K8),\"Day Trade\",\"À vista\")","v":"À vista"},null,{"$f":"IF(AND(L8=\"CP\",N8=\"VD\",O8=M8),\"Day Trade\",\"À vista\")","v":"À vista"},"APURAÇÃO","OPERAÇÃO",null,"CÓDIGO","NOME","CP","COMPRA"]
[null,{"$f":"IF(AND(E5>0,B6<>\"\"),CONCATENATE(A5,$B6),\" \")","v":" "},"Saldo Anterior (Fís.)",null,0,null,{"$f":"E16","v":200},null,{"$f":"G16","v":0},null,{"$f":"I16","v":45},null,{"$f":"K16","v":80},null,{"$f":"M16","v":230},"Cotação",null,null,"XP","XP-CORRET","VD","VENDA"]
[null,null,"Saldo Anterior (Fin.)",null,0,null,{"$f":"IF(E17>0,E17,0)","v":2922},null,{"$f":"IF(G17>0,G17,0)","v":0},null,{"$f":"IF(I17>0,I17,0)","v":660.15},null,{"$f":"IF(K17>0,K17,0)","v":1170.8},null,{"$f":"IF(M17>0,M17,0)","v":3351.8},"Val.Cart.",{"$f":"Q5*O16","v":0},null,"IT","ITAÚ","AG","AGRUPTO."]
[null,{"$f":"IF(AND(B5<>\"\",E5>0),CONCATENATE($A$17,B6),\" \")","v":" "},"Preço Médio Anterior",null,{"$f":"IF(E6<1,0,(E6/E5))","v":0},null,{"$f":"IF(G6<1,0,(G6/G5))","v":14.61},null,{"$f":"IF(I6<1,0,(I6/I5))","v":0},null,{"$f":"IF(K6<1,0,(K6/K5))","v":14.67},null,{"$f":"IF(M6<1,0,(M6/M5))","v":14.635},null,{"$f":"IF(O6<1,0,(O6/O5))","v":14.573043478260871},"Variação",{"$f":"Q6-O17","v":-3351.8},null,"MO","MODAL","SP","SPLIT"]
[null,null,"Data da Operação","CP","2021-03-01","VD","2021-03-02","CP","2021-03-05","CP","2021-03-16","CP","2021-03-17","CP",null,"Resultado",{"$f":"IF(Q7<0,\"PREJÚ\",IF(Q7=0,\"NEUTRO\",\"LUCRO\"))","v":"PREJÚ"},null,null,null,"BN","BÔNUS"]
[{"$f":"VLOOKUP($A8,$U$6:$V$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C$1,[1]Diário!$B$9:$H$95,MATCH($I$2,[1]Diário!$B$9:$H$9,FALSE))","v":{"$error":"#N/A"}},"Quantidade",null,200,null,200,null,45,null,35,null,150,null,null,"RESUMO",null,null,null,null,"SB","SUBSCRIÇÃO"]
["EVENTOS",null,"Cotação",null,14.61,null,14.72,null,14.67,null,14.59,null,14.54,null,null,{"$f":"SUMIF($D8:$O8,\"CP\",$E11:$O11)*-1","v":-6273.8},"compra"]
[null,null,"SubTotal da Operação",null,{"$f":"E10*E9","v":2922},null,{"$f":"G10*G9","v":2944},null,{"$f":"I10*I9","v":660.15},null,{"$f":"K10*K9","v":510.65},null,{"$f":"M10*M9","v":2181},null,{"$f":"O10*O9","v":0},{"$f":"SUMIF($D8:$O8,\"VD\",$E11:$O11)","v":2944},"venda"]
[null,null,"Corretagem","XP",0,"XP",0,"XP",0,"XP",0,"XP",0,"XP",0,{"$f":"SUM($D12:$O12)","v":0},"corret."]
[null,null,"Emolumentos",null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM($D13:$O13)","v":0},"emolum."]
[null,null,"Total da Despesa",null,{"$f":"SUM(E12:E13)","v":0},null,{"$f":"SUM(G12:G13)","v":0},null,{"$f":"SUM(I12:I13)","v":0},null,{"$f":"SUM(K12:K13)","v":0},null,{"$f":"SUM(M12:M13)","v":0},null,{"$f":"SUM(O12:O13)","v":0},{"$f":"SUM($D14:$O14)*-1","v":0},"despesa"]
[null,null,"LÍQUIDO DA OPERAÇÃO",null,{"$f":"IF(D8=\"CP\",(E11+E14),IF(D8=\"VD\",(E11-E14)*-1,0))","v":2922},null,{"$f":"IF(F8=\"CP\",(G11+G14),IF(F8=\"VD\",(G11-G14)*-1,0))","v":-2944},null,{"$f":"IF(H8=\"CP\",(I11+I14),IF(H8=\"VD\",(I11-I14)*-1,0))","v":660.15},null,{"$f":"IF(J8=\"CP\",(K11+K14),IF(J8=\"VD\",(K11-K14)*-1,0))","v":510.65},null,{"$f":"IF(L8=\"CP\",(M11+M14),IF(L8=\"VD\",(M11-M14)*-1,0))","v":2181},null,{"$f":"IF(N8=\"CP\",(O11+O14),IF(N8=\"VD\",(O11-O14)*-1,0))","v":0},{"$f":"SUM($P10:$P11,$P14)","v":-3329.8},"Soma"]
[null,null,"Saldo Atual (Fís.)",null,{"$f":"IF(D8=\"AG\",(E5/$B8),IF(D8=\"SP\",(E5*$B8),IF(D8=\"VD\",(E5-E9),IF(OR(D8=\"BN\",D8=\"SB\",D8=\"CP\"),E9+E5,E5))))","v":200},null,{"$f":"IF(F8=\"AG\",(G5/$B8),IF(F8=\"SP\",(G5*$B8),IF(F8=\"VD\",(G5-G9),IF(OR(F8=\"BN\",F8=\"SB\",F8=\"CP\"),G9+G5,G5))))","v":0},null,{"$f":"IF(H8=\"AG\",(I5/$B8),IF(H8=\"SP\",(I5*$B8),IF(H8=\"VD\",(I5-I9),IF(OR(H8=\"BN\",H8=\"SB\",H8=\"CP\"),I9+I5,I5))))","v":45},null,{"$f":"IF(J8=\"AG\",(K5/$B8),IF(J8=\"SP\",(K5*$B8),IF(J8=\"VD\",(K5-K9),IF(OR(J8=\"BN\",J8=\"SB\",J8=\"CP\"),K9+K5,K5))))","v":80},null,{"$f":"IF(L8=\"AG\",(M5/$B8),IF(L8=\"SP\",(M5*$B8),IF(L8=\"VD\",(M5-M9),IF(OR(L8=\"BN\",L8=\"SB\",L8=\"CP\"),M9+M5,M5))))","v":230},null,{"$f":"IF(N8=\"AG\",(O5/$B8),IF(N8=\"SP\",(O5*$B8),IF(N8=\"VD\",(O5-O9),IF(OR(N8=\"BN\",N8=\"SB\",N8=\"CP\"),O9+O5,O5))))","v":230},"RETORNO"]
[null,null,"Saldo Atual (Fin.)",null,{"$f":"IF(E6+E15<1,0,E6+E15)","v":2922},null,{"$f":"IF(G6+G15<1,0,G6+G15)","v":0},null,{"$f":"IF(I6+I15<1,0,I6+I15)","v":660.15},null,{"$f":"IF(K6+K15<1,0,K6+K15)","v":1170.8},null,{"$f":"IF(M6+M15<1,0,M6+M15)","v":3351.8},null,{"$f":"IF(O6+O15<1,0,O6+O15)","v":3351.8},"Bruto",{"$f":"P21","v":22}]
[null,null,"Preço Médio Atual",null,{"$f":"IF(AND(E7=0,E9>1),(E15/E9),0)","v":14.61},null,{"$f":"IFERROR(G17/G16,0)","v":0},null,{"$f":"IFERROR(I17/I16,0)","v":14.67},null,{"$f":"IFERROR(K17/K16,0)","v":14.635},null,{"$f":"IFERROR(M17/M16,0)","v":14.573043478260871},null,{"$f":"IFERROR(O17/O16,0)","v":14.573043478260871},"Líquido",{"$f":"(Q17-(P24+P25))","v":18.7}]
[null,null,"Retorno Day Trade",null,{"$f":"IF(AND(D8=\"VD\",E4=\"Day Trade\"),(E11-E14)-(E7*E9),0)","v":0},null,{"$f":"IF(AND(F8=\"VD\",G4=\"Day Trade\"),(G11-G14)-(G7*G9),0)","v":0},null,{"$f":"IF(AND(H8=\"VD\",I4=\"Day Trade\"),(I11-I14)-(I7*I9),0)","v":0},null,{"$f":"IF(AND(J8=\"VD\",K4=\"Day Trade\"),(K11-K14)-(K7*K9),0)","v":0},null,{"$f":"IF(AND(L8=\"VD\",M4=\"Day Trade\"),(M11-M14)-(M7*M9),0)","v":0},null,{"$f":"IF(AND(N8=\"VD\",O4=\"Day Trade\"),(O11-O14)-(O7*O9),0)","v":0},{"$f":"SUM(E19:O19)","v":0},"Day Trade"]
[null,null,"Retorno À Vista",null,{"$f":"IF(AND(D8=\"VD\",E4=\"À vista\"),(E11-E14)-(E7*E9),0)","v":0},null,{"$f":"IF(AND(F8=\"VD\",G4=\"À vista\"),(G11-G14)-(G7*G9),0)","v":22},null,{"$f":"IF(AND(H8=\"VD\",I4=\"À vista\"),(I11-I14)-(I7*I9),0)","v":0},null,{"$f":"IF(AND(J8=\"VD\",K4=\"À vista\"),(K11-K14)-(K7*K9),0)","v":0},null,{"$f":"IF(AND(L8=\"VD\",M4=\"À vista\"),(M11-M14)-(M7*M9),0)","v":0},null,{"$f":"IF(AND(N8=\"VD\",O4=\"À vista\"),(O11-O14)-(O7*O9),0)","v":0},{"$f":"SUM(E20:O20)","v":22},"À Vista"]
[null,null,"Valor Retornado",null,{"$f":"E19+E20","v":0},null,{"$f":"G19+G20","v":22},null,{"$f":"I19+I20","v":0},null,{"$f":"K19+K20","v":0},null,{"$f":"M19+M20","v":0},null,{"$f":"O19+O20","v":0},{"$f":"SUM(E21:O21)","v":22},"Ganho"]
[null,null,"Valor Investido",null,{"$f":"IF(D8=\"CP\",E6+E17,IF(AND(D8=\"VD\",E17=0),0,(E6+E14)))","v":2922},null,{"$f":"IF(F8=\"CP\",G6+G17,IF(AND(F8=\"VD\",G17=0),0,(G6+G14)))","v":0},null,{"$f":"IF(H8=\"CP\",I6+I17,IF(AND(H8=\"VD\",I17=0),0,(I6+I14)))","v":660.15},null,{"$f":"IF(J8=\"CP\",K6+K17,IF(AND(J8=\"VD\",K17=0),0,(K6+K14)))","v":1830.9499999999998},null,{"$f":"IF(L8=\"CP\",M6+M17,IF(AND(L8=\"VD\",M17=0),0,(M6+M14)))","v":4522.6000000000004},null,{"$f":"IF(N8=\"CP\",O6+O17,IF(AND(N8=\"VD\",O17=0),0,(O6+O14)))","v":6703.6},{"$f":"LARGE(E22:O22,1)","v":6703.6},"Vr.Invest."]
[null,null,"Rentabilidade %",null,{"$f":"IF(E21=0,0,((E21/E6)*100))","v":0},null,{"$f":"IF(G21=0,0,((G21/G6)*100))","v":0.75290896646132788},null,{"$f":"IF(I21=0,0,((I21/I6)*100))","v":0},null,{"$f":"IF(K21=0,0,((K21/K6)*100))","v":0},null,{"$f":"IF(M21=0,0,((M21/M6)*100))","v":0},null,{"$f":"IF(O21=0,0,((O21/O6)*100))","v":0},{"$f":"IF(P22=0,0,((P21/P22)*100))","v":0.32818187242675573},"Rentab.%"]
[null,null,"I.R.Calculado-D.Trade",null,{"$f":"IF(E19<=0,0,E19* [2]Regras!$J$20)","v":0},null,{"$f":"IF(G19<=0,0,G19*[2]Regras!$J$20)","v":0},null,{"$f":"IF(I19<=0,0,I19* [2]Regras!$J$20)","v":0},null,{"$f":"IF(K19<=0,0,K19* [2]Regras!$J$20)","v":0},null,{"$f":"IF(M19<=0,0,M19* [2]Regras!$J$20)","v":0},null,{"$f":"IF(O19<=0,0,O19* [2]Regras!$J$20)","v":0},{"$f":"SUM(E24:O24)","v":0},"IR-DT"]
[null,null,"I.R.Calculado-À Vista",null,{"$f":"IF(E20<=0,0,E20* [2]Regras!$I$20)","v":0},null,{"$f":"IF(G20<=0,0,G20*[2]Regras!$I$20)","v":3.3},null,{"$f":"IF(I20<=0,0,I20* [2]Regras!$I$20)","v":0},null,{"$f":"IF(K20<=0,0,K20* [2]Regras!$I$20)","v":0},null,{"$f":"IF(M20<=0,0,M20* [2]Regras!$I$20)","v":0},null,{"$f":"IF(O20<=0,0,O20* [2]Regras!$I$20)","v":0},{"$f":"SUM(E25:O25)","v":3.3},"IR-V"]