{"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":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,5,3,7],[3,8,3,10]]}
[null,null,"Fiche évaluation DNB",null,null,null,null,null,"APSA:",null,null,"Javelot N2"]
[null,null,"Classe/Groupe",null,null,null,null,null,"Professeur:",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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Javelot N2  .pdf"]
[null,null,null,null,null,"Lancer sans élan",null,null,"Lancer avec élan"]
[null,"Nom- Prénom","Sexe","Classe","Note","Essai1","Essai 2","Essai 3","Essai1","Essai 2","Essai 3","Performance retenue","Note de performance /8 points","Efficacité /8 points","Efficacité dans le rôle d'observateur et de juge /4 points",null,null,null,null,"lanceur arrêté",null,null,"Juge dilletante"]
[1,null,null,null,{"$f":"IF(M6=\"\",\"\",M6+N6+O6)","v":""},null,null,null,null,null,null,{"$f":"IF(F6=\"\",\"\",(MAX(F6:H6))+MAX(I6:K6))","v":""},{"$f":"IF(L6=\"\",\"\",IF(C6=\"F\",IF(Q6=0,R6,IF(L6>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$C$2:$C$10,-1)))),IF(Q6=0,S6,IF(L6>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,{"$f":"IF(MAX(F6:H6)>MAX(I6:K6),0,1)","v":1},{"$f":"IF(AND(C6=\"F\",Q6=0,IF(L6>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C6=\"M\",Q6=0,IF(L6>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L6,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},0,null,null,0]
[2,null,null,null,{"$f":"IF(M7=\"\",\"\",M7+N7+O7)","v":""},null,null,null,null,null,null,{"$f":"IF(F7=\"\",\"\",(MAX(G7:K7))+MAX(F7:H7))","v":""},{"$f":"IF(L7=\"\",\"\",IF(C7=\"F\",IF(Q7=0,R7,IF(L7>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$C$2:$C$10,-1)))),IF(Q7=0,S7,IF(L7>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,{"$f":"IF(MAX(F7:H7)>MAX(I7:K7),0,1)","v":1},{"$f":"IF(AND(C7=\"F\",Q7=0,IF(L7>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C7=\"M\",Q7=0,IF(L7>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L7,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},1,null,null,0.5]
[3,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L8=\"\",\"\",IF(C8=\"F\",IF(Q8=0,R8,IF(L8>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$C$2:$C$10,-1)))),IF(Q8=0,S8,IF(L8>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C8=\"F\",Q8=0,IF(L8>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C8=\"M\",Q8=0,IF(L8>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L8,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},2,null,null,1]
[4,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L9=\"\",\"\",IF(C9=\"F\",IF(Q9=0,R9,IF(L9>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$C$2:$C$10,-1)))),IF(Q9=0,S9,IF(L9>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C9=\"F\",Q9=0,IF(L9>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C9=\"M\",Q9=0,IF(L9>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L9,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},3,null,null,1.5]
[5,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L10=\"\",\"\",IF(C10=\"F\",IF(Q10=0,R10,IF(L10>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$C$2:$C$10,-1)))),IF(Q10=0,S10,IF(L10>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C10=\"F\",Q10=0,IF(L10>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C10=\"M\",Q10=0,IF(L10>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L10,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},4,null,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L11=\"\",\"\",IF(C11=\"F\",IF(Q11=0,R11,IF(L11>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$C$2:$C$10,-1)))),IF(Q11=0,S11,IF(L11>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C11=\"F\",Q11=0,IF(L11>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C11=\"M\",Q11=0,IF(L11>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L11,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},"Lanceur en mouvement",null,null,2]
[7,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L12=\"\",\"\",IF(C12=\"F\",IF(Q12=0,R12,IF(L12>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$C$2:$C$10,-1)))),IF(Q12=0,S12,IF(L12>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C12=\"F\",Q12=0,IF(L12>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C12=\"M\",Q12=0,IF(L12>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L12,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},4.5,null,null,2.5]
[8,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L13=\"\",\"\",IF(C13=\"F\",IF(Q13=0,R13,IF(L13>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$C$2:$C$10,-1)))),IF(Q13=0,S13,IF(L13>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C13=\"F\",Q13=0,IF(L13>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C13=\"M\",Q13=0,IF(L13>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L13,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},5,null,null,3]
[9,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L14=\"\",\"\",IF(C14=\"F\",IF(Q14=0,R14,IF(L14>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$C$2:$C$10,-1)))),IF(Q14=0,S14,IF(L14>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C14=\"F\",Q14=0,IF(L14>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C14=\"M\",Q14=0,IF(L14>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L14,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},5.5,null,null,"Juge multifonction"]
[10,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L15=\"\",\"\",IF(C15=\"F\",IF(Q15=0,R15,IF(L15>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$C$2:$C$10,-1)))),IF(Q15=0,S15,IF(L15>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C15=\"F\",Q15=0,IF(L15>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C15=\"M\",Q15=0,IF(L15>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L15,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},6,null,null,3.5]
[11,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L16=\"\",\"\",IF(C16=\"F\",IF(Q16=0,R16,IF(L16>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$C$2:$C$10,-1)))),IF(Q16=0,S16,IF(L16>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C16=\"F\",Q16=0,IF(L16>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C16=\"M\",Q16=0,IF(L16>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L16,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},"Lanceur accélérateur",null,null,4]
[12,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L17=\"\",\"\",IF(C17=\"F\",IF(Q17=0,R17,IF(L17>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$C$2:$C$10,-1)))),IF(Q17=0,S17,IF(L17>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C17=\"F\",Q17=0,IF(L17>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C17=\"M\",Q17=0,IF(L17>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L17,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},6.5]
[13,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L18=\"\",\"\",IF(C18=\"F\",IF(Q18=0,R18,IF(L18>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$C$2:$C$10,-1)))),IF(Q18=0,S18,IF(L18>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C18=\"F\",Q18=0,IF(L18>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C18=\"M\",Q18=0,IF(L18>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L18,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},7]
[14,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L19=\"\",\"\",IF(C19=\"F\",IF(Q19=0,R19,IF(L19>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$C$2:$C$10,-1)))),IF(Q19=0,S19,IF(L19>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C19=\"F\",Q19=0,IF(L19>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C19=\"M\",Q19=0,IF(L19>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L19,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},7.5]
[15,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L20=\"\",\"\",IF(C20=\"F\",IF(Q20=0,R20,IF(L20>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$C$2:$C$10,-1)))),IF(Q20=0,S20,IF(L20>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C20=\"F\",Q20=0,IF(L20>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C20=\"M\",Q20=0,IF(L20>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L20,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}},8]
[16,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L21=\"\",\"\",IF(C21=\"F\",IF(Q21=0,R21,IF(L21>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$C$2:$C$10,-1)))),IF(Q21=0,S21,IF(L21>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C21=\"F\",Q21=0,IF(L21>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C21=\"M\",Q21=0,IF(L21>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L21,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[17,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L22=\"\",\"\",IF(C22=\"F\",IF(Q22=0,R22,IF(L22>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$C$2:$C$10,-1)))),IF(Q22=0,S22,IF(L22>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C22=\"F\",Q22=0,IF(L22>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C22=\"M\",Q22=0,IF(L22>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L22,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[18,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L23=\"\",\"\",IF(C23=\"F\",IF(Q23=0,R23,IF(L23>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$C$2:$C$10,-1)))),IF(Q23=0,S23,IF(L23>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C23=\"F\",Q23=0,IF(L23>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C23=\"M\",Q23=0,IF(L23>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L23,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[19,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L24=\"\",\"\",IF(C24=\"F\",IF(Q24=0,R24,IF(L24>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$C$2:$C$10,-1)))),IF(Q24=0,S24,IF(L24>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C24=\"F\",Q24=0,IF(L24>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C24=\"M\",Q24=0,IF(L24>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L24,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[20,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L25=\"\",\"\",IF(C25=\"F\",IF(Q25=0,R25,IF(L25>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$C$2:$C$10,-1)))),IF(Q25=0,S25,IF(L25>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C25=\"F\",Q25=0,IF(L25>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C25=\"M\",Q25=0,IF(L25>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L25,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[21,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L26=\"\",\"\",IF(C26=\"F\",IF(Q26=0,R26,IF(L26>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$C$2:$C$10,-1)))),IF(Q26=0,S26,IF(L26>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C26=\"F\",Q26=0,IF(L26>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C26=\"M\",Q26=0,IF(L26>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L26,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[22,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L27=\"\",\"\",IF(C27=\"F\",IF(Q27=0,R27,IF(L27>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$C$2:$C$10,-1)))),IF(Q27=0,S27,IF(L27>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C27=\"F\",Q27=0,IF(L27>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C27=\"M\",Q27=0,IF(L27>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L27,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[23,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L28=\"\",\"\",IF(C28=\"F\",IF(Q28=0,R28,IF(L28>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$C$2:$C$10,-1)))),IF(Q28=0,S28,IF(L28>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C28=\"F\",Q28=0,IF(L28>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C28=\"M\",Q28=0,IF(L28>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L28,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[24,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L29=\"\",\"\",IF(C29=\"F\",IF(Q29=0,R29,IF(L29>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$C$2:$C$10,-1)))),IF(Q29=0,S29,IF(L29>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C29=\"F\",Q29=0,IF(L29>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C29=\"M\",Q29=0,IF(L29>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L29,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[25,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L30=\"\",\"\",IF(C30=\"F\",IF(Q30=0,R30,IF(L30>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$C$2:$C$10,-1)))),IF(Q30=0,S30,IF(L30>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C30=\"F\",Q30=0,IF(L30>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C30=\"M\",Q30=0,IF(L30>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L30,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[26,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L31=\"\",\"\",IF(C31=\"F\",IF(Q31=0,R31,IF(L31>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$C$2:$C$10,-1)))),IF(Q31=0,S31,IF(L31>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C31=\"F\",Q31=0,IF(L31>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C31=\"M\",Q31=0,IF(L31>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L31,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[27,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L32=\"\",\"\",IF(C32=\"F\",IF(Q32=0,R32,IF(L32>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$C$2:$C$10,-1)))),IF(Q32=0,S32,IF(L32>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C32=\"F\",Q32=0,IF(L32>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C32=\"M\",Q32=0,IF(L32>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L32,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[28,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L33=\"\",\"\",IF(C33=\"F\",IF(Q33=0,R33,IF(L33>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$C$2:$C$10,-1)))),IF(Q33=0,S33,IF(L33>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C33=\"F\",Q33=0,IF(L33>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C33=\"M\",Q33=0,IF(L33>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L33,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[29,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L34=\"\",\"\",IF(C34=\"F\",IF(Q34=0,R34,IF(L34>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$C$2:$C$10,-1)))),IF(Q34=0,S34,IF(L34>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C34=\"F\",Q34=0,IF(L34>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C34=\"M\",Q34=0,IF(L34>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L34,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[30,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",IF(C35=\"F\",IF(Q35=0,R35,IF(L35>45,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$C$2:$C$10,-1)))),IF(Q35=0,S35,IF(L35>60,8,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$D$2:$D$10,-1))))))","v":""},null,null,null,1,{"$f":"IF(AND(C35=\"F\",Q35=0,IF(L35>45,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$C$2:$C$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$C$2:$C$10,-1)))","v":{"$error":"#N/A"}},{"$f":"IF(AND(C35=\"M\",Q35=0,IF(L35>60,2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$D$2:$D$10,-1))>2)),2,INDEX(Feuil2!$E$2:$E$10,MATCH(Feuil1!L35,Feuil2!$D$2:$D$10,-1)))","v":{"$error":"#N/A"}}]
[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":"Feuil2","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,45,60,8,null,null,"lanceur arrêté",null,null,"Juge dilletante"]
[null,null,39,53,7,null,null,0,null,null,0]
[null,null,34,46,6,null,null,1,null,null,0.5]
[null,null,29,40,5,null,null,2,null,null,1]
[null,null,25,34,4,null,null,3,null,null,1.5]
[null,null,21,28,3,null,null,4,null,null,"Juge fiable"]
[null,null,18,23,2,null,null,"Lanceur en mouvement",null,null,2]
[null,null,15,19,1,null,null,4.5,null,null,2.5]
[null,null,13,17,0,null,null,5,null,null,3]
[null,null,null,null,null,null,null,5.5,null,null,"Juge multifonction"]
[null,null,null,null,null,null,null,6,null,null,3.5]
[null,null,null,null,null,null,null,"Lanceur accélérateur",null,null,4]
[null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,8]

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