{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CDC PROVENÇAL 2024 - D1 GRA","CDC PROVENÇAL 2024 - D1 GRB"],"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":"CDC PROVENÇAL 2024 - D1 GRA","index":0,"n_rows":311,"n_cols":22,"rows_kept":311,"cut":false,"hidden":false,"merged":[[0,2,0,5],[4,2,4,5],[8,2,8,5],[4,6,4,9],[23,1,23,10],[0,6,0,9],[24,1,24,10],[8,6,8,9],[9,6,9,7],[21,1,21,10],[22,1,22,10],[12,2,12,5]]}
[1,"MIGENNES 2","  Match 1 : à TONNERRE - Mercredi 01 Mai à 8H00",null,null,null,"  Match 5 : à ST BRIS - Dimanche 23 Juin à 8H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"TONNERRE 1",{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$2","v":"TONNERRE 1"},10,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",24-E2)))","v":14},{"$f":"$B$2","v":"TONNERRE 1"},{"$f":"$B$4","v":"STADE AUXERRE1"},null,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",24-I2)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=12,2,IF(Q2>12,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",24,IF(Q2=\"\",0,Q2))","v":0},{"$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":""}]
[3,"VAUX 1",{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$4","v":"STADE AUXERRE1"},0,24,{"$f":"$B$3","v":"VAUX 1"},{"$f":"$B$5","v":"CHEU 1"},null,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",24-I3)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=12,2,IF(Q3>12,3,1))))","v":""},null,null,0,""]
[4,"STADE AUXERRE1",{"$f":"$B$5","v":"CHEU 1"},"EXEMPT","G",{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",24-E4)))","v":"F"},{"$f":"$B$1","v":"MIGENNES 2"},"EXEMPT",null,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",24-I4)))","v":""},null,null,null,null,null,0,null,{"$f":"IF(Q4=\"\",\"\",IF(Q4=\"F\",0,IF(Q4=12,2,IF(Q4>12,3,1))))","v":""},null,null,{"$f":"IF(Q4=\"G\",24,IF(Q4=\"\",0,Q4))","v":0},{"$f":"IF(Q4=\"\",\"\",IF(U4=24,24,IF(U4=0,-24,IF(U4=12.5,12.5,IF(U4=\"f\",-24,U4-(24-U4))))))","v":""}]
[5,"CHEU 1","  Match 2 : à TONNERRE - Mercredi 01 Mai  à 14H00",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$3","v":"VAUX 1"},16,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",24-E6)))","v":8},null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"STADE AUXERRE1"},{"$f":"$B$5","v":"CHEU 1"},20,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",24-E7)))","v":4},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$2","v":"TONNERRE 1"},"EXEMPT","G",{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",24-E8)))","v":"F"},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
["Seules les Cases Blanches",null,"  Match 3 : à ST BRIS - Dimanche 16 Juin à 8H00",null,null,null,"Classement",null,null,null,null,null," ",null,null,0,null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$1","v":"MIGENNES 2"},{"$f":"$B$4","v":"STADE AUXERRE1"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",24-E10)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,0,null,{"$f":"IF(Q10=\"\",\"\",IF(Q10=\"F\",0,IF(Q10=12,2,IF(Q10>12,3,1))))","v":""},null,null,{"$f":"IF(Q10=\"G\",24,IF(Q10=\"\",0,Q10))","v":0},{"$f":"IF(Q10=\"\",\"\",IF(U10=24,24,IF(U10=0,-24,IF(U10=12.5,12.5,IF(U10=\"f\",-24,U10-(24-U10))))))","v":""}]
["sont à remplir",null,{"$f":"$B$2","v":"TONNERRE 1"},{"$f":"$B$5","v":"CHEU 1"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",24-E11)))","v":""},1,"STADE AUXERRE 1",6,40,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"VAUX 1"},"EXEMPT",null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",24-E12)))","v":""},2,"TONNERRE1",6,28,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,"  Match 4 : à ST BRIS - Dimanche 16 Juin à 14H00",null,null,null,3,"CHEU 1",4,8,null,null,null,null,null,0,"","",{"$f":"SUM(R6:R13)","v":0},{"$f":"SUM(V6:V13)","v":0},0,""]
[null,null,{"$f":"B1","v":"MIGENNES 2"},{"$f":"$B$5","v":"CHEU 1"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",24-E14)))","v":""},4,"MIGENNES 2",4,4,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$2","v":"TONNERRE 1"},{"$f":"$B$3","v":"VAUX 1"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",24-E15)))","v":""},5,"VAUX 1",2,-32,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"STADE AUXERRE1"},"EXEMPT",null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",24-E16)))","v":""},6,"EXEMPT",0,-48,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q18=\"\",\"\",IF(Q18=\"F\",0,IF(Q18=12,2,IF(Q18>12,3,1))))","v":""},null,null,{"$f":"IF(Q18=\"G\",24,IF(Q18=\"\",0,Q18))","v":0},{"$f":"IF(Q18=\"\",\"\",IF(U18=24,24,IF(U18=0,-24,IF(U18=12.5,12.5,IF(U18=\"f\",-24,U18-(24-U18))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,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,0,null,"",null,null,0,{"$f":"IF(Q22=\"\",\"\",IF(U22=24,24,IF(U22=0,-24,IF(U22=12.5,12.5,IF(U22=\"f\",-24,U22-(24-U22))))))","v":""}]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,{"$f":"IF(Q23=\"\",\"\",IF(U23=24,24,IF(U23=0,-24,IF(U23=12.5,12.5,IF(U23=\"f\",-24,U23-(24-U23))))))","v":""}]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(V20:V24)","v":0},0,""]
[null,"Championnat Départemental des Clubs 2024 Provençal Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R25:R29)","v":0},{"$f":"SUM(V25:V29)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,{"$f":"IF(Q36=\"G\",24,IF(Q36=\"\",0,Q36))","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,{"$f":"IF(Q37=\"G\",24,IF(Q37=\"\",0,Q37))","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R37:R41)","v":0},{"$f":"SUM(V37:V41)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U42=0,\"\",IF(U42=19,\"\",U42-(36-U42)))","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$3","v":"VAUX 1"},{"$f":"$B$1","v":"MIGENNES 2"},null,{"$f":"IF(E289=\"\",\"\",IF(E289=\"F\",\"G\",IF(E289=\"G\",\"F\",36-E289)))","v":""}]
[null,null,{"$f":"$B$2","v":"TONNERRE 1"},"Equipe 4",null,{"$f":"IF(E290=\"\",\"\",IF(E290=\"F\",\"G\",IF(E290=\"G\",\"F\",36-E290)))","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$3","v":"VAUX 1"},{"$f":"$B$1","v":"MIGENNES 2"},null,{"$f":"IF(E302=\"\",\"\",IF(E302=\"F\",\"G\",IF(E302=\"G\",\"F\",36-E302)))","v":""}]
[null,null,{"$f":"$B$2","v":"TONNERRE 1"},"Equipe 4",null,{"$f":"IF(E303=\"\",\"\",IF(E303=\"F\",\"G\",IF(E303=\"G\",\"F\",36-E303)))","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":"CDC PROVENÇAL 2024 - D1 GRB","index":1,"n_rows":302,"n_cols":22,"rows_kept":302,"cut":false,"hidden":false,"merged":[[21,1,21,10],[0,2,0,5],[3,2,3,5],[3,6,3,7],[6,2,6,5],[18,1,18,10],[19,1,19,10],[20,1,20,10]]}
[1,"AVALLON 1","  Match 1 : à TONNERRE - Mercredi 01 Mai à 8H00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"JOIGNY 1",{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$3","v":"MIGENNES 1"},3,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",24-E2)))","v":21},null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=12,2,IF(Q2>12,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",24,IF(Q2=\"\",0,Q2))","v":0},{"$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":""}]
[3,"MIGENNES 1",{"$f":"$B$2","v":"JOIGNY 1"},{"$f":"$B$4","v":"ST FLORENTIN 1"},24,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",24-E3)))","v":0},null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q3=\"\",\"\",IF(Q3=\"F\",0,IF(Q3=12,2,IF(Q3>12,3,1))))","v":""},null,null,0,""]
[5,"ST FLORENTIN 1","  Match 2 : à TONNERRE - Mercredi 01 Mai  à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$4","v":"ST FLORENTIN 1"},12,{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",24-E5)))","v":12},null,null,"Pts","+/-",null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$2","v":"JOIGNY 1"},{"$f":"$B$3","v":"MIGENNES 1"},20,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",24-E6)))","v":4},1,"JOIGNY 1",6,40,null,null,null,null,null,0,null,"",null,null,0,""]
["Rappel:",null,"  Match 3 : à ST BRIS - Dimanche 23 Juin à 8H00",null,null,null,2,"MIGENNES 1",4,2,null,null,null,null,null,0,null,"",null,null,0,""]
["sont à remplir",null,{"$f":"$B$1","v":"AVALLON 1"},{"$f":"$B$2","v":"JOIGNY 1"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",24-E8)))","v":""},3,"AVALLON 1",3,-18,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":"MIGENNES 1"},{"$f":"$B$4","v":"ST FLORENTIN 1"},null,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",24-E9)))","v":""},4,"ST FLORENTIN 1",3,-24,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R5:R10)","v":0},{"$f":"SUM(V5:V10)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,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,0,null,"",null,null,0,{"$f":"IF(Q19=\"\",\"\",IF(U19=24,24,IF(U19=0,-24,IF(U19=12.5,12.5,IF(U19=\"f\",-24,U19-(24-U19))))))","v":""}]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,{"$f":"IF(Q20=\"\",\"\",IF(U20=24,24,IF(U20=0,-24,IF(U20=12.5,12.5,IF(U20=\"f\",-24,U20-(24-U20))))))","v":""}]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R17:R21)","v":0},{"$f":"SUM(V17:V21)","v":0},0,""]
[null,"Championnat Départemental des Clubs 2024 Provençal Division 1 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,{"$f":"IF(Q32=\"G\",24,IF(Q32=\"\",0,Q32))","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,{"$f":"IF(Q33=\"G\",24,IF(Q33=\"\",0,Q33))","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(V33:V36)","v":0},0,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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$3","v":"MIGENNES 1"},{"$f":"$B$1","v":"AVALLON 1"},null,{"$f":"IF(E280=\"\",\"\",IF(E280=\"F\",\"G\",IF(E280=\"G\",\"F\",36-E280)))","v":""}]
[null,null,{"$f":"$B$2","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E281=\"\",\"\",IF(E281=\"F\",\"G\",IF(E281=\"G\",\"F\",36-E281)))","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$3","v":"MIGENNES 1"},{"$f":"$B$1","v":"AVALLON 1"},null,{"$f":"IF(E293=\"\",\"\",IF(E293=\"F\",\"G\",IF(E293=\"G\",\"F\",36-E293)))","v":""}]
[null,null,{"$f":"$B$2","v":"JOIGNY 1"},"Equipe 4",null,{"$f":"IF(E294=\"\",\"\",IF(E294=\"F\",\"G\",IF(E294=\"G\",\"F\",36-E294)))","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"]