{"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":25,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fiche évaluation DNB",null,null,null,null,null,"APSA:","Natation longue N2"]
[null,null,"Classe/Groupe",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",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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\Fiche évaluation DNB Natation longue N2  .pdf",null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Natation longue N2  .pdf"]
[]
[null,"Nom- Prénom","Sexe","Classe","Note","Temps nagé","Distance parcourue","Distance parcourue en crawl","Note de performance /8","Nombre de cycles de bras premier relevé","Nombre de cycles de bras second relevé","Note cycles de bras /4",null,null,null,"Ecart au projet de nage annoncé","Note écart au projet /4","Efficacité du starter, chronométreur, observateur 4 points",null,null,null,null,null,"Juge dilletante"]
[1,null,null,null,{"$f":"IF(I6=\"\",\"\",I6+L6+Q6+R6)","v":""},null,null,null,{"$f":"IF(OR(G6=\"\",F6=\"\"),\"\",IF(G6<200,0,IF(F6=\"<12\",0,IF(G6>450,8*N6,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G6,Feuil2!$D$3:$D$10,-1))*N6)))))","v":""},null,null,{"$f":"IF(OR(J6=\"\",K6=\"\"),\"\",IF(Feuil1!O6<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O6,Feuil2!$F$3:$F$11,1))))","v":""},{"$f":"IF(OR(G6=\"\",H6=\"\"),\"\",IF(G6<200,0,H6/G6))","v":""},{"$f":"IF(M6=\"\",\"\",IF(M6<0.5,0.7,1))","v":""},{"$f":"IF(OR(J6=\"\",K6=\"\"),\"\",J6+K6)","v":""},null,{"$f":"IF(P6=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P6,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,"<12",null,null,0]
[2,null,null,null,{"$f":"IF(I7=\"\",\"\",I7+L7+Q7+R7)","v":""},null,null,null,{"$f":"IF(OR(G7=\"\",F7=\"\"),\"\",IF(G7<200,0,IF(F7=\"<12\",0,IF(G7>450,8*N7,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G7,Feuil2!$D$3:$D$10,-1))*N7)))))","v":""},null,null,{"$f":"IF(OR(J7=\"\",K7=\"\"),\"\",IF(Feuil1!O7<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O7,Feuil2!$F$3:$F$11,1))))","v":""},{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",IF(G7<200,0,H7/G7))","v":""},{"$f":"IF(M7=\"\",\"\",IF(M7<0.5,0.7,1))","v":""},{"$f":"IF(OR(J7=\"\",K7=\"\"),\"\",J7+K7)","v":""},null,{"$f":"IF(P7=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P7,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,12,null,null,0.5]
[3,null,null,null,"",null,null,null,{"$f":"IF(OR(G8=\"\",F8=\"\"),\"\",IF(G8<200,0,IF(F8=\"<12\",0,IF(G8>450,8*N8,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G8,Feuil2!$D$3:$D$10,-1))*N8)))))","v":""},null,null,{"$f":"IF(OR(J8=\"\",K8=\"\"),\"\",IF(Feuil1!O8<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O8,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P8=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P8,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,1]
[4,null,null,null,"",null,null,null,{"$f":"IF(OR(G9=\"\",F9=\"\"),\"\",IF(G9<200,0,IF(F9=\"<12\",0,IF(G9>450,8*N9,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G9,Feuil2!$D$3:$D$10,-1))*N9)))))","v":""},null,null,{"$f":"IF(OR(J9=\"\",K9=\"\"),\"\",IF(Feuil1!O9<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O9,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P9=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P9,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,1.5]
[5,null,null,null,"",null,null,null,{"$f":"IF(OR(G10=\"\",F10=\"\"),\"\",IF(G10<200,0,IF(F10=\"<12\",0,IF(G10>450,8*N10,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G10,Feuil2!$D$3:$D$10,-1))*N10)))))","v":""},null,null,{"$f":"IF(OR(J10=\"\",K10=\"\"),\"\",IF(Feuil1!O10<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O10,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P10=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P10,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,{"$f":"IF(OR(G11=\"\",F11=\"\"),\"\",IF(G11<200,0,IF(F11=\"<12\",0,IF(G11>450,8*N11,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G11,Feuil2!$D$3:$D$10,-1))*N11)))))","v":""},null,null,{"$f":"IF(OR(J11=\"\",K11=\"\"),\"\",IF(Feuil1!O11<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O11,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P11=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P11,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,2]
[7,null,null,null,"",null,null,null,{"$f":"IF(OR(G12=\"\",F12=\"\"),\"\",IF(G12<200,0,IF(F12=\"<12\",0,IF(G12>450,8*N12,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G12,Feuil2!$D$3:$D$10,-1))*N12)))))","v":""},null,null,{"$f":"IF(OR(J12=\"\",K12=\"\"),\"\",IF(Feuil1!O12<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O12,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P12=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P12,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,2.5]
[8,null,null,null,"",null,null,null,{"$f":"IF(OR(G13=\"\",F13=\"\"),\"\",IF(G13<200,0,IF(F13=\"<12\",0,IF(G13>450,8*N13,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G13,Feuil2!$D$3:$D$10,-1))*N13)))))","v":""},null,null,{"$f":"IF(OR(J13=\"\",K13=\"\"),\"\",IF(Feuil1!O13<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O13,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P13=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P13,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,3]
[9,null,null,null,"",null,null,null,{"$f":"IF(OR(G14=\"\",F14=\"\"),\"\",IF(G14<200,0,IF(F14=\"<12\",0,IF(G14>450,8*N14,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G14,Feuil2!$D$3:$D$10,-1))*N14)))))","v":""},null,null,{"$f":"IF(OR(J14=\"\",K14=\"\"),\"\",IF(Feuil1!O14<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O14,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P14=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P14,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,"Juge multifonctions"]
[10,null,null,null,"",null,null,null,{"$f":"IF(OR(G15=\"\",F15=\"\"),\"\",IF(G15<200,0,IF(F15=\"<12\",0,IF(G15>450,8*N15,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G15,Feuil2!$D$3:$D$10,-1))*N15)))))","v":""},null,null,{"$f":"IF(OR(J15=\"\",K15=\"\"),\"\",IF(Feuil1!O15<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O15,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P15=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P15,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,3.5]
[11,null,null,null,"",null,null,null,{"$f":"IF(OR(G16=\"\",F16=\"\"),\"\",IF(G16<200,0,IF(F16=\"<12\",0,IF(G16>450,8*N16,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G16,Feuil2!$D$3:$D$10,-1))*N16)))))","v":""},null,null,{"$f":"IF(OR(J16=\"\",K16=\"\"),\"\",IF(Feuil1!O16<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O16,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P16=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P16,Feuil2!$I$7:$I$14,1)))","v":""},null,null,null,null,null,null,4]
[12,null,null,null,"",null,null,null,{"$f":"IF(OR(G17=\"\",F17=\"\"),\"\",IF(G17<200,0,IF(F17=\"<12\",0,IF(G17>450,8*N17,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G17,Feuil2!$D$3:$D$10,-1))*N17)))))","v":""},null,null,{"$f":"IF(OR(J17=\"\",K17=\"\"),\"\",IF(Feuil1!O17<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O17,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P17=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P17,Feuil2!$I$7:$I$14,1)))","v":""}]
[13,null,null,null,"",null,null,null,{"$f":"IF(OR(G18=\"\",F18=\"\"),\"\",IF(G18<200,0,IF(F18=\"<12\",0,IF(G18>450,8*N18,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G18,Feuil2!$D$3:$D$10,-1))*N18)))))","v":""},null,null,{"$f":"IF(OR(J18=\"\",K18=\"\"),\"\",IF(Feuil1!O18<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O18,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P18=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P18,Feuil2!$I$7:$I$14,1)))","v":""}]
[14,null,null,null,"",null,null,null,{"$f":"IF(OR(G19=\"\",F19=\"\"),\"\",IF(G19<200,0,IF(F19=\"<12\",0,IF(G19>450,8*N19,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G19,Feuil2!$D$3:$D$10,-1))*N19)))))","v":""},null,null,{"$f":"IF(OR(J19=\"\",K19=\"\"),\"\",IF(Feuil1!O19<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O19,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P19=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P19,Feuil2!$I$7:$I$14,1)))","v":""}]
[15,null,null,null,"",null,null,null,{"$f":"IF(OR(G20=\"\",F20=\"\"),\"\",IF(G20<200,0,IF(F20=\"<12\",0,IF(G20>450,8*N20,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G20,Feuil2!$D$3:$D$10,-1))*N20)))))","v":""},null,null,{"$f":"IF(OR(J20=\"\",K20=\"\"),\"\",IF(Feuil1!O20<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O20,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P20=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P20,Feuil2!$I$7:$I$14,1)))","v":""}]
[16,null,null,null,"",null,null,null,{"$f":"IF(OR(G21=\"\",F21=\"\"),\"\",IF(G21<200,0,IF(F21=\"<12\",0,IF(G21>450,8*N21,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G21,Feuil2!$D$3:$D$10,-1))*N21)))))","v":""},null,null,{"$f":"IF(OR(J21=\"\",K21=\"\"),\"\",IF(Feuil1!O21<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O21,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P21=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P21,Feuil2!$I$7:$I$14,1)))","v":""}]
[17,null,null,null,"",null,null,null,{"$f":"IF(OR(G22=\"\",F22=\"\"),\"\",IF(G22<200,0,IF(F22=\"<12\",0,IF(G22>450,8*N22,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G22,Feuil2!$D$3:$D$10,-1))*N22)))))","v":""},null,null,{"$f":"IF(OR(J22=\"\",K22=\"\"),\"\",IF(Feuil1!O22<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O22,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P22=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P22,Feuil2!$I$7:$I$14,1)))","v":""}]
[18,null,null,null,"",null,null,null,{"$f":"IF(OR(G23=\"\",F23=\"\"),\"\",IF(G23<200,0,IF(F23=\"<12\",0,IF(G23>450,8*N23,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G23,Feuil2!$D$3:$D$10,-1))*N23)))))","v":""},null,null,{"$f":"IF(OR(J23=\"\",K23=\"\"),\"\",IF(Feuil1!O23<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O23,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P23=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P23,Feuil2!$I$7:$I$14,1)))","v":""}]
[19,null,null,null,"",null,null,null,{"$f":"IF(OR(G24=\"\",F24=\"\"),\"\",IF(G24<200,0,IF(F24=\"<12\",0,IF(G24>450,8*N24,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G24,Feuil2!$D$3:$D$10,-1))*N24)))))","v":""},null,null,{"$f":"IF(OR(J24=\"\",K24=\"\"),\"\",IF(Feuil1!O24<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O24,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P24=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P24,Feuil2!$I$7:$I$14,1)))","v":""}]
[20,null,null,null,"",null,null,null,{"$f":"IF(OR(G25=\"\",F25=\"\"),\"\",IF(G25<200,0,IF(F25=\"<12\",0,IF(G25>450,8*N25,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G25,Feuil2!$D$3:$D$10,-1))*N25)))))","v":""},null,null,{"$f":"IF(OR(J25=\"\",K25=\"\"),\"\",IF(Feuil1!O25<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O25,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P25=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P25,Feuil2!$I$7:$I$14,1)))","v":""}]
[21,null,null,null,"",null,null,null,{"$f":"IF(OR(G26=\"\",F26=\"\"),\"\",IF(G26<200,0,IF(F26=\"<12\",0,IF(G26>450,8*N26,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G26,Feuil2!$D$3:$D$10,-1))*N26)))))","v":""},null,null,{"$f":"IF(OR(J26=\"\",K26=\"\"),\"\",IF(Feuil1!O26<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O26,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P26=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P26,Feuil2!$I$7:$I$14,1)))","v":""}]
[22,null,null,null,"",null,null,null,{"$f":"IF(OR(G27=\"\",F27=\"\"),\"\",IF(G27<200,0,IF(F27=\"<12\",0,IF(G27>450,8*N27,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G27,Feuil2!$D$3:$D$10,-1))*N27)))))","v":""},null,null,{"$f":"IF(OR(J27=\"\",K27=\"\"),\"\",IF(Feuil1!O27<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O27,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P27=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P27,Feuil2!$I$7:$I$14,1)))","v":""}]
[23,null,null,null,"",null,null,null,{"$f":"IF(OR(G28=\"\",F28=\"\"),\"\",IF(G28<200,0,IF(F28=\"<12\",0,IF(G28>450,8*N28,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G28,Feuil2!$D$3:$D$10,-1))*N28)))))","v":""},null,null,{"$f":"IF(OR(J28=\"\",K28=\"\"),\"\",IF(Feuil1!O28<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O28,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P28=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P28,Feuil2!$I$7:$I$14,1)))","v":""}]
[24,null,null,null,"",null,null,null,{"$f":"IF(OR(G29=\"\",F29=\"\"),\"\",IF(G29<200,0,IF(F29=\"<12\",0,IF(G29>450,8*N29,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G29,Feuil2!$D$3:$D$10,-1))*N29)))))","v":""},null,null,{"$f":"IF(OR(J29=\"\",K29=\"\"),\"\",IF(Feuil1!O29<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O29,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P29=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P29,Feuil2!$I$7:$I$14,1)))","v":""}]
[25,null,null,null,"",null,null,null,{"$f":"IF(OR(G30=\"\",F30=\"\"),\"\",IF(G30<200,0,IF(F30=\"<12\",0,IF(G30>450,8*N30,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G30,Feuil2!$D$3:$D$10,-1))*N30)))))","v":""},null,null,{"$f":"IF(OR(J30=\"\",K30=\"\"),\"\",IF(Feuil1!O30<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O30,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P30=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P30,Feuil2!$I$7:$I$14,1)))","v":""}]
[26,null,null,null,"",null,null,null,{"$f":"IF(OR(G31=\"\",F31=\"\"),\"\",IF(G31<200,0,IF(F31=\"<12\",0,IF(G31>450,8*N31,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G31,Feuil2!$D$3:$D$10,-1))*N31)))))","v":""},null,null,{"$f":"IF(OR(J31=\"\",K31=\"\"),\"\",IF(Feuil1!O31<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O31,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P31=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P31,Feuil2!$I$7:$I$14,1)))","v":""}]
[27,null,null,null,"",null,null,null,{"$f":"IF(OR(G32=\"\",F32=\"\"),\"\",IF(G32<200,0,IF(F32=\"<12\",0,IF(G32>450,8*N32,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G32,Feuil2!$D$3:$D$10,-1))*N32)))))","v":""},null,null,{"$f":"IF(OR(J32=\"\",K32=\"\"),\"\",IF(Feuil1!O32<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O32,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P32=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P32,Feuil2!$I$7:$I$14,1)))","v":""}]
[28,null,null,null,"",null,null,null,{"$f":"IF(OR(G33=\"\",F33=\"\"),\"\",IF(G33<200,0,IF(F33=\"<12\",0,IF(G33>450,8*N33,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G33,Feuil2!$D$3:$D$10,-1))*N33)))))","v":""},null,null,{"$f":"IF(OR(J33=\"\",K33=\"\"),\"\",IF(Feuil1!O33<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O33,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P33=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P33,Feuil2!$I$7:$I$14,1)))","v":""}]
[29,null,null,null,"",null,null,null,{"$f":"IF(OR(G34=\"\",F34=\"\"),\"\",IF(G34<200,0,IF(F34=\"<12\",0,IF(G34>450,8*N34,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G34,Feuil2!$D$3:$D$10,-1))*N34)))))","v":""},null,null,{"$f":"IF(OR(J34=\"\",K34=\"\"),\"\",IF(Feuil1!O34<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O34,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P34=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P34,Feuil2!$I$7:$I$14,1)))","v":""}]
[30,null,null,null,"",null,null,null,{"$f":"IF(OR(G35=\"\",F35=\"\"),\"\",IF(G35<200,0,IF(F35=\"<12\",0,IF(G35>450,8*N35,(INDEX(Feuil2!$C$3:$C$10,MATCH(Feuil1!G35,Feuil2!$D$3:$D$10,-1))*N35)))))","v":""},null,null,{"$f":"IF(OR(J35=\"\",K35=\"\"),\"\",IF(Feuil1!O35<30,4,INDEX(Feuil2!$G$3:$G$11,MATCH(Feuil1!O35,Feuil2!$F$3:$F$11,1))))","v":""},"","","",null,{"$f":"IF(P35=\"\",\"\",INDEX(Feuil2!$J$7:$J$14,MATCH(Feuil1!P35,Feuil2!$I$7:$I$14,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(E7=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"M\",$E$6:$E$35)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
["<12"]
[12,null,8,450,null,30,4]
[null,null,7,425,null,34,3.5]
[null,null,6,400,null,35,3]
[null,null,5,350,null,39,2.5]
[null,null,4,325,null,40,2,null,0,4]
[null,null,3,300,null,42,1.5,null,1,3.5]
[null,null,2,250,null,46,1,null,2,3]
[null,null,1,200,null,48,0.5,null,3,2.5]
[null,null,null,null,null,50,0,null,4,2]
[null,null,null,null,null,null,null,null,5,1]
[null,null,null,null,null,null,null,null,6,0.5]
[null,null,null,null,null,null,null,null,">6",0]

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