SpreadSheet
Basic concept
Configuration
In the configuration it is defined to which Eliona instance the connection should be made and which reports are created with which template.
Eliona Instance
Reports
The configuration of the reports is located within a list. This can contain one or more reports. Each report requires at least these configurations.
Templates
The templates should be stored in Excel format and must contain the configuration of the assets. The link to the assets / attributes in Eliona looks like this:
{"assetGai":"H01 Fernwärme Energiezähler IWB", "attribute":"Energie", "raster":"MONTH", "mode":"sum"}
The required information is entered here in JSON format.
Berechnungen
Calculations are performed in Excel. All Excel functions can be used here. Referencing values from your own table as well as using values from Eliona is possible. When using values from Eliona, simply use the JSON part for referencing.
Example: Here a cell content is subtracted from an Eliona Asset attribute.
= ({"assetGai":"K01 Netz Energiezähler 1005", "attribute":"Energie", "raster":"MONTH", "mode":"sum"} - J6)
ATTENTION: Entering such a formula is prevented by Excel. For this purpose, the format of the cell must be adjusted. After entering the formula, the cell type can be reset. It is recommended to choose the number format.
DataListSequential
Has not been used so far. Has only been intended for one project in the bidding phase
DataListParallel (Liste parallel)
Example table
Beispiel Template
Details
DataEntry
Beispiel Tabelle:
Beispiel Template:
Creating a report manually
To create a report manually, the Docker container can be opened and App.py can be called with arguments. A help exists which can be called with -h.
Last updated