Career Development Plan
Aarav02
project-timeline_ms.xlsxTimeline
| TIMELINE TEMPLATES by Vertex42.com | |||||||||
| https://www.vertex42.com/ExcelTemplates/timeline.html | |||||||||
| © 2018 Vertex42 LLC | |||||||||
| Tips for Using this Template | |||||||||
| • Insert and delete entire rows when editing the data tables | |||||||||
| • Avoid leaving the label column blank | |||||||||
| • Format the horizontal axis to set min/max bounds | |||||||||
| • Enter a vertical position between -100 and 50 | |||||||||
| • Format individual data labels or markers to highlight specific events | |||||||||
| • Read cell comments in the table header row for more information | |||||||||
| Other Notes | |||||||||
| • Milestone leader lines are Y Error bars | |||||||||
| • Task leader lines are Y Error bars | |||||||||
| • Task durations are X Error bars | |||||||||
| Tasks | |||||||||
| Start Vertex42.com Templates: Start Date: You can manually enter the Start Date, or you can use a formula to start a task the day after the completion of a previous task such as =end_date+1 | End Vertex42.com Templates: End Date: You can manually enter the End Date, or you can calculate the End Date from the Start Date and Duration using the formula =start_date+duration-1. | Duration Vertex42.com Templates: Task Duration: To show the duration of a task as a horizontal bar, enter the number of days in this column. Leave the column blank if you do not want to display durations. If you enter the End Date, you can calculate the Duration using the formula =end_date-start_date+1. | Label Vertex42.com Templates: Labels: The data labels used in the chart refer to this column. Text wrapping within data labels is difficult to control, but you can force a new line within the text by pressing Alt+Enter while typing in a cell to enter a carriage return. | Vert. Position Vertex42.com Templates: Vertical Position: Edit the vertical position of each task to avoid overlap. To use a different vertical scale, format the vertical axis to adjust the Minimum and Maximum bounds. | Vert. Line Vertex42.com Templates: Vertical Line: Defines the length of the vertical leader line for each task. To extend the leader line all the way to the horizontal axis, set the vertical line length equal to the vertical position. To extend the leader line to the previous task, set the vertical line length equal to the vertical position minus the vertical position of the previous task. |
||||
|
Vertex42.com Templates: Start Date: You can manually enter the Start Date, or you can use a formula to start a task the day after the completion of a previous task such as =end_date+1 |
Vertex42.com Templates: End Date: You can manually enter the End Date, or you can calculate the End Date from the Start Date and Duration using the formula =start_date+duration-1. |
Vertex42.com Templates: Task Duration: To show the duration of a task as a horizontal bar, enter the number of days in this column. Leave the column blank if you do not want to display durations. If you enter the End Date, you can calculate the Duration using the formula =end_date-start_date+1. | 2/18/18 | 3/9/18 | 20 | Task 1 Feb 18 - Mar 9 | -50 | -50 | |
| 3/10/18 | 4/8/18 | 30 | Task 2 Mar 10 - Apr 8 | -65 | -15 | ||||
| 4/9/18 | 5/2/18 | 24 | Task 3 Apr 9 - May 2 | -80 | -15 | ||||
| 4/1/18 | 6/15/18 | 76 | Task Label 4 | -30 | -30 | ||||
| 6/1/18 | 7/5/18 | 35 | Task Label 5 | -60 | -60 | ||||
| 7/6/18 | 7/20/18 | 15 | Task Label 6 | -75 | -15 | ||||
| 8/1/18 | 9/1/18 | 32 | Task Label 7 | -40 | -40 | ||||
| 9/2/18 | 9/6/18 | 5 | Task Label 8 | -55 | -15 | ||||
| 9/7/18 | 9/27/18 | 21 | Task Label 9 | -70 | -15 | ||||
| Insert new rows above this one | |||||||||
| Milestones | |||||||||
| Date | Label | Position | |||||||
| 2/15/18 | Start, Feb 15 | 30 | |||||||
| 5/1/18 | Milestone #1 | 20 | |||||||
| 7/1/18 | Milestone #2 | 20 | |||||||
| 10/1/18 | Deliver, Oct 1 | 30 | |||||||
| Insert new rows above this one |
[Project Timeline Title]
Tasks
[CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] 20 30 24 76 35 15 32 5 21 1 0 -50 -15 -15 -30 -60 -15 -40 -15 -15 43149 43169 43199 43191 43252 43287 43313 43345 43350 -50 -65 -80 -30 -60 -75 -40 -55 -70 Task 1 Feb 18 - Mar 9 Task 2 Mar 10 - Apr 8 Task 3 Apr 9 - May 2 Task Label 4 Task Label 5 Task Label 6 Task Label 7 Task Label 8 Task Label 9 Insert new rows above this one Milestones [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] 43146 43221 43282 43374 30 20 20 30 Start, Feb 15 Milestone #1 Milestone #2 Deliver, Oct 1 Insert new rows above this one https://www.vertex42.com/ExcelTemplates/timeline.html?utm_source=v42&utm_medium=file&utm_campaign=templates&utm_term=project-timeline_ms&utm_content=url https://www.vertex42.com/ExcelTemplates/timeline.html?utm_source=v42&utm_medium=file&utm_campaign=templates&utm_term=project-timeline_ms&utm_content=title
About
| PROJECT TIMELINE by Vertex42.com | |
| https://www.vertex42.com/ExcelTemplates/project-timeline.html | |
| © 2018 Vertex42 LLC | |
| About This Template | |
| 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. | |
| This type of project timeline is mainly useful for a general overview of a project rather than showing a detailed work breakdown structure. | |
| More Templates | |
| Visit Vertex42.com to download other timeline and project management templates. | |
| More Timeline Templates | |
| More Project Management Templates | |
| About Vertex42 | |
| 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. | |
| 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. |
