{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["timeline","backlog","info"],"not_rendered":{"charts":2},"unopened":[{"sheet":"timeline","index":0,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"backlog","index":1,"n_rows":13,"n_cols":142,"rows_kept":13,"merged":[[0,103,0,105],[0,107,0,109],[0,111,0,113],[0,115,0,117],[0,119,0,121],[0,123,0,125],[0,127,0,129],[0,131,0,133],[0,135,0,137],[0,139,0,141]]}
[{"$nulls":103},{"$f":"C2","v":"Activity"},{"$nulls":3},{"$f":"G2","v":"Activity"},{"$nulls":3},{"$f":"K2","v":"Activity"},{"$nulls":3},{"$f":"O2","v":"Activity"},{"$nulls":3},{"$f":"S2","v":"Activity"},{"$nulls":3},{"$f":"W2","v":"Activity"},{"$nulls":3},{"$f":"AA2","v":"Activity"},{"$nulls":3},{"$f":"AE2","v":"Activity"},{"$nulls":3},{"$f":"AI2","v":"Activity"},{"$nulls":3},{"$f":"AM2","v":"Activity"}]
["NN","Deliverables","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %","Activity","Start","Finish","Complete, %",{"$nulls":61},"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color",null,"white","gray","color"]
[1,"Deliverable",0,"2011-05-31",{"$f":"WORKDAY.INTL(D3,C3)","v":"2011-05-31"},{"v":0,"d":"0%"},4,{"$f":"E3","v":"2011-05-31"},{"$f":"WORKDAY.INTL(H3,G3)","v":"2011-06-06"},{"v":0,"d":"0%"},7,{"$f":"I3","v":"2011-06-06"},{"$f":"WORKDAY.INTL(L3,K3)","v":"2011-06-15"},{"v":0,"d":"0%"},6,"2011-06-17",{"$f":"WORKDAY.INTL(P3,O3)","v":"2011-06-27"},{"v":0,"d":"0%"},0,{"$f":"Q3","v":"2011-06-27"},{"$f":"WORKDAY.INTL(T3,S3)","v":"2011-06-27"},{"v":0,"d":"0%"},0,{"$f":"U3","v":"2011-06-27"},{"$f":"WORKDAY.INTL(X3,W3)","v":"2011-06-27"},{"v":0,"d":"0%"},0,{"$f":"Y3","v":"2011-06-27"},{"$f":"WORKDAY.INTL(AB3,AA3)","v":"2011-06-27"},{"v":0,"d":"0%"},5,{"$f":"AC3","v":"2011-06-27"},{"$f":"WORKDAY.INTL(AF3,AE3)","v":"2011-07-04"},{"v":0,"d":"0%"},0,{"$f":"AG3","v":"2011-07-04"},{"$f":"WORKDAY.INTL(AJ3,AI3)","v":"2011-07-04"},{"v":0,"d":"0%"},0,{"$f":"AK3","v":"2011-07-04"},{"$f":"WORKDAY.INTL(AN3,AM3)","v":"2011-07-04"},{"v":0,"d":"0%"},{"$nulls":61},{"$f":"D3","v":"2011-05-31"},{"$f":"(E3-D3)*F3","v":0},{"$f":"(E3-D3)*(1-F3)","v":0},null,{"$f":"H3-E3","v":0},{"$f":"(I3-H3)*J3","v":0},{"$f":"(I3-H3)*(1-J3)","v":6},null,{"$f":"L3-I3","v":0},{"$f":"(M3-L3)*N3","v":0},{"$f":"(M3-L3)*(1-N3)","v":9},null,{"$f":"P3-M3","v":{"v":2,"d":"2.00"}},{"$f":"(Q3-P3)*R3","v":0},{"$f":"(Q3-P3)*(1-R3)","v":10},null,{"$f":"T3-Q3","v":0},{"$f":"(U3-T3)*V3","v":0},{"$f":"(U3-T3)*(1-V3)","v":0},null,{"$f":"X3-U3","v":0},{"$f":"(Y3-X3)*Z3","v":0},{"$f":"(Y3-X3)*(1-Z3)","v":0},null,{"$f":"AB3-Y3","v":0},{"$f":"(AC3-AB3)*AD3","v":0},{"$f":"(AC3-AB3)*(1-AD3)","v":0},null,{"$f":"AF3-AC3","v":0},{"$f":"(AG3-AF3)*AH3","v":0},{"$f":"(AG3-AF3)*(1-AH3)","v":7},null,{"$f":"AJ3-AG3","v":0},{"$f":"(AK3-AJ3)*AL3","v":0},{"$f":"(AK3-AJ3)*(1-AL3)","v":0},null,{"$f":"AN3-AK3","v":0},{"$f":"(AO3-AN3)*AP3","v":0},{"$f":"(AO3-AN3)*(1-AP3)","v":0}]
[2,"Deliverable",0,"2011-06-07",{"$f":"WORKDAY.INTL(D4,C4)","v":"2011-06-07"},{"v":0,"d":"0%"},0,{"$f":"E4","v":"2011-06-07"},{"$f":"WORKDAY.INTL(H4,G4)","v":"2011-06-07"},{"v":0,"d":"0%"},0,{"$f":"I4","v":"2011-06-07"},{"$f":"WORKDAY.INTL(L4,K4)","v":"2011-06-07"},{"v":0,"d":"0%"},4,{"$f":"M4","v":"2011-06-07"},{"$f":"WORKDAY.INTL(P4,O4)","v":"2011-06-13"},{"v":0,"d":"0%"},5,"2011-06-04",{"$f":"WORKDAY.INTL(T4,S4)","v":"2011-06-10"},{"v":0,"d":"0%"},0,{"$f":"U4","v":"2011-06-10"},{"$f":"WORKDAY.INTL(X4,W4)","v":"2011-06-10"},{"v":0,"d":"0%"},6,{"$f":"Y4","v":"2011-06-10"},{"$f":"WORKDAY.INTL(AB4,AA4)","v":"2011-06-20"},{"v":0,"d":"0%"},0,{"$f":"AC4","v":"2011-06-20"},{"$f":"WORKDAY.INTL(AF4,AE4)","v":"2011-06-20"},{"v":0,"d":"0%"},0,{"$f":"AG4","v":"2011-06-20"},{"$f":"WORKDAY.INTL(AJ4,AI4)","v":"2011-06-20"},{"v":0,"d":"0%"},5,{"$f":"AK4","v":"2011-06-20"},{"$f":"WORKDAY.INTL(AN4,AM4)","v":"2011-06-27"},{"v":0,"d":"0%"},{"$nulls":61},{"$f":"D4","v":"2011-06-07"},{"$f":"(E4-D4)*F4","v":0},{"$f":"(E4-D4)*(1-F4)","v":0},null,{"$f":"H4-E4","v":0},{"$f":"(I4-H4)*J4","v":0},{"$f":"(I4-H4)*(1-J4)","v":0},null,{"$f":"L4-I4","v":0},{"$f":"(M4-L4)*N4","v":0},{"$f":"(M4-L4)*(1-N4)","v":0},null,{"$f":"P4-M4","v":0},{"$f":"(Q4-P4)*R4","v":0},{"$f":"(Q4-P4)*(1-R4)","v":6},null,{"$f":"T4-Q4","v":{"v":-9,"d":"(9.00)"}},{"$f":"(U4-T4)*V4","v":0},{"$f":"(U4-T4)*(1-V4)","v":6},null,{"$f":"X4-U4","v":0},{"$f":"(Y4-X4)*Z4","v":0},{"$f":"(Y4-X4)*(1-Z4)","v":0},null,{"$f":"AB4-Y4","v":0},{"$f":"(AC4-AB4)*AD4","v":0},{"$f":"(AC4-AB4)*(1-AD4)","v":10},null,{"$f":"AF4-AC4","v":0},{"$f":"(AG4-AF4)*AH4","v":0},{"$f":"(AG4-AF4)*(1-AH4)","v":0},null,{"$f":"AJ4-AG4","v":0},{"$f":"(AK4-AJ4)*AL4","v":0},{"$f":"(AK4-AJ4)*(1-AL4)","v":0},null,{"$f":"AN4-AK4","v":0},{"$f":"(AO4-AN4)*AP4","v":0},{"$f":"(AO4-AN4)*(1-AP4)","v":7}]
[3,"Deliverable",0,"2011-05-31",{"$f":"WORKDAY.INTL(D5,C5)","v":"2011-05-31"},{"v":0,"d":"0%"},4,"2011-06-08",{"$f":"WORKDAY.INTL(H5,G5)","v":"2011-06-14"},{"v":0,"d":"0%"},0,"2011-06-14",{"$f":"WORKDAY.INTL(L5,K5)","v":"2011-06-14"},{"v":0,"d":"0%"},0,"2011-06-14",{"$f":"WORKDAY.INTL(P5,O5)","v":"2011-06-14"},{"v":0,"d":"0%"},0,{"$f":"Q5","v":"2011-06-14"},{"$f":"WORKDAY.INTL(T5,S5)","v":"2011-06-14"},{"v":0,"d":"0%"},0,"2011-06-14",{"$f":"WORKDAY.INTL(X5,W5)","v":"2011-06-14"},{"v":0,"d":"0%"},0,"2011-06-14",{"$f":"WORKDAY.INTL(AB5,AA5)","v":"2011-06-14"},{"v":0,"d":"0%"},4,"2011-06-14",{"$f":"WORKDAY.INTL(AF5,AE5)","v":"2011-06-20"},{"v":0,"d":"0%"},6,"2011-06-20",{"$f":"WORKDAY.INTL(AJ5,AI5)","v":"2011-06-28"},{"v":0,"d":"0%"},0,"2011-06-28",{"$f":"WORKDAY.INTL(AN5,AM5)","v":"2011-06-28"},{"v":0,"d":"0%"},{"$nulls":61},"2011-05-31",0,0,null,{"v":8,"d":"8.00"},0,6,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,6,null,0,0,8,null,0,0,0]
[4,"Deliverable",0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},9,"2011-05-31","2011-06-13",{"v":0,"d":"0%"},0,"2011-06-13","2011-06-13",{"v":0,"d":"0%"},5,"2011-06-15","2011-06-22",{"v":0,"d":"0%"},8,"2011-06-22","2011-07-04",{"v":0,"d":"0%"},0,"2011-07-04","2011-07-04",{"v":0,"d":"0%"},0,"2011-07-04","2011-07-04",{"v":0,"d":"0%"},0,"2011-07-04","2011-07-04",{"v":0,"d":"0%"},{"$nulls":61},"2011-05-31",0,0,null,0,0,0,null,0,0,0,null,0,0,13,null,0,0,0,null,{"v":2,"d":"2.00"},0,7,null,0,0,12,null,0,0,0,null,0,0,0,null,0,0,0]
[5,"Deliverable",0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},4,"2011-06-06","2011-06-10",{"v":0,"d":"0%"},6,"2011-06-10","2011-06-20",{"v":0,"d":"0%"},0,"2011-06-20","2011-06-20",{"v":0,"d":"0%"},0,"2011-06-20","2011-06-20",{"v":0,"d":"0%"},7,"2011-06-20","2011-06-29",{"v":0,"d":"0%"},0,"2011-06-29","2011-06-29",{"v":0,"d":"0%"},0,"2011-06-29","2011-06-29",{"v":0,"d":"0%"},{"$nulls":61},"2011-05-31",0,0,null,0,0,0,null,0,0,0,null,{"v":6,"d":"6.00"},0,4,null,0,0,10,null,0,0,0,null,0,0,0,null,0,0,9,null,0,0,0,null,0,0,0]
[6,"Deliverable",0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},0,"2011-05-31","2011-05-31",{"v":0,"d":"0%"},6,"2011-06-02","2011-06-10",{"v":0,"d":"0%"},0,"2011-06-10","2011-06-10",{"v":0,"d":"0%"},0,"2011-06-10","2011-06-10",{"v":0,"d":"0%"},0,"2011-06-10","2011-06-10",{"v":0,"d":"0%"},0,"2011-06-10","2011-06-10",{"v":0,"d":"0%"},0,"2011-06-10","2011-06-10",{"v":0,"d":"0%"},4,"2011-06-19","2011-06-23",{"v":0,"d":"0%"},7,"2011-06-23","2011-07-04",{"v":0,"d":"0%"},{"$nulls":61},"2011-05-31",0,0,null,0,0,0,null,{"v":2,"d":"2.00"},0,8,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,{"v":9,"d":"9.00"},0,4,null,0,0,11]
[]
[]
[]
[]
[{"$nulls":102},{"$f":"IF(AM13=\"m\",1,0)","v":0}]

{"sheet":"info","index":2,"n_rows":32,"n_cols":1,"rows_kept":32}
["This Timeline template allows you to create a timeline chart without any other programs and without any previously created Gantt or bar chart only in the base of a filled out backlog."]
[]
["Features, supported by this release:"]
["Duration of task"]
["Start date of task"]
["Finish date of task"]
["For Agile: it’s possible to not use the start and finish dates and to measure task duration in points."]
["Task completion in per cents"]
["Holidays and weekends"]
["All types of links between tasks"]
["Tasks numbers is limited only by Excel"]
["Charts and tables customization according to Excel features without any limits"]
[]
["In the next realizes:"]
["Milestones"]
["Burn down charts"]
["Probabilities in task durations and dates"]
["Automatic links establishment on the base of three-dimensional time scheduling algorithm"]
[]
["In this template each project task defines as a composition of deliverables (objects, products, etc.) and activities (works, actions, etc.). "]
["First you have to enter the names of all project deliverables to the row headers and of all activities – to the columns. "]
[" And then you have to enter the task duration in the cells laying in the intersection of specific rows and columns. "]
["For example, for the task “turbine erection” you have to create the row “turbine” and the column “erection” and then enter the duration of task “turbine erection”"]
[" in the cell in the intersection of “turbine” row and “erection” column."]
[]
["If you want to detail the task information you have to ungroup the backlog columns which belong to chosen task and enter in specific cells start and finish dates and task completion in %."]
[]
["If you want to link tasks you have to link the respective cells of start and finish task dates using Excel formulas."]
[]
["Please note that you have to adjust data labels formatting manually as it requires Excel."]
[]
["This template is based on Three-Dimensional Time Scheduling math model, algorithms and charts. If you want to know more on this concept, please go to my blog with the same name."]