{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["delningstal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"delningstal","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,3,5],[7,4,8,6],[8,0,10,0]]}
[]
[null,"Uträkningen av premiepensionens delningstal. Uträkningen beskrivs närmare i Orange rapport "]
[]
[]
[]
[]
[null,"Födelsedatum","1960-01-01"]
[null,"Datum för pensionering/omräkning","2022-01-01",null,"Celler med orange färg innehåller input till beräkningarna"]
[null,"Pensionsålder/ålder vid omräkning",{"$f":"dur(C7,datum_pensionering)","v":62},"år"]
[null,"Födelseår",{"$f":"YEAR(C7)","v":1960}]
[null,"Kohort makehamparametrar",{"$f":"IF(C10<=1939,1930,IF(C10>=1950,IF(C10>=1960,IF(C10>=1970,1970,1960),1950),1940))","v":1960}]
[null,"Förskottsränta",1.7500000000000002E-2]
[null,"Tid till uttag i månader",0,"månader"]
[]
[null,"Dödlighets- och ränteparametrar för alla kohorter"]
[null,"PRADCM","A","B","C","K","W","EPSMY","R","EPSDKO"]
[null,1930,2.0060000000000001E-2,2.8850000000000002E-7,0.14349999999999999,0.04,97,0.1,0,1E-3]
[null,1940,2.186E-3,8.2210000000000004E-7,0.13270000000000001,0.04,97,0.1,0,1E-3]
[null,1950,4.7609999999999996E-3,2.2450000000000001E-7,0.1457,0.04,97,0.1,0,1E-3]
[null,1960,4.3639999999999998E-3,8.6939999999999996E-8,0.15509999999999999,0.04,97,0.1,0,1E-3]
[null,1970,3.9680000000000002E-3,3.428E-8,0.1643,0.04,97,0.1,0,1E-3]
[]
[null,"Makeham- och ränteparametrar för aktuell kohort"]
[null,"Kohort","A","B","C","K","W","EPSMY","R","EPSDKO"]
[null,{"$f":"C11","v":1960},{"$f":"SUMPRODUCT(($B25=$B$17:$B$21)*(C$24=$C$16:$L$16)*($C$17:$L$21))","v":4.3639999999999998E-3},8.6939999999999996E-8,0.15509999999999999,0.04,97,0.1,{"$f":"C12","v":1.7500000000000002E-2},{"$f":"SUMPRODUCT(($B25=$B$17:$B$21)*(J$24=$C$16:$L$16)*($C$17:$L$21))","v":1E-3}]
[]
[null,"Delningstal utan efterlevandeskydd",{"$f":"n1x(pensionsålder,a_makeham,b_makeham,c_makeham,w_makeham,k_makeham,belastn_dödlighet,förskottsränta,driftavdrag,0)/d1x(pensionsålder-tid_till_uttag/12,a_makeham,b_makeham,c_makeham,w_makeham,k_makeham,belastn_dödlighet,förskottsränta,driftavdrag,0)","v":21.037277560048242}]