Problem $1$

The loop network shown in Figure $1$ is part of a new development residential areas. The pipe roughness $(k_s)$ is provided by the manufacturer as in Table $1$ along with all pipe properties. Find the flow rate in each pipe and heads in each node using Hardy$-$Cfoss method. Make sure you show your manual calculation for the first trial. The following trials can be shown in an Excel spreadsheet. You must continue the trials until you reach the Start your calculations by assuming an initial estimate of flow into pipe $1$ and pipe $4$ and clearly show the assumptions you make. Use any suitable formula to calculate friction factor $().$ Consider the Viscosity of water $=0\mathrm{.}001N.\frac{s}{m}$ in your calculations. The head at Node A is $96m$ and the elevation of all nodes are the same.

Table $1$: Pipe properties

$\backslash$table$[[$Pipe$,$Length $(m),$Diameter $(mm),K_s(mm)$

I want both answers in detail and i wanI want it urgently please do it fast