Spreadsheet: 471693d1469135768-populate-and-format-data-from-one-tab-to-another-exampledata
Sheet: Data

ID | Milestone  Name | Original Baseline | Baseline Date | Forecast Date | Actual Date
5535550 | Project Start up | 2016-02-01 00:00:00 | 2016-02-01 00:00:00 | 2016-02-01 00:00:00 | 2016-02-01 00:00:00
 | Project Definition Agreed | 2016-05-12 00:00:00 | 2016-05-12 00:00:00 | 2016-05-12 00:00:00 | 2016-05-12 00:00:00
 | Project Closure | 2016-09-16 00:00:00 | 2016-09-16 00:00:00 | 2016-09-16 00:00:00
 | Service Definition 1st [NAME] | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | 2016-06-10 00:00:00
 | Service Model Agreed | 2016-08-26 00:00:00 | 2016-08-26 00:00:00 | 2016-08-26 00:00:00
 | Process completed | 2016-08-26 00:00:00 | 2016-08-26 00:00:00 | 2016-08-26 00:00:00
553569 | [NAME] off | 2016-02-29 00:00:00 | 2016-02-29 00:00:00 | 2016-02-29 00:00:00 | 2016-02-04 00:00:00
 | RG OU created | 2016-02-29 00:00:00 | 2016-02-29 00:00:00 | 2016-02-29 00:00:00 | 2016-02-29 00:00:00
 | Create RG groups | 2016-03-04 00:00:00 | 2016-03-04 00:00:00 | 2016-03-04 00:00:00 | 2016-03-04 00:00:00
 | POC for Users in RG Groups | 2016-03-25 00:00:00 | 2016-03-25 00:00:00 | 2016-03-25 00:00:00 | 2016-03-25 00:00:00
 | Migration of RG Users to be supported by [NAME] into RG OU's | 2016-07-15 00:00:00 | 2016-07-15 00:00:00 | 2016-07-15 00:00:00
 | Install and Configure Infrastructure Servers | 2016-07-29 00:00:00 | 2016-08-19 00:00:00 | 2016-08-19 00:00:00
 | Customer acceptance of [NAME] | 2016-08-15 00:00:00 | 2016-08-26 00:00:00 | 2016-08-26 00:00:00
 | Project Closure | 2016-09-09 00:00:00 | 2016-09-09 00:00:00 | 2016-09-09 00:00:00
553568 | Requirements signed off | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00
 | MPRG Circuit delivered | 2016-06-15 00:00:00 | 2016-07-29 00:00:00 | 2016-07-29 00:00:00
 | LAN commisioned (BRCD) | 2016-07-15 00:00:00 | 2016-08-15 00:00:00 | 2016-08-15 00:00:00
 | Network kit installed in Merthyr and commisioned | 2016-07-22 00:00:00 | 2016-08-19 00:00:00 | 2016-08-19 00:00:00
 | Customer Acceptance of Deliverables | 2016-06-30 00:00:00 | 2016-08-19 00:00:00 | 2016-08-19 00:00:00
 | Project Closure | 2016-07-11 00:00:00 | 2016-09-02 00:00:00 | 2016-09-02 00:00:00
553403 | Initiation - resouring and finance | 2016-06-13 00:00:00 | 2016-06-13 00:00:00 | 2016-06-13 00:00:00 | 2016-06-13 00:00:00
 | End - initiation resouring and finance | 2016-05-20 00:00:00 | 2016-05-20 00:00:00 | 2016-05-20 00:00:00 | 2016-05-21 00:00:00
 | Application categorisation | 2016-05-20 00:00:00 | 2016-05-20 00:00:00 | 2016-05-20 00:00:00 | 2016-05-27 00:00:00
 | Start - app investigation SME to contact vendor | 2016-06-03 00:00:00 | 2016-06-03 00:00:00 | 2016-06-03 00:00:00 | 2016-06-03 00:00:00
 | End - application investigation SME to contact vendors | 2016-06-17 00:00:00 | 2016-06-17 00:00:00 | 2016-07-31 00:00:00
 | Start - issue new certificates CRITICAL APPS | 2016-06-24 00:00:00 | 2016-06-24 00:00:00 | 2016-06-24 00:00:00 | 2016-07-11 00:00:00
 | End - issue new certificates CRITICAL APPS | 2016-07-10 00:00:00 | 2016-07-10 00:00:00 | 2016-07-31 00:00:00
 | Project closure | 2016-07-17 00:00:00 | 2016-07-17 00:00:00 | 2016-09-30 00:00:00
 | Start - issue new certificates OTHER APPS | 2016-07-25 00:00:00 | 2016-07-25 00:00:00 | 2016-07-25 00:00:00
 | End - issue new certificates OTHER APPS | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00
553402 | [NAME] meeting | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-07-14 00:00:00
 | Start - Good Tier 1 design | 2016-05-07 00:00:00 | 2016-06-07 00:00:00 | 2016-07-18 00:00:00 | 2016-07-18 00:00:00
 | End - Good Tier 1 design | 2016-07-12 00:00:00 | 2016-06-26 00:00:00 | 2016-08-09 00:00:00
 | Planning & resourcing complete | 2016-06-07 00:00:00 | 2016-06-07 00:00:00 | 2016-07-29 00:00:00
 | Start env build | 2016-08-16 00:00:00 | 2016-08-16 00:00:00 | 2016-08-16 00:00:00
 | End env build | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-08-30 00:00:00
 | Start - testing | 2016-09-05 00:00:00 | 2016-09-05 00:00:00 | 2016-09-05 00:00:00
 | End - testing | 2016-09-12 00:00:00 | 2016-09-12 00:00:00 | 2016-09-12 00:00:00
 | PI / ORR - Service Acceptance | 2016-09-17 00:00:00 | 2016-09-17 00:00:00 | 2016-09-17 00:00:00
 | Project closure | 2016-10-01 00:00:00 | 2016-10-01 00:00:00 | 2016-10-01 00:00:00
553399 | Documentation Complete | 2016-08-03 00:00:00 | 2016-08-03 00:00:00 | 2016-08-03 00:00:00
 | POC Ready for Pilot | 2016-08-03 00:00:00 | 2016-08-03 00:00:00 | 2016-08-03 00:00:00
 | Pilot Complete | 2016-08-25 00:00:00 | 2016-08-25 00:00:00 | 2016-08-25 00:00:00
 | Production Hardware complete ready for Go/No Go Decision | 2016-10-20 00:00:00 | 2016-10-21 00:00:00 | 2016-10-21 00:00:00
 | Commence AnyConnect Deployment | 2016-10-26 00:00:00 | 2016-10-26 00:00:00 | 2016-10-26 00:00:00
 | Decommissioning Complete | 2016-12-08 00:00:00 | 2016-12-06 00:00:00 | 2016-12-06 00:00:00
 | [NAME] | 2016-12-15 00:00:00 | 2016-12-15 00:00:00 | 2016-12-15 00:00:00
 | Go Live Complete | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00
55255055 | Workshop | 2016-03-17 00:00:00 | 2016-03-17 00:00:00 | 2016-04-11 00:00:00 | 2016-04-11 00:00:00
 | Engage PTC Consultant | 2016-04-15 00:00:00 | 2016-04-15 00:00:00 | 2016-05-13 00:00:00 | 2016-05-09 00:00:00
 | Start - Build new environment | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2016-07-11 00:00:00 | 2016-07-18 00:00:00
 | End - Build new environment | 2016-07-14 00:00:00 | 2016-07-14 00:00:00 | 2016-07-20 00:00:00 | 2016-07-18 00:00:00
 | Start - PTC install and test application in new env | 2016-07-14 00:00:00 | 2016-07-14 00:00:00 | 2016-07-25 00:00:00
 | Start PTC install and test in PTC cloud | 2016-06-01 00:00:00 | 2016-06-01 00:00:00 | 2016-06-01 00:00:00 | 2016-06-24 00:00:00
 | Testing | 2016-07-21 00:00:00 | 2016-07-21 00:00:00 | 2016-07-21 00:00:00
 | Add new configuration to implementation | 2016-07-25 00:00:00 | 2016-07-25 00:00:00 | 2016-07-25 00:00:00
 | Project Closure | 2016-08-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-05 00:00:00
 | Start - onsite install | 2016-07-18 00:00:00 | 2016-07-18 00:00:00 | 2016-07-25 00:00:00
 | End - onsite install | 2016-08-19 00:00:00 | 2016-08-19 00:00:00 | 2016-08-19 00:00:00
5525506 | Plan & assign resources | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2016-01-29 00:00:00 | 2016-01-29 00:00:00
 | Test Sunv compatible | 2016-04-28 00:00:00 | 2016-04-28 00:00:00 | 2016-04-28 00:00:00 | 2016-04-28 00:00:00
 | Build server | 2016-04-21 00:00:00 | 2016-04-21 00:00:00 | 2016-04-21 00:00:00 | 2016-04-21 00:00:00
 | Test server | 2016-04-28 00:00:00 | 2016-04-28 00:00:00 | 2016-04-28 00:00:00 | 2016-04-28 00:00:00
 | Acceptance | 2016-05-02 00:00:00 | 2016-07-08 00:00:00 | 2016-07-22 00:00:00
 | Ship to Turin | 2016-05-13 00:00:00 | 2016-05-13 00:00:00 | 2016-06-30 00:00:00 | 2016-06-21 00:00:00
 | Project Closure | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-07-29 00:00:00
550415 | Global testing of the Dylan Solution | 2015-11-26 00:00:00 | 2015-11-26 00:00:00 | 2015-11-26 00:00:00 | 2015-11-26 00:00:00
 | Project Closure | 2015-11-30 00:00:00 | 2016-06-17 00:00:00 | 2016-07-29 00:00:00
 | Additional rules implemented | 2015-11-19 00:00:00 | 2015-11-19 00:00:00 | 2015-11-19 00:00:00 | 2015-11-18 00:00:00
 | Resolution of any issues identified during Global Testing | 2015-12-17 00:00:00 | 2015-12-17 00:00:00 | 2015-12-17 00:00:00 | 2015-12-11 00:00:00
 | UK whiteboard & ppt testing | 2015-12-15 00:00:00 | 2016-05-13 00:00:00 | 2016-05-13 00:00:00 | 2016-05-12 00:00:00