Solar Powered Load Estimator v2.4.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Solar Powered System Estimator v2.4
2	By Doug Hanson
3	See the Solar Powered System Estimator - User’s Guide v1.1 for use with Estimator v2.4 HERE
4	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.
5	This spreadsheet will help to estimate the size, quantity, and parameters of solar system components given specified loads, component efficiencies, and environmental conditions.
6	Fill in the yellow cells for each step. Numbers shown in yellow squares now are just examples.
7
8		Project Name:	Latch Key "Boombox" Sound Stage
9
10	Step 1: Loads - List ALL the loads that will need to be powered.
11		This section is divided into loads that will use your system battery voltage, loads that use a different DC voltage, and AC loads.
12		You will also be asked for converter and inverter efficiencies where required.
13
14	Uses System Battery Voltage: (typically 12, 24, 48 volts, etc.)			44.8	volts
15
16			fill in one of these columns only					only one of these
17	Qty of loads	Description of load	name plate watts	OR name plate VA	OR name plate Amps	OR measured power	load power (calculated)	hours/ day	or duty cycle (%)	daily energy (watt-hours)
18		None					0.0			0.0
19		The EXM ProSUB uses four 97.7 Wh battery packs in a series/parallel configuration. Each individual pack is 24V, giving a 48V battery system after the series/parallel configuration.					0.0			0.0
20							0.0			0.0
21		The EXM Pro10 uses a single 48V battery pack rated at approximately 230 Wh.					0.0			0.0
22		I will just add that power consumption while charging is 48W for EXM Pro10 and 150W for EXM ProSub . These systems run only on battery power, they do not run on AC, so these specs are all you need.					0.0			0.0
23							0.0			0.0
24							0.0			0.0
25							0.0			0.0
26							0.0			0.0
27							0.0			0.0
28							0.0			0.0
29							0.0			0.0
30
31						Daily Energy used by system battery voltage loads:				0.00
32
33	Uses Non-battery voltage DC loads: (e.g., 5 volts)			5	volts
34
35			fill in one of these columns only					only one of these
36	Qty of loads	Description of load	name plate watts	OR name plate VA	OR name plate Amps	OR measured power	load power (calculated)	hours/ day	or duty cycle (%)	daily energy (watt-hours)
37		None					0			0.0
38							0			0.0
39							0			0.0
40							0			0.0
41							0			0.0
42							0			0.0
43							0			0.0
44							0			0.0
45							0			0.0
46							0			0.0
47							0			0.0
48							0			0.0
49
50						Daily Energy used by non-battery voltage DC loads:				0.0
51						DC-DC converter efficiency (%):				90%
52						Adjusted Energy used by non-battery voltage DC loads:				0.0
53
54	Uses AC loads (e.g., 120 volts)			120	volts
55
56			fill in one of these columns only					only one of these
57	Qty of loads	Description of load	name plate watts	OR name plate VA	OR name plate Amps	OR measured power	load power (calculated)	hours/ day	or duty cycle (%)	daily energy (watt-hours)
58	1	Pioneer XDJ-AZ Controller	60.0				60	5		300
59	2	Yorkville EXM Pro10 -INTERNAL BATTERY	300.0				600	5		3,000
60	2	Yorkville EXM Pro Sub - INTERNAL BATTERY	500.0				1,000	5		5,000
61							0			0
62							0			0
63							0			0
64							0			0
65							0			0
66							0			0
67							0			0
68							0			0
69							0			0
70
71						Daily Energy used by AC loads:				8,300.00
72						Inverter efficiency (%):				90.00%
73						Adjusted Energy used by AC loads:				9,222.22
74
75	Step 2: Margins -
76		This section will add any margins if desired
77
78		Total of all loads from Step 1: ------->	Daily energy-->	9,222	watt-hours	9	kW-hours
79		Reserve Days (0.0 - N) --->	1.0	18,444	watt-hours	18	kW-hours
80		Weather margin in days (see note 1):	1.0	36,889	watt-hours	37	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)
81
82
83
84	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.
85		This section will estimate the storage batteries required
86
87		Battery Type	Select Type	Amp-hour rating	Available Capacity %	Usable Capacity (Ah)	Qty batteries at system voltage
88		Deep Cycle Lead Acid (PB)		0.00	0.00	0.00
89		Lithium Ion (LiIon)		0.00	0.00	0.00
90		Lithium Ferrous Phosphate (LiFePo4)	Jackery Explorer 2000 V2	45.58	95.00	4,330.13	0.19
91
92	Step 4: Panels -
93		This section will estimate the number of solar panels required
94
95		Panel Type	Panel Power (watts)	Daylight Charge Hours	Panel Efficiency	Charger Efficiency	Battery Charge Efficiency	Qty panels
96		Monocyrstaline	120.00	6.00	25.00	75.00	90.00	0.00030
97
98	Step 5: Charge Controller -
99		This section will estimate the size of the charge controller
100