{"text_format":"1","workbook":"xlsx","n_sheets":6,"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"],"not_rendered":{"charts":0,"images":19,"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 2","  Match 1 : au 1er nommé le Mardi 25 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"PARON 1",{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$2","v":"PARON 1"},16,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":20},{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$6","v":"JOIGNY 1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"AILLANT 1",22,{"$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":22},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":8}]
[3,"MIGENNES 1",{"$f":"$B$3","v":"MIGENNES 1"},{"$f":"$B$4","v":"SENAN 1"},30,6,{"$f":"$B$3","v":"MIGENNES 1"},{"$f":"$B$5","v":"VERON 1"},null,"",null,null,null,null,null,"AILLANT 1",null,"",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,"SENAN 1",{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$6","v":"JOIGNY 1"},18,18,{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$4","v":"SENAN 1"},null,"",null,null,null,null,null,"AILLANT 1","","",null,null,0,""]
[5,"VERON 1",{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$8","v":"AILLANT 1"},14,22,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$2","v":"PARON 1"},null,"",null,null,null,null,null,"AILLANT 1","","",null,null,0,""]
[6,"JOIGNY 1","  Match 2 : au 1er nommé le Mardi 08 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,null,null,null,null,null,"AILLANT 1",null,"",null,null,0,""]
[7,"VAUX 2",{"$f":"$B$4","v":"SENAN 1"},{"$f":"$B$1","v":"USC SENS 2"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},{"$f":"$B$6","v":"JOIGNY 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,null,0,""]
[8,"AILLANT 1",{"$f":"$B$6","v":"JOIGNY 1"},{"$f":"$B$3","v":"MIGENNES 1"},null,"",{"$f":"$B$4","v":"SENAN 1"},{"$f":"$B$2","v":"PARON 1"},null,"",null,null,null,null,null,"AILLANT 1","","",{"$f":"SUM(R2:R8)","v":3},{"$f":"SUM(V2:V8)","v":8},0,""]
[null,null,{"$f":"$B$2","v":"PARON 1"},{"$f":"$B$7","v":"VAUX 2"},null,"",{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$1","v":"USC SENS 2"},null,"",null,null,null,null,null,"JOIGNY 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$5","v":"VERON 1"},null,"",{"$f":"$B$3","v":"MIGENNES 1"},{"$f":"$B$8","v":"AILLANT 1"},null,"",null,null,null,null,null,"JOIGNY 1",null,"",null,null,0,""]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"JOIGNY 1",null,"",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"SENAN 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,"JOIGNY 1",null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"PARON 1"},{"$f":"$B$3","v":"MIGENNES 1"},null,"","Classement",null,null,null,null,null,null,null,null,"JOIGNY 1","","",null,null,0,""]
[null,null,{"$f":"$B$7","v":"VAUX 2"},{"$f":"$B$1","v":"USC SENS 2"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"JOIGNY 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"JOIGNY 1"},{"$f":"$B$8","v":"AILLANT 1"},null,"",1,"MIGENNES 1",3,24,null,null,null,null,null,"JOIGNY 1",null,"",{"$f":"SUM(R9:R15)","v":2},{"$f":"SUM(V9:V15)","v":0},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,2,"AILLANT 1",3,8,null,null,null,null,null,"MIGENNES 1",30,3,null,null,30,24]
[null,null,{"$f":"$B$5","v":"VERON 1"},{"$f":"$B$2","v":"PARON 1"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"PARON 1",3,4,null,null,null,null,null,"MIGENNES 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"JOIGNY 1"},{"$f":"$B$4","v":"SENAN 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"JOIGNY 1",2,0,null,null,null,null,null,"MIGENNES 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"MIGENNES 1"},{"$f":"$B$7","v":"VAUX 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"VERON 1",2,0,null,null,null,null,null,"MIGENNES 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$8","v":"AILLANT 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"USC SENS 2",1,-4,null,null,null,null,null,"MIGENNES 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,7,"VAUX 2",1,-8,null,null,null,null,null,"MIGENNES 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$3","v":"MIGENNES 1"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"SENAN 1",1,-24,null,null,null,null,null,"MIGENNES 1",null,"",{"$f":"SUM(R16:R22)","v":3},{"$f":"SUM(V16:V22)","v":24},0,""]
[null,null,{"$f":"$B$2","v":"PARON 1"},{"$f":"$B$6","v":"JOIGNY 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",20,3,null,null,20,4]
[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",null,"",null,null,0,""]
[null,null,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$4","v":"SENAN 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,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","","",{"$f":"SUM(R23:R29)","v":3},{"$f":"SUM(V23:V29)","v":4},0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",6,1,null,null,6,-24]
[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,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,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,"",{"$f":"SUM(R30:R36)","v":1},{"$f":"SUM(V30:V36)","v":-24},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",16,1,null,null,16,-4]
[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,null,0,""]
[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,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2","","",{"$f":"SUM(R37:R43)","v":1},{"$f":"SUM(V37:V43)","v":-4},0,""]
[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,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,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":1},{"$f":"SUM(V44:V50)","v":-8},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","","",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,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":2},{"$f":"SUM(V51:V57)","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(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 2"},{"$f":"$B$2","v":"PARON 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 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 2"},{"$f":"$B$2","v":"PARON 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 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 25 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"RAVIERES 1",{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$2","v":"RAVIERES 1"},32,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":4},{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$6","v":"STADE AUXERRE 2"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"ANCY LE FRANC 1",26,{"$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":26},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":16}]
[3,"VAUX 1",{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$4","v":"APPOIGNY 1"},30,6,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$5","v":"ANCY LE FRANC 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1","","",null,null,0,""]
[4,"APPOIGNY 1",{"$f":"$B$5","v":"ANCY LE FRANC 1"},{"$f":"$B$6","v":"STADE AUXERRE 2"},26,10,{"$f":"$B$7","v":"MONETEAU 1"},{"$f":"$B$4","v":"APPOIGNY 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1","","",null,null,0,""]
[5,"ANCY LE FRANC 1",{"$f":"$B$7","v":"MONETEAU 1"},{"$f":"$B$8","v":"CHARBUY 1"},20,16,{"$f":"$B$8","v":"CHARBUY 1"},{"$f":"$B$2","v":"RAVIERES 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1",null,"",null,null,0,""]
[6,"STADE AUXERRE 2","  Match 2 : au 1er nommé le Mardi 08 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 1","","",null,null,0,""]
[7,"MONETEAU 1",{"$f":"$B$4","v":"APPOIGNY 1"},{"$f":"$B$1","v":"AVALLON 1"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},{"$f":"$B$6","v":"STADE AUXERRE 2"},{"$f":"$B$7","v":"MONETEAU 1"},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,0,""]
[8,"CHARBUY 1",{"$f":"$B$6","v":"STADE AUXERRE 2"},{"$f":"$B$3","v":"VAUX 1"},null,"",{"$f":"$B$4","v":"APPOIGNY 1"},{"$f":"$B$2","v":"RAVIERES 1"},null,"",null,null,null,null,null,"ANCY LE FRANC 1",null,"",{"$f":"SUM(R2:R8)","v":3},{"$f":"SUM(V2:V8)","v":16},0,""]
[null,null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$7","v":"MONETEAU 1"},null,"",{"$f":"$B$5","v":"ANCY LE FRANC 1"},{"$f":"$B$1","v":"AVALLON 1"},null,"",null,null,null,null,null,"APPOIGNY 1",6,1,null,null,6,-24]
[null,null,{"$f":"$B$8","v":"CHARBUY 1"},{"$f":"$B$5","v":"ANCY LE FRANC 1"},null,"",{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$8","v":"CHARBUY 1"},null,"",null,null,null,null,null,"APPOIGNY 1",null,"",null,null,0,""]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"APPOIGNY 1",null,"",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"APPOIGNY 1"},{"$f":"$B$5","v":"ANCY LE FRANC 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 1","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$3","v":"VAUX 1"},null,"","Classement",null,null,null,null,null,null,null,null,"APPOIGNY 1","","",null,null,0,""]
[null,null,{"$f":"$B$7","v":"MONETEAU 1"},{"$f":"$B$1","v":"AVALLON 1"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"APPOIGNY 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"STADE AUXERRE 2"},{"$f":"$B$8","v":"CHARBUY 1"},null,"",1,"AVALLON 1",3,28,null,null,null,null,null,"APPOIGNY 1",null,"",{"$f":"SUM(R9:R15)","v":1},{"$f":"SUM(V9:V15)","v":-24},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,2,"VAUX 1",3,24,null,null,null,null,null,"AVALLON 1",32,3,null,null,32,28]
[null,null,{"$f":"$B$5","v":"ANCY LE FRANC 1"},{"$f":"$B$2","v":"RAVIERES 1"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"ANCY LE FRANC 1",3,16,null,null,null,null,null,"AVALLON 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"STADE AUXERRE 2"},{"$f":"$B$4","v":"APPOIGNY 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"MONETEAU 1",3,4,null,null,null,null,null,"AVALLON 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$7","v":"MONETEAU 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"CHARBUY 1",1,-4,null,null,null,null,null,"AVALLON 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$8","v":"CHARBUY 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"STADE AUXERRE 2",1,-16,null,null,null,null,null,"AVALLON 1",null,"",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,7,"APPOIGNY 1",1,-24,null,null,null,null,null,"AVALLON 1",null,"",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,"RAVIERES 1",1,-28,null,null,null,null,null,"AVALLON 1","","",{"$f":"SUM(R16:R22)","v":3},{"$f":"SUM(V16:V22)","v":28},0,""]
[null,null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$6","v":"STADE AUXERRE 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,"CHARBUY 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$7","v":"MONETEAU 1"},{"$f":"$B$5","v":"ANCY LE FRANC 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,"CHARBUY 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$8","v":"CHARBUY 1"},{"$f":"$B$4","v":"APPOIGNY 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,"CHARBUY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 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,"CHARBUY 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,"CHARBUY 1",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 1","","",{"$f":"SUM(R23:R29)","v":1},{"$f":"SUM(V23:V29)","v":-4},0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 1 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",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,"MONETEAU 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1","","",{"$f":"SUM(R30:R36)","v":3},{"$f":"SUM(V30:V36)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1",4,1,null,null,4,-28]
[null,null,null,null,null,null,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,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1","","",null,null,0,""]
[null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1","","",{"$f":"SUM(R37:R43)","v":1},{"$f":"SUM(V37:V43)","v":-28},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",10,1,null,null,10,-16]
[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,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(R44:R50)","v":1},{"$f":"SUM(V44:V50)","v":-16},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",30,3,null,null,30,24]
[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,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":3},{"$f":"SUM(V51:V57)","v":24},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":"RAVIERES 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":"RAVIERES 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,"USC SENS 3","  Match 1 : au 1er nommé le Mardi 25 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"SENAN 2",{"$f":"$B$1","v":"USC SENS 3"},{"$f":"$B$2","v":"SENAN 2"},20,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":16},{"$f":"$B$1","v":"USC SENS 3"},{"$f":"$B$6","v":"ST FLORENTIN 2"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":""},null,null,null,null,null,"CHARBUY 3",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,"MIGENNES 2",{"$f":"$B$3","v":"MIGENNES 2"},{"$f":"$B$4","v":"USV VILLENEUVE 1"},20,16,{"$f":"$B$3","v":"MIGENNES 2"},{"$f":"$B$5","v":"PONT / YONNE 1"},null,"",null,null,null,null,null,"CHARBUY 3","","",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,"USV VILLENEUVE 1",{"$f":"$B$5","v":"PONT / YONNE 1"},{"$f":"$B$6","v":"ST FLORENTIN 2"},16,20,{"$f":"$B$4","v":"USV VILLENEUVE 1"},{"$f":"$B$7","v":"CHARBUY 3"},null,"",null,null,null,null,null,"CHARBUY 3",null,"",null,null,0,""]
[5,"PONT / YONNE 1",{"$f":"$B$7","v":"CHARBUY 3"},{"$f":"$B$8","v":"VERON 2"},20,16,{"$f":"$B$8","v":"VERON 2"},{"$f":"$B$2","v":"SENAN 2"},null,"",null,null,null,null,null,"CHARBUY 3","","",null,null,0,""]
[6,"ST FLORENTIN 2","  Match 2 : au 1er nommé le Mardi 08 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,null,null,null,null,null,"CHARBUY 3",null,"",null,null,0,""]
[7,"CHARBUY 3",{"$f":"$B$4","v":"USV VILLENEUVE 1"},{"$f":"$B$1","v":"USC SENS 3"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},{"$f":"$B$6","v":"ST FLORENTIN 2"},{"$f":"$B$7","v":"CHARBUY 3"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"CHARBUY 3","","",null,null,0,""]
[8,"VERON 2",{"$f":"$B$6","v":"ST FLORENTIN 2"},{"$f":"$B$3","v":"MIGENNES 2"},null,"",{"$f":"$B$4","v":"USV VILLENEUVE 1"},{"$f":"$B$2","v":"SENAN 2"},null,"",null,null,null,null,null,"CHARBUY 3","","",{"$f":"SUM(R2:R8)","v":3},{"$f":"SUM(V2:V8)","v":4},0,""]
[null,null,{"$f":"$B$2","v":"SENAN 2"},{"$f":"$B$7","v":"CHARBUY 3"},null,"",{"$f":"$B$5","v":"PONT / YONNE 1"},{"$f":"$B$1","v":"USC SENS 3"},null,"",null,null,null,null,null,"MIGENNES 2",20,3,null,null,20,4]
[null,null,{"$f":"$B$8","v":"VERON 2"},{"$f":"$B$5","v":"PONT / YONNE 1"},null,"",{"$f":"$B$3","v":"MIGENNES 2"},{"$f":"$B$8","v":"VERON 2"},null,"",null,null,null,null,null,"MIGENNES 2","","",null,null,0,""]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"MIGENNES 2","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"USV VILLENEUVE 1"},{"$f":"$B$5","v":"PONT / YONNE 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,"MIGENNES 2",null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"SENAN 2"},{"$f":"$B$3","v":"MIGENNES 2"},null,"","Classement",null,null,null,null,null,null,null,null,"MIGENNES 2","","",null,null,0,""]
[null,null,{"$f":"$B$7","v":"CHARBUY 3"},{"$f":"$B$1","v":"USC SENS 3"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"ST FLORENTIN 2"},{"$f":"$B$8","v":"VERON 2"},null,"",1,"CHARBUY 3",3,4,null,null,null,null,null,"MIGENNES 2",null,"",{"$f":"SUM(R9:R15)","v":3},{"$f":"SUM(V9:V15)","v":4},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,2,"MIGENNES 2",3,4,null,null,null,null,null,"PONT / YONNE 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$5","v":"PONT / YONNE 1"},{"$f":"$B$2","v":"SENAN 2"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"ST FLORENTIN 2",3,4,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"ST FLORENTIN 2"},{"$f":"$B$4","v":"USV VILLENEUVE 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"USC SENS 3",3,4,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"MIGENNES 2"},{"$f":"$B$7","v":"CHARBUY 3"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"PONT / YONNE 1",1,-4,null,null,null,null,null,"PONT / YONNE 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 3"},{"$f":"$B$8","v":"VERON 2"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"SENAN 2",1,-4,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,7,"USV VILLENEUVE 1",1,-4,null,null,null,null,null,"PONT / YONNE 1","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"USC SENS 3"},{"$f":"$B$3","v":"MIGENNES 2"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"VERON 2",1,-4,null,null,null,null,null,"PONT / YONNE 1",null,"",{"$f":"SUM(R16:R22)","v":1},{"$f":"SUM(V16:V22)","v":-4},0,""]
[null,null,{"$f":"$B$2","v":"SENAN 2"},{"$f":"$B$6","v":"ST FLORENTIN 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,"SENAN 2",16,1,null,null,16,-4]
[null,null,{"$f":"$B$7","v":"CHARBUY 3"},{"$f":"$B$5","v":"PONT / YONNE 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,"SENAN 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$8","v":"VERON 2"},{"$f":"$B$4","v":"USV VILLENEUVE 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,"SENAN 2",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,"SENAN 2","","",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,"SENAN 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,"SENAN 2","","",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2","","",{"$f":"SUM(R23:R29)","v":1},{"$f":"SUM(V23:V29)","v":-4},0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 2 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",20,3,null,null,20,4]
[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",null,"",null,null,0,""]
[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","","",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":"SUM(R30:R36)","v":3},{"$f":"SUM(V30:V36)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",20,3,null,null,20,4]
[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,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,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","","",{"$f":"SUM(R37:R43)","v":3},{"$f":"SUM(V37:V43)","v":4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USV VILLENEUVE 1",null,"",{"$f":"SUM(R44:R50)","v":1},{"$f":"SUM(V44:V50)","v":-4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",16,1,null,null,16,-4]
[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,"",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","","",{"$f":"SUM(R51:R57)","v":1},{"$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 3"},{"$f":"$B$2","v":"SENAN 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 2"},"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 3"},{"$f":"$B$2","v":"SENAN 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 2"},"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,"CHARBUY 2","  Match 1 : au 1er nommé le Mardi 25 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"AVALLON 2",{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$2","v":"AVALLON 2"},20,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":16},{"$f":"$B$6","v":"CHATEL CENSOIR 1"},{"$f":"$B$1","v":"CHARBUY 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","g",{"$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":19},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":19}]
[3,"HERY 1",{"$f":"$B$3","v":"HERY 1"},{"$f":"$B$4","v":"APPOIGNY 2"},12,24,{"$f":"$B$3","v":"HERY 1"},{"$f":"$B$5","v":"MONETEAU 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2","","",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,"APPOIGNY 2",{"$f":"$B$5","v":"MONETEAU 2"},{"$f":"$B$6","v":"CHATEL CENSOIR 1"},14,22,{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$4","v":"APPOIGNY 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[5,"MONETEAU 2",{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$8","v":"EXEMPT"},"g","F",{"$f":"$B$2","v":"AVALLON 2"},{"$f":"$B$8","v":"EXEMPT"},null,"",null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[6,"CHATEL CENSOIR 1","  Match 2 : au 1er nommé le Mardi 08 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 2",null,"",null,null,0,""]
[7,"ANCY LE FRANC 2",{"$f":"$B$4","v":"APPOIGNY 2"},{"$f":"$B$1","v":"CHARBUY 2"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},{"$f":"$B$6","v":"CHATEL CENSOIR 1"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},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,null,0,""]
[8,"EXEMPT",{"$f":"$B$6","v":"CHATEL CENSOIR 1"},{"$f":"$B$3","v":"HERY 1"},null,"",{"$f":"$B$4","v":"APPOIGNY 2"},{"$f":"$B$2","v":"AVALLON 2"},null,"",null,null,null,null,null,"ANCY LE FRANC 2","","",{"$f":"SUM(R2:R8)","v":3},{"$f":"SUM(V2:V8)","v":19},0,""]
[null,null,{"$f":"$B$2","v":"AVALLON 2"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},null,"",{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$5","v":"MONETEAU 2"},null,"",null,null,null,null,null,"APPOIGNY 2",24,3,null,null,24,12]
[null,null,{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$5","v":"MONETEAU 2"},null,"",{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$3","v":"HERY 1"},null,"",null,null,null,null,null,"APPOIGNY 2",null,"",null,null,0,""]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"APPOIGNY 2","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"MONETEAU 2"},{"$f":"$B$4","v":"APPOIGNY 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,"APPOIGNY 2","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$2","v":"AVALLON 2"},{"$f":"$B$3","v":"HERY 1"},null,"","Classement",null,null,null,null,null,null,null,null,"APPOIGNY 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},null,"",null,null,"Pts","+/-",null,null,null,null,null,"APPOIGNY 2","","",null,null,0,""]
[null,null,{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$6","v":"CHATEL CENSOIR 1"},null,"",1,"ANCY LE FRANC 2",3,19,null,null,null,null,null,"APPOIGNY 2",null,"",{"$f":"SUM(R9:R15)","v":3},{"$f":"SUM(V9:V15)","v":12},0,""]
[null,null,"  Match 4 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,2,"APPOIGNY 2",3,12,null,null,null,null,null,"AVALLON 2",16,1,null,null,16,-4]
[null,null,{"$f":"$B$5","v":"MONETEAU 2"},{"$f":"$B$2","v":"AVALLON 2"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},3,"CHATEL CENSOIR 1",3,8,null,null,null,null,null,"AVALLON 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"CHATEL CENSOIR 1"},{"$f":"$B$4","v":"APPOIGNY 2"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"CHARBUY 2",3,4,null,null,null,null,null,"AVALLON 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"HERY 1"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"AVALLON 2",1,-4,null,null,null,null,null,"AVALLON 2","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$8","v":"EXEMPT"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"MONETEAU 2",1,-8,null,null,null,null,null,"AVALLON 2",null,"",null,null,0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,7,"HERY 1",1,-12,null,null,null,null,null,"AVALLON 2",null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"HERY 1"},{"$f":"$B$1","v":"CHARBUY 2"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},8,"EXEMPT",0,-19,null,null,null,null,null,"AVALLON 2","","",{"$f":"SUM(R16:R22)","v":1},{"$f":"SUM(V16:V22)","v":-4},0,""]
[null,null,{"$f":"$B$2","v":"AVALLON 2"},{"$f":"$B$6","v":"CHATEL CENSOIR 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,"CHARBUY 2",20,3,null,null,20,4]
[null,null,{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$5","v":"MONETEAU 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,"CHARBUY 2","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"APPOIGNY 2"},{"$f":"$B$8","v":"EXEMPT"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 2",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,"CHARBUY 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,"CHARBUY 2","","",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,"CHARBUY 2","","",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 2",null,"",{"$f":"SUM(R23:R29)","v":3},{"$f":"SUM(V23:V29)","v":4},0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 2 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",{"$f":"SUM(R30:R36)","v":3},{"$f":"SUM(V30:V36)","v":8},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXEMPT",null,"",{"$f":"SUM(R37:R43)","v":0},{"$f":"SUM(V37:V43)","v":-19},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",12,1,null,null,12,-12]
[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,"",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,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1","","",{"$f":"SUM(R44:R50)","v":1},{"$f":"SUM(V44:V50)","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","","",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","","",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","","",{"$f":"SUM(R51:R57)","v":1},{"$f":"SUM(V51:V57)","v":-8},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":"CHARBUY 2"},{"$f":"$B$2","v":"AVALLON 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"HERY 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":"CHARBUY 2"},{"$f":"$B$2","v":"AVALLON 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"HERY 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":[[29,1,29,10],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[12,2,12,5],[12,6,12,9],[10,6,10,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10],[28,1,28,10]]}
[1,"STADE DE SENS 2","  Match 1 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"MALAY LE GRAND 1",{"$f":"$B$1","v":"STADE DE SENS 2"},{"$f":"$B$2","v":"MALAY LE GRAND 1"},null,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":""},null,null,null,null,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 MARTIN TERTRE 1",{"$f":"$B$3","v":"ST MARTIN TERTRE 1"},{"$f":"$B$4","v":"APPOIGNY 3"},null,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",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,"APPOIGNY 3",{"$f":"$B$5","v":"MIGENNES 3"},{"$f":"$B$6","v":"ST FLORENTIN 3"},null,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[5,"MIGENNES 3","  Match 2 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[6,"ST FLORENTIN 3",{"$f":"$B$3","v":"ST MARTIN TERTRE 1"},{"$f":"$B$1","v":"STADE DE SENS 2"},null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R2:R6)","v":0},{"$f":"SUM(V2:V6)","v":0},0,""]
[null,null,{"$f":"$B$2","v":"MALAY LE GRAND 1"},{"$f":"$B$5","v":"MIGENNES 3"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"APPOIGNY 3"},{"$f":"$B$6","v":"ST FLORENTIN 3"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,"  Match 3  : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$4","v":"APPOIGNY 3"},{"$f":"$B$1","v":"STADE DE SENS 2"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$6","v":"ST FLORENTIN 3"},{"$f":"$B$2","v":"MALAY LE GRAND 1"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":""},"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R7:R11)","v":0},{"$f":"SUM(V7:V11)","v":0},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"MIGENNES 3"},{"$f":"$B$3","v":"ST MARTIN TERTRE 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,0,"","",null,null,0,""]
["sont à remplir",null,"  Match 4 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,"Classement",null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"STADE DE SENS 2"},{"$f":"$B$5","v":"MIGENNES 3"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"MALAY LE GRAND 1"},{"$f":"$B$4","v":"APPOIGNY 3"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},1,0,0,0,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"ST MARTIN TERTRE 1"},{"$f":"$B$6","v":"ST FLORENTIN 3"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},2,0,0,0,null,null,null,null,null,0,null,"",{"$f":"SUM(R12:R16)","v":0},{"$f":"SUM(V12:V16)","v":0},0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,3,0,0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"ST FLORENTIN 3"},{"$f":"$B$1","v":"STADE DE SENS 2"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,0,0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$2","v":"MALAY LE GRAND 1"},{"$f":"$B$3","v":"ST MARTIN TERTRE 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,0,0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$5","v":"MIGENNES 3"},{"$f":"$B$4","v":"APPOIGNY 3"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,0,0,0,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(R17:R21)","v":0},{"$f":"SUM(V17:V21)","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,"",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},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,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,0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 3 Groupe A",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(R27:R31)","v":0},{"$f":"SUM(V27:V31)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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":"STADE DE SENS 2"},{"$f":"$B$2","v":"MALAY LE GRAND 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST MARTIN TERTRE 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":"STADE DE SENS 2"},{"$f":"$B$2","v":"MALAY LE GRAND 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST MARTIN TERTRE 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 B","index":5,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[28,1,28,10],[29,1,29,10],[12,2,12,5],[12,6,12,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10],[10,6,10,9],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5]]}
[1,"BLENEAU 1","  Match 1 : au 1er nommé le Mardi 22 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"CHARBUY 4",{"$f":"$B$1","v":"BLENEAU 1"},{"$f":"$B$2","v":"CHARBUY 4"},null,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1",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,"MONETEAU 3",{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$3","v":"MONETEAU 3"},null,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",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$5","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$6","v":"VAUX 3"},null,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",null,null,0,""]
[5,"ST PÈRE / VEZELAY 1","  Match 2 : au 1er nommé le Mardi 06 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"BLENEAU 1",null,"",null,null,0,""]
[6,"VAUX 3",{"$f":"$B$3","v":"MONETEAU 3"},{"$f":"$B$1","v":"BLENEAU 1"},null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",{"$f":"SUM(R2:R6)","v":0},{"$f":"SUM(V2:V6)","v":0},0,""]
[null,null,{"$f":"$B$2","v":"CHARBUY 4"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"VAUX 3"},{"$f":"$B$4","v":"MIGENNES 4"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
[null,null,"  Match 3  : au 1er nommé le Mardi 20 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$1","v":"BLENEAU 1"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$6","v":"VAUX 3"},{"$f":"$B$2","v":"CHARBUY 4"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":""},"CLASSEMENT : le mardi 24 Juin ,14h30 à St Florentin",null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",{"$f":"SUM(R7:R11)","v":0},{"$f":"SUM(V7:V11)","v":0},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$3","v":"MONETEAU 3"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""]
["sont à remplir",null,"  Match 4 : au 1er nommé le Mardi 27 Mai à 14h30",null,null,null,"Classement",null,null,null,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"BLENEAU 1"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"CHARBUY 4"},{"$f":"$B$4","v":"MIGENNES 4"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},1,"BLENEAU 1",0,0,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"MONETEAU 3"},{"$f":"$B$6","v":"VAUX 3"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},2,"CHARBUY 4",0,0,null,null,null,null,null,"MIGENNES 4",null,"",{"$f":"SUM(R12:R16)","v":0},{"$f":"SUM(V12:V16)","v":0},0,""]
[null,null,"  Match 5 : au 1er nommé le Mardi 03 Juin à 14h30",null,null,null,3,"MIGENNES 4",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"VAUX 3"},{"$f":"$B$1","v":"BLENEAU 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"MONETEAU 3",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"CHARBUY 4"},{"$f":"$B$3","v":"MONETEAU 3"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"ST PÈRE / VEZELAY 1",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"MIGENNES 4"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"VAUX 3",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 3","","",{"$f":"SUM(R17:R21)","v":0},{"$f":"SUM(V17:V21)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},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,"VAUX 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,"VAUX 3",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,"Championnat Départemental des Clubs 2025 Vétérans Division 3 Groupe B",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,"",{"$f":"SUM(R27:R31)","v":0},{"$f":"SUM(V27:V31)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[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":"BLENEAU 1"},{"$f":"$B$2","v":"CHARBUY 4"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"MONETEAU 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":"BLENEAU 1"},{"$f":"$B$2","v":"CHARBUY 4"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"MONETEAU 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"]