{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Systeem","SjabloonVoorblad","SjabloonWerkproces","KerntakenEnWerkprocessen","Beheersingsniveaus","Voorblad","B1-K2-W1","B1-K2-W2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":4,"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":"Systeem","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ja/Nee"]
[null,"Ja"]
[null,"Nee"]
[]
[null,"Debug modus"]
[null,0,"Normale bedrijfsstand =  0"]
[]
[null,"Teksten"]
[null,"Werkproces motivatie:","Onderbouw altijd het beoordelingsresultaat.\nBij de onderbouwing kan gebruik gemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]
[]
[null,"Fout markeer opmaak:"]
[]
[]
[null,"\"Grey-out\" opmaak:","greyed out"]
[]
[null,"Copyright tekst:","© Stichting Praktijkleren"]
[]
[null,"Regel afbreken werkprocesnaam:",45]

{"sheet":"SjabloonVoorblad","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,0,2,2],[13,1,13,2],[11,1,11,2],[0,0,0,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[9,1,9,2],[8,1,8,2]]}
["Beoordelingsformulier praktijkexamen"]
[]
["Algemene informatie"]
[]
["Code beoordelingsformulier en vaststellingsdatum",{"$f":"KerntakenEnWerkprocessen!B4","v":"BF_MBI_IS16-B1-K2_3"},{"$f":"KerntakenEnWerkprocessen!B3","v":"2016-04-27"}]
["Examenvorm",{"$f":"KerntakenEnWerkprocessen!C6","v":"Proeve van Bekwaamheid (praktijkexamen in de beroepspraktijk)"}]
["Examennaam",{"$f":"KerntakenEnWerkprocessen!B7","v":"[Examennaam]"}]
["Examencode",{"$f":"KerntakenEnWerkprocessen!C7","v":"[Examencode]"}]
["Profiel",{"$f":"KerntakenEnWerkprocessen!B9","v":"Medewerker ICT, 3"}]
["Kwalificatiedossier",{"$f":"KerntakenEnWerkprocessen!B8","v":"ICT Support"}]
["Cohort en crebocode",{"$f":"KerntakenEnWerkprocessen!C8","v":"2016 en verder"},{"$f":"KerntakenEnWerkprocessen!C9","v":25191}]
["Kerntaak",{"$f":"KerntakenEnWerkprocessen!C5","v":"Behandelen van incidentmeldingen"}]
[]
["Werkprocessen",{"$f":"KerntakenEnWerkprocessen!F2","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]

{"sheet":"SjabloonWerkproces","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[[9,1,9,6],[10,1,10,6],[12,1,12,6]]}
["Werkproces:",null,{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":{"$error":"#N/A"}}]
["Eerste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,3,FALSE)","v":{"$error":"#N/A"}}]
["Laatste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,4,FALSE)","v":{"$error":"#N/A"}}]
["PuntentotaalMax",{"$f":"SUM(N:N)","v":0},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":false}]
["PuntentotaalBehaald",{"$f":"SUM(M:M)","v":0}]
["#Ant. Mog. <=1",{"$f":"COUNTIF(N:N,1)","v":0}]
["#Ant. Mog. 2-3",{"$f":"COUNTIF(N:N,2)+COUNTIF(N:N,3)","v":0}]
["Cesuur",{"$f":"0.5*B4","v":0}]
[]
[null,{"$f":"CONCATENATE(kerntaakCode,\": \",kerntaakNaam)","v":"B1-K2: Behandelen van incidentmeldingen"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":{"$error":"#N/A"}}]
[]
[null,"Persoonsinformatie"]
[null,"Datum"]
[null,"Kandidaat"]
[null,"Leerlingnummer"]
[null,"Klas"]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]

{"sheet":"KerntakenEnWerkprocessen","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[[3,1,3,2]]}
["Kerntaken en werkprocessen"]
[null,null,null,null,null,{"$f":"F27","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]
["Vaststellingsdatum","2016-04-27"]
["Code beoordelingsformulier","BF_MBI_IS16-B1-K2_3"]
["Kerntaak","B1-K2","Behandelen van incidentmeldingen"]
["Examenvorm",null,"Proeve van Bekwaamheid (praktijkexamen in de beroepspraktijk)"]
["Examennaam en Examencode","[Examennaam]","[Examencode]"]
["Kwalificatiedossier en Cohort","ICT Support","2016 en verder"]
["Profiel en crebocode","Medewerker ICT, 3",25191]
[]
[]
["Werkprocessen","Code","Naam","EersteOpdracht","LaatsteOpdracht","TekstSamengevoegd"]
[null,"B1-K2-W1","In behandeling nemen en registreren van incidenten",{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$155))","v":1},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$155))","v":1},{"$f":"B13&\" \"&C13&CHAR(10)","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\n"}]
[null,"B1-K2-W2","Oplossen en/of escaleren van incidenten",{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$155))","v":2},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$155))","v":2},{"$f":"F13&B14&\" \"&C14&CHAR(10)","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"F14&B15&\" \"&C15&CHAR(10)","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"F22&B23&\" \"&C23&CHAR(10)","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$155))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$155=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$155))","v":0},"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n \n \n"]
[]
["Handtekening kandidaat tonen:",null,null,false]

{"sheet":"Beheersingsniveaus","index":4,"n_rows":155,"n_cols":11,"rows_kept":155,"cut":false,"hidden":true,"merged":[]}
["Beschrijvingen beheersingsniveaus"]
[]
["Werkproces","Opdracht","OpdrachtId","CriteriumId","Taken","Criterium","Beheersingsniveau 0","Beheersingsniveau 1","Beheersingsniveau 2","Beheersingsniveau 3","Cruciaal"]
["B1-K2-W1",1,{"$f":"IF(A4<>\"\",CONCATENATE(A4,\"-\",B4),\"\")","v":"B1-K2-W1-1"},{"$f":"IF(C4<>\"\",CONCATENATE(C4,\"-\",\"1\"),\"\")","v":"B1-K2-W1-1-1"},"T1","Klantcontact","De houding is weinig tot niet klantvriendelijk en begripvol.","De houding is voor een klein deel klantvriendelijk en begripvol.","De houding is grotendeels klantvriendelijk en begripvol.\n","De houding is volledig klantvriendelijk en begripvol."]
["B1-K2-W1",1,{"$f":"IF(A5<>\"\",CONCATENATE(A5,\"-\",B5),\"\")","v":"B1-K2-W1-1"},{"$f":"IF(C5<>\"\",CONCATENATE(C5,\"-\",COUNTIF($C$4:C5,C5),\"\"),\"\")","v":"B1-K2-W1-1-2"},"T1","Communiceren\n(LSD-methode)","Er wordt niet of te weinig geluisterd, samengevat en doorgevraagd.\n","Er wordt weinig geluisterd, samengevat en doorgevraagd.","Er wordt overwegend geluisterd, samengevat en doorgevraagd.","Er wordt volledig geluisterd, samengevat en doorgevraagd."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C6<>\"\",CONCATENATE(C6,\"-\",COUNTIF($C$4:C6,C6),\"\"),\"\")","v":"B1-K2-W1-1-3"},"T1","Vaststellen probleem","Minder dan 80% van de problemen is vastgesteld.","Minimaal 80% van de problemen is vastgesteld.","Minimaal 90% van de problemen is vastgesteld.\n","Alle problemen zijn vastgesteld.","Ja"]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C7<>\"\",CONCATENATE(C7,\"-\",COUNTIF($C$4:C7,C7),\"\"),\"\")","v":"B1-K2-W1-1-4"},"T1, T5","Taal Engels","De uitspraak van bekende woorden kan met enige inspanning worden verstaan. Woordgebruik en woordenschat (vaktaal Engels) worden onvoldoende toegepast. \n","De uitspraak is meestal duidelijk genoeg om verstaanbaar te zijn. Woordgebruik en woordenschat (vaktaal Engels) worden meestal toereikend toegepast. ","De uitspraak is duidelijk verstaanbaar. Woordgebruik en woordenschat (vaktaal Engels) worden meestal toereikend toegepast. ","De uitspraak is duidelijk verstaanbaar. Woordgebruik en woordenschat (vaktaal Engels) worden toereikend toegepast."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C8<>\"\",CONCATENATE(C8,\"-\",COUNTIF($C$4:C8,C8),\"\"),\"\")","v":"B1-K2-W1-1-5"},"T1, T5","Taal Nederlands","Stemt woordgebruik en vaktaal niet af op de doelgroep. Er worden vooral frequent voorkomende woorden en uitsluitend eenvoudige zinsconstructies gebruikt.","Stemt woordgebruik en vaktaal meestal af op de doelgroep. Past variatie in het woordgebruik meestal toe. Toont meestal een redelijke grammaticale beheersing.","Stemt woordgebruik en vaktaal op een enkel detail na af op de doelgroep. Past variatie in het woordgebruik toe. Toont op een enkel detail na een redelijke grammaticale beheersing.\n","Stemt woordgebruik en vaktaal af op de doelgroep. Past variatie in het woordgebruik toe. Toont een redelijke grammaticale beheersing."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C9<>\"\",CONCATENATE(C9,\"-\",COUNTIF($C$4:C9,C9),\"\"),\"\")","v":"B1-K2-W1-1-6"},"T2","Handelen conform bedrijfs-\nprocedures/SLA","Minder dan 80% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA.","Minimaal 80% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA.","Minimaal 90% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA.\n","Alle meldingen worden behandeld conform interne bedrijfsprocedures en/of SLA.","Ja"]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C10<>\"\",CONCATENATE(C10,\"-\",COUNTIF($C$4:C10,C10),\"\"),\"\")","v":"B1-K2-W1-1-7"},"T3","Categoriseren ","Minder dan 80% van de meldingen is juist gecategoriseerd.\n","Minimaal 80% van de meldingen is juist gecategoriseerd.","Minimaal 90% van de meldingen is juist gecategoriseerd.","Alle meldingen zijn juist gecategoriseerd."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C11<>\"\",CONCATENATE(C11,\"-\",COUNTIF($C$4:C11,C11),\"\"),\"\")","v":"B1-K2-W1-1-8"},"T3","Prioriteren","Minder dan 80% van de meldingen is juist geprioriteerd.\n","Minimaal 80% van de meldingen is juist geprioriteerd.","Minimaal 90% van de meldingen is juist geprioriteerd.","Alle meldingen zijn juist geprioriteerd."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C12<>\"\",CONCATENATE(C12,\"-\",COUNTIF($C$4:C12,C12),\"\"),\"\")","v":"B1-K2-W1-1-9"},"T3","Tijdsindicatie","Minder dan 80% van de meldingen is voorzien van een juiste tijdsindicatie.","Minimaal 80% van de meldingen is voorzien van een juiste tijdsindicatie.","Minimaal 90% van de meldingen is voorzien van een juiste tijdsindicatie.\n","Alle meldingen zijn voorzien van een juiste tijdsindicatie."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C13<>\"\",CONCATENATE(C13,\"-\",COUNTIF($C$4:C13,C13),\"\"),\"\")","v":"B1-K2-W1-1-10"},"T4","Doorzetten incidenten","Minder dan 80% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd.","Minimaal 80% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd.","Minimaal 90% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd.\n","Alle meldingen zijn juist doorgezet, of de leidinggevende is geraadpleegd."]
["B1-K2-W1",1,{"$f":"IF(A14<>\"\",CONCATENATE(A14,\"-\",B14),\"\")","v":"B1-K2-W1-1"},{"$f":"IF(C14<>\"\",CONCATENATE(C14,\"-\",COUNTIF($C$4:C14,C14),\"\"),\"\")","v":"B1-K2-W1-1-11"},"T4","Initiatief tonen","Minder dan 80% van de melders is geïnformeerd over de voortgang van de melding.","Minimaal 80% van de melders is geïnformeerd over de voortgang van de melding.","Minimaal 90% van de melders is geïnformeerd over de voortgang van de melding.\n","Alle melders zijn geïnformeerd over de voortgang van de melding."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C15<>\"\",CONCATENATE(C15,\"-\",COUNTIF($C$4:C15,C15),\"\"),\"\")","v":"B1-K2-W1-1-12"},"T5","Informeren melders","Minder dan 80% van de melders is geïnformeerd over de voortgang van de melding.","Minimaal 80% van de melders is geïnformeerd over de voortgang van de melding.","Minimaal 90% van de melders is geïnformeerd over de voortgang van de melding.\n","Alle melders zijn geïnformeerd over de voortgang van de melding."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C16<>\"\",CONCATENATE(C16,\"-\",COUNTIF($C$4:C16,C16),\"\"),\"\")","v":"B1-K2-W1-1-13"},"T6","Documentatie","Minder dan 80% van de meldingen is voorzien van een juiste documentatie.\n","Minimaal 80% van de meldingen is voorzien van een juiste documentatie.","Minimaal 90% van de meldingen is voorzien van een juiste documentatie.","Alle meldingen zijn voorzien van een juiste documentatie."]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C17<>\"\",CONCATENATE(C17,\"-\",COUNTIF($C$4:C17,C17),\"\"),\"\")","v":"B1-K2-W1-1-14"},"T6","Registratie","Minder dan 80% van de meldingen is voorzien van een juiste registratie.","Minimaal 80% van de meldingen is voorzien van een juiste registratie.","Minimaal 90% van de meldingen is voorzien van een juiste registratie.\n","Alle meldingen zijn voorzien van een juiste registratie.","Ja"]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C18<>\"\",CONCATENATE(C18,\"-\",COUNTIF($C$4:C18,C18),\"\"),\"\")","v":"B1-K2-W1-1-15"},"T1 t/m T6","Werktempo","Er is in een te laag tempo gewerkt.\n","Er is in een passend tempo gewerkt."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C19<>\"\",CONCATENATE(C19,\"-\",COUNTIF($C$4:C19,C19),\"\"),\"\")","v":"B1-K2-W2-2-1"},"T1","Escaleren","Minder dan 80% van de meldingen is juist geëscaleerd. ","Minimaal 80% van de meldingen is juist geëscaleerd.","Minimaal 90% van de meldingen is juist geëscaleerd.\n","Alle meldingen zijn juist geëscaleerd.","Ja"]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C20<>\"\",CONCATENATE(C20,\"-\",COUNTIF($C$4:C20,C20),\"\"),\"\")","v":"B1-K2-W2-2-2"},"T2","Oplossen meldingen","Minder dan 80% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende niet geraadpleegd.","Minimaal 80% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende niet geraadpleegd.","Minimaal 90% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende geraadpleegd.\n","Alle meldingen zijn juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende geraadpleegd.","Ja"]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C21<>\"\",CONCATENATE(C21,\"-\",COUNTIF($C$4:C21,C21),\"\"),\"\")","v":"B1-K2-W2-2-3"},"T2","Testen oplossingen","Oplossingen zijn niet of deels getest op werking.\n","Alle oplossingen zijn getest op werking."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C22<>\"\",CONCATENATE(C22,\"-\",COUNTIF($C$4:C22,C22),\"\"),\"\")","v":"B1-K2-W2-2-4"},"T3","Terugkoppelen","Minder dan 80% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant.","Minimaal 80% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant.","Minimaal 90% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant.\n","Alle afgehandelde meldingen worden juist teruggekoppeld aan de klant."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C23<>\"\",CONCATENATE(C23,\"-\",COUNTIF($C$4:C23,C23),\"\"),\"\")","v":"B1-K2-W2-2-5"},"T3","Schrijven Engels","Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling volledig onbegrijpelijk.","Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling grotendeels onbegrijpelijk.","Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling grotendeels begrijpelijk.\n","Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling volledig begrijpelijk."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C24<>\"\",CONCATENATE(C24,\"-\",COUNTIF($C$4:C24,C24),\"\"),\"\")","v":"B1-K2-W2-2-6"},"T3","Controleren tevredenheid","Bij minder dan 80% van de afgehandelde meldingen is de tevredenheid gecontroleerd.","Bij minimaal 80% van de afgehandelde meldingen is de tevredenheid gecontroleerd.","Bij minimaal 90% van de afgehandelde meldingen is de tevredenheid gecontroleerd.\n","Bij alle afgehandelde meldingen is de tevredenheid gecontroleerd."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C25<>\"\",CONCATENATE(C25,\"-\",COUNTIF($C$4:C25,C25),\"\"),\"\")","v":"B1-K2-W2-2-7"},"T4","Registreren","Minder dan 80% van de meldingen is voorzien van een juiste registratie.","Minimaal 80% van de meldingen is voorzien van een juiste registratie.","Minimaal 90% van de meldingen is voorzien van een juiste registratie.\n","Alle meldingen zijn voorzien van een juiste registratie."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C26<>\"\",CONCATENATE(C26,\"-\",COUNTIF($C$4:C26,C26),\"\"),\"\")","v":"B1-K2-W2-2-8"},"T5","Documenteren","Minder dan 80% van de meldingen is voorzien van een juiste documentatie.","Minimaal 80% van de meldingen is voorzien van een juiste documentatie.","Minimaal 90% van de meldingen is voorzien van een juiste documentatie.\n","Alle meldingen zijn voorzien van een juiste documentatie."]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C27<>\"\",CONCATENATE(C27,\"-\",COUNTIF($C$4:C27,C27),\"\"),\"\")","v":"B1-K2-W2-2-9"},"T1 t/m T5","Werktempo","Er is in een te laag tempo gewerkt.\n","Er is in een passend tempo gewerkt."]
[null,null,"",{"$f":"IF(C28<>\"\",CONCATENATE(C28,\"-\",COUNTIF($C$4:C28,C28),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C29<>\"\",CONCATENATE(C29,\"-\",COUNTIF($C$4:C29,C29),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C30<>\"\",CONCATENATE(C30,\"-\",COUNTIF($C$4:C30,C30),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C31<>\"\",CONCATENATE(C31,\"-\",COUNTIF($C$4:C31,C31),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C32<>\"\",CONCATENATE(C32,\"-\",COUNTIF($C$4:C32,C32),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C33<>\"\",CONCATENATE(C33,\"-\",COUNTIF($C$4:C33,C33),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C34<>\"\",CONCATENATE(C34,\"-\",COUNTIF($C$4:C34,C34),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C35<>\"\",CONCATENATE(C35,\"-\",COUNTIF($C$4:C35,C35),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C36<>\"\",CONCATENATE(C36,\"-\",COUNTIF($C$4:C36,C36),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C37<>\"\",CONCATENATE(C37,\"-\",COUNTIF($C$4:C37,C37),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C38<>\"\",CONCATENATE(C38,\"-\",COUNTIF($C$4:C38,C38),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C39<>\"\",CONCATENATE(C39,\"-\",COUNTIF($C$4:C39,C39),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C40<>\"\",CONCATENATE(C40,\"-\",COUNTIF($C$4:C40,C40),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C41<>\"\",CONCATENATE(C41,\"-\",COUNTIF($C$4:C41,C41),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C42<>\"\",CONCATENATE(C42,\"-\",COUNTIF($C$4:C42,C42),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C43<>\"\",CONCATENATE(C43,\"-\",COUNTIF($C$4:C43,C43),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C44<>\"\",CONCATENATE(C44,\"-\",COUNTIF($C$4:C44,C44),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C45<>\"\",CONCATENATE(C45,\"-\",COUNTIF($C$4:C45,C45),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C46<>\"\",CONCATENATE(C46,\"-\",COUNTIF($C$4:C46,C46),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C47<>\"\",CONCATENATE(C47,\"-\",COUNTIF($C$4:C47,C47),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C48<>\"\",CONCATENATE(C48,\"-\",COUNTIF($C$4:C48,C48),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C49<>\"\",CONCATENATE(C49,\"-\",COUNTIF($C$4:C49,C49),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C50<>\"\",CONCATENATE(C50,\"-\",COUNTIF($C$4:C50,C50),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C51<>\"\",CONCATENATE(C51,\"-\",COUNTIF($C$4:C51,C51),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C52<>\"\",CONCATENATE(C52,\"-\",COUNTIF($C$4:C52,C52),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C53<>\"\",CONCATENATE(C53,\"-\",COUNTIF($C$4:C53,C53),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C54<>\"\",CONCATENATE(C54,\"-\",COUNTIF($C$4:C54,C54),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C55<>\"\",CONCATENATE(C55,\"-\",COUNTIF($C$4:C55,C55),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C56<>\"\",CONCATENATE(C56,\"-\",COUNTIF($C$4:C56,C56),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C57<>\"\",CONCATENATE(C57,\"-\",COUNTIF($C$4:C57,C57),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C58<>\"\",CONCATENATE(C58,\"-\",COUNTIF($C$4:C58,C58),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C59<>\"\",CONCATENATE(C59,\"-\",COUNTIF($C$4:C59,C59),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C60<>\"\",CONCATENATE(C60,\"-\",COUNTIF($C$4:C60,C60),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C61<>\"\",CONCATENATE(C61,\"-\",COUNTIF($C$4:C61,C61),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C62<>\"\",CONCATENATE(C62,\"-\",COUNTIF($C$4:C62,C62),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C63<>\"\",CONCATENATE(C63,\"-\",COUNTIF($C$4:C63,C63),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C64<>\"\",CONCATENATE(C64,\"-\",COUNTIF($C$4:C64,C64),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C65<>\"\",CONCATENATE(C65,\"-\",COUNTIF($C$4:C65,C65),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C66<>\"\",CONCATENATE(C66,\"-\",COUNTIF($C$4:C66,C66),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C67<>\"\",CONCATENATE(C67,\"-\",COUNTIF($C$4:C67,C67),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C68<>\"\",CONCATENATE(C68,\"-\",COUNTIF($C$4:C68,C68),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C69<>\"\",CONCATENATE(C69,\"-\",COUNTIF($C$4:C69,C69),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A70<>\"\",CONCATENATE(A70,\"-\",B70),\"\")","v":""},{"$f":"IF(C70<>\"\",CONCATENATE(C70,\"-\",COUNTIF($C$4:C70,C70),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C71<>\"\",CONCATENATE(C71,\"-\",COUNTIF($C$4:C71,C71),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C72<>\"\",CONCATENATE(C72,\"-\",COUNTIF($C$4:C72,C72),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C73<>\"\",CONCATENATE(C73,\"-\",COUNTIF($C$4:C73,C73),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C74<>\"\",CONCATENATE(C74,\"-\",COUNTIF($C$4:C74,C74),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C75<>\"\",CONCATENATE(C75,\"-\",COUNTIF($C$4:C75,C75),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C76<>\"\",CONCATENATE(C76,\"-\",COUNTIF($C$4:C76,C76),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C77<>\"\",CONCATENATE(C77,\"-\",COUNTIF($C$4:C77,C77),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C78<>\"\",CONCATENATE(C78,\"-\",COUNTIF($C$4:C78,C78),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C79<>\"\",CONCATENATE(C79,\"-\",COUNTIF($C$4:C79,C79),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C80<>\"\",CONCATENATE(C80,\"-\",COUNTIF($C$4:C80,C80),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C81<>\"\",CONCATENATE(C81,\"-\",COUNTIF($C$4:C81,C81),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C82<>\"\",CONCATENATE(C82,\"-\",COUNTIF($C$4:C82,C82),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C83<>\"\",CONCATENATE(C83,\"-\",COUNTIF($C$4:C83,C83),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C84<>\"\",CONCATENATE(C84,\"-\",COUNTIF($C$4:C84,C84),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C85<>\"\",CONCATENATE(C85,\"-\",COUNTIF($C$4:C85,C85),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C86<>\"\",CONCATENATE(C86,\"-\",COUNTIF($C$4:C86,C86),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C87<>\"\",CONCATENATE(C87,\"-\",COUNTIF($C$4:C87,C87),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C88<>\"\",CONCATENATE(C88,\"-\",COUNTIF($C$4:C88,C88),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C89<>\"\",CONCATENATE(C89,\"-\",COUNTIF($C$4:C89,C89),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C90<>\"\",CONCATENATE(C90,\"-\",COUNTIF($C$4:C90,C90),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C91<>\"\",CONCATENATE(C91,\"-\",COUNTIF($C$4:C91,C91),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C92<>\"\",CONCATENATE(C92,\"-\",COUNTIF($C$4:C92,C92),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C93<>\"\",CONCATENATE(C93,\"-\",COUNTIF($C$4:C93,C93),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C94<>\"\",CONCATENATE(C94,\"-\",COUNTIF($C$4:C94,C94),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C95<>\"\",CONCATENATE(C95,\"-\",COUNTIF($C$4:C95,C95),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C96<>\"\",CONCATENATE(C96,\"-\",COUNTIF($C$4:C96,C96),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C97<>\"\",CONCATENATE(C97,\"-\",COUNTIF($C$4:C97,C97),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C98<>\"\",CONCATENATE(C98,\"-\",COUNTIF($C$4:C98,C98),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C99<>\"\",CONCATENATE(C99,\"-\",COUNTIF($C$4:C99,C99),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C100<>\"\",CONCATENATE(C100,\"-\",COUNTIF($C$4:C100,C100),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C101<>\"\",CONCATENATE(C101,\"-\",COUNTIF($C$4:C101,C101),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C102<>\"\",CONCATENATE(C102,\"-\",COUNTIF($C$4:C102,C102),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C103<>\"\",CONCATENATE(C103,\"-\",COUNTIF($C$4:C103,C103),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C104<>\"\",CONCATENATE(C104,\"-\",COUNTIF($C$4:C104,C104),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C105<>\"\",CONCATENATE(C105,\"-\",COUNTIF($C$4:C105,C105),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A106<>\"\",CONCATENATE(A106,\"-\",B106),\"\")","v":""},{"$f":"IF(C106<>\"\",CONCATENATE(C106,\"-\",COUNTIF($C$4:C106,C106),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C107<>\"\",CONCATENATE(C107,\"-\",COUNTIF($C$4:C107,C107),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C108<>\"\",CONCATENATE(C108,\"-\",COUNTIF($C$4:C108,C108),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C109<>\"\",CONCATENATE(C109,\"-\",COUNTIF($C$4:C109,C109),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C110<>\"\",CONCATENATE(C110,\"-\",COUNTIF($C$4:C110,C110),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(A111<>\"\",CONCATENATE(A111,\"-\",B111),\"\")","v":""},{"$f":"IF(C111<>\"\",CONCATENATE(C111,\"-\",COUNTIF($C$4:C111,C111),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C112<>\"\",CONCATENATE(C112,\"-\",COUNTIF($C$4:C112,C112),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C113<>\"\",CONCATENATE(C113,\"-\",COUNTIF($C$4:C113,C113),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C114<>\"\",CONCATENATE(C114,\"-\",COUNTIF($C$4:C114,C114),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C115<>\"\",CONCATENATE(C115,\"-\",COUNTIF($C$4:C115,C115),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C116<>\"\",CONCATENATE(C116,\"-\",COUNTIF($C$4:C116,C116),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C117<>\"\",CONCATENATE(C117,\"-\",COUNTIF($C$4:C117,C117),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C118<>\"\",CONCATENATE(C118,\"-\",COUNTIF($C$4:C118,C118),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C119<>\"\",CONCATENATE(C119,\"-\",COUNTIF($C$4:C119,C119),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C120<>\"\",CONCATENATE(C120,\"-\",COUNTIF($C$4:C120,C120),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C121<>\"\",CONCATENATE(C121,\"-\",COUNTIF($C$4:C121,C121),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C122<>\"\",CONCATENATE(C122,\"-\",COUNTIF($C$4:C122,C122),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C123<>\"\",CONCATENATE(C123,\"-\",COUNTIF($C$4:C123,C123),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C124<>\"\",CONCATENATE(C124,\"-\",COUNTIF($C$4:C124,C124),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C125<>\"\",CONCATENATE(C125,\"-\",COUNTIF($C$4:C125,C125),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C126<>\"\",CONCATENATE(C126,\"-\",COUNTIF($C$4:C126,C126),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C127<>\"\",CONCATENATE(C127,\"-\",COUNTIF($C$4:C127,C127),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C128<>\"\",CONCATENATE(C128,\"-\",COUNTIF($C$4:C128,C128),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C129<>\"\",CONCATENATE(C129,\"-\",COUNTIF($C$4:C129,C129),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C130<>\"\",CONCATENATE(C130,\"-\",COUNTIF($C$4:C130,C130),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C131<>\"\",CONCATENATE(C131,\"-\",COUNTIF($C$4:C131,C131),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C132<>\"\",CONCATENATE(C132,\"-\",COUNTIF($C$4:C132,C132),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C133<>\"\",CONCATENATE(C133,\"-\",COUNTIF($C$4:C133,C133),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C134<>\"\",CONCATENATE(C134,\"-\",COUNTIF($C$4:C134,C134),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C135<>\"\",CONCATENATE(C135,\"-\",COUNTIF($C$4:C135,C135),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C136<>\"\",CONCATENATE(C136,\"-\",COUNTIF($C$4:C136,C136),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C137<>\"\",CONCATENATE(C137,\"-\",COUNTIF($C$4:C137,C137),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C138<>\"\",CONCATENATE(C138,\"-\",COUNTIF($C$4:C138,C138),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C139<>\"\",CONCATENATE(C139,\"-\",COUNTIF($C$4:C139,C139),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C140<>\"\",CONCATENATE(C140,\"-\",COUNTIF($C$4:C140,C140),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C141<>\"\",CONCATENATE(C141,\"-\",COUNTIF($C$4:C141,C141),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C142<>\"\",CONCATENATE(C142,\"-\",COUNTIF($C$4:C142,C142),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C143<>\"\",CONCATENATE(C143,\"-\",COUNTIF($C$4:C143,C143),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C144<>\"\",CONCATENATE(C144,\"-\",COUNTIF($C$4:C144,C144),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C145<>\"\",CONCATENATE(C145,\"-\",COUNTIF($C$4:C145,C145),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C146<>\"\",CONCATENATE(C146,\"-\",COUNTIF($C$4:C146,C146),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C147<>\"\",CONCATENATE(C147,\"-\",COUNTIF($C$4:C147,C147),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C148<>\"\",CONCATENATE(C148,\"-\",COUNTIF($C$4:C148,C148),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C149<>\"\",CONCATENATE(C149,\"-\",COUNTIF($C$4:C149,C149),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C150<>\"\",CONCATENATE(C150,\"-\",COUNTIF($C$4:C150,C150),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C151<>\"\",CONCATENATE(C151,\"-\",COUNTIF($C$4:C151,C151),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C152<>\"\",CONCATENATE(C152,\"-\",COUNTIF($C$4:C152,C152),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C153<>\"\",CONCATENATE(C153,\"-\",COUNTIF($C$4:C153,C153),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C154<>\"\",CONCATENATE(C154,\"-\",COUNTIF($C$4:C154,C154),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C155<>\"\",CONCATENATE(C155,\"-\",COUNTIF($C$4:C155,C155),\"\"),\"\")","v":""}]

{"sheet":"Voorblad","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,9,2],[11,1,11,2],[13,1,13,2],[0,0,0,2],[2,0,2,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
["Beoordelingsformulier praktijkexamen"]
[]
["Algemene informatie"]
[]
["Code beoordelingsformulier en vaststellingsdatum",{"$f":"KerntakenEnWerkprocessen!B4","v":"BF_MBI_IS16-B1-K2_3"},{"$f":"KerntakenEnWerkprocessen!B3","v":"2016-04-27"}]
["Examenvorm",{"$f":"KerntakenEnWerkprocessen!C6","v":"Proeve van Bekwaamheid (praktijkexamen in de beroepspraktijk)"}]
["Examennaam",{"$f":"KerntakenEnWerkprocessen!B7","v":"[Examennaam]"}]
["Examencode",{"$f":"KerntakenEnWerkprocessen!C7","v":"[Examencode]"}]
["Profiel",{"$f":"KerntakenEnWerkprocessen!B9","v":"Medewerker ICT, 3"}]
["Kwalificatiedossier",{"$f":"KerntakenEnWerkprocessen!B8","v":"ICT Support"}]
["Cohort en crebocode",{"$f":"KerntakenEnWerkprocessen!C8","v":"2016 en verder"},{"$f":"KerntakenEnWerkprocessen!C9","v":25191}]
["Kerntaak",{"$f":"KerntakenEnWerkprocessen!C5","v":"Behandelen van incidentmeldingen"}]
[]
["Werkprocessen",{"$f":"KerntakenEnWerkprocessen!F2","v":"B1-K2-W1 In behandeling nemen en registreren van incidenten\nB1-K2-W2 Oplossen en/of escaleren van incidenten\n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]

{"sheet":"B1-K2-W1","index":6,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[[102,1,102,6],[106,2,106,3],[107,2,107,3],[9,1,9,6],[10,1,10,6],[12,1,12,6],[20,1,20,6],[39,1,39,6],[101,1,101,6]]}
["Werkproces:","B1-K2-W1",{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":"In behandeling nemen en registreren van incidenten"}]
["Eerste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,3,FALSE)","v":1}]
["Laatste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,4,FALSE)","v":1}]
["PuntentotaalMax",{"$f":"SUM(N:N)","v":43},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":false}]
["PuntentotaalBehaald",{"$f":"SUM(M:M)","v":0}]
["#Ant. Mog. <=1",{"$f":"COUNTIF(N:N,1)","v":1}]
["#Ant. Mog. 2-3",{"$f":"COUNTIF(N:N,2)+COUNTIF(N:N,3)","v":14}]
["Cesuur",{"$f":"0.5*B4","v":21.5}]
[]
[null,{"$f":"CONCATENATE(kerntaakCode,\": \",kerntaakNaam)","v":"B1-K2: Behandelen van incidentmeldingen"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":"B1-K2-W1: In behandeling nemen en registreren van incidenten"}]
[]
[null,"Persoonsinformatie"]
[null,"Datum"]
[null,"Kandidaat"]
[null,"Leerlingnummer"]
[null,"Klas"]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]
[]
[null,"Beoordeling opdracht 1"]
["Opdracht:",1,null,"OpdrachtId:","B1-K2-W1-1",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E22)","v":15}]
["CriteriumId","Taak","Criterium",0,1,2,3,"Cruciaal","Cb0","Cb1","Cb2","Cb3","PuntentotaalBehaald","PuntentotaalMax","CheckboxenIngevuld"]
["B1-K2-W1-1-1",{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H24=ja,\"*\",\"\"))","v":"Klantcontact"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De houding is weinig tot niet klantvriendelijk en begripvol."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De houding is voor een klein deel klantvriendelijk en begripvol."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De houding is grotendeels klantvriendelijk en begripvol.\n"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De houding is volledig klantvriendelijk en begripvol."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,{"$f":"IF(L24=TRUE,3,IF(K24=TRUE,2,IF(J24=TRUE,1,IF(I24=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D24:G24))-1","v":3},{"$f":"COUNTA(I24:L24)","v":0}]
["B1-K2-W1-1-2",{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H25=ja,\"*\",\"\"))","v":"Communiceren\n(LSD-methode)"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Er wordt niet of te weinig geluisterd, samengevat en doorgevraagd.\n"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Er wordt weinig geluisterd, samengevat en doorgevraagd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Er wordt overwegend geluisterd, samengevat en doorgevraagd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Er wordt volledig geluisterd, samengevat en doorgevraagd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-3",{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H26=ja,\"*\",\"\"))","v":"Vaststellen probleem*"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de problemen is vastgesteld."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de problemen is vastgesteld."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de problemen is vastgesteld.\n"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle problemen zijn vastgesteld."},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":"Ja"},null,null,null,null,0,3,0]
["B1-K2-W1-1-4",{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1, T5"},{"$f":"CONCATENATE(VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H27=ja,\"*\",\"\"))","v":"Taal Engels"},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De uitspraak van bekende woorden kan met enige inspanning worden verstaan. Woordgebruik en woordenschat (vaktaal Engels) worden onvoldoende toegepast. \n"},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"De uitspraak is meestal duidelijk genoeg om verstaanbaar te zijn. Woordgebruik en woordenschat (vaktaal Engels) worden meestal toereikend toegepast. "},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"De uitspraak is duidelijk verstaanbaar. Woordgebruik en woordenschat (vaktaal Engels) worden meestal toereikend toegepast. "},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"De uitspraak is duidelijk verstaanbaar. Woordgebruik en woordenschat (vaktaal Engels) worden toereikend toegepast."},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-5",{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1, T5"},{"$f":"CONCATENATE(VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H28=ja,\"*\",\"\"))","v":"Taal Nederlands"},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Stemt woordgebruik en vaktaal niet af op de doelgroep. Er worden vooral frequent voorkomende woorden en uitsluitend eenvoudige zinsconstructies gebruikt."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Stemt woordgebruik en vaktaal meestal af op de doelgroep. Past variatie in het woordgebruik meestal toe. Toont meestal een redelijke grammaticale beheersing."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Stemt woordgebruik en vaktaal op een enkel detail na af op de doelgroep. Past variatie in het woordgebruik toe. Toont op een enkel detail na een redelijke grammaticale beheersing.\n"},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Stemt woordgebruik en vaktaal af op de doelgroep. Past variatie in het woordgebruik toe. Toont een redelijke grammaticale beheersing."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-6",{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T2"},{"$f":"CONCATENATE(VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H29=ja,\"*\",\"\"))","v":"Handelen conform bedrijfs-\nprocedures/SLA*"},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen wordt behandeld conform interne bedrijfsprocedures en/of SLA.\n"},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen worden behandeld conform interne bedrijfsprocedures en/of SLA."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":"Ja"},null,null,null,null,0,3,0]
["B1-K2-W1-1-7",{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H30=ja,\"*\",\"\"))","v":"Categoriseren "},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is juist gecategoriseerd.\n"},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is juist gecategoriseerd."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is juist gecategoriseerd."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn juist gecategoriseerd."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-8",{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H31=ja,\"*\",\"\"))","v":"Prioriteren"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is juist geprioriteerd.\n"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is juist geprioriteerd."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is juist geprioriteerd."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn juist geprioriteerd."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-9",{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H32=ja,\"*\",\"\"))","v":"Tijdsindicatie"},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is voorzien van een juiste tijdsindicatie."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is voorzien van een juiste tijdsindicatie."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is voorzien van een juiste tijdsindicatie.\n"},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn voorzien van een juiste tijdsindicatie."},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-10",{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T4"},{"$f":"CONCATENATE(VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H33=ja,\"*\",\"\"))","v":"Doorzetten incidenten"},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is juist doorgezet, of de leidinggevende is geraadpleegd.\n"},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn juist doorgezet, of de leidinggevende is geraadpleegd."},{"$f":"VLOOKUP($A33,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-11",{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T4"},{"$f":"CONCATENATE(VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H34=ja,\"*\",\"\"))","v":"Initiatief tonen"},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de melders is geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de melders is geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de melders is geïnformeerd over de voortgang van de melding.\n"},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle melders zijn geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A34,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-12",{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T5"},{"$f":"CONCATENATE(VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H35=ja,\"*\",\"\"))","v":"Informeren melders"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de melders is geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de melders is geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de melders is geïnformeerd over de voortgang van de melding.\n"},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle melders zijn geïnformeerd over de voortgang van de melding."},{"$f":"VLOOKUP($A35,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-13",{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T6"},{"$f":"CONCATENATE(VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H36=ja,\"*\",\"\"))","v":"Documentatie"},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is voorzien van een juiste documentatie.\n"},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A36,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W1-1-14",{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T6"},{"$f":"CONCATENATE(VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H37=ja,\"*\",\"\"))","v":"Registratie*"},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is voorzien van een juiste registratie."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is voorzien van een juiste registratie."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is voorzien van een juiste registratie.\n"},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn voorzien van een juiste registratie."},{"$f":"VLOOKUP($A37,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":"Ja"},null,null,null,null,0,3,0]
["B1-K2-W1-1-15",{"$f":"VLOOKUP($A38,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1 t/m T6"},{"$f":"CONCATENATE(VLOOKUP($A38,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H38=ja,\"*\",\"\"))","v":"Werktempo"},{"$f":"VLOOKUP($A38,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Er is in een te laag tempo gewerkt.\n"},{"$f":"VLOOKUP($A38,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Er is in een passend tempo gewerkt."},null,null,{"$f":"VLOOKUP($A38,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,1,0]
[null,"* Cruciaal criterium"]
[null,"Beslissing B1-K2-W1"]
[null,"Cruciale criteria"]
[null,"Aantal cruciale criteria:",{"$f":"COUNTIF($H:$H,ja)","v":3},"Alle crucialecriteria behaald:",{"$f":"IF(COUNTIF(J42:J46,FALSE)=0,TRUE,FALSE)","v":false}]
["CriteriumId","Cruciaal criterium",null,"Behaald in kolom 1 of hoger",null,null,null,"cbCruciaalBehaaldJa","cbCruciaalBehaaldNee","cbCruciaalBehaald"]
["B1-K2-W1-1-3",{"$f":"VLOOKUP($A44,Beheersingsniveaus!$D$3:$F$154,3,FALSE)","v":"Vaststellen probleem"},null,"Ja","Nee",null,null,{"$f":"J44","v":false},{"$f":"IF(J44=FALSE,TRUE,FALSE)","v":true},{"$f":"IF(VLOOKUP($A44,$A$21:$N$39,13,FALSE)>0,TRUE,FALSE)","v":false}]
["B1-K2-W1-1-6",{"$f":"VLOOKUP($A45,Beheersingsniveaus!$D$3:$F$154,3,FALSE)","v":"Handelen conform bedrijfs-\nprocedures/SLA"},null,"Ja","Nee",null,null,{"$f":"J45","v":false},{"$f":"IF(J45=FALSE,TRUE,FALSE)","v":true},{"$f":"IF(VLOOKUP($A45,$A$21:$N$39,13,FALSE)>0,TRUE,FALSE)","v":false}]
["B1-K2-W1-1-14",{"$f":"VLOOKUP($A46,Beheersingsniveaus!$D$3:$F$154,3,FALSE)","v":"Registratie"},null,"Ja","Nee",null,null,{"$f":"J46","v":false},{"$f":"IF(J46=FALSE,TRUE,FALSE)","v":true},{"$f":"IF(VLOOKUP($A46,$A$21:$N$39,13,FALSE)>0,TRUE,FALSE)","v":false}]
[]
[]
[null,"Zijn alle cruciale criteria behaald?"]
[null,"Ja","Reik cijfer uit volgens cijfertabel",null,null,null,null,{"$f":"E42","v":false}]
[null,"Nee","Onvoldoende",null,null,null,null,{"$f":"IF(E42=FALSE,TRUE,FALSE)","v":true}]
[]
[null,"Cijfertabel"]
[null,"Punten","Cijfer","Behaald"]
[null,0,{"$f":"ROUNDUP(IF(B55<$B$8,4.5/$B$8*B55+1,4.5/($B$4-$B$8)*(B55-$B$8)+5.5),1)","v":1},{"$f":"IF($B55=$B$5,\"X\",\"\")","v":"X"}]
[null,1,1.3,""]
[null,2,1.5,""]
[null,3,1.7000000000000002,""]
[null,4,1.9000000000000001,""]
[null,5,2.1,""]
[null,6,2.3000000000000003,""]
[null,7,2.5,""]
[null,8,2.7,""]
[null,9,2.9,""]
[null,10,3.1,""]
[null,11,3.4,""]
[null,12,3.6,""]
[null,13,3.8000000000000003,""]
[null,14,4,""]
[null,15,4.1999999999999993,""]
[null,16,4.3999999999999995,""]
[null,17,4.5999999999999996,""]
[null,18,4.8,""]
[null,19,5,""]
[null,20,5.1999999999999993,""]
[null,21,5.3999999999999995,""]
[null,22,5.6999999999999993,""]
[null,23,5.8999999999999995,""]
[null,24,6.1,""]
[null,25,6.3,""]
[null,26,6.5,""]
[null,27,6.6999999999999993,""]
[null,28,6.8999999999999995,""]
[null,29,7.1,""]
[null,30,7.3,""]
[null,31,7.5,""]
[null,32,7.6999999999999993,""]
[null,33,8,""]
[null,34,8.1999999999999993,""]
[null,35,8.4,""]
[null,36,8.6,""]
[null,37,8.7999999999999989,""]
[null,38,9,""]
[null,39,9.1999999999999993,""]
[null,40,9.4,""]
[null,41,9.6,""]
[null,42,9.7999999999999989,""]
[null,43,10,""]
[]
[null,"Motivatie"]
[null,"Motiveer de beslissing."]
[null,"Onderbouw altijd het beoordelingsresultaat.\nBij de onderbouwing kan gebruik gemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]
[]
[]
[null,"Handtekening"]
[null,"Zet uw handtekening."]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]

{"sheet":"B1-K2-W2","index":7,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[[75,1,75,6],[79,2,79,3],[80,2,80,3],[9,1,9,6],[10,1,10,6],[12,1,12,6],[20,1,20,6],[33,1,33,6],[74,1,74,6]]}
["Werkproces:","B1-K2-W2",{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":"Oplossen en/of escaleren van incidenten"}]
["Eerste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,3,FALSE)","v":2}]
["Laatste opdracht:",{"$f":"VLOOKUP(B1,KerntakenEnWerkprocessen!B13:E27,4,FALSE)","v":2}]
["PuntentotaalMax",{"$f":"SUM(N:N)","v":23},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":false}]
["PuntentotaalBehaald",{"$f":"SUM(M:M)","v":0}]
["#Ant. Mog. <=1",{"$f":"COUNTIF(N:N,1)","v":2}]
["#Ant. Mog. 2-3",{"$f":"COUNTIF(N:N,2)+COUNTIF(N:N,3)","v":7}]
["Cesuur",{"$f":"0.5*B4","v":11.5}]
[]
[null,{"$f":"CONCATENATE(kerntaakCode,\": \",kerntaakNaam)","v":"B1-K2: Behandelen van incidentmeldingen"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":"B1-K2-W2: Oplossen en/of escaleren van incidenten"}]
[]
[null,"Persoonsinformatie"]
[null,"Datum"]
[null,"Kandidaat"]
[null,"Leerlingnummer"]
[null,"Klas"]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]
[]
[null,"Beoordeling opdracht 2"]
["Opdracht:",2,null,"OpdrachtId:","B1-K2-W2-2",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E22)","v":9}]
["CriteriumId","Taak","Criterium",0,1,2,3,"Cruciaal","Cb0","Cb1","Cb2","Cb3","PuntentotaalBehaald","PuntentotaalMax","CheckboxenIngevuld"]
["B1-K2-W2-2-1",{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1"},{"$f":"CONCATENATE(VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H24=ja,\"*\",\"\"))","v":"Escaleren*"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is juist geëscaleerd. "},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is juist geëscaleerd."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is juist geëscaleerd.\n"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn juist geëscaleerd."},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":"Ja"},null,null,null,null,{"$f":"IF(L24=TRUE,3,IF(K24=TRUE,2,IF(J24=TRUE,1,IF(I24=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D24:G24))-1","v":3},{"$f":"COUNTA(I24:L24)","v":0}]
["B1-K2-W2-2-2",{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T2"},{"$f":"CONCATENATE(VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H25=ja,\"*\",\"\"))","v":"Oplossen meldingen*"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende niet geraadpleegd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende niet geraadpleegd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende geraadpleegd.\n"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn juist opgelost.\n\nWaar een standaardoplossing niet voorhanden is, is de leidinggevende geraadpleegd."},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":"Ja"},null,null,null,null,0,3,0]
["B1-K2-W2-2-3",{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T2"},{"$f":"CONCATENATE(VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H26=ja,\"*\",\"\"))","v":"Testen oplossingen"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Oplossingen zijn niet of deels getest op werking.\n"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Alle oplossingen zijn getest op werking."},null,null,{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,1,0]
["B1-K2-W2-2-4",{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H27=ja,\"*\",\"\"))","v":"Terugkoppelen"},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant."},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant."},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de afgehandelde meldingen wordt juist teruggekoppeld aan de klant.\n"},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle afgehandelde meldingen worden juist teruggekoppeld aan de klant."},{"$f":"VLOOKUP($A27,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W2-2-5",{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H28=ja,\"*\",\"\"))","v":"Schrijven Engels"},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling volledig onbegrijpelijk."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling grotendeels onbegrijpelijk."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling grotendeels begrijpelijk.\n"},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Het woordgebruik, de zinsstructuur  en de spelling in de Engelse tekst maken de terugkoppeling volledig begrijpelijk."},{"$f":"VLOOKUP($A28,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W2-2-6",{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H29=ja,\"*\",\"\"))","v":"Controleren tevredenheid"},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Bij minder dan 80% van de afgehandelde meldingen is de tevredenheid gecontroleerd."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Bij minimaal 80% van de afgehandelde meldingen is de tevredenheid gecontroleerd."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Bij minimaal 90% van de afgehandelde meldingen is de tevredenheid gecontroleerd.\n"},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Bij alle afgehandelde meldingen is de tevredenheid gecontroleerd."},{"$f":"VLOOKUP($A29,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W2-2-7",{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T4"},{"$f":"CONCATENATE(VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H30=ja,\"*\",\"\"))","v":"Registreren"},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is voorzien van een juiste registratie."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is voorzien van een juiste registratie."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is voorzien van een juiste registratie.\n"},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn voorzien van een juiste registratie."},{"$f":"VLOOKUP($A30,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W2-2-8",{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T5"},{"$f":"CONCATENATE(VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H31=ja,\"*\",\"\"))","v":"Documenteren"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Minder dan 80% van de meldingen is voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Minimaal 80% van de meldingen is voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Minimaal 90% van de meldingen is voorzien van een juiste documentatie.\n"},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Alle meldingen zijn voorzien van een juiste documentatie."},{"$f":"VLOOKUP($A31,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,3,0]
["B1-K2-W2-2-9",{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T1 t/m T5"},{"$f":"CONCATENATE(VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H32=ja,\"*\",\"\"))","v":"Werktempo"},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Er is in een te laag tempo gewerkt.\n"},{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Er is in een passend tempo gewerkt."},null,null,{"$f":"VLOOKUP($A32,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,null,0,1,0]
[null,"* Cruciaal criterium"]
[null,"Beslissing B1-K2-W2"]
[null,"Cruciale criteria"]
[null,"Aantal cruciale criteria:",{"$f":"COUNTIF($H:$H,ja)","v":2},"Alle crucialecriteria behaald:",{"$f":"IF(COUNTIF(J36:J39,FALSE)=0,TRUE,FALSE)","v":false}]
["CriteriumId","Cruciaal criterium",null,"Behaald in kolom 1 of hoger",null,null,null,"cbCruciaalBehaaldJa","cbCruciaalBehaaldNee","cbCruciaalBehaald"]
["B1-K2-W2-2-1",{"$f":"VLOOKUP($A38,Beheersingsniveaus!$D$3:$F$154,3,FALSE)","v":"Escaleren"},null,"Ja","Nee",null,null,{"$f":"J38","v":false},{"$f":"IF(J38=FALSE,TRUE,FALSE)","v":true},{"$f":"IF(VLOOKUP($A38,$A$21:$N$33,13,FALSE)>0,TRUE,FALSE)","v":false}]
["B1-K2-W2-2-2",{"$f":"VLOOKUP($A39,Beheersingsniveaus!$D$3:$F$154,3,FALSE)","v":"Oplossen meldingen"},null,"Ja","Nee",null,null,{"$f":"J39","v":false},{"$f":"IF(J39=FALSE,TRUE,FALSE)","v":true},{"$f":"IF(VLOOKUP($A39,$A$21:$N$33,13,FALSE)>0,TRUE,FALSE)","v":false}]
[]
[]
[null,"Zijn alle cruciale criteria behaald?"]
[null,"Ja","Reik cijfer uit volgens cijfertabel",null,null,null,null,{"$f":"E36","v":false}]
[null,"Nee","Onvoldoende",null,null,null,null,{"$f":"IF(E36=FALSE,TRUE,FALSE)","v":true}]
[]
[null,"Cijfertabel"]
[null,"Punten","Cijfer","Behaald"]
[null,0,{"$f":"ROUNDUP(IF(B48<$B$8,4.5/$B$8*B48+1,4.5/($B$4-$B$8)*(B48-$B$8)+5.5),1)","v":1},{"$f":"IF($B48=$B$5,\"X\",\"\")","v":"X"}]
[null,1,1.4000000000000001,""]
[null,2,1.8,""]
[null,3,2.2000000000000002,""]
[null,4,2.6,""]
[null,5,3,""]
[null,6,3.4,""]
[null,7,3.8000000000000003,""]
[null,8,4.1999999999999993,""]
[null,9,4.5999999999999996,""]
[null,10,5,""]
[null,11,5.3999999999999995,""]
[null,12,5.6999999999999993,""]
[null,13,6.1,""]
[null,14,6.5,""]
[null,15,6.8999999999999995,""]
[null,16,7.3,""]
[null,17,7.6999999999999993,""]
[null,18,8.1,""]
[null,19,8.5,""]
[null,20,8.9,""]
[null,21,9.2999999999999989,""]
[null,22,9.6999999999999993,""]
[null,23,10,""]
[]
[null,"Motivatie"]
[null,"Motiveer de beslissing."]
[null,"Onderbouw altijd het beoordelingsresultaat.\nBij de onderbouwing kan gebruik gemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]
[]
[]
[null,"Handtekening"]
[null,"Zet uw handtekening."]
[null,"Beoordelaar 1"]
[null,"Beoordelaar 2"]