International Energy Agency (IEA) - Revision history

Wikiadmin at 23:54, 10 September 2018

2018-09-10T23:54:27Z

← Older revision		Revision as of 23:54, 10 September 2018
Line 1:		Line 1:
	~~= About =~~

	The '''International Energy Agency commenced''' its operation in 1974 under the auspices of the Organization for Economic Co-operation and Development (OECD). The IEA is the energy forum for 26 Member countries, all from the OECD, to improve the world’s energy supply and to promote reliable databases for energy-related information. IEA member governments are committed to sharing energy information, to co-ordinating their energy policies and to co-operating in the development of rational energy programs. IEA publishes monthly reports on electricity, natural gas, prices, and the oil market. The [http://www.worldenergyoutlook.org/publications/ ''World Energy Outlook''] is the IEA's most comprehensive publication, and is considerd " the world’s most authoritative source of energy market analysis and projections."		The '''International Energy Agency commenced''' its operation in 1974 under the auspices of the Organization for Economic Co-operation and Development (OECD). The IEA is the energy forum for 26 Member countries, all from the OECD, to improve the world’s energy supply and to promote reliable databases for energy-related information. IEA member governments are committed to sharing energy information, to co-ordinating their energy policies and to co-operating in the development of rational energy programs. IEA publishes monthly reports on electricity, natural gas, prices, and the oil market. The [http://www.worldenergyoutlook.org/publications/ ''World Energy Outlook''] is the IEA's most comprehensive publication, and is considerd " the world’s most authoritative source of energy market analysis and projections."

Wikiadmin at 15:51, 5 September 2018

2018-09-05T15:51:24Z

← Older revision		Revision as of 15:51, 5 September 2018
Line 5:		Line 5:
	The main IEA sources used by IFs are the '''''World Energy Balances (WEB) '''''<b>and </b>'''''World Energy Statistics (WES)''''',''' '''databases assocated with the ''World Energy Outlook.'' They contain variables such as the production, trade, and consumption of coal, oil, gas, electricity, heat, renewables, and waste for OECD countries and over 100 non-OECD countries.		The main IEA sources used by IFs are the '''''World Energy Balances (WEB) '''''<b>and </b>'''''World Energy Statistics (WES)''''',''' '''databases assocated with the ''World Energy Outlook.'' They contain variables such as the production, trade, and consumption of coal, oil, gas, electricity, heat, renewables, and waste for OECD countries and over 100 non-OECD countries.

	== Data Acquisition ==		= Data Acquisition =

	Unlike most data used in IFs, IEA data from the WEB and WES are not open source. The data must be purchased from the IEA and is delivered on two CD-ROMs.[http://www.iea.org/bookshop/730-World_Energy_Statistics_and_Balances_2016 [1]] Each disc runs on a database management software program called Beyond 20/20 that comes loaded on the discs, along with the data. Financial support for the purchase of the IEA data is available from a University Library Association grant. Pardee successfully applied for grant funding through this program for the 2017 update with the help of staff at the Anderson Academic Commons at the University of Denver.		Unlike most data used in IFs, IEA data from the WEB and WES are not open source. The data must be purchased from the IEA and is delivered on two CD-ROMs.[http://www.iea.org/bookshop/730-World_Energy_Statistics_and_Balances_2016 [1]] Each disc runs on a database management software program called Beyond 20/20 that comes loaded on the discs, along with the data. Financial support for the purchase of the IEA data is available from a University Library Association grant. Pardee successfully applied for grant funding through this program for the 2017 update with the help of staff at the Anderson Academic Commons at the University of Denver.

	== Documentation ==		= Documentation =

	Full documentation is available for each dataset detailing its contents, structure, definitions, geographical coverage, etc.		Full documentation is available for each dataset detailing its contents, structure, definitions, geographical coverage, etc.
Line 17:		Line 17:
	[http://wds.iea.org/wds/pdf/WORLDBES_Documentation.pdf World Energy Statistics 2016 Database Documentation]		[http://wds.iea.org/wds/pdf/WORLDBES_Documentation.pdf World Energy Statistics 2016 Database Documentation]

	== Batch Pull ==		= Batch Pull =

	The IEA update is performed as a batch pull that includes '''138 series''' using the Batch Data Update feature in IFs. In the display, "IEA" is the Source and the "IEA Countries" country list is used for country concordance. For the Code Location in Source Data portion of the update form, the source Excel must be formatted so that each Code in Source term is in a different column. For example, SeriesEnImportsOilProductsIEA's Code in Source is "Imports.Oil products," so there should be two columns with "Imports" in one and "Oil products" in the next.		The IEA update is performed as a batch pull that includes '''138 series''' using the Batch Data Update feature in IFs. In the display, "IEA" is the Source and the "IEA Countries" country list is used for country concordance. For the Code Location in Source Data portion of the update form, the source Excel must be formatted so that each Code in Source term is in a different column. For example, SeriesEnImportsOilProductsIEA's Code in Source is "Imports.Oil products," so there should be two columns with "Imports" in one and "Oil products" in the next.

	== Series Codes ==		= Series Codes =

	Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The Codes are listed in the DataDict, and should match the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code. [NOTE: Drag and drop FLOW, PRODUCT, UNIT, and COUNTRY to column and row headers to reconfigure the display in Beyond 20/20.]		Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The Codes are listed in the DataDict, and should match the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code. [NOTE: Drag and drop FLOW, PRODUCT, UNIT, and COUNTRY to column and row headers to reconfigure the display in Beyond 20/20.]
Line 37:		Line 37:
	[[File:IEA Beyond 2020 screenshot.png\|800px\|IEA Beyond 2020 screenshot.png]]		[[File:IEA Beyond 2020 screenshot.png\|800px\|IEA Beyond 2020 screenshot.png]]

	== Pulling and Formatting the Data ==		= Pulling and Formatting the Data =

	=== Pulling ===		== Pulling ==

	Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]		Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]
Line 45:		Line 45:
	[[File:IEA Beyond 2020 screenshot 2.png\|800px\|IEA Beyond 2020 screenshot 2.png]]		[[File:IEA Beyond 2020 screenshot 2.png\|800px\|IEA Beyond 2020 screenshot 2.png]]

	=== Formatting ===		== Formatting ==

	Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported with the Batch Import tool using the Codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the Codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)").		Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported with the Batch Import tool using the Codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the Codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)").
Line 51:		Line 51:
	[[File:IEA Excel ex.png\|800px\|IEA Excel ex.png]]		[[File:IEA Excel ex.png\|800px\|IEA Excel ex.png]]

	== Conversions ==		= Conversions =

	Most of the necessary conversion for these series are done automatically through the Batch Import form. However, 22 series had to be converted manually for the the 2017 update from terajoules (TJ) to kilotones of energy equivalent (ktoe). The conversion factor used for these series is from the [https://www.iea.org/statistics/resources/unitconverter/ IEA Unit Converter]: TJ value*0.0238845897. These series include:		Most of the necessary conversion for these series are done automatically through the Batch Import form. However, 22 series had to be converted manually for the the 2017 update from terajoules (TJ) to kilotones of energy equivalent (ktoe). The conversion factor used for these series is from the [https://www.iea.org/statistics/resources/unitconverter/ IEA Unit Converter]: TJ value*0.0238845897. These series include:
Line 102:		Line 102:
	\|}		\|}

	== DataDict ==		= DataDict =

	'''Variable: '''<span style="font-size: 13px;">Variable names were not changed from previous years this data was pulled, and no additional variables were added for the 2017 pull.</span>		'''Variable: '''<span style="font-size: 13px;">Variable names were not changed from previous years this data was pulled, and no additional variables were added for the 2017 pull.</span>
Line 140:		Line 140:
	'''Formula: '''These were not changed from previous years this data was pulled, and are either blank or convert data to BBOE or GwHr.		'''Formula: '''These were not changed from previous years this data was pulled, and are either blank or convert data to BBOE or GwHr.

	== Preprocessor Series ==		= Preprocessor Series =

	Of the 138 IEA Batch Pull series, 24 are preprocessor. These series should be first priority in any IEA batch update. They include:		Of the 138 IEA Batch Pull series, 24 are preprocessor. These series should be first priority in any IEA batch update. They include:
Line 195:		Line 195:
	\|}		\|}

	== Non-Preprocessor Series ==		= Non-Preprocessor Series =

	There are 114 nonpreprocessor series included in the IEA update. They include:		There are 114 nonpreprocessor series included in the IEA update. They include:
Line 430:		Line 430:
	\|}		\|}

	== Country Concordance ==		= Country Concordance =

	There is a unique country concordance table for the IEA series called "IEA Countries." This table should be checked for accuracy at the time of each update. For the 2017 update, the following countries had to be updated (to the form listed):		There is a unique country concordance table for the IEA series called "IEA Countries." This table should be checked for accuracy at the time of each update. For the 2017 update, the following countries had to be updated (to the form listed):

Wikiadmin at 15:50, 5 September 2018

2018-09-05T15:50:25Z

← Older revision		Revision as of 15:50, 5 September 2018
Line 4:		Line 4:

	The main IEA sources used by IFs are the '''''World Energy Balances (WEB) '''''<b>and </b>'''''World Energy Statistics (WES)''''',''' '''databases assocated with the ''World Energy Outlook.'' They contain variables such as the production, trade, and consumption of coal, oil, gas, electricity, heat, renewables, and waste for OECD countries and over 100 non-OECD countries.		The main IEA sources used by IFs are the '''''World Energy Balances (WEB) '''''<b>and </b>'''''World Energy Statistics (WES)''''',''' '''databases assocated with the ''World Energy Outlook.'' They contain variables such as the production, trade, and consumption of coal, oil, gas, electricity, heat, renewables, and waste for OECD countries and over 100 non-OECD countries.

	~~= Metadata =~~

	== Data Acquisition ==		== Data Acquisition ==

AlannaMarkle at 21:56, 25 May 2017

2017-05-25T21:56:16Z

← Older revision		Revision as of 21:56, 25 May 2017
Line 21:		Line 21:
	== Batch Pull ==		== Batch Pull ==

	The IEA update is performed as a ~~Batch Pull~~ that includes '''138 series''' using the Batch Data Update feature in IFs. In the display, "IEA" is the Source, "IEA Countries" ~~are~~ used for country concordance. For the Code Location in Source Data portion of the update form, the source Excel must be formatted so that each Code in Source term is in a different column. For example, SeriesEnImportsOilProductsIEA's Code in ~~Sourse~~ is "Imports.Oil products," so there should be two columns with "Imports" in one and "Oil products" in the next.		The IEA update is performed as a batch pull that includes '''138 series''' using the Batch Data Update feature in IFs. In the display, "IEA" is the Source and the "IEA Countries" country list is used for country concordance. For the Code Location in Source Data portion of the update form, the source Excel must be formatted so that each Code in Source term is in a different column. For example, SeriesEnImportsOilProductsIEA's Code in Source is "Imports.Oil products," so there should be two columns with "Imports" in one and "Oil products" in the next.

	== Series Codes ==		== Series Codes ==

	Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The ~~codes~~ are listed in the DataDict, and should match ~~(or be extremely close to)~~ the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code. Drag and drop FLOW, PRODUCT, UNIT, and COUNTRY to column and row headers to reconfigure the display in Beyond 20/20.		Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The Codes are listed in the DataDict, and should match the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code. [NOTE: Drag and drop FLOW, PRODUCT, UNIT, and COUNTRY to column and row headers to reconfigure the display in Beyond 20/20.]

	'''Example'''		'''Example'''
Line 43:		Line 43:
	=== Pulling ===		=== Pulling ===

	Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series  at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]		Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]

	[[File:IEA Beyond 2020 screenshot 2.png\|800px\|IEA Beyond 2020 screenshot 2.png]]		[[File:IEA Beyond 2020 screenshot 2.png\|800px\|IEA Beyond 2020 screenshot 2.png]]
Line 49:		Line 49:
	=== Formatting ===		=== Formatting ===

	Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported with the Batch Import tool using the ~~codes~~ assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the ~~codes~~, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)").		Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported with the Batch Import tool using the Codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the Codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)").

	[[File:IEA Excel ex.png\|800px\|IEA Excel ex.png]]		[[File:IEA Excel ex.png\|800px\|IEA Excel ex.png]]
Line 55:		Line 55:
	== Conversions ==		== Conversions ==

	Most of the necessary conversion for these series are done automatically through the Batch Import form~~; however~~, ~~there~~ 22 series ~~that as of the 2017 update~~ had to be converted ~~by hand~~ from terajoules (TJ) to kilotones of energy equivalent (ktoe). The conversion factor used for these series is from the [https://www.iea.org/statistics/resources/unitconverter/ IEA Unit Converter]: TJ value*0.0238845897. These series include:		Most of the necessary conversion for these series are done automatically through the Batch Import form. However, 22 series had to be converted manually for the the 2017 update from terajoules (TJ) to kilotones of energy equivalent (ktoe). The conversion factor used for these series is from the [https://www.iea.org/statistics/resources/unitconverter/ IEA Unit Converter]: TJ value*0.0238845897. These series include:

	{\| border="0" cellpadding="0" cellspacing="0" width="320"		{\| border="0" cellpadding="0" cellspacing="0" width="320"
Line 110:		Line 110:
	'''Table: '''These were not changed from previous years this data was pulled.		'''Table: '''These were not changed from previous years this data was pulled.

	'''Code in Source: '''~~Identifies the series for batch import;~~ were not changed from previous years this data was pulled.		'''Code in Source: '''These were not changed from previous years this data was pulled.

	'''Groups: '''These were not changed from previous years this data was pulled.		'''Groups: '''These were not changed from previous years this data was pulled.
Line 118:		Line 118:
	'''Definitions and Units:''' These were not changed from previous years this data was pulled.		'''Definitions and Units:''' These were not changed from previous years this data was pulled.

	'''Extended Source Defn: '''All were marked as "No Extended Source" for 2017 pull. Units used in this dataset ~~include~~ BBOE and GwHr.		'''Extended Source Defn: '''All were marked as "No Extended Source" for 2017 pull.

			'''Units:''' These were not changed from previous years; the units used in this dataset are BBOE and GwHr.

	'''Years: '''Years for every series were changed to available data provided through the database. Most series begin in 1960 with the exception of EnExportsOilIEA, EnImportsOiliIEA, and EnProdOilIEA, which begin in 1971. All extend through either 2014 or 2015 as of the 2017 update.		'''Years: '''Years for every series were changed to available data provided through the database. Most series begin in 1960 with the exception of EnExportsOilIEA, EnImportsOiliIEA, and EnProdOilIEA, which begin in 1971. All extend through either 2014 or 2015 as of the 2017 update.

	'''Source:''' The source used in the 2017 update for all batch pull IEA series is "IEA (International Energy Agency) Batch Pull."		'''Source:''' The source name used in the 2017 update for all batch pull IEA series is "IEA (International Energy Agency) Batch Pull."

	'''Original Source:''' The original source used in the 2017 update for all series is the "World Energy Outlook."		'''Original Source:''' The original source used in the 2017 update for all series is the "World Energy Outlook."
Line 132:		Line 134:
	'''Disaggregation: '''Disaggregations were not changed from previous updates.		'''Disaggregation: '''Disaggregations were not changed from previous updates.

	'''Name in source:''' ~~Was~~ updated based on the name of each variable as it is displayed in the Beyond 20/20 database format; generally matches the Code in Source.		'''Name in source:''' Names were updated based on the name of each variable as it is displayed in the Beyond 20/20 database format; generally matches the Code in Source.

	'''Decimal places: '''These were not changed from previous years this data was pulled.		'''Decimal places: '''These were not changed from previous years this data was pulled.

	'''Country Concordance: '''~~FAO~~ Countries were used.		'''Country Concordance: '''IEA Countries were used (and updated for the 2017 pull, see below).

	'''Formula: '''These were not changed from previous years this data was pulled, and are either blank or convert data ~~from ktoe~~ to BBOE or ~~GwH~~		'''Formula: '''These were not changed from previous years this data was pulled, and are either blank or convert data to BBOE or GwHr.

	== Preprocessor Series ==		== Preprocessor Series ==

	Of the 138 IEA Batch Pull series, 24 are preprocessor. These series should be ~~updated~~ first in any IEA batch update. They include:		Of the 138 IEA Batch Pull series, 24 are preprocessor. These series should be first priority in any IEA batch update. They include:

	{\| border="0" cellpadding="0" cellspacing="0" width="175"		{\| border="0" cellpadding="0" cellspacing="0" width="175"
Line 197:		Line 199:
	== Non-Preprocessor Series ==		== Non-Preprocessor Series ==

	There are 114 nonpreprocessor series included in the IEA ~~Batch Pull~~. They include:		There are 114 nonpreprocessor series included in the IEA update. They include:

	{\| border="0" cellpadding="0" cellspacing="0" width="64"		{\| border="0" cellpadding="0" cellspacing="0" width="64"
Line 432:		Line 434:
	== Country Concordance ==		== Country Concordance ==

	There is a unique country concordance table for IEA series called "IEA Countries." This table should be checked for accuracy at the time of each update. For the 2017 update, the following countries had to be updated (to the form listed):		There is a unique country concordance table for the IEA series called "IEA Countries." This table should be checked for accuracy at the time of each update. For the 2017 update, the following countries had to be updated (to the form listed):

	{\| border="0" cellpadding="0" cellspacing="0" width="279"		{\| border="0" cellpadding="0" cellspacing="0" width="279"

AlannaMarkle at 21:40, 25 May 2017

2017-05-25T21:40:11Z

Show changes

AlannaMarkle at 21:38, 25 May 2017

2017-05-25T21:38:17Z

Show changes

AlannaMarkle at 21:19, 25 May 2017

2017-05-25T21:19:52Z

@@ Line 37: / Line 37: @@
 PRODUCT: Oil products
-See Beyond 20/20 screenshot here&nbsp;-&nbsp;[http://pardee.du.edu/wiki/index.php?title=File:IEA_Beyond_2020_screenshot.png File:IEA Beyond 2020 screenshot.png]
+[[File:IEA Beyond 2020 screenshot.png|800px]]
 == Pulling and Formatting the Data ==
@@ Line 47: / Line 45: @@
 Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT&nbsp;or FLOW. For example, it is possible to pull all natural gas or oil products series &nbsp;at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data&nbsp;had to be copied and pasted into a new sheet to be manipulated]
+[[File:IEA Beyond 2020 screenshot 2.png|800px]]
 === Formatting ===
-Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported using the codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)")
+Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported with the Batch Import tool using the codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)").
-See Souce Excel screenshot here -&nbsp;
+[[File:IEA Excel ex.png|800px]]
 == DataDict ==
@@ Line 151: / Line 145: @@
 == Country Concordance ==

AlannaMarkle at 21:11, 25 May 2017

2017-05-25T21:11:01Z

← Older revision		Revision as of 21:11, 25 May 2017
Line 38:		Line 38:

	See Beyond 20/20 screenshot here - [http://pardee.du.edu/wiki/index.php?title=File:IEA_Beyond_2020_screenshot.png File:IEA Beyond 2020 screenshot.png]		See Beyond 20/20 screenshot here - [http://pardee.du.edu/wiki/index.php?title=File:IEA_Beyond_2020_screenshot.png File:IEA Beyond 2020 screenshot.png]

			[[File:IEA_Beyond_2020_screenshot.png]]

	== Pulling and Formatting the Data ==		== Pulling and Formatting the Data ==

AlannaMarkle at 21:06, 25 May 2017

2017-05-25T21:06:35Z

← Older revision		Revision as of 21:06, 25 May 2017
Line 43:		Line 43:
	=== Pulling ===		=== Pulling ===

	~~== ==~~		Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series  at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]



	~~== ==~~

	Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series  at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]

	See Beyond 20/20 screenshot here -		See Beyond 20/20 screenshot here -

AlannaMarkle at 21:05, 25 May 2017

2017-05-25T21:05:23Z

← Older revision		Revision as of 21:05, 25 May 2017
Line 25:		Line 25:
	== Series Codes ==		== Series Codes ==

	Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The codes are listed in the DataDict, and should match (or be extremely close to) the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code.		Because this is a batch pull, each series needs a Code in addition to a variable name to be imported. The codes are listed in the DataDict, and should match (or be extremely close to) the series name in the IEA source database. For the 2017 update, series on the WEB and WES discs were organized by two parameters, FLOW and PRODUCT, where FLOW is the first term of the Code and PRODUCT is the second term of the Code. Drag and drop FLOW, PRODUCT, UNIT, and COUNTRY to column and row headers to reconfigure the display in Beyond 20/20.

	'''Example'''		'''Example'''
Line 32:		Line 32:

	Code: Imports.Oil products		Code: Imports.Oil products
	~~<pre>[[File:''filename.extension''\|''options''\|''caption'']]</pre>~~

	~~[[[http~~:~~//pardee.du.edu/wiki/index.php?title=File:IEA_Beyond_2020_screenshot.png File:IEA Beyond 2020 screenshot.png]]]~~		FLOW: Imports

			PRODUCT: Oil products

			See Beyond 20/20 screenshot here - [http://pardee.du.edu/wiki/index.php?title=File:IEA_Beyond_2020_screenshot.png File:IEA Beyond 2020 screenshot.png]

			== Pulling and Formatting the Data ==

			=== Pulling ===

	~~[[File:IEA Beyond 2020 screenshot.png\|Beyond 20/20 Image]]~~		== ==

	== ==		== ==

	== ~~Pulling the Data~~ ==		Ideally, the IEA series are pulled from the discs in bulk. As of the 2017 update, Beyond 20/20 limits the number of records that can be exported at one time, preventing all the data from being exported at once; however, it is possible to pull all records by PRODUCT or FLOW. For example, it is possible to pull all natural gas or oil products series  at once from the WEB disc. Pull the data by assembling the correct configuration in Beyond 20/20, then going to File>Save As and saving it as a .xls file. It is also possible to copy and past individual (or a few) series into an Excel by highlighting them, but not a large number of series at once. [NOTE: The directly exported Excel file did not work on Pardee computers due to a policy setting issue, so the data had to be copied and pasted into a new sheet to be manipulated]

			See Beyond 20/20 screenshot here -

			=== Formatting ===

			Once the series have been pulled by PRODUCT or FLOW, they need to be cleaned. Missing data are marked with a "..", "x", or "n," so remove these with a Find+Replace. The data can then be imported using the codes assocated with the FLOW and PRODUCT, along with the country name. It may be necessary to also clean the codes, for example if there is a unit listed parenthetically after the name of the product (i.e. "Solar thermal (TJ-net)")

	~~Ideally, the IEA series can be pulled from the discs in bulk.~~		See Souce Excel screenshot here -

	== DataDict ==		== DataDict ==