{"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":25,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fiche évaluation DNB",null,null,null,"APSA:","Gymnastique sportive"]
[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,"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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Gymnastique sportive  .pdf"]
[]
[null,"Nom- Prénom","Sexe","Classe","Note","Cotation de difficulté de l'enchainement","Note d'enchainnement /8","Note d'enchaienement avec application du coefficient de difficulté /8 points","Qualité d'exécution /8 points","Efficacité dans le rôle de juge /4 points ",null,"A",1,null,null,"L'enchaînement est minimal",null,null,null,"Le gymnaste exécute",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 un coef de difficulté\",(G6*INDEX($M$5:$M$8,MATCH(F6,$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G7*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F7,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G8*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F8,Feuil1!$L$5:$L$8,0)))))","v":""},null,null,null,"D",0.7,null,null,1,null,null,null,1,null,null,1]
[4,null,null,null,"",null,null,{"$f":"IF(AND(F9=\"\",G9=\"\"),\"\",IF(F9=\"\",\"affectez un coef de difficulté\",(G9*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F9,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G10*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F10,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G11*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F11,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G12*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F12,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G13*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F13,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G14*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F14,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G15*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F15,Feuil1!$L$5:$L$8,0)))))","v":""},null,null,null,null,null,null,null,"L'enchaînement est construit",null,null,null,"Le gymnaste maîtrise",null,null,3.5]
[11,null,null,null,"",null,null,{"$f":"IF(AND(F16=\"\",G16=\"\"),\"\",IF(F16=\"\",\"affectez un coef de difficulté\",(G16*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F16,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G17*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F17,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G18*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F18,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G19*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F19,Feuil1!$L$5:$L$8,0)))))","v":""},null,null,null,null,null,null,null,"L'enchaînement est riche et original",null,null,null,"Le gymnaste anticipe"]
[15,null,null,null,"",null,null,{"$f":"IF(AND(F20=\"\",G20=\"\"),\"\",IF(F20=\"\",\"affectez un coef de difficulté\",(G20*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F20,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G21*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F21,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G22*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F22,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G23*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F23,Feuil1!$L$5:$L$8,0)))))","v":""},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 un coef de difficulté\",(G24*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F24,Feuil1!$L$5:$L$8,0)))))","v":""}]
[20,null,null,null,"",null,null,{"$f":"IF(AND(F25=\"\",G25=\"\"),\"\",IF(F25=\"\",\"affectez un coef de difficulté\",(G25*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F25,Feuil1!$L$5:$L$8,0)))))","v":""}]
[21,null,null,null,"",null,null,{"$f":"IF(AND(F26=\"\",G26=\"\"),\"\",IF(F26=\"\",\"affectez un coef de difficulté\",(G26*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F26,Feuil1!$L$5:$L$8,0)))))","v":""}]
[22,null,null,null,"",null,null,{"$f":"IF(AND(F27=\"\",G27=\"\"),\"\",IF(F27=\"\",\"affectez un coef de difficulté\",(G27*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F27,Feuil1!$L$5:$L$8,0)))))","v":""}]
[23,null,null,null,"",null,null,{"$f":"IF(AND(F28=\"\",G28=\"\"),\"\",IF(F28=\"\",\"affectez un coef de difficulté\",(G28*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F28,Feuil1!$L$5:$L$8,0)))))","v":""}]
[24,null,null,null,"",null,null,{"$f":"IF(AND(F29=\"\",G29=\"\"),\"\",IF(F29=\"\",\"affectez un coef de difficulté\",(G29*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F29,Feuil1!$L$5:$L$8,0)))))","v":""}]
[25,null,null,null,"",null,null,{"$f":"IF(AND(F30=\"\",G30=\"\"),\"\",IF(F30=\"\",\"affectez un coef de difficulté\",(G30*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F30,Feuil1!$L$5:$L$8,0)))))","v":""}]
[26,null,null,null,"",null,null,{"$f":"IF(AND(F31=\"\",G31=\"\"),\"\",IF(F31=\"\",\"affectez un coef de difficulté\",(G31*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F31,Feuil1!$L$5:$L$8,0)))))","v":""}]
[27,null,null,null,"",null,null,{"$f":"IF(AND(F32=\"\",G32=\"\"),\"\",IF(F32=\"\",\"affectez un coef de difficulté\",(G32*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F32,Feuil1!$L$5:$L$8,0)))))","v":""}]
[28,null,null,null,"",null,null,{"$f":"IF(AND(F33=\"\",G33=\"\"),\"\",IF(F33=\"\",\"affectez un coef de difficulté\",(G33*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F33,Feuil1!$L$5:$L$8,0)))))","v":""}]
[29,null,null,null,"",null,null,{"$f":"IF(AND(F34=\"\",G34=\"\"),\"\",IF(F34=\"\",\"affectez un coef de difficulté\",(G34*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F34,Feuil1!$L$5:$L$8,0)))))","v":""}]
[30,null,null,null,"",null,null,{"$f":"IF(AND(F35=\"\",G35=\"\"),\"\",IF(F35=\"\",\"affectez un coef de difficulté\",(G35*INDEX(Feuil1!$M$5:$M$8,MATCH(Feuil1!F35,Feuil1!$L$5:$L$8,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(E6=\"\",\"\",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":[]}