Statistical Review of World Energy, Energy Institute - Revision history

Norah.Shamin at 17:05, 11 March 2026

2026-03-11T17:05:33Z

Norah.Shamin at 20:06, 2 July 2025

2025-07-02T20:06:30Z

← Older revision		Revision as of 20:06, 2 July 2025
Line 1:		Line 1:
	= Summary =		= 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.		There are 18 tables from the Statistical Review of World Energy, Energy Institute. 8 are preprocessor and 10 are not.

Line 179:		Line 181:
	= Data Pulling Instructions =		= Data Pulling Instructions =

	*For the BP energy data, ~~pulled~~ it ~~all~~ 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)]		#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)]
	*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.		#*Download: Statistical Review of World Energy Data
	**<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit ~~from BP~~ for oil production is in MTOE (Million tonnes of oil equivalent). ~~We need~~ 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>		#The Name in Source is the sheet name that the data will be in. In the "Contents" tab each type of energy is linked.
	**<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 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>

	= Data Notes =		= Data Notes =
	*''Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''		*''Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''

Norah.Shamin at 18:34, 2 July 2025

2025-07-02T18:34:23Z

Show changes

Yutang.Xiong: Yutang.Xiong moved page Statistical Review of World Energy, Energy Institute (EI) to Statistical Review of World Energy, Energy Institute without leaving a redirect

2025-06-04T22:32:14Z

Yutang.Xiong moved page Statistical Review of World Energy, Energy Institute (EI) to Statistical Review of World Energy, Energy Institute without leaving a redirect

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

Yutang.Xiong: /* Series pulled from BP */

2025-06-04T22:30:56Z

Series pulled from BP

← Older revision		Revision as of 22:30, 4 June 2025
Line 1:		Line 1:
	= Series pulled from BP =		= Series pulled from Statistical Review of World Energy =

	{\| cellspacing="0" border="1" bgcolor="#ffffff"		{\| cellspacing="0" border="1" bgcolor="#ffffff"

Yutang.Xiong: Yutang.Xiong moved page BP data to Statistical Review of World Energy, Energy Institute (EI) without leaving a redirect

2025-06-04T22:30:22Z

Yutang.Xiong moved page BP data to Statistical Review of World Energy, Energy Institute (EI) without leaving a redirect

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

Yutang.Xiong: /* Series pulled from BP */

2024-03-12T21:26:38Z

Series pulled from BP

Show changes

Tania.Blanga at 22:34, 28 February 2024

2024-02-28T22:34:20Z

← Older revision		Revision as of 22:34, 28 February 2024
Line 160:		Line 160:

	*For the BP energy data, it is fairly straight forward. I pulled it all 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)]		*For the BP energy data, it is fairly straight forward. I pulled it all 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)]
	*I used all of the conversions that are listed in the DataDict and each one works well. When ~~prepare~~ 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 ~~lateset~~ update date for the BBOE_UnitConversion was 2024/02/12.		*I used all of the conversions that are listed in the DataDict and each one works well. 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 from BP for oil production is 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 in the Formula.</small></span>		**<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit from BP for oil production is 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 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>		**<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>
	*''Note: Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''		*''Note: Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''

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

2024-02-28T20:39:18Z

Instructions on importing data

← Older revision		Revision as of 20:39, 28 February 2024
Line 161:		Line 161:
	*For the BP energy data, it is fairly straight forward. I pulled it all 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)]		*For the BP energy data, it is fairly straight forward. I pulled it all 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)]
	*I used all of the conversions that are listed in the DataDict and each one works well. When prepare 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 lateset update date for the BBOE_UnitConversion was 2024/02/12.		*I used all of the conversions that are listed in the DataDict and each one works well. When prepare 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 lateset update date for the BBOE_UnitConversion was 2024/02/12.
	*<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit from BP for oil production is 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 in the Formula. 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>		**<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit from BP for oil production is 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 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>
			*''Note: Russian Federation, it was called the USSR before 1991 and we need to consolidate it into one country when pulling the data.''

Kexin.Shang: BP energy 2024/02

2024-02-22T21:11:36Z

BP energy 2024/02

← Older revision		Revision as of 21:11, 22 February 2024
Line 159:		Line 159:
	= Instructions on importing data =		= Instructions on importing data =

	*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~~]		*For the BP energy data, it is fairly straight forward. I pulled it all 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)]
	*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~~.~~ ~~		*I used all of the conversions that are listed in the DataDict and each one works well. When prepare 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 lateset update date for the BBOE_UnitConversion was 2024/02/12.
	<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~~, ~~</span>		*<span style="margin: 0px; color: black; font-size: 12pt;"><small>For example, the unit from BP for oil production is 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 in the Formula. 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>

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

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