{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Choix de Format de course","gestion de CO avec Balises","gestion de course tradi","Gestion CO parcours","Gestion CO cartes","note rythmeFormat1et2","note nbre erreursformat1et2","note  balises cherchéesFormat12","note parcourscherchésformat3et4","liste d'élèves","validation de données","Baremes 1","Bareme 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Choix de Format de course","index":0,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,1,7],[0,10,44,26]]}
["CHOIX DE VOTRE FORMAT DE COURSE DE CO (cliquer successivement sur les onglets)",null,null,null,null,null,null,null,null,null,"Cahier des charges de l'application:     GCO polymorphe NUMEPS   \n\nCette application est sur le plan technique excessivement simple à mettre en place. Elle n'utilise que des formules Excel simples et des macros simples. Je combine cette Application GCO avec l'utilisation d'une application Android pour la prise des temps Multi-chrono et Timer qui a l'avantage d'être gratuite, de pouvoir démarrer 20 chronos simultanés, de les nommer et d'enregistrer des temps intermédiaires.\n\nC'est une proposition numérique pédagogique qui a vocation à être modifiée en fonction de votre contexte d'enseignement et votre traitement didactique pour des utilisateurs numériques débutants. Elle a l'intérêt de vous donner une note presque en direct et de vous faire gagner du temps quand elle est construite.\n\nVous pouvez donc l'utiliser en kit si elle correspond à votre contexte d'enseignement ( une version protégée sur un format de course de 12 balises ou 12 parcours ou 12 cartes: les formules et les feuilles sont protégées) ou la faire évoluer à votre guise selon des axes qui vous conviennent (je vous partage sur le site EPS académique une version non protégée, modifiable ou toutes les feulles du classeur apparaissent pour modification) et des tutoriels sur deux fonctions principales utilisées dans cette application (la fonction TEMPS et la  fonction rechercheV).\n\nLes axes d'évolution concernent le format de course, le nombre de balises ou parcours ou cartes, la définition des critères de notation, la définition des barêmes 1 (CO en étoile et traditionnelle) et des barêmes 2 (CO nbre de parcours et CO nbre de cartes) et le changement des données de barême dans les tableaux de référence (feuilles nommées note en bas), et le changement des formules dans les feuilles de gestion de course.\n\nLes formules Excel utilisées sont:\n\nLa fonction Temps (sert à transformer votre saisie du temps sous forme décimale pour la saisir vite et de transfomer ce temps au format excel: Par exemple pour 2min13, vous allez saisir 213 et elle tansformera ce temps au format excel hh:mm:ss).\nLa fonction rechercheV (sert à construire les barêmes).\nLa fonction Si imbriquée à la fonction Ou (sert à dénombrer le nombre de balises fausses).\nLa fonction Sierreur (sert à écrire 0 dans les cellules au lieu d'écrire #DIV/0! ou autres écritures illisibles si le calcul n'est pas faisable).\nLa fonction NBVAL (sert à dénombrer des cellules où il y a une valeur dedans).\n\nDes petites macros viennent s'ajouter principalement pour ajouter de l'ergonomie à l'application (Quand vous cliquez sur un onglet de couleur cela se dirige directement sur une autre feuille, je ne les détaille pas ici, elles sont verrouillées). Cela vous impose donc d'utiliser la même structure, c'est à dire de modifier uniquement les formats de course, leurs contenus et leurs barêmes.\nEt enfin, l'outil validation de données d'excel qui permet de créer des listes déroulantes (liste d'élèves dans les formats de courses....)\n\n\n               \n"]

{"sheet":"gestion de CO avec Balises","index":1,"n_rows":37,"n_cols":61,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,38,1,41],[1,42,1,45],[1,46,1,49],[0,2,0,49],[1,26,1,29],[1,30,1,33],[1,34,1,37],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,1,17],[1,18,1,21],[1,22,1,25]]}
[null,null,"Gestion de Course de CO de 12 balises  et Proposition d'une note selon 4 critères changeables (nombre de balises cherchées, rythme de course, nombre d'erreurs, lisibilité de la feuille de course). Une balise non trouvée est comptée comme fausse."]
[null,null,"Balise 1",null,null,null,"Balise 2",null,null,null,"Balise 3",null,null,null,"Balise 4",null,null,null,"Balise 5",null,null,null,"Balise 6",null,null,null,"Balise 7",null,null,null,"Balise 8",null,null,null,"Balise 9",null,null,null,"Balise 10",null,null,null,"Balise 11",null,null,null,"Balise 12"]
["NOM 1","NOM 2","code balise 1","tpsdecimal\nA saisir","Temps","Erreurs","code balise 2","tpsdecimal\nA saisir","Temps","Erreurs","code balise  3","tpsdecimal\nA saisir","Temps","Erreurs","code balise 4","tpsdecimal\nA saisir","Temps","Erreurs","code balise 5","tpsdecimal\nA saisir","Temps","Erreurs","code balise 6","tpsdecimal\nA saisir","Temps","Erreurs","code balise 7","tpsdecimal\nA saisir","Temps","Erreurs","code balise  8","tpsdecimal\nA saisir","Temps","Erreurs","code balise 9","tpsdecimal\nA saisir","Temps","Erreurs","code balise 10","tpsdecimal\nA saisir","Temps","Erreurs","code balise 11","tpsdecimal\nA saisir","Temps","Erreurs","code balise 12","tpsdecimal\nA saisir","Temps","Erreurs","Nb de balises cherchées","Note nbre de balises cherchées\n\n/5","Temps Total du parcours\n","rythme","note Rythme\n\n/5","Nombre d'erreurs","note Nombre d'erreurs\n\n/10","Lisibilité\nà saisir\n/1","Bonus éventuel","Note /21","Note/20"]
[null,null,null,null,{"$f":"TIME(0,D4/100,MOD(D4,100))","v":"00:00:00"},{"$f":"IF(OR(C4=\"o\",C4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,H4/100,MOD(H4,100))","v":"00:00:00"},{"$f":"IF(OR(G4=\"o\",G4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,L4/100,MOD(L4,100))","v":"00:00:00"},{"$f":"IF(OR(K4=\"o\",K4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,P4/100,MOD(P4,100))","v":"00:00:00"},{"$f":"IF(OR(O4=\"o\",O4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,T4/100,MOD(T4,100))","v":"00:00:00"},{"$f":"IF(OR(S4=\"o\",S4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,X4/100,MOD(X4,100))","v":"00:00:00"},{"$f":"IF(OR(W4=\"o\",W4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AB4/100,MOD(AB4,100))","v":"00:00:00"},{"$f":"IF(OR(AA4=\"o\",AA4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AF4/100,MOD(AF4,100))","v":"00:00:00"},{"$f":"IF(OR(AE4=\"o\",AE4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AJ4/100,MOD(AJ4,100))","v":"00:00:00"},{"$f":"IF(OR(AI4=\"o\",AI4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AN4/100,MOD(AN4,100))","v":"00:00:00"},{"$f":"IF(OR(AM4=\"o\",AM4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AR4/100,MOD(AR4,100))","v":"00:00:00"},{"$f":"IF(OR(AQ4=\"o\",AQ4=\"\"),,1)","v":0},null,null,{"$f":"TIME(0,AV4/100,MOD(AV4,100))","v":"00:00:00"},{"$f":"IF(OR(AU4=\"o\",AU4=\"\"),,1)","v":0},{"$f":"COUNTA(D4,H4,L4,P4,T4,X4,AB4,AF4,AJ4,AN4,AR4,AV4)","v":0},{"$f":"VLOOKUP(AY4,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},{"$f":"E4+I4+M4+Q4+U4+Y4+AC4+AG4+AK4+AO4+AS4+AW4","v":"00:00:00"},{"$f":"IFERROR(BA4/AY4,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(BB4,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},{"$f":"F4+J4+N4+R4+V4+Z4+AD4+AH4+AL4+AP4+AT4+AX4","v":0},{"$f":"IFERROR(VLOOKUP(BD4,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"AZ4+BC4+BE4+BF4","v":10},{"$f":"(20/21)*BH4","v":9.5238095238095237}]
[null,null,null,null,{"$f":"TIME(0,D5/100,MOD(D5,100))","v":"00:00:00"},{"$f":"IF(OR(C5=\"o\",C5=\"\"),0,1)","v":0},null,null,{"$f":"TIME(0,H5/100,MOD(H5,100))","v":"00:00:00"},{"$f":"IF(OR(G5=\"o\",G5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(K5=\"o\",K5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(O5=\"o\",O5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(S5=\"o\",S5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(W5=\"o\",W5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(AA5=\"o\",AA5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(AE5=\"o\",AE5=\"\"),0,1)","v":0},null,null,"00:00:00",{"$f":"IF(OR(AI5=\"o\",AI5=\"\"),0,1)","v":0},null,null,{"$f":"TIME(0,AN5/100,MOD(AN5,100))","v":"00:00:00"},{"$f":"IF(OR(AM5=\"o\",AM5=\"\"),0,1)","v":0},null,null,{"$f":"TIME(0,AR5/100,MOD(AR5,100))","v":"00:00:00"},{"$f":"IF(OR(AQ5=\"o\",AQ5=\"\"),0,1)","v":0},null,null,{"$f":"TIME(0,AV5/100,MOD(AV5,100))","v":"00:00:00"},{"$f":"IF(OR(AU5=\"o\",AU5=\"\"),0,1)","v":0},0,{"$f":"VLOOKUP(AY5,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00",{"$f":"IFERROR(BA5/AY5,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(BB5,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD5,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,{"$f":"(20/21)*BH5","v":9.5238095238095237}]
[null,null,null,null,{"$f":"TIME(0,D6/100,MOD(D6,100))","v":"00:00:00"},0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY6,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB6,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD6,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY7,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB7,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD7,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY8,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB8,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD8,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY9,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB9,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD9,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY10,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB10,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD10,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY11,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB11,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD11,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY12,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB12,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD12,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY13,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB13,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD13,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,{"$f":"TIME(0,D14/100,MOD(D14,100))","v":"00:00:00"},0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY14,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB14,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD14,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY15,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB15,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD15,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY16,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB16,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD16,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY17,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB17,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD17,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,{"$f":"TIME(0,H18/100,MOD(H18,100))","v":"00:00:00"},0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY18,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB18,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD18,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY19,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB19,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD19,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY20,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB20,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD20,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY21,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB21,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD21,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY22,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB22,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD22,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY23,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB23,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD23,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY24,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB24,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD24,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY25,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB25,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD25,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY26,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB26,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD26,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY27,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB27,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD27,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY28,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB28,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD28,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY29,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB29,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD29,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY30,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB30,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD30,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY31,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB31,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD31,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY32,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB32,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD32,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY33,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB33,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD33,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY34,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB34,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD34,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY35,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB35,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD35,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY36,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB36,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD36,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,null,null,"00:00:00",0,0,{"$f":"VLOOKUP(AY37,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(BB37,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(BD37,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]

{"sheet":"gestion de course tradi","index":2,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,2,1,15]]}
[null,null,"Gestion de Course de CO traditionnelle de 12 balises  et Proposition d'une note selon 4 critères changeables (nombre de balises cherchées, rythme de course, nombre d'erreurs, lisibilité de la feuille de course)"]
[]
["NOM 1","NOM 2","tpsdecimal \nA saisir","Temps du parcours","Nbre Erreurs\n","Nb de balises cherchées","Note nbre de balises cherchées\n\n/5","Temps Total du parcours\n","rythme","note Rythme\n\n\n/5","Nombre d'erreurs","note Nombre d'erreurs\n\n/10","Lisibilité\nà saisir\n\n\n/1","Bonus éventuel","Note /21","Note/20"]
[null,null,null,{"$f":"TIME(0,C4/100,MOD(C4,100))","v":"00:00:00"},null,null,{"$f":"VLOOKUP(F4,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},{"$f":"D4","v":"00:00:00"},{"$f":"IFERROR(H4/F4,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(I4,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},{"$f":"E4","v":0},{"$f":"IFERROR(VLOOKUP(K4,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"G4+J4+L4+M4","v":10},{"$f":"(20/21)*O4","v":9.5238095238095237}]
[null,null,null,{"$f":"TIME(0,C5/100,MOD(C5,100))","v":"00:00:00"},null,null,{"$f":"VLOOKUP(F5,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},{"$f":"D5","v":"00:00:00"},{"$f":"IFERROR(H5/F5,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(I5,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},{"$f":"E5","v":0},{"$f":"IFERROR(VLOOKUP(K5,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,{"$f":"(20/21)*O5","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F6,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I6,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K6,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F7,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I7,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K7,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F8,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I8,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K8,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F9,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I9,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K9,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F10,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I10,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K10,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F11,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I11,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K11,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F12,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I12,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K12,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F13,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I13,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K13,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F14,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I14,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K14,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F15,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I15,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K15,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F16,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I16,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K16,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F17,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I17,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K17,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F18,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I18,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K18,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F19,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I19,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K19,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F20,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I20,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K20,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F21,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I21,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K21,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F22,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I22,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K22,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F23,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I23,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K23,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F24,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I24,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K24,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F25,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I25,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K25,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F26,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I26,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K26,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F27,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I27,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K27,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F28,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I28,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K28,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F29,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I29,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K29,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F30,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I30,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K30,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F31,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I31,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K31,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F32,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I32,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K32,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F33,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I33,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K33,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F34,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00",{"$f":"IFERROR(H34/F34,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(I34,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K34,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"G34+J34+L34+M34","v":10},{"$f":"(20/21)*O34","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F35,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00",{"$f":"IFERROR(H35/F35,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(I35,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K35,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"G35+J35+L35+M35","v":10},{"$f":"(20/21)*O35","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F36,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I36,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K36,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F37,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I37,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K37,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,{"$f":"VLOOKUP(F38,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(I38,'note rythmeFormat1et2'!$B$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(K38,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]

{"sheet":"Gestion CO parcours","index":3,"n_rows":37,"n_cols":49,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,0,37],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,19],[1,20,1,22],[1,23,1,25],[1,26,1,28],[1,29,1,31],[1,32,1,34],[1,35,1,37]]}
[null,null,"Gestion de Course de CO de 12 parcours ( 5 balises par parcours)  et Proposition d'une note selon 4 critères changeables (nombre de balises cherchées, rythme de course, nombre d'erreurs, lisibilité de la feuille de course). Une balise non trouvée est comptée comme fausse."]
[null,null,"Parcours 1",null,null,"Parcours 2",null,null,"Parcours 3",null,null,"Parcours 4",null,null,"Parcours 5",null,null,"Parcours 6",null,null,"Parcours 7",null,null,"Parcours 8",null,null,"Parcours 9",null,null,"Parcours 10",null,null,"Parcours 11",null,null,"Parcours 12"]
["NOM 1","NOM 2","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","Nb de parcours cherchés","Note nbre de balises cherchées\n\n/5","Temps Total du parcours\n","rythme","note Rythme\n\n/5","Nombre d'erreurs","note Nombre d'erreurs\n\n/10","Lisibilité\nà saisir\n/1","Bonus éventuel","Note /21","Note/20"]
[null,null,null,{"$f":"TIME(0,C4/100,MOD(C4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,F4/100,MOD(F4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,I4/100,MOD(I4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,L4/100,MOD(L4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,O4/100,MOD(O4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,R4/100,MOD(R4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,U4/100,MOD(U4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,X4/100,MOD(X4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AA4/100,MOD(AA4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AD4/100,MOD(AD4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AG4/100,MOD(AG4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AJ4/100,MOD(AJ4,100))","v":"00:00:00"},null,{"$f":"COUNTA(C4,F4,I4,L4,O4,R4,U4,X4,AA4,AD4,AG4,AJ4)","v":0},{"$f":"VLOOKUP(AM4,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},{"$f":"D4+G4+J4+M4+P4+S4+V4+Y4+AB4+AE4+AH4+AK4","v":"00:00:00"},{"$f":"IFERROR(AO4/AM4,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(AP4,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},{"$f":"E4+H4+K4+N4+Q4+T4+W4+Z4+AC4+AF4+AI4+AL4","v":0},{"$f":"IFERROR(VLOOKUP(AR4,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"AN4+AQ4+AS4+AT4","v":10},{"$f":"(20/21)*AV4","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,{"$f":"TIME(0,F5/100,MOD(F5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,I5/100,MOD(I5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,L5/100,MOD(L5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,O5/100,MOD(O5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,R5/100,MOD(R5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,U5/100,MOD(U5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,X5/100,MOD(X5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AA5/100,MOD(AA5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AD5/100,MOD(AD5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AG5/100,MOD(AG5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AJ5/100,MOD(AJ5,100))","v":"00:00:00"},null,0,{"$f":"VLOOKUP(AM5,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00",{"$f":"IFERROR(AO5/AM5,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(AP5,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR5,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,{"$f":"(20/21)*AV5","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM6,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP6,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR6,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM7,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP7,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR7,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM8,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP8,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR8,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM9,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP9,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR9,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM10,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP10,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR10,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM11,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP11,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR11,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM12,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP12,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR12,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM13,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP13,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR13,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM14,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP14,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR14,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM15,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP15,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR15,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM16,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP16,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR16,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM17,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP17,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR17,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM18,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP18,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR18,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM19,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP19,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR19,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM20,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP20,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR20,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM21,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP21,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR21,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM22,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP22,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR22,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM23,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP23,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR23,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM24,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP24,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR24,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM25,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP25,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR25,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM26,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP26,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR26,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM27,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP27,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR27,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM28,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP28,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR28,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM29,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP29,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR29,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM30,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP30,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR30,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM31,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP31,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR31,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM32,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP32,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR32,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM33,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP33,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR33,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM34,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP34,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR34,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM35,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP35,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR35,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM36,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP36,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR36,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM37,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP37,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR37,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]

{"sheet":"Gestion CO cartes","index":4,"n_rows":37,"n_cols":49,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,29,1,31],[1,32,1,34],[1,35,1,37],[0,2,0,37],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,19],[1,20,1,22],[1,23,1,25],[1,26,1,28]]}
[null,null,"Gestion de Course de CO de 12 cartes (5 balises par carte)  et Proposition d'une note selon 4 critères changeables (nombre de balises cherchées, rythme de course, nombre d'erreurs, lisibilité de la feuille de course). Une balise non trouvée est comptée comme fausse."]
[null,null,"Carte 1",null,null,"Carte 2",null,null,"Carte 3",null,null,"Carte 4",null,null,"Carte 5",null,null,"Carte 6",null,null,"Carte 7",null,null,"Carte 8",null,null,"Carte 9",null,null,"Carte 10",null,null,"Carte 11",null,null,"Carte 12"]
["NOM 1","NOM 2","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","tpsdecimal\nA saisir","Temps","Erreurs","Nb de cartes cherchées","Note nbre de balises cherchées\n\n/5","Temps Total du parcours\n","rythme","note Rythme\n\n/5","Nombre d'erreurs","note Nombre d'erreurs\n\n/10","Lisibilité\nà saisir\n/1","Bonus éventuel","Note /21","Note/20"]
[null,null,null,{"$f":"TIME(0,C4/100,MOD(C4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,F4/100,MOD(F4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,I4/100,MOD(I4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,L4/100,MOD(L4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,O4/100,MOD(O4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,R4/100,MOD(R4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,U4/100,MOD(U4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,X4/100,MOD(X4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AA4/100,MOD(AA4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AD4/100,MOD(AD4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AG4/100,MOD(AG4,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AJ4/100,MOD(AJ4,100))","v":"00:00:00"},null,{"$f":"COUNTA(C4,F4,I4,L4,O4,R4,U4,X4,AA4,AD4,AG4,AJ4)","v":0},{"$f":"VLOOKUP(AM4,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},{"$f":"D4+G4+J4+M4+P4+S4+V4+Y4+AB4+AE4+AH4+AK4","v":"00:00:00"},{"$f":"IFERROR(AO4/AM4,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(AP4,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},{"$f":"E4+H4+K4+N4+Q4+T4+W4+Z4+AC4+AF4+AI4+AL4","v":0},{"$f":"IFERROR(VLOOKUP(AR4,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,{"$f":"AN4+AQ4+AS4+AT4","v":10},{"$f":"(20/21)*AV4","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,{"$f":"TIME(0,F5/100,MOD(F5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,I5/100,MOD(I5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,L5/100,MOD(L5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,O5/100,MOD(O5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,R5/100,MOD(R5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,U5/100,MOD(U5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,X5/100,MOD(X5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AA5/100,MOD(AA5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AD5/100,MOD(AD5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AG5/100,MOD(AG5,100))","v":"00:00:00"},null,null,{"$f":"TIME(0,AJ5/100,MOD(AJ5,100))","v":"00:00:00"},null,0,{"$f":"VLOOKUP(AM5,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00",{"$f":"IFERROR(AO5/AM5,0)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(AP5,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR5,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,{"$f":"(20/21)*AV5","v":9.5238095238095237}]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM6,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP6,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR6,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM7,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP7,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR7,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM8,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP8,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR8,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM9,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP9,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR9,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM10,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP10,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR10,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM11,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP11,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR11,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM12,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP12,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR12,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM13,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP13,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR13,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM14,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP14,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR14,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM15,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP15,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR15,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM16,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP16,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR16,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM17,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP17,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR17,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM18,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP18,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR18,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM19,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP19,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR19,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM20,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP20,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR20,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM21,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP21,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR21,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM22,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP22,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR22,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM23,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP23,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR23,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM24,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP24,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR24,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM25,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP25,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR25,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM26,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP26,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR26,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM27,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP27,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR27,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM28,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP28,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR28,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM29,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP29,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR29,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM30,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP30,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR30,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM31,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP31,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR31,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM32,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP32,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR32,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM33,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP33,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR33,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM34,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP34,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR34,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM35,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP35,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR35,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM36,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP36,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR36,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]
[null,null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,null,"00:00:00",null,0,{"$f":"VLOOKUP(AM37,'note  balises cherchéesFormat12'!$B$3:$C$13,2,TRUE)","v":0},"00:00:00","00:00:00",{"$f":"IFERROR(VLOOKUP(AP37,'note rythmeFormat1et2'!$C$3:$D$14,2,TRUE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(AR37,'note nbre erreursformat1et2'!$C$2:$D$9,2,TRUE),0)","v":10},null,null,10,9.5238095238095237]

{"sheet":"note rythmeFormat1et2","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Note rythme"]
[null,100,{"$f":"TIME(0,B3/100,MOD(B3,100))","v":"00:01:00"},5]
[null,200,"00:02:00",5]
[null,300,"00:03:00",5]
[null,400,"00:04:00",4.5]
[null,430,"00:04:30",4]
[null,500,"00:05:00",3.5]
[null,530,"00:05:30",3]
[null,600,"00:06:00",2.5]
[null,630,"00:06:30",1.5]
[null,700,"00:07:00",1]
[null,800,"00:08:00",0]
[null,1500,"00:15:00",0]

{"sheet":"note nbre erreursformat1et2","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,0,10]
[null,null,1,9]
[null,null,2,8]
[null,null,3,6]
[null,null,4,4]
[null,null,5,2]
[null,null,6,1]
[null,null,7,0]

{"sheet":"note  balises cherchéesFormat12","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"note nbre parcours"]
[null,0,0]
[null,3,1.5]
[null,4,2]
[null,5,2.5]
[null,6,3]
[null,7,3.5]
[null,8,4]
[null,9,4.5]
[null,10,4]
[null,11,5]
[null,12,5]

{"sheet":"note parcourscherchésformat3et4","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"liste d'élèves","index":9,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,1,1]]}
["Copier/coller votre liste d'élèves"]
[]
["NOM","PRENOM"]
["NOM1","Prenom1"]
["NOM2","Prenom2"]
["NOM3","Prenom3"]
["NOM4","Prenom4"]
["NOM5","Prenom5"]
["NOM6","Prenom6"]
["NOM7","Prenom7"]
["NOM8","Prenom8"]
["NOM9","Prenom9"]
["NOM10","Prenom10"]
["NOM11","Prenom11"]
["NOM12","Prenom12"]
["NOM13","Prenom13"]
["NOM14","Prenom14"]
["NOM15","Prenom15"]
["NOM16","Prenom16"]
["NOM17","Prenom17"]
["NOM18","Prenom18"]
["NOM19","Prenom19"]
["NOM20","Prenom20"]
["NOM21","Prenom21"]
["NOM22","Prenom22"]
["NOM23","Prenom23"]
["NOM24","Prenom24"]
["NOM25","Prenom25"]
["NOM26","Prenom26"]
["NOM27","Prenom27"]
["NOM28","Prenom28"]
["NOM29","Prenom29"]
["NOM30","Prenom30"]
["NOM31","Prenom31"]
["NOM32","Prenom32"]
["NOM33","Prenom33"]
["NOM34","Prenom34"]

{"sheet":"validation de données","index":10,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"o",null,null,null,1,null,1]
[null,"n",null,null,null,2,null,2]
[null,null,null,null,null,3,null,3]
[null,null,null,null,null,4,null,4]
[null,null,null,null,null,5,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,null,9]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12]

{"sheet":"Baremes 1","index":11,"n_rows":23,"n_cols":34,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,0,9,1],[11,2,11,3],[11,13,11,15],[15,2,15,3],[15,0,15,1],[13,0,13,2],[11,6,11,7],[11,11,11,12],[13,12,13,15],[10,0,10,15],[14,0,14,15],[15,6,15,7],[15,14,15,15],[15,4,15,5],[15,12,15,13],[15,10,15,11],[14,18,14,19],[14,20,14,22],[13,6,13,8],[13,9,13,11],[12,18,12,34],[13,33,13,34],[12,0,12,15],[14,31,14,32],[14,33,14,34],[14,23,14,24],[13,18,13,19],[14,25,14,26],[14,27,14,28],[14,29,14,30],[13,3,13,5],[13,31,13,32],[13,29,13,30],[13,20,13,22],[13,23,13,24],[13,25,13,26],[13,27,13,28],[15,8,15,9],[22,0,23,15],[17,0,17,3],[17,4,17,7],[17,8,17,11],[16,0,16,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Barêmes 1"]
["Nombre de balises cherchées                                                                                                                                                              /5 points"]
["<3 = 0pt","3 = 1pt","4=1,5pts",null,"5=2pts","6=2,5pts","7=3pts",null,"8= 3,5pts","9=4pts","10=4,5pts","11= 5pts",null,"12= 5pts"]
["Rythme de course=temps de recherche moyen par balise (Temps Total de course/Nb de balises cherchées)       /5points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Détail du barême Rythme ( Temps Total de course / Nb de balises cherchées)                           /5 points"]
["Marche + de 7 min",null,null,"Marche rapide de 6 min à 7 min",null,null,"Course de 5 min à 6 min",null,null,"Course rapide de 4 min à 5 min",null,null,"Course ultra rapide moins de 4min",null,null,null,null,null,">7=0 pt",null,"<7-6:30=1pt",null,null,"6:30-6:00=2pts",null,"6:00-5:30=2,5pts",null,"5:30-5:00=3pts",null,"5:00-4:30=4pts",null,"4:30-4=4,5pts",null,"<4=5 pts"]
["Nombre d'erreurs balises                                                                                                                                                                     /10points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marche",null,"Marche rapide",null,null,"Marche rapide",null,"course",null,"course",null,"Course rapide",null,"course rapide",null,"course ultra rapide"]
["7 erreurs=0 pt",null,"6 erreurs=1 pt",null,"5 erreurs=2 pts",null,"4 erreurs=4 pts",null,"3 erreurs= 6 pts",null,"2 erreurs= 8pts",null,"1 erreur=9pts",null,"0 erreur=10pts"]
["Lisibilité fiche de course                                                                                                       /1 point"]
["0pt = Illisible",null,null,null,"0,5pt = Moyen",null,null,null,"1pt = Propre"]
[]
[]
[]
[]
["Nombre de balises cherchées=Nombre de balises relevées sur la feuille de course et relevant d'une activité de recherche. Ce critère qui peut être facile sans réelle activitée de recherche est contrebalancé par un barême sur le critère Nombre d'erreurs balises sévère. Il faudra le signifier aux élèves. On ne marque pas n'importe quoi. Le but n'est pas de remplir arbitrairement la feuille de course."]

{"sheet":"Bareme 2","index":12,"n_rows":22,"n_cols":33,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,15],[11,2,11,3],[11,6,11,7],[11,11,11,12],[11,13,11,15],[12,0,12,15],[13,0,13,2],[13,3,13,5],[13,6,13,8],[13,9,13,11],[13,12,13,15],[14,0,14,15],[15,0,15,1],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[12,17,12,33],[13,17,13,18],[13,19,13,21],[13,22,13,23],[13,24,13,25],[13,26,13,27],[14,32,14,33],[21,0,22,15],[13,28,13,29],[13,30,13,31],[13,32,13,33],[14,17,14,18],[14,19,14,21],[14,22,14,23],[14,24,14,25],[14,26,14,27],[14,28,14,29],[14,30,14,31],[16,0,16,11],[17,0,17,3],[17,4,17,7],[17,8,17,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Barêmes 2"]
["Nombre de parcours ou cartes cherchés                                                                                                                                                                                    /5 points"]
["<3 = 0pt","3 = 1pt","4=1,5pts",null,"5=2pts","6=2,5pts","7=3pts",null,"8= 3,5pts","9=4pts","10=4,5pts","11= 5pts",null,"12= 5pts"]
["Rythme de course=temps de recherche moyen par parcours ou carte (Temps Total de course/Nb de parcours ou cartes cherchés)     /5points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Détail du barême Rythme ( Temps Total de course / Nb de parcours ou cartes effectués)                           /5 points"]
["Marche + de 7 min",null,null,"Marche rapide de 6 min à 7 min",null,null,"Course de 5 min à 6 min",null,null,"Course rapide de 4 min à 5 min",null,null,"Course ultra rapide moins de 4min",null,null,null,null,">7=0 pt",null,"<7-6:30=1pt",null,null,"6:30-6:00=2pts",null,"6:00-5:30=2,5pts",null,"5:30-5:00=3pts",null,"5:00-4:30=4pts",null,"4:30-4=4,5pts",null,"<4=5 pts"]
["Nombre d'erreurs balises                                                                                                                                                                                                                 /10points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marche",null,"Marche rapide",null,null,"Marche rapide",null,"course",null,"course",null,"Course rapide",null,"course rapide",null,"course ultra rapide"]
[" 10 erreurs=0 pt",null," 9 erreurs=1 pt",null,"8 erreurs=2 pts",null," 7 erreurs=4 pts",null," 6 erreurs= 6 pts",null," 4 erreurs= 8pts",null,"2 erreurs=9pts",null,"0 erreur=10pts"]
["Lisibilité fiche de course                                                                                                                                                /1 point"]
["0pt = Illisible",null,null,null,"0,5pt = Moyen",null,null,null,"1pt = Propre"]
[]
[]
[]
["Nombre de parcours ou cartes cherchés=relevant d'une véritable activité de recherche. Ce critère qui peut être facile sans réelle activitée de recherche est contrebalancé par un barême sur le critère Nombre d'erreurs balises sévère. Il faudra le signifier aux élèves. On ne marque pas n'importe quoi. Le but n'est pas de remplir arbitrairement la feuille de course."]