{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["rb","ab","mb","bs","par"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":59,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"rb","index":0,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":true,"merged":[[23,12,24,12],[24,4,24,5],[24,6,24,7],[1,6,1,8],[3,4,3,6],[3,9,3,10],[11,3,11,4],[21,3,21,4],[22,3,22,4]]}
[]
[null,null,null,"UWV Afspiegelingstool 2017-01v2",null,null,"Rangordelijst",null,null,null,"2017-06-08T15:54:03"]
[]
[null,null,null,"Organisatie/Bedrijf: ","Test Meriant hiccups en gelijke dids",null,null,null,"Uitwisselbare functie: ","huishoudelijk medewerker"]
[]
[null,null,null,null,"Datum indiening ontslagaanvraag: ","2015-02-01",null,null,null,"Noodzakelijke krimp binnen alle 88 medewerkers: ",88]
[]
[null,null,null,null,"Peildatum: ","2015-02-01",null,null,null,"Rekenkrimp over alle 86 medewerkers niet uit dienst op de peildatum: ",86]
[]
[null,null,null,null,null,"LEEFTIJDSGROEPEN",null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,"15 t/m 24","25 t/m 34","35 t/m 44","45 t/m 54","55 en ouder","Totaal",null,null,null,0,0]
[null,null,null,"Medewerkers in dienst: ",null,6,11,23,23,23,{"$f":"SUM(F12:J12)","v":86},1,null,null,0,0]
[null,null,null,null,"Afspiegelingsberekening: ",{"$f":"(F12/$K12)*Krimp","v":6},{"$f":"(G12/$K12)*Krimp","v":11},{"$f":"(H12/$K12)*Krimp","v":22.999999999999996},{"$f":"(I12/$K12)*Krimp","v":22.999999999999996},{"$f":"(J12/$K12)*Krimp","v":22.999999999999996},{"$f":"SUM(F13:J13)","v":86},2]
[null,null,null,null,"Krimp obv voor de komma: ",{"$f":"TRUNC(F13)","v":6},{"$f":"TRUNC(G13)","v":11},{"$f":"TRUNC(H13)","v":23},{"$f":"TRUNC(I13)","v":23},{"$f":"TRUNC(J13)","v":23},{"$f":"SUM(F14:J14)","v":86},3]
[null,null,null,null,"Formule na de komma: ",{"$f":"TRUNC(MOD(F13,1)*100000)/100000","v":0},{"$f":"TRUNC(MOD(G13,1)*100000)/100000","v":0},{"$f":"TRUNC(MOD(H13,1)*100000)/100000","v":0.99999000000000005},0.99999000000000005,0.99999000000000005,{"$f":"SUM(F15:J15)","v":2.9999700000000002},4]
[null,null,null,null,"Volgnr leeftijdsgroepen: ",1,2,3,4,5,null,5]
[null,null,null,null,"Waarden na de komma: ",0,0,0.99999000000000005,0.99999000000000005,0.99999000000000005,null,6]
[null,null,null,null,"Datum in dienst: ","00:00:00","00:00:00","2013-03-01","2013-03-01",null,null,7]
[null,null,null,null,"Volgnr 1e medeweker: ",1,7,18,41,64,null,8]
[null,null,null,null,"Krimp obv na de komma: ",0,0,0,0,0,{"$f":"SUM(F20:J20)","v":0},9]
[null,null,null,null,"Totale krimp: ",{"$f":"F14+F20","v":6},{"$f":"G14+G20","v":11},{"$f":"H14+H20","v":23},{"$f":"I14+I20","v":23},{"$f":"J14+J20","v":23},{"$f":"SUM(F21:J21)","v":86},10]
[null,null,null,"Krimp  rangorde:  ",null,0,0,0,0,0,{"$f":"SUM(F22:J22)","v":0},11]
[null,null,null,"Krimp afspiegeling:  ",null,0,0,0,0,0,0,12]
[null,null,null,null,null,3,6,20,23,36,null,null,"Status op beslisdatum                   (1 mei 2015)"]
[null,null,null,"Leeftijdsgroep","Naam medewerker",null,"Functie",null,"Geboortedatum","Datum in dienst","Status op peildatum",null,null,null,"15-24","25-34","35-44","45-54","55+"]

{"sheet":"ab","index":1,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,6,1,8],[3,4,3,6],[23,12,24,12],[3,9,3,10],[11,3,11,4],[21,3,21,4],[22,3,22,4],[24,4,24,5],[24,6,24,7]]}
[]
[null,null,null,"UWV Afspiegelingstool 2017-01v2",null,null,"Resultaat Afspiegelingsberekening",null,null,null,"2019-08-23T11:35:47"]
[]
[null,null,null,"Organisatie/Bedrijf: ","Test Meriant hiccups en gelijke dids",null,null,null,"Uitwisselbare functie: ","huishoudelijk medewerker"]
[]
[null,null,null,null,"Datum indiening ontslagaanvraag: ","2015-02-01",null,null,null,"Noodzakelijke krimp binnen alle 88 medewerkers: ",12]
[]
[null,null,null,null,"Peildatum: ","2015-02-01",null,null,null,"Rekenkrimp over alle 86 medewerkers niet uit dienst op de peildatum: ",10]
[]
[null,null,null,null,null,"LEEFTIJDSGROEPEN"]
[null,null,null,null,null,"15 t/m 24","25 t/m 34","35 t/m 44","45 t/m 54","55 en ouder","Totaal"]
[null,null,null,"Medewerkers in dienst: ",null,6,11,23,23,23,{"$f":"SUM(F12:J12)","v":86}]
[null,null,null,null,"Afspiegelingsberekening: ",{"$f":"(F12/$K12)*Krimp","v":0.69767441860465118},{"$f":"(G12/$K12)*Krimp","v":1.2790697674418605},{"$f":"(H12/$K12)*Krimp","v":2.6744186046511627},{"$f":"(I12/$K12)*Krimp","v":2.6744186046511627},{"$f":"(J12/$K12)*Krimp","v":2.6744186046511627},{"$f":"SUM(F13:J13)","v":9.9999999999999982},null,null,null,null,"<->",null,"<->"]
[null,null,null,null,"Krimp obv voor de komma: ",{"$f":"TRUNC(F13)","v":0},{"$f":"TRUNC(G13)","v":1},{"$f":"TRUNC(H13)","v":2},{"$f":"TRUNC(I13)","v":2},{"$f":"TRUNC(J13)","v":2},{"$f":"SUM(F14:J14)","v":7},3]
[null,null,null,null,"Formule na de komma: ",{"$f":"TRUNC(MOD(F13,1)*100000)/100000","v":0.69767000000000001},{"$f":"TRUNC(MOD(G13,1)*100000)/100000","v":0.27905999999999997},{"$f":"TRUNC(MOD(H13,1)*100000)/100000","v":0.67440999999999995},0.67440999999999995,0.67440999999999995,{"$f":"SUM(F15:J15)","v":2.9999599999999997},4]
[null,null,null,null,"Volgnr leeftijdsgroepen: ",1,2,3,4,5,null,5]
[null,null,null,null,"Waarden na de komma: ",null,null,null,null,0,null,6]
[null,null,null,null,"Datum in dienst: ","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,7]
[null,null,null,null,"Volgnr 1e medeweker: ",0,0,0,0,0,null,8]
[null,null,null,null,"Krimp obv na de komma: ",5,5,5,5,5,{"$f":"SUM(F20:J20)","v":25},9]
[null,null,null,null,"Aangepaste afspiegeling: ",1,0,-1,-1,1,{"$f":"SUM(F21:J21)","v":0},10,null,null,null,"rangnr",null,"lftgroep"]
[null,null,null,"Krimp  volgens afspiegeling: ",null,1,1,3,3,2,{"$f":"SUM(F22:J22)","v":10},11,null,null,"1e hiccup"]
[null,null,null,"Krimp volgens rangorde: ",null,2,1,3,2,2,10,12,null,null,"2e hiccup"]
[null,null,null,null,null,1,{"$f":"F24+F12","v":7},{"$f":"G24+G12","v":18},41,64,131,null,"Status op beslisdatum                   (1 mei 2015)"]
[null,null,null,"Leeftijdsgroep","Naam medewerker",null,"Functie",null,"Geboortedatum","Datum in dienst","Status op peildatum",null,null,null,"15-24","25-34","35-44","45-54","55+"]

{"sheet":"mb","index":2,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[[4,2,4,4],[4,7,4,8]]}
[null,null,null,null,null,null,null,null,{"$f":"IF(E1>0,YEAR(peildatum)-YEAR(E1)+IF(DATE(YEAR(peildatum),MONTH(E1),DAY(E1))-peildatum>0,-1,0),0)","v":0},{"$f":"IF(E1>0,IF(O1=\"Uit dienst\",0,IF(I1<25,1,IF(I1<35,2,IF(I1<45,3,IF(I1<55,4,5))))),\"\")","v":""},{"$f":"IF(B1&C1&D1&E1=\"\",0,IF(B1=\"\",1,IF(OR(ISERROR(I1),E1=\"\",I1<15),4,IF(AND(E1<>\"\",E1>TODAY()),4,IF(YEAR(F1)-YEAR(E1)<15,5,IF(F1>=peildatum,5,IF(AND(G1<>\"\",G1-F1<0),6,IF(C1=\"\",2,0))))))))","v":0},{"$f":"IF(G1=\"\",0,IF(G1<=peildatum,\"Uit dienst\",IF(G1-IOdatum<26*7,\"Uit dienst < 26 wkn\",\"\")))","v":"00:00:00"},{"$f":"IF(I1>=55,DATE(YEAR(E1)+65,MONTH(E1)+INDEX(AOWtab,MATCH(E1,INDEX(AOWtab,,1),1),2),DAY(E1)),0)","v":"00:00:00"},{"$f":"IF(M1=0,\"\",IF(M1<=peildatum,\"AOW gerechtigd\",IF(M1-IOdatum<26*7,\"AOW gerechtigd <26 wkn\",\"\")))","v":""},{"$f":"IF(LEFT(L1,3)=\"Uit\",L1,IF(N1=\"AOW gerechtigd\",N1,IF(LEFT(H1,12)=\"oproepkracht\",\"Oproepkracht\",N1)))","v":""},{"$f":"K1","v":0},{"$f":"IF(AND(M1>0,M1<=IOdatplusacht),\"Groep 2: AOW gerechtigd\",IF(AND(LEFT(H1,12)<>\"oproepkracht\",M1>0,M1>IOdatplusacht,(M1-IOdatplusacht)<26*7),\"AOW gerechtigd < 26 wkn\",IF(AND(G1>0,G1<IOdatplusacht),\"Uit dienst\",IF(AND(LEFT(H1,12)<>\"oproepkracht\",G1>0,G1>IOdatplusacht,(G1-IOdatplusacht)<26*7),\"Groep 4: Uit dienst< 26 wkn\",\"\"))))","v":""}]
[null,null,null,null," "]
[null,"UWV Afspiegelingstool 2017-01v2",null,null,"OVERZICHT MEDEWERKERS",null,null,null,null,null,null,null,"Peildatum: ",null,null,null,{"$f":"IF(Bdatum>0,Bdatum,DATE(YEAR(IOdatum),MONTH(IOdatum)+8,DAY(IOdatum)))","v":"1900-08-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Datum indiening ontslagaanvraag: "]
[null,"Naam bedrijf / organisatie: ",null,null,null,null,"Uitwisselbare functie: ",null,null,null,null,null,"Beslisdatum: "]
[]
[null,"Naam","Uitwisselbare functie","Functie","Geboorte-datum","Datum in dienst","Datum uit dienst","Opmerking","Leef-tijd","Lgrp",{"$f":"SUM(INDEX(Tabmed,,10))","v":0},"Status uit dienst","Ingang AOW","Status AOW","Status op peildatum",null,"Status 8 mnd na indiening cq. Status op beslisdatum"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E8>0,YEAR(peildatum)-YEAR(E8)+IF(DATE(YEAR(peildatum),MONTH(E8),DAY(E8))-peildatum>0,-1,0),0)","v":0},{"$f":"IF(E8>0,IF(O8=\"Uit dienst\",0,IF(I8<25,1,IF(I8<35,2,IF(I8<45,3,IF(I8<55,4,5))))),\"\")","v":""},{"$f":"IF(B8&C8&D8&E8=\"\",0,IF(B8=\"\",1,IF(OR(ISERROR(I8),E8=\"\",I8<15),4,IF(AND(E8<>\"\",E8>TODAY()),4,IF(YEAR(F8)-YEAR(E8)<15,5,IF(F8>=peildatum,5,IF(AND(G8<>\"\",G8-F8<0),6,IF(C8=\"\",2,0))))))))","v":0},{"$f":"IF(G8=\"\",0,IF(G8<=peildatum,\"Uit dienst\",IF(G8-IOdatum<26*7,\"Uit dienst < 26 wkn\",\"\")))","v":"00:00:00"},{"$f":"IF(I8>=55,DATE(YEAR(E8)+65,MONTH(E8)+INDEX(AOWtab,MATCH(E8,INDEX(AOWtab,,1),1),2),DAY(E8)),0)","v":"00:00:00"},{"$f":"IF(M8=0,\"\",IF(M8<=peildatum,\"AOW gerechtigd\",IF(M8-IOdatum<26*7,\"AOW gerechtigd <26 wkn\",\"\")))","v":""},{"$f":"IF(LEFT(L8,3)=\"Uit\",L8,IF(N8=\"AOW gerechtigd\",N8,IF(LEFT(H8,12)=\"oproepkracht\",\"Oproepkracht\",N8)))","v":""},{"$f":"K8","v":0},{"$f":"IF(AND(M8>0,M8<=IOdatplusacht),\"Groep 2: AOW gerechtigd\",IF(AND(LEFT(H8,12)<>\"oproepkracht\",M8>0,M8>IOdatplusacht,(M8-IOdatplusacht)<26*7),\"AOW gerechtigd < 26 wkn\",IF(AND(G8>0,G8<IOdatplusacht),\"Uit dienst\",IF(AND(LEFT(H8,12)<>\"oproepkracht\",G8>0,G8>IOdatplusacht,(G8-IOdatplusacht)<26*7),\"Groep 4: Uit dienst< 26 wkn\",\"\"))))","v":""}]

{"sheet":"bs","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"UWV Afspiegelingstool"]
[]
[]
[null,null,null,null,"Indien het programma niet start, wijzig dan de onderstaande instelling in Excel:"]
[]
[null,null,null,null,"Bestand -> Opties -> Vertrouwenscentrum -> Instellingen voor het Vertrouwenscentrum -> Macro-"]
[]
[null,null,null,null,"instellingen -> Alle Macro's inschakelen -> OK -> Excel afsluiten en het programma opnieuw starten."]

{"sheet":"par","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Tabel ingangsdatum AOW geboortedatum vanaf","extra maanden",null,"Overige parameters"]
[null,0,0,null,"Menupostie boven",42]
[null,"1948-01-01",1,null,"Menupositie links",680.25]
[null,"1948-12-01",2,null,"Hdir","G:\\WERK AJD Centraal\\A&O Productie\\IT\\Tools\\Afspiegeltool Officieel"]
[null,"1949-11-01",3,null,"Excelversie",16]
[null,"1950-10-01",6,null,"Extension",".xls"]
[null,"1951-07-01",9,null,"ProgrammaNaam","UWV Afspiegelingstool 2017-01v2.xlsm"]
[null,"1952-04-01",12,null,"KZOpostie boven",42]
[null,"1953-01-01",16,null,"KZOpositie links",805.25]
[null,"1955-09-01",19,null,"Trace boven",343.5]
[null,"1956-06-01",22,null,"Trace links",789.75]
[null,"1957-03-01",24,null,"Ingelogd als beheerder",true]