ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Please Copy or Download to Use
2
Solar Powered System Estimator v2.4
3
By Doug Hanson
4
See the Solar Powered System Estimator - User’s Guide v1.1 for use with Estimator v2.4 HERE
5
For solar, wind, or solar/wind hybrid renewable power, determining the most appropriate, efficient, and cost-effective system requires a comprehensive installation electrical load analysis to determine the desired system capacity. Portions of this spreadsheet are useful for all projects.
6
This spreadsheet will help to estimate the size, quantity, and parameters of solar system components given specified
loads, component efficiencies, and environmental conditions.
7
Fill in the yellow cells for each step. Numbers shown in yellow squares now are just examples.
8
9
Project Name:Your Project
10
11
Step 1: Loads - List ALL the loads that will need to be powered.
12
This section is divided into loads that will use your system battery voltage, loads that use a different DC voltage, and AC loads.
13
You will also be asked for converter and inverter efficiencies where required.
14
15
System Battery Voltage: (typically 12, 24, 48 volts, etc.)0volts
16
17
fill in one of these columns onlyonly one of these
18
Qty of loadsDescription of loadname plate wattsOR name plate VAOR name plate AmpsOR measured powerload power (calculated)hours/ dayor duty cycle (%)daily energy (watt-hours)
19
0.00.0
20
0.00.0
21
0.00.0
22
0.00.0
23
0.00.0
24
0.00.0
25
0.00.0
26
0.00.0
27
0.00.0
28
0.00.0
29
0.00.0
30
0.00.0
31
32
Daily Energy used by system battery voltage loads:0.0
33
34
Non-battery voltage DC loads: (e.g., 5 volts)5volts
35
36
fill in one of these columns onlyonly one of these
37
Qty of loadsDescription of loadname plate wattsOR name plate VAOR name plate AmpsOR measured powerload power (calculated)hours/ dayor duty cycle (%)daily energy (watt-hours)
38
00.0
39
00.0
40
00.0
41
00.0
42
00.0
43
00.0
44
00.0
45
00.0
46
00.0
47
00.0
48
00.0
49
00.0
50
51
Daily Energy used by non-battery voltage DC loads:0.0
52
DC-DC converter efficiency (%):0%
53
Adjusted Energy used by non-battery voltage DC loads:#DIV/0!
54
55
AC loads (e.g., 120 volts)120volts
56
57
fill in one of these columns onlyonly one of these
58
Qty of loadsDescription of loadname plate wattsOR name plate VAOR name plate AmpsOR measured powerload power (calculated)hours/ dayor duty cycle (%)daily energy (watt-hours)
59
00
60
00
61
00
62
00
63
00
64
00
65
00
66
00
67
00
68
00
69
00
70
00
71
72
Daily Energy used by AC loads:0.0
73
Inverter efficiency (%):0%
74
Adjusted Energy used by AC loads:#DIV/0!
75
76
Step 2: Margins -
77
This section will add any margins if desired
78
79
Total of all loads from Step 1: ------->Daily energy-->#DIV/0!watt-hours#DIV/0!kW-hours
80
Reserve Days (0.0 - N) --->0.0#DIV/0!watt-hours#DIV/0!kW-hours
81
Weather margin in days (see note 1):0.0#DIV/0!watt-hours#DIV/0!kW-hours<---Note 1: Bad weather can affect the amount of solar power collected and stored in batteries. Enter the number of EXTRA days between 0 and N days (e.g., 0.5)
82
83
84
85
Step 3: Batteries -
Note: A battery is taken to be the aggregation of cells that you choose to make up the system voltage. The Ah rating is for one unit of this configuration.
86
This section will estimate the storage batteries required
87
88
Battery TypeSelect TypeAmp-hour ratingAvailable Capacity %Usable Capacity (Ah)Qty batteries at system voltage
89
Deep Cycle Lead Acid (PB)0.00.000.0
90
Lithium Ion (LiIon)0.00.000.0
91
Lithium Ferrous Phosphate (LiFePo4)0.00.000.0
92
93
Step 4: Panels -
94
This section will estimate the number of solar panels required
95
96
Panel TypePanel Power (watts)Daylight Charge HoursPanel EfficiencyCharger EfficiencyBattery Charge EfficiencyQty panels
97
Monocyrstaline 000.000.000.0#DIV/0!
98
99
Step 5: Charge Controller -
100
This section will estimate the size of the charge controller