{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Uitleg-toelichting","Agendalijst","Beoordeling","Overzicht resultaten"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Uitleg-toelichting","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null," "]

{"sheet":"Agendalijst","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Leerlingenlijst"]
[]
[]
[null,"Naam","eindcijfer"]
[1,"leerling 1",{"$f":"IF(B5<>\"\",'Overzicht resultaten'!C$15,\"\")","v":10}]
[{"$f":"A5+1","v":2},"leerling 2",{"$f":"IF(B6<>\"\",'Overzicht resultaten'!D$15,\"\")","v":10}]
[{"$f":"A6+1","v":3},"leerling 3",{"$f":"IF(B7<>\"\",'Overzicht resultaten'!E$15,\"\")","v":10}]
[4,"leerling 4",{"$f":"IF(B8<>\"\",'Overzicht resultaten'!F$15,\"\")","v":10}]
[5,"leerling 5",{"$f":"IF(B9<>\"\",'Overzicht resultaten'!G$15,\"\")","v":10}]
[6,"leerling 6",{"$f":"IF(B10<>\"\",'Overzicht resultaten'!H$15,\"\")","v":10}]
[7,"leerling 7",{"$f":"IF(B11<>\"\",'Overzicht resultaten'!I$15,\"\")","v":10}]
[8,"leerling 8",{"$f":"IF(B12<>\"\",'Overzicht resultaten'!J$15,\"\")","v":10}]
[9,"leerling 9",{"$f":"IF(B13<>\"\",'Overzicht resultaten'!K$15,\"\")","v":10}]
[10,"leerling 10",{"$f":"IF(B14<>\"\",'Overzicht resultaten'!L$15,\"\")","v":10}]
[11,"leerling 11",{"$f":"IF(B15<>\"\",'Overzicht resultaten'!M$15,\"\")","v":10}]
[12,null,{"$f":"IF(B16<>\"\",'Overzicht resultaten'!N$15,\"\")","v":""}]
[13,null,{"$f":"IF(B17<>\"\",'Overzicht resultaten'!O$15,\"\")","v":""}]
[14,null,{"$f":"IF(B18<>\"\",'Overzicht resultaten'!P$15,\"\")","v":""}]
[15,null,{"$f":"IF(B19<>\"\",'Overzicht resultaten'!Q$15,\"\")","v":""}]
[16,null,{"$f":"IF(B20<>\"\",'Overzicht resultaten'!R$15,\"\")","v":""}]
[17,null,{"$f":"IF(B21<>\"\",'Overzicht resultaten'!S$15,\"\")","v":""}]
[18,null,{"$f":"IF(B22<>\"\",'Overzicht resultaten'!T$15,\"\")","v":""}]
[19,null,{"$f":"IF(B23<>\"\",'Overzicht resultaten'!U$15,\"\")","v":""}]
[20,null,{"$f":"IF(B24<>\"\",'Overzicht resultaten'!V$15,\"\")","v":""}]
[21,null,{"$f":"IF(B25<>\"\",'Overzicht resultaten'!W$15,\"\")","v":""}]
[22,null,{"$f":"IF(B26<>\"\",'Overzicht resultaten'!X$15,\"\")","v":""}]
[23,null,{"$f":"IF(B27<>\"\",'Overzicht resultaten'!Y$15,\"\")","v":""}]
[24,null,{"$f":"IF(B28<>\"\",'Overzicht resultaten'!Z$15,\"\")","v":""}]
[25,null,{"$f":"IF(B29<>\"\",'Overzicht resultaten'!AA$15,\"\")","v":""}]
[{"$f":"A29+1","v":26},null,{"$f":"IF(B30<>\"\",'Overzicht resultaten'!AB$15,\"\")","v":""},null,{"$f":"IF(B30<>\"\",C30,\"\")","v":""}]
[27,null,{"$f":"IF(B31<>\"\",'Overzicht resultaten'!AC$15,\"\")","v":""},null,""]
[28,null,{"$f":"IF(B32<>\"\",'Overzicht resultaten'!AD$15,\"\")","v":""}]
[29,null,{"$f":"IF(B33<>\"\",'Overzicht resultaten'!AE$15,\"\")","v":""}]
[{"$f":"A33+1","v":30},null,{"$f":"IF(B34<>\"\",'Overzicht resultaten'!AF$15,\"\")","v":""}]
[31,null,{"$f":"IF(B35<>\"\",'Overzicht resultaten'!AG$15,\"\")","v":""}]
[32,null,{"$f":"IF(B36<>\"\",'Overzicht resultaten'!AH$15,\"\")","v":""}]

{"sheet":"Beoordeling","index":2,"n_rows":72,"n_cols":41,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"leerling 1"},{"$f":"'Overzicht resultaten'!D6","v":"leerling 2"},{"$f":"'Overzicht resultaten'!E6","v":"leerling 3"},{"$f":"'Overzicht resultaten'!F6","v":"leerling 4"},{"$f":"'Overzicht resultaten'!G6","v":"leerling 5"},{"$f":"'Overzicht resultaten'!H6","v":"leerling 6"},{"$f":"'Overzicht resultaten'!I6","v":"leerling 7"},{"$f":"'Overzicht resultaten'!J6","v":"leerling 8"},{"$f":"'Overzicht resultaten'!K6","v":"leerling 9"},{"$f":"'Overzicht resultaten'!L6","v":"leerling 10"},{"$f":"'Overzicht resultaten'!M6","v":"leerling 11"},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,null,null,1,{"$f":"F2+1","v":2},{"$f":"G2+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,null,null,"x","x"]
[null,null,"A. De inleiding en vraagstelling",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"de leerling…..","gewicht  (0-4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[1,"*","heeft een uitstekende CKV-onderzoeksvraag of hypothese geformuleerd die aan alle eisen voldoet.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$5>0,\"x\",0)","v":"x"},{"$f":"IF(B5=\"*\",\"x\",0)","v":"x"}]
[2,0,"heeft een beredeneerde keuze gemaakt voor een beschrijvende, vergelijkende, verklarende of evaluatieve hoofdvraag. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$6>0,\"x\",0)","v":0},0]
[3,0,"heeft relevante deelvragen geformuleerd die een antwoord op de hoofdvraag mogelijk maken.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7>0,\"x\",0)","v":0},0]
[4,0,"heeft een onderzoeksvraag geformuleerd waarin een beroep gedaan wordt op de voor dit onderzoek vereiste creërende en analytische vaardigheden. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$5:$D$9)>0,$E$10>0),VALUE(SUMPRODUCT($D$5:$D$9*F5:F9)*100/($D$72*SUM($D$5:$D$9))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"B. Zoekstrategie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"de leerling…..","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[6,"*","heeft een uitstekende selectie van bronnen in verschillende media gemaakt.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D13>0,\"x\",0)","v":"x"},"x"]
[7,0,"heeft bepaald welke informatie hij nodig had. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,0,"heeft gebruik gemaakt van zijn culturele omgeving.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,0,"heeft gekozen voor voldoende variatie in bronnen.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,0,"heeft oog voor de beschikbaarheid van bronnen.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[11,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[12,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[" ",null,null,null,1,{"$f":"IF(AND(SUM($D$13:$D$19)>0,$E$20>0),VALUE(SUMPRODUCT($D$13:$D$19*F13:F19)*100/($D$72*SUM($D$13:$D$19))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"C. Verwerven van informatie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"de leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[" ","*","heeft op aqequate wijze relevante informatie verzameld.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23>0,\"x\",0)","v":"x"},"x"]
[13,0,"ging bij het verwerven van informatie planmatig te werk.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[14,0,"heeft een adequate selectie gemaakt uit de beschikbare informatie.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[15,0,"heeft leemtes in de verzamelde informatie vastgesteld en/of, waar nodig, de zoekstrategie bijgesteld.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[16,0,"heeft de gebruikte informatie beoordeeld op betrouwbaarheid.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[17,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[18,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$23:$D$29)>0,$E$30>0),VALUE(SUMPRODUCT($D$23:$D$29*F23:F29)*100/($D$72*SUM($D$23:$D$29))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"D. Verwerken van de informatie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"De leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[19,"*","heeft de gevonden informatie op adequate wijze verwerkt.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33>0,\"x\",0)","v":"x"},"x"]
[20,0,"heeft de informatie op adequate wijze wijze geordend.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[21,0,"heeft relevante illustraties gebruikt.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[22,0,"heeft functioneel gebruik gemaakt van verschillende media.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[23,0,"heeft in dit onderzoek gebruik gemaakt van praktische activiteiten en beschouwend onderzoek.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[24,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$33:$D$38)>0,$E$39>0),VALUE(SUMPRODUCT($D$33:$D$38*F33:F38)*100/($D$72*SUM($D$33:$D$38))),0)","v":0},{"$f":"IF(AND(SUM($D$33:$D$38)>0,$E$39>0),VALUE(SUMPRODUCT($D$33:$D$38*G33:G38)*100/(4*SUM($D$33:$D$38))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"E. Presentatie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"De leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[25,"*","heeft een afdoende antwoord gegeven op hoofd- en deelvragen of de hypothese afdoende onderbouwd of weerlegd.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D42>0,\"x\",0)","v":"x"},"x"]
[26,0,"heeft zijn conclusies met argumenten onderbouwd.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[27,0,"heeft plagiaat vermeden.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[27,0,"heeft adequaat gebruik gemaakt van voet- of eindnoten.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[28,0,"heeft de literatuurlijst/bibliografie consequent vormgegeven (bijvoorbeeld via APA6). ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B46=\"*\",\"x\",0)","v":0}]
[29,0,"heeft gezorgd voor een presentatie die past bij het onderzoek.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D47>0,\"x\",0)","v":0},{"$f":"IF(B47=\"*\",\"x\",0)","v":0}]
[30,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$42:$D$48)>0,$E$49>0),VALUE(SUMPRODUCT($D$42:$D$48*F42:F48)*100/($D$72*SUM($D$42:$D$48))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"E. Evaluatie/discussie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"De leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[31,"*","heeft het onderzoeksproces geëvalueerd ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D52>0,\"x\",0)","v":"x"},"x"]
[32,0,"legt verbanden tussen opgedane ervaringen en inzichten met betrekking tot kunstzinnige processen.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[33,0,"heeft het resultaat van het onderzoek geëvalueerd",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[34,0,"heeft duidelijk gemaakt in hoeverre het onderzoek een antwoord op de onderzoeksvraag mogelijk heeft gemaakt.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[35,0,"heeft suggesties gedaan voor vervolgonderzoek.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[36,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[37,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$52:$D$58)>0,$E$59>0),VALUE(SUMPRODUCT($D$52:$D$58*F52:F58)*100/($D$72*SUM($D$52:$D$58))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"G. Taalgebruik: (indien schriftelijke presentatie)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"De leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D61>0,\"x\",0)","v":"x"},"x"]
[38,"*","heeft een verslag gemaakt waar taalkundig weinig op aan te merken is.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[39,0,"heeft blijk gegeven van oorspronkelijkheid (eigen woorden, getuigend van eigengemaakte kennis)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[40,0,"een verslag geschreven met een juiste zinsopbouw. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[41,0,"een verslag geschreven met een heldere en juiste interpunctie. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[42,0,"een verslag geschreven waarin opeenvolgende zinnen in een alinea inhoudelijk met elkaar in verband staan.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[43,0,"een verslag geschreven waarin de spelling in orde is.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[44,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"A68+1","v":45},0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$52:$D$58)>0,$E$59>0),VALUE(SUMPRODUCT($D$62:$D$69*F62:F69)*100/($D$72*SUM($D$52:$D$58))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[]
[null,null,"Lengte van de beoordelingsschaal, 4 (0-4), 5 (0-5) of 6 (0-6)",4]

{"sheet":"Overzicht resultaten","index":3,"n_rows":15,"n_cols":36,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Overzicht resultaten: niets invullen!"]
[]
[]
[null,null,1,{"$f":"C5+1","v":2},{"$f":"D5+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,{"$f":"AF5+1","v":31},32,null,"gemiddelde"]
["weging","categorie",{"$f":"IF(Agendalijst!B5=\"\",\"\",Agendalijst!B5)","v":"leerling 1"},{"$f":"IF(Agendalijst!B6=\"\",\"\",Agendalijst!B6)","v":"leerling 2"},{"$f":"IF(Agendalijst!B7=\"\",\"\",Agendalijst!B7)","v":"leerling 3"},{"$f":"IF(Agendalijst!B8=\"\",\"\",Agendalijst!B8)","v":"leerling 4"},{"$f":"IF(Agendalijst!B9=\"\",\"\",Agendalijst!B9)","v":"leerling 5"},{"$f":"IF(Agendalijst!B10=\"\",\"\",Agendalijst!B10)","v":"leerling 6"},{"$f":"IF(Agendalijst!B11=\"\",\"\",Agendalijst!B11)","v":"leerling 7"},{"$f":"IF(Agendalijst!B12=\"\",\"\",Agendalijst!B12)","v":"leerling 8"},{"$f":"IF(Agendalijst!B13=\"\",\"\",Agendalijst!B13)","v":"leerling 9"},{"$f":"IF(Agendalijst!B14=\"\",\"\",Agendalijst!B14)","v":"leerling 10"},{"$f":"IF(Agendalijst!B15=\"\",\"\",Agendalijst!B15)","v":"leerling 11"},{"$f":"IF(Agendalijst!B16=\"\",\"\",Agendalijst!B16)","v":""},{"$f":"IF(Agendalijst!B17=\"\",\"\",Agendalijst!B17)","v":""},{"$f":"IF(Agendalijst!B18=\"\",\"\",Agendalijst!B18)","v":""},{"$f":"IF(Agendalijst!B19=\"\",\"\",Agendalijst!B19)","v":""},{"$f":"IF(Agendalijst!B20=\"\",\"\",Agendalijst!B20)","v":""},{"$f":"IF(Agendalijst!B21=\"\",\"\",Agendalijst!B21)","v":""},{"$f":"IF(Agendalijst!B22=\"\",\"\",Agendalijst!B22)","v":""},{"$f":"IF(Agendalijst!B23=\"\",\"\",Agendalijst!B23)","v":""},{"$f":"IF(Agendalijst!B24=\"\",\"\",Agendalijst!B24)","v":""},{"$f":"IF(Agendalijst!B25=\"\",\"\",Agendalijst!B25)","v":""},{"$f":"IF(Agendalijst!B26=\"\",\"\",Agendalijst!B26)","v":""},{"$f":"IF(Agendalijst!B27=\"\",\"\",Agendalijst!B27)","v":""},{"$f":"IF(Agendalijst!B28=\"\",\"\",Agendalijst!B28)","v":""},{"$f":"IF(Agendalijst!B29=\"\",\"\",Agendalijst!B29)","v":""},{"$f":"IF(Agendalijst!B30=\"\",\"\",Agendalijst!B30)","v":""},{"$f":"IF(Agendalijst!B31=\"\",\"\",Agendalijst!B31)","v":""},{"$f":"IF(Agendalijst!B32=\"\",\"\",Agendalijst!B32)","v":""},{"$f":"IF(Agendalijst!B33=\"\",\"\",Agendalijst!B33)","v":""},{"$f":"IF(Agendalijst!B34=\"\",\"\",Agendalijst!B34)","v":""},{"$f":"IF(Agendalijst!B35=\"\",\"\",Agendalijst!B35)","v":""},{"$f":"IF(Agendalijst!B36=\"\",\"\",Agendalijst!B36)","v":""},null,"klas"]
[{"$f":"Beoordeling!E10","v":1},"A",{"$f":"IF(AND($A7>0,C6<>\"\"),Beoordeling!F10,\"\")","v":0},{"$f":"IF(AND($A7>0,D6<>\"\"),Beoordeling!G10,\"\")","v":0},{"$f":"IF(AND($A7>0,E6<>\"\"),Beoordeling!H10,\"\")","v":0},{"$f":"IF(AND($A7>0,F6<>\"\"),Beoordeling!I10,\"\")","v":0},{"$f":"IF(AND($A7>0,G6<>\"\"),Beoordeling!J10,\"\")","v":0},{"$f":"IF(AND($A7>0,H6<>\"\"),Beoordeling!K10,\"\")","v":0},{"$f":"IF(AND($A7>0,I6<>\"\"),Beoordeling!L10,\"\")","v":0},{"$f":"IF(AND($A7>0,J6<>\"\"),Beoordeling!M10,\"\")","v":0},{"$f":"IF(AND($A7>0,K6<>\"\"),Beoordeling!N10,\"\")","v":0},{"$f":"IF(AND($A7>0,L6<>\"\"),Beoordeling!O10,\"\")","v":0},{"$f":"IF(AND($A7>0,M6<>\"\"),Beoordeling!P10,\"\")","v":0},{"$f":"IF(AND($A7>0,N6<>\"\"),Beoordeling!Q10,\"\")","v":""},{"$f":"IF(AND($A7>0,O6<>\"\"),Beoordeling!R10,\"\")","v":""},{"$f":"IF(AND($A7>0,P6<>\"\"),Beoordeling!S10,\"\")","v":""},{"$f":"IF(AND($A7>0,Q6<>\"\"),Beoordeling!T10,\"\")","v":""},{"$f":"IF(AND($A7>0,R6<>\"\"),Beoordeling!U10,\"\")","v":""},{"$f":"IF(AND($A7>0,S6<>\"\"),Beoordeling!V10,\"\")","v":""},{"$f":"IF(AND($A7>0,T6<>\"\"),Beoordeling!W10,\"\")","v":""},{"$f":"IF(AND($A7>0,U6<>\"\"),Beoordeling!X10,\"\")","v":""},{"$f":"IF(AND($A7>0,V6<>\"\"),Beoordeling!Y10,\"\")","v":""},{"$f":"IF(AND($A7>0,W6<>\"\"),Beoordeling!Z10,\"\")","v":""},{"$f":"IF(AND($A7>0,X6<>\"\"),Beoordeling!AA10,\"\")","v":""},{"$f":"IF(AND($A7>0,Y6<>\"\"),Beoordeling!AB10,\"\")","v":""},{"$f":"IF(AND($A7>0,Z6<>\"\"),Beoordeling!AC10,\"\")","v":""},{"$f":"IF(AND($A7>0,AA6<>\"\"),Beoordeling!AD10,\"\")","v":""},{"$f":"IF(AND($A7>0,AB6<>\"\"),Beoordeling!AE10,\"\")","v":""},{"$f":"IF(AND($A7>0,AC6<>\"\"),Beoordeling!AF10,\"\")","v":""},{"$f":"IF(AND($A7>0,AD6<>\"\"),Beoordeling!AG10,\"\")","v":""},{"$f":"IF(AND($A7>0,AE6<>\"\"),Beoordeling!AH10,\"\")","v":""},{"$f":"IF(AND($A7>0,AF6<>\"\"),Beoordeling!AI10,\"\")","v":""},{"$f":"IF(AND($A7>0,AG6<>\"\"),Beoordeling!AJ10,\"\")","v":""},{"$f":"IF(AND($A7>0,AH6<>\"\"),Beoordeling!AK10,\"\")","v":""},null,{"$f":"IF(A7>0,AVERAGE(C7:AH7),\"-\")","v":0}]
[{"$f":"Beoordeling!E20","v":1},"B",{"$f":"IF(AND($A$8>0,C6<>\"\"),Beoordeling!F20,\"\")","v":0},{"$f":"IF(AND($A$8>0,D6<>\"\"),Beoordeling!G20,\"\")","v":0},{"$f":"IF(AND($A$8>0,E6<>\"\"),Beoordeling!H20,\"\")","v":0},{"$f":"IF(AND($A$8>0,F6<>\"\"),Beoordeling!I20,\"\")","v":0},{"$f":"IF(AND($A$8>0,G6<>\"\"),Beoordeling!J20,\"\")","v":0},{"$f":"IF(AND($A$8>0,H6<>\"\"),Beoordeling!K20,\"\")","v":0},{"$f":"IF(AND($A$8>0,I6<>\"\"),Beoordeling!L20,\"\")","v":0},{"$f":"IF(AND($A$8>0,J6<>\"\"),Beoordeling!M20,\"\")","v":0},{"$f":"IF(AND($A$8>0,K6<>\"\"),Beoordeling!N20,\"\")","v":0},{"$f":"IF(AND($A$8>0,L6<>\"\"),Beoordeling!O20,\"\")","v":0},{"$f":"IF(AND($A$8>0,M6<>\"\"),Beoordeling!P20,\"\")","v":0},{"$f":"IF(AND($A$8>0,N6<>\"\"),Beoordeling!Q20,\"\")","v":""},{"$f":"IF(AND($A$8>0,O6<>\"\"),Beoordeling!R20,\"\")","v":""},{"$f":"IF(AND($A$8>0,P6<>\"\"),Beoordeling!S20,\"\")","v":""},{"$f":"IF(AND($A$8>0,Q6<>\"\"),Beoordeling!T20,\"\")","v":""},{"$f":"IF(AND($A$8>0,R6<>\"\"),Beoordeling!U20,\"\")","v":""},{"$f":"IF(AND($A$8>0,S6<>\"\"),Beoordeling!V20,\"\")","v":""},{"$f":"IF(AND($A$8>0,T6<>\"\"),Beoordeling!W20,\"\")","v":""},{"$f":"IF(AND($A$8>0,U6<>\"\"),Beoordeling!X20,\"\")","v":""},{"$f":"IF(AND($A$8>0,V6<>\"\"),Beoordeling!Y20,\"\")","v":""},{"$f":"IF(AND($A$8>0,W6<>\"\"),Beoordeling!Z20,\"\")","v":""},{"$f":"IF(AND($A$8>0,X6<>\"\"),Beoordeling!AA20,\"\")","v":""},{"$f":"IF(AND($A$8>0,Y6<>\"\"),Beoordeling!AB20,\"\")","v":""},{"$f":"IF(AND($A$8>0,Z6<>\"\"),Beoordeling!AC20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AA6<>\"\"),Beoordeling!AD20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AB6<>\"\"),Beoordeling!AE20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AC6<>\"\"),Beoordeling!AF20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AD6<>\"\"),Beoordeling!AG20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AE6<>\"\"),Beoordeling!AH20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AF6<>\"\"),Beoordeling!AI20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AG6<>\"\"),Beoordeling!AJ20,\"\")","v":""},{"$f":"IF(AND($A$8>0,AH6<>\"\"),Beoordeling!AK20,\"\")","v":""},null,{"$f":"IF(A8>0,AVERAGE(C8:AH8),\"-\")","v":0}]
[{"$f":"Beoordeling!E30","v":1},"C",{"$f":"IF(AND($A$9>0,C6<>\"\"),Beoordeling!F30,\"\")","v":0},{"$f":"IF(AND($A$9>0,D6<>\"\"),Beoordeling!G30,\"\")","v":0},{"$f":"IF(AND($A$9>0,E6<>\"\"),Beoordeling!H30,\"\")","v":0},{"$f":"IF(AND($A$9>0,F6<>\"\"),Beoordeling!I30,\"\")","v":0},{"$f":"IF(AND($A$9>0,G6<>\"\"),Beoordeling!J30,\"\")","v":0},{"$f":"IF(AND($A$9>0,H6<>\"\"),Beoordeling!K30,\"\")","v":0},{"$f":"IF(AND($A$9>0,I6<>\"\"),Beoordeling!L30,\"\")","v":0},{"$f":"IF(AND($A$9>0,J6<>\"\"),Beoordeling!M30,\"\")","v":0},{"$f":"IF(AND($A$9>0,K6<>\"\"),Beoordeling!N30,\"\")","v":0},{"$f":"IF(AND($A$9>0,L6<>\"\"),Beoordeling!O30,\"\")","v":0},{"$f":"IF(AND($A$9>0,M6<>\"\"),Beoordeling!P30,\"\")","v":0},{"$f":"IF(AND($A$9>0,N6<>\"\"),Beoordeling!Q30,\"\")","v":""},{"$f":"IF(AND($A$9>0,O6<>\"\"),Beoordeling!R30,\"\")","v":""},{"$f":"IF(AND($A$9>0,P6<>\"\"),Beoordeling!S30,\"\")","v":""},{"$f":"IF(AND($A$9>0,Q6<>\"\"),Beoordeling!T30,\"\")","v":""},{"$f":"IF(AND($A$9>0,R6<>\"\"),Beoordeling!U30,\"\")","v":""},{"$f":"IF(AND($A$9>0,S6<>\"\"),Beoordeling!V30,\"\")","v":""},{"$f":"IF(AND($A$9>0,T6<>\"\"),Beoordeling!W30,\"\")","v":""},{"$f":"IF(AND($A$9>0,U6<>\"\"),Beoordeling!X30,\"\")","v":""},{"$f":"IF(AND($A$9>0,V6<>\"\"),Beoordeling!Y30,\"\")","v":""},{"$f":"IF(AND($A$9>0,W6<>\"\"),Beoordeling!Z30,\"\")","v":""},{"$f":"IF(AND($A$9>0,X6<>\"\"),Beoordeling!AA30,\"\")","v":""},{"$f":"IF(AND($A$9>0,Y6<>\"\"),Beoordeling!AB30,\"\")","v":""},{"$f":"IF(AND($A$9>0,Z6<>\"\"),Beoordeling!AC30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AA6<>\"\"),Beoordeling!AD30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AB6<>\"\"),Beoordeling!AE30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AC6<>\"\"),Beoordeling!AF30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AD6<>\"\"),Beoordeling!AG30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AE6<>\"\"),Beoordeling!AH30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AF6<>\"\"),Beoordeling!AI30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AG6<>\"\"),Beoordeling!AJ30,\"\")","v":""},{"$f":"IF(AND($A$9>0,AH6<>\"\"),Beoordeling!AK30,\"\")","v":""},null,0]
[{"$f":"Beoordeling!E39","v":1},"D",{"$f":"IF(AND($A$10>0,C6<>\"\"),Beoordeling!F39,\"\")","v":0},{"$f":"IF(AND($A$10>0,D6<>\"\"),Beoordeling!G39,\"\")","v":0},{"$f":"IF(AND($A$10>0,E6<>\"\"),Beoordeling!H39,\"\")","v":0},{"$f":"IF(AND($A$10>0,F6<>\"\"),Beoordeling!I39,\"\")","v":0},{"$f":"IF(AND($A$10>0,G6<>\"\"),Beoordeling!J39,\"\")","v":0},{"$f":"IF(AND($A$10>0,H6<>\"\"),Beoordeling!K39,\"\")","v":0},{"$f":"IF(AND($A$10>0,I6<>\"\"),Beoordeling!L39,\"\")","v":0},{"$f":"IF(AND($A$10>0,J6<>\"\"),Beoordeling!M39,\"\")","v":0},{"$f":"IF(AND($A$10>0,K6<>\"\"),Beoordeling!N39,\"\")","v":0},{"$f":"IF(AND($A$10>0,L6<>\"\"),Beoordeling!O39,\"\")","v":0},{"$f":"IF(AND($A$10>0,M6<>\"\"),Beoordeling!P39,\"\")","v":0},{"$f":"IF(AND($A$10>0,N6<>\"\"),Beoordeling!Q39,\"\")","v":""},{"$f":"IF(AND($A$10>0,O6<>\"\"),Beoordeling!R39,\"\")","v":""},{"$f":"IF(AND($A$10>0,P6<>\"\"),Beoordeling!S39,\"\")","v":""},{"$f":"IF(AND($A$10>0,Q6<>\"\"),Beoordeling!T39,\"\")","v":""},{"$f":"IF(AND($A$10>0,R6<>\"\"),Beoordeling!U39,\"\")","v":""},{"$f":"IF(AND($A$10>0,S6<>\"\"),Beoordeling!V39,\"\")","v":""},{"$f":"IF(AND($A$10>0,T6<>\"\"),Beoordeling!W39,\"\")","v":""},{"$f":"IF(AND($A$10>0,U6<>\"\"),Beoordeling!X39,\"\")","v":""},{"$f":"IF(AND($A$10>0,V6<>\"\"),Beoordeling!Y39,\"\")","v":""},{"$f":"IF(AND($A$10>0,W6<>\"\"),Beoordeling!Z39,\"\")","v":""},{"$f":"IF(AND($A$10>0,X6<>\"\"),Beoordeling!AA39,\"\")","v":""},{"$f":"IF(AND($A$10>0,Y6<>\"\"),Beoordeling!AB39,\"\")","v":""},{"$f":"IF(AND($A$10>0,Z6<>\"\"),Beoordeling!AC39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AA6<>\"\"),Beoordeling!AD39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AB6<>\"\"),Beoordeling!AE39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AC6<>\"\"),Beoordeling!AF39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AD6<>\"\"),Beoordeling!AG39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AE6<>\"\"),Beoordeling!AH39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AF6<>\"\"),Beoordeling!AI39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AG6<>\"\"),Beoordeling!AJ39,\"\")","v":""},{"$f":"IF(AND($A$10>0,AH6<>\"\"),Beoordeling!AK39,\"\")","v":""},null,0]
[{"$f":"Beoordeling!E49","v":1},"E",{"$f":"IF(AND($A$11>0,C6<>\"\"),Beoordeling!F49,\"\")","v":0},{"$f":"IF(AND($A$11>0,D6<>\"\"),Beoordeling!G49,\"\")","v":0},{"$f":"IF(AND($A$11>0,E6<>\"\"),Beoordeling!H49,\"\")","v":0},{"$f":"IF(AND($A$11>0,F6<>\"\"),Beoordeling!I49,\"\")","v":0},{"$f":"IF(AND($A$11>0,G6<>\"\"),Beoordeling!J49,\"\")","v":0},{"$f":"IF(AND($A$11>0,H6<>\"\"),Beoordeling!K49,\"\")","v":0},{"$f":"IF(AND($A$11>0,I6<>\"\"),Beoordeling!L49,\"\")","v":0},{"$f":"IF(AND($A$11>0,J6<>\"\"),Beoordeling!M49,\"\")","v":0},{"$f":"IF(AND($A$11>0,K6<>\"\"),Beoordeling!N49,\"\")","v":0},{"$f":"IF(AND($A$11>0,L6<>\"\"),Beoordeling!O49,\"\")","v":0},{"$f":"IF(AND($A$11>0,M6<>\"\"),Beoordeling!P49,\"\")","v":0},{"$f":"IF(AND($A$11>0,N6<>\"\"),Beoordeling!Q49,\"\")","v":""},{"$f":"IF(AND($A$11>0,O6<>\"\"),Beoordeling!R49,\"\")","v":""},{"$f":"IF(AND($A$11>0,P6<>\"\"),Beoordeling!S49,\"\")","v":""},{"$f":"IF(AND($A$11>0,Q6<>\"\"),Beoordeling!T49,\"\")","v":""},{"$f":"IF(AND($A$11>0,R6<>\"\"),Beoordeling!U49,\"\")","v":""},{"$f":"IF(AND($A$11>0,S6<>\"\"),Beoordeling!V49,\"\")","v":""},{"$f":"IF(AND($A$11>0,T6<>\"\"),Beoordeling!W49,\"\")","v":""},{"$f":"IF(AND($A$11>0,U6<>\"\"),Beoordeling!X49,\"\")","v":""},{"$f":"IF(AND($A$11>0,V6<>\"\"),Beoordeling!Y49,\"\")","v":""},{"$f":"IF(AND($A$11>0,W6<>\"\"),Beoordeling!Z49,\"\")","v":""},{"$f":"IF(AND($A$11>0,X6<>\"\"),Beoordeling!AA49,\"\")","v":""},{"$f":"IF(AND($A$11>0,Y6<>\"\"),Beoordeling!AB49,\"\")","v":""},{"$f":"IF(AND($A$11>0,Z6<>\"\"),Beoordeling!AC49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AA6<>\"\"),Beoordeling!AD49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AB6<>\"\"),Beoordeling!AE49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AC6<>\"\"),Beoordeling!AF49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AD6<>\"\"),Beoordeling!AG49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AE6<>\"\"),Beoordeling!AH49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AF6<>\"\"),Beoordeling!AI49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AG6<>\"\"),Beoordeling!AJ49,\"\")","v":""},{"$f":"IF(AND($A$11>0,AH6<>\"\"),Beoordeling!AK49,\"\")","v":""},null,0]
[{"$f":"Beoordeling!E59","v":1},"F",{"$f":"IF(AND($A$12>0,C6<>\"\"),Beoordeling!F59,\"\")","v":0},{"$f":"IF(AND($A$12>0,D6<>\"\"),Beoordeling!G59,\"\")","v":0},{"$f":"IF(AND($A$12>0,E6<>\"\"),Beoordeling!H59,\"\")","v":0},{"$f":"IF(AND($A$12>0,F6<>\"\"),Beoordeling!I59,\"\")","v":0},{"$f":"IF(AND($A$12>0,G6<>\"\"),Beoordeling!J59,\"\")","v":0},{"$f":"IF(AND($A$12>0,H6<>\"\"),Beoordeling!K59,\"\")","v":0},{"$f":"IF(AND($A$12>0,I6<>\"\"),Beoordeling!L59,\"\")","v":0},{"$f":"IF(AND($A$12>0,J6<>\"\"),Beoordeling!M59,\"\")","v":0},{"$f":"IF(AND($A$12>0,K6<>\"\"),Beoordeling!N59,\"\")","v":0},{"$f":"IF(AND($A$12>0,L6<>\"\"),Beoordeling!O59,\"\")","v":0},{"$f":"IF(AND($A$12>0,M6<>\"\"),Beoordeling!P59,\"\")","v":0},{"$f":"IF(AND($A$12>0,N6<>\"\"),Beoordeling!Q59,\"\")","v":""},{"$f":"IF(AND($A$12>0,O6<>\"\"),Beoordeling!R59,\"\")","v":""},{"$f":"IF(AND($A$12>0,P6<>\"\"),Beoordeling!S59,\"\")","v":""},{"$f":"IF(AND($A$12>0,Q6<>\"\"),Beoordeling!T59,\"\")","v":""},{"$f":"IF(AND($A$12>0,R6<>\"\"),Beoordeling!U59,\"\")","v":""},{"$f":"IF(AND($A$12>0,S6<>\"\"),Beoordeling!V59,\"\")","v":""},{"$f":"IF(AND($A$12>0,T6<>\"\"),Beoordeling!W59,\"\")","v":""},{"$f":"IF(AND($A$12>0,U6<>\"\"),Beoordeling!X59,\"\")","v":""},{"$f":"IF(AND($A$12>0,V6<>\"\"),Beoordeling!Y59,\"\")","v":""},{"$f":"IF(AND($A$12>0,W6<>\"\"),Beoordeling!Z59,\"\")","v":""},{"$f":"IF(AND($A$12>0,X6<>\"\"),Beoordeling!AA59,\"\")","v":""},{"$f":"IF(AND($A$12>0,Y6<>\"\"),Beoordeling!AB59,\"\")","v":""},{"$f":"IF(AND($A$12>0,Z6<>\"\"),Beoordeling!AC59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AA6<>\"\"),Beoordeling!AD59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AB6<>\"\"),Beoordeling!AE59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AC6<>\"\"),Beoordeling!AF59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AD6<>\"\"),Beoordeling!AG59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AE6<>\"\"),Beoordeling!AH59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AF6<>\"\"),Beoordeling!AI59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AG6<>\"\"),Beoordeling!AJ59,\"\")","v":""},{"$f":"IF(AND($A$12>0,AH6<>\"\"),Beoordeling!AK59,\"\")","v":""},null,0]
[{"$f":"Beoordeling!E70","v":1},"G",{"$f":"IF(AND($A$13>0,C6<>\"\"),Beoordeling!F70,\"\")","v":0},{"$f":"IF(AND($A$13>0,D6<>\"\"),Beoordeling!G70,\"\")","v":0},{"$f":"IF(AND($A$13>0,E6<>\"\"),Beoordeling!H70,\"\")","v":0},{"$f":"IF(AND($A$13>0,F6<>\"\"),Beoordeling!I70,\"\")","v":0},{"$f":"IF(AND($A$13>0,G6<>\"\"),Beoordeling!J70,\"\")","v":0},{"$f":"IF(AND($A$13>0,H6<>\"\"),Beoordeling!K70,\"\")","v":0},{"$f":"IF(AND($A$13>0,I6<>\"\"),Beoordeling!L70,\"\")","v":0},{"$f":"IF(AND($A$13>0,J6<>\"\"),Beoordeling!M70,\"\")","v":0},{"$f":"IF(AND($A$13>0,K6<>\"\"),Beoordeling!N70,\"\")","v":0},{"$f":"IF(AND($A$13>0,L6<>\"\"),Beoordeling!O70,\"\")","v":0},{"$f":"IF(AND($A$13>0,M6<>\"\"),Beoordeling!P70,\"\")","v":0},{"$f":"IF(AND($A$13>0,N6<>\"\"),Beoordeling!Q70,\"\")","v":""},{"$f":"IF(AND($A$13>0,O6<>\"\"),Beoordeling!R70,\"\")","v":""},{"$f":"IF(AND($A$13>0,P6<>\"\"),Beoordeling!S70,\"\")","v":""},{"$f":"IF(AND($A$13>0,Q6<>\"\"),Beoordeling!T70,\"\")","v":""},{"$f":"IF(AND($A$13>0,R6<>\"\"),Beoordeling!U70,\"\")","v":""},{"$f":"IF(AND($A$13>0,S6<>\"\"),Beoordeling!V70,\"\")","v":""},{"$f":"IF(AND($A$13>0,T6<>\"\"),Beoordeling!W70,\"\")","v":""},{"$f":"IF(AND($A$13>0,U6<>\"\"),Beoordeling!X70,\"\")","v":""},{"$f":"IF(AND($A$13>0,V6<>\"\"),Beoordeling!Y70,\"\")","v":""},{"$f":"IF(AND($A$13>0,W6<>\"\"),Beoordeling!Z70,\"\")","v":""},{"$f":"IF(AND($A$13>0,X6<>\"\"),Beoordeling!AA70,\"\")","v":""},{"$f":"IF(AND($A$13>0,Y6<>\"\"),Beoordeling!AB70,\"\")","v":""},{"$f":"IF(AND($A$13>0,Z6<>\"\"),Beoordeling!AC70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AA6<>\"\"),Beoordeling!AD70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AB6<>\"\"),Beoordeling!AE70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AC6<>\"\"),Beoordeling!AF70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AD6<>\"\"),Beoordeling!AG70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AE6<>\"\"),Beoordeling!AH70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AF6<>\"\"),Beoordeling!AI70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AG6<>\"\"),Beoordeling!AJ70,\"\")","v":""},{"$f":"IF(AND($A$13>0,AH6<>\"\"),Beoordeling!AK70,\"\")","v":""},null,0]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$13,C7:C13))/SUM($A$7:$A$13),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C14:AH14)","v":0}]
[null,"cijfer",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$13,C7:C13)*0.9)/SUM($A$7:$A$13)+10,\"\")","v":10},10,10,10,10,10,10,10,10,10,10,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C15:AH15)","v":10}]