{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Accueil","Répartition C2","Générateur C2","Répartition C3","Générateur C3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Générateur d'emploi du temps "]
[]
[]
[null,"Il a pour objectif de simplifier l'organisation hebdomadaire de l'emploi du temps."]
[null,"En fonction des domaines que vous afficherez il calcule leur cumul de temps sur la semaine et vous donne une appréciation "]
[null,"par rapport à une durée conseillée (tableau sous l'emploi du temps)"]
[]
[]
[]
[null,"Cliquez ici pour accéder à l'emploi du temps au cycle des apprentissages fondamentaux"]
[]
[null,"Cliquez ici pour accéder à l'emploi du temps au cycle des approfondissements"]

{"sheet":"Répartition C2","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,1,4,9]]}
[]
[null,"Cycle des apprentissages fondamentaux"]
[]
[null,"La proposition de répartition horaire pour l'Académie de Strasbourg prend en compte  l'heure d'enseignement religieux et moral."]
[]
[]
[null,"Pour accéder au générateur d'emploi du temps pour le cycle des apprentissages fondamentaux cliquez ici."]

{"sheet":"Générateur C2","index":2,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,2,52,3],[52,5,52,6],[56,5,56,6],[57,5,57,6],[59,5,59,6],[53,2,53,3],[53,5,53,6],[54,2,54,3],[54,5,54,6],[55,2,55,3],[55,5,55,6],[47,2,47,4],[47,5,47,6],[39,0,39,1],[39,2,40,3],[39,4,40,4],[39,5,40,8],[41,2,41,4],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6]]}
[null,null,null,"Emploi du temps de la classe de ",null,"_____________"]
[]
["Cet emploi du temps est uniquement à but indicatif puisque les horaires peuvent être annualisés."]
[]
[]
[]
[]
["Cycle des apprentissages fondamentaux"]
["Indiquer dans ces cellules l'horaire de début des cours du matin et de l'après-midi"]
["È",null,null,"Lundi","Mardi","Jeudi","Vendredi"]
["08:00:00","à",{"$f":"A11+0.25/24","v":"08:15:00"}]
[{"$f":"A11+0.25/24","v":"08:15:00"},"à","08:30:00"]
["08:30:00","à","08:45:00"]
["08:45:00","à","09:00:00"]
["09:00:00","à","09:15:00"]
["09:15:00","à","09:30:00"]
["09:30:00","à","09:45:00"]
["09:45:00","à","10:00:00"]
["10:00:00","à","10:15:00"]
["10:15:00","à","10:30:00"]
["10:30:00","à","10:45:00"]
["10:45:00","à","11:00:00"]
["11:00:00","à","11:15:00"]
["11:15:00","à","11:30:00"]
["È"]
["13:30:00","à","13:45:00"]
[{"$f":"A26+0.25/24","v":"13:45:00"},"à",{"$f":"A27+0.25/24","v":"14:00:00"}]
[{"$f":"A27+0.25/24","v":"14:00:00"},"à",{"$f":"A28+0.25/24","v":"14:15:00"}]
["14:15:00","à","14:30:00"]
["14:30:00","à","14:45:00"]
["14:45:00","à","15:00:00"]
["15:00:00","à","15:15:00"]
["15:15:00","à","15:30:00"]
["15:30:00","à","15:45:00"]
["15:45:00","à","16:00:00"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:E47)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(E45:E48)","v":"00:00:00"}]
[]
["Horaires",null,"Domaines",null,"Volume horaire","Observations"]
["Min","Max"]
["08:45:00","09:15:00","Français",null,null,{"$f":"IF(J37<A42,\"  Revoir la répartition (horaire minimum : \"&HOUR(A42)&\"h\"&(IF(MINUTE(A42)>9,MINUTE(A42),\"0\"&MINUTE(A42))&\")\"),IF(#REF!>B42,\"Revoir la répartition (horaire maximum : \"&HOUR(B42)&\"h\"&(IF(MINUTE(B42)>9,MINUTE(B42),\"0\"&MINUTE(B42))&\")\"),\"\"))","v":"  Revoir la répartition (horaire minimum : 8h45)"},null,{"$f":"IF(J37<A42,IF(N(A42)-N(J37)<=(N(C14)-N(A14)),\"  - écart acceptable \",\"  - défaut de \"),(IF(J37>B42,IF(N(J37)-N(B42)<=(N(C14)-N(A14)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H42<>\"\",(IF(HOUR(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),0)))>0,HOUR(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),\"\")))&\"h\",\"\")&IF(MINUTE(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),0)))>9,MINUTE(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),0)))&\"mn\",IF(MINUTE(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),0)))>0,\"0\"&MINUTE(IF(J37<A42,N(A42)-N(J37),IF(J37>B42,N(J37)-N(B42),0)))&\"mn\",\"\"))),\"\")","v":"8h45mn"}]
[null,null,null,"Langage oral",{"$f":"(COUNTIF($D$11:$G$35,$D43))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"SUM(E49:E52)","v":"00:00:00"}]
[null,null,null,"Lecture - Ecriture","00:00:00",null,null,null,null,"Langage oral"]
[null,null,null,"Vocabulaire","00:00:00",null,null,null,null,"Lecture - Ecriture"]
[null,null,null,"Grammaire","00:00:00",null,null,null,null,"Vocabulaire"]
[null,null,null,"Othographe","00:00:00",null,null,null,null,"Grammaire"]
["04:15:00","04:45:00","Mathématiques",null,null,{"$f":"IF(J43<A48,\"  Revoir la répartition (horaire minimum : \"&HOUR(A48)&\"h\"&(IF(MINUTE(A48)>9,MINUTE(A48),\"0\"&MINUTE(A48))&\")\"),IF(J43>B48,\"Revoir la répartition (horaire maximum : \"&HOUR(B48)&\"h\"&(IF(MINUTE(B48)>9,MINUTE(B48),\"0\"&MINUTE(B48))&\")\"),\"\"))","v":"  Revoir la répartition (horaire minimum : 4h15)"},null,{"$f":"IF(J43<A48,IF(N(A48)-N(J43)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - défaut de \"),(IF(J43>B48,IF(N(J43)-N(B48)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H48<>\"\",(IF(HOUR(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),0)))>0,HOUR(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),\"\")))&\"h\",\"\")&IF(MINUTE(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),0)))>9,MINUTE(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),0)))&\"mn\",IF(MINUTE(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),0)))>0,\"0\"&MINUTE(IF(J43<A48,N(A48)-N(J43),IF(J43>B48,N(J43)-N(B48),0)))&\"mn\",\"\"))),\"\")","v":"4h15mn"},"Othographe"]
[null,null,null,"Nombres et calcul","00:00:00",null,null,null,null,"Nombres et calcul"]
[null,null,null,"Géométrie","00:00:00",null,null,null,null,"Géométrie"]
[null,null,null,"Grandeur et mesures","00:00:00",null,null,null,null,"Grandeur et mesures"]
[null,null,null,"Organisation et gestion des données",{"$f":"(COUNTIF($D$11:$G$35,$J52))*0.25/24","v":"00:00:00"},null,null,null,null,"Gestion données"]
["01:45:00","02:15:00","Langue vivante",null,{"$f":"(COUNTIF($D$11:$G$35,$C53))*0.25/24","v":"00:00:00"},{"$f":"IF(E53<A53,\"  Volume horaire insuffisant (minimum : \"&HOUR(A53)&\"h\"&(IF(MINUTE(A53)>9,MINUTE(A53),\"0\"&MINUTE(A53))&\")\"),IF(E53>B53,\"Volume horaire trop important (maximum : \"&HOUR(B53)&\"h\"&(IF(MINUTE(B53)>9,MINUTE(B53),\"0\"&MINUTE(B53))&\")\"),\"\"))","v":"  Volume horaire insuffisant (minimum : 1h45)"},null,{"$f":"IF(E53<A53,IF(N(A53)-N(E53)<=(N(C16)-N(A16)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E53>B53,IF(N(E53)-N(B53)<=(N(C16)-N(A16)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H53<>\"\",(IF(HOUR(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),0)))>0,HOUR(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),\"\")))&\"h\",\"\")&IF(MINUTE(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),0)))>9,MINUTE(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),0)))&\"mn\",IF(MINUTE(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),0)))>0,\"0\"&MINUTE(IF(E53<A53,N(A53)-N(E53),IF(E53>B53,N(E53)-N(B53),0)))&\"mn\",\"\"))),\"\")","v":"1h45mn"},"Langue vivante"]
["01:15:00","01:45:00","Pratique artistique et HDA",null,{"$f":"(COUNTIF($D$11:$G$35,$C54))*0.25/24","v":"00:00:00"},"  Volume horaire insuffisant (minimum : 1h15)",null,{"$f":"IF(E54<A54,IF(N(A54)-N(E54)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E54>B54,IF(N(E54)-N(B54)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h15mn","Pratique artist. et HDA"]
["02:15:00","02:45:00","E.P.S.",null,{"$f":"(COUNTIF($D$11:$G$35,$C55))*0.25/24","v":"00:00:00"},"  Volume horaire insuffisant (minimum : 2h15)",null,{"$f":"IF(E55<A55,IF(N(A55)-N(E55)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E55>B55,IF(N(E55)-N(B55)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"2h15mn","E.P.S."]
["01:15:00","01:45:00","Découverte du monde",null,{"$f":"(COUNTIF($D$11:$G$35,$C56))*0.25/24","v":"00:00:00"},"  Volume horaire insuffisant (minimum : 1h15)",null,{"$f":"IF(E56<A56,IF(N(A56)-N(E56)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E56>B56,IF(N(E56)-N(B56)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h15mn","Découverte du monde"]
["02:00:00","02:00:00",null,"Récréation","00:00:00","  Volume horaire insuffisant (minimum : 2h00)",null,{"$f":"IF(E57<A57,IF(N(A57)-N(E57)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E57>B57,IF(N(E57)-N(B57)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"2h","Récréation"]
["01:00:00","01:00:00",null,"Religion","00:00:00","  Volume horaire insuffisant (minimum : 1h00)",null,{"$f":"IF(E58<A58,IF(N(A58)-N(E58)<=(N(C19)-N(A19)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E58>B58,IF(N(E58)-N(B58)<=(N(C19)-N(A19)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h","Religion"]

{"sheet":"Répartition C3","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,1,4,9]]}
[]
[null,"Cycle des appronfondissements"]
[]
[null,"La proposition de répartition horaire pour l'Académie de Strasbourg prend en compte  l'heure d'enseignement religieux et moral."]
[]
[]
[null,"Pour accéder au générateur d'emploi du temps pour le cycle des approfondissements cliquez ici."]

{"sheet":"Générateur C3","index":4,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,3,0,4],[49,2,49,3],[50,2,50,3],[51,2,51,3],[51,5,51,6],[37,2,37,3],[38,2,38,3],[39,2,39,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[47,2,47,3],[47,5,47,6],[48,2,48,3],[48,5,48,6],[49,5,49,6],[50,5,50,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[46,2,46,3],[46,5,46,6],[45,5,45,6],[45,2,45,3],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,2,40,4],[40,5,40,6],[34,0,34,1],[34,2,35,3],[34,4,35,4],[34,5,35,8],[36,2,36,4],[36,5,36,6]]}
[null,null,null,"Emploi du temps de la classe de ",null," ______________"]
[]
["Cet emploi du temps est uniquement à but indicatif puisque les horaires peuvent être annualisés."]
[]
[]
["Cycle 3"]
["Indiquer dans ces cellules l'horaire de début des cours du matin et de l'après-midi"]
["È",null,null,"Lundi","Mardi","Jeudi","Vendredi"]
["08:00:00","à",{"$f":"A9+0.25/24","v":"08:15:00"}]
[{"$f":"A9+0.25/24","v":"08:15:00"},"à",{"$f":"A10+0.25/24","v":"08:30:00"}]
[{"$f":"A10+0.25/24","v":"08:30:00"},"à","08:45:00"]
["08:45:00","à","09:00:00"]
["09:00:00","à","09:15:00"]
["09:15:00","à","09:30:00"]
["09:30:00","à","09:45:00"]
["09:45:00","à","10:00:00"]
["10:00:00","à","10:15:00"]
["10:15:00","à","10:30:00"]
["10:30:00","à","10:45:00"]
["10:45:00","à","11:00:00"]
["11:00:00","à","11:15:00"]
["11:15:00","à","11:30:00"]
["È"]
["13:30:00","à",{"$f":"A24+0.25/24","v":"13:45:00"}]
[{"$f":"A24+0.25/24","v":"13:45:00"},"à",{"$f":"A25+0.25/24","v":"14:00:00"}]
["14:00:00","à","14:15:00"]
["14:15:00","à","14:30:00"]
["14:30:00","à","14:45:00"]
["14:45:00","à","15:00:00"]
["15:00:00","à","15:15:00"]
["15:15:00","à","15:30:00"]
["15:30:00","à","15:45:00"]
["15:45:00","à","16:00:00"]
[]
["Horaires",null,"Domaines",null,"Volume horaire","Observations",null,null,null,{"$f":"SUM(E38:E40)","v":"00:00:00"}]
["Min","Max",null,null,null,null,null,null,null,{"$f":"SUM(E42:E45)","v":"00:00:00"}]
["07:00:00","07:45:00","Français",null,null,{"$f":"IF(J35<A37,\"  Revoir la répartition (horaire minimum : \"&HOUR(A37)&\"h\"&(IF(MINUTE(A37)>9,MINUTE(A37),\"0\"&MINUTE(A37))&\")\"),IF(J35>B37,\"Revoir la répartition (horaire maximum : \"&HOUR(B37)&\"h\"&(IF(MINUTE(B37)>9,MINUTE(B37),\"0\"&MINUTE(B37))&\")\"),\"\"))","v":"  Revoir la répartition (horaire minimum : 7h00)"},null,{"$f":"IF(J35<A37,IF(N(A37)-N(J35)<=(N(C9)-N(A9)),\"  - écart acceptable \",\"  - défaut de \"),(IF(J35>B37,IF(N(J35)-N(B37)<=(N(C9)-N(A9)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H37<>\"\",(IF(HOUR(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),0)))>0,HOUR(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),\"\")))&\"h\",\"\")&IF(MINUTE(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),0)))>9,MINUTE(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),0)))&\"mn\",IF(MINUTE(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),0)))>0,\"0\"&MINUTE(IF(J35<A37,N(A37)-N(J35),IF(J35>B37,N(J35)-N(B37),0)))&\"mn\",\"\"))),\"\")","v":"7h"}]
[null,null,"Langage oral",null,{"$f":"(COUNTIF($D$9:$G$33,$J39))*0.25/24","v":"00:00:00"}]
[null,null,"Lecture - Ecriture",null,{"$f":"(COUNTIF($D$9:$G$33,$J40))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"$C$38","v":"Langage oral"}]
[null,null,"Etude de la langue",null,{"$f":"(COUNTIF($D$9:$G$33,J41))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"$C$39","v":"Lecture - Ecriture"}]
["04:15:00","04:30:00","Mathématiques",null,null,{"$f":"IF(J36<A41,\"  Revoir la répartition (horaire minimum : \"&HOUR(A41)&\"h\"&(IF(MINUTE(A41)>9,MINUTE(A41),\"0\"&MINUTE(A41))&\")\"),IF(J36>B41,\"Revoir la répartition (horaire maximum : \"&HOUR(B41)&\"h\"&(IF(MINUTE(B41)>9,MINUTE(B41),\"0\"&MINUTE(B41))&\")\"),\"\"))","v":"  Revoir la répartition (horaire minimum : 4h15)"},null,{"$f":"IF(J36<A41,IF(N(A41)-N(J36)<=(N(C15)-N(A15)),\"  - écart acceptable \",\"  - défaut de \"),(IF(J36>B41,IF(N(J36)-N(B41)<=(N(C15)-N(A15)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H41<>\"\",(IF(HOUR(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),0)))>0,HOUR(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),\"\")))&\"h\",\"\")&IF(MINUTE(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),0)))>9,MINUTE(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),0)))&\"mn\",IF(MINUTE(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),0)))>0,\"0\"&MINUTE(IF(J36<A41,N(A41)-N(J36),IF(J36>B41,N(J36)-N(B41),0)))&\"mn\",\"\"))),\"\")","v":"4h15mn"},{"$f":"C40","v":"Etude de la langue"}]
[null,null,"Nombres et calcul",null,{"$f":"(COUNTIF($D$9:$G$33,$J42))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"$C$42","v":"Nombres et calcul"}]
[null,null,"Géométrie",null,{"$f":"(COUNTIF($D$9:$G$33,J43))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"$C$43","v":"Géométrie"}]
[null,null,"Grandeurs et mesures",null,{"$f":"(COUNTIF($D$9:$G$33,$J44))*0.25/24","v":"00:00:00"},null,null,null,null,{"$f":"$C$44","v":"Grandeurs et mesures"}]
[null,null,"Gestion de données",null,"00:00:00",null,null,null,null,{"$f":"$C$45","v":"Gestion de données"}]
["01:45:00","02:15:00","Langue étrangère",null,{"$f":"(COUNTIF($D$9:$G$33,$J46))*0.25/24","v":"00:00:00"},{"$f":"IF(E46<A46,\"  Volume horaire insuffisant (minimum : \"&HOUR(A46)&\"h\"&(IF(MINUTE(A46)>9,MINUTE(A46),\"0\"&MINUTE(A46))&\")\"),IF(E46>B46,\"Volume horaire trop important (maximum : \"&HOUR(B46)&\"h\"&(IF(MINUTE(B46)>9,MINUTE(B46),\"0\"&MINUTE(B46))&\")\"),\"\"))","v":"  Volume horaire insuffisant (minimum : 1h45)"},null,{"$f":"IF(E46<A46,IF(N(A46)-N(E46)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E46>B46,IF(N(E46)-N(B46)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H46<>\"\",(IF(HOUR(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),0)))>0,HOUR(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),\"\")))&\"h\",\"\")&IF(MINUTE(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),0)))>9,MINUTE(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),0)))&\"mn\",IF(MINUTE(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),0)))>0,\"0\"&MINUTE(IF(E46<A46,N(A46)-N(E46),IF(E46>B46,N(E46)-N(B46),0)))&\"mn\",\"\"))),\"\")","v":"1h45mn"},{"$f":"C46","v":"Langue étrangère"}]
["01:15:00","01:45:00","Sciences et techno.",null,{"$f":"(COUNTIF($D$9:$G$33,$J48))*0.25/24","v":"00:00:00"},{"$f":"IF(E47<A47,\"  Volume horaire insuffisant (minimum : \"&HOUR(A47)&\"h\"&(IF(MINUTE(A47)>9,MINUTE(A47),\"0\"&MINUTE(A47))&\")\"),IF(E47>B47,\"Volume horaire trop important (maximum : \"&HOUR(B47)&\"h\"&(IF(MINUTE(B47)>9,MINUTE(B47),\"0\"&MINUTE(B47))&\")\"),\"\"))","v":"  Volume horaire insuffisant (minimum : 1h15)"},null,{"$f":"IF(E47<A47,IF(N(A47)-N(E47)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E47>B47,IF(N(E47)-N(B47)<=(N(C17)-N(A17)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},{"$f":"IF(H47<>\"\",(IF(HOUR(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),0)))>0,HOUR(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),\"\")))&\"h\",\"\")&IF(MINUTE(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),0)))>9,MINUTE(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),0)))&\"mn\",IF(MINUTE(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),0)))>0,\"0\"&MINUTE(IF(E47<A47,N(A47)-N(E47),IF(E47>B47,N(E47)-N(B47),0)))&\"mn\",\"\"))),\"\")","v":"1h15mn"},"Pratique artistique"]
["01:15:00","01:45:00","Pratique artistique et HDA",null,{"$f":"(COUNTIF($D$9:$G$33,$J47))*0.25/24","v":"00:00:00"},"  Volume horaire insuffisant (minimum : 1h15)",null,{"$f":"IF(E48<A48,IF(N(A48)-N(E48)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E48>B48,IF(N(E48)-N(B48)<=(N(C18)-N(A18)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h15mn",{"$f":"$C$47","v":"Sciences et techno."}]
["02:15:00","02:30:00","E.P.S.",null,"00:00:00","  Volume horaire insuffisant (minimum : 2h15)",null,{"$f":"IF(E49<A49,IF(N(A49)-N(E49)<=(N(C19)-N(A19)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E49>B49,IF(N(E49)-N(B49)<=(N(C19)-N(A19)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"2h15mn",{"$f":"$C$49","v":"E.P.S."}]
["01:15:00","01:45:00","Culture humaniste",null,"00:00:00","  Volume horaire insuffisant (minimum : 1h15)",null,{"$f":"IF(E50<A50,IF(N(A50)-N(E50)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E50>B50,IF(N(E50)-N(B50)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h15mn",{"$f":"$C$50","v":"Culture humaniste"}]
["02:00:00","02:00:00","Récréation",null,"00:00:00","  Volume horaire insuffisant (minimum : 2h00)",null,{"$f":"IF(E51<A51,IF(N(A51)-N(E51)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E51>B51,IF(N(E51)-N(B51)<=(N(C20)-N(A20)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"2h",{"$f":"$C$51","v":"Récréation"}]
["01:00:00","01:00:00","Religion",null,"00:00:00","  Volume horaire insuffisant (minimum : 1h00)",null,{"$f":"IF(E52<A52,IF(N(A52)-N(E52)<=(N(C21)-N(A21)),\"  - écart acceptable \",\"  - défaut de \"),(IF(E52>B52,IF(N(E52)-N(B52)<=(N(C21)-N(A21)),\"  - écart acceptable \",\"  - excès de \"),\"\")))","v":"  - défaut de "},"1h",{"$f":"$C$52","v":"Religion"}]