{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","Course","Explications","Droits","Clubs","Brouillon"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":3,"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":"Accueil","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,3,2,5]]}
[]
[]
[null,null,null,"Cyclisme en Flandre"]
[]
[null,null,null,null,"Accueil"]
[]
[null,null,null,"Clubs",null,"Droits"]
[]
[null,null,null,"Course",null,"Explications"]

{"sheet":"Course","index":1,"n_rows":110,"n_cols":15,"rows_kept":110,"cut":false,"hidden":false,"merged":[[5,0,9,0],[0,1,6,2],[8,1,8,9],[0,9,6,10],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4]]}
["Accueil","Course des 24 & 25 avril 2021",null,null,null,{"$f":"Droits!C4","v":"1/2 Pro"},{"$f":"Droits!C5","v":"Amateur"},{"$f":"Droits!C6","v":"Pro"},"Total","Le dossard n'est affecté que lorsque les droits sont payés."]
["Clubs",null,null,"Nb inscrits :",null,{"$f":"COUNTIF(F11:F110,F1)","v":12},{"$f":"COUNTIF(F11:F110,G1)","v":8},{"$f":"COUNTIF(F11:F110,H1)","v":10},{"$f":"SUM(F2:H2)","v":30}]
["Course",null,null,"Attente règlement :",null,{"$f":"COUNTIFS(J11:J110,\"Non\",F11:F110,F1)","v":5},{"$f":"COUNTIFS(J11:J110,\"Non\",F11:F110,G1)","v":3},{"$f":"COUNTIFS(J11:J110,\"Non\",F11:F110,H1)","v":3},{"$f":"SUM(F3:H3)","v":11}]
["Droits",null,null,"Nb réglements :",null,{"$f":"COUNTIFS(J11:J110,\"Oui\",F11:F110,F1)","v":7},{"$f":"COUNTIFS(J11:J110,\"Oui\",F11:F110,G1)","v":5},{"$f":"COUNTIFS(J11:J110,\"Oui\",F11:F110,H1)","v":7},{"$f":"SUM(F4:H4)","v":19}]
["Explications",null,null,"Montant à venir :",null,{"$f":"F3*Droits!D4","v":150},{"$f":"G3*Droits!D5","v":60},{"$f":"H3*Droits!D6","v":105},{"$f":"SUM(F5:H5)","v":315}]
["Le dossard n'est affecté que lorsque les droits sont payés",null,null,"Montant encaissé :",null,{"$f":"F4*Droits!D4","v":210},{"$f":"G4*Droits!D5","v":100},{"$f":"H4*Droits!D6","v":245},{"$f":"SUM(F6:H6)","v":555}]
[null,null,null,"Total recettes :",null,{"$f":"F5+F6","v":360},{"$f":"G5+G6","v":160},350,870]
[]
[null,"Cycliste"]
[null,"Inscrits","Dossard","Nom et prénom","Age","Catégorie","Club","Inscription","Droits","Payé",null,"Club","Inscrits","Rang","Top club"]
[null,1,{"$f":"IF(AND(D11<>\"\",J11=\"Oui\"),B11,\"\")","v":""},"Gaby Cahun",39,"1/2 pro","LOOS EN GOHELLE ","2021-04-02",{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,Droits!$C$4:$D$6,2))","v":30},"Non",null,{"$f":"Clubs!C3","v":"A.S.B BILLY MONTIGNY"},{"$f":"COUNTIF($G$11:$G$110,L11)","v":1},{"$f":"RANK(M11,$M$11:$M$73)","v":6},{"$f":"IF(OR(N11=1,N11=2,N11=3),\"Top\",\"\")","v":""}]
[null,2,{"$f":"IF(AND(D12<>\"\",J12=\"Oui\"),B12,\"\")","v":""},"Natacha Bousquet",33,"Amateur","AGNEZ LES DUISANS ","2021-04-22",{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,Droits!$C$4:$D$6,2))","v":20},"Non",null,{"$f":"Clubs!C4","v":"AC BOURTHES"},{"$f":"COUNTIF($G$11:$G$110,L12)","v":0},{"$f":"RANK(M12,$M$11:$M$73)","v":22},{"$f":"IF(OR(N12=1,N12=2,N12=3),\"Top\",\"\")","v":""}]
[null,3,3,"Phil Ballouhey",29,"Pro","SC BOULOGNE/MER ","2021-04-16",{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C5","v":"AC OPALE SUD BERCK/MER "},1,6,""]
[null,4,4,"Agathe Chaucer",26,"1/2 pro","CC ISBERGUES MOLINGHEIM ","2021-04-04",{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C6","v":"AGNEZ LES DUISANS "},1,6,""]
[null,5,"","Amanda Micheaux",41,"Pro","CC ISBERGUES MOLINGHEIM ","2021-04-02",{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,Droits!$C$4:$D$6,2))","v":35},"Non",null,{"$f":"Clubs!C7","v":"AGNY VTT "},0,22,""]
[null,6,6,"Godeleine Delacroix",25,"Amateur","SC ARTOIS BEAURAINS ","2021-04-14",{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,Droits!$C$4:$D$6,2))","v":20},"Oui",null,{"$f":"Clubs!C8","v":"AIRE SUR LA LYS VC "},1,6,""]
[null,7,"","Margaux Courbet",37,"1/2 pro","EV GUINES ","2021-04-23",{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,Droits!$C$4:$D$6,2))","v":30},"Non",null,{"$f":"Clubs!C9","v":"AIRE SUR LA LYS VC "},1,6,""]
[null,8,8,"Patrick Fournier",18,"1/2 pro","CCBL LES D'JAKASS","2021-04-25",{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C10","v":"ANNEQUIN CYCLING TEAM"},0,22,""]
[null,9,"","Marc Naudé",39,"1/2 pro","SC BOULOGNE/MER ","2021-04-19",{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,Droits!$C$4:$D$6,2))","v":30},"Non",null,{"$f":"Clubs!C11","v":"ARRAS CYCLOTOURISME"},0,22,""]
[null,10,10,"Maxence Breguet",42,"Pro","HARNES ","2021-04-21",{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C12","v":"ARRAS VC "},0,22,""]
[null,11,"","Constantin Darche",31,"Amateur","OLYMPIQUE HESDIN MARCONNE","2021-04-01",{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,Droits!$C$4:$D$6,2))","v":20},"Non",null,{"$f":"Clubs!C13","v":"ASE ETAPLES SUR MER "},0,22,""]
[null,12,12,"Marcel Jacquemoud",32,"Pro","SC ARTOIS BEAURAINS ","2021-04-11",{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C14","v":"AUCHEL NATURE "},0,22,""]
[null,13,13,"William Bazalgette",40,"Amateur","CC ISBERGUES MOLINGHEIM ","2021-04-16",{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Droits!$C$4:$D$6,2))","v":20},"Oui",null,{"$f":"Clubs!C15","v":"BIACHE ST VAAST "},0,22,""]
[null,14,14,"Josselin Chappelle",20,"Pro","USO BRUAY-LA-BUISSIERE ","2021-04-18",{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C16","v":"BMX LAMBRES "},1,6,""]
[null,15,15,"Richard Bourdon",34,"1/2 pro","CC ISBERGUES MOLINGHEIM ","2021-04-08",{"$f":"IF(F25=\"\",\"\",VLOOKUP(F25,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C17","v":"C.C. BAPAUME "},0,22,""]
[null,16,16,"Jonathan Thibodeaux",19,"Amateur","AIRE SUR LA LYS VC ","2021-04-02",{"$f":"IF(F26=\"\",\"\",VLOOKUP(F26,Droits!$C$4:$D$6,2))","v":20},"Oui",null,{"$f":"Clubs!C18","v":"CC BILLY BERCLAU"},0,22,""]
[null,17,"","Marine Sardou",26,"1/2 pro","LOOS EN GOHELLE ","2021-04-25",{"$f":"IF(F27=\"\",\"\",VLOOKUP(F27,Droits!$C$4:$D$6,2))","v":30},"Non",null,{"$f":"Clubs!C19","v":"CC BRIMEUX "},0,22,""]
[null,18,"","Bruno Vernier",41,"Pro","CC MANQUEVILLE LILLERS ","2021-04-07",{"$f":"IF(F28=\"\",\"\",VLOOKUP(F28,Droits!$C$4:$D$6,2))","v":35},"Non",null,{"$f":"Clubs!C20","v":"CC CAUCHY A LA TOUR "},1,6,""]
[null,19,19,"Luc Fournier",31,"Pro","RLC PUNE LAPUGNOY ","2021-04-10",{"$f":"IF(F29=\"\",\"\",VLOOKUP(F29,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C21","v":"CC GRENAY "},0,22,""]
[null,20,20,"Rebecca Caillat",31,"Pro","BMX LAMBRES ","2021-04-08",{"$f":"IF(F30=\"\",\"\",VLOOKUP(F30,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C22","v":"CC ISBERGUES MOLINGHEIM "},5,1,"Top"]
[null,21,"","Vincent Gainsbourg",20,"Pro","ESC BULLY","2021-04-14",{"$f":"IF(F31=\"\",\"\",VLOOKUP(F31,Droits!$C$4:$D$6,2))","v":35},"Non",null,{"$f":"Clubs!C23","v":"CC LAVENTIE "},0,22,""]
[null,22,"","Alberte Bouchard",35,"1/2 pro","TERNOIS VELO VERT","2021-04-10",{"$f":"IF(F32=\"\",\"\",VLOOKUP(F32,Droits!$C$4:$D$6,2))","v":30},"Non",null,{"$f":"Clubs!C24","v":"CC LEFOREST"},0,22,""]
[null,23,23,"Émilien Boissonade",33,"1/2 pro","SC BOULOGNE/MER ","2021-04-04",{"$f":"IF(F33=\"\",\"\",VLOOKUP(F33,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C25","v":"CC MANQUEVILLE LILLERS "},2,4,""]
[null,24,24,"Simon Brochard",32,"Amateur","CC MANQUEVILLE LILLERS ","2021-04-16",{"$f":"IF(F34=\"\",\"\",VLOOKUP(F34,Droits!$C$4:$D$6,2))","v":20},"Oui",null,{"$f":"Clubs!C26","v":"CC VITRY EN ARTOIS"},0,22,""]
[null,25,25,"Clothilde Chopin",31,"Amateur","CC ISBERGUES MOLINGHEIM ","2021-04-12",{"$f":"IF(F35=\"\",\"\",VLOOKUP(F35,Droits!$C$4:$D$6,2))","v":20},"Oui",null,{"$f":"Clubs!C27","v":"CCBL LES D'JAKASS"},1,6,""]
[null,26,26,"Marc-Antoine Gouin",31,"1/2 pro","AC OPALE SUD BERCK/MER ","2021-04-14",{"$f":"IF(F36=\"\",\"\",VLOOKUP(F36,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C28","v":"CC-VTT DE FLEURBAIX "},0,22,""]
[null,27,"","Bertrand Carbonneau",25,"Amateur","SC ARTOIS BEAURAINS ","2021-04-10",{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,Droits!$C$4:$D$6,2))","v":20},"Non",null,{"$f":"Clubs!C29","v":"CL BARLIN "},0,22,""]
[null,28,28,"Auguste Bescond",31,"1/2 pro","A.S.B BILLY MONTIGNY","2021-04-04",{"$f":"IF(F38=\"\",\"\",VLOOKUP(F38,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C30","v":"CLUB SPORTIF OUTRELOIS "},0,22,""]
[null,29,29,"Lorraine Bonnet",26,"1/2 pro","CC CAUCHY A LA TOUR ","2021-04-16",{"$f":"IF(F39=\"\",\"\",VLOOKUP(F39,Droits!$C$4:$D$6,2))","v":30},"Oui",null,{"$f":"Clubs!C31","v":"CV BETHUNES "},0,22,""]
[null,30,30,"Matthieu Bossuet",29,"Pro","VC BARLIN","2021-04-12",{"$f":"IF(F40=\"\",\"\",VLOOKUP(F40,Droits!$C$4:$D$6,2))","v":35},"Oui",null,{"$f":"Clubs!C32","v":"CV LIEVIN "},0,22,""]
[null,31,"",null,null,null,null,null,{"$f":"IF(F41=\"\",\"\",VLOOKUP(F41,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C33","v":"CYCLO-CLUB NOYELLES-SOUS-LENS "},0,22,""]
[null,32,"",null,null,null,null,null,{"$f":"IF(F42=\"\",\"\",VLOOKUP(F42,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C34","v":"E.C.H HENIN-BEAUMONT "},0,22,""]
[null,33,"",null,null,null,null,null,{"$f":"IF(F43=\"\",\"\",VLOOKUP(F43,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C35","v":"ELEU LES GALOCHES VTT "},0,22,""]
[null,34,"",null,null,null,null,null,{"$f":"IF(F44=\"\",\"\",VLOOKUP(F44,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C36","v":"ES ARQUES "},0,22,""]
[null,35,"",null,null,null,null,null,{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C37","v":"ES CAMBLIGNEUL "},0,22,""]
[null,36,"",null,null,null,null,null,{"$f":"IF(F46=\"\",\"\",VLOOKUP(F46,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C38","v":"ESC BULLY"},1,6,""]
[null,37,"",null,null,null,null,null,{"$f":"IF(F47=\"\",\"\",VLOOKUP(F47,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C39","v":"ESC MERICOURT "},0,22,""]
[null,38,"",null,null,null,null,null,{"$f":"IF(F48=\"\",\"\",VLOOKUP(F48,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C40","v":"EV GUINES "},1,6,""]
[null,39,"",null,null,null,null,null,{"$f":"IF(F49=\"\",\"\",VLOOKUP(F49,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C41","v":"HARNES "},1,6,""]
[null,40,"",null,null,null,null,null,{"$f":"IF(F50=\"\",\"\",VLOOKUP(F50,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C42","v":"HERMELINGHEN "},0,22,""]
[null,41,"",null,null,null,null,null,{"$f":"IF(F51=\"\",\"\",VLOOKUP(F51,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C43","v":"LEO LAGRANGE ST MARTIN"},0,22,""]
[null,42,"",null,null,null,null,null,{"$f":"IF(F52=\"\",\"\",VLOOKUP(F52,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C44","v":"LES CYCLOS DE DROCOURT"},0,22,""]
[null,43,"",null,null,null,null,null,{"$f":"IF(F53=\"\",\"\",VLOOKUP(F53,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C45","v":"LOOS EN GOHELLE "},2,4,""]
[null,44,"",null,null,null,null,null,{"$f":"IF(F54=\"\",\"\",VLOOKUP(F54,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C46","v":"MARCK EN CALAISIES BMX "},0,22,""]
[null,45,"",null,null,null,null,null,{"$f":"IF(F55=\"\",\"\",VLOOKUP(F55,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C47","v":"OLYMPIQUE HESDIN MARCONNE"},1,6,""]
[null,46,"",null,null,null,null,null,{"$f":"IF(F56=\"\",\"\",VLOOKUP(F56,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C48","v":"RLC PUNE LAPUGNOY "},1,6,""]
[null,47,"",null,null,null,null,null,{"$f":"IF(F57=\"\",\"\",VLOOKUP(F57,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C49","v":"SC ARTOIS BEAURAINS "},3,2,"Top"]
[null,48,"",null,null,null,null,null,{"$f":"IF(F58=\"\",\"\",VLOOKUP(F58,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C50","v":"SC BOULOGNE/MER "},3,2,"Top"]
[null,49,"",null,null,null,null,null,{"$f":"IF(F59=\"\",\"\",VLOOKUP(F59,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C51","v":"TERNOIS VELO VERT"},1,6,""]
[null,50,"",null,null,null,null,null,{"$f":"IF(F60=\"\",\"\",VLOOKUP(F60,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C52","v":"TOUQUET ACC"},0,22,""]
[null,51,"",null,null,null,null,null,{"$f":"IF(F61=\"\",\"\",VLOOKUP(F61,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C53","v":"U.V.C.CALAIS "},0,22,""]
[null,52,"",null,null,null,null,null,{"$f":"IF(F62=\"\",\"\",VLOOKUP(F62,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C54","v":"UC ARDRES EN ARTOIS "},0,22,""]
[null,53,"",null,null,null,null,null,{"$f":"IF(F63=\"\",\"\",VLOOKUP(F63,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C55","v":"ULTRA VTT MERICOURT "},0,22,""]
[null,54,"",null,null,null,null,null,{"$f":"IF(F64=\"\",\"\",VLOOKUP(F64,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C56","v":"UNION SPORTIVE ARRAS OUEST"},0,22,""]
[null,55,"",null,null,null,null,null,{"$f":"IF(F65=\"\",\"\",VLOOKUP(F65,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C57","v":"USO BRUAY-LA-BUISSIERE "},1,6,""]
[null,56,"",null,null,null,null,null,{"$f":"IF(F66=\"\",\"\",VLOOKUP(F66,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C58","v":"VC AUBIGNY "},0,22,""]
[null,57,"",null,null,null,null,null,{"$f":"IF(F67=\"\",\"\",VLOOKUP(F67,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C59","v":"VC AUXI LE CHATEAU "},0,22,""]
[null,58,"",null,null,null,null,null,{"$f":"IF(F68=\"\",\"\",VLOOKUP(F68,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C60","v":"VC BARLIN"},1,6,""]
[null,59,"",null,null,null,null,null,{"$f":"IF(F69=\"\",\"\",VLOOKUP(F69,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C61","v":"VC BETHUNE "},0,22,""]
[null,60,"",null,null,null,null,null,{"$f":"IF(F70=\"\",\"\",VLOOKUP(F70,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C62","v":"VC NOEUX LES MINES "},0,22,""]
[null,61,"",null,null,null,null,null,{"$f":"IF(F71=\"\",\"\",VLOOKUP(F71,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C63","v":"VC PROVIN "},0,22,""]
[null,62,"",null,null,null,null,null,{"$f":"IF(F72=\"\",\"\",VLOOKUP(F72,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C64","v":"VC SAINT OMER "},0,22,""]
[null,63,"",null,null,null,null,null,{"$f":"IF(F73=\"\",\"\",VLOOKUP(F73,Droits!$C$4:$D$6,2))","v":""},null,null,{"$f":"Clubs!C65","v":"VTT 2 CAPS WIERRE EFFROY "},0,22,""]
[null,64,"",null,null,null,null,null,{"$f":"IF(F74=\"\",\"\",VLOOKUP(F74,Droits!$C$4:$D$6,2))","v":""}]
[null,65,"",null,null,null,null,null,{"$f":"IF(F75=\"\",\"\",VLOOKUP(F75,Droits!$C$4:$D$6,2))","v":""}]
[null,66,{"$f":"IF(AND(D76<>\"\",J76=\"Oui\"),B76,\"\")","v":""},null,null,null,null,null,{"$f":"IF(F76=\"\",\"\",VLOOKUP(F76,Droits!$C$4:$D$6,2))","v":""}]
[null,67,"",null,null,null,null,null,{"$f":"IF(F77=\"\",\"\",VLOOKUP(F77,Droits!$C$4:$D$6,2))","v":""}]
[null,68,"",null,null,null,null,null,{"$f":"IF(F78=\"\",\"\",VLOOKUP(F78,Droits!$C$4:$D$6,2))","v":""}]
[null,69,"",null,null,null,null,null,{"$f":"IF(F79=\"\",\"\",VLOOKUP(F79,Droits!$C$4:$D$6,2))","v":""}]
[null,70,"",null,null,null,null,null,{"$f":"IF(F80=\"\",\"\",VLOOKUP(F80,Droits!$C$4:$D$6,2))","v":""}]
[null,71,"",null,null,null,null,null,{"$f":"IF(F81=\"\",\"\",VLOOKUP(F81,Droits!$C$4:$D$6,2))","v":""}]
[null,72,"",null,null,null,null,null,{"$f":"IF(F82=\"\",\"\",VLOOKUP(F82,Droits!$C$4:$D$6,2))","v":""}]
[null,73,"",null,null,null,null,null,{"$f":"IF(F83=\"\",\"\",VLOOKUP(F83,Droits!$C$4:$D$6,2))","v":""}]
[null,74,"",null,null,null,null,null,{"$f":"IF(F84=\"\",\"\",VLOOKUP(F84,Droits!$C$4:$D$6,2))","v":""}]
[null,75,"",null,null,null,null,null,{"$f":"IF(F85=\"\",\"\",VLOOKUP(F85,Droits!$C$4:$D$6,2))","v":""}]
[null,76,"",null,null,null,null,null,{"$f":"IF(F86=\"\",\"\",VLOOKUP(F86,Droits!$C$4:$D$6,2))","v":""}]
[null,77,"",null,null,null,null,null,{"$f":"IF(F87=\"\",\"\",VLOOKUP(F87,Droits!$C$4:$D$6,2))","v":""}]
[null,78,"",null,null,null,null,null,{"$f":"IF(F88=\"\",\"\",VLOOKUP(F88,Droits!$C$4:$D$6,2))","v":""}]
[null,79,"",null,null,null,null,null,{"$f":"IF(F89=\"\",\"\",VLOOKUP(F89,Droits!$C$4:$D$6,2))","v":""}]
[null,80,"",null,null,null,null,null,{"$f":"IF(F90=\"\",\"\",VLOOKUP(F90,Droits!$C$4:$D$6,2))","v":""}]
[null,81,"",null,null,null,null,null,{"$f":"IF(F91=\"\",\"\",VLOOKUP(F91,Droits!$C$4:$D$6,2))","v":""}]
[null,82,"",null,null,null,null,null,{"$f":"IF(F92=\"\",\"\",VLOOKUP(F92,Droits!$C$4:$D$6,2))","v":""}]
[null,83,"",null,null,null,null,null,{"$f":"IF(F93=\"\",\"\",VLOOKUP(F93,Droits!$C$4:$D$6,2))","v":""}]
[null,84,"",null,null,null,null,null,{"$f":"IF(F94=\"\",\"\",VLOOKUP(F94,Droits!$C$4:$D$6,2))","v":""}]
[null,85,"",null,null,null,null,null,{"$f":"IF(F95=\"\",\"\",VLOOKUP(F95,Droits!$C$4:$D$6,2))","v":""}]
[null,86,"",null,null,null,null,null,{"$f":"IF(F96=\"\",\"\",VLOOKUP(F96,Droits!$C$4:$D$6,2))","v":""}]
[null,87,"",null,null,null,null,null,{"$f":"IF(F97=\"\",\"\",VLOOKUP(F97,Droits!$C$4:$D$6,2))","v":""}]
[null,88,"",null,null,null,null,null,{"$f":"IF(F98=\"\",\"\",VLOOKUP(F98,Droits!$C$4:$D$6,2))","v":""}]
[null,89,"",null,null,null,null,null,{"$f":"IF(F99=\"\",\"\",VLOOKUP(F99,Droits!$C$4:$D$6,2))","v":""}]
[null,90,"",null,null,null,null,null,{"$f":"IF(F100=\"\",\"\",VLOOKUP(F100,Droits!$C$4:$D$6,2))","v":""}]
[null,91,"",null,null,null,null,null,{"$f":"IF(F101=\"\",\"\",VLOOKUP(F101,Droits!$C$4:$D$6,2))","v":""}]
[null,92,"",null,null,null,null,null,{"$f":"IF(F102=\"\",\"\",VLOOKUP(F102,Droits!$C$4:$D$6,2))","v":""}]
[null,93,"",null,null,null,null,null,{"$f":"IF(F103=\"\",\"\",VLOOKUP(F103,Droits!$C$4:$D$6,2))","v":""}]
[null,94,"",null,null,null,null,null,{"$f":"IF(F104=\"\",\"\",VLOOKUP(F104,Droits!$C$4:$D$6,2))","v":""}]
[null,95,"",null,null,null,null,null,{"$f":"IF(F105=\"\",\"\",VLOOKUP(F105,Droits!$C$4:$D$6,2))","v":""}]
[null,96,"",null,null,null,null,null,{"$f":"IF(F106=\"\",\"\",VLOOKUP(F106,Droits!$C$4:$D$6,2))","v":""}]
[null,97,"",null,null,null,null,null,{"$f":"IF(F107=\"\",\"\",VLOOKUP(F107,Droits!$C$4:$D$6,2))","v":""}]
[null,98,"",null,null,null,null,null,{"$f":"IF(F108=\"\",\"\",VLOOKUP(F108,Droits!$C$4:$D$6,2))","v":""}]
[null,99,"",null,null,null,null,null,{"$f":"IF(F109=\"\",\"\",VLOOKUP(F109,Droits!$C$4:$D$6,2))","v":""}]
[null,100,"",null,null,null,null,null,{"$f":"IF(F110=\"\",\"\",VLOOKUP(F110,Droits!$C$4:$D$6,2))","v":""}]

{"sheet":"Explications","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,3,10,9]]}
["Accueil"]
["Clubs"]
["Course",null,null,"La Flandre française est la partie de l'ancien comté de Flandre qui fait aujourd'hui partie de la France, et qui consiste traditionnellement en la moitié nord du département du Nord, auquel s'ajoutent quatre communes du Pas-de-Calais"]
["Droits"]
["Explications"]

{"sheet":"Droits","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,1,3]]}
["Accueil",null,"Droits d'inscription"]
["Clubs"]
["Course",null,"Catégorie","Droit"]
["Droits",null,"1/2 Pro",30]
["Explications",null,"Amateur",20]
[null,null,"Pro",35]

{"sheet":"Clubs","index":4,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,1,2],[0,3,1,3],[2,4,2,9]]}
["Accueil","Clubs cyclistes"]
["Clubs",null,null,null,{"$f":"\"Soit : \"&COUNTA(C:C)&\" clubs.\"","v":"Soit : 63 clubs."}]
["Course",1,"A.S.B BILLY MONTIGNY",null,"Source : http://www.cyclisme-amateur.com/annuaire-clubs-pas-de-calais.html"]
["Droits",2,"AC BOURTHES"]
["Explications",3,"AC OPALE SUD BERCK/MER "]
[null,4,"AGNEZ LES DUISANS "]
[null,5,"AGNY VTT "]
[null,6,"AIRE SUR LA LYS VC "]
[null,7,"AIRE SUR LA LYS VC "]
[null,8,"ANNEQUIN CYCLING TEAM"]
[null,9,"ARRAS CYCLOTOURISME"]
[null,10,"ARRAS VC "]
[null,11,"ASE ETAPLES SUR MER "]
[null,12,"AUCHEL NATURE "]
[null,13,"BIACHE ST VAAST "]
[null,14,"BMX LAMBRES "]
[null,15,"C.C. BAPAUME "]
[null,16,"CC BILLY BERCLAU"]
[null,17,"CC BRIMEUX "]
[null,18,"CC CAUCHY A LA TOUR "]
[null,19,"CC GRENAY "]
[null,20,"CC ISBERGUES MOLINGHEIM "]
[null,21,"CC LAVENTIE "]
[null,22,"CC LEFOREST"]
[null,23,"CC MANQUEVILLE LILLERS "]
[null,24,"CC VITRY EN ARTOIS"]
[null,25,"CCBL LES D'JAKASS"]
[null,26,"CC-VTT DE FLEURBAIX "]
[null,27,"CL BARLIN "]
[null,28,"CLUB SPORTIF OUTRELOIS "]
[null,29,"CV BETHUNES "]
[null,30,"CV LIEVIN "]
[null,31,"CYCLO-CLUB NOYELLES-SOUS-LENS "]
[null,32,"E.C.H HENIN-BEAUMONT "]
[null,33,"ELEU LES GALOCHES VTT "]
[null,34,"ES ARQUES "]
[null,35,"ES CAMBLIGNEUL "]
[null,36,"ESC BULLY"]
[null,37,"ESC MERICOURT "]
[null,38,"EV GUINES "]
[null,39,"HARNES "]
[null,40,"HERMELINGHEN "]
[null,41,"LEO LAGRANGE ST MARTIN"]
[null,42,"LES CYCLOS DE DROCOURT"]
[null,43,"LOOS EN GOHELLE "]
[null,44,"MARCK EN CALAISIES BMX "]
[null,45,"OLYMPIQUE HESDIN MARCONNE"]
[null,46,"RLC PUNE LAPUGNOY "]
[null,47,"SC ARTOIS BEAURAINS "]
[null,48,"SC BOULOGNE/MER "]
[null,49,"TERNOIS VELO VERT"]
[null,50,"TOUQUET ACC"]
[null,51,"U.V.C.CALAIS "]
[null,52,"UC ARDRES EN ARTOIS "]
[null,53,"ULTRA VTT MERICOURT "]
[null,54,"UNION SPORTIVE ARRAS OUEST"]
[null,55,"USO BRUAY-LA-BUISSIERE "]
[null,56,"VC AUBIGNY "]
[null,57,"VC AUXI LE CHATEAU "]
[null,58,"VC BARLIN"]
[null,59,"VC BETHUNE "]
[null,60,"VC NOEUX LES MINES "]
[null,61,"VC PROVIN "]
[null,62,"VC SAINT OMER "]
[null,63,"VTT 2 CAPS WIERRE EFFROY "]

{"sheet":"Brouillon","index":5,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COUNTA(B:B)","v":30}]
[]
[{"$f":"RANDBETWEEN(0,29)","v":25},"Gaby Cahun",{"$f":"RANDBETWEEN(0,2)","v":1},{"$f":"IF(C3=0,\"Amateur\",IF(C3=1,\"1/2 pro\",\"Pro\"))","v":"1/2 pro"},{"$f":"RANDBETWEEN(18,42)","v":40},1,"A.S.B BILLY MONTIGNY",{"$f":"RANDBETWEEN(1,63)","v":6},{"$f":"VLOOKUP(H3,$F$3:$G$65,2)","v":"AIRE SUR LA LYS VC "},1,"2021-04-01",{"$f":"RANDBETWEEN(1,25)","v":3},{"$f":"VLOOKUP(L3,$J$3:$K$27,2)","v":"2021-04-03"},{"$f":"RANDBETWEEN(0,1)","v":1},{"$f":"IF(N3=0,\"Oui\",\"Non\")","v":"Non"}]
[12,"Natacha Bousquet",{"$f":"RANDBETWEEN(0,2)","v":2},{"$f":"IF(C4=0,\"Amateur\",IF(C4=1,\"1/2 pro\",\"Pro\"))","v":"Pro"},{"$f":"RANDBETWEEN(18,42)","v":38},2,"AC BOURTHES",{"$f":"RANDBETWEEN(1,63)","v":43},{"$f":"VLOOKUP(H4,$F$3:$G$65,2)","v":"LOOS EN GOHELLE "},2,"2021-04-02",{"$f":"RANDBETWEEN(1,25)","v":12},{"$f":"VLOOKUP(L4,$J$3:$K$27,2)","v":"2021-04-12"},{"$f":"RANDBETWEEN(0,1)","v":0},{"$f":"IF(N4=0,\"Oui\",\"Non\")","v":"Oui"}]
[18,"Phil Ballouhey",1,"1/2 pro",35,3,"AC OPALE SUD BERCK/MER ",9,"ARRAS CYCLOTOURISME",3,"2021-04-03",17,"2021-04-17",0,"Oui"]
[2,"Agathe Chaucer",1,"1/2 pro",35,4,"AGNEZ LES DUISANS ",42,"LES CYCLOS DE DROCOURT",4,"2021-04-04",20,"2021-04-20",1,"Non"]
[21,"Amanda Micheaux",0,"Amateur",29,5,"AGNY VTT ",58,"VC BARLIN",5,"2021-04-05",1,"2021-04-01",1,"Non"]
[6,"Godeleine Delacroix",1,"1/2 pro",22,6,"AIRE SUR LA LYS VC ",35,"ES CAMBLIGNEUL ",6,"2021-04-06",14,"2021-04-14",1,"Non"]
[5,"Margaux Courbet",1,"1/2 pro",42,7,"AIRE SUR LA LYS VC ",29,"CV BETHUNES ",7,"2021-04-07",20,"2021-04-20",1,"Non"]
[28,"Patrick Fournier",1,"1/2 pro",33,8,"ANNEQUIN CYCLING TEAM",58,"VC BARLIN",8,"2021-04-08",21,"2021-04-21",0,"Oui"]
[18,"Marc Naudé",1,"1/2 pro",34,9,"ARRAS CYCLOTOURISME",21,"CC LAVENTIE ",9,"2021-04-09",10,"2021-04-10",1,"Non"]
[29,"Maxence Breguet",0,"Amateur",40,10,"ARRAS VC ",18,"CC CAUCHY A LA TOUR ",10,"2021-04-10",5,"2021-04-05",1,"Non"]
[10,"Constantin Darche",0,"Amateur",31,11,"ASE ETAPLES SUR MER ",59,"VC BETHUNE ",11,"2021-04-11",10,"2021-04-10",0,"Oui"]
[22,"Marcel Jacquemoud",0,"Amateur",36,12,"AUCHEL NATURE ",34,"ES ARQUES ",12,"2021-04-12",2,"2021-04-02",1,"Non"]
[9,"William Bazalgette",0,"Amateur",33,13,"BIACHE ST VAAST ",12,"AUCHEL NATURE ",13,"2021-04-13",1,"2021-04-01",0,"Oui"]
[27,"Josselin Chappelle",2,"Pro",39,14,"BMX LAMBRES ",51,"U.V.C.CALAIS ",14,"2021-04-14",17,"2021-04-17",1,"Non"]
[29,"Richard Bourdon",0,"Amateur",32,15,"C.C. BAPAUME ",14,"BMX LAMBRES ",15,"2021-04-15",9,"2021-04-09",0,"Oui"]
[17,"Jonathan Thibodeaux",0,"Amateur",28,16,"CC BILLY BERCLAU",23,"CC MANQUEVILLE LILLERS ",16,"2021-04-16",9,"2021-04-09",0,"Oui"]
[5,"Marine Sardou",0,"Amateur",34,17,"CC BRIMEUX ",50,"TOUQUET ACC",17,"2021-04-17",18,"2021-04-18",1,"Non"]
[11,"Bruno Vernier",1,"1/2 pro",28,18,"CC CAUCHY A LA TOUR ",4,"AGNEZ LES DUISANS ",18,"2021-04-18",10,"2021-04-10",1,"Non"]
[19,"Luc Fournier",2,"Pro",22,19,"CC GRENAY ",13,"BIACHE ST VAAST ",19,"2021-04-19",18,"2021-04-18",1,"Non"]
[22,"Rebecca Caillat",2,"Pro",38,20,"CC ISBERGUES MOLINGHEIM ",10,"ARRAS VC ",20,"2021-04-20",23,"2021-04-23",1,"Non"]
[21,"Vincent Gainsbourg",1,"1/2 pro",21,21,"CC LAVENTIE ",50,"TOUQUET ACC",21,"2021-04-21",11,"2021-04-11",1,"Non"]
[18,"Alberte Bouchard",0,"Amateur",21,22,"CC LEFOREST",51,"U.V.C.CALAIS ",22,"2021-04-22",16,"2021-04-16",0,"Oui"]
[23,"Émilien Boissonade",1,"1/2 pro",18,23,"CC MANQUEVILLE LILLERS ",41,"LEO LAGRANGE ST MARTIN",23,"2021-04-23",13,"2021-04-13",1,"Non"]
[20,"Simon Brochard",1,"1/2 pro",21,24,"CC VITRY EN ARTOIS",3,"AC OPALE SUD BERCK/MER ",24,"2021-04-24",10,"2021-04-10",1,"Non"]
[14,"Clothilde Chopin",2,"Pro",20,25,"CCBL LES D'JAKASS",13,"BIACHE ST VAAST ",25,"2021-04-25",15,"2021-04-15",1,"Non"]
[11,"Marc-Antoine Gouin",2,"Pro",23,26,"CC-VTT DE FLEURBAIX ",16,"CC BILLY BERCLAU",null,null,null,null,0,"Oui"]
[25,"Bertrand Carbonneau",2,"Pro",26,27,"CL BARLIN ",40,"HERMELINGHEN ",null,null,null,null,1,"Non"]
[3,"Auguste Bescond",1,"1/2 pro",22,28,"CLUB SPORTIF OUTRELOIS ",59,"VC BETHUNE ",null,null,null,null,1,"Non"]
[19,"Lorraine Bonnet",2,"Pro",29,29,"CV BETHUNES ",20,"CC ISBERGUES MOLINGHEIM ",null,null,null,null,0,"Oui"]
[3,"Matthieu Bossuet",0,"Amateur",24,30,"CV LIEVIN ",35,"ES CAMBLIGNEUL ",null,null,null,null,0,"Oui"]
[null,null,null,null,null,31,"CYCLO-CLUB NOYELLES-SOUS-LENS ",41,"LEO LAGRANGE ST MARTIN"]
[null,null,null,null,null,32,"E.C.H HENIN-BEAUMONT ",23,"CC MANQUEVILLE LILLERS "]
[null,null,null,null,null,33,"ELEU LES GALOCHES VTT ",24,"CC VITRY EN ARTOIS"]
[null,null,null,null,null,34,"ES ARQUES ",56,"VC AUBIGNY "]
[null,null,null,null,null,35,"ES CAMBLIGNEUL ",47,"SC ARTOIS BEAURAINS "]
[null,null,null,null,null,36,"ESC BULLY",36,"ESC BULLY"]
[null,null,null,null,null,37,"ESC MERICOURT ",13,"BIACHE ST VAAST "]
[null,null,null,null,null,38,"EV GUINES ",23,"CC MANQUEVILLE LILLERS "]
[null,null,null,null,null,39,"HARNES ",58,"VC BARLIN"]
[null,null,null,null,null,40,"HERMELINGHEN ",53,"ULTRA VTT MERICOURT "]
[null,null,null,null,null,41,"LEO LAGRANGE ST MARTIN",48,"SC BOULOGNE/MER "]
[null,null,null,null,null,42,"LES CYCLOS DE DROCOURT",42,"LES CYCLOS DE DROCOURT"]
[null,null,null,null,null,43,"LOOS EN GOHELLE ",40,"HERMELINGHEN "]
[null,null,null,null,null,44,"MARCK EN CALAISIES BMX ",58,"VC BARLIN"]
[null,null,null,null,null,45,"OLYMPIQUE HESDIN MARCONNE",9,"ARRAS CYCLOTOURISME"]
[null,null,null,null,null,46,"RLC PUNE LAPUGNOY ",43,"LOOS EN GOHELLE "]
[null,null,null,null,null,47,"SC ARTOIS BEAURAINS ",27,"CL BARLIN "]
[null,null,null,null,null,48,"SC BOULOGNE/MER ",16,"CC BILLY BERCLAU"]
[null,null,null,null,null,49,"TERNOIS VELO VERT",4,"AGNEZ LES DUISANS "]
[null,null,null,null,null,50,"TOUQUET ACC",8,"ANNEQUIN CYCLING TEAM"]
[null,null,null,null,null,51,"U.V.C.CALAIS ",49,"TERNOIS VELO VERT"]
[null,null,null,null,null,52,"UC ARDRES EN ARTOIS ",47,"SC ARTOIS BEAURAINS "]
[null,null,null,null,null,53,"ULTRA VTT MERICOURT ",24,"CC VITRY EN ARTOIS"]
[null,null,null,null,null,54,"UNION SPORTIVE ARRAS OUEST",15,"C.C. BAPAUME "]
[null,null,null,null,null,55,"USO BRUAY-LA-BUISSIERE ",5,"AGNY VTT "]
[null,null,null,null,null,56,"VC AUBIGNY ",17,"CC BRIMEUX "]
[null,null,null,null,null,57,"VC AUXI LE CHATEAU ",38,"EV GUINES "]
[null,null,null,null,null,58,"VC BARLIN",25,"CCBL LES D'JAKASS"]
[null,null,null,null,null,59,"VC BETHUNE ",49,"TERNOIS VELO VERT"]
[null,null,null,null,null,60,"VC NOEUX LES MINES ",50,"TOUQUET ACC"]
[null,null,null,null,null,61,"VC PROVIN ",18,"CC CAUCHY A LA TOUR "]
[null,null,null,null,null,62,"VC SAINT OMER ",40,"HERMELINGHEN "]
[null,null,null,null,null,63,"VTT 2 CAPS WIERRE EFFROY ",32,"E.C.H HENIN-BEAUMONT "]