Water Supply - Buffer Tank Capacity

	A	B	C	D	E	F
1	Use “File > Make Copy” to make your own copy!
2
3
4	Water Supply System					Log in to your Google account to make a copy of this template!
5	Estimate Required Buffer Tank Capacity
6	This template can be used to simulate the variation in Supply Capacity, Consumption and the required Buffer Volume in a Water Supply System.
7	Substitute the Supply Capacities, the Consumption Values (blue/yellow) and the Buffer Volume (red/yellow) with your own data until supply shortage in the system is avoided.
8	Adjust the time frame and the flow and buffer units to your application. Be aware that due to the spreadsheet circular calculation limit you need assure your self that the possible shortage in hour 24 is recovered during the first hours (1..) of the day.
9	Hour	Supply Capacity (cu.m/h)	Consumption (cu.m/h)	Accumulated Volume (cu.m)	Buffer Volume (cu.m)
10					15
11	1	6	1	5	15
12	2	6	1	10	15
13	3	6	1	15	15
14	4	6	1	20	15
15	5	6	2	24	15
16	6	5	5	24	15
17	7	3	8	19	10
18	8	3	8	14	5
19	9	5	8	11	2
20	10	6	3	14	5
21	11	6	3	17	8
22	12	6	3	20	11
23	13	6	3	23	14
24	14	6	3	26	15
25	15	5	3	28	15
26	16	5	5	28	15
27	17	3	6	25	12
28	18	3	6	22	9
29	19	3	6	19	6
30	20	3	4	18	5
31	21	6	2	22	9
32	22	6	4	24	11
33	23	5	2	27	14
34	24	6	2	31	15
35	Acc. Volume (cu.m)	121	90
36	Diff. (cu.m)		31
37	Max. Vol. (cu.m)			31	15
38	Min. Vol. (cu.m)			5	2
39	Diff. Vol. (cu.m)			26	13
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