Load Loss and Imedance Calculation 3 phase Transformer.xlsx

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q	R	S	T	U	X	AA	AB	AC	AD	AE	AF	AG	AH	AJ	AK	AL	AM	AN	AO	AP	AQ
1		HV Load Loss CALCULATION
2	Winding	Tap NO	IU1N	1V1N	1W1N	AVG Resistance @ 39 degree C	R @ 75 degree C	Current	LOSS ( In WATT ) @ 39	LOSS ( In WATT ) @ 32	LOSS ( In WATT ) @ 75	Tap NO	Volt	Total Calculated Load Loss @ 75 C	Measured Loss	Stray Loss @ 32 C	Stray Loss @ 75 C	Impedance Volt	% Z Calculated	Remarks	Load Loss & Impedence									TTR Ratio in %
3	HV	1	0.07385	0.07385	0.075	0.0742	0.0840	72.17	1159.93		1312.34	1	2000	3704.10							Measured Impedence Volt					1711				Tap No.	HV VOLTAGE	LV VOLTAGE	ACTUAL RATIO	MEASURED RATIO			Ratio Error
4		2	0.19122	0.192	0.193	0.1921	0.2173	54.13	1688.36	1645.22	1910.19	2	4000	4301.95							corrected Impedence voltage					1692.971571				Tap No.	HV VOLTAGE	LV VOLTAGE	ACTUAL RATIO	1U-1N/2u-2w	1V-1N/2v-2u	1W-1N/2w-2v	(Measured-Actual)/Actual
5		3	0.54	0.5426	0.54132	0.5413	0.6124	36.09	2115.14	2061.10	2393.04	3	8000	4784.80							Applied Current					18.2				1	2000	580	1.99	1.98	1.98	1.98	0.549
6		4	1.1	1.09	1.09	1.0933	1.2370	24.06	1898.74	1850.23	2148.21	4	12000	4539.97							Measured Load Loss					14760				2	4000	580	3.98	3.985	3.984	3.985	-0.079
7		5	2	2	2.01	2.0033	2.2665	18.04	1955.90	1905.94	2212.88	5	16000	4604.64	15267	10662.36	9183.38	1711.00	10.58		corrected Load Loss at rated Current (IHR/ISC)^2*LLM					13926.5029				3	8000	580	7.96	7.978	7.977	7.977	-0.180
8		6	4.72	4.75	4.68	4.7167	5.3364	12.03	2047.80	1995.48	2316.85	6	24000	4708.61							Rated Current ( IHR )					18.04				4	12000	580	11.95	11.965	11.964	11.983	-0.163
9		7	14.5	14.5	14.4	14.4667	16.3674	7.22	2262.37	2204.57	2559.62	7	40000	4951.38																5	16000	580	15.93	15.951	15.949	15.968	-0.148
10		8	42	42	42	42.0000	47.5182	4.37	2406.21	2344.74	2722.35	8	66000	5114.11							Tap Position	1	2	3	4	5	6	7	8	6	24000	580	23.89	23.93	23.92	23.94	-0.163
11		LV Loss CALCULATION																			Rated Current ( HV )					18.04				7	40000	580	39.82	39.87	39.86	39.88	-0.130
12	LV	S.NO	IU1N	1V1N	1W1N	AVG Resistance Per phase @ 39 degree C	Resistance Per phase @ 75 degree C	Current ( A)	LOSS ( In WATT )@39		LOSS ( In WATT )@75										Rated Current ( LV )					497.7				8	66000	580	65.70	65.85	65.79	65.87	-0.228
13		1	0.0084591	0.00853995	0.008604	0.0085	0.0097	497.70	2114.00		2391.76										Avg Resistance ( HV )					2
14																					Avg Resistance ( LV )					0.0085
15																					Copper loss I^2R CLh ( HV )					1955.00
16																					Copper loss CLl ( LV )					2114
17																					Total copper loss I^2R ( CLh+ CLl)					4069.00
18																					Total copper loss I^2R ( CLh+ CLl) at Amb Temp. 32 C					3965.047445
19																					Measured Load Loss ( LLM )					14760
20																					Stray Loss ( LLC-TCL)					10691.00
21																					%Z ( VC/Vr)x100					10.69375
22																					Total copper Loss I^2R TCL Ref @75C					4603.613139
23																					Stray Loss @ 75 C( SL Ref= ( 235+ Tam)/(235+75)*SL					9208.054839
24																					%R(((LLC/MVA1000))100					2.78530058
25																					Load Loss (( LLref = TCL ref + SL ref )					13811.66798
26																					% XRef @ 75 C					10.33081808
27																					%Rref(((LLRef/MVA1000))100					2.762333595
28																					%Zref(((%Rref^2+%Xref^2)^0.5))					10.69375
29						,
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
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