Instructions:

Please show your calculations $($use excel formula$)$ and answers in this excel file and submit this file by the deadline. Use formula in excel to automate your calculation instead of doing them manually $($which takes time$).$

Problem:

Brgy$.$ Klasmeyt receives tap water from River Malangsa which is contaminated by heavy metals.

Three separate effluents containing heavy metals from a metal processing plant, mining plant and sewage treatment plant join the river at different points.

Besides these industrial effluents, soil containing heavy metals is eroded due to the flow of the river which also contributes to the heavy metal pollution.

But before these mixing points of effluents and before erosion takes place, the flowrate is $30,000\frac{L}{s}$ and is safe to assume concentration of heavy metals in this portion of the river as negligible.

The concentrations of different heavy metals in the three effluents and in the soil being eroded are found in excel tab "Data" together with other necessary information.

Please be sure to check all necessary information enclosed within column $N$ x row $30$ of tab "Data"

Questions:

What is the concentration of the heavy metals before treatment in $m\frac{g}{L}?$ in ppm$?$

Is it safe to drink the water without any treatment according to the PNSDW standard? If not, why? Do you propose that we treat River Malangsa before distributing to the tap water system?

$**$The PNSDW of $2017$ consists of standard concentrations of substances set as the safe limits for drinking water in the Philippines

Assuming a person drinks from the tap without treatment and consumes $4L$ per day, how much metal in grams is accumulated in the human body per year assuming these metals are not excreted?

Note:

Do not open columns$/$rows that are "grouped" and do not change the formula of the cells with the data already given.

You may only write a formula in the cells highlighted in yellow to answer the questions.

$13$Heavy MetalAntimony$15$ArsenicBarium$10$ MercuryCadmium$11$ NickelChromium$12$ SeleniumLeadManganese$14$ Additional Data$2616$ Shape of Flow$3117$ flowCross$-$sectionalDimensions for$18($cm$/$s$)$Flow velocity$19$ Q$(/$s$)$Mass flowrate of$20($kg$/$yr$)$soil being eroded$22($g$/$cm$3)$Density of SoilConcentration of Metal in Industrial Effluents $($Molar$,$ M$)$Metal Processing$2\mathrm{.}46$E$-065\mathrm{.}96$E$-052\mathrm{.}16$E $042\mathrm{.}81$E$-061\mathrm{.}35$E$-031\mathrm{.}25$E$-051\mathrm{.}60$E$-037\mathrm{.}48$E$-072\mathrm{.}62$E$-041\mathrm{.}14$E$-04$Metal Processingcylindrical$30\text{'}$ ID$02$Mining$70$TF$-7$L$\mathrm{.}70$E$-056\mathrm{.}16$E $058\mathrm{.}01$E$-073\mathrm{.}85$E$-043\mathrm{.}57$E$-061\mathrm{.}02$E$-042\mathrm{.}13$E$-075\mathrm{.}11$E$-063\mathrm{.}24$E$-05$Miningrectangular$0\mathrm{.}8$m x $0\mathrm{.}5$m$0\mathrm{.}1527$ average river flow before mixing with effluents and soil erosion$30$ average daily water intake by a human $($L$/$day$)$DWater Treatment$3\mathrm{.}82$E$-024\mathrm{.}00$E$-015\mathrm{.}11$E$+001\mathrm{.}89$E$-02$S$\mathrm{.}09$E$+002\mathrm{.}96$E$-012\mathrm{.}79$E$+011\mathrm{.}77$E$-02\mathrm{.}20$E$+002\mathrm{.}69$E$+00$Water Treatmenttrapezoidal,$=0\mathrm{.}6$m$,$ b$,=0\mathrm{.}8$m$,$h$=0,5$m$0\mathrm{.}130,00048\mathrm{.}6$Concentration of Metal PNSDW MolecularWeight o Concentration of Metal in thein soil being erodedthe Heavy tap Water if not treated $($mg$/)925153000609000\mathrm{.}5850\mathrm{.}4$Soil Erosion$2\mathrm{.}47$G$1\mathrm{.}3$mg$/$L$0\mathrm{.}070\mathrm{.}00\mathrm{.}7$D$\mathrm{.}0030\mathrm{.}050\mathrm{.}01$D$\mathrm{.}0010\mathrm{.}070\mathrm{.}04$Metal$121\mathrm{.}7574\mathrm{.}9216137\mathrm{.}33112\mathrm{.}4151\mathrm{.}996207\mathrm{.}254\mathrm{.}938200\mathrm{.}5958\mathrm{.}778\mathrm{.}96$E$-06$ means x$10^-6$Sha$$e of flow willdetermine how you getthe crosS$-$sectional area offlowN$|$To calculate for the volumetricflowrate of soil erosion, use thedensty of the sol$|$This is needed for the calculation of theconcentration of heavy metals in the finalstream. To calaulate the volumetric flowrate$|$or edc eltued the tow velpcity$($of course observing consistent units$)$Concentration of Metal in thetap water if not treated $($ppm$)$Amount metal ing$/$yearingested by one personif tap water is nottreated$**$The PNSDW of $2017$ consistsof standard concentrations of$|$substances set as the safe limitstor drinking water in thePhilippines$($mg$/$kg$)$