{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Comment utiliser","Joueurs","Classement","R1","Détail-R1","R2","Détail-R2","R3","Détail-R3","R4","Détail-R4","R5","Détail-R5","R6","Détail-R6","R7","Détail-R7","R8","Détail-R8","R9","Détail-R9","PASTOUCHE","A propos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Comment utiliser","index":0,"n_rows":86,"n_cols":4,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,"Petit outil de gestion de tournoi"]
[]
[null,"Guide d'utilisation rapide"]
[null,"1.","Remplissez l'onglet \"Joueurs\" avant de démarrer le tournoi, avec les informations des participants."]
[null,"2.","Cliquez sur le bouton \"GESTION DU TOURNOI\" et choisissez \"apparier la ronde 1\""]
[null,null,"Le résultat de l'appariement est disponible dans l'onglet R1. S'il ne vous plaît pas vous pouvez le changer."]
[null,"3.","A la fin des parties, saisissez les résultats \"score\" et \"départage\"."]
[null,null,"\"score\" dépend de votre mode de tournoi. Certains tournois font victoire3pts/égalité1pt/défaite0pt"]
[null,null,"d'autres font des scores sur 20  (par exemple 16-4), d'autres ont leur propre système de points."]
[null,null,"Saisissez en fonction de votre propre barème, il n'y a pas de contrainte."]
[null,null,"\"départage\" permet d'enregistrer une valeur qui départagera les égalités au classement."]
[null,null,"Cela peut être le \"score de poutre\" (nb de pts d'armée détruites), ou tout autre système de déparatage"]
[null,null,"à la discrétion de l'organisateur. Si vous n'utilisez pas de départage, mettez \"0\"."]
[null,"4.","Lorsque tous les résultats sont saisis, cliquez sur \"GESTION DU TOURNOI\" et faites \"Mettre à jour classement\""]
[null,null,"L'outil vous met à jour le classement dans l'onglet classement."]
[null,"5.","Répétez les étapes 3. et 4. autant de fois qu'il y a de ronde dans votre tournoi"]
[]
[]
[null,"FAQ"]
[null,"Fonctionnement par équipe ou fonctionnement individuel ?"]
[null,null,"L'outil fait les deux."]
[null,null,"Quand vous lancez \"gestion du tournoi\", il vous propose de basculer d'un affichage \"individuel\" à un affichage \"par équipe\"."]
[null,null,"Le mode par équipe apporte des onglets supplémentaires pour contenir le détail des matchs par équipe (sur la base "]
[null,null,"du modèle des matchs par 8 du jeu Warhammer 40000). Ces onglets supplémentaires sont facultatifs. Ils sont là juste pour "]
[null,null,"consigner les détails des parties mais si on ne les remplit pas, l'outil marche très bien sans. Dans un fonctionnement par équipe, "]
[null,null,"l'outil traite chaque \"équipe\" comme un \"joueur\". Le fait de demander un affichage par équipe ou un affichage individuel ne fait "]
[null,null,"que des changements d'affichage. Aucune autre information n'est modifiée."]
[]
[null,"Comment fonctionne l'appariement ?"]
[null,null,"Lorsqu'on fait \"appairer la ronde X\", l'outil regarde la liste des joueurs, les rondes précédentes et le classement."]
[null,null,"Pour la ronde 1, c'est un appariement 100% aléatoire."]
[null,null,"Pour les rondes suivantes, il prend le premier joueur du classement et l'appaire avec le premier meilleur adversaire"]
[null,null,"qu'il n'a pas déjà rencontré. Puis il répète cette étape pour le premier joueur du classement non encore appairé."]
[null,null,"En cas de nombre impair il donne le BYE au dernier joueur du classement n'ayant pas encore eu le Bye."]
[]
[null,"Est-ce que je peux modifier un appariement? "]
[null,null,"Oui. Une fois l'appariement fait par l'outil, rien n'interdit de le changer à la main."]
[null,null,"Attention, il n'y aura pas de contrôle sur ce que vous faites."]
[null,null,"Vous devrez être vigilants à ne pas faire se rencontrer deux fois des joueurs s'étant déjà affrontés."]
[null,null,"Vous devrez aussi être vigilants au fait de taper exactement le nom du joueur (si vous l'orthographiez mal il ne sera plus détecté…)"]
[]
[null,"Comment gérer le cas d'un joueur qui abandonne ?"]
[null,null,"Deux possibilités :"]
[null,null,"1.","Vu que lorsqu'on fait un appariement, on prend la liste des joueurs, si vous enlevez un joueur de cette liste, il ne sera plus appairé."]
[null,null,null,"Inconvénient, il n'apparaîtra plus non plus dans le classement."]
[null,null,"2.","Faites l'appariement et donnez lui le BYE à chaque fois."]
[null,null,null,"\"BYE\" est un mot-clef à mettre dans la case du nom de l'adversaire."]
[]
[null,"Peut-on rajouter un joueur en cours de route? "]
[null,null,"Oui, ajoutez le dans la liste des joueurs. Pour chaque ronde, ajoutez une ligne où ce joueur a joué un match contre \"BYE\" et a marqué 0 pt."]
[null,null,"S'il y a déjà un nb impair, mettez le à la place du BYE et donnez lui 0 pt."]
[null,null,"Si vous voulez ajouter 2 joueurs, ajoutez-les dans la feuille joueur, et mettez un match entre ces 2 joueurs à chaque ronde avec 0 pt chacun."]
[]
[null,"L'outil ne me propose pas d'appairer la ronde suivante, pourquoi ?"]
[null,null,"Une seule raison : il manque des résultats à la ronde en cours."]
[null,null,"Pour tous les matchs, vous devez saisir score et départage. Et pour un éventuel BYE aussi (mettez 0 et 0)."]
[]
[null,"Lorsque je met à jour le classement les résultats de ma dernière ronde ne sont pas pris en compte, pourquoi ?"]
[null,null,"Une seule raison : vous n'avez pas saisi tous les résultats."]
[]
[null,"L'outil m'affiche un message que je ne comprends pas où il parle de perdre des rondes déjà faites, je ne comprends pas."]
[null,null,"Une seule raison : vous avez déjà joué/saisi des résultats pour X rondes, et vous lui avez demandé d'appairer une ronde déjà jouée."]
[null,null,"Genre par exemple, vous avez laissé coché le bouton \"ronde 1\" alors que vous en êtes à la ronde 5."]
[null,null,"L'outil peut faire ça. Mais il vous met un gros avertissement, parceque si c'est vraiment ce que vous voulez faire, vous allez"]
[null,null,"perdre tout ce qui s'est passé depuis la ronde 1."]
[]
[null,"Comment je peux faire pour avoir le classement après chaque ronde ?"]
[null,null,"Le classement se calcule pour toutes les rondes complètes."]
[null,null,"Si vous avez joué 3 rondes et saisi tous les résultats, le classement vous donnera les positions après 3 rondes."]
[null,null,"Il n'y a pas de fonction pour calculer le classement après 2 rondes si vous en avez joué 3."]
[null,null,"Si vous voulez garder les classements intermédiaires, faites des copies de la feuille classement avant de passer à la ronde suivante."]
[]
[null,"C'est quoi la fonction \"vérifier la cohérence des rondes passées\" ?"]
[null,null,"Si vous cochez cette option et faites \"appairer\", l'outil va regarder les rondes passées et vérifier que la liste des joueurs lui conviens."]
[null,null,"Ca prend un peu de temps (en fonction de votre machine, du nombre de joueurs et du nombre de rondes) mais c'est une petite vérification"]
[null,null,"qui ne mange pas de pain. Si quoi que ce soit de louche est détecté, vous aurez un petit message informatif expliquant l'élément détecté."]
[null,null,"C'est une sécurité, et sauf problème de performances, je vous conseille de toujours cocher cette option."]
[]
[null,"Gestion des conflits"]
[null,null,"Faire de bons appariements n'est pas simple. Au bout d'un moment, il faut s'assurer que les joueurs ne se rencontrent pas une seconde fois."]
[null,null,"L'algorithme d'appariement est donc compliqué, et refait le travail plusieurs fois."]
[null,null,"Pour éviter d'exploser les perfos et de limiter les recherches, un \"seuil\" a été défini dans l'onglet \"pastouche\"."]
[null,null,"Vous pouvez bouger ce seuil, que je propose de placer à 30. Avec cette valeur, il permet de limiter le nombre de fois où on essaie une nouvelle"]
[null,null,"combinaison d'appariement."]
[null,null,"Si l'outil vous dit qu'il ne sait pas appairer une nouvelle ronde parcequ'il n'a plus de combinaison, essayez de remonter un peu ce seuil et de"]
[null,null,"recommencer. Ne le placez pas d'entrée à une valeur extrèmement élevée (10000) car votre PC risque de tourner un trop long moment."]

{"sheet":"Joueurs","index":1,"n_rows":403,"n_cols":10,"rows_kept":403,"cut":false,"hidden":false,"merged":[]}
["toto","Informations sur les joueurs"]
["titi","Instructions pour bien utiliser cette feuille :"]
["tata","Complétez la au début du tournoi, puis ne revenez pas dessus"]
["tutu","Ne mettez pas 2 pseudos identiques. Commencez en première ligne, ne"]
[null,"laissez pas de ligne vide entre 2 joueurs, ne laissez pas de joueur sans pseudo. Vous pouvez mettre autant de colonnes que vous voulez "]
[null,"Tous les pseudos doivent être différents. N'insérez pas de ligne, ne touchez pas à la colonne masquée \"A\""]
[null,"Joueur","Armée","Autre info","Autre info","Autre info","Autre info","Autre info","Autre info","Autre info"]
[{"$f":"IF(B8<>\"\",1,\"\")","v":1},"a","DA"]
[{"$f":"IF(B9<>\"\",A8+1,\"\")","v":2},"b","SM"]
[{"$f":"IF(B10<>\"\",A9+1,\"\")","v":3},"c","BA"]
[4,"d","SMC"]
[5,"e","TY"]
[6,"f","TAU"]
[7,"g","EN"]
[8,"h","GI"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B74<>\"\",A73+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B138<>\"\",A137+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B202<>\"\",A201+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B266<>\"\",A265+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B330<>\"\",A329+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B394<>\"\",A393+1,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Classement","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Classement"]
[]
["Joueur","Armée","Score","Départage"]

{"sheet":"R1","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°1"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]
[2,"c","f"]
[3,"d","a"]
[1,"b","h"]
[4,"g","e"]

{"sheet":"Détail-R1","index":4,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 1"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R2","index":5,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°2"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R2","index":6,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 2"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R3","index":7,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°3"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R3","index":8,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 3"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R4","index":9,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°4"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R4","index":10,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 4"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R5","index":11,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°5"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R5","index":12,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 5"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R6","index":13,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°6"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R6","index":14,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 6"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R7","index":15,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°7"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R7","index":16,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 7"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R8","index":17,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°8"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R8","index":18,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 8"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"R9","index":19,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Ronde n°9"]
[]
["Table","Joueur 1","Joueur 2","Score J1","Score J2","Dép J1","Dép J2"]

{"sheet":"Détail-R9","index":20,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"DETAIL DES PARTIES DE LA RONDE 9"]
[null,"Cette saisie n'est faite qu'à titre indicatif. Il faut reporter les pts de partie et de match dans l'onglet principal de la ronde\nRemplir uniquement les cases en jaune. Un exemple pré-rempli est dispo en bas de page"]
[]
[null,null,"Match table #1"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D7+E7","v":0},0,{"$f":"F7+G7","v":0},{"$f":"J7+K7","v":20},0,{"$f":"L7+M7","v":20},{"$f":"0-E7","v":0},{"$f":"20-D7","v":20},null,2,{"$f":"IF(H7+I7<>20,\"total différent de 20\",\"\")","v":""}]
[null,4,null,null,null,{"$f":"D8+E8","v":0},0,{"$f":"F8+G8","v":0},{"$f":"J8+K8","v":20},0,{"$f":"L8+M8","v":20},{"$f":"0-E8","v":0},{"$f":"20-D8","v":20},null,3,{"$f":"IF(H8+I8<>20,\"total différent de 20\",\"\")","v":""}]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6,""]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7,""]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10,""]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11,""]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14,""]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C",""]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I14)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H16<75,0,IF(H16<86,1,2))","v":0},{"$f":"IF(I16<75,0,IF(I16<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #2"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D22+E22","v":0},0,{"$f":"F22+G22","v":0},{"$f":"J22+K22","v":20},0,{"$f":"L22+M22","v":20},{"$f":"0-E22","v":0},{"$f":"20-D22","v":20},null,2]
[null,4,null,null,null,{"$f":"D23+E23","v":0},0,{"$f":"F23+G23","v":0},{"$f":"J23+K23","v":20},0,{"$f":"L23+M23","v":20},{"$f":"0-E23","v":0},{"$f":"20-D23","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H22:H29)","v":0},{"$f":"SUM(I22:I29)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H31<75,0,IF(H31<86,1,2))","v":0},{"$f":"IF(I31<75,0,IF(I31<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #3"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D37+E37","v":0},0,{"$f":"F37+G37","v":0},{"$f":"J37+K37","v":20},0,{"$f":"L37+M37","v":20},{"$f":"0-E37","v":0},{"$f":"20-D37","v":20},null,2]
[null,4,null,null,null,{"$f":"D38+E38","v":0},0,{"$f":"F38+G38","v":0},{"$f":"J38+K38","v":20},0,{"$f":"L38+M38","v":20},{"$f":"0-E38","v":0},{"$f":"20-D38","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H37:H44)","v":0},{"$f":"SUM(I37:I44)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H46<75,0,IF(H46<86,1,2))","v":0},{"$f":"IF(I46<75,0,IF(I46<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Match table #4"]
[]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,null,null,null,{"$f":"D52+E52","v":0},0,{"$f":"F52+G52","v":0},{"$f":"J52+K52","v":20},0,{"$f":"L52+M52","v":20},{"$f":"0-E52","v":0},{"$f":"20-D52","v":20},null,2]
[null,4,null,null,null,{"$f":"D53+E53","v":0},0,{"$f":"F53+G53","v":0},{"$f":"J53+K53","v":20},0,{"$f":"L53+M53","v":20},{"$f":"0-E53","v":0},{"$f":"20-D53","v":20},null,3]
[null,5,null,null,null,0,0,0,20,0,20,0,20,null,6]
[null,8,null,null,null,0,0,0,20,0,20,0,20,null,7]
[null,9,null,null,null,0,0,0,20,0,20,0,20,null,10]
[null,12,null,null,null,0,0,0,20,0,20,0,20,null,11]
[null,13,null,null,null,0,0,0,20,0,20,0,20,null,14]
[null,"C",null,null,null,0,0,0,20,0,20,0,20,null,"C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H52:H59)","v":0},{"$f":"SUM(I52:I59)","v":160},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H61<75,0,IF(H61<86,1,2))","v":0},{"$f":"IF(I61<75,0,IF(I61<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]
[]
[null,null,"Exemple de table remplie :"]
[null,null,"Team : L'oignon fait la force",null,null,null,null,null,null,null,null,null,null,"Team : N104"]
[null,null,"Joueur + armée(s)","pts scénar","pts poutre","total","pénalités","total final","total final","pénalités","total","pts poutre","pts scénar","Joueur + armée(s)"]
[null,1,"Towpypy",13,3,{"$f":"D67+E67","v":16},0,{"$f":"F67+G67","v":16},{"$f":"J67+K67","v":4},0,{"$f":"L67+M67","v":4},{"$f":"0-E67","v":-3},{"$f":"20-D67","v":7},"Barbouille",2]
[null,4,"Azeradan",5,-3,{"$f":"D68+E68","v":2},0,{"$f":"F68+G68","v":2},{"$f":"J68+K68","v":18},0,{"$f":"L68+M68","v":18},{"$f":"0-E68","v":3},{"$f":"20-D68","v":15},"Flo",3]
[null,5,"Chaeron",9,0,9,0,9,11,0,11,0,11,"Saebjorn",6]
[null,8,"Undead tyty",13,3,16,0,16,4,0,4,-3,7,"Byolix",7]
[null,9,"Dletch",5,-1,4,0,4,16,0,16,1,15,"Franssoué",10]
[null,12,"Tarasboula",12,0,12,0,12,8,0,8,0,8,"Salgin",11]
[null,13,"Judi",3,-3,0,0,0,20,0,20,3,17,"Doudou",14]
[null,"C","Xenos77",11,1,12,0,12,8,0,8,-1,9,"Ranek","C"]
[]
[null,null,null,null,"Total pts de partie",null,null,{"$f":"SUM(H67:H74)","v":71},{"$f":"SUM(I67:I74)","v":89},null,null,"Total pts de partie"]
[null,null,null,null,"Pts de tournoi",null,null,{"$f":"IF(H76<75,0,IF(H76<86,1,2))","v":0},{"$f":"IF(I76<75,0,IF(I76<86,1,2))","v":2},null,null,"Pts de tournoi",null,"0-74 => 0 / 75-85 => 1 / 86+ => 2"]

{"sheet":"PASTOUCHE","index":21,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"PASTOUCHE"]
["Cette feuille contient des données qui sont sauvegardées entre 2 exécutions de l'outil. Merci, comme son nom l'indique, de ne pas la modifier"]
["NBPLAYERS",8]
["NEXTROUND",1]
["SEUIL CONFLITS",30,"nb de tentatives de refaire un appariement en cas de conflit avant de s'arrêter. "]

{"sheet":"A propos","index":22,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["A propos"]
["Petit outil développé pour l'assoc' QUALIF-ETC de Warhammer 40000 par madBiker"]
["Pour contacter l'auteur en cas de question, merci de passer par le forum www.warhammer-forum.com et de lui envoyer un message privé."]
["Ce petit outil a été fait pour répondre à un besoin précis, avec du temps bénévole. Si vous vous en servez pour gérer un tournoi, assurez-vous"]
["de l'avoir convenablement pris en main en le testant au moins une fois avant de vous en servir le jour J."]
[]
["Versions"]
["0.1","2014-01-05","Première version"]
["0.2","2014-01-07","Mise en place de la gestion des conflits. Sélection automatique de la dernière ronde. Fonction de vérification des rondes passées"]
["1.0","2014-01-07","Ajout de l'aléa dans les tables. Première version pour utilisation"]
["1.1","2014-01-09","Correction de la mise à jour des listes intermédiaires pour la résolution des conflits. Correction de l'initialisation de la fonction d'aléa."]
[null,null,"Ajout d'un seuil pour la gestion des conflits."]
["1.2","2014-01-10","Correction de la gestion des conflits pour protéger le fait de reprendre le bye dans les permutations possibles."]
["1.3","2014-02-11","Ajout de sous-sections spécifiques à la collecte des résultats de matchs par équipe."]
["1.4","2014-02-17","Correction d'un bug : lors d'une permutation pour résoudre un conflit, on vérifiait juste qu'on était pas sur un cas d'impossibilité, mais on ne vérifiait pas qu'il n'y avait pas eu pairing entre les 2 joueurs appairés."]
[null,null,"Ajout d'un mode de bascule de l'affichage par équipe ou individuel"]
[]
["Choses à faire"]
["Onglets pour la gestion des matchs par équipe."]