Solar & Battery Calculator

	A	B	C	D	E	F	G	H	J	L	M	N	O	P	Q	R
1	This free spreadsheet is brought to you by Prepare2Thrive.com Full instructions and details can be found here:							https://prepare2thrive.com/power
2	Step 0: Go to the FILE menu, and select MAKE A COPY. This will give you a copy you can use and edit.
3	Step 1: Use a Kill-a-Watt device to measure the power usage of each appliance or device over several days								Step 2: Fill in green squares with your local numbers and prices.
4	Item/Device	Priority Level	Start Recording	End Recording	Max Rated Watts	Total KwH Used	Elapsed Time	KwH/Day	Battery Bank Voltage:		12	Battery Bank Size by Type of Battery
5		(1 - 3)	Date & Time	Date & Time	Max Rated Watts	Total KwH Used	Days	KwH/Day	Days of Autonomy:		3	Lead-Acid HD	L/A Deep Cycle	AGM	Lithium	LifePo4
6	Example: Refrigerator in basement	1	2022-07-10 12:00	2022-07-13 18:00	800	5.5	3.25	1.69			DOD:	25%	50%	80%	90%	90%
7							0	0.00	Priority	Watts	KwH/Day
8							0	0.00	Highest	0	0.00	0 Ah	0 Ah	0 Ah	0 Ah	0 Ah
9							0	0.00	Mid	0	0.00	0 Ah	0 Ah	0 Ah	0 Ah	0 Ah
10							0	0.00	Lowest	0	0.00	0 Ah	0 Ah	0 Ah	0 Ah	0 Ah
11							0	0.00	Total Bank Size:	0 Watts	0.00	0 Ah	0 Ah	0 Ah	0 Ah	0 Ah
12							0	0.00	Charging Efficiency:			80%	80%	80%	95%	95%
13							0	0.00	Charging KwHs Required:			0.00 KwH			0.00 KwH
14							0	0.00
15							0	0.00	Ah per battery			95	115	300	48	115
16							0	0.00	Price per battery			$119	$197	$375	$504	$1,266
17							0	0.00	# of batteries required:			0	0	0	0	0
18							0	0.00	Cost for batteries			$0	$0	$0	$0	$0
19							0	0.00
20							0	0.00	Daily Incident Shortwave Solar Energy		3.4	https://weatherspark.com		<- go to website, find your location, look for Solar Energy, take lowest month
21							0	0.00	Watts per panel, panel size		350
22							0	0.00	Price per panel		$190.00
23							0	0.00	Total panel watts required to charge in 1 day			0 Watts			0 Watts
24							0	0.00	# of panels required:			0 Panels			0 Panels
25							0	0.00	Cost for panels			$0.00			$0.00
26							0	0.00
27							0	0.00	Day 1 cost for batteries & panels			$0	$0	$0	$0	$0
28							0	0.00
29							0	0.00	Battery Lifespan (cycles)			600	900	600	2000	6000
30							0	0.00	Battery Lifespan (years)			1.6	2.5	1.6	5.5	16.4
31							0	0.00
32							0	0.00	15 year cost for batteries & panels			$0	$0	$0	$0	$0
33							0	0.00
34							0	0.00	Note that the costs do not include chargers, wiring, mounts, monitoring systems, installation, or any other costs.
35							0	0.00	Legend
36							0	0.00	Green fields need your input
37							0	0.00	Grey fields do calculations. Do not change them.
38							0	0.00	Yellow fields contain all the results you need.
39							0	0.00
40							0	0.00
41							0	0.00
42							0	0.00
43							0	0.00
44							0	0.00
45							0	0.00
46							0	0.00
47							0	0.00
48							0	0.00
49							0	0.00
50							0	0.00
51							0	0.00
52							0	0.00
53							0	0.00
54							0	0.00
55							0	0.00
56							0	0.00
57							0	0.00
58							0	0.00	Need more rows? Right click and insert above this line. Then copy & paste this line to the new blank lines.
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