{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CDC PROVENÇAL 2023"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"CDC PROVENÇAL 2023","index":0,"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],[26,1,26,10],[27,1,27,10],[15,2,15,5],[20,2,20,5],[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,"MIGENNES 1","  Match 1 : à AVALLON - Lundi 01 Mai à 8H00",null,null,null,"  Match 6 : à ST BRIS - Dimanche 25 Juin à 14H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"MIGENNES 2",{"$f":"$B$1","v":"MIGENNES 1"},{"$f":"$B$2","v":"MIGENNES 2"},18,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",24-E2)))","v":6},{"$f":"$B$1","v":"MIGENNES 1"},{"$f":"$B$6","v":"AVALLON"},4,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",24-I2)))","v":20},null,null,null,null,null,"AVALLON",8,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=12,2,IF(Q2>12,3,1))))","v":1},null,null,{"$f":"IF(Q2=\"G\",24,IF(Q2=\"\",0,Q2))","v":8},{"$f":"IF(Q2=\"\",\"\",IF(U2=24,24,IF(U2=0,-24,IF(U2=12.5,12.5,IF(U2=\"f\",-24,U2-(24-U2))))))","v":-8}]
[3,"STADE AUXERRE",{"$f":"$B$3","v":"STADE AUXERRE"},{"$f":"$B$4","v":"VAUX"},8,16,{"$f":"$B$3","v":"STADE AUXERRE"},{"$f":"$B$5","v":"TONNERRE"},4,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",24-I3)))","v":20},null,null,null,null,null,"AVALLON",6,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=12,2,IF(Q3>12,3,1))))","v":1},null,null,6,-12]
[4,"VAUX",{"$f":"$B$5","v":"TONNERRE"},{"$f":"$B$6","v":"AVALLON"},16,8,{"$f":"$B$7","v":"ST FLORENTIN"},{"$f":"$B$4","v":"VAUX"},10,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",24-I4)))","v":14},null,null,null,null,null,"AVALLON",8,1,null,null,8,-8]
[5,"TONNERRE",{"$f":"$B$7","v":"ST FLORENTIN"},{"$f":"$B$8","v":"JOIGNY"},14,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",24-E5)))","v":10},{"$f":"$B$2","v":"MIGENNES 2"},{"$f":"$B$8","v":"JOIGNY"},0,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",24-I5)))","v":24},null,null,null,null,null,"AVALLON","G",3,null,null,24,24]
[6,"AVALLON","  Match 2 : à AVALLON - Lundi 01 Mai  à 14H00",null,null,null,"  Match 7 : à XXX - Samedi 15 Juillet à 8h00",null,null,null,null,null,null,null,null,"AVALLON",24,3,null,null,24,24]
[7,"ST FLORENTIN",{"$f":"$B$4","v":"VAUX"},{"$f":"$B$1","v":"MIGENNES 1"},9,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",24-E7)))","v":15},{"$f":"$B$6","v":"AVALLON"},{"$f":"$B$7","v":"ST FLORENTIN"},12,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",24-I7)))","v":12},null,null,null,null,null,"AVALLON",20,3,null,null,20,16]
[8,"JOIGNY",{"$f":"$B$6","v":"AVALLON"},{"$f":"$B$3","v":"STADE AUXERRE"},6,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",24-E8)))","v":18},{"$f":"$B$4","v":"VAUX"},{"$f":"$B$2","v":"MIGENNES 2"},"G",{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",24-I8)))","v":"F"},null,null,null,null,null,"AVALLON",12,2,{"$f":"SUM(R2:R8)","v":14},{"$f":"SUM(V2:V8)","v":36},12,0]
[null,null,{"$f":"$B$2","v":"MIGENNES 2"},{"$f":"$B$7","v":"ST FLORENTIN"},10,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",24-E9)))","v":14},{"$f":"$B$5","v":"TONNERRE"},{"$f":"$B$1","v":"MIGENNES 1"},"G",{"$f":"IF(I9=\"\",\"\",IF(I9=\"F\",\"G\",IF(I9=\"G\",\"F\",24-I9)))","v":"F"},null,null,null,null,null,"JOIGNY",10,1,null,null,10,-4]
[null,null,{"$f":"$B$5","v":"TONNERRE"},{"$f":"$B$8","v":"JOIGNY"},8,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",24-E10)))","v":16},{"$f":"$B$3","v":"STADE AUXERRE"},{"$f":"$B$8","v":"JOIGNY"},"F",{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",24-I10)))","v":"G"},null,null,null,null,null,"JOIGNY",16,3,null,null,16,8]
["Rappel:",null,"  Match 3 : à TONNERRE - Dimanche 18 Juin à 8H00",null,null,null,null,null,null,null,null,null,null,null,null,"JOIGNY",16,3,null,null,16,8]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"VAUX"},{"$f":"$B$5","v":"TONNERRE"},"F",{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",24-E12)))","v":"G"},null,null,null,null,null,null,null,null,null,"JOIGNY",18,3,null,null,18,12]
["sont à remplir",null,{"$f":"$B$2","v":"MIGENNES 2"},{"$f":"$B$3","v":"STADE AUXERRE"},0,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",24-E13)))","v":24},"Classement",null,null,null,null,null,null,null,null,"JOIGNY",14,3,null,null,14,4]
[null,null,{"$f":"$B$7","v":"ST FLORENTIN"},{"$f":"$B$1","v":"MIGENNES 1"},10,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",24-E14)))","v":14},null,null,"Pts","+/-",null,null,null,null,null,"JOIGNY",24,3,null,null,24,24]
[null,null,{"$f":"$B$6","v":"AVALLON"},{"$f":"$B$8","v":"JOIGNY"},8,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",24-E15)))","v":16},1,"JOIGNY",19,76,null,null,null,null,null,"JOIGNY","G",3,{"$f":"SUM(R9:R15)","v":19},{"$f":"SUM(V9:V15)","v":76},24,24]
[null,null,"  Match 4 : à TONNERRE - Dimanche 18 Juin à 14H00",null,null,null,2,"TONNERRE",19,92,null,null,null,null,null,"MIGENNES 1",18,3,null,null,18,12]
[null,null,{"$f":"$B$5","v":"TONNERRE"},{"$f":"$B$2","v":"MIGENNES 2"},20,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",24-E17)))","v":4},3,"AVALLON",14,36,null,null,null,null,null,"MIGENNES 1",15,3,null,null,15,6]
[null,null,{"$f":"$B$6","v":"AVALLON"},{"$f":"$B$4","v":"VAUX"},"G",{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",24-E18)))","v":"F"},4,"STADE AUXERRE",13,4,null,null,null,null,null,"MIGENNES 1",14,3,null,null,14,4]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE"},{"$f":"$B$7","v":"ST FLORENTIN"},12,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",24-E19)))","v":12},5,"ST FLORENTIN",13,-12,null,null,null,null,null,"MIGENNES 1",6,1,null,null,6,-12]
[null,null,{"$f":"$B$1","v":"MIGENNES 1"},{"$f":"$B$8","v":"JOIGNY"},6,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",24-E20)))","v":18},6,"MIGENNES 1",12,-46,null,null,null,null,null,"MIGENNES 1",4,1,null,null,4,-16]
[null,null,"  Match 5 : à ST BRIS - Dimanche 25 Juin à 8H00",null,null,null,7,"VAUX",11,-22,null,null,null,null,null,"MIGENNES 1",4,1,null,null,4,-16]
[null,null,{"$f":"$B$1","v":"MIGENNES 1"},{"$f":"$B$3","v":"STADE AUXERRE"},4,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",24-E22)))","v":20},8,"MIGENNES 2",6,-128,null,null,null,null,null,"MIGENNES 1","F",0,{"$f":"SUM(R16:R22)","v":12},{"$f":"SUM(V16:V22)","v":-46},"F",-24]
[null,null,{"$f":"$B$2","v":"MIGENNES 2"},{"$f":"$B$6","v":"AVALLON"},0,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",24-E23)))","v":24},null,null,null,null,null,null,null,null,null,"MIGENNES 2",6,1,null,null,6,-12]
[null,null,{"$f":"$B$7","v":"ST FLORENTIN"},{"$f":"$B$5","v":"TONNERRE"},6,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",24-E24)))","v":18},null,null,null,null,null,null,null,null,null,"MIGENNES 2",10,1,null,null,10,-4]
[null,null,{"$f":"$B$4","v":"VAUX"},{"$f":"$B$8","v":"JOIGNY"},10,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",24-E25)))","v":14},null,null,null,null,null,null,null,null,null,"MIGENNES 2",0,1,null,null,0,-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 2",4,1,null,null,4,-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,"MIGENNES 2",0,1,null,null,0,{"$f":"IF(Q27=\"\",\"\",IF(U27=24,24,IF(U27=0,-24,IF(U27=12.5,12.5,IF(U27=\"f\",-24,U27-(24-U27))))))","v":-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,"MIGENNES 2",0,1,null,null,0,{"$f":"IF(Q28=\"\",\"\",IF(U28=24,24,IF(U28=0,-24,IF(U28=12.5,12.5,IF(U28=\"f\",-24,U28-(24-U28))))))","v":-24}]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 2","F",0,{"$f":"SUM(R23:R29)","v":6},{"$f":"SUM(V23:V29)","v":-128},"F",-24]
[null,"Championnat Départemental des Clubs 2023 Provençal Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",14,3,null,null,14,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",14,3,null,null,14,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",10,1,null,null,10,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",12,2,null,null,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",6,1,null,null,6,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",10,1,null,null,10,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN",12,2,{"$f":"SUM(R30:R36)","v":13},{"$f":"SUM(V30:V36)","v":-12},12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",8,1,null,null,8,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",18,3,null,null,18,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",24,3,null,null,24,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",12,2,null,null,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",20,3,null,null,20,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE",4,1,null,null,4,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE","F",0,{"$f":"SUM(R37:R43)","v":13},{"$f":"SUM(V37:V43)","v":4},"F",-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE",16,3,null,null,16,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE",8,1,null,null,8,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","G",3,null,null,24,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE",20,3,null,null,20,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE",18,3,null,null,{"$f":"IF(Q48=\"G\",24,IF(Q48=\"\",0,Q48))","v":18},12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE",20,3,null,null,{"$f":"IF(Q49=\"G\",24,IF(Q49=\"\",0,Q49))","v":20},16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TONNERRE","G",3,{"$f":"SUM(R44:R50)","v":19},{"$f":"SUM(V44:V50)","v":92},24,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX",16,3,null,null,16,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX",9,1,null,null,9,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","F",0,null,null,"F",-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","F",0,null,null,"F",-24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX",10,1,null,null,10,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX",14,3,null,null,14,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX","G",3,{"$f":"SUM(R51:R57)","v":11},{"$f":"SUM(V51:V57)","v":-22},24,24]
[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 1"},{"$f":"$B$2","v":"MIGENNES 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE"},"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 1"},{"$f":"$B$2","v":"MIGENNES 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE"},"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"]