{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["INPUTS","GLM 1","GLM 2","Bootstrap 1","Bootstrap 2"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"INPUTS","index":0,"n_rows":8,"n_cols":6,"rows_kept":8}
["Ejemplo ilustrativo con el triángulo de Schmidt y Zocher (2008):"]
[]
[1001,854,568,565,347,148]
[1113,990,671,648,422]
[1265,1168,800,744]
[1490,1383,1007]
[1725,2536]
[1889]

{"sheet":"GLM 1","index":1,"n_rows":8,"n_cols":11,"rows_kept":8}
["Rectángulo de desarrollo",{"$nulls":6},"Años de origen","IBNR","P.E.","C.V."]
[1001,854,568,565,347,148,null,0,0,0,"-"]
[1113,990,671,648,422,170.58830584707678,null,1,170.58830584707678,82.95983604707874,0.48631607914230507]
[1265,1168,800,744,477.1159126365057,197.66391456377946,null,2,674.7798272002851,160.0037242092494,0.23711989860917673]
[1490,1383,1007,900.7307236061694,573.5385220675731,237.61074913334795,null,3,1711.8799948070905,270.8205123793059,0.15820064093325906]
[1725,2536,1401.0153281519886,1314.4204029885475,836.9546142351127,346.7411607543021,null,4,3899.131506129951,477.30710902071166,0.12241369860706716]
[1889,1985.5412496208717,1273.947824519127,1195.2067755743758,761.0455707379646,315.2928726317686,null,5,5531.034293084108,737.7315484178353,0.1333803967442906]
[{"$nulls":7},"PT Total",11987.41392706851,1167.0558071745909,0.09735676220700851]

{"sheet":"GLM 2","index":2,"n_rows":15,"n_cols":11,"rows_kept":15}
["Rectángulo de desarrollo",{"$nulls":6},"Años de calendario","IBNR","P.E.","C.V."]
[1001,854,568,565,347,148,null,6,4934.991519862612,440.79731473547963,0.0893207846378936]
[1113,990,671,648,422,170.58830584707678,null,7,3359.570664139027,379.5011032479572,0.11296119093396528]
[1265,1168,800,744,477.1159126365057,197.66391456377946,null,8,2269.7721389428366,331.88407510439936,0.146219115747441]
[1490,1383,1007,900.7307236061694,573.5385220675731,237.61074913334795,null,9,1107.7867314922667,244.2411076962161,0.220476650200717]
[1725,2536,1401.0153281519886,1314.4204029885475,836.9546142351127,346.7411607543021,null,10,315.2928726317686,139.45377119620287,0.44229915517015606]
[1889,1985.5412496208717,1273.947824519127,1195.2067755743758,761.0455707379646,315.2928726317686]
[]
[{"$nulls":7},"Tipo de interés (tanto por uno):",null,0.003]
[{"$nulls":7},"% P.E. (tanto por uno):",null,0.25]
[]
[{"$nulls":7},"Valor Actual IBNR:"]
[{"$nulls":7},11914.39870610769]
[{"$nulls":7},"Valor Actual IBNR + 25% P.E.:"]
[{"$nulls":7},12295.483920152768]

{"sheet":"Bootstrap 1","index":3,"n_rows":8,"n_cols":11,"rows_kept":8}
["Rectángulo de desarrollo",{"$nulls":6},"Años de origen","IBNR","P.E.","C.V."]
[1001,854,568,565,347,148,null,0,0,0,"-"]
[1113,990,671,648,422,170.58830584707678,null,1,170.58830584707653,87.43775308158604,0.5125659267638745]
[1265,1168,800,744,477.1159126365057,197.66391456377946,null,2,674.7798272002851,158.29008659970413,0.23458034786911489]
[1490,1383,1007,900.7307236061694,573.5385220675731,237.61074913334795,null,3,1711.8799948070905,272.27255407282166,0.15904885558494053]
[1725,2536,1401.0153281519886,1314.4204029885475,836.9546142351127,346.7411607543021,null,4,3899.1315061299483,484.3378406948597,0.12421685186391299]
[1889,1985.5412496208717,1273.947824519127,1195.2067755743758,761.0455707379646,315.2928726317686,null,5,5531.0342930841,721.7794537659787,0.13049628975695884]
[{"$nulls":7},"PT Total",11987.413927068501,1199.1793469069196,0.10003653450216486]

{"sheet":"Bootstrap 2","index":4,"n_rows":17,"n_cols":12,"rows_kept":17}
["Rectángulo de desarrollo",{"$nulls":6},"Años de calendario","IBNR","P.E.","C.V.","VaR"]
[1001,854,568,565,347,148,null,6,4934.991519862609,445.4456052625163,0.09026268909878848,4683.8315614131025]
[1113,990,671,648,422,170.58830584707678,null,7,3359.570664139024,384.2386613893339,0.11437135866520162,4863.288709359965]
[1265,1168,800,744,477.1159126365057,197.66391456377946,null,8,2269.7721389428343,340.16144498065984,0.14986590025688346,4917.1258537440235]
[1490,1383,1007,900.7307236061694,573.5385220675731,237.61074913334795,null,9,1107.786731492266,251.024080574363,0.22659964543555786,5024.800142512141]
[1725,2536,1401.0153281519886,1314.4204029885475,836.9546142351127,346.7411607543021,null,10,315.29287263176764,139.54874822193858,0.4426003894636666,5114.528716485572]
[1889,1985.5412496208717,1273.947824519127,1195.2067755743758,761.0455707379646,315.2928726317686]
[]
[{"$nulls":7},"Tipo de interés (tanto por uno):",null,0.003]
[{"$nulls":7},"% P.E. (tanto por uno):",null,0.25]
[]
[{"$nulls":7},"Valor Actual IBNR:"]
[{"$nulls":7},11914.398706107679]
[{"$nulls":7},"Valor Actual IBNR + 25% P.E.:"]
[{"$nulls":7},12301.569598900956]
[{"$nulls":7},"Valor Actual VaR al 75%:"]
[{"$nulls":7},24380.64629826475]