{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Basic Data","Project Plan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Basic Data","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Planification projet"]
[]
["Basisinformationen",null,null,"Equipe du projet"]
["Nom du projet","PLANNING ",null,"Nom","Email","Numéro de téléphone"]
["Nom du manager",null,null,"Atelier"]
["Date de lancement","2020-09-09",null,"Pose"]
[null,null,null,"Livraison"]

{"sheet":"Project Plan","index":1,"n_rows":30,"n_cols":56,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,49,5,55],[5,7,5,13],[4,7,4,13],[4,14,4,20],[5,14,5,20],[4,21,4,27],[4,28,4,34],[5,21,5,27],[5,28,5,34],[5,35,5,41],[5,42,5,48],[4,35,4,41],[4,42,4,48],[4,49,4,55]]}
[]
[null,null,{"$f":"IF(ISBLANK('Basic Data'!$B$4),\"Nom de la feuille\", 'Basic Data'!$B$4)","v":"PLANNING "}]
[null,null,null,null,null,"Rôle :",null,null,"Pose",null,null,"Atelier",null,null,"Livraison"]
[null,null,"Date de début",{"$f":"IF(ISBLANK('Basic Data'!$B$6),\"Entrez la date sur Basic Data\", 'Basic Data'!$B$6)","v":"2020-09-09"},null,"Livraison"]
[null,null,"Date d'aujourd'hui",{"$f":"TODAY()","v":"2020-09-16"},null,null,null,{"$f":"\"Semaine \"&(H7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 1"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(O7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 2"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(V7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 3"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(AC7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 4"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(AJ7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 5"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(AQ7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 6"},null,null,null,null,null,null,{"$f":"\"Semaine \"&(AX7-($D$4-WEEKDAY($D$4,1)+2))/7+1","v":"Semaine 7"}]
[null,null,"Afficher le planning semaine :",1,null,null,null,{"$f":"H7","v":"2020-09-07"},null,null,null,null,null,null,{"$f":"O7","v":"2020-09-14"},null,null,null,null,null,null,{"$f":"V7","v":"2020-09-21"},null,null,null,null,null,null,{"$f":"AC7","v":"2020-09-28"},null,null,null,null,null,null,{"$f":"AJ7","v":"2020-10-05"},null,null,null,null,null,null,{"$f":"AQ7","v":"2020-10-12"},null,null,null,null,null,null,{"$f":"AX7","v":"2020-10-19"}]
[null,null,null,null,null,null,null,{"$f":"D4-WEEKDAY(D4,1)+2+7*(D6-1)","v":"2020-09-07"},{"$f":"H7+1","v":"2020-09-08"},"2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13",{"$f":"N7+1","v":"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"]
["Element PSP","Tâche / Paquet de travail","Editeur","Commentaires","Début","Deadline","Progression",{"$f":"CHOOSE(WEEKDAY(H7,1),\"Di\",\"Lu\",\"Ma\",\"Me\",\"Je\",\"Ve\",\"Sa\")","v":"Lu"},{"$f":"CHOOSE(WEEKDAY(I7,1),\"Di\",\"Lu\",\"Ma\",\"Me\",\"Je\",\"Ve\",\"Sa\")","v":"Ma"},"Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di","Lu","Ma","Me","Je","Ve","Sa","Di"]
["1","A",null,null,null,null,{"$f":"SUMIF(A10:A12,A9&\"*\",G10:G30)/(COUNTIF(A9:A30,A9&\".*\"))","v":0}]
["1.1","xxx","Pose",null,"2020-09-14","2020-09-18",0]
[2,"B",null,null,null,null,{"$f":"SUMIF(A12:A14,A11&\"*\",G12:G30)/(COUNTIF(A11:A30,A11&\".*\"))","v":0}]
["2.1","xxx","Pose",null,"2020-09-14","2020-09-21",0]
[3,"C",null,null,null,null,{"$f":"SUMIF(A14:A16,A13&\"*\",G14:G30)/(COUNTIF(A13:A30,A13&\".*\"))","v":0.2}]
["3.1","xxx","Atelier",null,"2020-09-07","2020-09-09",1]
["3.2","xxx","Livraison",null,"2020-09-14","2020-09-15",0]
["3.3","xxx","Pose",null,"2020-09-14","2020-09-18",0]
["3.4","xxx","Livraison",null,"2020-09-18","2020-09-18",0]
["3.5","xxx","Pose",null,"2020-09-18","2020-09-18",0]
[4,"D",null,null,null,null,{"$f":"SUMIF(A20:A22,A19&\"*\",G20:G30)/(COUNTIF(A19:A30,A19&\".*\"))","v":0}]
["4.1","xxx","Pose",null,"2020-10-05","2020-10-16",0]
[5,"E",null,null,null,null,{"$f":"SUMIF(A22:A24,A21&\"*\",G22:G30)/(COUNTIF(A21:A30,A21&\".*\"))","v":0}]
["5.1","xxx","Atelier",null,"2020-09-16","2020-09-16",0]
[6,"F",null,null,null,null,{"$f":"SUMIF(A24:A26,A23&\"*\",G24:G30)/(COUNTIF(A23:A30,A23&\".*\"))","v":0}]
["6.1","xxx","Atelier",null,"2020-09-14","2020-09-15",0]
["6.2","xxx","Livraison",null,"2020-09-16","2020-09-16",0]
["6.3","xxx","Pose",null,"2020-09-16","2020-09-17",0]
[7,"G",null,null,null,null,{"$f":"SUMIF(A28:A30,A27&\"*\",G28:G30)/(COUNTIF(A27:A30,A27&\".*\"))","v":0}]
["7.1","xxx","Atelier",null,"2020-09-18","2020-09-22",0]
["7.2","xxx","Livraison",null,"2020-09-23","2020-09-23",0]
["7.3","xxx","Pose",null,"2020-09-23","2020-09-25",0]