ENVE $3001(2024$ FALL$)$ COMPUTER PROJECT Due Date: $07\mathrm{.}01\mathrm{.}2024$ In the scope of this project, a computer program will be written in MS Excel or Visual Basic Application for a flocculent$-$settling type $($Type II$)$ sedimentation unit. There will be two worksheets for $($i$)$ rectangular and $($ii$)$ circular basins at water treatment plant with alum coagulation$-$flocculation system. Inputs: Flowrate Number of tanks W:L ratio $($if rectangular$)$ Effluent Launder width $($If a two$-$sided weir is selected, the distance between the launder and side wall will also be an input$)$ Freeboard above water level Sidewall depth Outputs: Dimensions: Length $($if rectangular$),$ Width $($if rectangular$),$ and Diameter $($if circular$)($The program will allow the user to round up or round down the calculated dimensions. All design parameters will be re$-$checked for these corrected dimensions$)$ Total tank depth Effective volume $($water volume$)$ Total volume Retention time Surface loading Weir type $($e$.$g$.$ one$-$sided, two$-$sided, corrugated$)$ Weir loading Horizontal velocity $($if it is rectangular$)$ The program will check design criteria according to their design ranges. All design ranges must be written next to the design criteria to be calculated with a reference. Additionally, comments about the design criteria must be shown. Example: Surface loading for Q: $...$ m$3/$m$2.$d Range: $...-...$ m$3/$m$2.$d Ref: $...$ Comment: Value is within the range If the calculated value is out of the range, guidance will be required for the programuser and it will be shown on the screen. Please describe $$what to do$$ very well to the program user with this guidance. Example: Surface loading for Q is higher than the design range. Please increase the number of tanks. The program should show units of all criteria and should make the necessary conversion in the formula during calculation. PLEASE MAKE IT ON VBA