{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Timeline","About"],"not_rendered":{"charts":1,"images":2,"macros":0,"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":"Timeline","index":0,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"TIMELINE TEMPLATES by Vertex42.com"]
[null,null,null,null,null,null,null,null,null,"https://www.vertex42.com/ExcelTemplates/timeline.html"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Tips for Using this Template"]
[null,null,null,null,null,null,null,null,null,"•  Insert and delete entire rows when editing the data tables"]
[null,null,null,null,null,null,null,null,null,"•  Avoid leaving the label column blank"]
[null,null,null,null,null,null,null,null,null,"•  Format the horizontal axis to set min/max bounds"]
[null,null,null,null,null,null,null,null,null,"•  Enter a vertical position between -100 and 50"]
[null,null,null,null,null,null,null,null,null,"•  Format individual data labels or markers to highlight specific events"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Other Notes"]
[null,null,null,null,null,null,null,null,null,"•  Milestone leader lines are Y Error bars"]
[null,null,null,null,null,null,null,null,null,"•  Task leader lines are Y Error bars"]
[null,null,null,null,null,null,null,null,null,"•  Task durations are X Error bars"]
[]
[]
[]
[]
[]
[]
[]
[]
[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,\"mmm d\")&\" - \"&TEXT(C31,\"mmm d\")","v":"Task 1\nMar 28 - Apr 11"},-25,{"$f":"F31","v":-25}]
[null,{"$f":"C31+1","v":"2018-04-12"},"2018-05-01",20,{"$f":"\"Task 2\"&CHAR(10)&TEXT(B32,\"mmm d\")&\" - \"&TEXT(C32,\"mmm d\")","v":"Task 2\nApr 12 - May 1"},{"$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,\"mmm d\")&\" - \"&TEXT(C33,\"mmm d\")","v":"Task 3\nMay 2 - May 25"},{"$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}]
[null,null,null,null,"Insert new rows above this one"]
[]
[null,"Milestones"]
[null,"Date",null,null,"Label","Position"]
[]
[null,"2018-04-02",null,null,{"$f":"\"Start, \"&TEXT(B45,\"mmm d\")","v":"Start, Apr 2"},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,\"mmm d\")","v":"Deliver, Oct 6"},15]
[null,null,null,null,"Insert new rows above this one"]

{"sheet":"About","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[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 amortization."]
[]
[null,"Businesses will find invoices, time sheets, inventory trackers, financial statements, and project planning templates. Teachers and students will find resources such as class schedules, grade books, and attendance sheets. Organize 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."]