{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["mode d'emploi","Pentabond","Bareme Penta","Poids","Bareme Poids"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"mode d'emploi","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["1) remplir nom et prénom de l'élève"]
["2) renseigner le sexe: F ou G"]
["3) renseigner le projet de moyenne des 3 meilleurs essais dans \"annoncé\""]
["4) remplir les 6 performances (mettre 0 pour un essai non validé)"]
["5) renseigner la note de maîtrise"]
[]
["UTILISER LES CASES ",null,null,null,"POUR EFFACER les données rentrées et NON LES FORMULES !!!!!!"]

{"sheet":"Pentabond","index":1,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,17],[1,18,1,19],[1,4,1,11],[0,0,0,3],[0,4,0,10]]}
[]
[null,"PENTABOND",null,null,"MEILLEURE PERFORMANCE en 6 essais",null,null,null,null,null,null,null,"max1","max2","max3","MOYENNE des 3 meilleurs",null,null,"écart",null,"maîtrise","NOTE"]
[null,"NOM","Prénom","sexe",1,2,3,4,5,6,"meilleur","10 pts",null,null,null,"réalisé","4 pts","annoncé",null,"2pts","4 pts","20 pts"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E4:J4)","v":0},{"$f":"IF(ISBLANK(K4),\"\",IF(D4='Bareme Penta'!$B$5,LOOKUP(K4,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D4='Bareme Penta'!$D$5,LOOKUP(K4,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},{"$f":"MAX(E4:J4)","v":0},{"$f":"IF(F4=\"\",\"\",LARGE(E4:J4,2))","v":""},{"$f":"IF(ISBLANK(G4),\"\",LARGE(E4:J4,3))","v":""},{"$f":"IF(ISBLANK(M4),\"\",AVERAGE(M4:O4))","v":0},{"$f":"IF(ISBLANK(P4),\"\",IF(ISBLANK(E4),\"\",IF(D4='Bareme Penta'!$F$5,LOOKUP(P4,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D4='Bareme Penta'!$H$5,LOOKUP(P4,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,{"$f":"IF(P4=0,\"\",ABS(P4-R4))","v":""},{"$f":"IF(ISBLANK(R4),\"\",IF(S4<0.2,2,IF(S4<0.3,1.5,IF(S4<0.4,1,IF(S4<0.5,0.5,IF(S4<100,0))))))","v":""},null,{"$f":"IF(D4=\"\",\"\",IF(ISBLANK(E4),\"\",IF(ISBLANK(T4),\"\",IF(ISBLANK(R4),\"\",(L4+Q4+T4+U4)))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K5),\"\",IF(D5='Bareme Penta'!$B$5,LOOKUP(K5,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D5='Bareme Penta'!$D$5,LOOKUP(K5,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P5),\"\",IF(ISBLANK(E5),\"\",IF(D5='Bareme Penta'!$F$5,LOOKUP(P5,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D5='Bareme Penta'!$H$5,LOOKUP(P5,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"",{"$f":"IF(ISBLANK(R5),\"\",IF(S5<0.2,2,IF(S5<0.3,1.5,IF(S5<0.4,1,IF(S5<0.5,0.5,IF(S5<100,0))))))","v":""},null,{"$f":"IF(D5=\"\",\"\",IF(ISBLANK(E5),\"\",IF(ISBLANK(T5),\"\",IF(ISBLANK(R5),\"\",(L5+Q5+T5+U5)))))","v":""}]
[3,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K6),\"\",IF(D6='Bareme Penta'!$B$5,LOOKUP(K6,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D6='Bareme Penta'!$D$5,LOOKUP(K6,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P6),\"\",IF(ISBLANK(E6),\"\",IF(D6='Bareme Penta'!$F$5,LOOKUP(P6,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D6='Bareme Penta'!$H$5,LOOKUP(P6,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[4,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K7),\"\",IF(D7='Bareme Penta'!$B$5,LOOKUP(K7,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D7='Bareme Penta'!$D$5,LOOKUP(K7,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P7),\"\",IF(ISBLANK(E7),\"\",IF(D7='Bareme Penta'!$F$5,LOOKUP(P7,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D7='Bareme Penta'!$H$5,LOOKUP(P7,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[5,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K8),\"\",IF(D8='Bareme Penta'!$B$5,LOOKUP(K8,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D8='Bareme Penta'!$D$5,LOOKUP(K8,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P8),\"\",IF(ISBLANK(E8),\"\",IF(D8='Bareme Penta'!$F$5,LOOKUP(P8,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D8='Bareme Penta'!$H$5,LOOKUP(P8,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[6,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K9),\"\",IF(D9='Bareme Penta'!$B$5,LOOKUP(K9,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D9='Bareme Penta'!$D$5,LOOKUP(K9,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P9),\"\",IF(ISBLANK(E9),\"\",IF(D9='Bareme Penta'!$F$5,LOOKUP(P9,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D9='Bareme Penta'!$H$5,LOOKUP(P9,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[7,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K10),\"\",IF(D10='Bareme Penta'!$B$5,LOOKUP(K10,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D10='Bareme Penta'!$D$5,LOOKUP(K10,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P10),\"\",IF(ISBLANK(E10),\"\",IF(D10='Bareme Penta'!$F$5,LOOKUP(P10,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D10='Bareme Penta'!$H$5,LOOKUP(P10,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[8,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K11),\"\",IF(D11='Bareme Penta'!$B$5,LOOKUP(K11,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D11='Bareme Penta'!$D$5,LOOKUP(K11,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P11),\"\",IF(ISBLANK(E11),\"\",IF(D11='Bareme Penta'!$F$5,LOOKUP(P11,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D11='Bareme Penta'!$H$5,LOOKUP(P11,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[9,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K12),\"\",IF(D12='Bareme Penta'!$B$5,LOOKUP(K12,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D12='Bareme Penta'!$D$5,LOOKUP(K12,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P12),\"\",IF(ISBLANK(E12),\"\",IF(D12='Bareme Penta'!$F$5,LOOKUP(P12,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D12='Bareme Penta'!$H$5,LOOKUP(P12,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[10,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K13),\"\",IF(D13='Bareme Penta'!$B$5,LOOKUP(K13,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D13='Bareme Penta'!$D$5,LOOKUP(K13,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P13),\"\",IF(ISBLANK(E13),\"\",IF(D13='Bareme Penta'!$F$5,LOOKUP(P13,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D13='Bareme Penta'!$H$5,LOOKUP(P13,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[11,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K14),\"\",IF(D14='Bareme Penta'!$B$5,LOOKUP(K14,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D14='Bareme Penta'!$D$5,LOOKUP(K14,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P14),\"\",IF(ISBLANK(E14),\"\",IF(D14='Bareme Penta'!$F$5,LOOKUP(P14,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D14='Bareme Penta'!$H$5,LOOKUP(P14,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[12,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K15),\"\",IF(D15='Bareme Penta'!$B$5,LOOKUP(K15,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D15='Bareme Penta'!$D$5,LOOKUP(K15,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P15),\"\",IF(ISBLANK(E15),\"\",IF(D15='Bareme Penta'!$F$5,LOOKUP(P15,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D15='Bareme Penta'!$H$5,LOOKUP(P15,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[13,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K16),\"\",IF(D16='Bareme Penta'!$B$5,LOOKUP(K16,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D16='Bareme Penta'!$D$5,LOOKUP(K16,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P16),\"\",IF(ISBLANK(E16),\"\",IF(D16='Bareme Penta'!$F$5,LOOKUP(P16,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D16='Bareme Penta'!$H$5,LOOKUP(P16,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[14,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K17),\"\",IF(D17='Bareme Penta'!$B$5,LOOKUP(K17,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D17='Bareme Penta'!$D$5,LOOKUP(K17,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P17),\"\",IF(ISBLANK(E17),\"\",IF(D17='Bareme Penta'!$F$5,LOOKUP(P17,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D17='Bareme Penta'!$H$5,LOOKUP(P17,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[15,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K18),\"\",IF(D18='Bareme Penta'!$B$5,LOOKUP(K18,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D18='Bareme Penta'!$D$5,LOOKUP(K18,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P18),\"\",IF(ISBLANK(E18),\"\",IF(D18='Bareme Penta'!$F$5,LOOKUP(P18,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D18='Bareme Penta'!$H$5,LOOKUP(P18,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[16,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K19),\"\",IF(D19='Bareme Penta'!$B$5,LOOKUP(K19,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D19='Bareme Penta'!$D$5,LOOKUP(K19,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P19),\"\",IF(ISBLANK(E19),\"\",IF(D19='Bareme Penta'!$F$5,LOOKUP(P19,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D19='Bareme Penta'!$H$5,LOOKUP(P19,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[17,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K20),\"\",IF(D20='Bareme Penta'!$B$5,LOOKUP(K20,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D20='Bareme Penta'!$D$5,LOOKUP(K20,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P20),\"\",IF(ISBLANK(E20),\"\",IF(D20='Bareme Penta'!$F$5,LOOKUP(P20,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D20='Bareme Penta'!$H$5,LOOKUP(P20,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[18,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K21),\"\",IF(D21='Bareme Penta'!$B$5,LOOKUP(K21,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D21='Bareme Penta'!$D$5,LOOKUP(K21,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P21),\"\",IF(ISBLANK(E21),\"\",IF(D21='Bareme Penta'!$F$5,LOOKUP(P21,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D21='Bareme Penta'!$H$5,LOOKUP(P21,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[19,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K22),\"\",IF(D22='Bareme Penta'!$B$5,LOOKUP(K22,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D22='Bareme Penta'!$D$5,LOOKUP(K22,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P22),\"\",IF(ISBLANK(E22),\"\",IF(D22='Bareme Penta'!$F$5,LOOKUP(P22,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D22='Bareme Penta'!$H$5,LOOKUP(P22,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[20,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K23),\"\",IF(D23='Bareme Penta'!$B$5,LOOKUP(K23,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D23='Bareme Penta'!$D$5,LOOKUP(K23,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P23),\"\",IF(ISBLANK(E23),\"\",IF(D23='Bareme Penta'!$F$5,LOOKUP(P23,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D23='Bareme Penta'!$H$5,LOOKUP(P23,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[21,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K24),\"\",IF(D24='Bareme Penta'!$B$5,LOOKUP(K24,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D24='Bareme Penta'!$D$5,LOOKUP(K24,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P24),\"\",IF(ISBLANK(E24),\"\",IF(D24='Bareme Penta'!$F$5,LOOKUP(P24,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D24='Bareme Penta'!$H$5,LOOKUP(P24,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[22,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K25),\"\",IF(D25='Bareme Penta'!$B$5,LOOKUP(K25,'Bareme Penta'!$B$6:$B$27,'Bareme Penta'!$C$6:$C$27),IF(D25='Bareme Penta'!$D$5,LOOKUP(K25,'Bareme Penta'!$D$6:$D$27,'Bareme Penta'!$C$6:$C$27),\"\")))","v":""},0,"",{"$f":"IF(ISBLANK(G25),\"\",LARGE(E25:J25,3))","v":""},{"$f":"IF(ISBLANK(M25),\"\",AVERAGE(M25:O25))","v":0},{"$f":"IF(ISBLANK(P25),\"\",IF(ISBLANK(E25),\"\",IF(D25='Bareme Penta'!$F$5,LOOKUP(P25,'Bareme Penta'!$F$6:$F$27,'Bareme Penta'!$G$6:$G$27),IF(D25='Bareme Penta'!$H$5,LOOKUP(P25,'Bareme Penta'!$H$6:$H$27,'Bareme Penta'!$G$6:$G$27),\"\"))))","v":""},null,{"$f":"IF(P25=0,\"\",ABS(P25-R25))","v":""},"",null,{"$f":"IF(D25=\"\",\"\",IF(ISBLANK(E25),\"\",IF(ISBLANK(T25),\"\",IF(ISBLANK(R25),\"\",(L25+Q25+T25+U25)))))","v":""}]

{"sheet":"Bareme Penta","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,5,3,7],[2,1,3,3],[2,9,3,10]]}
[]
[]
[null,"PERFORMANCE /10 ",null,null,null,"MOYENNE /4 des 3 meilleures perf",null,null,null,"CALCUL ECART"]
[]
[null,"F","NOTE","G",null,"F","NOTES","G",null,"ecart","NOTE"]
[null,0,0,0,null,0,0,0,null,0,2]
[null,6.87,0.5,8,null,6.3,0.2,7.5,null,0.19,2]
[null,7,1,8.5,null,6.5,0.4,7.75,null,0.2,1.5]
[null,7.42,1.5,9.0500000000000007,null,6.87,0.6,8,null,0.28999999999999998,1.5]
[null,7.83,2,9.5500000000000007,null,7,0.8,8.5,null,0.3,1]
[null,8.2200000000000006,2.5,10.07,null,7.42,1,9.0500000000000007,null,0.39,1]
[null,8.6199999999999992,3,10.57,null,7.83,1.2,9.5500000000000007,null,0.4,0.5]
[null,9,3.5,11.06,null,8.2200000000000006,1.4,10.07,null,0.59,0.5]
[null,9.39,4,11.56,null,8.6199999999999992,1.6,10.57,null,0.6,0]
[null,9.76,4.5,12.05,null,9,1.8,11.06,null,10,0]
[null,10.14,5,12.53,null,9.39,2,11.56]
[null,10.49,5.5,13,null,9.76,2.2000000000000002,12.05]
[null,10.86,6,13.47,null,10.14,2.4,12.53]
[null,11.2,6.5,13.93,null,10.49,2.6,13]
[null,11.55,7,14.39,null,10.86,2.8,13.47]
[null,11.88,7.5,14.85,null,11.2,3,13.93]
[null,12.22,8,15.28,null,11.55,3.2,14.39]
[null,12.54,8.5,15.73,null,11.88,3.4,14.85]
[null,12.87,9,16.149999999999999,null,12.22,3.6,15.28]
[null,13.17,9.5,16.579999999999998,null,12.54,3.8,15.73]
[null,13.5,10,17,null,12.87,4,16.149999999999999]
[null,40,10,40,null,40,4,40]

{"sheet":"Poids","index":3,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,18,1,19],[0,0,0,3],[0,4,0,10],[1,1,1,2],[1,4,1,11],[1,15,1,17]]}
[]
[null,"POIDS",null,null,"MEILLEURE PERFORMANCE en 6 essais",null,null,null,null,null,null,null,"max1","max2","max3","MOYENNE des 3 meilleurs",null,null,"écart",null,"maîtrise","NOTE"]
[null,"NOM","Prénom","sexe",1,2,3,4,5,6,"meilleur","10 pts",null,null,null,"réalisé","4 pts","annoncé",null,"2pts","4 pts","20 pts"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"MAX(E4:J4)","v":0},{"$f":"IF(ISBLANK(K4),\"\",IF(D4='Bareme Poids'!$B$5,LOOKUP(K4,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D4='Bareme Poids'!$D$5,LOOKUP(K4,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},{"$f":"K4","v":0},{"$f":"IF(F4=\"\",\"\",LARGE(E4:J4,2))","v":""},{"$f":"IF(ISBLANK(G4),\"\",LARGE(E4:J4,3))","v":""},{"$f":"IF(ISBLANK(M4),\"\",AVERAGE(M4:O4))","v":0},{"$f":"IF(ISBLANK(P4),\"\",IF(ISBLANK(E4),\"\",IF(D4='Bareme Poids'!$F$5,LOOKUP(P4,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D4='Bareme Poids'!$H$5,LOOKUP(P4,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,{"$f":"IF(P4=0,\"\",ABS(P4-R4))","v":""},{"$f":"IF(ISBLANK(R4),\"\",IF(S4<0.3,2,IF(S4<0.4,1.5,IF(S4<0.6,1.25,IF(S4<0.8,1,IF(S4<1,0.5,IF(S4<100,0)))))))","v":""},null,{"$f":"IF(D4=\"\",\"\",IF(ISBLANK(E4),\"\",IF(ISBLANK(T4),\"\",IF(ISBLANK(R4),\"\",(L4+Q4+T4+U4)))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K5),\"\",IF(D5='Bareme Poids'!$B$5,LOOKUP(K5,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D5='Bareme Poids'!$D$5,LOOKUP(K5,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},{"$f":"K5","v":0},"","",0,{"$f":"IF(ISBLANK(P5),\"\",IF(ISBLANK(E5),\"\",IF(D5='Bareme Poids'!$F$5,LOOKUP(P5,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D5='Bareme Poids'!$H$5,LOOKUP(P5,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"",{"$f":"IF(ISBLANK(R5),\"\",IF(S5<0.3,2,IF(S5<0.4,1.5,IF(S5<0.6,1.25,IF(S5<0.8,1,IF(S5<1,0.5,IF(S5<100,0)))))))","v":""},null,{"$f":"IF(D5=\"\",\"\",IF(ISBLANK(E5),\"\",IF(ISBLANK(T5),\"\",IF(ISBLANK(R5),\"\",(L5+Q5+T5+U5)))))","v":""}]
[3,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K6),\"\",IF(D6='Bareme Poids'!$B$5,LOOKUP(K6,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D6='Bareme Poids'!$D$5,LOOKUP(K6,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P6),\"\",IF(ISBLANK(E6),\"\",IF(D6='Bareme Poids'!$F$5,LOOKUP(P6,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D6='Bareme Poids'!$H$5,LOOKUP(P6,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[4,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K7),\"\",IF(D7='Bareme Poids'!$B$5,LOOKUP(K7,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D7='Bareme Poids'!$D$5,LOOKUP(K7,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P7),\"\",IF(ISBLANK(E7),\"\",IF(D7='Bareme Poids'!$F$5,LOOKUP(P7,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D7='Bareme Poids'!$H$5,LOOKUP(P7,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[5,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K8),\"\",IF(D8='Bareme Poids'!$B$5,LOOKUP(K8,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D8='Bareme Poids'!$D$5,LOOKUP(K8,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P8),\"\",IF(ISBLANK(E8),\"\",IF(D8='Bareme Poids'!$F$5,LOOKUP(P8,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D8='Bareme Poids'!$H$5,LOOKUP(P8,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[6,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K9),\"\",IF(D9='Bareme Poids'!$B$5,LOOKUP(K9,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D9='Bareme Poids'!$D$5,LOOKUP(K9,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P9),\"\",IF(ISBLANK(E9),\"\",IF(D9='Bareme Poids'!$F$5,LOOKUP(P9,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D9='Bareme Poids'!$H$5,LOOKUP(P9,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[7,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K10),\"\",IF(D10='Bareme Poids'!$B$5,LOOKUP(K10,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D10='Bareme Poids'!$D$5,LOOKUP(K10,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P10),\"\",IF(ISBLANK(E10),\"\",IF(D10='Bareme Poids'!$F$5,LOOKUP(P10,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D10='Bareme Poids'!$H$5,LOOKUP(P10,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[8,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K11),\"\",IF(D11='Bareme Poids'!$B$5,LOOKUP(K11,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D11='Bareme Poids'!$D$5,LOOKUP(K11,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P11),\"\",IF(ISBLANK(E11),\"\",IF(D11='Bareme Poids'!$F$5,LOOKUP(P11,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D11='Bareme Poids'!$H$5,LOOKUP(P11,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[9,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K12),\"\",IF(D12='Bareme Poids'!$B$5,LOOKUP(K12,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D12='Bareme Poids'!$D$5,LOOKUP(K12,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P12),\"\",IF(ISBLANK(E12),\"\",IF(D12='Bareme Poids'!$F$5,LOOKUP(P12,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D12='Bareme Poids'!$H$5,LOOKUP(P12,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[10,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K13),\"\",IF(D13='Bareme Poids'!$B$5,LOOKUP(K13,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D13='Bareme Poids'!$D$5,LOOKUP(K13,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P13),\"\",IF(ISBLANK(E13),\"\",IF(D13='Bareme Poids'!$F$5,LOOKUP(P13,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D13='Bareme Poids'!$H$5,LOOKUP(P13,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[11,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K14),\"\",IF(D14='Bareme Poids'!$B$5,LOOKUP(K14,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D14='Bareme Poids'!$D$5,LOOKUP(K14,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P14),\"\",IF(ISBLANK(E14),\"\",IF(D14='Bareme Poids'!$F$5,LOOKUP(P14,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D14='Bareme Poids'!$H$5,LOOKUP(P14,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[12,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K15),\"\",IF(D15='Bareme Poids'!$B$5,LOOKUP(K15,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D15='Bareme Poids'!$D$5,LOOKUP(K15,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P15),\"\",IF(ISBLANK(E15),\"\",IF(D15='Bareme Poids'!$F$5,LOOKUP(P15,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D15='Bareme Poids'!$H$5,LOOKUP(P15,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[13,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K16),\"\",IF(D16='Bareme Poids'!$B$5,LOOKUP(K16,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D16='Bareme Poids'!$D$5,LOOKUP(K16,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P16),\"\",IF(ISBLANK(E16),\"\",IF(D16='Bareme Poids'!$F$5,LOOKUP(P16,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D16='Bareme Poids'!$H$5,LOOKUP(P16,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[14,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K17),\"\",IF(D17='Bareme Poids'!$B$5,LOOKUP(K17,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D17='Bareme Poids'!$D$5,LOOKUP(K17,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P17),\"\",IF(ISBLANK(E17),\"\",IF(D17='Bareme Poids'!$F$5,LOOKUP(P17,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D17='Bareme Poids'!$H$5,LOOKUP(P17,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[15,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K18),\"\",IF(D18='Bareme Poids'!$B$5,LOOKUP(K18,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D18='Bareme Poids'!$D$5,LOOKUP(K18,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P18),\"\",IF(ISBLANK(E18),\"\",IF(D18='Bareme Poids'!$F$5,LOOKUP(P18,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D18='Bareme Poids'!$H$5,LOOKUP(P18,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[16,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K19),\"\",IF(D19='Bareme Poids'!$B$5,LOOKUP(K19,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D19='Bareme Poids'!$D$5,LOOKUP(K19,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P19),\"\",IF(ISBLANK(E19),\"\",IF(D19='Bareme Poids'!$F$5,LOOKUP(P19,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D19='Bareme Poids'!$H$5,LOOKUP(P19,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[17,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K20),\"\",IF(D20='Bareme Poids'!$B$5,LOOKUP(K20,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D20='Bareme Poids'!$D$5,LOOKUP(K20,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P20),\"\",IF(ISBLANK(E20),\"\",IF(D20='Bareme Poids'!$F$5,LOOKUP(P20,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D20='Bareme Poids'!$H$5,LOOKUP(P20,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[18,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K21),\"\",IF(D21='Bareme Poids'!$B$5,LOOKUP(K21,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D21='Bareme Poids'!$D$5,LOOKUP(K21,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P21),\"\",IF(ISBLANK(E21),\"\",IF(D21='Bareme Poids'!$F$5,LOOKUP(P21,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D21='Bareme Poids'!$H$5,LOOKUP(P21,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[19,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K22),\"\",IF(D22='Bareme Poids'!$B$5,LOOKUP(K22,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D22='Bareme Poids'!$D$5,LOOKUP(K22,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P22),\"\",IF(ISBLANK(E22),\"\",IF(D22='Bareme Poids'!$F$5,LOOKUP(P22,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D22='Bareme Poids'!$H$5,LOOKUP(P22,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[20,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K23),\"\",IF(D23='Bareme Poids'!$B$5,LOOKUP(K23,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D23='Bareme Poids'!$D$5,LOOKUP(K23,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P23),\"\",IF(ISBLANK(E23),\"\",IF(D23='Bareme Poids'!$F$5,LOOKUP(P23,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D23='Bareme Poids'!$H$5,LOOKUP(P23,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[21,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K24),\"\",IF(D24='Bareme Poids'!$B$5,LOOKUP(K24,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D24='Bareme Poids'!$D$5,LOOKUP(K24,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P24),\"\",IF(ISBLANK(E24),\"\",IF(D24='Bareme Poids'!$F$5,LOOKUP(P24,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D24='Bareme Poids'!$H$5,LOOKUP(P24,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]
[22,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(K25),\"\",IF(D25='Bareme Poids'!$B$5,LOOKUP(K25,'Bareme Poids'!$B$6:$B$27,'Bareme Poids'!$C$6:$C$27),IF(D25='Bareme Poids'!$D$5,LOOKUP(K25,'Bareme Poids'!$D$6:$D$27,'Bareme Poids'!$C$6:$C$27),\"\")))","v":""},0,"","",0,{"$f":"IF(ISBLANK(P25),\"\",IF(ISBLANK(E25),\"\",IF(D25='Bareme Poids'!$F$5,LOOKUP(P25,'Bareme Poids'!$F$6:$F$27,'Bareme Poids'!$G$6:$G$27),IF(D25='Bareme Poids'!$H$5,LOOKUP(P25,'Bareme Poids'!$H$6:$H$27,'Bareme Poids'!$G$6:$G$27),\"\"))))","v":""},null,"","",null,""]

{"sheet":"Bareme Poids","index":4,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,1,3,3],[2,5,3,7]]}
[]
[]
[null,"PERFORMANCE /10",null,null,null,"MOYENNE /4 des 3 meilleurs essais",null,null,null,"ecart","NOTE"]
[null,null,null,null,null,null,null,null,null,0,4]
[null,"F","NOTE","G",null,"F","NOTE","G",null,0.28999999999999998,4]
[null,0,0,0,null,0,0,0,null,0.39,3]
[null,3.5,"0.1",5,null,3.3,"0.1",4.5999999999999996,null,0.59,2]
[null,3.85,"0.7",5.3,null,3.45,"0.3",4.8,null,0.79,1.5]
[null,4.25,"1.3",5.7,null,3.6,"0.5",5,null,0.99,1]
[null,4.5999999999999996,"1.9",6.1,null,3.85,"0.7",5.3,null,1,0]
[null,4.95,"2.5",6.5,null,4.25,"0.9",5.7,null,10,0]
[null,5.25,"2.9",6.9,null,4.5999999999999996,1,6.1]
[null,5.6,"3.3",7.3,null,4.95,"1.2",6.5]
[null,5.9,"3.7",7.7,null,5.25,"1.4",6.9]
[null,6.15,"4.1",8.1,null,5.6,"1.6",7.3]
[null,6.45,"4.5",8.5,null,5.9,"1.8",7.7]
[null,6.8,5,8.8000000000000007,null,6.15,2,8.1]
[null,7.1,"5.5",9.1,null,6.45,"2.3",8.5]
[null,7.4,6,9.4,null,6.8,"2.6",8.8000000000000007]
[null,7.7,"6.5",9.6999999999999993,null,7.1,"2.8",9.1]
[null,8.0500000000000007,7,10,null,7.4,3,9.4]
[null,8.4,"7.6",10.3,null,7.7,"3.2",9.6999999999999993]
[null,8.6999999999999993,"8.2",10.6,null,8.0500000000000007,"3.4",10]
[null,9.0500000000000007,"8.8",10.9,null,8.4,"3.6",10.3]
[null,9.4,"9.4",11.2,null,8.6999999999999993,"3.8",10.6]
[null,9.6999999999999993,10,11.5,null,9.0500000000000007,4,10.9]
[null,40,10,40,null,40,4,40]