{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["paramètres FTP","paramètres choix fichiers","fichiers du répertoire cible","Score","Feuil1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":2,"defined_names":113,"comments":2,"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":"paramètres FTP","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Paramètres par défaut (FTP)"]
[]
[]
[null,null,null,{"$f":"LEFT(CELL(\"filename\",C1),FIND(\"[\",CELL(\"filename\",C1))-2)&\"\\result.html\"","v":"C:\\Users\\fseys\\Dropbox (Compte personnel)\\! ! ! ! Tournoi Noël 2022\\! Tournoi\\result.html"}]
[null,"adresse du site FTP",null,"ftp.cluster027.hosting.ovh.net"]
[]
[null,"Port FTP",null,21]
[]
[null,"Répertoire vers lequel les fichiers doivent être transférés",null,"/www/TIN2022/"]
[]
[null,"Login",null,"sshbfryhnr"]
[]
[null,"Mot de passe"]
[]
[null,"autres paramètres  dans le code de la macro",":","transfert en mode actif / passif, binaire / ascii"]

{"sheet":"paramètres choix fichiers","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Paramètres par défaut (choix des fichiers)"]
[]
[]
[null,null,null,{"$f":"LEFT(CELL(\"filename\",C1),FIND(\"[\",CELL(\"filename\",C1))-2)&\"\\result.html\"","v":"C:\\Users\\fseys\\Dropbox (Compte personnel)\\! ! ! ! Tournoi Noël 2022\\! Tournoi\\result.html"}]
[null,"adresse du répertoire à transférer",null,{"$f":"LEFT(CELL(\"filename\",K1),FIND(\"[\",CELL(\"filename\",K1))-2)","v":"C:\\Users\\fseys\\Dropbox (Compte personnel)\\! ! ! ! Tournoi Noël 2022\\! Tournoi"}]
[]
[null,"âge maxi des fichiers (en jours)",null,"5"]
[]
[null,"types de fichiers à transférer (séparer par des virgules)",null,"html"]

{"sheet":"fichiers du répertoire cible","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,{"$f":"LEFT(CELL(\"filename\",C1),FIND(\"[\",CELL(\"filename\",C1))-2)&\"\\result.html\"","v":"C:\\Users\\fseys\\Dropbox (Compte personnel)\\! ! ! ! Tournoi Noël 2022\\! Tournoi\\result.html"}]

{"sheet":"Score","index":3,"n_rows":52,"n_cols":28,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,0,2,2]]}
[null,null,null,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":"LEFT(CELL(\"filename\",K1),FIND(\"[\",CELL(\"filename\",K1))-2)&\"\\\"&\"2022-tournoi_m_16F.html\"","v":"C:\\Users\\fseys\\Dropbox (Compte personnel)\\! ! ! ! Tournoi Noël 2022\\! Tournoi\\2022-tournoi_m_16F.html"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de derni&egrave;re modification : 15/12/2022 17:33:47"]
["TOURNOI HANDBALL JEUNES.\nStrasbourg, Noël 2022",null,null,null,"MOINS DE 16 Féminins\nSAMEDI 17 DECEMBRE 2022"]
[]
[null,"POULE UNIQUE",null,null,null,null,null,".",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESSAHB"]
[null,"ESSAHB",null,null,"Suivi de la compétition en direct",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US  Argonne Meuse"]
[null,"VAL DE MODER 1",null,null,"Réultats et classement mis à jours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAL DE MODER 2"]
[null,"HC SARRALBE",null,null,null,null,null,"http://www.sshb.fr/TIN2022/2022m16F.html",null,null,null,null,"Timming","Départ","09:00:00",null,null,null,null,null,null,null,null,null,null,"DAMBACH LA VILLE"]
[null,"VAL DE MODER 2",null,null,null,null,null,null,null,null,null,null,null,"Mise en place","00:02:00",null,null,null,null,null,null,null,null,null,null,"HOMECOURT"]
[null,"DAMBACH LA VILLE",null,"GYMNASE ARISTIDE",null,null,null,null,null,null,null,null,null,"durée Match Clas","00:12:00",null,null,null,null,null,null,null,"00:05:00",null,null,"HC SARRALBE"]
[null,"HOMECOURT",null,"43 Rue du Rhin",null,null,null,null,null,null,null,null,null,"Pause midi","01:20:00",null,null,null,null,null,null,null,null,null,null,"VAL DE MODER 1"]
[null,"US  ARGONNE MEUSE",null,"67100 Strasbourg",null,null,null,null,null,null,null,null,null,"Exclusions","00:01:00"]
[]
[]
[null,"Recevants","Visiteurs",null,"Sc-R","Sc-V","Pt-R","Pt-V",null,null,null,null,null,null,null,"Repas"]
[{"$f":"HOUR(M16)&\"h\"&TEXT(MINUTE(M16),\"00\")","v":"9h00"},{"$f":"Equipe_A","v":"ESSAHB"},"VAL DE MODER 2","Aristide",null,null,{"$f":"IF(ISBLANK(E16),\"-\",IF(E16=F16,2,IF(E16<F16,1,3)))","v":"-"},{"$f":"IF(ISBLANK(E16),\"-\",IF(E16=F16,2,IF(E16>F16,1,3)))","v":"-"},null,null,null,1,{"$f":"O8","v":"09:00:00"},{"$f":"M16+duree","v":"09:12:00"},null,null,null,{"$f":"IF(ISBLANK(E16),0,1)","v":0}]
["9h19",{"$f":"Equipe_B","v":"VAL DE MODER 1"},{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},"Aristide",null,null,"-","-",null,null,null,2,{"$f":"M16+m_e_p+duree+supp","v":"09:19:00"},"09:31:00",null,null,null,0]
["9h38",{"$f":"Equipe_C","v":"HC SARRALBE"},{"$f":"Equipe_F","v":"HOMECOURT"},"Aristide",null,null,"-","-",null,null,null,3,{"$f":"M17+m_e_p+duree+supp","v":"09:38:00"},"09:50:00",null,null,null,0]
["9h52",{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},{"$f":"Equipe_A","v":"ESSAHB"},null,null,null,"-","-",null,null,null,4,{"$f":"M18+m_e_p+duree","v":"09:52:00"},"10:04:00",null,null,null,0]
["10h06",{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},"VAL DE MODER 2",null,null,null,"-","-",null,null,null,5,"10:06:00","10:18:00",null,null,null,0]
["10h20",{"$f":"Equipe_B","v":"VAL DE MODER 1"},{"$f":"Equipe_C","v":"HC SARRALBE"},null,null,null,"-","-",null,null,null,6,"10:20:00","10:32:00",null,null,null,0]
["10h34",{"$f":"Equipe_F","v":"HOMECOURT"},{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},null,null,null,"-","-",null,null,null,7,"10:34:00","10:46:00",null,null,null,0]
["10h48",{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},{"$f":"Equipe_A","v":"ESSAHB"},null,null,null,"-","-",null,null,null,8,"10:48:00","11:00:00",null,null,null,0]
["11h02",{"$f":"Equipe_D","v":"VAL DE MODER 2"},{"$f":"Equipe_C","v":"HC SARRALBE"},null,null,null,"-","-",null,null,null,9,"11:02:00","11:14:00",null,null,null,0]
[{"$f":"HOUR(M25)&\"h\"&TEXT(MINUTE(M25),\"00\")","v":"11h16"},{"$f":"Equipe_F","v":"HOMECOURT"},{"$f":"Equipe_B","v":"VAL DE MODER 1"},null,null,null,{"$f":"IF(ISBLANK(E25),\"-\",IF(E25=F25,2,IF(E25<F25,1,3)))","v":"-"},{"$f":"IF(ISBLANK(E25),\"-\",IF(E25=F25,2,IF(E25>F25,1,3)))","v":"-"},null,null,null,10,{"$f":"M24+m_e_p+duree","v":"11:16:00"},{"$f":"M25+duree","v":"11:28:00"},null,null,null,{"$f":"IF(ISBLANK(E25),0,1)","v":0}]
["PAUSE REPAS DE MIDI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["12h50",{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},null,null,null,"-","-",null,null,null,11,{"$f":"M25+m_e_p+duree+pause","v":"12:50:00"},{"$f":"M27+duree","v":"13:02:00"},null,null,null,0]
["13h04",{"$f":"Equipe_C","v":"HC SARRALBE"},{"$f":"Equipe_A","v":"ESSAHB"},null,null,null,"-","-",null,null,null,12,{"$f":"M27+m_e_p+duree","v":"13:04:00"},"13:16:00",null,null,null,0]
["13h18",{"$f":"Equipe_D","v":"VAL DE MODER 2"},{"$f":"Equipe_F","v":"HOMECOURT"},null,null,null,"-","-",null,null,null,13,"13:18:00","13:30:00",null,null,null,0]
["13h32",{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},{"$f":"Equipe_B","v":"VAL DE MODER 1"},null,null,null,"-","-",null,null,null,14,"13:32:00","13:44:00",null,null,null,0]
["13h46",{"$f":"Equipe_C","v":"HC SARRALBE"},{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},null,null,null,"-","-",null,null,null,15,"13:46:00","13:58:00",null,null,null,0]
["14h00",{"$f":"Equipe_A","v":"ESSAHB"},{"$f":"Equipe_F","v":"HOMECOURT"},null,null,null,"-","-",null,null,null,16,"14:00:00","14:12:00",null,null,null,0]
["14h14",{"$f":"Equipe_B","v":"VAL DE MODER 1"},{"$f":"Equipe_D","v":"VAL DE MODER 2"},null,null,null,"-","-",null,null,null,17,"14:14:00","14:26:00",null,null,null,0]
["14h28",{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},{"$f":"Equipe_C","v":"HC SARRALBE"},null,null,null,"-","-",null,null,null,18,"14:28:00","14:40:00",null,null,null,0]
["14h42",{"$f":"Equipe_F","v":"HOMECOURT"},{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},null,null,null,"-","-",null,null,null,19,"14:42:00","14:54:00",null,null,null,0]
["14h56",{"$f":"Equipe_A","v":"ESSAHB"},{"$f":"Equipe_B","v":"VAL DE MODER 1"},null,null,null,"-","-",null,null,null,20,"14:56:00","15:08:00",null,null,null,0]
["15h10",{"$f":"Equipe_D","v":"VAL DE MODER 2"},{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},null,null,null,"-","-",null,null,null,21,"15:10:00","15:22:00",null,null,null,0]
[]
[]
[null,null,"Equipe","Nb","Pts","B+","B-","Dif"]
[null,null,{"$f":"Equipe_D","v":"VAL DE MODER 2"},{"$f":"SUMIF($C$16:$C$37,C41,$R$16:$R$37)+SUMIF($B$16:$B$37,C41,$R$16:$R$37)","v":0},{"$f":"SUMIF($B$16:$B$37,C41,$G$16:$G$37)+SUMIF($C$16:$C$37,C41,$H$16:$H$37)","v":0},{"$f":"SUMIF($B$16:$B$37,C41,$E$16:$E$37)+SUMIF($C$16:$C$37,C41,$F$16:$F$37)","v":0},{"$f":"SUMIF($B$16:$B$37,C41,$F$16:$F$37)+SUMIF($C$16:$C$37,C41,$E$16:$E$37)","v":0},{"$f":"F41-G41","v":0},"1er"]
[null,null,{"$f":"Equipe_A","v":"ESSAHB"},0,0,0,0,0,"2ème"]
[null,null,{"$f":"Equipe_C","v":"HC SARRALBE"},0,0,0,0,0,"3ème"]
[null,null,{"$f":"Equipe_F","v":"HOMECOURT"},0,0,0,0,0,"4ème"]
[null,null,{"$f":"Equipe_E","v":"DAMBACH LA VILLE"},0,0,0,0,0,"5ème"]
[null,null,{"$f":"Equipe_G","v":"US  ARGONNE MEUSE"},0,0,0,0,0,"6ème"]
[null,null,{"$f":"Equipe_B","v":"VAL DE MODER 1"},0,0,0,0,0,"7ème"]
[]
["Compétition jouée comme un championnat traditionnel, toutes les équipes se rencontrent."]
["Victoire = 3pts ; Match Nul = 2 Pts ; Défaite = 1 pt"]
["Si égalité, goal avérage particulier, puis plus de buts marqués sur un match, puis plus gros écart sur 1 match"]
["entre les équipes à égalité."]

{"sheet":"Feuil1","index":4,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[null,"00:18:00",4,6,null,null,null,7,8]
[null,"00:02:00",{"$f":"C2*(C2-1)/2","v":6},15,null,null,null,21,28]
[null,{"$f":"SUM(B2:B3)","v":"00:20:00"}]
[]
[null,"09:30:00",1,"Equi A","Equi D",null,"13:00:00",1,"ab","F Equi1","F Equi2"]
[null,{"$f":"B6+duree","v":"09:42:00"},2,"Equi B","Equi E",null,{"$f":"G6+duree","v":"13:12:00"},2,"cd","F Equi3","F Equi4"]
[null,"09:54:00",3,"Equi C","Equi F",null,"13:24:00",3,"ef","F Equi5","F Equi6"]
[null,"10:06:00",4,"Equi G","Equi A",null,"13:36:00",4,"ac","F Equi1","F Equi3"]
[null,"10:18:00",5,"Equi E","Equi D",null,"13:48:00",5,"df","F Equi2","F Equi6"]
[null,"10:30:00",6,"Equi B","Equi C",null,"14:00:00",6,"be","F Equi4","F Equi5"]
[null,"10:42:00",7,"Equi F","Equi G",null,"14:12:00",7,"ad","F Equi1","F Equi6"]
[null,"10:54:00",8,"Equi E","Equi A",null,"14:24:00",8,"ce","F Equi3","F Equi5"]
[null,"11:06:00",9,"Equi D","Equi C",null,"14:36:00",9,"bf","F Equi2","F Equi4"]
[null,"11:18:00",10,"Equi F","Equi B",null,"14:48:00",10,null,"F Equi3","F Equi6"]
[null,"11:30:00",11,"Equi E","Equi G",null,"15:00:00",11,null,"F Equi1","F Equi4"]
[null,"11:42:00",12,"Equi C","Equi A",null,"15:12:00",12,null,"F Equi2","F Equi5"]
[null,"11:54:00",null,null,null,null,"15:24:00",13,null,"F Equi4","F Equi6"]
[null,"12:06:00",null,null,null,null,"15:36:00",14,null,"F Equi2","F Equi3"]
[null,"12:18:00",null,null,null,null,"15:48:00",15,null,"F Equi1","F Equi5"]
[null,"12:30:00",null,null,null,null,"16:00:00"]
[null,"12:42:00",13,"Equi D","Equi F",null,"16:12:00"]
[null,"12:54:00",14,"Equi G","Equi B",null,"16:24:00"]
[null,"13:06:00",15,"Equi C","Equi E",null,"16:36:00"]
[null,"13:18:00",16,"Equi A","Equi F",null,"16:48:00"]
[null,"13:30:00",17,"Equi B","Equi D",null,"17:00:00"]
[null,"13:42:00",18,"Equi G","Equi C",null,"17:12:00"]
[null,"13:54:00",19,"Equi F","Equi E",null,"17:24:00"]
[null,"14:06:00",20,"Equi A","Equi B",null,"17:36:00"]
[null,"14:18:00",21,"Equi D","Equi G",null,"17:48:00"]
[null,"14:30:00",22,null,null,null,"18:00:00"]
[null,"14:42:00",23,null,null,null,"18:12:00"]
[null,"14:54:00",24,null,null,null,"18:24:00"]
[null,"15:06:00",null,null,null,null,"18:36:00"]
[null,"15:18:00",null,null,null,null,"18:48:00"]
[null,"15:30:00",null,null,null,null,"19:00:00"]
[null,"15:42:00",null,null,null,null,"19:12:00"]
[null,"15:54:00",null,null,null,null,"19:24:00"]
[null,"16:06:00",null,null,null,null,"19:36:00"]
[null,"16:18:00"]
[null,"16:30:00"]
[null,"16:42:00"]
[null,"16:54:00"]
[null,"17:06:00"]
[null,"17:18:00"]
[null,"17:30:00"]
[null,"17:42:00"]
[null,"17:54:00"]
[null,"18:06:00"]
[null,"18:18:00"]
[null,"18:30:00"]