PQube® Report Writer 3.8.0
User’s Guide
The information contained in this document is subject to change without notice. POWERSIDE MAKES NO WARRANTY OF ANY KIND WITH REGARD TO
THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR USE.
Powerside shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of
this material. If you do not accept this limitation on liability, please return the product to Powerside prior to use.
If you find information in this manual that is incorrect, misleading, or incomplete, we would appreciate your comments and suggestions.
Please contact support@powerside.com for assistance or further information on our product.
Powerside® and PQube® are registered trademarks of Power Survey and Equipment Ltd. and Power Standards Lab. © 2020 Powerside. All rights
Powerside (Canada office) Powerside (U.S. office)
7850 Trans-Canada Highway 980 Atlantic Ave.
Saint-Laurent, Quebec H4T 1A5 Alameda, CA
514-333-8393 510-522-4400
www.powerside.com www.powerside.com
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 1 | 31
Visit Powerside.com for the latest manual
Contents
1. Introduction to the PQube® Report Writer ...................................................................................................... 3
2. Available Report Types ..................................................................................................................................... 3
3. Installing the Report Writer program ............................................................................................................... 4
4. Using Report Writer ........................................................................................................................................... 5
5. Write the report .................................................................................................................................................. 8
6. How to choose a pre-defined standard ............................................................................................................ 8
7. Choose a non-EN50160 standard ................................................................................................................... 10
8. Important information for all Harmonics and IEEE 519 reports ................................................................... 13
9. How to create a new standard ........................................................................................................................ 16
10. Sample EN50160 Report .................................................................................................................................. 17
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 2 | 31
Visit Powerside.com for the latest manual
1. Introduction to the PQube® Report Writer
Create Standard-based and Custom Power Quality Reports.
The PQube® Report Writer is a powerful tool that automates writing complete, ready-to-present
Microsoft Word® reports based on the data and analysis generated from the Powerside PQube. The
report organizes and formats the data collected and provides comparisons to international standards
such as EN50160¹ documenting compliance. In addition to the library of standard reports, Report Writer
can create custom reports based on user-selected thresholds, limits, coverage, etc.
Report customization is made easy and repeatable using information captured in the main Report Writer
window and inserted in the report, including photographs, as appropriate. Each report is complete and
ready for delivery.
2. Available Report Types
Standards-based reports, including EN50160
The PQube® Report Writer comes with a library of international standards, including all six versions of
EN50160. Choose a standard in the main Report Writer window to create a report based on that
standard.
Custom Reports, such as IEC 61000-3-2
Create custom reports and add new standards to the library. Simply select NEW and create a report
based on your unique criteria. Use this new standard for future reports. Note that any custom
standards report must manually copied to the PQube Report Writer Standards folder with the installation
of a new version of the Report Writer program.
Energy, Harmonics, and PQube Trends
Focused (limited) reports are available for energy usage, power readings or harmonic compliance.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 3 | 31
Visit Powerside.com for the latest manual
3. Installing the Report Writer program
System Requirements
To install the PQube® Report Writer program, you will need the following:
Microsoft® Word 2007 or later. Open Office version of Word will not work.
At least 1 GB of free RAM.
ADMIN privileges if installing in the C:\Program Files directory.
Installing the Report Writer program
It is a compressed (zipped) file so you will first need to extract (unzip) it to run the executable. A file
called “Install PQube Report Writer.exe” will be created. Double click on this to install the program. You
will get the PQube® Report Writer Setup screen.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 4 | 31
Visit Powerside.com for the latest manual
4. Using Report Writer
You must have Microsoft® Word® 2007 or later
Configuring your PQube’s Setup.ini for an EN50160 report
PQube Report Writer is now ready for use.
The PQube® Report Writer Program generates reports in Microsoft® Word®. To use this program, you
must have Microsoft Word 2007 or later. Note that Open Office version of Word will not work.
To include EN50160 requirements such as harmonics, flicker, voltage unbalance, voltage THD , 10-
sec frequency in your EN50160 report, it is important to properly configure your PQube’s Setup.ini
parameters prior to measuring and recording data. Below are the parameters which need to be enabled
in your Setup.ini file.
PQube 3: Record voltage unbalance, Record 10 second frequency, Record 10 min harmonics and
parameter, Record Flicker, Record THD, Record TDD. Note that if “Record 10 second frequency” is
enabled in your PQube 3’s Setup.ini, only averages for frequency will be reported.
PQube Classic: Trend Harmonics (10 or 15 min. intervals), Voltage THD, Voltage Unbalance, Flicker
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 5 | 31
Visit Powerside.com for the latest manual
Or click on the “EN50160 Settings” button in your PQube Configurator program and it will automatically
enable these settings for you.
Very important. Use either a comma (,) or semicolon (;) as your CSV separator for the PQube trends
output formatting in the Setup.ini file (default is set to comma). Do not use [tab]. The Report Writer
program does not recognize the use of the [tab] separator and will generate an error message.
PQube-recorded data
To create a report, import the recordings from your PQube. We recommend that you copy ALL the data
from your PQube to your computer. Or simply generate your report directly from your USB Drive or SD
card! If you don’t have physical access to the PQube, you can download the files via FTP. The Report
Writer program uses the Daily/Weekly/Monthly Trends data which can be found in the
\<year>\<month>\<day> folders. When downloading the files remotely to your computer, it is important
to maintain the same file directory structure found on your PQube.
Company Information
Enter information about your company in the main Report Writer window. The PQube® Report Writer
uses this information to prepare a Microsoft® Word® report that is correctly formatted with your
company as the preparer of the report. The PQube® Report Writer automatically remembers all your
company’s data, so you only need to enter it once.
Company’s Logo
If you want your company’s logo to appear on every report, click on Add Company Logo and select a
file that contains a picture of your logo in JPG, PNG, or GIF format. Don’t worry about the size of the
picture—the PQube® Report Writer will automatically resize it to fit.
Company’s Contact information
Fill in your company’s contact information. The PQube® Report Writer will automatically put it in the
correct locations in your report.
Company’s Website
Add your company’s website. It will appear on every page of the report. Your customer will know exactly
who prepared the report!
Customer Information
Enter information about your customer right below your company’s information. This information will
change based on the specific customer for whom the report was generated. Click the Save Customer
Information button to save the customer information for future use.
Once a customer profile has been saved, this customer’s information will be automatically available on
the customer drop-down list.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 6 | 31
Visit Powerside.com for the latest manual
To enter a new customer, choose New from the Customer drop-down list, choose a new name for this
customer, and enter the data for this customer.
Customer name, address and website
The PQube® Report Writer will automatically insert the customer’s name, address and website at the
correct locations in your report.
Customer photographs
Photographs can also be imported into Report Writer. Click on Add customer photos to add photos
and captions for the photos.
The photo files can be multiple formats with JPG being standard. The photos must be in the correct
orientation—the PQube® Report Writer will not rotate them. Report Writer will automatically resize the
photos to fit the report.
Standards-Based Reports
The PQube® Report Writer prepares a report based on your PQube’s recorded data and the
requirements of an international standard or your custom limits/threshold settings.
Choose a standard from the drop-down list on the right side of the Report Writer window.
Custom Reports
Create custom reports based on new standards or your unique requirements. From the Standard drop-
down list, choose New , and name the new standard. Thresholds, comments, and all the parameters of
the new standard can now be edited and saved for future use.
Standard Reports English, French or German
PQube® Report Writer comes ready to write reports in English, French and German.
Other Languages
Add any language is as easy as updating a text file. Copy and rename a text file (in the “Languages”
folder) and translate the phrases in the text file. The new language will be available in the Languages
menu of your PQube® Report Writer.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 7 | 31
Visit Powerside.com for the latest manual
5. Write the report
Once the data has been loaded and prepared, click on the Create Report button, and the PQube®
Report Writer will automatically launch Microsoft® Word® and start writing the report!
Choose an EN50160 standard or create your own!
You can customize your report by clicking on the
Edit Thresholds button. Note that you can only View
Thresholds for EN50160 reports.
Click Prepare to calculate
your Trends and Harmonics
coverage for your report.
SD card, USB or computer
Click Create Report to start
writing the report in MS
Word.
Choose Daily, Weekly,
Monthly or Date Range
for your report.
6. How to choose a pre-defined standard
Choose an EN50160 standard
There are six versions of the EN50160 standard built into the Report Writer program: Low Voltage,
Medium Voltage, High Voltage, and, each in a—Synchronous Connection (interconnected grid i.e.,
European grid, western U.S. grid, etc.)
—Non-synchronous Connection mode (islanded grid i.e., Azores Islands, Hawaii, Puerto Rico grid, etc.).
You have the option of excluding or including flagged data² in your EN50160 report by clicking on the
“View Thresholds…” button.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 8 | 31
Visit Powerside.com for the latest manual
This is the default setting . Dips, swells, interruptions will be “flagged,”
excluded in the report and not calculated in the measurement period.
However, if there was a continuous event and 100% of your data are flagged
or your frequency was flagged more than 20% of the measurement period,
the result will be INCOMPLETE.
Dips, swells, interruptions will NOT be “flagged” and included in the report. By
doing so, your results may yield as FAILED if the flagged data measurements
fall outside of the EN50160 limits and thresholds for frequency, voltage,
flicker, unbalance, THD.
²Flagged data is defined as IEC 61000-4-30 events such as voltage sags, swells, interruptions.
The description of the EN50160 standard is based on the characteristics of voltage at a network user’s
supply terminals: Limits and Values
EN50160 LV Synchronous Connection
Low Voltage Systems (<1 kV) limits
EN50160 LV Non-Synchronous Connection (Island)
Low Voltage Systems (<1 kV) limits
EN50160 MV Synchronous Connection
Medium Voltage Systems (1 kV —- 36 kV) limits
EN50160 MV Non-Synchronous Connection (Island)
Medium Voltage Systems (1 kV —- 36 kV) limits
EN50160 HV Synchronous Connection
High-Voltage Systems (36 kV —- 150 kV) limits
EN50160 HV Non-Synchronous Connection (Island)
High-Voltage Systems (36 kV —- 150 kV) limits
Click on the drop-down list to select from one of the EN50160 standards.
Thresholds, limits, parameters are pre-defined and cannot be edited (grayed out). To view the
thresholds, click on the View Thresholds button.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 9 | 31
Visit Powerside.com for the latest manual
The first screen that appears is your “General” settings for the EN50160 standard . Here you’ll select
what parameters are included in your report. To get more details, click on each tab to display the
EN50160 defined limits and thresholds for each individual parameter. Note that the limits and thresholds
are pre-defined per EN50160 standards and cannot be edited.
You have the option to EXCLUDE or INCLUDE flagged data² in your report.
- Exclude flagged data may lower the coverage and result in INCOMPLETE. Check the box.
- Include flagged data may result in FAILED when there are many events. Uncheck the box.
7. Choose a non-EN50160 standard
In addition to EN50160 compliance report, the PQube® Report Writer program comes preloaded with
other types of reports to help you understand and analyze your power.
PQube Report Writer User’s Guide Manual Rev 3.8.0.2 P a g e 10 | 31
Visit Powerside.com for the latest manual