Spreadsheet: 546040d1509816827-help-with-creating-a-gantt-chart-in-excel-gantt-chart-example
Sheet: Sheet1

ID | Action | Status | Workstream | Sub-workstream | Owner | Start date | Target completion date | Comments | 2017-11-13 00:00:00 | 2017-11-27 00:00:00 | 2017-12-11 00:00:00 | 2017-12-25 00:00:00 | 2018-01-08 00:00:00 | 2018-01-22 00:00:00 | 2018-02-05 00:00:00 | 2018-02-19 00:00:00 | 2018-03-05 00:00:00 | 2018-03-19 00:00:00 | 2018-04-02 00:00:00 | 2018-04-16 00:00:00 | 2018-04-30 00:00:00 | 2018-05-14 00:00:00 | 2018-05-28 00:00:00 | 2018-06-11 00:00:00 | 2018-06-25 00:00:00 | 2018-07-09 00:00:00 | 2018-07-23 00:00:00 | 2018-08-06 00:00:00 | 2018-08-20 00:00:00 | 2018-09-03 00:00:00 | 2018-09-17 00:00:00 | 2018-10-01 00:00:00 | 2018-10-15 00:00:00 | 2018-10-29 00:00:00 | 2018-11-12 00:00:00 | 2018-11-26 00:00:00 | 2018-12-10 00:00:00 | 2018-12-24 00:00:00 | 2019-01-07 00:00:00 | 2019-01-21 00:00:00 | 2019-02-04 00:00:00 | 2019-02-18 00:00:00 | 2019-03-04 00:00:00 | 2019-03-18 00:00:00 | 2019-04-01 00:00:00
1 | Planning/setup
1.1 | Task 1 | Open
1.1.1 | Task 1 - subtask 1 | Not started |  |  | SM | 2018-01-01 00:00:00 | 2018-03-30 00:00:00
1.1.2 | Task 1 - subtask 2 | Not started |  |  | SM | 2018-07-01 00:00:00 | 2018-09-29 00:00:00
1.1.3 | Task 1 - subtask 3 | Not started |  |  | RT | 2018-02-01 00:00:00 | 2018-04-28 00:00:00
1.1.4 | Task 1 - subtask 4 | Not started |  |  | RT | 2018-08-01 00:00:00 | 2018-10-27 00:00:00
1.1.5 | Task 1 - subtask 5 | Not started |  |  | MC
1.1.6 | Task 1 - subtask 6 | Not started |  |  | MC
1.1.7 | Task 1 - subtask 7 | Not started |  |  | SM
1.1.8 | Task 1 - subtask 8 | Not started |  |  | SM
1.2 | Task 2 | Open
1.2.1 | Task 2 - subtask 1 | Not started |  |  | SM
1.2.2 | Task 2 - subtask 2 | Not started |  |  | RT
1.2.3 | Task 2 - subtask 3 | Not started |  |  | MC
1.2.4 | Task 2 - subtask 4 | Not started |  |  | SM
1.3 | Task 3 | Not started |  |  | SM | 2018-01-01 00:00:00 | 2018-03-30 00:00:00
1.3.1 | Task 3 - subtask 1 | Not started |  |  | SM | 2019-01-01 00:00:00 | 2019-03-31 00:00:00
1.3.2 | Task 3 - subtask 2 | Not started |  |  | SM | 2018-01-01 00:00:00 | 2018-03-31 00:00:00
1.3.3 | Task 3 - subtask 3 | Not started |  |  | SM | 2018-04-01 00:00:00 | 2018-06-30 00:00:00
1.3.4 | Task 3 - subtask 4 | Not started |  |  | RT | 2018-01-01 00:00:00 | 2018-03-31 00:00:00
1.3.5 | Task 3 - subtask 5 | Not started |  |  | RT | 2018-07-01 00:00:00 | 2018-09-30 00:00:00
1.3.6 | Task 3 - subtask 6 | Not started |  |  | RT | 2018-10-01 00:00:00 | 2018-12-31 00:00:00
1.3.7 | Task 3 - subtask 7 | Not started |  |  | RT | 2018-01-01 00:00:00 | 2018-03-31 00:00:00
1.3.8 | Task 3 - subtask 8 | Not started |  |  | MC | 2018-04-01 00:00:00 | 2018-06-30 00:00:00
1.3.9 | Task 3 - subtask 9 | Not started |  |  | MC | 2018-07-01 00:00:00 | 2018-09-30 00:00:00
1.3.10 | Task 3 - subtask 10 | Not started |  |  | MC | 2018-10-01 00:00:00 | 2018-12-31 00:00:00
2 | Procurement
2.1 |  | Open |  |  | MC | 2017-10-20 00:00:00 | 2017-11-10 00:00:00
2.2 |  | Not started |  |  | MC | 2017-11-13 00:00:00 | 2017-11-20 00:00:00
2.3 |  | Open |  |  | MC
2.4 |  | Open |  |  | MC | 2017-05-01 00:00:00 | ??
2.4.1 |  | Open |  |  | MC
2.4.2 |  | Not started |  |  | MC
2.4.3 |  | Not started |  |  | MC
2.4.4 |  | Not started |  |  | MC
2.4.5 |  | Not started |  |  | MC
2.5 |  | Open |  |  | MC | 2017-05-01 00:00:00 | ??
2.5.1 |  | Open |  |  | MC
2.5.2 |  | Not started |  |  | MC
2.5.3 |  | Not started |  |  | MC
2.5.4 |  | Not started |  |  | MC
2.5.5 |  | Not started |  |  | MC
2.6 |  | Open |  |  | MC | 2017-08-01 00:00:00 | ??
2.6.1 |  | Open |  |  | MC
2.6.2 |  | Not started |  |  | MC
2.6.3 |  | Not started |  |  | MC
2.6.4 |  | Not started |  |  | MC
2.6.5 |  | Not started |  |  | MC
2.6.6 |  | Not started |  |  | MC
2.6.7 |  | Not started |  |  | MC
2.6.8 |  | Not started |  |  | MC
2.6.9 |  | Not started |  |  | MC
2.6.10 |  | Not started |  |  | MC
2.6.11 |  | Not started |  |  | MC
2.6.12 |  | Not started |  |  | MC
2.7 |  | Open |  |  | SM | 2017-08-01 00:00:00 | ??
2.7.1 |  | Not started |  |  | SM
2.7.2 |  | Not started |  |  | SM
2.7.3 |  | Not started |  |  | SM
2.7.4 |  | Not started |  |  | SM
2.7.5 |  | Not started |  |  | SM
2.7.6 |  | Not started |  |  | SM
2.7.7 |  | Not started |  |  | SM
2.7.8 |  | Not started |  |  | SM
2.7.9 |  | Not started |  |  | SM
2.7.10 |  | Not started |  |  | SM
2.7.11 |  | Not started |  |  | SM
2.7.12 |  | Not started |  |  | SM
3 | PMO
3.1 |  | Open |  |  | SM | 2017-08-01 00:00:00 | 2017-11-10 00:00:00
3.2 |  | Closed |  |  | SM | 2017-10-25 00:00:00 | 2017-11-01 00:00:00
3.3 |  | Recurring |  |  | MC
3.4 |  | Recurring |  |  | MC
3.5 |  | Not started |  |  | MC | 2017-11-06 00:00:00 | 2017-11-17 00:00:00
3.6 |  | Recurring |  |  | SM
3.6.1 |  | Closed |  |  | SM | 2017-10-01 00:00:00 | 2017-10-31 00:00:00
3.6.2 |  | Not started |  |  | SM | 2018-05-01 00:00:00 | 2018-05-30 00:00:00
3.6.3 |  | Not started |  |  | SM | 2018-10-01 00:00:00 | 2018-10-31 00:00:00
4 | Governance
4.1 |  | Open |  |  | DM/MC | 2017-10-01 00:00:00 | 2019-03-30 00:00:00
4.1.1 |  | Open |  |  | DM/MC | 2017-10-01 00:00:00 | 2019-03-31 00:00:00
4.1.2 |  | Not started |  |  | DM/MC | TBC
4.1.3 |  | Not started |  |  | DM/MC | TBC
4.1.4 |  | Not started |  |  | DM/MC | TBC
4.2 |  | Not started |  |  | DM/MC | 2017-12-01 00:00:00 | 2019-03-31 00:00:00
4.2.1 |  | Not started |  |  | DM/MC | 2017-12-01 00:00:00 | 2018-01-13 00:00:00
4.2.2 |  | Not started |  |  | DM/MC | TBC
4.2.3 |  | Not started |  |  | DM/MC | TBC
4.2.4 |  | Not started |  |  | DM/MC | TBC
4.3 |  | Not started |  |  | DM/MC | TBC
4.3.1 |  | Not started |  |  | DM/MC | TBC
4.3.2 |  | Not started |  |  | DM/MC | TBC
4.3.3 |  | Not started |  |  | DM/MC | TBC
5 | Outputs
5.1. |  | Open |  |  | SM | 2017-10-18 00:00:00 | 2017-11-18 00:00:00
5.2 |  | Open |  |  | SM | 2017-11-01 00:00:00 | 2017-11-13 00:00:00
5.3 |  | Not started |  |  | MC | 2017-11-01 00:00:00 | 2017-11-13 00:00:00
5.4 |  | Not started |  |  |  | 2017-11-01 00:00:00 | 2017-12-15 00:00:00
5.4.1 |  | Not started |  |  |  | 2017-11-13 00:00:00 | 2017-12-04 00:00:00
5.4.2 |  | Not started |  |  |  | 2017-12-04 00:00:00 | 2017-12-11 00:00:00
5.4.3 |  | Not started |  |  |  | ?? | ??
5.5 |  | Not started |  |  |  | 2017-11-01 00:00:00 | 2017-11-13 00:00:00
5.6 |  | Not started
5.7 |  | Not started
5.8 |  | Not started
5.9 |  | Not started
6 | Commerical
6.1 |  | Open |  |  | MC | 2017-10-14 00:00:00 | 2017-11-08 00:00:00
6.2 |  | Open |  |  | DM | 2017-11-01 00:00:00 | 2018-03-28 00:00:00
6.2.1 |  | Open |  |  | DM | 2017-11-01 00:00:00 | 2017-11-30 00:00:00
6.2.2 |  | Not started |  |  | DM | 2017-12-01 00:00:00 | 2018-01-31 00:00:00
6.2.3 |  | Not started |  |  | DM | 2018-02-01 00:00:00 | 2018-02-28 00:00:00
6.2.4 |  | Not started |  |  | DM | 2018-03-01 00:00:00 | 2018-03-28 00:00:00
6.2.5 |  | Not started |  |  | DM | 2018-04-01 00:00:00 | 2018-04-30 00:00:00
6.3 |  | Not started |  |  | DM
7 | Comms
7.1 |  | Closed |  |  | DM | 2017-10-01 00:00:00 | 2017-10-31 00:00:00
7.2 |  | Closed |  |  | DM | 2017-10-01 00:00:00 | 2017-10-31 00:00:00
7.3 |  | Not started |  |  | DM | 2017-12-01 00:00:00 | 2017-01-30 00:00:00
7.4 |  | Recurring |  |  | DM
7.4.1. |  | Not started |  |  |  | 2018-01-17 00:00:00 | 2018-01-24 00:00:00
7.4.2 |  | Not started |  |  |  | 2018-04-17 00:00:00 | 2018-04-24 00:00:00
7.4.3 |  | Not started |  |  |  | 2018-07-17 00:00:00 | 2018-07-24 00:00:00
7.4.4 |  | Not started |  |  |  | 2018-10-17 00:00:00 | 2018-10-24 00:00:00
7.4.5 |  | Not started |  |  |  | 2018-01-17 00:00:00 | 2018-01-24 00:00:00
7.5 |  | Closed |  |  | DM | 2017-07-01 00:00:00 | 2017-09-09 00:00:00
7.6 |  | Open |  |  | DM | 2017-11-01 00:00:00 | 2017-11-30 00:00:00
7.7 |  | Recurring |  |  | DM
7.7.1 |  | Not started
7.7.2 |  | Not started
7.7.3 |  | Not started
7.8 |  | Not started |  |  | DM | 2017-12-01 00:00:00 | 2018-01-31 00:00:00
7.9 |  | Not started |  |  | DM | 2018-01-01 00:00:00 | 2018-01-28 00:00:00
7.1 |  | Not started |  |  | DM