{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Explications_Moyenne_Cumulative","1. Moyenne - Programme A","1. Moyenne - Programme B","1. Moyenne - Programme C","2. Moyenne - BAC CUM","Normes Succès-Progression","... suite","BarèmeNotationFEP note %","Matrices"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":8,"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":"Explications_Moyenne_Cumulative","index":0,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,2],[35,4,35,10],[36,0,36,10],[58,31,58,40],[28,3,28,4],[29,3,29,4],[29,12,29,15],[30,3,31,5],[30,7,31,8],[31,0,34,2],[32,3,32,10],[33,3,34,3],[33,4,34,10],[24,0,30,2],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[15,0,15,2],[15,3,15,4],[16,0,19,2],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,0,23,2],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[14,0,14,2],[14,3,14,4],[8,16,9,16],[8,17,9,17],[8,18,9,18],[10,0,13,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[8,19,9,19],[8,20,9,20],[8,21,9,21],[5,0,6,2],[5,3,6,4],[5,5,5,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[7,0,7,4],[8,0,8,4],[0,0,0,10],[1,0,1,5],[3,0,3,10],[4,0,4,1],[4,2,4,3],[4,5,4,7],[4,8,4,10]]}
["TABLEAU 1 - Aide au calcul de la moyenne cumulative par programme (FEP-UdeM 1er cycle) màj 2021-04-23"]
["Le calcul de la moyenne cumulative est présenté à",null,null,null,null,null,"l'article 11 ","du Règlement des études de premier cycle"]
[]
[" Veuillez faire vos entrées ou vos modifications à partir des choix des listes déroulantes dans les champs en jaune"]
["ÉTAPE 1 4  ",null," Certificat, par défaut  4  ",null,null,"Certificat (30 crédits)",null,null,"3 modifier SI AUTRE TYPE de programme "]
["IMPORTANT  ",null,null,"ÉTAPE 2 4",null,"Entrer vos données dans ces 3 colonnes"]
[null,null,null,null,null,6,6,6,"VALEUR DE LA NOTE contributoire à la moyenne","Crédits qui contribuent au calcul de la moyenne cumulative du programme","Crédits obtenus associés à la structure du programme d’études"]
["Pour des calculs précis, NE PAS INCLURE les cours faits en Surplus ou Hors programme.",null,null,null,null,"entrée facultative","entrée obligatoire","entrée obligatoire"]
["Dans les deux cas, ils ne font pas partie de la structure du programme.  Ils ne sont contributoires ni à la moyenne cumulative (case C) ni au cumul de crédits (case B)",null,null,null,null,"SIGLE de COURS ","CRÉDITS SUIVIS                        3 par défaut","NOTE ",null,null,null,null,null,null,null,null,"Nb échecs","POINTS = valeur de la note multipliée par crédits","Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits SUIVIS, inclus ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,null,null,"Colonne1","3","Colonne2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour test"]
["Il est INUTILE D'INCLURE ICI                les cours pour lesquels les résultats sont ABA, EF, ATN ou REM car non contributoires à la structure du programme.",null,null,"Cours  1",null,"TXM 1112",3,"EQV",{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( S )\"),\"\",VLOOKUP(H11,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H11=\"\",\"\",IF(H11=\"EXE\",\"\",IF(H11=\"EQV\",\"\",IF(H11=\"( S )\",\"\", IF(H11= \"( E) \",\"\",IF(H11= \"SN\",\"\",IF(H11=\"EF\",\"\",IF(H11=\"REM\",\"\",IF(H11=\"ATN\",\"\",IF(H11=\"ABA\",\"\",G11))))))))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \", H11=\"SN\", H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",   H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),    \"\",G11))","v":3}]
[null,null,null,"Cours  2",null,"TXM 1221",3,"B",{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( S )\"),\"\",VLOOKUP(H12,Matrices!A$3:B$27,2,FALSE)))","v":3},{"$f":"IF(H12=\"\",\"\",IF(H12=\"EXE\",\"\",IF(H12=\"EQV\",\"\",IF(H12=\"( S )\",\"\", IF(H12= \"( E) \",\"\",IF(H12= \"SN\",\"\",IF(H12=\"EF\",\"\",IF(H12=\"REM\",\"\",IF(H12=\"ATN\",\"\",IF(H12=\"ABA\",\"\",G12))))))))))","v":3},{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \", H12=\"SN\", H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",   H12=\"E\",H12=\"E*\",H12=\"F\",H12=\"F*\" ),    \"\",G12))","v":3},null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),\"échec\",\"\"))","v":""},{"$f":"IF(OR(H11=\"\",H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( s )\"),\"\",I11*J11)","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\",H11=\"EQV\",H11=\"EXE\"),\"\",G11))","v":""},{"$f":"IF(I11<>\"\",IF(S12<>\"\",I11*S12,\"\"),\"\")","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\"),\"\",G11))","v":3},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EXE\",H11=\"EQV\"),\"\",G11))","v":""},"sigle 1",3,"A+"]
[null,null,null,"Cours  3",null,"TXM 1331",3,"B+",{"$f":"IF(H13=\"\",\"\",IF(OR(H13=\"( E) \",H13=\"SN\",H13=\"ABA\",H13=\"EF\",H13=\"REM\",H13=\"ATN\",H13=\"EQV\",H13=\"EXE\",H13=\"( S )\"),\"\",VLOOKUP(H13,Matrices!A$3:B$27,2,FALSE)))","v":3.3},3,3,null,null,null,null,null,"",{"$f":"IF(OR(K12=\"\",H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( s )\"),\"\",I12*J12)","v":9},3,9,3,3,"sigle 2",3,"C+"]
[null,null,null,"Cours  4",null,"TXM 1441",3,"C-",{"$f":"IF(H14=\"\",\"\",IF(OR(H14=\"( E) \",H14=\"SN\",H14=\"ABA\",H14=\"EF\",H14=\"REM\",H14=\"ATN\",H14=\"EQV\",H14=\"EXE\",H14=\"( S )\"),\"\",VLOOKUP(H14,Matrices!A$3:B$27,2,FALSE)))","v":1.7},3,3,null,null,null,null,null,"",9.8999999999999986,3,9.8999999999999986,3,3,"sigle 3",3,"A"]
["Pour une REPRISE de COURS :",null,null,"Cours  5",null,"TXM 2551",3,"E",{"$f":"IF(H15=\"\",\"\",IF(OR(H15=\"( E) \",H15=\"SN\",H15=\"ABA\",H15=\"EF\",H15=\"REM\",H15=\"ATN\",H15=\"EQV\",H15=\"EXE\",H15=\"( S )\"),\"\",VLOOKUP(H15,Matrices!A$3:B$27,2,FALSE)))","v":0.5},3,"",null,null,null,null,null,"",5.0999999999999996,3,5.0999999999999996,3,3,"sigle 4",3,"B-"]
["En vertu de l'article 13",null,null,"Cours  6",null,"TXM 3530",3,"B+",{"$f":"IF(H16=\"\",\"\",IF(OR(H16=\"( E) \",H16=\"SN\",H16=\"ABA\",H16=\"EF\",H16=\"REM\",H16=\"ATN\",H16=\"EQV\",H16=\"EXE\",H16=\"( S )\"),\"\",VLOOKUP(H16,Matrices!A$3:B$27,2,FALSE)))","v":3.3},3,3,null,null,null,null,null,"échec","","","",3,3,"sigle 5",3,"B+"]
["l Assurez-vous de remplacer par la nouvelle note celle d'un cours préalablement échoué    (E = 0,5        F = 0  F*= 0)",null,null,"Cours  7",null,"TXM 3510",3,"EXE",{"$f":"IF(H17=\"\",\"\",IF(OR(H17=\"( E) \",H17=\"SN\",H17=\"ABA\",H17=\"EF\",H17=\"REM\",H17=\"ATN\",H17=\"EQV\",H17=\"EXE\",H17=\"( S )\"),\"\",VLOOKUP(H17,Matrices!A$3:B$27,2,FALSE)))","v":""},"",3,null,null,null,null,null,"",9.8999999999999986,3,9.8999999999999986,3,3,"sigle 6",3,"B"]
[null,null,null,"Cours  8",null,"TXM 2480D",1,"D",{"$f":"IF(H18=\"\",\"\",IF(OR(H18=\"( E) \",H18=\"SN\",H18=\"ABA\",H18=\"EF\",H18=\"REM\",H18=\"ATN\",H18=\"EQV\",H18=\"EXE\",H18=\"( S )\"),\"\",VLOOKUP(H18,Matrices!A$3:B$27,2,FALSE)))","v":1},1,1,null,null,null,null,null,"","","","",3,"","sigle 7",3,"C"]
[null,null,null,"Cours  9",null,"TXM 2570D",1,"C+",{"$f":"IF(H19=\"\",\"\",IF(OR(H19=\"( E) \",H19=\"SN\",H19=\"ABA\",H19=\"EF\",H19=\"REM\",H19=\"ATN\",H19=\"EQV\",H19=\"EXE\",H19=\"( S )\"),\"\",VLOOKUP(H19,Matrices!A$3:B$27,2,FALSE)))","v":2.2999999999999998},1,1,null,null,null,null,null,"",1,1,1,1,1,"sigle 8",3,"F*"]
[null,null,null,"Cours 10",null,"TXM 2583D",1,"A+",{"$f":"IF(H20=\"\",\"\",IF(OR(H20=\"( E) \",H20=\"SN\",H20=\"ABA\",H20=\"EF\",H20=\"REM\",H20=\"ATN\",H20=\"EQV\",H20=\"EXE\",H20=\"( S )\"),\"\",VLOOKUP(H20,Matrices!A$3:B$27,2,FALSE)))","v":4.3},1,1,null,null,null,null,null,"",2.2999999999999998,1,2.2999999999999998,1,1,"sigle 9",3,"C-"]
["l La note d'une reprise approuvée d'un cours déjà réussi est la seule note qui sera retenue, même si elle devait être inférieure à la note initiale. ",null,null,"Cours 11",null,"TXM 3600",6,"( S )",{"$f":"IF(H21=\"\",\"\",IF(OR(H21=\"( E) \",H21=\"SN\",H21=\"ABA\",H21=\"EF\",H21=\"REM\",H21=\"ATN\",H21=\"EQV\",H21=\"EXE\",H21=\"( S )\"),\"\",VLOOKUP(H21,Matrices!A$3:B$27,2,FALSE)))","v":""},"",6,null,null,null,null,null,"",4.3,1,4.3,1,1,"sigle 10",3,"D"]
[null,null,null,"Cours 12",null,"TXM2551",3,null,{"$f":"IF(H22=\"\",\"\",IF(OR(H22=\"( E) \",H22=\"SN\",H22=\"ABA\",H22=\"EF\",H22=\"REM\",H22=\"ATN\",H22=\"EQV\",H22=\"EXE\",H22=\"( S )\"),\"\",VLOOKUP(H22,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","",6,"",6,6,"sigle 11",3,"E*"]
[null,null,null,"Cours 13",null,null,null,null,{"$f":"IF(H23=\"\",\"\",IF(OR(H23=\"( E) \",H23=\"SN\",H23=\"ABA\",H23=\"EF\",H23=\"REM\",H23=\"ATN\",H23=\"EQV\",H23=\"EXE\",H23=\"( S )\"),\"\",VLOOKUP(H23,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 12",3,"D+"]
[null,null,null,"Cours 14",null,null,null,null,{"$f":"IF(H24=\"\",\"\",IF(OR(H24=\"( E) \",H24=\"SN\",H24=\"ABA\",H24=\"EF\",H24=\"REM\",H24=\"ATN\",H24=\"EQV\",H24=\"EXE\",H24=\"( S )\"),\"\",VLOOKUP(H24,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 13",3,"E*"]
["IMPORTANT de remplacer  la note initiale par la note de reprise.           l Retenir que l'échec à la reprise d'un cours préalablement réussi vaut  E* = 1,0     contrairement             à   E =  0,5  pour l'échec d'un cours ne faisant pas l'objet d'une reprise.",null,null,"Cours 15",null,null,null,null,{"$f":"IF(H25=\"\",\"\",IF(OR(H25=\"( E) \",H25=\"SN\",H25=\"ABA\",H25=\"EF\",H25=\"REM\",H25=\"ATN\",H25=\"EQV\",H25=\"EXE\",H25=\"( S )\"),\"\",VLOOKUP(H25,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 14",3,"EQV"]
[null,null,null,"Cours 16",null,null,null,null,{"$f":"IF(H26=\"\",\"\",IF(OR(H26=\"( E) \",H26=\"SN\",H26=\"ABA\",H26=\"EF\",H26=\"REM\",H26=\"ATN\",H26=\"EQV\",H26=\"EXE\",H26=\"( S )\"),\"\",VLOOKUP(H26,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 15",3,"F*"]
[null,null,null,"Cours 17",null,null,null,null,{"$f":"IF(H27=\"\",\"\",IF(OR(H27=\"( E) \",H27=\"SN\",H27=\"ABA\",H27=\"EF\",H27=\"REM\",H27=\"ATN\",H27=\"EQV\",H27=\"EXE\",H27=\"( S )\"),\"\",VLOOKUP(H27,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 16",3,"E"]
[null,null,null,"Cours 18",null,null,null,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"( E) \",H28=\"SN\",H28=\"ABA\",H28=\"EF\",H28=\"REM\",H28=\"ATN\",H28=\"EQV\",H28=\"EXE\",H28=\"( S )\"),\"\",VLOOKUP(H28,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,null,"","","","","","sigle 17",3,"F"]
[null,null,null,"Cours 19",null,null,null,null,{"$f":"IF(H29=\"\",\"\",IF(OR(H29=\"( E) \",H29=\"SN\",H29=\"ABA\",H29=\"EF\",H29=\"REM\",H29=\"ATN\",H29=\"EQV\",H29=\"EXE\",H29=\"( S )\"),\"\",VLOOKUP(H29,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"E\",H28=\"E*\",H28=\"F\",H28=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 18",3,"( S )"]
[null,null,null,"Cours 20",null,null,null,null,{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"( E) \",H30=\"SN\",H30=\"ABA\",H30=\"EF\",H30=\"REM\",H30=\"ATN\",H30=\"EQV\",H30=\"EXE\",H30=\"( S )\"),\"\",VLOOKUP(H30,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,"report sans formule",null,null,null,{"$f":"IF(H29=\"\",\"\",IF(OR(H29=\"E\",H29=\"E*\",H29=\"F\",H29=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 19",3,"SN"]
[null,null,null,"MOYENNE CUMULATIVE                       avec notes contributoires",null,null,null,{"$f":"IF(J32=0,\"\",CONCATENATE(\" Arrondie à 2 décimales, moyenne cheminement en \",(VLOOKUP(G32,Matrices!G3:H11,2,TRUE))))","v":" Arrondie à 2 décimales, moyenne cheminement en progression-succès"},null,"Case A*","Case B*",null,"A","B","C:MC","Type Prog",{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"E\",H30=\"E*\",H30=\"F\",H30=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 20",3,"F*"]
["l Dans le cas d'un cours à option échoué non repris avec succès ou substitué (sous approbation du responsable), la note (E = 0,5  F = 0  F*= 0) demeure contributoire à la moyenne cumulative (case A) et aux crédits obtenus associés à la structure du programme (case B)",null,null,null,null,null,{"$f":"IF(J32=\"\",\"\",IF(J32<>0,R32/J32,\"\"))","v":2.3055555555555554},null,null,{"$f":" SUM(J11:J30)","v":18},{"$f":"SUM(K11:K30)","v":27},null,{"$f":"J32","v":18},{"$f":"K32","v":27},{"$f":"G32","v":2.3055555555555554},{"$f":"F5","v":"Certificat (30 crédits)"},{"$f":"COUNTIF(Q12:Q31, \"échec\")","v":1},{"$f":"SUM(R12:R31)","v":41.499999999999993},{"$f":"SUM(S12:S31)","v":21},{"$f":"SUM(T12:T31)","v":41.499999999999993},{"$f":"SUM(U12:U31)","v":30},{"$f":"SUM(V12:V31)","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits suivis, incluant les ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,"Case A*","Pour compléter un programme, il est nécessaire que les exigences de la structure du programme soient respectées. Même complété, il se peut que le nombre de crédits inscrits en case B soit supérieur au total de la structure, mais il ne peut être inférieur à celui-ci."]
[]
["l Le résultat à la case B peut être supérieur au nombre de crédits du programme.          ",null,null,"Case B*","La moyenne cumulative est calculée seulement à partir de crédits dont la note est contributoire à la moyenne cumulative qui est calculée en fonction du nombre de crédits contributoires obtenu à la case A"]
["Mise en garde - Les résultats obtenus à partir de ce tableau sont à titre suggestifs selon les entrées de données réelles ou hypothétiques. Seuls sont officiels les résultats des relevés de notes de l’étudiant émis par le Bureau du registraire de l’Université de Montréal."]

{"sheet":"1. Moyenne - Programme A","index":1,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,8,8,8],[6,9,8,9],[6,10,8,10],[7,0,7,4],[8,0,8,4],[5,0,6,2],[5,3,6,4],[5,5,5,7],[0,0,0,10],[3,0,3,10],[4,0,4,1],[4,2,4,3],[4,5,4,7],[4,8,4,10],[1,0,1,5],[10,0,13,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[14,0,14,2],[14,3,14,4],[15,0,15,2],[15,3,15,4],[16,0,19,2],[58,31,58,40],[36,0,36,10],[8,21,9,21],[20,0,23,2],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[26,3,26,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[35,0,35,2],[35,4,35,10],[29,12,29,15],[30,3,31,5],[30,7,31,8],[31,0,34,2],[33,3,34,3],[33,4,34,10],[24,0,30,2],[27,3,27,4],[28,3,28,4],[29,3,29,4],[32,3,32,10]]}
["TABLEAU 1 - Aide au calcul de la moyenne cumulative par programme (FEP-UdeM 1er cycle) màj 2021-04-23"]
["Le calcul de la moyenne cumulative est présenté à",null,null,null,null,null,"l'article 11 ","du Règlement des études de premier cycle"]
[]
[" Veuillez faire vos entrées ou vos modifications à partir des choix des listes déroulantes dans les champs en jaune"]
["ÉTAPE 1 4  ",null," Certificat, par défaut  4  ",null,null,"Certificat (30 crédits)",null,null,"3 modifier SI AUTRE TYPE de programme "]
["IMPORTANT  ",null,null,"ÉTAPE 2 4",null,"Entrer vos données dans ces 3 colonnes"]
[null,null,null,null,null,6,6,6,"VALEUR DE LA NOTE contributoire à la moyenne","Crédits qui contribuent au calcul de la moyenne cumulative du programme","Crédits obtenus associés à la structure du programme d’études"]
["Pour des calculs précis, NE PAS INCLURE les cours faits en Surplus ou Hors programme.",null,null,null,null,"entrée facultative","entrée obligatoire","entrée obligatoire"]
["Dans les deux cas, ils ne font pas partie de la structure du programme.  Ils ne sont contributoires ni à la moyenne cumulative (case C) ni au cumul de crédits (case B)",null,null,null,null,"SIGLE de COURS ","CRÉDITS SUIVIS                        3 par défaut","NOTE ",null,null,null,null,null,null,null,null,"Nb échecs","POINTS = valeur de la note multipliée par crédits","Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits SUIVIS, inclus ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,null,null,"Colonne1","3","Colonne2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour test"]
["Il est INUTILE D'INCLURE ICI                les cours pour lesquels les résultats sont ABA, EF, ATN ou REM car non contributoires à la structure du programme.",null,null,"Cours  1",null,null,3,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( S )\"),\"\",VLOOKUP(H11,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H11=\"\",\"\",IF(H11=\"EXE\",\"\",IF(H11=\"EQV\",\"\",IF(H11=\"( S )\",\"\", IF(H11= \"( E) \",\"\",IF(H11= \"SN\",\"\",IF(H11=\"EF\",\"\",IF(H11=\"REM\",\"\",IF(H11=\"ATN\",\"\",IF(H11=\"ABA\",\"\",G11))))))))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \", H11=\"SN\", H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",   H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),    \"\",G11))","v":""}]
[null,null,null,"Cours  2",null,null,3,null,{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( S )\"),\"\",VLOOKUP(H12,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H12=\"\",\"\",IF(H12=\"EXE\",\"\",IF(H12=\"EQV\",\"\",IF(H12=\"( S )\",\"\", IF(H12= \"( E) \",\"\",IF(H12= \"SN\",\"\",IF(H12=\"EF\",\"\",IF(H12=\"REM\",\"\",IF(H12=\"ATN\",\"\",IF(H12=\"ABA\",\"\",G12))))))))))","v":""},{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \", H12=\"SN\", H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",   H12=\"E\",H12=\"E*\",H12=\"F\",H12=\"F*\" ),    \"\",G12))","v":""},null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),\"échec\",\"\"))","v":""},{"$f":"IF(OR(H11=\"\",H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( s )\"),\"\",I11*J11)","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\",H11=\"EQV\",H11=\"EXE\"),\"\",G11))","v":""},{"$f":"IF(I11<>\"\",IF(S12<>\"\",I11*S12,\"\"),\"\")","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\"),\"\",G11))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EXE\",H11=\"EQV\"),\"\",G11))","v":""},"sigle 1",3,"A+"]
[null,null,null,"Cours  3",null,null,3,null,{"$f":"IF(H13=\"\",\"\",IF(OR(H13=\"( E) \",H13=\"SN\",H13=\"ABA\",H13=\"EF\",H13=\"REM\",H13=\"ATN\",H13=\"EQV\",H13=\"EXE\",H13=\"( S )\"),\"\",VLOOKUP(H13,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"",{"$f":"IF(OR(K12=\"\",H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( s )\"),\"\",I12*J12)","v":""},"","","","","sigle 2",3,"C+"]
[null,null,null,"Cours  4",null,null,3,null,{"$f":"IF(H14=\"\",\"\",IF(OR(H14=\"( E) \",H14=\"SN\",H14=\"ABA\",H14=\"EF\",H14=\"REM\",H14=\"ATN\",H14=\"EQV\",H14=\"EXE\",H14=\"( S )\"),\"\",VLOOKUP(H14,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 3",3,"A"]
["Pour une REPRISE de COURS :",null,null,"Cours  5",null,null,3,null,{"$f":"IF(H15=\"\",\"\",IF(OR(H15=\"( E) \",H15=\"SN\",H15=\"ABA\",H15=\"EF\",H15=\"REM\",H15=\"ATN\",H15=\"EQV\",H15=\"EXE\",H15=\"( S )\"),\"\",VLOOKUP(H15,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 4",3,"B-"]
["En vertu de l'article 13",null,null,"Cours  6",null,null,3,null,{"$f":"IF(H16=\"\",\"\",IF(OR(H16=\"( E) \",H16=\"SN\",H16=\"ABA\",H16=\"EF\",H16=\"REM\",H16=\"ATN\",H16=\"EQV\",H16=\"EXE\",H16=\"( S )\"),\"\",VLOOKUP(H16,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 5",3,"B+"]
["l Assurez-vous de remplacer par la nouvelle note celle d'un cours préalablement échoué    (E = 0,5        F = 0  F*= 0)",null,null,"Cours  7",null,null,3,null,{"$f":"IF(H17=\"\",\"\",IF(OR(H17=\"( E) \",H17=\"SN\",H17=\"ABA\",H17=\"EF\",H17=\"REM\",H17=\"ATN\",H17=\"EQV\",H17=\"EXE\",H17=\"( S )\"),\"\",VLOOKUP(H17,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 6",3,"B"]
[null,null,null,"Cours  8",null,null,3,null,{"$f":"IF(H18=\"\",\"\",IF(OR(H18=\"( E) \",H18=\"SN\",H18=\"ABA\",H18=\"EF\",H18=\"REM\",H18=\"ATN\",H18=\"EQV\",H18=\"EXE\",H18=\"( S )\"),\"\",VLOOKUP(H18,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 7",3,"C"]
[null,null,null,"Cours  9",null,null,3,null,{"$f":"IF(H19=\"\",\"\",IF(OR(H19=\"( E) \",H19=\"SN\",H19=\"ABA\",H19=\"EF\",H19=\"REM\",H19=\"ATN\",H19=\"EQV\",H19=\"EXE\",H19=\"( S )\"),\"\",VLOOKUP(H19,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 8",3,"F*"]
[null,null,null,"Cours 10",null,null,3,null,{"$f":"IF(H20=\"\",\"\",IF(OR(H20=\"( E) \",H20=\"SN\",H20=\"ABA\",H20=\"EF\",H20=\"REM\",H20=\"ATN\",H20=\"EQV\",H20=\"EXE\",H20=\"( S )\"),\"\",VLOOKUP(H20,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 9",3,"C-"]
["l La note d'une reprise approuvée d'un cours déjà réussi est la seule note qui sera retenue, même si elle devait être inférieure à la note initiale. ",null,null,"Cours 11",null,null,3,null,{"$f":"IF(H21=\"\",\"\",IF(OR(H21=\"( E) \",H21=\"SN\",H21=\"ABA\",H21=\"EF\",H21=\"REM\",H21=\"ATN\",H21=\"EQV\",H21=\"EXE\",H21=\"( S )\"),\"\",VLOOKUP(H21,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 10",3,"D"]
[null,null,null,"Cours 12",null,null,3,null,{"$f":"IF(H22=\"\",\"\",IF(OR(H22=\"( E) \",H22=\"SN\",H22=\"ABA\",H22=\"EF\",H22=\"REM\",H22=\"ATN\",H22=\"EQV\",H22=\"EXE\",H22=\"( S )\"),\"\",VLOOKUP(H22,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 11",3,"E*"]
[null,null,null,"Cours 13",null,null,3,null,{"$f":"IF(H23=\"\",\"\",IF(OR(H23=\"( E) \",H23=\"SN\",H23=\"ABA\",H23=\"EF\",H23=\"REM\",H23=\"ATN\",H23=\"EQV\",H23=\"EXE\",H23=\"( S )\"),\"\",VLOOKUP(H23,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 12",3,"D+"]
[null,null,null,"Cours 14",null,null,3,null,{"$f":"IF(H24=\"\",\"\",IF(OR(H24=\"( E) \",H24=\"SN\",H24=\"ABA\",H24=\"EF\",H24=\"REM\",H24=\"ATN\",H24=\"EQV\",H24=\"EXE\",H24=\"( S )\"),\"\",VLOOKUP(H24,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 13",3,"E*"]
["IMPORTANT de remplacer  la note initiale par la note de reprise.        l Retenir que l'échec à la reprise d'un cours préalablement réussi vaut  E* = 1,0     contrairement      à   E =  0,5  pour l'échec d'un cours ne faisant pas l'objet d'une reprise.",null,null,"Cours 15",null,null,3,null,{"$f":"IF(H25=\"\",\"\",IF(OR(H25=\"( E) \",H25=\"SN\",H25=\"ABA\",H25=\"EF\",H25=\"REM\",H25=\"ATN\",H25=\"EQV\",H25=\"EXE\",H25=\"( S )\"),\"\",VLOOKUP(H25,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 14",3,"EQV"]
[null,null,null,"Cours 16",null,null,3,null,{"$f":"IF(H26=\"\",\"\",IF(OR(H26=\"( E) \",H26=\"SN\",H26=\"ABA\",H26=\"EF\",H26=\"REM\",H26=\"ATN\",H26=\"EQV\",H26=\"EXE\",H26=\"( S )\"),\"\",VLOOKUP(H26,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 15",3,"F*"]
[null,null,null,"Cours 17",null,null,3,null,null,"","",null,null,null,null,null,"","","","","","","sigle 16",3,"E"]
[null,null,null,"Cours 18",null,null,3,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"( E) \",H28=\"SN\",H28=\"ABA\",H28=\"EF\",H28=\"REM\",H28=\"ATN\",H28=\"EQV\",H28=\"EXE\",H28=\"( S )\"),\"\",VLOOKUP(H28,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,null,"","","","","","sigle 17",3,"F"]
[null,null,null,"Cours 19",null,null,3,null,null,"","",null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"E\",H28=\"E*\",H28=\"F\",H28=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 18",3,"( S )"]
[null,null,null,"Cours 20",null,null,3,null,{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"( E) \",H30=\"SN\",H30=\"ABA\",H30=\"EF\",H30=\"REM\",H30=\"ATN\",H30=\"EQV\",H30=\"EXE\",H30=\"( S )\"),\"\",VLOOKUP(H30,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,"report sans formule",null,null,null,{"$f":"IF(H29=\"\",\"\",IF(OR(H29=\"E\",H29=\"E*\",H29=\"F\",H29=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 19",3,"SN"]
[null,null,null,"MOYENNE CUMULATIVE                       avec notes contributoires",null,null,"Case C",{"$f":"IF(J32=0,\"\",CONCATENATE(\" Arrondie à 3 décimales, moyenne cheminement en \",(VLOOKUP(G32,Matrices!G3:H11,2,TRUE))))","v":""},null,"Case A*","Case B*",null,"A","B","C:MC","Type Prog",{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"E\",H30=\"E*\",H30=\"F\",H30=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 20",3,"F*"]
["l Dans le cas d'un cours à option échoué non repris avec succès ou substitué (sous approbation du responsable), la note (E = 0,5  F = 0  F*= 0) demeure contributoire à la moyenne cumulative (case A) et aux crédits obtenus associés à la structure du programme (case B)",null,null,null,null,null,{"$f":"IF(J32=\"\",\"\",IF(J32<>0,R32/J32,\"\"))","v":""},null,null,{"$f":" SUM(J11:J30)","v":0},{"$f":"SUM(K11:K30)","v":0},null,{"$f":"J32","v":0},{"$f":"K32","v":0},{"$f":"G32","v":""},{"$f":"F5","v":"Certificat (30 crédits)"},{"$f":"COUNTIF(Q12:Q31, \"échec\")","v":0},{"$f":"SUM(R12:R31)","v":0},{"$f":"SUM(S12:S31)","v":0},{"$f":"SUM(T12:T31)","v":0},{"$f":"SUM(U12:U31)","v":0},{"$f":"SUM(V12:V31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits suivis, incluant les ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,"Case A*","Pour compléter un programme, il est nécessaire que les exigences de la structure du programme soient respectées. Même complété, il se peut que le nombre inscrit en case B soit supérieur au total de la structure, mais ne peut être inférieur à celui-ci ."]
[]
["l Le résultat à la case B peut être supérieur au nombre de crédits du programme.          ",null,null,"Case B*","La moyenne cumulative est calculée seulement à partir de crédits dont la note est contributoire à la moyenne cumulative (en fonction du nombre de crédits contributoires obtenu à la case A)"]
["Mise en garde - Les résultats obtenus à partir de ce tableau sont à titre suggestifs selon les entrées de données réelles ou hypothétiques. Seuls sont officiels les résultats des relevés de notes de l’étudiant émis par le Bureau du registraire de l’Université de Montréal."]

{"sheet":"1. Moyenne - Programme B","index":2,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,2],[35,4,35,10],[36,0,36,10],[58,31,58,40],[28,3,28,4],[29,3,29,4],[29,12,29,15],[30,3,31,5],[30,7,31,8],[31,0,34,2],[32,3,32,10],[33,3,34,3],[33,4,34,10],[24,0,30,2],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[15,0,15,2],[15,3,15,4],[16,0,19,2],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,0,23,2],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[14,0,14,2],[14,3,14,4],[8,16,9,16],[8,17,9,17],[8,18,9,18],[10,0,13,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[8,19,9,19],[8,20,9,20],[8,21,9,21],[5,0,6,2],[5,3,6,4],[5,5,5,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[7,0,7,4],[8,0,8,4],[0,0,0,10],[1,0,1,5],[3,0,3,10],[4,0,4,1],[4,2,4,3],[4,5,4,7],[4,8,4,10]]}
["TABLEAU 1 - Aide au calcul de la moyenne cumulative par programme (FEP-UdeM 1er cycle) màj 2021-04-23"]
["Le calcul de la moyenne cumulative est présenté à",null,null,null,null,null,"l'article 11 ","du Règlement des études de premier cycle"]
[]
[" Veuillez faire vos entrées ou vos modifications à partir des choix des listes déroulantes dans les champs en jaune"]
["ÉTAPE 1 4  ",null," Certificat, par défaut  4  ",null,null,"Certificat (30 crédits)",null,null,"3 modifier SI AUTRE TYPE de programme "]
["IMPORTANT  ",null,null,"ÉTAPE 2 4",null,"Entrer vos données dans ces 3 colonnes"]
[null,null,null,null,null,6,6,6,"VALEUR DE LA NOTE contributoire à la moyenne","Crédits qui contribuent au calcul de la moyenne cumulative du programme","Crédits obtenus associés à la structure du programme d’études"]
["Pour des calculs précis, NE PAS INCLURE les cours faits en Surplus ou Hors programme.",null,null,null,null,"entrée facultative","entrée obligatoire","entrée obligatoire"]
["Dans les deux cas, ils ne font pas partie de la structure du programme.  Ils ne sont contributoires ni à la moyenne cumulative (case C) ni au cumul de crédits (case B)",null,null,null,null,"SIGLE de COURS ","CRÉDITS SUIVIS                        3 par défaut","NOTE ",null,null,null,null,null,null,null,null,"Nb échecs","POINTS = valeur de la note multipliée par crédits","Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits SUIVIS, inclus ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,null,null,"Colonne1","3","Colonne2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour test"]
["Il est INUTILE D'INCLURE ICI                les cours pour lesquels les résultats sont ABA, EF, ATN ou REM car non contributoires à la structure du programme.",null,null,"Cours  1",null,null,3,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( S )\"),\"\",VLOOKUP(H11,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H11=\"\",\"\",IF(H11=\"EXE\",\"\",IF(H11=\"EQV\",\"\",IF(H11=\"( S )\",\"\", IF(H11= \"( E) \",\"\",IF(H11= \"SN\",\"\",IF(H11=\"EF\",\"\",IF(H11=\"REM\",\"\",IF(H11=\"ATN\",\"\",IF(H11=\"ABA\",\"\",G11))))))))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \", H11=\"SN\", H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",   H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),    \"\",G11))","v":""}]
[null,null,null,"Cours  2",null,null,3,null,{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( S )\"),\"\",VLOOKUP(H12,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H12=\"\",\"\",IF(H12=\"EXE\",\"\",IF(H12=\"EQV\",\"\",IF(H12=\"( S )\",\"\", IF(H12= \"( E) \",\"\",IF(H12= \"SN\",\"\",IF(H12=\"EF\",\"\",IF(H12=\"REM\",\"\",IF(H12=\"ATN\",\"\",IF(H12=\"ABA\",\"\",G12))))))))))","v":""},{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \", H12=\"SN\", H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",   H12=\"E\",H12=\"E*\",H12=\"F\",H12=\"F*\" ),    \"\",G12))","v":""},null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),\"échec\",\"\"))","v":""},{"$f":"IF(OR(H11=\"\",H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( s )\"),\"\",I11*J11)","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\",H11=\"EQV\",H11=\"EXE\"),\"\",G11))","v":""},{"$f":"IF(I11<>\"\",IF(S12<>\"\",I11*S12,\"\"),\"\")","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\"),\"\",G11))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EXE\",H11=\"EQV\"),\"\",G11))","v":""},"sigle 1",3,"A+"]
[null,null,null,"Cours  3",null,null,3,null,{"$f":"IF(H13=\"\",\"\",IF(OR(H13=\"( E) \",H13=\"SN\",H13=\"ABA\",H13=\"EF\",H13=\"REM\",H13=\"ATN\",H13=\"EQV\",H13=\"EXE\",H13=\"( S )\"),\"\",VLOOKUP(H13,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"",{"$f":"IF(OR(K12=\"\",H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( s )\"),\"\",I12*J12)","v":""},"","","","","sigle 2",3,"C+"]
[null,null,null,"Cours  4",null,null,3,null,{"$f":"IF(H14=\"\",\"\",IF(OR(H14=\"( E) \",H14=\"SN\",H14=\"ABA\",H14=\"EF\",H14=\"REM\",H14=\"ATN\",H14=\"EQV\",H14=\"EXE\",H14=\"( S )\"),\"\",VLOOKUP(H14,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 3",3,"A"]
["Pour une REPRISE de COURS :",null,null,"Cours  5",null,null,3,null,{"$f":"IF(H15=\"\",\"\",IF(OR(H15=\"( E) \",H15=\"SN\",H15=\"ABA\",H15=\"EF\",H15=\"REM\",H15=\"ATN\",H15=\"EQV\",H15=\"EXE\",H15=\"( S )\"),\"\",VLOOKUP(H15,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 4",3,"B-"]
["En vertu de l'article 13",null,null,"Cours  6",null,null,3,null,{"$f":"IF(H16=\"\",\"\",IF(OR(H16=\"( E) \",H16=\"SN\",H16=\"ABA\",H16=\"EF\",H16=\"REM\",H16=\"ATN\",H16=\"EQV\",H16=\"EXE\",H16=\"( S )\"),\"\",VLOOKUP(H16,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 5",3,"B+"]
["l Assurez-vous de remplacer par la nouvelle note celle d'un cours préalablement échoué    (E = 0,5        F = 0  F*= 0)",null,null,"Cours  7",null,null,3,null,{"$f":"IF(H17=\"\",\"\",IF(OR(H17=\"( E) \",H17=\"SN\",H17=\"ABA\",H17=\"EF\",H17=\"REM\",H17=\"ATN\",H17=\"EQV\",H17=\"EXE\",H17=\"( S )\"),\"\",VLOOKUP(H17,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 6",3,"B"]
[null,null,null,"Cours  8",null,null,3,null,{"$f":"IF(H18=\"\",\"\",IF(OR(H18=\"( E) \",H18=\"SN\",H18=\"ABA\",H18=\"EF\",H18=\"REM\",H18=\"ATN\",H18=\"EQV\",H18=\"EXE\",H18=\"( S )\"),\"\",VLOOKUP(H18,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 7",3,"C"]
[null,null,null,"Cours  9",null,null,3,null,{"$f":"IF(H19=\"\",\"\",IF(OR(H19=\"( E) \",H19=\"SN\",H19=\"ABA\",H19=\"EF\",H19=\"REM\",H19=\"ATN\",H19=\"EQV\",H19=\"EXE\",H19=\"( S )\"),\"\",VLOOKUP(H19,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 8",3,"F*"]
[null,null,null,"Cours 10",null,null,3,null,{"$f":"IF(H20=\"\",\"\",IF(OR(H20=\"( E) \",H20=\"SN\",H20=\"ABA\",H20=\"EF\",H20=\"REM\",H20=\"ATN\",H20=\"EQV\",H20=\"EXE\",H20=\"( S )\"),\"\",VLOOKUP(H20,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 9",3,"C-"]
["l La note d'une reprise approuvée d'un cours déjà réussi est la seule note qui sera retenue, même si elle devait être inférieure à la note initiale. ",null,null,"Cours 11",null,null,3,null,{"$f":"IF(H21=\"\",\"\",IF(OR(H21=\"( E) \",H21=\"SN\",H21=\"ABA\",H21=\"EF\",H21=\"REM\",H21=\"ATN\",H21=\"EQV\",H21=\"EXE\",H21=\"( S )\"),\"\",VLOOKUP(H21,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 10",3,"D"]
[null,null,null,"Cours 12",null,null,3,null,{"$f":"IF(H22=\"\",\"\",IF(OR(H22=\"( E) \",H22=\"SN\",H22=\"ABA\",H22=\"EF\",H22=\"REM\",H22=\"ATN\",H22=\"EQV\",H22=\"EXE\",H22=\"( S )\"),\"\",VLOOKUP(H22,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 11",3,"E*"]
[null,null,null,"Cours 13",null,null,3,null,{"$f":"IF(H23=\"\",\"\",IF(OR(H23=\"( E) \",H23=\"SN\",H23=\"ABA\",H23=\"EF\",H23=\"REM\",H23=\"ATN\",H23=\"EQV\",H23=\"EXE\",H23=\"( S )\"),\"\",VLOOKUP(H23,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 12",3,"D+"]
[null,null,null,"Cours 14",null,null,3,null,{"$f":"IF(H24=\"\",\"\",IF(OR(H24=\"( E) \",H24=\"SN\",H24=\"ABA\",H24=\"EF\",H24=\"REM\",H24=\"ATN\",H24=\"EQV\",H24=\"EXE\",H24=\"( S )\"),\"\",VLOOKUP(H24,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 13",3,"E*"]
["IMPORTANT de remplacer  la note initiale par la note de reprise.        l Retenir que l'échec à la reprise d'un cours préalablement réussi vaut  E* = 1,0     contrairement      à   E =  0,5  pour l'échec d'un cours ne faisant pas l'objet d'une reprise.",null,null,"Cours 15",null,null,3,null,{"$f":"IF(H25=\"\",\"\",IF(OR(H25=\"( E) \",H25=\"SN\",H25=\"ABA\",H25=\"EF\",H25=\"REM\",H25=\"ATN\",H25=\"EQV\",H25=\"EXE\",H25=\"( S )\"),\"\",VLOOKUP(H25,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 14",3,"EQV"]
[null,null,null,"Cours 16",null,null,3,null,{"$f":"IF(H26=\"\",\"\",IF(OR(H26=\"( E) \",H26=\"SN\",H26=\"ABA\",H26=\"EF\",H26=\"REM\",H26=\"ATN\",H26=\"EQV\",H26=\"EXE\",H26=\"( S )\"),\"\",VLOOKUP(H26,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 15",3,"F*"]
[null,null,null,"Cours 17",null,null,3,null,null,"","",null,null,null,null,null,"","","","","","","sigle 16",3,"E"]
[null,null,null,"Cours 18",null,null,3,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"( E) \",H28=\"SN\",H28=\"ABA\",H28=\"EF\",H28=\"REM\",H28=\"ATN\",H28=\"EQV\",H28=\"EXE\",H28=\"( S )\"),\"\",VLOOKUP(H28,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,null,"","","","","","sigle 17",3,"F"]
[null,null,null,"Cours 19",null,null,3,null,null,"","",null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"E\",H28=\"E*\",H28=\"F\",H28=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 18",3,"( S )"]
[null,null,null,"Cours 20",null,null,3,null,{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"( E) \",H30=\"SN\",H30=\"ABA\",H30=\"EF\",H30=\"REM\",H30=\"ATN\",H30=\"EQV\",H30=\"EXE\",H30=\"( S )\"),\"\",VLOOKUP(H30,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,"report sans formule",null,null,null,{"$f":"IF(H29=\"\",\"\",IF(OR(H29=\"E\",H29=\"E*\",H29=\"F\",H29=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 19",3,"SN"]
[null,null,null,"MOYENNE CUMULATIVE                       avec notes contributoires",null,null,"Case C",{"$f":"IF(J32=0,\"\",CONCATENATE(\" Arrondie à 3 décimales, moyenne cheminement en \",(VLOOKUP(G32,Matrices!G3:H11,2,TRUE))))","v":""},null,"Case A*","Case B*",null,"A","B","C:MC","Type Prog",{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"E\",H30=\"E*\",H30=\"F\",H30=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 20",3,"F*"]
["l Dans le cas d'un cours à option échoué non repris avec succès ou substitué (sous approbation du responsable), la note (E = 0,5  F = 0  F*= 0) demeure contributoire à la moyenne cumulative (case A) et aux crédits obtenus associés à la structure du programme (case B)",null,null,null,null,null,{"$f":"IF(J32=\"\",\"\",IF(J32<>0,R32/J32,\"\"))","v":""},null,null,{"$f":" SUM(J11:J30)","v":0},{"$f":"SUM(K11:K30)","v":0},null,{"$f":"J32","v":0},{"$f":"K32","v":0},{"$f":"G32","v":""},{"$f":"F5","v":"Certificat (30 crédits)"},{"$f":"COUNTIF(Q12:Q31, \"échec\")","v":0},{"$f":"SUM(R12:R31)","v":0},{"$f":"SUM(S12:S31)","v":0},{"$f":"SUM(T12:T31)","v":0},{"$f":"SUM(U12:U31)","v":0},{"$f":"SUM(V12:V31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits suivis, incluant les ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,"Case A*","Pour compléter un programme, il est nécessaire que les exigences de la structure du programme soient respectées. Même complété, il se peut que le nombre inscrit en case B soit supérieur au total de la structure, mais ne peut être inférieur à celui-ci ."]
[]
["l Le résultat à la case B peut être supérieur au nombre de crédits du programme.          ",null,null,"Case B*","La moyenne cumulative est calculée seulement à partir de crédits dont la note est contributoire à la moyenne cumulative (en fonction du nombre de crédits contributoires obtenu à la case A)"]
["Mise en garde - Les résultats obtenus à partir de ce tableau sont à titre suggestifs selon les entrées de données réelles ou hypothétiques. Seuls sont officiels les résultats des relevés de notes de l’étudiant émis par le Bureau du registraire de l’Université de Montréal."]

{"sheet":"1. Moyenne - Programme C","index":3,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,2],[35,4,35,10],[36,0,36,10],[58,31,58,40],[28,3,28,4],[29,3,29,4],[29,12,29,15],[30,3,31,5],[30,7,31,8],[31,0,34,2],[32,3,32,10],[33,3,34,3],[33,4,34,10],[24,0,30,2],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[15,0,15,2],[15,3,15,4],[16,0,19,2],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,0,23,2],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[14,0,14,2],[14,3,14,4],[8,16,9,16],[8,17,9,17],[8,18,9,18],[10,0,13,2],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[8,19,9,19],[8,20,9,20],[8,21,9,21],[5,0,6,2],[5,3,6,4],[5,5,5,7],[6,8,8,8],[6,9,8,9],[6,10,8,10],[7,0,7,4],[8,0,8,4],[0,0,0,10],[1,0,1,5],[3,0,3,10],[4,0,4,1],[4,2,4,3],[4,5,4,7],[4,8,4,10]]}
["TABLEAU 1 - Aide au calcul de la moyenne cumulative par programme (FEP-UdeM 1er cycle) màj 2021-04-23"]
["Le calcul de la moyenne cumulative est présenté à",null,null,null,null,null,"l'article 11 ","du Règlement des études de premier cycle"]
[]
[" Veuillez faire vos entrées ou vos modifications à partir des choix des listes déroulantes dans les champs en jaune"]
["ÉTAPE 1 4  ",null," Certificat, par défaut  4  ",null,null,"Certificat (30 crédits)",null,null,"3 modifier SI AUTRE TYPE de programme "]
["IMPORTANT  ",null,null,"ÉTAPE 2 4",null,"Entrer vos données dans ces 3 colonnes"]
[null,null,null,null,null,6,6,6,"VALEUR DE LA NOTE contributoire à la moyenne","Crédits qui contribuent au calcul de la moyenne cumulative du programme","Crédits obtenus associés à la structure du programme d’études"]
["Pour des calculs précis, NE PAS INCLURE les cours faits en Surplus ou Hors programme.",null,null,null,null,"entrée facultative","entrée obligatoire","entrée obligatoire"]
["Dans les deux cas, ils ne font pas partie de la structure du programme.  Ils ne sont contributoires ni à la moyenne cumulative (case C) ni au cumul de crédits (case B)",null,null,null,null,"SIGLE de COURS ","CRÉDITS SUIVIS                        3 par défaut","NOTE ",null,null,null,null,null,null,null,null,"Nb échecs","POINTS = valeur de la note multipliée par crédits","Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits SUIVIS, inclus ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,null,null,"Colonne1","3","Colonne2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour test"]
["Il est INUTILE D'INCLURE ICI                les cours pour lesquels les résultats sont ABA, EF, ATN ou REM car non contributoires à la structure du programme.",null,null,"Cours  1",null,null,3,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( S )\"),\"\",VLOOKUP(H11,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H11=\"\",\"\",IF(H11=\"EXE\",\"\",IF(H11=\"EQV\",\"\",IF(H11=\"( S )\",\"\", IF(H11= \"( E) \",\"\",IF(H11= \"SN\",\"\",IF(H11=\"EF\",\"\",IF(H11=\"REM\",\"\",IF(H11=\"ATN\",\"\",IF(H11=\"ABA\",\"\",G11))))))))))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \", H11=\"SN\", H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",   H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),    \"\",G11))","v":""}]
[null,null,null,"Cours  2",null,null,3,null,{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( S )\"),\"\",VLOOKUP(H12,Matrices!A$3:B$27,2,FALSE)))","v":""},{"$f":"IF(H12=\"\",\"\",IF(H12=\"EXE\",\"\",IF(H12=\"EQV\",\"\",IF(H12=\"( S )\",\"\", IF(H12= \"( E) \",\"\",IF(H12= \"SN\",\"\",IF(H12=\"EF\",\"\",IF(H12=\"REM\",\"\",IF(H12=\"ATN\",\"\",IF(H12=\"ABA\",\"\",G12))))))))))","v":""},{"$f":"IF(H12=\"\",\"\",IF(OR(H12=\"( E) \", H12=\"SN\", H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",   H12=\"E\",H12=\"E*\",H12=\"F\",H12=\"F*\" ),    \"\",G12))","v":""},null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\" ),\"échec\",\"\"))","v":""},{"$f":"IF(OR(H11=\"\",H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EQV\",H11=\"EXE\",H11=\"( s )\"),\"\",I11*J11)","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"( E) \",H11=\"SN\",H11=\"ABA\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"E\",H11=\"E*\",H11=\"F\",H11=\"F*\",H11=\"EQV\",H11=\"EXE\"),\"\",G11))","v":""},{"$f":"IF(I11<>\"\",IF(S12<>\"\",I11*S12,\"\"),\"\")","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\"),\"\",G11))","v":""},{"$f":"IF(H11=\"\",\"\",IF(OR(H11=\"SN\",H11=\"EF\",H11=\"REM\",H11=\"ATN\",H11=\"EXE\",H11=\"EQV\"),\"\",G11))","v":""},"sigle 1",3,"A+"]
[null,null,null,"Cours  3",null,null,3,null,{"$f":"IF(H13=\"\",\"\",IF(OR(H13=\"( E) \",H13=\"SN\",H13=\"ABA\",H13=\"EF\",H13=\"REM\",H13=\"ATN\",H13=\"EQV\",H13=\"EXE\",H13=\"( S )\"),\"\",VLOOKUP(H13,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"",{"$f":"IF(OR(K12=\"\",H12=\"( E) \",H12=\"SN\",H12=\"ABA\",H12=\"EF\",H12=\"REM\",H12=\"ATN\",H12=\"EQV\",H12=\"EXE\",H12=\"( s )\"),\"\",I12*J12)","v":""},"","","","","sigle 2",3,"C+"]
[null,null,null,"Cours  4",null,null,3,null,{"$f":"IF(H14=\"\",\"\",IF(OR(H14=\"( E) \",H14=\"SN\",H14=\"ABA\",H14=\"EF\",H14=\"REM\",H14=\"ATN\",H14=\"EQV\",H14=\"EXE\",H14=\"( S )\"),\"\",VLOOKUP(H14,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 3",3,"A"]
["Pour une REPRISE de COURS :",null,null,"Cours  5",null,null,3,null,{"$f":"IF(H15=\"\",\"\",IF(OR(H15=\"( E) \",H15=\"SN\",H15=\"ABA\",H15=\"EF\",H15=\"REM\",H15=\"ATN\",H15=\"EQV\",H15=\"EXE\",H15=\"( S )\"),\"\",VLOOKUP(H15,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 4",3,"B-"]
["En vertu de l'article 13",null,null,"Cours  6",null,null,3,null,{"$f":"IF(H16=\"\",\"\",IF(OR(H16=\"( E) \",H16=\"SN\",H16=\"ABA\",H16=\"EF\",H16=\"REM\",H16=\"ATN\",H16=\"EQV\",H16=\"EXE\",H16=\"( S )\"),\"\",VLOOKUP(H16,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 5",3,"B+"]
["l Assurez-vous de remplacer par la nouvelle note celle d'un cours préalablement échoué    (E = 0,5        F = 0  F*= 0)",null,null,"Cours  7",null,null,3,null,{"$f":"IF(H17=\"\",\"\",IF(OR(H17=\"( E) \",H17=\"SN\",H17=\"ABA\",H17=\"EF\",H17=\"REM\",H17=\"ATN\",H17=\"EQV\",H17=\"EXE\",H17=\"( S )\"),\"\",VLOOKUP(H17,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 6",3,"B"]
[null,null,null,"Cours  8",null,null,3,null,{"$f":"IF(H18=\"\",\"\",IF(OR(H18=\"( E) \",H18=\"SN\",H18=\"ABA\",H18=\"EF\",H18=\"REM\",H18=\"ATN\",H18=\"EQV\",H18=\"EXE\",H18=\"( S )\"),\"\",VLOOKUP(H18,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 7",3,"C"]
[null,null,null,"Cours  9",null,null,3,null,{"$f":"IF(H19=\"\",\"\",IF(OR(H19=\"( E) \",H19=\"SN\",H19=\"ABA\",H19=\"EF\",H19=\"REM\",H19=\"ATN\",H19=\"EQV\",H19=\"EXE\",H19=\"( S )\"),\"\",VLOOKUP(H19,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 8",3,"F*"]
[null,null,null,"Cours 10",null,null,3,null,{"$f":"IF(H20=\"\",\"\",IF(OR(H20=\"( E) \",H20=\"SN\",H20=\"ABA\",H20=\"EF\",H20=\"REM\",H20=\"ATN\",H20=\"EQV\",H20=\"EXE\",H20=\"( S )\"),\"\",VLOOKUP(H20,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 9",3,"C-"]
["l La note d'une reprise approuvée d'un cours déjà réussi est la seule note qui sera retenue, même si elle devait être inférieure à la note initiale. ",null,null,"Cours 11",null,null,3,null,{"$f":"IF(H21=\"\",\"\",IF(OR(H21=\"( E) \",H21=\"SN\",H21=\"ABA\",H21=\"EF\",H21=\"REM\",H21=\"ATN\",H21=\"EQV\",H21=\"EXE\",H21=\"( S )\"),\"\",VLOOKUP(H21,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 10",3,"D"]
[null,null,null,"Cours 12",null,null,3,null,{"$f":"IF(H22=\"\",\"\",IF(OR(H22=\"( E) \",H22=\"SN\",H22=\"ABA\",H22=\"EF\",H22=\"REM\",H22=\"ATN\",H22=\"EQV\",H22=\"EXE\",H22=\"( S )\"),\"\",VLOOKUP(H22,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 11",3,"E*"]
[null,null,null,"Cours 13",null,null,3,null,{"$f":"IF(H23=\"\",\"\",IF(OR(H23=\"( E) \",H23=\"SN\",H23=\"ABA\",H23=\"EF\",H23=\"REM\",H23=\"ATN\",H23=\"EQV\",H23=\"EXE\",H23=\"( S )\"),\"\",VLOOKUP(H23,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 12",3,"D+"]
[null,null,null,"Cours 14",null,null,3,null,{"$f":"IF(H24=\"\",\"\",IF(OR(H24=\"( E) \",H24=\"SN\",H24=\"ABA\",H24=\"EF\",H24=\"REM\",H24=\"ATN\",H24=\"EQV\",H24=\"EXE\",H24=\"( S )\"),\"\",VLOOKUP(H24,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 13",3,"E*"]
["IMPORTANT de remplacer  la note initiale par la note de reprise.        l Retenir que l'échec à la reprise d'un cours préalablement réussi vaut  E* = 1,0     contrairement      à   E =  0,5  pour l'échec d'un cours ne faisant pas l'objet d'une reprise.",null,null,"Cours 15",null,null,3,null,{"$f":"IF(H25=\"\",\"\",IF(OR(H25=\"( E) \",H25=\"SN\",H25=\"ABA\",H25=\"EF\",H25=\"REM\",H25=\"ATN\",H25=\"EQV\",H25=\"EXE\",H25=\"( S )\"),\"\",VLOOKUP(H25,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 14",3,"EQV"]
[null,null,null,"Cours 16",null,null,3,null,{"$f":"IF(H26=\"\",\"\",IF(OR(H26=\"( E) \",H26=\"SN\",H26=\"ABA\",H26=\"EF\",H26=\"REM\",H26=\"ATN\",H26=\"EQV\",H26=\"EXE\",H26=\"( S )\"),\"\",VLOOKUP(H26,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,"","","","","","","sigle 15",3,"F*"]
[null,null,null,"Cours 17",null,null,3,null,null,"","",null,null,null,null,null,"","","","","","","sigle 16",3,"E"]
[null,null,null,"Cours 18",null,null,3,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"( E) \",H28=\"SN\",H28=\"ABA\",H28=\"EF\",H28=\"REM\",H28=\"ATN\",H28=\"EQV\",H28=\"EXE\",H28=\"( S )\"),\"\",VLOOKUP(H28,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,null,null,null,null,null,"","","","","","sigle 17",3,"F"]
[null,null,null,"Cours 19",null,null,3,null,null,"","",null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",IF(OR(H28=\"E\",H28=\"E*\",H28=\"F\",H28=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 18",3,"( S )"]
[null,null,null,"Cours 20",null,null,3,null,{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"( E) \",H30=\"SN\",H30=\"ABA\",H30=\"EF\",H30=\"REM\",H30=\"ATN\",H30=\"EQV\",H30=\"EXE\",H30=\"( S )\"),\"\",VLOOKUP(H30,Matrices!A$3:B$27,2,FALSE)))","v":""},"","",null,"report sans formule",null,null,null,{"$f":"IF(H29=\"\",\"\",IF(OR(H29=\"E\",H29=\"E*\",H29=\"F\",H29=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 19",3,"SN"]
[null,null,null,"MOYENNE CUMULATIVE                       avec notes contributoires",null,null,"Case C",{"$f":"IF(J32=0,\"\",CONCATENATE(\" Arrondie à 3 décimales, moyenne cheminement en \",(VLOOKUP(G32,Matrices!G3:H11,2,TRUE))))","v":""},null,"Case A*","Case B*",null,"A","B","C:MC","Type Prog",{"$f":"IF(H30=\"\",\"\",IF(OR(H30=\"E\",H30=\"E*\",H30=\"F\",H30=\"F*\" ),\"échec\",\"\"))","v":""},"","","","","","sigle 20",3,"F*"]
["l Dans le cas d'un cours à option échoué non repris avec succès ou substitué (sous approbation du responsable), la note (E = 0,5  F = 0  F*= 0) demeure contributoire à la moyenne cumulative (case A) et aux crédits obtenus associés à la structure du programme (case B)",null,null,null,null,null,{"$f":"IF(J32=\"\",\"\",IF(J32<>0,R32/J32,\"\"))","v":""},null,null,{"$f":" SUM(J11:J30)","v":0},{"$f":"SUM(K11:K30)","v":0},null,{"$f":"J32","v":0},{"$f":"K32","v":0},{"$f":"G32","v":""},{"$f":"F5","v":"Certificat (30 crédits)"},{"$f":"COUNTIF(Q12:Q31, \"échec\")","v":0},{"$f":"SUM(R12:R31)","v":0},{"$f":"SUM(S12:S31)","v":0},{"$f":"SUM(T12:T31)","v":0},{"$f":"SUM(U12:U31)","v":0},{"$f":"SUM(V12:V31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crédits avec notes contributoires     sans échecs","POINTS = valeur multipliée par crédits   sans échecs","Crédits suivis, incluant les ABA","Crédits SUIVIS sauf EXE, EQV, ATN, SN, EF"]
[null,null,null,"Case A*","Pour compléter un programme, il est nécessaire que les exigences de la structure du programme soient respectées. Même complété, il se peut que le nombre inscrit en case B soit supérieur au total de la structure, mais ne peut être inférieur à celui-ci ."]
[]
["l Le résultat à la case B peut être supérieur au nombre de crédits du programme.          ",null,null,"Case B*","La moyenne cumulative est calculée seulement à partir de crédits dont la note est contributoire à la moyenne cumulative (en fonction du nombre de crédits contributoires obtenu à la case A)"]
["Mise en garde - Les résultats obtenus à partir de ce tableau sont à titre suggestifs selon les entrées de données réelles ou hypothétiques. Seuls sont officiels les résultats des relevés de notes de l’étudiant émis par le Bureau du registraire de l’Université de Montréal."]

{"sheet":"2. Moyenne - BAC CUM","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,1,26,7],[27,1,27,7],[28,1,28,7],[29,0,30,7],[16,3,16,4],[16,7,17,7],[19,3,19,4],[20,3,20,4],[21,3,21,4],[21,7,22,7],[15,3,15,4],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,1,5,3],[3,4,5,7],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[11,7,12,7],[14,3,14,4]]}
["TABLEAU 2 - Calculateur de la moyenne du grade par cumul (BACCUM) màj 2021-04-23"]
[]
["Reporter les résultats de la Case A et de la Moyenne Cumulative  obtenus                                                                                            pour chaque programme donnant lieu à un diplôme de 1er cycle *                                                                                                           - ou entrer vos résultats anticipées pour faire vos projections -"]
[null,"Nombre de crédits contributoires à la moyenne de chaque programme (Case A)",null,null," Moyenne cumulative de chaque programme                  Minimale de 2,000 pour diplomation                                                                                                                                                     Valeurs valides entre 2,000 et 4,300"]
[]
[]
[null,null,6,null,null,null,6]
["BACCUM  composé de 3 certificats ou mineures"]
["Programme 1 (30 crédits)",{"$f":"IF(G9=\"\",\"\",IF(AND(C9=\"\",G9<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C9=\"\",\"\",(IF(OR(C9>30,C9<1),\"! Doit être entre 1 et 30 \",\"\")))","v":""},null,{"$f":"IF(C9=\"\",\"\",IF(AND(G9=\"\",C9<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G9=\"\",\"\",(IF(OR(G9>4.3,G9<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
["Programme 2 (30 crédits)",{"$f":"IF(G10=\"\",\"\",IF(AND(C10=\"\",G10<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C10=\"\",\"\",(IF(OR(C10>30,C10<1),\"! Doit être entre 1 et 30 \",\"\")))","v":""},null,{"$f":"IF(C10=\"\",\"\",IF(AND(G10=\"\",C10<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G10=\"\",\"\",(IF(OR(G10>4.3,G10<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
["Programme 3 (30 crédits)","",null,{"$f":"IF(C11=\"\",\"\",(IF(OR(C11>30,C11<1),\"! Doit être entre 1 et 30 \",\"\")))","v":""},null,{"$f":"IF(C11=\"\",\"\",IF(AND(G11=\"\",C11<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G11=\"\",\"\",(IF(OR(G11>4.3,G11<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
[null,"Total:",{"$f":" SUM(C9:C11)","v":0},"Moyenne du BACCUM :",null,null,{"$f":"IF(AND(G9=\"\",G10=\"\",G11=\"\"),\"\",(G9*C9+G10*C10+G11*C11)/(SUM(C9:C11)))","v":""},{"$f":"IF(AND(B9=\"\",B10=\"\",B11=\"\",F9=\"\",F10=\"\",F11=\"\",D9=\"\",D10=\"\",D11=\"\",H9=\"\",H10=\"\",H11=\"\"),\"\",\"! Entrées incomplètes ou erronées. Veuillez rectifier\")","v":""},null,null,{"$f":"IF(AND(H9=\"\",H10=\"\",H11=\"\"),\"\",(H9*D9+H10*D10+H11*D11)/(SUM(D9:D11)))","v":""},"","","",""]
[]
["BACCUM  composé de 1 certificat ou mineure + 1 majeure"]
["Programme 1 (30 crédits)",{"$f":"IF(G15=\"\",\"\",IF(AND(C15=\"\",G15<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C15=\"\",\"\",(IF(OR(C15>30,C15<1),\"! Doit être entre 1 et 30 \",\"\")))","v":""},null,{"$f":"IF(C15=\"\",\"\",IF(AND(G15=\"\",C15<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G15=\"\",\"\",(IF(OR(G15>4.3,G15<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
["Programme 2 (60 crédits)",{"$f":"IF(G16=\"\",\"\",IF(AND(C16=\"\",G16<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C16=\"\",\"\",(IF(OR(C16>60,C16<1),\"! Doit être entre 1 et 60 \",\"\")))","v":""},null,{"$f":"IF(C16=\"\",\"\",IF(AND(G16=\"\",C16<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G16=\"\",\"\",(IF(OR(G16>4.3,G16<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
[null,"Total:",{"$f":"SUM(C15:C16)","v":0},"Moyenne du BACCUM :",null,null,{"$f":"IF(G15=\"\",IF(AND(G16=\"\"),\" \"),(G15*C15+G16*C16)/(SUM(C15:C16)))","v":" "},{"$f":"IF(AND(B15=\"\",B16=\"\",F15=\"\",F16=\"\",D15=\"\",D16=\"\",H15=\"\",H16=\"\"),\"\",\"! Entrées incomplètes ou erronées - veuillez rectifier\")","v":""},null,null,{"$f":"IF(AND(H9=\"\",H10=\"\",H11=\"\"),\"\",(H9*D9+H10*D10+H11*D11)/(SUM(D9:D11)))","v":""},"","","",""]
[]
["BACCUM  composé de 2 majeures (art.18.2f du RDEPC)"]
["Programme 1 (60 crédits)",{"$f":"IF(G20=\"\",\"\",IF(AND(C20=\"\",G20<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C20=\"\",\"\",(IF(OR(C20>60,C20<1),\"! Doit être entre 1 et 60 \",\"\")))","v":""},null,{"$f":"IF(C20=\"\",\"\",IF(AND(G20=\"\",C20<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(G20=\"\",\"\",(IF(OR(G20>4.3,G20<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
["Programme 2 (60 crédits)",{"$f":"IF(G21=\"\",\"\",IF(AND(C21=\"\",G21<>\"\"),\"4 \",\"\"))","v":""},null,{"$f":"IF(C21=\"\",\"\",(IF(OR(C21>60,C21<1),\"! Doit être entre 1 et 60 \",\"\")))","v":""},null,{"$f":"IF(C21=\"\",\"\",IF(AND(G21=\"\",C21<>\"\"),\"4\",\"\"))","v":""},null,{"$f":"IF(G21=\"\",\"\",(IF(OR(G21>4.3,G21<2),\"! Doit être entre 2,00 et 4,30 \",\"\")))","v":""}]
[null,"Total:",{"$f":"SUM(C20:C21)","v":0},"Moyenne du BACCUM :",null,null,{"$f":"IF(G20=\"\",IF(AND(G21=\"\"),\" \"),(G20*C20+G21*C21)/(SUM(C20:C21)))","v":" "},{"$f":"IF(AND(B20=\"\",B21=\"\",F20=\"\",F21=\"\",D20=\"\",D21=\"\",H20=\"\",H21=\"\"),\"\",\"! Entrées incomplètes ou erronées - veuillez rectifier\")","v":""}]
[]
[]
[]
[]
["*","Les microprogrammes donnent lieu à une attestationet et non à un diplôme de 1er cycle et, de ce fait, ne sont pas constitutifs d'un bac par cumul"]
[null,"La moyenne arrondie à 3 décimales est comprise entre 0,000 et 4,300"]
[null,"Pour diplomation, une moyenne minimale de 2,000 est requise"]
["Mise en garde - Les résultats obtenus à partir de ce tableau sont à titre suggestifs selon les entrées de données réelles ou hypothétiques. Seuls sont officiels les résultats des relevés de notes de l’étudiant émis par le Bureau du registraire de l’Université de Montréal."]

{"sheet":"Normes Succès-Progression","index":5,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,0,34,10],[35,0,35,10],[36,0,36,10],[37,0,37,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["IMPORTANT !"]
["Consulter l'article 9 surl'évaluation des apprentissages et l'article 8 sur la limite de crédits autorisée en reconnaissance de crédits et de transfert de cours."]
["Notez que, selon l'article 8, toute demande d'équivalence, d'exemption, de substitution et de transfert de cours doit être acheminée par écrit par l'étudiant à la TGDE du programme."]
["Pour une demande de reconnaissance des acquis expérientiels à la FEP,  veuillez consulter le site (cliquer sur le lien hypertexte)."]

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

{"sheet":"BarèmeNotationFEP note %","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,1,6]]}
["Note en lettres  Chaque unité applique un barème en pourcentage déterminé par son Conseil de programme. À la FEP, le barème appliqué est  inclus dans le plan de cours"]

{"sheet":"Matrices","index":8,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,16,1,17],[11,11,11,12],[0,0,0,1],[0,6,0,7],[0,10,0,11],[0,13,0,14],[1,10,1,11],[1,13,1,14]]}
["NOTE_DOUBLE",null,null,"màj 2021-03-18",null,null,"Commentaires"]
["Notes","Points",null,"Crédits","Nb crédits selon le type de programme :",null,"Seuils moyenne","Progession",null,null,null,null,null,"Programmes",null,null,"Composantes baccum"]
[null,null,null,null,null,null,null,null,null,null,null,"moyenne arrondie à deux décimales",null,"Aucun programme (études libres)"]
["A+",4.3,null,3,30,null,0,"mise en exclusion",null,null,null,null,null,"Certificat (30 crédits)",30,null,"Certificat                      (30 crédits)",30]
["A",4,null,2,15,null,1.65,"mise en probation",null,null,null,null,null,"Mineure (30 crédits)",30,null,"Mineure                      (30 crédits)",30]
["A-",3.7,null,1,12,null,1.95,"limite du seuil de progression",null,null,null,null,null,"Microprogramme de 15 crédits",15,null,"Majeure                       (60 crédits)",60]
["B+",3.3,null,6,9,null,2.0001000000000002,"progression-succès",null,null,null,null,null,"Microprogramme de 12 crédits",12]
["B",3,null,null,null,null,2.6,"progression-succès (bon)",null,null,null,null,null,"Microprogramme de 9 crédits",9]
["B-",2.7,null,null,null,null,2.7,"progression-succès (très bon)",null,null,null,null,null,"Majeure de 60 crédits",60]
["C+",2.2999999999999998,null,null,null,null,3.2,"progression-succès (très bon)",null,null,null,null,null,"Vérification complétée",null,null,"Composantes complétées "]
["C",2,null,null,null,null,3.31,"progression-succès (excellent)",null,null,null,null,null,"Oui",null,null,"Complété",1]
["C-",1.7,null,null,null,null,null,null,null,null,null,"Programme complété ?",null,"Non",null,null,"Non complété",0]
["D+",1.3,null,null,null,null,null,null,null,null,null,"OUI, si case B indique AU MOINS 30 crédits cumulés pour certificat/mineure ou 60 crédits  pour majeure",1,"Besoin d'aide",null,null,"Non applicable à microprog  et à études libres",0]
["D",1,null,null,null,null,null,null,null,null,null,"NON,  si case B  indique MOINS DE 30 crédits cumulés pour certificat/mineure ou 60 crédits  pour majeure",0,"Autre",null,null,"Voulez-vous conserver ces résultats pour le calcul du BACCUM ?"]
["E*",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUI, à titre du 1er programme"]
["E",0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUI, à titre du 2e programme"]
["F",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUI, à titre du 3e programme"]
["F*",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON"]
["EXE"]
["EXP"]
["EQV"]
["SN"]
["( S )"]
["( E) "]
[]
[]
[]
[null," "]