{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projet 1","Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Projet 1","index":0,"n_rows":99,"n_cols":67,"rows_kept":99,"cut":false,"hidden":false,"merged":[[6,0,6,4],[2,2,2,4],[1,2,1,4],[0,0,0,4],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[8,5,9,5],[8,4,9,4],[8,3,9,3],[8,2,9,2],[8,1,9,1]]}
["Détails du projet",null,null,null,null,null,15]
["Projet",null,"Article Apprendre-Excel.fr",null,null,null,{"$f":"TODAY()","v":"2018-06-07"}]
["Chef de projet",null,"Cédric GUERIN"]
[]
["Jours ouvrés uniquement",null,"OUI"]
["Date de début",null,"2013-08-01"]
["Commentaires",null,null,null,null,null,null,{"$f":"C6+G1","v":"2013-08-16"},{"$f":"H7+1","v":"2013-08-17"},{"$f":"I7+1","v":"2013-08-18"},"2013-08-19","2013-08-20","2013-08-21","2013-08-22","2013-08-23","2013-08-24","2013-08-25","2013-08-26","2013-08-27","2013-08-28","2013-08-29","2013-08-30","2013-08-31","2013-09-01","2013-09-02","2013-09-03","2013-09-04","2013-09-05","2013-09-06","2013-09-07","2013-09-08","2013-09-09","2013-09-10","2013-09-11","2013-09-12","2013-09-13","2013-09-14","2013-09-15","2013-09-16","2013-09-17","2013-09-18","2013-09-19","2013-09-20","2013-09-21","2013-09-22","2013-09-23","2013-09-24","2013-09-25","2013-09-26","2013-09-27","2013-09-28","2013-09-29","2013-09-30","2013-10-01","2013-10-02","2013-10-03","2013-10-04","2013-10-05","2013-10-06","2013-10-07","2013-10-08","2013-10-09","2013-10-10","2013-10-11","2013-10-12","2013-10-13","2013-10-14"]
[null,null,null,null,null,null,null,{"$f":"\"S \"&WEEKNUM(H7,2)","v":"S 33"},{"$f":"IF(I9=\"L\",\"S \"&WEEKNUM(I7,2),\"\")","v":""},{"$f":"IF(J9=\"L\",\"S \"&WEEKNUM(J7,2),\"\")","v":""},"S 34","","","","","","","S 35","","","","","","","S 36","","","","","","","S 37","","","","","","","S 38","","","","","","","S 39","","","","","","","S 40","","","","","","","S 41","","","","","","","S 42"]
[null,"Tâches","Date de début","Durée","Date de fin","Réalisé",null,{"$f":"VLOOKUP(WEEKDAY(H7,2),semaine,2,FALSE)","v":"V"},"S",{"$f":"VLOOKUP(WEEKDAY(J7,2),semaine,2,FALSE)","v":"D"},"L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L"]
[null,null,null,null,null,null,null,{"$f":"DAY(H7)","v":16},{"$f":"DAY(I7)","v":17},{"$f":"DAY(J7)","v":18},19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[1,"Tâche 1"]
["1.1","Sous-tâche 1","2013-08-18",1,{"$f":"IF(B12=\"\",\"\",IF($C$5=\"OUI\",WORKDAY(C12,IF(WEEKDAY(C12,2)>=6,D12,D12-1)),C12+D12-1))","v":"2013-08-19"},1,{"$f":"C12+F12*(E12-C12)","v":"2013-08-19"}]
["1.2","Sous-tâche 2","2013-08-19",4,{"$f":"IF(B13=\"\",\"\",IF($C$5=\"OUI\",WORKDAY(C13,IF(WEEKDAY(C13,2)>=6,D13,D13-1)),C13+D13-1))","v":"2013-08-22"},1,"2013-08-22"]
["1.3","Sous-tâche 3","2013-08-25",7,"2013-09-03",0.3,"2013-08-27T16:48:00"]
["1.4","Sous-tâche 4","2013-09-03",8,"2013-09-12",0,"2013-09-03"]
["1.5","Sous-tâche 5","2013-09-13",1,"2013-09-13",0,"2013-09-13"]
["1.6","Sous-tâche 6","2013-09-15",12,"2013-10-01",0.5,"2013-09-23"]
["1.7","Sous-tâche 7","2013-10-01",1,"2013-10-01",1,"2013-10-01"]
["1.8","Sous-tâche 8","2013-10-02",6,"2013-10-09",1,"2013-10-09"]
["1.9","Sous-tâche 9","2013-10-08",2,"2013-10-09",null,"2013-10-08"]
["1.10","Sous-tâche 10","2013-10-10",18,"2013-11-04",null,"2013-10-10"]
["1.11","Sous-tâche 11","2013-10-28",16,"2013-11-18",null,"2013-10-28"]
["1.12","Sous-tâche 12","2013-11-13",3,"2013-11-15",null,"2013-11-13"]
["1.13","Sous-tâche 13","2013-11-16",3,"2013-11-20",null,"2013-11-16"]
["1.14","Sous-tâche 14","2013-11-19",9,"2013-11-29",null,"2013-11-19"]
["1.15","Sous-tâche 15","2013-11-28",1,"2013-11-28",null,"2013-11-28"]
["1.16","Sous-tâche 16","2013-11-29",3,"2013-12-03",null,"2013-11-29"]
["1.17","Sous-tâche 17","2013-12-02",3,"2013-12-04",null,"2013-12-02"]
["1.18","Sous-tâche 18","2013-12-05",1,"2013-12-05",null,"2013-12-05"]
["1.19","Sous-tâche 19","2013-12-07",3,"2013-12-11",null,"2013-12-07"]
["1.20","Sous-tâche 20","2013-12-10",1,"2013-12-10",null,"2013-12-10"]
["1.21","Sous-tâche 21","2013-12-12",2,"2013-12-13",null,"2013-12-12"]
["1.22","Sous-tâche 22","2013-12-15",3,"2013-12-18",null,"2013-12-15"]
["1.23","Sous-tâche 23","2013-12-19",4,"2013-12-24",null,"2013-12-19"]
["1.24","Sous-tâche 24","2013-12-24",5,"2013-12-30",null,"2013-12-24"]
["1.25","Sous-tâche 25","2013-12-30",4,"2014-01-02",null,"2013-12-30"]
["1.26","Sous-tâche 26","2014-01-05",1,"2014-01-06",null,"2014-01-05"]
["1.27","Sous-tâche 27","2014-01-06",3,"2014-01-08",null,"2014-01-06"]
["1.28","Sous-tâche 28","2014-01-10",5,"2014-01-16",null,"2014-01-10"]
["1.29","Sous-tâche 29","2014-01-16",4,"2014-01-21",null,"2014-01-16"]
["1.30","Sous-tâche 30","2014-01-21",2,"2014-01-22",null,"2014-01-21"]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B77=\"\",\"\",IF($C$5=\"OUI\",WORKDAY(C77,IF(WEEKDAY(C77,2)>=6,D77,D77-1)),C77+D77-1))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]

{"sheet":"Table","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[1,"L",null,"OUI"]
[2,"M",null,"NON"]
[3,"M"]
[4,"J"]
[5,"V"]
[6,"S"]
[7,"D"]