{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Planning","Fériés"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Planning","index":0,"n_rows":12,"n_cols":60,"rows_kept":12}
["Numéro","Nom","Durée","Prédecesseur","Retard","Début","Fin",null,"2017-03-06","2017-03-07","2017-03-08","2017-03-09","2017-03-10","2017-03-11","2017-03-12","2017-03-13","2017-03-14","2017-03-15","2017-03-16","2017-03-17","2017-03-18","2017-03-19","2017-03-20","2017-03-21","2017-03-22","2017-03-23","2017-03-24","2017-03-25","2017-03-26","2017-03-27","2017-03-28","2017-03-29","2017-03-30","2017-03-31","2017-04-01","2017-04-02","2017-04-03","2017-04-04","2017-04-05","2017-04-06","2017-04-07","2017-04-08","2017-04-09","2017-04-10","2017-04-11","2017-04-12","2017-04-13","2017-04-14","2017-04-15","2017-04-16","2017-04-17","2017-04-18","2017-04-19","2017-04-20","2017-04-21","2017-04-22","2017-04-23","2017-04-24","2017-04-25","2017-04-26"]
[1,"Tâche 1",2,null,null,"2017-03-06",{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-07"},null,"Tâche 1"]
[2,"Tâche 2",4,1,-1,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-07"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-10"},null,null,"Tâche 2"]
[3,"Tâche 3",3,1,2,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-10"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-14"},{"$nulls":5},"Tâche 3"]
[4,"Tâche 4",5,2,1,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-14"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-20"},{"$nulls":9},"Tâche 4"]
[5,"Tâche 5",1,7,0,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-29"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-29"},{"$nulls":24},"Tâche 5"]
[6,"Tâche 6",6,5,-1,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-29"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-04-05"},{"$nulls":24},"Tâche 6"]
[7,"Tâche 7",3,4,3,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-03-24"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-03-28"},{"$nulls":19},"Tâche 7"]
[8,"Tâche 8",4,6,0,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-04-06"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-04-11"},{"$nulls":32},"Tâche 8"]
[9,"Tâche 9",2,8,0,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-04-12"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-04-13"},{"$nulls":38},"Tâche 9"]
[10,"Tâche 10",5,9,0,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-04-14"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-04-21"},{"$nulls":40},"Tâche 10"]
[11,"Tâche 11",4,10,-1,{"$f":"WORKDAY( INDEX(tblPlan[Fin],MATCH(tblPlan[[#This Row],[Prédecesseur]],tblPlan[Numéro],0),1),1+tblPlan[[#This Row],[Retard]],TblJF[])","v":"2017-04-21"},{"$f":"WORKDAY(tblPlan[[#This Row],[Début]],tblPlan[[#This Row],[Durée]]-1,TblJF[])","v":"2017-04-26"},{"$nulls":47},"Tâche 11"]

{"sheet":"Fériés","index":1,"n_rows":12,"n_cols":6,"rows_kept":12}
[null,{"$f":"YEAR(Planning!F2)","v":2017},null,"JF AN 1","JF AN 2","JF AN 3"]
[{"$nulls":3},{"$f":"DATE(Annee,1,1)","v":"2017-01-01"},{"$f":"DATE(Annee+1,1,1)","v":"2018-01-01"},{"$f":"DATE(Annee+1,1,1)","v":"2018-01-01"}]
["Lundi Pâques :",{"$f":"ROUND(DATE(Annee,4,MOD(234-11*MOD(Annee,19),30))/7,0)*7-6+1","v":"2017-04-17"},null,{"$f":"DATE(Annee,5,1)","v":"2017-05-01"},{"$f":"DATE(Annee+1,5,1)","v":"2018-05-01"},{"$f":"DATE(Annee+1,5,1)","v":"2018-05-01"}]
[null,{"$f":"B3+38","v":"2017-05-25"},null,{"$f":"DATE(Annee,5,8)","v":"2017-05-08"},{"$f":"DATE(Annee+1,5,8)","v":"2018-05-08"},{"$f":"DATE(Annee+1,5,8)","v":"2018-05-08"}]
[null,{"$f":"B3+49","v":"2017-06-05"},null,{"$f":"DATE(Annee,7,14)","v":"2017-07-14"},{"$f":"DATE(Annee+1,7,14)","v":"2018-07-14"},{"$f":"DATE(Annee+1,7,14)","v":"2018-07-14"}]
[{"$nulls":3},{"$f":"DATE(Annee,8,15)","v":"2017-08-15"},{"$f":"DATE(Annee+1,8,15)","v":"2018-08-15"},{"$f":"DATE(Annee+1,8,15)","v":"2018-08-15"}]
[{"$nulls":3},{"$f":"DATE(Annee,11,1)","v":"2017-11-01"},{"$f":"DATE(Annee+1,11,1)","v":"2018-11-01"},{"$f":"DATE(Annee+1,11,1)","v":"2018-11-01"}]
[{"$nulls":3},{"$f":"DATE(Annee,11,11)","v":"2017-11-11"},{"$f":"DATE(Annee+1,11,11)","v":"2018-11-11"},{"$f":"DATE(Annee+1,11,11)","v":"2018-11-11"}]
[{"$nulls":3},{"$f":"DATE(Annee,12,25)","v":"2017-12-25"},{"$f":"DATE(Annee+1,12,25)","v":"2018-12-25"},{"$f":"DATE(Annee+1,12,25)","v":"2018-12-25"}]
[{"$nulls":3},{"$f":"ROUND(DATE(Annee,4,MOD(234-11*MOD(Annee,19),30))/7,0)*7-6+1","v":"2017-04-17"},{"$f":"ROUND(DATE(Annee+1,4,MOD(234-11*MOD(Annee+1,19),30))/7,0)*7-6+1","v":"2018-04-02"},{"$f":"ROUND(DATE(Annee+1,4,MOD(234-11*MOD(Annee+1,19),30))/7,0)*7-6+1","v":"2018-04-02"}]
[{"$nulls":3},{"$f":"D10+38","v":"2017-05-25"},{"$f":"E10+38","v":"2018-05-10"},{"$f":"F10+38","v":"2018-05-10"}]
[{"$nulls":3},{"$f":"D10+49","v":"2017-06-05"},{"$f":"E10+49","v":"2018-05-21"},{"$f":"F10+49","v":"2018-05-21"}]