{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DIV 1F Gr Unique","DIV 2F GrA","DIV 2F GrB"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"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 1F Gr Unique","index":0,"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,"STADE DE SENS 1","Match 1: à PARON - Dimanche 21 Mai à 8H30 ",null,null,null,"Match 6: à AILLANT - Dimanche 08 Octobre à 14H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"STADE DE SENS 2",{"$f":"$B$1","v":"STADE DE SENS 1"},{"$f":"$B$2","v":"STADE DE SENS 2"},11,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",12-E2)))","v":1},{"$f":"$B$1","v":"STADE DE SENS 1"},{"$f":"$B$6","v":"CHARBUY 1"},6,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",12-I2)))","v":6},null,null,null,null,null,"AILLANT - MONETEAU 1","F",{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=6,2,IF(Q2>7,3,1))))","v":0},null,null,{"$f":"IF(Q2=\"G\",7,IF(Q2=\"\",0,Q2))","v":"F"},{"$f":"IF(Q2=\"\",\"\",IF(U2=12,12,IF(U2=0,-12,IF(U2=7,7,IF(U2=\"f\",-7,U2-(12-U2))))))","v":-7}]
[3,"AILLANT - MONETEAU 1",{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},{"$f":"$B$4","v":"USC SENS 1"},"F",{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",12-E3)))","v":"G"},{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},{"$f":"$B$5","v":"PARON 1"},11,1,null,null,null,null,null,"AILLANT - MONETEAU 1","F",0,null,null,{"$f":"IF(Q3=\"G\",7,IF(Q3=\"\",0,Q3))","v":"F"},{"$f":"IF(Q3=\"\",\"\",IF(U3=12,12,IF(U3=0,-12,IF(U3=7,7,IF(U3=\"f\",-7,U3-(12-U3))))))","v":-7}]
[4,"USC SENS 1",{"$f":"$B$5","v":"PARON 1"},{"$f":"$B$6","v":"CHARBUY 1"},9,3,{"$f":"$B$7","v":"VAUX 1"},{"$f":"$B$4","v":"USC SENS 1"},9,3,null,null,null,null,null,"AILLANT - MONETEAU 1",9,3,null,null,9,6]
[5,"PARON 1",{"$f":"$B$7","v":"VAUX 1"},{"$f":"$B$8","v":"STADE AUXERRE 2"},5,7,{"$f":"$B$8","v":"STADE AUXERRE 2"},{"$f":"$B$2","v":"STADE DE SENS 2"},5,7,null,null,null,null,null,"AILLANT - MONETEAU 1",8,3,null,null,8,4]
[6,"CHARBUY 1","Match 2: à PARON - Dimanche 21 Mai à 14H00 ",null,null,null,"Match 7 : à ST FLORENTIN - Dimanche 22 octobre à 14H00",null,null,null,null,null,null,null,null,"AILLANT - MONETEAU 1","","",null,null,0,""]
[7,"VAUX 1",{"$f":"$B$4","v":"USC SENS 1"},{"$f":"$B$1","v":"STADE DE SENS 1"},1,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",12-E7)))","v":11},{"$f":"$B$6","v":"CHARBUY 1"},{"$f":"$B$7","v":"VAUX 1"},4,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",12-I7)))","v":8},null,null,null,null,null,"AILLANT - MONETEAU 1",null,"",null,null,0,""]
[8,"STADE AUXERRE 2",{"$f":"$B$6","v":"CHARBUY 1"},{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},"G","F",{"$f":"$B$4","v":"USC SENS 1"},{"$f":"$B$2","v":"STADE DE SENS 2"},3,9,null,null,null,null,null,"AILLANT - MONETEAU 1",null,{"$f":"IF(Q8=\"\",\"\",IF(Q8=\"F\",0,IF(Q8=6,2,IF(Q8>7,3,1))))","v":""},{"$f":"SUM(R2:R8)","v":6},{"$f":"SUM(V2:V8)","v":-4},0,""]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$7","v":"VAUX 1"},8,4,{"$f":"$B$5","v":"PARON 1"},{"$f":"$B$1","v":"STADE DE SENS 1"},8,4,null,null,null,null,null,"CHARBUY 1",3,1,null,null,3,-6]
[null,null,{"$f":"$B$8","v":"STADE AUXERRE 2"},{"$f":"$B$5","v":"PARON 1"},10,2,{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},{"$f":"$B$8","v":"STADE AUXERRE 2"},6,6,null,null,null,null,null,"CHARBUY 1","G",3,null,null,7,7]
["Rappel:",null,"Match 3: à AILLANT - Dimanche 17 Septembre à 8H30 ",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 1",5,1,null,null,5,-2]
["Seules les Cases Blanches",null,{"$f":"$B$4","v":"USC SENS 1"},{"$f":"$B$5","v":"PARON 1"},2,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",12-E12)))","v":10},null,null,null,null,null,null,null,null,null,"CHARBUY 1",7,1,null,null,7,7]
["sont à remplir",null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},3,9,"Classement",null,null,null,null,null,null,null,null,"CHARBUY 1","","",null,null,0,""]
[null,null,{"$f":"$B$7","v":"VAUX 1"},{"$f":"$B$1","v":"STADE DE SENS 1"},3,9,null,null,"Pts","+/-",null,null,null,null,null,"CHARBUY 1","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"CHARBUY 1"},{"$f":"$B$8","v":"STADE AUXERRE 2"},5,7,1,"STADE AUXERRE 2",16,26]
[null,null,"Match 4: à AILLANT - Dimanche 17 Septembre à 14H00 ",null,null,null,2,"STADE DE SENS 1",13,10]
[null,null,{"$f":"$B$5","v":"PARON 1"},{"$f":"$B$2","v":"STADE DE SENS 2"},6,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",12-E17)))","v":6},3,"CHARBUY 1",13,3]
[null,null,{"$f":"$B$6","v":"CHARBUY 1"},{"$f":"$B$4","v":"USC SENS 1"},7,5,4,"AILLANT - MONETEAU 1",12,16]
[null,null,{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},{"$f":"$B$7","v":"VAUX 1"},8,4,5,"PARON 1",11,-6]
[null,null,{"$f":"$B$1","v":"STADE DE SENS 1"},{"$f":"$B$8","v":"STADE AUXERRE 2"},3,9,6,"STADE DE SENS 2",11,-12]
[null,null,"Match 5: à AILLANT - Dimanche 08 Octobre à 8H30",null,null,null,7,"VAUX 1",10,-8]
[null,null,{"$f":"$B$1","v":"STADE DE SENS 1"},{"$f":"$B$3","v":"AILLANT - MONETEAU 1"},1,11,8,"USC SENS 1",8,-29]
[null,null,{"$f":"$B$2","v":"STADE DE SENS 2"},{"$f":"$B$6","v":"CHARBUY 1"},5,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",12-E23)))","v":7},null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",7,1,null,null,7,7]
[null,null,{"$f":"$B$7","v":"VAUX 1"},{"$f":"$B$5","v":"PARON 1"},7,5,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",10,3,null,null,10,8]
[null,null,{"$f":"$B$8","v":"STADE AUXERRE 2"},{"$f":"$B$4","v":"USC SENS 1"},11,1,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",7,1,null,null,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2",9,3,null,null,9,6]
[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,"STADE AUXERRE 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,"STADE AUXERRE 2",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 2","","",{"$f":"SUM(R23:R29)","v":8},{"$f":"SUM(V23:V29)","v":28},0,""]
[null,"Championnat Départemental des Clubs 2023 FEMININ  Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",11,3,null,null,11,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",11,3,null,null,11,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",9,3,null,null,9,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",3,1,null,null,3,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 1","","",{"$f":"SUM(R30:R36)","v":10},{"$f":"SUM(V30:V36)","v":20},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",1,1,null,null,1,-10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",8,3,null,null,8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",3,1,null,null,3,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",6,2,null,null,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE DE SENS 2","","",{"$f":"SUM(R37:R43)","v":7},{"$f":"SUM(V37:V43)","v":-12},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1","G",3,null,null,7,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",1,1,null,null,1,-10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",2,1,null,null,2,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",5,1,null,null,5,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 1",null,"",{"$f":"SUM(R44:R50)","v":6},{"$f":"SUM(V44:V50)","v":-13},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",5,1,null,null,5,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",4,1,null,null,4,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",3,1,null,null,3,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",4,1,null,null,4,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 1","","",{"$f":"SUM(R51:R57)","v":4},{"$f":"SUM(V51:V57)","v":-16},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"STADE DE SENS 1"},{"$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":"AILLANT - MONETEAU 1"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"STADE DE SENS 1"},{"$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":"AILLANT - MONETEAU 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":"DIV 2F GrA","index":1,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[29,1,29,10],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[12,2,12,5],[12,6,12,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10],[28,1,28,10]]}
[1,"USC SENS 2","  Match 1 : à  APPOIGNY - Dimanche 24 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"SENAN 1",{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$2","v":"SENAN 1"},5,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",12-E2)))","v":7},null,null,null,null,null,null,null,null,null,"APPOIGNY 2",8,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=6,2,IF(Q2>6,3,1))))","v":3},null,null,{"$f":"IF(Q2=\"G\",6.5,IF(Q2=\"\",0,Q2))","v":8},{"$f":"IF(Q2=\"\",\"\",IF(U2=12,12,IF(U2=0,-12,IF(U2=6.5,6.5,IF(U2=\"f\",-6.5,U2-(12-U2))))))","v":4}]
[3,"VERON 1",{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$4","v":"MIGENNES 1"},4,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",12-E3)))","v":8},null,null,null,null,null,null,null,null,null,"APPOIGNY 2",3,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=6,2,IF(Q3>6,3,1))))","v":1},null,null,{"$f":"IF(Q3=\"G\",6.5,IF(Q3=\"\",0,Q3))","v":3},{"$f":"IF(Q3=\"\",\"\",IF(U3=12,12,IF(U3=0,-12,IF(U3=6.5,6.5,IF(U3=\"f\",-6.5,U3-(12-U3))))))","v":-6}]
[4,"MIGENNES 1",{"$f":"$B$5","v":"APPOIGNY 2"},{"$f":"$B$6","v":"ST MARTIN TERTRE 1"},8,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",12-E4)))","v":4},null,null,null,null,null,null,null,null,null,"APPOIGNY 2",5,1,null,null,5,-2]
[5,"APPOIGNY 2","  Match 2 : à  APPOIGNY - Dimanche 24 Septembre à 14H00",null,null,null,null,null,null,null,null,null,null,null,null,"APPOIGNY 2",11,3,null,null,11,10]
[6,"ST MARTIN TERTRE 1",{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$3","v":"VERON 1"},4,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",12-E6)))","v":8},null,null,null,null,null,null,null,null,null,"APPOIGNY 2","","",{"$f":"SUM(R2:R6)","v":8},{"$f":"SUM(V2:V6)","v":6},0,""]
[null,null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$5","v":"APPOIGNY 2"},9,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",12-E7)))","v":3},null,null,null,null,null,null,null,null,null,"MIGENNES 1",8,3,null,null,8,4]
[null,null,{"$f":"$B$4","v":"MIGENNES 1"},{"$f":"$B$6","v":"ST MARTIN TERTRE 1"},9,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",12-E8)))","v":3},null,null,null,null,null,null,null,null,null,"MIGENNES 1",9,3,null,null,9,6]
[null,null,"  Match 3 : à MIGENNES - Dimanche 08 Octobre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 1",5,1,null,null,5,-2]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$4","v":"MIGENNES 1"},7,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",12-E10)))","v":5},null,null,null,null,null,null,null,null,null,"MIGENNES 1",7,3,null,null,7,2]
["Rappel:",null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$6","v":"ST MARTIN TERTRE 1"},6,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",12-E11)))","v":6},null,null,null,null,null,null,null,null,null,"MIGENNES 1",null,"",{"$f":"SUM(R7:R11)","v":10},{"$f":"SUM(V7:V11)","v":10},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$5","v":"APPOIGNY 2"},7,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",12-E12)))","v":5},null,null,null,null,null,null,null,null,null,"SENAN 1",7,3,null,null,7,2]
["sont à remplir",null,"  Match 4 : à  MIGENNES - Dimanche 08 Octobre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"SENAN 1",9,3,null,null,9,6]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$5","v":"APPOIGNY 2"},1,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",12-E14)))","v":11},null,null,"Pts","+/-",null,null,null,null,null,"SENAN 1",6,2,null,null,6,0]
[null,null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$4","v":"MIGENNES 1"},5,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",12-E15)))","v":7},1,"MIGENNES 1",10,10,null,null,null,null,null,"SENAN 1",5,1,null,null,5,-2]
[null,null,{"$f":"$B$3","v":"VERON 1"},{"$f":"$B$6","v":"ST MARTIN TERTRE 1"},4,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",12-E16)))","v":8},2,"SENAN 1",9,6,null,null,null,null,null,"SENAN 1",null,"",{"$f":"SUM(R12:R16)","v":9},{"$f":"SUM(V12:V16)","v":6},0,""]
[null,null,"  Match 5 et finale : à ST FLORENTIN - Dimanche 22 Octobre à 8H30",null,null,null,3,"APPOIGNY 2",8,6,null,null,null,null,null,"ST MARTIN TERTRE 1",4,1,null,null,4,-4]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$6","v":"ST MARTIN TERTRE 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",12-E18)))","v":""},4,"VERON 1",8,-2,null,null,null,null,null,"ST MARTIN TERTRE 1",3,1,null,null,3,-6]
[null,null,{"$f":"$B$2","v":"SENAN 1"},{"$f":"$B$3","v":"VERON 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",12-E19)))","v":""},5,"ST MARTIN TERTRE 1",7,-6,null,null,null,null,null,"ST MARTIN TERTRE 1",6,2,null,null,6,0]
[null,null,{"$f":"$B$4","v":"MIGENNES 1"},{"$f":"$B$5","v":"APPOIGNY 2"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",12-E20)))","v":""},6,"USC SENS 2",6,-14,null,null,null,null,null,"ST MARTIN TERTRE 1",8,3,null,null,8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 1","","",{"$f":"SUM(R17:R21)","v":7},{"$f":"SUM(V17:V21)","v":-6},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",5,1,null,null,5,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",4,1,null,null,4,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",7,3,null,null,7,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",1,1,null,null,1,-10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USC SENS 2",null,"",{"$f":"SUM(R22:R26)","v":6},{"$f":"SUM(V22:V26)","v":-14},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,"VERON 1",4,1,null,null,4,-4]
[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,"VERON 1",8,3,null,null,8,4]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",7,3,null,null,7,2]
[null,"Championnat Départemental des Clubs 2023 FEMININ Division 2 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1",4,1,null,null,4,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 1","","",{"$f":"SUM(R27:R31)","v":8},{"$f":"SUM(V27:V31)","v":-2},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q32=\"\",\"\",IF(U32=36,36,IF(U32=0,-36,IF(U32=19,19,IF(U32=\"f\",-19,U32-(36-U32))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"USC SENS 2"},{"$f":"$B$2","v":"SENAN 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"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":"USC SENS 2"},{"$f":"$B$2","v":"SENAN 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"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":"DIV 2F GrB","index":2,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[29,1,29,10],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[12,2,12,5],[12,6,12,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10],[28,1,28,10]]}
[1,"APPOIGNY 1","  Match 1 : à APPOIGNY - Dimanche 17 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"ST FLORENTIN 1",{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$2","v":"ST FLORENTIN 1"},8,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",12-E2)))","v":4},null,null,null,null,null,null,null,null,null,"APPOIGNY 1",8,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=6,2,IF(Q2>6,3,1))))","v":3},null,null,{"$f":"IF(Q2=\"G\",6.5,IF(Q2=\"\",0,Q2))","v":8},{"$f":"IF(Q2=\"\",\"\",IF(U2=12,12,IF(U2=0,-12,IF(U2=6.5,6.5,IF(U2=\"f\",-6.5,U2-(12-U2))))))","v":4}]
[3,"STADE AUXERRE 3",{"$f":"$B$3","v":"STADE AUXERRE 3"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},10,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",12-E3)))","v":2},null,null,null,null,null,null,null,null,null,"APPOIGNY 1",2,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=6,2,IF(Q3>6,3,1))))","v":1},null,null,{"$f":"IF(Q3=\"G\",6.5,IF(Q3=\"\",0,Q3))","v":2},{"$f":"IF(Q3=\"\",\"\",IF(U3=12,12,IF(U3=0,-12,IF(U3=6.5,6.5,IF(U3=\"f\",-6.5,U3-(12-U3))))))","v":-8}]
[4,"CHATEL CENSOIR 1",{"$f":"$B$5","v":"RAVIERES 1"},{"$f":"$B$6","v":"HERY / LIGNY 1"},6,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",12-E4)))","v":6},null,null,null,null,null,null,null,null,null,"APPOIGNY 1",11,3,null,null,11,10]
[5,"RAVIERES 1","  Match 2 : à APPOIGNY - Dimanche 17 Septembre à 14H00",null,null,null,null,null,null,null,null,null,null,null,null,"APPOIGNY 1",9,3,null,null,9,6]
[6,"HERY / LIGNY 1",{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$3","v":"STADE AUXERRE 3"},2,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",12-E6)))","v":10},null,null,null,null,null,null,null,null,null,"APPOIGNY 1",null,"",{"$f":"SUM(R2:R6)","v":10},{"$f":"SUM(V2:V6)","v":12},0,""]
[null,null,{"$f":"$B$2","v":"ST FLORENTIN 1"},{"$f":"$B$5","v":"RAVIERES 1"},7,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",12-E7)))","v":5},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",2,1,null,null,2,-8]
[null,null,{"$f":"$B$4","v":"CHATEL CENSOIR 1"},{"$f":"$B$6","v":"HERY / LIGNY 1"},5,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",12-E8)))","v":7},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",5,1,null,null,5,-2]
[null,null,"  Match 3 : à AUXERRE - Dimanche 08 Octobre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",1,1,null,null,1,-10]
[null,null,{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},11,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",12-E10)))","v":1},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",1,1,null,null,1,-10]
["Rappel:",null,{"$f":"$B$2","v":"ST FLORENTIN 1"},{"$f":"$B$6","v":"HERY / LIGNY 1"},10,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",12-E11)))","v":2},null,null,null,null,null,null,null,null,null,"CHATEL CENSOIR 1",null,"",{"$f":"SUM(R7:R11)","v":4},{"$f":"SUM(V7:V11)","v":-30},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$3","v":"STADE AUXERRE 3"},{"$f":"$B$5","v":"RAVIERES 1"},11,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",12-E12)))","v":1},null,null,null,null,null,null,null,null,null,"HERY / LIGNY 1",6,2,null,null,6,0]
["sont à remplir",null,"  Match 4 : à AUXERRE- Dimanche 08 Octobre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"HERY / LIGNY 1",7,3,null,null,7,2]
[null,null,{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$5","v":"RAVIERES 1"},9,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",12-E14)))","v":3},null,null,"Pts","+/-",null,null,null,null,null,"HERY / LIGNY 1",2,1,null,null,2,-8]
[null,null,{"$f":"$B$2","v":"ST FLORENTIN 1"},{"$f":"$B$4","v":"CHATEL CENSOIR 1"},11,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",12-E15)))","v":1},1,"STADE AUXERRE 3",12,38,null,null,null,null,null,"HERY / LIGNY 1",0,1,null,null,0,-12]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE 3"},{"$f":"$B$6","v":"HERY / LIGNY 1"},12,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",12-E16)))","v":0},2,"ST FLORENTIN 1",10,16,null,null,null,null,null,"HERY / LIGNY 1","","",{"$f":"SUM(R12:R16)","v":7},{"$f":"SUM(V12:V16)","v":-18},0,""]
[null,null,"  Match 5 et finale : à  ST FLORENTIN - Dimanche 22 Octobre à 8H30",null,null,null,3,"APPOIGNY 1",10,12,null,null,null,null,null,"RAVIERES 1",6,2,null,null,6,0]
[null,null,{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$6","v":"HERY / LIGNY 1"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",12-E18)))","v":""},4,"HERY / LIGNY 1",7,-18,null,null,null,null,null,"RAVIERES 1",5,1,null,null,5,-2]
[null,null,{"$f":"$B$2","v":"ST FLORENTIN 1"},{"$f":"$B$3","v":"STADE AUXERRE 3"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",12-E19)))","v":""},5,"RAVIERES 1",5,-18,null,null,null,null,null,"RAVIERES 1",1,1,null,null,1,-10]
[null,null,{"$f":"$B$4","v":"CHATEL CENSOIR 1"},{"$f":"$B$5","v":"RAVIERES 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",12-E20)))","v":""},6,"CHATEL CENSOIR 1",4,-30,null,null,null,null,null,"RAVIERES 1",3,1,null,null,3,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAVIERES 1","","",{"$f":"SUM(R17:R21)","v":5},{"$f":"SUM(V17:V21)","v":-18},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",4,1,null,null,4,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",7,3,null,null,7,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",10,3,null,null,10,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",11,3,null,null,11,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 1",null,"",{"$f":"SUM(R22:R26)","v":10},{"$f":"SUM(V22:V26)","v":16},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,"STADE AUXERRE 3",10,3,null,null,10,8]
[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,"STADE AUXERRE 3",10,3,null,null,10,8]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 3",11,3,null,null,11,10]
[null,"Championnat Départemental des Clubs 2023 FEMININ Division 2 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 3",12,3,null,null,12,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 3","","",{"$f":"SUM(R27:R31)","v":12},{"$f":"SUM(V27:V31)","v":38},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q32=\"\",\"\",IF(U32=36,36,IF(U32=0,-36,IF(U32=19,19,IF(U32=\"f\",-19,U32-(36-U32))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$2","v":"ST FLORENTIN 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE 3"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"APPOIGNY 1"},{"$f":"$B$2","v":"ST FLORENTIN 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"STADE AUXERRE 3"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]