{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Gantt EDS","Gantt  PA","IssueList","Holiday","Histlog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":31,"comments":1,"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":"Gantt EDS","index":0,"n_rows":130,"n_cols":239,"rows_kept":130,"cut":false,"hidden":false,"merged":[[6,7,6,9],[6,5,6,6],[4,5,4,6],[5,5,5,6],[3,5,3,6],[0,0,0,9],[3,37,3,44],[3,13,3,17],[3,19,3,22],[3,24,3,27],[3,29,3,35]]}
[{"$f":"\"Planning du Projet - EDS d.d. \"&(DAY(MAX(IssueList!F2:F4)))&\"-\"&(MONTH(MAX(IssueList!F2:F4)))&\"-\"&(YEAR(MAX(IssueList!F2:F4)))","v":"Planning du Projet - EDS d.d. 17-2-2020"}]
[null,null,null,null,null,"Milestone:",0]
[null,null,null,"Demande (N°, nom à commune)"]
[null,null,null,"Company Name",null,"Today:",null,{"$f":"TODAY()","v":"2020-03-12"},null," Period Highlight:",{"$f":"H4","v":43902},null,null,"Plan Duration",null,null,null,null,null,"Actual Start",null,null,null,null,"% Complete",null,null,null,null,"Actual (beyond plan)",null,null,null,null,null,null,null,"% Complete (beyond plan)"]
[null,null,null,"Project Lead",null,"Project Start Date:",null,"2020-02-17"]
[null,null,null,"Project BOFAS",null,"Project End Date:",null,{"$f":"MAX(H12:H46)","v":"2020-08-31"},null,null,"PERIODES"]
[null,null,null,null,null,"Plan",null,"ACTUAL ",null,null,{"$f":"MID(PROPER(TEXT(K10,\"mmm/aaaa\")),DAY(K10),1)","v":""},"","","","","","","","","","","","","M","a","r","s","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","","A","v","r","/","2","0","2","0","","","","","","","","","","","","",{"$f":"MID(PROPER(TEXT(BW10,\"mmm/aaaa\")),DAY(BW10),1)","v":""},"","","","","","","","","","M","a","i","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","","","J","u","i","n","/","2","0","2","0","","","","","","","","","","","","","","",{"$f":"MID(PROPER(TEXT(EI10,\"mmm/aaaa\")),DAY(EI10),1)","v":""},"","","","","","","J","u","i","l","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","","A","o","û","t","/","2","0","2","0","","","","","","","","","","","","","","","","","",{"$f":"MID(PROPER(TEXT(GU10,\"mmm/aaaa\")),DAY(GU10),1)","v":""},"","","","","S","e","p","t","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","O","c"]
["Tache_ID",null,"Issue ID",null,null,"DEPART","Durée","DEPART","Durée","Delta(days)",null,{"$f":"IF(WEEKNUM(L10,2)=WEEKNUM(K10,2),\"\",WEEKNUM(L10,2))","v":""},{"$f":"IF(WEEKNUM(M10,2)=WEEKNUM(L10,2),\"\",WEEKNUM(M10,2))","v":""},"","","","",{"$f":"IF(WEEKNUM(R10,2)=WEEKNUM(Q10,2),\"\",WEEKNUM(R10,2))","v":"1900-01-09"},"","","","","","","1900-01-10","","","","","","","1900-01-11","","","","","","","1900-01-12","","","","","","","1900-01-13","","","","","","","1900-01-14","","","","","","","1900-01-15","","","","","","","1900-01-16","","","","","","","1900-01-17","","",{"$f":"IF(WEEKNUM(BY10,2)=WEEKNUM(BX10,2),\"\",WEEKNUM(BY10,2))","v":""},"","","","1900-01-18","","","","","","","1900-01-19","","","","","","","1900-01-20","","","","","","","1900-01-21","","","","","","","1900-01-22","","","","","","","1900-01-23","","","","","","","1900-01-24","","","","","","","1900-01-25","","","","","","","1900-01-26","","","",{"$f":"IF(WEEKNUM(EK10,2)=WEEKNUM(EJ10,2),\"\",WEEKNUM(EK10,2))","v":""},"","","1900-01-27","","","","","","","1900-01-28","","","","","","","1900-01-29","","","","","",{"$f":"IF(WEEKNUM(FH10,2)=WEEKNUM(FG10,2),\"\",WEEKNUM(FH10,2))","v":""},{"$f":"IF(WEEKNUM(FI10,2)=WEEKNUM(FH10,2),\"\",WEEKNUM(FI10,2))","v":"1900-01-30"},{"$f":"IF(WEEKNUM(FJ10,2)=WEEKNUM(FI10,2),\"\",WEEKNUM(FJ10,2))","v":""},{"$f":"IF(WEEKNUM(FK10,2)=WEEKNUM(FJ10,2),\"\",WEEKNUM(FK10,2))","v":""},{"$f":"IF(WEEKNUM(FL10,2)=WEEKNUM(FK10,2),\"\",WEEKNUM(FL10,2))","v":""},{"$f":"IF(WEEKNUM(FM10,2)=WEEKNUM(FL10,2),\"\",WEEKNUM(FM10,2))","v":""},{"$f":"IF(WEEKNUM(FN10,2)=WEEKNUM(FM10,2),\"\",WEEKNUM(FN10,2))","v":""},{"$f":"IF(WEEKNUM(FO10,2)=WEEKNUM(FN10,2),\"\",WEEKNUM(FO10,2))","v":""},{"$f":"IF(WEEKNUM(FP10,2)=WEEKNUM(FO10,2),\"\",WEEKNUM(FP10,2))","v":"1900-01-31"},{"$f":"IF(WEEKNUM(FQ10,2)=WEEKNUM(FP10,2),\"\",WEEKNUM(FQ10,2))","v":""},{"$f":"IF(WEEKNUM(FR10,2)=WEEKNUM(FQ10,2),\"\",WEEKNUM(FR10,2))","v":""},{"$f":"IF(WEEKNUM(FS10,2)=WEEKNUM(FR10,2),\"\",WEEKNUM(FS10,2))","v":""},{"$f":"IF(WEEKNUM(FT10,2)=WEEKNUM(FS10,2),\"\",WEEKNUM(FT10,2))","v":""},{"$f":"IF(WEEKNUM(FU10,2)=WEEKNUM(FT10,2),\"\",WEEKNUM(FU10,2))","v":""},{"$f":"IF(WEEKNUM(FV10,2)=WEEKNUM(FU10,2),\"\",WEEKNUM(FV10,2))","v":""},{"$f":"IF(WEEKNUM(FW10,2)=WEEKNUM(FV10,2),\"\",WEEKNUM(FW10,2))","v":"1900-02-01"},{"$f":"IF(WEEKNUM(FX10,2)=WEEKNUM(FW10,2),\"\",WEEKNUM(FX10,2))","v":""},{"$f":"IF(WEEKNUM(FY10,2)=WEEKNUM(FX10,2),\"\",WEEKNUM(FY10,2))","v":""},{"$f":"IF(WEEKNUM(FZ10,2)=WEEKNUM(FY10,2),\"\",WEEKNUM(FZ10,2))","v":""},{"$f":"IF(WEEKNUM(GA10,2)=WEEKNUM(FZ10,2),\"\",WEEKNUM(GA10,2))","v":""},{"$f":"IF(WEEKNUM(GB10,2)=WEEKNUM(GA10,2),\"\",WEEKNUM(GB10,2))","v":""},{"$f":"IF(WEEKNUM(GC10,2)=WEEKNUM(GB10,2),\"\",WEEKNUM(GC10,2))","v":""},{"$f":"IF(WEEKNUM(GD10,2)=WEEKNUM(GC10,2),\"\",WEEKNUM(GD10,2))","v":"1900-02-02"},{"$f":"IF(WEEKNUM(GE10,2)=WEEKNUM(GD10,2),\"\",WEEKNUM(GE10,2))","v":""},{"$f":"IF(WEEKNUM(GF10,2)=WEEKNUM(GE10,2),\"\",WEEKNUM(GF10,2))","v":""},{"$f":"IF(WEEKNUM(GG10,2)=WEEKNUM(GF10,2),\"\",WEEKNUM(GG10,2))","v":""},{"$f":"IF(WEEKNUM(GH10,2)=WEEKNUM(GG10,2),\"\",WEEKNUM(GH10,2))","v":""},{"$f":"IF(WEEKNUM(GI10,2)=WEEKNUM(GH10,2),\"\",WEEKNUM(GI10,2))","v":""},{"$f":"IF(WEEKNUM(GJ10,2)=WEEKNUM(GI10,2),\"\",WEEKNUM(GJ10,2))","v":""},{"$f":"IF(WEEKNUM(GK10,2)=WEEKNUM(GJ10,2),\"\",WEEKNUM(GK10,2))","v":"1900-02-03"},{"$f":"IF(WEEKNUM(GL10,2)=WEEKNUM(GK10,2),\"\",WEEKNUM(GL10,2))","v":""},{"$f":"IF(WEEKNUM(GM10,2)=WEEKNUM(GL10,2),\"\",WEEKNUM(GM10,2))","v":""},{"$f":"IF(WEEKNUM(GN10,2)=WEEKNUM(GM10,2),\"\",WEEKNUM(GN10,2))","v":""},{"$f":"IF(WEEKNUM(GO10,2)=WEEKNUM(GN10,2),\"\",WEEKNUM(GO10,2))","v":""},{"$f":"IF(WEEKNUM(GP10,2)=WEEKNUM(GO10,2),\"\",WEEKNUM(GP10,2))","v":""},{"$f":"IF(WEEKNUM(GQ10,2)=WEEKNUM(GP10,2),\"\",WEEKNUM(GQ10,2))","v":""},{"$f":"IF(WEEKNUM(GR10,2)=WEEKNUM(GQ10,2),\"\",WEEKNUM(GR10,2))","v":"1900-02-04"},{"$f":"IF(WEEKNUM(GS10,2)=WEEKNUM(GR10,2),\"\",WEEKNUM(GS10,2))","v":""},{"$f":"IF(WEEKNUM(GT10,2)=WEEKNUM(GS10,2),\"\",WEEKNUM(GT10,2))","v":""},{"$f":"IF(WEEKNUM(GU10,2)=WEEKNUM(GT10,2),\"\",WEEKNUM(GU10,2))","v":""},{"$f":"IF(WEEKNUM(GV10,2)=WEEKNUM(GU10,2),\"\",WEEKNUM(GV10,2))","v":""},{"$f":"IF(WEEKNUM(GW10,2)=WEEKNUM(GV10,2),\"\",WEEKNUM(GW10,2))","v":""},{"$f":"IF(WEEKNUM(GX10,2)=WEEKNUM(GW10,2),\"\",WEEKNUM(GX10,2))","v":""},{"$f":"IF(WEEKNUM(GY10,2)=WEEKNUM(GX10,2),\"\",WEEKNUM(GY10,2))","v":"1900-02-05"},{"$f":"IF(WEEKNUM(GZ10,2)=WEEKNUM(GY10,2),\"\",WEEKNUM(GZ10,2))","v":""},{"$f":"IF(WEEKNUM(HA10,2)=WEEKNUM(GZ10,2),\"\",WEEKNUM(HA10,2))","v":""},{"$f":"IF(WEEKNUM(HB10,2)=WEEKNUM(HA10,2),\"\",WEEKNUM(HB10,2))","v":""},{"$f":"IF(WEEKNUM(HC10,2)=WEEKNUM(HB10,2),\"\",WEEKNUM(HC10,2))","v":""},{"$f":"IF(WEEKNUM(HD10,2)=WEEKNUM(HC10,2),\"\",WEEKNUM(HD10,2))","v":""},{"$f":"IF(WEEKNUM(HE10,2)=WEEKNUM(HD10,2),\"\",WEEKNUM(HE10,2))","v":""},{"$f":"IF(WEEKNUM(HF10,2)=WEEKNUM(HE10,2),\"\",WEEKNUM(HF10,2))","v":"1900-02-06"},{"$f":"IF(WEEKNUM(HG10,2)=WEEKNUM(HF10,2),\"\",WEEKNUM(HG10,2))","v":""},{"$f":"IF(WEEKNUM(HH10,2)=WEEKNUM(HG10,2),\"\",WEEKNUM(HH10,2))","v":""},{"$f":"IF(WEEKNUM(HI10,2)=WEEKNUM(HH10,2),\"\",WEEKNUM(HI10,2))","v":""},{"$f":"IF(WEEKNUM(HJ10,2)=WEEKNUM(HI10,2),\"\",WEEKNUM(HJ10,2))","v":""},{"$f":"IF(WEEKNUM(HK10,2)=WEEKNUM(HJ10,2),\"\",WEEKNUM(HK10,2))","v":""},{"$f":"IF(WEEKNUM(HL10,2)=WEEKNUM(HK10,2),\"\",WEEKNUM(HL10,2))","v":""},{"$f":"IF(WEEKNUM(HM10,2)=WEEKNUM(HL10,2),\"\",WEEKNUM(HM10,2))","v":"1900-02-07"},{"$f":"IF(WEEKNUM(HN10,2)=WEEKNUM(HM10,2),\"\",WEEKNUM(HN10,2))","v":""},{"$f":"IF(WEEKNUM(HO10,2)=WEEKNUM(HN10,2),\"\",WEEKNUM(HO10,2))","v":""},{"$f":"IF(WEEKNUM(HP10,2)=WEEKNUM(HO10,2),\"\",WEEKNUM(HP10,2))","v":""},{"$f":"IF(WEEKNUM(HQ10,2)=WEEKNUM(HP10,2),\"\",WEEKNUM(HQ10,2))","v":""},{"$f":"IF(WEEKNUM(HR10,2)=WEEKNUM(HQ10,2),\"\",WEEKNUM(HR10,2))","v":""},{"$f":"IF(WEEKNUM(HS10,2)=WEEKNUM(HR10,2),\"\",WEEKNUM(HS10,2))","v":""},{"$f":"IF(WEEKNUM(HT10,2)=WEEKNUM(HS10,2),\"\",WEEKNUM(HT10,2))","v":"1900-02-08"},{"$f":"IF(WEEKNUM(HU10,2)=WEEKNUM(HT10,2),\"\",WEEKNUM(HU10,2))","v":""},{"$f":"IF(WEEKNUM(HV10,2)=WEEKNUM(HU10,2),\"\",WEEKNUM(HV10,2))","v":""},{"$f":"IF(WEEKNUM(HW10,2)=WEEKNUM(HV10,2),\"\",WEEKNUM(HW10,2))","v":""},{"$f":"IF(WEEKNUM(HX10,2)=WEEKNUM(HW10,2),\"\",WEEKNUM(HX10,2))","v":""},{"$f":"IF(WEEKNUM(HY10,2)=WEEKNUM(HX10,2),\"\",WEEKNUM(HY10,2))","v":""},{"$f":"IF(WEEKNUM(HZ10,2)=WEEKNUM(HY10,2),\"\",WEEKNUM(HZ10,2))","v":""},{"$f":"IF(WEEKNUM(IA10,2)=WEEKNUM(HZ10,2),\"\",WEEKNUM(IA10,2))","v":"1900-02-09"},{"$f":"IF(WEEKNUM(IB10,2)=WEEKNUM(IA10,2),\"\",WEEKNUM(IB10,2))","v":""},{"$f":"IF(WEEKNUM(IC10,2)=WEEKNUM(IB10,2),\"\",WEEKNUM(IC10,2))","v":""},{"$f":"IF(WEEKNUM(ID10,2)=WEEKNUM(IC10,2),\"\",WEEKNUM(ID10,2))","v":""},{"$f":"IF(WEEKNUM(IE10,2)=WEEKNUM(ID10,2),\"\",WEEKNUM(IE10,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKDAY(K10)","v":"1900-01-02"},{"$f":"WEEKDAY(L10)","v":"1900-01-03"},"1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03",{"$f":"WEEKDAY(BX10)","v":"1900-01-04"},"1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04",{"$f":"WEEKDAY(EJ10)","v":"1900-01-05"},"1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05",{"$f":"WEEKDAY(GV10)","v":"1900-01-06"},"1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06"]
[null,null,null,"TACHE","Responsable",null,null,null,null,"COMPLETE",{"$f":"H5","v":"2020-02-17"},{"$f":"K10+1","v":"2020-02-18"},{"$f":"L10+1","v":"2020-02-19"},"2020-02-20","2020-02-21","2020-02-22","2020-02-23","2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28","2020-02-29","2020-03-01","2020-03-02","2020-03-03","2020-03-04","2020-03-05","2020-03-06","2020-03-07","2020-03-08","2020-03-09","2020-03-10","2020-03-11","2020-03-12","2020-03-13","2020-03-14","2020-03-15","2020-03-16","2020-03-17","2020-03-18","2020-03-19","2020-03-20","2020-03-21","2020-03-22","2020-03-23","2020-03-24","2020-03-25","2020-03-26","2020-03-27","2020-03-28","2020-03-29","2020-03-30","2020-03-31","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16",{"$f":"BR10+1","v":"2020-04-17"},"2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04","2020-06-05","2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19",{"$f":"ED10+1","v":"2020-06-20"},"2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29",{"$f":"EN10+1","v":"2020-06-30"},{"$f":"EO10+1","v":"2020-07-01"},{"$f":"EP10+1","v":"2020-07-02"},{"$f":"EQ10+1","v":"2020-07-03"},{"$f":"ER10+1","v":"2020-07-04"},{"$f":"ES10+1","v":"2020-07-05"},{"$f":"ET10+1","v":"2020-07-06"},{"$f":"EU10+1","v":"2020-07-07"},{"$f":"EV10+1","v":"2020-07-08"},{"$f":"EW10+1","v":"2020-07-09"},{"$f":"EX10+1","v":"2020-07-10"},{"$f":"EY10+1","v":"2020-07-11"},{"$f":"EZ10+1","v":"2020-07-12"},{"$f":"FA10+1","v":"2020-07-13"},{"$f":"FB10+1","v":"2020-07-14"},{"$f":"FC10+1","v":"2020-07-15"},{"$f":"FD10+1","v":"2020-07-16"},{"$f":"FE10+1","v":"2020-07-17"},{"$f":"FF10+1","v":"2020-07-18"},{"$f":"FG10+1","v":"2020-07-19"},{"$f":"FH10+1","v":"2020-07-20"},{"$f":"FI10+1","v":"2020-07-21"},{"$f":"FJ10+1","v":"2020-07-22"},{"$f":"FK10+1","v":"2020-07-23"},{"$f":"FL10+1","v":"2020-07-24"},{"$f":"FM10+1","v":"2020-07-25"},{"$f":"FN10+1","v":"2020-07-26"},{"$f":"FO10+1","v":"2020-07-27"},{"$f":"FP10+1","v":"2020-07-28"},{"$f":"FQ10+1","v":"2020-07-29"},{"$f":"FR10+1","v":"2020-07-30"},{"$f":"FS10+1","v":"2020-07-31"},{"$f":"FT10+1","v":"2020-08-01"},{"$f":"FU10+1","v":"2020-08-02"},{"$f":"FV10+1","v":"2020-08-03"},{"$f":"FW10+1","v":"2020-08-04"},{"$f":"FX10+1","v":"2020-08-05"},{"$f":"FY10+1","v":"2020-08-06"},{"$f":"FZ10+1","v":"2020-08-07"},{"$f":"GA10+1","v":"2020-08-08"},{"$f":"GB10+1","v":"2020-08-09"},{"$f":"GC10+1","v":"2020-08-10"},{"$f":"GD10+1","v":"2020-08-11"},{"$f":"GE10+1","v":"2020-08-12"},{"$f":"GF10+1","v":"2020-08-13"},{"$f":"GG10+1","v":"2020-08-14"},{"$f":"GH10+1","v":"2020-08-15"},{"$f":"GI10+1","v":"2020-08-16"},{"$f":"GJ10+1","v":"2020-08-17"},{"$f":"GK10+1","v":"2020-08-18"},{"$f":"GL10+1","v":"2020-08-19"},{"$f":"GM10+1","v":"2020-08-20"},{"$f":"GN10+1","v":"2020-08-21"},{"$f":"GO10+1","v":"2020-08-22"},{"$f":"GP10+1","v":"2020-08-23"},{"$f":"GQ10+1","v":"2020-08-24"},{"$f":"GR10+1","v":"2020-08-25"},{"$f":"GS10+1","v":"2020-08-26"},{"$f":"GT10+1","v":"2020-08-27"},{"$f":"GU10+1","v":"2020-08-28"},{"$f":"GV10+1","v":"2020-08-29"},{"$f":"GW10+1","v":"2020-08-30"},{"$f":"GX10+1","v":"2020-08-31"},{"$f":"GY10+1","v":"2020-09-01"},{"$f":"GZ10+1","v":"2020-09-02"},{"$f":"HA10+1","v":"2020-09-03"},{"$f":"HB10+1","v":"2020-09-04"},{"$f":"HC10+1","v":"2020-09-05"},{"$f":"HD10+1","v":"2020-09-06"},{"$f":"HE10+1","v":"2020-09-07"},{"$f":"HF10+1","v":"2020-09-08"},{"$f":"HG10+1","v":"2020-09-09"},{"$f":"HH10+1","v":"2020-09-10"},{"$f":"HI10+1","v":"2020-09-11"},{"$f":"HJ10+1","v":"2020-09-12"},{"$f":"HK10+1","v":"2020-09-13"},{"$f":"HL10+1","v":"2020-09-14"},{"$f":"HM10+1","v":"2020-09-15"},{"$f":"HN10+1","v":"2020-09-16"},{"$f":"HO10+1","v":"2020-09-17"},{"$f":"HP10+1","v":"2020-09-18"},{"$f":"HQ10+1","v":"2020-09-19"},{"$f":"HR10+1","v":"2020-09-20"},{"$f":"HS10+1","v":"2020-09-21"},{"$f":"HT10+1","v":"2020-09-22"},{"$f":"HU10+1","v":"2020-09-23"},{"$f":"HV10+1","v":"2020-09-24"},{"$f":"HW10+1","v":"2020-09-25"},{"$f":"HX10+1","v":"2020-09-26"},{"$f":"HY10+1","v":"2020-09-27"},{"$f":"HZ10+1","v":"2020-09-28"},{"$f":"IA10+1","v":"2020-09-29"},{"$f":"IB10+1","v":"2020-09-30"},{"$f":"IC10+1","v":"2020-10-01"},{"$f":"ID10+1","v":"2020-10-02"}]
[1,0,null,"PEDS",null,null,{"$f":"SUM(G12:G13,G14:G16,)","v":20},null,{"$f":"SUM(I12:I13,I14:I16,)","v":20},{"$f":"G11-I11","v":0},{"$f":"IF(AND($G11=0,$H11=K$10),0,\"\")","v":""},{"$f":"IF(AND($G11=0,$H11=L$10),0,\"\")","v":""},"","","","","","","",{"$f":"IF(AND($G11=0,$H11=T$10),0,\"\")","v":""},{"$f":"IF(AND($G11=0,$H11=U$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=AE$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=AO$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=AY$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=BI$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=BS$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=CC$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=CM$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=CW$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=DG$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=DQ$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=EA$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=EK$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=EU$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=FE$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=FU$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=GK$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=HA$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=HQ$10),0,\"\")","v":""},"","","","","","","","","","","","","",""]
[1,{"$f":"B11+1","v":1},null,"Début mission",{"$f":"$D$5","v":"Project Lead"},{"$f":"H5","v":"2020-02-17"},5,{"$f":"H5","v":"2020-02-17"},{"$f":"G12","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B12+1","v":2},null,"Demande des plans d'impétrants et rédaction d'une note préparatoire PEDS",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F12,G12,REF_HOL)","v":"2020-02-24"},5,{"$f":"WORKDAY(H12,I12,REF_HOL)","v":"2020-02-24"},{"$f":"G13","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B13+1","v":3},null,"Evaluation de la note préparatoire PEDS",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F13,G13,REF_HOL)","v":"2020-03-02"},4,{"$f":"WORKDAY(H13,I13,REF_HOL)","v":"2020-03-02"},{"$f":"G14","v":4},0,{"$f":"IF(AND($G14=0,$H14=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B14+1","v":4},null,"Visite de terrain","Project Lead",{"$f":"WORKDAY(F14,G14,REF_HOL)","v":"2020-03-06"},1,{"$f":"WORKDAY(H14,I14,REF_HOL)","v":"2020-03-06"},1,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,5,null,"Rédaction PEDS définitive","Project Lead",{"$f":"WORKDAY(F15,G15,REF_HOL)","v":"2020-03-09"},5,{"$f":"WORKDAY(H15,I15,REF_HOL)","v":"2020-03-09"},{"$f":"G16","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,6,null,"Soumission PEDS à BOFAS","Project Lead",{"$f":"WORKDAY(F16,G16-1,REF_HOL)","v":"2020-03-13"},0,{"$f":"WORKDAY(H16,I16-1,REF_HOL)","v":"2020-03-13"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,7,null,"Evaluation PEDS et bon de commande EDS phase 1",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F16,G16,REF_HOL)","v":"2020-03-16"},5,{"$f":"WORKDAY(H16,I16,REF_HOL)","v":"2020-03-16"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,0,null,"EDS phase 1",null,null,{"$f":"G20+G21+G22","v":35},null,{"$f":"I20+I21+I22","v":35},{"$f":"G19-I19","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,1,null,"Planification des travaux de terrain",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F18,G18,REF_HOL)","v":"2020-03-23"},5,{"$f":"WORKDAY(H18,I18,REF_HOL)","v":"2020-03-23"},{"$f":"G20","v":5},0,{"$f":"IF(AND($G20=0,$H20=K$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=U$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=AE$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=AO$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=AY$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=BI$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=BS$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=CC$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=CM$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=CW$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=DG$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=DQ$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=EA$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=EK$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=EU$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G20=0,$H20=FE$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,2,null,"Travaux de terrain incl. analyses labo (si uniquement forages: durée = 10 jours)","Project Lead",{"$f":"WORKDAY(F20,G20,REF_HOL)","v":"2020-03-30"},20,{"$f":"WORKDAY(H20,I20,REF_HOL)","v":"2020-03-30"},{"$f":"G21","v":20},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,{"$f":"B21+1","v":3},null,"Interprétation et évaluation des résultats","Project Lead",{"$f":"WORKDAY(F21,G21,REF_HOL)","v":"2020-04-28"},10,{"$f":"WORKDAY(H21,I21,REF_HOL)","v":"2020-04-28"},{"$f":"G22","v":10},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,4,null,"Rapportage à BOFAS y compris proposition phase 2","Project Lead",{"$f":"WORKDAY(F22,G22-1,REF_HOL)","v":"2020-05-12"},0,{"$f":"WORKDAY(H22,I22-1,REF_HOL)","v":"2020-05-12"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,{"$f":"B23+1","v":5},null,"Evaluation rapportage et bon de commande phase 2",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F22,G22,REF_HOL)","v":"2020-05-13"},5,{"$f":"WORKDAY(H22,I22,REF_HOL)","v":"2020-05-13"},{"$f":"G24","v":5},0,{"$f":"IF(AND($G24=0,$H24=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,0,null,"EDS phase 2",null,null,{"$f":"IF($D25=\"ABO fase x\",0,G26+G27+G28)","v":35},null,{"$f":"IF($D25=\"ABO fase x\",0,I26+I27+I28)","v":35},{"$f":"G25-I25","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,{"$f":"B25+1","v":1},null,"Planification des travaux de terrain",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F24,G24,REF_HOL)","v":"2020-05-20"},5,{"$f":"WORKDAY(H24,I24,REF_HOL)","v":"2020-05-20"},{"$f":"G26","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G26=0,$H26=GJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G26=0,$H26=HP$10),0,\"\")","v":""},"","","","","","","","","","","","","","",""]
[3,2,null,"Travaux de terrain incl. analyses labo (si uniquement forages: durée = 10 jours)","Project Lead",{"$f":"WORKDAY(F26,G26,REF_HOL)","v":"2020-05-28"},20,{"$f":"WORKDAY(H26,I26,REF_HOL)","v":"2020-05-28"},{"$f":"G27","v":20},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G27=0,$H27=FU$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G27=0,$H27=GU$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G27=0,$H27=HK$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G27=0,$H27=IA$10),0,\"\")","v":""},"","","",""]
[3,{"$f":"B27+1","v":3},null,"Interprétation et évaluation des résultats","Project Lead",{"$f":"WORKDAY(F27,G27,REF_HOL)","v":"2020-06-26"},10,{"$f":"WORKDAY(H27,I27,REF_HOL)","v":"2020-06-26"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,4,null,"Rapportage à BOFAS y compris proposition phase x+1","Project Lead",{"$f":"WORKDAY(F28,G28-1,REF_HOL)","v":"2020-07-09"},0,{"$f":"WORKDAY(H28,I28-1,REF_HOL)","v":"2020-07-09"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,5,null,"Evaluation rapportage et bon de commande phase x+1",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F28,G28,REF_HOL)","v":"2020-07-10"},5,{"$f":"WORKDAY(H28,I28,REF_HOL)","v":"2020-07-10"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",0,null,"EDS phase x",null,null,{"$f":"IF($D31=\"ABO fase x\",0,G32+G33+G34)","v":35},null,{"$f":"IF($D31=\"ABO fase x\",0,I32+I33+I34)","v":35},{"$f":"G31-I31","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",{"$f":"B31+1","v":1},null,"Planification des travaux de terrain",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F24,G24,REF_HOL)","v":"2020-05-20"},5,{"$f":"WORKDAY(H24,I24,REF_HOL)","v":"2020-05-20"},{"$f":"G32","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",2,null,"Travaux de terrain incl. analyses labo (si uniquement forages: durée = 10 jours)","Project Lead",{"$f":"WORKDAY(F32,G32,REF_HOL)","v":"2020-05-28"},20,{"$f":"WORKDAY(H32,I32,REF_HOL)","v":"2020-05-28"},{"$f":"G33","v":20},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",{"$f":"B33+1","v":3},null,"Interprétation et évaluation des résultats","Project Lead",{"$f":"WORKDAY(F33,G33,REF_HOL)","v":"2020-06-26"},10,{"$f":"WORKDAY(H33,I33,REF_HOL)","v":"2020-06-26"},10,0,{"$f":"IF(AND($G34=0,$H34=K$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=U$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=AE$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=AO$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=AY$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=BI$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=BS$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=CC$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=CM$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=CW$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=DG$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=DQ$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=EA$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=EK$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=EU$10),0,\"\")","v":""},"","","","","","","","","",{"$f":"IF(AND($G34=0,$H34=FE$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",4,null,"Rapportage à BOFAS y compris proposition phase x+1","Project Lead",{"$f":"WORKDAY(F34,G34-1,REF_HOL)","v":"2020-07-09"},0,{"$f":"WORKDAY(H34,I34-1,REF_HOL)","v":"2020-07-09"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["x",5,null,"Evaluation rapportage et bon de commande phase x+1",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F34,G34,REF_HOL)","v":"2020-07-10"},5,{"$f":"WORKDAY(H34,I34,REF_HOL)","v":"2020-07-10"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,0,null,"Rapportage EDS ",null,null,{"$f":"SUM(G38:G40)","v":25},null,{"$f":"SUM(I38:I40)","v":25},{"$f":"G37-I37","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,1,null,"Elaboration rapport draft EDS",{"$f":"$D$5","v":"Project Lead"},{"$f":"IF($D31=\"ABO fase x\",WORKDAY(F30,G30,REF_HOL),WORKDAY(F36,G36,REF_HOL))","v":"2020-07-17"},10,{"$f":"IF($D31=\"ABO fase x\",WORKDAY(H30,I30,REF_HOL),WORKDAY(H36,I36,REF_HOL))","v":"2020-07-17"},{"$f":"G38","v":10},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,2,null,"Evaluation rapport draft EDS",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F38,G38,REF_HOL)","v":"2020-08-03"},5,{"$f":"WORKDAY(H38,I38,REF_HOL)","v":"2020-08-03"},{"$f":"G39","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,3,null,"Elaboration rapport final EDS",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F39,G39,REF_HOL)","v":"2020-08-10"},10,{"$f":"WORKDAY(H39,I39,REF_HOL)","v":"2020-08-10"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,4,null,"Soumission EDS aux autorités","Project Lead",{"$f":"WORKDAY(F40,G40-1,REF_HOL)","v":"2020-08-21"},0,{"$f":"WORKDAY(H40,I40-1,REF_HOL)","v":"2020-08-21"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,5,null,"Soumission EDS et décompte final à BOFAS","Project Lead",{"$f":"WORKDAY(F40,G40,REF_HOL)","v":"2020-08-24"},5,{"$f":"WORKDAY(H40,I40,REF_HOL)","v":"2020-08-24"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G42=0,$H42=GK$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,6,null,"Contrôle décompte final",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F42,G42,REF_HOL)","v":"2020-08-31"},10,{"$f":"WORKDAY(H42,I42,REF_HOL)","v":"2020-08-31"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G43=0,$H43=DJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G43=0,$H43=FU$10),0,\"\")","v":""},"","","","","","","","","","","","",{"$f":"IF(AND($G43=0,$H43=GH$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G43=0,$H43=HA$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G43=0,$H43=HQ$10),0,\"\")","v":""},"","","","","","","","","","","","","",""]
[{"$f":"A43+1","v":11},{"$f":"0","v":0},null,"Activity 20",null,null,{"$f":"SUM(G45:G46)","v":15},null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,{"$f":"B44+1","v":1},null,"Activity 21",{"$f":"$D$5","v":"Project Lead"},"1900-01-14",8,"1900-01-14",{"$f":"G45","v":8},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,{"$f":"B45+1","v":2},null,"Activity 22",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},"1900-01-14",7,"1900-01-14",{"$f":"G46","v":7},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,"Légende :"]
[null,null,null,"Durée: durée en jours ouvrables"]
[null,null,null,"= weekend"]
[null,null,null,"Remarques :"]
[null,null,null,"Le calendrier ci-dessus se fonde sur l'hypothèse que les autorisations, permis et plans des impétrants nécessaires sont obtenus rapidement."]
[null,null,null,"Si des travaux de terrain supplémentaires ou des essais de faisabilité sont nécessaires, le délai d'exécution sera prolongé en concertation mutuelle. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"EBSD"]
[null,null,null,"Envirosoil"]
[null,null,null,"Sweco Belgium nv"]
[null,null,null,"Witteveen&Bos"]
[null,null,null,"Antea Group"]
[null,null,null,"RSK Benelux"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Project Leader BOFAS"]
[null,null,null,"Gert Moerenhout"]
[null,null,null,"Katrien Achten"]
[null,null,null,"Kris Vandijck"]
[null,null,null,"Leen Vandenbussche"]
[null,null,null,"Luc Goolaerts"]
[null,null,null,"Pierre Bourguignon"]
[null,null,null,"Sven Van Daele"]
[null,null,null,"Sylvie Posel"]
[null,null,null,"Thomas Laloux"]
[null,null,null,"Yves Van Malderen"]
[null,null,null,"Yvon Vermoortel"]

{"sheet":"Gantt  PA","index":1,"n_rows":45,"n_cols":164,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,29,3,35],[3,37,3,44],[3,5,3,6],[3,13,3,17],[3,19,3,22],[3,24,3,27],[7,0,7,1],[0,0,0,9],[4,5,4,6],[5,5,5,6],[6,5,6,6],[6,7,6,9]]}
[{"$f":"\"Planning du Projet - PA d.d. \"&(DAY(MAX(IssueList!F2:F4)))&\"-\"&(MONTH(MAX(IssueList!F2:F4)))&\"-\"&(YEAR(MAX(IssueList!F2:F4)))","v":"Planning du Projet - PA d.d. 17-2-2020"}]
[null,null,null,null,null,"Milestone:",0]
[null,null,null,{"$f":"'Gantt EDS'!D3","v":"Demande (N°, nom à commune)"}]
[null,null,null,{"$f":"'Gantt EDS'!D4","v":"Company Name"},null,"Today:",null,{"$f":"TODAY()","v":"2020-03-12"},null," Period Highlight:",{"$f":"H4","v":43902},null,null,"Plan Duration",null,null,null,null,null,"Actual Start",null,null,null,null,"% Complete",null,null,null,null,"Actual (beyond plan)",null,null,null,null,null,null,null,"% Complete (beyond plan)"]
[null,null,null,"Project Lead",null,"Project Start Date:",null,{"$f":"'Gantt EDS'!H6","v":"2020-08-31"}]
[null,null,null,{"$f":"'Gantt EDS'!D6","v":"Project BOFAS"},null,"Project End Date:",null,{"$f":"MAX(H12:H38)","v":"2021-01-21"},null,null,"PERIODES"]
[null,null,null,null,null,"Plan",null,"ACTUAL ",null,null,{"$f":"MID(PROPER(TEXT(K10,\"mmm/aaaa\")),DAY(K10),1)","v":""},"S","e","p","t","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","O",{"$f":"MID(PROPER(TEXT(AQ10,\"mmm/aaaa\")),DAY(AQ10),1)","v":"c"},"t","/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","","","N","o",{"$f":"MID(PROPER(TEXT(BW10,\"mmm/aaaa\")),DAY(BW10),1)","v":"v"},"/","2","0","2","0","","","","","","","","","","","","","","","","","","","","","","","D","é","c","/",{"$f":"MID(PROPER(TEXT(DC10,\"mmm/aaaa\")),DAY(DC10),1)","v":"2"},"0","2","0","","","","","","","","","","","","","","","","","","","","","","","","J","a","n","v","/",{"$f":"MID(PROPER(TEXT(EI10,\"mmm/aaaa\")),DAY(EI10),1)","v":"2"},"0","2","1","","","","","","","","","","","","","","","","","","","","","",""]
["Task_ID",null,"Issue ID",null,null,"DEPART","Durée","DEPART","Durée","Delta(days)",1,null,{"$f":"IF(WEEKNUM(M10,2)=WEEKNUM(L10,2),\"\",WEEKNUM(M10,2))","v":""},"","","","","1900-02-06","","","","","","","1900-02-07","","","","","","","1900-02-08","","","","","","","1900-02-09","","","","","","","1900-02-10","","","","","","","1900-02-11","","","","","","","1900-02-12","","","","","","","1900-02-13","","","","","","","1900-02-14","","",{"$f":"IF(WEEKNUM(BY10,2)=WEEKNUM(BX10,2),\"\",WEEKNUM(BY10,2))","v":""},"","","","1900-02-15","","","","","","","1900-02-16","","","","","","","1900-02-17","","","","","","","1900-02-18","","","","","","","1900-02-19","","","","","","","1900-02-20","","","","","","","1900-02-21","","","","","","","1900-02-22","","","","1900-01-01","","","1900-01-02","","","",{"$f":"IF(WEEKNUM(EK10,2)=WEEKNUM(EJ10,2),\"\",WEEKNUM(EK10,2))","v":""},"","","1900-01-03","","","","","","","1900-01-04","","","","","","","1900-01-05","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKDAY(K10)","v":"1900-01-02"},{"$f":"WEEKDAY(L10)","v":"1900-01-03"},"1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03",{"$f":"WEEKDAY(BX10)","v":"1900-01-04"},"1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04",{"$f":"WEEKDAY(EJ10)","v":"1900-01-05"},"1900-01-06","1900-01-07","1900-01-01","1900-01-02",{"$f":"WEEKDAY(EO10)","v":"1900-01-03"},"1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01"]
[null,null,null,"TACHE","Responsable",null,null,null,null,"COMPLETE",{"$f":"H5","v":"2020-08-31"},{"$f":"K10+1","v":"2020-09-01"},{"$f":"L10+1","v":"2020-09-02"},"2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10","2020-10-11","2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04",{"$f":"BX10+1","v":"2020-11-05"},"2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11","2020-12-12","2020-12-13","2020-12-14","2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30","2020-12-31","2021-01-01","2021-01-02","2021-01-03","2021-01-04","2021-01-05","2021-01-06","2021-01-07",{"$f":"EJ10+1","v":"2021-01-08"},"2021-01-09","2021-01-10","2021-01-11",{"$f":"EN10+1","v":"2021-01-12"},{"$f":"EO10+1","v":"2021-01-13"},{"$f":"EP10+1","v":"2021-01-14"},{"$f":"EQ10+1","v":"2021-01-15"},{"$f":"ER10+1","v":"2021-01-16"},{"$f":"ES10+1","v":"2021-01-17"},{"$f":"ET10+1","v":"2021-01-18"},{"$f":"EU10+1","v":"2021-01-19"},{"$f":"EV10+1","v":"2021-01-20"},{"$f":"EW10+1","v":"2021-01-21"},{"$f":"EX10+1","v":"2021-01-22"},{"$f":"EY10+1","v":"2021-01-23"},{"$f":"EZ10+1","v":"2021-01-24"},{"$f":"FA10+1","v":"2021-01-25"},{"$f":"FB10+1","v":"2021-01-26"},{"$f":"FC10+1","v":"2021-01-27"},{"$f":"FD10+1","v":"2021-01-28"},{"$f":"FE10+1","v":"2021-01-29"},{"$f":"FF10+1","v":"2021-01-30"},{"$f":"FG10+1","v":"2021-01-31"}]
[1,0,null,"PPA",null,null,{"$f":"SUM(G12:G15)+MAX(G16:G17)","v":30},null,{"$f":"SUM(I12:I15)+MAX(I16:I17)","v":30},{"$f":"G11-I11","v":0},{"$f":"IF(AND($G11=0,$H11=K$10),0,\"\")","v":""},{"$f":"IF(AND($G11=0,$H11=L$10),0,\"\")","v":""},"","","","","","","","",{"$f":"IF(AND($G11=0,$H11=U$10),0,\"\")","v":""},"","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=AI$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=BX$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G11=0,$H11=EJ$10),0,\"\")","v":""},"","","","",{"$f":"IF(AND($G11=0,$H11=EO$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","",""]
[1,1,null,"Début mission après bon de commande PPA",{"$f":"$D$5","v":"Project Lead"},{"$f":"H5","v":"2020-08-31"},5,{"$f":"H5","v":"2020-08-31"},{"$f":"G12","v":5},0,{"$f":"IF(AND($G12=0,$H12=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B12+1","v":2},null,"Rédaction d'une note préparatoire PPA",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F12,G12,REF_HOL)","v":"2020-09-07"},15,{"$f":"WORKDAY(H12,I12,REF_HOL)","v":"2020-09-07"},{"$f":"G13","v":15},0,{"$f":"IF(AND($G13=0,$H13=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G13=0,$H13=AQ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G13=0,$H13=BW$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G13=0,$H13=DC$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G13=0,$H13=EI$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B13+1","v":3},null,"Evaluation de la note préparatoire PPA",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F13,G13,REF_HOL)","v":"2020-09-28"},4,{"$f":"WORKDAY(H13,I13,REF_HOL)","v":"2020-09-28"},4,0,{"$f":"IF(AND($G14=0,$H14=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G14=0,$H14=AQ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G14=0,$H14=BW$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G14=0,$H14=DC$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G14=0,$H14=EI$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B14+1","v":4},null,"Visite de terrain","Project Lead",{"$f":"WORKDAY(F14,G14,REF_HOL)","v":"2020-10-02"},1,{"$f":"WORKDAY(H14,I14,REF_HOL)","v":"2020-10-02"},1,0,"",{"$f":"IF(AND($G15=0,$H15=L$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G15=0,$H15=BX$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B15+1","v":5},null,"Rédaction PPA définitive","Project Lead",{"$f":"WORKDAY(F15,G15,REF_HOL)","v":"2020-10-05"},5,{"$f":"WORKDAY(H15,I15,REF_HOL)","v":"2020-10-05"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B16+1","v":6},null,"Sondages","Project Lead",{"$f":"WORKDAY(F15,G15,REF_HOL)","v":"2020-10-05"},5,{"$f":"WORKDAY(H15,I15,REF_HOL)","v":"2020-10-05"},5,0,{"$f":"IF(AND($G17=0,$H17=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B17+1","v":7},null,"Soumission PPA à BOFAS","Project Lead",{"$f":"WORKDAY(F17,G17-1,REF_HOL)","v":"2020-10-09"},0,{"$f":"WORKDAY(H17,I17-1,REF_HOL)","v":"2020-10-09"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G18=0,$H18=BV$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G18=0,$H18=EH$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,{"$f":"B18+1","v":8},null,"Evaluation PPA et bon de commande PA/cahier des charges",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F17,G17,REF_HOL)","v":"2020-10-12"},5,{"$f":"WORKDAY(H17,I17,REF_HOL)","v":"2020-10-12"},5,0,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=AA$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=AQ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=BG$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=CL$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=DB$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G19=0,$H19=DR$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,0,null,"PA",null,null,{"$f":"SUM(G21:G23)","v":30},null,{"$f":"SUM(I21:I23)","v":30},{"$f":"G20-I20","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,1,null,"Elaboration rapport draft PA",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F19,G19,REF_HOL)","v":"2020-10-19"},15,{"$f":"WORKDAY(H19,I19,REF_HOL)","v":"2020-10-19"},{"$f":"G21","v":15},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G21=0,$H21=EJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",""]
[2,{"$f":"B21+1","v":2},null,"Evaluation rapport draft PA",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F21,G21,REF_HOL)","v":"2020-11-09"},5,{"$f":"WORKDAY(H21,I21,REF_HOL)","v":"2020-11-09"},{"$f":"G22","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G22=0,$H22=FB$10),0,\"\")","v":""},"","","","","",""]
[2,{"$f":"B22+1","v":3},null,"Elaboration rapport final PA","Project Lead",{"$f":"WORKDAY(F22,G22,REF_HOL)","v":"2020-11-17"},10,{"$f":"WORKDAY(H22,I22,REF_HOL)","v":"2020-11-17"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G23=0,$H23=EO$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","",""]
[2,4,null,"Soumission PA aux autorités","Project Lead",{"$f":"WORKDAY(F23,G23-1,REF_HOL)","v":"2020-11-30"},0,{"$f":"WORKDAY(H23,I23-1,REF_HOL)","v":"2020-11-30"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,5,null,"Soumission PA et décompte final à BOFAS","Project Lead",{"$f":"WORKDAY(F23,G23,REF_HOL)","v":"2020-12-01"},5,{"$f":"WORKDAY(H23,I23,REF_HOL)","v":"2020-12-01"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,0,null,"Cahier des charges",null,null,{"$f":"SUM(G28:G32)","v":30},null,{"$f":"SUM(I28:I32)","v":30},{"$f":"G26-I26","v":0},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,1,null,"Début mission cahier des charges",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F23,G23,REF_HOL)","v":"2020-12-01"},0,{"$f":"WORKDAY(H23,I23,REF_HOL)","v":"2020-12-01"},{"$f":"G27","v":0},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,{"$f":"B27+1","v":2},null,"Réalisation figures draft pour le cahier des charges",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F27,G27,REF_HOL)","v":"2020-12-01"},5,{"$f":"WORKDAY(H27,I27,REF_HOL)","v":"2020-12-01"},{"$f":"G28","v":5},0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,{"$f":"B28+1","v":3},null,"Evaluation des figures draft",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F28,G28,REF_HOL)","v":"2020-12-08"},5,{"$f":"WORKDAY(H28,I28,REF_HOL)","v":"2020-12-08"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,4,null,"Elaboration cahier des charges draft et métré","Project Lead",{"$f":"WORKDAY(F29,G29,REF_HOL)","v":"2020-12-15"},10,{"$f":"WORKDAY(H29,I29,REF_HOL)","v":"2020-12-15"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,5,null,"Evaluation cahier des charges draft et métré",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F30,G30,REF_HOL)","v":"2020-12-30"},5,{"$f":"WORKDAY(H30,I30,REF_HOL)","v":"2020-12-30"},5,0,"","","","","","","","",{"$f":"IF(AND($G31=0,$H31=S$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G31=0,$H31=BF$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G31=0,$H31=DA$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G31=0,$H31=EG$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,6,null,"Elaboration cahier des charges définitif",{"$f":"$D$5","v":"Project Lead"},{"$f":"WORKDAY(F31,G31,REF_HOL)","v":"2021-01-07"},5,{"$f":"WORKDAY(H31,I31,REF_HOL)","v":"2021-01-07"},5,0,{"$f":"IF(AND($G32=0,$H32=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G32=0,$H32=AP$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G32=0,$H32=CJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G32=0,$H32=CZ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G32=0,$H32=DR$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,{"$f":"B31+1","v":6},null,"Soumission cahier des charges à BOFAS","Project Lead",{"$f":"WORKDAY(F32,G32-1,REF_HOL)","v":"2021-01-13"},0,{"$f":"WORKDAY(H32,I32-1,REF_HOL)","v":"2021-01-13"},0,0,"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G33=0,$H33=AI$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G33=0,$H33=BW$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"","","","","","","","","","","","","","","","","",""]
[3,{"$f":"B32+1","v":7},null,"Soumission décompte final PA et cahier des charges","Project Lead",{"$f":"WORKDAY(F32,G32,REF_HOL)","v":"2021-01-14"},5,{"$f":"WORKDAY(H32,I32,REF_HOL)","v":"2021-01-14"},5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,8,null,"Contrôle décompte final",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},{"$f":"WORKDAY(F34,G34,REF_HOL)","v":"2021-01-21"},10,{"$f":"WORKDAY(H34,I34,REF_HOL)","v":"2021-01-21"},10,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"A26+1","v":4},{"$f":"0","v":0},null,"Activity 20",null,null,{"$f":"SUM(G37:G38)","v":0},null,null,null,{"$f":"IF(AND($G36=0,$H36=K$10),0,\"\")","v":""},"","","","","","","",{"$f":"IF(AND($G36=0,$H36=S$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=AI$10),0,\"\")","v":""},"","","","","","","",{"$f":"IF(AND($G36=0,$H36=AQ$10),0,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=BF$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=BV$10),0,\"\")","v":""},{"$f":"IF(AND($G36=0,$H36=BW$10),0,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=CL$10),0,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=DA$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=DQ$10),0,\"\")","v":""},{"$f":"IF(AND($G36=0,$H36=DR$10),0,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AND($G36=0,$H36=EG$10),0,\"\")","v":""},"","",{"$f":"IF(AND($G36=0,$H36=EJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",""]
[4,{"$f":"B36+1","v":1},null,"Activity 21",{"$f":"$D$5","v":"Project Lead"},"1900-01-14",0,"1900-01-14",{"$f":"G37","v":0},0,{"$f":"IF(AND($G37=0,$H37=K$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G37=0,$H37=AP$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G37=0,$H37=CJ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($G37=0,$H37=CZ$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G37=0,$H37=DR$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,{"$f":"B37+1","v":2},null,"Activity 22",{"$f":"\"BOFAS \"&$D$6","v":"BOFAS Project BOFAS"},"1900-01-14",0,"1900-01-14",0,0,"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($G38=0,$H38=AI$10),0,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,{"$f":"'Gantt EDS'!D48","v":"Légende :"}]
[null,null,"Duur:",{"$f":"'Gantt EDS'!D49","v":"Durée: durée en jours ouvrables"}]
[null,null,null,{"$f":"'Gantt EDS'!D50","v":"= weekend"}]
[null,null,null,{"$f":"'Gantt EDS'!D51","v":"Remarques :"}]
[null,null,null,{"$f":"'Gantt EDS'!D52","v":"Le calendrier ci-dessus se fonde sur l'hypothèse que les autorisations, permis et plans des impétrants nécessaires sont obtenus rapidement."}]
[null,null,null,{"$f":"'Gantt EDS'!D53","v":"Si des travaux de terrain supplémentaires ou des essais de faisabilité sont nécessaires, le délai d'exécution sera prolongé en concertation mutuelle. "}]

{"sheet":"IssueList","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ID","Date","EAAS ","Commentaire",null,"Date","BOFAS ","Commentaire"]
[null,null,null,null,null,{"$f":" MAX(B5:B25)","v":"2019-03-01"}]
[null,null,null,null,null,{"$f":"'Gantt EDS'!H5","v":"2020-02-17"}]
[null,null,null,null,null,{"$f":"MAX(F5:F25)","v":"2019-03-05"}]
[1,"2019-03-01","LG","Autorisation domaine public demandée, conseil municipal le plus rapidement possible 10/3",null,"2019-03-05","GM","Prolongation du délai EDS tâche 22 autorisation de forages au niveau du domaine public + 10 jours ouvrables"]
[{"$f":"A5+1","v":2}]
[{"$f":"A6+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]

{"sheet":"Holiday","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Feest- en verlofdagen"]
["2020-01-01","2021-01-01","2022-01-03","2023-01-02","2024-01-01","2025-01-01",{"$f":"EDATE(F2,12)","v":"2026-01-01"},{"$f":"EDATE(G2,12)","v":"2027-01-01"}]
["2020-04-13","2021-04-05","2022-04-18","2023-04-10","2024-04-01","2025-04-21"]
["2020-05-01","2021-05-01","2022-05-01","2023-05-01","2024-05-01","2025-05-01",{"$f":"EDATE(F4,12)","v":"2026-05-01"},"2027-05-01"]
["2020-05-21","2021-05-13","2022-05-26","2023-05-18","2024-05-09","2025-05-29"]
["2020-06-01","2021-05-24","2022-06-06","2023-05-29","2024-05-20","2025-06-09"]
["2020-07-21","2021-07-21","2022-07-21","2023-07-21","2024-07-22","2025-07-21",{"$f":"EDATE(F7,12)","v":"2026-07-21"},"2027-07-21"]
["2020-08-15","2021-08-15","2022-08-15","2023-08-15","2024-08-15","2025-08-15",{"$f":"EDATE(F8,12)","v":"2026-08-15"},"2027-08-15"]
["2020-11-01","2021-11-01","2022-11-01","2023-11-01","2024-11-01","2025-11-01",{"$f":"EDATE(F9,12)","v":"2026-11-01"},"2027-11-01"]
["2020-11-11","2021-11-11","2022-11-11","2023-11-13","2024-11-11","2025-11-11",{"$f":"EDATE(F10,12)","v":"2026-11-11"},"2027-11-11"]
["2020-12-25","2021-12-25","2022-12-25","2023-12-25","2024-12-25","2025-12-25",{"$f":"EDATE(F11,12)","v":"2026-12-25"},"2027-12-25"]

{"sheet":"Histlog","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Datum","versie","Wie","VISA","Wat"]
["2019-03-08","0.1","GM",null,"ontwerpversie"]
["2019-03-21","1.0","GM",null,"met baseline"]
["2019-04-03","1.2","GM",null,"milestones"]
["2019-04-10","1.3","GM",null,"Macro toevoegd"]
["2019-06-03","1.4","GM",null,"workday aanpassing"]
["2019-06-21","1.5","GM",null,"aanpassen macro workday copy termijnen extra fase"]
["2019-07-01","1.6","JDW",null,"aanpassen conditional formats mbt workday en milestones (%complete nog te doen)"]
["2019-07-31","1.6.1","GM",null,"Bijwerken 1.6 aan versie 1.7"]
["2019-08-06","1.8.1","GM",null,"planning in weeknummers en weekend, aanpassing fases"]
["2019-08-07","1.8.2","EG",null,"weeknummer ISO, termijnen afgerond (indienen doc = laatste dag), inplannen terreinbezoek"]
["2019-08-21","1.9","LV",null,"lay-out BOFAS 3"]
["2019-09-17","1.10","GM",null,"tekst passend maken"]
["2019-09-25","1.00","LV",null,"definitieve versie BOFAS 3"]
["2020-01-21","1.01","GM",null,"Update "]
["2020-01-28","1.05","GM",null,"werkversie en Keep it simple"]
["2020-01-30","1.06","GM",null,"Issuelist"]
["2020-02-19"]
["2020-02-20",null,"YVM",null,"aanpassing document"]
["2020-02-21","1.00","LV",null,"lay-out BOFAS 3 en versie 1.00 BOFAS 3"]
["2020-03-12","1.00","GM",null,"toevoegen knoppen protect en uprotect"]