Task:

Determine the optimum $($best$)$ pipe and tank combination $($Figure $1)$ to supply drinking water to a community. The optimum combination is the lowest combined pipe and storage cost that does not violate anv rnnetrainte

a$)$ Project Part A:

$[$Total $=5$ marks$]$

Submit the algorithm $($hand$-$sketched or computer generated$)$ for Project Part B on one A$4$ or A$3$ page.

On the page, provide a legend where each variable in the algorithm is described.

b$)$ Project Part B:

$[$Total$=15$ marks$]$

Submit one $(1)$ Excel$$ Macro$-$Enabled Workbook that contains the provided Data worksheet with the given input data. Do not rearrange the data.

Place one Optimise button on the Data worksheet. This button is to call the VBA code that will:

i$.$ Create the worksheet named Balancing storage calculations and compute Pipe supply, $Q(\frac{m^3}{s})$ for each Diameter $(D)$ and Tank volume $(m^3)$ at each hour. The below steps$/$formulae are to be employed:

To calculate Pipe supply, $Q(\frac{m^3}{s})$ :

$4$

Step $1$: Assume Velocity, $v_1(\frac{m}{s})=1$ and Velocity, $v_2(\frac{m}{s})=1$

Step $2$: Calculate Reynolds Number, $Re=\frac{v_1^{**}D}{?}$ v

Step $3$: Calculate pipe headloss coefficient Lambda, $$ using the

Swamee$-$Jain formula $=(\frac{1}{(-2**lo{g}_{10}(\frac{5\mathrm{.}74}{R{e}^{0\mathrm{.}9}}+\frac{K}{3\mathrm{.}7**D}))}{)}^2$

$2$