Transformer Sizing and Selection.xlsx

	A	B	C	D	E	G	H
1
2	Transformer Sizing and Selection
3
4	S.NO	Load Type	Rating ( KW)		Noted
5	Step-01	Lighting load	30		DF		0.8
6		HVAC load	50		P.F		0.85
7		Machinery load	70		Transformer Efficiency		0.95
8		Other equipment load	20
9		Total Load	170
10	Step 2	Add Extra Load for Future Expansion	0.15	15%
11	Formula	Total Load with Future Expansion (kW) = Total Connected Load x (1 + Future Expansion Percentage)
12		Total Load with Future Expansion (kW)	195.5
13	Step 3	Calculate the Maximum Demand Load		DF	0.8
14	Formula	Maximum Demand (kW) = Total Load with Future Expansion (kW) x Demand Factor
15		Maximum Demand (kW)	156.4	P.F	0.85
16	Step 4:	Calculate the Maximum Demand in kVA
17		Formula: Maximum Demand (kVA) = Maximum Demand (kW) / Power Factor (PF)
18		Maximum Demand (kVA)	184
19				Transformer Efficiency		0.95
20	Step 5:	Determine the Transformer Capacity with Efficiency Considerations
21	Formula:	Required Transformer Capacity (kVA) = Maximum Demand (kVA) / Transformer Efficiency
22		Required Transformer Capacity (kVA)	194
23	Step-6	Select the Appropriate Transformer Size
24		Select the closest standard transformer size that can handle the calculated load.
25		The calculated transformer capacity is 194 kVA. The next standard size available is 250 kVA.
26		Thus, a 250 kVA transformer would be chosen.
27
28
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