Exerciseon Building Energy Balances

Exerciseon Building Energy Balances

The purpose of the IEA Balance Builder is to build a country’s energy balance following the IEA methodology. This can be done by filling by hand the “Data in physical units”and“Conversion factors” worksheets or by uploading data from the IEA data questionnaires.

You are presented with a partially filled balance builder (file BalanceBuilder_Statisland.xls), follow the instructions below to complete the data and answer the questions regarding the aggregated and disaggregated balance worksheets.
Note that yellow cells indicate errors (as explained in the “Main Menu” worksheet).

Before starting, open the “Data in physical units”worksheet. You will note that:

• there is an arithmetic error for other bituminous coal,
• natural gas is missing and
• there is a problem with double counting for non-energy use of other kerosene, fuel oil, white spirit, lubricants, bitumen and paraffin waxes.

Now do the following:

1. Upload the natural gas questionnaire (file: STATISLAND_Gas.xls) to fill in the missing natural gas data.
2. Update the “Data in physical units”worksheet according to the following. Cells modified in the “Data in physical units” worksheet will turn orange if the change is correct.
3. Anthracite previously reported as stocked was actually exported.
4. The amount of Non-metallic minerals for other bituminous coal was accidentally left out. It should be 913 kt.
5. Blast furnace gas used in main activity producer electricity plants generated 1300GWh of electricity.
6. Open the “Disaggregated Balance”worksheet. You will notice that there are no numbers for anthracite, biogasoline and biodiesels. This is because some of the net calorific values are missing on the “Conversion factors”worksheet. Update the following:
   Anthracite:26700 kJ/kgfor production, 26500 kJ/kg for exports and 26750 kJ/kg for all other flows
   Biogasoline: 26800 kJ/kg
   Biodiesels: 36800 kJ/kg

Now when you go into the “Disaggregated Balance” worksheet you will see numbers that were previously missing for anthracite, biogasoline and biodiesels.

1. Fix the non-energydouble counting issue for oil in the “Data in physical units” worksheet as described in the Main Menu.

Disaggregated balance

1. What is the difference between a negative and a positive number in stock changes (row12)?

1. Production of motor gasoline equals 12570 kt in the “Data in physical units” worksheet, why is it zero in the aggregated balance?

1. Why does other bituminous coalappear as a negative number on the main activity producer electricity plants row of the disaggregated balance?

1. What is the difference between a negative number in transformation processes (rows1737) and a negative number in energy industry own use (rows 39-55)?

1. Are coking coal and lignite transformed or consumed directly? If transformed, into what other products? If consumed, by which sector? In which cases will the numbers be positive, and in which cases will they be negative?

Aggregated balance

1. What is the efficiency (as percentage) of coal and natural gasmain activity producer electricity plants? (1GWh = 0.086 ktoe)

1. Is this country energy self sufficient? For all fuels?
   (self sufficiency is calculated as production over TPES)

1. What does the negative number in the total column of main activity producer electricity plants indicate?The oil refineries row has a positive number in the total column. Is this correct?

Bonus question

1. Look at the nuclear, hydro and geothermal columns in the “Data in physical units”worksheet, numbers are reported in electricity output for the three of them but only geothermal has data in production and transformation, why?
   Looking at nuclear, hydro and geothermal in the “aggregated balance” worksheet we find numbers in production, how are they calculated? What are their efficiencies?

© IEA/OECD 2013