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

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
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.912187.6811.413.815.82436
12
0451.82.12.63.145.187.28.410.412.41620.432
13
0Gate Valve0.811.52347457.510152035
14
0T - Run2.32.74.35.16.28.312.511.513.521.525.53141.562.5
15
0T - Branch781215162232.70000000
16
0Adapter2.83.54.55.56.5914567090110130180280
17
00000000
18
0feet of pipe1111111400400400400400400400
19
Total486.3504.9540.8571.7607.8685.9845.5
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.21.951.01-----48.0548.99-----0.0360.037-----
24
101.60.70.20.17.783.531.080.57---42.2246.4748.9249.43---0.0640.0700.0740.074---
25
205.62.60.80.30.127.2313.134.331.720.61--22.7736.8745.6748.2849.39--0.0690.1110.1380.1450.149--
26
3011.85.61.70.70.257.3828.279.194.001.22---21.7340.8146.0048.78---0.0980.1840.2080.220--
27
4020.19.52.81.20.40.197.7547.9715.146.862.430.69--2.0334.8643.1447.5749.31--0.0120.2100.2600.2870.297-
28
5014.44.31.80.60.2-72.7123.2510.293.651.37---26.7539.7146.3548.63---0.2010.2990.3490.366-
29
6020.162.50.90.2-101.4832.4514.295.471.37---17.5535.7144.5348.63---0.1590.3230.4030.440-
30
707.93.31.20.3--42.7218.877.292.06---7.2831.1342.7147.94---0.0770.3280.4500.506-
31
8010.24.31.50.4--55.1624.589.122.74----25.4240.8847.26----0.3060.4930.570-
32
9012.65.31.90.5--68.1430.3011.553.43----19.7038.4546.57----0.2670.5210.631-
33
1006.52.30.60.1---37.1613.984.120.85---12.8436.0245.8849.15---0.1930.5430.6910.741
34
1259.83.40.90.1---56.0320.676.170.85----29.3343.8349.15----0.5520.8250.926
35
1504.81.30.2----29.178.921.69----20.8341.0848.31----0.4710.9281.092
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 GPM3637#N/A#N/A#N/A#N/A#N/A
41
10 GPM64707474#N/A#N/A#N/A
42
20 GPM69111138145149#N/A#N/A
43
30 GPM#N/A98184208220#N/A#N/A
44
40 GPM#N/A12210260287297#N/A
45
50 GPM#N/A#N/A201299349366#N/A
46
60 GPM#N/A#N/A159323403440#N/A
47
70 GPM#N/A#N/A77328450506#N/A
48
80 GPM#N/A#N/A#N/A306493570#N/A
49
90 GPM#N/A#N/A#N/A267521631#N/A
50
100 GPM#N/A#N/A#N/A193543691741
51
125 GPM#N/A#N/A#N/A#N/A552825926
52
150 GPM#N/A#N/A#N/A#N/A4719281092
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