IPCC Inventory Software

UNFCCC Interoperability – CRT Export Quick Start Guide
Draft as of 6 June 2023

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

ContentsIntroduction ......................................................................................................................................................................... 3
CRT Data Set management ............................................................................................................................................... 3
What is CRT Data Set ................................................................................................................................................... 3
CRT Data Set management screen .............................................................................................................................. 3
New CRT Data Set .................................................................................................................................................... 4
Edit CRT Data Set..................................................................................................................................................... 5Open tables ................................................................................................................................................................. 6
Generate JSON .......................................................................................................................................................... 6
Refresh values............................................................................................................................................................. 7
Delete CRT Data Set................................................................................................................................................. 8
CRT Tables .......................................................................................................................................................................... 8
CRT Table actions.......................................................................................................................................................... 9Single-cell actions ....................................................................................................................................................... 9
Multi-cell actions ...................................................................................................................................................... 12
Editable cells ............................................................................................................................................................. 15
CRT Table Documentation Box................................................................................................................................ 16

This Guide was prepared by Technical Support Unit (TSU) of IPCC Task Force on
National Greenhouse Gas Inventories (TFI) to help national inventory compilers whouse the IPCC Inventory Software for the purpose of official inventory submission underthe Paris Agreement.
It has not been subject to formal IPCC review processes.

2

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Introduction

Since version v2.86, the IPCC Inventory Software is capable of preparing a JSON data exchange format filefor export of data from the IPCC Inventory Software into the UNFCCC reporting tool for the electronic
reporting of the Common Reporting Tables (CRT) under the Paris Agreement. The interface is accessible
from the Main Menu / Export / CRT.
This export functionality has been added to the IPCC Inventory Software following the invitation of theConference of the Parties serving as the meeting of the Parties to the Paris Agreement to the IPCC. 1
In this guide to UNFCCC CRTs export, guidance is provided by the Technical Support Unit of the IPCC
Task Force on National Greenhouse Gas Inventories (TFI TSU).

CRT Data Set management
What is CRT Data Set

CRT Data Set represents a particular instance of CRT export which holds CRT Tables with data for the set ofyears that were selected during CRT Data Set creation. Software allows maintaining multiple CRT Data Sets
that are independent of each other and thus can be managed and exported to JSON independently.

CRT Data Set management screen

This screen is designed for CRT Data Set management. It provides the following functionality:-Create New CRT Data Set
Edit properties of existing CRT Data Set
Open tables interface that visualizes the CRT and allows managing data across sectors and years forselected CRT Data Set
Generate JSON (export format) for selected CRT Data Set
Refresh values – compile CRT Variable values from IPCC Inventory Software worksheet data for
selected CRT Data Set
Delete existing CRT Data Set

1 Decision 5/CMA.3, paragraphs 19 and 20.

3IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Except for “New CRT Data Set” button, all the action buttons at the bottom of the table always apply tocurrently selected CRT Data Set in table (highlighted).

New CRT Data Set

This action button opens a screen where properties of the new CRT Data Set are specified.

-Name – name of new CRT Data Set
Years – inventory years assigned to new CRT Data Set

4

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide
After pressing Save, a new data set is created and the user is prompted whether to feed data into CRT ofthe new data set. This operation can be postponed and carried out later on various levels (at sector level,table level, cell level, multiple cell selection level)

Edit CRT Data Set

This action button a opens screen where properties of the existing CRT Data Set can be adjusted.
-Name – can be changed, if necessary
Years:o Adding additional years – user can add additional years to existing CRT Data Set. Afteradding new years and saving data set user is prompted whether to feed data into CRT tables
for newly added years within all sectors.

oDeleting existing years – user can remove existing years from edited data set. Note that alldata belonging to removed years will be permanently deleted from the CRT data set. Notethat this will not in any way impact the underlying data in the IPCC Inventory software
database.

5

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start GuideOpen tables

This action button opens a screen containing CRT for the currently selected CRT Data Set. This screen will
open in a mode that allows the user to switch between itself and other IPCC Inventory Software screens (e.g.
Worksheets screen). Only one CRT screen for one CRT Data Set can be open at a time. Refer to the “CRTTables” chapter for more information on CRT Tables screen in Open Tables and its functions.

Generate JSONThis action button serves the purpose of generating export in JSON format. All CRT that belong to theselected CRT Data Set will be serialized into the JSON file for selected years.

6

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Refresh values

This action button allows refreshing all CRT Variable values within selected CRT Data Set for all sectors andselected years. Fresh values are compiled from the IPCC Inventory Software worksheets replacing current
CRT Variable values. Other information that was already added by the user such as CRT Variable description
and comments will be preserved. Notation Key specific comments will be preserved only in case refreshedvariable Notation Key doesn’t change during refresh.

7

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Delete CRT Data Set

This action will permanently delete existing CRT Data Set together with all data in all CRT Tables. Thisaction is not reversible in CRT Data Set Management. Note that this will not in any way impact theunderlying data in the IPCC Inventory software database.

CRT Tables

Screen containing CRT Tables can be open using “Open tables” button in CRT Data Set Manager for
selected CRT Data Set. An alternative way to open the tables is to double-click the desired CRT Data Set row
in CRT Data Set Manager table. Only one CRT Tables screen of one particular CRT Data Set can be open ata time.

8

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

CRT Tables screen consists of the following elements.
-Window title – contains the name of selected CRT Data Set
Sector – currently selected sector. Set of tables is presented according to selected Sector
Year – currently selected year from the list of years that belong to selected CRT Data Set
Refresh values – allows refreshing values from the IPCC Inventory Software worksheets for all tables
in selected sector and for years selected by user
Tabbed interface – allows switching between tables belonging to selected sector
Documentation area – relevant for currently selected table. Contains Legend, Documentation box,
IPCC Inventory software notes and other relevant info. Documentation area windows can berearranged according to user preference.

CRT Table actions

For each CRT Variable in CRT Table there are several actions. Actions can be performed for a single cell aswell as for selection of cells.

Single-cell actions

Right click on any cell that represents CRT Variable to open context menu with actions that are relevant for
selected CRT Variable. Completion of these details provides information for inclusion in the UNFCCC CRT.

9IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

EditOpens CRT Variable detail dialog with all information relevant for the type of selected CRT Variable. Detaildialog can be alternatively opened by double-clicking on a cell. Standard numeric variable detail dialog isshown below.

-Summary – contains basic information such as UID and current value
Description – description of variable
Party comment
User comment
Official comment

User can enter this additional information independently for every CRT Variable cell in every CRT Table.
In case of a CRT Variable that has a Notation Key instead of a numeric value, additional information that isrelevant for the selected Notation Key becomes available. Example for FX (flexibility) variable below.

10

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Example of detail dialog for “Method” and “EF” CRT Variable:

11

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

Notation KeyThis menu item contains a list of possible Notation Keys that can be set for the CRT Variable. If a cellalready contains one of the notation keys instead of a numeric value, then the list of possible notation keys isas follows:In case of cells that contain numeric value the list of notation keys contains only one item – C (Confidential)
allowing a user to mark that CRT Variable as Confidential.

A “C” flag is added as suffix to the numeric value. While the value in the confidential cell is still visible in thesoftware it WILL NOT be exported in JSON. Choosing “C” on a cell that already has “C” flag will remove it.
Refresh value
This action allows refreshing the CRT Variable with the latest relevant IPCC Inventory Software worksheet
value. This action can be performed for the current year, all years in data set or only years explicitly selectedby user.

Multi-cell actions

CRT Table interface allows performing actions on multiple selected cells at once. This way it is possible toe.g. set the same documentation text for several cells without editing each cell individually.

12

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide
Multiple cells can be selected utilizing various techniques.
-Left click and hold on starting cell and drag mouse pointer to select additional cells;
Left click on column header to select single column or left click, hold and drag to select multiple
columns and all of their cells;
Left click on row header to select single row or left click, hold and drag to select multiple rows andall of their cells;
Hold CTRL and left click on individual cells to be selected;
Click on start cell, hold SHIFT and then click on end cell to select area of cells.

Selected cells are highlighted. In case selection contains at least one CRT Variable cell, right click anywhere
within selection opens context menu that applies to selection.

EditOpens detail dialog for selected cells in multi-cell mode. Detail dialog is constructed based on types of cells
that are in selection. This means all relevant tabs will be shown within detail dialog. (e.g. if selection contains“Method” and “EF” cell, “Method” and “EF” tabs will become available).
User has to explicitly flag which information entered in multi-cell detail dialog should be applied to selected
cells. This way it is possible to bulk-update only specific types of information while leaving other informationin selected cells intact. Example: If only “Party comment” should be updated in all selected cells then user
explicitly marks that comment using a dedicated checkbox and then inputs new value for that comment (seescreenshot below).

13IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

In multi-cell detail dialog, each piece of information has its dedicated “Apply” checkbox. Example for FX
related comments below where only “MPG Flexibility Provision” was marked to be updated within all FX
cells in the selection of cells.

Note, that every piece of information will be applied to cell in selection only in case it is relevant for that cell.
(e.g. FX comments will be applied only to those cells in selection that are FX).

14

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide
Notation key
Allows the user to set the same Notation Key for all cells in the selection. The rules are analogic to those in“Edit” action and thus selected Notation Key will be applied only to relevant cells. (e.g. if C is selected, onlycells containing real numeric value will be marked as C).

Refresh values
Allows refreshing values from the IPCC Inventory Software worksheets for all selected cells for either current
year, all years in data set or for years explicitly selected by user.

Editable cells

Some cells highlighted with pale green color allow direct editing of value. User is allowed to change value ofsuch cells or set notation key by direct input.
-To enter numeric value – type in numeric value directly into cell. Value can be marked as confidential
by entering “c” or “C” after numeric value
To enter notation key – type in one of the relevant notation keys directly. Allowed notation keys:
NE, NA, NO, IE, FX (can be typed lowercase in which case they will be automatically converted toupper case)

15

IPCC Inventory Software – UNFCCC Interoperability – CRT Export Quick Start Guide

CRT Table Documentation BoxAllows to specify additional textual information at CRT Table level. Each documentation box has its
dedicated UID thus it is exported to JSON just like any other CRT Variable. After changing value of
documentation box, click Save button located next to editing text area to apply changes.

16