{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sign_Up","Members_student","Login_Elev","Members","Evaluation_Maths_TleD","Les Résultats","Sauvegarde Réponse","Q_Maths_TleD"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":2,"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":"Sign_Up","index":0,"n_rows":12,"n_cols":143,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tle A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tle C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tle D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ère A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ère D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ère C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ème"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ème"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5ème"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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ème"]

{"sheet":"Members_student","index":1,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Code Cand","Nom","Prénoms","Username","Password","Niv_Etude"]
["Code-1152","DJE","KOUASSI THIERRY","DJ_KOUA","DKOU@1171","Tle D"]

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

{"sheet":"Members","index":3,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Username","Password","Role","Code_Etab"]
[null,"adminschool","P@ssword","Admin","DRENABIDJ004"]
[null,"moi","Percydev@","Global Admin","DEV2018"]
[null,"usermanager","P@ssword123","Manager","DRENABIDJ004"]

{"sheet":"Evaluation_Maths_TleD","index":4,"n_rows":23,"n_cols":27,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,4,2,10],[22,4,22,10],[4,4,8,10],[10,4,10,6],[10,8,10,10],[11,4,12,6],[11,8,12,10],[14,4,14,6],[14,8,14,10],[15,4,16,6],[15,8,16,10]]}
[]
[null,null,null,null,"Composition en Maths Niv Tle D"]
[]
[]
[null,null,null,null,{"$f":"INDEX(Q_Maths_TleD!A1:I21, MATCH(\"-\", Q_Maths_TleD!H1:H21,0),2)","v":"Lequel de ces opéras de Verdi a été composé en 1871 pour l'inauguration de l'opéra du Caire?"}]
[]
[]
[]
[]
[]
[null,null,null,null,"Choix 1",null,null,null,"Choix 2"]
[null,null,null,null,{"$f":"INDEX(Q_Maths_TleD!A1:I21, MATCH(\"-\", Q_Maths_TleD!H1:H21,0),3)","v":"Otello"},null,null,null,{"$f":"INDEX(Q_Maths_TleD!A1:I21, MATCH(\"-\", Q_Maths_TleD!H1:H21,0),4)","v":"Nabucco"}]
[]
[]
[null,null,null,null,"Choix 3",null,null,null,"Choix 4"]
[null,null,null,null,{"$f":"INDEX(Q_Maths_TleD!A1:I21, MATCH(\"-\", Q_Maths_TleD!H1:H21,0),5)","v":"Aïda"},null,null,null,{"$f":"INDEX(Q_Maths_TleD!A1:I21, MATCH(\"-\", Q_Maths_TleD!H1:H21,0),6)","v":"La Traviatta"}]
[]
[]
[]
[null,null,null,null,"Votre choix",null,null,null,"Votre Score / 20",{"$f":"Q_Maths_TleD!I22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,{"$f":"\"Nombre de questions restantes:\" &(20-LEN(AA20))","v":"Nombre de questions restantes:20"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20-LEN(AA20)","v":20},null,null,{"$f":"20-LEN(AA20)","v":20}]

{"sheet":"Les Résultats","index":5,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Date :"]
[]
[]
[null,null,null,"Code Candidat:"]
[]
[]
[]
[]
[]
[]
[null,"Nom:"]
[]
[]
[null,"Prénoms:"]
[]
[]
[null,"Score/Point obtenu:"]
[]
[]
[null,"Evaluation :"]
[]
[]
[null,"Performance de l'évaluation :"]

{"sheet":"Sauvegarde Réponse","index":6,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Code","Nom","Prénoms","Niveau","Matière","question juste","question fausse","note obtenue","date compo"]

{"sheet":"Q_Maths_TleD","index":7,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,6,21,7]]}
[null,"Question","Choix 1","Choix 2","Choix 3","Choix 4","Ch. Ok","Rep. U","Test"]
[1,"Lequel de ces opéras de Verdi a été composé en 1871 pour l'inauguration de l'opéra du Caire?","Otello","Nabucco","Aïda","La Traviatta",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A2, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A2, 1),\"-\")","v":"-"},{"$f":"IF(H2=TEXT(G2,\"0\"),1,0)","v":0}]
[2,"Lequels de ces métiers n'a jamais exercé Giuseppe VERDI ?","Décorateur","Librettiste","Metteur en scène",null,1,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A3, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A3, 1),\"-\")","v":"-"},{"$f":"IF(H3=TEXT(G3,\"0\"),1,0)","v":0}]
[3,"Quelle était la couleur des chemises de troupes de Garibaldi ?","Marron","noir","rouge","vert",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A4, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A4, 1),\"-\")","v":"-"},{"$f":"IF(H4=TEXT(G4,\"0\"),1,0)","v":0}]
[4,"Dans l'opéra \" Le Trouvère\" de Verdi. Léonora est amoureuse de …","Marico","Riccardo","Enrico","Radamès",1,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A5, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A5, 1),\"-\")","v":"-"},{"$f":"IF(H5=TEXT(G5,\"0\"),1,0)","v":0}]
[5,"En 1873, Verdi a composé un requiem à la mémoire de …","de sa femme Guiseppina Strponni","de son ami poête Allessandro Manzoni","du compositeur Giocchino Rossini","son cousin Alberto del  FISTO",2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A6, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A6, 1),\"-\")","v":"-"},0]
[6,"Laquelle de ces batailles a donné l'idée au prix Nobel de la paix Henri DUNANT, de créer la Croix Rouge pour secourir les bléssés de Guerre en 1863 ?","Magenta","Solférino","Crimée","Madrino",2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A7, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A7, 1),\"-\")","v":"-"},0]
[7,"De Quel auteur francais s'est inspiré Giuseppe Verdi pour écrire son opéra \"RIGOLETTO\" ?","Honoré de Balzac","STENDHAL","Victor HUGO","Gustave FLAUBERT",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A8, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A8, 1),\"-\")","v":"-"},0]
[8,"Dans ses dernières volontés, Verdi a demandé qu'on …","construise à ses frais un hopital","distribue 1000 francs aux pauvres le jour de sa mort","batisse un hospice pour arbitrer les vieux misiciens",null,2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A9, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A9, 1),\"-\")","v":"-"},0]
[9,"Lequels de ses orchestres créés au XIX siècle est le plus ancien ?","Pasdeloup","Lamoureux","Colonne",null,1,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A10, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A10, 1),\"-\")","v":"-"},0]
[10,"Lequel de ces romans a inspiré à Giuseppe VERDI \" La Traviatta\" ?","Madame de Bovary","Anna Karénine","La dame aux camélias",null,3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A11, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A11, 1),\"-\")","v":"-"},0]
[11,"Le sol de la Nouvelle Calédonie est connu pour etre particulierement riche en …..","Uranium","Nickel","Plomb","Zinc",2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A12, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A12, 1),\"-\")","v":"-"},0]
[12,"Quelle est la plus grande île du monde ?","Le Groenland","Madagascar","L'Australie","La Nouvelle Guinée",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A13, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A13, 1),\"-\")","v":"-"},0]
[13,"Comment appelle-t-on les masses de nuages denses en forme de montagne ?","Cirrocumulus","Nimbostratus","Altocumulus","Cumulonimbus",4,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A14, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A14, 1),\"-\")","v":"-"},0]
[14,"Quelle chanteuse demandait \" Palez moi d'amour\" ?","Régine","Edith Piaf","Dalida","Lucienne Boyer",4,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A15, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A15, 1),\"-\")","v":"-"},0]
[15,"Quel est le principal ingrédient de la pipérade ?","Le poivron","la tomate","L'oignon","Le Choux",2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A16, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A16, 1),\"-\")","v":"-"},0]
[16,"Le terme médical désignant un malade \"imaginaire\"  est :","paranoïaque","hypocondriaque","agoraphobe","psychopate",2,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A17, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A17, 1),\"-\")","v":"-"},0]
[17,"Lequel de ces musiciens a composé \"La lettre à Elise\"","Beethoven","Bach","Schubert","Mozart",1,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A18, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A18, 1),\"-\")","v":"-"},0]
[18,"Qu'est ce que le feng shui ?","un variété de poission cru japonais","un art martial","une philisophie orientale qui vise à harmoniquer nos lieux de vie","le mouvement féministe chinois",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A19, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A19, 1),\"-\")","v":"-"},0]
[19,"Quelle est la circonférence d'un ballon officiel de football ?","entre 51 et 63 cm","entre 64 et 67 cm","entre 68 et 71 cm","entre 72 et 77 cm",3,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A20, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A20, 1),\"-\")","v":"-"},0]
[20,"Quel prénom féminin complète le titre du film \" un poisson nommé ……\" ?","Sonia","Velda","Wania","Wanda",4,{"$f":"IF(MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A21, 1)<>\"\",MID(Evaluation_Maths_TleD!$AA$20,Q_Maths_TleD!A21, 1),\"-\")","v":"-"},0]
[null,null,null,null,null,null,"Note / 20",null,{"$f":"SUM(I2:I21)","v":0}]