{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MENU","BAREME","Classe  1","Histo"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":45,"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":"MENU","index":0,"n_rows":41,"n_cols":36,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,35,9,36]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,"Barème : ",{"$f":"Date_Bareme","v":"2021-05-11"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TA",null,null,null,null,null,"STRATEGIE",null,null,null,null,"COURSE",null,null,null,"NOTES",null,null,null,null,null,null,null,null,null,null,"00:02:53","FIN"]
[null,"NOM","PRENOM","SEXE","Rapport AFLP 3/4","Degré AFLP 1 ",null,"Course 1","Course 2","Course 3","Distance totale","vitesse","Degré AFLP 3","Degré AFLP 4"," ","Note AFLP 1","Note AFLP 2","Note 3","Note 4"," CAP-BEP/20","Dossard","Alerte",null,null,"      Arrivée","Dossard \nArrivée",null," \nALERTE"]
[null,"Coureur 1",null,"F","4/4","1+",null,2.1,"X","X",{"$f":"IF(COUNT(H38:J38)=3,SUM(INT(H38:J38),INT(SUM(H38:J38-INT(H38:J38))/0.6),MOD(SUM(H38:J38-INT(H38:J38)),0.6)),\"\")","v":""},{"$f":"  IF(ISNUMBER(K38),  (1500/(INT(K38)*0.6+(K38-INT(K38))))*0.036,\"\")","v":""},"1+","2-",null,6,3,0.5,1.5,11,"V1",null,null,"Tps 1",1.2,"R1"]
[null,"Coureur 2",null,"G","2/6","2-",null,2.4700000000000002,2.2200000000000002,2.0299999999999998,6.46,13.300492610837438,null,{"$f":"IF(COUNT(F39:G39)=2,   INT(INT(G39)*60  + ( G39-INT(G39) )*100 ) -  INT( (INT(F39)*60  + (F39-INT(F39) )*100 )), \"\")","v":""},null,4,2,{"$f":"IFERROR(VLOOKUP(M39,BAREME!$AD$24:$AG$36,CHOOSE(LEFT(C39,1)/2,   2,3,4),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N39,BAREME!$AD$24:$AG$36,CHOOSE(8-LEFT(D39,1)/2, 2,3,4),FALSE),\"\")","v":""},6,null,"Il manque 2 note(s)",null,"Tps 2",2.0299999999999998,"O2"]
[null,"Coureur 3",null,"F","6/2","2-",null,4.22,null,null,null,null,null,{"$f":"IF(COUNT(F40:G40)=2,   INT(INT(G40)*60  + ( G40-INT(G40) )*100 ) -  INT( (INT(F40)*60  + (F40-INT(F40) )*100 )), \"\")","v":""},null,{"$f":"IF(COUNT(G40:H40)=2, (INT( (INT(H40)*60  + ( H40-INT(H40) )*100 )) -   IF( AND(I40=\"=\",J40=\"=\"),     INT( (INT(F40)*60  + (F40-INT(F40) )*100 )),     INT( (INT(G40)*60  + (G40-INT(G40) )*100 )))), \"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(M40,BAREME!$AD$24:$AG$36,CHOOSE(LEFT(C40,1)/2,   2,3,4),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N40,BAREME!$AD$24:$AG$36,CHOOSE(8-LEFT(D40,1)/2, 2,3,4),FALSE),\"\")","v":""},"",null,null,null,"Tps 3",2.0299999999999998,15]
[null,"Coureur 4","","M",null,"2-",null,"D",null,null,{"$f":"IF(COUNT(H41:J41)=3,SUM(INT(H41:J41),INT(SUM(H41:J41-INT(H41:J41))/0.6),MOD(SUM(H41:J41-INT(H41:J41)),0.6)),\"\")","v":""},{"$f":"  IF(ISNUMBER(K41),  (1500/(INT(K41)*0.6+(K41-INT(K41))))*0.036,\"\")","v":""},"1","3",null,{"$f":"IF(COUNT(G42:H42)=2, (INT( (INT(H42)*60  + ( H42-INT(H42) )*100 )) -   IF( AND(I42=\"=\",J42=\"=\"),     INT( (INT(F42)*60  + (F42-INT(F42) )*100 )),     INT( (INT(G42)*60  + (G42-INT(G42) )*100 )))), \"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(M41,BAREME!$AD$24:$AG$36,CHOOSE(LEFT(C42,1)/2,   2,3,4),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N41,BAREME!$AD$24:$AG$36,CHOOSE(8-LEFT(D42,1)/2, 2,3,4),FALSE),\"\")","v":""},"D",null,null,null,"Tps 4","X","V1"]

{"sheet":"BAREME","index":1,"n_rows":45,"n_cols":33,"rows_kept":45,"cut":false,"hidden":false,"merged":[[27,1,27,4],[28,1,30,4],[34,1,34,3],[0,17,0,27],[2,29,2,32],[3,29,3,32],[1,4,1,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP - BEP  800 m"]
[null,null,null,null,"2021-05-11"]
[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,"Mode d'éval  AFLP 3 & 4  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$11","v":"1-"},{"$f":"$G$12","v":"1+"},{"$f":"$G$13","v":"2-"},{"$f":"$G$14","v":"2+"},{"$f":"$G$15","v":"3-"},{"$f":"$G$16","v":"3+"},{"$f":"$G$17","v":"4-"},{"$f":"$G$18","v":"4+"},null,"Niveau"]
[null,null,null,null,"Tolerance  course identique  + ou -  ",3,null,null,"Niv Perf","TEMPS","TEMPS",null,"TEMPS","NOTE","TEMPS","NOTE",null,"Decal F",null,null,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null," / 14","Filles","Garcons",null,"Filles"," / 14","Garcons"," / 14",null,"Decal G",null,null,2,3,4,5,6,7,8,9,null,null,null,"Notes  3 & 4"]
[null,null,"Projet de course",null,null,null,null,null,"1a",5.05,4.1500000000000004,null,0.01,{"$f":"I34","v":"5a"},0.01,{"$f":"N7","v":"5a"},null,"5a",{"$f":"M7","v":0.01},{"$f":"O7","v":0.01},6,6,7,7,7,7,7,7,null,null," /2"," /4"," /6"]
[null,null,"Projets ","Projets ","Projets ",null,null,null,"1b",5,4.04,null,{"$f":"BAREME!J34+0.01","v":0.01},{"$f":"I33","v":"5a"},{"$f":"BAREME!K34+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,0,0,0]
[null,null,"Réussi","Initiaux","Corrigés",null,"Degré",null,"1c",4.55,3.58,null,{"$f":"BAREME!J33+0.01","v":0.01},{"$f":"I32","v":"5a"},{"$f":"BAREME!K33+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,0.5,0.5,0.5]
[null,null,0,0,0,null," AFLP 1",null,"1d",4.45,3.52,null,{"$f":"BAREME!J32+0.01","v":0.01},{"$f":"I31","v":"5a"},{"$f":"BAREME!K32+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,1,1,1]
[null,null,1,1.5,1,null,"1-",null,"1e",4.4000000000000004,3.47,null,{"$f":"BAREME!J31+0.01","v":0.01},{"$f":"I30","v":"5a"},{"$f":"BAREME!K31+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,1.5,1.5,1.5]
[null,null,2,3,2,null,"1+",null,"2a",4.3499999999999996,3.42,null,{"$f":"BAREME!J30+0.01","v":0.01},{"$f":"I29","v":"5a"},{"$f":"BAREME!K30+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,2,2,2]
[null,null,null,null,null,null,"2-",null,"2b",4.3,3.37,null,{"$f":"BAREME!J29+0.01","v":0.01},{"$f":"I28","v":"5a"},{"$f":"BAREME!K29+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,null,2.5,2.5]
[null,"Note C1",null,6,null,null,"2+",null,"2c",4.25,3.32,null,{"$f":"BAREME!J28+0.01","v":0.01},{"$f":"I27","v":"5a"},{"$f":"BAREME!K28+0.01","v":0.01},"5a",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,null,3,3]
[null,"Prepa",null,3,null,null,"3-",null,"2d",4.2,3.28,null,{"$f":"BAREME!J27+0.01","v":0.01},{"$f":"I26","v":"4e"},{"$f":"BAREME!K27+0.01","v":0.01},"4e",null,"5a",0.01,0.01,6,6,7,7,7,7,7,7,null,null,null,3.5,3.5]
[null,null,null,null,null,null,"3+",null,"2e",4.1500000000000004,3.21,null,{"$f":"BAREME!J26+0.01","v":3.36},{"$f":"I25","v":"4d"},{"$f":"BAREME!K26+0.01","v":2.4099999999999997},"4d",null,"4e",3.36,2.4099999999999997,6,6,7,7,7,7,7,7,null,null,null,4,4]
[null,null,null,null,null,null,"4-",null,"3a",4.0999999999999996,3.17,null,{"$f":"BAREME!J25+0.01","v":3.3899999999999997},{"$f":"I24","v":"4c"},{"$f":"BAREME!K25+0.01","v":2.5099999999999998},"4c",null,"4d",3.3899999999999997,2.5099999999999998,6,6,6,7,7,7,7,7,null,null,null,null,4.5]
[null,null,null,null,null,null,"4+",null,"3b",4.05,3.13,null,{"$f":"BAREME!J24+0.01","v":3.42},{"$f":"I23","v":"4b"},{"$f":"BAREME!K24+0.01","v":2.5299999999999998},"4b",null,"4c",3.42,2.5299999999999998,6,6,6,6,6,6,6,6,null,null,null,null,5]
[null,null,null,null,null,null,null,null,"3c",4,3.09,null,{"$f":"BAREME!J23+0.01","v":3.46},{"$f":"I22","v":"4a"},{"$f":"BAREME!K23+0.01","v":2.5599999999999996},"4a",null,"4b",3.46,2.5599999999999996,5,6,6,6,6,6,6,6,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,"3d",3.57,3.05,null,{"$f":"BAREME!J22+0.01","v":3.5},{"$f":"I21","v":"3e"},{"$f":"BAREME!K22+0.01","v":2.59},"3e",null,"4a",3.5,2.59,5,5,5,5,6,6,6,6,null,null,null,null,6]
[null,null,"Distance totale",null,800,null,"Note",null,"3e",3.53,3.01,null,{"$f":"BAREME!J21+0.01","v":3.5399999999999996},{"$f":"I20","v":"3d"},{"$f":"BAREME!K21+0.01","v":3.0199999999999996},"3d",null,"3e",3.5399999999999996,3.0199999999999996,5,5,5,5,5,5,5,6]
[null,null,"Nb de Courses",null,1,null," AFLP  2",null,"4a",3.49,2.58,null,{"$f":"BAREME!J20+0.01","v":3.5799999999999996},{"$f":"I19","v":"3c"},{"$f":"BAREME!K20+0.01","v":3.0599999999999996},"3c",null,"3d",3.5799999999999996,3.0599999999999996,4,4,4,5,5,5,5,5]
[null,null,null,null,null,null,0,null,"4b",3.45,2.5499999999999998,null,{"$f":"BAREME!J19+0.01","v":4.01},{"$f":"I18","v":"3b"},{"$f":"BAREME!K19+0.01","v":3.0999999999999996},"3b",null,"3c",4.01,3.0999999999999996,4,4,4,4,4,5,5,5,null,"Niveau",null,"Notes  3 & 4"]
[null,null,null,null,null,null,0.5,null,"4c",3.41,2.52,null,{"$f":"BAREME!J18+0.01","v":4.0599999999999996},{"$f":"I17","v":"3a"},{"$f":"BAREME!K18+0.01","v":3.1399999999999997},"3a",null,"3b",4.0599999999999996,3.1399999999999997,4,4,4,4,4,4,4,4,null," AFLP  3 /4"," /2"," /4"," /6"]
[null,null,null,null,null,null,1,null,"4d",3.38,2.5,null,{"$f":"BAREME!J17+0.01","v":4.1099999999999994},{"$f":"I16","v":"2e"},{"$f":"BAREME!K17+0.01","v":3.1799999999999997},"2e",null,"3a",4.1099999999999994,3.1799999999999997,3,3,3,4,4,4,4,4,null,"1-",0,0,0]
[null,null,null,null,null,null,1.5,null,"4e",3.35,2.4,null,{"$f":"BAREME!J16+0.01","v":4.16},{"$f":"I15","v":"2d"},{"$f":"BAREME!K16+0.01","v":3.2199999999999998},"2d",null,"2e",4.16,3.2199999999999998,3,3,3,3,3,3,4,4,null,"1",0.5,0.5,0.5]
[null,null,"Chronometrage ",null,null,null,2,null,"5a",null,null,null,{"$f":"BAREME!J15+0.01","v":4.21},{"$f":"I14","v":"2c"},{"$f":"BAREME!K15+0.01","v":3.2899999999999996},"2c",null,"2d",4.21,3.2899999999999996,3,3,3,3,3,3,3,3,null,"1+",0.5,0.5,1]
[null,"1  Win  Clavier & Boutons écran  ",null,null,null,null,2.5,null,"5a",null,null,null,{"$f":"BAREME!J14+0.01","v":4.26},{"$f":"I13","v":"2b"},{"$f":"BAREME!K14+0.01","v":3.3299999999999996},"2b",null,"2c",4.26,3.3299999999999996,2,2,2,3,3,3,3,3,null,"2-",1,1,1.5]
[null,{"$f":"CHOOSE(LEFT(B28,1),\"ESC et Fleche Bas + Boutons Ecran  TESTER VITESSE DE REACTION\",\" Clic Droit Souris + ESC et Fleche Bas  TESTER VITESSE DE RECATION\",\"Clavier BAS & ESC + Clic sur BOUTON  Verifier la vitesse de réaction  pour une arrivée groupée \", \" Souris = Chrono à distance   Tester la vitesse de reaction de l'ordi\", \"Souris =Chrono  à distance  Attention à rester sur la bouton  Conseil = Masquer le capteur de mvt => Seul le bouton actif\"  )","v":"ESC et Fleche Bas + Boutons Ecran  TESTER VITESSE DE REACTION"},null,null,null,null,3,null,"5a",null,null,null,{"$f":"BAREME!J13+0.01","v":4.3099999999999996},{"$f":"I12","v":"2a"},{"$f":"BAREME!K13+0.01","v":3.38},"2a",null,"2b",4.3099999999999996,3.38,2,2,2,2,2,3,3,3,null,"2",1,1.5,2]
[null,null,null,null,null,null,3.5,null,"5a",null,null,null,{"$f":"BAREME!J12+0.01","v":4.3599999999999994},{"$f":"I11","v":"1e"},{"$f":"BAREME!K12+0.01","v":3.4299999999999997},"1e",null,"2a",4.3599999999999994,3.4299999999999997,1,2,2,2,2,2,2,2,null,"2+",1,1.5,2.5]
[null,null,null,null,null,null,4,null,"5a",null,null,null,{"$f":"BAREME!J11+0.01","v":4.41},{"$f":"I10","v":"1d"},{"$f":"BAREME!K11+0.01","v":3.48},"1d",null,"1e",4.41,3.48,1,1,1,2,2,2,2,2,null,"3-",1.5,2,3]
[null,null,null,null,null,null,4.5,null,"5a",null,null,null,{"$f":"BAREME!J10+0.01","v":4.46},{"$f":"I9","v":"1c"},{"$f":"BAREME!K10+0.01","v":3.53},"1c",null,"1d",4.46,3.53,1,1,1,1,1,2,2,2,null,"3",1.5,2.5,3.5]
[null,null,"Bouton Arrivée","2  Centre",null,null,5,null,"5a",null,null,null,{"$f":"BAREME!J9+0.01","v":4.5599999999999996},{"$f":"I8","v":"1b"},{"$f":"BAREME!K9+0.01","v":3.59},"1b",null,"1c",4.5599999999999996,3.59,0,1,1,1,1,1,1,1,null,"3+",1.5,3,4]
[null,null,"ZOOM Auto ","Auto",null,null,null,null,"5a",null,null,null,{"$f":"BAREME!J8+0.01","v":5.01},{"$f":"I7","v":"1a"},{"$f":"BAREME!K8+0.01","v":4.05},"1a",null,"1b",5.01,4.05,0,0,0,1,1,1,1,1,null,"3++",1.5,3,4.5]
[null,"Affiche toutes les colonnes",null,null,null,null,null,null,null,null,null,null,{"$f":"BAREME!J7+0.01","v":5.0599999999999996},0,{"$f":"BAREME!K7+0.01","v":4.16},0,null,"1a",5.0599999999999996,4.16,0,0,0,0,0,0,1,1,null,"4-",2,3.5,5]
[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,"4",2,3.5,5.5]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"4+",2,4,6]
[null,"Tps max  / Course",null,8,null,null,null,null,null,null,null,null,1,{"$f":"LEFT(G21)","v":"N"},{"$f":"RIGHT(G21)","v":"e"},{"$f":"G21","v":"Note"},1]
[null,"Pour éviter erreur de saisie",null,null,null,null,null,null,null,null,null,null,2," ","2"," AFLP  2",2]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"0","0",0,3]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"0","5",0.5,4]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"1","1",1,5]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"1","5",1.5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,7,"2","2",2,7]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"2","5",2.5,8]

{"sheet":"Classe  1","index":2,"n_rows":39,"n_cols":39,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,9,0,22]]}
[null,null,null,null,null,null,null,null,null,{"$f":"BAREME!R1","v":"CAP - BEP  800 m"}]
[null,"Classe  1",null,null,null,null,null,null,null,null,null,null,"COURSES",null,null,null,null,null,null,null,null,null,null,"NOTES",null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[null,"NOM","Prenom","SEXE","Rapport AFLP 3/4","Degré AFLP 1 ",null,"Course 1","Course 2","Course 3","Course 4","Course 5",{"$f":"Dist_Tot","v":800},"vitesse","Degré AFLP 3","Degré AFLP 4"," ",null,null,"Note AFLP 1","Note AFLP 2","Note 3","Note 4"," CAP-BEP/20",null,"Dossard","Alerte",null,null," COMMENTAIRES",null,null,null,null,"Arrivée","Dossard \nArrivée",null,null," \nALERTE"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G4),IF(ISERR(VALUE(F4)),LEFT(F4,1),T(VLOOKUP(VALUE(F4),BAREME!$M$37:$O$45,2,FALSE))),IF(ISERR(VALUE(G4)), LEFT(G4,1), T( VLOOKUP(VALUE(G4),BAREME!$M$37:$O$45,2,FALSE))))","v":""},{"$f":"IF(ISBLANK(G4),IF(ISERR(VALUE(F4)),RIGHT(F4,1),T(VLOOKUP(VALUE(F4),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G4)), RIGHT(G4,1), T( VLOOKUP(VALUE(G4),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H4:J4)=Nb_Courses,SUM(INT(H4:J4),INT(SUM(H4:J4-INT(H4:J4))/0.6),MOD(SUM(H4:J4-INT(H4:J4)),0.6)),\"\")","v":""},{"$f":"  IF(ISNUMBER(M4),  (Dist_Tot/(INT(M4)*0.6+(M4-INT(M4))))*0.036,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M4),D4<>\"\",F4<>\"\"),VLOOKUP(M4,IF(D4=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H4=\"X\",I4=\"X\",J4=\"X\"),0,\"\"))","v":""},null,{"$f":"IFERROR(VLOOKUP(O4,Niv_AFLP_3_4,CHOOSE(LEFT(E4,1)/2,   2,3,4),FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P4,Niv_AFLP_3_4,CHOOSE(RIGHT(E4,1)/2, 2,3,4),FALSE),\"\")","v":""},{"$f":"IF(COUNT(T4:W4),SUM(T4:W4),IF(ISTEXT(H4),H4,\"\"))","v":""},"",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z4)>1,\"Doublon\",IF(OR(X4=\"A\",X4=\"D\"),\"\",   IF(AB4<>\"\",AB4,   IF(AND(D4<>\"F\",D4<>\"G\",D4<>\"M\",D4<>\"\"),\"Sexe Non Valide\",IF(AND(D4=\"\",M4<>\"\"),\" Sexe ?\",IF(OR(N(V4)<0,N(V4)>Max_Note3),\"Pb Note 3\",IF(OR(N(W4)<0,N(W4)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X4),COUNT(T4:W4)<4), \"Il manque \"& (4-COUNT(T4:W4)) & \" note(s)\",\"\")))))))), \"\")","v":""},{"$f":"IF(  COUNT(H4:J4),   IF(ISBLANK(F4),\"Manque le Degré AFLP1 \",IF(AND(F4<>\"\",ISERROR(MATCH(F4,Liste_AFLP1,0))),\"ErreurDegré AFLP1\",IF(AND(ISBLANK(E4),ISNUMBER(X4)),\"Manque Rapport AFLP3/4\",\"\"))),\"\")","v":""},null,null,null,null,null,"Tps 1",null,null,{"$f":"IF(ISBLANK(Dossard_Arrivée),\"\",MATCH(Dossard_Arrivée,Dossard,0))","v":""},{"$f":"ISERROR(AK4)","v":false},{"$f":"IF(AL4,\" DOSSARD NON ATTRIBUE\",IF(COUNTIF(Dossard_Arrivée,Dossard_Arrivée)>1,\"Doublon\",IF(AND(Dossard_Arrivée<>\"\",Arrivee=\"\"),\"DOSSARD SANS TEMPS\",IF(AND(Dossard_Arrivée=\"\",Arrivee<>\"\"),\"TEMPS SANS DOSSARD\",\"\"))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G5),IF(ISERR(VALUE(F5)),LEFT(F5,1),CHOOSE(VALUE(F5)+1,\"\",\"=\",\"+\",\"=\",\"=\",\"-\",\"+\",\"-\",\"+\")),IF(ISERR(VALUE(G5)),LEFT(G5,1),CHOOSE(VALUE(G5),\"=\",\"+\",\"=\",\"=\",\"-\",\"+\",\"-\",\"+\")))","v":""},{"$f":"IF(ISBLANK(G5),IF(ISERR(VALUE(F5)),RIGHT(F5,1),T(VLOOKUP(VALUE(F5),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G5)), RIGHT(G5,1), T( VLOOKUP(VALUE(G5),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H5:J5)=Nb_Courses,SUM(INT(H5:J5),INT(SUM(H5:J5-INT(H5:J5))/0.6),MOD(SUM(H5:J5-INT(H5:J5)),0.6)),\"\")","v":""},{"$f":"  IF(ISNUMBER(M5),  (Dist_Tot/(INT(M5)*0.6+(M5-INT(M5))))*0.036,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M5),D5<>\"\",F5<>\"\"),VLOOKUP(M5,IF(D5=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H5=\"X\",I5=\"X\",J5=\"X\"),0,\"\"))","v":""},null,"","",{"$f":"IF(COUNT(T5:W5),SUM(T5:W5),IF(ISTEXT(H5),H5,\"\"))","v":""},"",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z5)>1,\"Doublon\",IF(OR(X5=\"A\",X5=\"D\"),\"\",   IF(AB5<>\"\",AB5,   IF(AND(D5<>\"F\",D5<>\"G\",D5<>\"M\",D5<>\"\"),\"Sexe Non Valide\",IF(AND(D5=\"\",M5<>\"\"),\" Sexe ?\",IF(OR(N(V5)<0,N(V5)>Max_Note3),\"Pb Note 3\",IF(OR(N(W5)<0,N(W5)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X5),COUNT(T5:W5)<4), \"Il manque \"& (4-COUNT(T5:W5)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 2",null,null,"",{"$f":"ISERROR(AK5)","v":false},""]
[3,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G6),IF(ISERR(VALUE(F6)),RIGHT(F6,1),T(VLOOKUP(VALUE(F6),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G6)), RIGHT(G6,1), T( VLOOKUP(VALUE(G6),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H6:J6)=Nb_Courses,SUM(INT(H6:J6),INT(SUM(H6:J6-INT(H6:J6))/0.6),MOD(SUM(H6:J6-INT(H6:J6)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M6),D6<>\"\",F6<>\"\"),VLOOKUP(M6,IF(D6=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H6=\"X\",I6=\"X\",J6=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z6)>1,\"Doublon\",IF(OR(X6=\"A\",X6=\"D\"),\"\",   IF(AB6<>\"\",AB6,   IF(AND(D6<>\"F\",D6<>\"G\",D6<>\"M\",D6<>\"\"),\"Sexe Non Valide\",IF(AND(D6=\"\",M6<>\"\"),\" Sexe ?\",IF(OR(N(V6)<0,N(V6)>Max_Note3),\"Pb Note 3\",IF(OR(N(W6)<0,N(W6)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X6),COUNT(T6:W6)<4), \"Il manque \"& (4-COUNT(T6:W6)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 3",null,null,"",false,""]
[4,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G7),IF(ISERR(VALUE(F7)),RIGHT(F7,1),T(VLOOKUP(VALUE(F7),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G7)), RIGHT(G7,1), T( VLOOKUP(VALUE(G7),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H7:J7)=Nb_Courses,SUM(INT(H7:J7),INT(SUM(H7:J7-INT(H7:J7))/0.6),MOD(SUM(H7:J7-INT(H7:J7)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M7),D7<>\"\",F7<>\"\"),VLOOKUP(M7,IF(D7=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H7=\"X\",I7=\"X\",J7=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z7)>1,\"Doublon\",IF(OR(X7=\"A\",X7=\"D\"),\"\",   IF(AB7<>\"\",AB7,   IF(AND(D7<>\"F\",D7<>\"G\",D7<>\"M\",D7<>\"\"),\"Sexe Non Valide\",IF(AND(D7=\"\",M7<>\"\"),\" Sexe ?\",IF(OR(N(V7)<0,N(V7)>Max_Note3),\"Pb Note 3\",IF(OR(N(W7)<0,N(W7)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X7),COUNT(T7:W7)<4), \"Il manque \"& (4-COUNT(T7:W7)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 4",null,null,"",false,""]
[5,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G8),IF(ISERR(VALUE(F8)),RIGHT(F8,1),T(VLOOKUP(VALUE(F8),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G8)), RIGHT(G8,1), T( VLOOKUP(VALUE(G8),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H8:J8)=Nb_Courses,SUM(INT(H8:J8),INT(SUM(H8:J8-INT(H8:J8))/0.6),MOD(SUM(H8:J8-INT(H8:J8)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M8),D8<>\"\",F8<>\"\"),VLOOKUP(M8,IF(D8=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H8=\"X\",I8=\"X\",J8=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z8)>1,\"Doublon\",IF(OR(X8=\"A\",X8=\"D\"),\"\",   IF(AB8<>\"\",AB8,   IF(AND(D8<>\"F\",D8<>\"G\",D8<>\"M\",D8<>\"\"),\"Sexe Non Valide\",IF(AND(D8=\"\",M8<>\"\"),\" Sexe ?\",IF(OR(N(V8)<0,N(V8)>Max_Note3),\"Pb Note 3\",IF(OR(N(W8)<0,N(W8)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X8),COUNT(T8:W8)<4), \"Il manque \"& (4-COUNT(T8:W8)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 5",null,null,"",false,""]
[4,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G9),IF(ISERR(VALUE(F9)),RIGHT(F9,1),T(VLOOKUP(VALUE(F9),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G9)), RIGHT(G9,1), T( VLOOKUP(VALUE(G9),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H9:J9)=Nb_Courses,SUM(INT(H9:J9),INT(SUM(H9:J9-INT(H9:J9))/0.6),MOD(SUM(H9:J9-INT(H9:J9)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M9),D9<>\"\",F9<>\"\"),VLOOKUP(M9,IF(D9=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H9=\"X\",I9=\"X\",J9=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z9)>1,\"Doublon\",IF(OR(X9=\"A\",X9=\"D\"),\"\",   IF(AB9<>\"\",AB9,   IF(AND(D9<>\"F\",D9<>\"G\",D9<>\"M\",D9<>\"\"),\"Sexe Non Valide\",IF(AND(D9=\"\",M9<>\"\"),\" Sexe ?\",IF(OR(N(V9)<0,N(V9)>Max_Note3),\"Pb Note 3\",IF(OR(N(W9)<0,N(W9)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X9),COUNT(T9:W9)<4), \"Il manque \"& (4-COUNT(T9:W9)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 6",null,null,"",false,""]
[7,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G10),IF(ISERR(VALUE(F10)),RIGHT(F10,1),T(VLOOKUP(VALUE(F10),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G10)), RIGHT(G10,1), T( VLOOKUP(VALUE(G10),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H10:J10)=Nb_Courses,SUM(INT(H10:J10),INT(SUM(H10:J10-INT(H10:J10))/0.6),MOD(SUM(H10:J10-INT(H10:J10)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M10),D10<>\"\",F10<>\"\"),VLOOKUP(M10,IF(D10=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H10=\"X\",I10=\"X\",J10=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z10)>1,\"Doublon\",IF(OR(X10=\"A\",X10=\"D\"),\"\",   IF(AB10<>\"\",AB10,   IF(AND(D10<>\"F\",D10<>\"G\",D10<>\"M\",D10<>\"\"),\"Sexe Non Valide\",IF(AND(D10=\"\",M10<>\"\"),\" Sexe ?\",IF(OR(N(V10)<0,N(V10)>Max_Note3),\"Pb Note 3\",IF(OR(N(W10)<0,N(W10)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X10),COUNT(T10:W10)<4), \"Il manque \"& (4-COUNT(T10:W10)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 7",null,null,"",false,""]
[8,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G11),IF(ISERR(VALUE(F11)),RIGHT(F11,1),T(VLOOKUP(VALUE(F11),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G11)), RIGHT(G11,1), T( VLOOKUP(VALUE(G11),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H11:J11)=Nb_Courses,SUM(INT(H11:J11),INT(SUM(H11:J11-INT(H11:J11))/0.6),MOD(SUM(H11:J11-INT(H11:J11)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M11),D11<>\"\",F11<>\"\"),VLOOKUP(M11,IF(D11=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H11=\"X\",I11=\"X\",J11=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z11)>1,\"Doublon\",IF(OR(X11=\"A\",X11=\"D\"),\"\",   IF(AB11<>\"\",AB11,   IF(AND(D11<>\"F\",D11<>\"G\",D11<>\"M\",D11<>\"\"),\"Sexe Non Valide\",IF(AND(D11=\"\",M11<>\"\"),\" Sexe ?\",IF(OR(N(V11)<0,N(V11)>Max_Note3),\"Pb Note 3\",IF(OR(N(W11)<0,N(W11)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X11),COUNT(T11:W11)<4), \"Il manque \"& (4-COUNT(T11:W11)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 8",null,null,"",false,""]
[9,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G12),IF(ISERR(VALUE(F12)),RIGHT(F12,1),T(VLOOKUP(VALUE(F12),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G12)), RIGHT(G12,1), T( VLOOKUP(VALUE(G12),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H12:J12)=Nb_Courses,SUM(INT(H12:J12),INT(SUM(H12:J12-INT(H12:J12))/0.6),MOD(SUM(H12:J12-INT(H12:J12)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M12),D12<>\"\",F12<>\"\"),VLOOKUP(M12,IF(D12=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H12=\"X\",I12=\"X\",J12=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z12)>1,\"Doublon\",IF(OR(X12=\"A\",X12=\"D\"),\"\",   IF(AB12<>\"\",AB12,   IF(AND(D12<>\"F\",D12<>\"G\",D12<>\"M\",D12<>\"\"),\"Sexe Non Valide\",IF(AND(D12=\"\",M12<>\"\"),\" Sexe ?\",IF(OR(N(V12)<0,N(V12)>Max_Note3),\"Pb Note 3\",IF(OR(N(W12)<0,N(W12)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X12),COUNT(T12:W12)<4), \"Il manque \"& (4-COUNT(T12:W12)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 9",null,null,"",false,""]
[10,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G13),IF(ISERR(VALUE(F13)),RIGHT(F13,1),T(VLOOKUP(VALUE(F13),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G13)), RIGHT(G13,1), T( VLOOKUP(VALUE(G13),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H13:J13)=Nb_Courses,SUM(INT(H13:J13),INT(SUM(H13:J13-INT(H13:J13))/0.6),MOD(SUM(H13:J13-INT(H13:J13)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M13),D13<>\"\",F13<>\"\"),VLOOKUP(M13,IF(D13=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H13=\"X\",I13=\"X\",J13=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z13)>1,\"Doublon\",IF(OR(X13=\"A\",X13=\"D\"),\"\",   IF(AB13<>\"\",AB13,   IF(AND(D13<>\"F\",D13<>\"G\",D13<>\"M\",D13<>\"\"),\"Sexe Non Valide\",IF(AND(D13=\"\",M13<>\"\"),\" Sexe ?\",IF(OR(N(V13)<0,N(V13)>Max_Note3),\"Pb Note 3\",IF(OR(N(W13)<0,N(W13)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X13),COUNT(T13:W13)<4), \"Il manque \"& (4-COUNT(T13:W13)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 10",null,null,"",false,""]
[11,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G14),IF(ISERR(VALUE(F14)),RIGHT(F14,1),T(VLOOKUP(VALUE(F14),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G14)), RIGHT(G14,1), T( VLOOKUP(VALUE(G14),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H14:J14)=Nb_Courses,SUM(INT(H14:J14),INT(SUM(H14:J14-INT(H14:J14))/0.6),MOD(SUM(H14:J14-INT(H14:J14)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M14),D14<>\"\",F14<>\"\"),VLOOKUP(M14,IF(D14=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H14=\"X\",I14=\"X\",J14=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z14)>1,\"Doublon\",IF(OR(X14=\"A\",X14=\"D\"),\"\",   IF(AB14<>\"\",AB14,   IF(AND(D14<>\"F\",D14<>\"G\",D14<>\"M\",D14<>\"\"),\"Sexe Non Valide\",IF(AND(D14=\"\",M14<>\"\"),\" Sexe ?\",IF(OR(N(V14)<0,N(V14)>Max_Note3),\"Pb Note 3\",IF(OR(N(W14)<0,N(W14)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X14),COUNT(T14:W14)<4), \"Il manque \"& (4-COUNT(T14:W14)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 11",null,null,"",false,""]
[12,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G15),IF(ISERR(VALUE(F15)),RIGHT(F15,1),T(VLOOKUP(VALUE(F15),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G15)), RIGHT(G15,1), T( VLOOKUP(VALUE(G15),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H15:J15)=Nb_Courses,SUM(INT(H15:J15),INT(SUM(H15:J15-INT(H15:J15))/0.6),MOD(SUM(H15:J15-INT(H15:J15)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M15),D15<>\"\",F15<>\"\"),VLOOKUP(M15,IF(D15=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H15=\"X\",I15=\"X\",J15=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z15)>1,\"Doublon\",IF(OR(X15=\"A\",X15=\"D\"),\"\",   IF(AB15<>\"\",AB15,   IF(AND(D15<>\"F\",D15<>\"G\",D15<>\"M\",D15<>\"\"),\"Sexe Non Valide\",IF(AND(D15=\"\",M15<>\"\"),\" Sexe ?\",IF(OR(N(V15)<0,N(V15)>Max_Note3),\"Pb Note 3\",IF(OR(N(W15)<0,N(W15)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X15),COUNT(T15:W15)<4), \"Il manque \"& (4-COUNT(T15:W15)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 12",null,null,"",false,""]
[13,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G16),IF(ISERR(VALUE(F16)),RIGHT(F16,1),T(VLOOKUP(VALUE(F16),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G16)), RIGHT(G16,1), T( VLOOKUP(VALUE(G16),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H16:J16)=Nb_Courses,SUM(INT(H16:J16),INT(SUM(H16:J16-INT(H16:J16))/0.6),MOD(SUM(H16:J16-INT(H16:J16)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M16),D16<>\"\",F16<>\"\"),VLOOKUP(M16,IF(D16=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H16=\"X\",I16=\"X\",J16=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z16)>1,\"Doublon\",IF(OR(X16=\"A\",X16=\"D\"),\"\",   IF(AB16<>\"\",AB16,   IF(AND(D16<>\"F\",D16<>\"G\",D16<>\"M\",D16<>\"\"),\"Sexe Non Valide\",IF(AND(D16=\"\",M16<>\"\"),\" Sexe ?\",IF(OR(N(V16)<0,N(V16)>Max_Note3),\"Pb Note 3\",IF(OR(N(W16)<0,N(W16)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X16),COUNT(T16:W16)<4), \"Il manque \"& (4-COUNT(T16:W16)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 13",null,null,"",false,""]
[14,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G17),IF(ISERR(VALUE(F17)),RIGHT(F17,1),T(VLOOKUP(VALUE(F17),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G17)), RIGHT(G17,1), T( VLOOKUP(VALUE(G17),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H17:J17)=Nb_Courses,SUM(INT(H17:J17),INT(SUM(H17:J17-INT(H17:J17))/0.6),MOD(SUM(H17:J17-INT(H17:J17)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M17),D17<>\"\",F17<>\"\"),VLOOKUP(M17,IF(D17=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H17=\"X\",I17=\"X\",J17=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z17)>1,\"Doublon\",IF(OR(X17=\"A\",X17=\"D\"),\"\",   IF(AB17<>\"\",AB17,   IF(AND(D17<>\"F\",D17<>\"G\",D17<>\"M\",D17<>\"\"),\"Sexe Non Valide\",IF(AND(D17=\"\",M17<>\"\"),\" Sexe ?\",IF(OR(N(V17)<0,N(V17)>Max_Note3),\"Pb Note 3\",IF(OR(N(W17)<0,N(W17)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X17),COUNT(T17:W17)<4), \"Il manque \"& (4-COUNT(T17:W17)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 14",null,null,"",false,""]
[15,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G18),IF(ISERR(VALUE(F18)),RIGHT(F18,1),T(VLOOKUP(VALUE(F18),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G18)), RIGHT(G18,1), T( VLOOKUP(VALUE(G18),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H18:J18)=Nb_Courses,SUM(INT(H18:J18),INT(SUM(H18:J18-INT(H18:J18))/0.6),MOD(SUM(H18:J18-INT(H18:J18)),0.6)),\"\")","v":""},{"$f":"  IF(ISNUMBER(M18),  (Dist_Tot/(INT(M18)*0.6+(M18-INT(M18))))*0.0036,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M18),D18<>\"\",F18<>\"\"),VLOOKUP(M18,IF(D18=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H18=\"X\",I18=\"X\",J18=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z18)>1,\"Doublon\",IF(OR(X18=\"A\",X18=\"D\"),\"\",   IF(AB18<>\"\",AB18,   IF(AND(D18<>\"F\",D18<>\"G\",D18<>\"M\",D18<>\"\"),\"Sexe Non Valide\",IF(AND(D18=\"\",M18<>\"\"),\" Sexe ?\",IF(OR(N(V18)<0,N(V18)>Max_Note3),\"Pb Note 3\",IF(OR(N(W18)<0,N(W18)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X18),COUNT(T18:W18)<4), \"Il manque \"& (4-COUNT(T18:W18)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 15",null,null,"",false,""]
[16,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G19),IF(ISERR(VALUE(F19)),RIGHT(F19,1),T(VLOOKUP(VALUE(F19),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G19)), RIGHT(G19,1), T( VLOOKUP(VALUE(G19),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H19:J19)=Nb_Courses,SUM(INT(H19:J19),INT(SUM(H19:J19-INT(H19:J19))/0.6),MOD(SUM(H19:J19-INT(H19:J19)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M19),D19<>\"\",F19<>\"\"),VLOOKUP(M19,IF(D19=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H19=\"X\",I19=\"X\",J19=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z19)>1,\"Doublon\",IF(OR(X19=\"A\",X19=\"D\"),\"\",   IF(AB19<>\"\",AB19,   IF(AND(D19<>\"F\",D19<>\"G\",D19<>\"M\",D19<>\"\"),\"Sexe Non Valide\",IF(AND(D19=\"\",M19<>\"\"),\" Sexe ?\",IF(OR(N(V19)<0,N(V19)>Max_Note3),\"Pb Note 3\",IF(OR(N(W19)<0,N(W19)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X19),COUNT(T19:W19)<4), \"Il manque \"& (4-COUNT(T19:W19)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 16",null,null,"",false,""]
[17,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G20),IF(ISERR(VALUE(F20)),RIGHT(F20,1),T(VLOOKUP(VALUE(F20),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G20)), RIGHT(G20,1), T( VLOOKUP(VALUE(G20),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H20:J20)=Nb_Courses,SUM(INT(H20:J20),INT(SUM(H20:J20-INT(H20:J20))/0.6),MOD(SUM(H20:J20-INT(H20:J20)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M20),D20<>\"\",F20<>\"\"),VLOOKUP(M20,IF(D20=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H20=\"X\",I20=\"X\",J20=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z20)>1,\"Doublon\",IF(OR(X20=\"A\",X20=\"D\"),\"\",   IF(AB20<>\"\",AB20,   IF(AND(D20<>\"F\",D20<>\"G\",D20<>\"M\",D20<>\"\"),\"Sexe Non Valide\",IF(AND(D20=\"\",M20<>\"\"),\" Sexe ?\",IF(OR(N(V20)<0,N(V20)>Max_Note3),\"Pb Note 3\",IF(OR(N(W20)<0,N(W20)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X20),COUNT(T20:W20)<4), \"Il manque \"& (4-COUNT(T20:W20)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 17",null,null,"",false,{"$f":"IF(AL20,\" DOSSARD NON ATTRIBUE\",IF(COUNTIF(Dossard_Arrivée,Dossard_Arrivée)>1,\"Doublon\",IF(AND(Dossard_Arrivée<>\"\",Arrivee=\"\"),\"DOSSARD SANS TEMPS\",IF(AND(Dossard_Arrivée=\"\",Arrivee<>\"\"),\"TEMPS SANS DOSSARD\",\"\"))))","v":""}]
[18,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G21),IF(ISERR(VALUE(F21)),RIGHT(F21,1),T(VLOOKUP(VALUE(F21),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G21)), RIGHT(G21,1), T( VLOOKUP(VALUE(G21),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H21:J21)=Nb_Courses,SUM(INT(H21:J21),INT(SUM(H21:J21-INT(H21:J21))/0.6),MOD(SUM(H21:J21-INT(H21:J21)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M21),D21<>\"\",F21<>\"\"),VLOOKUP(M21,IF(D21=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H21=\"X\",I21=\"X\",J21=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z21)>1,\"Doublon\",IF(OR(X21=\"A\",X21=\"D\"),\"\",   IF(AB21<>\"\",AB21,   IF(AND(D21<>\"F\",D21<>\"G\",D21<>\"M\",D21<>\"\"),\"Sexe Non Valide\",IF(AND(D21=\"\",M21<>\"\"),\" Sexe ?\",IF(OR(N(V21)<0,N(V21)>Max_Note3),\"Pb Note 3\",IF(OR(N(W21)<0,N(W21)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X21),COUNT(T21:W21)<4), \"Il manque \"& (4-COUNT(T21:W21)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 18",null,null,"",false,""]
[19,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G22),IF(ISERR(VALUE(F22)),RIGHT(F22,1),T(VLOOKUP(VALUE(F22),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G22)), RIGHT(G22,1), T( VLOOKUP(VALUE(G22),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H22:J22)=Nb_Courses,SUM(INT(H22:J22),INT(SUM(H22:J22-INT(H22:J22))/0.6),MOD(SUM(H22:J22-INT(H22:J22)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M22),D22<>\"\",F22<>\"\"),VLOOKUP(M22,IF(D22=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H22=\"X\",I22=\"X\",J22=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z22)>1,\"Doublon\",IF(OR(X22=\"A\",X22=\"D\"),\"\",   IF(AB22<>\"\",AB22,   IF(AND(D22<>\"F\",D22<>\"G\",D22<>\"M\",D22<>\"\"),\"Sexe Non Valide\",IF(AND(D22=\"\",M22<>\"\"),\" Sexe ?\",IF(OR(N(V22)<0,N(V22)>Max_Note3),\"Pb Note 3\",IF(OR(N(W22)<0,N(W22)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X22),COUNT(T22:W22)<4), \"Il manque \"& (4-COUNT(T22:W22)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 19",null,null,"",false,""]
[20,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G23),IF(ISERR(VALUE(F23)),RIGHT(F23,1),T(VLOOKUP(VALUE(F23),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G23)), RIGHT(G23,1), T( VLOOKUP(VALUE(G23),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H23:J23)=Nb_Courses,SUM(INT(H23:J23),INT(SUM(H23:J23-INT(H23:J23))/0.6),MOD(SUM(H23:J23-INT(H23:J23)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M23),D23<>\"\",F23<>\"\"),VLOOKUP(M23,IF(D23=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H23=\"X\",I23=\"X\",J23=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z23)>1,\"Doublon\",IF(OR(X23=\"A\",X23=\"D\"),\"\",   IF(AB23<>\"\",AB23,   IF(AND(D23<>\"F\",D23<>\"G\",D23<>\"M\",D23<>\"\"),\"Sexe Non Valide\",IF(AND(D23=\"\",M23<>\"\"),\" Sexe ?\",IF(OR(N(V23)<0,N(V23)>Max_Note3),\"Pb Note 3\",IF(OR(N(W23)<0,N(W23)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X23),COUNT(T23:W23)<4), \"Il manque \"& (4-COUNT(T23:W23)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 20",null,null,"",false,""]
[21,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G24),IF(ISERR(VALUE(F24)),RIGHT(F24,1),T(VLOOKUP(VALUE(F24),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G24)), RIGHT(G24,1), T( VLOOKUP(VALUE(G24),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H24:J24)=Nb_Courses,SUM(INT(H24:J24),INT(SUM(H24:J24-INT(H24:J24))/0.6),MOD(SUM(H24:J24-INT(H24:J24)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M24),D24<>\"\",F24<>\"\"),VLOOKUP(M24,IF(D24=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H24=\"X\",I24=\"X\",J24=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z24)>1,\"Doublon\",IF(OR(X24=\"A\",X24=\"D\"),\"\",   IF(AB24<>\"\",AB24,   IF(AND(D24<>\"F\",D24<>\"G\",D24<>\"M\",D24<>\"\"),\"Sexe Non Valide\",IF(AND(D24=\"\",M24<>\"\"),\" Sexe ?\",IF(OR(N(V24)<0,N(V24)>Max_Note3),\"Pb Note 3\",IF(OR(N(W24)<0,N(W24)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X24),COUNT(T24:W24)<4), \"Il manque \"& (4-COUNT(T24:W24)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 21",null,null,"",false,""]
[22,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G25),IF(ISERR(VALUE(F25)),RIGHT(F25,1),T(VLOOKUP(VALUE(F25),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G25)), RIGHT(G25,1), T( VLOOKUP(VALUE(G25),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H25:J25)=Nb_Courses,SUM(INT(H25:J25),INT(SUM(H25:J25-INT(H25:J25))/0.6),MOD(SUM(H25:J25-INT(H25:J25)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M25),D25<>\"\",F25<>\"\"),VLOOKUP(M25,IF(D25=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H25=\"X\",I25=\"X\",J25=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z25)>1,\"Doublon\",IF(OR(X25=\"A\",X25=\"D\"),\"\",   IF(AB25<>\"\",AB25,   IF(AND(D25<>\"F\",D25<>\"G\",D25<>\"M\",D25<>\"\"),\"Sexe Non Valide\",IF(AND(D25=\"\",M25<>\"\"),\" Sexe ?\",IF(OR(N(V25)<0,N(V25)>Max_Note3),\"Pb Note 3\",IF(OR(N(W25)<0,N(W25)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X25),COUNT(T25:W25)<4), \"Il manque \"& (4-COUNT(T25:W25)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 22",null,null,"",false,""]
[23,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G26),IF(ISERR(VALUE(F26)),RIGHT(F26,1),T(VLOOKUP(VALUE(F26),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G26)), RIGHT(G26,1), T( VLOOKUP(VALUE(G26),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H26:J26)=Nb_Courses,SUM(INT(H26:J26),INT(SUM(H26:J26-INT(H26:J26))/0.6),MOD(SUM(H26:J26-INT(H26:J26)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M26),D26<>\"\",F26<>\"\"),VLOOKUP(M26,IF(D26=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H26=\"X\",I26=\"X\",J26=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z26)>1,\"Doublon\",IF(OR(X26=\"A\",X26=\"D\"),\"\",   IF(AB26<>\"\",AB26,   IF(AND(D26<>\"F\",D26<>\"G\",D26<>\"M\",D26<>\"\"),\"Sexe Non Valide\",IF(AND(D26=\"\",M26<>\"\"),\" Sexe ?\",IF(OR(N(V26)<0,N(V26)>Max_Note3),\"Pb Note 3\",IF(OR(N(W26)<0,N(W26)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X26),COUNT(T26:W26)<4), \"Il manque \"& (4-COUNT(T26:W26)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 23",null,null,"",false,""]
[24,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G27),IF(ISERR(VALUE(F27)),RIGHT(F27,1),T(VLOOKUP(VALUE(F27),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G27)), RIGHT(G27,1), T( VLOOKUP(VALUE(G27),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H27:J27)=Nb_Courses,SUM(INT(H27:J27),INT(SUM(H27:J27-INT(H27:J27))/0.6),MOD(SUM(H27:J27-INT(H27:J27)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M27),D27<>\"\",F27<>\"\"),VLOOKUP(M27,IF(D27=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H27=\"X\",I27=\"X\",J27=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z27)>1,\"Doublon\",IF(OR(X27=\"A\",X27=\"D\"),\"\",   IF(AB27<>\"\",AB27,   IF(AND(D27<>\"F\",D27<>\"G\",D27<>\"M\",D27<>\"\"),\"Sexe Non Valide\",IF(AND(D27=\"\",M27<>\"\"),\" Sexe ?\",IF(OR(N(V27)<0,N(V27)>Max_Note3),\"Pb Note 3\",IF(OR(N(W27)<0,N(W27)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X27),COUNT(T27:W27)<4), \"Il manque \"& (4-COUNT(T27:W27)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 24",null,null,"",false,""]
[25,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G28),IF(ISERR(VALUE(F28)),RIGHT(F28,1),T(VLOOKUP(VALUE(F28),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G28)), RIGHT(G28,1), T( VLOOKUP(VALUE(G28),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H28:J28)=Nb_Courses,SUM(INT(H28:J28),INT(SUM(H28:J28-INT(H28:J28))/0.6),MOD(SUM(H28:J28-INT(H28:J28)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M28),D28<>\"\",F28<>\"\"),VLOOKUP(M28,IF(D28=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H28=\"X\",I28=\"X\",J28=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z28)>1,\"Doublon\",IF(OR(X28=\"A\",X28=\"D\"),\"\",   IF(AB28<>\"\",AB28,   IF(AND(D28<>\"F\",D28<>\"G\",D28<>\"M\",D28<>\"\"),\"Sexe Non Valide\",IF(AND(D28=\"\",M28<>\"\"),\" Sexe ?\",IF(OR(N(V28)<0,N(V28)>Max_Note3),\"Pb Note 3\",IF(OR(N(W28)<0,N(W28)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X28),COUNT(T28:W28)<4), \"Il manque \"& (4-COUNT(T28:W28)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 25",null,null,"",false,""]
[26,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G29),IF(ISERR(VALUE(F29)),RIGHT(F29,1),T(VLOOKUP(VALUE(F29),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G29)), RIGHT(G29,1), T( VLOOKUP(VALUE(G29),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H29:J29)=Nb_Courses,SUM(INT(H29:J29),INT(SUM(H29:J29-INT(H29:J29))/0.6),MOD(SUM(H29:J29-INT(H29:J29)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M29),D29<>\"\",F29<>\"\"),VLOOKUP(M29,IF(D29=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H29=\"X\",I29=\"X\",J29=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z29)>1,\"Doublon\",IF(OR(X29=\"A\",X29=\"D\"),\"\",   IF(AB29<>\"\",AB29,   IF(AND(D29<>\"F\",D29<>\"G\",D29<>\"M\",D29<>\"\"),\"Sexe Non Valide\",IF(AND(D29=\"\",M29<>\"\"),\" Sexe ?\",IF(OR(N(V29)<0,N(V29)>Max_Note3),\"Pb Note 3\",IF(OR(N(W29)<0,N(W29)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X29),COUNT(T29:W29)<4), \"Il manque \"& (4-COUNT(T29:W29)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 26",null,null,"",false,""]
[27,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G30),IF(ISERR(VALUE(F30)),RIGHT(F30,1),T(VLOOKUP(VALUE(F30),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G30)), RIGHT(G30,1), T( VLOOKUP(VALUE(G30),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H30:J30)=Nb_Courses,SUM(INT(H30:J30),INT(SUM(H30:J30-INT(H30:J30))/0.6),MOD(SUM(H30:J30-INT(H30:J30)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M30),D30<>\"\",F30<>\"\"),VLOOKUP(M30,IF(D30=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H30=\"X\",I30=\"X\",J30=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z30)>1,\"Doublon\",IF(OR(X30=\"A\",X30=\"D\"),\"\",   IF(AB30<>\"\",AB30,   IF(AND(D30<>\"F\",D30<>\"G\",D30<>\"M\",D30<>\"\"),\"Sexe Non Valide\",IF(AND(D30=\"\",M30<>\"\"),\" Sexe ?\",IF(OR(N(V30)<0,N(V30)>Max_Note3),\"Pb Note 3\",IF(OR(N(W30)<0,N(W30)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X30),COUNT(T30:W30)<4), \"Il manque \"& (4-COUNT(T30:W30)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 27",null,null,"",false,""]
[28,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G31),IF(ISERR(VALUE(F31)),RIGHT(F31,1),T(VLOOKUP(VALUE(F31),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G31)), RIGHT(G31,1), T( VLOOKUP(VALUE(G31),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H31:J31)=Nb_Courses,SUM(INT(H31:J31),INT(SUM(H31:J31-INT(H31:J31))/0.6),MOD(SUM(H31:J31-INT(H31:J31)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M31),D31<>\"\",F31<>\"\"),VLOOKUP(M31,IF(D31=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H31=\"X\",I31=\"X\",J31=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z31)>1,\"Doublon\",IF(OR(X31=\"A\",X31=\"D\"),\"\",   IF(AB31<>\"\",AB31,   IF(AND(D31<>\"F\",D31<>\"G\",D31<>\"M\",D31<>\"\"),\"Sexe Non Valide\",IF(AND(D31=\"\",M31<>\"\"),\" Sexe ?\",IF(OR(N(V31)<0,N(V31)>Max_Note3),\"Pb Note 3\",IF(OR(N(W31)<0,N(W31)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X31),COUNT(T31:W31)<4), \"Il manque \"& (4-COUNT(T31:W31)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 28",null,null,"",false,""]
[29,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G32),IF(ISERR(VALUE(F32)),RIGHT(F32,1),T(VLOOKUP(VALUE(F32),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G32)), RIGHT(G32,1), T( VLOOKUP(VALUE(G32),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H32:J32)=Nb_Courses,SUM(INT(H32:J32),INT(SUM(H32:J32-INT(H32:J32))/0.6),MOD(SUM(H32:J32-INT(H32:J32)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M32),D32<>\"\",F32<>\"\"),VLOOKUP(M32,IF(D32=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H32=\"X\",I32=\"X\",J32=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z32)>1,\"Doublon\",IF(OR(X32=\"A\",X32=\"D\"),\"\",   IF(AB32<>\"\",AB32,   IF(AND(D32<>\"F\",D32<>\"G\",D32<>\"M\",D32<>\"\"),\"Sexe Non Valide\",IF(AND(D32=\"\",M32<>\"\"),\" Sexe ?\",IF(OR(N(V32)<0,N(V32)>Max_Note3),\"Pb Note 3\",IF(OR(N(W32)<0,N(W32)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X32),COUNT(T32:W32)<4), \"Il manque \"& (4-COUNT(T32:W32)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 29",null,null,"",false,""]
[30,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G33),IF(ISERR(VALUE(F33)),RIGHT(F33,1),T(VLOOKUP(VALUE(F33),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G33)), RIGHT(G33,1), T( VLOOKUP(VALUE(G33),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H33:J33)=Nb_Courses,SUM(INT(H33:J33),INT(SUM(H33:J33-INT(H33:J33))/0.6),MOD(SUM(H33:J33-INT(H33:J33)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M33),D33<>\"\",F33<>\"\"),VLOOKUP(M33,IF(D33=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H33=\"X\",I33=\"X\",J33=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z33)>1,\"Doublon\",IF(OR(X33=\"A\",X33=\"D\"),\"\",   IF(AB33<>\"\",AB33,   IF(AND(D33<>\"F\",D33<>\"G\",D33<>\"M\",D33<>\"\"),\"Sexe Non Valide\",IF(AND(D33=\"\",M33<>\"\"),\" Sexe ?\",IF(OR(N(V33)<0,N(V33)>Max_Note3),\"Pb Note 3\",IF(OR(N(W33)<0,N(W33)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X33),COUNT(T33:W33)<4), \"Il manque \"& (4-COUNT(T33:W33)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 30",null,null,"",false,""]
[31,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G34),IF(ISERR(VALUE(F34)),RIGHT(F34,1),T(VLOOKUP(VALUE(F34),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G34)), RIGHT(G34,1), T( VLOOKUP(VALUE(G34),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H34:J34)=Nb_Courses,SUM(INT(H34:J34),INT(SUM(H34:J34-INT(H34:J34))/0.6),MOD(SUM(H34:J34-INT(H34:J34)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M34),D34<>\"\",F34<>\"\"),VLOOKUP(M34,IF(D34=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H34=\"X\",I34=\"X\",J34=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z34)>1,\"Doublon\",IF(OR(X34=\"A\",X34=\"D\"),\"\",   IF(AB34<>\"\",AB34,   IF(AND(D34<>\"F\",D34<>\"G\",D34<>\"M\",D34<>\"\"),\"Sexe Non Valide\",IF(AND(D34=\"\",M34<>\"\"),\" Sexe ?\",IF(OR(N(V34)<0,N(V34)>Max_Note3),\"Pb Note 3\",IF(OR(N(W34)<0,N(W34)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X34),COUNT(T34:W34)<4), \"Il manque \"& (4-COUNT(T34:W34)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 31",null,null,"",false,""]
[32,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G35),IF(ISERR(VALUE(F35)),RIGHT(F35,1),T(VLOOKUP(VALUE(F35),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G35)), RIGHT(G35,1), T( VLOOKUP(VALUE(G35),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H35:J35)=Nb_Courses,SUM(INT(H35:J35),INT(SUM(H35:J35-INT(H35:J35))/0.6),MOD(SUM(H35:J35-INT(H35:J35)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M35),D35<>\"\",F35<>\"\"),VLOOKUP(M35,IF(D35=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H35=\"X\",I35=\"X\",J35=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z35)>1,\"Doublon\",IF(OR(X35=\"A\",X35=\"D\"),\"\",   IF(AB35<>\"\",AB35,   IF(AND(D35<>\"F\",D35<>\"G\",D35<>\"M\",D35<>\"\"),\"Sexe Non Valide\",IF(AND(D35=\"\",M35<>\"\"),\" Sexe ?\",IF(OR(N(V35)<0,N(V35)>Max_Note3),\"Pb Note 3\",IF(OR(N(W35)<0,N(W35)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X35),COUNT(T35:W35)<4), \"Il manque \"& (4-COUNT(T35:W35)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 32",null,null,"",false,""]
[33,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G36),IF(ISERR(VALUE(F36)),RIGHT(F36,1),T(VLOOKUP(VALUE(F36),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G36)), RIGHT(G36,1), T( VLOOKUP(VALUE(G36),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H36:J36)=Nb_Courses,SUM(INT(H36:J36),INT(SUM(H36:J36-INT(H36:J36))/0.6),MOD(SUM(H36:J36-INT(H36:J36)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M36),D36<>\"\",F36<>\"\"),VLOOKUP(M36,IF(D36=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H36=\"X\",I36=\"X\",J36=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z36)>1,\"Doublon\",IF(OR(X36=\"A\",X36=\"D\"),\"\",   IF(AB36<>\"\",AB36,   IF(AND(D36<>\"F\",D36<>\"G\",D36<>\"M\",D36<>\"\"),\"Sexe Non Valide\",IF(AND(D36=\"\",M36<>\"\"),\" Sexe ?\",IF(OR(N(V36)<0,N(V36)>Max_Note3),\"Pb Note 3\",IF(OR(N(W36)<0,N(W36)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X36),COUNT(T36:W36)<4), \"Il manque \"& (4-COUNT(T36:W36)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 33",null,null,"",false,""]
[34,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G37),IF(ISERR(VALUE(F37)),RIGHT(F37,1),T(VLOOKUP(VALUE(F37),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G37)), RIGHT(G37,1), T( VLOOKUP(VALUE(G37),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H37:J37)=Nb_Courses,SUM(INT(H37:J37),INT(SUM(H37:J37-INT(H37:J37))/0.6),MOD(SUM(H37:J37-INT(H37:J37)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M37),D37<>\"\",F37<>\"\"),VLOOKUP(M37,IF(D37=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H37=\"X\",I37=\"X\",J37=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z37)>1,\"Doublon\",IF(OR(X37=\"A\",X37=\"D\"),\"\",   IF(AB37<>\"\",AB37,   IF(AND(D37<>\"F\",D37<>\"G\",D37<>\"M\",D37<>\"\"),\"Sexe Non Valide\",IF(AND(D37=\"\",M37<>\"\"),\" Sexe ?\",IF(OR(N(V37)<0,N(V37)>Max_Note3),\"Pb Note 3\",IF(OR(N(W37)<0,N(W37)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X37),COUNT(T37:W37)<4), \"Il manque \"& (4-COUNT(T37:W37)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 34",null,null,"",false,""]
[35,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G38),IF(ISERR(VALUE(F38)),RIGHT(F38,1),T(VLOOKUP(VALUE(F38),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G38)), RIGHT(G38,1), T( VLOOKUP(VALUE(G38),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H38:J38)=Nb_Courses,SUM(INT(H38:J38),INT(SUM(H38:J38-INT(H38:J38))/0.6),MOD(SUM(H38:J38-INT(H38:J38)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M38),D38<>\"\",F38<>\"\"),VLOOKUP(M38,IF(D38=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H38=\"X\",I38=\"X\",J38=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z38)>1,\"Doublon\",IF(OR(X38=\"A\",X38=\"D\"),\"\",   IF(AB38<>\"\",AB38,   IF(AND(D38<>\"F\",D38<>\"G\",D38<>\"M\",D38<>\"\"),\"Sexe Non Valide\",IF(AND(D38=\"\",M38<>\"\"),\" Sexe ?\",IF(OR(N(V38)<0,N(V38)>Max_Note3),\"Pb Note 3\",IF(OR(N(W38)<0,N(W38)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X38),COUNT(T38:W38)<4), \"Il manque \"& (4-COUNT(T38:W38)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 35",null,null,"",false,""]
[36,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(G39),IF(ISERR(VALUE(F39)),RIGHT(F39,1),T(VLOOKUP(VALUE(F39),BAREME!$M$37:$O$45,3,FALSE))),IF(ISERR(VALUE(G39)), RIGHT(G39,1), T( VLOOKUP(VALUE(G39),BAREME!$M$37:$O$45,3,FALSE))))","v":""},{"$f":"IF(COUNT(H39:J39)=Nb_Courses,SUM(INT(H39:J39),INT(SUM(H39:J39-INT(H39:J39))/0.6),MOD(SUM(H39:J39-INT(H39:J39)),0.6)),\"\")","v":""},"",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M39),D39<>\"\",F39<>\"\"),VLOOKUP(M39,IF(D39=\"F\",Bareme_F,Bareme_G),Decal),IF(OR(H39=\"X\",I39=\"X\",J39=\"X\"),0,\"\"))","v":""},null,"","","","",null,{"$f":"IFERROR(IF(COUNTIF(Dossard,Z39)>1,\"Doublon\",IF(OR(X39=\"A\",X39=\"D\"),\"\",   IF(AB39<>\"\",AB39,   IF(AND(D39<>\"F\",D39<>\"G\",D39<>\"M\",D39<>\"\"),\"Sexe Non Valide\",IF(AND(D39=\"\",M39<>\"\"),\" Sexe ?\",IF(OR(N(V39)<0,N(V39)>Max_Note3),\"Pb Note 3\",IF(OR(N(W39)<0,N(W39)>Max_Note4),\"Pb Note 4\",IF(AND(ISNUMBER(X39),COUNT(T39:W39)<4), \"Il manque \"& (4-COUNT(T39:W39)) & \" note(s)\",\"\")))))))), \"\")","v":""},"",null,null,null,null,null,"Tps 36",null,null,"",false,""]

{"sheet":"Histo","index":3,"n_rows":143,"n_cols":35,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"HISTORIQUE",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,3.0092592592592671E-4]
[]
[]
[]
["V3,0","2021-05-10","Version de Diffusion"]
[null,null,"Mise à jour de la page AIDE"]
[null,null,"Suppression du Multi-classes"]
[null,null,"Bouton Classe dans Bareme avec mise à jour  macro pour changement automatique du nom de la plaque en fonction de la classe "]
[null,null,"Matrice nommée dans rechercheV pour note AFLP 3 & 4"]
[null,null,"Correction erreur ref macro pour les fleches haut bas du bloc Degré AFLP1"]
[null,null,"Correction del formule nommée  Rap_AFLP3_4 pour tenir compte du numero de ligne de la valeur recherchée en utilisant index et ligne-3 pour decalage ligne physique et tableau"]
[]
["V2.11","2021-05-09","Dans Chronometrage = Transfere_Resultats  calcul de la derniere colonne de perf en fonction de la variable nommée Nb_Courses  et ajustement du MESSAGE d'ERREUR"]
[null,null,"Suppression des formules et masquage des colonnes inutiles sans suppression pour éviter erreur de ref dans VBA"]
[null,null,"Ajustement des contôles d'erreur et messages d'erreur"]
[null,null,"Afficher masquer les colonnes de Perf en fonction de Nb_Courses"]
[null,null,"Correction formule Note4"]
[null,null,"VBA gestion des macros d'effacement"]
[]
["V2.10","2021-05-09","Mise en page tableau Classe suppression des anciennes  colonnes profile de course"]
[null,null,"Changement du nom de la macro de choix du degré d'AFLP1 car conflit avec le nom definit de la liste de choix (Nom identique)"]
[null,null,"Gestion des differents worsheetChange dans \"Bareme\""]
[null,null,"Restriction de validation de données pour le rapport entre AFLP 3&4 il n'y a plus de valeur numerique simple"]
[]
["V2.9","2021-05-08","Mise en page de l onglet  Bareme"]
[null,null,"Allongement de la longueur du tableau Note AFLP2 pour personnalisation"]
[]
["V2.8","2021-04-25","Possibilité d Evaluation préalable  par degré AFLP3&4 Option à cocher dans Bareme"]
[null,null," => mise au format texte des colonnes Degré AFLP3 & Degré ALP 4 pour éviter les erreurs lors de la saisie  des valeurs simples 1/2/3/4 et rechercheV valeur EXACTE pour éviter problème d'ordre non croissant  1-/1/1+  "]
[null,null,"Dans Bareme  bouton \" Modifier\" et mise à jour automatique de la date du Bareme  "]
[]
["V2.7","2021-03-09","NOUVEAU CAP"]
[null,null,"Dans bareme  : Dist_Tot=somme des 3 courses et  Nb_Courses de 1 à 3"]
[null,null,"Cacul de la Vitesse en fonction du Nb_Courses et Dist_Tot"]
[null,null,"Titre course = course 1 /2 /3"]
[null,null,"Barre \"Grp Proje\"t devient \"Degre AFLP1\"  => Sub projet devient Degré_AFLP1 &  sub Affich_Masq_Projet = Affich_Masq_Degre_AFLP1"]
[null,null,"Note CAP = somme de 4 notes"]
[null,null,"Colonne F =   Degré  AFLP 1"]
[null,null,"Note AFLP1 defini dans le bareme tableau Nomagramme en fonction du temps cumulé et du degré AFLP1"]
[null,null,"Création Bareme2 Bareme4 Bareme6 pour les notes 3 & 4"]
[null,null,"Liste notes AFLP2"]
[null,null,"TEMPS MAX = variable definie dans BAREME pour  la formule de validation de donnée  PERF"]
[]
["V2.6a","2019-06-19","Modification de la Validation de donnée de  Projet régulé pour interdire saisie si pas de projet initial  ( Oublie / Versions 2.6 BAC et BAC PRO)"]
[]
["V2.6","2018-12-17","Ajout  d'un Visuel permanent des projets "]
[null,null,"Supression des Boutons activeX et deplacement des boutons de l'interface Chrono"]
[null,null,"NOTE Prepa_Recup => Nom dans BAREME => Validation de données par Formule car n'accepte pas les Nom dans Valeurs Min / Max"]
[null,null,"Mise à jour Alerte depuis Bac pro V2.6 avec Integration Prepa_Recup comme Constante modifiable dans BAREME"]
[null,null,"Ajout d'un Zoom automatique Desactivable dans les REGLAGES"]
[null,null,"MAJ de la page AIDE"]
[null,null,"Code de protection pour diffusion  en  Evaluation Certificative"]
[]
["V2.5","2018-11-29","Version de diffusion = Code transféré dans les version BAC & BAC Pro"]
[null,null,"Version testée et fonctionnelle sous MAC  & Excel 2016 dans les modes 3- 4 -5"]
[null,null,"Message dAlerte si Mode  Chrono 1 et 2 incompatible avec MAC => Sortie de la boucle sans Bug"]
[null,null,"Nettoyage du code  et Blocage des évenements à l'initialisation  Mise en rem  localisation Bouton activex TOP  pb avec MAC"]
[null,null,"Mode chrono 5 mode dans BAREME"]
[null,null,"MAJ page menu et AIDE cf 2.4 I"]
[null,null,"Validation des données sur  500m pour interdire decimale >59 en cas de saisie mauelle"]
[null,null,"Mise forme conditionnelle pour signaler decimale >59 si integration des temps par copier coller qui passe outre la validation de données "]
[null,null,"Simplification Formule Ecart 2  (Q) suite au projet en une seule cellule => comparaison avec  K & L"]
[null,null,"Reprise de la formule Note projet pour accepter résultat partiel en cas d'abandon  Si que course 1 la note apparait mais pas si les 3 courses sont faites sans remplir la case projet C1=>Alerte"]
[null,null,"Reprise de la formule du decompte \"Projets Reussits\" la note s'affiche à partir d'un seul projet comptabilisé (C1 C2 & Abandon)"]
[null,null,"Ecart Pojet C1 formule modifiée pour differencier Pas de course = case vide \"\" et Course realisée sans déclarer projet => \"?\""]
[null,null,"EVALUATION PARTIELLLE la note CAP apparait mais sur fond rouge avec en alerte le nombre de notes manquantes ou Projet non défini"]
[null,null,"Alerte => nouveau message pour signaler le nombre de notes Manquantes"]
[null,null,"Module Projet MAJ dans l'Ordre du Référentiel BAC"]
[null,null,"Ajout colonne Commentaires et Bouton  \"Effacement commmentaires\""]
[]
["V2.4I","2018-11-24","Exclusion de la souris en mode clavier"]
[null,null,"Mise à  jour de l'AIDE"]
[null,null,"Mise à jour de la page MENU pb  de protection des cellule activeés par boutons"]
[]
["V2.4 H","2018-11-17","Note Echauffement paramettrable dans Bareme => correction erreur CAP / BAC Pro 3pts au lieu de 2"]
[null,null,"Modification de la variable temps Affiche de single en double car erreur d'arrondi dans le tableau "]
[null,null,"Dedoublement desModes Win Et Compatibles pour gestion de la  Souris = Chrono à distance par clic Droit  En masquant les boutons pour éviter la  perte de clic"]
[null,null,"5 eme Mode  Chrono compatible avec gros bouton 1/2 ecran pour Clic Gauche souris = Chrono à distance"]
[null,null,"Attribution d'un Nom Explicite pour tous les boutons pour traitemernt des fonctions en boucle avec variable"]
[null,null,"Creation Module Saisie Projet par Boutons"]
[null,null,"Plein ecran dans toutes les modes chrono"]
[null,null,"bloquer le clic droit en mode Standard pendant le chronometrage  car Pb  sur 1er clic focus sur le cadre de la cellule  => pas de reaction  2eme Clic "]
[]
["V2.4g ","2018-11-08","Retour des Boutons Standards plus reactifs en mode compatible"]
[null,null,"2 Modes de Chrono   Standard et compatible Mac"]
[null,null,"Locallisation du Bouton Arrivee à Gauche / Centre /Droite de l'écran"]
[null,null,null,null,null,null,null,null,null,null,null,"En mode Windows le clic droit n'est pas asseez reactif mais pas de pb sii survol du bouton donc à verifier"]
["V2.4f","2018-11-04","Modification des boutons Arrivee et Fin en CommandButton pour contrôle clic droit"]
[null,null,"Dans Bareme  choix de la Position Variable du Bouton Arrivée Gauche / Centre / Droite pour écran tactile"]
[]
["V2.4e","2018-11-02","Chrono gestion clavier ou Clic Droit => Integrationn d'un Mode compatible pour les version Mac 2016"]
[null,null,"Choix du mode de Chronometrage  dans la page Bareme"]
[]
["V2.4d","2018-10-28","Correction Formule \" Gauche Projet\" => ref directe au Bareme"]
[null,null,"Correction  message info  dans Validation donnée Projet 2 => Ordre different CAP/BAC"]
[null,null,"Correction revalidation du menu contextuel  dans arrêt chrono"]
[null,null,"Note projet C1 devient une Variable dans Bareme  Note_C1 dans note projet => valeur 0 pour bac Pro et CAP"]
[null,null,"Chrono: Ajout de la gestion par Clavier  Bas / Esc et Souris  Clic Droit"]
[null,null,"Test sous Android Fonctionne avec Excel Android  mais pas les boutons de changement de page"]
[null,null,"Mise à jour page d'AIDE et des entêtes de tableau dans les classes"]
[]
["V2.4c","2018-10-26","Gestion du clavier par API sous 64 bit "]
[]
["V2.4b","2018-10-15","Mise à jour de la page d'Aide "]
[null,null,"Alignement des numeros de version avec le fichier BAC"]
[]
["V2.3d","2018-10-11","Correction Macro Exportation (décalage colonne) "]
[null,null,"Modification signal d'alerte nouvelle gestion des doublons dans transfere)"]
[null,null,"Modification signal d'alerte  (ôter erreur projet C1 car non concerné)"]
[null,null,"Implementation non activée de l' action clavier pour le Chrono  "]
[null,null,"Modification de l'ordre des Stratégies en lien avec le Referentiel CAP <> BAC"]
[]
["V2.3c","2018-10-04","Equivalent à V2,4  BAC Gal"]
[null,null,"A l'ouverture des macros Contrôle des noms d'Onglet & Boutons du Menu  en fonction des Noms de Classe (nv algorithme)"]
[]
["V2.3a","2018-10-03","Transfere du Bareme CAP sur la structure 2.4 BAC - Colonnes inutiles masquée mais Note projet C1 maintenue dans l'équation => =0"]
[]
["V2.3","2016-09-29","Ajout de la macro  pour changer le sens de déplacement"]
[null,null,"Ajustement des macros d'effacement  après modification de l'ordre des colonnes"]
[null,null,"Gestion protection par mot de passe"]
[]
["V2.2C","2018-09-26","Modification du texte d'aide dans MENU "]
[null,null,"Modificatin de  la zone Classe dans chaque page"]
[]
["V2.2b","2018-09-25","Reprise des équations pour Valider les Items acquis avant abandon"]
[null,null,"Ajustement des priorités d'Alerte"]
[]
["V2.2a","2018-09-24","Augmentation du nombre d' Alertes Gérées"]
[]
["V2.2","2018-09-16","Modification de la selection liste de stratégie"]
[]
["V2.1","2018-05-13","Bareme  MARS 2018 avec comparaison de la course 3 avec la course 1 en cas de choix de 2 courses identiques  = ="]
[null,null,"Modification du bareme de la note de projet   0-1-1,5-2-3  ou lieu de 0-1-2-2,5-3"]
[null,null,"Creation de l'Historique"]
[]
["V2.0","2018-03-11","Bareme  Mars 2018  / Contrôle de la note d'echauffement  saisie manuellement"]
[]
["V1.1","Fev 2018","Chrono Compatible PC et MAC "]
[null,null,"Introduction d'une variable \"Tolerence\" Parametrable  dans la partie bareme pour le choix de 2 courses identiques => Valeur initiale selon texte officiel 3 secondes"]
[]
["v1.0","2018-02-27","Bareme sur base des textes 2016"]
[null,null,"Chronometre  compatible PC mais pb sous MAC"]