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

{"sheet":"Beoordeling","index":2,"n_rows":39,"n_cols":41,"rows_kept":39,"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. 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,"de leerling…..","gewicht  (0-4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[1,"*","heeft een qua vorm en inhoud een uitstekende presentatie verzorgd.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$5>0,\"x\",0)","v":"x"},{"$f":"IF(B5=\"*\",\"x\",0)","v":"x"}]
[2,0,"heeft een presentatie gehouden met  een heldere opbouw, met een begin, een middenstuk en een afronding;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$6>0,\"x\",0)","v":0},0]
[3,0,"vertelt het publiek waarover de presentatie zal gaan;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D7>0,\"x\",0)","v":0},0]
[4,0,"weet precies wat hij met zijn presentatie wil bereiken;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,0,"heeft zijn presentatie volledig afgestemd op de doelgroep; ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6,0,"betrekt het publiek op adequate wijze bij zijn presentatie;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,0,"heeft zijn presentatie duidelijk en ter zake afgerond;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,0,"de presentatie voldoet wat de tijd betreft aan de eisen, niet te kort en niet te lang;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,0,"beheerst het onderwerp volledig;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,0,"de hoeveelheid informatie is in overeenstemming met de lengte van de presentatie;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[11,0,"de gekozen hulpmiddelen ondersteunen het betoog en maken de presentatie sterker;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[12,0,"gaat diepgaand in op alle onderdelen;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[13,0,"De presentatie is bijzonder effectvol; ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[14,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[15,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$5:$D$19)>0,$E$20>0),VALUE(SUMPRODUCT($D$5:$D$19*F5:F19)*100/(4*SUM($D$5:$D$19))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"B.Stemgebruik",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"de leerling …","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[16,"*","heeft een prima stemgebruik;",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23>0,\"x\",0)","v":"x"},"x"]
[17,0,"spreekt luid genoeg, brengt variatie in toonhoogte aan en articuleert goed;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[18,0,"spreekt vloeiend, zonder haperingen;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[19,0,"straalt gedurende de hele presentatie enthousiasme voor het onderwerp uit;",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[20,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[21,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$23:$D$28)>0,$E$29>0),VALUE(SUMPRODUCT($D$23:$D$28*F23:F28)*100/(4*SUM($D$23:$D$28))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"x","x"]
[null,null,"C. Non-verbale vaardigheden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,null,"de leerling:","gewicht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[22,"*","heeft voortdurend contact met het publiek en heeft zijn notities nauwelijks nodig.",1,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32>0,\"x\",0)","v":"x"},"x"]
[23,0,"toont telkens een adequate gezichtsuitdrukking die de presentatie ondersteunt.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[24,0,"ondersteunt zijn verhaal op natuurlijke wijze met toepasselijke gebaren.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[25,0," heeft gedurende de presentatie een ontspannen houding. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[26,0,"heeft, bijvoorbeeld in zijn kleding, veel aandacht besteed aan zijn presentatie. ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[27,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[28,0,"zelf invullen ...",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,1,{"$f":"IF(AND(SUM($D$32:$D$38)>0,$E$39>0),VALUE(SUMPRODUCT($D$32:$D$38*F32:F38)*100/(4*SUM($D$32:$D$38))),0)","v":100},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":11,"n_cols":36,"rows_kept":11,"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!E20","v":1},"A",{"$f":"IF(AND($A7>0,C6<>\"\"),Beoordeling!F20,\"\")","v":0},{"$f":"IF(AND($A7>0,D6<>\"\"),Beoordeling!G20,\"\")","v":0},{"$f":"IF(AND($A7>0,E6<>\"\"),Beoordeling!H20,\"\")","v":0},{"$f":"IF(AND($A7>0,F6<>\"\"),Beoordeling!I20,\"\")","v":0},{"$f":"IF(AND($A7>0,G6<>\"\"),Beoordeling!J20,\"\")","v":0},{"$f":"IF(AND($A7>0,H6<>\"\"),Beoordeling!K20,\"\")","v":0},{"$f":"IF(AND($A7>0,I6<>\"\"),Beoordeling!L20,\"\")","v":0},{"$f":"IF(AND($A7>0,J6<>\"\"),Beoordeling!M20,\"\")","v":0},{"$f":"IF(AND($A7>0,K6<>\"\"),Beoordeling!N20,\"\")","v":0},{"$f":"IF(AND($A7>0,L6<>\"\"),Beoordeling!O20,\"\")","v":0},{"$f":"IF(AND($A7>0,M6<>\"\"),Beoordeling!P20,\"\")","v":0},{"$f":"IF(AND($A7>0,N6<>\"\"),Beoordeling!Q20,\"\")","v":""},{"$f":"IF(AND($A7>0,O6<>\"\"),Beoordeling!R20,\"\")","v":""},{"$f":"IF(AND($A7>0,P6<>\"\"),Beoordeling!S20,\"\")","v":""},{"$f":"IF(AND($A7>0,Q6<>\"\"),Beoordeling!T20,\"\")","v":""},{"$f":"IF(AND($A7>0,R6<>\"\"),Beoordeling!U20,\"\")","v":""},{"$f":"IF(AND($A7>0,S6<>\"\"),Beoordeling!V20,\"\")","v":""},{"$f":"IF(AND($A7>0,T6<>\"\"),Beoordeling!W20,\"\")","v":""},{"$f":"IF(AND($A7>0,U6<>\"\"),Beoordeling!X20,\"\")","v":""},{"$f":"IF(AND($A7>0,V6<>\"\"),Beoordeling!Y20,\"\")","v":""},{"$f":"IF(AND($A7>0,W6<>\"\"),Beoordeling!Z20,\"\")","v":""},{"$f":"IF(AND($A7>0,X6<>\"\"),Beoordeling!AA20,\"\")","v":""},{"$f":"IF(AND($A7>0,Y6<>\"\"),Beoordeling!AB20,\"\")","v":""},{"$f":"IF(AND($A7>0,Z6<>\"\"),Beoordeling!AC20,\"\")","v":""},{"$f":"IF(AND($A7>0,AA6<>\"\"),Beoordeling!AD20,\"\")","v":""},{"$f":"IF(AND($A7>0,AB6<>\"\"),Beoordeling!AE20,\"\")","v":""},{"$f":"IF(AND($A7>0,AC6<>\"\"),Beoordeling!AF20,\"\")","v":""},{"$f":"IF(AND($A7>0,AD6<>\"\"),Beoordeling!AG20,\"\")","v":""},{"$f":"IF(AND($A7>0,AE6<>\"\"),Beoordeling!AH20,\"\")","v":""},{"$f":"IF(AND($A7>0,AF6<>\"\"),Beoordeling!AI20,\"\")","v":""},{"$f":"IF(AND($A7>0,AG6<>\"\"),Beoordeling!AJ20,\"\")","v":""},{"$f":"IF(AND($A7>0,AH6<>\"\"),Beoordeling!AK20,\"\")","v":""},null,{"$f":"IF(A7>0,AVERAGE(C7:AH7),\"-\")","v":0}]
[{"$f":"Beoordeling!E29","v":1},"B",{"$f":"IF(AND($A$8>0,C6<>\"\"),Beoordeling!F29,\"\")","v":0},{"$f":"IF(AND($A$8>0,D6<>\"\"),Beoordeling!G29,\"\")","v":0},{"$f":"IF(AND($A$8>0,E6<>\"\"),Beoordeling!H29,\"\")","v":0},{"$f":"IF(AND($A$8>0,F6<>\"\"),Beoordeling!I29,\"\")","v":0},{"$f":"IF(AND($A$8>0,G6<>\"\"),Beoordeling!J29,\"\")","v":0},{"$f":"IF(AND($A$8>0,H6<>\"\"),Beoordeling!K29,\"\")","v":0},{"$f":"IF(AND($A$8>0,I6<>\"\"),Beoordeling!L29,\"\")","v":0},{"$f":"IF(AND($A$8>0,J6<>\"\"),Beoordeling!M29,\"\")","v":0},{"$f":"IF(AND($A$8>0,K6<>\"\"),Beoordeling!N29,\"\")","v":0},{"$f":"IF(AND($A$8>0,L6<>\"\"),Beoordeling!O29,\"\")","v":0},{"$f":"IF(AND($A$8>0,M6<>\"\"),Beoordeling!P29,\"\")","v":0},{"$f":"IF(AND($A$8>0,N6<>\"\"),Beoordeling!Q29,\"\")","v":""},{"$f":"IF(AND($A$8>0,O6<>\"\"),Beoordeling!R29,\"\")","v":""},{"$f":"IF(AND($A$8>0,P6<>\"\"),Beoordeling!S29,\"\")","v":""},{"$f":"IF(AND($A$8>0,Q6<>\"\"),Beoordeling!T29,\"\")","v":""},{"$f":"IF(AND($A$8>0,R6<>\"\"),Beoordeling!U29,\"\")","v":""},{"$f":"IF(AND($A$8>0,S6<>\"\"),Beoordeling!V29,\"\")","v":""},{"$f":"IF(AND($A$8>0,T6<>\"\"),Beoordeling!W29,\"\")","v":""},{"$f":"IF(AND($A$8>0,U6<>\"\"),Beoordeling!X29,\"\")","v":""},{"$f":"IF(AND($A$8>0,V6<>\"\"),Beoordeling!Y29,\"\")","v":""},{"$f":"IF(AND($A$8>0,W6<>\"\"),Beoordeling!Z29,\"\")","v":""},{"$f":"IF(AND($A$8>0,X6<>\"\"),Beoordeling!AA29,\"\")","v":""},{"$f":"IF(AND($A$8>0,Y6<>\"\"),Beoordeling!AB29,\"\")","v":""},{"$f":"IF(AND($A$8>0,Z6<>\"\"),Beoordeling!AC29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AA6<>\"\"),Beoordeling!AD29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AB6<>\"\"),Beoordeling!AE29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AC6<>\"\"),Beoordeling!AF29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AD6<>\"\"),Beoordeling!AG29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AE6<>\"\"),Beoordeling!AH29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AF6<>\"\"),Beoordeling!AI29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AG6<>\"\"),Beoordeling!AJ29,\"\")","v":""},{"$f":"IF(AND($A$8>0,AH6<>\"\"),Beoordeling!AK29,\"\")","v":""},null,{"$f":"IF(A8>0,AVERAGE(C8:AH8),\"-\")","v":0}]
[{"$f":"Beoordeling!E39","v":1},"C",{"$f":"IF(AND($A$9>0,C6<>\"\"),Beoordeling!F39,\"\")","v":100},{"$f":"IF(AND($A$9>0,D6<>\"\"),Beoordeling!G39,\"\")","v":0},{"$f":"IF(AND($A$9>0,E6<>\"\"),Beoordeling!H39,\"\")","v":0},{"$f":"IF(AND($A$9>0,F6<>\"\"),Beoordeling!I39,\"\")","v":0},{"$f":"IF(AND($A$9>0,G6<>\"\"),Beoordeling!J39,\"\")","v":0},{"$f":"IF(AND($A$9>0,H6<>\"\"),Beoordeling!K39,\"\")","v":0},{"$f":"IF(AND($A$9>0,I6<>\"\"),Beoordeling!L39,\"\")","v":0},{"$f":"IF(AND($A$9>0,J6<>\"\"),Beoordeling!M39,\"\")","v":0},{"$f":"IF(AND($A$9>0,K6<>\"\"),Beoordeling!N39,\"\")","v":0},{"$f":"IF(AND($A$9>0,L6<>\"\"),Beoordeling!O39,\"\")","v":0},{"$f":"IF(AND($A$9>0,M6<>\"\"),Beoordeling!P39,\"\")","v":0},{"$f":"IF(AND($A$9>0,N6<>\"\"),Beoordeling!Q39,\"\")","v":""},{"$f":"IF(AND($A$9>0,O6<>\"\"),Beoordeling!R39,\"\")","v":""},{"$f":"IF(AND($A$9>0,P6<>\"\"),Beoordeling!S39,\"\")","v":""},{"$f":"IF(AND($A$9>0,Q6<>\"\"),Beoordeling!T39,\"\")","v":""},{"$f":"IF(AND($A$9>0,R6<>\"\"),Beoordeling!U39,\"\")","v":""},{"$f":"IF(AND($A$9>0,S6<>\"\"),Beoordeling!V39,\"\")","v":""},{"$f":"IF(AND($A$9>0,T6<>\"\"),Beoordeling!W39,\"\")","v":""},{"$f":"IF(AND($A$9>0,U6<>\"\"),Beoordeling!X39,\"\")","v":""},{"$f":"IF(AND($A$9>0,V6<>\"\"),Beoordeling!Y39,\"\")","v":""},{"$f":"IF(AND($A$9>0,W6<>\"\"),Beoordeling!Z39,\"\")","v":""},{"$f":"IF(AND($A$9>0,X6<>\"\"),Beoordeling!AA39,\"\")","v":""},{"$f":"IF(AND($A$9>0,Y6<>\"\"),Beoordeling!AB39,\"\")","v":""},{"$f":"IF(AND($A$9>0,Z6<>\"\"),Beoordeling!AC39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AA6<>\"\"),Beoordeling!AD39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AB6<>\"\"),Beoordeling!AE39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AC6<>\"\"),Beoordeling!AF39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AD6<>\"\"),Beoordeling!AG39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AE6<>\"\"),Beoordeling!AH39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AF6<>\"\"),Beoordeling!AI39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AG6<>\"\"),Beoordeling!AJ39,\"\")","v":""},{"$f":"IF(AND($A$9>0,AH6<>\"\"),Beoordeling!AK39,\"\")","v":""},null,9.0909090909090917]
[null,"eind(%)",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$9,C7:C9))/SUM($A$7:$A$9),\"\")","v":33.333333333333336},0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C10:AH10)","v":3.0303030303030307}]
[null,"cijfer",{"$f":"IF(C6<>\"\",(SUMPRODUCT($A$7:$A$9,C7:C9)*0.9)/SUM($A$7:$A$9)+10,\"\")","v":40},10,10,10,10,10,10,10,10,10,10,"","","","","","","","","","","","","","","","","","","","","",null,{"$f":"AVERAGE(C11:AH11)","v":12.727272727272727}]