Scribd
Upload
215 views9 pages

Reservoir Tank Usage Spreadsheet: Input Data

The spreadsheet calculates material requirements for constructing an 8,000 liter underground water reservoir tank that is 1.8 meters tall with an inner diameter of 2.379 meters, listing the estimated quantities of gravel, cement, rebar, and other materials needed for the tank base, walls, roof, floor, and final construction. Input data includes the planned tank capacity and wall height, and the results provide a breakdown of material amounts for the tank base, walls, roof, floor, and final construction.

Uploaded by

Shepherd Nhanga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
215 views9 pages

Reservoir Tank Usage Spreadsheet: Input Data

The spreadsheet calculates material requirements for constructing an 8,000 liter underground water reservoir tank that is 1.8 meters tall with an inner diameter of 2.379 meters, listing the estimated quantities of gravel, cement, rebar, and other materials needed for the tank base, walls, roof, floor, and final construction. Input data includes the planned tank capacity and wall height, and the results provide a breakdown of material amounts for the tank base, walls, roof, floor, and final construction.

Uploaded by

Shepherd Nhanga
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Tank Sizing Spreadsheet

Community : [Link]
Date :

Reservoir Tank Usage Spreadsheet


Owner :

Input data
Flow In Tank Capacity Total Demand
Litres/second Litres Litres
0.69 7500 35250

Scenario 1
Day Time Period Time % Usage Demand Flow in Change in Volume
Hours Hours % Litres Litres Litres
6am-8am 7 15 5287.5 2484 -2803.5
8 15 5287.5 2484 -2803.5
9 5 1762.5 2484 721.5
10 5 1762.5 2484 721.5
11 5 1762.5 2484 721.5
8am-4pm 12 5 1762.5 2484 721.5
13 5 1762.5 2484 721.5
14 5 1762.5 2484 721.5
15 5 1762.5 2484 721.5
16 5 1762.5 2484 721.5
4pm-6pm 17 15 5287.5 2484 -2803.5
18 15 5287.5 2484 -2803.5
19 0 0 2484 2484
20 0 0 2484 2484
21 0 0 2484 2484
22 0 0 2484 2484
23 0 0 2484 2484
6pm-6am 24 0 0 2484 2484
1 0 0 2484 2484
2 0 0 2484 2484
3 0 0 2484 2484
4 0 0 2484 2484
5 0 0 2484 2484
6 0 0 2484 2484

Scenario 1: Tank volume during a complete day

8000

7000

6000
Volume (Litres)

5000

4000

3000

2000
6000

Tank Sizing Spreadsheet

Volume (Litres)
5000 :
Community [Link]
Date :
Owner4000
:

3000

2000

1000

0
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1 2 3 4 5 6
Time (Hours)

Scenario 2
Day Time Period Time % Usage Demand Flow in Change in Volume
Hours Hours % Litres Litres Litres
5am-7am 6 5 1762.5 2484 721.5
7 5 1762.5 2484 721.5
8 6.25 2203.13 2484 280.875
7am-11am 9 6.25 2203.13 2484 280.875
10 6.25 2203.13 2484 280.875
11 6.25 2203.13 2484 280.875
11am-1pm 12 17.5 6168.75 2484 -3684.75
13 17.5 6168.75 2484 -3684.75
14 5 1762.5 2484 721.5
1pm-5pm 15 5 1762.5 2484 721.5
16 5 1762.5 2484 721.5
17 5 1762.5 2484 721.5
5pm-7pm 18 5 1762.5 2484 721.5
19 5 1762.5 2484 721.5
20 0 0 2484 2484
21 0 0 2484 2484
22 0 0 2484 2484
23 0 0 2484 2484
7pm-5am 24 0 0 2484 2484
1 0 0 2484 2484
2 0 0 2484 2484
3 0 0 2484 2484
4 0 0 2484 2484
5 0 0 2484 2484

Scenario 2: Tank volume during a complete day

8000

7000

6000
es)

5000
Scenario 2: Tank volume during a complete day
Tank Sizing Spreadsheet
Community
8000 : [Link]
Date :
Owner7000
:

6000
Volume (Litres)

5000

4000

3000

2000

1000

0
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 1 2 3 4 5
Time (Hours)
Tank Sizing Spreadsheet
Community : [Link]
Date :

dsheet
Owner :

Cumulative Change
Litres
4696.5
1893
2614.5
3336
4057.5
4779
5500.5
6222
6943.5
7500
4696.5
1893
4377
6861
7500
7500
7500
7500
7500
7500
7500
7500
7500
7500
Tank Sizing Spreadsheet
Community : [Link]
Date :
Owner :

3 4 5 6

Cumulative Change
Litres
7500
7500
7500
7500
7500
7500
3815.25
130.5
852
1573.5
2295
3016.5
3738
4459.5
6943.5
7500
7500
7500
7500
7500
7500
7500
7500
7500
Tank Sizing Spreadsheet
Community : [Link]
Date :
Owner :

2 3 4 5
Reservoir Tank Sizing Spreadsheet

Input data
Wall Height Tank Capacity
Metres Litres
1.80 8000.00

Tank Volume Tank Inner Diameter


Metres3 Metres
8.00 2.379

Material Requirements
Tank Base (Pre) Amount Tank Base Amount Tank Wall Amount
Arena (latas) 12.31 Arena (latas) 15.69
Grava (latas) 18.47 Grava (latas) 24.62
Cemento (bultos) 3.08 Cemento (bultos) 3.92
Festergral (palas) 3.08 Festergral (palas) 3.92
Electromalla (m) 8.13

Total Amount
Arena (latas) 92
Grava (latas) 58
Cemento (bultos) 22
Festergral (palas) 22
Electromalla (m) 16.18
heet

Tank Wall (1st Layer) Amount Tank Wall (2nd Layer) Amount Tank Roof Amount
Arena (latas) 15.69 Arena (latas) 15.69 Arena (latas) 7.39

Cemento (bultos) 3.92 Cemento (bultos) 3.92 Cemento (bultos) 1.85


Festergral (palas) 3.92 Festergral (palas) 3.92 Festergral (palas) 1.85
Tank Roof (Final Layer) Amount Tank Final Amount Tank Floor Amount
Arena (latas) 4.92 Arena (latas) 4.92 Arena (latas) 14.77
Grava (latas) 14.77
Cemento (bultos) 1.23 Cemento (bultos) 1.23 Cemento (bultos) 2.46
Festergral (palas) 1.23 Festergral (palas) 1.23 Festergral (palas) 2.46
Electromalla (m) 8.05

You might also like