{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Référentiel"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":108,"comments":1,"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":"Feuil1","index":0,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,5,3,7],[3,8,4,8],[3,9,4,9]]}
[null,null,"Fiche évaluation DNB",null,null,null,"APSA:","Aérobic"]
[null,"Classe/Groupe",null,null,null,null,"Professeur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Aérobic  .pdf"]
[null,null,null,null,null,"Qualité de l'enchaînement",null,null,"Qualité d'exécution /8 points","Efficacité dans le rôle de juge /4 points"]
[null,"Nom- Prénom","Sexe","Classe","Note","Cotation de l'enchaînement","Conception et présentation/8 point","Note qualité d'enchaînement /8 points",null,null,null,null,"A",1,null,null,"La routine est simple",null,null,null,"Le gymnaste récite sa routine",null,null,"Le jugement est partiel"]
[1,null,null,null,{"$f":"IF(H6=\"\",\"\",H6+I6+J6)","v":""},null,null,{"$f":"IF(AND(F6=\"\",G6=\"\"),\"\",IF(F6=\"\",\"affectez une cotation\",G6*(INDEX(N$5:$N$7,MATCH(F6,$M$5:$M$7,0)))))","v":""},null,null,null,null,"B",0.9,null,null,0,null,null,null,0,null,null,0]
[2,null,null,null,{"$f":"IF(H7=\"\",\"\",H7+I7+J7)","v":""},null,null,{"$f":"IF(AND(F7=\"\",G7=\"\"),\"\",IF(F7=\"\",\"affectez une cotation\",G7*(INDEX(N$5:$N$7,MATCH(F7,$M$5:$M$7,0)))))","v":""},null,null,null,null,"C",0.8,null,null,0.5,null,null,null,0.5,null,null,0.5]
[3,null,null,null,"",null,null,{"$f":"IF(AND(F8=\"\",G8=\"\"),\"\",IF(F8=\"\",\"affectez une cotation\",G8*(INDEX(N$5:$N$7,MATCH(F8,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,1,null,null,null,1,null,null,1]
[4,null,null,null,"",null,null,{"$f":"IF(AND(F9=\"\",G9=\"\"),\"\",IF(F9=\"\",\"affectez une cotation\",G9*(INDEX(N$5:$N$7,MATCH(F9,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,1.5,null,null,null,1.5,null,null,1.5]
[5,null,null,null,"",null,null,{"$f":"IF(AND(F10=\"\",G10=\"\"),\"\",IF(F10=\"\",\"affectez une cotation\",G10*(INDEX(N$5:$N$7,MATCH(F10,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,2,null,null,null,2,null,null,"Le jugement est argumenté"]
[6,null,null,null,"",null,null,{"$f":"IF(AND(F11=\"\",G11=\"\"),\"\",IF(F11=\"\",\"affectez une cotation\",G11*(INDEX(N$5:$N$7,MATCH(F11,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,2.5,null,null,null,2.5,null,null,2]
[7,null,null,null,"",null,null,{"$f":"IF(AND(F12=\"\",G12=\"\"),\"\",IF(F12=\"\",\"affectez une cotation\",G12*(INDEX(N$5:$N$7,MATCH(F12,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,3,null,null,null,3,null,null,2.5]
[8,null,null,null,"",null,null,{"$f":"IF(AND(F13=\"\",G13=\"\"),\"\",IF(F13=\"\",\"affectez une cotation\",G13*(INDEX(N$5:$N$7,MATCH(F13,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,3.5,null,null,null,3.5,null,null,3]
[9,null,null,null,"",null,null,{"$f":"IF(AND(F14=\"\",G14=\"\"),\"\",IF(F14=\"\",\"affectez une cotation\",G14*(INDEX(N$5:$N$7,MATCH(F14,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,4,null,null,null,4,null,null,"Le jugement est pertinent"]
[10,null,null,null,"",null,null,{"$f":"IF(AND(F15=\"\",G15=\"\"),\"\",IF(F15=\"\",\"affectez une cotation\",G15*(INDEX(N$5:$N$7,MATCH(F15,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,"La routine est construite",null,null,null,"Le gymnaste est en phase avec le groupe",null,null,3.5]
[11,null,null,null,"",null,null,{"$f":"IF(AND(F16=\"\",G16=\"\"),\"\",IF(F16=\"\",\"affectez une cotation\",G16*(INDEX(N$5:$N$7,MATCH(F16,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,4.5,null,null,null,4.5,null,null,4]
[12,null,null,null,"",null,null,{"$f":"IF(AND(F17=\"\",G17=\"\"),\"\",IF(F17=\"\",\"affectez une cotation\",G17*(INDEX(N$5:$N$7,MATCH(F17,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,5,null,null,null,5]
[13,null,null,null,"",null,null,{"$f":"IF(AND(F18=\"\",G18=\"\"),\"\",IF(F18=\"\",\"affectez une cotation\",G18*(INDEX(N$5:$N$7,MATCH(F18,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,6,null,null,null,6]
[14,null,null,null,"",null,null,{"$f":"IF(AND(F19=\"\",G19=\"\"),\"\",IF(F19=\"\",\"affectez une cotation\",G19*(INDEX(N$5:$N$7,MATCH(F19,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,"La routine est riche et originale",null,null,null,"Le gymnasete exécute une routine dynamique"]
[15,null,null,null,"",null,null,{"$f":"IF(AND(F20=\"\",G20=\"\"),\"\",IF(F20=\"\",\"affectez une cotation\",G20*(INDEX(N$5:$N$7,MATCH(F20,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,6.5,null,null,null,6.5]
[16,null,null,null,"",null,null,{"$f":"IF(AND(F21=\"\",G21=\"\"),\"\",IF(F21=\"\",\"affectez une cotation\",G21*(INDEX(N$5:$N$7,MATCH(F21,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,7,null,null,null,7]
[17,null,null,null,"",null,null,{"$f":"IF(AND(F22=\"\",G22=\"\"),\"\",IF(F22=\"\",\"affectez une cotation\",G22*(INDEX(N$5:$N$7,MATCH(F22,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,7.5,null,null,null,7.5]
[18,null,null,null,"",null,null,{"$f":"IF(AND(F23=\"\",G23=\"\"),\"\",IF(F23=\"\",\"affectez une cotation\",G23*(INDEX(N$5:$N$7,MATCH(F23,$M$5:$M$7,0)))))","v":""},null,null,null,null,null,null,null,null,8,null,null,null,8]
[19,null,null,null,"",null,null,{"$f":"IF(AND(F24=\"\",G24=\"\"),\"\",IF(F24=\"\",\"affectez une cotation\",G24*(INDEX(N$5:$N$7,MATCH(F24,$M$5:$M$7,0)))))","v":""}]
[20,null,null,null,"",null,null,{"$f":"IF(AND(F25=\"\",G25=\"\"),\"\",IF(F25=\"\",\"affectez une cotation\",G25*(INDEX(N$5:$N$7,MATCH(F25,$M$5:$M$7,0)))))","v":""}]
[21,null,null,null,"",null,null,{"$f":"IF(AND(F26=\"\",G26=\"\"),\"\",IF(F26=\"\",\"affectez une cotation\",G26*(INDEX(N$5:$N$7,MATCH(F26,$M$5:$M$7,0)))))","v":""}]
[22,null,null,null,"",null,null,{"$f":"IF(AND(F27=\"\",G27=\"\"),\"\",IF(F27=\"\",\"affectez une cotation\",G27*(INDEX(N$5:$N$7,MATCH(F27,$M$5:$M$7,0)))))","v":""}]
[23,null,null,null,"",null,null,{"$f":"IF(AND(F28=\"\",G28=\"\"),\"\",IF(F28=\"\",\"affectez une cotation\",G28*(INDEX(N$5:$N$7,MATCH(F28,$M$5:$M$7,0)))))","v":""}]
[24,null,null,null,"",null,null,{"$f":"IF(AND(F29=\"\",G29=\"\"),\"\",IF(F29=\"\",\"affectez une cotation\",G29*(INDEX(N$5:$N$7,MATCH(F29,$M$5:$M$7,0)))))","v":""}]
[25,null,null,null,"",null,null,{"$f":"IF(AND(F30=\"\",G30=\"\"),\"\",IF(F30=\"\",\"affectez une cotation\",G30*(INDEX(N$5:$N$7,MATCH(F30,$M$5:$M$7,0)))))","v":""}]
[26,null,null,null,"",null,null,{"$f":"IF(AND(F31=\"\",G31=\"\"),\"\",IF(F31=\"\",\"affectez une cotation\",G31*(INDEX(N$5:$N$7,MATCH(F31,$M$5:$M$7,0)))))","v":""}]
[27,null,null,null,"",null,null,{"$f":"IF(AND(F32=\"\",G32=\"\"),\"\",IF(F32=\"\",\"affectez une cotation\",G32*(INDEX(N$5:$N$7,MATCH(F32,$M$5:$M$7,0)))))","v":""}]
[28,null,null,null,"",null,null,{"$f":"IF(AND(F33=\"\",G33=\"\"),\"\",IF(F33=\"\",\"affectez une cotation\",G33*(INDEX(N$5:$N$7,MATCH(F33,$M$5:$M$7,0)))))","v":""}]
[29,null,null,null,"",null,null,{"$f":"IF(AND(F34=\"\",G34=\"\"),\"\",IF(F34=\"\",\"affectez une cotation\",G34*(INDEX(N$5:$N$7,MATCH(F34,$M$5:$M$7,0)))))","v":""}]
[30,null,null,null,"",null,null,{"$f":"IF(AND(F35=\"\",G35=\"\"),\"\",IF(F35=\"\",\"affectez une cotation\",G35*(INDEX(N$5:$N$7,MATCH(F35,$M$5:$M$7,0)))))","v":""}]
[null,null,null,"Moyenne générale",{"$f":"IF(E6=\"\",\"\",AVERAGE($E$6:$E$35))","v":""}]
[null,null,null,"Moyenne filles",{"$f":"IF(E6=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"F\",$E$6:$E$35)))","v":""}]
[null,null,null,"Moyenne garçons",{"$f":"IF(E7=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"M\",$E$6:$E$35)))","v":""}]

{"sheet":"Référentiel","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}