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

{"sheet":"Beoord Verslag","index":2,"n_rows":73,"n_cols":40,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":""},{"$f":"'Overzicht resultaten'!D6","v":""},{"$f":"'Overzicht resultaten'!E6","v":""},{"$f":"'Overzicht resultaten'!F6","v":""},{"$f":"'Overzicht resultaten'!G6","v":""},{"$f":"'Overzicht resultaten'!H6","v":""},{"$f":"'Overzicht resultaten'!I6","v":""},{"$f":"'Overzicht resultaten'!J6","v":""},{"$f":"'Overzicht resultaten'!K6","v":""},{"$f":"'Overzicht resultaten'!L6","v":""},{"$f":"'Overzicht resultaten'!M6","v":""},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,"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,"omschrijft het probleem duidelijk",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D5>0,$E$4>0),\"x\",0)","v":"x"}]
[2,2,"brengt het probleem in verband met relevante kennis en of theorieën of met eerder onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D6>0,$E$4>0),\"x\",0)","v":"x"}]
[3,3,"noemt meerdere kwalitatief goede, relevante, actuele bronnen, niet alleen nationale",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[4,4,"omschrijft de onderzoeksvraag (vragen) goed",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[5,5,"heeft oog gehad voor de onderzoekbaarheid en haalbaarheid",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[6,6,"laat de onderzoeksvraag aansluiten bij de probleemstelling en theorie",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[7,7,"stelt de vraag op een vakinhoudelijke voldoende niveau",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[8,8,"bakent de vraag af, beperkt tot één probleem",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[9,9,"laat de deelvragen aansluiten bij de hoofdvraag",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[10,10,"stelt de deelvragen voldoende concreet, de vragen zijn realistisch en onderzoekbaar",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[11,11,"formuleert een hypothese die past bij de onderzoeksvraag of probleemstelling",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[12,12,"zelf invullen ...",null,null,null,null,null,null,null,null,null,null,null,null,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":0},{"$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,"laat de opzet en methode van het onderzoek goed aansluiten bij de onderzoeksvraag en deelvragen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D19>0,$E$18>0),\"x\",0)","v":"x"}]
[{"$f":"A19+1","v":14},2,"zet het onderzoek logisch en adequaat op",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20>0,$E$18>0),\"x\",0)","v":"x"}]
[{"$f":"A20+1","v":15},3,"zet het onderzoek zichtbaar op volgens de natuurwetenschappelijke methode",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[16,4,"heeft oog voor controle of blanco experimenten",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[17,5,"laat zien dat herhaalbaarheid/reproduceerbaarheid belangrijk is",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[18,6,"heeft oog voor de nauwkeurigheid van metingen of observaties",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[19,7,"geeft de proefopstelling schematisch aan of geeft een goede beschrijving hiervan",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[20,8,"zorgt voor voldoende diepgang van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[21,9,"zorgt voor een betrouwbare en verifieerbare opzet van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[22,10,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*F19:F28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*G19:G28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*H19:H28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*I19:I28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*J19:J28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*K19:K28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*L19:L28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*M19:M28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*N19:N28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*O19:O28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*P19:P28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*Q19:Q28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*R19:R28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*S19:S28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*T19:T28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*U19:U28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*V19:V28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*W19:W28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*X19:X28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*Y19:Y28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*Z19:Z28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AA19:AA28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AB19:AB28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AC19:AC28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AD19:AD28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AE19:AE28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AF19:AF28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AG19:AG28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AH19:AH28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AI19:AI28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AJ19:AJ28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),0)","v":0},{"$f":"IF(AND(SUM($D$19:$D$28)>0,$E$18>0),VALUE(SUMPRODUCT($D$19:$D$28*AK19:AK28)*100/(Agendalijst!$F$4*SUM($D$19:$D$28))),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"]
[23,1,"voert het onderzoek uit volgens het werkplan, noteert afwijkingen en past het zo nodig aan",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D31>0,$E$30>0),\"x\",0)","v":"x"}]
[{"$f":"A31+1","v":24},2,"voert het onderzoek verantwoord, veilig en kritisch uit",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D32>0,$E$30>0),\"x\",0)","v":"x"}]
[25,3,"gaat adequaat om met instrumenten en materialen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[26,4,"voert de waarnemingen en metingen systematisch, nauwkeurig en objectief uit en noteert deze (zo min mogelijk geïnterpreteerd)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[27,5,"herhaalt metingen en waarnemingen en noteert deze ook",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[28,6,"ordent de gegevens op de juiste manier",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[29,7,"voert juiste berekeningen uit met de gegevens",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[30,8,"noteert alle gegevens correct, compleet, gedetailleerd en overzichtelijk ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[31,9,"verwerkt de gegevens functioneel / relevant / passend in grafieken en tabellen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[32,10,"zorgt voor voldoende kwaliteit van grafieken en tabellen (bv. bijschrift, schaalverdeling, grootheden, eenheden, meetpunten, spreiding, meetfout)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[33,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$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*F31:F41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*G31:G41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*H31:H41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*I31:I41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*J31:J41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*K31:K41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*L31:L41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*M31:M41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*N31:N41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*O31:O41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*P31:P41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*Q31:Q41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*R31:R41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*S31:S41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*T31:T41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*U31:U41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*V31:V41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*W31:W41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*X31:X41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*Y31:Y41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*Z31:Z41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AA31:AA41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AB31:AB41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AC31:AC41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AD31:AD41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AE31:AE41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AF31:AF41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AG31:AG41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AH31:AH41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AI31:AI41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AJ31:AJ41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},{"$f":"IF(AND(SUM($D$31:$D$41)>0,$E$30>0),VALUE(SUMPRODUCT($D$31:$D$41*AK31:AK41)*100/(Agendalijst!$F$4*SUM($D$31:$D$41))),0)","v":0},null,null,{"$f":"IF(E30>0,\"x\",0)","v":"x"}]
[null,null,"A4. De conclusie, 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"]
[34,1,"formuleert een conclusie die past bij de onderzoeksvraag en probleemstelling",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D44>0,$E$43>0),\"x\",0)","v":"x"}]
[{"$f":"A44+1","v":35},2,"onderbouwt de hypothese of weerlegt deze",1,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(D45>0,$E$43>0),\"x\",0)","v":"x"}]
[{"$f":"A45+1","v":36},3,"formuleert een conclusie die past bij de resultaten ",1,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,"x"]
[{"$f":"A46+1","v":37},4,"onderbouwt de conclusie met een logische redenering",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"A47+1","v":38},5,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*F44:F48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*G44:G48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*H44:H48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*I44:I48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*J44:J48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*K44:K48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*L44:L48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*M44:M48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*N44:N48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*O44:O48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*P44:P48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*Q44:Q48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*R44:R48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*S44:S48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*T44:T48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*U44:U48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*V44:V48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*W44:W48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*X44:X48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*Y44:Y48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*Z44:Z48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AA44:AA48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":50},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AB44:AB48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AC44:AC48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AD44:AD48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AE44:AE48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AF44:AF48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AG44:AG48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AH44:AH48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AI44:AI48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AJ44:AJ48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},{"$f":"IF(AND(SUM($D$44:$D$48)>0,$E$43>0),VALUE(SUMPRODUCT($D$44:$D$48*AK44:AK48)*100/(Agendalijst!$F$4*SUM($D$44:$D$48))),0)","v":0},null,null,{"$f":"IF(E43>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"]
[39,1,"evalueert het onderzoeksproduct m.b.t. de resultaten en conclusie",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D51>0,$E$50>0),\"x\",0)","v":"x"}]
[{"$f":"A51+1","v":40},2,"geeft de betrouwbaarheid aan van de resultaten",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D52>0,$E$50>0),\"x\",0)","v":"x"}]
[41,3,"geeft andere mogelijke verklaringen voor de resultaten (zijn er andere alternatieven mogelijk?)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[42,null,"geeft mogelijke oorzaken voor vertekende resultaten (vooringenomenheid, toeval, belangen)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[43,4,"geeft aan hoe de onderzoeksresultaten te verifiëren zijn",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[44,5,"beschrijft verbeterpunten bij de uitvoering van het onderzoek",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[45,null,"onderscheidt feiten en meningen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[46,6,"geeft suggesties voor vervolgonderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[47,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$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*F51:F59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*G51:G59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*H51:H59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*I51:I59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*J51:J59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*K51:K59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*L51:L59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*M51:M59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*N51:N59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*O51:O59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*P51:P59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*Q51:Q59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*R51:R59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*S51:S59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*T51:T59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*U51:U59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*V51:V59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*W51:W59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*X51:X59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*Y51:Y59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*Z51:Z59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AA51:AA59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AB51:AB59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AC51:AC59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AD51:AD59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AE51:AE59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AF51:AF59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AG51:AG59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AH51:AH59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AI51:AI59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AJ51:AJ59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},{"$f":"IF(AND(SUM($D$51:$D$59)>0,$E$50>0),VALUE(SUMPRODUCT($D$51:$D$59*AK51:AK59)*100/(Agendalijst!$F$4*SUM($D$51:$D$59))),0)","v":0},null,null,{"$f":"IF(E50>0,\"x\",0)","v":"x"}]
[null,null,"A6. Structuur, taal en vormgeving, 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"]
[48,1,"zorgt voor een duidelijke lijn in het verslag (zorgvuldig, helder en logisch opgeschreven, zonder overbodige informatie of herhaling)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D62>0,$E$61>0),\"x\",0)","v":"x"}]
[{"$f":"A62+1","v":49},2,"bouwt het verslag op volgens de geldende standaard / voorschriften",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D63>0,$E$61>0),\"x\",0)","v":"x"}]
[50,3,"zorgt voor een opbouw in hoofdstukken, paragrafen, alinea's",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[51,4,"zorgt voor een goede inleiding (zoals probleemstelling, theoretisch kader, onderzoeks/ontwerpvragen, etc.)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[52,5,"zorgt voor een paragraaf over de resultaten / conclusies",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[53,6,"zorgt voor functionele onderdelen, plaatsing van en verwijzing naar illustraties, tabellen en grafieken",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[54,7,"zorgt voor adequaatheid taalgebruik (begrijpelijk en afgestemd op de beoogde doelgroep)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[55,8,"zorgt voor oorspronkelijkheid (eigen woorden, getuigend van eigengemaakte kennis)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[56,9,"zorgt voor goede leesbaarheid, juist gebruik van grammatica, zinsconstructies en vermijdt spelfouten",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[57,10,"zorgt voor juist gebruik van vaktaal en vakbegrippen",1,null,null,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,"x"]
[58,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$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*F62:F72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*G62:G72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*H62:H72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*I62:I72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*J62:J72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*K62:K72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*L62:L72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*M62:M72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*N62:N72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*O62:O72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*P62:P72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*Q62:Q72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*R62:R72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*S62:S72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*T62:T72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*U62:U72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*V62:V72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*W62:W72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*X62:X72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*Y62:Y72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*Z62:Z72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AA62:AA72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":7.5},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AB62:AB72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AC62:AC72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AD62:AD72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AE62:AE72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AF62:AF72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AG62:AG72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AH62:AH72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AI62:AI72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AJ62:AJ72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},{"$f":"IF(AND(SUM($D$62:$D$72)>0,$E$61>0),VALUE(SUMPRODUCT($D$62:$D$72*AK62:AK72)*100/(Agendalijst!$F$4*SUM($D$62:$D$72))),0)","v":0},null,null,{"$f":"IF(E61>0,\"x\",0)","v":"x"}]

{"sheet":"Beoord Proces","index":3,"n_rows":32,"n_cols":40,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":""},{"$f":"'Overzicht resultaten'!D6","v":""},{"$f":"'Overzicht resultaten'!E6","v":""},{"$f":"'Overzicht resultaten'!F6","v":""},{"$f":"'Overzicht resultaten'!G6","v":""},{"$f":"'Overzicht resultaten'!H6","v":""},{"$f":"'Overzicht resultaten'!I6","v":""},{"$f":"'Overzicht resultaten'!J6","v":""},{"$f":"'Overzicht resultaten'!K6","v":""},{"$f":"'Overzicht resultaten'!L6","v":""},{"$f":"'Overzicht resultaten'!M6","v":""},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,"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"}]
[59,1,"toont de wil om te weten, toont initiatief",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[{"$f":"A5+1","v":60},2,"staat open voor commentaar en wil resultaten delen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[61,3,"toont een kritische, analytische benadering",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[62,4,"toont zelfstandigheid, flexibiliteit, discipline en doorzettingsvermogen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[63,5,"toont een eigen inbreng en komt met originele ideeën",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[64,6,"toont een integere professionele benadering",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[65,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,"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"]
[67,1,"plant duidelijke en realistische stappen ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D13>0,\"x\",0)","v":"x"}]
[{"$f":"A13+1","v":68},2,"rondt het werk op tijd af en levert het op tijd in",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[69,3,"heeft problemen in planning overwonnen en verantwoord",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[70,4,"toont zichtbare groei in houding, vaardigheden en/of kennis",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[71,5,"zorgt voor goede communicatie met begeleiding op afgesproken momenten en verwerkt feedback op de juiste manier",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[72,6,"kan zelf een manier vinden om door te gaan als onderzoek vastloopt",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[73,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,"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"]
[75,1,"kan naar een ander luisteren, met een ander rekening houden, een ander ondersteunen en waarderen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21>0,\"x\",0)","v":"x"}]
[{"$f":"A21+1","v":76},2,"kan adequaat overleggen en feedback geven",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"A22+1","v":77},3,"maakt gebruik van de talenten en voorkeuren van een ander",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"A23+1","v":78},4,"maakt een verdeling van taken",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"A24+1","v":79},5,"kan een ander aanspreken op het nakomen van afspraken",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[{"$f":"A25+1","v":80},6,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"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"]
[82,1,"kan reflecteren op het proces (houding, creativiteit, planning, voortgang, samenwerking)",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D28>0,\"x\",0)","v":"x"}]
[{"$f":"A28+1","v":83},2,"kan reflecteren op (de kwaliteit van) de behaalde resultaten",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29>0,\"x\",0)","v":"x"}]
[{"$f":"A29+1","v":84},3,"kan reflecteren op eigen gedrag en het eigen leerproces",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30>0,\"x\",0)","v":"x"}]
[{"$f":"A30+1","v":85},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(D31>0,\"x\",0)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*F5:F31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*G5:G31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*H5:H31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*I5:I31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*J5:J31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*K5:K31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*L5:L31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*M5:M31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*N5:N31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*O5:O31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*P5:P31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*Q5:Q31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*R5:R31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*S5:S31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*T5:T31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*U5:U31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*V5:V31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*W5:W31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*X5:X31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*Y5:Y31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*Z5:Z31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AA5:AA31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AB5:AB31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AC5:AC31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AD5:AD31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AE5:AE31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AF5:AF31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AG5:AG31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AH5:AH31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AI5:AI31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AJ5:AJ31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$31)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$31*AK5:AK31)*100/(Agendalijst!$F$4*SUM($D$5:$D$31))),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":""},{"$f":"'Overzicht resultaten'!D6","v":""},{"$f":"'Overzicht resultaten'!E6","v":""},{"$f":"'Overzicht resultaten'!F6","v":""},{"$f":"'Overzicht resultaten'!G6","v":""},{"$f":"'Overzicht resultaten'!H6","v":""},{"$f":"'Overzicht resultaten'!I6","v":""},{"$f":"'Overzicht resultaten'!J6","v":""},{"$f":"'Overzicht resultaten'!K6","v":""},{"$f":"'Overzicht resultaten'!L6","v":""},{"$f":"'Overzicht resultaten'!M6","v":""},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,"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"]
[87,1,"beschrijft de onderzoeksvraag en deelvragen",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[{"$f":"A5+1","v":88},2,"geeft de theoretische onderbouwing en een aanzet van literatuurlijst",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D6>0,\"x\",0)","v":"x"}]
[{"$f":"A6+1","v":89},3,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7>0,\"x\",0)","v":0}]
[null,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,1,"laat de aanpak van het onderzoek aansluiten bij de onderzoeksvraag, deelvragen en evt. hypothese",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D9>0,\"x\",0)","v":"x"}]
[{"$f":"A9+1","v":91},2,"beschrijft beperkingen en foutenbronnen in de aanpak van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D10>0,\"x\",0)","v":"x"}]
[{"$f":"A10+1","v":92},3,"beschrijft de gegevensverwerking in de aanpak van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D11>0,\"x\",0)","v":"x"}]
[{"$f":"A11+1","v":93},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(D12>0,\"x\",0)","v":0}]
[null,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"]
[94,1,"zorgt voor een goede planning en werkvoorbereiding",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14>0,\"x\",0)","v":"x"}]
[{"$f":"A14+1","v":95},2,"plant goede tussenstappen en tussenproducten",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15>0,\"x\",0)","v":"x"}]
[{"$f":"A15+1","v":96},3,"plant een goede taakverdeling",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16>0,\"x\",0)","v":"x"}]
[{"$f":"A16+1","v":97},4,"vermeldt veiligheidsrisico's van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17>0,\"x\",0)","v":"x"}]
[{"$f":"A17+1","v":98},5,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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":0},{"$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":0},{"$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":9,"n_cols":40,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":""},{"$f":"'Overzicht resultaten'!D6","v":""},{"$f":"'Overzicht resultaten'!E6","v":""},{"$f":"'Overzicht resultaten'!F6","v":""},{"$f":"'Overzicht resultaten'!G6","v":""},{"$f":"'Overzicht resultaten'!H6","v":""},{"$f":"'Overzicht resultaten'!I6","v":""},{"$f":"'Overzicht resultaten'!J6","v":""},{"$f":"'Overzicht resultaten'!K6","v":""},{"$f":"'Overzicht resultaten'!L6","v":""},{"$f":"'Overzicht resultaten'!M6","v":""},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,"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,"zorgt er voor dat het logboek inzicht geeft in het verloop van het onderzoek, de verzameling van de gegevens en de verslaglegging",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D5>0,\"x\",0)","v":"x"}]
[{"$f":"A5+1","v":100},2,"beschrijft in het logboek wat hij leert, hij reflecteert op de inhoud van het onderzoek",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D6>0,\"x\",0)","v":"x"}]
[{"$f":"A6+1","v":101},3,"reflecteert op het onderzoeksproces",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7>0,\"x\",0)","v":"x"}]
[{"$f":"A7+1","v":102},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}]
[null,null,null,null,null,{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*F5:F8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*G5:G8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*H5:H8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*I5:I8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*J5:J8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*K5:K8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*L5:L8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*M5:M8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*N5:N8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*O5:O8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*P5:P8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*Q5:Q8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*R5:R8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*S5:S8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*T5:T8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*U5:U8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*V5:V8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*W5:W8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*X5:X8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*Y5:Y8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*Z5:Z8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AA5:AA8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AB5:AB8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AC5:AC8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AD5:AD8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AE5:AE8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AF5:AF8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AG5:AG8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AH5:AH8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AI5:AI8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AJ5:AJ8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),0)","v":0},{"$f":"IF(AND(SUM($D$5:$D$8)>0,$E$4>0),VALUE(SUMPRODUCT($D$5:$D$8*AK5:AK8)*100/(Agendalijst!$F$4*SUM($D$5:$D$8))),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":""},{"$f":"IF(Agendalijst!B6=\"\",\"\",Agendalijst!B6)","v":""},{"$f":"IF(Agendalijst!B7=\"\",\"\",Agendalijst!B7)","v":""},{"$f":"IF(Agendalijst!B8=\"\",\"\",Agendalijst!B8)","v":""},{"$f":"IF(Agendalijst!B9=\"\",\"\",Agendalijst!B9)","v":""},{"$f":"IF(Agendalijst!B10=\"\",\"\",Agendalijst!B10)","v":""},{"$f":"IF(Agendalijst!B11=\"\",\"\",Agendalijst!B11)","v":""},{"$f":"IF(Agendalijst!B12=\"\",\"\",Agendalijst!B12)","v":""},{"$f":"IF(Agendalijst!B13=\"\",\"\",Agendalijst!B13)","v":""},{"$f":"IF(Agendalijst!B14=\"\",\"\",Agendalijst!B14)","v":""},{"$f":"IF(Agendalijst!B15=\"\",\"\",Agendalijst!B15)","v":""},{"$f":"IF(Agendalijst!B16=\"\",\"\",Agendalijst!B16)","v":""},{"$f":"IF(Agendalijst!B17=\"\",\"\",Agendalijst!B17)","v":""},{"$f":"IF(Agendalijst!B18=\"\",\"\",Agendalijst!B18)","v":""},{"$f":"IF(Agendalijst!B19=\"\",\"\",Agendalijst!B19)","v":""},{"$f":"IF(Agendalijst!B20=\"\",\"\",Agendalijst!B20)","v":""},{"$f":"IF(Agendalijst!B21=\"\",\"\",Agendalijst!B21)","v":""},{"$f":"IF(Agendalijst!B22=\"\",\"\",Agendalijst!B22)","v":""},{"$f":"IF(Agendalijst!B23=\"\",\"\",Agendalijst!B23)","v":""},{"$f":"IF(Agendalijst!B24=\"\",\"\",Agendalijst!B24)","v":""},{"$f":"IF(Agendalijst!B25=\"\",\"\",Agendalijst!B25)","v":""},{"$f":"IF(Agendalijst!B26=\"\",\"\",Agendalijst!B26)","v":""},{"$f":"IF(Agendalijst!B27=\"\",\"\",Agendalijst!B27)","v":""},{"$f":"IF(Agendalijst!B28=\"\",\"\",Agendalijst!B28)","v":""},{"$f":"IF(Agendalijst!B29=\"\",\"\",Agendalijst!B29)","v":""},{"$f":"IF(Agendalijst!B30=\"\",\"\",Agendalijst!B30)","v":""},{"$f":"IF(Agendalijst!B31=\"\",\"\",Agendalijst!B31)","v":""},{"$f":"IF(Agendalijst!B32=\"\",\"\",Agendalijst!B32)","v":""},{"$f":"IF(Agendalijst!B33=\"\",\"\",Agendalijst!B33)","v":""},{"$f":"IF(Agendalijst!B34=\"\",\"\",Agendalijst!B34)","v":""},{"$f":"IF(Agendalijst!B35=\"\",\"\",Agendalijst!B35)","v":""},{"$f":"IF(Agendalijst!B36=\"\",\"\",Agendalijst!B36)","v":""},null,"klas"]
[{"$f":"'Beoord Verslag'!E4","v":1},"Inleiding/vraagstelling",{"$f":"IF(AND($A7>0,C6<>\"\"),'Beoord Verslag'!F17,\"\")","v":""},{"$f":"IF(AND($A7>0,D6<>\"\"),'Beoord Verslag'!G17,\"\")","v":""},{"$f":"IF(AND($A7>0,E6<>\"\"),'Beoord Verslag'!H17,\"\")","v":""},{"$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":""},{"$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":{"$error":"#DIV/0!"}}]
[{"$f":"'Beoord Verslag'!E18","v":1},"Onderzoeksopzet",{"$f":"IF(AND($A8>0,C6<>\"\"),'Beoord Verslag'!F29,\"\")","v":""},{"$f":"IF(AND($A8>0,D6<>\"\"),'Beoord Verslag'!G29,\"\")","v":""},{"$f":"IF(AND($A8>0,E6<>\"\"),'Beoord Verslag'!H29,\"\")","v":""},{"$f":"IF(AND($A8>0,F6<>\"\"),'Beoord Verslag'!I29,\"\")","v":""},{"$f":"IF(AND($A8>0,G6<>\"\"),'Beoord Verslag'!J29,\"\")","v":""},{"$f":"IF(AND($A8>0,H6<>\"\"),'Beoord Verslag'!K29,\"\")","v":""},{"$f":"IF(AND($A8>0,I6<>\"\"),'Beoord Verslag'!L29,\"\")","v":""},{"$f":"IF(AND($A8>0,J6<>\"\"),'Beoord Verslag'!M29,\"\")","v":""},{"$f":"IF(AND($A8>0,K6<>\"\"),'Beoord Verslag'!N29,\"\")","v":""},{"$f":"IF(AND($A8>0,L6<>\"\"),'Beoord Verslag'!O29,\"\")","v":""},{"$f":"IF(AND($A8>0,M6<>\"\"),'Beoord Verslag'!P29,\"\")","v":""},{"$f":"IF(AND($A8>0,N6<>\"\"),'Beoord Verslag'!Q29,\"\")","v":""},{"$f":"IF(AND($A8>0,O6<>\"\"),'Beoord Verslag'!R29,\"\")","v":""},{"$f":"IF(AND($A8>0,P6<>\"\"),'Beoord Verslag'!S29,\"\")","v":""},{"$f":"IF(AND($A8>0,Q6<>\"\"),'Beoord Verslag'!T29,\"\")","v":""},{"$f":"IF(AND($A8>0,R6<>\"\"),'Beoord Verslag'!U29,\"\")","v":""},{"$f":"IF(AND($A8>0,S6<>\"\"),'Beoord Verslag'!V29,\"\")","v":""},{"$f":"IF(AND($A8>0,T6<>\"\"),'Beoord Verslag'!W29,\"\")","v":""},{"$f":"IF(AND($A8>0,U6<>\"\"),'Beoord Verslag'!X29,\"\")","v":""},{"$f":"IF(AND($A8>0,V6<>\"\"),'Beoord Verslag'!Y29,\"\")","v":""},{"$f":"IF(AND($A8>0,W6<>\"\"),'Beoord Verslag'!Z29,\"\")","v":""},{"$f":"IF(AND($A8>0,X6<>\"\"),'Beoord Verslag'!AA29,\"\")","v":""},{"$f":"IF(AND($A8>0,Y6<>\"\"),'Beoord Verslag'!AB29,\"\")","v":""},{"$f":"IF(AND($A8>0,Z6<>\"\"),'Beoord Verslag'!AC29,\"\")","v":""},{"$f":"IF(AND($A8>0,AA6<>\"\"),'Beoord Verslag'!AD29,\"\")","v":""},{"$f":"IF(AND($A8>0,AB6<>\"\"),'Beoord Verslag'!AE29,\"\")","v":""},{"$f":"IF(AND($A8>0,AC6<>\"\"),'Beoord Verslag'!AF29,\"\")","v":""},{"$f":"IF(AND($A8>0,AD6<>\"\"),'Beoord Verslag'!AG29,\"\")","v":""},{"$f":"IF(AND($A8>0,AE6<>\"\"),'Beoord Verslag'!AH29,\"\")","v":""},{"$f":"IF(AND($A8>0,AF6<>\"\"),'Beoord Verslag'!AI29,\"\")","v":""},{"$f":"IF(AND($A8>0,AG6<>\"\"),'Beoord Verslag'!AJ29,\"\")","v":""},{"$f":"IF(AND($A8>0,AH6<>\"\"),'Beoord Verslag'!AK29,\"\")","v":""},null,{"$f":"IF(A8>0,AVERAGE(C8:AH8),\"-\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Beoord Verslag'!E30","v":1},"Uitvoering",{"$f":"IF(AND($A9>0,C6<>\"\"),'Beoord Verslag'!F42,\"\")","v":""},{"$f":"IF(AND($A9>0,D6<>\"\"),'Beoord Verslag'!G42,\"\")","v":""},{"$f":"IF(AND($A9>0,E6<>\"\"),'Beoord Verslag'!H42,\"\")","v":""},{"$f":"IF(AND($A9>0,F6<>\"\"),'Beoord Verslag'!I42,\"\")","v":""},{"$f":"IF(AND($A9>0,G6<>\"\"),'Beoord Verslag'!J42,\"\")","v":""},{"$f":"IF(AND($A9>0,H6<>\"\"),'Beoord Verslag'!K42,\"\")","v":""},{"$f":"IF(AND($A9>0,I6<>\"\"),'Beoord Verslag'!L42,\"\")","v":""},{"$f":"IF(AND($A9>0,J6<>\"\"),'Beoord Verslag'!M42,\"\")","v":""},{"$f":"IF(AND($A9>0,K6<>\"\"),'Beoord Verslag'!N42,\"\")","v":""},{"$f":"IF(AND($A9>0,L6<>\"\"),'Beoord Verslag'!O42,\"\")","v":""},{"$f":"IF(AND($A9>0,M6<>\"\"),'Beoord Verslag'!P42,\"\")","v":""},{"$f":"IF(AND($A9>0,N6<>\"\"),'Beoord Verslag'!Q42,\"\")","v":""},{"$f":"IF(AND($A9>0,O6<>\"\"),'Beoord Verslag'!R42,\"\")","v":""},{"$f":"IF(AND($A9>0,P6<>\"\"),'Beoord Verslag'!S42,\"\")","v":""},{"$f":"IF(AND($A9>0,Q6<>\"\"),'Beoord Verslag'!T42,\"\")","v":""},{"$f":"IF(AND($A9>0,R6<>\"\"),'Beoord Verslag'!U42,\"\")","v":""},{"$f":"IF(AND($A9>0,S6<>\"\"),'Beoord Verslag'!V42,\"\")","v":""},{"$f":"IF(AND($A9>0,T6<>\"\"),'Beoord Verslag'!W42,\"\")","v":""},{"$f":"IF(AND($A9>0,U6<>\"\"),'Beoord Verslag'!X42,\"\")","v":""},{"$f":"IF(AND($A9>0,V6<>\"\"),'Beoord Verslag'!Y42,\"\")","v":""},{"$f":"IF(AND($A9>0,W6<>\"\"),'Beoord Verslag'!Z42,\"\")","v":""},{"$f":"IF(AND($A9>0,X6<>\"\"),'Beoord Verslag'!AA42,\"\")","v":""},{"$f":"IF(AND($A9>0,Y6<>\"\"),'Beoord Verslag'!AB42,\"\")","v":""},{"$f":"IF(AND($A9>0,Z6<>\"\"),'Beoord Verslag'!AC42,\"\")","v":""},{"$f":"IF(AND($A9>0,AA6<>\"\"),'Beoord Verslag'!AD42,\"\")","v":""},{"$f":"IF(AND($A9>0,AB6<>\"\"),'Beoord Verslag'!AE42,\"\")","v":""},{"$f":"IF(AND($A9>0,AC6<>\"\"),'Beoord Verslag'!AF42,\"\")","v":""},{"$f":"IF(AND($A9>0,AD6<>\"\"),'Beoord Verslag'!AG42,\"\")","v":""},{"$f":"IF(AND($A9>0,AE6<>\"\"),'Beoord Verslag'!AH42,\"\")","v":""},{"$f":"IF(AND($A9>0,AF6<>\"\"),'Beoord Verslag'!AI42,\"\")","v":""},{"$f":"IF(AND($A9>0,AG6<>\"\"),'Beoord Verslag'!AJ42,\"\")","v":""},{"$f":"IF(AND($A9>0,AH6<>\"\"),'Beoord Verslag'!AK42,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Verslag'!E43","v":1},"Conclusie",{"$f":"IF(AND($A10>0,C6<>\"\"),'Beoord Verslag'!F49,\"\")","v":""},{"$f":"IF(AND($A10>0,D6<>\"\"),'Beoord Verslag'!G49,\"\")","v":""},{"$f":"IF(AND($A10>0,E6<>\"\"),'Beoord Verslag'!H49,\"\")","v":""},{"$f":"IF(AND($A10>0,F6<>\"\"),'Beoord Verslag'!I49,\"\")","v":""},{"$f":"IF(AND($A10>0,G6<>\"\"),'Beoord Verslag'!J49,\"\")","v":""},{"$f":"IF(AND($A10>0,H6<>\"\"),'Beoord Verslag'!K49,\"\")","v":""},{"$f":"IF(AND($A10>0,I6<>\"\"),'Beoord Verslag'!L49,\"\")","v":""},{"$f":"IF(AND($A10>0,J6<>\"\"),'Beoord Verslag'!M49,\"\")","v":""},{"$f":"IF(AND($A10>0,K6<>\"\"),'Beoord Verslag'!N49,\"\")","v":""},{"$f":"IF(AND($A10>0,L6<>\"\"),'Beoord Verslag'!O49,\"\")","v":""},{"$f":"IF(AND($A10>0,M6<>\"\"),'Beoord Verslag'!P49,\"\")","v":""},{"$f":"IF(AND($A10>0,N6<>\"\"),'Beoord Verslag'!Q49,\"\")","v":""},{"$f":"IF(AND($A10>0,O6<>\"\"),'Beoord Verslag'!R49,\"\")","v":""},{"$f":"IF(AND($A10>0,P6<>\"\"),'Beoord Verslag'!S49,\"\")","v":""},{"$f":"IF(AND($A10>0,Q6<>\"\"),'Beoord Verslag'!T49,\"\")","v":""},{"$f":"IF(AND($A10>0,R6<>\"\"),'Beoord Verslag'!U49,\"\")","v":""},{"$f":"IF(AND($A10>0,S6<>\"\"),'Beoord Verslag'!V49,\"\")","v":""},{"$f":"IF(AND($A10>0,T6<>\"\"),'Beoord Verslag'!W49,\"\")","v":""},{"$f":"IF(AND($A10>0,U6<>\"\"),'Beoord Verslag'!X49,\"\")","v":""},{"$f":"IF(AND($A10>0,V6<>\"\"),'Beoord Verslag'!Y49,\"\")","v":""},{"$f":"IF(AND($A10>0,W6<>\"\"),'Beoord Verslag'!Z49,\"\")","v":""},{"$f":"IF(AND($A10>0,X6<>\"\"),'Beoord Verslag'!AA49,\"\")","v":""},{"$f":"IF(AND($A10>0,Y6<>\"\"),'Beoord Verslag'!AB49,\"\")","v":""},{"$f":"IF(AND($A10>0,Z6<>\"\"),'Beoord Verslag'!AC49,\"\")","v":""},{"$f":"IF(AND($A10>0,AA6<>\"\"),'Beoord Verslag'!AD49,\"\")","v":""},{"$f":"IF(AND($A10>0,AB6<>\"\"),'Beoord Verslag'!AE49,\"\")","v":""},{"$f":"IF(AND($A10>0,AC6<>\"\"),'Beoord Verslag'!AF49,\"\")","v":""},{"$f":"IF(AND($A10>0,AD6<>\"\"),'Beoord Verslag'!AG49,\"\")","v":""},{"$f":"IF(AND($A10>0,AE6<>\"\"),'Beoord Verslag'!AH49,\"\")","v":""},{"$f":"IF(AND($A10>0,AF6<>\"\"),'Beoord Verslag'!AI49,\"\")","v":""},{"$f":"IF(AND($A10>0,AG6<>\"\"),'Beoord Verslag'!AJ49,\"\")","v":""},{"$f":"IF(AND($A10>0,AH6<>\"\"),'Beoord Verslag'!AK49,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Verslag'!E50","v":1},"Evaluatie/discussie",{"$f":"IF(AND($A11>0,C6<>\"\"),'Beoord Verslag'!F60,\"\")","v":""},{"$f":"IF(AND($A11>0,D6<>\"\"),'Beoord Verslag'!G60,\"\")","v":""},{"$f":"IF(AND($A11>0,E6<>\"\"),'Beoord Verslag'!H60,\"\")","v":""},{"$f":"IF(AND($A11>0,F6<>\"\"),'Beoord Verslag'!I60,\"\")","v":""},{"$f":"IF(AND($A11>0,G6<>\"\"),'Beoord Verslag'!J60,\"\")","v":""},{"$f":"IF(AND($A11>0,H6<>\"\"),'Beoord Verslag'!K60,\"\")","v":""},{"$f":"IF(AND($A11>0,I6<>\"\"),'Beoord Verslag'!L60,\"\")","v":""},{"$f":"IF(AND($A11>0,J6<>\"\"),'Beoord Verslag'!M60,\"\")","v":""},{"$f":"IF(AND($A11>0,K6<>\"\"),'Beoord Verslag'!N60,\"\")","v":""},{"$f":"IF(AND($A11>0,L6<>\"\"),'Beoord Verslag'!O60,\"\")","v":""},{"$f":"IF(AND($A11>0,M6<>\"\"),'Beoord Verslag'!P60,\"\")","v":""},{"$f":"IF(AND($A11>0,N6<>\"\"),'Beoord Verslag'!Q60,\"\")","v":""},{"$f":"IF(AND($A11>0,O6<>\"\"),'Beoord Verslag'!R60,\"\")","v":""},{"$f":"IF(AND($A11>0,P6<>\"\"),'Beoord Verslag'!S60,\"\")","v":""},{"$f":"IF(AND($A11>0,Q6<>\"\"),'Beoord Verslag'!T60,\"\")","v":""},{"$f":"IF(AND($A11>0,R6<>\"\"),'Beoord Verslag'!U60,\"\")","v":""},{"$f":"IF(AND($A11>0,S6<>\"\"),'Beoord Verslag'!V60,\"\")","v":""},{"$f":"IF(AND($A11>0,T6<>\"\"),'Beoord Verslag'!W60,\"\")","v":""},{"$f":"IF(AND($A11>0,U6<>\"\"),'Beoord Verslag'!X60,\"\")","v":""},{"$f":"IF(AND($A11>0,V6<>\"\"),'Beoord Verslag'!Y60,\"\")","v":""},{"$f":"IF(AND($A11>0,W6<>\"\"),'Beoord Verslag'!Z60,\"\")","v":""},{"$f":"IF(AND($A11>0,X6<>\"\"),'Beoord Verslag'!AA60,\"\")","v":""},{"$f":"IF(AND($A11>0,Y6<>\"\"),'Beoord Verslag'!AB60,\"\")","v":""},{"$f":"IF(AND($A11>0,Z6<>\"\"),'Beoord Verslag'!AC60,\"\")","v":""},{"$f":"IF(AND($A11>0,AA6<>\"\"),'Beoord Verslag'!AD60,\"\")","v":""},{"$f":"IF(AND($A11>0,AB6<>\"\"),'Beoord Verslag'!AE60,\"\")","v":""},{"$f":"IF(AND($A11>0,AC6<>\"\"),'Beoord Verslag'!AF60,\"\")","v":""},{"$f":"IF(AND($A11>0,AD6<>\"\"),'Beoord Verslag'!AG60,\"\")","v":""},{"$f":"IF(AND($A11>0,AE6<>\"\"),'Beoord Verslag'!AH60,\"\")","v":""},{"$f":"IF(AND($A11>0,AF6<>\"\"),'Beoord Verslag'!AI60,\"\")","v":""},{"$f":"IF(AND($A11>0,AG6<>\"\"),'Beoord Verslag'!AJ60,\"\")","v":""},{"$f":"IF(AND($A11>0,AH6<>\"\"),'Beoord Verslag'!AK60,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Verslag'!E61","v":1},"Structuur, taal, vormgeving",{"$f":"IF(AND($A12>0,C6<>\"\"),'Beoord Verslag'!F73,\"\")","v":""},{"$f":"IF(AND($A12>0,D6<>\"\"),'Beoord Verslag'!G73,\"\")","v":""},{"$f":"IF(AND($A12>0,E6<>\"\"),'Beoord Verslag'!H73,\"\")","v":""},{"$f":"IF(AND($A12>0,F6<>\"\"),'Beoord Verslag'!I73,\"\")","v":""},{"$f":"IF(AND($A12>0,G6<>\"\"),'Beoord Verslag'!J73,\"\")","v":""},{"$f":"IF(AND($A12>0,H6<>\"\"),'Beoord Verslag'!K73,\"\")","v":""},{"$f":"IF(AND($A12>0,I6<>\"\"),'Beoord Verslag'!L73,\"\")","v":""},{"$f":"IF(AND($A12>0,J6<>\"\"),'Beoord Verslag'!M73,\"\")","v":""},{"$f":"IF(AND($A12>0,K6<>\"\"),'Beoord Verslag'!N73,\"\")","v":""},{"$f":"IF(AND($A12>0,L6<>\"\"),'Beoord Verslag'!O73,\"\")","v":""},{"$f":"IF(AND($A12>0,M6<>\"\"),'Beoord Verslag'!P73,\"\")","v":""},{"$f":"IF(AND($A12>0,N6<>\"\"),'Beoord Verslag'!Q73,\"\")","v":""},{"$f":"IF(AND($A12>0,O6<>\"\"),'Beoord Verslag'!R73,\"\")","v":""},{"$f":"IF(AND($A12>0,P6<>\"\"),'Beoord Verslag'!S73,\"\")","v":""},{"$f":"IF(AND($A12>0,Q6<>\"\"),'Beoord Verslag'!T73,\"\")","v":""},{"$f":"IF(AND($A12>0,R6<>\"\"),'Beoord Verslag'!U73,\"\")","v":""},{"$f":"IF(AND($A12>0,S6<>\"\"),'Beoord Verslag'!V73,\"\")","v":""},{"$f":"IF(AND($A12>0,T6<>\"\"),'Beoord Verslag'!W73,\"\")","v":""},{"$f":"IF(AND($A12>0,U6<>\"\"),'Beoord Verslag'!X73,\"\")","v":""},{"$f":"IF(AND($A12>0,V6<>\"\"),'Beoord Verslag'!Y73,\"\")","v":""},{"$f":"IF(AND($A12>0,W6<>\"\"),'Beoord Verslag'!Z73,\"\")","v":""},{"$f":"IF(AND($A12>0,X6<>\"\"),'Beoord Verslag'!AA73,\"\")","v":""},{"$f":"IF(AND($A12>0,Y6<>\"\"),'Beoord Verslag'!AB73,\"\")","v":""},{"$f":"IF(AND($A12>0,Z6<>\"\"),'Beoord Verslag'!AC73,\"\")","v":""},{"$f":"IF(AND($A12>0,AA6<>\"\"),'Beoord Verslag'!AD73,\"\")","v":""},{"$f":"IF(AND($A12>0,AB6<>\"\"),'Beoord Verslag'!AE73,\"\")","v":""},{"$f":"IF(AND($A12>0,AC6<>\"\"),'Beoord Verslag'!AF73,\"\")","v":""},{"$f":"IF(AND($A12>0,AD6<>\"\"),'Beoord Verslag'!AG73,\"\")","v":""},{"$f":"IF(AND($A12>0,AE6<>\"\"),'Beoord Verslag'!AH73,\"\")","v":""},{"$f":"IF(AND($A12>0,AF6<>\"\"),'Beoord Verslag'!AI73,\"\")","v":""},{"$f":"IF(AND($A12>0,AG6<>\"\"),'Beoord Verslag'!AJ73,\"\")","v":""},{"$f":"IF(AND($A12>0,AH6<>\"\"),'Beoord Verslag'!AK73,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Proces'!E4","v":1},"Proces",{"$f":"IF(AND($A$13>0,C6<>\"\"),'Beoord Proces'!F32,\"\")","v":""},{"$f":"IF(AND($A$13>0,D6<>\"\"),'Beoord Proces'!G32,\"\")","v":""},{"$f":"IF(AND($A$13>0,E6<>\"\"),'Beoord Proces'!H32,\"\")","v":""},{"$f":"IF(AND($A$13>0,F6<>\"\"),'Beoord Proces'!I32,\"\")","v":""},{"$f":"IF(AND($A$13>0,G6<>\"\"),'Beoord Proces'!J32,\"\")","v":""},{"$f":"IF(AND($A$13>0,H6<>\"\"),'Beoord Proces'!K32,\"\")","v":""},{"$f":"IF(AND($A$13>0,I6<>\"\"),'Beoord Proces'!L32,\"\")","v":""},{"$f":"IF(AND($A$13>0,J6<>\"\"),'Beoord Proces'!M32,\"\")","v":""},{"$f":"IF(AND($A$13>0,K6<>\"\"),'Beoord Proces'!N32,\"\")","v":""},{"$f":"IF(AND($A$13>0,L6<>\"\"),'Beoord Proces'!O32,\"\")","v":""},{"$f":"IF(AND($A$13>0,M6<>\"\"),'Beoord Proces'!P32,\"\")","v":""},{"$f":"IF(AND($A$13>0,N6<>\"\"),'Beoord Proces'!Q32,\"\")","v":""},{"$f":"IF(AND($A$13>0,O6<>\"\"),'Beoord Proces'!R32,\"\")","v":""},{"$f":"IF(AND($A$13>0,P6<>\"\"),'Beoord Proces'!S32,\"\")","v":""},{"$f":"IF(AND($A$13>0,Q6<>\"\"),'Beoord Proces'!T32,\"\")","v":""},{"$f":"IF(AND($A$13>0,R6<>\"\"),'Beoord Proces'!U32,\"\")","v":""},{"$f":"IF(AND($A$13>0,S6<>\"\"),'Beoord Proces'!V32,\"\")","v":""},{"$f":"IF(AND($A$13>0,T6<>\"\"),'Beoord Proces'!W32,\"\")","v":""},{"$f":"IF(AND($A$13>0,U6<>\"\"),'Beoord Proces'!X32,\"\")","v":""},{"$f":"IF(AND($A$13>0,V6<>\"\"),'Beoord Proces'!Y32,\"\")","v":""},{"$f":"IF(AND($A$13>0,W6<>\"\"),'Beoord Proces'!Z32,\"\")","v":""},{"$f":"IF(AND($A$13>0,X6<>\"\"),'Beoord Proces'!AA32,\"\")","v":""},{"$f":"IF(AND($A$13>0,Y6<>\"\"),'Beoord Proces'!AB32,\"\")","v":""},{"$f":"IF(AND($A$13>0,Z6<>\"\"),'Beoord Proces'!AC32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AA6<>\"\"),'Beoord Proces'!AD32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AB6<>\"\"),'Beoord Proces'!AE32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AC6<>\"\"),'Beoord Proces'!AF32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AD6<>\"\"),'Beoord Proces'!AG32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AE6<>\"\"),'Beoord Proces'!AH32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AF6<>\"\"),'Beoord Proces'!AI32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AG6<>\"\"),'Beoord Proces'!AJ32,\"\")","v":""},{"$f":"IF(AND($A$13>0,AH6<>\"\"),'Beoord Proces'!AK32,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Werkplan'!E4","v":1},"Werkplan",{"$f":"IF(AND($A$14>0,C6<>\"\"),'Beoord Werkplan'!F19,\"\")","v":""},{"$f":"IF(AND($A$14>0,D6<>\"\"),'Beoord Werkplan'!G19,\"\")","v":""},{"$f":"IF(AND($A$14>0,E6<>\"\"),'Beoord Werkplan'!H19,\"\")","v":""},{"$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":""},{"$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,{"$error":"#DIV/0!"}]
[{"$f":"'Beoord Logboek'!E4","v":1},"Logboek",{"$f":"IF(AND($A$15>0,C6<>\"\"),'Beoord Logboek'!F9,\"\")","v":""},{"$f":"IF(AND($A$15>0,D6<>\"\"),'Beoord Logboek'!G9,\"\")","v":""},{"$f":"IF(AND($A$15>0,E6<>\"\"),'Beoord Logboek'!H9,\"\")","v":""},{"$f":"IF(AND($A$15>0,F6<>\"\"),'Beoord Logboek'!I9,\"\")","v":""},{"$f":"IF(AND($A$15>0,G6<>\"\"),'Beoord Logboek'!J9,\"\")","v":""},{"$f":"IF(AND($A$15>0,H6<>\"\"),'Beoord Logboek'!K9,\"\")","v":""},{"$f":"IF(AND($A$15>0,I6<>\"\"),'Beoord Logboek'!L9,\"\")","v":""},{"$f":"IF(AND($A$15>0,J6<>\"\"),'Beoord Logboek'!M9,\"\")","v":""},{"$f":"IF(AND($A$15>0,K6<>\"\"),'Beoord Logboek'!N9,\"\")","v":""},{"$f":"IF(AND($A$15>0,L6<>\"\"),'Beoord Logboek'!O9,\"\")","v":""},{"$f":"IF(AND($A$15>0,M6<>\"\"),'Beoord Logboek'!P9,\"\")","v":""},{"$f":"IF(AND($A$15>0,N6<>\"\"),'Beoord Logboek'!Q9,\"\")","v":""},{"$f":"IF(AND($A$15>0,O6<>\"\"),'Beoord Logboek'!R9,\"\")","v":""},{"$f":"IF(AND($A$15>0,P6<>\"\"),'Beoord Logboek'!S9,\"\")","v":""},{"$f":"IF(AND($A$15>0,Q6<>\"\"),'Beoord Logboek'!T9,\"\")","v":""},{"$f":"IF(AND($A$15>0,R6<>\"\"),'Beoord Logboek'!U9,\"\")","v":""},{"$f":"IF(AND($A$15>0,S6<>\"\"),'Beoord Logboek'!V9,\"\")","v":""},{"$f":"IF(AND($A$15>0,T6<>\"\"),'Beoord Logboek'!W9,\"\")","v":""},{"$f":"IF(AND($A$15>0,U6<>\"\"),'Beoord Logboek'!X9,\"\")","v":""},{"$f":"IF(AND($A$15>0,V6<>\"\"),'Beoord Logboek'!Y9,\"\")","v":""},{"$f":"IF(AND($A$15>0,W6<>\"\"),'Beoord Logboek'!Z9,\"\")","v":""},{"$f":"IF(AND($A$15>0,X6<>\"\"),'Beoord Logboek'!AA9,\"\")","v":""},{"$f":"IF(AND($A$15>0,Y6<>\"\"),'Beoord Logboek'!AB9,\"\")","v":""},{"$f":"IF(AND($A$15>0,Z6<>\"\"),'Beoord Logboek'!AC9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AA6<>\"\"),'Beoord Logboek'!AD9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AB6<>\"\"),'Beoord Logboek'!AE9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AC6<>\"\"),'Beoord Logboek'!AF9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AD6<>\"\"),'Beoord Logboek'!AG9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AE6<>\"\"),'Beoord Logboek'!AH9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AF6<>\"\"),'Beoord Logboek'!AI9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AG6<>\"\"),'Beoord Logboek'!AJ9,\"\")","v":""},{"$f":"IF(AND($A$15>0,AH6<>\"\"),'Beoord Logboek'!AK9,\"\")","v":""},null,{"$error":"#DIV/0!"}]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$15,C7:C15))/SUM($A$7:$A$15),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C16:AH16)","v":{"$error":"#DIV/0!"}}]
[null,"cijfer",{"$f":"IF(C6<>\"\",((SUMPRODUCT($A$7:$A$15,C7:C15)*0.9)/SUM($A$7:$A$15)+10),\"\")","v":""},{"$f":"IF(D6<>\"\",((SUMPRODUCT($A$7:$A$15,D7:D15)*0.9)/SUM($A$7:$A$15)+10),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C17:AH17)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"kies leerling: ",null,1]