Question:
- What is the structure of the measurement data in CSV format for Fluke 6500-2 appliance testers?
Answer:
The data for the Fluke 6500-2 appliance tester (firmware 1.8.3) is structured as following:
A line always has the same number of elements, these are in fixed positions.
The comma is the separator between the individual elements.
When the CSV file is transferred to Excel, the following columns result:
The first columns contain information about the site, location, customer, user, date, Auto-test and visual test:
|
Column A |
Column B |
Column C |
Column D |
Column E |
Column F |
Column G |
Column H |
Column I |
Column J |
Column K |
Column L |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
memory location |
SITE | Customer name | USER | User code | DATE | Date | APP | Appliance No. | Auto test (AUTO) or single test(DIAG) |
VISUAL | Result of visual test (PASS) |
The individual measurements are listed in the following order with 3 repetitions, whether they were carried out or not:
- Protective bonding resistance RPE (4x),
- Insulation resistance RISO (4x),
- Substitute leakage current IEA (1x), touch leakage current IB(4x),
- Apparent power, load current, protective conductor current,
- IEC lead test, RCD-test and remark
Example of a result block for Protective Bonding Resistance RPE (BOND):
| Column M | Column N | Column O | Column P | Column Q | Column R | Column S | Column T | Column U | Column V | Column W | Column X | Column Y | Column Z | Column AA | Column AB |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BOND | Test current RPE 25A (HIGH) or 200mA (LOW) | Counter RPE test (1) | Measurement result no. 1 with unit, empty if no measurement was done | BOND | Test current RPE 25A (HIGH) or 200mA (LOW) | Counter RPE test (2) | Measurement result no. 2 with unit, empty if no measurement was done | BOND | Test current RPE 25A (HIGH) or 200mA (LOW) | Counter RPE test (3) | Measurement result no. 3 with unit, empty if no measurement was done | BOND | Test current RPE 25A (HIGH) or 200mA (LOW) | Counter RPE test (4) | Measurement result no. 4 with unit, empty if no measurement was done |
Example of a result block for Insulation Resistance RISO (INSU):
| Column AC | Column AD | Column AE | Column AF | Column AG | Column AH | Column AI | Column AJ | Column AK | Column AL | Column AM | Column AN | Column AO | Column AP | Column AQ | Column AR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Test voltage Riso (INSU 250V) or (INSU 500V) |
Class (I) or (II) | Counter Riso Test (1) | Measurement result no. 1 with unit, empty if no measurement was done | Test voltage Riso (INSU 250V) or (INSU 500V) |
Class (I) or (II) | Counter Riso Test (2) | Measurement result no. 2 with unit, empty if no measurement was done | Test voltage Riso (INSU 250V) or (INSU 500V) |
Class (I) or (II) | Counter Riso Test (3) | Measurement result no. 3 with unit, empty if no measurement was done | Test voltage Riso (INSU 250V) or (INSU 500V) |
Class (I) or (II) | Counter Riso Test (4) | Measurement result no. 4 with unit, empty if no measurement was done |
Example of a result block for Substitute leakage current ISUB (SUBST) and Touch current IC (CONTACT):
| Column AS | Column AT | Column AU | Column AV | Column AW | Column AX | Column AY | Column AZ | Column BA | Column BB | Column BC | Column BD | Column BE | Column BF | Column BG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SUBST | Class (I) or (II) | Measurement result of sub. leakage current with unit, empty if no measurement was done | CONTACT | Counter touch leakage test (1) | Measurement result no. 1 with unit, empty if no measurement was done | CONTACT | Counter touch leakage test (2) | Measurement result no. 2 with unit, empty if no measurement was done | CONTACT | Counter touch leakage test (3) | Measurement result no. 3 with unit, empty if no measurement was done | CONTACT | Counter touch leakage test (4) | Measurement result no. 4 with unit, empty if no measurement was done |
Example of a result block for Apparent Power (LOAD), Load current (LOAD CURRENT), Earth Leakage current (LEAKAGE):
| Column BH | Column BI | Column BJ | Column BK | Column BL | Column BM |
|---|---|---|---|---|---|
| LOAD VA | Measurement result of apparent power with unit, empty if no measurement was done | LOAD CURRENT | Measurement result of load current with unit, empty if no measurement was done | LEAKAGE | Measurement result of earth leakage current with unit, empty if no measurement was done |
Beispiel eines Ergebnisblocks Kaltgeräteleitungsprüfung (IEC), RCD-Prüfung und Bemerkung :
| Column BN | Column BO | Column BP | Column BQ | Column BR | Column BS | Column BT | Column BU | Column BV | Column BW | Column BX |
|---|---|---|---|---|---|---|---|---|---|---|
| IEC FUSE |
Result of IEC lead test continuity L-N |
IEC BOND | Measurement result of IEC lead earth bond resistance with unit, empty if no measurement was done | IEC INSU | Measurement result of IEC lead insulation resistance with unit, empty if no measurement was done | Test current RCD-test (RCD 15mA, RCD 30mA or RCD 150mA) | Angle at RCD-Test (0 DEG, 180 DEG) | Measurement result RCD trip time with unit, empty if no measurement was done | NOTE | Comment entered for the test |