{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Timeline","About"],"not_rendered":{"charts":1,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Timeline","index":0,"n_rows":49,"n_cols":10,"rows_kept":49}
[]
[]
[]
[{"$nulls":9},"TIMELINE TEMPLATES by Vertex42.com"]
[{"$nulls":9},"https://www.vertex42.com/ExcelTemplates/timeline.html"]
[]
[]
[{"$nulls":9},"Tips for using this template"]
[{"$nulls":9},"• Insert and delete entire rows when editing the data tables"]
[{"$nulls":9},"• Avoid leaving the label column blank"]
[{"$nulls":9},"• Format the horizontal axis to set min./max. bounds"]
[{"$nulls":9},"• Enter a vertical position between -100 and 50"]
[{"$nulls":9},"• Format individual data labels or markers to highlight specific events"]
[{"$nulls":9},"• Read cell comments in the table header row for more information"]
[]
[{"$nulls":9},"Other notes"]
[{"$nulls":9},"• Milestone leader lines are Y Error bars"]
[{"$nulls":9},"• Task leader lines are Y Error bars"]
[{"$nulls":9},"• Task durations are X Error bars"]
{"$rows_empty":8}
[null,"Tasks"]
[null,"Start","End","Duration","Label","Vert. Position","Vert. Line"]
[]
[null,"2018-03-28",{"$f":"B31+D31-1","v":"2018-04-11"},15,{"$f":"\"Task 1 \"&CHAR(10)&TEXT(B31,\"d mmm\")&\" - \"&TEXT(C31,\"d mmm\")","v":"Task 1 \n28 Mar - 11 Apr"},-25,{"$f":"F31","v":-25}]
[null,{"$f":"C31+1","v":"2018-04-12"},"2018-05-01",20,{"$f":"\"Task 2 \"&CHAR(10)&TEXT(B32,\"d mmm\")&\" - \"&TEXT(C32,\"d mmm\")","v":"Task 2 \n12 Apr - 1 May"},{"$f":"F31-15","v":-40},{"$f":"F32-F31","v":-15}]
[null,{"$f":"C32+1","v":"2018-05-02"},"2018-05-25",24,{"$f":"\"Task 3 \"&CHAR(10)&TEXT(B33,\"d mmm\")&\" - \"&TEXT(C33,\"d mmm\")","v":"Task 3 \n2 May - 25 May"},{"$f":"F32-15","v":-55},{"$f":"F33-F32","v":-15}]
[null,"2018-04-28","2018-07-12",76,"Task Label 4",-80,{"$f":"F34","v":-80}]
[null,"2018-06-15","2018-07-04",20,"Task Label 5",-30,{"$f":"F35","v":-30}]
[null,{"$f":"C35+1","v":"2018-07-05"},"2018-08-03",30,"Task Label 6",{"$f":"F35-15","v":-45},{"$f":"F36-F35","v":-15}]
[null,"2018-08-10","2018-09-10",32,"Task Label 7",-20,{"$f":"F37","v":-20}]
[null,{"$f":"C37+1","v":"2018-09-11"},"2018-09-15",5,"Task Label 8",-60,{"$f":"F38-F37","v":-40}]
[null,{"$f":"C38+1","v":"2018-09-16"},"2018-10-06",21,"Task Label 9",{"$f":"F38-15","v":-75},{"$f":"F39-F38","v":-15}]
[{"$nulls":4},"Insert new rows above this one"]
[]
[null,"Milestones"]
[null,"Date",null,null,"Label","Position"]
[]
[null,"2018-04-02",null,null,{"$f":"\"Start, \"&TEXT(B45,\"d mmm\")","v":"Start, 2 Apr"},30]
[null,{"$f":"C33","v":"2018-05-25"},null,null,"Milestone 1",25]
[null,{"$f":"C36","v":"2018-08-03"},null,null,"Milestone 2",20]
[null,{"$f":"C39","v":"2018-10-06"},null,null,{"$f":"\"Deliver, \"&TEXT(B48,\"d mmm\")","v":"Deliver, 6 Oct"},15]
[{"$nulls":4},"Insert new rows above this one"]

{"sheet":"About","index":1,"n_rows":19,"n_cols":2,"rows_kept":19}
[]
[null,"PROJECT TIMELINE by Vertex42.com"]
[null,"https://www.vertex42.com/ExcelTemplates/project-timeline.html"]
[]
[]
[null,"About this template"]
[null,"This template uses a scatter chart with data labels and error bars to create a project timeline that shows both milestones and tasks with durations. Unlike a Gantt chart, which shows each task on a separate row, you control the vertical positioning of tasks within the timeline. You can specify the length of the vertical leader line to help show task dependencies."]
[]
[null,"This type of project timeline is mainly useful for a general overview of a project rather than showing a detailed work breakdown structure."]
[]
[null,"More templates"]
[null,"Visit Vertex42.com to download other timeline and project management templates."]
[null,"More timeline templates"]
[null,"More project management templates"]
[]
[null,"About Vertex42"]
[null,"Vertex42.com provides professionally designed spreadsheet templates for business, home and education – most of which are free to download. Their collection includes a variety of calendars, planners and schedules, as well as personal finance spreadsheets for budgeting, debt reduction and loan amortisation."]
[]
[null,"Businesses will find invoices, timesheets, inventory trackers, financial statements and project planning templates. Teachers and students will find resources such as timetables, mark books and registers. Organise your family life with meal planners, checklists and exercise logs. Each template is thoroughly researched, refined and improved over time through feedback from thousands of users."]