Energy Data, BGR - Revision history

Norah.Shamin at 17:03, 11 March 2026

2026-03-11T17:03:32Z

Norah.Shamin at 20:07, 2 July 2025

2025-07-02T20:07:19Z

← Older revision		Revision as of 20:07, 2 July 2025
Line 1:		Line 1:
			= Summary =
	The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [https://www.bgr.bund.de/EN/Themen/Energie/Produkte/produkte_node_en.html?tab=Energy+Studies here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.		The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [https://www.bgr.bund.de/EN/Themen/Energie/Produkte/produkte_node_en.html?tab=Energy+Studies here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.

	= ~~Series pulled from BGR~~ =		= Tables In IFs =
	{\| class="wikitable"		{\| class="wikitable"
	\|Variable		!Variable
	\|Definition		!Definition
	\|Units		!Units
	\|Years		!Years
	\|Last IFs Update		!Last IFs Update
	\|UsedInPreprocessor		!UsedInPreprocessor
	\|UsedInPreprocessorFileName		!UsedInPreprocessorFileName
	\|-		\|-
	\|EnCumProdGasBGR		\|EnCumProdGasBGR
Line 147:		Line 148:
	\|ENER		\|ENER
	\|}		\|}
			= Data Pulling Instructions =


	= Instructions ~~on importing BGR data~~ =

	'''Process of importing and blending:'''		'''Process of importing and blending:'''
Line 156:		Line 154:
	In preparing these series, first downloaded the relevant energy data from the [https://www.bgr.bund.de/EN/Themen/Energie/Produkte/produkte_node_en.html?tab=Energy+Studies BGR website], or are available through a google search of "BGR Energy Resources [YEAR]".		In preparing these series, first downloaded the relevant energy data from the [https://www.bgr.bund.de/EN/Themen/Energie/Produkte/produkte_node_en.html?tab=Energy+Studies BGR website], or are available through a google search of "BGR Energy Resources [YEAR]".

	* The study ~~reported~~ data in previous year.		* The study reports data in previous year.
	* '''Missing BGR Energy Study 2020, thus, we don't have data in 2019.'''		* '''Missing BGR Energy Study 2020, thus, we don't have data in 2019.'''
	* Starting from 2019, BGR also provided data in excel spreadsheet. Thus, the data after 2018 can be extracted from excel, not pdf.		* Starting from 2019, BGR also provided data in excel spreadsheet. Thus, the data after 2018 can be extracted from excel, not pdf.
Line 165:		Line 163:
	Combined new data and current data in IFsHistSeries.db.		Combined new data and current data in IFsHistSeries.db.

			= Data Notes =
	'''Some notes on the formatting process:'''		'''Some notes on the formatting process:'''

Yutang.Xiong: Yutang.Xiong moved page BGR data to Energy Data, BGR without leaving a redirect

2025-06-04T22:20:06Z

Yutang.Xiong moved page BGR data to Energy Data, BGR without leaving a redirect

← Older revision	Revision as of 22:20, 4 June 2025
(No difference)

Kexin.Shang: /* Instructions on importing BGR data */

2024-04-16T23:38:31Z

Instructions on importing BGR data

Show changes

AlisaNelson at 00:52, 21 June 2017

2017-06-21T00:52:34Z

Wikiadmin at 16:46, 2 May 2016

2016-05-02T16:46:13Z

← Older revision		Revision as of 16:46, 2 May 2016
Line 89:		Line 89:
	#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil		#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil
	#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">		#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
	~~</ol></ol>~~

Wikiadmin at 16:45, 2 May 2016

2016-05-02T16:45:57Z

← Older revision		Revision as of 16:45, 2 May 2016
Line 90:		Line 90:
	#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">		#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
	</ol></ol>		</ol></ol>
	~~</ol>~~
	~~</ol> </ol>~~

Wikiadmin at 19:17, 30 April 2016

2016-04-30T19:17:15Z

Show changes

Wikiadmin at 19:15, 30 April 2016

2016-04-30T19:15:46Z

← Older revision		Revision as of 19:15, 30 April 2016
Line 1:		Line 1:
	The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.		The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.

	~~= Current Status =~~

	~~Brandon Voss pulled this data in February 2016 and Kristen Kennedy vetted. Problems found in the consolidation phase and is being re-vetted.~~

	~~Link to task on Teamwork: [https://pardeecenter.teamwork.com/tasks/3995004 https://pardeecenter.teamwork.com/tasks/3995004]~~

	= Series pulled from BGR =		= Series pulled from BGR =
Line 255:		Line 249:
	#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">		#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
	</ol></ol>		</ol></ol>
			</ol>
	</ol>		</ol>

Wikiadmin at 19:09, 30 April 2016

2016-04-30T19:09:10Z

← Older revision		Revision as of 19:09, 30 April 2016
Line 1:		Line 1:
	~~Back to [[Energy_preprocessor\|Energy preprocessor]]~~

	The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.		The Federal Institute for Geosciences and Natural Resources, or BGR, is a German Agency which publishes data on oil and gas resources and reserves. BGR data can be accessed [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here]. This data is useful because resources and reserves are broken into their unconventional sub-components such as shale gas, tight oil, and coalbed methane. This is important in initializing total resources and reserves in the model, especially with the rise in unconventional gas and oil production in North America.

Line 231:		Line 229:
	Sudan and South Sudan: Most of the time, BGR lists reserve and resource values for "Sudan" and "South Sudan" individually. On occasion though, BGR will use "Sudan and South Sudan" as a composite, representing aggregated data for both of the countries but not providing it on an individual basis. This is rare, and only takes place in series EnReserGasBGR and EnResorGasBGR. In these cases, I calculated the values for "Sudan" and "South Sudan" by taking the value of "Sudan and South Sudan" and dividing it by the ratio of land mass between Sudan (728,215 sqm) and South Sudan (239,285 sqm). Also, per Steve Hedden, we don't enter values for Sudan in the series EnCumProdGas and EnCumProdOil.		Sudan and South Sudan: Most of the time, BGR lists reserve and resource values for "Sudan" and "South Sudan" individually. On occasion though, BGR will use "Sudan and South Sudan" as a composite, representing aggregated data for both of the countries but not providing it on an individual basis. This is rare, and only takes place in series EnReserGasBGR and EnResorGasBGR. In these cases, I calculated the values for "Sudan" and "South Sudan" by taking the value of "Sudan and South Sudan" and dividing it by the ratio of land mass between Sudan (728,215 sqm) and South Sudan (239,285 sqm). Also, per Steve Hedden, we don't enter values for Sudan in the series EnCumProdGas and EnCumProdOil.

	Another issue that needs mentioning is BGR's usage of dashes ("-") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.		Another issue that needs mentioning is BGR's usage of dashes ("-") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.

	BGR occasionally uses "n.s." in its data, which is intrepreted as a null value.		BGR occasionally uses "n.s." in its data, which is intrepreted as a null value.

	If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Ex. <0.05 is entered as 0.05.		If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Ex. <0.05 is entered as 0.05.
Line 257:		Line 255:
	#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">		#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
	</ol></ol>		</ol></ol>
			</ol>

← Older revision		Revision as of 00:52, 21 June 2017
Line 46:		Line 46:
	'''Process of importing and blending:'''		'''Process of importing and blending:'''

	In preparing these series, I first downloaded the ~~two~~ energy reports from the BGR website~~. These~~ are ~~located in the folder Source Data, sub folder Source Data PDFs~~. I then exported the appropriate tables from these ~~two~~ PDFs into 2 excel sheets ~~(which can be found in folder Source Data, sub folder Source Data Excel)~~. Next, I broke these ~~two~~ excel sheets down into the 17 individual series, each series onto its own excel sheet ~~(these can be found in folder “Energy Series Extracted from Source Data”)~~.		In preparing these series, I first downloaded the relevant energy reports from the BGR website, or are available through a google search of "BGR Energy Resources [YEAR]". I then exported the appropriate tables from these PDFs into separate excel sheets. Next, I broke these excel sheets down into the individual series, each of the 17 series onto its own excel sheet.

	Each one of these 17 sheets has 5 tabs ~~(2012~~, ~~2013, 2012 Formatted, 2013 Formatted~~, and ~~Data~~ for ~~Import~~). The ~~2012 and 2013~~ tabs have the raw data pulled from the two Energy Study excel sheets ~~in sub folder Source Data Excel~~. The ~~2012 Formatted and 2013~~ Formatted tabs have the same data as the ~~2012 and 2013~~ tabs, only it has been formatted into a ~~IFS~~-compatible format. The Data for Import tab has these two years combined.		Each one of these 17 sheets has tabs for raw data for each year, formatted data for each year, and data for import (including data for all years). The [YEAR] tabs have the raw data pulled from the two Energy Study excel sheets. The [YEAR] Formatted tabs have the same data as the [YEAR] tabs, only it has been formatted into a IFs-compatible format. The Data for Import tab has these two years combined.

	Finally, I took all the Data for Import tabs from the 17 sheets and combined them into one sheet (Energy Series Final Version for Import). I then imported all series into Ifs from this sheet. Once I imported the data into Ifs, I blended the series with the existing ~~2011~~ data and exported all the series to the Access table “Imported Series” in folder “Imported Series”.		Finally, I took all the Data for Import tabs from the 17 sheets and combined them into one sheet (Energy Series Final Version for Import). I then imported all series into Ifs from this sheet. Once I imported the data into Ifs, I blended the series with the existing data and exported all the series to the Access table “Imported Series” in folder “Imported Series”.

	'''Some notes on the formatting process:'''		'''Some notes on the formatting process:'''
Line 66:		Line 66:
	Another issue that needs mentioning is BGR's usage of dashes ("-") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.		Another issue that needs mentioning is BGR's usage of dashes ("-") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.

	BGR occasionally uses "n.s." in its data, which is intrepreted as a null value.		BGR occasionally uses "n.s." in its data, which is intrepreted as a null value. In the German translation, "k. A." is used instead of "n.s.".

	If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Ex. <0.05 is entered as 0.05.		If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Ex. <0.05 is entered as 0.05.
Line 89:		Line 89:
	#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil		#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil
	#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">		#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
			</ol></ol>