{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["TERME","CRÉDITS","BUDGET","DÉPENSES MENSUELLES NETTES","DÉPENSES DU TERME","LIVRES"],"not_rendered":{"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"TERME","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"MON EMPLOI DU TEMPS"]
[null,"PREMIER SEMESTRE"]
[null,null,"HEURE DE DÉBUT","INTERVALLE",null,"ANNÉE"]
[null,null,"09:00:00",60,"(en minutes)"]
[null,"HEURE ","LUN","MAR","MER","JEU","VEN","SAM","DIM"]
[null,{"$f":"HeureDeDébut+TIME(0,(ROW(A1)-1)*Intervalle,0)","v":"09:00:00"},"Petit-déjeuner","Petit-déjeuner","Petit-déjeuner","Petit-déjeuner","Petit-déjeuner"]
[null,"10:00:00","Gestion : Lecture Bât B, salle 256"]
[null,"11:00:00",{"$nulls":3},"Physique : Lab \nBât J, salle 309"]
[null,"12:00:00"]
[null,"13:00:00"]
[null,"14:00:00"]
[null,"15:00:00"]
[null,"16:00:00"]
[null,"17:00:00"]
[null,"18:00:00"]
[null,"19:00:00"]
[null,"20:00:00"]
[null,"21:00:00"]
[null,"22:00:00"]
[null,"23:00:00"]
[null,1]
[null,1.0416666666666665]
[null,1.0833333333333335]
[null,1.125]
[null,1.1666666666666665]
[null,1.2083333333333335]
[null,1.25]
[null,1.2916666666666665]
[null,1.3333333333333335]

{"sheet":"CRÉDITS","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"UNIVERSITÉ"]
[null,"PLANIFICATEUR DE CRÉDIT"]
[null,"Nom du diplôme",{"$f":"Année","v":"ANNÉE"}]
[null,"PROGRESSION GLOBALE",null,"PROGRESSION GLOBALE"]
[null,{"$f":"AVERAGE(Formations[NOTE])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(Formations[TERMINÉ],\"Oui\",Formations[NOTE]),\"0,00\"),\"0,00\")&\" Moyenne cumulative actuelle\"","v":"3,50 Moyenne cumulative actuelle"},{"$f":"COUNTIF(Formations[TERMINÉ],\"Oui\")/COUNTA(Formations[TITRE DU COURS])","v":0.6666666666666666},{"$f":"\"Achevé à \"&TEXT(COUNTIF(Formations[TERMINÉ],\"Oui\")/COUNTA(Formations[TITRE DU COURS]),\"0%\")","v":"Achevé à 67%"}]
[null,"Remarque : La synthèse de crédits suivante est renseignées automatiquement par les données entrées dans la table Cours universitaires ci-dessous"]
[null,"CONDITIONS REQUISES","TOTAL DES CRÉDITS","ACQUIS","REQUIS"]
[null,"Spécialité",{"$f":"IF(SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B8,Formations[CRÉDITS])=0,\"0\",SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B8,Formations[CRÉDITS]))","v":4},{"$f":"SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B8,Formations[TERMINÉ],\"Oui\")","v":4},{"$f":"SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B8,Formations[CRÉDITS])-SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B8,Formations[TERMINÉ],\"Oui\")","v":0}]
[null,"Option",{"$f":"IF(SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B9,Formations[CRÉDITS])=0,\"0\",SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B9,Formations[CRÉDITS]))","v":3},{"$f":"SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B9,Formations[TERMINÉ],\"Oui\")","v":0},{"$f":"SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B9,Formations[CRÉDITS])-SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B9,Formations[TERMINÉ],\"Oui\")","v":3}]
[null,"Cours optionnel",{"$f":"IF(SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B10,Formations[CRÉDITS])=0,\"0\",SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B10,Formations[CRÉDITS]))","v":2},{"$f":"SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B10,Formations[TERMINÉ],\"Oui\")","v":2},{"$f":"SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B10,Formations[CRÉDITS])-SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B10,Formations[TERMINÉ],\"Oui\")","v":0}]
[null,"Études générales",{"$f":"IF(SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B11,Formations[CRÉDITS])=0,\"0\",SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B11,Formations[CRÉDITS]))","v":"0"},{"$f":"SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B11,Formations[TERMINÉ],\"Oui\")","v":0},{"$f":"SUMIF(Formations[CONDITIONS REQUISES],CRÉDITS!$B11,Formations[CRÉDITS])-SUMIFS(Formations[CRÉDITS],Formations[CONDITIONS REQUISES],CRÉDITS!$B11,Formations[TERMINÉ],\"Oui\")","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,CRÉDITS!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,CRÉDITS!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,CRÉDITS!$E$8:$E$11)","v":3}]
[null,"Formations"]
[null,"TITRE DU COURS","N° COURS","CONDITIONS REQUISES","CRÉDITS","TERMINÉ","NOTE","TERME"]
[null,"Cours 1","Nombre","Spécialité",4,"Oui",{"v":4,"d":"4.0"},"Terme 1"]
[null,"Cours 2","Nombre","Option",3,"Non",null,"Terme 1"]
[null,"Cours 3","Nombre","Cours optionnel",2,"Oui",{"v":3,"d":"3.0"},"Terme 1"]

{"sheet":"BUDGET","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[null,{"$f":"Collège","v":"UNIVERSITÉ"}]
[null,"SUIVI DU BUDGET"]
[null,"Mon budget",{"$f":"Année","v":"ANNÉE"}]
[null,"POURCENTAGE DES REVENUS DÉPENSÉ"]
[null,{"$f":"DÉPENSES_MENSUELLES_NETTES/REVENUS_MENSUELS_NETS","v":{"v":0.7454545454545455,"d":"75%"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"REVENUS MENSUELS NETS","DÉPENSES MENSUELLES NETTES","SOLDE"]
[null,{"$f":"C10","v":{"v":2750,"d":"2,750 $"}},{"$f":"'DÉPENSES MENSUELLES NETTES'!C4+'DÉPENSES DU TERME'!D4","v":{"v":2050,"d":"2,050 $"}},{"$f":"REVENUS_MENSUELS_NETS-DÉPENSES_MENSUELLES_NETTES","v":{"v":700,"d":"700 $"}}]
[null,"Mois dans le terme",4]
[null,"REVENUS MENSUELS",{"$f":"SUM(RevenuMensuel[MONTANT])","v":{"v":2750,"d":"2,750 $"}}]
[null,"ARTICLE","MONTANT"]
[null,"Revenu fixe",{"v":1500,"d":"1,500 $"}]
[null,"Aides financières",{"v":500,"d":"500 $"}]
[null,"Emprunts",{"v":500,"d":"500 $"}]
[null,"Autres revenus",{"v":250,"d":"250 $"}]

{"sheet":"DÉPENSES MENSUELLES NETTES","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"Collège","v":"UNIVERSITÉ"}]
[null,"SUIVI DU BUDGET"]
[null,"Dépenses mensuelles",{"$f":"Année","v":"ANNÉE"}]
[null,"DÉPENSES MENSUELLES",{"$f":"SUM(DépensesMensuelles[MONTANT])","v":{"v":1675,"d":"1,675 $"}}]
[null,"ARTICLE","MONTANT"]
[null,"Loyer",{"v":300,"d":"300 $"}]
[null,"Charges",{"v":50,"d":"50 $"}]
[null,"Téléphone portable",{"v":75,"d":"75 $"}]
[null,"Courses",{"v":250,"d":"250 $"}]
[null,"Frais automobile",{"v":50,"d":"50 $"}]
[null,"Prêts étudiant",{"v":500,"d":"500 $"}]
[null,"Carte bancaire",{"v":275,"d":"275 $"}]
[null,"Assurance",{"v":125,"d":"125 $"}]
[null,"Sorties",{"v":50,"d":"50 $"}]
[null,"Divers",{"v":0,"d":"0 $"}]

{"sheet":"DÉPENSES DU TERME","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"Collège","v":"UNIVERSITÉ"}]
[null,"SUIVI DU BUDGET"]
[null,"Dépenses du terme",{"$f":"Année","v":"ANNÉE"}]
[null,"DÉPENSES DU TERME (Totales/Par mois)",{"$f":"SUM(DépensesTerme[MONTANT])","v":{"v":1500,"d":"1,500 $"}},{"$f":"SUM(DépensesTerme[PAR MOIS])","v":{"v":375,"d":"375 $"}}]
[null,"ARTICLE","MONTANT","PAR MOIS"]
[null,"Frais d’inscription",{"v":750,"d":"750 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":187.5,"d":"188 $"}}]
[null,"Frais de laboratoire",{"v":250,"d":"250 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":62.5,"d":"63 $"}}]
[null,"Livres",{"v":500,"d":"500 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":125,"d":"125 $"}}]
[null,"Cautions",{"v":0,"d":"0 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":0,"d":"0 $"}}]
[null,"Transports",{"v":0,"d":"0 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":0,"d":"0 $"}}]
[null,"Autres frais",{"v":0,"d":"0 $"},{"$f":"DépensesTerme[[#This Row],[MONTANT]]/Mois_du_terme","v":{"v":0,"d":"0 $"}}]

{"sheet":"LIVRES","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"Collège","v":"UNIVERSITÉ"}]
[null,"SUIVI DES LECTURES"]
[null,"Liste de livres"]
[null,"TITRE","AUTEUR","COURS","LIEU DE VENTE","ISBN","NOTES"]
[null,"Titre du livre","Auteur","Cours","Lieu","Nombre"]
[null,"Titre du livre","Auteur","Cours","Lieu","Nombre"]
[null,"Titre du livre","Auteur","Cours","Lieu","Nombre"]