{"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 Gr Unique","classement D1 Gr A et B","classement D2 Gr A et B"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":5,"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],[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 28 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 30 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"USC SENS 3",{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$2","v":"USC SENS 3"},8,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":28},{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$6","v":"MIGENNES 1"},18,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":18},null,null,null,null,null,"AILLANT 1",14,{"$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":14},{"$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,"PONT / YONNE 1",{"$f":"$B$3","v":"PONT / YONNE 1"},{"$f":"$B$4","v":"PARON 1"},12,24,{"$f":"$B$3","v":"PONT / YONNE 1"},{"$f":"$B$5","v":"STADE DE SENS 1"},18,18,null,null,null,null,null,"AILLANT 1",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,"PARON 1",{"$f":"$B$5","v":"STADE DE SENS 1"},{"$f":"$B$6","v":"MIGENNES 1"},32,4,{"$f":"$B$7","v":"SENAN 1"},{"$f":"$B$4","v":"PARON 1"},22,14,null,null,null,null,null,"AILLANT 1",8,1,null,null,8,-20]
[5,"STADE DE SENS 1",{"$f":"$B$7","v":"SENAN 1"},{"$f":"$B$8","v":"AILLANT 1"},22,14,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$2","v":"USC SENS 3"},16,20,null,null,null,null,null,"AILLANT 1",16,1,null,null,16,-4]
[6,"MIGENNES 1","  Match 2 : au 1er nommé le Mardi 11 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 06 Juin à 14h30",null,null,null,null,null,null,null,null,"AILLANT 1",10,1,null,null,10,-16]
[7,"SENAN 1",{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$1","v":"USC SENS 1"},34,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":2},{"$f":"$B$6","v":"MIGENNES 1"},{"$f":"$B$7","v":"SENAN 1"},20,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":16},null,null,null,null,null,"AILLANT 1",16,1,null,null,16,-4]
[8,"AILLANT 1",{"$f":"$B$6","v":"MIGENNES 1"},{"$f":"$B$3","v":"PONT / YONNE 1"},24,12,{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$2","v":"USC SENS 3"},26,10,null,null,null,null,null,"AILLANT 1",16,1,{"$f":"SUM(R2:R8)","v":7},{"$f":"SUM(V2:V8)","v":-60},16,-4]
[null,null,{"$f":"$B$2","v":"USC SENS 3"},{"$f":"$B$7","v":"SENAN 1"},20,16,{"$f":"$B$5","v":"STADE DE SENS 1"},{"$f":"$B$1","v":"USC SENS 1"},28,8,null,null,null,null,null,"MIGENNES 1",4,1,null,null,4,-28]
[null,null,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$5","v":"STADE DE SENS 1"},16,20,{"$f":"$B$3","v":"PONT / YONNE 1"},{"$f":"$B$8","v":"AILLANT 1"},20,16,null,null,null,null,null,"MIGENNES 1",24,3,null,null,24,12]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 25 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 1",28,3,null,null,28,20]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"PARON 1"},{"$f":"$B$5","v":"STADE DE SENS 1"},22,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":14},null,null,null,null,null,null,null,null,null,"MIGENNES 1",10,1,null,null,10,-16]
["sont à remplir",null,{"$f":"$B$2","v":"USC SENS 3"},{"$f":"$B$3","v":"PONT / YONNE 1"},20,16,"Classement",null,null,null,null,null,null,null,null,"MIGENNES 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$7","v":"SENAN 1"},{"$f":"$B$1","v":"USC SENS 1"},12,24,null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$6","v":"MIGENNES 1"},{"$f":"$B$8","v":"AILLANT 1"},28,8,1,"PARON 1",19,92,null,null,null,null,null,"MIGENNES 1",20,3,{"$f":"SUM(R9:R15)","v":14},{"$f":"SUM(V9:V15)","v":-12},20,4]
[null,null,"  Match 4 : au 1er nommé le Mardi 09 Mai à 14h30",null,null,null,2,"STADE DE SENS 1",18,56,null,null,null,null,null,"PARON 1",24,3,null,null,24,12]
[null,null,{"$f":"$B$5","v":"STADE DE SENS 1"},{"$f":"$B$2","v":"USC SENS 3"},22,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":14},3,"USC SENS 3",17,12,null,null,null,null,null,"PARON 1",34,3,null,null,34,32]
[null,null,{"$f":"$B$6","v":"MIGENNES 1"},{"$f":"$B$4","v":"PARON 1"},10,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":26},4,"USC SENS 1",14,-32,null,null,null,null,null,"PARON 1",22,3,null,null,22,8]
[null,null,{"$f":"$B$3","v":"PONT / YONNE 1"},{"$f":"$B$7","v":"SENAN 1"},16,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":20},5,"MIGENNES 1",14,-12,null,null,null,null,null,"PARON 1",26,3,null,null,26,16]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$8","v":"AILLANT 1"},20,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":16},6,"SENAN 1",13,-4,null,null,null,null,null,"PARON 1",26,3,null,null,26,16]
[null,null,"  Match 5 : au 1er nommé le Mardi 23 Mai à 14h30",null,null,null,7,"PONT / YONNE 1",10,-52,null,null,null,null,null,"PARON 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$1","v":"USC SENS 1"},{"$f":"$B$3","v":"PONT / YONNE 1"},30,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":6},8,"AILLANT 1",7,-60,null,null,null,null,null,"PARON 1",26,3,{"$f":"SUM(R16:R22)","v":19},{"$f":"SUM(V16:V22)","v":92},26,16]
[null,null,{"$f":"$B$2","v":"USC SENS 3"},{"$f":"$B$6","v":"MIGENNES 1"},20,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":16},null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",12,1,null,null,12,-12]
[null,null,{"$f":"$B$7","v":"SENAN 1"},{"$f":"$B$5","v":"STADE DE SENS 1"},16,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":20},null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",12,1,null,null,12,-12]
[null,null,{"$f":"$B$8","v":"AILLANT 1"},{"$f":"$B$4","v":"PARON 1"},10,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":26},null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",16,1,null,null,16,-4]
[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,"PONT / YONNE 1",6,1,null,null,6,-24]
[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,"PONT / YONNE 1",18,2,null,null,18,0]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PONT / YONNE 1",20,3,{"$f":"SUM(R23:R29)","v":10},{"$f":"SUM(V23:V29)","v":-52},20,4]
[null,"Championnat Départemental des Clubs 2023 Vétérans Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",12,1,null,null,12,-12]
[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",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 1",16,1,{"$f":"SUM(R30:R36)","v":13},{"$f":"SUM(V30:V36)","v":-4},16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",14,1,null,null,14,-8]
[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",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",28,3,{"$f":"SUM(R37:R43)","v":18},{"$f":"SUM(V37:V43)","v":56},28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",8,1,null,null,8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",2,1,null,null,2,-32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",24,3,null,null,24,12]
[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",30,3,null,null,30,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",8,1,{"$f":"SUM(R44:R50)","v":14},{"$f":"SUM(V44:V50)","v":-32},8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",28,3,null,null,28,20]
[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",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",14,1,null,null,14,-8]
[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",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 3",10,1,{"$f":"SUM(R51:R57)","v":17},{"$f":"SUM(V51:V57)","v":12},10,-16]
[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":"USC SENS 3"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"PONT / YONNE 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":"USC SENS 3"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"PONT / YONNE 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]]}
[1,"USC SENS 2","  Match 1 : au 1er nommé le Mardi 28 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 30 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"RAVIERES 1",{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$2","v":"RAVIERES 1"},16,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":20},{"$f":"$B$6","v":"APPOIGNY 1"},{"$f":"$B$1","v":"USC SENS 2"},14,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":22},null,null,null,null,null,"ANCY LE FRANC 1",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,"ANCY LE FRANC 1",{"$f":"$B$3","v":"ANCY LE FRANC 1"},{"$f":"$B$4","v":"VAUX 1"},16,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":20},{"$f":"$B$5","v":"STADE AUXERRE 1"},{"$f":"$B$3","v":"ANCY LE FRANC 1"},34,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",36-I3)))","v":2},null,null,null,null,null,"ANCY LE FRANC 1",14,1,null,null,14,-8]
[4,"VAUX 1",{"$f":"$B$5","v":"STADE AUXERRE 1"},{"$f":"$B$6","v":"APPOIGNY 1"},20,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":16},{"$f":"$B$7","v":"CHARBUY 1"},{"$f":"$B$4","v":"VAUX 1"},12,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",36-I4)))","v":24},null,null,null,null,null,"ANCY LE FRANC 1",22,3,null,null,22,8]
[5,"STADE AUXERRE 1",{"$f":"$B$7","v":"CHARBUY 1"},{"$f":"$B$8","v":"ST FLORENTIN 1"},2,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":34},{"$f":"$B$8","v":"ST FLORENTIN 1"},{"$f":"$B$2","v":"RAVIERES 1"},28,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":8},null,null,null,null,null,"ANCY LE FRANC 1",12,1,null,null,12,-12]
[6,"APPOIGNY 1","  Match 2 : au 1er nommé le Mardi 11 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 06 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 1",26,3,null,null,26,16]
[7,"CHARBUY 1",{"$f":"$B$4","v":"VAUX 1"},{"$f":"$B$1","v":"USC SENS 2"},22,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":14},{"$f":"$B$6","v":"APPOIGNY 1"},{"$f":"$B$7","v":"CHARBUY 1"},28,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":8},null,null,null,null,null,"ANCY LE FRANC 1",2,1,null,null,2,-32]
[8,"ST FLORENTIN 1",{"$f":"$B$6","v":"APPOIGNY 1"},{"$f":"$B$3","v":"ANCY LE FRANC 1"},22,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":14},{"$f":"$B$4","v":"VAUX 1"},{"$f":"$B$2","v":"RAVIERES 1"},26,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":10},null,null,null,null,null,"ANCY LE FRANC 1",20,3,{"$f":"SUM(R2:R8)","v":13},{"$f":"SUM(V2:V8)","v":-28},20,4]
[null,null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$7","v":"CHARBUY 1"},26,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",36-E9)))","v":10},{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$5","v":"STADE AUXERRE 1"},2,{"$f":"IF(I9=\"\",\"\",IF(I9=\"F\",\"G\",IF(I9=\"G\",\"F\",36-I9)))","v":34},null,null,null,null,null,"APPOIGNY 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$8","v":"ST FLORENTIN 1"},{"$f":"$B$5","v":"STADE AUXERRE 1"},12,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":24},{"$f":"$B$3","v":"ANCY LE FRANC 1"},{"$f":"$B$8","v":"ST FLORENTIN 1"},20,{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":16},null,null,null,null,null,"APPOIGNY 1",22,3,null,null,22,8]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 25 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"APPOIGNY 1",16,1,null,null,16,-4]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"VAUX 1"},{"$f":"$B$5","v":"STADE AUXERRE 1"},14,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":22},null,null,null,null,null,null,null,null,null,"APPOIGNY 1",12,1,null,null,12,-12]
["sont à remplir",null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$3","v":"ANCY LE FRANC 1"},14,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",36-E13)))","v":22},"Classement",null,null,null,null,null,null,null,null,"APPOIGNY 1",36,3,null,null,36,36]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$7","v":"CHARBUY 1"},22,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":14},null,null,"Pts","+/-",null,null,null,null,null,"APPOIGNY 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$6","v":"APPOIGNY 1"},{"$f":"$B$8","v":"ST FLORENTIN 1"},16,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":20},1,"STADE AUXERRE 1",21,136,null,null,null,null,null,"APPOIGNY 1",28,3,{"$f":"SUM(R9:R15)","v":13},{"$f":"SUM(V9:V15)","v":36},28,20]
[null,null,"  Match 4 : au 1er nommé le Mardi 09 Mai à 14h30",null,null,null,2,"ST FLORENTIN 1",17,92,null,null,null,null,null,"CHARBUY 1",2,1,null,null,2,-32]
[null,null,{"$f":"$B$5","v":"STADE AUXERRE 1"},{"$f":"$B$2","v":"RAVIERES 1"},26,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":10},3,"VAUX 1",17,20,null,null,null,null,null,"CHARBUY 1",10,1,null,null,10,-16]
[null,null,{"$f":"$B$4","v":"VAUX 1"},{"$f":"$B$6","v":"APPOIGNY 1"},24,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":12},4,"APPOIGNY 1",13,36,null,null,null,null,null,"CHARBUY 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$3","v":"ANCY LE FRANC 1"},{"$f":"$B$7","v":"CHARBUY 1"},12,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":24},5,"ANCY LE FRANC 1",13,-28,null,null,null,null,null,"CHARBUY 1",24,3,null,null,24,12]
[null,null,{"$f":"$B$8","v":"ST FLORENTIN 1"},{"$f":"$B$1","v":"USC SENS 2"},32,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":4},6,"USC SENS 2",11,-72,null,null,null,null,null,"CHARBUY 1",2,1,null,null,2,-32]
[null,null,"  Match 5 : au 1er nommé le Mardi 23 Mai à 14h30",null,null,null,7,"RAVIERES 1",11,-76,null,null,null,null,null,"CHARBUY 1",12,1,null,null,12,-12]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$3","v":"ANCY LE FRANC 1"},10,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":26},8,"CHARBUY 1",9,-108,null,null,null,null,null,"CHARBUY 1",8,1,{"$f":"SUM(R16:R22)","v":9},{"$f":"SUM(V16:V22)","v":-108},8,-20]
[null,null,{"$f":"$B$2","v":"RAVIERES 1"},{"$f":"$B$6","v":"APPOIGNY 1"},0,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":36},null,null,null,null,null,null,null,null,null,"RAVIERES 1",20,3,null,null,20,4]
[null,null,{"$f":"$B$7","v":"CHARBUY 1"},{"$f":"$B$5","v":"STADE AUXERRE 1"},2,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":34},null,null,null,null,null,null,null,null,null,"RAVIERES 1",26,3,null,null,26,16]
[null,null,{"$f":"$B$8","v":"ST FLORENTIN 1"},{"$f":"$B$4","v":"VAUX 1"},30,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":6},null,null,null,null,null,null,null,null,null,"RAVIERES 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1",10,1,null,null,10,-16]
[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",0,1,null,null,0,-36]
[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",8,1,null,null,8,-20]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1",10,1,{"$f":"SUM(R23:R29)","v":11},{"$f":"SUM(V23:V29)","v":-76},10,-16]
[null,"Championnat Départemental des Clubs 2023 Vétérans Division 1 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",34,3,null,null,34,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",30,{"$f":"IF(Q34=\"\",\"\",IF(Q34=\"F\",0,IF(Q34=18,2,IF(Q34>18,3,1))))","v":3},null,null,{"$f":"IF(Q34=\"G\",19,IF(Q34=\"\",0,Q34))","v":30},{"$f":"IF(Q34=\"\",\"\",IF(U34=36,36,IF(U34=0,-36,IF(U34=19,19,IF(U34=\"f\",-19,U34-(36-U34))))))","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",16,1,{"$f":"SUM(R30:R36)","v":17},{"$f":"SUM(V30:V36)","v":92},16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",34,3,null,null,34,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",34,3,null,null,34,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 1",34,3,{"$f":"SUM(R37:R43)","v":21},{"$f":"SUM(V37:V43)","v":136},34,32]
[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",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",4,1,null,null,4,-28]
[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",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",2,1,{"$f":"SUM(R44:R50)","v":11},{"$f":"SUM(V44:V50)","v":-72},2,-32]
[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",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",6,1,null,null,6,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",26,3,{"$f":"SUM(R51:R57)","v":17},{"$f":"SUM(V51:V57)","v":20},26,16]
[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":"RAVIERES 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"ANCY LE FRANC 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":"RAVIERES 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"ANCY LE FRANC 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":[[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],[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,"MIGENNES 2","  Match 1 : au 1er nommé le Mardi 28 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 30 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"STADE DE SENS 2",{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},14,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":22},{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$6","v":"SENAN 2"},6,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":30},null,null,null,null,null,"APPOIGNY 2",12,{"$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":12},{"$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,"VERON 1",{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$4","v":"MONETEAU 2"},26,10,{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$5","v":"ST FLORENTIN 2"},32,4,null,null,null,null,null,"APPOIGNY 2",14,1,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":14},{"$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,"MONETEAU 2",{"$f":"$B$5","v":"ST FLORENTIN 2"},{"$f":"$B$6","v":"SENAN 2"},28,8,{"$f":"$B$7","v":"APPOIGNY 2"},{"$f":"$B$4","v":"MONETEAU 2"},14,22,null,null,null,null,null,"APPOIGNY 2",26,3,null,null,26,16]
[5,"ST FLORENTIN 2",{"$f":"$B$7","v":"APPOIGNY 2"},{"$f":"$B$8","v":"CHARBUY 2"},12,24,{"$f":"$B$8","v":"CHARBUY 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},20,16,null,null,null,null,null,"APPOIGNY 2",30,3,null,null,30,24]
[6,"SENAN 2","  Match 2 : au 1er nommé le Mardi 11 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 06 Juin à 14h30",null,null,null,null,null,null,null,null,"APPOIGNY 2",22,3,null,null,22,8]
[7,"APPOIGNY 2",{"$f":"$B$4","v":"MONETEAU 2"},{"$f":"$B$1","v":"MIGENNES 2"},32,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":4},{"$f":"$B$6","v":"SENAN 2"},{"$f":"$B$7","v":"APPOIGNY 2"},14,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":22},null,null,null,null,null,"APPOIGNY 2",14,1,null,null,14,-8]
[8,"CHARBUY 2",{"$f":"$B$6","v":"SENAN 2"},{"$f":"$B$3","v":"VERON 1"},6,30,{"$f":"$B$4","v":"MONETEAU 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},28,8,null,null,null,null,null,"APPOIGNY 2",22,3,{"$f":"SUM(R2:R8)","v":15},{"$f":"SUM(V2:V8)","v":28},22,8]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$7","v":"APPOIGNY 2"},22,14,{"$f":"$B$5","v":"ST FLORENTIN 2"},{"$f":"$B$1","v":"MIGENNES 2"},18,18,null,null,null,null,null,"CHARBUY 2",24,3,null,null,24,12]
[null,null,{"$f":"$B$8","v":"CHARBUY 2"},{"$f":"$B$5","v":"ST FLORENTIN 2"},16,20,{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$8","v":"CHARBUY 2"},22,14,null,null,null,null,null,"CHARBUY 2",16,1,null,null,16,-4]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 25 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 2",20,3,null,null,20,4]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"MONETEAU 2"},{"$f":"$B$5","v":"ST FLORENTIN 2"},22,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":14},null,null,null,null,null,null,null,null,null,"CHARBUY 2",22,3,null,null,22,8]
["sont à remplir",0,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$3","v":"VERON 1"},8,28,"Classement",null,null,null,null,null,null,null,null,"CHARBUY 2",4,1,null,null,4,-28]
[null,null,{"$f":"$B$7","v":"APPOIGNY 2"},{"$f":"$B$1","v":"MIGENNES 2"},26,10,null,null,"Pts","+/-",null,null,null,null,null,"CHARBUY 2",20,3,null,null,20,4]
[null,null,{"$f":"$B$6","v":"SENAN 2"},{"$f":"$B$8","v":"CHARBUY 2"},16,20,1,"VERON 1",19,84,null,null,null,null,null,"CHARBUY 2",14,1,{"$f":"SUM(R9:R15)","v":15},{"$f":"SUM(V9:V15)","v":-12},14,-8]
[null,null,"  Match 4 : au 1er nommé le Mardi 09 Mai à 14h30",null,null,null,2,"MONETEAU 2",19,96,null,null,null,null,null,"MIGENNES 2",14,1,null,null,14,-8]
[null,null,{"$f":"$B$5","v":"ST FLORENTIN 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},26,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":10},3,"APPOIGNY 2",15,28,null,null,null,null,null,"MIGENNES 2",4,1,null,null,4,-28]
[null,null,{"$f":"$B$6","v":"SENAN 2"},{"$f":"$B$4","v":"MONETEAU 2"},8,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":28},4,"CHARBUY 2",15,-12,null,null,null,null,null,"MIGENNES 2",10,1,null,null,10,-16]
[null,null,{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$7","v":"APPOIGNY 2"},6,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":30},5,"ST FLORENTIN 2",14,-4,null,null,null,null,null,"MIGENNES 2",14,1,null,null,14,-8]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$8","v":"CHARBUY 2"},14,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":22},6,"STADE DE SENS 2",13,-36,null,null,null,null,null,"MIGENNES 2",12,1,null,null,12,-12]
[null,null,"  Match 5 : au 1er nommé le Mardi 23 Mai à 14h30",null,null,null,7,"SENAN 2",9,-60,null,null,null,null,null,"MIGENNES 2",6,1,null,null,6,-24]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$3","v":"VERON 1"},12,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":24},8,"MIGENNES 2",8,-96,null,null,null,null,null,"MIGENNES 2",18,2,{"$f":"SUM(R16:R22)","v":8},{"$f":"SUM(V16:V22)","v":-96},18,0]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$6","v":"SENAN 2"},22,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":14},null,null,null,null,null,null,null,null,null,"MONETEAU 2",10,1,null,null,10,-16]
[null,null,{"$f":"$B$7","v":"APPOIGNY 2"},{"$f":"$B$5","v":"ST FLORENTIN 2"},22,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":14},null,null,null,null,null,null,null,null,null,"MONETEAU 2",32,3,null,null,32,28]
[null,null,{"$f":"$B$8","v":"CHARBUY 2"},{"$f":"$B$4","v":"MONETEAU 2"},4,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":32},null,null,null,null,null,null,null,null,null,"MONETEAU 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",28,3,null,null,28,20]
[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,"MONETEAU 2",32,3,null,null,32,28]
[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,"MONETEAU 2",22,3,null,null,22,8]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 2",28,3,{"$f":"SUM(R23:R29)","v":19},{"$f":"SUM(V23:V29)","v":96},28,20]
[null,"Championnat Départemental des Clubs 2023 Vétérans Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",8,1,null,null,8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",6,1,null,null,6,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",8,1,null,null,8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",30,3,null,null,30,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 2",14,1,{"$f":"SUM(R30:R36)","v":9},{"$f":"SUM(V30:V36)","v":-60},14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",28,3,null,null,28,20]
[null,null,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",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",4,1,null,null,4,-28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 2",18,2,{"$f":"SUM(R37:R43)","v":14},{"$f":"SUM(V37:V43)","v":-4},18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",8,1,null,null,8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",8,1,{"$f":"SUM(R44:R50)","v":13},{"$f":"SUM(V44:V50)","v":-36},8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",30,3,null,null,30,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",6,1,null,null,6,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",22,3,{"$f":"SUM(R51:R57)","v":19},{"$f":"SUM(V51:V57)","v":84},22,8]
[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":"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":"VERON 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":"MIGENNES 2"},{"$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":"VERON 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 B","index":3,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[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],[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,"MONETEAU 1","  Match 1 : au 1er nommé le Mardi 28 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 30 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"CHATEL CENSOIR 1",{"$f":"$B$1","v":"MONETEAU 1"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},28,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":8},{"$f":"$B$1","v":"MONETEAU 1"},{"$f":"$B$6","v":"AVALLON 1"},12,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":24},null,null,null,null,null,"ANCY LE FRANC 2",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,"VAUX 2",{"$f":"$B$3","v":"VAUX 2"},{"$f":"$B$4","v":"STADE AUXERRE 2"},4,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":32},{"$f":"$B$3","v":"VAUX 2"},{"$f":"$B$5","v":"ANCY LE FRANC 2"},28,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",36-I3)))","v":8},null,null,null,null,null,"ANCY LE FRANC 2",20,3,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":20},{"$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,"STADE AUXERRE 2",{"$f":"$B$5","v":"ANCY LE FRANC 2"},{"$f":"$B$6","v":"AVALLON 1"},8,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":28},{"$f":"$B$7","v":"LIGNY CHATEL 1"},{"$f":"$B$4","v":"STADE AUXERRE 2"},12,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",36-I4)))","v":24},null,null,null,null,null,"ANCY LE FRANC 2",16,1,null,null,16,-4]
[5,"ANCY LE FRANC 2",{"$f":"$B$7","v":"LIGNY CHATEL 1"},{"$f":"$B$8","v":"HERY 1"},26,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":10},{"$f":"$B$8","v":"HERY 1"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},22,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":14},null,null,null,null,null,"ANCY LE FRANC 2",20,3,null,null,20,4]
[6,"AVALLON 1","  Match 2 : au 1er nommé le Mardi 11 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 06 Juin à 14h30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 2",12,1,null,null,12,-12]
[7,"LIGNY CHATEL 1",{"$f":"$B$4","v":"STADE AUXERRE 2"},{"$f":"$B$1","v":"MONETEAU 1"},22,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":14},{"$f":"$B$6","v":"AVALLON 1"},{"$f":"$B$7","v":"LIGNY CHATEL 1"},18,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":18},null,null,null,null,null,"ANCY LE FRANC 2",8,1,null,null,8,-20]
[8,"HERY 1",{"$f":"$B$6","v":"AVALLON 1"},{"$f":"$B$3","v":"VAUX 2"},18,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":18},{"$f":"$B$4","v":"STADE AUXERRE 2"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},22,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":14},null,null,null,null,null,"ANCY LE FRANC 2",20,3,{"$f":"SUM(R2:R8)","v":13},{"$f":"SUM(V2:V8)","v":-44},20,4]
[null,null,{"$f":"$B$2","v":"CHATEL CENSOIR 1"},{"$f":"$B$7","v":"LIGNY CHATEL 1"},18,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",36-E9)))","v":18},{"$f":"$B$5","v":"ANCY LE FRANC 2"},{"$f":"$B$1","v":"MONETEAU 1"},20,{"$f":"IF(I9=\"\",\"\",IF(I9=\"F\",\"G\",IF(I9=\"G\",\"F\",36-I9)))","v":16},null,null,null,null,null,"AVALLON 1",28,3,null,null,28,20]
[null,null,{"$f":"$B$8","v":"HERY 1"},{"$f":"$B$5","v":"ANCY LE FRANC 2"},16,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":20},{"$f":"$B$3","v":"VAUX 2"},{"$f":"$B$8","v":"HERY 1"},36,{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":0},null,null,null,null,null,"AVALLON 1",18,2,null,null,18,0]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 25 Avril à 14h30",null,null,null,null,null,null,null,null,null,null,null,null,"AVALLON 1",34,3,null,null,34,32]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"STADE AUXERRE 2"},{"$f":"$B$5","v":"ANCY LE FRANC 2"},20,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":16},null,null,null,null,null,null,null,null,null,"AVALLON 1",30,3,null,null,30,24]
["sont à remplir",null,{"$f":"$B$2","v":"CHATEL CENSOIR 1"},{"$f":"$B$3","v":"VAUX 2"},20,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",36-E13)))","v":16},"Classement",null,null,null,null,null,null,null,null,"AVALLON 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$7","v":"LIGNY CHATEL 1"},{"$f":"$B$1","v":"MONETEAU 1"},16,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":20},null,null,"Pts","+/-",null,null,null,null,null,"AVALLON 1",24,3,null,null,24,12]
[null,null,{"$f":"$B$6","v":"AVALLON 1"},{"$f":"$B$8","v":"HERY 1"},34,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":2},1,"STADE AUXERRE 2",19,52,null,null,null,null,null,"AVALLON 1",18,2,{"$f":"SUM(R9:R15)","v":17},{"$f":"SUM(V9:V15)","v":80},18,0]
[null,null,"  Match 4 : au 1er nommé le Mardi 09 Mai à 14h30",null,null,null,2,"AVALLON 1",17,80,null,null,null,null,null,"CHATEL CENSOIR 1",8,1,null,null,8,-20]
[null,null,{"$f":"$B$5","v":"ANCY LE FRANC 2"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},20,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":16},3,"VAUX 2",15,32,null,null,null,null,null,"CHATEL CENSOIR 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$6","v":"AVALLON 1"},{"$f":"$B$4","v":"STADE AUXERRE 2"},30,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":6},4,"MONETEAU 1",14,16,null,null,null,null,null,"CHATEL CENSOIR 1",20,3,null,null,20,4]
[null,null,{"$f":"$B$3","v":"VAUX 2"},{"$f":"$B$7","v":"LIGNY CHATEL 1"},22,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":14},5,"LIGNY CHATEL 1",13,4,null,null,null,null,null,"CHATEL CENSOIR 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$1","v":"MONETEAU 1"},{"$f":"$B$8","v":"HERY 1"},26,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":10},6,"ANCY LE FRANC 2",13,-44,null,null,null,null,null,"CHATEL CENSOIR 1",22,3,null,null,22,8]
[null,null,"  Match 5 : au 1er nommé le Mardi 23 Mai à 14h30",null,null,null,7,"CHATEL CENSOIR 1",12,-28,null,null,null,null,null,"CHATEL CENSOIR 1",14,1,null,null,14,-8]
[null,null,{"$f":"$B$1","v":"MONETEAU 1"},{"$f":"$B$3","v":"VAUX 2"},18,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":18},8,"HERY 1",9,-112,null,null,null,null,null,"CHATEL CENSOIR 1",14,1,{"$f":"SUM(R16:R22)","v":12},{"$f":"SUM(V16:V22)","v":-28},14,-8]
[null,null,{"$f":"$B$2","v":"CHATEL CENSOIR 1"},{"$f":"$B$6","v":"AVALLON 1"},22,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":14},null,null,null,null,null,null,null,null,null,"HERY 1",10,1,null,null,10,-16]
[null,null,{"$f":"$B$7","v":"LIGNY CHATEL 1"},{"$f":"$B$5","v":"ANCY LE FRANC 2"},24,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":12},null,null,null,null,null,null,null,null,null,"HERY 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$8","v":"HERY 1"},{"$f":"$B$4","v":"STADE AUXERRE 2"},10,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":26},null,null,null,null,null,null,null,null,null,"HERY 1",2,1,null,null,2,-32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",10,1,null,null,10,-16]
[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,"HERY 1",10,1,null,null,10,-16]
[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,"HERY 1",22,3,null,null,22,8]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"HERY 1",0,1,{"$f":"SUM(R23:R29)","v":9},{"$f":"SUM(V23:V29)","v":-112},0,-36]
[null,"Championnat Départemental des Clubs 2023 Vétérans Division 2 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGNY CHATEL 1",18,2,{"$f":"SUM(R30:R36)","v":13},{"$f":"SUM(V30:V36)","v":4},18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",14,1,null,null,14,-8]
[null,null,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",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 1",16,1,{"$f":"SUM(R37:R43)","v":14},{"$f":"SUM(V37:V43)","v":16},16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",22,3,null,null,22,8]
[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",6,1,null,null,6,-24]
[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",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",22,3,{"$f":"SUM(R44:R50)","v":19},{"$f":"SUM(V44:V50)","v":52},22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",4,1,null,null,4,-28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",18,2,null,null,18,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",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 2",36,3,{"$f":"SUM(R51:R57)","v":15},{"$f":"SUM(V51:V57)","v":32},36,36]
[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":"MONETEAU 1"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"VAUX 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":"MONETEAU 1"},{"$f":"$B$2","v":"CHATEL CENSOIR 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"VAUX 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":"D3 Gr Unique","index":4,"n_rows":316,"n_cols":18,"rows_kept":316,"cut":false,"hidden":false,"merged":[[19,10,19,13],[34,1,34,9],[35,1,35,9],[36,1,36,9],[18,2,18,5],[18,6,18,9],[22,1,23,1],[24,2,24,5],[26,6,26,8],[33,1,33,9],[12,2,12,5],[12,6,12,9],[0,2,0,5],[0,6,0,9],[5,10,5,13],[6,2,6,5],[6,6,6,9]]}
[1,"CHARBUY 3","  Match 1 : au 1er nommé le Mardi 28 Mars à 14h30",null,null,null,"  Match 6 : au 1er nommé le Mardi 30 Mai à 14h30"]
[2,"USC SENS 4",{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$8","v":"CHARBUY 4"},26,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":10},{"$f":"$B$7","v":"BLENEAU 1"},{"$f":"$B$1","v":"CHARBUY 3"},24,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":12},null,null,null,null,"AUXERRE","AVALLON 2",20]
[3,"JOIGNY 1",{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$2","v":"USC SENS 4"},24,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":12},{"$f":"$B$2","v":"USC SENS 4"},{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},18,18,null,null,null,null,"AUXERRE","AVALLON 2",""]
[4,"ST MARTIN TERTRE 1",{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},{"$f":"$B$7","v":"BLENEAU 1"},8,28,{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$3","v":"JOIGNY 1"},8,28,null,null,null,null,"AUXERRE","AVALLON 2"]
[5,"VERON 2",{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$6","v":"MIGENNES 3"},32,4,{"$f":"$B$6","v":"MIGENNES 3"},{"$f":"$B$9","v":"AVALLON 2"},34,2,null,null,null,null,"AUXERRE","AVALLON 2",""]
[6,"MIGENNES 3",{"$f":"$B$10","v":"ST FLORENTIN 3"},{"$f":"$B$9","v":"AVALLON 2"},16,20,{"$f":"$B$10","v":"ST FLORENTIN 3"},{"$f":"$B$8","v":"CHARBUY 4"},16,20,"Classement",null,null,null,"AUXERRE","AVALLON 2"]
[7,"BLENEAU 1","  Match 2 : au 1er nommé le Mardi 11 Avril à 14h30",null,null,null,"  Match 7 : au 1er nommé le Mardi 06 Juin à 14h30",null,null,null,null,null,"Pts","+/-","AUXERRE","AVALLON 2","","changement de division"]
[8,"CHARBUY 4",{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$1","v":"CHARBUY 3"},34,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":2},{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$9","v":"AVALLON 2"},16,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":20},1,"JOIGNY 1",60,172,"AUXERRE","AVALLON 2","","monte"]
[9,"AVALLON 2",{"$f":"$B$6","v":"MIGENNES 3"},{"$f":"$B$10","v":"ST FLORENTIN 3"},16,20,{"$f":"$B$2","v":"USC SENS 4"},{"$f":"$B$6","v":"MIGENNES 3"},20,16,2,"BLENEAU 1",23,64,"AVALLON","BLENEAU 1",28,"monte"]
[10,"ST FLORENTIN 3",{"$f":"$B$7","v":"BLENEAU 1"},{"$f":"$B$5","v":"VERON 2"},24,12,{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},{"$f":"$B$3","v":"JOIGNY 1"},16,20,3,"CHARBUY 3",21,16,"AVALLON","BLENEAU 1",null,"monte"]
[null,null,{"$f":"$B$8","v":"CHARBUY 4"},{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},14,22,{"$f":"$B$8","v":"CHARBUY 4"},{"$f":"$B$7","v":"BLENEAU 1"},8,28,4,"AVALLON 2",21,14,"AVALLON","BLENEAU 1"]
[null,null,{"$f":"$B$2","v":"USC SENS 4"},{"$f":"$B$9","v":"AVALLON 2"},16,20,{"$f":"$B$10","v":"ST FLORENTIN 3"},{"$f":"$B$5","v":"VERON 2"},0,36,5,"VERON 2",21,7,"AVALLON","BLENEAU 1",""]
["Rappel:",null,"  Match 3 : au 1er nommé le Mardi 25 Avril à 14h30",null,null,null,"  Match 8 : au 1er nommé le Mardi 20 Juin à 14h30",null,null,null,6,"USC SENS 4",16,6,"AVALLON","BLENEAU 1",""]
["Seules les Cases Blanches",null,{"$f":"$B$8","v":"CHARBUY 4"},{"$f":"$B$3","v":"JOIGNY 1"},6,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":30},{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},22,{"$f":"IF(I14=\"\",\"\",IF(I14=\"F\",\"G\",IF(I14=\"G\",\"F\",36-I14)))","v":14},7,"MIGENNES 3",15,-28,"AVALLON","BLENEAU 1"]
["sont à remplir",null,{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$2","v":"USC SENS 4"},20,16,{"$f":"$B$6","v":"MIGENNES 3"},{"$f":"$B$8","v":"CHARBUY 4"},14,22,8,"CHARBUY 4",13,-136,"AVALLON","BLENEAU 1",""]
[null,null,{"$f":"$B$6","v":"MIGENNES 3"},{"$f":"$B$1","v":"CHARBUY 3"},10,26,{"$f":"$B$7","v":"BLENEAU 1"},{"$f":"$B$2","v":"USC SENS 4"},24,12,9,"ST FLORENTIN 3",13,-100,"JOIGNY","CHARBUY 3",26]
[null,null,{"$f":"$B$7","v":"BLENEAU 1"},{"$f":"$B$10","v":"ST FLORENTIN 3"},26,10,{"$f":"$B$9","v":"AVALLON 2"},{"$f":"$B$3","v":"JOIGNY 1"},6,30,10,"ST MARTIN TERTRE 1",12,-64,"JOIGNY","CHARBUY 3",""]
[null,null,{"$f":"$B$9","v":"AVALLON 2"},{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},26,10,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$10","v":"ST FLORENTIN 3"},20,16,null,null,null,null,"JOIGNY","CHARBUY 3",""]
[null,null,"  Match 4 : au 1er nommé le Mardi 09 Mai à 14h30",null,null,null,"  Match 9 : au 1er nommé le Mardi 27 Juin à 14h30",null,null,null,null,null,null,null,"JOIGNY","CHARBUY 3"]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$5","v":"VERON 2"},22,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":14},{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$10","v":"ST FLORENTIN 3"},34,{"$f":"IF(I20=\"\",\"\",IF(I20=\"F\",\"G\",IF(I20=\"G\",\"F\",36-I20)))","v":2},"MINI CLASSEMENT ENTRE LES 3 EQUIPES A EGALITÉES",null,null,null,"JOIGNY","CHARBUY 3"]
[null,null,{"$f":"$B$2","v":"USC SENS 4"},{"$f":"$B$10","v":"ST FLORENTIN 3"},24,12,{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},{"$f":"$B$1","v":"CHARBUY 3"},14,22,3,"CHARBUY 3",4,4,"JOIGNY","CHARBUY 3",""]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$7","v":"BLENEAU 1"},32,4,{"$f":"$B$6","v":"MIGENNES 3"},{"$f":"$B$7","v":"BLENEAU 1"},16,20,4,"AVALLON 2",4,0,"JOIGNY","CHARBUY 3"]
[null,null,{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},{"$f":"$B$6","v":"MIGENNES 3"},12,24,{"$f":"$B$8","v":"CHARBUY 4"},{"$f":"$B$2","v":"USC SENS 4"},0,36,5,"VERON 2",4,-4,"MIGENNES","CHARBUY 4",10]
[null,null,{"$f":"$B$8","v":"CHARBUY 4"},{"$f":"$B$9","v":"AVALLON 2"},6,30,{"$f":"$B$9","v":"AVALLON 2"},{"$f":"$B$5","v":"VERON 2"},16,20,null,null,null,null,"MIGENNES","CHARBUY 4"]
[null,null,"  Match 5 : au 1er nommé le Mardi 23 Mai à 14h30",null,null,null,null,null,null,null,null,null,null,null,"MIGENNES","CHARBUY 4"]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"USC SENS 4"},24,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":12},null,null,null,null,null,null,null,null,"MIGENNES","CHARBUY 4"]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},{"$f":"$B$6","v":"MIGENNES 3"},16,20,null,null,null,null,null,null,null,null,"MIGENNES","CHARBUY 4",""]
[null,null,{"$f":"$B$10","v":"ST FLORENTIN 3"},{"$f":"$B$4","v":"ST MARTIN TERTRE 1"},20,16,null,null,null,null,null,null,null,null,"MIGENNES","CHARBUY 4",""]
[null,null,{"$f":"$B$5","v":"VERON 2"},{"$f":"$B$8","v":"CHARBUY 4"},28,8,null,null,null,null,null,null,null,null,"MIGENNES","CHARBUY 4"]
[null,null,{"$f":"$B$9","v":"AVALLON 2"},{"$f":"$B$7","v":"BLENEAU 1"},22,14,null,null,null,null,null,null,null,null,"SENAN","JOIGNY 1",24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN","JOIGNY 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN","JOIGNY 1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN","JOIGNY 1"]
[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,"SENAN","JOIGNY 1"]
[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,"SENAN","JOIGNY 1",""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,"SENAN","JOIGNY 1",""]
[null,"Championnat Départemental des Clubs 2023 VETERAN Division 3 Groupe Unique",null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENS","MIGENNES 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN","ST FLORENTIN 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO","ST MARTIN TERTRE 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","USC SENS 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","VERON 2",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 20 à 4 : il faut mettre 20 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 20 ici"]
[]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"USC SENS 4"},null,{"$f":"IF(E294=\"\",\"\",IF(E294=\"F\",\"G\",IF(E294=\"G\",\"F\",36-E294)))","v":""}]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E295=\"\",\"\",IF(E295=\"F\",\"G\",IF(E295=\"G\",\"F\",36-E295)))","v":""}]
[]
[null,null,"Essayez : Tapez 6 ici"]
[]
[null,"L' équipe 4 Gagne par 18 à 6 : il faut mettre 6 pour le score de L'équipe 3 contre l'équipe 2 (18  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":"USC SENS 4"},null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[null,null,{"$f":"$B$3","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E308=\"\",\"\",IF(E308=\"F\",\"G\",IF(E308=\"G\",\"F\",36-E308)))","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 13 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"classement D1 Gr A et B","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Classement Final 2023",null,"Changements de \ndivision"]
[1,"STADE AUXERRE 1","Qualifié pour le tournoi\nCRC V Bourgogne FC"]
[2,"PARON 1"]
[3,"STADE DE SENS 1"]
[4,"ST FLORENTIN 1"]
[5,"USC SENS 3"]
[6,"VAUX 1"]
[7,"APPOIGNY 1"]
[8,"USC SENS 1"]
[9,"MIGENNES 1"]
[10,"ANCY LE FRANC 1"]
[11,"RAVIERES 1"]
[12,"SENAN 1"]
[13,"USC SENS 2"]
[14,"PONT / YONNE 1","descente en CDC V  D2"]
[15,"CHARBUY 1","descente en CDC V  D2"]
[16,"AILLANT 1","descente en CDC V  D2"]

{"sheet":"classement D2 Gr A et B","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Classement Final 2023",null,"Changements \nde division"]
[1,"STADE AUXERRE 2","monte en CDC V D1"]
[2,"VERON 1","monte en CDC V D1"]
[3,"AVALLON 1","monte en CDC V D1"]
[4,"MONETEAU 2"]
[5,"VAUX 2"]
[6,"CHARBUY 2"]
[7,"APPOIGNY 2"]
[8,"MONETEAU 1"]
[9,"LIGNY CHATEL 1"]
[9,"ST FLORENTIN 2"]
[11,"ANCY LE FRANC 2"]
[12,"STADE DE SENS 2"]
[13,"CHATEL CENSOIR 1"]
[14,"SENAN 2","descente en CDC V D3"]
[15,"HERY 1","descente en CDC V D3"]
[16,"MIGENNES 2","descente en CDC V D3"]