Siemens Industry Online Support
Siemens AG
Entry type: FAQ Entry ID: 79161605, Entry date: 09/03/2013

What are the benefits of virtual measuring points in the Reporting Tool of SIMATIC powerrate?

  • Entry
  • Associated product(s)

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

Fig. 01

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.

Advantages of the virtual measuring points
Here the user can employ the advantages of virtual measuring points.

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 (..).

Several measuring devices are integrated in a production line. Each one measures a single consumption. The total consumption can only be summed using a virtual measuring point.

2 Unit conversion of the measured values

At the delivery point the power consumption is measured and archived in the "kW" unit. However, for the sake of clarity, the unit in the report is supposed to be "MW". This is of course also possible with non-electrical units, like the conversion of liters into cubic meters.

3 Transformation of the technical measuring point designations into generally understandable plain text.

The technical designation of a measuring point is difficult to understand for inexperienced users. However, using a virtual measuring points makes it easy to transform the name in the report.

Table 01

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.

No. Procedure
1 Open the "Powerrate Reports" report tool over the Windows Start menu.

Fig. 02

2 Use the "Add report" button to create a new report.

Fig. 03

3 The Report Editor opens, which helps you create a report step-by-step.
Make the following settings.
  • Select "Export of archived measured values" as the Report Type.
  • Select "Manual" for the Trigger.
  • Enter "Report_01" under Name.
  • Select a storage location of your choice.
  • Click the "Next" button to confirm the settings.

Fig. 04

4 Enter "pre" of SIMATIC powerrate for the measured value archive.

Fig. 05

  • To create a virtual measuring point you right-click an item in the table with the archive tags.
  • Select "Virtual process tag > Add".

Fig. 06

6 Specify the name and unit for the virtual process tag:
  • You must terminate the name with ".V" (for power values) or ".S" (for energy values); for example "Delivery.V".
  • Put the unit in square brackets for the sake of clarity ("[kW]", for example).

Fig. 07

Fig. 08

7 Below is the configuration of the examples named in Table 01.
  • Calculation of multiple physical measuring points (measuring devices) into one virtual measuring point.
    The figure shows how multiple single power values are summed into one single total value.

    Fig. 09
  • Unit conversion of the measured values
    The figure shows how the in-feed power is converted from the output unit [kW] into the target unit [MW].

    Fig. 10
  • Transformation of the technical measuring point designation.
    The figure shows how an S7 program-side measuring point designation is transformed into generally understandable plain text.

    Fig. 11
8 Select the virtual measuring point(s) that should appear in the report and click "Next".

Fig. 12

9 Specify the report period and click "Create report".

Fig. 13

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.

Fig. 14

Table 02

Further Information about B.Data
An overview of the topic of energy management with SIMATIC is available in Entry ID: 68043160.

Additional Keywords
Energy data management

Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit