{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cálculos","Fórmulas"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Cálculos","index":0,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,null,"Aplicación de la función SQRT ET MAX (según Zorraquino, 2004)(1)"]
[null,"Rellenar solamente los números en azul: siempre C4 y C5; y J4 ó (J12 a J18)  según el cálculo deseado"]
[null,null,null,null,null,null,null,null,"Introducir el dato en J4 y confirmar la entrada"]
[null,"media",148.69999999999999,null,null,null,"A partir del valor ",null,"x=",400,"––>>","F(x)=",{"$f":"EXP(-k*(1+SQRT(alfa*x))*EXP(-SQRT(alfa*x)))","v":0.98870402697342963}]
[null,"desv típica",73.5,null,null,null,"calcular el retorno",null,null,null,null,"Probabilidad de que se supere x=",{"$f":"1-M4","v":1.1295973026570372E-2}]
[null,"Cv",{"$f":"desv/med","v":0.4942837928715535},null,null,null,null,null,null,null,null,"Periodo de retorno=",{"$f":"1/M5","v":88.527123572958388},"años"]
[]
[]
[]
[null,null,null,null,null,null,"A partir del retorno"]
[null,null,null,null,null,null,"calcular el valor",null,null,"Retorno",null,"x"]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,210]
[null,null,null,null,null,null,null,null,null,500]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"j","aj * (ln(Cv))j",null,null,"Cv :","0.99 a 0.70","0.70 a 0.30","0.30 a 0.19"]
[null,null,null,null,0,{"$f":"IF(Cv<0.3,L28*(LN(Cv))^E28,IF(Cv<0.7,K28*(LN(Cv))^E28,J28*(LN(Cv))^E28))","v":1.801512523},null,null,"a0",1.318614521,1.801512523,-1765.864939]
[null,null,null,null,1,{"$f":"IF(Cv<0.3,L29*(LN(Cv))^E29,IF(Cv<0.7,K29*(LN(Cv))^E29,J29*(LN(Cv))^E29))","v":-1.743124135209404},null,null,"a1",-3.1646276860000002,2.4737605870000001,-7240.5919899999999]
[null,null,null,null,2,{"$f":"IF(Cv<0.3,L30*(LN(Cv))^E30,IF(Cv<0.7,K30*(LN(Cv))^E30,J30*(LN(Cv))^E30))","v":11.696247159605104},null,null,"a2",-1.5955243969999999,23.556200189999998,-11785.550149999999]
[null,null,null,null,3,-17.478762507912318,null,null,"a3",-6.2691108529999999,49.957273800000003,-9537.9851739999995]
[null,null,null,null,4,14.736922708590992,null,null,"a4",-11.31766964,59.775635870000002,-3834.341011]
[null,null,null,null,5,-6.2013103339476929,null,null,"a5",-22.697555000000001,35.696876279999998,-612.6777022]
[null,null,null,null,6,1.0412010833877716,null,null,"a6",-22.066344690000001,8.5057127070000007,0]
[null,null,null,null,"Suma......",{"$f":"SUM(F28:F34)","v":3.852686497514453},"=ln(k)"]
[null,null,null,null,"k =",{"$f":"EXP(ln_k)","v":47.119479711895728}]
[]
[null,null,null,null,"j","bj * (ln(k))j",null,null,"Cv :","0.99 a 0.70","0.70 a 0.30","0.30 a 0.19"]
[null,null,null,null,0,{"$f":"IF(Cv<0.3,L39*ln_k^E39,IF(Cv<0.7,K39*ln_k^E39,J39*ln_k^E39))","v":2.3426968819999998},null,null,"b0",2.3073185430000001,2.3426968819999998,-0.93150848799999997]
[null,null,null,null,1,-0.5770717074304047,null,null,"b1",-0.136673609,-0.14978423699999999,2.1567091660000002]
[null,null,null,null,2,-1.4741068367784735,null,null,"b2",-7.5035626999999994E-2,-9.9311974999999997E-2,-0.77977033500000004]
[null,null,null,null,3,0.1969561469059104,null,null,"b3",-1.3464311E-2,3.444122E-3,0.112962273]
[null,null,null,null,4,0.22329493133004136,null,null,"b4",3.2280289999999999E-3,1.013501E-3,-9.3404539999999998E-3]
[null,null,null,null,5,-0.12003239635001893,null,null,"b5",5.2123999999999996E-4,-1.4140999999999999E-4,4.1189599999999997E-4]
[null,null,null,null,6,1.7962579164956256E-2,null,null,"b6",-1.4090000000000001E-4,5.4927099999999998E-6,-7.5371000000000002E-6]
[null,null,null,null,"Suma......",{"$f":"SUM(F39:F45)","v":0.60969959884201075},"=ln(I1)"]
[null,null,null,null,null,{"$f":"EXP(F46)","v":1.8398786140909813},"=I1"]
[]
[null,null,null,null,"a=",{"$f":"k*I_1/(1-EXP(-k))/2/med","v":0.29150680238403104}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"148*6","v":888}]

{"sheet":"Fórmulas","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}