{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Accueil","Recap","Liste","Matrice","ABDENNABI Sarah","ABRAHAM Jade","ALIOUETTE Izza","BOUCHAALA REQUIEG Shainess","CORBI Félicien","EL MANNOUTI Basma","EL YAKOUBI Imane","FOUQUET Ines","HASSOUN Lydia","HYRONIMUS Julian","JBILOU Dounia","KITA Kenza","LOUATI Ines","MASDAVAILL Maëva","MILA Camille","MJID Cyrine","MONTANO Sophia","NAMOUCHI Sheima","NESSIOUI Enzo","PALMERI Tina","PILLOTE Chloé","SAINGERY Sarah"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"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":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
["Accueil","Accueil"]
["Liste"]
["Matrice",null,"Aide à la saisie des contrôles",null,null,null,"Accueil"]
["Récap"]
[null,null,"Etape 1 : ","Feuille MATRICE"]
[]
[null,null,null,"Saisir la matrice d'évaluation : Thèmes, questions, barême"]
[]
[null,null,"Etape 2 : ","Feuille LISTE"]
[]
[null,null,null,"Vérifier et mettre à jour la liste d'élèves si nécessaire"]
[null,null,null,"Créer les onglets élèves en cliquant sur "]
[]
[null,null,"Etape 3 :","Feuilles élèves"]
[]
[null,null,null,"Saisir les notes élève par élève"]
[]
[null,null,"Etape 4 : ","Feuille RECAP"]
[]
[null,null,null,"Consulter/Imprimer les résultats"]
[]
[null,null,"Etape 5 : ","Feuille LISTE"]
[]
[null,null,null,"ATTENTION"]
[null,null,null,"Pour la création du nouvelle liste d'élève ou d'une nouvelle matrice"]
[null,null,null,"Clic sur Supprimer les onglets"]
[null,null,null,"IRREVERSIBLE…..."]

{"sheet":"Recap","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Accueil"]
["Liste"]
["Matrice",null,null,null,null,null,"Recap"]
["Récap",null,"TH1","TH2","TH3","Total"," /20","Note"]
[null,"Accueil",{"$f":"MIN(C9:C30)","v":5},10,6,21,{"$f":"MIN(G9:G30)","v":7.64},"Minimum"]
[null,"Recap",{"$f":"AVERAGE(C9:C30)","v":5.9545454545454541},10,6,21.954545454545453,{"$f":"AVERAGE(G9:G30)","v":7.9836363636363634},"Moyenne"]
[null,"Liste",{"$f":"MAX(C9:C30)","v":6},10,6,22,{"$f":"MAX(G9:G30)","v":8},"Maximum"]
[null,"Matrice",{"$f":"INDIRECT(\"'\" & B8 & \"'\" & \"!h4\" )","v":10},{"$f":"INDIRECT(\"'\" & B8 & \"'\" & \"!h5\" )","v":26},{"$f":"INDIRECT(\"'\" & B8 & \"'\" & \"!h6\" )","v":19},{"$f":"INDIRECT(\"'\" & B8 & \"'\" & \"!H7\" )","v":55},{"$f":"(F8/F8)*20","v":20}]
[null,"ABDENNABI Sarah",{"$f":"INDIRECT(\"'\" & B9 & \"'\" & \"!i4\" )","v":5},{"$f":"INDIRECT(\"'\" & B9 & \"'\" & \"!i5\" )","v":10},{"$f":"INDIRECT(\"'\" & B9 & \"'\" & \"!i6\" )","v":6},{"$f":"SUM(C9:E9)","v":21},{"$f":"ROUND((F9/$F$8)*20,2)","v":7.64},{"$f":"RANK(G9,G9:G43)","v":22}]
[null,"ABRAHAM Jade",{"$f":"INDIRECT(\"'\" & B10 & \"'\" & \"!i4\" )","v":6},{"$f":"INDIRECT(\"'\" & B10 & \"'\" & \"!i5\" )","v":10},{"$f":"INDIRECT(\"'\" & B10 & \"'\" & \"!i6\" )","v":6},{"$f":"SUM(C10:E10)","v":22},{"$f":"ROUND((F10/$F$8)*20,2)","v":8},{"$f":"RANK(G10,G10:G44)","v":1}]
[null,"ALIOUETTE Izza",{"$f":"INDIRECT(\"'\" & B11 & \"'\" & \"!i4\" )","v":6},{"$f":"INDIRECT(\"'\" & B11 & \"'\" & \"!i5\" )","v":10},{"$f":"INDIRECT(\"'\" & B11 & \"'\" & \"!i6\" )","v":6},{"$f":"SUM(C11:E11)","v":22},8,1]
[null,"BOUCHAALA REQUIEG Shainess",6,10,6,22,8,1]
[null,"CORBI Félicien",6,10,6,22,8,1]
[null,"EL MANNOUTI Basma",6,10,6,22,8,1]
[null,"EL YAKOUBI Imane",6,10,6,22,8,1]
[null,"FOUQUET Ines",6,10,6,22,8,1]
[null,"HASSOUN Lydia",6,10,6,22,8,1]
[null,"HYRONIMUS Julian",6,10,6,22,8,1]
[null,"JBILOU Dounia",6,10,6,22,8,1]
[null,"KITA Kenza",6,10,6,22,8,1]
[null,"LOUATI Ines",6,10,6,22,8,1]
[null,"MASDAVAILL Maëva",6,10,6,22,8,1]
[null,"MILA Camille",6,10,6,22,8,1]
[null,"MJID Cyrine",6,10,6,22,8,1]
[null,"MONTANO Sophia",6,10,6,22,8,1]
[null,"NAMOUCHI Sheima",6,10,6,22,8,1]
[null,"NESSIOUI Enzo",6,10,6,22,8,1]
[null,"PALMERI Tina",6,10,6,22,8,1]
[null,"PILLOTE Chloé",6,10,6,22,8,1]
[null,"SAINGERY Sarah",6,10,6,22,8,1]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$error":"#N/A"}]

{"sheet":"Liste","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,2,2,5],[11,4,12,5],[18,4,19,5],[8,6,10,8],[15,6,17,8],[4,2,4,8],[6,2,6,8],[7,1,7,2],[8,1,8,2]]}
["Accueil"]
["Liste",null,"Gérer la liste des inscrits"]
["Matrice",null,null,null,null,null,"Liste"]
["Récap"]
[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(B9:B44)&\" inscrits.\"","v":"22 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(C10=\"\",\"\",1)","v":1},"ABDENNABI Sarah"]
[null,{"$f":"IF(C11=\"\",\"\",1+B10)","v":2},"ABRAHAM Jade"]
[null,{"$f":"IF(C12=\"\",\"\",1+B11)","v":3},"ALIOUETTE Izza",null,"La matrice doit avoir été saisie…..."]
[null,4,"BOUCHAALA REQUIEG Shainess"]
[null,5,"CORBI Félicien"]
[null,6,"EL MANNOUTI Basma"]
[null,7,"EL YAKOUBI Imane",null,null,null,"Cette macro supprime tous les onglets sauf Accueil, Genere, Liste et Matrice"]
[null,8,"FOUQUET Ines"]
[null,9,"HASSOUN Lydia"]
[null,10,"HYRONIMUS Julian",null,"IRREVERSIBLE"]
[null,11,"JBILOU Dounia"]
[null,12,"KITA Kenza"]
[null,13,"LOUATI Ines"]
[null,14,"MASDAVAILL Maëva"]
[null,15,"MILA Camille"]
[null,16,"MJID Cyrine"]
[null,17,"MONTANO Sophia"]
[null,18,"NAMOUCHI Sheima"]
[null,19,"NESSIOUI Enzo"]
[null,20,"PALMERI Tina"]
[null,21,"PILLOTE Chloé"]
[null,22,"SAINGERY Sarah"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Matrice","index":3,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"Matrice","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"ABDENNABI Sarah","index":4,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"Accueil","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":5}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":21}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":7.6363636363636367}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,0]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":5}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,2]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,1]
[null,"2.4","Q2.4",8,5]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"ABRAHAM Jade","index":5,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"ABRAHAM Jade","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"ALIOUETTE Izza","index":6,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"ALIOUETTE Izza","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"BOUCHAALA REQUIEG Shainess","index":7,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"BOUCHAALA REQUIEG Shainess","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"CORBI Félicien","index":8,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"CORBI Félicien","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"EL MANNOUTI Basma","index":9,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"EL MANNOUTI Basma","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"EL YAKOUBI Imane","index":10,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"EL YAKOUBI Imane","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"FOUQUET Ines","index":11,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"FOUQUET Ines","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"HASSOUN Lydia","index":12,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"HASSOUN Lydia","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"HYRONIMUS Julian","index":13,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"HYRONIMUS Julian","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"JBILOU Dounia","index":14,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"Recap","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"KITA Kenza","index":15,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"KITA Kenza","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"LOUATI Ines","index":16,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"LOUATI Ines","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"MASDAVAILL Maëva","index":17,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"MASDAVAILL Maëva","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"MILA Camille","index":18,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"MILA Camille","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"MJID Cyrine","index":19,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"MJID Cyrine","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"MONTANO Sophia","index":20,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"MONTANO Sophia","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"NAMOUCHI Sheima","index":21,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"NAMOUCHI Sheima","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"NESSIOUI Enzo","index":22,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"NESSIOUI Enzo","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"PALMERI Tina","index":23,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"PALMERI Tina","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"PILLOTE Chloé","index":24,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"PILLOTE Chloé","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]

{"sheet":"SAINGERY Sarah","index":25,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
["Accueil","Matrice"]
["Liste"]
["Matrice",null,null,null,null,null,"SAINGERY Sarah","Pts","Note"]
["Récap",null,null,null,null,null,{"$f":"C10","v":"TH1"},{"$f":"D26","v":10},{"$f":"E26","v":6}]
[null,null,null,null,null,null,{"$f":"C27","v":"TH2"},{"$f":"D43","v":26},{"$f":"E43","v":10}]
["Propre","https://www.excel-downloads.com/threads/affecter-une-macro-a-un-texte.93167/",null,null,null,null,{"$f":"C44","v":"TH3"},{"$f":"D50","v":19},{"$f":"E50","v":6}]
["Sale",null,null,null,null,null,"Total",{"$f":"SUM(H4:H6)","v":55},{"$f":"SUM(I4:I6)","v":22}]
[null,null,null,null,null,null,"Note/20",{"$f":"(H7/H7)*20","v":20},{"$f":"(I7/H7)*20","v":8}]
[]
[null,1,"TH1","Pts","Note"]
[null,"1.1","Q1.1",1,1]
[null,"1.2",{"$f":"\"Q\"&B12","v":"Q1.2"},2,2]
[null,"1.3","Q1.3",3,1]
[null,"1.4","Q1.4",4,2]
[null,"1.5","Q1.5"]
[null,"1.6","Q1.6"]
[null,"1.7","Q1.7"]
[null,"1.8","Q1.8"]
[null,"1.9","Q1.9"]
[null,"1.10","Q1.10"]
[null,"1.11","Q1.11"]
[null,"1.12","Q1.12"]
[null,"1.13","Q1.13"]
[null,"1.14","Q1.14"]
[null,"1.15","Q1.15"]
[null,null,"Total",{"$f":"IF(COUNT(D11:D25)=\"\",\"\",SUM(D11:D25))","v":10},{"$f":"IF(COUNT(E11:E25)=\"\",\"\",SUM(E11:E25))","v":6}]
[null,2,"TH2","Pts","Note"]
[null,"2.1",{"$f":"\"Q\"&B28","v":"Q2.1"},5,1]
[null,"2.2",{"$f":"\"Q\"&B29","v":"Q2.2"},6,2]
[null,"2.3","Q2.3",7,3]
[null,"2.4","Q2.4",8,4]
[null,"2.5","Q2.5"]
[null,"2.6","Q2.6"]
[null,"2.7","Q2.7"]
[null,"2.8","Q2.8"]
[null,"2.9","Q2.9"]
[null,"2.10","Q2.10"]
[null,"2.11","Q2.11"]
[null,"2.12","Q2.12"]
[null,"2.13","Q2.13"]
[null,"2.14","Q2.14"]
[null,"2.15","Q2.15"]
[null,null,"Total",{"$f":"IF(COUNT(D28:D42)=\"\",\"\",SUM(D28:D42))","v":26},{"$f":"IF(COUNT(E28:E42)=\"\",\"\",SUM(E28:E42))","v":10}]
[null,3,"TH3","Pts","Note"]
[null,"3.1",{"$f":"\"Q\"&B45","v":"Q3.1"},9,2]
[null,"3.2",{"$f":"\"Q\"&B46","v":"Q3.2"},10,4]
[null,"3.3","Q3.3"]
[null,"3.4","Q3.4"]
[null,"3.5","Q3.5"]
[null,null,"Total",{"$f":"IF(COUNT(D45:D49)=\"\",\"\",SUM(D45:D49))","v":19},{"$f":"IF(COUNT(E45:E49)=\"\",\"\",SUM(E45:E49))","v":6}]