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

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

{"sheet":"Agendalijst","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Leerlingenlijst"]
[]
[]
[null,"Naam","eindcijfer",null,"ik kies voor schaal: 0- ...",4]
[1,"Jan",{"$f":"IF(B5<>\"\",'Overzicht resultaten'!C$17,\"\")","v":100}]
[{"$f":"A5+1","v":2},"Piet",{"$f":"IF(B6<>\"\",'Overzicht resultaten'!D$17,\"\")","v":10}]
[{"$f":"A6+1","v":3},"Klaas",{"$f":"IF(B7<>\"\",'Overzicht resultaten'!E$17,\"\")","v":10}]
[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,"Frits",{"$f":"IF(B26<>\"\",'Overzicht resultaten'!X$17,\"\")","v":84.732142857142861}]
[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":"Beoord Verslag","index":2,"n_rows":71,"n_cols":40,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"Jan"},{"$f":"'Overzicht resultaten'!D6","v":"Piet"},{"$f":"'Overzicht resultaten'!E6","v":"Klaas"},{"$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":"Frits"},{"$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,"gewicht  (0-4)","gewicht  (0-9)",1,{"$f":"F2+1","v":2},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,"Het verslag",null,null,{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},null,null,"x"]
[null,null,"A1. De inleiding en vraagstelling,  de leerling…..",null,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,"x"]
[1,1,"heeft een uitstekende onderzoeksvraag of hypothese geformuleerd die aan alle eisen voldoet.",1,null,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,{"$f":"IF(AND(D5>0,$E$4>0),\"x\",0)","v":"x"}]
[2,2,"heeft een beredeneerde keuze gemaakt voor een beschrijvende, vergelijkende, verklarende, voorspellende of evaluatieve hoofdvraag. ",0]
[3,3,"heeft een onderzoekbare en haalbare onderzoeksvraag of hypothese geformuleerd. ",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(AND(D7>0,$E$4>0),\"x\",0)","v":0}]
[4,4,"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,0]
[5,5,"heeft een onderzoeksvraag/hypothese geformuleerd waarin een beroep gedaan wordt op historische 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]
[6,6,"heeft een uitstekende selectie van bronnen gemaakt.",1,null,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,"x"]
[7,7,"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]
[8,8,"heeft relevante bronnen gekozen.",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,"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]
[10,10,"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]
[11,11,"heeft oog voor het verschil tussen primaire en secundaire 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]
[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]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$16)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$16*F5:F16)*100/(Agendalijst!F4*SUM($D$5:$D$16))))","v":100},{"$f":"IF(AND(SUM($D$5:$D$16)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$16*G5:G16)*100/(4*SUM($D$5:$D$16))))","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,{"$f":"IF(E4>0,\"x\",0)","v":"x"}]
[null,null,"A2. De onderzoeksopzet,  de leerling .....",null,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,"x"]
[13,1,"heeft het onderzoek opgezet volgens de sociaal-wetenschappelijke methode.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D19>0,$E$18>0),\"x\",0)","v":"x"}]
[14,2,"laat de opzet en methode van het onderzoek goed aansluiten bij de onderzoeksvraag en deelvragen",0]
[15,3,"heeft het onderzoek logisch opgezet",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D21>0,$E$18>0),\"x\",0)","v":0}]
[16,4,"heeft het onderzoek opgezet volgens wetenschappelijke criteria.",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,5,"heeft gezorgd voor een onderzoek met voldoende diepgang.",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,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,5,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*F19:F24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":100},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*G19:G24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*H19:H24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*I19:I24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*J19:J24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*K19:K24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*L19:L24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*M19:M24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*N19:N24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*O19:O24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*P19:P24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*Q19:Q24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*R19:R24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*S19:S24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*T19:T24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*U19:U24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*V19:V24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*W19:W24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*X19:X24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*Y19:Y24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*Z19:Z24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AA19:AA24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":125},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AB19:AB24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AC19:AC24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AD19:AD24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AE19:AE24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AF19:AF24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AG19:AG24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AH19:AH24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AI19:AI24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AJ19:AJ24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$24)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$24*AK19:AK24)*100/(Agendalijst!$F$4*SUM($D$19:$D$24))),0)","v":0},null,null,{"$f":"IF(E18>0,\"x\",0)","v":"x"}]
[null,null,"A3. De (beschrijving van de) uitvoering, de leerling ......",null,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,"x"]
[19,1,"heeft op adequate wijze relevante informatie verzameld",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D27>0,$E$26>0),\"x\",0)","v":"x"}]
[20,2,"ging bij het verwerven van informatie planmatig te werk.",0]
[21,3,"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,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D29>0,$E$26>0),\"x\",0)","v":0}]
[22,4,"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,4,null,null,null,null,null,null,null,null,null,null,null,null,0]
[23,5,"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]
[24,6,"heeft de gebruikte informatie, indien nodig, beoordeeld op representativiteit.",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]
[25,7,"hefet de gevonden informatie op adequate wijze verwerkt.",1,null,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,"x"]
[26,8,"heeft de informatie op adequate wijze wijze geordend.",{"$f":"D343","v":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":"A34+1","v":27},9,"heeft op een adequate wijze gebruik gemaakt van 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]
[28,10,"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]
[29,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,null,{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*F27:F37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":100},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*G27:G37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*H27:H37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*I27:I37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*J27:J37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*K27:K37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*L27:L37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*M27:M37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*N27:N37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*O27:O37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*P27:P37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*Q27:Q37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*R27:R37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*S27:S37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*T27:T37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*U27:U37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*V27:V37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*W27:W37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*X27:X37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*Y27:Y37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*Z27:Z37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AA27:AA37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":50},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AB27:AB37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AC27:AC37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AD27:AD37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AE27:AE37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AF27:AF37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AG27:AG37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AH27:AH37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AI27:AI37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AJ27:AJ37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},{"$f":"IF(AND(SUM($D$27:$D$37)>0,$E$26>0),VALUE(SUMPRODUCT($D$27:$D$37*AK27:AK37)*100/(Agendalijst!$F$4*SUM($D$27:$D$37))),0)","v":0},null,null,{"$f":"IF(E26>0,\"x\",0)","v":"x"}]
[null,null,"A4. Presentatie (verslag) van de resultaten, de leerling ....",null,6,null,null,null,null,null,null,null,null,null,null,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"]
[30,1,"heeft op adequate wijze verslag gedaan van de resultaten van het onderzoek",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D40>0,$E$39>0),\"x\",0)","v":"x"}]
[31,2,"heeft zorggedragen voor een duidelijke lijn in het verslag (zorgvuldig, helder en logisch opgeschreven, zonder overbodige informatie of herhaling)",0]
[32,3,"heeft een verslag gemaakt met een logische 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,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D42>0,$E$39>0),\"x\",0)","v":0}]
[33,4,"heeft een goede inleiding geschreven (met een probleemstelling, theoretisch kader, onderzoeks/ontwerpvragen, etc.).",0]
[34,5,"heeft functioneel gebruik gemaakt van illustraties, tabellen en grafieken",0]
[35,6,"heeft een afdoende antwoord gegeven op hoofd- en deelvragen of de hypothese afdoende onderbouwd of weerlegd.",0]
[36,7,"heeft zijn conclusies met argumenten onderbouwd.",0]
[37,8,"heeft bij het schrijven rekening gehouden met de doelgroep.",0]
[38,9,"heeft plagiaat vermeden.",0]
[39,10,"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,4,null,null,null,null,null,null,null,null,null,null,null,null,0]
[40,11,"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]
[41,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,null,{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*F40:F51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":100},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*G40:G51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*H40:H51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*I40:I51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*J40:J51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*K40:K51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*L40:L51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*M40:M51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*N40:N51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*O40:O51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*P40:P51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*Q40:Q51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*R40:R51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*S40:S51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*T40:T51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*U40:U51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*V40:V51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*W40:W51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*X40:X51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*Y40:Y51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*Z40:Z51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AA40:AA51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":100},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AB40:AB51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AC40:AC51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AD40:AD51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AE40:AE51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AF40:AF51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AG40:AG51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AH40:AH51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AI40:AI51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AJ40:AJ51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},{"$f":"IF(AND(SUM($D$40:$D$51)>0,$E$39>0),VALUE(SUMPRODUCT($D$40:$D$51*AK40:AK51)*100/(Agendalijst!$F$4*SUM($D$40:$D$51))),0)","v":0},null,null,{"$f":"IF(E39>0,\"x\",0)","v":"x"}]
[null,null,"A5. Evaluatie/discussie, de leerling .....",null,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,"x"]
[42,1,"heeft het onderzoeksproces geëvalueerd ",1,null,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,{"$f":"IF(AND(D54>0,$E$53>0),\"x\",0)","v":"x"}]
[43,2,"heeft aandacht besteed aan de goede en zwakke punten van het onderzoeksproces",0]
[44,3,"heeft verbeterpunten voor de uitvoering van het onderzoek beschreven",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D56>0,$E$53>0),\"x\",0)","v":0}]
[45,4,"heeft het resultaat van het onderzoek geëvalueerd",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[46,5,"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]
[47,6,"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]
[48,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]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*F54:F60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":100},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*G54:G60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*H54:H60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*I54:I60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*J54:J60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*K54:K60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*L54:L60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*M54:M60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*N54:N60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*O54:O60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*P54:P60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*Q54:Q60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*R54:R60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*S54:S60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*T54:T60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*U54:U60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*V54:V60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*W54:W60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*X54:X60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*Y54:Y60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*Z54:Z60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AA54:AA60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":62.5},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AB54:AB60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AC54:AC60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AD54:AD60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AE54:AE60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AF54:AF60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AG54:AG60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AH54:AH60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AI54:AI60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AJ54:AJ60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},{"$f":"IF(AND(SUM($D$54:$D$60)>0,$E$53>0),VALUE(SUMPRODUCT($D$54:$D$60*AK54:AK60)*100/(Agendalijst!$F$4*SUM($D$54:$D$60))),0)","v":0},null,null,{"$f":"IF(E53>0,\"x\",0)","v":"x"}]
[null,null,"A6. Taalgebruik, de leerling ....",null,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,"x"]
[49,1,"heeft een verslag gemaakt waar taalkundig weinig op aan te merken is.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D63>0,$E$62>0),\"x\",0)","v":"x"}]
[50,2,"heeft gekozen voor begrijpelijk taalgebruik, afgestemd op de beoogde doelgroep",0]
[51,3,"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,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D65>0,$E$62>0),\"x\",0)","v":0}]
[52,4,"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,5,null,null,null,null,null,null,null,null,null,null,null,null,0]
[53,5,"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]
[54,6,"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]
[{"$f":"A68+1","v":55},7,"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]
[56,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,null,{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*F63:F70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":100},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*G63:G70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*H63:H70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*I63:I70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*J63:J70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*K63:K70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*L63:L70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*M63:M70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*N63:N70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*O63:O70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*P63:P70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*Q63:Q70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*R63:R70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*S63:S70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*T63:T70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*U63:U70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*V63:V70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*W63:W70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*X63:X70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*Y63:Y70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*Z63:Z70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AA63:AA70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":125},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AB63:AB70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AC63:AC70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AD63:AD70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AE63:AE70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AF63:AF70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AG63:AG70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AH63:AH70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AI63:AI70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AJ63:AJ70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},{"$f":"IF(AND(SUM($D$63:$D$70)>0,$E$62>0),VALUE(SUMPRODUCT($D$63:$D$70*AK63:AK70)*100/(Agendalijst!$F$4*SUM($D$63:$D$70))),0)","v":0},null,null,{"$f":"IF(E62>0,\"x\",0)","v":"x"}]

{"sheet":"Beoord Proces","index":3,"n_rows":36,"n_cols":40,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"Jan"},{"$f":"'Overzicht resultaten'!D6","v":"Piet"},{"$f":"'Overzicht resultaten'!E6","v":"Klaas"},{"$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":"Frits"},{"$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,"gewicht (0-4)","gewicht  (0-9)",1,{"$f":"F2+1","v":2},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,"Het proces",null,null,{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},null,null,"x"]
[null,null,"de houding en creativiteit, de leerling .....",null,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,{"$f":"IF(D2>0,\"x\",0)","v":"x"}]
[57,1,"heeft blijk gegeven van een goede houding en creativiteit getoond.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[58,2,"toont de wil om te weten, toont initiatief",0]
[59,3,"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]
[60,4,"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]
[61,5,"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]
[62,6,"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]
[63,7,"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]
[64,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, de 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"]
[65,9,"heeft zich gehouden aan de planning.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14>0,\"x\",0)","v":"x"}]
[66,10,"plant duidelijke en realistische stappen ",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]
[67,11,"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":"A16+1","v":68},12,"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]
[69,13,"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]
[70,14,"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]
[71,15,"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]
[72,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, de 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,17,"heeft zelfstandig gewerkt en goed samengewerkt.",1,null,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,{"$f":"IF(D23>0,\"x\",0)","v":"x"}]
[74,18,"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,0]
[75,19,"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":"A25+1","v":76},20,"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]
[{"$f":"A26+1","v":77},21,"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]
[{"$f":"A27+1","v":78},22,"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]
[{"$f":"A28+1","v":79},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, de 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"]
[80,24,"heeft uitstekend gereflecteerd op inhoud en proces.",1,null,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,{"$f":"IF(D31>0,\"x\",0)","v":"x"}]
[81,25,"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,{"$f":"IF(D32>0,\"x\",0)","v":0}]
[82,26,"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,{"$f":"IF(D33>0,\"x\",0)","v":0}]
[{"$f":"A33+1","v":83},27,"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,{"$f":"IF(D34>0,\"x\",0)","v":0}]
[{"$f":"A34+1","v":84},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,{"$f":"IF(D35>0,\"x\",0)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*F5:F35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":100},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*G5:G35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*H5:H35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*I5:I35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*J5:J35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*K5:K35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*L5:L35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*M5:M35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*N5:N35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*O5:O35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*P5:P35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*Q5:Q35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*R5:R35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*S5:S35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*T5:T35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*U5:U35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*V5:V35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*W5:W35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*X5:X35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*Y5:Y35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*Z5:Z35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AA5:AA35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":50},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AB5:AB35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AC5:AC35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AD5:AD35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AE5:AE35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AF5:AF35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AG5:AG35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AH5:AH35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AI5:AI35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AJ5:AJ35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$35)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$35*AK5:AK35)*100/(Agendalijst!$F$4*SUM($D$5:$D$35))),0)","v":0},null,null,"x"]

{"sheet":"Beoord Werkplan","index":4,"n_rows":19,"n_cols":40,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"Jan"},{"$f":"'Overzicht resultaten'!D6","v":"Piet"},{"$f":"'Overzicht resultaten'!E6","v":"Klaas"},{"$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":"Frits"},{"$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,"gewicht  (0-4)","gewicht  (0-9)",1,{"$f":"F2+1","v":2},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,"Het werkplan",null,null,{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},null,null,"x"]
[null,null,"het inhoudelijk kader, de leerling ....",null,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,"x"]
[85,1,"heeft het onderzoek goed voorbereid zoals valt af te leiden uit het werkplan.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[86,2,"beschrijft de aanleiding van het onderzoek",0]
[87,3,"beschrijft de onderzoeksvraag en deelvragen",0]
[88,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,{"$f":"IF(D8>0,\"x\",0)","v":0}]
[89,null,"de aanpak van het onderzoek, de 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"]
[90,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,{"$f":"IF(D10>0,\"x\",0)","v":0}]
[{"$f":"A10+1","v":91},6,"beschrijft beperkingen 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,{"$f":"IF(D11>0,\"x\",0)","v":0}]
[{"$f":"A11+1","v":92},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,{"$f":"IF(D12>0,\"x\",0)","v":0}]
[{"$f":"A12+1","v":93},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,{"$f":"IF(D13>0,\"x\",0)","v":0}]
[94,null,"werkvoorbereiding,  de 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"]
[95,9,"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,{"$f":"IF(D15>0,\"x\",0)","v":0}]
[{"$f":"A15+1","v":96},10,"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,{"$f":"IF(D16>0,\"x\",0)","v":0}]
[{"$f":"A16+1","v":97},11,"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,{"$f":"IF(D17>0,\"x\",0)","v":0}]
[98,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,{"$f":"IF(D18>0,\"x\",0)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*F5:F18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":100},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*G5:G18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*H5:H18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*I5:I18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*J5:J18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*K5:K18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*L5:L18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*M5:M18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*N5:N18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*O5:O18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*P5:P18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*Q5:Q18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*R5:R18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*S5:S18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*T5:T18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*U5:U18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*V5:V18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*W5:W18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*X5:X18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*Y5:Y18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*Z5:Z18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AA5:AA18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":75},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AB5:AB18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AC5:AC18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AD5:AD18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AE5:AE18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AF5:AF18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AG5:AG18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AH5:AH18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AI5:AI18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AJ5:AJ18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$18)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$18*AK5:AK18)*100/(Agendalijst!$F$4*SUM($D$5:$D$18))),0)","v":0},null,null,"x"]

{"sheet":"Beoord Logboek","index":5,"n_rows":11,"n_cols":40,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"Jan"},{"$f":"'Overzicht resultaten'!D6","v":"Piet"},{"$f":"'Overzicht resultaten'!E6","v":"Klaas"},{"$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":"Frits"},{"$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,"gewicht  (0-4)","gewicht  (0-9)",1,{"$f":"F2+1","v":2},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,"Het logboek",null,null,{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},{"$f":"Agendalijst!$F$4","v":4},null,null,"x"]
[null,null,"Het logboek, de leerling ....",null,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,"x"]
[99,1,"heeft ervoor gezorgd dat het logboek inzicht geeft in het verloop van het onderzoek, de verzameling van de gegevens en de verslaglegging",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[{"$f":"A5+1","v":100},2,"heeft verslag gedaan van het verloop 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,{"$f":"IF(D6>0,\"x\",0)","v":0}]
[101,3,"heeft verslag gedaan van de wijze waarop gegevens zijn verzameld",0]
[102,4,"heeft in het logboek beschreven wat hij leert door te reflecteren op de inhoud van het onderzoek",0]
[103,5,"heeft in het logboek beschreven wat hij leert door te reflecteren 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,{"$f":"IF(D9>0,\"x\",0)","v":0}]
[104,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,{"$f":"IF(D10>0,\"x\",0)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*F5:F10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":100},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*G5:G10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*H5:H10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*I5:I10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*J5:J10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*K5:K10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*L5:L10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*M5:M10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*N5:N10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*O5:O10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*P5:P10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*Q5:Q10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*R5:R10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*S5:S10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*T5:T10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*U5:U10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*V5:V10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*W5:W10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*X5:X10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*Y5:Y10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*Z5:Z10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AA5:AA10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":75},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AB5:AB10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AC5:AC10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AD5:AD10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AE5:AE10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AF5:AF10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AG5:AG10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AH5:AH10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AI5:AI10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AJ5:AJ10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$10)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$10*AK5:AK10)*100/(Agendalijst!$F$4*SUM($D$5:$D$10))),0)","v":0},null,null,"x"]

{"sheet":"Overzicht resultaten","index":6,"n_rows":27,"n_cols":36,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,4,1],[26,4,28,5],[26,2,28,3]]}
[]
[]
["Overzicht resultaten: hier 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":"Jan"},{"$f":"IF(Agendalijst!B6=\"\",\"\",Agendalijst!B6)","v":"Piet"},{"$f":"IF(Agendalijst!B7=\"\",\"\",Agendalijst!B7)","v":"Klaas"},{"$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":"Frits"},{"$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":"'Beoord Verslag'!E4","v":1},"Inleiding/vraagstelling",{"$f":"IF(AND($A7>0,C6<>\"\"),'Beoord Verslag'!F17,\"\")","v":100},{"$f":"IF(AND($A7>0,D6<>\"\"),'Beoord Verslag'!G17,\"\")","v":0},{"$f":"IF(AND($A7>0,E6<>\"\"),'Beoord Verslag'!H17,\"\")","v":0},{"$f":"IF(AND($A7>0,F6<>\"\"),'Beoord Verslag'!I17,\"\")","v":""},{"$f":"IF(AND($A7>0,G6<>\"\"),'Beoord Verslag'!J17,\"\")","v":""},{"$f":"IF(AND($A7>0,H6<>\"\"),'Beoord Verslag'!K17,\"\")","v":""},{"$f":"IF(AND($A7>0,I6<>\"\"),'Beoord Verslag'!L17,\"\")","v":""},{"$f":"IF(AND($A7>0,J6<>\"\"),'Beoord Verslag'!M17,\"\")","v":""},{"$f":"IF(AND($A7>0,K6<>\"\"),'Beoord Verslag'!N17,\"\")","v":""},{"$f":"IF(AND($A7>0,L6<>\"\"),'Beoord Verslag'!O17,\"\")","v":""},{"$f":"IF(AND($A7>0,M6<>\"\"),'Beoord Verslag'!P17,\"\")","v":""},{"$f":"IF(AND($A7>0,N6<>\"\"),'Beoord Verslag'!Q17,\"\")","v":""},{"$f":"IF(AND($A7>0,O6<>\"\"),'Beoord Verslag'!R17,\"\")","v":""},{"$f":"IF(AND($A7>0,P6<>\"\"),'Beoord Verslag'!S17,\"\")","v":""},{"$f":"IF(AND($A7>0,Q6<>\"\"),'Beoord Verslag'!T17,\"\")","v":""},{"$f":"IF(AND($A7>0,R6<>\"\"),'Beoord Verslag'!U17,\"\")","v":""},{"$f":"IF(AND($A7>0,S6<>\"\"),'Beoord Verslag'!V17,\"\")","v":""},{"$f":"IF(AND($A7>0,T6<>\"\"),'Beoord Verslag'!W17,\"\")","v":""},{"$f":"IF(AND($A7>0,U6<>\"\"),'Beoord Verslag'!X17,\"\")","v":""},{"$f":"IF(AND($A7>0,V6<>\"\"),'Beoord Verslag'!Y17,\"\")","v":""},{"$f":"IF(AND($A7>0,W6<>\"\"),'Beoord Verslag'!Z17,\"\")","v":""},{"$f":"IF(AND($A7>0,X6<>\"\"),'Beoord Verslag'!AA17,\"\")","v":0},{"$f":"IF(AND($A7>0,Y6<>\"\"),'Beoord Verslag'!AB17,\"\")","v":""},{"$f":"IF(AND($A7>0,Z6<>\"\"),'Beoord Verslag'!AC17,\"\")","v":""},{"$f":"IF(AND($A7>0,AA6<>\"\"),'Beoord Verslag'!AD17,\"\")","v":""},{"$f":"IF(AND($A7>0,AB6<>\"\"),'Beoord Verslag'!AE17,\"\")","v":""},{"$f":"IF(AND($A7>0,AC6<>\"\"),'Beoord Verslag'!AF17,\"\")","v":""},{"$f":"IF(AND($A7>0,AD6<>\"\"),'Beoord Verslag'!AG17,\"\")","v":""},{"$f":"IF(AND($A7>0,AE6<>\"\"),'Beoord Verslag'!AH17,\"\")","v":""},{"$f":"IF(AND($A7>0,AF6<>\"\"),'Beoord Verslag'!AI17,\"\")","v":""},{"$f":"IF(AND($A7>0,AG6<>\"\"),'Beoord Verslag'!AJ17,\"\")","v":""},{"$f":"IF(AND($A7>0,AH6<>\"\"),'Beoord Verslag'!AK17,\"\")","v":""},null,{"$f":"IF(A7>0,AVERAGE(C7:AH7),\"-\")","v":25}]
[{"$f":"'Beoord Verslag'!E18","v":1},"Onderzoeksopzet",{"$f":"IF(AND($A8>0,C6<>\"\"),'Beoord Verslag'!F25,\"\")","v":100},{"$f":"IF(AND($A8>0,D6<>\"\"),'Beoord Verslag'!G25,\"\")","v":0},{"$f":"IF(AND($A8>0,E6<>\"\"),'Beoord Verslag'!H25,\"\")","v":0},{"$f":"IF(AND($A8>0,F6<>\"\"),'Beoord Verslag'!I25,\"\")","v":""},{"$f":"IF(AND($A8>0,G6<>\"\"),'Beoord Verslag'!J25,\"\")","v":""},{"$f":"IF(AND($A8>0,H6<>\"\"),'Beoord Verslag'!K25,\"\")","v":""},{"$f":"IF(AND($A8>0,I6<>\"\"),'Beoord Verslag'!L25,\"\")","v":""},{"$f":"IF(AND($A8>0,J6<>\"\"),'Beoord Verslag'!M25,\"\")","v":""},{"$f":"IF(AND($A8>0,K6<>\"\"),'Beoord Verslag'!N25,\"\")","v":""},{"$f":"IF(AND($A8>0,L6<>\"\"),'Beoord Verslag'!O25,\"\")","v":""},{"$f":"IF(AND($A8>0,M6<>\"\"),'Beoord Verslag'!P25,\"\")","v":""},{"$f":"IF(AND($A8>0,N6<>\"\"),'Beoord Verslag'!Q25,\"\")","v":""},{"$f":"IF(AND($A8>0,O6<>\"\"),'Beoord Verslag'!R25,\"\")","v":""},{"$f":"IF(AND($A8>0,P6<>\"\"),'Beoord Verslag'!S25,\"\")","v":""},{"$f":"IF(AND($A8>0,Q6<>\"\"),'Beoord Verslag'!T25,\"\")","v":""},{"$f":"IF(AND($A8>0,R6<>\"\"),'Beoord Verslag'!U25,\"\")","v":""},{"$f":"IF(AND($A8>0,S6<>\"\"),'Beoord Verslag'!V25,\"\")","v":""},{"$f":"IF(AND($A8>0,T6<>\"\"),'Beoord Verslag'!W25,\"\")","v":""},{"$f":"IF(AND($A8>0,U6<>\"\"),'Beoord Verslag'!X25,\"\")","v":""},{"$f":"IF(AND($A8>0,V6<>\"\"),'Beoord Verslag'!Y25,\"\")","v":""},{"$f":"IF(AND($A8>0,W6<>\"\"),'Beoord Verslag'!Z25,\"\")","v":""},{"$f":"IF(AND($A8>0,X6<>\"\"),'Beoord Verslag'!AA25,\"\")","v":125},{"$f":"IF(AND($A8>0,Y6<>\"\"),'Beoord Verslag'!AB25,\"\")","v":""},{"$f":"IF(AND($A8>0,Z6<>\"\"),'Beoord Verslag'!AC25,\"\")","v":""},{"$f":"IF(AND($A8>0,AA6<>\"\"),'Beoord Verslag'!AD25,\"\")","v":""},{"$f":"IF(AND($A8>0,AB6<>\"\"),'Beoord Verslag'!AE25,\"\")","v":""},{"$f":"IF(AND($A8>0,AC6<>\"\"),'Beoord Verslag'!AF25,\"\")","v":""},{"$f":"IF(AND($A8>0,AD6<>\"\"),'Beoord Verslag'!AG25,\"\")","v":""},{"$f":"IF(AND($A8>0,AE6<>\"\"),'Beoord Verslag'!AH25,\"\")","v":""},{"$f":"IF(AND($A8>0,AF6<>\"\"),'Beoord Verslag'!AI25,\"\")","v":""},{"$f":"IF(AND($A8>0,AG6<>\"\"),'Beoord Verslag'!AJ25,\"\")","v":""},{"$f":"IF(AND($A8>0,AH6<>\"\"),'Beoord Verslag'!AK25,\"\")","v":""},null,{"$f":"IF(A8>0,AVERAGE(C8:AH8),\"-\")","v":56.25}]
[{"$f":"'Beoord Verslag'!E26","v":1},"Uitvoering",{"$f":"IF(AND($A9>0,C6<>\"\"),'Beoord Verslag'!F38,\"\")","v":100},{"$f":"IF(AND($A9>0,D6<>\"\"),'Beoord Verslag'!G38,\"\")","v":0},{"$f":"IF(AND($A9>0,E6<>\"\"),'Beoord Verslag'!H38,\"\")","v":0},{"$f":"IF(AND($A9>0,F6<>\"\"),'Beoord Verslag'!I38,\"\")","v":""},{"$f":"IF(AND($A9>0,G6<>\"\"),'Beoord Verslag'!J38,\"\")","v":""},{"$f":"IF(AND($A9>0,H6<>\"\"),'Beoord Verslag'!K38,\"\")","v":""},{"$f":"IF(AND($A9>0,I6<>\"\"),'Beoord Verslag'!L38,\"\")","v":""},{"$f":"IF(AND($A9>0,J6<>\"\"),'Beoord Verslag'!M38,\"\")","v":""},{"$f":"IF(AND($A9>0,K6<>\"\"),'Beoord Verslag'!N38,\"\")","v":""},{"$f":"IF(AND($A9>0,L6<>\"\"),'Beoord Verslag'!O38,\"\")","v":""},{"$f":"IF(AND($A9>0,M6<>\"\"),'Beoord Verslag'!P38,\"\")","v":""},{"$f":"IF(AND($A9>0,N6<>\"\"),'Beoord Verslag'!Q38,\"\")","v":""},{"$f":"IF(AND($A9>0,O6<>\"\"),'Beoord Verslag'!R38,\"\")","v":""},{"$f":"IF(AND($A9>0,P6<>\"\"),'Beoord Verslag'!S38,\"\")","v":""},{"$f":"IF(AND($A9>0,Q6<>\"\"),'Beoord Verslag'!T38,\"\")","v":""},{"$f":"IF(AND($A9>0,R6<>\"\"),'Beoord Verslag'!U38,\"\")","v":""},{"$f":"IF(AND($A9>0,S6<>\"\"),'Beoord Verslag'!V38,\"\")","v":""},{"$f":"IF(AND($A9>0,T6<>\"\"),'Beoord Verslag'!W38,\"\")","v":""},{"$f":"IF(AND($A9>0,U6<>\"\"),'Beoord Verslag'!X38,\"\")","v":""},{"$f":"IF(AND($A9>0,V6<>\"\"),'Beoord Verslag'!Y38,\"\")","v":""},{"$f":"IF(AND($A9>0,W6<>\"\"),'Beoord Verslag'!Z38,\"\")","v":""},{"$f":"IF(AND($A9>0,X6<>\"\"),'Beoord Verslag'!AA38,\"\")","v":50},{"$f":"IF(AND($A9>0,Y6<>\"\"),'Beoord Verslag'!AB38,\"\")","v":""},{"$f":"IF(AND($A9>0,Z6<>\"\"),'Beoord Verslag'!AC38,\"\")","v":""},{"$f":"IF(AND($A9>0,AA6<>\"\"),'Beoord Verslag'!AD38,\"\")","v":""},{"$f":"IF(AND($A9>0,AB6<>\"\"),'Beoord Verslag'!AE38,\"\")","v":""},{"$f":"IF(AND($A9>0,AC6<>\"\"),'Beoord Verslag'!AF38,\"\")","v":""},{"$f":"IF(AND($A9>0,AD6<>\"\"),'Beoord Verslag'!AG38,\"\")","v":""},{"$f":"IF(AND($A9>0,AE6<>\"\"),'Beoord Verslag'!AH38,\"\")","v":""},{"$f":"IF(AND($A9>0,AF6<>\"\"),'Beoord Verslag'!AI38,\"\")","v":""},{"$f":"IF(AND($A9>0,AG6<>\"\"),'Beoord Verslag'!AJ38,\"\")","v":""},{"$f":"IF(AND($A9>0,AH6<>\"\"),'Beoord Verslag'!AK38,\"\")","v":""},null,37.5]
[{"$f":"'Beoord Verslag'!E39","v":6},"Conclusie",{"$f":"IF(AND($A10>0,C6<>\"\"),'Beoord Verslag'!F52,\"\")","v":100},{"$f":"IF(AND($A10>0,D6<>\"\"),'Beoord Verslag'!G52,\"\")","v":0},{"$f":"IF(AND($A10>0,E6<>\"\"),'Beoord Verslag'!H52,\"\")","v":0},{"$f":"IF(AND($A10>0,F6<>\"\"),'Beoord Verslag'!I52,\"\")","v":""},{"$f":"IF(AND($A10>0,G6<>\"\"),'Beoord Verslag'!J52,\"\")","v":""},{"$f":"IF(AND($A10>0,H6<>\"\"),'Beoord Verslag'!K52,\"\")","v":""},{"$f":"IF(AND($A10>0,I6<>\"\"),'Beoord Verslag'!L52,\"\")","v":""},{"$f":"IF(AND($A10>0,J6<>\"\"),'Beoord Verslag'!M52,\"\")","v":""},{"$f":"IF(AND($A10>0,K6<>\"\"),'Beoord Verslag'!N52,\"\")","v":""},{"$f":"IF(AND($A10>0,L6<>\"\"),'Beoord Verslag'!O52,\"\")","v":""},{"$f":"IF(AND($A10>0,M6<>\"\"),'Beoord Verslag'!P52,\"\")","v":""},{"$f":"IF(AND($A10>0,N6<>\"\"),'Beoord Verslag'!Q52,\"\")","v":""},{"$f":"IF(AND($A10>0,O6<>\"\"),'Beoord Verslag'!R52,\"\")","v":""},{"$f":"IF(AND($A10>0,P6<>\"\"),'Beoord Verslag'!S52,\"\")","v":""},{"$f":"IF(AND($A10>0,Q6<>\"\"),'Beoord Verslag'!T52,\"\")","v":""},{"$f":"IF(AND($A10>0,R6<>\"\"),'Beoord Verslag'!U52,\"\")","v":""},{"$f":"IF(AND($A10>0,S6<>\"\"),'Beoord Verslag'!V52,\"\")","v":""},{"$f":"IF(AND($A10>0,T6<>\"\"),'Beoord Verslag'!W52,\"\")","v":""},{"$f":"IF(AND($A10>0,U6<>\"\"),'Beoord Verslag'!X52,\"\")","v":""},{"$f":"IF(AND($A10>0,V6<>\"\"),'Beoord Verslag'!Y52,\"\")","v":""},{"$f":"IF(AND($A10>0,W6<>\"\"),'Beoord Verslag'!Z52,\"\")","v":""},{"$f":"IF(AND($A10>0,X6<>\"\"),'Beoord Verslag'!AA52,\"\")","v":100},{"$f":"IF(AND($A10>0,Y6<>\"\"),'Beoord Verslag'!AB52,\"\")","v":""},{"$f":"IF(AND($A10>0,Z6<>\"\"),'Beoord Verslag'!AC52,\"\")","v":""},{"$f":"IF(AND($A10>0,AA6<>\"\"),'Beoord Verslag'!AD52,\"\")","v":""},{"$f":"IF(AND($A10>0,AB6<>\"\"),'Beoord Verslag'!AE52,\"\")","v":""},{"$f":"IF(AND($A10>0,AC6<>\"\"),'Beoord Verslag'!AF52,\"\")","v":""},{"$f":"IF(AND($A10>0,AD6<>\"\"),'Beoord Verslag'!AG52,\"\")","v":""},{"$f":"IF(AND($A10>0,AE6<>\"\"),'Beoord Verslag'!AH52,\"\")","v":""},{"$f":"IF(AND($A10>0,AF6<>\"\"),'Beoord Verslag'!AI52,\"\")","v":""},{"$f":"IF(AND($A10>0,AG6<>\"\"),'Beoord Verslag'!AJ52,\"\")","v":""},{"$f":"IF(AND($A10>0,AH6<>\"\"),'Beoord Verslag'!AK52,\"\")","v":""},null,50]
[{"$f":"'Beoord Verslag'!E53","v":1},"Evaluatie/discussie",{"$f":"IF(AND($A11>0,C6<>\"\"),'Beoord Verslag'!F61,\"\")","v":100},{"$f":"IF(AND($A11>0,D6<>\"\"),'Beoord Verslag'!G61,\"\")","v":0},{"$f":"IF(AND($A11>0,E6<>\"\"),'Beoord Verslag'!H61,\"\")","v":0},{"$f":"IF(AND($A11>0,F6<>\"\"),'Beoord Verslag'!I61,\"\")","v":""},{"$f":"IF(AND($A11>0,G6<>\"\"),'Beoord Verslag'!J61,\"\")","v":""},{"$f":"IF(AND($A11>0,H6<>\"\"),'Beoord Verslag'!K61,\"\")","v":""},{"$f":"IF(AND($A11>0,I6<>\"\"),'Beoord Verslag'!L61,\"\")","v":""},{"$f":"IF(AND($A11>0,J6<>\"\"),'Beoord Verslag'!M61,\"\")","v":""},{"$f":"IF(AND($A11>0,K6<>\"\"),'Beoord Verslag'!N61,\"\")","v":""},{"$f":"IF(AND($A11>0,L6<>\"\"),'Beoord Verslag'!O61,\"\")","v":""},{"$f":"IF(AND($A11>0,M6<>\"\"),'Beoord Verslag'!P61,\"\")","v":""},{"$f":"IF(AND($A11>0,N6<>\"\"),'Beoord Verslag'!Q61,\"\")","v":""},{"$f":"IF(AND($A11>0,O6<>\"\"),'Beoord Verslag'!R61,\"\")","v":""},{"$f":"IF(AND($A11>0,P6<>\"\"),'Beoord Verslag'!S61,\"\")","v":""},{"$f":"IF(AND($A11>0,Q6<>\"\"),'Beoord Verslag'!T61,\"\")","v":""},{"$f":"IF(AND($A11>0,R6<>\"\"),'Beoord Verslag'!U61,\"\")","v":""},{"$f":"IF(AND($A11>0,S6<>\"\"),'Beoord Verslag'!V61,\"\")","v":""},{"$f":"IF(AND($A11>0,T6<>\"\"),'Beoord Verslag'!W61,\"\")","v":""},{"$f":"IF(AND($A11>0,U6<>\"\"),'Beoord Verslag'!X61,\"\")","v":""},{"$f":"IF(AND($A11>0,V6<>\"\"),'Beoord Verslag'!Y61,\"\")","v":""},{"$f":"IF(AND($A11>0,W6<>\"\"),'Beoord Verslag'!Z61,\"\")","v":""},{"$f":"IF(AND($A11>0,X6<>\"\"),'Beoord Verslag'!AA61,\"\")","v":62.5},{"$f":"IF(AND($A11>0,Y6<>\"\"),'Beoord Verslag'!AB61,\"\")","v":""},{"$f":"IF(AND($A11>0,Z6<>\"\"),'Beoord Verslag'!AC61,\"\")","v":""},{"$f":"IF(AND($A11>0,AA6<>\"\"),'Beoord Verslag'!AD61,\"\")","v":""},{"$f":"IF(AND($A11>0,AB6<>\"\"),'Beoord Verslag'!AE61,\"\")","v":""},{"$f":"IF(AND($A11>0,AC6<>\"\"),'Beoord Verslag'!AF61,\"\")","v":""},{"$f":"IF(AND($A11>0,AD6<>\"\"),'Beoord Verslag'!AG61,\"\")","v":""},{"$f":"IF(AND($A11>0,AE6<>\"\"),'Beoord Verslag'!AH61,\"\")","v":""},{"$f":"IF(AND($A11>0,AF6<>\"\"),'Beoord Verslag'!AI61,\"\")","v":""},{"$f":"IF(AND($A11>0,AG6<>\"\"),'Beoord Verslag'!AJ61,\"\")","v":""},{"$f":"IF(AND($A11>0,AH6<>\"\"),'Beoord Verslag'!AK61,\"\")","v":""},null,40.625]
[{"$f":"'Beoord Verslag'!E62","v":1},"Structuur, taal, vormgeving",{"$f":"IF(AND($A12>0,C6<>\"\"),'Beoord Verslag'!F71,\"\")","v":100},{"$f":"IF(AND($A12>0,D6<>\"\"),'Beoord Verslag'!G71,\"\")","v":0},{"$f":"IF(AND($A12>0,E6<>\"\"),'Beoord Verslag'!H71,\"\")","v":0},{"$f":"IF(AND($A12>0,F6<>\"\"),'Beoord Verslag'!I71,\"\")","v":""},{"$f":"IF(AND($A12>0,G6<>\"\"),'Beoord Verslag'!J71,\"\")","v":""},{"$f":"IF(AND($A12>0,H6<>\"\"),'Beoord Verslag'!K71,\"\")","v":""},{"$f":"IF(AND($A12>0,I6<>\"\"),'Beoord Verslag'!L71,\"\")","v":""},{"$f":"IF(AND($A12>0,J6<>\"\"),'Beoord Verslag'!M71,\"\")","v":""},{"$f":"IF(AND($A12>0,K6<>\"\"),'Beoord Verslag'!N71,\"\")","v":""},{"$f":"IF(AND($A12>0,L6<>\"\"),'Beoord Verslag'!O71,\"\")","v":""},{"$f":"IF(AND($A12>0,M6<>\"\"),'Beoord Verslag'!P71,\"\")","v":""},{"$f":"IF(AND($A12>0,N6<>\"\"),'Beoord Verslag'!Q71,\"\")","v":""},{"$f":"IF(AND($A12>0,O6<>\"\"),'Beoord Verslag'!R71,\"\")","v":""},{"$f":"IF(AND($A12>0,P6<>\"\"),'Beoord Verslag'!S71,\"\")","v":""},{"$f":"IF(AND($A12>0,Q6<>\"\"),'Beoord Verslag'!T71,\"\")","v":""},{"$f":"IF(AND($A12>0,R6<>\"\"),'Beoord Verslag'!U71,\"\")","v":""},{"$f":"IF(AND($A12>0,S6<>\"\"),'Beoord Verslag'!V71,\"\")","v":""},{"$f":"IF(AND($A12>0,T6<>\"\"),'Beoord Verslag'!W71,\"\")","v":""},{"$f":"IF(AND($A12>0,U6<>\"\"),'Beoord Verslag'!X71,\"\")","v":""},{"$f":"IF(AND($A12>0,V6<>\"\"),'Beoord Verslag'!Y71,\"\")","v":""},{"$f":"IF(AND($A12>0,W6<>\"\"),'Beoord Verslag'!Z71,\"\")","v":""},{"$f":"IF(AND($A12>0,X6<>\"\"),'Beoord Verslag'!AA71,\"\")","v":125},{"$f":"IF(AND($A12>0,Y6<>\"\"),'Beoord Verslag'!AB71,\"\")","v":""},{"$f":"IF(AND($A12>0,Z6<>\"\"),'Beoord Verslag'!AC71,\"\")","v":""},{"$f":"IF(AND($A12>0,AA6<>\"\"),'Beoord Verslag'!AD71,\"\")","v":""},{"$f":"IF(AND($A12>0,AB6<>\"\"),'Beoord Verslag'!AE71,\"\")","v":""},{"$f":"IF(AND($A12>0,AC6<>\"\"),'Beoord Verslag'!AF71,\"\")","v":""},{"$f":"IF(AND($A12>0,AD6<>\"\"),'Beoord Verslag'!AG71,\"\")","v":""},{"$f":"IF(AND($A12>0,AE6<>\"\"),'Beoord Verslag'!AH71,\"\")","v":""},{"$f":"IF(AND($A12>0,AF6<>\"\"),'Beoord Verslag'!AI71,\"\")","v":""},{"$f":"IF(AND($A12>0,AG6<>\"\"),'Beoord Verslag'!AJ71,\"\")","v":""},{"$f":"IF(AND($A12>0,AH6<>\"\"),'Beoord Verslag'!AK71,\"\")","v":""},null,56.25]
[{"$f":"'Beoord Proces'!E4","v":1},"Proces",{"$f":"IF(AND($A$13>0,C6<>\"\"),'Beoord Proces'!F36,\"\")","v":100},{"$f":"IF(AND($A$13>0,D6<>\"\"),'Beoord Proces'!G36,\"\")","v":0},{"$f":"IF(AND($A$13>0,E6<>\"\"),'Beoord Proces'!H36,\"\")","v":0},{"$f":"IF(AND($A$13>0,F6<>\"\"),'Beoord Proces'!I36,\"\")","v":""},{"$f":"IF(AND($A$13>0,G6<>\"\"),'Beoord Proces'!J36,\"\")","v":""},{"$f":"IF(AND($A$13>0,H6<>\"\"),'Beoord Proces'!K36,\"\")","v":""},{"$f":"IF(AND($A$13>0,I6<>\"\"),'Beoord Proces'!L36,\"\")","v":""},{"$f":"IF(AND($A$13>0,J6<>\"\"),'Beoord Proces'!M36,\"\")","v":""},{"$f":"IF(AND($A$13>0,K6<>\"\"),'Beoord Proces'!N36,\"\")","v":""},{"$f":"IF(AND($A$13>0,L6<>\"\"),'Beoord Proces'!O36,\"\")","v":""},{"$f":"IF(AND($A$13>0,M6<>\"\"),'Beoord Proces'!P36,\"\")","v":""},{"$f":"IF(AND($A$13>0,N6<>\"\"),'Beoord Proces'!Q36,\"\")","v":""},{"$f":"IF(AND($A$13>0,O6<>\"\"),'Beoord Proces'!R36,\"\")","v":""},{"$f":"IF(AND($A$13>0,P6<>\"\"),'Beoord Proces'!S36,\"\")","v":""},{"$f":"IF(AND($A$13>0,Q6<>\"\"),'Beoord Proces'!T36,\"\")","v":""},{"$f":"IF(AND($A$13>0,R6<>\"\"),'Beoord Proces'!U36,\"\")","v":""},{"$f":"IF(AND($A$13>0,S6<>\"\"),'Beoord Proces'!V36,\"\")","v":""},{"$f":"IF(AND($A$13>0,T6<>\"\"),'Beoord Proces'!W36,\"\")","v":""},{"$f":"IF(AND($A$13>0,U6<>\"\"),'Beoord Proces'!X36,\"\")","v":""},{"$f":"IF(AND($A$13>0,V6<>\"\"),'Beoord Proces'!Y36,\"\")","v":""},{"$f":"IF(AND($A$13>0,W6<>\"\"),'Beoord Proces'!Z36,\"\")","v":""},{"$f":"IF(AND($A$13>0,X6<>\"\"),'Beoord Proces'!AA36,\"\")","v":50},{"$f":"IF(AND($A$13>0,Y6<>\"\"),'Beoord Proces'!AB36,\"\")","v":""},{"$f":"IF(AND($A$13>0,Z6<>\"\"),'Beoord Proces'!AC36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AA6<>\"\"),'Beoord Proces'!AD36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AB6<>\"\"),'Beoord Proces'!AE36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AC6<>\"\"),'Beoord Proces'!AF36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AD6<>\"\"),'Beoord Proces'!AG36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AE6<>\"\"),'Beoord Proces'!AH36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AF6<>\"\"),'Beoord Proces'!AI36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AG6<>\"\"),'Beoord Proces'!AJ36,\"\")","v":""},{"$f":"IF(AND($A$13>0,AH6<>\"\"),'Beoord Proces'!AK36,\"\")","v":""},null,37.5]
[{"$f":"'Beoord Werkplan'!E4","v":1},"Werkplan",{"$f":"IF(AND($A$14>0,C6<>\"\"),'Beoord Werkplan'!F19,\"\")","v":100},{"$f":"IF(AND($A$14>0,D6<>\"\"),'Beoord Werkplan'!G19,\"\")","v":0},{"$f":"IF(AND($A$14>0,E6<>\"\"),'Beoord Werkplan'!H19,\"\")","v":0},{"$f":"IF(AND($A$14>0,F6<>\"\"),'Beoord Werkplan'!I19,\"\")","v":""},{"$f":"IF(AND($A$14>0,G6<>\"\"),'Beoord Werkplan'!J19,\"\")","v":""},{"$f":"IF(AND($A$14>0,H6<>\"\"),'Beoord Werkplan'!K19,\"\")","v":""},{"$f":"IF(AND($A$14>0,I6<>\"\"),'Beoord Werkplan'!L19,\"\")","v":""},{"$f":"IF(AND($A$14>0,J6<>\"\"),'Beoord Werkplan'!M19,\"\")","v":""},{"$f":"IF(AND($A$14>0,K6<>\"\"),'Beoord Werkplan'!N19,\"\")","v":""},{"$f":"IF(AND($A$14>0,L6<>\"\"),'Beoord Werkplan'!O19,\"\")","v":""},{"$f":"IF(AND($A$14>0,M6<>\"\"),'Beoord Werkplan'!P19,\"\")","v":""},{"$f":"IF(AND($A$14>0,N6<>\"\"),'Beoord Werkplan'!Q19,\"\")","v":""},{"$f":"IF(AND($A$14>0,O6<>\"\"),'Beoord Werkplan'!R19,\"\")","v":""},{"$f":"IF(AND($A$14>0,P6<>\"\"),'Beoord Werkplan'!S19,\"\")","v":""},{"$f":"IF(AND($A$14>0,Q6<>\"\"),'Beoord Werkplan'!T19,\"\")","v":""},{"$f":"IF(AND($A$14>0,R6<>\"\"),'Beoord Werkplan'!U19,\"\")","v":""},{"$f":"IF(AND($A$14>0,S6<>\"\"),'Beoord Werkplan'!V19,\"\")","v":""},{"$f":"IF(AND($A$14>0,T6<>\"\"),'Beoord Werkplan'!W19,\"\")","v":""},{"$f":"IF(AND($A$14>0,U6<>\"\"),'Beoord Werkplan'!X19,\"\")","v":""},{"$f":"IF(AND($A$14>0,V6<>\"\"),'Beoord Werkplan'!Y19,\"\")","v":""},{"$f":"IF(AND($A$14>0,W6<>\"\"),'Beoord Werkplan'!Z19,\"\")","v":""},{"$f":"IF(AND($A$14>0,X6<>\"\"),'Beoord Werkplan'!AA19,\"\")","v":75},{"$f":"IF(AND($A$14>0,Y6<>\"\"),'Beoord Werkplan'!AB19,\"\")","v":""},{"$f":"IF(AND($A$14>0,Z6<>\"\"),'Beoord Werkplan'!AC19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AA6<>\"\"),'Beoord Werkplan'!AD19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AB6<>\"\"),'Beoord Werkplan'!AE19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AC6<>\"\"),'Beoord Werkplan'!AF19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AD6<>\"\"),'Beoord Werkplan'!AG19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AE6<>\"\"),'Beoord Werkplan'!AH19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AF6<>\"\"),'Beoord Werkplan'!AI19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AG6<>\"\"),'Beoord Werkplan'!AJ19,\"\")","v":""},{"$f":"IF(AND($A$14>0,AH6<>\"\"),'Beoord Werkplan'!AK19,\"\")","v":""},null,43.75]
[{"$f":"'Beoord Logboek'!E4","v":1},"Logboek",{"$f":"IF(AND($A$15>0,C6<>\"\"),'Beoord Logboek'!F11,\"\")","v":100},{"$f":"IF(AND($A$15>0,D6<>\"\"),'Beoord Logboek'!G11,\"\")","v":0},{"$f":"IF(AND($A$15>0,E6<>\"\"),'Beoord Logboek'!H11,\"\")","v":0},{"$f":"IF(AND($A$15>0,F6<>\"\"),'Beoord Logboek'!I11,\"\")","v":""},{"$f":"IF(AND($A$15>0,G6<>\"\"),'Beoord Logboek'!J11,\"\")","v":""},{"$f":"IF(AND($A$15>0,H6<>\"\"),'Beoord Logboek'!K11,\"\")","v":""},{"$f":"IF(AND($A$15>0,I6<>\"\"),'Beoord Logboek'!L11,\"\")","v":""},{"$f":"IF(AND($A$15>0,J6<>\"\"),'Beoord Logboek'!M11,\"\")","v":""},{"$f":"IF(AND($A$15>0,K6<>\"\"),'Beoord Logboek'!N11,\"\")","v":""},{"$f":"IF(AND($A$15>0,L6<>\"\"),'Beoord Logboek'!O11,\"\")","v":""},{"$f":"IF(AND($A$15>0,M6<>\"\"),'Beoord Logboek'!P11,\"\")","v":""},{"$f":"IF(AND($A$15>0,N6<>\"\"),'Beoord Logboek'!Q11,\"\")","v":""},{"$f":"IF(AND($A$15>0,O6<>\"\"),'Beoord Logboek'!R11,\"\")","v":""},{"$f":"IF(AND($A$15>0,P6<>\"\"),'Beoord Logboek'!S11,\"\")","v":""},{"$f":"IF(AND($A$15>0,Q6<>\"\"),'Beoord Logboek'!T11,\"\")","v":""},{"$f":"IF(AND($A$15>0,R6<>\"\"),'Beoord Logboek'!U11,\"\")","v":""},{"$f":"IF(AND($A$15>0,S6<>\"\"),'Beoord Logboek'!V11,\"\")","v":""},{"$f":"IF(AND($A$15>0,T6<>\"\"),'Beoord Logboek'!W11,\"\")","v":""},{"$f":"IF(AND($A$15>0,U6<>\"\"),'Beoord Logboek'!X11,\"\")","v":""},{"$f":"IF(AND($A$15>0,V6<>\"\"),'Beoord Logboek'!Y11,\"\")","v":""},{"$f":"IF(AND($A$15>0,W6<>\"\"),'Beoord Logboek'!Z11,\"\")","v":""},{"$f":"IF(AND($A$15>0,X6<>\"\"),'Beoord Logboek'!AA11,\"\")","v":75},{"$f":"IF(AND($A$15>0,Y6<>\"\"),'Beoord Logboek'!AB11,\"\")","v":""},{"$f":"IF(AND($A$15>0,Z6<>\"\"),'Beoord Logboek'!AC11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AA6<>\"\"),'Beoord Logboek'!AD11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AB6<>\"\"),'Beoord Logboek'!AE11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AC6<>\"\"),'Beoord Logboek'!AF11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AD6<>\"\"),'Beoord Logboek'!AG11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AE6<>\"\"),'Beoord Logboek'!AH11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AF6<>\"\"),'Beoord Logboek'!AI11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AG6<>\"\"),'Beoord Logboek'!AJ11,\"\")","v":""},{"$f":"IF(AND($A$15>0,AH6<>\"\"),'Beoord Logboek'!AK11,\"\")","v":""},null,43.75]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$15,C7:C15))/SUM($A$7:$A$15),\"\")","v":100},0,0,"","","","","","","","","","","","","","","","","","",83.035714285714292,"","","","","","","","","","",null,{"$f":"AVERAGE(C16:AH16)","v":45.758928571428569}]
[null,"cijfer",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$15,C7:C15)*0.9)/SUM($A$7:$A$15)+10,\"\")","v":100},{"$f":"IF(D6<>\"\",(SUMPRODUCT($A$7:$A$15,D7:D15)*0.9)/SUM($A$7:$A$15)+10,\"\")","v":10},10,"","","","","","","","","","","","","","","","","","",84.732142857142861,"","","","","","","","","","",null,{"$f":"AVERAGE(C17:AH17)","v":51.183035714285715}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"kies leerling: ",null,23]