Energy preprocessor

64 series are read into the energy preprocessor. Most energy data comes from: BGR, BP, 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:

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:

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:

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:

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:

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:

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: WDI 2014 May Batch Pull
• Definition: Electricity Consumption Total in BBOE
• Country coverage: 136 Countries, 1960-2011
• Source definition:

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:

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:

If null then use SeriesEnProdHydroIEA

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:

If null use SeriesEnConNucBP

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:

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:

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:

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 20012 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).
• Coverage: 137 Countries, 1960-2011
• Source definition:

If null use SeriesEnProdSolar

• Source:
• Definition:
• Coverage:
• Source definition:

If IsNull(Solar) Then Solar = 0.000001

Tidal/Wave

Initialize using EnPTideWaveIEATbl

• Source:
• Definition:
• Coverage:
• Source definition:

If null use SeriesEnProdTideWave

• Source:
• Definition:
• Coverage:
• Source definition:

If IsNull(TideWave) Then TideWave = 0.000001

Biodiesel

Initialize using SeriesEnProdBiodieselIEA

• Source:
• Definition:
• Coverage:
• Source definition:

If IsNull(BioDiesel) Then BioDiesel = 0.000001

Biogas

Initialize using SeriesEnProdBiogasIEA

• Source:
• Definition:
• Coverage:
• Source definition:

If IsNull(BioGas) Then BioGas = 0.000001

Trade

Initialize total energy exports with SeriesEnExportsTotalIEA

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

Initialize coal exports using SeriesEnExportsCoalIEA

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