| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Sizing a Rainwater Tank based on Climatological and Usage Data | Conversions: | |||||||||||||||||
2 | User Input | Units | SI Units | 7.48052 | gal/ft³ | ||||||||||||||
3 | Footprint | 561 | ft² | 52 | m² | 12 | in/ft | ||||||||||||
4 | Roof Efficiency | 0.8 | material dependent, e.g., 0.75 soil, 0.8 average, 0.95 metal | 3.281 | ft/m | ||||||||||||||
5 | Size of Tank | 2300 | gal | 8706 | liters | 3.785 | liters/gal | ||||||||||||
6 | |||||||||||||||||||
7 | ID # | Arcata | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Avg | Total | Notes: | ||
8 | Rainfall (in) | 5.97 | 5.51 | 5.55 | 2.91 | 1.62 | 0.65 | 0.16 | 0.38 | 0.86 | 2.36 | 5.78 | 6.35 | 3.18 | 38.1 | http://www.appropedia.org/Climate_data | |||
9 | Collection Capacity (gal) | 1670 | 1542 | 1553 | 814 | 453 | 182 | 45 | 106 | 241 | 660 | 1617 | 1777 | 888 | 10,659 | rain fall (in) * 1 ft/12 in * collection area (ft²) * 7.48 gal/ft³ * roof coefficient | |||
10 | Usage (gal) | 500 | 500 | 400 | 500 | 700 | 600 | 300 | 800 | 400 | 600 | 700 | 100 | 508 | 6100 | Calculate from rules of thumb or get from bill. | |||
11 | Tank Vol, starting full in Jan (gal) | 2300 | 2300 | 2300 | 2300 | 2053 | 1635 | 1380 | 686 | 527 | 587 | 1504 | 2300 | 1656 | These are the 1st year tank volumes. | ||||
12 | 2nd year tank volume (gal) | 2300 | 2300 | 2300 | 2300 | 2053 | 1635 | 1380 | 686 | 527 | 587 | 1504 | 2300 | 1656 | These are the 2nd year tank volumes. | ||||
13 | Tank can't fill up past capacity for the month. 0 means need exceeds availability. | ||||||||||||||||||
14 | Recommendation | Sustainable Supply | If the end of the second year is lower than the end of the first year, then attrition is occurring. If any of the two years of calcs falls bellow zero, it is noted. | ||||||||||||||||
15 | |||||||||||||||||||
16 | Instructions: Please make a copy of this for your own use. | ||||||||||||||||||
17 | Change the values in orange cells to match your conditions. See the results in the gray cells. | ||||||||||||||||||
18 | Also, I would love to hear about your project, email me at lonny@humboldt.edu. | ||||||||||||||||||
19 | Check out this free book on Rainwater Catchment: | http://www.tocatchtherain.org | |||||||||||||||||
20 | Or purchase a paperback on Amazon or a local bookstore to help support Appropedia: | http://bit.ly/calcsthx | |||||||||||||||||
21 | |||||||||||||||||||
22 | |||||||||||||||||||
23 | |||||||||||||||||||
24 | |||||||||||||||||||
25 | |||||||||||||||||||
26 | |||||||||||||||||||
27 | |||||||||||||||||||
28 | |||||||||||||||||||
29 | |||||||||||||||||||