{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["plan_pers_vac","roulement_vacances"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"plan_pers_vac","index":0,"n_rows":32,"n_cols":22,"rows_kept":32,"merged":[[9,10,9,11],[9,12,9,13]]}
[null,"CP","CP","CP","CP","CP"]
["2016-01-01",{"$nulls":17},"A","début","2016-01-03","2016-01-14"]
["2016-01-02",{"$nulls":18},"fin","2016-01-06","2016-01-21"]
["2016-01-03","A",{"$nulls":8},"2016-01-03","2016-01-28",{"$nulls":6},"B","début","2016-01-07","2016-01-19"]
["2016-01-04","A",null,"C",{"$nulls":6},"2016-01-24","2016-01-31",{"$nulls":7},"fin","2016-01-13","2016-01-22"]
["2016-01-05","A",null,"C",{"$nulls":6},44,8,{"$nulls":6},"C","début","2016-01-04"]
["2016-01-06","A",null,"C",{"$nulls":15},"fin","2016-01-24"]
["2016-01-07",null,"B","C",{"$nulls":14},"D","début","2016-01-28"]
["2016-01-08",null,"B","C",{"$nulls":15},"fin","2016-01-31"]
["2016-01-09",null,"B","C",{"$nulls":6},"A",null,"B",null,"C","D","E",null,"E","début","2016-01-28"]
["2016-01-10",null,"B","C",{"$nulls":5},"début","2016-01-03","2016-01-14","0701/2016","2016-01-19","04/012016","2016-01-28","2016-01-28",null,null,"fin","2016-01-31"]
["2016-01-11",null,"B","C",{"$nulls":5},"fin","2016-01-06","2016-01-21","2016-01-13","2016-01-22","2016-01-24","2016-01-31","2016-01-31"]
["2016-01-12",null,"B","C"]
["2016-01-13",null,"B","C",{"$nulls":6},"A",null,"B",null,"C","D","E"]
["2016-01-14","A",null,"C",{"$nulls":5},"début","2016-01-03","2016-01-14","2016-01-07","2016-01-19","2016-01-04","2016-01-28","2016-01-28"]
["2016-01-15","A",null,"C",{"$nulls":5},"fin","2016-01-06","2016-01-21","2016-01-13","2016-01-22","2016-01-24","2016-01-31","2016-01-31"]
["2016-01-16","A",null,"C",{"$nulls":5},"Jours",4,8,7,4,21,4,4]
["2016-01-17","A",null,"C",{"$nulls":4},"petit hic avec la macro actuelle:",null,"- pas de prise en compte des vacances de chaque personne (A, B, C, D et E) séparement"]
["2016-01-18","A",null,"C",{"$nulls":6},"- selon la macro: uniquement deux plages (voir encadré) alors qu'au final il faudra en voir 7: 2 pour A, 2 pour B, 1 pour C, D et E"]
["2016-01-19","A","B","C"]
["2016-01-20","A","B","C"]
["2016-01-21","A","B","C",{"$nulls":4},"serait-il possible d'adapter ta macro de manière à ce qu'elle sélectionne les plages et détermine le debut et la fin de chaque plage en fonction du texte des cellules? (pour mon cas, 16 initiales posibles)"]
["2016-01-22",null,"B","C"]
["2016-01-23",null,null,"C"]
["2016-01-24",null,null,"C"]
["2016-01-25"]
["2016-01-26"]
["2016-01-27"]
["2016-01-28",{"$nulls":3},"D","E"]
["2016-01-29",{"$nulls":3},"D","E"]
["2016-01-30",{"$nulls":3},"D","E"]
["2016-01-31",{"$nulls":3},"D","E"]

{"sheet":"roulement_vacances","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"hidden":true}
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Nb de jours posés sur tout le mois","du","au"]
["A","CB",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["B","CC",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["C","VC",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["D","OC",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["E","MP",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["F","MG",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["G","CG",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["H","AG",{"$f":"plan_pers_vac!I35","v":0},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["I","ML",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["J","MOM",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["K","RN",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["L","IP",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["M","SR",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["N","TS",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["O","HV",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]
["P","PW",{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}},{"$f":"plan_pers_vac!#REF!","v":{"$error":"#REF!"}}]