{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inscrit","Tirage","Veteran"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":8,"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":"Inscrit","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Clubs & Compétiteurs              "]
[]
[]
[null,null,null,null,null,null,null,null,null,"Nombre total d'équipes inscrites"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(B7:I14,\">\"\"\")","v":2}]
[]
[null,null,null,"K"]
[]
[null,null,null,null,null,null,"M"]
[]
[]
[]
[null,"Tirage 1"]
[null,1,2,3,4,5,6,7,8]
[null,null,"K"]
[null,null,null,null,null,null,"M"]

{"sheet":"Tirage","index":1,"n_rows":21,"n_cols":404,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,6,15,13],[9,6,9,13],[4,6,4,13]]}
[]
[null," \"Tirage\""]
[]
[null,null,null,"Tirage 2","Tirage 3"]
[null,"N°","Participants","Jeu ","Jeu ",null,"Jeux  partie 1"]
[null,1,{"$f":"IFERROR(    _xlfn.FILTERXML(\"<x><t>\"&_xlfn.TEXTJOIN(\"</t><t>\",TRUE,TRANSPOSE(Inscrit!B7:I14))&\"</t></x>\",\"//t\"),\"\")","v":"K"},null,null,null,1,2,3,4,5,6,7,8]
[null,2,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melmoux"]
[null,3]
[null,4]
[null,5,null,null,null,null,"Jeux  partie 2"]
[null,6,null,null,null,null,1,2,3,4,5,6,7,8]
[null,7,null,null,null,null,"Perdant P1","Perdant P1","Gagnant P1","Gagnant P1","Gagnant P1","Gagnant P1","Perdant P1","Perdant P1"]
[null,8,null,null,null,null,{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=G$11,ROW($D$1:$D$21)),ROW(A1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=H$11,ROW($D$1:$D$21)),ROW(B1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=I$11,ROW($D$1:$D$21)),ROW(C1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=J$11,ROW($D$1:$D$21)),ROW(D1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=K$11,ROW($D$1:$D$21)),ROW(E1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=L$11,ROW($D$1:$D$21)),ROW(F1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=M$11,ROW($D$1:$D$21)),ROW(G1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=N$11,ROW($D$1:$D$21)),ROW(H1)),1),\"\")","v":""}]
[null,9,null,null,null,null,{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=G$11,ROW($D$1:$D$21)),ROW(A2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=H$11,ROW($D$1:$D$21)),ROW(B2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=I$11,ROW($D$1:$D$21)),ROW(C2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=J$11,ROW($D$1:$D$21)),ROW(D2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=K$11,ROW($D$1:$D$21)),ROW(E2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=L$11,ROW($D$1:$D$21)),ROW(F2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=M$11,ROW($D$1:$D$21)),ROW(G2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($D$1:$D$21=N$11,ROW($D$1:$D$21)),ROW(H2)),1),\"\")","v":""}]
[null,10]
[null,11,null,null,null,null,"Jeux  partie 3"]
[null,12,null,null,null,null,1,2,3,4,5,6,7,8]
[null,13,null,null,null,null,"Perdant P1","Perdant P1","Gagnant P1","Gagnant P1","Gagnant P1","Gagnant P1","Perdant P1","Perdant P1"]
[null,14,null,null,null,null,"Perdant P2","Gagnant P2","Perdant P2","Gagnant P2","Gagnant P2","Perdant P2","Gagnant P2","Perdant P2"]
[null,15,null,null,null,null,{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=G$17,ROW($E$1:$E$21)),ROW(A1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=H$17,ROW($E$1:$E$21)),ROW(B1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=I$17,ROW($E$1:$E$21)),ROW(C1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=J$17,ROW($E$1:$E$21)),ROW(D1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=K$17,ROW($E$1:$E$21)),ROW(E1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=L$17,ROW($E$1:$E$21)),ROW(F1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=M$17,ROW($E$1:$E$21)),ROW(G1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=N$17,ROW($E$1:$E$21)),ROW(H1)),1),\"\")","v":""}]
[null,16,null,null,null,null,{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=G$17,ROW($E$1:$E$21)),ROW(A2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=H$17,ROW($E$1:$E$21)),ROW(B2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=I$17,ROW($E$1:$E$21)),ROW(C2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=J$17,ROW($E$1:$E$21)),ROW(D2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=K$17,ROW($E$1:$E$21)),ROW(E2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=L$17,ROW($E$1:$E$21)),ROW(F2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=M$17,ROW($E$1:$E$21)),ROW(G2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$1:$C$21,SMALL(IF($E$1:$E$21=N$17,ROW($E$1:$E$21)),ROW(H2)),1),\"\")","v":""}]

{"sheet":"Veteran","index":2,"n_rows":29,"n_cols":46,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,40,3,45],[1,1,1,7],[1,11,1,14],[2,1,2,7],[2,11,2,13],[3,26,3,31],[4,1,5,1],[4,2,4,4],[4,5,5,5],[4,6,5,6],[4,7,4,9],[5,3,5,4],[5,8,5,9],[4,37,5,37],[4,38,5,38],[4,20,5,20],[4,21,5,21],[4,24,5,24],[4,25,5,25],[4,26,5,27],[4,28,5,28],[4,10,5,10],[4,40,5,40],[4,42,5,42],[4,43,5,43],[4,44,5,44],[5,13,5,14],[4,29,5,31],[4,33,5,33],[4,11,5,11],[4,12,4,14],[4,15,5,15],[4,16,5,16],[4,18,5,18],[4,19,5,19],[4,35,5,35],[4,36,5,36],[4,45,5,45],[9,26,10,27],[9,29,10,31],[6,1,7,1],[6,6,7,6],[6,11,7,11],[6,24,7,24],[6,25,13,25],[6,26,7,27],[10,33,10,38],[12,1,13,1],[12,6,13,6],[12,11,13,11],[12,24,13,24],[12,26,13,27],[12,29,13,31],[9,1,10,1],[9,6,10,6],[9,11,10,11],[9,24,10,24],[12,37,13,37],[12,33,13,33],[12,35,13,35],[12,36,13,36],[6,28,13,28],[6,29,7,31],[12,38,13,38],[15,1,16,1],[15,6,16,6],[15,11,16,11],[16,24,16,26],[18,1,19,1],[18,6,19,6],[18,11,19,11],[18,24,18,26],[19,24,19,26],[27,1,28,1],[27,6,28,6],[27,11,28,11],[22,27,22,29],[24,1,25,1],[24,6,25,6],[24,11,25,11],[24,24,24,26],[24,27,24,29],[21,1,22,1],[21,6,22,6],[21,11,22,11],[22,24,22,26]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"\"\"   BOULES"]
[null,"CONCOURS VETERANS",null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2023-08-20T09:30:00.320"},null,null,{"$f":"TIME(HOUR(NOW()),MINUTE(NOW()),0)","v":"09:30:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classement \"Dernier\"ex-aequo"]
[null,"Jeu"," Partie 1",null,null,null,"Jeu","Partie 2",null,null,null,"Jeu","Partie 3",null,null,null,"Rang",null,"Delta","Total","Partie 3 gagnée ","Val H ",null,null,"Partie",null,"Début",null,null,"Fin",null,null,null,null,null,null,null,null,null,null,"Rang",null,"Delta","Total","Partie 3 gagnée ","Val H "]
[null,null,"Nom","Score",null,null,null,"Nom","Score",null,null,null,"Nom","Score"]
[null,1,null,null,null,null,1,null,null,null,null,1,null,null,null,null,{"$f":"IF(M7&N7<>\"\",MATCH(T7,_xlfn._xlws.SORT(_xlfn.VSTACK(T7,T8,T28,T29),,-1),0),\"\")","v":""},null,{"$f":"N7-O7","v":0},{"$f":"N7+S7+V7","v":0},{"$f":"IF(N7>O7,1,0)","v":0},{"$f":"IF(U7=1,100,0)","v":0},null,null,1,null,{"$f":"IF(AB20=\"\",\"\",AB20)","v":"13:30:00"},null,null,{"$f":"IF(AA7=\"\",\"\",AA7+AB19)","v":"15:00:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7&N7<>\"\",MATCH(AR7,_xlfn._xlws.SORT(_xlfn.VSTACK(AR7,AR8,AR28,AR29),,-1),0),\"\")","v":""},null,{"$f":"(D7+I7+N7)-(E7+J7+O7)","v":0},{"$f":"U7+AQ7+AT7","v":0},{"$f":"U7","v":0},{"$f":"IF(AS7=1,100,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M8&N8<>\"\",MATCH(T8,_xlfn._xlws.SORT(_xlfn.VSTACK(T7,T8,T28,T29),,-1),0),\"\")","v":""},null,{"$f":"N8-O8","v":0},{"$f":"N8+S8+V8","v":0},{"$f":"IF(N8>O8,1,0)","v":0},{"$f":"IF(U8=1,100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M8&N8<>\"\",MATCH(AR8,_xlfn._xlws.SORT(_xlfn.VSTACK(AR7,AR8,AR28,AR29),,-1),0),\"\")","v":""},null,{"$f":"(D8+I8+N8)-(E8+J8+O8)","v":0},{"$f":"U8+AQ8+AT8","v":0},{"$f":"U8","v":0},{"$f":"IF(AS8=1,100,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N9=\"\",\"\",IF(M9<>\"\",COUNTIFS(M$7:M$29,\"<>\",T$7:T$29,\">\"&T9)+1,\"\"))","v":""}]
[null,2,"K",null,null,null,2,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"IF(AD20=\"\",\"\",AD20)","v":"15:20:00"},null,null,{"$f":"IF(AA10=\"\",\"\",AA10+AD19)","v":"16:50:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classement \"Premier ex-aequo\""]
[]
[null,3,null,null,null,null,3,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"IF(AF20=\"\",\"\",AF20)","v":"17:15:00"},null,null,{"$f":"IF(AA13=\"\",\"\",AA13+AF19)","v":"18:45:00"},null,null,null,"Rang",null,"Delta","Total","Partie 3 gagnée ","Val H "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N15=\"\",\"\",IF(M15<>\"\",COUNTIFS(M$16:M$20,\"<>\",T$16:T$20,\">\"&T15)+1,\"\"))","v":""}]
[null,4,null,null,null,null,4,null,null,null,null,4,null,null,null,null,{"$f":"IF(N16=\"\",\"\",IF(M16<>\"\",COUNTIFS(M$16:M$20,\"<>\",T$16:T$20,\">\"&T16)+1,\"\"))","v":""},null,{"$f":"N16-O16","v":0},{"$f":"N16+V16+S16","v":0},{"$f":"IF(N16>O16,1,0)","v":0},{"$f":"IF(U16=1,100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M16=\"\",\"\",IF(N16<>\"\",COUNTIFS(M$16:M$20,\"<>\",AK$16:AK$20,\">\"&AK16)+1,\"\"))","v":""},null,{"$f":"(D16+I16+N16)-(E16+J16+O16)","v":0},{"$f":"(N16+AJ16+AM16)","v":0},{"$f":"U16","v":0},{"$f":"V16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N17=\"\",\"\",IF(M17<>\"\",COUNTIFS(M$16:M$20,\"<>\",T$16:T$20,\">\"&T17)+1,\"\"))","v":""},null,{"$f":"N17-O17","v":0},{"$f":"N17+V17+S17","v":0},{"$f":"IF(N17>O17,1,0)","v":0},{"$f":"IF(U17=1,100,0)","v":0},null,null,"Partie",null,null,1,"13:30:00",2,null,3,null,{"$f":"IF(M17=\"\",\"\",IF(N17<>\"\",COUNTIFS(M$16:M$20,\"<>\",AK$16:AK$20,\">\"&AK17)+1,\"\"))","v":""},null,{"$f":"(D17+I17+N17)-(E17+J17+O17)","v":0},{"$f":"(N17+AJ17+AM17)","v":0},{"$f":"U17","v":0},{"$f":"V17","v":0}]
[]
[null,5,null,null,null,null,5,null,null,null,null,5,null,null,null,null,"",null,{"$f":"N19-O19","v":0},{"$f":"N19+V19+S19","v":0},{"$f":"IF(N19>O19,1,0)","v":0},{"$f":"IF(U19=1,100,0)","v":0},null,null,"Durée",null,null,"01:30:00",null,"01:30:00",null,"01:30:00",null,{"$f":"IF(M19=\"\",\"\",IF(N19<>\"\",COUNTIFS(M$16:M$20,\"<>\",AK$16:AK$20,\">\"&AK19)+1,\"\"))","v":""},null,{"$f":"(D19+I19+N19)-(E19+J19+O19)","v":0},{"$f":"(N19+AJ19+AM19)","v":0},{"$f":"U19","v":0},{"$f":"V19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"N20-O20","v":0},{"$f":"N20+V20+S20","v":0},{"$f":"IF(N20>O20,1,0)","v":0},{"$f":"IF(U20=1,100,0)","v":0},null,null,"Début",null,null,"13:30:00","00:30:00","15:20:00",null,"17:15:00",null,{"$f":"IF(M20=\"\",\"\",IF(N20<>\"\",COUNTIFS(M$16:M$20,\"<>\",AK$16:AK$20,\">\"&AK20)+1,\"\"))","v":""},null,{"$f":"(D20+I20+N20)-(E20+J20+O20)","v":0},{"$f":"(N20+AJ20+AM20)","v":0},{"$f":"U20","v":0},{"$f":"V20","v":0}]
[]
[null,6,null,null,null,null,6,null,null,null,null,6]
[null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Programmation",null,null,"Gagnant",null,null,null,13]
[]
[null,7,null,null,null,null,7,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,"Office",null,null,"Perdant",null,null,null,6]
[]
[]
[null,8,null,null,null,null,8,null,null,null,null,8,null,null,null,null,{"$f":"IF(M28&N28<>\"\",MATCH(T28,_xlfn._xlws.SORT(_xlfn.VSTACK(T7,T8,T28,T29),,-1),0),\"\")","v":""},null,{"$f":"N28-O28","v":0},{"$f":"N28+S28+V28","v":0},{"$f":"IF(N28>O28,1,0)","v":0},{"$f":"IF(U28=1,100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M28&N28<>\"\",MATCH(AR28,_xlfn._xlws.SORT(_xlfn.VSTACK(AR7,AR8,AR28,AR29),,-1),0),\"\")","v":""},null,{"$f":"(D28+I28+N28)-(E28+J28+O28)","v":0},{"$f":"U28+AQ28+AT28","v":0},{"$f":"U28","v":0},{"$f":"IF(AS28=1,100,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29&N29<>\"\",MATCH(T29,_xlfn._xlws.SORT(_xlfn.VSTACK(T7,T8,T28,T29),,-1),0),\"\")","v":""},null,{"$f":"N29-O29","v":0},{"$f":"N29+S29+V29","v":0},{"$f":"IF(N29>O29,1,0)","v":0},{"$f":"IF(U29=1,100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29&N29<>\"\",MATCH(AR29,_xlfn._xlws.SORT(_xlfn.VSTACK(AR7,AR8,AR28,AR29),,-1),0),\"\")","v":""},null,{"$f":"(D29+I29+N29)-(E29+J29+O29)","v":0},{"$f":"U29+AQ29+AT29","v":0},{"$f":"U29","v":0},{"$f":"IF(AS29=1,100,0)","v":0}]