Spreadsheet: 828036d1683199998-gantt-chart-gantt-chart
Sheet: ProjectSchedule

Create a Project Schedule in this worksheet. Enter title of this project in cell B1.  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
Enter Company Name in cell B2.
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Project Start: label is in cell [NAME]. |  |  | [NAME]: |  |  |  |  |  |  |  |  | PROJECT Duration: |  |  |  |  |  |  | Weeks
Cells I5 through BL5 contain the day number for the week represented in the cell block above each date cell and are auto calculated. You should 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.
 | TASK / ITEM | Description | START | END | Duration | Days Complete | Progress |  | DAYS |  | 2023-03-29 00:00:00 | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 | 2023-04-01 00:00:00 | 2023-04-02 00:00:00 | 2023-04-03 00:00:00 | 2023-04-04 00:00:00 | 2023-04-05 00:00:00 | 2023-04-06 00:00:00 | 2023-04-07 00:00:00 | 2023-04-08 00:00:00 | 2023-04-09 00:00:00 | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2023-04-12 00:00:00 | 2023-04-13 00:00:00 | 2023-04-14 00:00:00 | 2023-04-15 00:00:00 | 2023-04-16 00:00:00 | 2023-04-17 00:00:00 | 2023-04-18 00:00:00 | 2023-04-19 00:00:00 | 2023-04-20 00:00:00 | 2023-04-21 00:00:00 | 2023-04-22 00:00:00 | 2023-04-23 00:00:00 | 2023-04-24 00:00:00 | 2023-04-25 00:00:00 | 2023-04-26 00:00:00 | 2023-04-27 00:00:00 | 2023-04-28 00:00:00 | 2023-04-29 00:00:00 | 2023-04-30 00:00:00 | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00 | 2023-05-06 00:00:00 | 2023-05-07 00:00:00 | 2023-05-08 00:00:00 | 2023-05-09 00:00:00 | 2023-05-10 00:00:00 | 2023-05-11 00:00:00 | 2023-05-12 00:00:00 | 2023-05-13 00:00:00 | 2023-05-14 00:00:00 | 2023-05-15 00:00:00 | 2023-05-16 00:00:00 | 2023-05-17 00:00:00 | 2023-05-18 00:00:00 | 2023-05-19 00:00:00 | 2023-05-20 00:00:00 | 2023-05-21 00:00:00 | 2023-05-22 00:00:00 | 2023-05-23 00:00:00 | 2023-05-24 00:00:00 | 2023-05-25 00:00:00 | 2023-05-26 00:00:00 | 2023-05-27 00:00:00 | 2023-05-28 00:00:00 | 2023-05-29 00:00:00 | 2023-05-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-01 00:00:00 | 2023-06-02 00:00:00 | 2023-06-03 00:00:00 | 2023-06-04 00:00:00 | 2023-06-05 00:00:00 | 2023-06-06 00:00:00 | 2023-06-07 00:00:00 | 2023-06-08 00:00:00 | 2023-06-09 00:00:00 | 2023-06-10 00:00:00 | 2023-06-11 00:00:00 | 2023-06-12 00:00:00 | 2023-06-13 00:00:00 | 2023-06-14 00:00:00 | 2023-06-15 00:00:00 | 2023-06-16 00:00:00 | 2023-06-17 00:00:00 | 2023-06-18 00:00:00 | 2023-06-19 00:00:00 | 2023-06-20 00:00:00
Cell B8 contains the Phase 1 sample title.  Enter a new Title in cell B8. Enter a name to assign the phase to, if it applies for your project, in cell C8. Enter Progress for the entire phase, if it applies for your project, in cell D8. Enter the start and end dates for the entire phase, if it applies for your project, in cells E8 and F8.  The [NAME] chart will automatically fill in the appropriate dates and shade according to the progress entered. To delete the phase and work only from tasks, simply delete this row. | Site Setup | Site Setup | 2023-03-28 00:00:00 |  | 9 | 0
 | Hoarding | Site perimeter | 2023-03-28 00:00:00 |  | 7 | 0
Cell B9 contains the sample task "Task 1."  Enter a new task name in cell B9. Enter a person to assign the task to in cell C9. Enter progress of the task in cell D9. A progress bar appears in the cell and is shaded according to the number in the cell. For example, 50 percent progress would shade half of the cell. Enter task start date in cell E9. Enter task end date in cell F9. A status bar shaded for the dates entered appears in blocks starting from cell I9 through [NAME]. | Wellfare | Wellfare  Units | 2023-04-06 00:00:00 |  | 2 | 0
 | Elec | Disconnection | 2023-04-05 00:00:00 |  | 1 | 0
Rows 10 through 13 repeat the pattern from row 9.  Repeat the instructions from cell A9 for all task rows in this worksheet. Overwrite any sample data. A sample of another phase starts in cell A14.  Continue entering tasks in cells A10 through A13 or go to cell A14 to learn more. | Strip Out Grd Floor | BTN | 2023-04-10 00:00:00 |  | 12 | 0
 | 11.1 | Remove Ceilings | 2023-04-17 00:00:00 |  | 10 | 0
 | 11.2 | Remove P/B Ceilings | 2023-04-28 00:00:00 |  | 4 | 0
 | 11.4 | Remove Damaged Palster | 2023-05-02 00:00:00 |  | 4 | 0
 | 11.6 | Remove GF Intenal Partitions | 2023-04-17 00:00:00 |  | 10 | 0
 | 11.7 | [NAME] | 2023-04-10 00:00:00 |  | 2 | 0
 | 11.13 | Strip out of M & E | 2023-04-24 00:00:00 |  | 5 | 0
 | 11.14 | Access for Structural Inspection | 2023-04-17 00:00:00 |  | 10 | 0
 | Strip Out First Floor | BTN | 2023-05-22 00:00:00 |  | 5 | 0
 | 11.5 | Remove FF Intenal Partitions | 2023-05-22 00:00:00 |  | 3 | 0
 | 11.9 | Remove FF Stair Case | 2023-05-24 00:00:00 |  | 1 | 0
 | 11.8 | Remove Raised Floor FF | 2023-05-24 00:00:00 |  | 3 | 0
 | [NAME] | BTN | 2023-05-04 00:00:00 |  | 17 | 0
 | 11.1.0 | Remove Aircon Units | 2023-04-28 00:00:00 |  | 5 | 0
 | 11.11 | Remove Slate Roof | 2023-05-09 00:00:00 |  | 4 | 0
 | 11.12 | Replace lock to window | 2023-05-04 00:00:00 |  | 1 | 0
Sample phase title block | 12.4 | Install Lean to Roof Timbers | 2023-05-15 00:00:00 |  | 3 | 0
Sample phase title block | 13.16 / 13.17 | [NAME] too | 2023-05-17 00:00:00 |  | 8 | 0
Sample phase title block | 13.18 / 13.19 | Install Rainwater Goods | 2023-05-26 00:00:00 |  | 1 | 0
Sample phase title block | 13.2 | Repalce Lightwell Flat Roof | 2023-05-17 00:00:00 |  | 8 | 0
 | Structural Works | BTN / Beal | 2023-05-02 00:00:00 |  | 14 | 0
Sample phase title block | 12.1 | Propping | 2023-05-02 00:00:00 |  | 4 | 0
Sample phase title block | 12.2 | [NAME] | 2023-05-09 00:00:00 |  | 4 | 0
Sample phase title block | 12.3 | Install Timber Joists | 2023-05-15 00:00:00 |  | 5 | 0
Sample phase title block | 12.5 | Replace Steel to lean to | 2023-05-09 00:00:00 |  | 4 | 0
 | Reinstatement | BTN | 2023-05-30 00:00:00 |  | 10 | 0
Sample phase title block | 13.1 | Timber Stair Case to FF | 2023-05-30 00:00:00 |  | 2 | 0
Sample phase title block | 13.15 | Fire boards to Ceiling | 2023-05-30 00:00:00 |  | 10 | 0
Sample phase title block | 14.1 | Repair Concrete Floor | 2023-06-05 00:00:00 |  | 3 | 0
 | 14.2 / 15.1 | Repair loose plaster 2nd / 3rd Flr | 2023-05-30 00:00:00 |  | 3 | 0
 | Handover | BTN / Client | 2023-06-12 00:00:00 |  | 5 | 0
 | 15.1.0 | Thouroughly Clean | 2023-06-12 00:00:00 |  | 3 | 0
 | Clear Site | Clear Welfare | 2023-06-13 00:00:00 |  | 2 | 0
 | Handover | [NAME] | 2023-06-15 00:00:00 |  | 1 | 0
This is an empty row