{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Accueil","Genere","Liste","Matrice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Liste des élèves"]
[]
[null,"Matrice du contrôle"]

{"sheet":"Genere","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Génere"]

{"sheet":"Liste","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,6,9,8],[14,6,16,8],[1,2,1,8],[3,2,3,8],[5,2,5,8],[6,1,6,2],[7,1,7,2]]}
[]
[null,null,"Gérer la liste des inscrits"]
[]
[null,null,"Saisir la liste puis cliquer sur \"CRÉER...\" pour créer les onglets pour chaque élève."]
[]
[null,null,"Pour supprimer les onglets élèves cliquer sur \"SUPPRIMER…\"",null,null,null,null,null,null,"IRREVERSIBLE"]
[null,{"$f":"MAX(B8:B43)&\" inscrits.\"","v":"26 inscrits."}]
[null,"Liste élèves",null,null,null,null,"Cette macro fait référence à la zone Liste  qui comprend les élèves de Alpha à *** 'Soit de 1 à 35."]
[null,{"$f":"IF(C9=\"\",\"\",1)","v":1},"Alpha André"]
[null,{"$f":"IF(C10=\"\",\"\",1+B9)","v":2},"Bravo Benoit"]
[null,{"$f":"IF(C11=\"\",\"\",1+B10)","v":3},"Charly Constance",null,"Macro : ajout_onglets_eleves()"]
[null,4,"Delta Désirée"]
[null,5,"Echo Eugène"]
[null,6,"Foxtrot Firmin"]
[null,7,"Golf Gaston",null,null,null,"Cette macro supprime tous les onglets sauf Accueil, Genere, Liste et Matrice"]
[null,8,"Hotel Hermine"]
[null,9,"India Isadora"]
[null,10,"Juliet jean",null,"Macro : supprimer_onglets_eleves()"]
[null,11,"Kilo kouamé"]
[null,12,"Lima Loïc"]
[null,13,"Mike Michel"]
[null,14,"November Noémie"]
[null,15,"Oscar Owen"]
[null,16,"Papa Pierre"]
[null,17,"Quebec Quirin"]
[null,18,"Romeo René"]
[null,19,"Sierra Sylvie"]
[null,20,"Tango Tadeo"]
[null,21,"Uniform Ursule"]
[null,22,"Victor Valerian"]
[null,23,"Whisky Waldo"]
[null,24,"Xray Xana"]
[null,25,"Yankee Yannick"]
[null,26,"Zoulou Zoé"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Matrice","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Matrice"]
[]
[null,"SS1",null,"Pts"]
[null,null,"aaa",1]
[null,null,"bbb",2]
[null,null,"ccc",3]
[]
[null,"SS2"]
[null,null,"ddd",4]
[null,null,"eee",5]
[null,null,"fff",6]
[null,null,null,null,null," /20"]
[null,"Total",null,{"$f":"SUM(D6:D13)","v":21},{"$f":"SUM(E6:E8,E11:E13)","v":0},{"$f":"(E15/D15)*20","v":0}]