In the shown intake structure, determine the flow rate in the pipeline as well as the pressure at point B$.$ The pipeline is newly constructed from welded steel; the lengths of the different sections are: L$1=50$ m$,$ L$3=1000$ m$,$ L$4=2400$ m$,$ L$5=600$ m$.$ The diameter of the pipeline is D $=0\mathrm{.}40$ m and the radius of the bends is equal to $4$D$.$ Create a scale drawing placing the total energy line and the hydraulic gradient line on it$.($Solve the exercise using Excel and provide detailed formulas used and the process used at each point.$)$