{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Instructions","Open","Closed","Priority Matrix"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":55,"n_cols":2,"rows_kept":55,"merged":[[0,0,0,26],[4,0,6,26],[11,1,11,26],[13,1,13,26],[15,1,17,26],[19,1,20,26],[22,1,22,26],[24,1,25,26],[27,1,28,26],[30,1,30,26],[32,1,33,26],[35,1,37,26],[39,1,40,26],[42,1,44,26],[46,1,46,26],[48,1,48,26],[52,1,53,26],[54,1,54,26]],"flags":["formulas_cached_only"]}
["Similar to the 5 Ws (who, what, where, when & why), the \"W3\" stands for what, when & who.  The 'P' stands for priority."]
[]
[]
["Purpose:"]
["Use this form to manage all tasks during an improvement initiative.  Use the form as a means to communicate (via email attachment, posting on communication boards, hand-out during meetings) the progress of the improvement initiative to project team members, stakeholders and/or Management."]
[]
[]
[]
[]
["Instructions:"]
["\"Open\" Sheet"]
["1.","In cell C1 enter the team leader's name after the text \"Leader:\"."]
[]
["2.","In cell C2 enter the names of the team members after the text \"Members:\" seperating each with a comma (,)."]
[]
["3.","Under \"Type\" (in cells D3 to D7), replace the \"Enter type '1' here\" text with the name of the category (which a task belongs to).  The categories may need to be pre-determined.  A suggestioon could be the use of the Priority Matrix categories (Don't Do, Major Project, Quick Hit & Gems)."]
[]
[]
[]
["5.","Do not change the contents of G1 to G7.  The cells automatically counts the number of tasks for each particular category and calculates the total number of tasks."]
[]
[]
["6.","In cell H1 enter the team name (can be creative here and have fun) or brief description of the initiative."]
[]
["7.","From cell A9 and on (A10, A11, A12, ect.) enter the task item number starting at 1 and increase sequentially (2, 3, 4, ect.) with each additional task."]
[]
[]
["8.","From cell B9 and on, enter the category type (1, 2, 3, ect., refer to the category types that were previously established) which the task belongs to."]
[]
[]
["9.","For cell C9 and on (C10, C11, C12, ect.), enter a brief description of the task."]
[]
["10.","For cell D9 and on (D10, D11, D12, ect.) enter the person who is responsible for completing the task (or who needs to ensure completion of the task)."]
[]
[]
["11.","For cell E9 and on (E10, E11, E12, ect.) enter the target completion date for the task.  This could be an estimate at the beginning and once the time line is known, update to the necessary date.  Format should be dd-mmm-yy (16-Apr-13)."]
[]
[]
[]
["12.","For cell F9 and on (F10, F11, F12, ect.) enter the revised completion date for the task.  Format should be dd-mmm-yy (16-Apr-13)."]
[]
[]
["13.","For cell G9 and on (G10, G11, G12, ect.) enter the priority of the task ('D' for Don't Do, 'M' for Major Project, 'Q' for Quick hit or 'G' for Gems).  Use the Priority Matrix to prioritize the task.  If the Priority Matrix categories were used as the \"Type\" categories, leave the cell(s) blank."]
[]
[]
[]
["14.","For cell H9 and on (H10, H11, H12, ect.) enter specific details of the task."]
[]
["15.","Upon the completion of tasks, cut and paste task from \"Open\" to \"Close\" sheet."]
[]
[]
["Tip(s)/Rule(s) of Thumb:"]
["•","Continue to number each additional task sequentially.  Resetting the numbering (on completion of earlier tasks) will likely cause confusion if the W3P form is used as a communication tool."]
[]
["•","Tasks which are put on hold (to address at a later date), color the entire row in a shade of grey."]

{"sheet":"Open","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,0,6,1],[0,3,0,5],[0,7,6,7],[1,2,6,2],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5]],"flags":["formulas_cached_only"]}
[null,null,"Leader:","Total Open Tasks:",null,null,0,"TEAM OR INITIATIVE NAME"]
[null,null,"Members:","Type:"]
[{"$nulls":3},"1 = Enter type '1' here",null,null,0]
[{"$nulls":3},"2 = Enter type '2' here",null,null,0]
[{"$nulls":3},"3 = Enter type '3' here",null,null,0]
[{"$nulls":3},"4 = Enter type '4' here",null,null,0]
[{"$nulls":3},"5 = Enter type '5' here",null,null,0]
["Item No.","Type","What\n(Action Item Description)","Who\n(Resource)","When\n(Target Completion Date)","When\n(Revised Completion Date)","Priority\n(D, M, Q, G)","Info\n(Details, Updates, Timing)"]
[1]

{"sheet":"Closed","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"flags":["formulas_cached_only"]}
["Item No.","Type","What\n(Action Item Description)","Who\n(Resource)","When\n(Target Completion Date)","When\n(Revised Completion Date)","Priority\n(D, M, Q, G)","Info\n(Details, Updates, Timing)"]

{"sheet":"Priority Matrix","index":3,"n_rows":31,"n_cols":24,"rows_kept":31,"merged":[[0,4,1,23],[1,1,1,2],[2,0,21,1],[2,4,10,12],[2,15,10,23],[13,4,21,12],[13,15,21,23],[23,1,23,2],[23,23,23,24],[24,4,25,23]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"PRIORITY MATRIX"]
[null,"High"]
["Risk/Cost/Effort",{"$nulls":3},"Don't Do",{"$nulls":10},"Major Project"]
{"$rows_empty":10}
[{"$nulls":4},"Quick Win",{"$nulls":10},"Gems"]
{"$rows_empty":9}
[null,"Low",{"$nulls":21},"High"]
[{"$nulls":4},"Benefit"]
[]
[]
["Tasks which are medium to high in terms of Risk/Cost/Effort and low to medium in terms of Benefit are Don't Dos."]
["Tasks which are medium to high in terms of Risk/Cost/Effort and Benefit are Major Projects."]
["Tasks which are low to medium in terms of Risk/Cost/Effort and Benefit are Quick Wins."]
["Tasks which are low to medium in terms of Risk/Cost/Effort and medium to high in terms of Benefit are Gems."]