Friction Loss
Sheet1
EXCEL PROGRAM FOR CALCULATING FRICTION LOSS
Q=? 9100 lpm 21097285.2943643
C=? 120 7022.40
D=? 300 mm 1157658621551.85
6.05*100000 605000
(D4.87xC1.85) = 8129537068639834.0
(6.05x105/B13)= 0.00000000007
L=? 114 Mtr
FL= D5xB15xB17 0.178987 Bar ( PF ) PRESSURE LOSS
d=? 0.35 mtr
A=? 0.09619925 m2
V=? m/s 4.330874 15591.1464 m/hr
Q=? 1499.8565903202 m3/hr
24997.5098482306 lpm
d=? 0.2 mtr
Q=? 546 m3/hr
9099.9636 lpm
V=? 4.8278423259 m/sec
V=? 5 m/sec
18000 m/hr
Q=? 135 m3/hr
2249.991 lpm
d=? 0.0095504903
0.0977266098
MM= 97.726609777 mm
3) ISOSCELES RIGHT
1) TRIANGLE
PERIMETER = a+b+c
AREA = 1/2 bh
PERIMETER = 2a+d
AREA = 1/2 a2
Page 1
Sheet1
d= a x sq.root( 2 )
2) RIGHT
PERIMETER = a+b+d 4) EQUILATERAL
AREA = 1/2 ab
d= sq.root( a2 + b2 )
PERIMETER = 3a
AREA = sq.root(3)/4 x a
5) SQUARE h=sq.root(3)/2 x a
PERIMETER = 4a 7) RHOMBUS
AREA = a2
Diagonal=a x sq.root(2)
6) PARALLELOGRAM
PERIMETER = 2(a+b)
AREA = b x h
PERIMETER = 4a
AREA = d1d2 / 2
8) TRAPEZIUM Side a=1/2xsqrt(d
AREA = 1/2 x h ( a + b)
VOLUME OF SOLIDS:
1) CUBOID
SURFACE AREA = 2(lb + bh + lh)
VOLUME = lbh
Length of Diagonal =sq.root(l2+ b2+ h2)
2) CUBE
SURFACE AREA =6l2.
VOLUME = l3.
Length of Diagonal = l x sq.root(3)
3) CYLINDER
AREA =2 rh.
Page 2
Sheet1
Total Surface Area =2 r(r+h).
VOLUME= r2h.
4) CONE
AREA = rl.
Total Surface Area = r(r+l).
VOLUME= 1/3 r2h.
5) Frustum of a Cone
Curved Surface Area = l (R1+R2). ; l2 = H2 + (R2-R1)2.
Total Surface Area = [l (R1+R2)+R12+R22]
VOLUME= 1/3 H (R12+R22+R1R2)
6) Sphere
AREA =4 r2.
VOLUME= 4/3 r3.
7) Hemisphere(solid)
Curved Surface Area =2 r2.
Total Surface Area =3 r2.
Volume = 2/3 r3.
8) Spherical shell
Surface Area(outer) =4 R2.
Volume = 4/3 (R3 - r3).
Page 3
Sheet1
Pe = Pressure due to elevation.
Pe = Elevation diff. X 0.098 bars.
VELOCITY PRESSURE = PV = (0.001123(Q2/D4))PSI
(D)4=(inch) 4 256
Q=(gpm) 333.6 111288.96
124.9775
PV= 0.488193 PSI
D= MM 62.71 2.468898 INCHES
(D)4 = 37.15458
Q=LPM 674.9 31794.14 178.3091
35.70482
PV= 0.067201 BAR 0.96098 PSI
EXAMPLE:
Pf =0.045 Bar.
Pe = -0.147 Bar.
Pt = Pf - Pt
Pt = Pf - Pt
Pt = {0.045 - ( -0.147)}
) ISOSCELES RIGHT
ERIMETER = 2a+d
REA = 1/2 a2
Page 4
Sheet1
= a x sq.root( 2 )
4) EQUILATERAL
ERIMETER = 3a
REA = sq.root(3)/4 x a2
=sq.root(3)/2 x a
RHOMBUS
ERIMETER = 4a
REA = d1d2 / 2
de a=1/2xsqrt(d12 + d22)
Page 5
