Energy preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 715: Line 715:
----
----


Initialize Undiscovered Energy Resources, Gas using '''Series''''''EnResorGasUSGS​'''
Initialize Undiscovered Energy Resources, Gas using '''SeriesE''''''nResorGasUSGS​'''


*'''Source: '''U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]
*'''Source: '''U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]
Line 729: Line 729:
*Source defintion: U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]
*Source defintion: U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]


Initialize Undiscovered Energy Resources, Oil using '''Series''''''EnResorOilUSGS'''
Initialize Undiscovered Energy Resources, Oil using '''Series''''''EnResorOilUSGS'''


*'''Source: '''U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]
*'''Source: '''U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at:[http://pubs.usgs.gov/dds/dds-060/index.html#TOP http://pubs.usgs.gov/dds/dds-060/index.html#TOP]
Line 764: Line 764:
*Source defintion:
*Source defintion:


Initialize using '''Series''''''EnResorGasUSGS'''
Initialize using '''Series''''''EnResorGasUSGS'''


*'''Source: '''
*'''Source: '''
Line 778: Line 778:
*Source defintion:
*Source defintion:


Initialize Oil Reserves using '''Series''''''EnResorGasUSGS'''
Initialize Oil Reserves using '''Series''''''EnResorGasUSGS'''


*'''Source: '''
*'''Source: '''

Revision as of 17:00, 17 June 2016

64 series are read into the energy preprocessor. Most energy data comes from: BGRBP, EIA, and the IEA. There are some old WRI series that need to be either updated or the preprocessor needs to be adjusted. There are also some old series from the Oil & Gas Journal that need to be revisited. World Energy Council (WEC)

Energy series pulled into preprocessor

Table Definition Source Notes Last IFs Update
SeriesEnProdCoal Coal production WRI CD 98    
SeriesEnProdGas Natural gas production WRI CD 00-01    
SeriesEnProdOil Oil production WRI CD 98    
SeriesEnReserHyd Energy reserves, hydro WRI Annual    
SeriesEnReserGas Energy reserves, gas WEC; Oil and Gas Journal; 1960 estimated AT;CN 02/25/2012
SeriesEnReserOil Energy reserve, oil, in billion barrels WEC; Oil and Gas Journal; 1960 estimated AT;CN;Brunei includes Malaysia to 1975 02/25/2012
SeriesEnConPhoto Energy consumption, photovoltaic solar WRI Earthtrends http://earthtrends.wri.org/ Converted from thousand tons oil equivalent with 7.3/1000000 2002/11
SeriesEnConWind Energy consumption, wind WRI Earthtrends http://earthtrends.wri.org/ Converted from thousand tons oil equivalent with 7.3/1000000 2002/11
SeriesEnProdGeoTherm Energy production, geothermal WRI Earthtrends http://earthtrends.wri.org/ Converted from thousand tons oil equivalent with 7.3/1000000 2002/11
SeriesEnProdSolar Energy production, solar WRI Earthtrends http://earthtrends.wri.org/ Converted from thousand tons oil equivalent with 7.3/1000000 2002/11
SeriesEnProdTideWave Energy production, tide, wave, and water WRI Earthtrends http://earthtrends.wri.org/ Converted from thousand tons oil equivalent with 7.3/1000000 2002/11
SeriesEnResorGasUSGS Undiscovered energy resources, gas U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at: http://pubs.usgs.gov/dds/dds-060/index.html#TOP   2005/01
SeriesEnResorNGLUSGS Undiscovered energy resources, natural gas liquids U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at: http://pubs.usgs.gov/dds/dds-060/index.html#TOP   2005/01
SeriesEnResorOilUSGS Undiscovered energy resources, oil U.S. GEOLOGICAL SURVEY WORLD PETROLEUM ASSESSMENT 2000  available at: http://pubs.usgs.gov/dds/dds-060/index.html#TOP   2005/01
SeriesEnResorCoalBGRBBOE Coal resources BGR; "Reserves, Resources and Availability of Energy Resources 2010"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010
Combined hard and brown coal totals; Conversions: 1 ton hard coal=4.879boe, brown=2.053boe; MJE;CN 2012/03/01
SeriesEnReserGasBGR Natural gas reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/04
SeriesEnReserCBMBGR Coalbed methane reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012" SGH 2013/04/05
SeriesEnReserHeavyOilBGR Heavy Oil Reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnReserOilBGR Crude oil reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnReserOilSandsBGR Oil Sands Reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnReserShaleGasBGR Shale Gas Reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012" SGH 2013/04/05
SeriesEnReserShaleOilBGR Shale Oil Reserves BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorCBMBGR Coalbed methane Resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorGasBGR Natural gas resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
Total is inclusive of EnReserGasBGR; SGH 2013/04/05
SeriesEnResorHeavyOilBGR Heavy Oil Resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorOilBGR Crude oil resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
Total is inclusive of EnReserOilBGR; SGH 2013/04/05
SeriesEnResorOilSandsBGR Oil sands resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorShaleGasBGR Shale Gas Resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorShaleOilBGR Shale Oil resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnResorTightGasBGR Tight Gas Resources BGR; "Reserves, Resources and Availability of Energy Resources 2012"
Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012
SGH 2013/04/05
SeriesEnExportsCoalIEA Exports of coal and coal products IEA 2012 BATCH PULL SMD; DAB - From SUMMARY FILE; MJE; SGH; Converted ktoe to BBOE 2013/08/13
SeriesEnExportsNatGasIEA Exports of natural gas IEA 2012 BATCH PULL SMD; DAB - From SUMMARY FILE; MJE;SGH 2013/08/13
SeriesEnExportsOilIEA Crude oil exports IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; converted ktoe to bboe 2013/08/13
SeriesEnExportsOilProductsIEA Exports of Crude Natural Gas Liquids IEA 2012 BATCH PULL SMD; DAB - From SUMMARY FILE; MJE;SGH 2013/08/13
SeriesEnExportsPeatIEA Peat exports IEA 2012 BATCH PULL SMD; DAB - From SUMMARY FILE; MJE;SGH 2013/08/13
SeriesEnExportsTotalIEA Total energy exports IEA 2012 BATCH PULL SMD; DAB - From SUMMARY FILE; MJE;SGH 2013/08/13
SeriesEnImportsCoalIEA Imports of coal and coal products IEA 2012 BATCH PULL Converted ktoe to BBOE; 7.3 * 10e-6 BBOE/ktoe; MJE; DAB 2013/08/13
SeriesEnImportsNatGasIEA Imports of natural gas IEA 2012 BATCH PULL DAB - FROM EXTENDED FILE; MJE;SGH 2013/08/13
SeriesEnImportsOilIEA Crude Oil Imports IEA 2012 BATCH PULL DAB - FROM EXTENDED FILE; MJE;SGH 2013/08/13
SeriesEnImportsOilProductsIEA Imports of Crude Natural Gas Liquids IEA 2012 BATCH PULL Converted ktoe to BBOE; 7.3 * 10e-6 BBOE/ktoe; MJE; DAB 2013/08/13
SeriesEnImportsPeatIEA Peat imports IEA 2012 BATCH PULL DAB - FROM EXTENDED FILE; MJE;SGH 2013/08/13
SeriesEnImportsTotalIEA Total energy imports IEA 2012 BATCH PULL Converted ktoe to BBOE; 7.3 * 10e-6 BBOE/ktoe; MJE; DAB 2013/08/13
SeriesEnProdBiodieselIEA Production of biodiesel. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdBiogasIEA Production of biogas (derived from anaerobic fermentation of biomass and solid wastes and combusted to produce heat and/or power). IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdCoalIEA Production of coal products IEA 2012 BATCH PULL SMD; DAB - FROM SUMMARY FILE; MJE; SGH 2013/08/13
SeriesEnProdGeothermIEA Energy produced from heat emitted with earth's crust, usually in the form of hot water or steam. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdHydroIEA Potential and kinetic energy of water converted into electricity in hydroelectric plants. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdNatGasIEA Production of Natural Gas IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdNuclearIEA Energy produced by nuclear fission or nuclear fusion. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdOilIEA Crude oil production IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdSolarPhotoIEA Electricity production from photovoltaic cells. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdSolarThermIEA Energy production from solar radiation used for hot water production and electricity generation (passive solar for direct heating, cooling, lighting not included). IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdTideWaveOceanIEA Electricity generation derived from tidal movement, wave motion, or ocean current. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnProdWindIEA Electricity generation by wind turbines. IEA 2012 BATCH PULL SMD; DAB - FROM EXTENDED FILE; SGH 2013/08/13
SeriesEnConElec Electricity consumption total in BBOE WDI 2014 May BATCH PULL ME; PM; AMB; *5.89*0.0001*0.000000001 2014/06/11
SeriesGDPCurDol Gross Domestic Product in Current US$ WDI  BATCH PULL AD 2015/07/14
SeriesEnConHydroBP Hydro-electricity consumption BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *.00733 2016/01/27
SeriesEnConNucBP Nuclear-electricity consumption BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *.00733 2016/01/27
SeriesEnProdCoalBP
Coal production BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *.00733 2016/01/27
SeriesEnProdGasBP
Gas (natural) production BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *.00733 2016/01/27
SeriesEnProdOilBP Oil production BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *.00733 2016/01/27
SeriesEnReserCoalBP Coal reserves BP’s Statistical Review of World Energy 2013 BV; AMBl SH; .00733 2016/01/27
SeriesEnReserGasBP Gas (natural) reserves BP’s Statistical Review of World Energy 2013 BV; AMB; SH; *6.6 2016/01/27
SeriesEnReserOilBP Oil reserves BP’s Statistical Review of World Energy 2013
BV; AMB; SH 2016/01/27

Initialization of data

Production

Oil

Oil production is initialized using SeriesEnProdOilIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Crude Oil Production
  • Country coverage: 137 Countries, 1971-2011
  • Source definition: Crude oil comprises crude oil, natural gas liquids, refinery feedstocks, and additives as well as other hydrocarbons (including emulsified oils, synthetic crude oil, mineral oils extracted from bituminous minerals such as oil shale, bituminous sand, etc., and oils from coal liquefaction). Crude oil is a mineral oil consisting of a mixture of hydrocarbons of natural origin and associated impurities, such as sulphur. It exists in the liquid phase under normal surface temperatures and pressure and its physical characteristics (density, viscosity, etc.) are highly variable. It includes field or lease condensates (separator liquids) which are recovered from associated and non-associated gas where it is commingled with the commercial crude oil stream. All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro 

If null use BP data: SeriesEnProdOilBP

  • Source: BP's Statistical Review of World Energy 2013
  • Definition: Data in Million Tonnes of Oil Equivalent
  • Country coverage: 49 Countries, 1965-2014
  • Source definition: Oil production data includes crude oil, tight oil, oil sands, and NGLS (the liquid content of natural gas where this is removed separately).  The data excludes liquid fuels from other sources such as biomass and derivatives of coal and natural gas.  World oil production tables are available in both thousand barrels daily and million tonnes.  All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

If still null use WRI data: SeriesEnProdOil

  • Source: WRI CD 98
  • Definition: Oil Production
  • Country coverage: 156 Countries, 1960-1995 (last year with data)
  • Source definition:

If still null then estimate as .02% of GDP:

            If IsNull(COil) Then COil = CGDP(ICount%) * 0.002 * 0.1

Gas

Gas production is initialized using SeriesEnProdNatGasIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Production of Natural Gas
  • Country coverage: 137 Countries, 1960-2011.
  • Source definition: Natural gas comprises gases, occurring in underground deposits, whether liquefied or gaseous, consisting mainly of methane. It includes both "non-associated" gas originating from fields producing only hydrocarbons in gaseous form, and "associated" gas produced in association with crude oil as well as methane recovered from coal mines (colliery gas) or from coal seams (coal seam gas). Production represents dry marketable production within national boundaries, including offshore production and is measured after purification and extraction of NGL and sulphur. It includes gas consumed by gas processing plants and gas transported by pipeline. Quantities of gas that are re-injected, vented or flared are excluded. All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro 

If null then use SeriesEnProdGasBP

  • Source: BP's Stastical Review of World Energy 2013
  • Definition: Gas (Natural) Production
  • Country coverage: 49 Countries, 1970-2014
  • Source definition: Gas production comprises marketed production and excludes gas flared or recycled gas.  Includes natural gas produced for gas-to-liquids transformation.  As far as possible, the data represents standard cubic meters (at 150 degrees Celsius and 1013 mbar.  (May not necessarily equate with gas volumes expressed in national terms).  Data given in both billion cubic meters and million tons equivalent for world natural gas production for world natural gas production tables.  Data in excel workbook in billion cubic feet per day (bcf/d).  All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

Make sure it is not negative:

  • CGas = AMAX(0.000001, CGas)

If still null then set as .02% of GDP:

            If IsNull(CGas) Then CGas = CGDP(ICount%) * 0.002 * 0.1

Coal

Coal production initialized using SeriesEnProdCoalIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Production of Coal Products
  • Country coverage: 137 Countries, 1960-2011
  • Source definition: Coal and peat includes all coal, both primary (including hard coal and lignite) and derived fuels (including patent fuel, coke oven coke, gas coke, BKB, gas works gas, coke oven gas, blast furnace gas and oxygen steel furnace gas). Peat is also included in this category.Note: starting with 2011 edition, gas works gas is included here with coal. In prior years, gas works gas was included with natural gas.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro 

If null use BP data: SeriesEnProdCoalBP

  • Source: BP's Statistical Review of World Energy 2013
  • Definition: Coal Production
  • Country coverage: 33 Countries, 1981-2014
  • Source definition: Coal production includes data for commercial solid fuels only.  Included in the hard coal category are bituminous and anthracite.  Sub-bituminous coal includes lignite and brown coal.  Other commercial solid fuels are also included.  Data excludes coal converted to liquid or gaseous fuels but includes coal consumed in transformation processes.  Coal production table: units in million tonnes oil equivalent (mtoe).  Units in excel workbook: data million tonnes.  All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

If still null use WRI data: SeriesEnProdCoal

  • Source: WRI CD 98
  • Definition: Coal Production
  • Country coverage: 155 Countries, 1960-1995
  • Source definition:

Make sure it is not negative:

                    ENPCoal(ICount%) = AMAX(0.000001, ENPCoal(ICount%))

If still null set as .04% of GDP:

            If IsNull(ENPCoal(ICount%)) Then ENPCoal(ICount%) = CGDP(ICount%) * 0.002 * 0.2

Electricity

Initialize using SeriesEnConElec

  • Source: World Development Indicators (WDI) 2014 May Batch Pull
  • Definition: Electricity Consumption Total in BBOE
  • Country coverage: 136 Countries, 1960-2011
  • Source definition: Electric Power Consumption (kWh per capita): Electric power consumption measures the production of power plants and combined heat and power plants less transmission, distribution, and transformation losses and own use by heat and power plants.  WDI definition available at: http://data.worldbank.org/indicator/EG.USE.ELEC.KH.PC

If null then set as .02% of GDP:

            If IsNull(Elec) Then Elec = CGDP(ICount%) * 0.002 * 0.1

Note: I'm pretty sure this (Elec) is not used anywhere

Hydro

Initialize using SeriesEnProdHydroIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Potential and Kinetic Energy of Water Converted into Electricity in Hydroelectric Plants
  • Country coverage: 137 Countries, 1960-2011
  • Source definition: Hydro shows the energy content of the electricity produced in hydro power plants. Hydro output excludes output from pumped storage plants.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro 

If null use BP Data: SeriesEnConHydroBP

  • Source: BP's Statistical Review of World Energy 2013
  • Definition: Hydro-Electricity Consumption.  Data in Million Tonnes of Oil Equivalent
  • Country coverage: 67 Countries, 1965-2014
  • Source defintion: The primary energy value of hydroelectricity generation has been derived by calculating the equivalent amount of fossil fuel required to generate the same volume of electricity in a thermal power station, assuming a conversion efficiency of 38% (the average for OECD Thermal Power generation).  Data based on gross primary hydroelectric generation and does not account for cross-border electricity supply.  All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

If null then use SeriesEnProdHydroIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Potential and Kinetic Energy of Water Converted into Electricity in Hydroelectric Plants
  • Country coverage: 137 Countries, 1960-2011
  • Source defintion: 
  • Hydro shows the energy content of the electricity produced in hydro power plants. Hydro output excludes output from pumped storage plants.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro 

Note: redundant

If still null then set as .02% of GDP

            If IsNull(hyd) Then hyd = CGDP(ICount%) * 0.002 * 0.01

Make sure it's not too small

            If hyd < CGDP(ICount%) * 0.002 * 0.001 Then hyd = CGDP(ICount%) * 0.002 * 0.001

Nuclear

Initialize using SeriesEnProdNuclearIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Energy Produced by Nuclear Fission or Nuclear Fusion
  • Coverage: 137 Countries, 1960-2011
  • Source definition: Nuclear shows the primary heat equivalent of the electricity produced by a nuclear power plant with an average thermal efficiency of 33 per cent.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

  If null use SeriesEnConNucBP

  • Source: BP's Statistical Review of World Energy
  • Definition: Nuclear-Electricity Consumption (in million tonnes of oil equivalent)
  • Coverage: 67 Countries, 1965-2014
  • Source definition:  Data are based on gross generation, not accounting for cross-border electricity supply.  The primary value of nuclear power generation has been derived by calculating the equivalent amount of fossil fuel required to generate the same volume of electricity in a thermal power station, assuming a conversion efficiency of 38% (the average for OECD thermal power generation).  Data for the units are in million tones oil equivalent (mtoe) in the PDF.  In addition, the data are available in the Excel workbook in terawatt-hours (twh).  All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

If still null then

  • If IsNull(Nuc) Then Nuc = 0.00001

Geothermal

Initialize using SeriesEnProdGeothermIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Energy Produced from Heat Emitted with Earth's Crust, Usually in the form of Hot Water or Steam
  • Coverage: 137 Countries, 1960-2011
  • Source definition: Geothermal, solar, etc. shows production of geothermal, solar, wind and tide/wave/ocean energy and the use of these energy forms for electricity and heat generation. Unless the actual efficiency of the geothermal process is known, the quantity of geothermal energy entering electricity generation is inferred from the electricity production at geothermal plants assuming an average thermal efficiency of 10%. Other uses shown in this column relate to geothermal and solar heat.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If null then use SeriesEnProdGeoTherm

  • Source: WRI Earthtrends http://earthtrends.wri.org/  
  • Original Source: International Energy Agency (IEA) 2001.  Energy Balances of OECD Countries (2001 Edition) and Energy Balances of non-OECD Countries (2001 Edition). http://data.iea.org/ieastore/default.asp.Paris: OECD.
  • Definition: Energy Production, Geothermal
  • Coverage: 125 Countries, 1960-1997
  • Source definition:

If IsNull(Geo) Then Geo = 0.00001

Photovoltaic

Initialize using SeriesEnProdSolarPhotoIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Electricity Production from Photovoltaic Cells
  • Coverage: 137 Countries, 1960-2011
  • Source definition: Geothermal, solar, etc. shows production of geothermal, solar, wind and tide/wave/ocean energy and the use of these energy forms for electricity and heat generation. Unless the actual efficiency of the geothermal process is known, the quantity of geothermal energy entering electricity generation is inferred from the electricity production at geothermal plants assuming an average thermal efficiency of 10%. For solar, wind and tide/wave/ocean energy, the quantities entering electricity generation are equal to the electrical energy generated. Other uses shown in this column relate to geothermal and solar heat.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If null then use SeriesEnConPhoto

  • Source: WRI Earthtrends http://earthtrends.wri.org/   
  • Original Source: International Energy Agency (IEA) 2001.  Energy Balances of OECD Countries (2001 Edition) and Energy Balances of non-OECD Countries (2001 Edition). http://data.iea.org/ieastore/default.asp.Paris: OECD.
  • Definition: Energy Consumption, Photovoltaic Cells
  • Coverage: 128 Countries, 1960-1999
  • Source definition:

If IsNull(Photo) Then Photo = 0.000001

Wind

Initialize using SeriesEnProdWindIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Electricity Generation by Wind Turbines
  • Coverage: 137 Countries, 1960-2011
  • Source definition: Geothermal, solar, etc. shows production of geothermal, solar, wind and tide/wave/ocean energy and the use of these energy forms for electricity and heat generation. Unless the actual efficiency of the geothermal process is known, the quantity of geothermal energy entering electricity generation is inferred from the electricity production at geothermal plants assuming an average thermal efficiency of 10%. For solar, wind and tide/wave/ocean energy, the quantities entering electricity generation are equal to the electrical energy generated. Other uses shown in this column relate to geothermal and solar heat.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If null use SeriesEnConWind

  • Source: WRI Earthtrends http://earthtrends.wri.org/   
  • Original Source: International Energy Agency (IEA) 2001.  Energy Balances of OECD Countries (2001 Edition) and Energy Balances of non-OECD Countries (2001 Edition). http://data.iea.org/ieastore/default.asp.Paris: OECD.
  • Definition: Energy Consumption, Wind
  • Coverage: 128 Countries, 1960-1999
  • Source definition:

If IsNull(Wind) Then Wind = 0.000001

Solar

Initialize using SeriesEnProdSolarThermIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Energy Production from Solar Radiation used for Hot Water Production and Electricity Generation (Passive Solar for Direct Heating, Cooling, Lighting not Included).  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;
  • Coverage: 137 Countries, 1960-2011
  • Source definition:

If null use SeriesEnProdSolar

  • Source: WRI Earthtrends http://earthtrends.wri.org/   
  • Original Source: International Energy Agency (IEA) 2001.  Energy Balances of OECD Countries (2001 Edition) and Energy Balances of non-OECD Countries (2001 Edition). http://data.iea.org/ieastore/default.asp.Paris: OECD.
  • Definition: Energy Production, Solar
  • Coverage: 128 Countries, 1960-1999
  • Source definition:

If IsNull(Solar) Then Solar = 0.000001

Tidal/Wave

Initialize using EnProdTideWaveOceanIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Electricity Generation Derived from Tidal Movement, Wave Motion, or Ocean Current
  • Coverage: 137 Countries, 1960-2011
  • Source definition:  Geothermal, solar, etc. shows production of geothermal, solar, wind and tide/wave/ocean energy and the use of these energy forms for electricity and heat generation. Unless the actual efficiency of the geothermal process is known, the quantity of geothermal energy entering electricity generation is inferred from the electricity production at geothermal plants assuming an average thermal efficiency of 10%. For solar, wind and tide/wave/ocean energy, the quantities entering electricity generation are equal to the electrical energy generated. Other uses shown in this column relate to geothermal and solar heat. All IEA definitions available at:   https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If null use SeriesEnProdTideWave

  • Source: WRI Earthtrends http://earthtrends.wri.org/   
  • Original Source: International Energy Agency (IEA) 2001.  Energy Balances of OECD Countries (2001 Edition) and Energy Balances of non-OECD Countries (2001 Edition). http://data.iea.org/ieastore/default.asp.Paris: OECD.
  • Definition: Energy Production, Tide, Wave, and Water
  • Coverage: 124 Countries, 1960-1997
  • Source definition:

If IsNull(TideWave) Then TideWave = 0.000001

Biodiesel

Initialize using SeriesEnProdBiodieselIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Production of Biodiesel
  • Coverage: 137 Countries, 1960-2011
  • Source definition: Biodiesels includes biodiesel (a methyl-ester produced from vegetable or animal oil, of diesel quality), bio-dimethylether (dimethylether produced from biomass), Fischer Tropsh (Fischer Tropsh produced from biomass), cold pressed bio-oil (oil produced from oil seed through mechanical processing only) and all other liquid biofuels which are added to, blended with or used straight as transport diesel. Other liquid biofuels includes liquid biofuels not reported in either biogasoline or biodiesels. All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If IsNull(BioDiesel) Then BioDiesel = 0.000001

Biogas

Initialize using SeriesEnProdBiogasIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Production of Biogas (Derived from Anaerobic Fermentation of Biomass and Solid Wastes and Combusted to Produce Heat and/or Power).
  • Coverage: 137 Countries, 1960-2011.
  • Source definition: Biogasoline includes bioethanol (ethanol produced from biomass and/or the biodegradable fraction of waste), biomethanol (methanol produced from biomass and/or the biodegradable fraction of waste), bioETBE (ethyl-tertio-butyl-ether produced on the basis of bioethanol; the percentage by volume of bio-ETBE that is calculated as biofuel is 47%) and bioMTBE (methyl-tertio-butyl-ether produced on the basis of biomethanol: the percentage by volume of bioMTBE that is calculated as biofuel is 36%).  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

If IsNull(BioGas) Then BioGas = 0.000001

Trade

Initialize total energy exports with SeriesEnExportsTotalIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Total Energy Exports
  • Coverage: 137 Countries, 1960-2011
  • Source defintion: Electricity amounts are considered as imported or exported when they have crossed the national territorial boundaries of the country. If electricity is "wheeled" or transited through a country, the amount is shown as both an import and an export.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

Initialize coal exports using SeriesEnExportsCoalIEA

  • Source: IEA 2012 Batch Pull
  • Definition: Exports of Coal and Coal Products
  • Coverage: 137 Countries, 1960-2011
  • Source defintion: Coal imports and exports comprise the amount of fuels obtained from or supplied to other countries, whether or not there is an economic or customs union between the relevant countries. Coal in transit should not be included.  All IEA definitions available at:  https://www.iea.org/statistics/resources/balancedefinitions/#hydro&nbsp;

Reserves 


Initialize Coal Reserves using SeriesEnReserCoalBP

  • Source: BP’s Statistical Review of World Energy 2013
  • Definition: Coal Reserves (Data in million tonnes of oil equivalent)
  • Coverage: 33 Countries, 2007-2014
  • Source defintion: Total proved reserves of coal are generally taken to be those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known deposits under existing economic and operating conditions.  Total proved coal reserves are shown for anthracite and bituminous (including brown coal) and sub-bituminous and lignite.  Coal reserve data is in million tonnes.  Reserves-to-production (R/P) ratios represent the length of time that those remaining reserves would last if production were to continue at the previous year's rate.  They are calculated by dividing remaining reserves at the end of the year by the production in that year.  The R/P ratios are calculated excluding other solid fuels in reserves and production.  R/P ratios are available by country and feature in the table of coal reserves.

All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

Initialize Natural Gas Reseves using SeriesEnReserGasBP

  • Source: BP’s Statistical Review of World Energy 2013
  • Definition: Gas (Natural) Reserves (Data in million tonnes of oil equivalent)
  • Coverage: 51 Countries, 1980-2014
  • Source defintion: Total proved reserves of natural gas are generally taken to be those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known reservoirs under existing economic and operating conditions.  Rather the data series has been compiled using a combination of primary official sources and third-party data.  There is a time series of natural gas reserves.  Data are measured in billion cubic metres.Although every effort is made to come up with a consistent series for reserves based on a common definition, in reality different countries use different methodologies and the data have varying levels of reliability.R/P ratios represent the length of time that those remaining reserves would last if production were to continue at the previous year's rate.  They are calculated by dividing remaining reserves at the end of the year by the production in that year.  Reserves-to-production (R/P) ratios are available by country and feature in the table of gas reserves. All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

Initialize Oil Reserves using SeriesEnReserOilBP

  • Source: BP’s Statistical Review of World Energy 2013
  • Definition: Oil Reserves (Data in thousand million barrels)
  • Coverage: 49 Countries (1980-2014)
  • Source defintion: Total proved reserves of oil are those quantities that geological and engineering information indicates with reasonable certainty can be recovered in the future from known reservoirs under existing economic and geological conditions.  The data series has been compiled using a combination of primary official sources and third-party data.  Oil reserves include field condensate and natural gas liquids as well as crude oil.  Liquid hydrocarbon fuels from non-hydrocarbon sources, such as ethanol from corn or sugar or synthetic oil derived from natural gas (so-called GTL or gas-to-liquids), are not included in either the reserves or production series.  Data are measured in thousand million barrels.  R/P ratios represent the length of time that those remaining reserves would last if production were to continue at the previous year's rate.  They are calculated by dividing remaining reserves at the end of the year by the production in that year.  Reserves-to-production (R/P) ratios are available by country and feature in the table of oil reserves. All BP defitions available at: http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html

Resources 


Initialize Undiscovered Energy Resources, Gas using SeriesE'nResorGasUSGS​'

Initialize Undiscovered Energy Resources, Natural Gas Liquids using 'Series'EnResorNGLUSGS

Initialize Undiscovered Energy Resources, Oil using Series'EnResorOilUSGS'

Initialize using 'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize using 'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize Oil Reserves'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize  using 'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize using Series'EnResorGasUSGS'

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize using 'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize Oil Reserves using Series'EnResorGasUSGS'

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion:

Initialize Oil Reserves using 'Series'EnResorGasUSGS

  • Source: 
  • Definition: 
  • Coverage: 
  • Source defintion: