{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Basic Plan Tracker ","Guidance Notes","Simple Gantt Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":9,"defined_names":135,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Basic Plan Tracker ","index":0,"n_rows":133,"n_cols":8,"rows_kept":133,"cut":false,"hidden":false,"merged":[[6,6,6,7],[1,0,1,1],[1,2,1,4],[0,0,0,4],[2,0,2,1],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7]]}
["Plan Title:  xxxxxx"]
["Plan Owner :  Name",null,"Version No. xx   Date: xx/xx/xxxx"]
["Progress Update Date: xx/xx/xxxx",null,null,null,null,null,"RAG Definition"]
[null,null,null,null,null,null,"Red - Project shows significant slippage, cost over-run or serious issues."]
[null,null,null,null,null,null,"Amber - Project moving toward significant, but recoverable, cost overrun, slippage and/or significant issues."]
[null,null,null,null,null,null,"Green - Project on track, with no significant cost overrun, slippage or issues."]
[null,null,null,null,null,null,"Blue - Completed"]
[null,null,null,null,null,null,null,"Template V7 Feb 19"]
["Plan Milestones & Tasks"]
[null,"Key Milestones / Tasks"]
[null,"Milestone / Task Title","Owner","Start Date","Finish Date","Agreed Revised Finish Date","RAG","Comments/Notes"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[null,"Work Stream Task Plans"]
[null,"Task description","Owner","Start Date","Finish Date","Agreed Revised Finish Date","RAG","Comments/Notes"]
[1,"Work Stream Title"]
[1.1000000000000001,"Task description","Name",null,null,null,"R"]
[1.2,"Task description","Name",null,null,null,"A"]
[1.3,"Task description","Name",null,null,null,"G"]
[1.4,"Task description","Name",null,null,null,"COMPLETE"]
[1.5,"Task description","Name"]
[1.6,"Task description","Name"]
[1.7,"Task description","Name"]
[1.8,"Task description","Name"]
[1.9,"Task description","Name"]
[1.1000000000000001,"Task description","Name"]
[2,"Work Stream Title"]
[2.1,"Task description","Name"]
[2.2000000000000002,"Task description","Name"]
[2.2999999999999998,"Task description","Name"]
[2.4,"Task description","Name"]
[2.5,"Task description","Name",null,null,null," "]
[2.6,"Task description","Name"]
[2.7,"Task description","Name",null,null,null," "]
[2.8,"Task description","Name",null,null,null," "]
[2.9,"Task description","Name",null,null,null," "]
[2.1,"Task description","Name",null,null,null," "]
[3,"Work Stream Title"]
[3.1,"Task description","Name",null,null,null," "]
[3.2,"Task description","Name",null,null,null," "]
[3.3,"Task description","Name"]
[3.4,"Task description","Name",null,null,null," "]
[3.5,"Task description","Name",null,null,null," "]
[3.6,"Task description","Name",null,null,null," "]
[3.7,"Task description","Name",null,null,null," "]
[3.8,"Task description","Name",null,null,null," "]
[3.9,"Task description","Name",null,null,null," "]
[3.1,"Task description","Name",null,null,null," "]
[4,"Work Stream Title",null,null,null,null," "]
[4.0999999999999996,"Task description","Name",null,null,null," "]
[4.2,"Task description","Name",null,null,null," "]
[4.3,"Task description","Name",null,null,null," "]
[4.4000000000000004,"Task description","Name",null,null,null," "]
[4.5,"Task description","Name",null,null,null," "]
[4.5999999999999996,"Task description","Name",null,null,null," "]
[4.7,"Task description","Name",null,null,null," "]
[4.8,"Task description","Name",null,null,null," "]
[4.9000000000000004,"Task description","Name",null,null,null," "]
[4.0999999999999996,"Task description","Name",null,null,null," "]
[5,"Work Stream Title",null,null,null,null," "]
[5.0999999999999996,"Task description","Name",null,null,null," "]
[5.2,"Task description","Name",null,null,null," "]
[5.3,"Task description","Name",null,null,null," "]
[5.4,"Task description","Name",null,null,null," "]
[5.5,"Task description","Name",null,null,null," "]
[5.6,"Task description","Name",null,null,null," "]
[5.7,"Task description","Name",null,null,null," "]
[5.8,"Task description","Name",null,null,null," "]
[5.9,"Task description","Name",null,null,null," "]
[5.0999999999999996,"Task description","Name",null,null,null," "]
[6,"Work Stream Title",null,null,null,null," "]
[6.1,"Task description","Name",null,null,null," "]
[6.2,"Task description","Name",null,null,null," "]
[6.3,"Task description","Name",null,null,null," "]
[6.4,"Task description","Name",null,null,null," "]
[6.5,"Task description","Name",null,null,null," "]
[6.6,"Task description","Name",null,null,null," "]
[6.7,"Task description","Name",null,null,null," "]
[6.8,"Task description","Name",null,null,null," "]
[6.9,"Task description","Name",null,null,null," "]
[6.1,"Task description","Name",null,null,null," "]
[7,"Work Stream Title",null,null,null,null," "]
[7.1,"Task description","Name",null,null,null," "]
[7.2,"Task description","Name",null,null,null," "]
[7.3,"Task description","Name",null,null,null," "]
[7.4,"Task description","Name",null,null,null," "]
[7.5,"Task description","Name",null,null,null," "]
[7.6,"Task description","Name",null,null,null," "]
[7.7,"Task description","Name",null,null,null," "]
[7.8,"Task description","Name",null,null,null," "]
[7.9,"Task description","Name",null,null,null," "]
[7.1,"Task description","Name",null,null,null," "]
[8,"Work Stream Title",null,null,null,null," "]
[8.1,"Task description","Name",null,null,null," "]
[8.1999999999999993,"Task description","Name",null,null,null," "]
[8.3000000000000007,"Task description","Name",null,null,null," "]
[8.4,"Task description","Name",null,null,null," "]
[8.5,"Task description","Name",null,null,null," "]
[8.6,"Task description","Name",null,null,null," "]
[8.6999999999999993,"Task description","Name",null,null,null," "]
[8.8000000000000007,"Task description","Name",null,null,null," "]
[8.9,"Task description","Name",null,null,null," "]
[8.1,"Task description","Name",null,null,null," "]
[9,"Work Stream Title",null,null,null,null," "]
[9.1,"Task description","Name",null,null,null," "]
[9.1999999999999993,"Task description","Name",null,null,null," "]
[9.3000000000000007,"Task description","Name",null,null,null," "]
[9.4,"Task description","Name",null,null,null," "]
[9.5,"Task description","Name",null,null,null," "]
[9.6,"Task description","Name",null,null,null," "]
[9.6999999999999993,"Task description","Name",null,null,null," "]
[9.8000000000000007,"Task description","Name",null,null,null," "]
[9.9,"Task description","Name",null,null,null," "]
[9.1,"Task description","Name",null,null,null," "]
[10,"Work Stream Title",null,null,null,null," "]
[10.1,"Task description","Name",null,null,null," "]
[10.199999999999999,"Task description","Name",null,null,null," "]
[10.199999999999999,"Task description","Name",null,null,null," "]
[10.4,"Task description","Name",null,null,null," "]
[10.5,"Task description","Name",null,null,null," "]
[10.6,"Task description","Name",null,null,null," "]
[10.7,"Task description","Name",null,null,null," "]
[10.8,"Task description","Name",null,null,null," "]
[10.9,"Task description","Name",null,null,null," "]
[10.1,"Task description","Name",null,null,null," "]

{"sheet":"Guidance Notes","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Guidance Notes For Completing The Plan Tracker"]
[]
["Purpose:","The task tracker has been designed to help you plan, monitor, manage and control changes to be implemented. It can be used for both formal projects and action plans but you may also find it useful for informal changesto be implemented within your team(s).\n\nThe format should help you think about what the key tasks are within the plan and also how tasks can be grouped together as well as clearly setting out who is responsible for implementing the task and when it should be completed by. \n\nIt is important when agreeing task owners and dates that they are agreed with the relevant party as being realistic to achieve."]
["Plan Title:","Please insert the name of the project or action plan so it can be differentiated from other plans."]
["Plan Owner:","This should be the person who is responsible for the plan, ensuring that tasks and owners deliver to the agreed timelines."]
["Version No.","Please ensure a new version is saved when tasks are either added or deleted and if finish dates are revised."]
["Progress Update Date:","Plans should be updated on a regular basis to ensure progress can be monitored.  Once updates on progress have been updated to the plan then record the new progress date in the 'Progress Update Date' box. This does not need to be a new version unless changes are made as stated above."]
["Saving the document:","Please save the plan as 'Plan Title - Version No. - Progress date'  i.e. Transformation team Process Review-V1-Progress date 30.9.22'"]
["Key Milestones / Tasks:","This section is to help you define and monitor the key tasks or stages in the plan. Although all tasks will need to be monitored, it is important that any crtiical stages or tasks can be monitored at a glance e.g. a contract sign off, an HR consultation completion date, a new process or model approved, an IT change implemented, training completed etc."]
["Work Stream Task Plans:","This section is to help you group together tasks to make it easier to monitor. For instance, you may have an HR work stream and under that section you can list all the tasks that need to be completed from an HR perspective.  Although there may be an overall owner for the work stream, tasks may be assigned to a number of different people. "]
["Owner:","This should be the person responsible for implementing the change. "]
["Start Date:","Please enter the date that the task should be started."]
["Finish Date:","Please enter the date that the task should be completed."]
["Agreed Revised Finish Date:","When it has been agreed that the finish date for a task needs to be changed, then a new date should be entered in the box."]
["RAG:","For the definitions of the 'Red, Amber, Green' (RAG) status, please see above the plan.  To make it easier to record the status of RAG (not 'Completed') you only need to enter the first letter and the box will automatically change to the appropriate colour. For instance, if you enter G, the box will change to green. For completed tasks, please update the box to state 'Completed' and shade this as dark green."]
["Comments/Notes:","If required, please enter any important comments or notes that may help you when monitoring the task."]

{"sheet":"Simple Gantt Template","index":2,"n_rows":16,"n_cols":35,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,3,2,4],[3,7,3,13],[3,14,3,20],[3,21,3,27],[3,28,3,34]]}
["TITLE"]
["Company name"]
["Project lead",null,"PROJECT START","2021-04-16"]
[null,null,"Display week",3,null,null,null,{"$f":"H5","v":"2021-04-26"},null,null,null,null,null,null,{"$f":"O5","v":"2021-05-03"},null,null,null,null,null,null,{"$f":"V5","v":"2021-05-10"},null,null,null,null,null,null,{"$f":"AC5","v":"2021-05-17"}]
[null,null,null,null,null,null,null,{"$f":"$D$3-WEEKDAY(project_start,3)+(display_week-1)*7","v":"2021-04-26"},{"$f":"H5+1","v":"2021-04-27"},{"$f":"I5+1","v":"2021-04-28"},"2021-04-29","2021-04-30","2021-05-01","2021-05-02","2021-05-03","2021-05-04","2021-05-05","2021-05-06","2021-05-07","2021-05-08","2021-05-09","2021-05-10","2021-05-11","2021-05-12","2021-05-13","2021-05-14","2021-05-15","2021-05-16","2021-05-17","2021-05-18","2021-05-19","2021-05-20","2021-05-21","2021-05-22","2021-05-23"]
["TASK","Assignee","Progress","START","END","RAG",null,{"$f":"LEFT(TEXT(H5,\"ddd\"),1)","v":"M"},{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"T"},"W","T","F","S","S",{"$f":"LEFT(TEXT(O5,\"ddd\"),1)","v":"M"},{"$f":"LEFT(TEXT(P5,\"ddd\"),1)","v":"T"},"W","T","F","S","S",{"$f":"LEFT(TEXT(V5,\"ddd\"),1)","v":"M"},{"$f":"LEFT(TEXT(W5,\"ddd\"),1)","v":"T"},"W","T","F","S","S",{"$f":"LEFT(TEXT(AC5,\"ddd\"),1)","v":"M"},{"$f":"LEFT(TEXT(AD5,\"ddd\"),1)","v":"T"},"W","T","F","S","S"]
["Phase 1"]
["Task 1.1",null,0.6,"2021-04-26","2021-04-28",{"$f":"IF(ISBLANK(E8),\"\",IF(TODAY()+5<=E8,\"Green\",IF(AND(TODAY()>=E8-5,TODAY()<E8+1),\"Amber\",\"Red\")))","v":"Red"}]
["Task 1.2",null,0.75,"2021-04-28","2021-04-30",{"$f":"IF(ISBLANK(E9),\"\",IF(TODAY()+4<=E9,\"Green\",IF(AND(TODAY()>=E9-4,TODAY()<E9+1),\"Amber\",\"Red\")))","v":"Red"}]
["Task 1.3",null,0.4,"2021-05-04","2021-05-15",{"$f":"IF(ISBLANK(E10),\"\",IF(TODAY()+7<=E10,\"Green\",IF(AND(TODAY()>=E10-7,TODAY()<E10+1),\"Amber\",\"Red\")))","v":"Red"}]
["Task 1.4",null,0.5,"2021-05-17","2021-05-19","Red"]
["Phase 2 ",null,null,null,null,""]
["Task 2.1",null,0.5,"2021-05-20","2021-06-30","Red"]
["Task 2.2",null,0.8,"2021-05-25","2021-06-01","Red"]
["Task 2.3",null,0.9,"2021-05-27","2021-05-31","Red"]
["Task 2.4",null,0.5,"2021-06-01","2021-06-21","Red"]