ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Excel Sheet for Wind Power Generation Design
2
3
1. Input Data
4
5
ABC
6
Wind Speed (m/s)10Enter wind speed
7
Rotor Radius (m)20Enter rotor radius
8
Air Density (kg/m³)1.225Enter air density
9
Power Coefficient (Cp)0.4Enter Cp
10
Capacity Factor (CF)0.35Enter CF
11
12
13
2. Calculations
14
15
ABC
16
Swept Area (m²)1257#ERROR!
17
Power in Wind (kW)769.7#ERROR!
18
Terbine Power Extracted (kW)307.9#ERROR!
19
Annual Energy (kWh)943948#ERROR!
20
21
22
3. Example Output
23
24
ABC
25
Swept Area (m²)1256.64Calculated
26
Power in Wind (kW)768.998Calculated
27
Power Extracted (kW)307.6Calculated
28
Annual Energy (kWh)943,266Calculated
29
30
31
32
Formulas Used in Excel
33
34
1. Swept Area (m²)PI()*(Rotor Radius)^2
35
Copy
36
#ERROR!
37
2.Power in Wind (kW)
0.5*Air Density*Swept Area*Wind Speed^3/1000
38
Copy
39
#ERROR!
40
3.Power Extracted (kW)Power in Wind * Cp
41
Copy
42
#ERROR!
43
4.Annual Energy (kWh)Power Extracted * CF * 8760
44
Copy
45
46
Example Calculation
47
48
Input:
49
50
Wind Speed = 10 m/s
51
Rotor Radius = 20 m
52
Air Density = 1.225 kg/m³
53
Power Coefficient (Cp) = 0.4
54
Capacity Factor (CF) = 0.35
55
56
Output:
57
58
Swept Area = 1256.64 m²
59
Power in Wind = 768.998 kW
60
Power Extracted = 307.6 kW
61
Annual Energy = 943,266 kWh
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