About
MANNING - PIPE FLOW CALCULATOR FOR PART FULL PIPES
P_HYD_3E.xls
Version
Date
This spreadsheet carries out hydraulic calculations for pipes flowing part full.
Separate sheets are provided for calculations with Mannings equation and Colebrook-White.
Also calculated are the hydraulic properties of the section,
REVISION NOTES
Page 1
About
Uncategorised software
All Users are responsible for
checking their own calculations.
Page 2
PIPE FLOW CALCULATIONS for PART FULL PIPE using MANNINGS Equation
P_HYD_3E.xls
Uncategorised Software
All Users are responsible for checking
their own calculations
Enter any four valid input parameters into the blue boxed cells.
The other parameters are then calculated.
INPUT
Flow
Qm
25
Diameter
Dm
250
Depth
zm
Slope
Sm
5
Mannings n
Nm
0.011
Energy coefficient
FULL DETAILS
Flow
Velocity
Diameter
Depth
Slope
Mannings N
Equivalent ColbrookeWhite k
Proportional depth
Proportional velocity
Proportional flow
Values as a proportion of pipe full flow values.
[Link]
alphm
Note: Accuracy OK for most engineering uses.
However, result may not be accurate to last dp shown.
STATUS & ERROR LABELS
OK
RESULTS
l/s
mm
mm
m/km
#MACRO? mm
1.06
25.0
#MACRO?
250.0
#MACRO?
5.000E+00
0.0110
#MACRO?
l/s
m/s
mm
mm
m/km
mm (T=15C)
#MACRO?
#MACRO?
0.5031
Pipe area
Flow area
Half angle of flow
Hydraulic radius
Hydraulic depth
Froude number
Depth for max flow
max flow
Pipe full flow
Critical depth
Critical flow
Min critical slope
P_HYD_3E
0.0491
#MACRO?
#MACRO?
#MACRO?
#MACRO?
#MACRO?
203.20
53.5
49.7
#MACRO?
#MACRO?
m2
m2
rad
m
m
mm
l/s
l/s
mm
l/s
(given flow & dia)
(given depth)
4.050 m/km
10/06/2016
ast dp shown.
(given flow & dia)
(given depth)
[Link]
P_HYD_3E
10/06/2016
PIPE FLOW CALCULATIONS for PART FULL PIPE using COLEBROOK-WHITE Equation
P_HYD_3E.xls
Uncategorised Software:
All Users are responsible for checking
their own calculations
Enter any four valid input parameters into the blue boxed cells.
The other parameters are then calculated.
INPUT
Flow
Qc
Diameter
Dc
150
Depth
zc
89
Slope
Sc
3
Roughness k
kc
0.3
Temperature
Energy coeff
FULL DETAILS
Flow
Velocity
Diameter
Depth
Slope
Roughness
Equivalent Manning n
Proportional depth
Proportional velocity
Proportional flow
Values as a proportion of pipe full flow values.
[Link]-White
T
alpha
l/s
mm
mm
m/km
mm
RESULTS
#MACRO? l/s
#MACRO?
#MACRO?
15 C
1.060
#MACRO?
#MACRO?
150.0
89.0
3.000
0.30
#MACRO?
Note: Accuracy OK for most engineering uses.
However, result may not be accurate to last dp shown.
STATUS & ERROR LABELS
#MACRO?
#MACRO?
l/s
m/s
mm
mm
m/km
mm
Pipe area
Flow area
Half angle of flow
Hydraulic radius
Hydraulic depth
Froude number
Depth for max flow
max flow
Pipe full flow
Critical depth
Critical flow
0.5933
#MACRO?
#MACRO?
P_HYD_3E.xls
0.0177
0.0109
1.759
0.0414
0.0741
#MACRO?
#MACRO?
#MACRO?
#MACRO?
#MACRO?
9.0
m2
m2
rad
m
m
mm
l/s
l/s
mm
l/s
(given flow & dia)
(given depth)
10/06/2016
to last dp shown.
(given flow & dia)
(given depth)
[Link]-White
P_HYD_3E.xls
10/06/2016