$($A$)(10$ points$)$ Prepare a bar chart ON the VBA for the following water analysis given below. What is total

hardness, carbonate hardness, and non$-$carbonate hardness?

$($B$)(10$ points$)M{g}^2$ When the magnesium concentration in raw water is greater than $40m\frac{g}{L}$

as $CaC{O}_3,$ the flow is split to achieve a magnesium hardness of $40m\frac{g}{L}$ as $CaC{O}_3$ in the

effluent. If $M{g}^{2+}$ is $100m\frac{g}{L}$ as $CaC{O}_3$ in raw water, what $\%$ of flow should be bypassed

around the softening reaction tank? The portion of the flow that is treated in the tank is

dosed to achieve the practical solubility limits for $+10m\frac{g}{L}$ as $CaC{O}_3.$