{"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":21,"n_cols":3,"rows_kept":21,"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:","Doe dit volgens richtlijnen van de school. Het is raadzaam om in elk geval een onvoldoende te motiveren.\nBij de motivering kan gebruikgemaakt 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]
[]
[null,"Systeem versie:","30e"]

{"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_AM-EX_IT20_B1-K2_2"},{"$f":"KerntakenEnWerkprocessen!B3","v":"2020-12-22"}]
["Examenvorm",{"$f":"KerntakenEnWerkprocessen!C6","v":"Praktijkexamen"}]
["Examennaam",{"$f":"KerntakenEnWerkprocessen!B7","v":"[Examennaam]"}]
["Examencode",{"$f":"KerntakenEnWerkprocessen!C7","v":"[Examencode]"}]
["Profiel",{"$f":"KerntakenEnWerkprocessen!B9","v":"Allround medewerker IT systems and devices, niveau 3\nExpert IT systems and devices, niveau 4"}]
["Kwalificatiedossier",{"$f":"KerntakenEnWerkprocessen!B8","v":"IT systems and devices"}]
["Cohort en crebocode",{"$f":"KerntakenEnWerkprocessen!C8","v":"2020 en verder"},{"$f":"KerntakenEnWerkprocessen!C9","v":"25605\n25606"}]
["Kerntaak",{"$f":"KerntakenEnWerkprocessen!C5","v":"Beheert de infrastructuur"}]
[]
["Werkprocessen",{"$f":"KerntakenEnWerkprocessen!F2","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\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: Beheert de infrastructuur"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":{"$error":"#N/A"}}]
[]
[null,"Persoonsinformatie"]
[null,"Datum"]
[null,"Kandidaat"]
[null,"Studentnummer"]
[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 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]
["Vaststellingsdatum","2020-12-22"]
["Code beoordelingsformulier","BF_AM-EX_IT20_B1-K2_2"]
["Kerntaak","B1-K2","Beheert de infrastructuur"]
["Examenvorm",null,"Praktijkexamen"]
["Examennaam en Examencode","[Examennaam]","[Examencode]"]
["Kwalificatiedossier en Cohort","IT systems and devices","2020 en verder"]
["Profiel en crebocode","Allround medewerker IT systems and devices, niveau 3\nExpert IT systems and devices, niveau 4","25605\n25606"]
[]
[]
["Werkprocessen","Code","Naam","EersteOpdracht","LaatsteOpdracht","TekstSamengevoegd"]
[null,"B1-K2-W1","Installeert en configureert netwerk- en infrastructuuronderdelen",{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$153))","v":1},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B13,Beheersingsniveaus!$B$4:$B$153))","v":1},{"$f":"B13&\" \"&C13&CHAR(10)","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\n"}]
[null,"B1-K2-W2","Beheert en monitort netwerk- en infrastructuuronderdelen",{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$153))","v":2},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B14,Beheersingsniveaus!$B$4:$B$153))","v":2},{"$f":"F13&B14&\" \"&C14&CHAR(10)","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B15,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"F14&B15&\" \"&C15&CHAR(10)","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B16,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B17,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B18,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B19,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B20,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B21,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B22,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B23,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"F22&B23&\" \"&C23&CHAR(10)","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n"}]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B24,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B25,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B26,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n \n \n \n"]
[null,null,null,{"$f":"MIN(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$153))","v":0},{"$f":"MAX(IF(Beheersingsniveaus!$A$4:$A$153=KerntakenEnWerkprocessen!$B27,Beheersingsniveaus!$B$4:$B$153))","v":0},"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\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":153,"n_cols":11,"rows_kept":153,"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","Installeren van infrastructuur-devices","Infrastructuur-devices zijn conform opdracht geїnstalleerd.\n\nNiet of nauwelijks\n\n","Enigszins","Grotendeels","Volledig"]
["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","Configureren van infrastructuur-devices","Infrastructuur-devices zijn conform opdracht geconfigureerd.\n\nNiet of nauwelijks","Enigszins","Grotendeels","Volledig"]
["B1-K2-W1",1,"B1-K2-W1-1",{"$f":"IF(C6<>\"\",CONCATENATE(C6,\"-\",COUNTIF($C$4:C6,C6),\"\"),\"\")","v":"B1-K2-W1-1-3"},"T2","Testen","De werking van de infrastructuur-devices is getest. Eventuele fouten zijn gelokaliseerd en op passende wijze afgehandeld.\n\nNiet of nauwelijks","Enigszins","Grotendeels","Volledig"]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C7<>\"\",CONCATENATE(C7,\"-\",COUNTIF($C$4:C7,C7),\"\"),\"\")","v":"B1-K2-W2-2-1"},"T1","Gekozen tools","De juiste tools zijn correct gebruikt.\n\nNiet of nauwelijks","Enigszins","Grotendeels","Volledig"]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C8<>\"\",CONCATENATE(C8,\"-\",COUNTIF($C$4:C8,C8),\"\"),\"\")","v":"B1-K2-W2-2-2"},"T2","Beheerwerkzaam-heden","De beheerwerkzaam-heden zijn conform opdracht uitgevoerd.\n\nNiet of nauwelijks","Enigszins","Grotendeels","Volledig"]
["B1-K2-W2",2,"B1-K2-W2-2",{"$f":"IF(C9<>\"\",CONCATENATE(C9,\"-\",COUNTIF($C$4:C9,C9),\"\"),\"\")","v":"B1-K2-W2-2-3"},"T3","Verbeteringen aanbrengen of adviseren","De onderdelen van het netwerk/de infrastructuur voldoen aan de gestelde onderhouds- en veiligheidseisen of er is advies uitgebracht over verbeteringen.\n\nNiet of nauwelijks","Enigszins","Grotendeels","Volledig"]
[null,null,"",{"$f":"IF(C10<>\"\",CONCATENATE(C10,\"-\",COUNTIF($C$4:C10,C10),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C11<>\"\",CONCATENATE(C11,\"-\",COUNTIF($C$4:C11,C11),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C12<>\"\",CONCATENATE(C12,\"-\",COUNTIF($C$4:C12,C12),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C13<>\"\",CONCATENATE(C13,\"-\",COUNTIF($C$4:C13,C13),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C14<>\"\",CONCATENATE(C14,\"-\",COUNTIF($C$4:C14,C14),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C15<>\"\",CONCATENATE(C15,\"-\",COUNTIF($C$4:C15,C15),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C16<>\"\",CONCATENATE(C16,\"-\",COUNTIF($C$4:C16,C16),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C17<>\"\",CONCATENATE(C17,\"-\",COUNTIF($C$4:C17,C17),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C18<>\"\",CONCATENATE(C18,\"-\",COUNTIF($C$4:C18,C18),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C19<>\"\",CONCATENATE(C19,\"-\",COUNTIF($C$4:C19,C19),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C20<>\"\",CONCATENATE(C20,\"-\",COUNTIF($C$4:C20,C20),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C21<>\"\",CONCATENATE(C21,\"-\",COUNTIF($C$4:C21,C21),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C22<>\"\",CONCATENATE(C22,\"-\",COUNTIF($C$4:C22,C22),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C23<>\"\",CONCATENATE(C23,\"-\",COUNTIF($C$4:C23,C23),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C24<>\"\",CONCATENATE(C24,\"-\",COUNTIF($C$4:C24,C24),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C25<>\"\",CONCATENATE(C25,\"-\",COUNTIF($C$4:C25,C25),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C26<>\"\",CONCATENATE(C26,\"-\",COUNTIF($C$4:C26,C26),\"\"),\"\")","v":""}]
[null,null,"",{"$f":"IF(C27<>\"\",CONCATENATE(C27,\"-\",COUNTIF($C$4:C27,C27),\"\"),\"\")","v":""}]
[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(A68<>\"\",CONCATENATE(A68,\"-\",B68),\"\")","v":""},{"$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(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(A104<>\"\",CONCATENATE(A104,\"-\",B104),\"\")","v":""},{"$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(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(A109<>\"\",CONCATENATE(A109,\"-\",B109),\"\")","v":""},{"$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(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":""}]

{"sheet":"Voorblad","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"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],[20,1,20,2],[21,1,21,2],[23,2,25,2],[15,0,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
["Beoordelingsformulier praktijkexamen"]
[]
["Algemene informatie"]
[]
["Code beoordelingsformulier en vaststellingsdatum",{"$f":"KerntakenEnWerkprocessen!B4","v":"BF_AM-EX_IT20_B1-K2_2"},"2021-07-13"]
["Examenvorm",{"$f":"KerntakenEnWerkprocessen!C6","v":"Praktijkexamen"}]
["Examennaam",{"$f":"KerntakenEnWerkprocessen!B7","v":"[Examennaam]"}]
["Examencode",{"$f":"KerntakenEnWerkprocessen!C7","v":"[Examencode]"}]
["Profiel",{"$f":"KerntakenEnWerkprocessen!B9","v":"Allround medewerker IT systems and devices, niveau 3\nExpert IT systems and devices, niveau 4"}]
["Kwalificatiedossier",{"$f":"KerntakenEnWerkprocessen!B8","v":"IT systems and devices"}]
["Cohort en crebocode",{"$f":"KerntakenEnWerkprocessen!C8","v":"2020 en verder"},{"$f":"KerntakenEnWerkprocessen!C9","v":"25605\n25606"}]
["Kerntaak",{"$f":"KerntakenEnWerkprocessen!C5","v":"Beheert de infrastructuur"}]
[]
["Werkprocessen",{"$f":"KerntakenEnWerkprocessen!F2","v":"B1-K2-W1 Installeert en configureert netwerk- en infrastructuuronderdelen\nB1-K2-W2 Beheert en monitort netwerk- en infrastructuuronderdelen\n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]
[]
["Persoonsinformatie"]
["Datum",null,null," [Vul alleen de gele cellen in]"]
["Kandidaat"]
["Leerlingnummer"]
["Klas"]
["Beoordelaar 1"]
["Beoordelaar 2"]
[]
["Werkprocessen","Resultaat","[Laat de rode cellen leeg. Excel vult het resultaat automatisch in na beoordeling van de werkprocessen.]"]
["B1-K2-W1",{"$f":"'B1-K2-W1'!B41","v":""}]
["B1-K2-W2",{"$f":"'B1-K2-W2'!B41","v":""}]
[]
["Handtekening beoordelaar 1","Handtekening beoordelaar 2"]

{"sheet":"B1-K2-W1","index":6,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[45,1,45,6],[9,1,9,6],[10,1,10,6],[12,1,12,6],[20,1,20,6],[27,1,27,6],[44,1,44,6]]}
["Werkproces:","B1-K2-W1",{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":"Installeert en configureert netwerk- en infrastructuuronderdelen"}]
["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":9},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":true}]
["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":3}]
["Cesuur",{"$f":"0.5*B4","v":4.5}]
[]
[null,{"$f":"CONCATENATE(kerntaakCode,\": \",kerntaakNaam)","v":"B1-K2: Beheert de infrastructuur"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":"B1-K2-W1: Installeert en configureert netwerk- en infrastructuuronderdelen"}]
[]
[null,"Persoonsinformatie"]
[null,"Datum",{"$f":"IF(Voorblad!B17=\"\",\"\",Voorblad!B17)","v":""}]
[null,"Kandidaat",{"$f":"IF(Voorblad!B18=\"\",\"\",Voorblad!B18)","v":""}]
[null,"Studentnummer",{"$f":"IF(Voorblad!B19=\"\",\"\",Voorblad!B19)","v":""}]
[null,"Klas",{"$f":"IF(Voorblad!B20=\"\",\"\",Voorblad!B20)","v":""}]
[null,"Beoordelaar 1",{"$f":"IF(Voorblad!B21=\"\",\"\",Voorblad!B21)","v":""}]
[null,"Beoordelaar 2",{"$f":"IF(Voorblad!B22=\"\",\"\",Voorblad!B22)","v":""}]
[]
[null,"Beoordeling opdracht 1"]
["Opdracht:",1,null,"OpdrachtId:","B1-K2-W1-1",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E22)","v":3}]
["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":"Installeren van infrastructuur-devices"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Infrastructuur-devices zijn conform opdracht geїnstalleerd.\n\nNiet of nauwelijks\n\n"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,false,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":1}]
["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":"Configureren van infrastructuur-devices"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"Infrastructuur-devices zijn conform opdracht geconfigureerd.\n\nNiet of nauwelijks"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,false,null,{"$f":"IF(L25=TRUE,3,IF(K25=TRUE,2,IF(J25=TRUE,1,IF(I25=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D25:G25))-1","v":3},{"$f":"COUNTA(I25:L25)","v":1}]
["B1-K2-W1-1-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"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De werking van de infrastructuur-devices is getest. Eventuele fouten zijn gelokaliseerd en op passende wijze afgehandeld.\n\nNiet of nauwelijks"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},false,null,null,false,{"$f":"IF(L26=TRUE,3,IF(K26=TRUE,2,IF(J26=TRUE,1,IF(I26=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D26:G26))-1","v":3},{"$f":"COUNTA(I26:L26)","v":2}]
[]
[null,"Beslissing B1-K2-W1"]
[null,"Cijfertabel"]
[null,"Punten","Cijfer","Behaald"]
[null,0,{"$f":"ROUNDUP(IF(B31<$B$8,4.5/$B$8*B31+1,4.5/($B$4-$B$8)*(B31-$B$8)+5.5),1)","v":1},{"$f":"IF($B31=$B$5,\"X\",\"\")","v":"X"}]
[null,1,2,""]
[null,2,3,""]
[null,3,4,""]
[null,4,5,""]
[null,5,6,""]
[null,6,7,""]
[null,7,8,""]
[null,8,9,""]
[null,9,10,""]
[null,{"$f":"IF(D31=\"X\",\"\",IF(D32=\"X\",C32,IF(D33=\"X\",C33,IF(D34=\"X\",C34,IF(D35=\"X\",C35,IF(D36=\"X\",C36,IF(D37=\"X\",C37,IF(D38=\"X\",C38,IF(D39=\"X\",C39,IF(D40=\"X\",C40,\"\"))))))))))","v":""}]
[]
[null,"Motivatie"]
[null,"Motiveer de beslissing."]
[null,"Doe dit volgens richtlijnen van de school. Het is raadzaam om in elk geval een onvoldoende te motiveren.\nBij de motivering kan gebruikgemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]

{"sheet":"B1-K2-W2","index":7,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[45,1,45,6],[9,1,9,6],[10,1,10,6],[12,1,12,6],[20,1,20,6],[27,1,27,6],[44,1,44,6]]}
["Werkproces:","B1-K2-W2",{"$f":"VLOOKUP(B1,werkprocessen,2,FALSE)","v":"Beheert en monitort netwerk- en infrastructuuronderdelen"}]
["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":9},"Invullen gestart:",{"$f":"IF(SUM(O:O)>0,TRUE,FALSE)","v":true}]
["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":3}]
["Cesuur",{"$f":"0.5*B4","v":4.5}]
[]
[null,{"$f":"CONCATENATE(kerntaakCode,\": \",kerntaakNaam)","v":"B1-K2: Beheert de infrastructuur"}]
[null,{"$f":"CONCATENATE(VLOOKUP(B1,werkprocessen,1,FALSE),\": \",C1)","v":"B1-K2-W2: Beheert en monitort netwerk- en infrastructuuronderdelen"}]
[]
[null,"Persoonsinformatie"]
[null,"Datum",{"$f":"IF(Voorblad!B17=\"\",\"\",Voorblad!B17)","v":""}]
[null,"Kandidaat",{"$f":"IF(Voorblad!B18=\"\",\"\",Voorblad!B18)","v":""}]
[null,"Studentnummer",{"$f":"IF(Voorblad!B19=\"\",\"\",Voorblad!B19)","v":""}]
[null,"Klas",{"$f":"IF(Voorblad!B20=\"\",\"\",Voorblad!B20)","v":""}]
[null,"Beoordelaar 1",{"$f":"IF(Voorblad!B21=\"\",\"\",Voorblad!B21)","v":""}]
[null,"Beoordelaar 2",{"$f":"IF(Voorblad!B22=\"\",\"\",Voorblad!B22)","v":""}]
[]
[null,"Beoordeling opdracht 2"]
["Opdracht:",2,null,"OpdrachtId:","B1-K2-W2-2",null,"Aantal criteria:",{"$f":"COUNTIF(Beheersingsniveaus!$C$4:$C$154,$E22)","v":3}]
["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":"Gekozen tools"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De juiste tools zijn correct gebruikt.\n\nNiet of nauwelijks"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A24,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,false,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":1}]
["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":"Beheerwerkzaam-heden"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De beheerwerkzaam-heden zijn conform opdracht uitgevoerd.\n\nNiet of nauwelijks"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A25,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,null,false,{"$f":"IF(L25=TRUE,3,IF(K25=TRUE,2,IF(J25=TRUE,1,IF(I25=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D25:G25))-1","v":3},{"$f":"COUNTA(I25:L25)","v":1}]
["B1-K2-W2-2-3",{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,2,FALSE)","v":"T3"},{"$f":"CONCATENATE(VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,3,FALSE),IF($H26=ja,\"*\",\"\"))","v":"Verbeteringen aanbrengen of adviseren"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,4,FALSE)","v":"De onderdelen van het netwerk/de infrastructuur voldoen aan de gestelde onderhouds- en veiligheidseisen of er is advies uitgebracht over verbeteringen.\n\nNiet of nauwelijks"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,5,FALSE)","v":"Enigszins"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,6,FALSE)","v":"Grotendeels"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,7,FALSE)","v":"Volledig"},{"$f":"VLOOKUP($A26,Beheersingsniveaus!$D$4:$K$154,8,FALSE)","v":0},null,null,false,null,{"$f":"IF(L26=TRUE,3,IF(K26=TRUE,2,IF(J26=TRUE,1,IF(I26=TRUE,0,0))))","v":0},{"$f":"(4-COUNTBLANK(D26:G26))-1","v":3},{"$f":"COUNTA(I26:L26)","v":1}]
[]
[null,"Beslissing B1-K2-W2"]
[null,"Cijfertabel"]
[null,"Punten","Cijfer","Behaald"]
[null,0,{"$f":"ROUNDUP(IF(B31<$B$8,4.5/$B$8*B31+1,4.5/($B$4-$B$8)*(B31-$B$8)+5.5),1)","v":1},{"$f":"IF($B31=$B$5,\"X\",\"\")","v":"X"}]
[null,1,2,""]
[null,2,3,""]
[null,3,4,""]
[null,4,5,""]
[null,5,6,""]
[null,6,7,""]
[null,7,8,""]
[null,8,9,""]
[null,9,10,""]
[null,{"$f":"IF(D31=\"X\",\"\",IF(D32=\"X\",C32,IF(D33=\"X\",C33,IF(D34=\"X\",C34,IF(D35=\"X\",C35,IF(D36=\"X\",C36,IF(D37=\"X\",C37,IF(D38=\"X\",C38,IF(D39=\"X\",C39,IF(D40=\"X\",C40,\"\"))))))))))","v":""}]
[]
[null,"Motivatie"]
[null,"Motiveer de beslissing."]
[null,"Doe dit volgens richtlijnen van de school. Het is raadzaam om in elk geval een onvoldoende te motiveren.\nBij de motivering kan gebruikgemaakt worden van de beschrijvingen in de beoordelingstabel.\n"]