{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welkom","Kort tijdelijk","salaristabel","Vast dienstverband","Toelichting"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Welkom","index":0,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,3,4]]}
["Model Verlofafrekening"]
[]
[]
[]
[]
["Voor welk type dienstverband wilt u een verlofafrekening doen?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Wanneer verlofuren uitbetalen?"]
[" - Wel: verlaten onderwijssector"]
[" - Wel: korttijdelijke benoeming"]
[" - Niet: overstap naar andere onderwijswerkgever "]
[]
["Let op: dit model gaat ervanuit dat een werknemer al zijn te werken uren in de lesweken maakt. "]

{"sheet":"Kort tijdelijk","index":1,"n_rows":90,"n_cols":16,"rows_kept":90,"cut":false,"hidden":true,"merged":[[5,1,5,3],[6,1,6,3]],"read":"row_number_cap"}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,24]
["Afrekening verlofuren bij uitdiensttreding",null,null,null,null,null,null,null,null,null,null,null,null,null,14,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,24]
["School",null,null,null,null,null,"Omdat je elke week compensatieverlof opbouwd is het gemiddeld aantal uur verlof per week lager dan 40",null,null,null,null,null,null,null,16,24]
["Naam werknemer",null,null,null,null,null,"Bij opbouw onbetaald verlof is gerekend met fulltime 40 uur",null,null,null,null,null,null,null,17,24]
["OOP zonder lesgebonden en/of behandeltaken?","ja",null,null,null,null,null,null,null,null,null,null,null,null,18,24]
[]
["Schoolgegevens",null,null,null,null,null,null,null,null,null,null,null,null,null,19,16]
["Weken per jaar",{"$f":"365.25/7","v":52.178571428571431},null,null,null,null,{"$f":"G12","v":"2026-01-01"},null,null,null,null,null,null,null,20,8]
["Lesweken",{"$f":"IF(B8=\"ja\",41.475,\"\")","v":41.475000000000001},null,null,null,null,{"$f":"B17","v":"2026-01-01"},null,null,null,null,8,null,null,21,0]
["Verlofweken",{"$f":"B11-B12","v":10.703571428571429},null,null,null,null,null,null,null,null,null,12,null,null,22,0]
[null,null,null,null,null,null,null,null,null,null,"salaris 8 max",{"$f":"VLOOKUP(L12,salaristabel!$A:$O,'Kort tijdelijk'!L13+2,FALSE)","v":4449},null,null,23,0]
["Werknemergegevens",null,null,null,null,null,null,null,null,null,null,null,null,null,24,0]
["Geboortedatum","1980-01-01"]
["Datum begin huidige aanstelling","2026-01-01",null,null,null,null,"onbetaald verlof",null,null,null,null,null,null,null,25,0]
["Schaal",5,null,null,null,null,null,null,null,null,null,null,null,null,26,0]
["Trede",12,null,null,null,null,null,null,null,null,null,null,null,null,27,0]
["Brutoloon",{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,salaristabel!$A:$O,'Kort tijdelijk'!B19+2,FALSE))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,28,0]
["Werktijdfactor werknemer",1,null,null,null,null,null,null,null,null,null,null,null,null,29,0]
["Werkdagen per week",5,null,null,null,null,"vermindering verlof 20,5% van aantal uur",null,null,null,null,null,null,null,30,8]
["Einddatum aanstelling","2026-07-31",null,null,null,null,null,null,null,null,null,null,null,null,31,8]
["Kalenderweken ",{"$f":"IF(B23=\"\",\"\",ROUNDDOWN(NETWORKDAYS(G12,B23),0)/5+(NETWORKDAYS(G12,B23)-ROUNDDOWN(NETWORKDAYS(G12,B23),0))/5)","v":30.4},null,null,null,null,{"$f":"B11*40","v":2087.1428571428573},null,null,null,null,null,null,null,32,8]
["Opgebouwde uren vakantieverlof",{"$f":"IF(B24=\"\",\"\",ROUND((B24/B11*I29*B21)+((1659/B12)-40)*(B24-B37)*B21,0))","v":263},null,null,null,null,{"$f":"1659/G24","v":0.7948665297741272},null,null,null,null,null,null,null,33,8]
[null,null,null,null,null,null,{"$f":"1-G25","v":0.2051334702258728},"geboortejaar",{"$f":"YEAR(B16)","v":1980},null,null,null,null,null,34,8]
["Verplichte werkdagen op niet-lesdagen *",0,null,null,null,null,null,"jaar afrekening",{"$f":"YEAR(B23)","v":2026},null,null,null,null,null,35,8]
[null,{"$f":"IF(B27=\"\",\"\",ROUND(B27/B22*B21*40,0))","v":0},null,null,null,null,null,"leeftijd",{"$f":"I27-I26","v":46},null,null,null,null,null,36,8]
[null,null,null,null,null,null,null,null,{"$f":"IF(B8=\"nee\",428,428+IF(B20>=L14,8,0)+VLOOKUP(I28,$O:$P,2,FALSE))","v":452},null,null,null,null,null,37,8]
["Aantal hele weken onbetaald verlof **",null,null,null,null,null,null,null,null,null,null,null,null,null,38,8]
["Aantal losse dagen onbetaald verlof **",null,null,null,null,null,null,null,null,null,null,null,null,null,39,8]
["Vermindering recht verlof",{"$f":"IF(B22=\"\",\"\",ROUND((B30*40*B21+B31/B22*40*B21)*G26,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,40,16]
["Netto opgebouwde uren vakantieverlof",{"$f":"IFERROR(B25-B32,0)","v":263},null,null,null,null,null,null,null,null,null,null,null,null,41,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,16]
["Aantal hele weken genoten verlof",null,null,null,null,null,null,null,null,null,null,null,null,null,43,16]
["Aantal losse dagen genoten verlof",null,null,null,null,null,null,null,null,null,null,null,null,null,44,16]
["Totaal genoten verlofweken",{"$f":"IF(B22=\"\",\"\",B35+B36/B22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,45,24]
["Genoten uren verlof",{"$f":"IF(B22=\"\",\"\",ROUND(B37*B21*40,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,46,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,24]
[{"$f":"IF(B25=\"\",\"\",IF(B25=B38,\"Opgebouwde verlof is volledig besteed***\",IF(B25>B38,\"Nog uit te betalen verlofuren***\",\"Te veel genoten verlofuren***\")))","v":"Nog uit te betalen verlofuren***"},{"$f":"IFERROR(IF(B33-B28-B38>0,B33-B28-B38,-(B33-B28-B38)),\"nog niet alle gegevens zijn juist gevuld\")","v":263},null,null,null,null,null,null,null,null,null,null,null,null,48,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,32]
["* denk hierbij aan terugkomdagen tijdens vakantie, studiedagen in een lesweek, etc. ",null,null,null,null,null,null,null,null,null,null,null,null,null,53,32]
["** alleen van toepassing bij onbetaald verlof > 1 maand",null,null,null,null,null,null,null,null,null,null,null,null,null,54,32]
["*** deze berekening betreft een schatting",null,null,null,null,null,null,null,null,null,null,null,null,null,55,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,40]
["Let op: dit model gaat ervanuit dat een werknemer al zijn te werken uren in de lesweken maakt. ",null,null,null,null,null,null,null,null,null,null,null,null,null,58,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,48]

{"sheet":"salaristabel","index":2,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Schaal","▲",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["A10","Directie",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["A11","Directie",3644,3817,4015,4213,4409,4629,4873,5138,5427,5740,6074,6432,null,0,0,0,0,0,0,0]
["A12","Directie",3659,3874,4125,4376,4627,4910,5225,5577,5960,6378,6828,7313,null,0,0,0,0,0,0,0]
["A13","Directie",5691,5889,6088,6285,6483,6682,6879,7076,7274,7471,7670,7867,8065,0,0,0,0,0,0,0]
["D11","Directie",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D12","Directie",3659,3874,4125,4376,4627,4910,5225,5577,5960,6378,6828,7313,null,0,0,0,0,0,0,0]
["D13","Directie",5691,5889,6088,6285,6483,6682,6879,7076,7274,7471,7670,7867,8065,0,0,0,0,0,0,0]
["D14","Directie",6517,6681,7004,7209,7416,7621,7828,8036,8253,8478,8708,null,null,0,0,0,0,0,0,0]
["D15","Directie",6841,7004,7209,7621,7828,8036,8253,8478,8708,8984,9270,9562,null,0,0,0,0,0,0,0]
["LB","Leerkrachten",3622,3710,3821,3933,4046,4185,4348,4533,4742,4975,5234,5520,0,0,0,0,0,0,0,0]
["LC","Leerkrachten",3644,3817,4015,4213,4409,4629,4873,5138,5427,5740,6074,6432,0,0,0,0,0,0,0,0]
["LD","Leerkrachten",3659,3874,4125,4376,4627,4910,5225,5577,5960,6378,6828,7313,0,0,0,0,0,0,0,0]
["LE","Leerkrachten",4695,4870,5025,5341,5691,6011,6329,6649,6969,7287,7605,8065,0,0,0,0,0,0,0,0]
["LIOa","Leerkrachten",1811,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LIOb","Leerkrachten",1822,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Onderwijs ondersteunend personeel",2559.54,2559.54,2559.54,2580,2634,2689,2743,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,"Onderwijs ondersteunend personeel",3326,3659,3835,4030,4201,4371,4534,4695,4870,5025,5185,5341,5520,0,0,0,0,0,0,0]
[11,"Onderwijs ondersteunend personeel",3644,3817,4015,4213,4409,4629,4873,5138,5427,5740,6074,6432,null,0,0,0,0,0,0,0]
[12,"Onderwijs ondersteunend personeel",3659,3874,4125,4376,4627,4910,5225,5577,5960,6378,6828,7313,null,0,0,0,0,0,0,0]
[13,"Onderwijs ondersteunend personeel",5691,5889,6088,6285,6483,6682,6879,7076,7274,7471,7670,7867,8065,0,0,0,0,0,0,0]
[14,"Onderwijs ondersteunend personeel",6517,6681,7004,7209,7416,7621,7828,8036,8253,8478,8708,null,null,0,0,0,0,0,0,0]
[15,"Onderwijs ondersteunend personeel",6841,7004,7209,7621,7828,8036,8253,8478,8708,8984,9270,9562,null,0,0,0,0,0,0,0]
[16,"Onderwijs ondersteunend personeel",7416,7621,7828,8253,8478,8708,8984,9270,9562,9868,10179,10503,null,0,0,0,0,0,0,0]
[2,"Onderwijs ondersteunend personeel",2559.54,2559.54,2580,2641,2702,2764,2825,2886,null,null,null,null,0,0,0,0,0,0,0,0]
[3,"Onderwijs ondersteunend personeel",2559.54,2574,2651,2729,2806,2884,2961,3039,3116,null,null,null,0,0,0,0,0,0,0,0]
[4,"Onderwijs ondersteunend personeel",2559.54,2598,2673,2748,2822,2897,2971,3046,3121,3195,3270,null,0,0,0,0,0,0,0,0]
[5,"Onderwijs ondersteunend personeel",2559.54,2637,2723,2810,2896,2982,3068,3154,3240,3326,3412,null,0,0,0,0,0,0,0,0]
[6,"Onderwijs ondersteunend personeel",2672,2766,2859,2953,3047,3141,3235,3329,3422,3516,3610,null,0,0,0,0,0,0,0,0]
[7,"Onderwijs ondersteunend personeel",2798,2902,3005,3109,3212,3316,3419,3523,3626,3730,3833,3937,0,0,0,0,0,0,0,0]
[8,"Onderwijs ondersteunend personeel",3022,3152,3281,3411,3541,3671,3800,3930,4060,4190,4320,4449,0,0,0,0,0,0,0,0]
[9,"Onderwijs ondersteunend personeel",3326,3496,3835,4030,4201,4371,4534,4695,4870,5025,null,null,0,0,0,0,0,0,0,0]
["BBL","Onderwijs ondersteunend personeel",1279.77,1919.66,2559.54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Minjl","Onderwijs ondersteunend personeel",2559.54,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Vast1","Onderwijs ondersteunend personeel",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Vast dienstverband","index":3,"n_rows":91,"n_cols":16,"rows_kept":91,"cut":false,"hidden":true,"merged":[[5,1,5,3],[6,1,6,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,24]
["Afrekening verlofuren bij uitdiensttreding",null,null,null,null,null,null,null,null,null,null,null,null,null,14,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,24]
["School",null,null,null,null,null,"Omdat je elke week compensatieverlof opbouwd is het gemiddeld aantal uur verlof per week lager dan 40",null,null,null,null,null,null,null,16,24]
["Naam werknemer",null,null,null,null,null,"Bij opbouw onbetaald verlof is gerekend met fulltime 40 uur",null,null,null,null,null,null,null,17,24]
["OOP zonder lesgebonden en/of behandeltaken?","ja",null,null,null,null,null,null,null,null,null,null,null,null,18,24]
[]
["Schoolgegevens",null,null,null,null,null,null,null,null,null,null,null,null,null,19,16]
["Weken per jaar",{"$f":"365.25/7","v":52.178571428571431},null,null,null,null,{"$f":"IF(B8=\"nee\",DATE(IF(MONTH(B23)>9,YEAR(B23),YEAR(B23)-1),10,1),DATE(YEAR(B23),1,1))","v":"2026-01-01"},null,null,null,null,null,null,null,20,8]
["Lesweken",{"$f":"IF(B8=\"ja\",41.475,\"\")","v":41.475000000000001},null,null,null,null,{"$f":"IF(G11>B17,G11,B17)","v":"2026-01-01"},null,null,null,null,8,null,null,21,0]
["Verlofweken",{"$f":"B11-B12","v":10.703571428571429},null,null,null,null,null,null,null,null,null,12,null,null,22,0]
[null,null,null,null,null,null,null,null,null,null,"salaris 8 max",{"$f":"VLOOKUP(L12,salaristabel!$A:$O,L13+2,FALSE)","v":4449},null,null,23,0]
["Werknemergegevens",null,null,null,null,null,null,null,null,null,null,null,null,null,24,0]
["Geboortedatum","1980-01-01"]
["Datum in dienst","2025-01-01",null,null,null,null,"onbetaald verlof",null,null,null,null,null,null,null,25,0]
["Schaal",8,null,null,null,null,null,null,null,null,null,null,null,null,26,0]
["Trede",11,null,null,null,null,null,null,null,null,null,null,null,null,27,0]
["Brutoloon",{"$f":"IF(B18=\"\",\"\",VLOOKUP(B18,salaristabel!$A:$O,B19+2,FALSE))","v":4320},null,null,null,null,null,null,null,null,null,null,null,null,28,0]
["Werktijdfactor werknemer",1]
["Werkdagen per week",5,null,null,null,null,"vermindering verlof 20,5% van aantal uur",null,null,null,null,null,null,null,29,0]
["Datum uit dienst","2026-07-31",null,null,null,null,null,null,null,null,null,null,null,null,30,8]
[{"$f":"IF(B8=\"ja\",\"Kalenderweken na 1 januari\",\"Kalenderweken na 1 oktober\")","v":"Kalenderweken na 1 januari"},{"$f":"IF(B23=\"\",\"\",ROUNDDOWN(NETWORKDAYS(G12,B23),0)/5+(NETWORKDAYS(G12,B23)-ROUNDDOWN(NETWORKDAYS(G12,B23),0))/5)","v":30.4},null,null,null,null,{"$f":"B11*40","v":2087.1428571428573},null,null,null,null,null,null,null,31,8]
["Opgebouwde uren vakantieverlof",{"$f":"IF(B24=\"\",\"\",ROUND((B24/B11*I29*B21)+((1659/B12)-40)*(B24-B37)*B21,0))","v":263},null,null,null,null,{"$f":"1659/G24","v":0.7948665297741272},null,null,null,null,null,null,null,32,8]
[null,null,null,null,null,null,{"$f":"1-G25","v":0.2051334702258728},"geboortejaar",{"$f":"YEAR(B16)","v":1980},null,null,null,null,null,33,8]
["Verplichte werkdagen op niet-lesdagen*",0,null,null,null,null,null,"jaar afrekening",{"$f":"YEAR(B23)","v":2026},null,null,null,null,null,34,8]
[null,{"$f":"IF(B27=\"\",\"\",ROUND(B27/B22*B21*40,0))","v":0},null,null,null,null,null,"leeftijd",{"$f":"I27-I26","v":46},null,null,null,null,null,35,8]
[null,null,null,null,null,null,null,null,{"$f":"IF(B8=\"nee\",428,428+IF(B20>=L14,8,0)+VLOOKUP(I28,$O:$P,2,FALSE))","v":452},null,null,null,null,null,36,8]
["Aantal hele weken onbetaald verlof **",0,null,null,null,null,null,null,null,null,null,null,null,null,37,8]
["Aantal losse dagen onbetaald verlof **",0,null,null,null,null,null,null,null,null,null,null,null,null,38,8]
["Vermindering recht verlof",{"$f":"IF(B22=\"\",\"\",ROUND((B30*40*B21+B31/B22*40*B21)*G26,0))","v":0},null,null,null,null,null,null,{"$f":"B24/B11*I29*B21","v":263.34182067077342},null,null,null,null,null,39,8]
["Netto opgebouwde uren vakantieverlof",{"$f":"IFERROR(B25-B32,0)","v":263},null,null,null,null,null,null,null,null,null,null,null,null,40,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,16]
["Aantal hele weken genoten verlof",null,null,null,null,null,null,null,null,null,null,null,null,null,42,16]
["Aantal losse dagen genoten verlof",null,null,null,null,null,null,null,null,null,null,null,null,null,43,16]
["Totaal genoten verlofweken",{"$f":"IF(B22=\"\",\"\",B35+B36/B22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,44,16]
["Genoten uren verlof",{"$f":"IF(B22=\"\",\"\",ROUND(B37*B21*40,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,45,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,24]
[{"$f":"IF(B25=\"\",\"\",IF((B33-B28-B38)=0,\"Opgebouwde verlof is volledig besteed***\",IF((B33-B28-B38)>0,\"Nog uit te betalen verlofuren***\",\"Te veel genoten verlofuren***\")))","v":"Nog uit te betalen verlofuren***"},{"$f":"IFERROR(IF(B33-B28-B38>0,B33-B28-B38,-(B33-B28-B38)),\"nog niet alle gegevens zijn juist gevuld\")","v":263},null,null,null,null,null,null,null,null,null,null,null,null,47,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,32]
["* denk hierbij aan terugkomdagen tijdens vakantie, studiedagen in een lesweek, etc. ",null,null,null,null,null,null,null,null,null,null,null,null,null,51,32]
["** alleen van toepassing bij onbetaald verlof > 1 maand",null,null,null,null,null,null,null,null,null,null,null,null,null,52,32]
["*** deze berekening betreft een schatting",null,null,null,null,null,null,null,null,null,null,null,null,null,53,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,40]
["Let op: dit model gaat ervanuit dat een werknemer al zijn te werken uren in de lesweken maakt. ",null,null,null,null,null,null,null,null,null,null,null,null,null,56,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,48]

{"sheet":"Toelichting","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Toelichting op berekening: SCHATTING VAKANTIEVERLOFURENSALDO"]
[]
["Met dit model kan het vakantieverlofsaldo op enig moment worden geschat uitgaande van de volgende uitgangspunten:"]
[]
["Schoolgegevens:\nAantal weken per jaar = 52,18\nAantal lesweken = door school vastgesteld gemiddeld aantal weken per jaar waarin les wordt gegeven"]
[]
["Opbouw en opname\nVoor OP en OOP met les of behandeltaken:\n-\tWerknemer heeft jaarlijks recht op 428 uur vakantieverlof (incl. verlof tijdens feestdagen) bij FTE 1 (= jaartaak van 1659 uur), parttime naar rato.\n-\tWerknemer bouwt het recht op verlof op van 1 oktober tot 1 oktober. \n-\tWerknemer werkt in de lesweken per jaar extra uren om alle leerlingenvakanties vrij te kunnen zijn. Dit betekent dat opbouw van vakantieverlof uit 2 onderdelen uiteenvalt:\no\tAantal gewerkte weken / weken per jaar (52,18) * 428 (recht vakantieverlof) * WTF van de werknemer\no\t(1659 uur / gemiddeld aantal schoolweken) - 40 uur) * aantal gewerkte weken\n\nVoor OOP’ers zonder les- of behandeltaken:\n-\tWerknemer heeft jaarlijks recht op 428 uur vakantieverlof (incl. verlof tijdens feestdagen) bij FTE 1, parttime naar rato.\n-\tWerknemer die wordt beloond vanaf het salarisniveau dat overeenkomt de maximumtrede schaal van 8, ontvangt 8 vakantie-uren per jaar extra, parttime naar rato.\n-\tWerknemer heeft conform CAO afhankelijk van zijn leeftijd extra vakantie-uren.\n-\tWerknemer verricht het werk niet uitsluitend in leswerken maar spreidt deze uren gelijkmatig over het jaar."]
["Dienstverband langer dan 1 jaar / korttijdelijk dienstverband\n- Vast dienstverband: het model gaat uit van gewerkte weken na 1 oktober (OP en OOP met les- en behandeltaken) respectievelijk 1 januari OOP). Hierbij wordt er vanuit gegaan dat de werknemer zijn/haar recht op vakantieverlof voor 1 oktober respectievelijk 1 januari inmiddels heeft opgenomen. \n- Korttijdelijk dienstverband: het model rekent met de werkelijke duur van het dienstverband per ingangsdatum benoeming. Het is onterecht om te concluderen dat deze werknemers hun opgebouwde recht op vakantieverlof voor 1 oktober c.q. 1 januari al hebben opgenomen aangezien zij normaliter de schoolvakanties niet uitbetaald krijgen. \n\nInstructies met betrekking tot gebruik model\n- Genoten verlof.  Betrekt bij het aantal weken/dagen genoten vakantieverlof naast de leerlingenvakanties tevens het verlof tijdens, feestdagen, biddag/dankdag, etc.\nLet op: bij werknemers van een vast dienstverband rekenen vanaf 1 oktober (OP en OOP met les- of behandeltaken) respectievelijk 1 januari (OOP). In het model wordt het aantal genoten verlofuren als volgt berekend:\n o Totaal genoten verlofweken * WTF van de werknemer* 40 uur\n- Gewerkte uren in leerlingenvakanties. Beschouw voor OP en OOP met les- en behandeltaken gewerkte dagen in leerlingenvakanties als vakantiedagen. In het model worden deze uren al als in lesweken gewerkte uren aangemerkt.\n- Onbetaald verlof. Als een werknemer onbetaald verlof heeft genoten ontstaat er een verlaging van het opgebouwde recht op vakantieverlof. Het advies is om het onbetaald verlof van langer dan 1 maand mee te nemen in deze berekening. Het model corrigeert de opbouw van vakantieverlofrechten bij opname onbetaald verlof op de volgende wijze:\n o (aantal hele weken * 40 uur * WTF ) + (aantal losse dagen / werkdagen per week * 40 uur * WTF) = aantal genoten uren onbetaald verlof \n o 428 uur vakantieverlof + 1659 uur (normjaartaak) = 2087 uur per jaar. 428 / 2087 * 100% = 20,51% vakantieverlof\n o 20,51% * aantal genoten uren onbetaald verlof  = vermindering recht verlof\""]