{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["accueil","options","résultats","le_cycle","graph","groupes de travail","Note défis","barème défis"],"not_rendered":{"charts":42,"images":1,"macros":1,"external_links":1,"defined_names":38,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"options","index":1,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,9,4,20],[0,9,0,19],[0,20,2,20],[1,10,1,14],[1,15,1,19]]}
[null,null,null,null,null,null,null,null,null,"VOUS AVEZ GAGNE UN ADVERSAIRE CLASSE",null,null,null,null,null,null,null,null,null,null,"VOUS AVEZ PERDU LE MATCH"]
[null,null,null,null,null,null,null,null,null,null,"AU DESSUS DE VOUS",null,null,null,null,"EN DESSOUS DE VOUS"]
[null,null,null,null,null,null,null,null,null,"Nombre de places d'écart",5,4,3,2,1,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,"Points",6,5,5,5,4,4,3,3,3,2,1]
[null,null,null,null,null,null,null,null,null,"Les références sont relatives. \nVous pouvez attribuerer le nombre de points que vous souhaitez"]

{"sheet":"résultats","index":2,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,23,0,27],[1,23,2,23],[1,24,1,25],[1,26,1,27],[0,14,0,15],[0,16,0,18],[9,12,10,12],[9,16,10,16],[5,13,5,14],[2,13,3,14],[0,0,0,8],[0,10,0,11]]}
["ATP Tournoi",null,null,null,null,null,null,null,null,null,"Nbre de joueurs",null,6]
["Classt ProvisR","Rang pour la séance","Noms et Prénoms","Points","Points marqués / séance","Nombre de matches joués","Nombre de matches arbitrés","Goal average","N° d'ordre",null,null,null,null,"Effacer        le tableau"]
[{"$f":"RANK(D3,liste,0)","v":1},1,"F",11,0,0,0,11,1,null,null,null,null,"BAT"]
[2,2,"A",6,0,0,0,0,2]
[2,2,"B",6,0,0,0,-7,3]
[4,4,"C",4,0,0,0,0,4,null,null,null,"N° d'ordre","         ARBITRAGE",null,null,"N° d'ordre"]
[4,4,"D",4,0,0,0,-4,5,null,null,null,6,null,null,null,4]
[6,6,"E",2,0,0,0,0,6]
[null,null,null,null,null,null,null,null,null,null,null,null,"Points",null,null,null,"Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]

{"sheet":"le_cycle","index":3,"n_rows":20,"n_cols":78,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,73,0,74],[0,75,0,76],[0,77,1,77],[0,70,0,72],[0,39,0,41],[0,59,0,60],[0,54,0,56],[0,42,0,44],[0,48,0,50],[0,51,0,53],[19,63,19,67],[0,57,0,58],[18,63,18,67],[0,61,1,61],[0,33,0,35],[0,45,0,47],[0,27,0,29],[0,30,0,32],[17,63,17,67],[16,63,16,68],[0,36,0,38],[0,24,0,26],[0,0,0,2],[0,6,0,8],[0,12,0,14],[0,18,0,20],[0,3,0,5],[0,15,0,17],[0,9,0,11],[0,21,0,23]]}
["SEANCE 1",null,null,"Date : 03/04/2012 08:59:47",null,null,"SEANCE 2",null,null,null,null,null,"SEANCE 3",null,null,null,null,null,"SEANCE 4",null,null,null,null,null,"SEANCE 5",null,null,null,null,null,"SEANCE 6",null,null,null,null,null,"SEANCE 7",null,null,null,null,null,"SEANCE 8",null,null,null,null,null,"SEANCE 9",null,null,null,null,null,"SYNTHESE",null,null,"Matches joués",null,"Matches arbitrés",null,"Indice final des points marqués",null,null,null,null,null,null,null,null,null,null,null,"Matches joués",null,"Matches arbitrés",null,"Indice final des points marqués"]
["Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués /séance","Matchs joués","Matchs arbitrés","Indice pts par matchs","Rang","Noms et prénoms","Points marqués / séance","Par l'élève","Ecart par rapport à l'indice","Par l'élève","Ecart par rapport à l'indice",null,null,null,null,null,null,null,null,null,"Rang","Noms et prénoms","Points marqués / séance","Par l'élève","Ecart par rapport à l'indice","Par l'élève","Ecart par rapport à l'indice"]
[2,"A",0,0,1,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"A",0,0,-0.33333333333333331,1,0.66666666666666674,0,null,null,null,null,null,null,null,null,1,"F",10,2,1.6666666666666667,0,-0.33333333333333331,5]
[2,"B",1,1,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"B",1,1,0.66666666666666674,0,-0.33333333333333331,1,null,null,null,null,null,null,null,null,2,"A",0,0,-0.33333333333333331,1,0.66666666666666674,0]
[4,"C",0,0,1,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"C",0,0,-0.33333333333333331,1,0.66666666666666674,0,null,null,null,null,null,null,null,null,2,"B",1,1,0.66666666666666674,0,-0.33333333333333331,1]
[4,"D",1,1,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"D",1,1,0.66666666666666674,0,-0.33333333333333331,1,null,null,null,null,null,null,null,null,4,"C",0,0,-0.33333333333333331,1,0.66666666666666674,0]
[6,"E",0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"E",0,0,-0.33333333333333331,0,-0.33333333333333331,0,null,null,null,null,null,null,null,null,4,"D",1,1,0.66666666666666674,0,-0.33333333333333331,1]
[1,"F",10,2,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"F",10,2,1.6666666666666667,0,-0.33333333333333331,5,null,null,null,null,null,null,null,null,6,"E",0,0,-0.33333333333333331,0,-0.33333333333333331,0]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,"RECAPITLATIF DE LA CLASSE"]
[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,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,"Nombre total de matchs joués",null,null,null,null,4]
[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,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,"Indice du nombre de matchs joués par chaque élève",null,null,null,null,0.33333333333333331]
[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,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,"Indice du nombre de matchs arbitrés par chaque élève",null,null,null,null,0.33333333333333331]

{"sheet":"graph","index":4,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["TABLEAU DES INDICES DE POINTS MARQUES PAR MATCHES"]
["Noms Prénoms","Séance 1","Séance 2","Séance 3","Séance 4","Séance 5","Séance 6","Séance 7","Séance 8","Séance 9"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"groupes de travail","index":5,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["FORMATION DES GROUPES DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,"Nombre d'élèves par groupe",null,null,"Il est possible d'ajouter des groupes de travail"]
["GROUPE 1","GROUPE 2","GROUPE 3","GROUPE 4","GROUPE 5","GROUPE 6","GROUPE 7","GROUPE 8"]

{"sheet":"Note défis","index":6,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,0,44,2]]}
["Prénom","nbre défis joués","note                 / 6 points","nbre défis          arbitrés","note                 / 6 points","classement initial (place)","classement final   (place)","points progression   /4 points","note classement   / 4 points","Note / 20"]
[null,null,{"$f":"IF(B2=\"\",\"\",(VLOOKUP(B2,Nbre_défis_joués___arbitrés,2,TRUE)))","v":""},null,{"$f":"IF(D2=\"\",\"\",(VLOOKUP(D2,Nbre_défis_joués___arbitrés,2,TRUE)))","v":""},null,null,{"$f":"IF(F2=\"\",\"\",IF(F2=0,0,IF(F2>G2,4,IF(F2=G2,3,IF(F2<G2,2)))))","v":""},{"$f":"IF(H2=\"\",\"\",(VLOOKUP(G2,classement_fin,2,TRUE)))","v":""},{"$f":"IF(H2=\"\",\"\",SUM(C2,E2,H2,I2))","v":""}]
[null,null,"",null,"",null,null,{"$f":"IF(F3=\"\",\"\",IF(F3=0,0,IF(F3>G3,4,IF(F3=G3,3,IF(F3<G3,2)))))","v":""},{"$f":"IF(H3=\"\",\"\",(VLOOKUP(G3,classement_fin,2,TRUE)))","v":""},{"$f":"IF(H3=\"\",\"\",SUM(C3,E3,H3,I3))","v":""}]
[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,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,"",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,"",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,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,"","",""]
[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,"moyenne:",{"$f":"IF(J2=\"\",\"\",AVERAGE(J2:J41))","v":""}]
[null,null,null,null,null,null,null,null,"note max:",{"$f":"IF(J2=\"\",\"\",MAX(J2:J41))","v":""}]
[null,null,null,null,null,null,null,null,"note min:",{"$f":"IF(J2=\"\",\"\",MIN(J2:J41))","v":""}]

{"sheet":"barème défis","index":7,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Nbre défis joués / arbitrés"," points attribués",null,"classement","points attribués"]
[null,0,0,null,0,0]
[null,1,0.5,null,1,5]
[null,2,1,null,2,4.5]
[null,4,1.5,null,5,4]
[null,6,2,null,9,3.5]
[null,8,2.5,null,12,3]
[null,10,3,null,15,2.5]
[null,12,3.5,null,19,2]
[null,14,4,null,22,1.5]
[null,16,4.5,null,30,1]
[null,18,5]
[null,20,5.5]
[null,22,6]