CTA Remote Excel File Loader

Version 4.51

The CTA Remote Excel File Loader is used to:

- prepare and edit tests with Microsoft Excel on yo
- communicate with the CT Analyzer
- import CT Analyzer report files (*.xml) into Micro
- upload/download tests to and from the CT Analy
- prepare customer-specific test reports
- develop test automation under VBA.

The CTA Remote Excel File Loader performs re

can be extended further to a customer-specific rep
TEST button creates a new empty worksheet (XM
Help
As many test reports as required can be combined
worksheets, the button LOAD REPORT loads a re
button CHANGE SETTINGS to define or change t
automatically transfer the test settings to the CT A
CT Analyzer test is finished, the data are read fro
Excel worksheet.

Post-processing of the results is easy, since the re

numbers. In a separate blank worksheet or custom
of the OMICRON pre-made worksheets using Mic
OMICRON worksheets are updated, Microsoft Ex
this method, it is possible to create customer-spec
applications.

Sheet is password protected with "CTAnalyzer"

el File Loader is used to:
s with Microsoft Excel on your computer
e CT Analyzer
eport files (*.xml) into Microsoft Excel
s to and from the CT Analyzer
ecific test reports
on under VBA.

el File Loader performs remote-controlled tests with the CT Analyzer. The tool
r to a customer-specific report tool for the CT Analyzer. Clicking the NEW
new empty worksheet (XMLData(x)) for one test report.

s required can be combined to one customer-specific test report. In the

LOAD REPORT loads a report file created with the CT Analyzer. Use the
INGS to define or change the test settings. Use the button START TEST to
he test settings to the CT Analyzer, and to start the test. Once the
shed, the data are read from the CT Analyzer and loaded into the Microsoft

results is easy, since the results are converted into Microsoft Excel-compatible
e blank worksheet or customer-specific test report, you can reference to the data
made worksheets using Microsoft Excel formulas. When the data in the
are updated, Microsoft Excel also updates the customer-made worksheets. By
ble to create customer-specific Microsoft Excel templates for different

CTAnalyzer"
TEST SETTINGS:
Location: \\PT. KPJB\2A\R\
Company:
Country:
Station: PT. KPJB

Object: \\11820910\1\1S1-1S2\
Manufacturer:
Type:
CT Serial Number: 11820910

Rated primary current I-pn: 2000.0A

Applied standard: IEC 60044-1
Class: 5P
FS:
ALF: 20.0
Kssc:
f: 50.0Hz
Tmeas: 25.0°C
Burden designation:
Rated burden: 40.0VA cosphi 0.8
Low rated burden: ? ?
High rated burden: ? ?
Operating burden: 40.0VA cosphi 0.8
Ts:
Tp:
Duty:
t1:
t2:
tfr:
Comment:

General test information Assessments

Used test settings Burden test
Comment Residual Magnetism Test
TEST RESULTS:

General test information:

Test device: CT-Analyzer

Device Serial No.: QH792Q
Date/Time: 2019-09-03, 14:37:09
Test language: English
Status info: Test successful
Error type: n/a
Error number: 0
Error location: 0
Error Info Text:

Overall Assessment: OK

Used test settings:

Location: \\PT. KPJB\2A\R\

Company:
Country:
Station: PT. KPJB

Object: \\11820910\1\1S1-1S2\
Manufacturer:
Type:
Serial number: 11820910

Rated primary current I-pn: 2000.0A

Applied standard: IEC 60044-1
Class: 5P
FS:
ALF: 20.0
Kssc:
f: 50.0Hz
Tmeas: 25.0°C
Burden designation: ? ?
Rated burden: 40.0VA cosphi 0.8
Low rated burden:
High rated burden:
Operating burden: 40.0VA cosphi 0.8
Ts:
Tp:
Duty:
t1:
t2:
 tfr:

Comment:

Assessments: Auto. Manual

ALFi: OK ?
Accuracy: OK ?
Current ratio error (ε): OK ?
Phase error (∆φ): OK ?
Composite error(εc): OK ?
RCF: n/a ?

Burden test:
Status info:
Error type:
Error number:
Error location:
Results:
Overload:
Test current:
Vmeas:
Z:

Residual Magnetism Test:

Status info:
Error type:
Error number:
Error location:
Results:
Residual Flux:
Residual Magnetism:

Primary Resistance Test:

Status info:
Error type:
Error number:
Error location:
Test current:
Results:
I-DC:
Tmeas:
 Tref:

Resistance test:
Status info: Test successful
Error type: n/a
Error number: 0
Error location: 0
Test current: 1.0A
Results:
I-DC: 1.0156A
Tmeas: 25.0°C
Tref: 75.0°C

Excitation test:
Status info: Test successful
Error type: n/a
Error number: 0
Error location: 0
Results:
Overload: No
Knee Points: 60044-1: V-kn: 964.51V
V-kn 2:
60044-6: V-kn: 911.11V
V-kn 2:
61869-2: V-kn: 964.51V
V-kn 2:
ANSI 30: V-kn: 941.36V
IEEE C57.13 V-kn: 767.35V

Ls:
Kr: 79.21%
Eddy Resistance: 30416.25Ohm

Result with rated burden:

ALF: >28,386325 28.386325
ALFi: 27.1 27.1460875
FS:
FSi:
Kssc:
Vb:
Kx:
Ktd:
Ts: 1.839s
ε peak:
 E-max:
Error indirect (εi) [%]: 0.21% 0.20912963
ε^ ac:

Excitation curve data:

Measured data Help for graph
EMF [Vs] UCrms [V] UCTrms [V] ICTrms [A]

5.4610991478 1213.1512451172 1213.1512451172 2.7381949425

5.4253869057 1205.2180175781 1205.2180175781 1.9459586143
5.3709068298 1193.1154785156 1193.1154785156 1.3361469507
5.3022742271 1177.869140625 1177.869140625 0.8844960332
5.2303957939 1161.9018554688 1161.9018554688 0.5733331442
5.1626887321 1146.8609619141 1146.8609619141 0.3736200333
5.0972399712 1132.3220214844 1132.3220214844 0.2474612147
5.0295972824 1117.2956542969 1117.2956542969 0.1691268831
4.9534106255 1100.3712158203 1100.3712158203 0.1199187413
4.8623142242 1080.1346435547 1080.1346435547 0.0889373198
4.7496056557 1055.0971679688 1055.0971679688 0.0696925372
4.6312685013 1028.8092041016 1028.8092041016 0.0597558282
4.489792347 997.3811035156 997.3811035156 0.0533106588
4.3366327286 963.3576049805 963.3576049805 0.0490591004
4.1727218628 926.9456787109 926.9456787109 0.0458321795
3.9993233681 888.4262084961 888.4262084961 0.0431449302
3.8186397552 848.2885131836 848.2885131836 0.0407554097
3.6334543228 807.1506347656 807.1506347656 0.0385769904
3.4461016655 765.5313110352 765.5313110352 0.0365132503
3.2630918026 724.8767700195 724.8767700195 0.0346525609
3.0880718231 685.9970703125 685.9970703125 0.032912191
2.9291541576 650.6944580078 650.6944580078 0.0313800797
2.7724013329 615.8727416992 615.8727416992 0.0298984293
2.6034257412 578.3358154297 578.3358154297 0.0283789597
2.4181871414 537.1860961914 537.1860961914 0.0266949199
2.2151470184 492.0819396973 492.0819396973 0.0248931907
1.9850798845 440.9739074707 440.9739074707 0.0228433795
1.7291538715 384.1214294434 384.1214294434 0.0206549708
1.4729694128 327.2115478516 327.2115478516 0.0184827391
1.2419686317 275.8960571289 275.8960571289 0.01645541
1.0479977131 232.8065795898 232.8065795898 0.0147233699
0.7590352297 168.615234375 168.615234375 0.0119940303
0.5808068514 129.0228424072 129.0228424072 0.0100946603
0.4586532712 101.8871459961 101.8871459961 0.0086113904
0.3667118251 81.462890625 81.462890625 0.00736321
0.2969812155 65.9726409912 65.9726409912 0.0063645202
0.2391934097 53.1354217529 53.1354217529 0.0054774298
0.1701532155 37.7992401123 37.8118286133 0.00444077
0.0969152525 21.5293827057 21.5380020142 0.0031332099
0.0551977418 12.2621965408 12.2681436539 0.0022817
0.0314323306 6.9827561378 6.9868149757 0.00170135
0.0178973302 3.9758892059 3.9786176682 0.00128698
0.0101911798 2.2639510632 2.2657217979 0.00098287
0.0058025201 1.2890059948 1.2901200056 0.00075585
0.00450132 1 1.0008993149 0.00067584
0.00188239 0.4181499183 0.4185832739 0.00048614
0.00107207 0.2381510437 0.2383996397 0.00037097
0.00061051 0.1356299073 0.1357735544 0.00025644
0.00034776 0.0772527233 0.0773242563 0.00016406
Reference graph data
EMF [Vs] UCrms [V] UCTrms [V] ICTrms [A]

1 1 1
Ratio test:
Status info: Test successful
Error type: n/a
Error number: 0
Error location: 0
 Results with operating burden:
Ratio: 2000.0 0.99522456
N: 2000.09 2000.087125
Phase: 3.798min
I-p: 2000.0A
Turns ratio error ε-t: 0.004%
RE @ 20*I-sn: -0.220

Results with rated burden (VA):

POWER Current ratio error in % at % of rat
VA cosPhi Data type 1%
String value -3,571
40 0.8
Float value -3.571
String value -2,370
20 0.8
Float value -2.370
String value -1,441
10 0.8
Float value -1.441
String value -0,811
5 0.8
Float value -0.811
String value
Float value
String value
 Float value
String value
Float value
String value
Float value

POWER Phase displacement in [min] at %

VA cosPhi Data type 1%
String value 115,79
40 0.8
Float value 115.79
String value 95,18
20 0.8
Float value 95.18
String value 71,92
10 0.8
Float value 71.92
String value 54,58
5 0.8
Float value 54.58
String value
Float value
String value
Float value
String value
Float value
String value
Float value

Core ratio measurement:

V0 V1 V2 I1

22.237895 22.24652 0.01111846 0.00312204

Measured points
EMF [Vs] UCrms [V] UCTrms [V] ICTrms [A]

0.17015322 37.79924 37.8118275 0.00444077

0.09691525 21.5293825 21.5380025 0.00313321
0.05519774 12.26219625 12.26814375 0.0022817
0.03143233 6.982756 6.986815 0.00170135
0.01789733 3.97588925 3.97861775 0.00128698
0.01019118 2.263951 2.26572175 0.00098287
0.00580252 1.289006 1.29012 0.00075585
0.00450132 1 1.00089931 0.00067584
0.00188239 0.41814991 0.41858328 0.00048614
0.00107207 0.23815105 0.23839964 0.00037097
0.00061051 0.13562991 0.13577355 0.00025644
0.00034776 0.07725272 0.07732426 0.00016406
Class parallelogram for IEEE C57.13 metering CT:

Defined accuracy class:

Defined ratio factor:

Measurement points according to IEEE C57.13

% of primary current Measured RCF Phase displacement [min]

Table for borders in parallelogram

Limits for 10% I-pn
x y
 Lower burden VA
Measured RCF
Phase displacement [min]

AL Error Graph:
Defined accuracy limiting error: 5% 5% Error Line

Max K-factor at rated burden: 26.62

Impedance at rated burden: 40.00 Ohm

Max K-factor at operating burden: 26.62

Impedance at operating burden: 40.00 Ohm

User-defined measurement point:

K-Value: 0.00
Maximum Burden and
60.00
Burden: 0.00 Ohm

Accuracy limiting table:

50.00
Multple of I-pn (K)

Impedance [Ω] K-Value [K]

19.378662 50.00
22.033691 45.00
25.329590 40.00
40.00
29.479980 35.00
35.034180 30.00
42.724609 25.00
54.199219 20.00
30.00
73.242188 15.00
92.041016 12.00

20.00
 30.00

110.839844 10.00
123.291016 9.00
20.00
138.671875 8.00
158.691406 7.00
185.058594 6.00
221.679688 5.00
10.00
275.878906 4.00
365.234375 3.0000
436.0352 2.50
539.0625 2.0000
0.00
703.125 1.5000 Burden
0.00 Ohm 100.00 Ohm 200.00 Ohm 300.00 Ohm impe
400.00
26.62 1.0000
 Info for current ratio calculation below:
Calculation of current error at specified burden and primary current

I-pn [A] Burden [VA] cosφ

1% 20 0 0
5% 100 0 0
10% 200 0 0
20% 400 0 0
25% 500 0 0
50% 1000 0 0
100% 2000 0 0
120% 2400 0 0
125% 2500 0 0
150% 3000 0 0
200% 4000 0 0
-
- -
1% 20 0 0.9
5% 100 0 0.9
10% 200 0 0.9
20% 400 0 0.9
25% 500 0 0.9
50% 1000 0 0.9
100% 2000 0 0.9
120% 2400 0 0.9
125% 2500 0 0.9
150% 3000 0 0.9
200% 4000 0 0.9
 Test cards:
Burden test:
Feeder / Apparatus: 2A Itest:
Phase: R Residual Magnetism test:
IEC-ID: Primary resistance test:
Resistance test:
Excitation test:
Core number: 1 Ratio test:
Tap: 1S1-1S2
Optional:

Rated secondary current I-sn: 1.0A

Core type (P/M): P Assess @ Rated B.:
Class multiplier: 1 Delta compensation:
RF: ext (Icth):
Vb: RE(20*Isn):
Ktd: Ktd calculation:
max. Rct: ? max. Rprim:
Tref: 75.0°C T Unit:

Ext. VA: Ktd Spec.:

V-al, Ek, Vk: E1, Vk1:

I-al, Ie, Ik: Ie1, Ik1:
Kx:
K:
t-al1:
t-al2:

Primary Resistance Test Ratio test

Resistance test Class parallelogram for IEEE C57.13 metering CT
Excitation test AL Error Graph
Device software version: 5.00 (449) 2018-08-07 15:28
Hardware version: 01/01/09/05/01/11
Stylesheet version: 5
File name: B:\MSISettings.xml
Remote Excel File Loader Version4,51
Name of test file: C:\Users\BPI-024\AppData\Local\Temp\XMLData(1).xml
Security key correct: Yes

Feeder/Bay: 2A
Phase: R
IEC-ID

Core number: 1
Tap: 1S1-1S2
Optional:

Rated secondary current I-sn: 1.0A

Core type (P/M): P Assess @ Rated B.:
Class multiplier: 1 Delta compensation:
RF: ext (Icth):
Vb: RE(20*Isn):
Ktd: Ktd calculation:
max. Rct: 4.842Ohm max. Rprim:
Tref: 75.0°C T Unit:

min. VA at M-cores Isn 5A: 0.0VA Ext. VA:

Enable rated burdens < 1VA: disable Ktd Spec.:

V-al, Ek, Vk: E1, Vk1:
I-al, Ie, Ik: Ie1, Ik1:
Kx:
K:
t-al1:
t-al2:

Assessment rule Value

Imeas:
Burden:

V-DC:
Rmeas:
Rref:

V-DC: 4.1231V
Rmeas: 4.0596Ohm
Rref: 4.8418Ohm

CT model used by CT Analyzer

Rp Lp Ip
P1 IST

I-kn: 0.04920A (Vc) IL

I-kn 2:
Uc
I-kn: 0.054251A Lmain
I-kn 2: RH
I-kn: 0.04920A
I-kn 2:
I-kn: 0.047098A
P2
I-kn: 0.036603A
Np Ns
Lm: 67.7545H
V-al, Ek, Vk:
I-al, Ie, Ik:
E1, Vk1:
Ie1 Ik1:

Result with operating burden:

ALF: >28,386325 28.386325
ALFi: 27.1 27.1460875
FS:
FSi:
Kssc:
Vb:
Kx:
Ktd: IEC 60044-6
Ts: 1.839s
ε peak:
E-max:
Error indirect (εi) [%]: 0.21% 0.20912963
ε^ ac:

Info for table below

ICTpeak [A] ICTrect [A] Phase Uct/Ict [°]

9.7966136932 1.3260606527 87.0682220459

6.4532217979 0.9838683009 86.2618026733
4.2534909248 0.6964377165 84.9273300171
2.7990531921 0.4752694368 82.6456832886
1.8347432613 0.3224369586 79.0659713745
1.2054648399 0.2258627564 73.9421005249
0.7898151875 0.1653001755 67.211517334
0.517844677 0.1268832684 59.356098175
0.3378169239 0.1011721566 51.0377807617
0.2189766467 0.0830171108 43.0688934326
0.1414818317 0.0697493479 36.3017158508
0.1023819819 0.0615823418 32.2644424438
0.0780121312 0.0555909388 29.526014328
0.0637718588 0.0513173603 27.7951393127
0.0553720295 0.0479423292 26.5882644653
0.0526520386 0.0450735502 25.7236919403
0.0506576411 0.0425011814 25.082452774
0.0486485213 0.0401488282 24.6511917114
0.0466313995 0.0379097089 24.3213329315
0.0446684286 0.0359086804 24.2792282104
0.0428024009 0.0340266302 24.293340683
0.0410955101 0.03237544 24.458486557
0.0394195504 0.0307795592 24.7315216064
0.0375976115 0.0291720498 25.347410202
0.0356113911 0.0273730699 26.0685882568
0.0334105901 0.0254651699 27.1866340637
0.0308910701 0.0232890099 28.6395225525
0.0280093104 0.0210194699 30.8828430176
0.0250504799 0.0187968295 33.4836616516
0.0222871304 0.0167218801 35.8397674561
0.0198913794 0.0149686504 38.185836792
0.0161083005 0.0122036301 42.3603363037
0.0135158096 0.0102725103 45.4793815613
0.0115146302 0.0087512499 47.217716217
0.0098745199 0.00747487 48.0301551819
0.0085480502 0.0064551001 48.5752792358
0.0073897899 0.00555166 48.8325767517
0.0061834399 0.00446657 45.6838531494
0.0043312502 0.0031564501 47.3249931335
0.0031371401 0.00230114 50.0430603027
0.00234685 0.0017141 53.9887237549
0.0018003 0.00129251 58.4888191223
0.00140017 0.00098304 63.609828949
0.00108309 0.00075442 68.6464767456
0.00096779 0.00067474 71.0306854248
0.00069069 0.00048669 77.1835479736
0.00052585 0.00037194 80.3200073242
0.00036332 0.00025688 81.8519210815
0.00023203 0.00016406 83.5878067017
ICTpeak [A] ICTrect [A] Phase Uct/Ict [°]

1
Current deviaton [%]

2.000 Rato Error Graph

1.000

0.000
0% 50% 100%

-1.000
 Current deviaton [
2.000 Rato Error Graph

1.000

1
1 0.000
0% 50% 100%
1

-1.000
Deviation [%]: -0.4775%
Composite error [%]: 0.49%
Polarity: OK -2.000

RCF: 1.00479844
TCF: 1.0033375
-3.000

I-pn [%]
-4.000

Phase displacem ent [min]

150.00 Phase Displacement G

100.00

50.00

0.00
0% 50% 100%

-50.00

I-pn [%]
-100.00

ent ratio error in % at % of rated current

5% 10% 20%
-1,651 -1,227 -0,907
-1.651 -1.227 -0.907
-1,126 -0,843 -0,629
-1.126 -0.843 -0.629
-0,780 -0,576 -0,437
-0.780 -0.576 -0.437
-0,543 -0,395 -0,304
-0.543 -0.395 -0.304
se displacement in [min] at % rated current
5% 10% 20%
33,58 19,08 10,79
33.58 19.08 10.79
31,11 18,44 10,78
31.11 18.44 10.78
29,79 17,69 10,78
29.79 17.69 10.78
28,28 17,32 10,69
28.28 17.32 10.69

Phase VI1 PhaseVI2

312.883525 0.0310353

Info for table below

ICTpeak [A] ICTrect [A] Phase Uct/Ict [°]

0.00618344 0.00446657 45.683855

0.00433125 0.00315645 47.324995
0.00313714 0.00230114 50.04306
0.00234685 0.0017141 53.988725
0.0018003 0.00129251 58.48882
0.00140017 0.00098304 63.60983
0.00108309 0.00075442 68.646475
0.00096779 0.00067474 71.030685
0.00069069 0.00048669 77.18355
0.00052585 0.00037194 80.320005
0.00036332 0.00025688 81.85192
0.00023203 0.00016406 83.587805
e displacement [min]

Limits for 100% I-pn

x y
Maximum Burden and K-Factor at Defined Accuracy Limit
 Burden
00 Ohm 200.00 Ohm 300.00 Ohm impedance
400.00 (Z)
Ohm 500.00 Ohm 600.00 Ohm 700.00 Ohm 800.00 Ohm
 Phase Composite error
Current deviation [%] displacement [min] [%]
-0.0968807191 29.4526255131 1.0275527239
-0.1085444912 22.7382785082 0.7500219345
-0.1078413129 16.1085408926 0.5149740577
-0.0948615819 10.2669113874 0.334610194
-0.0927795097 8.8305723667 0.2949694395
-0.083617799 5.8137904108 0.2050293535
-0.0727697164 3.8242936134 0.1450171024
-0.0689657331 3.4454948455 0.1327183098
-0.0681841671 3.3644474298 0.1301176846
-0.0649885461 3.0177115649 0.1192291528
-0.0599380136 2.5516607612 0.1043967083

-0.0968807191 29.4526255131 1.0275527239

-0.1085444912 22.7382785082 0.7500219345
-0.1078413129 16.1085408926 0.5149740577
-0.0948615819 10.2669113874 0.334610194
-0.0927795097 8.8305723667 0.2949694395
-0.083617799 5.8137904108 0.2050293535
-0.0727697164 3.8242936134 0.1450171024
-0.0689657331 3.4454948455 0.1327183098
-0.0681841671 3.3644474298 0.1301176846
-0.0649885461 3.0177115649 0.1192291528
-0.0599380136 2.5516607612 0.1043967083
 disable

disable
disable
enable
enable
enable

IEC 60044-6

°C

elogram for IEEE C57.13 metering CT

mp\XMLData(1).xml

disable
1

IEC 60044-6

°C
Additional info
sed by CT Analyzer

Lp Ip IST ICT Ls RCT

S1
(Vc) IL Iex
Uc IEddy
Lmain
RH Zb UCT
Reddy
(VB)

S2
Np Ns
Phase Uc/Ict [°] Flux remanence [Vs] L [H] UCrect [V]

87.3766784668 4.9353094101 0.5574476719 1213.1512451172

86.488822937 4.9332866669 0.8407253027 1205.2180175781
85.0860366821 4.929254055 1.2627056837 1193.1154785156
82.7513580322 4.9187736511 1.8943098783 1177.869140625
79.1345901489 4.9027519226 2.8507511616 1161.9018554688
73.9869995117 4.8771862984 4.2827367783 1146.8609619141
67.2415008545 4.8407711983 6.4537129402 1132.3220214844
59.3767433167 4.7891764641 9.7125597 1117.2956542969
51.0523948669 4.7146191597 14.6630039215 1100.3712158203
43.0795402527 4.6043357849 22.2047157288 1080.1346435547
36.3097724915 4.3996901512 33.5704269409 1055.0971679688
32.2711448669 4.0732288361 45.2351951599 1028.8092041016
29.5318908691 3.7571697235 57.5524940491 997.3811035156
27.8005065918 3.5074687004 68.0022888184 963.3576049805
26.5933132172 3.3050391674 75.3579330444 926.9456787109
25.7285251617 3.1230413914 75.9576034546 888.4262084961
25.0871391296 2.9507894516 75.3813247681 848.2885131836
24.655790329 2.7779257298 74.6878738403 807.1506347656
24.3258666992 2.6062908173 73.9008865356 765.5313110352
24.2837657928 2.4360487461 73.0514068604 724.8767700195
24.2979106903 2.2721102238 72.1471633911 685.9970703125
24.4631099701 2.1213161945 71.2767562866 650.6944580078
24.7362346649 1.971353054 70.330619812 615.8727416992
25.3522853851 1.8090764284 69.2444534302 578.3358154297
26.0736446381 1.6295750141 67.904876709 537.1860961914
27.1920108795 1.4352688789 66.300743103 492.0819396973
28.6452903748 1.2194744349 64.2606430054 440.9739074707
30.8892440796 0.9991143942 61.7349815369 384.1214294434
33.4909133911 0.8047705293 58.8000488281 327.2115478516
35.8478889465 0.6541605592 55.7258148193 275.8960571289
38.1949310303 0.5376374125 52.6860084534 232.8065795898
42.3714637756 0.3771834671 47.1207389832 168.615234375
45.4923553467 0.2816103399 42.9724006653 129.0228424072
47.2321357727 0.2227267027 39.8322143555 101.8871459961
48.0457382202 0.1808570772 37.1371917725 81.462890625
48.592086792 0.1508144438 34.7425727844 65.9726409912
48.8506088257 0.1245969534 32.3680915833 53.1354217529
45.7034034729 0.1258028746 27.5175590515 37.8118286133
47.3498802185 0.0705845132 22.375825882 21.5380020142
50.0762367249 0.0382448807 17.5949230194 12.2681436539
54.0345649719 0.0204085205 13.3934059143 6.9868149757
58.5530090332 0.0104502598 9.9413232803 3.9786176682
63.7002868652 0.0052391202 7.2785439491 2.2657217979
68.7735061646 0.0025512499 5.3573970795 1.2901200056
71.1867218018 0.00181986 4.5639843941 1.0008993149
77.447227478 0.00047183 2.7253777981 0.4185832739
80.6771697998 0.00017935 2.0387387276 0.2383996397
82.2872619629 0.00008091 1.6803956032 0.1357735544
84.078666687 0.00017935 1.4987555742 0.0773242563
Phase Uc/Ict [°] Flux remanence [Vs] L [H] UCrect [V]

1
 Rato Error Graph

50% 100% 150% 200% 40VA

250%
20VA
10VA
5VA
 Rato Error Graph

-1 60 -60
-1 60 -60
50% 100% 150% 200% 40VA
250%
-1 60 -60
20VA
10VA
5VA
+Erro
r
-Error

I-pn [%]

Phase Displacement Graph

40VA
20VA
10VA
5VA
+Erro
50% 100% 150% 200% r250%
-Error

I-pn [%]

50% 100% 120% 200%

-0,618 !-0,477 !-0,444 !-0,382
-0.618 -0.477 -0.444 -0.382
-0,426 -0,323 -0,302 !-0,249
-0.426 -0.323 -0.302 -0.249
-0,301 -0,227 -0,211 -0,174
-0.301 -0.227 -0.211 -0.174
-0,217 -0,166 -0,154 -0,127
-0.217 -0.166 -0.154 -0.127
 50% 100% 120% 200%
5,14 !3,80 !4,03 !3,28
5.14 3.80 4.03 3.28
5,18 3,19 2,90 !2,51
5.18 3.19 2.90 2.51
5,42 3,29 2,94 2,16
5.42 3.29 2.94 2.16
5,64 3,52 3,11 2,26
5.64 3.52 3.11 2.26

Phase Uc/Ict [°] Flux remanence [Vs] L [H] UCrect [V]

45.703405 0.12580288 27.51756 37.8118275

47.34988 0.07058451 22.375825 21.5380025
50.076235 0.03824488 17.5949225 12.26814375
54.034565 0.02040852 13.39340625 6.986815
58.55301 0.01045026 9.941323 3.97861775
63.700285 0.00523912 7.278544 2.26572175
68.773505 0.00255125 5.357397 1.29012
71.18672 0.00181986 4.5639845 1.00089931
77.447225 0.00047183 2.72537775 0.41858328
80.67717 0.00017935 2.03873875 0.23839964
82.28726 0.00008091 1.68039563 0.13577355
84.07867 0.00017935 1.49875563 0.07732426
0 Ohm
Calculated I-s [A]
0.0190297216
0.0499457158
0.0998921618
0.1998102665
0.249767974
0.4995818138
0.9992722273
1.1991727352
1.2491483688
1.4990246296
1.9987999201

0.0190297216
0.0499457158
0.0998921618
0.1998102665
0.249767974
0.4995818138
0.9992722273
1.1991727352
1.2491483688
1.4990246296
1.9987999201
 IEC 60044-1 Excitaton Graph
10000

1000
RMS Voltage

100

10

1
0.0001 0.001 0.01 0.1 1

0.1

0.01
RMS current

IEC 60044-6 Excitaton Graph

10000

1000
RMS Voltage

100

10

1
0.0001 0.001 0.01 0.1 1

0.1

0.01
Peak Current
 1
0.0001 0.001 0.01 0.1 1

0.1

0.01
Peak Current

IEEE C57.13 Excitaton Graph

10000

1000
RMS Voltage

100

10

1
0.0001 0.001 0.01 0.1 1

0.1

0.01
RMS Current

IEC 61869-2 Excitaton Graph

10000

1000
Rect Voltage

100

10

1
0.0001 0.001 0.01 0.1 1

0.1

0.01
RMS current
 1
0.0001 0.001 0.01 0.1 1

0.1

0.01
RMS current
ph
10000

1000

100

Meas Data
10 Ref Data
Low V Data
Knee IEC_1
1
1 10

0.1

0.01

ph
10000

1000

100

Meas Data
10 Ref Data
Low V Data
Knee IEC_6
1
1 10

0.1

0.01
 Low V Data
Knee IEC_6
1
1 10

0.1

0.01

ph
10000

1000

100
Meas Data
Ref Data
10 Low V Data
Knee ANSI 30
Knee IEEE
C57.13
1
1 10

0.1

0.01

ph
10000

1000

100

Meas Data
10 Ref Data
Low V Data
Knee IEC_2
1
1 10

0.1

0.01
 1
1 10

0.1

0.01
1
Company Name:

Company Address:

Order Number:

#NAME? #NAME? Err:504

#NAME? Err:504 #NAME? Err:504
#NAME? Err:504
#NAME? Err:504

#NAME?
I-pn: Err:504 #NAME? #NAME?
I-sn: Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 ### #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 ### #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504

#NAME? #NAME?
#NAME? Err:504 #NAME? Err:504 cos φ: Err:504 ### Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504

#NAME?
### Err:504 ### Err:504 #NAME? #NAME?
### Err:504 ### Err:504 ### Err:504 ### Err:504 ### Err:504 ### Err:504
### Err:504 ### Err:504 ### Err:504 ### Err:504
### Err:504

#NAME?
#NAME? Err:504 : Err:504 ε: Err:504 Δφ: Err:504 #NAME? ### ### Err:504
εc : Err:504

#NAME?
#NAME? Err:504
#NAME? Err:504

### Excitation curve data

10000

1000
Es / V

100

10

0.1

0.01
0.0001 0.001 0.01 0.1 1 10
le / A

Column C Row 28 Row 29 Series 2

437517717.xls Page 54 of 58
 0.0001 0.001 0.01 0.1 1 10
le / A

Column C Row 28 Row 29 Series 2

#NAME?
#NAME? Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

#NAME?
#NAME? Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

Error borders according IEC 60044-1 at % of rated current

Mult.Factor 1 5 10 20 50 100 120 200
Ratio
0.60 Error Graph 0.30
Current deviation [%]

-0.60 -0.30
12.000

10.000

8.000
100% Load

50% Load
6.000

25% Load

4.000

2.000

0.000
0 5 10 15 20 25 30 35
% I-pn

437517717.xls Page 55 of 58
Company Name:

Company Address:

Order Number:

#NAME? #NAME? Err:504

#NAME? Err:504 #NAME? Err:504
#NAME? Err:504
#NAME? Err:504

#NAME?
I-pn: Err:504 #NAME? #NAME?
I-sn: Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 ### #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 ### #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504
#NAME? Err:504
#NAME? Err:504 #NAME? Err:504

#NAME? #NAME?
#NAME? Err:504 #NAME? Err:504 cos φ: Err:504 ### Err:504
#NAME? Err:504 #NAME? Err:504 #NAME? Err:504

#NAME?
V-k30: Err:504 I-k30: Err:504 #NAME? #NAME?
V-k45: Err:504 I-k45: Err:504 ### Err:504 #NAME? Err:504 ### Err:504 #NAME? Err:504
### Err:504 ### Err:504 ### Err:504 ### Err:504
### Err:504

#NAME?
#NAME? Err:504 : Err:504 ε: Err:504 Δφ: Err:504 #NAME? ### ### Err:504
εc : Err:504 ### Err:504

#NAME?
#NAME? Err:504
#NAME? Err:504

Excitation curve data

###

10000

1000
Es / V

100

10

0.1

0.01
0.0001 0.001 0.01 0.1 1 10
le / A
Column B Row 28 Row 29 Series 2

437517717.xls Page 56 of 58
 #NAME?
#NAME? Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

#NAME?
#NAME? Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504
Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

#NAME?
Error borders according IEC 60044-1 at % of rated current
Mult.Factor 1 5 10 20 50 100 120 200
Class parallelogram
0.60 for IEEE C57.13 metering CT 0.30
-0.60 -0.30
###
### 12
at 10% I-pn

10

8
RCF

0 2 4 6 8 10 5% or 10% I- 12
pn
0
100% I-pn

Phase [min]

437517717.xls Page 57 of 58
Help:

This template is an application-specific tool extension of the CTA Remote Excel File Loader in-
tended to get a comprehensive, printable test report for all classes according IEC 60044-1, IEC
60044-6, IEC 61869-2 and IEEE C57.13 (ANSI) standards.These results are distributed over eight
worksheets.

The first section of each of those worksheets holds fields to insert your company's name and
address as well as an order number. Those fields are not write-protected and to your disposal.
All fields of the "... Test" sections, which hold test results, the "General Test Information" section
and the "Used Test Settings" section are write-protected and therefore not available for customer-
entries.The same applies to the sections "Excitation Curve Data", "Current Ratio Error in % at...",
"Phase Displacement in [min] at..." and the two charts "Excitation Curve Data" and "Ratio Error
Graph".

The cells below that are available for customer-specific calculations or data entries.

The section "Excitation Curve Data" holds a subset of the "CT Excitation Measured Data" table
from the "Report" worksheet with a maximum number up to 30 (U,I)-pairs.

The applied standard, CT's core type and accuracy class definition of the input fields on the "Re-
port" worksheet determine the curve progressions displayed in charts, the excitation tables, the
kneepoint voltages and currents, etc.

To perform measurements, select the worksheet "Data" and open the settings form by clicking
either the "Settings" button or the colored "TEST SETTINGS" area. Enter the necessary para-
meters and text in the fields of the "TEST SETTINGS" block and start the test.

To insert a company logo, or change it, respectively, click the Page Setup command from the
File pull-down menu. Go to the Header/Footer tab and click the Custom Header... button.
Position your cursor into the "Right section:" and click the Insert Picture button. Browse the
folder structure to the picture of your choice, select it and click Insert. The company logo can
then be viewed by clicking the Print Preview command from the File pull-down menu.

If you need to change the contents of protected cells, click the Protection | Unprotect Sheet
command from the Tools pull-down menu. A password is not required to remove the worksheet
protection.

Please note that you remove the worksheet protection at your own risk. OMICRON electronics
does not assume responsibility for a correct operation if you edit initially protected parameters.
The same applies if you carry out modifications at the cell-specific VBA code.