Skip to content

Harmonic Correction System — Software Operation Manual

Jump to bottom
GENY edited this page Jun 1, 2026 · 1 revision

Harmonic Correction System — Software Operation Manual

Version: v1.0.0
Target Audience: G-Type Test Bench Operators
Last Updated: 2026-06-01

Table of Contents

  1. Software Overview
  2. Installation and Startup
  3. Main Interface Overview
  4. Initial Setup
  5. Core Workflow
  6. Menu Reference
  7. Frequently Asked Questions

1. Software Overview

1.1 Purpose

This software is designed for G-Type Test Bench Harmonic Correction. When a test bench outputs harmonics, deviations may exist between the actual measured values and the target setpoint values. This software imports measured Excel data, automatically calculates correction coefficients, and generates corrected transmission parameters so that subsequent tests produce outputs closer to the target values.

1.2 Core Features

Feature Description
Bench Management Add, edit, and delete test bench information (ID, name, range, communication method)
Scheme Management Create multiple correction schemes per bench, with configurable voltage/current references and tolerance (optional)
Excel Import Read harmonic setpoint and measured values from Excel files (.xls format)
Correction Calculation Automatically compute correction coefficient K, generate new voltage/current send values and phase send values
Result Export Export correction results to Excel files
Operation Log Automatically record all operations (import, correction, export, errors); viewable and exportable

1.3 Supported Harmonic Range

  • Harmonic Order: 2–31 (fundamental 1st order excluded)
  • Amplitude: 0%–40%
  • Phase Angle: –180° to 180°

2. Installation and Startup

2.1 System Requirements

Requirement Details
Operating System Windows 7 / 10 / 11 (32-bit or 64-bit)
Dependency sqlite3.dll must be in the same directory as HarmonicCorrector.exe
Disk Space Approximately 5 MB

2.2 File List

Harmonic correction/
├── HarmonicCorrector.exe    ← Main executable, double-click to run
├── sqlite3.dll              ← Database engine
├── HarmonicCorr.db          ← Database file (auto-created on first run)
└── data/                    ← Data folder (optional)

2.3 Starting the Application

Double-click HarmonicCorrector.exe to launch. On first run, the software automatically creates the database and inserts default bench and scheme entries.

3. Main Interface Overview

After launch, the main interface contains the following areas:

┌─────────────────────────────────────────────────────┐
│  Menu Bar  File  Management  Help                    │
├─────────────────────────────────────────────────────┤
│  [Dashboard]  [Correction]  [Log]       ← 3 tabs      │
├─────────────────────────────────────────────────────┤
│                                                     │
│        Content area of the active tab                │
│                                                     │
├─────────────────────────────────────────────────────┤
│  Status Bar  Harmonic Correction System | Status     │
└─────────────────────────────────────────────────────┘

3.1 Tab 1: Dashboard

Displays a summary of the software status:

Item Description
Database Status Shows "Connected" or "Disconnected"
Database Path Current database file location
Data Directory Application working directory
Bench Count Number of registered test benches
Scheme Count Total number of created schemes
Quick Guide Brief operation steps

A "Reinitialize Database" button at the bottom resets to default settings (use with caution — clears all existing data).

3.2 Tab 2: Correction

This is the core workspace, laid out as follows:

┌──────────────┬──────────────────────────────────────┐
│  TreeView    │  StringGrid (15-column data table)    │
│  (Bench/     │                                      │
│   Scheme     │  ┌──────────────────────────────┐    │
│   tree)      │  │ # │Harmonic│V_Set│V_Meas│... │    │
│              │  ├───┼─────── ─┼─────┼──────┼───┤    │
│  ├ 526001    │  │ 1 │   2    │ 100 │ 98  │... │    │
│  │ ├ Standard│  │ 2 │   3    │ 100 │ 97  │... │    │
│  │ └ HighPrec│  └──────────────────────────────┘    │
│  └ 526002    │                                      │
│              │  [Import Excel][Calculate][Export]    │
└──────────────┴──────────────────────────────────────┘

Left — TreeView: Select a bench and scheme. A scheme must be selected before importing data.

Right — Data Table: Displays the imported harmonic data in 15 columns:

# Column Description
1 Harmonic Order Harmonic order (2–31)
2 V_Set% Voltage setpoint
3 V_Meas% Voltage measured value
4 V_Corr_K Voltage correction coefficient K
5 V_Send% Corrected voltage send value
6 I_Set% Current setpoint
7 I_Meas% Current measured value
8 I_Corr_K Current correction coefficient K
9 I_Send% Corrected current send value
10 Phase_Set° Phase setpoint
11 Phase_Meas_RD° Measured phase RD
12 Phase_Dev° Phase deviation Qm
13 Phase_Send° Corrected phase send value Qns
14 Phase_OK? Whether phase is within tolerance
15 Iters Iteration count

Bottom Buttons:

Button Function
Import Excel Open a .xls file and read harmonic data
Calculate Execute the correction algorithm; compute K coefficients and new send values
Export Excel Export current results to a .xls file

3.3 Tab 3: Log

Displays all operation records in a list:

Column Description
Time Operation timestamp
Bench Bench ID
Scheme Scheme ID
Harmonic Harmonic order
Action Operation type (CORRECTION / EXPORT / ERROR)
Result Operation result

Bottom buttons:

Button Function
Clear Log Delete all log records
Refresh Log Reload log entries from the database

4. Initial Setup

Before using the correction features, benches and schemes must be configured.

4.1 Bench Management

Open the Bench Manager via Management → Bench Manager.

Adding a Bench

  1. Click the Add button
  2. In the dialog, enter the following:
    • Bench ID (e.g. 526001)
    • Bench Name (e.g. G-Type Single-Phase Bench)
    • Voltage Range (V, default 220)
    • Current Range (A, default 5)
    • Communication Method (RS232 / RS485 / TCP, default RS232)
  3. Click OK to save

Editing a Bench

  1. Select the bench in the list
  2. Click the Edit button
  3. Modify the information and click OK

Deleting a Bench

  1. Select the bench in the list
  2. Click the Delete button
  3. Confirm deletion

⚠️ Warning: Deleting a bench also removes all associated schemes and correction records. This action cannot be undone.

4.2 Scheme Management

Open the Scheme Manager via Management → Scheme Manager.

Adding a Scheme

  1. Select the target bench from the top dropdown (or keep "All")
  2. Click the Add button
  3. Enter scheme information:
    • Scheme Name (e.g. Standard)
    • Scheme Description (e.g. Default correction parameters)
    • Voltage Reference (%, default 100)
    • Current Reference (%, default 100)
    • Fundamental Phase Angle (°, default 0)
    • Target Tolerance (%, default 1)
  4. Click OK to save

Editing / Deleting a Scheme

Same steps as bench management.

5. Core Workflow

The complete correction workflow consists of 4 steps:

Select Scheme → Import Excel → Calculate → Export Results

Step 1: Select a Scheme

  1. Switch to the Correction tab
  2. Expand the target bench in the left tree view
  3. Click to select a scheme (the scheme name will be highlighted)
  4. The status bar will display "Scheme selected: xxx"

💡 If no benches or schemes are visible, add them first via the Management menu.

Step 2: Import Excel

Excel File Format Requirements

The Excel file must be in .xls format (Excel 97-2003 Workbook), with the following column structure:

Column Content Example Required
A Harmonic Order 2, 3, 4, ..., 31 ✅ Yes
B Voltage Setpoint (%) 100, 50, 30 ✅ Yes
C Current Setpoint (%) 100, 80, 60 ✅ Yes
D Voltage Measured (%) 98.5, 48.2 Optional
E Current Measured (%) 97.3, 79.1 Optional
F Phase Setpoint (°) 0, 15, 30 Optional
G Phase Measured RD (°) 2.3, 14.8 Optional

📌 Data begins at row 4 (the first 3 rows can be headers or comments and will be automatically skipped).

Operation Steps

  1. Click the Import Excel button
  2. Select a .xls file in the file dialog (.xlsx is not supported)
  3. The software automatically reads the data and displays it in the table
  4. The status bar shows the import result (e.g. "Successfully imported 20 records")

⚠️ If prompted with "No valid harmonic records", check:

  • The file is in .xls format (not .xlsx)
  • Data starts from row 4
  • Harmonic orders are within the 2–31 range

Step 3: Calculate Correction

Click the Calculate button. The software automatically performs the following:

  1. Voltage Amplitude Correction: Compute voltage correction coefficient K = V_meas / V_set; derive new send values
  2. Current Amplitude Correction: Compute current correction coefficient K = I_meas / I_set; derive new send values
  3. Phase Correction: Normalize RD angles; compute phase deviation and corrected phase send values
  4. Convergence Check: Verify amplitude deviation < 0.5% and phase deviation < 1°
  5. Iterative Correction: If not converged, iterate up to 5 times

After calculation:

  • The "V_Send%", "I_Send%", and "Phase_Send°" columns are populated
  • Data is automatically saved to the database
  • A "CORRECTION" record is added to the operation log

Step 4: Export Results

  1. Click the Export Excel button
  2. Choose a save location and file name
  3. The exported Excel file contains all 15 columns of data (including correction coefficients, send values, etc.)
  4. The file can be viewed, printed, or shared in Excel

6. Menu Reference

6.1 File

Menu Item Shortcut Function
New DB — Create a new empty database file
Open DB — Open an existing database file (switch data source)
Close DB — Close the current database and revert to the default
Export All — Export all correction records from the database to Excel
Exit — Exit the application

6.2 Management

Menu Item Function
Bench Manager Open the Bench Manager window
Scheme Manager Open the Scheme Manager window

6.3 Help

Menu Item Function
About Display software version and description

7. Frequently Asked Questions

7.1 Excel Import Fails

Symptom: Message "No valid harmonic records" or file cannot be opened.

Solution:

  1. Ensure the file is in .xls format (Excel 97-2003), not .xlsx or .xlsm
  2. If you only have a .xlsx file, open it in Excel and choose File → Save As → Excel 97-2003 Workbook
  3. Ensure data starts from row 4
  4. Ensure column A (harmonic order) is within the 2–31 range

7.2 Application Startup Error

Symptom: Prompt indicating sqlite3.dll is missing.

Solution:

  1. Confirm that sqlite3.dll is in the same directory as HarmonicCorrector.exe
  2. If missing, copy the file from the installation package

7.3 Unable to Select a Scheme

Symptom: The left tree view shows no benches or schemes.

Solution:

  1. Add a bench via Management → Bench Manager
  2. Add a scheme via Management → Scheme Manager
  3. Switch back to the Correction tab to refresh the tree view

7.4 Correction Results Are Unsatisfactory

Possible Causes:

  1. Measured value deviation is too large (beyond correction range)
  2. Maximum iteration count (5) reached without convergence

Suggestions:

  1. Verify the measured data is correct
  2. Run correction multiple times (measure again with the corrected send values, then correct again)
  3. Check test bench equipment connections and calibration

7.5 Database Corruption

Symptom: Database-related errors on startup or during operation.

Solution:

  1. Close the application
  2. Delete the HarmonicCorr.db file
  3. Restart the application (a new database will be created automatically)
  4. Re-add benches and schemes

Appendix: Excel Template Example

Below is a standard Excel input file example (first few rows):

Row A B C D E F G
1 Harmonic Correction Test Data
2 Test Bench: 526001
3 Harmonic Order V_Set% I_Set% V_Meas% I_Meas% Phase_Set° Phase_Meas_RD°
4 2 100 100 98.5 97.3 0 2.3
5 3 80 80 79.2 78.8 15 14.8
6 4 60 60 58.7 58.1 30 31.5
7 5 40 40 39.1 38.6 45 44.2
... ... ... ... ... ... ... ...
34 31 10 10 9.5 9.2 60 58.7

💡 The first 3 rows can contain any content (headers, descriptions, etc.). The software automatically skips them. Data reading begins at row 4.

This document is intended for end users and follows the actual operation workflow, covering everything from installation to the complete correction process. For questions, please contact the software maintainer.

Clone this wiki locally