{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["parametres","Aide","Presentation","MODELES"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":26,"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":"parametres","index":0,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":false,"merged":[[17,4,19,4],[21,1,21,2],[24,1,28,2],[0,1,0,2],[1,1,1,2],[4,1,4,2],[16,1,16,2]]}
[null,"Ne modifiez que les cellules sur fond jaune."]
[null,"Paramètres de l'application"]
[null,"Chemin système vers \nla base PAPI "]
[null,"Chemin système vers \nle dossier de sauvegarde "]
[null,"Paramètres de la compétition"]
[null,"Arbitre principal "]
[null,"date et lieu "]
[null,"nom de la compétition "]
[null,"Nb rondes "]
[null,"Nb joueurs à chaque ronde "]
[null,"Nb suppléants "]
[null,"Nb maxi d'équipes "]
[null,"Nb réel d'équipes"]
[null,"Elo pris en compte "]
[null,"ELO estimé ramené à "]
[null,"Moyenne Elo calculée sur"]
[null,"Profil des joueurs"]
[null,"Ligue "]
[null,"Année de naissance mini "]
[null,"Année de naissance maxi "]
[null,"Type de licenciés"]
[null,"Les 4 paramètres ci-dessus ne servent qu'à alléger le classeur en \nrestreignant le nombre de joueurs importés depuis la base PAPI."]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"LISTES DEROULANTES","Ne pas dépacer dans une autre feuille sinon on perd la compatibilité avec Excel 2007"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$18,J54:L81,3,FALSE)","v":{"$error":"#N/A"}},"LIGUES","Code Ligue","Lettre"]
[null,null,null,null,null,null,null,null,null,"TOUTES",null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,"Auvergne-Rhône-Alpes","ARA","JQD"]
[null,null,null,null,null,null,null,null,null,"Bourgogne Franche-Comté","BFC","EK"]
[null,null,null,null,null,null,null,null,null,"Bretagne","BRE","F"]
[null,null,null,null,null,null,null,null,null,"Centre Val de Loire","CVL","G"]
[null,null,null,null,null,null,null,null,null,"Grand Est","EST","BHP"]
[null,null,null,null,null,null,null,null,null,"Corse","CRS","I"]
[null,null,null,null,null,null,null,null,null,"Guadeloupe","GUA","Z9C"]
[null,null,null,null,null,null,null,null,null,"Guyane","GUY","Z9B"]
[null,null,null,null,null,null,null,null,null,"Haut-de-France","HDF","RY"]
[null,null,null,null,null,null,null,null,null,"Ile-de-France","IDF","M"]
[null,null,null,null,null,null,null,null,null,"Martinique","MAR","Z9D"]
[null,null,null,null,null,null,null,null,null,"Normandie","NOR","AS"]
[null,null,null,null,null,null,null,null,null,"Nouvelle Aquitaine","NAQ","LOT"]
[null,null,null,null,null,null,null,null,null,"Nouvelle Calédonie","NCA","Z9F"]
[null,null,null,null,null,null,null,null,null,"Occitanie","OCC","NV"]
[null,null,null,null,null,null,null,null,null,"Pays de la Loire","PDL","C"]
[null,null,null,null,null,null,null,null,null,"Polynésie","POL","Z9E"]
[null,null,null,null,null,null,null,null,null,"Provence-Alpes-Côte d'Azur","PAC","IU"]
[null,null,null,null,null,null,null,null,null,"Réunion","REU","X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$14,J84:K86,2,FALSE)","v":{"$error":"#N/A"}},"ELO  pris en compte"]
[null,null,null,null,null,null,null,null,null,"Blitz","B"]
[null,null,null,null,null,null,null,null,null,"Rapide","R"]
[null,null,null,null,null,null,null,null,null,"Lent","L"]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$16,J89:K90,2,FALSE)","v":{"$error":"#N/A"}},"MOYENNE ELO calculée sur",null,null,"Tous"]
[null,null,null,null,null,null,null,null,null,"la liste complète : joueurs et suppléants","T",null,"Limité au n premiers joueurs"]
[null,null,null,null,null,null,null,null,null,"la liste sans les suppléants","L"]
[]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$21,J93:K95,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"A en cours de validité","A"]
[null,null,null,null,null,null,null,null,null,"A ou B en cours de validité","B"]
[null,null,null,null,null,null,null,null,null,"Tous, même les anciens (A, B ou N)","N"]

{"sheet":"Aide","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Presentation","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,6,40,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"version","1.2.1","2018-11-01"]
[null,null,null,null,null,null,"\nCette version a été testée  sous Microsoft Excel 2016 version Française\nElle risque de dysfonctionner avec une version étrangère.\nElle est normalement compatible avec  Microsoft Excel 2010 français\n\nNOUVEAUTÉS 1.2.0 : \n- Le élo Blitz est pris en compte\n- On distingue les élos lent, rapide et blitz,  National ou Fide\n- Les rapides et blitz estimés sont maintenant correctement gérés pour calculer la moyenne élo de l'équipe\n- Prise en compte des nouvelles Ligues"]

{"sheet":"MODELES","index":3,"n_rows":112,"n_cols":22,"rows_kept":112,"cut":false,"hidden":true,"merged":[[0,0,1,0],[3,0,4,0],[7,0,8,0],[3,1,3,4],[3,5,3,7],[0,3,0,6],[1,3,1,6],[0,1,1,2],[3,10,3,16],[5,4,5,5],[7,1,7,3],[7,6,7,7],[8,1,8,7],[4,2,4,4],[4,6,4,7]]}
["FMentete","ffe",null,{"$f":"evenement","v":0},null,null,null,null,null,"LTjoueur",null,null,{"$f":"IF(ISBLANK(N1),\"\",VLOOKUP(N1,joueurs,2,FALSE)&\" \"&VLOOKUP(N1,joueurs,3,FALSE))","v":""},null,{"$f":"IF(ISBLANK(N1),\"\",VLOOKUP(N1,joueurs,IF(lettreTypeElo=\"R\",8,IF(lettreTypeElo=\"B\",10,6)),FALSE)&\" \"&VLOOKUP(N1,joueurs,IF(lettreTypeElo=\"R\",9,IF(lettreTypeElo=\"B\",11,7)),FALSE))","v":""},{"$f":"IF(ISBLANK(N1),\"\",LEFT(VLOOKUP(N1,joueurs,5,FALSE),3))","v":""},{"$f":"IF(ISBLANK(N1),\"\",RIGHT(VLOOKUP(N1,joueurs,5,FALSE),1))","v":""},{"$f":"IF(ISBLANK(N1),\"\",TEXT(VLOOKUP(N1,joueurs,4,FALSE),\"jj/mm/aa\"))","v":""},null,{"$f":"IF(ISBLANK(N1),\"\",_xlfn.NUMBERVALUE(IF(RIGHT(O1,1)=\"N\",IF(MOD(LEFT(O1,4)+1,10)=0,IF((eloNC=0),LEFT(O1,4),eloNC),LEFT(O1,4)),LEFT(O1,4)),\".\",\" \"))","v":""},{"$f":" IF(ISBLANK(N1),\"\",UPPER(N1) & \" \" & M1 & \"-\" & P1 & Q1 & \"-\" & O1)","v":""},{"$f":" IF(ISBLANK(N1),\"\", M1 & \"-\" & P1 & Q1 &\"-\" & O1)","v":""}]
[null,null,null,{"$f":"lieu","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elo corrigé","info pour feuille de match","info simplifiée pour equipes"]
["FMronde",null,null,null,"Ronde","n","rangée","r",null,"LTentete","nom équipe","N°","Nom","NrFFE","Elo","Cat.","F/M","Né(e) le","Commentaire"]
["FMenteteEquipe","Equipe ayant les BLANCS sur le premier échiquier",null,null,null,"Equipe ayant les NOIRS sur le premier échiquier"]
[null,"code","Nom équipe",null,null,"code","Nom équipe",null,null,"btPrint"]
["FMenteteJoueur","Table","B/N","Nom","Résultat",null,"Nom","B/N"]
["FMjoueur",1,"B",null,null,null,null,"N"]
["FMsignatures","Nom du capitaine et signature :",null,null,null,null,"Nom du capitaine et signature :",null,null,"consigneAppariements"]
[null,{"$f":"\"signature arbitre : \" & arbitre","v":"signature arbitre : "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"consigneEquipes3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"consigneListeType2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"consigneNonLicencies"]