{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DIV 3 Gr A","DIV 3 Gr B"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"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":"DIV 3 Gr A","index":0,"n_rows":331,"n_cols":22,"rows_kept":331,"cut":false,"hidden":false,"merged":[[1,0,1,9],[13,2,13,5],[8,2,8,5],[3,2,3,5],[8,6,8,9],[3,6,3,9],[13,6,13,9],[15,6,15,9],[16,6,16,7],[29,1,29,10],[30,1,30,10],[23,2,23,5],[18,2,18,5],[21,11,22,11],[17,11,18,11],[19,11,20,11],[31,1,31,10],[32,1,32,10]]}
[]
["CDC OPEN D3 2024 Groupe A"]
[]
[1,"EXEMPT","Match 1: à COURLON - Dimanche 01 Septembre à 8H30",null,null,null,"Match 6: à SENAN - Dimanche 06 Octobre à 14H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"COURLON 1",{"$f":"$B$4","v":"EXEMPT"},{"$f":"$B$5","v":"COURLON 1"},"F",{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":"G"},{"$f":"$B$4","v":"EXEMPT"},{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},null,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":""},null,null,null,null,null,"CHAMPIGNY 1",26,{"$f":"IF(Q5=\"\",\"\",IF(Q5=\"F\",0,IF(Q5=18,2,IF(Q5>18,3,1))))","v":3},null,null,{"$f":"IF(Q5=\"G\",19,IF(Q5=\"\",0,Q5))","v":26},{"$f":"IF(Q5=\"\",\"\",IF(U5=36,36,IF(U5=0,-36,IF(U5=19,19,IF(U5=\"f\",-19,U5-(36-U5))))))","v":16}]
[3,"CHAMPIGNY 1",{"$f":"$B$6","v":"CHAMPIGNY 1"},{"$f":"$B$7","v":"ST FLORENTIN 3"},26,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":10},{"$f":"$B$6","v":"CHAMPIGNY 1"},{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},null,{"$f":"IF(I6=\"\",\"\",IF(I6=\"F\",\"G\",IF(I6=\"G\",\"F\",36-I6)))","v":""},null,null,null,null,null,"CHAMPIGNY 1",24,3,null,null,{"$f":"IF(Q6=\"G\",19,IF(Q6=\"\",0,Q6))","v":24},{"$f":"IF(Q6=\"\",\"\",IF(U6=36,36,IF(U6=0,-36,IF(U6=19,19,IF(U6=\"f\",-19,U6-(36-U6))))))","v":12}]
[4,"ST FLORENTIN 3",{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},12,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":24},{"$f":"$B$10","v":"SENAN 3"},{"$f":"$B$7","v":"ST FLORENTIN 3"},null,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":""},null,null,null,null,null,"CHAMPIGNY 1","","",null,null,0,""]
[5,"VILLENEUVE PETANQUE 1",{"$f":"$B$10","v":"SENAN 3"},{"$f":"$B$11","v":"MIGENNES 3"},28,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":8},{"$f":"$B$11","v":"MIGENNES 3"},{"$f":"$B$5","v":"COURLON 1"},null,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":""},null,null,null,null,null,"CHAMPIGNY 1",null,"",null,null,0,""]
[6,"ST MARTIN DU TERTRE 1","Match 2: à COURLON - Dimanche 01 Septembre à 14h00",null,null,null,"Match 7 et Finale: à MIGENNES - Dimanche 20 Octobre à 8H30",null,null,null,null,null,null,null,null,"CHAMPIGNY 1","","",null,null,0,""]
[7,"SENAN 3",{"$f":"$B$7","v":"ST FLORENTIN 3"},{"$f":"$B$4","v":"EXEMPT"},"G",{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":"F"},{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},{"$f":"$B$10","v":"SENAN 3"},null,{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":""},null,null,null,null,null,"CHAMPIGNY 1",null,"",null,null,0,""]
[8,"MIGENNES 3",{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},{"$f":"$B$6","v":"CHAMPIGNY 1"},12,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":24},{"$f":"$B$7","v":"ST FLORENTIN 3"},{"$f":"$B$5","v":"COURLON 1"},null,{"$f":"IF(I11=\"\",\"\",IF(I11=\"F\",\"G\",IF(I11=\"G\",\"F\",36-I11)))","v":""},null,null,null,null,null,"CHAMPIGNY 1",null,"",{"$f":"SUM(R5:R11)","v":6},{"$f":"SUM(V5:V11)","v":28},0,""]
[null,null,{"$f":"$B$5","v":"COURLON 1"},{"$f":"$B$10","v":"SENAN 3"},8,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":28},{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},{"$f":"$B$4","v":"EXEMPT"},null,{"$f":"IF(I12=\"\",\"\",IF(I12=\"F\",\"G\",IF(I12=\"G\",\"F\",36-I12)))","v":""},null,null,null,null,null,"COURLON 1","G",3,null,null,19,19]
[null,null,{"$f":"$B$11","v":"MIGENNES 3"},{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},10,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",36-E13)))","v":26},{"$f":"$B$6","v":"CHAMPIGNY 1"},{"$f":"$B$11","v":"MIGENNES 3"},null,{"$f":"IF(I13=\"\",\"\",IF(I13=\"F\",\"G\",IF(I13=\"G\",\"F\",36-I13)))","v":""},null,null,null,null,null,"COURLON 1",8,1,null,null,8,-20]
["Rappel:",null,"Match 3: à CHAMPIGNY - Dimanche 08 Septembre à 8h30",null,null,null,null,null,null,null,null,null,null,null,null,"COURLON 1",null,"",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$7","v":"ST FLORENTIN 3"},{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},null,null,null,null,null,null,null,null,null,"COURLON 1","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$5","v":"COURLON 1"},{"$f":"$B$6","v":"CHAMPIGNY 1"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},"Classement",null,null,null,null,null,null,null,null,"COURLON 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$10","v":"SENAN 3"},{"$f":"$B$4","v":"EXEMPT"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,"COURLON 1","","",null,null,0,""]
[null,null,{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},{"$f":"$B$11","v":"MIGENNES 3"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},1,"SENAN 3",6,40,null,null,null,null,null,"COURLON 1","","",{"$f":"SUM(R12:R18)","v":4},{"$f":"SUM(V12:V18)","v":-1},0,""]
[null,null,"Match 4:  à CHAMPIGNY - Dimanche 08 Septembre à 14H00",null,null,null,2,"CHAMPIGNY 1",6,28,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},{"$f":"$B$5","v":"COURLON 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},3,"VILLENEUVE PETANQUE 1",4,4,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},{"$f":"$B$7","v":"ST FLORENTIN 3"},null,{"$f":"IF(E21=\"\",\"\",IF(E21=\"F\",\"G\",IF(E21=\"G\",\"F\",36-E21)))","v":""},4,"ST FLORENTIN 3",4,3,null,null,null,null,null,"EXEMPT","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"CHAMPIGNY 1"},{"$f":"$B$10","v":"SENAN 3"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},5,"ST MARTIN DU TERTRE 1",4,0,null,null,null,null,null,"EXEMPT",null,"",null,null,0,""]
[null,null,{"$f":"$B$4","v":"EXEMPT"},{"$f":"$B$11","v":"MIGENNES 3"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},6,"COURLON 1",4,-1,null,null,null,null,null,"EXEMPT",null,"",null,null,0,""]
[null,null,"Match 5: à SENAN - Dimanche 06 Octobre à 8H30",null,null,null,7,"MIGENNES 3",2,-36,null,null,null,null,null,"EXEMPT",null,"",null,null,0,""]
[null,null,{"$f":"$B$4","v":"EXEMPT"},{"$f":"$B$6","v":"CHAMPIGNY 1"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},8,"EXEMPT",0,-38,null,null,null,null,null,"EXEMPT","","",{"$f":"SUM(R19:R25)","v":0},{"$f":"SUM(V19:V25)","v":-38},0,""]
[null,null,{"$f":"$B$5","v":"COURLON 1"},{"$f":"$B$9","v":"ST MARTIN DU TERTRE 1"},null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3",8,1,null,null,8,-20]
[null,null,{"$f":"$B$10","v":"SENAN 3"},{"$f":"$B$8","v":"VILLENEUVE PETANQUE 1"},null,{"$f":"IF(E27=\"\",\"\",IF(E27=\"F\",\"G\",IF(E27=\"G\",\"F\",36-E27)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3",10,1,null,null,10,-16]
[null,null,{"$f":"$B$11","v":"MIGENNES 3"},{"$f":"$B$7","v":"ST FLORENTIN 3"},null,{"$f":"IF(E28=\"\",\"\",IF(E28=\"F\",\"G\",IF(E28=\"G\",\"F\",36-E28)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3","","",null,null,0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",null,"",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3","","",{"$f":"SUM(R26:R32)","v":2},{"$f":"SUM(V26:V32)","v":-36},0,""]
[null,"Championnat Départemental des Clubs 2024  Division 4 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3","","",{"$f":"SUM(R33:R39)","v":6},{"$f":"SUM(V33:V39)","v":40},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","G",3,null,null,19,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 3",null,"",{"$f":"SUM(R40:R46)","v":4},{"$f":"SUM(V40:V46)","v":3},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 1",null,"",{"$f":"SUM(R47:R53)","v":4},{"$f":"SUM(V47:V53)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLENEUVE PETANQUE 1",null,"",{"$f":"SUM(R54:R60)","v":4},{"$f":"SUM(V54:V60)","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(U61=0,\"\",IF(U61=19,\"\",U61-(36-U61)))","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$4","v":"EXEMPT"},{"$f":"$B$5","v":"COURLON 1"},null,{"$f":"IF(E309=\"\",\"\",IF(E309=\"F\",\"G\",IF(E309=\"G\",\"F\",36-E309)))","v":""}]
[null,null,{"$f":"$B$6","v":"CHAMPIGNY 1"},"Equipe 4",null,{"$f":"IF(E310=\"\",\"\",IF(E310=\"F\",\"G\",IF(E310=\"G\",\"F\",36-E310)))","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$4","v":"EXEMPT"},{"$f":"$B$5","v":"COURLON 1"},null,{"$f":"IF(E322=\"\",\"\",IF(E322=\"F\",\"G\",IF(E322=\"G\",\"F\",36-E322)))","v":""}]
[null,null,{"$f":"$B$6","v":"CHAMPIGNY 1"},"Equipe 4",null,{"$f":"IF(E323=\"\",\"\",IF(E323=\"F\",\"G\",IF(E323=\"G\",\"F\",36-E323)))","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":"DIV 3 Gr B","index":1,"n_rows":331,"n_cols":22,"rows_kept":331,"cut":false,"hidden":false,"merged":[[1,0,1,9],[32,1,32,10],[15,6,15,9],[16,6,16,7],[29,1,29,10],[30,1,30,10],[18,2,18,5],[23,2,23,5],[20,11,21,11],[13,6,13,9],[3,6,3,9],[8,6,8,9],[31,1,31,10],[3,2,3,5],[8,2,8,5],[13,2,13,5]]}
[]
["CDC OPEN D3 2024 Groupe B"]
[]
[1,"VAUX 3","Match 1: à BLENEAU - Dimanche 01 Septembre à 8H30",null,null,null,"Match 6: à AVALLON - Dimanche 06 Octobre à 14H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"RAVIERES 3",{"$f":"$B$4","v":"VAUX 3"},{"$f":"$B$5","v":"RAVIERES 3"},14,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":22},{"$f":"$B$4","v":"VAUX 3"},{"$f":"$B$9","v":"BLENEAU 1"},null,{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2",22,{"$f":"IF(Q5=\"\",\"\",IF(Q5=\"F\",0,IF(Q5=18,2,IF(Q5>18,3,1))))","v":3},null,null,{"$f":"IF(Q5=\"G\",19,IF(Q5=\"\",0,Q5))","v":22},{"$f":"IF(Q5=\"\",\"\",IF(U5=36,36,IF(U5=0,-36,IF(U5=19,19,IF(U5=\"f\",-19,U5-(36-U5))))))","v":8}]
[3,"ST VINNEMER 1",{"$f":"$B$6","v":"ST VINNEMER 1"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},14,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":22},{"$f":"$B$6","v":"ST VINNEMER 1"},{"$f":"$B$8","v":"MALAY LE GRAND 2"},null,{"$f":"IF(I6=\"\",\"\",IF(I6=\"F\",\"G\",IF(I6=\"G\",\"F\",36-I6)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2",2,1,null,null,2,-32]
[4,"ANCY LE FRANC 2",{"$f":"$B$8","v":"MALAY LE GRAND 2"},{"$f":"$B$9","v":"BLENEAU 1"},16,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":20},{"$f":"$B$10","v":"CHAMPIGNY 2"},{"$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,""]
[5,"MALAY LE GRAND 2",{"$f":"$B$10","v":"CHAMPIGNY 2"},{"$f":"$B$11","v":"AVALLON 3"},4,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":32},{"$f":"$B$11","v":"AVALLON 3"},{"$f":"$B$5","v":"RAVIERES 3"},null,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[6,"BLENEAU 1","Match 2: à BLENEAU - Dimanche 01 Septembre à 14h00",null,null,null,"Match 7 et Finale: à MIGENNES - Dimanche 20 Octobre à 8H30",null,null,null,null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[7,"CHAMPIGNY 2",{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$4","v":"VAUX 3"},2,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":34},{"$f":"$B$9","v":"BLENEAU 1"},{"$f":"$B$10","v":"CHAMPIGNY 2"},null,{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2","","",null,null,0,""]
[8,"AVALLON 3",{"$f":"$B$9","v":"BLENEAU 1"},{"$f":"$B$6","v":"ST VINNEMER 1"},24,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":12},{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$5","v":"RAVIERES 3"},null,{"$f":"IF(I11=\"\",\"\",IF(I11=\"F\",\"G\",IF(I11=\"G\",\"F\",36-I11)))","v":""},null,null,null,null,null,"ANCY LE FRANC 2",null,"",{"$f":"SUM(R5:R11)","v":4},{"$f":"SUM(V5:V11)","v":-24},0,""]
[null,null,{"$f":"$B$5","v":"RAVIERES 3"},{"$f":"$B$10","v":"CHAMPIGNY 2"},26,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":10},{"$f":"$B$8","v":"MALAY LE GRAND 2"},{"$f":"$B$4","v":"VAUX 3"},null,{"$f":"IF(I12=\"\",\"\",IF(I12=\"F\",\"G\",IF(I12=\"G\",\"F\",36-I12)))","v":""},null,null,null,null,null,"AVALLON 3",32,3,null,null,32,28]
[null,null,{"$f":"$B$11","v":"AVALLON 3"},{"$f":"$B$8","v":"MALAY LE GRAND 2"},18,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",36-E13)))","v":18},{"$f":"$B$6","v":"ST VINNEMER 1"},{"$f":"$B$11","v":"AVALLON 3"},null,{"$f":"IF(I13=\"\",\"\",IF(I13=\"F\",\"G\",IF(I13=\"G\",\"F\",36-I13)))","v":""},null,null,null,null,null,"AVALLON 3",18,2,null,null,18,0]
["Rappel:",null,"Match 3: à MALAY LE GRAND - Dimanche 08 Septembre à 8h30",null,null,null,null,null,null,null,null,null,null,null,null,"AVALLON 3","","",null,null,0,""]
["Seules les Cases Blanches",null,{"$f":"$B$7","v":"ANCY LE FRANC 2"},{"$f":"$B$8","v":"MALAY LE GRAND 2"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},null,null,null,null,null,null,null,null,null,"AVALLON 3","","",null,null,0,""]
["sont à remplir",null,{"$f":"$B$5","v":"RAVIERES 3"},{"$f":"$B$6","v":"ST VINNEMER 1"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},"Classement",null,null,null,null,null,null,null,null,"AVALLON 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$10","v":"CHAMPIGNY 2"},{"$f":"$B$4","v":"VAUX 3"},null,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,"AVALLON 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$9","v":"BLENEAU 1"},{"$f":"$B$11","v":"AVALLON 3"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},1,"RAVIERES 3",6,24,null,null,null,null,null,"AVALLON 3","","",{"$f":"SUM(R12:R18)","v":5},{"$f":"SUM(V12:V18)","v":28},0,""]
[null,null,"Match 4:  à MALAY LE GRAND - Dimanche 08 Septembre à 14H00",null,null,null,2,"BLENEAU 1",6,16,null,null,null,null,null,"BLENEAU 1",20,3,null,null,20,4]
[null,null,{"$f":"$B$8","v":"MALAY LE GRAND 2"},{"$f":"$B$5","v":"RAVIERES 3"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},3,"AVALLON 3",5,28,null,null,null,null,null,"BLENEAU 1",24,3,null,null,24,12]
[null,null,{"$f":"$B$9","v":"BLENEAU 1"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},null,{"$f":"IF(E21=\"\",\"\",IF(E21=\"F\",\"G\",IF(E21=\"G\",\"F\",36-E21)))","v":""},4,"VAUX 3",4,24,null,null,null,null,null,"BLENEAU 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$6","v":"ST VINNEMER 1"},{"$f":"$B$10","v":"CHAMPIGNY 2"},null,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":""},5,"ANCY LE FRANC 2",4,-24,null,null,null,null,null,"BLENEAU 1",null,"",null,null,0,""]
[null,null,{"$f":"$B$4","v":"VAUX 3"},{"$f":"$B$11","v":"AVALLON 3"},null,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":""},6,"MALAY LE GRAND 2",3,-4,null,null,null,null,null,"BLENEAU 1","","",null,null,0,""]
[null,null,"Match 5: à AVALLON - Dimanche 06 Octobre à 8H30",null,null,null,7,"ST VINNEMER 1",2,-20,null,null,null,null,null,"BLENEAU 1","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"VAUX 3"},{"$f":"$B$6","v":"ST VINNEMER 1"},null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":""},8,"CHAMPIGNY 2",2,-44,null,null,null,null,null,"BLENEAU 1",null,"",{"$f":"SUM(R19:R25)","v":6},{"$f":"SUM(V19:V25)","v":16},0,""]
[null,null,{"$f":"$B$5","v":"RAVIERES 3"},{"$f":"$B$9","v":"BLENEAU 1"},null,{"$f":"IF(E26=\"\",\"\",IF(E26=\"F\",\"G\",IF(E26=\"G\",\"F\",36-E26)))","v":""},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",4,1,null,null,4,-28]
[null,null,{"$f":"$B$10","v":"CHAMPIGNY 2"},{"$f":"$B$8","v":"MALAY LE GRAND 2"},null,{"$f":"IF(E27=\"\",\"\",IF(E27=\"F\",\"G\",IF(E27=\"G\",\"F\",36-E27)))","v":""},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",10,1,null,null,10,-16]
[null,null,{"$f":"$B$11","v":"AVALLON 3"},{"$f":"$B$7","v":"ANCY LE FRANC 2"},null,{"$f":"IF(E28=\"\",\"\",IF(E28=\"F\",\"G\",IF(E28=\"G\",\"F\",36-E28)))","v":""},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHAMPIGNY 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,"CHAMPIGNY 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,"CHAMPIGNY 2",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2","","",{"$f":"SUM(R26:R32)","v":2},{"$f":"SUM(V26:V32)","v":-44},0,""]
[null,"Championnat Départemental des Clubs 2024 Division 3 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2","",{"$f":"IF(Q37=\"\",\"\",IF(Q37=\"F\",0,IF(Q37=18,2,IF(Q37>18,3,1))))","v":""},null,null,{"$f":"IF(Q37=\"G\",19,IF(Q37=\"\",0,Q37))","v":0},{"$f":"IF(Q37=\"\",\"\",IF(U37=36,36,IF(U37=0,-36,IF(U37=19,19,IF(U37=\"f\",-19,U37-(36-U37))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 2",null,"",{"$f":"SUM(R33:R39)","v":3},{"$f":"SUM(V33:V39)","v":-4},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 3","","",{"$f":"SUM(R40:R46)","v":6},{"$f":"SUM(V40:V46)","v":24},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST VINNEMER 1",null,"",{"$f":"SUM(R47:R53)","v":2},{"$f":"SUM(V47:V53)","v":-20},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",34,3,null,null,34,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",{"$f":"SUM(R54:R60)","v":4},{"$f":"SUM(V54:V60)","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(U61=0,\"\",IF(U61=19,\"\",U61-(36-U61)))","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$4","v":"VAUX 3"},{"$f":"$B$5","v":"RAVIERES 3"},null,{"$f":"IF(E309=\"\",\"\",IF(E309=\"F\",\"G\",IF(E309=\"G\",\"F\",36-E309)))","v":""}]
[null,null,{"$f":"$B$6","v":"ST VINNEMER 1"},"Equipe 4",null,{"$f":"IF(E310=\"\",\"\",IF(E310=\"F\",\"G\",IF(E310=\"G\",\"F\",36-E310)))","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$4","v":"VAUX 3"},{"$f":"$B$5","v":"RAVIERES 3"},null,{"$f":"IF(E322=\"\",\"\",IF(E322=\"F\",\"G\",IF(E322=\"G\",\"F\",36-E322)))","v":""}]
[null,null,{"$f":"$B$6","v":"ST VINNEMER 1"},"Equipe 4",null,{"$f":"IF(E323=\"\",\"\",IF(E323=\"F\",\"G\",IF(E323=\"G\",\"F\",36-E323)))","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"]