{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calendrier","Taches","Activite","Synthese","Parametres","Graphiques","Février","Mars"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":23,"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":"Calendrier","index":0,"n_rows":37,"n_cols":36,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,35],[1,24,1,26],[1,27,1,29],[1,30,1,32],[1,33,1,35],[1,0,1,2],[1,3,1,5],[1,6,1,8],[1,9,1,11],[1,12,1,14],[1,15,1,17],[1,18,1,20],[1,21,1,23],[2,24,2,26],[2,27,2,29],[2,30,2,32],[2,33,2,35],[2,0,2,2],[2,3,2,5],[2,6,2,8],[2,9,2,11],[2,12,2,14],[2,15,2,17],[2,18,2,20],[2,21,2,23]]}
[2016]
["2016-01-01",null,null,"2016-02-01",null,null,"2016-03-01",null,null,"2016-04-01",null,null,"2016-05-01",null,null,"2016-06-01",null,null,"2016-07-01",null,null,"2016-08-01",null,null,"2016-09-01",null,null,"2016-10-01",null,null,"2016-11-01",null,null,"2016-12-01"]
[1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,6,null,null,7,null,null,8,null,null,9,null,null,10,null,null,11,null,null,12]
["S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°","S","J","N°"]
["2016-01-01","2016-01-01",null,"2016-02-01","2016-02-01",null,"2016-03-01","2016-03-01",null,"2016-04-01","2016-04-01",null,"2016-05-01","2016-05-01",null,"2016-06-01","2016-06-01",null,"2016-07-01","2016-07-01",null,"2016-08-01","2016-08-01",null,"2016-09-01","2016-09-01",null,"2016-10-01","2016-10-01",null,"2016-11-01","2016-11-01",null,"2016-12-01","2016-12-01"]
["2016-01-02","2016-01-02",null,"2016-02-02","2016-02-02",null,"2016-03-02","2016-03-02",null,"2016-04-02","2016-04-02",null,"2016-05-02","2016-05-02",null,"2016-06-02","2016-06-02",null,"2016-07-02","2016-07-02",null,"2016-08-02","2016-08-02",null,"2016-09-02","2016-09-02",null,"2016-10-02","2016-10-02",null,"2016-11-02","2016-11-02",null,"2016-12-02","2016-12-02"]
["2016-01-03","2016-01-03",null,"2016-02-03","2016-02-03",null,"2016-03-03","2016-03-03",null,"2016-04-03","2016-04-03",null,"2016-05-03","2016-05-03",null,"2016-06-03","2016-06-03",null,"2016-07-03","2016-07-03",null,"2016-08-03","2016-08-03",null,"2016-09-03","2016-09-03",null,"2016-10-03","2016-10-03",null,"2016-11-03","2016-11-03",null,"2016-12-03","2016-12-03"]
["2016-01-04","2016-01-04",null,"2016-02-04","2016-02-04",null,"2016-03-04","2016-03-04",null,"2016-04-04","2016-04-04",null,"2016-05-04","2016-05-04",null,"2016-06-04","2016-06-04",null,"2016-07-04","2016-07-04",null,"2016-08-04","2016-08-04",null,"2016-09-04","2016-09-04",null,"2016-10-04","2016-10-04",null,"2016-11-04","2016-11-04",null,"2016-12-04","2016-12-04"]
["2016-01-05","2016-01-05",null,"2016-02-05","2016-02-05",null,"2016-03-05","2016-03-05",null,"2016-04-05","2016-04-05",null,"2016-05-05","2016-05-05",null,"2016-06-05","2016-06-05",null,"2016-07-05","2016-07-05",null,"2016-08-05","2016-08-05",null,"2016-09-05","2016-09-05",null,"2016-10-05","2016-10-05",null,"2016-11-05","2016-11-05",null,"2016-12-05","2016-12-05"]
["2016-01-06","2016-01-06",null,"2016-02-06","2016-02-06",null,"2016-03-06","2016-03-06",null,"2016-04-06","2016-04-06",null,"2016-05-06","2016-05-06",null,"2016-06-06","2016-06-06",null,"2016-07-06","2016-07-06",null,"2016-08-06","2016-08-06",null,"2016-09-06","2016-09-06",null,"2016-10-06","2016-10-06",null,"2016-11-06","2016-11-06",null,"2016-12-06","2016-12-06"]
["2016-01-07","2016-01-07",null,"2016-02-07","2016-02-07",null,"2016-03-07","2016-03-07",null,"2016-04-07","2016-04-07",null,"2016-05-07","2016-05-07",null,"2016-06-07","2016-06-07",null,"2016-07-07","2016-07-07",null,"2016-08-07","2016-08-07",null,"2016-09-07","2016-09-07",null,"2016-10-07","2016-10-07",null,"2016-11-07","2016-11-07",null,"2016-12-07","2016-12-07"]
["2016-01-08","2016-01-08",null,"2016-02-08","2016-02-08",null,"2016-03-08","2016-03-08",null,"2016-04-08","2016-04-08",null,"2016-05-08","2016-05-08",null,"2016-06-08","2016-06-08",null,"2016-07-08","2016-07-08",null,"2016-08-08","2016-08-08",null,"2016-09-08","2016-09-08",null,"2016-10-08","2016-10-08",null,"2016-11-08","2016-11-08",null,"2016-12-08","2016-12-08"]
["2016-01-09","2016-01-09",null,"2016-02-09","2016-02-09",null,"2016-03-09","2016-03-09",null,"2016-04-09","2016-04-09",null,"2016-05-09","2016-05-09",null,"2016-06-09","2016-06-09",null,"2016-07-09","2016-07-09",null,"2016-08-09","2016-08-09",null,"2016-09-09","2016-09-09",null,"2016-10-09","2016-10-09",null,"2016-11-09","2016-11-09",null,"2016-12-09","2016-12-09"]
["2016-01-10","2016-01-10",null,"2016-02-10","2016-02-10",null,"2016-03-10","2016-03-10",null,"2016-04-10","2016-04-10",null,"2016-05-10","2016-05-10",null,"2016-06-10","2016-06-10",null,"2016-07-10","2016-07-10",null,"2016-08-10","2016-08-10",null,"2016-09-10","2016-09-10",null,"2016-10-10","2016-10-10",null,"2016-11-10","2016-11-10",null,"2016-12-10","2016-12-10"]
["2016-01-11","2016-01-11",null,"2016-02-11","2016-02-11",null,"2016-03-11","2016-03-11",null,"2016-04-11","2016-04-11",null,"2016-05-11","2016-05-11",null,"2016-06-11","2016-06-11",null,"2016-07-11","2016-07-11",null,"2016-08-11","2016-08-11",null,"2016-09-11","2016-09-11",null,"2016-10-11","2016-10-11",null,"2016-11-11","2016-11-11",null,"2016-12-11","2016-12-11"]
["2016-01-12","2016-01-12",null,"2016-02-12","2016-02-12",null,"2016-03-12","2016-03-12",null,"2016-04-12","2016-04-12",null,"2016-05-12","2016-05-12",null,"2016-06-12","2016-06-12",null,"2016-07-12","2016-07-12",null,"2016-08-12","2016-08-12",null,"2016-09-12","2016-09-12",null,"2016-10-12","2016-10-12",null,"2016-11-12","2016-11-12",null,"2016-12-12","2016-12-12"]
["2016-01-13","2016-01-13",null,"2016-02-13","2016-02-13",null,"2016-03-13","2016-03-13",null,"2016-04-13","2016-04-13",null,"2016-05-13","2016-05-13",null,"2016-06-13","2016-06-13",null,"2016-07-13","2016-07-13",null,"2016-08-13","2016-08-13",null,"2016-09-13","2016-09-13",null,"2016-10-13","2016-10-13",null,"2016-11-13","2016-11-13",null,"2016-12-13","2016-12-13"]
["2016-01-14","2016-01-14",null,"2016-02-14","2016-02-14",null,"2016-03-14","2016-03-14",null,"2016-04-14","2016-04-14",null,"2016-05-14","2016-05-14",null,"2016-06-14","2016-06-14",null,"2016-07-14","2016-07-14",null,"2016-08-14","2016-08-14",null,"2016-09-14","2016-09-14",null,"2016-10-14","2016-10-14",null,"2016-11-14","2016-11-14",null,"2016-12-14","2016-12-14"]
["2016-01-15","2016-01-15",null,"2016-02-15","2016-02-15",null,"2016-03-15","2016-03-15",null,"2016-04-15","2016-04-15",null,"2016-05-15","2016-05-15",null,"2016-06-15","2016-06-15",null,"2016-07-15","2016-07-15",null,"2016-08-15","2016-08-15",null,"2016-09-15","2016-09-15",null,"2016-10-15","2016-10-15",null,"2016-11-15","2016-11-15",null,"2016-12-15","2016-12-15"]
["2016-01-16","2016-01-16",null,"2016-02-16","2016-02-16",null,"2016-03-16","2016-03-16",null,"2016-04-16","2016-04-16",null,"2016-05-16","2016-05-16",null,"2016-06-16","2016-06-16",null,"2016-07-16","2016-07-16",null,"2016-08-16","2016-08-16",null,"2016-09-16","2016-09-16",null,"2016-10-16","2016-10-16",null,"2016-11-16","2016-11-16",null,"2016-12-16","2016-12-16"]
["2016-01-17","2016-01-17",null,"2016-02-17","2016-02-17",null,"2016-03-17","2016-03-17",null,"2016-04-17","2016-04-17",null,"2016-05-17","2016-05-17",null,"2016-06-17","2016-06-17",null,"2016-07-17","2016-07-17",null,"2016-08-17","2016-08-17",null,"2016-09-17","2016-09-17",null,"2016-10-17","2016-10-17",null,"2016-11-17","2016-11-17",null,"2016-12-17","2016-12-17"]
["2016-01-18","2016-01-18",null,"2016-02-18","2016-02-18",null,"2016-03-18","2016-03-18",null,"2016-04-18","2016-04-18",null,"2016-05-18","2016-05-18",null,"2016-06-18","2016-06-18",null,"2016-07-18","2016-07-18",null,"2016-08-18","2016-08-18",null,"2016-09-18","2016-09-18",null,"2016-10-18","2016-10-18",null,"2016-11-18","2016-11-18",null,"2016-12-18","2016-12-18"]
["2016-01-19","2016-01-19",null,"2016-02-19","2016-02-19",null,"2016-03-19","2016-03-19",null,"2016-04-19","2016-04-19",null,"2016-05-19","2016-05-19",null,"2016-06-19","2016-06-19",null,"2016-07-19","2016-07-19",null,"2016-08-19","2016-08-19",null,"2016-09-19","2016-09-19",null,"2016-10-19","2016-10-19",null,"2016-11-19","2016-11-19",null,"2016-12-19","2016-12-19"]
["2016-01-20","2016-01-20",null,"2016-02-20","2016-02-20",null,"2016-03-20","2016-03-20",null,"2016-04-20","2016-04-20",null,"2016-05-20","2016-05-20",null,"2016-06-20","2016-06-20",null,"2016-07-20","2016-07-20",null,"2016-08-20","2016-08-20",null,"2016-09-20","2016-09-20",null,"2016-10-20","2016-10-20",null,"2016-11-20","2016-11-20",null,"2016-12-20","2016-12-20"]
["2016-01-21","2016-01-21",null,"2016-02-21","2016-02-21",null,"2016-03-21","2016-03-21",null,"2016-04-21","2016-04-21",null,"2016-05-21","2016-05-21",null,"2016-06-21","2016-06-21",null,"2016-07-21","2016-07-21",null,"2016-08-21","2016-08-21",null,"2016-09-21","2016-09-21",null,"2016-10-21","2016-10-21",null,"2016-11-21","2016-11-21",null,"2016-12-21","2016-12-21"]
["2016-01-22","2016-01-22",null,"2016-02-22","2016-02-22",null,"2016-03-22","2016-03-22",null,"2016-04-22","2016-04-22",null,"2016-05-22","2016-05-22",null,"2016-06-22","2016-06-22",null,"2016-07-22","2016-07-22",null,"2016-08-22","2016-08-22",null,"2016-09-22","2016-09-22",null,"2016-10-22","2016-10-22",null,"2016-11-22","2016-11-22",null,"2016-12-22","2016-12-22"]
["2016-01-23","2016-01-23",null,"2016-02-23","2016-02-23",null,"2016-03-23","2016-03-23",null,"2016-04-23","2016-04-23",null,"2016-05-23","2016-05-23",null,"2016-06-23","2016-06-23",null,"2016-07-23","2016-07-23",null,"2016-08-23","2016-08-23",null,"2016-09-23","2016-09-23",null,"2016-10-23","2016-10-23",null,"2016-11-23","2016-11-23",null,"2016-12-23","2016-12-23"]
["2016-01-24","2016-01-24",null,"2016-02-24","2016-02-24",null,"2016-03-24","2016-03-24",null,"2016-04-24","2016-04-24",null,"2016-05-24","2016-05-24",null,"2016-06-24","2016-06-24",null,"2016-07-24","2016-07-24",null,"2016-08-24","2016-08-24",null,"2016-09-24","2016-09-24",null,"2016-10-24","2016-10-24",null,"2016-11-24","2016-11-24",null,"2016-12-24","2016-12-24"]
["2016-01-25","2016-01-25",null,"2016-02-25","2016-02-25",null,"2016-03-25","2016-03-25",null,"2016-04-25","2016-04-25",null,"2016-05-25","2016-05-25",null,"2016-06-25","2016-06-25",null,"2016-07-25","2016-07-25",null,"2016-08-25","2016-08-25",null,"2016-09-25","2016-09-25",null,"2016-10-25","2016-10-25",null,"2016-11-25","2016-11-25",null,"2016-12-25","2016-12-25"]
["2016-01-26","2016-01-26",null,"2016-02-26","2016-02-26",null,"2016-03-26","2016-03-26",null,"2016-04-26","2016-04-26",null,"2016-05-26","2016-05-26",null,"2016-06-26","2016-06-26",null,"2016-07-26","2016-07-26",null,"2016-08-26","2016-08-26",null,"2016-09-26","2016-09-26",null,"2016-10-26","2016-10-26",null,"2016-11-26","2016-11-26",null,"2016-12-26","2016-12-26"]
["2016-01-27","2016-01-27",null,"2016-02-27","2016-02-27",null,"2016-03-27","2016-03-27",null,"2016-04-27","2016-04-27",null,"2016-05-27","2016-05-27",null,"2016-06-27","2016-06-27",null,"2016-07-27","2016-07-27",null,"2016-08-27","2016-08-27",null,"2016-09-27","2016-09-27",null,"2016-10-27","2016-10-27",null,"2016-11-27","2016-11-27",null,"2016-12-27","2016-12-27"]
["2016-01-28","2016-01-28",null,"2016-02-28","2016-02-28",null,"2016-03-28","2016-03-28",null,"2016-04-28","2016-04-28",null,"2016-05-28","2016-05-28",null,"2016-06-28","2016-06-28",null,"2016-07-28","2016-07-28",null,"2016-08-28","2016-08-28",null,"2016-09-28","2016-09-28",null,"2016-10-28","2016-10-28",null,"2016-11-28","2016-11-28",null,"2016-12-28","2016-12-28"]
["2016-01-29","2016-01-29",null,"2016-02-29","2016-02-29",null,"2016-03-29","2016-03-29",null,"2016-04-29","2016-04-29",null,"2016-05-29","2016-05-29",null,"2016-06-29","2016-06-29",null,"2016-07-29","2016-07-29",null,"2016-08-29","2016-08-29",null,"2016-09-29","2016-09-29",null,"2016-10-29","2016-10-29",null,"2016-11-29","2016-11-29",null,"2016-12-29","2016-12-29"]
["2016-01-30","2016-01-30",null,"","",null,"2016-03-30","2016-03-30",null,"2016-04-30","2016-04-30",null,"2016-05-30","2016-05-30",null,"2016-06-30","2016-06-30",null,"2016-07-30","2016-07-30",null,"2016-08-30","2016-08-30",null,"2016-09-30","2016-09-30",null,"2016-10-30","2016-10-30",null,"2016-11-30","2016-11-30",null,"2016-12-30","2016-12-30"]
["2016-01-31","2016-01-31",null,"","",null,"2016-03-31","2016-03-31",null,"","",null,"2016-05-31","2016-05-31",null,"","",null,"2016-07-31","2016-07-31",null,"2016-08-31","2016-08-31",null,"","",null,"2016-10-31","2016-10-31",null,"","",null,"2016-12-31","2016-12-31"]
[]
["Heures mensuels",null,{"$f":"SUM(C5:C35)","v":0},null,null,{"$f":"SUM(F5:F35)","v":0},null,null,{"$f":"SUM(I5:I35)","v":0},null,null,{"$f":"SUM(L5:L35)","v":0},null,null,{"$f":"SUM(O5:O35)","v":0},null,null,{"$f":"SUM(R5:R35)","v":0},null,null,{"$f":"SUM(U5:U35)","v":0},null,null,{"$f":"SUM(X5:X35)","v":0},null,null,{"$f":"SUM(AA5:AA35)","v":0},null,null,{"$f":"SUM(AD5:AD35)","v":0},null,null,{"$f":"SUM(AG5:AG35)","v":0},null,null,{"$f":"SUM(AJ5:AJ35)","v":0}]

{"sheet":"Taches","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Tâches",{"$f":"A3","v":"Vente"},{"$f":"A4","v":"Merchandising"},{"$f":"A5","v":"Administratif"},{"$f":"A6","v":"Encaissement"},{"$f":"A7","v":"Rangement"},{"$f":"A8","v":"Menage"},{"$f":"A9","v":"Absences"}]
[]
["Vente","Puériculture","Vitrine","Cahier de liaison","Caisse ","Classement à la taille","Miroir","CS","congés sans solde"]
["Merchandising","Bébé","Implantation nouvelle collection","Gestion mails","Cloture","Pliage","Poussière","CP","congés payés"]
["Administratif","Garçon","Facing","Planning","Depot banque","Divers rangements","Aspirateur","RTT","RTT"]
["Encaissement","Fille","Mannequins","Reunion","Monnaie","Cintrage","Serpillère","CE","congés exceptionnels"]
["Rangement","Accessoire","Inventaire",null,null,"Colis",null,"JF","jour férié"]
["Menage"]
["Absences"]
[]
[]
[]
[]
["Puériculture","Vente au rayon puériculture"]
["Bébé","Vente au rayon bébé"]
["Garçon","Vente au rayon garçon"]
["Fille","Vente au rayon fille"]
["Accessoire","Vente au rayon accessoire"]
["Vitrine","Mise en place de la vitrine"]
["Implantation nouvelle collection","Modification agencement"]
["Facing","Assemblage de tenue sur cintre"]
["Mannequins","Changer les mannequins avec nouvelle tenue"]
["Inventaire","Faire l'inventaire des produits"]
["Cahier de liaison","Tenir le cahier à jour pour les collégues absentes"]
["Gestion mails","Répondre et gérer les demandes mails"]
["Planning","Etablir les plannings de l'équipe"]
["Reunion","Mise en place projet, animations etc…"]
["Caisse","Encaisser les ventes de la journée"]
["Cloture","Comptabiliser la caisse en fin de journée"]
["Depot banque","Deposer en banque la recette du jour"]
["Monnaie","Allé faire de la monnaie à la banque"]
["Classement à la taille","Ranger les vetements par taille"]
["Pliage","Replier correctement les vétements"]
["Divers rangement","Tenir le magasin propre"]
["Cintrage","Mettre les vetements sur cintre"]
["Colis","Déballer et ranger les nouveaux articles"]
["Miroir","Nettoyer les miroirs"]
["Poussière","Faire la poussière du magasin"]
["Aspirateur","Passer l'aspirateur"]
["Serpillère","Passer la serpillère"]
["CS","congés sans solde"]
["CP","congés payés"]
["RTT","RTT"]
["CE","congés exceptionnels"]
["JF","jour férié"]

{"sheet":"Activite","index":2,"n_rows":38,"n_cols":36,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,1,7,3]]}
[null,"Choix du mois : "]
[]
[]
[]
[]
[null,null,null,{"$f":"\"1/\" & Parametres!B16 & \"/\" & YEAR(TODAY())","v":"1/1/2016"},{"$f":"MONTH(D6)","v":1}]
[null,"Jour",null,null,{"$f":"E8","v":"2016-01-01"},{"$f":"F8","v":"2016-01-02"},"2016-01-03","2016-01-04","2016-01-05","2016-01-06","2016-01-07","2016-01-08","2016-01-09","2016-01-10","2016-01-11","2016-01-12","2016-01-13","2016-01-14","2016-01-15","2016-01-16","2016-01-17","2016-01-18","2016-01-19","2016-01-20","2016-01-21","2016-01-22","2016-01-23","2016-01-24","2016-01-25","2016-01-26","2016-01-27","2016-01-28","2016-01-29","2016-01-30","2016-01-31"]
[null,null,null,null,{"$f":"D6+0","v":"2016-01-01"},{"$f":"$D$6+1","v":"2016-01-02"},{"$f":"$D$6+2","v":"2016-01-03"},{"$f":"$D$6+3","v":"2016-01-04"},{"$f":"$D$6+4","v":"2016-01-05"},{"$f":"$D$6+5","v":"2016-01-06"},{"$f":"$D$6+6","v":"2016-01-07"},{"$f":"$D$6+7","v":"2016-01-08"},{"$f":"$D$6+8","v":"2016-01-09"},{"$f":"$D$6+9","v":"2016-01-10"},{"$f":"$D$6+10","v":"2016-01-11"},{"$f":"$D$6+11","v":"2016-01-12"},{"$f":"$D$6+12","v":"2016-01-13"},{"$f":"$D$6+13","v":"2016-01-14"},{"$f":"$D$6+14","v":"2016-01-15"},{"$f":"$D$6+15","v":"2016-01-16"},{"$f":"$D$6+16","v":"2016-01-17"},{"$f":"$D$6+17","v":"2016-01-18"},{"$f":"$D$6+18","v":"2016-01-19"},{"$f":"$D$6+19","v":"2016-01-20"},{"$f":"$D$6+20","v":"2016-01-21"},{"$f":"$D$6+21","v":"2016-01-22"},{"$f":"$D$6+22","v":"2016-01-23"},{"$f":"$D$6+23","v":"2016-01-24"},{"$f":"$D$6+24","v":"2016-01-25"},{"$f":"$D$6+25","v":"2016-01-26"},{"$f":"$D$6+26","v":"2016-01-27"},{"$f":"$D$6+27","v":"2016-01-28"},{"$f":"IF($AF$8+1<=EOMONTH($E$8,0), $AF$8+1, \"\")","v":"2016-01-29"},{"$f":"IF($AF$8+2<=EOMONTH($E$8,0), $AF$8+2, \"\")","v":"2016-01-30"},{"$f":"IF($AF$8+3<=EOMONTH($E$8,0), $AF$8+3, \"\")","v":"2016-01-31"}]
[null,null,null,"Numéro du jour",{"$f":"IF(E7<>\"\",WEEKDAY(E7),\"\")","v":6},{"$f":"IF(F7<>\"\",WEEKDAY(F7),\"\")","v":7},1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,""]
[null,null,null,"Numéro de la semaine",{"$f":"IF(E8<>\"\",WEEKNUM(E8),\"\")","v":1},{"$f":"IF(F8<>\"\",WEEKNUM(F8),\"\")","v":1},2,2,2,2,2,2,2,3,3,3,3,3,3,3,4,4,4,4,4,4,4,5,5,5,5,5,5,5,6]
[null,"Tâche","sous-tâche","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:AI12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:AI13)","v":0}]
[null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C34=\"\",\"\",VLOOKUP(C34,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C35=\"\",\"\",VLOOKUP(C35,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C36=\"\",\"\",VLOOKUP(C36,Taches!$A$14:$B$45,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total jour",null,{"$f":"IF(E9<>7,IF(E9<>1,SUM(E12:E36),\"\"),\"\")","v":0},"","",0,0,0,0,0,"","",0,0,0,0,0,"","",0,0,0,0,0,"","",0,0,0,0,0,"",""]
[null,null,"TOTAL semaine",null,{"$f":"IF(E9=6,SUM(E12:E36,D12:D36,C12:C36,B12:B36,A12:A36),\"\")","v":0},{"$f":"IF(F9=6,SUM(F12:F36,E12:E36,D12:D36,C12:C36,B12:B36),\"\")","v":""},{"$f":"IF(G9=6,SUM(G12:G36,F12:F36,E12:E36,D12:D36,C12:C36),\"\")","v":""},{"$f":"IF(AND(H9=6,H8<>Parametres!G13),SUM(H12:H36,G12:G36,F12:F36,E12:E36,D12:D36),\"\")","v":""},{"$f":"IF(AND(I9=6,I8<>Parametres!H13),SUM(I12:I36,H12:H36,G12:G36,F12:F36,E12:E36),\"\")","v":""},{"$f":"IF(AND(J9=6,J8<>Parametres!I13),SUM(J12:J36,I12:I36,H12:H36,G12:G36,F12:F36),\"\")","v":""},{"$f":"IF(AND(K9=6,K8<>Parametres!J13),SUM(K12:K36,J12:J36,I12:I36,H12:H36,G12:G36),\"\")","v":""},{"$f":"IF(L9=6,SUM(L12:L36,K12:K36,J12:J36,I12:I36,H12:H36),\"\")","v":0},{"$f":"IF(AND(M9=6,M8<>Parametres!L13),SUM(M12:M36,L12:L36,K12:K36,J12:J36,I12:I36),\"\")","v":""},{"$f":"IF(AND(N9=6,N8<>Parametres!M13),SUM(N12:N36,M12:M36,L12:L36,K12:K36,J12:J36),\"\")","v":""},{"$f":"IF(AND(O9=6,O8<>Parametres!N13),SUM(O12:O36,N12:N36,M12:M36,L12:L36,K12:K36),\"\")","v":""},{"$f":"IF(AND(P9=6,P8<>Parametres!O13),SUM(P12:P36,O12:O36,N12:N36,M12:M36,L12:L36),\"\")","v":""},{"$f":"IF(AND(Q9=6,Q8<>\"FERIE\"),SUM(Q12:Q36,P12:P36,O12:O36,N12:N36,M12:M36),\"\")","v":""},"",0,"","","","","","",0,"","","","","","",0,"","",0]

{"sheet":"Synthese","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Date","Tâche","sous-tâche","Temps passé"]
["2016-01-02","Tâche2","sous-tâche10",12]
["2016-03-02","Tâche1","sous-tâche 1",9]
["2016-02-03","Tâche1","sous-tâche 2",5]
["2016-02-03","Tâche2","sous-tâche 8",3]
["2016-02-04","Tâche1","sous-tâche 3",9]
["2016-02-08","Tâche1","sous-tâche 4",5]
["2016-02-08","Tâche2","sous-tâche 9",3]
["2016-02-09","Tâche4","sous-tâche 17",10]
["2016-02-10","Tâche4","sous-tâche 18",8]
["2016-02-15","Tâche5","sous-tâche 23",12]
["2016-02-16","Tâche5","sous-tâche 23",5]
["2016-02-17","Tâche5","sous-tâche 24",11]
["2016-02-18","Tâche5","sous-tâche 23",10]
["2016-02-22","Tâche2","sous-tâche 10",10]
["2016-02-23","Tâche2","sous-tâche 11",10]
["2016-02-24","Tâche3","sous-tâche 13",10]
["2016-02-25","Tâche1","sous-tâche 5",8]
["2016-02-29","Tâche1","sous-tâche 6",8]

{"sheet":"Parametres","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["n°","Mois","nb de jours",null,null,"Jours fériés",{"$f":"YEAR(TODAY())","v":2016}]
[1,"Janvier",31,null,null,"Jour de l'an",{"$f":"DATE(an,1,1)","v":"2016-01-01"}]
[2,"Février",29,null,null,"Pâques",{"$f":"DATE(an,IF((25-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29)-MOD(an-1900\n+INT((an-1900)/4)+31-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29),7))>0,4,3),\nIF((25-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29)\n-MOD(an-1900+INT((an-1900)/4)+31\n-MOD((11*MOD(an-1900,19)+4-INT((7*MOD(an-1900,19)\n+1)/19)),29),7))>0,(25-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29)-MOD(an-1900\n+INT((an-1900)/4)+31-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29),7)),31\n+(25-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29)\n-MOD(an-1900+INT((an-1900)/4)+31\n-MOD((11*MOD(an-1900,19)+4\n-INT((7*MOD(an-1900,19)+1)/19)),29),7))))","v":"2016-03-27"}]
[3,"Mars",31,null,null,"Lundi de Pâques",{"$f":"G3+1","v":"2016-03-28"}]
[4,"Avril",30,null,null,"1er mai",{"$f":"DATE(an,5,1)","v":"2016-05-01"}]
[5,"Mai",31,null,null,"Le 8 mai",{"$f":"DATE(an,5,8)","v":"2016-05-08"}]
[6,"Juin",30,null,null,"Ascension",{"$f":"G4+38","v":"2016-05-05"}]
[7,"Juillet",31,null,null,"Pentecôte",{"$f":"G4+49","v":"2016-05-16"}]
[8,"Août",31,null,null,"Fête nationale",{"$f":"DATE(an,7,14)","v":"2016-07-14"}]
[9,"Septembre",30,null,null,"Assomption",{"$f":"DATE(an,8,15)","v":"2016-08-15"}]
[10,"Octobre",31,null,null,"Toussaint",{"$f":"DATE(an,11,1)","v":"2016-11-01"}]
[11,"Novembre",30,null,null,"Armistice",{"$f":"DATE(an,11,11)","v":"2016-11-11"}]
[12,"Décembre",31,null,null,"Noel",{"$f":"DATE(an,12,25)","v":"2016-12-25"}]
[]
[]
[null,1]
[]
[null,{"$f":"\"1/\" & B16 & \"/\" & YEAR(TODAY())","v":"1/1/2016"}]

{"sheet":"Graphiques","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Tâches","TOTAL",null,"Tâches","sous-tâches","TOTAL"]
["Tâche1",44,null,"Tâche1","sous-tâche 1",9]
["Tâche2",38,null,"Tâche1","sous-tâche 2",5]
["Tâche3",10,null,"Tâche1","sous-tâche 3",9]
["Tâche4",18,null,"Tâche1","sous-tâche 4",5]
["Tâche5",38,null,"Tâche1","sous-tâche 5",8]
[null,null,null,"Tâche1","sous-tâche 6",8]
[null,null,null,"Tâche1","sous-tâche 7",0]
[null,null,null,"Tâche2","sous-tâche 8",3]
[null,null,null,"Tâche2","sous-tâche 9",3]
[null,null,null,"Tâche2","sous-tâche 10",10]
[null,null,null,"Tâche2","sous-tâche 11",10]
[null,null,null,"Tâche3","sous-tâche 12",0]
[null,null,null,"Tâche3","sous-tâche 13",10]
[null,null,null,"Tâche3","sous-tâche 14",0]
[null,null,null,"Tâche3","sous-tâche 15",0]
[null,null,null,"Tâche3","sous-tâche 16",0]
[null,null,null,"Tâche4","sous-tâche 17",10]
[null,null,null,"Tâche4","sous-tâche 18",8]
[null,null,null,"Tâche4","sous-tâche 19",0]
[null,null,null,"Tâche4","sous-tâche 20",0]
[null,null,null,"Tâche4","sous-tâche 21",0]
[null,null,null,"Tâche4","sous-tâche 22",0]
[null,null,null,"Tâche5","sous-tâche 23",27]
[null,null,null,"Tâche5","sous-tâche 24",11]
[null,null,null,"Tâche5","sous-tâche 25",0]

{"sheet":"Février","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Mars","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}