Instructions

Develop an Excel spreadsheet to solve the problem set out below. The spreadsheet must show all calculations $($automated$)$ and relevant data sourced and given.

Provide a brief outline$/$ description of how the spreadsheet works such that a fellow student can be able to use it to solve a problem with different pipe sizes and pipe fittings. The description must include all the equations used. The equations must be created using the 'insert equation' in Excel.

Completed Excel document must be submitted through the assignment link on Blackboard. No email submissions will be allowed.

Problem statement

Kerosene at $25C$ is flowing in the system shown in Fig. $1.$ The total length of $49\mathrm{.}8mm$ ID galvanized iron tubing is $30m.$ The two $90$ bends are standard elbows and tank $B$ is open at the top. Calculate the volume flow rate $(\frac{m^3}{s})$ into tank $B$ if a pressure of $150$kPa is maintained above the kerosene in tank $A.$

$1$