FlowFrictionPower
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
Spreadsheet for determining power available in a river of specfic run and head at various flow rates
2
3
Only Change cells with a blue background.
4
Givens:run63.5ft
5
Ht14.8ft
6
e0.83
7
K5310(gal*ft)/(min*kW)
8
9
Lengths of pipe per fitting (ft)Total length of pipe (ft)
10
QtyComponent1-1/4" 1-1/2" 2"2-1/2"3"4"6"1-1/4" 1-1/2" 2"2-1/2"3"4"6"
11
0903.845.76.97.912180000000
12
0451.82.12.63.145.180000000
13
0Gate Valve0.811.523470000000
14
0T - Run2.32.74.35.16.28.312.50000000
15
0T - Branch781215162232.70000000
16
0Adapter2.83.54.55.56.59140000000
17
00000000
18
0feet of pipe11111110000000
19
Total0000000
20
21
Friction loss per 100' of plastic pipe (ft)Total friction loss (ft)Head Available (Ha in Ft)Power (P in kW)
22
Flow Rate1-1/4" 1-1/2" 2"2-1/2"3"4"6"1-1/4" 1-1/2" 2"2-1/2"3"4"6"1-1/4" 1-1/2" 2"2-1/2"3"4"6"1-1/4" 1-1/2" 2"2-1/2"3"4"6"
23
50.40.20.000.00-----14.8014.80-----0.0120.012-----
24
101.60.70.20.10.000.000.000.00---14.8014.8014.8014.80---0.0230.0230.0230.023---
25
205.62.60.80.30.10.000.000.000.000.00--14.8014.8014.8014.8014.80--0.0460.0460.0460.0460.046--
26
3011.85.61.70.70.20.000.000.000.000.00--14.8014.8014.8014.8014.80--0.0690.0690.0690.0690.069--
27
4020.19.52.81.20.40.10.000.000.000.000.000.00-14.8014.8014.8014.8014.8014.80-0.0930.0930.0930.0930.0930.093-
28
5014.44.31.80.60.2-0.000.000.000.000.00--14.8014.8014.8014.8014.80--0.1160.1160.1160.1160.116-
29
6020.162.50.90.2-0.000.000.000.000.00--14.8014.8014.8014.8014.80--0.1390.1390.1390.1390.139-
30
707.93.31.20.3--0.000.000.000.00---14.8014.8014.8014.80---0.1620.1620.1620.162-
31
8010.24.31.50.4--0.000.000.000.00---14.8014.8014.8014.80---0.1850.1850.1850.185-
32
9012.65.31.90.5--0.000.000.000.00---14.8014.8014.8014.80---0.2080.2080.2080.208-
33
1006.52.30.60.1---0.000.000.000.00---14.8014.8014.8014.80---0.2310.2310.2310.231
34
1259.83.40.90.1---0.000.000.000.00---14.8014.8014.8014.80---0.2890.2890.2890.289
35
1504.81.30.2----0.000.000.00----14.8014.8014.80----0.3470.3470.347
36
---------------------
37
38
Pipe Diameter (inches)
39
GPM1-1/4" 1-1/2" 2"2-1/2"3"4"6"
40
Flow Rate (GPM)5 GPM1212#N/A#N/A#N/A#N/A#N/A
41
10 GPM23232323#N/A#N/A#N/A
42
20 GPM4646464646#N/A#N/A
43
30 GPM6969696969#N/A#N/A
44
40 GPM939393939393#N/A
45
50 GPM#N/A116116116116116#N/A
46
60 GPM#N/A139139139139139#N/A
47
70 GPM#N/A#N/A162162162162#N/A
48
80 GPM#N/A#N/A185185185185#N/A
49
90 GPM#N/A#N/A208208208208#N/A
50
100 GPM#N/A#N/A#N/A231231231231
51
125 GPM#N/A#N/A#N/A289289289289
52
150 GPM#N/A#N/A#N/A#N/A347347347
53
54
See http://www.retscreen.net/ to actually do it!
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
Loading...
 
 
 
For Graphing
Chart1