{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Référentiel"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":108,"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":"Feuil1","index":0,"n_rows":38,"n_cols":36,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,21,5,21],[3,6,3,8],[3,9,3,11],[3,12,3,14],[3,15,3,17],[4,6,4,7],[4,9,4,10],[4,12,4,13],[4,15,4,16],[0,18,5,18],[0,19,5,19],[0,20,5,20]]}
[null,null,null,null,"Fiche évaluation DNB",null,null,null,null,"APSA:",null,"Demi fond",null,null,null,null,null,null,"Moyenne des VMA réalisées sur les 3 ou 4 courses /8 points","Efficacité dans l'utilisation des repères sur soi et des repères extérieurs /4 points","Efficacité du projet /4 points","Efficacité dans les rôles de chronométreur et d'obserrvateur /4 points"]
[null,null,null,null,null,"Classe/Groupe",null,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,null,null,null,null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Demi fond  .pdf"]
[null,null,null,null,null,null,"Parcours  1",null,null,"Parcours  2",null,null,"Parcours  3",null,null,"Parcours  4"]
[null,null,null,null,null,null,"Durée du parcours",null,null,"Durée du parcours",null,null,"Durée du parcours",null,null,"Durée du parcours"]
[null,"Nom- Prénom","Sexe","Classe","Note","VMA","projet d'allure en % VMA","distance parcourue","% VMA réalisé","projet d'allure en % VMA","distance parcourue","% VMA réalisé","projet d'allure en % VMA","distance parcourue","% VMA réalisé","projet d'allure en % VMA","distance parcourue","% VMA réalisé",null,null,null,null,null,"Vitesse moyenne projet","V P1","V P2","VP3","VP4","V moyenne réalisée",null,null,"Coureur avec peu de repères sur soi",null,null,null,"Juge dilettante"]
[1,null,null,null,{"$f":"IF(OR(S7=\"\",T7=\"\",U1:U7=\"\"),\"\",S7+T7+U7+V7)","v":""},null,null,null,{"$f":"IF(OR(H7=\"\",$I$5=\"\"),\"\",(((H7/($I$5*60))*3.6)/$F7)*100)","v":""},null,null,{"$f":"IF(OR(K7=\"\",$L$5=\"\"),\"\",(((K7/($L$5*60))*3.6)/$F7)*100)","v":""},null,null,{"$f":"IF(OR(N7=\"\",$O$5=\"\"),\"\",(((N7/($O$5*60))*3.6)/$F7)*100)","v":""},null,null,{"$f":"IF(OR(Q7=\"\",$R$5=\"\"),\"\",(((Q7/($R$5*60))*3.6)/$F7)*100)","v":""},{"$f":"IF(W7=\"\",\"\",IF(W7<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W7,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X7=\"\",AC7=\"\"),\"\",IF((ABS(AC7-X7))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC7-X7),Feuil2!$J$4:$J$6,-1))))","v":""},null,{"$f":"IF(I7=\"\",\"\",AVERAGE(I7,L7,O7,R7))","v":""},{"$f":"IF(G7=\"\",\"\",IF($R$5=\"\",((G7+J7+M7)*F7)/300,((G7+J7+M7+P7)*F7)/400))","v":""},{"$f":"IF(OR($I$5=\"\",H7=\"\"),\"\",(H7/($I$5*60))*3.6)","v":""},{"$f":"IF(OR($L$5=\"\",K7=\"\"),\"\",(K7/($L$5*60))*3.6)","v":""},{"$f":"IF(OR($O$5=\"\",N7=\"\"),\"\",(N7/($O$5*60))*3.6)","v":""},{"$f":"IF(OR($R$5=\"\",AA7=\"\"),\"\",(Q7/($R$5*60))*3.6)","v":""},{"$f":"IF(Y7=\"\",\"\",(IF(AB7=\"\",(Y7+Z7+AA7),Y7+Z7+AA7+AB7))/(IF(AB7=\"\",3,4)))","v":""},null,null,0,null,null,null,0]
[2,null,null,null,{"$f":"IF(OR(S8=\"\",T8=\"\",U5:U8=\"\"),\"\",S8+T8+U8+V8)","v":""},null,null,null,{"$f":"IF(OR(H8=\"\",$I$5=\"\"),\"\",(((H8/($I$5*60))*3.6)/$F8)*100)","v":""},null,null,{"$f":"IF(OR(K8=\"\",$L$5=\"\"),\"\",(((K8/($L$5*60))*3.6)/$F8)*100)","v":""},null,null,{"$f":"IF(OR(N8=\"\",$O$5=\"\"),\"\",(((N8/($O$5*60))*3.6)/$F8)*100)","v":""},null,null,{"$f":"IF(OR(Q8=\"\",$R$5=\"\"),\"\",(((Q8/($R$5*60))*3.6)/$F8)*100)","v":""},{"$f":"IF(W8=\"\",\"\",IF(W8<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W8,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X8=\"\",AC8=\"\"),\"\",IF((ABS(AC8-X8))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC8-X8),Feuil2!$J$4:$J$6,-1))))","v":""},null,{"$f":"IF(I8=\"\",\"\",AVERAGE(I8,L8,O8,R8))","v":""},{"$f":"IF(G8=\"\",\"\",IF($R$5=\"\",((G8+J8+M8)*F8)/300,((G8+J8+M8+P8)*F8)/400))","v":""},{"$f":"IF(OR($I$5=\"\",H8=\"\"),\"\",(H8/($I$5*60))*3.6)","v":""},{"$f":"IF(OR($L$5=\"\",K8=\"\"),\"\",(K8/($L$5*60))*3.6)","v":""},{"$f":"IF(OR($O$5=\"\",N8=\"\"),\"\",(N8/($O$5*60))*3.6)","v":""},{"$f":"IF(OR($R$5=\"\",AA8=\"\"),\"\",(Q8/($R$5*60))*3.6)","v":""},{"$f":"IF(Y8=\"\",\"\",(IF(AB8=\"\",(Y8+Z8+AA8),Y8+Z8+AA8+AB8))/(IF(AB8=\"\",3,4)))","v":""},null,null,0.5,null,null,null,0.5]
[3,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W9=\"\",\"\",IF(W9<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W9,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X9=\"\",AC9=\"\"),\"\",IF((ABS(AC9-X9))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC9-X9),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,1,null,null,null,1]
[4,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W10=\"\",\"\",IF(W10<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W10,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X10=\"\",AC10=\"\"),\"\",IF((ABS(AC10-X10))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC10-X10),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,1.5,null,null,null,1.5]
[5,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W11=\"\",\"\",IF(W11<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W11,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X11=\"\",AC11=\"\"),\"\",IF((ABS(AC11-X11))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC11-X11),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,2,null,null,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W12=\"\",\"\",IF(W12<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W12,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X12=\"\",AC12=\"\"),\"\",IF((ABS(AC12-X12))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC12-X12),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,"Coureur en construction d'autonomie",null,null,null,2]
[7,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W13=\"\",\"\",IF(W13<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W13,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X13=\"\",AC13=\"\"),\"\",IF((ABS(AC13-X13))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC13-X13),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,2.25,null,null,null,2.5]
[8,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W14=\"\",\"\",IF(W14<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W14,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X14=\"\",AC14=\"\"),\"\",IF((ABS(AC14-X14))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC14-X14),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,2.5,null,null,null,3]
[9,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W15=\"\",\"\",IF(W15<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W15,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X15=\"\",AC15=\"\"),\"\",IF((ABS(AC15-X15))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC15-X15),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,2.75,null,null,null,"Juge multifonctions"]
[10,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W16=\"\",\"\",IF(W16<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W16,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X16=\"\",AC16=\"\"),\"\",IF((ABS(AC16-X16))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC16-X16),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,3,null,null,null,3.5]
[11,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W17=\"\",\"\",IF(W17<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W17,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X17=\"\",AC17=\"\"),\"\",IF((ABS(AC17-X17))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC17-X17),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,"Coureur autonome",null,null,null,4]
[12,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W18=\"\",\"\",IF(W18<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W18,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X18=\"\",AC18=\"\"),\"\",IF((ABS(AC18-X18))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC18-X18),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,3.25]
[13,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W19=\"\",\"\",IF(W19<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W19,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X19=\"\",AC19=\"\"),\"\",IF((ABS(AC19-X19))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC19-X19),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,3.5]
[14,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W20=\"\",\"\",IF(W20<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W20,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X20=\"\",AC20=\"\"),\"\",IF((ABS(AC20-X20))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC20-X20),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,3.75]
[15,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W21=\"\",\"\",IF(W21<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W21,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X21=\"\",AC21=\"\"),\"\",IF((ABS(AC21-X21))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC21-X21),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","","",null,null,4]
[16,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W22=\"\",\"\",IF(W22<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W22,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X22=\"\",AC22=\"\"),\"\",IF((ABS(AC22-X22))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC22-X22),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[17,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W23=\"\",\"\",IF(W23<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W23,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X23=\"\",AC23=\"\"),\"\",IF((ABS(AC23-X23))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC23-X23),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[18,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W24=\"\",\"\",IF(W24<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W24,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X24=\"\",AC24=\"\"),\"\",IF((ABS(AC24-X24))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC24-X24),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[19,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W25=\"\",\"\",IF(W25<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W25,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X25=\"\",AC25=\"\"),\"\",IF((ABS(AC25-X25))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC25-X25),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[20,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W26=\"\",\"\",IF(W26<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W26,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X26=\"\",AC26=\"\"),\"\",IF((ABS(AC26-X26))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC26-X26),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[21,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W27=\"\",\"\",IF(W27<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W27,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X27=\"\",AC27=\"\"),\"\",IF((ABS(AC27-X27))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC27-X27),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[22,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W28=\"\",\"\",IF(W28<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W28,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X28=\"\",AC28=\"\"),\"\",IF((ABS(AC28-X28))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC28-X28),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[23,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W29=\"\",\"\",IF(W29<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W29,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X29=\"\",AC29=\"\"),\"\",IF((ABS(AC29-X29))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC29-X29),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[24,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W30=\"\",\"\",IF(W30<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W30,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X30=\"\",AC30=\"\"),\"\",IF((ABS(AC30-X30))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC30-X30),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[25,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W31=\"\",\"\",IF(W31<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W31,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X31=\"\",AC31=\"\"),\"\",IF((ABS(AC31-X31))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC31-X31),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[26,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W32=\"\",\"\",IF(W32<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W32,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X32=\"\",AC32=\"\"),\"\",IF((ABS(AC32-X32))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC32-X32),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[27,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W33=\"\",\"\",IF(W33<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W33,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X33=\"\",AC33=\"\"),\"\",IF((ABS(AC33-X33))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC33-X33),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[28,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W34=\"\",\"\",IF(W34<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W34,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X34=\"\",AC34=\"\"),\"\",IF((ABS(AC34-X34))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC34-X34),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[29,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(W35=\"\",\"\",IF(W35<Feuil2!$C$1,0,INDEX(Feuil2!$B$1:$B$15,MATCH(Feuil1!W35,Feuil2!$C$1:$C$15,1))))","v":""},null,{"$f":"IF(OR(X35=\"\",AC35=\"\"),\"\",IF((ABS(AC35-X35))>0.55,0,INDEX(Feuil2!$K$4:$K$6,MATCH(ABS(AC35-X35),Feuil2!$J$4:$J$6,-1))))","v":""},null,"","","","","","",""]
[null,null,"Moyenne générale",null,{"$f":"IF($E$7=\"\",\"\",AVERAGE($E$6:$E$35))","v":""}]
[null,null,"Moyenne filles",null,{"$f":"IF($E$7=\"\",\"\",IF(C7=\"\",\"\",AVERAGE($E$6:$E$35)))","v":""}]
[null,null,"Moyenne garçons",null,{"$f":"IF($E$7=\"\",\"\",IF(C7=\"\",\"\",AVERAGE($E$6:$E$35)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,0,75,null,null,"Coureur avec peu de repères sur soi"]
[null,1,80,null,null,0]
[null,2,85,null,null,0.5]
[null,2.5,86,null,null,1,null,null,null,0.55000000000000004,0]
[null,3,87,null,null,1.5,null,null,null,0.5,4]
[null,3.5,88,null,null,2,null,null,null,0.49,8]
[null,4,89,null,null,"Coureur en construction d'autonomie"]
[null,4.5,90,null,null,2.25]
[null,5,92,null,null,2.5]
[null,5.5,93,null,null,2.75]
[null,6,94,null,null,3]
[null,6.5,95,null,null,"Coureur autonome",null,null,null,"Juge dilettante"]
[null,7,96,null,null,3.25,null,null,null,0]
[null,7.5,98,null,null,3.5,null,null,null,0.5]
[null,8,100,null,null,3.75,null,null,null,1]
[null,null,null,null,null,4,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,"Juge fiable"]
[null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Juge multifonctions"]
[null,null,null,null,null,null,null,null,null,3.5]
[null,null,null,null,null,null,null,null,null,4]

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