{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Portfólio"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":30,"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":"Portfólio","index":0,"n_rows":50,"n_cols":23,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,6,26,8],[38,10,38,12]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pontos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,"Seleção de Portfólios",null,null,null,null,null,null,null,null,null,4.8152839473684213E-2]
[null,null,"Taxas de Retorno",null,null,null,"Matriz de Covariâncias - C"]
["Trimestre","a","b","c",null,"Cias.","a","b","c",null,"P",null,"R",null,null,null,null,"Risco","Retorno",null,"Risco","Retorno"]
[1,-0.39929999999999999,-0.5363,0.25269999999999998,null,"a",{"$f":"COVAR(B29:B48,B29:B48)*20/19","v":4.4117003263157893E-2},{"$f":"_xlfn.COVARIANCE.S(B29:B48,C29:C48)","v":4.8152839473684213E-2},{"$f":"COVAR(B29:B48,D29:D48)*20/19","v":1.2498759631578949E-2},null,{"$f":"M33/M36","v":0.3155737704918033},null,{"$f":"B50","v":9.7130000000000008E-2},null,null,null,null,null,null,null,4.4117003263157893E-2,9.7130000000000008E-2,"a"]
[2,0.28520000000000001,0.47199999999999998,-4.4600000000000001E-2,null,"b",{"$f":"COVAR(C29:C48,B29:B48)*20/19","v":4.8152839473684213E-2},{"$f":"COVAR(C29:C48,C29:C48)*20/19","v":0.10390997052631577},{"$f":"COVAR(C29:C48,D29:D48)*20/19","v":2.3085687368421048E-2},null,{"$f":"M34/M36","v":0.35655737704918034},null,{"$f":"C50","v":0.1109},null,null,null,null,null,null,null,0.10390997052631577,0.1109,"b"]
[3,3.5200000000000002E-2,-0.2399,8.3999999999999995E-3,null,"c",{"$f":"COVAR(D29:D48,B29:B48)*20/19","v":1.2498759631578949E-2},{"$f":"COVAR(D29:D48,C29:C48)*20/19","v":2.3085687368421048E-2},{"$f":"COVAR(D29:D48,D29:D48)*20/19","v":5.9734018394736819E-2},null,{"$f":"M35/M36","v":0.32786885245901637},null,{"$f":"D50","v":9.9344999999999989E-2},null,null,null,null,null,null,null,5.9734018394736819E-2,9.9344999999999989E-2,"c"]
[4,-8.6300000000000002E-2,0.32719999999999999,0.1515]
[5,9.8799999999999999E-2,0.44679999999999997,8.0100000000000005E-2,null,null,"a","b","c","Total",null,{"$f":"RANDBETWEEN(0,100)","v":57},77]
[6,0.20680000000000001,8.7099999999999997E-2,6.9000000000000006E-2,null,"Partic.  PT",{"$f":"K29","v":0.3155737704918033},{"$f":"K30","v":0.35655737704918034},{"$f":"K31","v":0.32786885245901637},{"$f":"SUM(K29:K31)","v":1},null,null,87]
[7,0.21840000000000001,-3.2000000000000001E-2,0.31869999999999998,null,"Aplicação",{"$f":"K29*$I$43","v":31557.37704918033},{"$f":"K30*$I$43","v":35655.737704918036},{"$f":"K31*$I$43","v":32786.885245901634},{"$f":"SUM(G35:I35)","v":100000},null,null,80]
[8,9.4799999999999995E-2,0.29110000000000003,0.64259999999999995,null,null,null,null,null,null,null,null,{"$f":"SUM(M33:M35)","v":244}]
[9,-5.74E-2,-0.14410000000000001,-5.1499999999999997E-2,null,null,"Retorno esperado",null,{"$f":"B50*K29+C50*K30+D50*K31","v":0.10276602459016393},": = PT R =",{"$f":"MMULT(G34:I34,M29:M31)","v":0.10276602459016393}]
[10,0.38919999999999999,0.66020000000000001,0.61919999999999997,null,null,"Retorno Desejado",null,0.1]
[11,7.8799999999999995E-2,-0.28339999999999999,-0.17369999999999999,null,null,null,null,null,null,"PT ",null,null,null,"S P"]
[12,-0.2702,-0.3957,-0.1215,null,null,"Variância da carteira",null,{"$f":"G29*K29^2+H30*K30^2+I31*K31^2+2*(G30*K29*K30+G31*K29*K31+H31*K30*K31)","v":4.2845525851336289E-2},": = PT C P =",{"$f":"G34","v":0.3155737704918033},{"$f":"H34","v":0.35655737704918034},{"$f":"I34","v":0.32786885245901637},"x",{"$f":"MMULT(G29:I31,K29:K31)","v":3.5189373180327867E-2},"=",{"$f":"MMULT(K40:M40,O40:O42)","v":4.2845525851336289E-2}]
[13,0.38450000000000001,0.1928,-1.8800000000000001E-2,null,null,"Desvio Padrão ",null,{"$f":"SQRT(I40)","v":0.20699160816645754},null,null,null,null,null,5.9814717478429674E-2]
[14,0.25490000000000002,0.44969999999999999,3.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,3.1760576902717851E-2]
[15,9.9000000000000008E-3,0.01,-0.26900000000000002,null,null,"Capital Disponível",null,100000]
[16,0.31690000000000002,3.49E-2,0.4325]
[17,0.2495,0.4279,-4.3400000000000001E-2,null,"Variância do portfólio"]
[18,0.05,0.1263,-4.7600000000000003E-2]
[19,-0.12089999999999999,-2.0899999999999998E-2,3.1399999999999997E-2]
[20,0.20380000000000001,0.34429999999999999,0.1479]
[]
["Média",{"$f":"AVERAGE(B29:B48)","v":9.7130000000000008E-2},{"$f":"AVERAGE(C29:C48)","v":0.1109},{"$f":"AVERAGE(D29:D48)","v":9.9344999999999989E-2}]