{"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":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":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fiche évaluation DNB",null,null,null,"APSA:","Natation de vitesse N2"]
[null,null,"Classe/Groupe",null,null,null,"Professeur:",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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Natation de vitesse N2  .pdf"]
[]
[null,"Nom- Prénom","Sexe","Classe","Note","Distance nagée (d)","Temps de parcours en secondes","Note Temps/distance 8 points","nombre de cycles de bras","Note d'efficacité du rapport amplitude/fréquence 8 points","Efficacité du starter, chronométreur, observateur 4 points",null,null,"Distance nagée"]
[1,null,null,null,{"$f":"IF(H6=\"\",\"\",H6+J6+K6)","v":""},null,null,{"$f":"IF(F6=\"\",\"\",IF(F6<50,VLOOKUP(F6,Feuil2!$B$3:$C$6,2,FALSE),(IF(C6=\"F\",(IF(G6=\"\",\"remplir temps de parcours\",IF(G6<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G6,Feuil2!$E$5:$E$12,1))))),IF(G6=\"\",\"remplir le temps de parcours\",IF(G6<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G6,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F6=\"\",\"\",IF(F6<50,0,IF(I6<25,8,IF(I6=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I6,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,12.5]
[2,null,null,null,{"$f":"IF(H7=\"\",\"\",H7+J7+K7)","v":""},null,null,{"$f":"IF(F7=\"\",\"\",IF(F7<50,VLOOKUP(F7,Feuil2!$B$3:$C$6,2,FALSE),(IF(C7=\"F\",(IF(G7=\"\",\"remplir temps de parcours\",IF(G7<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G7,Feuil2!$E$5:$E$12,1))))),IF(G7=\"\",\"remplir le temps de parcours\",IF(G7<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G7,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F7=\"\",\"\",IF(F7<50,0,IF(I7<25,8,IF(I7=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I7,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,25]
[3,null,null,null,"",null,null,{"$f":"IF(F8=\"\",\"\",IF(F8<50,VLOOKUP(F8,Feuil2!$B$3:$C$6,2,FALSE),(IF(C8=\"F\",(IF(G8=\"\",\"remplir temps de parcours\",IF(G8<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G8,Feuil2!$E$5:$E$12,1))))),IF(G8=\"\",\"remplir le temps de parcours\",IF(G8<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G8,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F8=\"\",\"\",IF(F8<50,0,IF(I8<25,8,IF(I8=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I8,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,37.5]
[4,null,null,null,"",null,null,{"$f":"IF(F9=\"\",\"\",IF(F9<50,VLOOKUP(F9,Feuil2!$B$3:$C$6,2,FALSE),(IF(C9=\"F\",(IF(G9=\"\",\"remplir temps de parcours\",IF(G9<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G9,Feuil2!$E$5:$E$12,1))))),IF(G9=\"\",\"remplir le temps de parcours\",IF(G9<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G9,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F9=\"\",\"\",IF(F9<50,0,IF(I9<25,8,IF(I9=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I9,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,50]
[5,null,null,null,"",null,null,{"$f":"IF(F10=\"\",\"\",IF(F10<50,VLOOKUP(F10,Feuil2!$B$3:$C$6,2,FALSE),(IF(C10=\"F\",(IF(G10=\"\",\"remplir temps de parcours\",IF(G10<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G10,Feuil2!$E$5:$E$12,1))))),IF(G10=\"\",\"remplir le temps de parcours\",IF(G10<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G10,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F10=\"\",\"\",IF(F10<50,0,IF(I10<25,8,IF(I10=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I10,Feuil2!$J$6:$J$18,1))))))","v":""}]
[6,null,null,null,"",null,null,{"$f":"IF(F11=\"\",\"\",IF(F11<50,VLOOKUP(F11,Feuil2!$B$3:$C$6,2,FALSE),(IF(C11=\"F\",(IF(G11=\"\",\"remplir temps de parcours\",IF(G11<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G11,Feuil2!$E$5:$E$12,1))))),IF(G11=\"\",\"remplir le temps de parcours\",IF(G11<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G11,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F11=\"\",\"\",IF(F11<50,0,IF(I11<25,8,IF(I11=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I11,Feuil2!$J$6:$J$18,1))))))","v":""}]
[7,null,null,null,"",null,null,{"$f":"IF(F12=\"\",\"\",IF(F12<50,VLOOKUP(F12,Feuil2!$B$3:$C$6,2,FALSE),(IF(C12=\"F\",(IF(G12=\"\",\"remplir temps de parcours\",IF(G12<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G12,Feuil2!$E$5:$E$12,1))))),IF(G12=\"\",\"remplir le temps de parcours\",IF(G12<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G12,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F12=\"\",\"\",IF(F12<50,0,IF(I12<25,8,IF(I12=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I12,Feuil2!$J$6:$J$18,1))))))","v":""}]
[8,null,null,null,"",null,null,{"$f":"IF(F13=\"\",\"\",IF(F13<50,VLOOKUP(F13,Feuil2!$B$3:$C$6,2,FALSE),(IF(C13=\"F\",(IF(G13=\"\",\"remplir temps de parcours\",IF(G13<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G13,Feuil2!$E$5:$E$12,1))))),IF(G13=\"\",\"remplir le temps de parcours\",IF(G13<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G13,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F13=\"\",\"\",IF(F13<50,0,IF(I13<25,8,IF(I13=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I13,Feuil2!$J$6:$J$18,1))))))","v":""}]
[9,null,null,null,"",null,null,{"$f":"IF(F14=\"\",\"\",IF(F14<50,VLOOKUP(F14,Feuil2!$B$3:$C$6,2,FALSE),(IF(C14=\"F\",(IF(G14=\"\",\"remplir temps de parcours\",IF(G14<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G14,Feuil2!$E$5:$E$12,1))))),IF(G14=\"\",\"remplir le temps de parcours\",IF(G14<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G14,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F14=\"\",\"\",IF(F14<50,0,IF(I14<25,8,IF(I14=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I14,Feuil2!$J$6:$J$18,1))))))","v":""}]
[10,null,null,null,"",null,null,{"$f":"IF(F15=\"\",\"\",IF(F15<50,VLOOKUP(F15,Feuil2!$B$3:$C$6,2,FALSE),(IF(C15=\"F\",(IF(G15=\"\",\"remplir temps de parcours\",IF(G15<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G15,Feuil2!$E$5:$E$12,1))))),IF(G15=\"\",\"remplir le temps de parcours\",IF(G15<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G15,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F15=\"\",\"\",IF(F15<50,0,IF(I15<25,8,IF(I15=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I15,Feuil2!$J$6:$J$18,1))))))","v":""}]
[11,null,null,null,"",null,null,{"$f":"IF(F16=\"\",\"\",IF(F16<50,VLOOKUP(F16,Feuil2!$B$3:$C$6,2,FALSE),(IF(C16=\"F\",(IF(G16=\"\",\"remplir temps de parcours\",IF(G16<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G16,Feuil2!$E$5:$E$12,1))))),IF(G16=\"\",\"remplir le temps de parcours\",IF(G16<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G16,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F16=\"\",\"\",IF(F16<50,0,IF(I16<25,8,IF(I16=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I16,Feuil2!$J$6:$J$18,1))))))","v":""}]
[12,null,null,null,"",null,null,{"$f":"IF(F17=\"\",\"\",IF(F17<50,VLOOKUP(F17,Feuil2!$B$3:$C$6,2,FALSE),(IF(C17=\"F\",(IF(G17=\"\",\"remplir temps de parcours\",IF(G17<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G17,Feuil2!$E$5:$E$12,1))))),IF(G17=\"\",\"remplir le temps de parcours\",IF(G17<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G17,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F17=\"\",\"\",IF(F17<50,0,IF(I17<25,8,IF(I17=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I17,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,"Juge diléttante"]
[13,null,null,null,"",null,null,{"$f":"IF(F18=\"\",\"\",IF(F18<50,VLOOKUP(F18,Feuil2!$B$3:$C$6,2,FALSE),(IF(C18=\"F\",(IF(G18=\"\",\"remplir temps de parcours\",IF(G18<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G18,Feuil2!$E$5:$E$12,1))))),IF(G18=\"\",\"remplir le temps de parcours\",IF(G18<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G18,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F18=\"\",\"\",IF(F18<50,0,IF(I18<25,8,IF(I18=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I18,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,0]
[14,null,null,null,"",null,null,{"$f":"IF(F19=\"\",\"\",IF(F19<50,VLOOKUP(F19,Feuil2!$B$3:$C$6,2,FALSE),(IF(C19=\"F\",(IF(G19=\"\",\"remplir temps de parcours\",IF(G19<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G19,Feuil2!$E$5:$E$12,1))))),IF(G19=\"\",\"remplir le temps de parcours\",IF(G19<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G19,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F19=\"\",\"\",IF(F19<50,0,IF(I19<25,8,IF(I19=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I19,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,0.5]
[15,null,null,null,"",null,null,{"$f":"IF(F20=\"\",\"\",IF(F20<50,VLOOKUP(F20,Feuil2!$B$3:$C$6,2,FALSE),(IF(C20=\"F\",(IF(G20=\"\",\"remplir temps de parcours\",IF(G20<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G20,Feuil2!$E$5:$E$12,1))))),IF(G20=\"\",\"remplir le temps de parcours\",IF(G20<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G20,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F20=\"\",\"\",IF(F20<50,0,IF(I20<25,8,IF(I20=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I20,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,1]
[16,null,null,null,"",null,null,{"$f":"IF(F21=\"\",\"\",IF(F21<50,VLOOKUP(F21,Feuil2!$B$3:$C$6,2,FALSE),(IF(C21=\"F\",(IF(G21=\"\",\"remplir temps de parcours\",IF(G21<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G21,Feuil2!$E$5:$E$12,1))))),IF(G21=\"\",\"remplir le temps de parcours\",IF(G21<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G21,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F21=\"\",\"\",IF(F21<50,0,IF(I21<25,8,IF(I21=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I21,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,1.5]
[17,null,null,null,"",null,null,{"$f":"IF(F22=\"\",\"\",IF(F22<50,VLOOKUP(F22,Feuil2!$B$3:$C$6,2,FALSE),(IF(C22=\"F\",(IF(G22=\"\",\"remplir temps de parcours\",IF(G22<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G22,Feuil2!$E$5:$E$12,1))))),IF(G22=\"\",\"remplir le temps de parcours\",IF(G22<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G22,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F22=\"\",\"\",IF(F22<50,0,IF(I22<25,8,IF(I22=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I22,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,"Juge fiable"]
[18,null,null,null,"",null,null,{"$f":"IF(F23=\"\",\"\",IF(F23<50,VLOOKUP(F23,Feuil2!$B$3:$C$6,2,FALSE),(IF(C23=\"F\",(IF(G23=\"\",\"remplir temps de parcours\",IF(G23<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G23,Feuil2!$E$5:$E$12,1))))),IF(G23=\"\",\"remplir le temps de parcours\",IF(G23<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G23,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F23=\"\",\"\",IF(F23<50,0,IF(I23<25,8,IF(I23=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I23,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,2]
[19,null,null,null,"",null,null,{"$f":"IF(F24=\"\",\"\",IF(F24<50,VLOOKUP(F24,Feuil2!$B$3:$C$6,2,FALSE),(IF(C24=\"F\",(IF(G24=\"\",\"remplir temps de parcours\",IF(G24<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G24,Feuil2!$E$5:$E$12,1))))),IF(G24=\"\",\"remplir le temps de parcours\",IF(G24<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G24,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F24=\"\",\"\",IF(F24<50,0,IF(I24<25,8,IF(I24=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I24,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,2.5]
[20,null,null,null,"",null,null,{"$f":"IF(F25=\"\",\"\",IF(F25<50,VLOOKUP(F25,Feuil2!$B$3:$C$6,2,FALSE),(IF(C25=\"F\",(IF(G25=\"\",\"remplir temps de parcours\",IF(G25<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G25,Feuil2!$E$5:$E$12,1))))),IF(G25=\"\",\"remplir le temps de parcours\",IF(G25<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G25,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F25=\"\",\"\",IF(F25<50,0,IF(I25<25,8,IF(I25=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I25,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,3]
[21,null,null,null,"",null,null,{"$f":"IF(F26=\"\",\"\",IF(F26<50,VLOOKUP(F26,Feuil2!$B$3:$C$6,2,FALSE),(IF(C26=\"F\",(IF(G26=\"\",\"remplir temps de parcours\",IF(G26<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G26,Feuil2!$E$5:$E$12,1))))),IF(G26=\"\",\"remplir le temps de parcours\",IF(G26<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G26,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F26=\"\",\"\",IF(F26<50,0,IF(I26<25,8,IF(I26=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I26,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,"Juge multifonctions"]
[22,null,null,null,"",null,null,{"$f":"IF(F27=\"\",\"\",IF(F27<50,VLOOKUP(F27,Feuil2!$B$3:$C$6,2,FALSE),(IF(C27=\"F\",(IF(G27=\"\",\"remplir temps de parcours\",IF(G27<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G27,Feuil2!$E$5:$E$12,1))))),IF(G27=\"\",\"remplir le temps de parcours\",IF(G27<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G27,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F27=\"\",\"\",IF(F27<50,0,IF(I27<25,8,IF(I27=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I27,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,3.5]
[23,null,null,null,"",null,null,{"$f":"IF(F28=\"\",\"\",IF(F28<50,VLOOKUP(F28,Feuil2!$B$3:$C$6,2,FALSE),(IF(C28=\"F\",(IF(G28=\"\",\"remplir temps de parcours\",IF(G28<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G28,Feuil2!$E$5:$E$12,1))))),IF(G28=\"\",\"remplir le temps de parcours\",IF(G28<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G28,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F28=\"\",\"\",IF(F28<50,0,IF(I28<25,8,IF(I28=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I28,Feuil2!$J$6:$J$18,1))))))","v":""},null,null,null,4]
[24,null,null,null,"",null,null,{"$f":"IF(F29=\"\",\"\",IF(F29<50,VLOOKUP(F29,Feuil2!$B$3:$C$6,2,FALSE),(IF(C29=\"F\",(IF(G29=\"\",\"remplir temps de parcours\",IF(G29<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G29,Feuil2!$E$5:$E$12,1))))),IF(G29=\"\",\"remplir le temps de parcours\",IF(G29<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G29,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F29=\"\",\"\",IF(F29<50,0,IF(I29<25,8,IF(I29=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I29,Feuil2!$J$6:$J$18,1))))))","v":""}]
[25,null,null,null,"",null,null,{"$f":"IF(F30=\"\",\"\",IF(F30<50,VLOOKUP(F30,Feuil2!$B$3:$C$6,2,FALSE),(IF(C30=\"F\",(IF(G30=\"\",\"remplir temps de parcours\",IF(G30<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G30,Feuil2!$E$5:$E$12,1))))),IF(G30=\"\",\"remplir le temps de parcours\",IF(G30<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G30,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F30=\"\",\"\",IF(F30<50,0,IF(I30<25,8,IF(I30=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I30,Feuil2!$J$6:$J$18,1))))))","v":""}]
[26,null,null,null,"",null,null,{"$f":"IF(F31=\"\",\"\",IF(F31<50,VLOOKUP(F31,Feuil2!$B$3:$C$6,2,FALSE),(IF(C31=\"F\",(IF(G31=\"\",\"remplir temps de parcours\",IF(G31<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G31,Feuil2!$E$5:$E$12,1))))),IF(G31=\"\",\"remplir le temps de parcours\",IF(G31<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G31,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F31=\"\",\"\",IF(F31<50,0,IF(I31<25,8,IF(I31=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I31,Feuil2!$J$6:$J$18,1))))))","v":""}]
[27,null,null,null,"",null,null,{"$f":"IF(F32=\"\",\"\",IF(F32<50,VLOOKUP(F32,Feuil2!$B$3:$C$6,2,FALSE),(IF(C32=\"F\",(IF(G32=\"\",\"remplir temps de parcours\",IF(G32<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G32,Feuil2!$E$5:$E$12,1))))),IF(G32=\"\",\"remplir le temps de parcours\",IF(G32<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G32,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F32=\"\",\"\",IF(F32<50,0,IF(I32<25,8,IF(I32=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I32,Feuil2!$J$6:$J$18,1))))))","v":""}]
[28,null,null,null,"",null,null,{"$f":"IF(F33=\"\",\"\",IF(F33<50,VLOOKUP(F33,Feuil2!$B$3:$C$6,2,FALSE),(IF(C33=\"F\",(IF(G33=\"\",\"remplir temps de parcours\",IF(G33<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G33,Feuil2!$E$5:$E$12,1))))),IF(G33=\"\",\"remplir le temps de parcours\",IF(G33<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G33,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F33=\"\",\"\",IF(F33<50,0,IF(I33<25,8,IF(I33=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I33,Feuil2!$J$6:$J$18,1))))))","v":""}]
[29,null,null,null,"",null,null,{"$f":"IF(F34=\"\",\"\",IF(F34<50,VLOOKUP(F34,Feuil2!$B$3:$C$6,2,FALSE),(IF(C34=\"F\",(IF(G34=\"\",\"remplir temps de parcours\",IF(G34<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G34,Feuil2!$E$5:$E$12,1))))),IF(G34=\"\",\"remplir le temps de parcours\",IF(G34<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G34,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F34=\"\",\"\",IF(F34<50,0,IF(I34<25,8,IF(I34=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I34,Feuil2!$J$6:$J$18,1))))))","v":""}]
[30,null,null,null,"",null,null,{"$f":"IF(F35=\"\",\"\",IF(F35<50,VLOOKUP(F35,Feuil2!$B$3:$C$6,2,FALSE),(IF(C35=\"F\",(IF(G35=\"\",\"remplir temps de parcours\",IF(G35<42,8,INDEX(Feuil2!$G$5:$G$12,MATCH(G35,Feuil2!$E$5:$E$12,1))))),IF(G35=\"\",\"remplir le temps de parcours\",IF(G35<37,8,(INDEX(Feuil2!$G$6:$G$12,MATCH(G35,Feuil2!$F$6:$F$12,1)))))))))","v":""},null,{"$f":"IF(F35=\"\",\"\",IF(F35<50,0,IF(I35<25,8,IF(I35=\"\",\"\",INDEX(Feuil2!$K$6:$K$18,MATCH(I35,Feuil2!$J$6:$J$18,1))))))","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":"Feuil2","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Temps parcours","filles","Garçons"]
[null,"Distance nagée"]
[null,12.5,0]
[null,25,1]
[null,37.5,1.5,null,"<42","<37",8,null,null,"<25",8]
[null,"37,5<d<50",1.5,null,42,37,8,null,null,25,8]
[null,50,null,null,43,38,7,null,null,26,7.5]
[null,null,null,null,49,44,6,null,null,28,7]
[null,null,null,null,56,51,5,null,null,29,6.5]
[null,35,null,null,63,58,4,null,null,30,6]
[null,null,null,null,71,66,3,null,null,32,5.5]
[null,null,null,null,80,75,2,null,null,34,5]
[null,null,null,null,null,null,null,null,null,35,4.5]
[null,"Juge diléttante",null,null,null,null,null,null,null,36,4]
[null,0,null,null,null,null,null,null,null,37,3]
[null,0.5,null,null,null,null,null,null,null,38,2]
[null,1,null,null,null,null,null,null,null,39,1]
[null,1.5,null,null,null,null,null,null,null,40,0]
[null,"Juge fiable"]
[null,2]
[null,2.5]
[null,3]
[null,"Juge multifonctions"]
[null,3.5]
[null,4]

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