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

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

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

{"sheet":"Beoordeling","index":2,"n_rows":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Alle criteria",null,"gewicht per onderdeel","categorie gewicht",{"$f":"'Overzicht resultaten'!C6","v":"leerling 1"},{"$f":"'Overzicht resultaten'!D6","v":"leerling 2"},{"$f":"'Overzicht resultaten'!E6","v":"leerling 3"},{"$f":"'Overzicht resultaten'!F6","v":"leerling 4"},{"$f":"'Overzicht resultaten'!G6","v":"leerling 5"},{"$f":"'Overzicht resultaten'!H6","v":"leerling 6"},{"$f":"'Overzicht resultaten'!I6","v":"leerling 7"},{"$f":"'Overzicht resultaten'!J6","v":"leerling 8"},{"$f":"'Overzicht resultaten'!K6","v":"leerling 9"},{"$f":"'Overzicht resultaten'!L6","v":"leerling 10"},{"$f":"'Overzicht resultaten'!M6","v":"leerling 11"},{"$f":"'Overzicht resultaten'!N6","v":""},{"$f":"'Overzicht resultaten'!O6","v":""},{"$f":"'Overzicht resultaten'!P6","v":""},{"$f":"'Overzicht resultaten'!Q6","v":""},{"$f":"'Overzicht resultaten'!R6","v":""},{"$f":"'Overzicht resultaten'!S6","v":""},{"$f":"'Overzicht resultaten'!T6","v":""},{"$f":"'Overzicht resultaten'!U6","v":""},{"$f":"'Overzicht resultaten'!V6","v":""},{"$f":"'Overzicht resultaten'!W6","v":""},{"$f":"'Overzicht resultaten'!X6","v":""},{"$f":"'Overzicht resultaten'!Y6","v":""},{"$f":"'Overzicht resultaten'!Z6","v":""},{"$f":"'Overzicht resultaten'!AA6","v":""},{"$f":"'Overzicht resultaten'!AB6","v":""},{"$f":"'Overzicht resultaten'!AC6","v":""},{"$f":"'Overzicht resultaten'!AD6","v":""},{"$f":"'Overzicht resultaten'!AE6","v":""},{"$f":"'Overzicht resultaten'!AF6","v":""},{"$f":"'Overzicht resultaten'!AG6","v":""},{"$f":"'Overzicht resultaten'!AH6","v":""},null,null,5]
[null,null,null,null,null,1,{"$f":"F2+1","v":2},{"$f":"G2+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,null,null,"x","x"]
[null,null,"A. Structuur en inhoud",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,null,"gewicht  (0-4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[1,"*","Je hebt een uitstekende poster gemaakt. Dat betekent …",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$5>0,\"x\",0)","v":0},{"$f":"IF(B5=\"*\",\"x\",0)","v":"x"}]
[2,0,"de poster is op 1,5 meter afstand goed leesbaar.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$6>0,\"x\",0)","v":"x"},0]
[3,0,"de boodschap wordt binnen 11 seconden 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(D7>0,\"x\",0)","v":"x"},0]
[4,0,"de poster bevat alle vereiste elementen.",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",0]
[5,0,"de poster bevat niet teveel tekst.",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,null,0]
[6,0,"alle belangrijke onderdelen hebben relevante bijschriften die op 1,5 meter afstand te lezen 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,null,0]
[7,0,"alle gebruikte grafieken hebben een relatie met het onderwerp.",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,null,0]
[8,0,"alle grafieken van anderen zijn voorzien van een bronvermelding.",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,null,0]
[9,0,"de grafieken hebben duidelijk een toegevoegde waarde.",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,null,0]
[10,0,"de inhoud van de poster is volledig juist.",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,null,0]
[11,0,"de poster bevat geen taalfouten.",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,null,0]
[12,0,"uit de poster blijkt dat je het onderwerp volledig beheerst.",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",0]
[13,0,"de poster is zeer effectief.",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,null,0]
[14,0,"de poster is grafisch zeer aantrekkelijk en overzichtelijk vormgegeven.",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",0]
[15,0,"de poster is zeer origineel.",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",0]
[16,0,"de gebruikte kleuren harmoniëren prachtig.",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,null,0]
[17,0,"de vlakverdeling is uitstekend.",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,null,0]
[18,0,"het is duidelijk wie de poster heeft gemaakt.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[19,0,"zelf invullen ...",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",0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$5:$D$23)>0,$E$24>0),VALUE(SUMPRODUCT($D$5:$D$23*F5:F23)*100/(4*SUM($D$5:$D$23))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]

{"sheet":"Overzicht resultaten","index":3,"n_rows":9,"n_cols":36,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Overzicht resultaten: niets invullen!"]
[]
[]
[null,null,1,{"$f":"C5+1","v":2},{"$f":"D5+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,{"$f":"AF5+1","v":31},32,null,"gemiddelde"]
["weging","categorie",{"$f":"IF(Agendalijst!B5=\"\",\"\",Agendalijst!B5)","v":"leerling 1"},{"$f":"IF(Agendalijst!B6=\"\",\"\",Agendalijst!B6)","v":"leerling 2"},{"$f":"IF(Agendalijst!B7=\"\",\"\",Agendalijst!B7)","v":"leerling 3"},{"$f":"IF(Agendalijst!B8=\"\",\"\",Agendalijst!B8)","v":"leerling 4"},{"$f":"IF(Agendalijst!B9=\"\",\"\",Agendalijst!B9)","v":"leerling 5"},{"$f":"IF(Agendalijst!B10=\"\",\"\",Agendalijst!B10)","v":"leerling 6"},{"$f":"IF(Agendalijst!B11=\"\",\"\",Agendalijst!B11)","v":"leerling 7"},{"$f":"IF(Agendalijst!B12=\"\",\"\",Agendalijst!B12)","v":"leerling 8"},{"$f":"IF(Agendalijst!B13=\"\",\"\",Agendalijst!B13)","v":"leerling 9"},{"$f":"IF(Agendalijst!B14=\"\",\"\",Agendalijst!B14)","v":"leerling 10"},{"$f":"IF(Agendalijst!B15=\"\",\"\",Agendalijst!B15)","v":"leerling 11"},{"$f":"IF(Agendalijst!B16=\"\",\"\",Agendalijst!B16)","v":""},{"$f":"IF(Agendalijst!B17=\"\",\"\",Agendalijst!B17)","v":""},{"$f":"IF(Agendalijst!B18=\"\",\"\",Agendalijst!B18)","v":""},{"$f":"IF(Agendalijst!B19=\"\",\"\",Agendalijst!B19)","v":""},{"$f":"IF(Agendalijst!B20=\"\",\"\",Agendalijst!B20)","v":""},{"$f":"IF(Agendalijst!B21=\"\",\"\",Agendalijst!B21)","v":""},{"$f":"IF(Agendalijst!B22=\"\",\"\",Agendalijst!B22)","v":""},{"$f":"IF(Agendalijst!B23=\"\",\"\",Agendalijst!B23)","v":""},{"$f":"IF(Agendalijst!B24=\"\",\"\",Agendalijst!B24)","v":""},{"$f":"IF(Agendalijst!B25=\"\",\"\",Agendalijst!B25)","v":""},{"$f":"IF(Agendalijst!B26=\"\",\"\",Agendalijst!B26)","v":""},{"$f":"IF(Agendalijst!B27=\"\",\"\",Agendalijst!B27)","v":""},{"$f":"IF(Agendalijst!B28=\"\",\"\",Agendalijst!B28)","v":""},{"$f":"IF(Agendalijst!B29=\"\",\"\",Agendalijst!B29)","v":""},{"$f":"IF(Agendalijst!B30=\"\",\"\",Agendalijst!B30)","v":""},{"$f":"IF(Agendalijst!B31=\"\",\"\",Agendalijst!B31)","v":""},{"$f":"IF(Agendalijst!B32=\"\",\"\",Agendalijst!B32)","v":""},{"$f":"IF(Agendalijst!B33=\"\",\"\",Agendalijst!B33)","v":""},{"$f":"IF(Agendalijst!B34=\"\",\"\",Agendalijst!B34)","v":""},{"$f":"IF(Agendalijst!B35=\"\",\"\",Agendalijst!B35)","v":""},{"$f":"IF(Agendalijst!B36=\"\",\"\",Agendalijst!B36)","v":""},null,"klas"]
[{"$f":"Beoordeling!E24","v":1},"A",{"$f":"IF(AND($A7>0,C6<>\"\"),Beoordeling!F24,\"\")","v":0},{"$f":"IF(AND($A7>0,D6<>\"\"),Beoordeling!G24,\"\")","v":0},{"$f":"IF(AND($A7>0,E6<>\"\"),Beoordeling!H24,\"\")","v":0},{"$f":"IF(AND($A7>0,F6<>\"\"),Beoordeling!I24,\"\")","v":0},{"$f":"IF(AND($A7>0,G6<>\"\"),Beoordeling!J24,\"\")","v":0},{"$f":"IF(AND($A7>0,H6<>\"\"),Beoordeling!K24,\"\")","v":0},{"$f":"IF(AND($A7>0,I6<>\"\"),Beoordeling!L24,\"\")","v":0},{"$f":"IF(AND($A7>0,J6<>\"\"),Beoordeling!M24,\"\")","v":0},{"$f":"IF(AND($A7>0,K6<>\"\"),Beoordeling!N24,\"\")","v":0},{"$f":"IF(AND($A7>0,L6<>\"\"),Beoordeling!O24,\"\")","v":0},{"$f":"IF(AND($A7>0,M6<>\"\"),Beoordeling!P24,\"\")","v":0},{"$f":"IF(AND($A7>0,N6<>\"\"),Beoordeling!Q24,\"\")","v":""},{"$f":"IF(AND($A7>0,O6<>\"\"),Beoordeling!R24,\"\")","v":""},{"$f":"IF(AND($A7>0,P6<>\"\"),Beoordeling!S24,\"\")","v":""},{"$f":"IF(AND($A7>0,Q6<>\"\"),Beoordeling!T24,\"\")","v":""},{"$f":"IF(AND($A7>0,R6<>\"\"),Beoordeling!U24,\"\")","v":""},{"$f":"IF(AND($A7>0,S6<>\"\"),Beoordeling!V24,\"\")","v":""},{"$f":"IF(AND($A7>0,T6<>\"\"),Beoordeling!W24,\"\")","v":""},{"$f":"IF(AND($A7>0,U6<>\"\"),Beoordeling!X24,\"\")","v":""},{"$f":"IF(AND($A7>0,V6<>\"\"),Beoordeling!Y24,\"\")","v":""},{"$f":"IF(AND($A7>0,W6<>\"\"),Beoordeling!Z24,\"\")","v":""},{"$f":"IF(AND($A7>0,X6<>\"\"),Beoordeling!AA24,\"\")","v":""},{"$f":"IF(AND($A7>0,Y6<>\"\"),Beoordeling!AB24,\"\")","v":""},{"$f":"IF(AND($A7>0,Z6<>\"\"),Beoordeling!AC24,\"\")","v":""},{"$f":"IF(AND($A7>0,AA6<>\"\"),Beoordeling!AD24,\"\")","v":""},{"$f":"IF(AND($A7>0,AB6<>\"\"),Beoordeling!AE24,\"\")","v":""},{"$f":"IF(AND($A7>0,AC6<>\"\"),Beoordeling!AF24,\"\")","v":""},{"$f":"IF(AND($A7>0,AD6<>\"\"),Beoordeling!AG24,\"\")","v":""},{"$f":"IF(AND($A7>0,AE6<>\"\"),Beoordeling!AH24,\"\")","v":""},{"$f":"IF(AND($A7>0,AF6<>\"\"),Beoordeling!AI24,\"\")","v":""},{"$f":"IF(AND($A7>0,AG6<>\"\"),Beoordeling!AJ24,\"\")","v":""},{"$f":"IF(AND($A7>0,AH6<>\"\"),Beoordeling!AK24,\"\")","v":""},null,{"$f":"IF(A7>0,AVERAGE(C7:AH7),\"-\")","v":0}]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$7,C7:C7))/SUM($A$7:$A$7),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C8:AH8)","v":0}]
[null,"cijfer",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$7,C7:C7)*0.9)/SUM($A$7:$A$7)+10,\"\")","v":10},10,10,10,10,10,10,10,10,10,10,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C9:AH9)","v":10}]