{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Equipes","Préparation","Billards","Compo","Grille","E1-E2","E1-E3","E2-E3","E1-E4","E2-E4","E3-E4"],"not_rendered":{"external_links":3,"defined_names":12,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Equipes","index":0,"n_rows":9,"n_cols":4,"rows_kept":9}
["BLOIS","MER","SAINT DENIS EN VAL","EXEMPT"]
["HAYES Arnaud","CHESNEAU Christophe","COSTAS FREITAS Domingos"]
["CHANTERAUD Dominique","FOURRE Cedric","SERVANT Denis"]
["ARRACHEPIED Yohan","RUBLINE Pascal","MUNGUIA Bruno"]
["ORGEBIN Patrice","PICOT COURNEE Sylvain","BOUBAULT Andre"]
["FONTAINE Isabelle","BOURSEREAU François","LECLAND Michel"]
["MARCHISSEAU Stéphane"]
[" "," "," "," "]
[" "," "," "," "]

{"sheet":"Préparation","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[8,1,8,5],[9,1,9,5]]}
["Inscriptions",null,"Simple","Double","Relais","Pt Match"]
["Equipes","Code",100,100,150,2]
["BLOIS","E1"]
["MER","E2"]
["SAINT DENIS EN VAL","E3"]
["EXEMPT","E4"]
[]
[]
["Compétition","CF D2 5 Quilles"]
["Phase","Eliminatoires Ligue"]
["Poule","A"]
["Date","A remplir"]
[]
[null,"Liste des rencontres (6)"]
[null,"E1-E2"]
[null,"E1-E3"]
[null,"E2-E4"]

{"sheet":"Billards","index":2,"n_rows":17,"n_cols":21,"rows_kept":17,"merged":[[0,3,1,3],[0,6,2,7],[0,9,2,10],[0,17,2,18],[0,20,2,21]]}
[{"$nulls":3},"Billard ",null,null,1,null,null,2,null,null,"Etage",null,null,"Etage",null,3,null,null,4]
["N°","Match",{"$nulls":10},"Coin de rue",null,null,"Escalier"]
["Match","Equipes",{"$nulls":10},"2,80m",null,null,"2,80m"]
[{"$nulls":9},3]
[1,"E1E4",{"$f":"Préparation!$A$3","v":"BLOIS"},{"$f":"Préparation!$A$6","v":"EXEMPT"},null,null,{"$f":"\"Double \" &$B$7","v":"Double E2E3"},null,null,{"$f":"\"Double \" &$B$5","v":"Double E1E4"},{"$nulls":7},{"$f":"\"Simple \" &$B$7","v":"Simple E2E3"},null,null,{"$f":"\"Simple \" &$B$5","v":"Simple E1E4"}]
[]
[2,"E2E3",{"$f":"Préparation!$A$4","v":"MER"},{"$f":"Préparation!$A$5","v":"SAINT DENIS EN VAL"},null,null,{"$f":"\"Relais \" &$B$7","v":"Relais E2E3"},null,null,{"$f":"\"Relais \" &$B$5","v":"Relais E1E4"}]
[]
[]
[3,"E1E3",{"$f":"Préparation!$A$3","v":"BLOIS"},{"$f":"Préparation!$A$5","v":"SAINT DENIS EN VAL"},null,null,{"$f":"\"Double \" &$B$12","v":"Double E2E4"},null,null,{"$f":"\"Double \" &$B$10","v":"Double E1E3"},{"$nulls":7},{"$f":"\"Simple \" &$B$12","v":"Simple E2E4"},null,null,{"$f":"\"Simple \" &$B$10","v":"Simple E1E3"}]
[]
[4,"E2E4",{"$f":"Préparation!$A$4","v":"MER"},{"$f":"Préparation!$A$6","v":"EXEMPT"},null,null,{"$f":"\"Relais \" &$B$12","v":"Relais E2E4"},null,null,{"$f":"\"Relais \" &$B$10","v":"Relais E1E3"}]
[]
[]
[5,"E1E2",{"$f":"Préparation!$A$3","v":"BLOIS"},{"$f":"Préparation!$A$4","v":"MER"},null,null,{"$f":"\"Double \" &$B$15","v":"Double E1E2"},null,null,{"$f":"\"Double \" &$B$17","v":"Double E3E4"},{"$nulls":7},{"$f":"\"Simple \" &$B$15","v":"Simple E1E2"},null,null,{"$f":"\"Simple \" &$B$17","v":"Simple E3E4"}]
[]
[6,"E3E4",{"$f":"Préparation!$A$5","v":"SAINT DENIS EN VAL"},{"$f":"Préparation!$A$6","v":"EXEMPT"},null,null,{"$f":"\"Relais \" &$B$15","v":"Relais E1E2"},null,null,{"$f":"\"Relais \" &$B$17","v":"Relais E3E4"}]

{"sheet":"Compo","index":3,"n_rows":28,"n_cols":12,"rows_kept":28}
["Rencontre","E3-E4",{"$nulls":5},{"$f":"A1","v":"Rencontre"},{"$f":"B1","v":"E3-E4"}]
[]
[{"$f":"INDIRECT(\"'\"&B1&\"'!C2\")","v":"SAINT DENIS EN VAL"},null,null,"Adversaire",{"$f":"INDIRECT(\"'\"&B1&\"'!G2\")","v":"EXEMPT"},null,null,{"$f":"E3","v":"EXEMPT"},null,null,{"$f":"D3","v":"Adversaire"},{"$f":"A3","v":"SAINT DENIS EN VAL"}]
[]
[]
[]
["Simple","_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":5},"Simple","_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[]
[]
[]
[]
["Double",{"$nulls":6},"Double"]
[null,"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":6},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[]
[]
[null,"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":6},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[]
[]
[]
[]
["Relais",{"$nulls":6},"Relais"]
[null,"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":6},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[]
[]
[null,"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":6},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]
[]
[]
[null,"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _",{"$nulls":6},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _"]

{"sheet":"Grille","index":4,"n_rows":19,"n_cols":28,"rows_kept":19,"merged":[[0,19,0,22],[3,19,6,19],[3,20,6,20],[3,21,6,21],[3,22,6,22],[3,23,6,23],[3,24,6,24],[3,25,6,25],[3,26,6,26],[3,27,6,27],[4,1,5,1],[7,19,10,19],[7,20,10,20],[7,21,10,21],[7,22,10,22],[7,23,10,23],[7,24,10,24],[7,25,10,25],[7,26,10,26],[7,27,10,27],[8,1,9,1],[11,19,14,19],[11,20,14,20],[11,21,14,21],[11,22,14,22],[11,23,14,23],[11,24,14,24],[11,25,14,25],[11,26,14,26],[11,27,14,27],[12,1,13,1],[15,19,18,19],[15,20,18,20],[15,21,18,21],[15,22,18,22],[15,23,18,23],[15,24,18,24],[15,25,18,25],[15,26,18,26],[15,27,18,27],[16,1,17,1]]}
[null,{"$f":"Préparation!B9 & \" - \" &Préparation!B10","v":"CF D2 5 Quilles - Eliminatoires Ligue"},{"$nulls":17},{"$f":"Préparation!B12","v":"A remplir"}]
[]
[null,{"$f":"Préparation!B11","v":"A"},{"$f":"\"E1 \" & B5","v":"E1 BLOIS"},{"$nulls":3},{"$f":"\"E2 \" & B9","v":"E2 MER"},{"$nulls":3},{"$f":"\"E3 \" & B13","v":"E3 SAINT DENIS EN VAL"},{"$nulls":3},{"$f":"\"E4 \" & B17","v":"E4 EXEMPT"},{"$nulls":4},"Clst","Pts \nRenc.","Pts Match","Moy. Gen.","Moy. Part.","Pts marq.","Pts subis","Calcul\n1er","Renc.\ndirecte"]
[null,"Equipe 1","Matchs",null,null,"Rencontre","S","D","R","E1-E2","S","D","R","E1-E3","S","D","R","E1-E4",null,{"$f":"IF(AA4=\"\",\"\",IF(AB4<>\"\",AB4,RANK(AA4,$AA$4:$AA$19)))","v":""},{"$f":"COUNTIF(F5:R5,\"G\")*2","v":0},{"$f":"SUM(J6,N6,R6)","v":0},{"$f":"IF(Z4<>0,ROUNDDOWN(Y4/Z4,3),\"\")","v":""},{"$f":"MAX(J7,N7,R7)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(G5:I5,K5:M5,O5:Q5)","v":0},{"$f":"SUM(G6:I6,K6:M6,O6:Q6)","v":0},{"$f":"IF(W4<>\"\",(U4*10000000)+(V4*100000)+(W4*10000)+X4,\"\")","v":""}]
[null,{"$f":"Préparation!$A$3","v":"BLOIS"},"Pts marqués",null,null,"G/P",{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&J4&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&J4&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&J4&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(G7:I7,\"Err!\")>0,\"Err!\",IF(I5=\"\",\"\",IF(J6>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&N4&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&N4&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&N4&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(K7:M7,\"Err!\")>0,\"Err!\",IF(M5=\"\",\"\",IF(N6>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&R4&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&R4&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&R4&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(O7:Q7,\"Err!\")>0,\"Err!\",IF(Q5=\"\",\"\",IF(R6>PtMatch,\"G\",\"P\")))","v":""}]
[null,null,"Pts subis",null,null,"Pts de Match",{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&J4&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&J4&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&J4&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&J4&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(G5=\"\",\"\",SUM(COUNTIF(G5,Préparation!$C$2),COUNTIF(H5,Préparation!$D$2),COUNTIF(I5,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&N4&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&N4&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N4&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&N4&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(K5=\"\",\"\",SUM(COUNTIF(K5,Préparation!$C$2),COUNTIF(L5,Préparation!$D$2),COUNTIF(M5,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&R4&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&R4&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R4&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&R4&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(O5=\"\",\"\",SUM(COUNTIF(O5,Préparation!$C$2),COUNTIF(P5,Préparation!$D$2),COUNTIF(Q5,Préparation!$E$2))*PtMatch)","v":""}]
[{"$nulls":5},"Moyenne",{"$f":"IF(_xlfn.XOR(G5<>\"\",G6<>\"\"),\"...\",IF(AND(G5<>\"\",G6<>\"\",COUNTIF(G5,Préparation!$C$2)+COUNTIF(G6,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(H5<>\"\",H6<>\"\"),\"...\",IF(AND(H5<>\"\",H6<>\"\",COUNTIF(H5,Préparation!$D$2)+COUNTIF(H6,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(I5<>\"\",I6<>\"\"),\"...\",IF(AND(I5<>\"\",I6<>\"\",COUNTIF(I5,Préparation!$E$2)+COUNTIF(I6,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(J5=\"\",\"\",IF(SUM(G6:I6)<>0,ROUNDDOWN(SUM(G5:I5)/SUM(G6:I6),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(K5<>\"\",K6<>\"\"),\"...\",IF(AND(K5<>\"\",K6<>\"\",COUNTIF(K5,Préparation!$C$2)+COUNTIF(K6,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(L5<>\"\",L6<>\"\"),\"...\",IF(AND(L5<>\"\",L6<>\"\",COUNTIF(L5,Préparation!$D$2)+COUNTIF(L6,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(M5<>\"\",M6<>\"\"),\"...\",IF(AND(M5<>\"\",M6<>\"\",COUNTIF(M5,Préparation!$E$2)+COUNTIF(M6,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(N5=\"\",\"\",IF(SUM(K6:M6)<>0,ROUNDDOWN(SUM(K5:M5)/SUM(K6:M6),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(O5<>\"\",O6<>\"\"),\"...\",IF(AND(O5<>\"\",O6<>\"\",COUNTIF(O5,Préparation!$C$2)+COUNTIF(O6,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(P5<>\"\",P6<>\"\"),\"...\",IF(AND(P5<>\"\",P6<>\"\",COUNTIF(P5,Préparation!$D$2)+COUNTIF(P6,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(Q5<>\"\",Q6<>\"\"),\"...\",IF(AND(Q5<>\"\",Q6<>\"\",COUNTIF(Q5,Préparation!$E$2)+COUNTIF(Q6,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(R5=\"\",\"\",IF(SUM(O6:Q6)<>0,ROUNDDOWN(SUM(O5:Q5)/SUM(O6:Q6),3),\"\"))","v":""}]
[null,"Equipe 2","S","D","R",{"$f":"J4","v":"E1-E2"},{"$nulls":4},"S","D","R","E2-E3","S","D","R","E2-E4",null,{"$f":"IF(AA8=\"\",\"\",IF(AB8<>\"\",AB8,RANK(AA8,$AA$4:$AA$19)))","v":""},{"$f":"COUNTIF(F9:R9,\"G\")*2","v":0},{"$f":"SUM(F10,N10,R10)","v":0},{"$f":"IF(Z8<>0,ROUNDDOWN(Y8/Z8,3),\"\")","v":""},{"$f":"MAX(F11,N11,R11)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(C9:E9,K9:M9,O9:Q9)","v":0},{"$f":"SUM(C10:E10,K10:M10,O10:Q10)","v":0},{"$f":"IF(W8<>\"\",(U8*10000000)+(V8*100000)+(W8*10000)+X8,\"\")","v":""}]
[null,{"$f":"Préparation!$A$4","v":"MER"},{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(H6<>\"\",H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6,\"\")","v":""},{"$f":"IF(COUNTIF(C11:E11,\"Err!\")>0,\"Err!\",IF(E9=\"\",\"\",IF(F10>PtMatch,\"G\",\"P\")))","v":""},{"$nulls":4},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&N8&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&N8&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&N8&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(K11:M11,\"Err!\")>0,\"Err!\",IF(M9=\"\",\"\",IF(N10>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&R8&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&R8&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&R8&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(O11:Q11,\"Err!\")>0,\"Err!\",IF(Q9=\"\",\"\",IF(R10>PtMatch,\"G\",\"P\")))","v":""}]
[null,null,{"$f":"IF(G5<>\"\",G5,\"\")","v":""},{"$f":"IF(H5<>\"\",H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5,\"\")","v":""},{"$f":"IF(C9=\"\",\"\",SUM(COUNTIF(C9,Préparation!$C$2),COUNTIF(D9,Préparation!$D$2),COUNTIF(E9,Préparation!$E$2))*PtMatch)","v":""},{"$nulls":4},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&N8&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&N8&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&N8&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&N8&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(K9=\"\",\"\",SUM(COUNTIF(K9,Préparation!$C$2),COUNTIF(L9,Préparation!$D$2),COUNTIF(M9,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&R8&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&R8&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R8&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&R8&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(O9=\"\",\"\",SUM(COUNTIF(O9,Préparation!$C$2),COUNTIF(P9,Préparation!$D$2),COUNTIF(Q9,Préparation!$E$2))*PtMatch)","v":""}]
[null,null,{"$f":"IF(_xlfn.XOR(C9<>\"\",C10<>\"\"),\"...\",IF(AND(C9<>\"\",C10<>\"\",COUNTIF(C9,Préparation!$C$2)+COUNTIF(C10,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(D9<>\"\",D10<>\"\"),\"...\",IF(AND(D9<>\"\",D10<>\"\",COUNTIF(D9,Préparation!$D$2)+COUNTIF(D10,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(E9<>\"\",E10<>\"\"),\"...\",IF(AND(E9<>\"\",E10<>\"\",COUNTIF(E9,Préparation!$E$2)+COUNTIF(E10,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(F9=\"\",\"\",IF(SUM(C10:E10)<>0,ROUNDDOWN(SUM(C9:E9)/SUM(C10:E10),3),\"\"))","v":""},{"$nulls":4},{"$f":"IF(_xlfn.XOR(K9<>\"\",K10<>\"\"),\"...\",IF(AND(K9<>\"\",K10<>\"\",COUNTIF(K9,Préparation!$C$2)+COUNTIF(K10,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(L9<>\"\",L10<>\"\"),\"...\",IF(AND(L9<>\"\",L10<>\"\",COUNTIF(L9,Préparation!$D$2)+COUNTIF(L10,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(M9<>\"\",M10<>\"\"),\"...\",IF(AND(M9<>\"\",M10<>\"\",COUNTIF(M9,Préparation!$E$2)+COUNTIF(M10,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(N9=\"\",\"\",IF(SUM(K10:M10)<>0,ROUNDDOWN(SUM(K9:M9)/SUM(K10:M10),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(O9<>\"\",O10<>\"\"),\"...\",IF(AND(O9<>\"\",O10<>\"\",COUNTIF(O9,Préparation!$C$2)+COUNTIF(O10,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(P9<>\"\",P10<>\"\"),\"...\",IF(AND(P9<>\"\",P10<>\"\",COUNTIF(P9,Préparation!$D$2)+COUNTIF(P10,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(Q9<>\"\",Q10<>\"\"),\"...\",IF(AND(Q9<>\"\",Q10<>\"\",COUNTIF(Q9,Préparation!$E$2)+COUNTIF(Q10,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(R9=\"\",\"\",IF(SUM(O10:Q10)<>0,ROUNDDOWN(SUM(O9:Q9)/SUM(O10:Q10),3),\"\"))","v":""}]
[null,"Equipe 3","S","D","R",{"$f":"N4","v":"E1-E3"},"S","D","R",{"$f":"N8","v":"E2-E3"},{"$nulls":4},"S","D","R","E3-E4",null,{"$f":"IF(AA12=\"\",\"\",IF(AB12<>\"\",AB12,RANK(AA12,$AA$4:$AA$19)))","v":""},{"$f":"COUNTIF(F13:R13,\"G\")*2","v":0},{"$f":"SUM(F14,J14,R14)","v":0},{"$f":"IF(Z12<>0,ROUNDDOWN(Y12/Z12,3),\"\")","v":""},{"$f":"MAX(J15,F15,R15)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(G13:I13,C13:E13,O13:Q13)","v":0},{"$f":"SUM(G14:I14,C14:E14,O14:Q14)","v":0},{"$f":"IF(W12<>\"\",(U12*10000000)+(V12*100000)+(W12*10000)+X12,\"\")","v":""}]
[null,{"$f":"Préparation!$A$5","v":"SAINT DENIS EN VAL"},{"$f":"IF(K6<>\"\",K6,\"\")","v":""},{"$f":"IF(L6<>\"\",L6,\"\")","v":""},{"$f":"IF(M6<>\"\",M6,\"\")","v":""},{"$f":"IF(COUNTIF(C15:E15,\"Err!\")>0,\"Err!\",IF(E13=\"\",\"\",IF(F14>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(K10<>\"\",K10,\"\")","v":""},{"$f":"IF(L10<>\"\",L10,\"\")","v":""},{"$f":"IF(M10<>\"\",M10,\"\")","v":""},{"$f":"IF(COUNTIF(G15:I15,\"Err!\")>0,\"Err!\",IF(I13=\"\",\"\",IF(J14>PtMatch,\"G\",\"P\")))","v":""},{"$nulls":4},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$D$13\")<>\"\",INDIRECT(\"'\"&R12&\"'!$D$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$D$16\")<>\"\",INDIRECT(\"'\"&R12&\"'!$D$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$D$20\")<>\"\",INDIRECT(\"'\"&R12&\"'!$D$20\"),\"\")","v":""},{"$f":"IF(COUNTIF(O15:Q15,\"Err!\")>0,\"Err!\",IF(Q13=\"\",\"\",IF(R14>PtMatch,\"G\",\"P\")))","v":""}]
[null,null,{"$f":"IF(K5<>\"\",K5,\"\")","v":""},{"$f":"IF(L5<>\"\",L5,\"\")","v":""},{"$f":"IF(M5<>\"\",M5,\"\")","v":""},{"$f":"IF(C13=\"\",\"\",SUM(COUNTIF(C13,Préparation!$C$2),COUNTIF(D13,Préparation!$D$2),COUNTIF(E13,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(K9<>\"\",K9,\"\")","v":""},{"$f":"IF(L9<>\"\",L9,\"\")","v":""},{"$f":"IF(M9<>\"\",M9,\"\")","v":""},{"$f":"IF(G13=\"\",\"\",SUM(COUNTIF(G13,Préparation!$C$2),COUNTIF(H13,Préparation!$D$2),COUNTIF(I13,Préparation!$E$2))*PtMatch)","v":""},{"$nulls":4},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$F$13\")<>\"\",INDIRECT(\"'\"&R12&\"'!$F$13\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$F$16\")<>\"\",INDIRECT(\"'\"&R12&\"'!$F$16\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"'\"&R12&\"'!$F$20\")<>\"\",INDIRECT(\"'\"&R12&\"'!$F$20\"),\"\")","v":""},{"$f":"IF(O13=\"\",\"\",SUM(COUNTIF(O13,Préparation!$C$2),COUNTIF(P13,Préparation!$D$2),COUNTIF(Q13,Préparation!$E$2))*PtMatch)","v":""}]
[null,null,{"$f":"IF(_xlfn.XOR(C13<>\"\",C14<>\"\"),\"...\",IF(AND(C13<>\"\",C14<>\"\",COUNTIF(C13,Préparation!$C$2)+COUNTIF(C14,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(D13<>\"\",D14<>\"\"),\"...\",IF(AND(D13<>\"\",D14<>\"\",COUNTIF(D13,Préparation!$D$2)+COUNTIF(D14,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(E13<>\"\",E14<>\"\"),\"...\",IF(AND(E13<>\"\",E14<>\"\",COUNTIF(E13,Préparation!$E$2)+COUNTIF(E14,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(F13=\"\",\"\",IF(SUM(C14:E14)<>0,ROUNDDOWN(SUM(C13:E13)/SUM(C14:E14),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(G13<>\"\",G14<>\"\"),\"...\",IF(AND(G13<>\"\",G14<>\"\",COUNTIF(G13,Préparation!$C$2)+COUNTIF(G14,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(H13<>\"\",H14<>\"\"),\"...\",IF(AND(H13<>\"\",H14<>\"\",COUNTIF(H13,Préparation!$D$2)+COUNTIF(H14,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(I13<>\"\",I14<>\"\"),\"...\",IF(AND(I13<>\"\",I14<>\"\",COUNTIF(I13,Préparation!$E$2)+COUNTIF(I14,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(J13=\"\",\"\",IF(SUM(G14:I14)<>0,ROUNDDOWN(SUM(G13:I13)/SUM(G14:I14),3),\"\"))","v":""},{"$nulls":4},{"$f":"IF(_xlfn.XOR(O13<>\"\",O14<>\"\"),\"...\",IF(AND(O13<>\"\",O14<>\"\",COUNTIF(O13,Préparation!$C$2)+COUNTIF(O14,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(P13<>\"\",P14<>\"\"),\"...\",IF(AND(P13<>\"\",P14<>\"\",COUNTIF(P13,Préparation!$D$2)+COUNTIF(P14,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(Q13<>\"\",Q14<>\"\"),\"...\",IF(AND(Q13<>\"\",Q14<>\"\",COUNTIF(Q13,Préparation!$E$2)+COUNTIF(Q14,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(R13=\"\",\"\",IF(SUM(O14:Q14)<>0,ROUNDDOWN(SUM(O13:Q13)/SUM(O14:Q14),3),\"\"))","v":""}]
[null,"Equipe 4","S","D","R",{"$f":"R4","v":"E1-E4"},"S","D","R",{"$f":"R8","v":"E2-E4"},"S","D","R",{"$f":"R12","v":"E3-E4"},{"$nulls":5},{"$f":"IF(AA16=\"\",\"\",IF(AB16<>\"\",AB16,RANK(AA16,$AA$4:$AA$19)))","v":""},{"$f":"COUNTIF(F17:R17,\"G\")*2","v":0},{"$f":"SUM(F18,J18,N18)","v":0},{"$f":"IF(Z16<>0,ROUNDDOWN(Y16/Z16,3),\"\")","v":""},{"$f":"MAX(J19,N19,F19)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(G17:I17,K17:M17,C17:E17)","v":0},{"$f":"SUM(G18:I18,K18:M18,C18:E18)","v":0},{"$f":"IF(W16<>\"\",(U16*10000000)+(V16*100000)+(W16*10000)+X16,\"\")","v":""}]
[null,{"$f":"Préparation!$A$6","v":"EXEMPT"},{"$f":"IF(O6<>\"\",O6,\"\")","v":""},{"$f":"IF(P6<>\"\",P6,\"\")","v":""},{"$f":"IF(Q6<>\"\",Q6,\"\")","v":""},{"$f":"IF(COUNTIF(C19:E19,\"Err!\")>0,\"Err!\",IF(E17=\"\",\"\",IF(F18>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(O10<>\"\",O10,\"\")","v":""},{"$f":"IF(P10<>\"\",P10,\"\")","v":""},{"$f":"IF(Q10<>\"\",Q10,\"\")","v":""},{"$f":"IF(COUNTIF(G19:I19,\"Err!\")>0,\"Err!\",IF(I17=\"\",\"\",IF(J18>PtMatch,\"G\",\"P\")))","v":""},{"$f":"IF(O14<>\"\",O14,\"\")","v":""},{"$f":"IF(P14<>\"\",P14,\"\")","v":""},{"$f":"IF(Q14<>\"\",Q14,\"\")","v":""},{"$f":"IF(COUNTIF(K19:M19,\"Err!\")>0,\"Err!\",IF(M17=\"\",\"\",IF(N18>PtMatch,\"G\",\"P\")))","v":""}]
[null,null,{"$f":"IF(O5<>\"\",O5,\"\")","v":""},{"$f":"IF(P5<>\"\",P5,\"\")","v":""},{"$f":"IF(Q5<>\"\",Q5,\"\")","v":""},{"$f":"IF(C17=\"\",\"\",SUM(COUNTIF(C17,Préparation!$C$2),COUNTIF(D17,Préparation!$D$2),COUNTIF(E17,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(O9<>\"\",O9,\"\")","v":""},{"$f":"IF(P9<>\"\",P9,\"\")","v":""},{"$f":"IF(Q9<>\"\",Q9,\"\")","v":""},{"$f":"IF(G17=\"\",\"\",SUM(COUNTIF(G17,Préparation!$C$2),COUNTIF(H17,Préparation!$D$2),COUNTIF(I17,Préparation!$E$2))*PtMatch)","v":""},{"$f":"IF(O13<>\"\",O13,\"\")","v":""},{"$f":"IF(P13<>\"\",P13,\"\")","v":""},{"$f":"IF(Q13<>\"\",Q13,\"\")","v":""},{"$f":"IF(K17=\"\",\"\",SUM(COUNTIF(K17,Préparation!$C$2),COUNTIF(L17,Préparation!$D$2),COUNTIF(M17,Préparation!$E$2))*PtMatch)","v":""}]
[null,null,{"$f":"IF(_xlfn.XOR(C17<>\"\",C18<>\"\"),\"...\",IF(AND(C17<>\"\",C18<>\"\",COUNTIF(C17,Préparation!$C$2)+COUNTIF(C18,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(D17<>\"\",D18<>\"\"),\"...\",IF(AND(D17<>\"\",D18<>\"\",COUNTIF(D17,Préparation!$D$2)+COUNTIF(D18,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(E17<>\"\",E18<>\"\"),\"...\",IF(AND(E17<>\"\",E18<>\"\",COUNTIF(E17,Préparation!$E$2)+COUNTIF(E18,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(F17=\"\",\"\",IF(SUM(C18:E18)<>0,ROUNDDOWN(SUM(C17:E17)/SUM(C18:E18),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(G17<>\"\",G18<>\"\"),\"...\",IF(AND(G17<>\"\",G18<>\"\",COUNTIF(G17,Préparation!$C$2)+COUNTIF(G18,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(H17<>\"\",H18<>\"\"),\"...\",IF(AND(H17<>\"\",H18<>\"\",COUNTIF(H17,Préparation!$D$2)+COUNTIF(H18,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(I17<>\"\",I18<>\"\"),\"...\",IF(AND(I17<>\"\",I18<>\"\",COUNTIF(I17,Préparation!$E$2)+COUNTIF(I18,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(J17=\"\",\"\",IF(SUM(G18:I18)<>0,ROUNDDOWN(SUM(G17:I17)/SUM(G18:I18),3),\"\"))","v":""},{"$f":"IF(_xlfn.XOR(K17<>\"\",K18<>\"\"),\"...\",IF(AND(K17<>\"\",K18<>\"\",COUNTIF(K17,Préparation!$C$2)+COUNTIF(K18,Préparation!$C$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(L17<>\"\",L18<>\"\"),\"...\",IF(AND(L17<>\"\",L18<>\"\",COUNTIF(L17,Préparation!$D$2)+COUNTIF(L18,Préparation!$D$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(_xlfn.XOR(M17<>\"\",M18<>\"\"),\"...\",IF(AND(M17<>\"\",M18<>\"\",COUNTIF(M17,Préparation!$E$2)+COUNTIF(M18,Préparation!$E$2)<>1),\"Err!\",\"\"))","v":""},{"$f":"IF(N17=\"\",\"\",IF(SUM(K18:M18)<>0,ROUNDDOWN(SUM(K17:M17)/SUM(K18:M18),3),\"\"))","v":""}]

{"sheet":"E1-E2","index":5,"n_rows":22,"n_cols":8,"rows_kept":22}
[null,"Go to Grille"]
[null,"E1-E2",{"$f":"Préparation!A3","v":"BLOIS"},{"$nulls":3},{"$f":"Préparation!A4","v":"MER"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"HAYES Arnaud"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"CHESNEAU Christophe"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"CHANTERAUD Dominique"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"FOURRE Cedric"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ARRACHEPIED Yohan"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"RUBLINE Pascal"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ORGEBIN Patrice"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"PICOT COURNEE Sylvain"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"FONTAINE Isabelle"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"BOURSEREAU François"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"MARCHISSEAU Stéphane"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"BLOIS"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"MER"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]

{"sheet":"E1-E3","index":6,"n_rows":22,"n_cols":8,"rows_kept":22}
[null,"Go to Grille"]
[null,"E1-E3",{"$f":"Préparation!A3","v":"BLOIS"},{"$nulls":3},{"$f":"Préparation!A5","v":"SAINT DENIS EN VAL"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"HAYES Arnaud"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"COSTAS FREITAS Domingos"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"CHANTERAUD Dominique"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"SERVANT Denis"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ARRACHEPIED Yohan"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"MUNGUIA Bruno"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ORGEBIN Patrice"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"BOUBAULT Andre"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"FONTAINE Isabelle"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"LECLAND Michel"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"MARCHISSEAU Stéphane"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"BLOIS"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"SAINT DENIS EN VAL"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]

{"sheet":"E2-E3","index":7,"n_rows":22,"n_cols":8,"rows_kept":22}
[null,"Go to Grille"]
[null,"E3-E3",{"$f":"Préparation!A4","v":"MER"},{"$nulls":3},{"$f":"Préparation!A5","v":"SAINT DENIS EN VAL"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"CHESNEAU Christophe"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"COSTAS FREITAS Domingos"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"FOURRE Cedric"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"SERVANT Denis"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"RUBLINE Pascal"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"MUNGUIA Bruno"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"PICOT COURNEE Sylvain"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"BOUBAULT Andre"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"BOURSEREAU François"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":"LECLAND Michel"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":0},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"MER"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"SAINT DENIS EN VAL"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]

{"sheet":"E1-E4","index":8,"n_rows":22,"n_cols":8,"rows_kept":22,"hidden":true}
[null,"Go to Grille"]
[null,"E1-E4",{"$f":"Préparation!A3","v":"BLOIS"},{"$nulls":3},{"$f":"Préparation!A6","v":"EXEMPT"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"HAYES Arnaud"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"CHANTERAUD Dominique"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ARRACHEPIED Yohan"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"ORGEBIN Patrice"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"FONTAINE Isabelle"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"MARCHISSEAU Stéphane"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"BLOIS"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"EXEMPT"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]

{"sheet":"E2-E4","index":9,"n_rows":22,"n_cols":8,"rows_kept":22,"hidden":true}
[null,"Go to Grille"]
[null,"E3-E4",{"$f":"Préparation!A4","v":"MER"},{"$nulls":3},{"$f":"Préparation!A6","v":"EXEMPT"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"CHESNEAU Christophe"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"FOURRE Cedric"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"RUBLINE Pascal"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"PICOT COURNEE Sylvain"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"BOURSEREAU François"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":0},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"MER"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"EXEMPT"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]

{"sheet":"E3-E4","index":10,"n_rows":22,"n_cols":8,"rows_kept":22,"hidden":true}
[null,"Go to Grille"]
[null,"E3-E4",{"$f":"Préparation!A5","v":"SAINT DENIS EN VAL"},{"$nulls":3},{"$f":"Préparation!A6","v":"EXEMPT"}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"COSTAS FREITAS Domingos"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,2,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"SERVANT Denis"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,3,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"MUNGUIA Bruno"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,4,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"BOUBAULT Andre"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,5,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":"LECLAND Michel"},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,6,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":0},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,7,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":0}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,8,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[null,null,{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(C$2,Equipes!$1:$1,0)),\"\")","v":" "},{"$nulls":3},{"$f":"IFERROR(INDEX(Equipes!$A$1:$R$9,9,MATCH(G$2,Equipes!$1:$1,0)),\"\")","v":" "}]
[]
[null,{"$f":"\"S \" & Préparation!C2 & \" - D \" &Préparation!D2 & \" - R \" & Préparation!E2","v":"S 100 - D 100 - R 150"},{"$f":"IF(C2<>\"\",C2,\"\")","v":"SAINT DENIS EN VAL"},"Pts faits",null,"Pts faits",{"$f":"IF(G2<>\"\",G2,\"\")","v":"EXEMPT"},{"$f":"B12","v":"S 100 - D 100 - R 150"}]
[null,{"$f":"\"Simple \" &Préparation!C2 & \" pts\"","v":"Simple 100 pts"},{"$nulls":5},"Simple"]
[null,"Double",{"$nulls":5},"Double"]
[]
[null,null,"Total double",{"$nulls":3},"Total double"]
[null,"Relais",{"$nulls":5},"Relais"]
[null,"Changements à",{"$nulls":5},{"$f":"B18","v":"Changements à"}]
[null,{"$f":"Préparation!$E$2/3 & \" et \" & Préparation!$E$2/3*2 & \" pts\"","v":"50 et 100 pts"},{"$nulls":5},{"$f":"B19","v":"50 et 100 pts"}]
[null,null,"Total relais",{"$nulls":3},"Total relais"]
[]
[null,null,"Signature  capitaine",{"$nulls":3},{"$f":"C22","v":"Signature  capitaine"}]