{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Accueil","Variation","Résumé Variation","Feedback","Rupture","Résumé Rupture","Feedback 2","Table de score","Liste élèves"],"not_rendered":{"charts":6,"images":12,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Variation","index":1,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,1,28,2],[36,1,39,2],[0,6,0,9],[0,13,0,15],[5,8,5,10],[25,10,25,11],[29,14,29,16],[26,5,26,6],[26,10,26,11],[26,14,26,16],[27,5,27,6],[27,10,27,11],[28,5,28,6],[28,10,28,11],[29,1,29,3],[29,5,29,6],[29,10,29,11],[30,5,30,6],[30,10,30,11],[8,23,8,24],[27,15,28,15],[36,15,38,15],[31,10,31,11],[32,5,35,6],[32,9,35,10],[32,7,35,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paramétrage Enseignant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type de Bonus","Valeur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valorisation Zone centrale",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valorisation CD",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valorisation Revers",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multizone",100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Couloir central",null,null,null,null,"Couloir central"]
[null,null,null,null,null,"Couloir gauche",null,null,null,null,"Couloir droit"]
[null,null,null,null,null,"Couloir droit",null,null,null,null,"Couloir gauche"]
[null,null,null,null,null,"Bonus",null,null,null,null,"Bonus"]
[null,null,null,null,null,"Bonus Final",null,null,null,null,"Bonus Final"]
[]
[null,null,null,null,null,"Score",null,{"$f":" SUM(H27:H29)+(H30*B28)+(H31*B37)","v":0},null,{"$f":"SUM(M27:M29)+(M30*P28)+(M31*P37)","v":0}]
[]
[]
[]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Résumé Variation","index":2,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,9,0,11],[2,4,2,6],[3,0,3,2],[21,0,22,1],[21,9,22,10],[2,8,2,9],[34,0,36,4],[34,10,36,14],[33,0,33,4],[33,10,33,14],[23,0,24,1],[23,9,24,10],[31,0,31,4],[31,10,31,14],[32,0,32,4],[32,10,32,14]]}
[null,null,{"$f":"Variation!G1","v":0},null,null,null,null,null,null,{"$f":"Variation!N1","v":0}]
[]
[null,null,null,null,"Score",null,null,null,{"$f":"Variation!H33","v":0},null,{"$f":"Variation!J33","v":0}]
[]
["Couloir droit","Couloir gauche","Zone centrale","Bonus","Bonus final",null,null,null,null,null,"Couloir droit","Couloir gauche","Zone centrale","Bonus","Bonus final"]
[{"$f":"Variation!H29","v":0},{"$f":"Variation!H28","v":0},{"$f":"Variation!H27","v":0},{"$f":"Variation!H30","v":0},{"$f":"Variation!H31","v":0},null,null,null,null,null,{"$f":"Variation!M28","v":0},{"$f":"Variation!M29","v":0},{"$f":"Variation!M27","v":0},{"$f":"Variation!$M$30","v":0},{"$f":"Variation!M31","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BILAN DE L'OBSERVATION :",null,null,null,null,null,null,null,null,null,"BILAN DE L'OBSERVATION :"]
[{"$f":"IF(AND(A6>=2, B6>=2, C6>=2), Feedback!B3,Feedback!B2)","v":"ZONE DE JEU REDUITE - PRIVILEGIER UN BONUS SIMPLE"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K6>=2,L6>=2,M6>=2),Feedback!C3,Feedback!C2)","v":"ZONE DE JEU REDUITE - PRIVILEGIER UN BONUS SIMPLE"}]
[{"$f":"IF(D6<3,Feedback!B4,Feedback!B5)","v":"CHOIX DE BONUS A REVOIR"},null,null,null,null,null,null,null,null,null,{"$f":"IF(N6<3,Feedback!C4,Feedback!C5)","v":"CHOIX DE BONUS A REVOIR"}]
[{"$f":" IF(E6=0,Feedback!B6,Feedback!B7)","v":"Persiste ou choisi un bonus plus adapté"},null,null,null,null,null,null,null,null,null,{"$f":" IF(O6=0,Feedback!C6,Feedback!C7)","v":"Persiste ou choisi un bonus plus adapté"}]

{"sheet":"Feedback","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Joueur 1","Joueur 2"]
["Prédominance d'une zone","ZONE DE JEU REDUITE - PRIVILEGIER UN BONUS SIMPLE","ZONE DE JEU REDUITE - PRIVILEGIER UN BONUS SIMPLE"]
["Variation largeur","BIEN - TU FAIS BOUGER TON ADVERSAIRE - PRIVILEGIER LE BONUS FINAL","BIEN - TU FAIS BOUGER TON ADVERSAIRE - PRIVILEGIER LE BONUS FINAL"]
["Bonus<3","CHOIX DE BONUS A REVOIR","CHOIX DE BONUS A REVOIR"]
["Bonus >3","BON CHOIX DE BONUS - ATTENTION L'ADVERSAIRE VA PEUT ETRE S'ADAPTER","BON CHOIX DE BONUS - ATTENTION L'ADVERSAIRE VA PEUT ETRE S'ADAPTER"]
["Bonus final 0","Persiste ou choisi un bonus plus adapté","Persiste ou choisi un bonus plus adapté"]
["Bonus final 1","Bon choix de Bonus, tu peux essayer de complexifier","Bon choix de Bonus, tu peux essayer de complexifier"]

{"sheet":"Rupture","index":4,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[[42,3,43,4],[13,22,13,23],[50,7,50,9],[51,7,52,9],[51,10,52,10],[51,11,52,11],[46,7,47,9],[46,10,47,10],[46,11,47,11],[48,7,49,9],[48,10,49,10],[48,11,49,11],[38,11,39,12],[38,13,39,14],[38,15,39,16],[40,11,41,12],[40,13,41,14],[40,15,41,16],[34,11,35,12],[34,13,35,14],[34,15,35,16],[36,11,37,12],[36,13,37,14],[36,15,37,16],[30,11,31,12],[30,13,31,14],[30,15,31,16],[32,11,33,12],[32,13,33,14],[32,15,33,16],[27,11,27,12],[27,13,27,14],[27,15,27,16],[28,11,29,12],[28,13,29,14],[28,15,29,16],[38,3,39,4],[40,5,41,6],[28,7,29,8],[30,7,31,8],[32,7,33,8],[34,7,35,8],[36,7,37,8],[38,7,39,8],[40,7,41,8],[30,5,31,6],[32,5,33,6],[34,5,35,6],[36,5,37,6],[38,5,39,6],[11,6,13,8],[11,11,13,13],[49,15,50,16],[56,15,59,16],[58,2,61,3],[50,2,51,3],[40,3,41,4],[27,3,27,4],[27,5,27,6],[27,7,27,8],[28,3,29,4],[28,5,29,6],[30,3,31,4],[32,3,33,4],[34,3,35,4],[36,3,37,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Achile",null,null,null,null,"Talon"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paramétrage Enseignant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type de Bonus","Valeur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus 1",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus 2",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus 3",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus Régularité",100]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Echanges",null,"Nombre",null,"%",null,null,null,"Echanges",null,"Nombre",null,"%"]
[null,null,null,1,null,null,null,{"$f":"IF($K$47=0,0,(F29*100)/$K$47)","v":0},null,null,null,1,null,null,null,{"$f":"IF($L$47=0,0,(N29*100)/$L$47)","v":0}]
[]
[null,null,null,2,null,null,null,{"$f":"IF($K$47=0,0,(F31*100)/$K$47)","v":0},null,null,null,2,null,null,null,{"$f":"IF($L$47=0,0,(N31*100)/$L$47)","v":0}]
[]
[null,null,null,3,null,null,null,{"$f":"IF($K$47=0,0,(F33*100)/$K$47)","v":0},null,null,null,3,null,null,null,{"$f":"IF($L$47=0,0,(N33*100)/$L$47)","v":0}]
[]
[null,null,null,4,null,null,null,{"$f":"IF($K$47=0,0,(F35*100)/$K$47)","v":0},null,null,null,4,null,null,null,{"$f":"IF($L$47=0,0,(N35*100)/$L$47)","v":0}]
[]
[null,null,null,5,null,null,null,{"$f":"IF($K$47=0,0,(F37*100)/$K$47)","v":0},null,null,null,5,null,null,null,{"$f":"IF($L$47=0,0,(N37*100)/$L$47)","v":0}]
[]
[null,null,null,6,null,null,null,{"$f":"IF($K$47=0,0,(F39*100)/$K$47)","v":0},null,null,null,6,null,null,null,{"$f":"IF($L$47=0,0,(N39*100)/$L$47)","v":0}]
[]
[null,null,null,"7 et +",null,null,null,{"$f":"IF($K$47=0,0,(F41*100)/$K$47)","v":0},null,null,null,"7 et +",null,null,null,{"$f":"IF($L$47=0,0,(N41*100)/$L$47)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Score",null,null,{"$f":"SUM(F29:G42)","v":0},{"$f":"SUM(N29:O42)","v":0}]
[]
[null,null,null,null,null,null,null,"Nombre bonus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,10,null,null,null,null,"Régularité"]
[null,null,null,null,null,null,null,"Score final",null,null,{"$f":"K47+(K49*C51)+(K51*C59)","v":0},{"$f":"L47+(L49*P50)+(L51*P57)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[]
[null,null,0]

{"sheet":"Résumé Rupture","index":5,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,0,19,1],[20,0,20,1],[21,0,21,1],[7,20,10,21],[7,17,10,19],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[9,7,11,9],[9,12,11,14],[7,0,10,1],[7,2,10,3],[15,2,15,3],[16,2,16,3],[18,2,18,3],[17,2,17,3],[19,2,19,3],[14,17,14,18],[17,17,17,18],[14,2,14,3],[14,19,14,20],[15,17,15,18],[15,19,15,20],[16,17,16,18],[16,19,16,20],[17,19,17,20],[18,17,18,18],[18,19,18,20],[19,17,19,18],[19,19,19,20],[20,17,20,18],[20,19,20,20],[21,17,21,18],[21,19,21,20],[25,0,27,1],[20,2,20,3],[21,2,21,3],[29,0,31,1],[25,2,27,3],[29,2,31,3],[25,17,27,18],[25,19,27,20],[29,17,31,18],[29,19,31,20],[35,1,35,8],[36,1,36,8],[37,1,37,8],[35,11,35,18],[36,11,36,18],[37,11,37,18]]}
[]
[]
[]
[]
[]
[]
[]
["Score",null,{"$f":"Rupture!K52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,{"$f":"Rupture!L52","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"Rupture!$G$12","v":"Achile"},null,null,null,null,{"$f":"Rupture!$L$12","v":"Talon"}]
[]
[]
[]
[]
["Echanges",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Echanges",null,"%"]
[1,null,{"$f":"Rupture!H29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"Rupture!P29","v":0}]
[2,null,{"$f":"Rupture!H31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"Rupture!$P31","v":0}]
[3,null,{"$f":"Rupture!H33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"Rupture!$P33","v":0}]
[4,null,{"$f":"Rupture!H35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"Rupture!$P35","v":0}]
[5,null,{"$f":"Rupture!H37","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"Rupture!$P37","v":0}]
[6,null,{"$f":"Rupture!H39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,{"$f":"Rupture!$P39","v":0}]
["7 et +",null,{"$f":"Rupture!H41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 et +",null,{"$f":"Rupture!$P41","v":0}]
[]
[]
[]
["Bonus",null,{"$f":"Rupture!K49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus",null,{"$f":"Rupture!L49","v":0}]
[]
[]
[]
["Bonus extra",null,{"$f":"Rupture!K51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus extra",null,{"$f":"Rupture!L51","v":0}]
[]
[]
[]
[]
[]
[null,"BILAN DE L'OBSERVATION :",null,null,null,null,null,null,null,null,null,"BILAN DE L'OBSERVATION :"]
[null,{"$f":"IF((C16+C17+C18)>=50, 'Feedback 2'!B3,'Feedback 2'!B2)","v":"BIEN CONTINUE A ETRE DANGEREUX DES LE DEBUT"},null,null,null,null,null,null,null,null,null,{"$f":"IF((C16+C17+C18)>=50, 'Feedback 2'!C3,'Feedback 2'!C2)","v":"BIEN CONTINUE A ETRE DANGEREUX DES LE DEBUT"}]
[null,{"$f":" IF(C26<3,'Feedback 2'!B4,'Feedback 2'!B5)","v":"CHOIX DE BONUS A REVOIR"},null,null,null,null,null,null,null,null,null,{"$f":"IF(T26<3,'Feedback 2'!C4,'Feedback 2'!C5)","v":"CHOIX DE BONUS A REVOIR"}]

{"sheet":"Feedback 2","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Joueur 1","Joueur 2"]
["Rupture rapide","BIEN CONTINUE A ETRE DANGEREUX DES LE DEBUT","BIEN CONTINUE A ETRE DANGEREUX DES LE DEBUT"]
["Jeu en coopération","PENSE A VARIER TES COUPS ET LES VITESSES POUR ETRE PLUS DANGEREUX DANS L'ECHANGE","PENSE A VARIER TES COUPS ET LES VITESSES POUR ETRE PLUS DANGEREUX DANS L'ECHANGE"]
["Bonus<3","CHOIX DE BONUS A REVOIR","CHOIX DE BONUS A REVOIR"]
["Bonus >3","BON CHOIX DE BONUS - ATTENTION L'ADVERSAIRE VA PEUT ETRE S'ADAPTER","BON CHOIX DE BONUS - ATTENTION L'ADVERSAIRE VA PEUT ETRE S'ADAPTER"]
["Bonus régularité =0"]
["Bonus régularité = 1"]

{"sheet":"Table de score","index":7,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,9,15,10],[3,11,3,14],[2,11,2,14],[2,1,2,4],[3,1,3,4],[9,3,9,4],[9,9,9,10],[11,2,16,3],[11,12,16,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[25,2,30,3],[25,12,30,13]]}
[]
[]
[null,"Joueur 1",null,null,null,null,null,null,null,null,null,"Joueur 2"]
[null,"Achile",null,null,null,null,null,null,null,null,null,"Talon"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"V","D",null,"SETS","POINTS","TOTAL",null,"LIGNE NOM"]
[null,null,null,null,{"$f":"IF(B4=\"\",\"\",B4)","v":"Achile"},{"$f":"IF(K35>K36,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K35<K36,1,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C26=\"\",\"\",C26)","v":""},{"$f":" IF(C12=\"\",\"\",C12)","v":""},{"$f":"IF(I35=I36,I35+J35,I35)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISERROR(MATCH(E35,Tableau1[Nom],0)),\"\",MATCH(E35,Tableau1[Nom],0))","v":1}]
[null,null,null,null,{"$f":"IF(L4=\"\",\"\",L4)","v":"Talon"},{"$f":" IF( K36>K35,1,0)","v":{"$error":"#VALUE!"}},{"$f":" IF( K36<K35,1,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(M26=\"\",\"\",M26)","v":""},{"$f":"IF(M12=\"\",\"\",M12)","v":""},{"$f":"IF(I36=I35,I36+J36,I36)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISERROR(MATCH(E36,Tableau1[Nom],0)),\"\",MATCH(E36,Tableau1[Nom],0))","v":2}]
[]
[null,null,null,null,"Remarque : s'il y a égalité au nombre de sets, on regarde les points marqués."]

{"sheet":"Liste élèves","index":8,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,5,3,12]]}
[]
[null,null,null,null,null,"Paramétrage des joueurs"]
[]
[]
[]
[]
[null,"Nom","Prénom","Victoires","Défaites"]
[null,"Achile","Talon",2,0]
[null,"Talon","Achile",0,2]