Eurostat Natural Gas Instructions

Procedure

Step 1) Go to http://appsso.eurostat.ec.europa.eu/nui/show.do?query=BOOKMARK_DS-052778_QID_19DCD425_UID_-3F171EB0&layout=TIME,C,X,0;GEO,L,Y,0;PRODUCT,L,Z,0;CONSOM,L,Z,1;UNIT,L,Z,2;TAX,L,Z,3;CURRENCY,L,Z,4;INDICATORS,C,Z,5;&zSelection=DS-052778PRODUCT,4100;DS-052778TAX,X_TAX;DS-052778CONSOM,4142904;DS-052778INDICATORS,OBS_FLAG;DS-052778UNIT,GJ_GCV;DS-052778CURRENCY,EUR;&rankName1=TAX_1_2_-1_2&rankName2=UNIT_1_2_-1_2&rankName3=CURRENCY_1_2_-1_2&rankName4=CONSOM_1_2_-1_2&rankName5=INDICATORS_1_2_-1_2&rankName6=PRODUCT_1_2_-1_2&rankName7=TIME_1_0_0_0&rankName8=GEO_1_2_0_1&sortC=ASC_-1_FIRST&rStp=&cStp=&rDCh=&cDCh=&rDM=true&cDM=true&footnes=false&empty=false&wai=false&time_mode=NONE&time_most_recent=false&lang=EN&cfo=%23%23%23%2C%23%23%23.%23%23%23

Step 2) Click in the "+" button next to "Time", a new box will open.

Step 3) Change the time range by clicking 'Select all' and click on "Update"

Step 4) Click in the "+" button next to "GEO", another new box will open.

Step 4) Look for the Country named in Cell 'A7', verify if its checkbox is marked* and click on "Update"

*if it is not marked, click it to mark

Step 5) In "Consumption" topic, select "Band I5 : 1 000 000 GJ < Consumption < 4 000 000 GJ"

Step 6) In "Taxes" topic, select "All taxes and levies included"

Step 7) In "Unit of Measure" topic, select "Kilowatt-hour"

Step 8) Input the most recent year on the 'Year' column and all the months from that semester number on the 'Month' (1-12 format) column on the spreadsheet

Step 9) Find the line corresponding to the Country in Cell 'A7' and copy the most recent value*

*In the example, the Country in cell 'A7' is Turkey.

Step 10) Paste it on the six first blank lines of the 'EUR/GJ' column on the spreadsheet

Step 11) Repeat steps 1-10 for the second and third most recent semesters