{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["modSpline","BMF","LTN_CASADA","EX_LTN","DIV 01","FERIADOS"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"modSpline","index":0,"reason":"part_missing"}],"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":"BMF","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["TAXA DE JUROS",null,null,null,null,null,null,null,null,null,null,"2020-02-05"]
["BMF Bovespa - Taxa de Juros"]
["DI1 - Depósito Interfinanceiro de um dia"]
["Dvc","DU","Ultima","Var","Neg","Cng","Cab","Mín","Máx","Abe","Ajut","Ajat"]
["2020-03-02",16,4.2,-0.23752999999999999,72,627035,1595378,4.1849999999999996,4.2030000000000003,4.1849999999999996,4.1970000000000001,4.1980000000000004]
["2020-04-01",38,4.18,-0.11947000000000001,1627,634495,5521510,4.1660000000000004,4.1849999999999996,4.173,4.17,4.1740000000000004]
["2020-05-04",58,4.1500000000000004,-0.24038999999999999,37,26295,218825,4.1470000000000002,4.1500000000000004,4.1500000000000004,4.1500000000000004,4.1509999999999998]
["2020-06-01",78,4.16,-0.12005,3,270,125280,4.16,4.18,4.16,4.1429999999999998,4.1470000000000002]
["2020-07-01",99,4.1550000000000002,0,1413,364175,5266707,4.13,4.16,4.1449999999999996,4.1399999999999997,4.1420000000000003]
["2020-08-03",122,4.1550000000000002,0.24126,1,200,72720,4.1550000000000002,4.1550000000000002,4.1550000000000002,4.1429999999999998,4.1479999999999997]
["2020-09-01",143,4.1500000000000004,0.12063,6,550,37370,4.1500000000000004,4.1500000000000004,4.1500000000000004,4.1449999999999996,4.1429999999999998]
["2020-10-01",164,4.21,0.11891,458,66570,695068,4.1849999999999996,4.21,4.1950000000000003,4.1849999999999996,4.194]
["2020-11-03",185,4.22,-0.23641000000000001,6,685,37945,4.21,4.22,4.21,4.21,4.2190000000000003]
["2020-12-01",205,4.25,0.33050000000000002,35,5075,37095,4.24,4.25,4.24,4.2279999999999998,4.2350000000000003]
["2021-01-04",227,4.32,0.34843000000000002,2752,430415,4303082,4.2750000000000004,4.3250000000000002,4.2850000000000001,4.29,4.2949999999999999]
["2021-04-01",288,4.45,0.45146999999999998,165,12590,549347,4.4000000000000004,4.45,4.41,4.42,4.42]
["2021-07-01",350,4.6100000000000003,0.21739,943,36205,902722,4.55,4.6100000000000003,4.58,4.57,4.5810000000000004]
["2021-10-01",415,4.7699999999999996,-0.41754000000000002,62,2145,449222,4.7300000000000004,4.7699999999999996,4.74,4.7300000000000004,4.7510000000000003]
["2022-01-03",478,4.92,0,3269,272275,1392762,4.87,4.92,4.9000000000000004,4.8899999999999997,4.9109999999999996]
["2022-04-01",540,5.07,0,99,5650,146310,5.04,5.07,5.04,5.05,5.0709999999999997]
["2022-07-01",602,5.2,-0.19194,630,22565,405582,5.16,5.21,5.2,5.18,5.2009999999999996]
["2022-10-03",667,5.32,-0.56074999999999997,3,130,49715,5.3,5.32,5.3,5.3250000000000002,5.351]
["2023-01-02",729,5.44,-0.18348999999999999,10663,318205,1683036,5.4,5.46,5.45,5.42,5.4509999999999996]
["2023-04-03",792,5.53,-0.71813000000000005,18,315,21250,5.51,5.55,5.53,5.5250000000000004,5.5709999999999997]
["2023-07-03",853,5.66,-0.35210999999999998,499,25755,790821,5.62,5.69,5.68,5.64,5.6820000000000004]
["2023-10-02",917,5.74,-0.69203999999999999,13,95,17645,5.72,5.75,5.75,5.74,5.782]
["2024-01-02",978,5.83,-0.51195000000000002,1112,46785,406407,5.8,5.86,5.85,5.82,5.8620000000000001]

{"sheet":"LTN_CASADA","index":2,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[41,11,41,13],[42,7,42,10],[41,0,41,1],[41,2,41,10],[42,0,43,0],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6]]}
["I","Calculo FLUXO E PU LTN",null,{"$f":"K40","v":"05/Fev/2020"},null,null,null,null,"II"]
[null,null,"ESPECULAÇÃO",null,null,null,null,null,null,null,"ESPECULAÇÃO"]
[null,null,"no resgate",null,"VN",null,null,"CDI médio",null,null,"no secundário",null,"VN",null,null,"CDI médio"]
[null,null,null,null,1000,null,null,5.4,"%a.a.",null,null,null,{"$f":"E4","v":1000},null,null,6,"%a.a."]
[null,"BM&F",{"$f":"VLOOKUP(E10,L45:O55,3,FALSE)","v":5.66},null,null,null,null,null,null,"BM&F",5.8]
[null,"Prêmio",{"$f":"VLOOKUP(E10,L45:O55,4,FALSE)","v":1.3799999999999812},null,null,null,"Res. Resgate",null,null,"Prêmio",{"$f":"C6","v":1.3799999999999812},null,null,null,"Vd LTN"]
[null,"Taxa",{"$f":"C5+C6/100","v":5.6738},"%a.a.",null,null,"LTN",{"$f":"C14*E4","v":1000000},null,"Taxa",{"$f":"K5+K6/100","v":5.8137999999999996},"%a.a.",null,null,"LTN",{"$f":"K16","v":988850.17300000007}]
[null,null,null,null,null,null,"Fin",{"$f":"(1+H4/100)^(E10/252)*C16","v":991256.76194486278},null,null,null,null,null,null,"Fin",{"$f":"(1+P4/100)^((E10-M10)/252)*C16","v":998872.02076447383}]
[null,null,null,null,"Prazo",null,null,null,null,null,null,null,"Prazo"]
[null,null,null,null,853,"du","Res. LTN.",{"$f":"H7-H8","v":8743.2380551372189},null,null,null,null,50,"du","Res. LTN.",{"$f":"P7-P8","v":-10021.847764473758}]
[]
[null,"PU =",{"$f":"ROUND(E4/(1+C7/100)^(E10/252),6)","v":829.60719099999994},null,null,null,null,"Over Suportável",null,"PU =",{"$f":"ROUND(M4/(1+K7/100)^(M10/252),6)","v":988.85017300000004},null,null,null,null,"Over Suportável"]
[null,null,null,null,null,null,null,5.6737999884724255,"%a.a.",null,null,null,null,null,null,5.6650888081359803,"%a.a."]
[null,"Estoque",1000,null,null,null,null,{"$f":"H7-(1+H13/100)^(E10/252)*C16","v":-3.5739503800868988E-8},null,"Estoque",{"$f":"C14","v":1000},null,null,null,"Atingir Meta = 0",{"$f":"P7-(1+P13/100)^((E10-M10)/252)*C16","v":0}]
[]
[null,"Fin",{"$f":"C12*C14","v":829607.19099999999},null,null,null,null,null,null,"Fin",{"$f":"K12*K14","v":988850.17300000007}]
[]
[]
["III","BM&F",null,null,null,null,null,null,"IIII"]
[null,null,"ARBITRAGEM",null,null,null,null,null,null,null,"Hedge"]
[null,null,"no resgate",null,"VN",null,null,"CDI médio",null,null,"secundário",null,"VN",null,null,"CDI médio"]
[null,null,null,null,100000,null,null,{"$f":"H4","v":5.4},"%a.a.",null,null,null,100000,null,null,{"$f":"P4","v":6},"%a.a."]
[]
[null,null,null,null,null,null,"Res. Resgate",null,null,null,null,null,null,null,"Liq. Futuro"]
[null,"Taxa",{"$f":"C5","v":5.66},"%a.a.",null,null,"Pre",{"$f":"E22*C34","v":999558.0476014911},null,"BM&F",{"$f":"K5","v":5.8},"%a.a.",null,null,"Pre",{"$f":"K32","v":988438.76396836271}]
[null,null,null,null,null,null,"Pós",{"$f":"(1+H22/100)^(E28/252)*C32","v":991256.76194486278},null,null,null,null,null,null,"Pós",{"$f":"(1+P22/100)^((E28-M28)/252)*C32","v":998872.02076447383}]
[null,null,null,null,"Prazo",null,null,null,null,null,null,null,"Prazo"]
[null,null,null,null,{"$f":"E10","v":853},"du","Res. BM&F",{"$f":"-(H25-H26)","v":-8301.2856566283153},null,null,null,null,{"$f":"M10","v":50},"du","Res. BM&F",{"$f":"-(P25-P26)","v":10433.25679611112}]
[]
[null,"PU =",{"$f":"ROUND(E22/(1+C25/100)^(E28/252),2)","v":82997.399999999994},null,null,null,null,null,null,"PU =",{"$f":"ROUND(M22/(1+K25/100)^(M28/252),2)","v":98887.58}]
[]
[null,"Fin.",{"$f":"C16","v":829607.19099999999},null,null,null,"Arb.",{"$f":"H10+H28","v":441.95239850890357},null,"Fin.",{"$f":"K30*K34","v":988438.76396836271},null,null,null,"Hedge.",{"$f":"P10+P28","v":411.4090316373622}]
[]
[null,"Qde. Cts.",{"$f":"C32/C30","v":9.9955804760149114},null,null,null,null,null,null,"Qde. Cts.",{"$f":"C34","v":9.9955804760149114},null,null,null,"BreakEven ~",{"$f":"C6*E10/M10","v":23.54279999999968}]
[]
[]
[]
[]
[]
["Títulos Públicos Federais",null,null,null,null,null,null,null,null,null,"05/Fev/2020"]
[]
["Papel PREFIXADO",null,"LTN - Taxa (% a.a.)/252",null,null,null,null,null,null,null,null,"BM&F"]
["Código SELIC","Data Base/Emissão","Data de Vencimento","Tx. Compra","Tx. Venda","Tx. Indicativas","PU","Intervalo Indicativo"]
[null,null,null,null,null,null,null,"Mínimo (D0)","Máximo (D0)","Mínimo (D+1)","Máximo (D+1)","DU","DC","BMF","Spread","ltn"]
[100000,"2018-01-05","2020-04-01",4.1806000000000001,4.1684999999999999,4.1749999999999998,993.85122000000001,4.0909000000000004,4.282,4.0772000000000004,4.2683,{"$f":"NETWORKDAYS($K$40,C45,Feriado)-1","v":38},{"$f":"C45-$K$40","v":56},{"$f":"VLOOKUP(L45,BMF!$B$4:$N$27,2,FALSE)","v":4.18},{"$f":"(F45-N45)*100","v":-0.49999999999998934},{"$f":"D45","v":4.1806000000000001}]
[100000,"2016-07-08","2020-07-01",4.1544999999999996,4.1432000000000002,4.1494,984.15479000000005,4.0392999999999999,4.2862999999999998,4.0308000000000002,4.2759,99,{"$f":"C46-$K$40","v":147},{"$f":"VLOOKUP(L46,BMF!$B$4:$N$27,2,FALSE)","v":4.1550000000000002},-0.56000000000002714,{"$f":"D46","v":4.1544999999999996}]
[100000,"2018-07-06","2020-10-01",4.1974999999999998,4.1875,4.1931000000000003,973.62231299999996,4.0285000000000002,4.4168000000000003,4.0175999999999998,4.4039000000000001,164,239,{"$f":"VLOOKUP(L47,BMF!$B$4:$N$27,2,FALSE)","v":4.21},-1.6899999999999693,4.1974999999999998]
[100000,"2019-01-04","2021-04-01",4.4367000000000001,4.4245999999999999,4.4318999999999997,951.64805899999999,4.1741999999999999,4.7319000000000004,4.1740000000000004,4.7306999999999997,288,421,{"$f":"VLOOKUP(L48,BMF!$B$4:$N$27,2,FALSE)","v":4.45},-1.8100000000000449,4.4367000000000001]
[100000,"2017-07-07","2021-07-01",4.5880999999999998,4.5770999999999997,4.5833000000000004,939.65617099999997,4.3057999999999996,4.9173,4.2946999999999997,4.9054000000000002,350,512,{"$f":"VLOOKUP(L49,BMF!$B$4:$N$27,2,FALSE)","v":4.6100000000000003},-2.6699999999999946,4.5880999999999998]
[100000,"2019-07-05","2021-10-01",4.7565,4.7455999999999996,4.75,926.42406700000004,4.4565000000000001,5.1083999999999996,4.4368999999999996,5.0881999999999996,415,604,{"$f":"VLOOKUP(L50,BMF!$B$4:$N$27,2,FALSE)","v":4.7699999999999996},-1.9999999999999574,4.7565]
[100000,"2018-01-05","2022-01-01",4.9145000000000003,4.9042000000000003,4.9088000000000003,913.11068,4.5987999999999998,5.2784000000000004,4.5777999999999999,5.2571000000000003,{"$f":"NETWORKDAYS($K$40,C51,Feriado)","v":478},696,{"$f":"VLOOKUP(L51,BMF!$B$4:$N$27,2,FALSE)","v":4.92},-1.1199999999999655,4.9145000000000003]
[100000,"2020-01-03","2022-04-01",5.0763999999999996,5.0671999999999997,5.0709,899.42752399999995,4.7458,5.4447999999999999,4.7268999999999997,5.4257,540,786,{"$f":"VLOOKUP(L52,BMF!$B$4:$N$27,2,FALSE)","v":5.07},8.9999999999967883E-2,5.0763999999999996]
[100000,"2018-06-21","2022-07-01",5.2111999999999998,5.1993999999999998,5.2050000000000001,885.84458500000005,4.8723000000000001,5.5801999999999996,4.8516000000000004,5.5594000000000001,602,877,{"$f":"VLOOKUP(L53,BMF!$B$4:$N$27,2,FALSE)","v":5.2},0.49999999999998934,5.2111999999999998]
[100000,"2019-04-05","2023-07-01",5.6797000000000004,5.6687000000000003,5.6738,829.60718999999995,5.3459000000000003,6.0472999999999999,5.3053999999999997,6.0069999999999997,{"$f":"NETWORKDAYS($K$40,C54,Feriado)","v":853},1242,{"$f":"VLOOKUP(L54,BMF!$B$4:$N$27,2,FALSE)","v":5.66},1.3799999999999812,5.6797000000000004]
[100000,"2020-01-03","2024-01-01",5.8639999999999999,5.8540999999999999,5.8590999999999998,801.73536899999999,5.5313999999999997,6.2449000000000003,5.4913999999999996,6.2047999999999996,{"$f":"NETWORKDAYS($K$40,C55,Feriado)","v":978},1426,{"$f":"VLOOKUP(L55,BMF!$B$4:$N$27,2,FALSE)","v":5.83},2.9099999999999682,5.8639999999999999]

{"sheet":"EX_LTN","index":3,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,5,1,8],[24,1,24,4],[24,5,24,8],[48,1,48,4],[48,5,48,8]]}
[{"$f":"BMF!L1","v":"2020-02-05"}]
[null,"Carteira Ativa A",null,null,null,"Carteira Passiva B"]
["DU","Taxa","QTDE","VF","VPL","VF","PU","Fin","Qtde","Taxa","Qtde teórica"]
[null,null,null,null,{"$f":"SUM(E5:E16)","v":929734.66036136611},null,null,{"$f":"SUM(H5:H16)","v":-929734.66036136646}]
[{"$f":"LTN_CASADA!L45","v":38},{"$f":"LTN_CASADA!F45","v":4.1749999999999998},100,1000,{"$f":"D5/((1+$B5/100)^($A5/252))*C5","v":99385.122099476182},{"$f":"-D5*100","v":-100000},{"$f":"F5/((1+$J5/100)^($A5/252))","v":-99384.316506786592},{"$f":"-G5*I5","v":-99385.122099476197},{"$f":"E5/G5*K5","v":-1.0000081058331729},{"$f":"VLOOKUP(A5,LTN_CASADA!L45:P55,5,FALSE)","v":4.1806000000000001},{"$f":"K20","v":1.0000000000000002}]
[{"$f":"LTN_CASADA!L46","v":99},{"$f":"LTN_CASADA!F46","v":4.1494},100,1000,{"$f":"D6/((1+$B6/100)^($A6/252))*C6","v":98415.479064514686},{"$f":"-D6*100","v":-100000},{"$f":"F6/((1+$J6/100)^($A6/252))","v":-98413.585863807122},{"$f":"-G6*I6","v":-98415.479064514715},-1.0000192371885546,{"$f":"VLOOKUP(A6,LTN_CASADA!L46:P56,5,FALSE)","v":4.1544999999999996},{"$f":"K20","v":1.0000000000000002}]
[{"$f":"LTN_CASADA!L47","v":164},{"$f":"LTN_CASADA!F47","v":4.1931000000000003},100,1000,97362.231323565808,-100000,-97359.555654453812,-97362.231323565822,-1.0000274823472028,{"$f":"VLOOKUP(A7,LTN_CASADA!L47:P57,5,FALSE)","v":4.1974999999999998},{"$f":"K6","v":1.0000000000000002}]
[{"$f":"LTN_CASADA!L48","v":288},{"$f":"LTN_CASADA!F48","v":4.4318999999999997},100,1000,95164.805934171163,-100000,-95159.807258211949,-95164.805934171178,-1.0000525292778879,{"$f":"VLOOKUP(A8,LTN_CASADA!L48:P58,5,FALSE)","v":4.4367000000000001},{"$f":"K7","v":1.0000000000000002}]
[{"$f":"LTN_CASADA!L49","v":350},{"$f":"LTN_CASADA!F49","v":4.5833000000000004},100,1000,93965.617122464842,-100000,-93959.627608770941,-93965.617122464857,-1.0000637456091126,{"$f":"VLOOKUP(A9,LTN_CASADA!L49:P59,5,FALSE)","v":4.5880999999999998},1.0000000000000002]
[{"$f":"LTN_CASADA!L50","v":415},{"$f":"LTN_CASADA!F50","v":4.75},100,1000,92642.406710860902,-100000,-92632.940393803801,-92642.406710860931,{"$f":"E10/G10*K10","v":-1.0001021916935475},{"$f":"VLOOKUP(A10,LTN_CASADA!L50:P60,5,FALSE)","v":4.7565},1.0000000000000002]
[{"$f":"LTN_CASADA!L51","v":478},{"$f":"LTN_CASADA!F51","v":4.9088000000000003},100,1000,91311.068068927576,-100000,-91301.658287438055,-91311.068068927591,-1.0001030625474503,{"$f":"VLOOKUP(A11,LTN_CASADA!L51:P61,5,FALSE)","v":4.9145000000000003},1.0000000000000002]
[{"$f":"LTN_CASADA!L52","v":540},{"$f":"LTN_CASADA!F52","v":5.0709},100,1000,89942.752419513359,-100000,-89932.66444660828,-89942.752419513388,-1.0001121725122588,{"$f":"VLOOKUP(A12,LTN_CASADA!L52:P62,5,FALSE)","v":5.0763999999999996},1.0000000000000002]
[{"$f":"LTN_CASADA!L53","v":602},{"$f":"LTN_CASADA!F53","v":5.2050000000000001},100,1000,88584.458548507784,-100000,-88571.988577950062,-88584.458548507799,-1.0001407891000071,{"$f":"VLOOKUP(A13,LTN_CASADA!L53:P63,5,FALSE)","v":5.2111999999999998},1.0000000000000002]
[{"$f":"LTN_CASADA!L54","v":853},{"$f":"LTN_CASADA!F54","v":5.6738},100,1000,82960.719069363884,-100000,-82945.042445976636,-82960.719069363913,-1.000189000124962,{"$f":"VLOOKUP(A14,LTN_CASADA!L54:P64,5,FALSE)","v":5.6797000000000004},1.0000000000000002]
[]
[]
["Duration",null,null,null,{"$f":"SUMPRODUCT(A5:A16,E5:E16)/E4","v":370.57703755293244},null,{"$f":"SUMPRODUCT($A$5:$A$16,H5:H16)/H4","v":370.57703755293232}]
["Modify Duration",null,"tx 0 equiv.",{"$f":"'DIV 01'!B7","v":4.9863002724634668E-2},{"$f":"-E17/(1+D18/100)","v":-370.39234880595552},null,{"$f":"-G17/(1+D18/100)","v":-370.39234880595541}]
[]
["Valor de B para imunizar A",null,null,"Ft. Ajuste:MDUR",{"$f":"E17/G17","v":1.0000000000000002},{"$f":"H4*E20","v":-929734.6603613667},null,null,null,{"$f":"H4+E4","v":0},1.0000000000000002]
[null,null,null,null,null,null,null,null,null,"Atingir meta = 0"]
["Deslocamento paralelo = Variações iguais para todos os vértices"]
["du"]
[0,"Incremento",0.01]
[null,"Carteira Ativa A",null,null,null,"Carteira Passiva B"]
["DU","Taxa","QTDE","VF","VPL","VF","VPL","Qtde","Taxa"]
[null,null,null,null,{"$f":"SUM(E28:E39)","v":929604.44746242545},null,{"$f":"SUM(G28:G39)","v":-929604.45445740258}]
[{"$f":"A5-$A$24","v":38},{"$f":"B5+$C$24","v":4.1849999999999996},{"$f":"C5","v":100},1000,{"$f":"D28/((1+$B28/100)^($A28/252))*C28","v":99383.68357606027},{"$f":"F5","v":-100000},{"$f":"-F28/((1+$I28/100)^($A28/252))*H28","v":-99383.683653380693},{"$f":"I5*$E$20","v":-1.0000081058331731},{"$f":"J5+$C$24","v":4.1905999999999999}]
[{"$f":"A6-$A$24","v":99},4.1593999999999998,100,1000,{"$f":"D29/((1+$B29/100)^($A29/252))*C29","v":98411.7670278851},{"$f":"F6","v":-100000},{"$f":"-F29/((1+$I29/100)^($A29/252))*H29","v":-98411.767209635553},-1.0000192371885548,4.1644999999999994]
[164,4.2031000000000001,100,1000,97356.150527147387,{"$f":"F7","v":-100000},-97356.150783903911,-1.0000274823472031,4.2074999999999996]
[288,4.4418999999999995,100,1000,95154.392581448352,-100000,-95154.393060005867,-1.0000525292778881,4.4466999999999999]
[350,4.5933000000000002,100,1000,93953.139709924741,-100000,-93953.140282501787,-1.0000637456091128,4.5980999999999996]
[415,4.76,100,1000,92627.843790074097,-100000,-92627.844693569656,-1.0001021916935477,4.7664999999999997]
[478,4.9188000000000001,100,1000,91294.560660298055,-100000,-91294.561557021036,-1.0001030625474505,4.9245000000000001]
[540,5.0808999999999997,100,1000,89924.411884873582,-100000,-89924.412844726277,-1.000112172512259,5.0863999999999994]
[602,5.2149999999999999,100,1000,88564.346923587495,-100000,-88564.348108556369,-1.0001407891000074,5.2211999999999996]
[853,5.6837999999999997,100,1000,82934.150781126184,-100000,-82934.152264101547,-1.0001890001249623,5.6897000000000002]
[]
[]
["Duration",null,null,null,{"$f":"SUMPRODUCT(A28:A39,E28:E39)/E27","v":370.55644855291274},null,{"$f":"SUMPRODUCT($A$5:$A$16,G28:G39)/G27","v":370.55644974639466}]
["Modify Duration",null,"tx 0 equiv.",{"$f":"Cubic_Spline(A28:A37,B28:B37,E40)/100","v":4.6458938924567261E-2},{"$f":"-E40/(1+D41/100)","v":-370.3843719037838},null,{"$f":"-G40/(1+D41/100)","v":-370.38437309671156}]
[]
["Variação ocorrida em A",null,null,null,{"$f":"E27-E4","v":-130.21289894066285},null,"Imunização"]
["Variação ocorrida em B",null,null,null,{"$f":"G27-F20","v":130.20590396411717},null,{"$f":"E43+E44","v":-6.9949765456840396E-3}]
[]
[]
["Deslocamentos diferentes nos vértices:"]
[]
[null,"Carteira Ativa A",null,null,null,"Carteira Passiva B",null,null,null,null,"INCREMENTO"]
["DU","Taxa","QTDE","VF","VPL","VF","VPL","Qtde","Taxa"]
[null,null,null,null,{"$f":"SUM(E52:E63)","v":929604.44746242545},null,{"$f":"SUM(G52:G63)","v":-929604.45445740258}]
[{"$f":"A28","v":38},{"$f":"B5+K52","v":4.1849999999999996},{"$f":"C28","v":100},{"$f":"D28","v":1000},{"$f":"D52/((1+$B52/100)^($A52/252))*C52","v":99383.68357606027},{"$f":"F28","v":-100000},{"$f":"-F52/((1+$I52/100)^($A52/252))*H52","v":-99383.683653380693},{"$f":"H28","v":-1.0000081058331731},{"$f":"J5+K52","v":4.1905999999999999},null,0.01]
[{"$f":"A29","v":99},{"$f":"B6+K53","v":4.1593999999999998},{"$f":"C29","v":100},{"$f":"D29","v":1000},{"$f":"D53/((1+$B53/100)^($A53/252))*C53","v":98411.7670278851},{"$f":"F29","v":-100000},{"$f":"-F53/((1+$I53/100)^($A53/252))*H53","v":-98411.767209635553},{"$f":"H29","v":-1.0000192371885548},4.1644999999999994,null,0.01]
[164,4.2031000000000001,100,1000,97356.150527147387,{"$f":"F30","v":-100000},-97356.150783903911,{"$f":"H30","v":-1.0000274823472031},4.2074999999999996,null,0.01]
[288,4.4418999999999995,100,1000,95154.392581448352,-100000,-95154.393060005867,-1.0000525292778881,4.4466999999999999,null,0.01]
[350,4.5933000000000002,100,1000,93953.139709924741,-100000,-93953.140282501787,-1.0000637456091128,4.5980999999999996,null,0.01]
[415,4.76,100,1000,92627.843790074097,-100000,-92627.844693569656,-1.0001021916935477,4.7664999999999997,null,0.01]
[478,4.9188000000000001,100,1000,91294.560660298055,-100000,-91294.561557021036,-1.0001030625474505,4.9245000000000001,null,0.01]
[540,5.0808999999999997,100,1000,89924.411884873582,-100000,-89924.412844726277,-1.000112172512259,5.0863999999999994,null,0.01]
[602,5.2149999999999999,100,1000,88564.346923587495,-100000,-88564.348108556369,-1.0001407891000074,5.2211999999999996,null,0.01]
[853,5.6837999999999997,100,1000,82934.150781126184,-100000,-82934.152264101547,-1.0001890001249623,5.6897000000000002,null,0.01]
[null,null,null,null,null,null,null,null,null,null,0.01]
[]
["Duration",null,null,null,{"$f":"SUMPRODUCT(A52:A63,E52:E63)/E51","v":370.55644855291274},null,{"$f":"SUMPRODUCT($A$5:$A$16,G52:G63)/G51","v":370.55644974639466}]
["Modify Duration",null,"tx média",{"$f":"D41","v":4.6458938924567261E-2},{"$f":"-E64/(1+D65/100)","v":-370.3843719037838},null,{"$f":"-G64/(1+D65/100)","v":-370.38437309671156}]
[]
["Variação ocorrida em A",null,null,null,{"$f":"E51-E4","v":-130.21289894066285},null,"Imunização"]
["Variação ocorrida em B",null,null,null,{"$f":"G51-F20","v":130.20590396411717},null,{"$f":"E67+E68","v":-6.9949765456840396E-3}]

{"sheet":"DIV 01","index":4,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Data",{"$f":"BMF!L1","v":"2020-02-05"},38,99,164,288,350,415,478,540,602,853]
["Preço Anbima",{"$f":"SUMPRODUCT(C2:L2,C5:L5)","v":929734.65990000009},993.85122000000001,984.15479000000005,973.62231299999996,951.64805899999999,939.65617099999997,926.42406700000004,913.11068,899.42752399999995,885.84458500000005,829.60718999999995]
["Prazo em dias úteis",0,{"$f":"C1+$B$3","v":38},{"$f":"D1+$B$3","v":99},164,288,350,415,478,540,602,853]
["Valor Nominal - R$",null,{"$f":"$M$4*C5","v":100000},100000,100000,100000,100000,100000,100000,100000,100000,100000,1000]
["Carteira",null,100,100,100,100,100,100,100,100,100,100]
[]
["Taxa Equivalente",4.9863002724634668E-2,{"$f":"B8-B2","v":-6.0535967350006104E-8},"Atingir meta para valor = 0"]
["VPL taxa única",{"$f":"SUM(C8:L8)","v":929734.65989993955},{"$f":"C4/(1+$B$7)^(C3/252)","v":99268.928314855002},98106.525412072864,96882.874918682821,94590.696047801088,93465.024260882914,92299.265688034036,91183.254314876045,90098.132615699942,89025.924352339091,84814.033974695776]
[]
["Duration",{"$f":"SUMPRODUCT(C10:L10,C36:L36)/SUM(C36:L36)","v":1.4759766505682168},{"$f":"C3/252","v":0.15079365079365079},0.39285714285714285,0.65079365079365081,1.1428571428571428,1.3888888888888888,1.6468253968253967,1.8968253968253967,2.1428571428571428,2.3888888888888888,3.3849206349206349,{"$f":"B10*252","v":371.94611594319065}]
["Modify Duration",{"$f":"B10/(1+B7)","v":1.4058754777887397}]
[]
[]
[]
["t^2 + t",null,{"$f":"C10^2+C10","v":0.17353237591332829},0.54719387755102034,1.0743260267069792,2.4489795918367347,3.3179012345679011,4.3588592844545229,5.4947719828672206,6.7346938775510203,8.0956790123456788,14.842608339632148]
["(t^2 + t) * VPL(t)",{"$f":"SUM(C16:K16)","v":2947611.2124365726},{"$f":"C15*C36","v":17226.372984846657},53683.290053289864,104083.79406733776,231650.68419869654,310107.71938410227,402319.51119262195,501031.19111603749,606783.34210573428,720725.3073339056,1258861.4879906639]
["Convexity",{"$f":"(1/B8)*(1/((1+B7)^2))*B16","v":2.8763777164275957}]
[]
[]
["DIV01 - Duration para",1E-4,{"$f":"-B8*B11/10000","v":-130.7091159203579}]
["DIV01 - Duration para ",0.05,{"$f":"C68","v":-65354.557960179052}]
[]
[]
["Fluxos Futuros",null,"C1","C2","C3","C4","C5","C6","C7","C8","C9","C10"]
[]
[]
["Variações em i","VPL-Totais","VP(1)","VP(2)","VP(3)","VP(4)","VP(5)","VP(6)","VP(7)","VP(8)","VP(9)","VP(10)"]
[{"$f":"A49","v":-0.35013699727536518},{"$f":"SUM(C28:L28)","v":2094921.2134753503},{"$f":"C$4/((1+$A49)^(C$3/252))","v":106714.95416475534},118449.78800655851,132377.5611813092,163650.72291496798,181957.39235793057,203352.62936831717,226487.55268179934,251823.41851873571,279993.4626145059,430113.73166647041]
[{"$f":"A50","v":-0.30013699727536514},{"$f":"SUM(C29:L29)","v":1822071.5035968572},{"$f":"C$4/((1+$A50)^(C$3/252))","v":105528.81226877317},115050.2948346279,126143.39992393764,150358.49122942734,164157.10049716308,179985.06486343357,196781.02117291754,214839.89101305124,234556.04862392135,334671.37916960428]
[-0.25013699727536509,1607588.4711330689,{"$f":"C$4/((1+$A51)^(C$3/252))","v":104436.40931758111},111973.2395386026,120603.79349586283,138956.15812178759,149154.44933312596,160650.81693166448,172638.42160219376,185308.72654990174,198908.93241988434,264957.52382246446]
[-0.20013699727536502,1435676.1454704686,{"$f":"C$4/((1+$A52)^(C$3/252))","v":103424.7858592522},109169.42193774915,115642.32797117246,129074.15893416322,136364.25458360286,144449.60477205392,152743.40071807956,161370.33278759982,170484.5131217406,212953.34478505477]
[-0.15013699727536495,1295548.0174302405,{"$f":"C$4/((1+$A53)^(C$3/252))","v":102483.44922386916},106599.65032385854,111167.86679988239,120432.60697697109,125350.62256434149,130722.39233599252,136148.46723009963,141708.25955579642,147495.0929296501,173439.60948977922]
[-0.1001369972753649,1179639.3308623403,{"$f":"C$4/((1+$A54)^(C$3/252))","v":101603.79006407944},104232.25413758113,107107.95075594932,112815.77537701455,115782.75889692188,118977.12604344578,122157.28590521449,125369.94524213932,128667.0954871475,142925.3489528471]
[-5.0136997275364879E-2,1082519.3617090604,{"$f":"C$4/((1+$A55)^(C$3/252))","v":100778.6609475482},102041.31498664754,103404.18059050017,106054.79711965179,107405.47683294042,108839.98627708234,110248.63859905489,111652.72972569606,113074.70290436949,119018.87372556962]
[{"$f":"A56","v":-1.3699727536482104E-4},1000208.0952181985,{"$f":"C$4/((1+$A56)^(C$3/252))","v":100002.06599479109},100005.3825493677,100008.91670398157,100015.65912995364,100019.03051339871,100022.56515032677,100025.9911484022,100029.3628801247,100032.73472550341,100046.38642234867]
[{"$f":"A57","v":4.9863002724634668E-2},929734.65989993955,{"$f":"C$4/((1+$A57)^(C$3/252))","v":99268.928314855002},98106.525412072864,96882.874918682821,94590.696047801088,93465.024260882914,92299.265688034036,91183.254314876045,90098.132615699942,89025.924352339091,84814.033974695776]
[9.986300272463472E-2,868844.73042067059,{"$f":"C$4/((1+$A58)^(C$3/252))","v":98574.913028671712},96329.618046606774,93993.345098765363,89692.451241239265,87616.376199734266,85491.424667129846,83481.050614530395,81548.74836143112,79661.172330269008,72455.630832292809]
[0.14986300272463476,815802.2357322867,{"$f":"C$4/((1+$A59)^(C$3/252))","v":97916.290715471667},94661.797349922723,91312.8510208769,85249.172239485968,82370.045277410347,79455.956717107445,76729.953700542232,74138.546972539771,71634.660026657133,62332.961712272641]
[0.19986300272463481,769252.23097185581,{"$f":"C$4/((1+$A60)^(C$3/252))","v":97289.83072355004},93092.042960214487,88818.128250611189,81201.455635551829,77641.678126321582,74077.099461266494,70778.45092893987,67675.605840967284,64708.785878065879,53969.153166367236]
[0.24986300272463485,728124.31489925401,{"$f":"C$4/((1+$A61)^(C$3/252))","v":96692.716862801739},91610.849282762676,86489.334784898849,77499.713997853905,73361.612949519054,69260.323994671096,65504.165106999098,62006.566982868244,58695.723282947525,47003.307653931792]
[0.2998630027246349,691563.46293288737,{"$f":"C$4/((1+$A62)^(C$3/252))","v":96122.480090938014},90209.966392283211,84309.434486793063,74102.239596713538,69471.857780882303,64927.782112045395,60807.363309259606,57007.73038496232,53445.522824530555,41159.085954479444]
[0.34986300272463494,658879.73538174061,{"$f":"C$4/((1+$A63)^(C$3/252))","v":95576.944256633375},88882.193306674497,82263.710452787142,70973.707483019229,65923.77846331209,61014.86047658488,56606.095395740456,52578.452287204062,48837.384482905341,36222.608776879482]
[0.39986300272463499,629511.197272146,{"$f":"C$4/((1+$A64)^(C$3/252))","v":95054.181984719835},87621.211535952665,80339.377243073017,68084.006129558256,62676.310405458637,57467.54304808913,52832.51024362586,48636.192253843692,44773.174434546861,32026.68999327816]
[0.44986300272463503,602996.22679158906,{"$f":"C$4/((1+$A65)^(C$3/252))","v":94552.478518639764},86421.449928583432,78525.269155282571,65407.31515579082,59694.56158892854,54240.371108687323,49430.034131024404,45112.755503709675,41172.553183816919,28439.438517125567]
[0.49986300272463507,578952.58942251117,{"$f":"C$4/((1+$A66)^(C$3/252))","v":94070.301864057488},85277.974073863952,76811.58757834055,62921.371448244383,56948.71110700268,51294.850260869367,46351.18783791153,41951.412451631979,37969.275196168091,25355.917604421171]
[]
[null,"VPL - R$"]
["Variações em i","Full Valuation","Modify Duration","Convexity",null,null,null,null,null,null,null,null,"Convexidade","Duration"]
[{"$f":"$B$7+(ROW()%-57%)*$B$21*100","v":-0.35013699727536518},{"$f":"SUM(C28:L28)","v":2094921.2134753503},{"$f":"$B$57-$B$57*$B$11*(A49-$B$7)","v":1452571.1235813708},{"$f":"$B$8+$B$8*(-$B$11*(A49-$B$7)+$B$17*0.5*((A49-$B$7)^2))","v":1666512.5682154968},null,null,null,null,null,null,null,null,{"$f":"D49-B49","v":-428408.64525985345},{"$f":"C49-B49","v":-642350.08989397949}]
[{"$f":"$B$7+(ROW()%-57%)*$B$21*100","v":-0.30013699727536514},1822071.5035968572,{"$f":"$B$57-$B$57*$B$11*(A50-$B$7)","v":1387216.5656211919},{"$f":"$B$8+$B$8*(-$B$11*(A50-$B$7)+$B$17*0.5*((A50-$B$7)^2))","v":1551015.4841691945},null,null,null,null,null,null,null,null,-271056.01942766272,{"$f":"C50-B50","v":-434854.93797566532}]
[-0.25013699727536509,1607588.4711330689,1321862.0076610129,1442204.0702677085,null,null,null,null,null,null,null,null,-165384.4008653604,-285726.46347205597]
[-0.20013699727536502,1435676.1454704686,1256507.4497008338,1340078.3265110392,null,null,null,null,null,null,null,null,-95597.818959429394,-179168.6957696348]
[-0.15013699727536495,1295548.0174302405,1191152.8917406548,1244638.2528991862,null,null,null,null,null,null,null,null,-50909.764531054301,-104395.12568958569]
[-0.1001369972753649,1179639.3308623403,1125798.3337804759,1155883.8494321497,null,null,null,null,null,null,null,null,-23755.481430190615,-53840.997081864392]
[-5.0136997275364879E-2,1082519.3617090604,1060443.775820297,1073815.1161099295,null,null,null,null,null,null,null,null,-8704.245599130867,-22075.585888763424]
[-1.3699727536482104E-4,1000208.0952181985,995089.21786011779,998432.05293252598,null,null,null,null,null,null,null,null,-1776.0422856725054,-5118.8773580807028]
[{"$f":"$B$7+(ROW()%-57%)*$B$21*100","v":4.9863002724634668E-2},929734.65989993955,{"$f":"$B$57-$B$57*$B$11*(A57-$B$7)","v":929734.65989993955},929734.65989993955,null,null,null,null,null,null,null,null,0,0]
[9.986300272463472E-2,868844.73042067059,864380.1019397605,867722.93701216881,null,null,null,null,null,null,null,null,{"$f":"D58-B58","v":-1121.7934085017769},-4464.6284809100907]
[0.14986300272463476,815802.2357322867,799025.54397958156,812396.88426921447,null,null,null,null,null,null,null,null,-3405.3514630722348,-16776.691752705141]
[0.19986300272463481,769252.23097185581,733670.98601940251,763756.50167107652,null,null,null,null,null,null,null,null,-5495.7293007792905,-35581.2449524533]
[0.24986300272463485,728124.31489925401,668316.42805922357,721801.7892177552,null,null,null,null,null,null,null,null,-6322.5256814988097,-59807.886840030435]
[0.2998630027246349,691563.46293288737,602961.87009904452,686532.74690925016,null,null,null,null,null,null,null,null,-5030.7160236372147,-88601.592833842849]
[0.34986300272463494,658879.73538174061,537607.31213886547,657949.37474556174,null,null,null,null,null,null,null,null,-930.36063617886975,-121272.42324287514]
[0.39986300272463499,629511.197272146,472252.75417868653,636051.67272668961,null,null,null,null,null,null,null,null,6540.4754545436008,-157258.44309345947]
[0.44986300272463503,602996.22679158906,406898.19621850748,620839.64085263398,null,null,null,null,null,null,null,null,17843.414061044925,-196098.03057308157]
[0.49986300272463507,578952.58942251117,341543.63825832854,612313.27912339475,null,null,null,null,null,null,null,null,{"$f":"D66-B66","v":33360.68970088358},-237408.95116418262]
[]
[{"$f":"A21&B21*100&\"%\"","v":"DIV01 - Duration para 5%"},{"$f":"B58-B57","v":-60889.929479268962},{"$f":"C58-C57","v":-65354.557960179052},{"$f":"D58-D57","v":-62011.722887770738}]

{"sheet":"FERIADOS","index":5,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["2009-01-01","2009-02-23","2009-02-24","2009-04-10","2009-04-21","2009-05-01","2009-06-11","2009-09-07","2009-10-12","2009-11-02","2009-11-15","2009-12-25"]
["2010-01-01","2010-02-15","2010-02-16","2010-04-02","2010-04-21","2010-05-01","2010-06-03","2010-09-07","2010-10-12","2010-11-02","2010-11-15","2010-12-25"]
["2011-01-01","2011-03-07","2011-03-08","2011-04-21","2011-04-22","2011-05-01","2011-06-23","2011-09-07","2011-10-12","2011-11-02","2011-11-15","2011-12-25"]
["2012-01-01","2012-02-20","2012-02-21","2012-04-06","2012-04-21","2012-05-01","2012-06-07","2012-09-07","2012-10-12","2012-11-02","2012-11-15","2012-12-25"]
["2013-01-01","2013-02-11","2013-02-12","2013-03-29","2013-04-21","2013-05-01","2013-05-30","2013-09-07","2013-10-12","2013-11-02","2013-11-15","2013-12-25"]
["2014-01-01","2014-03-03","2014-03-04","2014-04-18","2014-04-21","2014-05-01","2014-06-19","2014-09-07","2014-10-12","2014-11-02","2014-11-15","2014-12-25"]
["2015-01-01","2015-02-16","2015-02-17","2015-04-03","2015-04-21","2015-05-01","2015-06-04","2015-09-07","2015-10-12","2015-11-02","2015-11-15","2015-12-25"]
["2016-01-01","2016-02-08","2016-02-09","2016-03-25","2016-04-21","2016-05-01","2016-05-26","2016-09-07","2016-10-12","2016-11-02","2016-11-15","2016-12-25"]
["2017-01-01","2017-02-27","2017-02-28","2017-04-14","2017-04-21","2017-05-01","2017-06-15","2017-09-07","2017-10-12","2017-11-02","2017-11-15","2017-12-25"]
["2018-01-01","2018-02-12","2018-02-13","2018-03-30","2018-04-21","2018-05-01","2018-05-31","2018-09-07","2018-10-12","2018-11-02","2018-11-15","2018-12-25"]
["2019-01-01","2019-03-04","2019-03-05","2019-04-19","2019-04-21","2019-05-01","2019-06-20","2019-09-07","2019-10-12","2019-11-02","2019-11-15","2019-12-25"]
["2020-01-01","2020-02-24","2020-02-25","2020-04-10","2020-04-21","2020-05-01","2020-06-11","2020-09-07","2020-10-12","2020-11-02","2020-11-15","2020-12-25"]
["2021-01-01","2021-02-15","2021-02-16","2021-04-02","2021-04-21","2021-05-01","2021-06-03","2021-09-07","2021-10-12","2021-11-02","2021-11-15","2021-12-25"]
["2022-01-01","2022-02-28","2022-03-01","2022-04-15","2022-04-21","2022-05-01","2022-06-16","2022-09-07","2022-10-12","2022-11-02","2022-11-15","2022-12-25"]
["2023-01-01","2023-02-20","2023-02-21","2023-04-07","2023-04-21","2023-05-01","2023-06-08","2023-09-07","2023-10-12","2023-11-02","2023-11-15","2023-12-25"]
["2024-01-01","2024-02-12","2024-02-13","2024-03-29","2024-04-21","2024-05-01","2024-05-30","2024-09-07","2024-10-12","2024-11-02","2024-11-15","2024-12-25"]
["2025-01-01","2025-03-03","2025-03-04","2025-04-18","2025-04-21","2025-05-01","2025-06-19","2025-09-07","2025-10-12","2025-11-02","2025-11-15","2025-12-25"]
["2026-01-01","2026-02-16","2026-02-17","2026-04-03","2026-04-21","2026-05-01","2026-06-04","2026-09-07","2026-10-12","2026-11-02","2026-11-15","2026-12-25"]
["2027-01-01","2027-02-08","2027-02-09","2027-03-26","2027-04-21","2027-05-01","2027-05-27","2027-09-07","2027-10-12","2027-11-02","2027-11-15","2027-12-25"]
["2028-01-01","2028-02-28","2028-02-29","2028-04-14","2028-04-21","2028-05-01","2028-06-15","2028-09-07","2028-10-12","2028-11-02","2028-11-15","2028-12-25"]
["2029-01-01","2029-02-12","2029-02-13","2029-03-30","2029-04-21","2029-05-01","2029-05-31","2029-09-07","2029-10-12","2029-11-02","2029-11-15","2029-12-25"]
["2030-01-01","2030-03-04","2030-03-05","2030-04-19","2030-04-21","2030-05-01","2030-06-20","2030-09-07","2030-10-12","2030-11-02","2030-11-15","2030-12-25"]
["2031-01-01","2031-02-24","2031-02-25","2031-04-11","2031-04-21","2031-05-01","2031-06-12","2031-09-07","2031-10-12","2031-11-02","2031-11-15","2031-12-25"]
["2032-01-01","2032-02-09","2032-02-10","2032-03-26","2032-04-21","2032-05-01","2032-05-27","2032-09-07","2032-10-12","2032-11-02","2032-11-15","2032-12-25"]
["2033-01-01","2033-02-28","2033-03-01","2033-04-15","2033-04-21","2033-05-01","2033-06-16","2033-09-07","2033-10-12","2033-11-02","2033-11-15","2033-12-25"]
["2034-01-01","2034-02-20","2034-02-21","2034-04-07","2034-04-21","2034-05-01","2034-06-08","2034-09-07","2034-10-12","2034-11-02","2034-11-15","2034-12-25"]
["2035-01-01","2035-02-05","2035-02-06","2035-03-23","2035-04-21","2035-05-01","2035-05-24","2035-09-07","2035-10-12","2035-11-02","2035-11-15","2035-12-25"]
["2036-01-01","2036-02-25","2036-02-26","2036-04-11","2036-04-21","2036-05-01","2036-06-12","2036-09-07","2036-10-12","2036-11-02","2036-11-15","2036-12-25"]
["2037-01-01","2037-02-16","2037-02-17","2037-04-03","2037-04-21","2037-05-01","2037-06-04","2037-09-07","2037-10-12","2037-11-02","2037-11-15","2037-12-25"]
["2038-01-01","2038-03-08","2038-03-09","2038-04-21","2038-04-23","2038-05-01","2038-06-24","2038-09-07","2038-10-12","2038-11-02","2038-11-15","2038-12-25"]
["2039-01-01","2039-02-21","2039-02-22","2039-04-08","2039-04-21","2039-05-01","2039-06-09","2039-09-07","2039-10-12","2039-11-02","2039-11-15","2039-12-25"]
["2040-01-01","2040-02-13","2040-02-14","2040-03-30","2040-04-21","2040-05-01","2040-05-31","2040-09-07","2040-10-12","2040-11-02","2040-11-15","2040-12-25"]
["2041-01-01","2041-03-04","2041-03-05","2041-04-19","2041-04-21","2041-05-01","2041-06-20","2041-09-07","2041-10-12","2041-11-02","2041-11-15","2041-12-25"]
["2042-01-01","2042-02-17","2042-02-18","2042-04-04","2042-04-21","2042-05-01","2042-06-05","2042-09-07","2042-10-12","2042-11-02","2042-11-15","2042-12-25"]
["2043-01-01","2043-02-09","2043-02-10","2043-03-27","2043-04-21","2043-05-01","2043-05-28","2043-09-07","2043-10-12","2043-11-02","2043-11-15","2043-12-25"]
["2044-01-01","2044-02-29","2044-03-01","2044-04-15","2044-04-21","2044-05-01","2044-06-16","2044-09-07","2044-10-12","2044-11-02","2044-11-15","2044-12-25"]
["2045-01-01","2045-02-20","2045-02-21","2045-04-07","2045-04-21","2045-05-01","2045-06-08","2045-09-07","2045-10-12","2045-11-02","2045-11-15","2045-12-25"]
["2046-01-01","2046-02-05","2046-02-06","2046-03-23","2046-04-21","2046-05-01","2046-05-24","2046-09-07","2046-10-12","2046-11-02","2046-11-15","2046-12-25"]
["2047-01-01","2047-02-25","2047-02-26","2047-04-12","2047-04-21","2047-05-01","2047-06-13","2047-09-07","2047-10-12","2047-11-02","2047-11-15","2047-12-25"]
["2048-01-01","2048-02-17","2048-02-18","2048-04-03","2048-04-21","2048-05-01","2048-06-04","2048-09-07","2048-10-12","2048-11-02","2048-11-15","2048-12-25"]
["2049-01-01","2049-03-01","2049-03-02","2049-04-16","2049-04-21","2049-05-01","2049-06-17","2049-09-07","2049-10-12","2049-11-02","2049-11-15","2049-12-25"]
["2050-01-01","2050-02-21","2050-02-22","2050-04-08","2050-04-21","2050-05-01","2050-06-09","2050-09-07","2050-10-12","2050-11-02","2050-11-15","2050-12-25"]
["2051-01-01","2051-02-13","2051-02-14","2051-03-31","2051-04-21","2051-05-01","2051-06-01","2051-09-07","2051-10-12","2051-11-02","2051-11-15","2051-12-25"]
["2052-01-01","2052-03-04","2052-03-05","2052-04-19","2052-04-21","2052-05-01","2052-06-20","2052-09-07","2052-10-12","2052-11-02","2052-11-15","2052-12-25"]
["2053-01-01","2053-02-17","2053-02-18","2053-04-04","2053-04-21","2053-05-01","2053-06-05","2053-09-07","2053-10-12","2053-11-02","2053-11-15","2053-12-25"]
["2054-01-01","2054-02-09","2054-02-10","2054-03-27","2054-04-21","2054-05-01","2054-05-28","2054-09-07","2054-10-12","2054-11-02","2054-11-15","2054-12-25"]
["2055-01-01","2055-03-01","2055-03-02","2055-04-16","2055-04-21","2055-05-01","2055-06-17","2055-09-07","2055-10-12","2055-11-02","2055-11-15","2055-12-25"]
["2056-01-01","2056-02-14","2056-02-15","2056-03-31","2056-04-21","2056-05-01","2056-06-01","2056-09-07","2056-10-12","2056-11-02","2056-11-15","2056-12-25"]
["2057-01-01","2057-03-05","2057-03-06","2057-04-20","2057-04-21","2057-05-01","2057-06-21","2057-09-07","2057-10-12","2057-11-02","2057-11-15","2057-12-25"]
["2058-01-01","2058-02-25","2058-02-26","2058-04-12","2058-04-21","2058-05-01","2058-06-13","2058-09-07","2058-10-12","2058-11-02","2058-11-15","2058-12-25"]
["2059-01-01","2059-02-10","2059-02-11","2059-03-28","2059-04-21","2059-05-01","2059-05-29","2059-09-07","2059-10-12","2059-11-02","2059-11-15","2059-12-25"]
["2060-01-01","2060-03-01","2060-03-02","2060-04-16","2060-04-21","2060-05-01","2060-06-17","2060-09-07","2060-10-12","2060-11-02","2060-11-15","2060-12-25"]
["2061-01-01","2061-02-21","2061-02-22","2061-04-08","2061-04-21","2061-05-01","2061-06-09","2061-09-07","2061-10-12","2061-11-02","2061-11-15","2061-12-25"]
["2062-01-01","2062-02-06","2062-02-07","2062-03-24","2062-04-21","2062-05-01","2062-05-25","2062-09-07","2062-10-12","2062-11-02","2062-11-15","2062-12-25"]
["2063-01-01","2063-02-26","2063-02-27","2063-04-13","2063-04-21","2063-05-01","2063-06-14","2063-09-07","2063-10-12","2063-11-02","2063-11-15","2063-12-25"]
["2064-01-01","2064-02-18","2064-02-19","2064-04-04","2064-04-21","2064-05-01","2064-06-05","2064-09-07","2064-10-12","2064-11-02","2064-11-15","2064-12-25"]
["2065-01-01","2065-02-09","2065-02-10","2065-03-27","2065-04-21","2065-05-01","2065-05-28","2065-09-07","2065-10-12","2065-11-02","2065-11-15","2065-12-25"]
["2066-01-01","2066-02-22","2066-02-23","2066-04-09","2066-04-21","2066-05-01","2066-06-10","2066-09-07","2066-10-12","2066-11-02","2066-11-15","2066-12-25"]
["2067-01-01","2067-02-14","2067-02-15","2067-04-01","2067-04-21","2067-05-01","2067-06-02","2067-09-07","2067-10-12","2067-11-02","2067-11-15","2067-12-25"]
["2068-01-01","2068-03-05","2068-03-06","2068-04-20","2068-04-21","2068-05-01","2068-06-21","2068-09-07","2068-10-12","2068-11-02","2068-11-15","2068-12-25"]
["2069-01-01","2069-02-25","2069-02-26","2069-04-12","2069-04-21","2069-05-01","2069-06-13","2069-09-07","2069-10-12","2069-11-02","2069-11-15","2069-12-25"]
["2070-01-01","2070-02-10","2070-02-11","2070-03-28","2070-04-21","2070-05-01","2070-05-29","2070-09-07","2070-10-12","2070-11-02","2070-11-15","2070-12-25"]