{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["1- Regles et consignes de sécu","2- Traversées et pose de pieds","3- Défi de grimpe par groupe","Feuille de score","4- Défis individuel + Diplomes","Contest individuel - G1","Contest individuel - G2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1- Regles et consignes de sécu","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,0,19,3]]}
["Cycle:","4 séances","Thème de la séance:","Creneau :",null,"Date:","2026-06-08"]
["Séance:",1,"Initiation groupe scolaire - Regles et consignes de sécurité + vocabulaire de base"]
["Nombre:",20]
["ATELIER","CONSIGNES","SITU PEDA","VARIANTE -","VARIANTE +","CRIT REUSSITE","TEMPS"]
["Accueil du groupe",null,"- Accueil\n- Présentation de la séance\n- Les eleves se changent et se regroupent pour le début de séance",null,null,null,"00:10:00"]
["Règles de sécurité","Ecouter les consignes","Explication des règles de sécurité dans une salle de bloc:\n- Ne pas courir\n- Ne pas se trouver sous un grimpeur\n- Ne pas sauter du haut des murs\n- Ne pas dépasser une certaine hauteur pour les plus petits (prise de redescente)",null,null,"Consignes entendues par le groupe","00:10:00"]
["Echauffement",null,"Articulaire et cardiaque",null,null,"Rythme cardiaque accéléré, corps échauffé.","00:10:00"]
["Jeu des consignes\n+ Vocabulaire","Essayer de reproduire la consigne demandée","Appel des couleurs, postures sur le mur, positions au sol... Garder les consignes adaptées au publique et au nombre d'eleves. Exploration des murs. Jeauger les eleves pour repérer les difficultés et les comportement.\nIntroduction du vocabulaire simple: bac, reglette, volume, plat.",null,null,"ECD réussir 3 consignes\nECD retenir 2 mots de vocabulaire","00:20:00"]
["Grimpe libre - COMPORTEMENT ET SECURITE","Rappel des règles de sécurité + grimper librement","Les eleves sont libres d'explorer la salle et respectant les consignes de sécurité. Ce servir de ce moment pour jeauger les comportements, rappeler les consignes de sécurité etc. HAUTEUR LIMITEE",null,null,null,"00:10:00"]
["Rappel des règles de sécurité + chutes","Apprendre à chuter ","Démonstration et exercices de chutes (pieds - fesses - dos)",null,null,null,"00:10:00"]
["Grimpe libre - TRAVAIL DES CHUTES","Explorer la salle","Les eleves travaillent les chutes amorties. \nRéaliser une chute du sol, des premieres prises puis de plus haut pour se mettre à l'aise.",null,null,null,"00:20:00"]
["Pause fin","Repos","Les eleves se reposes et prennent un goûter",null,null,null,"00:05:00"]
["Grimpe libre","Explorer les 2 salles","En fonction des comportement, retour sur les consignes de sécurité. Si tout OK, sans limite de hauteur.",null,null,null,"00:15:00"]
["Retour de séance","Echange avec les élèves","Les eleves et encadrants échangent sur la séance, ce qui s'est bien passé, moins bien passé.",null,null,null,"00:05:00"]
["Recupération des affaires","Récuperer les affaires et se ranger pour la sortie","Les eleves se préparent pour repartir.",null,null,null,"00:05:00"]
["Notes: CONSIGNES SECU RESPECTEES, GRIMPE LIBRE SANS LIMITE DE HAUTEUR. TRAVAIL DE LA CHUTE. REGLES DE L'ESCALADE.",{"$nulls":4},"Durée de séance:",{"$f":"SUM(G5:G15)","v":"02:00:00"}]
[]
[]
[]
[]
[" "]

{"sheet":"2- Traversées et pose de pieds","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,0,20,3]]}
["Cycle:","4 séances","Thème de la séance:","Creneau :",null,"Date:","2026-05-19"]
["Séance:",2,"Initiation groupe scolaire - Traversées et pose de pieds - regles de l'escalade"]
["Nombre:",20]
["ATELIER","CONSIGNES","SITU PEDA","VARIANTE -","VARIANTE +","CRIT REUSSITE","TEMPS"]
["Accueil du groupe",null,"- Accueil\n- Présentation de la séance\n- Les eleves se changent et se regroupent pour le début de séance",null,null,null,"00:05:00"]
["Règles de sécurité","Ecouter les consignes","Explication des règles de sécurité dans une salle de bloc:\n- Ne pas courir\n- Ne pas se trouver sous un grimpeur\n- Ne pas sauter du haut des murs\n- Ne pas dépasser une certaine hauteur pour les plus petits (prise de redescente)",null,null,"Consignes entendues par le groupe","00:05:00"]
["Echauffement",null,"Articulaire et cardiaque",null,null,"Rythme cardiaque accéléré, corps échauffé.","00:10:00"]
["Jeu des consignes","Essayer de reproduire la consigne demandée","Appel des couleurs, postures sur le mur, positions au sol... Garder les consignes adaptées au publique et au nombre d'eleves. Exploration des murs. Jeauger les eleves pour repérer les difficultés et les comportement.",null,null,"ECD réussir 3 consignes","00:10:00"]
["Atelier pose de pieds en traversée","Traversées en posant la pointe des pieds","Diviser le groupe sur plusieurs traversées. Insister sur la pose de pieds sur la pointe. 2 passages par traversée puis tourner les groupes. 4 traversées, donc 4 groupes.",null,null,null,"00:15:00"]
["Pause (mi-séance)","Repos","Les eleves se reposes et prennent un goûter",null,null,null,"00:05:00"]
["Jeu en traversée\n(ex: foulard, shifumi, balles et paniers…)",{"$nulls":5},"00:20:00"]
["Règles de l'escalade et Règles de sécurité","Ecouter les règlers","Explication des règles de l'escalade de bloc:\n- Parcours de couleur\n- Etiquettes de départ et de top\n- Cotations\nRappel des règles de sécurité.",null,null,null,"00:10:00"]
["Grimpe libre cotation",null,"Essayer de faire 3 blocs en respectant les règles de l'escalade.\nPosition de départ\nUne seule couleur + volumes\nPosition de top (3s + equilibre)",null,null,null,"00:15:00"]
["Pause (mi-séance)","Repos","Les eleves se reposes et prennent un goûter",null,null,null,"00:05:00"]
["Retour de séance","Echange avec les élèves","Les eleves et encadrants échangent sur la séance, ce qui s'est bien passé, moins bien passé.",null,null,null,"00:05:00"]
["Recupération des affaires","Récuperer les affaires et se ranger pour la sortie","Les eleves se préparent pour repartir.",null,null,null,"00:05:00"]
["Notes: JEU DES CONSIGNES ELIMINATOIRE, RAPPEL SECU,  TRAVERSEES DANS UN SENS PUIS L'AUTRE, REGLES DE L'ESCALADE",{"$nulls":4},"Durée de séance:",{"$f":"SUM(G5:G16)","v":"01:50:00"}]
[]
[]
[]
[]
[" "]

{"sheet":"3- Défi de grimpe par groupe","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,0,18,3]]}
["Cycle:","4 séances","Thème de la séance:","Creneau :",null,"Date:","2026-06-11"]
["Séance:",3,"Initiation groupe scolaire - Défi de grimpe par groupe"]
["Nombre:",20]
["ATELIER","CONSIGNES","SITU PEDA","VARIANTE -","VARIANTE +","CRIT REUSSITE","TEMPS"]
["Accueil du groupe",null,"- Accueil\n- Présentation de la séance\n- Les eleves se changent et se regroupent pour le début de séance",null,null,null,"00:10:00"]
["Echauffement",null,"Articulaire et cardiaque",null,null,"Rythme cardiaque accéléré, corps échauffé.","00:10:00"]
["Jeu des consignes","Essayer de reproduire la consigne demandée","Appel des couleurs, postures sur le mur, positions au sol… Rappel du vocabulaire.",null,null,"ECD réussir 3 consignes","00:15:00"]
["Jeu des consignes éliminatoire","Essayer de reproduire la consigne demandée","Appel des couleurs, postures sur le mur, positions au sol... Avec un décompte de temps. Si la position n'est pas réalisée, l'eleve est éliminé.",null,null,"ECD réussir toutes le consignes données","00:10:00"]
["Grimpe libre cotation",null,"Par equipe (2 CE1 et 2 CE2). Faire un maximum de blocs différents.",null,null,null,"00:10:00"]
["Pause (mi-séance)","Repos","Les eleves se reposes et prennent un goûter",null,null,null,"00:05:00"]
["Rappel des Règles de l'escalade et Règles de sécurité","Apprendre à croiser / décroiser","Rappel des règles: depart sur les etiquettes, une couleur, top.",null,null,null,"00:15:00"]
["Défi de grimpe par groupe","Réaliser un maximum de blocs","2 équipes par classe. Chaque bloc rapporte des points en fonction de sa cotation. \nB = 1\nV = 2\nR = 5\nVi = 10\nN = 50\nG = 500\nBla = 1 000 000\n2 prises bonus autorisées par blocs à partir du niveau rouge.",null,null,null,"00:35:00"]
["Retour de séance","Echange avec les élèves","Les eleves et encadrants échangent sur la séance, ce qui s'est bien passé, moins bien passé.",null,null,null,"00:05:00"]
["Recupération des affaires","Récuperer les affaires et se ranger pour la sortie","Les eleves se préparent pour repartir.",null,null,null,"00:05:00"]
["Notes: Echauffement, jeu des consignes avec eliminations, défis de groupe bloc max.",{"$nulls":4},"Durée de séance:",{"$f":"SUM(G5:G14)","v":"02:00:00"}]
[]
[]
[]
[]
[" "]

{"sheet":"Feuille de score","index":3,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,0,9,2],[0,0,0,1],[0,12,2,12],[1,0,1,1],[2,0,2,2],[2,3,2,9],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[21,10,21,11],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,21,9],[33,0,33,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1]]}
["Defis",null,"Cotation","BLEU","VERT","ROUGE","VIOLET","NOIR","GRIS","BLANC",null,null,"SCORE\nAddition des points"]
[null,null,"Points par blocs dans la cotation","2p","5p","10p","20p","50p","500p","1000p"]
["Prenom / Equipe",null,null,"Noter le nombre de blocs réussis par cotation dans les colonnes ci-dessous"]
{"$rows_empty":17}
["Un bloc ne peut pas être fait deux fois de suite. Une cotation intermediaire (bi-color) vaut pour la cotation supérieure.\n+2 prises bonus pour les blocs à partir de Rouge, +3 prises bonus à partir des blocs Violets."]

{"sheet":"4- Défis individuel + Diplomes","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,0,16,3]]}
["Cycle:","4 séances","Thème de la séance:","Creneau :",null,"Date:","2026-05-22"]
["Séance:",4,"Initiation groupe scolaire - Défis individuel + Diplômes"]
["Nombre:",20]
["ATELIER","CONSIGNES","SITU PEDA","VARIANTE -","VARIANTE +","CRIT REUSSITE","TEMPS"]
["Accueil du groupe",null,"- Accueil\n- Présentation de la séance\n- Les eleves se changent et se regroupent pour le début de séance",null,null,null,"00:05:00"]
["Règles de sécurité","Ecouter les consignes","Explication des règles de sécurité dans une salle de bloc:\n- Ne pas courir\n- Ne pas se trouver sous un grimpeur\n- Ne pas sauter du haut des murs\n- Ne pas dépasser une certaine hauteur pour les plus petits (prise de redescente)",null,null,"Consignes entendues par le groupe","00:05:00"]
["Echauffement",null,"Articulaire et cardiaque (Loup gainage?)",null,null,"Rythme cardiaque accéléré, corps échauffé.","00:10:00"]
["Jeu des consignes","Essayer de reproduire la consigne demandée","Appel des couleurs, postures sur le mur, positions au sol... Garder les consignes adaptées au publique et au nombre d'eleves. Exploration des murs. Jeauger les eleves pour repérer les difficultés et les comportement.",null,null,"ECD réussir 3 consignes","00:15:00"]
["Pause (mi-séance)","Repos","Les eleves se reposes et prennent un goûter",null,null,null,"00:05:00"]
["Contest individuel","Faire un maximum de points","16 Blocs répartis dans la salle, comptage en 1000/reussites",null,null,null,"01:00:00"]
["Retour de séance + Diplômes","Echange avec les élèves","Les eleves et encadrants échangent sur la séance, ce qui s'est bien passé, moins bien passé.\nRemise des diplômes",null,null,null,"00:10:00"]
["Recupération des affaires","Récuperer les affaires et se ranger pour la sortie","Les eleves se préparent pour repartir.",null,null,null,"00:05:00"]
["Notes: tres bonne ambiance, et motivation de chacuns",{"$nulls":4},"Durée de séance:",{"$f":"SUM(G5:G12)","v":"01:55:00"}]
[]
[]
[]
[]
[" "]

{"sheet":"Contest individuel - G1","index":5,"n_rows":27,"n_cols":31,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Couleur des prises (Secteur)","Jaunes (Cigognes)","Oranges (Coin Enfants)","Roses (Coin Enfants)","Noires (Etrave)","Oranges (Réta)","Violettes ( Devers)","Bois (Dalle)","Kilter","Vertes (Cirque)","Vertes (Dalle)","Turquoises ( Terrasse)","Oranges ( Proue)","Bleues ( Cigogne )",null,null,null,"SCORE",null,"RANG","EN FINALE","Bloc Finale 1",null,null,null,"Bloc Finale 2",{"$nulls":4},"PODIUM"]
["Participant",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,{"$nulls":4},"Top","Z","P","E","Top","Z","P","E","Points"]
["CHLOE",{"$nulls":16},{"$f":"IF(A3=\"\",\"\",SUMIF(B3:Q3,\"X\",$B$26:$Q$26))","v":0},{"$f":"IF(A3=\"\",\"\",R3-((COUNTIF(B3:Q3,\"X\")*0.001)))","v":0},{"$f":"IF(A3=\"\",\"\",IF(RANK(S3,$S$3:$S$25,0)=1,\"1er\",RANK(S3,$S$3:$S$25,0)&\"ème\"))","v":"1er"},{"$nulls":9},{"$f":"IF(U3<>\"X\",\"\",IF(V3=\"X\",75+25*EXP(-(Y3-1)*0.05),IF(W3=\"X\",25+50*EXP(-(Y3-1)*0.05),25*(1-EXP(-X3*0.2))))+IF(Z3=\"X\",75+25*EXP(-(AC3-1)*0.05),IF(AA3=\"X\",25+50*EXP(-(AC3-1)*0.05),25*(1-EXP(-AB3*0.2)))))","v":""}]
["EDNA",{"$nulls":16},0,0,"1er",{"$nulls":9},{"$f":"IF(U4<>\"X\",\"\",IF(V4=\"X\",75+25*EXP(-(Y4-1)*0.05),IF(W4=\"X\",25+50*EXP(-(Y4-1)*0.05),25*(1-EXP(-X4*0.2))))+IF(Z4=\"X\",75+25*EXP(-(AC4-1)*0.05),IF(AA4=\"X\",25+50*EXP(-(AC4-1)*0.05),25*(1-EXP(-AB4*0.2)))))","v":""}]
["PIERRE",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["MONA",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["KAMEEL",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ADAM",{"$nulls":16},0,0,"1er"]
["FAYCAL",{"$nulls":16},0,0,"1er"]
["MARCEL",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ELISABETH",{"$nulls":16},0,0,"1er"]
["YOUSSEF",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["FELIX",{"$nulls":16},0,0,"1er"]
["MATHIAS",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ELIAS",{"$nulls":16},0,0,"1er"]
["LEO",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ANTHONY",{"$nulls":16},0,0,"1er"]
["MIA",{"$nulls":16},0,0,"1er"]
["HUGO",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["HELOISE",{"$nulls":16},0,0,"1er"]
["LOUNES",{"$nulls":16},0,0,"1er"]
["CELY",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["GASPARD",{"$nulls":16},0,0,"1er"]
["CAMELIA",{"$nulls":16},0,0,"1er"]
[{"$nulls":17},"","","",{"$nulls":9},""]
["Valeur",{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\")))","v":""}]
["Réussite",{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))/COUNTA($A$3:$A$25))","v":""}]

{"sheet":"Contest individuel - G2","index":6,"n_rows":27,"n_cols":31,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Couleur des prises (Secteur)","Jaunes (Cigognes)","Oranges (Coin Enfants)","Roses (Coin Enfants)","Noires (Etrave)","Oranges (Réta)","Violettes ( Devers)","Bois (Dalle)","Kilter","Vertes (Cirque)","Vertes (Dalle)","Turquoises ( Terrasse)","Oranges ( Proue)","Bleues ( Cigogne )",null,null,null,"SCORE",null,"RANG","EN FINALE","Bloc Finale 1",null,null,null,"Bloc Finale 2",{"$nulls":4},"PODIUM"]
["Participant",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,{"$nulls":4},"Top","Z","P","E","Top","Z","P","E","Points"]
["CHLOE",{"$nulls":16},{"$f":"IF(A3=\"\",\"\",SUMIF(B3:Q3,\"X\",$B$26:$Q$26))","v":0},{"$f":"IF(A3=\"\",\"\",R3-((COUNTIF(B3:Q3,\"X\")*0.001)))","v":0},{"$f":"IF(A3=\"\",\"\",IF(RANK(S3,$S$3:$S$25,0)=1,\"1er\",RANK(S3,$S$3:$S$25,0)&\"ème\"))","v":"1er"},{"$nulls":9},{"$f":"IF(U3<>\"X\",\"\",IF(V3=\"X\",75+25*EXP(-(Y3-1)*0.05),IF(W3=\"X\",25+50*EXP(-(Y3-1)*0.05),25*(1-EXP(-X3*0.2))))+IF(Z3=\"X\",75+25*EXP(-(AC3-1)*0.05),IF(AA3=\"X\",25+50*EXP(-(AC3-1)*0.05),25*(1-EXP(-AB3*0.2)))))","v":""}]
["EDNA",{"$nulls":16},0,0,"1er",{"$nulls":9},{"$f":"IF(U4<>\"X\",\"\",IF(V4=\"X\",75+25*EXP(-(Y4-1)*0.05),IF(W4=\"X\",25+50*EXP(-(Y4-1)*0.05),25*(1-EXP(-X4*0.2))))+IF(Z4=\"X\",75+25*EXP(-(AC4-1)*0.05),IF(AA4=\"X\",25+50*EXP(-(AC4-1)*0.05),25*(1-EXP(-AB4*0.2)))))","v":""}]
["PIERRE",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["MONA",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["KAMEEL",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ADAM",{"$nulls":16},0,0,"1er"]
["FAYCAL",{"$nulls":16},0,0,"1er"]
["MARCEL",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ELISABETH",{"$nulls":16},0,0,"1er"]
["YOUSSEF",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["FELIX",{"$nulls":16},0,0,"1er"]
["MATHIAS",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ELIAS",{"$nulls":16},0,0,"1er"]
["LEO",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["ANTHONY",{"$nulls":16},0,0,"1er"]
["MIA",{"$nulls":16},0,0,"1er"]
["HUGO",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["HELOISE",{"$nulls":16},0,0,"1er"]
["LOUNES",{"$nulls":16},0,0,"1er"]
["CELY",{"$nulls":16},0,0,"1er",{"$nulls":9},""]
["GASPARD",{"$nulls":16},0,0,"1er"]
["CAMELIA",{"$nulls":16},0,0,"1er"]
[{"$nulls":17},"","","",{"$nulls":9},""]
["Valeur",{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\")))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))=0,\"\",1000/SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\")))","v":""}]
["Réussite",{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(B3:B25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(C3:C25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(D3:D25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(E3:E25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(F3:F25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(G3:G25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(H3:H25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(I3:I25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(J3:J25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(K3:K25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(L3:L25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(M3:M25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(N3:N25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(O3:O25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(P3:P25=\"X\"))/COUNTA($A$3:$A$25))","v":""},{"$f":"IF(SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))=0,\"\",SUMPRODUCT(($A$3:$A$25<>\"\")*(Q3:Q25=\"X\"))/COUNTA($A$3:$A$25))","v":""}]