Satec PM130 PLUS Series - Exporting Files in Excel Format

Chapter 8 Retrieving and Storing Files Exporting Files
PM130 PLUS Powermeter Series_Installation Operation and Manual 140
In COMTRADE format, each waveform event is recorded into a separate file.
PQDIF file names are followed by a timestamp of the first event recorded to the file, and may look like
follows:
12KVSUB_20040928T133038.pqd.
Automatic Converting
PAS allows you to automatically convert data logs into PQDIF format at the time you upload data from
your devices via the Upload Scheduler.
To automatically convert your data log tables into PQDIF format:
1. Open the Upload Scheduler.
2. Highlight a desired device site with the left mouse button, and then click on the Export button.
3. Check the Enabled box for a data log or a waveform log table you want to automatically convert
at the upload time.
4. Highlight the Record to… row for the selected table and click on the Browse button.
5. Select a folder where you want to store converted files, type in the converted file’s name, select
a desired output file format, and then click on Save.
6. Repeat the same for all tables you wish to be converted.
7. Click OK.
8.4.3 Exporting Files in Excel Format
PAS allows you to convert data tables into the Microsoft Excel workbook format, either manually, or
automatically while retrieving data from your meters via the Upload Scheduler.
To store files in Excel format, follow instructions in the previous section and select Excel Workbook as
the output file format.
The first row of the Excel table lists data names (see Appendix D) and the second row provides data codes,
which identify recorded data points (see Modbus communications guide for data codes) that may be useful
for automated table processing.
Each table row is provided with the device identifier that you can define in the meter database (see Creating
a New Site for your Meter).