Guidance for Importing GHG Data in CIRIS or Clearpath to Questions 4.6a and 4.6b
This feature allows you to automatically import the GHG emissions summary data from your inventory file (CIRIS, or previously named ‘GPC Tool’, emissions inventory), in relation to questions 4.6a and 4.6b, or Clearpath in relation to question 4.6a.
City Inventory Reporting and Information System (CIRIS)
If you are using CIRIS this feature can work for both questions 4.6a and 4.6b, this is dependent on whether question 4.6a or 4.6b is applicable to your city and the version of CIRIS your city is using:
- Cities who are part of the Global Covenant of Mayors will be presented question 4.6a and the import of GHG emissions data from CIRIS Emissions Inventory requires version 2.4 (the workbook will include the tab ‘GCoM - CRF’). This version of the tool is available at the C40 Climate Action Planning Resource Centre here.
- Cities who are not part of the Global Covenant of Mayors who select ‘Global Protocol for Community Greenhouse Gas Emissions Inventories (GPC)’ in response to 4.3 will be presented question 4.6b. The import of GHG emissions data from CIRIS requires version 2.1 and above (these versions will include the tab ‘Results_Overview’ and not ‘GCoM – CRF’). Please note that comments and notation keys from the Excel file will not be automatically uploaded to your response if reporting to 4.6b, so you will have to enter these manually. If you select ‘NO’ (Not Occurring) as a notation key, please add a comment to question 4.6b in the column ‘Where data is not available, please explain why’ with your explanation.
GPC Tool Emissions Inventory
- If you are using GPC Tool Emissions Inventory this feature works only for question 4.6b for versions 1.7 and 1.9 and may not work for other versions. Please note that comments and notation keys from the Excel file will not be automatically uploaded to your response if reporting to 4.6b, so you will have to enter these manually. If you select ‘NO’ (Not Occurring) as a notation key, please add a comment to question 4.6b in the column ‘Where data is not available, please explain why’ with your explanation. The ‘GPC reporting tool’ has been superseded, it is recommended that cities update to the latest version - CIRIS V2.4 (available here)
Clearpath
To access the necessary file for importing your emissions data please log in to your Clearpath account and navigate to the ‘Community-Scale’ track, and then the ‘Reports’ tab. On this tab, under the column titled ‘Name’ you will find the ‘CDP Upload’ inventory report. On this row, select the inventory you want to report from the dropdown, then click ‘Export’ and follow the prompts to save the fie (you may name the file however you choose). Using the exported file follow Steps 2-8 described below to import your emissions data into Question 4.6a.
Steps to Import
- If using Clearpath please advance to Step 2. If using CIRIS or the GPC Tool Emissions Inventory tool save a version of your inventory Excel file that you wish to import in either .xls or .xlsx format. Binary formatted or macro-enabled excel spreadsheet cannot be uploaded. The CIRIS and GPC tool templates are macro-enabled spreadsheets, so in order to upload the data, you will have to save the file in either .xls or .xlsx format locally on your computer first. N.B: Keep an original version of the file saved to upload in full to question 4.5 as outlined in step 6.
- Ensure that you are logged in to the CDP/ICLEI Unified Reporting System to access your questionnaire response. Import your file using the 'Import' button at the top of the screen.
- In the 'Import' field select the option 'City Wide Emissions'.
- In the ‘Import map’ field, select the format of the emissions inventory template you are using, in bold text in column 3 of the table below:
Emissions Inventory | Question Number | Import Map Name |
---|---|---|
CIRIS | 4.6a (for GCoM Cities) | CIRIS 2.4 CRF Format |
CIRIS | 4.6b (for non-GCoM Cities) | CIRIS Emissions Inventory |
GPC Tool Emissions Inventory | 4.6b (for non-GCoM Cities) | GPC Tool Emissions Inventory |
Clearpath | 4.6a (for GCoM Cities) | CIRIS 2.4 CRF Format |
- Select ‘Overwrite existing data/comments when import cell/comment is empty’ and click ‘OK’.
- If your import is successful, you will be presented with an import result screen. You will see the number of data points imported. Your answers will now show in the appropriate question in your questionnaire.
- Check all answers (emissions data and notation keys) have been correctly imported and look correct in your response by navigating to question 4.6a or 4.6b. Excel automatically rounds numbers and checks the numerical data is exact when imported.
- Please ensure that in addition to importing your emission data in questions 4.6a or 4.6b that you have also attached your emissions inventory excel file in xlsm format in question 4.5.
More detailed guidance with screenshots of the reporting system when undertaking the process can be found be in the guidance document 'Using CDP’s Disclosure Platform - Cities', in the section 'GHG Data Upload', accessible here.