{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["OP2021","RICO","DIAS","PAINEL"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"OP2021","index":0,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,8,0,16]]}
["OPERAÇÕES COMUNS",null,null,null,null,null,null,null,"OPERAÇÕES DAY TRADE"]
["MÊS","TOTAL","PIBB11","PMAM3","XFIX11","IR PG","RES NEG MÊS ANT",null,"MÊS","PIBB11","ÍNDICE","IR RET WIN","PREJ WIN","DÓLAR","IR RET WDO","PREJ WDO","RES NEG MÊS ANT"]
[1,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":-1456.7650000000019},{"$f":"30*204.1475-207.67*30-5.95-4.12-0.55-0.66-(30*207.95-30*202.49)","v":-280.75499999999852},{"$f":"-39194.16+38038-2.49-2.74-10.77","v":-1172.1600000000035},{"$f":"-207.35+51.5+20.6+103+10.3+20.6-2.49-0.01","v":-3.8499999999999979},{"$f":"1.91+0.3","v":2.21},41981.96,null,1,{"$f":"-5+204.1475*30-203.41*30","v":17.125},null,null,null,-6249.88,29.78,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":-6279.66},109937.13]
[2,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,2,null,null,null,null,-835.46,17.62,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":-853.08}]
[3,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,3,null,null,null,null,8365.7999999999993,95.12,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":8270.6799999999985}]
[4,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,4,null,355.5,{"$f":"2.54+1.01","v":3.55},{"$f":"Tabela135[[#This Row],[ÍNDICE]]-Tabela135[[#This Row],[IR RET WIN]]","v":351.95},127.5,1.27,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":126.23}]
[5,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":737.9900000000016},{"$f":"-37.2+(13*213.31)-(13*207.08)+(60*217.64)-(60*206.07)","v":737.9900000000016},null,null,null,null,null,5,null,-3545.9,4.9000000000000004,{"$f":"Tabela135[[#This Row],[ÍNDICE]]-Tabela135[[#This Row],[IR RET WIN]]","v":-3550.8},-11289.8,46.68,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":-11336.48}]
[6,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":2629.6049999999968},{"$f":"3110.59-C7-C3-23.75","v":2629.6049999999968},null,null,null,null,null,6,null,null,null,null,{"$f":"184.7-2744.6-743.3+691.42-8.5-12.4+342.05+197.13","v":-2093.4999999999995},1.84,{"$f":"Tabela135[[#This Row],[DÓLAR]]-Tabela135[[#This Row],[IR RET WDO]]","v":-2095.3399999999997}]
[7,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,7]
[8,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,8]
[9,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,9]
[10,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,10]
[11,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,11]
[12,{"$f":"SUM(Tabela13[[#This Row],[PIBB11]:[XFIX11]])","v":0},null,null,null,null,null,null,12]
[null,{"$f":"SUM(Tabela13[TOTAL])","v":1910.8299999999965},{"$f":"SUM(Tabela13[PIBB11])","v":3086.84},{"$f":"SUM(Tabela13[PMAM3])","v":-1172.1600000000035},{"$f":"SUM(Tabela13[XFIX11])","v":-3.8499999999999979},{"$f":"SUM(Tabela13[IR PG])","v":2.21},{"$f":"G3-SUM(Tabela13[[PIBB11]:[XFIX11]])","v":40071.130000000005},null,null,{"$f":"SUM(Tabela135[PIBB11])","v":17.125},{"$f":"SUM(Tabela135[ÍNDICE])","v":-3190.4},{"$f":"SUM(Tabela135[IR RET WIN])","v":8.4499999999999993},{"$f":"SUM(Tabela135[PREJ WIN])","v":-3198.8500000000004},{"$f":"SUM(N2:N14)","v":-11975.34},{"$f":"SUM(O3:O14)","v":192.31000000000003},{"$f":"SUM(Tabela135[PREJ WDO])","v":-12167.650000000001},{"$f":"Q3-Tabela135[[#Totals],[PREJ WDO]]-Tabela135[[#Totals],[PREJ WIN]]-Tabela135[[#Totals],[PIBB11]]","v":125286.505}]

{"sheet":"RICO","index":1,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["DATA","QUANTIDADE","UNITÁRIO","PAGO","TOTAL PAGO","CORRETORA",null,null,null,"QUANTIDADE","PAGO","PREÇO MÉDIO","FECHAMENTO","RESULTADO"]
["2021-03-17",5,{"$f":"D2/B2","v":199.05599999999998},995.28,{"$f":"Tabela5[[#This Row],[PAGO]]","v":995.28},"RICO",null,null,null,{"$f":"SUM(B:B)","v":62},{"$f":"SUM(D:D)","v":12566.970000000003},{"$f":"K2/J2","v":202.69306451612908},{"$f":"INDEX(DIAS!D:D,COUNTA(DIAS!D:D),1)","v":225.05},{"$f":"Tabela6[FECHAMENTO]*Tabela6[QUANTIDADE]-Tabela6[PAGO]","v":1386.1299999999974}]
["2021-03-18",4,{"$f":"D3/B3","v":198.01750000000001},792.07,{"$f":"Tabela5[[#This Row],[PAGO]]+E2","v":1787.35},"RICO"]
["2021-03-19",19,199.48421052631579,3790.2,{"$f":"Tabela5[[#This Row],[PAGO]]+E3","v":5577.5499999999993},"RICO",null,null,null,"MENOR","MAIOR","MÉDIA"]
["2021-03-22",2,197.28,394.56,{"$f":"Tabela5[[#This Row],[PAGO]]+E4","v":5972.11},"RICO",null,null,null,{"$f":"MIN(Tabela5[UNITÁRIO])","v":192.02},{"$f":"MAX(Tabela5[UNITÁRIO])","v":223.56},{"$f":"SUM(Tabela3[[MENOR]:[MAIOR]])/2","v":207.79000000000002}]
["2021-03-23",4,196.77,787.08,{"$f":"Tabela5[[#This Row],[PAGO]]+E5","v":6759.19},"RICO"]
["2021-03-24",1,192.02,192.02,{"$f":"Tabela5[[#This Row],[PAGO]]+E6","v":6951.21},"RICO"]
["2021-03-26",1,197.22,197.22,{"$f":"Tabela5[[#This Row],[PAGO]]+E7","v":7148.43},"RICO"]
["2021-03-30",1,199.12,199.12,{"$f":"Tabela5[[#This Row],[PAGO]]+E8","v":7347.55},"RICO"]
["2021-04-01",7,199.54857142857142,1396.84,{"$f":"Tabela5[[#This Row],[PAGO]]+E9","v":8744.39},"RICO"]
["2021-04-12",3,204.92,614.76,{"$f":"Tabela5[[#This Row],[PAGO]]+E10","v":9359.15},"RICO"]
["2021-04-30",1,206.77,206.77,{"$f":"Tabela5[[#This Row],[PAGO]]+E11","v":9565.92},"RICO"]
["2021-05-03",1,210.87,210.87,{"$f":"Tabela5[[#This Row],[PAGO]]+E12","v":9776.7900000000009},"RICO"]
["2021-05-05",1,208.2,208.2,{"$f":"Tabela5[[#This Row],[PAGO]]+E13","v":9984.9900000000016},"RICO"]
["2021-05-10",2,214.06,428.12,{"$f":"Tabela5[[#This Row],[PAGO]]+E14","v":10413.110000000002},"RICO"]
["2021-05-11",4,213.8425,855.37,{"$f":"Tabela5[[#This Row],[PAGO]]+E15","v":11268.480000000003},"RICO"]
["2021-05-19",1,213.65,213.65,{"$f":"Tabela5[[#This Row],[PAGO]]+E16","v":11482.130000000003},"RICO"]
["2021-05-25",3,212.57333333333335,637.72,{"$f":"Tabela5[[#This Row],[PAGO]]+E17","v":12119.850000000002},"RICO"]
["2021-06-07",2,223.56,{"$f":"223.56*2","v":447.12},{"$f":"E18+Tabela5[[#This Row],[PAGO]]","v":12566.970000000003},"RICO"]

{"sheet":"DIAS","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["DATA","QTD","QTD T","FECHAM","PREÇO MÉDIO","PAGO","ATUAL","RESULT","%","COTAS","VENDA"]
["2021-03-17",5,5,200.78,{"$f":"F2/C2","v":199.05599999999998},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":995.28},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":1003.9},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":8.6200000000000045},{"$f":"H2/G2","v":8.586512600856664E-3},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":885.56516834346041},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":35761.534899999999}]
["2021-03-18",4,9,197.84,198.59444444444443,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":1787.35},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":1780.56},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-6.7899999999999636},-3.8134070180167834E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":894.79940608572576},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":19867.51938888889}]
["2021-03-19",19,28,199.65,199.19821428571427,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":5577.5499999999993},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":5590.2},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":12.650000000000546},2.2628886265250877E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":867.60568244427748},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":6385.9883749999999}]
["2021-03-22",2,30,197.3,199.07033333333331,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":5972.11},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":5919},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-53.109999999999673},-8.9727994593680818E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":876.27305879371511},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":5960.2558166666668}]
["2021-03-23",4,34,194,198.79970588235292,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":6759.19},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":6596},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-163.1899999999996},-2.474075197089139E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":887.68904381443292},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":5259.04925}]
["2021-03-24",1,35,192.85,198.60599999999999,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":6951.21},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":6749.75},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-201.46000000000004},-2.9847031371532284E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":892.18524500907438},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":5108.7906999999996}]
["2021-03-25",0,35,195,198.60599999999999,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":6951.21},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":6825},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-126.21000000000004},-1.8492307692307697E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":881.96243333333325},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":5108.7906999999996}]
["2021-03-26",1,36,197.45,198.5675,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":7148.43},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":7108.2},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":-40.230000000000473},-5.6596606735883166E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":869.58457584198538},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4966.8798472222225}]
["2021-03-29",0,36,199.45,198.5675,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":7148.43},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":7180.2},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":31.769999999999527},4.424667836550448E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":860.50375783404365},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4966.8798472222225}]
["2021-03-30",1,37,200.77,198.58243243243243,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":7347.55},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":7428.4900000000007},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":80.940000000000509},1.0895888666471988E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":853.6095258255715},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4832.6398513513514}]
["2021-03-31",0,37,201,198.58243243243243,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":7347.55},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":7437},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":89.449999999999818},1.2027699341132153E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":852.59042039800988},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4832.6398513513514}]
["2021-04-01",7,44,199.07,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":8759.08},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":14.690000000000509},1.6771167748211582E-3,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":854.21507258753206},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-05",0,44,203.45,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":8951.7999999999993},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":207.40999999999985},2.3169641859737692E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":834.877731629393},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-06",0,44,203.08,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":8935.52},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":191.13000000000102},2.1389913513707205E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":836.47899596218235},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-07",0,44,203.95,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":8973.7999999999993},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":229.40999999999985},2.5564420869642723E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":832.72309144398139},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-08",0,44,204.82,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9012.08},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":267.69000000000051},{"$f":"H17/G17","v":2.9703464682958931E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":828.99909432672587},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-09",0,44,203.5,198.73613636363635,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":8744.39},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":8954},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":209.61000000000058},2.3409649318740292E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":834.6617911547911},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":4063.8107840909088}]
["2021-04-12",3,47,205.6,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9663.1999999999989},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":304.04999999999927},3.1464732179816136E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":822.68713278210112},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-13",0,47,206.15,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9689.0500000000011},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":329.90000000000146},3.404874574906739E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":820.36684210526312},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-14",0,47,208.7,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9808.9},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":449.75},4.5851216752133266E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":809.76892429324391},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-15",0,47,208.42,{"$f":"F22/C22","v":199.13085106382977},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9795.74},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":436.59000000000015},4.4569374034018887E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":810.91994290375203},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-16",0,47,210.05,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9872.35},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":513.20000000000073},5.1983570274554761E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":804.26243513449174},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-19",0,47,209.74,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9857.7800000000007},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":498.63000000000102},5.0582382645991388E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":805.5206183846667},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-20",0,47,207.91,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9771.77},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":412.6200000000008},4.222571755168212E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":813.02440719542108},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-22",0,47,206.92,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9725.24},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":366.09000000000015},3.7643286952301451E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":817.13915764546687},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-23",0,47,209.02,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9823.94},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":464.79000000000087},{"$f":"H27/G27","v":4.7311974625252273E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":808.45725050234421},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-26",0,47,209.68,{"$f":"F28/C28","v":199.13085106382977},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9854.9600000000009},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":495.81000000000131},5.0310706486885917E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":805.76456743609299},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-27",0,47,207.9,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9771.3000000000011},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":412.15000000000146},4.2179648562627431E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":813.06577441077434},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-28",0,47,210.92,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9913.24},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":554.09000000000015},5.5893935786887047E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":800.7511592072824},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-29",0,47,209.18,199.13085106382977,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9359.15},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9831.4600000000009},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":472.31000000000131},4.8040677579932307E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":807.80291853905726},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3804.4186063829784}]
["2021-04-30",1,48,206.71,199.29,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9565.92},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":9922.08},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":356.15999999999985},3.5895699288858773E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":817.0170504571621},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3725.1598854166664}]
["2021-05-03",1,49,207.39,199.52632653061227,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9776.7900000000009},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":10162.109999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":385.31999999999789},{"$f":"H33/G33","v":3.7917322288382821E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":813.18079222720485},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3649.1362142857142}]
["2021-05-04",0,49,205.38,{"$f":"F34/C34","v":199.52632653061227},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9776.7900000000009},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":10063.619999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":286.82999999999811},2.8501672360442678E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":821.61872869802312},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3649.1362142857142}]
["2021-05-05",1,50,208.44,199.69980000000004,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9984.9900000000016},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":10422},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":437.0099999999984},4.1931491076568642E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":807.83762473613513},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3576.1534899999997}]
["2021-05-06",0,50,210.41,199.69980000000004,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9984.9900000000016},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":10520.5},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":535.5099999999984},5.0901573119148176E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":799.80597167435008},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3576.1534899999997}]
["2021-05-07",0,50,213.81,199.69980000000004,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":9984.9900000000016},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":10690.5},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":705.5099999999984},6.5994106917356382E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":786.29238342453573},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3576.1534899999997}]
["2021-05-10",2,52,213.55,200.25211538461542,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":10413.110000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":11104.6},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":691.48999999999796},6.2270590566071531E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":785.31058066026685},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3438.6091249999999}]
["2021-05-11",4,56,216.06,201.22285714285721,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12099.36},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":830.87999999999738},6.8671400801364482E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":771.58342358604091},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-12",0,56,210.2,201.22285714285721,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":11771.199999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":502.71999999999571},4.2707625390783925E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":794.6549690770695},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-13",0,56,211.21,201.22285714285721,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":11827.76},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":559.27999999999702},4.7285369334514479E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":790.58716206618999},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-14",0,56,212.35,201.22285714285721,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":11891.6},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":623.11999999999716},5.2400013454875473E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":786.04226277372265},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-17",0,56,214.78,{"$f":"F43/C43","v":201.22285714285721},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12027.68},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":759.19999999999709},{"$f":"H43/G43","v":6.312106740451999E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":776.5154786292951},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-18",0,56,215.17,201.22285714285721,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11268.480000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12049.519999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":781.03999999999542},6.4819179519183798E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":775.00652739694192},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3192.9941875}]
["2021-05-19",1,57,213.9,201.4408771929825,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11482.130000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12192.300000000001},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":710.16999999999825},5.824741845262979E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":778.9405072463768},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3136.9767456140348}]
["2021-05-20",0,57,213.55,201.4408771929825,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11482.130000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12172.35},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":690.21999999999753},5.6703923235858114E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":780.31058066026685},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3136.9767456140348}]
["2021-05-21",0,57,213.02,201.4408771929825,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11482.130000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12142.140000000001},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":660.0099999999984},5.4356974964874259E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":782.39383391230865},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3136.9767456140348}]
["2021-05-24",0,57,215.02,201.4408771929825,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":11482.130000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12256.140000000001},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":774.0099999999984},6.3152836047890959E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":774.58624546553801},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":3136.9767456140348}]
["2021-05-25",3,60,212.51,{"$f":"F49/C49","v":201.99750000000003},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12750.599999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":630.74999999999636},{"$f":"H49/G49","v":4.9468260317161263E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":781.40828431603222},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-05-26",0,60,215,{"$f":"F50/C50","v":201.99750000000003},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12900},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":780.14999999999782},6.0476744186046344E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":771.66360232558134},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-05-27",0,60,215.5,{"$f":"F51/C51","v":201.99750000000003},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":12930},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":810.14999999999782},6.2656612529002148E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":769.7339883990719},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-05-28",0,60,217.71,{"$f":"F52/C52","v":201.99750000000003},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13062.6},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":942.74999999999818},7.2171696293233972E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":761.3112603922649},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-05-31",0,60,219.03,201.99750000000003,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13141.8},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1021.9499999999971},7.7763320093137703E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":756.36156919143491},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-06-01",0,60,222.58,{"$f":"F54/C54","v":201.99750000000003},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13354.800000000001},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1234.9499999999989},9.2472369485128852E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":743.34115598885785},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-06-02",0,60,225.17,201.99750000000003,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13510.199999999999},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1390.3499999999967},{"$f":"H55/G55","v":0.10291113381000998},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":734.1007882932895},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-06-04",0,60,225.3,201.99750000000003,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12119.850000000002},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13518},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1398.1499999999978},0.10342876165113166,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":733.64258544163329},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2980.1279083333334}]
["2021-06-07",2,62,225.95,202.69306451612908,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":14008.9},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1441.9299999999967},0.10292956620434129,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":729.35947997344545},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-08",0,62,224.21,202.69306451612908,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13901.02},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1334.0499999999975},9.5967777904067283E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":735.50088979082102},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-09",0,62,224.95,202.69306451612908,{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13946.9},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1379.9299999999967},9.8941700306160993E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":732.87741498110688},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-10",0,62,224.36,{"$f":"F60/C60","v":202.69306451612908},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13910.320000000002},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1343.3499999999985},9.6572185255263607E-2,{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":734.96770591905863},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-11",0,62,225.23,{"$f":"F61/C61","v":202.69306451612908},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13964.26},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1397.2899999999972},{"$f":"H61/G61","v":0.10006187223669548},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":731.88924432802025},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-14",0,62,227,{"$f":"F62/C62","v":202.69306451612908},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":14074},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1507.029999999997},{"$f":"H62/G62","v":0.10707901094216264},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":725.6990066079295},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-15",0,62,225.05,{"$f":"F63/C63","v":202.69306451612908},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":12566.970000000003},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":13953.1},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":1386.1299999999974},{"$f":"H63/G63","v":9.934208168794012E-2},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":732.52421461897347},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":2883.9947499999998}]
["2021-06-15",0,62,225.05,{"$f":"F64/C64","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":{"$error":"#VALUE!"}},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":{"$error":"#VALUE!"}},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":{"$error":"#VALUE!"}},{"$f":"H64/G64","v":{"$error":"#VALUE!"}},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":{"$error":"#VALUE!"}},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":{"$error":"#VALUE!"}}]
["2021-06-15",0,62,225.05,{"$f":"F65/C65","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Tabela5[#All],MATCH(Tabela1[[#This Row],[DATA]],RICO!A:A,1),5)","v":{"$error":"#VALUE!"}},{"$f":"Tabela1[[#This Row],[QTD T]]*Tabela1[[#This Row],[FECHAM]]","v":{"$error":"#VALUE!"}},{"$f":"Tabela1[ATUAL]-Tabela1[PAGO]","v":{"$error":"#VALUE!"}},{"$f":"H65/G65","v":{"$error":"#VALUE!"}},{"$f":"(TOTAL/Tabela1[[#This Row],[FECHAM]])-Tabela1[[#This Row],[QTD T]]","v":{"$error":"#VALUE!"}},{"$f":"TOTAL/Tabela1[[#This Row],[QTD T]]","v":{"$error":"#VALUE!"}}]

{"sheet":"PAINEL","index":3,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["PIBB11"]
[]
["NO DIA",{"$f":"((FECHAMENTO/FECHAMENTOANTERIOR)-1)*100","v":0},"%",null,"MAIOR","MENOR","MAIOR","ACIMA","ABAIXO",null,{"$f":"I15+B6","v":178807.67449999999}]
["DATA",{"$f":"TODAY()","v":"2021-06-15"},null,null,"FECHAMENTO","FECHAMENTO","PREJUÍZO","P. MÉDIO","P. MÉDIO",null,{"$f":"ATUAL","v":13953.1}]
["PAGO",{"$f":"Tabela6[PAGO]","v":12566.970000000003},null,null,{"$f":"LARGE(Tabela1[FECHAM],1)","v":227},{"$f":"SMALL(Tabela1[FECHAM],1)","v":192.85},{"$f":"SMALL(Tabela1[%],1)","v":-2.9847031371532284E-2},{"$f":"COUNTIF(Tabela1[FECHAM],\">=\" & PRECOMEDIO)","v":50},{"$f":"COUNTIF(Tabela1[FECHAM],\"<\" & PRECOMEDIO)","v":12}]
["ATUAL",{"$f":"FECHAMENTO*QUANTIDADE","v":13953.1}]
["FECHAMENTO",{"$f":"INDEX(DIAS!D:D,COUNTA(DIAS!D:D),1)","v":225.05},null,null,"MAIOR","MAIOR","FALTAM","MAIOR","MENOR"]
["DATA ANTERIOR",{"$f":"INDEX(Tabela1[[#All],[DATA]],MATCH(B4,Tabela1[[#All],[DATA]],1)-1,1)","v":"2021-06-14"},null,null,"LUCRO","LUCRO",{"$f":"TOTALCOTAS-QUANTIDADE","v":732.52421461897347},"P. MÉDIO","P. MÉDIO"]
["FECHAMENTO ANTERIOR",{"$f":"INDEX(DIAS!D:D,COUNTA(DIAS!D:D)-1,1)","v":225.05},null,null,{"$f":"LARGE(Tabela1[%],1)","v":0.10707901094216264},{"$f":"LARGE(Tabela1[RESULT],1)","v":1507.029999999997},"COTAS",{"$f":"LARGE(Tabela1[PREÇO MÉDIO],1)","v":202.69306451612908},{"$f":"SMALL(Tabela1[PREÇO MÉDIO],1)","v":198.5675}]
["RENDIMENTO",{"$f":"INDEX(DIAS!I:I,COUNT(DIAS!I:I)+1,1)*100","v":9.9342081687940116},"%"]
["PREÇO MÉDIO",{"$f":"Tabela6[PREÇO MÉDIO]","v":202.69306451612908},null,null,"META","DIAS","JUROS","JUROS/DIA","DIFERENÇA"]
["QUANTIDADE",{"$f":"SUM(DIAS!B:B)","v":62},null,null,{"$f":"JUROS+PAGO+LÍQUIDO+IR","v":178807.67449999999},{"$f":"_xlfn.DAYS(TODAY(),\"17/3/21\")","v":90},{"$f":"MESES*FECHAMENTO","v":675.15000000000009},{"$f":"G12/F12","v":7.5016666666666678},{"$f":"H15-B7","v":2658.9447499999997}]
["RESULTADO",{"$f":"Tabela6[RESULTADO]","v":1386.1299999999974}]
["RESULTADO POR COTA",{"$f":"B13/B12","v":22.356935483870924},null,null,"PREVISÃO","COTAS/PREGÃO","LÍQUIDO","VENDA","FALTAM"]
["IMPOSTO DE RENDA",{"$f":"RESULTADO*15/100","v":207.9194999999996},null,null,{"$f":"2021+(FALTAMCOTAS/11/12)","v":2026.5494258683257},{"$f":"QUANTIDADE/(H5+I5)","v":1},{"$f":"COMUM+DAYTRADE","v":165357.63500000001},{"$f":"TOTAL/QUANTIDADE","v":2883.9947499999998},{"$f":"TOTAL-ATUAL","v":164854.57449999999}]
["IR ANOS ANTERIORES",{"$f":"COMUM*15/100","v":6010.6695000000009}]
["IR A PAGAR",{"$f":"IR-IRANTERIOR","v":-5802.7500000000009},null,null,"MESES","COTAS","ALVO","C","D"]
["COMPRAR",10,null,null,{"$f":"DIAS/30","v":3},{"$f":"TOTAL/FECHAMENTO","v":794.52421461897347},{"$f":"(VENDA/FECHAMENTO)","v":12.814906687402798},{"$f":"Tabela13[[#Totals],[RES NEG MÊS ANT]]","v":40071.130000000005},{"$f":"Tabela135[[#Totals],[RES NEG MÊS ANT]]","v":125286.505}]
["VAI LEVAR PM PARA",{"$f":"((B18*FECHAMENTO)+PAGO)/(QUANTIDADE+B18)","v":205.79819444444448}]
["VALOR MÉDIO POR PREGÃO",{"$f":"PAGO/(H5+I5)","v":202.69306451612908},null,null,"ATINGIDO","FALTAM","PREGÕES","VARIAÇÃO","VAR %"]
["MÉDIA MÓVEL",{"$f":"MM(\"DIAS\",4,2, 54)","v":213.14185185185184},null,null,{"$f":"RESULTADO*100/(TOTAL-PAGO)/100","v":8.3380902659733226E-3},{"$f":"100%-E21","v":0.99166190973402668},{"$f":"SUM(H5:I5)","v":62}]