{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["wtf OP, basismodel","wtf OOP, basismodel","wtf overlegmodel onderbouw","wtf overlegmodel bovenbouw","wtf leerkracht huidig","wtf OOP huidig"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"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":"wtf OP, basismodel","index":0,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[30,2,30,3],[30,5,30,7],[36,10,39,14],[51,10,55,14],[53,5,54,6],[55,5,58,7],[31,2,31,3],[30,10,31,14],[1,3,1,4],[27,10,28,14],[20,5,21,6],[20,7,21,7],[28,2,28,3],[6,1,6,3],[12,2,12,3],[11,10,15,14],[16,10,19,14],[23,5,24,6],[23,7,24,7],[22,10,24,14],[29,2,29,3],[4,1,4,3],[4,6,4,7],[5,1,5,3],[5,6,5,7],[7,1,7,8]]}
[]
["Normjaartaak OP schooljaar"]
[]
["Schoolgegevens",null,null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,null,"Naam:"]
["Plaats",null,null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[]
["Gemiddeld aantal lesweken",null,null,"Percentage voor- en nawerk"]
[null,null,null,null,null,null,null,null,null,null,"Toelichting",null,null,null,null,null,null,null,{"$f":"(D20+D24-H29)*C10","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Binnen het basismodel wordt vastgehouden aan de maximale lessentaak van 930 uur, naar rato van de werktijdfactor. Dit betekent dat bij een bepaald aantal lesuren een minimale werktijdfactor hoort. Deze werktijdtijdsfactor wordt automatisch berekend in dit model."]
[null,null,"Lesuren per week"]
[null,null,"Schoolrooster","Werknemer",null,{"$f":"40/(930/C10)","v":{"$error":"#DIV/0!"}}]
[null,"Maandag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"930/40","v":23.25}]
[null,"Dinsdag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"40/S15","v":1.7204301075268817},{"$f":"+S16*5.5","v":9.4623655913978499}]
[null,"Woensdag",null,null,null,null,null,null,null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Dit kunnen bv. lesuren voor vervanging zijn of extra taakuren zoals de aanwezigheid voor een parttimer bij ouderavonden. Deze uren kunnen worden ingevuld in regel 23."]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Totaal",{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":0}]
[null,{"$f":"IF(OR(C33>0,H30>0),\"Totaal exclusief verlofuren\",\"\")","v":""},null,{"$f":"IF(B21=\"\",\"\",C47/C10)","v":""},null,{"$f":"IF(C33>0,\"Werktijdfactor exclusief verlof duurzame inzetbaarheid:\",IF(H30>0,\"Werktijdfactor exclusief ouderschapsverlof:\",\"\"))","v":""},null,{"$f":"IF(C33>0,FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H24,2)/40-(H49/1659))*40-FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H24,2)/40-(H49/1659))*40-FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1))*60,0)&\" minuten\"),IF(H30>0,FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H24,2)/40-(H49/1659))*40-FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H24,2)/40-(H49/1659))*40-FLOOR((LEFT(H24,2)/40-(H49/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1958-10-01","1962-10-01"]
["Extra uren per jaar bovenop de jaartaak",null,null,null,null,null,null,null,null,null,"Tot slot kunnen er extra uren toegekend worden voor taken die niet binnen de huidige werktijdfactor uitgevoerd kunnen worden. Regel 24 geeft de mogelijkheid hier extra uren op jaarbasis voor uit te keren.",null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(C31<=S22,\"Overgangsregeling 56+\",IF(C31<=T22,\"Overgangsregeling 52+\",\"\")))","v":""}]
["Lesgevende uren (excl. voor- en nawerk)",null,null,null,null,"Werktijdfactor:",null,{"$f":"IFERROR(CEILING(IF(AND((D20+D24-H29)*C10>930,(D20+D24-H29)*C10<935),40+D25/41.475,ROUNDDOWN((D20+D24/C10-H29/C10)*F14+D25/41.475,1)),1)&\" uur\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(C31<=S22,\"Basis en bijzonder budget\",IF(C31<=T22,\"Enkel basis budget\",\"\")))","v":""}]
["Extra taakuren (op jaarbasis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(C31<=S22,\"Enkel basis budget\",\"\"))","v":""}]
[null,null,null,null,null,"Werktijdfactor numeriek:",null,{"$f":"IF(H24=0,\"\",LEFT(H24,2)/40)","v":""}]
[]
["Werknemer specifiek",null,null,null,null,null,null,null,null,null,"Bij vrij geroosterde uren wordt gevraagd naar het aantal te compenseren lesuren op jaarbasis. Voorheen de zogenaamde compensatieverlofuren.",null,null,null,null,null,null,null,"verdeling"]
["Vrij geroosterde lesuren",null,null,null,null,{"$f":"IF(C29=\"ja\",\"Aantal lesuren verlof per jaar\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"voor/na"]
["Ouderschapsverlof",null,null,null,null,{"$f":"IF(C30=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""}]
["Geboortedatum",null,null,null,null,{"$f":"IF(C33>0,\"Verdeling uren verlof duurz. inz.\",IF(H30>0,\"Verdeling uren ouderschapsverlof\",\"\"))","v":""},null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. ",null,null,null,null,null,null,{"$f":"2014-1958","v":56},"lesgebonden/behandeltaken"]
[{"$f":"IF(C31=\"\",\"\",IF($C$31<$S$22,\"Recht duurzame inzetbaarheid\",IF($C$31<=$T$22,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,"",null,null,{"$f":"IF(OR(C33>0,H30>0),\"Lesuren\",\"\")","v":""},{"$f":"IF(OR(C33>0,H30>0),\"v/n-werk\",\"\")","v":""},{"$f":"IF(OR(C33>0,H30>0),\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"H30*1659","v":0}]
[{"$f":"IF(C32=\"\",\"\",IF(C32=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(C32=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(C32=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,null,{"$f":"IF(C32=\"Overgangsregeling 56+\",\"Tussen \"&ROUND(170*LEFT(H24,2)/40,0)&\" en \"&ROUND(340*LEFT(H24,2)/40,0),IF(C32=\"Overgangsregeling 52+\",\"Tussen 0 en \"&ROUND(170*LEFT(H24,2)/40,0),IF(C32=\"Basis en bijzonder budget\",\"Tussen 0 en \"&ROUND(170*LEFT(H24,2)/40,0),\"\")))","v":""},null,{"$f":"IFERROR(ROUND(IF(C33>0,U53,IF(H30>0,U33*U32,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C33>0,U54,IF(H30>0,U34*U32,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C33>0,U55,IF(H30>0,U37*U32,\"\")),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(AND(D20*C10+D24-H29>930,D20*C10+D24-H29<935),930,D20*C10+D24-H29),0)","v":0},null,{"$f":"S33/SUM($S$33:$S$37)","v":{"$error":"#DIV/0!"}},{"$f":"U33*$U$32","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"IF(H30>0,\"Professionalisering\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(H30>0,U35*U32,\"\"),0),\"\")","v":""},{"$f":"IF(H30>0,\"Duurz. inzetb.\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(H30>0,U36*U32,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S53*G10,0)","v":0},{"$f":"S33+S34","v":0},{"$f":"S34/SUM($S$33:$S$37)","v":{"$error":"#DIV/0!"}},{"$f":"U34*$U$32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(LEFT(H24,2)/40*2*41.475,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Extra voor- en nawerk per jaar in verband met.. (uren op jaarbasis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(A33=\"\",ROUND(LEFT(H24,2)/40*40,0),ROUND(VLOOKUP(C32,$S$46:$T$50,2,FALSE)*LEFT(H24,2)/40,0))-C33,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. aantal zorgleerlingen",null,null,null,null,null,null,null,null,null,"Het is mogelijk dat een bepaalde leerkracht extra ruimte krijgt in verband met bijzondere omstandigheden in de klas. Hiernaast is ruimte gereserveerd om deze uren in te vullen. Dit gaat ten koste van nog bestaande uren voor resttaken en worden verrekend onder de lesgebonden uren.",null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(S55,0),0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. groepsgrootte"]
[".. startende leerkracht"]
[".. anders"]
["Totaal",null,{"$f":"SUM(C37:C40)","v":0}]
[]
[]
["TOTAALOVERZICHT verdeling werkzaamheden"]
[]
["Lesgebonden uren",null,null,null,null,"Niet-lesgebonden uren",null,null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 52+",170,null,{"$f":"1659/40*41","v":1700.4750000000001}]
["Lesuren op jaarbasis",null,{"$f":"IFERROR(ROUND(IF(H30>0,S53-V33,S53-H49/SUM(S53:S55)*S53),0),0)","v":0},null,null,"Professionalisering",null,{"$f":"IFERROR(ROUND(LEFT(H24,2)/40*2*41.475-V35,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["Voor- en nawerk",null,{"$f":"IFERROR(ROUND(IF(H30>0,S54-V34,S54-H49/SUM(S53:S55)*S54),0),0)","v":0},null,null,"Duurzame inzetbaarheid",null,{"$f":"IFERROR(ROUND(IF(A33=\"\",ROUND(LEFT(H24,2)/40*40,0),ROUND(VLOOKUP(C32,$S$46:$T$50,2,FALSE)*LEFT(H24,2)/40,0))-C33-V36,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Extra voor- en nawerk",null,{"$f":"C41","v":0},null,null,{"$f":"IF(C33>0,\"Verlof duurzame inzetbaarheid\",IF(H30>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"ROUND(IF(F49=\"\",0,IF(C33>0,C33,U32)),0)","v":0}]
["Totaal lesgebonden uren",null,{"$f":"SUM(C47:C49)","v":0},null,null,"Totaal",null,{"$f":"SUM(H47:H49)","v":0},null,null,null,null,null,null,null,null,null,null,"Enkel basis budget",40]
[]
["Taakuren buiten het voor- en nawerk op jaarbasis",null,null,null,null,null,null,null,null,null,"Onder de taakuren kunnen de uren aan overige taken verder uit gespecificeerd worden. Dit zijn dus de taken welke buiten het voor- en nawerk vallen. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. In dit geval moet het aantal extra taakuren van de werknemer (regel 24) worden aangepast."]
["Ouderavonden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(AND(D20*C10+D24-H29>930,D20*C10+D24-H29<935),930,D20*C10+D24-H29),0)","v":0},null,{"$f":"S53-C47","v":0},{"$f":"S53/SUM($S$53:$S$55)","v":{"$error":"#DIV/0!"}}]
["(Team)Vergaderingen",null,null,null,null,{"$f":"IF(C96<0,\"LET OP:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S53*G10,0)","v":0},{"$f":"S53+S54","v":0},{"$f":"S54-C48","v":0},{"$f":"S54/SUM($S$53:$S$55)","v":{"$error":"#DIV/0!"}}]
["Teamscholing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(1659*(LEFT(H24,2)/40)-T54-ROUND(IF(A33=\"\",ROUND(LEFT(H24,2)/40*40,0),ROUND(VLOOKUP(C32,$S$46:$T$50,2,FALSE)*LEFT(H24,2)/40,0))-C33,0)-ROUND(LEFT(H24,2)/40*2*41.475,0)-C41,0)","v":0},null,{"$f":"+S55-C97","v":0},{"$error":"#DIV/0!"}]
["Project",null,null,null,null,{"$f":"IF(C96<0,\"De werktijdfactor is te laag om deze taken te kunnen vervullen. Vul in cel D22 extra uren in\",\"\")","v":""}]
["……"]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1452/1659","v":0.87522603978300184}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"35/40","v":0.875}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"1659/40*LEFT(H24,2)","v":0}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["….."]
["Resturen op jaarbasis",null,{"$f":"IFERROR(IF(H30>0,ROUND(S55-SUM(C53:C95)-V37,0),ROUND(S55-H49/SUM(S53:S55)*S55-SUM(C53:C95),0)),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C53:C96)","v":0}]

{"sheet":"wtf OOP, basismodel","index":1,"n_rows":77,"n_cols":21,"rows_kept":77,"cut":false,"hidden":false,"merged":[[37,9,41,13],[39,4,42,6],[37,4,38,6],[10,1,10,2],[19,1,20,2],[19,3,20,3],[10,4,10,6],[15,9,20,13],[9,9,14,13],[24,2,24,3],[25,2,25,3],[25,4,25,6],[23,9,26,13],[26,2,26,3],[19,4,20,5],[19,6,20,6],[7,1,7,7],[6,1,6,3],[1,3,1,4],[4,1,4,3],[4,5,4,6],[5,1,5,3],[5,5,5,6]]}
[]
["Normjaartaak OOP schooljaar"]
[]
["Schoolgegevens",null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,"Naam:"]
["Plaats",null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[null,null,null,null,null,null,null,null,null,"Toelichting"]
[null,null,null,null,null,null,null,null,null,"Voor een werknemer die benoemd wordt in de categorie O.O.P. moet worden bepaald hoeveel uur per dag deze werknemer nodig is. Dit gaat nadrukkelijk om werkuren en staat los van de leerlinguren. Voor O.O.P.'ers geldt ook dat deze uren verdeeld moeten worden over maximaal 40 uur per week, naar rato van de werktijdfactor. Dit betekent dus ook dat een deel in de leerlingvakanties wordt gewerkt."]
[null,"Vaste werkdagen per week",null,null,"Variabele dagen per jaar"]
[null,"Schoolrooster","Werknemer",null,"Daguren","aantal dagen","Totaal"]
["Maandag",null,null,null,null,null,{"$f":"E13*F13","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"930/40","v":23.25}]
["Dinsdag",null,null,null,null,null,{"$f":"E14*F14","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"40/R13","v":1.7204301075268817},{"$f":"+R14*5.5","v":9.4623655913978499}]
["Woensdag",null,null,null,null,null,0]
["Donderdag",null,null,null,null,null,0,null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Dit kunnen bijvoorbeeld extra dagen zijn bij vergaderingen of projecten. Hiervoor is de tweede tabel bedoeld waarin aangegeven kan worden hoeveel dagen in het jaar, bovenop de jaartaak, moet worden gewerkt."]
["Vrijdag",null,null,null,null,null,0]
["Totaal",{"$f":"SUM(B13:B17)","v":0},{"$f":"SUM(C13:C17)","v":0},null,{"$f":"SUM(E13:E17)","v":0},{"$f":"SUM(F13:F17)","v":0},{"$f":"SUM(G13:G17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1958-10-01","1962-10-01"]
[null,"Werktijdfactor:",null,{"$f":"IFERROR(ROUND((C18+G18/41.475),0)&\" uur\",0)","v":"0 uur"},{"$f":"IF(C28>0,\"Werktijdfactor exclusief verlof duurzame inzetbaarheid:\",IF(G25>0,\"Werktijdfactor exclusief ouderschapsverlof:\",\"\"))","v":""},null,{"$f":"IF(C28>0,FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(D20,2)/40-(G35/1659))*40-FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(D20,2)/40-(G35/1659))*40-FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1))*60,0)&\" minuten\"),IF(G25>0,FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(D20,2)/40-(G35/1659))*40-FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(D20,2)/40-(G35/1659))*40-FLOOR((LEFT(D20,2)/40-(G35/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",IF(C26<=R19,\"Overgangsregeling 56+\",IF(C26<=S19,\"Overgangsregeling 52+\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",IF(C26<=R19,\"Basis en bijzonder budget\",IF(C26<=S19,\"Enkel basis budget\",\"\")))","v":""}]
[null,"Werktijdfactor numeriek:",null,{"$f":"IF(D20=0,\"\",LEFT(D20,2)/40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",IF(C26<=R19,\"Enkel basis budget\",\"\"))","v":""}]
[]
["Werknemer specifiek",null,null,null,null,null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. ",null,null,null,null,null,null,null,{"$f":"ROUND(LEFT(D20,2)/40*40,0)","v":0}]
["Ouderschapsverlof",null,null,null,{"$f":"IF(C25=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""}]
["Geboortedatum",null,null,null,{"$f":"IF(G25>0,\"Verdeling uren ouderschapsverlof\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"2014-1958","v":56},"lesgebonden/behandeltaken"]
[{"$f":"IF(C26=\"\",\"\",IF($C$26<$R$19,\"Recht duurzame inzetbaarheid\",IF($C$26<=$S$19,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,null,null,{"$f":"IF(G25>0,\"Profess.\",\"\")","v":""},{"$f":"IF(G25>0,\"Duurz. inz.\",\"\")","v":""},{"$f":"IF(G25>0,\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"G25*1659","v":0}]
[{"$f":"IF(C27=\"\",\"\",IF(C27=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(C27=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(C27=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,null,{"$f":"IF(C27=\"Overgangsregeling 56+\",\"Tussen \"&ROUND(170*LEFT(D20,2)/40,0)&\" en \"&ROUND(340*LEFT(D20,2)/40,0),IF(C27=\"Overgangsregeling 52+\",\"Tussen 0 en \"&ROUND(170*LEFT(D20,2)/40,0),IF(C27=\"Basis en bijzonder budget\",\"Tussen 0 en \"&ROUND(170*LEFT(D20,2)/40,0),\"\")))","v":""},{"$f":"IF(G25>0,ROUND(T29*T27,0),\"\")","v":""},{"$f":"IF(G25>0,ROUND(T30*T27,0),\"\")","v":""},{"$f":"IF(G25>0,ROUND(T31*T27,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R28/SUM($S$32:$S$36)","v":0},{"$f":"T28*$T$27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(LEFT(D20,2)/40*2*41.475,0)","v":0},null,{"$f":"R29/SUM($R$29:$R$31)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(T29*$T$27,0)","v":0}]
["TOTAALOVERZICHT verdeling werkzaamheden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(A27=\"\",ROUND(LEFT(D20,2)/40*40,0),ROUND(VLOOKUP(C27,$R$32:$S$36,2,FALSE)*LEFT(D20,2)/40,0))-C28,0)","v":0},null,{"$f":"R30/SUM($R$29:$R$31)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(T30*$T$27,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(R41,0),0)","v":0},null,{"$f":"R31/SUM($R$29:$R$31)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(T31*$T$27,0)","v":0}]
["Specificatie op jaarbasis",null,null,null,"Niet-taakgebonden uren",null,null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 52+",170]
["Ouderavonden",null,null,null,"Professionalisering",null,{"$f":"ROUND(LEFT(D20,2)/40*2*41.475-U29,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["(Team)Vergaderingen",null,null,null,"Duurzame inzetbaarheid",null,{"$f":"ROUND(IF(AND(A28=\"\",G25=\"\"),ROUND(LEFT(D20,2)/40*40,0),IF(G25>0,ROUND(LEFT(D20,2)/40*40,0)-F28,ROUND(VLOOKUP(C27,$R$32:$S$36,2,FALSE)*LEFT(D20,2)/40,0))-C28),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Teamscholing",null,null,null,{"$f":"IF(C28>0,\"Verlof duurzame inzetbaarheid\",IF(G25>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"IF(E35=\"\",\"\",IF(C28>0,C28,IF(G25>0,T27,\"\")))","v":""}]
["Project",null,null,null,"Totaal",null,{"$f":"SUM(G33:G35)","v":0},null,null,null,null,null,null,null,null,null,null,"Enkel basis budget",40]
["……"]
["……",null,null,null,{"$f":"IF(C76<0,\"LET OP:\",\"\")","v":""},null,null,null,null,"Onder de taakuren kunnen de uren verder uit gespecificeerd worden. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. In dit geval moeten er extra variabelen toegevoegd worden."]
["……"]
["……",null,null,null,{"$f":"IF(C76<0,\"De werktijdfactor is te laag om deze taken te kunnen vervullen. Vul extra variabele dagen in.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R39+R40","v":0}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(1659*(LEFT(D20,2)/40)-ROUND(IF(A27=\"\",ROUND(LEFT(D20,2)/40*40,0),ROUND(VLOOKUP(C27,$R$32:$S$36,2,FALSE)*LEFT(D20,2)/40,0))-C28,0)-ROUND(LEFT(D20,2)/40*2*41.475,0),0)","v":0}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1659/40*LEFT(D20,2)","v":0},null,{"$f":"R41-G35-SUM(C33:C75)-U31","v":{"$error":"#VALUE!"}}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["….."]
["Resturen op jaarbasis",null,{"$f":"IFERROR(ROUND(IF(C28>0,R41-G35-SUM(C33:C75)-U31,R41-SUM(C33:C75)-U31),0),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C33:C76)","v":0}]

{"sheet":"wtf overlegmodel onderbouw","index":2,"n_rows":102,"n_cols":22,"rows_kept":102,"cut":false,"hidden":false,"merged":[[37,0,37,2],[23,2,23,4],[6,1,6,3],[27,5,28,6],[27,7,28,7],[24,5,25,6],[35,1,35,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[22,6,22,7],[7,1,7,8],[4,1,4,3],[4,5,4,6],[15,2,15,3],[15,1,16,1],[14,5,14,7],[15,5,16,5],[15,6,15,7],[5,1,5,3],[5,5,5,6],[1,2,1,3],[56,10,60,14],[58,4,59,7],[60,4,64,7],[30,10,31,14],[40,10,43,14],[34,10,38,14],[34,4,34,7],[5,7,5,8],[4,7,4,8],[27,10,29,14],[11,10,14,14],[22,2,22,3],[14,1,14,3],[15,10,25,14],[24,7,25,7]]}
[]
["Normjaartaak OP schooljaar:"]
[]
["Schoolgegevens",null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,"Naam:"]
["Plaats",null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[null,null,null,null,null,null,null,{"$f":"40/(930/C10)","v":{"$error":"#DIV/0!"}}]
["Gemiddeld aantal lesweken",null,null,null,"Percentage voor- en nawerk"]
[null,null,null,null,null,null,null,null,null,null,"Toelichting"]
[null,null,null,null,null,null,null,null,null,null,"Het uitgangspunt van de nieuwe werktijdfactor is niet meer het aantal lesuren, maar het werkelijk aantal te werken uren. Daarom wordt in dit nieuwe model onderscheid gemaakt tussen het aantal lesuren en het aantal werkuren per dag."]
["Standaard weekspreiding van lesuren (leerling) en werkuren (werknemer)"]
[]
[null,"STANDAARD SCHOOLROOSTER",null,null,null,"ROOSTER WERKNEMER"]
[null,"Lesuren","Spreiding werkuren",null,null,"Lesuren","Spreiding werkuren",null,null,null,"De eerste stap is om het standaard schoolrooster in te vullen. Vul het aantal lesuren in voor een standaard lesweek en bepaal het aantal uren per dagdeel dat hierbij wordt gewerkt. De tweede stap is om het rooster van de werknemer in te vullen. Vul het aantal lesuren in dat de werknemer les geeft in een standaard week en bepaal welke dagdelen hierbij gewerkt moet worden. Het is mogelijk af te wijken van het standaard schoolrooster in overleg met de werknemer. Wanneer een leerkracht een dag ambulant is, vult u geen lesuren in maar wel werkuren. Bij een O.O.P.'er vult u ook enkel werkuren in."]
[null,null,"Ochtend","Middag",null,null,"Ochtend","Middag"]
["Maandag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"930/40","v":23.25}]
["Dinsdag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"40/S18","v":1.7204301075268817},{"$f":"+S19*5.5","v":9.4623655913978499}]
["Woensdag"]
["Donderdag"]
["Vrijdag"]
["Totaal",{"$f":"SUM(B18:B22)","v":0},{"$f":"SUM(C18:D22)","v":0},null,null,{"$f":"SUM(F18:F22)","v":0},{"$f":"SUM(G18:H22)","v":0}]
[null,null,{"$f":"IF(B37>0,\"Totaal exclusief verlofuren\",\"\")","v":""},null,null,{"$f":"IF(C24=\"\",\"\",C52/C10)","v":""}]
[null,null,null,null,null,{"$f":"IF(B37>0,\"Werktijdfactor exclusief verlof duurz. inz.:\",IF(G34>0,\"Werktijdfactor ouderschapsverlof:\",\"\"))","v":""},null,{"$f":"IF(B37>0,FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0)&\" minuten\"),IF(G34>0,FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1958-10-01","1962-10-01"]
["Extra uren per jaar bovenop de jaartaak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Overgangsregeling 56+\",IF(B35<=T26,\"Overgangsregeling 52+\",\"\")))","v":""}]
["Lesgevende uren (ex. voor- en nawerk)",null,null,null,null,"Werktijdfactor:",null,{"$f":"IFERROR(ROUND((G23-G33/C10*H26+(D28+D28*H10+D29)/41.475),0)&\" uur\",0)","v":0},null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Dit kunnen bv. lesuren voor vervanging zijn of extra taakuren zoals de aanwezigheid voor een parttimer bij ouderavonden.",null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Basis en bijzonder budget\",IF(B35<=T26,\"Enkel basis budget\",\"\")))","v":""}]
["Extra taakuren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Enkel basis budget\",\"\"))","v":""}]
[null,null,null,null,null,"Werktijdfactor numeriek:",null,{"$f":"IF(H28=0,\"\",LEFT(H28,2)/40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Een hoger percentage aan voor- en nawerk leidt tot een lager aantal uren voor overige taken."]
["Werknemer specifiek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"verdeling"]
[{"$f":"'wtf OP, basismodel'!A29","v":"Vrij geroosterde lesuren"},null,null,{"$f":"IF(B33=\"ja\",\"Aantal lesuren verlof per jaar\",\"\")","v":""}]
["Ouderschapsverlof",null,null,{"$f":"IF(B34=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""}]
["Geboortedatum",null,null,null,{"$f":"IF(B37>0,\"Verdeling uren verlof duurz. inz.\",\"\")","v":""},null,null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. Wanneer de werknemer recht heeft op verlof moet bepaald worden hoe dit verlof wordt verdeeld over lesuren, voor- en nawerk en taakuren. Hiervoor geldt geen vaste verhouding.",null,null,null,null,null,null,{"$f":"2014-1958","v":56},"lesgebonden/behandeltaken"]
[{"$f":"IF(B35=\"\",\"\",IF($B$35<$S$26,\"Recht duurzame inzetbaarheid\",IF($B$35<=$T$26,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,null,null,null,{"$f":"IF(B37>0,\"Lesuren\",\"\")","v":""},{"$f":"IF(B37>0,\"v/n-werk\",\"\")","v":""},{"$f":"IF(B37>0,\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"G34*1659","v":0}]
[{"$f":"IF(B36=\"\",\"\",IF(B36=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(B36=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(B36=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,{"$f":"IF(B36=\"Overgangsregeling 56+\",ROUND(170*LEFT(H28,2)/40,0)&\" - \"&ROUND(340*LEFT(H28,2)/40,0),IF(B36=\"Overgangsregeling 52+\",\"0 - \"&ROUND(170*LEFT(H28,2)/40,0),IF(B36=\"Basis en bijzonder budget\",\"0 - \"&ROUND(170*LEFT(H28,2)/40,0),\"\")))","v":""},{"$f":"IF(G34>0,\"Lesuren\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U37*U36,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F23*C10+D28-G33,0)","v":0},null,{"$f":"S37/SUM($S$37:$S$42)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(U37*$U$36,\"\")","v":""}]
[{"$f":"IF(G34>0,\"Verdeling uren ouderschapsverlof\",\"\")","v":""},null,null,{"$f":"IF(G34>0,\"v/n-werk\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G34>0,U39*U36,\"\"),0),\"\")","v":""},{"$f":"IF(B37>0,IF(B37>SUM(F37:H37),\"nog \"&B37-SUM(F37:H37)&\" uur\",IF(B37=SUM(F37:H37),\"verdeeld\",\"te veel uren\")),IF(G34>0,\"Taakuren\",\"\"))","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U42*U36,\"\"),0),\"\")","v":""}]
[null,null,null,{"$f":"IF(G34>0,\"Professionalisering\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G34>0,U40*U36,\"\"),0),\"\")","v":""},{"$f":"IF(G34>0,\"Duurz. inz.\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U41*U36,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S37*H10,0)","v":0},{"$f":"S37+S39","v":0},{"$f":"S39/SUM($S$37:$S$42)","v":{"$error":"#DIV/0!"}},{"$f":"U39*$U$36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(LEFT(H28,2)/40*2*41.475,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Extra voor- en nawerk per jaar in verband met.. (uren op jaarbasis)",null,null,null,null,null,null,null,null,null,"Het is mogelijk dat een bepaalde leerkracht extra ruimte krijgt in verband met bijzondere omstandigheden in de klas. Hiernaast is ruimte gereserveerd om deze uren in te vullen. Dit gaat ten koste van nog bestaande uren voor resttaken en worden verrekend onder de lesgebonden uren.",null,null,null,null,null,null,{"$f":"IF(B37>0,IF(B37>SUM(F37:H37),\"nog \"&B37-SUM(F37:H37)&\" uren te vullen\",IF(B37=SUM(F37:H37),\"verlof is verdeeld\",\"te veel verlofuren ingevuld\")),\"\")","v":""},{"$f":"ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. aantal zorgleerlingen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(T59,0),0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. groepsgrootte"]
[".. startende leerkracht"]
[".. anders"]
["Totaal",null,{"$f":"SUM(C42:C45)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B36=\"Overgangsregeling 56+\",ROUND(340*LEFT(H28,2)/40,0),IF(B36=\"Overgangsregeling 52+\",ROUND(170*LEFT(H28,2)/40,0),IF(B36=\"Basis en bijzonder budget\",ROUND(170*LEFT(H28,2)/40,0),\"\")))","v":""}]
["TOTAALOVERZICHT verdeling werkzaamheden"]
[]
["Lesgebonden uren",null,null,null,"Niet-lesgebonden uren",null,null,null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 52+",170]
["Lesuren op jaarbasis",null,{"$f":"IFERROR(ROUND(IF(G34>0,T57-V37,T57-F37),0),0)","v":0},null,"Professionalisering",null,{"$f":"IFERROR(ROUND(LEFT(H28,2)/40*2*41.475-V40,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["Voor- en nawerk",null,{"$f":"IFERROR(ROUND(IF(G34>0,T58-V39,IF(B37>0,T58-G37,T58)),0),0)","v":0},null,"Duurz. inzetbaarheid",null,{"$f":"IFERROR(ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37-V41,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Extra voor- en nawerk",null,{"$f":"C46","v":0},null,{"$f":"IF(B37>0,\"Verlof duurz. inz.\",IF(G34>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"ROUND(IF(E54=\"\",0,IF(B37>0,B37,U36)),0)","v":0}]
["Totaal lesgebonden uren",null,{"$f":"SUM(C52:C54)","v":0},null,"Totaal",null,{"$f":"SUM(G52:G54)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Enkel basis budget",40]
[]
["Taakuren buiten het voor- en nawerk op jaarbasis",null,null,null,null,null,null,null,null,null,"Onder de taakuren kunnen de uren aan overige taken verder uit gespecificeerd worden. Dit zijn dus de taken welke buiten het voor- en nawerk vallen. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. In dit geval moet het aantal werkuren van de werknemer worden aangepast.",null,null,null,null,null,null,null,"Lesuren op jaarbasis",{"$f":"ROUND(F23*C10+D28-G33,0)","v":0}]
["Ouderavonden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voor- en nawerk",{"$f":"ROUND(T57*H10,0)","v":0}]
["(Team)Vergaderingen",null,null,null,{"$f":"IF(C101<0,\"LET OP:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Resturen op jaarbasis",{"$f":"ROUND(1659*(LEFT(H28,2)/40)-T58-T57-ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37,0)-ROUND(LEFT(H28,2)/40*2*41.475,0)-C46,0)","v":0}]
["Teamscholing"]
["Project",null,null,null,{"$f":"IF(C101<0,\"De werktijdfactor is te laag om aan de normjaartaak te voldoen. Vul in cel D25 extra uren in of verstrek een extra dagdeel\",\"\")","v":""}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(1659*(LEFT(H28,2)/40)-ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37,0)-ROUND(LEFT(H28,2)/40*2*41.475,0),0)","v":0}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1659/40*LEFT(H28,2)","v":0}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["….."]
["Resturen op jaarbasis",null,{"$f":"IFERROR(IF(G34>0,ROUND(T59-SUM(C58:C100)-V42,0),ROUND(T59-H37-SUM(C58:C100),0)),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C58:C101)","v":0}]

{"sheet":"wtf overlegmodel bovenbouw","index":3,"n_rows":102,"n_cols":22,"rows_kept":102,"cut":false,"hidden":false,"merged":[[40,10,43,14],[56,10,60,14],[58,4,59,7],[60,4,64,7],[30,10,31,14],[34,1,34,2],[34,4,34,7],[34,10,38,14],[35,1,35,2],[37,0,37,2],[23,2,23,4],[24,5,25,6],[24,7,25,7],[32,1,32,2],[33,1,33,2],[15,1,16,1],[15,2,15,3],[15,5,16,5],[15,6,15,7],[22,2,22,3],[22,6,22,7],[7,1,7,8],[6,1,6,3],[4,1,4,3],[5,1,5,3],[14,1,14,3],[14,5,14,7],[27,10,29,14],[11,10,14,14],[15,10,25,14],[27,5,28,6],[27,7,28,7],[1,2,1,3],[4,5,4,6],[4,7,4,8],[5,5,5,6],[5,7,5,8]]}
[]
["Normjaartaak OP schooljaar:"]
[]
["Schoolgegevens",null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,"Naam:"]
["Plaats",null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[null,null,null,null,null,null,null,{"$f":"40/(930/C10)","v":{"$error":"#DIV/0!"}}]
["Gemiddeld aantal lesweken",null,null,null,"Percentage voor- en nawerk"]
[null,null,null,null,null,null,null,null,null,null,"Toelichting"]
[null,null,null,null,null,null,null,null,null,null,"Het uitgangspunt van de nieuwe werktijdfactor is niet meer het aantal lesuren, maar het werkelijk aantal te werken uren. Daarom wordt in dit nieuwe model onderscheid gemaakt tussen het aantal lesuren en het aantal werkuren per dag."]
["Standaard weekspreiding van lesuren (leerling) en werkuren (werknemer)"]
[]
[null,"STANDAARD SCHOOLROOSTER",null,null,null,"ROOSTER WERKNEMER"]
[null,"Lesuren","Spreiding werkuren",null,null,"Lesuren","Spreiding werkuren",null,null,null,"De eerste stap is om het standaard schoolrooster in te vullen. Vul het aantal lesuren in voor een standaard lesweek en bepaal het aantal uren per dagdeel dat hierbij wordt gewerkt. De tweede stap is om het rooster van de werknemer in te vullen. Vul het aantal lesuren in dat de werknemer les geeft in een standaard week en bepaal welke dagdelen hierbij gewerkt moet worden. Het is mogelijk af te wijken van het standaard schoolrooster in overleg met de werknemer. Wanneer een leerkracht een dag ambulant is, vult u geen lesuren in maar wel werkuren. Bij een O.O.P.'er vult u ook enkel werkuren in."]
[null,null,"Ochtend","Middag",null,null,"Ochtend","Middag"]
["Maandag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"930/40","v":23.25}]
["Dinsdag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"40/S18","v":1.7204301075268817},{"$f":"+S19*5.5","v":9.4623655913978499}]
["Woensdag"]
["Donderdag"]
["Vrijdag"]
["Totaal",{"$f":"SUM(B18:B22)","v":0},{"$f":"SUM(C18:D22)","v":0},null,null,{"$f":"SUM(F18:F22)","v":0},{"$f":"SUM(G18:H22)","v":0}]
[null,null,{"$f":"IF(B37>0,\"Totaal exclusief verlofuren\",\"\")","v":""},null,null,{"$f":"IF(C24=\"\",\"\",C52/C10)","v":""}]
[null,null,null,null,null,{"$f":"IF(B37>0,\"Werktijdfactor exclusief verlof duurz. inz.:\",IF(G33>0,\"Werktijdfactor exclusief ouderschapsverlof:\",\"\"))","v":""},null,{"$f":"IF(B37>0,FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0)&\" minuten\"),IF(G34>0,FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1)&\" uur\"&IF((ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((LEFT(H28,2)/40-(G54/1659))*40-FLOOR((LEFT(H28,2)/40-(G54/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1958-10-01","1962-10-01"]
["Extra uren per jaar bovenop de jaartaak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Overgangsregeling 56+\",IF(B35<=T26,\"Overgangsregeling 52+\",\"\")))","v":""}]
["Lesgevende uren (ex. voor- en nawerk)",null,null,null,null,"Werktijdfactor:",null,{"$f":"IFERROR(ROUND((G23-G33/C10*H26+(D28+D28*H10+D29)/41.475),0)&\" uur\",0)","v":0},null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Dit kunnen bv. lesuren voor vervanging zijn of extra taakuren zoals de aanwezigheid voor een parttimer bij ouderavonden.",null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Basis en bijzonder budget\",IF(B35<=T26,\"Enkel basis budget\",\"\")))","v":""}]
["Extra taakuren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(B35<=S26,\"Enkel basis budget\",\"\"))","v":""}]
[null,null,null,null,null,"Werktijdfactor numeriek:",null,{"$f":"IF(H28=0,\"\",LEFT(H28,2)/40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Een hoger percentage aan voor- en nawerk leidt tot een lager aantal uren voor overige taken."]
["Werknemer specifiek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"verdeling"]
[{"$f":"'wtf OP, basismodel'!A29","v":"Vrij geroosterde lesuren"},null,null,{"$f":"IF(B33=\"ja\",\"Aantal lesuren verlof per jaar\",\"\")","v":""}]
["Ouderschapsverlof",null,null,{"$f":"IF(B34=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""}]
["Geboortedatum",null,null,null,{"$f":"IF(B37>0,\"Verdeling uren verlof duurz. inz.\",\"\")","v":""},null,null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. Wanneer de werknemer recht heeft op verlof moet bepaald worden hoe dit verlof wordt verdeeld over lesuren, voor- en nawerk en taakuren. Hiervoor geldt geen vaste verhouding.",null,null,null,null,null,null,{"$f":"2014-1958","v":56},"lesgebonden/behandeltaken"]
[{"$f":"IF(B35=\"\",\"\",IF($B$35<$S$26,\"Recht duurzame inzetbaarheid\",IF($B$35<=$T$26,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,null,null,null,{"$f":"IF(B37>0,\"Lesuren\",\"\")","v":""},{"$f":"IF(B37>0,\"v/n-werk\",\"\")","v":""},{"$f":"IF(B37>0,\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"G34*1659","v":0}]
[{"$f":"IF(B36=\"\",\"\",IF(B36=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(B36=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(B36=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,{"$f":"IF(B36=\"Overgangsregeling 56+\",ROUND(170*LEFT(H28,2)/40,0)&\" - \"&ROUND(340*LEFT(H28,2)/40,0),IF(B36=\"Overgangsregeling 52+\",\"0 - \"&ROUND(170*LEFT(H28,2)/40,0),IF(B36=\"Basis en bijzonder budget\",\"0 - \"&ROUND(170*LEFT(H28,2)/40,0),\"\")))","v":""},{"$f":"IF(G34>0,\"Lesuren\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U37*U36,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F23*C10+D28-G33,0)","v":0},null,{"$f":"S37/SUM($S$37:$S$42)","v":{"$error":"#DIV/0!"}},{"$f":"U37*$U$36","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(G34>0,\"Verdeling uren ouderschapsverlof\",\"\")","v":""},null,null,{"$f":"IF(G34>0,\"v/n-werk\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G34>0,U39*U36,\"\"),0),\"\")","v":""},{"$f":"IF(B37>0,IF(B37>SUM(F37:H37),\"nog \"&B37-SUM(F37:H37)&\" uur\",IF(B37=SUM(F37:H37),\"verdeeld\",\"te veel uren\")),IF(G34>0,\"Taakuren\",\"\"))","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U42*U36,\"\"),0),\"\")","v":""}]
[null,null,null,{"$f":"IF(G34>0,\"Professionalisering\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G34>0,U40*U36,\"\"),0),\"\")","v":""},{"$f":"IF(G34>0,\"Duurz. inz.\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,U41*U36,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S37*H10,0)","v":0},{"$f":"S37+S39","v":0},{"$f":"S39/SUM($S$37:$S$42)","v":{"$error":"#DIV/0!"}},{"$f":"U39*$U$36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(LEFT(H28,2)/40*2*41.475,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Extra voor- en nawerk per jaar in verband met.. (uren op jaarbasis)",null,null,null,null,null,null,null,null,null,"Het is mogelijk dat een bepaalde leerkracht extra ruimte krijgt in verband met bijzondere omstandigheden in de klas. Hiernaast is ruimte gereserveerd om deze uren in te vullen. Dit gaat ten koste van nog bestaande uren voor resttaken en worden verrekend onder de lesgebonden uren.",null,null,null,null,null,null,{"$f":"IF(B37>0,IF(B37>SUM(F37:H37),\"nog \"&B37-SUM(F37:H37)&\" uren te vullen\",IF(B37=SUM(F37:H37),\"verlof is verdeeld\",\"te veel verlofuren ingevuld\")),\"\")","v":""},{"$f":"ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. aantal zorgleerlingen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(T59,0),0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. groepsgrootte"]
[".. startende leerkracht"]
[".. anders"]
["Totaal",null,{"$f":"SUM(C42:C45)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B36=\"Overgangsregeling 56+\",ROUND(340*LEFT(H28,2)/40,0),IF(B36=\"Overgangsregeling 52+\",ROUND(170*LEFT(H28,2)/40,0),IF(B36=\"Basis en bijzonder budget\",ROUND(170*LEFT(H28,2)/40,0),\"\")))","v":""}]
["TOTAALOVERZICHT verdeling werkzaamheden"]
[]
["Lesgebonden uren",null,null,null,"Niet-lesgebonden uren",null,null,null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 52+",170]
["Lesuren op jaarbasis",null,{"$f":"IFERROR(ROUND(IF(G34>0,T57-V37,T57-F37),0),0)","v":0},null,"Professionalisering",null,{"$f":"IFERROR(ROUND(LEFT(H28,2)/40*2*41.475-V40,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["Voor- en nawerk",null,{"$f":"IFERROR(ROUND(IF(G34>0,T58-V39,IF(B37>0,T58-G37,T58)),0),0)","v":0},null,"Duurz. inzetbaarheid",null,{"$f":"IFERROR(ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37-V41,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Extra voor- en nawerk",null,{"$f":"C46","v":0},null,{"$f":"IF(B37>0,\"Verlof duurz. inz.\",IF(G34>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"ROUND(IF(E54=\"\",0,IF(B37>0,B37,U36)),0)","v":0}]
["Totaal lesgebonden uren",null,{"$f":"SUM(C52:C54)","v":0},null,"Totaal",null,{"$f":"SUM(G52:G54)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Enkel basis budget",40]
[]
["Taakuren buiten het voor- en nawerk op jaarbasis",null,null,null,null,null,null,null,null,null,"Onder de taakuren kunnen de uren aan overige taken verder uit gespecificeerd worden. Dit zijn dus de taken welke buiten het voor- en nawerk vallen. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. In dit geval moet het aantal werkuren van de werknemer worden aangepast.",null,null,null,null,null,null,null,"Lesuren op jaarbasis",{"$f":"ROUND(F23*C10+D28-G33,0)","v":0}]
["Ouderavonden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voor- en nawerk",{"$f":"ROUND(T57*H10,0)","v":0}]
["(Team)Vergaderingen",null,null,null,{"$f":"IF(C101<0,\"LET OP:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Resturen op jaarbasis",{"$f":"ROUND(1659*(LEFT(H28,2)/40)-T58-T57-ROUND(IF(A37=\"\",ROUND(LEFT(H28,2)/40*40,0),ROUND(VLOOKUP(B36,$S$51:$T$55,2,FALSE)*LEFT(H28,2)/40,0))-B37,0)-ROUND(LEFT(H28,2)/40*2*41.475,0)-C46,0)","v":0}]
["Teamscholing"]
["Project",null,null,null,{"$f":"IF(C101<0,\"De werktijdfactor is te laag om aan de normjaartaak te voldoen. Vul in cel D25 extra uren in of verstrek een extra dagdeel\",\"\")","v":""}]
["……"]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1659/40*LEFT(H28,2)","v":0}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["….."]
["Resturen op jaarbasis",null,{"$f":"IFERROR(IF(G34>0,ROUND(T59-SUM(C58:C100)-V42,0),ROUND(T59-H37-SUM(C58:C100),0)),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C58:C101)","v":0}]

{"sheet":"wtf leerkracht huidig","index":4,"n_rows":104,"n_cols":20,"rows_kept":104,"cut":false,"hidden":false,"merged":[[57,4,58,5],[59,4,61,6],[35,2,35,3],[32,2,32,3],[34,2,34,3],[33,2,33,3],[34,4,34,7],[37,2,37,3],[39,9,42,13],[34,9,35,13],[56,9,61,13],[17,9,17,13],[10,9,12,13],[20,9,23,13],[25,9,28,13],[31,9,32,13],[14,9,15,13],[1,3,1,4],[4,1,4,3],[4,5,4,6],[5,1,5,3],[5,5,5,6],[6,1,6,3],[10,0,11,2],[10,3,11,3],[10,4,11,5],[28,4,28,5],[18,2,18,3],[12,4,13,5],[12,1,13,3],[7,1,7,7]]}
[]
["Normjaartaak OP schooljaar:"]
[]
["Schoolgegevens",null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,"Naam:"]
["Plaats",null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[]
[null,null,null,null,null,null,null,null,null,"Toelichting"]
["Huidige werktijdfactor",null,null,null,{"$f":"IF(D11>0,FLOOR(D11*40,1)&\" uur\"&IF((ROUND((D11*40-FLOOR(D11*40,1))*60,0))=0,\"\",\" en \"&ROUND((D11*40-FLOOR(D11*40,1))*60,0)&\" minuten\"),\"\")","v":""},null,null,null,null,"De oude werktijdfactor van een werknemer blijft bestaan, maar wordt nu weergegeven in uren en minuten. Hiernaast kunt u de bestaande werktijdfactor invullen."]
[]
[null,{"$f":"IF(C37>0,\"Werktijdfactor exclusief verlof duurzame inzetbaarheid:\",IF(G34>0,\"Werktijdfactor exclusief ouderschapsverlof:\",\"\"))","v":""},null,null,{"$f":"IF(C37>0,FLOOR((D11-(G53/1659))*40,1)&\" uur\"&IF((ROUND(((D11-(G53/1659))*40-FLOOR((D11-(G53/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((D11-(G53/1659))*40-FLOOR((D11-(G53/1659))*40,1))*60,0)&\" minuten\"),IF(G34>0,FLOOR((D11-(G53/1659))*40,1)&\" uur\"&IF((ROUND(((D11-(G53/1659))*40-FLOOR((D11-(G53/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((D11-(G53/1659))*40-FLOOR((D11-(G53/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Het percentage voor- en nawerk bepaalt mede het aantal lesgebonden uren. Een hoger opslagpercentage betekent een lager restant aan overige taken."]
["Gemiddeld aantal schoolweken",null,null,"Percentage voor- en nawerk"]
[]
[]
[null,null,"Lesuren per week"]
[null,null,"Schoolrooster","Werknemer"]
[null,"Maandag",null,null,null,null,null,null,null,"In de rode vlakken hiernaast kan aangegeven worden wat het lesmodel is dat schoolbreed wordt aangehouden. Let hierbij op of het gaat om een onderbouw- of bovenbouwklas. In de blauwe vlakken hiernaast vult u de lesuren van de werknemer in. Dit bepaalt het aantal lesgebonden uren."]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Totaal",{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D21:D25)","v":0},null,null,null,null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Dit kunnen bv. lesuren voor vervanging zijn of extra taakuren zoals de aanwezigheid voor een parttimer bij ouderavonden. Deze uren kunnen ingevuld worden in regel 27."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1958-10-01","1962-10-01"]
["Lesuren per jaar bovenop de jaartaak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35<=P27,\"Overgangsregeling 56+\",IF(C35<=Q27,\"Overgangsregeling 52+\",\"\"))","v":"Overgangsregeling 56+"}]
["Extra lesgevende uren (excl. voor- en nawerk)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35<=P27,\"Basis en bijzonder budget\",IF(C35<=Q27,\"Enkel basis budget\",\"\"))","v":"Basis en bijzonder budget"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35<=P27,\"Enkel basis budget\",\"\")","v":"Enkel basis budget"}]
[]
["Werknemer specifiek",null,null,null,null,null,null,null,null,"Bij vrij geroosterde uren wordt gevraagd naar het aantal te compenseren lesuren op jaarbasis. Voorheen de zogenaamde compensatieverlofuren.",null,null,null,null,null,"verdeling"]
[{"$f":"'wtf OP, basismodel'!A29","v":"Vrij geroosterde lesuren"},null,"Nee",null,{"$f":"IF(C33=\"ja\",\"Aantal lesuren verlof per jaar\",\"\")","v":""},null,0,null,null,null,null,null,null,null,null,"voor/na"]
["Ouderschapsverlof",null,null,null,{"$f":"IF(C34=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""}]
["Geboortedatum",null,null,null,{"$f":"IF(C37>0,\"Verdeling uren verlof duurz. inz.\",IF(G34>0,\"Verdeling uren ouderschapsverlof\",\"\"))","v":""},null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. ",null,null,null,null,null,"lesgebonden/behandeltaken"]
[{"$f":"IF($C$35=\"\",\"\",IF($C$35<$P$27,\"Recht duurzame inzetbaarheid\",IF($C$35<=$Q$27,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,null,null,{"$f":"IF(OR(C37>0,G34>0),\"Lesuren\",\"\")","v":""},{"$f":"IF(OR(C37>0,G34>0),\"v/n-werk\",\"\")","v":""},{"$f":"IF(OR(C37>0,G34>0),\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"G34*1659","v":0}]
[{"$f":"IF(C36=\"\",\"\",IF(C36=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(C36=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(C36=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,null,{"$f":"IF(C36=\"Overgangsregeling 56+\",ROUND(170*D11,0)&\" - \"&ROUND(340*D11,0),IF(C36=\"Overgangsregeling 52+\",\"0 - \"&ROUND(170*D11,0),IF(C36=\"Basis en bijzonder budget\",\"0 - \"&ROUND(170*D11,0),\"\")))","v":""},{"$f":"IFERROR(ROUND(IF(C37>0,S56,IF(G34>0,R36*R37,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C37>0,S57,IF(G34>0,R38*R36,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C37>0,S58,IF(G34>0,R41*R36,\"\")),0),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"ROUND(D26*C16+D29-G33,0)","v":0},null,{"$f":"P37/SUM($P$37:$P$41)","v":{"$error":"#DIV/0!"}},{"$f":"R37*$R$36","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(G34>0,\"Professionalisering\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G34>0,R39*R36,\"\"),0),\"\")","v":""},{"$f":"IF(G34>0,\"Duurz. inzetb.\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G34>0,R40*R36,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"ROUND(Q56*F16,0)","v":0},{"$f":"P37+P38","v":0},{"$f":"P38/SUM($P$37:$P$41)","v":{"$error":"#DIV/0!"}},{"$f":"R38*$R$36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(D11*2*41.475,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Extra voor- en nawerk per jaar in verband met.. (op jaarbasis)",null,null,null,null,null,null,null,null,"Het is mogelijk dat een bepaalde leerkracht extra ruimte krijgt in verband met bijzondere omstandigheden in de klas. Hiernaast is ruimte gereserveerd om deze uren in te vullen. Dit gaat ten koste van nog bestaande uren voor resttaken en worden verrekend onder de lesgebonden uren.",null,null,null,null,null,{"$f":"ROUND(IF(A37=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C36,$P$50:$Q$54,2,FALSE)*D11,0))-C37,0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. aantal zorgleerlingen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(Q58-SUM(C57:C102),0),0)","v":0},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[".. groepsgrootte"]
[".. startende leerkracht"]
[".. anders"]
["Totaal",null,{"$f":"SUM(C41:C44)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36=\"Overgangsregeling 56+\",ROUND(340*LEFT(G29,2)/40,0),IF(C36=\"Overgangsregeling 52+\",ROUND(170*LEFT(G29,2)/40,0),IF(C36=\"Basis en bijzonder budget\",ROUND(170*LEFT(G29,2)/40,0),\"\")))","v":""}]
["TOTAALOVERZICHT verdeling werkzaamheden"]
[]
["Lesgebonden uren",null,null,null,"Niet-lesgebonden uren",null,null,null,null,null,null,null,null,null,null,"Overgangsregeling 52+",170]
["Lesuren op jaarbasis",null,{"$f":"IFERROR(ROUND(IF(G34>0,Q56-S37,Q56-G53/SUM(Q56:Q58)*Q56),0),0)","v":0},null,"Professionalisering",null,{"$f":"IFERROR(ROUND(D11*2*41.475-S39,0),0)","v":0},null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["Voor- en nawerk",null,{"$f":"IFERROR(ROUND(IF(G34>0,Q57-S38,Q57-G53/SUM(Q56:Q58)*Q57),0),0)","v":0},null,"Duurzame inzetbaarheid",null,{"$f":"IFERROR(ROUND(IF(A37=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C36,$P$50:$Q$54,2,FALSE)*D11,0))-C37-S40,0),0)","v":0},null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Extra voor- en nawerk",null,{"$f":"C45","v":0},null,{"$f":"IF(C37>0,\"Verlof duurzame inzetbaarheid\",IF(G34>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"ROUND(IF(E53=\"\",0,IF(C37>0,C37,R36)),0)","v":0}]
["Totaal lesgebonden uren",null,{"$f":"SUM(C51:C53)","v":0},null,"Totaal",null,{"$f":"SUM(G51:G53)","v":0},null,null,null,null,null,null,null,null,"Enkel basis budget",40]
[]
["Taakuren buiten het voor- en nawerk op jaarbasis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lesuren op jaarbasis",{"$f":"ROUND(D26*C16+D29-G33,0)","v":0},null,{"$f":"Q56-C51","v":0},{"$f":"Q56/SUM($S$56:$S$58)","v":{"$error":"#DIV/0!"}}]
["Ouderavonden",null,null,null,null,null,null,null,null,"Onder de taakuren kunnen de uren aan overige taken verder uit gespecificeerd worden. Dit zijn dus de taken welke buiten het voor- en nawerk vallen. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. Dit betekent dus dat de werknemer te veel taken heeft. Hierdoor moet óf de werktijdfactor verhoogd worden, óf het aantal taken moet verminderd worden.",null,null,null,null,null,"Voor- en nawerk",{"$f":"ROUND(Q56*F16,0)","v":0},{"$f":"Q56+Q57","v":0},{"$f":"Q57-C52","v":0},{"$f":"Q57/SUM($S$56:$S$58)","v":{"$error":"#DIV/0!"}}]
["(Team)Vergaderingen",null,null,null,{"$f":"IF(C103<0,\"LET OP:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Rest",{"$f":"ROUND(1659*D11-R57-ROUND(IF(A36=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C36,$P$50:$Q$54,2,FALSE)*D11,0))-C37,0)-ROUND(D11*2*41.475,0)-C45,0)","v":0},null,{"$f":"+Q58-C104","v":0},{"$error":"#DIV/0!"}]
["Teamscholing"]
["Project X",null,null,null,{"$f":"IF(C103<0,\"Het is niet mogelijk de ingevulde werkzaamheden binnen de aangegeven werktijdfactor te voldoen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"1659*D11","v":0}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["Resturen op jaarbasis",null,{"$f":"IFERROR(IF(G34>0,ROUND(Q58-SUM(C57:C102)-S41,0),ROUND(Q58-G53/SUM(Q56:Q58)*Q58-SUM(C57:C99),0)),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C57:C103)","v":0}]

{"sheet":"wtf OOP huidig","index":5,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[24,9,26,13],[38,9,43,13],[34,2,34,3],[44,4,45,5],[46,4,48,6],[28,9,29,13],[29,2,29,3],[30,2,30,3],[31,2,31,3],[31,4,31,7],[31,9,32,13],[32,2,32,3],[14,9,15,13],[17,9,17,13],[20,9,23,13],[7,1,7,7],[10,0,11,2],[10,3,11,3],[10,4,11,5],[10,9,12,13],[12,1,13,3],[12,4,13,5],[18,1,18,2],[6,1,6,3],[1,3,1,4],[4,1,4,3],[4,5,4,6],[5,1,5,3],[5,5,5,6]]}
[]
["Normjaartaak OOP schooljaar:"]
[]
["Schoolgegevens",null,null,null,"Persoonlijke gegevens"]
["School:",null,null,null,"Naam:"]
["Plaats",null,null,null,"Groep:"]
["Datum:"]
["Opmerkingen:"]
[]
[null,null,null,null,null,null,null,null,null,"Toelichting"]
["Huidige werktijdfactor",null,null,0,{"$f":"IF(D11>0,FLOOR(D11*40,1)&\" uur\"&IF((ROUND((D11*40-FLOOR(D11*40,1))*60,0))=0,\"\",\" en \"&ROUND((D11*40-FLOOR(D11*40,1))*60,0)&\" minuten\"),\"\")","v":""},null,null,null,null,"De oude werktijdfactor van een werknemer blijft bestaan, maar wordt nu weergegeven in uren en minuten. Hiernaast kunt u de bestaande werktijdfactor invullen."]
[]
[null,{"$f":"IF(C34>0,\"Werktijdfactor exclusief verlof duurzame inzetbaarheid:\",IF(G31>0,\"Werktijdfactor exclusief ouderschapsverlof:\",\"\"))","v":""},null,null,{"$f":"IF(C34>0,FLOOR((D11-(G40/1659))*40,1)&\" uur\"&IF((ROUND(((D11-(G40/1659))*40-FLOOR((D11-(G40/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((D11-(G40/1659))*40-FLOOR((D11-(G40/1659))*40,1))*60,0)&\" minuten\"),IF(G31>0,FLOOR((D11-(G40/1659))*40,1)&\" uur\"&IF((ROUND(((D11-(G40/1659))*40-FLOOR((D11-(G40/1659))*40,1))*60,0))=0,\"\",\" en \"&ROUND(((D11-(G40/1659))*40-FLOOR((D11-(G40/1659))*40,1))*60,0)&\" minuten\"),\"\"))","v":""}]
[]
[]
["Gemiddeld aantal schoolweken"]
[]
[]
[null,"Uren per week"]
[null,"Schoolrooster","Werknemer",null,"Extra uren per jaar in verband met.. (jaarbasis)"]
["Maandag",null,null,null,".. aantal zorgleerlingen",null,null,null,null,"Ter informatie kunt u in de rode vlakken het les- of schoolrooster invullen wat op de school van toepassing is. Dit is enkel ter info. In de blauwe cellen kunnen de uren per dag ingevuld worden zoals toegepast bij de betreffende werknemer.",null,null,null,null,null,"1958-10-01","1962-10-01"]
["Dinsdag",null,null,null,".. aantal zorgleerlingen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32<=P21,\"Overgangsregeling 56+\",IF(C32<=Q21,\"Overgangsregeling 52+\",\"\"))","v":"Overgangsregeling 56+"}]
["Woensdag",null,null,null,".. groepsgrootte",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32<=P21,\"Basis en bijzonder budget\",IF(C32<=Q21,\"Enkel basis budget\",\"\"))","v":"Basis en bijzonder budget"}]
["Donderdag",null,null,null,".. startende leerkracht",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32<=P21,\"Enkel basis budget\",\"\")","v":"Enkel basis budget"}]
["Vrijdag",null,null,null,".. anders",null,null,null,null,"Naast het standaard aantal werkuren is het mogelijk dat een werknemer incidenteel extra moet werken bovenop de jaartaak. Als dit verwerkt is in de werktijdfactor kan dit als uitsplitsing worden weergegeven onder de 'Extra uren per jaar'."]
["Totaal",{"$f":"SUM(B21:B25)","v":0},{"$f":"SUM(C21:C25)","v":0},null,"Totaal",null,{"$f":"SUM(G21:G25)","v":0},null,null,null,null,null,null,null,null,"verdeling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"voor/na"]
[]
["Werknemer specifiek",null,null,null,null,null,null,null,null,"Bij vrij geroosterde uren wordt gevraagd naar het aantal te compenseren uren op jaarbasis. Voorheen de zogenaamde compensatieverlofuren.",null,null,null,null,null,"lesgebonden/behandeltaken"]
["Vrij geroosterde uren",null,"Nee",null,{"$f":"IF(C30=\"ja\",\"Aantal uren verlof per jaar\",\"\")","v":""},null,0,null,null,null,null,null,null,null,null,"overige taken",null,{"$f":"G31*1659","v":0}]
["Ouderschapsverlof",null,null,null,{"$f":"IF(C31=\"Ja\",\"Werktijdfactor verlof\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"P31/SUM($P$31:$P$35)","v":{"$error":"#DIV/0!"}},{"$f":"R31*$R$30","v":{"$error":"#DIV/0!"}}]
["Geboortedatum",null,null,null,{"$f":"IF(C34>0,\"Verdeling uren verlof duurz. inz.\",IF(G31>0,\"Verdeling uren ouderschapsverlof\",\"\"))","v":""},null,null,null,null,"De leeftijd van de werknemer bepaalt hoeveel recht er is op uren aan duurzame inzetbaarheid. ",null,null,null,null,null,{"$f":"ROUND(Q45*F16,0)","v":0},{"$f":"P31+P32","v":0},{"$f":"P32/SUM($P$31:$P$35)","v":{"$error":"#DIV/0!"}},{"$f":"R32*$R$30","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF($C$32=\"\",\"\",IF($C$32<$P$21,\"Recht duurzame inzetbaarheid\",IF($C$32<=$Q$21,\"Recht duurzame inzetbaarheid\",\"\")))","v":""},null,null,null,{"$f":"IF(OR(C34>0,G31>0),\"Lesuren\",\"\")","v":""},{"$f":"IF(OR(C34>0,G31>0),\"v/n-werk\",\"\")","v":""},{"$f":"IF(OR(C34>0,G31>0),\"Taakuren\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"ROUND(D11*2*41.475,0)","v":0},null,{"$f":"P33/SUM($P$31:$P$35)","v":{"$error":"#DIV/0!"}},{"$f":"R33*$R$30","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(C33=\"\",\"\",IF(C33=\"Overgangsregeling 52+\",\"Aantal uur verlof\",IF(C33=\"Overgangsregeling 56+\",\"Aantal uur verlof\",IF(C33=\"Basis en bijzonder budget\",\"Aantal uur verlof\",\"\"))))","v":""},null,null,{"$f":"IF(C33=\"Overgangsregeling 56+\",ROUND(170*D11,0)&\" - \"&ROUND(340*D11,0),IF(C33=\"Overgangsregeling 52+\",\"0 - \"&ROUND(170*D11,0),IF(C33=\"Basis en bijzonder budget\",\"0 - \"&ROUND(170*D11,0),\"\")))","v":""},{"$f":"IFERROR(ROUND(IF(C34>0,S45,IF(G31>0,R30*R31,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C34>0,S46,IF(G31>0,R32*R30,\"\")),0),\"\")","v":""},{"$f":"IFERROR(ROUND(IF(C34>0,S47,IF(G31>0,R35*R30,\"\")),0),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(A34=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C33,$P$39:$Q$43,2,FALSE)*D11,0))-C34,0)","v":0},null,{"$f":"P34/SUM($P$31:$P$35)","v":{"$error":"#DIV/0!"}},{"$f":"R34*$R$30","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(G31>0,\"Professionalisering\",\"\")","v":""},null,{"$f":"IFERROR(ROUND(IF(G31>0,R33*R30,\"\"),0),\"\")","v":""},{"$f":"IF(G31>0,\"Duurz. inzetb.\",\"\")","v":""},{"$f":"IFERROR(ROUND(IF(G31>0,R34*R30,\"\"),0),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(Q47-SUM(C38:C83),0),0)","v":0},null,{"$f":"P35/SUM($P$31:$P$35)","v":{"$error":"#DIV/0!"}},{"$f":"R35*$R$30","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33=\"Overgangsregeling 56+\",ROUND(340*LEFT(#REF!,2)/40,0),IF(C33=\"Overgangsregeling 52+\",ROUND(170*LEFT(#REF!,2)/40,0),IF(C33=\"Basis en bijzonder budget\",ROUND(170*LEFT(#REF!,2)/40,0),\"\")))","v":""}]
["Taakuren buiten het voor- en nawerk op jaarbasis",null,null,null,"Niet-lesgebonden uren"]
["Extra uren per jaar",null,{"$f":"G26","v":0},null,"Professionalisering",null,{"$f":"IFERROR(ROUND(D11*2*41.475-S33,0),0)","v":0}]
["Standaard werkzaamheden",null,{"$f":"ROUND(C16*C26-SUM(P33:P34),0)","v":0},null,"Duurzame inzetbaarheid",null,{"$f":"IFERROR(ROUND(IF(A34=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C33,$P$39:$Q$43,2,FALSE)*D11,0))-C34-S34,0),0)","v":0},null,null,"Onder de taakuren kunnen de uren  verder uit gespecificeerd worden. Wanneer blijkt dat het gewenst aantal taken niet binnen de huidige werktijdfactor past, zal er een foutmelding getoond worden. Dit betekent dus dat de werknemer te veel taken heeft. Hierdoor moet óf de werktijdfactor verhoogd worden, óf het aantal taken moet verminderd worden.",null,null,null,null,null,"Overgangsregeling 52+",170]
["Ouderavonden",null,null,null,{"$f":"IF(C34>0,\"Verlof duurzame inzetbaarheid\",IF(G31>0,\"Ouderschapsverlof\",\"\"))","v":""},null,{"$f":"ROUND(IF(E40=\"\",0,IF(C34>0,C34,R30)),0)","v":0},null,null,null,null,null,null,null,null,"Overgangsregeling 56+",340]
["(Team)Vergaderingen",null,null,null,"Totaal",null,{"$f":"SUM(G38:G40)","v":0},null,null,null,null,null,null,null,null,"Basis en bijzonder budget",170]
["Teamscholing"]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enkel basis budget",40]
["……"]
["……",null,null,null,{"$f":"IF(C84<0,\"LET OP:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Lesuren op jaarbasis",0,null,0,{"$f":"Q45/SUM($S$45:$S$47)","v":{"$error":"#DIV/0!"}}]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voor- en nawerk",0,{"$f":"Q45+Q46","v":0},0,{"$f":"Q46/SUM($S$45:$S$47)","v":{"$error":"#DIV/0!"}}]
["……",null,null,null,{"$f":"IF(C84<0,\"Het is niet mogelijk de ingevulde werkzaamheden binnen de aangegeven werktijdfactor te voldoen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Rest",{"$f":"ROUND(1659*D11-R46-ROUND(IF(A33=\"\",ROUND(D11*40,0),ROUND(VLOOKUP(C33,$P$39:$Q$43,2,FALSE)*D11,0))-C34,0)-ROUND(D11*2*41.475,0),0)","v":0},null,{"$f":"+Q47-C85","v":0},{"$error":"#DIV/0!"}]
["……"]
["……",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1659*D11","v":0}]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["……"]
["Resturen op jaarbasis",null,{"$f":"IFERROR(IF(G31>0,ROUND(Q47-SUM(C38:C83)-S35,0),ROUND(Q47-G40/SUM(Q45:Q47)*Q47-SUM(C38:C83),0)),0)","v":0}]
["Totaal taakuren",null,{"$f":"SUM(C38:C84)","v":0}]