How RepDab works

The file you enter into RepDab will be tested at a number of different levels. A colour code indicated in the brackets is assigned to highlight potential problems:

 

  • Test 0 (0.1-0.2) for viruses
  • Test 1 (1.1-1.6) the format (red),
  • Test 2 (2.2-2.3) completeness (blue), 
  • Test 3 (3.1-3.2) internal inconsistency (yellow).

 

Test 0: Unpack ZIP File

 

Test 0.1: This test checks the zip-file for viruses and unzips it.

 

Test 0.2: This test is applied to all NFR02 tables (1A, 1B, 1, 2A, 2B, 2C, 2D, 2E, 3A, 3B, 3C) and the new NFR09 tables (1, 2A, 3A, 3B). 2B of the new NFR09 tables is not included in the RepDab check so far. This test aborts on failure.

 

Test 1: Format check (Red)

 

Test 1.1: File Type test. The files must be in Excel. The file might include more than one worksheet.

 

Test 1.2: File Name test. This test checks that the official table-name and correct version are used in the first two fields.

 

Test 1.3: Year and Country check. This test checks for the existence of the "Year" and the ISO2 country code in the table. For table 2A in NFR02 (projections for 2010, 2015, and 2020), the reporting year is used as a dummy for "Year".

 

Test 1.4: Number of columns and rows test. The tables must be exactly the same as in the template file. For Tables 3A, 3B, 3C, only the explanatory rows are checked, since these tables can have arbitrary numbers of rows.

 

Test 1.5: Number Check. Cells cannot contain values which are not a number, and not one of the following codes: NE, NA, NO, IE, C.

 

Test 1.6: Number Check. Longitude, latitude and height must be one number for each row in table 3C of NFR02 and table 2C of NFR08 (Large Point Sources).

 

These 6 tests are done for all tables. If a table fails to pass sub-tests other than Test 1.3, REPDAB is aborted and no further testing is performed. REPDAB will continue testing even if the file fails Test 1.3.

 

Test 2: Internal Consistency Check (Yellow)

 

This test applies only to 'old' (2002) NFR tables. In accordance with the Guidelines of 2002 for Estimating and Reporting Emissions Data (ECE/EB.AIR/80, Air Pollution Studies series, No. 15), [PDF, 728KB]Parties may report aggregated levels or detailed levels. This test consists of the following steps:

 

Test 2.1: Conversion of code names in cells: NO, NA, IE, NE, C => 0

 

Test 2.2: Sums up detailed levels, if all detailed levels are reported.

 

Test 2.3: Internal consistency check:

 

Adds detailed sums as aggregation, if aggregated level not reported.

 

Compares detailed sums and aggregated levels including national totals. Differences of 0.1% of detailed sums are allowed between detailed sums and aggregated level.

 

This test applies only to Tables 1, 1A and 1B of NFR02. It continues on failure.

 

Test 3: Completeness Check (Blue)

 

Test 3.1: Checks if table exists and that there are at least some entries in table cells. This test applies to all tables. Aborts on failure.

 

Test 3.2: Tests for each table required entries and determines completeness. (Blue)

 

This test is applied to Tables 1, 1A, 1B, 2A, 2B, 2C, 2D and 2E of NFR02 as well as for Table 1 of NFR08. There must be entries in all the applicable cells in order for the table to be defined as complete. Aborts on failure.

Last Update: 05.07.2016