{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","About","Categories","Organisational Readiness Qs","People Readiness Qs","Process Readiness Qs","Technology Readiness Qs","Report","Definitions","Change Readiness Questions","Working"],"not_rendered":{"charts":5,"images":3,"macros":1,"external_links":0,"defined_names":48,"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":"1904"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"The Change Readiness Assessor helps you to objectively assess your readiness and help to ensure that your change will be a success.  "]
[null,"Please enable macros before you start to complete the assessor."]
[]
[]
[null,"Using the Assessor\nThe Assessor is driven from the Categories sheet.\n\nTo start a new change project:\n• In the Categories worksheet press the \"New Project\" button and enter your change project’s name and optionally a description.\n\nTo answer questions\n• To update your answers follow the hyperlinks from the Categories tab and answer as many questions as are relevant to your project.\nEach answer will affect the rating for that particular area and the overall readiness rating across the four areas. You need to answer all questions or mark as Not Relevant to complete the Category RAGs and corrective actions. If a question is marked as not relevant this does not affect the Assessor ratings.\n\nTo clear the answers for one of the four sets of questions:\n• In the question worksheet press the \"Clear Answers\" button.\n\nTo produce a change project report\n• In the Categories worksheet press the \"Report\" button. From here you can print your report using the standard Excel functionality.\n\nSaving your results:\n• Once you have completed your assessment you should save the Excel spreadsheet. One excel spreadsheet corresponds to a single project assessment."]
[]
[]
[]
[]
[]
[null,"This has been produced with the assistance of www.bestoutcome.com © 2014 Copyright Bestoutcome Ltd.  "]

{"sheet":"About","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Are you about to implement some new ways-of-working into your business and need to be certain that everybody is ready for them? Do you need to ensure that any impact on customers, staff, stakeholders, processes, technology and current levels of service will be minimised during transition to the new ways-of-working?\n\nThe Change Readiness Assessor has been developed to replace individual surveys and create a coordinated assessment of the progress of your project at any time throughout its lifespan.  It identifies priorities and recommends corrective actions to be taken."]
[]
[null,"The Change Readiness Assessor gives you:\n• an overall rating of the readiness of the business to implement this change\n• a detailed rating for the four key areas of organisational readiness, people readiness, process readiness and technology readiness\n• recommended Corrective Actions to effectively increase your readiness for the change\n• options to print or e-mail the report to colleagues\n\nThe overall rating indicates the readiness of the business to implement this change, and to ensure that any impact of the new ways-of-working on customers, staff, stakeholders, processes, technology and current levels of service will be minimised during transition.\n\nThe Assessor holds the results for a single change project and you can revise your rating at any time during a project’s life. It contains a set of questions sub-divided into four key areas:\n• Organisational Readiness : the readiness of the organisation to move to the new ways-of-working, and assurance that senior management are committed to making it happen\n• People Readiness : the readiness of the organisation's people to embrace the new ways-of-working, and assurance that they will be supported during the transition\n• Process Readiness : the readiness of the new ways-of-working (processes and procedures) to be implemented, and assurance that they are sustainable\n• Technology Readiness : the readiness of the new technology (hardware and software) to be deployed, and assurance that the technical environment can accommodate it\n\nThe questions and corrective actions have been devised by Bestoutcome’s project and programme management practitioners based on their extensive experience of both delivering and independently reviewing change projects and programmes."]
[]
[null,"The contents of this Assessor are not intended to amount to advice on which reliance should be placed. Accordingly, Bestoutcome disclaims, to the fullest extent permitted by law, all liability and responsibility arising from any reliance placed on such materials by any user and all direct, indirect, special, incidental, consequential or punitive damages arising from any use of this application or data contained herein are disclaimed and excluded."]

{"sheet":"Categories","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[11,2,12,2],[11,3,12,3],[5,2,6,2],[5,3,6,3],[13,2,14,2],[13,3,14,3],[7,2,8,2],[7,3,8,3],[9,2,10,2],[9,3,10,3]]}
[]
[null,"Project Name:"]
[null,"Project Description:"]
[null,"Date of Assessment:",null,"2014-04-06T22:01:36"]
[null,"Category","RAG","Corrective Action"]
[null,"Overall",{"$f":"Working!Q2","v":"N"},{"$f":"Working!J2","v":"Not relevant"}]
[null,{"$f":"Definitions!C5","v":"The readiness of the business to implement this change, and to ensure that any impact of the new ways-of-working will be minimised during transition"}]
[null,"Organisational readiness",{"$f":"Working!Q3","v":"N"},{"$f":"Working!J3","v":"Not relevant"}]
[null,{"$f":"Definitions!C6","v":"The readiness of the organisation to move to the new ways-of-working, and assurance that senior management are committed to making it happen"}]
[null,"People readiness",{"$f":"Working!Q5","v":"N"},{"$f":"Working!J5","v":"Not relevant"}]
[null,{"$f":"Definitions!C7","v":"The readiness of the organisation's people to embrace the new ways-of-working, and assurance that they will be supported during the transition"}]
[null,"Process readiness",{"$f":"Working!Q7","v":"N"},{"$f":"Working!J7","v":"Not relevant"}]
[null,{"$f":"Definitions!C8","v":"The readiness of the new processes and procedures to be implemented, and assurance that they are sustainable"}]
[null,"Technology readiness",{"$f":"Working!Q9","v":"N"},{"$f":"Working!J9","v":"Not relevant"}]
[null,{"$f":"Definitions!C9","v":"The readiness of the new technology (hardware and software) to be deployed, and assurance that the technical environment can accommodate it"}]

{"sheet":"Organisational Readiness Qs","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"No.","Question","RAG","Answer"]
[null,1,{"$f":"'Change Readiness Questions'!C2","v":"Do you have an overall vision for change ?"},{"$f":"Working!G16","v":"N"},"Not Relevant"]
[null,2,{"$f":"'Change Readiness Questions'!C3","v":"Is there a proven track record of successful business change ?"},{"$f":"Working!G17","v":"N"},"Not Relevant"]
[null,3,{"$f":"'Change Readiness Questions'!C4","v":"Has the purpose of this change been clearly articulated ?"},{"$f":"Working!G18","v":"N"},"Not Relevant"]
[null,4,{"$f":"'Change Readiness Questions'!C5","v":"Does the sponsor consistently give active support to this change ?"},{"$f":"Working!G19","v":"N"},"Not Relevant"]
[null,5,{"$f":"'Change Readiness Questions'!C6","v":"Is senior management committed to making this change happen ?"},{"$f":"Working!G20","v":"N"},"Not Relevant"]
[null,6,{"$f":"'Change Readiness Questions'!C7","v":"Do senior management have sufficient leadership skills ?"},{"$f":"Working!G21","v":"N"},"Not Relevant"]
[null,7,{"$f":"'Change Readiness Questions'!C8","v":"Is there an agreed project plan for delivering this change ?"},{"$f":"Working!G22","v":"N"},"Not Relevant"]
[null,8,{"$f":"'Change Readiness Questions'!C9","v":"Is the authority for the go / no-go decision process agreed ?"},{"$f":"Working!G23","v":"N"},"Not Relevant"]
[null,9,{"$f":"'Change Readiness Questions'!C10","v":"Can the affected area accommodate this change now ?"},{"$f":"Working!G24","v":"N"},"Not Relevant"]

{"sheet":"People Readiness Qs","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"No.","Question","RAG","Answer"]
[null,10,{"$f":"'Change Readiness Questions'!C11","v":"Have the people impacted by the change been actively engaged ?"},{"$f":"Working!G25","v":"N"},"Not Relevant"]
[null,11,{"$f":"'Change Readiness Questions'!C12","v":"Has the impact on the organisational structures been considered ?"},{"$f":"Working!G26","v":"N"},"Not Relevant"]
[null,12,{"$f":"'Change Readiness Questions'!C13","v":"Has the impact on terms & conditions been assessed ?"},{"$f":"Working!G27","v":"N"},"Not Relevant"]
[null,13,{"$f":"'Change Readiness Questions'!C14","v":"Do people have the knowledge and skills to make the change work ?"},{"$f":"Working!G28","v":"N"},"Not Relevant"]
[null,14,{"$f":"'Change Readiness Questions'!C15","v":"Have suitable Change Leaders within the business been appointed ?"},{"$f":"Working!G29","v":"N"},"Not Relevant"]
[null,15,{"$f":"'Change Readiness Questions'!C16","v":"Will business users be able to 'rehearse' the new ways-of-working ?"},{"$f":"Working!G30","v":"N"},"Not Relevant"]
[null,16,{"$f":"'Change Readiness Questions'!C17","v":"Is the Project Manager/Sponsor empowered to make decisions ?"},{"$f":"Working!G31","v":"N"},"Not Relevant"]
[null,17,{"$f":"'Change Readiness Questions'!C18","v":"Is there on-going feedback between staff and the Change Leaders ?"},{"$f":"Working!G32","v":"N"},"Not Relevant"]
[null,18,{"$f":"'Change Readiness Questions'!C19","v":"Has the transition approach to new ways-of-working been agreed ?"},{"$f":"Working!G33","v":"N"},"Not Relevant"]

{"sheet":"Process Readiness Qs","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"No.","Question","RAG","Answer"]
[null,19,{"$f":"'Change Readiness Questions'!C20","v":"Have the designs of the new processes been approved ?"},{"$f":"Working!G34","v":"N"},"Not Relevant"]
[null,20,{"$f":"'Change Readiness Questions'!C21","v":"Have the new processes and procedures been sufficiently tested ?"},{"$f":"Working!G35","v":"N"},"Not Relevant"]
[null,21,{"$f":"'Change Readiness Questions'!C22","v":"Have business users received targeted communications ?"},{"$f":"Working!G36","v":"N"},"Not Relevant"]
[null,22,{"$f":"'Change Readiness Questions'!C23","v":"Are the risks of integrating the new processes being managed ?"},{"$f":"Working!G37","v":"N"},"Not Relevant"]
[null,23,{"$f":"'Change Readiness Questions'!C24","v":"Have business experts approved the transition approach ?"},{"$f":"Working!G38","v":"N"},"Not Relevant"]
[null,24,{"$f":"'Change Readiness Questions'!C25","v":"Has knowledge transfer to the process support staff occurred ?"},{"$f":"Working!G39","v":"N"},"Not Relevant"]
[null,25,{"$f":"'Change Readiness Questions'!C26","v":"Has the early-life support for the new processes been approved ?"},{"$f":"Working!G40","v":"N"},"Not Relevant"]
[null,26,{"$f":"'Change Readiness Questions'!C27","v":"Has a support plan for the new processes been approved and included in the Transition Plan ?"},{"$f":"Working!G41","v":"N"},"Not Relevant"]
[null,27,{"$f":"'Change Readiness Questions'!C28","v":"Have on-going performance measures been agreed ?"},{"$f":"Working!G42","v":"N"},"Not Relevant"]

{"sheet":"Technology Readiness Qs","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"No.","Question","RAG","Answer"]
[null,28,{"$f":"'Change Readiness Questions'!C29","v":"Has the design of the new technology been approved by IM?"},{"$f":"Working!G43","v":"N"},"Not Relevant"]
[null,29,{"$f":"'Change Readiness Questions'!C30","v":"Has the new technology been sufficiently tested functionally ?"},{"$f":"Working!G44","v":"N"},"Not Relevant"]
[null,30,{"$f":"'Change Readiness Questions'!C31","v":"Has the new technology been sufficiently tested for capacity and resilience in everyday use?"},{"$f":"Working!G45","v":"N"},"Not Relevant"]
[null,31,{"$f":"'Change Readiness Questions'!C32","v":"Are the risks of deploying the new technology being managed ?"},{"$f":"Working!G46","v":"N"},"Not Relevant"]
[null,32,{"$f":"'Change Readiness Questions'!C33","v":"Have technical experts approved the transition approach ?"},{"$f":"Working!G47","v":"N"},"Not Relevant"]
[null,33,{"$f":"'Change Readiness Questions'!C34","v":"Have data quality criteria been agreed ?"},{"$f":"Working!G48","v":"N"},"Not Relevant"]
[null,34,{"$f":"'Change Readiness Questions'!C35","v":"Has knowledge transfer to the technology support staff occurred ?"},{"$f":"Working!G49","v":"N"},"Not Relevant"]
[null,35,{"$f":"'Change Readiness Questions'!C36","v":"Has a support plan for the new technology been approved and included in the Transition Plan ?"},{"$f":"Working!G50","v":"N"},"Not Relevant"]
[null,36,{"$f":"'Change Readiness Questions'!C37","v":"Is there a proven roll-back plan in case the new technology 'fails' ?"},{"$f":"Working!G51","v":"N"},"Not Relevant"]

{"sheet":"Report","index":7,"n_rows":74,"n_cols":6,"rows_kept":74,"cut":false,"hidden":false,"merged":[[7,3,7,4],[43,0,43,2],[43,3,43,5],[8,3,8,4],[9,3,9,4],[13,3,13,5],[15,0,15,2],[14,0,14,2],[36,0,36,2],[36,3,36,5],[38,0,38,2],[38,3,38,5],[28,0,28,2],[26,3,26,5],[28,3,28,5],[26,0,26,2],[37,0,37,2],[32,0,32,2],[34,3,34,5],[37,3,37,5],[15,3,15,5],[30,3,30,5],[25,0,25,2],[16,0,16,2],[19,3,19,5],[21,0,21,2],[21,3,21,5],[27,0,27,2],[11,3,11,5],[42,0,42,2],[42,3,42,5],[32,3,32,5],[14,3,14,5],[16,3,16,5],[24,3,24,5],[25,3,25,5],[35,3,35,5],[23,3,23,5],[17,3,17,5],[30,0,30,2],[27,3,27,5],[29,0,29,2],[29,3,29,5],[18,3,18,5],[20,3,20,5],[22,3,22,5],[41,3,41,5],[8,0,8,1],[9,0,9,1],[24,0,24,2],[17,0,17,2],[12,0,12,1],[18,0,18,2],[11,0,11,2],[13,0,13,2],[20,0,20,2],[23,0,23,2],[22,0,22,2],[19,0,19,2],[72,4,72,5],[73,4,73,5],[53,0,53,2],[7,0,7,1],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[72,1,72,2],[73,1,73,2],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[69,1,69,2],[57,1,57,2],[58,1,58,2],[70,4,70,5],[69,4,69,5],[44,3,44,5],[59,1,59,2],[49,3,49,5],[46,0,46,2],[46,3,46,5],[39,3,39,5],[45,3,45,5],[50,0,50,2],[48,0,48,2],[48,3,48,5],[56,1,56,2],[40,3,40,5],[47,0,47,2],[68,1,68,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[71,4,71,5],[70,1,70,2],[71,1,71,2],[60,1,60,2],[45,0,45,2],[34,0,34,2],[44,0,44,2],[41,0,41,2],[39,0,39,2],[0,0,0,5],[1,1,1,5],[51,0,51,2],[51,3,51,5],[40,0,40,2],[47,3,47,5],[49,0,49,2],[2,2,2,5],[2,0,4,1],[6,2,6,5],[6,0,6,1],[3,2,3,5],[4,2,4,5],[5,2,5,5],[5,0,5,1],[33,0,33,1],[35,0,35,2],[50,3,50,5]]}
[{"$f":"CONCATENATE(\"Project Name: \",IF(ProjectName=0,\"Not yet provided\",ProjectName))","v":"Project Name: Not yet provided"}]
[null,{"$f":"IF(ProjectDesc=0,\"\",ProjectDesc)","v":""}]
[null,null,"Top 3 recommended corrective actions for your project:"]
[null,null,{"$f":"CONCATENATE(\"1. \",IF(ISERROR(VLOOKUP(1,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(1,Working!E$16:G$51,2,FALSE)))","v":"1. "}]
[null,null,{"$f":"CONCATENATE(\"2. \",IF(ISERROR(VLOOKUP(2,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(2,Working!E$16:G$51,2,FALSE)))","v":"2. "}]
["Overall Readiness",null,{"$f":"CONCATENATE(\"3. \",IF(ISERROR(VLOOKUP(3,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(3,Working!E$16:G$51,2,FALSE)))","v":"3. "}]
[{"$f":"Categories!D6","v":"Not relevant"},null,"Corrective actions continued on page 3"]
["Organisational readiness",null,"People readiness","Process readiness",null,"Technology readiness"]
[" "]
[{"$f":"Categories!D8","v":"Not relevant"},null,{"$f":"Categories!D10","v":"Not relevant"},{"$f":"Categories!D12","v":"Not relevant"},null,{"$f":"Categories!D14","v":"Not relevant"}]
[null,"Assessment Date:",{"$f":"ASSESS_DATE","v":"2014-04-06T22:01:36"}]
["Organisational Readiness",null,null,"People Readiness"]
[]
[{"$f":"'Organisational Readiness Qs'!C3","v":"Do you have an overall vision for change ?"},null,null,{"$f":"'People Readiness Qs'!C3","v":"Have the people impacted by the change been actively engaged ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E3=0,\"Not answered yet\",'Organisational Readiness Qs'!E3)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E3=0,\"Not answered yet\",'People Readiness Qs'!E3)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C4","v":"Is there a proven track record of successful business change ?"},null,null,{"$f":"'People Readiness Qs'!C4","v":"Has the impact on the organisational structures been considered ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E4=0,\"Not answered yet\",'Organisational Readiness Qs'!E4)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E4=0,\"Not answered yet\",'People Readiness Qs'!E4)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C5","v":"Has the purpose of this change been clearly articulated ?"},null,null,{"$f":"'People Readiness Qs'!C5","v":"Has the impact on terms & conditions been assessed ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E5=0,\"Not answered yet\",'Organisational Readiness Qs'!E5)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E5=0,\"Not answered yet\",'People Readiness Qs'!E5)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C6","v":"Does the sponsor consistently give active support to this change ?"},null,null,{"$f":"'People Readiness Qs'!C6","v":"Do people have the knowledge and skills to make the change work ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E6=0,\"Not answered yet\",'Organisational Readiness Qs'!E6)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E6=0,\"Not answered yet\",'People Readiness Qs'!E6)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C7","v":"Is senior management committed to making this change happen ?"},null,null,{"$f":"'People Readiness Qs'!C7","v":"Have suitable Change Leaders within the business been appointed ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E7=0,\"Not answered yet\",'Organisational Readiness Qs'!E7)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E7=0,\"Not answered yet\",'People Readiness Qs'!E7)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C8","v":"Do senior management have sufficient leadership skills ?"},null,null,{"$f":"'People Readiness Qs'!C8","v":"Will business users be able to 'rehearse' the new ways-of-working ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E8=0,\"Not answered yet\",'Organisational Readiness Qs'!E8)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E8=0,\"Not answered yet\",'People Readiness Qs'!E8)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C9","v":"Is there an agreed project plan for delivering this change ?"},null,null,{"$f":"'People Readiness Qs'!C9","v":"Is the Project Manager/Sponsor empowered to make decisions ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E9=0,\"Not answered yet\",'Organisational Readiness Qs'!E9)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E9=0,\"Not answered yet\",'People Readiness Qs'!E9)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C10","v":"Is the authority for the go / no-go decision process agreed ?"},null,null,{"$f":"'People Readiness Qs'!C10","v":"Is there on-going feedback between staff and the Change Leaders ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E10=0,\"Not answered yet\",'Organisational Readiness Qs'!E10)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E10=0,\"Not answered yet\",'People Readiness Qs'!E10)","v":"Not Relevant"}]
[{"$f":"'Organisational Readiness Qs'!C11","v":"Can the affected area accommodate this change now ?"},null,null,{"$f":"'People Readiness Qs'!C11","v":"Has the transition approach to new ways-of-working been agreed ?"}]
[{"$f":"IF('Organisational Readiness Qs'!E11=0,\"Not answered yet\",'Organisational Readiness Qs'!E11)","v":"Not Relevant"},null,null,{"$f":"IF('People Readiness Qs'!E11=0,\"Not answered yet\",'People Readiness Qs'!E11)","v":"Not Relevant"}]
[]
["Process Readiness",null,null,"Technology Readiness"]
[]
[{"$f":"'Process Readiness Qs'!C3","v":"Have the designs of the new processes been approved ?"},null,null,{"$f":"'Technology Readiness Qs'!C3","v":"Has the design of the new technology been approved by IM?"}]
[{"$f":"IF('Process Readiness Qs'!E3=0,\"Not answered yet\",'Process Readiness Qs'!E3)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E3=0,\"Not answered yet\",'Technology Readiness Qs'!E3)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C4","v":"Have the new processes and procedures been sufficiently tested ?"},null,null,{"$f":"'Technology Readiness Qs'!C4","v":"Has the new technology been sufficiently tested functionally ?"}]
[{"$f":"IF('Process Readiness Qs'!E4=0,\"Not answered yet\",'Process Readiness Qs'!E4)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E4=0,\"Not answered yet\",'Technology Readiness Qs'!E4)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C5","v":"Have business users received targeted communications ?"},null,null,{"$f":"'Technology Readiness Qs'!C5","v":"Has the new technology been sufficiently tested for capacity and resilience in everyday use?"}]
[{"$f":"IF('Process Readiness Qs'!E5=0,\"Not answered yet\",'Process Readiness Qs'!E5)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E5=0,\"Not answered yet\",'Technology Readiness Qs'!E5)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C6","v":"Are the risks of integrating the new processes being managed ?"},null,null,{"$f":"'Technology Readiness Qs'!C6","v":"Are the risks of deploying the new technology being managed ?"}]
[{"$f":"IF('Process Readiness Qs'!E6=0,\"Not answered yet\",'Process Readiness Qs'!E6)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E6=0,\"Not answered yet\",'Technology Readiness Qs'!E6)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C7","v":"Have business experts approved the transition approach ?"},null,null,{"$f":"'Technology Readiness Qs'!C7","v":"Have technical experts approved the transition approach ?"}]
[{"$f":"IF('Process Readiness Qs'!E7=0,\"Not answered yet\",'Process Readiness Qs'!E7)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E7=0,\"Not answered yet\",'Technology Readiness Qs'!E7)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C8","v":"Has knowledge transfer to the process support staff occurred ?"},null,null,{"$f":"'Technology Readiness Qs'!C8","v":"Have data quality criteria been agreed ?"}]
[{"$f":"IF('Process Readiness Qs'!E8=0,\"Not answered yet\",'Process Readiness Qs'!E8)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E8=0,\"Not answered yet\",'Technology Readiness Qs'!E8)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C9","v":"Has the early-life support for the new processes been approved ?"},null,null,{"$f":"'Technology Readiness Qs'!C9","v":"Has knowledge transfer to the technology support staff occurred ?"}]
[{"$f":"IF('Process Readiness Qs'!E9=0,\"Not answered yet\",'Process Readiness Qs'!E9)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E9=0,\"Not answered yet\",'Technology Readiness Qs'!E9)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C10","v":"Has a support plan for the new processes been approved and included in the Transition Plan ?"},null,null,{"$f":"'Technology Readiness Qs'!C10","v":"Has a support plan for the new technology been approved and included in the Transition Plan ?"}]
[{"$f":"IF('Process Readiness Qs'!E10=0,\"Not answered yet\",'Process Readiness Qs'!E10)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E10=0,\"Not answered yet\",'Technology Readiness Qs'!E10)","v":"Not Relevant"}]
[{"$f":"'Process Readiness Qs'!C11","v":"Have on-going performance measures been agreed ?"},null,null,{"$f":"'Technology Readiness Qs'!C11","v":"Is there a proven roll-back plan in case the new technology 'fails' ?"}]
[{"$f":"IF('Process Readiness Qs'!E11=0,\"Not answered yet\",'Process Readiness Qs'!E11)","v":"Not Relevant"},null,null,{"$f":"IF('Technology Readiness Qs'!E11=0,\"Not answered yet\",'Technology Readiness Qs'!E11)","v":"Not Relevant"}]
[]
["Corrective Actions For Your Project"]
["Corrective actions in descending order of importance"]
[]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B17,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B17,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A57,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A57,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B35,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B35,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D57,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D57,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B18,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B18,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A58,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A58,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B36,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B36,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D58,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D58,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B19,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B19,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A59,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A59,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B37,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B37,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D59,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D59,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B20,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B20,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A60,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A60,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B38,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B38,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D60,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D60,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B21,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B21,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A61,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A61,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B39,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B39,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D61,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D61,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B22,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B22,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A62,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A62,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B40,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B40,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D62,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D62,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B23,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B23,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A63,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A63,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B41,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B41,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D63,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D63,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B24,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B24,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A64,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A64,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B42,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B42,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D64,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D64,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B25,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B25,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A65,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A65,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B43,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B43,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D65,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D65,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B26,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B26,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A66,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A66,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B44,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B44,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D66,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D66,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B27,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B27,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A67,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A67,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B45,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B45,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D67,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D67,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B28,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B28,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A68,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A68,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B46,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B46,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D68,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D68,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B29,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B29,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A69,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A69,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B47,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B47,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D69,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D69,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B30,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B30,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A70,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A70,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B48,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B48,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D70,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D70,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B31,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B31,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A71,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A71,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B49,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B49,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D71,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D71,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B32,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B32,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A72,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A72,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B50,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B50,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D72,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D72,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B33,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B33,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A73,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A73,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B51,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B51,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D73,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D73,Working!E$16:G$51,2,FALSE))","v":""}]
[{"$f":"IF(ISERROR(VLOOKUP(Working!B34,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B34,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(A74,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(A74,Working!E$16:G$51,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(Working!B52,Working!E$16:G$51,1,FALSE)),\"\",VLOOKUP(Working!B52,Working!E$16:G$51,1,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D74,Working!E$16:G$51,2,FALSE)),\"\",VLOOKUP(D74,Working!E$16:G$51,2,FALSE))","v":""}]

{"sheet":"Definitions","index":8,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Change Readiness Assessor Tool",null,null,"Last updated :","2013-03-30"]
[]
[null,"Category","Description",null,"Red","Amber","Green"]
[null,"Overall","The readiness of the business to implement this change, and to ensure that any impact of the new ways-of-working will be minimised during transition",null,"The business is not ready for the change, and should not implement the new ways-of-working unless substantial corrective action is taken","The business is getting ready for the change, but should complete some key corrective actions before implementing the new ways-of-working","The business is ready to implement the change, and has prepared thoroughly for a successful transition to the new ways-of-working"]
[null,"Organisational readiness","The readiness of the organisation to move to the new ways-of-working, and assurance that senior management are committed to making it happen",null,"The organisation is not ready for the new ways-of-working. Substantial corrective action should be taken before proceeding","The organisation is getting ready for the new ways-of-working, but key corrective action should be taken before implementing them","The organisation is ready for the new ways-of-working. Senior management are committed to the change and have prepared thoroughly for implementing the new ways-of-working"]
[null,"People readiness","The readiness of the organisation's people to embrace the new ways-of-working, and assurance that they will be supported during the transition",null,"Staff are not ready for the new ways-of-working. Substantial corrective action should be taken before proceeding.","Staff are getting ready for the new ways-of-working, but key corrective action should be taken before implementing them","Staff are ready for the new ways-of-working, and have been actively involved in preparing for their implementation"]
[null,"Process readiness","The readiness of the new processes and procedures to be implemented, and assurance that they are sustainable",null,"The new processes and procedures are not ready to be implemented. Substantial corrective action should be taken before proceeding","The new processes and procedures are becoming ready, but key corrective action should be taken before implementing them","The new processes and procedures are ready to be implemented"]
[null,"Technology readiness","The readiness of the new technology (hardware and software) to be deployed, and assurance that the technical environment can accommodate it",null,"The new technology (hardware and software) is not ready to be deployed. Substantial corrective action should be taken before proceeding","The new technology (hardware and software) is becoming ready, but key corrective action should be taken before deploying it","The new technology (hardware and software) is ready to be deployed"]

{"sheet":"Change Readiness Questions","index":9,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["ID","Category","Question","Actions","Not relevant","Answer - green","Answer - amber","Answer - red","Actions - green","Actions - amber","Actions - red","Hint","Weighting Factor","Non-Null Max Weighting"]
[0,"organisational readiness","Do you have an overall vision for change ?","Create, approve and publish the Vision for Change ","Not Relevant","Yes - the Vision for Change is available to all ","The Vision for Change is known to senior executives only","No - a Vision for Change does not exist","n/a","Review the Vision for Change and communicate it to customers and stakeholders","Create, approve and publish the Vision for Change ",null,1,{"$f":"IF('Organisational Readiness Qs'!D3=\"N\",0,2*'Change Readiness Questions'!M2)","v":0}]
[1,"organisational readiness","Is there a proven track record of successful business change ?","Engage some experienced and successful change delivery managers","Not Relevant","Yes - the organisation has often undertaken business change successfully","Previous business change initiatives produced inconsistent outcomes","No - previous business change initiatives have been largely unsuccessful","n/a","Provide mentoring from experienced and successful change delivery managers to staff","Engage some experienced and successful change delivery managers to deliver the change",null,2,{"$f":"IF('Organisational Readiness Qs'!D4=\"N\",0,2*'Change Readiness Questions'!M3)","v":0}]
[2,"organisational readiness","Has the purpose of this change been clearly articulated ?","Create, approve and publish the Vision for Change for this project","Not Relevant","Yes - the purpose of this change has been clearly communicated across the business","The purpose of this change is known but has not yet been communicated","No - the purpose of this change is unknown / ambiguous","n/a","Review the project's Vision for Change and communicate it to the stakeholders","Create, approve and publish the Vision for Change for this project","(e.g. outcomes, benefits, opportunities, value)",3,{"$f":"IF('Organisational Readiness Qs'!D5=\"N\",0,2*'Change Readiness Questions'!M4)","v":0}]
[3,"organisational readiness","Does the sponsor consistently give active support to this change ?","Work closely with the Sponsor to urgently increase their active support for the change","Not Relevant","Yes - the sponsor is actively promoting the change","The sponsor supports the change but participates only at major milestones","No - the sponsor does not support / ignores the change","n/a","Strengthen communications about the Sponsor's support and encourage them to participate at more events","Work closely with the Sponsor to urgently increase their active support for the change",null,4,{"$f":"IF('Organisational Readiness Qs'!D6=\"N\",0,2*'Change Readiness Questions'!M5)","v":0}]
[4,"organisational readiness","Is senior management committed to making this change happen ?","Undertake a communications campaign to engage senior management and gain their active commitment to the change","Not Relevant","Yes - senior management regularly demonstrate active commitment","Senior management show passive commitment to the change","No - senior management show no commitment to the change","n/a","Work with senior management to convert their passive commitment to active support","Initiate a communications campaign to engage senior management and gain their active commitment to the change",null,3,{"$f":"IF('Organisational Readiness Qs'!D7=\"N\",0,2*'Change Readiness Questions'!M6)","v":0}]
[5,"organisational readiness","Do senior management have sufficient leadership skills ?","Engage leadership coaches for senior management","Not Relevant","Yes - all managers have proven leadership and coaching skills","Some managers have leadership and coaching capabilities","No - managers do not have proven leadership skills","n/a","Encourage experienced leaders to provide coaching to less experienced managers","Engage leadership coaches for senior management throughout the change",null,4,{"$f":"IF('Organisational Readiness Qs'!D8=\"N\",0,2*'Change Readiness Questions'!M7)","v":0}]
[6,"organisational readiness","Is there an agreed project plan for delivering this change ?","Create, approve and enact the project plan for delivering the change, including accountabilities","Not Relevant","Yes - the project plan has been approved and is underway","An outline project plan exists, but has not been signed off","No - a project plan does not exist","n/a","Define accountabilities for delivering the change, update the project plan and get sign-off","Create, approve and enact the project plan for delivering the change, including accountabilities",null,3,{"$f":"IF('Organisational Readiness Qs'!D9=\"N\",0,2*'Change Readiness Questions'!M8)","v":0}]
[7,"organisational readiness","Is the authority for the go / no-go decision process agreed ?","Confirm and publicise the go/no-go decision authority","Not Relevant","Yes - the authority and criteria for the go/no-go decision have been agreed","Go/no-go criteria are not yet agreed","No - the authority for the go/no-go decision is unknown","n/a","Define the go/no-go criteria, update the project plan and get sign-off","Confirm and publicise the go/no-go decision authority and go/no-go criteria",null,2,{"$f":"IF('Organisational Readiness Qs'!D10=\"N\",0,2*'Change Readiness Questions'!M9)","v":0}]
[8,"organisational readiness","Can the affected area accommodate this change now ?","Consider stopping or delaying the change project, to reduce the simultaneous impact of changes","Not Relevant","Yes - there is very little other change underway at the moment","Other change initiatives are underway, but no dependencies on them","No - there are other significant change initiatives underway ","n/a","Review the Risk Register to ensure it accurately shows the dependencies. Confirm that the dependencies are regularly monitored","Consider stopping or delaying the change project, to reduce the simultaneous impact of changes",null,5,{"$f":"IF('Organisational Readiness Qs'!D11=\"N\",0,2*'Change Readiness Questions'!M10)","v":0}]
[9,"people readiness","Have the people impacted by the change been actively engaged ?","Undertake Stakeholder Planning, and engage staff in helping shape the outcomes","Not Relevant","Yes - there is strong business involvement in the project","Limited / occasional business involvement","No - the business has not been involved in the project","n/a","Review the Stakeholder Plan and Communications Plan, and increase the business engagement","Initiate Stakeholder planning and engage staff in helping shape the outcomes",null,3,{"$f":"IF('People Readiness Qs'!D3=\"N\",0,2*'Change Readiness Questions'!M11)","v":0}]
[10,"people readiness","Has the impact on the organisational structures been considered ?","Assess the impact on organisational structures and culture, and include mitigation actions in the project plan","Not Relevant","Yes - the impact on organisational structures is reflected in the project plan","An informal impact assessment has been made","No - the impact on organisational structures has not been considered","n/a","Review the mitigation actions to reduce the impact on organisational structures and culture, update the project plan and get sign-off","Initiate an impact assessment on organisational structures and culture, and include mitigation actions in the project plan"," (e.g. departments, functions) ",1,{"$f":"IF('People Readiness Qs'!D4=\"N\",0,2*'Change Readiness Questions'!M12)","v":0}]
[11,"people readiness","Has the impact on terms & conditions been assessed ?","Undertake an impact assessment on terms, conditions and places of employment/work, and include mitigation actions in the project plan","Not Relevant","Yes - an impact analysis on terms and conditions has been undertaken","Terms and conditions are not expected to change, but not yet agreed","No - an analysis on terms and conditions has not been undertaken","n/a","Review the mitigation actions to reduce the impact on terms, conditions and places of employment/work, update the project plan and get sign-off","Initiate an impact assessment on terms, conditions and places of employment/work, and include mitigation actions in the project plan",null,2,{"$f":"IF('People Readiness Qs'!D5=\"N\",0,2*'Change Readiness Questions'!M13)","v":0}]
[12,"people readiness","Do people have the knowledge and skills to make the change work ?","Consider stopping or delaying the change project until sufficient knowledge transfer and training for the business staff has been completed","Not Relevant","Yes - a comprehensive training and coaching programme is in place","Limited training or coaching will be provided","No - skill requirements have not been assessed and no training is planned","n/a","Review the Risk Register to ensure it accurately shows the risk of insufficient knowledge transfer and training for the business staff.  Confirm that the risks are regularly monitored","Consider stopping or delaying the change project until sufficient knowledge transfer and training for the business staff has been completed",null,5,{"$f":"IF('People Readiness Qs'!D6=\"N\",0,2*'Change Readiness Questions'!M14)","v":0}]
[13,"people readiness","Have suitable Change Leaders within the business been appointed ?","Identify and appoint suitable Change Leaders from within the business","Not Relevant","Yes - the Change Leaders are in place to support staff during the change","Change Leaders have been informally identified","No - Change Leaders have not been identified and/or appointed","n/a","Review the list of suitable Change Leaders and ensure they are assigned to business areas/staff","Identify and appoint suitable Change Leaders from within the business",null,4,{"$f":"IF('People Readiness Qs'!D7=\"N\",0,2*'Change Readiness Questions'!M15)","v":0}]
[14,"people readiness","Will business users be able to 'rehearse' the new ways-of-working ?","Create a Model Office or similar, to allow staff to 'rehearse' the new ways-of-working before go-live","Not Relevant","Yes - a full simulation of the new ways-of-working will be provided","Limited simulations of the new ways-of-working will be provided","No - there will be no provision for trying the new ways-of-working","n/a","Review and strengthen the provisions for staff to 'rehearse' the new ways-of-working before go-live","Create a Model Office or similar, to allow staff to 'rehearse' the new ways-of-working before go-live",null,3,{"$f":"IF('People Readiness Qs'!D8=\"N\",0,2*'Change Readiness Questions'!M16)","v":0}]
[15,"people readiness","Is the Project Manager/Sponsor empowered to make decisions ?","Ensure the Project Manager/Sponsor is empowered to make decisions about new ways-of-working and transition","Not Relevant","Yes - the Project Manager/Sponsor is authorised to take these decisions","Decisions are taken by committee","No - the decision making authority is not defined","n/a","Define the accountabilities for making decisions about new ways-of-working and transition, update the Project Plan and get sign-off","Ensure the Project Manager/Sponsor is empowered to make decisions about new ways-of-working and transition",null,3,{"$f":"IF('People Readiness Qs'!D9=\"N\",0,2*'Change Readiness Questions'!M17)","v":0}]
[16,"people readiness","Is there on-going feedback between staff and the Change Leaders ?","Strengthen the communication channels between staff and the Change Leaders, and monitor their use. Ensure the Communications Plan includes these activities","Not Relevant","Yes - business users regularly receive and provide feedback","Occasional / informal feedback is provided","No - feedback mechanisms do not exist or are ad-hoc","n/a","Review and strengthen the communication channels between staff and the Change Leaders, and monitor their use. Update the Communications Plan and get sign-off","Define the communication channels between staff and the Change Leaders, and monitor their use. Ensure the Communications Plan includes these activities",null,2,{"$f":"IF('People Readiness Qs'!D10=\"N\",0,2*'Change Readiness Questions'!M18)","v":0}]
[17,"people readiness","Has the transition approach to new ways-of-working been agreed ?","Create, approve and publish the Transition Plan detailing the transition to the new ways-of-working","Not Relevant","Yes - a Transition Plan has been agreed and signed-off","Informal discussions have taken place about transition","No - the transition approach has not been defined","n/a","Review the Transition Plan detailing the transition to the new ways-of-working, update the Plan and get sign-off","Create, approve and publish the Transition Plan detailing the transition to the new ways-of-working","(e.g. pilot, proof-of-concept, parallel running, big-bang)",3,{"$f":"IF('People Readiness Qs'!D11=\"N\",0,2*'Change Readiness Questions'!M19)","v":0}]
[18,"process readiness","Have the designs of the new processes been approved ?","Conduct a full review of the designs of the new processes and procedures and obtain sign-off from the Sponsor","Not Relevant","Yes - the  Sponsor has signed off the designs","The designs have been peer reviewed but not signed off","No - the designs have not been reviewed","n/a","Review the designs of the new processes and procedures and get sign-off from the Sponsor ","Conduct a full review of the designs of the new processes and procedures and obtain sign-off from the Sponsor",null,2,{"$f":"IF('Process Readiness Qs'!D3=\"N\",0,2*'Change Readiness Questions'!M20)","v":0}]
[19,"process readiness","Have the new processes and procedures been sufficiently tested ?","Strengthen the business process testing activities and participation by business users","Not Relevant","Yes - full process testing has occurred and been signed off","Some process testing has taken place","No - process testing has not taken place","n/a","Conduct a gap analysis to identify actions needed to achieve appropriate functionality, update the Transition Plan and get sign-off","Define the go-live functionality needed; write the relevant section of the Transition Plan and get sign-off","(e.g. workability, functionality, usability)",4,{"$f":"IF('Process Readiness Qs'!D4=\"N\",0,2*'Change Readiness Questions'!M21)","v":0}]
[20,"process readiness","Have business users received targeted communications ?","Ensure the Communications Plan includes activities targeted at business process users, obtain sign-off and publish","Not Relevant","Yes - business process users regularly receive targeted communications","Informal communications occur with business process users","No - business process users do not have targeted communications","n/a","Review the Communications Plan to strengthen activities targeted at business process users, obtain sign-off and publish","Update the Communications Plan to include activities targeted at business process users, obtain sign-off and publish",null,1,{"$f":"IF('Process Readiness Qs'!D5=\"N\",0,2*'Change Readiness Questions'!M22)","v":0}]
[21,"process readiness","Are the risks of integrating the new processes being managed ?","Undertake a risk assessment on integrating the new processes and procedures into the business environment, and include mitigation actions in the Transition Plan","Not Relevant","Yes - implementation risks and issues are logged and regularly reviewed","Implementation risks and issues are tracked informally","No - there is no active process for managing implementation risks and issues","n/a","Update the Risk Register with risks on integrating the new processes and procedures into the business environment, update the Transition Plan with mitigation actions, ensure the Risk register is reviewed regularly (e.g. weekly)","Initiate a risk assessment on integrating the new ways-of-working into the business environment, and include mitigation actions in the Transition Plan",null,2,{"$f":"IF('Process Readiness Qs'!D6=\"N\",0,2*'Change Readiness Questions'!M23)","v":0}]
[22,"process readiness","Have business experts approved the transition approach ?","Review the transition approach with full involvement from business process experts, update the Transition Plan and get sign-off","Not Relevant","Yes - business experts have approved the transition approach","Informal discussions have taken place with business staff about transition","No - business experts have not been consulted about transition","n/a","Review the cut-over approach with business staff, update the Transition Plan and get sign-off","Define the transition approach with full involvement from business process experts, define the Transition Plan and get sign-off",null,2,{"$f":"IF('Process Readiness Qs'!D7=\"N\",0,2*'Change Readiness Questions'!M24)","v":0}]
[23,"process readiness","Has knowledge transfer to the process support staff occurred ?","Consider stopping or delaying the change project until sufficient knowledge transfer and training for business process support staff has been completed","Not Relevant","Yes - full handover from development teams to support teams has occurred","Informal knowledge transfer has taken place","No - knowledge transfer has not taken place","n/a","Review the Risk Register to ensure it accurately shows the risk of insufficient knowledge transfer and training for the business process support staff.  Confirm that the risks are regularly monitored","Consider stopping or delaying the change project until sufficient knowledge transfer and training for business process support staff has been completed"," (e.g. admin training and support documentation)",5,{"$f":"IF('Process Readiness Qs'!D8=\"N\",0,2*'Change Readiness Questions'!M25)","v":0}]
[24,"process readiness","Has the early-life support for the new processes been approved ?","Create, approve and publish the Transition (& Integration) Plan detailing early-life support of the new processes and procedures","Not Relevant","Yes - the Transition (& Integration) Plan has been signed off","Informal discussions about early-life support have taken place","No - the Transition (& Integration) Plan does not exist","n/a","Review the Transition (& Integration) Plan detailing early-life support of the new processes and procedures, get sign-off and publish","Define the Transition (& Integration) Plan detailing early-life support of the new processes and procedures, get sign-off and publish","(e.g. temporary increase in support staff)",3,{"$f":"IF('Process Readiness Qs'!D9=\"N\",0,2*'Change Readiness Questions'!M26)","v":0}]
[25,"process readiness","Has a support plan for the new processes been approved and included in the Transition Plan ?","Create, approve and publish a support plan for the new processes and procedures within the Transition Plan,  including SLAs and budgets","Not Relevant","Yes - a support plan, SLAs and budgets have been approved","Informal discussions have taken place about support and SLAs","No - a support plan for the new processes does not exist","n/a","Review the Transition Plan support details for the new processes and procedures, including SLAs and budgets, get sign-off and publish","Define the Transition Plan support details for the new processes and procedures, including SLAs and budgets, get sign-off and publish",null,3,{"$f":"IF('Process Readiness Qs'!D10=\"N\",0,2*'Change Readiness Questions'!M27)","v":0}]
[26,"process readiness","Have on-going performance measures been agreed ?","Create, approve and publish performance measures, targets and responsibilities for achieving them","Not Relevant","Yes - performance measures and responsibilities have been signed off","Informal discussions about performance measures have taken place","No - performance measures and responsibilities have not been defined","n/a","Review the performance measures, targets and responsibilities for achieving them, get sign-off and publish","Define, approve and publish performance measures, targets and responsibilities for achieving them","(e.g. benefits realisation, customer satisfaction, supplier performance)",2,{"$f":"IF('Process Readiness Qs'!D11=\"N\",0,2*'Change Readiness Questions'!M28)","v":0}]
[27,"technology readiness","Has the design of the new technology been approved by IM?","Conduct a full review of the design of the new technology and obtain confirmation of compatibility with the TfL network from IM","Not Relevant","Yes - IM has agreed the design","The design has been peer reviewed but not agreed","No - the design has not been reviewed","n/a","Review the design of the new technology and get agreement from IM ","Conduct a full review of the design of the new technology and obtain agreement from IM",null,2,{"$f":"IF('Technology Readiness Qs'!D3=\"N\",0,2*'Change Readiness Questions'!M29)","v":0}]
[28,"technology readiness","Has the new technology been sufficiently tested functionally ?","Strengthen the user acceptance testing activities and participation by business users","Not Relevant","Yes - full user acceptance testing has been signed off","Some user acceptance testing has taken place","No - user acceptance testing has not taken place","n/a","Review the go-live functionality levels, conduct additional user tests needed to achieve these levels, update the Transition Plan and get sign-off","Define the go-live functionality levels, write the relevant section of the Transition Plan and get sign-off",null,4,{"$f":"IF('Technology Readiness Qs'!D4=\"N\",0,2*'Change Readiness Questions'!M30)","v":0}]
[29,"technology readiness","Has the new technology been sufficiently tested for capacity and resilience in everyday use?","Strengthen the operational acceptance testing activities and participation by support /operations staff (a wider audience)","Not Relevant","Yes - full operational acceptance testing has been signed off","Some operational testing has taken place","No - operational testing has not taken place","n/a","Review the go-live levels for capacity and resilience, conduct additional operational tests needed to achieve these levels, update the Transition Plan and get sign-off","Define the go-live levels for capacity and resilience, write the relevant section of the Transition Plan and get sign-off","(e.g. capacity, performance, resilience)",4,{"$f":"IF('Technology Readiness Qs'!D5=\"N\",0,2*'Change Readiness Questions'!M31)","v":0}]
[30,"technology readiness","Are the risks of deploying the new technology being managed ?","Assess the risk of deploying the new technology into the technical environment, and include mitigation actions in the Transition Plan","Not Relevant","Yes - deployment risks and issues are logged and regularly reviewed","Deployment risks and issues are tracked informally","No - there is no active process for management of deployment risks and issues","n/a","Update the Risk Register with risks on deploying the new technology into the technical environment, update the Transition Plan with mitigation actions, ensure the Risk register is reviewed regularly (e.g. weekly)","Initiate a risk assessment on deploying the new technology into the technical environment, and include mitigation actions in the Transition Plan",null,2,{"$f":"IF('Technology Readiness Qs'!D6=\"N\",0,2*'Change Readiness Questions'!M32)","v":0}]
[31,"technology readiness","Have technical experts approved the transition approach ?","Review the transition approach with full involvement from technical experts, update the Transition Plan and get sign-off","Not Relevant","Yes - technical experts have approved the transition approach","Informal discussions have taken place with technical staff about transition","No - technical experts have not been consulted about transition","n/a","Review the transition approach with technical staff, update the Transition Plan and get sign-off","Define the transition approach with full involvement from technical experts, define the Transition Plan and get sign-off","(e.g. pilot, parallel running, big-bang)",2,{"$f":"IF('Technology Readiness Qs'!D7=\"N\",0,2*'Change Readiness Questions'!M33)","v":0}]
[32,"technology readiness","Have data quality criteria been agreed ?","Create, approve and publish the data quality criteria and responsibilities in the Implementation Plan","Not Relevant","Yes - pre, during and post go-live data quality criteria have been approved","Criteria for data quality have been discussed informally","No - data quality has not been considered","n/a","Review the data quality criteria and ensure they are aligned with the transition approach, update the Transition Plan and get sign-off","Define and agree the data quality criteria and responsibilities, update the Transition Plan and get sign-off","(e.g. accuracy, integrity, validity, security)",3,{"$f":"IF('Technology Readiness Qs'!D8=\"N\",0,2*'Change Readiness Questions'!M34)","v":0}]
[33,"technology readiness","Has knowledge transfer to the technology support staff occurred ?","Consider stopping or delaying the change project until sufficient knowledge transfer and training for technology support staff has been completed","Not Relevant","Yes - full handover from development teams to support teams has occurred","Informal knowledge transfer has taken place","No - knowledge transfer has not taken place","n/a","Review the Risk Register to ensure it accurately shows the risk of insufficient knowledge transfer and training for the technology support staff.  Confirm that the risks are regularly monitored","Consider stopping or delaying the change project until sufficient knowledge transfer and training for technology support staff has been completed"," (e.g. admin training and support documentation)",5,{"$f":"IF('Technology Readiness Qs'!D9=\"N\",0,2*'Change Readiness Questions'!M35)","v":0}]
[34,"technology readiness","Has a support plan for the new technology been approved and included in the Transition Plan ?","Create, approve and publish a support plan for the new technology within the Transition Plan, including SLAs and budgets","Not Relevant","Yes - a support plan, SLAs and budgets have been approved","Informal discussions have taken place about support and SLAs","No - a support plan for the new technology does not exist","n/a","Review the Transition Plan support details for the new technology, including SLAs and budgets, get sign-off and publish","Define the Transition Plan support details for the new technology, including SLAs and budgets, get sign-off and publish",null,3,{"$f":"IF('Technology Readiness Qs'!D10=\"N\",0,2*'Change Readiness Questions'!M36)","v":0}]
[35,"technology readiness","Is there a proven roll-back plan in case the new technology 'fails' ?","Create, approve, publish and test the roll-back plan, in case the new technology 'fails' after go-live","Not Relevant","Yes - there is an approved and tested roll-back plan","Informal discussions have taken place about roll-back","No - there is no roll-back plan","n/a","Review the roll-back approach, update the Transition Plan with activities to test roll-back and get sign-off","Define, approve, publish and test the roll-back activities in case the new technology 'fails' after go-live. Update the Transition Plan and get sign-off",null,1,{"$f":"IF('Technology Readiness Qs'!D11=\"N\",0,2*'Change Readiness Questions'!M37)","v":0}]
[null,null,null,null,"N",0,1,2]

{"sheet":"Working","index":10,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":true,"merged":[[2,2,3,2],[4,2,5,2],[6,2,7,2],[8,2,9,2],[2,1,3,1],[4,1,5,1],[6,1,7,1],[8,1,9,1],[1,9,1,15],[6,3,7,3],[8,3,9,3],[11,9,11,10],[2,9,2,15],[4,9,4,15],[6,9,6,15],[8,9,8,15],[2,3,3,3],[4,3,5,3]]}
["Category","RAG","sum products of Qs and Answers","sum of max weighted non-null ",null,"speedo position","speedo width","speedo end","unanswered questions","Corrective action",null,null,null,null,null,null,"RAG"]
["Overall",{"$f":"IF(UnansweredQs=0,IF(ISERROR(INT(100*C2/D2)),\"N\",INT(100*C2/D2)),-1)","v":"N"},{"$f":"SUM(C3:C10)","v":0},{"$f":"SUM(D3:D10)","v":0},{"$f":"A2","v":"Overall"},{"$f":"IF(B2=\"N\",0,IF(B2 < 0,150,B2))","v":0},1,{"$f":"199-F2","v":199},{"$f":"COUNTIF(C16:C51,-1)","v":0},{"$f":"IF(I2=0,IF(B2<=RAG_GREEN,Definitions!G5,IF(B2<=RAG_AMBER,Definitions!F5,IF(B2<=100,Definitions!E5,\"Not relevant\"))),CONCATENATE(36-I2,\" out of 36 questions answered\"))","v":"Not relevant"},null,null,null,null,null,null,{"$f":"IF(B2<0,\"N\",IF(B2<=RAG_GREEN,\"Green\",IF(B2<=RAG_AMBER,\"Amber\",IF(B2=\"N\",\"N\",\"Red\"))))","v":"N"}]
["Organizational readiness",{"$f":"IF(I3=0,IF(ISERROR(INT(100*C3/D3)),\"N\",INT(100*C3/D3)),-1)","v":"N"},{"$f":"SUMPRODUCT(C16:C24,'Change Readiness Questions'!M2:M10)","v":0},{"$f":"SUM('Change Readiness Questions'!N2:N10)","v":0},{"$f":"A3","v":"Organizational readiness"},{"$f":"IF(B3=\"N\",0,IF(B3 < 0,150,B3))","v":0},1,{"$f":"199-F3","v":199},{"$f":"COUNTIF(C16:C24,-1)","v":0},{"$f":"IF(I3=0,IF(B3<=RAG_GREEN,Definitions!G6,IF(B3<=RAG_AMBER,Definitions!F6,IF(B3<=100,Definitions!E6,\"Not relevant\"))),CONCATENATE(9-I3,\" out of 9 questions answered\"))","v":"Not relevant"},null,null,null,null,null,null,{"$f":"IF(B3<0,\"N\",IF(B3<=RAG_GREEN,\"Green\",IF(B3<=RAG_AMBER,\"Amber\",IF(B3=\"N\",\"N\",\"Red\"))))","v":"N"}]
[]
["People readiness",{"$f":"IF(I5=0,IF(ISERROR(INT(100*C5/D5)),\"N\",INT(100*C5/D5)),-1)","v":"N"},{"$f":"SUMPRODUCT(C25:C33,'Change Readiness Questions'!M11:M19)","v":0},{"$f":"SUM('Change Readiness Questions'!N11:N19)","v":0},{"$f":"A5","v":"People readiness"},{"$f":"IF(B5=\"N\",0,IF(B5 < 0,150,B5))","v":0},1,{"$f":"199-F5","v":199},{"$f":"COUNTIF(C25:C33,-1)","v":0},{"$f":"IF(I5=0,IF(B5<=RAG_GREEN,Definitions!G7,IF(B5<=RAG_AMBER,Definitions!F7,IF(B5<=100,Definitions!E7,\"Not relevant\"))),CONCATENATE(9-I5,\" out of 9 questions answered\"))","v":"Not relevant"},null,null,null,null,null,null,{"$f":"IF(B5<0,\"N\",IF(B5<=RAG_GREEN,\"Green\",IF(B5<=RAG_AMBER,\"Amber\",IF(B5=\"N\",\"N\",\"Red\"))))","v":"N"}]
[]
["Process readiness",{"$f":"IF(I7=0,IF(ISERROR(INT(100*C7/D7)),\"N\",INT(100*C7/D7)),-1)","v":"N"},{"$f":"SUMPRODUCT(C34:C42,'Change Readiness Questions'!M20:M28)","v":0},{"$f":"SUM('Change Readiness Questions'!N20:N28)","v":0},{"$f":"A7","v":"Process readiness"},{"$f":"IF(B7=\"N\",0,IF(B7 < 0,150,B7))","v":0},1,{"$f":"199-F7","v":199},{"$f":"COUNTIF(C34:C42,-1)","v":0},{"$f":"IF(I7=0,IF(B7<=RAG_GREEN,Definitions!G8,IF(B7<=RAG_AMBER,Definitions!F8,IF(B7<=100,Definitions!E8,\"Not relevant\"))),CONCATENATE(9-I7,\" out of 9 questions answered\"))","v":"Not relevant"},null,null,null,null,null,null,{"$f":"IF(B7<0,\"N\",IF(B7<=RAG_GREEN,\"Green\",IF(B7<=RAG_AMBER,\"Amber\",IF(B7=\"N\",\"N\",\"Red\"))))","v":"N"}]
[]
["Technology readiness",{"$f":"IF(I9=0,IF(ISERROR(INT(100*C9/D9)),\"N\",INT(100*C9/D9)),-1)","v":"N"},{"$f":"SUMPRODUCT(C43:C51,'Change Readiness Questions'!M29:M37)","v":0},{"$f":"SUM('Change Readiness Questions'!N29:N37)","v":0},{"$f":"A9","v":"Technology readiness"},{"$f":"IF(B9=\"N\",0,IF(B9 < 0,150,B9))","v":0},1,{"$f":"199-F9","v":199},{"$f":"COUNTIF(C43:C51,-1)","v":0},{"$f":"IF(I9=0,IF(B9<=RAG_GREEN,Definitions!G9,IF(B9<=RAG_AMBER,Definitions!F9,IF(B9<=100,Definitions!E9,\"Not relevant\"))),CONCATENATE(9-I9,\" out of 9 questions answered\"))","v":"Not relevant"},null,null,null,null,null,null,{"$f":"IF(B9<0,\"N\",IF(B9<=RAG_GREEN,\"Green\",IF(B9<=RAG_AMBER,\"Amber\",IF(B9=\"N\",\"N\",\"Red\"))))","v":"N"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Speedometer "]
[null,null,null,null,null,null,null,null,null,"Start",0]
["Displayed Question ID","Question Sheet ",null,null,null,null,null,null,null,"Initial ",{"$f":"RAG_GREEN","v":33},33,"RAG_GREEN"]
[null,"ID","Answer","Weighted Answer","Rank","Actions","RAG",null,null,"Middle",{"$f":"RAG_AMBER-RAG_GREEN","v":33},66,"RAG_AMBER"]
[1,0,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E3,'Change Readiness Questions'!E2:H$38,37-B16,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E3,'Change Readiness Questions'!E2:H$38,37-B16,FALSE))","v":"N"},{"$f":"IF(C16<>\"N\",C16*'Change Readiness Questions'!M2+(B16/36),0)","v":0},{"$f":"IF(D16<1,-1,RANK(D16,D$16:D$51))","v":-1},{"$f":"IF(C16=1,'Change Readiness Questions'!J2,IF(C16=2,'Change Readiness Questions'!K2,\"\"))","v":""},{"$f":"IF(C16=0,\"Green\",IF(C16=1,\"Amber\",IF(C16=2,\"Red\",\"N\")))","v":"N"},null,null,"End",{"$f":"L16-RAG_AMBER","v":33},99,"RAG_RED"]
[2,1,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E4,'Change Readiness Questions'!E3:H$38,37-B17,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E4,'Change Readiness Questions'!E3:H$38,37-B17,FALSE))","v":"N"},{"$f":"IF(C17<>\"N\",C17*'Change Readiness Questions'!M3+(B17/36),0)","v":0},{"$f":"IF(D17<1,-1,RANK(D17,D$16:D$51))","v":-1},{"$f":"IF(C17=1,'Change Readiness Questions'!J3,IF(C17=2,'Change Readiness Questions'!K3,\"\"))","v":""},"N",null,null,"Max",{"$f":"L16","v":99}]
[3,2,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E5,'Change Readiness Questions'!E4:H$38,37-B18,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E5,'Change Readiness Questions'!E4:H$38,37-B18,FALSE))","v":"N"},{"$f":"IF(C18<>\"N\",C18*'Change Readiness Questions'!M4+(B18/36),0)","v":0},-1,{"$f":"IF(C18=1,'Change Readiness Questions'!J4,IF(C18=2,'Change Readiness Questions'!K4,\"\"))","v":""},"N"]
[4,3,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E6,'Change Readiness Questions'!E5:H$38,37-B19,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E6,'Change Readiness Questions'!E5:H$38,37-B19,FALSE))","v":"N"},{"$f":"IF(C19<>\"N\",C19*'Change Readiness Questions'!M5+(B19/36),0)","v":0},-1,{"$f":"IF(C19=1,'Change Readiness Questions'!J5,IF(C19=2,'Change Readiness Questions'!K5,\"\"))","v":""},"N"]
[5,4,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E7,'Change Readiness Questions'!E6:H$38,37-B20,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E7,'Change Readiness Questions'!E6:H$38,37-B20,FALSE))","v":"N"},{"$f":"IF(C20<>\"N\",C20*'Change Readiness Questions'!M6+(B20/36),0)","v":0},-1,{"$f":"IF(C20=1,'Change Readiness Questions'!J6,IF(C20=2,'Change Readiness Questions'!K6,\"\"))","v":""},"N"]
[6,5,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E8,'Change Readiness Questions'!E7:H$38,37-B21,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E8,'Change Readiness Questions'!E7:H$38,37-B21,FALSE))","v":"N"},{"$f":"IF(C21<>\"N\",C21*'Change Readiness Questions'!M7+(B21/36),0)","v":0},-1,{"$f":"IF(C21=1,'Change Readiness Questions'!J7,IF(C21=2,'Change Readiness Questions'!K7,\"\"))","v":""},"N"]
[7,6,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E9,'Change Readiness Questions'!E8:H$38,37-B22,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E9,'Change Readiness Questions'!E8:H$38,37-B22,FALSE))","v":"N"},{"$f":"IF(C22<>\"N\",C22*'Change Readiness Questions'!M8+(B22/36),0)","v":0},-1,{"$f":"IF(C22=1,'Change Readiness Questions'!J8,IF(C22=2,'Change Readiness Questions'!K8,\"\"))","v":""},"N"]
[8,7,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E10,'Change Readiness Questions'!E9:H$38,37-B23,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E10,'Change Readiness Questions'!E9:H$38,37-B23,FALSE))","v":"N"},{"$f":"IF(C23<>\"N\",C23*'Change Readiness Questions'!M9+(B23/36),0)","v":0},-1,{"$f":"IF(C23=1,'Change Readiness Questions'!J9,IF(C23=2,'Change Readiness Questions'!K9,\"\"))","v":""},"N"]
[9,8,{"$f":"IF(ISERROR(HLOOKUP('Organisational Readiness Qs'!E11,'Change Readiness Questions'!E10:H$38,37-B24,FALSE)),-1,HLOOKUP('Organisational Readiness Qs'!E11,'Change Readiness Questions'!E10:H$38,37-B24,FALSE))","v":"N"},{"$f":"IF(C24<>\"N\",C24*'Change Readiness Questions'!M10+(B24/36),0)","v":0},-1,{"$f":"IF(C24=1,'Change Readiness Questions'!J10,IF(C24=2,'Change Readiness Questions'!K10,\"\"))","v":""},"N"]
[10,9,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E3,'Change Readiness Questions'!E11:H$38,37-B25,FALSE)),-1,HLOOKUP('People Readiness Qs'!E3,'Change Readiness Questions'!E11:H$38,37-B25,FALSE))","v":"N"},{"$f":"IF(C25<>\"N\",C25*'Change Readiness Questions'!M11+(B25/36),0)","v":0},-1,{"$f":"IF(C25=1,'Change Readiness Questions'!J11,IF(C25=2,'Change Readiness Questions'!K11,\"\"))","v":""},"N"]
[11,10,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E4,'Change Readiness Questions'!E12:H$38,37-B26,FALSE)),-1,HLOOKUP('People Readiness Qs'!E4,'Change Readiness Questions'!E12:H$38,37-B26,FALSE))","v":"N"},{"$f":"IF(C26<>\"N\",C26*'Change Readiness Questions'!M12+(B26/36),0)","v":0},-1,{"$f":"IF(C26=1,'Change Readiness Questions'!J12,IF(C26=2,'Change Readiness Questions'!K12,\"\"))","v":""},"N"]
[12,11,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E5,'Change Readiness Questions'!E13:H$38,37-B27,FALSE)),-1,HLOOKUP('People Readiness Qs'!E5,'Change Readiness Questions'!E13:H$38,37-B27,FALSE))","v":"N"},{"$f":"IF(C27<>\"N\",C27*'Change Readiness Questions'!M13+(B27/36),0)","v":0},-1,{"$f":"IF(C27=1,'Change Readiness Questions'!J13,IF(C27=2,'Change Readiness Questions'!K13,\"\"))","v":""},"N"]
[13,12,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E6,'Change Readiness Questions'!E14:H$38,37-B28,FALSE)),-1,HLOOKUP('People Readiness Qs'!E6,'Change Readiness Questions'!E14:H$38,37-B28,FALSE))","v":"N"},{"$f":"IF(C28<>\"N\",C28*'Change Readiness Questions'!M14+(B28/36),0)","v":0},-1,{"$f":"IF(C28=1,'Change Readiness Questions'!J14,IF(C28=2,'Change Readiness Questions'!K14,\"\"))","v":""},"N"]
[14,13,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E7,'Change Readiness Questions'!E15:H$38,37-B29,FALSE)),-1,HLOOKUP('People Readiness Qs'!E7,'Change Readiness Questions'!E15:H$38,37-B29,FALSE))","v":"N"},{"$f":"IF(C29<>\"N\",C29*'Change Readiness Questions'!M15+(B29/36),0)","v":0},-1,{"$f":"IF(C29=1,'Change Readiness Questions'!J15,IF(C29=2,'Change Readiness Questions'!K15,\"\"))","v":""},"N"]
[15,14,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E8,'Change Readiness Questions'!E16:H$38,37-B30,FALSE)),-1,HLOOKUP('People Readiness Qs'!E8,'Change Readiness Questions'!E16:H$38,37-B30,FALSE))","v":"N"},{"$f":"IF(C30<>\"N\",C30*'Change Readiness Questions'!M16+(B30/36),0)","v":0},-1,{"$f":"IF(C30=1,'Change Readiness Questions'!J16,IF(C30=2,'Change Readiness Questions'!K16,\"\"))","v":""},"N"]
[16,15,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E9,'Change Readiness Questions'!E17:H$38,37-B31,FALSE)),-1,HLOOKUP('People Readiness Qs'!E9,'Change Readiness Questions'!E17:H$38,37-B31,FALSE))","v":"N"},{"$f":"IF(C31<>\"N\",C31*'Change Readiness Questions'!M17+(B31/36),0)","v":0},-1,{"$f":"IF(C31=1,'Change Readiness Questions'!J17,IF(C31=2,'Change Readiness Questions'!K17,\"\"))","v":""},"N"]
[17,16,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E10,'Change Readiness Questions'!E18:H$38,37-B32,FALSE)),-1,HLOOKUP('People Readiness Qs'!E10,'Change Readiness Questions'!E18:H$38,37-B32,FALSE))","v":"N"},{"$f":"IF(C32<>\"N\",C32*'Change Readiness Questions'!M18+(B32/36),0)","v":0},-1,{"$f":"IF(C32=1,'Change Readiness Questions'!J18,IF(C32=2,'Change Readiness Questions'!K18,\"\"))","v":""},"N"]
[18,17,{"$f":"IF(ISERROR(HLOOKUP('People Readiness Qs'!E11,'Change Readiness Questions'!E19:H$38,37-B33,FALSE)),-1,HLOOKUP('People Readiness Qs'!E11,'Change Readiness Questions'!E19:H$38,37-B33,FALSE))","v":"N"},{"$f":"IF(C33<>\"N\",C33*'Change Readiness Questions'!M19+(B33/36),0)","v":0},-1,{"$f":"IF(C33=1,'Change Readiness Questions'!J19,IF(C33=2,'Change Readiness Questions'!K19,\"\"))","v":""},"N"]
[19,18,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E3,'Change Readiness Questions'!E20:H$38,37-B34,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E3,'Change Readiness Questions'!E20:H$38,37-B34,FALSE))","v":"N"},{"$f":"IF(C34<>\"N\",C34*'Change Readiness Questions'!M20+(B34/36),0)","v":0},-1,{"$f":"IF(C34=1,'Change Readiness Questions'!J20,IF(C34=2,'Change Readiness Questions'!K20,\"\"))","v":""},"N"]
[20,19,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E4,'Change Readiness Questions'!E21:H$38,37-B35,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E4,'Change Readiness Questions'!E21:H$38,37-B35,FALSE))","v":"N"},{"$f":"IF(C35<>\"N\",C35*'Change Readiness Questions'!M21+(B35/36),0)","v":0},-1,{"$f":"IF(C35=1,'Change Readiness Questions'!J21,IF(C35=2,'Change Readiness Questions'!K21,\"\"))","v":""},"N"]
[21,20,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E5,'Change Readiness Questions'!E22:H$38,37-B36,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E5,'Change Readiness Questions'!E22:H$38,37-B36,FALSE))","v":"N"},{"$f":"IF(C36<>\"N\",C36*'Change Readiness Questions'!M22+(B36/36),0)","v":0},-1,{"$f":"IF(C36=1,'Change Readiness Questions'!J22,IF(C36=2,'Change Readiness Questions'!K22,\"\"))","v":""},"N"]
[22,21,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E6,'Change Readiness Questions'!E23:H$38,37-B37,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E6,'Change Readiness Questions'!E23:H$38,37-B37,FALSE))","v":"N"},{"$f":"IF(C37<>\"N\",C37*'Change Readiness Questions'!M23+(B37/36),0)","v":0},-1,{"$f":"IF(C37=1,'Change Readiness Questions'!J23,IF(C37=2,'Change Readiness Questions'!K23,\"\"))","v":""},"N"]
[23,22,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E7,'Change Readiness Questions'!E24:H$38,37-B38,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E7,'Change Readiness Questions'!E24:H$38,37-B38,FALSE))","v":"N"},{"$f":"IF(C38<>\"N\",C38*'Change Readiness Questions'!M24+(B38/36),0)","v":0},-1,{"$f":"IF(C38=1,'Change Readiness Questions'!J24,IF(C38=2,'Change Readiness Questions'!K24,\"\"))","v":""},"N"]
[24,23,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E8,'Change Readiness Questions'!E25:H$38,37-B39,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E8,'Change Readiness Questions'!E25:H$38,37-B39,FALSE))","v":"N"},{"$f":"IF(C39<>\"N\",C39*'Change Readiness Questions'!M25+(B39/36),0)","v":0},-1,{"$f":"IF(C39=1,'Change Readiness Questions'!J25,IF(C39=2,'Change Readiness Questions'!K25,\"\"))","v":""},"N"]
[25,24,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E9,'Change Readiness Questions'!E26:H$38,37-B40,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E9,'Change Readiness Questions'!E26:H$38,37-B40,FALSE))","v":"N"},{"$f":"IF(C40<>\"N\",C40*'Change Readiness Questions'!M26+(B40/36),0)","v":0},-1,{"$f":"IF(C40=1,'Change Readiness Questions'!J26,IF(C40=2,'Change Readiness Questions'!K26,\"\"))","v":""},"N"]
[26,25,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E10,'Change Readiness Questions'!E27:H$38,37-B41,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E10,'Change Readiness Questions'!E27:H$38,37-B41,FALSE))","v":"N"},{"$f":"IF(C41<>\"N\",C41*'Change Readiness Questions'!M27+(B41/36),0)","v":0},-1,{"$f":"IF(C41=1,'Change Readiness Questions'!J27,IF(C41=2,'Change Readiness Questions'!K27,\"\"))","v":""},"N"]
[27,26,{"$f":"IF(ISERROR(HLOOKUP('Process Readiness Qs'!E11,'Change Readiness Questions'!E28:H$38,37-B42,FALSE)),-1,HLOOKUP('Process Readiness Qs'!E11,'Change Readiness Questions'!E28:H$38,37-B42,FALSE))","v":"N"},{"$f":"IF(C42<>\"N\",C42*'Change Readiness Questions'!M28+(B42/36),0)","v":0},-1,{"$f":"IF(C42=1,'Change Readiness Questions'!J28,IF(C42=2,'Change Readiness Questions'!K28,\"\"))","v":""},"N"]
[28,27,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E3,'Change Readiness Questions'!E29:H$38,37-B43,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E3,'Change Readiness Questions'!E29:H$38,37-B43,FALSE))","v":"N"},{"$f":"IF(C43<>\"N\",C43*'Change Readiness Questions'!M29+(B43/36),0)","v":0},-1,{"$f":"IF(C43=1,'Change Readiness Questions'!J29,IF(C43=2,'Change Readiness Questions'!K29,\"\"))","v":""},"N"]
[29,28,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E4,'Change Readiness Questions'!E30:H$38,37-B44,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E4,'Change Readiness Questions'!E30:H$38,37-B44,FALSE))","v":"N"},{"$f":"IF(C44<>\"N\",C44*'Change Readiness Questions'!M30+(B44/36),0)","v":0},-1,{"$f":"IF(C44=1,'Change Readiness Questions'!J30,IF(C44=2,'Change Readiness Questions'!K30,\"\"))","v":""},"N"]
[30,29,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E5,'Change Readiness Questions'!E31:H$38,37-B45,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E5,'Change Readiness Questions'!E31:H$38,37-B45,FALSE))","v":"N"},{"$f":"IF(C45<>\"N\",C45*'Change Readiness Questions'!M31+(B45/36),0)","v":0},-1,{"$f":"IF(C45=1,'Change Readiness Questions'!J31,IF(C45=2,'Change Readiness Questions'!K31,\"\"))","v":""},"N"]
[31,30,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E6,'Change Readiness Questions'!E32:H$38,37-B46,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E6,'Change Readiness Questions'!E32:H$38,37-B46,FALSE))","v":"N"},{"$f":"IF(C46<>\"N\",C46*'Change Readiness Questions'!M32+(B46/36),0)","v":0},-1,{"$f":"IF(C46=1,'Change Readiness Questions'!J32,IF(C46=2,'Change Readiness Questions'!K32,\"\"))","v":""},"N"]
[32,31,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E7,'Change Readiness Questions'!E33:H$38,37-B47,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E7,'Change Readiness Questions'!E33:H$38,37-B47,FALSE))","v":"N"},{"$f":"IF(C47<>\"N\",C47*'Change Readiness Questions'!M33+(B47/36),0)","v":0},-1,{"$f":"IF(C47=1,'Change Readiness Questions'!J33,IF(C47=2,'Change Readiness Questions'!K33,\"\"))","v":""},"N"]
[33,32,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E8,'Change Readiness Questions'!E34:H$38,37-B48,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E8,'Change Readiness Questions'!E34:H$38,37-B48,FALSE))","v":"N"},{"$f":"IF(C48<>\"N\",C48*'Change Readiness Questions'!M34+(B48/36),0)","v":0},-1,{"$f":"IF(C48=1,'Change Readiness Questions'!J34,IF(C48=2,'Change Readiness Questions'!K34,\"\"))","v":""},"N"]
[34,33,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E9,'Change Readiness Questions'!E35:H$38,37-B49,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E9,'Change Readiness Questions'!E35:H$38,37-B49,FALSE))","v":"N"},{"$f":"IF(C49<>\"N\",C49*'Change Readiness Questions'!M35+(B49/36),0)","v":0},-1,{"$f":"IF(C49=1,'Change Readiness Questions'!J35,IF(C49=2,'Change Readiness Questions'!K35,\"\"))","v":""},"N"]
[35,34,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E10,'Change Readiness Questions'!E36:H$38,37-B50,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E10,'Change Readiness Questions'!E36:H$38,37-B50,FALSE))","v":"N"},{"$f":"IF(C50<>\"N\",C50*'Change Readiness Questions'!M36+(B50/36),0)","v":0},-1,{"$f":"IF(C50=1,'Change Readiness Questions'!J36,IF(C50=2,'Change Readiness Questions'!K36,\"\"))","v":""},"N"]
[36,35,{"$f":"IF(ISERROR(HLOOKUP('Technology Readiness Qs'!E11,'Change Readiness Questions'!E37:H$38,37-B51,FALSE)),-1,HLOOKUP('Technology Readiness Qs'!E11,'Change Readiness Questions'!E37:H$38,37-B51,FALSE))","v":"N"},{"$f":"IF(C51<>\"N\",C51*'Change Readiness Questions'!M37+(B51/36),0)","v":0},-1,{"$f":"IF(C51=1,'Change Readiness Questions'!J37,IF(C51=2,'Change Readiness Questions'!K37,\"\"))","v":""},"N"]
[null,36]