{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Start here","Dashboard","tmpActionPlan","Run - chart","Run - results","Action Plan","Organisational Notes","All Questions","All Choices","Action plan matrix","Config"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":1,"defined_names":45,"comments":1,"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":"Start here","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,2,13,4],[15,2,15,4],[21,2,22,4],[24,6,24,7],[24,8,24,9],[20,6,20,7],[20,8,20,9],[18,6,18,7],[18,8,18,9],[24,14,24,15],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[24,10,24,11],[24,12,24,13],[22,14,22,15],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[20,10,20,11],[20,12,20,13],[20,14,20,15],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[18,10,18,11],[18,12,18,13],[18,14,18,15],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[16,14,16,15],[16,12,16,13],[16,10,16,11],[16,8,16,9],[16,6,16,7],[13,10,13,11],[13,12,13,13],[13,14,13,15],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[13,6,13,7],[13,8,13,9],[7,2,7,15],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[9,14,9,15],[9,12,9,13],[9,10,9,11],[9,8,9,9],[9,6,9,7],[11,2,11,4],[15,19,16,19],[15,20,16,21],[15,22,16,23],[11,22,12,23],[13,19,14,19],[13,20,14,21],[13,22,14,23],[11,19,12,19],[11,20,12,21],[6,19,7,19],[6,20,7,21],[6,22,7,23],[8,20,8,21],[8,22,8,23],[1,2,1,15],[2,19,2,23],[3,20,3,21],[3,22,3,23],[4,19,5,19],[4,20,5,21],[4,22,5,23],[3,2,3,15],[4,2,5,15]]}
[]
[null,null,"Introduction to the Climate Change Assessment Tool (CCAT)\n\nWritten for Scottish Public Sector organisations, the aim of this toolkit is to help your organisation self-evaluate performance under the Climate Change (Scotland) Act Public Sector duties, identify the key priority areas and actions for improvement and prepare yourselves for 2020 and beyond.\n\nFor organisations that are still developing their climate change processes, putting effective foundations in place in terms of governance, data, staff training and communications will help prepare for climate change leadership after 2020. For organisations with a desire for a more sophisticated, integrated approach to climate change, there is a range of activities that can be undertaken, appropriate to readiness and objectives. \n\nCCAT uses your organisation's responses to questions to create a targeted and achievable action plan to help guide short-term improvement. This can form the basis of discussion within your organisation and should help prioritise the most effective actions for performance improvement. Action plans are for the year ahead and can be reviewed and refined year on year in readiness for 2020."]
[]
[null,null,"Organisation Name:"]
[null,null,"Enter organisation name here"]
[]
[]
[null,null,"Personnel"]
[]
[null,null,null,null,null,null,1,null,2,null,3,null,4,null,5]
[]
[null,null,"Run Date"]
[]
[null,null,"Facilitator (name)"]
[]
[null,null,"Participants (names)"]

{"sheet":"Dashboard","index":1,"n_rows":18,"n_cols":35,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,14,17,15],[1,2,2,11],[1,12,2,12],[15,21,16,22],[17,21,18,22],[8,21,8,22],[8,19,8,20],[7,18,7,22],[13,14,15,14],[13,15,15,15],[9,14,10,15],[9,18,10,18],[11,18,12,18],[13,18,14,18],[15,18,16,18],[17,18,18,18],[9,19,10,20],[11,19,12,20],[13,19,14,20],[15,19,16,20],[17,19,18,20],[5,2,6,15],[9,21,10,22],[11,21,12,22],[13,21,14,22],[17,2,17,3],[17,5,17,6],[17,8,17,9],[17,11,17,12],[13,3,15,3],[13,6,15,6],[13,9,15,9],[13,12,15,12],[13,2,15,2],[13,5,15,5],[13,8,15,8],[13,11,15,11]]}
[]
[null,null,"CCAT: Climate Change Assessment Tool",null,null,null,null,null,null,null,null,null,"v5.1"]
[]
[]
[]
[null,null,{"$f":"'Start here'!C5","v":"Enter organisation name here"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114, 198, 199",{"$f":"\"RGB(\" & AH9 & \")\"","v":"RGB(114, 198, 199)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"122, 184, 0",{"$f":"\"RGB(\" & AH10 & \")\"","v":"RGB(122, 184, 0)"}]
[null,null,1,7,null,0,4,null,0,5,null,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"191, 255, 143",{"$f":"\"RGB(\" & AH11 & \")\"","v":"RGB(191, 255, 143)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"146, 205, 220",{"$f":"\"RGB(\" & AH12 & \")\"","v":"RGB(146, 205, 220)"}]
[]
[null,null,0,7,null,0,6,null,0,6,null,0,5,null,0,4]
[]
[]
[]
[null,null,{"$f":"'All Choices'!AL3","v":0},null,null,{"$f":"'All Choices'!AL4","v":0},null,null,{"$f":"'All Choices'!AL5","v":0},null,null,{"$f":"'All Choices'!AL6","v":0},null,null,{"$f":"'All Choices'!AL7","v":0}]

{"sheet":"tmpActionPlan","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[12,"3a","i","Aims and objectives of the climate change adaptation process have been identified.","NO","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3]
[13,"3a","ii","A business case for tackling climate change adaptation has been put together.","NO","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3]
[14,"3a","iii","Internal governance for adaptation arrangements has been established.","NO","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3]
[15,"3a","iv","External partnerships for developing and delivering adaptation work have been set up.","NO","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3]
[16,"3a","v","Adaptation risk has been defined and embedded within Corporate Risk Register to help gain organisational buy-in.","NO","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3]
[19,"1c",2,"All mandatory external reporting requirements are up to date.","SELECTED","Identify voluntary external reporting requirements and identify ways that these can help your organisation with both communication and performance reporting.",3]
[25,"3b","i","Our organisation has understood recent climate change trends and UKCPO9 headline messages.","NO","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3]
[26,"3b","ii","We have issued a screening questionnaire to Service Managers to help identify key staff to attend a workshop.","NO","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3]
[27,"3b","iii","We have run a climate change adaptation workshop with relevant Service Managers.","NO","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3]
[28,"3b","iv","Service Managers have completed impact assessments for selected relevant services.","NO","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3]
[29,"3b","v","The individual impact assessments have been collated into a summary report for Senior Management.","NO","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3]
[31,"1b",2,"Chief Executive has overall accountability for carbon reduction targets and has signed a Climate Change Declaration or statement of intent.","SELECTED","Widen out the remit of carbon reduction to include climate change adaptation.",2]
[41,"3c","i","We have conducted a climate change risk assessment for priority threats and opportunities.","NO","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3]
[42,"3c","ii","We have identified and prioritised actions.","NO","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3]
[43,"3c","iii","We have service-level risk assessments and action plans in place.","NO","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3]
[73,"4b",1,"Staff with a direct climate change remit understand your organisation's priorities but are unsure about appropriate actions.","SELECTED","Focus on communication and empowerment of staff to identify and take appropriate actions to increase resource efficiency and mitigate climate change risk. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12]
[76,"4e",1,"Some of the key services delivered by our organisation have been assessed for climate change impacts but there are no formal process in place for incorporating these into service improvement plans.","SELECTED","Look at ways to extend the range of services that are assessed for climate change impacts and to formalise the process for assessing climate change impacts and identifying appropriate actions. Identify effective ways to monitor and evaluate the impact of the service improvement plans and communicate these to other services within the organisation. Consider using ISM approach and principles to help identify behavourial barriers and to target actions.",12]
[77,"5a",1,"Our organisation has recently (within the previous year) completed the Flexible Framework Assessment Tool and has reached at least Level 1 or 2 across all 5 categories (People, Policy, Process, Suppliers, Results) and has an action plan in place to achieve Level 3 status within the next assessment period.","SELECTED","Develop a process for documenting the sustainability and carbon assessment and the decisions reached.",6]
[78,"5b",1,"Procurement strategy contains commitment to consider the carbon cost of goods and services but no documented evidence of being action actually being taken.","SELECTED","Document decisions and monitor outcomes to collect evidence for implementing a more formal process of evaluation.",6]
[79,"5c",1,"Only very significant projects are subject to limited carbon appraisal but additional funding rarely made available to incorporate resource and energy efficiency improvements.","SELECTED","Widen remit to include a greater range of projects, including refurbishment. Carefully document decisions and monitor outcomes to collect evidence for future decisions.",12]
[82,"1e",2,"The existing corporate business plan contains climate change actions as part of overall environmental commitment. All committee reports contain a requirement to consider environmental implications of new proposals but reviewers have limited knowledge of climate change mitigation and adaptation.","SELECTED","Identify staff with the skill set to review organisational strategy documents and identify environmental impacts and also ways to improve objectives. If this skill set can be identified internally, make sure they are allocated time and resources for this task. Build staff capacity and expertise in using the ISM approach to identify barriers and constraints to change and to develop an action plan. ",6]
[83,"1f",2,"Our organisation has an internal climate change communication strategy but no formal assessment of effectiveness is undertaken.","SELECTED","Work with appropriate departments to develop and implement a methodology for measuring the effectiveness of the communication strategy.",3]
[85,"4a",2,"Formal plans are in place to introduce climate change actions as part of competency requirements for selected staff with significant climate change remit within their job function.","SELECTED","Select a range of roles and draw up competency requirements in partnership with HR and staff representatives. Work with HR and staff representatives to get these incorporated into job descriptions. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12]
[87,"4c",2,"Informal group of climate change champions cover some strategically important sites but given limited resources to disseminate / embed climate change policies and practices across sites and networks.","SELECTED","Work with climate change champions and managers to identify and provide the resources required for them to successfully implement the actions. Monitor to demonstrate effectiveness. Use the ISM approach to design and develop the pilot project, identify current barriers and devise an action plan.",6]
[88,"4d",2,"Energy budgets are devolved to Departmental Directors and Group Managers who have designated emission reduction responsibilities but limited opportunities to actually control these emissions.","SELECTED","Develop accessible energy data systems for staff to access. Devolve control for relevant emissions in their operational area to appropriate staff. Make sure that sufficient support and training is available. Investigate widening energy budgets to cover other emission sources e.g. transport. Use ISM approach and principles to ensure that potential behavioural barriers are identified and needs are addressed in context of individual, social and material contexts.  ",12]
[93,"5d",2,"We have a climate change risk assessment process for some projects that are subject to financial appraisal, however, there is limited additional funding made available for more resilient building specifications.","SELECTED","Widen the remit to include a greater range of projects, including refurbishment projects. Carefully document decisions and monitor outcomes to collect evidence to support future risk assessments and aim to fund more resilient building specifications at a level likely to result in payback over the project lifetime.",12]
[94,"1a",3,"Climate change action is one of your organisation’s key objectives and is seen as a priority but it is not clear how Senior Management are accountable for achieving targets and implementing plans.","SELECTED","Work with the Carbon Management Board or equivalent to clarify accountability for meeting targets and implementing plans.",2]
[96,"3e","i","We have collated and reported our organisation's adaptation arrangements through internal mechanisms.","NO","Complete Step 4 of 5 Steps to Managing your Climate Risks.",6]
[97,"3e","ii","We have embedded climate risk assessment into existing organisational processes.","NO","Complete Step 4 of 5 Steps to Managing your Climate Risks.",6]
[98,"3e","iii","We review our climate change risk assessment and arrangements on an annual basis.","NO","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6]
[99,"3e","iv","We critically evaluate the progress made in implementation and discuss whether new actions are required to manage risk.","NO","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6]
[100,"3e","v","We communicate our adaptation arrangements to staff, partners and the wider community and invite feedback and joint working.","NO","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6]
[105,"1d",3,"Relevant reports detailing progress against targets are peer-reviewed by another organisation.","SELECTED","Consider whether key external reports or the underlying dataset would benefit from an external audit process, even if this was a one-off event and subsequently peer-review was continued.",3]
[108,"1g",3,"Carbon Manager or equivalent reviews carbon performance against carbon reduction targets and develops a carbon management improvement programme of actions supported and signed off by Corporate Management Team.","SELECTED","Widen scope of performance improvement to include climate change adaptation.",3]

{"sheet":"Run - chart","index":3,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,15],[8,1,8,5],[2,6,3,13],[1,6,1,9]]}
[]
[null,"Climate Change Assesment Tool results",null,null,null,null,"Organisation Name"]
[null,"Date of assessment",null,{"$f":"'Start here'!G12","v":"00:00:00"},null,null,{"$f":"'Start here'!C5","v":"Enter organisation name here"}]
[null,"Facilitator",null,{"$f":"'Start here'!G14","v":0}]
[null,"Assessment team",null,{"$f":"'Start here'!G16","v":0},null,{"$f":"'Start here'!G18","v":0},null,null,{"$f":"'Start here'!G20","v":0},null,null,{"$f":"'Start here'!G22","v":0},null,null,{"$f":"'Start here'!G24","v":0}]
[null,null,null,{"$f":"'Start here'!G17","v":0},null,{"$f":"'Start here'!G19","v":0},null,null,{"$f":"'Start here'!G21","v":0},null,null,{"$f":"'Start here'!G23","v":0},null,null,{"$f":"'Start here'!G25","v":0}]
[]
[]
[null,"Overall results - Run 1"]
[null,null,"Organisation score","Total score available","Percentage score","Traffic light assessment"]
[null,"Governance",{"$f":"SUM('All Choices'!V3:V37)","v":0},{"$f":"'All Choices'!AM3","v":28},{"$f":"'All Choices'!AL3","v":0},{"$f":"E11","v":0}]
[null,"Emissions",{"$f":"SUM('All Choices'!V38:V67)","v":0},{"$f":"'All Choices'!AM4","v":30},{"$f":"'All Choices'!AL4","v":0},{"$f":"E12","v":0}]
[null,"Adaptation",{"$f":"SUM('All Choices'!V68:V95)","v":0},{"$f":"'All Choices'!AM5","v":28},{"$f":"'All Choices'!AL5","v":0},0]
[null,"Behaviour",{"$f":"SUM('All Choices'!V96:V120)","v":0},{"$f":"'All Choices'!AM6","v":20},{"$f":"'All Choices'!AL6","v":0},0]
[null,"Procurement",{"$f":"SUM('All Choices'!V121:V140)","v":0},{"$f":"'All Choices'!AM7","v":16},{"$f":"'All Choices'!AL7","v":0},0]
[null,"Overall",{"$f":"SUM(C11:C15)","v":0},{"$f":"SUM(D11:D15)","v":122},{"$f":"C16/D16","v":0},0]

{"sheet":"Run - results","index":4,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[21,1,21,5],[30,1,30,5],[38,1,38,5],[2,1,2,5],[12,1,12,5]]}
[]
[]
[null,"Results for Governance"]
[null,"Question number","Question","Stage","Response","Organisational notes"]
[null,{"$f":"'All Questions'!E3","v":"1a"},{"$f":"'All Questions'!D3","v":"How committed is your organisation to climate change action?"}]
[null,{"$f":"'All Questions'!E4","v":"1b"},{"$f":"'All Questions'!D4","v":"How far up does accountability for climate change action extend in your organisation?"}]
[null,{"$f":"'All Questions'!E5","v":"1c"},{"$f":"'All Questions'!D5","v":"How well has your organisation completed external reporting requirements?"}]
[null,{"$f":"'All Questions'!E6","v":"1d"},{"$f":"'All Questions'!D6","v":"Does your organisation have an audit process for climate change reporting?"}]
[null,{"$f":"'All Questions'!E7","v":"1e"},{"$f":"'All Questions'!D7","v":"How well is climate change action embedded in organisational plans, policies and strategies?"}]
[null,{"$f":"'All Questions'!E8","v":"1f"},{"$f":"'All Questions'!D8","v":"Does your organisation have a communications strategy for climate change action?"}]
[null,{"$f":"'All Questions'!E9","v":"1g"},{"$f":"'All Questions'!D9","v":"Does your organisation have a performance improvement process for climate change action?"}]
[]
[null,"Results for Emissions"]
[null,"Question number","Question"]
[null,{"$f":"'All Questions'!E10","v":"2a"},{"$f":"'All Questions'!D10","v":"Does your Carbon Management Plan have a realistic target and strategy for achieving reductions?"}]
[null,{"$f":"'All Questions'!E11","v":"2b"},{"$f":"'All Questions'!D11","v":"Does your organisation have a coherent set of targets for other activities or emission sources?"}]
[null,{"$f":"'All Questions'!E12","v":"2c"},{"$f":"'All Questions'!D12","v":"Do you have an effective Carbon Management process?"}]
[null,{"$f":"'All Questions'!E13","v":"2d"},{"$f":"'All Questions'!D13","v":"Do you have systems to collect appropriate data to calculate your carbon footprint?"}]
[null,{"$f":"'All Questions'!E14","v":"2e"},{"$f":"'All Questions'!D14","v":"How well are you tracking your carbon footprint?"}]
[null,{"$f":"'All Questions'!E15","v":"2f"},{"$f":"'All Questions'!D15","v":"Are you successfully implementing a Carbon Management Project Register that is likely to meet your CM Plan reduction target?"}]
[]
[null,"Results for Adaptation"]
[null,"Question number","Question"]
[null,{"$f":"'All Questions'!E16","v":"3a"},{"$f":"'All Questions'!D16","v":"Have you defined the challenges of climate change adaptation?"}]
[null,{"$f":"'All Questions'!E17","v":"3b"},{"$f":"'All Questions'!D17","v":"Have you assessed climate change threats and opportunities?"}]
[null,{"$f":"'All Questions'!E18","v":"3c"},{"$f":"'All Questions'!D18","v":"Have you assessed climate change risks and identified actions?"}]
[null,{"$f":"'All Questions'!E19","v":"3d"},{"$f":"'All Questions'!D19","v":"Which specific risk areas have you considered?"}]
[null,{"$f":"'All Questions'!E20","v":"3e"},{"$f":"'All Questions'!D20","v":"Have you reported and implemented your adaptation arrangements and do you have processes for monitoring and review?"}]
[null,{"$f":"'All Questions'!E21","v":"3f"},{"$f":"'All Questions'!D21","v":"Has your organisation identified its responsibilities under the Scottish Climate Change Adaptation Programme (SCCAP) objectives?"}]
[]
[null,"Results for Behaviour"]
[null,"Question number","Question"]
[null,{"$f":"'All Questions'!E22","v":"4a"},{"$f":"'All Questions'!D22","v":"To what extent is climate change action embedded in staff competencies across your organisation?"}]
[null,{"$f":"'All Questions'!E23","v":"4b"},{"$f":"'All Questions'!D23","v":"How effective has your internal communication of climate change action been at influencing  staff behaviour?"}]
[null,{"$f":"'All Questions'!E24","v":"4c"},{"$f":"'All Questions'!D24","v":"How much dedicated resources do you have for championing climate change action?"}]
[null,{"$f":"'All Questions'!E25","v":"4d"},{"$f":"'All Questions'!D25","v":"How well does your organisation devolve responsibility for meeting carbon reduction targets?"}]
[null,{"$f":"'All Questions'!E26","v":"4e"},{"$f":"'All Questions'!D26","v":"Has your organisation considered how to reduce the climate change impact of service delivery?"}]
[]
[null,"Results for Procurement"]
[null,"Question number","Question"]
[null,{"$f":"'All Questions'!E27","v":"5a"},{"$f":"'All Questions'!D27","v":"Has your organisation completed the Flexible Framework Assessment Tool?"}]
[null,{"$f":"'All Questions'!E28","v":"5b"},{"$f":"'All Questions'!D28","v":"How integral are resource efficiency considerations to procurement decisions for goods and services?"}]
[null,{"$f":"'All Questions'!E29","v":"5c"},{"$f":"'All Questions'!D29","v":"How integral are resource efficiency considerations to decisions about capital and maintenance budget expenditure?"}]
[null,{"$f":"'All Questions'!E30","v":"5d"},{"$f":"'All Questions'!D30","v":"To what extent does climate change adaptation risk influence decisions about capital and maintenance budget expenditure?"}]

{"sheet":"Action Plan","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Action priority","Question","Part","Question","Response","Suggested Action","Timescale to complete (months)"]

{"sheet":"Organisational Notes","index":6,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,1,0,5]]}
[null,"Organisational Notes"]
["Question Key",1,2,3,4,5]
["1a"]
["1b"]
["1c"]
["1d"]
["1e"]
["1f"]
["1g"]
["2a"]
["2b"]
["2c"]
["2d"]
["2e"]
["2f"]
["3a"]
["3b"]
["3c"]
["3d"]
["3e"]
["3f"]
["4a"]
["4b"]
["4c"]
["4d"]
["4e"]
["5a"]
["5b"]
["5c"]
["5d"]

{"sheet":"All Questions","index":7,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Topic","Question number","Question Text","Question Key","Question Type","Topic Text","Help text"]
[null,1,"a","How committed is your organisation to climate change action?",{"$f":"B3&C3","v":"1a"},"PICK ONE","Governance","An organisation’s key objectives are likely to be listed in the corporate plan or equivalent document (e.g. strategic plan, business plan etc.). It is considered important to have an explicit mention of climate change within these objectives and for it to be clearly documented (either in the corporate plan, or referenced elsewhere) how these objectives will be achieved and who within the organisation is accountable for achieving them. Climate change in this context should include both mitigation (reducing the organisation’s impact on climate change) and adaptation (reducing the impact of climate change on the organisation).\nThe corporate plan might also reference other documents within the organisation where climate change objectives are stated but it is considered better practice to have clearly stated these within the main document."]
[null,1,"b","How far up does accountability for climate change action extend in your organisation?",{"$f":"B4&C4","v":"1b"},"PICK ONE","Governance","Accountability is defined as the obligation of an organisation or named individual to account for its activities, accept responsibility for them and disclose the results in a transparent manner. Accountability can be defined as the ultimate responsibility. \nIn order for climate change action to be given priority, resources and funding, the Chief Executive, or equivalent, needs to accept overall accountability for delivering against carbon reduction targets and adaptation programmes. \nAccountability is defined as the obligation of an organisation or named individual to account for its activities, accept responsibility for them and disclose the results in a transparent manner. Accountability can be defined as the ultimate responsibility. \nIn order for climate change action to be given priority, resources and funding, the Chief Executive, or equivalent, needs to accept overall accountability for delivering against carbon reduction targets and adaptation programmes. "]
[null,1,"c","How well has your organisation completed external reporting requirements?",{"$f":"B5&C5","v":"1c"},"PICK ONE","Governance","This question is aimed at helping organisations understand where they are with respect to climate change reporting; most organisations should be meeting at least Level 2 which is that all mandatory reporting is up to date. If not, this is the area which requires immediate action and it will be flagged up in your action plan. The most advanced organisations will see reporting as an opportunity to actively inform and engage internally and externally.\nThe reporting requirements will depend on, among other factors, your sector, the size of your organisation and whether you are listed as a Major Player in terms of the Public Sector Duties in Part 4 of the Climate Change (Scotland) Act. It is important therefore for each organisation to draw up a full list of reporting obligations. It is suggested that this is done before running each CCAT workshop so that there is a list to refer to. Remember to include adaptation as well as mitigation reports and to flag up whether reports are mandatory and voluntary. "]
[null,1,"d","Does your organisation have an audit process for climate change reporting?",{"$f":"B6&C6","v":"1d"},"PICK ONE","Governance","As reporting your organisation’s emissions and climate change activity becomes part of the mandatory landscape, there is likely to be an increased appetite for GHG auditing (verification/validation of GHG inventory) which helps the organisation have confidence in the data that is being published. In addition, auditing can help identify process improvements in terms of data collection, management and documentation or it can identify underlying trends that the organisation has not yet spotted. Auditing can be an internal process, it can use peers within the sector, or it can be external."]
[null,1,"e","How well is climate change action embedded in organisational plans, policies and strategies?","1e","PICK ONE","Governance","Climate change needs to break out of specific areas to become a successful campaign. That means that all activities within your organisation need to be considered in light of climate change mitigation and adaptation and evaluated to see if there is a way to amend these plans, policies and strategies in order to achieve objectives in a more sustainable manner. "]
[null,1,"f","Does your organisation have a communications strategy for climate change action?","1f","PICK ONE","Governance","As an organisation you might be successfully implementing strategies and plans to reduce your emissions and adapt to climate change but if awareness of activities, successes and challenges is limited to a small team of active participants, it will be difficult to achieve future emissions targets and maintain momentum.\nCommunication about climate change action is a key area. A communication strategy needs to have both internal and external components and to consider the variety of audiences."]
[null,1,"g","Does your organisation have a performance improvement process for climate change action?","1g","PICK ONE","Governance","A performance improvement process is designed to identify where the organisation is succeeding and where it is failing against key objectives. The timing of the performance improvement process needs to be carefully scheduled to enable evaluation of key results and information but in time for useful changes to be made. CCAT can be used as both an evaluation tool and action plan for improvement."]
[null,2,"a","Does your Carbon Management Plan have a realistic target and strategy for achieving reductions?","2a","AGREE/DISAGREE","Emissions","This set of statements are all related to your organisation’s Carbon Management Plan. This document might be called a different name but it will relate to your organisation’s corporate emissions (also known as your carbon footprint or greenhouse gas inventory) and will cover emissions that your organisation is responsible for through its activities (both direct and indirect). \nCarbon Management Plans provide a summary of your organisation’s baseline emissions, and enable activity to be focussed towards delivering and implementing change that reduces greenhouse gas emissions, improves organisational efficiency and ensures environmental performance in line with internal policies and national targets.\nFor a Carbon Management Plan to be effective, it needs to have clearly stated drivers, objectives and strategy, a target based on a realistic forecast of Business As Usual and an achievable project list with agreed funding. The Carbon Management Plan should also have a clear governance and operational structure, enabling users to see how responsibilities and tasks are allocated and timetabled. A good Carbon Management Plan will be an instruction manual of how to implement carbon management over the time period of the target. \n"]
[null,2,"b","Does your organisation have a coherent set of targets for other activities or emission sources?","2b","AGREE/DISAGREE","Emissions","Many organisations will have specific targets for certain emission sources or activities; in some cases these targets are cost driven e.g. reducing expenditure on business travel. Other cases may be externally mandated e.g. energy saving targets driven by the Scottish Government’s Energy Efficient Action Plan. As part of the forthcoming mandatory reporting under the Climate Change Duties, organisations will be expected to report the range of targets that will have an impact on their emissions reporting. It is advisable to collate this information and work out whether the target set is coherent e.g. are the targets based on the same boundary as the carbon reduction target and are they broadly aimed at decreasing emissions by the same amount over the same time period. If they are not coherent e.g. the annual energy saving target is much lower than would be required to meet the carbon management plan target, this needs to be noted. \nThe other advantage of identifying targets driving different areas of the organisation is that projects and policies aimed at achieving these targets can be included within the carbon reduction project list and the staff responsible can be brought into the carbon management process. This helps make overall climate change action more comprehensive and wide-ranging rather than limiting it only to the energy team. "]
[null,2,"c","Do you have an effective Carbon Management process?","2c","AGREE/DISAGREE","Emissions","The process part of your Carbon Management Plan is the part that describes who does what and when. To achieve and monitor emissions reductions, there needs to be a process to identify, prioritise, fund, implement and monitor carbon reduction projects. A process to collect emissions data, calculate your carbon footprint accurately and report on progress is also required. In addition to these key tasks, there are other activities that are likely to need to take place around governance and communication."]
[null,2,"d","Do you have systems to collect appropriate data to calculate your carbon footprint?","2d","AGREE/DISAGREE","Emissions","This set of statements is around having systems in place to collect appropriate data to calculate your corporate carbon footprint. As a minimum, this should include Scope 1 and 2 sources (as defined in the GHG protocol), however, it is also recommended that organisations assess which Scope 3 emission sources they have control over and develop appropriate systems to collect data for these sources."]
[null,2,"e","How well are you tracking your carbon footprint?","2e","AGREE/DISAGREE","Emissions","These set of statements are based around having a documented boundary (both organisational and operational), data collection regime and emission factors to be able to calculate and report your carbon footprint on an annual basis with confidence. "]
[null,2,"f","Are you successfully implementing a Carbon Management Project Register that is likely to meet your CM Plan reduction target?","2f","AGREE/DISAGREE","Emissions","A project register should contain all the projects within your organisation that are likely to reduce emission sources that are within your carbon footprint boundary, even if responsibility for implementation of these project is not directly held by your team. "]
[null,3,"a","Have you defined the challenges of climate change adaptation?","3a","YES/NO","Adaptation","Step 1: Define the challenge helps you to define the scope and governance of your adaptation planning arrangements. You will focus your efforts on your organisation’s critical functions or core services – the things that you must protect.\nSetting a boundary for your adaptation planning arrangements allows you to focus your limited time and resources on essential services. Once you have completed the five steps, gained political buy-in and built momentum, you will be well placed to look beyond these essential services (5 steps to managing your climate risks: a guide for public bodies)."]
[null,3,"b","Have you assessed climate change threats and opportunities?","3b","YES/NO","Adaptation","Step 2: Assess climate threats and opportunities helps you to understand how your organisation’s critical functions have been affected by recent severe weather impacts, and to consider how they might be affected in a future climate. Step 2 is completed mainly through a workshop with Service Managers who are identified through a screening questionnaire. \nBefore you can begin implementing adaptation actions, you need to understand the priority threats and opportunities that you face. Step 2 helps you to do this, and focus your limited time and resources on essential services. Once you have completed the five steps, gained political buy-in and built momentum, you will be well placed to look beyond these essential services (5 steps to managing your climate risks: a guide for public bodies)."]
[null,3,"c","Have you assessed climate change risks and identified actions?","3c","YES/NO","Adaptation","Step 3: Assess climate risks and identify actions helps you support Service Managers to carry out a climate change risk assessment for the most significant threats and opportunities identified in Step 2. This enables you to assign a scoring to each threat and opportunity based on its probability and consequences. Once you have agreed the risks that you need to manage, you will help to identify further actions. Work closely with your Risk Manager throughout Step 3. A climate change risk assessment allows you to focus limited resources on managing priority threats and opportunities (5 steps to managing your climate risks: a guide for public bodies). "]
[null,3,"d","Which specific risk areas have you considered?","3d","YES/NO","Adaptation","This set of statements looks at some of the more specific risk areas that organisations need to consider in terms of their own estate and delivery of services. Not all the risk areas are relevant to every organisation and the extent to which climate change effects are likely to be experienced is also dependant on the projected timescale and the location. To find out more about UK Climate Projections, see the Scottish Compendium of UKCP09 Climate Change Information."]
[null,3,"e","Have you reported and implemented your adaptation arrangements and do you have processes for monitoring and review?","3e","YES/NO","Adaptation","Step 4: report and implement is about how you report and implement your adaptation arrangements. You should be able to collate this evidence reasonably quickly if you completed each of the milestones. Always use existing processes to report and implement your arrangements. It is essential that you capture all your work in one location for ease of reference. Remember that it must not sit in isolation; it must interact with other corporate strategies. \nStep 5: Monitor and review helps you to establish a regular monitoring and review process, and to communicate your progress to others. Monitoring is essential to keep your adaptation arrangements up-to-date, to understand whether you are achieving your aims and objectives, and whether your actions are appropriate and cost-effective (5 steps to managing your climate risks: a guide for public bodies)."]
[null,3,"f","Has your organisation identified its responsibilities under the Scottish Climate Change Adaptation Programme (SCCAP) objectives?","3f","YES/NO","Adaptation","For each of the policies/proposals listed within the Scottish Climate Change Adaptation Programme, the organisations who are partially or fully responsible for delivering these are listed. Organisations therefore need to examine the SCCAP in detail to identify their responsibilities, if any, and then develop plans to deliver these policies and proposals. "]
[null,4,"a","To what extent is climate change action embedded in staff competencies across your organisation?","4a","PICK ONE","Behaviour","A competency is a set of defined behaviours that provide a structured guide enabling the identification, evaluation and development of the behaviours in individual employees. For staff to be fully engaged with climate change action, both in terms of adaptation and mitigation, it is useful to have a written description of both the knowledge and behaviours expected within different job roles. \nFor front-line staff this might be as simple as expecting staff to aware of and implement appropriate local environmental practices in terms of energy use, travel, waste and water use. For staff with significant climate change remit e.g. energy and sustainability managers/officers, the competencies required are likely to be more complex and related to the implementation of the Carbon Management Plan and other strategies. \n"]
[null,4,"b","How effective has your internal communication of climate change action been at influencing  staff behaviour?","4b","PICK ONE","Behaviour","Staff behaviour is often a key component in an organisation’s effort to reduce carbon emissions. Communication is one of the key areas for influencing staff behaviour; making sure that staff are aware of what is expected of them and why and whether their efforts are making a difference are key elements of positive behavioural change. "]
[null,4,"c","How much dedicated resources do you have for championing climate change action?",{"$f":"B24&C24","v":"4c"},"PICK ONE","Behaviour","For climate change action to become embedded throughout your organisation, it is likely to need additional resources in the form of climate change champions, who educate, guide and sometimes enforce good local environmental practices. "]
[null,4,"d","How well does your organisation devolve responsibility for meeting carbon reduction targets?",{"$f":"B25&C25","v":"4d"},"PICK ONE","Behaviour","One of the key promoters of better environmental behaviour is competition within organisations and one of the ways that this can be harnessed is by devolving responsibility to meeting carbon reduction targets to services, departments or buildings within your organisation. However, to achieve devolution of carbon targets, organisations need excellent data and communication systems and buy-in from managers about the methodology for monitoring targets. "]
[null,4,"e","Has your organisation considered how to reduce the climate change impact of service delivery?",{"$f":"B26&C26","v":"4e"},"PICK ONE","Behaviour","The question needs to be answered within the context of what your organisation does. For some smaller organisations, this might be a relatively simple question but for larger and more complex organisations who deliver many services across many areas (e.g. local authorities), this question will take some analysis to work out a list of key services and to consider ways that climate change considerations could be integrated into delivery of those services. "]
[null,5,"a","Has your organisation completed the Flexible Framework Assessment Tool?","5a","PICK ONE","Procurement","The Scottish Sustainable Procurement Action Plan recommends that organisations carry out initial and periodic self-assessments against the Flexible Framework. The Flexible Framework enables measurement against various aspects of sustainable procurement. Scottish Procurement and Scotland Excel have developed a self-assessment tool to support this process. The tool is aimed at helping organisations to assess where the current level of performance lies and the actions required to improve performance."]
[null,5,"b","How integral are resource efficiency considerations to procurement decisions for goods and services?","5b","PICK ONE","Procurement","This question is asking about operational expenditure (or government consumption) which is the purchase of goods and services required to run your organisation. A high percentage of goods and services are likely to procured through national contracts let by Scottish Procurements, however, within these contracts, there are still likely to be opportunities to improve resource efficiency decisions e.g. choosing paper with a high recycled content as part of the stationary and office paper contract. \nUnderstanding how to leverage buying power and work within the constraints of procurement rules and also which resource efficiency considerations to incorporate is likely to require closer working between the procurement officer/team and the sustainability officer/team. "]
[null,5,"c","How integral are resource efficiency considerations to decisions about capital and maintenance budget expenditure?","5c","PICK ONE","Procurement","This question is asking about the process for assessing and incorporating resource efficiency into decisions about capital and maintenance budget. These are often larger amounts of money and commitments are over a longer timescale e.g. the expected lifetime of a new building. Integrating resource efficiency asks how much more it would cost now, in terms of £ and resources, to get a better performance and lower resource use in the future. Often the best resource efficient opportunities occur early on in the planning phase e.g. it is cheaper and easier to amend projects at the design stage than the construction phase. However, in order to consider resource efficiency at the design stage or earlier, it needs to be explicitly built into the decision-making process."]
[null,5,"d","To what extent does climate change adaptation risk influence decisions about capital and maintenance budget expenditure?","5d","PICK ONE","Procurement","There are opportunities for organisations to help deliver on climate change risk assessments through procurement decisions about capital and maintenance expenditure. For example, an organisation which plans to consolidate a number of smaller offices into one single leased premises is in a good position to consider future climate risks and incorporate consideration of these when selecting an appropriate location and property. Another example could be a maintenance project that offers the opportunity to upgrade building fabric to withstand more extreme weather conditions. However, as with resource efficiency, adaptation risk and opportunity needs to be explicitly built into the decision-making process. "]

{"sheet":"All Choices","index":8,"n_rows":140,"n_cols":49,"rows_kept":140,"cut":false,"hidden":true,"merged":[[0,45,0,46],[0,28,0,34],[0,37,0,38],[0,39,0,40],[0,41,0,42],[0,43,0,44]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,"<= RUN NUMBER OFFSET",null,null,null,null,{"$f":"SUM(T38:T91)","v":0},null,null,null,null,null,null,null,null,"ACTION PLAN",null,null,null,null,null,null,null,null,"Run 1",null,"Run 2",null,"Run 3",null,"Run 4",null,"Run 5"]
[null,"Question Key","Topic","Question number","Stage","Possible Answers","Suggested action","Timescale","Role","Action Plan matrix number","Question Parameters","Score",null,null,null,null,null,null,null,"Adjust",null,1,2,3,4,5,6,null,"Action Plan matrix number","Question Key","Stage","Selected Answer","Response","Suggested Action","Timescale",null,"Results","Percentage","Max","Percentage","Max","Percentage","Max","Percentage","Max","Percentage","Max",null,"Adjust"]
[null,{"$f":"C3&D3","v":"1a"},1,"a",4,"Climate change action has been placed at the core of the organisation’s key objectives and Senior Management are accountable for achieving targets and implementing plans.","2020 ready.",null,null,{"$f":"'Action plan matrix'!C5","v":118},"SO",4,null,null,null,null,null,null,null,{"$f":"IF(OFFSET(N3,0,$N$1) =\"N/A\",  -1, \"\")","v":""},null,{"$f":"IF(OFFSET(N3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},{"$f":"IF(OFFSET(O3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},{"$f":"IF(OFFSET(P3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},{"$f":"IF(OFFSET(Q3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},{"$f":"IF(OFFSET(R3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},{"$f":"IF(OFFSET(S3,0,$N$1) =\"SELECTED\",  $L3, \"\")","v":""},null,{"$f":"IF(OFFSET(N3,0,$N$1) =\"SELECTED\",  $J3, \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), B3, \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), E3, \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), F3, \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), OFFSET(N3,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), G3, \"\")","v":""},{"$f":"IF(ISNUMBER($AC3), H3, \"\")","v":""},null,"Governance",{"$f":"SUM(V3:V37)/AM3","v":0},28,{"$f":"SUM(W3:W135)/AO3","v":0},28,{"$f":"SUM(X3:X135)/AQ3","v":0},28,{"$f":"SUM(Y3:Y135)/AS3","v":0},28,{"$f":"SUM(Z3:Z135)/AU3","v":0},28]
[null,{"$f":"C4&D4","v":"1a"},1,"a",3,"Climate change action is one of your organisation’s key objectives and is seen as a priority but it is not clear how Senior Management are accountable for achieving targets and implementing plans.","Work with the Carbon Management Board or equivalent to clarify accountability for meeting targets and implementing plans.",2,null,{"$f":"'Action plan matrix'!C6","v":94},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","","",null,"Emissions",{"$f":"SUM(V38:V67)/AM4","v":0},{"$f":"30+$AW4","v":30},{"$f":"SUM(W38:W67)/AO4","v":0},{"$f":"30+$AW4","v":30},{"$f":"SUM(X38:X67)/AQ4","v":0},{"$f":"30+$AW4","v":30},{"$f":"SUM(Y38:Y67)/AS4","v":0},{"$f":"30+$AW4","v":30},{"$f":"SUM(Z38:Z67)/AU4","v":0},{"$f":"30+$AW4","v":30},null,{"$f":"SUM(T38:T67)","v":0}]
[null,"1a",1,"a",2,"Climate change action is part of your organisation’s key objectives but is not seen as a priority.","Look carefully at the key objectives and work out how climate change action can support achievement of these aims, in order to move climate change to the core of the organisation. Consider how ISM approach and principles can help inform development of climate change actions.",2,null,{"$f":"'Action plan matrix'!C7","v":30},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","","",null,"Adaptation",{"$f":"(SUM(V68:V95) ) /AM5","v":0},{"$f":"28+$AW5","v":28},{"$f":"(SUM(W68:W91) ) /AO5","v":0},{"$f":"28+$AW5","v":28},{"$f":"(SUM(X68:X91) ) /AQ5","v":0},{"$f":"28+$AW5","v":28},{"$f":"(SUM(Y68:Y91) ) /AS5","v":0},{"$f":"28+$AW5","v":28},{"$f":"(SUM(Z68:Z91) ) /AU5","v":0},{"$f":"28+$AW5","v":28},null,{"$f":"SUM(T68:T95)","v":0}]
[null,"1a",1,"a",1,"Only carbon emission reduction is included in the organisation’s key objectives.","Widen the remit of carbon emission reduction to include other climate change actions including resource efficiency, adaptation and energy efficiency.",3,null,{"$f":"'Action plan matrix'!C8","v":17},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","","",null,"Behaviour",{"$f":"SUM(V96:V120)/AM6","v":0},20,{"$f":"SUM(W96:W135)/AO6","v":0},20,{"$f":"SUM(X96:X135)/AQ6","v":0},20,{"$f":"SUM(Y96:Y135)/AS6","v":0},20,{"$f":"SUM(Z96:Z135)/AU6","v":0},20]
[null,"1a",1,"a",0,"Climate change action is not part of your organisational objectives.","Produce a set of objectives around climate change action for inclusion in your organisation's key objectives. Discuss these with your Senior Sponsor and work out how these can be incorporated.",6,null,{"$f":"'Action plan matrix'!C9","v":1},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","","",null,"Procurement",{"$f":"SUM(V121:V140)/AM7","v":0},16,{"$f":"SUM(W121:W140)/AO7","v":0},16,{"$f":"SUM(X121:X140)/AQ7","v":0},16,{"$f":"SUM(Y121:Y140)/AS7","v":0},16,{"$f":"SUM(Z121:Z140)/AU7","v":0},16]
[null,{"$f":"C8&D8","v":"1b"},1,"b",4,"Our Chief Executive accepts overall accountability for climate change action, including meeting carbon reduction targets in the organisation, and is actively involved in annual progress reviews.","2020 ready.",null,null,{"$f":"'Action plan matrix'!D5","v":119},"SO",4,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},{"$f":"IF(OFFSET(O8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},{"$f":"IF(OFFSET(P8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},{"$f":"IF(OFFSET(Q8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},{"$f":"IF(OFFSET(R8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},{"$f":"IF(OFFSET(S8,0,$N$1) =\"SELECTED\",  $L8, \"\")","v":""},null,"","","","","","",""]
[null,"1b",1,"b",3,"Chief Executive accepts overall accountability for climate change action.","Suggest roles to make the Chief Executive’s involvement more active, such as chairing annual progress reviews.",2,null,{"$f":"'Action plan matrix'!D6","v":95},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1b",1,"b",2,"Chief Executive has overall accountability for carbon reduction targets and has signed a Climate Change Declaration or statement of intent.","Widen out the remit of carbon reduction to include climate change adaptation.",2,null,{"$f":"'Action plan matrix'!D7","v":31},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1b",1,"b",1,"Chief Executive has committed to carbon reduction by signing a Climate Change Declaration or statement of intent.","Implement an annual review process for the Carbon Management Plan involving the Chief Executive.",3,null,{"$f":"'Action plan matrix'!D8","v":18},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1b",1,"b",0,"Chief Executive has not engaged in any way with climate change action.","Produce a board paper outlining the benefits to the organisation of the Chief Executive taking a more active role in climate change action (e.g. reputational benefits, achieving other key targets) and make it clear what you want the CE to actually do.",6,null,{"$f":"'Action plan matrix'!D9","v":3},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1c",1,"c",4,"All mandatory and voluntary external reporting requirements are up to date and external reports are used for communication and performance improvement.","2020 ready.",null,null,{"$f":"'Action plan matrix'!E5","v":120},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N13,0,$N$1) =\"SELECTED\",  $J13, \"\")","v":""},{"$f":"IF(ISNUMBER($AC13), B13, \"\")","v":""},{"$f":"IF(ISNUMBER($AC13), E13, \"\")","v":""},"",{"$f":"IF(ISNUMBER($AC13), OFFSET(N13,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC13), G13, \"\")","v":""},""]
[null,"1c",1,"c",3,"All mandatory and voluntary external reporting requirements are up to date.","Work out how to make best use of the external reporting for communication, internal and external, and for performance improvement.",2,null,{"$f":"'Action plan matrix'!E6","v":32},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N14,0,$N$1) =\"SELECTED\",  $J14, \"\")","v":""},{"$f":"IF(ISNUMBER($AC14), B14, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC14), OFFSET(N14,0,$N$1), \"\")","v":""},"",""]
[null,"1c",1,"c",2,"All mandatory external reporting requirements are up to date.","Identify voluntary external reporting requirements and identify ways that these can help your organisation with both communication and performance reporting.",3,null,{"$f":"'Action plan matrix'!E7","v":19},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N15,0,$N$1) =\"SELECTED\",  $J15, \"\")","v":""},{"$f":"IF(ISNUMBER($AC15), B15, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC15), OFFSET(N15,0,$N$1), \"\")","v":""},"",""]
[null,"1c",1,"c",1,"Most mandatory external reporting requirements are up to date.","Identify and complete remaining mandatory reporting requirements. Implement methodologies to store data and information to make reporting numbers simple and analysis focused.",3,null,{"$f":"'Action plan matrix'!E8","v":4},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N16,0,$N$1) =\"SELECTED\",  $J16, \"\")","v":""},{"$f":"IF(ISNUMBER($AC16), B16, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC16), OFFSET(N16,0,$N$1), \"\")","v":""},"",""]
[null,"1c",1,"c",0,"No mandatory climate change reporting requirements have been completed.","Identify all mandatory reporting requirements. Implement methodologies to store data and information to make reporting numbers simple and analysis focused.",6,null,{"$f":"'Action plan matrix'!E9","v":2},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N17,0,$N$1) =\"SELECTED\",  $J17, \"\")","v":""},{"$f":"IF(ISNUMBER($AC17), B17, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC17), OFFSET(N17,0,$N$1), \"\")","v":""},"",""]
[null,"1d",1,"d",4,"Relevant reports detailing progress against targets are externally and independently audited.","2020 ready.",null,null,{"$f":"'Action plan matrix'!F5","v":121},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N18,0,$N$1) =\"SELECTED\",  $J18, \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), B18, \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), E18, \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), F18, \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), OFFSET(N18,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), G18, \"\")","v":""},{"$f":"IF(ISNUMBER($AC18), H18, \"\")","v":""}]
[null,"1d",1,"d",3,"Relevant reports detailing progress against targets are peer-reviewed by another organisation.","Consider whether key external reports or the underlying dataset would benefit from an external audit process, even if this was a one-off event and subsequently peer-review was continued.",3,null,{"$f":"'Action plan matrix'!F6","v":105},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1d",1,"d",2,"Relevant reports detailing progress against targets are internally audited with a  documented process.","Consider whether key external reports or the underlying dataset would benefit from a peer-review process, where a similar organisation was used to audit and review reports and data in exchange for the same service.",3,null,{"$f":"'Action plan matrix'!F7","v":81},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1d",1,"d",1,"Some reports detailing progress against targets are internally audited.","Improve the existing internal audit by documenting the process carefully. Consider whether key external reports or the underlying dataset would benefit from a peer-review or external review process. ",6,null,{"$f":"'Action plan matrix'!F8","v":68},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1d",1,"d",0,"There is no audit process in place for any reports detailing progress against targets.","Consider whether key external reports or the underlying dataset would benefit from an internal audit, peer-review or external audit process. Put together a business case for resources and/or budget for this to occur.",6,null,{"$f":"'Action plan matrix'!F9","v":44},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,{"$f":"C23&D23","v":"1e"},1,"e",4,"The existing corporate business plan contains measurable climate change actions. All new plans, policies, procedures strategies and committee reports are checked to assess any potential impact on climate change actions or on achieving carbon targets. As well as removing negative effects, the process looks to incorporate positive reinforcement where possible, identifying ways to actively combat climate change.","2020 ready.",null,null,{"$f":"'Action plan matrix'!G5","v":122},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1e",1,"e",3,"The existing corporate business plan contains climate change actions. All new plans, policies, procedures strategies and committee reports are checked to assess any potential impact on achieving carbon targets.","Widen the scope of the assessment to include climate change adaptation and look at positive ways for climate change actions to positively reinforce other organisational objectives.",3,null,{"$f":"'Action plan matrix'!G6","v":106},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1e",1,"e",2,"The existing corporate business plan contains climate change actions as part of overall environmental commitment. All committee reports contain a requirement to consider environmental implications of new proposals but reviewers have limited knowledge of climate change mitigation and adaptation.","Identify staff with the skill set to review organisational strategy documents and identify environmental impacts and also ways to improve objectives. If this skill set can be identified internally, make sure they are allocated time and resources for this task. Build staff capacity and expertise in using the ISM approach to identify barriers and constraints to change and to develop an action plan. ",6,null,{"$f":"'Action plan matrix'!G7","v":82},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1e",1,"e",1,"The existing corporate business plan contains environmental commitments but does not expressly mention climate change. Selected committee reports consider environmental implications of new proposals but this is done on an informal and ad hoc basis.","Introduce a requirement for all committee reports to consider climate change mitigation and adaptation and wider sustainability issues before publication.",3,null,{"$f":"'Action plan matrix'!G8","v":69},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1e",1,"e",0,"The existing corporate business plan does not contain environmental commitments. Committee reports do not cover environmental implications.","Introduce a requirement for all committee reports to consider climate change actions and wider sustainability issues before publication.",3,null,{"$f":"'Action plan matrix'!G9","v":45},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,{"$f":"C28&D28","v":"1f"},1,"f",4,"Our organisation has a climate change communication strategy, covering both adaptation and mitigation, for the organisation, and the wider area, which has components to enable quantification of the effectiveness of both communications and awareness raising measures.","2020 ready.",null,null,{"$f":"'Action plan matrix'!H5","v":123},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N28,0,$N$1) =\"SELECTED\",  $J28, \"\")","v":""},{"$f":"IF(ISNUMBER($AC28), B28, \"\")","v":""},{"$f":"IF(ISNUMBER($AC28), E28, \"\")","v":""},"",{"$f":"IF(ISNUMBER($AC28), OFFSET(N28,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC28), G28, \"\")","v":""},""]
[null,{"$f":"C29&D29","v":"1f"},1,"f",3,"Our organisation has an internal climate change communication strategy, which has components to enable quantification of the effectiveness of both communications and awareness raising measures.","Draw up and implement a communication strategy for the wider area, including partners and the public. Apply ISM approach and principles to communication strategy to ensure balance of focus across all three behavioural contexts - individual, social and material.  ",3,null,{"$f":"'Action plan matrix'!H6","v":107},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N29,0,$N$1) =\"SELECTED\",  $J29, \"\")","v":""},{"$f":"IF(ISNUMBER($AC29), B29, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC29), OFFSET(N29,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C30&D30","v":"1f"},1,"f",2,"Our organisation has an internal climate change communication strategy but no formal assessment of effectiveness is undertaken.","Work with appropriate departments to develop and implement a methodology for measuring the effectiveness of the communication strategy.",3,null,{"$f":"'Action plan matrix'!H7","v":83},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N30,0,$N$1) =\"SELECTED\",  $J30, \"\")","v":""},{"$f":"IF(ISNUMBER($AC30), B30, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC30), OFFSET(N30,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C31&D31","v":"1f"},1,"f",1,"Our organisation communicates climate change issues to employees but this is done on an ad hoc basis.","Work with appropriate departments to develop a regular and reasonably frequent communication strategy for climate change action. It is suggested that internal communication should be quarterly as a minimum. Apply ISM approach and principles to communication strategy to ensure balance of focus across all three behavioural contexts - individual, social and material.  ",6,null,{"$f":"'Action plan matrix'!H8","v":70},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N31,0,$N$1) =\"SELECTED\",  $J31, \"\")","v":""},{"$f":"IF(ISNUMBER($AC31), B31, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC31), OFFSET(N31,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C32&D32","v":"1f"},1,"f",0,"Our organisation has no system for communication of climate change issues.","Work with appropriate departments to develop a regular and reasonably frequent communication strategy for climate change action. It is suggested that internal communication should be quarterly as a minimum. Apply ISM approach and principles to communication strategy to ensure balance of focus across all three behavioural contexts - individual, social and material.  ",6,null,{"$f":"'Action plan matrix'!H9","v":46},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N32,0,$N$1) =\"SELECTED\",  $J32, \"\")","v":""},{"$f":"IF(ISNUMBER($AC32), B32, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC32), OFFSET(N32,0,$N$1), \"\")","v":""},"",""]
[null,"1g",1,"g",4,"There is an annual review of climate change mitigation and adaptation actions and, following consultation with specialist agencies, an improvement programme of actions is supported and signed off by Corporate Management Team.","2020 ready.",null,null,{"$f":"'Action plan matrix'!I5","v":124},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N33,0,$N$1) =\"SELECTED\",  $J33, \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), B33, \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), E33, \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), F33, \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), OFFSET(N33,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), G33, \"\")","v":""},{"$f":"IF(ISNUMBER($AC33), H33, \"\")","v":""}]
[null,"1g",1,"g",3,"Carbon Manager or equivalent reviews carbon performance against carbon reduction targets and develops a carbon management improvement programme of actions supported and signed off by Corporate Management Team.","Widen scope of performance improvement to include climate change adaptation.",3,null,{"$f":"'Action plan matrix'!I6","v":108},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1g",1,"g",2,"Carbon Manager or equivalent reviews carbon performance against carbon reduction targets and develops a carbon management improvement programme of actions.","Add performance improvement plan as an action to be approved and signed off at the annual Climate Change Management Review Board.",3,null,{"$f":"'Action plan matrix'!I7","v":84},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1g",1,"g",1,"Carbon Manager or equivalent reviews carbon performance against carbon reduction targets and takes actions to improve performance on an ad hoc basis.","Develop a more formal performance improvement plan that can be taken to the annual Climate Change Management Review Board. Consider using Individual-Social-Material (ISM) approach and principles to help inform development of the performance improvement plan and take account of all relevant behavioural factors and contexts.",3,null,{"$f":"'Action plan matrix'!I8","v":71},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"1g",1,"g",0,"No annual review of performance against targets takes place.","Develop a process for reviewing performance against key performance indicators.",3,null,{"$f":"'Action plan matrix'!I9","v":47},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2a",2,"a","i","Our current CMP has clearly stated drivers, objectives and strategy.","Review drivers, objectives and strategy with reference to your organisation's corporate plan. Aim to align the CMP objectives with key organisational objectives, demonstrating how the CMP will support your organisation to achieve these.",3,null,{"$f":"'Action plan matrix'!C13","v":7},"AD",1,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},{"$f":"IF(OFFSET(O38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},{"$f":"IF(OFFSET(P38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},{"$f":"IF(OFFSET(Q38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},{"$f":"IF(OFFSET(R38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},{"$f":"IF(OFFSET(S38,0,$N$1) =\"AGREE\",  $L38, \"\")","v":""},null,{"$f":"IF(OFFSET(N38,0,$N$1) =\"DISAGREE\",  $J38, \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), B38, \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), E38, \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), F38, \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), OFFSET(N38,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), G38, \"\")","v":""},{"$f":"IF(ISNUMBER($AC38), H38, \"\")","v":""}]
[null,"2a",2,"a","ii","Our current CMP has a carbon reduction target based on a realistic Business As Usual forecast and Carbon Reduction Project List, with agreed funding to implement projects.","Run Business As Usual forecast based on best available data. Estimate reductions available from projects with agreed funding. Discuss any target 'gaps' with Carbon Management Board.",3,null,{"$f":"'Action plan matrix'!C14","v":8},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2a",2,"a","iii","Our current CMP has a clearly stated carbon reduction target e.g. a % reduction of a baseline by a stated date.","Review stated reduction target and clarify wording e.g. date to be achieved.",1,null,{"$f":"'Action plan matrix'!C15","v":9},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2a",2,"a","iv","Our current CMP contains a clear CM governance structure, including purpose and frequency of Carbon Management meetings and decision-making process.","Identify key CM governance activities and roles. Draw up a proposed structure that will provide feedback, support and internal championing of the Carbon Management Plan and make it explicit about who takes what decisions.",1,null,{"$f":"'Action plan matrix'!C16","v":10},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2a",2,"a","v","Our current CMP contains a clear CM operational structure, including management of the Carbon Reduction Project Register and carbon footprint reporting.","Identify key CM operational activities and roles. Draw up a proposed structure that will provide effective implementation of the Carbon Management Plan, including implementing Carbon Reduction Project Register and tracking progress towards targets.",1,null,{"$f":"'Action plan matrix'!C17","v":11},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2b",2,"b","i","Our organisation has an individual annual energy efficiency target relating to the Energy Efficiency Action Plan, consistent with the overall target for the public sector.","Use the Conserve and Save: Energy Efficient Action Plan (Scottish Government, 2010) and accompanying documentation to set an appropriate organisational level energy saving target, consistent with the overall target for the public sector. This should be approved at Chief Executive level, or equivalent and both the target and progress on meeting it should be reported and published annually. ",6,null,{"$f":"'Action plan matrix'!D13","v":20},"ADNA",1,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OFFSET(O43,0,$N$1) =\"AGREE\",  $L43, \"\")","v":""},{"$f":"IF(OFFSET(P43,0,$N$1) =\"AGREE\",  $L43, \"\")","v":""},{"$f":"IF(OFFSET(Q43,0,$N$1) =\"AGREE\",  $L43, \"\")","v":""},{"$f":"IF(OFFSET(R43,0,$N$1) =\"AGREE\",  $L43, \"\")","v":""},{"$f":"IF(OFFSET(S43,0,$N$1) =\"AGREE\",  $L43, \"\")","v":""},null,{"$f":"IF(OFFSET(N43,0,$N$1) =\"DISAGREE\",  $J43, \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), B43, \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), E43, \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), F43, \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), OFFSET(N43,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), G43, \"\")","v":""},{"$f":"IF(ISNUMBER($AC43), H43, \"\")","v":""}]
[null,"2b",2,"b","ii","Our organisation has a target for reducing business travel and/or transport (expressed as distance, cost or GHG emissions).","Organisations with significant business travel or transport requirement should consider setting targets to reduce overall travel or reduce particular modes of travel. These targets can also support Health and Safety goals around staff out of office safety.",6,null,{"$f":"'Action plan matrix'!D14","v":21},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2b",2,"b","iii","Our organisation has a target for reducing waste (expressed as overall tonnes, tonnes per disposal route or GHG emissions).","Organisations producing significant quantities of internal waste should consider setting targets to reduce all waste or key waste streams/disposal routes. For organisations that include the disposal of municipal waste within their carbon footprint boundary, national waste reduction and disposal route targets can be included.",6,null,{"$f":"'Action plan matrix'!D15","v":22},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2b",2,"b","iv","Our organisation has a target for reducing energy consumption in data centres (expressed as total energy consumed or Power Usage Effectiveness (PUE) rating.","Organisations using in-house data centres with significant energy consumption should consider setting targets to reduce energy consumption and/or increasing efficiency.",3,null,{"$f":"'Action plan matrix'!D16","v":23},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2b",2,"b","v","Our organisation has a target for reducing water use and wastewater production (expressed as m3, cost or GHG emissions).","Organisations with significant water consumption and/or treatment requirements should consider setting targets to reduce water use and/or wastewater production.",6,null,{"$f":"'Action plan matrix'!D17","v":24},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2c",2,"c","i","We have regular monthly Carbon Management meetings with the CM Team, where actions are minuted and followed-up.","Set up an annual timetable for meetings and produce outline agendas so that all activities such as updating the Carbon Reduction Project Register, reviewing quarterly energy figures and producing the annual carbon footprint report are scheduled in. Make sure there is sufficient time for reports to be reviewed before going to the CM Board.",1,null,{"$f":"'Action plan matrix'!E13","v":57},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2c",2,"c","ii","The Carbon Management Board (or equivalent) oversees progress and plans on a quarterly basis.","Set up an annual timetable for meetings and produce outline agendas so that all activities such as producing and reviewing reports, decision-making and external reporting are scheduled in.",1,null,{"$f":"'Action plan matrix'!E14","v":58},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2c",2,"c","iii","Our organisation has a systematic process for actively monitoring consumption (energy/transport/waste etc.) throughout the year.","Set up a data source and collection plan to help identify who, when and how data is supplied. Aim to keep all data in a single database system for use in multiple reporting rather than running multiple systems.",3,null,{"$f":"'Action plan matrix'!E15","v":59},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2c",2,"c","iv","Our Carbon Management Project Register is updated every quarter with review and approval by the Carbon Management Board (or equivalent).","Set up a formal process for reviewing projects at different stages of implementation, including refining cost and emissions data, agreeing finance and identifying new opportunities.",2,null,{"$f":"'Action plan matrix'!E16","v":60},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2c",2,"c","v","All our Carbon Reduction projects have a designated manager to aid accountability.","Set up a system for designated project managers to provide updates that can be collated into the Project Register prior to quarterly review.",2,null,{"$f":"'Action plan matrix'!E17","v":61},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2d",2,"d","i","Scope 1 emissions - these are direct emissions from sources owned or controlled by the organisation e.g. fuels combusted on site or used in vehicles owned by organisation and fugitive emissions from refrigerants. The majority of these emissions should be included in your operational boundary, although it is permissible to disregard very small sources.","Review energy data collection systems and make sure all key emission sources are captured. If sources are excluded because they are very small proportionally and require significant effort to collect the data, the reasoning should be carefully documented. If your organisation is within the Carbon Reduction Commitment (CRC) Energy Efficiency scheme, it is reasonable to use the same organisational boundary for both the CRC and your corporate carbon footprint. If you are part way through a target period with respect to a baseline and if it is not possible to retrospectively include sources that have been missed, make sure that a plan is in place to include them in the next baseline year. ",6,null,{"$f":"'Action plan matrix'!F13","v":5},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","",{"$f":"IF(ISNUMBER($AC53), F53, \"\")","v":""},"","",""]
[null,"2d",2,"d","ii","Scope 2 emissions - these are indirect emissions from the consumption of purchased electricity, heat or steam. The majority of these emissions should be included in your operational boundary, although it is permissible to disregard very small sources.","Review energy data collection systems and make sure all key emission sources are captured. If sources are excluded because they are very small proportionally and require significant effort to collect the data, the reasoning should be carefully documented. If your organisation is within the Carbon Reduction Commitment (CRC) Energy Efficiency scheme, it is reasonable to use the same organisational boundary for both the CRC and your corporate carbon footprint. If you are part way through a target period with respect to a baseline and if it is not possible to retrospectively include sources that have been missed, make sure that a plan is in place to include them in the next baseline year. ",6,null,{"$f":"'Action plan matrix'!F14","v":6},"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2d",2,"d","iii","Scope 3 emissions: business travel. These are emissions resulting from staff travel using private or leased vehicles or modes of public transport such as air travel, taxis, buses and trains. It is best practice to include this emission source in your operational boundary.","Review available systems for capturing business travel data e.g. expenses systems and aim to include key emission sources relating to business travel. If sources are excluded because they are very small proportionally and require significant effort to collect the data, the reasoning should be carefully documented. If you are part way through a target period with respect to a baseline and if it is not possible to retrospectively include sources that have been missed, make sure that a plan is in place to include them in the next baseline year. It can be useful to include some of the less significant modes of business travel within the carbon footprint boundary because for some organisations, this is the only place that this dataset is collated into one place and although the emissions might be minimal, the cost to the organisation might be more significant. ",6,null,{"$f":"'Action plan matrix'!F15","v":38},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","",{"$f":"IF(ISNUMBER($AC55), F55, \"\")","v":""},"","",""]
[null,"2d",2,"d","iv","Scope 3 emissions: waste. These are emissions resulting from the disposal of waste and include different waste streams (e.g. paper, glass, organic and mixed waste streams etc.) and also different disposal routes (e.g. landfill, recycling, energy recovery, composting etc.). It is best practice to include this emission source in your operational boundary.","Review available systems for capturing waste data e.g. waste transfer notes or waste collection contracts and aim to include key emission sources relating to waste disposal. If sources are excluded because they are very small proportionally and require significant effort to collect the data, the reasoning should be carefully documented. If you are part way through a target period with respect to a baseline and if it is not possible to retrospectively include sources that have been missed, make sure that a plan is in place to include them in the next baseline year. It can be useful to use the carbon footprint boundary to improve waste data collection within your organisation, as this is one of the key steps to reducing waste and considering alternatives within the waste hierarchy. Waste is also one of the areas that staff have the most control over and therefore can help stimulate behavioural change within your organisation. \nIf your organisation includes municipal waste within the operational boundary, it is useful to be able to also measure and report corporate waste (produced by your own organisation) separately.",6,null,{"$f":"'Action plan matrix'!F16","v":39},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2d",2,"d","v","Scope 3 emissions: water. There are emissions resulting from the consumption of water and production of wastewater. It is best practice to include this emission source in your operational boundary.","Review available systems for capturing water usage data e.g. metering and billing data and aim to include water within your operational boundary. If individual sources are excluded because they are very small proportionally and require significant effort to collect the data, the reasoning should be carefully documented. If you are part way through a target period with respect to a baseline and if it is not possible to retrospectively include sources that have been missed, make sure that a plan is in place to include them in the next baseline year. It can be useful to include water within the carbon footprint boundary because although the emissions might be minimal, the cost to the organisation might be more significant and therefore projects to reduce water consumption can have financial benefits.",6,null,{"$f":"'Action plan matrix'!F17","v":40},"ADNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2e",2,"e","i","Our current CMP clearly defines the carbon footprint in terms of both the organisational (estate and departments included) and operational (emission sources included) boundary in a way that communicates the boundary to non-specialists and also allows the boundary to be replicated easily year on year.","Draw up boundary diagrams for both organisational and operational boundary to help identify when the carbon footprint boundary changes. Check the Greenhouse Gas Protocol for which emissions sources are required for inclusion and which are recommended.",3,null,26,"AD",1,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},{"$f":"IF(OFFSET(O58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},{"$f":"IF(OFFSET(P58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},{"$f":"IF(OFFSET(Q58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},{"$f":"IF(OFFSET(R58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},{"$f":"IF(OFFSET(S58,0,$N$1) =\"AGREE\",  $L58, \"\")","v":""},null,{"$f":"IF(OFFSET(N58,0,$N$1) =\"DISAGREE\",  $J58, \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), B58, \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), E58, \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), F58, \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), OFFSET(N58,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), G58, \"\")","v":""},{"$f":"IF(ISNUMBER($AC58), H58, \"\")","v":""}]
[null,"2e",2,"e","ii","Our current CMP contains a clearly documented process for reporting our annual carbon footprint.","Document process reporting annual carbon footprint. This should include the timescales for completion, the format of report, analysis to be included and the review and publication process.",3,null,27,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2e",2,"e","iii","We have a verifiable data collection regime that allows calculation of our organisation’s carbon emissions on a yearly basis.","Implement a data collection regime which meets GHG verification standards. Document the process for calculation of emissions from consumption data.",6,null,28,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2e",2,"e","iv","We have produced a carbon footprint report for each year since our baseline.","Commit to producing a carbon footprint report on an annual basis. This should report the absolute footprint and any metrics used by your organisation (e.g. kgCO2e per FTE), a summary of implemented Carbon Reduction projects and an explanation of reductions/increases against the baseline.",12,null,29,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2e",2,"e","v","We have produced our carbon footprint using the relevant correct conversion factors for each year.","Check the conversion factors against the UK conversion factors for company reporting. Document which factors have been selected and why.",2,null,30,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2f",2,"f","i","Our Project Register contains sufficient projects with realistic emission reduction figures to achieve our overall carbon reduction target and other related targets such as Energy Efficiency, business travel and transport, waste and water.","The project register needs to contain a range of projects at different stages of implementation. There should be some that are very complete in terms of data and others that require more information and assessment. Aim to have realistic emission reduction figures for sufficient projects to achieve your annual carbon reduction targets over the next 1-2 years to stay on track. Apply ISM approach and principles to evaluate  whether projects are effectively addressing potential barriers and constraints and identify how they may be improved.",12,null,36,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2f",2,"f","ii","Our Project Register contains sufficient projects with realistic costs and payback figures (agreed through discussion with suppliers) to achieve our carbon reduction target.","The project register needs to contain a range of projects at different stages of implementation. There should be some that are very complete in terms of data and others that require more information and assessment. Aim to have realistic costs and payback figures for sufficient projects to achieve your annual carbon reduction targets over the next 1-2 years to stay on track.",12,null,37,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2f",2,"f","iii","Our Project Register contains sufficient projects with committed and signed off funding to achieve our carbon reduction target.","The project register needs to contain a range of projects at different stages of implementation. There should be some that are very complete in terms of data and others that require more information and assessment. Aim to have projects with committed and signed off funding to achieve your annual carbon reduction targets over the next 1-2 years to stay on track.",12,null,38,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2f",2,"f","iv","All our projects have a firm implementation date that has been established through consideration of procurement, staff resourcing and other relevant factors.","The project register needs to contain a range of projects at different stages of implementation. There should be some that are very complete in terms of data and others that require more information and assessment. Aim to have firm project implementation dates to achieve your annual carbon reduction targets over the next 1-2 years to stay on track.",6,null,39,"AD",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"2f",2,"f","v","We are on schedule, with projects being implemented on time and monitored for cost and emissions savings.","Make sure project updates are collated prior to quarterly Carbon Management team meetings and that priority is given to successful implementation of projects. The Carbon Manager should provide support to name Project Managers to keep implementation on track. Use ISM to identify and target actions to address specific behavioural barriers and constraints.",12,null,40,"AD",1,null,null,null,null,null,null,null,{"$f":"IF(OFFSET(N67,0,$N$1) =\"N/A\",  -1, \"\")","v":""},null,"","","","","","",null,"","","","","","",""]
[null,"3a",3,"a","i","Aims and objectives of the climate change adaptation process have been identified.","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!H13","v":12},"YN",1,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N68,0,$N$1) =\"YES\",  $L68, \"\")","v":""},{"$f":"IF(OFFSET(O68,0,$N$1) =\"AGREE\",  $L68, \"\")","v":""},{"$f":"IF(OFFSET(P68,0,$N$1) =\"AGREE\",  $L68, \"\")","v":""},{"$f":"IF(OFFSET(Q68,0,$N$1) =\"AGREE\",  $L68, \"\")","v":""},{"$f":"IF(OFFSET(R68,0,$N$1) =\"AGREE\",  $L68, \"\")","v":""},{"$f":"IF(OFFSET(S68,0,$N$1) =\"AGREE\",  $L68, \"\")","v":""},null,{"$f":"IF(OFFSET(N68,0,$N$1) =\"NO\",  $J68, \"\")","v":""},"","","","","",""]
[null,"3a",3,"a","ii","A business case for tackling climate change adaptation has been put together.","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!H14","v":13},"YN",1,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N69,0,$N$1) =\"YES\",  $L69, \"\")","v":""},"","","","","",null,{"$f":"IF(OFFSET(N69,0,$N$1) =\"NO\",  $J69, \"\")","v":""},"","","","","",""]
[null,"3a",3,"a","iii","Internal governance for adaptation arrangements has been established.","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!H15","v":14},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3a",3,"a","iv","External partnerships for developing and delivering adaptation work have been set up.","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!H16","v":15},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3a",3,"a","v","Adaptation risk has been defined and embedded within Corporate Risk Register to help gain organisational buy-in.","Complete Step 1 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!H17","v":16},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3b",3,"b","i","Our organisation has understood recent climate change trends and UKCPO9 headline messages.","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!I13","v":25},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3b",3,"b","ii","We have issued a screening questionnaire to Service Managers to help identify key staff to attend a workshop.","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!I14","v":26},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3b",3,"b","iii","We have run a climate change adaptation workshop with relevant Service Managers.","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!I15","v":27},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3b",3,"b","iv","Service Managers have completed impact assessments for selected relevant services.","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!I16","v":28},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3b",3,"b","v","The individual impact assessments have been collated into a summary report for Senior Management.","Complete Step 2 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!I17","v":29},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"",{"$f":"IF(ISNUMBER($AC77), B77, \"\")","v":""},{"$f":"IF(ISNUMBER($AC77), E77, \"\")","v":""},{"$f":"IF(ISNUMBER($AC77), F77, \"\")","v":""},{"$f":"IF(ISNUMBER($AC77), OFFSET(N77,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC77), G77, \"\")","v":""},{"$f":"IF(ISNUMBER($AC77), H77, \"\")","v":""}]
[null,"3c",3,"c","i","We have conducted a climate change risk assessment for priority threats and opportunities.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!J13","v":41},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3c",3,"c","ii","We have identified and prioritised actions.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!J14","v":42},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3c",3,"c","iii","We have service-level risk assessments and action plans in place.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!J15","v":43},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","i","Building performance to deal with temperature and weather changes - both existing and new estate.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K13","v":62},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","ii","Disruption to energy, transport, water and ICT infrastructure and delivery networks.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K14","v":63},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","iii","Rising sea levels for coastal communities.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K15","v":64},"YNNA",1,null,null,null,null,null,null,null,{"$f":"IF(OFFSET(N83,0,$N$1) =\"N/A\",  -1, \"\")","v":""},null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","iv","Threats to biodiversity and natural areas.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K16","v":65},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","v","Productivity of agriculture and forestry.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K17","v":66},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3d",3,"d","vi","Impacts on the health and wellbeing of individuals and communities.","Complete Step 3 of 5 Steps to Managing your Climate Risks.",3,null,{"$f":"'Action plan matrix'!K18","v":67},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,{"$f":"C87&D87","v":"3e"},3,"e","i","We have collated and reported our organisation's adaptation arrangements through internal mechanisms.","Complete Step 4 of 5 Steps to Managing your Climate Risks.",6,null,{"$f":"'Action plan matrix'!L13","v":96},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3e",3,"e","ii","We have embedded climate risk assessment into existing organisational processes.","Complete Step 4 of 5 Steps to Managing your Climate Risks.",6,null,{"$f":"'Action plan matrix'!L14","v":97},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3e",3,"e","iii","We review our climate change risk assessment and arrangements on an annual basis.","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6,null,{"$f":"'Action plan matrix'!L15","v":98},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3e",3,"e","iv","We critically evaluate the progress made in implementation and discuss whether new actions are required to manage risk.","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6,null,{"$f":"'Action plan matrix'!L16","v":99},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3e",3,"e","v","We communicate our adaptation arrangements to staff, partners and the wider community and invite feedback and joint working.","Complete Step 5 of 5 Steps to Managing your Climate Risks.",6,null,{"$f":"'Action plan matrix'!L17","v":100},"YN",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3f",3,"f","i","We have identified our responsibilities under Natural Environment theme (Objectives N1 - N3).","Use the tables in the Scottish Climate Change Adaptation Programme (Climate Ready Scotland, Scottish Government, 2014) or more up to date version to identify if your organisation is named as a delivery partner under any of the multiple policies under each of the three objectives in the Natural Environment theme.",3,null,{"$f":"'Action plan matrix'!M13","v":101},"YNNA",1,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N92,0,$N$1) =\"YES\",  $L92, \"\")","v":""},{"$f":"IF(OFFSET(O92,0,$N$1) =\"AGREE\",  $L92, \"\")","v":""},{"$f":"IF(OFFSET(P92,0,$N$1) =\"AGREE\",  $L92, \"\")","v":""},{"$f":"IF(OFFSET(Q92,0,$N$1) =\"AGREE\",  $L92, \"\")","v":""},{"$f":"IF(OFFSET(R92,0,$N$1) =\"AGREE\",  $L92, \"\")","v":""},{"$f":"IF(OFFSET(S92,0,$N$1) =\"AGREE\",  $L92, \"\")","v":""},null,{"$f":"IF(OFFSET(N92,0,$N$1) =\"NO\",  $J92, \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), B92, \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), E92, \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), F92, \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), OFFSET(N92,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), G92, \"\")","v":""},{"$f":"IF(ISNUMBER($AC92), H92, \"\")","v":""}]
[null,"3f",3,"f","ii","We have identified our responsibilities under the Buildings and Infrastructure theme (Objectives B1 - B3).","Use the tables in the Scottish Climate Change Adaptation Programme (Climate Ready Scotland, Scottish Government, 2014 or more up to date version) to identify if your organisation is named as a delivery partner under any of the multiple policies under each of the three objectives in the Buildings and Infrastructure theme.",3,null,{"$f":"'Action plan matrix'!M14","v":102},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3f",3,"f","iii","We have identified our responsibilities under the Society theme (Objectives S1 - S3).","Use the tables in the Scottish Climate Change Adaptation Programme (Climate Ready Scotland, Scottish Government, 2014 or more up to date version) to identify if your organisation is named as a delivery partner under any of the multiple policies under each of the three objectives in the Society theme.",3,null,{"$f":"'Action plan matrix'!M15","v":103},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"3f",3,"f","iv","For the policies where we have identified responsibilities, we have a plan in place to deliver these responsibilities.","For the policies where our organisation is named as a delivery partner, develop an action plan to help deliver these policies. This is likely to require partnership working with other public bodies. For organisations with significant responsibilities, the policies should be assessed and prioritised before putting together action plans. ",12,null,{"$f":"'Action plan matrix'!M16","v":104},"YNNA",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4a",4,"a",4,"Climate change actions are part of competency requirements of 100% of employees’ job descriptions, with specific responsibilities designated to staff appropriate to the climate change remit of their job function.","2020 ready.",null,null,{"$f":"'Action plan matrix'!J5","v":125},"SO",4,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},{"$f":"IF(OFFSET(O96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},{"$f":"IF(OFFSET(P96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},{"$f":"IF(OFFSET(Q96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},{"$f":"IF(OFFSET(R96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},{"$f":"IF(OFFSET(S96,0,$N$1) =\"SELECTED\",  $L96, \"\")","v":""},null,{"$f":"IF(OFFSET(N96,0,$N$1) =\"SELECTED\",  $J96, \"\")","v":""},"","","","","",""]
[null,"4a",4,"a",3,"Climate change actions are part of competency requirements for all staff with significant climate change remit within their job functions but not for all other staff.","Draw up a list of basic climate change mitigation and adaptation actions, including resource efficiency, that are appropriate to all staff. Work with HR and staff representatives to get these incorporated into job descriptions. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",6,null,{"$f":"'Action plan matrix'!J6","v":109},"SO",3,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},{"$f":"IF(OFFSET(O97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},{"$f":"IF(OFFSET(P97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},{"$f":"IF(OFFSET(Q97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},{"$f":"IF(OFFSET(R97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},{"$f":"IF(OFFSET(S97,0,$N$1) =\"SELECTED\",  $L97, \"\")","v":""},null,"","","","","","",""]
[null,"4a",4,"a",2,"Formal plans are in place to introduce climate change actions as part of competency requirements for selected staff with significant climate change remit within their job function.","Select a range of roles and draw up competency requirements in partnership with HR and staff representatives. Work with HR and staff representatives to get these incorporated into job descriptions. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12,null,{"$f":"'Action plan matrix'!J7","v":85},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4a",4,"a",1,"Informal plans are in place to introduce climate change actions as part of competency requirements for selected staff with significant climate change remit within their job function.","Formalise plans for introducing climate change mitigation and adaptation actions for selected staff with high carbon intensity job functions. Select a range of roles and draw up competency requirements in partnership with HR and staff representatives. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12,null,{"$f":"'Action plan matrix'!J8","v":72},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4a",4,"a",0,"No climate change actions mentioned within job competencies.","Prepare a list of suggested basic resource efficiency actions that could be included within job competencies and set up a meeting with Human Resources (or appropriate department) for discussion. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",6,null,{"$f":"'Action plan matrix'!J9","v":48},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,{"$f":"C101&D101","v":"4b"},4,"b",4,"All staff understand your organisation's climate change priorities and take appropriate and proactive action to increase resource efficiency (energy, water, water, materials, transport etc.) and manage climate change risks within their daily activities.","2020 ready.",null,null,{"$f":"'Action plan matrix'!K5","v":126},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N101,0,$N$1) =\"SELECTED\",  $J101, \"\")","v":""},{"$f":"IF(ISNUMBER($AC101), B101, \"\")","v":""},{"$f":"IF(ISNUMBER($AC101), E101, \"\")","v":""},"",{"$f":"IF(ISNUMBER($AC101), OFFSET(N101,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC101), G101, \"\")","v":""},""]
[null,{"$f":"C102&D102","v":"4b"},4,"b",3,"Most permanent staff understand your organisation's climate change priorities and take appropriate action to increase resource efficiency (energy, water, water, materials, transport etc.) and manage climate change risks within their daily activities.","Investigate and implement mechanisms for communication of climate change actions for temporary and agency staff and provide support for staff to be proactive in identifying ways to increase resource efficiency and managing risk. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",6,null,{"$f":"'Action plan matrix'!K6","v":110},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N102,0,$N$1) =\"SELECTED\",  $J102, \"\")","v":""},{"$f":"IF(ISNUMBER($AC102), B102, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC102), OFFSET(N102,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C103&D103","v":"4b"},4,"b",2,"Staff with a direct climate change remit understand your organisation's priorities and take appropriate actions to increase resource efficiency.","Investigate and implement mechanisms for communication of climate change actions for staff in other departments and teams, and provide support for staff to be proactive in identifying ways to increase resource efficiency and managing risk. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12,null,{"$f":"'Action plan matrix'!K7","v":86},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N103,0,$N$1) =\"SELECTED\",  $J103, \"\")","v":""},{"$f":"IF(ISNUMBER($AC103), B103, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC103), OFFSET(N103,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C104&D104","v":"4b"},4,"b",1,"Staff with a direct climate change remit understand your organisation's priorities but are unsure about appropriate actions.","Focus on communication and empowerment of staff to identify and take appropriate actions to increase resource efficiency and mitigate climate change risk. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12,null,{"$f":"'Action plan matrix'!K8","v":73},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N104,0,$N$1) =\"SELECTED\",  $J104, \"\")","v":""},{"$f":"IF(ISNUMBER($AC104), B104, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC104), OFFSET(N104,0,$N$1), \"\")","v":""},"",""]
[null,{"$f":"C105&D105","v":"4b"},4,"b",0,"No evidence of staff awareness about organisational priorities and expected staff actions around climate change.","Focus on communication of climate change strategy to key staff and help them identify and take appropriate actions to increase resource efficiency and mitigate climate change risk. Consider using ISM approach and principles to ensure that desired behaviours are supported in individual, social and material contexts. ",12,null,{"$f":"'Action plan matrix'!K9","v":49},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N105,0,$N$1) =\"SELECTED\",  $J105, \"\")","v":""},{"$f":"IF(ISNUMBER($AC105), B105, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC105), OFFSET(N105,0,$N$1), \"\")","v":""},"",""]
[null,"4c",4,"c",4,"Climate change champions appointed at strategically important sites or service delivery networks and given sufficient resources, training and control to disseminate / embed climate change policies and practices across their own site  / networks.","2020 ready.",null,null,{"$f":"'Action plan matrix'!L5","v":127},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4c",4,"c",3,"Climate change champions appointed at strategically important sites or service delivery networks and given limited time, training and control to disseminate / embed climate change policies and practices across their own site  / networks.","Work with climate change champions and managers to identify and provide the additional resources required for them to successfully implement the actions. Monitor to demonstrate effectiveness. Build capacity and expertise in applying ISM approach and principles to identify barriers to achieving broader staff behaviour change and develop an action plan as part of the Carbon Management Plan.   ",6,null,{"$f":"'Action plan matrix'!L6","v":111},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4c",4,"c",2,"Informal group of climate change champions cover some strategically important sites but given limited resources to disseminate / embed climate change policies and practices across sites and networks.","Work with climate change champions and managers to identify and provide the resources required for them to successfully implement the actions. Monitor to demonstrate effectiveness. Use the ISM approach to design and develop the pilot project, identify current barriers and devise an action plan.",6,null,{"$f":"'Action plan matrix'!L7","v":87},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4c",4,"c",1,"Plans to establish climate change champions at all strategically important sites or service delivery networks to disseminate / embed climate change policies and practices.","Identify a number of sites for a pilot project, covering a range of building types and departments. Work with managers to identify appropriate staff to take on the role. Set up a 6 month pilot with monitoring to demonstrate effectiveness. Use the ISM approach to design and develop the pilot project, identify current barriers and devise an action plan.",12,null,{"$f":"'Action plan matrix'!L8","v":74},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4c",4,"c",0,"No plans to establish climate change champions to disseminate/embed climate change policies and practices.","Identify a site for a pilot climate change champion project. Work with managers to identify appropriate staff to take on the role. Set up a 6 month pilot with monitoring to demonstrate effectiveness. Use the ISM approach to design and develop the pilot project, identify current barriers and devise an action plan.",12,null,{"$f":"'Action plan matrix'!L9","v":50},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,{"$f":"C111&D111","v":"4d"},4,"d",4,"Carbon budgets (measured in tonnes of CO2e) are devolved to departments or sites (whichever is more appropriate). Appropriate staff have designated emission reduction responsibilities, access to data and control over the relevant emissions in their operational area.","2020 ready.",null,null,{"$f":"'Action plan matrix'!M5","v":128},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N111,0,$N$1) =\"SELECTED\",  $J111, \"\")","v":""},{"$f":"IF(ISNUMBER($AC111), B111, \"\")","v":""},{"$f":"IF(ISNUMBER($AC111), E111, \"\")","v":""},"",{"$f":"IF(ISNUMBER($AC111), OFFSET(N111,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC111), G111, \"\")","v":""},""]
[null,"4d",4,"d",3,"Carbon budgets (measured in tonnes of CO2e) are devolved to departments or sites (whichever is more appropriate). Appropriate staff have designated emission reduction responsibilities but limited access to data and control over the relevant emissions in their operational area.","Develop accessible data systems for staff to access. Devolve control for relevant emissions in their operational area to appropriate staff. Make sure that sufficient support and training is available. Use ISM approach and principles to ensure that potential behavioural barriers are identified and needs are addressed in context of individual, social and material contexts.  ",12,null,{"$f":"'Action plan matrix'!M6","v":112},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N112,0,$N$1) =\"SELECTED\",  $J112, \"\")","v":""},{"$f":"IF(ISNUMBER($AC112), B112, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC112), OFFSET(N112,0,$N$1), \"\")","v":""},"",""]
[null,"4d",4,"d",2,"Energy budgets are devolved to Departmental Directors and Group Managers who have designated emission reduction responsibilities but limited opportunities to actually control these emissions.","Develop accessible energy data systems for staff to access. Devolve control for relevant emissions in their operational area to appropriate staff. Make sure that sufficient support and training is available. Investigate widening energy budgets to cover other emission sources e.g. transport. Use ISM approach and principles to ensure that potential behavioural barriers are identified and needs are addressed in context of individual, social and material contexts.  ",12,null,{"$f":"'Action plan matrix'!M7","v":88},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N113,0,$N$1) =\"SELECTED\",  $J113, \"\")","v":""},{"$f":"IF(ISNUMBER($AC113), B113, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC113), OFFSET(N113,0,$N$1), \"\")","v":""},"",""]
[null,"4d",4,"d",1,"Plans are in place to estimate individual departments energy budgets and to devolve these to Service Directors.","Develop accessible energy data systems for staff to access. Devolve control for relevant emissions in their operational area to appropriate staff. Make sure that sufficient support and training is available. Investigate widening energy budgets to cover other emission sources such as transport, waste or business travel. Use ISM approach and principles to ensure that potential behavioural barriers are identified and needs are addressed in context of individual, social and material contexts.  ",12,null,{"$f":"'Action plan matrix'!M8","v":75},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N114,0,$N$1) =\"SELECTED\",  $J114, \"\")","v":""},{"$f":"IF(ISNUMBER($AC114), B114, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC114), OFFSET(N114,0,$N$1), \"\")","v":""},"",""]
[null,"4d",4,"d",0,"No plans to devolve energy budgets.","Develop a plan of how limited energy budgets could be practically devolved to Service Directors. Run a pilot project to demonstrate benefits and highlight required systems and training. Consider applying ISM approach and principles to pilot project development and evaluation.",6,null,{"$f":"'Action plan matrix'!M9","v":51},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N115,0,$N$1) =\"SELECTED\",  $J115, \"\")","v":""},{"$f":"IF(ISNUMBER($AC115), B115, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC115), OFFSET(N115,0,$N$1), \"\")","v":""},"",""]
[null,"4e",4,"e",4,"All services delivered by our organisation have been assessed for climate change impacts and individual departments (or appropriate level) are active in developing and delivering service improvement plans that include climate change actions for both mitigation and adaptation. The impact of these service improvement plans is monitored and evaluated. Where appropriate partnership organisations are involved and supported. ","2020 ready.",null,null,{"$f":"'Action plan matrix'!N5","v":129},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N116,0,$N$1) =\"SELECTED\",  $J116, \"\")","v":""},{"$f":"IF(ISNUMBER($AC116), B116, \"\")","v":""},"","",{"$f":"IF(ISNUMBER($AC116), OFFSET(N116,0,$N$1), \"\")","v":""},"",""]
[null,"4e",4,"e",3,"Some of the key services delivered by our organisation have been assessed for climate change impacts and Heads of Service (or appropriate level) are active in developing and delivering service improvement plans that include climate change actions for both mitigation and adaptation. There is informal evidence of these actions being implemented.","Look at ways to extend the range of services that are assessed for climate change impacts. Aim to devolve some responsibility for developing and delivering these service improvement plans to departmental level. Look at ways to monitor and evaluate the impact of the service improvement plans and involve external partners where appropriate. Consider using ISM approach and principles in collaboration with external partners, where appropriate, to help identify behavioural barriers and target actions. ",24,null,{"$f":"'Action plan matrix'!N6","v":113},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4e",4,"e",2,"Some of the key services delivered by our organisation have been assessed for climate change impacts and appropriate actions have been incorporated into some of the service improvement plans but there is little evidence of changes to service delivery being made as a result of these. ","Look at ways to extend the range of services that are assessed for climate change impacts. Identify effective ways to monitor and evaluate the impact of the service improvement plans and communicate these to other services within the organisation. Consider using ISM approach and principles to help identify behavioural barriers and to target actions.",12,null,{"$f":"'Action plan matrix'!N7","v":89},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4e",4,"e",1,"Some of the key services delivered by our organisation have been assessed for climate change impacts but there are no formal process in place for incorporating these into service improvement plans.","Look at ways to extend the range of services that are assessed for climate change impacts and to formalise the process for assessing climate change impacts and identifying appropriate actions. Identify effective ways to monitor and evaluate the impact of the service improvement plans and communicate these to other services within the organisation. Consider using ISM approach and principles to help identify behavioural barriers and to target actions.",12,null,{"$f":"'Action plan matrix'!N8","v":76},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"4e",4,"e",0,"There is no consideration of climate change impacts within service delivery.","Work with one key area within the organisation where the service or department are keen to incorporate climate change impacts and actions within their service improvement plan. Look at ways to monitor and evaluate the impact and collect evidence to support a business case for extending the approach across the organisation. Consider using ISM approach and principles to help identify behavioural barriers and to target actions.",12,null,{"$f":"'Action plan matrix'!N9","v":52},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5a",5,"a",4,"Our organisation has recently (within the previous year) completed the Flexible Framework Assessment Tool and has reached Level 5 across all 5 categories (People, Policy, Process, Suppliers, Results).","2020 ready.",null,null,{"$f":"'Action plan matrix'!O5","v":130},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5a",5,"a",3,"Our organisation has recently (within the previous year) completed the Flexible Framework Assessment Tool and has reached at least Level 4 across all 5 categories (People, Policy, Process, Suppliers, Results) and has an action plan in place to achieve Level 5 status within the next assessment period.","Implement the Proposed Actions required to meet the Level 5 (Expert) criteria across the 5 categories (People, Policy, Process, Suppliers, Results).",6,null,{"$f":"'Action plan matrix'!O6","v":114},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5a",5,"a",2,"Our organisation has recently (within the previous year) completed the Flexible Framework Assessment Tool and has reached at least Level 3 across all 5 categories (People, Policy, Process, Suppliers, Results) and has an action plan in place to achieve Level 4 status within the next assessment period.","Implement the Proposed Actions required to meet the Level 3 (Practice) criteria across the 5 categories (People, Policy, Process, Suppliers, Results).",6,null,{"$f":"'Action plan matrix'!O7","v":90},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5a",5,"a",1,"Our organisation has recently (within the previous year) completed the Flexible Framework Assessment Tool and has reached at least Level 1 or 2 across all 5 categories (People, Policy, Process, Suppliers, Results) and has an action plan in place to achieve Level 3 status within the next assessment period.","Develop a process for documenting the sustainability and carbon assessment and the decisions reached.",6,null,{"$f":"'Action plan matrix'!O8","v":77},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5a",5,"a",0,"Our organisation has not completed the Flexible Framework Assessment Tool.","Task the appropriate team/department with completing the Flexible Framework Assessment Tool and implementing the resulting set of Proposed Actions required to meet the criteria.",6,null,{"$f":"'Action plan matrix'!O9","v":53},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5b",5,"b",4,"Consideration of resource efficiency, including whole life costing of carbon/energy and reducing waste to landfill through the waste hierarchy is standard practice and taken into account in procurement decisions for +90% of goods, services and contracts by value.","2020 ready.",null,null,{"$f":"'Action plan matrix'!P5","v":131},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5b",5,"b",3,"Consideration of resource efficiency, including whole life costing of carbon/energy and reducing waste to landfill through the waste hierarchy is standard practice and taken into account in procurement decisions for +50% of goods, services and contracts by value.","Investigate possibilities for widening the range of goods, services and contracts, and incorporating a simplified process for lower value goods and services.",6,null,{"$f":"'Action plan matrix'!P6","v":115},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5b",5,"b",2,"Whole life costing or consideration of low carbon alternatives for selected goods and services that are determined to have high carbon impact and/or implications.","Run a pilot project to demonstrate the cost-effectiveness of widening the range of goods, services and contracts included and widening the evaluation to incorporate resource efficiency.",6,null,{"$f":"'Action plan matrix'!P7","v":91},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"",{"$f":"IF(ISNUMBER($AC128), B128, \"\")","v":""},{"$f":"IF(ISNUMBER($AC128), E128, \"\")","v":""},{"$f":"IF(ISNUMBER($AC128), F128, \"\")","v":""},{"$f":"IF(ISNUMBER($AC128), OFFSET(N128,0,$N$1), \"\")","v":""},{"$f":"IF(ISNUMBER($AC128), G128, \"\")","v":""},{"$f":"IF(ISNUMBER($AC128), H128, \"\")","v":""}]
[null,"5b",5,"b",1,"Procurement strategy contains commitment to consider the carbon cost of goods and services but no documented evidence of being action actually being taken.","Document decisions and monitor outcomes to collect evidence for implementing a more formal process of evaluation.",6,null,{"$f":"'Action plan matrix'!P8","v":78},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5b",5,"b",0,"No consideration of the carbon cost of goods and services within the procurement strategy or process.","Develop a process for evaluating resource efficiency for selected goods and services that are determined to have high carbon impact.",6,null,{"$f":"'Action plan matrix'!P9","v":54},"SO",0,null,null,null,null,null,null,null,"",null,{"$f":"IF(OFFSET(N130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},{"$f":"IF(OFFSET(O130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},{"$f":"IF(OFFSET(P130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},{"$f":"IF(OFFSET(Q130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},{"$f":"IF(OFFSET(R130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},{"$f":"IF(OFFSET(S130,0,$N$1) =\"SELECTED\",  $L130, \"\")","v":""},null,"","","","","","",""]
[null,"5c",5,"c",4,"100% of projects that are subject to financial appraisal are subject to carbon appraisal - including whole life costing and consideration of alternative low carbon methods of project delivery. Additional funding is routinely made available and embedded as business as usual policy for low carbon building specifications and carbon reduction projects through linkage of capital costs and longer term running costs. ","2020 ready.",null,null,{"$f":"'Action plan matrix'!Q5","v":132},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5c",5,"c",3,"100% of projects that are subject to financial appraisal are subject to carbon appraisal - including whole life costing and consideration of alternative low carbon methods of project delivery but limited additional funding available.","Use projects to demonstrate longer-term financial benefits of low carbon building specifications and carbon reduction projects to help convince Finance Managers to make more funding available.",6,null,{"$f":"'Action plan matrix'!Q6","v":116},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5c",5,"c",2,"Larger projects that are subject to financial appraisal are subject to carbon appraisal - including whole life costing and consideration of alternative low carbon methods of project delivery but limited additional funding available.","Widen remit to include all projects subject to financial appraisal, including refurbishment. Carefully document decisions and monitor outcomes to collect evidence for future decisions.",6,null,{"$f":"'Action plan matrix'!Q7","v":92},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5c",5,"c",1,"Only very significant projects are subject to limited carbon appraisal but additional funding rarely made available to incorporate resource and energy efficiency improvements.","Widen remit to include a greater range of projects, including refurbishment. Carefully document decisions and monitor outcomes to collect evidence for future decisions.",12,null,{"$f":"'Action plan matrix'!Q8","v":79},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5c",5,"c",0,"No system for carbon appraisal of projects is in place.","Develop a simple system for identifying appropriate projects and conducting a simple carbon appraisal to demonstrate how projects could be made more cost effective by considering resource and energy efficiency early on.",12,null,{"$f":"'Action plan matrix'!Q9","v":55},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5d",5,"d",4,"We have a climate change risk assessment process for all projects that are subject to financial appraisal. Additional funding is routinely made available and embedded as business as usual policy for future-proofed building specifications through linkage of capital cost versus longer term maintenance costs. The adaptation risks are re-evaluated and updated on a regular basis.","2020 ready.",null,null,{"$f":"'Action plan matrix'!R5","v":133},"SO",4,null,null,null,null,null,null,null,"",null,"","","","","","",null,{"$f":"IF(OFFSET(N136,0,$N$1) =\"SELECTED\",  $J136, \"\")","v":""},"","","","","",""]
[null,"5d",5,"d",3,"We have a climate change risk assessment process for most projects that are subject to financial appraisal. Some additional funding is routinely made available for more resilient building specifications.","Use existing projects to demonstrate longer-term financial benefits of incorporating climate change risk solutions at an early point in project planning to help convince Finance Managers to make more funding available. ",12,null,{"$f":"'Action plan matrix'!R6","v":117},"SO",3,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5d",5,"d",2,"We have a climate change risk assessment process for some projects that are subject to financial appraisal, however, there is limited additional funding made available for more resilient building specifications.","Widen the remit to include a greater range of projects, including refurbishment projects. Carefully document decisions and monitor outcomes to collect evidence to support future risk assessments and aim to fund more resilient building specifications at a level likely to result in payback over the project lifetime.",12,null,{"$f":"'Action plan matrix'!R7","v":93},"SO",2,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5d",5,"d",1,"Only very significant capital projects are subject to a climate change risk assessment and there is rarely additional funding made available for more resilient building specifications.","Widen the remit to include a greater range of projects, including refurbishment projects. Carefully document decisions and monitor outcomes to collect evidence to support future risk assessments.",12,null,{"$f":"'Action plan matrix'!R8","v":80},"SO",1,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]
[null,"5d",5,"d",0,"Our organisation has no system in place to evaluate climate change risks for capital and maintenance expenditure.","Develop a system for identifying appropriate projects and conducting a risk assessment to demonstrate the types of risks that the project might be exposed to in the future, depending on its location, infrastructure and usage etc. Come up with cost-effective solutions to increase resilience, taking into consideration the potential increased cost of maintenance and cost of disruption to services resulting from climate change impacts.",12,null,{"$f":"'Action plan matrix'!R9","v":56},"SO",0,null,null,null,null,null,null,null,"",null,"","","","","","",null,"","","","","","",""]

{"sheet":"Action plan matrix","index":9,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Question type (choose a level)"]
[null,null,"Question number"]
[null,"Level","1a","1b","1c","1d","1e","1f","1g","4a","4b","4c","4d","4e","5a","5b","5c","5d"]
[null,4,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133]
[null,3,94,95,32,105,106,107,108,109,110,111,112,113,114,115,116,117]
[null,2,30,31,19,81,82,83,84,85,86,87,88,89,90,91,92,93]
[null,1,17,18,4,68,69,70,71,72,73,74,75,76,77,78,79,80]
[null,0,1,3,2,44,45,46,47,48,49,50,51,52,53,54,55,56]
[null,null,"Question type (answer all)"]
[null,null,"Question number"]
[null,"Statement","2a","2b","2c","2d","2e","3a","3b","3c","3d","3e","3f"]
[null,1,7,20,57,5,33,12,25,41,62,96,101]
[null,2,8,21,58,6,34,13,26,42,63,97,102]
[null,3,9,22,59,38,35,14,27,43,64,98,103]
[null,4,10,23,60,39,36,15,28,null,65,99,104]
[null,5,11,24,61,40,37,16,29,null,66,100]
[null,6,null,null,null,null,null,null,null,null,67]

{"sheet":"Config","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}