{"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":37,"rows_kept":103,"cut":false,"hidden":false,"merged":[[3,8,3,10],[15,6,16,6],[63,6,64,6],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[23,6,24,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":15},{"$f":"SUMIF($A$18:$A$69,$A7,$B$18:$B$69)+SUMIF($C$18:$C$69,$A7,$D$18:$D$69)","v":138},{"$f":"SUMIF($C$18:$C$69,$A7,$B$18:$B$69)+SUMIF($A$18:$A$69,$A7,$D$18:$D$69)","v":114},24]
["AC","1C",{"$f":"SUMIF($A$18:$A$69,A8,$E$18:$E$69)+SUMIF($C$18:$C$69,A8,$F$18:$F$69)","v":14},118,134,-16]
["AD","1D",11,108,144,-36]
["AE","1E",15,136,116,20]
["AF","1F",14,124,128,-4]
["AG","1G",14,130,122,{"$f":"D12-E12","v":8}]
["AH","1H",14,{"$f":"SUMIF($A$18:$A$69,$A13,$B$18:$B$69)+SUMIF($C$18:$C$69,$A13,$D$18:$D$69)","v":130},122,{"$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",12,"AB",{"$f":"IF(G18=19,19,IF(ISBLANK(B18),\"\",IF(B18=19,0,36-B18)))","v":24},{"$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":12},{"$f":"D18","v":24}]
["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},30,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,"AEAF",1,"AFAE",3,16,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,"AGAH",2,"AHAG",2,18,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,"AAAC",2,"ACAA",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,"ABAH",1,"AHAB",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,"ADAF",2,"AFAD",2,18,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,"AEAG",3,"AGAE",1,28,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,"AAAH",3,"AHAA",1,20,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,"ABAE",2,"AEAB",2,18,18]
["AC",10,"AF",{"$f":"IF(G36=19,19,IF(ISBLANK(B36),\"\",IF(B36=19,0,36-B36)))","v":26},{"$f":"IF(G36=19,0,IF(ISBLANK(B36),\"\",IF(B36<18,1,IF(B36=18,2,IF(B36>18,3)))))","v":1},{"$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":3},null,null,null,null,null,{"$f":"IF(B36>D36,A36&C36,IF(D36>B36,C36&A36,\"/\"))","v":"AFAC"},null,"ACAF",1,"AFAC",3,10,26]
["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,"ADAG",2,"AGAD",2,18,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,"AAAD",3,"ADAA",1,20,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,"AFAG",1,"AGAF",3,10,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,"ABAC",3,"ACAB",1,32,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,"AEAH",3,"AHAE",1,20,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,"AAAF",2,"AFAA",2,18,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,"ADAH",2,"AHAD",2,18,18]
["AB",10,"AG",{"$f":"IF(G52=19,19,IF(ISBLANK(B52),\"\",IF(B52=19,0,36-B52)))","v":26},{"$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,"ABAG",1,"AGAB",3,10,26]
["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,"ACAE",3,"AEAC",1,20,16]
[]
["6 éme MATCH le ","à","AF"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["Equipes","score","Equipes","score","Points","Points"]
["AB",22,"AD",{"$f":"IF(G58=19,19,IF(ISBLANK(B58),\"\",IF(B58=19,0,36-B58)))","v":14},{"$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,"ABAD",3,"ADAB",1,22,14]
["AE",20,"AA",{"$f":"IF(G59=19,19,IF(ISBLANK(B59),\"\",IF(B59=19,0,36-B59)))","v":16},{"$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,"AEAA",3,"AAAE",1,20,16]
["AG",18,"AC",{"$f":"IF(G60=19,19,IF(ISBLANK(B60),\"\",IF(B60=19,0,36-B60)))","v":18},{"$f":"IF(G60=19,0,IF(ISBLANK(B60),\"\",IF(B60<18,1,IF(B60=18,2,IF(B60>18,3)))))","v":2},{"$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":2},null,null,null,null,null,{"$f":"IF(B60>D60,A60&C60,IF(D60>B60,C60&A60,\"/\"))","v":"/"},null,"AGAC",2,"ACAG",2,18,18]
["AF",14,"AH",{"$f":"IF(G61=19,19,IF(ISBLANK(B61),\"\",IF(B61=19,0,36-B61)))","v":22},{"$f":"IF(G61=19,0,IF(ISBLANK(B61),\"\",IF(B61<18,1,IF(B61=18,2,IF(B61>18,3)))))","v":1},{"$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":3},null,null,null,null,null,{"$f":"IF(B61>D61,A61&C61,IF(D61>B61,C61&A61,\"/\"))","v":"AHAF"},null,"AFAH",1,"AHAF",3,14,22]
[]
["7 éme MATCH le","à","AG"]
[null,null,null,null,null,null,"SI forfait éq recevante"]
["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,"AAAG",3,"AGAA",1,20,16]
["AB",18,"AF",{"$f":"IF(G67=19,19,IF(ISBLANK(B67),\"\",IF(B67=19,0,36-B67)))","v":18},{"$f":"IF(G67=19,0,IF(ISBLANK(B67),\"\",IF(B67<18,1,IF(B67=18,2,IF(B67>18,3)))))","v":2},{"$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":2},null,null,null,null,null,{"$f":"IF(B67>D67,A67&C67,IF(D67>B67,C67&A67,\"/\"))","v":"/"},null,"ABAF",2,"AFAB",2,18,18]
["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,"AEAD",2,"ADAE",2,18,18,null,null,null,null,{"$f":"RANK($W73,$W72:$W75)","v":3}]
["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,"ACAH",2,"AHAC",2,18,18]
[null,null,null,null,null,null,null,null,"NE PAS EFFACER"]
["EQUIPES",null,"POINTS","Pour","Contre","Diff","Classt","Pts matchs","Exaq","n°","AA","AB","AC","AD","AE","AF","AG","AH","Pts matchs",1,2,3,"1000000*Pts matchs +1000 (Diff +  abs(diff mini) )+Pour ","Rang triplons",1,2,3,4,"Rang quadruplons","Diff matchs","Pour matchs"]
["AB","1B",15,138,114,24,1,{"$f":"IF(S72>0,S72,\"\")","v":5},{"$f":"COUNTIF($C$72:$C$79,C72)","v":3},{"$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":3},"","","",2,"","","",{"$f":"SUM(K72:R72)","v":5},{"$f":"IF(AND($J72<>\"\",$I72=3),LARGE($S72:$S74,1),\"\")","v":5},{"$f":"IF(AND($J72<>\"\",$I72=3),LARGE($S72:$S74,2),\"\")","v":5},{"$f":"IF(AND($J72<>\"\",$I72=3),LARGE($S72:$S74,3),\"\")","v":2},{"$f":"S72*1000000+U96*1000+D72","v":5028138},{"$f":"IF($I72=3,IF($J72<>\"\",RANK($W72,$W72:$W74),IF($J71<>\"\",RANK($W72,$W71:$W73),RANK($W72,$W70:$W72))))","v":1},{"$f":"IF(AND($J72<>\"\",$I72=4),LARGE($S72:$S75,1),\"\")","v":""},{"$f":"IF(AND($J72<>\"\",$I72=4),LARGE($S72:$S75,2),\"\")","v":""},{"$f":"IF(AND($J72<>\"\",$I72=4),LARGE($S72:$S75,3),\"\")","v":""},{"$f":"IF(AND($J72<>\"\",$I72=4),LARGE($S72:$S75,4),\"\")","v":""},{"$f":"IF($I72=4,IF($J72<>\"\",RANK($W72,$W72:$W75),IF($J71<>\"\",RANK($W72,$W71:$W74),IF($J70<>\"\",RANK($W72,$W70:$W73),RANK($W72,$W69:$W72)))))","v":false},{"$f":"S96","v":12},{"$f":"S80","v":42}]
["AE","1E",15,136,116,20,2,{"$f":"IF(S73>0,S73,\"\")","v":5},{"$f":"COUNTIF($C$72:$C$79,C73)","v":3},{"$f":"IF(AND(I73>1,COUNTIFS(I$72:I73,I73,C$72:C73,C73)=1),MAX(J$71:J72)+1,\"\")","v":""},3,2,"","","","","","",{"$f":"SUM(K73:R73)","v":5},{"$f":"IF(AND($J73<>\"\",$I73=3),LARGE($S73:$S75,1),\"\")","v":""},{"$f":"IF(AND($J73<>\"\",$I73=3),LARGE($S73:$S75,2),\"\")","v":""},{"$f":"IF(AND($J73<>\"\",$I73=3),LARGE($S73:$S75,3),\"\")","v":""},{"$f":"S73*1000000+U97*1000+D73","v":5020136},{"$f":"IF($I73=3,IF($J73<>\"\",RANK($W73,$W73:$W75),IF($J72<>\"\",RANK($W73,$W72:$W74),RANK($W73,$W71:$W73))))","v":2},{"$f":"IF(AND($J73<>\"\",$I73=4),LARGE($S73:$S76,1),\"\")","v":""},{"$f":"IF(AND($J73<>\"\",$I73=4),LARGE($S73:$S76,2),\"\")","v":""},{"$f":"IF(AND($J73<>\"\",$I73=4),LARGE($S73:$S76,3),\"\")","v":""},{"$f":"IF(AND($J73<>\"\",$I73=4),LARGE($S73:$S76,4),\"\")","v":""},{"$f":"IF($I73=4,IF($J73<>\"\",RANK($W73,$W73:$W76),IF($J72<>\"\",RANK($W73,$W72:$W75),IF($J71<>\"\",RANK($W73,$W71:$W74),RANK($W73,$W70:$W73)))))","v":false},{"$f":"S97","v":4},{"$f":"S81","v":38}]
["AA","1A",15,124,128,-4,3,{"$f":"IF(S74>0,S74,\"\")","v":2},3,{"$f":"IF(AND(I74>1,COUNTIFS(I$72:I74,I74,C$72:C74,C74)=1),MAX(J$71:J73)+1,\"\")","v":""},"",1,"","",1,"","","",2,"","","",2000124,3,"","","","",false,-16,28]
["AG","1G",14,130,122,8,4,{"$f":"IF(S75>0,S75,\"\")","v":7},4,{"$f":"IF(AND(I75>1,COUNTIFS(I$72:I75,I75,C$72:C75,C75)=1),MAX(J$71:J74)+1,\"\")","v":2},"","",2,"","",3,"",2,7,"","","",7032130,false,7,7,5,5,1,16,62]
["AH","1H",14,130,122,8,5,{"$f":"IF(S76>0,S76,\"\")","v":7},4,{"$f":"IF(AND(I76>1,COUNTIFS(I$72:I76,I76,C$72:C76,C76)=1),MAX(J$71:J75)+1,\"\")","v":""},"","",2,"","",3,2,"",7,"","","",7024130,false,"","","","",2,8,58]
["AF","1F",14,124,128,-4,6,{"$f":"IF(S77>0,S77,\"\")","v":5},4,{"$f":"IF(AND(I77>1,COUNTIFS(I$72:I77,I77,C$72:C77,C77)=1),MAX(J$71:J76)+1,\"\")","v":""},"","",3,"","","",1,1,5,"","","",5008124,false,{"$f":"IF(AND($J77<>\"\",$I77=4),LARGE($S77:$S79,1),\"\")","v":""},{"$f":"IF(AND($J77<>\"\",$I77=4),LARGE($S77:$S79,2),\"\")","v":""},{"$f":"IF(AND($J77<>\"\",$I77=4),LARGE($S77:$S79,3),\"\")","v":""},{"$f":"IF(AND($J77<>\"\",$I77=4),LARGE($S77:$S79,4),\"\")","v":""},{"$f":"IF($I77=4,IF($J77<>\"\",RANK($W77,$W77:$W79),IF($J76<>\"\",RANK($W77,$W76:$W79),IF($J75<>\"\",RANK($W77,$W75:$W78),RANK($W77,$W74:$W77)))))","v":3},-8,50]
["AC","1C",14,118,134,-16,7,{"$f":"IF(S78>0,S78,\"\")","v":5},4,{"$f":"IF(AND(I78>1,COUNTIFS(I$72:I78,I78,C$72:C78,C78)=1),MAX(J$71:J77)+1,\"\")","v":""},"","","","","",1,2,2,5,{"$f":"IF(AND($J78<>\"\",$I78=3),LARGE($S78:$S79,1),\"\")","v":""},{"$f":"IF(AND($J78<>\"\",$I78=3),LARGE($S78:$S79,2),\"\")","v":""},{"$f":"IF(AND($J78<>\"\",$I78=3),LARGE($S78:$S79,3),\"\")","v":""},{"$f":"S78*1000000+U102*1000+D78","v":5000118},{"$f":"IF($I78=3,IF($J78<>\"\",RANK($W78,$W78:$W79),IF($J77<>\"\",RANK($W78,$W77:$W79),RANK($W78,$W76:$W78))))","v":false},{"$f":"IF(AND($J78<>\"\",$I78=4),LARGE($S78:$S79,1),\"\")","v":""},{"$f":"IF(AND($J78<>\"\",$I78=4),LARGE($S78:$S79,2),\"\")","v":""},{"$f":"IF(AND($J78<>\"\",$I78=4),LARGE($S78:$S79,3),\"\")","v":""},{"$f":"IF(AND($J78<>\"\",$I78=4),LARGE($S78:$S79,4),\"\")","v":""},{"$f":"IF($I78=4,IF($J78<>\"\",RANK($W78,$W78:$W79),IF($J77<>\"\",RANK($W78,$W77:$W79),IF($J76<>\"\",RANK($W78,$W76:$W79),RANK($W78,$W75:$W78)))))","v":4},-16,46,null,"Cas de figure à tester :"]
["AD","1D",11,108,144,-36,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,{"$f":"IF(AND($J79<>\"\",$I79=3),LARGE($S79:$S79,1),\"\")","v":""},{"$f":"IF(AND($J79<>\"\",$I79=3),LARGE($S79:$S79,2),\"\")","v":""},{"$f":"IF(AND($J79<>\"\",$I79=3),LARGE($S79:$S79,3),\"\")","v":""},16108,{"$f":"IF($I79=3,IF($J79<>\"\",RANK($W79,$W79:$W79),IF($J78<>\"\",RANK($W79,$W78:$W79),RANK($W79,$W77:$W79))))","v":false},{"$f":"IF(AND($J79<>\"\",$I79=4),LARGE($S79:$S79,1),\"\")","v":""},{"$f":"IF(AND($J79<>\"\",$I79=4),LARGE($S79:$S79,2),\"\")","v":""},{"$f":"IF(AND($J79<>\"\",$I79=4),LARGE($S79:$S79,3),\"\")","v":""},{"$f":"IF(AND($J79<>\"\",$I79=4),LARGE($S79:$S79,4),\"\")","v":""},{"$f":"IF($I79=4,IF($J79<>\"\",RANK($W79,$W79:$W79),IF($J78<>\"\",RANK($W79,$W78:$W79),IF($J77<>\"\",RANK($W79,$W77:$W79),RANK($W79,$W76:$W79)))))","v":false},0,0,null,"Triplons",null,null,null,"Quadruplons"]
[null,null,null,null,null,null,null,null,"POUR",{"$f":"A72","v":"AB"},{"$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":24},"","","",18,"","","",42,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) points macths tous différents",null,null,null,"1) points macths tous différents"]
[null,null,null,null,null,null,null,null,null,{"$f":"A73","v":"AE"},20,18,"","","","","","",38,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) points matchs exeaquos pour les 2 premiers",null,null,null,"2) points matchs exeaquos pour les 2 premiers"]
[null,null,null,null,null,null,null,null,null,"AA","",12,"","",16,"","","",28,null,null,null,null,null,null,null,null,null,null,null,null,null,"3) points matchs exeaquos pour les 2 derniers",null,null,null,"3) points matchs exeaquos pour les 2 du milieu"]
[null,null,null,null,null,null,null,null,null,"AG","","",18,"","",26,"",18,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4) points matchs exeaquos pour les 2 derniers"]
[null,null,null,null,null,null,null,null,null,"AH","","",18,"","",22,18,"",58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5) points matchs exeaquos pour les 3 premiers"]
[null,null,null,null,null,null,null,null,null,"AF","","",26,"","","",10,14,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6) points matchs exeaquos pour les 3 derniers"]
[null,null,null,null,null,null,null,null,null,"AC","","","","","",10,18,18,46]
[null,null,null,null,null,null,null,null,null,"AD","","","","","","","","",0]
[null,null,null,null,null,null,null,null,"CONTRE",{"$f":"J80","v":"AB"},{"$f":"INDEX($K$80:$R$87,MATCH(K$71,$J$80:$J$87,0),MATCH($J80,$K$71:$R$71,0))","v":12},{"$f":"INDEX($K$80:$R$87,MATCH(L$71,$J$80:$J$87,0),MATCH($J80,$K$71:$R$71,0))","v":""},"","",18,"","","",30]
[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":16},18,"","","","","","",34]
[null,null,null,null,null,null,null,null,null,"AA","",24,"","",20,"","","",44]
[null,null,null,null,null,null,null,null,null,"AG","","",18,"","",10,"",18,46]
[null,null,null,null,null,null,null,null,null,"AH","","",18,"","",14,18,"",50]
[null,null,null,null,null,null,null,null,null,"AF","","",10,"","","",26,22,58]
[null,null,null,null,null,null,null,null,null,"AC","","","","","",26,18,18,62]
[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":"AB"},null,null,null,null,null,null,null,null,{"$f":"S80-S88","v":12},null,{"$f":"S96+ABS(MIN($S$96:$S$103))","v":28}]
[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":4},null,20]
[null,null,null,null,null,null,null,null,null,"AA",null,null,null,null,null,null,null,null,-16,null,0]
[null,null,null,null,null,null,null,null,null,"AG",null,null,null,null,null,null,null,null,16,null,32]
[null,null,null,null,null,null,null,null,null,"AH",null,null,null,null,null,null,null,null,8,null,24]
[null,null,null,null,null,null,null,null,null,"AF",null,null,null,null,null,null,null,null,-8,null,8]
[null,null,null,null,null,null,null,null,null,"AC",null,null,null,null,null,null,null,null,-16,null,{"$f":"S102+ABS(MIN($S$96:$S$103))","v":0}]
[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":16}]