Spread Sheet Developed By: Softwel (P) Ltd.

Design and Drawing of

Rural Water Supply Scheme

View Pipe Data

Goto
Goto Data
Data Input
Input
GPO Box 86, Kathmandu, Nepal
Phone : +977-1-4104307
Email : support@softwel.com.np Goto
Goto PD-Sample
PD-Sample

Pipe Database Updated as per Nepal Standard For PN100 Pipe Series.
Last Updated : 2019/12/01
If any issue please contact at softwel.sanjog@gmail.com

Annex - I
 DATA INPUT FORM
Spread Sheets Developed by SOFTWEL (P) Ltd.

Organization CBWSS
Scheme Code 11000
Scheme Name TEST
Name of the Community Community
Name of the Support Organization SO
Location : Ward No.: WD
VDC : VDC
District : Baitadi
Baitadi

SCHEME TYPE Gravity

SURVEY / DESIGN INFORMATION

District Pop Growth Rate (r) 1.35 % From District Growth Rates
Construction Period (n1) 2 years
Design Period (n) 20 years
Peak Factor 3 Factor
Per Capita Domestic Water Demand 45 l/d
Per Capita Water Demand for Students 10 l/d
Present Year ( Survey Year) 2020 AD
Base Year ( Project Completion Year) 2022 AD
Design Year 2042 AD
Minimum Flow Rate per Tap 0.10 lps
Table C.1 : Water Demand and Tap Flow Calculation Sheet

SCHEME NAME : TEST

SUPPORT ORGANIZATION :
LOCATION : WARD NO : WD VDC : VDC DISTRICT : Baitadi
Name of Community : Community
Required Datas:
Peak Factor: 3
Per Capita Demand : 45 lpcd
Per Capita Demand for Students: 10 lpcd Minimum flow rate 0.10 lps Create RVT Sheets

Description of Tap Population forecast Institutional Water Demand Total Tap Flow Calculation
Tap Cluster Name Ward Nos Present YearBase Year Design Year Total No. of Other Total Live Water Average Peak Peak Design Adjusted Remarks
No or No. of 2020 2022 2042 Domestic Pupil in Institutional Institutional Stock Demand Tap Flow Factor Flow flow Peak
Locality HH (P) (Po) (Pn) Demand School Demand Demand Demand factor
(Nos) (Nos) P(1+r)^n1 P(l+r)^(n1+n) (lpd) (Nos) (lpd) (lpd) (lpd) (lpd) (lps) (Factor) (lps) (lps) (lps)
[1] [2] [2-1] [3] [4] [5] [6] [8] [9] [10] [11] [11-1] [12] [13] [14] [15] [16] [17] [18]
RVT1
1 Cluster 1 2 14 15 19 855 855 0.01 3.00 0.03 0.10 10.00
2 Cluster 2 3 21 22 29 1,305 1,305 0.02 3.00 0.05 0.10 6.67
3 Cluster 3 4 28 29 38 1,710 1,710 0.02 3.00 0.06 0.10 5.00
4 Cluster 4 5 35 36 48 2,160 2,160 0.03 3.00 0.08 0.10 4.00
5 Cluster 5 4 28 29 38 1,710 1,710 0.02 3.00 0.06 0.10 5.00

sub total 18 126 131 172 7,740 - - - - 7,740 0.09 0.27 0.50

Grand Total 18 126 131 172 7740 0 0 0 7740 0.09 0.27 0.50 0.00

NOTE : 1 Peak factor of 3 has been adopted

2 Design Tap Flow has been adjusted for the Peak flow by rounding off to nearest 0.01lps.
3 If flow is less than 0.1 lps then it has been adjusted to 0.1 lps and if flow is greater than 0.25 lps provide additional tapstand.
Table C.2 : Reservoir Tank Sizing
CBWSS
SCHEME NAME : TEST
LOCATION : WARD NO : WD VDC : VDC DISTRICT : Baitadi

a) Scheme Information
a.1 Reservoir Tank No: 1
a.2 Served Standposts 1 to 14
a.3 Average Design Demand to be Supplied through Reservoir 0.090 l/s = 7740.000 l/day
a.4 Available Minimum flow from the Source (Safe Yield) 0.130 l/s

a.5 Adjusted/Optimized supply to Reservoir from Source 0.130 l/s = 11232.0 l/day
a.6 Total Design Flows of all Standposts : 0.500 l/s
b) Reservoir sizing assuming Continuous System using Consumption Patterns

Time Period Hours Water Cummu. Cummu. Surplus Deficit

From To Consumption Supply Demand
(%) (lt) (lt) (lt) (lt)
5:00 AM 7:00 AM 2 25.0% 936 1935 999
7:00 AM 12:00 PM 5 35.0% 3276 4644 1368
12:00 PM 5:00 PM 5 20.0% 5616 6192 576
5:00 PM 7:00 PM 2 20.0% 6552 7740 1188
7:00 PM 5:00 AM 10 0.0% 11232 7740 3492

Maximum Deficit 1368 lt

Minimum required Reservoir capacity 1.37 cum
Provide Reservoir of capacity 2.00 cum 26% of Average Demand
Check if Reservoir gets filled during night (7:00 PM - 5:00 AM)
Volume of water collected during night 4.68 cum

12000

10000

8000

6000

4000

2000

0
12:00 AM
12:00 AM

04:48 AM

09:36 AM

02:24 PM

07:12 PM

04:48 AM

09:36 AM

Supply Demand

c) Reservoir sizing assuming Intermittent System (Optional)

Maximum Required supply hours based on Supply from Source 6.24 hours
Maximum Required supply hours based on Demand 4.30 hours
Adopted hours of Supply 5.00 hours
Recommended Supply Hours and Period
First Shift 5:00 AM To 7:59 AM
Second Shift 5:00 PM To 7:00 PM

Time Period Hours Cum. Inflow Cum. Con- Surplus Deficit

From To In Out (lt) sumption (lt) (lt) (lt)
5:00 AM 7:59 AM 3.00 3.0 1404 5400 3996
7:59 AM 5:00 PM 9.00 0.0 5616 5400 216
5:00 PM 7:00 PM 2.00 2.0 6552 9000 2448
7:00 PM 5:00 AM 10.00 0.0 11232 9000 2232

Max Deficit 3996 lt = 4.00 cum

Provide Reservoir Capacity of 4.00 cum
c) Recommended Reservoir Size

Recommended Size for RVT 01 = 6.00 cum Time to Fill the RVT 12.82 Hr
 PIPELINE DESIGN Sheet No. : 5 of 15

(HYDRAULIC CALCULATIONS)
Pipe Class abbreviation HC Soil Code GMS OS
MC (Ctrl+a for using solver) HR BMS
SCHEME NAME : SOURCE NAME : SAFE YEILD : DI Run
SR MR
Run Macro
Macro HereHere
LOCATION : WARD NO : VDC : DISTRICT : CI Ctrl
Ctrl ++ ee HS SS Pipe Line Design from CW Method
HS Steel

S. Pipe Line Length Design Direction Reduced Level Level New Total Max. PIPE USED Friction Head Residual Flow Hydraulic Gradient L Soil
(UL/UR
No. Dis. / Diff. Static Head Static HDPE G.I. Factor Loss Head Velocity Type
From To Actual Design Q DL/DR) From To Level Available Pressure O.D. Class I.D. N.B. Class From To Remarks
(m) (m) (lps) (L/R/U/D) (m) (m) (m) (m) (m) (m) (mm)(kg/cm²) (mm) (mm) (m) (m) (m/s) (m) (m)
[0] [1] [2] [3] 0 [5] (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) (18) (19) (20) (21) (22) (23) (24) (25)

Intake to RVT
1 IN P1 210 231 0.130 DR 1518.00 1491.00 27.00 1518.00 27.00 27.00 32 10.0 26.70 0.0420 0.98 26.02 0.23 1518.00 1517.02 BMS
2 P1 P2 315 346.5 0.130 DR 1491.00 1477.00 14.00 1518.00 40.02 41.00 32 10.0 26.70 0.0420 1.47 38.55 0.23 1517.02 1515.55 BMS
3 P2 RVT 315 346.5 0.130 DR 1477.00 1465.00 12.00 1518.00 50.55 53.00 32 10.0 26.70 0.0420 1.47 49.08 0.23 1515.55 1514.08 BMS
RVT to DJ1,DJ2,DJ3
1 RVT LJ1 120 132 0.300 DL 1465.00 1432.00 33.00 1465.00 33.00 33.00 32 10.0 26.70 0.0355 2.61 30.39 0.54 1465.00 1462.39 BMS
2 LJ1 LJ2 60 66 0.200 DL 1432.00 1420.00 12.00 1465.00 42.39 45.00 32 10.0 26.70 0.0382 0.62 41.77 0.36 1462.39 1461.77 BMS
3 LJ2 LJ3 150 165 0.100 D 1420.00 1387.00 33.00 1465.00 74.77 78.00 25 12.5 19.90 0.0429 1.86 72.91 0.32 1461.77 1459.91 BMS
RVT to DJ4,DJ5
1 RVT LJ4 245 269.5 0.200 DR 1465.00 1433.00 32.00 1465.00 32.00 32.00 32 10.0 26.70 0.0382 2.55 29.45 0.36 1465.00 1462.45 BMS
2 LJ4 LJ5 200 220 0.100 D 1433.00 1400.00 33.00 1465.00 62.45 65.00 25 12.5 19.90 0.0429 2.47 59.98 0.32 1462.45 1459.98 BMS
Pipe Line Estimate
Transmission
CODE Type Nominal Dia/Outer Dia Class ND Code
GP-1 G.I. Pipe 1/2" - 15mm 15-MC-TL
GP-2 G.I. Pipe 3/4" - 20mm 20-MC-TL
GP-3 G.I. Pipe 1" - 25mm 25-MC-TL
GP-4 G.I. Pipe 1-1/4" - 32mm 32-MC-TL
GP-5 G.I. Pipe 1-1/2" - 40mm 40-MC-TL
GP-6 G.I. Pipe 2" - 50mm 50-MC-TL
GP-7 G.I. Pipe 2-1/4" - 65mm 65-MC-TL
GP-8 G.I. Pipe 3" - 80mm 80-MC-TL
GP-9 G.I. Pipe 3-1/2" - 100mm 100-MC-TL
GP-10 G.I. Pipe 1/2" - 15mm 15-HC-TL
GP-11 G.I. Pipe 3/4" - 20mm 20-HC-TL
GP-12 G.I. Pipe 1" - 25mm 25-HC-TL
GP-13 G.I. Pipe 1-1/4" - 32mm 32-HC-TL
GP-14 G.I. Pipe 1-1/2" - 40mm 40-HC-TL
GP-15 G.I. Pipe 2" - 50mm 50-HC-TL
GP-16 G.I. Pipe 2-1/4" - 65mm 65-HC-TL
GP-17 G.I. Pipe 3" - 80mm 80-HC-TL
GP-18 G.I. Pipe 3-1/2" - 100mm 100-HC-TL

HPA-1 HDP Pipe 20 16 kg/cm² 20-16-TL

HPA-2 HDP Pipe 25 16 kg/cm² 25-16-TL
HPA-3 HDP Pipe 32 16 kg/cm² 32-16-TL
HPA-4 HDP Pipe 40 16 kg/cm² 40-16-TL
HPA-5 HDP Pipe 50 16 kg/cm² 50-16-TL
HPA-6 HDP Pipe 63 16 kg/cm² 63-16-TL
HPA-7 HDP Pipe 75 16 kg/cm² 75-16-TL
HPA-8 HDP Pipe 90 16 kg/cm² 90-16-TL
HPA-9 HDP Pipe 110 16 kg/cm² 110-16-TL
HPA-10 HDP Pipe 125 16 kg/cm² 125-16-TL
HPA-11 HDP Pipe 140 16 kg/cm² 140-16-TL
HPA-12 HDP Pipe 160 16 kg/cm² 160-16-TL
HPA-13 HDP Pipe 180 16 kg/cm² 180-16-TL
HPA-14 HDP Pipe 200 16 kg/cm² 200-16-TL
HPA-15 HDP Pipe 225 16 kg/cm² 225-16-TL
HPA-16 HDP Pipe 250 16 kg/cm² 250-16-TL
HPA-20 HDP Pipe 50 6 kg/cm² 50-6-TL
HPA-21 HDP Pipe 63 6 kg/cm² 63-6-TL
HPA-22 HDP Pipe 75 6 kg/cm² 75-6-TL
HPA-23 HDP Pipe 90 6 kg/cm² 90-6-TL
HPA-24 HDP Pipe 110 6 kg/cm² 110-6-TL
HPA-25 HDP Pipe 125 6 kg/cm² 125-6-TL
HPA-26 HDP Pipe 140 6 kg/cm² 140-6-TL
HPA-27 HDP Pipe 160 6 kg/cm² 160-6-TL
HPA-28 HDP Pipe 180 6 kg/cm² 180-6-TL
HPA-29 HDP Pipe 200 6 kg/cm² 200-6-TL
HPA-30 HDP Pipe 225 6 kg/cm² 225-6-TL
HPA-31 HDP Pipe 250 6 kg/cm² 250-6-TL
HPA-36 HDP Pipe 32 10 kg/cm² 32-10-TL
HPA-37 HDP Pipe 40 10 kg/cm² 40-10-TL
HPA-38 HDP Pipe 50 10 kg/cm² 50-10-TL
HPA-39 HDP Pipe 63 10 kg/cm² 63-10-TL
HPA-40 HDP Pipe 75 10 kg/cm² 75-10-TL
HPA-41 HDP Pipe 90 10 kg/cm² 90-10-TL
HPA-42 HDP Pipe 110 10 kg/cm² 110-10-TL
HPA-43 HDP Pipe 125 10 kg/cm² 125-10-TL
HPA-44 HDP Pipe 140 10 kg/cm² 140-10-TL
HPA-45 HDP Pipe 160 10 kg/cm² 160-10-TL
HPA-46 HDP Pipe 180 10 kg/cm² 180-10-TL
HPA-47 HDP Pipe 200 10 kg/cm² 200-10-TL
HPA-48 HDP Pipe 225 10 kg/cm² 225-10-TL
HPA-49 HDP Pipe 250 10 kg/cm² 250-10-TL
HPA-50 HDP Pipe 25 12.5 kg/cm² 25-12.5-TL
HPA-51 HDP Pipe 32 12.5 kg/cm² 32-12.5-TL
HPA-52 HDP Pipe 40 12.5 kg/cm² 40-12.5-TL
HPA-53 HDP Pipe 50 12.5 kg/cm² 50-12.5-TL
HPA-54 HDP Pipe 63 12.5 kg/cm² 63-12.5-TL
HPA-55 HDP Pipe 75 12.5 kg/cm² 75-12.5-TL
HPA-56 HDP Pipe 90 12.5 kg/cm² 90-12.5-TL
HPA-57 HDP Pipe 110 12.5 kg/cm² 110-12.5-TL
HPA-58 HDP Pipe 125 12.5 kg/cm² 125-12.5-TL
HPA-59 HDP Pipe 140 12.5 kg/cm² 140-12.5-TL
HPA-60 HDP Pipe 160 12.5 kg/cm² 160-12.5-TL
HPA-61 HDP Pipe 180 12.5 kg/cm² 180-12.5-TL
HPA-62 HDP Pipe 200 12.5 kg/cm² 200-12.5-TL
HPA-63 HDP Pipe 225 12.5 kg/cm² 225-12.5-TL
HPA-64 HDP Pipe 250 12.5 kg/cm² 250-12.5-TL
Distribution Length
SD Code PipeCode Transmission Distribution
15-MC-DL GPM-15 - -
20-MC-DL GPM-20 - -
25-MC-DL GPM-25 - -
32-MC-DL GPM-32 - -
40-MC-DL GPM-40 - -
50-MC-DL GPM-50 - -
65-MC-DL GPM-63 - -
80-MC-DL GPM-80 - -
100-MC-DL GPM-100 - -
15-HC-DL GPH-15 - -
20-HC-DL GPH-20 - -
25-HC-DL GPH-25 - -
32-HC-DL GPH-32 - -
40-HC-DL GPH-40 - -
50-HC-DL GPH-50 - -
65-HC-DL GPH-63 - -
80-HC-DL GPH-80 - -
100-HC-DL GPH-100 - -

20-16-DL HP16-20 - -
25-16-DL HP16-25 - -
32-16-DL HP16-32 - -
40-16-DL HP16-40 - -
50-16-DL HP16-50 - -
63-16-DL HP16-63 - -
75-16-DL HP16-75 - -
90-16-DL HP16-90 - -
110-16-DL HP16-110 - -
125-16-DL HP16-125 - -
140-16-DL HP16-140 - -
160-16-DL HP16-160 - -
180-16-DL HP16-180 - -
200-16-DL HP16-200 - -
225-16-DL HP16-225 - -
250-16-DL HP16-250 - -
50-6-DL HP6-50 - -
63-6-DL HP6-63 - -
75-6-DL HP6-75 - -
90-6-DL HP6-90 - -
110-6-DL HP6-110 - -
125-6-DL HP6-125 - -
140-6-DL HP6-140 - -
160-6-DL HP6-160 - -
180-6-DL HP6-180 - -
200-6-DL HP6-200 - -
225-6-DL HP6-225 - -
250-6-DL HP6-250 - -
32-10-DL HP10-32 840.00 425.00
40-10-DL HP10-40 - -
50-10-DL HP10-50 - -
63-10-DL HP10-63 - -
75-10-DL HP10-75 - -
90-10-DL HP10-90 - -
110-10-DL HP10-110 - -
125-10-DL HP10-125 - -
140-10-DL HP10-140 - -
160-10-DL HP10-160 - -
180-10-DL HP10-180 - -
200-10-DL HP10-200 - -
225-10-DL HP10-225 - -
250-10-DL HP10-250 - -
25-12.5-DL HP12.5-25 - 350.00
32-12.5-DL HP12.5-32 - -
40-12.5-DL HP12.5-40 - -
50-12.5-DL HP12.5-50 - -
63-12.5-DL HP12.5-63 - -
75-12.5-DL HP12.5-75 - -
90-12.5-DL HP12.5-90 - -
110-12.5-DL HP12.5-110 - -
125-12.5-DL HP12.5-125 - -
140-12.5-DL HP12.5-140 - -
160-12.5-DL HP12.5-160 - -
180-12.5-DL HP12.5-180 - -
200-12.5-DL HP12.5-200 - -
225-12.5-DL HP12.5-225 - -
250-12.5-DL HP12.5-250 - -

TOTAL LENGTH 840.00 775.00

HDP Pipe Length 840.00 775.00
GI Pipe Length - -
Total 840.00 775.00

Grand Total 1,615.00

 Salient Features ( Schemewise ) of Project

1 Name of Project CBWSS

2 Name of VDC VDC
3 Wards Covered 8, 9 9
Number of scheme Scheme - 1 Scheme - 2
Khadgadera & Tallo
Name of Scheme Setipokhari Khadgadera
A. Household/Population
1 Households (Survey Year : 2007) No. 61 21
2 Population (Survey Year : 2007) No. 343 118
3 Households (Survey Year : 2008) No. 61 21
4 Population (Survey Year : 2008) No. 355 123
5 Households (Survey Year : 2028) No. 85 29
6 Population (Survey Year : 2028) No. 480 166
7 Design Period Yrs. 20 15
8 Annual growth rate % 1 2
B. Source Information
1 Source Name Lamakhola Lamakhola
2 Source Type & Number Type/No. Stream / 1 Stream / 1
Tapped Discharge source - 1 Lps - -
3 Tapped Discharge source - 2 Lps 0.2 ( Lamakhola )
4 Approximate Distance from Project Site km 1 1
5 Water Quality of Source Good Good
C. Water provision & Demand
1 Provision for Domestic use lpcd 21,600.00 7,470.00
3 Provision for Institutional use lpcd
2 Provision for Live Stock Yes/No No No
3 Total Water Demand (Design Year) Lpd 21,600 7,470
D. Project Components
1 Actual Length of Transmission Main km 3 -
2 Actual Length of Distribution Pipe Line km 2 1
3 Total Number of Public Stand Post No. 13 4
4 Number of Private Connection Provided No. No No
5 Reservoir Number/ Capacity m³ / no 4, 5 m³ x 1 3 m³ x 1
6 Total Number of DC, IC, VC & AVC No. 9.00 1.00
7 Crossing No. 4.00 1.00
8 Number of Institutional Latrine No. 0 0
E. Project Cost Data
1 Total Estimated Cost NRs. 1,517,834 416,267
 2 Average Per Capita Cost at Base Year (E1/A4) NRs. 4276 3384
3 Average Per Capita Cost at Design Year (E1/A6) NRs. 3162 2508
4 Total O/M Cost at Base Year NRs.
5 Total O/M Cost at Design Year NRs.
6 Total O/M Cost per HH per Month NRs.
7 Monthly Household Income NRs.
8 Total O/M Cost as % of Monthly HH Income (E6/E7)*100 %
9 Community Contribution Amount as per Estimate NRs. 241,195 70,552
10 Community Contribution as per % of Estimate % 16 17
11 Number of WUSC Members/VMW No. 9/2 9/2
ewise ) of Project

CBWSS
VDC
8 5, 6 5, 6, 8, 9
Scheme - 3 Scheme - 4 Total
Indredanda Extention of
Rehabilitation Sallikot Scheme

68 84 234
381 471 1313
69 85 236
394 489 1361
95 117 326
533 659 1838
15 15 65
2 2 7

Mangrakhola Mangrakhola
Stream / 2 Stream / 1
- - 0
0.2 ( Lamakhola ) 0.20
1 1 4
Good Good Good

23,985.00 29,655.00 82710

3,500.00 3500
No No No
27,485 29,655 86210

2 1 6
4 2 9
6 6 29
No No No
12 m³ x 1 14 m³ x 1 5
7.00 9.00 26
2.00 2.00 9
1 1 2

1,233,187 #N/A #N/A

 3130 #N/A #N/A
2314 #N/A #N/A
0

0
0
0
315,345 207,171 834263
26 #N/A #N/A
9/2 9/2 0