{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Gant"],"not_rendered":{"charts":1,"images":1,"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":"Gant","index":0,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Project Name","My Project Name"]
["Days Off","2015-01-02","2015-01-10",null,null,null,"<- Add days of closure here in line"]
["Project Start Date",{"$f":"MIN(C10:C13)","v":"2015-01-03"}]
["Project End",{"$f":"MAX(I10:I13)","v":"2015-01-12"}]
[]
[null,null,null,"Input",null,"Input",null,null,null,"Input",null,null,"Input"]
[null,null,null,null,null,"[days]","[days]","[days]",null,null,null,null,"M=Manual, A= Auto"]
[]
["Id","Task","Start Date","Manual Start Date","Calculated Start Date","Duration","Completed","Remaining","End Date","Predecessor Id","Predecessor Name","Predecessor End Date","Type of Task"]
[1,"Task 1",{"$f":"IF(M10=\"M\",D10,E10)","v":"2015-01-03"},"2015-01-03",{"$f":"L10","v":{"$error":"#N/A"}},2,1,{"$f":"F10-G10","v":1},{"$f":"WORKDAY(D10,F10,$B$2:$E$2)","v":"2015-01-06"},null,{"$f":"HLOOKUP($B$9,$A$9:$I$13,MATCH(J10,$A$10:$A$13)+1,FALSE)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP($I$9,$A$9:$I$13,MATCH(J10,$A$10:$A$13)+1,FALSE)","v":{"$error":"#N/A"}},"M"]
[2,"Task 2",{"$f":"IF(M11=\"M\",D11,E11)","v":"2015-01-06"},"2015-01-01",{"$f":"L11","v":"2015-01-06"},5,1,{"$f":"F11-G11","v":4},{"$f":"WORKDAY(D11,F11,$B$2:$E$2)","v":"2015-01-09"},1,{"$f":"HLOOKUP($B$9,$A$9:$I$13,MATCH(J11,$A$10:$A$13)+1,FALSE)","v":"Task 1"},{"$f":"HLOOKUP($I$9,$A$9:$I$13,MATCH(J11,$A$10:$A$13)+1,FALSE)","v":"2015-01-06"},"A"]
[4,"Task 3","2015-01-09","2015-01-01","2015-01-09",6,1,5,{"$f":"WORKDAY(D12,F12,$B$2:$E$2)","v":"2015-01-12"},2,{"$f":"HLOOKUP($B$9,$A$9:$I$13,MATCH(J12,$A$10:$A$13)+1,FALSE)","v":"Task 2"},{"$f":"HLOOKUP($I$9,$A$9:$I$13,MATCH(J12,$A$10:$A$13)+1,FALSE)","v":"2015-01-09"},"A"]
[5,"Task 4","2015-01-09","2015-01-01","2015-01-09",6,1,5,{"$f":"WORKDAY(D13,F13,$B$2:$E$2)","v":"2015-01-12"},2,"Task 2","2015-01-09","A"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Note : Don't change the name of the cells or the macro will stop working"]