{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DIV 4 GR A","DIV 4 Gr B","DIV 4 GR C"],"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 4 GR A","index":0,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[15,11,16,11],[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,"MALAY LE GRAND 3","  Match 1 : à  MALAY LE GRAND - Dimanche 17 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"ST MARTIN TERTRE 2",{"$f":"$B$1","v":"MALAY LE GRAND 3"},{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},14,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":22},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",18,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":2},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":18},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":0}]
[3,"MIGENNES 4",{"$f":"$B$3","v":"MIGENNES 4"},{"$f":"$B$4","v":"CHAMPIGNY 2"},18,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":18},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",24,3,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":24},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":12}]
[4,"CHAMPIGNY 2",{"$f":"$B$5","v":"MONTACHER 1"},{"$f":"$B$6","v":"VERON 2"},10,26,null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",20,3,null,null,20,4]
[5,"MONTACHER 1","  Match 2 : à  MALAY LE GRAND - Dimanche 17 Septembre à 14H00",null,null,null,null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",22,3,null,null,22,8]
[6,"VERON 2",{"$f":"$B$1","v":"MALAY LE GRAND 3"},{"$f":"$B$3","v":"MIGENNES 4"},14,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":22},null,null,null,null,null,null,null,null,null,"CHAMPIGNY 2",28,3,{"$f":"SUM(R2:R6)","v":14},{"$f":"SUM(V2:V6)","v":44},28,20]
[null,null,{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},{"$f":"$B$5","v":"MONTACHER 1"},18,18,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 3",14,1,null,null,14,-8]
[null,null,{"$f":"$B$4","v":"CHAMPIGNY 2"},{"$f":"$B$6","v":"VERON 2"},24,12,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 3",14,1,null,null,14,-8]
[null,null,"  Match 3 : à MALAY LE GRAND - Dimanche 08 Octobre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 3",16,1,null,null,16,-4]
[null,null,{"$f":"$B$1","v":"MALAY LE GRAND 3"},{"$f":"$B$4","v":"CHAMPIGNY 2"},16,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":20},null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 3",24,3,null,null,24,12]
["Rappel:",null,{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},{"$f":"$B$6","v":"VERON 2"},18,18,null,null,null,null,null,null,null,null,null,"MALAY LE GRAND 3",14,1,{"$f":"SUM(R7:R11)","v":7},{"$f":"SUM(V7:V11)","v":-16},14,-8]
["Seules les Cases Blanches",null,{"$f":"$B$3","v":"MIGENNES 4"},{"$f":"$B$5","v":"MONTACHER 1"},34,2,null,null,null,null,null,null,null,null,null,"MIGENNES 4",18,2,null,null,18,0]
["sont à remplir",null,"  Match 4 : à MALAY LE GRAND - Dimanche 08 Octobre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"MIGENNES 4",22,3,null,null,22,8]
[null,null,{"$f":"$B$1","v":"MALAY LE GRAND 3"},{"$f":"$B$5","v":"MONTACHER 1"},24,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":12},null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 4",34,3,null,null,34,32]
[null,null,{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},{"$f":"$B$4","v":"CHAMPIGNY 2"},14,22,1,"CHAMPIGNY 2",14,44,null,null,null,null,null,"MIGENNES 4",16,1,null,null,16,-4]
[null,null,{"$f":"$B$3","v":"MIGENNES 4"},{"$f":"$B$6","v":"VERON 2"},16,20,2,"VERON 2",12,16,null,"veron gagne 20 à 16 contre migennes",null,null,null,"MIGENNES 4",30,3,{"$f":"SUM(R12:R16)","v":12},{"$f":"SUM(V12:V16)","v":60},30,24]
[null,null,"  Match 5  : à MIGENNES - Dimanche 22 Octobre à 14H00",null,null,null,3,"MIGENNES 4",12,60,null,null,null,null,null,"MONTACHER 1",10,1,null,null,10,-16]
[null,null,{"$f":"$B$1","v":"MALAY LE GRAND 3"},{"$f":"$B$6","v":"VERON 2"},14,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":22},4,"ST MARTIN TERTRE 2",9,-24,null,null,null,null,null,"MONTACHER 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},{"$f":"$B$3","v":"MIGENNES 4"},6,30,5,"MALAY LE GRAND 3",7,-16,null,null,null,null,null,"MONTACHER 1",2,1,null,null,2,-32]
[null,null,{"$f":"$B$4","v":"CHAMPIGNY 2"},{"$f":"$B$5","v":"MONTACHER 1"},28,8,6,"MONTACHER 1",6,-80,null,null,null,null,null,"MONTACHER 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTACHER 1",8,1,{"$f":"SUM(R17:R21)","v":6},{"$f":"SUM(V17:V21)","v":-80},8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 2",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 2",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 2",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 2",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN TERTRE 2",6,1,{"$f":"SUM(R22:R26)","v":9},{"$f":"SUM(V22:V26)","v":-24},6,-24]
[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 2",26,3,null,null,26,16]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",12,1,null,null,12,-12]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",18,2,null,null,18,0]
[null,"Championnat Départemental des Clubs 2023  Division 4 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERON 2",22,3,{"$f":"SUM(R27:R31)","v":12},{"$f":"SUM(V27:V31)","v":16},22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(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":"MALAY LE GRAND 3"},{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 4"},"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":"MALAY LE GRAND 3"},{"$f":"$B$2","v":"ST MARTIN TERTRE 2"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"MIGENNES 4"},"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 4 Gr B","index":1,"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],[10,2,10,5],[5,2,5,5],[5,6,5,9],[0,6,0,9]]}
[1,"MIGENNES 3","Match 1: à CHARBUY - Dimanche 21 Mai à 8H30 ",null,null,null,"Match 6: à MIGENNES - Dimanche 08 Octobre à 14H00",null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"CHARBUY 1",{"$f":"$B$1","v":"MIGENNES 3"},{"$f":"$B$2","v":"CHARBUY 1"},16,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":20},{"$f":"$B$1","v":"MIGENNES 3"},{"$f":"$B$6","v":"SENAN 3"},26,{"$f":"IF(I2=\"\",\"\",IF(I2=\"F\",\"G\",IF(I2=\"G\",\"F\",36-I2)))","v":10},null,null,null,null,null,"APPOIGNY 4",12,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":1},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":12},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":-12}]
[3,"ST FLORENTIN 4",{"$f":"$B$3","v":"ST FLORENTIN 4"},{"$f":"$B$5","v":"APPOIGNY 4"},24,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":12},{"$f":"$B$3","v":"ST FLORENTIN 4"},{"$f":"$B$4","v":"STADE AUXERRE 6"},10,{"$f":"IF(I3=\"\",\"\",IF(I3=\"F\",\"G\",IF(I3=\"G\",\"F\",36-I3)))","v":26},null,null,null,null,null,"APPOIGNY 4",20,3,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":20},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":4}]
[4,"STADE AUXERRE 6",{"$f":"$B$4","v":"STADE AUXERRE 6"},{"$f":"$B$6","v":"SENAN 3"},16,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":20},{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},{"$f":"$B$5","v":"APPOIGNY 4"},10,{"$f":"IF(I4=\"\",\"\",IF(I4=\"F\",\"G\",IF(I4=\"G\",\"F\",36-I4)))","v":26},null,null,null,null,null,"APPOIGNY 4",22,3,null,null,22,8]
[5,"APPOIGNY 4",{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},{"$f":"$B$8","v":"EXEMPT"},"G",{"$f":"IF(E5=\"\",\"\",IF(E5=\"F\",\"G\",IF(E5=\"G\",\"F\",36-E5)))","v":"F"},{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$2","v":"CHARBUY 1"},"F",{"$f":"IF(I5=\"\",\"\",IF(I5=\"F\",\"G\",IF(I5=\"G\",\"F\",36-I5)))","v":"G"},null,null,null,null,null,"APPOIGNY 4",4,1,null,null,4,-28]
[6,"SENAN 3","Match 2: à CHARBUY - Dimanche 21 Mai à 14H00 ",null,null,null,"Match 7 : à MIGENNES - Dimanche 22 octobre à 14H00",null,null,null,null,null,null,null,null,"APPOIGNY 4","G",3,null,null,19,19]
[7,"ST MARTIN DU TERTRE 3",{"$f":"$B$5","v":"APPOIGNY 4"},{"$f":"$B$1","v":"MIGENNES 3"},20,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":16},{"$f":"$B$6","v":"SENAN 3"},{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},26,{"$f":"IF(I7=\"\",\"\",IF(I7=\"F\",\"G\",IF(I7=\"G\",\"F\",36-I7)))","v":10},null,null,null,null,null,"APPOIGNY 4",26,3,null,null,26,16]
[8,"EXEMPT",{"$f":"$B$6","v":"SENAN 3"},{"$f":"$B$3","v":"ST FLORENTIN 4"},22,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":14},{"$f":"$B$5","v":"APPOIGNY 4"},{"$f":"$B$2","v":"CHARBUY 1"},16,{"$f":"IF(I8=\"\",\"\",IF(I8=\"F\",\"G\",IF(I8=\"G\",\"F\",36-I8)))","v":20},null,null,null,null,null,"APPOIGNY 4",16,1,{"$f":"SUM(R2:R8)","v":15},{"$f":"SUM(V2:V8)","v":3},16,-4]
[null,null,{"$f":"$B$2","v":"CHARBUY 1"},{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},36,{"$f":"IF(E9=\"\",\"\",IF(E9=\"F\",\"G\",IF(E9=\"G\",\"F\",36-E9)))","v":0},{"$f":"$B$4","v":"STADE AUXERRE 6"},{"$f":"$B$1","v":"MIGENNES 3"},12,{"$f":"IF(I9=\"\",\"\",IF(I9=\"F\",\"G\",IF(I9=\"G\",\"F\",36-I9)))","v":24},null,null,null,null,null,"CHARBUY 1",20,3,null,null,20,4]
[null,null,{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$4","v":"STADE AUXERRE 6"},"F",{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":"G"},{"$f":"$B$3","v":"ST FLORENTIN 4"},{"$f":"$B$8","v":"EXEMPT"},"F",{"$f":"IF(I10=\"\",\"\",IF(I10=\"F\",\"G\",IF(I10=\"G\",\"F\",36-I10)))","v":"G"},null,null,null,null,null,"CHARBUY 1",36,3,null,null,36,36]
["Rappel:",null,"Match 3: à APPOIGNY - Dimanche 17 Septembre à 8H30 ",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 1",20,3,null,null,20,4]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"APPOIGNY 4"},{"$f":"$B$4","v":"STADE AUXERRE 6"},22,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":14},null,null,null,null,null,null,null,null,null,"CHARBUY 1",18,2,null,null,18,0]
["sont à remplir",null,{"$f":"$B$2","v":"CHARBUY 1"},{"$f":"$B$3","v":"ST FLORENTIN 4"},20,{"$f":"IF(E13=\"\",\"\",IF(E13=\"F\",\"G\",IF(E13=\"G\",\"F\",36-E13)))","v":16},"Classement",null,null,null,null,null,null,null,null,"CHARBUY 1",10,1,null,null,10,-16]
[null,null,{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},{"$f":"$B$1","v":"MIGENNES 3"},8,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":28},null,null,"Pts","+/-",null,null,null,null,null,"CHARBUY 1","G",3,null,null,19,19]
[null,null,{"$f":"$B$6","v":"SENAN 3"},{"$f":"$B$8","v":"EXEMPT"},"G",{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":"F"},1,"SENAN 3",19,75,null,null,null,null,null,"CHARBUY 1",20,3,{"$f":"SUM(R9:R15)","v":18},{"$f":"SUM(V9:V15)","v":47},20]
[null,null,"Match 4: à APPOIGNY - Dimanche 17 Septembre à 14H00 ",null,null,null,2,"CHARBUY 1",18,47,null,null,null,null,null,"EXEMPT","F",null,null,null,"F"]
[null,null,{"$f":"$B$4","v":"STADE AUXERRE 6"},{"$f":"$B$2","v":"CHARBUY 1"},18,{"$f":"IF(E17=\"\",\"\",IF(E17=\"F\",\"G\",IF(E17=\"G\",\"F\",36-E17)))","v":18},3,"MIGENNES 3",17,75,null,null,null,null,null,"EXEMPT","F",null,null,null,"F"]
[null,null,{"$f":"$B$6","v":"SENAN 3"},{"$f":"$B$5","v":"APPOIGNY 4"},32,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":4},4,"APPOIGNY 4",15,3,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,{"$f":"$B$3","v":"ST FLORENTIN 4"},{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},22,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":14},5,"STADE AUXERRE 6",14,43,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,{"$f":"$B$1","v":"MIGENNES 3"},{"$f":"$B$8","v":"EXEMPT"},"G",{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":"F"},6,"ST FLORENTIN 4",10,-43,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,"Match 5: à MIGENNES - Dimanche 08 Octobre à 8H30",null,null,null,7,"ST MARTIN DU TERTRE 3",9,-109,null,null,null,null,null,"EXEMPT","F",0,null,null,"F",-19]
[null,null,{"$f":"$B$1","v":"MIGENNES 3"},{"$f":"$B$3","v":"ST FLORENTIN 4"},26,{"$f":"IF(E22=\"\",\"\",IF(E22=\"F\",\"G\",IF(E22=\"G\",\"F\",36-E22)))","v":10},8,"EXEMPT",3,-57,null,null,null,null,null,"EXEMPT","G",3,{"$f":"SUM(R16:R22)","v":3},{"$f":"SUM(V16:V22)","v":-57},19,19]
[null,null,{"$f":"$B$2","v":"CHARBUY 1"},{"$f":"$B$6","v":"SENAN 3"},10,{"$f":"IF(E23=\"\",\"\",IF(E23=\"F\",\"G\",IF(E23=\"G\",\"F\",36-E23)))","v":26},null,null,null,null,null,null,null,null,null,"MIGENNES 3",16,1,null,null,16,-4]
[null,null,{"$f":"$B$7","v":"ST MARTIN DU TERTRE 3"},{"$f":"$B$4","v":"STADE AUXERRE 6"},2,{"$f":"IF(E24=\"\",\"\",IF(E24=\"F\",\"G\",IF(E24=\"G\",\"F\",36-E24)))","v":34},null,null,null,null,null,null,null,null,null,"MIGENNES 3",16,1,null,null,16,-4]
[null,null,{"$f":"$B$8","v":"EXEMPT"},{"$f":"$B$5","v":"APPOIGNY 4"},"F",{"$f":"IF(E25=\"\",\"\",IF(E25=\"F\",\"G\",IF(E25=\"G\",\"F\",36-E25)))","v":"G"},null,null,null,null,null,null,null,null,null,"MIGENNES 3",28,3,null,null,28,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3","G",3,null,null,19,19]
[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",26,3,null,null,26,16]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",26,3,null,null,26,16]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"MIGENNES 3",24,3,{"$f":"SUM(R23:R29)","v":17},{"$f":"SUM(V23:V29)","v":75},24,12]
[null,"Championnat Départemental des Clubs 2023  Division 4 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",20,3,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3","G",3,null,null,19,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",32,3,null,null,32,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENAN 3",26,3,{"$f":"SUM(R30:R36)","v":19},{"$f":"SUM(V30:V36)","v":75},26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",24,3,null,null,24,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST FLORENTIN 4","F",0,{"$f":"SUM(R37:R43)","v":10},{"$f":"SUM(V37:V43)","v":-43},"F",-19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3","G",3,null,null,19,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",0,1,null,null,0,-36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",8,1,null,null,8,-20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",2,1,null,null,2,-32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST MARTIN DU TERTRE 3",10,1,{"$f":"SUM(R44:R50)","v":9},{"$f":"SUM(V44:V50)","v":-109},10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",16,1,null,null,16,-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6","G",3,null,null,19,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",34,3,null,null,34,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",26,3,null,null,26,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STADE AUXERRE 6",12,1,{"$f":"SUM(R51:R57)","v":14},{"$f":"SUM(V51:V57)","v":43},12,-12]
[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 3"},{"$f":"$B$2","v":"CHARBUY 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST FLORENTIN 4"},"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 3"},{"$f":"$B$2","v":"CHARBUY 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST FLORENTIN 4"},"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 4 GR C","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,"CHARBUY 2","  Match 1 : à  BLENEAU - Dimanche 17 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"BLENEAU 1",{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$2","v":"BLENEAU 1"},12,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":24},null,null,null,null,null,null,null,null,null,"AVALLON 3",22,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":3},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":22},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":8}]
[3,"ST SAUVEUR 1",{"$f":"$B$3","v":"ST SAUVEUR 1"},{"$f":"$B$4","v":"GRIMAULT 1"},14,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":22},null,null,null,null,null,null,null,null,null,"AVALLON 3",18,2,null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":18},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":0}]
[4,"GRIMAULT 1",{"$f":"$B$5","v":"AVALLON 3"},{"$f":"$B$6","v":"LAVAU 1"},22,14,null,null,null,null,null,null,null,null,null,"AVALLON 3",20,3,null,null,20,4]
[5,"AVALLON 3","  Match 2 : à  BLENEAU - Dimanche 17 Septembre à 14H00",null,null,null,null,null,null,null,null,null,null,null,null,"AVALLON 3",20,3,null,null,20,4]
[6,"LAVAU 1",{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$3","v":"ST SAUVEUR 1"},24,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":12},null,null,null,null,null,null,null,null,null,"AVALLON 3",22,3,{"$f":"SUM(R2:R6)","v":14},{"$f":"SUM(V2:V6)","v":24},22,8]
[null,null,{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$5","v":"AVALLON 3"},18,18,null,null,null,null,null,null,null,null,null,"BLENEAU 1",24,3,null,null,24,12]
[null,null,{"$f":"$B$4","v":"GRIMAULT 1"},{"$f":"$B$6","v":"LAVAU 1"},18,18,null,null,null,null,null,null,null,null,null,"BLENEAU 1",18,2,null,null,18,0]
[null,null,"  Match 3 : à GRIMAULT - Dimanche 08 Octobre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,"BLENEAU 1",26,3,null,null,26,16]
[null,null,{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$4","v":"GRIMAULT 1"},20,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":16},null,null,null,null,null,null,null,null,null,"BLENEAU 1",24,3,null,null,24,12]
["Rappel:",null,{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$6","v":"LAVAU 1"},26,10,null,null,null,null,null,null,null,null,null,"BLENEAU 1",24,3,{"$f":"SUM(R7:R11)","v":14},{"$f":"SUM(V7:V11)","v":52},24,12]
["Seules les Cases Blanches",null,{"$f":"$B$3","v":"ST SAUVEUR 1"},{"$f":"$B$5","v":"AVALLON 3"},16,20,null,null,null,null,null,null,null,null,null,"CHARBUY 2",12,1,null,null,12,-12]
["sont à remplir",null,"  Match 4 : à  GRIMAULT - Dimanche 08 Octobre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"CHARBUY 2",24,3,null,null,24,12]
[null,null,{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$5","v":"AVALLON 3"},16,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":20},null,null,"Pts","+/-",null,null,null,null,null,"CHARBUY 2",20,3,null,null,20,4]
[null,null,{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$4","v":"GRIMAULT 1"},24,12,1,"BLENEAU 1",14,52,null,null,null,null,null,"CHARBUY 2",16,1,null,null,16,-4]
[null,null,{"$f":"$B$3","v":"ST SAUVEUR 1"},{"$f":"$B$6","v":"LAVAU 1"},22,14,2,"AVALLON 3",14,24,null,null,null,null,null,"CHARBUY 2",28,3,{"$f":"SUM(R12:R16)","v":11},{"$f":"SUM(V12:V16)","v":20},28,20]
[null,null,"  Match 5  : à MIGENNES - Dimanche 22 Octobre à 14H00",null,null,null,3,"CHARBUY 2",11,20,null,null,null,null,null,"GRIMAULT 1",22,3,null,null,22,8]
[null,null,{"$f":"$B$1","v":"CHARBUY 2"},{"$f":"$B$6","v":"LAVAU 1"},28,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":8},4,"GRIMAULT 1",8,-16,null,null,null,null,null,"GRIMAULT 1",18,2,null,null,18,0]
[null,null,{"$f":"$B$2","v":"BLENEAU 1"},{"$f":"$B$3","v":"ST SAUVEUR 1"},24,12,5,"ST SAUVEUR 1",7,-28,null,null,null,null,null,"GRIMAULT 1",16,1,null,null,16,-4]
[null,null,{"$f":"$B$4","v":"GRIMAULT 1"},{"$f":"$B$5","v":"AVALLON 3"},14,22,6,"LAVAU 1",6,-52,null,null,null,null,null,"GRIMAULT 1",12,1,null,null,12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRIMAULT 1",14,1,{"$f":"SUM(R17:R21)","v":8},{"$f":"SUM(V17:V21)","v":-16},14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAVAU 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAVAU 1",18,2,null,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAVAU 1",10,1,null,null,10,-16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAVAU 1",14,1,null,null,14,-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAVAU 1",8,1,{"$f":"SUM(R22:R26)","v":6},{"$f":"SUM(V22:V26)","v":-52},8,-20]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST SAUVEUR 1",14,1,null,null,14,-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,"ST SAUVEUR 1",12,1,null,null,12,-12]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST SAUVEUR 1",16,1,null,null,16,-4]
[null,"Championnat Départemental des Clubs 2023  Division 4 Groupe C",null,null,null,null,null,null,null,null,null,null,null,null,null,"ST SAUVEUR 1",22,3,null,null,22,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST SAUVEUR 1",12,1,{"$f":"SUM(R27:R31)","v":7},{"$f":"SUM(V27:V31)","v":-28},12,-12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"CHARBUY 2"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST SAUVEUR 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":"CHARBUY 2"},{"$f":"$B$2","v":"BLENEAU 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"ST SAUVEUR 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"]