nodes_source_analyses

ETDataset – nodes source analyses

The ETDataset is a repository that includes all the input data of the ETModel. This data can apply to:

1. A country's energy system

• Energy technologies (like electric cars)
• Energy carriers (like fuels)

Needless to say the data of type 1 are country specific, i.e. they vary per country, as far as data and sources are concerned. Almost all data of types 2 and 3 are global as far as the Energytransition model is concerned. The 'nodes' documented in the node source analyses contained in this particular directory are mostly energy conversion technologies, so this directory is for documenting type 2 data.

For those contributing to the ETM, once a coherent dataset is completed on ETDataset, it needs to be exported to ETSource from where the Input Data will be used in calculations by ETEngine. The user can interact with the model through the front-end of the ETM that is maintained in the ETModel repository.

This nodes_source_analyses repository contains Excel files of all the nodes that are used in the ETModel. Each nodes_source_analysis has the purpose to analyze and document the technical and costs parameters of the nodes. Once a nodes_source_analysis is completed, it needs to be exported to ETDataset, from where it will be exported to ETSource using VBA functionality. The following image describes the dataflow used to transfer the data from the nodes_source_analysis to ETDataset and then to ETSource.

The main reasons for creating the nodes_source_analyses are:

• to update the technical and cost parameters of nodes that are used in the ETModel.
• to document the technical and cost parameters of nodes and make them transparent to the public.
• to document the technical and cost parameters of nodes in a more comprehensive way for the public.
• to document the technical and cost parameters of nodes in a simple way, that easily can be updated in the future.
• to document the analyses of the technical and cost parameters of nodes and present the sources that are used for the calculations.

The analyses of the technical and cost parameters are based on data from various institutions’ reports.

##Content

The nodes_source_analyses repository contains folders of all sectors:

• Households
• Buildings
• Energy
• Transport
• Industry
• Agriculture.

Each folder includes Excel files of the relevant nodes. The Excel files contains the following sheets:

• The Cover Sheet, which introduces to the reader the analysed node and explains the following sheets.

• The Dashboard, this sheet includes all the attributes of the analyzed node. The columns of this sheet refer to:

  • Name of the node attribute
  • Unit of the node attribute
  • Value of the node attribute
  • Definition of the node attribute
  • Sources of the node attribute

• The Research data, this sheet includes the calculations and sources used for the technical and costs parameters. The columns include:

  • Name of the parameter
  • Unit of the parameter
  • Value of the parameter
  • Sources used for the calculation of the parameter
  • Comments

• The Sources, this sheet summarizes all the sources used for the analysis. The columns include:

  • Name of the source
  • Date published/ retrieved
  • Subject year
  • ETM Library URL, all the documents used are stored to the ETM Library
  • Link of the source

• The Notes, it includes notes and screenshots of the sources used for the calculation.

Generate node source analyses

The main purpose of this repository is to document the nodes used in the ETModel, putting focus on the analyses of the technical and cost parameters. This section outlines the process and methods used for the documentation of the nodes.

Excel files are used for the documentation of the nodes, in order to keep the node_source_analyses as simple as possible for the public, The following steps and methods were used in order to create an Excel file of each node.

1. Copied all attributes of the node from ETSource to the Dashboard sheet.
2. Researched for new sources in order to update the values of the technical and cost parameters of the node. For the calculation of the new values the following methods were used:
   • The latest and most reliable sources were used and an average value of the sources was taken.
   • The value of each parameter is dynamic, so in case of any change it automatically changes to the Dashboard sheet.
   • Sreenshots and notes of the sources used were taken, in order to make it easier for the reader to verify the data from the relevant source.
   • The values are linked in all sheets (Dashboard , Research data and Notes ).
3. All the documents used for the analyses are stored in the ETM Library.
4. The name of the Excel file is the same with the equivelant node (i.e. <node_name>.xlsx).

Export data to ETDataset

Once the Excel file is completed, it need to be exported to ETDataset. The data of the ETDataset is available in the GitHub repository, you can read more about GitHub here.

Exporting data to ETDataset includes the following steps:

• Create a new branch
• Commit your changes
• Push commits to remote repository
• Create a pull request

More details can be found here.

Export data to ETSource

Once the data from the node_source_analyses is exported to ETDataset and merged, then needs to be exported to ETSource. This can be done with the VBA functionality, which is stored to the node_manager. The node_manager was cteared for exporting the data form ETDataset to ETSource. It is a .xlsm file and is also stored to ETDataset. The node_manager:

• Contains all the VBA functionality

• Contains general remarks on source documentation of node attributes

• Allows easy opening of source documents through browse menu.

Exporting data to ETSource includes the following steps:

• Create a new branch
• Open the Excel file through the node_manager
• Commit your changes
• Push commits to remote repository
• Create a pull request

Document a new node

It is simple to create a new documentation for a node. The following steps need to be made for the new Excel file:

• Name the Excel file with the same name of the node and save it to the right folder
• Copy all the node attributes from ETSource to Dashboard sheet
• Research for new sources and document them in the Research data sheet
• Keep screenshots and notes of the sources used in the Notes sheet
• Use the ETM Library to store all the new sources
• Make the values linked in all sheets (Dashboard , Research data and Notes )
• Export the new data to ETDataset and create a pull request
• Once the pull request is merged, export data to ETSource.