{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["CW-berekening","Output","VAV-uitgebreid","Sterftetabel Man","Sterftetabel Vrouw","Blad2","Blad3","Blad1","Blad4"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":4,"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":"CW-berekening","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,4,21,5]]}
[]
[]
[null,null,"Contante waarde berekening"]
[]
[null,null,"Dossiernr."]
[null,null,"Geboortedatum"]
[null,null,"Geslacht"]
[]
[null,null,"Startjaar*",null,"Startdatum",{"$f":"DATE(D9,1,1)","v":"1900-01-01"}]
[null,null,"Kapitalisatiejaar*"]
[]
[null,null,"Jaarlijkse schade"]
[null,null,"Duur schade*",null,"Einddatum",{"$f":"DATE(D9+D13,1,1)","v":"1900-01-01"}]
[]
[]
[null,null,"Rendement"]
[]
[]
[null,null,"Inflatie"]
[]
[]
[null,null,"Sterftekanscorrectie",null,{"$f":"IF(D22=\"ja\",\"GBM/GBV 2012-2017\",\"\")","v":""}]
[]
[null,null,"Fiscale schade berekenen"]
[null,null,"Vrijstelling","Ja, enkele vrijstelling (€30.360)"]
[]
[null,null,"Contante waarde",{"$f":"IF(D22=\"ja\",'VAV-uitgebreid'!AA123,'VAV-uitgebreid'!AB123)","v":0}]
[null,null,"Fiscale schade",{"$f":"IF(D24=\"ja\",'VAV-uitgebreid'!BD123,\"nvt\")","v":"nvt"}]
[null,null,"Totaal",{"$f":"IF(D24=\"ja\",D27+D28,D27)","v":0}]
[]
[null,null,"* Als datum wordt 1 januari gehanteerd"]

{"sheet":"Output","index":1,"n_rows":97,"n_cols":19,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contante waarde"]
[null,null,null,null,null,null,null,null,"Dossiernr.",null,{"$f":"'CW-berekening'!D5","v":0}]
[]
[]
[null,"Dossiernr.",{"$f":"'CW-berekening'!D5","v":0},null,null,null,null,null,"Jaar","Jaarschade","Sterftekans","Rendement","Inflatie","Contante waarde schade","Vermogen \nbegin","Vermogen \neinde","Opname schade","Fiscale schade","Rendement"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B33),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G33","v":" "},{"$f":"IF(I7=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M33,1))","v":""},{"$f":"IF(I7=\"\", \"\",'VAV-uitgebreid'!Q33)","v":""},{"$f":"IF(I7=\"\", \"\",'VAV-uitgebreid'!N33)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA33,'VAV-uitgebreid'!AB33)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD33=0,\"\", 'VAV-uitgebreid'!AD33)","v":" "},{"$f":"'VAV-uitgebreid'!AG33","v":" "},{"$f":"IF('VAV-uitgebreid'!AE33=0,\"\",'VAV-uitgebreid'!AE33)","v":""},{"$f":"'VAV-uitgebreid'!BD33","v":" "},{"$f":"'VAV-uitgebreid'!AF33","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B34),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G34","v":" "},{"$f":"IF(I8=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M34,1))","v":""},{"$f":"IF(I8=\"\", \"\",'VAV-uitgebreid'!Q34)","v":""},{"$f":"IF(I8=\"\", \"\",'VAV-uitgebreid'!N34)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA34,'VAV-uitgebreid'!AB34)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD34=0,\"\", 'VAV-uitgebreid'!AD34)","v":" "},{"$f":"'VAV-uitgebreid'!AG34","v":" "},{"$f":"IF('VAV-uitgebreid'!AE34=0,\"\",'VAV-uitgebreid'!AE34)","v":""},{"$f":"'VAV-uitgebreid'!BD34","v":" "},{"$f":"'VAV-uitgebreid'!AF34","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B35),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G35","v":" "},{"$f":"IF(I9=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M35,1))","v":""},{"$f":"IF(I9=\"\", \"\",'VAV-uitgebreid'!Q35)","v":""},{"$f":"IF(I9=\"\", \"\",'VAV-uitgebreid'!N35)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA35,'VAV-uitgebreid'!AB35)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD35=0,\"\", 'VAV-uitgebreid'!AD35)","v":" "},{"$f":"'VAV-uitgebreid'!AG35","v":" "},{"$f":"IF('VAV-uitgebreid'!AE35=0,\"\",'VAV-uitgebreid'!AE35)","v":""},{"$f":"'VAV-uitgebreid'!BD35","v":" "},{"$f":"'VAV-uitgebreid'!AF35","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B36),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G36","v":" "},{"$f":"IF(I10=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M36,1))","v":""},{"$f":"IF(I10=\"\", \"\",'VAV-uitgebreid'!Q36)","v":""},{"$f":"IF(I10=\"\", \"\",'VAV-uitgebreid'!N36)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA36,'VAV-uitgebreid'!AB36)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD36=0,\"\", 'VAV-uitgebreid'!AD36)","v":" "},{"$f":"'VAV-uitgebreid'!AG36","v":" "},{"$f":"IF('VAV-uitgebreid'!AE36=0,\"\",'VAV-uitgebreid'!AE36)","v":""},{"$f":"'VAV-uitgebreid'!BD36","v":" "},{"$f":"'VAV-uitgebreid'!AF36","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B37),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G37","v":" "},{"$f":"IF(I11=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M37,1))","v":""},{"$f":"IF(I11=\"\", \"\",'VAV-uitgebreid'!Q37)","v":""},{"$f":"IF(I11=\"\", \"\",'VAV-uitgebreid'!N37)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA37,'VAV-uitgebreid'!AB37)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD37=0,\"\", 'VAV-uitgebreid'!AD37)","v":" "},{"$f":"'VAV-uitgebreid'!AG37","v":" "},{"$f":"IF('VAV-uitgebreid'!AE37=0,\"\",'VAV-uitgebreid'!AE37)","v":""},{"$f":"'VAV-uitgebreid'!BD37","v":" "},{"$f":"'VAV-uitgebreid'!AF37","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B38),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G38","v":" "},{"$f":"IF(I12=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M38,1))","v":""},{"$f":"IF(I12=\"\", \"\",'VAV-uitgebreid'!Q38)","v":""},{"$f":"IF(I12=\"\", \"\",'VAV-uitgebreid'!N38)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA38,'VAV-uitgebreid'!AB38)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD38=0,\"\", 'VAV-uitgebreid'!AD38)","v":" "},{"$f":"'VAV-uitgebreid'!AG38","v":" "},{"$f":"IF('VAV-uitgebreid'!AE38=0,\"\",'VAV-uitgebreid'!AE38)","v":""},{"$f":"'VAV-uitgebreid'!BD38","v":" "},{"$f":"'VAV-uitgebreid'!AF38","v":" "}]
[null,"Uitgangspunten",null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B39),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G39","v":" "},{"$f":"IF(I13=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M39,1))","v":""},{"$f":"IF(I13=\"\", \"\",'VAV-uitgebreid'!Q39)","v":""},{"$f":"IF(I13=\"\", \"\",'VAV-uitgebreid'!N39)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA39,'VAV-uitgebreid'!AB39)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD39=0,\"\", 'VAV-uitgebreid'!AD39)","v":" "},{"$f":"'VAV-uitgebreid'!AG39","v":" "},{"$f":"IF('VAV-uitgebreid'!AE39=0,\"\",'VAV-uitgebreid'!AE39)","v":""},{"$f":"'VAV-uitgebreid'!BD39","v":" "},{"$f":"'VAV-uitgebreid'!AF39","v":" "}]
[null,"Geboortedatum",{"$f":"'CW-berekening'!D6","v":"00:00:00"},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B40),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G40","v":" "},{"$f":"IF(I14=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M40,1))","v":""},{"$f":"IF(I14=\"\", \"\",'VAV-uitgebreid'!Q40)","v":""},{"$f":"IF(I14=\"\", \"\",'VAV-uitgebreid'!N40)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA40,'VAV-uitgebreid'!AB40)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD40=0,\"\", 'VAV-uitgebreid'!AD40)","v":" "},{"$f":"'VAV-uitgebreid'!AG40","v":" "},{"$f":"IF('VAV-uitgebreid'!AE40=0,\"\",'VAV-uitgebreid'!AE40)","v":""},{"$f":"'VAV-uitgebreid'!BD40","v":" "},{"$f":"'VAV-uitgebreid'!AF40","v":" "}]
[null,"Geslacht",{"$f":"'CW-berekening'!D7","v":0},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B41),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G41","v":" "},{"$f":"IF(I15=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M41,1))","v":""},{"$f":"IF(I15=\"\", \"\",'VAV-uitgebreid'!Q41)","v":""},{"$f":"IF(I15=\"\", \"\",'VAV-uitgebreid'!N41)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA41,'VAV-uitgebreid'!AB41)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD41=0,\"\", 'VAV-uitgebreid'!AD41)","v":" "},{"$f":"'VAV-uitgebreid'!AG41","v":" "},{"$f":"IF('VAV-uitgebreid'!AE41=0,\"\",'VAV-uitgebreid'!AE41)","v":""},{"$f":"'VAV-uitgebreid'!BD41","v":" "},{"$f":"'VAV-uitgebreid'!AF41","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B42),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G42","v":" "},{"$f":"IF(I16=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M42,1))","v":""},{"$f":"IF(I16=\"\", \"\",'VAV-uitgebreid'!Q42)","v":""},{"$f":"IF(I16=\"\", \"\",'VAV-uitgebreid'!N42)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA42,'VAV-uitgebreid'!AB42)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD42=0,\"\", 'VAV-uitgebreid'!AD42)","v":""},{"$f":"'VAV-uitgebreid'!AG42","v":" "},{"$f":"IF('VAV-uitgebreid'!AE42=0,\"\",'VAV-uitgebreid'!AE42)","v":""},{"$f":"'VAV-uitgebreid'!BD42","v":" "},{"$f":"'VAV-uitgebreid'!AF42","v":" "}]
[null,"Jaarschade",null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B43),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G43","v":" "},{"$f":"IF(I17=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M43,1))","v":""},{"$f":"IF(I17=\"\", \"\",'VAV-uitgebreid'!Q43)","v":""},{"$f":"IF(I17=\"\", \"\",'VAV-uitgebreid'!N43)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA43,'VAV-uitgebreid'!AB43)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD43=0,\"\", 'VAV-uitgebreid'!AD43)","v":""},{"$f":"'VAV-uitgebreid'!AG43","v":" "},{"$f":"IF('VAV-uitgebreid'!AE43=0,\"\",'VAV-uitgebreid'!AE43)","v":""},{"$f":"'VAV-uitgebreid'!BD43","v":" "},{"$f":"'VAV-uitgebreid'!AF43","v":" "}]
[null,null,"Bedrag",null,"Van",null,"Tot",null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B44),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G44","v":" "},{"$f":"IF(I18=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M44,1))","v":""},{"$f":"IF(I18=\"\", \"\",'VAV-uitgebreid'!Q44)","v":""},{"$f":"IF(I18=\"\", \"\",'VAV-uitgebreid'!N44)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA44,'VAV-uitgebreid'!AB44)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD44=0,\"\", 'VAV-uitgebreid'!AD44)","v":""},{"$f":"'VAV-uitgebreid'!AG44","v":" "},{"$f":"IF('VAV-uitgebreid'!AE44=0,\"\",'VAV-uitgebreid'!AE44)","v":""},{"$f":"'VAV-uitgebreid'!BD44","v":" "},{"$f":"'VAV-uitgebreid'!AF44","v":" "}]
[null,null,{"$f":"'CW-berekening'!D12","v":0},null,{"$f":"DATE('CW-berekening'!D9,1,1)","v":"1900-01-01"},null,{"$f":"DATE(('CW-berekening'!D9)+('CW-berekening'!D13),1,1)","v":"1900-01-01"},null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B45),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G45","v":" "},{"$f":"IF(I19=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M45,1))","v":""},{"$f":"IF(I19=\"\", \"\",'VAV-uitgebreid'!Q45)","v":""},{"$f":"IF(I19=\"\", \"\",'VAV-uitgebreid'!N45)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA45,'VAV-uitgebreid'!AB45)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD45=0,\"\", 'VAV-uitgebreid'!AD45)","v":""},{"$f":"'VAV-uitgebreid'!AG45","v":" "},{"$f":"IF('VAV-uitgebreid'!AE45=0,\"\",'VAV-uitgebreid'!AE45)","v":""},{"$f":"'VAV-uitgebreid'!BD45","v":" "},{"$f":"'VAV-uitgebreid'!AF45","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B46),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G46","v":" "},{"$f":"IF(I20=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M46,1))","v":""},{"$f":"IF(I20=\"\", \"\",'VAV-uitgebreid'!Q46)","v":""},{"$f":"IF(I20=\"\", \"\",'VAV-uitgebreid'!N46)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA46,'VAV-uitgebreid'!AB46)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD46=0,\"\", 'VAV-uitgebreid'!AD46)","v":""},{"$f":"'VAV-uitgebreid'!AG46","v":" "},{"$f":"IF('VAV-uitgebreid'!AE46=0,\"\",'VAV-uitgebreid'!AE46)","v":""},{"$f":"'VAV-uitgebreid'!BD46","v":" "},{"$f":"'VAV-uitgebreid'!AF46","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B47),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G47","v":" "},{"$f":"IF(I21=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M47,1))","v":""},{"$f":"IF(I21=\"\", \"\",'VAV-uitgebreid'!Q47)","v":""},{"$f":"IF(I21=\"\", \"\",'VAV-uitgebreid'!N47)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA47,'VAV-uitgebreid'!AB47)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD47=0,\"\", 'VAV-uitgebreid'!AD47)","v":""},{"$f":"'VAV-uitgebreid'!AG47","v":" "},{"$f":"IF('VAV-uitgebreid'!AE47=0,\"\",'VAV-uitgebreid'!AE47)","v":""},{"$f":"'VAV-uitgebreid'!BD47","v":" "},{"$f":"'VAV-uitgebreid'!AF47","v":" "}]
[null,"Kapitalisatiedatum",{"$f":"DATE('CW-berekening'!D10,1,1)","v":"1900-01-01"},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B48),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G48","v":" "},{"$f":"IF(I22=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M48,1))","v":""},{"$f":"IF(I22=\"\", \"\",'VAV-uitgebreid'!Q48)","v":""},{"$f":"IF(I22=\"\", \"\",'VAV-uitgebreid'!N48)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA48,'VAV-uitgebreid'!AB48)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD48=0,\"\", 'VAV-uitgebreid'!AD48)","v":""},{"$f":"'VAV-uitgebreid'!AG48","v":" "},{"$f":"IF('VAV-uitgebreid'!AE48=0,\"\",'VAV-uitgebreid'!AE48)","v":""},{"$f":"'VAV-uitgebreid'!BD48","v":" "},{"$f":"'VAV-uitgebreid'!AF48","v":" "}]
[null,null,null,null,"Van",null,"Tot",null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B49),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G49","v":" "},{"$f":"IF(I23=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M49,1))","v":""},{"$f":"IF(I23=\"\", \"\",'VAV-uitgebreid'!Q49)","v":""},{"$f":"IF(I23=\"\", \"\",'VAV-uitgebreid'!N49)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA49,'VAV-uitgebreid'!AB49)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD49=0,\"\", 'VAV-uitgebreid'!AD49)","v":""},{"$f":"'VAV-uitgebreid'!AG49","v":" "},{"$f":"IF('VAV-uitgebreid'!AE49=0,\"\",'VAV-uitgebreid'!AE49)","v":""},{"$f":"'VAV-uitgebreid'!BD49","v":" "},{"$f":"'VAV-uitgebreid'!AF49","v":" "}]
[null,"Rendement",{"$f":"'CW-berekening'!D16","v":0},null,{"$f":"C22","v":"1900-01-01"},null,{"$f":"G19","v":"1900-01-01"},null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B50),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G50","v":" "},{"$f":"IF(I24=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M50,1))","v":""},{"$f":"IF(I24=\"\", \"\",'VAV-uitgebreid'!Q50)","v":""},{"$f":"IF(I24=\"\", \"\",'VAV-uitgebreid'!N50)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA50,'VAV-uitgebreid'!AB50)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD50=0,\"\", 'VAV-uitgebreid'!AD50)","v":""},{"$f":"'VAV-uitgebreid'!AG50","v":" "},{"$f":"IF('VAV-uitgebreid'!AE50=0,\"\",'VAV-uitgebreid'!AE50)","v":""},{"$f":"'VAV-uitgebreid'!BD50","v":" "},{"$f":"'VAV-uitgebreid'!AF50","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B51),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G51","v":" "},{"$f":"IF(I25=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M51,1))","v":""},{"$f":"IF(I25=\"\", \"\",'VAV-uitgebreid'!Q51)","v":""},{"$f":"IF(I25=\"\", \"\",'VAV-uitgebreid'!N51)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA51,'VAV-uitgebreid'!AB51)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD51=0,\"\", 'VAV-uitgebreid'!AD51)","v":""},{"$f":"'VAV-uitgebreid'!AG51","v":" "},{"$f":"IF('VAV-uitgebreid'!AE51=0,\"\",'VAV-uitgebreid'!AE51)","v":""},{"$f":"'VAV-uitgebreid'!BD51","v":" "},{"$f":"'VAV-uitgebreid'!AF51","v":" "}]
[null,"Inflatie",{"$f":"'CW-berekening'!D19","v":0},null,{"$f":"C22","v":"1900-01-01"},null,{"$f":"G19","v":"1900-01-01"},null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B52),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G52","v":" "},{"$f":"IF(I26=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M52,1))","v":""},{"$f":"IF(I26=\"\", \"\",'VAV-uitgebreid'!Q52)","v":""},{"$f":"IF(I26=\"\", \"\",'VAV-uitgebreid'!N52)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA52,'VAV-uitgebreid'!AB52)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD52=0,\"\", 'VAV-uitgebreid'!AD52)","v":""},{"$f":"'VAV-uitgebreid'!AG52","v":" "},{"$f":"IF('VAV-uitgebreid'!AE52=0,\"\",'VAV-uitgebreid'!AE52)","v":""},{"$f":"'VAV-uitgebreid'!BD52","v":" "},{"$f":"'VAV-uitgebreid'!AF52","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B53),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G53","v":" "},{"$f":"IF(I27=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M53,1))","v":""},{"$f":"IF(I27=\"\", \"\",'VAV-uitgebreid'!Q53)","v":""},{"$f":"IF(I27=\"\", \"\",'VAV-uitgebreid'!N53)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA53,'VAV-uitgebreid'!AB53)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD53=0,\"\", 'VAV-uitgebreid'!AD53)","v":""},{"$f":"'VAV-uitgebreid'!AG53","v":" "},{"$f":"IF('VAV-uitgebreid'!AE53=0,\"\",'VAV-uitgebreid'!AE53)","v":""},{"$f":"'VAV-uitgebreid'!BD53","v":" "},{"$f":"'VAV-uitgebreid'!AF53","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B54),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G54","v":" "},{"$f":"IF(I28=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M54,1))","v":""},{"$f":"IF(I28=\"\", \"\",'VAV-uitgebreid'!Q54)","v":""},{"$f":"IF(I28=\"\", \"\",'VAV-uitgebreid'!N54)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA54,'VAV-uitgebreid'!AB54)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD54=0,\"\", 'VAV-uitgebreid'!AD54)","v":""},{"$f":"'VAV-uitgebreid'!AG54","v":" "},{"$f":"IF('VAV-uitgebreid'!AE54=0,\"\",'VAV-uitgebreid'!AE54)","v":""},{"$f":"'VAV-uitgebreid'!BD54","v":" "},{"$f":"'VAV-uitgebreid'!AF54","v":" "}]
[null,"Sterftekanscorrectie",{"$f":"'CW-berekening'!D22","v":0},null,{"$f":"IF(C29=\"ja\",\"GBM/GBV 2012-2017\",\"\")","v":""},null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B55),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G55","v":" "},{"$f":"IF(I29=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M55,1))","v":""},{"$f":"IF(I29=\"\", \"\",'VAV-uitgebreid'!Q55)","v":""},{"$f":"IF(I29=\"\", \"\",'VAV-uitgebreid'!N55)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA55,'VAV-uitgebreid'!AB55)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD55=0,\"\", 'VAV-uitgebreid'!AD55)","v":""},{"$f":"'VAV-uitgebreid'!AG55","v":" "},{"$f":"IF('VAV-uitgebreid'!AE55=0,\"\",'VAV-uitgebreid'!AE55)","v":""},{"$f":"'VAV-uitgebreid'!BD55","v":" "},{"$f":"'VAV-uitgebreid'!AF55","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B56),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G56","v":" "},{"$f":"IF(I30=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M56,1))","v":""},{"$f":"IF(I30=\"\", \"\",'VAV-uitgebreid'!Q56)","v":""},{"$f":"IF(I30=\"\", \"\",'VAV-uitgebreid'!N56)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA56,'VAV-uitgebreid'!AB56)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD56=0,\"\", 'VAV-uitgebreid'!AD56)","v":""},{"$f":"'VAV-uitgebreid'!AG56","v":" "},{"$f":"IF('VAV-uitgebreid'!AE56=0,\"\",'VAV-uitgebreid'!AE56)","v":""},{"$f":"'VAV-uitgebreid'!BD56","v":" "},{"$f":"'VAV-uitgebreid'!AF56","v":" "}]
[null,"Belastingschade",{"$f":"'CW-berekening'!D24","v":0},null,{"$f":"IF(C31=\"ja\",\"Fiscale cijfers 2019\",\"\")","v":""},null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B57),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G57","v":" "},{"$f":"IF(I31=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M57,1))","v":""},{"$f":"IF(I31=\"\", \"\",'VAV-uitgebreid'!Q57)","v":""},{"$f":"IF(I31=\"\", \"\",'VAV-uitgebreid'!N57)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA57,'VAV-uitgebreid'!AB57)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD57=0,\"\", 'VAV-uitgebreid'!AD57)","v":""},{"$f":"'VAV-uitgebreid'!AG57","v":" "},{"$f":"IF('VAV-uitgebreid'!AE57=0,\"\",'VAV-uitgebreid'!AE57)","v":""},{"$f":"'VAV-uitgebreid'!BD57","v":" "},{"$f":"'VAV-uitgebreid'!AF57","v":" "}]
[null,"Vrijstelling",{"$f":"'CW-berekening'!D25","v":"Ja, enkele vrijstelling (€30.360)"},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B58),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G58","v":" "},{"$f":"IF(I32=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M58,1))","v":""},{"$f":"IF(I32=\"\", \"\",'VAV-uitgebreid'!Q58)","v":""},{"$f":"IF(I32=\"\", \"\",'VAV-uitgebreid'!N58)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA58,'VAV-uitgebreid'!AB58)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD58=0,\"\", 'VAV-uitgebreid'!AD58)","v":""},{"$f":"'VAV-uitgebreid'!AG58","v":" "},{"$f":"IF('VAV-uitgebreid'!AE58=0,\"\",'VAV-uitgebreid'!AE58)","v":""},{"$f":"'VAV-uitgebreid'!BD58","v":" "},{"$f":"'VAV-uitgebreid'!AF58","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B59),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G59","v":" "},{"$f":"IF(I33=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M59,1))","v":""},{"$f":"IF(I33=\"\", \"\",'VAV-uitgebreid'!Q59)","v":""},{"$f":"IF(I33=\"\", \"\",'VAV-uitgebreid'!N59)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA59,'VAV-uitgebreid'!AB59)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD59=0,\"\", 'VAV-uitgebreid'!AD59)","v":""},{"$f":"'VAV-uitgebreid'!AG59","v":" "},{"$f":"IF('VAV-uitgebreid'!AE59=0,\"\",'VAV-uitgebreid'!AE59)","v":""},{"$f":"'VAV-uitgebreid'!BD59","v":" "},{"$f":"'VAV-uitgebreid'!AF59","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B60),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G60","v":" "},{"$f":"IF(I34=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M60,1))","v":""},{"$f":"IF(I34=\"\", \"\",'VAV-uitgebreid'!Q60)","v":""},{"$f":"IF(I34=\"\", \"\",'VAV-uitgebreid'!N60)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA60,'VAV-uitgebreid'!AB60)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD60=0,\"\", 'VAV-uitgebreid'!AD60)","v":""},{"$f":"'VAV-uitgebreid'!AG60","v":" "},{"$f":"IF('VAV-uitgebreid'!AE60=0,\"\",'VAV-uitgebreid'!AE60)","v":""},{"$f":"'VAV-uitgebreid'!BD60","v":" "},{"$f":"'VAV-uitgebreid'!AF60","v":" "}]
[null,"Resultaat",null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B61),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G61","v":" "},{"$f":"IF(I35=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M61,1))","v":""},{"$f":"IF(I35=\"\", \"\",'VAV-uitgebreid'!Q61)","v":""},{"$f":"IF(I35=\"\", \"\",'VAV-uitgebreid'!N61)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA61,'VAV-uitgebreid'!AB61)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD61=0,\"\", 'VAV-uitgebreid'!AD61)","v":""},{"$f":"'VAV-uitgebreid'!AG61","v":" "},{"$f":"IF('VAV-uitgebreid'!AE61=0,\"\",'VAV-uitgebreid'!AE61)","v":""},{"$f":"'VAV-uitgebreid'!BD61","v":" "},{"$f":"'VAV-uitgebreid'!AF61","v":" "}]
[null,"Verschenen schade",{"$f":"'VAV-uitgebreid'!D4","v":0},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B62),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G62","v":" "},{"$f":"IF(I36=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M62,1))","v":""},{"$f":"IF(I36=\"\", \"\",'VAV-uitgebreid'!Q62)","v":""},{"$f":"IF(I36=\"\", \"\",'VAV-uitgebreid'!N62)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA62,'VAV-uitgebreid'!AB62)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD62=0,\"\", 'VAV-uitgebreid'!AD62)","v":""},{"$f":"'VAV-uitgebreid'!AG62","v":" "},{"$f":"IF('VAV-uitgebreid'!AE62=0,\"\",'VAV-uitgebreid'!AE62)","v":""},{"$f":"'VAV-uitgebreid'!BD62","v":" "},{"$f":"'VAV-uitgebreid'!AF62","v":" "}]
[null,"Toekomstige schade",{"$f":"('CW-berekening'!D27)-C36","v":0},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B63),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G63","v":" "},{"$f":"IF(I37=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M63,1))","v":""},{"$f":"IF(I37=\"\", \"\",'VAV-uitgebreid'!Q63)","v":""},{"$f":"IF(I37=\"\", \"\",'VAV-uitgebreid'!N63)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA63,'VAV-uitgebreid'!AB63)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD63=0,\"\", 'VAV-uitgebreid'!AD63)","v":""},{"$f":"'VAV-uitgebreid'!AG63","v":" "},{"$f":"IF('VAV-uitgebreid'!AE63=0,\"\",'VAV-uitgebreid'!AE63)","v":""},{"$f":"'VAV-uitgebreid'!BD63","v":" "},{"$f":"'VAV-uitgebreid'!AF63","v":" "}]
[null,"Fiscale schade ",{"$f":"'CW-berekening'!D28","v":"nvt"},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B64),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G64","v":" "},{"$f":"IF(I38=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M64,1))","v":""},{"$f":"IF(I38=\"\", \"\",'VAV-uitgebreid'!Q64)","v":""},{"$f":"IF(I38=\"\", \"\",'VAV-uitgebreid'!N64)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA64,'VAV-uitgebreid'!AB64)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD64=0,\"\", 'VAV-uitgebreid'!AD64)","v":""},{"$f":"'VAV-uitgebreid'!AG64","v":" "},{"$f":"IF('VAV-uitgebreid'!AE64=0,\"\",'VAV-uitgebreid'!AE64)","v":""},{"$f":"'VAV-uitgebreid'!BD64","v":" "},{"$f":"'VAV-uitgebreid'!AF64","v":" "}]
[null,"Totale schade",{"$f":"SUM(C36:C38)","v":0},null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B65),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G65","v":" "},{"$f":"IF(I39=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M65,1))","v":""},{"$f":"IF(I39=\"\", \"\",'VAV-uitgebreid'!Q65)","v":""},{"$f":"IF(I39=\"\", \"\",'VAV-uitgebreid'!N65)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA65,'VAV-uitgebreid'!AB65)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD65=0,\"\", 'VAV-uitgebreid'!AD65)","v":""},{"$f":"'VAV-uitgebreid'!AG65","v":" "},{"$f":"IF('VAV-uitgebreid'!AE65=0,\"\",'VAV-uitgebreid'!AE65)","v":""},{"$f":"'VAV-uitgebreid'!BD65","v":" "},{"$f":"'VAV-uitgebreid'!AF65","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B66),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G66","v":" "},{"$f":"IF(I40=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M66,1))","v":""},{"$f":"IF(I40=\"\", \"\",'VAV-uitgebreid'!Q66)","v":""},{"$f":"IF(I40=\"\", \"\",'VAV-uitgebreid'!N66)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA66,'VAV-uitgebreid'!AB66)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD66=0,\"\", 'VAV-uitgebreid'!AD66)","v":""},{"$f":"'VAV-uitgebreid'!AG66","v":" "},{"$f":"IF('VAV-uitgebreid'!AE66=0,\"\",'VAV-uitgebreid'!AE66)","v":""},{"$f":"'VAV-uitgebreid'!BD66","v":" "},{"$f":"'VAV-uitgebreid'!AF66","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B67),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G67","v":" "},{"$f":"IF(I41=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M67,1))","v":""},{"$f":"IF(I41=\"\", \"\",'VAV-uitgebreid'!Q67)","v":""},{"$f":"IF(I41=\"\", \"\",'VAV-uitgebreid'!N67)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA67,'VAV-uitgebreid'!AB67)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD67=0,\"\", 'VAV-uitgebreid'!AD67)","v":""},{"$f":"'VAV-uitgebreid'!AG67","v":" "},{"$f":"IF('VAV-uitgebreid'!AE67=0,\"\",'VAV-uitgebreid'!AE67)","v":""},{"$f":"'VAV-uitgebreid'!BD67","v":" "},{"$f":"'VAV-uitgebreid'!AF67","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B68),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G68","v":" "},{"$f":"IF(I42=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M68,1))","v":""},{"$f":"IF(I42=\"\", \"\",'VAV-uitgebreid'!Q68)","v":""},{"$f":"IF(I42=\"\", \"\",'VAV-uitgebreid'!N68)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA68,'VAV-uitgebreid'!AB68)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD68=0,\"\", 'VAV-uitgebreid'!AD68)","v":""},{"$f":"'VAV-uitgebreid'!AG68","v":" "},{"$f":"IF('VAV-uitgebreid'!AE68=0,\"\",'VAV-uitgebreid'!AE68)","v":""},{"$f":"'VAV-uitgebreid'!BD68","v":" "},{"$f":"'VAV-uitgebreid'!AF68","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B69),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G69","v":" "},{"$f":"IF(I43=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M69,1))","v":""},{"$f":"IF(I43=\"\", \"\",'VAV-uitgebreid'!Q69)","v":""},{"$f":"IF(I43=\"\", \"\",'VAV-uitgebreid'!N69)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA69,'VAV-uitgebreid'!AB69)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD69=0,\"\", 'VAV-uitgebreid'!AD69)","v":""},{"$f":"'VAV-uitgebreid'!AG69","v":" "},{"$f":"IF('VAV-uitgebreid'!AE69=0,\"\",'VAV-uitgebreid'!AE69)","v":""},{"$f":"'VAV-uitgebreid'!BD69","v":" "},{"$f":"'VAV-uitgebreid'!AF69","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B70),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G70","v":" "},{"$f":"IF(I44=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M70,1))","v":""},{"$f":"IF(I44=\"\", \"\",'VAV-uitgebreid'!Q70)","v":""},{"$f":"IF(I44=\"\", \"\",'VAV-uitgebreid'!N70)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA70,'VAV-uitgebreid'!AB70)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD70=0,\"\", 'VAV-uitgebreid'!AD70)","v":""},{"$f":"'VAV-uitgebreid'!AG70","v":" "},{"$f":"IF('VAV-uitgebreid'!AE70=0,\"\",'VAV-uitgebreid'!AE70)","v":""},{"$f":"'VAV-uitgebreid'!BD70","v":" "},{"$f":"'VAV-uitgebreid'!AF70","v":" "}]
[null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,"Aan deze berekening kunnen geen rechten ontleend worden. Sedgwick aanvaardt daarom"]
[null,null,null,null,null,null,null,null,"geen enkele aansprakelijkheid bij het gebruik van deze rekenmodule. "]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B71),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G71","v":" "},{"$f":"IF(I50=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M71,1))","v":""},{"$f":"IF(I50=\"\", \"\",'VAV-uitgebreid'!Q71)","v":""},{"$f":"IF(I50=\"\", \"\",'VAV-uitgebreid'!N71)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA71,'VAV-uitgebreid'!AB71)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD71=0,\"\", 'VAV-uitgebreid'!AD71)","v":""},{"$f":"'VAV-uitgebreid'!AG71","v":" "},{"$f":"IF('VAV-uitgebreid'!AE71=0,\"\",'VAV-uitgebreid'!AE71)","v":""},{"$f":"'VAV-uitgebreid'!BD71","v":" "},{"$f":"'VAV-uitgebreid'!AF71","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B72),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G72","v":" "},{"$f":"IF(I51=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M72,1))","v":""},{"$f":"IF(I51=\"\", \"\",'VAV-uitgebreid'!Q72)","v":""},{"$f":"IF(I51=\"\", \"\",'VAV-uitgebreid'!N72)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA72,'VAV-uitgebreid'!AB72)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD72=0,\"\", 'VAV-uitgebreid'!AD72)","v":""},{"$f":"'VAV-uitgebreid'!AG72","v":" "},{"$f":"IF('VAV-uitgebreid'!AE72=0,\"\",'VAV-uitgebreid'!AE72)","v":""},{"$f":"'VAV-uitgebreid'!BD72","v":" "},{"$f":"'VAV-uitgebreid'!AF72","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B73),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G73","v":" "},{"$f":"IF(I52=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M73,1))","v":""},{"$f":"IF(I52=\"\", \"\",'VAV-uitgebreid'!Q73)","v":""},{"$f":"IF(I52=\"\", \"\",'VAV-uitgebreid'!N73)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA73,'VAV-uitgebreid'!AB73)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD73=0,\"\", 'VAV-uitgebreid'!AD73)","v":""},{"$f":"'VAV-uitgebreid'!AG73","v":" "},{"$f":"IF('VAV-uitgebreid'!AE73=0,\"\",'VAV-uitgebreid'!AE73)","v":""},{"$f":"'VAV-uitgebreid'!BD73","v":" "},{"$f":"'VAV-uitgebreid'!AF73","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B74),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G74","v":" "},{"$f":"IF(I53=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M74,1))","v":""},{"$f":"IF(I53=\"\", \"\",'VAV-uitgebreid'!Q74)","v":""},{"$f":"IF(I53=\"\", \"\",'VAV-uitgebreid'!N74)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA74,'VAV-uitgebreid'!AB74)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD74=0,\"\", 'VAV-uitgebreid'!AD74)","v":""},{"$f":"'VAV-uitgebreid'!AG74","v":" "},{"$f":"IF('VAV-uitgebreid'!AE74=0,\"\",'VAV-uitgebreid'!AE74)","v":""},{"$f":"'VAV-uitgebreid'!BD74","v":" "},{"$f":"'VAV-uitgebreid'!AF74","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B75),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G75","v":" "},{"$f":"IF(I54=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M75,1))","v":""},{"$f":"IF(I54=\"\", \"\",'VAV-uitgebreid'!Q75)","v":""},{"$f":"IF(I54=\"\", \"\",'VAV-uitgebreid'!N75)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA75,'VAV-uitgebreid'!AB75)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD75=0,\"\", 'VAV-uitgebreid'!AD75)","v":""},{"$f":"'VAV-uitgebreid'!AG75","v":" "},{"$f":"IF('VAV-uitgebreid'!AE75=0,\"\",'VAV-uitgebreid'!AE75)","v":""},{"$f":"'VAV-uitgebreid'!BD75","v":" "},{"$f":"'VAV-uitgebreid'!AF75","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B76),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G76","v":" "},{"$f":"IF(I55=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M76,1))","v":""},{"$f":"IF(I55=\"\", \"\",'VAV-uitgebreid'!Q76)","v":""},{"$f":"IF(I55=\"\", \"\",'VAV-uitgebreid'!N76)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA76,'VAV-uitgebreid'!AB76)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD76=0,\"\", 'VAV-uitgebreid'!AD76)","v":""},{"$f":"'VAV-uitgebreid'!AG76","v":" "},{"$f":"IF('VAV-uitgebreid'!AE76=0,\"\",'VAV-uitgebreid'!AE76)","v":""},{"$f":"'VAV-uitgebreid'!BD76","v":" "},{"$f":"'VAV-uitgebreid'!AF76","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B77),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G77","v":" "},{"$f":"IF(I56=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M77,1))","v":""},{"$f":"IF(I56=\"\", \"\",'VAV-uitgebreid'!Q77)","v":""},{"$f":"IF(I56=\"\", \"\",'VAV-uitgebreid'!N77)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA77,'VAV-uitgebreid'!AB77)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD77=0,\"\", 'VAV-uitgebreid'!AD77)","v":""},{"$f":"'VAV-uitgebreid'!AG77","v":" "},{"$f":"IF('VAV-uitgebreid'!AE77=0,\"\",'VAV-uitgebreid'!AE77)","v":""},{"$f":"'VAV-uitgebreid'!BD77","v":" "},{"$f":"'VAV-uitgebreid'!AF77","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B78),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G78","v":" "},{"$f":"IF(I57=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M78,1))","v":""},{"$f":"IF(I57=\"\", \"\",'VAV-uitgebreid'!Q78)","v":""},{"$f":"IF(I57=\"\", \"\",'VAV-uitgebreid'!N78)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA78,'VAV-uitgebreid'!AB78)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD78=0,\"\", 'VAV-uitgebreid'!AD78)","v":""},{"$f":"'VAV-uitgebreid'!AG78","v":" "},{"$f":"IF('VAV-uitgebreid'!AE78=0,\"\",'VAV-uitgebreid'!AE78)","v":""},{"$f":"'VAV-uitgebreid'!BD78","v":" "},{"$f":"'VAV-uitgebreid'!AF78","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B79),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G79","v":" "},{"$f":"IF(I58=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M79,1))","v":""},{"$f":"IF(I58=\"\", \"\",'VAV-uitgebreid'!Q79)","v":""},{"$f":"IF(I58=\"\", \"\",'VAV-uitgebreid'!N79)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA79,'VAV-uitgebreid'!AB79)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD79=0,\"\", 'VAV-uitgebreid'!AD79)","v":""},{"$f":"'VAV-uitgebreid'!AG79","v":" "},{"$f":"IF('VAV-uitgebreid'!AE79=0,\"\",'VAV-uitgebreid'!AE79)","v":""},{"$f":"'VAV-uitgebreid'!BD79","v":" "},{"$f":"'VAV-uitgebreid'!AF79","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B80),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G80","v":" "},{"$f":"IF(I59=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M80,1))","v":""},{"$f":"IF(I59=\"\", \"\",'VAV-uitgebreid'!Q80)","v":""},{"$f":"IF(I59=\"\", \"\",'VAV-uitgebreid'!N80)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA80,'VAV-uitgebreid'!AB80)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD80=0,\"\", 'VAV-uitgebreid'!AD80)","v":""},{"$f":"'VAV-uitgebreid'!AG80","v":" "},{"$f":"IF('VAV-uitgebreid'!AE80=0,\"\",'VAV-uitgebreid'!AE80)","v":""},{"$f":"'VAV-uitgebreid'!BD80","v":" "},{"$f":"'VAV-uitgebreid'!AF80","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B81),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G81","v":" "},{"$f":"IF(I60=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M81,1))","v":""},{"$f":"IF(I60=\"\", \"\",'VAV-uitgebreid'!Q81)","v":""},{"$f":"IF(I60=\"\", \"\",'VAV-uitgebreid'!N81)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA81,'VAV-uitgebreid'!AB81)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD81=0,\"\", 'VAV-uitgebreid'!AD81)","v":""},{"$f":"'VAV-uitgebreid'!AG81","v":" "},{"$f":"IF('VAV-uitgebreid'!AE81=0,\"\",'VAV-uitgebreid'!AE81)","v":""},{"$f":"'VAV-uitgebreid'!BD81","v":" "},{"$f":"'VAV-uitgebreid'!AF81","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B82),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G82","v":" "},{"$f":"IF(I61=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M82,1))","v":""},{"$f":"IF(I61=\"\", \"\",'VAV-uitgebreid'!Q82)","v":""},{"$f":"IF(I61=\"\", \"\",'VAV-uitgebreid'!N82)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA82,'VAV-uitgebreid'!AB82)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD82=0,\"\", 'VAV-uitgebreid'!AD82)","v":""},{"$f":"'VAV-uitgebreid'!AG82","v":" "},{"$f":"IF('VAV-uitgebreid'!AE82=0,\"\",'VAV-uitgebreid'!AE82)","v":""},{"$f":"'VAV-uitgebreid'!BD82","v":" "},{"$f":"'VAV-uitgebreid'!AF82","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B83),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G83","v":" "},{"$f":"IF(I62=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M83,1))","v":""},{"$f":"IF(I62=\"\", \"\",'VAV-uitgebreid'!Q83)","v":""},{"$f":"IF(I62=\"\", \"\",'VAV-uitgebreid'!N83)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA83,'VAV-uitgebreid'!AB83)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD83=0,\"\", 'VAV-uitgebreid'!AD83)","v":""},{"$f":"'VAV-uitgebreid'!AG83","v":" "},{"$f":"IF('VAV-uitgebreid'!AE83=0,\"\",'VAV-uitgebreid'!AE83)","v":""},{"$f":"'VAV-uitgebreid'!BD83","v":" "},{"$f":"'VAV-uitgebreid'!AF83","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B84),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G84","v":" "},{"$f":"IF(I63=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M84,1))","v":""},{"$f":"IF(I63=\"\", \"\",'VAV-uitgebreid'!Q84)","v":""},{"$f":"IF(I63=\"\", \"\",'VAV-uitgebreid'!N84)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA84,'VAV-uitgebreid'!AB84)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD84=0,\"\", 'VAV-uitgebreid'!AD84)","v":""},{"$f":"'VAV-uitgebreid'!AG84","v":" "},{"$f":"IF('VAV-uitgebreid'!AE84=0,\"\",'VAV-uitgebreid'!AE84)","v":""},{"$f":"'VAV-uitgebreid'!BD84","v":" "},{"$f":"'VAV-uitgebreid'!AF84","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B85),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G85","v":" "},{"$f":"IF(I64=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M85,1))","v":""},{"$f":"IF(I64=\"\", \"\",'VAV-uitgebreid'!Q85)","v":""},{"$f":"IF(I64=\"\", \"\",'VAV-uitgebreid'!N85)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA85,'VAV-uitgebreid'!AB85)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD85=0,\"\", 'VAV-uitgebreid'!AD85)","v":""},{"$f":"'VAV-uitgebreid'!AG85","v":" "},{"$f":"IF('VAV-uitgebreid'!AE85=0,\"\",'VAV-uitgebreid'!AE85)","v":""},{"$f":"'VAV-uitgebreid'!BD85","v":" "},{"$f":"'VAV-uitgebreid'!AF85","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B86),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G86","v":" "},{"$f":"IF(I65=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M86,1))","v":""},{"$f":"IF(I65=\"\", \"\",'VAV-uitgebreid'!Q86)","v":""},{"$f":"IF(I65=\"\", \"\",'VAV-uitgebreid'!N86)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA86,'VAV-uitgebreid'!AB86)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD86=0,\"\", 'VAV-uitgebreid'!AD86)","v":""},{"$f":"'VAV-uitgebreid'!AG86","v":" "},{"$f":"IF('VAV-uitgebreid'!AE86=0,\"\",'VAV-uitgebreid'!AE86)","v":""},{"$f":"'VAV-uitgebreid'!BD86","v":" "},{"$f":"'VAV-uitgebreid'!AF86","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B87),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G87","v":" "},{"$f":"IF(I66=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M87,1))","v":""},{"$f":"IF(I66=\"\", \"\",'VAV-uitgebreid'!Q87)","v":""},{"$f":"IF(I66=\"\", \"\",'VAV-uitgebreid'!N87)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA87,'VAV-uitgebreid'!AB87)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD87=0,\"\", 'VAV-uitgebreid'!AD87)","v":""},{"$f":"'VAV-uitgebreid'!AG87","v":" "},{"$f":"IF('VAV-uitgebreid'!AE87=0,\"\",'VAV-uitgebreid'!AE87)","v":""},{"$f":"'VAV-uitgebreid'!BD87","v":" "},{"$f":"'VAV-uitgebreid'!AF87","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B88),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G88","v":" "},{"$f":"IF(I67=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M88,1))","v":""},{"$f":"IF(I67=\"\", \"\",'VAV-uitgebreid'!Q88)","v":""},{"$f":"IF(I67=\"\", \"\",'VAV-uitgebreid'!N88)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA88,'VAV-uitgebreid'!AB88)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD88=0,\"\", 'VAV-uitgebreid'!AD88)","v":""},{"$f":"'VAV-uitgebreid'!AG88","v":" "},{"$f":"IF('VAV-uitgebreid'!AE88=0,\"\",'VAV-uitgebreid'!AE88)","v":""},{"$f":"'VAV-uitgebreid'!BD88","v":" "},{"$f":"'VAV-uitgebreid'!AF88","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B89),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G89","v":" "},{"$f":"IF(I68=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M89,1))","v":""},{"$f":"IF(I68=\"\", \"\",'VAV-uitgebreid'!Q89)","v":""},{"$f":"IF(I68=\"\", \"\",'VAV-uitgebreid'!N89)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA89,'VAV-uitgebreid'!AB89)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD89=0,\"\", 'VAV-uitgebreid'!AD89)","v":""},{"$f":"'VAV-uitgebreid'!AG89","v":" "},{"$f":"IF('VAV-uitgebreid'!AE89=0,\"\",'VAV-uitgebreid'!AE89)","v":""},{"$f":"'VAV-uitgebreid'!BD89","v":" "},{"$f":"'VAV-uitgebreid'!AF89","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B90),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G90","v":" "},{"$f":"IF(I69=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M90,1))","v":""},{"$f":"IF(I69=\"\", \"\",'VAV-uitgebreid'!Q90)","v":""},{"$f":"IF(I69=\"\", \"\",'VAV-uitgebreid'!N90)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA90,'VAV-uitgebreid'!AB90)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD90=0,\"\", 'VAV-uitgebreid'!AD90)","v":""},{"$f":"'VAV-uitgebreid'!AG90","v":" "},{"$f":"IF('VAV-uitgebreid'!AE90=0,\"\",'VAV-uitgebreid'!AE90)","v":""},{"$f":"'VAV-uitgebreid'!BD90","v":" "},{"$f":"'VAV-uitgebreid'!AF90","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B91),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G91","v":" "},{"$f":"IF(I70=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M91,1))","v":""},{"$f":"IF(I70=\"\", \"\",'VAV-uitgebreid'!Q91)","v":""},{"$f":"IF(I70=\"\", \"\",'VAV-uitgebreid'!N91)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA91,'VAV-uitgebreid'!AB91)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD91=0,\"\", 'VAV-uitgebreid'!AD91)","v":""},{"$f":"'VAV-uitgebreid'!AG91","v":" "},{"$f":"IF('VAV-uitgebreid'!AE91=0,\"\",'VAV-uitgebreid'!AE91)","v":""},{"$f":"'VAV-uitgebreid'!BD91","v":" "},{"$f":"'VAV-uitgebreid'!AF91","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B92),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G92","v":" "},{"$f":"IF(I71=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M92,1))","v":""},{"$f":"IF(I71=\"\", \"\",'VAV-uitgebreid'!Q92)","v":""},{"$f":"IF(I71=\"\", \"\",'VAV-uitgebreid'!N92)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA92,'VAV-uitgebreid'!AB92)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD92=0,\"\", 'VAV-uitgebreid'!AD92)","v":""},{"$f":"'VAV-uitgebreid'!AG92","v":" "},{"$f":"IF('VAV-uitgebreid'!AE92=0,\"\",'VAV-uitgebreid'!AE92)","v":""},{"$f":"'VAV-uitgebreid'!BD92","v":" "},{"$f":"'VAV-uitgebreid'!AF92","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B93),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G93","v":" "},{"$f":"IF(I72=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M93,1))","v":""},{"$f":"IF(I72=\"\", \"\",'VAV-uitgebreid'!Q93)","v":""},{"$f":"IF(I72=\"\", \"\",'VAV-uitgebreid'!N93)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA93,'VAV-uitgebreid'!AB93)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD93=0,\"\", 'VAV-uitgebreid'!AD93)","v":""},{"$f":"'VAV-uitgebreid'!AG93","v":" "},{"$f":"IF('VAV-uitgebreid'!AE93=0,\"\",'VAV-uitgebreid'!AE93)","v":""},{"$f":"'VAV-uitgebreid'!BD93","v":" "},{"$f":"'VAV-uitgebreid'!AF93","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B94),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G94","v":" "},{"$f":"IF(I73=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M94,1))","v":""},{"$f":"IF(I73=\"\", \"\",'VAV-uitgebreid'!Q94)","v":""},{"$f":"IF(I73=\"\", \"\",'VAV-uitgebreid'!N94)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA94,'VAV-uitgebreid'!AB94)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD94=0,\"\", 'VAV-uitgebreid'!AD94)","v":""},{"$f":"'VAV-uitgebreid'!AG94","v":" "},{"$f":"IF('VAV-uitgebreid'!AE94=0,\"\",'VAV-uitgebreid'!AE94)","v":""},{"$f":"'VAV-uitgebreid'!BD94","v":" "},{"$f":"'VAV-uitgebreid'!AF94","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B95),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G95","v":" "},{"$f":"IF(I74=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M95,1))","v":""},{"$f":"IF(I74=\"\", \"\",'VAV-uitgebreid'!Q95)","v":""},{"$f":"IF(I74=\"\", \"\",'VAV-uitgebreid'!N95)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA95,'VAV-uitgebreid'!AB95)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD95=0,\"\", 'VAV-uitgebreid'!AD95)","v":""},{"$f":"'VAV-uitgebreid'!AG95","v":" "},{"$f":"IF('VAV-uitgebreid'!AE95=0,\"\",'VAV-uitgebreid'!AE95)","v":""},{"$f":"'VAV-uitgebreid'!BD95","v":" "},{"$f":"'VAV-uitgebreid'!AF95","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B96),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G96","v":" "},{"$f":"IF(I75=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M96,1))","v":""},{"$f":"IF(I75=\"\", \"\",'VAV-uitgebreid'!Q96)","v":""},{"$f":"IF(I75=\"\", \"\",'VAV-uitgebreid'!N96)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA96,'VAV-uitgebreid'!AB96)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD96=0,\"\", 'VAV-uitgebreid'!AD96)","v":""},{"$f":"'VAV-uitgebreid'!AG96","v":" "},{"$f":"IF('VAV-uitgebreid'!AE96=0,\"\",'VAV-uitgebreid'!AE96)","v":""},{"$f":"'VAV-uitgebreid'!BD96","v":" "},{"$f":"'VAV-uitgebreid'!AF96","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B97),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G97","v":" "},{"$f":"IF(I76=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M97,1))","v":""},{"$f":"IF(I76=\"\", \"\",'VAV-uitgebreid'!Q97)","v":""},{"$f":"IF(I76=\"\", \"\",'VAV-uitgebreid'!N97)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA97,'VAV-uitgebreid'!AB97)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD97=0,\"\", 'VAV-uitgebreid'!AD97)","v":""},{"$f":"'VAV-uitgebreid'!AG97","v":" "},{"$f":"IF('VAV-uitgebreid'!AE97=0,\"\",'VAV-uitgebreid'!AE97)","v":""},{"$f":"'VAV-uitgebreid'!BD97","v":" "},{"$f":"'VAV-uitgebreid'!AF97","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B98),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G98","v":" "},{"$f":"IF(I77=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M98,1))","v":""},{"$f":"IF(I77=\"\", \"\",'VAV-uitgebreid'!Q98)","v":""},{"$f":"IF(I77=\"\", \"\",'VAV-uitgebreid'!N98)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA98,'VAV-uitgebreid'!AB98)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD98=0,\"\", 'VAV-uitgebreid'!AD98)","v":""},{"$f":"'VAV-uitgebreid'!AG98","v":" "},{"$f":"IF('VAV-uitgebreid'!AE98=0,\"\",'VAV-uitgebreid'!AE98)","v":""},{"$f":"'VAV-uitgebreid'!BD98","v":" "},{"$f":"'VAV-uitgebreid'!AF98","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B99),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G99","v":" "},{"$f":"IF(I78=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M99,1))","v":""},{"$f":"IF(I78=\"\", \"\",'VAV-uitgebreid'!Q99)","v":""},{"$f":"IF(I78=\"\", \"\",'VAV-uitgebreid'!N99)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA99,'VAV-uitgebreid'!AB99)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD99=0,\"\", 'VAV-uitgebreid'!AD99)","v":""},{"$f":"'VAV-uitgebreid'!AG99","v":" "},{"$f":"IF('VAV-uitgebreid'!AE99=0,\"\",'VAV-uitgebreid'!AE99)","v":""},{"$f":"'VAV-uitgebreid'!BD99","v":" "},{"$f":"'VAV-uitgebreid'!AF99","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B100),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G100","v":" "},{"$f":"IF(I79=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M100,1))","v":""},{"$f":"IF(I79=\"\", \"\",'VAV-uitgebreid'!Q100)","v":""},{"$f":"IF(I79=\"\", \"\",'VAV-uitgebreid'!N100)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA100,'VAV-uitgebreid'!AB100)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD100=0,\"\", 'VAV-uitgebreid'!AD100)","v":""},{"$f":"'VAV-uitgebreid'!AG100","v":" "},{"$f":"IF('VAV-uitgebreid'!AE100=0,\"\",'VAV-uitgebreid'!AE100)","v":""},{"$f":"'VAV-uitgebreid'!BD100","v":" "},{"$f":"'VAV-uitgebreid'!AF100","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B101),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G101","v":" "},{"$f":"IF(I80=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M101,1))","v":""},{"$f":"IF(I80=\"\", \"\",'VAV-uitgebreid'!Q101)","v":""},{"$f":"IF(I80=\"\", \"\",'VAV-uitgebreid'!N101)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA101,'VAV-uitgebreid'!AB101)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD101=0,\"\", 'VAV-uitgebreid'!AD101)","v":""},{"$f":"'VAV-uitgebreid'!AG101","v":" "},{"$f":"IF('VAV-uitgebreid'!AE101=0,\"\",'VAV-uitgebreid'!AE101)","v":""},{"$f":"'VAV-uitgebreid'!BD101","v":" "},{"$f":"'VAV-uitgebreid'!AF101","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B102),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G102","v":" "},{"$f":"IF(I81=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M102,1))","v":""},{"$f":"IF(I81=\"\", \"\",'VAV-uitgebreid'!Q102)","v":""},{"$f":"IF(I81=\"\", \"\",'VAV-uitgebreid'!N102)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA102,'VAV-uitgebreid'!AB102)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD102=0,\"\", 'VAV-uitgebreid'!AD102)","v":""},{"$f":"'VAV-uitgebreid'!AG102","v":" "},{"$f":"IF('VAV-uitgebreid'!AE102=0,\"\",'VAV-uitgebreid'!AE102)","v":""},{"$f":"'VAV-uitgebreid'!BD102","v":" "},{"$f":"'VAV-uitgebreid'!AF102","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B103),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G103","v":" "},{"$f":"IF(I82=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M103,1))","v":""},{"$f":"IF(I82=\"\", \"\",'VAV-uitgebreid'!Q103)","v":""},{"$f":"IF(I82=\"\", \"\",'VAV-uitgebreid'!N103)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA103,'VAV-uitgebreid'!AB103)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD103=0,\"\", 'VAV-uitgebreid'!AD103)","v":""},{"$f":"'VAV-uitgebreid'!AG103","v":" "},{"$f":"IF('VAV-uitgebreid'!AE103=0,\"\",'VAV-uitgebreid'!AE103)","v":""},{"$f":"'VAV-uitgebreid'!BD103","v":" "},{"$f":"'VAV-uitgebreid'!AF103","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B104),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G104","v":" "},{"$f":"IF(I83=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M104,1))","v":""},{"$f":"IF(I83=\"\", \"\",'VAV-uitgebreid'!Q104)","v":""},{"$f":"IF(I83=\"\", \"\",'VAV-uitgebreid'!N104)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA104,'VAV-uitgebreid'!AB104)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD104=0,\"\", 'VAV-uitgebreid'!AD104)","v":""},{"$f":"'VAV-uitgebreid'!AG104","v":" "},{"$f":"IF('VAV-uitgebreid'!AE104=0,\"\",'VAV-uitgebreid'!AE104)","v":""},{"$f":"'VAV-uitgebreid'!BD104","v":" "},{"$f":"'VAV-uitgebreid'!AF104","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B105),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G105","v":" "},{"$f":"IF(I84=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M105,1))","v":""},{"$f":"IF(I84=\"\", \"\",'VAV-uitgebreid'!Q105)","v":""},{"$f":"IF(I84=\"\", \"\",'VAV-uitgebreid'!N105)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA105,'VAV-uitgebreid'!AB105)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD105=0,\"\", 'VAV-uitgebreid'!AD105)","v":""},{"$f":"'VAV-uitgebreid'!AG105","v":" "},{"$f":"IF('VAV-uitgebreid'!AE105=0,\"\",'VAV-uitgebreid'!AE105)","v":""},{"$f":"'VAV-uitgebreid'!BD105","v":" "},{"$f":"'VAV-uitgebreid'!AF105","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B106),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G106","v":" "},{"$f":"IF(I85=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M106,1))","v":""},{"$f":"IF(I85=\"\", \"\",'VAV-uitgebreid'!Q106)","v":""},{"$f":"IF(I85=\"\", \"\",'VAV-uitgebreid'!N106)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA106,'VAV-uitgebreid'!AB106)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD106=0,\"\", 'VAV-uitgebreid'!AD106)","v":""},{"$f":"'VAV-uitgebreid'!AG106","v":" "},{"$f":"IF('VAV-uitgebreid'!AE106=0,\"\",'VAV-uitgebreid'!AE106)","v":""},{"$f":"'VAV-uitgebreid'!BD106","v":" "},{"$f":"'VAV-uitgebreid'!AF106","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B107),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G107","v":" "},{"$f":"IF(I86=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M107,1))","v":""},{"$f":"IF(I86=\"\", \"\",'VAV-uitgebreid'!Q107)","v":""},{"$f":"IF(I86=\"\", \"\",'VAV-uitgebreid'!N107)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA107,'VAV-uitgebreid'!AB107)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD107=0,\"\", 'VAV-uitgebreid'!AD107)","v":""},{"$f":"'VAV-uitgebreid'!AG107","v":" "},{"$f":"IF('VAV-uitgebreid'!AE107=0,\"\",'VAV-uitgebreid'!AE107)","v":""},{"$f":"'VAV-uitgebreid'!BD107","v":" "},{"$f":"'VAV-uitgebreid'!AF107","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B108),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G108","v":" "},{"$f":"IF(I87=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M108,1))","v":""},{"$f":"IF(I87=\"\", \"\",'VAV-uitgebreid'!Q108)","v":""},{"$f":"IF(I87=\"\", \"\",'VAV-uitgebreid'!N108)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA108,'VAV-uitgebreid'!AB108)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD108=0,\"\", 'VAV-uitgebreid'!AD108)","v":""},{"$f":"'VAV-uitgebreid'!AG108","v":" "},{"$f":"IF('VAV-uitgebreid'!AE108=0,\"\",'VAV-uitgebreid'!AE108)","v":""},{"$f":"'VAV-uitgebreid'!BD108","v":" "},{"$f":"'VAV-uitgebreid'!AF108","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B109),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G109","v":" "},{"$f":"IF(I88=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M109,1))","v":""},{"$f":"IF(I88=\"\", \"\",'VAV-uitgebreid'!Q109)","v":""},{"$f":"IF(I88=\"\", \"\",'VAV-uitgebreid'!N109)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA109,'VAV-uitgebreid'!AB109)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD109=0,\"\", 'VAV-uitgebreid'!AD109)","v":""},{"$f":"'VAV-uitgebreid'!AG109","v":" "},{"$f":"IF('VAV-uitgebreid'!AE109=0,\"\",'VAV-uitgebreid'!AE109)","v":""},{"$f":"'VAV-uitgebreid'!BD109","v":" "},{"$f":"'VAV-uitgebreid'!AF109","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B110),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G110","v":" "},{"$f":"IF(I89=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M110,1))","v":""},{"$f":"IF(I89=\"\", \"\",'VAV-uitgebreid'!Q110)","v":""},{"$f":"IF(I89=\"\", \"\",'VAV-uitgebreid'!N110)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA110,'VAV-uitgebreid'!AB110)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD110=0,\"\", 'VAV-uitgebreid'!AD110)","v":""},{"$f":"'VAV-uitgebreid'!AG110","v":" "},{"$f":"IF('VAV-uitgebreid'!AE110=0,\"\",'VAV-uitgebreid'!AE110)","v":""},{"$f":"'VAV-uitgebreid'!BD110","v":" "},{"$f":"'VAV-uitgebreid'!AF110","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B111),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G111","v":" "},{"$f":"IF(I90=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M111,1))","v":""},{"$f":"IF(I90=\"\", \"\",'VAV-uitgebreid'!Q111)","v":""},{"$f":"IF(I90=\"\", \"\",'VAV-uitgebreid'!N111)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA111,'VAV-uitgebreid'!AB111)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD111=0,\"\", 'VAV-uitgebreid'!AD111)","v":""},{"$f":"'VAV-uitgebreid'!AG111","v":" "},{"$f":"IF('VAV-uitgebreid'!AE111=0,\"\",'VAV-uitgebreid'!AE111)","v":""},{"$f":"'VAV-uitgebreid'!BD111","v":" "},{"$f":"'VAV-uitgebreid'!AF111","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B112),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G112","v":" "},{"$f":"IF(I91=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M112,1))","v":""},{"$f":"IF(I91=\"\", \"\",'VAV-uitgebreid'!Q112)","v":""},{"$f":"IF(I91=\"\", \"\",'VAV-uitgebreid'!N112)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA112,'VAV-uitgebreid'!AB112)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD112=0,\"\", 'VAV-uitgebreid'!AD112)","v":""},{"$f":"'VAV-uitgebreid'!AG112","v":" "},{"$f":"IF('VAV-uitgebreid'!AE112=0,\"\",'VAV-uitgebreid'!AE112)","v":""},{"$f":"'VAV-uitgebreid'!BD112","v":" "},{"$f":"'VAV-uitgebreid'!AF112","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B113),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G113","v":" "},{"$f":"IF(I92=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M113,1))","v":""},{"$f":"IF(I92=\"\", \"\",'VAV-uitgebreid'!Q113)","v":""},{"$f":"IF(I92=\"\", \"\",'VAV-uitgebreid'!N113)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA113,'VAV-uitgebreid'!AB113)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD113=0,\"\", 'VAV-uitgebreid'!AD113)","v":""},{"$f":"'VAV-uitgebreid'!AG113","v":" "},{"$f":"IF('VAV-uitgebreid'!AE113=0,\"\",'VAV-uitgebreid'!AE113)","v":""},{"$f":"'VAV-uitgebreid'!BD113","v":" "},{"$f":"'VAV-uitgebreid'!AF113","v":" "}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR('VAV-uitgebreid'!B114),\"\")","v":""},{"$f":"'VAV-uitgebreid'!G114","v":" "},{"$f":"IF(I93=\"\",\"\",IF($C$29=\"ja\",'VAV-uitgebreid'!M114,1))","v":""},{"$f":"IF(I93=\"\", \"\",'VAV-uitgebreid'!Q114)","v":""},{"$f":"IF(I93=\"\", \"\",'VAV-uitgebreid'!N114)","v":""},{"$f":"IF($C$29=\"ja\",'VAV-uitgebreid'!AA114,'VAV-uitgebreid'!AB114)","v":" "},{"$f":"IF('VAV-uitgebreid'!AD114=0,\"\", 'VAV-uitgebreid'!AD114)","v":""},{"$f":"'VAV-uitgebreid'!AG114","v":" "},{"$f":"IF('VAV-uitgebreid'!AE114=0,\"\",'VAV-uitgebreid'!AE114)","v":""},{"$f":"'VAV-uitgebreid'!BD114","v":" "},{"$f":"'VAV-uitgebreid'!AF114","v":" "}]
[]
[null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,"Aan deze berekening kunnen geen rechten ontleend worden. Sedgwick aanvaardt daarom"]
[null,null,null,null,null,null,null,null,"geen enkele aansprakelijkheid bij het gebruik van deze rekenmodule. "]

{"sheet":"VAV-uitgebreid","index":2,"n_rows":123,"n_cols":63,"rows_kept":123,"cut":false,"hidden":true,"merged":[[1,1,1,4],[9,30,11,30]]}
[]
[null,"VAV"]
[]
[null,"verschenen",null,{"$f":"V123","v":0}]
[null,"toekomstig",null,{"$f":"AA123-D4","v":0}]
[null,"totaal",null,{"$f":"SUM(D4:D5)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel berekening rendement op vermogen over 2017"]
[]
[null,"Geslacht",null,null,{"$f":"IF('CW-berekening'!D7=\"man\",\"m\",\"v\")","v":"v"},null,"v/m",null,null,{"$f":"DATE(H11,1,1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schijf","Uw (deel van de) grondslag","Percentage","Percentage","Percentage"]
[null,"Geboortedatum",null,null,{"$f":"'CW-berekening'!D6","v":"00:00:00"},null,null,{"$f":"YEAR(E11)","v":1900},null,{"$f":"DATE(H11,7,1)","v":"1900-07-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sparen en beleggen",1.6299999999999999E-2,5.3900000000000003E-2,"gemiddeld"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(G13)","v":1900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rendement"]
[null,"Verlies ArbeidsVermogen (jaar)",null,null,{"$f":"'CW-berekening'!D12","v":0},null,{"$f":"E15","v":"1900-01-01"},{"$f":"DATE(YEAR(G13)+'CW-berekening'!D13,MONTH(G13),DAY(G13))","v":"1900-01-01"},{"$f":"(H13-G13)/365.25-1","v":-1},null,{"$f":"K12+'CW-berekening'!D13","v":1900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Tot en met € 75.000",0.67,0.33,2.8709999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Vanaf € 975.001",0,1,5.3900000000000003E-2]
[null,"Startdatum",null,null,{"$f":"DATE('CW-berekening'!D9,1,1)","v":"1900-01-01"}]
[null,"Kapitalisatiedatum",null,null,{"$f":"DATE('CW-berekening'!D10,1,1)","v":"1900-01-01"}]
[null,"Leeftijd kap.dat.",null,null,{"$f":"IF(AND(E11>J10,E11<=J11),(DATEDIF($E$11,E16,\"y\"))+1,DATEDIF($E$11,E16,\"y\"))","v":0}]
[null,"Overlevingskans kap.dat.vrouw",null,null,{"$f":"VLOOKUP(E17,'Sterftetabel Vrouw'!$A$4:$C$124,3)","v":10000000}]
[null,"Overlevingskans kap.dat. man",null,null,{"$f":"VLOOKUP(E17,'Sterftetabel Man'!$A$4:$C$124,3)","v":10000000}]
[null,"Rendement 1",null,null,{"$f":"'CW-berekening'!D16","v":0},null,{"$f":"DATE(YEAR(E16)+'CW-berekening'!E16,MONTH(G13),DAY(G13))","v":"1900-01-01"},null,null,null,1.2999999999999999E-3,0.67,{"$f":"+K20*L20","v":8.7100000000000003E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"waarom geen box III voor kapitalisatiedatum?"]
[null,null,null,null,null,null,null,null,null,null,5.6000000000000001E-2,0.33,{"$f":"+K21*L21","v":1.848E-2}]
[null,"Inflatie 1",null,null,{"$f":"'CW-berekening'!D19","v":0},null,{"$f":"DATE(YEAR(E16)+'CW-berekening'!E19,MONTH(G13),DAY(G13))","v":"1900-01-01"},null,null,null,null,null,{"$f":"SUM(M20:M21)","v":1.9351E-2}]
[]
[null,"Heffingvrij vermogen box 3",null,null,30360,null,null,null,null,null,1.2999999999999999E-3,0.21,{"$f":"+K24*L24","v":2.7299999999999997E-4}]
[null,"Malen heffingvrij vermogen box 3",null,null,{"$f":"IF('CW-berekening'!D24=\"nee\",0,IF('CW-berekening'!D25=\"Ja, enkele vrijstelling (€30.360)\",1,2))","v":1},null,"0x/1x/2x",null,null,null,5.6000000000000001E-2,0.79,{"$f":"+K25*L25","v":4.4240000000000002E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"als kleiner dan kapdatum of einde schadedatum?",null,null,null,"invloed ",null,"voor kap geen boixIII?",null,"geen tussenstap contant maken?"]
[null,null,null,null,71650,null,989736,989737,null,null,null,null,{"$f":"SUM(M24:M25)","v":4.4513000000000004E-2},null,null,null,null,null,null,null,null,null,null,null,null,"nut??",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rendement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"en het rendement over box III kolom AO!!!!"]
[null,"Fictief rendement box 3",null,null,{"$f":"M22","v":1.9351E-2},null,{"$f":"M26","v":4.4513000000000004E-2},5.6000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,"?????",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"reeds verdisconteerd in box III schade?!"]
[null,"Heffing box 3",null,null,0.3,null,0.3,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inflatie",null,null,null,null,null,null,null,null,null,null,null,null,"Te bepalen over het fiscaal inkomen????"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sterfte",null,"zonder sterftekans"]
[null,"Datum","Jaar","Looptijd","Leeftijd","Leeftijd","VAV",null,null,"Totaal","Aantal","Aantal","Overle-","Inflatie","Inflatie-","Inflatie-","Rendement","Rendement-","Rendement-","Kapitalis.","Cum.","Schade","Schade","Kapitalis.","Zonder","Schade","Schade","Schade",null,"Vermogen","Schade","Rendement","Vermogen",null,"Vermogen","1e schijf","Heffingvrij","Fiscaal","FC1","FC1","FC1","FC1","FC1","FC1","FC1","FC2","FC2","FC3","FC3","FC4","FC4","FC5","FC5",null,"FC kapitaal","Fiscale","FC kapitaal",null,"Jaar","Vermogen","Schade","Rendement","Vermogen"]
[null,null,null,null,null,"tbv sterftekans",null,null,null,"schade","jaar","kap.dat","vingskans",null,"factor","factor cum.",null,"factor","factor cum.","factor 1","kap.fact.","verschenen","met kans","factor 2","sterftekans",null,"herrekend","herrekend",null,"begin",null,null,"eind",null,"01-01",null,"vermogen","vermogen","bepaling %","1e","2e","3e","totaal","contant","kapitaal",null,"kapitaal",null,"kapitaal",null,"kapitaal",null,"kapitaal",null,"begin","schade","eind",null,null,"begin",null,null,"eind"]
[null,"T","T","T","T",null,"€",null,null,"€","A","A","F","%","F","F","%","F","F","F","F","€","€","F",null,"€","€",null,null,"€","€","€","€",null,"€","€","€","€",null,"€","€","€",null,"€","€","€","€","€","€","€","€","€","€",null,"€","€","€",null,"T","€","€","€","€"]
[{"$f":"E15","v":"1900-01-01"},{"$f":"IF(A33>=$H$13,\" \",A33)","v":" "},{"$f":"YEAR(G13)","v":1900},{"$f":"IF(A33>=$H$13,\" \",1)","v":" "},{"$f":"YEAR(A33)-YEAR($E$11)","v":0},{"$f":"IF(AND($E$11>$J$10,$E$11<=$J$11),(DATEDIF($E$11,A33,\"y\"))+1,DATEDIF($E$11,A33,\"y\"))","v":0},{"$f":"IF(A33>=$H$13,\" \",IF(B33>=$G$13,IF(B33<$H$13,$E$13,0),0))","v":" "},null,null,{"$f":"IF(A33>=$H$13,\" \",SUM(G33:I33))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F33,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F33,'Sterftetabel Vrouw'!A4:$C$124,3)))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF($E$10=\"m\",$E$19,$E$18))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33>$E$16,K33/L33,1))","v":" "},{"$f":"IF(B33<$E$16,0,$E$22)","v":0},{"$f":"IF(A33>=$H$13,\" \",(1+N33)^(YEAR(B33)+1-YEAR($E$16)))","v":" "},{"$f":"IF(A33>=$H$13,\" \",O33)","v":" "},{"$f":"IF(B33<$E$16,0,$E$20)","v":0},{"$f":"IF(A33>=$H$13,\" \",(1+Q33)^(YEAR(B33)+1-YEAR($E$16)))","v":" "},{"$f":"IF(A33>=$H$13,\" \",R33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",M33*O33/R33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",T33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,W33,\" \"))","v":" "},{"$f":"IF(A33>=$H$13,\" \",J33*T33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",M33*P33/S33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",P33/S33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",J33*P33*M33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",J33*X33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",J33*Y33)","v":" "},null,{"$f":"IF(A33>=$H$13,\" \",AA123)","v":" "},{"$f":"IF(Z33=\" \",0,Z33)","v":0},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,0,AD33*Q33))","v":" "},{"$f":"IF(A33>=$H$13,\" \",AD33-AE33+AF33)","v":" "},null,{"$f":"IF(B33<$E$16,0,AD33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(AI33<$E$26,AI33,$E$26))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(AI33<1,0,IF($E$25=0,0,IF($E$25=1,$E$24,2*$E$24))))","v":" "},{"$f":"IF(A33>=$H$13,\" \",AI33-AK33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(AI33<$H$26,IF(AI33<$E$26,$E$27,$G$27),$H$27))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$H$13,IF(AI33-AK33<AJ33,IF(AI33-AK33<0,0,(AI33-AK33)*$E$27*0.3),AJ33*$E$27*0.3),0))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$H$13,IF(AL33<AJ33,0,IF(AL33>$G$26,($G$26-AJ33)*$G$27*0.3,(AL33-AJ33)*$G$27*0.3)),0))","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(AL33>$G$26,(AL33-$G$26)*$H$27*0.3,0))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AN33+AO33+AP33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",AQ33/S33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",AR123)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,0,+AS33*AM33*0.3))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AT123)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,0,AU33*AM33*0.3))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AV123)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,0,+AW33*AM33*0.3))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AX123)","v":" "},{"$f":"IF(A33>=$H$13,\" \",IF(B33<$E$16,0,+AY33*AM33*0.3))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AZ123)","v":" "},null,{"$f":"IF(A33>=$H$13,\" \",SUM(AR123:AZ123))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AR33+AT33+AV33+AX33+AZ33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",BC33-BD33)","v":" "},null,{"$f":"IF(A33>=$H$13,\" \",YEAR($E$15))","v":" "},{"$f":"IF(A33>=$H$13,\" \",+BC33+AD33)","v":" "},{"$f":"IF(A33>=$H$13,\" \",+BD33+AE33)","v":" "},{"$f":"+AF33","v":" "},{"$f":"IF(A33>=$H$13,\" \",+AG33+BE33)","v":" "}]
[{"$f":"DATE(C34,1,1)","v":"1901-01-01"},{"$f":"IF(A34>=$H$13,\" \",A34)","v":" "},{"$f":"C33+1","v":1901},{"$f":"IF(A34>=$H$13,\" \",D33+1)","v":" "},{"$f":"YEAR(A34)-YEAR($E$11)","v":1},{"$f":"IF(AND($E$11>$J$10,$E$11<=$J$11),(DATEDIF($E$11,A34,\"y\"))+1,DATEDIF($E$11,A34,\"y\"))","v":1},{"$f":"IF(A34>=$H$13,\" \",IF(B34>=$G$13,IF(B34<$H$13,$E$13,0),0))","v":" "},null,null,{"$f":"IF(A34>=$H$13,\" \",SUM(G34:I34))","v":" "},{"$f":"IF(A34>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F34,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F34,'Sterftetabel Vrouw'!A5:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B34<$E$16,0,$E$22)","v":0}," ",{"$f":"P33*(1+N34)","v":{"$error":"#VALUE!"}},{"$f":"IF(B34<$E$16,0,$E$20)","v":0}," ",{"$f":"S33*(1+Q34)","v":{"$error":"#VALUE!"}},{"$f":"IF(A34>=$H$13,\" \",M34*O34/R34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",T34)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",J34*T34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",M34*P34/S34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",P34/S34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",J34*P34*M34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",J34*X34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",J34*Y34)","v":" "},null,{"$f":"IF(A34>=$H$13,\" \",AG33)","v":" "},{"$f":"IF(Z34=\" \",0,Z34)","v":0}," ",{"$f":"IF(A34>=$H$13,\" \",AD34-AE34+AF34)","v":" "},null,{"$f":"IF(B34<$E$16,0,AD34)","v":" "}," "," ",{"$f":"IF(A34>=$H$13,\" \",AI34-AK34)","v":" "}," "," "," "," ",{"$f":"IF(A34>=$H$13,\" \",+AN34+AO34+AP34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",AQ34/S34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",+AS33-AR33)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",+AU33-AT33)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",+AW33-AV33)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",+AY33-AX33)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",+AZ124)","v":" "},null,{"$f":"IF(A34>=$H$13,\" \",+BE33)","v":" "},{"$f":"IF(A34>=$H$13,\" \",+AR34+AT34+AV34+AX34+AZ34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",BC34-BD34)","v":" "},null,{"$f":"IF(A34>=$H$13,\" \",BG33+1)","v":" "},{"$f":"IF(A34>=$H$13,\" \",+BC34+AD34)","v":" "},{"$f":"IF(A34>=$H$13,\" \",+BD34+AE34)","v":" "}," ",{"$f":"IF(A34>=$H$13,\" \",+AG34+BE34)","v":" "}]
[{"$f":"DATE(C35,1,1)","v":"1902-01-01"}," ",{"$f":"C34+1","v":1902},{"$f":"IF(A35>=$H$13,\" \",D34+1)","v":" "},2,2," ",null,null," ",{"$f":"IF(A35>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F35,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F35,'Sterftetabel Vrouw'!A6:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P34*(1+N35)","v":{"$error":"#VALUE!"}},0," ",{"$f":"S34*(1+Q35)","v":{"$error":"#VALUE!"}}," "," "," "," "," ",{"$f":"IF(A35>=$H$13,\" \",P35/S35)","v":" "}," "," ",{"$f":"IF(A35>=$H$13,\" \",J35*Y35)","v":" "},null,{"$f":"IF(A35>=$H$13,\" \",AG34)","v":" "},0," "," ",null,{"$f":"IF(B35<$E$16,0,AD35)","v":" "}," "," "," "," "," "," "," "," "," ",{"$f":"IF(A35>=$H$13,\" \",+AS34-AR34)","v":" "}," ",{"$f":"IF(A35>=$H$13,\" \",+AU34-AT34)","v":" "}," ",{"$f":"IF(A35>=$H$13,\" \",+AW34-AV34)","v":" "}," ",{"$f":"IF(A35>=$H$13,\" \",+AY34-AX34)","v":" "}," "," ",null,{"$f":"IF(A35>=$H$13,\" \",+BE34)","v":" "}," "," ",null,{"$f":"IF(A35>=$H$13,\" \",BG34+1)","v":" "}," "," "," "," "]
["1903-01-01"," ",1903," ",3,3," ",null,null," ",{"$f":"IF(A36>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F36,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F36,'Sterftetabel Vrouw'!A7:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P35*(1+N36)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," ",{"$f":"IF(A36>=$H$13,\" \",P36/S36)","v":" "}," "," "," ",null," ",0," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1904-01-01"," ",1904," ",4,4," ",null,null," ",{"$f":"IF(A37>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F37,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F37,'Sterftetabel Vrouw'!A8:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P36*(1+N37)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null," ",0," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1905-01-01"," ",1905," ",5,5," ",null,null," ",{"$f":"IF(A38>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F38,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F38,'Sterftetabel Vrouw'!A9:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P37*(1+N38)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null," ",0," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1906-01-01"," ",1906," ",6,6," ",null,null," ",{"$f":"IF(A39>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F39,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F39,'Sterftetabel Vrouw'!A10:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null," ",0," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1907-01-01"," ",1907," ",7,7," ",null,null," ",{"$f":"IF(A40>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F40,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F40,'Sterftetabel Vrouw'!A11:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null," ",0," "," ",null," "," "," "," "," ",{"$f":"IF(A40>=$H$13,\" \",IF(B40<$H$13,IF(AI40-AK40<AJ40,IF(AI40-AK40<0,0,(AI40-AK40)*$E$27*0.3),AJ40*$E$27*0.3),0))","v":" "},{"$f":"IF(A40>=$H$13,\" \",IF(B40<$H$13,IF(AL40<AJ40,0,IF(AL40>$G$26,($G$26-AJ40)*$G$27*0.3,(AL40-AJ40)*$G$27*0.3)),0))","v":" "}," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1908-01-01"," ",1908," ",8,8," ",null,null," ",{"$f":"IF(A41>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F41,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F41,'Sterftetabel Vrouw'!A12:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null," ",0," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1909-01-01",{"$f":"IF(A42>=$H$13,\" \",A42)","v":" "},1909," ",9,9," ",null,null," ",{"$f":"IF(A42>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F42,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F42,'Sterftetabel Vrouw'!A13:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(A42>=$H$13,0,AG41)","v":0},0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1910-01-01"," ",1910," ",10,10," ",null,null," ",{"$f":"IF(A43>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F43,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F43,'Sterftetabel Vrouw'!A14:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(A43>=$H$13,0,AG42)","v":0},0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1911-01-01"," ",1911," ",11,11," ",null,null," ",{"$f":"IF(A44>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F44,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F44,'Sterftetabel Vrouw'!A15:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1912-01-01"," ",1912," ",12,12," ",null,null," ",{"$f":"IF(A45>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F45,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F45,'Sterftetabel Vrouw'!A16:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B45<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1913-01-01"," ",1913," ",13,13," ",null,null," ",{"$f":"IF(A46>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F46,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F46,'Sterftetabel Vrouw'!A17:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1914-01-01"," ",1914," ",14,14," ",null,null," ",{"$f":"IF(A47>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F47,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F47,'Sterftetabel Vrouw'!A18:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1915-01-01"," ",1915," ",15,15," ",null,null," ",{"$f":"IF(A48>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F48,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F48,'Sterftetabel Vrouw'!A19:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1916-01-01"," ",1916," ",16,16,{"$f":"IF(A49>=$H$13,\" \",IF(B49>=$G$13,IF(B49<$H$13,$E$13,0),0))","v":" "},null,null," ",{"$f":"IF(A49>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F49,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F49,'Sterftetabel Vrouw'!A20:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1917-01-01"," ",1917," ",17,17," ",null,null," ",{"$f":"IF(A50>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F50,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F50,'Sterftetabel Vrouw'!A21:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B50<$E$16,0,AD50)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1918-01-01",{"$f":"IF(A51>=$H$13,\" \",A51)","v":" "},1918," ",18,18," ",null,null," ",{"$f":"IF(A51>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F51,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F51,'Sterftetabel Vrouw'!A22:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B51<$E$16,0,AD51)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," ",{"$f":"IF(A51>=$H$13,\" \",BC51-BD51)","v":" "},null," "," "," "," "," "]
["1919-01-01"," ",1919," ",19,19," ",null,null," ",{"$f":"IF(A52>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F52,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F52,'Sterftetabel Vrouw'!A23:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P51*(1+N52)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(A52>=$H$13,0,AG51)","v":0},0," "," ",null,{"$f":"IF(B52<$E$16,0,AD52)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1920-01-01"," ",1920," ",20,20," ",null,null," ",{"$f":"IF(A53>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F53,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F53,'Sterftetabel Vrouw'!A24:$C$124,3)))","v":" "}," "," ",0," ",{"$f":"P52*(1+N53)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1921-01-01"," ",1921," ",21,21," ",null,null," ",{"$f":"IF(A54>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F54,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F54,'Sterftetabel Vrouw'!A25:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B54<$E$16,0,$E$22)","v":0}," ",{"$f":"P53*(1+N54)","v":{"$error":"#VALUE!"}},0," ",{"$f":"S53*(1+Q54)","v":{"$error":"#VALUE!"}}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(A54>=$H$13,\" \",+BE53)","v":" "}," "," ",null," "," "," "," "," "]
["1922-01-01"," ",1922," ",22,22," ",null,null," ",{"$f":"IF(A55>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F55,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F55,'Sterftetabel Vrouw'!A26:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," ",{"$f":"IF(A55>=$H$13,\" \",+BD55+AE55)","v":" "}," "," "]
["1923-01-01"," ",1923," ",23,23," ",null,null," ",{"$f":"IF(A56>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F56,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F56,'Sterftetabel Vrouw'!A27:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B56<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1924-01-01"," ",1924," ",24,24," ",null,null," ",{"$f":"IF(A57>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F57,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F57,'Sterftetabel Vrouw'!A28:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A57>=$H$13,\" \",M57*O57/R57)","v":" "}," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1925-01-01",{"$f":"IF(A58>=$H$13,\" \",A58)","v":" "},1925," ",25,25," ",null,null," ",{"$f":"IF(A58>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F58,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F58,'Sterftetabel Vrouw'!A29:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(A57>=$H$13,\" \",+AU57-AT57)","v":" "}," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1926-01-01"," ",1926," ",26,26," ",null,null," ",{"$f":"IF(A59>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F59,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F59,'Sterftetabel Vrouw'!A30:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1927-01-01"," ",1927," ",27,27," ",null,null," ",{"$f":"IF(A60>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F60,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F60,'Sterftetabel Vrouw'!A31:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," ",{"$f":"IF(A60>=$H$13,\" \",AI60-AK60)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1928-01-01"," ",1928," ",28,28," ",null,null," ",{"$f":"IF(A61>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F61,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F61,'Sterftetabel Vrouw'!A32:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," ",{"$f":"IF(A61>=$H$13,\" \",J61*X61)","v":" "}," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1929-01-01",{"$f":"IF(A62>=$H$13,\" \",A62)","v":" "},1929," ",29,29," ",null,null," ",{"$f":"IF(A62>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F62,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F62,'Sterftetabel Vrouw'!A33:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B62<$E$16,0,AD62)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null,{"$f":"IF(A62>=$H$13,\" \",BG61+1)","v":" "}," "," "," "," "]
["1930-01-01"," ",1930," ",30,30," ",null,null," ",{"$f":"IF(A63>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F63,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F63,'Sterftetabel Vrouw'!A34:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B63<$E$16,0,AD63)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1931-01-01"," ",1931," ",31,31," ",null,null," ",{"$f":"IF(A64>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F64,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F64,'Sterftetabel Vrouw'!A35:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B64<$E$16,0,AD64)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1932-01-01"," ",1932," ",32,32," ",null,null," ",{"$f":"IF(A65>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F65,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F65,'Sterftetabel Vrouw'!A36:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A65>=$H$13,\" \",M65*O65/R65)","v":" "}," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1933-01-01"," ",1933," ",33,33," ",null,null," ",{"$f":"IF(A66>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F66,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F66,'Sterftetabel Vrouw'!A37:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1934-01-01"," ",1934," ",34,34," ",null,null," ",{"$f":"IF(A67>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F67,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F67,'Sterftetabel Vrouw'!A38:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1935-01-01"," ",1935," ",35,35," ",null,null," ",{"$f":"IF(A68>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F68,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F68,'Sterftetabel Vrouw'!A39:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B68<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1936-01-01"," ",1936," ",36,36," ",null,null," ",{"$f":"IF(A69>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F69,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F69,'Sterftetabel Vrouw'!A40:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B69<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1937-01-01"," ",1937," ",37,37," ",null,null," ",{"$f":"IF(A70>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F70,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F70,'Sterftetabel Vrouw'!A41:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B70<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1938-01-01",{"$f":"IF(A71>=$H$13,\" \",A71)","v":" "},1938," ",38,38," ",null,null," ",{"$f":"IF(A71>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F71,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F71,'Sterftetabel Vrouw'!A42:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1939-01-01",{"$f":"IF(A72>=$H$13,\" \",A72)","v":" "},1939," ",39,39," ",null,null," ",{"$f":"IF(A72>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F72,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F72,'Sterftetabel Vrouw'!A43:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1940-01-01",{"$f":"IF(A73>=$H$13,\" \",A73)","v":" "},1940," ",40,40," ",null,null," ",{"$f":"IF(A73>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F73,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F73,'Sterftetabel Vrouw'!A44:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1941-01-01"," ",1941," ",41,41," ",null,null," ",{"$f":"IF(A74>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F74,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F74,'Sterftetabel Vrouw'!A45:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1942-01-01"," ",1942," ",42,42," ",null,null," ",{"$f":"IF(A75>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F75,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F75,'Sterftetabel Vrouw'!A46:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," ",{"$f":"IF(A75>=$H$13,\" \",+AR75+AT75+AV75+AX75+AZ75)","v":" "}," ",null," "," "," "," "," "]
["1943-01-01"," ",1943," ",43,43," ",null,null," ",{"$f":"IF(A76>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F76,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F76,'Sterftetabel Vrouw'!A47:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B76<$E$16,0,AD76)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1944-01-01"," ",1944," ",44,44," ",null,null," ",{"$f":"IF(A77>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F77,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F77,'Sterftetabel Vrouw'!A48:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," ",{"$f":"IF(A77>=$H$13,\" \",J77*X77)","v":" "}," ",null,0,0," "," ",null,{"$f":"IF(B77<$E$16,0,AD77)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1945-01-01"," ",1945," ",45,45," ",null,null," ",{"$f":"IF(A78>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F78,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F78,'Sterftetabel Vrouw'!A49:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B78<$E$16,0,AD78)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1946-01-01"," ",1946," ",46,46," ",null,null," ",{"$f":"IF(A79>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F79,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F79,'Sterftetabel Vrouw'!A50:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," ",{"$f":"IF(A79>=$H$13,\" \",+AN79+AO79+AP79)","v":" "}," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1947-01-01"," ",1947," ",47,47," ",null,null," ",{"$f":"IF(A80>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F80,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F80,'Sterftetabel Vrouw'!A51:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1948-01-01",{"$f":"IF(A81>=$H$13,\" \",A81)","v":" "},1948," ",48,48," ",null,null," ",{"$f":"IF(A81>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F81,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F81,'Sterftetabel Vrouw'!A52:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1949-01-01"," ",1949," ",49,49," ",null,null," ",{"$f":"IF(A82>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F82,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F82,'Sterftetabel Vrouw'!A53:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B82<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},{"$f":"IF(B82<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1950-01-01"," ",1950," ",50,50," ",null,null," ",{"$f":"IF(A83>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F83,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F83,'Sterftetabel Vrouw'!A54:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1951-01-01"," ",1951," ",51,51," ",null,null," ",{"$f":"IF(A84>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F84,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F84,'Sterftetabel Vrouw'!A55:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1952-01-01"," ",1952," ",52,52," ",null,null," ",{"$f":"IF(A85>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F85,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F85,'Sterftetabel Vrouw'!A56:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1953-01-01"," ",1953," ",53,53," ",null,null," ",{"$f":"IF(A86>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F86,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F86,'Sterftetabel Vrouw'!A57:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1954-01-01",{"$f":"IF(A87>=$H$13,\" \",A87)","v":" "},1954," ",54,54," ",null,null," ",{"$f":"IF(A87>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F87,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F87,'Sterftetabel Vrouw'!A58:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," ",{"$f":"IF(A87>=$H$13,\" \",P87/S87)","v":" "}," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1955-01-01",{"$f":"IF(A88>=$H$13,\" \",A88)","v":" "},1955," ",55,55," ",null,null," ",{"$f":"IF(A88>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F88,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F88,'Sterftetabel Vrouw'!A59:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," ",{"$f":"IF(A88>=$H$13,\" \",P88/S88)","v":" "}," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1956-01-01"," ",1956," ",56,56," ",null,null," ",{"$f":"IF(A89>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F89,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F89,'Sterftetabel Vrouw'!A60:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A89>=$H$13,\" \",M89*O89/R89)","v":" "}," "," "," "," ",{"$f":"IF(A89>=$H$13,\" \",P89/S89)","v":" "}," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1957-01-01"," ",1957," ",57,57," ",null,null," ",{"$f":"IF(A90>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F90,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F90,'Sterftetabel Vrouw'!A61:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," ",{"$f":"IF(A90>=$H$13,\" \",P90/S90)","v":" "}," ",{"$f":"IF(A90>=$H$13,\" \",J90*X90)","v":" "}," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1958-01-01"," ",1958," ",58,58," ",null,null," ",{"$f":"IF(A91>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F91,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F91,'Sterftetabel Vrouw'!A62:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1959-01-01"," ",1959," ",59,59," ",null,null," ",{"$f":"IF(A92>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F92,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F92,'Sterftetabel Vrouw'!A63:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B92<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1960-01-01"," ",1960," ",60,60," ",null,null," ",{"$f":"IF(A93>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F93,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F93,'Sterftetabel Vrouw'!A64:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B93<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B93<$E$16,0,AD93)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1961-01-01"," ",1961," ",61,61," ",null,null," ",{"$f":"IF(A94>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F94,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F94,'Sterftetabel Vrouw'!A65:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B94<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B94<$E$16,0,AD94)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1962-01-01"," ",1962," ",62,62," ",null,null," ",{"$f":"IF(A95>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F95,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F95,'Sterftetabel Vrouw'!A66:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B95<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B95<$E$16,0,AD95)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1963-01-01",{"$f":"IF(A96>=$H$13,\" \",A96)","v":" "},1963," ",63,63," ",null,null," ",{"$f":"IF(A96>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F96,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F96,'Sterftetabel Vrouw'!A67:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B96<$E$16,0,AD96)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1964-01-01"," ",1964," ",64,64," ",null,null," ",{"$f":"IF(A97>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F97,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F97,'Sterftetabel Vrouw'!A68:$C$124,3)))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF($E$10=\"m\",$E$19,$E$18))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF(B97>$E$16,K97/L97,1))","v":" "},0,{"$f":"IF(A97>=$H$13,\" \",(1+N97)^(YEAR(B97)+1-YEAR($E$16)))","v":" "},{"$error":"#VALUE!"},0,{"$f":"IF(A97>=$H$13,\" \",(1+Q97)^(YEAR(B97)+1-YEAR($E$16)))","v":" "},{"$error":"#VALUE!"}," "," ",{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,W97,\" \"))","v":" "}," "," "," "," "," "," ",null,0,0,{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,0,AD97*Q97))","v":" "}," ",null,{"$f":"IF(B97<$E$16,0,AD97)","v":0},{"$f":"IF(A97>=$H$13,\" \",IF(AI97<$E$26,AI97,$E$26))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF(AI97<1,0,IF($E$25=0,0,IF($E$25=1,$E$24,2*$E$24))))","v":" "}," ",{"$f":"IF(A97>=$H$13,\" \",IF(AI97<$H$26,IF(AI97<$E$26,$E$27,$G$27),$H$27))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF(B97<$H$13,IF(AI97-AK97<AJ97,IF(AI97-AK97<0,0,(AI97-AK97)*$E$27*0.3),AJ97*$E$27*0.3),0))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF(B97<$H$13,IF(AL97<AJ97,0,IF(AL97>$G$26,($G$26-AJ97)*$G$27*0.3,(AL97-AJ97)*$G$27*0.3)),0))","v":" "},{"$f":"IF(A97>=$H$13,\" \",IF(AL97>$G$26,(AL97-$G$26)*$H$27*0.3,0))","v":" "}," "," "," ",{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,0,+AS97*AM97*0.3))","v":" "}," ",{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,0,AU97*AM97*0.3))","v":" "}," ",{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,0,+AW97*AM97*0.3))","v":" "}," ",{"$f":"IF(A97>=$H$13,\" \",IF(B97<$E$16,0,+AY97*AM97*0.3))","v":" "}," ",null," ",{"$f":"IF(A97>=$H$13,\" \",+AR97+AT97+AV97+AX97+AZ97)","v":" "}," ",null," "," "," ",{"$f":"+AF97","v":" "}," "]
["1965-01-01"," ",1965," ",{"$f":"YEAR(A98)-YEAR($E$11)","v":65},{"$f":"IF(AND($E$11>$J$10,$E$11<=$J$11),(DATEDIF($E$11,A98,\"y\"))+1,DATEDIF($E$11,A98,\"y\"))","v":65},{"$f":"IF(A98>=$H$13,\" \",IF(B98>=$G$13,IF(B98<$H$13,$E$13,0),0))","v":" "},null,null,{"$f":"IF(A98>=$H$13,\" \",SUM(G98:I98))","v":" "},{"$f":"IF(A98>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F98,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F98,'Sterftetabel Vrouw'!A69:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B98<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A98>=$H$13,\" \",M98*O98/R98)","v":" "},{"$f":"IF(A98>=$H$13,\" \",T98)","v":" "}," ",{"$f":"IF(A98>=$H$13,\" \",J98*T98)","v":" "},{"$f":"IF(A98>=$H$13,\" \",M98*P98/S98)","v":" "}," ",{"$f":"IF(A98>=$H$13,\" \",J98*P98*M98)","v":" "},{"$f":"IF(A98>=$H$13,\" \",J98*X98)","v":" "}," ",null,0,{"$f":"IF(Z98=\" \",0,Z98)","v":0}," ",{"$f":"IF(A98>=$H$13,\" \",AD98-AE98+AF98)","v":" "},null,{"$f":"IF(B98<$E$16,0,AD98)","v":0}," "," ",{"$f":"IF(A98>=$H$13,\" \",AI98-AK98)","v":" "}," "," "," "," ",{"$f":"IF(A98>=$H$13,\" \",+AN98+AO98+AP98)","v":" "},{"$f":"IF(A98>=$H$13,\" \",AQ98/S98)","v":" "}," "," "," "," "," "," "," "," ",{"$f":"IF(A98>=$H$13,\" \",+AZ188)","v":" "},null," "," ",{"$f":"IF(A98>=$H$13,\" \",BC98-BD98)","v":" "},null," ",{"$f":"IF(A98>=$H$13,\" \",+BC98+AD98)","v":" "},{"$f":"IF(A98>=$H$13,\" \",+BD98+AE98)","v":" "}," ",{"$f":"IF(A98>=$H$13,\" \",+AG98+BE98)","v":" "}]
[{"$f":"DATE(C99,1,1)","v":"1966-01-01"}," ",{"$f":"C98+1","v":1966},{"$f":"IF(A99>=$H$13,\" \",D98+1)","v":" "},66,66," ",null,null," ",{"$f":"IF(A99>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F99,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F99,'Sterftetabel Vrouw'!A70:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$f":"S98*(1+Q99)","v":{"$error":"#VALUE!"}}," "," "," "," "," "," "," "," ",{"$f":"IF(A99>=$H$13,\" \",J99*Y99)","v":" "},null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," ",{"$f":"IF(A99>=$H$13,\" \",+AS98-AR98)","v":" "}," "," "," ",{"$f":"IF(A99>=$H$13,\" \",+AW98-AV98)","v":" "}," ",{"$f":"IF(A99>=$H$13,\" \",+AY98-AX98)","v":" "}," "," ",null,{"$f":"IF(A99>=$H$13,\" \",+BE98)","v":" "},{"$f":"IF(A99>=$H$13,\" \",+AR99+AT99+AV99+AX99+AZ99)","v":" "}," ",null,{"$f":"IF(A99>=$H$13,\" \",BG98+1)","v":" "}," "," "," "," "]
["1967-01-01"," ",1967," ",67,67," ",null,null," ",{"$f":"IF(A100>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F100,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F100,'Sterftetabel Vrouw'!A71:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1968-01-01"," ",1968," ",68,68," ",null,null," ",{"$f":"IF(A101>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F101,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F101,'Sterftetabel Vrouw'!A72:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1969-01-01"," ",1969," ",69,69," ",null,null," ",{"$f":"IF(A102>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F102,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F102,'Sterftetabel Vrouw'!A73:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B102<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1970-01-01"," ",1970," ",70,70," ",null,null," ",{"$f":"IF(A103>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F103,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F103,'Sterftetabel Vrouw'!A74:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B103<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1971-01-01"," ",1971," ",71,71," ",null,null," ",{"$f":"IF(A104>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F104,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F104,'Sterftetabel Vrouw'!A75:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1972-01-01",{"$f":"IF(A105>=$H$13,\" \",A105)","v":" "},1972," ",72,72," ",null,null," ",{"$f":"IF(A105>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F105,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F105,'Sterftetabel Vrouw'!A76:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B105<$E$16,0,AD105)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1973-01-01"," ",1973," ",73,73," ",null,null," ",{"$f":"IF(A106>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F106,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F106,'Sterftetabel Vrouw'!A77:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B106<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,{"$f":"IF(B106<$E$16,0,AD106)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1974-01-01"," ",1974," ",74,74," ",null,null," ",{"$f":"IF(A107>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F107,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F107,'Sterftetabel Vrouw'!A78:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(A107>=$H$13,0,AG106)","v":0},0," "," ",null,{"$f":"IF(B107<$E$16,0,AD107)","v":0}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1975-01-01",{"$f":"IF(A108>=$H$13,\" \",A108)","v":" "},1975," ",75,75," ",null,null," ",{"$f":"IF(A108>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F108,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F108,'Sterftetabel Vrouw'!A79:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A108>=$H$13,\" \",M108*O108/R108)","v":" "}," "," "," "," "," "," ",{"$f":"IF(A108>=$H$13,\" \",J108*X108)","v":" "}," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1976-01-01",{"$f":"IF(A109>=$H$13,\" \",A109)","v":" "},1976," ",76,76," ",null,null," ",{"$f":"IF(A109>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F109,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F109,'Sterftetabel Vrouw'!A80:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"},{"$f":"IF(A109>=$H$13,\" \",M109*O109/R109)","v":" "}," "," "," "," "," "," ",{"$f":"IF(A109>=$H$13,\" \",J109*X109)","v":" "}," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," ",{"$f":"IF(A109>=$H$13,\" \",+AR109+AT109+AV109+AX109+AZ109)","v":" "}," ",null," "," "," "," "," "]
["1977-01-01"," ",1977," ",77,77," ",null,null," ",{"$f":"IF(A110>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F110,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F110,'Sterftetabel Vrouw'!A81:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B110<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," ",{"$f":"IF(A110>=$H$13,\" \",+AR110+AT110+AV110+AX110+AZ110)","v":" "}," ",null," "," "," "," "," "]
["1978-01-01"," ",1978," ",78,78," ",null,null," ",{"$f":"IF(A111>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F111,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F111,'Sterftetabel Vrouw'!A82:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B111<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1979-01-01"," ",1979," ",79,79," ",null,null," ",{"$f":"IF(A112>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F112,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F112,'Sterftetabel Vrouw'!A83:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1980-01-01"," ",1980," ",80,80," ",null,null," ",{"$f":"IF(A113>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F113,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F113,'Sterftetabel Vrouw'!A84:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1981-01-01"," ",1981," ",81,81," ",null,null," ",{"$f":"IF(A114>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F114,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F114,'Sterftetabel Vrouw'!A85:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," ",{"$f":"IF(A114>=$H$13,\" \",J114*T114)","v":" "}," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1982-01-01"," ",1982," ",82,82," ",null,null," ",{"$f":"IF(A115>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F115,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F115,'Sterftetabel Vrouw'!A86:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," ",{"$f":"IF(A115>=$H$13,\" \",J115*T115)","v":" "}," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1983-01-01"," ",1983," ",83,83," ",null,null," ",{"$f":"IF(A116>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F116,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F116,'Sterftetabel Vrouw'!A87:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1984-01-01",{"$f":"IF(A117>=$H$13,\" \",A117)","v":" "},1984," ",84,84," ",null,null," ",{"$f":"IF(A117>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F117,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F117,'Sterftetabel Vrouw'!A88:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1985-01-01"," ",1985," ",85,85," ",null,null," ",{"$f":"IF(A118>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F118,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F118,'Sterftetabel Vrouw'!A89:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B118<$E$16,0,$E$22)","v":0}," ",{"$f":"P117*(1+N118)","v":{"$error":"#VALUE!"}},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1986-01-01"," ",1986," ",86,86," ",null,null," ",{"$f":"IF(A119>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F119,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F119,'Sterftetabel Vrouw'!A90:$C$124,3)))","v":" "}," "," ",{"$f":"IF(B119<$E$16,0,$E$22)","v":0}," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," "," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1987-01-01"," ",1987," ",87,87," ",null,null," ",{"$f":"IF(A120>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F120,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F120,'Sterftetabel Vrouw'!A91:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," ",{"$f":"IF(A120>=$H$13,\" \",J120*P120*M120)","v":" "}," "," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1988-01-01"," ",1988," ",88,88," ",null,null," ",{"$f":"IF(A121>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F121,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F121,'Sterftetabel Vrouw'!A92:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},0," ",{"$error":"#VALUE!"}," "," "," "," "," "," ",{"$f":"IF(A121>=$H$13,\" \",J121*P121*M121)","v":" "},{"$f":"IF(A121>=$H$13,\" \",J121*X121)","v":" "}," ",null,0,0," "," ",null,0," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
["1989-01-01"," ",1989," ",89,89," ",null,null," ",{"$f":"IF(A122>=$H$13,\" \",IF($E$10=\"M\",VLOOKUP(F122,'Sterftetabel Man'!$A$4:$C$124,3),VLOOKUP(F122,'Sterftetabel Vrouw'!A93:$C$124,3)))","v":" "}," "," ",0," ",{"$error":"#VALUE!"},{"$f":"IF(B122<$E$16,0,$E$20)","v":0}," ",{"$error":"#VALUE!"}," "," "," "," "," "," "," ",{"$f":"IF(A122>=$H$13,\" \",J122*X122)","v":" "}," ",null,0,0," "," ",null,{"$f":"IF(B122<$E$16,0,AD122)","v":0}," "," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(A121>=$H$13,\" \",+AU121-AT121)","v":" "}," "," "," "," "," "," ",null," "," "," ",null," "," "," "," "," "]
[null,"TOTALEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V33:V122)","v":0},{"$f":"SUM(W33:W122)","v":0},null,null,null,{"$f":"SUM(AA33:AA122)","v":0},{"$f":"SUM(AB33:AB122)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR33:AR122)","v":0},null,{"$f":"SUM(AT33:AT122)","v":0},null,{"$f":"SUM(AV33:AV122)","v":0},null,{"$f":"SUM(AX33:AX108)","v":0},null,{"$f":"SUM(AZ33:AZ122)","v":0},null,null,null,{"$f":"SUM(BD33:BD122)","v":0}]

{"sheet":"Sterftetabel Man","index":3,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["Sterftequotienten Gehele Bevolking 2012-2017"]
["leeftijd","MAN","afgerond"]
["lft","qx","lx"]
[0,3.8287E-3,10000000]
[1,2.431E-4,{"$f":"+C4*(1-B4)","v":9961713},null,null,{"$f":"+C4-C5","v":38287}]
[2,1.5569999999999999E-4,9959291.3075696994,null,null,2421.6924303006381]
[3,1.338E-4,9957740.645913111,null,null,1550.661656588316]
[4,1.082E-4,9956408.3002146874,null,null,1332.3456984236836]
[5,9.0199999999999997E-5,9955331.0168366041,null,null,1077.2833780832589]
[6,7.8899999999999993E-5,9954433.0459788851,null,null,897.97085771895945]
[7,7.5500000000000006E-5,9953647.6412115581,null,null,785.40476732701063]
[8,7.36E-5,9952896.1408146471,null,null,751.50039691105485]
[9,7.36E-5,9952163.6076586824,null,null,732.53315596468747]
[10,7.9400000000000006E-5,9951431.1284171585,null,null,732.47924152389169]
[11,8.3499999999999997E-5,9950640.9847855624,null,null,790.14363159611821]
[12,9.3200000000000002E-5,9949810.1062633321,null,null,830.87852223031223]
[13,1.0280000000000001E-4,9948882.7839614283,null,null,927.32230190373957]
[14,1.2909999999999999E-4,9947860.0388112366,null,null,1022.7451501917094]
[15,1.6009999999999999E-4,9946575.7700802255,null,null,1284.2687310110778]
[16,1.9450000000000001E-4,9944983.3232994359,null,null,1592.4467807896435]
[17,2.4580000000000001E-4,9943049.0240430534,null,null,1934.2992563825101]
[18,2.9510000000000002E-4,9940605.0225929432,null,null,2444.0014501102269]
[19,3.3369999999999998E-4,9937671.5500507765,null,null,2933.4725421667099]
[20,3.6269999999999998E-4,9934355.3490545247,null,null,3316.2009962517768]
[21,3.7599999999999998E-4,9930752.158369422,null,null,3603.1906851027161]
[22,3.904E-4,9927018.1955578756,null,null,3733.9628115464002]
[23,4.0220000000000002E-4,9923142.6876543295,null,null,3875.5079035460949]
[24,4.1590000000000003E-4,9919151.5996653549,null,null,3991.0879889745265]
[25,4.3360000000000002E-4,9915026.2245150544,null,null,4125.3751503005624]
[26,4.4220000000000001E-4,9910727.0691441037,null,null,4299.1553709506989]
[27,4.5570000000000002E-4,9906344.5456341282,null,null,4382.5235099755228]
[28,4.6460000000000002E-4,9901830.2244246826,null,null,4514.3212094455957]
[29,4.7649999999999998E-4,9897229.8341024145,null,null,4600.3903222680092]
[30,4.8369999999999999E-4,9892513.8040864654,null,null,4716.0300159491599]
[31,5.1710000000000005E-4,9887728.7951594293,null,null,4785.0089270360768]
[32,5.4529999999999997E-4,9882615.850599451,null,null,5112.9445599783212]
[33,5.7779999999999995E-4,9877226.86017612,null,null,5388.9904233310372]
[34,6.1050000000000004E-4,9871519.7984963097,null,null,5707.0616798102856]
[35,6.4119999999999997E-4,9865493.2356593274,null,null,6026.5628369823098]
[36,6.7860000000000001E-4,9859167.481396623,null,null,6325.7542627044022]
[37,7.2389999999999998E-4,9852477.0503437482,null,null,6690.4310528747737]
[38,7.7289999999999998E-4,9845344.8422070052,null,null,7132.2081367429346]
[39,8.4630000000000003E-4,9837735.3751784638,null,null,7609.4670285414904]
[40,9.1870000000000005E-4,9829409.6997304503,null,null,8325.6754480134696]
[41,1.0298E-3,9820379.4210393075,null,null,9030.2786911427975]
[42,1.1150999999999999E-3,9810266.3943115212,null,null,10113.026727786288]
[43,1.2333000000000001E-3,9799326.9662552234,null,null,10939.428056297824]
[44,1.3699000000000001E-3,9787241.4563077409,null,null,12085.509947482497]
[45,1.4908E-3,9773833.9142367449,null,null,13407.542070996016]
[46,1.6527E-3,9759263.0826374013,null,{"$f":"+C50","v":9759263.0826374013},14570.831599343568]
[47,1.8366999999999999E-3,9743133.9485407267,{"$f":"+B51*2.5","v":4.5917499999999995E-3},{"$f":"+E50*(1-D51)","v":9714450.9863777012},16129.134096674621]
[48,2.0268999999999999E-3,9725238.7344174422,{"$f":"+B52*2.5","v":5.0672499999999997E-3},9665225.4346169792,17895.214123284444,null,{"$f":"+C52/C52","v":1}]
[49,2.2758000000000001E-3,9705526.6480266508,5.6895000000000001E-3,9610235.1345067266,19712.086390791461,null,{"$f":"+C53/C52","v":0.99797309999999995}]
[50,2.5490000000000001E-3,9683438.8104810715,6.3724999999999997E-3,9548993.9111120831,22087.837545579299,null,{"$f":"+C54/C52","v":0.99570191281901987}]
[51,2.8427999999999999E-3,9658755.7249531541,7.1069999999999996E-3,9481129.2113858089,24683.08552791737]
[52,3.1605000000000001E-3,9631297.8141782563,7.9012500000000003E-3,9406216.4392043464,27457.910774897784]
[53,3.5328E-3,9600858.0974365454,8.8319999999999996E-3,9323140.7356132939,30439.716741710901]
[54,3.9471999999999997E-3,9566940.1859499216,9.8679999999999983E-3,9231139.9828342628,33917.911486623809]
[55,4.3673999999999996E-3,9529177.5596479401,1.0918499999999999E-2,9130349.780931687,37762.626301981509]
[56,4.8788E-3,9487559.829573933,1.2197E-2,9018986.9046536628,41617.730074007064]
[57,5.3961E-3,9441271.9226774089,1.3490250000000001E-2,8897318.5165631585,46287.906896524131]
[58,5.9620000000000003E-3,9390325.8752554487,1.4905000000000002E-2,8764703.9840737842,50946.04742196016]
[59,6.6035E-3,9334340.7523871753,1.6508749999999999E-2,8620009.6771767065,55985.122868273407]
[60,7.3086000000000002E-3,9272701.433228787,1.82715E-2,8462509.1703601722,61639.319158388302]
[61,8.0678E-3,9204930.967533892,2.01695E-2,8291824.5916485935,67770.465694895014]
[62,8.8564000000000004E-3,9130667.4254740216,2.2141000000000001E-2,8108235.3033649027,74263.542059870437]
[63,9.7503999999999993E-3,9049802.5824870542,2.4375999999999998E-2,7910588.9596100803,80864.842986967415]
[64,1.06845E-2,8961563.3873867728,2.6711249999999999E-2,7699287.2402626956,88239.195100281388]
[65,1.1741700000000001E-2,{"$f":"+C68*(1-B68)","v":8865813.5633742381},2.9354250000000002E-2,7473280.4377902141,{"$f":"+C68-C69","v":95749.824012534693}]
[66,1.29569E-2,8761713.8402571678,3.2392249999999997E-2,7231204.0695292037,104099.72311707027]
[67,1.4297000000000001E-2,8648189.19020034,3.5742500000000003E-2,6972742.7580740564,113524.65005682781]
[68,1.5828800000000001E-2,8524546.0293480456,3.9572000000000003E-2,6696817.3816515496,123643.16085229442]
[69,1.7505900000000001E-2,8389612.6951587014,4.3764750000000005E-2,6403732.8431479149,134933.3341893442]
[70,1.93581E-2,8242744.9742785227,4.8395250000000001E-2,6093822.5912705604,146867.72088017873]
[71,2.14144E-2,8083181.092791941,5.3536E-2,5767583.7050242992,159563.88148658164]
[72,2.3675600000000002E-2,7910084.6195984567,5.9189000000000005E-2,5426206.1931076162,173096.47319348436]
[73,2.6173200000000001E-2,7722808.6201786911,6.5433000000000005E-2,5071153.2432740061,187275.99941976555]
[74,2.8967E-2,7520678.0056010298,7.2417499999999996E-2,4703913.003279211,202130.61457766127]
[75,3.21935E-2,7302826.5258127851,8.0483749999999993E-2,4325324.4451015377,217851.4797882447]
[76,3.6044199999999998E-2,7067722.9800540311,9.0110499999999996E-2,3935567.2966912156,235103.54575875401]
[77,4.0589199999999999E-2,6812972.5594163677,0.10147299999999999,3536213.4763940675,254750.42063766345]
[78,4.5836599999999998E-2,6536439.4536077045,0.1145915,3130993.4698138568,276533.10580866318]
[79,5.17993E-2,6236831.2929484695,0.12949825000000001,2725535.2947115344,299608.16065923497]
[80,5.8578699999999997E-2,5913767.7977556437,0.14644674999999999,2326389.5087907379,323063.49519282579]
[81,6.64854E-2,5567346.9680612553,0.16621350000000001,1939712.1661713487,346420.82969438843]
[82,7.5215699999999996E-2,5197199.6779509149,0.18803924999999999,1574970.1452286129,370147.29011034034]
[83,8.4805800000000001E-2,4806288.6661340622,0.21201449999999999,1241053.6373730411,390911.01181685273]
[84,9.5355700000000002E-2,4398687.5107716303,0.23838925,945199.79154990986,407601.15536243189]
[85,0.1067381,3979247.5841007438,0.26684525000000003,692977.71687382623,419439.92667088658]
[86,0.1194423,3554510.25754424,0.29860575,486050.5859934297,424737.32655650377]
[87,0.1335201,3129951.3770095636,0.33380025000000002,323806.77887617634,424558.88053467637]
[88,0.1486364,2712039.956156109,0.371591,203483.09410679911,417911.42085345462]
[89,0.16544490000000001,2308932.1004169071,0.41361225000000001,119319.99371632418,403107.85573920188]
[90,0.1831556,1926931.0599566419,0.45788899999999999,64684.681113550221,382001.04046026524]
[91,0.20388529999999999,1574002.8455116472,0.50971325000000001,31714.042077948918,352928.21444499469]
[92,0.2252226,1253086.8031536513,0.56305649999999996,13857.244544686275,320916.04235799587]
[93,0.24567240000000001,970863.33532169787,0.61418100000000009,5346.3882329863127,282223.46783195343]
[94,0.26829579999999997,732349.00966121152,{"$f":"+B98*2.5","v":0.67073949999999993},{"$f":"+E97*(1-D98)","v":1760.3544627871902},238514.32566048636]
[95,0.28811999999999999,535862.84623494907,{"$f":"+B99*2.5","v":0.72029999999999994},{"$f":"+E98*(1-D99)","v":492.37114324157722},196486.16342626244]
[96,0.31046770000000001,381470.04297773557,{"$f":"+B100*2.5","v":0.77616925000000003},{"$f":"+E99*(1-D100)","v":110.20780227011964},154392.8032572135]
[97,0.33288689999999999,263035.91611553688,{"$f":"+B101*2.5","v":0.83221725000000002},{"$f":"+E100*(1-D101)","v":18.490968136336914},118434.1268621987]
[98,0.3551491,175474.70541117576,{"$f":"+B102*2.5","v":0.88787274999999999},{"$f":"+E101*(1-D102)","v":2.0733414069650835},87561.210704361118]
[99,0.37703170000000003,113155.02171163156,null,null,62319.683699544199]
[100,0.39832679999999998,70491.991512158202,null,null,42663.03019947336]
[101,0.41884880000000002,42413.142107493062,null,null,28078.849404665139]
[102,0.43844060000000001,24648.448431540121,null,null,17764.693675952942]
[103,0.45697749999999998,13841.567912146609,null,null,10806.880519393511]
[104,0.47436850000000003,7516.282811573632,null,null,6325.2851005729772]
[105,0.49055579999999999,3950.795008671666,null,null,3565.487802901966]
[106,0.50551279999999998,2012.70960255673,null,null,1938.0854061149359]
[107,0.51924040000000005,995.25913578139034,null,null,1017.4504667753397]
[108,0.53176259999999997,478.48038401460684,null,null,516.77875176678344]
[109,0.54312199999999999,224.04241096200107,null,null,254.43797305260577]
[110,0.55337530000000001,102.36004863549712,null,null,121.68236232650395]
[111,0.56258909999999995,45.71652601381431,null,null,56.643522621682813]
[112,0.5708358,19.996906788575931,null,null,25.719619225238379]
[113,0.57819100000000001,8.5819565043937587,null,null,11.414950284182172]
[114,0.58473070000000005,3.6199464911618269,null,null,4.9620100132319322]
[115,0.59052930000000003,1.5032526454222279,null,null,2.116693845739599]
[116,0.59565860000000004,0.6155379129978914,null,null,0.88771473242433652]
[117,0.60018609999999994,0.24888746149464558,null,null,0.36665045150324582]
[118,0.60417509999999996,9.9508666641274085E-2,null,null,0.14937879485337149]
[119,0.60768390000000005,3.9388008022415655E-2,null,null,6.012065861885843E-2]
[120,0.61076600000000003,1.5452549694122819E-2,null,null,2.3935458328292837E-2]

{"sheet":"Sterftetabel Vrouw","index":4,"n_rows":124,"n_cols":3,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["Sterftequotienten Gehele Bevolking 2012-2017"]
["leeftijd","VROUW","afgerond"]
["lft","qy","ly"]
[0,3.2599999999999999E-3,10000000]
[1,2.1330000000000001E-4,{"$f":"+C4*(1-B4)","v":9967400}]
[2,9.6600000000000003E-5,{"$f":"+C5*(1-B5)","v":9965273.9535799995}]
[3,8.9900000000000003E-5,9964311.308116084]
[4,7.3499999999999998E-5,9963415.5165294837]
[5,7.1299999999999998E-5,9962683.2054890189]
[6,6.8999999999999997E-5,9961972.8661764674]
[7,7.2299999999999996E-5,9961285.4900487009]
[8,7.3100000000000001E-5,9960565.2891077697]
[9,7.6199999999999995E-5,9959837.1717851348]
[10,7.8700000000000002E-5,9959078.2321926448]
[11,7.8399999999999995E-5,9958294.4527357705]
[12,8.1899999999999999E-5,9957513.7224506754]
[13,8.9400000000000005E-5,9956698.2020768076]
[14,1.014E-4,9955808.0732575413]
[15,1.12E-4,9954798.5543189123]
[16,1.3420000000000001E-4,9953683.6168808285]
[17,1.517E-4,9952347.8325394429]
[18,1.641E-4,9950838.0613732468]
[19,1.7330000000000001E-4,9949205.1288473755]
[20,1.771E-4,9947480.931598546]
[21,1.752E-4,9945719.2327255588]
[22,1.7980000000000001E-4,9943976.7427159846]
[23,1.783E-4,9942188.8156976439]
[24,1.8420000000000001E-4,9940416.1234318055]
[25,1.9550000000000001E-4,9938585.0987818688]
[26,2.1350000000000001E-4,9936642.1053950563]
[27,2.318E-4,9934520.632305555]
[28,2.4429999999999998E-4,9932217.8104229867]
[29,2.6860000000000002E-4,9929791.3696119003]
[30,2.9300000000000002E-4,9927124.2276500221]
[31,3.1690000000000001E-4,9924215.5802513212]
[32,3.4519999999999999E-4,9921070.5963339396]
[33,3.6049999999999998E-4,9917645.8427640852]
[34,3.8769999999999999E-4,9914070.5314377695]
[35,4.2079999999999998E-4,9910226.8462927304]
[36,4.5609999999999997E-4,9906056.6228358112]
[37,4.9660000000000004E-4,9901538.4704101365]
[38,5.3479999999999999E-4,9896621.3664057311]
[39,5.9100000000000005E-4,9891328.6532989778]
[40,6.5629999999999996E-4,9885482.8780648783]
[41,7.2820000000000003E-4,9878995.0356520042]
[42,8.097E-4,9871801.151467042]
[43,9.0959999999999999E-4,9863807.9540746994]
[44,1.0150000000000001E-3,9854835.8343596738]
[45,1.1552999999999999E-3,9844833.1759877987]
[46,1.2844E-3,9833459.4402195811]
[47,1.4652000000000001E-3,9820829.344914563]
[48,1.6442E-3,9806439.865758393]
[49,1.8450000000000001E-3,9790316.1173311137]
[50,2.0574999999999999E-3,9772252.9840946384]
[51,2.2717000000000002E-3,9752146.5735798627]
[52,2.5132000000000002E-3,9729992.6222086623]
[53,2.7726999999999999E-3,9705539.2047505267]
[54,3.0682999999999999E-3,9678628.6561975144]
[55,3.3852999999999999E-3,9648931.7198917028]
[56,3.7055E-3,9616267.1913403533]
[57,4.1043E-3,9580634.1132628415]
[58,4.4927999999999999E-3,9541312.3166717775]
[59,4.9588000000000002E-3,9498445.1086954344]
[60,5.3981000000000003E-3,9451344.2190904357]
[61,5.9002000000000004E-3,9400324.9178613648]
[62,6.3818E-3,9344861.1207809988]
[63,6.8925999999999996E-3,9285224.0860803984]
[64,7.4489999999999999E-3,9221224.7505446803]
[65,8.0464999999999998E-3,9152535.8473778721]
[66,8.7135000000000008E-3,{"$f":"+C69*(1-B69)","v":9078889.9676819462}]
[67,9.5099E-3,8999781.0599485487]
[68,1.0393400000000001E-2,8914194.0420465451]
[69,1.14219E-2,8821545.2576899379]
[70,1.24157E-2,8720786.4499111287]
[71,1.3601800000000001E-2,8612511.7815849669]
[72,1.48664E-2,8495366.118834205]
[73,1.63926E-2,8369070.6079651685]
[74,1.8171400000000001E-2,8231879.7811170388]
[75,2.0174500000000001E-2,8082295.0008624494]
[76,2.2644899999999999E-2,7919238.7403675504]
[77,2.57001E-2,7739908.3710158011]
[78,2.91877E-2,7540991.9518898576]
[79,3.3345300000000001E-2,7320887.7410956817]
[80,3.8042899999999998E-2,7076770.5431025233]
[81,4.3445699999999997E-2,6807549.6690083286]
[82,4.9868200000000001E-2,6511790.9083534935]
[83,5.7459799999999998E-2,6187059.6169775398]
[84,6.5971100000000005E-2,5831552.4087979337]
[85,7.5483499999999995E-2,5446838.4816818843]
[86,8.6463200000000004E-2,5035692.0491498495]
[87,9.8913000000000001E-2,4600290.0003657965]
[88,0.11303779999999999,4145261.5155596142]
[89,0.12874730000000001,3676690.2734160898]
[90,0.14550279999999999,3203326.3277775063]
[91,0.16417789999999999,2737233.3777721613]
[92,0.18384059999999999,2287840.1499996213]
[93,0.2052234,1867242.2441196009]
[94,0.2280469,1484040.4421577465]
[95,0.2503822,1145609.619849043]
[96,0.27456970000000003,858769.36289007589]
[97,0.29928670000000002,622977.31655215658]
[98,0.32423220000000003,436528.49130640627]
[99,0.34909240000000002,294991.8982074493]
[100,0.37355670000000002,192012.46848165515]
[101,0.3973334,120284.92439679404]
[102,0.42016330000000002,72491.706417472917]
[103,0.44183050000000001,42033.351826476319]
[104,0.46216849999999998,23461.734972308372]
[105,0.48106290000000002,12618.46011275907]
[106,0.49844929999999998,6548.1870973808655]
[107,0.51430900000000002,3284.2478224223414]
[108,0.52866199999999997,1595.1296091201293]
[109,0.54155960000000003,751.84519970346355]
[110,0.55307649999999997,344.67621409013572]
[111,0.56330309999999995,154.04389996791278]
[112,0.5723395,67.270493579897618]
[113,0.58029010000000003,28.768932919625804]
[114,0.58725910000000003,12.074605958802854]
[115,0.59334810000000004,4.9836837305816521]
[116,0.59865310000000005,2.0266244580401169]
[117,0.60326400000000002,0.81337944369858095]
[118,0.6072632,0.3226969069752002]
[119,0.61072559999999998,0.12673495061533779]
[120,0.61371869999999995,4.933467185981525E-2]

{"sheet":"Blad2","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Aanpassingen"]
[]
["-","Rendement en inflatie begint te lopen op 1-1 van kapitalisatiejaar of op 1-7 van kapitalisatiejaar (HRP per 1-1 en bij NRL op 1-7)"]
["-","Leeftijd tbv berekenen sterftecijfers?  Jaar-/-geboortejaar, of differentieren op specifieke geboortedatum? "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,"1985-04-01"]
[null,null,null,null,null,null,{"$f":"(G29-G30)/365.25","v":33.752224503764545}]

{"sheet":"Blad3","index":6,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[null,1993]
[null,1994]
[null,1995]
[null,1996,null,"man",null,null,null,"ja"]
[null,1997,null,"vrouw",null,null,null,"nee"]
[null,1998,null,null,null,1,null,null,null,"nee"]
[null,1999,null,null,null,2,null,null,null,"Ja, enkele vrijstelling (€30.360)"]
[null,2000,null,null,null,3,null,null,null,"Ja, dubbele vrijstelling (€60.720)"]
[null,2001,null,null,null,4]
[null,2002,null,null,null,5]
[null,2003,null,null,null,6]
[null,2004,null,null,null,7]
[null,2005,null,null,null,8]
[null,2006,null,null,null,9,null,null,null,"Gedurende hoeveel jaar?"]
[null,2007,null,null,null,10,null,null,null,1]
[null,2008,null,null,null,11,null,null,null,2]
[null,2009,null,null,null,12,null,null,null,3]
[null,2010,null,null,null,13,null,null,null,4]
[null,2011,null,null,null,14,null,null,null,5]
[null,2012,null,null,null,15,null,null,null,6]
[null,2013,null,null,null,16,null,null,null,7]
[null,2014,null,null,null,17,null,null,null,8]
[null,2015,null,null,null,18,null,null,null,9]
[null,2016,null,null,null,19,null,null,null,10]
[null,2017,null,null,null,20,null,null,null,11]
[null,2018,null,2015,null,21,null,null,null,12]
[null,2019,null,2016,null,22,null,null,null,13]
[null,null,null,2017,null,23,null,null,null,14]
[null,null,null,2018,null,24,null,null,null,15]
[null,null,null,2019,null,25,null,null,null,16]
[null,null,null,2020,null,26,null,null,null,17]
[null,null,null,null,null,27,null,null,null,18]
[null,null,null,null,null,28,null,null,null,19]
[null,null,null,null,null,29,null,null,null,20]
[null,null,null,null,null,30,null,null,null,21]
[null,null,null,null,null,31,null,null,null,22]
[null,null,null,null,null,32,null,null,null,23]
[null,null,null,null,null,33,null,null,null,24]
[null,null,null,null,null,34,null,null,null,25]
[null,null,null,null,null,35,null,null,null,26]
[null,null,null,null,null,36,null,null,null,27]
[null,null,null,null,null,37,null,null,null,28]
[null,null,null,null,null,38,null,null,null,29]
[null,null,null,null,null,39,null,null,null,30]
[null,null,null,null,null,40,null,null,null,31]
[null,null,null,null,null,41,null,null,null,32]
[null,null,null,null,null,42,null,null,null,33]
[null,null,null,null,null,43,null,null,null,34]
[null,null,null,null,null,44,null,null,null,35]
[null,null,null,null,null,45,null,null,null,36]
[null,null,null,null,null,46,null,null,null,37]
[null,null,null,null,null,47,null,null,null,38]
[null,null,null,null,null,48,null,null,null,39]
[null,null,null,null,null,49,null,null,null,40]
[null,null,null,null,null,50,null,null,null,41]
[null,null,null,null,null,51,null,null,null,42]
[null,null,null,null,null,52,null,null,null,43]
[null,null,null,null,null,53,null,null,null,44]
[null,null,null,null,null,54,null,null,null,45]
[null,null,null,null,null,55,null,null,null,46]
[null,null,null,null,null,56,null,null,null,47]
[null,null,null,null,null,57,null,null,null,48]
[null,null,null,null,null,58,null,null,null,49]
[null,null,null,null,null,59,null,null,null,50]
[null,null,null,null,null,60,null,null,null,51]
[null,null,null,null,null,61,null,null,null,52]
[null,null,null,null,null,62,null,null,null,53]
[null,null,null,null,null,63,null,null,null,54]
[null,null,null,null,null,64,null,null,null,55]
[null,null,null,null,null,65,null,null,null,56]
[null,null,null,null,null,66,null,null,null,57]
[null,null,null,null,null,67,null,null,null,58]
[null,null,null,null,null,68,null,null,null,59]
[null,null,null,null,null,69,null,null,null,60]
[null,null,null,null,null,70]

{"sheet":"Blad1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Blad4","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}