## Types of default reports

This section shows basic characteristics of the Microsoft Excel reports generated from the templates. The first tab in the workbook is created from the “Presentation sheet” of the report template. You can modify the look and functionality of a report by editing its presentation sheet. See "Modifying the Finished Report" on page 1 for details.

Note

The presentation sheet contains references that automatically update the data each time the report is generated. Be careful not to overwrite these references.

#### Energy and Demand

Use the Energy and Demand template to create a tabular report on energy consumption and peak demand levels over a period of time, categorized by time of use. TOU (Time Of Use) schedules are typically set up to match an energy provider’s tariff schedule.

The Energy and Demand template uses quantities from the Energy and Demand log (kWh, kVARh, kVAh, kW Demand, kVAR Demand, kVA Demand) that is available on most devices.

##### TOU Schedule

requires a TOU schedule when creating a report using the Energy and Demand template. A sample TOU schedule is included — this allows you to define time periods that coincide with time periods in your energy provider’s tariff schedule, such as On Peak and Off Peak times. If you do not need to use a TOU schedule, simply create a new TOU schedule with only one time period defined.

The Aggregate Energy & Demand tab contains a summary of the combined energy and demand values. Energy and demand information from different sources are stored in separate tabs in the workbook.

#### Load Profile

Use the Load Profile template to create a graphical representation of demand or load levels over a period of time. The profile shows peak loads — points on the graph where peak electricity demand is high. A load profile report can be used to analyze the electrical loads at the time of maximum demand. This information creates opportunities for developing strategies to improve energy management.

Similar to the Energy and Demand template, the Load Profile template uses data from the Energy and Demand log (kW Demand, kVAR Demand, kVA Demand), except it does not use a TOU schedule.

The Load tab contains a graphical representation of the power usage of your system over time (total load profile). Load profiles from different sources are stored in separate tabs in the workbook.

#### Power Quality

Use the Power Quality template to create a report that summarizes the number and severity of voltage sags, swells and transients over a period of time. The finished report also includes a graphical representation of the disturbances, and an interactive selection of group events.

The Power Quality template uses data from all three Power Quality log files that are found on devices with sag/swell and transient detection capabilities:

Sag/Swell Log

Transient Log

Waveform Log

##### Sample Power Quality Report

A | This graph displays the worst disturbances
B | Click on any incidents's timestamp to view its details

The Power Quality Summary tab displays a chart that identifies the worst line disturbances and a list of incidents linked to their details. An incident is made up of several disturbances.

The Power Quality report shows a system’s line fluctuations for the specified date range. Use the Interactive Power Quality toolbar to change the time interval between incidents:

A | Select the incident interval (time between power quality events)

Click the timestamp of the incident in the Waveforms tab to view a graphical representation of the disturbance.

A | Click Show Complete to display individual waveforms
B | Click the magnify buttons to zoom in or out

#### EN50160

EN50160 is a set of power quality standards used by energy suppliers and energy consumers in European countries. The following EN50160 templates are available in :

##### CM_EN50160_General

Use the CM_EN50160_General template to create a report containing detailed analysis of the entire EN50160 compliance data logged by a single Circuit Monitor device. Data is recorded for each observation period. The worksheets contain percentages of non-compliant EN50160 measurements such as Power Frequency, Supply Voltage Magnitude, and Flicker.

##### CM_EN50160_Summary

Use the CM_EN50160_Summary template to create a report containing comprehensive analysis of the entire EN50160 compliance data logged by multiple Circuit Monitor devices. The compliance summary is based on the EN50160 limits for each observation period: each default EN50160 measurement indicates a pass with a Y (yes), or a did not pass with an N (no), on the compliance test.

The CM_EN50160_Summary template uses data from the same log files as the CM_EN50160_General template.

An observation sheet is generated for every observation period; however, it is hidden by default. You can access specific observation sheets by unhiding the specific sheet for the generated report in Microsoft Excel (Format > Sheet > Unhide > “observation sheet”).

##### EN50160_General

Use the EN50160_General template to create a report containing detailed analysis of the entire EN50160 compliance data logged by a single meter. Data is recorded for each observation period. The worksheets contain percentages of non-compliant EN50160 measurements such as Power Frequency, Supply Voltage Magnitude, and Flicker.

The EN50160_General template uses data from these fourteen EN50160 log files:

EN50160 Vlt Dp1 to EN50160 Vlt Dp5 (supply voltage dips)

EN50160 Ovrvlt1 to EN50160 Ovrvlt3 (temporary overvoltages)

EN50160 Vunbal (supply voltage unbalance)

EN50160 Hrm Vlt (harmonic voltage)

EN50160 Ihm Vlt (interharmonic voltage)

EN50160 Frq/Mg (frequency and magnitude)

EN50160 Flicker (flicker)

EN50160 Intrp (short- and long-term interruptions)

##### EN50160_Summary

Use the EN50160_Summary template to create a report containing comprehensive analysis of the entire EN50160 compliance data logged by multiple meters. The compliance summary is based on the EN50160 limits for each observation period: each default EN50160 measurement indicates a pass with a Y (yes), or a did not pass with an N (no), on the compliance test.

The EN50160_Summary template uses data from the same log files as the EN50160_General template.

An observation sheet is generated for every observation period; however, it is hidden by default. You can access specific observation sheets by unhiding the specific sheet for the generated report in Microsoft Excel (Format > Sheet > Unhide > “observation sheet”).

##### EN50160_Mains_Signal

Use the EN50160_Mains_Signal template to create a report for signal line frequency statistics for a single meter, for each observation period.

The EN50160_Mains_Signal template uses data from the EN50160 MSignal log.

#### IEC 61000-4-30

IEC 61000-4-30 are power quality standards that define measurement methods for 50 Hz and 60 Hz power quality instruments. Three IEC 61000-4-30 templates are available in :

##### IEC61000-4-30_10Min

Use this template to create the IEC 61000-4-30 report based on a 10-minute interval sampling period.

##### IEC61000-4-30_2Hr

Use this template to create the IEC 61000-4-30 report based on a 2-hour interval sampling period.

##### IEC61000-4-30_3Sec

Use this template to create the IEC 61000-4-30 report based on a 3-second interval sampling period (i.e., 150 cycles for 50 Hz; 180 cycles for 60 Hz).

#### Waveforms

To generate a report from logs that contain voltage and current waveform data, select <no template> and set the Log to Waveforms. See "Creating a Report Without a Template" on page 1 for details.

After the report is generated, click the tab named for the waveform query to view.

The left pane contains timestamps that link to the waveform chart on the right pane. Click a timestamp to view the waveform.

To view the waveforms for each current and voltage phase, click Show Complete on the Waveforms toolbar. Use the magnifying glass icons to zoom in or zoom out.

#### Custom templates

Contact if you require other specialized report templates.

### Creating a report without a template

You can use to copy raw data from a database and paste it into Microsoft Excel:

In the main window, select Manage Reports, then click New.

Fill in the Report Name box, select <No Template>, then click Next.

Click New to create a source/log query for the report. Set the Query Properties:

Name: New queries are automatically named in a sequential manner, but you can also rename them as required.

Source: Select the source of the query (for example, power meter).

Log: Choose the data log that you want to copy raw data from.

Database: <SQL> is the default setting. To change the database source, select one from the list, or click More.

If a TOU schedule is required, select Apply TOU Schedule to database queries, then select one from the list, or click Manage to create one.

To add another query, click New, then set the query properties as described above.

When you have added and configured each of your queries, click Next.

Configure the report options as described in the section, "Step 3: Set Up the Report Options" on page 1.