Spreadsheet: 622103d1556582789-gantt-chart-with-predecessors-project-schedule
Sheet: Project 

Create a Gantt Chart in this worksheet. Enter title of this project in cell B1.  Legend title is in cell I1. Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions. | Project Title |  |  |  |  |  |  |  |  |  |  |  | Legend:
Enter Company Name in cell B2. A legend is in cells I2 through AC2. |  |  |  |  |  |  |  |  |  |  |  |  | On Track |  |  |  |  | Low Risk |  |  |  |  | [NAME] |  |  |  |  | High Risk |  |  |  |  | Unassigned
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell F3 or allow the sample formula to find the smallest date value from the Gantt Data table.   Project Start Date: label is in cell D3. | Project Lead |  |  |  | Project Start Date: |  | 2019-03-01 00:00:00
A Scrolling Increment is in cell F4.  Months for the dates in row 5 are displayed starting in cells I4 through cell BL4. Do not modify these cells. They are auto updated based on the project start date in cell F3. | [NAME] |  |  |  | Scrolling Increment: |  | 0
Cells I5 through BL5 contain the day number of the month for the Month represented in the cell block above each date cell and are auto calculated. Do not modify these cells. Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule.
This row contains headers for the project schedule that follows below them.  [NAME] from B7 through BL7 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I7 and continues through cell BL7. All project timeline charting is auto generated based on the category, start date and number of days entered in the Milestones table. | Item | Description | Show Name | Category | Assigned To | Progress | Start | End | Precedence | Precedence 2 | # Days
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule.
Enter Project information starting in cell B9 through cell G9.  Sample data is in cells B9 through G33. Enter Milestone Description, select a Category from the drop-down list, assign someone to the item, enter the progress, start date and number of days for the task to start charting. The next instruction is in cell A34. | 1 | Preliminary |  | Main Task
 |  | All Concepts |  | On Track |  | 1 |  |  |  |  | 1
 |  | Vision Board |  | On Track |  | 0 |  |  | 1.1 |  | 1
 |  | Project Documentation |  | On Track |  | 0 |  |  | 1.1 |  | 1
 |  | PER open |  | On Track |  | 0 |  |  | 1.2 | 1.3 | 4
 |  | Production |  | On Track |  | 0 |  |  | 1.4 |  | 110
 |  | Entertainment writing |  | On Track |  | 0 |  |  | 1.5 |  | 42
 | 2 | Area 1 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 3 | Area 2 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 4 | Area 3 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 5 | Area 4 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 6 | Area 5 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 7 | Area 6 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 8 | Area 7 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 9 | Area 8 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 10 | Area 9 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 11 | Area 10 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 12 | Area 11 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 13 | Area 12 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 14 | Area 13 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 15 | Area 14 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 16 | Area 15 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 17 | Area 16 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 18 | Area 17 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 19 | Area 18 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 20 | Area 19 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 21 | Area 20 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 22 | Area 21 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 23 | Area 22 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 24 | Area 23 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 25 | Area 24 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 26 | Area 25 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 27 | Area 26 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 28 | Area 27 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 29 | Area 28 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 30 | Area 29 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 31 | Area 30 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 32 | Area 31 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 33 | Area 32 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 34 | Area 33 |  | Main Task
 |  | Task 1 |  |  |  | 0
 |  | Task 2 |  |  |  | 0
 |  | Task 3 |  |  |  | 0
 |  | Task 4 |  |  |  | 0
 |  | Task 5 |  |  |  | 0
 | 35 | Area 34 |  | Main Task
 |  | Task 1 |  | Goal |  | 0 | 2019-07-08 00:00:00 | 2019-09-03 00:00:00
 |  | Task 2 |  | Low Risk |  | 0 | 2019-09-03 00:00:00 | 2019-09-11 00:00:00
 |  | Task 3 |  | Milestone |  | 0 | 2019-09-11 00:00:00 | 2019-09-11 00:00:00
 |  | Task 4 |  | Milestone |  | 0 | 2019-09-18 00:00:00 | 2019-09-18 00:00:00
This is an empty row |  | Task 5 |  | Milestone |  | 0 | 2019-09-21 00:00:00 | 2019-09-21 00:00:00