Arteche_kVAR_Calculator_Tool_10-1122 (1).xlsx

	A	B	C	D	E	F	G	H	I	J
1										@dropdown
2		Arteche Reactive Power and Harmonic Resonance Point Calculator
3
4
5			(1) ENTER Transformer Data
6			Rating			2500	2,500	kVA
7
8			V primary			13800	13,800	Volts
9
10			V secondary			480	480	Volts
11
12			Impedance			575	5.75	%
13
14			Frequency			60	60	Hz
15
16			(2) ENTER Load Data
17			System load			1508	1508	kW
18
19			Initial Power Factor			75	0.75	41.4º
20
21			Target Power Factor			95	0.95	18.2º
22
23
24			(3) RESULTS
25			Active Power (P)=		1508	kW
26			Total Power (S1)=		2010.7	kVA (without Capacitors)			9604.97
27			Reactive Power (Q1)=		1329.9	kVAR (without Capacitors)
28			Load Current=		2418.5	Amps (without Capacitors)
29
30			Required kVAR		834	(Qcap)
31
32			Total Power (S2)=		1587	kVA (with Capacitors)
33			Reactive Power (Q2)=		495.7	kVAR (with Capacitors)
34			Load Current=		1909.3	Amps (with Capacitors)
35			Savings=		423.3	kVA
36			Voltage Boost=		489.2	(1.92%)
37
38
39	www.artechepq.com
40			Power Triangle Graph
41			P	Qcap
42			1508	834.3
43
44			Qi	Qf	Si	Sf
45			1329.9	495.7	2010.7	1587
46
47			P	x	y	Qi	x	y
48			1	0	10	1	1508	0
49			2	1508	10	2	1508	1329.9
50
51			Qf	x	y	Si	x	y
52			1	1508	0	1	0	0
53			2	1508	495.7	2	1508	1329.9
54
55			Sf	x	y	Qcap	x	y
56			1	0	0	1	1558	1329.9
57			2	1508	495.7	2	1558	495.7
58
59			System Calculations
60			Xt=	0.0052992	ohms
61			Lt=	14.05656457	uH
62
63			Freq=	433.14	Hz
64			h=	7.22	Harmonic
65
66			Voltage boost=	489.2	Volts	1.92%
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100