{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Assessment criteria","Assessment","Priority grid","Ranking"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Introduction","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["QGEA implementation prioritisation technique"]
["The QGEA implementation prioritisation technique was developed to demonstrate how Queensland Government departments can prioritise their implementation of QGEA policies. "]
[]
[]
["For further introductory information, please see the QGEA implementation prioritisation guideline."]
[]
["Licence"]
["This work is licensed under a Creative Commons Attribution 4.0 International licence. To view the terms of this licence, visit http://creativecommons.org/licenses/by/4.0/. For permissions beyond the scope of this licence, contact qgcio@qgcio.qld.gov.au. To attribute this material, cite the Queensland Government Chief Information Office. The licence does not apply to any branding or images."]

{"sheet":"Assessment criteria","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Assessment","index":2,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,1],[24,0,27,0],[28,0,28,8],[32,0,32,8],[0,0,1,16],[21,0,21,8],[29,0,31,0],[22,0,22,8],[2,0,2,8],[15,0,19,0],[6,0,7,0],[9,0,13,0]]}
["QGEA implementation prioritisation technique"]
[]
["Attractiveness criteria - Attractiveness measures the benefit of implementation of the policy to the department, its customers and its contribution to the department's and Queensland Government's direction.",null,null,null,null,null,null,null,null,"Policy A","Policy B","Policy C","Policy D","Policy E","Policy F","Policy G","Policy H"]
["Criteria","Sub criteria","Questions",0,1,2,3,4,5,"Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5"]
["Mandate\n\nThis criterion assesses the strength of the mandate for the policy. A mandate is a traceable, direction to develop and implement the policy.",null,"Does the policy have a mandate? How strong is the mandate for implementation of this policy?","No direct mandate OR mandate is unclear.","A Queensland Government CIO level governance body requested that this policy be developed.","A Queensland Government CEO level governance body requested this policy be developed.","There is a mandate from the Queensland Government Chief Information Officer.","There is a mandate from Cabinet, the Premier or Minister for Public Works and ICT; a relevant independent office (e.g. Queensland Audit Office); OR a formal requirement from a national body or inter-jurisdictional body.","There is a legislative mandate.",5,4,1,5,4,5,1,5]
["Total mandate",null,null,null,null,null,null,null,null,{"$f":"J5","v":5},{"$f":"K5","v":4},{"$f":"L5","v":1},5,4,5,1,5]
["Strategic alignment\n\nAssesses the degree to which the outcomes to be achieved from implementing the policy aligns with whole-of-government direction and departmental business direction.","Whole-of-government direction  (objectives for the community, priorities, whole-of-government strategies).","To what extent do the outcomes to be achieved from implementation of this policy align with whole-of-government direction?","The outcomes to be realised from the implementation of this policy do not link to whole-of-government direction.","The outcomes to be realised from implementation of this policy links to less than 25% of whole-of-government direction.","The outcomes to be realised from implementation of this policy links to between 25% and 50% of whole-of-government direction.","The outcomes to be realised from implementation of this policy links to between 50% and 75% of whole-of-government direction.",null,"The outcomes to be realised from implementation of this policy link to between 75% and 100% of whole-of-government direction.",5,5,4,3,3,4,2,4]
[null,"Departmental business direction (purpose, vision, objectives)","To what extent do the outcomes to be achieved from implementation of this policy align with the department's business direction?","The outcomes to be realised from the implementation of this policy does not link to the department's business direction.","The outcomes to be realised from implementation of this policy links to less than 25% of the department's business direction.","The outcomes to be realised from implementation of this policy links to between 25% and 50% of the department's business direction.","The outcomes to be realised from implementation of this policy links to between 50% and 75% of the department's business direction.",null,"The outcomes to be realised from implementation of this policy link to between 75% and 100% of the department's business direction.",5,4,3,3,3,4,4,4]
["Total strategic alignment",null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J8)/2","v":5},{"$f":"SUM(K7:K8)/2","v":4.5},3.5,3,3,4,3,4]
["Benefits and dis-benefits of implementation of the policy","Service delivery\n\nAssesses benefit to citizens/external clients who consume departmental services","Will the policy improve service delivery?","Implementation of this policy will be significantly detrimental to service delivery.","Implementation of this policy is expected to be detrimental to client service delivery.","Implementation of this policy is not expected to enhance the current delivery of services to clients.","Anecdotal evidence exists that implementation of this policy may support enhanced delivery of departmental services to clients.","Evidence exists to demonstrate that implementation of this policy will clearly support enhanced delivery of departmental services to clients.","Evidence exists to demonstrate that implementation of this policy will support significantly enhanced delivery of departmental services to clients.",5,5,2,4,4,3,2,5]
[null,"Community/social\n\nAssesses benefit to a community or society as a whole.","Will the policy benefit the community or society as a whole?","Implementation of this policy will be significantly detrimental to the community/society.","Implementation of this policy is expected to be detrimental to the community/society.","Implementation of this policy is not expected to deliver any community/social benefit/s.","Anecdotal evidence exists that implementation of this policy delivers community/social benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers community/social benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers significant community/social benefit/s.",5,5,2,2,3,3,1,5]
[null,"Environmental\n\nAssesses benefit to the environment (e.g. Green ICT).","Will the policy deliver any environmental benefits?","Implementation of this policy will be significantly detrimental to the environment.","Implementation of this policy is expected to be detrimental to the environment.","Implementation of this policy is not expected to deliver any environmental benefit/s.","Anecdotal evidence exists that implementation of this policy delivers environmental benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers environmental benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers significant environmental benefit/s.",5,4,3,2,2,3,5,1]
[null,"Fiscal\n\nAssesses fiscal benefit to Queensland.","Will the policy reduce government operating costs or increase its revenue?","Implementation of this policy will significantly decrease revenues and/or increase operating costs.","Implementation of this policy is expected to decrease revenues and/or increase operating costs.","Implementation of this policy is not expected to affect government revenues or operating costs.","Anecdotal evidence exists that implementation of this policy increases revenue and/or decreases operating costs.","Evidence exists to demonstrate that implementation of this policy will increase revenue and/or decrease operating costs.","Evidence exists to demonstrate that implementation of this policy will significantly increase revenue and/or decrease operating costs.",5,3,2,4,4,4,2]
[null,"Operational support\n\nAssesses operational benefit to department/government.\nNote: The focus in this element is on internal service delivery within the department (i.e. internal efficiencies) as opposed to service delivery to external clients.","Will the policy improve the efficiency of operational support services?","Implementation of this policy will be significantly detrimental to departmental operations.","Implementation of this policy is expected to be detrimental to departmental operations.","Implementation of this policy is not expected to deliver any departmental operational benefit/s.","Anecdotal evidence exists that implementation of this policy delivers departmental operational benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers departmental operational benefit/s.","Evidence exists to demonstrate that implementation of this policy delivers significant departmental operational benefit/s.",5,5,3,2,4,4,1,4]
["Total benefits",null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J14)/5","v":5},4.4000000000000004,2.4,2.8,3.4,3.4,2.2000000000000002,{"$f":"SUM(Q10:Q14)/5","v":3}]
["Risk of not implementing the policy\n\nWhat is the impact of not implementing the policy?","Service delivery\n\nWhat will be the impact of not implementing the policy on the delivery of departmental services to citizens/external clients?","Would not implementing the policy potentially impede service delivery in any way?","Departmental service delivery will be significantly better off.","Departmental service delivery will be better off.","No impact.","… will increase the likelihood of a threat to the delivery of departmental services, or distress to a client.","…will increase the likelihood of a significant threat to the delivery of departmental services, or distress to a client OR result in a minor or moderate negative impact on departmental service delivery or cause minor or moderate distress to a client.","…will significantly impede effective departmental service delivery or cause distress to a client.",5,5,2,2,4,4,1,2]
[null,"Community/social\n\nWhat will be the impact of not implementing the policy on the community or society as a whole?","Would not implementing the policy be potentially detrimental to the community or society? For example, could it cause a loss of confidence in the department/ government?","The community/society will be significantly better off.","The community will be better off.","No impact.","…will increase the likelihood of causing damage to community or social programs, public order and/or confidence in the department/government.","…will increase the likelihood of a significant damage to community or social programs, public order and/or confidence in the department/government OR will a minor or moderate impact on these.","…will have a significant negative impact on community or social programs, prejudice public order and/or cause a measurable loss of confidence in the department/government. ",5,4,3,4,4,4,1,2]
[null,"Environmental\n\nWhat will be the impact of not implementing the policy on the environment?","Would not implementing the policy be potentially detrimental to the environment?","The environment will be significantly better off.","The environment will be better off.","No impact.","…will increase the likelihood of causing damage to the environment.","…will increase the likelihood of causing significant damage to the environment OR there will be a minor or moderate negative impact on the environment.","…will have a significant negative impact on the environment.",5,3,2,2,4,3,2,1]
[null,"Fiscal\n\nWhat will be the impact of not implementing the policy on the department's fiscal position?","Would not implementing the policy potentially cost the department money?","The department will be in a significantly better financial position.","The department will be in a better financial position.","No impact.","…will increase the likelihood of causing a financial loss to the department.","…will increase the likelihood of causing significant financial loss to the department OR will cause a minor or moderate financial loss to the department.","…will cause a significant financial loss to the department.",5,5,3,1,4,3,2,2]
[null,"Operational support\n\nWhat will be the impact of not implementing the policy on departmental operations?\n\nNote: The focus in this element is on internal service delivery within the department (i.e. internal efficiencies) as opposed to service delivery to external clients.","Would not implementing the policy be detrimental to the efficiency of departmental operations?","Departmental operations will be significantly better.","Departmental operations will be better off.","No impact.","...will increase the likelihood of impeding effective development or operation of major departmental policy and/or cause a moderate increase in the department's risk.","…will increase the likelihood of significantly impeding effective development or operation of major departmental policy and/or cause a moderate increase in the government's risk OR will cause a minor or moderate negative impact on government operations.","…will cause a significant negative impact on departmental operations.",5,5,2,3,4,4,2,1]
["Total benefits",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J20)/5","v":5},4.4000000000000004,2.4,2.4,4,3.6,1.6,1.6]
["Total attractiveness score",null,null,null,null,null,null,null,null,{"$f":"SUM(J6,J9,J15,J21)/4","v":5},{"$f":"SUM(K6,K9,K15,K21)/4","v":4.3250000000000002},2.3250000000000002,3.3000000000000003,3.6,4,1.9500000000000002,3.4]
["Achievability criteria - achievability examines the ability of a department to implement the policy taking into consideration resourcing and level of change.",null,null,null,null,null,null,null,null,{"$f":"J3","v":"Policy A"},{"$f":"K3","v":"Policy B"},"Policy C","Policy D","Policy E","Policy F","Policy G","Policy H"]
["Criteria","Sub criteria","Questions",0,1,2,3,4,5,"Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5","Score out of 5"]
["Resource availability","People\n\nAvailability of people including skills and capability to support policy delivery.","Does the department have people available to implement the policy? Would they need training?","No current people are available within the department or centrally (i.e. whole-of-government) to support this initiative. External sourcing will be mandatory.","Department would need to reassign people to support this implementation, leading to other work being under resourced. Significant training and re-skilling required.","Department could find people with only minor impacts on other work. These people possess the required skills and capability. Some training required.","Department has people with the capacity to work on this policy. These people are highly experienced and capable.","There are some people available centrally (i.e. whole-of-government) to provide partial implementation support of this policy OR no people are required.","There are adequate resources available centrally (i.e. whole-of-government) to support implementation of this policy.",4,1,4,1,1,4,1,2]
[null,"Knowledge \n\n(Process/method/tools/techniques/information asset/tacit or explicit knowledge)","Does the department have the knowledge required to implement the policy?","There is no existing knowledge to assist the implementation of this policy.","There is limited existing knowledge to assist with the implementation of this policy. Significant knowledge acquisition may be required.","There is some existing knowledge that would assist with implementation of this policy. Substantial knowledge acquisition may be required.","There is substantial existing knowledge that would assist with the implementation of this policy. Some knowledge acquisition may be required.","There is significant existing knowledge that would assist with the implementation of this policy. Limited knowledge acquisition may be required.","There is a well understood body of knowledge that would assist implementation of this policy. Either no or limited knowledge acquisition may be required.",4,2,3,1,1,4,2,2]
[null,"Infrastructure \n\n(Building, Park, Site, Network, Plant, Venue, Node, Room, ICT)","Does the department require any ICT/infrastructure support? If so, is it available?","None of the infrastructure required to support implementation of this policy is available.","Department would need to acquire infrastructure to support implementation of this policy.","Department would need to reassign infrastructure to support implementation of this policy.","Current departmental infrastructure has the capacity to support implementation of this policy.","Infrastructure will be reassigned or acquired centrally (i.e. whole-of-government) to support implementation of this policy OR no infrastructure support is required.","Current centrally available (i.e. whole-of-government) infrastructure has the capacity to support the implementation of this policy.",4,3,5,1,2,4,1,2]
[null,"Funding\n\nAvailability of non-salary based funding to support policy implementation","Does the department need funds to implement the policy? If so, would most of them have the funds or be able to obtain them?","Required funding is unlikely or requirement or policy implementation requires new budget bids.","Required funding likely.","Required funding expected however additional budget is required. (i.e. Policy implementation cannot be funded from the current budget).","Required funding expected - budget can be found from sources.","Required funding guaranteed within current budget OR funding is not required.","Whole-of-Government funding is available.",4,4,5,1,1,3,2,3]
["Total resource availability",null,null,null,null,null,null,null,null,{"$f":"SUM(J25:J28)/4","v":4},{"$f":"SUM(K25:K28)/4","v":2.5},4.25,1,1.25,3.75,1.5,2.25]
["Implementation risk","Governance","Can the department govern implementation with their existing arrangements?","There is no implementation governance in place.","Governance arrangements could be developed with difficulty.","Governance arrangements could be developed without difficulty.","Existing governance arrangements could accommodate this with effort.","Existing governance arrangements could easily accommodate implementation governance requirements.","Governance is not required.",4,5,3,1,2,4,1,3]
[null,"Organisational and cultural change","To what extent does the implementation of the policy require organisational and cultural change?","There is substantial organisational change required AND/OR substantial cultural change will be required.","There is significant organisational change required AND/OR significant cultural change will be required.","There is moderate organisational change required AND/OR some cultural change will be required. ","There is minor organisational change required.","There is negligible organisational change required.","There is no organisational change required.",4,2,4,2,2,3,2,3]
[null,"Organisational support","Are there any objections within the department to implementation of this policy?","There is no support among the department for implementation of the policy and this is unlikely to change.","There is no support within the department for implementation of the policy however support may develop over time.","There is a small amount of support within the department however significant objections to the policy's implementation exist.","There is moderate support within the department for the policy's implementation however some objections to the policy's implementation exist.","There is extensive support within the department for the implementation of the policy and only minor objections exist.","There is extensive support within the department for the policy's implementation and no objections exist.",4,3,5,3,1,4,1,5]
["Total implementation risk",null,null,null,null,null,null,null,null,{"$f":"SUM(J30:J32)/3","v":4},{"$f":"SUM(K30:K32)/3","v":3.3333333333333335},4,2,1.6666666666666667,3.6666666666666665,1.3333333333333333,3.6666666666666665]
["Total achievability score",null,null,null,null,null,null,null,null,{"$f":"SUM(J29,J33)/2","v":4},{"$f":"SUM(K29,K33)/2","v":2.916666666666667},4.125,1.5,1.4583333333333335,3.708333333333333,1.4166666666666665,2.958333333333333]

{"sheet":"Priority grid","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
["High","Delay","Commit"]
[null,"Policy C","Policy A\nPolicy B\nPolicy F\nPolicy H"]
["Achievability","\n\n\nPolicy G","\nPolicy D\nPolicy E"]
["Low","Hold","Manage closely"]
[null,"Low","High"]
[null,"Attractiveness"]

{"sheet":"Ranking","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Initiative","Description","Attractiveness","Achievability","Ranking score","Priority action"]
[{"$f":"Assessment!J3","v":"Policy A"},null,{"$f":"Assessment!J22","v":5},{"$f":"Assessment!J34","v":4},{"$f":"IF($C2>=0,ROUND(SQRT(((6-$C2)*(6-$C2))+((6-$D2)*(6-$D2))),2),\"N/A\")","v":2.2400000000000002},{"$f":"PriorityAction(C2,D2)","v":"Commit"}]
[{"$f":"Assessment!K3","v":"Policy B"},null,{"$f":"Assessment!K22","v":4.3250000000000002},{"$f":"Assessment!K34","v":2.916666666666667},{"$f":"IF($C3>=0,ROUND(SQRT(((6-$C3)*(6-$C3))+((6-$D3)*(6-$D3))),2),\"N/A\")","v":3.51},"Commit"]
[{"$f":"Assessment!L3","v":"Policy C"},null,{"$f":"Assessment!L22","v":2.3250000000000002},{"$f":"Assessment!L34","v":4.125},4.13,"Delay"]
[{"$f":"Assessment!M3","v":"Policy D"},null,{"$f":"Assessment!M22","v":3.3000000000000003},{"$f":"Assessment!M34","v":1.5},5.25,"Manage Closely"]
[{"$f":"Assessment!N3","v":"Policy E"},null,{"$f":"Assessment!N22","v":3.6},{"$f":"Assessment!N34","v":1.4583333333333335},5.14,"Manage Closely"]
[{"$f":"Assessment!O3","v":"Policy F"},null,{"$f":"Assessment!O22","v":4},{"$f":"Assessment!O34","v":3.708333333333333},3.04,"Commit"]
[{"$f":"Assessment!P3","v":"Policy G"},null,{"$f":"ROUND(Assessment!P22,0)","v":2},{"$f":"ROUND(Assessment!P34,0)","v":1},6.4,"Hold"]
[{"$f":"Assessment!Q3","v":"Policy H"},null,{"$f":"Assessment!Q22","v":3.4},{"$f":"Assessment!Q34","v":2.958333333333333},4,"Commit"]