Carbon Footprint and Project Register Tool
A carbon management plan is essential for public sector organisations to formulate a measurable and achievable strategy for reducing greenhouse gas emissions in line with Scottish Government commitments.
Additionally, developing and improving knowledge in carbon management planning will assist in completing Section 3 of Public Bodies Duties Climate Change reports.
Carbon Footprint and Project Register Tool
Carbon foot-printing, creating and maintaining a project register, forecasting emissions and target setting are all key aspects of a strong carbon management plan.
To assist in this area of strategy and planning, the Carbon Footprint and Project Register Tool (CFPR) has been developed by the Sustainable Scotland Network, Resource Efficient Scotland (a programme delivered by Zero Waste Scotland) and partners, to help organisations:
- calculate their annual carbon footprint
- collate and manage their carbon project list and forecast savings
- document estate changes and other impacts on their footprint to create a Business as Usual forecast
- track progress towards targets and provide management information to other parts of the organisation
- produce accurate and auditable outputs to easily complete annual Public Bodies Climate Change Duties reporting
The tool is managed by SSN who also provide support with using the tool. It will be updated yearly to reflect changes in the official Government emission factors.
Carbon Management Plan Resources
Zero Waste Scotland have produced a range of carbon management plan resources. These include:
- Setting targets – considers factors such as time-scale, boundaries, and forecasts of savings as opposed to business as usual
- Reporting – will help shape your carbon management plans so as to comply with your public bodies climate change duties reporting obligations, including guidance on scope, data availability and sense checking
- Organisational boundaries – ensures you identify the line between you and third-party organisations, and how to quantify this in your reporting
- Governance and accountability – a carbon management plan needs commitment from across your organisation, and to be seen to dovetail with your organisation's other drivers, such as cost-effectiveness and engagement with the wider community.
Additionally, there are also both long and short versions of a carbon management plan template, to give your plan structure and keep you on track, along with a diagnosis tool, which functions as a spreadsheet checklist.
A full set of notes on navigating and using the tool with step by step guides on how to correctly populate each worksheet within the tool. These notes also include troubleshooting tips and worked examples of how the tool deals with renewable emission sources and projects.
These notes are also included within the tool itself. It is very important you read these notes before using the tool to ensure you understand exactly how it works and how your organisation can get the most from it.
The slide deck used from the two sessions held in August and September 2017 centred on carbon footprinting and project register training with a focus on using the CFPR tool.
The training hand-outs used from the two sessions held in August and September 2017. These handouts were exercises worked through during the training. Answers have been filled in for guidance purposes.
- There are now macros present within the tool. Please ensure macros are enabled before using the tool or some functionality will not work. You should receive a prompt to ‘enable macros’ when you open the tool. If you are unsure if your version of Excel has macros enabled, please contact SSN who can assist.
- For larger bodies that require several hundred emission sources, please note that there is a limit to the number of emission sources that the current tool can deal with. If you require more than 1000 emission sources, the tool will issue you with a warning and you will need to contact SSN to unlock the tool for you to add in more rows.
- It is recommended that this tool is used with Excel 2010 and onwards. If you are using a version of Excel that is older than this, you should hopefully be able to use the tool without any disruption however if you experience issues please contact SSN.
- Whilst this tool has undergone vigorous testing over the past month, some small bugs may still exist. If you experience anything that you think is unusual with the tool, please let the SSN team know so we can take a look. Thanks.
Tutorial videos on using the tool can be found below. These videos contain step by step guides on populating the tool in order to get the most use out of it. Topics covered include:
- Getting started with the tool
- Completing your carbon footprint and making the most use of the output charts and tables
- Adding a project to the register
- Renewable emission sources and projects
Video One – “Getting Started” - This video focuses on getting started with the tool. It contains information on how to use the guidance and navigate your way around the tool before diving in to use it.
Video Two – “Completing your footprint” - This video focuses on carbon footprinting and how you can use the tool to complete your organisation's current and future year’s footprint. It will also help to explain how to define your own emission factors and costs as well as provide a brief overview of how the tool uses the data you provide it to generate a host of different outputs, particularly those to assist with completing your public bodies climate change duties report.
Video Three – Compiling a project register - This video focuses on compiling and managing your own project register. The video takes you through the steps involved in inputting project data into the tool, what outputs are available and how this can all help with tracking existing organisational targets as well as helping to define new targets
Video Four – Renewable emission sources and projects – This final video focuses solely on renewable emission sources and renewable projects. The CFPR tool deals with renewable installations in a unique way and therefore this tutorial will breakdown the necessary steps involved to include these within your carbon footprint and/or project register.