Rainwater Catchment Calculator
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Rainwater Catchment Calculator
4
5
This is a simple sheet that allows the user to calculate the amount of rainfall that can potentially be collected from an impervious surface such as a roof or asphault parking lot
6
Plug in the area of the impervious surface in the green cells to determine how much rainfall could be collected each year
7
Green cells can be edited, organge cells should not be edited or done so carefully so as not to mess up the calculations
8
The worksheet can also help calculate the sizing of a tank. Insert the tank size in gallons and in the Rainfall Collected table insert estimated water used per month
9
10
GENERAL CALCULATIONS
11
1. Take the dimensions of the footprint of your roof and convert them to inches. (So, a 50' x 20' roof is 600" x 240".)
12
2. Multiply the roof dimensions by the number of inches of rainfall. ...
13
3. Divide by 231 to get the number of gallons (because 1 gallon = 231 cubic inches).
14
15
16
DIMENSIONS
17
BarnFeetInches
Tank Size (gallons)
18
length546482500
19
width32384
20
21
1,728 248,832
22
23
High Tunnel
FeetInches
Tank Size (gallons)
24
length961152
25
width30360
26
27
2,880 414,720
28
29
WEATHER DATA
30
JanFebMarAprMayJunJulAugSepOctNovDec
31
Average high inÂ Â°F:333747607079828174635037
32
Average low inÂ Â°F:151825364656595648372920
33
Av. precipitation inÂ inch:2.832.43.153.584.414.254.173.393.312.83.232.99
34
Days with precipitation:------------
35
Hours of sunshine:------------
36
37
https://www.usclimatedata.com/climate/mount-vernon/ohio/united-states/usoh1887
38
39
40
RAINFALL COLLECTED
41
JanFebMarAprMayJunJulAugSepOctNovDec
42
BarnSquare inches collected 704,194.56 597,196.80 783,820.80 890,818.56 1,097,349.12 1,057,536.00 1,037,629.44 843,540.48 823,633.92 696,729.60 803,727.36 744,007.68
43
Gallons per month 3,048.46 2,585.27 3,393.16 3,856.36 4,750.43 4,578.08 4,491.90 3,651.69 3,565.51 3,016.15 3,479.34 3,220.81
44
Cumulative gallons 3,048.46 5,633.73 9,026.89 12,883.25 17,633.68 22,211.76 26,703.66 30,355.35 33,920.86 36,937.01 40,416.35 43,637.16
45
Gallons in tank 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,116.15 2,500.00 2,500.00
46
Gallons Used - - 500.00 1,000.00 1,000.00 1,000.00 2,500.00 2,500.00 3,400.00 2,000.00 2,000.00 -
47
Gallons Remaining 2,500.00 2,500.00 2,000.00 1,500.00 1,500.00 1,500.00 - - (900.00) 116.15 500.00 2,500.00
48
49
50
High Tunnel
Square inches collected 1,173,657.60 995,328.00 1,306,368.00 1,484,697.60 1,828,915.20 1,762,560.00 1,729,382.40 1,405,900.80 1,372,723.20 1,161,216.00 1,339,545.60 1,240,012.80
51
Gallons per month of rainfall 5,080.77 4,308.78 5,655.27 6,427.26 7,917.38 7,630.13 7,486.50 6,086.15 5,942.52 5,026.91 5,798.90 5,368.02
52
Cumulative gallons 5,080.77 9,389.55 15,044.82 21,472.08 29,389.46 37,019.59 44,506.10 50,592.25 56,534.77 61,561.68 67,360.58 72,728.60
53
Gallons collected 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00
54
Gallons Used 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00
55
Gallons Remaining 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00
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