BGR data: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
(10 intermediate revisions by 2 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 [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 =


{| cellspacing="0" border="1" bgcolor="#ffffff"
{| border="1" cellpadding="0" cellspacing="0" width="64"
|+ '''Copy Of DataDict 720'''
|- height="20"
|-
| height="20" width="64" | SeriesEnCumProdGasBGR
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Table</font>
|- height="20"
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Group</font>
| height="20" | SeriesEnCumProdOilBGR
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Definition</font>
|- height="20"
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Years</font>
| height="20" | SeriesEnReserCBMBGR
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Source</font>
|- height="20"
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Last IFs Update</font>
| height="20" | SeriesEnReserGasBGR
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">UsedInPreprocessor</font>
|- height="20"
|- valign="top"
| height="20" | SeriesEnReserHeavyOilBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorOilBGRBBOE</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| height="20" | SeriesEnReserOilBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">Crude oil resources</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| height="20" | SeriesEnReserOilSandsBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| height="20" | SeriesEnReserShaleGasBGR
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- height="20"
|- valign="top"
| height="20" | SeriesEnReserShaleOilBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserCoalBGRBBOE</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| height="20" | SeriesEnResorCBMBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coal reserves</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| height="20" | SeriesEnResorGasBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| height="20" | SeriesEnResorHeavyOilBGR
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- height="20"
|- valign="top"
| height="20" | SeriesEnResorOilBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserGasBGRBBOE</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| height="20" | SeriesEnResorOilSandsBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural gas reserves</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| height="20" | SeriesEnResorShaleGasBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
|- height="20"
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| height="20" | SeriesEnResorShaleOilBGR
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- height="20"
|- valign="top"
| height="20" | SeriesEnResorTightGasBGR
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserOilBGRBBOE</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Crude oil reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorCoalBGRBBOE</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coal resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorGasBGRBBOE</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural gas resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2009</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2010"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2010</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2012/03/01</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnCumProdGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural Gas Cumulative Production</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnCumProdOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Cumulative Production Oil</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">No</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserCBMBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coalbed methane reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural gas reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/04</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserHeavyOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Heavy Oil Reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Crude oil reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserOilSandsBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Oil Sands Reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserShaleGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Shale Gas Reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnReserShaleOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Shale Oil Reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorCBMBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coalbed methane Resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural gas resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorHeavyOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Heavy Oil Resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Crude oil resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorOilSandsBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Oil sands resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorShaleGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Shale Gas Resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorShaleOilBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Shale Oil resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnResorTightGasBGR</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Tight Gas Resources</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BGR; "Reserves, Resources and Availability of Energy Resources 2012"<br/>Bundesanstalt fur Geowissenschaften und Rohstoffe (BGR) in Hannover; Annual Report. Reserves, Resources and Availability of Energy Resources 2012</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2013/04/05</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|}
|}


Line 213: 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&nbsp;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&nbsp;PDFs into separate&nbsp;excel sheets. Next, I broke these&nbsp;excel sheets down into the&nbsp;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&nbsp;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&nbsp;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&nbsp;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 225: Line 58:
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]&nbsp;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]
''-Source: ''[http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html ''http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html'']''; Accessed 3/6/16''


In effect, resources shouldn’t change over time, while reserves can.
Sudan and South Sudan:&nbsp;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&nbsp;EnReserGasBGR and EnResorGasBGR. In these cases, I&nbsp;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,&nbsp;we don't enter values for Sudan in the series EnCumProdGas and EnCumProdOil.


''-Source: ''[http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html ''http://www.bgs.ac.uk/mineralsUK/mineralsYou/resourcesReserves.html'']''; Accessed 3/6/16''
Another issue that needs mentioning is BGR's usage of dashes ("-")&nbsp;in its Energy Reports. Dashes are intrepreted as 0's&nbsp;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. In the German translation, "k. A." is used instead of "n.s.".&nbsp;
 
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.


'''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).''
'''Reference Data''''': Listed below is each BGR series I updated, all with the name of the table in the Energy Report pdf, and the column of the table used.''


#EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
#EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
Line 245: Line 82:
#EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
#EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
#EnResorCBMBGR: Uses table Natural Gas Resources, column CBM
#EnResorCBMBGR: Uses table Natural Gas Resources, column CBM
 
#11.EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential
*Differences in India, Libya, Mexico, S. Africa,
#EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil
*EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential
#EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential
*Differences in Afghan, Albania, Austria, many differences
#EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand<ol style="list-style-type: lower-alpha;"
*EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil
#EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas
*Differences in Iraq, Mexico,
#EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil
*EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential
#EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
*Many differences
</ol></ol>
*EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand<ol style="list-style-type: lower-alpha;">
</ol></ul>
 
*Differences in Iraq
*EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas<ol style="list-style-type: lower-alpha;">
</ol></ul>
 
*Differences in Algeria, Argentina, Aust, Brazil, Canada, China, Mex, many others
*EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil<ol style="list-style-type: lower-alpha;">
</ol><li>Many differences</li>
<li>EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas<ol style="list-style-type: lower-alpha;">
</ol></li>
<li>Differences in Mexico</li>
</ul>

Revision as of 00:52, 21 June 2017

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

SeriesEnCumProdGasBGR
SeriesEnCumProdOilBGR
SeriesEnReserCBMBGR
SeriesEnReserGasBGR
SeriesEnReserHeavyOilBGR
SeriesEnReserOilBGR
SeriesEnReserOilSandsBGR
SeriesEnReserShaleGasBGR
SeriesEnReserShaleOilBGR
SeriesEnResorCBMBGR
SeriesEnResorGasBGR
SeriesEnResorHeavyOilBGR
SeriesEnResorOilBGR
SeriesEnResorOilSandsBGR
SeriesEnResorShaleGasBGR
SeriesEnResorShaleOilBGR
SeriesEnResorTightGasBGR


Instructions on importing BGR data

Process of importing and blending:

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 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 data and exported all the series to the Access table “Imported Series” in folder “Imported Series”.

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 ("-") 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. 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.

Reference Data: Listed below is each BGR series I updated, all with the name of the table in the Energy Report pdf, and the column of the table used.

  1. EnCumProdGasBGR: uses table Natural Gas in XXXX (year), column Cum. Production
  2. EnCumProdOilBGR: uses table Crude Oil in XXXX (year), column Cum. Production
  3. EnReserCBMBGR: Coalbed Methane Reserves. Table Natural Gas Resources (under CBM)
  4. EnReserGasBGR: Uses table Natural Gas in XXXX (Year), Column: Reserves
  5. EnReserHeavyOilBGR: Uses table Crude Oil Reserves, Extra Heavy Oil column
  6. EnReserOilBGR: Utilizes table Crude Oil in XXXX (year), column Reserves
  7. EnReserOilSandsBGR: Uses table Crude Oil Reserves, column Oil Sand
  8. EnReserShaleGasBGR: Uses table Natural Gas Reserves, column Shale Gas
  9. EnReserShaleOilBGR: Uses table Crude Oil Reserves, column Shale Oil
  10. EnResorCBMBGR: Uses table Natural Gas Resources, column CBM
  11. 11.EnResorGasBGR: Uses table Natural Gas in XXXX (year), column Remaining Potential
  12. EnResorHeavyOilBGR: Uses table Crude Oil Resources, column Extra Heavy Oil
  13. EnResorOilBGR: Uses table Crude Oil in XXXX (year), column Remaining Potential
  14. EnResorOilSandsBGR: table Crude Oil Resources, column Oil Sand<ol style="list-style-type: lower-alpha;"
  15. EnResorShaleGasBGR: table Natural Gas Resources in XXXX, Column Shale Gas
  16. EnResorShaleOilBGR: table Crude Oil Resources, Column Shale Oil
  17. EnResorTightGasBGR: table Natural Gas Resources, column Tight Gas