Statistical Review of World Energy, Energy Institute: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
Dave (talk | contribs)
84 edits
No edit summary
Norah.Shamin (talk | contribs)
1,060 edits
No edit summary
 
(11 intermediate revisions by 7 users not shown)
Line 1: Line 1:
Back to [[Energy_preprocessor|Energy preprocessor]]
= Summary =
The Statistical Review analyzes data on world energy markets and provides data to the energy community since 1952. Data compilation is done by the Centre for Energy Economics Research and Policy at Heriot-Watt University. An advisory board has also been established, bringing together leaders and experts to provide strategic oversight of the publication.


Last updated 2016/03/05 by Ryan Wells. Vetted by Brandon Voss. Task in teamwork to begin January 2017 when BP Statistical Review 2016 is released.
There are 18 tables from the Statistical Review of World Energy, Energy Institute. 8 are preprocessor and 10 are not.  


Source says 2013 Statistical Review. This is incorrect. The most recent data came from the 2015 Statistical Review.
= Tables In IFs =
 
{| class="wikitable"
TeamWork task: [https://pardeecenter.teamwork.com/tasks/3869647 https://pardeecenter.teamwork.com/tasks/3869647]
|+
 
!Variable
{| cellspacing="0" border="1" bgcolor="#ffffff"
!Definition
|+ '''Copy Of DataDict'''
!Years
!UsedInPreprocesspr
!UsedInPreprocessorFileName
!Name In Source
!Formula
!Extended Source Definition/Units
|-
|EnConHydroBP
|Hydro-electricity  consumption
|1965-2022
|1
|ENERGY
|Hydroelectricity -  Consumption
|* 0.1634
|Data in Exajoules
|-
|EnConNucBP
|Nuclear-electricity consumption
|1965-2022
|1
|ENERGY
|Nuclear Energy - Consumption
|* 0.1634
|Data in Exajoules
|-
|EnProdCoalBP
|Coal production
|1981-2022
|1
|ENERGY
|Coal - Production
|* 0.004789
|Data in Million tonnes
|-
|EnProdGasBP
|Gas (natural) production
|1970-2022
|1
|ENERGY
|Gas - Production
|*  0.006373
|Data in Billion cubic metres
|-
|EnProdOilBP
|Oil production
|1965-2022
|1
|ENERGY
|Oil - Production
|* 0.00684
|Data in million tonnes of oil equivalent
|-
|EnReserGasBP
|Gas (natural) reserves
|1980-2020
|1
|ENERGY
|Gas - Proved Reserves
|* 6.373
|Data in Trillion cubic metres
|-
|EnReserOilBP
|Oil reserves
|1980-2020
|1
|ENERGY
|Oil - Proved Reserves
|
|Data in thousand million barrels
|-
|EnConCoalBP
|Coal consumption
|1965-2017
|0
|
|Coal - Consumption
|
|Data in million tonnes of oil equivalent
|-
|EnConGasBP
|Natural gas consumption
|1965-2017
|0
|
|Gas - Consumption
|
|Data in million tonnes of oil equivalent
|-
|EnConGeothBioBP
|Geothermal, biomass and other renewable  energy consumption
|1965-2017
|0
|
|Renewables - Geothermal, Biomass and  Other
|
|Data in million tonnes of oil equivalent
|-
|EnConOilBP
|Oil consumption
|1965-2017
|0
|
|Oil - Consumption
|
|Data in million tonnes of oil equivalent
|-
|EnConSolarBP
|Solar energy consumption
|1965-2017
|0
|
|Renewables - Solar Consumption
|
|Data in million tonnes of oil equivalent
|-
|EnConWindBP
|Wind energy consumption
|1965-2017
|0
|
|Renewables - Wind Consumption
|
|Data in million tonnes of oil equivalent
|-
|EnInstGeothermalBP
|Cumulative installed geothermal power  capacity
|1975,1980,1985,1990,1995,2000-2017
|0
|
|Renewable energy - geothemal ;  Cumulative installed geothermal power capacity
|
|Data in megawatts
|-
|EnInstSolarBP
|Cumulative installed photovoltaic (PV)  power
|1996-2017
|0
|
|Renewable energy - solar; Cumulative  installed photovoltaic (PV) power
|
|Data in megawatts
|-
|EnInstWindBP
|Cumulative installed wind turbine  capacity
|1995-2017
|0
|
|Renewable energy - solar; Cumulative  installed wind turbine capacity
|
|Data in megawatts
|-
|EnProdBioBP
|Biofuels production
|1990-2017
|0
|
|Renewables - Biofuels production
|
|Data in thousand tonnes of oil equivalent
|-
|-
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Table</font>
|EnReserCoalBP
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Group</font>
|Coal reserves
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Definition</font>
|2007-2014
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Years</font>
|1
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Source</font>
|ENERGY
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Last IFs Update</font>
|Coal - Proved Reserves
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">UsedInPreprocessor</font>
|
|- valign="top"
|Data in million tonnes of oil equivalent
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnConCoalBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coal consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConGeothBioBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Geothermal, biomass and other renewable energy consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConSolarBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Solar energy consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnInstGeothermalBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Cumulative installed geothermal power capacity</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1975,1980,1985,1990,1995,2000-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnInstSolarBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Cumulative installed photovoltaic (PV) power</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1996-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnInstWindBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Cumulative installed wind turbine capacity</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1995-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnProdBioBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Biofuels production</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1990-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConWindBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Wind energy consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnReserCoalBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coal reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2007-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConGasBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Natural gas consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConHydroBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Hydro-electricity consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConOilBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Oil consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnProdCoalBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Coal production</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1981-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnProdGasBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Gas (natural) production</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1970-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnProdOilBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Oil production</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnReserGasBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Gas (natural) reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1980-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnReserOilBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Oil reserves</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1980-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</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">SeriesEnConNucBP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Energy, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Nuclear-electricity consumption</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">1965-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">BP’s Statistical Review of World Energy 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/01/27</font>
| align="right" | <font style="font-size: 11pt;" face="calibri" color="#000000">Yes</font>
|}
|}


= Instructions on importing data =
= Data Pulling Instructions =


From Ryan Wells 2016/03
#For the BP energy data, pull it from the BP website [https://www.energyinst.org/statistical-review/resources-and-data-downloads Resources and data downloads | Statistical Review of World Energy (energyinst.org)]
#*Download: Statistical Review of World Energy Data
#The Name in Source is the sheet name that the data will be in. In the "Contents" tab each type of energy is linked.
##For example, Hydroelectricity - Consumption is under "Hydroelectricity - Consumption - Exajoules (from 1965)" in the Contents tab and the sheet name is Hydro Consumption - EJ.
#When preparing the data, please compare the units from the original source and the units in the DataDict. Use the BBOE_UnitConversions.xlsx to transform the data to unified units (BBOE) in IFs. The latest update date for the BBOE_UnitConversion was 2024/02/12.
#*<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit for oil production is in MTOE (Million tonnes of oil equivalent). It needs to convert that to BBOE (Billion Barrels of Oil Equivalent), which is why it needs to be multiply by those numbers in the Formula.</small></span>
#*<span style="margin: 0px; color: black; font-size: 12pt;"><small>The conversion factors can be found here:</small></span> <span style="margin: 0px; color: black; font-size: 12pt;"><font face="calibri" color="#0000ff">[https://www.iea.org/data-and-statistics/data-tools/unit-converter Unit Converter – Data Tools - IEA] or [Https://www.convert-me.com/en/convert/energy/?u=bboe&v=1 https://www.convert-me.com/en/convert/energy/?u=bboe&v=1]</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]
= Data Notes =
*I used all of the conversions that are listed in the DataDict and each one works well.
*''Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''
*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.

Latest revision as of 20:06, 2 July 2025

Summary

The Statistical Review analyzes data on world energy markets and provides data to the energy community since 1952. Data compilation is done by the Centre for Energy Economics Research and Policy at Heriot-Watt University. An advisory board has also been established, bringing together leaders and experts to provide strategic oversight of the publication.

There are 18 tables from the Statistical Review of World Energy, Energy Institute. 8 are preprocessor and 10 are not.

Tables In IFs

Variable Definition Years UsedInPreprocesspr UsedInPreprocessorFileName Name In Source Formula Extended Source Definition/Units
EnConHydroBP Hydro-electricity consumption 1965-2022 1 ENERGY Hydroelectricity - Consumption * 0.1634 Data in Exajoules
EnConNucBP Nuclear-electricity consumption 1965-2022 1 ENERGY Nuclear Energy - Consumption * 0.1634 Data in Exajoules
EnProdCoalBP Coal production 1981-2022 1 ENERGY Coal - Production * 0.004789 Data in Million tonnes
EnProdGasBP Gas (natural) production 1970-2022 1 ENERGY Gas - Production * 0.006373 Data in Billion cubic metres
EnProdOilBP Oil production 1965-2022 1 ENERGY Oil - Production * 0.00684 Data in million tonnes of oil equivalent
EnReserGasBP Gas (natural) reserves 1980-2020 1 ENERGY Gas - Proved Reserves * 6.373 Data in Trillion cubic metres
EnReserOilBP Oil reserves 1980-2020 1 ENERGY Oil - Proved Reserves Data in thousand million barrels
EnConCoalBP Coal consumption 1965-2017 0 Coal - Consumption Data in million tonnes of oil equivalent
EnConGasBP Natural gas consumption 1965-2017 0 Gas - Consumption Data in million tonnes of oil equivalent
EnConGeothBioBP Geothermal, biomass and other renewable energy consumption 1965-2017 0 Renewables - Geothermal, Biomass and Other Data in million tonnes of oil equivalent
EnConOilBP Oil consumption 1965-2017 0 Oil - Consumption Data in million tonnes of oil equivalent
EnConSolarBP Solar energy consumption 1965-2017 0 Renewables - Solar Consumption Data in million tonnes of oil equivalent
EnConWindBP Wind energy consumption 1965-2017 0 Renewables - Wind Consumption Data in million tonnes of oil equivalent
EnInstGeothermalBP Cumulative installed geothermal power capacity 1975,1980,1985,1990,1995,2000-2017 0 Renewable energy - geothemal ; Cumulative installed geothermal power capacity Data in megawatts
EnInstSolarBP Cumulative installed photovoltaic (PV) power 1996-2017 0 Renewable energy - solar; Cumulative installed photovoltaic (PV) power Data in megawatts
EnInstWindBP Cumulative installed wind turbine capacity 1995-2017 0 Renewable energy - solar; Cumulative installed wind turbine capacity Data in megawatts
EnProdBioBP Biofuels production 1990-2017 0 Renewables - Biofuels production Data in thousand tonnes of oil equivalent
EnReserCoalBP Coal reserves 2007-2014 1 ENERGY Coal - Proved Reserves Data in million tonnes of oil equivalent

Data Pulling Instructions

  1. For the BP energy data, pull it from the BP website Resources and data downloads | Statistical Review of World Energy (energyinst.org)
    • Download: Statistical Review of World Energy Data
  2. The Name in Source is the sheet name that the data will be in. In the "Contents" tab each type of energy is linked.
    1. For example, Hydroelectricity - Consumption is under "Hydroelectricity - Consumption - Exajoules (from 1965)" in the Contents tab and the sheet name is Hydro Consumption - EJ.
  3. When preparing the data, please compare the units from the original source and the units in the DataDict. Use the BBOE_UnitConversions.xlsx to transform the data to unified units (BBOE) in IFs. The latest update date for the BBOE_UnitConversion was 2024/02/12.

Data Notes

  • Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.
Retrieved from "https://pardeewiki.du.edu//index.php?title=Statistical_Review_of_World_Energy,_Energy_Institute&oldid=12732"