BGR data: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
 
(24 intermediate revisions by 4 users not shown)
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 [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 here: [http://www.bgr.bund.de/EN/Themen/Energie/Produkte/energy_study_2014_summary_en.html;jsessionid=15BA5CB5AEB1632F61A4DB9B0A3DC1A7.1_cid292&nbsp here];
= Series pulled from BGR =
 
{| class="wikitable"
{| border="1" cellspacing="1" cellpadding="1" style="width:500px;"
|Variable
|Definition
|Units
|Years
|Last IFs Update
|UsedInPreprocessor
|UsedInPreprocessorFileName
|-
|-
| <br/>
|EnCumProdGasBGR
| <br/>
|Natural Gas  Cumulative Production
| <br/>
|BCM
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|0
| <br/>
|
|-
|-
| SeriesEnCumProdGasBGR
|EnReserCBMBGR
| <br/>
|Coalbed methane  reserves
| <br/>
|BCM
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnCumProdOilBGR
|EnReserGasBGR
| <br/>
|Natural gas reserves
| <br/>
|BCM
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserCBMBGR
|EnReserShaleGasBGR
| <br/>
|Shale Gas Reserves
| <br/>
|BCM
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserGasBGR
|EnResorCBMBGR
| <br/>
|Coalbed methane  Resources
| <br/>
|BCM
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserHeavyOilBGR
|EnResorGasBGR
| <br/>
|Natural gas resources
| <br/>
|BCM
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserOilBGR
|EnResorShaleGasBGR
| <br/>
|Shale Gas Resources
| <br/>
|BCM
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserOilSandsBGR
|EnResorTightGasBGR
| <br/>
|Tight Gas Resources
| <br/>
|BCM
| <br/>
|2011-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnReserShaleGasBGR
|EnCumProdOilBGR
| <br/>
|Cumulative Production  Oil
| <br/>
|Mt
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|0
| <br/>
|
|-
|-
| SeriesEnReserShaleOilBGR
|EnReserHeavyOilBGR
| <br/>
|Heavy Oil Reserves
| <br/>
|Mt
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorCBMBGR
|EnReserOilBGR
| <br/>
|Crude oil reserves
| <br/>
|Mt
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorGasBGR
|EnReserOilSandsBGR
| <br/>
|Oil Sands Reserves
| <br/>
|Mt
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorHeavyOilBGR
|EnReserShaleOilBGR
| <br/>
|Shale Oil Reserves
| <br/>
|Mt
| <br/>
|2011-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorOilBGR
|EnResorHeavyOilBGR
| <br/>
|Heavy Oil Resources
| <br/>
|Mt
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorOilSandsBGR
|EnResorOilBGR
| <br/>
|Crude oil resources
| <br/>
|Mt
| <br/>
|2009-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorShaleGasBGR
|EnResorOilSandsBGR
| <br/>
|Oil sands resources
| <br/>
|Mt
| <br/>
|2010-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
|-
| SeriesEnResorShaleOilBGR
|EnResorShaleOilBGR
| <br/>
|Shale Oil resources
| <br/>
|Mt
| <br/>
|2011-2018, 2020-2022
| <br/>
|2024/04/17
| <br/>
|1
| <br/>
|ENER
|-
| SeriesEnResorTightGasBGR
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
| <br/>
|}
|}


= Instructions on importing BGR data =
= Instructions on importing BGR data =


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”).
'''Process of importing and blending:'''


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.
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]".  


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”.
* The study reported data in previous year.
* '''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.
* The data before 2018 need to be extracted from BGR reports in pdf.
* '''The most recent data can be downloaded in BGR Energy Study in Germany version from [https://www.bgr.bund.de/DE/Themen/Energie/Produkte/produkte_node.html?tab=Energiestudien here].'''
** The latest update was in April, 2024. The data in 2021 and 2022 were downloaded from the BGR Energy Study in Germany version.
 
Combined new data and current data in IFsHistSeries.db.


'''Some notes on the formatting process:'''
'''Some notes on the formatting process:'''
Line 164: Line 171:
Table numbers don’t stay the same over different years in the energy reports.
Table numbers don’t stay the same over different years in the energy reports.


Once all series were formatted for uploading, I replaced all “–“ with 0’s, all “n.s”. with blanks, all “<” with blanks as per convention.
Differences between resources and reserves: “…[That] part of a mineral resource, which has been fully evaluated and is deemed commercially viable to work, is called a mineral reserve [in effect, resources will always be larger than resources]” In effect, resources shouldn’t change over time, while reserves can.
 
Differences between resources and reserves: “…[That] part of a mineral resource, which has been fully evaluated and is deemed commercially viable to work, is called a mineral reserve [in effect, resources will always be larger than resources]”
 
In effect, resources shouldn’t change over time, while reserves can.


''-Source: ''[http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html ''http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html'']''; Accessed 3/6/16''
''-Source: ''[http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html ''http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html'']''; Accessed 3/6/16''


'''Reference Data''''': Listed below is each BGR series I updated, all with the name of the table in the Energy Report pdf, the column of the table used, and any differences found between years (I only listed differences for the resource series).''
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.


#EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
Another issue that needs mentioning is BGR's usage of dashes ("-" or "—") in its Energy Reports. Dashes are intrepreted as 0's based on the definition given by BGR in the Energy Reports.
#EnCumProdOilBGR: uses table Crude Oil in XXXX (year), column Cum. Production
#EnReserCBMBGR: Coalbed Methane Reserves. Table Natural Gas Resources (under CBM)
#EnReserGasBGR: Uses table Natural Gas in XXXX (Year), Column: Reserves
#EnReserHeavyOilBGR: Uses table Crude Oil Reserves, Extra Heavy Oil column
#EnReserOilBGR: Utilizes table Crude Oil in XXXX (year), column Reserves
#EnReserOilSandsBGR: Uses table Crude Oil Reserves, column Oil Sand
#EnReserShaleGasBGR: Uses table Natural Gas Reserves, column Shale Gas
#EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
#EnResorCBMBGR: Uses table Natural Gas Resources, column CBM<ol style="list-style-type:lower-alpha;">
</ol></ol>
&lt;/ol&gt;
&lt;/ol&gt; &lt;/ol&gt; &lt;/ol&gt;


*Differences in India, Libya, Mexico, S. Africa,
BGR occasionally uses "n.s." (or "n. s.") in its data, which is intrepreted as a null value. In the German translation, "k. A." is used instead of "n.s.".
*EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential<ol style="list-style-type:lower-alpha;">
</ol></ul>
&lt;/ul&gt;
&lt;/ul&gt; &lt;/ul&gt;


*Differences in Afghan, Albania, Austria, many differences
If there is a less than sign in the data, it is dropped and the value preceding it is entered as is. Eg. <0.05 is entered as 0.05.
*EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil<ol style="list-style-type:lower-alpha;">
</ol></ul>
&lt;/ul&gt;
&lt;/ul&gt;


*Differences in Iraq, Mexico,
'''Reference Data''''': Listed below is each BGR series updated, all with the name of the table in the Energy Report pdf, and the column of the table used before 2018 or with the sheet name in the Excel, and the column of the table used after 2018''
*EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential<ol style="list-style-type:lower-alpha;">
{| class="wikitable"
</ol></ul>
|
&lt;/ul&gt;
|
*Many differences
|
*EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand<ol style="list-style-type:lower-alpha;">
! colspan="8" |''Data  after 2018 from Excel''
</ol></ul>
|-
 
|
*Differences in Iraq
! colspan="2" |''Data Before 2018 from pdf''
*EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas<ol style="list-style-type:lower-alpha;">
! colspan="2" |''2018''
<li>Differences in Algeria, Argentina, Aust, Brazil, Canada, China, Mex, many others</li>
! colspan="2" |''2020''
</ol><li>EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil<ol style="list-style-type:lower-alpha;">
! colspan="2" |''2021''
<li>Many differences</li>
! colspan="2" |''2022''
</ol></li>
|-
<li>EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type:lower-alpha;">
|''Variable''
<li>Differences in Mexico</li>
|''Table Name''
</ol></li>
|''Column''
</ul>
|''Sheet Name''
 
|''Column''
&lt;/ul&gt;
|''Sheet Name''
 
|''Column''
&lt;/ul&gt;
|''Sheet Name''
 
|''Column''
&lt;/ul&gt;
|''Sheet Name''
 
|''Column''
&lt;/ul&gt;
|-
 
|''EnCumProdGasBGR''
&lt;/ol&gt;
|''Natural Gas in XXXX  (year)''
|''Cum. Production''
|''s. A-15, Natural Gas,  2018 ...''
|''Cum. Production''
|''s. A-15, Natural Gas,  2020 ...''
|''Cum. Production''
|''s. A-15, Übersicht  Erdgas, ...''
|''Kum. Förderung''
|''s. A-15, Übersicht  Erdgas, ...''
|''Kum. Förderung''
|-
|''EnReserCBMBGR''
|''Natural Gas Reserves  in XXXX (year)''
|''CBM''
|''A-17, Natural gas  reserves 2018''
|''CBM: proved reserves''
|''A-17, Natural gas  reserves ...''
|''CBM: proved reserves''
|''A-17, Erdgasreserven  2021 (...''
|''CBM, Reserven''
|''A-17, Erdgasreserven  2022 (...''
|''CBM, Reserven''
|-
|''EnReserGasBGR''
|''Natural Gas in XXXX (year)''
|''Reserves''
|''s. A-15, Natural Gas, 2018 ...''
|''Reserves''
|''s. A-15, Natural Gas,  2020 ...''
|''Reserves''
|''s. A-15, Übersicht  Erdgas, ...''
|''Reserven''
|''s. A-15, Übersicht  Erdgas, ...''
|''Reserven''
|-
|''EnReserShaleGasBGR''
|''Natural Gas Reserves  in XXXX (year)''
|''shale gas''
|''A-17, Natural gas  reserves 2018''
|''shale gas: proved  reserves''
|''A-17, Natural gas  reserves ...''
|''shale gas: proved  reserves''
|''A-17, Erdgasreserven  2021 (...''
|''Schiefer Gas:  Reserven''
|''A-17, Erdgasreserven  2022 (...''
|''Schiefer Gas: Reserven''
|-
|''EnResorCBMBGR''
|''Natural Gas Resources in XXXX (year)''
|''CBM''
|''A-16, Natural gas  resources...''
|''CBM: ressources''
|''A-16, Natural gas  resources...''
|''CBM: ressources''
|''A-16,  Erdgasressourcen 2021...''
|''CBM, Ressourcen''
|''A-16,  Erdgasressourcen 2022...''
|''CBM, Ressourcen''
|-
|''EnResorGasBGR''
|''Natural Gas in XXXX  (year)''
|''Remaining Potential''
|''s. A-15, Natural Gas,  2018 ...''
|''Remaining Potential''
|''s. A-15, Natural Gas,  2020 ...''
|''Remaining Potential''
|''s. A-15, Übersicht  Erdgas, ...''
|''Verbl. Potenzial''
|''s. A-15, Übersicht  Erdgas, ...''
|''Verbl. Potenzial''
|-
|''EnResorShaleGasBGR''
|''Natural Gas Resources  in XXXX (year)''
|''shale gas''
|''A-16, Natural gas  resources...''
|''shale gas: resources''
|''A-16, Natural gas  resources...''
|''shale gas: resources''
|''A-16,  Erdgasressourcen 2021...''
|''Schiefer Gas,  Ressourcen''
|''A-16,  Erdgasressourcen 2022...''
|''Schiefer Gas,  Ressourcen''
|-
|''EnResorTightGasBGR''
|''Natural Gas Resources in XXXX (year)''
|''tight gas''
|''A-16, Natural gas  resources...''
|''tight gas: resources''
|''A-16, Natural gas  resources...''
|''tight gas: resources''
|''A-16,  Erdgasressourcen 2021...''
|''Tight Gas, Ressourcen''
|''A-16,  Erdgasressourcen 2022...''
|''Tight Gas, Ressourcen''
|-
|''EnCumProdOilBGR''
|''Crude Oil in XXXX  (year)''
|''Cum. Production''
|''s. A-8, Crude oil,  2018 (Mt)''
|''Cum. Production''
|''s. A-8, Crude oil,  2020 (Mt)''
|''Cum. Production''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Kum. Förderung''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Kum. Förderung''
|-
|''EnReserHeavyOilBGR''
|''Crude Oil Reserves in  XXXX (year)''
|''extra heavy oil''
|''A-10, Crude oil  reserves 2018''
|''extra heavy oil:  proved reserves''
|''A-10, Crude oil  reserves 20...''
|''extra heavy oil: proved reserves''
|''A-10, Erdölreserven  2021 (Mt)''
|''Schwerstöl, Reserven''
|''A-10, Erdölreserven  2022 (Mt)''
|''Schwerstöl, Reserven''
|-
|''EnReserOilBGR''
|''Crude Oil in XXXX  (year)''
|''Reserves''
|''s. A-8, Crude oil,  2018 (Mt)''
|''Reserves''
|''s. A-8, Crude oil, 2020 (Mt)''
|''Reserves''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Reserven''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Reserven''
|-
|''EnReserOilSandsBGR''
|''Crude Oil Reserves in  XXXX (year)''
|''oil sand''
|''A-10, Crude oil  reserves 2018''
|''Oil Sand: Proved  reserves''
|''A-10, Crude oil  reserves 20...''
|''Oil Sand: Proved  reserves''
|''A-10, Erdölreserven  2021 (Mt)''
|''Ölsandreserven''
|''A-10, Erdölreserven  2022 (Mt)''
|''Ölsandreserven''
|-
|''EnReserShaleOilBGR''
|''Crude Oil Reserves in  XXXX (year)''
|''shale oil''
|''A-10, Crude oil  reserves 2018''
|''shale oil: reserves''
|''A-10, Crude oil  reserves 20...''
|''shale oil: reserves''
|''A-10, Erdölreserven  2021 (Mt)''
|''Schieferöl: Reserven''
|''A-10, Erdölreserven  2022 (Mt)''
|''Schieferöl: Reserven''
|-
|''EnResorHeavyOilBGR''
|''Crude Oil Resources in XXXX (year)''
|''extra heavy oil''
|''A-9, Crude oil  resources 2018''
|''extra heavy oil:  resources''
|''A-9, Crude oil  resources 20...''
|''extra heavy oil:  resources''
|''A-9, Erdölressourcen  2021 (Mt)''
|''Schwerstöl,  Ressourcen''
|''A-9, Erdölressourcen  2022 (Mt)''
|''Schwerstöl,  Ressourcen''
|-
|''EnResorOilBGR''
|''Crude Oil in XXXX  (year)''
|''Remaining Potential''
|''s. A-8, Crude oil,  2018 (Mt)''
|''Remaining Potential''
|''s. A-8, Crude oil,  2020 (Mt)''
|''Remaining Potential''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Verbl. Potenzial''
|''s. A-8, Übersicht  Erdöl, 20...''
|''Verbl. Potenzial''
|-
|''EnResorOilSandsBGR''
|''Crude Oil Resources  in XXXX (year)''
|''oil sand''
|''A-9, Crude oil  resources 2018''
|''oil sand: resources''
|''A-9, Crude oil  resources 20...''
|''oil sand: resources''
|''A-9, Erdölressourcen  2021 (Mt)''
|''Ölsand, Ressourcen''
|''A-9, Erdölressourcen  2022 (Mt)''
|''Ölsand, Ressourcen''
|-
|''EnResorShaleOilBGR''
|''Crude Oil Resources  in XXXX (year)''
|''shale oil''
|''A-9, Crude oil  resources 2018''
|''shale oil: resources''
|''A-9, Crude oil  resources 20...''
|''shale oil: resources''
|''A-9, Erdölressourcen  2021 (Mt)''
|''Schieferöl:  Ressourcen''
|''A-9, Erdölressourcen  2022 (Mt)''
|''Schieferöl:  Ressourcen''
|}
Note: Data in 2021 and 2022 were downloaded from https://www.bgr.bund.de/DE/Themen/Energie/Produkte/produkte_node.html?tab=Energiestudien<ol style="list-style-type: lower-alpha;">

Latest revision as of 23:38, 16 April 2024

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 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

Variable Definition Units Years Last IFs Update UsedInPreprocessor UsedInPreprocessorFileName
EnCumProdGasBGR Natural Gas Cumulative Production BCM 2009-2018, 2020-2022 2024/04/17 0
EnReserCBMBGR Coalbed methane reserves BCM 2010-2018, 2020-2022 2024/04/17 1 ENER
EnReserGasBGR Natural gas reserves BCM 2009-2018, 2020-2022 2024/04/17 1 ENER
EnReserShaleGasBGR Shale Gas Reserves BCM 2010-2018, 2020-2022 2024/04/17 1 ENER
EnResorCBMBGR Coalbed methane Resources BCM 2010-2018, 2020-2022 2024/04/17 1 ENER
EnResorGasBGR Natural gas resources BCM 2009-2018, 2020-2022 2024/04/17 1 ENER
EnResorShaleGasBGR Shale Gas Resources BCM 2010-2018, 2020-2022 2024/04/17 1 ENER
EnResorTightGasBGR Tight Gas Resources BCM 2011-2018, 2020-2022 2024/04/17 1 ENER
EnCumProdOilBGR Cumulative Production Oil Mt 2009-2018, 2020-2022 2024/04/17 0
EnReserHeavyOilBGR Heavy Oil Reserves Mt 2010-2018, 2020-2022 2024/04/17 1 ENER
EnReserOilBGR Crude oil reserves Mt 2009-2018, 2020-2022 2024/04/17 1 ENER
EnReserOilSandsBGR Oil Sands Reserves Mt 2010-2018, 2020-2022 2024/04/17 1 ENER
EnReserShaleOilBGR Shale Oil Reserves Mt 2011-2018, 2020-2022 2024/04/17 1 ENER
EnResorHeavyOilBGR Heavy Oil Resources Mt 2010-2018, 2020-2022 2024/04/17 1 ENER
EnResorOilBGR Crude oil resources Mt 2009-2018, 2020-2022 2024/04/17 1 ENER
EnResorOilSandsBGR Oil sands resources Mt 2010-2018, 2020-2022 2024/04/17 1 ENER
EnResorShaleOilBGR Shale Oil resources Mt 2011-2018, 2020-2022 2024/04/17 1 ENER


Instructions on importing BGR data

Process of importing and blending:

In preparing these series, first downloaded the relevant energy data from the BGR website, or are available through a google search of "BGR Energy Resources [YEAR]".

  • The study reported data in previous year.
  • 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.
  • The data before 2018 need to be extracted from BGR reports in pdf.
  • The most recent data can be downloaded in BGR Energy Study in Germany version from here.
    • The latest update was in April, 2024. The data in 2021 and 2022 were downloaded from the BGR Energy Study in Germany version.

Combined new data and current data in IFsHistSeries.db.

Some notes on the formatting process:

In 2014, term changed from Shale Oil to Tight Oil (applies to Series EnReserShaleOil and EnResourceShaleOil) not to be confused with Tight Gas.

Table numbers don’t stay the same over different years in the energy reports.

Differences between resources and reserves: “…[That] part of a mineral resource, which has been fully evaluated and is deemed commercially viable to work, is called a mineral reserve [in effect, resources will always be larger than resources]” In effect, resources shouldn’t change over time, while reserves can.

-Source: http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html; Accessed 3/6/16

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 ("-" or "—") 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." (or "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. Eg. <0.05 is entered as 0.05.

Reference Data: Listed below is each BGR series updated, all with the name of the table in the Energy Report pdf, and the column of the table used before 2018 or with the sheet name in the Excel, and the column of the table used after 2018

Data after 2018 from Excel
Data Before 2018 from pdf 2018 2020 2021 2022
Variable Table Name Column Sheet Name Column Sheet Name Column Sheet Name Column Sheet Name Column
EnCumProdGasBGR Natural Gas in XXXX (year) Cum. Production s. A-15, Natural Gas, 2018 ... Cum. Production s. A-15, Natural Gas, 2020 ... Cum. Production s. A-15, Übersicht Erdgas, ... Kum. Förderung s. A-15, Übersicht Erdgas, ... Kum. Förderung
EnReserCBMBGR Natural Gas Reserves in XXXX (year) CBM A-17, Natural gas reserves 2018 CBM: proved reserves A-17, Natural gas reserves ... CBM: proved reserves A-17, Erdgasreserven 2021 (... CBM, Reserven A-17, Erdgasreserven 2022 (... CBM, Reserven
EnReserGasBGR Natural Gas in XXXX (year) Reserves s. A-15, Natural Gas, 2018 ... Reserves s. A-15, Natural Gas, 2020 ... Reserves s. A-15, Übersicht Erdgas, ... Reserven s. A-15, Übersicht Erdgas, ... Reserven
EnReserShaleGasBGR Natural Gas Reserves in XXXX (year) shale gas A-17, Natural gas reserves 2018 shale gas: proved reserves A-17, Natural gas reserves ... shale gas: proved reserves A-17, Erdgasreserven 2021 (... Schiefer Gas: Reserven A-17, Erdgasreserven 2022 (... Schiefer Gas: Reserven
EnResorCBMBGR Natural Gas Resources in XXXX (year) CBM A-16, Natural gas resources... CBM: ressources A-16, Natural gas resources... CBM: ressources A-16, Erdgasressourcen 2021... CBM, Ressourcen A-16, Erdgasressourcen 2022... CBM, Ressourcen
EnResorGasBGR Natural Gas in XXXX (year) Remaining Potential s. A-15, Natural Gas, 2018 ... Remaining Potential s. A-15, Natural Gas, 2020 ... Remaining Potential s. A-15, Übersicht Erdgas, ... Verbl. Potenzial s. A-15, Übersicht Erdgas, ... Verbl. Potenzial
EnResorShaleGasBGR Natural Gas Resources in XXXX (year) shale gas A-16, Natural gas resources... shale gas: resources A-16, Natural gas resources... shale gas: resources A-16, Erdgasressourcen 2021... Schiefer Gas, Ressourcen A-16, Erdgasressourcen 2022... Schiefer Gas, Ressourcen
EnResorTightGasBGR Natural Gas Resources in XXXX (year) tight gas A-16, Natural gas resources... tight gas: resources A-16, Natural gas resources... tight gas: resources A-16, Erdgasressourcen 2021... Tight Gas, Ressourcen A-16, Erdgasressourcen 2022... Tight Gas, Ressourcen
EnCumProdOilBGR Crude Oil in XXXX (year) Cum. Production s. A-8, Crude oil, 2018 (Mt) Cum. Production s. A-8, Crude oil, 2020 (Mt) Cum. Production s. A-8, Übersicht Erdöl, 20... Kum. Förderung s. A-8, Übersicht Erdöl, 20... Kum. Förderung
EnReserHeavyOilBGR Crude Oil Reserves in XXXX (year) extra heavy oil A-10, Crude oil reserves 2018 extra heavy oil: proved reserves A-10, Crude oil reserves 20... extra heavy oil: proved reserves A-10, Erdölreserven 2021 (Mt) Schwerstöl, Reserven A-10, Erdölreserven 2022 (Mt) Schwerstöl, Reserven
EnReserOilBGR Crude Oil in XXXX (year) Reserves s. A-8, Crude oil, 2018 (Mt) Reserves s. A-8, Crude oil, 2020 (Mt) Reserves s. A-8, Übersicht Erdöl, 20... Reserven s. A-8, Übersicht Erdöl, 20... Reserven
EnReserOilSandsBGR Crude Oil Reserves in XXXX (year) oil sand A-10, Crude oil reserves 2018 Oil Sand: Proved reserves A-10, Crude oil reserves 20... Oil Sand: Proved reserves A-10, Erdölreserven 2021 (Mt) Ölsandreserven A-10, Erdölreserven 2022 (Mt) Ölsandreserven
EnReserShaleOilBGR Crude Oil Reserves in XXXX (year) shale oil A-10, Crude oil reserves 2018 shale oil: reserves A-10, Crude oil reserves 20... shale oil: reserves A-10, Erdölreserven 2021 (Mt) Schieferöl: Reserven A-10, Erdölreserven 2022 (Mt) Schieferöl: Reserven
EnResorHeavyOilBGR Crude Oil Resources in XXXX (year) extra heavy oil A-9, Crude oil resources 2018 extra heavy oil: resources A-9, Crude oil resources 20... extra heavy oil: resources A-9, Erdölressourcen 2021 (Mt) Schwerstöl, Ressourcen A-9, Erdölressourcen 2022 (Mt) Schwerstöl, Ressourcen
EnResorOilBGR Crude Oil in XXXX (year) Remaining Potential s. A-8, Crude oil, 2018 (Mt) Remaining Potential s. A-8, Crude oil, 2020 (Mt) Remaining Potential s. A-8, Übersicht Erdöl, 20... Verbl. Potenzial s. A-8, Übersicht Erdöl, 20... Verbl. Potenzial
EnResorOilSandsBGR Crude Oil Resources in XXXX (year) oil sand A-9, Crude oil resources 2018 oil sand: resources A-9, Crude oil resources 20... oil sand: resources A-9, Erdölressourcen 2021 (Mt) Ölsand, Ressourcen A-9, Erdölressourcen 2022 (Mt) Ölsand, Ressourcen
EnResorShaleOilBGR Crude Oil Resources in XXXX (year) shale oil A-9, Crude oil resources 2018 shale oil: resources A-9, Crude oil resources 20... shale oil: resources A-9, Erdölressourcen 2021 (Mt) Schieferöl: Ressourcen A-9, Erdölressourcen 2022 (Mt) Schieferöl: Ressourcen

Note: Data in 2021 and 2022 were downloaded from https://www.bgr.bund.de/DE/Themen/Energie/Produkte/produkte_node.html?tab=Energiestudien

    Retrieved from "https://pardeewiki.du.edu//index.php?title=BGR_data&oldid=11381"