{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Noms des employés"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Janvier","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,"Calendrier des absences des employés"]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[{"$nulls":33},"Entrez l’année :"]
[null,"Janvier","Dates d’absence",{"$nulls":30},2016]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,1),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,2),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,3),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,4),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,5),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,6),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,7),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,8),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,9),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,10),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,11),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,12),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,13),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,14),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,15),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,16),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,17),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,18),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,19),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,20),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,21),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,22),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,23),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,24),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,25),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,26),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,27),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,28),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,29),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,30),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,1,31),1),\"jjj\")","v":"dim"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",null,null,"C","C","C","C",{"$nulls":6},"C",{"$nulls":18},{"$f":"COUNTA(Janvier!$C7:$AG7)","v":5}]
[null,"Employé 2",{"$nulls":4},"M","M",{"$nulls":4},"P",{"$nulls":8},"M",{"$nulls":4},"C","C","C",{"$nulls":4},{"$f":"COUNTA(Janvier!$C8:$AG8)","v":7}]
[null,"Employé 3",null,null,"P",{"$nulls":10},"M",{"$nulls":14},"M",null,null,{"$f":"COUNTA(Janvier!$C9:$AG9)","v":3}]
[null,"Employé 4",{"$nulls":6},"P",{"$nulls":11},"C","C","C",{"$nulls":10},{"$f":"COUNTA(Janvier!$C10:$AG10)","v":4}]
[null,"Employé 5",{"$nulls":3},"M","C","C",{"$nulls":10},"M",{"$nulls":6},"M",{"$nulls":6},"C",{"$f":"COUNTA(Janvier!$C11:$AG11)","v":6}]
[null,{"$f":"NomMois&\" Total\"","v":"Janvier Total"},{"$f":"SUBTOTAL(103,Janvier!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,Janvier!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,Janvier!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,Janvier!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,Janvier!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,Janvier!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,Janvier!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,Janvier!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,Janvier[Total des jours])","v":25}]

{"sheet":"Février","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Février","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,1),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,2),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,3),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,4),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,5),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,6),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,7),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,8),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,9),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,10),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,11),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,12),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,13),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,14),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,15),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,16),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,17),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,18),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,19),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,20),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,21),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,22),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,23),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,24),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,25),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,26),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,27),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,28),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,2,29),1),\"jjj\")","v":"lun"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"," ","  ","Total des jours"]
[null,"Employé 1",null,null,"C","C","C","C",{"$nulls":6},"C",{"$nulls":18},{"$f":"COUNTA(Février[[#This Row],[1]:[29]])","v":5}]
[null,"Employé 2",{"$nulls":4},"M","M",{"$nulls":4},"P",{"$nulls":8},"M",{"$nulls":4},"C","C","C",{"$nulls":4},{"$f":"COUNTA(Février[[#This Row],[1]:[29]])","v":7}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Février[[#This Row],[1]:[29]])","v":0}]
[null,"Employé 4",null,null,"M",{"$nulls":10},"M",{"$nulls":3},"P",{"$nulls":9},"M",{"$nulls":3},{"$f":"COUNTA(Février[[#This Row],[1]:[29]])","v":4}]
[null,"Employé 5",{"$nulls":7},"C","C","C","C",{"$nulls":12},"M",{"$nulls":7},{"$f":"COUNTA(Février[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"NomMois&\" Total\"","v":"Février Total"},{"$f":"SUBTOTAL(103,Février[1])","v":0},{"$f":"SUBTOTAL(103,Février[2])","v":0},{"$f":"SUBTOTAL(103,Février[3])","v":2},{"$f":"SUBTOTAL(103,Février[4])","v":1},{"$f":"SUBTOTAL(103,Février[5])","v":2},{"$f":"SUBTOTAL(103,Février[6])","v":2},{"$f":"SUBTOTAL(103,Février[7])","v":0},{"$f":"SUBTOTAL(103,Février[8])","v":1},{"$f":"SUBTOTAL(103,Février[9])","v":1},{"$f":"SUBTOTAL(103,Février[10])","v":1},{"$f":"SUBTOTAL(103,Février[11])","v":2},{"$f":"SUBTOTAL(103,Février[12])","v":0},{"$f":"SUBTOTAL(103,Février[13])","v":1},{"$f":"SUBTOTAL(103,Février[14])","v":1},{"$f":"SUBTOTAL(103,Février[15])","v":0},{"$f":"SUBTOTAL(103,Février[16])","v":0},{"$f":"SUBTOTAL(103,Février[17])","v":0},{"$f":"SUBTOTAL(103,Février[18])","v":1},{"$f":"SUBTOTAL(103,Février[19])","v":0},{"$f":"SUBTOTAL(103,Février[20])","v":1},{"$f":"SUBTOTAL(103,Février[21])","v":0},{"$f":"SUBTOTAL(103,Février[22])","v":0},{"$f":"SUBTOTAL(103,Février[23])","v":0},{"$f":"SUBTOTAL(103,Février[24])","v":1},{"$f":"SUBTOTAL(103,Février[25])","v":1},{"$f":"SUBTOTAL(103,Février[26])","v":1},{"$f":"SUBTOTAL(103,Février[27])","v":1},{"$f":"SUBTOTAL(103,Février[28])","v":1},{"$f":"SUBTOTAL(103,Février[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Février[Total des jours])","v":21}]

{"sheet":"Mars","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Mars","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,1),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,2),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,3),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,4),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,5),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,6),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,7),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,8),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,9),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,10),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,11),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,12),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,13),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,14),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,15),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,16),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,17),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,18),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,19),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,20),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,21),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,22),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,23),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,24),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,25),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,26),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,27),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,28),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,29),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,30),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,3,31),1),\"jjj\")","v":"jeu"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Mars[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Mars[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Mars[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Mars[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Mars[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Mars Total"},{"$f":"SUBTOTAL(103,Mars[1])","v":0},{"$f":"SUBTOTAL(103,Mars[2])","v":0},{"$f":"SUBTOTAL(103,Mars[3])","v":0},{"$f":"SUBTOTAL(103,Mars[4])","v":0},{"$f":"SUBTOTAL(103,Mars[5])","v":0},{"$f":"SUBTOTAL(103,Mars[6])","v":0},{"$f":"SUBTOTAL(103,Mars[7])","v":0},{"$f":"SUBTOTAL(103,Mars[8])","v":0},{"$f":"SUBTOTAL(103,Mars[9])","v":0},{"$f":"SUBTOTAL(103,Mars[10])","v":0},{"$f":"SUBTOTAL(103,Mars[11])","v":0},{"$f":"SUBTOTAL(103,Mars[12])","v":0},{"$f":"SUBTOTAL(103,Mars[13])","v":0},{"$f":"SUBTOTAL(103,Mars[14])","v":0},{"$f":"SUBTOTAL(103,Mars[15])","v":0},{"$f":"SUBTOTAL(103,Mars[16])","v":0},{"$f":"SUBTOTAL(103,Mars[17])","v":0},{"$f":"SUBTOTAL(103,Mars[18])","v":0},{"$f":"SUBTOTAL(103,Mars[19])","v":0},{"$f":"SUBTOTAL(103,Mars[20])","v":0},{"$f":"SUBTOTAL(103,Mars[21])","v":0},{"$f":"SUBTOTAL(103,Mars[22])","v":0},{"$f":"SUBTOTAL(103,Mars[23])","v":0},{"$f":"SUBTOTAL(103,Mars[24])","v":0},{"$f":"SUBTOTAL(103,Mars[25])","v":0},{"$f":"SUBTOTAL(103,Mars[26])","v":0},{"$f":"SUBTOTAL(103,Mars[27])","v":0},{"$f":"SUBTOTAL(103,Mars[28])","v":0},{"$f":"SUBTOTAL(103,Mars[29])","v":0},{"$f":"SUBTOTAL(109,Mars[30])","v":0},{"$f":"SUBTOTAL(109,Mars[31])","v":0},{"$f":"SUBTOTAL(109,Mars[Total des jours])","v":0}]

{"sheet":"Avril","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Avril","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,1),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,2),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,3),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,4),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,5),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,6),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,7),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,8),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,9),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,10),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,11),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,12),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,13),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,14),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,15),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,16),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,17),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,18),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,19),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,20),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,21),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,22),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,23),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,24),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,25),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,26),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,27),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,28),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,29),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,4,30),1),\"jjj\")","v":"sam"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Avril[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Avril[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Avril[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Avril[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Avril[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Avril Total"},{"$f":"SUBTOTAL(103,Avril[1])","v":0},{"$f":"SUBTOTAL(103,Avril[2])","v":0},{"$f":"SUBTOTAL(103,Avril[3])","v":0},{"$f":"SUBTOTAL(103,Avril[4])","v":0},{"$f":"SUBTOTAL(103,Avril[5])","v":0},{"$f":"SUBTOTAL(103,Avril[6])","v":0},{"$f":"SUBTOTAL(103,Avril[7])","v":0},{"$f":"SUBTOTAL(103,Avril[8])","v":0},{"$f":"SUBTOTAL(103,Avril[9])","v":0},{"$f":"SUBTOTAL(103,Avril[10])","v":0},{"$f":"SUBTOTAL(103,Avril[11])","v":0},{"$f":"SUBTOTAL(103,Avril[12])","v":0},{"$f":"SUBTOTAL(103,Avril[13])","v":0},{"$f":"SUBTOTAL(103,Avril[14])","v":0},{"$f":"SUBTOTAL(103,Avril[15])","v":0},{"$f":"SUBTOTAL(103,Avril[16])","v":0},{"$f":"SUBTOTAL(103,Avril[17])","v":0},{"$f":"SUBTOTAL(103,Avril[18])","v":0},{"$f":"SUBTOTAL(103,Avril[19])","v":0},{"$f":"SUBTOTAL(103,Avril[20])","v":0},{"$f":"SUBTOTAL(103,Avril[21])","v":0},{"$f":"SUBTOTAL(103,Avril[22])","v":0},{"$f":"SUBTOTAL(103,Avril[23])","v":0},{"$f":"SUBTOTAL(103,Avril[24])","v":0},{"$f":"SUBTOTAL(103,Avril[25])","v":0},{"$f":"SUBTOTAL(103,Avril[26])","v":0},{"$f":"SUBTOTAL(103,Avril[27])","v":0},{"$f":"SUBTOTAL(103,Avril[28])","v":0},{"$f":"SUBTOTAL(103,Avril[29])","v":0},{"$f":"SUBTOTAL(109,Avril[30])","v":0},{"$f":"SUBTOTAL(109,Avril[31])","v":0},{"$f":"SUBTOTAL(109,Avril[Total des jours])","v":0}]

{"sheet":"Mai","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Mai","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,1),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,2),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,3),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,4),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,5),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,6),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,7),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,8),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,9),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,10),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,11),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,12),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,13),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,14),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,15),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,16),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,17),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,18),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,19),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,20),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,21),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,22),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,23),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,24),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,25),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,26),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,27),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,28),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,29),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,30),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,5,31),1),\"jjj\")","v":"mar"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Mai[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Mai[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Mai[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Mai[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Mai[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Mai Total"},{"$f":"SUBTOTAL(103,Mai[1])","v":0},{"$f":"SUBTOTAL(103,Mai[2])","v":0},{"$f":"SUBTOTAL(103,Mai[3])","v":0},{"$f":"SUBTOTAL(103,Mai[4])","v":0},{"$f":"SUBTOTAL(103,Mai[5])","v":0},{"$f":"SUBTOTAL(103,Mai[6])","v":0},{"$f":"SUBTOTAL(103,Mai[7])","v":0},{"$f":"SUBTOTAL(103,Mai[8])","v":0},{"$f":"SUBTOTAL(103,Mai[9])","v":0},{"$f":"SUBTOTAL(103,Mai[10])","v":0},{"$f":"SUBTOTAL(103,Mai[11])","v":0},{"$f":"SUBTOTAL(103,Mai[12])","v":0},{"$f":"SUBTOTAL(103,Mai[13])","v":0},{"$f":"SUBTOTAL(103,Mai[14])","v":0},{"$f":"SUBTOTAL(103,Mai[15])","v":0},{"$f":"SUBTOTAL(103,Mai[16])","v":0},{"$f":"SUBTOTAL(103,Mai[17])","v":0},{"$f":"SUBTOTAL(103,Mai[18])","v":0},{"$f":"SUBTOTAL(103,Mai[19])","v":0},{"$f":"SUBTOTAL(103,Mai[20])","v":0},{"$f":"SUBTOTAL(103,Mai[21])","v":0},{"$f":"SUBTOTAL(103,Mai[22])","v":0},{"$f":"SUBTOTAL(103,Mai[23])","v":0},{"$f":"SUBTOTAL(103,Mai[24])","v":0},{"$f":"SUBTOTAL(103,Mai[25])","v":0},{"$f":"SUBTOTAL(103,Mai[26])","v":0},{"$f":"SUBTOTAL(103,Mai[27])","v":0},{"$f":"SUBTOTAL(103,Mai[28])","v":0},{"$f":"SUBTOTAL(103,Mai[29])","v":0},{"$f":"SUBTOTAL(109,Mai[30])","v":0},{"$f":"SUBTOTAL(109,Mai[31])","v":0},{"$f":"SUBTOTAL(109,Mai[Total des jours])","v":0}]

{"sheet":"Juin","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Juin","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,1),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,2),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,3),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,4),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,5),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,6),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,7),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,8),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,9),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,10),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,11),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,12),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,13),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,14),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,15),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,16),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,17),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,18),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,19),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,20),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,21),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,22),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,23),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,24),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,25),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,26),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,27),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,28),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,29),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,6,30),1),\"jjj\")","v":"jeu"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Juin[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Juin[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Juin[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Juin[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Juin[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Juin Total"},{"$f":"SUBTOTAL(103,Juin[1])","v":0},{"$f":"SUBTOTAL(103,Juin[2])","v":0},{"$f":"SUBTOTAL(103,Juin[3])","v":0},{"$f":"SUBTOTAL(103,Juin[4])","v":0},{"$f":"SUBTOTAL(103,Juin[5])","v":0},{"$f":"SUBTOTAL(103,Juin[6])","v":0},{"$f":"SUBTOTAL(103,Juin[7])","v":0},{"$f":"SUBTOTAL(103,Juin[8])","v":0},{"$f":"SUBTOTAL(103,Juin[9])","v":0},{"$f":"SUBTOTAL(103,Juin[10])","v":0},{"$f":"SUBTOTAL(103,Juin[11])","v":0},{"$f":"SUBTOTAL(103,Juin[12])","v":0},{"$f":"SUBTOTAL(103,Juin[13])","v":0},{"$f":"SUBTOTAL(103,Juin[14])","v":0},{"$f":"SUBTOTAL(103,Juin[15])","v":0},{"$f":"SUBTOTAL(103,Juin[16])","v":0},{"$f":"SUBTOTAL(103,Juin[17])","v":0},{"$f":"SUBTOTAL(103,Juin[18])","v":0},{"$f":"SUBTOTAL(103,Juin[19])","v":0},{"$f":"SUBTOTAL(103,Juin[20])","v":0},{"$f":"SUBTOTAL(103,Juin[21])","v":0},{"$f":"SUBTOTAL(103,Juin[22])","v":0},{"$f":"SUBTOTAL(103,Juin[23])","v":0},{"$f":"SUBTOTAL(103,Juin[24])","v":0},{"$f":"SUBTOTAL(103,Juin[25])","v":0},{"$f":"SUBTOTAL(103,Juin[26])","v":0},{"$f":"SUBTOTAL(103,Juin[27])","v":0},{"$f":"SUBTOTAL(103,Juin[28])","v":0},{"$f":"SUBTOTAL(103,Juin[29])","v":0},{"$f":"SUBTOTAL(109,Juin[30])","v":0},{"$f":"SUBTOTAL(109,Juin[31])","v":0},{"$f":"SUBTOTAL(109,Juin[Total des jours])","v":0}]

{"sheet":"Juillet","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Juillet","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,1),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,2),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,3),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,4),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,5),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,6),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,7),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,8),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,9),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,10),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,11),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,12),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,13),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,14),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,15),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,16),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,17),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,18),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,19),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,20),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,21),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,22),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,23),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,24),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,25),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,26),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,27),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,28),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,29),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,30),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,7,31),1),\"jjj\")","v":"dim"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Juillet[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Juillet[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Juillet[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Juillet[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Juillet[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Juillet Total"},{"$f":"SUBTOTAL(103,Juillet[1])","v":0},{"$f":"SUBTOTAL(103,Juillet[2])","v":0},{"$f":"SUBTOTAL(103,Juillet[3])","v":0},{"$f":"SUBTOTAL(103,Juillet[4])","v":0},{"$f":"SUBTOTAL(103,Juillet[5])","v":0},{"$f":"SUBTOTAL(103,Juillet[6])","v":0},{"$f":"SUBTOTAL(103,Juillet[7])","v":0},{"$f":"SUBTOTAL(103,Juillet[8])","v":0},{"$f":"SUBTOTAL(103,Juillet[9])","v":0},{"$f":"SUBTOTAL(103,Juillet[10])","v":0},{"$f":"SUBTOTAL(103,Juillet[11])","v":0},{"$f":"SUBTOTAL(103,Juillet[12])","v":0},{"$f":"SUBTOTAL(103,Juillet[13])","v":0},{"$f":"SUBTOTAL(103,Juillet[14])","v":0},{"$f":"SUBTOTAL(103,Juillet[15])","v":0},{"$f":"SUBTOTAL(103,Juillet[16])","v":0},{"$f":"SUBTOTAL(103,Juillet[17])","v":0},{"$f":"SUBTOTAL(103,Juillet[18])","v":0},{"$f":"SUBTOTAL(103,Juillet[19])","v":0},{"$f":"SUBTOTAL(103,Juillet[20])","v":0},{"$f":"SUBTOTAL(103,Juillet[21])","v":0},{"$f":"SUBTOTAL(103,Juillet[22])","v":0},{"$f":"SUBTOTAL(103,Juillet[23])","v":0},{"$f":"SUBTOTAL(103,Juillet[24])","v":0},{"$f":"SUBTOTAL(103,Juillet[25])","v":0},{"$f":"SUBTOTAL(103,Juillet[26])","v":0},{"$f":"SUBTOTAL(103,Juillet[27])","v":0},{"$f":"SUBTOTAL(103,Juillet[28])","v":0},{"$f":"SUBTOTAL(103,Juillet[29])","v":0},{"$f":"SUBTOTAL(109,Juillet[30])","v":0},{"$f":"SUBTOTAL(109,Juillet[31])","v":0},{"$f":"SUBTOTAL(109,Juillet[Total des jours])","v":0}]

{"sheet":"Août","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Août","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,1),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,2),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,3),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,4),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,5),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,6),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,7),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,8),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,9),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,10),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,11),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,12),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,13),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,14),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,15),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,16),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,17),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,18),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,19),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,20),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,21),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,22),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,23),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,24),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,25),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,26),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,27),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,28),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,29),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,30),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,8,31),1),\"jjj\")","v":"mer"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Août[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Août[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Août[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Août[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Août[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Août Total"},{"$f":"SUBTOTAL(103,Août[1])","v":0},{"$f":"SUBTOTAL(103,Août[2])","v":0},{"$f":"SUBTOTAL(103,Août[3])","v":0},{"$f":"SUBTOTAL(103,Août[4])","v":0},{"$f":"SUBTOTAL(103,Août[5])","v":0},{"$f":"SUBTOTAL(103,Août[6])","v":0},{"$f":"SUBTOTAL(103,Août[7])","v":0},{"$f":"SUBTOTAL(103,Août[8])","v":0},{"$f":"SUBTOTAL(103,Août[9])","v":0},{"$f":"SUBTOTAL(103,Août[10])","v":0},{"$f":"SUBTOTAL(103,Août[11])","v":0},{"$f":"SUBTOTAL(103,Août[12])","v":0},{"$f":"SUBTOTAL(103,Août[13])","v":0},{"$f":"SUBTOTAL(103,Août[14])","v":0},{"$f":"SUBTOTAL(103,Août[15])","v":0},{"$f":"SUBTOTAL(103,Août[16])","v":0},{"$f":"SUBTOTAL(103,Août[17])","v":0},{"$f":"SUBTOTAL(103,Août[18])","v":0},{"$f":"SUBTOTAL(103,Août[19])","v":0},{"$f":"SUBTOTAL(103,Août[20])","v":0},{"$f":"SUBTOTAL(103,Août[21])","v":0},{"$f":"SUBTOTAL(103,Août[22])","v":0},{"$f":"SUBTOTAL(103,Août[23])","v":0},{"$f":"SUBTOTAL(103,Août[24])","v":0},{"$f":"SUBTOTAL(103,Août[25])","v":0},{"$f":"SUBTOTAL(103,Août[26])","v":0},{"$f":"SUBTOTAL(103,Août[27])","v":0},{"$f":"SUBTOTAL(103,Août[28])","v":0},{"$f":"SUBTOTAL(103,Août[29])","v":0},{"$f":"SUBTOTAL(109,Août[30])","v":0},{"$f":"SUBTOTAL(109,Août[31])","v":0},{"$f":"SUBTOTAL(109,Août[Total des jours])","v":0}]

{"sheet":"Septembre","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Septembre","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,1),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,2),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,3),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,4),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,5),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,6),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,7),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,8),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,9),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,10),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,11),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,12),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,13),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,14),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,15),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,16),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,17),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,18),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,19),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,20),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,21),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,22),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,23),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,24),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,25),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,26),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,27),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,28),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,29),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,9,30),1),\"jjj\")","v":"ven"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Septembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Septembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Septembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Septembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Septembre[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Septembre Total"},{"$f":"SUBTOTAL(103,Septembre[1])","v":0},{"$f":"SUBTOTAL(103,Septembre[2])","v":0},{"$f":"SUBTOTAL(103,Septembre[3])","v":0},{"$f":"SUBTOTAL(103,Septembre[4])","v":0},{"$f":"SUBTOTAL(103,Septembre[5])","v":0},{"$f":"SUBTOTAL(103,Septembre[6])","v":0},{"$f":"SUBTOTAL(103,Septembre[7])","v":0},{"$f":"SUBTOTAL(103,Septembre[8])","v":0},{"$f":"SUBTOTAL(103,Septembre[9])","v":0},{"$f":"SUBTOTAL(103,Septembre[10])","v":0},{"$f":"SUBTOTAL(103,Septembre[11])","v":0},{"$f":"SUBTOTAL(103,Septembre[12])","v":0},{"$f":"SUBTOTAL(103,Septembre[13])","v":0},{"$f":"SUBTOTAL(103,Septembre[14])","v":0},{"$f":"SUBTOTAL(103,Septembre[15])","v":0},{"$f":"SUBTOTAL(103,Septembre[16])","v":0},{"$f":"SUBTOTAL(103,Septembre[17])","v":0},{"$f":"SUBTOTAL(103,Septembre[18])","v":0},{"$f":"SUBTOTAL(103,Septembre[19])","v":0},{"$f":"SUBTOTAL(103,Septembre[20])","v":0},{"$f":"SUBTOTAL(103,Septembre[21])","v":0},{"$f":"SUBTOTAL(103,Septembre[22])","v":0},{"$f":"SUBTOTAL(103,Septembre[23])","v":0},{"$f":"SUBTOTAL(103,Septembre[24])","v":0},{"$f":"SUBTOTAL(103,Septembre[25])","v":0},{"$f":"SUBTOTAL(103,Septembre[26])","v":0},{"$f":"SUBTOTAL(103,Septembre[27])","v":0},{"$f":"SUBTOTAL(103,Septembre[28])","v":0},{"$f":"SUBTOTAL(103,Septembre[29])","v":0},{"$f":"SUBTOTAL(109,Septembre[30])","v":0},{"$f":"SUBTOTAL(109,Septembre[31])","v":0},{"$f":"SUBTOTAL(109,Septembre[Total des jours])","v":0}]

{"sheet":"Octobre","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Octobre","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,1),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,2),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,3),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,4),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,5),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,6),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,7),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,8),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,9),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,10),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,11),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,12),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,13),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,14),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,15),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,16),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,17),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,18),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,19),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,20),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,21),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,22),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,23),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,24),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,25),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,26),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,27),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,28),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,29),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,30),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,10,31),1),\"jjj\")","v":"lun"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Octobre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Octobre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Octobre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Octobre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Octobre[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Octobre Total"},{"$f":"SUBTOTAL(103,Octobre[1])","v":0},{"$f":"SUBTOTAL(103,Octobre[2])","v":0},{"$f":"SUBTOTAL(103,Octobre[3])","v":0},{"$f":"SUBTOTAL(103,Octobre[4])","v":0},{"$f":"SUBTOTAL(103,Octobre[5])","v":0},{"$f":"SUBTOTAL(103,Octobre[6])","v":0},{"$f":"SUBTOTAL(103,Octobre[7])","v":0},{"$f":"SUBTOTAL(103,Octobre[8])","v":0},{"$f":"SUBTOTAL(103,Octobre[9])","v":0},{"$f":"SUBTOTAL(103,Octobre[10])","v":0},{"$f":"SUBTOTAL(103,Octobre[11])","v":0},{"$f":"SUBTOTAL(103,Octobre[12])","v":0},{"$f":"SUBTOTAL(103,Octobre[13])","v":0},{"$f":"SUBTOTAL(103,Octobre[14])","v":0},{"$f":"SUBTOTAL(103,Octobre[15])","v":0},{"$f":"SUBTOTAL(103,Octobre[16])","v":0},{"$f":"SUBTOTAL(103,Octobre[17])","v":0},{"$f":"SUBTOTAL(103,Octobre[18])","v":0},{"$f":"SUBTOTAL(103,Octobre[19])","v":0},{"$f":"SUBTOTAL(103,Octobre[20])","v":0},{"$f":"SUBTOTAL(103,Octobre[21])","v":0},{"$f":"SUBTOTAL(103,Octobre[22])","v":0},{"$f":"SUBTOTAL(103,Octobre[23])","v":0},{"$f":"SUBTOTAL(103,Octobre[24])","v":0},{"$f":"SUBTOTAL(103,Octobre[25])","v":0},{"$f":"SUBTOTAL(103,Octobre[26])","v":0},{"$f":"SUBTOTAL(103,Octobre[27])","v":0},{"$f":"SUBTOTAL(103,Octobre[28])","v":0},{"$f":"SUBTOTAL(103,Octobre[29])","v":0},{"$f":"SUBTOTAL(109,Octobre[30])","v":0},{"$f":"SUBTOTAL(109,Octobre[31])","v":0},{"$f":"SUBTOTAL(109,Octobre[Total des jours])","v":0}]

{"sheet":"Novembre","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Novembre","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,1),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,2),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,3),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,4),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,5),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,6),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,7),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,8),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,9),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,10),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,11),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,12),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,13),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,14),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,15),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,16),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,17),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,18),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,19),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,20),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,21),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,22),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,23),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,24),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,25),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,26),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,27),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,28),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,29),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,11,30),1),\"jjj\")","v":"mer"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Novembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Novembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Novembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Novembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Novembre[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Novembre Total"},{"$f":"SUBTOTAL(103,Novembre[1])","v":0},{"$f":"SUBTOTAL(103,Novembre[2])","v":0},{"$f":"SUBTOTAL(103,Novembre[3])","v":0},{"$f":"SUBTOTAL(103,Novembre[4])","v":0},{"$f":"SUBTOTAL(103,Novembre[5])","v":0},{"$f":"SUBTOTAL(103,Novembre[6])","v":0},{"$f":"SUBTOTAL(103,Novembre[7])","v":0},{"$f":"SUBTOTAL(103,Novembre[8])","v":0},{"$f":"SUBTOTAL(103,Novembre[9])","v":0},{"$f":"SUBTOTAL(103,Novembre[10])","v":0},{"$f":"SUBTOTAL(103,Novembre[11])","v":0},{"$f":"SUBTOTAL(103,Novembre[12])","v":0},{"$f":"SUBTOTAL(103,Novembre[13])","v":0},{"$f":"SUBTOTAL(103,Novembre[14])","v":0},{"$f":"SUBTOTAL(103,Novembre[15])","v":0},{"$f":"SUBTOTAL(103,Novembre[16])","v":0},{"$f":"SUBTOTAL(103,Novembre[17])","v":0},{"$f":"SUBTOTAL(103,Novembre[18])","v":0},{"$f":"SUBTOTAL(103,Novembre[19])","v":0},{"$f":"SUBTOTAL(103,Novembre[20])","v":0},{"$f":"SUBTOTAL(103,Novembre[21])","v":0},{"$f":"SUBTOTAL(103,Novembre[22])","v":0},{"$f":"SUBTOTAL(103,Novembre[23])","v":0},{"$f":"SUBTOTAL(103,Novembre[24])","v":0},{"$f":"SUBTOTAL(103,Novembre[25])","v":0},{"$f":"SUBTOTAL(103,Novembre[26])","v":0},{"$f":"SUBTOTAL(103,Novembre[27])","v":0},{"$f":"SUBTOTAL(103,Novembre[28])","v":0},{"$f":"SUBTOTAL(103,Novembre[29])","v":0},{"$f":"SUBTOTAL(109,Novembre[30])","v":0},{"$f":"SUBTOTAL(109,Novembre[31])","v":0},{"$f":"SUBTOTAL(109,Novembre[Total des jours])","v":0}]

{"sheet":"Décembre","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,11],[1,13,1,16],[1,18,1,21],[3,2,3,32]]}
[null,{"$f":"Titre_Absence_Employé","v":"Calendrier des absences des employés"}]
[null,"Clé de motif d’absence","C","Congé",null,"P","Personnel",null,null,"M","Maladie",null,null,"Personnalisé 1",{"$nulls":4},"Personnalisé 2"]
[]
[null,"Décembre","Dates d’absence",{"$nulls":30},{"$f":"AnnéeCalendrier","v":2016}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,1),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,2),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,3),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,4),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,5),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,6),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,7),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,8),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,9),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,10),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,11),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,12),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,13),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,14),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,15),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,16),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,17),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,18),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,19),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,20),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,21),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,22),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,23),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,24),1),\"jjj\")","v":"sam"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,25),1),\"jjj\")","v":"dim"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,26),1),\"jjj\")","v":"lun"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,27),1),\"jjj\")","v":"mar"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,28),1),\"jjj\")","v":"mer"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,29),1),\"jjj\")","v":"jeu"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,30),1),\"jjj\")","v":"ven"},{"$f":"TEXT(WEEKDAY(DATE(AnnéeCalendrier,12,31),1),\"jjj\")","v":"sam"}]
[null,"Nom de l’employé","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total des jours"]
[null,"Employé 1",{"$nulls":31},{"$f":"COUNTA(Décembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 2",{"$nulls":31},{"$f":"COUNTA(Décembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 3",{"$nulls":31},{"$f":"COUNTA(Décembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 4",{"$nulls":31},{"$f":"COUNTA(Décembre[[#This Row],[1]:[31]])","v":0}]
[null,"Employé 5",{"$nulls":31},{"$f":"COUNTA(Décembre[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NomMois&\" Total\"","v":"Décembre Total"},{"$f":"SUBTOTAL(103,Décembre[1])","v":0},{"$f":"SUBTOTAL(103,Décembre[2])","v":0},{"$f":"SUBTOTAL(103,Décembre[3])","v":0},{"$f":"SUBTOTAL(103,Décembre[4])","v":0},{"$f":"SUBTOTAL(103,Décembre[5])","v":0},{"$f":"SUBTOTAL(103,Décembre[6])","v":0},{"$f":"SUBTOTAL(103,Décembre[7])","v":0},{"$f":"SUBTOTAL(103,Décembre[8])","v":0},{"$f":"SUBTOTAL(103,Décembre[9])","v":0},{"$f":"SUBTOTAL(103,Décembre[10])","v":0},{"$f":"SUBTOTAL(103,Décembre[11])","v":0},{"$f":"SUBTOTAL(103,Décembre[12])","v":0},{"$f":"SUBTOTAL(103,Décembre[13])","v":0},{"$f":"SUBTOTAL(103,Décembre[14])","v":0},{"$f":"SUBTOTAL(103,Décembre[15])","v":0},{"$f":"SUBTOTAL(103,Décembre[16])","v":0},{"$f":"SUBTOTAL(103,Décembre[17])","v":0},{"$f":"SUBTOTAL(103,Décembre[18])","v":0},{"$f":"SUBTOTAL(103,Décembre[19])","v":0},{"$f":"SUBTOTAL(103,Décembre[20])","v":0},{"$f":"SUBTOTAL(103,Décembre[21])","v":0},{"$f":"SUBTOTAL(103,Décembre[22])","v":0},{"$f":"SUBTOTAL(103,Décembre[23])","v":0},{"$f":"SUBTOTAL(103,Décembre[24])","v":0},{"$f":"SUBTOTAL(103,Décembre[25])","v":0},{"$f":"SUBTOTAL(103,Décembre[26])","v":0},{"$f":"SUBTOTAL(103,Décembre[27])","v":0},{"$f":"SUBTOTAL(103,Décembre[28])","v":0},{"$f":"SUBTOTAL(103,Décembre[29])","v":0},{"$f":"SUBTOTAL(109,Décembre[30])","v":0},{"$f":"SUBTOTAL(109,Décembre[31])","v":0},{"$f":"SUBTOTAL(109,Décembre[Total des jours])","v":0}]

{"sheet":"Noms des employés","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Noms des employés"]
[]
[null,"Noms des employés"]
[null,"Employé 1"]
[null,"Employé 2"]
[null,"Employé 3"]
[null,"Employé 4"]
[null,"Employé 5"]