Power_System_Calculations Design Excel sheets.xlsx

	A	B	C	D	E
1	Quick Reference Guide for Power System Calculations
2	1. Power Factor Calculation
3
4	A	B	C
5	Real Power (kW)	Apparent Power (kVA)	Power Factor
6	8	10	0.8
7
8
9	2. Transformer Efficiency Calculation
10
11	A	B	C
12	Output Power (kW)	Input Power (kW)	Efficiency (%)
13	95	100	95
14
15
16	3. Short Circuit Current Calculation
17
18	A	B	C
19	Voltage (V)	Impedance (Ω)	Short Circuit Current (A)
20	400	0.02	20000
21
22
23	4. Cable Sizing Formula
24
25	A	B	C	D	E
26	Current (A)	Length (m)	Material Constant (K)	Voltage Drop (V)	Cable Size (mm²)
27	50	100	0.017	5	17
28
29
30	5. Voltage Drop Calculation
31
32	A	B	C
33	Current (A)	Resistance (Ω)	Voltage Drop (V)
34	10	0.5	5
35	Current (A)	Resistance (Ω/km)	Length (m)	Voltage Drop (V)
36	50	0.5	100	2.5
37	6. Motor Starting Current Calculation
38
39	A	B
40	Rated Current (A)	Starting Current (A)
41	10	60
42
43
44	7. Earthing System Calculation
45
46	A	B	C	D
47	Soil Resistivity (ρ)	Length of Electrode (L)	Diameter of Electrode (d)	Resistance (Ω)
48	100	2	0.02	47.68
49
50
51	8. Harmonics Calculation
52
53	A	B	C	D
54	Fundamental Current (I1)	Harmonic Current (I3)	Harmonic Current (I5)	THD (%)
55	10	1	0.5	11.18
56
57
58	9. Reactive Power Compensation
59
60	A	B	C	D
61	Real Power (P)	Initial Power Factor (cosφ1)	Desired Power Factor (cosφ2)	Reactive Power Compensation (kVAR)
62	100	0.8	0.95	42.13
63
64
65	10. Load Flow Analysis
66
67	Load flow analysis is complex and typically requires iterative methods or specialized software. However, you can set up a simple power flow equation in Excel using Solver or VBA macros.
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