{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notice","Période1","Période2","Période3","Période4","Période5"],"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":"Notice","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,6,26,9],[16,1,16,9],[17,3,17,9],[18,3,18,9],[19,1,19,9],[20,1,20,9],[23,6,24,9],[22,7,22,8],[1,1,1,9],[2,1,2,9],[3,1,3,3],[13,1,13,3],[3,4,3,9],[4,1,4,9],[5,4,7,9],[9,4,9,9],[10,6,10,7],[10,8,10,9],[14,1,14,9],[13,4,13,9],[15,1,15,9],[11,6,11,7],[11,8,11,9],[12,1,12,9]]}
[]
[null,"Tableau individuel de suivi des heures du service hebdomadaire"]
[]
[null,"INFORMATIONS PERSONNELLES"]
[]
[null,"NOM",":"]
[null,"Prénom",":"]
[null,"Qualité",":"]
[null,"École de rattachement",":",null,{"$f":"D11","v":"école 1"},{"$f":"E11","v":"école 2"},{"$f":"F11","v":"école 3"},{"$f":"G11","v":"école 4"},{"$f":"I11","v":"école 5"},{"$f":"D12","v":"école 6"},{"$f":"E12","v":"école 7"},{"$f":"F12","v":"école 8"},{"$f":"G12","v":"école 9"},{"$f":"I12","v":"école 10"}]
[null,"Circonscription",":"]
[null,"Liste d'écoles d'exercice",":","école 1","école 2","école 3","école 4",null,"école 5"]
[null,null,null,"école 6","école 7","école 8","école 9",null,"école 10"]
[]
[null,"CONSEILS D'UTILISATION"]
[null,null,null,null,null,null,null,null,null,null,"Caen - Clermont Ferrand - Grenoble - Lyon - Montpellier - Nancy/Metz - Nantes - Rennes - Toulouse"]
[null,"Dans les cellules \"école\", inscrire pour mémoire, le nom de l'école d'exercice après avoir rempli la liste des écoles d'exercice ci-dessus.",null,null,null,null,null,null,null,null,"Aix/Marseille - Amiens - Besançon - Dijon - Lille - Limoges - Nice - Orléans/Tours - Poitiers - Reims - Rouen - Strasbourg"]
[null,"Dans les cellules \"horaire\", saisir la durée horaire effectuée,",null,null,null,null,null,null,null,null,"Bordeaux - Créteil - Paris - Versailles"]
[null,null,"-","Pour 6 h de classe, saisir 6:00"]
[null,null,"-","Pour 5 h 30 de classe, saisir 5:30"]
[null,"Cliquer sur les onglets ci-dessous, pour voir les périodes scolaires, après avoir défini votre zone de vacances (Zone A définie par défaut)."]
[]
[null,null,null,null,"du","au",null,"ZONE DE VACANCES"]
[null,null,"-","Période 1 :","2014-09-01",{"$f":"Période1!$L$19","v":"2014-10-17"},null,"Zone A"]
[null,null,"-","Période 2 :","2014-11-03",{"$f":"Période2!$L$19","v":"2014-12-19"},{"$f":"IF(H23=\"Zone A\",K15,IF(H23=\"Zone B\",K16,IF(H23=\"Zone C\",K17,\"\")))","v":"Caen - Clermont Ferrand - Grenoble - Lyon - Montpellier - Nancy/Metz - Nantes - Rennes - Toulouse"}]
[null,null,"-","Période 3 :","2015-01-05",{"$f":"IF(H23=\"Zone A\",\"06/02\",IF(H23=\"Zone B\",\"20/02\",IF(H23=\"Zone C\",\"13/02\",\"\")))","v":"06/02"}]
[null,null,"-","Période 4 :",{"$f":"IF(F25=\"\",\"\",F25+17)","v":"2014-02-23"},{"$f":"IF(E26=\"\",\"\",E26+46)","v":"2014-04-10"}]
[null,null,"-","Période 5 :",{"$f":"IF(F26=\"\",\"\",F26+17)","v":"2014-04-27"},"2015-07-03"]

{"sheet":"Période1","index":1,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,14,9,14],[7,8,7,10],[8,15,9,15],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,10],[9,11,9,12],[8,2,8,3],[8,9,8,10],[8,13,9,13],[6,9,6,10],[5,11,5,12],[7,11,7,12],[6,2,6,3],[6,13,7,13],[6,15,7,15],[6,14,7,14],[7,1,7,3],[7,4,7,5],[7,6,7,7],[1,11,1,13],[2,11,2,13],[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,10],[1,3,1,5],[2,3,2,5],[3,3,3,5],[10,15,11,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,10],[11,11,11,12],[10,2,10,3],[10,9,10,10],[10,13,11,13],[10,14,11,14],[12,14,13,14],[12,15,13,15],[12,2,12,3],[12,9,12,10],[12,13,13,13],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[13,11,13,12],[14,15,15,15],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,10],[15,11,15,12],[14,2,14,3],[14,9,14,10],[14,13,15,13],[14,14,15,14],[16,15,17,15],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,10],[17,11,17,12],[16,2,16,3],[16,9,16,10],[16,13,17,13],[16,14,17,14],[18,15,19,15],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,10],[19,11,19,12],[18,2,18,3],[18,9,18,10],[18,13,19,13],[18,14,19,14]]}
[]
[null,"NOM",":",{"$f":"IF(Notice!D6=\"\",\"\",Notice!D6)","v":""},null,null,null,"École de rattachement",null,null,":",{"$f":"IF(Notice!D9=\"\",\"\",Notice!D9)","v":""}]
[null,"Prénom",":",{"$f":"IF(Notice!D7=\"\",\"\",Notice!D7)","v":""},null,null,null,"Circonscription",null,null,":",{"$f":"IF(Notice!D10=\"\",\"\",Notice!D10)","v":""}]
[null,"Qualité",":",{"$f":"IF(Notice!D8=\"\",\"\",Notice!D8)","v":""}]
[]
[null,"LUNDI",null,null,"MARDI",null,"MERCREDI",null,"JEUDI",null,null,"VENDREDI",null,"Service effectué",1,"Solde de la semaine"]
[null,{"$f":"Notice!E23","v":"2014-09-01"},"horaire",null,{"$f":"B7+1","v":"2014-09-02"},"horaire",{"$f":"E7+1","v":"2014-09-03"},"horaire",{"$f":"G7+1","v":"2014-09-04"},"horaire",null,{"$f":"I7+1","v":"2014-09-05"},"horaire",{"$f":"IF(ISNUMBER(C7),C7,0)+IF(ISNUMBER(F7),F7,0)+IF(ISNUMBER(H7),H7,0)+IF(ISNUMBER(J7),J7,0)+IF(ISNUMBER(M7),M7,0)","v":0},{"$f":"IF(N7>0,N7-$O$6,0)","v":0},{"$f":"IF(O7<=0,0,IF(O7>0,TEXT(O7,\"hh:mm\")))","v":0}]
[null,null,null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B7+7","v":"2014-09-08"},"horaire",null,{"$f":"B9+1","v":"2014-09-09"},"horaire",{"$f":"E9+1","v":"2014-09-10"},"horaire",{"$f":"G9+1","v":"2014-09-11"},"horaire",null,{"$f":"I9+1","v":"2014-09-12"},"horaire",{"$f":"IF(ISNUMBER(C9),C9,0)+IF(ISNUMBER(F9),F9,0)+IF(ISNUMBER(H9),H9,0)+IF(ISNUMBER(J9),J9,0)+IF(ISNUMBER(M9),M9,0)","v":0},{"$f":"IF(N9>0,N9-$O$6,0)","v":0},{"$f":"IF(O9<=0,0,IF(O9>0,TEXT(O9,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B9+7","v":"2014-09-15"},"horaire",null,{"$f":"B11+1","v":"2014-09-16"},"horaire",{"$f":"E11+1","v":"2014-09-17"},"horaire",{"$f":"G11+1","v":"2014-09-18"},"horaire",null,{"$f":"I11+1","v":"2014-09-19"},"horaire",{"$f":"IF(ISNUMBER(C11),C11,0)+IF(ISNUMBER(F11),F11,0)+IF(ISNUMBER(H11),H11,0)+IF(ISNUMBER(J11),J11,0)+IF(ISNUMBER(M11),M11,0)","v":0},{"$f":"IF(N11>0,N11-$O$6,0)","v":0},{"$f":"IF(O11<=0,0,IF(O11>0,TEXT(O11,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B11+7","v":"2014-09-22"},"horaire",null,{"$f":"B13+1","v":"2014-09-23"},"horaire",{"$f":"E13+1","v":"2014-09-24"},"horaire",{"$f":"G13+1","v":"2014-09-25"},"horaire",null,{"$f":"I13+1","v":"2014-09-26"},"horaire",{"$f":"IF(ISNUMBER(C13),C13,0)+IF(ISNUMBER(F13),F13,0)+IF(ISNUMBER(H13),H13,0)+IF(ISNUMBER(J13),J13,0)+IF(ISNUMBER(M13),M13,0)","v":0},{"$f":"IF(N13>0,N13-$O$6,0)","v":0},{"$f":"IF(O13<=0,0,IF(O13>0,TEXT(O13,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B13+7","v":"2014-09-29"},"horaire",null,{"$f":"B15+1","v":"2014-09-30"},"horaire",{"$f":"E15+1","v":"2014-10-01"},"horaire",{"$f":"G15+1","v":"2014-10-02"},"horaire",null,{"$f":"I15+1","v":"2014-10-03"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(F15),F15,0)+IF(ISNUMBER(H15),H15,0)+IF(ISNUMBER(J15),J15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,N15-$O$6,0)","v":0},{"$f":"IF(O15<=0,0,IF(O15>0,TEXT(O15,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B15+7","v":"2014-10-06"},"horaire",null,{"$f":"B17+1","v":"2014-10-07"},"horaire",{"$f":"E17+1","v":"2014-10-08"},"horaire",{"$f":"G17+1","v":"2014-10-09"},"horaire",null,{"$f":"I17+1","v":"2014-10-10"},"horaire",{"$f":"IF(ISNUMBER(C17),C17,0)+IF(ISNUMBER(F17),F17,0)+IF(ISNUMBER(H17),H17,0)+IF(ISNUMBER(J17),J17,0)+IF(ISNUMBER(M17),M17,0)","v":0},{"$f":"IF(N17>0,N17-$O$6,0)","v":0},{"$f":"IF(O17<=0,0,IF(O17>0,TEXT(O17,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B17+7","v":"2014-10-13"},"horaire",null,{"$f":"B19+1","v":"2014-10-14"},"horaire",{"$f":"E19+1","v":"2014-10-15"},"horaire",{"$f":"G19+1","v":"2014-10-16"},"horaire",null,{"$f":"I19+1","v":"2014-10-17"},"horaire",{"$f":"IF(ISNUMBER(C19),C19,0)+IF(ISNUMBER(F19),F19,0)+IF(ISNUMBER(H19),H19,0)+IF(ISNUMBER(J19),J19,0)+IF(ISNUMBER(M19),M19,0)","v":0},{"$f":"IF(N19>0,N19-$O$6,0)","v":0},{"$f":"IF(O19<=0,0,IF(O19>0,TEXT(O19,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde de la période","Solde de la période",{"$f":"SUM(P7:P20)","v":0}]

{"sheet":"Période2","index":2,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,10],[6,15,7,15],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,10],[7,11,7,12],[6,13,7,13],[6,14,7,14],[1,3,1,5],[1,11,1,13],[2,3,2,5],[2,11,2,13],[3,3,3,5],[3,7,3,9],[5,11,5,12],[6,2,6,3],[6,9,6,10],[8,15,9,15],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,10],[9,11,9,12],[8,2,8,3],[8,9,8,10],[8,13,9,13],[8,14,9,14],[10,15,11,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,10],[11,11,11,12],[10,2,10,3],[10,9,10,10],[10,13,11,13],[10,14,11,14],[12,15,13,15],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[13,11,13,12],[12,2,12,3],[12,9,12,10],[12,13,13,13],[12,14,13,14],[14,15,15,15],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,10],[15,11,15,12],[14,2,14,3],[14,9,14,10],[14,13,15,13],[14,14,15,14],[16,15,17,15],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,10],[17,11,17,12],[16,2,16,3],[16,9,16,10],[16,13,17,13],[16,14,17,14],[18,15,19,15],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,10],[19,11,19,12],[18,2,18,3],[18,9,18,10],[18,13,19,13],[18,14,19,14]]}
[]
[null,"NOM",":",{"$f":"IF(Notice!D6=\"\",\"\",Notice!D6)","v":""},null,null,null,"École de rattachement",null,null,":",{"$f":"IF(Notice!D9=\"\",\"\",Notice!D9)","v":""}]
[null,"Prénom",":",{"$f":"IF(Notice!D7=\"\",\"\",Notice!D7)","v":""},null,null,null,"Circonscription",null,null,":",{"$f":"IF(Notice!D10=\"\",\"\",Notice!D10)","v":""}]
[null,"Qualité",":",{"$f":"IF(Notice!D8=\"\",\"\",Notice!D8)","v":""}]
[]
[null,"LUNDI",null,null,"MARDI",null,"MERCREDI",null,"JEUDI",null,null,"VENDREDI",null,"Service effectué",1,"Solde de la semaine"]
[null,{"$f":"Notice!E24","v":"2014-11-03"},"horaire",null,{"$f":"B7+1","v":"2014-11-04"},"horaire",{"$f":"E7+1","v":"2014-11-05"},"horaire",{"$f":"G7+1","v":"2014-11-06"},"horaire",null,{"$f":"I7+1","v":"2014-11-07"},"horaire",{"$f":"IF(ISNUMBER(C7),C7,0)+IF(ISNUMBER(F7),F7,0)+IF(ISNUMBER(H7),H7,0)+IF(ISNUMBER(J7),J7,0)+IF(ISNUMBER(M7),M7,0)","v":0},{"$f":"IF(N7>0,N7-$O$6,0)","v":0},{"$f":"IF(O7<=0,0,IF(O7>0,TEXT(O7,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B7+7","v":"2014-11-10"},"horaire",null,{"$f":"B9+1","v":"2014-11-11"},"Férié",{"$f":"E9+1","v":"2014-11-12"},"horaire",{"$f":"G9+1","v":"2014-11-13"},"horaire",null,{"$f":"I9+1","v":"2014-11-14"},"horaire",{"$f":"IF(ISNUMBER(F9),F9,0)+IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(H9),H9,0)+IF(ISNUMBER(J9),J9,0)+IF(ISNUMBER(M9),M9,0)","v":0},{"$f":"IF(N9>0,N9-$O$6,0)","v":0},{"$f":"IF(O9<=0,0,IF(O9>0,TEXT(O9,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,{"$f":"IF(#REF!<=0,0,IF(#REF!>0,TEXT(#REF!,\"hh:mm\")))","v":{"$error":"#REF!"}}]
[null,{"$f":"B9+7","v":"2014-11-17"},"horaire",null,{"$f":"B11+1","v":"2014-11-18"},"horaire",{"$f":"E11+1","v":"2014-11-19"},"horaire",{"$f":"G11+1","v":"2014-11-20"},"horaire",null,{"$f":"I11+1","v":"2014-11-21"},"horaire",{"$f":"IF(ISNUMBER(C11),C11,0)+IF(ISNUMBER(F11),F11,0)+IF(ISNUMBER(H11),H11,0)+IF(ISNUMBER(J11),J11,0)+IF(ISNUMBER(M11),M11,0)","v":0},{"$f":"IF(N11>0,N11-$O$6,0)","v":0},{"$f":"IF(O11<=0,0,IF(O11>0,TEXT(O11,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B11+7","v":"2014-11-24"},"horaire",null,{"$f":"B13+1","v":"2014-11-25"},"horaire",{"$f":"E13+1","v":"2014-11-26"},"horaire",{"$f":"G13+1","v":"2014-11-27"},"horaire",null,{"$f":"I13+1","v":"2014-11-28"},"horaire",{"$f":"IF(ISNUMBER(C13),C13,0)+IF(ISNUMBER(F13),F13,0)+IF(ISNUMBER(H13),H13,0)+IF(ISNUMBER(J13),J13,0)+IF(ISNUMBER(M13),M13,0)","v":0},{"$f":"IF(N13>0,N13-$O$6,0)","v":0},{"$f":"IF(O13<=0,0,IF(O13>0,TEXT(O13,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B13+7","v":"2014-12-01"},"horaire",null,{"$f":"B15+1","v":"2014-12-02"},"horaire",{"$f":"E15+1","v":"2014-12-03"},"horaire",{"$f":"G15+1","v":"2014-12-04"},"horaire",null,{"$f":"I15+1","v":"2014-12-05"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(F15),F15,0)+IF(ISNUMBER(H15),H15,0)+IF(ISNUMBER(J15),J15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,N15-$O$6,0)","v":0},{"$f":"IF(O15<=0,0,IF(O15>0,TEXT(O15,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B15+7","v":"2014-12-08"},"horaire",null,{"$f":"B17+1","v":"2014-12-09"},"horaire",{"$f":"E17+1","v":"2014-12-10"},"horaire",{"$f":"G17+1","v":"2014-12-11"},"horaire",null,{"$f":"I17+1","v":"2014-12-12"},"horaire",{"$f":"IF(ISNUMBER(C17),C17,0)+IF(ISNUMBER(F17),F17,0)+IF(ISNUMBER(H17),H17,0)+IF(ISNUMBER(J17),J17,0)+IF(ISNUMBER(M17),M17,0)","v":0},{"$f":"IF(N17>0,N17-$O$6,0)","v":0},{"$f":"IF(O17<=0,0,IF(O17>0,TEXT(O17,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B17+7","v":"2014-12-15"},"horaire",null,{"$f":"B19+1","v":"2014-12-16"},"horaire",{"$f":"E19+1","v":"2014-12-17"},"horaire",{"$f":"G19+1","v":"2014-12-18"},"horaire",null,{"$f":"I19+1","v":"2014-12-19"},"horaire",{"$f":"IF(ISNUMBER(C19),C19,0)+IF(ISNUMBER(F19),F19,0)+IF(ISNUMBER(H19),H19,0)+IF(ISNUMBER(J19),J19,0)+IF(ISNUMBER(M19),M19,0)","v":0},{"$f":"IF(N19>0,N19-$O$6,0)","v":0},{"$f":"IF(O19<=0,0,IF(O19>0,TEXT(O19,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(P7:P20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"Période1!P22+Période2!P22","v":0}]

{"sheet":"Période3","index":3,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,1,17,3],[17,4,17,5],[17,6,17,7],[18,2,18,3],[18,13,19,13],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,10],[19,11,19,12],[15,6,15,7],[15,8,15,10],[15,11,15,12],[18,14,19,14],[14,15,15,15],[17,8,17,10],[17,11,17,12],[16,15,17,15],[18,15,19,15],[18,9,18,10],[16,2,16,3],[16,9,16,10],[16,13,17,13],[16,14,17,14],[14,2,14,3],[14,9,14,10],[14,13,15,13],[14,14,15,14],[15,1,15,3],[15,4,15,5],[12,15,13,15],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[12,2,12,3],[12,9,12,10],[12,13,13,13],[12,14,13,14],[13,11,13,12],[8,14,9,14],[8,15,9,15],[10,2,10,3],[10,9,10,10],[10,13,11,13],[10,14,11,14],[10,15,11,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,10],[11,11,11,12],[7,11,7,12],[8,2,8,3],[8,9,8,10],[8,13,9,13],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,10],[9,11,9,12],[3,7,3,9],[6,2,6,3],[6,9,6,10],[6,13,7,13],[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,10],[5,11,5,12],[3,3,3,5],[1,3,1,5],[1,11,1,13],[2,3,2,5],[2,11,2,13],[6,14,7,14],[6,15,7,15],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,10]]}
[]
[null,"NOM",":",{"$f":"IF(Notice!D6=\"\",\"\",Notice!D6)","v":""},null,null,null,"École de rattachement",null,null,":",{"$f":"IF(Notice!D9=\"\",\"\",Notice!D9)","v":""}]
[null,"Prénom",":",{"$f":"IF(Notice!D7=\"\",\"\",Notice!D7)","v":""},null,null,null,"Circonscription",null,null,":",{"$f":"IF(Notice!D10=\"\",\"\",Notice!D10)","v":""}]
[null,"Qualité",":",{"$f":"IF(Notice!D8=\"\",\"\",Notice!D8)","v":""},null,null,null,"Zone de vacances",null,null,":",{"$f":"Notice!H23","v":"Zone A"}]
[]
[null,"LUNDI",null,null,"MARDI",null,"MERCREDI",null,"JEUDI",null,null,"VENDREDI",null,"Service effectué",1,"Solde de la semaine"]
[null,{"$f":"Notice!E25","v":"2015-01-05"},"horaire",null,{"$f":"B7+1","v":"2015-01-06"},"horaire",{"$f":"E7+1","v":"2015-01-07"},"horaire",{"$f":"G7+1","v":"2015-01-08"},"horaire",null,{"$f":"I7+1","v":"2015-01-09"},"horaire",{"$f":"IF(ISNUMBER(C7),C7,0)+IF(ISNUMBER(F7),F7,0)+IF(ISNUMBER(H7),H7,0)+IF(ISNUMBER(J7),J7,0)+IF(ISNUMBER(M7),M7,0)","v":0},{"$f":"IF(N7>0,N7-$O$6,0)","v":0},{"$f":"IF(O7<=0,0,IF(O7>0,TEXT(O7,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B7+7","v":"2015-01-12"},"horaire",null,{"$f":"B9+1","v":"2015-01-13"},"horaire",{"$f":"E9+1","v":"2015-01-14"},"horaire",{"$f":"G9+1","v":"2015-01-15"},"horaire",null,{"$f":"I9+1","v":"2015-01-16"},"horaire",{"$f":"IF(ISNUMBER(C9),C9,0)+IF(ISNUMBER(F9),F9,0)+IF(ISNUMBER(H9),H9,0)+IF(ISNUMBER(J9),J9,0)+IF(ISNUMBER(M9),M9,0)","v":0},{"$f":"IF(N9>0,N9-$O$6,0)","v":0},{"$f":"IF(O9<=0,0,IF(O9>0,TEXT(O9,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B9+7","v":"2015-01-19"},"horaire",null,{"$f":"B11+1","v":"2015-01-20"},"horaire",{"$f":"E11+1","v":"2015-01-21"},"horaire",{"$f":"G11+1","v":"2015-01-22"},"horaire",null,{"$f":"I11+1","v":"2015-01-23"},"horaire",{"$f":"IF(ISNUMBER(C11),C11,0)+IF(ISNUMBER(F11),F11,0)+IF(ISNUMBER(H11),H11,0)+IF(ISNUMBER(J11),J11,0)+IF(ISNUMBER(M11),M11,0)","v":0},{"$f":"IF(N11>0,N11-$O$6,0)","v":0},{"$f":"IF(O11<=0,0,IF(O11>0,TEXT(O11,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B11+7","v":"2015-01-26"},"horaire",null,{"$f":"B13+1","v":"2015-01-27"},"horaire",{"$f":"E13+1","v":"2015-01-28"},"horaire",{"$f":"G13+1","v":"2015-01-29"},"horaire",null,{"$f":"I13+1","v":"2015-01-30"},"horaire",{"$f":"IF(ISNUMBER(C13),C13,0)+IF(ISNUMBER(F13),F13,0)+IF(ISNUMBER(H13),H13,0)+IF(ISNUMBER(J13),J13,0)+IF(ISNUMBER(M13),M13,0)","v":0},{"$f":"IF(N13>0,N13-$O$6,0)","v":0},{"$f":"IF(O13<=0,0,IF(O13>0,TEXT(O13,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B13+7","v":"2015-02-02"},"horaire",null,{"$f":"B15+1","v":"2015-02-03"},"horaire",{"$f":"E15+1","v":"2015-02-04"},"horaire",{"$f":"G15+1","v":"2015-02-05"},"horaire",null,{"$f":"I15+1","v":"2015-02-06"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(F15),F15,0)+IF(ISNUMBER(H15),H15,0)+IF(ISNUMBER(J15),J15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,N15-$O$6,0)","v":0},{"$f":"IF(O15<=0,0,IF(O15>0,TEXT(O15,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B15+7","v":"2015-02-09"},"horaire",null,{"$f":"B17+1","v":"2015-02-10"},"horaire",{"$f":"E17+1","v":"2015-02-11"},"horaire",{"$f":"G17+1","v":"2015-02-12"},"horaire",null,{"$f":"I17+1","v":"2015-02-13"},"horaire",{"$f":"IF(ISNUMBER(C17),C17,0)+IF(ISNUMBER(F17),F17,0)+IF(ISNUMBER(H17),H17,0)+IF(ISNUMBER(J17),J17,0)+IF(ISNUMBER(M17),M17,0)","v":0},{"$f":"IF(N17>0,N17-$O$6,0)","v":0},{"$f":"IF(O17<=0,0,IF(O17>0,TEXT(O17,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B17+7","v":"2015-02-16"},"horaire",null,{"$f":"B19+1","v":"2015-02-17"},"horaire",{"$f":"E19+1","v":"2015-02-18"},"horaire",{"$f":"G19+1","v":"2015-02-19"},"horaire",null,{"$f":"I19+1","v":"2015-02-20"},"horaire",{"$f":"IF(ISNUMBER(C19),C19,0)+IF(ISNUMBER(F19),F19,0)+IF(ISNUMBER(H19),H19,0)+IF(ISNUMBER(J19),J19,0)+IF(ISNUMBER(M19),M19,0)","v":0},{"$f":"IF(N19>0,N19-$O$6,0)","v":0},{"$f":"IF(O19<=0,0,IF(O19>0,TEXT(O19,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(P7:P20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"Période2!P22+Période3!P22","v":0}]

{"sheet":"Période4","index":4,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,8,5,10],[1,3,1,5],[1,11,1,13],[2,3,2,5],[2,11,2,13],[5,11,5,12],[6,13,7,13],[9,11,9,12],[6,14,7,14],[8,14,9,14],[3,3,3,5],[3,7,3,9],[5,1,5,3],[5,4,5,5],[5,6,5,7],[6,15,7,15],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,10],[7,11,7,12],[6,2,6,3],[6,9,6,10],[10,13,11,13],[8,15,9,15],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,10],[11,11,11,12],[8,2,8,3],[8,9,8,10],[8,13,9,13],[12,13,13,13],[10,14,11,14],[10,15,11,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,10],[13,11,13,12],[10,2,10,3],[10,9,10,10],[14,13,15,13],[12,14,13,14],[12,15,13,15],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[15,11,15,12],[12,2,12,3],[12,9,12,10],[19,11,19,12],[14,14,15,14],[14,15,15,15],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,10],[17,11,17,12],[14,2,14,3],[14,9,14,10],[16,14,17,14],[16,15,17,15],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,10],[16,2,16,3],[16,9,16,10],[16,13,17,13],[20,17,20,18],[18,2,18,3],[18,9,18,10],[18,13,19,13],[18,14,19,14],[18,15,19,15],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,10]]}
[]
[null,"NOM",":",{"$f":"IF(Notice!D6=\"\",\"\",Notice!D6)","v":""},null,null,null,"École de rattachement",null,null,":",{"$f":"IF(Notice!D9=\"\",\"\",Notice!D9)","v":""}]
[null,"Prénom",":",{"$f":"IF(Notice!D7=\"\",\"\",Notice!D7)","v":""},null,null,null,"Circonscription",null,null,":",{"$f":"IF(Notice!D10=\"\",\"\",Notice!D10)","v":""}]
[null,"Qualité",":",{"$f":"IF(Notice!D8=\"\",\"\",Notice!D8)","v":""},null,null,null,"Zone de vacances",null,null,":",{"$f":"Notice!H23","v":"Zone A"}]
[]
[null,"LUNDI",null,null,"MARDI",null,"MERCREDI",null,"JEUDI",null,null,"VENDREDI",null,"Service effectué",1,"Solde de la semaine"]
[null,{"$f":"Notice!E26","v":"2014-02-23"},"horaire",null,{"$f":"B7+1","v":"2014-02-24"},"horaire",{"$f":"E7+1","v":"2014-02-25"},"horaire",{"$f":"G7+1","v":"2014-02-26"},"horaire",null,{"$f":"I7+1","v":"2014-02-27"},"horaire",{"$f":"IF(ISNUMBER(C7),C7,0)+IF(ISNUMBER(F7),F7,0)+IF(ISNUMBER(H7),H7,0)+IF(ISNUMBER(J7),J7,0)+IF(ISNUMBER(M7),M7,0)","v":0},{"$f":"IF(N7>0,N7-$O$6,0)","v":0},{"$f":"IF(O7<=0,0,IF(O7>0,TEXT(O7,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B7+7","v":"2014-03-02"},"horaire",null,{"$f":"B9+1","v":"2014-03-03"},"horaire",{"$f":"E9+1","v":"2014-03-04"},"horaire",{"$f":"G9+1","v":"2014-03-05"},"horaire",null,{"$f":"I9+1","v":"2014-03-06"},"horaire",{"$f":"IF(ISNUMBER(C9),C9,0)+IF(ISNUMBER(F9),F9,0)+IF(ISNUMBER(H9),H9,0)+IF(ISNUMBER(J9),J9,0)+IF(ISNUMBER(M9),M9,0)","v":0},{"$f":"IF(N9>0,N9-$O$6,0)","v":0},{"$f":"IF(O9<=0,0,IF(O9>0,TEXT(O9,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B9+7","v":"2014-03-09"},"horaire",null,{"$f":"B11+1","v":"2014-03-10"},"horaire",{"$f":"E11+1","v":"2014-03-11"},"horaire",{"$f":"G11+1","v":"2014-03-12"},"horaire",null,{"$f":"I11+1","v":"2014-03-13"},"horaire",{"$f":"IF(ISNUMBER(C11),C11,0)+IF(ISNUMBER(F11),F11,0)+IF(ISNUMBER(H11),H11,0)+IF(ISNUMBER(J11),J11,0)+IF(ISNUMBER(M11),M11,0)","v":0},{"$f":"IF(N11>0,N11-$O$6,0)","v":0},{"$f":"IF(O11<=0,0,IF(O11>0,TEXT(O11,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B11+7","v":"2014-03-16"},"horaire",null,{"$f":"B13+1","v":"2014-03-17"},"horaire",{"$f":"E13+1","v":"2014-03-18"},"horaire",{"$f":"G13+1","v":"2014-03-19"},"horaire",null,{"$f":"I13+1","v":"2014-03-20"},"horaire",{"$f":"IF(ISNUMBER(C13),C13,0)+IF(ISNUMBER(F13),F13,0)+IF(ISNUMBER(H13),H13,0)+IF(ISNUMBER(J13),J13,0)+IF(ISNUMBER(M13),M13,0)","v":0},{"$f":"IF(N13>0,N13-$O$6,0)","v":0},{"$f":"IF(O13<=0,0,IF(O13>0,TEXT(O13,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B13+7","v":"2014-03-23"},"Férié",null,{"$f":"B15+1","v":"2014-03-24"},"horaire",{"$f":"E15+1","v":"2014-03-25"},"horaire",{"$f":"G15+1","v":"2014-03-26"},"horaire",null,{"$f":"I15+1","v":"2014-03-27"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(F15),F15,0)+IF(ISNUMBER(H15),H15,0)+IF(ISNUMBER(J15),J15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,N15-$O$6,0)","v":0},{"$f":"IF(O15<=0,0,IF(O15>0,TEXT(O15,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,null,{"$f":"IF(S16<=0,0,IF(S16>0,TEXT(S16,\"hh:mm\")))","v":0}]
[null,{"$f":"B15+7","v":"2014-03-30"},"horaire",null,{"$f":"B17+1","v":"2014-03-31"},"horaire",{"$f":"E17+1","v":"2014-04-01"},"horaire",{"$f":"G17+1","v":"2014-04-02"},"horaire",null,{"$f":"I17+1","v":"2014-04-03"},"horaire",{"$f":"IF(ISNUMBER(C17),C17,0)+IF(ISNUMBER(F17),F17,0)+IF(ISNUMBER(H17),H17,0)+IF(ISNUMBER(J17),J17,0)+IF(ISNUMBER(M17),M17,0)","v":0},{"$f":"IF(N17>0,N17-$O$6,0)","v":0},{"$f":"IF(O17<=0,0,IF(O17>0,TEXT(O17,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B17+7","v":"2014-04-06"},"horaire",null,{"$f":"B19+1","v":"2014-04-07"},"horaire",{"$f":"E19+1","v":"2014-04-08"},"horaire",{"$f":"G19+1","v":"2014-04-09"},"horaire",null,{"$f":"I19+1","v":"2014-04-10"},"horaire",{"$f":"IF(ISNUMBER(C19),C19,0)+IF(ISNUMBER(F19),F19,0)+IF(ISNUMBER(H19),H19,0)+IF(ISNUMBER(J19),J19,0)+IF(ISNUMBER(M19),M19,0)","v":0},{"$f":"IF(N19>0,N19-$O$6,0)","v":0},{"$f":"IF(O19<=0,0,IF(O19>0,TEXT(O19,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(P7:P20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"Période3!P22+Période4!P22","v":0}]

{"sheet":"Période5","index":5,"n_rows":29,"n_cols":20,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,3,1,5],[1,11,1,13],[2,3,2,5],[2,11,2,13],[3,3,3,5],[3,7,3,9],[6,13,7,13],[6,14,7,14],[5,1,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,10],[5,11,5,12],[8,2,8,3],[8,9,8,10],[6,15,7,15],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,10],[7,11,7,12],[6,2,6,3],[6,9,6,10],[10,13,11,13],[10,14,11,14],[8,13,9,13],[8,14,9,14],[8,15,9,15],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,10],[9,11,9,12],[18,13,19,13],[18,14,19,14],[10,15,11,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,10],[11,11,11,12],[10,2,10,3],[10,9,10,10],[12,9,12,10],[12,13,13,13],[12,14,13,14],[18,15,19,15],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,10],[19,11,19,12],[18,2,18,3],[14,9,14,10],[14,13,15,13],[14,14,15,14],[12,15,13,15],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[13,11,13,12],[12,2,12,3],[22,13,23,13],[22,14,23,14],[16,14,17,14],[14,15,15,15],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,10],[15,11,15,12],[14,2,14,3],[23,1,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,10],[23,11,23,12],[17,11,17,12],[22,9,22,10],[18,9,18,10],[16,15,17,15],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,10],[25,11,25,12],[16,2,16,3],[16,9,16,10],[16,13,17,13],[24,2,24,3],[24,14,25,14],[22,2,22,3],[24,15,25,15],[25,1,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,10],[24,9,24,10],[24,13,25,13],[22,15,23,15],[20,15,21,15],[21,1,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,10],[21,11,21,12],[20,2,20,3],[20,9,20,10],[20,13,21,13],[20,14,21,14]]}
[]
[null,"NOM",":",{"$f":"IF(Notice!D6=\"\",\"\",Notice!D6)","v":""},null,null,null,"École de rattachement",null,null,":",{"$f":"IF(Notice!D9=\"\",\"\",Notice!D9)","v":""}]
[null,"Prénom",":",{"$f":"IF(Notice!D7=\"\",\"\",Notice!D7)","v":""},null,null,null,"Circonscription",null,null,":",{"$f":"IF(Notice!D10=\"\",\"\",Notice!D10)","v":""}]
[null,"Qualité",":",{"$f":"IF(Notice!D8=\"\",\"\",Notice!D8)","v":""},null,null,null,"Zone de vacances",null,null,":",{"$f":"Notice!H23","v":"Zone A"}]
[]
[null,"LUNDI",null,null,"MARDI",null,"MERCREDI",null,"JEUDI",null,null,"VENDREDI",null,"Service effectué",1,"Solde de la semaine"]
[null,"2014-04-27","horaire",null,{"$f":"B7+1","v":"2014-04-28"},"horaire",{"$f":"E7+1","v":"2014-04-29"},"horaire",{"$f":"G7+1","v":"2014-04-30"},"horaire",null,{"$f":"I7+1","v":"2014-05-01"},"Férié",{"$f":"IF(ISNUMBER(C7),C7,0)+IF(ISNUMBER(F7),F7,0)+IF(ISNUMBER(H7),H7,0)+IF(ISNUMBER(J7),J7,0)+IF(ISNUMBER(M7),M7,0)","v":0},{"$f":"IF(N7>0,N7-$O$6,0)","v":0},{"$f":"IF(O7<=0,0,IF(O7>0,TEXT(O7,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,null,{"$f":"IF(S8<=0,0,IF(S8>0,TEXT(S8,\"hh:mm\")))","v":0}]
[null,{"$f":"B7+7","v":"2014-05-04"},"horaire",null,{"$f":"B9+1","v":"2014-05-05"},"horaire",{"$f":"E9+1","v":"2014-05-06"},"horaire",{"$f":"G9+1","v":"2014-05-07"},"horaire",null,{"$f":"I9+1","v":"2014-05-08"},"Férié",{"$f":"IF(ISNUMBER(C9),C9,0)+IF(ISNUMBER(F9),F9,0)+IF(ISNUMBER(H9),H9,0)+IF(ISNUMBER(J9),J9,0)+IF(ISNUMBER(M9),M9,0)","v":0},{"$f":"IF(N9>0,N9-$O$6,0)","v":0},{"$f":"IF(O9<=0,0,IF(O9>0,TEXT(O9,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,null,{"$f":"IF(S10<=0,0,IF(S10>0,TEXT(S10,\"hh:mm\")))","v":0}]
[null,{"$f":"B9+7","v":"2014-05-11"},"horaire",null,{"$f":"B11+1","v":"2014-05-12"},"horaire",{"$f":"E11+1","v":"2014-05-13"},"horaire",{"$f":"G11+1","v":"2014-05-14"},"Férié",null,{"$f":"I11+1","v":"2014-05-15"},"horaire",{"$f":"IF(ISNUMBER(C11),C11,0)+IF(ISNUMBER(F11),F11,0)+IF(ISNUMBER(H11),H11,0)+IF(ISNUMBER(J11),J11,0)+IF(ISNUMBER(M11),M11,0)","v":0},{"$f":"IF(N11>0,N11-$O$6,0)","v":0},{"$f":"IF(O11<=0,0,IF(O11>0,TEXT(O11,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,null,{"$f":"IF(S12<=0,0,IF(S12>0,TEXT(S12,\"hh:mm\")))","v":0}]
[null,{"$f":"B11+7","v":"2014-05-18"},"horaire",null,{"$f":"B13+1","v":"2014-05-19"},"horaire",{"$f":"E13+1","v":"2014-05-20"},"horaire",{"$f":"G13+1","v":"2014-05-21"},"horaire",null,{"$f":"I13+1","v":"2014-05-22"},"horaire",{"$f":"IF(ISNUMBER(C13),C13,0)+IF(ISNUMBER(F13),F13,0)+IF(ISNUMBER(H13),H13,0)+IF(ISNUMBER(J13),J13,0)+IF(ISNUMBER(M13),M13,0)","v":0},{"$f":"IF(N13>0,N13-$O$6,0)","v":0},{"$f":"IF(O13<=0,0,IF(O13>0,TEXT(O13,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B13+7","v":"2014-05-25"},"Férié",null,{"$f":"B15+1","v":"2014-05-26"},"horaire",{"$f":"E15+1","v":"2014-05-27"},"horaire",{"$f":"G15+1","v":"2014-05-28"},"horaire",null,{"$f":"I15+1","v":"2014-05-29"},"horaire",{"$f":"IF(ISNUMBER(C15),C15,0)+IF(ISNUMBER(F15),F15,0)+IF(ISNUMBER(H15),H15,0)+IF(ISNUMBER(J15),J15,0)+IF(ISNUMBER(M15),M15,0)","v":0},{"$f":"IF(N15>0,N15-$O$6,0)","v":0},{"$f":"IF(O15<=0,0,IF(O15>0,TEXT(O15,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école",null,null,null,null,null,null,null,{"$f":"IF(S16<=0,0,IF(S16>0,TEXT(S16,\"hh:mm\")))","v":0}]
[null,{"$f":"B15+7","v":"2014-06-01"},"horaire",null,{"$f":"B17+1","v":"2014-06-02"},"horaire",{"$f":"E17+1","v":"2014-06-03"},"horaire",{"$f":"G17+1","v":"2014-06-04"},"horaire",null,{"$f":"I17+1","v":"2014-06-05"},"horaire",{"$f":"IF(ISNUMBER(C17),C17,0)+IF(ISNUMBER(F17),F17,0)+IF(ISNUMBER(H17),H17,0)+IF(ISNUMBER(J17),J17,0)+IF(ISNUMBER(M17),M17,0)","v":0},{"$f":"IF(N17>0,N17-$O$6,0)","v":0},{"$f":"IF(O17<=0,0,IF(O17>0,TEXT(O17,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B17+7","v":"2014-06-08"},"horaire",null,{"$f":"B19+1","v":"2014-06-09"},"horaire",{"$f":"E19+1","v":"2014-06-10"},"horaire",{"$f":"G19+1","v":"2014-06-11"},"horaire",null,{"$f":"I19+1","v":"2014-06-12"},"horaire",{"$f":"IF(ISNUMBER(C19),C19,0)+IF(ISNUMBER(F19),F19,0)+IF(ISNUMBER(H19),H19,0)+IF(ISNUMBER(J19),J19,0)+IF(ISNUMBER(M19),M19,0)","v":0},{"$f":"IF(N19>0,N19-$O$6,0)","v":0},{"$f":"IF(O19<=0,0,IF(O19>0,TEXT(O19,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B19+7","v":"2014-06-15"},"horaire",null,{"$f":"B21+1","v":"2014-06-16"},"horaire",{"$f":"E21+1","v":"2014-06-17"},"horaire",{"$f":"G21+1","v":"2014-06-18"},"horaire",null,{"$f":"I21+1","v":"2014-06-19"},"horaire",{"$f":"IF(ISNUMBER(C21),C21,0)+IF(ISNUMBER(F21),F21,0)+IF(ISNUMBER(H21),H21,0)+IF(ISNUMBER(J21),J21,0)+IF(ISNUMBER(M21),M21,0)","v":0},{"$f":"IF(N21>0,N21-$O$6,0)","v":0},{"$f":"IF(O21<=0,0,IF(O21>0,TEXT(O21,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B21+7","v":"2014-06-22"},"horaire",null,{"$f":"B23+1","v":"2014-06-23"},"horaire",{"$f":"E23+1","v":"2014-06-24"},"horaire",{"$f":"G23+1","v":"2014-06-25"},"horaire",null,{"$f":"I23+1","v":"2014-06-26"},"horaire",{"$f":"IF(ISNUMBER(C23),C23,0)+IF(ISNUMBER(F23),F23,0)+IF(ISNUMBER(H23),H23,0)+IF(ISNUMBER(J23),J23,0)+IF(ISNUMBER(M23),M23,0)","v":0},{"$f":"IF(N23>0,N23-$O$6,0)","v":0},{"$f":"IF(O23<=0,0,IF(O23>0,TEXT(O23,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[null,{"$f":"B23+7","v":"2014-06-29"},"horaire",null,{"$f":"B25+1","v":"2014-06-30"},"horaire",{"$f":"E25+1","v":"2014-07-01"},"horaire",{"$f":"G25+1","v":"2014-07-02"},"horaire",null,{"$f":"I25+1","v":"2014-07-03"},"horaire",{"$f":"IF(ISNUMBER(C25),C25,0)+IF(ISNUMBER(F25),F25,0)+IF(ISNUMBER(H25),H25,0)+IF(ISNUMBER(J25),J25,0)+IF(ISNUMBER(M25),M25,0)","v":0},{"$f":"IF(N25>0,N25-$O$6,0)","v":0},{"$f":"IF(O25<=0,0,IF(O25>0,TEXT(O25,\"hh:mm\")))","v":0}]
[null,"école",null,null,"école",null,"école",null,"école",null,null,"école"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Solde de la période",null,{"$f":"SUM(P7:P26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumul annuel",null,{"$f":"Période4!P22+Période5!P28","v":0}]