{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["D1 VET Gr A","D1 VET Gr B","D2 VET Gr A","D2 VET Gr B","D3 VET Gr A","D3 VET Gr B","CLASSEMENT"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":"D1 VET Gr A","index":0,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[29,1,29,10],[13,6,13,7],[26,1,26,10],[27,1,27,10],[28,1,28,10],[15,2,15,5],[20,2,20,5],[24,6,24,9],[12,6,12,9],[10,6,10,9],[0,2,0,5],[5,2,5,5],[10,2,10,5],[0,6,0,9],[5,6,5,9]]}
[1,"USC SENS 1","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"STADE DE SENS 1",{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$2","v":"STADE DE SENS 1"},20,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":16},{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$6","v":"AILLANT 1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"AILLANT 1",18,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":2},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":18},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":0}]
[3,"JOIGNY 1",{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$4","v":"PARON 1"},18,18,{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$5","v":"VERON 1"},null,"",null,null,null,null,null,"AILLANT 1",22,3,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":22},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":8}]
[4,"PARON 1",{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$6","v":"AILLANT 1"},18,18,{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$4","v":"PARON 1"},null,"",null,null,null,null,null,"AILLANT 1",null,"",null,null,0,""]
[5,"VERON 1",{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$8","v":"APPOIGNY 2"},16,20,{"$f":"$B$8","v":"APPOIGNY 2"},{"$f":"$B$2","v":"STADE DE SENS 1"},null,"",null,null,null,null,null,"AILLANT 1",null,"",null,null,0,""]
[6,"AILLANT 1","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,"AILLANT 1","","",null,null,0,""]
[7,"VAUX 2",{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$1","v":"USC SENS 1"},20,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":16},{"$f":"$B$6","v":"AILLANT 1"},{"$f":"$B$7","v":"VAUX 2"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"AILLANT 1","","",null,null,0,""]
[8,"APPOIGNY 2",{"$f":"$B$6","v":"AILLANT 1"},{"$f":"$B$3","v":"JOIGNY 1"},22,14,{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$2","v":"STADE DE SENS 1"},null,"",null,null,null,null,null,"AILLANT 1",null,"",{"$f":"SUM(R2:R8)","v":5},{"$f":"SUM(V2:V8)","v":8},0,""]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 1"},{"$f":"$B$7","v":"VAUX 2"},22,14,{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$1","v":"USC SENS 1"},null,"",null,null,null,null,null,"APPOIGNY 2",20,3,null,null,20,4]
[null,null,{"$f":"$B$8","v":"APPOIGNY 2"},{"$f":"$B$5","v":"VERON 1"},20,16,{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$8","v":"APPOIGNY 2"},null,"",null,null,null,null,null,"APPOIGNY 2",20,3,null,null,20,4]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"APPOIGNY 2","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$5","v":"VERON 1"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"APPOIGNY 2","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"STADE DE SENS 1"},{"$f":"$B$3","v":"JOIGNY 1"},null,"","Classement",null,null,null,null,null,null,null,null,"APPOIGNY 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$1","v":"USC SENS 1"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"APPOIGNY 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"AILLANT 1"},{"$f":"$B$8","v":"APPOIGNY 2"},null,"",1,"APPOIGNY 2",6,8,null,null,null,null,null,"APPOIGNY 2","","",{"$f":"SUM(R9:R15)","v":6},{"$f":"SUM(V9:V15)","v":8},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,2,"AILLANT 1",5,8,null,null,null,null,null,"JOIGNY 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$2","v":"STADE DE SENS 1"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"PARON 1",5,4,null,null,null,null,null,"JOIGNY 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$6","v":"AILLANT 1"},{"$f":"$B$4","v":"PARON 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"STADE DE SENS 1",4,4,null,null,null,null,null,"JOIGNY 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$7","v":"VAUX 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"USC SENS 1",4,0,null,null,null,null,null,"JOIGNY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$8","v":"APPOIGNY 2"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"VERON 1",3,-4,null,null,null,null,null,"JOIGNY 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,7,"JOIGNY 1",3,-8,null,null,null,null,null,"JOIGNY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$3","v":"JOIGNY 1"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"VAUX 2",2,-12,null,null,null,null,null,"JOIGNY 1",null,"",{"$f":"SUM(R16:R22)","v":3},{"$f":"SUM(V16:V22)","v":-8},0,""]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 1"},{"$f":"$B$6","v":"AILLANT 1"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},null,null,null,null,null,null,null,null,null,"PARON 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$5","v":"VERON 1"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},null,null,null,null,null,null,null,null,null,"PARON 1",20,3,null,null,20,4]
[null,null,{"$f":"$B$8","v":"APPOIGNY 2"},{"$f":"$B$4","v":"PARON 1"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"PARON 1",null,"",null,null,0,""]
[null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"PARON 1","","",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"PARON 1","","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PARON 1","","",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PARON 1",null,"",{"$f":"SUM(R23:R29)","v":5},{"$f":"SUM(V23:V29)","v":4},0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1","","",{"$f":"SUM(R30:R36)","v":4},{"$f":"SUM(V30:V36)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1","","",{"$f":"SUM(R37:R43)","v":4},{"$f":"SUM(V37:V43)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2","","",{"$f":"SUM(R44:R50)","v":2},{"$f":"SUM(V44:V50)","v":-12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",null,"",{"$f":"SUM(R51:R57)","v":3},{"$f":"SUM(V51:V57)","v":-4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$2","v":"STADE DE SENS 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$2","v":"STADE DE SENS 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D1 VET Gr B","index":1,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,9],[5,2,5,5],[5,6,5,9],[10,2,10,5],[10,6,10,9],[28,1,28,10],[29,1,29,10],[12,6,12,9],[13,6,13,7],[15,2,15,5],[20,2,20,5],[26,1,26,10],[27,1,27,10],[24,6,24,9]]}
[1,"AVALLON 1","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"APPOIGNY 1",{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$2","v":"APPOIGNY 1"},16,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":20},{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$6","v":"MONETEAU 1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"APPOIGNY 1",20,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":3},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":20},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":4}]
[3,"VAUX 1",{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$4","v":"USC SENS 2"},26,10,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$5","v":"STADE AUXERRE 2"},null,"",null,null,null,null,null,"APPOIGNY 1",34,3,null,null,34,32]
[4,"USC SENS 2",{"$f":"$B$5","v":"STADE AUXERRE 2"},{"$f":"$B$6","v":"MONETEAU 1"},20,16,{"$f":"$B$7","v":"RAVIERES 1"},{"$f":"$B$4","v":"USC SENS 2"},null,"",null,null,null,null,null,"APPOIGNY 1",null,"",null,null,0,""]
[5,"STADE AUXERRE 2",{"$f":"$B$7","v":"RAVIERES 1"},{"$f":"$B$8","v":"ST FLORENTIN 2"},26,10,{"$f":"$B$8","v":"ST FLORENTIN 2"},{"$f":"$B$2","v":"APPOIGNY 1"},null,"",null,null,null,null,null,"APPOIGNY 1","","",null,null,0,""]
[6,"MONETEAU 1","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,"APPOIGNY 1",null,"",null,null,0,""]
[7,"RAVIERES 1",{"$f":"$B$4","v":"USC SENS 2"},{"$f":"$B$1","v":"AVALLON 1"},28,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":8},{"$f":"$B$6","v":"MONETEAU 1"},{"$f":"$B$7","v":"RAVIERES 1"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"APPOIGNY 1","","",null,null,0,""]
[8,"ST FLORENTIN 2",{"$f":"$B$6","v":"MONETEAU 1"},{"$f":"$B$3","v":"VAUX 1"},16,20,{"$f":"$B$4","v":"USC SENS 2"},{"$f":"$B$2","v":"APPOIGNY 1"},null,"",null,null,null,null,null,"APPOIGNY 1","","",{"$f":"SUM(R2:R8)","v":6},{"$f":"SUM(V2:V8)","v":36},0,""]
[null,null,{"$f":"$B$2","v":"APPOIGNY 1"},{"$f":"$B$7","v":"RAVIERES 1"},34,2,{"$f":"$B$5","v":"STADE AUXERRE 2"},{"$f":"$B$1","v":"AVALLON 1"},null,"",null,null,null,null,null,"AVALLON 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$8","v":"ST FLORENTIN 2"},{"$f":"$B$5","v":"STADE AUXERRE 2"},10,26,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$8","v":"ST FLORENTIN 2"},null,"",null,null,null,null,null,"AVALLON 1",8,1,null,null,8,-20]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"AVALLON 1","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"USC SENS 2"},{"$f":"$B$5","v":"STADE AUXERRE 2"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"AVALLON 1",null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"APPOIGNY 1"},{"$f":"$B$3","v":"VAUX 1"},null,"","Classement",null,null,null,null,null,null,null,null,"AVALLON 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$7","v":"RAVIERES 1"},{"$f":"$B$1","v":"AVALLON 1"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"AVALLON 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"MONETEAU 1"},{"$f":"$B$8","v":"ST FLORENTIN 2"},null,"",1,"APPOIGNY 1",6,36,null,null,null,null,null,"AVALLON 1","","",{"$f":"SUM(R9:R15)","v":2},{"$f":"SUM(V9:V15)","v":-24},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,2,"STADE AUXERRE 2",6,20,null,null,null,null,null,"MONETEAU 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$5","v":"STADE AUXERRE 2"},{"$f":"$B$2","v":"APPOIGNY 1"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"VAUX 1",6,20,null,null,null,null,null,"MONETEAU 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$6","v":"MONETEAU 1"},{"$f":"$B$4","v":"USC SENS 2"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"USC SENS 2",4,4,null,null,null,null,null,"MONETEAU 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$7","v":"RAVIERES 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"RAVIERES 1",4,-16,null,null,null,null,null,"MONETEAU 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$8","v":"ST FLORENTIN 2"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"MONETEAU 1",2,-8,null,null,null,null,null,"MONETEAU 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,7,"AVALLON 1",2,-24,null,null,null,null,null,"MONETEAU 1","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$3","v":"VAUX 1"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"ST FLORENTIN 2",2,-32,null,null,null,null,null,"MONETEAU 1",null,"",{"$f":"SUM(R16:R22)","v":2},{"$f":"SUM(V16:V22)","v":-8},0,""]
[null,null,{"$f":"$B$2","v":"APPOIGNY 1"},{"$f":"$B$6","v":"MONETEAU 1"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},null,null,null,null,null,null,null,null,null,"RAVIERES 1",26,3,null,null,26,16]
[null,null,{"$f":"$B$7","v":"RAVIERES 1"},{"$f":"$B$5","v":"STADE AUXERRE 2"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},null,null,null,null,null,null,null,null,null,"RAVIERES 1",2,1,null,null,2,-32]
[null,null,{"$f":"$B$8","v":"ST FLORENTIN 2"},{"$f":"$B$4","v":"USC SENS 2"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"RAVIERES 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1","","",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1",null,"",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1","","",{"$f":"SUM(R23:R29)","v":4},{"$f":"SUM(V23:V29)","v":-16},0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 1 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",null,{"$f":"IF(Q34=\"\",\"\",IF(Q34=\"F\",0,IF(Q34=18,2,IF(Q34>18,3,1))))","v":""},null,null,{"$f":"IF(Q34=\"G\",19,IF(Q34=\"\",0,Q34))","v":0},{"$f":"IF(Q34=\"\",\"\",IF(U34=36,36,IF(U34=0,-36,IF(U34=19,19,IF(U34=\"f\",-19,U34-(36-U34))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2","","",{"$f":"SUM(R30:R36)","v":2},{"$f":"SUM(V30:V36)","v":-32},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",null,"",{"$f":"SUM(R37:R43)","v":6},{"$f":"SUM(V37:V43)","v":20},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",null,"",{"$f":"SUM(R44:R50)","v":4},{"$f":"SUM(V44:V50)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",null,"",{"$f":"SUM(R51:R57)","v":6},{"$f":"SUM(V51:V57)","v":20},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$2","v":"APPOIGNY 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"VAUX 1"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$2","v":"APPOIGNY 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"VAUX 1"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D2 VET Gr A","index":2,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,9],[5,2,5,5],[5,6,5,9],[10,2,10,5],[10,6,10,9],[27,1,27,10],[28,1,28,10],[29,1,29,10],[12,6,12,9],[13,6,13,7],[15,2,15,5],[20,2,20,5],[24,6,24,9],[26,1,26,10]]}
[1,"MIGENNES 2","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"CHARBUY 2",{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$2","v":"CHARBUY 2"},12,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":24},{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$6","v":"ANCY LE FRANC 2"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2",16,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":1},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":16},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":-4}]
[3,"USC SENS 3",{"$f":"$B$3","v":"USC SENS 3"},{"$f":"$B$4","v":"PONT / YONNE 1"},4,32,{"$f":"$B$3","v":"USC SENS 3"},{"$f":"$B$5","v":"VERON 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2",24,3,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":24},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":12}]
[4,"PONT / YONNE 1",{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$6","v":"ANCY LE FRANC 2"},20,16,{"$f":"$B$7","v":"USV PETANQUE 1"},{"$f":"$B$4","v":"PONT / YONNE 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 2",null,"",null,null,0,""]
[5,"VERON 2",{"$f":"$B$7","v":"USV PETANQUE 1"},{"$f":"$B$8","v":"MALAY LE GRAND 1"},32,4,{"$f":"$B$8","v":"MALAY LE GRAND 1"},{"$f":"$B$2","v":"CHARBUY 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2",null,"",null,null,0,""]
[6,"ANCY LE FRANC 2","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[7,"USV PETANQUE 1",{"$f":"$B$4","v":"PONT / YONNE 1"},{"$f":"$B$1","v":"MIGENNES 2"},24,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":12},{"$f":"$B$6","v":"ANCY LE FRANC 2"},{"$f":"$B$7","v":"USV PETANQUE 1"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[8,"MALAY LE GRAND 1",{"$f":"$B$6","v":"ANCY LE FRANC 2"},{"$f":"$B$3","v":"USC SENS 3"},24,12,{"$f":"$B$4","v":"PONT / YONNE 1"},{"$f":"$B$2","v":"CHARBUY 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2",null,"",{"$f":"SUM(R2:R8)","v":4},{"$f":"SUM(V2:V8)","v":8},0,""]
[null,null,{"$f":"$B$2","v":"CHARBUY 2"},{"$f":"$B$7","v":"USV PETANQUE 1"},26,10,{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$1","v":"MIGENNES 2"},null,"",null,null,null,null,null,"CHARBUY 2",24,3,null,null,24,12]
[null,null,{"$f":"$B$8","v":"MALAY LE GRAND 1"},{"$f":"$B$5","v":"VERON 2"},12,24,{"$f":"$B$3","v":"USC SENS 3"},{"$f":"$B$8","v":"MALAY LE GRAND 1"},null,"",null,null,null,null,null,"CHARBUY 2",26,3,null,null,26,16]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"CHARBUY 2",null,"",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"PONT / YONNE 1"},{"$f":"$B$5","v":"VERON 2"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 2","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"CHARBUY 2"},{"$f":"$B$3","v":"USC SENS 3"},null,"","Classement",null,null,null,null,null,null,null,null,"CHARBUY 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$7","v":"USV PETANQUE 1"},{"$f":"$B$1","v":"MIGENNES 2"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"CHARBUY 2","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"ANCY LE FRANC 2"},{"$f":"$B$8","v":"MALAY LE GRAND 1"},null,"",1,"PONT / YONNE 1",6,40,null,null,null,null,null,"CHARBUY 2","","",{"$f":"SUM(R9:R15)","v":6},{"$f":"SUM(V9:V15)","v":28},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,2,"CHARBUY 2",6,28,null,null,null,null,null,"MALAY LE GRAND 1",4,1,null,null,4,-28]
[null,null,{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$2","v":"CHARBUY 2"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"VERON 2",6,16,null,null,null,null,null,"MALAY LE GRAND 1",12,1,null,null,12,-12]
[null,null,{"$f":"$B$6","v":"ANCY LE FRANC 2"},{"$f":"$B$4","v":"PONT / YONNE 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"USV PETANQUE 1",4,12,null,null,null,null,null,"MALAY LE GRAND 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"USC SENS 3"},{"$f":"$B$7","v":"USV PETANQUE 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"ANCY LE FRANC 2",4,8,null,null,null,null,null,"MALAY LE GRAND 1","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$8","v":"MALAY LE GRAND 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"MIGENNES 2",2,-24,null,null,null,null,null,"MALAY LE GRAND 1",null,"",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,7,"MALAY LE GRAND 1",2,-40,null,null,null,null,null,"MALAY LE GRAND 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$3","v":"USC SENS 3"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"USC SENS 3",2,-40,null,null,null,null,null,"MALAY LE GRAND 1","","",{"$f":"SUM(R16:R22)","v":2},{"$f":"SUM(V16:V22)","v":-40},0,""]
[null,null,{"$f":"$B$2","v":"CHARBUY 2"},{"$f":"$B$6","v":"ANCY LE FRANC 2"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 2",12,1,null,null,12,-12]
[null,null,{"$f":"$B$7","v":"USV PETANQUE 1"},{"$f":"$B$5","v":"VERON 2"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 2",12,1,null,null,12,-12]
[null,null,{"$f":"$B$8","v":"MALAY LE GRAND 1"},{"$f":"$B$4","v":"PONT / YONNE 1"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 2","","",null,null,0,""]
[null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 2",null,"",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 2",null,"",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 2",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 2","","",{"$f":"SUM(R23:R29)","v":2},{"$f":"SUM(V23:V29)","v":-24},0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 2 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",null,"",{"$f":"SUM(R30:R36)","v":6},{"$f":"SUM(V30:V36)","v":40},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",4,1,null,null,4,-28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",null,"",{"$f":"SUM(R37:R43)","v":2},{"$f":"SUM(V37:V43)","v":-40},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV PETANQUE 1","","",{"$f":"SUM(R44:R50)","v":4},{"$f":"SUM(V44:V50)","v":12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",null,"",{"$f":"SUM(R51:R57)","v":6},{"$f":"SUM(V51:V57)","v":16},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$2","v":"CHARBUY 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"USC SENS 3"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$2","v":"CHARBUY 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"USC SENS 3"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D2 VET Gr B","index":3,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,9],[5,2,5,5],[5,6,5,9],[10,2,10,5],[10,6,10,9],[27,1,27,10],[28,1,28,10],[29,1,29,10],[12,6,12,9],[13,6,13,7],[15,2,15,5],[20,2,20,5],[24,6,24,9],[26,1,26,10]]}
[1,"ANCY LE FRANC 1","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"SENAN 1",{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$2","v":"SENAN 1"},8,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":28},{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$6","v":"HERY 1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"ANCY LE FRANC 1",8,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":1},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":8},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":-20}]
[3,"CHARBUY 1",{"$f":"$B$3","v":"CHARBUY 1"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},26,10,{"$f":"$B$3","v":"CHARBUY 1"},{"$f":"$B$5","v":"AVALLON 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 1",8,1,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":8},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":-20}]
[4,"CHATEL CENSOIR 1",{"$f":"$B$5","v":"AVALLON 2"},{"$f":"$B$6","v":"HERY 1"},30,6,{"$f":"$B$7","v":"MONETEAU 2"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1","","",null,null,0,""]
[5,"AVALLON 2",{"$f":"$B$7","v":"MONETEAU 2"},{"$f":"$B$8","v":"VAUX 3"},14,22,{"$f":"$B$8","v":"VAUX 3"},{"$f":"$B$2","v":"SENAN 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1",null,"",null,null,0,""]
[6,"HERY 1","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 1",null,"",null,null,0,""]
[7,"MONETEAU 2",{"$f":"$B$4","v":"CHATEL CENSOIR 1"},{"$f":"$B$1","v":"ANCY LE FRANC 1"},28,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":8},{"$f":"$B$6","v":"HERY 1"},{"$f":"$B$7","v":"MONETEAU 2"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"ANCY LE FRANC 1",null,"",null,null,0,""]
[8,"VAUX 3",{"$f":"$B$6","v":"HERY 1"},{"$f":"$B$3","v":"CHARBUY 1"},24,12,{"$f":"$B$4","v":"CHATEL CENSOIR 1"},{"$f":"$B$2","v":"SENAN 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1","","",{"$f":"SUM(R2:R8)","v":2},{"$f":"SUM(V2:V8)","v":-40},0,""]
[null,null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$7","v":"MONETEAU 2"},20,16,{"$f":"$B$5","v":"AVALLON 2"},{"$f":"$B$1","v":"ANCY LE FRANC 1"},null,"",null,null,null,null,null,"AVALLON 2",30,3,null,null,30,24]
[null,null,{"$f":"$B$8","v":"VAUX 3"},{"$f":"$B$5","v":"AVALLON 2"},16,20,{"$f":"$B$3","v":"CHARBUY 1"},{"$f":"$B$8","v":"VAUX 3"},null,"",null,null,null,null,null,"AVALLON 2",20,3,null,null,20,4]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"AVALLON 2","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"CHATEL CENSOIR 1"},{"$f":"$B$5","v":"AVALLON 2"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"AVALLON 2",null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$3","v":"CHARBUY 1"},null,"","Classement",null,null,null,null,null,null,null,null,"AVALLON 2","","",null,null,0,""]
[null,null,{"$f":"$B$7","v":"MONETEAU 2"},{"$f":"$B$1","v":"ANCY LE FRANC 1"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"AVALLON 2","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"HERY 1"},{"$f":"$B$8","v":"VAUX 3"},null,"",1,"AVALLON 2",6,28,null,null,null,null,null,"AVALLON 2",null,"",{"$f":"SUM(R9:R15)","v":6},{"$f":"SUM(V9:V15)","v":28},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,2,"SENAN 1",6,24,null,null,null,null,null,"CHARBUY 1",26,3,null,null,26,16]
[null,null,{"$f":"$B$5","v":"AVALLON 2"},{"$f":"$B$2","v":"SENAN 1"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"CHARBUY 1",4,4,null,null,null,null,null,"CHARBUY 1",12,1,null,null,12,-12]
[null,null,{"$f":"$B$6","v":"HERY 1"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"CHATEL CENSOIR 1",4,4,null,null,null,null,null,"CHARBUY 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"CHARBUY 1"},{"$f":"$B$7","v":"MONETEAU 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"VAUX 3",4,4,null,null,null,null,null,"CHARBUY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$8","v":"VAUX 3"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"HERY 1",4,-12,null,null,null,null,null,"CHARBUY 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,7,"MONETEAU 2",2,-12,null,null,null,null,null,"CHARBUY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$3","v":"CHARBUY 1"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"ANCY LE FRANC 1",2,-40,null,null,null,null,null,"CHARBUY 1",null,"",{"$f":"SUM(R16:R22)","v":4},{"$f":"SUM(V16:V22)","v":4},0,""]
[null,null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$6","v":"HERY 1"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",10,1,null,null,10,-16]
[null,null,{"$f":"$B$7","v":"MONETEAU 2"},{"$f":"$B$5","v":"AVALLON 2"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",28,3,null,null,28,20]
[null,null,{"$f":"$B$8","v":"VAUX 3"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",null,null,0,""]
[null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1","","",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1","","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1","","",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",{"$f":"SUM(R23:R29)","v":4},{"$f":"SUM(V23:V29)","v":4},0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 2 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",6,1,null,null,6,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",null,"",{"$f":"SUM(R30:R36)","v":4},{"$f":"SUM(V30:V36)","v":-12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2","","",{"$f":"SUM(R37:R43)","v":2},{"$f":"SUM(V37:V43)","v":-12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1","","",{"$f":"SUM(R44:R50)","v":6},{"$f":"SUM(V44:V50)","v":24},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",{"$f":"SUM(R51:R57)","v":4},{"$f":"SUM(V51:V57)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$2","v":"SENAN 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"CHARBUY 1"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"ANCY LE FRANC 1"},{"$f":"$B$2","v":"SENAN 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"CHARBUY 1"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D3 VET Gr A","index":4,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[27,1,27,10],[28,1,28,10],[29,1,29,10],[12,6,12,9],[13,6,13,7],[15,2,15,5],[20,2,20,5],[24,6,24,9],[26,1,26,10],[0,2,0,5],[0,6,0,9],[5,2,5,5],[5,6,5,9],[10,2,10,5],[10,6,10,9]]}
[1,"APPOIGNY 3","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"STADE DE SENS 2",{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$2","v":"STADE DE SENS 2"},22,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":14},{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$6","v":"CEZY 1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"AILLANT 2",24,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":3},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":24},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":12}]
[3,"MIGENNES 3",{"$f":"$B$3","v":"MIGENNES 3"},{"$f":"$B$4","v":"ST FLORENTIN 3"},26,10,{"$f":"$B$3","v":"MIGENNES 3"},{"$f":"$B$5","v":"VILLENEUVE PET 1"},null,"",null,null,null,null,null,"AILLANT 2",16,1,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":16},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":-4}]
[4,"ST FLORENTIN 3",{"$f":"$B$5","v":"VILLENEUVE PET 1"},{"$f":"$B$6","v":"CEZY 1"},20,16,{"$f":"$B$7","v":"AILLANT 2"},{"$f":"$B$4","v":"ST FLORENTIN 3"},null,"",null,null,null,null,null,"AILLANT 2",null,"",null,null,0,""]
[5,"VILLENEUVE PET 1",{"$f":"$B$7","v":"AILLANT 2"},{"$f":"$B$8","v":"PONT/YONNE 2"},24,12,{"$f":"$B$8","v":"PONT/YONNE 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},null,"",null,null,null,null,null,"AILLANT 2","","",null,null,0,""]
[6,"CEZY 1","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,"AILLANT 2",null,"",null,null,0,""]
[7,"AILLANT 2",{"$f":"$B$4","v":"ST FLORENTIN 3"},{"$f":"$B$1","v":"APPOIGNY 3"},20,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":16},{"$f":"$B$6","v":"CEZY 1"},{"$f":"$B$7","v":"AILLANT 2"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"AILLANT 2",null,"",null,null,0,""]
[8,"PONT/YONNE 2",{"$f":"$B$6","v":"CEZY 1"},{"$f":"$B$3","v":"MIGENNES 3"},22,14,{"$f":"$B$4","v":"ST FLORENTIN 3"},{"$f":"$B$2","v":"STADE DE SENS 2"},null,"",null,null,null,null,null,"AILLANT 2","","",{"$f":"SUM(R2:R8)","v":4},{"$f":"SUM(V2:V8)","v":8},0,""]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$7","v":"AILLANT 2"},20,16,{"$f":"$B$5","v":"VILLENEUVE PET 1"},{"$f":"$B$1","v":"APPOIGNY 3"},null,"",null,null,null,null,null,"APPOIGNY 3",22,3,null,null,22,8]
[null,null,{"$f":"$B$8","v":"PONT/YONNE 2"},{"$f":"$B$5","v":"VILLENEUVE PET 1"},6,30,{"$f":"$B$3","v":"MIGENNES 3"},{"$f":"$B$8","v":"PONT/YONNE 2"},null,"",null,null,null,null,null,"APPOIGNY 3",16,1,null,null,16,-4]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"APPOIGNY 3","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"ST FLORENTIN 3"},{"$f":"$B$5","v":"VILLENEUVE PET 1"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"APPOIGNY 3",null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$3","v":"MIGENNES 3"},null,"","Classement",null,null,null,null,null,null,null,null,"APPOIGNY 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$7","v":"AILLANT 2"},{"$f":"$B$1","v":"APPOIGNY 3"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"APPOIGNY 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"CEZY 1"},{"$f":"$B$8","v":"PONT/YONNE 2"},null,"",1,"VILLENEUVE PET 1",6,28,null,null,null,null,null,"APPOIGNY 3","","",{"$f":"SUM(R9:R15)","v":4},{"$f":"SUM(V9:V15)","v":4},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,2,"AILLANT 2",4,8,null,null,null,null,null,"CEZY 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$5","v":"VILLENEUVE PET 1"},{"$f":"$B$2","v":"STADE DE SENS 2"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"MIGENNES 3",4,8,null,null,null,null,null,"CEZY 1",22,3,null,null,22,8]
[null,null,{"$f":"$B$6","v":"CEZY 1"},{"$f":"$B$4","v":"ST FLORENTIN 3"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"APPOIGNY 3",4,4,null,null,null,null,null,"CEZY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"MIGENNES 3"},{"$f":"$B$7","v":"AILLANT 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"CEZY 1",4,4,null,null,null,null,null,"CEZY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$8","v":"PONT/YONNE 2"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"STADE DE SENS 2",4,-4,null,null,null,null,null,"CEZY 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,7,"ST FLORENTIN 3",4,-12,null,null,null,null,null,"CEZY 1","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$3","v":"MIGENNES 3"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"PONT/YONNE 2",2,-36,null,null,null,null,null,"CEZY 1",null,"",{"$f":"SUM(R16:R22)","v":4},{"$f":"SUM(V16:V22)","v":4},0,""]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$6","v":"CEZY 1"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3",26,3,null,null,26,16]
[null,null,{"$f":"$B$7","v":"AILLANT 2"},{"$f":"$B$5","v":"VILLENEUVE PET 1"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3",14,1,null,null,14,-8]
[null,null,{"$f":"$B$8","v":"PONT/YONNE 2"},{"$f":"$B$4","v":"ST FLORENTIN 3"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3","","",null,null,0,""]
[null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3",null,"",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3","","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",null,"",{"$f":"SUM(R23:R29)","v":4},{"$f":"SUM(V23:V29)","v":8},0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 3 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2",6,1,null,null,6,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT/YONNE 2","","",{"$f":"SUM(R30:R36)","v":2},{"$f":"SUM(V30:V36)","v":-36},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",null,"",{"$f":"SUM(R37:R43)","v":4},{"$f":"SUM(V37:V43)","v":-12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2","","",{"$f":"SUM(R44:R50)","v":4},{"$f":"SUM(V44:V50)","v":-4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1",30,3,null,null,30,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PET 1",null,"",{"$f":"SUM(R51:R57)","v":6},{"$f":"SUM(V51:V57)","v":28},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$2","v":"STADE DE SENS 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 3"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"APPOIGNY 3"},{"$f":"$B$2","v":"STADE DE SENS 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 3"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D3 VET Gr B","index":5,"n_rows":333,"n_cols":22,"rows_kept":333,"cut":false,"hidden":false,"merged":[[0,2,0,5],[30,2,30,5],[6,2,6,5],[6,6,6,9],[12,2,12,5],[0,6,0,9],[38,1,38,10],[39,1,39,10],[40,1,40,7],[12,6,12,9],[18,2,18,5],[24,2,24,5],[37,1,37,10],[23,6,23,9]]}
[1,"CHARBUY 3","  Match 1 : au 1er nommé le Mardi 24 Mars à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 02 Juin à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"BLENEAU 1",{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$8","v":"AVALLON 3"},36,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":0},{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$7","v":"CHATEL CENSOIR 2"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":0},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":""}]
[3,"ST PÈRE / VEZELAY 1",{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},16,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":20},{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$4","v":"MIGENNES 4"},null,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",36-I3)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=18,2,IF(Q3>18,3,1))))","v":""},null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":0},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":""}]
[4,"MIGENNES 4",{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$7","v":"CHATEL CENSOIR 2"},30,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":6},{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",36-I4)))","v":""}]
[5,"LIGNY LE CHATEL 1",{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},{"$f":"$B$6","v":"TONNERRE 1"},10,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":26},{"$f":"$B$6","v":"TONNERRE 1"},{"$f":"$B$9","v":"RAVIERES 2"},null,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q5=\"\",\"\",IF(Q5=\"F\",0,IF(Q5=18,2,IF(Q5>18,3,1))))","v":""},null,null,{"$f":"IF(Q5=\"G\",19,IF(Q5=\"\",0,Q5))","v":0},{"$f":"IF(Q5=\"\",\"\",IF(U5=36,36,IF(U5=0,-36,IF(U5=19,19,IF(U5=\"f\",-19,U5-(36-U5))))))","v":""}]
[6,"TONNERRE 1",{"$f":"$B$9","v":"RAVIERES 2"},{"$f":"$B$10","v":"EXEMPT"},"g","f",{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$10","v":"EXEMPT"},null,{"$f":"IF(I6=\"\",\"\",IF(I6=\"F\",\"G\",IF(I6=\"G\",\"F\",36-I6)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q6=\"\",\"\",IF(Q6=\"F\",0,IF(Q6=18,2,IF(Q6>18,3,1))))","v":""},null,null,{"$f":"IF(Q6=\"G\",19,IF(Q6=\"\",0,Q6))","v":0},{"$f":"IF(Q6=\"\",\"\",IF(U6=36,36,IF(U6=0,-36,IF(U6=19,19,IF(U6=\"f\",-19,U6-(36-U6))))))","v":""}]
[7,"CHATEL CENSOIR 2","  Match 2 : au 1er nommé le Mardi 07 Avril à 14h30",null,null,null,"  Match 8 : au 1er nommé le Mardi 9 Juin à 14h30",null,null,null,null,null,null,null,null,0,"",{"$f":"IF(Q7=\"\",\"\",IF(Q7=\"F\",0,IF(Q7=18,2,IF(Q7>18,3,1))))","v":""},null,null,{"$f":"IF(Q7=\"G\",19,IF(Q7=\"\",0,Q7))","v":0},{"$f":"IF(Q7=\"\",\"\",IF(U7=36,36,IF(U7=0,-36,IF(U7=19,19,IF(U7=\"f\",-19,U7-(36-U7))))))","v":""}]
[8,"AVALLON 3",{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$1","v":"CHARBUY 3"},24,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":12},{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":""},null,null,null,null,null,0,"",{"$f":"IF(Q8=\"\",\"\",IF(Q8=\"F\",0,IF(Q8=18,2,IF(Q8>18,3,1))))","v":""},null,null,{"$f":"IF(Q8=\"G\",19,IF(Q8=\"\",0,Q8))","v":0},{"$f":"IF(Q8=\"\",\"\",IF(U8=36,36,IF(U8=0,-36,IF(U8=19,19,IF(U8=\"f\",-19,U8-(36-U8))))))","v":""}]
[9,"RAVIERES 2",{"$f":"$B$7","v":"CHATEL CENSOIR 2"},{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},16,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",36-E9)))","v":20},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$6","v":"TONNERRE 1"},null,{"$f":"IF(I9=\"\",\"\",IF(I9=\"F\",\"G\",IF(I9=\"G\",\"F\",36-I9)))","v":""}]
[10,"EXEMPT",{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$4","v":"MIGENNES 4"},6,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":30},{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},null,{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":""},null,null,null,null,null,0,"",{"$f":"IF(Q10=\"\",\"\",IF(Q10=\"F\",0,IF(Q10=18,2,IF(Q10>18,3,1))))","v":""},{"$f":"SUM(R2:R10)","v":0},{"$f":"SUM(V2:V10)","v":0},{"$f":"IF(Q10=\"G\",19,IF(Q10=\"\",0,Q10))","v":0},{"$f":"IF(Q10=\"\",\"\",IF(U10=36,36,IF(U10=0,-36,IF(U10=19,19,IF(U10=\"f\",-19,U10-(36-U10))))))","v":""}]
[null,null,{"$f":"$B$9","v":"RAVIERES 2"},{"$f":"$B$2","v":"BLENEAU 1"},20,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":16},{"$f":"$B$7","v":"CHATEL CENSOIR 2"},{"$f":"$B$9","v":"RAVIERES 2"},null,{"$f":"IF(I11=\"\",\"\",IF(I11=\"F\",\"G\",IF(I11=\"G\",\"F\",36-I11)))","v":""},null,null,null,null,null,0,"",{"$f":"IF(Q11=\"\",\"\",IF(Q11=\"F\",0,IF(Q11=18,2,IF(Q11>18,3,1))))","v":""},null,null,{"$f":"IF(Q11=\"G\",19,IF(Q11=\"\",0,Q11))","v":0},{"$f":"IF(Q11=\"\",\"\",IF(U11=36,36,IF(U11=0,-36,IF(U11=19,19,IF(U11=\"f\",-19,U11-(36-U11))))))","v":""}]
[null,null,{"$f":"$B$10","v":"EXEMPT"},{"$f":"$B$6","v":"TONNERRE 1"},"f",{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":"G"},{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$10","v":"EXEMPT"},null,{"$f":"IF(I12=\"\",\"\",IF(I12=\"F\",\"G\",IF(I12=\"G\",\"F\",36-I12)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q12=\"\",\"\",IF(Q12=\"F\",0,IF(Q12=18,2,IF(Q12>18,3,1))))","v":""},null,null,{"$f":"IF(Q12=\"G\",19,IF(Q12=\"\",0,Q12))","v":0},{"$f":"IF(Q12=\"\",\"\",IF(U12=36,36,IF(U12=0,-36,IF(U12=19,19,IF(U12=\"f\",-19,U12-(36-U12))))))","v":""}]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 28 Avril à 14h30",null,null,null,"  Match 9 : au 1er nommé le Mardi 16 Juin à 14h30",null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q13=\"\",\"\",IF(Q13=\"F\",0,IF(Q13=18,2,IF(Q13>18,3,1))))","v":""},null,null,{"$f":"IF(Q13=\"G\",19,IF(Q13=\"\",0,Q13))","v":0},{"$f":"IF(Q13=\"\",\"\",IF(U13=36,36,IF(U13=0,-36,IF(U13=19,19,IF(U13=\"f\",-19,U13-(36-U13))))))","v":""}]
["Seules les Cases Blanches",null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$9","v":"RAVIERES 2"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(I14=\"\",\"\",IF(I14=\"F\",\"G\",IF(I14=\"G\",\"F\",36-I14)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q14=\"\",\"\",IF(Q14=\"F\",0,IF(Q14=18,2,IF(Q14>18,3,1))))","v":""},null,null,{"$f":"IF(Q14=\"G\",19,IF(Q14=\"\",0,Q14))","v":0},{"$f":"IF(Q14=\"\",\"\",IF(U14=36,36,IF(U14=0,-36,IF(U14=19,19,IF(U14=\"f\",-19,U14-(36-U14))))))","v":""}]
[null,null,{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$6","v":"TONNERRE 1"},null,null,{"$f":"$B$7","v":"CHATEL CENSOIR 2"},{"$f":"$B$6","v":"TONNERRE 1"},null,{"$f":"IF(I15=\"\",\"\",IF(I15=\"F\",\"G\",IF(I15=\"G\",\"F\",36-I15)))","v":""}]
["sont à remplir",null,{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(I16=\"\",\"\",IF(I16=\"F\",\"G\",IF(I16=\"G\",\"F\",36-I16)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q16=\"\",\"\",IF(Q16=\"F\",0,IF(Q16=18,2,IF(Q16>18,3,1))))","v":""},null,null,{"$f":"IF(Q16=\"G\",19,IF(Q16=\"\",0,Q16))","v":0},{"$f":"IF(Q16=\"\",\"\",IF(U16=36,36,IF(U16=0,-36,IF(U16=19,19,IF(U16=\"f\",-19,U16-(36-U16))))))","v":""}]
[null,null,{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$7","v":"CHATEL CENSOIR 2"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},{"$f":"$B$9","v":"RAVIERES 2"},{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},null,{"$f":"IF(I17=\"\",\"\",IF(I17=\"F\",\"G\",IF(I17=\"G\",\"F\",36-I17)))","v":""},null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},{"$f":"$B$10","v":"EXEMPT"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$10","v":"EXEMPT"},null,{"$f":"IF(I18=\"\",\"\",IF(I18=\"F\",\"G\",IF(I18=\"G\",\"F\",36-I18)))","v":""},null,null,null,null,null,0,"","",{"$f":"SUM(R11:R18)","v":0},{"$f":"SUM(V11:V18)","v":0},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 05 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$8","v":"AVALLON 3"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E21=\"\",\"\",IF(E21=\"F\",\"G\",IF(E21=\"G\",\"F\",36-E21)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"TONNERRE 1"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$9","v":"RAVIERES 2"},{"$f":"$B$4","v":"MIGENNES 4"}]
[null,null,{"$f":"$B$7","v":"CHATEL CENSOIR 2"},{"$f":"$B$10","v":"EXEMPT"},null,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":""},"CLASSEMENT : le mardi 23 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q24=\"\",\"\",IF(Q24=\"F\",0,IF(Q24=18,2,IF(Q24>18,3,1))))","v":""},null,null,{"$f":"IF(Q24=\"G\",19,IF(Q24=\"\",0,Q24))","v":0},{"$f":"IF(Q24=\"\",\"\",IF(U24=36,36,IF(U24=0,-36,IF(U24=19,19,IF(U24=\"f\",-19,U24-(36-U24))))))","v":""}]
[null,null,"  Match 5 : au 1er nommé le Mardi 19 Mai à 14h30",null,null,null,"Classement",null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q25=\"\",\"\",IF(Q25=\"F\",0,IF(Q25=18,2,IF(Q25>18,3,1))))","v":""},null,null,{"$f":"IF(Q25=\"G\",19,IF(Q25=\"\",0,Q25))","v":0},{"$f":"IF(Q25=\"\",\"\",IF(U25=36,36,IF(U25=0,-36,IF(U25=19,19,IF(U25=\"f\",-19,U25-(36-U25))))))","v":""}]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,0,"",{"$f":"IF(Q26=\"\",\"\",IF(Q26=\"F\",0,IF(Q26=18,2,IF(Q26>18,3,1))))","v":""},{"$f":"SUM(R19:R26)","v":0},{"$f":"SUM(V19:V26)","v":0},{"$f":"IF(Q26=\"G\",19,IF(Q26=\"\",0,Q26))","v":0},{"$f":"IF(Q26=\"\",\"\",IF(U26=36,36,IF(U26=0,-36,IF(U26=19,19,IF(U26=\"f\",-19,U26-(36-U26))))))","v":""}]
[null,null,{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$7","v":"CHATEL CENSOIR 2"},null,{"$f":"IF(E27=\"\",\"\",IF(E27=\"F\",\"G\",IF(E27=\"G\",\"F\",36-E27)))","v":""},1,"MIGENNES 4",6,48,null,null,null,null,null,0,"",{"$f":"IF(Q27=\"\",\"\",IF(Q27=\"F\",0,IF(Q27=18,2,IF(Q27>18,3,1))))","v":""},null,null,{"$f":"IF(Q27=\"G\",19,IF(Q27=\"\",0,Q27))","v":0},{"$f":"IF(Q27=\"\",\"\",IF(U27=36,36,IF(U27=0,-36,IF(U27=19,19,IF(U27=\"f\",-19,U27-(36-U27))))))","v":""}]
[null,null,{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$6","v":"TONNERRE 1"},null,null,2,"TONNERRE 1",6,35]
[null,null,{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$9","v":"RAVIERES 2"},null,{"$f":"IF(E29=\"\",\"\",IF(E29=\"F\",\"G\",IF(E29=\"G\",\"F\",36-E29)))","v":""},3,"RAVIERES 2",6,23,null,null,null,null,null,0,"",{"$f":"IF(Q29=\"\",\"\",IF(Q29=\"F\",0,IF(Q29=18,2,IF(Q29>18,3,1))))","v":""},null,null,{"$f":"IF(Q29=\"G\",19,IF(Q29=\"\",0,Q29))","v":0},{"$f":"IF(Q29=\"\",\"\",IF(U29=36,36,IF(U29=0,-36,IF(U29=19,19,IF(U29=\"f\",-19,U29-(36-U29))))))","v":""}]
[null,null,{"$f":"$B$10","v":"EXEMPT"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E30=\"\",\"\",IF(E30=\"F\",\"G\",IF(E30=\"G\",\"F\",36-E30)))","v":""},4,"ST PÈRE / VEZELAY 1",6,16,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,"  Match 6 : au 1er nommé le Mardi 26 Mai à 14h30",null,null,null,5,"CHARBUY 3",6,24,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$5","v":"LIGNY LE CHATEL 1"},{"$f":"$B$4","v":"MIGENNES 4"},null,{"$f":"IF(E32=\"\",\"\",IF(E32=\"F\",\"G\",IF(E32=\"G\",\"F\",36-E32)))","v":""},6,"LIGNY LE CHATEL 1",4,0,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$8","v":"AVALLON 3"},{"$f":"$B$6","v":"TONNERRE 1"},null,{"$f":"IF(E33=\"\",\"\",IF(E33=\"F\",\"G\",IF(E33=\"G\",\"F\",36-E33)))","v":""},7,"BLENEAU 1",2,-8,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$7","v":"CHATEL CENSOIR 2"},{"$f":"$B$2","v":"BLENEAU 1"},null,null,8,"CHATEL CENSOIR 2",2,-28,null,null,null,null,null,0,null,"",{"$f":"SUM(R27:R34)","v":0},{"$f":"SUM(V27:V34)","v":0},0,""]
[null,null,{"$f":"$B$9","v":"RAVIERES 2"},{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E35=\"\",\"\",IF(E35=\"F\",\"G\",IF(E35=\"G\",\"F\",36-E35)))","v":""},9,"AVALLON 3",2,-60,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$10","v":"EXEMPT"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(E36=\"\",\"\",IF(E36=\"F\",\"G\",IF(E36=\"G\",\"F\",36-E36)))","v":""},10,"EXEMPT",0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,"Championnat Départemental des Clubs 2026 Vétérans Division 3 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R35:R41)","v":0},{"$f":"SUM(V35:V41)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R42:R48)","v":0},{"$f":"SUM(V42:V48)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R49:R55)","v":0},{"$f":"SUM(V49:V55)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R56:R62)","v":0},{"$f":"SUM(V56:V62)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U63=0,\"\",IF(U63=19,\"\",U63-(36-U63)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E311=\"\",\"\",IF(E311=\"F\",\"G\",IF(E311=\"G\",\"F\",36-E311)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},"Equipe 4",null,{"$f":"IF(E312=\"\",\"\",IF(E312=\"F\",\"G\",IF(E312=\"G\",\"F\",36-E312)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E324=\"\",\"\",IF(E324=\"F\",\"G\",IF(E324=\"G\",\"F\",36-E324)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST PÈRE / VEZELAY 1"},"Equipe 4",null,{"$f":"IF(E325=\"\",\"\",IF(E325=\"F\",\"G\",IF(E325=\"G\",\"F\",36-E325)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"CLASSEMENT","index":6,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,5],[4,0,11,0],[24,0,32,0],[14,0,21,0]]}
[]
["VETERANS - SAISON 2026"]
[]
[null,null,null,null,null,"SCORE"]
["D1",1,null,"VS"]
[null,2,null,"VS"]
[null,3,null,"VS"]
[null,4,null,"VS"]
[null,5,null,"VS"]
[null,6,null,"VS"]
[null,7,null,"VS"]
[null,8,null,"VS"]
[]
[null,null,null,null,null,"SCORE"]
["D2",1,null,"VS"]
[null,2,null,"VS"]
[null,3,null,"VS"]
[null,4,null,"VS"]
[null,5,null,"VS"]
[null,6,null,"VS"]
[null,7,null,"VS"]
[null,8,null,"VS"]
[]
[null,null,null,null,null,"SCORE"]
["D3",1,null,"VS"]
[null,2,null,"VS"]
[null,3,null,"VS"]
[null,4,null,"VS"]
[null,5,null,"VS"]
[null,6,null,"VS"]
[null,7,null,"VS"]
[null,8,null,"VS"]
[null,9,"EXEMPT","VS"]