Problem

Water flows in steady$-$state through a $7-$pipe network. The flow rate of water supplied to the network

and the demands taking water out of the network are shown. What is the flow rate $(Q)$ in each pipe

and the pressure $(P)$ at each node of this system?

Guidance

$($a$)$ Create a balanced, Excel$-$based, Hardy Cross $($HC$)$ distribution model of this network.

$($b$)$ Since this model has two loops, you will need to initially "guess" two flow rates. Your first guess is

for pipe #$2($in $f\frac{t^3}{sec}).$ You may choose the direction of the flow in this pipe, but it must have a

magnitude of:

$Q_2=(\frac{7G}{368,864})-16\mathrm{.}1412$

where: $G=$ your $\frac{G}{M}U$ student ID number without the $"G",$ rounded to two decimal places.

$($c$)$ Your second guess must be for pipe #$7,$ the magnitude is up to you.Ans: $Q_{(1)}=1\mathrm{.}29f\frac{t^3}{sec\text{;}{h}_{L(4)}}=40\mathrm{.}58ft$;$P_{(f)}=185\mathrm{.}7$Pipe Topology

Initial $($guess$)$ flow rate in pipe #$2(Q_2)=f\frac{t^3}{sec}($include sign$)$

$\backslash$table$[[$Pipe$,$Node,$\backslash$table$[[$el$.],[($ft$)]],$Pipe Material,C$,\backslash$table$[[L$