BP data: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 159: Line 159:
= Instructions on importing data =
= Instructions on importing data =


From Ryan Wells 2016/03
*For the BP energy data, it is fairly straight forward. I pulled it all from the BP website h[http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html) ttp://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html]
*I used all of the conversions that are listed in the DataDict and each one works well. The notes document the conversion factor that needs to be applied to the data. For example, to get from MMOE to BBOE, which is what IFs uses, some series are multilied by 0.00733. 
<span style="margin: 0px; color: black; font-size: 12pt;">The units from BP are in MTOE (Million tonnes of oil equivalent). We need to convert that to BBOE (Billion Barrels of Oil Equivalent). Which is why we multiply by those numbers. The conversion factors can be found here,&nbsp;</span>
 
<span style="margin: 0px; color: black; font-size: 12pt;">[https://www.iea.org/statistics/resources/unitconverter/ <font face="calibri" color="#0000ff">https://www.iea.org/statistics/resources/unitconverter/</font>]</span>


*For the BP energy data, it is fairly straight forward. I pulled it all from the BP website h[http://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html) ttp://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html]
*I used all of the conversions that are listed in the DataDict and each one works well.
*The only tricky part is for some reason some of the historic coal data from the downloaded information does not come with the download. I pulled the historic data from the DataDict and filled in the historic data into the excel document that was then imported into IFs.
*The only tricky part is for some reason some of the historic coal data from the downloaded information does not come with the download. I pulled the historic data from the DataDict and filled in the historic data into the excel document that was then imported into IFs.

Revision as of 18:54, 9 November 2018

Series pulled from BP

Copy Of DataDict
Table Group Definition Years Source Last IFs Update UsedInPreprocessor
SeriesEnConCoalBP Energy, Infrastructure Coal consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnConGeothBioBP Energy, Infrastructure Geothermal, biomass and other renewable energy consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnConSolarBP Energy, Infrastructure Solar energy consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnInstGeothermalBP Energy, Infrastructure Cumulative installed geothermal power capacity 1975,1980,1985,1990,1995,2000-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnInstSolarBP Energy, Infrastructure Cumulative installed photovoltaic (PV) power 1996-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnInstWindBP Energy, Infrastructure Cumulative installed wind turbine capacity 1995-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnProdBioBP Energy, Infrastructure Biofuels production 1990-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnConWindBP Energy, Infrastructure Wind energy consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnReserCoalBP Energy, Infrastructure Coal reserves 2007-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnConGasBP Energy, Infrastructure Natural gas consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnConHydroBP Energy, Infrastructure Hydro-electricity consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnConOilBP Energy, Infrastructure Oil consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 No
SeriesEnProdCoalBP Energy, Infrastructure Coal production 1981-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnProdGasBP Energy, Infrastructure Gas (natural) production 1970-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnProdOilBP Energy, Infrastructure Oil production 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnReserGasBP Energy, Infrastructure Gas (natural) reserves 1980-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnReserOilBP Energy, Infrastructure Oil reserves 1980-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes
SeriesEnConNucBP Energy, Infrastructure Nuclear-electricity consumption 1965-2014 BP’s Statistical Review of World Energy 2013 2016/01/27 Yes

Instructions on importing data

The units from BP are in MTOE (Million tonnes of oil equivalent). We need to convert that to BBOE (Billion Barrels of Oil Equivalent). Which is why we multiply by those numbers. The conversion factors can be found here, 

https://www.iea.org/statistics/resources/unitconverter/

  • The only tricky part is for some reason some of the historic coal data from the downloaded information does not come with the download. I pulled the historic data from the DataDict and filled in the historic data into the excel document that was then imported into IFs.