What are the benefits of virtual measuring points in the Reporting Tool of SIMATIC powerrate?
The SIMATIC powerrate power data management software captures and archives power consumption values of all the connected measuring points (measuring devices). These measured values can be output in Excel reports using the "Powerrate Reports" reporting tool supplied with SIMATIC powerrate.
These reports include
- Export of archived measured values
- Cost-center report
- Duration curve report
- Batch-related power reports
For example, with the report type "Export of archived measured values" the measured values are exported directly from the database into an Excel file. In many cases, however, the user is not interested in the pure "raw data", but wants a prepared presentation.
|No.||Option (independent from one another, combined use also possible)|
|1||Calculation of multiple physical measuring points (measuring devices) into one virtual measuring point.|
There are the basic forms of calculation available +, -, *, /, as well as % and (..).
|2||Unit conversion of the measured values
|3||Transformation of the technical measuring point designations into generally understandable plain text.
In each case, the date, time stamp and designations of the measured values in the database remain untouched and are available for other reports.
Below we give the example of the configuration of a virtual measuring point using the report type "Export of archived measured values".
Of course, you can also configure a virtual measuring point for other report types.
|1||Open the "Powerrate Reports" report tool over the Windows Start menu.
|2||Use the "Add report" button to create a new report.
|3||The Report Editor opens, which helps you create a report step-by-step.|
Make the following settings.
|4||Enter "pre" of SIMATIC powerrate for the measured value archive.
|6||Specify the name and unit for the virtual process tag:
|7||Below is the configuration of the examples named in Table 01.
|8||Select the virtual measuring point(s) that should appear in the report and click "Next".
|9||Specify the report period and click "Create report".
|10||The report is created in Excel and saved in the file configured in Step 3.|
Open this report and open the "Virtual process tags" worksheet.
Further Information about B.Data
An overview of the topic of energy management with SIMATIC is available in Entry ID: 68043160.
Energy data management