Lyons Rainwater Harvesting Calculations

	A	B	C	D	E	F	G	H	I	J
1	Total roof footprint in Sq Ft	3200	Rainfall Coefficient	1	Municipal Charge per 100 Cubic Feet	$
2	Landscape area in Sq Ft		Plant Factor
3	Month	Average Monthly Precipitation in Millimeters	Rainfall Harvest in Gallons	Historical Average ET	Actual Demand in Gallons	Monthly Supply Surplus/Deficit in Gallons	Cumulative Storage Gallons	Municipal Usage in CCF	Municipal Usage in Gallons	Total $ in Municipal Source (excluding base rate)
4	January	4	3.328		0	3.328	3.328		0	#VALUE!
5	February	3	2.496		0	2.496	5.824		0	#VALUE!
6	March	3	2.496		0	2.496	8.32		0	#VALUE!
7	April	2	1.664		0	1.664	9.984		0	#VALUE!
8	May	2	1.664		0	1.664	11.648		0	#VALUE!
9	June	2	1.664		0	1.664	13.312		0	#VALUE!
10	July	1	0.832		0	0.832	14.144		0	#VALUE!
11	August	0	0		0	0	14.144		0	#VALUE!
12	September	1	0.832		0	0.832	14.976		0	#VALUE!
13	October	3	2.496		0	2.496	17.472		0	#VALUE!
14	November	5	4.16		0	4.16	21.632		0	#VALUE!
15	December	4	3.328		0	3.328	24.96		0	#VALUE!
16	Total	30	24.96		0	24.96	24.96	0	0	#VALUE!
17
18	Type expected overhead costs of tank, labor, set-up and related infrastructure	$
19	Price of Municipal Water is expected to increase 5% annually, type here the number of years you want to see your potential ROI for
20	This # helps narrow down your expected time of ROI, if the number is in the negatives add more years and if it's positive subtract years until it's as close to neutral as possible. If you are using a rebate then this number will be the amount rebated to you.	#VALUE!
21	Type in % of local rebate as a decimal (0.50)
22	Here is your total for the above # of years factoring in your rebate, ignore this number if you did not type in rebate amount	#VALUE!
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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