Requirements
To create and edit the OpenOffice report templates, OpenOffice (Download) or LibreOffice (Download) must be installed on your PC.Important:
It is imperative that you use the software mentioned above to create the report templates. Opening and saving in other programs (e.g. Microsoft Office / Word) renders the file unusable.
Corresponding sample report templates can be found in the appendix to this FAQ.
Variables
The list of variables that can be used in the report can be displayed via the following menu:
The corresponding variables appear in a new window.
You can choose from different categories and copy the name of the variable to the clipboard with a click next to the designation in order to then paste it into the report template:
Inserting variables
Open a corresponding report template with OpenOffice or LibreOffice.You can design the template according to your wishes and insert the desired variables at any point:
Example:
Peak Power: {system:performance} kWp
will generate the following sentence for a 4.9 kWp system when the report is generated:
Peak Power: 4.9 kWp
Inserting graphics
To insert a graphic, a dummy image must be used. If you have not yet inserted a dummy image, you can do this simply using the Insert image function in OpenOffice or LibreOffice.Open the properties of the dummy picture (double-click) and enter the desired variable in the Name field. When the image is generated, the dummy image is then replaced with the corresponding image from the variable.
Inserting tables
All table values must be defined in a table that takes the following parameters into account:
{START} for the first cell of the row, followed by the first variable.
{END} for the last cell of the row after the last variable that is displayed in the table.
In some cases it is possible to define the variable via different time resolutions depending on the selected data point or the selected table:
- Day
- Week
- Month
- Year
Daily, monthly, weekly OR annual values.
Examples:
Display ticket statistic:
Causes |
Absolute |
Relative |
{START}{ts:causes:table.causes} |
{ts:causes:table.absolute} |
{ts:causes:table.relative}{END} |
Display daily Energy Generation and specific Yield:
Energy production |
Spec. yield |
|
{START}{mdDay:calc.date} |
{mdDay:calc.E_ZAEHLER} kWh |
{mdDay:calc.E_N} kWh/kWp{END} |
Display monthly Energy Generation and specific Yield:
Energy production |
Spec. yield |
|
{START}{mdMonth:calc.date} |
{mdMonth:calc.E_ZAEHLER} kWh |
{mdMonth:calc.E_N} kWh/kWp{END} |
Table of contents
When inserting table of contents, please note that these do not have to be created manually.
Please use the OpenOffice integrated option Insert -> Directory -> Directory.