{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["NOTICE","Etat_108h","Période 1","Période 2","Période 3","Période 4","Période 5"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"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":"NOTICE","index":0,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[28,6,28,7],[7,3,7,4],[6,3,6,4],[5,3,5,4],[8,3,8,4],[9,3,9,4],[31,1,31,7],[1,1,1,7],[2,1,2,7],[3,1,3,3],[3,4,3,7],[4,1,4,7],[11,1,11,3],[11,4,11,7],[12,1,12,7],[23,1,23,7],[24,1,24,7],[26,6,26,7],[27,6,27,7]]}
[]
[null,"Tableau individuel de suivi des heures du service hebdomadaire ZONE B"]
[]
[null,"INFORMATIONS PERSONNELLES"]
[]
[null,"NOM",":"]
[null,"Prénom",":"]
[null,"Qualité",":",null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16","v":"école 1"}]
[null,"École de rattachement",":",null,null,{"$f":"E15","v":0},{"$f":"F15","v":0},null,null,null,null,null,null,null,{"$f":"E16","v":"école 2"}]
[null,"Circonscription",":",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F16","v":"école3"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Titulaire mobile",null,{"$f":"G16","v":"école 4"}]
[null,"CONSEILS D'UTILISATION",null,null,null,null,null,null,null,null,null,null,"Poste fractionné",null,{"$f":"H16","v":"école 5"}]
[null,"Il y a une feuille par période (entre 2 vacances scolaires). Vous devez remplir préalablement la liste des écoles ci-dessus.\nCette saisie préalable vous permettra par la suite de remplir plus rapidement les feuilles suivantes.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17","v":"école 6"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E17","v":"école 7"}]
[null,"Liste d'écoles d'exercice",":","Dans les cellules \"école\", inscrire pour mémoire, le nom de l'école d'exercice par ordre d’affectation",null,null,null,null,null,null,null,null,null,null,{"$f":"F17","v":"école 8"}]
[null,null,null,"école 1","école 2","école3","école 4","école 5",null,null,null,null,null,null,{"$f":"G17","v":"école 9"}]
[null,null,null,"école 6","école 7","école 8","école 9","école 10",null,null,null,null,null,null,{"$f":"H17","v":"école 10"}]
[null,null,null,"école 11","école 12","école 13","école 14","école 15",null,null,null,null,null,null,{"$f":"D18","v":"école 11"}]
[null,null,null,"école 16","école 17","école 18","école 19","école 20",null,null,null,null,null,null,{"$f":"E18","v":"école 12"}]
[null,null,null,"école 21","école 22","école 23","école 24","école 25",null,null,null,null,null,null,{"$f":"F18","v":"école 13"}]
[null,null,null,"école 26","école 27","école 28","école 29","école 30",null,null,null,null,null,null,{"$f":"G18","v":"école 14"}]
[null,null,null,"école 31","école 32","école 33","école 34","école 35",null,null,null,null,null,null,{"$f":"H18","v":"école 15"}]
[null,"Quotité de service",":",1,null,null,null,null,null,null,null,null,null,null,{"$f":"D19","v":"école 16"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E19","v":"école 17"},null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F19","v":"école 18"}]
[null,null,null,null,"du","au",null,null,null,null,null,null,null,null,{"$f":"G19","v":"école 19"}]
[null,null,"-","Période 1 :","2018-09-03","2018-10-20","Zone B :",null,null,null,null,null,null,null,{"$f":"H19","v":"école 20"}]
[null,null,"-","Période 2 :","2018-11-05","2018-12-22","Aix-Marseille / Amiens / Caen\nLille / Nancy-Metz / Nantes",null,null,null,null,null,null,null,{"$f":"D20","v":"école 21"}]
[null,null,"-","Période 3 :","2019-01-07","2019-02-09","Nice / Orléans-Tours / Reims\nRennes / Rouen / Strasbourg",null,null,null,null,null,null,null,{"$f":"E20","v":"école 22"}]
[null,null,"-","Période 4 :",{"$f":"IF(F29=\"\",\"\",F29+16)","v":"2019-02-25"},{"$f":"IF(E30=\"\",\"\",E30+40)","v":"2019-04-06"},null,null,null,null,null,null,null,null,{"$f":"F20","v":"école 23"}]
[null,null,"-","Période 5 :",{"$f":"IF(F30=\"\",\"\",F30+16)","v":"2019-04-22"},"2019-07-06",null,null,null,null,null,null,null,null,{"$f":"G20","v":"école 24"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H20","v":"école 25"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21","v":"école 26"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E21","v":"école 27"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F21","v":"école 28"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G21","v":"école 29"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H21","v":"école 30"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D22","v":"école 31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E22","v":"école 32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F22","v":"école 33"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G22","v":"école 34"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H22","v":"école 35"}]

{"sheet":"Etat_108h","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,2,3,7],[16,1,16,7],[6,2,6,7],[1,1,1,3],[1,4,1,7],[2,1,2,7]]}
[]
[null,"ETAT DES 108 heures"]
[null,"Vous trouverez ci-dessous un état récapitulatif des 108 heures annuels. Vous devez remplir pour chaque période la ligne rose dévolue aux 108h en selectionnant la catégorie correspondante.\nCatégories proposées:"]
[null,null,"APC: Activités pédagogiques complémentaires (36 heures)"]
[null,null,"FORMATION: Animations pédagogiques et actions de formation (18 heures)"]
[null,null,"CONSEIL D'ECOLE: Participation aux conseils d'école (6 heures)"]
[null,null,"AUTRES: Travaux en équipes pédgogiques, liaison ecole-collège, relation avec les parents, Eléboration et suivi des PPS, \nPréparation des APC …(48 heures)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APC",1.5]
[null,"Etat 108 heures :",null,"Décompte",null,"MAXIMUM",null,null,null,null,null,null,null,null,null,null,"Formation",0.75]
[null,null,"APC",{"$f":"SUM('Période 1:Période 5'!AA12)","v":0},{"$f":"R8*(1-NOTICE!D23)","v":0},{"$f":"R8-E10","v":1.5},null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",0.25]
[null,null,"Formation",{"$f":"SUM('Période 1:Période 5'!AA13)","v":0},{"$f":"R9*(1-NOTICE!D23)","v":0},{"$f":"R9-E11","v":0.75},null,null,null,null,null,null,null,null,null,null,"Autres",2]
[null,null,"Conseil d'école",{"$f":"SUM('Période 1:Période 5'!AA14)","v":0},{"$f":"R10*(1-NOTICE!D23)","v":0},0.25]
[null,null,"Autres",{"$f":"SUM('Période 1:Période 5'!AA15)","v":0},{"$f":"R11*(1-NOTICE!D23)","v":0},2]
[null,null,"TOTAL",{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":4.5}]
[]
[null,"Quotité de service",":",{"$f":"NOTICE!D23","v":1}]

{"sheet":"Période 1","index":2,"n_rows":34,"n_cols":27,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,15,31,15],[32,1,32,15],[33,1,33,12],[29,14,30,14],[30,1,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[29,13,31,13],[23,15,25,15],[26,14,27,14],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[26,13,28,13],[26,15,28,15],[23,14,24,14],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[23,13,25,13],[17,15,19,15],[20,14,21,14],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[20,13,22,13],[20,15,22,15],[17,14,18,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[17,13,19,13],[11,15,13,15],[14,14,15,14],[15,11,15,12],[14,13,16,13],[14,15,16,15],[11,14,12,14],[12,11,12,12],[11,13,13,13],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[5,1,5,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[1,3,1,4],[1,9,1,13],[2,3,2,4],[2,9,2,13],[3,3,3,4]]}
[]
[null,"NOM",":",{"$f":"NOTICE!D6","v":0},null,null,"École de rattachement",null,null,{"$f":"NOTICE!D9","v":0}]
[null,"Prénom",":",{"$f":"NOTICE!D7","v":0},null,null,"Circonscription",null,null,{"$f":"NOTICE!D10","v":0}]
[null,"Qualité",":",{"$f":"NOTICE!D8","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Vous devez remplir préalablement la liste des écoles dans le feuillet NOTICE."]
[null,null,null,null,null,null,null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée en suivant les exemples ci contre ="]
[null,null,null,null,null,null,null,"Pour 6 h de classe, saisir 6:00 / Pour 5h30 de classe, saisir 5:30 / Pour 5h45 de classe saisir 5:45 …"]
[]
[null,"LUNDI",null,"MARDI",null,"MERCREDI",null,"JEUDI",null,"VENDREDI",null,"SAMEDI",null,"Service d'Enseignement effectué",1,"Solde semaine Service d'Enseignement"]
[null,"2018-09-03","horaire",{"$f":"B12+1","v":"2018-09-04"},"horaire",{"$f":"D12+1","v":"2018-09-05"},"horaire",{"$f":"F12+1","v":"2018-09-06"},"horaire",{"$f":"H12+1","v":"2018-09-07"},"horaire",{"$f":"J12+1","v":"2018-09-08"},"horaire",{"$f":"IF(ISNUMBER(C12),C12,0)+IF(ISNUMBER(E12),E12,0)+IF(ISNUMBER(G12),G12,0)+IF(ISNUMBER(I12),I12,0)+IF(ISNUMBER(K12),K12,0)+IF(ISNUMBER(M12),M12,0)","v":0},{"$f":"IF(N12>0,IF(N12-$O$11*NOTICE!$D$23>0,N12-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O12,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"APC",{"$f":"SUMIFS(C14:M32,B14:L32,\"APC\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,null,null,null,null,null,null,null,null,null,null,null,"Formation",{"$f":"SUMIFS(C14:M32,B14:L32,\"Formation\")","v":"00:00:00"}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire",null,null,null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",{"$f":"SUMIFS(C14:M32,B14:L32,\"Conseil ecole\")","v":"00:00:00"}]
[null,{"$f":"B12+7","v":"2018-09-10"},"horaire",{"$f":"B15+1","v":"2018-09-11"},"horaire",{"$f":"D15+1","v":"2018-09-12"},"horaire",{"$f":"F15+1","v":"2018-09-13"},"horaire",{"$f":"H15+1","v":"2018-09-14"},"horaire",{"$f":"J15+1","v":"2018-09-15"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(E15),E15,0)+IF(ISNUMBER(G15),G15,0)+IF(ISNUMBER(I15),I15,0)+IF(ISNUMBER(K15),K15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,IF(N15-$O$11*NOTICE!$D$23>0,N15-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O15,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"Autres",{"$f":"SUMIFS(C14:M32,B14:L32,\"autres\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B15+7","v":"2018-09-17"},"horaire",{"$f":"B18+1","v":"2018-09-18"},"horaire",{"$f":"D18+1","v":"2018-09-19"},"horaire",{"$f":"F18+1","v":"2018-09-20"},"horaire",{"$f":"H18+1","v":"2018-09-21"},"horaire",{"$f":"J18+1","v":"2018-09-22"},"horaire",{"$f":"IF(ISNUMBER(C18),C18,0)+IF(ISNUMBER(E18),E18,0)+IF(ISNUMBER(G18),G18,0)+IF(ISNUMBER(I18),I18,0)+IF(ISNUMBER(K18),K18,0)+IF(ISNUMBER(M18),M18,0)","v":0},{"$f":"IF(N18>0,IF(N18-$O$11*NOTICE!$D$23>0,N18-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O18,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B18+7","v":"2018-09-24"},"horaire",{"$f":"B21+1","v":"2018-09-25"},"horaire",{"$f":"D21+1","v":"2018-09-26"},"horaire",{"$f":"F21+1","v":"2018-09-27"},"horaire",{"$f":"H21+1","v":"2018-09-28"},"horaire",{"$f":"J21+1","v":"2018-09-29"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(E21),E21,0)+IF(ISNUMBER(G21),G21,0)+IF(ISNUMBER(I21),I21,0)+IF(ISNUMBER(K21),K21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,IF(N21-$O$11*NOTICE!$D$23>0,N21-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O21,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B21+7","v":"2018-10-01"},"horaire",{"$f":"B24+1","v":"2018-10-02"},"horaire",{"$f":"D24+1","v":"2018-10-03"},"horaire",{"$f":"F24+1","v":"2018-10-04"},"horaire",{"$f":"H24+1","v":"2018-10-05"},"horaire",{"$f":"J24+1","v":"2018-10-06"},"horaire",{"$f":"IF(ISNUMBER(C24),C24,0)+IF(ISNUMBER(E24),E24,0)+IF(ISNUMBER(G24),G24,0)+IF(ISNUMBER(I24),I24,0)+IF(ISNUMBER(K24),K24,0)+IF(ISNUMBER(M24),M24,0)","v":0},{"$f":"IF(N24>0,IF(N24-$O$11*NOTICE!$D$23>0,N24-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O24,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B24+7","v":"2018-10-08"},"horaire",{"$f":"B27+1","v":"2018-10-09"},"horaire",{"$f":"D27+1","v":"2018-10-10"},"horaire",{"$f":"F27+1","v":"2018-10-11"},"horaire",{"$f":"H27+1","v":"2018-10-12"},"horaire",{"$f":"J27+1","v":"2018-10-13"},"horaire",{"$f":"IF(ISNUMBER(C27),C27,0)+IF(ISNUMBER(E27),E27,0)+IF(ISNUMBER(G27),G27,0)+IF(ISNUMBER(I27),I27,0)+IF(ISNUMBER(K27),K27,0)+IF(ISNUMBER(M27),M27,0)","v":0},{"$f":"IF(N27>0,IF(N27-$O$11*NOTICE!$D$23>0,N27-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O27,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B27+7","v":"2018-10-15"},"horaire",{"$f":"B30+1","v":"2018-10-16"},"horaire",{"$f":"D30+1","v":"2018-10-17"},"horaire",{"$f":"F30+1","v":"2018-10-18"},"horaire",{"$f":"H30+1","v":"2018-10-19"},"horaire",{"$f":"J30+1","v":"2018-10-20"},"horaire",{"$f":"IF(ISNUMBER(C30),C30,0)+IF(ISNUMBER(E30),E30,0)+IF(ISNUMBER(G30),G30,0)+IF(ISNUMBER(I30),I30,0)+IF(ISNUMBER(K30),K30,0)+IF(ISNUMBER(M30),M30,0)","v":0},{"$f":"IF(N30>0,IF(N30-$O$11*NOTICE!$D$23>0,N30-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O30,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[]
[null,"Le solde ne se déclenche que s'il y a un excédent",null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(O12:O31)","v":0}]

{"sheet":"Période 2","index":3,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,1,32,15],[33,1,33,12],[34,1,34,12],[29,14,30,14],[30,1,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[29,13,31,13],[29,15,31,15],[23,15,25,15],[26,14,27,14],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[26,13,28,13],[26,15,28,15],[23,14,24,14],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[23,13,25,13],[17,15,19,15],[20,14,21,14],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[20,13,22,13],[20,15,22,15],[17,14,18,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[17,13,19,13],[11,15,13,15],[14,14,15,14],[15,11,15,12],[14,13,16,13],[14,15,16,15],[11,14,12,14],[12,11,12,12],[11,13,13,13],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[5,1,5,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[1,3,1,4],[1,9,1,13],[2,3,2,4],[2,9,2,13],[3,3,3,4]]}
[]
[null,"NOM",":",{"$f":"NOTICE!D6","v":0},null,null,"École de rattachement",null,null,{"$f":"NOTICE!D9","v":0}]
[null,"Prénom",":",{"$f":"NOTICE!D7","v":0},null,null,"Circonscription",null,null,{"$f":"NOTICE!D10","v":0}]
[null,"Qualité",":",{"$f":"NOTICE!D8","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Vous devez remplir préalablement la liste des écoles dans le feuillet NOTICE."]
[null,null,null,null,null,null,null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée en suivant les exemples ci contre ="]
[null,null,null,null,null,null,null,"Pour 6 h de classe, saisir 6:00 / Pour 5h30 de classe, saisir 5:30 / Pour 5h45 de classe saisir 5:45 …"]
[]
[null,"LUNDI",null,"MARDI",null,"MERCREDI",null,"JEUDI",null,"VENDREDI",null,"SAMEDI",null,"Service d'Enseignement effectué",1,"Solde semaine Service d'Enseignement"]
[null,"2018-11-05","horaire",{"$f":"B12+1","v":"2018-11-06"},"horaire",{"$f":"D12+1","v":"2018-11-07"},"horaire",{"$f":"F12+1","v":"2018-11-08"},"horaire",{"$f":"H12+1","v":"2018-11-09"},"horaire",{"$f":"J12+1","v":"2018-11-10"},"horaire",{"$f":"IF(ISNUMBER(C12),C12,0)+IF(ISNUMBER(E12),E12,0)+IF(ISNUMBER(G12),G12,0)+IF(ISNUMBER(I12),I12,0)+IF(ISNUMBER(K12),K12,0)+IF(ISNUMBER(M12),M12,0)","v":0},{"$f":"IF(N12>0,IF(N12-$O$11*NOTICE!$D$23>0,N12-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O12,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"APC",{"$f":"SUMIFS(C14:M32,B14:L32,\"APC\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,null,null,null,null,null,null,null,null,null,null,null,"Formation",{"$f":"SUMIFS(C14:M32,B14:L32,\"Formation\")","v":"00:00:00"}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire",null,null,null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",{"$f":"SUMIFS(C14:M32,B14:L32,\"Conseil ecole\")","v":"00:00:00"}]
[null,{"$f":"B12+7","v":"2018-11-12"},"horaire",{"$f":"B15+1","v":"2018-11-13"},"horaire",{"$f":"D15+1","v":"2018-11-14"},"horaire",{"$f":"F15+1","v":"2018-11-15"},"horaire",{"$f":"H15+1","v":"2018-11-16"},"horaire",{"$f":"J15+1","v":"2018-11-17"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(E15),E15,0)+IF(ISNUMBER(G15),G15,0)+IF(ISNUMBER(I15),I15,0)+IF(ISNUMBER(K15),K15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,IF(N15-$O$11*NOTICE!$D$23>0,N15-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O15,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"Autres",{"$f":"SUMIFS(C14:M32,B14:L32,\"autres\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N16>0,IF(N16-$O$11*NOTICE!$D$23>0,N16-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B15+7","v":"2018-11-19"},"horaire",{"$f":"B18+1","v":"2018-11-20"},"horaire",{"$f":"D18+1","v":"2018-11-21"},"horaire",{"$f":"F18+1","v":"2018-11-22"},"horaire",{"$f":"H18+1","v":"2018-11-23"},"horaire",{"$f":"J18+1","v":"2018-11-24"},"horaire",{"$f":"IF(ISNUMBER(C18),C18,0)+IF(ISNUMBER(E18),E18,0)+IF(ISNUMBER(G18),G18,0)+IF(ISNUMBER(I18),I18,0)+IF(ISNUMBER(K18),K18,0)+IF(ISNUMBER(M18),M18,0)","v":0},{"$f":"IF(N18>0,IF(N18-$O$11*NOTICE!$D$23>0,N18-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O18,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N19>0,IF(N19-$O$11*NOTICE!$D$23>0,N19-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B18+7","v":"2018-11-26"},"horaire",{"$f":"B21+1","v":"2018-11-27"},"horaire",{"$f":"D21+1","v":"2018-11-28"},"horaire",{"$f":"F21+1","v":"2018-11-29"},"horaire",{"$f":"H21+1","v":"2018-11-30"},"horaire",{"$f":"J21+1","v":"2018-12-01"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(E21),E21,0)+IF(ISNUMBER(G21),G21,0)+IF(ISNUMBER(I21),I21,0)+IF(ISNUMBER(K21),K21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,IF(N21-$O$11*NOTICE!$D$23>0,N21-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O21,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N22>0,IF(N22-$O$11*NOTICE!$D$23>0,N22-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B21+7","v":"2018-12-03"},"horaire",{"$f":"B24+1","v":"2018-12-04"},"horaire",{"$f":"D24+1","v":"2018-12-05"},"horaire",{"$f":"F24+1","v":"2018-12-06"},"horaire",{"$f":"H24+1","v":"2018-12-07"},"horaire",{"$f":"J24+1","v":"2018-12-08"},"horaire",{"$f":"IF(ISNUMBER(C24),C24,0)+IF(ISNUMBER(E24),E24,0)+IF(ISNUMBER(G24),G24,0)+IF(ISNUMBER(I24),I24,0)+IF(ISNUMBER(K24),K24,0)+IF(ISNUMBER(M24),M24,0)","v":0},{"$f":"IF(N24>0,IF(N24-$O$11*NOTICE!$D$23>0,N24-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O24,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N25>0,IF(N25-$O$11*NOTICE!$D$23>0,N25-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B24+7","v":"2018-12-10"},"horaire",{"$f":"B27+1","v":"2018-12-11"},"horaire",{"$f":"D27+1","v":"2018-12-12"},"horaire",{"$f":"F27+1","v":"2018-12-13"},"horaire",{"$f":"H27+1","v":"2018-12-14"},"horaire",{"$f":"J27+1","v":"2018-12-15"},"horaire",{"$f":"IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(E27),E27,0)+IF(ISNUMBER(G27),G27,0)+IF(ISNUMBER(I27),I27,0)+IF(ISNUMBER(K27),K27,0)+IF(ISNUMBER(M27),M27,0)","v":0},{"$f":"IF(N27>0,IF(N27-$O$11*NOTICE!$D$23>0,N27-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O27,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N28>0,IF(N28-$O$11*NOTICE!$D$23>0,N28-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B27+7","v":"2018-12-17"},"horaire",{"$f":"B30+1","v":"2018-12-18"},"horaire",{"$f":"D30+1","v":"2018-12-19"},"horaire",{"$f":"F30+1","v":"2018-12-20"},"horaire",{"$f":"H30+1","v":"2018-12-21"},"horaire",{"$f":"J30+1","v":"2018-12-22"},"horaire",{"$f":"IF(ISNUMBER(C30),C30,0)+IF(ISNUMBER(E30),E30,0)+IF(ISNUMBER(G30),G30,0)+IF(ISNUMBER(I30),I30,0)+IF(ISNUMBER(K30),K30,0)+IF(ISNUMBER(M30),M30,0)","v":0},{"$f":"IF(N30>0,IF(N30-$O$11*NOTICE!$D$23>0,N30-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O30,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[]
[null,"Le solde ne se déclenche que s'il y a un excédent",null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(O12:O31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"P34+'Période 1'!P34","v":0}]

{"sheet":"Période 3","index":4,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,13,25,13],[23,14,24,14],[23,15,25,15],[26,1,26,15],[27,1,27,12],[28,1,28,12],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[17,15,19,15],[20,14,21,14],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[20,13,22,13],[20,15,22,15],[17,14,18,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[17,13,19,13],[11,15,13,15],[14,14,15,14],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[14,13,16,13],[14,15,16,15],[11,14,12,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,13,13,13],[5,1,5,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[1,3,1,4],[1,9,1,13],[2,3,2,4],[2,9,2,13],[3,3,3,4]]}
[]
[null,"NOM",":",{"$f":"NOTICE!D6","v":0},null,null,"École de rattachement",null,null,{"$f":"NOTICE!D9","v":0}]
[null,"Prénom",":",{"$f":"NOTICE!D7","v":0},null,null,"Circonscription",null,null,{"$f":"NOTICE!D10","v":0}]
[null,"Qualité",":",{"$f":"NOTICE!D8","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Vous devez remplir préalablement la liste des écoles dans le feuillet NOTICE."]
[null,null,null,null,null,null,null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée en suivant les exemples ci contre ="]
[null,null,null,null,null,null,null,"Pour 6 h de classe, saisir 6:00 / Pour 5h30 de classe, saisir 5:30 / Pour 5h45 de classe saisir 5:45 …"]
[]
[null,"LUNDI",null,"MARDI",null,"MERCREDI",null,"JEUDI",null,"VENDREDI",null,"SAMEDI",null,"Service d'Enseignement effectué",1,"Solde semaine Service d'Enseignement"]
[null,"2019-01-07","horaire",{"$f":"B12+1","v":"2019-01-08"},"horaire",{"$f":"D12+1","v":"2019-01-09"},"horaire",{"$f":"F12+1","v":"2019-01-10"},"horaire",{"$f":"H12+1","v":"2019-01-11"},"horaire",{"$f":"J12+1","v":"2019-01-12"},"horaire",{"$f":"IF(ISNUMBER(C12),C12,0)+IF(ISNUMBER(E12),E12,0)+IF(ISNUMBER(G12),G12,0)+IF(ISNUMBER(I12),I12,0)+IF(ISNUMBER(K12),K12,0)+IF(ISNUMBER(M12),M12,0)","v":0},{"$f":"IF(N12>0,IF(N12-$O$11*NOTICE!$D$23>0,N12-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O12,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"APC",{"$f":"SUMIFS(C14:M32,B14:L32,\"APC\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N13>0,IF(N13-$O$11*NOTICE!$D$23>0,N13-$O$11*NOTICE!$D$23,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Formation",{"$f":"SUMIFS(C14:M32,B14:L32,\"Formation\")","v":"00:00:00"}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire",null,null,null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",{"$f":"SUMIFS(C14:M32,B14:L32,\"Conseil ecole\")","v":"00:00:00"}]
[null,{"$f":"B12+7","v":"2019-01-14"},"horaire",{"$f":"B15+1","v":"2019-01-15"},"horaire",{"$f":"D15+1","v":"2019-01-16"},"horaire",{"$f":"F15+1","v":"2019-01-17"},"horaire",{"$f":"H15+1","v":"2019-01-18"},"horaire",{"$f":"J15+1","v":"2019-01-19"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(E15),E15,0)+IF(ISNUMBER(G15),G15,0)+IF(ISNUMBER(I15),I15,0)+IF(ISNUMBER(K15),K15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,IF(N15-$O$11*NOTICE!$D$23>0,N15-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O15,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"Autres",{"$f":"SUMIFS(C14:M32,B14:L32,\"autres\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N16>0,IF(N16-$O$11*NOTICE!$D$23>0,N16-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B15+7","v":"2019-01-21"},"horaire",{"$f":"B18+1","v":"2019-01-22"},"horaire",{"$f":"D18+1","v":"2019-01-23"},"horaire",{"$f":"F18+1","v":"2019-01-24"},"horaire",{"$f":"H18+1","v":"2019-01-25"},"horaire",{"$f":"J18+1","v":"2019-01-26"},"horaire",{"$f":"IF(ISNUMBER(C18),C18,0)+IF(ISNUMBER(E18),E18,0)+IF(ISNUMBER(G18),G18,0)+IF(ISNUMBER(I18),I18,0)+IF(ISNUMBER(K18),K18,0)+IF(ISNUMBER(M18),M18,0)","v":0},{"$f":"IF(N18>0,IF(N18-$O$11*NOTICE!$D$23>0,N18-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O18,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N19>0,IF(N19-$O$11*NOTICE!$D$23>0,N19-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B18+7","v":"2019-01-28"},"horaire",{"$f":"B21+1","v":"2019-01-29"},"horaire",{"$f":"D21+1","v":"2019-01-30"},"horaire",{"$f":"F21+1","v":"2019-01-31"},"horaire",{"$f":"H21+1","v":"2019-02-01"},"horaire",{"$f":"J21+1","v":"2019-02-02"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(E21),E21,0)+IF(ISNUMBER(G21),G21,0)+IF(ISNUMBER(I21),I21,0)+IF(ISNUMBER(K21),K21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,IF(N21-$O$11*NOTICE!$D$23>0,N21-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O21,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N22>0,IF(N22-$O$11*NOTICE!$D$23>0,N22-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B21+7","v":"2019-02-04"},"horaire",{"$f":"B24+1","v":"2019-02-05"},"horaire",{"$f":"D24+1","v":"2019-02-06"},"horaire",{"$f":"F24+1","v":"2019-02-07"},"horaire",{"$f":"H24+1","v":"2019-02-08"},"horaire",{"$f":"J24+1","v":"2019-02-09"},"horaire",{"$f":"IF(ISNUMBER(C24),C24,0)+IF(ISNUMBER(E24),E24,0)+IF(ISNUMBER(G24),G24,0)+IF(ISNUMBER(I24),I24,0)+IF(ISNUMBER(K24),K24,0)+IF(ISNUMBER(M24),M24,0)","v":0},{"$f":"IF(N24>0,IF(N24-$O$11*NOTICE!$D$23>0,N24-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O24,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N25>0,IF(N25-$O$11*NOTICE!$D$23>0,N25-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[]
[null,"Le solde ne se déclenche que s'il y a un excédent",null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(O12:O26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"P28+'Période 2'!P35","v":0}]

{"sheet":"Période 4","index":5,"n_rows":32,"n_cols":27,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,15,25,15],[29,1,29,15],[30,1,30,12],[31,1,31,12],[26,14,27,14],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[26,13,28,13],[26,15,28,15],[23,14,24,14],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[23,13,25,13],[17,15,19,15],[20,14,21,14],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[20,13,22,13],[20,15,22,15],[17,14,18,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[17,13,19,13],[11,15,13,15],[14,14,15,14],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[14,13,16,13],[14,15,16,15],[11,14,12,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,13,13,13],[5,1,5,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[1,3,1,4],[1,9,1,13],[2,3,2,4],[2,9,2,13],[3,3,3,4]]}
[]
[null,"NOM",":",{"$f":"NOTICE!D6","v":0},null,null,"École de rattachement",null,null,{"$f":"NOTICE!D9","v":0}]
[null,"Prénom",":",{"$f":"NOTICE!D7","v":0},null,null,"Circonscription",null,null,{"$f":"NOTICE!D10","v":0}]
[null,"Qualité",":",{"$f":"NOTICE!D8","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Vous devez remplir préalablement la liste des écoles dans le feuillet NOTICE."]
[null,null,null,null,null,null,null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée en suivant les exemples ci contre ="]
[null,null,null,null,null,null,null,"Pour 6 h de classe, saisir 6:00 / Pour 5h30 de classe, saisir 5:30 / Pour 5h45 de classe saisir 5:45 …"]
[]
[null,"LUNDI",null,"MARDI",null,"MERCREDI",null,"JEUDI",null,"VENDREDI",null,"SAMEDI",null,"Service d'Enseignement effectué",1,"Solde semaine Service d'Enseignement"]
[null,"2019-02-25","horaire",{"$f":"B12+1","v":"2019-02-26"},"horaire",{"$f":"D12+1","v":"2019-02-27"},"horaire",{"$f":"F12+1","v":"2019-02-28"},"horaire",{"$f":"H12+1","v":"2019-03-01"},"horaire",{"$f":"J12+1","v":"2019-03-02"},"horaire",{"$f":"IF(ISNUMBER(C12),C12,0)+IF(ISNUMBER(E12),E12,0)+IF(ISNUMBER(G12),G12,0)+IF(ISNUMBER(I12),I12,0)+IF(ISNUMBER(K12),K12,0)+IF(ISNUMBER(M12),M12,0)","v":0},{"$f":"IF(N12>0,IF(N12-$O$11*NOTICE!$D$23>0,N12-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O12,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"APC",{"$f":"SUMIFS(C14:M32,B14:L32,\"APC\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N13>0,IF(N13-$O$11*NOTICE!$D$23>0,N13-$O$11*NOTICE!$D$23,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Formation",{"$f":"SUMIFS(C14:M32,B14:L32,\"Formation\")","v":"00:00:00"}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire",null,null,null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",{"$f":"SUMIFS(C14:M32,B14:L32,\"Conseil ecole\")","v":"00:00:00"}]
[null,{"$f":"B12+7","v":"2019-03-04"},"horaire",{"$f":"B15+1","v":"2019-03-05"},"horaire",{"$f":"D15+1","v":"2019-03-06"},"horaire",{"$f":"F15+1","v":"2019-03-07"},"horaire",{"$f":"H15+1","v":"2019-03-08"},"horaire",{"$f":"J15+1","v":"2019-03-09"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(E15),E15,0)+IF(ISNUMBER(G15),G15,0)+IF(ISNUMBER(I15),I15,0)+IF(ISNUMBER(K15),K15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,IF(N15-$O$11*NOTICE!$D$23>0,N15-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O15,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"Autres",{"$f":"SUMIFS(C14:M32,B14:L32,\"autres\")","v":"00:00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N16>0,IF(N16-$O$11*NOTICE!$D$23>0,N16-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B15+7","v":"2019-03-11"},"horaire",{"$f":"B18+1","v":"2019-03-12"},"horaire",{"$f":"D18+1","v":"2019-03-13"},"horaire",{"$f":"F18+1","v":"2019-03-14"},"horaire",{"$f":"H18+1","v":"2019-03-15"},"horaire",{"$f":"J18+1","v":"2019-03-16"},"horaire",{"$f":"IF(ISNUMBER(C18),C18,0)+IF(ISNUMBER(E18),E18,0)+IF(ISNUMBER(G18),G18,0)+IF(ISNUMBER(I18),I18,0)+IF(ISNUMBER(K18),K18,0)+IF(ISNUMBER(M18),M18,0)","v":0},{"$f":"IF(N18>0,IF(N18-$O$11*NOTICE!$D$23>0,N18-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O18,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N19>0,IF(N19-$O$11*NOTICE!$D$23>0,N19-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B18+7","v":"2019-03-18"},"horaire",{"$f":"B21+1","v":"2019-03-19"},"horaire",{"$f":"D21+1","v":"2019-03-20"},"horaire",{"$f":"F21+1","v":"2019-03-21"},"horaire",{"$f":"H21+1","v":"2019-03-22"},"horaire",{"$f":"J21+1","v":"2019-03-23"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(E21),E21,0)+IF(ISNUMBER(G21),G21,0)+IF(ISNUMBER(I21),I21,0)+IF(ISNUMBER(K21),K21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,IF(N21-$O$11*NOTICE!$D$23>0,N21-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O21,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N22>0,IF(N22-$O$11*NOTICE!$D$23>0,N22-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B21+7","v":"2019-03-25"},"horaire",{"$f":"B24+1","v":"2019-03-26"},"horaire",{"$f":"D24+1","v":"2019-03-27"},"horaire",{"$f":"F24+1","v":"2019-03-28"},"horaire",{"$f":"H24+1","v":"2019-03-29"},"horaire",{"$f":"J24+1","v":"2019-03-30"},"horaire",{"$f":"IF(ISNUMBER(C24),C24,0)+IF(ISNUMBER(E24),E24,0)+IF(ISNUMBER(G24),G24,0)+IF(ISNUMBER(I24),I24,0)+IF(ISNUMBER(K24),K24,0)+IF(ISNUMBER(M24),M24,0)","v":0},{"$f":"IF(N24>0,IF(N24-$O$11*NOTICE!$D$23>0,N24-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O24,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N25>0,IF(N25-$O$11*NOTICE!$D$23>0,N25-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B24+7","v":"2019-04-01"},"horaire",{"$f":"B27+1","v":"2019-04-02"},"horaire",{"$f":"D27+1","v":"2019-04-03"},"horaire",{"$f":"F27+1","v":"2019-04-04"},"horaire",{"$f":"H27+1","v":"2019-04-05"},"horaire",{"$f":"J27+1","v":"2019-04-06"},"horaire",{"$f":"IF(ISNUMBER(C27),C27,0)+IF(ISNUMBER(E27),E27,0)+IF(ISNUMBER(G27),G27,0)+IF(ISNUMBER(I27),I27,0)+IF(ISNUMBER(K27),K27,0)+IF(ISNUMBER(M27),M27,0)","v":0},{"$f":"IF(N27>0,IF(N27-$O$11*NOTICE!$D$23>0,N27-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O27,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école"]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[]
[null,"Le solde ne se déclenche que s'il y a un excédent",null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(O12:O28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"P31+'Période 3'!P29","v":0}]

{"sheet":"Période 5","index":6,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,1,45,12],[46,1,46,12],[35,14,36,14],[36,1,36,2],[36,3,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[35,13,37,13],[44,1,44,15],[41,13,43,13],[41,14,42,14],[41,15,43,15],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[35,15,37,15],[38,13,40,13],[38,14,39,14],[38,15,40,15],[39,1,39,2],[33,1,33,2],[33,3,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[32,15,34,15],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[26,14,27,14],[27,1,27,2],[27,3,27,4],[27,5,27,6],[29,14,30,14],[30,11,30,12],[29,13,31,13],[29,15,31,15],[32,14,33,14],[33,11,33,12],[32,13,34,13],[26,15,28,15],[30,1,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[27,7,27,8],[27,9,27,10],[27,11,27,12],[26,13,28,13],[17,15,19,15],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[23,13,25,13],[23,15,25,15],[21,11,21,12],[20,13,22,13],[23,14,24,14],[20,15,22,15],[20,14,21,14],[21,1,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[14,14,15,14],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[14,13,16,13],[17,14,18,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[17,13,19,13],[14,15,16,15],[1,3,1,4],[1,9,1,13],[2,3,2,4],[2,9,2,13],[3,3,3,4],[5,1,5,15],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[11,14,12,14],[12,1,12,2],[12,3,12,4],[11,15,13,15],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[11,13,13,13]]}
[]
[null,"NOM",":",{"$f":"NOTICE!D6","v":0},null,null,"École de rattachement",null,null,{"$f":"NOTICE!D9","v":0}]
[null,"Prénom",":",{"$f":"NOTICE!D7","v":0},null,null,"Circonscription",null,null,{"$f":"NOTICE!D10","v":0}]
[null,"Qualité",":",{"$f":"NOTICE!D8","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Vous devez remplir préalablement la liste des écoles dans le feuillet NOTICE."]
[null,null,null,null,null,null,null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée en suivant les exemples ci contre ="]
[null,null,null,null,null,null,null,"Pour 6 h de classe, saisir 6:00 / Pour 5h30 de classe, saisir 5:30 / Pour 5h45 de classe saisir 5:45 …"]
[]
[null,"LUNDI",null,"MARDI",null,"MERCREDI",null,"JEUDI",null,"VENDREDI",null,"SAMEDI",null,"Service d'Enseignement effectué",1,"Solde semaine Service d'Enseignement"]
[null,"2019-04-22","Férié",{"$f":"B12+1","v":"2019-04-23"},"horaire",{"$f":"D12+1","v":"2019-04-24"},"horaire",{"$f":"F12+1","v":"2019-04-25"},"horaire",{"$f":"H12+1","v":"2019-04-26"},"horaire",{"$f":"J12+1","v":"2019-04-27"},"horaire",{"$f":"IF(ISNUMBER(C12),C12,0)+IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(G12),G12,0)+IF(ISNUMBER(G15),G15,0)+IF(ISNUMBER(K12),K12,0)+IF(ISNUMBER(M12),M12,0)","v":0},{"$f":"IF(N12>0,IF(N12-$O$11*NOTICE!$D$23>0,N12-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O12,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"APC",{"$f":"SUMIFS(C14:M32,B14:L32,\"APC\")","v":"00:00:00"}]
[null,null,null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N13>0,IF(N13-$O$11*NOTICE!$D$23>0,N13-$O$11*NOTICE!$D$23,0),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Formation",{"$f":"SUMIFS(C14:M32,B14:L32,\"Formation\")","v":"00:00:00"}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire",null,null,null,null,null,null,null,null,null,null,null,null,"Conseil Ecole",{"$f":"SUMIFS(C14:M32,B14:L32,\"Conseil ecole\")","v":"00:00:00"}]
[null,{"$f":"B12+7","v":"2019-04-29"},"horaire",{"$f":"B15+1","v":"2019-04-30"},"horaire",{"$f":"D15+1","v":"2019-05-01"},"Férié",{"$f":"F15+1","v":"2019-05-02"},"horaire",{"$f":"H15+1","v":"2019-05-03"},"horaire",{"$f":"J15+1","v":"2019-05-04"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(E12),E12,0)+IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(I15),I15,0)+IF(ISNUMBER(K15),K15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,IF(N15-$O$11*NOTICE!$D$23>0,N15-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O15,\"hh:mm\")","v":"00:00"},null,null,null,null,null,null,null,null,null,"Autres",{"$f":"SUMIFS(C14:M32,B14:L32,\"autres\")","v":"00:00:00"}]
[null,"école",null,"école",null,null,null,"école",null,"école",null,"école",null,null,{"$f":"IF(N16>0,IF(N16-$O$11*NOTICE!$D$23>0,N16-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B15+7","v":"2019-05-06"},"horaire",{"$f":"B18+1","v":"2019-05-07"},"horaire",{"$f":"D18+1","v":"2019-05-08"},"Férié",{"$f":"F18+1","v":"2019-05-09"},"horaire",{"$f":"H18+1","v":"2019-05-10"},"horaire",{"$f":"J18+1","v":"2019-05-11"},"horaire",{"$f":"IF(ISNUMBER(G18),G18,0)+IF(ISNUMBER(E18),E18,0)+IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(I18),I18,0)+IF(ISNUMBER(K18),K18,0)+IF(ISNUMBER(M18),M18,0)","v":0},{"$f":"IF(N18>0,IF(N18-$O$11*NOTICE!$D$23>0,N18-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O18,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,null,null,"école",null,"école",null,"école",null,null,{"$f":"IF(N19>0,IF(N19-$O$11*NOTICE!$D$23>0,N19-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B18+7","v":"2019-05-13"},"horaire",{"$f":"B21+1","v":"2019-05-14"},"horaire",{"$f":"D21+1","v":"2019-05-15"},"horaire",{"$f":"F21+1","v":"2019-05-16"},"horaire",{"$f":"H21+1","v":"2019-05-17"},"horaire",{"$f":"J21+1","v":"2019-05-18"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(E21),E21,0)+IF(ISNUMBER(G21),G21,0)+IF(ISNUMBER(I21),I21,0)+IF(ISNUMBER(K21),K21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,IF(N21-$O$11*NOTICE!$D$23>0,N21-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O21,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N22>0,IF(N22-$O$11*NOTICE!$D$23>0,N22-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B21+7","v":"2019-05-20"},"horaire",{"$f":"B24+1","v":"2019-05-21"},"horaire",{"$f":"D24+1","v":"2019-05-22"},"horaire",{"$f":"F24+1","v":"2019-05-23"},"horaire",{"$f":"H24+1","v":"2019-05-24"},"horaire",{"$f":"J24+1","v":"2019-05-25"},"horaire",{"$f":"IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(E24),E24,0)+IF(ISNUMBER(G24),G24,0)+IF(ISNUMBER(I24),I24,0)+IF(ISNUMBER(K24),K24,0)+IF(ISNUMBER(M24),M24,0)","v":0},{"$f":"IF(N24>0,IF(N24-$O$11*NOTICE!$D$23>0,N24-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O24,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N25>0,IF(N25-$O$11*NOTICE!$D$23>0,N25-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B24+7","v":"2019-05-27"},"horaire",{"$f":"B27+1","v":"2019-05-28"},"horaire",{"$f":"D27+1","v":"2019-05-29"},"horaire",{"$f":"F27+1","v":"2019-05-30"},"Férié",{"$f":"H27+1","v":"2019-05-31"},"Férié",{"$f":"J27+1","v":"2019-06-01"},"Férié",{"$f":"IF(ISNUMBER(C24),C24,0)+IF(ISNUMBER(E27),E27,0)+IF(ISNUMBER(G27),G27,0)+IF(ISNUMBER(I27),I27,0)+IF(ISNUMBER(K27),K27,0)+IF(ISNUMBER(M27),M27,0)","v":0},{"$f":"IF(N27>0,IF(N27-$O$11*NOTICE!$D$23>0,N27-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O27,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N28>0,IF(N28-$O$11*NOTICE!$D$23>0,N28-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B27+7","v":"2019-06-03"},"horaire",{"$f":"B30+1","v":"2019-06-04"},"horaire",{"$f":"D30+1","v":"2019-06-05"},"horaire",{"$f":"F30+1","v":"2019-06-06"},"horaire",{"$f":"H30+1","v":"2019-06-07"},"horaire",{"$f":"J30+1","v":"2019-06-08"},"horaire",{"$f":"IF(ISNUMBER(C30),C30,0)+IF(ISNUMBER(E30),E30,0)+IF(ISNUMBER(G30),G30,0)+IF(ISNUMBER(I30),I30,0)+IF(ISNUMBER(K30),K30,0)+IF(ISNUMBER(M30),M30,0)","v":0},{"$f":"IF(N30>0,IF(N30-$O$11*NOTICE!$D$23>0,N30-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O30,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N31>0,IF(N31-$O$11*NOTICE!$D$23>0,N31-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B30+7","v":"2019-06-10"},"Férié",{"$f":"B33+1","v":"2019-06-11"},"horaire",{"$f":"D33+1","v":"2019-06-12"},"horaire",{"$f":"F33+1","v":"2019-06-13"},"horaire",{"$f":"H33+1","v":"2019-06-14"},"horaire",{"$f":"J33+1","v":"2019-06-15"},"horaire",{"$f":"IF(ISNUMBER(C33),C33,0)+IF(ISNUMBER(E33),E33,0)+IF(ISNUMBER(G33),G33,0)+IF(ISNUMBER(I33),I33,0)+IF(ISNUMBER(K33),K33,0)+IF(ISNUMBER(M33),M33,0)","v":0},{"$f":"IF(N33>0,IF(N33-$O$11*NOTICE!$D$23>0,N33-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O33,\"hh:mm\")","v":"00:00"}]
[null,null,null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N34>0,IF(N34-$O$11*NOTICE!$D$23>0,N34-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B33+7","v":"2019-06-17"},"horaire",{"$f":"B36+1","v":"2019-06-18"},"horaire",{"$f":"D36+1","v":"2019-06-19"},"horaire",{"$f":"F36+1","v":"2019-06-20"},"horaire",{"$f":"H36+1","v":"2019-06-21"},"horaire",{"$f":"J36+1","v":"2019-06-22"},"horaire",{"$f":"IF(ISNUMBER(C36),C36,0)+IF(ISNUMBER(E36),E36,0)+IF(ISNUMBER(G36),G36,0)+IF(ISNUMBER(I36),I36,0)+IF(ISNUMBER(K36),K36,0)+IF(ISNUMBER(M36),M36,0)","v":0},{"$f":"IF(N36>0,IF(N36-$O$11*NOTICE!$D$23>0,N36-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O36,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N37>0,IF(N37-$O$11*NOTICE!$D$23>0,N37-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B36+7","v":"2019-06-24"},"horaire",{"$f":"B39+1","v":"2019-06-25"},"horaire",{"$f":"D39+1","v":"2019-06-26"},"horaire",{"$f":"F39+1","v":"2019-06-27"},"horaire",{"$f":"H39+1","v":"2019-06-28"},"horaire",{"$f":"J39+1","v":"2019-06-29"},"horaire",{"$f":"IF(ISNUMBER(C39),C39,0)+IF(ISNUMBER(E39),E39,0)+IF(ISNUMBER(G39),G39,0)+IF(ISNUMBER(I39),I39,0)+IF(ISNUMBER(K39),K39,0)+IF(ISNUMBER(M39),M39,0)","v":0},{"$f":"IF(N39>0,IF(N39-$O$11*NOTICE!$D$23>0,N39-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O39,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N40>0,IF(N40-$O$11*NOTICE!$D$23>0,N40-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[null,{"$f":"B39+7","v":"2019-07-01"},"horaire",{"$f":"B42+1","v":"2019-07-02"},"horaire",{"$f":"D42+1","v":"2019-07-03"},"horaire",{"$f":"F42+1","v":"2019-07-04"},"horaire",{"$f":"H42+1","v":"2019-07-05"},"horaire",{"$f":"J42+1","v":"2019-07-06"},"horaire",{"$f":"IF(ISNUMBER(C42),C42,0)+IF(ISNUMBER(E42),E42,0)+IF(ISNUMBER(G42),G42,0)+IF(ISNUMBER(I42),I42,0)+IF(ISNUMBER(K42),K42,0)+IF(ISNUMBER(M42),M42,0)","v":0},{"$f":"IF(N42>0,IF(N42-$O$11*NOTICE!$D$23>0,N42-$O$11*NOTICE!$D$23,0),0)","v":0},{"$f":"TEXT(O42,\"hh:mm\")","v":"00:00"}]
[null,"école",null,"école",null,"école",null,"école",null,"école",null,"école",null,null,{"$f":"IF(N43>0,IF(N43-$O$11*NOTICE!$D$23>0,N43-$O$11*NOTICE!$D$23,0),0)","v":0}]
[null,"ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire","ETAT 108h","horaire"]
[]
[null,"Le solde ne se déclenche que s'il y a un excédent",null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(O12:O44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"P46+'Période 4'!P32","v":0}]