HBC Solar Energy Calculator App3.xlsx

	B	C	D	E	F	H	I	J	K	L	M	N	O
1	OFF-GRID SOLAR ENERGY CALCULATOR					GRID-TIED SOLAR HOME ENERGY CALCULATOR
2	2- DESIRED BATTERY STORAGE CAPACITY (LA or AGM only)					HOME INFO (Table 2200.12, 210.11c1 / c2 NEC 2011)				AIR CONDITIONING REQUIREMENTS (Table 220.82c)
3	Ah	VDC	No. of batts	Wh Available		a	Enter: Square footage of home?	750	ft2	19	Enter: Total heating load (about 5000W for 4-bed home)	0	W
4	100	12	36	14400	Wh	b	W/Ft2	3		20	Enter: Total cooling load (about 3500W for 4-bed home)	1600	W
5	Required for Appliace total>>			14385	Wh	1	Total home/general load (axb)	2250	W	21	Enter: Higher load in Watts cooling or heat? Omit lower load (tot. heat or tot. a/c)	1600	W
6	Surp./(Def.)>>			15.00	Wh	1a	Enter: How many kitchen appliances? # of small appliances load (kitchen)	4		22	Larger load (tot. heat or tot. cool) @ 40% (21 x 0.4)	640	W
7	1- DESIRED APPLIANCE REQUIREMENTS					2	Total small applicances load (1a x 1500)	6000	W	HOME TOTAL LOAD (MINIMUM INVERTER SIZE REQUIRED)
8	Device	Rated watts	Avg Hrs used/day (decimal)	Req. Wh from battery bank		2a	Enter: How many laudry rooms? Laundry circuits	1		23	Total home power requirement (inverter run w) +20% Total home load (18 + 22)	22923	W
9	Microwave	1200	2	2400	Wh	3	Total laudry load (2a x 1500)	1500	W	24	Voltage provided at service entrance	220	VAC
10	TV1	200	2	400	Wh	4	Total 1 (general + circuit loads)(1 + 2 + 3)	9750	W	25	Total amperage required for home (23 / 24)	104	A
11	TV2	200	1.5	300	Wh	Table 220.42				DESIRED SOLAR PANEL CAPACITY
12	Stereo	300	0.5	150	Wh	5	W Portion of total 2 @100%	6000	W	26	Enter: Solar Module (each) peak power (usually 50 - 400 W)	420	W
13	Window AC	1600	6	9600	Wh	6	Total 1 - W portion @100% (4 - 5)	3750	W	27	Insolation hours (avg. no. of hrs. of sunlight exposure to modules)	3	Hr
14	PC	250	3	750	Wh	7	Total 2 (total 1 @ 35%) (6 x 0.35)	1312.5	W	28	Solar module average power avail. Per day (26 x 27)	1260	Wh
15	Fan	50	2.5	125	Wh	8	Total 2 + W portion of total 1 @100% (5 + 7)	7312.5	W	29	Enter Number of modules in array (actual)	18	Modules
16	Light1	40	2	80	Wh	ELECTRIC HOME APPLIANCES (not cool or heat) (table 220.52/.53/.54 Nameplate ratings of fixed appliances NEC 2011)				30	Available daily power from solar array as calculated	22680	Wh
17	Light2	30	3	90	Wh	9	Electric range (about 12200w)	6100	W	31	Surplus/Deficit of required power for home (30 - 23)	-243	W
18	Light3	40	4	160	Wh	10	Electric clothes dryer (about 5900w)	3450	W	32	Number of modules req'd. for 100% coverage (cvg) (avg. power) (23 / 28)	18	Modules
19	Printer	50	0.25	12.5	Wh	11	Electric dishwasher (about 900w)	0	W	33	Number of modules req'd. for 50% coverage (peak) (32 x 0.5)	9	Modules
20	Cell charger1	10	1	10	Wh	12	Electric water heater (about 3000w)	1600	W	34	Number of modules req'd. for 25% coverage (peak) (32 x .25)	5	Modules
21	Cell charger2	10	2	20	Wh	13	Other (not common)	0	W
22	Tablet charger	10	2	20	Wh	14	Other (not common)	0	W
23	Coffee maker	150	0.25	37.5	Wh	15	Other (not common)	0	W
24	Toaster	800	0.25	200	Wh	16	Other (not common)	0	W
25	Miter saw	120	0.25	30	Wh	17	Total fixed appliances VA (sum 9:16)	11150	W
26	TOTALS	5060	32.5	14385	Wh	18	Net calculated load (8 + 17)	18462.5	W
27	4 – DESIRED SOLAR REGENERATION CAPACITY
28	Module rated watts	Avg. Sun (Hrs/day)	No. of Modules	Aval. Regen. Wh
29	420	4	9	15120	Wh
30	3 – REQUIRED SOLAR WATTS
31	Total Wh req.	Avg. insolation (Hrs/day)	Module total Watts req.	Min. no. of modules req.
32	14385	4	3596	9	Modules
33	OFF-GRID SOLAR ESTIMATES
34	5 – ESTIMATION
35	PV Module cost ea.	420	$USD	Wire&HW %	0.1
36	Battery cost ea.	150	$USD	Project Cost Estimates
37	Min. Inverter size (for 100% cover) + 10%	3596	W	$32,128	100% cvg
38	Inverter cost	6500	$USD	$19,920	50% cvg
39	Labor cost per watt	1	$USD	$11,245	25% cvg
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