{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info en versiebeheer","Invoer en Uitvoer","Input and Output","Berekening","Legaliteit","Variabelen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"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":"Info en versiebeheer","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Info en Versiebeheer"]
[]
["Datum",{"$f":"TODAY()","v":"2025-12-12"}]
["Door","Ferry Goike"]
["Review","Henk van Heuveln"]
["Fondsnaam","PME"]
["Doel van de sheet","Berekening van ANW premies voor werkgevers"]
["Gebaseerd op Pensioenreglement","Pensioenreglement PME 1-1-2026"]
["Datum vaststelling reglement","2026-01-01"]
["Versienummer","1.0 - 2026"]
[]
["Werkwijze:"]
["Alle werkbladen worden beveiligd"]
["De sheet komt in directory waar alleen Actuariaat schrijfrechten op heeft, rest van TKP heeft alleen leesrechten"]
["De sheet is geschikt vanaf 1-1-2021."]
["In de sheet moet bij de invoer het verzekerd bedrag worden ingevuld."]
["Daarnaast moet er een geboortedatum van de deelnemer/partner worden ingevuld. "]
["De sheet zal d.m.v. de geboortedatum een burgelijke leeftijd op 1 januari, toetreding regeling of ingang relatie berekenen. Ferry checken a.u.b."]
["De sheet berekent de premie voor een heel jaar (het jaar waarin de berekendatum ligt). Daarnaast wordt ook een bedrag berekend in maanden en 4wk. "]
["Op deze manier is het voor de werkgever inzichtelijk wat de ANW-verzekering op jaar/maand/4wk basis aan premie kost."]
["Tabblad \"Variabelen\" bevat de premietarieven en opslagen; dit moet periodiek worden bijgewerkt"]
["N.B. voor de versie van de sheet die op de website komt: alleen tabblad Invoer en Uitvoer zichtbaar maken en legaliteit op 1 zetten."]
["Voor het tabblad Batch Invoer en Uitvoer dient het pensioennummer te worden gevuld"]
["om een berekening te maken voor de deelnemer. Met de knop wordt de batch berekend."]
["Let op! Bij een jaarovergang (nieuwe bedragen) moet ook de macro (Module4) worden aangepast!"]
[]
["Versienummer","Wijzigingen (korte omschrijving van de aanpassing)","Datum","Auteur","JIRA-melding","Controleur"]
[1,"Aanmaak van een sheet berekening van ANW premies voor werkgevers/werknemers","2021-08-13","Jeroen Achterhof"]
["1.1","Opmaak bedragen, ingangsdatum >= VANDAAG() - 3mnd, delete/print knop","2021-10-08","Jeroen Achterhof"]
[1,"Tarieven en bedragen per 01-01-2022 ingevoerd","2021-12-14","Ferry Goike"]
["1.1 ","Batch tabblad toegevoegd","2022-01-04","Jeroen Achterhof"]
["1.2","Format bedragen aangepast","2002-01-12","Ferry Goike"]
["1.3","Validatie geboortedatum partner aangepast","2022-04-28","Ferry Goike"]
["1.4","Batch invoer aangepast, keuzemogelijkheid periode","2022-05-31","Jeroen Achterhof",null,"Luuk Keizer"]
["1.5","Alle output terug geplaatst","2022-08-02","Jeroen Achterhof",null,"Luuk Keizer"]
["1.6","Nieuwe AOWlftd 67 3 mnd","2022-11-23","Jeroen Achterhof",null,"Patricia Woudstra/Ben Geense"]
["2023 - 1.0","Bedragen en tarieven per 01-01-2023","2022-11-23","Ferry Goike",null,"Patricia Woudstra/Bart van der Kooi"]
["2023 - 1.1","Invoer datum 2023 op batch sheet was niet mogelijk","2023-02-14","Jeroen Achterhof",null,"Patricia Woudstra/Bart van der Kooi"]
["2023 - 1.20","Toevoeging Engelse tabblad Input and Output & Legaliteit aangepast","2023-04-03","Jeffrey Holtrop",null,"Rutger de Boer / Patricia Woudstra"]
["2023 - 1.21","Kolom H tabblad Berekening uitgebreid. Cel E6 tabblad Input and Output naamgeving aangepast.","2023-05-31","Jeffrey Holtrop",null,"Patricia Woudstra"]
["2023 - 1.22","Tabblad Variabelen cel B19 aangepast.","2023-06-21","Jeffrey Holtrop",null,"Patricia Woudstra / Elske de Ruiter"]
["2023 - 1.23","Einde verzekering partner met 1 maand verlaagd, tabblad Variabelen cel B19.","2023-06-26","Jeffrey Holtrop",null,"Patricia Woudstra / Elske de Ruiter"]
["2023 - 1.24 -> 2.0","Einde verzekering partner met 1 maand verhoogd t.o.v. versie 1.22, tabblad Variabelen cel B19.","2023-07-05","Jeffrey Holtrop",null,"Patricia Woudstra / Elske de Ruiter"]
["2023 - 3.0","\"S:\\Pensioenuitvoering_rekensheets_pme\\\" werkzaam gemaakt in tabblad [Legaliteit]","2023-10-26","Ferry Goike",null,"Patricia Woudstra"]
["2024  - 1.0","Tarieven en bedragen per 01-01-2024 ingevoerd","2023-11-27","Ferry Goike",null,"Patricia Woudstra / Elske de Ruiter"]
["2024  - 2.0","Batch tabblad aangepast naar 2024","2023-11-27","Ferry Goike",null,"Alen Buzimkic / Elske de Ruiter"]
["2025  - 1.0","Tarieven en bedragen per 01-01-2025 ingevoerd en batch tabblad aangepast naar 2025","2024-11-20","Ferry Goike","https://tkppensioen.atlassian.net/browse/FLEX-1342","Patricia Tiktak-Woudstra / Wietske Hooghiemstra"]
["2026  - 1.0","Tarieven en bedragen per 01-01-2026 ingevoerd en batch tabblad aangepast naar 2026. Bedragen in Module4 aangepast.","2025-11-21","Ferry Goike","https://tkppensioen.atlassian.net/browse/FLEX-1466","Patricia Tiktak-Woudstra / Wietske Hooghiemstra"]

{"sheet":"Invoer en Uitvoer","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,4,9,7],[5,4,5,7]]}
[]
["Invoer:"]
[]
[null,"Ingangsdatum ANW:"]
[null,"Naam deelnemer:"]
[null,"Pensioennr deelnemer:",null,null,"berekening premie Anw-hiaatpensioen 2026"]
[null,"Geboortedatum deelnemer:"]
[null,"Geboortedatum partner:"]
[null,"Verzekerd bedrag:",null,null,{"$f":"\"Voor nieuwe deelnemers zijn er vanaf 1-1-2026 drie ANW-hiaat bedragen te kiezen: € 9.700, € 15.600 en € 21.500\"","v":"Voor nieuwe deelnemers zijn er vanaf 1-1-2026 drie ANW-hiaat bedragen te kiezen: € 9.700, € 15.600 en € 21.500"}]
[]
[]
[]
[]
[]
[]
["Uitvoer:","Brutopremie per jaar:",{"$f":"IFERROR(Berekening!B23*Legaliteit,\"\")","v":""}]
[null,"Brutopremie per maand:",{"$f":"IFERROR(Berekening!B24*Legaliteit,\"\")","v":""}]
[null,"Brutopremie per 4wk:",{"$f":"IFERROR(Berekening!B25*Legaliteit,\"\")","v":""}]
[null,{"$f":"Berekening!A15","v":"factor koopsom (leeftijd partner)"},{"$f":"Berekening!B15","v":0}]
[null,{"$f":"Berekening!A16","v":"factor premie (leeftijd deelnemer)"},{"$f":"Berekening!B16","v":{"$error":"#N/A"}}]

{"sheet":"Input and Output","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,4,5,7],[8,4,9,7]]}
[]
["Input:"]
[]
[null,"Commencement date ANW:"]
[null,"Name participant:"]
[null,"Pension number participant:",null,null,"Calculation premium additional partner pension (Anw gap) 2026"]
[null,"Date of birth participant:"]
[null,"Date of birth partner:"]
[null,"Insured amount:",null,null,{"$f":"\"For new participants there are three Anw gap pension amounts to choose from as of 1-1-2026: € 9,700, € 15,600 and € 21,500\"","v":"For new participants there are three Anw gap pension amounts to choose from as of 1-1-2026: € 9,700, € 15,600 and € 21,500"}]
[]
[]
[]
[]
[]
[]
["Output:","Gross premium per year:",{"$f":"IFERROR(Berekening!H23*Legaliteit,\"\")","v":""}]
[null,"Gross premium per month:",{"$f":"IFERROR(Berekening!H24*Legaliteit,\"\")","v":""}]
[null,"Gross premium per 4 weeks:",{"$f":"IFERROR(Berekening!H25*Legaliteit,\"\")","v":""}]
[null,{"$f":"Berekening!A15","v":"factor koopsom (leeftijd partner)"},{"$f":"Berekening!B15","v":0}]
[null,{"$f":"Berekening!A16","v":"factor premie (leeftijd deelnemer)"},{"$f":"Berekening!B16","v":{"$error":"#N/A"}}]

{"sheet":"Berekening","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Rekendatum:",{"$f":"rekdat","v":"00:00:00"},{"$f":"IF(B1<Variabelen!B21,0,1)","v":0},null,null,"Engelse variant:","Commence Date",{"$f":"Commencedate","v":"00:00:00"},{"$f":"IF(H1<Variabelen!B21,0,1)","v":0}]
[]
[]
[{"$f":"'Invoer en Uitvoer'!B5","v":"Naam deelnemer:"},{"$f":"'Invoer en Uitvoer'!C5","v":0},null,null,null,null,{"$f":"'Input and Output'!B5","v":"Name participant:"},{"$f":"'Input and Output'!C5","v":0}]
[{"$f":"'Invoer en Uitvoer'!B6","v":"Pensioennr deelnemer:"},{"$f":"'Invoer en Uitvoer'!C6","v":0},null,null,null,null,{"$f":"'Input and Output'!B6","v":"Pension number participant:"},{"$f":"'Input and Output'!C6","v":0}]
[{"$f":"'Invoer en Uitvoer'!B7","v":"Geboortedatum deelnemer:"},{"$f":"'Invoer en Uitvoer'!C7","v":"00:00:00"},{"$f":"IF(AND(B6>=Variabelen!D19,B6<=Variabelen!D20),1,0)","v":0},null,null,null,{"$f":"'Input and Output'!B7","v":"Date of birth participant:"},{"$f":"'Input and Output'!C7","v":"00:00:00"},{"$f":"IF(AND(H6>=Variabelen!D19,H6<=Variabelen!D20),1,0)","v":0}]
[{"$f":"'Invoer en Uitvoer'!B8","v":"Geboortedatum partner:"},{"$f":"'Invoer en Uitvoer'!C8","v":"00:00:00"},{"$f":"IF(AND(B7>=Variabelen!B19,B7<=Variabelen!B20),1,0)","v":0},null,null,null,{"$f":"'Input and Output'!B8","v":"Date of birth partner:"},{"$f":"'Input and Output'!C8","v":"00:00:00"},{"$f":"IF(AND(H7>=Variabelen!B19,H7<=Variabelen!B20),1,0)","v":0}]
[{"$f":"'Invoer en Uitvoer'!B9","v":"Verzekerd bedrag:"},{"$f":"'Invoer en Uitvoer'!C9","v":0},null,null,null,null,{"$f":"'Input and Output'!B9","v":"Insured amount:"},{"$f":"'Input and Output'!C9","v":0}]
["b_Verzekerd bedrag:",{"$f":"IF(ISNUMBER(MATCH(B8,Variabelen!B15:B17,0)),1,0)","v":0},{"$f":"IF(ISNUMBER(MATCH(B8,Variabelen!B15:B17,0)),1,0)","v":0},null,null,null,"Insured amount:",{"$f":"IF(ISNUMBER(MATCH(H8,Variabelen!B15:B17,0)),1,0)","v":0},{"$f":"IF(ISNUMBER(MATCH(H8,Variabelen!B15:B17,0)),1,0)","v":0}]
[]
[]
["Burgerlijke leeftijd deelnemer op 1 januari:",{"$f":"YEAR(B1)-YEAR(B6)-IF(AND(MONTH(B6)=1,DAY(B6)=1),0,1)","v":-1},null,null,null,null,"Age participant on the 1st of januari:",{"$f":"YEAR(H1)-YEAR(H6)-IF(AND(MONTH(H6)=1,DAY(H6)=1),0,1)","v":-1}]
["Burgerlijke leeftijd partner op 1 januari:",{"$f":"YEAR(B1)-YEAR(B7)-IF(AND(MONTH(B7)=1,DAY(B7)=1),0,1)","v":-1},null,null,null,null,"Age partner on the 1st of januari:",{"$f":"YEAR(H1)-YEAR(H7)-IF(AND(MONTH(H7)=1,DAY(H7)=1),0,1)","v":-1}]
[]
["factor koopsom (leeftijd partner)",{"$f":"IFERROR(VLOOKUP(B13,Variabelen!$A$25:$E$90,2,0),0)","v":0},null,null,null,null,"factor purchase price (age partner)",{"$f":"IFERROR(VLOOKUP(H13,Variabelen!$A$25:$E$90,2,0),0)","v":0}]
["factor premie (leeftijd deelnemer)",{"$f":"VLOOKUP(B12,Variabelen!$A$25:$E$90,3,0)","v":{"$error":"#N/A"}},null,null,null,null,"factor purchase price (age participant)",{"$f":"VLOOKUP(H12,Variabelen!$A$25:$E$90,3,0)","v":{"$error":"#N/A"}}]
[]
["OVL risicokapitaal:",{"$f":"B15*B8","v":0},null,null,null,null,"Death risk capital:",{"$f":"H15*H8","v":0}]
["OVL risicokapitaal / 1000:",{"$f":"B18/1000","v":0},null,null,null,null,"Death risk capital / 1000:",{"$f":"H18/1000","v":0}]
[null,null,{"$f":"C6*C7*C9","v":0},null,null,null,null,null,{"$f":"I6*I7*I9","v":0}]
[]
[]
["Premie per jaar",{"$f":"B19*B16*C20","v":{"$error":"#N/A"}},null,{"$f":"B19*B16*C20","v":{"$error":"#N/A"}},null,null,"Gross premium per year:",{"$f":"H19*H16*I20","v":{"$error":"#N/A"}}]
["Premie per maand",{"$f":"(B23/12)*C20","v":{"$error":"#N/A"}},null,null,null,null,"Gross premium per month:",{"$f":"(H23/12)*I20","v":{"$error":"#N/A"}}]
["Premie per 4wk",{"$f":"(B23/13)*C20","v":{"$error":"#N/A"}},null,null,null,null,"Gross premium per 4 weeks:",{"$f":"(H23/13)*I20","v":{"$error":"#N/A"}}]

{"sheet":"Legaliteit","index":4,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Dit tabblad wordt verborgen"]
["Op het tabblad Legaliteit komen de toegestane paden te staan"]
["Staat de sheet op een andere locatie dan worden de uitkomsten met nul vermenigvuldigd"]
[]
["Naam sheet: ","PME_ANW Premie berekening_2026 versie 1.0"]
[]
[]
["Toegestane locaties"]
["S:\\Pensioenuitvoering_Rekensheets\\Algemene rekensheets\\",{"$f":"A9&\"[\"&$B$5&\".xlsm]Legaliteit\"","v":"S:\\Pensioenuitvoering_Rekensheets\\Algemene rekensheets\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"}]
["S:\\Deelnemersdesk_Testversies_rekensheets_Seniordesk\\Algemeen\\",{"$f":"A10&\"[\"&$B$5&\".xlsm]Legaliteit\"","v":"S:\\Deelnemersdesk_Testversies_rekensheets_Seniordesk\\Algemeen\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"}]
["S:\\Deelnemersdesk_Testversies_rekensheets_Seniordesk\\PME\\","S:\\Deelnemersdesk_Testversies_rekensheets_Seniordesk\\PME\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_Rekensheets\\PME\\","S:\\Pensioenuitvoering_Rekensheets\\PME\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_rekensheets_pme\\","S:\\Pensioenuitvoering_rekensheets_pme\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["X:\\Finance\\Actuariaat\\Fondsen\\PME\\Rekensheets en berekeningen\\Individuele berekeningen\\ANW premie\\",{"$f":"A14&\"[\"&$B$5&\".xlsm]Legaliteit\"","v":"X:\\Finance\\Actuariaat\\Fondsen\\PME\\Rekensheets en berekeningen\\Individuele berekeningen\\ANW premie\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"}]
["X:\\PenI\\PME\\003 Reglementen\\Premie Rekensheets","X:\\PenI\\PME\\003 Reglementen\\Premie Rekensheets[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_Rekensheets\\PME\\archief\\","S:\\Pensioenuitvoering_Rekensheets\\PME\\archief\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Deelnemersdesk_PME\\","S:\\Deelnemersdesk_PME\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_Rekensheets\\PME\\Obbing.t\\Testmap\\","S:\\Pensioenuitvoering_Rekensheets\\PME\\Obbing.t\\Testmap\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_Rekensheets\\PME\\Dorren.m\\Testmap\\","S:\\Pensioenuitvoering_Rekensheets\\PME\\Dorren.m\\Testmap\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_rekensheets_pme\\Obbing.t\\Testmap\\","S:\\Pensioenuitvoering_rekensheets_pme\\Obbing.t\\Testmap\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
["S:\\Pensioenuitvoering_rekensheets_pme\\Dorren.m\\Testmap\\","S:\\Pensioenuitvoering_rekensheets_pme\\Dorren.m\\Testmap\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"]
[]
["Huidige Locatie ",{"$f":"CELL(\"bestandsnaam\",A1)","v":"X:\\Finance\\Actuariaat\\Fondsen\\PME\\Rekensheets en berekeningen\\Individuele berekeningen\\ANW premie\\[PME_ANW Premie berekening_2026 versie 1.0.xlsm]Legaliteit"}]
[]
[null,1]

{"sheet":"Variabelen","index":5,"n_rows":816,"n_cols":12,"rows_kept":816,"cut":false,"hidden":true,"merged":[]}
["PME"]
["Bron: "]
["versienummer:","1.0 - 2026",null,null,null,null,"AOW Leeftijd"]
["datum:","2025-11-21",null,null,null,null,"Geboren uiterlijk","AOW-leeftijd","Aanvangsleeftijd",null,"Geboortedatum","AOW"]
["door: ","Ferry Goike",null,null,null,null,"2023-12-31",67.25,17,null,"1900-01-01",{"$f":"H16","v":65}]
["review:",null,null,null,null,null,"1960-12-31",67,17,null,{"$f":"G16+1","v":"1948-01-01"},{"$f":"H15","v":65.083333333333329}]
[null,null,null,null,null,null,"1957-02-28",66.8333333333333,16.8333333333333,null,{"$f":"G15+1","v":"1948-12-01"},{"$f":"H14","v":65.166666666666671}]
[null,null,null,null,null,null,"1956-05-31",66.5833333333333,16.5833333333333,null,{"$f":"G14+1","v":"1949-11-01"},{"$f":"H13","v":65.25}]
["Opslagen","excasso","solvabiliteit","pvi",null,null,"1955-08-31",66.333333333333329,16.333333333333329,null,{"$f":"G13+1","v":"1950-10-01"},{"$f":"H12","v":65.5}]
["2026-01-01",null,null,null,null,null,"1952-12-31",66,16,null,{"$f":"G12+1","v":"1951-07-01"},{"$f":"H11","v":65.75}]
[null,null,null,null,null,null,"1952-03-31",65.75,15.75,null,{"$f":"G11+1","v":"1952-04-01"},{"$f":"H10","v":66}]
[null,null,null,null,null,null,"1951-06-30",65.5,15.5,null,{"$f":"G10+1","v":"1953-01-01"},{"$f":"H9","v":66.333333333333329}]
[null,null,null,null,null,null,"1950-09-30",65.25,15.25,null,{"$f":"G9+1","v":"1955-09-01"},{"$f":"H8","v":66.5833333333333}]
[null,null,null,null,null,null,"1949-10-31",65.166666666666671,15.166666666666671,null,{"$f":"G8+1","v":"1956-06-01"},{"$f":"H7","v":66.8333333333333}]
["Hoogte ANW optie 1",21500,null,{"$f":"YEAR(rekdat)","v":1900},null,null,"1948-11-30",65.083333333333329,15.083333333333329,null,{"$f":"G7+1","v":"1957-03-01"},{"$f":"H6","v":67}]
["Hoogte ANW optie 2",15600,null,null,null,null,"1947-12-31",65,15,null,{"$f":"G6+1","v":"1961-01-01"},{"$f":"H5","v":67.25}]
["Hoogte ANW optie 3",9700]
[null,null,null,null,null,null,null,null,null,null,"AOW-leeftijd partner",{"$f":"VLOOKUP('Invoer en Uitvoer'!$C$8,$K$6:$L$16,2,TRUE)","v":{"$error":"#N/A"}}]
["Maximale geboortedatum partner 2026",{"$f":"IF(GeboortedatumPartner<DATE(1948,1,1),DATE(YEAR(rekdat)-64,MONTH(rekdat)-10,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1948,12,1),DATE(YEAR(rekdat)-64,MONTH(rekdat)-11,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1949,11,1),DATE(YEAR(rekdat)-65,MONTH(rekdat),DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1950,10,1),DATE(YEAR(rekdat)-65,MONTH(rekdat)-1,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1951,7,1),DATE(YEAR(rekdat)-65,MONTH(rekdat)-4,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1952,4,1),DATE(YEAR(rekdat)-65,MONTH(rekdat)-7,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1953,1,1),DATE(YEAR(rekdat)-65,MONTH(rekdat)-10,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1955,9,1),DATE(YEAR(rekdat)-66,MONTH(rekdat)-2,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1956,6,1),DATE(YEAR(rekdat)-66,MONTH(rekdat)-5,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1957,3,1),DATE(YEAR(rekdat)-66,MONTH(rekdat)-8,DAY(rekdat)),\nIF(GeboortedatumPartner<DATE(1961,1,1),DATE(YEAR(rekdat)-66,MONTH(rekdat)-10,DAY(rekdat)),DATE(YEAR(rekdat)-67,MONTH(rekdat)-1,DAY(rekdat)))))))))))))","v":"3735-02-28"},"Maximale geboortedatum deelnemer 2026",{"$f":"DATE(YEAR(rekdat)-80,MONTH(rekdat),1)","v":"3720-01-01"},null,null,null,null,null,null,"AOW-leeftijd jaar",{"$f":"INT(L18)","v":{"$error":"#N/A"}}]
["Minimale geboortedatum partner 2026",{"$f":"DATE(YEAR(rekdat)-15,MONTH(rekdat),1)","v":"3785-01-01"},"Minimale geboortedatum deelnemer 2026",{"$f":"DATE(YEAR(rekdat)-18,MONTH(rekdat),1)","v":"3782-01-01"},null,null,null,null,null,null,"AOW-leeftijd maand",{"$f":"(L18-L19)*12","v":{"$error":"#N/A"}}]
["Minimale Ingangsdatum",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-3,1)","v":"2025-09-01"},null,null,null,null,null,null,null,null,"AOW-datum partner",{"$f":"DATE(YEAR('Invoer en Uitvoer'!$C$8)+Variabelen!$L$19,MONTH('Invoer en Uitvoer'!$C$8)+Variabelen!$L$20,1)","v":{"$error":"#N/A"}}]
["premie"]
[]
["leeftijd","koopsomtarief (gebaseerd op leeftijd partner op 1-1)","premietarief (gebaseerd op leeftijd deelnemer op 1-1)",null,"Leeftijd maanden","koopsomtarief (gebaseerd op leeftijd partner op 1-1)","premietarief (gebaseerd op leeftijd deelnemer op 1-1)"]
[15,32.630000000000003,0.06,null,180,{"$f":"VLOOKUP(ROUNDDOWN($E25/12,0),$A$25:$C$90,2,0)","v":32.630000000000003},{"$f":"VLOOKUP(ROUNDDOWN($E25/12,0),$A$25:$C$90,3,0)","v":0.06}]
[16,32.299999999999997,0.09,null,181,{"$f":"VLOOKUP(ROUNDDOWN($E26/12,0),$A$25:$C$90,2,0)","v":32.630000000000003},{"$f":"VLOOKUP(ROUNDDOWN($E26/12,0),$A$25:$C$90,3,0)","v":0.06}]
[17,31.962,0.1,null,182,32.630000000000003,0.06]
[18,31.619,0.12,null,183,32.630000000000003,0.06]
[19,31.266999999999999,0.15,null,184,32.630000000000003,0.06]
[20,30.908999999999999,0.16,null,185,32.630000000000003,0.06]
[21,30.542999999999999,0.17,null,186,32.630000000000003,0.06]
[22,30.17,0.17,null,187,32.630000000000003,0.06]
[23,29.788,0.19,null,188,32.630000000000003,0.06]
[24,29.399000000000001,0.19,null,189,32.630000000000003,0.06]
[25,29.001000000000001,0.2,null,190,32.630000000000003,0.06]
[26,28.594999999999999,0.21,null,191,32.630000000000003,0.06]
[27,28.181000000000001,0.2,null,192,32.299999999999997,0.09]
[28,27.757999999999999,0.22,null,193,32.299999999999997,0.09]
[29,27.292000000000002,0.23,null,194,32.299999999999997,0.09]
[30,26.780999999999999,0.23,null,195,32.299999999999997,0.09]
[31,26.33,0.26,null,196,32.299999999999997,0.09]
[32,25.867999999999999,0.27,null,197,32.299999999999997,0.09]
[33,25.361000000000001,0.28000000000000003,null,198,32.299999999999997,0.09]
[34,24.805,0.3,null,199,32.299999999999997,0.09]
[35,24.312999999999999,0.32,null,200,32.299999999999997,0.09]
[36,23.811,0.34,null,201,32.299999999999997,0.09]
[37,23.219000000000001,0.37,null,202,32.299999999999997,0.09]
[38,22.655000000000001,0.39,null,203,32.299999999999997,0.09]
[39,22.12,0.44,null,204,31.962,0.1]
[40,21.574000000000002,0.47,null,205,31.962,0.1]
[41,20.888999999999999,0.52,null,206,31.962,0.1]
[42,20.32,0.57999999999999996,null,207,31.962,0.1]
[43,19.739999999999998,0.64,null,208,31.962,0.1]
[44,19.100999999999999,0.71,null,209,31.962,0.1]
[45,18.402000000000001,0.77,null,210,31.962,0.1]
[46,17.785,0.86,null,211,31.962,0.1]
[47,17.106999999999999,0.98,null,212,31.962,0.1]
[48,16.364999999999998,1.0900000000000001,null,213,31.962,0.1]
[49,15.71,1.21,null,214,31.962,0.1]
[50,14.936,1.34,null,215,31.962,0.1]
[51,14.2,1.51,null,216,31.619,0.12]
[52,13.505000000000001,1.68,null,217,31.619,0.12]
[53,12.797000000000001,1.89,null,218,31.619,0.12]
[54,11.901,2.08,null,219,31.619,0.12]
[55,11.161,2.37,null,220,31.619,0.12]
[56,10.345000000000001,2.6,null,221,31.619,0.12]
[57,9.4459999999999997,2.9,null,222,31.619,0.12]
[58,8.6579999999999995,3.24,null,223,31.619,0.12]
[59,7.8529999999999998,3.5,null,224,31.619,0.12]
[60,6.9630000000000001,3.94,null,225,31.619,0.12]
[61,5.9829999999999997,4.29,null,226,31.619,0.12]
[62,5.12,4.8,null,227,31.619,0.12]
[63,4.0910000000000002,5.34,null,228,31.266999999999999,0.15]
[64,3.11,5.88,null,229,31.266999999999999,0.15]
[65,2.1800000000000002,6.51,null,230,31.266999999999999,0.15]
[66,0.98599999999999999,7.15,null,231,31.266999999999999,0.15]
[67,0,7.96,null,232,31.266999999999999,0.15]
[68,0,8.8800000000000008,null,233,31.266999999999999,0.15]
[69,0,9.99,null,234,31.266999999999999,0.15]
[70,0,11.1,null,235,31.266999999999999,0.15]
[71,0,12.52,null,236,31.266999999999999,0.15]
[72,0,13.98,null,237,31.266999999999999,0.15]
[73,0,15.76,null,238,31.266999999999999,0.15]
[74,0,18.07,null,239,31.266999999999999,0.15]
[75,0,20.149999999999999,null,240,30.908999999999999,0.16]
[76,0,23.09,null,241,30.908999999999999,0.16]
[77,0,26.19,null,242,30.908999999999999,0.16]
[78,0,29.89,null,243,30.908999999999999,0.16]
[79,0,34.11,null,244,30.908999999999999,0.16]
[80,0,39.1,null,245,{"$f":"VLOOKUP(ROUNDDOWN($E90/12,0),$A$25:$C$90,2,0)","v":30.908999999999999},{"$f":"VLOOKUP(ROUNDDOWN($E90/12,0),$A$25:$C$90,3,0)","v":0.16}]
[null,null,null,null,246,30.908999999999999,0.16]
[null,null,null,null,247,30.908999999999999,0.16]
[null,null,null,null,248,30.908999999999999,0.16]
[null,null,null,null,249,30.908999999999999,0.16]
[null,null,null,null,250,30.908999999999999,0.16]
[null,null,null,null,251,30.908999999999999,0.16]
[null,null,null,null,252,30.542999999999999,0.17]
[null,null,null,null,253,30.542999999999999,0.17]
[null,null,null,null,254,30.542999999999999,0.17]
[null,null,null,null,255,30.542999999999999,0.17]
[null,null,null,null,256,30.542999999999999,0.17]
[null,null,null,null,257,30.542999999999999,0.17]
[null,null,null,null,258,30.542999999999999,0.17]
[null,null,null,null,259,30.542999999999999,0.17]
[null,null,null,null,260,30.542999999999999,0.17]
[null,null,null,null,261,30.542999999999999,0.17]
[null,null,null,null,262,30.542999999999999,0.17]
[null,null,null,null,263,30.542999999999999,0.17]
[null,null,null,null,264,30.17,0.17]
[null,null,null,null,265,30.17,0.17]
[null,null,null,null,266,30.17,0.17]
[null,null,null,null,267,30.17,0.17]
[null,null,null,null,268,30.17,0.17]
[null,null,null,null,269,30.17,0.17]
[null,null,null,null,270,30.17,0.17]
[null,null,null,null,271,30.17,0.17]
[null,null,null,null,272,30.17,0.17]
[null,null,null,null,273,30.17,0.17]
[null,null,null,null,274,30.17,0.17]
[null,null,null,null,275,30.17,0.17]
[null,null,null,null,276,29.788,0.19]
[null,null,null,null,277,29.788,0.19]
[null,null,null,null,278,29.788,0.19]
[null,null,null,null,279,29.788,0.19]
[null,null,null,null,280,29.788,0.19]
[null,null,null,null,281,29.788,0.19]
[null,null,null,null,282,29.788,0.19]
[null,null,null,null,283,29.788,0.19]
[null,null,null,null,284,29.788,0.19]
[null,null,null,null,285,29.788,0.19]
[null,null,null,null,286,29.788,0.19]
[null,null,null,null,287,29.788,0.19]
[null,null,null,null,288,29.399000000000001,0.19]
[null,null,null,null,289,29.399000000000001,0.19]
[null,null,null,null,290,29.399000000000001,0.19]
[null,null,null,null,291,29.399000000000001,0.19]
[null,null,null,null,292,29.399000000000001,0.19]
[null,null,null,null,293,29.399000000000001,0.19]
[null,null,null,null,294,29.399000000000001,0.19]
[null,null,null,null,295,29.399000000000001,0.19]
[null,null,null,null,296,29.399000000000001,0.19]
[null,null,null,null,297,29.399000000000001,0.19]
[null,null,null,null,298,29.399000000000001,0.19]
[null,null,null,null,299,29.399000000000001,0.19]
[null,null,null,null,300,29.001000000000001,0.2]
[null,null,null,null,301,29.001000000000001,0.2]
[null,null,null,null,302,29.001000000000001,0.2]
[null,null,null,null,303,29.001000000000001,0.2]
[null,null,null,null,304,29.001000000000001,0.2]
[null,null,null,null,305,29.001000000000001,0.2]
[null,null,null,null,306,29.001000000000001,0.2]
[null,null,null,null,307,29.001000000000001,0.2]
[null,null,null,null,308,29.001000000000001,0.2]
[null,null,null,null,309,{"$f":"VLOOKUP(ROUNDDOWN($E154/12,0),$A$25:$C$90,2,0)","v":29.001000000000001},{"$f":"VLOOKUP(ROUNDDOWN($E154/12,0),$A$25:$C$90,3,0)","v":0.2}]
[null,null,null,null,310,29.001000000000001,0.2]
[null,null,null,null,311,29.001000000000001,0.2]
[null,null,null,null,312,28.594999999999999,0.21]
[null,null,null,null,313,28.594999999999999,0.21]
[null,null,null,null,314,28.594999999999999,0.21]
[null,null,null,null,315,28.594999999999999,0.21]
[null,null,null,null,316,28.594999999999999,0.21]
[null,null,null,null,317,28.594999999999999,0.21]
[null,null,null,null,318,28.594999999999999,0.21]
[null,null,null,null,319,28.594999999999999,0.21]
[null,null,null,null,320,28.594999999999999,0.21]
[null,null,null,null,321,28.594999999999999,0.21]
[null,null,null,null,322,28.594999999999999,0.21]
[null,null,null,null,323,28.594999999999999,0.21]
[null,null,null,null,324,28.181000000000001,0.2]
[null,null,null,null,325,28.181000000000001,0.2]
[null,null,null,null,326,28.181000000000001,0.2]
[null,null,null,null,327,28.181000000000001,0.2]
[null,null,null,null,328,28.181000000000001,0.2]
[null,null,null,null,329,28.181000000000001,0.2]
[null,null,null,null,330,28.181000000000001,0.2]
[null,null,null,null,331,28.181000000000001,0.2]
[null,null,null,null,332,28.181000000000001,0.2]
[null,null,null,null,333,28.181000000000001,0.2]
[null,null,null,null,334,28.181000000000001,0.2]
[null,null,null,null,335,28.181000000000001,0.2]
[null,null,null,null,336,27.757999999999999,0.22]
[null,null,null,null,337,27.757999999999999,0.22]
[null,null,null,null,338,27.757999999999999,0.22]
[null,null,null,null,339,27.757999999999999,0.22]
[null,null,null,null,340,27.757999999999999,0.22]
[null,null,null,null,341,27.757999999999999,0.22]
[null,null,null,null,342,27.757999999999999,0.22]
[null,null,null,null,343,27.757999999999999,0.22]
[null,null,null,null,344,27.757999999999999,0.22]
[null,null,null,null,345,27.757999999999999,0.22]
[null,null,null,null,346,27.757999999999999,0.22]
[null,null,null,null,347,27.757999999999999,0.22]
[null,null,null,null,348,27.292000000000002,0.23]
[null,null,null,null,349,27.292000000000002,0.23]
[null,null,null,null,350,27.292000000000002,0.23]
[null,null,null,null,351,27.292000000000002,0.23]
[null,null,null,null,352,27.292000000000002,0.23]
[null,null,null,null,353,27.292000000000002,0.23]
[null,null,null,null,354,27.292000000000002,0.23]
[null,null,null,null,355,27.292000000000002,0.23]
[null,null,null,null,356,27.292000000000002,0.23]
[null,null,null,null,357,27.292000000000002,0.23]
[null,null,null,null,358,27.292000000000002,0.23]
[null,null,null,null,359,27.292000000000002,0.23]
[null,null,null,null,360,26.780999999999999,0.23]
[null,null,null,null,361,26.780999999999999,0.23]
[null,null,null,null,362,26.780999999999999,0.23]
[null,null,null,null,363,26.780999999999999,0.23]
[null,null,null,null,364,26.780999999999999,0.23]
[null,null,null,null,365,26.780999999999999,0.23]
[null,null,null,null,366,26.780999999999999,0.23]
[null,null,null,null,367,26.780999999999999,0.23]
[null,null,null,null,368,26.780999999999999,0.23]
[null,null,null,null,369,26.780999999999999,0.23]
[null,null,null,null,370,26.780999999999999,0.23]
[null,null,null,null,371,26.780999999999999,0.23]
[null,null,null,null,372,26.33,0.26]
[null,null,null,null,373,{"$f":"VLOOKUP(ROUNDDOWN($E218/12,0),$A$25:$C$90,2,0)","v":26.33},{"$f":"VLOOKUP(ROUNDDOWN($E218/12,0),$A$25:$C$90,3,0)","v":0.26}]
[null,null,null,null,374,26.33,0.26]
[null,null,null,null,375,26.33,0.26]
[null,null,null,null,376,26.33,0.26]
[null,null,null,null,377,26.33,0.26]
[null,null,null,null,378,26.33,0.26]
[null,null,null,null,379,26.33,0.26]
[null,null,null,null,380,26.33,0.26]
[null,null,null,null,381,26.33,0.26]
[null,null,null,null,382,26.33,0.26]
[null,null,null,null,383,26.33,0.26]
[null,null,null,null,384,25.867999999999999,0.27]
[null,null,null,null,385,25.867999999999999,0.27]
[null,null,null,null,386,25.867999999999999,0.27]
[null,null,null,null,387,25.867999999999999,0.27]
[null,null,null,null,388,25.867999999999999,0.27]
[null,null,null,null,389,25.867999999999999,0.27]
[null,null,null,null,390,25.867999999999999,0.27]
[null,null,null,null,391,25.867999999999999,0.27]
[null,null,null,null,392,25.867999999999999,0.27]
[null,null,null,null,393,25.867999999999999,0.27]
[null,null,null,null,394,25.867999999999999,0.27]
[null,null,null,null,395,25.867999999999999,0.27]
[null,null,null,null,396,25.361000000000001,0.28000000000000003]
[null,null,null,null,397,25.361000000000001,0.28000000000000003]
[null,null,null,null,398,25.361000000000001,0.28000000000000003]
[null,null,null,null,399,25.361000000000001,0.28000000000000003]
[null,null,null,null,400,25.361000000000001,0.28000000000000003]
[null,null,null,null,401,25.361000000000001,0.28000000000000003]
[null,null,null,null,402,25.361000000000001,0.28000000000000003]
[null,null,null,null,403,25.361000000000001,0.28000000000000003]
[null,null,null,null,404,25.361000000000001,0.28000000000000003]
[null,null,null,null,405,25.361000000000001,0.28000000000000003]
[null,null,null,null,406,25.361000000000001,0.28000000000000003]
[null,null,null,null,407,25.361000000000001,0.28000000000000003]
[null,null,null,null,408,24.805,0.3]
[null,null,null,null,409,24.805,0.3]
[null,null,null,null,410,24.805,0.3]
[null,null,null,null,411,24.805,0.3]
[null,null,null,null,412,24.805,0.3]
[null,null,null,null,413,24.805,0.3]
[null,null,null,null,414,24.805,0.3]
[null,null,null,null,415,24.805,0.3]
[null,null,null,null,416,24.805,0.3]
[null,null,null,null,417,24.805,0.3]
[null,null,null,null,418,24.805,0.3]
[null,null,null,null,419,24.805,0.3]
[null,null,null,null,420,24.312999999999999,0.32]
[null,null,null,null,421,24.312999999999999,0.32]
[null,null,null,null,422,24.312999999999999,0.32]
[null,null,null,null,423,24.312999999999999,0.32]
[null,null,null,null,424,24.312999999999999,0.32]
[null,null,null,null,425,24.312999999999999,0.32]
[null,null,null,null,426,24.312999999999999,0.32]
[null,null,null,null,427,24.312999999999999,0.32]
[null,null,null,null,428,24.312999999999999,0.32]
[null,null,null,null,429,24.312999999999999,0.32]
[null,null,null,null,430,24.312999999999999,0.32]
[null,null,null,null,431,24.312999999999999,0.32]
[null,null,null,null,432,23.811,0.34]
[null,null,null,null,433,23.811,0.34]
[null,null,null,null,434,23.811,0.34]
[null,null,null,null,435,23.811,0.34]
[null,null,null,null,436,23.811,0.34]
[null,null,null,null,437,{"$f":"VLOOKUP(ROUNDDOWN($E282/12,0),$A$25:$C$90,2,0)","v":23.811},{"$f":"VLOOKUP(ROUNDDOWN($E282/12,0),$A$25:$C$90,3,0)","v":0.34}]
[null,null,null,null,438,23.811,0.34]
[null,null,null,null,439,23.811,0.34]
[null,null,null,null,440,23.811,0.34]
[null,null,null,null,441,23.811,0.34]
[null,null,null,null,442,23.811,0.34]
[null,null,null,null,443,23.811,0.34]
[null,null,null,null,444,23.219000000000001,0.37]
[null,null,null,null,445,23.219000000000001,0.37]
[null,null,null,null,446,23.219000000000001,0.37]
[null,null,null,null,447,23.219000000000001,0.37]
[null,null,null,null,448,23.219000000000001,0.37]
[null,null,null,null,449,23.219000000000001,0.37]
[null,null,null,null,450,23.219000000000001,0.37]
[null,null,null,null,451,23.219000000000001,0.37]
[null,null,null,null,452,23.219000000000001,0.37]
[null,null,null,null,453,23.219000000000001,0.37]
[null,null,null,null,454,23.219000000000001,0.37]
[null,null,null,null,455,23.219000000000001,0.37]
[null,null,null,null,456,22.655000000000001,0.39]
[null,null,null,null,457,22.655000000000001,0.39]
[null,null,null,null,458,22.655000000000001,0.39]
[null,null,null,null,459,22.655000000000001,0.39]
[null,null,null,null,460,22.655000000000001,0.39]
[null,null,null,null,461,22.655000000000001,0.39]
[null,null,null,null,462,22.655000000000001,0.39]
[null,null,null,null,463,22.655000000000001,0.39]
[null,null,null,null,464,22.655000000000001,0.39]
[null,null,null,null,465,22.655000000000001,0.39]
[null,null,null,null,466,22.655000000000001,0.39]
[null,null,null,null,467,22.655000000000001,0.39]
[null,null,null,null,468,22.12,0.44]
[null,null,null,null,469,22.12,0.44]
[null,null,null,null,470,22.12,0.44]
[null,null,null,null,471,22.12,0.44]
[null,null,null,null,472,22.12,0.44]
[null,null,null,null,473,22.12,0.44]
[null,null,null,null,474,22.12,0.44]
[null,null,null,null,475,22.12,0.44]
[null,null,null,null,476,22.12,0.44]
[null,null,null,null,477,22.12,0.44]
[null,null,null,null,478,22.12,0.44]
[null,null,null,null,479,22.12,0.44]
[null,null,null,null,480,21.574000000000002,0.47]
[null,null,null,null,481,21.574000000000002,0.47]
[null,null,null,null,482,21.574000000000002,0.47]
[null,null,null,null,483,21.574000000000002,0.47]
[null,null,null,null,484,21.574000000000002,0.47]
[null,null,null,null,485,21.574000000000002,0.47]
[null,null,null,null,486,21.574000000000002,0.47]
[null,null,null,null,487,21.574000000000002,0.47]
[null,null,null,null,488,21.574000000000002,0.47]
[null,null,null,null,489,21.574000000000002,0.47]
[null,null,null,null,490,21.574000000000002,0.47]
[null,null,null,null,491,21.574000000000002,0.47]
[null,null,null,null,492,20.888999999999999,0.52]
[null,null,null,null,493,20.888999999999999,0.52]
[null,null,null,null,494,20.888999999999999,0.52]
[null,null,null,null,495,20.888999999999999,0.52]
[null,null,null,null,496,20.888999999999999,0.52]
[null,null,null,null,497,20.888999999999999,0.52]
[null,null,null,null,498,20.888999999999999,0.52]
[null,null,null,null,499,20.888999999999999,0.52]
[null,null,null,null,500,20.888999999999999,0.52]
[null,null,null,null,501,{"$f":"VLOOKUP(ROUNDDOWN($E346/12,0),$A$25:$C$90,2,0)","v":20.888999999999999},{"$f":"VLOOKUP(ROUNDDOWN($E346/12,0),$A$25:$C$90,3,0)","v":0.52}]
[null,null,null,null,502,20.888999999999999,0.52]
[null,null,null,null,503,20.888999999999999,0.52]
[null,null,null,null,504,20.32,0.57999999999999996]
[null,null,null,null,505,20.32,0.57999999999999996]
[null,null,null,null,506,20.32,0.57999999999999996]
[null,null,null,null,507,20.32,0.57999999999999996]
[null,null,null,null,508,20.32,0.57999999999999996]
[null,null,null,null,509,20.32,0.57999999999999996]
[null,null,null,null,510,20.32,0.57999999999999996]
[null,null,null,null,511,20.32,0.57999999999999996]
[null,null,null,null,512,20.32,0.57999999999999996]
[null,null,null,null,513,20.32,0.57999999999999996]
[null,null,null,null,514,20.32,0.57999999999999996]
[null,null,null,null,515,20.32,0.57999999999999996]
[null,null,null,null,516,19.739999999999998,0.64]
[null,null,null,null,517,19.739999999999998,0.64]
[null,null,null,null,518,19.739999999999998,0.64]
[null,null,null,null,519,19.739999999999998,0.64]
[null,null,null,null,520,19.739999999999998,0.64]
[null,null,null,null,521,19.739999999999998,0.64]
[null,null,null,null,522,19.739999999999998,0.64]
[null,null,null,null,523,19.739999999999998,0.64]
[null,null,null,null,524,19.739999999999998,0.64]
[null,null,null,null,525,19.739999999999998,0.64]
[null,null,null,null,526,19.739999999999998,0.64]
[null,null,null,null,527,19.739999999999998,0.64]
[null,null,null,null,528,19.100999999999999,0.71]
[null,null,null,null,529,19.100999999999999,0.71]
[null,null,null,null,530,19.100999999999999,0.71]
[null,null,null,null,531,19.100999999999999,0.71]
[null,null,null,null,532,19.100999999999999,0.71]
[null,null,null,null,533,19.100999999999999,0.71]
[null,null,null,null,534,19.100999999999999,0.71]
[null,null,null,null,535,19.100999999999999,0.71]
[null,null,null,null,536,19.100999999999999,0.71]
[null,null,null,null,537,19.100999999999999,0.71]
[null,null,null,null,538,19.100999999999999,0.71]
[null,null,null,null,539,19.100999999999999,0.71]
[null,null,null,null,540,18.402000000000001,0.77]
[null,null,null,null,541,18.402000000000001,0.77]
[null,null,null,null,542,18.402000000000001,0.77]
[null,null,null,null,543,18.402000000000001,0.77]
[null,null,null,null,544,18.402000000000001,0.77]
[null,null,null,null,545,18.402000000000001,0.77]
[null,null,null,null,546,18.402000000000001,0.77]
[null,null,null,null,547,18.402000000000001,0.77]
[null,null,null,null,548,18.402000000000001,0.77]
[null,null,null,null,549,18.402000000000001,0.77]
[null,null,null,null,550,18.402000000000001,0.77]
[null,null,null,null,551,18.402000000000001,0.77]
[null,null,null,null,552,17.785,0.86]
[null,null,null,null,553,17.785,0.86]
[null,null,null,null,554,17.785,0.86]
[null,null,null,null,555,17.785,0.86]
[null,null,null,null,556,17.785,0.86]
[null,null,null,null,557,17.785,0.86]
[null,null,null,null,558,17.785,0.86]
[null,null,null,null,559,17.785,0.86]
[null,null,null,null,560,17.785,0.86]
[null,null,null,null,561,17.785,0.86]
[null,null,null,null,562,17.785,0.86]
[null,null,null,null,563,17.785,0.86]
[null,null,null,null,564,17.106999999999999,0.98]
[null,null,null,null,565,{"$f":"VLOOKUP(ROUNDDOWN($E410/12,0),$A$25:$C$90,2,0)","v":17.106999999999999},{"$f":"VLOOKUP(ROUNDDOWN($E410/12,0),$A$25:$C$90,3,0)","v":0.98}]
[null,null,null,null,566,17.106999999999999,0.98]
[null,null,null,null,567,17.106999999999999,0.98]
[null,null,null,null,568,17.106999999999999,0.98]
[null,null,null,null,569,17.106999999999999,0.98]
[null,null,null,null,570,17.106999999999999,0.98]
[null,null,null,null,571,17.106999999999999,0.98]
[null,null,null,null,572,17.106999999999999,0.98]
[null,null,null,null,573,17.106999999999999,0.98]
[null,null,null,null,574,17.106999999999999,0.98]
[null,null,null,null,575,17.106999999999999,0.98]
[null,null,null,null,576,16.364999999999998,1.0900000000000001]
[null,null,null,null,577,16.364999999999998,1.0900000000000001]
[null,null,null,null,578,16.364999999999998,1.0900000000000001]
[null,null,null,null,579,16.364999999999998,1.0900000000000001]
[null,null,null,null,580,16.364999999999998,1.0900000000000001]
[null,null,null,null,581,16.364999999999998,1.0900000000000001]
[null,null,null,null,582,16.364999999999998,1.0900000000000001]
[null,null,null,null,583,16.364999999999998,1.0900000000000001]
[null,null,null,null,584,16.364999999999998,1.0900000000000001]
[null,null,null,null,585,16.364999999999998,1.0900000000000001]
[null,null,null,null,586,16.364999999999998,1.0900000000000001]
[null,null,null,null,587,16.364999999999998,1.0900000000000001]
[null,null,null,null,588,15.71,1.21]
[null,null,null,null,589,15.71,1.21]
[null,null,null,null,590,15.71,1.21]
[null,null,null,null,591,15.71,1.21]
[null,null,null,null,592,15.71,1.21]
[null,null,null,null,593,15.71,1.21]
[null,null,null,null,594,15.71,1.21]
[null,null,null,null,595,15.71,1.21]
[null,null,null,null,596,15.71,1.21]
[null,null,null,null,597,15.71,1.21]
[null,null,null,null,598,15.71,1.21]
[null,null,null,null,599,15.71,1.21]
[null,null,null,null,600,14.936,1.34]
[null,null,null,null,601,14.936,1.34]
[null,null,null,null,602,14.936,1.34]
[null,null,null,null,603,14.936,1.34]
[null,null,null,null,604,14.936,1.34]
[null,null,null,null,605,14.936,1.34]
[null,null,null,null,606,14.936,1.34]
[null,null,null,null,607,14.936,1.34]
[null,null,null,null,608,14.936,1.34]
[null,null,null,null,609,14.936,1.34]
[null,null,null,null,610,14.936,1.34]
[null,null,null,null,611,14.936,1.34]
[null,null,null,null,612,14.2,1.51]
[null,null,null,null,613,14.2,1.51]
[null,null,null,null,614,14.2,1.51]
[null,null,null,null,615,14.2,1.51]
[null,null,null,null,616,14.2,1.51]
[null,null,null,null,617,14.2,1.51]
[null,null,null,null,618,14.2,1.51]
[null,null,null,null,619,14.2,1.51]
[null,null,null,null,620,14.2,1.51]
[null,null,null,null,621,14.2,1.51]
[null,null,null,null,622,14.2,1.51]
[null,null,null,null,623,14.2,1.51]
[null,null,null,null,624,13.505000000000001,1.68]
[null,null,null,null,625,13.505000000000001,1.68]
[null,null,null,null,626,13.505000000000001,1.68]
[null,null,null,null,627,13.505000000000001,1.68]
[null,null,null,null,628,13.505000000000001,1.68]
[null,null,null,null,629,{"$f":"VLOOKUP(ROUNDDOWN($E474/12,0),$A$25:$C$90,2,0)","v":13.505000000000001},{"$f":"VLOOKUP(ROUNDDOWN($E474/12,0),$A$25:$C$90,3,0)","v":1.68}]
[null,null,null,null,630,13.505000000000001,1.68]
[null,null,null,null,631,13.505000000000001,1.68]
[null,null,null,null,632,13.505000000000001,1.68]
[null,null,null,null,633,13.505000000000001,1.68]
[null,null,null,null,634,13.505000000000001,1.68]
[null,null,null,null,635,13.505000000000001,1.68]
[null,null,null,null,636,12.797000000000001,1.89]
[null,null,null,null,637,12.797000000000001,1.89]
[null,null,null,null,638,12.797000000000001,1.89]
[null,null,null,null,639,12.797000000000001,1.89]
[null,null,null,null,640,12.797000000000001,1.89]
[null,null,null,null,641,12.797000000000001,1.89]
[null,null,null,null,642,12.797000000000001,1.89]
[null,null,null,null,643,12.797000000000001,1.89]
[null,null,null,null,644,12.797000000000001,1.89]
[null,null,null,null,645,12.797000000000001,1.89]
[null,null,null,null,646,12.797000000000001,1.89]
[null,null,null,null,647,12.797000000000001,1.89]
[null,null,null,null,648,11.901,2.08]
[null,null,null,null,649,11.901,2.08]
[null,null,null,null,650,11.901,2.08]
[null,null,null,null,651,11.901,2.08]
[null,null,null,null,652,11.901,2.08]
[null,null,null,null,653,11.901,2.08]
[null,null,null,null,654,11.901,2.08]
[null,null,null,null,655,11.901,2.08]
[null,null,null,null,656,11.901,2.08]
[null,null,null,null,657,11.901,2.08]
[null,null,null,null,658,11.901,2.08]
[null,null,null,null,659,11.901,2.08]
[null,null,null,null,660,11.161,2.37]
[null,null,null,null,661,11.161,2.37]
[null,null,null,null,662,11.161,2.37]
[null,null,null,null,663,11.161,2.37]
[null,null,null,null,664,11.161,2.37]
[null,null,null,null,665,11.161,2.37]
[null,null,null,null,666,11.161,2.37]
[null,null,null,null,667,11.161,2.37]
[null,null,null,null,668,11.161,2.37]
[null,null,null,null,669,11.161,2.37]
[null,null,null,null,670,11.161,2.37]
[null,null,null,null,671,11.161,2.37]
[null,null,null,null,672,10.345000000000001,2.6]
[null,null,null,null,673,10.345000000000001,2.6]
[null,null,null,null,674,10.345000000000001,2.6]
[null,null,null,null,675,10.345000000000001,2.6]
[null,null,null,null,676,10.345000000000001,2.6]
[null,null,null,null,677,10.345000000000001,2.6]
[null,null,null,null,678,10.345000000000001,2.6]
[null,null,null,null,679,10.345000000000001,2.6]
[null,null,null,null,680,10.345000000000001,2.6]
[null,null,null,null,681,10.345000000000001,2.6]
[null,null,null,null,682,10.345000000000001,2.6]
[null,null,null,null,683,10.345000000000001,2.6]
[null,null,null,null,684,9.4459999999999997,2.9]
[null,null,null,null,685,9.4459999999999997,2.9]
[null,null,null,null,686,9.4459999999999997,2.9]
[null,null,null,null,687,9.4459999999999997,2.9]
[null,null,null,null,688,9.4459999999999997,2.9]
[null,null,null,null,689,9.4459999999999997,2.9]
[null,null,null,null,690,9.4459999999999997,2.9]
[null,null,null,null,691,9.4459999999999997,2.9]
[null,null,null,null,692,9.4459999999999997,2.9]
[null,null,null,null,693,{"$f":"VLOOKUP(ROUNDDOWN($E538/12,0),$A$25:$C$90,2,0)","v":9.4459999999999997},{"$f":"VLOOKUP(ROUNDDOWN($E538/12,0),$A$25:$C$90,3,0)","v":2.9}]
[null,null,null,null,694,9.4459999999999997,2.9]
[null,null,null,null,695,9.4459999999999997,2.9]
[null,null,null,null,696,8.6579999999999995,3.24]
[null,null,null,null,697,8.6579999999999995,3.24]
[null,null,null,null,698,8.6579999999999995,3.24]
[null,null,null,null,699,8.6579999999999995,3.24]
[null,null,null,null,700,8.6579999999999995,3.24]
[null,null,null,null,701,8.6579999999999995,3.24]
[null,null,null,null,702,8.6579999999999995,3.24]
[null,null,null,null,703,8.6579999999999995,3.24]
[null,null,null,null,704,8.6579999999999995,3.24]
[null,null,null,null,705,8.6579999999999995,3.24]
[null,null,null,null,706,8.6579999999999995,3.24]
[null,null,null,null,707,8.6579999999999995,3.24]
[null,null,null,null,708,7.8529999999999998,3.5]
[null,null,null,null,709,7.8529999999999998,3.5]
[null,null,null,null,710,7.8529999999999998,3.5]
[null,null,null,null,711,7.8529999999999998,3.5]
[null,null,null,null,712,7.8529999999999998,3.5]
[null,null,null,null,713,7.8529999999999998,3.5]
[null,null,null,null,714,7.8529999999999998,3.5]
[null,null,null,null,715,7.8529999999999998,3.5]
[null,null,null,null,716,7.8529999999999998,3.5]
[null,null,null,null,717,7.8529999999999998,3.5]
[null,null,null,null,718,7.8529999999999998,3.5]
[null,null,null,null,719,7.8529999999999998,3.5]
[null,null,null,null,720,6.9630000000000001,3.94]
[null,null,null,null,721,6.9630000000000001,3.94]
[null,null,null,null,722,6.9630000000000001,3.94]
[null,null,null,null,723,6.9630000000000001,3.94]
[null,null,null,null,724,6.9630000000000001,3.94]
[null,null,null,null,725,6.9630000000000001,3.94]
[null,null,null,null,726,6.9630000000000001,3.94]
[null,null,null,null,727,6.9630000000000001,3.94]
[null,null,null,null,728,6.9630000000000001,3.94]
[null,null,null,null,729,6.9630000000000001,3.94]
[null,null,null,null,730,6.9630000000000001,3.94]
[null,null,null,null,731,6.9630000000000001,3.94]
[null,null,null,null,732,5.9829999999999997,4.29]
[null,null,null,null,733,5.9829999999999997,4.29]
[null,null,null,null,734,5.9829999999999997,4.29]
[null,null,null,null,735,5.9829999999999997,4.29]
[null,null,null,null,736,5.9829999999999997,4.29]
[null,null,null,null,737,5.9829999999999997,4.29]
[null,null,null,null,738,5.9829999999999997,4.29]
[null,null,null,null,739,5.9829999999999997,4.29]
[null,null,null,null,740,5.9829999999999997,4.29]
[null,null,null,null,741,5.9829999999999997,4.29]
[null,null,null,null,742,5.9829999999999997,4.29]
[null,null,null,null,743,5.9829999999999997,4.29]
[null,null,null,null,744,5.12,4.8]
[null,null,null,null,745,5.12,4.8]
[null,null,null,null,746,5.12,4.8]
[null,null,null,null,747,5.12,4.8]
[null,null,null,null,748,5.12,4.8]
[null,null,null,null,749,5.12,4.8]
[null,null,null,null,750,5.12,4.8]
[null,null,null,null,751,5.12,4.8]
[null,null,null,null,752,5.12,4.8]
[null,null,null,null,753,5.12,4.8]
[null,null,null,null,754,5.12,4.8]
[null,null,null,null,755,5.12,4.8]
[null,null,null,null,756,4.0910000000000002,5.34]
[null,null,null,null,757,{"$f":"VLOOKUP(ROUNDDOWN($E602/12,0),$A$25:$C$90,2,0)","v":4.0910000000000002},{"$f":"VLOOKUP(ROUNDDOWN($E602/12,0),$A$25:$C$90,3,0)","v":5.34}]
[null,null,null,null,758,4.0910000000000002,5.34]
[null,null,null,null,759,4.0910000000000002,5.34]
[null,null,null,null,760,4.0910000000000002,5.34]
[null,null,null,null,761,4.0910000000000002,5.34]
[null,null,null,null,762,4.0910000000000002,5.34]
[null,null,null,null,763,4.0910000000000002,5.34]
[null,null,null,null,764,4.0910000000000002,5.34]
[null,null,null,null,765,4.0910000000000002,5.34]
[null,null,null,null,766,4.0910000000000002,5.34]
[null,null,null,null,767,4.0910000000000002,5.34]
[null,null,null,null,768,3.11,5.88]
[null,null,null,null,769,3.11,5.88]
[null,null,null,null,770,3.11,5.88]
[null,null,null,null,771,3.11,5.88]
[null,null,null,null,772,3.11,5.88]
[null,null,null,null,773,3.11,5.88]
[null,null,null,null,774,3.11,5.88]
[null,null,null,null,775,3.11,5.88]
[null,null,null,null,776,3.11,5.88]
[null,null,null,null,777,3.11,5.88]
[null,null,null,null,778,3.11,5.88]
[null,null,null,null,779,3.11,5.88]
[null,null,null,null,780,2.1800000000000002,6.51]
[null,null,null,null,781,2.1800000000000002,6.51]
[null,null,null,null,782,2.1800000000000002,6.51]
[null,null,null,null,783,2.1800000000000002,6.51]
[null,null,null,null,784,2.1800000000000002,6.51]
[null,null,null,null,785,2.1800000000000002,6.51]
[null,null,null,null,786,2.1800000000000002,6.51]
[null,null,null,null,787,2.1800000000000002,6.51]
[null,null,null,null,788,2.1800000000000002,6.51]
[null,null,null,null,789,2.1800000000000002,6.51]
[null,null,null,null,790,2.1800000000000002,6.51]
[null,null,null,null,791,2.1800000000000002,6.51]
[null,null,null,null,792,0.98599999999999999,7.15]
[null,null,null,null,793,0.98599999999999999,7.15]
[null,null,null,null,794,0.98599999999999999,7.15]
[null,null,null,null,795,0.98599999999999999,7.15]
[null,null,null,null,796,0.98599999999999999,7.15]
[null,null,null,null,797,0.98599999999999999,7.15]
[null,null,null,null,798,0.98599999999999999,7.15]
[null,null,null,null,799,0.98599999999999999,7.15]
[null,null,null,null,800,0.98599999999999999,7.15]
[null,null,null,null,801,0.98599999999999999,7.15]
[null,null,null,null,802,0.98599999999999999,7.15]
[null,null,null,null,803,0.98599999999999999,7.15]
[null,null,null,null,804,0,7.96]
[null,null,null,null,805,0,7.96]
[null,null,null,null,806,0,7.96]
[null,null,null,null,807,0,7.96]
[null,null,null,null,808,0,7.96]
[null,null,null,null,809,0,7.96]
[null,null,null,null,810,0,7.96]
[null,null,null,null,811,0,7.96]
[null,null,null,null,812,0,7.96]
[null,null,null,null,813,0,7.96]
[null,null,null,null,814,0,7.96]
[null,null,null,null,815,0,7.96]
[null,null,null,null,816,0,8.8800000000000008]
[null,null,null,null,817,0,8.8800000000000008]
[null,null,null,null,818,0,8.8800000000000008]
[null,null,null,null,819,0,8.8800000000000008]
[null,null,null,null,820,0,8.8800000000000008]
[null,null,null,null,821,{"$f":"VLOOKUP(ROUNDDOWN($E666/12,0),$A$25:$C$90,2,0)","v":0},{"$f":"VLOOKUP(ROUNDDOWN($E666/12,0),$A$25:$C$90,3,0)","v":8.8800000000000008}]
[null,null,null,null,822,0,8.8800000000000008]
[null,null,null,null,823,0,8.8800000000000008]
[null,null,null,null,824,0,8.8800000000000008]
[null,null,null,null,825,0,8.8800000000000008]
[null,null,null,null,826,0,8.8800000000000008]
[null,null,null,null,827,0,8.8800000000000008]
[null,null,null,null,828,0,9.99]
[null,null,null,null,829,0,9.99]
[null,null,null,null,830,0,9.99]
[null,null,null,null,831,0,9.99]
[null,null,null,null,832,0,9.99]
[null,null,null,null,833,0,9.99]
[null,null,null,null,834,0,9.99]
[null,null,null,null,835,0,9.99]
[null,null,null,null,836,0,9.99]
[null,null,null,null,837,0,9.99]
[null,null,null,null,838,0,9.99]
[null,null,null,null,839,0,9.99]
[null,null,null,null,840,0,11.1]
[null,null,null,null,841,0,11.1]
[null,null,null,null,842,0,11.1]
[null,null,null,null,843,0,11.1]
[null,null,null,null,844,0,11.1]
[null,null,null,null,845,0,11.1]
[null,null,null,null,846,0,11.1]
[null,null,null,null,847,0,11.1]
[null,null,null,null,848,0,11.1]
[null,null,null,null,849,0,11.1]
[null,null,null,null,850,0,11.1]
[null,null,null,null,851,0,11.1]
[null,null,null,null,852,0,12.52]
[null,null,null,null,853,0,12.52]
[null,null,null,null,854,0,12.52]
[null,null,null,null,855,0,12.52]
[null,null,null,null,856,0,12.52]
[null,null,null,null,857,0,12.52]
[null,null,null,null,858,0,12.52]
[null,null,null,null,859,0,12.52]
[null,null,null,null,860,0,12.52]
[null,null,null,null,861,0,12.52]
[null,null,null,null,862,0,12.52]
[null,null,null,null,863,0,12.52]
[null,null,null,null,864,0,13.98]
[null,null,null,null,865,0,13.98]
[null,null,null,null,866,0,13.98]
[null,null,null,null,867,0,13.98]
[null,null,null,null,868,0,13.98]
[null,null,null,null,869,0,13.98]
[null,null,null,null,870,0,13.98]
[null,null,null,null,871,0,13.98]
[null,null,null,null,872,0,13.98]
[null,null,null,null,873,0,13.98]
[null,null,null,null,874,0,13.98]
[null,null,null,null,875,0,13.98]
[null,null,null,null,876,0,15.76]
[null,null,null,null,877,0,15.76]
[null,null,null,null,878,0,15.76]
[null,null,null,null,879,0,15.76]
[null,null,null,null,880,0,15.76]
[null,null,null,null,881,0,15.76]
[null,null,null,null,882,0,15.76]
[null,null,null,null,883,0,15.76]
[null,null,null,null,884,0,15.76]
[null,null,null,null,885,{"$f":"VLOOKUP(ROUNDDOWN($E730/12,0),$A$25:$C$90,2,0)","v":0},{"$f":"VLOOKUP(ROUNDDOWN($E730/12,0),$A$25:$C$90,3,0)","v":15.76}]
[null,null,null,null,886,0,15.76]
[null,null,null,null,887,0,15.76]
[null,null,null,null,888,0,18.07]
[null,null,null,null,889,0,18.07]
[null,null,null,null,890,0,18.07]
[null,null,null,null,891,0,18.07]
[null,null,null,null,892,0,18.07]
[null,null,null,null,893,0,18.07]
[null,null,null,null,894,0,18.07]
[null,null,null,null,895,0,18.07]
[null,null,null,null,896,0,18.07]
[null,null,null,null,897,0,18.07]
[null,null,null,null,898,0,18.07]
[null,null,null,null,899,0,18.07]
[null,null,null,null,900,0,20.149999999999999]
[null,null,null,null,901,0,20.149999999999999]
[null,null,null,null,902,0,20.149999999999999]
[null,null,null,null,903,0,20.149999999999999]
[null,null,null,null,904,0,20.149999999999999]
[null,null,null,null,905,0,20.149999999999999]
[null,null,null,null,906,0,20.149999999999999]
[null,null,null,null,907,0,20.149999999999999]
[null,null,null,null,908,0,20.149999999999999]
[null,null,null,null,909,0,20.149999999999999]
[null,null,null,null,910,0,20.149999999999999]
[null,null,null,null,911,0,20.149999999999999]
[null,null,null,null,912,0,23.09]
[null,null,null,null,913,0,23.09]
[null,null,null,null,914,0,23.09]
[null,null,null,null,915,0,23.09]
[null,null,null,null,916,0,23.09]
[null,null,null,null,917,0,23.09]
[null,null,null,null,918,0,23.09]
[null,null,null,null,919,0,23.09]
[null,null,null,null,920,0,23.09]
[null,null,null,null,921,0,23.09]
[null,null,null,null,922,0,23.09]
[null,null,null,null,923,0,23.09]
[null,null,null,null,924,0,26.19]
[null,null,null,null,925,0,26.19]
[null,null,null,null,926,0,26.19]
[null,null,null,null,927,0,26.19]
[null,null,null,null,928,0,26.19]
[null,null,null,null,929,0,26.19]
[null,null,null,null,930,0,26.19]
[null,null,null,null,931,0,26.19]
[null,null,null,null,932,0,26.19]
[null,null,null,null,933,0,26.19]
[null,null,null,null,934,0,26.19]
[null,null,null,null,935,0,26.19]
[null,null,null,null,936,0,29.89]
[null,null,null,null,937,0,29.89]
[null,null,null,null,938,0,29.89]
[null,null,null,null,939,0,29.89]
[null,null,null,null,940,0,29.89]
[null,null,null,null,941,0,29.89]
[null,null,null,null,942,0,29.89]
[null,null,null,null,943,0,29.89]
[null,null,null,null,944,0,29.89]
[null,null,null,null,945,0,29.89]
[null,null,null,null,946,0,29.89]
[null,null,null,null,947,0,29.89]
[null,null,null,null,948,0,34.11]
[null,null,null,null,949,{"$f":"VLOOKUP(ROUNDDOWN($E794/12,0),$A$25:$C$90,2,0)","v":0},{"$f":"VLOOKUP(ROUNDDOWN($E794/12,0),$A$25:$C$90,3,0)","v":34.11}]
[null,null,null,null,950,0,34.11]
[null,null,null,null,951,0,34.11]
[null,null,null,null,952,0,34.11]
[null,null,null,null,953,0,34.11]
[null,null,null,null,954,0,34.11]
[null,null,null,null,955,0,34.11]
[null,null,null,null,956,0,34.11]
[null,null,null,null,957,0,34.11]
[null,null,null,null,958,0,34.11]
[null,null,null,null,959,0,34.11]
[null,null,null,null,960,0,39.1]
[null,null,null,null,961,0,39.1]
[null,null,null,null,962,0,39.1]
[null,null,null,null,963,0,39.1]
[null,null,null,null,964,0,39.1]
[null,null,null,null,965,0,39.1]
[null,null,null,null,966,0,39.1]
[null,null,null,null,967,0,39.1]
[null,null,null,null,968,0,39.1]
[null,null,null,null,969,0,39.1]
[null,null,null,null,970,0,39.1]
[null,null,null,null,971,0,39.1]