ProjectMasterPlan1.xlsx

Sheet1

[Project Name] Project Schedule Gantt Chart Template © 2006-2018 by Vertex42.com.

[Company Name]

Project Start Date 43129.0 Display Week 1 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8

Project Lead 29″ “Jan” “2018 5” “Feb” “2018 12” “Feb” “2018 19” “Feb” “2018 26” “Feb” “2018 5” “Mar” “2018 12” “Mar” “2018 19” “Mar” “2018

29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

WBS

Vertex42: Vertex42:
Work Breakdown Structure
Level 1: 1, 2, 3, …
Level 2: 1.1, 1.2, 1.3, …
Level 3: 1.1.1, 1.1.2, 1.1.3, …
– The WBS uses a formula to control the numbering, but the formulas are different for different levels. Copy and Paste the cells in the WBS column from the examples at the bottom of the worksheet. TASK

Vertex42: Vertex42:
Task Description
Enter the name of each task and sub-task. Use indents for sub-tasks. LEAD

Vertex42: Vertex42:
Task Lead
Enter the name of the Task Lead in this column. START

Vertex42: Vertex42:
Task Start Date
You can manually enter the Start Date for each task or use a formula to create a dependency on a Predecessor. For example, you could enter =enddate+1 to set the Start date to the next calendar day, or =WORKDAY(enddate,1) to set the Start date to the next work day (excluding weekends), where enddate is the cell reference for the End date of the Predecessor task. END

Vertex42.com Templates: Vertex42.com Templates:
End Date:
The End Date is calculated based on the Start Date and the Calendar Days columns. DAYS

Vertex42: Vertex42:
Duration (Calendar Days)
The duration is the number of calendar days for the given task. The duration is calculated as the End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day.
Note: The conditional formatting used to create the gantt chart references this column. % DONE

Vertex42: Vertex42:
Percent Complete
Update the status of this task by entering the percent complete (between 0% and 100%). M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S

1 Product Development –

1.1 Define product requirements Project Manager Mon” “1/29/18 Fri” “2/02/18 5 0%

1.2 Brief product dev. Team Project Manager Mon” “2/05/18 Tue” “2/06/18 2 0%

1.3 Delivery of samples Designer Thu” “2/08/18 Wed” “2/21/18 14 0%

1.4 Evaluation of samples project Manager Thu” “2/01/18 Thu” “2/01/18 0 0%

1.4.1 Fri” “2/02/18 Fri” “2/02/18 0 0%

1.4.2 [Sub-task] Sun” “2/04/18 Sun” “2/04/18 0 0%

1.5 Approve design with SC Project Manager Mon” “2/05/18 Mon” “2/05/18 0 0%

1.6 [Task] Sat” “2/03/18 Sat” “2/03/18 0 0%

1.7 [Task] Sat” “2/10/18 Sat” “2/10/18 0 0%

2 Design development –

2.1 [Task] Sat” “2/10/18 Sat” “2/10/18 0 0%

2.2 [Task] Wed” “2/14/18 Wed” “2/14/18 0 0%

2.3 [Task] Wed” “2/14/18 Wed” “2/14/18 0 0%

2.4 [Task] Sat” “2/17/18 Sat” “2/17/18 0 0%

2.5 [Task] Fri” “2/23/18 Fri” “2/23/18 0 0%

3 Marketing campaing –

3.1 [Task] Sat” “2/10/18 Sat” “2/10/18 0 0%

3.2 [Task] Wed” “2/14/18 Wed” “2/14/18 0 0%

3.3 [Task] Wed” “2/14/18 Wed” “2/14/18 0 0%

3.4 [Task] Sat” “2/17/18 Sat” “2/17/18 0 0%

3.5 [Task] Fri” “2/23/18 Fri” “2/23/18 0 0%

4 Suppluy chain –

4.1 [Task] Mon” “1/29/18 Mon” “1/29/18 0 0%

4.2 [Task] Tue” “1/30/18 Tue” “1/30/18 0 0%

4.3 [Task] Wed” “1/31/18 Wed” “1/31/18 0 0%

4.4 [Task] Thu” “2/01/18 Thu” “2/01/18 0 0%

4.5 [Task] Fri” “2/02/18 Fri” “2/02/18 0 0%

TEMPLATE ROWS

See the Help worksheet to learn how to use these rows. You can hide these rows before printing.

1 [ Level 1 Task or Phase ] –

1.1 . [ Level 2 Task ] –

1.1.1 . . [ Level 3 Task ] –

1.1.1.1 . . . [ Level 4 Task ] –

&”Helvetica Neue,Regular”&12&K000000&P

https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html