VARIABLE MEDIDA UNIDAD H (m) Ks/D hfi (m) v (m/s)
L 500 m 40 7.557437E-06 40 5.1775164
D 0.19848 m 40 7.557437E-06 29.0659191 4.3477483
KS 0.0000015 m 40 7.557437E-06 32.2897563 4.60535787
VISCOSIDAD 0.00000101 m2/s 40 7.557437E-06 31.3490046 4.53145004
DENSIDAD 1000 kg / m3 40 7.557437E-06 31.6244428 4.55319287
Z2 0 40 7.557437E-06 31.5438747 4.54684188
H 40 m 40 7.557437E-06 31.5674482 4.54870089
KM 8 40 7.557437E-06 31.5605514 4.54815707
40 7.557437E-06 31.5625692 4.54831618
40 7.557437E-06 31.5619788 4.54826963
40 7.557437E-06 31.5621515 4.54828325
40 7.557437E-06 31.562101 4.54827927
hfi +1 (m)
29.0659191
32.2897563
31.3490046
31.6244428
31.5438747
31.5674482
31.5605514
31.5625692
31.5619788
31.5621515
31.562101
31.5621158
The Colebrook-White Equation
http://excelcalculations.blogspot.com
Parameters Cell Name
Pipe roughness (m) 0.0001293 e
Pipe Diameter (m) 0.3556 D
Viscosity (Pa s) 0.001007 mu
Density (kg m-3) 1000 rho
Velocity (m s )
-1
4.833 u
Reynolds Number 1706668.123 Re
Method 1 - Using VBA and Goalseek
Turb Friction Factor Check 1.119772E-05 fCheck
Friction Factor 0.015950816 f