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

{"sheet":"Beoordeling","index":2,"n_rows":146,"n_cols":40,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":""},{"$f":"'Overzicht resultaten'!D6","v":""},{"$f":"'Overzicht resultaten'!E6","v":""},{"$f":"'Overzicht resultaten'!F6","v":""},{"$f":"'Overzicht resultaten'!G6","v":""},{"$f":"'Overzicht resultaten'!H6","v":""},{"$f":"'Overzicht resultaten'!I6","v":""},{"$f":"'Overzicht resultaten'!J6","v":""},{"$f":"'Overzicht resultaten'!K6","v":""},{"$f":"'Overzicht resultaten'!L6","v":""},{"$f":"'Overzicht resultaten'!M6","v":""},{"$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"]
[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"]
[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"]
[1,1,"omschrijft het probleem duidelijk",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"}]
[2,2,"brengt het probleem in verband met relevante kennis en of theorieën of met eerder 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(D$6>0,\"x\",0)","v":0}]
[3,3,"noemt meerdere kwalitatief goede, relevante, actuele bronnen, niet alleen nationale",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}]
[4,4,"omschrijft de onderzoeksvraag (vragen) goed",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]
[5,5,"heeft oog gehad voor de onderzoekbaarheid en haalbaarheid",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]
[6,6,"laat de onderzoeksvraag aansluiten bij de probleemstelling en theorie",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]
[7,7,"stelt de vraag op een vakinhoudelijke voldoende niveau",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]
[8,8,"bakent de vraag af, beperkt tot één probleem",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]
[9,9,"laat de deelvragen aansluiten bij de 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,0]
[10,10,"stelt de deelvragen voldoende concreet, de vragen zijn realistisch en onderzoekbaar",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]
[11,11,"formuleert een hypothese die past bij de onderzoeksvraag of probleemstelling",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]
[12,12,"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]
[13,13,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$5:$D$17)>0,$E$18>0),VALUE(SUMPRODUCT($D$5:$D$17*F5:F17)*100/(4*SUM($D$5:$D$17))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$17)>0,$E$18>0),VALUE(SUMPRODUCT($D$5:$D$17*G5:G17)*100/(4*SUM($D$5:$D$17))),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"]
[null,null,"B. De onderzoeksopzet",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[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"]
[14,1,"laat de opzet en methode van het onderzoek goed aansluiten bij de onderzoeksvraag en deelvragen",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(D21>0,\"x\",0)","v":"x"}]
[15,2,"zet het onderzoek logisch en adequaat op",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]
[16,3,"zet het onderzoek zichtbaar op volgens de natuurwetenschappelijke methode",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]
[17,4,"heeft oog voor controle of blanco experimenten",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]
[18,5,"laat zien dat herhaalbaarheid/reproduceerbaarheid belangrijk 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]
[19,6,"heeft oog voor de nauwkeurigheid van metingen of observaties",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]
[20,7,"geeft de proefopstelling schematisch aan of geeft een goede beschrijving hiervan",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]
[21,8,"zorgt voor voldoende diepgang van 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,0]
[22,9,"zorgt voor een betrouwbare en verifieerbare opzet van 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,0]
[23,10,"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]
[24,11,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$21:$D$31)>0,$E$32>0),VALUE(SUMPRODUCT($D$21:$D$31*F21:F31)*100/(4*SUM($D$21:$D$31))),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"]
[null,null,"C. De (beschrijving van de) uitvoering",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[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"]
[25,1,"voert het onderzoek uit volgens het werkplan, noteert afwijkingen en past het zo nodig aan",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(D35>0,\"x\",0)","v":"x"}]
[{"$f":"A35+1","v":26},2,"voert het onderzoek verantwoord, veilig en kritisch uit",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":"A36+1","v":27},3,"gaat adequaat om met instrumenten en materialen",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]
[28,4,"voert de waarnemingen en metingen systematisch, nauwkeurig en objectief uit en noteert deze (zo min mogelijk geïnterpreteerd)",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]
[29,5,"herhaalt metingen en waarnemingen en noteert deze ook",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]
[30,6,"ordent de gegevens op de juiste manier",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]
[31,7,"voert juiste berekeningen uit met de gegevens",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]
[32,8,"noteert alle gegevens correct, compleet, gedetailleerd en overzichtelijk ",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]
[33,9,"verwerkt de gegevens functioneel / relevant / passend in grafieken en tabellen",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]
[34,10,"zorgt voor voldoende kwaliteit van grafieken en tabellen (bv. bijschrift, schaalverdeling, grootheden, eenheden, meetpunten, spreiding, meetfout)",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":"A44+1","v":35},11,"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]
[36,12,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$35:$D$46)>0,$E$47>0),VALUE(SUMPRODUCT($D$35:$D$46*F35:F46)*100/(4*SUM($D$35:$D$46))),0)","v":0},{"$f":"IF(AND(SUM($D$35:$D$46)>0,$E$47>0),VALUE(SUMPRODUCT($D$35:$D$46*G35:G46)*100/(4*SUM($D$35:$D$46))),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"]
[null,null,"D. De conclusie",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[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"]
[37,1,"formuleert een conclusie die past bij de onderzoeksvraag en probleemstelling",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(D50>0,\"x\",0)","v":"x"}]
[{"$f":"A50+1","v":38},2,"onderbouwt de hypothese of weerlegt deze",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":"A51+1","v":39},3,"formuleert een conclusie die past bij de resultaten ",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]
[40,4,"onderbouwt de conclusie met een logische redenering",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]
[41,5,"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]
[42,6,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$50:$D$55)>0,$E$56>0),VALUE(SUMPRODUCT($D$50:$D$55*F50:F55)*100/(4*SUM($D$50:$D$55))),0)","v":0},{"$f":"IF(AND(SUM($D$50:$D$55)>0,$E$56>0),VALUE(SUMPRODUCT($D$50:$D$55*G50:G55)*100/(4*SUM($D$50:$D$55))),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"]
[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"]
[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"]
[43,1,"evalueert het onderzoeksproduct m.b.t. de resultaten en conclusie",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(D59>0,\"x\",0)","v":"x"}]
[{"$f":"A59+1","v":44},2,"geeft de betrouwbaarheid aan van de resultaten",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":"A60+1","v":45},3,"geeft andere mogelijke verklaringen voor de resultaten (zijn er andere alternatieven mogelijk?)",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]
[46,null,"geeft mogelijke oorzaken voor vertekende resultaten (vooringenomenheid, toeval, belangen)",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]
[47,4,"geeft aan hoe de onderzoeksresultaten te verifiëren zijn",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]
[48,5,"beschrijft verbeterpunten bij de uitvoering van 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,0]
[49,null,"onderscheidt feiten en meningen",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]
[50,6,"geeft suggesties 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]
[51,7,"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]
[52,8,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$59:$D$68)>0,$E$69>0),VALUE(SUMPRODUCT($D$59:$D$68*F59:F68)*100/(4*SUM($D$59:$D$68))),0)","v":0},{"$f":"IF(AND(SUM($D$59:$D$68)>0,$E$69>0),VALUE(SUMPRODUCT($D$59:$D$68*G59:G68)*100/(4*SUM($D$59:$D$68))),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"]
[null,null,"F. Structuur, taal en vormgeving:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[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"]
[53,1,"zorgt voor een duidelijke lijn in het verslag (zorgvuldig, helder en logisch opgeschreven, zonder overbodige informatie of herhaling)",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(D72>0,\"x\",0)","v":"x"}]
[{"$f":"A72+1","v":54},2,"bouwt het verslag op volgens de geldende standaard / voorschriften",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":"A73+1","v":55},3,"zorgt voor een opbouw in hoofdstukken, paragrafen, alinea's",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]
[56,4,"zorgt voor een goede inleiding (zoals probleemstelling, theoretisch kader, onderzoeks/ontwerpvragen, etc.)",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]
[57,5,"zorgt voor een paragraaf over de resultaten / conclusies",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]
[58,6,"zorgt voor functionele onderdelen, plaatsing van en verwijzing naar illustraties, tabellen en grafieken",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]
[59,7,"zorgt voor adequaatheid taalgebruik (begrijpelijk en afgestemd op de beoogde doelgroep)",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]
[60,8,"zorgt voor 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]
[61,9,"zorgt voor goede leesbaarheid, juist gebruik van grammatica, zinsconstructies en vermijdt spelfouten",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]
[62,10,"zorgt voor juist gebruik van vaktaal en vakbegrippen",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]
[63,11,"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]
[64,12,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$72:$D$83)>0,$E$84>0),VALUE(SUMPRODUCT($D$72:$D$83*F72:F83)*100/(4*SUM($D$72:$D$83))),0)","v":0},{"$f":"IF(AND(SUM($D$72:$D$83)>0,$E$84>0),VALUE(SUMPRODUCT($D$72:$D$83*G72:G83)*100/(4*SUM($D$72:$D$83))),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"]
[null,null,"G. Het proces: ",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,"de houding en creativiteit\nDe 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(D86>0,\"x\",0)","v":"x"}]
[65,1,"toont de wil om te weten, toont initiatief",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"]
[{"$f":"A87+1","v":66},2,"staat open voor commentaar en wil resultaten delen",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":"A88+1","v":67},3,"toont een kritische, analytische benadering",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]
[68,4,"toont zelfstandigheid, flexibiliteit, discipline en doorzettingsvermogen",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]
[69,5,"toont een eigen inbreng en komt met originele ideeën",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]
[70,6,"toont een integere professionele benadering",null,null,null,null,null,null,null,null,null,null,null,null,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]
[71,7,"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]
[72,8,"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]
[null,null,"de planning en vormgeving\nDe leerling:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[73,9,"plant duidelijke en realistische stappen ",null,null,null,null,null,null,null,null,null,null,null,null,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(D96>0,\"x\",0)","v":0}]
[{"$f":"A96+1","v":74},10,"rondt het werk op tijd af en levert het op tijd in",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":"A97+1","v":75},11,"heeft problemen in planning overwonnen en verantwoord",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":"A98+1","v":76},12,"toont zichtbare groei in houding, vaardigheden en/of 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]
[77,13,"zorgt voor goede communicatie met begeleiding op afgesproken momenten en verwerkt feedback op de juiste manier",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]
[78,14,"kan zelf een manier vinden om door te gaan als onderzoek vastloopt",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]
[79,15,"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]
[80,16,"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]
[null,null,"zelfstandigheid en samenwerking\nDe leerling:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[81,17,"kan naar een ander luisteren, met een ander rekening houden, een ander ondersteunen en waarderen",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(D105>0,\"x\",0)","v":0}]
[{"$f":"A105+1","v":82},18,"kan adequaat overleggen en feedback geven",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":"A106+1","v":83},19,"maakt gebruik van de talenten en voorkeuren van een ander",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]
[84,20,"maakt een verdeling van taken",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]
[85,21,"kan een ander aanspreken op het nakomen van afspraken",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]
[86,22,"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]
[87,23,"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]
[null,null,"de reflectie\nDe leerling:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[88,24,"kan reflecteren op het proces (houding, creativiteit, planning, voortgang, samenwerking)",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":"A113+1","v":89},25,"kan reflecteren op (de kwaliteit van) de behaalde resultaten",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":"A114+1","v":90},26,"kan reflecteren op eigen gedrag en het eigen leerproces",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]
[91,27,"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]
[92,28,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$87:$D$117)>0,$E$118>0),VALUE(SUMPRODUCT($D$87:$D$117*F87:F117)*100/(4*SUM($D$87:$D$117))),0)","v":0},{"$f":"IF(AND(SUM($D$87:$D$117)>0,$E$118>0),VALUE(SUMPRODUCT($D$87:$D$117*G87:G117)*100/(4*SUM($D$87:$D$117))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(SUM($D$87:$D$117)>0,$E$118>0),VALUE(SUMPRODUCT($D$87:$D$117*W87:W117)*100/(4*SUM($D$87:$D$117))),0)","v":0},{"$f":"IF(AND(SUM($D$87:$D$117)>0,$E$118>0),VALUE(SUMPRODUCT($D$87:$D$117*X87:X117)*100/(4*SUM($D$87:$D$117))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x"]
[null,null,"H. Het werkplan: ",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,"het inhoudelijk kader\nDe 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"]
[93,1,"beschrijft de onderzoeksvraag en deelvragen",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(D121>0,\"x\",0)","v":"x"}]
[{"$f":"A121+1","v":94},2,"geeft de theoretische onderbouwing en een aanzet van literatuurlijst",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":"A122+1","v":95},3,"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]
[96,4,"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]
[null,null,"de aanpak van het onderzoek\nDe leerling:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[97,5,"laat de aanpak van het onderzoek aansluiten bij de onderzoeksvraag, deelvragen en evt. hypothese",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":"A126+1","v":98},6,"beschrijft beperkingen en foutenbronnen in de aanpak van 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,0]
[{"$f":"A127+1","v":99},7,"beschrijft de gegevensverwerking in de aanpak van 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,0]
[100,8,"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]
[101,9,"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]
[null,null,"werkvoorbereiding\nDe leerling:",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[102,10,"zorgt voor een goede planning en werkvoorbereiding",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":"A132+1","v":103},11,"plant goede tussenstappen en tussenproducten",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":"A133+1","v":104},12,"plant een goede taakverdeling",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]
[105,13,"vermeldt veiligheidsrisico's van 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,0]
[106,14,"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]
[107,15,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*F121:F137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*G121:G137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*H121:H137)*100/(4*SUM($D$121:$D$137))),0)","v":0},0,0,0,0,0,0,{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*O121:O137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*P121:P137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*Q121:Q137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*R121:R137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*S121:S137)*100/(4*SUM($D$121:$D$137))),0)","v":0},0,0,{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*V121:V137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*W121:W137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*X121:X137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*Y121:Y137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*Z121:Z137)*100/(4*SUM($D$121:$D$137))),0)","v":0},0,0,{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AC121:AC137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AD121:AD137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AE121:AE137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AF121:AF137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AG121:AG137)*100/(4*SUM($D$121:$D$137))),0)","v":0},0,0,{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AJ121:AJ137)*100/(4*SUM($D$121:$D$137))),0)","v":0},{"$f":"IF(AND(SUM($D$121:$D$137)>0,$E$138>0),VALUE(SUMPRODUCT($D$121:$D$137*AK121:AK137)*100/(4*SUM($D$121:$D$137))),0)","v":0},null,null,"x"]
[null,null,"I. Het logboek",null,null,null,null,null,null,null,null,null,null,null,null,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"]
[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"]
[108,1,"zorgt er voor dat het logboek inzicht geeft in het verloop van het onderzoek, de verzameling van de gegevens en de verslaglegging",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(D141>0,\"x\",0)","v":"x"}]
[{"$f":"A141+1","v":109},2,"beschrijft in het logboek wat hij leert, hij reflecteert op de inhoud van 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,0]
[{"$f":"A142+1","v":110},3,"reflecteert op het onderzoeksproces",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]
[111,4,"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]
[112,5,"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]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$141:$D$145)>0,$E$146>0),VALUE(SUMPRODUCT($D$141:$D$145*F141:F145)*100/(4*SUM($D$141:$D$145))),0)","v":0},{"$f":"IF(AND(SUM($D$141:$D$145)>0,$E$146>0),VALUE(SUMPRODUCT($D$141:$D$145*G141:G145)*100/(4*SUM($D$141:$D$145))),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"]

{"sheet":"Overzicht resultaten","index":3,"n_rows":17,"n_cols":36,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["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":""},{"$f":"IF(Agendalijst!B6=\"\",\"\",Agendalijst!B6)","v":""},{"$f":"IF(Agendalijst!B7=\"\",\"\",Agendalijst!B7)","v":""},{"$f":"IF(Agendalijst!B8=\"\",\"\",Agendalijst!B8)","v":""},{"$f":"IF(Agendalijst!B9=\"\",\"\",Agendalijst!B9)","v":""},{"$f":"IF(Agendalijst!B10=\"\",\"\",Agendalijst!B10)","v":""},{"$f":"IF(Agendalijst!B11=\"\",\"\",Agendalijst!B11)","v":""},{"$f":"IF(Agendalijst!B12=\"\",\"\",Agendalijst!B12)","v":""},{"$f":"IF(Agendalijst!B13=\"\",\"\",Agendalijst!B13)","v":""},{"$f":"IF(Agendalijst!B14=\"\",\"\",Agendalijst!B14)","v":""},{"$f":"IF(Agendalijst!B15=\"\",\"\",Agendalijst!B15)","v":""},{"$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!E18","v":1},"A",{"$f":"IF(AND($A7>0,C6<>\"\"),Beoordeling!F18,\"\")","v":""},{"$f":"IF(AND($A7>0,D6<>\"\"),Beoordeling!G18,\"\")","v":""},{"$f":"IF(AND($A7>0,E6<>\"\"),Beoordeling!H18,\"\")","v":""},{"$f":"IF(AND($A7>0,F6<>\"\"),Beoordeling!I18,\"\")","v":""},{"$f":"IF(AND($A7>0,G6<>\"\"),Beoordeling!J18,\"\")","v":""},{"$f":"IF(AND($A7>0,H6<>\"\"),Beoordeling!K18,\"\")","v":""},{"$f":"IF(AND($A7>0,I6<>\"\"),Beoordeling!L18,\"\")","v":""},{"$f":"IF(AND($A7>0,J6<>\"\"),Beoordeling!M18,\"\")","v":""},{"$f":"IF(AND($A7>0,K6<>\"\"),Beoordeling!N18,\"\")","v":""},{"$f":"IF(AND($A7>0,L6<>\"\"),Beoordeling!O18,\"\")","v":""},{"$f":"IF(AND($A7>0,M6<>\"\"),Beoordeling!P18,\"\")","v":""},{"$f":"IF(AND($A7>0,N6<>\"\"),Beoordeling!Q18,\"\")","v":""},{"$f":"IF(AND($A7>0,O6<>\"\"),Beoordeling!R18,\"\")","v":""},{"$f":"IF(AND($A7>0,P6<>\"\"),Beoordeling!S18,\"\")","v":""},{"$f":"IF(AND($A7>0,Q6<>\"\"),Beoordeling!T18,\"\")","v":""},{"$f":"IF(AND($A7>0,R6<>\"\"),Beoordeling!U18,\"\")","v":""},{"$f":"IF(AND($A7>0,S6<>\"\"),Beoordeling!V18,\"\")","v":""},{"$f":"IF(AND($A7>0,T6<>\"\"),Beoordeling!W18,\"\")","v":""},{"$f":"IF(AND($A7>0,U6<>\"\"),Beoordeling!X18,\"\")","v":""},{"$f":"IF(AND($A7>0,V6<>\"\"),Beoordeling!Y18,\"\")","v":""},{"$f":"IF(AND($A7>0,W6<>\"\"),Beoordeling!Z18,\"\")","v":""},{"$f":"IF(AND($A7>0,X6<>\"\"),Beoordeling!AA18,\"\")","v":""},{"$f":"IF(AND($A7>0,Y6<>\"\"),Beoordeling!AB18,\"\")","v":""},{"$f":"IF(AND($A7>0,Z6<>\"\"),Beoordeling!AC18,\"\")","v":""},{"$f":"IF(AND($A7>0,AA6<>\"\"),Beoordeling!AD18,\"\")","v":""},{"$f":"IF(AND($A7>0,AB6<>\"\"),Beoordeling!AE18,\"\")","v":""},{"$f":"IF(AND($A7>0,AC6<>\"\"),Beoordeling!AF18,\"\")","v":""},{"$f":"IF(AND($A7>0,AD6<>\"\"),Beoordeling!AG18,\"\")","v":""},{"$f":"IF(AND($A7>0,AE6<>\"\"),Beoordeling!AH18,\"\")","v":""},{"$f":"IF(AND($A7>0,AF6<>\"\"),Beoordeling!AI18,\"\")","v":""},{"$f":"IF(AND($A7>0,AG6<>\"\"),Beoordeling!AJ18,\"\")","v":""},{"$f":"IF(AND($A7>0,AH6<>\"\"),Beoordeling!AK18,\"\")","v":""},null,{"$f":"IF(A7>0,AVERAGE(C7:AH7),\"-\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"Beoordeling!E32","v":1},"B",{"$f":"IF(AND($A$8>0,C6<>\"\"),Beoordeling!F32,\"\")","v":""},{"$f":"IF(AND($A$8>0,D6<>\"\"),Beoordeling!G32,\"\")","v":""},{"$f":"IF(AND($A$8>0,E6<>\"\"),Beoordeling!H32,\"\")","v":""},{"$f":"IF(AND($A$8>0,F6<>\"\"),Beoordeling!I32,\"\")","v":""},{"$f":"IF(AND($A$8>0,G6<>\"\"),Beoordeling!J32,\"\")","v":""},{"$f":"IF(AND($A$8>0,H6<>\"\"),Beoordeling!K32,\"\")","v":""},{"$f":"IF(AND($A$8>0,I6<>\"\"),Beoordeling!L32,\"\")","v":""},{"$f":"IF(AND($A$8>0,J6<>\"\"),Beoordeling!M32,\"\")","v":""},{"$f":"IF(AND($A$8>0,K6<>\"\"),Beoordeling!N32,\"\")","v":""},{"$f":"IF(AND($A$8>0,L6<>\"\"),Beoordeling!O32,\"\")","v":""},{"$f":"IF(AND($A$8>0,M6<>\"\"),Beoordeling!P32,\"\")","v":""},{"$f":"IF(AND($A$8>0,N6<>\"\"),Beoordeling!Q32,\"\")","v":""},{"$f":"IF(AND($A$8>0,O6<>\"\"),Beoordeling!R32,\"\")","v":""},{"$f":"IF(AND($A$8>0,P6<>\"\"),Beoordeling!S32,\"\")","v":""},{"$f":"IF(AND($A$8>0,Q6<>\"\"),Beoordeling!T32,\"\")","v":""},{"$f":"IF(AND($A$8>0,R6<>\"\"),Beoordeling!U32,\"\")","v":""},{"$f":"IF(AND($A$8>0,S6<>\"\"),Beoordeling!V32,\"\")","v":""},{"$f":"IF(AND($A$8>0,T6<>\"\"),Beoordeling!W32,\"\")","v":""},{"$f":"IF(AND($A$8>0,U6<>\"\"),Beoordeling!X32,\"\")","v":""},{"$f":"IF(AND($A$8>0,V6<>\"\"),Beoordeling!Y32,\"\")","v":""},{"$f":"IF(AND($A$8>0,W6<>\"\"),Beoordeling!Z32,\"\")","v":""},{"$f":"IF(AND($A$8>0,X6<>\"\"),Beoordeling!AA32,\"\")","v":""},{"$f":"IF(AND($A$8>0,Y6<>\"\"),Beoordeling!AB32,\"\")","v":""},{"$f":"IF(AND($A$8>0,Z6<>\"\"),Beoordeling!AC32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AA6<>\"\"),Beoordeling!AD32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AB6<>\"\"),Beoordeling!AE32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AC6<>\"\"),Beoordeling!AF32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AD6<>\"\"),Beoordeling!AG32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AE6<>\"\"),Beoordeling!AH32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AF6<>\"\"),Beoordeling!AI32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AG6<>\"\"),Beoordeling!AJ32,\"\")","v":""},{"$f":"IF(AND($A$8>0,AH6<>\"\"),Beoordeling!AK32,\"\")","v":""},null,{"$f":"IF(A8>0,AVERAGE(C8:AH8),\"-\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"Beoordeling!E47","v":1},"C",{"$f":"IF(AND($A$9>0,C6<>\"\"),Beoordeling!F47,\"\")","v":""},{"$f":"IF(AND($A$9>0,D6<>\"\"),Beoordeling!G47,\"\")","v":""},{"$f":"IF(AND($A$9>0,E6<>\"\"),Beoordeling!H47,\"\")","v":""},{"$f":"IF(AND($A$9>0,F6<>\"\"),Beoordeling!I47,\"\")","v":""},{"$f":"IF(AND($A$9>0,G6<>\"\"),Beoordeling!J47,\"\")","v":""},{"$f":"IF(AND($A$9>0,H6<>\"\"),Beoordeling!K47,\"\")","v":""},{"$f":"IF(AND($A$9>0,I6<>\"\"),Beoordeling!L47,\"\")","v":""},{"$f":"IF(AND($A$9>0,J6<>\"\"),Beoordeling!M47,\"\")","v":""},{"$f":"IF(AND($A$9>0,K6<>\"\"),Beoordeling!N47,\"\")","v":""},{"$f":"IF(AND($A$9>0,L6<>\"\"),Beoordeling!O47,\"\")","v":""},{"$f":"IF(AND($A$9>0,M6<>\"\"),Beoordeling!P47,\"\")","v":""},{"$f":"IF(AND($A$9>0,N6<>\"\"),Beoordeling!Q47,\"\")","v":""},{"$f":"IF(AND($A$9>0,O6<>\"\"),Beoordeling!R47,\"\")","v":""},{"$f":"IF(AND($A$9>0,P6<>\"\"),Beoordeling!S47,\"\")","v":""},{"$f":"IF(AND($A$9>0,Q6<>\"\"),Beoordeling!T47,\"\")","v":""},{"$f":"IF(AND($A$9>0,R6<>\"\"),Beoordeling!U47,\"\")","v":""},{"$f":"IF(AND($A$9>0,S6<>\"\"),Beoordeling!V47,\"\")","v":""},{"$f":"IF(AND($A$9>0,T6<>\"\"),Beoordeling!W47,\"\")","v":""},{"$f":"IF(AND($A$9>0,U6<>\"\"),Beoordeling!X47,\"\")","v":""},{"$f":"IF(AND($A$9>0,V6<>\"\"),Beoordeling!Y47,\"\")","v":""},{"$f":"IF(AND($A$9>0,W6<>\"\"),Beoordeling!Z47,\"\")","v":""},{"$f":"IF(AND($A$9>0,X6<>\"\"),Beoordeling!AA47,\"\")","v":""},{"$f":"IF(AND($A$9>0,Y6<>\"\"),Beoordeling!AB47,\"\")","v":""},{"$f":"IF(AND($A$9>0,Z6<>\"\"),Beoordeling!AC47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AA6<>\"\"),Beoordeling!AD47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AB6<>\"\"),Beoordeling!AE47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AC6<>\"\"),Beoordeling!AF47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AD6<>\"\"),Beoordeling!AG47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AE6<>\"\"),Beoordeling!AH47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AF6<>\"\"),Beoordeling!AI47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AG6<>\"\"),Beoordeling!AJ47,\"\")","v":""},{"$f":"IF(AND($A$9>0,AH6<>\"\"),Beoordeling!AK47,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E56","v":1},"D",{"$f":"IF(AND($A$10>0,C6<>\"\"),Beoordeling!F56,\"\")","v":""},{"$f":"IF(AND($A$10>0,D6<>\"\"),Beoordeling!G56,\"\")","v":""},{"$f":"IF(AND($A$10>0,E6<>\"\"),Beoordeling!H56,\"\")","v":""},{"$f":"IF(AND($A$10>0,F6<>\"\"),Beoordeling!I56,\"\")","v":""},{"$f":"IF(AND($A$10>0,G6<>\"\"),Beoordeling!J56,\"\")","v":""},{"$f":"IF(AND($A$10>0,H6<>\"\"),Beoordeling!K56,\"\")","v":""},{"$f":"IF(AND($A$10>0,I6<>\"\"),Beoordeling!L56,\"\")","v":""},{"$f":"IF(AND($A$10>0,J6<>\"\"),Beoordeling!M56,\"\")","v":""},{"$f":"IF(AND($A$10>0,K6<>\"\"),Beoordeling!N56,\"\")","v":""},{"$f":"IF(AND($A$10>0,L6<>\"\"),Beoordeling!O56,\"\")","v":""},{"$f":"IF(AND($A$10>0,M6<>\"\"),Beoordeling!P56,\"\")","v":""},{"$f":"IF(AND($A$10>0,N6<>\"\"),Beoordeling!Q56,\"\")","v":""},{"$f":"IF(AND($A$10>0,O6<>\"\"),Beoordeling!R56,\"\")","v":""},{"$f":"IF(AND($A$10>0,P6<>\"\"),Beoordeling!S56,\"\")","v":""},{"$f":"IF(AND($A$10>0,Q6<>\"\"),Beoordeling!T56,\"\")","v":""},{"$f":"IF(AND($A$10>0,R6<>\"\"),Beoordeling!U56,\"\")","v":""},{"$f":"IF(AND($A$10>0,S6<>\"\"),Beoordeling!V56,\"\")","v":""},{"$f":"IF(AND($A$10>0,T6<>\"\"),Beoordeling!W56,\"\")","v":""},{"$f":"IF(AND($A$10>0,U6<>\"\"),Beoordeling!X56,\"\")","v":""},{"$f":"IF(AND($A$10>0,V6<>\"\"),Beoordeling!Y56,\"\")","v":""},{"$f":"IF(AND($A$10>0,W6<>\"\"),Beoordeling!Z56,\"\")","v":""},{"$f":"IF(AND($A$10>0,X6<>\"\"),Beoordeling!AA56,\"\")","v":""},{"$f":"IF(AND($A$10>0,Y6<>\"\"),Beoordeling!AB56,\"\")","v":""},{"$f":"IF(AND($A$10>0,Z6<>\"\"),Beoordeling!AC56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AA6<>\"\"),Beoordeling!AD56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AB6<>\"\"),Beoordeling!AE56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AC6<>\"\"),Beoordeling!AF56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AD6<>\"\"),Beoordeling!AG56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AE6<>\"\"),Beoordeling!AH56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AF6<>\"\"),Beoordeling!AI56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AG6<>\"\"),Beoordeling!AJ56,\"\")","v":""},{"$f":"IF(AND($A$10>0,AH6<>\"\"),Beoordeling!AK56,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E69","v":1},"E",{"$f":"IF(AND($A$11>0,C6<>\"\"),Beoordeling!F69,\"\")","v":""},{"$f":"IF(AND($A$11>0,D6<>\"\"),Beoordeling!G69,\"\")","v":""},{"$f":"IF(AND($A$11>0,E6<>\"\"),Beoordeling!H69,\"\")","v":""},{"$f":"IF(AND($A$11>0,F6<>\"\"),Beoordeling!I69,\"\")","v":""},{"$f":"IF(AND($A$11>0,G6<>\"\"),Beoordeling!J69,\"\")","v":""},{"$f":"IF(AND($A$11>0,H6<>\"\"),Beoordeling!K69,\"\")","v":""},{"$f":"IF(AND($A$11>0,I6<>\"\"),Beoordeling!L69,\"\")","v":""},{"$f":"IF(AND($A$11>0,J6<>\"\"),Beoordeling!M69,\"\")","v":""},{"$f":"IF(AND($A$11>0,K6<>\"\"),Beoordeling!N69,\"\")","v":""},{"$f":"IF(AND($A$11>0,L6<>\"\"),Beoordeling!O69,\"\")","v":""},{"$f":"IF(AND($A$11>0,M6<>\"\"),Beoordeling!P69,\"\")","v":""},{"$f":"IF(AND($A$11>0,N6<>\"\"),Beoordeling!Q69,\"\")","v":""},{"$f":"IF(AND($A$11>0,O6<>\"\"),Beoordeling!R69,\"\")","v":""},{"$f":"IF(AND($A$11>0,P6<>\"\"),Beoordeling!S69,\"\")","v":""},{"$f":"IF(AND($A$11>0,Q6<>\"\"),Beoordeling!T69,\"\")","v":""},{"$f":"IF(AND($A$11>0,R6<>\"\"),Beoordeling!U69,\"\")","v":""},{"$f":"IF(AND($A$11>0,S6<>\"\"),Beoordeling!V69,\"\")","v":""},{"$f":"IF(AND($A$11>0,T6<>\"\"),Beoordeling!W69,\"\")","v":""},{"$f":"IF(AND($A$11>0,U6<>\"\"),Beoordeling!X69,\"\")","v":""},{"$f":"IF(AND($A$11>0,V6<>\"\"),Beoordeling!Y69,\"\")","v":""},{"$f":"IF(AND($A$11>0,W6<>\"\"),Beoordeling!Z69,\"\")","v":""},{"$f":"IF(AND($A$11>0,X6<>\"\"),Beoordeling!AA69,\"\")","v":""},{"$f":"IF(AND($A$11>0,Y6<>\"\"),Beoordeling!AB69,\"\")","v":""},{"$f":"IF(AND($A$11>0,Z6<>\"\"),Beoordeling!AC69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AA6<>\"\"),Beoordeling!AD69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AB6<>\"\"),Beoordeling!AE69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AC6<>\"\"),Beoordeling!AF69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AD6<>\"\"),Beoordeling!AG69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AE6<>\"\"),Beoordeling!AH69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AF6<>\"\"),Beoordeling!AI69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AG6<>\"\"),Beoordeling!AJ69,\"\")","v":""},{"$f":"IF(AND($A$11>0,AH6<>\"\"),Beoordeling!AK69,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E84","v":1},"F",{"$f":"IF(AND($A$12>0,C6<>\"\"),Beoordeling!F84,\"\")","v":""},{"$f":"IF(AND($A$12>0,D6<>\"\"),Beoordeling!G84,\"\")","v":""},{"$f":"IF(AND($A$12>0,E6<>\"\"),Beoordeling!H84,\"\")","v":""},{"$f":"IF(AND($A$12>0,F6<>\"\"),Beoordeling!I84,\"\")","v":""},{"$f":"IF(AND($A$12>0,G6<>\"\"),Beoordeling!J84,\"\")","v":""},{"$f":"IF(AND($A$12>0,H6<>\"\"),Beoordeling!K84,\"\")","v":""},{"$f":"IF(AND($A$12>0,I6<>\"\"),Beoordeling!L84,\"\")","v":""},{"$f":"IF(AND($A$12>0,J6<>\"\"),Beoordeling!M84,\"\")","v":""},{"$f":"IF(AND($A$12>0,K6<>\"\"),Beoordeling!N84,\"\")","v":""},{"$f":"IF(AND($A$12>0,L6<>\"\"),Beoordeling!O84,\"\")","v":""},{"$f":"IF(AND($A$12>0,M6<>\"\"),Beoordeling!P84,\"\")","v":""},{"$f":"IF(AND($A$12>0,N6<>\"\"),Beoordeling!Q84,\"\")","v":""},{"$f":"IF(AND($A$12>0,O6<>\"\"),Beoordeling!R84,\"\")","v":""},{"$f":"IF(AND($A$12>0,P6<>\"\"),Beoordeling!S84,\"\")","v":""},{"$f":"IF(AND($A$12>0,Q6<>\"\"),Beoordeling!T84,\"\")","v":""},{"$f":"IF(AND($A$12>0,R6<>\"\"),Beoordeling!U84,\"\")","v":""},{"$f":"IF(AND($A$12>0,S6<>\"\"),Beoordeling!V84,\"\")","v":""},{"$f":"IF(AND($A$12>0,T6<>\"\"),Beoordeling!W84,\"\")","v":""},{"$f":"IF(AND($A$12>0,U6<>\"\"),Beoordeling!X84,\"\")","v":""},{"$f":"IF(AND($A$12>0,V6<>\"\"),Beoordeling!Y84,\"\")","v":""},{"$f":"IF(AND($A$12>0,W6<>\"\"),Beoordeling!Z84,\"\")","v":""},{"$f":"IF(AND($A$12>0,X6<>\"\"),Beoordeling!AA84,\"\")","v":""},{"$f":"IF(AND($A$12>0,Y6<>\"\"),Beoordeling!AB84,\"\")","v":""},{"$f":"IF(AND($A$12>0,Z6<>\"\"),Beoordeling!AC84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AA6<>\"\"),Beoordeling!AD84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AB6<>\"\"),Beoordeling!AE84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AC6<>\"\"),Beoordeling!AF84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AD6<>\"\"),Beoordeling!AG84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AE6<>\"\"),Beoordeling!AH84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AF6<>\"\"),Beoordeling!AI84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AG6<>\"\"),Beoordeling!AJ84,\"\")","v":""},{"$f":"IF(AND($A$12>0,AH6<>\"\"),Beoordeling!AK84,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E118","v":1},"G",{"$f":"IF(AND($A$13>0,C6<>\"\"),Beoordeling!F118,\"\")","v":""},{"$f":"IF(AND($A$13>0,D6<>\"\"),Beoordeling!G118,\"\")","v":""},{"$f":"IF(AND($A$13>0,E6<>\"\"),Beoordeling!H118,\"\")","v":""},{"$f":"IF(AND($A$13>0,F6<>\"\"),Beoordeling!I118,\"\")","v":""},{"$f":"IF(AND($A$13>0,G6<>\"\"),Beoordeling!J118,\"\")","v":""},{"$f":"IF(AND($A$13>0,H6<>\"\"),Beoordeling!K118,\"\")","v":""},{"$f":"IF(AND($A$13>0,I6<>\"\"),Beoordeling!L118,\"\")","v":""},{"$f":"IF(AND($A$13>0,J6<>\"\"),Beoordeling!M118,\"\")","v":""},{"$f":"IF(AND($A$13>0,K6<>\"\"),Beoordeling!N118,\"\")","v":""},{"$f":"IF(AND($A$13>0,L6<>\"\"),Beoordeling!O118,\"\")","v":""},{"$f":"IF(AND($A$13>0,M6<>\"\"),Beoordeling!P118,\"\")","v":""},{"$f":"IF(AND($A$13>0,N6<>\"\"),Beoordeling!Q118,\"\")","v":""},{"$f":"IF(AND($A$13>0,O6<>\"\"),Beoordeling!R118,\"\")","v":""},{"$f":"IF(AND($A$13>0,P6<>\"\"),Beoordeling!S118,\"\")","v":""},{"$f":"IF(AND($A$13>0,Q6<>\"\"),Beoordeling!T118,\"\")","v":""},{"$f":"IF(AND($A$13>0,R6<>\"\"),Beoordeling!U118,\"\")","v":""},{"$f":"IF(AND($A$13>0,S6<>\"\"),Beoordeling!V118,\"\")","v":""},{"$f":"IF(AND($A$13>0,T6<>\"\"),Beoordeling!W118,\"\")","v":""},{"$f":"IF(AND($A$13>0,U6<>\"\"),Beoordeling!X118,\"\")","v":""},{"$f":"IF(AND($A$13>0,V6<>\"\"),Beoordeling!Y118,\"\")","v":""},{"$f":"IF(AND($A$13>0,W6<>\"\"),Beoordeling!Z118,\"\")","v":""},{"$f":"IF(AND($A$13>0,X6<>\"\"),Beoordeling!AA118,\"\")","v":""},{"$f":"IF(AND($A$13>0,Y6<>\"\"),Beoordeling!AB118,\"\")","v":""},{"$f":"IF(AND($A$13>0,Z6<>\"\"),Beoordeling!AC118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AA6<>\"\"),Beoordeling!AD118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AB6<>\"\"),Beoordeling!AE118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AC6<>\"\"),Beoordeling!AF118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AD6<>\"\"),Beoordeling!AG118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AE6<>\"\"),Beoordeling!AH118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AF6<>\"\"),Beoordeling!AI118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AG6<>\"\"),Beoordeling!AJ118,\"\")","v":""},{"$f":"IF(AND($A$13>0,AH6<>\"\"),Beoordeling!AK118,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E138","v":1},"H",{"$f":"IF(AND($A$14>0,C6<>\"\"),Beoordeling!F138,\"\")","v":""},{"$f":"IF(AND($A$14>0,D6<>\"\"),Beoordeling!G138,\"\")","v":""},{"$f":"IF(AND($A$14>0,E6<>\"\"),Beoordeling!H138,\"\")","v":""},{"$f":"IF(AND($A$14>0,F6<>\"\"),Beoordeling!I138,\"\")","v":""},{"$f":"IF(AND($A$14>0,G6<>\"\"),Beoordeling!J138,\"\")","v":""},{"$f":"IF(AND($A$14>0,H6<>\"\"),Beoordeling!K138,\"\")","v":""},{"$f":"IF(AND($A$14>0,I6<>\"\"),Beoordeling!L138,\"\")","v":""},{"$f":"IF(AND($A$14>0,J6<>\"\"),Beoordeling!M138,\"\")","v":""},{"$f":"IF(AND($A$14>0,K6<>\"\"),Beoordeling!N138,\"\")","v":""},{"$f":"IF(AND($A$14>0,L6<>\"\"),Beoordeling!O138,\"\")","v":""},{"$f":"IF(AND($A$14>0,M6<>\"\"),Beoordeling!P138,\"\")","v":""},{"$f":"IF(AND($A$14>0,N6<>\"\"),Beoordeling!Q138,\"\")","v":""},{"$f":"IF(AND($A$14>0,O6<>\"\"),Beoordeling!R138,\"\")","v":""},{"$f":"IF(AND($A$14>0,P6<>\"\"),Beoordeling!S138,\"\")","v":""},{"$f":"IF(AND($A$14>0,Q6<>\"\"),Beoordeling!T138,\"\")","v":""},{"$f":"IF(AND($A$14>0,R6<>\"\"),Beoordeling!U138,\"\")","v":""},{"$f":"IF(AND($A$14>0,S6<>\"\"),Beoordeling!V138,\"\")","v":""},{"$f":"IF(AND($A$14>0,T6<>\"\"),Beoordeling!W138,\"\")","v":""},{"$f":"IF(AND($A$14>0,U6<>\"\"),Beoordeling!X138,\"\")","v":""},{"$f":"IF(AND($A$14>0,V6<>\"\"),Beoordeling!Y138,\"\")","v":""},{"$f":"IF(AND($A$14>0,W6<>\"\"),Beoordeling!Z138,\"\")","v":""},{"$f":"IF(AND($A$14>0,X6<>\"\"),Beoordeling!AA138,\"\")","v":""},{"$f":"IF(AND($A$14>0,Y6<>\"\"),Beoordeling!AB138,\"\")","v":""},{"$f":"IF(AND($A$14>0,Z6<>\"\"),Beoordeling!AC138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AA6<>\"\"),Beoordeling!AD138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AB6<>\"\"),Beoordeling!AE138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AC6<>\"\"),Beoordeling!AF138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AD6<>\"\"),Beoordeling!AG138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AE6<>\"\"),Beoordeling!AH138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AF6<>\"\"),Beoordeling!AI138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AG6<>\"\"),Beoordeling!AJ138,\"\")","v":""},{"$f":"IF(AND($A$14>0,AH6<>\"\"),Beoordeling!AK138,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"Beoordeling!E146","v":1},"I",{"$f":"IF(AND($A$15>0,C6<>\"\"),Beoordeling!F146,\"\")","v":""},{"$f":"IF(AND($A$15>0,D6<>\"\"),Beoordeling!G146,\"\")","v":""},{"$f":"IF(AND($A$15>0,E6<>\"\"),Beoordeling!H146,\"\")","v":""},{"$f":"IF(AND($A$15>0,F6<>\"\"),Beoordeling!I146,\"\")","v":""},{"$f":"IF(AND($A$15>0,G6<>\"\"),Beoordeling!J146,\"\")","v":""},{"$f":"IF(AND($A$15>0,H6<>\"\"),Beoordeling!K146,\"\")","v":""},{"$f":"IF(AND($A$15>0,I6<>\"\"),Beoordeling!L146,\"\")","v":""},{"$f":"IF(AND($A$15>0,J6<>\"\"),Beoordeling!M146,\"\")","v":""},{"$f":"IF(AND($A$15>0,K6<>\"\"),Beoordeling!N146,\"\")","v":""},{"$f":"IF(AND($A$15>0,L6<>\"\"),Beoordeling!O146,\"\")","v":""},{"$f":"IF(AND($A$15>0,M6<>\"\"),Beoordeling!P146,\"\")","v":""},{"$f":"IF(AND($A$15>0,N6<>\"\"),Beoordeling!Q146,\"\")","v":""},{"$f":"IF(AND($A$15>0,O6<>\"\"),Beoordeling!R146,\"\")","v":""},{"$f":"IF(AND($A$15>0,P6<>\"\"),Beoordeling!S146,\"\")","v":""},{"$f":"IF(AND($A$15>0,Q6<>\"\"),Beoordeling!T146,\"\")","v":""},{"$f":"IF(AND($A$15>0,R6<>\"\"),Beoordeling!U146,\"\")","v":""},{"$f":"IF(AND($A$15>0,S6<>\"\"),Beoordeling!V146,\"\")","v":""},{"$f":"IF(AND($A$15>0,T6<>\"\"),Beoordeling!W146,\"\")","v":""},{"$f":"IF(AND($A$15>0,U6<>\"\"),Beoordeling!X146,\"\")","v":""},{"$f":"IF(AND($A$15>0,V6<>\"\"),Beoordeling!Y146,\"\")","v":""},{"$f":"IF(AND($A$15>0,W6<>\"\"),Beoordeling!Z146,\"\")","v":""},{"$f":"IF(AND($A$15>0,X6<>\"\"),Beoordeling!AA146,\"\")","v":""},{"$f":"IF(AND($A$15>0,Y6<>\"\"),Beoordeling!AB146,\"\")","v":""},{"$f":"IF(AND($A$15>0,Z6<>\"\"),Beoordeling!AC146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AA6<>\"\"),Beoordeling!AD146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AB6<>\"\"),Beoordeling!AE146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AC6<>\"\"),Beoordeling!AF146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AD6<>\"\"),Beoordeling!AG146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AE6<>\"\"),Beoordeling!AH146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AF6<>\"\"),Beoordeling!AI146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AG6<>\"\"),Beoordeling!AJ146,\"\")","v":""},{"$f":"IF(AND($A$15>0,AH6<>\"\"),Beoordeling!AK146,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$15,C7:C15))/SUM($A$7:$A$15),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AH6<>\"\",(SUMPRODUCT($A$7:$A$15,AH7:AH15))/SUM($A$7:$A$15),\"\")","v":""},null,{"$f":"AVERAGE(C16:AH16)","v":{"$error":"#DIV/0!"}}]
[null,"cijfer",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$15,C7:C15)*0.9)/SUM($A$7:$A$15)+10,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AH6<>\"\",(SUMPRODUCT($A$7:$A$15,AH7:AH15)*0.9)/SUM($A$7:$A$15)+10,\"\")","v":""},null,{"$f":"AVERAGE(C17:AH17)","v":{"$error":"#DIV/0!"}}]