{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MATCH","Feuil1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"MATCH","index":0,"n_rows":531,"n_cols":46,"rows_kept":531,"cut":false,"hidden":false,"merged":[[20,12,20,15],[20,18,20,20],[0,0,0,21],[1,4,1,21],[2,9,2,12],[3,19,3,20],[19,12,19,15],[19,18,19,21]]}
["TOURNOI INTERNATIONAL DE FRANCE - SOUVENIR DENIS RANDON 2015"]
[null,null,null,null,"13ème Edition      Clermont l'Hérault           Samedi 24 octobre"]
[]
["SEXE","Tir","REG.","Place","NOMS","Prénoms","Nationalité","AN","POIDS",1,2,3,"ARR",1,2,3,"EP-J","Total","IWF","Class",null,"Catég","Points","DEP +","REG +","IRG +","FED +","NAT +","INTB +","INTA +","OLY +","NCL"]
[null,null,null,null,"HOMMES"]
["H",null,null,null,"AUCOUTURIER","Yann","France",86,70.650000000000006,125,129,132,{"$f":"IF(I6=\"\",\"\",IF(MAXA(J6:L6)<=0,0,MAXA(J6:L6)))","v":132},159,165,167,{"$f":"IF(I6=\"\",\"\",IF(MAXA(N6:P6)<=0,0,MAXA(N6:P6)))","v":167},{"$f":"IF(I6=\"\",\"\",IF(OR(M6=0,Q6=0),0,M6+Q6))","v":299},{"$f":"IF(I6=\"\",\"\",IF(A6=\"H\",10^(0.794358141*LOG(I6/174.393)^2)*R6,IF(A6=\"F\",10^(0.89726074*LOG(I6/148.026)^2)*R6,\"\")))","v":396.27365491680575},{"$f":"RANK(S6,S6:S17)","v":3},null,{"$f":"IF(I6=\"\",\"\",IF(A6=\"H\",IF(OR(H6=\"SEN\",H6<94),VLOOKUP(I6,Feuil1!$A$10:$E$28,5),IF(AND(H6>93,H6<97),VLOOKUP(I6,Feuil1!$A$10:$E$28,4),IF(AND(H6>93,H6<96),VLOOKUP(I6,Feuil1!$A$10:$E$28,3),IF(AND(H6>95,H6<2000),VLOOKUP(I6,Feuil1!$A$10:$E$28,3),VLOOKUP(I6,Feuil1!$A$10:$E$28,2))))),IF(OR(H6=\"SEN\",H6<94),VLOOKUP(I6,Feuil1!$F$10:$J$24,5),IF(AND(H6>93,H6<97),VLOOKUP(I6,Feuil1!$F$10:$J$24,4),IF(AND(H6>93,H6<96),VLOOKUP(I6,Feuil1!$F$10:$J$24,4),IF(AND(H6>93,H6<2000),VLOOKUP(I6,Feuil1!$F$10:$J$24,3),VLOOKUP(I6,Feuil1!$F$10:$J$24,2)))))))","v":"S77"},null,{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,4,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,5,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,7,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,8,FALSE)","v":{"$error":"#REF!"}},{"$f":"R6-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,9,FALSE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"IF(AE6>=0,$AE$4,IF(AD6>=0,$AD$4,IF(AC6>=0,$AC$4,IF(AB6>=0,$AB$4,IF(AA6>=0,$AA$4,IF(Z6>=0,$Z$4,IF(Y6>=0,$Y$4,IF(X6>=0,$X$4,$AF$4))))))))","v":{"$error":"#REF!"}}]
["H",null,null,null,"BOULY","Kévin","France",81,107.75,-155,-155,-155,{"$f":"IF(I7=\"\",\"\",IF(MAXA(J7:L7)<=0,0,MAXA(J7:L7)))","v":0},190,-200,200,{"$f":"IF(I7=\"\",\"\",IF(MAXA(N7:P7)<=0,0,MAXA(N7:P7)))","v":200},{"$f":"IF(I7=\"\",\"\",IF(OR(M7=0,Q7=0),0,M7+Q7))","v":0},{"$f":"IF(I7=\"\",\"\",IF(A7=\"H\",10^(0.794358141*LOG(I7/174.393)^2)*R7,IF(A7=\"F\",10^(0.89726074*LOG(I7/148.026)^2)*R7,\"\")))","v":0},{"$f":"RANK(S7,S6:S17)","v":10},null,{"$f":"IF(I7=\"\",\"\",IF(A7=\"H\",IF(OR(H7=\"SEN\",H7<94),VLOOKUP(I7,Feuil1!$A$10:$E$28,5),IF(AND(H7>93,H7<97),VLOOKUP(I7,Feuil1!$A$10:$E$28,4),IF(AND(H7>93,H7<96),VLOOKUP(I7,Feuil1!$A$10:$E$28,3),IF(AND(H7>95,H7<2000),VLOOKUP(I7,Feuil1!$A$10:$E$28,3),VLOOKUP(I7,Feuil1!$A$10:$E$28,2))))),IF(OR(H7=\"SEN\",H7<94),VLOOKUP(I7,Feuil1!$F$10:$J$24,5),IF(AND(H7>93,H7<97),VLOOKUP(I7,Feuil1!$F$10:$J$24,4),IF(AND(H7>93,H7<96),VLOOKUP(I7,Feuil1!$F$10:$J$24,4),IF(AND(H7>93,H7<2000),VLOOKUP(I7,Feuil1!$F$10:$J$24,3),VLOOKUP(I7,Feuil1!$F$10:$J$24,2)))))))","v":"S+105"},null,{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,4,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,5,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,7,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,8,FALSE)","v":{"$error":"#REF!"}},{"$f":"R7-HLOOKUP(#REF!,Feuil1!$C$1:$AU$9,9,FALSE)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"IF(AE7>=0,$AE$4,IF(AD7>=0,$AD$4,IF(AC7>=0,$AC$4,IF(AB7>=0,$AB$4,IF(AA7>=0,$AA$4,IF(Z7>=0,$Z$4,IF(Y7>=0,$Y$4,IF(X7>=0,$X$4,$AF$4))))))))","v":{"$error":"#REF!"}}]
["H",null,null,null,"BARDIS","Jean Baptiste","France",87,87.45,155,-160,-161,{"$f":"IF(I8=\"\",\"\",IF(MAXA(J8:L8)<=0,0,MAXA(J8:L8)))","v":155},185,190,-196,{"$f":"IF(I8=\"\",\"\",IF(MAXA(N8:P8)<=0,0,MAXA(N8:P8)))","v":190},{"$f":"IF(I8=\"\",\"\",IF(OR(M8=0,Q8=0),0,M8+Q8))","v":345},{"$f":"IF(I8=\"\",\"\",IF(A8=\"H\",10^(0.794358141*LOG(I8/174.393)^2)*R8,IF(A8=\"F\",10^(0.89726074*LOG(I8/148.026)^2)*R8,\"\")))","v":406.63184216248857},{"$f":"RANK(S8,S6:S17)","v":2},{"$f":"IF(I8=\"\",\"\",IF(AE8>=0,AE8,IF(AD8>=0,AD8,IF(AC8>=0,AC8,IF(AB8>=0,AB8,IF(AA8>=0,AA8,IF(Z8>=0,Z8,IF(Y8>=0,Y8,X8))))))))","v":5},{"$f":"IF(I8=\"\",\"\",IF(A8=\"H\",IF(OR(H8=\"SEN\",H8<94),VLOOKUP(I8,Feuil1!$A$10:$E$28,5),IF(AND(H8>93,H8<97),VLOOKUP(I8,Feuil1!$A$10:$E$28,4),IF(AND(H8>93,H8<96),VLOOKUP(I8,Feuil1!$A$10:$E$28,3),IF(AND(H8>95,H8<2000),VLOOKUP(I8,Feuil1!$A$10:$E$28,3),VLOOKUP(I8,Feuil1!$A$10:$E$28,2))))),IF(OR(H8=\"SEN\",H8<94),VLOOKUP(I8,Feuil1!$F$10:$J$24,5),IF(AND(H8>93,H8<97),VLOOKUP(I8,Feuil1!$F$10:$J$24,4),IF(AND(H8>93,H8<96),VLOOKUP(I8,Feuil1!$F$10:$J$24,4),IF(AND(H8>93,H8<2000),VLOOKUP(I8,Feuil1!$F$10:$J$24,3),VLOOKUP(I8,Feuil1!$F$10:$J$24,2)))))))","v":"S94"},{"$f":"SUM(R8-(I8*2))","v":170.1},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,2,FALSE)","v":160},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,3,FALSE)","v":140},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,4,FALSE)","v":115},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,5,FALSE)","v":85},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,6,FALSE)","v":55},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,7,FALSE)","v":25},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,8,FALSE)","v":5},{"$f":"R8-HLOOKUP(V8,Feuil1!$C$1:$AU$9,9,FALSE)","v":-10},null,null,null,null,null,null,null,{"$f":"IF(AE8>=0,$AE$4,IF(AD8>=0,$AD$4,IF(AC8>=0,$AC$4,IF(AB8>=0,$AB$4,IF(AA8>=0,$AA$4,IF(Z8>=0,$Z$4,IF(Y8>=0,$Y$4,IF(X8>=0,$X$4,$AF$4))))))))","v":"INTA +"}]
["H",null,null,null,"KINGUE MATAM","Bernardin","France",90,71.849999999999994,-143,143,-150,143,175,180,-185,180,323,423.65157365828441,{"$f":"RANK(S9,S6:S17)","v":1},13,{"$f":"IF(I9=\"\",\"\",IF(A9=\"H\",IF(OR(H9=\"SEN\",H9<94),VLOOKUP(I9,Feuil1!$A$10:$E$28,5),IF(AND(H9>93,H9<97),VLOOKUP(I9,Feuil1!$A$10:$E$28,4),IF(AND(H9>93,H9<96),VLOOKUP(I9,Feuil1!$A$10:$E$28,3),IF(AND(H9>95,H9<2000),VLOOKUP(I9,Feuil1!$A$10:$E$28,3),VLOOKUP(I9,Feuil1!$A$10:$E$28,2))))),IF(OR(H9=\"SEN\",H9<94),VLOOKUP(I9,Feuil1!$F$10:$J$24,5),IF(AND(H9>93,H9<97),VLOOKUP(I9,Feuil1!$F$10:$J$24,4),IF(AND(H9>93,H9<96),VLOOKUP(I9,Feuil1!$F$10:$J$24,4),IF(AND(H9>93,H9<2000),VLOOKUP(I9,Feuil1!$F$10:$J$24,3),VLOOKUP(I9,Feuil1!$F$10:$J$24,2)))))))","v":"S77"},{"$f":"SUM(R9-(I9*2))","v":179.3},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,2,FALSE)","v":163},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,3,FALSE)","v":143},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,4,FALSE)","v":118},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,5,FALSE)","v":88},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,6,FALSE)","v":58},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,7,FALSE)","v":33},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,8,FALSE)","v":13},{"$f":"R9-HLOOKUP(V9,Feuil1!$C$1:$AU$9,9,FALSE)","v":-2},null,null,null,null,null,null,null,"INTA +"]
["H",null,null,null,"SUIUGAN DARIUS","Stéphan","Roumanie",93,69.7,-115,120,-126,120,-145,145,150,150,270,360.89484232178057,{"$f":"RANK(S10,S6:S17)","v":8},5,{"$f":"IF(I10=\"\",\"\",IF(A10=\"H\",IF(OR(H10=\"SEN\",H10<94),VLOOKUP(I10,Feuil1!$A$10:$E$28,5),IF(AND(H10>93,H10<97),VLOOKUP(I10,Feuil1!$A$10:$E$28,4),IF(AND(H10>93,H10<96),VLOOKUP(I10,Feuil1!$A$10:$E$28,3),IF(AND(H10>95,H10<2000),VLOOKUP(I10,Feuil1!$A$10:$E$28,3),VLOOKUP(I10,Feuil1!$A$10:$E$28,2))))),IF(OR(H10=\"SEN\",H10<94),VLOOKUP(I10,Feuil1!$F$10:$J$24,5),IF(AND(H10>93,H10<97),VLOOKUP(I10,Feuil1!$F$10:$J$24,4),IF(AND(H10>93,H10<96),VLOOKUP(I10,Feuil1!$F$10:$J$24,4),IF(AND(H10>93,H10<2000),VLOOKUP(I10,Feuil1!$F$10:$J$24,3),VLOOKUP(I10,Feuil1!$F$10:$J$24,2)))))))","v":"S77"},{"$f":"SUM(R10-(I10*2))","v":130.6},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,2,FALSE)","v":110},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,3,FALSE)","v":90},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,4,FALSE)","v":65},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,5,FALSE)","v":35},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,6,FALSE)","v":5},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,7,FALSE)","v":-20},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,8,FALSE)","v":-40},{"$f":"R10-HLOOKUP(V10,Feuil1!$C$1:$AU$9,9,FALSE)","v":-55},null,null,null,null,null,null,null,"NAT +"]
["H",null,null,null,"HENNEQUIN","Benjamin","France",84,87.65,155,-160,-160,155,-190,"-","-",0,0,0,{"$f":"RANK(S11,S6:S17)","v":10},-185,{"$f":"IF(I11=\"\",\"\",IF(A11=\"H\",IF(OR(H11=\"SEN\",H11<94),VLOOKUP(I11,Feuil1!$A$10:$E$28,5),IF(AND(H11>93,H11<97),VLOOKUP(I11,Feuil1!$A$10:$E$28,4),IF(AND(H11>93,H11<96),VLOOKUP(I11,Feuil1!$A$10:$E$28,3),IF(AND(H11>95,H11<2000),VLOOKUP(I11,Feuil1!$A$10:$E$28,3),VLOOKUP(I11,Feuil1!$A$10:$E$28,2))))),IF(OR(H11=\"SEN\",H11<94),VLOOKUP(I11,Feuil1!$F$10:$J$24,5),IF(AND(H11>93,H11<97),VLOOKUP(I11,Feuil1!$F$10:$J$24,4),IF(AND(H11>93,H11<96),VLOOKUP(I11,Feuil1!$F$10:$J$24,4),IF(AND(H11>93,H11<2000),VLOOKUP(I11,Feuil1!$F$10:$J$24,3),VLOOKUP(I11,Feuil1!$F$10:$J$24,2)))))))","v":"S94"},{"$f":"SUM(R11-I11)","v":-87.65},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,2,FALSE)","v":-185},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,3,FALSE)","v":-205},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,4,FALSE)","v":-230},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,5,FALSE)","v":-260},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,6,FALSE)","v":-290},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,7,FALSE)","v":-320},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,8,FALSE)","v":-340},{"$f":"R11-HLOOKUP(V11,Feuil1!$C$1:$AU$9,9,FALSE)","v":-355},null,null,null,null,null,null,null,"NCL"]
["H",null,null,null,"GHAZARIAN","Norik","Arménie",95,78.45,130,135,137,137,165,-170,-170,{"$f":"IF(I12=\"\",\"\",IF(MAXA(N12:P12)<=0,0,MAXA(N12:P12)))","v":165},{"$f":"IF(I12=\"\",\"\",IF(OR(M12=0,Q12=0),0,M12+Q12))","v":302},376.37397774096183,{"$f":"RANK(S12,S6:S17)","v":6},2,{"$f":"IF(I12=\"\",\"\",IF(A12=\"H\",IF(OR(H12=\"SEN\",H12<94),VLOOKUP(I12,Feuil1!$A$10:$E$28,5),IF(AND(H12>93,H12<97),VLOOKUP(I12,Feuil1!$A$10:$E$28,4),IF(AND(H12>93,H12<96),VLOOKUP(I12,Feuil1!$A$10:$E$28,3),IF(AND(H12>95,H12<2000),VLOOKUP(I12,Feuil1!$A$10:$E$28,3),VLOOKUP(I12,Feuil1!$A$10:$E$28,2))))),IF(OR(H12=\"SEN\",H12<94),VLOOKUP(I12,Feuil1!$F$10:$J$24,5),IF(AND(H12>93,H12<97),VLOOKUP(I12,Feuil1!$F$10:$J$24,4),IF(AND(H12>93,H12<96),VLOOKUP(I12,Feuil1!$F$10:$J$24,4),IF(AND(H12>93,H12<2000),VLOOKUP(I12,Feuil1!$F$10:$J$24,3),VLOOKUP(I12,Feuil1!$F$10:$J$24,2)))))))","v":"J85"},223.55,{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,2,FALSE)","v":147},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,3,FALSE)","v":127},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,4,FALSE)","v":107},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,5,FALSE)","v":82},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,6,FALSE)","v":52},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,7,FALSE)","v":22},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,8,FALSE)","v":2},{"$f":"R12-HLOOKUP(V12,Feuil1!$C$1:$AU$9,9,FALSE)","v":-698},null,null,null,null,null,null,null,"INTA +"]
["H",null,null,null,"RUIZ VELASCO","Marcos","Espagne",96,102.5,-151,151,-155,151,170,-175,"-",170,321,353.8517199203406,{"$f":"RANK(S13,S6:S17)","v":9},1,{"$f":"IF(I13=\"\",\"\",IF(A13=\"H\",IF(OR(H13=\"SEN\",H13<94),VLOOKUP(I13,Feuil1!$A$10:$E$28,5),IF(AND(H13>93,H13<97),VLOOKUP(I13,Feuil1!$A$10:$E$28,4),IF(AND(H13>93,H13<96),VLOOKUP(I13,Feuil1!$A$10:$E$28,3),IF(AND(H13>95,H13<2000),VLOOKUP(I13,Feuil1!$A$10:$E$28,3),VLOOKUP(I13,Feuil1!$A$10:$E$28,2))))),IF(OR(H13=\"SEN\",H13<94),VLOOKUP(I13,Feuil1!$F$10:$J$24,5),IF(AND(H13>93,H13<97),VLOOKUP(I13,Feuil1!$F$10:$J$24,4),IF(AND(H13>93,H13<96),VLOOKUP(I13,Feuil1!$F$10:$J$24,4),IF(AND(H13>93,H13<2000),VLOOKUP(I13,Feuil1!$F$10:$J$24,3),VLOOKUP(I13,Feuil1!$F$10:$J$24,2)))))))","v":"J105"},218.5,{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,2,FALSE)","v":146},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,3,FALSE)","v":126},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,4,FALSE)","v":106},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,5,FALSE)","v":81},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,6,FALSE)","v":51},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,7,FALSE)","v":16},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,8,FALSE)","v":1},{"$f":"R13-HLOOKUP(V13,Feuil1!$C$1:$AU$9,9,FALSE)","v":-679},null,null,null,null,null,null,null,"INTA +"]
["H",null,null,null,"MANUSHI","Redon","France",90,97.6,160,165,"-",165,174,"-","-",174,339,380.78194093511848,{"$f":"RANK(S14,S6:S17)","v":5},9,{"$f":"IF(I14=\"\",\"\",IF(A14=\"H\",IF(OR(H14=\"SEN\",H14<94),VLOOKUP(I14,Feuil1!$A$10:$E$28,5),IF(AND(H14>93,H14<97),VLOOKUP(I14,Feuil1!$A$10:$E$28,4),IF(AND(H14>93,H14<96),VLOOKUP(I14,Feuil1!$A$10:$E$28,3),IF(AND(H14>95,H14<2000),VLOOKUP(I14,Feuil1!$A$10:$E$28,3),VLOOKUP(I14,Feuil1!$A$10:$E$28,2))))),IF(OR(H14=\"SEN\",H14<94),VLOOKUP(I14,Feuil1!$F$10:$J$24,5),IF(AND(H14>93,H14<97),VLOOKUP(I14,Feuil1!$F$10:$J$24,4),IF(AND(H14>93,H14<96),VLOOKUP(I14,Feuil1!$F$10:$J$24,4),IF(AND(H14>93,H14<2000),VLOOKUP(I14,Feuil1!$F$10:$J$24,3),VLOOKUP(I14,Feuil1!$F$10:$J$24,2)))))))","v":"S105"},241.4,{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,2,FALSE)","v":144},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,3,FALSE)","v":124},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,4,FALSE)","v":99},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,5,FALSE)","v":69},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,6,FALSE)","v":39},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,7,FALSE)","v":9},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,8,FALSE)","v":-11},{"$f":"R14-HLOOKUP(V14,Feuil1!$C$1:$AU$9,9,FALSE)","v":-26},null,null,null,null,null,null,null,"INTB +"]
["H",null,null,null,"BEJENARIU","Florin","Roumanie",94,79.95,-130,130,135,135,155,-165,165,165,300,370.04443656287714,{"$f":"RANK(S15,S6:S17)","v":7},0,{"$f":"IF(I15=\"\",\"\",IF(A15=\"H\",IF(OR(H15=\"SEN\",H15<94),VLOOKUP(I15,Feuil1!$A$10:$E$28,5),IF(AND(H15>93,H15<97),VLOOKUP(I15,Feuil1!$A$10:$E$28,4),IF(AND(H15>93,H15<96),VLOOKUP(I15,Feuil1!$A$10:$E$28,3),IF(AND(H15>95,H15<2000),VLOOKUP(I15,Feuil1!$A$10:$E$28,3),VLOOKUP(I15,Feuil1!$A$10:$E$28,2))))),IF(OR(H15=\"SEN\",H15<94),VLOOKUP(I15,Feuil1!$F$10:$J$24,5),IF(AND(H15>93,H15<97),VLOOKUP(I15,Feuil1!$F$10:$J$24,4),IF(AND(H15>93,H15<96),VLOOKUP(I15,Feuil1!$F$10:$J$24,4),IF(AND(H15>93,H15<2000),VLOOKUP(I15,Feuil1!$F$10:$J$24,3),VLOOKUP(I15,Feuil1!$F$10:$J$24,2)))))))","v":"J85"},220.05,{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,2,FALSE)","v":145},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,3,FALSE)","v":125},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,4,FALSE)","v":105},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,5,FALSE)","v":80},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,6,FALSE)","v":50},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,7,FALSE)","v":20},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,8,FALSE)","v":0},{"$f":"R15-HLOOKUP(V15,Feuil1!$C$1:$AU$9,9,FALSE)","v":-700},null,null,null,null,null,null,null,"INTA +"]
["H",null,null,null,"MATAM MATAM","David","France",75,94.65,150,155,-160,{"$f":"IF(I16=\"\",\"\",IF(MAXA(J16:L16)<=0,0,MAXA(J16:L16)))","v":155},184,-190,190,190,345,{"$f":"IF(I16=\"\",\"\",IF(A16=\"H\",10^(0.794358141*LOG(I16/174.393)^2)*R16,IF(A16=\"F\",10^(0.89726074*LOG(I16/148.026)^2)*R16,\"\")))","v":392.44154900241637},{"$f":"RANK(S16,S6:S17)","v":4},{"$f":"IF(I16=\"\",\"\",IF(AE16>=0,AE16,IF(AD16>=0,AD16,IF(AC16>=0,AC16,IF(AB16>=0,AB16,IF(AA16>=0,AA16,IF(Z16>=0,Z16,IF(Y16>=0,Y16,X16))))))))","v":15},{"$f":"IF(I16=\"\",\"\",IF(A16=\"H\",IF(OR(H16=\"SEN\",H16<94),VLOOKUP(I16,Feuil1!$A$10:$E$28,5),IF(AND(H16>93,H16<97),VLOOKUP(I16,Feuil1!$A$10:$E$28,4),IF(AND(H16>93,H16<96),VLOOKUP(I16,Feuil1!$A$10:$E$28,3),IF(AND(H16>95,H16<2000),VLOOKUP(I16,Feuil1!$A$10:$E$28,3),VLOOKUP(I16,Feuil1!$A$10:$E$28,2))))),IF(OR(H16=\"SEN\",H16<94),VLOOKUP(I16,Feuil1!$F$10:$J$24,5),IF(AND(H16>93,H16<97),VLOOKUP(I16,Feuil1!$F$10:$J$24,4),IF(AND(H16>93,H16<96),VLOOKUP(I16,Feuil1!$F$10:$J$24,4),IF(AND(H16>93,H16<2000),VLOOKUP(I16,Feuil1!$F$10:$J$24,3),VLOOKUP(I16,Feuil1!$F$10:$J$24,2)))))))","v":"S105"},{"$f":"SUM(R16-I16)","v":250.35},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,2,FALSE)","v":150},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,3,FALSE)","v":130},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,4,FALSE)","v":105},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,5,FALSE)","v":75},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,6,FALSE)","v":45},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,7,FALSE)","v":15},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,8,FALSE)","v":-5},{"$f":"R16-HLOOKUP(V16,Feuil1!$C$1:$AU$9,9,FALSE)","v":-20},null,null,null,null,null,null,null,{"$f":"IF(AE16>=0,$AE$4,IF(AD16>=0,$AD$4,IF(AC16>=0,$AC$4,IF(AB16>=0,$AB$4,IF(AA16>=0,$AA$4,IF(Z16>=0,$Z$4,IF(Y16>=0,$Y$4,IF(X16>=0,$X$4,$AF$4))))))))","v":"INTB +"}]
["H",null,null,null,"COULLET","Anthony","EEAR Monteux",97,135.44999999999999,142,-150,-150,142,"-","-","-",0,0,0,{"$f":"RANK(S17,S6:S17)","v":10},-160,{"$f":"IF(I17=\"\",\"\",IF(A17=\"H\",IF(OR(H17=\"SEN\",H17<94),VLOOKUP(I17,Feuil1!$A$10:$E$28,5),IF(AND(H17>93,H17<97),VLOOKUP(I17,Feuil1!$A$10:$E$28,4),IF(AND(H17>93,H17<96),VLOOKUP(I17,Feuil1!$A$10:$E$28,3),IF(AND(H17>95,H17<2000),VLOOKUP(I17,Feuil1!$A$10:$E$28,3),VLOOKUP(I17,Feuil1!$A$10:$E$28,2))))),IF(OR(H17=\"SEN\",H17<94),VLOOKUP(I17,Feuil1!$F$10:$J$24,5),IF(AND(H17>93,H17<97),VLOOKUP(I17,Feuil1!$F$10:$J$24,4),IF(AND(H17>93,H17<96),VLOOKUP(I17,Feuil1!$F$10:$J$24,4),IF(AND(H17>93,H17<2000),VLOOKUP(I17,Feuil1!$F$10:$J$24,3),VLOOKUP(I17,Feuil1!$F$10:$J$24,2)))))))","v":"C+94"},-135.44999999999999,{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,2,FALSE)","v":-160},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,3,FALSE)","v":-180},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,4,FALSE)","v":-205},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,5,FALSE)","v":-220},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,6,FALSE)","v":-235},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,7,FALSE)","v":-250},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,8,FALSE)","v":-270},{"$f":"R17-HLOOKUP(V17,Feuil1!$C$1:$AU$9,9,FALSE)","v":-1000},null,null,null,null,null,null,null,"NCL"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Secrétaire de Compétition",null,"Arbitre",null,null,null,null,null,null,"Arbitre",null," ",null,null,null,"Arbitre"]
[null,null,null,"Nom :","Daniel MENONI","Nom :","Jean Pierre BRUNET",null," ",null,null,"Nom :","Michel VALENTE ",null,null,null,null,"Nom :","Jean BOUSQUET"]
[null,null,null,"Signature :"," ","Signature :",null,null," ",null,null,"Signature :"," ",null,null,null,null,"Signature :"]
[]
[null,null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J69","J77","J85","J94","J105","J+105",null,"J56","J62","J69","J77","J85","J94","J105","J+105",null,"S56","S62","S69","S77","S85","S94","S105","S+105"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,145,160,170,180,190,null,100,115,130,145,160,170,180,190,null,115,135,150,165,180,190,200,210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,165,180,190,200,210,null,115,135,150,165,180,190,200,210,null,130,150,165,185,200,210,220,230]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165,185,200,210,220,230,null,130,150,165,185,200,210,220,230,null,145,165,180,200,220,230,240,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,200,220,230,240,250,null,145,165,180,200,220,230,240,250,null,175,195,215,235,250,260,275,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,235,250,260,275,280,null,175,195,215,235,250,260,275,280,null,210,230,250,270,290,300,310,325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,270,290,300,310,325,null,210,230,250,270,290,300,310,325,null,230,255,275,300,315,335,345,355]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,295,320,335,355,370,380,null,245,270,295,320,335,355,370,380,null,245,270,295,320,335,355,370,380]

{"sheet":"Feuil1","index":1,"n_rows":28,"n_cols":47,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,"FC44","FC48","FC53","FC58","FC63","FC69","FC+69","FJ48","FJ53","FJ58","FJ63","FJ69","FJ75","FJ+75","FS48","FS53","FS58","FS63","FS69","FS75","FS+75","C50","C56","C62","C69","C77","C85","C94","C+94","J56","J62","J69","J77","J85","J94","J105","J+105","S56","S62","S69","S77","S85","S94","S105","S+105"]
[null,"DEPARTEMENTAL",40,45,50,55,60,65,75,50,55,65,70,75,90,100,60,70,80,85,95,100,110,65,80,100,115,125,135,150,160,95,110,125,140,155,165,175,185,110,130,145,160,175,185,195,205]
[null,"REGIONAL",50,55,65,70,75,80,90,60,65,75,80,85,100,110,70,80,90,95,105,115,125,80,95,115,130,145,155,170,180,110,130,145,160,175,185,195,205,130,150,165,180,195,205,215,225]
[null,"INTERREGIONAL",60,65,75,80,85,95,105,75,80,90,95,100,115,120,85,95,100,110,120,130,140,95,110,130,150,165,180,190,205,130,150,165,185,195,205,215,225,145,170,185,205,220,230,240,250]
[null,"FEDERAL",70,75,85,90,95,105,115,85,95,100,110,120,130,140,95,105,115,125,135,145,155,110,125,145,160,180,195,210,220,145,165,185,205,220,230,240,250,170,195,215,235,250,260,270,280]
[null,"NATIONAL",80,85,95,100,110,120,130,95,105,110,125,135,145,155,110,120,130,140,150,160,170,120,140,160,175,195,215,225,235,170,190,215,235,250,260,270,280,195,220,240,265,280,290,300,310]
[null,"INTERNATIONAL B",90,95,105,115,125,135,145,110,120,130,140,150,160,170,125,140,155,165,175,180,190,135,155,175,190,210,230,240,250,190,215,240,270,280,290,305,315,210,240,260,290,310,320,330,340]
[null,"INTERNATIONAL A",100,105,115,125,135,145,155,125,135,145,155,165,175,185,140,160,175,185,190,195,210,150,175,195,215,235,250,260,270,215,235,260,280,300,310,320,330,225,255,275,310,330,340,350,360]
[null,"OLYMPIQUE",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,10000,155,175,190,200,205,210,225,1000,1000,1000,1000,1000,10000,1000,1000,1000,1000,1000,10000,1000,1000,1000,10000,240,270,290,325,345,355,365,375]
[null,"MINIME","CADET","JUNIOR","SENIOR",null,"MINIME","CADETTE","JUNIOR","SENIOR"]
[20.010000000000002,"NON","C50","J56","S56",20.010000000000002,"NON","FC44","FJ48","FS48"]
[34.01,"NON","C50","J56","S56",30.01,"NON","FC44","FJ48","FS48"]
[38.01,"NON","C50","J56","S56",35.01,"NON","FC44","FJ48","FS48"]
[40.01,"NON","C50","J56","S56",36.01,"NON","FC44","FJ48","FS48"]
[45.01,"NON","C50","J56","S56",40.01,"NON","FC44","FJ48","FS48"]
[50.01,"NON","C56","J56","S56",44.01,"NON","FC48","FJ48","FS48"]
[52.05,"NON","C56","J56","S56",48.01,"NON","FC53","FJ53","FS53"]
[56.01,"NON","C62","J62","S62",53.01,"NON","FC58","FJ58","FS58"]
[62.01,"NON","C69","J69","S69",58.01,"NON","FC63","FJ63","FS63"]
[69.010000000000005,"NON","C77","J77","S77",63.01,"NON","FC69","FJ69","FS69"]
[77.010000000000005,"NON","C85","J85","S85",69.010000000000005,"NON","FC+69","FJ75","FS75"]
[85.01,"NON","C94","J94","S94",75.010000000000005,"NON","FC+69","FJ+75","FS+75"]
[94.01,"NON","C+94","J105","S105",110,"NON","FC+69","FJ+75","FS+75"]
[105.01,"NON","C+94","J+105","S+105",140,"NON","FC+69","FJ+75","FS+75"]
[110,"NON","C+94","J+105","S+105"]
[120,"NON","C+94","J+105","S+105"]
[130,"NON","C+94","J+105","S+105"]
[140,"NON","C+94","J+105","S+105"]