Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

Eurostat Electricity Instructions

Procedure

Step 1) Go to https://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=nrg_pc_205&lang=en

IMPORTANT! The images below are just examples. The real values should be different.

Step 2) Input the most recent year on the six first blank lines of the 'Year' column and all the months from that semester number on the 'Month' (1-12 format) column on the spreadsheet

image.png

Step 3) Click on the '+' sign next to 'Band IC : 500 Mwh < Consumption < 2000 Mwh'. A pop-up will open

image.png

Step 4) On the pop-up window, toggle 'Select all' and click on 'Update' (the pop-up will close)

image.png

Step 5) Under 'Consumption', choose 'Band IF : 70 000 MWh < Consumption < 150 000 MWh'

Step 6) Under 'Taxes', choose 'All taxes and levies included'

image.png

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

image.png

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

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

Step 9) Repeat steps 1-8 for the second and third most recent semesters

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.