File:Energy supply in Europe.xls

From Opasnet
Jump to: navigation, search
Energy_supply_in_Europe.xls ‎(file size: 491 KB, MIME type: application/zip)
Warning: This file type may contain malicious code. By executing it, your system may be compromised.

Model for energy supply and demand calculations by Matti Jantunen. Designed for variable Energy supply in Europe. Original name Balance.OECD_Europe.2007.baseline-Av+Nav.EUcomp+EFs+iFs+Combustor.xls.


Note! This is actually an XLSX file. Change the suffix before opening.

⇤--#: . The table below is probably redundant and should be removed. --Jouni (talk) 15:35, 27 March 2014 (EET) (type: truth; paradigms: science: attack)

File:Energy supply in Europe.xls(Mtoe/a)
ObsSupply and consumptionCoal & peatCrude oilPetrochem productsGasNuclearHydroGeothermal solar windCombust renew waste ElectricityHeatTotalDescription
1Production188.71236.95236.63241.2642.7920.9299.580.451067.29
2Imports174.45657.10299.21347.424.2129.031511.43
3Exports-32.74-173.64-287.97140.82-1.31-28.69-0.01-665.18
4Intl marine bunkers0.00-54.73Domestic supply of fuels for international aviation and navigation are moved to lower rows.
5Intl aviation bunkers-45.79Domestic supply of fuels for international aviation and navigation are moved to lower rows.
6Stock changes6.780.012.764.50-0.0813.97
7TPES337.20720.4214.0447.73241.2642.7920.92102.410.340.441927.50
8Transfers17.67-15.390.002.29
9Statistical differences-2.991.671.791.16-0.080.110.442.12
10Electricity plants-177.01-15.48-83.86-237.92-42.79-16.16-17.85251.41-0.45-340.13
11CHP Plants-63.56-9.56-58.68-3.34-0.97-16.8756.2147.52-49.25The coal & peat value modified from the original IEA 2000 Energy Balance data sheet. Other data are not affected.
12Heat plants-5.19-0.82-5.38-0.13-3.72-0.2513.40-2.09
13Gas works-0.46-0.180.46-0.18
14Petroleum refineries-748.50741.71-6.79
15Coal transformation-24.440.02-1.96-0.09-26.47
16Liquefication plants
17Other transformation0.0111.18-11.41-0.17-0.11-0.50
18Own use-6.850.00-39.78-17.74-0.08-24.33-2.33-91.60
19Distribution losses-1.03-0.02-2.69-0.13-0.02-19.70-3.77-27.35
20TFC55.672.47662.91280.743.5363.69263.3055.261387.51
21Industry sector40.930.0145.2692.260.1619.84107.4917.23322.95
22Iron and steel16.861.219.830.0412.930.3441.20
23Chemical and petrochem2.280.018.8520.610.4917.813.4653.52
24Non-ferrous metals0.651.083.310.039.560.2314.87
25Non-metallic minerals6.6811.0316.261.517.760.1243.34
26Transport equipment0.130.663.074.200.218.27
27Machinery0.232.397.990.039.550.3620.56
28Mining and quarrying0.160.810.551.430.283.24
29Food and tobacco2.263.9012.460.9010.100.6230.24
30Paper, pulp & printing1.272.049.0011.3012.981.6338.23
31Wood and wood products0.140.310.403.152.370.336.71
32Construction2.163.390.810.121.570.068.11
33Textile and leather0.330.873.150.073.640.108.15
34Non-specified industry7.778.494.810.162.2013.599.5046.50
35Transport section0.00432.491.897.856.54448.78
36Domestic aviation10.9610.96
37International aviation45.7945.79
38Road transport311.230.637.85319.71
39Rail transport0.012.955.188.13
40Pipeline transport0.001.140.111.25
41Domestic navigation6.686.68
42International navigation0.0054.7354.73
43Non-specified transport0.150.121.261.53
44Other sectors13.4583.69173.683.3736.01149.2638.03497.49
45Residental11.0345.84118.422.7432.2973.9713.00297.30
46Community & public services1.2517.1641.330.262.1569.845.32137.31
47Agriculture & forestry1.0818.044.530.071.554.960.3430.56
48Fishing1.680.040.050.001.77
49Non-speficied0.090.979.390.260.020.4519.3830.56
50Non-energy use1.282.46101.7012.92118.36
51in industry/transf./energy1.112.4697.7112.92114.20
52of which:feedstocks0.162.4668.0312.9283.57
53in transport3.383.38
54in other sections0.170.610.77
55Electricity generated - TWh1012.690.02109.87801.95925.32497.60120.81108.090.633577.00
56in Electricity plants769.9564.64503.26912.96497.60118.9855.320.362923.07
57in CHP plants242.750.0245.23298.7012.361.8352.770.27653.93
58Heat generated - PJ722.420.08178.561007.854.8524.20359.023.88232.822569.67
59in CHP plants583.610.08154.30861.974.858.28290.551.7392.891998.25
60in Heat plants138.8124.27145.8815.92104.472.15139.93571.42

Rationale

OECD Europe consists of EU-27, MINUS Bulgaria, Cyprus, Estonia, Latvia, Lithuania, Malta, Romania and Slovenia, PLUS Iceland, Norway, Switzerland and Turkey

The gray area of columns A…L (the data table) is copied directly from IEA 2009 (see reference below table), and can be replaced with 2007 baseline data from any other country from the same document. In the particular case of Finland, apparet errors in the dividion of fuel use for CHP and Heat Plants - resulting in too low efficiency for CHP and 110% (!) thermal efficiency for Heat Plants was corrected in a way that did not change the overall balances. The unit is the same for all energies, tons of oil equivalent, used by IEA and others, and allowing direct replacement of, e.g. 1 toe of gas by 1 toe of oil, etc.

What's in the excel?

'OECD

  • OECD Europe energy balance sheet 2009 (A6..L74)
  • Thermal conversion efficiency, stock of 2009 (A2...K5)
    • What is it in the different columns?

Countries

  • Thermal conversion efficiency, stock of 2009 for every country, different values
  • Energy balance sheet Finland 2009 (IEA 2011) (A2...K5; A6...L74)
  • Energy balance sheet Germany 2009 (IEA 2011) (A77..K81; A82...L150)
  • Energy balance sheet Greece (IEA 2011) (A152...K156; A157...L225)
  • Energy balance sheet The Netherlands (IEA 2011) (A227...K231; A232...L300)

CVDLCDALY's

  • A graph of PM2.5 (three year running mean μg/m3) at (sub)urban stations in different countries in Europe
  • DALY/a thousands and DALY/a/100000 for Trachea, bronchus & lung cancers and Cardio-vascular diseases for EU-27 and OECD 22 countries, WHO 2002 (A1..I37)

TransportSummaryOECDEU

Irrelevant for now

Intake

  • Population pre-policy fuel ash PM intake, kg/a + iF for Primary PM (ppm) (A1..L61; A63..L119)
  • Population pre-policy secondary PM intake, kg/a + iF for Secondary PM (ppm) (N1...X61; N63...X119)
  • Population pre policy (EC+OC) PM intake (kg/a) + iF for Primary PM (ppm) (Z1...AJ61; Z63...AJ119)
  • Population post-policy total PM intake, kg/a (broken, shows just #REF!) (AL2...AW61)
  • Population post-policy BoD in DALY/a (broken, shows just #REF!) (AY2...DL61)
  • Summary of recommended intake fractions
  • Lung cancer, cardiopulmonary mortality, and long-tern exposure to fine particulate air pollution
  • Health benefit of cycling and walking (AW92...BP113)

PMemission

  • Fuel ash fine PM emission, kt/a (A9...L68)
    • Fuel ash contents (%) (A70...L126)
    • Fly ash removal efficiency (%) (A127...L183)
  • Secondary sulfate PM emission, kt((NH3)2SO4)/a (N9...X68)
    • Fuel sulfur contents (%) (N70...X126)
    • Process sulfur removal efficiency (%) (N127...X183)
  • (EC+OC)PM emission, kt/a (Z9...AJ68)
    • EC+OC emission factor (t/Mtoe) (Z70...AJ183)
  • Thousand tons of primary and secondary PM per year (AM9...AZ27)
    • Total PM emissions from centralised electricity and district heat generation (AM28...AZ69)

Mtoe

  • Thermal conversion efficiency (of different types of power plants for different fuels) (A3...L7)
  • Thermal conversion efficiency for new installations after 2009 (O3...X7)
  • Energy balance sheet 2009 for OECD Europe (Mtoe) (A8...L78)
    • (Transport sector)
  • OECD Europe post policy energy balance (Mtoe) (AA8...AK75)
  • CO2 emissions from the combustion of each fuel of interest…in generation of heat and power (MtCO2/Mtoe) (AN4...AX8)
  • Million tons of carbon dioxide (MtCO2) per year (in different industries, using different fuels) (AM9...BB76)

See also

Urgenche research project 2011 - 2014: city-level climate change mitigation
Urgenche pages

Urgenche main page · Category:Urgenche · Urgenche project page (password-protected)

Relevant data
Building stock data in Urgenche‎ · Building regulations in Finland · Concentration-response to PM2.5 · Emission factors for burning processes · ERF of indoor dampness on respiratory health effects · ERF of several environmental pollutions · General criteria for land use · Indoor environment quality (IEQ) factors · Intake fractions of PM · Land use in Urgenche · Land use and boundary in Urgenche · Energy use of buildings

Relevant methods
Building model · Energy balance · Health impact assessment · Opasnet map · Help:Drawing graphs · OpasnetUtils‎ · Recommended R functions‎ · Using summary tables‎

City Kuopio
 Climate change policies and health in Kuopio (assessment) · Climate change policies in Kuopio (plausible city-level climate policies) · Health impacts of energy consumption in Kuopio · Building stock in Kuopio · Cost curves for energy (prioritization of options) · Energy balance in Kuopio (energy data) · Energy consumption and GHG emissions in Kuopio by sector · Energy consumption classes (categorisation) · Energy consumption of heating of buildings in Kuopio · Energy transformations (energy production and use processes) · Fuels used by Haapaniemi energy plant · Greenhouse gas emissions in Kuopio · Haapaniemi energy plant in Kuopio · Land use in Kuopio · Building data availability in Kuopio · Password-protected pages: File:Heat use in Kuopio.csv · Kuopio housing

City Basel
 Buildings in Basel (password-protected)

Energy balances
Energy balance in Basel · Energy balance in Kuopio · Energy balance in Stuttgart · Energy balance in Suzhou

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeDimensionsUserComment
current13:30, 27 March 2014 (491 KB)Jouni (talk | contribs)Matti's final version. Changes as additions, not multiplications. Contains data for several countries. Combustor is removed. Several bug fixes.
13:42, 10 June 2013 (373 KB)Jouni (talk | contribs)Code commented and coloured for clarity.
09:56, 28 February 2010 (362 KB)Jouni (talk | contribs)Model for energy supply and demand calculations by Matti Jantunen. Designed for variable Energy supply in Europe. Original name Balance.OECD_Europe.2007.baseline-Av+Nav.EUcomp+EFs+iFs+Combustor.xls. Category:Energy {{tool|moderator=Jouni}}
  • You cannot overwrite this file.
Retrieved from "http://en.opasnet.org/en-opwiki/index.php?title=File:Energy_supply_in_Europe.xls&oldid=37166"