Skip to content

Exporting Data

How to Export Data

Depending on the purpose of the data generated in TOP-Energy, there are different ways of exporting them. In the following you will learn about these possibilities. Detailed descriptions of the individual export functions can also be found in the linked articles.

In addition to the data export options shown below, it is possible to copy and paste certain data from TOP-Energy (by the key combinations <CTRL>+<A>, <CTRL>+<C> and <CTRL>+<V>) to other files, e.g., in the rare cases in which model descriptions (Model equations) are to be exported.

Data Report (in Word format)

The data report displays the project input and output data intended for export in a Microsoft Word document. In contrast to the eValuate report in Word format, this is merely a data collection in the form of tables and schematic illustrations without text and diagrams.

In the Report configuration, which is activated in the Home ribbon, you determine which data is collected in the data report. Select the check boxes for the export in the displayed boxes either in the Project explorer in front of whole project tree elements or in the form view in front of the individual data of the components (see the following figure).

You can also use the default report configuration for a data report without making your own selections.

To output the data of the entire project as a Word report, select the Word-Datenbericht Generate data report function in Export group of the the Project ribbon via the Word split button.

You can output the data not only for the entire project at once, but also individually for each selected element of the project.

To output only the data of an element from the project as a Word report (e.g., a Variante variant or a single component), right-click on this element in the Project explorer and select Bericht erzeugen Generate report → Word-Datenbericht Generate data report.

Further information on the data report in Word format can be found in the article Generating Reports and in the articles about the structure and configuration of data reports.

eValuate Report (in Word format)

The eValuate report describes the variants examined in the eValuate module and compares them according to economic and ecological criteria. It contains text passages and diagrams. The eValuate report in Word format provides a comprehensive, comprehensible, and clear overview of the eValuate results in TOP-Energy and is therefore of central importance when presenting the project results.

The following figure shows an example of the table of contents of an eValuate report for comparing different fuels.

Data Export

There are two accesses to the eValuate report.

To open the economy and ecology report in Microsoft Word select Word-Datenbericht Generate eValuate report in the Project ribbon in the Export group via the Word split button.

It is also possible to open the report using the context menu of individual components in the project explorer. This does not restrict the report to these components. In any case, the data of all variants available in the eValuate module are output. The following figure shows a section of an eValuate report in Word format.

Data Export

Further information on the eValuate report in Word format can be found in the linked article.

Exporting eValuate Calculations in Excel Format

The export of the eValuate calculation creates a file in Microsoft Excel format that summarizes the cost and energy flows of the examined variants of an eValuate module. Several worksheets list the energy forms, costs, and revenues as well as the components used in the system.

You call the eValuate export in Excel format similar to the eValuate report in Word format in the context menu in the Project explorer or in the Project ribbon in the Export group via the Excel split button with the Varianten exportieren Export eValuate calculation. Before, select an eValuate node in the Project explorer to activate this export function.

The exported eValuate calculations also differ in content from the two Word reports (data report and eValuate report, see above).

The eValuate export in Excel format always contains data from the respective eValuate module and the variants compared in it.

The following figure shows a section of the exported eValuate data that are opened in Excel.

Data Export

Further information on eValuate export in Excel format can be found in the linked article.

Exporting the Scheme by Copy-And-Paste

The graphical representation of a project, the scheme, can be exported via the clipboard. You can find out what special features there are when exporting scheme in the linked article.

You can copy and paste the scheme.

To copy the scheme, either all elements are marked with <CTRL>+<A> or single elements are marked with a frame and then copied to a suitable application, e.g., Paint, using <CTRL>+<C> and <CTRL>+<V>.

In Microsoft Office applications (e.g., Microsoft Word, PowerPoint) the graphic is inserted with a transparent background.

Copying Diagrams and Associated Data to the Clipboard

Both the diagrams and the associated data can be exported.

The diagrams displayed in a form can be copied to the clipboard by right-clicking on the diagram and selecting Copy to clipboard and then pasted elsewhere as a graphic (see the illustration below).

The export of the pure data underlying the diagrams works similarly.

The data that make up a diagram can be exported by right-clicking on the diagram and selecting Copy data (see following figure).

The data are copied to the clipboard in tabular form and can then be pasted into suitable programs such as Microsoft Excel.

Export From ETA

Time series plots, value tables, and time series can be exported from ETA. How exactly, you will find out in the following.

 

Exporting Time Series Plots From ETA

The time series plots are the graphical representations of the time series. They can be copied.

The graphic representation (plot) of one or more time series in ETA can be transferred to another application by right-clicking on the graph and selecting Copy plot window to clipboard.

Further options are described in the article Exporting the Plot Window.

Exporting Value Tables From ETA

The value tables on which the graphs are based can also be output for further processing in another application.

To do this, you can select one or more columns of the value table and copy them to the clipboard by right-clicking on them and selecting Copy.

Note that the columns Date and Time, which precede each time series in the value table, are copied automatically in each case. For this reason, they need not and cannot be selected during the copying process. The following figure shows the columns selected for export in the value table of ETA.

Please make sure that the basic settings regarding language, decimal separator, etc., and the formatting of the cells in the target file match the form of the data to be exported.

Exporting Time Series From ETA

The values of the time series to be exported can be saved in a CSV, XLS, or XLSX file. There are basically two ways to carry out this type of export.

In the first case, the time series in the ETA are exported once. This simple time series export is described in the linked article.

You can export time series from ETA once only via the button export time series in the export group of the Project ribbon. After the file name and format have been set, the time series available in the project can be inserted in the next window by dragging and dropping them in the order in which they should appear in the resulting file.

In the second case, repeated export of time series is possible. For this you have to create an Export configuration. This process is described in the linked article.

With the Configuration button in the Export group of the Project ribbon, time series opened from a TOP-Energy project can be exported to a file multiple times using the Time_Series_Interface without using the ETA.
Back To Top