Question $2.($Use Excel$)$ Determine flow rates in the branching pipe system depicted in the figure below, given the following water surface $($WS$)$ elevation and pipe data $($lengths and diameters$)$:

$WS1=5,200ftL1=4,000ftD1=3ft$

$WS2=5,170ftL2=2,000ftD2=5ft$

$WS3=5,100ftL3=3,000ftD3=4ft$

All of the pipes are lined ductile iron $($DIP$,e=0\mathrm{.}0004ft)$ and the temperature of the water is $68F.$ Also determine the elevation of the junction $(J)$ if the pressure head $(P\frac{J}{})$ at the junction measured by a piezometer $($height from $J$ to $HJ)$ is $30ft.$

Reservoir I

$wS2=$grad ${?}_{(})$

Pipe $1$

Reservoir $2$

Reservoir $3$

Pipe $3$