{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["P1"],"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":"P1","index":0,"n_rows":103,"n_cols":26,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[23,6,24,6],[69,7,69,25],[69,2,69,5],[69,6,70,6],[3,8,3,10],[15,6,16,6],[63,6,64,6],[31,6,32,6],[39,6,40,6],[47,6,48,6],[55,6,56,6]]}
[null,null,null,null,null,null,3]
["CHAMPIONNAT DES CLUBS"]
[]
["POULE 1"]
["EQUIPES",null,"POINTS","Pour","Contre","Diff"]
["AA","1A",{"$f":"SUMIF($A$18:$A$69,A6,$E$18:$E$69)+SUMIF($C$18:$C$69,A6,$F$18:$F$69)","v":15},{"$f":"SUMIF($A$18:$A$69,$A6,$B$18:$B$69)+SUMIF($C$18:$C$69,$A6,$D$18:$D$69)","v":124},{"$f":"SUMIF($C$18:$C$69,$A6,$B$18:$B$69)+SUMIF($A$18:$A$69,$A6,$D$18:$D$69)","v":128},{"$f":"D6-E6","v":-4}]
["AB","1B",{"$f":"SUMIF($A$18:$A$69,A7,$E$18:$E$69)+SUMIF($C$18:$C$69,A7,$F$18:$F$69)","v":14},{"$f":"SUMIF($A$18:$A$69,$A7,$B$18:$B$69)+SUMIF($C$18:$C$69,$A7,$D$18:$D$69)","v":130},{"$f":"SUMIF($C$18:$C$69,$A7,$B$18:$B$69)+SUMIF($A$18:$A$69,$A7,$D$18:$D$69)","v":122},8]
["AC","1C",{"$f":"SUMIF($A$18:$A$69,A8,$E$18:$E$69)+SUMIF($C$18:$C$69,A8,$F$18:$F$69)","v":15},114,138,-24]
["AD","1D",11,100,152,-52]
["AE","1E",15,140,112,28]
["AF","1F",15,128,124,4]
["AG","1G",15,150,102,{"$f":"D12-E12","v":48}]
["AH","1H",12,{"$f":"SUMIF($A$18:$A$69,$A13,$B$18:$B$69)+SUMIF($C$18:$C$69,$A13,$D$18:$D$69)","v":122},130,{"$f":"D13-E13","v":-8}]
[]
["1er MATCH le ","à","AA"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AA",16,"AB",{"$f":"IF(G18=19,19,IF(ISBLANK(B18),\"\",IF(B18=19,0,36-B18)))","v":20},{"$f":"IF(G18=19,0,IF(ISBLANK(B18),\"\",IF(B18<18,1,IF(B18=18,2,IF(B18>18,3)))))","v":1},{"$f":"IF(G18=19,3,IF(ISBLANK(B18),\"\",IF(B18=19,0,IF(D18<18,1,IF(D18=18,2,IF(D18>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B18>D18,A18&C18,IF(D18>B18,C18&A18,\"/\"))","v":"ABAA"},null,{"$f":"A18&C18","v":"AAAB"},{"$f":"E18","v":1},{"$f":"C18&A18","v":"ABAA"},{"$f":"F18","v":3},{"$f":"B18","v":16},{"$f":"D18","v":20}]
["AC",30,"AD",{"$f":"IF(G19=19,19,IF(ISBLANK(B19),\"\",IF(B19=19,0,36-B19)))","v":6},{"$f":"IF(G19=19,0,IF(ISBLANK(B19),\"\",IF(B19<18,1,IF(B19=18,2,IF(B19>18,3)))))","v":3},{"$f":"IF(G19=19,3,IF(ISBLANK(B19),\"\",IF(B19=19,0,IF(D19<18,1,IF(D19=18,2,IF(D19>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B19>D19,A19&C19,IF(D19>B19,C19&A19,\"/\"))","v":"ACAD"},null,{"$f":"A19&C19","v":"ACAD"},{"$f":"E19","v":3},{"$f":"C19&A19","v":"ADAC"},{"$f":"F19","v":1},{"$f":"B19","v":30},{"$f":"D19","v":6}]
["AE",16,"AF",{"$f":"IF(G20=19,19,IF(ISBLANK(B20),\"\",IF(B20=19,0,36-B20)))","v":20},{"$f":"IF(G20=19,0,IF(ISBLANK(B20),\"\",IF(B20<18,1,IF(B20=18,2,IF(B20>18,3)))))","v":1},{"$f":"IF(G20=19,3,IF(ISBLANK(B20),\"\",IF(B20=19,0,IF(D20<18,1,IF(D20=18,2,IF(D20>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B20>D20,A20&C20,IF(D20>B20,C20&A20,\"/\"))","v":"AFAE"},null,{"$f":"A20&C20","v":"AEAF"},{"$f":"E20","v":1},{"$f":"C20&A20","v":"AFAE"},{"$f":"F20","v":3},{"$f":"B20","v":16},{"$f":"D20","v":20}]
["AG",18,"AH",{"$f":"IF(G21=19,19,IF(ISBLANK(B21),\"\",IF(B21=19,0,36-B21)))","v":18},{"$f":"IF(G21=19,0,IF(ISBLANK(B21),\"\",IF(B21<18,1,IF(B21=18,2,IF(B21>18,3)))))","v":2},{"$f":"IF(G21=19,3,IF(ISBLANK(B21),\"\",IF(B21=19,0,IF(D21<18,1,IF(D21=18,2,IF(D21>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B21>D21,A21&C21,IF(D21>B21,C21&A21,\"/\"))","v":"/"},null,{"$f":"A21&C21","v":"AGAH"},{"$f":"E21","v":2},{"$f":"C21&A21","v":"AHAG"},{"$f":"F21","v":2},{"$f":"B21","v":18},{"$f":"D21","v":18}]
[]
["2 éme MATCH le ","à","AB"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AA",18,"AC",{"$f":"IF(G26=19,19,IF(ISBLANK(B26),\"\",IF(B26=19,0,36-B26)))","v":18},{"$f":"IF(G26=19,0,IF(ISBLANK(B26),\"\",IF(B26<18,1,IF(B26=18,2,IF(B26>18,3)))))","v":2},{"$f":"IF(G26=19,3,IF(ISBLANK(B26),\"\",IF(B26=19,0,IF(D26<18,1,IF(D26=18,2,IF(D26>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B26>D26,A26&C26,IF(D26>B26,C26&A26,\"/\"))","v":"/"},null,{"$f":"A26&C26","v":"AAAC"},{"$f":"E26","v":2},{"$f":"C26&A26","v":"ACAA"},{"$f":"F26","v":2},{"$f":"B26","v":18},{"$f":"D26","v":18}]
["AB",14,"AH",{"$f":"IF(G27=19,19,IF(ISBLANK(B27),\"\",IF(B27=19,0,36-B27)))","v":22},{"$f":"IF(G27=19,0,IF(ISBLANK(B27),\"\",IF(B27<18,1,IF(B27=18,2,IF(B27>18,3)))))","v":1},{"$f":"IF(G27=19,3,IF(ISBLANK(B27),\"\",IF(B27=19,0,IF(D27<18,1,IF(D27=18,2,IF(D27>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B27>D27,A27&C27,IF(D27>B27,C27&A27,\"/\"))","v":"AHAB"},null,{"$f":"A27&C27","v":"ABAH"},{"$f":"E27","v":1},{"$f":"C27&A27","v":"AHAB"},{"$f":"F27","v":3},{"$f":"B27","v":14},{"$f":"D27","v":22}]
["AD",18,"AF",{"$f":"IF(G28=19,19,IF(ISBLANK(B28),\"\",IF(B28=19,0,36-B28)))","v":18},{"$f":"IF(G28=19,0,IF(ISBLANK(B28),\"\",IF(B28<18,1,IF(B28=18,2,IF(B28>18,3)))))","v":2},{"$f":"IF(G28=19,3,IF(ISBLANK(B28),\"\",IF(B28=19,0,IF(D28<18,1,IF(D28=18,2,IF(D28>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B28>D28,A28&C28,IF(D28>B28,C28&A28,\"/\"))","v":"/"},null,{"$f":"A28&C28","v":"ADAF"},{"$f":"E28","v":2},{"$f":"C28&A28","v":"AFAD"},{"$f":"F28","v":2},{"$f":"B28","v":18},{"$f":"D28","v":18}]
["AE",28,"AG",{"$f":"IF(G29=19,19,IF(ISBLANK(B29),\"\",IF(B29=19,0,36-B29)))","v":8},{"$f":"IF(G29=19,0,IF(ISBLANK(B29),\"\",IF(B29<18,1,IF(B29=18,2,IF(B29>18,3)))))","v":3},{"$f":"IF(G29=19,3,IF(ISBLANK(B29),\"\",IF(B29=19,0,IF(D29<18,1,IF(D29=18,2,IF(D29>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B29>D29,A29&C29,IF(D29>B29,C29&A29,\"/\"))","v":"AEAG"},null,{"$f":"A29&C29","v":"AEAG"},{"$f":"E29","v":3},{"$f":"C29&A29","v":"AGAE"},{"$f":"F29","v":1},{"$f":"B29","v":28},{"$f":"D29","v":8}]
[]
["3 éme MATCH le ","à","AC"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AA",20,"AH",{"$f":"IF(G34=19,19,IF(ISBLANK(B34),\"\",IF(B34=19,0,36-B34)))","v":16},{"$f":"IF(G34=19,0,IF(ISBLANK(B34),\"\",IF(B34<18,1,IF(B34=18,2,IF(B34>18,3)))))","v":3},{"$f":"IF(G34=19,3,IF(ISBLANK(B34),\"\",IF(B34=19,0,IF(D34<18,1,IF(D34=18,2,IF(D34>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B34>D34,A34&C34,IF(D34>B34,C34&A34,\"/\"))","v":"AAAH"},null,{"$f":"A34&C34","v":"AAAH"},{"$f":"E34","v":3},{"$f":"C34&A34","v":"AHAA"},{"$f":"F34","v":1},{"$f":"B34","v":20},{"$f":"D34","v":16}]
["AB",18,"AE",{"$f":"IF(G35=19,19,IF(ISBLANK(B35),\"\",IF(B35=19,0,36-B35)))","v":18},{"$f":"IF(G35=19,0,IF(ISBLANK(B35),\"\",IF(B35<18,1,IF(B35=18,2,IF(B35>18,3)))))","v":2},{"$f":"IF(G35=19,3,IF(ISBLANK(B35),\"\",IF(B35=19,0,IF(D35<18,1,IF(D35=18,2,IF(D35>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B35>D35,A35&C35,IF(D35>B35,C35&A35,\"/\"))","v":"/"},null,{"$f":"A35&C35","v":"ABAE"},{"$f":"E35","v":2},{"$f":"C35&A35","v":"AEAB"},{"$f":"F35","v":2},{"$f":"B35","v":18},{"$f":"D35","v":18}]
["AC",20,"AF",{"$f":"IF(G36=19,19,IF(ISBLANK(B36),\"\",IF(B36=19,0,36-B36)))","v":16},{"$f":"IF(G36=19,0,IF(ISBLANK(B36),\"\",IF(B36<18,1,IF(B36=18,2,IF(B36>18,3)))))","v":3},{"$f":"IF(G36=19,3,IF(ISBLANK(B36),\"\",IF(B36=19,0,IF(D36<18,1,IF(D36=18,2,IF(D36>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B36>D36,A36&C36,IF(D36>B36,C36&A36,\"/\"))","v":"ACAF"},null,{"$f":"A36&C36","v":"ACAF"},{"$f":"E36","v":3},{"$f":"C36&A36","v":"AFAC"},{"$f":"F36","v":1},{"$f":"B36","v":20},{"$f":"D36","v":16}]
["AD",18,"AG",{"$f":"IF(G37=19,19,IF(ISBLANK(B37),\"\",IF(B37=19,0,36-B37)))","v":18},{"$f":"IF(G37=19,0,IF(ISBLANK(B37),\"\",IF(B37<18,1,IF(B37=18,2,IF(B37>18,3)))))","v":2},{"$f":"IF(G37=19,3,IF(ISBLANK(B37),\"\",IF(B37=19,0,IF(D37<18,1,IF(D37=18,2,IF(D37>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B37>D37,A37&C37,IF(D37>B37,C37&A37,\"/\"))","v":"/"},null,{"$f":"A37&C37","v":"ADAG"},{"$f":"E37","v":2},{"$f":"C37&A37","v":"AGAD"},{"$f":"F37","v":2},{"$f":"B37","v":18},{"$f":"D37","v":18}]
[]
["4 éme MATCH le ","à","AD"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AA",20,"AD",{"$f":"IF(G42=19,19,IF(ISBLANK(B42),\"\",IF(B42=19,0,36-B42)))","v":16},{"$f":"IF(G42=19,0,IF(ISBLANK(B42),\"\",IF(B42<18,1,IF(B42=18,2,IF(B42>18,3)))))","v":3},{"$f":"IF(G42=19,3,IF(ISBLANK(B42),\"\",IF(B42=19,0,IF(D42<18,1,IF(D42=18,2,IF(D42>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B42>D42,A42&C42,IF(D42>B42,C42&A42,\"/\"))","v":"AAAD"},null,{"$f":"A42&C42","v":"AAAD"},{"$f":"E42","v":3},{"$f":"C42&A42","v":"ADAA"},{"$f":"F42","v":1},{"$f":"B42","v":20},{"$f":"D42","v":16}]
["AF",10,"AG",{"$f":"IF(G43=19,19,IF(ISBLANK(B43),\"\",IF(B43=19,0,36-B43)))","v":26},{"$f":"IF(G43=19,0,IF(ISBLANK(B43),\"\",IF(B43<18,1,IF(B43=18,2,IF(B43>18,3)))))","v":1},{"$f":"IF(G43=19,3,IF(ISBLANK(B43),\"\",IF(B43=19,0,IF(D43<18,1,IF(D43=18,2,IF(D43>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B43>D43,A43&C43,IF(D43>B43,C43&A43,\"/\"))","v":"AGAF"},null,{"$f":"A43&C43","v":"AFAG"},{"$f":"E43","v":1},{"$f":"C43&A43","v":"AGAF"},{"$f":"F43","v":3},{"$f":"B43","v":10},{"$f":"D43","v":26}]
["AB",32,"AC",{"$f":"IF(G44=19,19,IF(ISBLANK(B44),\"\",IF(B44=19,0,36-B44)))","v":4},{"$f":"IF(G44=19,0,IF(ISBLANK(B44),\"\",IF(B44<18,1,IF(B44=18,2,IF(B44>18,3)))))","v":3},{"$f":"IF(G44=19,3,IF(ISBLANK(B44),\"\",IF(B44=19,0,IF(D44<18,1,IF(D44=18,2,IF(D44>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B44>D44,A44&C44,IF(D44>B44,C44&A44,\"/\"))","v":"ABAC"},null,{"$f":"A44&C44","v":"ABAC"},{"$f":"E44","v":3},{"$f":"C44&A44","v":"ACAB"},{"$f":"F44","v":1},{"$f":"B44","v":32},{"$f":"D44","v":4}]
["AE",20,"AH",{"$f":"IF(G45=19,19,IF(ISBLANK(B45),\"\",IF(B45=19,0,36-B45)))","v":16},{"$f":"IF(G45=19,0,IF(ISBLANK(B45),\"\",IF(B45<18,1,IF(B45=18,2,IF(B45>18,3)))))","v":3},{"$f":"IF(G45=19,3,IF(ISBLANK(B45),\"\",IF(B45=19,0,IF(D45<18,1,IF(D45=18,2,IF(D45>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B45>D45,A45&C45,IF(D45>B45,C45&A45,\"/\"))","v":"AEAH"},null,{"$f":"A45&C45","v":"AEAH"},{"$f":"E45","v":3},{"$f":"C45&A45","v":"AHAE"},{"$f":"F45","v":1},{"$f":"B45","v":20},{"$f":"D45","v":16}]
[]
["5 éme MATCH le ","à","AE"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AA",18,"AF",{"$f":"IF(G50=19,19,IF(ISBLANK(B50),\"\",IF(B50=19,0,36-B50)))","v":18},{"$f":"IF(G50=19,0,IF(ISBLANK(B50),\"\",IF(B50<18,1,IF(B50=18,2,IF(B50>18,3)))))","v":2},{"$f":"IF(G50=19,3,IF(ISBLANK(B50),\"\",IF(B50=19,0,IF(D50<18,1,IF(D50=18,2,IF(D50>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B50>D50,A50&C50,IF(D50>B50,C50&A50,\"/\"))","v":"/"},null,{"$f":"A50&C50","v":"AAAF"},{"$f":"E50","v":2},{"$f":"C50&A50","v":"AFAA"},{"$f":"F50","v":2},{"$f":"B50","v":18},{"$f":"D50","v":18}]
["AD",18,"AH",{"$f":"IF(G51=19,19,IF(ISBLANK(B51),\"\",IF(B51=19,0,36-B51)))","v":18},{"$f":"IF(G51=19,0,IF(ISBLANK(B51),\"\",IF(B51<18,1,IF(B51=18,2,IF(B51>18,3)))))","v":2},{"$f":"IF(G51=19,3,IF(ISBLANK(B51),\"\",IF(B51=19,0,IF(D51<18,1,IF(D51=18,2,IF(D51>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B51>D51,A51&C51,IF(D51>B51,C51&A51,\"/\"))","v":"/"},null,{"$f":"A51&C51","v":"ADAH"},{"$f":"E51","v":2},{"$f":"C51&A51","v":"AHAD"},{"$f":"F51","v":2},{"$f":"B51","v":18},{"$f":"D51","v":18}]
["AB",4,"AG",{"$f":"IF(G52=19,19,IF(ISBLANK(B52),\"\",IF(B52=19,0,36-B52)))","v":32},{"$f":"IF(G52=19,0,IF(ISBLANK(B52),\"\",IF(B52<18,1,IF(B52=18,2,IF(B52>18,3)))))","v":1},{"$f":"IF(G52=19,3,IF(ISBLANK(B52),\"\",IF(B52=19,0,IF(D52<18,1,IF(D52=18,2,IF(D52>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B52>D52,A52&C52,IF(D52>B52,C52&A52,\"/\"))","v":"AGAB"},null,{"$f":"A52&C52","v":"ABAG"},{"$f":"E52","v":1},{"$f":"C52&A52","v":"AGAB"},{"$f":"F52","v":3},{"$f":"B52","v":4},{"$f":"D52","v":32}]
["AC",20,"AE",{"$f":"IF(G53=19,19,IF(ISBLANK(B53),\"\",IF(B53=19,0,36-B53)))","v":16},{"$f":"IF(G53=19,0,IF(ISBLANK(B53),\"\",IF(B53<18,1,IF(B53=18,2,IF(B53>18,3)))))","v":3},{"$f":"IF(G53=19,3,IF(ISBLANK(B53),\"\",IF(B53=19,0,IF(D53<18,1,IF(D53=18,2,IF(D53>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B53>D53,A53&C53,IF(D53>B53,C53&A53,\"/\"))","v":"ACAE"},null,{"$f":"A53&C53","v":"ACAE"},{"$f":"E53","v":3},{"$f":"C53&A53","v":"AEAC"},{"$f":"F53","v":1},{"$f":"B53","v":20},{"$f":"D53","v":16}]
[]
["6 éme MATCH le ","à","AF"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AB",30,"AD",{"$f":"IF(G58=19,19,IF(ISBLANK(B58),\"\",IF(B58=19,0,36-B58)))","v":6},{"$f":"IF(G58=19,0,IF(ISBLANK(B58),\"\",IF(B58<18,1,IF(B58=18,2,IF(B58>18,3)))))","v":3},{"$f":"IF(G58=19,3,IF(ISBLANK(B58),\"\",IF(B58=19,0,IF(D58<18,1,IF(D58=18,2,IF(D58>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B58>D58,A58&C58,IF(D58>B58,C58&A58,\"/\"))","v":"ABAD"},null,{"$f":"A58&C58","v":"ABAD"},{"$f":"E58","v":3},{"$f":"C58&A58","v":"ADAB"},{"$f":"F58","v":1},{"$f":"B58","v":30},{"$f":"D58","v":6}]
["AE",24,"AA",{"$f":"IF(G59=19,19,IF(ISBLANK(B59),\"\",IF(B59=19,0,36-B59)))","v":12},{"$f":"IF(G59=19,0,IF(ISBLANK(B59),\"\",IF(B59<18,1,IF(B59=18,2,IF(B59>18,3)))))","v":3},{"$f":"IF(G59=19,3,IF(ISBLANK(B59),\"\",IF(B59=19,0,IF(D59<18,1,IF(D59=18,2,IF(D59>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B59>D59,A59&C59,IF(D59>B59,C59&A59,\"/\"))","v":"AEAA"},null,{"$f":"A59&C59","v":"AEAA"},{"$f":"E59","v":3},{"$f":"C59&A59","v":"AAAE"},{"$f":"F59","v":1},{"$f":"B59","v":24},{"$f":"D59","v":12}]
["AG",32,"AC",{"$f":"IF(G60=19,19,IF(ISBLANK(B60),\"\",IF(B60=19,0,36-B60)))","v":4},{"$f":"IF(G60=19,0,IF(ISBLANK(B60),\"\",IF(B60<18,1,IF(B60=18,2,IF(B60>18,3)))))","v":3},{"$f":"IF(G60=19,3,IF(ISBLANK(B60),\"\",IF(B60=19,0,IF(D60<18,1,IF(D60=18,2,IF(D60>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B60>D60,A60&C60,IF(D60>B60,C60&A60,\"/\"))","v":"AGAC"},null,{"$f":"A60&C60","v":"AGAC"},{"$f":"E60","v":3},{"$f":"C60&A60","v":"ACAG"},{"$f":"F60","v":1},{"$f":"B60","v":32},{"$f":"D60","v":4}]
["AF",22,"AH",{"$f":"IF(G61=19,19,IF(ISBLANK(B61),\"\",IF(B61=19,0,36-B61)))","v":14},{"$f":"IF(G61=19,0,IF(ISBLANK(B61),\"\",IF(B61<18,1,IF(B61=18,2,IF(B61>18,3)))))","v":3},{"$f":"IF(G61=19,3,IF(ISBLANK(B61),\"\",IF(B61=19,0,IF(D61<18,1,IF(D61=18,2,IF(D61>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B61>D61,A61&C61,IF(D61>B61,C61&A61,\"/\"))","v":"AFAH"},null,{"$f":"A61&C61","v":"AFAH"},{"$f":"E61","v":3},{"$f":"C61&A61","v":"AHAF"},{"$f":"F61","v":1},{"$f":"B61","v":22},{"$f":"D61","v":14}]
[]
["7 éme MATCH le","à","AG"]
[null,null,null,null,null,null,"SI forfait éq recevante",null," "]
["Equipes","score","Equipes","score","Points","Points"]
["AA",20,"AG",{"$f":"IF(G66=19,19,IF(ISBLANK(B66),\"\",IF(B66=19,0,36-B66)))","v":16},{"$f":"IF(G66=19,0,IF(ISBLANK(B66),\"\",IF(B66<18,1,IF(B66=18,2,IF(B66>18,3)))))","v":3},{"$f":"IF(G66=19,3,IF(ISBLANK(B66),\"\",IF(B66=19,0,IF(D66<18,1,IF(D66=18,2,IF(D66>=20,3))))))","v":1},null,null,null,null,null,{"$f":"IF(B66>D66,A66&C66,IF(D66>B66,C66&A66,\"/\"))","v":"AAAG"},null,{"$f":"A66&C66","v":"AAAG"},{"$f":"E66","v":3},{"$f":"C66&A66","v":"AGAA"},{"$f":"F66","v":1},{"$f":"B66","v":20},{"$f":"D66","v":16}]
["AB",12,"AF",{"$f":"IF(G67=19,19,IF(ISBLANK(B67),\"\",IF(B67=19,0,36-B67)))","v":24},{"$f":"IF(G67=19,0,IF(ISBLANK(B67),\"\",IF(B67<18,1,IF(B67=18,2,IF(B67>18,3)))))","v":1},{"$f":"IF(G67=19,3,IF(ISBLANK(B67),\"\",IF(B67=19,0,IF(D67<18,1,IF(D67=18,2,IF(D67>=20,3))))))","v":3},null,null,null,null,null,{"$f":"IF(B67>D67,A67&C67,IF(D67>B67,C67&A67,\"/\"))","v":"AFAB"},null,{"$f":"A67&C67","v":"ABAF"},{"$f":"E67","v":1},{"$f":"C67&A67","v":"AFAB"},{"$f":"F67","v":3},{"$f":"B67","v":12},{"$f":"D67","v":24}]
["AE",18,"AD",{"$f":"IF(G68=19,19,IF(ISBLANK(B68),\"\",IF(B68=19,0,36-B68)))","v":18},{"$f":"IF(G68=19,0,IF(ISBLANK(B68),\"\",IF(B68<18,1,IF(B68=18,2,IF(B68>18,3)))))","v":2},{"$f":"IF(G68=19,3,IF(ISBLANK(B68),\"\",IF(B68=19,0,IF(D68<18,1,IF(D68=18,2,IF(D68>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B68>D68,A68&C68,IF(D68>B68,C68&A68,\"/\"))","v":"/"},null,{"$f":"A68&C68","v":"AEAD"},{"$f":"E68","v":2},{"$f":"C68&A68","v":"ADAE"},{"$f":"F68","v":2},{"$f":"B68","v":18},{"$f":"D68","v":18}]
["AC",18,"AH",{"$f":"IF(G69=19,19,IF(ISBLANK(B69),\"\",IF(B69=19,0,36-B69)))","v":18},{"$f":"IF(G69=19,0,IF(ISBLANK(B69),\"\",IF(B69<18,1,IF(B69=18,2,IF(B69>18,3)))))","v":2},{"$f":"IF(G69=19,3,IF(ISBLANK(B69),\"\",IF(B69=19,0,IF(D69<18,1,IF(D69=18,2,IF(D69>=20,3))))))","v":2},null,null,null,null,null,{"$f":"IF(B69>D69,A69&C69,IF(D69>B69,C69&A69,\"/\"))","v":"/"},null,{"$f":"A69&C69","v":"ACAH"},{"$f":"E69","v":2},{"$f":"C69&A69","v":"AHAC"},{"$f":"F69","v":2},{"$f":"B69","v":18},{"$f":"D69","v":18}]
[null,null,"Si pas d'exaequo",null,null,null,"Classt        Final","Rencontres entre exaequos"]
["EQUIPES",null,"POINTS","POUR","CONTRE","DIFF",null,"POINTS Exaequos","Exaq","n°","AA","AB","AC","AD","AE","AF","AG","AH","Pts matchs",null,null,null,"1000000*Pts matchs +1000 (Diff +  abs(diff mini) )+Pour ","RANG","DIFF Exaequos","POUR Exaequos"]
["AC","1C",15,114,138,-24,1,{"$f":"IF(S72>0,S72,\"\")","v":9},{"$f":"COUNTIF($C$72:$C$79,C72)","v":5},{"$f":"IF(AND(I72>1,COUNTIFS(I$72:I72,I72,C$72:C72,C72)=1),MAX(J$71:J71)+1,\"\")","v":1},{"$f":"IF($A72=K$71,\"\",IF(INDEX($C$72:$C$79,MATCH(K$71,$A$72:$A$79,0))=$C72,IFERROR(VLOOKUP($A72&K$71,$N$18:$O$69,2,0),  VLOOKUP(K$71&$A72,$N$18:$Q$69,4,0)),          \"\"))","v":2},"","","",3,3,1,"",{"$f":"SUM(K72:R72)","v":9},null,null,null,{"$f":"IF(I72<3,S72*1000000+(F72+ABS(MIN($F$72:$F$79)))*1000+D72,S72*1000000+U96*1000+Z72)","v":9000062},{"$f":"IF(I72>2,RANK(W72,OFFSET(W$71,MATCH(I72,I72:I79,0),,I72)))","v":1},{"$f":"IF(S96=0,\"\",S96)","v":-20},{"$f":"IF(S80=0,\"\",S80)","v":62}]
["AE","1E",15,140,112,28,2,{"$f":"IF(S73>0,S73,\"\")","v":8},5,{"$f":"IF(AND(I73>1,COUNTIFS(I$72:I73,I73,C$72:C73,C73)=1),MAX(J$71:J72)+1,\"\")","v":""},3,"",1,"","",1,3,"",{"$f":"SUM(K73:R73)","v":8},null,null,null,{"$f":"IF(I73<3,S73*1000000+(F73+ABS(MIN($F$72:$F$79)))*1000+D73,S73*1000000+U97*1000+Z73)","v":8044084},{"$f":"IF(I73>2,RANK(W73,OFFSET(W$71,MATCH(I73,I73:I80,0),,I73)))","v":2},24,84]
["AG","1G",15,150,102,48,3,{"$f":"IF(S74>0,S74,\"\")","v":8},5,{"$f":"IF(AND(I74>1,COUNTIFS(I$72:I74,I74,C$72:C74,C74)=1),MAX(J$71:J73)+1,\"\")","v":""},1,"",3,"",1,3,"","",8,null,null,null,{"$f":"IF(I74<3,S74*1000000+(F74+ABS(MIN($F$72:$F$79)))*1000+D74,S74*1000000+U98*1000+Z74)","v":8040082},3,20,82]
["AA","1A",15,124,128,-4,4,{"$f":"IF(S75>0,S75,\"\")","v":8},5,{"$f":"IF(AND(I75>1,COUNTIFS(I$72:I75,I75,C$72:C75,C75)=1),MAX(J$71:J74)+1,\"\")","v":""},"","",2,"",1,2,3,"",8,null,null,null,8012068,4,-8,68]
["AF","1F",15,128,124,4,5,{"$f":"IF(S76>0,S76,\"\")","v":7},5,{"$f":"IF(AND(I76>1,COUNTIFS(I$72:I76,I76,C$72:C76,C76)=1),MAX(J$71:J75)+1,\"\")","v":""},2,"",1,"",3,"",1,"",7,null,null,null,7004064,5,-16,64]
["AB","1B",14,130,122,8,6,{"$f":"IF(S77>0,S77,\"\")","v":""},1,{"$f":"IF(AND(I77>1,COUNTIFS(I$72:I77,I77,C$72:C77,C77)=1),MAX(J$71:J76)+1,\"\")","v":""},"","","","","","","","",0,null,null,null,60130,false,"",""]
["AH","1H",12,122,130,-8,7,{"$f":"IF(S78>0,S78,\"\")","v":""},1,{"$f":"IF(AND(I78>1,COUNTIFS(I$72:I78,I78,C$72:C78,C78)=1),MAX(J$71:J77)+1,\"\")","v":""},"","","","","","","","",0,null,null,null,44122,false,"",""]
["AD","1D",11,100,152,-52,8,{"$f":"IF(S79>0,S79,\"\")","v":""},1,{"$f":"IF(AND(I79>1,COUNTIFS(I$72:I79,I79,C$72:C79,C79)=1),MAX(J$71:J78)+1,\"\")","v":""},"","","","","","","","",0,null,null,null,100,false,"",""]
[null,null,null,null,null,null,null,null,"POUR",{"$f":"A72","v":"AC"},{"$f":"IF($A72=K$71,\"\",IF(INDEX($C$72:$C$79,MATCH(K$71,$A$72:$A$79,0))=$C72,IFERROR(VLOOKUP($A72&K$71,$N$18:$R$69,5,0),  VLOOKUP(K$71&$A72,$N$18:$S$69,6,0)),          \"\"))","v":18},"","","",20,20,4,"",62]
[null,null,null,null,null,null,null,null,null,"AE",24,"",16,"","",16,28,"",84]
[null,null,null,null,null,null,null,null,null,"AG",16,"",32,"",8,26,"","",82]
[null,null,null,null,null,null,null,null,null,"AA","","",18,"",12,18,20,"",68]
[null,null,null,null,null,null,null,null,null,"AF",18,"",16,"",20,"",10,"",64,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,"AB","","","","","","","","",0]
[null,null,null,null,null,null,null,null,null,"AH","","","","","","","","",0]
[null,null,null,null,null,null,null,null,null,"AD","","","","","","","","",0]
[null,null,null,null,null,null,null,null,"CONTRE",{"$f":"J80","v":"AC"},{"$f":"INDEX($K$80:$R$87,MATCH(K$71,$J$80:$J$87,0),MATCH($J80,$K$71:$R$71,0))","v":18},{"$f":"INDEX($K$80:$R$87,MATCH(L$71,$J$80:$J$87,0),MATCH($J80,$K$71:$R$71,0))","v":""},"","",16,16,32,"",82]
[null,null,null,null,null,null,null,null,null,{"$f":"J81","v":"AE"},{"$f":"INDEX($K$80:$R$87,MATCH(K$71,$J$80:$J$87,0),MATCH($J81,$K$71:$R$71,0))","v":12},"",20,"","",20,8,"",60]
[null,null,null,null,null,null,null,null,null,"AG",20,"",4,"",28,10,"","",62]
[null,null,null,null,null,null,null,null,null,"AA","","",18,"",24,18,16,"",76]
[null,null,null,null,null,null,null,null,null,"AF",18,"",20,"",16,"",26,"",80]
[null,null,null,null,null,null,null,null,null,"AB","","","","","","","","",0]
[null,null,null,null,null,null,null,null,null,"AH","","","","","","","","",0]
[null,null,null,null,null,null,null,null,null,"AD","","","","","","","","",0,null,"Diff pondérée"]
[null,null,null,null,null,null,null,null,"DIFF",{"$f":"J88","v":"AC"},null,null,null,null,null,null,null,null,{"$f":"S80-S88","v":-20},null,{"$f":"S96+ABS(MIN($S$96:$S$103))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J89","v":"AE"},null,null,null,null,null,null,null,null,{"$f":"S81-S89","v":24},null,44]
[null,null,null,null,null,null,null,null,null,"AG",null,null,null,null,null,null,null,null,20,null,40]
[null,null,null,null,null,null,null,null,null,"AA",null,null,null,null,null,null,null,null,-8,null,12]
[null,null,null,null,null,null,null,null,null,"AF",null,null,null,null,null,null,null,null,-16,null,4]
[null,null,null,null,null,null,null,null,null,"AB",null,null,null,null,null,null,null,null,0,null,20]
[null,null,null,null,null,null,null,null,null,"AH",null,null,null,null,null,null,null,null,0,null,{"$f":"S102+ABS(MIN($S$96:$S$103))","v":20}]
[null,null,null,null,null,null,null,null,null,"AD",null,null,null,null,null,null,null,null,0,null,{"$f":"S103+ABS(MIN($S$96:$S$103))","v":20}]