{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["tableau de bord","Race","multi","Grille","doublon","ticket","base","version"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"tableau de bord","index":0,"n_rows":1,"n_cols":24,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID unique","info1","info2","info3","plaque","NOM Prénom","club","catégorie","race","position","M1","M2","M3","total","résultat","race 1/4","position","résultat","race 1/2","position","résultat","race F","position","résultat"]

{"sheet":"Race","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,4],[10,5,10,7],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,33,4],[32,5,32,7]]}
[null,null,null,null,"course","Trophée de la carotte"]
[null,null,null,null,"organisateur ","panpan"]
[]
[null,null,null,null,"date","24 avril 2019"]
[]
[null,null,null,null,"catégorie"]
[]
[]
["Manches Qualificatives",null,null,null,"race n°"]
[]
["Plaque","Nom",null,"Club",null,"position de départ"]
[null,null,null,null,null,1,2,3]
[null,null,null,null,null,8,2,3]
[null,null,null,null,null,7,6,1]
[null,null,null,null,null,6,3,5]
[null,null,null,null,null,5,1,7]
[null,null,null,null,null,4,8,2]
[null,null,null,null,null,3,5,6]
[null,null,null,null,null,2,7,4]
[null,null,null,null,null,1,4,8]
["Les 4 premiers vont en finale"]
[]
[null,null,null,null,"course",{"$f":"F1","v":"Trophée de la carotte"}]
[null,null,null,null,"organisateur ",{"$f":"F2","v":"panpan"}]
[]
[null,null,null,null,"date",{"$f":"F4","v":"24 avril 2019"}]
[]
[null,null,null,null,"catégorie","Prélicencié"]
[]
[]
["Manches Qualificatives",null,null,null,"race n°"]
[]
["Plaque","Nom",null,"Club",null,"position de départ"]
[null,null,null,null,null,1,2,3]
[null,null,null,null,null,8,2,3]
[null,null,null,null,null,7,6,1]
[null,null,null,null,null,6,3,5]
[null,null,null,null,null,5,1,7]
[null,null,null,null,null,4,8,2]
[null,null,null,null,null,3,5,6]
[null,null,null,null,null,2,7,4]
[null,null,null,null,null,1,4,8]
["Les 4 premiers vont en finale"]
[]
[]
["Ces races ont été créés avec RacExcel, logiciel gratuit de BMX"]

{"sheet":"multi","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["RACE",null,"catégorie"]
[null,null,null,null,null,null,null,8,2,3]
[null,null,null,null,null,null,null,7,6,1]
[null,null,null,null,null,null,null,6,3,5]
[null,null,null,null,null,null,null,5,1,7]
[null,null,null,null,null,null,null,4,8,2]
[null,null,null,null,null,null,null,3,5,6]
[null,null,null,null,null,null,null,2,7,4]
[null,null,null,null,null,null,null,1,4,8]
[null,null,null,null,null,null,"classement sur 3 manches"]
[]
["RACE",null,"catégorie"]
[null,null,null,null,null,null,null,8,2,3]
[null,null,null,null,null,null,null,7,6,1]
[null,null,null,null,null,null,null,6,3,5]
[null,null,null,null,null,null,null,5,1,7]
[null,null,null,null,null,null,null,4,8,2]
[null,null,null,null,null,null,null,3,5,6]
[null,null,null,null,null,null,null,2,7,4]
[null,null,null,null,null,null,null,1,4,8]
[null,null,null,null,null,null,"classement sur 3 manches"]
[]
["RACE",null,"catégorie"]
[null,null,null,null,null,null,null,8,2,3]
[null,null,null,null,null,null,null,7,6,1]
[null,null,null,null,null,null,null,6,3,5]
[null,null,null,null,null,null,null,5,1,7]
[null,null,null,null,null,null,null,4,8,2]
[null,null,null,null,null,null,null,3,5,6]
[null,null,null,null,null,null,null,2,7,4]
[null,null,null,null,null,null,null,1,4,8]
[null,null,null,null,null,null,"classement sur 3 manches"]
[]
["RACE",null,"catégorie"]
[null,null,null,null,null,null,null,8,2,3]
[null,null,null,null,null,null,null,7,6,1]
[null,null,null,null,null,null,null,6,3,5]
[null,null,null,null,null,null,null,5,1,7]
[null,null,null,null,null,null,null,4,8,2]
[null,null,null,null,null,null,null,3,5,6]
[null,null,null,null,null,null,null,2,7,4]
[null,null,null,null,null,null,null,1,4,8]
[null,null,null,null,null,null,"classement sur 3 manches"]
[]
["RACE",null,"catégorie"]
[null,null,null,null,null,null,null,8,2,3]
[null,null,null,null,null,null,null,7,6,1]
[null,null,null,null,null,null,null,6,3,5]
[null,null,null,null,null,null,null,5,1,7]
[null,null,null,null,null,null,null,4,8,2]
[null,null,null,null,null,null,null,3,5,6]
[null,null,null,null,null,null,null,2,7,4]
[null,null,null,null,null,null,null,1,4,8]
[null,null,null,null,null,null,"classement sur 3 manches"]

{"sheet":"Grille","index":3,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,1,2,3,4,5,6,7,8]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]
[]
[]
[]
[null,"race 1",null,"M1"]
[null,null,null,"M2"]
["catégorie",null,null,"M3"]

{"sheet":"doublon","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ticket","index":5,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,"RACE",null,null,null,null,null,"RACE",null,null,null,null,null,"RACE"]
[]
["Doublons",null,null,null,null,null,"Doublons",null,null,null,null,null,"Doublons"]
[]
[1,null,null,null,null,null,1,null,null,null,null,null,1]
[2,null,null,null,null,null,2,null,null,null,null,null,2]
[3,null,null,null,null,null,3,null,null,null,null,null,3]
[4,null,null,null,null,null,4,null,null,null,null,null,4]
[5,null,null,null,null,null,5,null,null,null,null,null,5]
[6,null,null,null,null,null,6,null,null,null,null,null,6]
[7,null,null,null,null,null,7,null,null,null,null,null,7]
[8,null,null,null,null,null,8,null,null,null,null,null,8]
[]
[]
[null,null,"RACE",null,null,null,null,null,"RACE",null,null,null,null,null,"RACE"]
[]
["Doublons",null,null,null,null,null,"Doublons",null,null,null,null,null,"Doublons"]
[]
[1,null,null,null,null,null,1,null,null,null,null,null,1]
[2,null,null,null,null,null,2,null,null,null,null,null,2]
[3,null,null,null,null,null,3,null,null,null,null,null,3]
[4,null,null,null,null,null,4,null,null,null,null,null,4]
[5,null,null,null,null,null,5,null,null,null,null,null,5]
[6,null,null,null,null,null,6,null,null,null,null,null,6]
[7,null,null,null,null,null,7,null,null,null,null,null,7]
[8,null,null,null,null,null,8,null,null,null,null,null,8]

{"sheet":"base","index":6,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["min","max","race",null,"départ","arrivée","série",1,2,3,4,5,6,7,8]
[1,8,1,null,2,1,1,11,21,12,22,13,23,14,24]
[9,16,2,null,3,2,1,11,22,32,13,33,24]
[17,19,3,null,3,2,2,21,31,12,23,14,34]
[20,32,4,null,4,2,1,11,41,22,32,13,43,24,34]
[33,42,6,null,4,2,2,21,31,12,42,23,33,14,44]
[43,64,8,null,6,4,1,11,22,32,43,53,64]
[65,84,12,null,6,4,2,21,12,42,33,63,54]
[85,128,16,null,6,4,3,31,61,52,23,14,44]
[129,160,24,null,6,4,4,41,51,62,13,24,34]
[161,256,32,null,8,4,1,11,51,22,62,33,73,44,84]
[257,320,40,null,8,4,2,21,61,32,72,43,83,54,14]
[321,384,48,null,8,4,3,31,71,42,82,53,13,64,24]
[387,512,64,null,8,4,4,41,81,52,12,63,23,74,34]
[null,null,null,null,12,8,1,11,91,62,33,113,84]
[null,null,null,null,12,8,2,21,101,72,43,123,94]
[null,null,null,null,12,8,3,31,111,82,53,13,101]
[null,null,null,null,12,8,4,41,121,92,63,23,114]
[null,null,null,null,12,8,5,51,22,102,73,44,124]
[null,null,null,null,12,8,6,61,32,112,83,54,14]
[null,null,null,null,12,8,7,71,42,122,93,64,24]
[null,null,null,null,12,8,8,81,52,12,103,74,34]
[null,null,null,null,16,8,1,11,91,162,82,153,73,144,64]
[null,null,null,null,16,8,2,21,101,12,92,163,83,154,74]
[null,null,null,null,16,8,3,31,111,22,102,13,93,164,84]
[null,null,null,null,16,8,4,41,121,32,112,23,103,14,94]
[null,null,null,null,16,8,5,51,131,42,122,33,113,23,104]
[null,null,null,null,16,8,6,61,141,52,132,43,123,34,114]
[null,null,null,null,16,8,7,71,151,62,142,53,133,44,124]
[null,null,null,null,16,8,8,81,161,72,152,63,143,54,134]
[null,null,null,null,24,16,null,11,171,102,33,193,124]
[null,null,null,null,24,16,null,21,181,112,43,203,134]
[null,null,null,null,24,16,null,31,191,122,53,213,144]
[null,null,null,null,24,16,null,41,201,132,63,223,154]
[null,null,null,null,24,16,null,51,211,142,73,233,164]
[null,null,null,null,24,16,null,61,221,152,83,243,174]
[null,null,null,null,24,16,null,71,231,162,93,13,184]
[null,null,null,null,24,16,null,81,241,172,103,23,194]
[null,null,null,null,24,16,null,91,22,182,113,44,204]
[null,null,null,null,24,16,null,101,32,192,123,54,214]
[null,null,null,null,24,16,null,111,42,202,133,64,224]
[null,null,null,null,24,16,null,121,52,212,143,74,234]
[null,null,null,null,24,16,null,131,62,222,153,83,244]
[null,null,null,null,24,16,null,141,72,232,163,94,14]
[null,null,null,null,24,16,null,151,82,242,173,104,24]
[null,null,null,null,24,16,null,161,92,12,183,114,34]
[null,null,null,null,32,16,null,11,31,52,72,93,113,134,154]
[null,null,null,null,32,16,null,21,41,62,82,103,123,144,164]
[null,null,null,null,32,16,null,51,71,92,112,133,153,174,194]
[null,null,null,null,32,16,null,61,81,102,122,143,163,184,204]
[null,null,null,null,32,16,null,91,111,132,152,173,193,214,234]
[null,null,null,null,32,16,null,101,121,142,162,183,203,224,244]
[null,null,null,null,32,16,null,131,151,172,192,213,233,254,274]
[null,null,null,null,32,16,null,141,161,182,202,223,243,264,284]
[null,null,null,null,32,16,null,171,191,212,232,253,273,294,314]
[null,null,null,null,32,16,null,181,201,222,242,263,283,304,324]
[null,null,null,null,32,16,null,211,231,252,272,293,313,14,34]
[null,null,null,null,32,16,null,221,241,262,282,303,323,24,44]
[null,null,null,null,32,16,null,251,271,292,312,13,33,54,74]
[null,null,null,null,32,16,null,261,281,302,322,23,43,64,84]
[null,null,null,null,32,16,null,291,311,12,32,53,73,94,114]
[null,null,null,null,32,16,null,301,321,22,42,63,83,104,124]

{"sheet":"version","index":7,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["version","état","type","description"]
["1.190307.1737",null,"new"]
["1.190307.2025","fait","new","montage des nièmes v2"]
["1.190308.2116","fait","correction","tri les races pour afficher correctement les manches qualificatives"]
["1.190309.1128","fait","new","module pour rentrer les nième de finale"]
["1.190309.1523","fait","new","impression des nieme"]
["1.190315.2223","fait","new","réorganisation des boutons"]
["1.190316.1849","fait","new","module impression regroupé"]
["1.190316.2212","fait","new","module résultat nième regroupé"]
[1.1903239999999999,"fait","new","quand 1/2 finale a 6, effacement de la place 7 et 8"]
["190407","fait","correction","affichage du montage avant le message de fin"]
[null,"fait","cosmetique","mise en gras de la plaque + case club + grande"]
[null,"fait","correction","probleme si trop d'absent dans une race"]
[null,"fait","correction","affichage vide sur la dernière race"]
[null,"fait","correction","revoir numérotation des manches"]
[null,"fait","correction","numérotation des nième"]
["190410","fait","new","gestion des abs"]
[null,"fait","new","doublons en couleur lors de la saisie des manches"]
["190411","fait","new","doublons en couleur pour les nième"]
[null,"fait","cosmetique","affichage des races, légère différence entre les labels et les textbox"]
[null,"fait","correction","doublons dans les nième fusionné avec la fonction doublons dans les manches"]
[null,"fait","correction","l'impression des niemes ne faisait pas apparaitre certains pilotes"]
["190415","fait","correction","la règle de abs+2 oblige a avoir un tableau place plus grand (8+2=10) afin d'avoir toute les possibilités"]
["190416","fait","correction","si 2 pilotes ex eaquo 1 1 7 et 4 4 1 alors pb avec la dernière manche car place=1"]
[null,"fait","correction","probleme si une catégorie contient entre 40 et 42 pilotes"]
[null,"fait","new","résultat par la souris"]
[null,"fait","correction","un pilote a une place de 0.9999996 au lieu de 1"]
[null,"fait","correction","numérotation des nième corrigé"]
[null,"fait","cosmetique","si à la souris pil>8 alors désactivation de la souris et il faut finir au clavier"]
[null,"fait","cosmetique","nom de la fenetre résultat manche 1 pour les manches"]
[null,"fait","cosmetique","nom de la fenetre résultat manche change suivant le bouton des manches"]
[null,"fait","cosmetique","nom de la fenetre pour les nieme"]
[null,"fait","cosmetique","agrandissement du label de la catégorie pour afficher les nom long de catégorie"]
["190418","fait","cosmetique","change userform3 des nieme pour éviter d'utiliser userform3.show a chaque race"]
["190420","fait","new","mise en place de la phrase les 4 premiers"]
[]
[]
[]
[null,null,null,"gestion de la finale à 9"]
[null,null,null,"quand on ouvre les résultats manche, il faut que ce soit le premier résultat vide"]
[null,null,null,"premier résultat vide dans les niemes"]
[null,null,null,"si fin de manche1 alors retour vers la manche 2 race 1"]
[]
[]
[null,null,"new","doc grille"]
[null,null,"new","doc prégrille"]
[null,null,"new","doc doublon"]
[null,null,"new","doublons sur la feuille de grille"]
[null,null,"new","doc classement"]
[null,null,"new","doc speaker"]
[null,null,"new","gestion si 2 abs alors eliminé"]
[null,null,"new","gestion des dnf"]
[null,null,"new","gestion des relégué départ+2"]
[null,null,"bug","montage des nième quand la numérotation est personalisée"]
[null,null,"bug","quand 2 pilotes absents en manche, il faut qu'ils soient a la même place"]
[null,null,null,"mise en place d'un film de course"]
[null,null,null,"mise en place d'un classement final"]